Name: 2010 Census Tracts
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

2010 Census Tracts

Pittsburgh 2010 Census Tracts
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T18:03:59.826670
Tags: _etl, demographics, pittsburgh

Tables

Table 1

@usgov.allegheny_county_city_of_pitts_2010_census_tracts_894e8.table_1

40.72 kB
138 rows
32 columns

CREATE TABLE table_1 (
  "n__id" BIGINT  -- Id,
  "objectid" BIGINT,
  "statefp10" BIGINT,
  "countyfp10" BIGINT,
  "tractce10" BIGINT,
  "blkgrpce10" BIGINT,
  "geoid10" BIGINT,
  "namelsad10" VARCHAR,
  "mtfcc10" VARCHAR,
  "funcstat10" VARCHAR,
  "aland10" BIGINT,
  "awater10" BIGINT,
  "intptlat10" DOUBLE,
  "intptlon10" DOUBLE,
  "hood" VARCHAR,
  "hood_no" BIGINT,
  "acres" DOUBLE,
  "sqmiles" DOUBLE,
  "sectors" BIGINT,
  "tract" BIGINT,
  "cdbg2014" VARCHAR,
  "tracttext" BIGINT,
  "objectid_1" BIGINT,
  "tractce10_1" BIGINT,
  "cnt_tractce10" BIGINT,
  "sum_lowmod2018" BIGINT,
  "sum_lowmoduniv" BIGINT,
  "lowmodperct" DOUBLE,
  "lowmodpercanno" DOUBLE,
  "cdbg2018" VARCHAR,
  "shape_area" DOUBLE,
  "shape_length" DOUBLE
);