musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "shimmering hi hats" and musiccaps_aspects contains "wide aggressive electric guitar chords" sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- aggressive 2
- distorted bass guitar 2
- energetic 2
- punchy snare 2
- shimmering hi hats · 2 ✖
- wide aggressive electric guitar chords · 2 ✖
- addictive 1
- down sweep 1
- echoing electric guitar licks 1
- guitar slide 1
- hard rock 1
- instrumental 1
- low quality 1
- punchy kick 1
- repetitive filtered male vocal 1
- shimmering open hat 1
- soft kick hit 1
musiccaps_names (array) 5 ✖
- Music 2
- Grunge 1
- Heavy metal 1
- Progressive 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 |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Matt Ragan - Bundle of Clang | The low quality recording features wide aggressive electric guitar chords, shimmering hi hats and open hats, punchy snare, soft kick hits and distorted bass guitar. Right before the "drop", there is a short guitar slide, leading perfectly into it. The instrumental sounds energetic and aggressive. | 2010-09-14T19:28:23Z | Alfa Scighera | Need for Speed Hot Pursuit 2 Soundtrack Bundle of Clang by Matt Ragan, featured on Need for Speed Hot Pursuit 2. All rights belong to Matt Ragan. | ["Heavy metal", "Music", "Progressive rock"] | ["low quality", "wide aggressive electric guitar chords", "guitar slide", "shimmering hi hats", "shimmering open hat", "punchy snare", "soft kick hit", "distorted bass guitar", "instrumental", "energetic", "aggressive"] | 4 | acEHGV7Gq6U | 3557 |
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;