(Archive) Allegheny County COVID-19 Monthly...
URL: https://data.wprdc.org/datastore/dump/d93a442d-d69c-48e6-9364-50e23ffc2054
Includes tests, deaths, and confirmed/probable cases.
On April 4th 2022 the Pennsylvania Department of Health no longer required labs to report negative Antigen tests. This historical file contains records through 3/31 including antigen tests. For up-to-date counts for PCR test counts and results see the non-archived version.
There are no views created for this resource yet.
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)". |
| month | text | Month | Year and month of aggregates |
| 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 their initial infection). |
| total_infections | int4 | Sum of infections + reinfections. |
|
| breakthrough_infections | int4 | Number of infections for fully vaccinated individuals (1-dose or 2-dose series) after their fully vaccinated date (2 weeks after their final dose date). |
|
| deaths | int4 | Deaths | Number of deaths where Covid-19 case status is either confirmed or probable. |
| breakthrough_deaths | int4 | Number of deaths for fully vaccinated individuals (1-dose or 2-dose series) after their fully vaccinated date (2 weeks after their final dose date). |
|
| hospitalizations | int4 | Hospitalizations | Number of hospitalizations where Covid-19 case status is either confirmed or probable. |
| breakthrough_hospitalizations | int4 | Number of hospitalizations for fully vaccinated individuals (1-dose or 2-dose series) after their fully vaccinated date (2 weeks after their final dose date). |
|
| 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 | Number of antigen tests taken |
| positive_ag_tests | int4 | Positive Antigen Tests | Number where test type is antigen and test result is positive. |
| pcr_tests | int4 | PCR Tests | Number of PCR tests taken, |
| positive_pcr_tests | int4 | Positive PCR Tests | Where test type is PCR and test result is positive. |
Additional Information
| Field | Value |
|---|---|
| Data last updated | May 1, 2023 |
| Metadata last updated | unknown |
| Created | unknown |
| Format | CSV |
| License | Creative Commons CCZero |
| Created | 2 years ago |
| Media type | text/csv |
| Datastore active | True |
| Has views | False |
| Id | d93a442d-d69c-48e6-9364-50e23ffc2054 |
| Package id | 80e0ca5d-c88a-4b1a-bf5d-51d0aaeeac86 |
| Position | 7 |
| State | active |
| Url type | datapusher |