musiccaps_details (view)
1 row where musiccaps_aspects contains "ambient street noises", musiccaps_aspects contains "gameplay", musiccaps_aspects contains "haunting" and musiccaps_aspects contains "horror movies"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Silence of the Sleep - First 13 Minutes of the Game | The music is instrumental. There are ambient sounds like door banging sounds, eerie squeaks, church bells ringing and string section harmony. The song is a video game soundtrack. | 2013-09-16T14:23:49Z | Silence of the Sleep | Silence of the Sleep is upcoming psychological horror adventure indie game for PC. NOTE: This is early footage, many things have changed since! You play as a man called Jacob Reeves. A man who has lost his reason to live. He throws himself into a blackness, but instead of simply fading away he ends up in a nightmare. You explore a dark, wicked world to find the very reason for your journey. Silence of the Sleep will be released for PC in 2014. NOTE: Silence of the Sleep runs natively 60 fps and Youtube supports only max 30 fps. This is why it seems a bit choppy at times, but it's only because of the video! :) http://www.silenceofthesleep.com https://www.facebook.com/pages/Silence-of-The-Sleep/706974265996346 | ["Music", "Thunk"] | ["door slamming tones", "string section harmony", "video game soundtrack", "game sound prediction", "gameplay", "ambient street noises", "medium tempo", "stock sounds", "ambient noises", "creepy", "game sound tones", "instrumental music", "doors banging", "church bells", "horror movies", "haunting", "eerie"] | 1 | G6A9NKeK8ko | 1691 |
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;