musiccaps_details (view)
4 rows where musiccaps_aspects contains "bouncy", musiccaps_aspects contains "enthusiastic" and musiccaps_aspects contains "keyboard harmony"
This data as json, CSV (advanced)
musiccaps_aspects (array) 74 ✖
- bouncy · 4 ✖
- energetic 4
- enthusiastic · 4 ✖
- keyboard harmony · 4 ✖
- dance music 3
- fast tempo 3
- punchy 3
- youthful 3
- buoyant 2
- club music 2
- dance groove 2
- funky bass line 2
- male singer 2
- pop 2
- world music 2
- acoustic guitar accompaniment 1
- animated piano 1
- brass band 1
- brass instruments 1
- bright trumpet 1
- catchy 1
- clapping 1
- congas 1
- crowd cheering 1
- crowd hooting 1
- digital drum arrangement 1
- dj 1
- drum machine 1
- engaging 1
- enthusiastic drumming 1
- enthusiastic vocal backup 1
- female singer 1
- foreign language 1
- fresh 1
- fresh punchy 1
- funk rap 1
- funky 1
- gig 1
- groovy 1
- groovy bass lines 1
- hip-hop 1
- hip-hop hits 1
- latin dance music 1
- latin folk 1
- latin music 1
- latin pop 1
- live performance 1
- lively keyboard harmony 1
- lively piano 1
- lucid vocals 1
- male vocalist 1
- medium tempo 1
- passionate 1
- perky vocals 1
- punk rap 1
- rap 1
- recurring beat 1
- regional pop 1
- rhythmic acoustic guitar 1
- rhythmic patter 1
- rhythmic speech 1
- shakers 1
- slick drumming 1
- sound of chatter 1
- spanish guitar 1
- spirited 1
- spirited drumming 1
- synth articulation 1
- tambourine beats 1
- upbeat 1
- upbeat groove 1
- vibrant 1
- vigorous 1
- vocal backup 1
musiccaps_names (array) 10 ✖
- Music 4
- Hip hop music 1
- Music of Africa 1
- Music of Latin America 1
- Rapping 1
- Salsa music 1
- Singing 1
- Ska 1
- Soul music 1
- Vocal music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Sallie Ford and the Sound Outside at The Crystal Ballroom 5-23-09 | A female vocalist sings this perky pop. The tempo is medium with rhythmic acoustic guitar , groovy bass lines, keyboard accompaniment and enthusiastic drumming. The song is simple, dulcet, fresh, peppy, youthful, vibrant and punchy with sounds of crowd hooting and cheering and talking. This song is a Pop song. | 2009-05-27T05:02:05Z | ConcordKurve | Great video of Sallie Ford and the Sound Outside singing "Not an animal" at the Crystal Ballroom. They opened for the Avett Brothers on May 22 and 23, 2009. | ["Singing", "Music", "Soul music", "Vocal music"] | ["female singer", "medium tempo", "club music", "keyboard harmony", "lucid vocals", "enthusiastic", "live performance", "energetic", "slick drumming", "spirited", "crowd cheering", "sound of chatter", "gig", "upbeat groove", "punchy", "fresh", "crowd hooting", "perky vocals", "acoustic guitar accompaniment", "funky bass line", "slick drumming", "keyboard harmony", "funky", "youthful", "fresh punchy", "bouncy", "pop"] | 7 | I-Z3gB6pfIA | 1859 | |
Hadiya Deville..Make it Ping Pong...mpg | A male vocalist sings this spirited hip-hop. The tempo is fast with synthesiser articulation, digital drum arrangements and vocal backup. The music is a youthful , enthusiastic, bouncy, punchy rhythmic patter with a dance groove. This song is contemporary Hip-Hop/ Rap. | 2011-11-26T16:20:24Z | Loc Deville | This is a Must See Video..2 Year old Hadiya Shaheed..aka Hadiya Deville..Rocks Out, to her Fathers New Single ''Make it Ping Pong''.. ---Talent is in the D.N.A..--SEE FOR YOUR SELF :) | ["Music", "Rapping", "Hip hop music"] | ["male vocalist", "fast tempo", "hip-hop", "rap", "bouncy", "punchy", "funk rap", "punk rap", "rhythmic patter", "rhythmic speech", "engaging", "passionate", "energetic", "enthusiastic", "vocal backup", "recurring beat", "youthful", "keyboard harmony", "digital drum arrangement", "drum machine", "synth articulation", "vocal backup", "dance groove", "dj", "club music", "dance music", "hip-hop hits"] | 7 | QBMM1ocXkhY | 2602 | |
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 | |
Toño Rosario-El Hot Dog | A male vocalist sings this lively Latino song. The tempo is fast with an animated piano accompaniment, bright trumpets, energetic and rhythmic drumming, groovy bass and keyboard. The song is energetic, lively, buoyant, bouncy, vibrant and vivacious with a dance groove. This song is Latin Pop. | 2011-09-18T02:16:01Z | TheBombers27 | ["Music", "Music of Latin America", "Salsa music"] | ["male singer", "fast tempo", "brass band", "brass instruments", "vibrant", "animated piano", "youthful", "buoyant", "bouncy", "enthusiastic", "energetic", "vigorous", "latin music", "bright trumpet", "groovy bass lines", "keyboard harmony", "enthusiastic drumming", "spanish guitar", "upbeat", "latin pop", "latin dance music", "latin folk", "lively piano", "world music", "congas", "dance music", "latin pop"] | 7 | vMU7ZKY2Eso | 5174 |
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;