musiccaps_details (view)
1 row where musiccaps_aspects contains "amateur audio", musiccaps_aspects contains "trumpets" and musiccaps_author = 0
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 |
---|---|---|---|---|---|---|---|---|---|---|
Hard Rock Blues | This amateur recording features trumpets playing the main melody. This is accompanied by the bass drum playing one beat on alternate counts and two beats on the remaining alternate counts. Hand claps are played on alternate counts. Other instruments are not audible due to the low audio quality. | 2009-01-21T02:15:23Z | imamousecp | This is a school concert I had in my beginning year of Band. I am the Trombone player that you can clearly see when all of the trombone players stand up. I am sorry if you are offended at how bad we are. I know... we suck. | ["Orchestra"] | ["amateur audio", "low quality audio", "hand claps", "trumpets", "bass drum", "moderate tempo", "orchestra song"] | 0 | X1KJfb5xhr4 | 3157 |
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;