musiccaps_details (view)

3 rows where musiccaps_author = 7 and musiccaps_names = "["Ice cream truck, ice cream van", "Music"]"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: youtube_published (date), musiccaps_names (array), musiccaps_aspects (array)

video youtube_link musiccaps_caption youtube_published youtube_channel youtube_description musiccaps_names musiccaps_aspects musiccaps_author youtube_id musiccaps_rowid
Candle Cove (Intro Theme) This clipping is an instrumental with rapid synthesised chimes like sound and a boomy bass drop against white noise. The contrast of the psychedelic fast music against the boom drop gives it an eerie vibe. It is sinister, spine-tingling, scary, spooky and spine-chilling. 2011-11-13T00:25:18Z TOPiAN http://topianmusic.bandcamp.com http://facebook.com/topianmusic As featured on SyFy's 'Channel Zero' Season 1 Candle Cove, where not everything is as it seems. Inspired by: http://www.ichorfalls.com/2009/03/15/... Topian/Ben Hayward ["Ice cream truck, ice cream van", "Music"] ["instrumental", "electronic instrumentation", "white noise", "no vocals", "no percussions", "boomy bass", "synthesised chime like sound", "eerie", "spooky", "sinister", "scary", "dangerous", "mysterious", "unearthly", "terrifying", "horror", "atmospheric synthesiser"] 7 PIIAyM4H1UE 2524
1st Ice Cream Truck of the Year This music is instrumental. The tempo is medium with an electronic xylophone melody. The audio is of inferior quality and it sounds like it is being played outdoors. There are ambient nature sounds like birds chirping, a car engine, a loud thud and people’s voices. 2011-04-15T01:41:18Z Elizabeth's Adventures Here is a video that I took of the first ice cream truck of the year. This truck comes around almost every day in front of our building. The song is the Mr Softee song ["Ice cream truck, ice cream van", "Music"] ["instrumental", "medium tempo", "engine sound", "car engine", "people’s voices", "low quality audio", "amateur recording", "home video", "outdoors", "ice-cream cart", "merry-go round", "carousel", "carousel music", "engine whirring", "thudding", "xylophone melody", "birds chirping", "electronic music", "children’s music", "children’s toy music"] 7 ZsmxO0wnqdQ 3423
1/18 Tampa City of Tampa Florida POLICE Diecast Car with Lights and SIREN This music is instrumental. The tempo is slow with an electronic keyboard playing a simple, high pitched harmony. There are sounds in the background like whirring, whooshing and clicking. The music is not very clear as the audio clip is muffled, but it sounds like video game music or the music Ina child’s electronic toy. 2010-10-29T21:53:59Z 6877mercedes Ebay City of Tampa Florida POLICE Diecast Car with Lights and SIREN ["Ice cream truck, ice cream van", "Music"] ["instrumental", "medium tempo", "high notes", "sharp", "children electronic toys", "electronic music", "whirring", "white noise", "whooshing sound", "video game music", "children’s game music", "elctronic music", "synthesiser arrangements", "muffled audio", "muddled audio", "home video", "amateur recording"] 7 uwPeQy7ZtGo 5143

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;