Dataset: Coronavirus Canada

About this Dataset

Coronavirus Canada

The Canada COVID19 dataset consists of two files and extracted from the Public Health Canada website (https://www.canada.ca/en/public-health/services/diseases/2019-novel-coronavirus-infection.html) which contains the COVID-19 outbreak updates from all provinces and territories.
Statistics Canada - Population data by province: https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=1710000901.

The dataset consists of the following attributes: pruid, prname, prnameFR, date, numconf, numprob, numdeaths ,numtotal ,untested , numrecover, percentrecover, ratetested, umtoday, percentoday. The following columns are dropped from dataframe: percentoday, numprob, prnameFR, and pruid,

In addition, the mortality rate and P_code were added to the dataframe. Few columns have null values in the early days due to no data collection at the national level. Therefore, those values are filled with '0' values. Correlation test is performed to understand the relationship between confirmed, death, and total cases and such variables are positively correlated.

Tables

Canada Events

@kaggle.shiyapara_canada_covid19_data.canada_events

7.9 KB
24 rows
6 columns


CREATE TABLE canada_events (
  "date" VARCHAR,
  "confirmed" BIGINT,
  "tested" BIGINT,
  "death" DOUBLE,
  "description" VARCHAR,
  "ca_events" VARCHAR
);

Covid19–0405

@kaggle.shiyapara_canada_covid19_data.covid19_0405

27.92 KB
882 rows
14 columns


CREATE TABLE covid19_0405 (
  "pruid" BIGINT,
  "prname" VARCHAR,
  "prnamefr" VARCHAR,
  "date" VARCHAR,
  "numconf" BIGINT,
  "numprob" BIGINT,
  "numdeaths" DOUBLE,
  "numtotal" BIGINT,
  "numtested" DOUBLE,
  "numrecover" DOUBLE,
  "percentrecover" DOUBLE,
  "ratetested" VARCHAR,
  "numtoday" DOUBLE,
  "percentoday" DOUBLE
);

Covid19–1105

@kaggle.shiyapara_canada_covid19_data.covid19_1105

41.67 KB
987 rows
15 columns


CREATE TABLE covid19_1105 (
  "pruid" BIGINT,
  "prname" VARCHAR,
  "prnamefr" VARCHAR,
  "date" VARCHAR,
  "numconf" BIGINT,
  "numprob" BIGINT,
  "numdeaths" DOUBLE,
  "numtotal" BIGINT,
  "numtested" DOUBLE,
  "numrecover" DOUBLE,
  "percentrecover" DOUBLE,
  "ratetested" DOUBLE,
  "numtoday" DOUBLE,
  "percentoday" DOUBLE,
  "ratetotal" DOUBLE
);

Covid19–1704

@kaggle.shiyapara_canada_covid19_data.covid19_1704

21.98 KB
642 rows
14 columns


CREATE TABLE covid19_1704 (
  "pruid" BIGINT,
  "prname" VARCHAR,
  "prnamefr" VARCHAR,
  "date" VARCHAR,
  "numconf" BIGINT,
  "numprob" BIGINT,
  "numdeaths" DOUBLE,
  "numtotal" BIGINT,
  "numtested" DOUBLE,
  "numrecover" DOUBLE,
  "percentrecover" DOUBLE,
  "ratetested" VARCHAR,
  "numtoday" DOUBLE,
  "percentoday" DOUBLE
);

Covid19–1904

@kaggle.shiyapara_canada_covid19_data.covid19_1904

22.49 KB
657 rows
14 columns


CREATE TABLE covid19_1904 (
  "pruid" BIGINT,
  "prname" VARCHAR,
  "prnamefr" VARCHAR,
  "date" VARCHAR,
  "numconf" BIGINT,
  "numprob" BIGINT,
  "numdeaths" DOUBLE,
  "numtotal" BIGINT,
  "numtested" DOUBLE,
  "numrecover" DOUBLE,
  "percentrecover" DOUBLE,
  "ratetested" VARCHAR,
  "numtoday" DOUBLE,
  "percentoday" DOUBLE
);

Covid19–2204

@kaggle.shiyapara_canada_covid19_data.covid19_2204

23.66 KB
702 rows
14 columns


CREATE TABLE covid19_2204 (
  "pruid" BIGINT,
  "prname" VARCHAR,
  "prnamefr" VARCHAR,
  "date" VARCHAR,
  "numconf" BIGINT,
  "numprob" BIGINT,
  "numdeaths" DOUBLE,
  "numtotal" BIGINT,
  "numtested" DOUBLE,
  "numrecover" DOUBLE,
  "percentrecover" DOUBLE,
  "ratetested" VARCHAR,
  "numtoday" DOUBLE,
  "percentoday" DOUBLE
);

Covid19–2404

@kaggle.shiyapara_canada_covid19_data.covid19_2404

24.48 KB
732 rows
14 columns


CREATE TABLE covid19_2404 (
  "pruid" BIGINT,
  "prname" VARCHAR,
  "prnamefr" VARCHAR,
  "date" VARCHAR,
  "numconf" BIGINT,
  "numprob" BIGINT,
  "numdeaths" DOUBLE,
  "numtotal" BIGINT,
  "numtested" DOUBLE,
  "numrecover" DOUBLE,
  "percentrecover" DOUBLE,
  "ratetested" VARCHAR,
  "numtoday" DOUBLE,
  "percentoday" DOUBLE
);

P Code

@kaggle.shiyapara_canada_covid19_data.p_code

3.02 KB
15 rows
3 columns


CREATE TABLE p_code (
  "prname" VARCHAR,
  "p_code" VARCHAR,
  "population" BIGINT
);