musiccaps_details (view)
1 row where musiccaps_names contains "Pizzicato" and youtube_description = "James Farm featuring Joshua Redman, Aaron Parks, Matt Penman, and Eric Harland, at the Jazz Standard, June 2011 Produced by Jennifer Kessler, James Sapione, and Stuart Schulzke"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 8 ✖
- acoustic drums 1
- acoustic piano 1
- amateur recording 1
- calm 1
- fast tempo 1
- jazz 1
- saxophone 1
- upright bass 1
musiccaps_names (array) 5 ✖
- Bowed string instrument 1
- Brass instrument 1
- Cello 1
- Pizzicato · 1 ✖
- Saxophone 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
James Farm, Chronos.mp4 | This song contains a fast and silent jazz drum rhythm with a fast groove on the ride. Someone is playing an arpeggio melody on an acoustic piano in the midrange, adding a little melody on top being played in the upper register. A upright bass is playing a walking bassline. A saxophone is playing the main melody. This song may be playing live as a concert. | 2012-03-23T03:37:24Z | Jennifer Kessler | James Farm featuring Joshua Redman, Aaron Parks, Matt Penman, and Eric Harland, at the Jazz Standard, June 2011 Produced by Jennifer Kessler, James Sapione, and Stuart Schulzke | ["Brass instrument", "Cello", "Saxophone", "Pizzicato", "Bowed string instrument"] | ["jazz", "amateur recording", "upright bass", "acoustic drums", "acoustic piano", "saxophone", "fast tempo", "calm"] | 6 | kdxW11WBlQE | 4337 |
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;