musiccaps_details (view)
2 rows where musiccaps_aspects contains "amateur recording" and musiccaps_aspects contains "dance rhythm" sorted by video
This data as json, CSV (advanced)
musiccaps_aspects (array) 31 ✖
- amateur recording · 2 ✖
- dance rhythm · 2 ✖
- instrumental music 2
- medium tempo 2
- amateur tap dancing 1
- amateur tapping tones 1
- ambient room noises 1
- bad audio quality 1
- dance lessons 1
- drum solo 1
- drums maestro 1
- echoes 1
- energetic 1
- exciting 1
- exemplary stick work 1
- gripping experience 1
- groovy rhythm 1
- impressive playing 1
- jazz music 1
- live audience 1
- live performance 1
- memdiumm tempo 1
- no other instrumentation 1
- out of sync tapping rhythm 1
- people talking 1
- piano accompaniment 1
- poor audio quality 1
- pulsating experience 1
- rap dancers 1
- retro drum hits 1
- syncopated rhythms 1
musiccaps_names (array) 9 ✖
- Bass drum 1
- Cowbell 1
- Drum 1
- Drum kit 1
- Music 1
- Percussion 1
- Rimshot 1
- Snare drum 1
- Tap 1
video ▼ | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
42nd street tap dance! | The song is instrumental. The tempo is medium with a piano playing solo accompaniment with no other instrumentation. Tap dancers tap to the piano accompaniment not perfectly in sync , with a lot of ambient room noises and people talking. The audio quality is very poor in this home video. | 2010-02-25T02:39:37Z | n3v3rb33ndone3 | classic tap dance to broadway's 42nd street.. Done by dancers at mary ann's dance studio | ["Music", "Tap"] | ["instrumental music", "poor audio quality", "rap dancers", "medium tempo", "amateur tapping tones", "piano accompaniment", "no other instrumentation", "jazz music", "amateur tap dancing", "ambient room noises", "people talking", "memdiumm tempo", "out of sync tapping rhythm", "dance rhythm", "dance lessons", "amateur recording", "instrumental music"] | 1 | pG6yeC3yUY4 | 4693 |
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;