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 = "Ishikawa" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1165182 | 1165182 | 2021-07-04 | Japan | Ishikawa | 3954 | 115 | 3799 | 40 | 36.769464 | 136.771027 | 2021-07-05 04:21:28 | Ishikawa, Japan | ||
1495616 | 1495616 | 2021-07-03 | Japan | Ishikawa | 3949 | 115 | 3796 | 38 | 36.769464 | 136.771027 | 2021-07-04 04:21:38 | Ishikawa, Japan | ||
2071931 | 2071931 | 2021-07-02 | Japan | Ishikawa | 3941 | 115 | 3792 | 34 | 36.769464 | 136.771027 | 2021-07-03 04:21:37 | Ishikawa, Japan | ||
2764947 | 2764947 | 2021-07-01 | Japan | Ishikawa | 3935 | 115 | 3786 | 34 | 36.769464 | 136.771027 | 2021-07-02 04:21:47 | Ishikawa, Japan | ||
1893155 | 1893155 | 2021-06-30 | Japan | Ishikawa | 3931 | 115 | 3781 | 35 | 36.769464 | 136.771027 | 2021-07-01 04:21:19 | Ishikawa, Japan | ||
400278 | 400278 | 2021-06-29 | Japan | Ishikawa | 3930 | 115 | 3770 | 45 | 36.769464 | 136.771027 | 2021-06-30 04:21:41 | Ishikawa, Japan | ||
3125521 | 3125521 | 2021-06-28 | Japan | Ishikawa | 3929 | 115 | 3768 | 46 | 36.769464 | 136.771027 | 2021-06-29 04:21:28 | Ishikawa, Japan | ||
2590016 | 2590016 | 2021-06-27 | Japan | Ishikawa | 3928 | 115 | 3764 | 49 | 36.769464 | 136.771027 | 2021-06-28 04:21:29 | Ishikawa, Japan | ||
3958520 | 3958520 | 2021-06-26 | Japan | Ishikawa | 3927 | 115 | 3760 | 52 | 36.769464 | 136.771027 | 2021-06-27 04:21:39 | Ishikawa, Japan | ||
1712339 | 1712339 | 2021-06-25 | Japan | Ishikawa | 3927 | 115 | 3756 | 56 | 36.769464 | 136.771027 | 2021-06-26 04:21:43 | Ishikawa, Japan | ||
2295464 | 2295464 | 2021-06-24 | Japan | Ishikawa | 3926 | 115 | 3743 | 68 | 36.769464 | 136.771027 | 2021-06-25 04:21:33 | Ishikawa, Japan | ||
2422904 | 2422904 | 2021-06-23 | Japan | Ishikawa | 3922 | 114 | 3730 | 78 | 36.769464 | 136.771027 | 2021-06-24 04:21:55 | Ishikawa, Japan | ||
562981 | 562981 | 2021-06-22 | Japan | Ishikawa | 3920 | 114 | 3729 | 77 | 36.769464 | 136.771027 | 2021-06-23 04:21:46 | Ishikawa, Japan | ||
3358683 | 3358683 | 2021-06-21 | Japan | Ishikawa | 3914 | 114 | 3725 | 75 | 36.769464 | 136.771027 | 2021-06-22 04:21:34 | Ishikawa, Japan | ||
2884382 | 2884382 | 2021-06-20 | Japan | Ishikawa | 3912 | 114 | 3717 | 81 | 36.769464 | 136.771027 | 2021-06-21 04:21:41 | Ishikawa, Japan | ||
107465 | 107465 | 2021-06-19 | Japan | Ishikawa | 3911 | 114 | 3708 | 89 | 36.769464 | 136.771027 | 2021-06-20 04:21:48 | Ishikawa, Japan | ||
1125608 | 1125608 | 2021-06-18 | Japan | Ishikawa | 3901 | 114 | 3694 | 93 | 36.769464 | 136.771027 | 2021-06-19 04:22:33 | Ishikawa, Japan | ||
2911186 | 2911186 | 2021-06-17 | Japan | Ishikawa | 3894 | 114 | 3684 | 96 | 36.769464 | 136.771027 | 2021-06-18 04:22:16 | Ishikawa, Japan | ||
3030304 | 3030304 | 2021-06-16 | Japan | Ishikawa | 3887 | 112 | 3668 | 107 | 36.769464 | 136.771027 | 2021-06-17 04:22:36 | Ishikawa, Japan | ||
2339410 | 2339410 | 2021-06-15 | Japan | Ishikawa | 3883 | 112 | 3655 | 116 | 36.769464 | 136.771027 | 2021-06-16 04:22:32 | Ishikawa, Japan | ||
1564106 | 1564106 | 2021-06-14 | Japan | Ishikawa | 3880 | 112 | 3642 | 126 | 36.769464 | 136.771027 | 2021-06-15 04:22:22 | Ishikawa, Japan | ||
3381389 | 3381389 | 2021-06-13 | Japan | Ishikawa | 3875 | 112 | 3633 | 130 | 36.769464 | 136.771027 | 2021-06-14 04:22:46 | Ishikawa, Japan | ||
1736523 | 1736523 | 2021-06-12 | Japan | Ishikawa | 3869 | 111 | 3600 | 158 | 36.769464 | 136.771027 | 2021-06-13 04:22:44 | Ishikawa, Japan | ||
3970564 | 3970564 | 2021-06-11 | Japan | Ishikawa | 3868 | 111 | 3600 | 157 | 36.769464 | 136.771027 | 2021-06-12 04:22:22 | Ishikawa, Japan | ||
2716986 | 2716986 | 2021-06-10 | Japan | Ishikawa | 3861 | 110 | 3556 | 195 | 36.769464 | 136.771027 | 2021-06-11 04:23:20 | Ishikawa, Japan | ||
522871 | 522871 | 2021-06-09 | Japan | Ishikawa | 3854 | 110 | 3529 | 215 | 36.769464 | 136.771027 | 2021-06-10 04:23:17 | Ishikawa, Japan | ||
3472311 | 3472311 | 2021-06-08 | Japan | Ishikawa | 3850 | 109 | 3505 | 236 | 36.769464 | 136.771027 | 2021-06-09 04:23:31 | Ishikawa, Japan | ||
3145595 | 3145595 | 2021-06-07 | Japan | Ishikawa | 3843 | 109 | 3472 | 262 | 36.769464 | 136.771027 | 2021-06-08 04:22:35 | Ishikawa, Japan | ||
825597 | 825597 | 2021-06-06 | Japan | Ishikawa | 3839 | 109 | 3443 | 287 | 36.769464 | 136.771027 | 2021-06-07 04:22:51 | Ishikawa, Japan | ||
2586002 | 2586002 | 2021-06-05 | Japan | Ishikawa | 3824 | 108 | 3377 | 339 | 36.769464 | 136.771027 | 2021-06-06 04:24:03 | Ishikawa, Japan | ||
2315316 | 2315316 | 2021-06-04 | Japan | Ishikawa | 3810 | 108 | 3344 | 358 | 36.769464 | 136.771027 | 2021-06-05 04:23:03 | Ishikawa, Japan | ||
1448601 | 1448601 | 2021-06-03 | Japan | Ishikawa | 3799 | 108 | 3305 | 386 | 36.769464 | 136.771027 | 2021-06-04 04:23:37 | Ishikawa, Japan | ||
1708325 | 1708325 | 2021-06-02 | Japan | Ishikawa | 3790 | 106 | 3242 | 442 | 36.769464 | 136.771027 | 2021-06-03 04:23:32 | Ishikawa, Japan | ||
2104143 | 2104143 | 2021-06-01 | Japan | Ishikawa | 3772 | 106 | 3200 | 466 | 36.769464 | 136.771027 | 2021-06-02 04:24:34 | Ishikawa, Japan | ||
1188759 | 1188759 | 2021-05-31 | Japan | Ishikawa | 3752 | 105 | 3162 | 485 | 36.769464 | 136.771027 | 2021-06-01 04:23:09 | Ishikawa, Japan | ||
3089436 | 3089436 | 2021-05-30 | Japan | Ishikawa | 3727 | 104 | 3138 | 485 | 36.769464 | 136.771027 | 2021-05-31 03:08:59 | Ishikawa, Japan | ||
50805 | 50805 | 2021-05-29 | Japan | Ishikawa | 3713 | 102 | 3106 | 505 | 36.769464 | 136.771027 | 2021-05-30 04:20:55 | Ishikawa, Japan | ||
20384 | 20384 | 2021-05-28 | Japan | Ishikawa | 3691 | 101 | 3042 | 548 | 36.769464 | 136.771027 | 2021-05-29 04:20:41 | Ishikawa, Japan | ||
1806759 | 1806759 | 2021-05-27 | Japan | Ishikawa | 3650 | 101 | 3012 | 537 | 36.769464 | 136.771027 | 2021-05-28 04:20:36 | Ishikawa, Japan | ||
1310183 | 1310183 | 2021-05-26 | Japan | Ishikawa | 3632 | 101 | 2941 | 590 | 36.769464 | 136.771027 | 2021-05-27 04:20:59 | Ishikawa, Japan | ||
83109 | 83109 | 2021-05-25 | Japan | Ishikawa | 3596 | 99 | 2886 | 611 | 36.769464 | 136.771027 | 2021-05-26 04:20:35 | Ishikawa, Japan | ||
1413071 | 1413071 | 2021-05-24 | Japan | Ishikawa | 3495 | 98 | 2857 | 540 | 36.769464 | 136.771027 | 2021-05-25 04:21:08 | Ishikawa, Japan | ||
1771357 | 1771357 | 2021-05-23 | Japan | Ishikawa | 3472 | 98 | 2821 | 553 | 36.769464 | 136.771027 | 2021-05-24 04:20:53 | Ishikawa, Japan | ||
726512 | 726512 | 2021-05-22 | Japan | Ishikawa | 3436 | 98 | 2765 | 573 | 36.769464 | 136.771027 | 2021-05-23 04:20:51 | Ishikawa, Japan | ||
1952527 | 1952527 | 2021-05-21 | Japan | Ishikawa | 3381 | 98 | 2715 | 568 | 36.769464 | 136.771027 | 2021-05-22 04:20:45 | Ishikawa, Japan | ||
1913226 | 1913226 | 2021-05-20 | Japan | Ishikawa | 3356 | 98 | 2650 | 608 | 36.769464 | 136.771027 | 2021-05-21 04:20:43 | Ishikawa, Japan | ||
2255747 | 2255747 | 2021-05-19 | Japan | Ishikawa | 3328 | 98 | 2594 | 636 | 36.769464 | 136.771027 | 2021-05-20 04:21:05 | Ishikawa, Japan | ||
2390785 | 2390785 | 2021-05-18 | Japan | Ishikawa | 3292 | 97 | 2542 | 653 | 36.769464 | 136.771027 | 2021-05-19 04:20:42 | Ishikawa, Japan | ||
3574610 | 3574610 | 2021-05-17 | Japan | Ishikawa | 3249 | 97 | 2489 | 663 | 36.769464 | 136.771027 | 2021-05-18 04:20:33 | Ishikawa, Japan | ||
2939340 | 2939340 | 2021-05-16 | Japan | Ishikawa | 3233 | 96 | 2447 | 690 | 36.769464 | 136.771027 | 2021-05-17 04:20:34 | Ishikawa, Japan | ||
1872970 | 1872970 | 2021-05-15 | Japan | Ishikawa | 3174 | 96 | 2421 | 657 | 36.769464 | 136.771027 | 2021-05-16 04:20:49 | Ishikawa, Japan | ||
1081939 | 1081939 | 2021-05-14 | Japan | Ishikawa | 3129 | 93 | 2385 | 651 | 36.769464 | 136.771027 | 2021-05-15 04:20:58 | Ishikawa, Japan | ||
3054205 | 3054205 | 2021-05-13 | Japan | Ishikawa | 3084 | 92 | 2355 | 637 | 36.769464 | 136.771027 | 2021-05-14 04:20:41 | Ishikawa, Japan | ||
2004675 | 2004675 | 2021-05-12 | Japan | Ishikawa | 3028 | 88 | 2325 | 615 | 36.769464 | 136.771027 | 2021-05-13 04:20:51 | Ishikawa, Japan | ||
3954506 | 3954506 | 2021-05-11 | Japan | Ishikawa | 2957 | 88 | 2294 | 575 | 36.769464 | 136.771027 | 2021-05-12 04:21:29 | Ishikawa, Japan | ||
2820785 | 2820785 | 2021-05-10 | Japan | Ishikawa | 2916 | 88 | 2273 | 555 | 36.769464 | 136.771027 | 2021-05-11 04:20:41 | Ishikawa, Japan | ||
1425117 | 1425117 | 2021-05-09 | Japan | Ishikawa | 2866 | 85 | 2248 | 533 | 36.769464 | 136.771027 | 2021-05-10 04:20:38 | Ishikawa, Japan | ||
1551985 | 1551985 | 2021-05-08 | Japan | Ishikawa | 2803 | 84 | 2225 | 494 | 36.769464 | 136.771027 | 2021-05-09 04:20:35 | Ishikawa, Japan | ||
2502043 | 2502043 | 2021-05-07 | Japan | Ishikawa | 2723 | 80 | 2193 | 450 | 36.769464 | 136.771027 | 2021-05-08 04:21:04 | Ishikawa, Japan | ||
3113499 | 3113499 | 2021-05-06 | Japan | Ishikawa | 2676 | 79 | 2193 | 404 | 36.769464 | 136.771027 | 2021-05-07 04:20:40 | Ishikawa, Japan | ||
645966 | 645966 | 2021-05-05 | Japan | Ishikawa | 2639 | 78 | 2172 | 389 | 36.769464 | 136.771027 | 2021-05-06 04:20:38 | Ishikawa, Japan | ||
3675666 | 3675666 | 2021-05-04 | Japan | Ishikawa | 2618 | 77 | 2157 | 384 | 36.769464 | 136.771027 | 2021-05-05 04:20:43 | Ishikawa, Japan | ||
2760933 | 2760933 | 2021-05-03 | Japan | Ishikawa | 2589 | 75 | 2118 | 396 | 36.769464 | 136.771027 | 2021-05-04 04:20:34 | Ishikawa, Japan | ||
2450786 | 2450786 | 2021-05-02 | Japan | Ishikawa | 2560 | 73 | 2118 | 369 | 36.769464 | 136.771027 | 2021-05-03 04:20:39 | Ishikawa, Japan | ||
2824799 | 2824799 | 2021-05-01 | Japan | Ishikawa | 2520 | 73 | 2084 | 363 | 36.769464 | 136.771027 | 2021-05-02 04:20:48 | Ishikawa, Japan | ||
380207 | 380207 | 2021-04-30 | Japan | Ishikawa | 2495 | 71 | 2084 | 340 | 36.769464 | 136.771027 | 2021-05-01 04:20:47 | Ishikawa, Japan | ||
1636330 | 1636330 | 2021-04-29 | Japan | Ishikawa | 2467 | 71 | 2069 | 327 | 36.769464 | 136.771027 | 2021-04-30 04:21:03 | Ishikawa, Japan | ||
3393409 | 3393409 | 2021-04-28 | Japan | Ishikawa | 2428 | 71 | 2039 | 318 | 36.769464 | 136.771027 | 2021-04-29 04:20:55 | Ishikawa, Japan | ||
3702125 | 3702125 | 2021-04-27 | Japan | Ishikawa | 2399 | 69 | 2039 | 291 | 36.769464 | 136.771027 | 2021-04-28 04:20:32 | Ishikawa, Japan | ||
888134 | 888134 | 2021-04-26 | Japan | Ishikawa | 2381 | 69 | 2019 | 293 | 36.769464 | 136.771027 | 2021-04-27 04:20:52 | Ishikawa, Japan | ||
954879 | 954879 | 2021-04-25 | Japan | Ishikawa | 2366 | 69 | 2005 | 292 | 36.769464 | 136.771027 | 2021-04-26 04:21:04 | Ishikawa, Japan | ||
3924026 | 3924026 | 2021-04-24 | Japan | Ishikawa | 2346 | 68 | 1987 | 291 | 36.769464 | 136.771027 | 2021-04-25 04:20:32 | Ishikawa, Japan | ||
1409057 | 1409057 | 2021-04-23 | Japan | Ishikawa | 2309 | 68 | 1971 | 270 | 36.769464 | 136.771027 | 2021-04-24 04:20:38 | Ishikawa, Japan | ||
1568120 | 1568120 | 2021-04-22 | Japan | Ishikawa | 2279 | 68 | 1959 | 252 | 36.769464 | 136.771027 | 2021-04-23 04:20:52 | Ishikawa, Japan | ||
3242341 | 3242341 | 2021-04-21 | Japan | Ishikawa | 2248 | 68 | 1949 | 231 | 36.769464 | 136.771027 | 2021-04-22 04:20:53 | Ishikawa, Japan | ||
2020737 | 2020737 | 2021-04-20 | Japan | Ishikawa | 2215 | 68 | 1935 | 212 | 36.769464 | 136.771027 | 2021-04-21 04:21:14 | Ishikawa, Japan | ||
2410858 | 2410858 | 2021-04-19 | Japan | Ishikawa | 2192 | 67 | 1921 | 204 | 36.769464 | 136.771027 | 2021-04-20 04:20:41 | Ishikawa, Japan | ||
3129535 | 3129535 | 2021-04-18 | Japan | Ishikawa | 2182 | 66 | 1914 | 202 | 36.769464 | 136.771027 | 2021-04-19 04:20:57 | Ishikawa, Japan | ||
982963 | 982963 | 2021-04-17 | Japan | Ishikawa | 2164 | 66 | 1904 | 194 | 36.769464 | 136.771027 | 2021-04-18 04:20:41 | Ishikawa, Japan | ||
170058 | 170058 | 2021-04-16 | Japan | Ishikawa | 2148 | 66 | 1889 | 193 | 36.769464 | 136.771027 | 2021-04-17 04:20:40 | Ishikawa, Japan | ||
2548889 | 2548889 | 2021-04-15 | Japan | Ishikawa | 2113 | 66 | 1883 | 164 | 36.769464 | 136.771027 | 2021-04-16 04:20:46 | Ishikawa, Japan | ||
1841959 | 1841959 | 2021-04-14 | Japan | Ishikawa | 2094 | 66 | 1877 | 151 | 36.769464 | 136.771027 | 2021-04-15 04:20:54 | Ishikawa, Japan | ||
2571693 | 2571693 | 2021-04-13 | Japan | Ishikawa | 2073 | 66 | 1867 | 140 | 36.769464 | 136.771027 | 2021-04-14 04:20:41 | Ishikawa, Japan | ||
36444 | 36444 | 2021-04-12 | Japan | Ishikawa | 2060 | 66 | 1854 | 140 | 36.769464 | 136.771027 | 2021-04-13 04:20:37 | Ishikawa, Japan | ||
3883603 | 3883603 | 2021-04-11 | Japan | Ishikawa | 2048 | 66 | 1842 | 140 | 36.769464 | 136.771027 | 2021-04-12 04:21:00 | Ishikawa, Japan | ||
2983271 | 2983271 | 2021-04-10 | Japan | Ishikawa | 2030 | 66 | 1833 | 131 | 36.769464 | 136.771027 | 2021-04-11 04:20:56 | Ishikawa, Japan | ||
605703 | 605703 | 2021-04-09 | Japan | Ishikawa | 2014 | 66 | 1833 | 115 | 36.769464 | 136.771027 | 2021-04-10 04:20:59 | Ishikawa, Japan | ||
2645767 | 2645767 | 2021-04-08 | Japan | Ishikawa | 1992 | 65 | 1831 | 96 | 36.769464 | 136.771027 | 2021-04-09 04:21:13 | Ishikawa, Japan | ||
2247409 | 2247409 | 2021-04-07 | Japan | Ishikawa | 1987 | 65 | 1829 | 93 | 36.769464 | 136.771027 | 2021-04-08 04:21:13 | Ishikawa, Japan | ||
3003319 | 3003319 | 2021-04-06 | Japan | Ishikawa | 1973 | 65 | 1829 | 79 | 36.769464 | 136.771027 | 2021-04-07 04:20:53 | Ishikawa, Japan | ||
3085314 | 3085314 | 2021-04-05 | Japan | Ishikawa | 1957 | 64 | 1827 | 66 | 36.769464 | 136.771027 | 2021-04-06 04:20:32 | Ishikawa, Japan | ||
388237 | 388237 | 2021-04-04 | Japan | Ishikawa | 1952 | 64 | 1825 | 63 | 36.769464 | 136.771027 | 2021-04-05 04:20:35 | Ishikawa, Japan | ||
3710153 | 3710153 | 2021-04-03 | Japan | Ishikawa | 1941 | 64 | 1824 | 53 | 36.769464 | 136.771027 | 2021-04-04 04:20:49 | Ishikawa, Japan | ||
241269 | 241269 | 2021-04-02 | Japan | Ishikawa | 1930 | 64 | 1824 | 42 | 36.769464 | 136.771027 | 2021-04-03 04:20:44 | Ishikawa, Japan | ||
1302066 | 1302066 | 2021-04-01 | Japan | Ishikawa | 1916 | 64 | 1824 | 28 | 36.769464 | 136.771027 | 2021-04-02 04:20:36 | Ishikawa, Japan | ||
637938 | 637938 | 2021-03-31 | Japan | Ishikawa | 1911 | 64 | 1824 | 23 | 36.769464 | 136.771027 | 2021-04-01 04:27:05 | Ishikawa, Japan | ||
3643567 | 3643567 | 2021-03-30 | Japan | Ishikawa | 1902 | 64 | 1823 | 15 | 36.769464 | 136.771027 | 2021-03-31 04:26:25 | Ishikawa, Japan | ||
1290020 | 1290020 | 2021-03-29 | Japan | Ishikawa | 1901 | 64 | 1823 | 14 | 36.769464 | 136.771027 | 2021-03-30 04:26:23 | Ishikawa, Japan | ||
1535942 | 1535942 | 2021-03-28 | Japan | Ishikawa | 1901 | 64 | 1816 | 21 | 36.769464 | 136.771027 | 2021-03-29 04:28:35 | Ishikawa, Japan | ||
1219582 | 1219582 | 2021-03-27 | Japan | Ishikawa | 1901 | 64 | 1816 | 21 | 36.769464 | 136.771027 | 2021-03-28 05:28:10 | Ishikawa, 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]);