musiccaps_details (view)
4 rows where musiccaps_aspects contains "instrumental", musiccaps_names contains "Punk rock" and musiccaps_names contains "Rock music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 35 ✖
- instrumental · 4 ✖
- acoustic drums 1
- aggressive 1
- backdoor shuffle 1
- bass 1
- bass riff 1
- blues rock 1
- crunchy 1
- distorted bass guitar 1
- distortion guitar 1
- electric bass 1
- electric guitar 1
- electropop 1
- energetic 1
- guitar lick 1
- guitar riff 1
- hard rock 1
- hard-hitting 1
- imbalanced 1
- loud 1
- low quality 1
- moderate tempo 1
- muffled 1
- no voice 1
- overdriven electric guitar 1
- power trio 1
- punchy snare 1
- rock 1
- rock drums 1
- shimmering hi hats 1
- swung rhythm 1
- synth-pop 1
- upbeat song 1
- uptempo kick pattern 1
- wide electric guitars chord progressions 1
musiccaps_names (array) 7 ✖
- Music 4
- Punk rock · 4 ✖
- Rock music · 4 ✖
- Blues 1
- Progressive rock 1
- Psychedelic rock 1
- Rock and roll 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Rat Race - Seminal Rats | The low quality recording features a rock song that consists of wide electric guitar chord progressions, distorted bass guitar, shimmering hi hats, uptempo kick pattern and punchy snare. This instrumental sounds a bit muffled and imbalanced in volume, as the guitars are really loud, but it is very energetic regardless. | 2008-12-31T23:39:53Z | Seminalrats | On the occasion of the 10th. anniversary of the death of Mick Weber. | ["Music", "Punk rock", "Psychedelic rock", "Rock music", "Progressive rock"] | ["rock", "low quality", "wide electric guitars chord progressions", "distorted bass guitar", "shimmering hi hats", "uptempo kick pattern", "punchy snare", "imbalanced", "energetic", "instrumental", "muffled"] | 4 | 9dBWFEpcJIo | 1030 | |
Led Zeppelin - Rock and Roll (Madison Square Garden 1973) | This hard rock song features a distortion guitar playing aggressive riffs. This is accompanied by a rock percussion playing a simple rock beat with a roll at the end. The bass guitar plays the root notes of the chord with a flourish to move to the subsequent note. There are no voices in this song. This is an instrumental song. | 2011-11-30T15:18:24Z | Led Zeppelin | Watch Led Zeppelin perform their song 'Rock And Roll' live at Madison Square Garden in New York City in July 1973 from The Song Remains the Same. The Song Remains the Same has been reissued with audio remastered by Jimmy Page! Order your copy here https://lnk.to/TSRTS More info about this show: http://www.ledzeppelin.com/show/july-... ► Listen to Mothership https://lnk.to/StreamMothership ♪ Watch all episodes of Led Zeppelin History https://lnk.to/LedZeppelinHistoryID 🕭 Subscribe to the Led Zeppelin channel https://lnk.to/YTLedZeppelinSubID Official Led Zeppelin Playlists: ☑ Led Zeppelin - Essentials https://lnk.to/YTLedZeppelinEssentialsID 📽 The Led Zeppelin Rare Film Series https://lnk.to/LedZeppelinRareFilmID 🎚 Led Zeppelin - Alternative Mixes & Deep Cuts https://lnk.to/LedZeppelinAltMixID Stay Connected with Led Zeppelin: ♪ Website http://www.ledzeppelin.com 🎛 Facebook http://www.facebook.com/ledzeppelin 🎙 Twitter http://www.twitter.com/ledzeppelin 🎞 Instagram https://www.instagram.com/ledzeppelin --------------------------------------------------------------------------------------------------------------------- The Led Zeppelin channel is the band’s official YouTube home, featuring a catalog of official live performances, official music videos, Led Zeppelin History, archival footage, and Zeppelin-approved playlists. 🕭 Subscribe to join the Led Zeppelin YouTube community and check back for new uploads, product announcements, and updates from the band Led Zeppelin formed in 1968 and went on to become one of the most influential, innovative, and successful groups in modern music, having sold more than 300 million albums worldwide. The band rose from the ashes of The Yardbirds, when Jimmy Page brought in John Bonham, John Paul Jones, and Robert Plant to tour as The New Yardbirds. In 1969, Led Zeppelin released its self-titled debut which was produced by Page, as were all the subsequent albums. It marked the beginning of a 12-year reign, during which the group was widely considered to be the … | ["Music", "Punk rock", "Rock music"] | ["hard rock", "distortion guitar", "guitar lick", "no voice", "instrumental", "rock drums", "bass", "moderate tempo", "upbeat song"] | 0 | XgXOW3lX25Y | 3212 | |
BACK DOOR SLAM 'ComeHome' live rehearsal | A blues rock power trio with electric bass and overdriven electric guitar playing a riff together and the drummer playing a backdoor shuffle. It is instrumental with a swung rhythm. | 2007-05-10T16:49:48Z | Christy DeHaven | Filmed at Shabby Road Studios Isle of Man. | ["Blues", "Music", "Punk rock", "Rock music", "Rock and roll"] | ["blues rock", "overdriven electric guitar", "guitar riff", "bass riff", "backdoor shuffle", "electric bass", "instrumental", "power trio", "swung rhythm"] | 8 | nP05Sf4Fgac | 4535 | |
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;