musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "amplified", musiccaps_names contains "Electric guitar" and musiccaps_names contains "Speech"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 23 ✖
- amplified · 2 ✖
- instrumental 2
- male voice speaking 2
- medium tempo 2
- sonic power 2
- demo 1
- demonstration 1
- electric guitar 1
- electric guitar lesson 1
- electric guitar tutorial 1
- evie’s 1
- female voice speaking 1
- foreign language 1
- hard rock 1
- heavy meal 1
- introduction 1
- loud 1
- mark lucas 1
- metal 1
- review 1
- rock 1
- stringed instrument 1
- tutorial 1
musiccaps_names (array) 9 ✖
- Electric guitar · 2 ✖
- Guitar 2
- Music 2
- Musical instrument 2
- Plucked string instrument 2
- Speech · 2 ✖
- Bass guitar 1
- Electronic tuner 1
- Inside, small room 1
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 | |
竹中くんと野村くんのエレキギター講座 ジェフ・ベック編 2/10 | This music is an electric guitar instrumental. The tempo is medium with a strong, emphatic and funky riff. There are male and female voices in a foreign language superimposed on the audio. This clip is an electronic guitar demo or lesson. | 2010-10-16T09:58:48Z | tw2tsugua | トークの部分だけに編集しています。 | ["Bass guitar", "Electric guitar", "Guitar", "Music", "Musical instrument", "Speech", "Plucked string instrument"] | ["instrumental", "medium tempo", "electric guitar", "demonstration", "review", "amplified", "sonic power", "male voice speaking", "female voice speaking", "foreign language", "electric guitar lesson", "tutorial"] | 7 | yaUK4XvVGTg | 5423 |
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;