musiccaps_details (view)
2 rows where musiccaps_aspects contains "heavy cymbal crashes" and musiccaps_author = 1
This data as json, CSV (advanced)
musiccaps_aspects (array) 34 ✖
- heavy cymbal crashes · 2 ✖
- instrumental music 2
- adrenaline rush 1
- attitude 1
- bad audio quality 1
- choreography 1
- creeps 1
- dance hits 1
- dance music 1
- dance rhythm 1
- designed to scare 1
- devilish music 1
- drum solo 1
- enegetic 1
- fast drumming rhythm 1
- fast tempo 1
- full of spunk 1
- groovy 1
- horror show 1
- jeepers creeps 1
- medium tempo 1
- percussive bass line 1
- pop dance routine 1
- psychological 1
- rhyming dance 1
- satanic 1
- scary children’s show 1
- scary laugh 1
- soloist 1
- spooky 1
- tempo 1
- twisted 1
- young dancers 1
- youthful 1
musiccaps_names (array) 9 ✖
- Bass drum 1
- Drum 1
- Drum kit 1
- Drum roll 1
- Music 1
- Percussion 1
- Rimshot 1
- Scary music 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 |
---|---|---|---|---|---|---|---|---|---|---|
What music are you into? - Undertale version | The song is an instrumental with a devilish voice laughing. The tempo is fast with a fast paced drumming rhythm with strong cymbal crashes. The song is probably an adult animated show designed to scare. | 2015-12-24T02:11:49Z | JakobTheQuizGuy | I dig ghost music. All rights to Undertale belong to Toby Fox. Buy Undertale here: http://undertale.com/ | ["Music", "Scary music"] | ["scary laugh", "twisted", "psychological", "satanic", "designed to scare", "devilish music", "spooky", "horror show", "creeps", "jeepers creeps", "percussive bass line", "fast tempo", "scary children’s show", "fast drumming rhythm", "heavy cymbal crashes", "instrumental music"] | 1 | 1ArUx6UCxe4 | 245 | |
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;