musiccaps_details (view)
1 row where musiccaps_aspects contains "bad signals", musiccaps_aspects contains "computer sounds" and musiccaps_aspects contains "white noise"
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
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;