musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "male voice speaking", musiccaps_aspects contains "medium tempo" and musiccaps_names contains "Electric guitar"
This data as json, CSV (advanced)
musiccaps_aspects (array) 25 ✖
- instrumental 3
- male voice speaking · 3 ✖
- medium tempo · 3 ✖
- amplified 2
- electric guitar 2
- electric guitar lesson 2
- electric guitar tutorial 2
- sonic power 2
- stringed instrument 2
- amplified instrument 1
- catchy riff 1
- demo 1
- demonstration 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
- tutorial 1
musiccaps_names (array) 9 ✖
- Electric guitar · 3 ✖
- Guitar 3
- Music 3
- Musical instrument 3
- Plucked string instrument 3
- Speech 3
- Electronic tuner 2
- Bass guitar 1
- Inside, small room 1
youtube_published (date) 3 ✖
- 2009-07-17 1
- 2010-10-16 1
- 2011-07-01 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 | |
16. Tipos de Guitarra | This music is instrumental. The tempo is medium with an electric guitar harmony. The music is a catchy riff with a male voice speaking in a foreign language. This clip is an electric guitar lesson/ tutorial. | 2009-07-17T04:08:27Z | iBeriano93 | 16/17 Clinica Angel Parra 16/ Tipos de Guitarra sl2! | ["Electric guitar", "Guitar", "Music", "Musical instrument", "Speech", "Electronic tuner", "Plucked string instrument"] | ["instrumental", "medium tempo", "electric guitar", "male voice speaking", "electric guitar lesson", "amplified instrument", "stringed instrument", "electric guitar tutorial", "catchy riff"] | 7 | YBbvQ0RPrG8 | 3264 | |
竹中くんと野村くんのエレキギター講座 ジェフ・ベック編 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;