musiccaps_details (view)
1 row where musiccaps_aspects contains "gurtural vocals", musiccaps_aspects contains "hard rock" and musiccaps_aspects contains "heavily distorted aggressive electric guitar"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Solemn Promise - Leave The Rats Behind | The heavy metal music features a guttural male voice. The sound is aggressive and energetic. The background has a dark tonality that contrasts the heavily distorted guitars that strum chords. An aggressive drum kit plays a common heavy metal beat in the background. This is a song you could hear at a monster truck show. | 2013-10-14T19:37:15Z | SolemnPromiseMusic | Get Solemn Promise's debut EP 'Worse Than Death' DOWNLOAD (name your price / free): http://www.solemnpromise.bandcamp.com PHYSICAL COPY / MERCH: http://www.solemnpromise.bigcartel.com LYRICS: Eyes burn green. Staring at me. Get what you earn. You want what you can't have. You're too weak to carry the weight of your words. Your teeth are blunt and blunt teeth don't dig deep. This is true heart, you have no heart. A poison mouth and glare won't stop me. So clear out your mouth and avert your eyes. Leave the rats in the sewer like the filth they are. You're on higher ground. Leave the rats behind. Say it to my fucking face. Sever the tongue and burn the roots. Eyes burn green. Get what you earn. Leave the fucking rats behind, leave you in the fucking dust. Your words mean nothing. FACEBOOK: http://www.facebook.com/SolemnPromiseMusic TWITTER: http://www.twitter.com/SolemnPromise BANDCAMP: http://www.solemnpromise.bandcamp.com BIGCARTEL: http://www.solemnpromise.bigcartel.com | ["Heavy metal", "Music", "Progressive rock", "Grunge"] | ["heavy metal", "hard rock", "aggressive drum kit", "heavily distorted aggressive electric guitar", "dark ambience background", "gurtural vocals", "dark", "energetic", "mid tempo"] | 5 | Wu-Oh9OJIlI | 3146 |
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;