musiccaps_details (view)
2 rows where musiccaps_aspects contains "punchy drumming", musiccaps_author = 7 and musiccaps_names contains "Dance music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 39 ✖
- buoyant 2
- fast tempo 2
- punchy drumming · 2 ✖
- youthful 2
- amateur recording 1
- bouncy 1
- catchy riff 1
- club music 1
- contemporary pop 1
- dance floor 1
- dance hits 1
- digital drumming 1
- digital music 1
- distorted sounds 1
- dj 1
- dj mixer 1
- drum machine 1
- edm 1
- electrifying 1
- electronic music 1
- energetic 1
- female singer 1
- freestyle dance 1
- groovy bass line 1
- groovy melody 1
- infectious 1
- inferior audio quality 1
- instrumental 1
- keyboard harmony 1
- lively accordion 1
- peppy 1
- pop hits 1
- pulsating 1
- simple melody 1
- spirited 1
- static 1
- synthesiser arpeggio 1
- synthesiser articulation 1
- teen pop 1
musiccaps_names (array) 8 ✖
- Dance music · 2 ✖
- Music 2
- Afrobeat 1
- Dubstep 1
- Electronic dance music 1
- House music 1
- Music of Asia 1
- Shuffle 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
เพลงแดนซ์เพราะๆ Ri'ryo music sweet love Remix-2016 HD【OFFICIAL MV】 | A female vocalist sings this groovy pop song. The tempo is fast with accordion harmony, funky bass lines, punchy drumming and keyboard accompaniment. The song is youthful, infectious, catchy, bouncy, nifty and groovy with a dance rhythm. This song is Modern pop. | 2016-01-24T12:25:52Z | ริเรียว หลงทาง | มาติดตามที่นี่เลย Ri'Ryo music (Thank for Watching Contact) https://www.facebook.com/Ri-Ryo-Music-815679285186249/ 1. move Sucker punch ชื่อภาษาไทย อีหนูดุทะลุโลก 2011 2. move The Avengers 2 ชื่อภาษาไทย ดิอเวนเจอร์ส 2015 3. move Thor 2 The Dark World ชื่อภาษาไทย เทพเจ้าสายฟ้าโลกาทมิฬ 2013 4. movie ant-man ชื่อภาษาไทย มนุษย์มดมหากาฬ 2015 5. movie Man of Steel ชื่อภาษาไทย บุรุษเหล็กซูเปอร์แมน 2013 เครดิต DJ-bOe Remixer - Sweet love 3CHA https://www.youtube.com/watch?v=d3brT7nmRHI เพลงฉบับเต็ม Liviu Hodor feat. Mona - Sweet Love จัดทำเพื่อความบันเทิงเท่านั้น By Ri'ryo music 2016 【OFFICIAL MV】 เพลงแดนซ์สนุกๆ DJ-Dance Remix By ริเรียว หลงทาง 2016 ติดตามแซนแนล Ri'ryo music ได้ที่ลิงค์ด้าน ล่าง https://www.youtube.com/channel/UCbAuON-0IQNGvGbiJr55J-A ดาวน์โหลดเพลงนี้ http://www5.zippyshare.com/v/wsjgusTv/file.html | ["Afrobeat", "Music of Asia", "Music", "Dance music"] | ["female singer", "fast tempo", "lively accordion", "synthesiser arpeggio", "bouncy", "infectious", "dance hits", "club music", "dance hits", "pop hits", "catchy riff", "simple melody", "energetic", "spirited", "groovy bass line", "punchy drumming", "keyboard harmony", "groovy melody", "buoyant", "youthful", "teen pop", "contemporary pop", "peppy", "youthful"] | 7 | E16FgDFQI_w | 1524 | |
TAIWAN Melbourne Shuffle · 曳步舞 · 鬼步舞 【T.N.S 貓少] | This music is an Electronic instrumental. The tempo is fast with punchy, synthesised music and thumping drum beats on the drum machine. The music is youthful, energetic, enthusiastic,loud, buoyant, punchy, pulsating and electrifying. The sound quality is of inferior quality and there is a bit of static. | 2013-03-15T14:55:39Z | 魑魅鳳 | ["House music", "Music", "Shuffle", "Dubstep", "Electronic dance music", "Dance music"] | ["instrumental", "fast tempo", "electronic music", "buoyant", "youthful", "pulsating", "electrifying", "static", "inferior audio quality", "amateur recording", "edm", "punchy drumming", "synthesiser articulation", "dj", "dj mixer", "dance floor", "freestyle dance", "drum machine", "digital drumming", "digital music", "distorted sounds"] | 7 | JqmOqYtQqB8 | 2038 |
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;