musiccaps_details (view)
2 rows where musiccaps_aspects contains "fun", musiccaps_aspects contains "punchy "4 on the floor" kick pattern" and musiccaps_names contains "Exciting music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- fun · 2 ✖
- happy 2
- punchy "4 on the floor" kick pattern · 2 ✖
- addictive 1
- chiptune 1
- claps 1
- commercial music 1
- euphoric 1
- exciting 1
- groovy 1
- groovy piano melody 1
- high pitched female vocal 1
- low quality 1
- pop 1
- remix 1
- repetitive synth melody 1
- shimmering bells melody 1
- shimmering hi hats 1
- snare roll 1
- stretched audio 1
- wide synth lead melody 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Vitaa ft Maitre Gim's Game over - Chipmunks music video | The low quality recording features a chiptune remix of a pop song and it consists of high pitched female vocal singing over repetitive synth melody, punchy "4 on the floor" kick pattern and shimmering bells melody at the very beginning of the loop. It sounds kind of addictive, fun and happy. The audio sounds like it was stretched. | 2014-01-16T18:13:45Z | Djanyzia Emeraude | Game over de Vitaa et Maitre Gim's par les Chipmunks/Chipettes. Like et commente la vidéo | ["Music", "Pop music", "Exciting music"] | ["low quality", "stretched audio", "pop", "high pitched female vocal", "repetitive synth melody", "punchy \"4 on the floor\" kick pattern", "shimmering bells melody", "chiptune", "remix", "fun", "happy", "addictive"] | 4 | 5iPTcL50mvw | 685 | |
Music Box Dancer 2007 - Holdman Christmas Lights HQ Version | The commercial music features a groovy piano melody played over snare rolls in the first half of the loop. Right after, there is a drop that consists of a punchy "4 on the floor" kick pattern, shimmering hi hats, claps, groovy piano and wide synth lead melody. It sounds happy, fun, euphoric and exciting. | 2009-09-20T03:35:36Z | holdmanchristmas | More info at www.holdman.com - This was our display for 2007 | ["Music", "Exciting music"] | ["commercial music", "groovy piano melody", "snare roll", "shimmering hi hats", "punchy \"4 on the floor\" kick pattern", "wide synth lead melody", "happy", "fun", "groovy", "exciting", "euphoric", "claps"] | 4 | ZK5M3DZejzk | 3362 |
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;