edmonton-ca/historical-covid19-in-alberta-case-history-by-rrjc-ssaw
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 7 months ago
Indexed 2 hours ago

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

Note: Date last updated 2022-09-26, data is no longer provided.

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-28 16:08 with data as of end of day 2022-09-26.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"edmonton-ca/historical-covid19-in-alberta-case-history-by-rrjc-ssaw\".\"historical_covid19_in_alberta_case_history_by\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • historical_covid19_in_alberta_case_history_by
     
     
     
     
     
Upstream Metadata