musiccaps_details (view)
2 rows where musiccaps_aspects contains "no voices" and musiccaps_aspects contains "snare drum"
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 | |
Kingaroy SHS Concert Band 'Pirates of the Caribbean' 2006 | This symphonic song features the string section and brass section playing the main melody. The instruments are playing different parts in harmony. At the beginning, the instruments play a two note descending sequence in which the second note is allowed to ring. Then one note is played and allowed to sustain for six counts followed by a bass note that is played for the remaining counts. A snare plays a pattern during this last sustain. A cymbal is also played at the end of this phrase. There are no voices in this song. This is an instrumental song. This song can be played in a movie about a voyage. | 2008-08-22T09:50:21Z | MusoMaestro | Concert Band 2006 Festival of Music Conducted by Julianne Schick | ["Orchestra"] | ["symphonic song", "orchestral song", "snare drum", "string section", "brass section", "cymbals", "moderate tempo", "no voices", "instrumental"] | 0 | lTAfSpsyTSI | 4400 |
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;