musiccaps_details (view)
2 rows where musiccaps_aspects contains "dance party" and musiccaps_aspects contains "steady drumming rhythm" sorted by musiccaps_caption
This data as json, CSV (advanced)
musiccaps_aspects (array) 28 ✖
- dance party · 2 ✖
- people dancing 2
- steady drumming rhythm · 2 ✖
- animated singing 1
- cheerful 1
- children’s song 1
- clapping rhythm 1
- groovy bass line 1
- groovy rhythm 1
- guitar accompaniment 1
- keyboard accompaniment 1
- male backup singers 1
- male singer 1
- male singer backup singers 1
- medium tempo 1
- playful 1
- poor audio quality 1
- pop anthem 1
- pop dance hits 1
- pop song 1
- rapping vocals 1
- reggae music 1
- retro reggae 1
- screaming vocals 1
- strong bass line 1
- sway to the music 1
- tropical dance party 1
- vocal harmony 1
musiccaps_names (array) 5 ✖
- Music 2
- Electronic music 1
- Hip hop music 1
- Rhythm and blues 1
- Ska 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 | |
Best Dancehall of the 90's part 1 | A male singer sings this melody with a backup singer singing rapping vocals. The song is medium tempo, with a steady drumming rhythm, groovy bass line and keyboard accompaniment. The song is groovy and exciting. The song is a retro reggae song but has a poor audio quality. | 2008-11-02T05:58:19Z | Jason | Best Dancehall of the 90's part 1 Add me on Facebook... Dj-Mix Vybz Catch My live broadcast every Wednesday night at www.284radio.com from 8-11 Subscribe and check out the rest of my vids | ["Electronic music", "Music", "Ska"] | ["poor audio quality", "reggae music", "groovy bass line", "sway to the music", "dance party", "steady drumming rhythm", "guitar accompaniment", "people dancing", "tropical dance party", "rapping vocals", "retro reggae", "keyboard accompaniment", "male singer backup singers"] | 1 | p28jmA01BHo | 4679 |
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;