Allegheny County COVID-19 Tests, Cases and Deaths

Description

COVID-19 Cases information is reported through the Pennsylvania State Department’s National Electronic Disease Surveillance System (PA-NEDSS). As new cases are passed to the Allegheny County Health Department they are investigated by case investigators. During investigation some cases which are initially determined by the State to be in the Allegheny County jurisdiction may change, which can account for differences between publication of the files on the number of cases, deaths and tests. Additionally, information is not always reported to the State in a timely manner, delays can range from days to weeks, which can also account for discrepancies between previous and current files. Test and Case information will be updated daily. This resource contains individuals who received a COVID-19 test and individuals whom are probable cases. Every day, these records are overwritten with updates. Each row in the data reflects a person that is tested, not tests that are conducted. People that are tested more than once will have their testing and case data updated using the following rules: 1. Positive tests overwrite negative tests. 2. Polymerase chain reaction (PCR) tests overwrite antibody or antigen (AG) tests. 3. The first positive PCR test is never overwritten. Data collected from additional tests do not replace the first positive PCR test. _*Note:* On April 4th 2022 the Pennsylvania Department of Health no longer required labs to report negative AG tests. Therefore aggregated counts that included AG tests have been removed from the Municipality/Neighborhood files going forward. Versions of this data up to this cut-off have been retained as archived files._ Individual Test information is also updated daily. This resource contains the details and results of individual tests along with demographic information of the individual tested. Only PCR and AG tests are included. Every day, these records are overwritten with updates. This resource should be used to determine positivity rates. The remaining datasets provide statistics on death demographics. Demographic, municipality and neighborhood information for deaths are reported on a weekly schedule and are not included with individual cases or tests. This has been done to protect the privacy and security of individuals and their families in accordance with the Health Insurance Portability and Accountability Act (HIPAA). 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 counted as "Undefined". Since the start of the pandemic, the ACHD has mapped every day’s COVID tests, cases, and deaths to their Allegheny County municipality and neighborhood. Tests were mapped to patient address, and if this was not available, to the provider location. This has recently resulted in apparent testing rates that exceeded the populations of various municipalities -- mostly those with healthcare providers. As this was brought to our attention, the health department and our data partners began researching and comparing methods to most accurately display the data. This has led us to leave those with missing home addresses off the map. Although these data will still appear in test, case and death counts, there will be over 20,000 fewer tests and almost 1000 fewer cases on the map. In addition to these map changes, we have identified specific health systems and laboratories that had data uploading errors that resulted in missing locations, and are working with them to correct these errors. Due to minor discrepancies in the Municipal boundary and the City of Pittsburgh Neighborhood files individuals whose City Neighborhood cannot be identified are be counted as “Undefined (Pittsburgh)”.

Resources

Name Format Description Link
8 Includes confirmed and probable cases. Updated weekly. https://data.wprdc.org/datastore/dump/7507526c-1e28-49be-8b62-808fdd0b4029
8 Includes tests, deaths, and confirmed/probable cases. Updated weekly. https://data.wprdc.org/datastore/dump/0f214885-ff3e-44e1-9963-e9e9062a04d1
8 Monthly County-wide Counts for the various levels of vaccination status individuals had at the time of infection. https://data.wprdc.org/datastore/dump/a3553be0-67df-4a00-acb5-502cbf33b61c
8 Date of collection of various positive tests for individuals through Allegheny County. https://data.wprdc.org/datastore/dump/141040c7-b90c-4699-ad5b-ff5862d3a5cc
21 The WPRDC's Unofficial Data Guide to COVID-19 test, case, hospitalization, and death data. A living document. https://docs.google.com/document/d/19fvMCYYWXdB8lC7augb84kaCEvm--G-_N9UkW_pG_vw/edit?usp=sharingG-_N9UkW_pG_vw/edit?usp=sharing
8 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. https://data.wprdc.org/datastore/dump/d93a442d-d69c-48e6-9364-50e23ffc2054
21 https://tableau.alleghenycounty.us/t/PublicSite/views/COVID-19-VariantandGenomicSurveillance_16523720460910/VariantsandGenomicSurveillanceforSARS-CoV-2?:embed=y&:showAppBanner=false&:display_count=n&:showVizHome=n&:origin=viz_share_link
8 On April 4th 2022 the Pennsylvania Department of Health no longer required labs to report negative Antigen tests. This historical file contains records through 4/3 including antigen tests. For up-to-date counts for PCR test counts and results see the non-archived version. https://data.wprdc.org/datastore/dump/abbfc1a0-9343-4fe9-8e4f-61c56ce6526e
21 https://tableau.alleghenycounty.us/t/PublicSite/views/AlleghenyCountyCOVID-19-PostVaccineSurveillance/COVID-19Post-VaccineSurveillance?:embed=y&:showAppBanner=false&:display_count=n&:showVizHome=n&:origin=viz_share_link
8 Testing and case data by individual. Updated daily Monday-Friday. https://data.wprdc.org/dataset/80e0ca5d-c88a-4b1a-bf5d-51d0aaeeac86/resource/4051a85a-bf92-45fc-adc6-b31eb8efaad4/download/covid_19_testing_cases.csv
8 Includes confirmed and probable cases. Updated weekly. https://data.wprdc.org/datastore/dump/dd92b53c-6a90-4b83-9810-c6e8689d325c
8 Test-level data, including type of test, results, and demographics. Updated daily Monday-Friday. https://data.wprdc.org/dataset/80e0ca5d-c88a-4b1a-bf5d-51d0aaeeac86/resource/ec9ced6e-9d5e-4982-a591-459252725937/download/covid_19_tests.csv
8 Monthly community statistics including tests, cases, hospitalizations, and deaths. https://data.wprdc.org/datastore/dump/3869680f-8faa-4e8c-8c01-6aa1309c40ad
21 Dashboards developed by from the Allegheny County Health Department, updated daily and including the number of complete COVID-19 tests, the number of positive tests, the number of hospitalizations, the number of patients in intensive care units, and the number of deaths. The dashboard has a map showing a geographic breakdown of cases by municipality/Pittsburgh neighborhood, distributions by age and race, and a timeline showing cases by specimen collection date. https://www.alleghenycounty.us/Health-Department/Resources/COVID-19/COVID-19-Dashboards.aspx

Tags

  • covid19
  • coronavirus
  • hospitalization
  • _etl
  • sars-cov-2
  • testing
  • death
  • case
  • health
  • covid-19

Topics

  • Local Government

Categories