musiccaps_details (view)
1 row where musiccaps_aspects contains "cello bass", musiccaps_aspects contains "electronic harmony" and musiccaps_author = 7
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
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;