New York Pedestrian Crash Data

From Tyche Insights
Jump to navigation Jump to search
An image from the New York State pedestrian crash data and analysis

Overview

When we analyzed pedestrian crash data for the City of Albany, NY and then wrote a data story, we utilized a state-wide dataset of pedestrian crash data from New York State Department of Transporation.

We want to make this dataset available state-wide, in a manner than can be studied or used to write similar data stories for other counties and cities within New York. We ran the same enrichment processes on the state-wide data that we did for the City of Albany study, so you can perform much of the same analysis (or more!) without having to go through various processes to clean up and enrich the data. We enriched the NY DOT data with processes that include:

  • adding in data for the boundaries - City, County, Town and Neighborhood - where each pedestrian crash happened
  • linking intersection- and non-intersection-based crashes to the names of streets where the crashes took place
  • adding the notion of whether an accident happened on a major or minor street
  • changing the coordinate information to a coordinate system that is more readily mappable

From there, we put the data into Microsoft Excel format and added various pivot tables and charts; we also have the data in a GIS format for download as well. The purpose of these tables and charts is to demonstrate various ways that the data can be used and examine. We hope that is a starting point for you extending the analysis, creating extracts of data specific to your area, putting the data into a data visualization tool, or ...

The data is available via a Creative Commons Attribution license that allows you to do whatever you want with the data. You may freely share the data, build upon it, storytell on top of the data, turn the data into a commerical product, create derivative work, etc. The only requirement is to provide proper attribution for the source of the data.

Examples

We can show some examples of charts and pivot tables that you can make with the statewide data.

Analyze pedestrian crash deaths in Buffalo, NY by day of week, day vs. night
Analyze pedestrian crash trends by quarter for Orange County, NY, complete with trendline
Understand pedestrian crashes by intersection - which intersections and the number of crashes - for Rochester, NY

Data Downloads

We have placed two files in a Google Drive folder for download. If you are unable to see these folders please send an email to karl@tycheinsights.com.

Two files:

  1. NYPedestrianCrashData_Final_Version1.xlsx - This is the Microsoft Excel file that is available for download. See the following sheets for more details:
    • Cover_sheet - provides details on the version of the file and the Creative Commons license
    • Data_Descirption - provides details on the data schema
    • Sheets_Description - provides an overview of each of the sheets that have pivot tables and charts
    • NYPedestrianCrashData - is the original data from NY DOT along with the columns of additional enrichment
    • Other sheets - 14 other sheets that demonstrate various ways to use and examine the data
  2. PedestrianEvents_Base.zip - This is the Geospatial file representation of the source data. If you would like to analyze this data in QGIS, ArcGIS or other mapping technologies, use this file

Credits

The data is available under the Creative Commons Attribution license.

Persons or organizations that Share or Adapt this content should provide Attribution that provides appropriate credit, which includes:

  • © Copyright 2026
  • Tyche Insights, P.B.C.
  • KarlTyche (Karl Urich)

For example, a data product or service that utilizes this article could include attribution such as:

"Portions derived from 'New York Pedestrian Crash Data', © Copyright 2026 by Tyche Insights, P.B.C., KarlTyche (Karl Urich) & licensed under the CC BY 4.0 license"

Retrieved from "https://wiki.tycheinsights.com/index.php?title=New_York_Pedestrian_Crash_Data&oldid=1325"