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 longitude
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude ▼ | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
325 | 325 | 2021-12-02 | Japan | Hokkaido | 61157 | 1472 | 0 | 43.385711 | 142.55231799999999 | 2021-12-03 04:23:05 | Hokkaido, Japan | |||
4341 | 4341 | 2021-10-28 | Japan | Hokkaido | 60722 | 1470 | 0 | 43.385711 | 142.55231799999999 | 2021-10-29 04:22:03 | Hokkaido, Japan | |||
16366 | 16366 | 2021-09-18 | Japan | Hokkaido | 59649 | 1465 | 0 | 43.385711 | 142.55231799999999 | 2021-09-19 04:21:34 | Hokkaido, Japan | |||
24396 | 24396 | 2022-03-20 | Japan | Hokkaido | 205866 | 1898 | 0 | 43.385711 | 142.55231799999999 | 2022-03-21 04:20:50 | Hokkaido, Japan | |||
28411 | 28411 | 2021-11-11 | Japan | Hokkaido | 60854 | 1472 | 0 | 43.385711 | 142.55231799999999 | 2021-11-12 04:22:01 | Hokkaido, Japan | |||
32427 | 32427 | 2021-08-25 | Japan | Hokkaido | 54534 | 1437 | 0 | 43.385711 | 142.55231799999999 | 2021-08-26 04:21:28 | Hokkaido, Japan | |||
43703 | 43703 | 2021-11-02 | Japan | Hokkaido | 60766 | 1471 | 0 | 43.385711 | 142.55231799999999 | 2021-11-03 06:22:09 | Hokkaido, Japan | |||
67072 | 67072 | 2021-09-01 | Japan | Hokkaido | 57158 | 1452 | 0 | 43.385711 | 142.55231799999999 | 2021-09-02 04:21:15 | Hokkaido, Japan | |||
71086 | 71086 | 2022-02-07 | Japan | Hokkaido | 116089 | 1541 | 0 | 43.385711 | 142.55231799999999 | 2022-02-08 04:21:15 | Hokkaido, Japan | |||
87120 | 87120 | 2021-11-09 | Japan | Hokkaido | 60838 | 1472 | 0 | 43.385711 | 142.55231799999999 | 2021-11-10 04:21:38 | Hokkaido, Japan | |||
99321 | 99321 | 2022-01-14 | Japan | Hokkaido | 63242 | 1477 | 0 | 43.385711 | 142.55231799999999 | 2022-01-15 04:21:07 | Hokkaido, Japan | |||
103337 | 103337 | 2021-08-15 | Japan | Hokkaido | 49552 | 1430 | 0 | 43.385711 | 142.55231799999999 | 2021-08-16 04:21:31 | Hokkaido, Japan | |||
121837 | 121837 | 2020-07-19 | Japan | Hokkaido | 1348 | 102 | 1141 | 105 | 43.385711 | 142.55231799999999 | 2020-07-20 05:34:40 | Hokkaido, Japan | ||
126728 | 126728 | 2022-01-09 | Japan | Hokkaido | 62027 | 1475 | 0 | 43.385711 | 142.55231799999999 | 2022-01-10 04:22:07 | Hokkaido, Japan | |||
137966 | 137966 | 2021-12-04 | Japan | Hokkaido | 61170 | 1472 | 0 | 43.385711 | 142.55231799999999 | 2021-12-05 04:22:25 | Hokkaido, Japan | |||
149979 | 149979 | 2021-11-29 | Japan | Hokkaido | 61141 | 1472 | 0 | 43.385711 | 142.55231799999999 | 2021-11-30 04:22:53 | Hokkaido, Japan | |||
158008 | 158008 | 2022-03-29 | Japan | Hokkaido | 218934 | 1924 | 0 | 43.385711 | 142.55231799999999 | 2022-03-30 04:20:45 | Hokkaido, Japan | |||
162023 | 162023 | 2021-11-19 | Japan | Hokkaido | 61019 | 1472 | 0 | 43.385711 | 142.55231799999999 | 2021-11-20 04:22:17 | Hokkaido, Japan | |||
178037 | 178037 | 2021-09-02 | Japan | Hokkaido | 57472 | 1453 | 0 | 43.385711 | 142.55231799999999 | 2021-09-03 04:21:20 | Hokkaido, Japan | |||
186066 | 186066 | 2022-02-13 | Japan | Hokkaido | 136327 | 1595 | 0 | 43.385711 | 142.55231799999999 | 2022-02-14 04:20:51 | Hokkaido, Japan | |||
233238 | 233238 | 2022-02-11 | Japan | Hokkaido | 130355 | 1580 | 0 | 43.385711 | 142.55231799999999 | 2022-02-12 04:21:06 | Hokkaido, Japan | |||
245280 | 245280 | 2021-08-17 | Japan | Hokkaido | 50319 | 1433 | 0 | 43.385711 | 142.55231799999999 | 2021-08-18 04:21:35 | Hokkaido, Japan | |||
249294 | 249294 | 2021-09-04 | Japan | Hokkaido | 57947 | 1456 | 0 | 43.385711 | 142.55231799999999 | 2021-09-05 04:21:33 | Hokkaido, Japan | |||
261528 | 261528 | 2022-03-15 | Japan | Hokkaido | 197290 | 1878 | 0 | 43.385711 | 142.55231799999999 | 2022-03-16 04:20:50 | Hokkaido, Japan | |||
276178 | 276178 | 2021-11-03 | Japan | Hokkaido | 60779 | 1471 | 0 | 43.385711 | 142.55231799999999 | 2021-11-04 04:22:20 | Hokkaido, Japan | |||
287122 | 287122 | 2020-06-15 | Japan | Hokkaido | 1176 | 91 | 956 | 129 | 43.385711 | 142.55231799999999 | 2020-06-16 04:33:09 | Hokkaido, Japan | ||
287991 | 287991 | 2021-10-31 | Japan | Hokkaido | 60749 | 1471 | 0 | 43.385711 | 142.55231799999999 | 2021-11-01 04:22:01 | Hokkaido, Japan | |||
302994 | 302994 | 2020-07-01 | Japan | Hokkaido | 1267 | 100 | 1054 | 113 | 43.385711 | 142.55231799999999 | 2020-07-02 04:33:46 | Hokkaido, Japan | ||
303864 | 303864 | 2022-04-16 | Japan | Hokkaido | 257396 | 1964 | 0 | 43.385711 | 142.55231799999999 | 2022-04-17 04:20:59 | Hokkaido, Japan | |||
315912 | 315912 | 2022-02-12 | Japan | Hokkaido | 133635 | 1590 | 0 | 43.385711 | 142.55231799999999 | 2022-02-13 04:21:00 | Hokkaido, Japan | |||
326932 | 326932 | 2020-07-20 | Japan | Hokkaido | 1351 | 102 | 1156 | 93 | 43.385711 | 142.55231799999999 | 2020-07-21 04:38:46 | Hokkaido, Japan | ||
335932 | 335932 | 2022-03-18 | Japan | Hokkaido | 202761 | 1892 | 0 | 43.385711 | 142.55231799999999 | 2022-03-19 04:20:47 | Hokkaido, Japan | |||
356322 | 356322 | 2022-03-11 | Japan | Hokkaido | 191910 | 1851 | 0 | 43.385711 | 142.55231799999999 | 2022-03-12 04:20:50 | Hokkaido, Japan | |||
404289 | 404289 | 2021-12-07 | Japan | Hokkaido | 61179 | 1472 | 0 | 43.385711 | 142.55231799999999 | 2021-12-08 04:22:46 | Hokkaido, Japan | |||
415286 | 415286 | 2020-07-05 | Japan | Hokkaido | 1277 | 101 | 1077 | 99 | 43.385711 | 142.55231799999999 | 2020-07-06 04:33:57 | Hokkaido, Japan | ||
423346 | 423346 | 2021-10-10 | Japan | Hokkaido | 60421 | 1469 | 0 | 43.385711 | 142.55231799999999 | 2021-10-11 04:21:31 | Hokkaido, Japan | |||
443350 | 443350 | 2021-10-20 | Japan | Hokkaido | 60645 | 1469 | 0 | 43.385711 | 142.55231799999999 | 2021-10-21 04:21:18 | Hokkaido, Japan | |||
447366 | 447366 | 2021-11-17 | Japan | Hokkaido | 60982 | 1472 | 0 | 43.385711 | 142.55231799999999 | 2021-11-18 04:21:33 | Hokkaido, Japan | |||
459375 | 459375 | 2022-02-02 | Japan | Hokkaido | 98561 | 1504 | 0 | 43.385711 | 142.55231799999999 | 2022-02-03 04:21:21 | Hokkaido, Japan | |||
467407 | 467407 | 2021-10-07 | Japan | Hokkaido | 60359 | 1469 | 0 | 43.385711 | 142.55231799999999 | 2021-10-08 04:21:25 | Hokkaido, Japan | |||
491631 | 491631 | 2021-10-14 | Japan | Hokkaido | 60519 | 1469 | 0 | 43.385711 | 142.55231799999999 | 2021-10-15 04:21:26 | Hokkaido, Japan | |||
495647 | 495647 | 2021-11-06 | Japan | Hokkaido | 60809 | 1472 | 0 | 43.385711 | 142.55231799999999 | 2021-11-07 04:21:53 | Hokkaido, Japan | |||
499664 | 499664 | 2022-04-02 | Japan | Hokkaido | 227037 | 1935 | 0 | 43.385711 | 142.55231799999999 | 2022-04-03 04:20:48 | Hokkaido, Japan | |||
507695 | 507695 | 2021-08-14 | Japan | Hokkaido | 49186 | 1430 | 0 | 43.385711 | 142.55231799999999 | 2021-08-15 04:21:41 | Hokkaido, Japan | |||
511709 | 511709 | 2021-08-19 | Japan | Hokkaido | 51489 | 1434 | 0 | 43.385711 | 142.55231799999999 | 2021-08-20 04:21:33 | Hokkaido, Japan | |||
529848 | 529848 | 2020-07-04 | Japan | Hokkaido | 1276 | 101 | 1077 | 98 | 43.385711 | 142.55231799999999 | 2020-07-05 04:33:46 | Hokkaido, Japan | ||
534731 | 534731 | 2021-10-27 | Japan | Hokkaido | 60717 | 1470 | 0 | 43.385711 | 142.55231799999999 | 2021-10-28 04:22:08 | Hokkaido, Japan | |||
550769 | 550769 | 2021-12-08 | Japan | Hokkaido | 61181 | 1473 | 0 | 43.385711 | 142.55231799999999 | 2021-12-09 04:22:49 | Hokkaido, Japan | |||
554785 | 554785 | 2022-01-16 | Japan | Hokkaido | 64629 | 1477 | 0 | 43.385711 | 142.55231799999999 | 2022-01-17 04:21:08 | Hokkaido, Japan | |||
567099 | 567099 | 2021-10-29 | Japan | Hokkaido | 60730 | 1470 | 0 | 43.385711 | 142.55231799999999 | 2021-10-30 04:22:03 | Hokkaido, Japan | |||
574828 | 574828 | 2022-02-25 | Japan | Hokkaido | 165998 | 1734 | 0 | 43.385711 | 142.55231799999999 | 2022-02-26 04:21:12 | Hokkaido, Japan | |||
597669 | 597669 | 2021-10-19 | Japan | Hokkaido | 60631 | 1469 | 0 | 43.385711 | 142.55231799999999 | 2021-10-20 04:21:00 | Hokkaido, Japan | |||
601685 | 601685 | 2021-09-23 | Japan | Hokkaido | 59942 | 1466 | 0 | 43.385711 | 142.55231799999999 | 2021-09-24 04:21:44 | Hokkaido, Japan | |||
633919 | 633919 | 2021-10-13 | Japan | Hokkaido | 60474 | 1469 | 0 | 43.385711 | 142.55231799999999 | 2021-10-14 04:21:29 | Hokkaido, Japan | |||
641949 | 641949 | 2021-09-07 | Japan | Hokkaido | 58425 | 1460 | 0 | 43.385711 | 142.55231799999999 | 2021-09-08 04:21:31 | Hokkaido, Japan | |||
649977 | 649977 | 2021-08-09 | Japan | Hokkaido | 47075 | 1428 | 0 | 43.385711 | 142.55231799999999 | 2021-08-10 04:21:27 | Hokkaido, Japan | |||
653991 | 653991 | 2021-10-22 | Japan | Hokkaido | 60671 | 1470 | 0 | 43.385711 | 142.55231799999999 | 2021-10-23 04:21:32 | Hokkaido, Japan | |||
682336 | 682336 | 2021-10-24 | Japan | Hokkaido | 60694 | 1470 | 0 | 43.385711 | 142.55231799999999 | 2021-10-25 04:22:31 | Hokkaido, Japan | |||
686352 | 686352 | 2021-11-13 | Japan | Hokkaido | 60895 | 1472 | 0 | 43.385711 | 142.55231799999999 | 2021-11-14 04:21:31 | Hokkaido, Japan | |||
694385 | 694385 | 2022-03-17 | Japan | Hokkaido | 201047 | 1890 | 0 | 43.385711 | 142.55231799999999 | 2022-03-18 04:20:55 | Hokkaido, Japan | |||
698400 | 698400 | 2021-11-04 | Japan | Hokkaido | 60783 | 1472 | 0 | 43.385711 | 142.55231799999999 | 2021-11-05 04:21:54 | Hokkaido, Japan | |||
706430 | 706430 | 2021-09-29 | Japan | Hokkaido | 60212 | 1467 | 0 | 43.385711 | 142.55231799999999 | 2021-09-30 04:21:20 | Hokkaido, Japan | |||
714461 | 714461 | 2021-11-12 | Japan | Hokkaido | 60876 | 1472 | 0 | 43.385711 | 142.55231799999999 | 2021-11-13 04:21:38 | Hokkaido, Japan | |||
722493 | 722493 | 2021-11-20 | Japan | Hokkaido | 61031 | 1472 | 0 | 43.385711 | 142.55231799999999 | 2021-11-21 04:22:13 | Hokkaido, Japan | |||
730523 | 730523 | 2021-12-27 | Japan | Hokkaido | 61402 | 1474 | 0 | 43.385711 | 142.55231799999999 | 2021-12-28 04:21:47 | Hokkaido, Japan | |||
737445 | 737445 | 2020-06-12 | Japan | Hokkaido | 1154 | 91 | 921 | 142 | 43.385711 | 142.55231799999999 | 2020-06-13 03:33:14 | Hokkaido, Japan | ||
746340 | 746340 | 2022-04-23 | Japan | Hokkaido | 275161 | 1981 | 0 | 43.385711 | 142.55231799999999 | 2022-04-24 04:20:56 | Hokkaido, Japan | |||
758323 | 758323 | 2021-11-26 | Japan | Hokkaido | 61116 | 1472 | 0 | 43.385711 | 142.55231799999999 | 2021-11-27 04:22:45 | Hokkaido, Japan | |||
770344 | 770344 | 2021-10-23 | Japan | Hokkaido | 60676 | 1470 | 0 | 43.385711 | 142.55231799999999 | 2021-10-24 04:21:22 | Hokkaido, Japan | |||
782386 | 782386 | 2021-12-13 | Japan | Hokkaido | 61200 | 1474 | 0 | 43.385711 | 142.55231799999999 | 2021-12-14 04:22:38 | Hokkaido, Japan | |||
798425 | 798425 | 2021-12-22 | Japan | Hokkaido | 61309 | 1474 | 0 | 43.385711 | 142.55231799999999 | 2021-12-23 04:21:21 | Hokkaido, Japan | |||
805288 | 805288 | 2020-06-01 | Japan | Hokkaido | 1096 | 87 | 810 | 199 | 43.385711 | 142.55231799999999 | 2020-06-02 02:33:08 | Hokkaido, Japan | ||
809587 | 809587 | 2021-09-20 | Japan | Hokkaido | 59774 | 1466 | 0 | 43.385711 | 142.55231799999999 | 2021-09-21 04:21:26 | Hokkaido, Japan | |||
876260 | 876260 | 2022-03-27 | Japan | Hokkaido | 216368 | 1918 | 0 | 43.385711 | 142.55231799999999 | 2022-03-28 04:20:33 | Hokkaido, Japan | |||
887261 | 887261 | 2020-07-07 | Japan | Hokkaido | 1278 | 101 | 1093 | 84 | 43.385711 | 142.55231799999999 | 2020-07-08 05:33:48 | Hokkaido, Japan | ||
904174 | 904174 | 2021-11-24 | Japan | Hokkaido | 61086 | 1472 | 0 | 43.385711 | 142.55231799999999 | 2021-11-25 04:22:33 | Hokkaido, Japan | |||
919680 | 919680 | 2022-03-08 | Japan | Hokkaido | 186256 | 1829 | 0 | 43.385711 | 142.55231799999999 | 2022-03-09 04:20:59 | Hokkaido, Japan | |||
934796 | 934796 | 2021-10-16 | Japan | Hokkaido | 60570 | 1469 | 0 | 43.385711 | 142.55231799999999 | 2021-10-17 04:21:29 | Hokkaido, Japan | |||
942829 | 942829 | 2022-02-28 | Japan | Hokkaido | 172533 | 1757 | 0 | 43.385711 | 142.55231799999999 | 2022-03-01 04:21:09 | Hokkaido, Japan | |||
950861 | 950861 | 2022-03-12 | Japan | Hokkaido | 193611 | 1860 | 0 | 43.385711 | 142.55231799999999 | 2022-03-13 04:20:49 | Hokkaido, Japan | |||
986974 | 986974 | 2021-10-04 | Japan | Hokkaido | 60309 | 1467 | 0 | 43.385711 | 142.55231799999999 | 2021-10-05 04:21:27 | Hokkaido, Japan | |||
1005436 | 1005436 | 2020-07-09 | Japan | Hokkaido | 1283 | 101 | 1106 | 76 | 43.385711 | 142.55231799999999 | 2020-07-10 04:34:24 | Hokkaido, Japan | ||
1014329 | 1014329 | 2021-11-21 | Japan | Hokkaido | 61056 | 1472 | 0 | 43.385711 | 142.55231799999999 | 2021-11-22 04:22:20 | Hokkaido, Japan | |||
1030371 | 1030371 | 2021-12-06 | Japan | Hokkaido | 61177 | 1472 | 0 | 43.385711 | 142.55231799999999 | 2021-12-07 04:22:34 | Hokkaido, Japan | |||
1057845 | 1057845 | 2022-02-23 | Japan | Hokkaido | 161447 | 1709 | 0 | 43.385711 | 142.55231799999999 | 2022-02-24 04:21:14 | Hokkaido, Japan | |||
1077920 | 1077920 | 2021-12-09 | Japan | Hokkaido | 61188 | 1473 | 0 | 43.385711 | 142.55231799999999 | 2021-12-10 04:22:28 | Hokkaido, Japan | |||
1113585 | 1113585 | 2022-01-11 | Japan | Hokkaido | 62250 | 1477 | 0 | 43.385711 | 142.55231799999999 | 2022-01-12 04:21:44 | Hokkaido, Japan | |||
1136028 | 1136028 | 2020-06-26 | Japan | Hokkaido | 1221 | 98 | 1028 | 95 | 43.385711 | 142.55231799999999 | 2020-06-27 04:33:35 | Hokkaido, Japan | ||
1140908 | 1140908 | 2022-01-23 | Japan | Hokkaido | 73417 | 1479 | 0 | 43.385711 | 142.55231799999999 | 2022-01-24 04:21:12 | Hokkaido, Japan | |||
1144924 | 1144924 | 2021-12-01 | Japan | Hokkaido | 61153 | 1472 | 0 | 43.385711 | 142.55231799999999 | 2021-12-02 04:22:37 | Hokkaido, Japan | |||
1195796 | 1195796 | 2020-06-17 | Japan | Hokkaido | 1184 | 92 | 970 | 122 | 43.385711 | 142.55231799999999 | 2020-06-18 04:33:18 | Hokkaido, Japan | ||
1215563 | 1215563 | 2022-01-08 | Japan | Hokkaido | 61910 | 1475 | 0 | 43.385711 | 142.55231799999999 | 2022-01-09 04:21:46 | Hokkaido, Japan | |||
1223594 | 1223594 | 2022-04-14 | Japan | Hokkaido | 252335 | 1958 | 0 | 43.385711 | 142.55231799999999 | 2022-04-15 04:20:57 | Hokkaido, Japan | |||
1227609 | 1227609 | 2022-01-24 | Japan | Hokkaido | 75006 | 1480 | 0 | 43.385711 | 142.55231799999999 | 2022-01-25 04:21:05 | Hokkaido, Japan | |||
1231625 | 1231625 | 2021-11-28 | Japan | Hokkaido | 61135 | 1472 | 0 | 43.385711 | 142.55231799999999 | 2021-11-29 04:22:30 | Hokkaido, Japan | |||
1235641 | 1235641 | 2021-09-27 | Japan | Hokkaido | 60141 | 1467 | 0 | 43.385711 | 142.55231799999999 | 2021-09-28 04:21:28 | Hokkaido, Japan | |||
1254768 | 1254768 | 2021-12-20 | Japan | Hokkaido | 61265 | 1474 | 0 | 43.385711 | 142.55231799999999 | 2021-12-21 03:21:27 | Hokkaido, Japan | |||
1258784 | 1258784 | 2021-12-18 | Japan | Hokkaido | 61239 | 1474 | 0 | 43.385711 | 142.55231799999999 | 2021-12-19 04:21:11 | Hokkaido, Japan | |||
1262800 | 1262800 | 2021-09-09 | Japan | Hokkaido | 58749 | 1460 | 0 | 43.385711 | 142.55231799999999 | 2021-09-10 04:21:20 | Hokkaido, Japan | |||
1273415 | 1273415 | 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 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]);