musiccaps_details (view)
5 rows where musiccaps_aspects contains "male voice" and musiccaps_names contains "Electric 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 |
|---|---|---|---|---|---|---|---|---|---|---|
| Deer Tick 10-18-2007 Ashamed 1/10 | This song is a low quality live recording of a performance. This features a male voice singing the main melody. At the end of the song, other voices sing with the main voice in harmony. This is accompanied by an electric guitar plucking chords. The double bass plays the root notes of the chords. The percussion plays the cymbal, increasing volume slowly, giving it a swell feel. The mood of the song seems romantic. | 2007-10-22T00:17:05Z | vincenz7 | Live @ Cakeshop. CMJ's. Unfortunately it got cut 1 1/2 minutes into the song. But check out the rest of the show! | ["Electric guitar", "Guitar", "Music", "Tick"] | ["live recording", "male voice", "slow rock", "guitar", "double bass", "drums", "low quality music", "romantic theme", "vocal harmony", "moderate tempo"] | 0 | P90rFZQFqWk | 2510 | |
| Joe Bonamassa Inspired Guitar Lick - Blues Rock Guitar Lessons - Speed Building | This is the recording of a guitar lesson video. There is a male instructor first performing the tune and then describing what he is playing. The tune is being played on a clean sounding electric guitar and there is a blues feel to it. The atmosphere is easygoing. The parts the male voice is not heard can be sampled for use in beat-making. | 2011-06-01T23:23:19Z | GuitarJamz | My Technique and review channel http://www.youtube.com/youcanlearnguitar Joe Bonamassa Inspired Guitar Lick - Blues Rock Guitar Lessons - Speed Building Excercise marty schwartz lesson against rise electric metal picking steve play "guitar lesson" chords gilbert sweep improvisation guitarist solos beginner learn acoustic tab jazz scales jam instrumental guitars "electric guitar" minor classical "guitar lessons" | ["Electric guitar", "Guitar", "Music", "Musical instrument", "Speech", "Electronic tuner", "Plucked string instrument"] | ["guitar lesson", "male voice", "electric guitar", "clean sound", "blues", "easygoing"] | 9 | YDh36ZdneAU | 3266 | |
| JC-120 Roland Jazz Chorus Amp | This is the recording of a gear showcase. There is a male voice advertising an effect amp. The distorted electric guitar is playing a crunchy-sounding riff with the added effect of the chorus amp. The atmosphere is hard-hitting. Some parts of this recording could be used in heavy guitar samples for beat-making. Such parts could also work in sections of an advertisement jingle. | 2007-03-13T06:13:47Z | nikmarkmedia | Johnny DeMarco and Gary Lenaire Show you the Amazing Powers of the Legendary Roland Jazz Chorus JC-120 | ["Electric guitar", "Guitar", "Heavy metal", "Music", "Musical instrument", "Rock music", "Speech", "Progressive rock", "Grunge", "Plucked string instrument"] | ["gear showcase", "jam", "male voice", "advertising", "distorted electric guitar", "guitar solo", "amp", "chorus", "hard-hitting", "crunchy"] | 9 | hRQJgZVxRX0 | 4103 | |
| Behringer RSM guitar FX pedals review - DW400 Dynamic Wah / Human Voice | This is a gear showcase jam. There is a male voice talking in between the sounds giving information about a reverb pedal. There is an electric guitar playing random tunes with the reverb effect. The tunes in the recording are simple. Sounds from this recording could be sampled for use in beat-making. | 2010-01-27T15:36:51Z | dancetech | Behringer RSM guitar FX pedals review - DW400 Dynamic Wah / Human Voice | ["Echo", "Effects unit", "Electric guitar", "Guitar", "Music", "Musical instrument", "Speech", "Plucked string instrument", "Distortion"] | ["jam", "instrumental", "single instrument", "male voice", "instructive", "electric guitar", "guitar solo", "effect pedal", "reverb", "simple tunes"] | 9 | n179cK8EubU | 4510 | |
| PRS 30th Anniversary Custom 24 electric guitar review demo | This clip features a guitar song. An overdriven guitar is struck at the beginning. This is followed by an electric guitar strumming two chords once each. The chords are strummed with a light overdrive sound. There are no other instruments in this song. A male voice talks in a narrative tone at the end of the segment. | 2015-02-19T14:56:55Z | Guitarist | Reviewed in Guitarist issue 391 Gear demos playlist: http://goo.gl/30cAf Subscribe for more from Guitarist: http://goo.gl/2PRXE Buy Guitarist magazine in print and digital forms: http://www.myfavouritemagazines.co.uk/content/lp/digitalbundles/mm-guitarist/ Visit our website: http://www.guitarist.co.uk Facebook: http://www.facebook.com/guitaristmagazine Twitter: http://www.twitter.com/Guitarist_Mag | ["Reverberation", "Electric guitar", "Guitar", "Music", "Musical instrument", "Speech", "Plucked string instrument"] | ["guitar song", "overdriven guitar", "male voice", "narration", "electric guitar", "instructional clip", "no percussion", "no other instrument"] | 0 | vOiDwXo-SuM | 5180 |
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;