musiccaps_details (view)
2 rows where musiccaps_aspects contains "repeated theme" and musiccaps_names contains "Music of Asia"
This data as json, CSV (advanced)
musiccaps_aspects (array) 23 ✖
- repeated theme · 2 ✖
- dance pop 1
- easygoing 1
- electronic drums 1
- esraj 1
- female vocal 1
- female vocals 1
- generic 1
- haunting 1
- hypnotic 1
- indian folk music 1
- k-pop 1
- keyboard 1
- korean 1
- live performance 1
- manjira 1
- melodic singing 1
- percussion 1
- simple tune 1
- strings 1
- tabla 1
- trippy 1
- upbeat 1
musiccaps_names (array) 4 ✖
- Music 2
- Music of Asia · 2 ✖
- Middle Eastern music 1
- Music of Bollywood 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 | |
Hayati - Jah Wobble & Temple of sound ft.Shahin Badar | This is an Indian folk music piece. There is a haunting female vocal in the lead. There is a group of strings which sound similar to Esraj being heard playing the main tune. In the rhythmic background, there are bell percussion that sound like manjira and membranous percussion that sound like tabla. The atmosphere is trippy. This piece could be used in the soundtrack of an exotic movie or could be sampled to be used in beat-making. It could also be playing in the background of an Indian cuisine restaurant. | 2013-02-07T03:16:47Z | Shahin Badar | HAYATI - Jah Wobble & Temple of Sound Ft.Shahin Badar- Listen to the haunting vocals of Shahin Badar as you have already heard her on Prodigy's No.1 single smack my bitch up ,Tim deluxe's Mundaya & Ar Rahman's Dol Dol & many others .She was invited by the legendary Jah Wobble ( Invaders of the hearts) to collabrate on this wonderful production of Hayati (My Life) .Official music video taken from the Album Shout at the devil.Also released on various lounge Albums/compilations around the world. Video directed by John Wilmor. Actor - Vikas Bhardwarj Location - Mumbai(India) Copyright 30herts Records www.30hertzrecords.com www.shahinbadar.com | ["Music of Asia", "Music", "Middle Eastern music", "Music of Bollywood"] | ["indian folk music", "female vocal", "haunting", "strings", "esraj", "percussion", "manjira", "tabla", "repeated theme", "trippy", "hypnotic"] | 9 | OzaVvthCvtk | 2488 |
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;