Data Dictionary

Column Type Label Description
Template text Template

The Type of report conducted according to the record management system.

Case_Number text Case_Number

The PBP Reporting number associated with the respective case.

ArrestPerson_ID text ArrestPerson_ID

A Unique number associated with the respective case and subject.

Arrest_Date timestamp Arrest_Date

The date that the arrest report was created from.

Arrest_Year numeric Arrest_Year

The year when the arrest report was created.

Arrest_Month text Arrest_Month

The month when the arrest report was created.

Arrest_Time text Arrest_Time

The time when the arrest report was created.

Type text Type

Either an “On-View Arrest”, a “Summons/Cited Arrest”, or “Taken into custody (Warrant) Arrest”.

ArrestPerson_Age numeric ArrestPerson_Age

Arrestee's age at the time of arrest.

ArrestPerson_Sex text ArrestPerson_Sex

Arrestee's sex at the time of arrest.

ArrestPerson_Race text ArrestPerson_Race

Arrestee's race at the time of arrest.

NIBRS_Coded_Offense text NIBRS_Coded_Offense

Code associated with the FBI’s National Incident-Based Reporting System (NIBRS).

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

Arrestee's violation per PA Crime Code.

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.

ArrestCharge_Felony_Misdemeanor_Description text ArrestCharge_Felony_Misdemeanor_Description

The charge and classification of charge associated with the Arrest (Felony, Misdemeanor, Infraction, and degree of level).

XCOORD text XCOORD

The X coordinate associated with the arrest report.

YCOORD text YCOORD

The Y coordinate associated with the arrest report.

Block_Address text Block_Address

The address of where the arrest occurred rounded to the nearest block level.

Additional Information

Field Value
Data last updated April 9, 2025
Metadata last updated April 9, 2025
Created April 9, 2025
Format XLSX
License License not specified
Datastore activeTrue
Has viewsTrue
Hash66e5ead3ba8e336df3c44f0833187604
Ide419c20c-8df4-4729-830c-e49427a656e0
Mimetypeapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Package idb62e8c3f-f40e-4b3f-9c60-82509bc397fb
Position0
PreviewTrue
Preview rows22,027
Size3.9 MiB
Stateactive
Total record count22,027
Url typeupload