Allegheny County Crash Data

Description

Contains locations and information about every crash incident reported to the police in Allegheny County from 2004 to 2020. Fields include injury severity, fatalities, information about the vehicles involved, location information, and factors that may have contributed to the crash. Data is provided by PennDOT and is subject to PennDOT's data privacy restrictions, which are noted in the metadata information section below. The map below shows car crashes in Allegheny County during 2016, with the color indicating whether it was a rear end collision or not.

Resources

Name Format Description Link
8 https://data.wprdc.org/datastore/dump/e3b145c0-41ba-4cc9-9054-8f686ac59643
8 https://data.wprdc.org/datastore/dump/514ae074-f42e-4bfb-8869-8d8c461dd824
8 https://data.wprdc.org/datastore/dump/cb0a4d8b-2893-4d20-ad1c-47d5fdb7e8d5
8 https://data.wprdc.org/datastore/dump/9ccea350-e062-45e2-ade5-45e9378f40d2
8 https://data.wprdc.org/datastore/dump/d90eb4fd-1234-4f3b-ba3d-422769cd3761
8 2013alcocrash.csv https://data.wprdc.org/dataset/3130f583-9499-472b-bb5a-f63a6ff6059a/resource/eb54323c-164b-4010-a78f-2dba4d382604/download/2013alcocrash.csv
8 https://data.wprdc.org/datastore/dump/4cccbf70-5709-4630-a0cd-cc4a3ed69be7
8 https://data.wprdc.org/datastore/dump/1c7ce0ad-40d3-47e4-b654-6a6bdbfeca2c
8 https://data.wprdc.org/datastore/dump/01860f81-dd89-465a-ab73-1edc21858303
8 2004alcocrash.csv https://data.wprdc.org/dataset/3130f583-9499-472b-bb5a-f63a6ff6059a/resource/17012686-77d8-477b-b034-5b4a4715ec53/download/2004alcocrash.csv
8 https://data.wprdc.org/datastore/dump/93b3d18c-680f-4a1c-9896-72b446557505
21 ArcGIS Tool for downloading Crash data for all of Pennsylvania https://pennshare.maps.arcgis.com/apps/webappviewer/index.html?id=8fdbf046e36e41649bbfd9d7dd7c7e7e
8 2011alcocrash.csv https://data.wprdc.org/dataset/3130f583-9499-472b-bb5a-f63a6ff6059a/resource/0950f9ac-fe2f-4441-a355-d60ee7653f8c/download/2011alcocrash.csv
8 2008alcocrash.csv https://data.wprdc.org/dataset/3130f583-9499-472b-bb5a-f63a6ff6059a/resource/92608ca3-3a44-4fe8-af1a-967cfe8bc29d/download/2008alcocrash.csv
8 Dictionary for PennDOT municipality codes in Allegheny County. https://data.wprdc.org/dataset/3130f583-9499-472b-bb5a-f63a6ff6059a/resource/fb81a55f-c560-4541-9ad4-7ea7c41f79e7/download/municipalitycodes.csv
8 Note that this resource has two additional fields not present in years before 2017 (TOT_INJ_COUNT and SCHOOL_BUS_UNIT) and retains two empty fields (ADJ_RDWY_SEQ and ACCESS_CTRL) for backward compatibility with crash-data schema from 2016 and before. https://data.wprdc.org/datastore/dump/bf8b3c7e-8d60-40df-9134-21606a451c1a
8 Dictionary for PennDOT police agency codes in Allegheny County. https://data.wprdc.org/dataset/3130f583-9499-472b-bb5a-f63a6ff6059a/resource/057dc1b4-a720-4593-8a0c-02f302b8b817/download/policeagencycodes.csv
8 2012alcocrash.csv https://data.wprdc.org/dataset/3130f583-9499-472b-bb5a-f63a6ff6059a/resource/bcd2e0a7-d059-4ec8-9d5d-3d293aadd4c4/download/2012alcocrash.csv
8 To download this data, use this link: https://tools.wprdc.org/downstream/2c13021f-74a9-4289-a1e5-fe0472c89881 This is a combination of all the available crash data for Allegheny County (crashes from 2004 to 2021 inclusive). There are a few years with slight differences in records because of additions and subtractions of fields published by PennDOT. See the "Data notes" field on the WPRDC dataset landing page, https://data.wprdc.org/dataset/allegheny-county-crash-data for more details. You can also download CSVs for each individual year. https://data.wprdc.org/datastore/dump/2c13021f-74a9-4289-a1e5-fe0472c89881
8 2014alcocrash.csv https://data.wprdc.org/dataset/3130f583-9499-472b-bb5a-f63a6ff6059a/resource/a1d00c8a-18dd-43ee-aa13-c2998ceb76ad/download/2014alcocrash.csv
57 This is a compressed version of the 2004-2018 Cumulative Crash Data (https://data.wprdc.org/dataset/allegheny-county-crash-data/resource/6d5a9908-cbec-412b-abfa-69d00c0b2777). https://data.wprdc.org/dataset/3130f583-9499-472b-bb5a-f63a6ff6059a/resource/ec578660-2d3f-489d-9ba1-af0ebfc3b140/download/all-crashes-2004-2018.csv.zip
8 Note that this resource retains three empty fields (ADJ_RDWY_SEQ, ACCESS_CTRL, and LOCAL_ROAD) for backward compatibility with crash-data schema from 2016 and before. https://data.wprdc.org/dataset/3130f583-9499-472b-bb5a-f63a6ff6059a/resource/48f30bee-e404-4cf5-825b-b0da3c975e45/download/crash-data-2018.csv
21 A demonstration Jupyter notebook that shows how to load and manipulate the crash data using the CKAN API, using the Pandas library, and using SQL queries. To launch this notebook in your browser, follow this link: https://mybinder.org/v2/gh/WPRDC/Jupyter-notebooks-by-dataset/master and then click on the Crash-Data-Analysis notebook. https://github.com/WPRDC/Jupyter-notebooks-by-dataset/blob/master/Crash-Data-Analysis.ipynb
33 PennDOT produced a crash data primer that includes more details about what is in the crash data, how crashes are reported, and how they're geocoded. https://data.wprdc.org/dataset/3130f583-9499-472b-bb5a-f63a6ff6059a/resource/c884d6da-588d-45ec-b029-8aaec8018500/download/database-primer-4-15.pdf
8 2005alcocrash.csv https://data.wprdc.org/dataset/3130f583-9499-472b-bb5a-f63a6ff6059a/resource/e6a24c09-c381-430b-b8ff-3ec5611538f5/download/2005alcocrash.csv

Tags

  • bus
  • speed
  • accident
  • _etl
  • transportation
  • _jupyter
  • motorcycle
  • bicycle
  • vehicle
  • crash
  • truck
  • car
  • pedestrian
  • traffic
  • incident

Topics

  • Local Government

Categories