musiccaps_details (view)
1 row where musiccaps_aspects contains "bravado", musiccaps_aspects contains "electric guitar", musiccaps_aspects contains "energetic" and musiccaps_names contains "Music"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Black Strobe - I'm A Man | This is an electroclash piece. There is a male vocalist singing in the lead with hollering samples in the background. An electric guitar is playing the main theme repeatedly. The bass guitar is playing a groovy bass line. In the rhythmic background, there is an upbeat acoustic drum beat. The piece is groovy and danceable. It could be playing in the background at a sports bar or a rock bar. The music would also suit well with sports venues. | 2007-06-29T16:46:49Z | The Arkive | Check out the Top of the Pops playlist here ➤ https://bit.ly/2F8np11 Black Strobe (sometimes Blackstrobe) is an electroclash group formed in Paris in 1997 by producer Arnaud Rebotini and DJ Ivan Smagghe. They were instrumental in the rise of the electroclash movement in the UK with their breakthrough single "Me and Madonna". Originally producing in the house genre, they later became more influenced by music from the 1970s and 1980s, especially industrial post-punk and European electronic body music. They are heavily influenced by acts such as Cabaret Voltaire, Nitzer Ebb, Front 242, and Depeche Mode. | ["Music", "Grunge"] | ["electroclash", "male vocal", "electric guitar", "repeated theme", "bass guitar", "groovy", "danceable", "energetic", "bravado", "upbeat"] | 9 | LbPRGDwlfqs | 2206 |
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;