musiccaps_details (view)
2 rows where musiccaps_aspects contains "relaxing", musiccaps_names contains "Music" and musiccaps_names contains "Rock music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 34 ✖
- groovy bass line 2
- guitar lead 2
- relaxing · 2 ✖
- adventurous 1
- amateur playing 1
- amateur rock band 1
- ambient music 1
- casual rock 1
- chill-out music 1
- classic rock influences 1
- classic rock instrumental 1
- classic rock playlist 1
- distortion guitar accompaniment 1
- driving song 1
- echo tones 1
- filler music 1
- high on adrenaline 1
- high spirits 1
- home music video 1
- home recording 1
- instrumental music 1
- keyboard harmony 1
- memdium tempo 1
- modern pop 1
- never give up 1
- out of time 1
- passionate 1
- poor audio quality 1
- rhythm guitar 1
- slow tempo 1
- song cover 1
- spirited 1
- steady drumming rhythm 1
- steady rock drumming 1
musiccaps_names (array) 10 ✖
- Music · 2 ✖
- Rock music · 2 ✖
- Blues 1
- Distortion 1
- Electric guitar 1
- Heavy metal 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 |
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;