musiccaps_details (view)

2 rows where musiccaps_names contains "Singing" and "youtube_published" is on date 2010-06-23

✎ 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
Sarah Brightman performing 'Music Of the Night' at Queen Mother's 90th Birthday Gala 1990 Dramatic female opera singer accompanied by orchestra and brass and cymbal crash. 2010-06-23T02:57:11Z tapesalvage Sarah Brightman performing 'Music Of the Night' from Phantom Of the Opera at Queen Mother's 90th Birthday Gala 1990 ["Singing", "Music", "Opera", "Classical music"] ["opera", "dramatic", "cymbal crash", "orchestral brass", "orchestral accompaniment"] 8 XUzaEsoOlWQ 3187
Dj Chuckie - Party Bounce This audio contains a digital reggaeton beat that uses some acoustic samples. In the background you can hear a soft bass playing along with the kick. A lot of male voices are rapping/speaking providing backing vocals that are spread across both sides of the speakers. This song may be playing at a party outside on the streets. 2010-06-23T22:40:03Z abtotdec Enjoy the Song Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for "fair use" for purposes such as criticism, comment, news reporting, teaching, scholarship, and research. Fair use is a use permitted by copyright statute that might otherwise be infringing. Non-profit, educational or personal use tips the balance in favor of fair use ["Afrobeat", "Singing", "Music", "Rapping", "Hip hop music"] ["reggeaton", "male voices rapping/talking", "bass", "digital drums", "medium to uptempo"] 6 ou3LJpAM4mk 4663

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;