musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "emotional", musiccaps_aspects contains "home music video" and musiccaps_aspects contains "instrumental music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 57 ✖
- emotional · 4 ✖
- home music video · 4 ✖
- instrumental music · 4 ✖
- medium tempo 3
- average audio quality 2
- exciting 2
- groovy rhythm 2
- guitar demo 2
- guitar solo 2
- passionate 2
- soloist 2
- spirited 2
- acoustic guitar session 1
- adventure of a lifetime 1
- amateur recording 1
- backing track 1
- bad audio quality 1
- celtic music 1
- classic guitars music 1
- classic rock 1
- country music 1
- delay guitar effects pedal 1
- fiddler 1
- groovy music 1
- guitar harmony 1
- guitar lead 1
- guitar pedal demonstration 1
- guitar strumming 1
- home studio setup 1
- melancholic 1
- mome music video 1
- moody 1
- nostalgia 1
- online tutorial 1
- organ accompaniment 1
- pensive 1
- playful 1
- poor audio quality 1
- psychedelic 1
- relaxing 1
- retro rock music 1
- slow tempo 1
- soothing 1
- splits 1
- steady bass line 1
- steady rock drumming 1
- subtle bass line 1
- tambourine percussions 1
- traditional folk music 1
- traditional percussion instruments 1
- trippy 1
- vintage rock vibes 1
- violin 1
- violins playing 1
- virtuosos playing 1
- walkthrough video 1
- youthful 1
musiccaps_names (array) 11 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
8 Year Old Jonny Mizzone - Flint Hill Special - Sleepy Man Banjo Boys | The song is an instrumental. The song is slow tempo with a fiddler plays a rhythmic melody accompanied by a guitar accompaniment and other percussive instruments. The song is spirited and energetic. The song has country or Celtic influences. The song has average quality audio. | 2011-02-21T02:57:35Z | Sleepy Man | Our new single "Rain" https://www.youtube.com/watch?v=ZcoOKXrJqY0 http://sleepyman.com **From 2011** Another bedroom practice of Earl Scruggs's Flint Hill Special. Brothers Jonny Mizzone age 8 on banjo, Robbie Mizzone age 12 on fiddle, and Tommy Mizzone age 13 on guitar. http://www.sleepymanbanjo.com http://facebook.com/sleepymanbanjo | ["Banjo", "Music"] | ["fiddler", "instrumental music", "celtic music", "spirited", "home music video", "exciting", "traditional folk music", "violin", "average audio quality", "mome music video", "groovy music", "traditional folk music", "guitar strumming", "traditional percussion instruments", "emotional", "playful", "exciting", "country music", "violins playing", "medium tempo"] | 1 | I3qbB4Kq3Y0 | 1869 | |
Snap Crackle and how`s your Dad | The song is an instrumental. The song is medium tempo with a groovy bass line, rock drumming, tambourine percussion, guitar rhythm and guitar lead. The song is adventurous and emotional. The song is classic rock and has a poor audio quality. | 2010-06-19T06:13:50Z | BurnsErnst | Here is another special tune by The Shadows. Backing track is from the original vinyl record without the first lead. On some parts, where the lead was on both channels, I try to play as exactly along with Hank as I could. I hope it`s ok. | ["Music", "Grunge"] | ["instrumental music", "guitar lead", "soloist", "guitar solo", "vintage rock vibes", "emotional", "spirited", "passionate", "groovy rhythm", "psychedelic", "backing track", "classic rock", "tambourine percussions", "medium tempo", "steady rock drumming", "organ accompaniment", "poor audio quality", "home music video", "guitar demo", "retro rock music", "steady bass line", "adventure of a lifetime"] | 1 | g6f-LxiT9Eo | 4006 | |
Boss DD-7 Digital Delay Modulate (chorus phaser) Strat Squier Deluxe Boss CH-1 | The song track is an instrumental. The tempo is medium, with a guitarist demonstrating a guitar effects reverb pedal by playing related instrumental phrases. The song is trippy and exciting. The audio quality is poor as it’s an amateur home recording . | 2011-12-30T20:18:39Z | MurphyMario13 | Boss DD7 Modulate setting very versatile setting , you can have a chorus if you cut the repeat. Very close to Boss CH-1 Super Chorus Squier stratocaster deluxe Daphnee blue Amp peavey 6505 plus clean channel with compressor Marshall ED1 Boss Digital Delay DD-7 Pedal Demo | ["Effects unit", "Guitar", "Music", "Musical instrument", "Chorus effect", "Plucked string instrument"] | ["guitar solo", "delay guitar effects pedal", "guitar demo", "amateur recording", "online tutorial", "walkthrough video", "home studio setup", "instrumental music", "groovy rhythm", "trippy", "exciting", "emotional", "passionate", "youthful", "bad audio quality", "guitar pedal demonstration", "home music video", "soloist", "medium tempo"] | 1 | gpEU6RafUf0 | 4056 | |
Berceuse - Lullaby | The song is an instrumental. The tempo is slow with a classical guitar playing harmony style with a subtle bass line and no other instrumentation. The song is emotional and relaxing. The audio quality is worth average. | 2009-01-13T21:16:18Z | bernard vdd | Compo perso pour Timeo. Play with a gibson j45. For stereo sound try this link: http://fr.youtube.com/watch?v=jS9u6X6TQmk&fmt=18 | ["Guitar", "Acoustic guitar", "Music", "Steel guitar, slide guitar", "Strum", "Plucked string instrument"] | ["guitar harmony", "splits", "classic guitars music", "average audio quality", "melancholic", "nostalgia", "soothing", "virtuosos playing", "instrumental music", "subtle bass line", "guitar harmony", "slow tempo", "acoustic guitar session", "home music video", "emotional", "pensive", "moody", "relaxing", "emotional"] | 1 | jS9u6X6TQmk | 4255 |
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;