musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_names contains "Acoustic guitar", musiccaps_names contains "Blues", musiccaps_names contains "Music" and musiccaps_names contains "Steel guitar, slide guitar"
This data as json, CSV (advanced)
Suggested facets: musiccaps_names, youtube_published (date)
musiccaps_aspects (array) 24 ✖
- amateur recording 2
- blues guitar 2
- acoustic guitar 1
- acoustic guitars 1
- blues 1
- country blues 1
- dense guitar playing 1
- filtered vocal humming 1
- fingerstyle guitar 1
- folk rock 1
- foot stomping percussion 1
- guitar layers 1
- instrumental music 1
- intricate acoustic guitar playing 1
- male voice singing 1
- medium to uptempo 1
- no percussion 1
- no voices 1
- relaxing 1
- resonator guitar 1
- singer-songwriter/pop 1
- slide guitar 1
- uplifting vibe 1
- uptempo 1
musiccaps_names (array) 8 ✖
- Acoustic guitar · 4 ✖
- Blues · 4 ✖
- Music · 4 ✖
- Steel guitar, slide guitar · 4 ✖
- Guitar 3
- Plucked string instrument 3
- Mandolin 2
- Musical instrument 2
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Mike Dowling " Blues In G ." | This blues guitar song features a resonator guitar. Fingerstyle guitar is being played. The melody is a blues style guitar. There are no other instruments in this song. There are no voices in this song. This song can be played in a bar. | 2014-05-08T19:25:05Z | nationalguitars | Mike Dowling presents "Blues In G." courtesy of Homespun. | ["Blues", "Guitar", "Acoustic guitar", "Music", "Mandolin", "Musical instrument", "Steel guitar, slide guitar", "Plucked string instrument"] | ["blues guitar", "fingerstyle guitar", "no percussion", "resonator guitar", "no voices", "instrumental music", "relaxing"] | 0 | F1X7egd8Us0 | 1608 | |
Careless Love Guitar Improvisation - Pentatonic Scale - Harmonic Minor - Major Scale Usage | One acoustic guitar is strumming chords while the other one is playing a solo melody on top with bending notes in a pentatonic scale. This song may be playing at home practicing guitar. | 2012-03-03T19:14:55Z | YourGuitarSage | This video is a guitar improvisation jam using the classic swing tune, "Careless Love". If you want the form for the pentatonic scale, go to http://www.yourguitarsage.com and get the free Ultimate Guitar Guide. If you like free guitar lessons, your mom will be so proud of you for subscribing to my channel. That is if Free and Guitar are things you like... Your $1 UGS membership trial is right here: http://www.yourguitarsage.com/1-dollar Feel free to ask me guitar questions on Twitter at: http://www.twitter.com/yourguitarsage and Facebook at http://www.facebook.com/yourguitarsage Now go swing that guit fiddle! :) e | ["Blues", "Guitar", "Acoustic guitar", "Music", "Mandolin", "Musical instrument", "Steel guitar, slide guitar", "Plucked string instrument"] | ["folk rock", "acoustic guitars", "amateur recording", "uptempo", "uplifting vibe"] | 6 | RSryuuvUfDM | 2703 | |
ライオンハート SMAP cover, Gibson Humming bird ( ギター 弾き語り スマップカバー ギブソン ハミングバード) | Someone is strumming an acoustic guitar while a male voice is singing along. This may be playing at a bonfire. | 2015-05-31T09:04:29Z | MA channel | ライオンハート SMAP cover 8曲目のアップとなります!是非!聞いてください。 | ["Blues", "Acoustic guitar", "Music", "Steel guitar, slide guitar"] | ["singer-songwriter/pop", "acoustic guitar", "male voice singing", "medium to uptempo", "amateur recording"] | 6 | em7akjDUsWk | 3895 | |
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 |
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;