musiccaps_details (view)
1 row where musiccaps_aspects contains "medium-to-high pitch male vocal", musiccaps_aspects contains "optimistic" and musiccaps_names contains "Zing"
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 |
---|---|---|---|---|---|---|---|---|---|---|
The Eden Project - Times Like These | This is a pop music piece. There is a medium-to-high pitch male vocal singing melodically in the lead. The melody is being played by the strings and the piano. There is a loud but simple electronic drum beat in the rhythmic background. The piece is in major key, so there is an optimistic aura. The piece could be used in the soundtracks of teenage dramas. It could also work well in an advertisement jingle. | 2015-05-04T14:14:21Z | TheGrandWhiteFox | Become a part of our pack, subscribe! http://goo.gl/n2ESRs » http://www.thegrandwhitefox.com ● Free Download https://www.facebook.com/TheEdenProjectOfficial/posts/882464298493614 ● Background Image http://wolfsecho.deviantart.com/art/Sunrise-hunter-476535368 ● The Eden Project https://soundcloud.com/eden-mcmxcv ● Art by Wolfsecho http://wolfsecho.deviantart.com ● TheGrandWhiteFox - Where Music Meets Art » http://www.facebook.com/thegrandwhitefox » https://twitter.com/grandwhitefox These videos are made to promote music and art. For business inquiries and submissions: http://www.thegrandwhitefox.com/contact The Eden Project - Times Like These - "The Grand White Fox" --------------------------------------------------------------------- ● LYRICS It's been a long long time We've come a long long way No i can't see the finish line Scared half to death but that's ok It's been a long long night After a long long day My body's aching but i know somehow My feet will find a way So i'll sing it loud In the silence And give the best of me Till its alright But not over I will find fight Like a soldier coming home In the silence But i have never felt so free The futures so bright This is our time I'mma live it how i dream It's been a long long time time Since I've seen sunlight through the rain Since I've felt love or truth, its strange But i left bliss back where i came And i wont lie It's taken so long to feel ok And now the world is screaming out for more But i don't feel the same But we'll be alright Cos it's all we know And it's only change Sun sets on the old But we're nocturnal anyway And this is how we know It'll be ok These are the times we will hold When our memories fade Cos it's all we know And it's only change Sun sets on the old But we're nocturnal anyway And this is how we know It'll be ok These are the times we will hold These are the times we will hold In the silence When I've given all of me And it's alright That it's over And I've found fight Like a soldier coming home In the silence But i ha… | ["Music", "Zing"] | ["pop music", "medium-to-high pitch male vocal", "melodic singing", "electronic drums", "strings", "piano", "bass", "optimistic", "passionate", "emotional"] | 9 | ROM--1yVra8 | 2696 |
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;