musiccaps_details (view)
1 row where musiccaps_aspects contains "instrumental", musiccaps_aspects contains "snare roll" 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 |
---|---|---|---|---|---|---|---|---|---|---|
HEMA | Dennis Ljungqvist vs Anders Linnard | Swordfish 2015 Open Longsword | This amateur recording clip features a snare drum playing a continuous roll. It is like a marching beat. It sounds like a roll made before an important announcement in a kingdom. This is an instrumental clip. There are no voices in this clip. There are no other instruments in this clip. | 2015-11-02T02:39:58Z | ViciouSExorcisT | ~ HEMA tee for pandemic times: https://teespring.com/stay-out-of-melee-range-hema 10 Years of Celebrating Historical European Martial Arts Official event website: http://swordfish.ghfs.se/ While folk around the world celebrated Halloween, renown fighters presented their exquisite historical fencing skills on the best HEMA sparring event in Sweden! This video excerpt shows the open longsword final, fight for 1st place. Enjoy! | ["Timpani", "Percussion"] | ["amateur recording", "snare drum", "marching beat", "no other instruments", "snare roll", "instrumental", "no voices"] | 0 | DueNcVFHI0k | 1517 |
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;