Skip to main content

Data Dictionary

Column Type Label Description
CRN numeric CRN
ARRIVAL_TM text ARRIVAL_TM
AUTOMOBILE_COUNT numeric AUTOMOBILE_COUNT
BELTED_DEATH_COUNT numeric BELTED_DEATH_COUNT
BELTED_SUSP_SERIOUS_INJ_COUNT numeric BELTED_SUSP_SERIOUS_INJ_COUNT
BICYCLE_COUNT numeric BICYCLE_COUNT
BICYCLE_DEATH_COUNT numeric BICYCLE_DEATH_COUNT
BICYCLE_SUSP_SERIOUS_INJ_COUNT numeric BICYCLE_SUSP_SERIOUS_INJ_COUNT
BUS_COUNT numeric BUS_COUNT
CHLDPAS_DEATH_COUNT numeric CHLDPAS_DEATH_COUNT
CHLDPAS_SUSP_SERIOUS_INJ_COUNT numeric CHLDPAS_SUSP_SERIOUS_INJ_COUNT
COLLISION_TYPE numeric COLLISION_TYPE
COMM_VEH_COUNT numeric COMM_VEH_COUNT
CONS_ZONE_SPD_LIM text CONS_ZONE_SPD_LIM
COUNTY text COUNTY
CRASH_MONTH numeric CRASH_MONTH
CRASH_YEAR numeric CRASH_YEAR
DAY_OF_WEEK numeric DAY_OF_WEEK
DEC_LATITUDE numeric DEC_LATITUDE
DEC_LONGITUDE numeric DEC_LONGITUDE
DISPATCH_TM text DISPATCH_TM
DISTRICT numeric DISTRICT
DRIVER_COUNT_16YR numeric DRIVER_COUNT_16YR
DRIVER_COUNT_17YR numeric DRIVER_COUNT_17YR
DRIVER_COUNT_18YR numeric DRIVER_COUNT_18YR
DRIVER_COUNT_19YR numeric DRIVER_COUNT_19YR
DRIVER_COUNT_20YR numeric DRIVER_COUNT_20YR
DRIVER_COUNT_50_64YR numeric DRIVER_COUNT_50_64YR
DRIVER_COUNT_65_74YR numeric DRIVER_COUNT_65_74YR
DRIVER_COUNT_75PLUS numeric DRIVER_COUNT_75PLUS
EST_HRS_CLOSED text EST_HRS_CLOSED
FATAL_COUNT numeric FATAL_COUNT
HEAVY_TRUCK_COUNT numeric HEAVY_TRUCK_COUNT
HORSE_BUGGY_COUNT numeric HORSE_BUGGY_COUNT
HOUR_OF_DAY numeric HOUR_OF_DAY
ILLUMINATION numeric ILLUMINATION
INJURY_COUNT numeric INJURY_COUNT
INTERSECTION_RELATED text INTERSECTION_RELATED
INTERSECT_TYPE numeric INTERSECT_TYPE
LANE_CLOSED numeric LANE_CLOSED
LATITUDE text LATITUDE
LN_CLOSE_DIR numeric LN_CLOSE_DIR
LOCATION_TYPE numeric LOCATION_TYPE
LONGITUDE text LONGITUDE
MAX_SEVERITY_LEVEL numeric MAX_SEVERITY_LEVEL
MCYCLE_DEATH_COUNT numeric MCYCLE_DEATH_COUNT
MCYCLE_SUSP_SERIOUS_INJ_COUNT numeric MCYCLE_SUSP_SERIOUS_INJ_COUNT
MOTORCYCLE_COUNT numeric MOTORCYCLE_COUNT
MUNICIPALITY numeric MUNICIPALITY
NONMOTR_COUNT numeric NONMOTR_COUNT
NONMOTR_DEATH_COUNT numeric NONMOTR_DEATH_COUNT
NONMOTR_SUSP_SERIOUS_INJ_COUNT numeric NONMOTR_SUSP_SERIOUS_INJ_COUNT
NTFY_HIWY_MAINT text NTFY_HIWY_MAINT
PED_COUNT numeric PED_COUNT
PED_DEATH_COUNT numeric PED_DEATH_COUNT
PED_SUSP_SERIOUS_INJ_COUNT numeric PED_SUSP_SERIOUS_INJ_COUNT
PERSON_COUNT numeric PERSON_COUNT
POLICE_AGCY text POLICE_AGCY
POSSIBLE_INJ_COUNT numeric POSSIBLE_INJ_COUNT
RDWY_SURF_TYPE_CD numeric RDWY_SURF_TYPE_CD
RELATION_TO_ROAD numeric RELATION_TO_ROAD
ROADWAY_CLEARED numeric ROADWAY_CLEARED
ROAD_CONDITION numeric ROAD_CONDITION
SCH_BUS_IND text SCH_BUS_IND
SCH_ZONE_IND text SCH_ZONE_IND
SECONDARY_CRASH text SECONDARY_CRASH
SMALL_TRUCK_COUNT numeric SMALL_TRUCK_COUNT
SPEC_JURIS_CD numeric SPEC_JURIS_CD
SUSP_MINOR_INJ_COUNT numeric SUSP_MINOR_INJ_COUNT
SUSP_SERIOUS_INJ_COUNT numeric SUSP_SERIOUS_INJ_COUNT
SUV_COUNT numeric SUV_COUNT
TCD_FUNC_CD numeric TCD_FUNC_CD
TCD_TYPE numeric TCD_TYPE
TFC_DETOUR_IND text TFC_DETOUR_IND
TIME_OF_DAY numeric TIME_OF_DAY
TOTAL_UNITS numeric TOTAL_UNITS
TOT_INJ_COUNT numeric TOT_INJ_COUNT
UNBELTED_OCC_COUNT numeric UNBELTED_OCC_COUNT
UNB_DEATH_COUNT numeric UNB_DEATH_COUNT
UNB_SUSP_SERIOUS_INJ_COUNT numeric UNB_SUSP_SERIOUS_INJ_COUNT
UNK_INJ_DEG_COUNT numeric UNK_INJ_DEG_COUNT
UNK_INJ_PER_COUNT numeric UNK_INJ_PER_COUNT
URBAN_RURAL numeric URBAN_RURAL
VAN_COUNT numeric VAN_COUNT
VEHICLE_COUNT numeric VEHICLE_COUNT
VULNERABLE_ROAD_USER_COUNT numeric VULNERABLE_ROAD_USER_COUNT
VULNERABLE_ROAD_USER_DEATH_COUNT numeric VULNERABLE_ROAD_USER_DEATH_COUNT
VULNERABLE_ROAD_USER_SER_INJ_COUNT numeric VULNERABLE_ROAD_USER_SER_INJ_COUNT
WEATHER1 text WEATHER1
WEATHER2 text WEATHER2
WORKERS_PRES text WORKERS_PRES
WORK_ZONE_IND text WORK_ZONE_IND
WORK_ZONE_LOC numeric WORK_ZONE_LOC
WORK_ZONE_TYPE numeric WORK_ZONE_TYPE
WZ_CLOSE_DETOUR text WZ_CLOSE_DETOUR
WZ_FLAGGER text WZ_FLAGGER
WZ_LAW_OFFCR_IND text WZ_LAW_OFFCR_IND
WZ_LN_CLOSURE text WZ_LN_CLOSURE
WZ_MOVING text WZ_MOVING
WZ_OTHER text WZ_OTHER
WZ_SHLDER_MDN text WZ_SHLDER_MDN
WZ_WORKERS_INJ_KILLED text WZ_WORKERS_INJ_KILLED

