musiccaps_details (view)
2 rows where musiccaps_aspects contains "dance pop" and musiccaps_aspects contains "female vocals"
This data as json, CSV (advanced)
musiccaps_aspects (array) 37 ✖
- dance pop · 2 ✖
- female vocals · 2 ✖
- atmospheric synthesiser 1
- club 1
- club music 1
- dance groove 1
- dance hits 1
- dance music 1
- digital drums 1
- dissonant 1
- drum machine 1
- drum rhythm 1
- easygoing 1
- edm 1
- electronic drums 1
- electronic music 1
- enigmatic 1
- generic 1
- heavily synthesised 1
- high notes 1
- high pitched 1
- k-pop 1
- keyboard 1
- korean 1
- live performance 1
- medium tempo 1
- melodic singing 1
- party music 1
- pop 1
- psychedelic 1
- repeated theme 1
- simple tune 1
- trance 1
- trap 1
- trippy 1
- upbeat 1
- youthful 1
musiccaps_names (array) 4 ✖
- Music 2
- Dubstep 1
- Electronic 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 |
---|---|---|---|---|---|---|---|---|---|---|
[Comeback Stage] GIRL'S DAY - Ring My Bell, 걸스데이 - 링마벨, Show Music core 20150711 | This is a K-pop music piece being performed live by a girl group. There are female vocals singing melodically. There is a keyboard playing a simple and repeated theme. The rhythmic background consists of a danceable electronic drum beat. The atmosphere is easygoing. This piece could be playing in the background at a clothing store. | 2015-07-11T07:45:45Z | MBCkpop | Music core 20150711 GIRL'S DAY - Ring My Bell, 걸스데이 - 링마벨 ▶Show Music Core Official Facebook Page - https://www.facebook.com/mbcmusiccore | ["Music of Asia", "Music"] | ["k-pop", "dance pop", "korean", "live performance", "female vocals", "melodic singing", "keyboard", "electronic drums", "simple tune", "repeated theme", "generic", "easygoing", "upbeat"] | 9 | CretxKgW4Jk | 1408 | |
Mt Eden Dubstep - Sarah McLachlan: Silence | A female vocalist sings this trippy vocal riff. The tempo is medium with atmospheric synthesiser and digital drums. The song is heavily synthesised and is psychedelic, intense, enigmatic, mysterious and youthful with a dance groove. This song is an EDM/Electro Pop song. | 2009-06-12T09:12:04Z | Mt Eden Official | ► FREE DOWNLOAD : http://click.dj/mreden/sarah-mclachlan-silence-mt-eden-remix ► Facebook: https://www.facebook.com/MtEdenOfficial ► SoundCloud: http://soundcloud.com/mtedenofficial ► YouTube: http://www.youtube.com/MtEdenDnB08 ► Twitter: https://twitter.com/MtEdenOfficial ► Beatport: http://www.beatport.com/artist/mt-ede... Cheers for all the support . We can't wait to share more with you Enjoy | ["Electronic music", "Music", "Dubstep"] | ["female vocals", "electronic music", "enigmatic", "medium tempo", "atmospheric synthesiser", "electronic music", "high notes", "high pitched", "dissonant", "psychedelic", "heavily synthesised", "drum rhythm", "digital drums", "drum machine", "youthful", "dance music", "dance hits", "pop", "dance pop", "club", "club music", "dance music", "party music", "dance groove", "edm", "trance", "trap", "trippy"] | 7 | Nymjfq2kXnI | 2384 |
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;