{"action":"create","ckan_id":null,"date_created":"Tue, 10 Mar 2026 00:26:34 GMT","date_finished":null,"harvest_job_id":"fa67d1eb-cf37-4e99-bd53-69451f6544c2","harvest_source_id":"638ed9d7-1f15-4bbe-ad49-e9a819290bb1","id":"6bc5690b-e3a8-4b0e-8d9c-bd84965ebee4","identifier":"fatal-crashes","parent_identifier":null,"source_hash":"65c719481394cfccab9761e689650245c0ecf85d8b00f67fa7d6987eaf7ba827","source_raw":"{\"accessLevel\": \"public\", \"contactPoint\": {\"fn\": \"Captain Heinzeroth\", \"hasEmail\": \"mailto:robert.heinzeroth@phila.gov\"}, \"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.\\r\\n\\r\\n__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.\\r\\n\\r\\n\", \"distribution\": [{\"accessURL\": \"https://cityofphiladelphia.github.io/carto-api-explorer/#fatal_crashes&_ga=2.159128115.869140587.1676312538-1066601619.1667858192\", \"format\": \"API\", \"mediaType\": \"application/http\", \"title\": \"Fatal Crashes (API)\"}, {\"accessURL\": \"https://metadata.phila.gov/#home/datasetdetails/5d89169eb5d0de0010bf1ed1/representationdetails/5d89169fb5d0de0010bf1ed5/\", \"format\": \"HTML\", \"mediaType\": \"text/html\", \"title\": \"Fatal Crashes (Metadata)\"}, {\"accessURL\": \"https://storymaps.arcgis.com/stories/814b1b2ace6f46f7b7e470504ac08b5e\", \"format\": \"HTML\", \"mediaType\": \"text/html\", \"title\": \"Reducing Traffic Deaths (Visualization)\"}, {\"downloadURL\": \"https://phl.carto.com/api/v2/sql?filename=fatal_crashes&format=csv&skipfields=cartodb_id,the_geom,the_geom_webmercator&q=SELECT%20%2A,%20ST_Y(the_geom)%20AS%20lat,%20ST_X(the_geom)%20AS%20lng%20FROM%20fatal_crashes\", \"format\": \"CSV\", \"mediaType\": \"text/csv\", \"title\": \"Fatal Crashes (CSV)\"}, {\"downloadURL\": \"https://phl.carto.com/api/v2/sql?filename=fatal_crashes&format=geojson&skipfields=cartodb_id&q=SELECT+%2A+FROM+fatal_crashes\", \"format\": \"GEOJSON\", \"mediaType\": \"application/octet-stream\", \"title\": \"Fatal Crashes (GeoJSON)\"}, {\"downloadURL\": \"https://phl.carto.com/api/v2/sql?filename=fatal_crashes&format=shp&skipfields=cartodb_id&q=SELECT%20%2A%20FROM%20fatal_crashes\", \"format\": \"SHP\", \"mediaType\": \"application/zip\", \"title\": \"Fatal Crashes (SHP)\"}], \"identifier\": \"fatal-crashes\", \"keyword\": [\"Philadelphia Police Department\", \"Vision Zero\", \"accidents\", \"crashes\", \"health\", \"human services\", \"transportation\"], \"license\": \"https://metadata.phila.gov/#help/help-faqs/what-are-the-terms-of-use/\", \"modified\": null, \"publisher\": {\"@type\": \"org:Organization\", \"name\": \"City of Philadelphia\"}, \"spatial\": \"Philadelphia, Pennsylvania\", \"title\": \"Fatal Crashes\"}","source_transform":null,"status":"error"}