musiccaps_details (view)
2 rows where musiccaps_aspects contains "groovy bass", musiccaps_aspects contains "synthesiser arrangement" and musiccaps_names contains "Music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 44 ✖
- fast tempo 2
- groovy bass · 2 ✖
- synthesiser arrangement · 2 ✖
- accordion harmony 1
- alternative/indie 1
- animated 1
- bongos 1
- catchy beat 1
- cheerful 1
- colourful 1
- compelling 1
- complex harmonies 1
- conga 1
- contemporary traditional music 1
- dance groove 1
- electric guitar 1
- electronic reggae 1
- energetic 1
- enthusiastic 1
- enthusiastic keyboard harmony 1
- folk music 1
- groovy basslines 1
- happy merry 1
- high-spirited 1
- indie pop 1
- infectious drumming 1
- instrumental 1
- latin folk 1
- lively 1
- male voclaist 1
- new music 1
- party song 1
- polyrhythms 1
- psychedelic 1
- saxophone 1
- steel pan 1
- syncopated 1
- tambourine beats 1
- trombone 1
- trumpets 1
- upbeat 1
- vivacious 1
- vivid 1
- world music 1
musiccaps_names (array) 3 ✖
- Music · 2 ✖
- Ska 1
- Soul music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Wild Cub - Thunder Clatter lyrics on screen | A male vocalist sings this upbeat pop. The tempo is fast with synthesiser arrangements, hard hitting drums, groovy bass, tambourine beats ,keyboard harmony and choral harmony. The song is an upbeat, catchy , compelling, persuasive, enthusiastic and youthful Indie Pop. | 2013-07-19T08:34:53Z | Brown Leather Wallet | Song from the Bose advert. Enjoy. Dont own the rights to the music. | ["Music", "Soul music"] | ["male voclaist", "fast tempo", "groovy bass", "indie pop", "enthusiastic keyboard harmony", "tambourine beats", "synthesiser arrangement", "infectious drumming", "groovy basslines", "alternative/indie", "new music", "compelling", "enthusiastic", "energetic", "catchy beat"] | 7 | 4jzr88nEdCM | 598 | |
Ondatrópica - Punkero Sonidero | This music is an upbeat instrumental. The tempo is fast with a plethora of instruments like trumpets, congas, bongos, steel drum, accordion,saxophone, keyboard,and electric guitar. The music is perky, buoyant, high spirited, enthusiastic, energetic with complex harmonies. This music is a contemporary take in Traditional Latin folk music. | 2012-06-29T08:59:31Z | Soundway Records | Artist: Ondatrópica Title: Punkero Sonidero Album: Punkero Sonidero Conceived by Colombian musician Mario Galeano, the force behind the band Frente Cumbiero, and English producer Will 'Quantic' Holland, Ondatrópica brings together an all-star cast representing both the classic and modern styles of la musica Colombiana. Label Website: http://www.soundwayrecords.com https://www.facebook.com/SoundwayRecords http://soundcloud.com/soundway-records https://twitter.com/#!/soundway Click here to subscribe to Soundway Records - http://www.bit.ly/sub2soundway MUSIC FROM PLANET EARTH: PAST, PRESENT & FUTURE Soundway Records was conceived in 2002 by label owner Miles Cleret whilst returning from Ghana with a hoard of dusty old 45s and LPs that had mostly not been heard outside the former Gold Coast since their original release. Planned on a whim the trip was not one of the carefully planned research expeditions that Miles would later embark on to any number of far-flung tropical destinations. On the contrary he left England with no idea of what he might find or that it might be the start of a career in the record business. Although the label has it's roots in West Africa the scope has grown to include many other parts of the tropical belt with the aim of making available recordings that have in most cases never been available outside of their original countries and often not even there for over 30 years. Over the years Soundway's modus operandi has been to approach the music from a different angle from many of the more established "World Music" labels. By focusing on more obscure artists as well as big names and often concentrating on progressive recordings more in sync with Cleret's generation and background in DJ culture and dance-music. Styles have included afro-beat, funk, highlife, ethio-jazz, molam, calypso, cumbia, champeta, biguine, latin-jazz and disco as well as many unclassifiable recordings. Since 2012 Soundway has begun releasing new material from a carefully selected handful of contemporary recording … | ["Music", "Ska"] | ["instrumental", "fast tempo", "trumpets", "complex harmonies", "syncopated", "electronic reggae", "synthesiser arrangement", "folk music", "latin folk", "world music", "accordion harmony", "psychedelic", "party song", "dance groove", "contemporary traditional music", "trombone", "conga", "bongos", "steel pan", "saxophone", "electric guitar", "groovy bass", "upbeat", "cheerful", "happy merry", "polyrhythms", "animated", "high-spirited", "lively", "colourful", "vivid", "vivacious"] | 7 | mcAsO331Z9s | 4482 |
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;