This is a data collection of various data of interest related to CoViD-19 in Alberta. It includes active, recovered, and total cases of the disease, as well as total deaths caused by it. It also includes the geographical distribution of cases, broken down by region per day.
An interactive dashboard to explore the data is available at https://covid.mattschlosser.me. You can select a region and see the active/total/recovered/deaths for each region.
Data is automatically updated daily, provided the Government of Alberta's dashboard updates on time (usually around 3:35 pm)
The dashboard contains various charts including:
- History of all cases, active, recovered, and daeths.
- History of cases counts devided by local geographical (neighbourhood) or municipal area.
- History of hospitalizations, ICU, and deaths rates, by age.
- History of age/gender distribution of cases.
- History of CoViD-19 variants in Alberta, broken down by region.
- Total vaccines administered as of each day
Below is a list of all the different types of data available.
Data is avilable for some categories by individual dates. Each of the local , age, and severe/ directories
contain files with filenames formated as YYYYMMDD.json representing the end reporting date for the data.
Each JSON file formated as YYYYMMDD.json in local/ contains all of Alberta's geospatial data related to COVID-19 cases for that day. Each JSON file has the following format:
[
{
"name": "Region Name Here",
"cases": 3,
"recovered": 1,
"deaths": 1,
"active": 1
},
{
"name" : "Another Region Here",
"cases": 3,
"recovered": 1,
"deaths": 1,
"active": 1
}
]Each JSON file formated as YYYYMMDD.json in municipal/ contains COVID-19 data for each municipal aerasfor that day. Each date is an object representing the cummulative total of each of the categories cases, recovered, deaths, and active as reported to the end of that date. Each JSON file has the following format:
[
{
"name": "Municipality Name Here",
"cases": 3,
"recovered": 1,
"deaths": 1,
"active": 1
},
{
"name" : "Another Municipality Name Here",
"cases": 3,
"recovered": 1,
"deaths": 1,
"active": 1
}
]Each JSON file formated as YYYYMMDD.json in age/ is an array of objects, one for each age category. Each category has a format like:
{
"category": "Under 1 Year",
"male_cases": 0,
"male_percent": 0,
"female_cases": 0,
"female_percent": 0,
"unknown_cases": 0,
"unknown_percent": 0,
"all_cases": 0,
"percent": 0
}Severe outcome JSON files are an array of objects, each object representing an age category. Each category has a format like:
{
"category": "Under 1 year",
"all_cases": 2,
"hospitalized": 0,
"hospitalized_pct": 0,
"hospitalized_rate": 0,
"icu": 0,
"icu_pct": 0,
"icu_rate": 0,
"deaths": 0,
"deaths_pct": 0,
"deaths_rate": 0
}severeVaccine/YYYYMMDD.json
Contains cumulative cases, hospitalized, and deaths numbers as they were reported for each of Unvaccinated, Vaccinated, and Total categories.
First date reported: 2021-06-02
[
{
"category": "Unvaccinated",
"cases": 120224,
"hospitalized": 4974,
"deaths": 624
},
{
"category": "Vaccinated",
"cases": 5025,
"hospitalized": 350,
"deaths": 82
},
{
"category": "Total",
"cases": 125249,
"hospitalized": 5324,
"deaths":706
}
]Each all.json file in local, age, and severe directories, as well as each of the files in the data/ directory, is formated as a colleciton of time series data for each category/region.
An array of objects. One for each local region. Each region has a format like:
{
"name": "Calgary - West",
"data": [
{
"x": "2020-03-21",
"cases": 0,
},
{
"x": "2020-03-22",
"cases": 1,
},
{
"x": "2020-04-09",
"cases": 38,
"active": 24,
"recovered": 13,
"deaths": 1
},
]
}Note: There is a distinction between data before April 9, 2020, and onwards. Data before April 9 only includes total number of cases, whereas data after that date includes active cases, recoveries, and deaths.
The all.json file in the age folder is an array of objects, one for each age category. Each category has a format like:
{
"category": "Under 1 Year",
"data": [
{
"x": "2020-03-21",
"male_cases": 0,
"male_percent": 0,
"female_cases": 0,
"female_percent": 0,
"unknown_cases": 0,
"unknown_percent": 0,
"all_cases": 0,
"percent": 0
},
{
"x": "2020-03-22",
"male_cases": 0,
"male_percent": 0,
"female_cases": 0,
"female_percent": 0,
"unknown_cases": 0,
"unknown_percent": 0,
"all_cases": 0,
"percent": 0
}
]
}The all.json file in the severe folder is an array of objects, one for each age category. Each category has a format like:
{
"category": "Under 1 Year",
"data": [
{
"x": "2020-03-21",
"hospitalized": 0,
"hospitalized_pct": 0,
"hospitalized_rate": 0,
"icu": 0,
"icu_pct": 0,
"icu_rate": 0,
"deaths": 0,
"deaths_pct": 0,
"deaths_rate": 0
},
{
"x": "2020-03-22",
"hospitalized": 0,
"hospitalized_pct": 0,
"hospitalized_rate": 0,
"icu": 0,
"icu_pct": 0,
"icu_rate": 0,
"deaths": 0,
"deaths_pct": 0,
"deaths_rate": 0
}
]
}severeVaccine/all.json
Contains cumulative cases, hospitalized, and deaths numbers as they were reported for each day x for each of Unvaccinated, Vaccinated, and Total categories.
First date reported: 2021-06-02
[
{
"category": "Unvaccianted",
"data": [
{
"x": "2021-06-02",
"cases": 120224,
"hospitalized" : 4974,
"deaths": 624
},
]
},
{
"category": "Vaccinated",
"data": [
{
"x": "2021-06-02",
"cases": 5025,
"hospitalized": 350,
"deaths": 82
},
],
},
{
"category": "Total",
"data": [
{
"x": "2021-06-02",
"cases": 125249,
"hospitalized": 5324,
"deaths": 706,
}
]
}
]Only one category, Alberta with the names and values of the six tiles on the main page of the Alberta covid dashboard for each date.
Note: The content of the six tiles is not always the same six categories. While active cases, current ICU,
current hospitalisations and total deaths have always been present, the other keys/values to the other
tiles may change from day to day.
[{
"category": "Alberta",
"data": [
{
"x": "2020-06-18",
"current hospitalizations": 38,
"current ICU": 6,
"active cases" : 525,
"total deaths": 152
}
]
}]An array of six categories: In Alberta, Edmonton Zone, Calgary Zone, North Zone, South Zone, and Central Zone. Each category is an object containing it's name, cateogry, and an array of objects, data, one for each date. Each object has the keys total, B.1.1.7, and B.1.351, whose values represent the respective cummulative case counts in each category as reported on that date x.
[{
"category": "In Alberta",
"data": [
{
"x": "2021-02-09",
"B.1.1.7": 97,
"B.1.351": 7,
"total" : 104
}
]
}]data/dailyVariantActiveDiedRecoveredCounts.json
An array of six categories: Alberta, Edmonton Zone, Calgary Zone, North Zone, South Zone, and Central Zone. Each category is an object containing it's name, category, and array of objects date. Each object has the keys Active, Recovered, Deaths, Total and x, where each of Active, Recovered, Deaths, and Total is the cummulative total of cases in each category as it was reported on the date x.
Note: The cateory Alberta here differs from the category In Alberta above due to the way data for the types of variants were initalliy reported.
[{
"category": "Alberta",
"data": [
{
"x": "2021-03-29",
"Active": 2152,
"Died": 22,
"Recovored": 1143,
"Total" : 3317
},
{
"x": "2021-03-30",
"Active": 2660,
"Died": 23,
"Recovered": 1372,
"Total": 4055
}
]
}]git clone https://github.com/mattschlosser/alberta-covid
cd alberta-covid
npm install
This is how to update the data/what each script is for.
A simple script is provided to update the data.
On Ubuntu/WSL/Linux:
./update.shBelow are the various tasks that update.sh does:
First, get a recent copy of the Alberta Covid data dashboard.
mkdir -p pages
cd pages
wget https://www.alberta.ca/stats/covid-19-alberta-statistics.htm
node localProcessor.js
node ageProcessor.js
node severeProcessor.js
node severeVaccine.js
node vaccineReactions.js
node municipalProcessor.js
Each of these produces a 2020MMDD.json in the local, age, severe and municipal folders respectively, where MM is the two digit month, and DD is the two digit date. Data is pulled from each pae in the pages/ directory. Dates that already have been processed are skipped. The data in each dated file is cureent up to the end of it's date.
node topProcessor.js
node variantProcessor.js
Each of these produce a single file in the data directory.
topProcessor.js processes the tiles from the Alberta dashboard at
https://covid19stats.alberta.ca. This produces a file, data/dailyCaseCounts.json, which is the summary of # of people in hospital (both ICU and non-ICU cases) per day, current active cases, and total deaths.
variantProcessor.js processes the variant table found at https://alberta.ca/covid19.
Run:
node data-shaper.js
Which produces an all.json file, in local, age, and severe, each which contains all the data for each day
node data-shaper2.js
Which merges duplicate names into the same regions for local data, and places it in an local/all2.json file. On August 16, 2020, some regions were renamed from names like "Calgary - Nose Hill" to "Calgary - Nose HIll (& Nearby Neighbourhoods)". This merges the data from older name formats, into the newer ones.
npm run webpack
This updates the files in docs/ with the new data, which is where the GitHub Pages site is pointed.
git add . && git commit -m "Update for $(date)" && git push
To run a dev server for local dev of the UI pages
npm run webpack serve