musiccaps_details (view)
3 rows where musiccaps_aspects contains "dance club", musiccaps_aspects contains "groovy bass line" and musiccaps_aspects contains "techno dance music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 45 ✖
- dance club · 3 ✖
- dance floor 3
- dj 3
- groovy bass line · 3 ✖
- techno dance music · 3 ✖
- ambient room noise 1
- cheerful 1
- cymbal crashes 1
- cymbals crashing loud 1
- dance all night 1
- dance hits 1
- dance music 1
- dance party 1
- dance rhythm 1
- disc scratching tones 1
- discotheque 1
- electronic dance music 1
- energetic 1
- female backup singer 1
- instrumental music 1
- instrumental music 1
- keybiard harmony 1
- keyboard accompaniment 1
- keyboard harmony 1
- keyboard tones 1
- live performance 1
- make vocals 1
- medium tempo 1
- night party 1
- party night 1
- people dance 1
- people dancing 1
- percussion hits 1
- piano accompaniment 1
- poor audio quality 1
- rap vocals 1
- retro dance 1
- steady drumming rhythm 1
- steady rhythm 1
- steady techno drumming rhythm 1
- techno dance club 1
- teenage romance 1
- teenagers dancing 1
- underground music 1
- youthful 1
musiccaps_names (array) 12 ✖
- Music 3
- Dance music 1
- Disco 1
- Drum and bass 1
- Drum machine 1
- Dubstep 1
- Electronic dance music 1
- Electronica 1
- Music of Latin America 1
- Sampler 1
- Tambourine 1
- Techno 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Spliff Boy (N.B.T. Sound System) -Still In Da Place- (Trust In Records 01) | The song is an instrumental. The song is medium tempo with a steady drumming rhythm, cymbal crashes, groovy bass line and various percussion hits. The song is youthful and energetic. The song has an average audio quality. | 2013-03-24T22:46:29Z | KireKet | track A1 taken from N.B.T. Sound System "Trust In Records 01" (2009)...enJOY!!! | ["Sampler", "Drum and bass", "Music", "Drum machine", "Electronica"] | ["instrumental music", "techno dance music", "underground music", "cheerful", "teenagers dancing", "retro dance", "cymbal crashes", "steady drumming rhythm", "instrumental music", "dj", "keyboard tones", "discotheque", "dance floor", "dance club", "dance all night", "party night", "groovy bass line", "keyboard accompaniment"] | 1 | 6cQjwXNY4sc | 772 | |
ZATURNO ESPACIAL EN COPIAPO IMPERIO PUB 2011 WARRIOR SOUND SYSTEM | A male singer sings this cool melody with backup female singers in vocal harmony. The song is medium tempo with a groovy rhythm, steady drumming rhythm, disc scratching tones, and piano accompaniment. The song is groovy and has a dance rhythm. The song has poor audio quality. | 2011-01-26T05:25:14Z | HEISGRAFF | WARRIOR SOUND SYSTEM PRESENTA EN IMPERIO PUB A ZATURNO ESPACIAL | ["Music", "Tambourine", "Music of Latin America"] | ["techno dance music", "groovy bass line", "dance club", "dance floor", "people dance", "disc scratching tones", "dj", "techno dance club", "make vocals", "rap vocals", "dance music", "live performance", "female backup singer", "piano accompaniment", "ambient room noise", "poor audio quality", "groovy bass line", "dance rhythm", "steady techno drumming rhythm"] | 1 | 8pc8fjPIV-Q | 950 | |
Invisible Sounds vs Daniel Licht - Dexter | The song is instrumental. The song is medium tempo with a groovy bass line, keyboard harmony, various percussion hits and a steady drumming rhythm. The song has a dance rhythm and is exciting. | 2009-01-05T17:53:42Z | Perry12344 | Bootleg remix on one of track from OST "Dexter" from Showtime... original track produced by Daniel Licht | ["Disco", "Music", "Techno", "Dubstep", "Electronic dance music", "Dance music"] | ["techno dance music", "electronic dance music", "cymbals crashing loud", "percussion hits", "keyboard harmony", "dance party", "dance club", "dance floor", "electronic dance music", "youthful", "energetic", "teenage romance", "dance hits", "steady rhythm", "medium tempo", "keybiard harmony", "groovy bass line", "people dancing", "dj", "night party"] | 1 | ClK_qf_Twm8 | 1399 |
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;