musiccaps_details (view)

3 rows where musiccaps_aspects contains "waltz", musiccaps_author = 8 and musiccaps_names contains "Music"

✎ 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
jan-e-bahar husn tera,wallah kamal hai_ShammiKapoor&Saroja_Rafi_ Shakeel_Ravi_tribute to singing GOD Vintage south Asian Bollywood music featuring sitar and an orchestral string melody which uses a pentatonic scale. The song follows a waltz rhythm, using three beats to the measure. 2012-04-18T06:13:45Z 9431885 MK Song :Jaane bahaar husn tera bemisal hai.. Movie :Pyaar Kiya To Darna Kya (1963), Singer: Mohammad Rafi, Lyricist : Shakeel Badayuni, Music Director : Ravi, Cast : Shammi Kapoor,B.Saroja Devi, Pran, Om Prakash, Agha and Prithviraj Kapoor, Helen,Shobha Khote, Melancholy Director : B.S. Ranga Lyrics :- jaan-e-bahaar husn teraa bemisaal hai jaan-e-bahaar husn teraa bemisaal hai wallaah kamaal hai, arre wallaah kamaal hai jaan-e-bahaar husn teraa bemisaal hai aayi hai mere paas tu is aan-baan se aayi hai mere paas tu is aan-baan se utri ho jaise koyi pari aasmaan se main kyaa kahoon khushi se ajab meraa haal hai jaan-e-bahaar husn teraa bemisaal hai wallaah kamaal hai, arre wallaah kamaal hai haay jaan-e-bahaar husn teraa bemisaal hai haay ye teri mast adaayen ye baankpan haay ye teri mast adaayen ye baankpan kirnon ko bhi main chhoone na doongaa tera badan tujhse nazar milaaye ye kiski majaal hai jaan-e-bahaar husn teraa bemisaal hai wallaah kamaal hai, arre wallaah kamaal hai jaan-e-bahaar husn teraa bemisaal hai main khushnaseeb hoon ke tujhe maine paa liyaa main khushnaseeb hoon ke tujhe maine paa liyaa toone karam kiyaa mujhe apnaa banaa liyaa aise mile hain ham ke bichhdnaa muhaal hai jaan-e-bahaar husn teraa bemisaal hai wallaah kamaal hai, arre wallaah kamaal hai haay jaan-e-bahaar husn teraa bemisaal hai ["Music", "Sitar"] ["waltz", "orchestral string melody", "sitar", "vintage", "bollywood", "pentatonic melody", "exotic", "south asian"] 8 Q6dVti1YVwM 2594
Zelmer odkurzacz An orchestra plays a waltz with low strings playing arpeggios and high strings taking the melody. The music has a quaint, lilting feel. There are mechanical sounds in the foreground. 2007-03-23T21:07:33Z slupek Reklama produktu firmy Zelmer, firma po kilkunasty latach istnienia, przypomina o sobie w nowych, zabawnych reklamach, wiecej znajdziesz na www.reklamatv.ovh.org ["Music", "Thunk"] ["instrumental", "classical", "orchestral", "waltz", "low string arpeggios", "violin ensemble melody", "mechanical sounds", "quaint", "lilting feel"] 8 SLcIv8CNk20 2760
Celia Sheen plays Midsomer Murders on Theremin An orchestra plays a waltz supporting a Theremin which takes the lead melody while the piano plays a counter melody. The feel is cinematic, spooky and a bit quirky. 2009-01-17T21:29:10Z randomnotegenerator Celia Sheen plays the theme tune from ITV's drama series "Midsomer Murders" on the Theremin. She has done so, along with incidental music, on the soundtrack of every episode for fourteen years. This fascinating instrument was the world's very first electronic instrument, invented in 1920 by Russian scientist Lev Theremin. Of course, nobody ever sees Celia's performances on the recordings, but what makes it interesting is that the Theremin is played without being touched! ["Background music", "Music", "Opera", "Theremin"] ["spooky", "theremin melody", "sci-fi", "waltz", "orchestra", "piano counter melody", "cinematic", "quirky"] 8 YTZK9FNgK74 3288

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;