musiccaps_details (view)
2 rows where musiccaps_aspects contains "medium tempo", musiccaps_aspects contains "rock", musiccaps_aspects contains "stringed instrument", musiccaps_names contains "Electric guitar" and musiccaps_names contains "Guitar"
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| The Jim Kelley Reverb amplifier, demo by Pete Thorn | This music is an electric guitar instrumental. The tempo is medium with a smooth electric guitar lead harmony. The music is clear, emphatic, smooth, groovy, youthful, crisp, edgy and dominant. | 2013-03-03T20:58:20Z | Pete Thorn | An in-depth look at the Kelley Reverb head, built by J.S. Technologies Check out Pete Thorn's "Guitar Nerd" album at CDbaby.com and iTunes: http://www.cdbaby.com/cd/petethorn https://itunes.apple.com/us/artist/pete-thorn/id437846702 | ["Reverberation", "Electric guitar", "Guitar", "Music", "Musical instrument", "Plucked string instrument", "Distortion"] | ["instrumental", "electric guitars", "medium tempo", "demonstration", "tutorial", "learning electric", "electric guitar lesson", "clear", "loud", "powerful", "empahtic", "amplified guitar", "electric guitar", "stringed instrument", "loud feed back", "blues", "rock", "jazz", "resonating", "reverb", "youthful", "groovy", "catchy riff", "smooth", "electric guitar lead", "electric guitar solo", "dense", "rich", "crisp", "edgy"] | 7 | ouVuF-y8bog | 4664 |
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;