musiccaps_details (view)
3 rows where musiccaps_aspects contains "cheerful", musiccaps_aspects contains "conga" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 61 ✖
- cheerful · 3 ✖
- conga · 3 ✖
- catchy 2
- dance groove 2
- fast tempo 2
- foreign language 2
- happy 2
- synthesiser arrangement 2
- upbeat 2
- world music 2
- accordion harmony 1
- afro beats 1
- akuba 1
- animated 1
- bongos 1
- bright drumming 1
- buoyant 1
- carefree 1
- clave 1
- colourful 1
- complex harmonies 1
- contemporary traditional music 1
- dominant music 1
- electric guitar 1
- electronic reggae 1
- flute melody 1
- folk music 1
- folk song 1
- groovy bass 1
- hand percussion 1
- happy merry 1
- high-spirited 1
- inspirational 1
- instrumental 1
- latin folk 1
- lively 1
- male singer 1
- male vocalist 1
- medium fast tempo 1
- middle eastern music 1
- nigerian music 1
- party song 1
- peppy 1
- pleasant 1
- polyrhythms 1
- propulsive percussion 1
- psychedelic 1
- reflective 1
- reggae 1
- regional music 1
- saxophone 1
- steady bass line 1
- steel pan 1
- syncopated 1
- trombone 1
- trumpets 1
- ugandan song 1
- upstroke rhythm guitar 1
- vivacious 1
- vivid 1
- youthful 1
musiccaps_names (array) 5 ✖
- Music 3
- Music of Africa 2
- Afrobeat 1
- Dance music 1
- Ska 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Simo Issaoui 2008 by WWW.TOP2008.NEW.FR**05** | A male vocalist sings this upbeat song in a foreign language. The tempo is medium fast with a very perky and bouncy beat. The song is happy, cheerful, groovy, simple light and catchy with middle eastern music influences. This song is a contemporary Folk song. | 2008-07-17T18:21:13Z | jamalyoussef2010 | Simo issaoui issawi hyooh nachat guercif jamal youssef super_jamal@hotmail.fr | ["Music of Africa", "Music"] | ["male vocalist", "medium fast tempo", "foreign language", "buoyant", "peppy", "happy", "cheerful", "middle eastern music", "upbeat", "catchy", "synthesiser arrangement", "conga", "hand percussion", "steady bass line", "flute melody", "folk song", "regional music"] | 7 | XCQMJXkI5bA | 3166 | |
Sitya Loss Remix - Eddy Kenzo | A male vocalist sings this energetic Nigerian song. The tempo is fast and upbeat with keyboard harmony and Afro beats of conga, clave, drums and akuba. The music is upbeat, catchy, spirited, energetic, youthful and pulsating with a dance groove. This song is a Reggae song. | 2014-02-20T13:25:19Z | Eddy Kenzo | big talent young managment | ["Afrobeat", "Music of Africa", "Music", "Dance music"] | ["male singer", "fast tempo", "nigerian music", "world music", "propulsive percussion", "upstroke rhythm guitar", "dominant music", "pleasant", "catchy", "youthful", "dance groove", "happy", "cheerful", "carefree", "conga", "clave", "akuba", "bright drumming", "reggae", "ugandan song", "foreign language", "afro beats", "reggae", "inspirational", "reflective"] | 7 | Xaq-segSEsQ | 3200 | |
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;