musiccaps_details (view)

1 row where musiccaps_names contains "Music", musiccaps_names contains "Music of Asia" and musiccaps_names contains "Music of Bollywood"

✎ View and edit SQL

This data as json, CSV (advanced)

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

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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;