COVID Tests and Cases

Description

***As of May 2022, these datasets moved from daily updates to weekly updates every Monday.*** **For greatest accuracy, please use the latest dataset for all analysis and reporting as opposed to any data you downloaded prior to September 29, 2020. All datasets now reflect counts from test collection dates instead of the previously displayed result dates. To keep things clear, the field name in the COVID Outcome by Date files also changed from 'Result_Date' to 'CollectionDate.' These changes will adjust, for example, the count of cases for each day. PDPH has also added 376 confirmed COVID-19 cases (positive tests) that were previously missing from the data.** Deidentified, aggregate datasets showing COVID tests by date, zip, and outcome and cases by race, age or sex. To protect the confidentiality of residents, PDPH suppresses the exact data for any categories that have less than 6 counts (i.e. of tests or fatalities).

Resources

Name Format Description Link
2 https://cityofphiladelphia.github.io/carto-api-explorer/#covid_cases_by_outcome
8 https://phl.carto.com/api/v2/sql?q=SELECT+*+FROM+covid_cases_by_date&filename=covid_cases_by_date&format=csv&skipfields=cartodb_id
2 https://cityofphiladelphia.github.io/carto-api-explorer/#covid_cases_by_date
21 https://metadata.phila.gov/#home/datasetdetails/5ea725f6890f920015c17af8/representationdetails/5ea73b68890f920015c190d3/
8 https://phl.carto.com/api/v2/sql?q=SELECT+*+FROM+covid_cases_by_zip&filename=covid_cases_by_zip&format=csv&skipfields=cartodb_id
61 https://phl.carto.com/api/v2/sql?q=SELECT+*+FROM+covid_cases_by_zip&filename=covid_cases_by_zip&format=shp&skipfields=cartodb_id
15 https://phl.carto.com/api/v2/sql?q=SELECT+*+FROM+covid_cases_by_zip&filename=covid_cases_by_zip&format=geojson&skipfields=cartodb_id
2 https://cityofphiladelphia.github.io/carto-api-explorer/#covid_cases_by_zip
21 https://metadata.phila.gov/#home/datasetdetails/5ea725f6890f920015c17af8/representationdetails/5ea73ae520b5b10015e10d10/
8 https://phl.carto.com/api/v2/sql?q=SELECT+*+FROM+covid_cases_by_age&filename=covid_cases_by_age&format=csv&skipfields=cartodb_id
2 https://cityofphiladelphia.github.io/carto-api-explorer/#covid_cases_by_age
21 https://metadata.phila.gov/#home/datasetdetails/5ea725f6890f920015c17af8/representationdetails/5ea725f6890f920015c17afc/
8 https://phl.carto.com/api/v2/sql?q=SELECT+*+FROM+covid_cases_by_sex&filename=covid_cases_by_sex&format=csv&skipfields=cartodb_id
2 https://cityofphiladelphia.github.io/carto-api-explorer/#covid_cases_by_sex
21 https://metadata.phila.gov/#home/datasetdetails/5ea725f6890f920015c17af8/representationdetails/5ea73b819b544f0016339e8b/
8 https://phl.carto.com/api/v2/sql?filename=covid_cases_by_race&format=csv&skipfields=cartodb_id,the_geom,the_geom_webmercator&q=SELECT%20*%20FROM%20covid_cases_by_race
2 https://cityofphiladelphia.github.io/carto-api-explorer/#covid_cases_by_race
8 https://phl.carto.com/api/v2/sql?q=SELECT+*+FROM+covid_cases_by_outcome&filename=covid_cases_by_outcome&format=csv&skipfields=cartodb_id
21 https://metadata.phila.gov/#home/datasetdetails/5ea725f6890f920015c17af8/representationdetails/5eda5c1bfcec2f0015af6656/
21 https://metadata.phila.gov/#home/datasetdetails/5ea725f6890f920015c17af8/representationdetails/5f0db610b084460016abaf14/

Tags

  • human-services
  • coronavirus
  • philadelphia-department-of-public-health
  • economy
  • health
  • covid-19

Topics

  • Local Government

Categories