musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "soulful" and musiccaps_names contains "Guitar" sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 23 ✖
- low quality 3
- soulful · 3 ✖
- mono 2
- noisy 2
- passionate 2
- acoustic rhythm guitar melody 1
- crowd noises 1
- electric guitar chords 1
- electric guitar melody 1
- emotional 1
- energetic 1
- finger style acoustic guitar melody 1
- folk 1
- groovy bass 1
- live performance 1
- metronome 1
- passionate electric guitar lick 1
- punchy snare 1
- shimmering cymbals 1
- steel guitar solo melody 1
- uptempo 1
- violin melody 1
- wide clapping 1
musiccaps_names (array) 9 ✖
- Guitar · 3 ✖
- Music 3
- Musical instrument 3
- Plucked string instrument 3
- Acoustic guitar 1
- Banjo 1
- Bass guitar 1
- Chorus effect 1
- Inside, small room 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Fingerstyle Guitar Lessons | The low quality recording features a finger style acoustic guitar melody. The recording is in mono, noisy and it sounds soulful and passionate. | 2006-06-20T14:01:13Z | workshoplive | http://www.workshoplive.com/index.cfm?WT.mc_id=YTFINGERSTYLE-SM Let Susan Mazer show you the goals of playing true fingerstyle blues. | ["Bass guitar", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["low quality", "finger style acoustic guitar melody", "metronome", "mono", "noisy", "soulful", "passionate"] | 4 | 15z-gbPxdXg | 236 | |
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 | |
Shinedown - Sound of Madness Guitar Cover | The low quality recording features a passionate electric guitar lick played over electric guitar chords. It sounds emotional, soulful and the recording is noisy and in mono. | 2010-11-12T17:07:08Z | UnitedWeTabDailyVid | Sound of Madness cover by Matt Hogan. | ["Guitar", "Music", "Musical instrument", "Chorus effect", "Plucked string instrument", "Inside, small room"] | ["low quality", "noisy", "mono", "passionate electric guitar lick", "electric guitar chords", "emotional", "soulful"] | 4 | sGVzzQLcT0U | 4936 |
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;