musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "no other instruments" and musiccaps_aspects contains "string bending"
This data as json, CSV (advanced)
musiccaps_aspects (array) 13 ✖
- no other instruments · 2 ✖
- string bending · 2 ✖
- acoustic guitar music 1
- blues feel 1
- distortion guitar 1
- guitar solo 1
- instrumental 1
- low quality amateur recording 1
- no percussion 1
- no voice 1
- raking guitar strings 1
- slow tempo 1
- speed picking 1
musiccaps_names (array) 7 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
whitesnake crying in the rain - my solo | This low quality amateur recording features a guitar solo being played on a distortion guitar. The solo is played up the neck on the higher register. The guitarist plays with very fast picking techniques. This song starts off with string bending which is followed by fast picking on descending licks. | 2007-09-16T15:27:54Z | Damcka | me going nuts with a whitesnake solo by john sykes. | ["Tapping (guitar technique)", "Electric guitar", "Music"] | ["low quality amateur recording", "guitar solo", "string bending", "distortion guitar", "speed picking", "no other instruments"] | 0 | 1FnA3w94zXI | 250 | |
Andrea Valeri: Carrasecare | This instrumental song features an acoustic guitar being played. The strings are raked followed by a bend to a higher note. This is followed by a descending run using three notes. This song has a blues feel. There are no other instruments in this song. There are no voices in this song. This song can be played in a Wild West movie. | 2011-04-19T05:56:08Z | Fingerpicking net | Andrea Valeri for fingerpicking.net. High resolution video on http://www.fingerpicking.net | ["Guitar", "Music", "Mandolin", "Musical instrument", "Plucked string instrument"] | ["acoustic guitar music", "raking guitar strings", "slow tempo", "string bending", "blues feel", "no percussion", "no other instruments", "no voice", "instrumental"] | 0 | 4ueN2gGsH5Y | 614 |
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;