musiccaps_details (view)
2 rows where musiccaps_aspects contains "female singer", musiccaps_aspects contains "passionate" and musiccaps_names contains "Folk music"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- female singer · 2 ✖
- medium tempo 2
- passionate · 2 ✖
- arabic dance music sultry vocals 1
- arabic music 1
- arabic percussion 1
- backup female singers 1
- bridal send off song 1
- bridal song 1
- classical ghazals 1
- dance tunes 1
- devotional music 1
- dholak percussions 1
- emotional 1
- ghazal 1
- groovy music 1
- heartfelt 1
- indian percussions 1
- indian traditional song 1
- keyboard accompaniment 1
- life’s truths 1
- live performance 1
- love songs 1
- mehandi ceremony 1
- poor audio quality 1
- positive 1
- proverbs 1
- romantic 1
- steady drumming rhythm 1
- story telling 1
- …
musiccaps_names (array) 5 ✖
- Folk music · 2 ✖
- Music 2
- Middle Eastern music 1
- Music of Bollywood 1
- Wedding music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Rif Music 2018 | A female singer sings this sultry vocals. The song is medium tempo with traditional Arabic percussions playing steadily, tambourine percussion, keyboard accompaniment and a strong bass-line. The song is romantic and passionate. The audio quality is poor. | 2010-04-16T23:11:47Z | Moha Dulce Rifeño | www.Rifmelody.com | ["Folk music", "Music"] | ["female singer", "arabic music", "medium tempo", "poor audio quality", "groovy music", "arabic dance music sultry vocals", "tambourine percussion", "keyboard accompaniment", "steady drumming rhythm", "dholak percussions", "arabic percussion", "passionate", "romantic", "love songs", "dance tunes"] | 1 | 7dmT4SgS_EM | 869 | |
Mehandi Ni Mehandi | Geet Shagna De | Punjabi Marriage Ceremony Songs | Popular Wedding Music | A female singer sings this beautiful wedding song for the bride. The song is a medium tempo with traditional Indian instruments like the tabla playing percussion and stringed instruments playing rhythm. The song is heartfelt and emotional. The song is a mehendi ceremony song or a bridal preparation song for her wedding, | 2012-03-18T15:20:43Z | Catrack Entertainment | Mehndi Ni Mehndi, Mehndi Ni Mehndi, Mehndi Ni Mehndi, Mehndi Ni Mehndi Aaj Ralke Laawan Aayo Ni Bhaina Te Bharjaiyan Mehndi Ni Mehndi, Mehndi Ni Mehndi, Mehndi Ni Mehndi, Mehndi Ni Mehndi Ambi Da Buta Vehde Laaye Maali Gairan Di Jholi Paye Tenu Aap Sajawan Aaiyan Ni Bhaina Te Bharjaiyan Mehndi Ni Mehndi, Mehndi Ni Mehndi, Mehndi Ni Mehndi, Mehndi Ni Mehndi Beh Gaiyan Sakhiyan Chaar Chuphere Rondiyan Akhiyan Hasde Chehre Rang Ratda Lawan Aaiyan Ni Bhaina Te Bharjaiyan Mehndi Ni Mehndi, Mehndi Ni Mehndi, Mehndi Ni Mehndi, Mehndi Ni Mehndi Bhuan Te Chachiyan Taiyan Aaiyan Lakh Duawan Te Den Vadhaiyan Tere Shagan Manawan Aaiyan Ni Bhaina Te Bharjaiyan Mehndi Ni Mehndi, Mehndi Ni Mehndi, Mehndi Ni Mehndi, Mehndi Ni Mehndi This Song/Boliyan represents the Rich Punjabi Culture and Music and is Part of Rituals in every Traditional Punjabi Wedding Ceremony whether it takes place in a Village of Punjab (India) or Anywhere in the World. These Folk / Marriage Songs are integral part of Punjabi Culture and have various forms of Song & Dance like Tappe, Bolian, Gidha, Bhangra and Sithniyan. These are also called Shagna De Geet. All Punjabi Songs / Punjabi Music By Catrack is Available On I-Tunes, Spotify, Rhapsody, Nokia, emusic, Google Music, Amazon & Sound Cloud. Subscribe to Catrack's Youtube Channel http://www.youtube.com/subscription_center?add_user=catrackentertainment Join Us On Facebook http://www.facebook.com/CatrackOfficial Twitter https://twitter.com/catrack Google+ https://plus.google.com/112539272523400923462/ For Any Content, Advertising, or Marketing Related Queries for All our Platforms, including Heeroz OTT, Kindly Visit: http://www.catrack.com | ["Folk music", "Music", "Wedding music", "Middle Eastern music", "Music of Bollywood"] | ["female singer", "backup female singers", "bridal send off song", "mehandi ceremony", "vocal harmony", "medium tempo", "proverbs", "tabla playing steadily", "stringed instrument accompaniment", "passionate", "emotional", "positive", "classical ghazals", "live performance", "heartfelt", "devotional music", "story telling", "life’s truths", "wedding song", "bridal song", "indian traditional song", "indian percussions", "ghazal"] | 1 | uHgpDP_4Lsc | 5105 |
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;