johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
482 rows where active = 2 and country_or_region = "Japan" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
province_or_state >30
- Saga 48
- Aomori 47
- Akita 38
- Yamanashi 27
- Yamagata 26
- Fukushima 25
- Niigata 22
- Shimane 22
- Fukui 20
- Kochi 20
- Tottori 20
- Nagasaki 18
- Nagano 17
- Shiga 16
- Toyama 14
- Ehime 12
- Okayama 12
- Iwate 11
- Oita 11
- Gunma 9
- Gifu 7
- Miyazaki 7
- Shizuoka 7
- Yamaguchi 7
- Okinawa 5
- Kagawa 3
- Kumamoto 3
- Mie 2
- Miyagi 2
- Hiroshima 1
- …
country_or_region 1
- Japan · 482 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3903981 | 3903981 | 2021-07-31 | Japan | Gifu | 9589 | 188 | 9399 | 2 | 35.778671 | 137.055925 | 2021-08-01 04:21:50 | Gifu, Japan | ||
2947378 | 2947378 | 2021-07-16 | Japan | Mie | 5422 | 113 | 5307 | 2 | 34.508018 | 136.376013 | 2021-07-17 04:22:22 | Mie, Japan | ||
1440620 | 1440620 | 2021-07-07 | Japan | Shimane | 555 | 2 | 551 | 2 | 35.07076 | 132.55406399999998 | 2021-07-08 04:21:26 | Shimane, Japan | ||
2693725 | 2693725 | 2021-07-06 | Japan | Shimane | 554 | 2 | 550 | 2 | 35.07076 | 132.55406399999998 | 2021-07-07 04:21:20 | Shimane, Japan | ||
1932474 | 1932474 | 2021-07-05 | Japan | Shimane | 553 | 2 | 549 | 2 | 35.07076 | 132.55406399999998 | 2021-07-06 04:21:32 | Shimane, Japan | ||
2590039 | 2590039 | 2021-06-27 | Japan | Shimane | 552 | 1 | 549 | 2 | 35.07076 | 132.55406399999998 | 2021-06-28 04:21:29 | Shimane, Japan | ||
562992 | 562992 | 2021-06-22 | Japan | Nagano | 4985 | 91 | 4892 | 2 | 36.132134 | 138.045528 | 2021-06-23 04:21:46 | Nagano, Japan | ||
1302089 | 1302089 | 2021-04-01 | Japan | Shimane | 288 | 0 | 286 | 2 | 35.07076 | 132.55406399999998 | 2021-04-02 04:20:36 | Shimane, Japan | ||
637961 | 637961 | 2021-03-31 | Japan | Shimane | 287 | 0 | 285 | 2 | 35.07076 | 132.55406399999998 | 2021-04-01 04:27:05 | Shimane, Japan | ||
1881003 | 1881003 | 2021-03-26 | Japan | Kagoshima | 1790 | 28 | 1760 | 2 | 31.009484000000004 | 130.430665 | 2021-03-27 05:25:04 | Kagoshima, Japan | ||
1980664 | 1980664 | 2021-03-25 | Japan | Yamanashi | 956 | 18 | 936 | 2 | 35.612364 | 138.61148899999998 | 2021-03-26 05:26:55 | Yamanashi, Japan | ||
1203833 | 1203833 | 2021-03-22 | Japan | Nagasaki | 1616 | 38 | 1576 | 2 | 33.235712 | 129.608033 | 2021-03-23 05:26:18 | Nagasaki, Japan | ||
3369355 | 3369355 | 2021-03-21 | Japan | Nagasaki | 1616 | 38 | 1576 | 2 | 33.235712 | 129.608033 | 2021-03-22 05:25:43 | Nagasaki, Japan | ||
3621107 | 3621107 | 2021-03-17 | Japan | Nagasaki | 1614 | 38 | 1574 | 2 | 33.235712 | 129.608033 | 2021-03-18 05:26:22 | Nagasaki, Japan | ||
702406 | 702406 | 2021-03-16 | Japan | Akita | 270 | 6 | 262 | 2 | 39.748679 | 140.408228 | 2021-03-17 05:25:07 | Akita, Japan | ||
2055888 | 2055888 | 2021-03-15 | Japan | Fukui | 546 | 25 | 519 | 2 | 35.846614 | 136.22465400000002 | 2021-03-16 05:25:13 | Fukui, Japan | ||
1732500 | 1732500 | 2021-03-14 | Japan | Fukui | 546 | 25 | 519 | 2 | 35.846614 | 136.22465400000002 | 2021-03-15 05:25:51 | Fukui, Japan | ||
1580157 | 1580157 | 2021-03-13 | Japan | Fukui | 546 | 25 | 519 | 2 | 35.846614 | 136.22465400000002 | 2021-03-14 05:25:37 | Fukui, Japan | ||
1837936 | 1837936 | 2021-03-12 | Japan | Fukui | 546 | 25 | 519 | 2 | 35.846614 | 136.22465400000002 | 2021-03-13 05:25:15 | Fukui, Japan | ||
352301 | 352301 | 2021-03-11 | Japan | Fukui | 546 | 25 | 519 | 2 | 35.846614 | 136.22465400000002 | 2021-03-12 05:26:50 | Fukui, Japan | ||
3962568 | 3962568 | 2021-03-10 | Japan | Yamanashi | 941 | 17 | 922 | 2 | 35.612364 | 138.61148899999998 | 2021-03-11 05:25:48 | Yamanashi, Japan | ||
3663623 | 3663623 | 2021-03-09 | Japan | Iwate | 555 | 30 | 523 | 2 | 39.593287 | 141.361777 | 2021-03-10 05:24:35 | Iwate, Japan | ||
3663656 | 3663656 | 2021-03-09 | Japan | Yamanashi | 941 | 17 | 922 | 2 | 35.612364 | 138.61148899999998 | 2021-03-10 05:24:35 | Yamanashi, Japan | ||
2359482 | 2359482 | 2021-03-08 | Japan | Iwate | 555 | 30 | 523 | 2 | 39.593287 | 141.361777 | 2021-03-09 05:28:19 | Iwate, Japan | ||
54810 | 54810 | 2021-03-07 | Japan | Fukui | 545 | 25 | 518 | 2 | 35.846614 | 136.22465400000002 | 2021-03-08 05:24:48 | Fukui, Japan | ||
54820 | 54820 | 2021-03-07 | Japan | Iwate | 555 | 30 | 523 | 2 | 39.593287 | 141.361777 | 2021-03-08 05:24:48 | Iwate, Japan | ||
3667637 | 3667637 | 2021-03-06 | Japan | Iwate | 555 | 30 | 523 | 2 | 39.593287 | 141.361777 | 2021-03-07 05:21:54 | Iwate, Japan | ||
3254148 | 3254148 | 2021-03-02 | Japan | Akita | 269 | 6 | 261 | 2 | 39.748679 | 140.408228 | 2021-03-03 05:23:28 | Akita, Japan | ||
845571 | 845571 | 2020-12-12 | Japan | Akita | 92 | 1 | 89 | 2 | 39.748679 | 140.408228 | 2020-12-13 05:27:20 | Akita, Japan | ||
2975229 | 2975229 | 2020-12-09 | Japan | Akita | 90 | 1 | 87 | 2 | 39.748679 | 140.408228 | 2020-12-10 05:26:19 | Akita, Japan | ||
1972624 | 1972624 | 2020-11-25 | Japan | Shimane | 143 | 0 | 141 | 2 | 35.07076 | 132.55406399999998 | 2020-11-26 05:27:44 | Shimane, Japan | ||
3190007 | 3190007 | 2020-11-22 | Japan | Kochi | 146 | 4 | 140 | 2 | 33.422519 | 133.367307 | 2020-11-23 05:25:26 | Kochi, Japan | ||
3836501 | 3836501 | 2020-11-21 | Japan | Kochi | 146 | 4 | 140 | 2 | 33.422519 | 133.367307 | 2020-11-22 05:25:45 | Kochi, Japan | ||
2880229 | 2880229 | 2020-11-15 | Japan | Miyazaki | 373 | 1 | 370 | 2 | 32.193203999999994 | 131.299374 | 2020-11-16 05:25:57 | Miyazaki, Japan | ||
2915207 | 2915207 | 2020-11-14 | Japan | Miyazaki | 373 | 1 | 370 | 2 | 32.193203999999994 | 131.299374 | 2020-11-15 05:26:53 | Miyazaki, Japan | ||
2785029 | 2785029 | 2020-11-13 | Japan | Miyazaki | 373 | 1 | 370 | 2 | 32.193203999999994 | 131.299374 | 2020-11-14 05:25:37 | Miyazaki, Japan | ||
2785048 | 2785048 | 2020-11-13 | Japan | Toyama | 425 | 26 | 397 | 2 | 36.637464 | 137.26934599999998 | 2020-11-14 05:25:37 | Toyama, Japan | ||
864794 | 864794 | 2020-11-12 | Japan | Miyazaki | 373 | 1 | 370 | 2 | 32.193203999999994 | 131.299374 | 2020-11-13 05:25:30 | Miyazaki, Japan | ||
864813 | 864813 | 2020-11-12 | Japan | Toyama | 425 | 26 | 397 | 2 | 36.637464 | 137.26934599999998 | 2020-11-13 05:25:30 | Toyama, Japan | ||
3440839 | 3440839 | 2020-11-11 | Japan | Miyazaki | 373 | 1 | 370 | 2 | 32.193203999999994 | 131.299374 | 2020-11-12 05:25:55 | Miyazaki, Japan | ||
3440858 | 3440858 | 2020-11-11 | Japan | Toyama | 425 | 26 | 397 | 2 | 36.637464 | 137.26934599999998 | 2020-11-12 05:25:55 | Toyama, Japan | ||
272184 | 272184 | 2020-11-10 | Japan | Oita | 161 | 3 | 156 | 2 | 33.200697 | 131.43323999999998 | 2020-11-11 05:25:30 | Oita, Japan | ||
272198 | 272198 | 2020-11-10 | Japan | Toyama | 425 | 26 | 397 | 2 | 36.637464 | 137.26934599999998 | 2020-11-11 05:25:30 | Toyama, Japan | ||
1988661 | 1988661 | 2020-11-09 | Japan | Oita | 161 | 3 | 156 | 2 | 33.200697 | 131.43323999999998 | 2020-11-10 05:40:07 | Oita, Japan | ||
1728513 | 1728513 | 2020-11-08 | Japan | Oita | 161 | 3 | 156 | 2 | 33.200697 | 131.43323999999998 | 2020-11-09 05:25:45 | Oita, Japan | ||
1728527 | 1728527 | 2020-11-08 | Japan | Toyama | 424 | 26 | 396 | 2 | 36.637464 | 137.26934599999998 | 2020-11-09 05:25:45 | Toyama, Japan | ||
1543949 | 1543949 | 2020-11-07 | Japan | Fukui | 258 | 11 | 245 | 2 | 35.846614 | 136.22465400000002 | 2020-11-08 05:24:56 | Fukui, Japan | ||
1543987 | 1543987 | 2020-11-07 | Japan | Toyama | 424 | 26 | 396 | 2 | 36.637464 | 137.26934599999998 | 2020-11-08 05:24:56 | Toyama, Japan | ||
376225 | 376225 | 2020-11-06 | Japan | Toyama | 424 | 26 | 396 | 2 | 36.637464 | 137.26934599999998 | 2020-11-07 05:24:52 | Toyama, Japan | ||
892146 | 892146 | 2020-11-05 | Japan | Nagasaki | 246 | 3 | 241 | 2 | 33.235712 | 129.608033 | 2020-11-06 05:24:55 | Nagasaki, Japan | ||
892162 | 892162 | 2020-11-05 | Japan | Tottori | 38 | 0 | 36 | 2 | 35.359069 | 133.863619 | 2020-11-06 05:24:55 | Tottori, Japan | ||
892163 | 892163 | 2020-11-05 | Japan | Toyama | 424 | 26 | 396 | 2 | 36.637464 | 137.26934599999998 | 2020-11-06 05:24:55 | Toyama, Japan | ||
2498038 | 2498038 | 2020-11-03 | Japan | Kochi | 144 | 4 | 138 | 2 | 33.422519 | 133.367307 | 2020-11-04 05:25:09 | Kochi, Japan | ||
3304209 | 3304209 | 2020-11-02 | Japan | Iwate | 27 | 0 | 25 | 2 | 39.593287 | 141.361777 | 2020-11-03 06:00:16 | Iwate, Japan | ||
3304213 | 3304213 | 2020-11-02 | Japan | Kochi | 144 | 4 | 138 | 2 | 33.422519 | 133.367307 | 2020-11-03 06:00:16 | Kochi, Japan | ||
3304220 | 3304220 | 2020-11-02 | Japan | Nagasaki | 245 | 3 | 240 | 2 | 33.235712 | 129.608033 | 2020-11-03 06:00:16 | Nagasaki, Japan | ||
3409448 | 3409448 | 2020-11-01 | Japan | Fukui | 257 | 11 | 244 | 2 | 35.846614 | 136.22465400000002 | 2020-11-02 05:25:04 | Fukui, Japan | ||
3409458 | 3409458 | 2020-11-01 | Japan | Iwate | 27 | 0 | 25 | 2 | 39.593287 | 141.361777 | 2020-11-02 05:25:04 | Iwate, Japan | ||
3409462 | 3409462 | 2020-11-01 | Japan | Kochi | 144 | 4 | 138 | 2 | 33.422519 | 133.367307 | 2020-11-02 05:25:04 | Kochi, Japan | ||
3409469 | 3409469 | 2020-11-01 | Japan | Nagasaki | 245 | 3 | 240 | 2 | 33.235712 | 129.608033 | 2020-11-02 05:25:04 | Nagasaki, Japan | ||
2079937 | 2079937 | 2020-10-31 | Japan | Fukui | 257 | 11 | 244 | 2 | 35.846614 | 136.22465400000002 | 2020-11-01 04:36:19 | Fukui, Japan | ||
2079947 | 2079947 | 2020-10-31 | Japan | Iwate | 27 | 0 | 25 | 2 | 39.593287 | 141.361777 | 2020-11-01 04:36:19 | Iwate, Japan | ||
2079958 | 2079958 | 2020-10-31 | Japan | Nagasaki | 245 | 3 | 240 | 2 | 33.235712 | 129.608033 | 2020-11-01 04:36:19 | Nagasaki, Japan | ||
2243386 | 2243386 | 2020-10-30 | Japan | Akita | 61 | 0 | 59 | 2 | 39.748679 | 140.408228 | 2020-10-31 04:24:44 | Akita, Japan | ||
2243400 | 2243400 | 2020-10-30 | Japan | Iwate | 27 | 0 | 25 | 2 | 39.593287 | 141.361777 | 2020-10-31 04:24:44 | Iwate, Japan | ||
2243411 | 2243411 | 2020-10-30 | Japan | Nagasaki | 244 | 3 | 239 | 2 | 33.235712 | 129.608033 | 2020-10-31 04:24:44 | Nagasaki, Japan | ||
210241 | 210241 | 2020-10-29 | Japan | Akita | 61 | 0 | 59 | 2 | 39.748679 | 140.408228 | 2020-10-30 04:24:49 | Akita, Japan | ||
210266 | 210266 | 2020-10-29 | Japan | Nagasaki | 244 | 3 | 239 | 2 | 33.235712 | 129.608033 | 2020-10-30 04:24:49 | Nagasaki, Japan | ||
754303 | 754303 | 2020-10-28 | Japan | Akita | 61 | 0 | 59 | 2 | 39.748679 | 140.408228 | 2020-10-29 04:24:49 | Akita, Japan | ||
754307 | 754307 | 2020-10-28 | Japan | Fukui | 256 | 11 | 243 | 2 | 35.846614 | 136.22465400000002 | 2020-10-29 04:24:49 | Fukui, Japan | ||
754328 | 754328 | 2020-10-28 | Japan | Nagasaki | 244 | 3 | 239 | 2 | 33.235712 | 129.608033 | 2020-10-29 04:24:49 | Nagasaki, Japan | ||
754330 | 754330 | 2020-10-28 | Japan | Niigata | 181 | 0 | 179 | 2 | 37.521819 | 138.918647 | 2020-10-29 04:24:49 | Niigata, Japan | ||
1452588 | 1452588 | 2020-10-27 | Japan | Akita | 61 | 0 | 59 | 2 | 39.748679 | 140.408228 | 2020-10-28 04:24:39 | Akita, Japan | ||
1452613 | 1452613 | 2020-10-27 | Japan | Nagasaki | 244 | 3 | 239 | 2 | 33.235712 | 129.608033 | 2020-10-28 04:24:39 | Nagasaki, Japan | ||
1452615 | 1452615 | 2020-10-27 | Japan | Niigata | 181 | 0 | 179 | 2 | 37.521819 | 138.918647 | 2020-10-28 04:24:39 | Niigata, Japan | ||
3480312 | 3480312 | 2020-10-26 | Japan | Akita | 61 | 0 | 59 | 2 | 39.748679 | 140.408228 | 2020-10-27 04:24:45 | Akita, Japan | ||
3480330 | 3480330 | 2020-10-26 | Japan | Kochi | 142 | 4 | 136 | 2 | 33.422519 | 133.367307 | 2020-10-27 04:24:45 | Kochi, Japan | ||
3480339 | 3480339 | 2020-10-26 | Japan | Niigata | 181 | 0 | 179 | 2 | 37.521819 | 138.918647 | 2020-10-27 04:24:45 | Niigata, Japan | ||
3480345 | 3480345 | 2020-10-26 | Japan | Saga | 254 | 0 | 252 | 2 | 33.286977 | 130.115738 | 2020-10-27 04:24:45 | Saga, Japan | ||
3480353 | 3480353 | 2020-10-26 | Japan | Tottori | 37 | 0 | 35 | 2 | 35.359069 | 133.863619 | 2020-10-27 04:24:45 | Tottori, Japan | ||
8333 | 8333 | 2020-10-25 | Japan | Akita | 61 | 0 | 59 | 2 | 39.748679 | 140.408228 | 2020-10-26 04:25:02 | Akita, Japan | ||
8351 | 8351 | 2020-10-25 | Japan | Kochi | 142 | 4 | 136 | 2 | 33.422519 | 133.367307 | 2020-10-26 04:25:02 | Kochi, Japan | ||
8360 | 8360 | 2020-10-25 | Japan | Niigata | 181 | 0 | 179 | 2 | 37.521819 | 138.918647 | 2020-10-26 04:25:02 | Niigata, Japan | ||
8366 | 8366 | 2020-10-25 | Japan | Saga | 254 | 0 | 252 | 2 | 33.286977 | 130.115738 | 2020-10-26 04:25:02 | Saga, Japan | ||
8374 | 8374 | 2020-10-25 | Japan | Tottori | 37 | 0 | 35 | 2 | 35.359069 | 133.863619 | 2020-10-26 04:25:02 | Tottori, Japan | ||
3651570 | 3651570 | 2020-10-24 | Japan | Akita | 61 | 0 | 59 | 2 | 39.748679 | 140.408228 | 2020-10-25 04:24:36 | Akita, Japan | ||
1053825 | 1053825 | 2020-10-23 | Japan | Akita | 61 | 0 | 59 | 2 | 39.748679 | 140.408228 | 2020-10-24 04:24:46 | Akita, Japan | ||
1053858 | 1053858 | 2020-10-23 | Japan | Saga | 253 | 0 | 251 | 2 | 33.286977 | 130.115738 | 2020-10-24 04:24:46 | Saga, Japan | ||
1177495 | 1177495 | 2020-10-22 | Japan | Akita | 61 | 0 | 59 | 2 | 39.748679 | 140.408228 | 2020-10-23 04:24:46 | Akita, Japan | ||
2191600 | 2191600 | 2020-10-21 | Japan | Akita | 61 | 0 | 59 | 2 | 39.748679 | 140.408228 | 2020-10-22 04:24:27 | Akita, Japan | ||
2191603 | 2191603 | 2020-10-21 | Japan | Ehime | 116 | 6 | 108 | 2 | 33.624835 | 132.856842 | 2020-10-22 04:24:27 | Ehime, Japan | ||
2191627 | 2191627 | 2020-10-21 | Japan | Niigata | 179 | 0 | 177 | 2 | 37.521819 | 138.918647 | 2020-10-22 04:24:27 | Niigata, Japan | ||
2191645 | 2191645 | 2020-10-21 | Japan | Yamagata | 82 | 1 | 79 | 2 | 38.448396 | 140.102154 | 2020-10-22 04:24:27 | Yamagata, Japan | ||
3990614 | 3990614 | 2020-10-20 | Japan | Ehime | 116 | 6 | 108 | 2 | 33.624835 | 132.856842 | 2020-10-21 04:24:14 | Ehime, Japan | ||
3990638 | 3990638 | 2020-10-20 | Japan | Niigata | 179 | 0 | 177 | 2 | 37.521819 | 138.918647 | 2020-10-21 04:24:14 | Niigata, Japan | ||
3990656 | 3990656 | 2020-10-20 | Japan | Yamagata | 81 | 1 | 78 | 2 | 38.448396 | 140.102154 | 2020-10-21 04:24:14 | Yamagata, Japan | ||
3990657 | 3990657 | 2020-10-20 | Japan | Yamaguchi | 209 | 2 | 205 | 2 | 34.201190000000004 | 131.573293 | 2020-10-21 04:24:14 | Yamaguchi, Japan | ||
3990658 | 3990658 | 2020-10-20 | Japan | Yamanashi | 199 | 6 | 191 | 2 | 35.612364 | 138.61148899999998 | 2020-10-21 04:24:14 | Yamanashi, Japan | ||
1794634 | 1794634 | 2020-10-19 | Japan | Ehime | 116 | 6 | 108 | 2 | 33.624835 | 132.856842 | 2020-10-20 04:24:22 | Ehime, Japan | ||
1794676 | 1794676 | 2020-10-19 | Japan | Yamagata | 81 | 1 | 78 | 2 | 38.448396 | 140.102154 | 2020-10-20 04:24:22 | Yamagata, 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]);