musiccaps_details (view)
1 row where search matches "guitar", musiccaps_aspects contains "blues" and musiccaps_names contains "Electronic tuner" sorted by youtube_published
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_names (array) 7 ✖
- Electric guitar 1
- Electronic tuner · 1 ✖
- Guitar 1
- Music 1
- Musical instrument 1
- Plucked string instrument 1
- Speech 1
musiccaps_aspects (array) 6 ✖
- blues · 1 ✖
- clean sound 1
- easygoing 1
- electric guitar 1
- guitar lesson 1
- male voice 1
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Joe Bonamassa Inspired Guitar Lick - Blues Rock Guitar Lessons - Speed Building | This is the recording of a guitar lesson video. There is a male instructor first performing the tune and then describing what he is playing. The tune is being played on a clean sounding electric guitar and there is a blues feel to it. The atmosphere is easygoing. The parts the male voice is not heard can be sampled for use in beat-making. | 2011-06-01T23:23:19Z | GuitarJamz | My Technique and review channel http://www.youtube.com/youcanlearnguitar Joe Bonamassa Inspired Guitar Lick - Blues Rock Guitar Lessons - Speed Building Excercise marty schwartz lesson against rise electric metal picking steve play "guitar lesson" chords gilbert sweep improvisation guitarist solos beginner learn acoustic tab jazz scales jam instrumental guitars "electric guitar" minor classical "guitar lessons" | ["Electric guitar", "Guitar", "Music", "Musical instrument", "Speech", "Electronic tuner", "Plucked string instrument"] | ["guitar lesson", "male voice", "electric guitar", "clean sound", "blues", "easygoing"] | 9 | YDh36ZdneAU | 3266 |
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;