musiccaps_details (view)
1 row where musiccaps_aspects contains "atmospheric", musiccaps_names contains "Music" and "youtube_published" is on date 2009-10-12
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 |
---|---|---|---|---|---|---|---|---|---|---|
Machinarium Demo (PC) Walkthrough | A synthesizer is playing soothing pad sounds with a lot of reverb. In the background you can hear external noises and some water sounds. This may be playing in a videogame. | 2009-10-12T02:20:17Z | Artificialraven | A short walkthrough of the Machinarium Demo for the PC. Machinarium is independent puzzle / adventure game developed by the makers of popular web-games Samorost and Samorost2. A little robot whos been thrown out to the scrap yard behind the city must return and confront the Black Cap Brotherhood and save his robot-girl friend. Visit: http://machinarium.net/index.html or http://store.steampowered.com/search/?term=Machinarium for more details. My 2 cents: I'm a fan of the Samorost games and of Amanita Design. I always loved their artwork and the music they've used in their flash movies/games. I was excited to hear the news that they were developing a new game title, which just happened to be Machinarium. I've waited and now the game is finally being released with even more impressive artwork, music and puzzles. I'm looking forward to playing the full version of this game. If you want to see some of Amanita's older stuff, check out http://www.amanitadesign.com | ["Music", "Pour"] | ["atmospheric", "synth pad sounds", "background-noises", "slow tempo", "soothing"] | 6 | kMK10SknFAI | 4310 |
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;