daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
946 rows where province_or_state = "Hokkaido" sorted by longitude
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, recovered, longitude, last_update, day (date), last_update (date)
day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude ▼ | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-12-02 | Japan | Hokkaido | 61157 | 1472 | 0 | 43.385711 | 142.55231799999999 | 2021-12-03 04:23:05 | Hokkaido, Japan | |||
2021-10-28 | Japan | Hokkaido | 60722 | 1470 | 0 | 43.385711 | 142.55231799999999 | 2021-10-29 04:22:03 | Hokkaido, Japan | |||
2021-09-18 | Japan | Hokkaido | 59649 | 1465 | 0 | 43.385711 | 142.55231799999999 | 2021-09-19 04:21:34 | Hokkaido, Japan | |||
2022-03-20 | Japan | Hokkaido | 205866 | 1898 | 0 | 43.385711 | 142.55231799999999 | 2022-03-21 04:20:50 | Hokkaido, Japan | |||
2021-11-11 | Japan | Hokkaido | 60854 | 1472 | 0 | 43.385711 | 142.55231799999999 | 2021-11-12 04:22:01 | Hokkaido, Japan | |||
2021-08-25 | Japan | Hokkaido | 54534 | 1437 | 0 | 43.385711 | 142.55231799999999 | 2021-08-26 04:21:28 | Hokkaido, Japan | |||
2021-11-02 | Japan | Hokkaido | 60766 | 1471 | 0 | 43.385711 | 142.55231799999999 | 2021-11-03 06:22:09 | Hokkaido, Japan | |||
2021-09-01 | Japan | Hokkaido | 57158 | 1452 | 0 | 43.385711 | 142.55231799999999 | 2021-09-02 04:21:15 | Hokkaido, Japan | |||
2022-02-07 | Japan | Hokkaido | 116089 | 1541 | 0 | 43.385711 | 142.55231799999999 | 2022-02-08 04:21:15 | Hokkaido, Japan | |||
2021-11-09 | Japan | Hokkaido | 60838 | 1472 | 0 | 43.385711 | 142.55231799999999 | 2021-11-10 04:21:38 | Hokkaido, Japan | |||
2022-01-14 | Japan | Hokkaido | 63242 | 1477 | 0 | 43.385711 | 142.55231799999999 | 2022-01-15 04:21:07 | Hokkaido, Japan | |||
2021-08-15 | Japan | Hokkaido | 49552 | 1430 | 0 | 43.385711 | 142.55231799999999 | 2021-08-16 04:21:31 | Hokkaido, Japan | |||
2020-07-19 | Japan | Hokkaido | 1348 | 102 | 1141 | 105 | 43.385711 | 142.55231799999999 | 2020-07-20 05:34:40 | Hokkaido, Japan | ||
2022-01-09 | Japan | Hokkaido | 62027 | 1475 | 0 | 43.385711 | 142.55231799999999 | 2022-01-10 04:22:07 | Hokkaido, Japan | |||
2021-12-04 | Japan | Hokkaido | 61170 | 1472 | 0 | 43.385711 | 142.55231799999999 | 2021-12-05 04:22:25 | Hokkaido, Japan | |||
2021-11-29 | Japan | Hokkaido | 61141 | 1472 | 0 | 43.385711 | 142.55231799999999 | 2021-11-30 04:22:53 | Hokkaido, Japan | |||
2022-03-29 | Japan | Hokkaido | 218934 | 1924 | 0 | 43.385711 | 142.55231799999999 | 2022-03-30 04:20:45 | Hokkaido, Japan | |||
2021-11-19 | Japan | Hokkaido | 61019 | 1472 | 0 | 43.385711 | 142.55231799999999 | 2021-11-20 04:22:17 | Hokkaido, Japan | |||
2021-09-02 | Japan | Hokkaido | 57472 | 1453 | 0 | 43.385711 | 142.55231799999999 | 2021-09-03 04:21:20 | Hokkaido, Japan | |||
2022-02-13 | Japan | Hokkaido | 136327 | 1595 | 0 | 43.385711 | 142.55231799999999 | 2022-02-14 04:20:51 | Hokkaido, Japan | |||
2022-02-11 | Japan | Hokkaido | 130355 | 1580 | 0 | 43.385711 | 142.55231799999999 | 2022-02-12 04:21:06 | Hokkaido, Japan | |||
2021-08-17 | Japan | Hokkaido | 50319 | 1433 | 0 | 43.385711 | 142.55231799999999 | 2021-08-18 04:21:35 | Hokkaido, Japan | |||
2021-09-04 | Japan | Hokkaido | 57947 | 1456 | 0 | 43.385711 | 142.55231799999999 | 2021-09-05 04:21:33 | Hokkaido, Japan | |||
2022-03-15 | Japan | Hokkaido | 197290 | 1878 | 0 | 43.385711 | 142.55231799999999 | 2022-03-16 04:20:50 | Hokkaido, Japan | |||
2021-11-03 | Japan | Hokkaido | 60779 | 1471 | 0 | 43.385711 | 142.55231799999999 | 2021-11-04 04:22:20 | Hokkaido, Japan | |||
2020-06-15 | Japan | Hokkaido | 1176 | 91 | 956 | 129 | 43.385711 | 142.55231799999999 | 2020-06-16 04:33:09 | Hokkaido, Japan | ||
2021-10-31 | Japan | Hokkaido | 60749 | 1471 | 0 | 43.385711 | 142.55231799999999 | 2021-11-01 04:22:01 | Hokkaido, Japan | |||
2020-07-01 | Japan | Hokkaido | 1267 | 100 | 1054 | 113 | 43.385711 | 142.55231799999999 | 2020-07-02 04:33:46 | Hokkaido, Japan | ||
2022-04-16 | Japan | Hokkaido | 257396 | 1964 | 0 | 43.385711 | 142.55231799999999 | 2022-04-17 04:20:59 | Hokkaido, Japan | |||
2022-02-12 | Japan | Hokkaido | 133635 | 1590 | 0 | 43.385711 | 142.55231799999999 | 2022-02-13 04:21:00 | Hokkaido, Japan | |||
2020-07-20 | Japan | Hokkaido | 1351 | 102 | 1156 | 93 | 43.385711 | 142.55231799999999 | 2020-07-21 04:38:46 | Hokkaido, Japan | ||
2022-03-18 | Japan | Hokkaido | 202761 | 1892 | 0 | 43.385711 | 142.55231799999999 | 2022-03-19 04:20:47 | Hokkaido, Japan | |||
2022-03-11 | Japan | Hokkaido | 191910 | 1851 | 0 | 43.385711 | 142.55231799999999 | 2022-03-12 04:20:50 | Hokkaido, Japan | |||
2021-12-07 | Japan | Hokkaido | 61179 | 1472 | 0 | 43.385711 | 142.55231799999999 | 2021-12-08 04:22:46 | Hokkaido, Japan | |||
2020-07-05 | Japan | Hokkaido | 1277 | 101 | 1077 | 99 | 43.385711 | 142.55231799999999 | 2020-07-06 04:33:57 | Hokkaido, Japan | ||
2021-10-10 | Japan | Hokkaido | 60421 | 1469 | 0 | 43.385711 | 142.55231799999999 | 2021-10-11 04:21:31 | 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-02-02 | Japan | Hokkaido | 98561 | 1504 | 0 | 43.385711 | 142.55231799999999 | 2022-02-03 04:21:21 | Hokkaido, Japan | |||
2021-10-07 | Japan | Hokkaido | 60359 | 1469 | 0 | 43.385711 | 142.55231799999999 | 2021-10-08 04:21:25 | 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 | |||
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 | |||
2020-07-04 | Japan | Hokkaido | 1276 | 101 | 1077 | 98 | 43.385711 | 142.55231799999999 | 2020-07-05 04:33:46 | Hokkaido, Japan | ||
2021-10-27 | Japan | Hokkaido | 60717 | 1470 | 0 | 43.385711 | 142.55231799999999 | 2021-10-28 04:22:08 | 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 | |||
2021-10-29 | Japan | Hokkaido | 60730 | 1470 | 0 | 43.385711 | 142.55231799999999 | 2021-10-30 04:22:03 | Hokkaido, Japan | |||
2022-02-25 | Japan | Hokkaido | 165998 | 1734 | 0 | 43.385711 | 142.55231799999999 | 2022-02-26 04:21:12 | 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-10-13 | Japan | Hokkaido | 60474 | 1469 | 0 | 43.385711 | 142.55231799999999 | 2021-10-14 04:21:29 | Hokkaido, Japan | |||
2021-09-07 | Japan | Hokkaido | 58425 | 1460 | 0 | 43.385711 | 142.55231799999999 | 2021-09-08 04:21:31 | 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 | |||
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-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-09-29 | Japan | Hokkaido | 60212 | 1467 | 0 | 43.385711 | 142.55231799999999 | 2021-09-30 04:21:20 | Hokkaido, Japan | |||
2021-11-12 | Japan | Hokkaido | 60876 | 1472 | 0 | 43.385711 | 142.55231799999999 | 2021-11-13 04:21:38 | Hokkaido, Japan | |||
2021-11-20 | Japan | Hokkaido | 61031 | 1472 | 0 | 43.385711 | 142.55231799999999 | 2021-11-21 04:22:13 | 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 | ||
2022-04-23 | Japan | Hokkaido | 275161 | 1981 | 0 | 43.385711 | 142.55231799999999 | 2022-04-24 04:20:56 | Hokkaido, Japan | |||
2021-11-26 | Japan | Hokkaido | 61116 | 1472 | 0 | 43.385711 | 142.55231799999999 | 2021-11-27 04:22:45 | Hokkaido, Japan | |||
2021-10-23 | Japan | Hokkaido | 60676 | 1470 | 0 | 43.385711 | 142.55231799999999 | 2021-10-24 04:21:22 | Hokkaido, Japan | |||
2021-12-13 | Japan | Hokkaido | 61200 | 1474 | 0 | 43.385711 | 142.55231799999999 | 2021-12-14 04:22:38 | 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 | |||
2022-03-27 | Japan | Hokkaido | 216368 | 1918 | 0 | 43.385711 | 142.55231799999999 | 2022-03-28 04:20:33 | Hokkaido, Japan | |||
2020-07-07 | Japan | Hokkaido | 1278 | 101 | 1093 | 84 | 43.385711 | 142.55231799999999 | 2020-07-08 05:33:48 | Hokkaido, Japan | ||
2021-11-24 | Japan | Hokkaido | 61086 | 1472 | 0 | 43.385711 | 142.55231799999999 | 2021-11-25 04:22:33 | Hokkaido, Japan | |||
2022-03-08 | Japan | Hokkaido | 186256 | 1829 | 0 | 43.385711 | 142.55231799999999 | 2022-03-09 04:20:59 | Hokkaido, Japan | |||
2021-10-16 | Japan | Hokkaido | 60570 | 1469 | 0 | 43.385711 | 142.55231799999999 | 2021-10-17 04:21:29 | Hokkaido, Japan | |||
2022-02-28 | Japan | Hokkaido | 172533 | 1757 | 0 | 43.385711 | 142.55231799999999 | 2022-03-01 04:21:09 | Hokkaido, Japan | |||
2022-03-12 | Japan | Hokkaido | 193611 | 1860 | 0 | 43.385711 | 142.55231799999999 | 2022-03-13 04:20:49 | Hokkaido, Japan | |||
2021-10-04 | Japan | Hokkaido | 60309 | 1467 | 0 | 43.385711 | 142.55231799999999 | 2021-10-05 04:21:27 | Hokkaido, Japan | |||
2020-07-09 | Japan | Hokkaido | 1283 | 101 | 1106 | 76 | 43.385711 | 142.55231799999999 | 2020-07-10 04:34:24 | Hokkaido, Japan | ||
2021-11-21 | Japan | Hokkaido | 61056 | 1472 | 0 | 43.385711 | 142.55231799999999 | 2021-11-22 04:22:20 | Hokkaido, Japan | |||
2021-12-06 | Japan | Hokkaido | 61177 | 1472 | 0 | 43.385711 | 142.55231799999999 | 2021-12-07 04:22:34 | Hokkaido, Japan | |||
2022-02-23 | Japan | Hokkaido | 161447 | 1709 | 0 | 43.385711 | 142.55231799999999 | 2022-02-24 04:21:14 | Hokkaido, Japan | |||
2021-12-09 | Japan | Hokkaido | 61188 | 1473 | 0 | 43.385711 | 142.55231799999999 | 2021-12-10 04:22:28 | Hokkaido, Japan | |||
2022-01-11 | Japan | Hokkaido | 62250 | 1477 | 0 | 43.385711 | 142.55231799999999 | 2022-01-12 04:21:44 | Hokkaido, Japan | |||
2020-06-26 | Japan | Hokkaido | 1221 | 98 | 1028 | 95 | 43.385711 | 142.55231799999999 | 2020-06-27 04:33:35 | 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 | |||
2020-06-17 | Japan | Hokkaido | 1184 | 92 | 970 | 122 | 43.385711 | 142.55231799999999 | 2020-06-18 04:33:18 | Hokkaido, Japan | ||
2022-01-08 | Japan | Hokkaido | 61910 | 1475 | 0 | 43.385711 | 142.55231799999999 | 2022-01-09 04:21:46 | 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 | |||
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-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;