Data Dictionary

Column Type Label Description
record_id int4 Unique record ID

A unique identifier for this particular census record.

census_date date Census date

Date of the daily jail census that produced this record.

gender text Gender

The gender of the inmate. Null values appear where the gender of an inmate was accidentally not recorded for a particular day.

race text Race

The race of the inmate. Possible values are: A: ASIAN OR PACIFIC ISLANDER, B: BLACK OR AFRICAN AMERICAN, H: HISPANIC, I: AMERICAN INDIAN OR ALASKAN NATIVE, U: UNKNOWN, W: WHITE, x: BIRACIAL [we note that this does not appear in the records before 2016-09], O: ALL OTHERS

Null values appear where the race of the inmate was accidentally not recorded for a particular day.

age_at_booking int4 Age at booking

The age in years of the inmate at the Allegheny County Jail at booking.

age_at_census int4 Age at census

The age in years of the inmate on the day of the census.

Additional Information

Field Value
Data last updated November 25, 2024
Metadata last updated November 25, 2024
Created October 14, 2015
Format CSV
License Creative Commons CCZero
Datastore activeTrue
Has viewsTrue
Id66cdcd57-6c92-4aaa-8800-0ed9d8f03e22
Mimetypetext/csv
Package idd15ca172-66df-4508-8562-5ec54498cfd4
Position0
Revision idef247a91-5c9f-44cb-ac8d-fa6fce2051aa
Stateactive
Url typedatapusher