{"action":"create","ckan_id":null,"date_created":"Sat, 04 Apr 2026 21:58:33 GMT","date_finished":null,"harvest_job_id":"ae5041d5-4abf-43eb-b665-66f0181c07b3","harvest_source_id":"273d8fe1-da31-4ee1-853a-037e5f9307bf","id":"b1ca1191-fc75-466e-bdd3-562efcfa5590","identifier":"covid-tests-and-cases","parent_identifier":null,"source_hash":"22d4a139d28a56fe7b117e2c4187132f76aefb2c9b11f65f7b61ae011d639db2","source_raw":"{\"accessLevel\": \"public\", \"contactPoint\": {\"fn\": \"PublicHealthInfo@phila.gov\", \"hasEmail\": \"mailto:PublicHealthInfo@phila.gov\"}, \"description\": \"***COVID datasets are now a snapshot in time from 2020 - December 2024.***\\r\\n\\r\\n**  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.**\\r\\n\\r\\nDeidentified, 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).\\r\\n\\r\\n\", \"distribution\": [{\"accessURL\": \"https://cityofphiladelphia.github.io/carto-api-explorer/#covid_cases_by_age\", \"format\": \"API\", \"mediaType\": \"application/http\", \"title\": \"2020 - 2024 COVID Cases by Age (API)\"}, {\"accessURL\": \"https://cityofphiladelphia.github.io/carto-api-explorer/#covid_cases_by_date\", \"format\": \"API\", \"mediaType\": \"application/http\", \"title\": \"2020 - 2024 COVID Tests by Date (API)\"}, {\"accessURL\": \"https://cityofphiladelphia.github.io/carto-api-explorer/#covid_cases_by_outcome\", \"format\": \"API\", \"mediaType\": \"application/http\", \"title\": \"2020 - 2024 COVID Tests by Outcome (API)\"}, {\"accessURL\": \"https://cityofphiladelphia.github.io/carto-api-explorer/#covid_cases_by_race\", \"format\": \"API\", \"mediaType\": \"application/http\", \"title\": \"2020 - 2024 COVID Cases by Race (API)\"}, {\"accessURL\": \"https://cityofphiladelphia.github.io/carto-api-explorer/#covid_cases_by_sex\", \"format\": \"API\", \"mediaType\": \"application/http\", \"title\": \"2020 - 2024 COVID Cases by Sex (API)\"}, {\"accessURL\": \"https://cityofphiladelphia.github.io/carto-api-explorer/#covid_cases_by_zip\", \"format\": \"API\", \"mediaType\": \"application/http\", \"title\": \"2020 - 2024 COVID Tests by ZIP (API)\"}, {\"accessURL\": \"https://metadata.phila.gov/#home/datasetdetails/5ea725f6890f920015c17af8/representationdetails/5ea725f6890f920015c17afc/\", \"format\": \"HTML\", \"mediaType\": \"text/html\", \"title\": \"2020 - 2024 COVID Cases by Age (Metadata)\"}, {\"accessURL\": \"https://metadata.phila.gov/#home/datasetdetails/5ea725f6890f920015c17af8/representationdetails/5ea73ae520b5b10015e10d10/\", \"format\": \"HTML\", \"mediaType\": \"text/html\", \"title\": \"2020 - 2024 COVID Tests by ZIP (Metadata)\"}, {\"accessURL\": \"https://metadata.phila.gov/#home/datasetdetails/5ea725f6890f920015c17af8/representationdetails/5ea73b68890f920015c190d3/\", \"format\": \"HTML\", \"mediaType\": \"text/html\", \"title\": \"2020 - 2024 COVID Tests by Date (Metadata)\"}, {\"accessURL\": \"https://metadata.phila.gov/#home/datasetdetails/5ea725f6890f920015c17af8/representationdetails/5ea73b819b544f0016339e8b/\", \"format\": \"HTML\", \"mediaType\": \"text/html\", \"title\": \"2020 - 2024 COVID Cases by Sex (Metadata)\"}, {\"accessURL\": \"https://metadata.phila.gov/#home/datasetdetails/5ea725f6890f920015c17af8/representationdetails/5eda5c1bfcec2f0015af6656/\", \"format\": \"HTML\", \"mediaType\": \"text/html\", \"title\": \"2020 - 2024 COVID Tests by Outcome (Metadata)\"}, {\"accessURL\": \"https://metadata.phila.gov/#home/datasetdetails/5ea725f6890f920015c17af8/representationdetails/5f0db610b084460016abaf14/\", \"format\": \"HTML\", \"mediaType\": \"text/html\", \"title\": \"2020 - 2024 COVID Cases by Race (Metadata)\"}, {\"downloadURL\": \"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%2A%20FROM%20covid_cases_by_race\", \"format\": \"CSV\", \"mediaType\": \"text/csv\", \"title\": \"2020 - 2024 COVID Cases by Race (CSV)\"}, {\"downloadURL\": \"https://phl.carto.com/api/v2/sql?q=SELECT+%2A+FROM+covid_cases_by_age&filename=covid_cases_by_age&format=csv&skipfields=cartodb_id\", \"format\": \"CSV\", \"mediaType\": \"text/csv\", \"title\": \"2020 - 2024 COVID Cases by Age (CSV)\"}, {\"downloadURL\": \"https://phl.carto.com/api/v2/sql?q=SELECT+%2A+FROM+covid_cases_by_date&filename=covid_cases_by_date&format=csv&skipfields=cartodb_id\", \"format\": \"CSV\", \"mediaType\": \"text/csv\", \"title\": \"2020 - 2024 COVID Tests by Date (CSV)\"}, {\"downloadURL\": \"https://phl.carto.com/api/v2/sql?q=SELECT+%2A+FROM+covid_cases_by_outcome&filename=covid_cases_by_outcome&format=csv&skipfields=cartodb_id\", \"format\": \"CSV\", \"mediaType\": \"text/csv\", \"title\": \"2020 - 2024 COVID Tests by Outcome (CSV)\"}, {\"downloadURL\": \"https://phl.carto.com/api/v2/sql?q=SELECT+%2A+FROM+covid_cases_by_sex&filename=covid_cases_by_sex&format=csv&skipfields=cartodb_id\", \"format\": \"CSV\", \"mediaType\": \"text/csv\", \"title\": \"2020 - 2024 COVID Cases by Sex (CSV)\"}, {\"downloadURL\": \"https://phl.carto.com/api/v2/sql?q=SELECT+%2A+FROM+covid_cases_by_zip&filename=covid_cases_by_zip&format=csv&skipfields=cartodb_id\", \"format\": \"CSV\", \"mediaType\": \"text/csv\", \"title\": \"2020 - 2024 COVID Tests by ZIP (CSV)\"}, {\"downloadURL\": \"https://phl.carto.com/api/v2/sql?q=SELECT+%2A+FROM+covid_cases_by_zip&filename=covid_cases_by_zip&format=geojson&skipfields=cartodb_id\", \"format\": \"GEOJSON\", \"mediaType\": \"application/octet-stream\", \"title\": \"2020 - 2024 COVID Tests by ZIP (GeoJSON)\"}, {\"downloadURL\": \"https://phl.carto.com/api/v2/sql?q=SELECT+%2A+FROM+covid_cases_by_zip&filename=covid_cases_by_zip&format=shp&skipfields=cartodb_id\", \"format\": \"SHP\", \"mediaType\": \"application/zip\", \"title\": \"2020 - 2024 COVID Tests by ZIP (SHP)\"}], \"identifier\": \"covid-tests-and-cases\", \"keyword\": [\"COVID-19\", \"Coronavirus\", \"Philadelphia Department of Public Health\", \"economy\", \"health\", \"human services\"], \"license\": \"https://metadata.phila.gov/#help/help-faqs/what-are-the-terms-of-use/\", \"modified\": null, \"publisher\": {\"@type\": \"org:Organization\", \"name\": \"City of Philadelphia\"}, \"spatial\": \"Philadelphia, Pennsylvania\", \"title\": \"COVID Tests and Cases\"}","source_transform":null,"status":"error"}