musiccaps_details (view)
2 rows where musiccaps_author = 2 and musiccaps_names contains "Blues"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date), musiccaps_names (array), musiccaps_aspects (array)
| video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
|---|---|---|---|---|---|---|---|---|---|---|
| Stray Cat Strut by The Nosey Joe Band | The music features a male voice singing a descending melody that repeats. The instrumental consists of a drum kit that's playing a light rhythm, a double bass that's playing a repeating descending melody and an electric guitar that's strumming chords once per beat. The quality of the audio recording is not so good which leads me to believe this is an amateur recording and not something professional. | 2008-05-28T02:57:13Z | pookyfmr | This is our version of the song made famous by the Stray Cats. | ["Blues", "Singing", "Music", "Rock and roll"] | ["male voice", "reverb effect", "electric guitar", "double bass", "drums", "low audio recording quality"] | 2 | FvQgVl5IBHw | 1676 | |
| 35 Blues Licks Guitar Lesson | The excerpt features an electric guitar playing a descending melody note by note with a slight distortion effect on. This doesn't sound like actual music but more like an exercise. | 2013-03-09T16:30:19Z | gmcguitar | Backing tracks: Slow Blues: 14:17, Tasteful Blues: 18:14, Blues Duet: 22:18, Kenny Wayne Style: 25:13 More blues licks: http://bit.ly/1awubom Slow Blues Lesson : http://bit.ly/1hTGBcf Tasteful Blues Soloing Lesson : http://bit.ly/1mE5zN2 Blues Duet Rhythm & Solo Lesson : http://bit.ly/1bni8XV Kenny Wayne Shepherd Phrasing Lesson : http://bit.ly/1mE5ZTz Blues licks shown in this video : Kenny Wayne Style - 00:03 Xtreme Bending - 00:19 Double Lickin' - 00:40 Eric Clapton Style - 01:39 SRV Style Ending - 01:59 Bottleneck Lick - 02:18 SRV Turnaround - 02:36 Modern Blues - 03:02 Double Stops - 03:20 Turnaround - 03:39 Robben Ford Style - 04:13 Ending Lick In E - 04:31 SRV Style - 05:10 Major Minor Lick - 05:30 Albert King Style - 06:09 Classic Shuffle - 06:32 E Blues - 06:52 SRV Style Shuffle - 07:08 Slow Blues - 07:27 I-iV-V Rhythm - 07:50 Blues Riff - 08:34 Mix-O-Major - 08:56 Blues Rhythm - 09:28 Pentatonic Legato - 09:51 Bluesy Groove - 10:13 Blues Power - 10:36 Minor Comping - 10:56 Pentatonic Power - 11:19 Kenny Wayne Style Ending - 11:40 Robben Ford Style - 12:06 Blues Rake Lick - 12:26 BB King Style Lick - 12:57 Shuffle Comping - 13:20 SRV Style Bending - 13:35 BB King Style - 13:56 Related '30 Blues Greats' video : https://www.youtube.com/watch?v=55auX-OxpNk | ["Blues", "Electric guitar", "Guitar", "Music", "Musical instrument", "Steel guitar, slide guitar", "Plucked string instrument"] | ["electric guitar", "slight distortion effect", "no music", "exercise"] | 2 | k2uiJXN3L6E | 4294 |
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;