musiccaps_details (view)
2 rows where musiccaps_aspects contains "crunchy", musiccaps_aspects contains "electric guitar" and musiccaps_aspects contains "instrumental" sorted by youtube_channel
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- acoustic drums 2
- crunchy · 2 ✖
- electric guitar · 2 ✖
- instrumental · 2 ✖
- aggressive 1
- bass guitar 1
- blues 1
- electropop 1
- groovy 1
- guitar solo 1
- hard-hitting 1
- live performance 1
- loud 1
- slow tempo 1
- synth-pop 1
musiccaps_names (array) 9 ✖
- Music 2
- Blues 1
- Electric guitar 1
- Guitar 1
- Musical instrument 1
- Plucked string instrument 1
- Punk rock 1
- Rock music 1
- Strum 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel ▼ | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Josh Gooch: Guitar Center King of the Blues '09 Finalist | This is the live performance of a blues music piece. It is an instrumental performance. The lead electric guitar is playing a blues solo while another electric guitar and a bass guitar are playing in the background. The rhythmic background consists of a slow tempo blues acoustic drum beat. There is a groovy atmosphere to this performance. This piece could be playing in the background at a rock bar. | 2010-02-05T23:29:42Z | Guitar Center | Guitar Center King of the Blues finalist, Josh Gooch's performance from the GC King of the Blues Grand FInals - Nov 12th, 2009 at the House of Blues Sunset. For more information on Guitar Center or King of the Blues visit www.guitarcenter.com | ["Blues", "Electric guitar", "Guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument"] | ["live performance", "blues", "instrumental", "electric guitar", "guitar solo", "bass guitar", "acoustic drums", "groovy", "crunchy", "slow tempo"] | 9 | 4bXb6GLm6zg | 589 | |
Kraftwerk - Heavy Metal Kids | This is an electropop/synth-pop music piece. It is an instrumental piece. There is a crunchy sounding electric guitar tune at the forefront. The rhythmic background consists of an aggressive acoustic drum beat. The atmosphere is hard-hitting. This piece could be playing in the soundtrack of a coming-of-age drama movie. | 2007-10-31T01:56:54Z | kraftneu | A live rarity from the early days of Kraftwerk. Recorded live for Radio Bremen in June 1971, whilst Ralf Hutter was taking a 6 month brief break from the band, and instead features the Rother/Dinger/Schneider line up. This is a very hard rocking krautrock number. Featuring: FLORIAN SCHNEIDER - flute with effects. MICHAEL ROTHER - guitar. KLAUS DINGER - drums. Pre - Neu! days and this track gives a taster of what was to come from Neu! in the future. Eventually Dinger and Rother would leave KRAFTWERK to form NEU!. Later on in the year Ralf Hutter would rejoin KRAFTWERK and electronic history would be made there after. Reason that Ralf Hutter did NOT participate during this brief moment of the band (late 1970-mid 1971)is apparently he wanted to complete his Studies. Since mid-1971 Hutter was back. It is rumoured that a drummer called Charley Weiss and a bassist/cellist (now an artist) Eberhard Krannemann also collaborated around this time, but not on this recording at least. Sadly Klaus Dinger died in March 2008. | ["Music", "Punk rock", "Rock music"] | ["electropop", "synth-pop", "instrumental", "electric guitar", "acoustic drums", "loud", "aggressive", "crunchy", "hard-hitting"] | 9 | tw8-TlQBcBA | 5080 |
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;