musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "jam" and musiccaps_names contains "Acoustic guitar" sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- jam · 3 ✖
- acoustic guitar 2
- guitar solo 2
- instrumental 2
- no singer 2
- sensual 2
- acoustic drums 1
- bass guitar 1
- bossa nova 1
- easygoing 1
- electric guitar 1
- exotic 1
- flamenco 1
- groovy 1
- jazz 1
- male voice 1
- percussive slap 1
- review 1
- single instrument 1
- soft 1
- tranquil 1
musiccaps_names (array) 11 ✖
- Acoustic guitar · 3 ✖
- Guitar 3
- Music 3
- Musical instrument 3
- Plucked string instrument 3
- Strum 2
- Bass guitar 1
- Flamenco 1
- Jazz 1
- Speech 1
- Tapping (guitar technique) 1
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Paco de Lucia plays an Erez Perelman Flamenco Guitar Part 1 | This is an instrument review jam that is played in the style of flamenco music. There is an acoustic guitar being played while a male voice gives his opinion concerning the instrument. The character of the sound is sensual. The guitar sounds can be sampled for use in beat-making. | 2011-11-22T11:13:27Z | Erez Perelman | Order Your Handmade Classical or Flamenco Guitar Here: http://erez-perelman.com/contact/ Paco de Lucias playing Erez Perelman flamenco guitar. | ["Bass guitar", "Flamenco", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Speech", "Plucked string instrument"] | ["jam", "flamenco", "acoustic guitar", "male voice", "review", "exotic", "sensual"] | 9 | axqtExFY5-s | 3590 | |
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 | |
Percussive Slap Technique - Acoustic Guitar Lesson Part 1 - The Basics | This is an instrumental jam piece. The only instrument is an acoustic guitar which is being played with a percussive slap technique. The track is groovy. This piece could fit perfectly as an advertisement jingle. | 2014-03-07T10:05:04Z | Gareth Evans | Watch the rest of this series now Part 1 - https://youtu.be/F1uXNtotVsg Part 2 - https://youtu.be/KI0LjpPiu5U Part 3 - https://youtu.be/5eBNvXbvxHQ Part 4 - https://youtu.be/TmGTzpyyE3c Part 5 - https://youtu.be/P81hTF8Bmw8 My website will be back very soon. http://www.goliathguitartutorials.com/ Don't forget to like and subscribe, it helps me a lot, thank you. Gareth | ["Tapping (guitar technique)", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["jam", "no singer", "instrumental", "single instrument", "acoustic guitar", "guitar solo", "percussive slap", "groovy", "easygoing"] | 9 | F1uXNtotVsg | 1609 |
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;