musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "blues" and musiccaps_aspects contains "country blues"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 26 ✖
- blues · 3 ✖
- country blues · 3 ✖
- slide guitar 2
- acoustic guitar harmony 1
- blues guitar 1
- country music 1
- country song 1
- dense guitar playing 1
- empahtic electric guitar feedback 1
- empahtic melody 1
- fiddle 1
- filtered vocal humming 1
- foot stomping percussion 1
- guitar layers 1
- instrumental 1
- intense 1
- intricate acoustic guitar playing 1
- lap steel guitar 1
- melancholy 1
- powerful 1
- regional music 1
- rugged 1
- slow tempo 1
- twangy high pitched licks 1
- upright bass guitar 1
- vivid 1
musiccaps_names (array) 8 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Country blues music | This music is instrumental. The tempo is slow with an acoustic guitar harmony, loud electric guitar feedback and fiddle. The music is intense, rugged, vivid, melancholic, pensive, raw, powerful, emphatic and strong. This music is classic Blues Country Music. | 2012-07-29T11:41:29Z | PROMETHEUS | Country, blues song :D | ["Blues", "Country", "Music", "Bluegrass"] | ["instrumental", "slow tempo", "melancholy", "vivid", "empahtic melody", "rugged", "powerful", "country blues", "blues", "country music", "country song", "regional music", "empahtic electric guitar feedback", "acoustic guitar harmony", "country music", "intense", "rugged", "fiddle"] | 7 | cGorUmWMrwo | 3693 | |
Blues & Decker - Till Dawn (Official Music Video) | This is a high-octane blues song, with layers of intricate bluesy acoustic guitar playing. There's a slide guitar involved, and other layers of potent intense guitar playing. There's a distant filtered vocal hum which sounds like it is coming through a telephone. | 2013-06-17T07:20:31Z | Blues & Decker | Videoclip del tema "Till Dawn", extraído del disco "Stealin' the blues" de Blues & Decker. Una historia de Blues y Muerte. Protagonizado por Eve MyVestal. Dirigido y realizado por Titi Muñoz. No dejes de visitar la web oficial de la banda: www.bluesdecker.com | ["Blues", "Guitar", "Acoustic guitar", "Music", "Steel guitar, slide guitar", "Plucked string instrument"] | ["slide guitar", "blues", "blues guitar", "country blues", "intricate acoustic guitar playing", "guitar layers", "dense guitar playing", "foot stomping percussion", "filtered vocal humming"] | 3 | m7i4g_o-znQ | 4445 | |
I've Got a New Heartache | This is a bluesy country style song played on a lap steel guitar. There is a walking bassline, and slide guitar being played. The singer has a burly, calm voice. The song would be heard in an old school bar in Texas - which might be called a "saloon". | 2008-02-16T09:58:41Z | Brian Folks | A Real Good Swingin' Country Song...Has Lots of Pedal Steel Guitar in it...Enjoy. Brian... | ["Blues", "Music", "Steel guitar, slide guitar"] | ["lap steel guitar", "blues", "upright bass guitar", "country blues", "twangy high pitched licks", "slide guitar"] | 3 | nU7x170OvJ4 | 4543 |
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;