Name: Coronavirus Canada
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

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

8.09 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

28.59 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

42.66 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

22.51 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

23.03 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

24.23 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

25.07 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.1 kB
15 rows
3 columns

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