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.504738
Tags: _profiles

Tables

Blockgroup Lookup

@usgov.allegheny_county_city_of_pitts_profiles_data.blockgroup_lookup

5.84 MB
9,739 rows
3 columns

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

County Lookup

@usgov.allegheny_county_city_of_pitts_profiles_data.county_lookup

79.56 kB
10 rows
3 columns

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

County Subdivision Lookuip

@usgov.allegheny_county_city_of_pitts_profiles_data.county_subdivision_lookuip

2.87 MB
2,572 rows
3 columns

CREATE TABLE county_subdivision_lookuip (
  "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

110.51 kB
3,112 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  -- Georeferenced Latitude & Longitude
);

Place Lookup

@usgov.allegheny_county_city_of_pitts_profiles_data.place_lookup

1.15 MB
1,761 rows
3 columns

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

PUMA Lookup

@usgov.allegheny_county_city_of_pitts_profiles_data.puma_lookup

573.55 kB
92 rows
3 columns

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

School District Lookup

@usgov.allegheny_county_city_of_pitts_profiles_data.school_district_lookup

1.35 MB
501 rows
3 columns

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