musiccaps_details (view)
2 rows where musiccaps_aspects contains "jazz music" and musiccaps_names contains "Tap"
This data as json, CSV (advanced)
musiccaps_aspects (array) 26 ✖
- jazz music · 2 ✖
- acoustic drums 1
- amateur recording 1
- amateur tap dancing 1
- amateur tapping tones 1
- ambient room noises 1
- brass section 1
- dance lessons 1
- dance rhythm 1
- instrumental music 1
- jolly 1
- lively 1
- medium tempo 1
- memdiumm tempo 1
- no other instrumentation 1
- old recording 1
- out of sync tapping rhythm 1
- people talking 1
- piano 1
- piano accompaniment 1
- poor audio quality 1
- rap dancers 1
- shoes 1
- tap dancing 1
- upbeat 1
- upright bass 1
youtube_published (date) 2 ✖
- 2006-12-24 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 DANCING CONTEST | This is a jazz music piece used as an accompaniment for a tap dancing contest. It is an old recording. There is a brass section and a piano that are playing the melody while the upright bass is playing a simple bass line. The rhythmic background consists of acoustic drums and the tapping of the shoes to the ground. There is a lively atmosphere. This piece is used in the background of comedic social media content or advertisement jingles. | 2006-12-24T05:40:32Z | DCLAQUETTE | From a short. A collegiate contest. The other side could have had Eleanor Powell--no matter, she would have sucked. Partisanship at its worst--but, what the hell, it's fiction. | ["Music", "Tap"] | ["jazz music", "tap dancing", "shoes", "brass section", "piano", "upright bass", "acoustic drums", "lively", "jolly", "upbeat", "old recording"] | 9 | BjIksWR4oKw | 1282 | |
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;