musiccaps_details (view)
2 rows where musiccaps_aspects contains "adrenaline rush", musiccaps_aspects contains "medium tempo" and musiccaps_aspects contains "soloist"
This data as json, CSV (advanced)
musiccaps_aspects (array) 38 ✖
- adrenaline rush · 2 ✖
- medium tempo · 2 ✖
- soloist · 2 ✖
- attitude 1
- bad audio quality 1
- choreography 1
- d]steady drumming rhythm 1
- dance hits 1
- dance music 1
- dance rhythm 1
- dreamy 1
- drum solo 1
- emotional 1
- enegetic 1
- full of spunk 1
- groovy 1
- groovy music 1
- guitar skills 1
- guitar solo 1
- heavy cymbal crashes 1
- high on adrenaline 1
- instrumental hits 1
- instrumental music 1
- keybiard harmony 1
- keyboard harmony 1
- pop dance routine 1
- retro guitar hits 1
- rhyming dance 1
- rock guitar solo 1
- rock guitarist 1
- steady percussion rhythm 1
- string section accompaniment 1
- tempo 1
- tremolo 1
- vibrato 1
- whammy bar 1
- young dancers 1
- youthful 1
musiccaps_names (array) 12 ✖
- Bass drum 1
- Drum 1
- Drum kit 1
- Drum roll 1
- Guitar 1
- Music 1
- Musical instrument 1
- Percussion 1
- Plucked string instrument 1
- Rimshot 1
- Snare drum 1
- Steel guitar, slide guitar 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 | |
Whammy Bar Phrasing Solo | The song is an instrumental. The tempo is medium with an electric guitar playing a dreamy solo with a keyboard accompaniment , string section harmony and rhythmic percussion rhythm. The song is passionate and emotional. The song is a rock guitar instrumental. | 2011-02-03T00:16:18Z | gmcguitar | Breathtaking solo by Piotr Kaczor with tabs and slow illustrations, more: http://www.guitarmasterclass.net/s/youtube-piotr-whammy-bar-2/ls/Whammy-Bar-Phrasing-II/ More Piotr lessons: http://www.guitarmasterclass.net/s/youtube-piotr-whammy-bar-2/instructor/Piotr-Kaczor/ | ["Guitar", "Music", "Musical instrument", "Steel guitar, slide guitar", "Plucked string instrument"] | ["guitar solo", "whammy bar", "keyboard harmony", "steady percussion rhythm", "tremolo", "vibrato", "guitar skills", "rock guitar solo", "dreamy", "emotional", "adrenaline rush", "retro guitar hits", "instrumental hits", "high on adrenaline", "string section accompaniment", "rock guitarist", "soloist", "keybiard harmony", "steady percussion rhythm", "d]steady drumming rhythm", "groovy music", "medium tempo"] | 1 | BqIZipifARo | 1294 |
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;