musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "uptempo", musiccaps_names contains "Blues" and musiccaps_names contains "Electric guitar"
This data as json, CSV (advanced)
musiccaps_aspects (array) 10 ✖
- e-guitar 2
- uptempo · 2 ✖
- acoustic guitar 1
- amateur recording 1
- country/blues 1
- drum loop 1
- drums 1
- electric keys 1
- upright bass 1
- violin 1
musiccaps_names (array) 7 ✖
- Blues · 2 ✖
- Electric guitar · 2 ✖
- Music 2
- Distortion 1
- Guitar 1
- Musical instrument 1
- Tapping (guitar technique) 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
David Peterson "Rattlesnakin' Daddy" | The drums and the upright bass are playing in a bluesy, country vibe with a half open hi hat. An acoustic guitar is strumming chords that are almost not noticeable. The e-guitar is playing a loud lead melody in the foreground while a violin is playing short bowed notes along. This is an amateur recording. This song may be playing in a bar. | 2009-04-23T02:23:03Z | NeuronVacuum | David Peterson performs "Rattlesnakin' Daddy" at the Family Wash in Nashville TN April 2009. Paul Franklin on pedal steel, Luke Bulla on fiddle, Richard Bennett on electric guitar, Dennis Crouch on bass, and Tommy Giampietro on snare. | ["Blues", "Electric guitar", "Music"] | ["country/blues", "e-guitar", "acoustic guitar", "drums", "violin", "upright bass", "electric keys", "uptempo"] | 6 | D0L-M4trkpw | 1428 | |
Harley Benton SC-550 Paradise Amber Flame sound test | Someone is playing a e-guitar melody and strumming chords using a lot of reverb and delay over a drum backing track. This is an amateur recording. This song may be playing at home practicing guitar. | 2015-07-10T17:17:35Z | Che Guebuddha | Harley Benton SC-550 Paradise Amber Flame from Thomann.de all stock. Amp is Kustom PH2012R and played through Digitech RP70 multi pedal. Same tune clean with delay-reverb and dirty fuzz territory afterwards. Because this cheap camera records very thin sound I had Tone down to almost 0. These are very hot pickups (Wilkinson Alnico) | ["Blues", "Tapping (guitar technique)", "Electric guitar", "Guitar", "Music", "Musical instrument", "Distortion"] | ["amateur recording", "drum loop", "e-guitar", "uptempo"] | 6 | idUZsNLnyDg | 4209 |
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;