Additional Information

Field Value
Data last updated September 11, 2026
Metadata last updated September 11, 2026
Created September 11, 2026
Format CSV
License Creative Commons CCZero
Datastore activeTrue
Has viewsTrue
Idc6bedb17-2d23-49b1-843a-8f6b41e5e5c3
Mimetypetext/csv
Package id3130f583-9499-472b-bb5a-f63a6ff6059a
Position29
Size4.6 MiB
Stateactive
Tracking summary{'total': 0, 'recent': 0}
Url typeupload

Data Use Agreement

You must agree to the terms below to access the site.

Terms of use

The Western Pennsylvania Regional Data Center (WPRDC) is a project led by the University Center of Social and Urban Research (UCSUR) at the University of Pittsburgh ("University") in collaboration with City of Pittsburgh and The County of Allegheny in Pennsylvania. The WPRDC and the WPRDC Project is supported by a grant from the Richard King Mellon Foundation.

This Data Use Agreement covers the terms and conditions that you must agree to before you access or use the Data on deposit with the WPRDC. By using the data available on the WPRDC website portal, you agree to the terms and conditions of your access to the WPRDC and your use of the Data on deposit with the WPRDC.

Intending to be legally bound, you agree to the following:

  1. Effective Date: The effective date of the Agreement is the date of your signature or click through acceptance of these terms, and the terms shall continue to bind you with every subsequent attempt to access or use Data from the WPRDC.
  2. Definitions: "Data" for purposes of this Agreement, shall mean all information of varying formats which has been deposited with the WPRDC by The City, The County, and other third parties, to make such information available for public access. Data may cover, but is not limited to topics including property ownership, budgets, transportation, education, public safety, public services, and geographic information. Data may consist of, but is not limited to administrative records created by government or other organizations, statistical information designed to improve the function of government and organizations, and information created about government and organizations. The Data on deposit with the WPRDC is not intended to and should not contain Non-Public Information, as defined below.
  3. "Non-Public Information" for the purposes of this Agreement shall mean information that may not be disclosed to the public for the following reasons: The information is exempt from disclosure or the information is prohibited from being disclosed under State and Federal Laws and regulations including the Pennsylvania Right to Know Act, 65 P.S § 67.101 et seq., the Criminal History Record Information Act, 18 Pa.C.S. §§ 9101-9183, the Health Insurance Portability and Accountability Act (HIPAA), and other applicable privacy laws; The information is covered by a contractual non-disclosure obligation; The information is covered by confidentiality and fiduciary obligations; or The information is private, proprietary or privileged. "User" shall mean any individual who seeks access to or uses WPRDC Data. "Third Party Links" shall mean any website links to other data and data resources provided by the WPRDC portal/website.
  4. Grant of Access and Use of WPRDC Data: Subject to the compliance with the User Terms and Conditions set forth below, UCSUR hereby grants User permission to access and use the Data from the WPRDC pursuant to the license terms, restrictions, or designations placed upon the Data by the Data owner and depositor. This grant shall not include permission to use Non-Public Information which is inadvertently deposited in the WPRDC.
  5. User Terms and Conditions:

    The User is subject to the following terms and conditions with respect to the User's access and use of WPRDC Data.

    1. User shall accept complete responsibility for its access to and use of the Data derived from the WPRDC, or any derivatives User makes of the Data.
    2. User shall abide by the licensing terms if provided by the data owner and WPRDC as publisher.
    3. User shall abide by the terms and conditions of any Third Party Links when accessing data from the WPRDC through such Third Party Links.
    4. User agrees to immediately notify the WPRDC Project Manager, Robert Gradeck, at 412-624-9177 or via email at rmg44@pitt.edu when Non-Public Information is suspected or discovered through User access to the WPRDC. User agrees to refrain from use of any Non-Public Information inadvertently on deposit and accessible from the WPRDC.
    5. User understands that UCSUR may, on its own and without notice, remove Data and Third Party Data Links from the WPRDC.
    6. User understands and agrees that there is no obligation for UCSUR to update or provide customized Data under this Agreement.
    7. User shall comply with all Federal, State, and local laws and regulations governing regarding use of the Data and Third Party Data Links.
    8. User shall provide feedback, questions, concerns, or comments regarding access or use of Data on deposit with the WPRDC by contacting the WPRDC Project Manager, Robert Gradeck, at 412-624-9177 or rmg44@pitt.edu.
  6. Ownership of Data: Ownership of the Data in the WPRDC and through Third Party Links shall remain and belong to the person or party that created it and/or deposited it in the WPRDC. Nothing in this Agreement shall be construed as a transfer or assignment of ownership of any data, copyrights, or other intellectual property.
  7. Disclaimers/No Warranties/As Is and As Available: DISCLAIMER. THE UNIVERSITY, THE CITY, AND THE COUNTY OF ALLEGHENY HEREBY DISCLAIM ALL IMPLIED AND EXPRESS WARRANTIES OF ANY KIND WITH REGARD TO DATA MADE AVAILABLE IN THE WPRDC AND ACCESSED BY USER THROUGH THE WPRDC, INCLUDING, BUT NOT LIMITED TO, THE WARRANTIES OF MERCHANTABILITY AND OF FITNESS FOR ANY PARTICULAR PURPOSE SPECIFIC PURPOSE. THE UNIVERSITY DOES NOT WARRANT THE COMPLETENESS OR ACCURACY OF THE DATA MADE AVAILABLE THROUGH THE WPRDC. USER HEREBY ACKNOWLEDGES AND ACCEPTS THE ABOVE DISCLAIMERS AND USES ALL OF THE DATA IN THE WPRDC AT ITS OWN RISK AND ON AN "AS IS" AND "AS AVAILABLE" BASIS.
  8. Indemnification: User agrees to indemnify, release, and hold harmless the University of Pittsburgh, UCSUR, The City of Pittsburgh, and The County of Allegheny, to include its elected officials, officers, appointees, employees and agents, from any and all liability for claims arising out of my access to and/or use of Data made available through the WPRDC.
  9. Assignability: User agrees that this Agreement may not be assigned by User. This Agreement may be assigned at any time by University without prior notice to Licensee.
  10. Governing Law, Jurisdiction, and Venue: User agrees that this Agreement shall be construed and enforced according to the laws of the Commonwealth of Pennsylvania and the sole jurisdiction and venue for the resolution of any dispute arising from or relating to the Agreement shall be the state and federal courts located within the County of Allegheny, Pennsylvania.

Through clicking the button below, the User represents that they are over the age of 18 and understands and agrees to the terms and conditions set forth above.