musiccaps_details (view)
2 rows where musiccaps_aspects contains "aggressive", musiccaps_aspects contains "hard rock" and musiccaps_names contains "Rock music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- aggressive · 2 ✖
- hard rock · 2 ✖
- acoustic drums 1
- addictive 1
- bass guitar 1
- chainsaw 1
- distorted bass guitar 1
- down sweep 1
- echoing electric guitar licks 1
- electric guitar 1
- energetic 1
- hard-hitting 1
- live performance 1
- male vocal 1
- punchy kick 1
- punchy snare 1
- repetitive filtered male vocal 1
- shimmering hi hats 1
- shouting 1
- wide aggressive electric guitar chords 1
musiccaps_names (array) 8 ✖
- Music 2
- Rock music · 2 ✖
- Chainsaw 1
- Drum 1
- Grunge 1
- Guitar 1
- Heavy metal 1
- Musical instrument 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
GODZILLA 1998 / Puff Daddy Feat. Jimmy Page - Come With Me (Morello Mix) | The Hard Rock song features a repetitive filtered male vocal over shimmering hi hats, down sweep, wide aggressive electric guitar chords, distorted bass guitar, echoing electric guitar licks, punchy kick and punchy snare hits. It sounds energetic, aggressive and addictive. | 2009-03-23T02:05:43Z | sideskroll | A track from the "Come With Me" single by Puff Daddy and Jimmy Page for the GODZILLA 1998 movie. With Tom Morello producing it, playing guitar and bass. If you liked this movie go to http://www.godzilla1998.org where you can find some interesting info about the movie and join other people who enjoyed the film. [b]Download MP3 Track[/b] Puff Daddy Feat. Jimmy Page - Come With Me (Morello Mix): http://www.megaupload.com/?d=XU7YGDSI Password: sideskroll | ["Music", "Rock music", "Grunge"] | ["hard rock", "shimmering hi hats", "wide aggressive electric guitar chords", "distorted bass guitar", "echoing electric guitar licks", "repetitive filtered male vocal", "punchy kick", "punchy snare", "down sweep", "energetic", "aggressive", "addictive"] | 4 | KKgYvcfrxj4 | 2074 | |
Front row! Jackyl 'The Lumberjack Song' live in concert in California! Enjoy! NAMM | This is the live performance of a hard rock piece. There is a male vocal who is shouting at the crowd while revving up a chainsaw. The electric guitar is playing the melody while the bass guitar is playing in the background. The acoustic drums are playing a simple blues rock beat. The atmosphere is aggressive. | 2012-01-23T22:46:42Z | pasha28dio | Filmed at the 'Grove in Anaheim' during NAMM 2012 at the 3rd Annual Dean Guitars Namm Jamm. You just have to love any song that has a chainsaw solo. :-) Testament and Static X also played. Great night of jams. | ["Chainsaw", "Drum", "Guitar", "Heavy metal", "Music", "Musical instrument", "Rock music"] | ["hard rock", "live performance", "male vocal", "shouting", "electric guitar", "bass guitar", "acoustic drums", "chainsaw", "hard-hitting", "aggressive"] | 9 | MQ1Q7xydJPU | 2265 |
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;