edmonton-ca/covid19-in-alberta-case-history-by-municipality-rrjc-ssaw
Icon for Socrata external plugin
 
Readme
Updated 6 days ago
Indexed 2 hours 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-09-21 16:08 with data as of end of day 2022-09-19.

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
deathsdeathsdeathsNumber
cases_recoveredcases_recoveredcases_recoveredNumber
active_case_rateactive_case_rateactive_case_rateNumberFrom https://www.alberta.ca/data/stats/covid-19-alberta-statistics-map-data.csv
cases_activecases_activecases_activeNumber
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.
populationpopulationpopulationNumberFrom https://www.alberta.ca/data/stats/covid-19-alberta-statistics-map-data.csv
locationlocationlocationText
cases_totalcases_totalcases_totalNumber
map_typemap_typemap_typeTextWhether Municipality or Local Geographic Area; both may exist for the same date.
datedatedateCalendar dateThe "data as of" date when the data was obtained from the AHS website.
geometry_polygongeometry_polygongeometry_polygonMultiPolygon
 
Preview
  • covid19_in_alberta_case_history_by_municipality
     
Upstream Metadata