johns_hopkins_csse_daily_reports

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

39,913 rows where country_or_region = "Japan" sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: day (date), last_update (date)

province_or_state >30

country_or_region 1

  • Japan · 39,913 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
647562 647562 2022-08-18 Japan Aichi     1037904 2401 0   35.035551 137.211621 2022-08-19 04:20:54 Aichi, Japan
647563 647563 2022-08-18 Japan Akita     64196 86 0   39.748679 140.408228 2022-08-19 04:20:54 Akita, Japan
647564 647564 2022-08-18 Japan Aomori     117029 167 0   40.781541 140.828896 2022-08-19 04:20:54 Aomori, Japan
647565 647565 2022-08-18 Japan Chiba     760526 2072 0   35.510141 140.198917 2022-08-19 04:20:54 Chiba, Japan
647566 647566 2022-08-18 Japan Ehime     108312 208 0   33.624835 132.856842 2022-08-19 04:20:54 Ehime, Japan
647567 647567 2022-08-18 Japan Fukui     79364 62 0   35.846614 136.224654 2022-08-19 04:20:54 Fukui, Japan
647568 647568 2022-08-18 Japan Fukuoka     849223 1541 0   33.526032 130.666949 2022-08-19 04:20:54 Fukuoka, Japan
647569 647569 2022-08-18 Japan Fukushima     121188 240 0   37.378867 140.223295 2022-08-19 04:20:54 Fukushima, Japan
647570 647570 2022-08-18 Japan Gifu     207031 420 0   35.778671 137.055925 2022-08-19 04:20:54 Gifu, Japan
647571 647571 2022-08-18 Japan Gunma     174984 397 0   36.504479 138.985605 2022-08-19 04:20:54 Gunma, Japan
647572 647572 2022-08-18 Japan Hiroshima     291529 586 0   34.605309 132.788719 2022-08-19 04:20:54 Hiroshima, Japan
647573 647573 2022-08-18 Japan Hokkaido     572833 2287 0   43.385711 142.552318 2022-08-19 04:20:54 Hokkaido, Japan
647574 647574 2022-08-18 Japan Hyogo     782884 2498 0   35.039913 134.828057 2022-08-19 04:20:54 Hyogo, Japan
647575 647575 2022-08-18 Japan Ibaraki     270274 527 0   36.303588 140.319591 2022-08-19 04:20:54 Ibaraki, Japan
647576 647576 2022-08-18 Japan Ishikawa     111060 213 0   36.769464 136.771027 2022-08-19 04:20:54 Ishikawa, Japan
647577 647577 2022-08-18 Japan Iwate     73927 135 0   39.593287 141.361777 2022-08-19 04:20:54 Iwate, Japan
647578 647578 2022-08-18 Japan Kagawa     98298 206 0   34.217292 133.969047 2022-08-19 04:20:54 Kagawa, Japan
647579 647579 2022-08-18 Japan Kagoshima     209744 331 0   31.009484 130.430665 2022-08-19 04:20:54 Kagoshima, Japan
647580 647580 2022-08-18 Japan Kanagawa     1243325 2557 0   35.415312 139.338983 2022-08-19 04:20:54 Kanagawa, Japan
647581 647581 2022-08-18 Japan Kochi     64404 175 0   33.422519 133.367307 2022-08-19 04:20:54 Kochi, Japan
647582 647582 2022-08-18 Japan Kumamoto     251511 466 0   32.608154 130.745231 2022-08-19 04:20:54 Kumamoto, Japan
647583 647583 2022-08-18 Japan Kyoto     372716 819 0   35.253815 135.443341 2022-08-19 04:20:54 Kyoto, Japan
647584 647584 2022-08-18 Japan Mie     174183 395 0   34.508018 136.376013 2022-08-19 04:20:54 Mie, Japan
647585 647585 2022-08-18 Japan Miyagi     186095 261 0   38.446859 140.927086 2022-08-19 04:20:54 Miyagi, Japan
647586 647586 2022-08-18 Japan Miyazaki     137517 225 0   32.193204 131.299374 2022-08-19 04:20:54 Miyazaki, Japan
647587 647587 2022-08-18 Japan Nagano     142428 240 0   36.132134 138.045528 2022-08-19 04:20:54 Nagano, Japan
647588 647588 2022-08-18 Japan Nagasaki     145395 190 0   33.235712 129.608033 2022-08-19 04:20:54 Nagasaki, Japan
647589 647589 2022-08-18 Japan Nara     164257 442 0   34.317451 135.871644 2022-08-19 04:20:54 Nara, Japan
647590 647590 2022-08-18 Japan Niigata     156813 106 0   37.521819 138.918647 2022-08-19 04:20:54 Niigata, Japan
647591 647591 2022-08-18 Japan Oita     128414 224 0   33.200697 131.43324 2022-08-19 04:20:54 Oita, Japan
647592 647592 2022-08-18 Japan Okayama     188223 307 0   34.89246 133.826252 2022-08-19 04:20:54 Okayama, Japan
647593 647593 2022-08-18 Japan Okinawa     436146 555 0   25.768923 126.668016 2022-08-19 04:20:54 Okinawa, Japan
647594 647594 2022-08-18 Japan Osaka     1707958 5729 0   34.620965 135.507481 2022-08-19 04:20:54 Osaka, Japan
647595 647595 2022-08-18 Japan Port Quarantine     4463 4 0       2021-11-10 23:21:44 Port Quarantine, Japan
647596 647596 2022-08-18 Japan Saga     118215 175 0   33.286977 130.115738 2022-08-19 04:20:54 Saga, Japan
647597 647597 2022-08-18 Japan Saitama     952274 1864 0   35.997101 139.347635 2022-08-19 04:20:54 Saitama, Japan
647598 647598 2022-08-18 Japan Shiga     170588 263 0   35.215827 136.138064 2022-08-19 04:20:54 Shiga, Japan
647599 647599 2022-08-18 Japan Shimane     58530 64 0   35.07076 132.554064 2022-08-19 04:20:54 Shimane, Japan
647600 647600 2022-08-18 Japan Shizuoka     357448 566 0   34.916975 138.407784 2022-08-19 04:20:54 Shizuoka, Japan
647601 647601 2022-08-18 Japan Tochigi     168419 374 0   36.689912 139.819213 2022-08-19 04:20:54 Tochigi, Japan
647602 647602 2022-08-18 Japan Tokushima     53390 106 0   33.919178 134.242091 2022-08-19 04:20:54 Tokushima, Japan
647603 647603 2022-08-18 Japan Tokyo     2671780 4989 0   35.711343 139.446921 2022-08-19 04:20:54 Tokyo, Japan
647604 647604 2022-08-18 Japan Tottori     42979 40 0   35.359069 133.863619 2022-08-19 04:20:54 Tottori, Japan
647605 647605 2022-08-18 Japan Toyama     83145 118 0   36.637464 137.269346 2022-08-19 04:20:54 Toyama, Japan
647606 647606 2022-08-18 Japan Unknown     8 0 0       2021-11-10 23:21:44 Unknown, Japan
647607 647607 2022-08-18 Japan Wakayama     94719 174 0   33.911879 135.505446 2022-08-19 04:20:54 Wakayama, Japan
647608 647608 2022-08-18 Japan Yamagata     62165 122 0   38.448396 140.102154 2022-08-19 04:20:54 Yamagata, Japan
647609 647609 2022-08-18 Japan Yamaguchi     108798 259 0   34.20119 131.573293 2022-08-19 04:20:54 Yamaguchi, Japan
647610 647610 2022-08-18 Japan Yamanashi     71425 99 0   35.612364 138.611489 2022-08-19 04:20:54 Yamanashi, Japan
2706334 2706334 2022-08-17 Japan Aichi     1019911 2376 0   35.035551 137.211621 2022-08-18 04:21:11 Aichi, Japan
2706335 2706335 2022-08-17 Japan Akita     62331 86 0   39.748679 140.408228 2022-08-18 04:21:11 Akita, Japan
2706336 2706336 2022-08-17 Japan Aomori     114991 166 0   40.781541 140.828896 2022-08-18 04:21:11 Aomori, Japan
2706337 2706337 2022-08-17 Japan Chiba     753731 2064 0   35.510141 140.198917 2022-08-18 04:21:11 Chiba, Japan
2706338 2706338 2022-08-17 Japan Ehime     104799 202 0   33.624835 132.856842 2022-08-18 04:21:11 Ehime, Japan
2706339 2706339 2022-08-17 Japan Fukui     78063 61 0   35.846614 136.224654 2022-08-18 04:21:11 Fukui, Japan
2706340 2706340 2022-08-17 Japan Fukuoka     836118 1531 0   33.526032 130.666949 2022-08-18 04:21:11 Fukuoka, Japan
2706341 2706341 2022-08-17 Japan Fukushima     117893 240 0   37.378867 140.223295 2022-08-18 04:21:11 Fukushima, Japan
2706342 2706342 2022-08-17 Japan Gifu     202541 417 0   35.778671 137.055925 2022-08-18 04:21:11 Gifu, Japan
2706343 2706343 2022-08-17 Japan Gunma     172175 388 0   36.504479 138.985605 2022-08-18 04:21:11 Gunma, Japan
2706344 2706344 2022-08-17 Japan Hiroshima     284770 582 0   34.605309 132.788719 2022-08-18 04:21:11 Hiroshima, Japan
2706345 2706345 2022-08-17 Japan Hokkaido     564518 2275 0   43.385711 142.552318 2022-08-18 04:21:11 Hokkaido, Japan
2706346 2706346 2022-08-17 Japan Hyogo     770619 2484 0   35.039913 134.828057 2022-08-18 04:21:11 Hyogo, Japan
2706347 2706347 2022-08-17 Japan Ibaraki     266184 523 0   36.303588 140.319591 2022-08-18 04:21:11 Ibaraki, Japan
2706348 2706348 2022-08-17 Japan Ishikawa     108717 213 0   36.769464 136.771027 2022-08-18 04:21:11 Ishikawa, Japan
2706349 2706349 2022-08-17 Japan Iwate     72390 130 0   39.593287 141.361777 2022-08-18 04:21:11 Iwate, Japan
2706350 2706350 2022-08-17 Japan Kagawa     95822 203 0   34.217292 133.969047 2022-08-18 04:21:11 Kagawa, Japan
2706351 2706351 2022-08-17 Japan Kagoshima     204796 318 0   31.009484 130.430665 2022-08-18 04:21:11 Kagoshima, Japan
2706352 2706352 2022-08-17 Japan Kanagawa     1233328 2537 0   35.415312 139.338983 2022-08-18 04:21:11 Kanagawa, Japan
2706353 2706353 2022-08-17 Japan Kochi     62572 168 0   33.422519 133.367307 2022-08-18 04:21:11 Kochi, Japan
2706354 2706354 2022-08-17 Japan Kumamoto     245832 465 0   32.608154 130.745231 2022-08-18 04:21:11 Kumamoto, Japan
2706355 2706355 2022-08-17 Japan Kyoto     367729 814 0   35.253815 135.443341 2022-08-18 04:21:11 Kyoto, Japan
2706356 2706356 2022-08-17 Japan Mie     169542 390 0   34.508018 136.376013 2022-08-18 04:21:11 Mie, Japan
2706357 2706357 2022-08-17 Japan Miyagi     182053 261 0   38.446859 140.927086 2022-08-18 04:21:11 Miyagi, Japan
2706358 2706358 2022-08-17 Japan Miyazaki     133405 222 0   32.193204 131.299374 2022-08-18 04:21:11 Miyazaki, Japan
2706359 2706359 2022-08-17 Japan Nagano     138829 237 0   36.132134 138.045528 2022-08-18 04:21:11 Nagano, Japan
2706360 2706360 2022-08-17 Japan Nagasaki     140867 184 0   33.235712 129.608033 2022-08-18 04:21:11 Nagasaki, Japan
2706361 2706361 2022-08-17 Japan Nara     162006 438 0   34.317451 135.871644 2022-08-18 04:21:11 Nara, Japan
2706362 2706362 2022-08-17 Japan Niigata     153086 106 0   37.521819 138.918647 2022-08-18 04:21:11 Niigata, Japan
2706363 2706363 2022-08-17 Japan Oita     125420 221 0   33.200697 131.43324 2022-08-18 04:21:11 Oita, Japan
2706364 2706364 2022-08-17 Japan Okayama     183939 306 0   34.89246 133.826252 2022-08-18 04:21:11 Okayama, Japan
2706365 2706365 2022-08-17 Japan Okinawa     431635 548 0   25.768923 126.668016 2022-08-18 04:21:11 Okinawa, Japan
2706366 2706366 2022-08-17 Japan Osaka     1683641 5710 0   34.620965 135.507481 2022-08-18 04:21:11 Osaka, Japan
2706367 2706367 2022-08-17 Japan Port Quarantine     4463 4 0       2021-11-10 23:21:44 Port Quarantine, Japan
2706368 2706368 2022-08-17 Japan Saga     115700 172 0   33.286977 130.115738 2022-08-18 04:21:11 Saga, Japan
2706369 2706369 2022-08-17 Japan Saitama     941087 1852 0   35.997101 139.347635 2022-08-18 04:21:11 Saitama, Japan
2706370 2706370 2022-08-17 Japan Shiga     168245 259 0   35.215827 136.138064 2022-08-18 04:21:11 Shiga, Japan
2706371 2706371 2022-08-17 Japan Shimane     57298 64 0   35.07076 132.554064 2022-08-18 04:21:11 Shimane, Japan
2706372 2706372 2022-08-17 Japan Shizuoka     350437 558 0   34.916975 138.407784 2022-08-18 04:21:11 Shizuoka, Japan
2706373 2706373 2022-08-17 Japan Tochigi     165205 358 0   36.689912 139.819213 2022-08-18 04:21:11 Tochigi, Japan
2706374 2706374 2022-08-17 Japan Tokushima     51177 106 0   33.919178 134.242091 2022-08-18 04:21:11 Tokushima, Japan
2706375 2706375 2022-08-17 Japan Tokyo     2644327 4962 0   35.711343 139.446921 2022-08-18 04:21:11 Tokyo, Japan
2706376 2706376 2022-08-17 Japan Tottori     41961 40 0   35.359069 133.863619 2022-08-18 04:21:11 Tottori, Japan
2706377 2706377 2022-08-17 Japan Toyama     80637 117 0   36.637464 137.269346 2022-08-18 04:21:11 Toyama, Japan
2706378 2706378 2022-08-17 Japan Unknown     8 0 0       2021-11-10 23:21:44 Unknown, Japan
2706379 2706379 2022-08-17 Japan Wakayama     92528 173 0   33.911879 135.505446 2022-08-18 04:21:11 Wakayama, Japan
2706380 2706380 2022-08-17 Japan Yamagata     60217 121 0   38.448396 140.102154 2022-08-18 04:21:11 Yamagata, Japan
2706381 2706381 2022-08-17 Japan Yamaguchi     105304 252 0   34.20119 131.573293 2022-08-18 04:21:11 Yamaguchi, Japan
2706382 2706382 2022-08-17 Japan Yamanashi     69763 94 0   35.612364 138.611489 2022-08-18 04:21:11 Yamanashi, Japan
2396001 2396001 2022-08-16 Japan Aichi     1000926 2359 0   35.035551 137.211621 2022-08-17 04:20:59 Aichi, Japan
2396002 2396002 2022-08-16 Japan Akita     60659 83 0   39.748679 140.408228 2022-08-17 04:20:59 Akita, Japan

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [johns_hopkins_csse_daily_reports] (
   [day] TEXT,
   [country_or_region] TEXT,
   [province_or_state] TEXT,
   [admin2] TEXT,
   [fips] TEXT,
   [confirmed] INTEGER,
   [deaths] INTEGER,
   [recovered] INTEGER,
   [active] INTEGER,
   [latitude] TEXT,
   [longitude] TEXT,
   [last_update] TEXT,
   [combined_key] TEXT
);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day]
    ON [johns_hopkins_csse_daily_reports] ([day]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state]
    ON [johns_hopkins_csse_daily_reports] ([province_or_state]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region]
    ON [johns_hopkins_csse_daily_reports] ([country_or_region]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key]
    ON [johns_hopkins_csse_daily_reports] ([combined_key]);