musiccaps_details (view)
1 row where musiccaps_aspects contains "eccentric", musiccaps_aspects contains "jazz fusion" and musiccaps_names contains "Electric piano"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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;