musiccaps_details (view)
2 rows where musiccaps_aspects contains "instrumental", musiccaps_aspects contains "soft" and musiccaps_names contains "Acoustic guitar"
This data as json, CSV (advanced)
musiccaps_aspects (array) 25 ✖
- instrumental · 2 ✖
- soft · 2 ✖
- acoustic drums 1
- bass guitar 1
- bossa nova 1
- electric guitar 1
- four stringed instrument 1
- guitar solo 1
- hawaiian instrument 1
- jam 1
- jazz 1
- live performance 1
- lute family 1
- mellow 1
- minimalist 1
- no singer 1
- pleasant sound 1
- rhythmic 1
- sensual 1
- simple 1
- slow tempo 1
- sound of clapping 1
- stringed instrument 1
- tranquil 1
- ukelele melody 1
musiccaps_names (array) 9 ✖
- Acoustic guitar · 2 ✖
- Guitar 2
- Music 2
- Musical instrument 2
- Plucked string instrument 2
- Bowed string instrument 1
- Jazz 1
- Strum 1
- Ukulele 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Blue Bossa - Achim Kohl - Jazz Guitar Improvisation with Tabs | This is an instrumental jazz improvisation piece with heavy bossa nova influences. There is an over-arching bossa nova syncopation not only being played by the acoustic drums in the backing track but also followed by the electric rhythm guitar and the bass guitar. The lead is a guitar solo being played by a gentle sounding electric guitar. Although there are complex chords and riffs, the general atmosphere is tranquil. This piece could be playing in the background of a restaurant. It could also be included in the soundtrack of a movie during serene scenery. | 2013-03-11T13:08:58Z | Achim Kohl | played with my Gibson ES 137 Custom, If you want to play a transcription of this solo, go to https://www.klangfarbe-noten-shop.de/en/blue-bossa-solo.html | ["Guitar", "Jazz", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument"] | ["jam", "jazz", "bossa nova", "no singer", "instrumental", "electric guitar", "guitar solo", "bass guitar", "acoustic drums", "soft", "sensual", "tranquil"] | 9 | AgtY6m-b3Gk | 1155 | |
ウクレレチューニング | This song is a simple instrumental. The tempo slows with the sound of clapping followed by a soft and mellow ukelele melody. This is a home video of a Ukelele instrumental. | 2008-06-01T00:14:12Z | radiorau | ウクレレのチューニング方法です | ["Guitar", "Acoustic guitar", "Music", "Musical instrument", "Ukulele", "Plucked string instrument", "Bowed string instrument"] | ["instrumental", "slow tempo", "ukelele melody", "minimalist", "pleasant sound", "simple", "rhythmic", "soft", "mellow", "sound of clapping", "live performance", "four stringed instrument", "stringed instrument", "hawaiian instrument", "lute family"] | 7 | u3yOMK8SuRI | 5088 |
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;