COVID-19 Dataset In Japan

Number of Novel Corona Virus 2019 cases in Japan

@kaggle.lisphilar_covid19_dataset_in_japan

Table List

3 tables(1.12 MB)

Covid Jpn Metadata

Covid Jpn Prefecture

Covid Jpn Total

Covid Jpn Total

@kaggle.lisphilar_covid19_dataset_in_japan.covid_jpn_total

117.87 KB
3526 rows
19 columns

date Date	location Location	positive Positive	tested Tested	symptomatic Symptomatic	asymptomatic Asymptomatic	hosp_mild Hosp Mild	hosp_unknown Hosp Unknown	discharged Discharged
Thu Feb 06 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Domestic	16	132	16		9	3	4
Thu Feb 06 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Returnee	9	566	5	4	3	2
Fri Feb 07 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Domestic	16	151	16		12		4
Fri Feb 07 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Returnee	9	566	6	3	4	2
Mon Feb 10 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Domestic	16	174	16		7		9
Mon Feb 10 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Returnee	10	764	7	3	4	3
Wed Feb 12 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Domestic	16	190	16		6		10
Wed Feb 12 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Returnee	12	764	9	3	8	1
Thu Feb 13 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Domestic	17	200	17		6		11
Thu Feb 13 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Returnee	12	764	9	3


CREATE TABLE covid_jpn_total (
  "date" TIMESTAMP,
  "location" VARCHAR,
  "positive" BIGINT,
  "tested" DOUBLE,
  "symptomatic" DOUBLE,
  "asymptomatic" DOUBLE,
  "sym_unknown" DOUBLE,
  "hosp_require" DOUBLE,
  "hosp_mild" DOUBLE,
  "hosp_severe" BIGINT,
  "hosp_unknown" DOUBLE,
  "hosp_waiting" DOUBLE,
  "discharged" DOUBLE,
  "fatal" BIGINT,
  "vaccinated_1st" DOUBLE,
  "vaccinated_2nd" DOUBLE,
  "vaccinated_3rd" DOUBLE,
  "vaccinated_4th" DOUBLE,
  "vaccinated_5th" DOUBLE
);