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 active
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 | |||
63057 | 63057 | 2022-11-12 | Japan | Hokkaido | 923809 | 2872 | 0 | 43.385711 | 142.552318 | 2022-11-13 04:21:14 | 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 | |||
91137 | 91137 | 2022-07-23 | Japan | Hokkaido | 416778 | 2113 | 0 | 43.385711 | 142.552318 | 2022-07-24 04:20:47 | 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 | |||
114747 | 114747 | 2022-09-06 | Japan | Hokkaido | 678332 | 2471 | 0 | 43.385711 | 142.552318 | 2022-09-07 04:20:59 | Hokkaido, Japan | |||
126728 | 126728 | 2022-01-09 | Japan | Hokkaido | 62027 | 1475 | 0 | 43.385711 | 142.55231799999999 | 2022-01-10 04:22:07 | Hokkaido, Japan | |||
130745 | 130745 | 2022-10-04 | Japan | Hokkaido | 755093 | 2599 | 0 | 43.385711 | 142.552318 | 2022-10-05 04:23:06 | Hokkaido, Japan | |||
137966 | 137966 | 2021-12-04 | Japan | Hokkaido | 61170 | 1472 | 0 | 43.385711 | 142.55231799999999 | 2021-12-05 04:22:25 | Hokkaido, Japan | |||
141983 | 141983 | 2022-07-09 | Japan | Hokkaido | 388132 | 2101 | 0 | 43.385711 | 142.552318 | 2022-07-10 04:20:54 | 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 | |||
166040 | 166040 | 2022-06-21 | Japan | Hokkaido | 376380 | 2090 | 0 | 43.385711 | 142.552318 | 2022-06-22 04:20:54 | 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 | |||
198254 | 198254 | 2022-10-19 | Japan | Hokkaido | 791542 | 2668 | 0 | 43.385711 | 142.552318 | 2022-10-20 04:22:59 | Hokkaido, Japan | |||
217975 | 217975 | 2022-12-26 | Japan | Hokkaido | 1209679 | 3932 | 0 | 43.385711 | 142.552318 | 2022-12-27 04:21:07 | Hokkaido, Japan | |||
221991 | 221991 | 2022-05-09 | Japan | Hokkaido | 312312 | 2009 | 0 | 43.385711 | 142.552318 | 2022-05-10 04:20:50 | Hokkaido, Japan | |||
229222 | 229222 | 2022-05-31 | Japan | Hokkaido | 358769 | 2064 | 0 | 43.385711 | 142.552318 | 2022-06-01 04:20:55 | 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 | |||
253309 | 253309 | 2022-09-08 | Japan | Hokkaido | 688844 | 2492 | 0 | 43.385711 | 142.552318 | 2022-09-09 04:21:11 | Hokkaido, Japan | |||
257325 | 257325 | 2022-12-10 | Japan | Hokkaido | 1131003 | 3558 | 0 | 43.385711 | 142.552318 | 2022-12-11 04:20:50 | 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 | |||
287991 | 287991 | 2021-10-31 | Japan | Hokkaido | 60749 | 1471 | 0 | 43.385711 | 142.55231799999999 | 2021-11-01 04:22:01 | Hokkaido, Japan | |||
292008 | 292008 | 2022-11-15 | Japan | Hokkaido | 944512 | 2904 | 0 | 43.385711 | 142.552318 | 2022-11-16 04:21:09 | Hokkaido, Japan | |||
303864 | 303864 | 2022-04-16 | Japan | Hokkaido | 257396 | 1964 | 0 | 43.385711 | 142.55231799999999 | 2022-04-17 04:20:59 | Hokkaido, Japan | |||
307880 | 307880 | 2022-12-13 | Japan | Hokkaido | 1145262 | 3616 | 0 | 43.385711 | 142.552318 | 2022-12-14 04:21:04 | Hokkaido, Japan | |||
311896 | 311896 | 2022-11-13 | Japan | Hokkaido | 929467 | 2885 | 0 | 43.385711 | 142.552318 | 2022-11-14 04:21:09 | Hokkaido, Japan | |||
315912 | 315912 | 2022-02-12 | Japan | Hokkaido | 133635 | 1590 | 0 | 43.385711 | 142.55231799999999 | 2022-02-13 04:21:00 | Hokkaido, Japan | |||
319928 | 319928 | 2022-10-30 | Japan | Hokkaido | 834492 | 2728 | 0 | 43.385711 | 142.552318 | 2022-10-31 04:21:36 | Hokkaido, Japan | |||
327902 | 327902 | 2022-12-27 | Japan | Hokkaido | 1215529 | 3944 | 0 | 43.385711 | 142.552318 | 2022-12-28 04:21:04 | Hokkaido, Japan | |||
335932 | 335932 | 2022-03-18 | Japan | Hokkaido | 202761 | 1892 | 0 | 43.385711 | 142.55231799999999 | 2022-03-19 04:20:47 | Hokkaido, Japan | |||
348292 | 348292 | 2022-12-14 | Japan | Hokkaido | 1152476 | 3658 | 0 | 43.385711 | 142.552318 | 2022-12-15 04:20:58 | Hokkaido, Japan | |||
356322 | 356322 | 2022-03-11 | Japan | Hokkaido | 191910 | 1851 | 0 | 43.385711 | 142.55231799999999 | 2022-03-12 04:20:50 | Hokkaido, Japan | |||
360338 | 360338 | 2022-05-07 | Japan | Hokkaido | 306641 | 2001 | 0 | 43.385711 | 142.552318 | 2022-05-08 04:20:49 | Hokkaido, Japan | |||
372192 | 372192 | 2022-09-13 | Japan | Hokkaido | 704854 | 2518 | 0 | 43.385711 | 142.552318 | 2022-09-14 04:20:44 | Hokkaido, Japan | |||
384219 | 384219 | 2022-09-23 | Japan | Hokkaido | 731371 | 2569 | 0 | 43.385711 | 142.552318 | 2022-09-24 04:21:40 | Hokkaido, Japan | |||
396260 | 396260 | 2022-10-07 | Japan | Hokkaido | 761617 | 2612 | 0 | 43.385711 | 142.552318 | 2022-10-08 04:22:56 | Hokkaido, Japan | |||
404289 | 404289 | 2021-12-07 | Japan | Hokkaido | 61179 | 1472 | 0 | 43.385711 | 142.55231799999999 | 2021-12-08 04:22:46 | Hokkaido, Japan | |||
419331 | 419331 | 2022-09-18 | Japan | Hokkaido | 719799 | 2536 | 0 | 43.385711 | 142.552318 | 2022-09-19 04:21:49 | Hokkaido, Japan | |||
423346 | 423346 | 2021-10-10 | Japan | Hokkaido | 60421 | 1469 | 0 | 43.385711 | 142.55231799999999 | 2021-10-11 04:21:31 | Hokkaido, Japan | |||
431353 | 431353 | 2022-11-03 | Japan | Hokkaido | 859767 | 2763 | 0 | 43.385711 | 142.552318 | 2022-11-04 04:22:11 | 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 | |||
451383 | 451383 | 2022-12-21 | Japan | Hokkaido | 1188520 | 3813 | 0 | 43.385711 | 142.552318 | 2022-12-22 04:20:56 | Hokkaido, Japan | |||
459375 | 459375 | 2022-02-02 | Japan | Hokkaido | 98561 | 1504 | 0 | 43.385711 | 142.55231799999999 | 2022-02-03 04:21:21 | Hokkaido, Japan | |||
463392 | 463392 | 2022-05-02 | Japan | Hokkaido | 297199 | 1997 | 0 | 43.385711 | 142.552318 | 2022-05-03 04:21:00 | Hokkaido, Japan | |||
467407 | 467407 | 2021-10-07 | Japan | Hokkaido | 60359 | 1469 | 0 | 43.385711 | 142.55231799999999 | 2021-10-08 04:21:25 | Hokkaido, Japan | |||
475438 | 475438 | 2022-06-26 | Japan | Hokkaido | 379664 | 2094 | 0 | 43.385711 | 142.552318 | 2022-06-27 04:21:00 | Hokkaido, Japan | |||
479586 | 479586 | 2022-11-08 | Japan | Hokkaido | 888963 | 2805 | 0 | 43.385711 | 142.552318 | 2022-11-09 04:21:22 | Hokkaido, Japan | |||
487616 | 487616 | 2022-11-25 | Japan | Hokkaido | 1029264 | 3113 | 0 | 43.385711 | 142.552318 | 2022-11-26 04:21:11 | 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 | |||
503680 | 503680 | 2022-12-17 | Japan | Hokkaido | 1170252 | 3724 | 0 | 43.385711 | 142.552318 | 2022-12-18 04:21:03 | 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 | |||
515724 | 515724 | 2022-10-15 | Japan | Hokkaido | 780358 | 2647 | 0 | 43.385711 | 142.552318 | 2022-10-16 04:22:39 | Hokkaido, Japan | |||
534731 | 534731 | 2021-10-27 | Japan | Hokkaido | 60717 | 1470 | 0 | 43.385711 | 142.55231799999999 | 2021-10-28 04:22:08 | Hokkaido, Japan | |||
538748 | 538748 | 2022-10-26 | Japan | Hokkaido | 816761 | 2701 | 0 | 43.385711 | 142.552318 | 2022-10-27 04:22:01 | Hokkaido, Japan | |||
542764 | 542764 | 2022-12-15 | Japan | Hokkaido | 1158847 | 3681 | 0 | 43.385711 | 142.552318 | 2022-12-16 04:21:01 | 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 | |||
558802 | 558802 | 2022-06-16 | Japan | Hokkaido | 373283 | 2082 | 0 | 43.385711 | 142.552318 | 2022-06-17 04:20:56 | 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 | |||
589639 | 589639 | 2021-08-08 | Japan | Hokkaido | 46765 | 1428 | 0 | 43.385711 | 142.552318 | 2021-08-09 04:21:24 | Hokkaido, Japan | |||
593654 | 593654 | 2022-07-01 | Japan | Hokkaido | 382401 | 2096 | 0 | 43.385711 | 142.552318 | 2022-07-02 04:21:16 | 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 | |||
617858 | 617858 | 2022-11-05 | Japan | Hokkaido | 871058 | 2776 | 0 | 43.385711 | 142.552318 | 2022-11-06 04:21:24 | Hokkaido, Japan | |||
621874 | 621874 | 2022-05-22 | Japan | Hokkaido | 350642 | 2051 | 0 | 43.385711 | 142.552318 | 2022-05-26 04:20:50 | Hokkaido, Japan | |||
629904 | 629904 | 2022-07-12 | Japan | Hokkaido | 390396 | 2102 | 0 | 43.385711 | 142.552318 | 2022-07-13 04:20:58 | 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 | |||
658310 | 658310 | 2022-05-13 | Japan | Hokkaido | 324181 | 2018 | 0 | 43.385711 | 142.552318 | 2022-05-14 04:20:48 | Hokkaido, Japan | |||
670295 | 670295 | 2022-07-21 | Japan | Hokkaido | 407678 | 2109 | 0 | 43.385711 | 142.552318 | 2022-07-22 04:21:15 | Hokkaido, Japan | |||
674311 | 674311 | 2022-07-30 | Japan | Hokkaido | 451557 | 2136 | 0 | 43.385711 | 142.552318 | 2022-07-31 04:21:02 | 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 | |||
690369 | 690369 | 2022-12-23 | Japan | Hokkaido | 1199266 | 3862 | 0 | 43.385711 | 142.552318 | 2022-12-24 04:21:02 | 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 | |||
710446 | 710446 | 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 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]);