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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1491600 | 1491600 | 2021-10-12 | Japan | Ishikawa | 7919 | 128 | 0 | 36.769464 | 136.771027 | 2021-10-13 04:20:51 | Ishikawa, Japan | |||
3007333 | 3007333 | 2021-10-11 | Japan | Ishikawa | 7918 | 127 | 0 | 36.769464 | 136.771027 | 2021-10-12 04:21:09 | Ishikawa, Japan | |||
423349 | 423349 | 2021-10-10 | Japan | Ishikawa | 7916 | 125 | 0 | 36.769464 | 136.771027 | 2021-10-11 04:21:31 | Ishikawa, Japan | |||
2876206 | 2876206 | 2021-10-09 | Japan | Ishikawa | 7914 | 124 | 0 | 36.769464 | 136.771027 | 2021-10-10 04:21:38 | Ishikawa, Japan | |||
2959372 | 2959372 | 2021-10-08 | Japan | Ishikawa | 7912 | 124 | 0 | 36.769464 | 136.771027 | 2021-10-09 04:21:34 | Ishikawa, Japan | |||
467410 | 467410 | 2021-10-07 | Japan | Ishikawa | 7911 | 124 | 0 | 36.769464 | 136.771027 | 2021-10-08 04:21:25 | Ishikawa, Japan | |||
2458790 | 2458790 | 2021-10-06 | Japan | Ishikawa | 7910 | 124 | 0 | 36.769464 | 136.771027 | 2021-10-07 04:21:36 | Ishikawa, Japan | |||
3832484 | 3832484 | 2021-10-05 | Japan | Ishikawa | 7910 | 124 | 0 | 36.769464 | 136.771027 | 2021-10-06 04:21:33 | Ishikawa, Japan | |||
986977 | 986977 | 2021-10-04 | Japan | Ishikawa | 7902 | 124 | 0 | 36.769464 | 136.771027 | 2021-10-05 04:21:27 | Ishikawa, Japan | |||
1274287 | 1274287 | 2021-10-03 | Japan | Ishikawa | 7900 | 124 | 0 | 36.769464 | 136.771027 | 2021-10-04 04:21:31 | Ishikawa, Japan | |||
3928040 | 3928040 | 2021-10-02 | Japan | Ishikawa | 7891 | 124 | 0 | 36.769464 | 136.771027 | 2021-10-03 04:21:24 | Ishikawa, Japan | |||
2132020 | 2132020 | 2021-10-01 | Japan | Ishikawa | 7876 | 124 | 0 | 36.769464 | 136.771027 | 2021-10-02 04:21:25 | Ishikawa, Japan | |||
2772977 | 2772977 | 2021-09-30 | Japan | Ishikawa | 7846 | 124 | 0 | 36.769464 | 136.771027 | 2021-10-01 04:21:35 | Ishikawa, Japan | |||
706433 | 706433 | 2021-09-29 | Japan | Ishikawa | 7833 | 124 | 0 | 36.769464 | 136.771027 | 2021-09-30 04:21:20 | Ishikawa, Japan | |||
1334275 | 1334275 | 2021-09-28 | Japan | Ishikawa | 7825 | 124 | 0 | 36.769464 | 136.771027 | 2021-09-29 04:21:45 | Ishikawa, Japan | |||
1235644 | 1235644 | 2021-09-27 | Japan | Ishikawa | 7813 | 123 | 0 | 36.769464 | 136.771027 | 2021-09-28 04:21:28 | Ishikawa, Japan | |||
2075945 | 2075945 | 2021-09-26 | Japan | Ishikawa | 7810 | 123 | 0 | 36.769464 | 136.771027 | 2021-09-27 04:21:16 | Ishikawa, Japan | |||
1724497 | 1724497 | 2021-09-25 | Japan | Ishikawa | 7800 | 123 | 0 | 36.769464 | 136.771027 | 2021-09-26 04:21:29 | Ishikawa, Japan | |||
1921217 | 1921217 | 2021-09-24 | Japan | Ishikawa | 7789 | 123 | 0 | 36.769464 | 136.771027 | 2021-09-25 04:21:31 | Ishikawa, Japan | |||
601688 | 601688 | 2021-09-23 | Japan | Ishikawa | 7782 | 123 | 0 | 36.769464 | 136.771027 | 2021-09-24 04:21:44 | Ishikawa, Japan | |||
3011349 | 3011349 | 2021-09-22 | Japan | Ishikawa | 7774 | 123 | 0 | 36.769464 | 136.771027 | 2021-09-23 04:21:43 | Ishikawa, Japan | |||
3757487 | 3757487 | 2021-09-21 | Japan | Ishikawa | 7762 | 123 | 0 | 36.769464 | 136.771027 | 2021-09-22 04:21:45 | Ishikawa, Japan | |||
809590 | 809590 | 2021-09-20 | Japan | Ishikawa | 7754 | 123 | 0 | 36.769464 | 136.771027 | 2021-09-21 04:21:26 | Ishikawa, Japan | |||
1814789 | 1814789 | 2021-09-19 | Japan | Ishikawa | 7740 | 123 | 0 | 36.769464 | 136.771027 | 2021-09-20 04:21:22 | Ishikawa, Japan | |||
16369 | 16369 | 2021-09-18 | Japan | Ishikawa | 7727 | 123 | 0 | 36.769464 | 136.771027 | 2021-09-19 04:21:34 | Ishikawa, Japan | |||
2618054 | 2618054 | 2021-09-17 | Japan | Ishikawa | 7708 | 123 | 0 | 36.769464 | 136.771027 | 2021-09-18 04:21:24 | Ishikawa, Japan | |||
2808762 | 2808762 | 2021-09-16 | Japan | Ishikawa | 7694 | 123 | 0 | 36.769464 | 136.771027 | 2021-09-17 04:21:46 | Ishikawa, Japan | |||
1374507 | 1374507 | 2021-09-15 | Japan | Ishikawa | 7675 | 123 | 0 | 36.769464 | 136.771027 | 2021-09-16 04:22:19 | Ishikawa, Japan | |||
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 |
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]);