Profiles Data by US Government | Demographics and Population Studies

About this Dataset

Profiles Data

Data used to link profiles with data in the data center.
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T18:10:30.504735
Tags: _profiles

Tables

Tracts Lookup

@usgov.allegheny_county_city_of_pitts_profiles_data.tracts_lookup

3.03 MB
3217 rows
3 columns


CREATE TABLE tracts_lookup (
  "id" BIGINT,
  "geoid" BIGINT,
  "geom" VARCHAR
);

County Lookup

@usgov.allegheny_county_city_of_pitts_profiles_data.county_lookup

77.7 KB
10 rows
3 columns


CREATE TABLE county_lookup (
  "id" BIGINT,
  "geoid" BIGINT,
  "geom" VARCHAR
);

Blockgroup Lookup

@usgov.allegheny_county_city_of_pitts_profiles_data.blockgroup_lookup

5.57 MB
9739 rows
3 columns


CREATE TABLE blockgroup_lookup (
  "id" BIGINT,
  "geoid" BIGINT,
  "geom" VARCHAR
);

County Subdivision Lookuip

@usgov.allegheny_county_city_of_pitts_profiles_data.county_subdivision_lookuip

2.73 MB
2572 rows
3 columns


CREATE TABLE county_subdivision_lookuip (
  "id" BIGINT,
  "geoid" BIGINT,
  "geom" VARCHAR
);

School District Lookup

@usgov.allegheny_county_city_of_pitts_profiles_data.school_district_lookup

1.29 MB
501 rows
3 columns


CREATE TABLE school_district_lookup (
  "id" BIGINT,
  "geoid" BIGINT,
  "geom" VARCHAR
);

PUMA Lookup

@usgov.allegheny_county_city_of_pitts_profiles_data.puma_lookup

560.1 KB
92 rows
3 columns


CREATE TABLE puma_lookup (
  "id" BIGINT,
  "geoid" BIGINT,
  "geom" VARCHAR
);

Place Lookup

@usgov.allegheny_county_city_of_pitts_profiles_data.place_lookup

1.09 MB
1761 rows
3 columns


CREATE TABLE place_lookup (
  "id" BIGINT,
  "geoid" BIGINT,
  "geom" VARCHAR
);

COVID-19 Vaccinations By Race Across Zip Codes

@usgov.allegheny_county_city_of_pitts_profiles_data.covid_19_vaccinations_by_race_across_zip_codes

107.92 KB
3112 rows
16 columns


CREATE TABLE covid_19_vaccinations_by_race_across_zip_codes (
  "patient_zip_code" BIGINT,
  "partially_covered_african_american" DOUBLE,
  "partially_covered_asian" DOUBLE,
  "partially_covered_native_american" DOUBLE,
  "partially_covered_pacific_islander" DOUBLE,
  "partially_covered_multiple_other" DOUBLE,
  "partially_covered_white" DOUBLE,
  "partially_covered_unknown" DOUBLE,
  "fully_covered_african_american" DOUBLE,
  "fully_covered_asian" DOUBLE,
  "fully_covered_native_american" DOUBLE,
  "fully_covered_pacific_islander" DOUBLE,
  "fully_covered_multiple_other" DOUBLE,
  "fully_covered_white" DOUBLE,
  "fully_covered_unknown" DOUBLE,
  "georeferenced_latitude_longitude" VARCHAR
);