musiccaps_details (view)
4 rows where musiccaps_aspects contains "club music", musiccaps_aspects contains "electronic drums" and musiccaps_names contains "Music"
This data as json, CSV (advanced)
| video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
|---|---|---|---|---|---|---|---|---|---|---|
| I'm Sexy and I Know It (Official Music Video).By:THECARSIBESIKTAS1903 | This is a house music piece. There is a synth with a crisp sound playing the melody while a lot of turntable scratches can be heard in the background. An electronic drum beat with lots of snare beat repeat sounds provide the rhythm. The atmosphere is energetic and upbeat. This piece could be played at nightclubs or dance clubs. | 2011-12-19T14:18:44Z | TheCarsiBesiktas1903 | The New Video from LMFAO | ["Music", "Dance music", "Exciting music"] | ["house", "disco music", "no singer", "electronic", "synth", "turntable", "electronic drums", "energetic", "dance", "upbeat", "club music"] | 9 | 9PMoI31ncIs | 1001 | |
| Baltimore Club Music-Ester Dean Jawn- Click Clack Pop Pop (original) | This is a minimal techno music piece. There is a repeated vocal sample shouting the same thing repeatedly. In the background, a very strong bass is accompanied by the electronic kick drum to provide the rhythmic background. A dirty snare drum with heavy effects joins them later on. The piece is very danceable. It could be used in a nightclub. It could also be included in a DJ set. | 2011-10-05T15:27:46Z | The Baltimore Club Channel | Baltimore Club Music DOWNLOAD IT! Gucci Mane-I think i love her DJ Extrodinare- Ester Dean Jawn Click Clack Pop Pop MP3 DOWNLOAD:http://kiwi6.com/file/nt0rfzc6yh Subscribe + Follow on twitter @Dbsgdaclubhead Follow baltimoreclubdancing.tumblr.com for track updates with a little bit of commentary,news from the Bmore dance world, events, the best videos and alot more! | ["Music", "Rapping", "Burst, pop"] | ["minimal techno", "club music", "dance music", "loud bass", "electronic drums", "vocal sample", "repeated theme", "hollering", "dance", "sound effects"] | 9 | CtcmYF7mufk | 1411 | |
| Rave on Snow 2010 -| FELIX KRÖCHER |- official ROS2010 top Sound HD Qualität | This is the recording of an electronic dance music/rave party. The rhythmic background consists of a loud electronic drum beat. There is a synth playing a simple and repeated theme. The atmosphere is energetic. This piece could be played at nightclubs, dance clubs and rave events. It could also be playing at beach parties. | 2010-12-14T13:16:22Z | BodisTV | Felix Kröcher beim Rave on Snow 2010 in der Smirnoff Lounge Video by www.Bodis.TV visuals by Mar-k.os, visualdrugstore.com | ["Disco", "Music"] | ["rave", "electronic dance music", "electronic drums", "synth", "dance", "loud", "energetic", "repeated theme", "club music"] | 9 | NuN-ug3dIkw | 2376 | |
| TECHNO DANCE REMIX UNLIMITED DISCO MOBILE VOL.1 #2015 DJRYAN& DJ AR AR&DJ PROKZKIE | This is a disco/house music piece. There is a male vocal sample and a chopped hollering sample constantly repeating in the beat. The bass sound is fuzzy. The rhythm is provided by a slightly fast tempo electronic drum beat. The atmosphere is energetic. This piece could be played at nightclubs or dance clubs. | 2015-11-01T00:51:04Z | DJRYAN DOYON BUTUAN MIX CLUB | BASTA BMS DABEST! ,,, ACC https://www.facebook.com/ FREE soon vol2 #download linkhttp://www.mediafire.com/listen/y2tcaeem7t4m599/NONSTOP+DISCO%23+djrr%26+dj+prokzkie+%26+djarma+%26+djryan+remix.mp3 | ["Disco", "Electronic music", "Music", "Techno"] | ["disco", "house", "electronic dance music", "male vocal sample", "hollering sample", "repeated theme", "fuzzy bass", "electronic drums", "energetic", "club music"] | 9 | ULXbXpLcoVA | 2908 |
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;