johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
946 rows where country_or_region = "Japan" and province_or_state = "Hokkaido" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2533393 | 2533393 | 2022-05-12 | Japan | Hokkaido | 321147 | 2013 | 0 | 43.385711 | 142.552318 | 2022-05-13 04:20:51 | Hokkaido, Japan | |||
3444839 | 3444839 | 2022-05-11 | Japan | Hokkaido | 317971 | 2012 | 0 | 43.385711 | 142.552318 | 2022-05-12 04:20:54 | Hokkaido, Japan | |||
3535456 | 3535456 | 2022-05-10 | Japan | Hokkaido | 314712 | 2011 | 0 | 43.385711 | 142.552318 | 2022-05-11 04:20:48 | Hokkaido, Japan | |||
221991 | 221991 | 2022-05-09 | Japan | Hokkaido | 312312 | 2009 | 0 | 43.385711 | 142.552318 | 2022-05-10 04:20:50 | Hokkaido, Japan | |||
2331376 | 2331376 | 2022-05-08 | Japan | Hokkaido | 309756 | 2003 | 0 | 43.385711 | 142.552318 | 2022-05-09 04:20:54 | Hokkaido, Japan | |||
360338 | 360338 | 2022-05-07 | Japan | Hokkaido | 306641 | 2001 | 0 | 43.385711 | 142.552318 | 2022-05-08 04:20:49 | Hokkaido, Japan | |||
1397689 | 1397689 | 2022-05-06 | Japan | Hokkaido | 304529 | 2001 | 0 | 43.385711 | 142.552318 | 2022-05-07 04:21:09 | Hokkaido, Japan | |||
2598044 | 2598044 | 2022-05-05 | Japan | Hokkaido | 302861 | 2000 | 0 | 43.385711 | 142.552318 | 2022-05-06 04:21:00 | Hokkaido, Japan | |||
3265493 | 3265493 | 2022-05-04 | Japan | Hokkaido | 301007 | 2000 | 0 | 43.385711 | 142.552318 | 2022-05-05 04:20:55 | Hokkaido, Japan | |||
1572132 | 1572132 | 2022-05-03 | Japan | Hokkaido | 298917 | 1999 | 0 | 43.385711 | 142.552318 | 2022-05-04 04:20:59 | Hokkaido, Japan | |||
463392 | 463392 | 2022-05-02 | Japan | Hokkaido | 297199 | 1997 | 0 | 43.385711 | 142.552318 | 2022-05-03 04:21:00 | Hokkaido, Japan | |||
3916031 | 3916031 | 2022-05-01 | Japan | Hokkaido | 295394 | 1994 | 0 | 43.385711 | 142.552318 | 2022-05-02 04:21:10 | Hokkaido, Japan | |||
2840835 | 2840835 | 2022-04-30 | Japan | Hokkaido | 293540 | 1994 | 0 | 43.385711 | 142.552318 | 2022-05-01 04:20:57 | Hokkaido, Japan | |||
1157148 | 1157148 | 2022-04-29 | Japan | Hokkaido | 291038 | 1994 | 0 | 43.385711 | 142.552318 | 2022-04-30 04:21:05 | Hokkaido, Japan | |||
1696330 | 1696330 | 2022-04-28 | Japan | Hokkaido | 288111 | 1993 | 0 | 43.385711 | 142.552318 | 2022-04-29 04:20:59 | Hokkaido, Japan | |||
3851813 | 3851813 | 2022-04-27 | Japan | Hokkaido | 284952 | 1991 | 0 | 43.385711 | 142.552318 | 2022-04-28 04:20:47 | Hokkaido, Japan | |||
1326243 | 1326243 | 2022-04-26 | Japan | Hokkaido | 281793 | 1989 | 0 | 43.385711 | 142.55231799999999 | 2022-04-27 04:20:52 | Hokkaido, Japan | |||
3722197 | 3722197 | 2022-04-25 | Japan | Hokkaido | 279661 | 1985 | 0 | 43.385711 | 142.55231799999999 | 2022-04-26 04:20:51 | Hokkaido, Japan | |||
2028765 | 2028765 | 2022-04-24 | Japan | Hokkaido | 277794 | 1983 | 0 | 43.385711 | 142.55231799999999 | 2022-04-25 04:20:56 | Hokkaido, Japan | |||
746340 | 746340 | 2022-04-23 | Japan | Hokkaido | 275161 | 1981 | 0 | 43.385711 | 142.55231799999999 | 2022-04-24 04:20:56 | Hokkaido, Japan | |||
3436825 | 3436825 | 2022-04-22 | Japan | Hokkaido | 272377 | 1979 | 0 | 43.385711 | 142.55231799999999 | 2022-04-23 04:20:50 | Hokkaido, Japan | |||
2892410 | 2892410 | 2022-04-21 | Japan | Hokkaido | 269532 | 1978 | 0 | 43.385711 | 142.55231799999999 | 2022-04-22 04:20:45 | Hokkaido, Japan | |||
2307282 | 2307282 | 2022-04-20 | Japan | Hokkaido | 266400 | 1974 | 0 | 43.385711 | 142.55231799999999 | 2022-04-21 04:20:46 | Hokkaido, Japan | |||
2251421 | 2251421 | 2022-04-19 | Japan | Hokkaido | 263342 | 1971 | 0 | 43.385711 | 142.55231799999999 | 2022-04-20 04:20:45 | Hokkaido, Japan | |||
1845971 | 1845971 | 2022-04-18 | Japan | Hokkaido | 261275 | 1970 | 0 | 43.385711 | 142.55231799999999 | 2022-04-19 04:21:00 | Hokkaido, Japan | |||
3416915 | 3416915 | 2022-04-17 | Japan | Hokkaido | 259509 | 1965 | 0 | 43.385711 | 142.55231799999999 | 2022-04-18 04:21:12 | Hokkaido, Japan | |||
303864 | 303864 | 2022-04-16 | Japan | Hokkaido | 257396 | 1964 | 0 | 43.385711 | 142.55231799999999 | 2022-04-17 04:20:59 | Hokkaido, Japan | |||
2669809 | 2669809 | 2022-04-15 | Japan | Hokkaido | 254940 | 1960 | 0 | 43.385711 | 142.55231799999999 | 2022-04-16 04:20:48 | Hokkaido, Japan | |||
1223594 | 1223594 | 2022-04-14 | Japan | Hokkaido | 252335 | 1958 | 0 | 43.385711 | 142.55231799999999 | 2022-04-15 04:20:57 | Hokkaido, Japan | |||
2442752 | 2442752 | 2022-04-13 | Japan | Hokkaido | 249567 | 1954 | 0 | 43.385711 | 142.55231799999999 | 2022-04-13 23:21:06 | Hokkaido, Japan | |||
1948509 | 1948509 | 2022-04-12 | Japan | Hokkaido | 246854 | 1954 | 0 | 43.385711 | 142.55231799999999 | 2022-04-13 04:21:03 | Hokkaido, Japan | |||
3206262 | 3206262 | 2022-04-11 | Japan | Hokkaido | 244950 | 1952 | 0 | 43.385711 | 142.55231799999999 | 2022-04-12 04:20:49 | Hokkaido, Japan | |||
1576148 | 1576148 | 2022-04-10 | Japan | Hokkaido | 243399 | 1948 | 0 | 43.385711 | 142.55231799999999 | 2022-04-11 04:21:02 | Hokkaido, Japan | |||
1652390 | 1652390 | 2022-04-09 | Japan | Hokkaido | 241254 | 1947 | 0 | 43.385711 | 142.55231799999999 | 2022-04-10 04:20:52 | Hokkaido, Japan | |||
2115712 | 2115712 | 2022-04-08 | Japan | Hokkaido | 238980 | 1946 | 0 | 43.385711 | 142.55231799999999 | 2022-04-09 04:20:42 | Hokkaido, Japan | |||
3320236 | 3320236 | 2022-04-07 | Japan | Hokkaido | 236764 | 1942 | 0 | 43.385711 | 142.55231799999999 | 2022-04-08 04:20:48 | Hokkaido, Japan | |||
2800772 | 2800772 | 2022-04-06 | Japan | Hokkaido | 234418 | 1941 | 0 | 43.385711 | 142.55231799999999 | 2022-04-07 04:20:53 | Hokkaido, Japan | |||
3867541 | 3867541 | 2022-04-05 | Japan | Hokkaido | 232048 | 1940 | 0 | 43.385711 | 142.55231799999999 | 2022-04-06 04:20:49 | Hokkaido, Japan | |||
2748883 | 2748883 | 2022-04-04 | Japan | Hokkaido | 230459 | 1937 | 0 | 43.385711 | 142.55231799999999 | 2022-04-05 04:20:48 | Hokkaido, Japan | |||
3730229 | 3730229 | 2022-04-03 | Japan | Hokkaido | 228882 | 1937 | 0 | 43.385711 | 142.55231799999999 | 2022-04-04 04:20:51 | Hokkaido, Japan | |||
499664 | 499664 | 2022-04-02 | Japan | Hokkaido | 227037 | 1935 | 0 | 43.385711 | 142.55231799999999 | 2022-04-03 04:20:48 | Hokkaido, Japan | |||
3350649 | 3350649 | 2022-04-01 | Japan | Hokkaido | 225052 | 1935 | 0 | 43.385711 | 142.55231799999999 | 2022-04-02 04:20:47 | Hokkaido, Japan | |||
1539954 | 1539954 | 2022-03-31 | Japan | Hokkaido | 223019 | 1932 | 0 | 43.385711 | 142.55231799999999 | 2022-04-01 04:20:28 | Hokkaido, Japan | |||
2477967 | 2477967 | 2022-03-30 | Japan | Hokkaido | 220913 | 1928 | 0 | 43.385711 | 142.55231799999999 | 2022-03-31 04:20:56 | Hokkaido, Japan | |||
158008 | 158008 | 2022-03-29 | Japan | Hokkaido | 218934 | 1924 | 0 | 43.385711 | 142.55231799999999 | 2022-03-30 04:20:45 | Hokkaido, Japan | |||
1436579 | 1436579 | 2022-03-28 | Japan | Hokkaido | 217567 | 1919 | 0 | 43.385711 | 142.55231799999999 | 2022-03-29 04:20:46 | Hokkaido, Japan | |||
876260 | 876260 | 2022-03-27 | Japan | Hokkaido | 216368 | 1918 | 0 | 43.385711 | 142.55231799999999 | 2022-03-28 04:20:33 | Hokkaido, Japan | |||
2163543 | 2163543 | 2022-03-26 | Japan | Hokkaido | 214871 | 1917 | 0 | 43.385711 | 142.55231799999999 | 2022-03-27 04:20:47 | Hokkaido, Japan | |||
1720479 | 1720479 | 2022-03-25 | Japan | Hokkaido | 213170 | 1915 | 0 | 43.385711 | 142.55231799999999 | 2022-03-26 04:20:23 | Hokkaido, Japan | |||
1468096 | 1468096 | 2022-03-24 | Japan | Hokkaido | 211032 | 1911 | 0 | 43.385711 | 142.55231799999999 | 2022-03-25 04:20:46 | Hokkaido, Japan | |||
3022270 | 3022270 | 2022-03-23 | Japan | Hokkaido | 208984 | 1905 | 0 | 43.385711 | 142.55231799999999 | 2022-03-24 04:20:43 | Hokkaido, Japan | |||
1905192 | 1905192 | 2022-03-22 | Japan | Hokkaido | 207760 | 1904 | 0 | 43.385711 | 142.55231799999999 | 2022-03-23 04:20:48 | Hokkaido, Japan | |||
3238323 | 3238323 | 2022-03-21 | Japan | Hokkaido | 206875 | 1900 | 0 | 43.385711 | 142.55231799999999 | 2022-03-22 04:20:54 | Hokkaido, Japan | |||
24396 | 24396 | 2022-03-20 | Japan | Hokkaido | 205866 | 1898 | 0 | 43.385711 | 142.55231799999999 | 2022-03-21 04:20:50 | Hokkaido, Japan | |||
1656406 | 1656406 | 2022-03-19 | Japan | Hokkaido | 204347 | 1894 | 0 | 43.385711 | 142.55231799999999 | 2022-03-20 04:20:45 | Hokkaido, Japan | |||
335932 | 335932 | 2022-03-18 | Japan | Hokkaido | 202761 | 1892 | 0 | 43.385711 | 142.55231799999999 | 2022-03-19 04:20:47 | Hokkaido, Japan | |||
694385 | 694385 | 2022-03-17 | Japan | Hokkaido | 201047 | 1890 | 0 | 43.385711 | 142.55231799999999 | 2022-03-18 04:20:55 | Hokkaido, Japan | |||
2319328 | 2319328 | 2022-03-16 | Japan | Hokkaido | 199223 | 1883 | 0 | 43.385711 | 142.55231799999999 | 2022-03-17 04:20:56 | Hokkaido, Japan | |||
261528 | 261528 | 2022-03-15 | Japan | Hokkaido | 197290 | 1878 | 0 | 43.385711 | 142.55231799999999 | 2022-03-16 04:20:50 | Hokkaido, Japan | |||
2263887 | 2263887 | 2022-03-14 | Japan | Hokkaido | 196094 | 1868 | 0 | 43.385711 | 142.55231799999999 | 2022-03-15 04:20:47 | Hokkaido, Japan | |||
3627953 | 3627953 | 2022-03-13 | Japan | Hokkaido | 195052 | 1863 | 0 | 43.385711 | 142.55231799999999 | 2022-03-14 04:20:46 | Hokkaido, Japan | |||
950861 | 950861 | 2022-03-12 | Japan | Hokkaido | 193611 | 1860 | 0 | 43.385711 | 142.55231799999999 | 2022-03-13 04:20:49 | Hokkaido, Japan | |||
356322 | 356322 | 2022-03-11 | Japan | Hokkaido | 191910 | 1851 | 0 | 43.385711 | 142.55231799999999 | 2022-03-12 04:20:50 | Hokkaido, Japan | |||
1865474 | 1865474 | 2022-03-10 | Japan | Hokkaido | 190266 | 1844 | 0 | 43.385711 | 142.55231799999999 | 2022-03-11 04:20:50 | Hokkaido, Japan | |||
2140169 | 2140169 | 2022-03-09 | Japan | Hokkaido | 188241 | 1837 | 0 | 43.385711 | 142.55231799999999 | 2022-03-10 04:20:48 | Hokkaido, Japan | |||
919680 | 919680 | 2022-03-08 | Japan | Hokkaido | 186256 | 1829 | 0 | 43.385711 | 142.55231799999999 | 2022-03-09 04:20:59 | Hokkaido, Japan | |||
1547967 | 1547967 | 2022-03-07 | Japan | Hokkaido | 184928 | 1820 | 0 | 43.385711 | 142.55231799999999 | 2022-03-08 04:20:54 | Hokkaido, Japan | |||
2199636 | 2199636 | 2022-03-06 | Japan | Hokkaido | 183822 | 1814 | 0 | 43.385711 | 142.55231799999999 | 2022-03-07 04:20:47 | Hokkaido, Japan | |||
2092093 | 2092093 | 2022-03-05 | Japan | Hokkaido | 182018 | 1807 | 0 | 43.385711 | 142.55231799999999 | 2022-03-06 04:20:49 | Hokkaido, Japan | |||
2665793 | 2665793 | 2022-03-04 | Japan | Hokkaido | 180391 | 1799 | 0 | 43.385711 | 142.55231799999999 | 2022-03-05 04:21:10 | Hokkaido, Japan | |||
1644358 | 1644358 | 2022-03-03 | Japan | Hokkaido | 178550 | 1790 | 0 | 43.385711 | 142.55231799999999 | 2022-03-04 04:21:09 | Hokkaido, Japan | |||
2525361 | 2525361 | 2022-03-02 | Japan | Hokkaido | 176245 | 1780 | 0 | 43.385711 | 142.55231799999999 | 2022-03-03 04:21:01 | Hokkaido, Japan | |||
1992655 | 1992655 | 2022-03-01 | Japan | Hokkaido | 174013 | 1772 | 0 | 43.385711 | 142.55231799999999 | 2022-03-02 04:21:07 | Hokkaido, Japan | |||
942829 | 942829 | 2022-02-28 | Japan | Hokkaido | 172533 | 1757 | 0 | 43.385711 | 142.55231799999999 | 2022-03-01 04:21:09 | Hokkaido, Japan | |||
2733020 | 2733020 | 2022-02-27 | Japan | Hokkaido | 170928 | 1746 | 0 | 43.385711 | 142.55231799999999 | 2022-02-28 04:21:05 | Hokkaido, Japan | |||
3046173 | 3046173 | 2022-02-26 | Japan | Hokkaido | 168465 | 1744 | 0 | 43.385711 | 142.55231799999999 | 2022-02-27 04:21:04 | Hokkaido, Japan | |||
574828 | 574828 | 2022-02-25 | Japan | Hokkaido | 165998 | 1734 | 0 | 43.385711 | 142.55231799999999 | 2022-02-26 04:21:12 | Hokkaido, Japan | |||
1511404 | 1511404 | 2022-02-24 | Japan | Hokkaido | 164068 | 1722 | 0 | 43.385711 | 142.55231799999999 | 2022-02-25 04:21:11 | Hokkaido, Japan | |||
1057845 | 1057845 | 2022-02-23 | Japan | Hokkaido | 161447 | 1709 | 0 | 43.385711 | 142.55231799999999 | 2022-02-24 04:21:14 | Hokkaido, Japan | |||
2446768 | 2446768 | 2022-02-22 | Japan | Hokkaido | 159054 | 1695 | 0 | 43.385711 | 142.55231799999999 | 2022-02-23 04:21:09 | Hokkaido, Japan | |||
3718181 | 3718181 | 2022-02-21 | Japan | Hokkaido | 157013 | 1681 | 0 | 43.385711 | 142.55231799999999 | 2022-02-22 04:21:01 | Hokkaido, Japan | |||
3912015 | 3912015 | 2022-02-20 | Japan | Hokkaido | 155090 | 1670 | 0 | 43.385711 | 142.55231799999999 | 2022-02-21 04:21:05 | Hokkaido, Japan | |||
3875573 | 3875573 | 2022-02-19 | Japan | Hokkaido | 152756 | 1659 | 0 | 43.385711 | 142.55231799999999 | 2022-02-20 04:21:00 | Hokkaido, Japan | |||
3855829 | 3855829 | 2022-02-18 | Japan | Hokkaido | 149959 | 1650 | 0 | 43.385711 | 142.55231799999999 | 2022-02-19 04:21:11 | Hokkaido, Japan | |||
1298048 | 1298048 | 2022-02-17 | Japan | Hokkaido | 147303 | 1643 | 0 | 43.385711 | 142.55231799999999 | 2022-02-18 04:21:04 | Hokkaido, Japan | |||
3820434 | 3820434 | 2022-02-16 | Japan | Hokkaido | 143675 | 1631 | 0 | 43.385711 | 142.55231799999999 | 2022-02-17 04:20:56 | Hokkaido, Japan | |||
3671648 | 3671648 | 2022-02-15 | Japan | Hokkaido | 140861 | 1617 | 0 | 43.385711 | 142.55231799999999 | 2022-02-16 04:21:10 | Hokkaido, Japan | |||
2641749 | 2641749 | 2022-02-14 | Japan | Hokkaido | 138579 | 1612 | 0 | 43.385711 | 142.55231799999999 | 2022-02-15 04:21:09 | Hokkaido, Japan | |||
186066 | 186066 | 2022-02-13 | Japan | Hokkaido | 136327 | 1595 | 0 | 43.385711 | 142.55231799999999 | 2022-02-14 04:20:51 | Hokkaido, Japan | |||
315912 | 315912 | 2022-02-12 | Japan | Hokkaido | 133635 | 1590 | 0 | 43.385711 | 142.55231799999999 | 2022-02-13 04:21:00 | Hokkaido, Japan | |||
233238 | 233238 | 2022-02-11 | Japan | Hokkaido | 130355 | 1580 | 0 | 43.385711 | 142.55231799999999 | 2022-02-12 04:21:06 | Hokkaido, Japan | |||
1464080 | 1464080 | 2022-02-10 | Japan | Hokkaido | 126672 | 1569 | 0 | 43.385711 | 142.55231799999999 | 2022-02-11 04:21:09 | Hokkaido, Japan | |||
3074041 | 3074041 | 2022-02-09 | Japan | Hokkaido | 122574 | 1560 | 0 | 43.385711 | 142.55231799999999 | 2022-02-10 04:21:14 | Hokkaido, Japan | |||
1362348 | 1362348 | 2022-02-08 | Japan | Hokkaido | 118968 | 1548 | 0 | 43.385711 | 142.55231799999999 | 2022-02-09 04:21:04 | Hokkaido, Japan | |||
71086 | 71086 | 2022-02-07 | Japan | Hokkaido | 116089 | 1541 | 0 | 43.385711 | 142.55231799999999 | 2022-02-08 04:21:15 | Hokkaido, Japan | |||
2012702 | 2012702 | 2022-02-06 | Japan | Hokkaido | 113402 | 1532 | 0 | 43.385711 | 142.55231799999999 | 2022-02-07 04:21:05 | Hokkaido, Japan | |||
1294031 | 1294031 | 2022-02-05 | Japan | Hokkaido | 109938 | 1527 | 0 | 43.385711 | 142.55231799999999 | 2022-02-06 04:21:00 | Hokkaido, Japan | |||
2327359 | 2327359 | 2022-02-04 | Japan | Hokkaido | 105892 | 1522 | 0 | 43.385711 | 142.55231799999999 | 2022-02-05 04:21:05 | Hokkaido, Japan | |||
2473950 | 2473950 | 2022-02-03 | Japan | Hokkaido | 102349 | 1506 | 0 | 43.385711 | 142.55231799999999 | 2022-02-04 04:21:10 | Hokkaido, Japan | |||
459375 | 459375 | 2022-02-02 | Japan | Hokkaido | 98561 | 1504 | 0 | 43.385711 | 142.55231799999999 | 2022-02-03 04:21:21 | Hokkaido, 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]);