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 Metadata

@kaggle.lisphilar_covid19_dataset_in_japan.covid_jpn_metadata

11.58 KB
846 rows
7 columns

prefecture Prefecture	category Category	item Item	value Value	date Date	primary_source Primary Source	secondary_source Secondary Source
Hokkaido	Population	Total	5320	Sun Oct 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	https://www.mhlw.go.jp/toukei/youran/indexyk_1_1.html	nan
Aomori	Population	Total	1278	Sun Oct 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	https://www.mhlw.go.jp/toukei/youran/indexyk_1_1.html	nan
Iwate	Population	Total	1255	Sun Oct 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	https://www.mhlw.go.jp/toukei/youran/indexyk_1_1.html	nan
Miyagi	Population	Total	2323	Sun Oct 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	https://www.mhlw.go.jp/toukei/youran/indexyk_1_1.html	nan
Akita	Population	Total	996	Sun Oct 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	https://www.mhlw.go.jp/toukei/youran/indexyk_1_1.html	nan
Yamagata	Population	Total	1102	Sun Oct 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	https://www.mhlw.go.jp/toukei/youran/indexyk_1_1.html	nan
Fukushima	Population	Total	1882	Sun Oct 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	https://www.mhlw.go.jp/toukei/youran/indexyk_1_1.html	nan
Ibaraki	Population	Total	2892	Sun Oct 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	https://www.mhlw.go.jp/toukei/youran/indexyk_1_1.html	nan
Tochigi	Population	Total	1957	Sun Oct 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	https://www.mhlw.go.jp/toukei/youran/indexyk_1_1.html	nan
Gunma	Population	Total	1960	Sun Oct 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	https://www.mhlw.go.jp/toukei/youran/indexyk_1_1.html	nan


CREATE TABLE covid_jpn_metadata (
  "prefecture" VARCHAR,
  "category" VARCHAR,
  "item" VARCHAR,
  "value" VARCHAR,
  "date" TIMESTAMP,
  "primary_source" VARCHAR,
  "secondary_source" VARCHAR
);