28 Health-related databases
28.1 Canadian Vitals Statistics Database
28.1.1 Vital Statistics - Death Database
Statistique de l’état civil - Base de données sur les décès
28.1.1.1 Leading causes of death
Provisional weekly death counts, by selected grouped causes of death
Nombre provisoire de décès et surmortalité janvier 2020 à août 2021
Frequency: Weekly Table: 13-10-0810-01 https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=1310081001 https://www150.statcan.gc.ca/n1/tbl/csv/13100810-eng.zip
if (F) {
curl::curl_download("https://www150.statcan.gc.ca/n1/tbl/csv/13100810-eng.zip",
"13100810.zip",
mode = "wb"
)
url <- "https://www150.statcan.gc.ca/n1/tbl/csv/13100810-eng.zip"
temp <- tempfile()
download.file(url, temp)
dt <- fread(unzip(temp, files = "13100810.csv"))
rm(temp)
}
dt <- fread ("https://github.com/open-canada/datasets/raw/main/statcan/13100810-after-20190901.csv", stringsAsFactors = F)
dt[, Date := ymd(Date)]
dt[, GEO := gsub(", place of occurrence", "", GEO)]
dt0 <- dt[ Date >= "2019-10-01" ]
# Plot GEO vertically - allows comparison across Causes
ggplot(dt0) + guides(col = "none") +
geom_step(aes(Date, val_norm, col = `Cause of death (ICD-10)`)) +
facet_grid(GEO ~ `Cause of death (ICD-10)`, scales = "free") +
labs( title = NULL, x = NULL, y = NULL,
caption = "Source: Statistics Canada - Table 13-10-0810-01" )## Warning: Removed 745 row(s) containing missing values (geom_path).
# Plot Causes vertically - allows comparison across GEO
ggplot(dt0) + theme(legend.position = "bottom") +
geom_step(aes(Date, val_norm, col = `Cause of death (ICD-10)`)) +
facet_grid(`Cause of death (ICD-10)` ~ GEO, scales = "free") +
labs( title = NULL, x = NULL, y = NULL,
caption = "Source: Statistics Canada - Table 13-10-0810-01" )## Warning: Removed 745 row(s) containing missing values (geom_path).
28.1.1.2 Other
Provisional weekly death counts, by age group and sex Frequency: Weekly Table: 13-10-0768-01 Release date: 2021-12-06 Geography: Canada, Province or territory https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=1310076801
Previous releases and revisions to provisional weekly death counts1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13 Frequency: Weekly Table: 13-10-0783-01 Release date: 2021-12-06 Geography: Canada, Province or territory https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=1310078301
Fetal deaths (20 weeks or more of gestation) and late fetal deaths (28 weeks or more of gestation) Table: 13-10-0427-01 (formerly: CANSIM 102-4514)
Perinatal mortality (late fetal deaths and early neonatal deaths) Table: 13-10-0714-01 (formerly: CANSIM 102-0508)
Deaths and age-specific mortality rates, by selected grouped causes1, 2, 3, 4, 5, 6, 7, 8, 9, 10 Frequency: Annual Table: 13-10-0392-01
Leading causes of death, total population, by age group Frequency: Annual. till 2019 Table: 13-10-0394-01
Leading causes of death, infants Table: 13-10-0395-01 (formerly: CANSIM 102-0562)
28.1.2 Vital Statistics - Birth Database
https://www150.statcan.gc.ca/n1/en/surveys/3231
Crude birth rate, age-specific fertility rates and total fertility rate (live births) Table: 13-10-0418-01 (formerly: CANSIM 102-4505)
Live births, by month Table: 13-10-0415-01 (formerly: CANSIM 102-4502)
Live births, by age of mother Table: 13-10-0416-01 (formerly: CANSIM 102-4503)