musiccaps_details (view)
2 rows where musiccaps_aspects contains "fast tempo", musiccaps_author = 6 and musiccaps_names contains "Saxophone"
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 |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Introduction et variations sur une ronde populaire, Henri Pierné | This audio contains people playing saxophones in all ranges and with a fast melody. This song may be playing as part of an orchestral performance. | 2011-02-27T00:37:25Z | MichiganSaxStudio | Introduction et variations sur une ronde populaire, Henri Pierné Performance by Echo Saxophone Quartet: Spring 2010 Students of Donald Sinta Dan Graser (2nd year Doctoral at time of recording) Katherine Weintraub (Senior at time of recording) Chris Bartz (2nd year Masters at time of recording) Andy Hall (1st year Masters at time of recording) | ["Brass instrument", "Clarinet", "Saxophone"] | ["amateur recording", "orchestral", "saxophones", "fast tempo", "classical"] | 6 | v5SsASLy2c8 | 5154 |
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;