musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "easygoing", musiccaps_names contains "Musical instrument" and musiccaps_names contains "Tapping (guitar technique)"
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- easygoing · 2 ✖
- acoustic guitar 1
- chill 1
- chill electric guitar melody 1
- groovy 1
- guitar solo 1
- instrumental 1
- jam 1
- low quality 1
- no singer 1
- noisy 1
- percussive slap 1
- relaxing 1
- single instrument 1
- smooth buzzy bass guitar 1
- unbalanced stereo 1
musiccaps_names (array) 8 ✖
- Acoustic guitar 2
- Guitar 2
- Music 2
- Musical instrument · 2 ✖
- Plucked string instrument 2
- Tapping (guitar technique) · 2 ✖
- Bass guitar 1
- Electric guitar 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Round Midnight - Guitar and acoustic bass guitar | The low quality recording features a smooth buzzy bass guitar and chill, electric guitar melody playing. It is noisy and the stereo image is unbalanced, as the bass guitar is leaning toward the left channel. It sounds easygoing, chill and relaxing. | 2015-03-24T20:19:36Z | Matt Otten | I bought this bass guitar about 2 weeks ago; this is my first recording with it :) starting with a slow tune to get used to the fretless playing, it's a challenge! I have played bass guitar for quite some time, but acoustic and fretless is another thing. | ["Bass guitar", "Tapping (guitar technique)", "Electric guitar", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["low quality", "smooth buzzy bass guitar", "chill electric guitar melody", "noisy", "unbalanced stereo", "chill", "easygoing", "relaxing"] | 4 | ZmgkpmzvL6c | 3412 |
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;