musiccaps_details (view)

1 row where musiccaps_aspects contains "electronic percussion", musiccaps_aspects contains "religious" and musiccaps_aspects contains "sikh"

✎ 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
Dhan Su Wela Jit Darshan Karna -My own Music -Gurbani shabad -Devotional song -L1M This is a Sikh religious music piece. The male vocalist is singing in the Hindi language in a devoted manner. There is an organ in the background playing the melody accompanying the male vocal. Electronic drums and electronic percussion provide the rhythmic background for the piece. 2011-11-17T13:08:41Z DilDaar S Dhan Su Wela Jit , Voice & Music ( Copyright SEP 2011 ) of DilDaarS, Devotional- song, Gurbani shabad of Sikhs Holy Book, Gur Granth Sahib , Mahala 5, Pg 562 ; (04 SEP 2011) ... Translated in English : ... Blessed is the moment when I see the Holy Book . ... I offer myself (bow ) down to the Holy Book . ... You , beloved , Master of all living beings . ... your recitation is my life-line . ... Your words are the truth and are like nector for life . ... Your words are cool and soothing , and your gaze knows all. ... Your ( Holy Book ) advices are always truthful . ... You are always present and never leave us . ... You are mercyful to devotees , I am your humble servant . ... Says Naanak , the Master fulfils all prayers . ... For Panjabi & Hindi text , visit ( Select page 562 ) : http://www.srigranth.org ["Music", "Sad music"] ["sikh", "devotional", "male vocal", "organ", "electronic drums", "electronic percussion", "religious", "hindi"] 9 giPa2vVEyVc 4047

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;