musiccaps_details (view)
2 rows where musiccaps_aspects contains "metal" and musiccaps_aspects contains "vital" sorted by musiccaps_caption
This data as json, CSV (advanced)
musiccaps_aspects (array) 33 ✖
- animated 2
- fast tempo 2
- hard rock 2
- metal · 2 ✖
- rock 2
- vigorous 2
- vital · 2 ✖
- youthful 2
- animated electric guitar accompaniment 1
- captivating keyboard harmony 1
- dance groove 1
- dance music 1
- electronic music 1
- energetic 1
- enthusiastic 1
- enthusiastic vocals 1
- funky bass line 1
- groovy bass line 1
- hard hitting drums 1
- heavy metal 1
- intense drumming 1
- intense electric guitar feedback 1
- male singer 1
- male vocalist 1
- progressive 1
- progressive metal 1
- skilled guitarist 1
- spirited 1
- spirited vocals 1
- vibrant 1
- vigorous bass lines 1
- vigorous keyboard harmony 1
- vivacious 1
musiccaps_names (array) 4 ✖
- Music 2
- Angry music 1
- Exciting music 1
- Heavy metal 1
video | youtube_link | musiccaps_caption ▼ | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
I Prevail - Stuck In Your Head (Official Music Video) | A male vocalist sings this enthusiastic Rock song. The tempo is fast with bright drumming, enthusiastic electric guitar harmony, keyboard accompaniment , groovy bass line. The song is youthful, enthusiastic, energetic, vital, vigorous and passionate rock. | 2016-10-22T16:00:46Z | IPrevailBand | Stream ‘TRUE POWER’ - https://found.ee/iptruepower Get Official I Prevail merch - https://found.ee/tp_merch "Stuck In Your Head" taken from the album 'Lifelines' available now. ITUNES: http://smarturl.it/IPlifelines Video by Drew Russ. http://drewruss.com/ Follow I Prevail: Website: https://found.ee/ip_web Facebook: https://found.ee/ip_facebook Twitter: https://found.ee/ip_twitter Instagram: https://found.ee/ip_instagram TikTok: https://found.ee/ip_tiktok Spotify: https://found.ee/ip_spotify Apple Music: https://found.ee/ip_applemusic Stay Connected with Fearless Records: Website: http://www.fearlessrecords.com/ Facebook: https://found.ee/FearlessFB Instagram: https://found.ee/FearlessIG Twitter:https://found.ee/FearlessTW Subscribe to Fearless Records on Youtube: http://found.ee/fr_youtube LYRICS: You’re not the one I want in my bed But I’m gonna be the song stuck in your head Stuck in your head Stuck in your head Guess what? For the record you’re the broken one Tried to sing along but we got stuck So we turn it over and over again But now, a thousand scratches on the song we held A million cuts finally wore it down Couldn’t turn it over and over again Turn it over and over again This’ll be the last time that I spin our life Never gonna play again You’re not the one I want in my bed I’m not the song you want in your head This’ll be the last time that I spin our life Never gonna play again You’re not the one I want in my bed But I’m gonna be the song stuck in your head Stuck in your head Guess what? Didn’t wanna have to write these words Now you’re on the other side reversed Never turning over and over again So now, I’ll turn it off cuz it’s so damn loud All your lies finally wore me down You can skip our track, cuz I’m not coming back This’ll be the last time that I spin our life Never gonna play again You’re not the one I want in my bed I’m not the song you want in your head This’ll be the last time that I spin our life Never gonna play again You’re not the one I want in my bed But I’m gonna be the… | ["Music", "Exciting music"] | ["male singer", "fast tempo", "rock", "hard rock", "metal", "heavy metal", "hard hitting drums", "animated electric guitar accompaniment", "groovy bass line", "captivating keyboard harmony", "enthusiastic vocals", "youthful", "electronic music", "dance music", "energetic", "enthusiastic", "spirited", "animated", "vigorous", "vital", "dance groove"] | 7 | 5keRbrVx-G4 | 690 | |
Avantasia - Wastelands (Michael Kiske) | A male vocalist sings this high energy Rock song. The tempo is fast with enthusiastic and skilled bass guitar lines, intense, hard hitting drums, groovy electric guitar accompaniment and rhythmic keyboard. The song is youthful, animated, spirited, animated,vigorous, incredibly vital and vivacious. This song is Hard Rock/ Progressive metal. | 2010-03-24T12:02:47Z | Artem Reva | The new edition of Tobias Sammet's AVANTASIA will be released as two separate albums entitled "The Wicked Symphony" and "Angel Of Babylon". Status: Ready to be release. Record deal: Nuclear Blast Records. Album scheduled for release in April 3rd 2010. The Japanese edition on 31th March. Michael sings on "Stargazers", "Wastelands", "Runaway Train" and "Promised Land". | ["Heavy metal", "Music", "Angry music"] | ["male vocalist", "fast tempo", "hard rock", "vigorous bass lines", "youthful", "animated", "vigorous", "vital", "vivacious", "progressive", "metal", "progressive metal", "intense electric guitar feedback", "intense drumming", "funky bass line", "vigorous keyboard harmony", "spirited vocals", "rock", "hard rock", "skilled guitarist", "youthful", "vibrant"] | 7 | JRmfjBDKCpE | 2006 |
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;