musiccaps_details (view)
1 row where musiccaps_aspects contains "animated electric guitar accompaniment", musiccaps_aspects contains "hard rock", musiccaps_aspects contains "heavy metal" and musiccaps_author = 7
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 |
---|---|---|---|---|---|---|---|---|---|---|
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 |
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;