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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2016719 | 2016719 | 2022-09-20 | Japan | Hokkaido | 722826 | 2548 | 0 | 43.385711 | 142.552318 | 2022-09-21 04:23:22 | Hokkaido, Japan | |||
3570592 | 3570592 | 2022-09-19 | Japan | Hokkaido | 721462 | 2541 | 0 | 43.385711 | 142.552318 | 2022-09-20 04:22:48 | Hokkaido, Japan | |||
419331 | 419331 | 2022-09-18 | Japan | Hokkaido | 719799 | 2536 | 0 | 43.385711 | 142.552318 | 2022-09-19 04:21:49 | Hokkaido, Japan | |||
3373355 | 3373355 | 2022-09-17 | Japan | Hokkaido | 717614 | 2535 | 0 | 43.385711 | 142.552318 | 2022-09-18 04:22:50 | Hokkaido, Japan | |||
2355463 | 2355463 | 2022-09-16 | Japan | Hokkaido | 715042 | 2529 | 0 | 43.385711 | 142.552318 | 2022-09-17 04:20:19 | Hokkaido, Japan | |||
3986620 | 3986620 | 2022-09-15 | Japan | Hokkaido | 712046 | 2524 | 0 | 43.385711 | 142.552318 | 2022-09-16 04:21:19 | Hokkaido, Japan | |||
1889137 | 1889137 | 2022-09-14 | Japan | Hokkaido | 708575 | 2523 | 0 | 43.385711 | 142.552318 | 2022-09-15 04:21:02 | Hokkaido, Japan | |||
372192 | 372192 | 2022-09-13 | Japan | Hokkaido | 704854 | 2518 | 0 | 43.385711 | 142.552318 | 2022-09-14 04:20:44 | Hokkaido, Japan | |||
2394797 | 2394797 | 2022-09-12 | Japan | Hokkaido | 702487 | 2512 | 0 | 43.385711 | 142.552318 | 2022-09-13 04:20:57 | Hokkaido, Japan | |||
3765875 | 3765875 | 2022-09-11 | Japan | Hokkaido | 700340 | 2504 | 0 | 43.385711 | 142.552318 | 2022-09-12 04:20:58 | Hokkaido, Japan | |||
3824450 | 3824450 | 2022-09-10 | Japan | Hokkaido | 697045 | 2502 | 0 | 43.385711 | 142.552318 | 2022-09-11 04:20:50 | Hokkaido, Japan | |||
962907 | 962907 | 2022-09-09 | Japan | Hokkaido | 693294 | 2495 | 0 | 43.385711 | 142.552318 | 2022-09-10 04:21:10 | Hokkaido, Japan | |||
253309 | 253309 | 2022-09-08 | Japan | Hokkaido | 688844 | 2492 | 0 | 43.385711 | 142.552318 | 2022-09-09 04:21:11 | Hokkaido, Japan | |||
3745107 | 3745107 | 2022-09-07 | Japan | Hokkaido | 683512 | 2486 | 0 | 43.385711 | 142.552318 | 2022-09-08 04:21:02 | Hokkaido, Japan | |||
114747 | 114747 | 2022-09-06 | Japan | Hokkaido | 678332 | 2471 | 0 | 43.385711 | 142.552318 | 2022-09-07 04:20:59 | Hokkaido, Japan | |||
2633719 | 2633719 | 2022-09-05 | Japan | Hokkaido | 674742 | 2463 | 0 | 43.385711 | 142.552318 | 2022-09-06 04:21:02 | Hokkaido, Japan | |||
2987283 | 2987283 | 2022-09-04 | Japan | Hokkaido | 671505 | 2453 | 0 | 43.385711 | 142.552318 | 2022-09-05 04:21:01 | Hokkaido, Japan | |||
2712968 | 2712968 | 2022-09-03 | Japan | Hokkaido | 667125 | 2446 | 0 | 43.385711 | 142.552318 | 2022-09-04 04:21:22 | Hokkaido, Japan | |||
1393673 | 1393673 | 2022-09-02 | Japan | Hokkaido | 661849 | 2440 | 0 | 43.385711 | 142.552318 | 2022-09-03 04:21:04 | Hokkaido, Japan | |||
3547502 | 3547502 | 2022-09-01 | Japan | Hokkaido | 656283 | 2429 | 0 | 43.385711 | 142.552318 | 2022-09-02 04:21:07 | Hokkaido, Japan | |||
2343422 | 2343422 | 2022-08-31 | Japan | Hokkaido | 650646 | 2421 | 0 | 43.385711 | 142.552318 | 2022-09-01 04:21:03 | Hokkaido, Japan | |||
3773902 | 3773902 | 2022-08-30 | Japan | Hokkaido | 644677 | 2408 | 0 | 43.385711 | 142.552318 | 2022-08-31 04:20:57 | Hokkaido, Japan | |||
1680498 | 1680498 | 2022-08-29 | Japan | Hokkaido | 640791 | 2395 | 0 | 43.385711 | 142.552318 | 2022-08-30 04:21:03 | Hokkaido, Japan | |||
1876982 | 1876982 | 2022-08-28 | Japan | Hokkaido | 637125 | 2386 | 0 | 43.385711 | 142.552318 | 2022-08-29 04:21:06 | Hokkaido, Japan | |||
2096109 | 2096109 | 2022-08-27 | Japan | Hokkaido | 631965 | 2378 | 0 | 43.385711 | 142.552318 | 2022-08-28 04:21:02 | Hokkaido, Japan | |||
1531924 | 1531924 | 2022-08-26 | Japan | Hokkaido | 626230 | 2361 | 0 | 43.385711 | 142.552318 | 2022-08-27 04:20:57 | Hokkaido, Japan | |||
2828811 | 2828811 | 2022-08-25 | Japan | Hokkaido | 619835 | 2343 | 0 | 43.385711 | 142.552318 | 2022-08-26 04:21:02 | Hokkaido, Japan | |||
2323344 | 2323344 | 2022-08-24 | Japan | Hokkaido | 613285 | 2326 | 0 | 43.385711 | 142.552318 | 2022-08-25 04:21:13 | Hokkaido, Japan | |||
1250753 | 1250753 | 2022-08-23 | Japan | Hokkaido | 606399 | 2322 | 0 | 43.385711 | 142.552318 | 2022-08-24 04:20:46 | Hokkaido, Japan | |||
2852857 | 2852857 | 2022-08-22 | Japan | Hokkaido | 600812 | 2313 | 0 | 43.385711 | 142.552318 | 2022-08-23 04:20:56 | Hokkaido, Japan | |||
2402829 | 2402829 | 2022-08-21 | Japan | Hokkaido | 595415 | 2307 | 0 | 43.385711 | 142.552318 | 2022-08-22 04:20:38 | Hokkaido, Japan | |||
3797907 | 3797907 | 2022-08-20 | Japan | Hokkaido | 589055 | 2302 | 0 | 43.385711 | 142.552318 | 2022-08-21 04:20:44 | Hokkaido, Japan | |||
2363493 | 2363493 | 2022-08-19 | Japan | Hokkaido | 581465 | 2292 | 0 | 43.385711 | 142.552318 | 2022-08-20 04:21:01 | Hokkaido, Japan | |||
1161164 | 1161164 | 2022-08-18 | Japan | Hokkaido | 572833 | 2287 | 0 | 43.385711 | 142.552318 | 2022-08-19 04:20:54 | Hokkaido, Japan | |||
3950488 | 3950488 | 2022-08-17 | Japan | Hokkaido | 564518 | 2275 | 0 | 43.385711 | 142.552318 | 2022-08-18 04:21:11 | Hokkaido, Japan | |||
990990 | 990990 | 2022-08-16 | Japan | Hokkaido | 557638 | 2264 | 0 | 43.385711 | 142.552318 | 2022-08-17 04:20:59 | Hokkaido, Japan | |||
2494029 | 2494029 | 2022-08-15 | Japan | Hokkaido | 552098 | 2247 | 0 | 43.385711 | 142.552318 | 2022-08-16 04:20:58 | Hokkaido, Japan | |||
3647579 | 3647579 | 2022-08-14 | Japan | Hokkaido | 546808 | 2237 | 0 | 43.385711 | 142.552318 | 2022-08-15 04:20:59 | Hokkaido, Japan | |||
1968585 | 1968585 | 2022-08-13 | Japan | Hokkaido | 540802 | 2234 | 0 | 43.385711 | 142.552318 | 2022-08-14 04:20:55 | Hokkaido, Japan | |||
2888394 | 2888394 | 2022-08-12 | Japan | Hokkaido | 534520 | 2225 | 0 | 43.385711 | 142.552318 | 2022-08-13 04:20:52 | Hokkaido, Japan | |||
3907999 | 3907999 | 2022-08-11 | Japan | Hokkaido | 527462 | 2219 | 0 | 43.385711 | 142.552318 | 2022-08-12 04:20:54 | Hokkaido, Japan | |||
1346316 | 1346316 | 2022-08-10 | Japan | Hokkaido | 519802 | 2209 | 0 | 43.385711 | 142.552318 | 2022-08-11 04:20:49 | Hokkaido, Japan | |||
1086071 | 1086071 | 2022-08-09 | Japan | Hokkaido | 512029 | 2206 | 0 | 43.385711 | 142.552318 | 2022-08-10 04:20:57 | Hokkaido, Japan | |||
3543486 | 3543486 | 2022-08-08 | Japan | Hokkaido | 506483 | 2189 | 0 | 43.385711 | 142.552318 | 2022-08-09 04:20:34 | Hokkaido, Japan | |||
1069889 | 1069889 | 2022-08-07 | Japan | Hokkaido | 501385 | 2182 | 0 | 43.385711 | 142.552318 | 2022-08-08 04:21:08 | Hokkaido, Japan | |||
1940477 | 1940477 | 2022-08-06 | Japan | Hokkaido | 495063 | 2181 | 0 | 43.385711 | 142.552318 | 2022-08-07 04:20:54 | Hokkaido, Japan | |||
880276 | 880276 | 2022-08-05 | Japan | Hokkaido | 488182 | 2174 | 0 | 43.385711 | 142.552318 | 2022-08-06 04:20:56 | Hokkaido, Japan | |||
2008687 | 2008687 | 2022-08-04 | Japan | Hokkaido | 480972 | 2166 | 0 | 43.385711 | 142.552318 | 2022-08-05 04:20:52 | Hokkaido, Japan | |||
1098114 | 1098114 | 2022-08-03 | Japan | Hokkaido | 473768 | 2154 | 0 | 43.385711 | 142.552318 | 2022-08-04 04:20:58 | Hokkaido, Japan | |||
1405039 | 1405039 | 2022-08-02 | Japan | Hokkaido | 466838 | 2147 | 0 | 43.385711 | 142.552318 | 2022-08-03 04:20:59 | Hokkaido, Japan | |||
3617077 | 3617077 | 2022-08-01 | Japan | Hokkaido | 462205 | 2140 | 0 | 43.385711 | 142.552318 | 2022-08-02 04:20:53 | Hokkaido, Japan | |||
3871557 | 3871557 | 2022-07-31 | Japan | Hokkaido | 457622 | 2139 | 0 | 43.385711 | 142.552318 | 2022-08-01 04:21:03 | Hokkaido, Japan | |||
674311 | 674311 | 2022-07-30 | Japan | Hokkaido | 451557 | 2136 | 0 | 43.385711 | 142.552318 | 2022-07-31 04:21:02 | Hokkaido, Japan | |||
1783510 | 1783510 | 2022-07-29 | Japan | Hokkaido | 445271 | 2134 | 0 | 43.385711 | 142.552318 | 2022-07-30 04:20:42 | Hokkaido, Japan | |||
1065873 | 1065873 | 2022-07-28 | Japan | Hokkaido | 438677 | 2130 | 0 | 43.385711 | 142.552318 | 2022-07-29 04:20:45 | Hokkaido, Japan | |||
2335392 | 2335392 | 2022-07-27 | Japan | Hokkaido | 433001 | 2128 | 0 | 43.385711 | 142.552318 | 2022-07-28 04:20:56 | Hokkaido, Japan | |||
1487582 | 1487582 | 2022-07-26 | Japan | Hokkaido | 427479 | 2123 | 0 | 43.385711 | 142.552318 | 2022-07-27 04:21:04 | Hokkaido, Japan | |||
2594028 | 2594028 | 2022-07-25 | Japan | Hokkaido | 424211 | 2118 | 0 | 43.385711 | 142.552318 | 2022-07-26 04:20:58 | Hokkaido, Japan | |||
896143 | 896143 | 2022-07-24 | Japan | Hokkaido | 420850 | 2115 | 0 | 43.385711 | 142.552318 | 2022-07-25 04:20:51 | Hokkaido, Japan | |||
91137 | 91137 | 2022-07-23 | Japan | Hokkaido | 416778 | 2113 | 0 | 43.385711 | 142.552318 | 2022-07-24 04:20:47 | Hokkaido, Japan | |||
900159 | 900159 | 2022-07-22 | Japan | Hokkaido | 412142 | 2110 | 0 | 43.385711 | 142.552318 | 2022-07-23 04:20:53 | Hokkaido, Japan | |||
670295 | 670295 | 2022-07-21 | Japan | Hokkaido | 407678 | 2109 | 0 | 43.385711 | 142.552318 | 2022-07-22 04:21:15 | Hokkaido, Japan | |||
1608258 | 1608258 | 2022-07-20 | Japan | Hokkaido | 403713 | 2109 | 0 | 43.385711 | 142.552318 | 2022-07-21 04:21:10 | Hokkaido, Japan | |||
958891 | 958891 | 2022-07-19 | Japan | Hokkaido | 401653 | 2107 | 0 | 43.385711 | 142.552318 | 2022-07-20 04:20:59 | Hokkaido, Japan | |||
3210278 | 3210278 | 2022-07-18 | Japan | Hokkaido | 400468 | 2106 | 0 | 43.385711 | 142.552318 | 2022-07-19 04:20:58 | Hokkaido, Japan | |||
3405453 | 3405453 | 2022-07-17 | Japan | Hokkaido | 398953 | 2106 | 0 | 43.385711 | 142.552318 | 2022-07-18 04:20:59 | Hokkaido, Japan | |||
2151653 | 2151653 | 2022-07-16 | Japan | Hokkaido | 397120 | 2106 | 0 | 43.385711 | 142.552318 | 2022-07-17 04:21:15 | Hokkaido, Japan | |||
2418886 | 2418886 | 2022-07-15 | Japan | Hokkaido | 395192 | 2105 | 0 | 43.385711 | 142.552318 | 2022-07-16 04:21:05 | Hokkaido, Japan | |||
3428961 | 3428961 | 2022-07-14 | Japan | Hokkaido | 393458 | 2105 | 0 | 43.385711 | 142.552318 | 2022-07-15 04:20:53 | Hokkaido, Japan | |||
3109481 | 3109481 | 2022-07-13 | Japan | Hokkaido | 391745 | 2105 | 0 | 43.385711 | 142.552318 | 2022-07-14 04:20:57 | Hokkaido, Japan | |||
629904 | 629904 | 2022-07-12 | Japan | Hokkaido | 390396 | 2102 | 0 | 43.385711 | 142.552318 | 2022-07-13 04:20:58 | Hokkaido, Japan | |||
1211548 | 1211548 | 2022-07-11 | Japan | Hokkaido | 389593 | 2102 | 0 | 43.385711 | 142.552318 | 2022-07-12 04:20:51 | Hokkaido, Japan | |||
2789030 | 2789030 | 2022-07-10 | Japan | Hokkaido | 388991 | 2101 | 0 | 43.385711 | 142.552318 | 2022-07-11 04:20:46 | Hokkaido, Japan | |||
141983 | 141983 | 2022-07-09 | Japan | Hokkaido | 388132 | 2101 | 0 | 43.385711 | 142.552318 | 2022-07-10 04:20:54 | Hokkaido, Japan | |||
1417083 | 1417083 | 2022-07-08 | Japan | Hokkaido | 387221 | 2100 | 0 | 43.385711 | 142.552318 | 2022-07-09 04:20:59 | Hokkaido, Japan | |||
2741008 | 2741008 | 2022-07-07 | Japan | Hokkaido | 386334 | 2099 | 0 | 43.385711 | 142.552318 | 2022-07-08 04:20:56 | Hokkaido, Japan | |||
1199803 | 1199803 | 2022-07-06 | Japan | Hokkaido | 385433 | 2097 | 0 | 43.385711 | 142.552318 | 2022-07-07 04:20:55 | Hokkaido, Japan | |||
3966546 | 3966546 | 2022-07-05 | Japan | Hokkaido | 384612 | 2096 | 0 | 43.385711 | 142.552318 | 2022-07-06 04:20:58 | Hokkaido, Japan | |||
3078057 | 3078057 | 2022-07-04 | Japan | Hokkaido | 384051 | 2096 | 0 | 43.385711 | 142.552318 | 2022-07-05 04:20:45 | Hokkaido, Japan | |||
1767339 | 1767339 | 2022-07-03 | Japan | Hokkaido | 383644 | 2096 | 0 | 43.385711 | 142.552318 | 2022-07-04 04:20:54 | Hokkaido, Japan | |||
3365325 | 3365325 | 2022-07-02 | Japan | Hokkaido | 383027 | 2096 | 0 | 43.385711 | 142.552318 | 2022-07-03 04:20:59 | Hokkaido, Japan | |||
593654 | 593654 | 2022-07-01 | Japan | Hokkaido | 382401 | 2096 | 0 | 43.385711 | 142.552318 | 2022-07-02 04:21:16 | Hokkaido, Japan | |||
3940055 | 3940055 | 2022-06-30 | Japan | Hokkaido | 381760 | 2096 | 0 | 43.385711 | 142.552318 | 2022-07-01 04:21:10 | Hokkaido, Japan | |||
2490013 | 2490013 | 2022-06-29 | Japan | Hokkaido | 381115 | 2096 | 0 | 43.385711 | 142.552318 | 2022-06-30 04:21:01 | Hokkaido, Japan | |||
2239395 | 2239395 | 2022-06-28 | Japan | Hokkaido | 380403 | 2095 | 0 | 43.385711 | 142.552318 | 2022-06-29 04:20:59 | Hokkaido, Japan | |||
2147637 | 2147637 | 2022-06-27 | Japan | Hokkaido | 379982 | 2095 | 0 | 43.385711 | 142.552318 | 2022-06-28 04:20:58 | Hokkaido, Japan | |||
475438 | 475438 | 2022-06-26 | Japan | Hokkaido | 379664 | 2094 | 0 | 43.385711 | 142.552318 | 2022-06-27 04:21:00 | Hokkaido, Japan | |||
938813 | 938813 | 2022-06-25 | Japan | Hokkaido | 379114 | 2094 | 0 | 43.385711 | 142.552318 | 2022-06-26 04:21:02 | Hokkaido, Japan | |||
3346633 | 3346633 | 2022-06-24 | Japan | Hokkaido | 378529 | 2094 | 0 | 43.385711 | 142.552318 | 2022-06-25 04:20:57 | Hokkaido, Japan | |||
1648374 | 1648374 | 2022-06-23 | Japan | Hokkaido | 377856 | 2094 | 0 | 43.385711 | 142.552318 | 2022-06-24 04:20:58 | Hokkaido, Japan | |||
2187609 | 2187609 | 2022-06-22 | Japan | Hokkaido | 377103 | 2092 | 0 | 43.385711 | 142.552318 | 2022-06-23 04:20:55 | Hokkaido, Japan | |||
166040 | 166040 | 2022-06-21 | Japan | Hokkaido | 376380 | 2090 | 0 | 43.385711 | 142.552318 | 2022-06-22 04:20:54 | Hokkaido, Japan | |||
1763323 | 1763323 | 2022-06-20 | Japan | Hokkaido | 375907 | 2090 | 0 | 43.385711 | 142.552318 | 2022-06-21 04:20:56 | Hokkaido, Japan | |||
3269509 | 3269509 | 2022-06-19 | Japan | Hokkaido | 375473 | 2088 | 0 | 43.385711 | 142.552318 | 2022-06-20 04:21:01 | Hokkaido, Japan | |||
3397421 | 3397421 | 2022-06-18 | Japan | Hokkaido | 374770 | 2088 | 0 | 43.385711 | 142.552318 | 2022-06-19 04:20:51 | Hokkaido, Japan | |||
2311298 | 2311298 | 2022-06-17 | Japan | Hokkaido | 374078 | 2083 | 0 | 43.385711 | 142.552318 | 2022-06-18 04:21:10 | Hokkaido, Japan | |||
558802 | 558802 | 2022-06-16 | Japan | Hokkaido | 373283 | 2082 | 0 | 43.385711 | 142.552318 | 2022-06-17 04:20:56 | Hokkaido, Japan | |||
3982604 | 3982604 | 2022-06-15 | Japan | Hokkaido | 372381 | 2081 | 0 | 43.385711 | 142.552318 | 2022-06-16 04:20:55 | Hokkaido, Japan | |||
946845 | 946845 | 2022-06-14 | Japan | Hokkaido | 371416 | 2079 | 0 | 43.385711 | 142.552318 | 2022-06-15 04:20:54 | Hokkaido, Japan | |||
2979253 | 2979253 | 2022-06-13 | Japan | Hokkaido | 370795 | 2079 | 0 | 43.385711 | 142.552318 | 2022-06-14 04:20:52 | 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]);