musiccaps_details (view)
1 row where musiccaps_aspects contains "glam metal" and "youtube_published" is on date 2012-06-04
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 |
---|---|---|---|---|---|---|---|---|---|---|
Extreme - More Than Words - piano cover | This is a piano cover of a glam metal music piece. The piece is being played gently on a keyboard with a grand piano sound. There is a calming, relaxing atmosphere in this piece. It could be playing in the background at a coffee shop. | 2012-06-04T15:15:36Z | vkgoeswild | You can learn how to play some of my arrangements on flowkey: http://tinyurl.com/p3m7e37 https://www.facebook.com/pages/Viktoriya-Yermolyeva-vkgoeswild/134411767159 my FB page, with gigs announcements and stuff like that. another of my favorite songs. Very tough to cover though. I hope you'll enjoy! "It is built around acoustic guitar work by Nuno Bettencourt and the vocals of Gary Cherone (with harmony vocals from Bettencourt). Released in 1990 on the album Extreme II: Pornograffiti, the song marked a departure from the funk metal that had permeated the band's style previous to its release. The song was described by Bettencourt as a song warning that the phrase "I love you" was becoming meaningless: "People use it so easily and so lightly that they think you can say that and fix everything, or you can say that and everything's OK. Sometimes you have to do more and you have to show it -- there's other ways to say 'I love you.'" | ["Electric piano", "Keyboard (musical)", "Piano"] | ["piano cover", "glam metal", "keyboard", "piano sound", "gentle playing", "calming", "relaxing"] | 9 | R5KBk76b9HE | 2667 |
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;