musiccaps_details (view)
3 rows where musiccaps_aspects contains "euphoric", musiccaps_aspects contains "groovy piano melody" and musiccaps_author = 4
This data as json, CSV (advanced)
musiccaps_aspects (array) 26 ✖
- euphoric · 3 ✖
- groovy piano melody · 3 ✖
- happy 2
- claps 1
- commercial music 1
- exciting 1
- fun 1
- groovy 1
- live performance 1
- low quality 1
- mixed harmonizing choir 1
- noisy 1
- nostalgic 1
- passionate 1
- passionate female vocal 1
- pop 1
- punchy "4 on the floor" kick pattern 1
- shimmering bells melody 1
- shimmering hi hats 1
- smooth bass 1
- snappy rimshots 1
- snaps 1
- snare roll 1
- sustained strings melody 1
- wide shimmering shakers 1
- wide synth lead melody 1
musiccaps_names (array) 6 ✖
- Music 3
- Song 2
- Chant 1
- Choir 1
- Exciting music 1
- Music of Asia 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
3 ohin jingle bell | The recording features a live performance of a pop song that consists of passionate female vocal singing over groovy piano melody, sustained strings melody, smooth bass, widely spread shimmering shaker, snaps and snappy rimshots. It sounds euphoric, as it brings a Christmassy vibe, and is also happy and nostalgic. | 2012-12-19T10:33:32Z | Ganaa Jigee | ["Music of Asia", "Music", "Song"] | ["live performance", "pop", "passionate female vocal", "sustained strings melody", "groovy piano melody", "smooth bass", "wide shimmering shakers", "snaps", "snappy rimshots", "euphoric", "happy", "nostalgic"] | 4 | 20Vh6z6Ie0E | 325 | ||
Rhythm of Life - GMEA Honor Chorus | The low quality recording features a mixed harmonizing vocals singing over shimmering bells and groovy piano melody. It sounds passionate and euphoric. The recording is noisy. | 2008-02-10T22:21:33Z | ElleForrest | Rhythm of life preformed by the Georgia 11/12 Mixed 6 Honors Chorus. No Copyright intended | ["Chant", "Music", "Song", "Choir"] | ["low quality", "noisy", "shimmering bells melody", "groovy piano melody", "mixed harmonizing choir", "passionate", "euphoric"] | 4 | G-5UYGccne4 | 1683 | |
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;