musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "moderate tempo" and musiccaps_names contains "Electric guitar" sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 28 ✖
- moderate tempo · 4 ✖
- instrumental 3
- no voices 3
- amateur recording 2
- distortion guitar 2
- guitar solo 2
- alternate picking 1
- bass 1
- blues melody 1
- demo audio 1
- double bass 1
- drums 1
- electric guitar 1
- guitar 1
- harmonics 1
- instructional audio 1
- live recording 1
- low quality audio 1
- low quality music 1
- male voice 1
- no other instruments 1
- percussion 1
- rock song 1
- romantic theme 1
- slow rock 1
- string bending 1
- sweep picking 1
- vocal harmony 1
musiccaps_names (array) 11 ✖
- Electric guitar · 4 ✖
- Guitar 4
- Music 4
- Musical instrument 2
- Plucked string instrument 2
- Blues 1
- Bowed string instrument 1
- Cacophony 1
- Distortion 1
- Pulse 1
- Tick 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Tomáš Valášek - www.kytarova-skola.com, www.kytara-online.cz | This rock song features a guitar solo being played on a distortion guitar. This starts off with a string bend followed by a descending lick. A harmonic string scratch technique is played to produce a screeching sound. This is followed by a fast ascending scale run. This is accompanied by percussion playing a simple rock beat. The bass plays the root notes of the chords. There are no voices in this song. This is an instrumental. Due to the low audio quality, the instruments are not clearly heard. | 2010-04-24T08:39:01Z | kytarovaskola | www.kytara-online.cz, www.kytarova-skola.com. | ["Electric guitar", "Guitar", "Music", "Musical instrument", "Pulse", "Plucked string instrument", "Bowed string instrument"] | ["rock song", "low quality audio", "no voices", "instrumental", "distortion guitar", "guitar solo", "percussion", "bass", "harmonics", "moderate tempo", "string bending"] | 0 | CM7jMnBXw2Y | 1356 | |
burn the ground cacophony | This instrumental song features a distortion guitar playing a guitar solo. The guitar starts playing an ascending pattern followed by a sweep picking lick. This is followed by an alternate picking pattern. The ending of this solo consists of a sweep picking lick using string skipping technique. There are no other instruments in this song. There is no voice in this song. | 2007-12-17T22:20:07Z | johannflame | cacophony burn the ground jason becker marty friedman go off speed metal symphony | ["Electric guitar", "Guitar", "Music", "Cacophony", "Distortion"] | ["amateur recording", "guitar solo", "instrumental", "no voices", "alternate picking", "distortion guitar", "sweep picking", "moderate tempo"] | 0 | J0lA7ZDfPLE | 1959 | |
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 | |
Fender Blues Jr. with Clean Sound - Demo - Blues Junior | This song features an electric guitar. The guitar starts off with a descending pentatonic run. A descending slide is played followed by a moderate tempo blues lick. There are no other instruments in this song. There is no voice in this song. This is an instrumental song with a blues mood. This song can be played as an instructional blues song. | 2009-03-23T05:35:56Z | JVStratocasters | More info of JV (Japan Vintage) Stratocasters (1982~1984) at http://www.youtube.com/jvs30thanniversary (My new channel, please subscribe!) Questions? Feel free to email me at jvstratocasters@yahoo.com Fender Japan - Squier Logo JV Stratocaster 1983 - 2TS Fender Blues Jr. Amp - Blues Junior Strings - Dean Markley 10-46 | ["Blues", "Electric guitar", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["electric guitar", "amateur recording", "blues melody", "no other instruments", "demo audio", "instructional audio", "no voices", "instrumental", "moderate tempo"] | 0 | vyNstX5b1V8 | 5223 |
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;