musiccaps_details (view)
2 rows where musiccaps_aspects contains "groovy rhythm" and musiccaps_names contains "Hip hop music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 32 ✖
- groovy rhythm · 2 ✖
- medium tempo 2
- people dancing 2
- strong bass line 2
- animated singing 1
- average audio quality 1
- cheerful 1
- children’s song 1
- clapping rhythm 1
- dance floor 1
- dance party 1
- dj 1
- dj turntable 1
- electronic dance music 1
- energetic 1
- female singer 1
- groovy music 1
- male backup singers 1
- male singer 1
- playful 1
- pop anthem 1
- pop dance hits 1
- pop song 1
- repeated vocal phrases 1
- retro electronica 1
- scratching disc 1
- screaming vocals 1
- spinning discs 1
- steady drumming rhythm 1
- steady rhythm 1
- techno dance music 1
- vocal harmony 1
musiccaps_names (array) 5 ✖
- Hip hop music · 2 ✖
- Music 2
- Rhythm and blues 1
- Scratching (performance technique) 1
- Speech 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Hairless Dancing Nathan : "Cupid Shuffle" | A male singer sings this animated melody with backup singers in vocal harmony. The song is medium tempo with a groovy drum rhythm, clapping percussion and strong bass hits. The song is a pop dance hit with a groovy dance rhythm. | 2014-02-14T03:00:29Z | DancingNathan | Dancing Nathan is a hairless chinese crested who LOVES to chair dance. He was adopted from Bald is Beautiful Hairless & Small Breed Rescue and is quite a character. #dancingnathan #hotmessgilligan #hairlessdog #chinesecrested @dancenekkid #cupidshuffle | ["Music", "Rhythm and blues", "Hip hop music"] | ["male singer", "animated singing", "male backup singers", "dance party", "people dancing", "groovy rhythm", "strong bass line", "clapping rhythm", "steady drumming rhythm", "screaming vocals", "pop dance hits", "children’s song", "pop anthem", "playful", "cheerful", "vocal harmony", "medium tempo", "pop song"] | 1 | 9CJu43AvIds | 982 | |
DJ Shortee - "Watch Out Now" Beatjuggle Routine 2003 | A DJ plays a cool groove with some female vocals. The song is medium tempo with a steady drumming rhythm, scratch disc percussions, and percussive bass line. The song is exciting and groovy. The audio quality is average. | 2006-08-07T01:33:25Z | DJ Shortee | Turntablist beat juggle routine performed by Shortee in 2003 with the Beatnuts' song "Watch Out Now". Featured on "Shortee's DJ 202" Instructional DVD available on www.how2dj.com. Learn more about shortee at www.djshortee.com! | ["Scratching (performance technique)", "Music", "Speech", "Hip hop music"] | ["dj", "female singer", "repeated vocal phrases", "techno dance music", "average audio quality", "groovy music", "dj turntable", "spinning discs", "scratching disc", "energetic", "groovy rhythm", "strong bass line", "steady rhythm", "medium tempo", "people dancing", "retro electronica", "electronic dance music", "dance floor"] | 1 | J0t4VMnXDNM | 1960 |
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;