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-08-17 | Japan | Hokkaido | 1632 | 103 | 1379 | 150 | 43.385711 | 142.552318 | 2020-08-18 04:27:56 | Hokkaido, Japan | ||
2020-07-22 | Japan | Hokkaido | 1367 | 102 | 1164 | 101 | 43.385711 | 142.552318 | 2020-07-23 05:15:04 | Hokkaido, Japan | ||
2020-12-12 | Japan | Hokkaido | 11167 | 308 | 8239 | 2620 | 43.385711 | 142.552318 | 2020-12-13 05:27:20 | Hokkaido, Japan | ||
2022-11-02 | Japan | Hokkaido | 852510 | 2750 | 0 | 43.385711 | 142.552318 | 2022-11-03 04:22:05 | Hokkaido, Japan | |||
2022-09-30 | Japan | Hokkaido | 747821 | 2591 | 0 | 43.385711 | 142.552318 | 2022-10-01 04:23:01 | Hokkaido, Japan | |||
2020-12-11 | Japan | Hokkaido | 10979 | 302 | 8025 | 2652 | 43.385711 | 142.552318 | 2020-12-12 05:26:19 | Hokkaido, Japan | ||
2020-11-12 | Japan | Hokkaido | 4820 | 122 | 3110 | 1588 | 43.385711 | 142.552318 | 2020-11-13 05:25:30 | Hokkaido, Japan | ||
2022-12-11 | Japan | Hokkaido | 1135075 | 3576 | 0 | 43.385711 | 142.552318 | 2022-12-12 04:21:01 | Hokkaido, Japan | |||
2022-03-27 | Japan | Hokkaido | 216368 | 1918 | 0 | 43.385711 | 142.55231799999999 | 2022-03-28 04:20:33 | Hokkaido, Japan | |||
2022-08-05 | Japan | Hokkaido | 488182 | 2174 | 0 | 43.385711 | 142.552318 | 2022-08-06 04:20:56 | Hokkaido, Japan | |||
2020-07-07 | Japan | Hokkaido | 1278 | 101 | 1093 | 84 | 43.385711 | 142.55231799999999 | 2020-07-08 05:33:48 | Hokkaido, Japan | ||
2021-04-26 | Japan | Hokkaido | 23409 | 843 | 21108 | 1458 | 43.385711 | 142.552318 | 2021-04-27 04:20:52 | Hokkaido, Japan | ||
2020-11-05 | Japan | Hokkaido | 3566 | 112 | 2690 | 764 | 43.385711 | 142.552318 | 2020-11-06 05:24:55 | Hokkaido, Japan | ||
2022-07-24 | Japan | Hokkaido | 420850 | 2115 | 0 | 43.385711 | 142.552318 | 2022-07-25 04:20:51 | Hokkaido, Japan | |||
2022-07-22 | Japan | Hokkaido | 412142 | 2110 | 0 | 43.385711 | 142.552318 | 2022-07-23 04:20:53 | Hokkaido, Japan | |||
2021-11-24 | Japan | Hokkaido | 61086 | 1472 | 0 | 43.385711 | 142.55231799999999 | 2021-11-25 04:22:33 | Hokkaido, Japan | |||
2021-01-19 | Japan | Hokkaido | 16031 | 546 | 13695 | 1790 | 43.385711 | 142.552318 | 2021-01-20 05:21:54 | Hokkaido, Japan | ||
2022-10-29 | Japan | Hokkaido | 830834 | 2721 | 0 | 43.385711 | 142.552318 | 2022-10-30 04:22:14 | Hokkaido, Japan | |||
2022-03-08 | Japan | Hokkaido | 186256 | 1829 | 0 | 43.385711 | 142.55231799999999 | 2022-03-09 04:20:59 | Hokkaido, Japan | |||
2020-11-26 | Japan | Hokkaido | 8021 | 171 | 5068 | 2782 | 43.385711 | 142.552318 | 2020-11-27 05:26:53 | Hokkaido, Japan | ||
2020-12-21 | Japan | Hokkaido | 12303 | 394 | 9930 | 1979 | 43.385711 | 142.552318 | 2020-12-22 05:22:33 | Hokkaido, Japan | ||
2021-10-16 | Japan | Hokkaido | 60570 | 1469 | 0 | 43.385711 | 142.55231799999999 | 2021-10-17 04:21:29 | Hokkaido, Japan | |||
2022-06-25 | Japan | Hokkaido | 379114 | 2094 | 0 | 43.385711 | 142.552318 | 2022-06-26 04:21:02 | Hokkaido, Japan | |||
2022-02-28 | Japan | Hokkaido | 172533 | 1757 | 0 | 43.385711 | 142.55231799999999 | 2022-03-01 04:21:09 | Hokkaido, Japan | |||
2022-06-14 | Japan | Hokkaido | 371416 | 2079 | 0 | 43.385711 | 142.552318 | 2022-06-15 04:20:54 | Hokkaido, Japan | |||
2022-03-12 | Japan | Hokkaido | 193611 | 1860 | 0 | 43.385711 | 142.55231799999999 | 2022-03-13 04:20:49 | Hokkaido, Japan | |||
2021-04-25 | Japan | Hokkaido | 23270 | 837 | 21072 | 1361 | 43.385711 | 142.552318 | 2021-04-26 04:21:04 | Hokkaido, Japan | ||
2022-07-19 | Japan | Hokkaido | 401653 | 2107 | 0 | 43.385711 | 142.552318 | 2022-07-20 04:20:59 | Hokkaido, Japan | |||
2022-09-09 | Japan | Hokkaido | 693294 | 2495 | 0 | 43.385711 | 142.552318 | 2022-09-10 04:21:10 | Hokkaido, Japan | |||
2020-09-29 | Japan | Hokkaido | 2091 | 107 | 1831 | 153 | 43.385711 | 142.552318 | 2020-09-30 04:23:33 | Hokkaido, Japan | ||
2022-06-01 | Japan | Hokkaido | 360009 | 2066 | 0 | 43.385711 | 142.552318 | 2022-06-02 05:20:39 | Hokkaido, Japan | |||
2021-02-06 | Japan | Hokkaido | 18011 | 619 | 16101 | 1291 | 43.385711 | 142.552318 | 2021-02-07 05:23:00 | Hokkaido, Japan | ||
2022-02-01 | Japan | Hokkaido | 94974 | 1502 | 0 | 43.385711 | 142.552318 | 2022-02-02 04:21:09 | Hokkaido, Japan | |||
2021-04-17 | Japan | Hokkaido | 22283 | 797 | 20466 | 1020 | 43.385711 | 142.552318 | 2021-04-18 04:20:41 | Hokkaido, Japan | ||
2021-10-04 | Japan | Hokkaido | 60309 | 1467 | 0 | 43.385711 | 142.55231799999999 | 2021-10-05 04:21:27 | Hokkaido, Japan | |||
2022-08-16 | Japan | Hokkaido | 557638 | 2264 | 0 | 43.385711 | 142.552318 | 2022-08-17 04:20:59 | Hokkaido, Japan | |||
2021-03-01 | Japan | Hokkaido | 19122 | 679 | 17867 | 576 | 43.385711 | 142.552318 | 2021-03-02 05:23:30 | Hokkaido, Japan | ||
2020-07-09 | Japan | Hokkaido | 1283 | 101 | 1106 | 76 | 43.385711 | 142.55231799999999 | 2020-07-10 04:34:24 | Hokkaido, Japan | ||
2020-12-06 | Japan | Hokkaido | 10036 | 256 | 7269 | 2511 | 43.385711 | 142.552318 | 2020-12-07 05:26:14 | Hokkaido, Japan | ||
2020-12-30 | Japan | Hokkaido | 13271 | 448 | 11106 | 1717 | 43.385711 | 142.552318 | 2020-12-31 05:22:49 | Hokkaido, Japan | ||
2021-11-21 | Japan | Hokkaido | 61056 | 1472 | 0 | 43.385711 | 142.55231799999999 | 2021-11-22 04:22:20 | Hokkaido, Japan | |||
2022-12-24 | Japan | Hokkaido | 1204173 | 3887 | 0 | 43.385711 | 142.552318 | 2022-12-25 04:21:04 | Hokkaido, Japan | |||
2022-11-04 | Japan | Hokkaido | 863595 | 2768 | 0 | 43.385711 | 142.552318 | 2022-11-05 04:21:52 | Hokkaido, Japan | |||
2020-10-17 | Japan | Hokkaido | 2518 | 108 | 2166 | 244 | 43.385711 | 142.552318 | 2020-10-18 04:24:25 | Hokkaido, Japan | ||
2021-12-06 | Japan | Hokkaido | 61177 | 1472 | 0 | 43.385711 | 142.55231799999999 | 2021-12-07 04:22:34 | Hokkaido, Japan | |||
2020-12-15 | Japan | Hokkaido | 11560 | 341 | 8887 | 2332 | 43.385711 | 142.552318 | 2020-12-16 05:28:04 | Hokkaido, Japan | ||
2020-10-07 | Japan | Hokkaido | 2267 | 107 | 1937 | 223 | 43.385711 | 142.552318 | 2020-10-08 04:23:56 | Hokkaido, Japan | ||
2020-09-30 | Japan | Hokkaido | 2107 | 107 | 1842 | 158 | 43.385711 | 142.552318 | 2020-10-01 04:23:42 | Hokkaido, Japan | ||
2022-11-06 | Japan | Hokkaido | 876485 | 2787 | 0 | 43.385711 | 142.552318 | 2022-11-07 04:21:26 | Hokkaido, Japan | |||
2020-10-23 | Japan | Hokkaido | 2703 | 108 | 2287 | 308 | 43.385711 | 142.552318 | 2020-10-24 04:24:46 | Hokkaido, Japan | ||
2022-02-23 | Japan | Hokkaido | 161447 | 1709 | 0 | 43.385711 | 142.55231799999999 | 2022-02-24 04:21:14 | Hokkaido, Japan | |||
2021-01-04 | Japan | Hokkaido | 13774 | 476 | 11521 | 1777 | 43.385711 | 142.552318 | 2021-01-05 05:21:49 | Hokkaido, Japan | ||
2022-07-28 | Japan | Hokkaido | 438677 | 2130 | 0 | 43.385711 | 142.552318 | 2022-07-29 04:20:45 | Hokkaido, Japan | |||
2022-08-07 | Japan | Hokkaido | 501385 | 2182 | 0 | 43.385711 | 142.552318 | 2022-08-08 04:21:08 | Hokkaido, Japan | |||
2022-12-28 | Japan | Hokkaido | 1221571 | 3982 | 0 | 43.385711 | 142.552318 | 2022-12-29 04:21:01 | Hokkaido, Japan | |||
2021-12-09 | Japan | Hokkaido | 61188 | 1473 | 0 | 43.385711 | 142.55231799999999 | 2021-12-10 04:22:28 | Hokkaido, Japan | |||
2021-05-14 | Japan | Hokkaido | 29345 | 927 | 23506 | 4912 | 43.385711 | 142.552318 | 2021-05-15 04:20:58 | Hokkaido, Japan | ||
2022-08-09 | Japan | Hokkaido | 512029 | 2206 | 0 | 43.385711 | 142.552318 | 2022-08-10 04:20:57 | Hokkaido, Japan | |||
2021-03-03 | Japan | Hokkaido | 19211 | 687 | 17944 | 580 | 43.385711 | 142.552318 | 2021-03-04 05:24:24 | Hokkaido, Japan | ||
2021-01-20 | Japan | Hokkaido | 16195 | 551 | 13866 | 1778 | 43.385711 | 142.552318 | 2021-01-21 05:22:01 | Hokkaido, Japan | ||
2022-08-03 | Japan | Hokkaido | 473768 | 2154 | 0 | 43.385711 | 142.552318 | 2022-08-04 04:20:58 | Hokkaido, Japan | |||
2020-09-02 | Japan | Hokkaido | 1803 | 104 | 1558 | 141 | 43.385711 | 142.552318 | 2020-09-03 04:28:22 | Hokkaido, Japan | ||
2022-05-21 | Japan | Hokkaido | 343646 | 2045 | 0 | 43.385711 | 142.552318 | 2022-05-22 04:20:52 | Hokkaido, Japan | |||
2022-01-11 | Japan | Hokkaido | 62250 | 1477 | 0 | 43.385711 | 142.55231799999999 | 2022-01-12 04:21:44 | Hokkaido, Japan | |||
2021-08-06 | Japan | Hokkaido | 46110 | 1427 | 0 | 43.385711 | 142.552318 | 2021-08-07 04:21:30 | Hokkaido, Japan | |||
2020-09-17 | Japan | Hokkaido | 1910 | 106 | 1724 | 80 | 43.385711 | 142.552318 | 2020-09-18 05:05:00 | Hokkaido, Japan | ||
2021-06-18 | Japan | Hokkaido | 40870 | 1334 | 36579 | 2957 | 43.385711 | 142.552318 | 2021-06-19 04:22:33 | Hokkaido, Japan | ||
2020-06-26 | Japan | Hokkaido | 1221 | 98 | 1028 | 95 | 43.385711 | 142.55231799999999 | 2020-06-27 04:33:35 | Hokkaido, Japan | ||
2021-01-01 | Japan | Hokkaido | 13536 | 456 | 11309 | 1771 | 43.385711 | 142.552318 | 2021-01-02 05:22:33 | Hokkaido, Japan | ||
2022-01-23 | Japan | Hokkaido | 73417 | 1479 | 0 | 43.385711 | 142.55231799999999 | 2022-01-24 04:21:12 | Hokkaido, Japan | |||
2021-12-01 | Japan | Hokkaido | 61153 | 1472 | 0 | 43.385711 | 142.55231799999999 | 2021-12-02 04:22:37 | Hokkaido, Japan | |||
2022-12-12 | Japan | Hokkaido | 1137355 | 3585 | 0 | 43.385711 | 142.552318 | 2022-12-13 04:21:01 | Hokkaido, Japan | |||
2021-02-18 | Japan | Hokkaido | 18674 | 647 | 17200 | 827 | 43.385711 | 142.552318 | 2021-02-19 05:24:16 | Hokkaido, Japan | ||
2022-04-29 | Japan | Hokkaido | 291038 | 1994 | 0 | 43.385711 | 142.552318 | 2022-04-30 04:21:05 | Hokkaido, Japan | |||
2022-08-18 | Japan | Hokkaido | 572833 | 2287 | 0 | 43.385711 | 142.552318 | 2022-08-19 04:20:54 | Hokkaido, Japan | |||
2021-07-04 | Japan | Hokkaido | 41466 | 1405 | 39316 | 745 | 43.385711 | 142.552318 | 2021-07-05 04:21:28 | Hokkaido, Japan | ||
2022-05-20 | Japan | Hokkaido | 341406 | 2044 | 0 | 43.385711 | 142.552318 | 2022-05-21 04:20:58 | Hokkaido, Japan | |||
2020-09-10 | Japan | Hokkaido | 1860 | 106 | 1659 | 95 | 43.385711 | 142.552318 | 2020-09-11 04:46:23 | Hokkaido, Japan | ||
2020-10-22 | Japan | Hokkaido | 2652 | 108 | 2266 | 278 | 43.385711 | 142.552318 | 2020-10-23 04:24:46 | Hokkaido, Japan | ||
2022-05-18 | Japan | Hokkaido | 336042 | 2041 | 0 | 43.385711 | 142.552318 | 2022-05-19 04:20:54 | Hokkaido, Japan | |||
2021-05-31 | Japan | Hokkaido | 37959 | 1112 | 28596 | 8251 | 43.385711 | 142.552318 | 2021-06-01 04:23:09 | Hokkaido, Japan | ||
2020-06-17 | Japan | Hokkaido | 1184 | 92 | 970 | 122 | 43.385711 | 142.55231799999999 | 2020-06-18 04:33:18 | Hokkaido, Japan | ||
2022-07-06 | Japan | Hokkaido | 385433 | 2097 | 0 | 43.385711 | 142.552318 | 2022-07-07 04:20:55 | Hokkaido, Japan | |||
2021-03-22 | Japan | Hokkaido | 20421 | 733 | 18916 | 772 | 43.385711 | 142.552318 | 2021-03-23 05:26:18 | Hokkaido, Japan | ||
2020-06-09 | Japan | Hokkaido | 1132 | 91 | 888 | 153 | 43.385711 | 142.552318 | 2020-06-10 04:07:00 | Hokkaido, Japan | ||
2022-07-11 | Japan | Hokkaido | 389593 | 2102 | 0 | 43.385711 | 142.552318 | 2022-07-12 04:20:51 | Hokkaido, Japan | |||
2022-01-08 | Japan | Hokkaido | 61910 | 1475 | 0 | 43.385711 | 142.55231799999999 | 2022-01-09 04:21:46 | Hokkaido, Japan | |||
2021-03-27 | Japan | Hokkaido | 20742 | 742 | 19171 | 829 | 43.385711 | 142.552318 | 2021-03-28 05:28:10 | Hokkaido, Japan | ||
2022-04-14 | Japan | Hokkaido | 252335 | 1958 | 0 | 43.385711 | 142.55231799999999 | 2022-04-15 04:20:57 | Hokkaido, Japan | |||
2022-01-24 | Japan | Hokkaido | 75006 | 1480 | 0 | 43.385711 | 142.55231799999999 | 2022-01-25 04:21:05 | Hokkaido, Japan | |||
2021-11-28 | Japan | Hokkaido | 61135 | 1472 | 0 | 43.385711 | 142.55231799999999 | 2021-11-29 04:22:30 | Hokkaido, Japan | |||
2021-09-27 | Japan | Hokkaido | 60141 | 1467 | 0 | 43.385711 | 142.55231799999999 | 2021-09-28 04:21:28 | Hokkaido, Japan | |||
2022-11-28 | Japan | Hokkaido | 1048329 | 3194 | 0 | 43.385711 | 142.552318 | 2022-11-29 04:21:05 | Hokkaido, Japan | |||
2020-09-08 | Japan | Hokkaido | 1845 | 105 | 1641 | 99 | 43.385711 | 142.552318 | 2020-09-09 04:28:48 | Hokkaido, Japan | ||
2022-08-23 | Japan | Hokkaido | 606399 | 2322 | 0 | 43.385711 | 142.552318 | 2022-08-24 04:20:46 | Hokkaido, Japan | |||
2021-12-20 | Japan | Hokkaido | 61265 | 1474 | 0 | 43.385711 | 142.55231799999999 | 2021-12-21 03:21:27 | Hokkaido, Japan | |||
2021-12-18 | Japan | Hokkaido | 61239 | 1474 | 0 | 43.385711 | 142.55231799999999 | 2021-12-19 04:21:11 | Hokkaido, Japan | |||
2021-09-09 | Japan | Hokkaido | 58749 | 1460 | 0 | 43.385711 | 142.55231799999999 | 2021-09-10 04:21:20 | Hokkaido, Japan | |||
2020-06-05 | Japan | Hokkaido | 1109 | 90 | 849 | 170 | 43.385711 | 142.552318 | 2020-06-06 02:33:00 | Hokkaido, Japan | ||
2020-06-11 | Japan | Hokkaido | 1144 | 91 | 906 | 147 | 43.385711 | 142.55231799999999 | 2020-06-12 05:09:52 | Hokkaido, Japan |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;