musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "guitar solo", musiccaps_author = 0 and musiccaps_names contains "Musical instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 23 ✖
- guitar solo · 3 ✖
- instrumental 3
- bass 2
- distortion guitar 2
- no voices 2
- slow tempo 2
- 12 bar blues 1
- hammer on 1
- harmonics 1
- low quality audio 1
- moderate tempo 1
- no other instruments 1
- no percussion 1
- no voice 1
- percussion 1
- piano 1
- rock song 1
- romantic theme 1
- simple percussion 1
- slow blues song 1
- string bending 1
- synth backing 1
- vibrato 1
musiccaps_names (array) 9 ✖
- Guitar 3
- Music 3
- Musical instrument · 3 ✖
- Plucked string instrument 3
- Bowed string instrument 1
- Electric guitar 1
- Jazz 1
- Opera 1
- Pulse 1
youtube_published (date) 3 ✖
- 2006-07-17 1
- 2010-04-24 1
- 2012-11-06 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Tomáš Valášek - www.kytarova-skola.com, www.kytara-online.cz | This rock song features a guitar solo being played on a distortion guitar. This starts off with a string bend followed by a descending lick. A harmonic string scratch technique is played to produce a screeching sound. This is followed by a fast ascending scale run. This is accompanied by percussion playing a simple rock beat. The bass plays the root notes of the chords. There are no voices in this song. This is an instrumental. Due to the low audio quality, the instruments are not clearly heard. | 2010-04-24T08:39:01Z | kytarovaskola | www.kytara-online.cz, www.kytarova-skola.com. | ["Electric guitar", "Guitar", "Music", "Musical instrument", "Pulse", "Plucked string instrument", "Bowed string instrument"] | ["rock song", "low quality audio", "no voices", "instrumental", "distortion guitar", "guitar solo", "percussion", "bass", "harmonics", "moderate tempo", "string bending"] | 0 | CM7jMnBXw2Y | 1356 | |
Lindsey Stirling - Phantom of the Opera(Guitar Cover) | This song features a distortion guitar playing a guitar solo. The solo is played at a high pitch. It is a slow tempo solo. The guitarist plays a lot of vibrato when the notes are allowed to ring for a while. The pattern follows three ascending notes followed by three strikes on a lower note. This is followed by one higher note, the lower note and a hammer on to a higher note. A synth plays backing chords. There are no other instruments in this song. The mood of this song is romantic. | 2012-11-06T21:02:35Z | Łukasz Stemler - MusiC | Fell free to add me on facebook https://www.facebook.com/update_security_info.php?wizard=1#!/pages/ManieK/180841045311104 Here's my band http://www.facebook.com/pages/MossaD-Masters-of-speed-strength-and-Disorder/179106888791919 Hey, my friends ! Check out my fanpage on facebook ! I would like to present you my band .M.o.s.s.a.D ! Click the button ' like it ' :D It would be great ;) Greetings ^ ^ It's a new cover of Lindsey. Everything is playing by ear plus some of my ideas :)This is the second version on youtube I guess :) Hope you gonna like that one . All the best. Axelek666 | ["Guitar", "Music", "Musical instrument", "Opera", "Plucked string instrument"] | ["distortion guitar", "guitar solo", "synth backing", "vibrato", "hammer on", "no other instruments", "no percussion", "no voice", "instrumental", "slow tempo", "romantic theme"] | 0 | NKDBwJIwWoU | 2331 | |
Jazzed Blues Solo | This slow blues song features a solo played on a guitar. The tempo of this song is slow. This is accompanied by percussion playing a simple beat. The bass follows the 12 bar blues pattern. The piano plays chords in the background. The mood of this song is romantic and the pattern played on the guitar is similar to a call-response theme. This song can be played in a bar. | 2006-07-17T14:30:15Z | looptruefire | My favorite solo from TrueFire's Jazz ed Blues course with Mark Stefani. | ["Guitar", "Jazz", "Music", "Musical instrument", "Plucked string instrument"] | ["slow blues song", "instrumental", "guitar solo", "bass", "simple percussion", "12 bar blues", "piano", "slow tempo", "no voices"] | 0 | qAgZ__fk9LY | 4760 |
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;