musiccaps_details (view)

1 row where musiccaps_aspects contains "accident", musiccaps_aspects contains "police van siren" and musiccaps_names contains "Police car (siren)"

✎ 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
new Lego City Police car This audio is an animated movie clip. There are ambient street sounds like footsteps, car brakes being slammed, car crashing, police van or ambulance siren and a song at the end. 2009-07-25T20:19:46Z vdosjcoi This is a video about my new Lego City police car.... I hope that you find her interesting!! please rate and komment!! by VDOSJCOI ["Police car (siren)", "Music", "Thunk"] ["ambient street sounds", "walking", "ambulance siren", "car", "car crash", "accident", "emergency", "accident", "sound of footsteps", "brakes slamming", "song the end", "animated", "lego", "lego city", "police", "police van", "police van siren", "police officer", "crime", "criminal"] 7 oZoJ26C6LrU 4643

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;