musiccaps_details (view)

2 rows where musiccaps_aspects contains "amplified", musiccaps_aspects contains "metal", musiccaps_author = 7 and musiccaps_names contains "Musical instrument"

✎ View and edit SQL

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
Voice of the Soul (Death cover) This music is instrumental. The tempo is fast with an electric guitar riff playing a cover of a popular melody. The music is intense, loud, passionate, violent, aggressive and thunderous. This music is heavy metal/ death metal. 2014-05-19T11:44:39Z Juris Alunaanc Hi! Debut EP of my band ''HEDONYST'' is out now! Check it here: Itunes: https://apple.co/2JG2ymS Spotify: https://spoti.fi/2YgXmZV Deezer: https://bit.ly/2unWmpq Google Play: https://bit.ly/2FksQpG Follow us on social media: Facebook: https://bit.ly/2HM8UyI Soundcloud: https://bit.ly/2WjvaEd ["Bass guitar", "Guitar", "Music", "Musical instrument", "Cacophony", "Plucked string instrument", "Outside, urban or manmade"] ["instrumental", "fast tempo", "electric guitar", "rock", "hard rock", "metal", "heavy metalloud feed back", "amplified", "sonic power", "intense", "passionate", "loud feedback", "heavy metal", "death metal", "aggressive", "passionate", "stringed instrument"] 7 P5uIpVLEpm4 2507

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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;