musiccaps_details (view)

1 row where musiccaps_aspects contains "church bells", musiccaps_aspects contains "instrumental music" and musiccaps_names contains "Thunk"

✎ 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
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

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;