musiccaps_details (view)
3 rows where musiccaps_aspects contains "4 on the floor kick pattern" and musiccaps_aspects contains "exciting"
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- 4 on the floor kick pattern · 3 ✖
- exciting · 3 ✖
- electro 2
- low quality 2
- addictive 1
- clapping 1
- crowd cheering 1
- electric guitar melody 1
- energetic 1
- flat female vocal 1
- flat male vocal 1
- groovy 1
- haunting synth lead melody 1
- live performance 1
- mellow synth keys 1
- passionate female vocal 1
- pop 1
- reversed hi hats 1
- shimmering 2 step hi hats 1
- shimmering hi hats 1
- wide synth pad chords 1
musiccaps_names (array) 8 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
101.9 For Life launches new radio station jingle | The low quality recording features a live performance of a pop song and it consists of flat female and male vocal rapping over "4 on the floor" kick pattern and electric guitar melody. There are some crowd clapping and cheering noises in the background. It sounds exciting and energetic. | 2013-07-07T07:39:40Z | ABS-CBN News | FM radio station M.O.R. 101.9 For Life! Manila launched its official station jingle on "ASAP 18" on Sunday ahead of its launch on Monday, July 8, starting at 5 a.m. | ["Singing", "Music of Asia", "Music", "Pop music"] | ["low quality", "clapping", "crowd cheering", "pop", "live performance", "flat male vocal", "flat female vocal", "4 on the floor kick pattern", "electric guitar melody", "exciting", "energetic"] | 4 | HEhogaw0vUg | 1782 | |
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;