johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
44 rows where active = 93 and country_or_region = "Japan" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 24
country_or_region 1
- Japan · 44 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1378550 | 1378550 | 2021-07-25 | Japan | Toyama | 2156 | 38 | 2025 | 93 | 36.637464 | 137.26934599999998 | 2021-07-26 04:21:28 | Toyama, Japan | ||
1330262 | 1330262 | 2021-07-24 | Japan | Iwate | 1899 | 47 | 1759 | 93 | 39.593287 | 141.361777 | 2021-07-25 04:22:12 | Iwate, Japan | ||
2071943 | 2071943 | 2021-07-02 | Japan | Nagasaki | 3205 | 69 | 3043 | 93 | 33.235712 | 129.608033 | 2021-07-03 04:21:37 | Nagasaki, Japan | ||
2764959 | 2764959 | 2021-07-01 | Japan | Nagasaki | 3197 | 69 | 3035 | 93 | 33.235712 | 129.608033 | 2021-07-02 04:21:47 | Nagasaki, Japan | ||
2590022 | 2590022 | 2021-06-27 | Japan | Kumamoto | 6475 | 116 | 6266 | 93 | 32.608154 | 130.74523100000002 | 2021-06-28 04:21:29 | Kumamoto, Japan | ||
107474 | 107474 | 2021-06-19 | Japan | Miyagi | 9064 | 86 | 8885 | 93 | 38.446859 | 140.927086 | 2021-06-20 04:21:48 | Miyagi, Japan | ||
1125608 | 1125608 | 2021-06-18 | Japan | Ishikawa | 3901 | 114 | 3694 | 93 | 36.769464 | 136.771027 | 2021-06-19 04:22:33 | Ishikawa, Japan | ||
522902 | 522902 | 2021-06-09 | Japan | Wakayama | 2641 | 47 | 2501 | 93 | 33.911879 | 135.505446 | 2021-06-10 04:23:17 | Wakayama, Japan | ||
1806746 | 1806746 | 2021-05-27 | Japan | Akita | 755 | 12 | 650 | 93 | 39.748679 | 140.408228 | 2021-05-28 04:20:36 | Akita, Japan | ||
726535 | 726535 | 2021-05-22 | Japan | Shimane | 492 | 0 | 399 | 93 | 35.07076 | 132.55406399999998 | 2021-05-23 04:20:51 | Shimane, Japan | ||
2247409 | 2247409 | 2021-04-07 | Japan | Ishikawa | 1987 | 65 | 1829 | 93 | 36.769464 | 136.771027 | 2021-04-08 04:21:13 | Ishikawa, Japan | ||
1837959 | 1837959 | 2021-03-12 | Japan | Niigata | 1174 | 16 | 1065 | 93 | 37.521819 | 138.918647 | 2021-03-13 05:25:15 | Niigata, Japan | ||
998467 | 998467 | 2021-03-01 | Japan | Niigata | 1085 | 15 | 977 | 93 | 37.521819 | 138.918647 | 2021-03-02 05:23:30 | Niigata, Japan | ||
280190 | 280190 | 2021-02-24 | Japan | Fukushima | 1890 | 69 | 1728 | 93 | 37.378867 | 140.223295 | 2021-02-25 05:24:57 | Fukushima, Japan | ||
280211 | 280211 | 2021-02-24 | Japan | Niigata | 1052 | 14 | 945 | 93 | 37.521819 | 138.918647 | 2021-02-25 05:24:57 | Niigata, Japan | ||
3230467 | 3230467 | 2021-01-03 | Japan | Kagawa | 311 | 3 | 215 | 93 | 34.217292 | 133.969047 | 2021-01-04 05:22:02 | Kagawa, Japan | ||
2227536 | 2227536 | 2021-01-02 | Japan | Kagawa | 308 | 3 | 212 | 93 | 34.217292 | 133.969047 | 2021-01-03 05:22:52 | Kagawa, Japan | ||
1136888 | 1136888 | 2021-01-01 | Japan | Ehime | 471 | 13 | 365 | 93 | 33.624835 | 132.856842 | 2021-01-02 05:22:33 | Ehime, Japan | ||
202271 | 202271 | 2020-12-25 | Japan | Iwate | 353 | 22 | 238 | 93 | 39.593287 | 141.361777 | 2020-12-26 05:22:28 | Iwate, Japan | ||
3769906 | 3769906 | 2020-12-22 | Japan | Oita | 580 | 5 | 482 | 93 | 33.200697 | 131.43323999999998 | 2020-12-23 05:22:03 | Oita, Japan | ||
860722 | 860722 | 2020-12-11 | Japan | Wakayama | 545 | 7 | 445 | 93 | 33.911879 | 135.505446 | 2020-12-12 05:26:19 | Wakayama, Japan | ||
1632351 | 1632351 | 2020-12-05 | Japan | Yamanashi | 413 | 9 | 311 | 93 | 35.612364 | 138.61148899999998 | 2020-12-06 05:26:18 | Yamanashi, Japan | ||
738316 | 738316 | 2020-12-02 | Japan | Iwate | 208 | 4 | 111 | 93 | 39.593287 | 141.361777 | 2020-12-03 05:28:22 | Iwate, Japan | ||
2537440 | 2537440 | 2020-12-01 | Japan | Wakayama | 462 | 6 | 363 | 93 | 33.911879 | 135.505446 | 2020-12-02 05:27:41 | Wakayama, Japan | ||
1584193 | 1584193 | 2020-11-30 | Japan | Oita | 295 | 3 | 199 | 93 | 33.200697 | 131.43323999999998 | 2020-12-01 05:26:18 | Oita, Japan | ||
2935277 | 2935277 | 2020-11-28 | Japan | Wakayama | 436 | 6 | 337 | 93 | 33.911879 | 135.505446 | 2020-11-29 05:25:55 | Wakayama, Japan | ||
3836510 | 3836510 | 2020-11-21 | Japan | Niigata | 294 | 0 | 201 | 93 | 37.521819 | 138.918647 | 2020-11-22 05:25:45 | Niigata, Japan | ||
3169657 | 3169657 | 2020-11-16 | Japan | Kumamoto | 918 | 10 | 815 | 93 | 32.608154 | 130.74523100000002 | 2020-11-17 05:25:54 | Kumamoto, Japan | ||
1988638 | 1988638 | 2020-11-09 | Japan | Fukuoka | 5284 | 104 | 5087 | 93 | 33.526032 | 130.666949 | 2020-11-10 05:40:07 | Fukuoka, Japan | ||
2606047 | 2606047 | 2020-09-24 | Japan | Kyoto | 1710 | 25 | 1592 | 93 | 35.253815 | 135.443341 | 2020-09-25 04:23:00 | Kyoto, Japan | ||
2454792 | 2454792 | 2020-09-19 | Japan | Kyoto | 1672 | 25 | 1554 | 93 | 35.253815 | 135.443341 | 2020-09-20 04:22:00 | Kyoto, Japan | ||
2729026 | 2729026 | 2020-09-15 | Japan | Miyagi | 331 | 2 | 236 | 93 | 38.446859 | 140.927086 | 2020-09-16 04:22:53 | Miyagi, Japan | ||
546767 | 546767 | 2020-09-12 | Japan | Ishikawa | 730 | 42 | 595 | 93 | 36.769464 | 136.771027 | 2020-09-13 04:30:52 | Ishikawa, Japan | ||
194076 | 194076 | 2020-08-31 | Japan | Gunma | 440 | 19 | 328 | 93 | 36.504479 | 138.985605 | 2020-09-01 04:28:31 | Gunma, Japan | ||
194087 | 194087 | 2020-08-31 | Japan | Kumamoto | 520 | 7 | 420 | 93 | 32.608154 | 130.74523100000002 | 2020-09-01 04:28:31 | Kumamoto, Japan | ||
2510204 | 2510204 | 2020-08-27 | Japan | Kumamoto | 491 | 7 | 391 | 93 | 32.608154 | 130.74523100000002 | 2020-08-28 04:28:11 | Kumamoto, Japan | ||
206267 | 206267 | 2020-08-19 | Japan | Ibaraki | 476 | 11 | 372 | 93 | 36.303588 | 140.319591 | 2020-08-20 04:27:43 | Ibaraki, Japan | ||
1928318 | 1928318 | 2020-07-30 | Japan | Hiroshima | 311 | 3 | 215 | 93 | 34.605309000000005 | 132.788719 | 2020-07-31 04:35:18 | Hiroshima, Japan | ||
2958518 | 2958518 | 2020-07-29 | Japan | Kagoshima | 232 | 1 | 138 | 93 | 31.009484000000004 | 130.430665 | 2020-07-30 04:35:05 | Kagoshima, Japan | ||
326932 | 326932 | 2020-07-20 | Japan | Hokkaido | 1351 | 102 | 1156 | 93 | 43.385711 | 142.55231799999999 | 2020-07-21 04:38:46 | Hokkaido, Japan | ||
2708590 | 2708590 | 2020-07-17 | Japan | Kyoto | 502 | 18 | 391 | 93 | 35.253815 | 135.443341 | 2020-07-18 04:34:45 | Kyoto, Japan | ||
2748072 | 2748072 | 2020-07-15 | Japan | Kyoto | 477 | 18 | 366 | 93 | 35.253815 | 135.443341 | 2020-07-16 04:44:59 | Kyoto, Japan | ||
2222579 | 2222579 | 2020-07-08 | Japan | Chiba | 1034 | 46 | 895 | 93 | 35.510141 | 140.198917 | 2020-07-09 04:34:23 | Chiba, Japan | ||
1195974 | 1195974 | 2020-06-17 | Japan | Port Quarantine | 271 | 0 | 178 | 93 | 2020-06-18 04:33:18 | Port Quarantine, Japan |
Advanced export
JSON shape: default, array, newline-delimited
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] TEXT, [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]);