musiccaps_details (view)
4 rows where search matches "guitar" and musiccaps_aspects contains "solo guitar" sorted by youtube_id descending
This data as json, CSV (advanced)
musiccaps_aspects (array) 41 ✖
- solo guitar · 4 ✖
- fingerstyle 3
- acoustic guitar strumming 1
- bad audio recording 1
- bedroom recording 1
- blues influences 1
- blues lick 1
- bossa nova 1
- brazilian 1
- deep 1
- diy 1
- echo tone 1
- emotional 1
- extended range guitar 1
- finger snapping 1
- flamenco 1
- folk 1
- free time 1
- guitar amplifier 1
- guitar lead 1
- guitar solo 1
- guitar technique 1
- hazy muffled 1
- home video 1
- indie 1
- instrumental music 1
- knocking on guitar 1
- lo-fi 1
- low bass notes 1
- medium tempo 1
- moody blues 1
- no other instrumentation 1
- nylon string acoustic 1
- nylon string acoustic guitar 1
- passionate 1
- poor audio quality 1
- room reverb 1
- slightly 1
- sound check 1
- spirited 1
- tremolo effect 1
musiccaps_names (array) 12 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▲ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Flamenco guitar - Livio Gianola - Sicomoro | Solo nylon string acoustic guitar played fingerstyle in a flamenco tradition. The guitar has lower bass notes than a regular 6 string guitar. | 2010-02-17T13:39:12Z | Veojam | Livio Ganola plays his tarantas "Sicomoro" on eight strings flamenco guitar. Check https://www.veojam.com/spanish_flamenco for more flamenco guitar videos | ["Flamenco", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument"] | ["solo guitar", "nylon string acoustic guitar", "fingerstyle", "flamenco", "low bass notes", "extended range guitar", "free time"] | 8 | n3EeS2mVU5w | 4514 | |
AC-33 Acoustic Chorus Guitar Amplifier featuring Alex Hutchings | solo acoustic nylon string guitar playing in a fingerstyle Brazilian bossa nova style. | 2010-02-25T05:59:50Z | RolandChannel | http://www.roland.com/products/en/AC-33/ Worlds First AA Battery-Powered Acoustic Guitar Amp! Rich, deep, stereo sound to go — introducing the AC-33, the worlds first AA battery-powered amp made specifically for acoustic guitar. Portable yet powerful, the AC-33 provides true stereo sound, Guitar and Mic/Line channels, custom-tailored effects, anti-feedback, and a Phrase Looper. But this amp was made to go places no amp has gone before. Thanks to its battery-power capability, the AC-33 lets you take your act anywhere — into the backwoods, onto the streets, or wherever your imagination leads you. | ["Effects unit", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Chorus effect", "Plucked string instrument"] | ["solo guitar", "nylon string acoustic", "fingerstyle", "bossa nova", "brazilian"] | 8 | ZVvX2-ldhvY | 3387 | |
diane cluck - focus on their eyes | Intentionally lo-fi bedroom recording of acoustic guitar strumming, knocking and fingerstyle playing. Finger snaps can also be heard. There is a slightly muffled room reverb over everything. Has an indie folk DIY aesthetic. | 2010-05-20T23:30:43Z | frinkianz | focus on their eyes | ["Tapping (guitar technique)", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument"] | ["diy", "solo guitar", "acoustic guitar strumming", "room reverb", "lo-fi", "knocking on guitar", "fingerstyle", "finger snapping", "bedroom recording", "indie", "slightly", "hazy muffled", "folk"] | 8 | BI8YQ3ueD24 | 1226 | |
Fender FSR Limited Edition Deluxe Reverb RI | A male guitarist plays a cool guitar like on an electric guitar. The song is medium tempo with a guitar solo with heavy a[echoes played though a guitar amplifier and no other instrumentation. The song is bluesy and passionate. The song is a casual blue slick played on a guitar. | 2012-05-09T06:39:38Z | Thomas Fargo | Testing the amp with Lollar P-90s | ["Reverberation", "Electric guitar", "Guitar", "Music", "Musical instrument"] | ["home video", "poor audio quality", "sound check", "deep", "emotional", "passionate", "blues influences", "instrumental music", "guitar solo", "tremolo effect", "guitar amplifier", "guitar lead", "echo tone", "solo guitar", "bad audio recording", "no other instrumentation", "guitar technique", "moody blues", "spirited", "passionate", "medium tempo", "blues lick"] | 1 | 6_zzu2KON6c | 768 |
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;