musiccaps_details (view)
3 rows where musiccaps_aspects contains "guitar lead" and musiccaps_names contains "Rock music" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 48 ✖
- guitar lead · 3 ✖
- groovy bass line 2
- instrumental music 2
- passionate 2
- relaxing 2
- spirited 2
- adrenaline rush 1
- adventurous 1
- amateur playing 1
- amateur rock band 1
- ambient music 1
- bad audio quality 1
- casual rock 1
- chill-out music 1
- classic rock influences 1
- classic rock instrumental 1
- classic rock playlist 1
- cymbals crashing 1
- distorted guitar rhythm 1
- distortion guitar accompaniment 1
- driving song 1
- echo tones 1
- fast metal drumming 1
- fast tempo 1
- filler music 1
- groovy rhythm 1
- heavy metal music 1
- high on adrenaline 1
- high spirits 1
- home music video 1
- home recording 1
- keyboard accompaniment 1
- keyboard harmony 1
- memdium tempo 1
- modern pop 1
- never give up 1
- out of time 1
- percussive bass line 1
- poor audio quality 1
- rebellious 1
- rhythm guitar 1
- slow tempo 1
- song cover 1
- song ending 1
- song fade 1
- steady drumming rhythm 1
- steady rock drumming 1
- youthful 1
musiccaps_names (array) 11 ✖
- Music 3
- Rock music · 3 ✖
- Heavy metal 2
- Angry music 1
- Blues 1
- Distortion 1
- Electric guitar 1
- New-age music 1
- Progressive rock 1
- Punk rock 1
- Steel guitar, slide guitar 1
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
My Grandfather's Clock with tabs | The song is an instrumental. The song is medium tempo with an electric guitar playing lead and distorted guitar rhythm, along with groovy bass line and rock drumming rhythm. The song is exciting and spirited. The song is a classic rock instrumental with poor quality audio. | 2007-08-16T21:36:56Z | Rockaholick1 | This video got mirrored when I recordet it! I do not play a left-handed guitar in this video!! Sponsored by Dean Markley inc.: http://www.deanmarkley.com/ If you like what you hear then SUBSCRIBE, as I probably will be releasing more material soon! For tabs and backing track, go here: http://kabudono01.s344.xrea.com/download_ookina/ A SPECIAL THANKS TO ALL WHO LEAVE A COMMENT AND RATING! A pure Rock N' Roll song for all the Rockaholics out there! Played with the amazing Gibson Custom EDS-1275! | ["Blues", "Heavy metal", "Music", "Punk rock", "Rock music", "Progressive rock"] | ["instrumental music", "guitar lead", "spirited", "song cover", "passionate", "home music video", "high spirits", "never give up", "adventurous", "classic rock playlist", "relaxing", "driving song", "distortion guitar accompaniment", "rhythm guitar", "classic rock instrumental", "memdium tempo", "groovy bass line", "steady rock drumming", "high on adrenaline", "poor audio quality"] | 1 | Lrhy2auO6hY | 2226 | |
Relaxation Music Progressive Rock | The song is an instrumental music piece. The song is slow tempo with an electric guitar playing lead with heavy echoes, steady drumming and a keyboard harmony. The song is casual and slightly out of rhythm. The song is an instrumental with a casual listening vibe. | 2011-10-11T06:06:56Z | Gothenburg Music | Relaxation Music Progressive Rock, Rock jam and improvisation | ["Electric guitar", "New-age music", "Music", "Rock music", "Steel guitar, slide guitar", "Distortion"] | ["slow tempo", "guitar lead", "steady drumming rhythm", "filler music", "relaxing", "home recording", "chill-out music", "modern pop", "classic rock influences", "amateur rock band", "ambient music", "groovy bass line", "echo tones", "relaxing", "out of time", "amateur playing", "keyboard harmony", "casual rock"] | 1 | UrgzGbGVV8I | 2948 | |
W.A.S.P. - My Tortured Eyes LYRICS | The song is an instrumental. The tempo is fast with a fast metal drumming rhythm, complete with cymbal crashes, distorted guitar lead, guitar playing rhythm, and percussive bass line. The song is a death metal song ending with a bad audio quality. | 2011-08-19T16:13:10Z | nagito11 | ["Heavy metal", "Music", "Rock music", "Angry music"] | ["heavy metal music", "instrumental music", "fast metal drumming", "distorted guitar rhythm", "keyboard accompaniment", "instrumental music", "fast tempo", "groovy rhythm", "cymbals crashing", "song fade", "song ending", "passionate", "adrenaline rush", "spirited", "youthful", "rebellious", "bad audio quality", "guitar lead", "percussive bass line"] | 1 | nbb8vmfjHJs | 4563 |
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;