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 active
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: 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 | |||
2022-11-12 | Japan | Hokkaido | 923809 | 2872 | 0 | 43.385711 | 142.552318 | 2022-11-13 04:21:14 | 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-07-23 | Japan | Hokkaido | 416778 | 2113 | 0 | 43.385711 | 142.552318 | 2022-07-24 04:20:47 | 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 | |||
2022-09-06 | Japan | Hokkaido | 678332 | 2471 | 0 | 43.385711 | 142.552318 | 2022-09-07 04:20:59 | Hokkaido, Japan | |||
2022-01-09 | Japan | Hokkaido | 62027 | 1475 | 0 | 43.385711 | 142.55231799999999 | 2022-01-10 04:22:07 | Hokkaido, Japan | |||
2022-10-04 | Japan | Hokkaido | 755093 | 2599 | 0 | 43.385711 | 142.552318 | 2022-10-05 04:23:06 | Hokkaido, Japan | |||
2021-12-04 | Japan | Hokkaido | 61170 | 1472 | 0 | 43.385711 | 142.55231799999999 | 2021-12-05 04:22:25 | Hokkaido, Japan | |||
2022-07-09 | Japan | Hokkaido | 388132 | 2101 | 0 | 43.385711 | 142.552318 | 2022-07-10 04:20:54 | 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 | |||
2022-06-21 | Japan | Hokkaido | 376380 | 2090 | 0 | 43.385711 | 142.552318 | 2022-06-22 04:20:54 | 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-10-19 | Japan | Hokkaido | 791542 | 2668 | 0 | 43.385711 | 142.552318 | 2022-10-20 04:22:59 | Hokkaido, Japan | |||
2022-12-26 | Japan | Hokkaido | 1209679 | 3932 | 0 | 43.385711 | 142.552318 | 2022-12-27 04:21:07 | Hokkaido, Japan | |||
2022-05-09 | Japan | Hokkaido | 312312 | 2009 | 0 | 43.385711 | 142.552318 | 2022-05-10 04:20:50 | Hokkaido, Japan | |||
2022-05-31 | Japan | Hokkaido | 358769 | 2064 | 0 | 43.385711 | 142.552318 | 2022-06-01 04:20:55 | 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-09-08 | Japan | Hokkaido | 688844 | 2492 | 0 | 43.385711 | 142.552318 | 2022-09-09 04:21:11 | Hokkaido, Japan | |||
2022-12-10 | Japan | Hokkaido | 1131003 | 3558 | 0 | 43.385711 | 142.552318 | 2022-12-11 04:20:50 | 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 | |||
2021-10-31 | Japan | Hokkaido | 60749 | 1471 | 0 | 43.385711 | 142.55231799999999 | 2021-11-01 04:22:01 | Hokkaido, Japan | |||
2022-11-15 | Japan | Hokkaido | 944512 | 2904 | 0 | 43.385711 | 142.552318 | 2022-11-16 04:21:09 | Hokkaido, Japan | |||
2022-04-16 | Japan | Hokkaido | 257396 | 1964 | 0 | 43.385711 | 142.55231799999999 | 2022-04-17 04:20:59 | Hokkaido, Japan | |||
2022-12-13 | Japan | Hokkaido | 1145262 | 3616 | 0 | 43.385711 | 142.552318 | 2022-12-14 04:21:04 | Hokkaido, Japan | |||
2022-11-13 | Japan | Hokkaido | 929467 | 2885 | 0 | 43.385711 | 142.552318 | 2022-11-14 04:21:09 | Hokkaido, Japan | |||
2022-02-12 | Japan | Hokkaido | 133635 | 1590 | 0 | 43.385711 | 142.55231799999999 | 2022-02-13 04:21:00 | Hokkaido, Japan | |||
2022-10-30 | Japan | Hokkaido | 834492 | 2728 | 0 | 43.385711 | 142.552318 | 2022-10-31 04:21:36 | Hokkaido, Japan | |||
2022-12-27 | Japan | Hokkaido | 1215529 | 3944 | 0 | 43.385711 | 142.552318 | 2022-12-28 04:21:04 | Hokkaido, Japan | |||
2022-03-18 | Japan | Hokkaido | 202761 | 1892 | 0 | 43.385711 | 142.55231799999999 | 2022-03-19 04:20:47 | Hokkaido, Japan | |||
2022-12-14 | Japan | Hokkaido | 1152476 | 3658 | 0 | 43.385711 | 142.552318 | 2022-12-15 04:20:58 | Hokkaido, Japan | |||
2022-03-11 | Japan | Hokkaido | 191910 | 1851 | 0 | 43.385711 | 142.55231799999999 | 2022-03-12 04:20:50 | Hokkaido, Japan | |||
2022-05-07 | Japan | Hokkaido | 306641 | 2001 | 0 | 43.385711 | 142.552318 | 2022-05-08 04:20:49 | Hokkaido, Japan | |||
2022-09-13 | Japan | Hokkaido | 704854 | 2518 | 0 | 43.385711 | 142.552318 | 2022-09-14 04:20:44 | Hokkaido, Japan | |||
2022-09-23 | Japan | Hokkaido | 731371 | 2569 | 0 | 43.385711 | 142.552318 | 2022-09-24 04:21:40 | Hokkaido, Japan | |||
2022-10-07 | Japan | Hokkaido | 761617 | 2612 | 0 | 43.385711 | 142.552318 | 2022-10-08 04:22:56 | Hokkaido, Japan | |||
2021-12-07 | Japan | Hokkaido | 61179 | 1472 | 0 | 43.385711 | 142.55231799999999 | 2021-12-08 04:22:46 | Hokkaido, Japan | |||
2022-09-18 | Japan | Hokkaido | 719799 | 2536 | 0 | 43.385711 | 142.552318 | 2022-09-19 04:21:49 | Hokkaido, Japan | |||
2021-10-10 | Japan | Hokkaido | 60421 | 1469 | 0 | 43.385711 | 142.55231799999999 | 2021-10-11 04:21:31 | Hokkaido, Japan | |||
2022-11-03 | Japan | Hokkaido | 859767 | 2763 | 0 | 43.385711 | 142.552318 | 2022-11-04 04:22:11 | 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 | |||
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 | |||
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 | |||
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-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 | |||
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-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-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 | |||
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 | |||
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-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 | |||
2022-05-13 | Japan | Hokkaido | 324181 | 2018 | 0 | 43.385711 | 142.552318 | 2022-05-14 04:20:48 | 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 | |||
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-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 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;