{"action":"create","ckan_id":null,"date_created":"Fri, 09 Jan 2026 06:38:01 GMT","date_finished":null,"harvest_job_id":"5e5a388d-db67-41da-bdb8-b73fe8319177","harvest_source_id":"b523e984-9c29-4379-b89e-034d453e07b4","id":"71d7f1a7-5356-4899-849e-d6ae8fb36854","identifier":"https://www.arcgis.com/home/item.html?id=be40a1fd4ae24c279093b2bdffb44eb2","parent_identifier":null,"source_hash":"f33c45f165c46de2017093fe6c58035f4fdf28b338081a01b2b3f863e473551d","source_raw":"{\"@type\": \"dcat:Dataset\", \"accessLevel\": \"public\", \"contactPoint\": {\"@type\": \"vcard:Contact\", \"fn\": \"OpenDataAdmin_detroitmi\", \"hasEmail\": \"mailto:gis@detroitmi.gov\"}, \"description\": \"
Detroit-specific ZIP code populations, along with their cumulative COVID case counts, deaths, and rates.\\u00a0
Data provided by Detroit Health Department.\\u00a0
The public-facing COVID Cases Dashboard is hosted at:\\u00a0detroitmi.gov/health

UPDATE* July 29 2021:
The underlying calculation for disease date was updated to allow for individuals to appear on the curve in multiple locations if they experienced more than one case of COVID-19 that was at least 90 days apart.
Geospatial information analysis was also improved and additional criterial for address clean up were implemented, which leads to more accurate case counts within Zip Codes. Some unverified addresses that may have appeared in previous Zip Code counts are now excluded.
This change discourages direct comparison of dashboard visualizations and counts prior to the new calculation, and non-significant shifts in numbers will be noticed.

Case numbers represent Detroit residents only. Some ZIP codes with very low case counts are excluded to protect privacy. Case counts are totals per ZIP code and are not adjusted for population. ZIP code totals are preliminary; addresses are updated as new information becomes available and counts are subject to change. Not all cases have an accurate location; only cases with a known ZIP code are represented. Where a ZIP code is split between cities, only the Detroit portion is shown (48203, 48211, 48212, 48236, 48239). The counts exclude cases among prisoners at the Wayne County Jail and known hospital or laboratory locations.

ZIP_Code: The USPS ZIP postal code\\u00a0

Clipped_ZIP_Population: The 2010 population of the ZIP code, clipped to include Detroit City residents only.

ZIP_Case_Count: The current cumulative count of Confirmed COVID cases within the ZIP code, since the beginning of the pandemic. (Have a "Confimed" case status in MDSS)

ZIP_Death_Count:\\u00a0The current cumulative count of Confirmed COVID cases within the ZIP code, since the beginning of the pandemic. (Have a "Confimed" case status in MDSS and are deceased)

ZIP_Case_Rate: Rate of confirmed cases per 100 thousand residents in the ZIP code.\\u00a0
\\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0For each zip, the rate was calculated by (C/P)*100000\\u00a0
\\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0C = the count of confirmed (MDSS case status = Confirmed) cases with
\\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 a resident address in the ZIP code
\\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0P = the population count of the ZIP code

ZIP_Death_Rate: Rate of confirmed cases that were marked deceased, per 100 thousand residents in the ZIP code.\\u00a0
\\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0For each zip, the rate was calculated by\\u00a0(D/P)*100000\\u00a0
\\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0D\\u00a0= the count of confirmed (MDSS case status = Confirmed) cases
\\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 marked as deceased, with a resident address in the ZIP\\u00a0\\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0\\u00a0\\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0
\\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0 \\u00a0P\\u00a0= the population count of the ZIP code
\", \"distribution\": [{\"@type\": \"dcat:Distribution\", \"accessURL\": \"https://data.ferndalemi.gov/datasets/detroitmi::detroit-city-covid-confirmed-cases-and-rates-by-zip-code\", \"format\": \"Web Page\", \"mediaType\": \"text/html\", \"title\": \"ArcGIS Hub Dataset\"}], \"identifier\": \"https://www.arcgis.com/home/item.html?id=be40a1fd4ae24c279093b2bdffb44eb2\", \"issued\": \"2021-04-05T14:26:24.000Z\", \"keyword\": [\"covid\", \"detroit\", \"public health\"], \"landingPage\": \"https://data.ferndalemi.gov/datasets/detroitmi::detroit-city-covid-confirmed-cases-and-rates-by-zip-code\", \"license\": \"\", \"modified\": \"2025-03-27T19:06:15.000Z\", \"publisher\": {\"name\": \"City of Detroit\"}, \"spatial\": \"{{extent:computeSpatialProperty}}\", \"theme\": [\"geospatial\"], \"title\": \"Detroit City COVID Confirmed Cases and Rates by ZIP Code\"}","source_transform":null,"status":"error"}