musiccaps_details (view)
4 rows where musiccaps_aspects contains "dance club", musiccaps_aspects contains "energetic" and musiccaps_names contains "Techno"
This data as json, CSV (advanced)
musiccaps_aspects (array) 61 ✖
- dance club · 4 ✖
- energetic · 4 ✖
- dance floor 3
- dj 3
- groovy bass line 3
- medium tempo 3
- people dancing 3
- youthful 3
- electronic dance music 2
- auto tuned female vocals 1
- average audio quality 1
- cymbals crashing loud 1
- dance hits 1
- dance party 1
- dance rhythm 1
- dancers 1
- discotheque 1
- electronic harmony tones 1
- electronic music 1
- emotional 1
- entertaining 1
- euro pop hits 1
- exciting 1
- experimental 1
- fast tempo 1
- female singer 1
- groovy mood bass line 1
- groovy rhythm 1
- grunge keyboard tones 1
- grunge tones 1
- instrumental music 1
- keybiard harmony 1
- keyboard accompaniment 1
- keyboard harmony 1
- male singer 1
- moog bass 1
- music production 1
- night party 1
- passionate 1
- percussion hits 1
- poor audio quality 1
- quirky 1
- radio buzzing tones 1
- rap singer 1
- retro pop music 1
- romantic 1
- russian pop hits 1
- russian singer 1
- sonic effects 1
- spirited 1
- steady drumming rhythm 1
- steady rhythm 1
- synth trumpet lead 1
- techno dance hits 1
- techno dance music 1
- techno dance rhythm 1
- techno drumming rhythm 1
- teenage romance 1
- trance party 1
- various frequency tones 1
- vocal monologue 1
musiccaps_names (array) 13 ✖
- Music 4
- Techno · 4 ✖
- Dubstep 2
- Electronic dance music 2
- Buzz 1
- Cacophony 1
- Dance music 1
- Disco 1
- Drum and bass 1
- Drum machine 1
- Electronic music 1
- Electronica 1
- Sampler 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Azzido Da Bass - Music For Bagpipes (TRASHLINE Remix) [HD] | The song is an instrumental. The song is medium tempo with a groovy bass line, grunge keyboard tones, synth trumpet lead and techno drumming rhythm. The song is entertaining and energetic. The song is an electronic dance song with average quality recording. | 2010-09-04T16:45:36Z | PapayaOficiallRP | Azzido Da Bass - Music For Bagpipes (TRASHLINE Remix) Watch in HD! Suscribe! ;) MSN: PAPAiiA-JEtAiiME@hotmail.fr By: PapayaOficiallRP | ["Music", "Techno", "Dubstep", "Cacophony", "Electronic dance music"] | ["average audio quality", "groovy rhythm", "electronic dance music", "instrumental music", "groovy bass line", "medium tempo", "synth trumpet lead", "people dancing", "dj", "techno dance rhythm", "dance club", "dance floor", "spirited", "energetic", "youthful", "grunge keyboard tones"] | 1 | 4Mm5mBgktG0 | 562 | |
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 | |
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 | |
Russen Techno Remix | A male Russian singer sings this rap vocals with a female backup singer in vocal harmony. The song is fast tempo with techno drumming rhythm, percussive bass line, keyboard accompaniment and sonic effects. The song is a techno dance hit. The audio quality is poor. | 2008-10-23T14:40:58Z | CoolerRussenking | Russische Musik mit Verschiedenen Bildern. | ["Electronic music", "Music", "Techno"] | ["russian singer", "male singer", "rap singer", "poor audio quality", "fast tempo", "techno drumming rhythm", "groovy bass line", "keyboard accompaniment", "grunge tones", "sonic effects", "auto tuned female vocals", "exciting", "energetic", "entertaining", "dancers", "dance floor", "dance club", "trance party", "russian pop hits", "euro pop hits", "techno dance hits"] | 1 | dDKUjMHerLs | 3770 |
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;