musiccaps_details (view)
2 rows where musiccaps_aspects contains "groovy", musiccaps_aspects contains "soloist" and musiccaps_aspects contains "youthful"
This data as json, CSV (advanced)
musiccaps_aspects (array) 34 ✖
- groovy · 2 ✖
- medium tempo 2
- soloist · 2 ✖
- youthful · 2 ✖
- adrenaline rush 1
- attitude 1
- bad audio quality 1
- choreography 1
- dance hits 1
- dance music 1
- dance rhythm 1
- drum solo 1
- electric guitar lead 1
- emotional 1
- enegetic 1
- energetic 1
- full of spunk 1
- guitar a 1
- guitar technique 1
- heavy cymbal crashes 1
- home video 1
- instrumental music 1
- no other instrumentation 1
- no percussions 1
- note bending 1
- playing rhythm guitar 1
- plification 1
- poor quality video 1
- pop dance routine 1
- rhyming dance 1
- solo guitarist 1
- spirited 1
- tempo 1
- young dancers 1
musiccaps_names (array) 12 ✖
- Bass drum 1
- Distortion 1
- Drum 1
- Drum kit 1
- Drum roll 1
- Electric guitar 1
- Guitar 1
- Music 1
- Percussion 1
- Rimshot 1
- Snare drum 1
- Tapping (guitar technique) 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 | |
ギター レスポールを弾いてみた | The song is an instrumental guitar solo. The song tempo is medium with a racy electric guitar solo with a show of technique of note bending, tremolo and playing rhythmically. The song is home video and an average quality recording. | 2013-05-08T08:11:45Z | RDRGuitarBass | エレキギター RDRを弾いてみた | ["Tapping (guitar technique)", "Electric guitar", "Guitar", "Music", "Distortion"] | ["electric guitar lead", "note bending", "playing rhythm guitar", "solo guitarist", "soloist", "no other instrumentation", "no percussions", "home video", "poor quality video", "guitar technique", "guitar a", "plification", "medium tempo", "spirited", "emotional", "youthful", "groovy", "energetic"] | 1 | 7V0G65FK2VQ | 850 |
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;