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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2462806 | 2462806 | 2021-09-14 | Japan | Ishikawa | 7647 | 123 | 0 | 36.769464 | 136.771027 | 2021-09-15 03:22:37 | Ishikawa, Japan | |||
1385645 | 1385645 | 2021-09-13 | Japan | Ishikawa | 7624 | 123 | 0 | 36.769464 | 136.771027 | 2021-09-14 04:21:41 | Ishikawa, Japan | |||
1885014 | 1885014 | 2021-09-12 | Japan | Ishikawa | 7609 | 123 | 0 | 36.769464 | 136.771027 | 2021-09-13 04:21:15 | Ishikawa, Japan | |||
3805917 | 3805917 | 2021-09-11 | Japan | Ishikawa | 7587 | 123 | 0 | 36.769464 | 136.771027 | 2021-09-12 04:21:13 | Ishikawa, Japan | |||
3448857 | 3448857 | 2021-09-10 | Japan | Ishikawa | 7552 | 123 | 0 | 36.769464 | 136.771027 | 2021-09-11 04:21:30 | Ishikawa, Japan | |||
1262803 | 1262803 | 2021-09-09 | Japan | Ishikawa | 7522 | 123 | 0 | 36.769464 | 136.771027 | 2021-09-10 04:21:20 | Ishikawa, Japan | |||
2279173 | 2279173 | 2021-09-08 | Japan | Ishikawa | 7494 | 123 | 0 | 36.769464 | 136.771027 | 2021-09-09 04:21:27 | Ishikawa, Japan | |||
641952 | 641952 | 2021-09-07 | Japan | Ishikawa | 7476 | 123 | 0 | 36.769464 | 136.771027 | 2021-09-08 04:21:31 | Ishikawa, Japan | |||
3194015 | 3194015 | 2021-09-06 | Japan | Ishikawa | 7451 | 123 | 0 | 36.769464 | 136.771027 | 2021-09-07 04:21:35 | Ishikawa, Japan | |||
3280883 | 3280883 | 2021-09-05 | Japan | Ishikawa | 7434 | 123 | 0 | 36.769464 | 136.771027 | 2021-09-06 04:21:22 | Ishikawa, Japan | |||
249297 | 249297 | 2021-09-04 | Japan | Ishikawa | 7414 | 123 | 0 | 36.769464 | 136.771027 | 2021-09-05 04:21:33 | Ishikawa, Japan | |||
3974578 | 3974578 | 2021-09-03 | Japan | Ishikawa | 7389 | 123 | 0 | 36.769464 | 136.771027 | 2021-09-04 04:21:28 | Ishikawa, Japan | |||
178040 | 178040 | 2021-09-02 | Japan | Ishikawa | 7356 | 123 | 0 | 36.769464 | 136.771027 | 2021-09-03 04:21:20 | Ishikawa, Japan | |||
67075 | 67075 | 2021-09-01 | Japan | Ishikawa | 7315 | 123 | 0 | 36.769464 | 136.771027 | 2021-09-02 04:21:15 | Ishikawa, Japan | |||
2067917 | 2067917 | 2021-08-31 | Japan | Ishikawa | 7251 | 123 | 0 | 36.769464 | 136.771027 | 2021-09-01 04:21:38 | Ishikawa, Japan | |||
1775371 | 1775371 | 2021-08-30 | Japan | Ishikawa | 7211 | 123 | 0 | 36.769464 | 136.771027 | 2021-08-31 04:21:46 | Ishikawa, Japan | |||
3891945 | 3891945 | 2021-08-29 | Japan | Ishikawa | 7185 | 123 | 0 | 36.769464 | 136.771027 | 2021-08-30 04:21:23 | Ishikawa, Japan | |||
2793048 | 2793048 | 2021-08-28 | Japan | Ishikawa | 7127 | 123 | 0 | 36.769464 | 136.771027 | 2021-08-29 04:21:14 | Ishikawa, Japan | |||
2923207 | 2923207 | 2021-08-27 | Japan | Ishikawa | 7068 | 123 | 0 | 36.769464 | 136.771027 | 2021-08-28 04:21:28 | Ishikawa, Japan | |||
1596221 | 1596221 | 2021-08-26 | Japan | Ishikawa | 7004 | 123 | 0 | 36.769464 | 136.771027 | 2021-08-27 04:21:37 | Ishikawa, Japan | |||
32430 | 32430 | 2021-08-25 | Japan | Ishikawa | 6948 | 123 | 0 | 36.769464 | 136.771027 | 2021-08-26 04:21:28 | Ishikawa, Japan | |||
3105469 | 3105469 | 2021-08-24 | Japan | Ishikawa | 6881 | 121 | 0 | 36.769464 | 136.771027 | 2021-08-25 04:21:41 | Ishikawa, Japan | |||
3165640 | 3165640 | 2021-08-23 | Japan | Ishikawa | 6811 | 121 | 0 | 36.769464 | 136.771027 | 2021-08-24 04:21:19 | Ishikawa, Japan | |||
2175567 | 2175567 | 2021-08-22 | Japan | Ishikawa | 6763 | 121 | 0 | 36.769464 | 136.771027 | 2021-08-23 04:21:27 | Ishikawa, Japan | |||
3555663 | 3555663 | 2021-08-21 | Japan | Ishikawa | 6697 | 121 | 0 | 36.769464 | 136.771027 | 2021-08-22 04:21:29 | Ishikawa, Japan | |||
1854005 | 1854005 | 2021-08-20 | Japan | Ishikawa | 6628 | 121 | 0 | 36.769464 | 136.771027 | 2021-08-21 04:21:38 | Ishikawa, Japan | |||
511712 | 511712 | 2021-08-19 | Japan | Ishikawa | 6546 | 121 | 0 | 36.769464 | 136.771027 | 2021-08-20 04:21:33 | Ishikawa, Japan | |||
2518191 | 2518191 | 2021-08-18 | Japan | Ishikawa | 6463 | 120 | 0 | 36.769464 | 136.771027 | 2021-08-19 04:21:15 | Ishikawa, Japan | |||
245283 | 245283 | 2021-08-17 | Japan | Ishikawa | 6374 | 120 | 0 | 36.769464 | 136.771027 | 2021-08-18 04:21:35 | Ishikawa, Japan | |||
1604246 | 1604246 | 2021-08-16 | Japan | Ishikawa | 6308 | 120 | 0 | 36.769464 | 136.771027 | 2021-08-17 04:21:49 | Ishikawa, Japan | |||
103340 | 103340 | 2021-08-15 | Japan | Ishikawa | 6262 | 120 | 0 | 36.769464 | 136.771027 | 2021-08-16 04:21:31 | Ishikawa, Japan | |||
507698 | 507698 | 2021-08-14 | Japan | Ishikawa | 6188 | 120 | 0 | 36.769464 | 136.771027 | 2021-08-15 04:21:41 | Ishikawa, Japan | |||
1483570 | 1483570 | 2021-08-13 | Japan | Ishikawa | 6102 | 119 | 0 | 36.769464 | 136.771027 | 2021-08-14 04:21:25 | Ishikawa, Japan | |||
2899700 | 2899700 | 2021-08-12 | Japan | Ishikawa | 6009 | 119 | 0 | 36.769464 | 136.771027 | 2021-08-13 04:21:24 | Ishikawa, Japan | |||
1342304 | 1342304 | 2021-08-11 | Japan | Ishikawa | 5911 | 119 | 0 | 36.769464 | 136.771027 | 2021-08-12 04:21:25 | Ishikawa, Japan | |||
2351451 | 2351451 | 2021-08-10 | Japan | Ishikawa | 5836 | 119 | 0 | 36.769464 | 136.771027 | 2021-08-11 04:21:58 | Ishikawa, Japan | |||
649980 | 649980 | 2021-08-09 | Japan | Ishikawa | 5803 | 119 | 0 | 36.769464 | 136.771027 | 2021-08-10 04:21:27 | Ishikawa, Japan | |||
589642 | 589642 | 2021-08-08 | Japan | Ishikawa | 5732 | 118 | 0 | 36.769464 | 136.771027 | 2021-08-09 04:21:24 | Ishikawa, Japan | |||
2203654 | 2203654 | 2021-08-07 | Japan | Ishikawa | 5677 | 118 | 0 | 36.769464 | 136.771027 | 2021-08-08 04:21:33 | Ishikawa, Japan | |||
1117604 | 1117604 | 2021-08-06 | Japan | Ishikawa | 5595 | 118 | 0 | 36.769464 | 136.771027 | 2021-08-07 04:21:30 | Ishikawa, Japan | |||
1956541 | 1956541 | 2021-08-05 | Japan | Ishikawa | 5517 | 118 | 0 | 36.769464 | 136.771027 | 2021-08-06 04:21:18 | Ishikawa, Japan | |||
331920 | 331920 | 2021-08-04 | Japan | Ishikawa | 5444 | 118 | 4338 | 988 | 36.769464 | 136.771027 | 2021-08-05 04:21:51 | Ishikawa, Japan | ||
3468191 | 3468191 | 2021-08-03 | Japan | Ishikawa | 5326 | 118 | 4289 | 919 | 36.769464 | 136.771027 | 2021-08-04 04:21:25 | Ishikawa, Japan | ||
3683465 | 3683465 | 2021-08-02 | Japan | Ishikawa | 5241 | 118 | 4199 | 924 | 36.769464 | 136.771027 | 2021-08-03 04:21:39 | Ishikawa, Japan | ||
3015364 | 3015364 | 2021-08-01 | Japan | Ishikawa | 5185 | 118 | 4199 | 868 | 36.769464 | 136.771027 | 2021-08-02 04:21:36 | Ishikawa, Japan | ||
3903987 | 3903987 | 2021-07-31 | Japan | Ishikawa | 5104 | 118 | 4148 | 838 | 36.769464 | 136.771027 | 2021-08-01 04:21:50 | Ishikawa, Japan | ||
3296192 | 3296192 | 2021-07-30 | Japan | Ishikawa | 5014 | 118 | 4125 | 771 | 36.769464 | 136.771027 | 2021-07-31 04:21:35 | Ishikawa, Japan | ||
3385403 | 3385403 | 2021-07-29 | Japan | Ishikawa | 4904 | 117 | 4092 | 695 | 36.769464 | 136.771027 | 2021-07-30 04:21:34 | Ishikawa, Japan | ||
408308 | 408308 | 2021-07-28 | Japan | Ishikawa | 4811 | 116 | 4072 | 623 | 36.769464 | 136.771027 | 2021-07-29 04:21:33 | Ishikawa, Japan | ||
1306169 | 1306169 | 2021-07-27 | Japan | Ishikawa | 4692 | 116 | 4033 | 543 | 36.769464 | 136.771027 | 2021-07-28 04:21:39 | Ishikawa, Japan | ||
3218312 | 3218312 | 2021-07-26 | Japan | Ishikawa | 4620 | 116 | 4004 | 500 | 36.769464 | 136.771027 | 2021-07-27 04:21:18 | Ishikawa, Japan | ||
1378521 | 1378521 | 2021-07-25 | Japan | Ishikawa | 4541 | 116 | 3982 | 443 | 36.769464 | 136.771027 | 2021-07-26 04:21:28 | Ishikawa, Japan | ||
1330261 | 1330261 | 2021-07-24 | Japan | Ishikawa | 4470 | 116 | 3958 | 396 | 36.769464 | 136.771027 | 2021-07-25 04:22:12 | Ishikawa, Japan | ||
3137565 | 3137565 | 2021-07-23 | Japan | Ishikawa | 4435 | 116 | 3939 | 380 | 36.769464 | 136.771027 | 2021-07-24 00:21:36 | Ishikawa, Japan | ||
3476325 | 3476325 | 2021-07-22 | Japan | Ishikawa | 4388 | 116 | 3922 | 350 | 36.769464 | 136.771027 | 2021-07-23 04:21:29 | Ishikawa, Japan | ||
3331544 | 3331544 | 2021-07-21 | Japan | Ishikawa | 4326 | 116 | 3899 | 311 | 36.769464 | 136.771027 | 2021-07-22 04:21:19 | Ishikawa, Japan | ||
2371525 | 2371525 | 2021-07-20 | Japan | Ishikawa | 4260 | 115 | 3869 | 276 | 36.769464 | 136.771027 | 2021-07-21 04:21:40 | Ishikawa, Japan | ||
483604 | 483604 | 2021-07-19 | Japan | Ishikawa | 4237 | 115 | 3859 | 263 | 36.769464 | 136.771027 | 2021-07-20 04:21:48 | Ishikawa, Japan | ||
2673827 | 2673827 | 2021-07-18 | Japan | Ishikawa | 4212 | 115 | 3847 | 250 | 36.769464 | 136.771027 | 2021-07-19 04:21:24 | Ishikawa, Japan | ||
3706139 | 3706139 | 2021-07-17 | Japan | Ishikawa | 4189 | 115 | 3842 | 232 | 36.769464 | 136.771027 | 2021-07-18 04:22:07 | Ishikawa, Japan | ||
2947370 | 2947370 | 2021-07-16 | Japan | Ishikawa | 4156 | 115 | 3841 | 200 | 36.769464 | 136.771027 | 2021-07-17 04:22:22 | Ishikawa, Japan | ||
296026 | 296026 | 2021-07-15 | Japan | Ishikawa | 4115 | 115 | 3834 | 166 | 36.769464 | 136.771027 | 2021-07-16 04:21:22 | Ishikawa, Japan | ||
3631971 | 3631971 | 2021-07-14 | Japan | Ishikawa | 4094 | 115 | 3826 | 153 | 36.769464 | 136.771027 | 2021-07-15 04:21:48 | Ishikawa, Japan | ||
578846 | 578846 | 2021-07-13 | Japan | Ishikawa | 4061 | 115 | 3825 | 121 | 36.769464 | 136.771027 | 2021-07-14 04:21:35 | Ishikawa, Japan | ||
3741095 | 3741095 | 2021-07-12 | Japan | Ishikawa | 4045 | 115 | 3820 | 110 | 36.769464 | 136.771027 | 2021-07-13 04:21:18 | Ishikawa, Japan | ||
3659608 | 3659608 | 2021-07-11 | Japan | Ishikawa | 4034 | 115 | 3810 | 109 | 36.769464 | 136.771027 | 2021-07-12 04:21:34 | Ishikawa, Japan | ||
625892 | 625892 | 2021-07-10 | Japan | Ishikawa | 4023 | 115 | 3810 | 98 | 36.769464 | 136.771027 | 2021-07-11 04:21:43 | Ishikawa, Japan | ||
829611 | 829611 | 2021-07-09 | Japan | Ishikawa | 4008 | 115 | 3808 | 85 | 36.769464 | 136.771027 | 2021-07-10 04:21:25 | Ishikawa, Japan | ||
778375 | 778375 | 2021-07-08 | Japan | Ishikawa | 3994 | 115 | 3808 | 71 | 36.769464 | 136.771027 | 2021-07-09 04:21:21 | Ishikawa, Japan | ||
1440597 | 1440597 | 2021-07-07 | Japan | Ishikawa | 3981 | 115 | 3802 | 64 | 36.769464 | 136.771027 | 2021-07-08 04:21:26 | Ishikawa, Japan | ||
2693702 | 2693702 | 2021-07-06 | Japan | Ishikawa | 3972 | 115 | 3801 | 56 | 36.769464 | 136.771027 | 2021-07-07 04:21:20 | Ishikawa, Japan | ||
1932451 | 1932451 | 2021-07-05 | Japan | Ishikawa | 3965 | 115 | 3801 | 49 | 36.769464 | 136.771027 | 2021-07-06 04:21:32 | Ishikawa, Japan | ||
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 |
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]);