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 Prefecture

@kaggle.lisphilar_covid19_dataset_in_japan.covid_jpn_prefecture

1015.27 KB
53815 rows
16 columns

date Date	prefecture Prefecture	positive Positive	tested Tested	discharged Discharged	fatal Fatal
Wed Mar 18 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Hokkaido	154	1587	69	7
Wed Mar 18 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Aomori		75
Wed Mar 18 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Iwate		24
Wed Mar 18 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Miyagi	1	138	1
Wed Mar 18 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Akita	2	109	1
Wed Mar 18 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Yamagata		123
Wed Mar 18 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Fukushima	2	127
Wed Mar 18 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Ibaraki	2	454
Wed Mar 18 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Tochigi	3	242	2
Wed Mar 18 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Gunma	10	161


CREATE TABLE covid_jpn_prefecture (
  "date" TIMESTAMP,
  "prefecture" VARCHAR,
  "positive" BIGINT,
  "tested" DOUBLE,
  "discharged" DOUBLE,
  "fatal" DOUBLE,
  "hosp_require" DOUBLE,
  "hosp_severe" DOUBLE,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR,
  "unnamed_10" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR,
  "unnamed_13" VARCHAR,
  "unnamed_14" VARCHAR,
  "unnamed_15" VARCHAR
);