musiccaps_details (view)
2 rows where musiccaps_aspects contains "tabla", musiccaps_author = 9 and musiccaps_names contains "Music of Bollywood"
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- tabla · 2 ✖
- amusing 1
- comedy 1
- esraj 1
- female vocal 1
- funny singing 1
- haunting 1
- hindi language 1
- hypnotic 1
- indian folk music 1
- kanjira 1
- male vocals 1
- manjira 1
- obscene 1
- percussion 1
- repeated theme 1
- strings 1
- trippy 1
musiccaps_names (array) 6 ✖
- Music 2
- Music of Bollywood · 2 ✖
- Folk music 1
- Middle Eastern music 1
- Music of Asia 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 |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Bhabi Mera Vyah Karde | Geet Shagna De | Punjabi Marriage Ceremony Songs | Popular Wedding Music | This is a comedy music piece. The male vocals are singing in a funny manner in the Hindi language. The rhythm is being played by percussive elements such as the tabla and the kanjira. The atmosphere is amusing. This piece could be used in the background of a comedy skit. | 2012-03-18T14:33:36Z | Catrack Entertainment | 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", "Music of Bollywood"] | ["comedy", "male vocals", "funny singing", "hindi language", "tabla", "kanjira", "amusing", "obscene"] | 9 | xseL3oZc7pY | 5358 |
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;