musiccaps_details (view)
1 row where musiccaps_aspects contains "electric guitar lead and harmony", musiccaps_aspects contains "vibrant", musiccaps_aspects contains "voracious" 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 |
---|---|---|---|---|---|---|---|---|---|---|
Truth Be Told "Let It Go" Official Music Video | A male vocalist sings this vigorous Rock song. The tempo is fast with enthusiastic electric guitar lead and harmonies, electric bass guitar and hard hitting drumming with cymbal rides. The song is passionate, youthful, enthusiastic, intense, compelling, boisterous and vigorous. This song is a Hard Rock/Heavy Metal song. | 2012-10-04T18:11:26Z | TruthBeToldProject | Produced by: FlareSoul Entertainment Group Directed by Norberto Peña (http://www.npenaphoto.com) Truth Be Told www.Facebook.com/TruthBeToldProject Twitter: @TruthBeToldProj Official Release on iTunes, Spotify, AmazonMp3 on 10/25/12 Lyrics: A total change of mind A total change of life Its necessary to achieve these goals to reach, the desires of our heart. So much sacrifice Wasting money and time Left so many things behind Hope this is, Hope this is worth our while NO! We won't lose our faith, no we won't! So we let it go, let it go Fearless and committed Cause we gotta, go gotta go Find that place where we belong Losing all, winning all Find the purpose, of our, lives Hope this is worth our while Maybe loosing some friends so far from our loved ones Working hard Can't be left behind Using all, using all our might Giving what we are We put together all our strength Hope this is, Hope this is worth our while Be strong and courageous. Do not be frightened; do not be dismayed, for the Lord your God will be with you wherever you go So we let it go, let it go Cause we gotta, go gotta go Losing all, winning all Losing all, winning all All Rights Reserved by Truth Be Told --------------------------------------------------------------------- Additional Tags: Victory Records, Facedown Records, Tooth And Nail, Come & Live, Universal, Lyrics, Metal Blade, Road Runners, Indie, Post Punk, Post Hardcore | ["Music", "Punk rock", "Progressive rock", "/t/dd00032"] | ["male vocalist", "energetic drumming", "loud electric guitar feedback", "electric guitar lead and harmony", "enthusiastic vocal backup", "youthful", "enthusiastic", "energetic", "vibrant", "boisterous", "voracious", "intense", "passionate", "metal", "hard rock", "rock music", "heavy metal", "electric bass guitar"] | 7 | 3nbB3F-OdSM | 501 |
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;