musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "electric guitar melody", musiccaps_aspects contains "punchy snare" and musiccaps_aspects contains "shimmering cymbals"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) >30 ✖
- electric guitar melody · 4 ✖
- punchy snare · 4 ✖
- shimmering cymbals · 4 ✖
- energetic 3
- groovy bass 3
- low quality 3
- live performance 2
- noisy 2
- passionate 2
- acoustic rhythm guitar melody 1
- addictive 1
- addictive synth keys melody 1
- blues 1
- cover 1
- crowd noises 1
- distorted 1
- flat male vocal 1
- folk 1
- fun 1
- groovy 1
- groovy bass guitar 1
- happy 1
- harmonica solo melody 1
- mellow 1
- mono 1
- punchy kick 1
- rock 1
- soft male vocal 1
- soulful 1
- steel guitar solo melody 1
- …
musiccaps_names (array) 13 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Foggy Mtn Breakdown (Must-Own DVD) | The low quality recording features a live performance of a folk song and it contains a steel guitar solo melody played over, acoustic rhythm guitar, electric guitar melody, shimmering cymbals, punchy snare, groovy bass, followed by violin melody, crowd noises and claps. It sounds passionate, uptempo, soulful and energetic. | 2009-07-15T05:50:54Z | jamesarthurjohnson | From All-Star Bluegrass Celebration DVD - Ricky Skaggs, Earl Scruggs, Vince Gill, Travis Tritt, Jerry Douglas, and on and on... | ["Banjo", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["low quality", "folk", "live performance", "wide clapping", "crowd noises", "steel guitar solo melody", "acoustic rhythm guitar melody", "groovy bass", "punchy snare", "shimmering cymbals", "electric guitar melody", "violin melody", "passionate", "uptempo", "soulful", "energetic"] | 4 | GuHDy--gWiM | 1758 | |
Blues Rhythms - #1 - Guitar Lesson - Corey Congilio | The low quality recording features an electric guitar melody played over a playback that consists of groovy bass, punchy snare and shimmering cymbals. At the end of the loop, there is a flat male vocal talking. It sounds groovy, fun and the recording is noisy and slightly distorted. | 2012-11-21T19:01:01Z | TrueFire | *FULL COURSE NOW AVAILABLE FOR DOWNLOAD w/ TAB, JAMS & MORE: http://tfir.es/50BluesRhythms COREY CONGILIO: http://tfir.es/CoreyC MORE FREE GUITAR LESSONS: http://bit.ly/TrueFire | ["Blues", "Bass guitar", "Guitar", "Music", "Musical instrument", "Rhythm and blues", "Speech", "Harmonic", "Plucked string instrument"] | ["low quality", "electric guitar melody", "groovy bass", "punchy snare", "shimmering cymbals", "groovy", "fun", "happy", "flat male vocal", "distorted", "noisy"] | 4 | NZ2kFIaW05k | 2345 | |
Maps (UCSC Version) - Yeah Yeah Yeahs | The cover of a rock song consists of soft male vocal singing over shimmering cymbals, punchy snare and kick hits, groovy bass guitar, addictive synth keys melody and electric guitar melody. It sounds energetic, but yet mellow and addictive - thanks to that cadence. | 2006-08-06T04:59:47Z | Michael Tucker | "Fantastically Creepy" is one way it has been described. How would you describe it? Video for "Maps" by the Yeah Yeah Yeahs. Go UCSC (University of California at Santa Cruz). Check out more of our movies at http://www.finite-films.com | ["Independent music"] | ["cover", "rock", "soft male vocal", "shimmering cymbals", "punchy snare", "punchy kick", "groovy bass guitar", "addictive synth keys melody", "electric guitar melody", "energetic", "addictive", "mellow"] | 4 | nZOgoVEud_w | 4553 | |
Steve Miller mercury blues norton buffalo harmonica solo | The low quality recording features a live performance of blues songs and it consists of a harmonica solo melody played over groovy bass, punchy snare, shimmering cymbals and electric guitar melody. As it was recorded with a phone, there are some whistling crowd noises, aside from the fact that the recording is in mono and noisy. It still sounds energetic and passionate. | 2006-10-04T03:46:37Z | Sunshine Day | part of song with awesome harmonica solo by norton | ["Harmonica", "Wind instrument, woodwind instrument"] | ["low quality", "whistling sound", "mono", "noisy", "harmonica solo melody", "groovy bass", "punchy snare", "shimmering cymbals", "electric guitar melody", "live performance", "blues", "passionate", "energetic"] | 4 | ovomUNSo_uo | 4666 |
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;