musiccaps_details (view)

1 row where musiccaps_aspects contains "chaotic atmosphere", musiccaps_aspects contains "no rhythm", musiccaps_aspects contains "scary" 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
Cluck Yegger in Escape From The Planet of The Poultroid - Scare Teaser Updated The sounds are background sound elements of a sci-fi tv show. There is no tempo, there are a collection of sounds like machine whirring, computer signal beeps, boomy explosion sounds, white noise, bad signal tones and glitchy noises. The music is chaotic like an alien invasion. This is background sound effects for a science fiction tv show. 2015-10-21T03:10:48Z AndromedaGuys Vote YES to help get this game in steam at CluckYegger.com! This is a short "Scare teaser trailer" of our game Cluck Yegger in Escape From The Planet of the Poultroid! Mayday, mayday… This is Cluck Yegger, free ranger. My craft, Eggcelsior was grounded by my old nemesis Colonel Zanderz. I don’t like that guy. The ship’s on limited auxiliary solar power that can recharge during the daytime. By computer estimates, it’ll take seven sols to make ship repairs. But at night, I’ll have to survive some unwelcomed company in the form of Zanderz’s genetically-modified poultriod. Fun times. Confined to this cockpit, I’ll use the ship’s cameras, lights, and doors to keep the peckish poultriod at bay. But everything drains power, so I’ve gotta conserve energy as much as possible. If the power drains before dawn, it could be “Game Over!” Yegger out! ["Music", "White noise"] ["white noise", "bad signals", "booming explosions tones", "background sound effects", "computer signal tones", "haunted space ship", "glitch tones", "computer sounds", "no music", "chaotic atmosphere", "scientific exposition", "eerie", "haunted", "scary", "machine whirring", "space travel", "alien invasion", "scraping noises", "sci-fi tv show", "space travel", "no rhythm"] 1 WhNun_U3cRU 3126

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;