Skip to main content

Словарь данных

Колонка Тип Лейбл Описание
CRASH_CRN text
DISTRICT text
CRASH_COUNTY text
MUNICIPALITY text
POLICE_AGCY text
CRASH_YEAR int4
CRASH_MONTH text
DAY_OF_WEEK int4
TIME_OF_DAY text
HOUR_OF_DAY text
ILLUMINATION text
WEATHER text
ROAD_CONDITION text
COLLISION_TYPE text
RELATION_TO_ROAD text
INTERSECT_TYPE text
TCD_TYPE text
URBAN_RURAL text
LOCATION_TYPE text
SCH_BUS_IND text
SCH_ZONE_IND text
TOTAL_UNITS int4
PERSON_COUNT int4
VEHICLE_COUNT int4
AUTOMOBILE_COUNT int4
MOTORCYCLE_COUNT int4
BUS_COUNT int4
SMALL_TRUCK_COUNT int4
HEAVY_TRUCK_COUNT int4
SUV_COUNT int4
VAN_COUNT int4
BICYCLE_COUNT int4
FATAL_COUNT int4
INJURY_COUNT int4
MAJ_INJ_COUNT int4
MOD_INJ_COUNT int4
MIN_INJ_COUNT int4
UNK_INJ_DEG_COUNT int4
UNK_INJ_PER_COUNT int4
UNBELTED_OCC_COUNT int4
UNB_DEATH_COUNT int4
UNB_MAJ_INJ_COUNT int4
BELTED_DEATH_COUNT int4
BELTED_MAJ_INJ_COUNT int4
MCYCLE_DEATH_COUNT int4
MCYCLE_MAJ_INJ_COUNT int4
BICYCLE_DEATH_COUNT int4
BICYCLE_MAJ_INJ_COUNT int4
PED_COUNT int4
PED_DEATH_COUNT int4
PED_MAJ_INJ_COUNT int4
COMM_VEH_COUNT int4
MAX_SEVERITY_LEVEL int4
DRIVER_COUNT_16YR int4
DRIVER_COUNT_17YR int4
DRIVER_COUNT_18YR int4
DRIVER_COUNT_19YR int4
DRIVER_COUNT_20YR int4
DRIVER_COUNT_50_64YR int4
DRIVER_COUNT_65_74YR int4
DRIVER_COUNT_75PLUS int4
LATITUDE text
LONGITUDE text
DEC_LAT float8
DEC_LONG float8
EST_HRS_CLOSED int4
LANE_CLOSED int4
LN_CLOSE_DIR text
NTFY_HIWY_MAINT text
RDWY_SURF_TYPE_CD text
SPEC_JURIS_CD text
TCD_FUNC_CD text
TFC_DETOUR_IND text
WORK_ZONE_IND text
WORK_ZONE_TYPE text
WORK_ZONE_LOC text
CONS_ZONE_SPD_LIM int4
WORKERS_PRES text
WZ_CLOSE_DETOUR text
WZ_FLAGGER text
WZ_LAW_OFFCR_IND text
WZ_LN_CLOSURE text
WZ_MOVING text
WZ_OTHER text
WZ_SHLDER_MDN text
FLAG_CRN text
INTERSTATE int4
STATE_ROAD int4
LOCAL_ROAD int4
LOCAL_ROAD_ONLY int4
TURNPIKE int4
WET_ROAD int4
SNOW_SLUSH_ROAD int4
ICY_ROAD int4
SUDDEN_DEER int4
SHLDR_RELATED int4
REAR_END int4
HO_OPPDIR_SDSWP int4
HIT_FIXED_OBJECT int4
SV_RUN_OFF_RD int4
WORK_ZONE int4
PROPERTY_DAMAGE_ONLY int4
FATAL_OR_MAJ_INJ int4
INJURY int4
FATAL int4
NON_INTERSECTION int4
INTERSECTION int4
SIGNALIZED_INT int4
STOP_CONTROLLED_INT int4
UNSIGNALIZED_INT int4
SCHOOL_BUS int4
SCHOOL_ZONE int4
HIT_DEER int4
HIT_TREE_SHRUB int4
HIT_EMBANKMENT int4
HIT_POLE int4
HIT_GDRAIL int4
HIT_GDRAIL_END int4
HIT_BARRIER int4
HIT_BRIDGE int4
OVERTURNED int4
MOTORCYCLE int4
BICYCLE int4
HVY_TRUCK_RELATED int4
VEHICLE_FAILURE int4
TRAIN_TROLLEY int4
PHANTOM_VEHICLE int4
ALCOHOL_RELATED int4
DRINKING_DRIVER int4
UNDERAGE_DRNK_DRV int4
UNLICENSED int4
CELL_PHONE int4
NO_CLEARANCE int4
RUNNING_RED_LT int4
TAILGATING int4
CROSS_MEDIAN int4
CURVE_DVR_ERROR int4
LIMIT_65MPH int4
SPEEDING int4
SPEEDING_RELATED int4
AGGRESSIVE_DRIVING int4
FATIGUE_ASLEEP int4
DRIVER_16YR int4
DRIVER_17YR int4
DRIVER_65_74YR int4
DRIVER_75PLUS int4
UNBELTED int4
PEDESTRIAN int4
DISTRACTED int4
CURVED_ROAD int4
DRIVER_18YR int4
DRIVER_19YR int4
DRIVER_20YR int4
DRIVER_50_64YR int4
VEHICLE_TOWED int4
FIRE_IN_VEHICLE int4
HIT_PARKED_VEHICLE int4
MC_DRINKING_DRIVER int4
DRUGGED_DRIVER int4
INJURY_OR_FATAL int4
COMM_VEHICLE int4
IMPAIRED_DRIVER int4
DEER_RELATED int4
DRUG_RELATED int4
HAZARDOUS_TRUCK int4
ILLEGAL_DRUG_RELATED int4
ILLUMINATION_DARK int4
MINOR_INJURY int4
MODERATE_INJURY int4
MAJOR_INJURY int4
NHTSA_AGG_DRIVING int4
PSP_REPORTED int4
RUNNING_STOP_SIGN int4
TRAIN int4
TROLLEY int4
ROADWAY_CRN text
RDWY_SEQ_NUM int4
ADJ_RDWY_SEQ int4
ACCESS_CTRL text
ROADWAY_COUNTY text
LANE_COUNT int4
RDWY_ORIENT text
ROAD_OWNER text
ROUTE text
SPEED_LIMIT int4
SEGMENT text
OFFSET int4
STREET_NAME text
TOT_INJ_COUNT int4
SCHOOL_BUS_UNIT text

Дополнительная информация

Поле Величина
Data last updated 30 июня 2025 г.
Метаданные обновлены 30 июня 2025 г.
Создано 18 июня 2025 г.
Формат CSV
Лицензия Creative Commons CCZero
Datastore activeTrue
Has viewsTrue
Hash0c2e57930875eeaf008f53583771eb4f
Id4c016b4c-59f0-45ca-981c-718c784b3462
Mimetypetext/csv
Package id3130f583-9499-472b-bb5a-f63a6ff6059a
Position8
PreviewTrue
Preview rows10 228
Size5 MiB
Stateactive
Total record count10 228
Url typedatapusher

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.