musiccaps_details (view)
2 rows where musiccaps_aspects contains "punchy kick", musiccaps_names contains "Christmas music" and musiccaps_names contains "Music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 29 ✖
- punchy kick · 2 ✖
- brass section progression 1
- electric guitar melody 1
- emotional 1
- euphoric 1
- excited 1
- flat male lead vocal 1
- fun 1
- groovy bass 1
- groovy bass guitar 1
- happy 1
- live performance 1
- low quality 1
- muffled bells melody 1
- noisy 1
- nostalgic 1
- passionate 1
- passionate male vocal 1
- regional mexican 1
- seasonal 1
- shimmering hi hats 1
- shimmering shaker bells 1
- shimmering tambourine 1
- simple piano chord progression 1
- soft snare 1
- soft synth keys melody 1
- soulful 1
- staccato strings melody 1
- wide harmonizing male vocals 1
musiccaps_names (array) 5 ✖
- Christmas music · 2 ✖
- Music · 2 ✖
- Gospel music 1
- Song 1
- Soul music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Brian Lexus - The Christmas Song | This seasonal song features a flat male vocal, supported by wide harmonizing male vocals, singing over punchy kick, soft snare, groovy bass, shimmering shaker bells, muffled bells melody, staccato strings melody, brass section progression and simple piano chord progression. It sounds fun and happy, leaving the listener with the feelings of euphoria, nostalgia and excitement. | 2014-06-29T21:08:11Z | Grzegorz Burzyński | Lyrics and Music by Sebastian Kwiatkowski Brian Lexus - The Christmas Song | ["Christmas music", "Music", "Soul music"] | ["seasonal", "wide harmonizing male vocals", "flat male lead vocal", "soft snare", "groovy bass", "punchy kick", "simple piano chord progression", "muffled bells melody", "brass section progression", "staccato strings melody", "fun", "happy", "nostalgic", "euphoric", "excited", "shimmering shaker bells"] | 4 | BS2ZnUhmHj4 | 1239 | |
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;