musiccaps_details (view)
4 rows where musiccaps_aspects contains "discotheque" and musiccaps_author = 1
This data as json, CSV (advanced)
musiccaps_aspects (array) 66 ✖
- discotheque · 4 ✖
- dance club 3
- medium tempo 3
- steady drumming rhythm 3
- dance floor 2
- dance music 2
- dance rhythm 2
- dj 2
- emotional 2
- energetic 2
- groovy bass line 2
- groovy music 2
- passionate 2
- people dancing 2
- underground music 2
- youthful 2
- all night party 1
- ambient noises 1
- cheerful 1
- cymbal crashes 1
- dance all night 1
- dance mix 1
- dance party 1
- disc scratching noises 1
- dj face off 1
- dj turntable 1
- electronic dance music 1
- electronic harmony tones 1
- electronic music 1
- euro pop 1
- exciting 1
- experimental 1
- female singer 1
- flute countermelody 1
- groovy mood bass line 1
- guitar accompaniment 1
- hardship 1
- inspiring 1
- instrumental music 1
- instrumental music 1
- keyboard accompaniment 1
- keyboard harmony 1
- keyboard tones 1
- male rapper 1
- male vocals 1
- melancholic 1
- moog bass 1
- music production 1
- party night 1
- poignant 1
- poor audio quality 1
- purposeful 1
- quirky 1
- radio buzzing tones 1
- rapping vocals 1
- retro dance 1
- retro pop music 1
- romantic 1
- russian hit songs 1
- russian rap music 1
- story telling 1
- techno dance music 1
- techno pop music 1
- teenagers dancing 1
- various frequency tones 1
- vocal monologue 1
musiccaps_names (array) 12 ✖
- Music 4
- Drum and bass 2
- Drum machine 2
- Electronica 2
- Sampler 2
- Buzz 1
- Electronic music 1
- Hip hop music 1
- Rapping 1
- Scratching (performance technique) 1
- Speech 1
- Techno 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
1st Place DJ NIFFTY - 2010 World DMC DJ Championships - South African Final | A male singer sings this rapping vocals with a backup singer. The song is medium tempo with a groovy drum rhythm, disc scratching sounds, strong bass line and string accompaniment. The song is groovy and has a dance rhythm. The song audio quality is poor. | 2010-09-30T14:21:46Z | edptv | Produced by: www.blackbirdproductions.co.za 2010 South African DMC DJ Championships Final. MULTI-CAM of Live Set - DJ NIFFTY - Club Atmospheer - Cape Town - South Africa. RESULTS: 1st - DJ NIFFTY (2010 South African DMC DJ Champion) http://www.youtube.com/watch?v=6YXjJ6ABnZU 2nd - DJ CODAX http://www.youtube.com/watch?v=dibExyXfC3c 3rd - DJ ON Q http://www.youtube.com/watch?v=rCIoFNNOdOE FINALISTS: DJ CALCULUS http://www.youtube.com/watch?v=kvmBoL-tmtA DJ SHAMELESS http://www.youtube.com/watch?v=Uo5YJZ6RFbI DJ MARV D http://www.youtube.com/watch?v=1NqCsKCitfA DJ JUICE http://www.youtube.com/watch?v=J4xzSdnnFLM | ["Scratching (performance technique)", "Electronic music", "Music", "Speech"] | ["techno pop music", "male vocals", "rapping vocals", "dance party", "all night party", "discotheque", "dance floor", "dance rhythm", "energetic", "exciting", "medium tempo", "dj turntable", "ambient noises", "poor audio quality", "dance music", "electronic dance music", "groovy music", "dj face off", "disc scratching noises"] | 1 | 6YXjJ6ABnZU | 766 | |
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 | |
Gunshot - ROCMA ( Feat. XEptional ) | A male rapper sings this groovy melody. The song is medium tempo with a steady drumming rhythm, groovy bass line, a melancholic flute countermelody, keyboard harmony and guitar accompaniment. The song is exciting and passionate. The song is a modern Russian rap song with a story telling nature. | 2014-04-05T21:46:22Z | Mehdi Rafale | Produced and Mixed by XEptional https://www.facebook.com/Gunshot.officiel https://www.facebook.com/thexeptionalpage | ["Music", "Rapping", "Hip hop music"] | ["male rapper", "russian rap music", "medium tempo", "purposeful", "inspiring", "underground music", "youthful", "discotheque", "hardship", "flute countermelody", "guitar accompaniment", "groovy bass line", "steady drumming rhythm", "steady drumming rhythm", "keyboard harmony", "poignant", "melancholic", "emotional", "russian hit songs", "euro pop", "groovy music", "dance music", "dance mix", "dance club", "people dancing", "passionate", "story telling"] | 1 | TakkuFZJsis | 2849 | |
KING Q4 Love Buzz | A female singer sings this vocal monologue. The song is medium tempo with a groovy moog bass line, electro mix keyboard harmony tones, steady drumming rhythm and very quirky electronic tones. The song is groovy and retro dance music. | 2011-07-16T11:15:03Z | KINGQ44 | http://kingq4.bandcamp.com/ http://itunes.apple.com/fr/album/love-buzz-ep/id357022549 King Q4 Love Buzz Help me records 2010 composed by Shocking Blue arranged by King Q4 mixed by Raphael Seguin | ["Sampler", "Drum and bass", "Music", "Techno", "Buzz", "Drum machine", "Electronica"] | ["female singer", "retro pop music", "moog bass", "medium tempo", "energetic", "experimental", "quirky", "romantic", "youthful", "passionate", "people dancing", "dance club", "dance rhythm", "discotheque", "music production", "electronic music", "steady drumming rhythm", "dj", "radio buzzing tones", "various frequency tones", "groovy mood bass line", "dance rhythm", "emotional", "vocal monologue", "electronic harmony tones"] | 1 | dAAwzwexvUQ | 3767 |
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;