musiccaps_details (view)
3 rows where musiccaps_aspects contains "bass", musiccaps_author = 6 and musiccaps_names contains "Techno"
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- bass · 3 ✖
- uptempo 3
- amateur recording 1
- clubmusic 1
- electronic drums 1
- electronic kick 1
- hardstyle/trance 1
- house 1
- house/techno 1
- low production 1
- male vocal sample 1
- monoton 1
- pulsating pad sounds 1
- riser 1
- synthesizer plucks 1
musiccaps_names (array) 13 ✖
- Music 3
- Techno · 3 ✖
- Dance music 1
- Disco 1
- Drum and bass 1
- Drum machine 1
- Dubstep 1
- Electronic dance music 1
- Electronic music 1
- Electronica 1
- House music 1
- Sampler 1
- Trance music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Jarrad - HARD TRANCE SHUFFLING 2012 #2 - Rage | The drums are playing a four on the floor techno rhythm with hihats and a strong kick. A synthetic bass follows the kick with almost just a single note playing. Panned to the left and right side of the speakers you can hear a monotone, repeating synth melody. This song may be playing in a technoclub. | 2012-04-25T20:48:13Z | 1am Films | WEEK #2 This is my Second Video for hardstyle/hard trance rocking, going to put together a new quick video every week :) TAGS : shuffling hardstyle reverse bass len we dance hard NR newcalste rockers LMFAO running man 2011 HD how to best dancing moves hat boy jarrad alalmbie sydney music qdance defqon cars loud new amazing magic slide DC break techno shuffle rocking melbourne old school how to running man new HD best compilation len wedancehard newcastle rockers brenton hiltzy pae sarah LMFAO party rock anthem every day im shuffling facebook twitter qdance scantraxx bass controll powerhouse jarrad peters hardstylestudio dance music australia NR GR german justin | ["Drum and bass", "Music", "Techno", "Trance music", "Dubstep"] | ["hardstyle/trance", "electronic drums", "bass", "synthesizer plucks", "pulsating pad sounds", "clubmusic", "uptempo"] | 6 | D7pjR9cQChM | 1440 | |
sound cars 2009 barquisimeto who is elvis | This song contains a four on the floor kick with a monotone and simple bassline. This song is produced in lower sound quality and the recording is clipping a little bit. This song may be played at a private houseparty. | 2010-01-16T04:32:04Z | Luis Linares | ["Sampler", "Disco", "Music", "Techno", "Electronic dance music", "Drum machine", "Dance music", "Electronica"] | ["house/techno", "low production", "monoton", "electronic kick", "bass", "uptempo"] | 6 | m-NM_tIWjxs | 4435 | ||
House music MIX 2011 | A synthesizer is playing a rhythmic, simple bassline. A male vocal sample that seems to be processed and pitched down is being played with a delay. Then a riser noise comes in sounding like wind that is getting stronger. This song may be playing while playing at a play-station with your friends. | 2010-08-20T01:41:48Z | RetroBlitz | _____________________________ That there, my first Top 10 Electro House music Comment, rate and join in my channel soon be posting the link to download 10 songs and Mix (Top 10 Electro House Music) I hope you like 10º Paris - Deluxe (Original Mix) 09º Daman-R - Close my Eyes (Boom&Base Radio Mix) 08º Fawni - Serious (In Styles Remix) 07º Megara vs DJ Lee - I Want You (Mikkas Remix) 06º Disco Reason - Hey Girl (Lokko Freakz Remix) 05º Stanhide - Model Game (Cherry Coke Remix) 04º Fast Foot - Toy Killer 03º Phantom Project - Super Girl 02º Eiffel 65 - I'm Blue (Fend Brothers Remix) 01º Max Furtado - Mensage From My Heart (Original Mix) | ["Electronic music", "House music", "Music", "Techno"] | ["house", "amateur recording", "bass", "male vocal sample", "riser", "uptempo"] | 6 | xuepy6SFOf8 | 5362 |
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;