musiccaps_details (view)
1 row where musiccaps_aspects contains "distortion guitar", musiccaps_aspects contains "guitar instructional clip", musiccaps_aspects contains "no other instruments" and musiccaps_aspects contains "root and fifth"
This data as json, CSV (advanced)
| video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
|---|---|---|---|---|---|---|---|---|---|---|
| Canon Rock for beginners | This song features a male giving instructions on playing a guitar. A distortion guitar is playing the root note and the fifth. After the instruction, the root note and the fifth is played individually. This song features only the male instruction voice and no vocal melody. There are no other instruments in this song. There is no percussion in this song. | 2010-06-01T03:15:47Z | Brandon Burch Music | I've made this lesson for beginners who would like to get started with Canon Rock. These are just the chords. Enjoy! When you're ready to move on to the rest of the song, I have lessons available in my channel playlists. They cover the entire song. ✅ Watch next –Canon Rock Full Series Lessons https://www.youtube.com/playlist?list=PL0C718E78A4D6FD88 Join our journey: https://www.youtube.com/brandonburch?sub_confirmation=1 Click the bell so you won't miss my sporadic uploads! Need more inspiration? Check out these playlists: Best Productions: https://www.youtube.com/watch?v=SYMOy9-Y6ZA&list=PLLRq8GHI4SPFLGa4gik1lHZQUBU83NOi5 Musicians' Corner: https://www.youtube.com/watch?v=g81OJkCcbuw&list=PLLRq8GHI4SPG6b3QmtEQ98S2T16ZTYPX0 Gear Reviews: https://www.youtube.com/watch?v=CrAXz7tgf8U&list=PLLRq8GHI4SPH9uvFmOi4ndfA9rP-uvPtT Vocal Vids: https://www.youtube.com/watch?v=zR_rJha9hZo&list=PLLRq8GHI4SPEKQuwN1aXtL0lUcBd4WBhd I wish you all the best on your guitar journey! Guitar Journey merch: https://teespring.com/stores/brandon-burch-store My gear: https://www.amazon.com/shop/brandonburch1 Follow me: My music: https://brandonburch.bandcamp.com/ Soundcloud clips: https://soundcloud.com/brandon-burch-music Behind the music: https://www.instagram.com/brandondburch/ Photography: https://www.instagram.com/brandondburchphotos/ Follow my metal band: (Analyzed Within) Our music: https://analyzedwithin.bandcamp.com/ Facebook: https://www.facebook.com/analyzedwithin/ Official YT: http://www.youtube.com/analyzedwithin Drummer YT: https://www.youtube.com/user/DANOA7X2009 Drummer Instagram: https://www.instagram.com/dano.drums_aw/ Get my music gear! * D’Addario Strings, Regular Light, 7-String, 10-59: https://amzn.to/324Mwch * Ernie Ball 5-String Power Slinky Bass Set, 50-135: https://amzn.to/3aHaL44 * Dunlop Tortex Pitch Black Jazz Picks 1 Dozen 1.14 mm: https://amzn.to/327Nbtx * Gruv Gear FretWrap String Muter (Green, Medium): https://amzn.to/3gdCSJA * Focusrite Scarlett 2i2 USB Audio Interface: https://amzn.to/2EknGgg * Ib… | ["Tapping (guitar technique)", "Guitar", "Musical instrument", "Plucked string instrument"] | ["guitar instructional clip", "low quality audio", "distortion guitar", "no other instruments", "male voice", "instructional audio", "root and fifth"] | 0 | fsXQHyg5qDI | 3984 |
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;