musiccaps_details (view)
1 row where musiccaps_aspects contains "distorted bass guitar", musiccaps_names contains "Grunge" and musiccaps_names contains "Rock music"
This data as json, CSV (advanced)
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 |
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;