Fatal Crashes

Description

This data set shows all fatal crashes and their investigative outcomes from PPD's Accident Investigation Unit (AID) from 1/1/19 to the present. The whole dataset gets refreshed nightly. This means the dataset will show new records the day after the source data has updated. __For those conducting analysis, this dataset by PPD and [OTIS' crash data](https://opendataphilly.org/datasets/crashes/) should not be compared, or should be used together cautiously.__ The same crash may show as in different locations between the two datasets since PPD data represent the location of where crashes are initially _reported_ whereas OTIS' crash data involves further investigation to confirm initial reports. If you want to analyze the location of crashes in Philadelphia, use OTIS' dataset. If you want to understand the investigative outcomes of crashes, use the PPD dataset.

Resources

Name Format Description Link
21 https://storymaps.arcgis.com/stories/814b1b2ace6f46f7b7e470504ac08b5e
61 https://phl.carto.com/api/v2/sql?filename=fatal_crashes&format=shp&skipfields=cartodb_id&q=SELECT%20*%20FROM%20fatal_crashes
2 https://cityofphiladelphia.github.io/carto-api-explorer/#fatal_crashes&_ga=2.159128115.869140587.1676312538-1066601619.1667858192
15 https://phl.carto.com/api/v2/sql?filename=fatal_crashes&format=geojson&skipfields=cartodb_id&q=SELECT+*+FROM+fatal_crashes
21 https://metadata.phila.gov/#home/datasetdetails/5d89169eb5d0de0010bf1ed1/representationdetails/5d89169fb5d0de0010bf1ed5/
8 https://phl.carto.com/api/v2/sql?filename=fatal_crashes&format=csv&skipfields=cartodb_id,the_geom,the_geom_webmercator&q=SELECT%20*,%20ST_Y(the_geom)%20AS%20lat,%20ST_X(the_geom)%20AS%20lng%20FROM%20fatal_crashes

Tags

  • human-services
  • crashes
  • transportation
  • philadelphia-police-department
  • accidents
  • vision-zero
  • health

Topics

  • Local Government

Categories