musiccaps_details (view)
2 rows where musiccaps_aspects contains "harpsichord", musiccaps_author = 9 and musiccaps_names contains "Piano"
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- harpsichord · 2 ✖
- baroque 1
- celeste 1
- classical music 1
- eccentric 1
- funky 1
- instrumental 1
- jazz fusion 1
- live performance 1
- medieval sounding 1
- no singer 1
- organ 1
- piano 1
- rhodes 1
- synth 1
- various instruments 1
musiccaps_names (array) 6 ✖
- Keyboard (musical) 2
- Piano · 2 ✖
- Classical music 1
- Electric piano 1
- Music 1
- Musical instrument 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Cristofori Piano: Sonata K.9 by Domenico Scarlatti | This is the live performance of a classical music piece. The piece is being performed with a harpsichord. It is in the minor key. The piece is medieval sounding. It could fit perfectly in the soundtrack of a historical drama that takes place in the medieval era. | 2013-06-06T22:24:58Z | The Met | Dongsok Shin performs the Sonata in d minor, K.9 by Domenico Scarlatti (1685-1757) on the earliest known surviving piano, made by the instrument's inventor, Bartolomeo Cristofori (1655-1731), in Florence, 1720. Scarlatti's keyboard compositions were performed on both the harpsichord and the early piano. Production support was provided by The Donna and Marvin Schwartz Foundation A production of the Digital Media Department The Metropolitan Museum of Art Produced and Directed by Christopher Noey Edited by Kate Farrell Camera by Kelly Richardson and Jessica Glass Lighting by Ned Hallick Sound Recording and Post-Production Audio by David Raymond Production Coordinator: Stephanie Wuertz Production Assistants: Sarah Cowan, Maureen Coyle Organized by the Department of Musical Instruments J. Kenneth Moore, Frederick P. Rose Curator-in-Charge Jayson Kerr Dobney, Associate Curator and Administrator E. Bradley Strauchen-Scherer, Associate Curator Susana Caldeira, Assistant Conservator Dongsok Shin, keyboard technician Joseph Peknik III, Principal Technician Pamela Summey, Programs Coordinator Marian Eines, Associate for Administration | ["Music", "Musical instrument", "Keyboard (musical)", "Piano", "Classical music"] | ["classical music", "live performance", "baroque", "harpsichord", "medieval sounding"] | 9 | A2WdjyKQ57A | 1060 | |
Tubular Bells by the Brooklyn Organ Synth Orchestra | This is an instrumental jazz fusion piece. Various instruments are played throughout this piece. A wide variety of key instruments such as the piano, the organ, the celeste, the rhodes, the synth and the harpsichord can be heard. The atmosphere is funky and eccentric. A vibrant array of samples can be gathered from this piece, ideally for use in the soundtrack of a goofy cartoon. | 2011-03-04T06:26:26Z | Joseph McGinty | Filmed and Directed by Amy Hobby. Edited by Tony Zajkowski. Over 20 different NYC female keyboardists playing vintage keyboards at Joe McGinty's Carousel Studio in Brooklyn, NY. Available on iTunes! http://itunes.apple.com/us/album/tubular-bells/id398862997 Featuring: Kaia Wong (Mixel Pixel) Kelly Rae Kerwin (Private Income) Natasha Bartolf Joanna Choy (Spray Paint Star) Amy Merril (Mia Riddle) Greta Gertler (The Universal Thump) Supercute! Anna Copa Cabanna Rolyn Hu (True Primes) Sondra Sun-Odeon (Silver Summit) Michi Turner (Crash Diet Crew) Katia Floreska (The Tall Pines) Natalie Weiss (Unicornicopia, Camp Wanatachi) Wendy Ip Alice Cohen Yvette Perez Kelly Vaughn-Kauffman (Winstron Troy) Yvette Perez (H*E*R) Hula Hoop Harlot Melissa-Anne Alix Brown (Golden Triangle) Leah Cary (Girl Crisis) Caitlin Jemison (Queen Of Sibyls) Instruments featured: Hammond M3 Organ Fender Rhodes Oberheim Xpander Dave Smith Instruments Poly Evolver Keyboard Steinway Upright Grand Piano RMI Keyboard Computer Jenco Celeste Baldwin Electric Harpsichord Bebot Magical Musical Thing Thingamagoop Hohner Clavinet D6 Casio CZ-101 Wurlitzer Electric Piano Conn Electric Band ARP 2600 ARP Omni Suzuki Omnichord Yamaha CS-01 Yamaha TX802 Vox Continental Fender Starmaster Farfisa Combo Compact Buzzing Bee Optigan Stylophone Toy Piano 360 Systems Digital Keyboard Hammond Synthesizer Gibson Clavioline Moog Little Phatty MiniMoog Mellotron Mass-Rowe Vibrachime | ["Electric piano", "Keyboard (musical)", "Piano"] | ["jazz fusion", "no singer", "instrumental", "various instruments", "piano", "organ", "celeste", "rhodes", "synth", "harpsichord", "funky", "eccentric"] | 9 | aeujZtBvMFY | 3565 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW musiccaps_details AS select musiccaps.url as video, json_object( 'label', coalesce(videos.title, 'Missing from YouTube'), 'href', musiccaps.url ) as youtube_link, musiccaps.caption as musiccaps_caption, videos.publishedAt as youtube_published, videos.channelTitle as youtube_channel, videos.description as youtube_description, musiccaps.audioset_names as musiccaps_names, musiccaps.aspect_list as musiccaps_aspects, musiccaps.author_id as musiccaps_author, videos.id as youtube_id, musiccaps.rowid as musiccaps_rowid from musiccaps left join videos on musiccaps.ytid = videos.id;