musiccaps_details (view)
2 rows where musiccaps_aspects contains "entertaining", musiccaps_aspects contains "live performance" and musiccaps_aspects contains "positive"
This data as json, CSV (advanced)
musiccaps_aspects (array) 36 ✖
- entertaining · 2 ✖
- live performance · 2 ✖
- positive · 2 ✖
- adrenaline junkies 1
- adrenaline rush 1
- amateur musician 1
- ambient room noises 1
- crowds cheering 1
- dance rhythm 1
- energetic 1
- energetic drumming rhythm 1
- fast tempo 1
- fats tempo 1
- funny 1
- funny video 1
- groovy bass line 1
- guitar accompaniment 1
- instrumental music 1
- joyful cheerful 1
- keyboard accompaniment 1
- live audience 1
- male singer 1
- medium fast tempo 1
- people cheering 1
- people screaming 1
- percussive tap dancing 1
- poor audio quality 1
- show tune 1
- snares riding fast 1
- spirited 1
- strong drumming rhythm 1
- tambourine man 1
- tambourine percussions 1
- tap dancers 1
- various percussion hits 1
- youthful 1
musiccaps_names (array) 3 ✖
- Music 2
- Tambourine 1
- Tap 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Tambourine Master Transforms Into Super Gonzo! | Asia’s Got Talent Semis 1 | The song is an instrumental track for a live performance act. The song is medium tempo with a male singer singing to a strong drumming rhythm, groovy bass line, keyboard accompaniment along with an amateur playing tambourine percussion. The song has poor audio quality. | 2015-04-16T13:52:34Z | Asia's Got Talent | It’s a bird, it’s a plane….no, no, it’s: SUPER GONZO! Watch the tambourine master transform and shake his tambourine for world peace! | ["Music", "Tambourine"] | ["live performance", "tambourine man", "fast tempo", "poor audio quality", "funny video", "crowds cheering", "ambient room noises", "people screaming", "amateur musician", "joyful cheerful", "positive", "funny", "entertaining", "adrenaline rush", "male singer", "fats tempo", "strong drumming rhythm", "guitar accompaniment", "keyboard accompaniment", "show tune", "tambourine percussions"] | 1 | fer_4HvG3aY | 3967 | |
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 |
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;