musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "danceable" and musiccaps_names contains "Grunge" sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- danceable · 2 ✖
- energetic 2
- bass guitar 1
- bravado 1
- distorted electric guitar 1
- electric guitar 1
- electric guitar solo 1
- electroclash 1
- groovy 1
- happy 1
- male vocal 1
- no vocals 1
- positive 1
- powerfull 1
- repeated theme 1
- rock&roll 1
- upbeat 1
- upbeat drum kit 1
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 | |
Whip Ass Gaming: Twisted Metal Gameplay Demo | The song is a rock track that features distorted and energetic guitar strumming chords. A secondary guitar does a solo melody in the foreground. A drum kit plays a typical upbeat rock pattern with an energetic mood. A bass adds deepness to the track while playing the same progression as the strummed guitar. | 2008-05-09T21:11:29Z | Belpowerslave | The video gameplay demo showing off various levels and cars. Please note that this is *video* of gameplay footage, and most of the issues you'll see with the graphics are the fault of the low quality encode on the disc. | ["Music", "Grunge"] | ["rock&roll", "no vocals", "distorted electric guitar", "energetic", "electric guitar solo", "upbeat drum kit", "danceable", "happy", "positive", "powerfull"] | 5 | fxdWwzdeY_o | 3994 |
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;