musiccaps_details (view)
1 row where musiccaps_aspects contains "adrenaline rush", musiccaps_aspects contains "attitude" and musiccaps_names contains "Rimshot"
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- adrenaline rush · 1 ✖
- attitude · 1 ✖
- bad audio quality 1
- choreography 1
- dance hits 1
- dance music 1
- dance rhythm 1
- drum solo 1
- enegetic 1
- full of spunk 1
- groovy 1
- heavy cymbal crashes 1
- instrumental music 1
- medium tempo 1
- pop dance routine 1
- rhyming dance 1
- soloist 1
- tempo 1
- young dancers 1
- youthful 1
musiccaps_names (array) 7 ✖
- Bass drum 1
- Drum 1
- Drum kit 1
- Drum roll 1
- Percussion 1
- Rimshot · 1 ✖
- Snare drum 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Hyorin (SISTAR) - 미니스커트 (dance practice) DVhd | The song is an instrumental. The tempo is medium, featuring a drum solo with no other instrumentation, featuring a lot of stops, cymbals crashes and drum rolls. The song serves as a dance track for a group of dancers. The audio quality is deteriorated and generally poor. | 2011-07-03T16:03:44Z | Joshiii | DVhd CREATIONS (kpop compilations) KPop Final Omen - http://www.youtube.com/watch?v=Qf9sys83DDM Empty KPop - http://www.youtube.com/watch?v=tbBhgXw1xXM Checkout my channel for more Dance Versions and Dance Rehearsals... enjoy :) SUBSCRIBE!!! | ["Drum", "Drum kit", "Drum roll", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["bad audio quality", "instrumental music", "enegetic", "youthful", "dance rhythm", "choreography", "young dancers", "youthful", "full of spunk", "attitude", "adrenaline rush", "pop dance routine", "medium tempo", "groovy", "heavy cymbal crashes", "dance music", "drum solo", "rhyming dance", "dance hits", "soloist", "tempo"] | 1 | 2gvyOxKuQPY | 397 |
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;