musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "danceable", musiccaps_aspects contains "electric guitar" and musiccaps_aspects contains "upbeat"
This data as json, CSV (advanced)
musiccaps_aspects (array) 23 ✖
- danceable · 3 ✖
- electric guitar · 3 ✖
- upbeat · 3 ✖
- bass guitar 2
- male vocal 2
- acoustic drums 1
- bravado 1
- dj 1
- dub 1
- electroclash 1
- electronic 1
- electronic drums 1
- energetic 1
- groovy 1
- keyboard 1
- lively 1
- raspy voice 1
- reggae 1
- repeated theme 1
- ska punk 1
- spanish language 1
- tropical 1
- turntable 1
musiccaps_names (array) 4 ✖
- Music 3
- Grunge 1
- Ska 1
- Tambourine 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 | |
Maskatesta - Castillos de Juguete [This Is Ska] | This is a ska punk music piece. There is a male vocalist with a raspy voice singing in the Spanish language. The keyboard and the electric guitar are playing the melody while there is a bass guitar playing in the background. The rhythm consists of fast tempo acoustic drum beats. The atmosphere is lively. This piece can be played at sports venues. | 2010-08-11T05:34:43Z | REBORracho7 | Esta es una de las rolas del nuevo disco de la maskatesta... This Is Ska!!! | ["Music", "Ska"] | ["ska punk", "male vocal", "raspy voice", "spanish language", "electric guitar", "keyboard", "bass guitar", "acoustic drums", "lively", "danceable", "upbeat"] | 9 | nyLpME6YH20 | 4597 | |
ADDICTED KRU SOUND on SoulJah Sessions Radio | This is an electronic DJ set in the style of Jamaican reggae music. There is a DJ performing over a track that has a groovy beat being played by the electric guitar and the electronic drums. There is a tropical atmosphere. Samples could be lifted from this recording to be used in the beat-making. | 2007-09-19T01:45:21Z | Steve B | SoulJah Sessions Radio CJIQ 88.3 fm 09-15-07 featuring special guest "AKS" | ["Music", "Tambourine"] | ["electronic", "reggae", "dub", "dj", "turntable", "electric guitar", "electronic drums", "tropical", "danceable", "upbeat"] | 9 | wXWpkfGfZD8 | 5272 |
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;