daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
946 rows where country_or_region = "Japan" and province_or_state = "Hokkaido" sorted by admin2
This data as json, yaml, Notebook, copyable, CSV (advanced)
day | country_or_region | province_or_state | admin2 ▼ | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-09-07 | Japan | Hokkaido | 1834 | 105 | 1623 | 106 | 43.385711 | 142.552318 | 2020-09-08 04:28:25 | Hokkaido, Japan | ||
2022-11-03 | Japan | Hokkaido | 859767 | 2763 | 0 | 43.385711 | 142.552318 | 2022-11-04 04:22:11 | Hokkaido, Japan | |||
2021-01-21 | Japan | Hokkaido | 16325 | 557 | 14001 | 1767 | 43.385711 | 142.552318 | 2021-01-22 05:22:10 | Hokkaido, Japan | ||
2020-07-26 | Japan | Hokkaido | 1391 | 103 | 1188 | 100 | 43.385711 | 142.552318 | 2020-07-27 04:35:02 | Hokkaido, Japan | ||
2021-10-20 | Japan | Hokkaido | 60645 | 1469 | 0 | 43.385711 | 142.55231799999999 | 2021-10-21 04:21:18 | Hokkaido, Japan | |||
2021-11-17 | Japan | Hokkaido | 60982 | 1472 | 0 | 43.385711 | 142.55231799999999 | 2021-11-18 04:21:33 | Hokkaido, Japan | |||
2022-12-21 | Japan | Hokkaido | 1188520 | 3813 | 0 | 43.385711 | 142.552318 | 2022-12-22 04:20:56 | Hokkaido, Japan | |||
2020-08-07 | Japan | Hokkaido | 1528 | 103 | 1273 | 152 | 43.385711 | 142.552318 | 2020-08-08 04:34:53 | Hokkaido, Japan | ||
2022-02-02 | Japan | Hokkaido | 98561 | 1504 | 0 | 43.385711 | 142.55231799999999 | 2022-02-03 04:21:21 | Hokkaido, Japan | |||
2022-05-02 | Japan | Hokkaido | 297199 | 1997 | 0 | 43.385711 | 142.552318 | 2022-05-03 04:21:00 | Hokkaido, Japan | |||
2021-10-07 | Japan | Hokkaido | 60359 | 1469 | 0 | 43.385711 | 142.55231799999999 | 2021-10-08 04:21:25 | Hokkaido, Japan | |||
2021-02-19 | Japan | Hokkaido | 18717 | 650 | 17306 | 761 | 43.385711 | 142.552318 | 2021-02-20 05:22:51 | Hokkaido, Japan | ||
2022-06-26 | Japan | Hokkaido | 379664 | 2094 | 0 | 43.385711 | 142.552318 | 2022-06-27 04:21:00 | Hokkaido, Japan | |||
2022-11-08 | Japan | Hokkaido | 888963 | 2805 | 0 | 43.385711 | 142.552318 | 2022-11-09 04:21:22 | Hokkaido, Japan | |||
2021-07-19 | Japan | Hokkaido | 42456 | 1418 | 40141 | 897 | 43.385711 | 142.552318 | 2021-07-20 04:21:48 | Hokkaido, Japan | ||
2022-11-25 | Japan | Hokkaido | 1029264 | 3113 | 0 | 43.385711 | 142.552318 | 2022-11-26 04:21:11 | Hokkaido, Japan | |||
2021-10-14 | Japan | Hokkaido | 60519 | 1469 | 0 | 43.385711 | 142.55231799999999 | 2021-10-15 04:21:26 | Hokkaido, Japan | |||
2021-11-06 | Japan | Hokkaido | 60809 | 1472 | 0 | 43.385711 | 142.55231799999999 | 2021-11-07 04:21:53 | Hokkaido, Japan | |||
2022-04-02 | Japan | Hokkaido | 227037 | 1935 | 0 | 43.385711 | 142.55231799999999 | 2022-04-03 04:20:48 | Hokkaido, Japan | |||
2022-12-17 | Japan | Hokkaido | 1170252 | 3724 | 0 | 43.385711 | 142.552318 | 2022-12-18 04:21:03 | Hokkaido, Japan | |||
2021-08-14 | Japan | Hokkaido | 49186 | 1430 | 0 | 43.385711 | 142.55231799999999 | 2021-08-15 04:21:41 | Hokkaido, Japan | |||
2021-08-19 | Japan | Hokkaido | 51489 | 1434 | 0 | 43.385711 | 142.55231799999999 | 2021-08-20 04:21:33 | Hokkaido, Japan | |||
2022-10-15 | Japan | Hokkaido | 780358 | 2647 | 0 | 43.385711 | 142.552318 | 2022-10-16 04:22:39 | Hokkaido, Japan | |||
2021-06-09 | Japan | Hokkaido | 39938 | 1241 | 33003 | 5694 | 43.385711 | 142.552318 | 2021-06-10 04:23:17 | Hokkaido, Japan | ||
2020-07-04 | Japan | Hokkaido | 1276 | 101 | 1077 | 98 | 43.385711 | 142.55231799999999 | 2020-07-05 04:33:46 | Hokkaido, Japan | ||
2021-02-22 | Japan | Hokkaido | 18835 | 660 | 17423 | 752 | 43.385711 | 142.552318 | 2021-02-23 05:23:41 | Hokkaido, Japan | ||
2021-10-27 | Japan | Hokkaido | 60717 | 1470 | 0 | 43.385711 | 142.55231799999999 | 2021-10-28 04:22:08 | Hokkaido, Japan | |||
2022-10-26 | Japan | Hokkaido | 816761 | 2701 | 0 | 43.385711 | 142.552318 | 2022-10-27 04:22:01 | Hokkaido, Japan | |||
2022-12-15 | Japan | Hokkaido | 1158847 | 3681 | 0 | 43.385711 | 142.552318 | 2022-12-16 04:21:01 | Hokkaido, Japan | |||
2020-09-12 | Japan | Hokkaido | 1873 | 106 | 1679 | 88 | 43.385711 | 142.552318 | 2020-09-13 04:30:52 | Hokkaido, Japan | ||
2021-12-08 | Japan | Hokkaido | 61181 | 1473 | 0 | 43.385711 | 142.55231799999999 | 2021-12-09 04:22:49 | Hokkaido, Japan | |||
2022-01-16 | Japan | Hokkaido | 64629 | 1477 | 0 | 43.385711 | 142.55231799999999 | 2022-01-17 04:21:08 | Hokkaido, Japan | |||
2022-06-16 | Japan | Hokkaido | 373283 | 2082 | 0 | 43.385711 | 142.552318 | 2022-06-17 04:20:56 | Hokkaido, Japan | |||
2021-06-22 | Japan | Hokkaido | 41061 | 1358 | 37516 | 2187 | 43.385711 | 142.552318 | 2021-06-23 04:21:46 | Hokkaido, Japan | ||
2021-10-29 | Japan | Hokkaido | 60730 | 1470 | 0 | 43.385711 | 142.55231799999999 | 2021-10-30 04:22:03 | Hokkaido, Japan | |||
2020-06-06 | Japan | Hokkaido | 1117 | 90 | 849 | 178 | 43.385711 | 142.552318 | 2020-06-07 03:53:30 | Hokkaido, Japan | ||
2022-02-25 | Japan | Hokkaido | 165998 | 1734 | 0 | 43.385711 | 142.55231799999999 | 2022-02-26 04:21:12 | Hokkaido, Japan | |||
2021-07-13 | Japan | Hokkaido | 41935 | 1413 | 39843 | 679 | 43.385711 | 142.552318 | 2021-07-14 04:21:35 | Hokkaido, Japan | ||
2020-08-13 | Japan | Hokkaido | 1593 | 103 | 1323 | 167 | 43.385711 | 142.552318 | 2020-08-14 04:51:19 | Hokkaido, Japan | ||
2021-08-08 | Japan | Hokkaido | 46765 | 1428 | 0 | 43.385711 | 142.552318 | 2021-08-09 04:21:24 | Hokkaido, Japan | |||
2022-07-01 | Japan | Hokkaido | 382401 | 2096 | 0 | 43.385711 | 142.552318 | 2022-07-02 04:21:16 | Hokkaido, Japan | |||
2021-10-19 | Japan | Hokkaido | 60631 | 1469 | 0 | 43.385711 | 142.55231799999999 | 2021-10-20 04:21:00 | Hokkaido, Japan | |||
2021-09-23 | Japan | Hokkaido | 59942 | 1466 | 0 | 43.385711 | 142.55231799999999 | 2021-09-24 04:21:44 | Hokkaido, Japan | |||
2021-04-09 | Japan | Hokkaido | 21595 | 772 | 19846 | 977 | 43.385711 | 142.552318 | 2021-04-10 04:20:59 | Hokkaido, Japan | ||
2020-08-29 | Japan | Hokkaido | 1769 | 103 | 1512 | 154 | 43.385711 | 142.552318 | 2020-08-30 04:28:22 | Hokkaido, Japan | ||
2021-02-08 | Japan | Hokkaido | 18130 | 625 | 16254 | 1251 | 43.385711 | 142.552318 | 2021-02-09 05:23:30 | Hokkaido, Japan | ||
2022-11-05 | Japan | Hokkaido | 871058 | 2776 | 0 | 43.385711 | 142.552318 | 2022-11-06 04:21:24 | Hokkaido, Japan | |||
2022-05-22 | Japan | Hokkaido | 350642 | 2051 | 0 | 43.385711 | 142.552318 | 2022-05-26 04:20:50 | Hokkaido, Japan | |||
2021-07-10 | Japan | Hokkaido | 41772 | 1412 | 39745 | 615 | 43.385711 | 142.552318 | 2021-07-11 04:21:43 | Hokkaido, Japan | ||
2022-07-12 | Japan | Hokkaido | 390396 | 2102 | 0 | 43.385711 | 142.552318 | 2022-07-13 04:20:58 | Hokkaido, Japan | |||
2021-10-13 | Japan | Hokkaido | 60474 | 1469 | 0 | 43.385711 | 142.55231799999999 | 2021-10-14 04:21:29 | Hokkaido, Japan | |||
2021-03-31 | Japan | Hokkaido | 20994 | 749 | 19413 | 832 | 43.385711 | 142.552318 | 2021-04-01 04:27:05 | Hokkaido, Japan | ||
2021-09-07 | Japan | Hokkaido | 58425 | 1460 | 0 | 43.385711 | 142.55231799999999 | 2021-09-08 04:21:31 | Hokkaido, Japan | |||
2021-05-05 | Japan | Hokkaido | 25204 | 878 | 22055 | 2271 | 43.385711 | 142.552318 | 2021-05-06 04:20:38 | Hokkaido, Japan | ||
2021-08-09 | Japan | Hokkaido | 47075 | 1428 | 0 | 43.385711 | 142.55231799999999 | 2021-08-10 04:21:27 | Hokkaido, Japan | |||
2021-10-22 | Japan | Hokkaido | 60671 | 1470 | 0 | 43.385711 | 142.55231799999999 | 2021-10-23 04:21:32 | Hokkaido, Japan | |||
2022-05-13 | Japan | Hokkaido | 324181 | 2018 | 0 | 43.385711 | 142.552318 | 2022-05-14 04:20:48 | Hokkaido, Japan | |||
2020-08-11 | Japan | Hokkaido | 1579 | 103 | 1316 | 160 | 43.385711 | 142.552318 | 2020-08-12 04:27:29 | Hokkaido, Japan | ||
2020-09-16 | Japan | Hokkaido | 1903 | 106 | 1717 | 80 | 43.385711 | 142.552318 | 2020-09-17 04:22:00 | Hokkaido, Japan | ||
2022-07-21 | Japan | Hokkaido | 407678 | 2109 | 0 | 43.385711 | 142.552318 | 2022-07-22 04:21:15 | Hokkaido, Japan | |||
2022-07-30 | Japan | Hokkaido | 451557 | 2136 | 0 | 43.385711 | 142.552318 | 2022-07-31 04:21:02 | Hokkaido, Japan | |||
2020-11-23 | Japan | Hokkaido | 7368 | 152 | 4629 | 2587 | 43.385711 | 142.552318 | 2020-11-24 05:27:31 | Hokkaido, Japan | ||
2021-10-24 | Japan | Hokkaido | 60694 | 1470 | 0 | 43.385711 | 142.55231799999999 | 2021-10-25 04:22:31 | Hokkaido, Japan | |||
2021-11-13 | Japan | Hokkaido | 60895 | 1472 | 0 | 43.385711 | 142.55231799999999 | 2021-11-14 04:21:31 | Hokkaido, Japan | |||
2022-12-23 | Japan | Hokkaido | 1199266 | 3862 | 0 | 43.385711 | 142.552318 | 2022-12-24 04:21:02 | Hokkaido, Japan | |||
2022-03-17 | Japan | Hokkaido | 201047 | 1890 | 0 | 43.385711 | 142.55231799999999 | 2022-03-18 04:20:55 | Hokkaido, Japan | |||
2021-11-04 | Japan | Hokkaido | 60783 | 1472 | 0 | 43.385711 | 142.55231799999999 | 2021-11-05 04:21:54 | Hokkaido, Japan | |||
2021-03-16 | Japan | Hokkaido | 20013 | 715 | 18534 | 764 | 43.385711 | 142.552318 | 2021-03-17 05:25:07 | Hokkaido, Japan | ||
2021-09-29 | Japan | Hokkaido | 60212 | 1467 | 0 | 43.385711 | 142.55231799999999 | 2021-09-30 04:21:20 | Hokkaido, Japan | |||
2022-11-01 | Japan | Hokkaido | 844615 | 2739 | 0 | 43.385711 | 142.552318 | 2022-11-02 04:22:09 | Hokkaido, Japan | |||
2021-11-12 | Japan | Hokkaido | 60876 | 1472 | 0 | 43.385711 | 142.55231799999999 | 2021-11-13 04:21:38 | Hokkaido, Japan | |||
2022-12-04 | Japan | Hokkaido | 1094147 | 3387 | 0 | 43.385711 | 142.552318 | 2022-12-05 04:20:58 | Hokkaido, Japan | |||
2021-11-20 | Japan | Hokkaido | 61031 | 1472 | 0 | 43.385711 | 142.55231799999999 | 2021-11-21 04:22:13 | Hokkaido, Japan | |||
2021-05-22 | Japan | Hokkaido | 33976 | 990 | 25616 | 7370 | 43.385711 | 142.552318 | 2021-05-23 04:20:51 | Hokkaido, Japan | ||
2021-12-27 | Japan | Hokkaido | 61402 | 1474 | 0 | 43.385711 | 142.55231799999999 | 2021-12-28 04:21:47 | Hokkaido, Japan | |||
2020-06-12 | Japan | Hokkaido | 1154 | 91 | 921 | 142 | 43.385711 | 142.55231799999999 | 2020-06-13 03:33:14 | Hokkaido, Japan | ||
2020-12-02 | Japan | Hokkaido | 9248 | 213 | 6394 | 2641 | 43.385711 | 142.552318 | 2020-12-03 05:28:22 | Hokkaido, Japan | ||
2021-02-20 | Japan | Hokkaido | 18751 | 656 | 17351 | 744 | 43.385711 | 142.552318 | 2021-02-21 05:24:33 | Hokkaido, Japan | ||
2022-04-23 | Japan | Hokkaido | 275161 | 1981 | 0 | 43.385711 | 142.55231799999999 | 2022-04-24 04:20:56 | Hokkaido, Japan | |||
2020-08-01 | Japan | Hokkaido | 1446 | 103 | 1237 | 106 | 43.385711 | 142.552318 | 2020-08-02 04:34:47 | Hokkaido, Japan | ||
2020-10-28 | Japan | Hokkaido | 2933 | 109 | 2402 | 422 | 43.385711 | 142.552318 | 2020-10-29 04:24:49 | Hokkaido, Japan | ||
2021-11-26 | Japan | Hokkaido | 61116 | 1472 | 0 | 43.385711 | 142.55231799999999 | 2021-11-27 04:22:45 | Hokkaido, Japan | |||
2020-10-18 | Japan | Hokkaido | 2542 | 108 | 2166 | 268 | 43.385711 | 142.552318 | 2020-10-19 04:24:16 | Hokkaido, Japan | ||
2020-12-29 | Japan | Hokkaido | 13138 | 445 | 10988 | 1705 | 43.385711 | 142.552318 | 2020-12-30 05:22:34 | Hokkaido, Japan | ||
2021-10-23 | Japan | Hokkaido | 60676 | 1470 | 0 | 43.385711 | 142.55231799999999 | 2021-10-24 04:21:22 | Hokkaido, Japan | |||
2021-01-12 | Japan | Hokkaido | 14993 | 514 | 12767 | 1712 | 43.385711 | 142.552318 | 2021-01-13 05:22:15 | Hokkaido, Japan | ||
2021-07-08 | Japan | Hokkaido | 41658 | 1411 | 39685 | 562 | 43.385711 | 142.552318 | 2021-07-09 04:21:21 | Hokkaido, Japan | ||
2021-12-13 | Japan | Hokkaido | 61200 | 1474 | 0 | 43.385711 | 142.55231799999999 | 2021-12-14 04:22:38 | Hokkaido, Japan | |||
2020-10-15 | Japan | Hokkaido | 2460 | 107 | 2096 | 257 | 43.385711 | 142.552318 | 2020-10-16 04:24:01 | Hokkaido, Japan | ||
2021-02-04 | Japan | Hokkaido | 17840 | 612 | 15859 | 1369 | 43.385711 | 142.552318 | 2021-02-05 05:22:38 | Hokkaido, Japan | ||
2022-10-24 | Japan | Hokkaido | 805616 | 2697 | 0 | 43.385711 | 142.552318 | 2022-10-25 04:21:53 | Hokkaido, Japan | |||
2021-12-22 | Japan | Hokkaido | 61309 | 1474 | 0 | 43.385711 | 142.55231799999999 | 2021-12-23 04:21:21 | Hokkaido, Japan | |||
2020-06-01 | Japan | Hokkaido | 1096 | 87 | 810 | 199 | 43.385711 | 142.55231799999999 | 2020-06-02 02:33:08 | Hokkaido, Japan | ||
2021-09-20 | Japan | Hokkaido | 59774 | 1466 | 0 | 43.385711 | 142.55231799999999 | 2021-09-21 04:21:26 | Hokkaido, Japan | |||
2020-09-05 | Japan | Hokkaido | 1824 | 105 | 1594 | 125 | 43.385711 | 142.552318 | 2020-09-06 04:28:33 | Hokkaido, Japan | ||
2020-10-09 | Japan | Hokkaido | 2323 | 107 | 1964 | 252 | 43.385711 | 142.552318 | 2020-10-10 04:23:57 | Hokkaido, Japan | ||
2020-11-19 | Japan | Hokkaido | 6380 | 141 | 3846 | 2393 | 43.385711 | 142.552318 | 2020-11-20 05:26:28 | Hokkaido, Japan | ||
2021-06-06 | Japan | Hokkaido | 39492 | 1191 | 31935 | 6366 | 43.385711 | 142.552318 | 2021-06-07 04:22:51 | Hokkaido, Japan | ||
2021-07-09 | Japan | Hokkaido | 41708 | 1412 | 39725 | 571 | 43.385711 | 142.552318 | 2021-07-10 04:21:25 | Hokkaido, Japan | ||
2022-12-02 | Japan | Hokkaido | 1082592 | 3348 | 0 | 43.385711 | 142.552318 | 2022-12-03 04:21:02 | Hokkaido, Japan |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;