musiccaps_details (view)

1 row where musiccaps_aspects contains "mesmerising", musiccaps_aspects contains "spooky" and "youtube_published" is on date 2016-03-24

✎ 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
'Elliot Lake Encounters' | Paranormal Stories This music is an ominous instrumental. The tempo is slow with a spooky electronic keyboard harmony and menacing bass on the cello. The music is eerie, sinister, frightening, and baleful. 2016-03-24T00:07:26Z Beyond Creepy UFOs, vanishing planes, Bigfoot and other strange creatures, this video looks at the weird stuff going on in Elliot Lake in Ontario, Canada. Without the Support of Patrons this channel would not be possible. https://patreon.com/BeyondCreepy ------------------------------------------------------------------------------------------------ Author: Beyond Creepy Source: mufon.com, ufocasebook.com Video: Background footage filmed/photographed by Beyond Creepy using a Panasonic Lumix ------------------------------------------------------------------------------------------------ All background footage is filmed by me using a Panasonic Lumix. stock images. All audio narrations are provided by me (Beyond Creepy). All stories are exclusively written for this channel by me. ▶ SOCIAL MEDIA ►Twitter ~ https://twitter.com/BeyondCreepy ▶Contact Information beyondcreepy@gmail.com All music and background soundscapes/music/audio are royalty free and provided by Youtube's Audio library: ▶Kevin MacLeod https://incompetech.com Licensed under Creative Commons: By Attribution 3.0 https://creativecommons.org/licenses/by/3.0/ ["Singing bowl"] ["instrumental", "slow tempo", "synthesiser arrangements", "metal clanging", "heavy bass", "intense", "scary", "electronic harmony", "cello bass", "string instrument", "cello", "eerie", "scary", "paranormal", "sinister", "ominous", "baleful", "spooky", "mesmerising"] 7 G_iJif-fC6E 1736

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;