musiccaps_details (view)
3 rows where musiccaps_aspects contains "acoustic guitar", musiccaps_aspects contains "jam" and musiccaps_names contains "Musical instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- acoustic guitar · 3 ✖
- jam · 3 ✖
- male voice 2
- advertising 1
- bass guitar 1
- easygoing 1
- electronic drum beat 1
- exotic 1
- flamenco 1
- gear 1
- groovy 1
- guitar solo 1
- instrumental 1
- no singer 1
- percussive slap 1
- review 1
- rhythm machine 1
- sensual 1
- single instrument 1
musiccaps_names (array) 11 ✖
- Guitar 3
- Musical instrument · 3 ✖
- Plucked string instrument 3
- Acoustic guitar 2
- Music 2
- Bass guitar 1
- Drum machine 1
- Flamenco 1
- Speech 1
- Strum 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 |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
KR Mini: Energize your practices and performances with diverse rhythm patterns! | This is an advertisement video for a rhythm machine. Firstly, it is shown playing behind a bass guitar jam. Then, it is shown playing behind an acoustic guitar jam. A male voice is describing the benefits and functions of the rhythm machine. The parts where the instruments can be heard without the interruption of the voice can be sampled for use in beat-making. | 2013-09-05T01:01:42Z | Korg | Designed for guitarists, bassists, pianists or any musician looking for easy rhythm accompaniment, the KR mini features nostalgic looks and a simple design focused on easy, push-button control. The KR mini is also lightweight, can run on batteries and has a built-in speaker, allowing it to provide a backing rhythm pattern anywhere at any time. With a total of 60 diverse rhythm patterns across the genres, the compact KR Mini is ready to accompany any performance. For more information on the KR Mini Rhythm Machine, head over to http://www.Korg.com/KRmini. "Like" us -- https://www.facebook.com/KORGusa "Follow" us -- https://www.twitter.com/KorgUSA | ["Guitar", "Musical instrument", "Drum machine", "Plucked string instrument"] | ["jam", "gear", "rhythm machine", "electronic drum beat", "bass guitar", "acoustic guitar", "male voice", "advertising"] | 9 | rS8oECcQBCk | 4877 |
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;