musiccaps_details (view)
4 rows where musiccaps_aspects contains "amateur recording", musiccaps_aspects contains "medium tempo" and musiccaps_names contains "Drum"
This data as json, CSV (advanced)
musiccaps_aspects (array) 30 ✖
- amateur recording · 4 ✖
- medium tempo · 4 ✖
- percussion 2
- background voices 1
- backing track 1
- bad audio quality 1
- cheerful 1
- chimes 1
- dance rhythm 1
- drum solo 1
- drums maestro 1
- echoes 1
- energetic 1
- exciting 1
- exemplary stick work 1
- flutes 1
- gripping experience 1
- groovy rhythm 1
- impressive playing 1
- instrumental music 1
- live audience 1
- live performance 1
- male voice speaking 1
- marching band 1
- pop 1
- pulsating experience 1
- retro drum hits 1
- syncopated rhythms 1
- synth pad 1
- tablas 1
musiccaps_names (array) 10 ✖
- Drum · 4 ✖
- Percussion 4
- Bass drum 2
- Snare drum 2
- Cowbell 1
- Drum kit 1
- Drum roll 1
- Rimshot 1
- Tabla 1
- Wood block 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Zaroori Tha by Shiv | Someone is playing a simple groove on tablas. In the background you can hear a backing track playing a flute melody along with synth pads, shaker/chime sounds and a tambourine. This song may be playing practicing tablas at home. | 2014-09-12T22:13:26Z | Nitin Parekh | Tabla beats | ["Tabla", "Drum", "Percussion"] | ["amateur recording", "pop", "backing track", "synth pad", "flutes", "chimes", "tablas", "medium tempo"] | 6 | 0AhX-ReXovI | 131 | |
traditional Bassa gospel song | This audio contains someone playing a snare like instrument with a flat sounding kick. The snare hits are complex and fast. There is some reverb involved in the recording. This is an amateur recording. This may be playing in a traditional entry for a song. | 2016-02-26T02:09:21Z | Weedeh Menyongai | must watch by Bishmen | ["Wood block", "Drum", "Percussion"] | ["amateur recording", "percussion", "medium tempo"] | 6 | 0hw_BB4QN34 | 200 | |
VSU vs ECSC PERCUSSION BATTLE 2012 | This recording contains a marching band playing kick sounds, fast snare rolls and cymbal hits. In the background you can hear people talking and cheering. A male voice is speaking as if making an announcement. This may be playing during a cultural event. | 2012-10-08T18:45:27Z | juankiki25 | FOOTAGE BY DELVALLE | ["Drum", "Drum roll", "Snare drum", "Bass drum", "Percussion"] | ["amateur recording", "marching band", "percussion", "male voice speaking", "background voices", "medium tempo", "cheerful"] | 6 | Qy77eJc72UQ | 2652 | |
Drums Steve Gadd Cowbell.wmv | The song is an instrumental. The tempo is medium with a maestro percussionist performing a solo drum solo in front of a live audience. The song is exciting and gripping. The audio quality is poor. | 2008-12-16T11:27:34Z | bestdrumvideos | Drums Steve Gadd | ["Cowbell", "Drum", "Drum kit", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["drum solo", "live performance", "live audience", "gripping experience", "instrumental music", "echoes", "syncopated rhythms", "drums maestro", "impressive playing", "energetic", "medium tempo", "groovy rhythm", "bad audio quality", "amateur recording", "exciting", "pulsating experience", "exemplary stick work", "retro drum hits", "dance rhythm"] | 1 | nrj2zTr7U0o | 4584 |
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;