musiccaps_details (view)
4 rows where musiccaps_aspects contains "dance music" and musiccaps_aspects contains "folk music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 67 ✖
- dance music · 4 ✖
- folk music · 4 ✖
- happy 2
- 8 stringed instrument 1
- accordion player 1
- acoustic guitar 1
- acoustic guitar accompaniment 1
- ambient crowd noise 1
- animated 1
- animated percussions 1
- bright 1
- bright violin 1
- celebration 1
- cheerful 1
- chirpy 1
- dance 1
- electronic drums 1
- emphatic vocals 1
- energetic 1
- enthusiastic 1
- ethnic instruments 1
- fast tempo 1
- flute playing 1
- folk pop 1
- folk song 1
- foreign language 1
- groovy bass line 1
- guitar playing 1
- gypsy music 1
- high notes 1
- home studio 1
- instrumental 1
- instrumental harmony 1
- instrumental music 1
- jam session 1
- jovial 1
- life is good 1
- live jam 1
- live performance 1
- lively 1
- lively mandolin 1
- lute family 1
- male singer 1
- male vocal 1
- mandolin 1
- mandolin harmony 1
- medium tempo 1
- melancholic 1
- melodic singing 1
- merry 1
- nostalgic moments 1
- people enjoying the music 1
- percussion 1
- playful 1
- plucking 1
- pop 1
- pop hits 1
- regional pop 1
- relaxing 1
- remix 1
- soprano string instrument 1
- spirited 1
- string harmony 1
- stringed instruments 1
- sunny 1
- world music 1
- youthful 1
musiccaps_names (array) 10 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Θα κάνω φασαρία-Γιαννούλης Βαζαίος | A male vocalist sings this animated song in a foreign language. The tempo is fast with a bright applied violin accompaniment, lively drumming, groovy bass line, tambourine beats, rhythmic mandolin and acoustic guitar accompany net. The song is lively, energetic, vibrant, happy, vivacious and merry with a dance groove. This song is a Folk Pop/Regional Pop. | 2010-06-29T13:03:59Z | mike gr | από το cd ''να μαστε πάλι[πιτσιρίκα]'' | ["Jingle (music)", "Music"] | ["male singer", "fast tempo", "regional pop", "folk pop", "emphatic vocals", "foreign language", "bright violin", "energetic", "animated percussions", "lively mandolin", "acoustic guitar", "groovy bass line", "folk song", "folk music", "world music", "pop", "pop hits", "youthful", "dance music", "celebration", "merry", "happy"] | 7 | 40D4L5Ndi6k | 529 | |
Old Joe Clark - Mandolins | This music is instrumental . The tempo is fast with mandolins playing a lively, spirited rhythmic harmony with acoustic guitar accompaniment. The instrumentation is minimal with emphasis on the mandolin melody. The music is chirpy, perky, cheerful, happy, animated and spirited. | 2011-09-09T13:52:59Z | pstewart0831 | Bluegrass Mandolin Class impromptu jam Lyrics: 1. Old Joe Clark, the preacher's son Preached all over the plain The only text he ever knew Was high low jack and the game [Chorus] Fare thee well Old Joe Clark Fare thee well I'm bound Fare thee well Old Joe Clark Goodbye Betsy Brown 2. Old Joe Clark had a mule His name was Morgan Brown And every tooth in that mule's head Was sixteen inches round Chorus 3. Old Joe Clark had a yellow cat She would neither sing nor pray Stuck her head in a buttermilk jar And washed her sins away Chorus 4. Old joe clark had a house Fifteen stories high And every story in that house Was filled with chicken pie Chorus 5. I went down to Old Joe's house He invited me to supper I stumped my toe on the table leg And stuck my nose in the butter Chorus | ["Acoustic guitar", "Music", "Mandolin", "Musical instrument", "Plucked string instrument"] | ["instrumental", "mandolin", "mandolin harmony", "stringed instruments", "8 stringed instrument", "string harmony", "lute family", "soprano string instrument", "high notes", "plucking", "lively", "cheerful", "happy", "sunny", "chirpy", "bright", "animated", "spirited", "dance music", "folk music", "acoustic guitar accompaniment"] | 7 | D-p9s8y2z_U | 1427 | |
Vp Premier - Ring Bang Ring Bang - Soca Chutney Remix Volume 3 | This is a remix of an Indian folk music piece. There is a male vocalist singing melodically and passionately. The rhythmic background is full of percussive elements that were emphasized by the use of electronic drums. The atmosphere is lively and jovial. This piece could be played in dance parties and also in contemporary dancing courses as an accompaniment piece. | 2010-08-23T13:20:23Z | Vp Premier | Vp Premier - Soca Chutney Remix Volume 3 - 2006 1. Snake In Meh Bed 2. Mor Tor 3. More Rum For Me 4. Royie Royie 5. Shaadi Kare 6. Mousie 7. Doo Doo Darling 8. Yam Baka Bana 9. Bhojay D' Lawa 10. Dhaiya Peegai 11. Ah Going To Rock You 12. Playing With Me Heart 13. Jhulanah Jhulaway 14. Cat Lick Deh Butter 15. Married Once 16. Rozeena 17. For Cane 18. Run Fuh Meh Life 19. Lollipop 20. Rajin Jheem Jheem Jhoom 21. I Ain't Ride No Bicycle | ["Folk music", "Music", "Song"] | ["folk music", "dance music", "remix", "male vocal", "melodic singing", "electronic drums", "percussion", "dance", "playful", "jovial"] | 9 | _mQ6KuA2p6k | 3488 | |
"Eu Quero é Sossego", de K-Ximbinho, com Nonato Lima e Grupo Murmurando.mp4 | The song is an instrumental. The tempo is medium with an accordion player, guitar rhythm, flute player and other percussion playing in harmony. The song is groovy and has gypsy flavour to it. The song audio quality is poor with ambient crowd noises. | 2013-01-24T15:01:39Z | claudeide | Programa Brasileirinho, 20 de Janeiro de 2013 - Acordeonista Nonato Lima toca a música "Eu Quero é sossego", de K-Ximbinho, acompanhado pelo Quinteto Murmurando. | ["Wind instrument, woodwind instrument", "Accordion"] | ["accordion player", "life is good", "relaxing", "jam session", "home studio", "melancholic", "nostalgic moments", "people enjoying the music", "instrumental harmony", "folk music", "flute playing", "guitar playing", "live jam", "instrumental music", "medium tempo", "ambient crowd noise", "enthusiastic", "dance music", "gypsy music", "folk music", "ethnic instruments", "dance music", "live performance"] | 1 | tbovKStEnME | 5051 |
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;