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

65.25 kB
7,378 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

42 kB
89 rows
31 columns

CREATE TABLE city_of_pittsburgh_neighborhood_population_2020 (
  "neighborhood" VARCHAR,
  "n_2010_total_population" BIGINT  -- 2010 Total Population,
  "n_2010_onerace_population" BIGINT  -- 2010 OneRace Population,
  "n_2010_white_alone_population" BIGINT  -- 2010 White Alone Population,
  "n_2010_black_alone_population" BIGINT  -- 2010 Black Alone Population,
  "n_2010_american_indian_and_alaska_native_alone_population" BIGINT  -- 2010 American Indian And Alaska Native Alone Population,
  "n_2010_asian_alone_population" BIGINT  -- 2010 Asian Alone Population,
  "n_2010_native_hawaiian_and_other_pacific_islander_alon_3faa4342" BIGINT  -- 2010 Native Hawaiian And Other Pacific Islander Alone Population,
  "n_2010_any_other_single_race_alone_popualtion" BIGINT  -- 2010 Any Other Single Race Alone Popualtion,
  "n_2010_population_two_or_more_races" BIGINT  -- 2010 Population Two Or More Races,
  "n_2010_hispanic_or_latino_population" BIGINT  -- 2010 Hispanic Or Latino Population,
  "n_2020_total_population" BIGINT  -- 2020 Total Population,
  "n_2020_onerace_population" BIGINT  -- 2020 OneRace Population,
  "n_2020_white_alone_population" BIGINT  -- 2020 White Alone Population,
  "n_2020_black_alone_population" BIGINT  -- 2020 Black Alone Population,
  "n_2020_american_indian_and_alaska_native_alone_population" BIGINT  -- 2020 American Indian And Alaska Native Alone Population,
  "n_2020_asian_alone_population" BIGINT  -- 2020 Asian Alone Population,
  "n_2020_native_hawaiian_and_other_pacific_islander_alon_50659dca" BIGINT  -- 2020 Native Hawaiian And Other Pacific Islander Alone Population,
  "n_2020_any_other_single_race_alone_popualtion" BIGINT  -- 2020 Any Other Single Race Alone Popualtion,
  "n_2020_population_two_or_more_races" BIGINT  -- 2020 Population Two Or More Races,
  "n_2020_hispanic_or_latino_population" BIGINT  -- 2020 Hispanic Or Latino Population,
  "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 American Indian And Alaska Native Alone Population,
  "change_2010_to_2020_asian_alone_population" BIGINT,
  "change_2010_to_2020_native_hawaiian_and_other_pacific__664e4978" BIGINT  -- Change 2010 To 2020 Native Hawaiian And Other Pacific Islander Alone Population,
  "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
);