musiccaps_details (view)
1 row where musiccaps_aspects contains "latin jazz", musiccaps_aspects contains "passionate female vocal" and musiccaps_aspects contains "subtle hi hats"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Primavera Latin Jazz Band - Sampler | The Latin Jazz song features an exotic, jazzy piano melody, plucked double bass, subtle hi hats and percussive wooden elements playing as the passionate female vocalist is singing. It sounds like it was recorded with stereo room microphones, since the vocal sounds a bit "roomy". | 2013-06-25T02:26:45Z | primaveralatinjazz | Primavera Latin Jazz Band performs live at The JazzSchool in Berkeley, California on May 26, 2013. Samples of songs played during the concert. Featuring: Ana Nitmar (vocals), Dave Casini (vibes), Jane Lenoir (flute), Lena Johnson (piano), Jeff McNish (guitar), David Pinto (bass), Glen Iwaoka (drums), Al Standford (percussion) | ["Music", "A capella"] | ["latin jazz", "low quality", "passionate female vocal", "exotic piano melody", "subtle hi hats", "percussive wooden elements", "plucked double bass", "reverberant"] | 4 | zYUZEXCE7gw | 5490 |
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;