musiccaps_details (view)
2 rows where musiccaps_aspects contains "groovy bass line", musiccaps_aspects contains "medium fast tempo" and musiccaps_aspects contains "positive"
This data as json, CSV (advanced)
musiccaps_aspects (array) 36 ✖
- groovy bass line · 2 ✖
- instrumental music 2
- medium fast tempo · 2 ✖
- positive · 2 ✖
- adrenaline junkies 1
- adventure 1
- animate vocals 1
- arcade game music 1
- average sound quality 1
- building anticipation 1
- cheer 1
- dance rhythm 1
- energetic 1
- energetic drumming rhythm 1
- entertaining 1
- excited vocals 1
- excitement 1
- fun 1
- groovy bas slime 1
- keyboard harmony 1
- live audience 1
- live performance 1
- mysterious 1
- people cheering 1
- percussive tap dancing 1
- snares riding fast 1
- spirited 1
- steady drumming rhythm 1
- string synth harmony 1
- suspense 1
- tap dancers 1
- the great adventure 1
- various percussion hits 1
- video game soundtrack 1
- whip sounds 1
- youthful 1
musiccaps_names (array) 3 ✖
- Music 2
- Burst, pop 1
- Tap 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 | ||
Mario Party 9 | Bowser Pop | The song is an instrumental. The song is medium fast tempo with keyboard accompaniment, steady drumming rhythm, whopping sounds, strong bass line, and string synth harmony. The song is exciting and suspenseful. The song is a video arcade game soundtrack with average quality audio. | 2013-05-26T00:11:26Z | Red9378 | [122 - 720p HD] Mario Party 9 | Bowser Pop Talk about an inflated ego! The COM was set to Master difficulty. This video was recorded on May 16, 2013. | ["Music", "Burst, pop"] | ["arcade game music", "animate vocals", "average sound quality", "instrumental music", "video game soundtrack", "excitement", "adventure", "suspense", "building anticipation", "fun", "cheer", "positive", "the great adventure", "excited vocals", "mysterious", "whip sounds", "medium fast tempo", "groovy bas slime", "keyboard harmony", "string synth harmony", "groovy bass line", "steady drumming rhythm"] | 1 | tAdNaRRFFXg | 5013 |
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;