musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "energetic", musiccaps_aspects contains "groovy" and musiccaps_aspects contains "upbeat"
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- bass guitar 2
- electric guitar 2
- energetic · 2 ✖
- groovy · 2 ✖
- male vocal 2
- upbeat · 2 ✖
- acoustic drums 1
- bravado 1
- danceable 1
- electroclash 1
- repeated theme 1
- rimshots 1
- rock-n-roll 1
- simple tune 1
- story-telling mood 1
musiccaps_names (array) 4 ✖
- Music 2
- Grunge 1
- Rock and roll 1
- Ska 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Blue devils - Mystery girl | This is a rock-n-roll music piece. There is a male vocalist singing as if he is telling a story in the lead. The electric and the bass guitar are playing a simple tune. The acoustic drums are playing an upbeat rhythm with a heavy use of rimshots. The atmosphere of the piece is groovy. This piece could be used in the soundtrack of a romance/romantic comedy movie where the protagonist cannot stop thinking about a girl. | 2008-09-10T20:16:30Z | Tage_ | ["Music", "Ska", "Rock and roll"] | ["rock-n-roll", "male vocal", "story-telling mood", "electric guitar", "simple tune", "bass guitar", "acoustic drums", "rimshots", "upbeat", "energetic", "groovy"] | 9 | D6xrH93lnoc | 1437 | ||
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;