About this Dataset

Allegheny County Jail Daily Census

A daily census of the inmates at the Allegheny County Jail (ACJ). Includes gender, race, age at booking, and current age. The records for each month contain a census for every day, therefore many inmates records are repeated each day.

Another representation of this data is the County's jail population management dashboard.
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T17:58:55.682382
Tags: _etl, census, crime, inmates, jail, public-safety

Tables

ACJ Daily Census Data - 10/2015 (deprecated)

@usgov.allegheny_county_city_of_pitts_allegheny_county_jail_d_fd009130.acj_daily_census_data_10_2015_deprecated

137.64 kB
77,295 rows
5 columns

CREATE TABLE acj_daily_census_data_10_2015_deprecated (
  "date" TIMESTAMP,
  "gender" VARCHAR,
  "race" VARCHAR,
  "age_at_booking" DOUBLE,
  "current_age" DOUBLE
);

ACJ Daily Census Data - 11/2015 (deprecated)

@usgov.allegheny_county_city_of_pitts_allegheny_county_jail_d_fd009130.acj_daily_census_data_11_2015_deprecated

2.25 MB
289,764 rows
6 columns

CREATE TABLE acj_daily_census_data_11_2015_deprecated (
  "n__id" BIGINT  -- Id,
  "date" TIMESTAMP,
  "gender" VARCHAR,
  "race" VARCHAR,
  "age_at_booking" DOUBLE,
  "current_age" BIGINT
);