musiccaps_details (view)
2 rows where musiccaps_aspects contains "4 on the floor kick pattern", musiccaps_author = 4 and musiccaps_names contains "Electronic music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 13 ✖
- 4 on the floor kick pattern · 2 ✖
- electro 2
- exciting 2
- addictive 1
- groovy 1
- haunting synth lead melody 1
- low quality 1
- mellow synth keys 1
- passionate female vocal 1
- reversed hi hats 1
- shimmering 2 step hi hats 1
- shimmering hi hats 1
- wide synth pad chords 1
musiccaps_names (array) 5 ✖
- Electronic music · 2 ✖
- Music 2
- Drum machine 1
- Electronic dance music 1
- Synthesizer 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
KiNK with Roland T.R. 8 test 1 | The low quality recording features an electro song that consists of reversed hi hats, followed by shimmering 2 step hi hats and "4 on the floor" kick pattern playing on top of it. It sounds groovy and exciting. | 2014-07-14T17:16:57Z | kink303 | First test with Roland T.R. 8, showing the 909 sounds of the machine. I start from scratch, with nothing in the memory. I kept the sound unprocessed, so you can decide if you want to buy it or not. The next demos will be more raw and distorted, as I like it :) | ["Electronic music", "Music", "Drum machine", "Synthesizer"] | ["electro", "reversed hi hats", "4 on the floor kick pattern", "groovy", "exciting", "low quality", "shimmering 2 step hi hats"] | 4 | qeoYWM1uYPI | 4805 | |
DANCE FLOOR 2011 - VOEUX 2011 - FRED FRUHAUF | The Electro song features a passionate female vocalist singing over wide synth pad chords, mellow synth keys, shimmering hi hats, "4 on the floor" kick pattern and haunting synth lead melody. It sounds addictive and exciting. | 2010-12-31T18:06:42Z | Fred Fruhauf | Un petit Remix de l'année 2010 pour passer votre réveillon. Toute l'équipe FFZOOM, ainsi que le Studio le Clos Sevestre vous présente SES MEILLEURS VOEUX POUR L'ANNEE 2011. | ["Electronic music", "Music", "Electronic dance music"] | ["electro", "passionate female vocal", "wide synth pad chords", "mellow synth keys", "shimmering hi hats", "4 on the floor kick pattern", "haunting synth lead melody", "addictive", "exciting"] | 4 | sU08gu2zJ4c | 4953 |
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;