Data Dictionary

Column Type Label Description
neighborhood_municipality text Pittsburgh Neighborhood/Allegheny County Municipality

Municipality or City of Pittsburgh Neighborhood is based off the geocoded home address of the individual tested.

Individuals whose home address is incomplete may not be in Allegheny County but whose temporary residency, work or other mitigating circumstance are determined to be in Allegheny County by the Pennsylvania Department of Health are listed as "Undefined".

Due to minor discrepancies in the Municipal boundary and the City of Pittsburgh Neighborhood files individuals whose City Neighborhood cannot be identified are be listed as “Undefined (Pittsburgh)”.

individuals_tested int4 Individuals Tested

Number of individuals with at least 1 viral (PCR or Antigen) test result for COVID-19.

infections int4 Infections

Number of individuals infected with COVID-19 for the first time.

reinfections int4 Reinfections

Number of individuals infected with COVID-19 for the second time (at least 90 days after initial infection).

deaths int4 Deaths

Number of deaths where COVID-19 case status is either confirmed or probable.

hospitalizations int4 Hospitalizations

Number of hospitalizations where COVID-19 case status is either confirmed or probable.

tests int4 Tests

Total number of tests (ag_tests + pcr_tests).

postives int4 Positives

Total number of tests with a positive test result (positive_ag_tests + positive_pcr_tests).

ag_tests int4 Antigen Tests
positive_ag_tests int4 Positive Antigen Tests

Where test type is antigen and test result is positive.

pcr_tests int4 PCR Tests
positive_pcr_tests int4 Positive PCR Tests

Where test type is PCR and test result is positive.

update_date date Update Date

Date of most recent update to the dataset.

Additional Information

Field Value
Data last updated May 19, 2023
Metadata last updated April 1, 2022
Created April 1, 2022
Format CSV
License Creative Commons CCZero
Datastore activeTrue
Has viewsFalse
Idabbfc1a0-9343-4fe9-8e4f-61c56ce6526e
Mimetypetext/csv
Package id80e0ca5d-c88a-4b1a-bf5d-51d0aaeeac86
Position5
Stateactive
Url typedatapusher