musiccaps_details (view)
3 rows where musiccaps_aspects contains "percussion's" and musiccaps_aspects contains "pop"
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- percussion's · 3 ✖
- pop · 3 ✖
- male voice singing 2
- uptempo 2
- acoustic guitars 1
- bass 1
- chimes 1
- e-bass 1
- electric piano 1
- female choir 1
- flute sound 1
- higher register 1
- kids voices 1
- male voices singing 1
- medium to uptempo 1
- strings 1
- synth pad 1
musiccaps_names (array) 6 ✖
youtube_published (date) 3 ✖
- 2009-09-19 1
- 2013-04-01 1
- 2013-06-09 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Mingalar Doe 2013 သၾကၤန္ ရဲရဲေတာက္သံခ်ပ္ေတးမ်ား | This song is sung by a female choir and then a single male voice along with the melody of an e-piano. In the background someone is playing lower tuned percussion and some chimes and wooden sounds. This song may be playing at a band rehearsal. | 2013-04-01T16:40:19Z | kotun wai | ၂၁ၾကိမ္ ေျမာက္ အစဥ္လာမပ်က္( ဂ်ပန္) မဂၤလာဒိုး အႏုပညာအင္အားစုမွ ရဲရဲေတာက္ေတးသံခ်ပ္မ်ား စတင္ျဖန္ ့ခ်ီ .... 2013 မဂၤလာဒိုးအႏုပညာ အင္အားစု (ဂ်ပန္) အဖြဲ ့၏ရဲရဲေတာက္ေတးသံခ်ပ္မ်ား 2013ခုရဲ ့ျမန္မာျပည္ သၾကၤန္ အမွီ တင္ဆက္ေဖ်ာ္ေျဖတင္ဆက္ႏိုင္ ရန္ အတြက္ ဂ်ပန္ႏိုင္ငံေရာက္ မဂၤလာဒိုး အႏုပညာအင္အားစု မွ ႏွစ္စဥ္ က်င္းပေနၾက ဂ်ပန္ႏိုင္ငံရွိ ျမန္မာ့ ရိုးရာ သၾကၤန္ ပြဲ မ်ားတြင္ တင္ဆက္ေနက် ဒိုးပတ္သံ မ်ားျဖင့္ ႏိုင္ငံတကာေရာက္ ျမန္မာမိသားစု မ်ားႏွင့္ ျမန္မာျပည္တြင္းမွ ေအာင္ပြဲရ အမ်ိဳးသားဒီမိုကေရစီအဖြဲ ့ခ်ဳပ္ ကိုေထာက္ခံအားေပးေနေသာ မိဘျပည္သူမ်ားအတြက္ စိတ္ေသာက ကင္းေ၀း ႏိုင္ေစရန္ ႏွင့္ ဒုကၡ အေပါင္းမွ ကင္းျငိမ္းေစရန္ ရည္ရြယ္ ခ်က္ ျဖင့္ အစဥ္လာမပ်က္ တႏွစ္တေခါက္ အတို ့အထိ ရိ စရာ ေလးမ်ားႏွင့္ မွန္မွန္ေရာက္ရွိလာတဲ့ မဂၤလာဒိုး ရဲ ့သံခ်ပ္မ်ား အမ်ားျပည္သူမ်ား ေရွ့ေမွာက္သို ့ေရာက္ရွိလို ့ လာခဲ့ျပန္ပါျပီ၊၊ ယခု ႏွစ္သံခ်ပ္မ်ားကို ၊ကိုမ်ိဳးသန္ ့၊ကိုေသာင္း၊ကိုေအးမင္းကို ၊ ခင္ျငိမ္းေဆြ ႏွင့္ ကိုထြန္းေ၀တို ့မွေရးသားခဲ့ၾကျခင္း ျဖစ္ပါတယ္၊၊2013 တြင္လည္း ၁။ရိုးရာသၾကၤန္ ၂။အားလံုးေကာင္းဖို ့ေျပာင္းၾကပါ ၃။ဖားတစ္ပိုင္း ငါးတစ္ပိုင္း ၄။ရိုဟင္ဂ်ာ ၅။အမတ္မင္း ၆။မေျပာခ်င္ဘူး ၇။တိုက်ိဳသၾကၤန္နဲ ့အိတ္ေပါက္ၾကီး ၈။ဗမာစာသည္ တို ့စာ ၉။အႏုပညာစြမ္းအား ၁၀။ေခါင္းေဆာင္ေကာင္း ၁၁။ႏွစ္ကူးမဂၤလာ စသည့့္ ေတးသံခ်ပ္မ်ား ျဖင့္ ျမန္မာျပည္တြင္းမွ မိဘရဟန္းရွင္ ျပည္သူမ်ား ၾကည့္ရႈ ့ႏိုင္ေစရန္ႏွစ္စဥ္ႏွစ္တုိင္း အတာသႀကၤန္ မေရာက္ခင္မွာ သံခ်ပ္ သီခ်င္းေခြ ဗီြဒီယိုေတြ ထုတ္လုပ္ၿပီး ျပည္တြင္းနဲ႔ ႏုိင္ငံတကာကုိ ျဖန္႔ခ်ိခဲ့တာ ႏွစ္စဥ္ႏွစ္တုိင္းပင္ ျဖစ္ပါတယ္။ မူရင္း ဗီြဒီယို ေဇယ်ာေအာင္ https://soundcloud.com/htaytintnl/mingalar-doe-2013 အသံဖိုင္ ျဖစ္ပါတယ္။ | ["Music", "Rattle (instrument)"] | ["pop", "percussion's", "female choir", "male voice singing", "electric piano", "chimes", "uptempo"] | 6 | IN71kMOAk_k | 1899 | |
Arunachal Pradesh Traditional Dance and Modern Dance FUSION Music Video | A lot of percussive instruments are being played and panned to the left and right side of the speakers. A funky bassline is repeating the same pattern with fill-ins. An acoustic guitar is strumming funky chords and another guitar-like instrument is playing a melody on top. Male voices are singing in unison and kids voices are responding as backing vocals. This is an amateur recording. | 2013-06-09T04:36:31Z | cosmo z | Arunachal Pradesh Traditional Dance and Modern Dance FUSION Music Video-Song:-Nyodege Haaduku-Language:-Nyishi | ["Music of Africa", "Music", "Music of Bollywood", "Dance music"] | ["pop", "acoustic guitars", "male voices singing", "kids voices", "e-bass", "percussion's", "medium to uptempo"] | 6 | kUQ1xfK82Q0 | 4322 | |
Ax kardia mou Konstantinos Galanos.... | A male voice is singing loud and in a higher register while a flute is playing a counter melody. Percussions are playing a fast paced groove along with a soft minimalistic bass. In the background you can hear a synth pad playing chords. This song may be playing in a oriental barber shop. | 2009-09-19T19:41:52Z | Mazzika | ["Music", "Middle Eastern music"] | ["pop", "bass", "strings", "flute sound", "percussion's", "synth pad", "male voice singing", "higher register", "uptempo"] | 6 | oczJZV87k9A | 4647 |
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;