musiccaps_details (view)
3 rows where musiccaps_names contains "Acoustic guitar" and musiccaps_names contains "Jazz" sorted by musiccaps_aspects
This data as json, CSV (advanced)
Suggested facets: musiccaps_names
musiccaps_aspects (array) 21 ✖
- low quality 2
- acoustic drums 1
- audio cutout 1
- bass guitar 1
- bossa nova 1
- calming 1
- electric guitar 1
- groovy acoustic rhythm guitar melody 1
- guitar solo 1
- instrumental 1
- jam 1
- jazz 1
- jazzy electric guitar melody 1
- mono 1
- no singer 1
- noisy 1
- relaxing 1
- sensual 1
- soft 1
- tranquil 1
- unbalanced stereo 1
musiccaps_names (array) 9 ✖
- Acoustic guitar · 3 ✖
- Guitar 3
- Jazz · 3 ✖
- Music 3
- Strum 3
- Musical instrument 2
- Plucked string instrument 2
- Blues 1
- Funk 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 | |
Fingerstyle Jazz Guitar Improv - Jody Fisher | The low quality recording features a jazzy electric guitar melody. The recording is noisy and it is in mono - regardless, it sounds calming and relaxing. | 2006-02-23T23:43:33Z | workshoplive | http://www.workshoplive.com/index.cfm?WT.mc_id=YTJZGIT-JF1 Jody Fisher, one of our jazz instructors at workshoplive, took some time to jam some jazz musings on his Klein electric guitar. Enjoy Jody's music! | ["Guitar", "Jazz", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument"] | ["jazzy electric guitar melody", "low quality", "mono", "noisy", "calming", "relaxing"] | 4 | 476vNb6thyM | 540 | |
Jam Track - Jazzy Funk Blues - Bm7 (rhythm guitar track) | The Low quality recording features a groovy acoustic rhythm guitar melody that occasionally has some audio cuts out in the stereo image - making it sound unbalanced. | 2013-11-28T08:13:31Z | Randy Struble Backing Tracks | A play on the Bm7 chord in a funk, jazz, blues kinda way!! Listen! Be inspired! Create! Improvise! Enjoy!! You can DOWNLOAD this and any of my other Jam/Backing Tracks @ https://bluegrassbackingtracks.bandcamp.com/track/jam-track-jazzy-funky-blues-bm7-rhythm-guitar-track Thanks for using a Backing Track by Randy Struble Produced with CyberLink PowerDirector 10 | ["Blues", "Funk", "Guitar", "Jazz", "Acoustic guitar", "Music", "Strum"] | ["unbalanced stereo", "audio cutout", "groovy acoustic rhythm guitar melody", "low quality"] | 4 | VOWGbyg4KZY | 2998 |
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;