Daily COVID-19 Cases by Zip Code

citydata.mesaaz.gov | Last Updated 12 Jul 2021

Information sourced from Arizona Department of Health of confirmed COVID-19 cases by zip code and displayed here to better visualize the data. Direct REST Endpoint URL in Source Link field below. Statewide data available at https://www.azdhs.gov/preparedness/epidemiology-disease-control/infectious-disease-epidemiology/covid-19/dashboards/index.php.

This dataset has the following 18 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
Row IDrow_idtexta unique identifier for each row
Yearyeartextthe year the data was loaded
Monthmonthtextthe month the data was loaded
Datedatecalendar_datethe date the data was loaded
Zip Codezip_codetextthe zip code to which the COVID cases belong to
Primary Cityprimary_citytextthe city that the zip code resides in
Confirmed Cases Categoryconfirmed_cases_categorytextthe category of each confirmed COVID case amount (for example: ‘0’, ‘1-5’,’6-10’,’Greater than 10’,’Data Suppressed’)
Confirmed Cases Countconfirmed_cases_countnumberthe count of confirmed COVID cases, however the count was not provided for any zip codes with a category of ‘1-5’,’6-10’, and ‘Data Suppressed’. Therefore the Confirmed Cases Count for records with these categories will be rounded down to the following:  ‘Data Suppressed’ = 0  ‘1-5’ = 1  ‘6-10’ = 6
Populationpopulationnumberpopulation by Arizona Zip Code Tabulation (Source: US Census Bureau, American Community Survey 2018 5-year estimates)
Population Densitypopulation_densitynumberthe population of the zip code divided by the number of square miles within the zip code boundaries
Confirmed Case Rate per 100,000 Peopleconfirmed_case_rate_per_100_000_peoplenumberthe confirmed case count per 100,000 per poulation
New Casesnew_casesnumber
Geometrygeometrymultipolygonthe area of land of the zip code (this field is the multi-polygon that will provide the zip code shapes on the map)
New Vaccinationsnew_vaccinationsnumber
Number of People Vaccinatednumber_of_people_vaccinatednumber
Vaccinated Number Categoryvaccinated_number_categorytextVaccinated Number Category
Vaccinated Percent over 18vaccinated_percent_over_18number
Vaccinated Percent over 65vaccinated_percent_over_65number