musiccaps_details (view)
2 rows where musiccaps_aspects contains "noisy", musiccaps_aspects contains "punchy kick" and musiccaps_aspects contains "shimmering tambourine"
This data as json, CSV (advanced)
musiccaps_aspects (array) 27 ✖
- low quality 2
- noisy · 2 ✖
- punchy kick · 2 ✖
- shimmering tambourine · 2 ✖
- addictive synth lead melody 1
- buzzy synth bass 1
- clapping 1
- dirty mix 1
- edm 1
- electric guitar melody 1
- emotional 1
- energetic 1
- groovy bass guitar 1
- live performance 1
- messy 1
- passionate 1
- passionate male vocal 1
- pulsating 1
- pulsating synth chords 1
- punchy snare 1
- regional mexican 1
- shimmering bells 1
- shimmering hi hats 1
- shimmering open hats 1
- snaps 1
- soft synth keys melody 1
- soulful 1
musiccaps_names (array) 7 ✖
- Music 2
- Christmas music 1
- Dubstep 1
- Electronic dance music 1
- Funk 1
- Gospel music 1
- Song 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Missing from YouTube | The low quality recording features an EDM song that consists of shimmering bells, buzzy synth bass, pulsating synth chords, snaps, claps, punchy kick, shimmering open hats and tambourine hits. The recording is a bit noisy, but it sounds energetic. The mix is a bit dirty, which makes the song sound a bit messy in terms of frequencies. | ["Funk", "Music", "Dubstep", "Electronic dance music"] | ["low quality", "shimmering bells", "noisy", "punchy snare", "pulsating synth chords", "snaps", "punchy kick", "addictive synth lead melody", "shimmering open hats", "shimmering tambourine", "energetic", "edm", "pulsating", "clapping", "buzzy synth bass", "dirty mix", "messy"] | 4 | 1156 | |||||
Chiquilla. Interpretacion GRUPO FREE SOUNDS de Ensenada, BC | The low quality recording features a live performance of a regional Mexican song and it consists of passionate male vocal singing over groovy bass guitar, mellow synth keys melody and electric guitar melody, followed by shimmering tambourine, hi hats and punchy kick. It sounds passionate, emotional and soulful - like something you would hear at family gathering events. | 2012-04-20T18:44:22Z | victor lopez | PRESENTACION EN EL PROGRAMA LA VELADA DE SINTESIS TELEVISION TIJUANA (DERECHOS RESERVADOS) DEL GRUPO MUSICAL FREE SOUNDS DE ENSENADA, BC | ["Christmas music", "Gospel music", "Music", "Song"] | ["low quality", "live performance", "regional mexican", "passionate male vocal", "groovy bass guitar", "soft synth keys melody", "shimmering tambourine", "punchy kick", "electric guitar melody", "noisy", "passionate", "emotional", "soulful", "shimmering hi hats"] | 4 | RNwiEsjrhiQ | 2694 |
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;