About this Dataset

2020 Census Redistricting Data Extracts (PL 94-171)

Chris Briem of the University of Pittsburgh Center for Social and Urban Research has been producing extracts from the Census Bureau's PL 94-171 redistricting file.

On August 12th, the U.S. Census Bureau released the first detailed data from the 2020 Decennial Census of Population and Housing. Before this, the only data that has been released from the 2020 Census has been total population counts by state needed for the reapportionment of congressional seats. The data just released is known as PL 94-171 data and includes the final census enumeration of the population by race and ethnicity for counties, municipalities, and smaller levels of geography.

PL 94-171 data is used in the redrawing of the boundaries for federal, state, and local legislative districts, a process known as redistricting. This data includes housing unit counts, occupancy status for housing units, population totals, and population by race Hispanic/Latino origin, voting-age population (age 18+), and group quarters counts. The Census Bureau will be releasing additional data, including more detailed population and household statistics from the 2020 Census in the future.
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T18:10:06.030058
Tags: 2010, 2020, block, census-2020, census-bureau, county-subarea, demographics, municipality, neighborhood, pl-94-171, population, redistricting

Tables

Block Index City Of Pittsburgh Neighborhoods

@usgov.allegheny_county_city_of_pitts_2020_census_redistricti_7ad23f6b.block_index_city_of_pittsburgh_neighborhoods

63.72 KB
7378 rows
10 columns


CREATE TABLE block_index_city_of_pittsburgh_neighborhoods (
  "sumlev" DOUBLE,
  "county" BIGINT,
  "cousub" BIGINT,
  "tract" BIGINT,
  "blkgrp" BIGINT,
  "block" BIGINT,
  "name" VARCHAR,
  "geoid20" BIGINT,
  "neighborhood" VARCHAR,
  "neighborhoodgroup" VARCHAR
);

City Of Pittsburgh Neighborhood Population 2020

@usgov.allegheny_county_city_of_pitts_2020_census_redistricti_7ad23f6b.city_of_pittsburgh_neighborhood_population_2020

41.01 KB
89 rows
31 columns


CREATE TABLE city_of_pittsburgh_neighborhood_population_2020 (
  "neighborhood" VARCHAR,
  "n_2010_total_population" BIGINT,
  "n_2010_onerace_population" BIGINT,
  "n_2010_white_alone_population" BIGINT,
  "n_2010_black_alone_population" BIGINT,
  "n_2010_american_indian_and_alaska_native_alone_population" BIGINT,
  "n_2010_asian_alone_population" BIGINT,
  "n_2010_native_hawaiian_and_other_pacific_islander_alon_3faa4342" BIGINT,
  "n_2010_any_other_single_race_alone_popualtion" BIGINT,
  "n_2010_population_two_or_more_races" BIGINT,
  "n_2010_hispanic_or_latino_population" BIGINT,
  "n_2020_total_population" BIGINT,
  "n_2020_onerace_population" BIGINT,
  "n_2020_white_alone_population" BIGINT,
  "n_2020_black_alone_population" BIGINT,
  "n_2020_american_indian_and_alaska_native_alone_population" BIGINT,
  "n_2020_asian_alone_population" BIGINT,
  "n_2020_native_hawaiian_and_other_pacific_islander_alon_50659dca" BIGINT,
  "n_2020_any_other_single_race_alone_popualtion" BIGINT,
  "n_2020_population_two_or_more_races" BIGINT,
  "n_2020_hispanic_or_latino_population" BIGINT,
  "change_2010_to_2020_total_population" BIGINT,
  "change_2010_to_2020_onerace_population" BIGINT,
  "change_2010_to_2020_white_alone_population" BIGINT,
  "change_2010_to_2020_black_alone_population" BIGINT,
  "change_2010_to_2020_american_indian_and_alaska_native__71c8f3a4" BIGINT,
  "change_2010_to_2020_asian_alone_population" BIGINT,
  "change_2010_to_2020_native_hawaiian_and_other_pacific__664e4978" BIGINT,
  "change_2010_to_2020_any_other_single_race_alone_popualtion" BIGINT,
  "change_2010_to_2020_population_two_or_more_races" BIGINT,
  "change_2010_to_2020_hispanic_or_latino_population" BIGINT
);