musiccaps_details (view)
2 rows where musiccaps_aspects contains "acoustic drums", musiccaps_aspects contains "crunchy" and musiccaps_aspects contains "hard-hitting"
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- acoustic drums · 2 ✖
- crunchy · 2 ✖
- hard-hitting · 2 ✖
- aggressive 1
- bass guitar 1
- clean electric guitar 1
- distorted electric guitar 1
- electric guitar 1
- electropop 1
- instrumental 1
- loud 1
- male vocals 1
- melodic singing 1
- pop punk 1
- rebellious 1
- rising pattern 1
- synth-pop 1
musiccaps_names (array) 5 ✖
- Music 2
- Exciting music 1
- Independent music 1
- Punk rock 1
- Rock music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Patent Pending: Douchebag (Official Music Video) | This is a pop punk music piece. The male vocals are singing melodically. Initially, there is a clean sounding electric guitar playing the main melody. Then, a rising pattern starts to play and the distorted electric guitar takes the place of the clean electric guitar. The bass guitar is playing in the background. The rhythm is provided by an upbeat acoustic drum beat. The atmosphere is hard-hitting. This piece can be used in the soundtrack of a teenage drama as the opening theme. | 2011-12-06T21:45:34Z | Patent Pending TV | "Douchebag" Patent Pending's Official Music Video Directed by Built By Ninjas! http://itunes.apple.com/us/album/douchebag/id455707825?i=455707833&ign-mpt=uo%3D4 New album 'Riot Hearts Rebellion' AVAILABLE NOW! Digital: http://smarturl.it/RHRDigital Physical: http://smarturl.it/RHRPhysical Catch Patent Pending supporting Simple Plan this summer in The United States: August 18 - The Intersection - Grand Rapids, MI August 19 - Bogarts - Cincinnati, Oh August 20 - Egyptian Room at Old National Centre - Indianapolis, IN August 22 - First Avenue - Minneapolis, MN August 24 - House Of Blues - Dallas, TX August 25 - House Of Blues - Houston, TX August 26 - Emo’s East - Austin, TX August 29 - Brooklyn Bowl - Las Vegas, NV August 28 - Orpheum - Flagstaff, AZ August 30 - Ace OF Spades - Sacramento, CA September 1 - Crystal Ballroom - Portland, OR September 2 - Neptune Theater - Seattle, WA September 3 - Neptune Theater - Seattle, WA | ["Music", "Independent music", "Exciting music"] | ["pop punk", "male vocals", "melodic singing", "clean electric guitar", "rising pattern", "distorted electric guitar", "bass guitar", "acoustic drums", "crunchy", "hard-hitting", "rebellious"] | 9 | 6XHdybfV5Cw | 764 | |
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;