edmonton-ca/covid19-in-alberta-case-history-by-municipality-rrjc-ssaw
 
Readme
Updated 2 hours ago
Indexed 1 hour ago

COVID-19 in Alberta: Case History by Municipality and Local Geographic Area

COVID-19 case history for Alberta, by municipality and local geographic area. Be sure to filter on the map_type value e.g.:

This is a mirror of the data presented in the map view at https://www.alberta.ca/stats/covid-19-alberta-statistics.htm ('Geospatial' tab), with each day's snapshot of data stored locally along with the "data as of" date in order to build the history. Gaps in this data (typically data pertaining to Fridays and Saturdays) are filled from https://www.alberta.ca/data/stats/covid-19-alberta-statistics-map-data.csv. Updated 2022-01-18 09:50 with data as of end of day 2022-01-16.

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
datedatedateCalendar dateThe "data as of" date when the data was obtained from the AHS website.
map_typemap_typemap_typeTextWhether Municipality or Local Geographic Area; both may exist for the same date.
locationlocationlocationText
populationpopulationpopulationNumberFrom https://www.alberta.ca/data/stats/covid-19-alberta-statistics-map-data.csv
sort_ordersort_ordersort_orderNumberNot from the original source data. Regions are sorted based on distance from Edmonton, to facilitate at-a-glance viewing of data for our primary audience.
cases_totalcases_totalcases_totalNumber
cases_activecases_activecases_activeNumber
active_case_rateactive_case_rateactive_case_rateNumberFrom https://www.alberta.ca/data/stats/covid-19-alberta-statistics-map-data.csv
cases_recoveredcases_recoveredcases_recoveredNumber
deathsdeathsdeathsNumber
geometry_polygongeometry_polygongeometry_polygonMultiPolygon
Upstream Metadata