Data Dictionary

Column Type Label Description
Report_Number text Report_Number

The PBP Reporting number associated with the respective case

ReportedDate timestamp ReportedDate

The date that the report was created

ReportedTime text ReportedTime

The time that the report was created

Hour numeric Hour

The time that the report was created within the hour (ex. 11:48 pm = 11:00pm)

DayofWeek text DayofWeek

Day of the week in which the report was created

ReportedMonth text ReportedMonth

The month when the report was created

NIBRS_Coded_Offense text NIBRS_Coded_Offense

Code associated with the FBI’s National Incident Based Reporting System (NIBRS) NIBRS related Sexual Offenses will have the Tract, Block_Address, XCOORD, and YCOORD represented by "N/A".

NIBRS_Offense_Code text NIBRS_Offense_Code

The 3-digit code associated with NIBRS offense

NIBRS_Offense_Category text NIBRS_Offense_Category

Aggregated type of NIBRS offense

NIBRS_Offense_Type text NIBRS_Offense_Type

Aggregated type of NIBRS offense

NIBRS_Crime_Against text NIBRS_Crime_Against

Aggregated type of NIBRS offense

NIBRS_Offense_Grouping text NIBRS_Offense_Grouping

Aggregated type of NIBRS offense

Violation text Violation

Subject’s violation per PA Crime Code

XCOORD text XCOORD

The X coordinate associated with the arrest report

YCOORD text YCOORD

The Y coordinate associated with the arrest report

Zone text Zone

The zone where the crime occurred

Tract text Tract

The census tract where the crime occurred

Neighborhood text Neighborhood

The neighborhood where the crime occurred

Block_Address text Block_Address

The address of where the crime occurred, rounded to the nearest block level

Additional Information

Field Value
Data last updated April 8, 2025
Metadata last updated April 8, 2025
Created April 7, 2025
Format XLSX
License License not specified
Datastore activeTrue
Has viewsTrue
Hash2fee480c4d45e5ad5a53b40a7370920d
Idbd41992a-987a-4cca-8798-fbe1cd946b07
Mimetypeapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Package id65e69ee3-93b2-4f7a-b9cb-8ce977f15d9a
Position0
PreviewTrue
Preview rows47,713
Size7 MiB
Stateactive
Total record count47,713
Url typeupload