musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "shimmering hi hats" and musiccaps_aspects contains "soulful" sorted by youtube_channel
This data as json, CSV (advanced)
musiccaps_aspects (array) 27 ✖
- shimmering hi hats · 3 ✖
- soulful · 3 ✖
- acoustic rhythm guitar 2
- emotional 2
- low quality 2
- noisy 2
- passionate 2
- country 1
- electric guitar melodies 1
- electric guitar melody 1
- electric guitar solo melody 1
- groovy bass 1
- groovy bass guitar 1
- harmonizing vocals 1
- live performance 1
- mellow kick hits 1
- passionate male vocal 1
- punchy kick 1
- punchy snare 1
- regional mexican 1
- rock 1
- shimmering tambourine 1
- smooth bass guitar 1
- snappy rimshot 1
- soft kick hits 1
- soft synth keys melody 1
- sustained strings melody 1
musiccaps_names (array) 9 ✖
- Music 3
- Gospel music 2
- Christian music 1
- Christmas music 1
- Happy music 1
- Psychedelic rock 1
- Rock and roll 1
- Rock 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 |
---|---|---|---|---|---|---|---|---|---|---|
Duane Eddy - Because They`re Young | The Rock song features a sustained strings melody, groovy bass, electric guitar melodies, punchy snare, shimmering hi hats, mellow kick hits and acoustic rhythm guitar. It sounds soulful and like something you would hear during the 70s. The recording is a bit noisy. | 2008-12-15T22:20:12Z | 45RPMbyMikeEvans | Duane Eddy`s UK chart hit singles - 1958 Rebel Rouser #19 1959 Cannonball #22 1959 Peter Gunn # 6 1959 Yep! #17 1959 40 Miles of Bad Road #11 1959 Some Kind-A-Earthquake #12 1960 Bonnie Came Back #12 1960 Shazam #4 1960 Becuase They`re Young #2 1960 Kommotion #13 1961 Pepe #2 1961 Theme From Dixie #7 1961 Ring Of Fire #17 1961 Drivin` Home #30 1961 Caravan #42 1962 Deep In The Heart Of Texas #19 1962 Ballad Of Paladin #10 1962 ( Dance With The ) Guitar Man # 4 1963 Boss guitar # 27 1963 Lonely Boy Lonely Guitar #35 1963 Your Baby`s Gone Surfin` #49 1975 Play Me Like You Play Your Guitar #9 1986 Peter Gunn #8 ( with Art of Noise ) | ["Music", "Psychedelic rock", "Rock music", "Rock and roll"] | ["rock", "sustained strings melody", "groovy bass", "electric guitar melodies", "punchy snare", "shimmering hi hats", "mellow kick hits", "acoustic rhythm guitar", "soulful", "noisy"] | 4 | bKm2_67xtVs | 3617 | |
The Singing Cooke's--Family Circle | The low quality recording features a country song that contains harmonizing vocals singing over electric guitar solo melody, smooth bass guitar, acoustic rhythm guitar, snappy rimshots, shimmering hi hats and soft kick hits. It sounds soulful, emotional and passionate. | 2010-12-11T03:34:48Z | Nexar41834 | ["Gospel music", "Christian music", "Music", "Happy music"] | ["low quality", "country", "harmonizing vocals", "electric guitar solo melody", "smooth bass guitar", "snappy rimshot", "shimmering hi hats", "soft kick hits", "acoustic rhythm guitar", "soulful", "emotional", "passionate"] | 4 | mlpTCec4igo | 4490 | ||
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;