musiccaps_details (view)
3 rows where musiccaps_aspects contains "loud", musiccaps_names contains "Electronic tuner", musiccaps_names contains "Guitar" and musiccaps_names contains "Musical instrument"
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| How To Tune A Guitar Electric or Acoustic Online Video Play Along Mp3 | This music is instrumental. The tempo is slow with an electric guitar playing two corresponding notes. The plucking pattern indicates that the guitar is being tuned. This is a Guitar tuning Tutorial/ Lesson. | 2009-02-08T01:51:23Z | musiciansdiscount | http://musiciansdiscountwarehouse.com/ davison guitar jameson guitar tune electric acoustic tuner video how to tune guitar play along | ["Electric guitar", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Electronic tuner", "Plucked string instrument"] | ["instrumental", "slow tempo", "plucking", "electric guitar", "scales", "three scales", "corresponding notes", "amplified instrument", "stringed instrument", "two notes", "guitar tuning", "electric guitar tuning", "guitar tuning lesson", "guitar tuning tutorial", "loud", "sharp", "lucid"] | 7 | Hn46VuvS88Y | 1833 | |
| PRS SE 245 Electric Guitar | This music is instrumental. The tempo is medium with a short,electric guitar riff and a male voice doing an introduction to a demo. The video is a tutorial/review of an electric guitar. | 2011-07-01T19:00:48Z | N Stuff Music | With a voice that is classic, eminently recordable and gig ready, the SE 245 is perfect for traditional single-cutaway players. The 24.5" scale length makes this instrument instantly comfortable to players who grew up using short scale guitars. Volume and tone controls for each pickup, a 3-way toggle and bird inlays are all standard appointments. Specifications: Body Top Wood: Maple Top and Flame Maple Veneer (no veneer on opaque finishes) Back Wood: Thick Mahogany Neck Number of Frets: 22 Scale Length: 24 1/2" Neck Wood: Mahogany Fretboard Wood: Rosewood Neck Shape: Wide Fat Fretboard Inlays: Birds Hardware/Electronics Bridge: PRS Designed Stoptail Tuners: PRS Designed Tuners Truss Rod Cover: "PRS" Hardware Type: Nickel Treble Pickup: PRS Designed SE 245 Treble Humbucker Bass Pickup: PRS Designed SE 245 Bass Humbucker Pickup Switching: Volume and Tone Control For Each Pickup and 3-Way Toggle Pickup Selector On Upper Bout . Join us on Facebook! https://www.facebook.com/NStuffmusic Checkout all of the videos on our Youtube channel! https://www.youtube.com/nstuffmusic Follow us on Twitter and stay up-to-date on all our deals! https://twitter.com/Nstuffmusic Wanna see what’s new? Follow us here. https://instagram.com/nstuffmusic Come visit us and check us out on Google. https://plus.google.com/+NstuffMusic N Stuff Music 468 Freeport Road Pittsburgh PA 15238 412-828-1003 https://www.NStuffMusic.com | ["Electric guitar", "Guitar", "Music", "Musical instrument", "Speech", "Electronic tuner", "Plucked string instrument", "Inside, small room"] | ["instrumental", "medium tempo", "introduction", "evie’s", "mark lucas", "male voice speaking", "demo", "electric guitar tutorial", "loud", "sonic power", "amplified", "stringed instrument", "rock", "metal", "heavy meal", "hard rock"] | 7 | Ij1-640aafg | 1933 | |
| How To Tune Your Guitar - Beginner Guitar Lesson #6 | This audio is an instrumental. The tempo is medium with an acoustic guitar monotone rhythm with a male voice giving instructions. The notes went from low to high. This clip is instructional audio on how to tune a guitar. | 2014-07-02T21:15:28Z | Guitareo | Learning how to tune the guitar is an essential skill because it gives you the ability to always sound your best when playing the guitar. There is nothing worse for your development as a guitarist than playing and practicing with an out-of-tune guitar. This guitar lesson is for beginners that want to learn how to tune a guitar by ear or how to tune with an electronic tuner. With the advancement of mobile phones and other devices - it's easier than ever to get your hands on a quality electronic tuner. However, it's still very valuable to have the ability to tune a guitar by ear. Not only will this help you whenever you don't have access to a tuner, but it will also help develop your ears. Just getting started on the acoustic guitar? Get free access to our 6-video course here 😎 ► https://www.guitareo.com/free-acoustic-guitar-lessons Ready to level up your playing? Get personal coaching tips and structured lessons: enjoy your free 7-day trial to Guitareo! ► https://guitareo.com/trial You can find the next beginner guitar lesson in this playlist: ► http://www.youtube.com/playlist?list=... Follow us: ►Facebook: https://www.facebook.com/guitareoofficial ►Instagram: https://www.instagram.com/guitareoofficial/ ►TikTok: https://www.tiktok.com/@guitareoofficial ► The Riff Blog: https://www.guitareo.com/riff/ #guitarlesson #guitarplayer #guitareo | ["Guitar", "Music", "Musical instrument", "Strum", "Electronic tuner", "Plucked string instrument"] | ["instrumental", "acoustic guitar", "sharp sound", "loud", "lucid", "instructor", "lecture", "guitar tuning", "monotone", "low to high notes", "male voice", "guitar tuning tutorial", "how to tune a guitar", "male voice talking", "informative", "teaching to tune a guitar", "learning to tune a guitar"] | 7 | bqPCtwibgPg | 3657 |
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;