musiccaps_details (view)
1 row where musiccaps_aspects contains "distortion guitars", musiccaps_aspects contains "twin guitars", musiccaps_author = 0 and musiccaps_names contains "Progressive rock"
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 |
---|---|---|---|---|---|---|---|---|---|---|
A Message Made By Knife - Stolen Heartbeat (NEW SONG 2014) | This heavy metal song features a high pitched male voice. This is accompanied by percussion playing an aggressive metal beat. The kick drum plays double kicks matching the picking pattern of the guitars. The distortion guitars play twin parts. One guitar plays the low parts while the other plays the same riff at a higher octave. The bass guitar follows the distortion guitars and plays the notes from the same riffs but ending earlier than the guitars. This song has a romantic theme. This song can be played in a superhero movie. | 2014-05-16T05:05:38Z | michishige kaito | Download the track here: https://www.dropbox.com/s/ovrhy9eby1oawdt/A%20Message%20Made%20By%20Knife%20-%20Stolen%20Heartbeat.mp3 BAND PAGE: https://www.facebook.com/ammbkOFFICIAL LYRICS: Searching for a, beat in my chest but I've said it enough, a hole a missing pieces can't full this , glass up face in the mirror, that cracked I've found out Tried to believe her (but I've said it enough, said it enough..) A cut so deep (with a stolen heartbeat, stolen heartbeat) Chorus: The day she dropped me as I sleep, I drink and make up when the heavens open up for them and I, I think I could kill her the day she dropped me as I sleep I drink and make up when heavens open up . For them!!! The night comes... out waiting for my dreams to catch you up and feeling Im the only one... The night comes! (gang shout) Out!. waiting for my, dreams to catch you up and feeling Im the only! (gang shout) One!. We're in the surface of madness and selfishness!! the word forgiveness makes me wonder how!! I am the prison in this cold heart!! give me the rain, for me to start!! (repeat chorus till fade) | ["Heavy metal", "Music", "Punk rock", "Progressive rock", "Grunge"] | ["heavy metal song", "high pitched male voice", "distortion guitars", "twin guitars", "aggressive guitars", "aggressive percussion", "bass guitar", "romantic theme"] | 0 | z9hRQiJMnIw | 5461 |
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;