musiccaps_details (view)
2 rows where search matches "guitar" and musiccaps_aspects contains "metal song"
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- metal song · 2 ✖
- bassline 1
- car door closing 1
- car door opening 1
- car starting 1
- distortion guitar 1
- electric guitar riff 1
- engine choking 1
- low quality recording 1
- male voice 1
- metallic guitar 1
- moderate tempo 1
- multiple guitars 1
- out of time guitar 1
- overdriven electric guitar 1
- power drumming 1
- rock music 1
- sports car engine whirring 1
musiccaps_names (array) 6 ✖
- Music 2
- Guitar 1
- Musical instrument 1
- Plucked string instrument 1
- Roll 1
- Rumble 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Hail The Villain - Take Back The Fear [OFFICIAL VIDEO] | The clip starts off with a series of sound effects that indicate that a person is stepping into a car and starting the engine. The car is a powerful sports car. The person then turns on the music and we hear a metallic, overdriven electric guitar riff that's suitable for a song that's a sub-genre of rock and roll. | 2010-04-23T21:46:31Z | Roadrunner Records | Hail The Villain's video for 'Take Back The Fear' off the album Population: Declining - available now on Roadrunner Records. Download now on iTunes: http://smarturl.it/htv-popdeclining LYRICS What I believe is all that I am. Take it away, I'm only a man back from the dead and now it appears. I'll be the one to take back the fear. Kill or be killed, that isn't me. Maybe it's you dying to be somebody else. Man of the year, but I am the one to take back the fear. Someone who take it away! [Don't want anything] taken away! [Don't want anything] taken away! [Don't want anything] Taken away from me it's all that I believe. [Don't want anything] taken away! [Don't want anything] taken away! [Don't want anything] Taken away from me it's all that I believe. Message of hate, fading away. My love and my failures: "one in the same". Now that I'm back, painfully clear, I'll be the one to take back the fear. Someone who take it away! [Don't want anything] taken away! [Don't want anything] taken away! [Don't want anything] Taken away from me it's all that I believe. [Don't want anything] taken away! [Don't want anything] taken away! [Don't want anything] Taken away from me... When it seems that everything is all a dream. Everything's not what it seems. Even I cannot believe in me easily. [Don't want anything] taken away! [Don't want anything] taken away! [Don't want anything] Taken away from me it's all that I believe. [Don't want anything] taken away! [Don't want anything] taken away! [Don't want anything] Taken away from me... When it seems that everything is all a dream. Everything's not what it seems. Even I cannot believe in me easily. [Don't want anything] taken away! [Don't want anything] taken away! [Don't want anything] Taken away from me it's all that I believe. | ["Music", "Rumble"] | ["car door opening", "car door closing", "engine choking", "car starting", "sports car engine whirring", "metal song", "electric guitar riff", "metallic guitar", "overdriven electric guitar", "rock music"] | 3 | TCRxCAYyduo | 2821 | |
Guitar Hero | This clip features 2 distortion guitars playing a metal song. A high pitched male voice sings the main melody. This is accompanied by percussion playing a simple rock beat in common time. A bass guitar plays a bassline with a descending run. The distortion guitars play power chords followed by a guitar lick. One of the guitars plays one chord a little after the other guitar making it sound dissonant. This song can be played in an action movie. | 2006-04-25T16:32:40Z | Kim Burkart | Two Dudes Playing Guitar Hero | ["Guitar", "Music", "Musical instrument", "Roll", "Plucked string instrument"] | ["low quality recording", "metal song", "distortion guitar", "multiple guitars", "bassline", "power drumming", "male voice", "out of time guitar", "moderate tempo"] | 0 | dVUgd8ot6BE | 3794 |
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;