musiccaps_details (view)
2 rows where musiccaps_aspects contains "percussion's", musiccaps_aspects contains "uptempo", musiccaps_author = 6 and musiccaps_names contains "Rattle (instrument)"
This data as json, CSV (advanced)
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 | |
Dream Team - Stir It Up | Someone is playing a very fat drum with a slightly open hi hat along with other people playing percussion with a lot of snare hits and a bass sound playing on every beat along with the kick. A keyboard is playing string chords. A male voice is singing/shouting with delay and reverb. This song may be playing at a celebration event. | 2012-10-19T04:22:07Z | XclusiveGoGo (Old Channel) | XclusiveGoGo Website - http://xclusivegogo.net/unlimited/ Subscribe to our 2nd Channel - https://www.youtube.com/channel/UC_3F9RuRO_TrWw8NEAFTxiQ Add us on Google Plus - https://plus.google.com/u/0/b/101715502406950546736/+XclusiveGoGo Like Us On Facebook - https://www.facebook.com/XclusiveGoGo Follow Us On Twitter - https://twitter.com/XclusiveGoGo_ Check our music out on SoundCloud - https://soundcloud.com/xclusivegogo Follow Us on Instagram - http://instagram.com/xclusivegogo Like, Comment, Share, & Subscribe | ["Music", "Rattle (instrument)"] | ["dance/folk", "acoustic drums", "percussion's", "male voice singing", "keyboard strings", "uptempo", "happy mood"] | 6 | ZkfKOLp5SxU | 3408 |
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;