{"accessLevel": "public", "contactPoint": {"fn": "PublicHealthInfo@phila.gov", "hasEmail": "mailto:PublicHealthInfo@phila.gov"}, "description": "***As of May 2022, these datasets moved from daily updates to weekly updates every Monday.***\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": [{"downloadURL": "https://phl.carto.com/api/v2/sql?q=SELECT+*+FROM+covid_cases_by_outcome&filename=covid_cases_by_outcome&format=csv&skipfields=cartodb_id", "format": "CSV", "mediaType": "text/csv", "title": "COVID Tests by Outcome (CSV)"}, {"accessURL": "https://cityofphiladelphia.github.io/carto-api-explorer/#covid_cases_by_outcome", "format": "API", "mediaType": "application/http", "title": "COVID Tests by Outcome (API)"}, {"accessURL": "https://metadata.phila.gov/#home/datasetdetails/5ea725f6890f920015c17af8/representationdetails/5eda5c1bfcec2f0015af6656/", "format": "HTML", "mediaType": "text/html", "title": "COVID Tests by Outcome (Metadata)"}, {"downloadURL": "https://phl.carto.com/api/v2/sql?q=SELECT+*+FROM+covid_cases_by_date&filename=covid_cases_by_date&format=csv&skipfields=cartodb_id", "format": "CSV", "mediaType": "text/csv", "title": "COVID Tests by Date (CSV)"}, {"accessURL": "https://cityofphiladelphia.github.io/carto-api-explorer/#covid_cases_by_date", "format": "API", "mediaType": "application/http", "title": "COVID Tests by Date (API)"}, {"accessURL": "https://metadata.phila.gov/#home/datasetdetails/5ea725f6890f920015c17af8/representationdetails/5ea73b68890f920015c190d3/", "format": "HTML", "mediaType": "text/html", "title": "COVID Tests by Date (Metadata)"}, {"downloadURL": "https://phl.carto.com/api/v2/sql?q=SELECT+*+FROM+covid_cases_by_zip&filename=covid_cases_by_zip&format=csv&skipfields=cartodb_id", "format": "CSV", "mediaType": "text/csv", "title": "COVID Tests by ZIP (CSV)"}, {"downloadURL": "https://phl.carto.com/api/v2/sql?q=SELECT+*+FROM+covid_cases_by_zip&filename=covid_cases_by_zip&format=shp&skipfields=cartodb_id", "format": "SHP", "mediaType": "application/zip", "title": "COVID Tests by ZIP (SHP)"}, {"downloadURL": "https://phl.carto.com/api/v2/sql?q=SELECT+*+FROM+covid_cases_by_zip&filename=covid_cases_by_zip&format=geojson&skipfields=cartodb_id", "format": "GEOJSON", "mediaType": "application/octet-stream", "title": "COVID Tests by ZIP (GeoJSON)"}, {"accessURL": "https://cityofphiladelphia.github.io/carto-api-explorer/#covid_cases_by_zip", "format": "API", "mediaType": "application/http", "title": "COVID Tests by ZIP (API)"}, {"accessURL": "https://metadata.phila.gov/#home/datasetdetails/5ea725f6890f920015c17af8/representationdetails/5ea73ae520b5b10015e10d10/", "format": "HTML", "mediaType": "text/html", "title": "COVID Tests by ZIP (Metadata)"}, {"downloadURL": "https://phl.carto.com/api/v2/sql?q=SELECT+*+FROM+covid_cases_by_age&filename=covid_cases_by_age&format=csv&skipfields=cartodb_id", "format": "CSV", "mediaType": "text/csv", "title": "COVID Cases by Age (CSV)"}, {"accessURL": "https://cityofphiladelphia.github.io/carto-api-explorer/#covid_cases_by_age", "format": "API", "mediaType": "application/http", "title": "COVID Cases by Age (API)"}, {"accessURL": "https://metadata.phila.gov/#home/datasetdetails/5ea725f6890f920015c17af8/representationdetails/5ea725f6890f920015c17afc/", "format": "HTML", "mediaType": "text/html", "title": "COVID Cases by Age (Metadata)"}, {"downloadURL": "https://phl.carto.com/api/v2/sql?q=SELECT+*+FROM+covid_cases_by_sex&filename=covid_cases_by_sex&format=csv&skipfields=cartodb_id", "format": "CSV", "mediaType": "text/csv", "title": "COVID Cases by Sex (CSV)"}, {"accessURL": "https://cityofphiladelphia.github.io/carto-api-explorer/#covid_cases_by_sex", "format": "API", "mediaType": "application/http", "title": "COVID Cases by Sex (API)"}, {"accessURL": "https://metadata.phila.gov/#home/datasetdetails/5ea725f6890f920015c17af8/representationdetails/5ea73b819b544f0016339e8b/", "format": "HTML", "mediaType": "text/html", "title": "COVID Cases by Sex (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*%20FROM%20covid_cases_by_race", "format": "CSV", "mediaType": "text/csv", "title": "COVID Cases by Race (CSV)"}, {"accessURL": "https://cityofphiladelphia.github.io/carto-api-explorer/#covid_cases_by_race", "format": "API", "mediaType": "application/http", "title": "COVID Cases by Race (API)"}, {"accessURL": "https://metadata.phila.gov/#home/datasetdetails/5ea725f6890f920015c17af8/representationdetails/5f0db610b084460016abaf14/", "format": "HTML", "mediaType": "text/html", "title": "COVID Cases by Race (Metadata)"}], "identifier": "covid-tests-and-cases", "keyword": ["economy", "health", "human services", "COVID-19", "Coronavirus", "Philadelphia Department of Public Health"], "license": "https://metadata.phila.gov/#help/help-faqs/what-are-the-terms-of-use/", "publisher": {"@type": "org:Organization", "name": "City of Philadelphia"}, "spatial": "Philadelphia, Pennsylvania", "title": "COVID Tests and Cases"}