musiccaps_details (view)
5 rows where musiccaps_aspects contains "fast tempo", musiccaps_aspects contains "shakers" and musiccaps_names contains "Music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 80 ✖
- fast tempo · 5 ✖
- shakers · 5 ✖
- enthusiastic 3
- bouncy 2
- buoyant 2
- dance music 2
- foreign language 2
- lively 2
- male vocalists 2
- simple 2
- tambourine beats 2
- acordion harmony 1
- amateur recording 1
- ambient outdoor sounds 1
- animated acoustic guitar rhythm 1
- animated piano 1
- bass drums 1
- bustling 1
- catchy 1
- celebratory 1
- cello 1
- cheerful 1
- clapping 1
- club music 1
- dance groove 1
- dance pop 1
- deep house 1
- digital drums 1
- digital music 1
- duet 1
- earnest singing 1
- electronic music 1
- energetic 1
- engaging 1
- enthusiastic vocal backup 1
- enthusiastic vocals 1
- female vocalisation 1
- festive 1
- folk dance 1
- folk music 1
- folk song 1
- funky bass line 1
- funky bass lines 1
- gig 1
- groovy 1
- hand drums 1
- hand percussion 1
- hand percussions 1
- happy 1
- hard hitting drums 1
- instrumental 1
- keyboard harmony 1
- live performance 1
- lively keyboard harmony 1
- lively singing 1
- male singer 1
- melodic 1
- outdoor singing 1
- people talking 1
- peppy 1
- poor audio quality 1
- pop 1
- punchy 1
- regional music 1
- regional pop 1
- regional song 1
- rhythmic acoustic guitar 1
- simple joys 1
- smal hand drum 1
- spirited 1
- spirited drumming 1
- stringed instrument harmony 1
- sunny 1
- synthesiser arrangements 1
- tambourine 1
- tambourine used as hand drum 1
- techno music 1
- world music 1
- xylophone 1
- youthful 1
musiccaps_names (array) 10 ✖
- Music · 5 ✖
- Musical instrument 3
- Rattle (instrument) 3
- Music of Africa 2
- Ska 2
- Bowed string instrument 1
- Jazz 1
- Mantra 1
- Singing 1
- Ukulele 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Per Andersson ''Pump up the Jam'' (Så ska det låta 2012) | This song is a lively duet by two male voices. The tempo is fast with amplified piano, infectious drumming; tambourine beats and synthesiser arrangements. The song is youthful,fun, happy, groovy, energetic, buoyant, and high spirited. This song is called Deep House. | 2012-12-31T17:35:29Z | Theboxen21 | Per Andersson ''Pump up the Jam'' (Så ska det låta 2012) | ["Music", "Ska"] | ["male vocalists", "duet", "fast tempo", "electronic music", "spirited", "buoyant", "club music", "dance music", "dance pop", "techno music", "digital music", "synthesiser arrangements", "deep house", "lively", "youthful", "shakers", "digital drums", "lively singing"] | 7 | 6-MdbipzKS0 | 712 | |
watra safi | This music is an energetic instrumental. The tempo is fast with a regional string instrument playing the lead with hand percussion like a small hand drum, tambourine and shaker beats. The music is lively, cheerful, happy, youthful, buoyant, enthusiastic, sunny and celebratory with a peppy dance groove. This music is Folk dance music. | 2011-12-31T18:18:01Z | watrasafi2012 | ["Music of Africa", "Music", "Musical instrument", "Rattle (instrument)"] | ["instrumental", "fast tempo", "tambourine beats", "peppy", "enthusiastic", "happy", "cheerful", "simple", "celebratory", "festive", "simple joys", "sunny", "bouncy", "folk music", "regional music", "folk dance", "stringed instrument harmony", "hand drums", "shakers"] | 7 | FAhfuP_xh5Y | 1620 | ||
Mahlathini & The Mahotella Queens - Mbaqanga (1991) | A male vocalist sings this upbeat song in a foreign language. The tempo is fast with a lively keyboard harmony, spirited drumming, funky bass line, rhythmic acoustic guitar, shakers enthusiastic vocal backup and clapping. The song is upbeat, high-spirited, energetic, buoyant, cheerful, peppy, happy and groovy. This song is a lively Pop song. | 2007-12-30T19:14:10Z | NickLotay | Music video to one of the group's hit songs, "Mbaqanga", from 1991. Featuring the late, great 'groaner' Simon Mahlathini Nkabinde, the everlasting Mahotella Queens (left to right: Nobesuthu Shawe, Hilda Tloubatla, Mildred Mangxola), and the unstoppable backing band Makgona Tsohle Band. Original music video with improved soundtrack. | ["Music of Africa", "Music", "Ska"] | ["male singer", "fast tempo", "foreign language", "rhythmic acoustic guitar", "groovy", "dance music", "dance groove", "pop", "shakers", "lively keyboard harmony", "spirited drumming", "funky bass line", "enthusiastic vocal backup", "clapping", "keyboard harmony", "tambourine beats", "catchy", "punchy", "bouncy", "buoyant", "energetic", "enthusiastic", "pop", "regional pop", "world music"] | 7 | TEWYFkjH2jc | 2822 | |
HESTER GOODMAN...HAT SONG.. | This song is an animated vocalisation. The tempo is fast with a lively piano accompaniment, accordion harmony, cello rhythm, hard hitting drums, groovy bass lines, hand percussion beats and xylophone. The music is upbeat, energetic,enthusiastic, high-spirited and vivacious. This is a live performance with ambient sounds of people talking and general bustling. The audio quality is inferior. This song is a live Pop. | 2010-10-21T17:54:37Z | spaceritual72 | ...HAT SONG.....from "you could at least smile" album launch night...by HESTER GOODMAN..available at.......www.ukuleleorchestra.com | ["Singing", "Jazz", "Music", "Musical instrument", "Rattle (instrument)", "Ukulele"] | ["female vocalisation", "fast tempo", "cello", "hand percussion", "bass drums", "xylophone", "hard hitting drums", "animated piano", "shakers", "funky bass lines", "amateur recording", "live performance", "gig", "poor audio quality", "people talking", "bustling", "acordion harmony", "enthusiastic vocals"] | 7 | qXSG2uq2tNw | 4795 | |
SINCHI WAIRA. MANTRA SUMA AMBIWASKA | A group of male vocalists sing this folk song in a foreign language. The tempo is fast with minimalist instruments like a lively acoustic guitar harmony, shakers and tambourine beat;The vocals are energetic, youthful, earnest, cheerful , happy, simple and chirpy. | 2013-04-23T07:17:55Z | Daniel Ortega | Poderoso mantra de sanación. Taita John Muchavisoy, Nicolas Lozada y Cristiam Herrán. Centro de sanación SINCHI WAIRA. | ["Mantra", "Music", "Musical instrument", "Rattle (instrument)", "Bowed string instrument"] | ["male vocalists", "fast tempo", "foreign language", "tambourine", "tambourine used as hand drum", "animated acoustic guitar rhythm", "hand percussions", "shakers", "smal hand drum", "folk song", "regional song", "outdoor singing", "ambient outdoor sounds", "engaging", "lively", "simple", "earnest singing", "enthusiastic", "melodic"] | 7 | qbIPQGY8RRA | 4800 |
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;