musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "low quality", musiccaps_aspects contains "punchy kick" and musiccaps_aspects contains "shimmering tambourine"
This data as json, CSV (advanced)
musiccaps_aspects (array) 28 ✖
- low quality · 3 ✖
- punchy kick · 3 ✖
- shimmering tambourine · 3 ✖
- emotional 2
- groovy bass guitar 2
- live performance 2
- passionate 2
- cover 1
- crowd cheering 1
- crowd clapping 1
- crowd noises 1
- easygoing 1
- electric guitar feedback 1
- electric guitar melody 1
- electric guitar solo melody 1
- funky 1
- groovy 1
- noisy 1
- passionate male vocal 1
- punchy snare 1
- regional mexican 1
- repetitive synth bells melody 1
- rock 1
- shimmering hi hats 1
- smooth bass guitar 1
- soft synth keys melody 1
- soulful 1
- tinny wooden percussions 1
musiccaps_names (array) 9 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Johnny A - Hip Bone | The low quality recording features an electric guitar solo melody played over groovy bass guitar, shimmering tambourine, punchy kick and tinny wooden percussion. It sounds groovy, funky and passionate. | 2006-06-17T05:03:31Z | clydeman | More tasty guitar from the master. | ["Guitar", "Music", "Musical instrument", "Steel guitar, slide guitar", "Plucked string instrument"] | ["low quality", "electric guitar solo melody", "groovy bass guitar", "shimmering tambourine", "punchy kick", "tinny wooden percussions", "groovy", "funky", "passionate"] | 4 | aCTm1TcL7z8 | 3520 | |
Part 1: With or Without You (U2 Cover: Rattle & Hum) with Axe-Fx Ultra | The low quality recording features a cover of a rock song and it consists of an electric guitar feedback playing over a live performance instrumental that has crowd cheering, crowd clapping noises, smooth bass guitar, repetitive synth bells melody, punchy snare and kick hits and shimmering tambourine. It sounds emotional and easygoing. | 2010-03-29T04:08:11Z | U2 Guitar Tutorials | Cover of U2's With or Without You. Part 1 of guitar tutorial. Based on the live version from Rattle & Hum. Recorded entirely with Fractal Audio's Axe-Fx Ultra. See www.u2guitartutorials.com for more information. | ["Music", "Rattle"] | ["low quality", "live performance", "electric guitar feedback", "crowd noises", "crowd clapping", "crowd cheering", "smooth bass guitar", "repetitive synth bells melody", "punchy snare", "punchy kick", "shimmering tambourine", "cover", "rock", "emotional", "easygoing"] | 4 | d2gHgzfC-Oo | 3759 |
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;