musiccaps_details (view)
2 rows where musiccaps_aspects contains "dance rhythm" and musiccaps_names contains "Tap"
This data as json, CSV (advanced)
musiccaps_aspects (array) 32 ✖
- dance rhythm · 2 ✖
- instrumental music 2
- adrenaline junkies 1
- amateur recording 1
- amateur tap dancing 1
- amateur tapping tones 1
- ambient room noises 1
- dance lessons 1
- energetic 1
- energetic drumming rhythm 1
- entertaining 1
- groovy bass line 1
- jazz music 1
- live audience 1
- live performance 1
- medium fast tempo 1
- medium tempo 1
- memdiumm tempo 1
- no other instrumentation 1
- out of sync tapping rhythm 1
- people cheering 1
- people talking 1
- percussive tap dancing 1
- piano accompaniment 1
- poor audio quality 1
- positive 1
- rap dancers 1
- snares riding fast 1
- spirited 1
- tap dancers 1
- various percussion hits 1
- youthful 1
youtube_published (date) 2 ✖
- 2009-07-26 1
- 2010-02-25 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Tap Dogs I Beams | The song is an instrumental. The song is medium fast tempo with a groovy bass line, energetic drumming, and tap dancers in a percussive groove. The song is entertaining and energetic. | 2009-07-26T17:06:46Z | Tap Dogs Official | ["Music", "Tap"] | ["tap dancers", "percussive tap dancing", "adrenaline junkies", "live audience", "live performance", "instrumental music", "groovy bass line", "people cheering", "energetic drumming rhythm", "medium fast tempo", "various percussion hits", "snares riding fast", "entertaining", "energetic", "positive", "spirited", "youthful", "dance rhythm"] | 1 | oRUdvu3Qo-E | 4628 | ||
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;