musiccaps_details (view)
2 rows where musiccaps_aspects contains "female singer", musiccaps_aspects contains "youthful" and musiccaps_names contains "Music of Asia"
This data as json, CSV (advanced)
musiccaps_aspects (array) 34 ✖
- female singer · 2 ✖
- youthful · 2 ✖
- amateur recording 1
- bouncy 1
- buoyant 1
- catchy riff 1
- club music 1
- contemporary pop 1
- dance hits 1
- energetic 1
- enthusiastic 1
- fast tempo 1
- foreign language 1
- groovy bass line 1
- groovy melody 1
- home videos 1
- incoherent music 1
- infectious 1
- inferior audio quality 1
- karaoke 1
- keyboard harmony 1
- lively accordion 1
- medium tempo 1
- off key singing 1
- peppy 1
- piano accompaniment 1
- pop hits 1
- punchy drumming 1
- simple melody 1
- spirited 1
- synthesiser arpeggio 1
- teen pop 1
- violin harmony 1
- vocal backup 1
musiccaps_names (array) 5 ✖
- Music 2
- Music of Asia · 2 ✖
- /t/dd00004 1
- Afrobeat 1
- Dance music 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 | |
ジョウネツ | A female vocalist sings this pop song in a foreign language. The tempo is medium with karaoke music and vocal backup. The audio quality is inferior and the music is incoherent except for a violin harmony and piano accompaniment. This song is an amateur home video. | 2007-11-26T14:12:35Z | yupanntu | 熱い~ よっ釣れた(笑) | ["Music of Asia", "Music", "/t/dd00004"] | ["female singer", "medium tempo", "foreign language", "violin harmony", "piano accompaniment", "karaoke", "off key singing", "vocal backup", "incoherent music", "amateur recording", "inferior audio quality", "enthusiastic", "youthful", "home videos"] | 7 | jKWl63gozLE | 4246 |
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;