musiccaps_details (view)

1 row where musiccaps_aspects contains "racing car sounds"

✎ 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
Ferrari 458 Best Car Commercial Engine Start Exhaust Sound Classic - New Carjam Radio 2011 This audio clip features programmed percussion playing a trap beat. Hi-hats are played at a very fast tempo. The kick drum plays continuously in eighth notes. The sound of racing cars is the main point of focus in this clip. There are no voices. There are no other instruments and no melody. 2011-09-02T08:52:42Z CARJAM TV Carjam Car Radio Show -- A Car Show About People Website: http://www.kclr96fm.com/presenters?id=531 Twitter: http://www.twitter.com/carjamradio Youtube: http://www.youtube.com/user/CarjamRadio carjamradio "car jam radio" "car radio show" "car talk radio show" "carjam" ferrari "car talk" "bbc top gear" "great car ad 2011" "funny commercials 2011" "banned car commercials 2011" f1 "formula one" "funny videos" "classic cars" evo "best car ads 2011" "funny car ads 2011" funniest "fail" "sexy car ad 2011" "road test" "road review" "car test" "road report" "driving test" hot sexy new nissan fast Porsche suv "celebrity car" maserati vw audi 4x4 estate lotus fiat "alfa romeo" subaru toyota ford impreza "high speed" "tractor" "rally car" crashes accidents ["Music", "Accelerating, revving, vroom", "Race car, auto racing", "Medium engine (mid frequency)"] ["trap beat", "instrumental", "racing car sounds", "no voices", "minimal instruments"] 0 OZv8mtQEgA0 2448

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;