musiccaps_details (view)
2 rows where musiccaps_aspects contains "bouncy" and musiccaps_aspects contains "catchy riff" sorted by musiccaps_caption
This data as json, CSV (advanced)
musiccaps_aspects (array) 44 ✖
- bouncy · 2 ✖
- catchy riff · 2 ✖
- fast tempo 2
- ambient street sounds 1
- animated 1
- animated singing 1
- buoyant 1
- busker 1
- busking 1
- catchy vocal riff 1
- cheering 1
- chirpy 1
- clapping 1
- club music 1
- concert 1
- contemporary pop 1
- dance hits 1
- energetic 1
- enthusiastic paino 1
- female singer 1
- gig 1
- groovy bass line 1
- groovy melody 1
- infectious 1
- inferior audio quality 1
- keyboard harmony 1
- live performance 1
- lively accordion 1
- male vocalist 1
- mufffled audio 1
- people talking 1
- peppy 1
- piano harmony 1
- pop hits 1
- punchy drumming 1
- simple melody 1
- spirited 1
- street performance 1
- synthesiser arpeggio 1
- teen pop 1
- vehicle sounds 1
- vivacious 1
- vivid 1
- youthful 1
musiccaps_names (array) 5 ✖
- Music 2
- Afrobeat 1
- Applause 1
- Dance music 1
- Music of Asia 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 | |
Bicycle Piano -Mickey Mouse March | A male vocalist sings this energetic song. The tempo is fast with a spirited piano accompaniment and ambient street noises like vehicles, people talking and breeze. There is a sound of clapping and cheering indicating that this is a live street performance. The audio quality is inferior causing static and muffled sounds.This song is a cheerful, animated, spirited, happy, chirpy and bouncy pop. | 2007-10-08T15:21:12Z | M K | Who the leader of the club that made for you and me! | ["Applause", "Music"] | ["male vocalist", "fast tempo", "piano harmony", "bouncy", "chirpy", "animated", "vivid", "vivacious", "ambient street sounds", "inferior audio quality", "mufffled audio", "catchy riff", "animated singing", "enthusiastic paino", "catchy vocal riff", "clapping", "people talking", "cheering", "vehicle sounds", "live performance", "gig", "concert", "street performance", "busking", "busker"] | 7 | 6ragcEJVErI | 792 |
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;