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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2016722 | 2016722 | 2022-09-20 | Japan | Ishikawa | 156662 | 276 | 0 | 36.769464 | 136.771027 | 2022-09-21 04:23:22 | Ishikawa, Japan | |||
3570595 | 3570595 | 2022-09-19 | Japan | Ishikawa | 156379 | 276 | 0 | 36.769464 | 136.771027 | 2022-09-20 04:22:48 | Ishikawa, Japan | |||
419334 | 419334 | 2022-09-18 | Japan | Ishikawa | 155904 | 276 | 0 | 36.769464 | 136.771027 | 2022-09-19 04:21:49 | Ishikawa, Japan | |||
3373358 | 3373358 | 2022-09-17 | Japan | Ishikawa | 155231 | 275 | 0 | 36.769464 | 136.771027 | 2022-09-18 04:22:50 | Ishikawa, Japan | |||
2355466 | 2355466 | 2022-09-16 | Japan | Ishikawa | 154573 | 273 | 0 | 36.769464 | 136.771027 | 2022-09-17 04:20:19 | Ishikawa, Japan | |||
3986623 | 3986623 | 2022-09-15 | Japan | Ishikawa | 153852 | 273 | 0 | 36.769464 | 136.771027 | 2022-09-16 04:21:19 | Ishikawa, Japan | |||
1889140 | 1889140 | 2022-09-14 | Japan | Ishikawa | 152907 | 271 | 0 | 36.769464 | 136.771027 | 2022-09-15 04:21:02 | Ishikawa, Japan | |||
372195 | 372195 | 2022-09-13 | Japan | Ishikawa | 151873 | 270 | 0 | 36.769464 | 136.771027 | 2022-09-14 04:20:44 | Ishikawa, Japan | |||
2394800 | 2394800 | 2022-09-12 | Japan | Ishikawa | 151488 | 264 | 0 | 36.769464 | 136.771027 | 2022-09-13 04:20:57 | Ishikawa, Japan | |||
3765878 | 3765878 | 2022-09-11 | Japan | Ishikawa | 150759 | 263 | 0 | 36.769464 | 136.771027 | 2022-09-12 04:20:58 | Ishikawa, Japan | |||
3824453 | 3824453 | 2022-09-10 | Japan | Ishikawa | 149837 | 262 | 0 | 36.769464 | 136.771027 | 2022-09-11 04:20:50 | Ishikawa, Japan | |||
962910 | 962910 | 2022-09-09 | Japan | Ishikawa | 148913 | 260 | 0 | 36.769464 | 136.771027 | 2022-09-10 04:21:10 | Ishikawa, Japan | |||
253312 | 253312 | 2022-09-08 | Japan | Ishikawa | 147918 | 259 | 0 | 36.769464 | 136.771027 | 2022-09-09 04:21:11 | Ishikawa, Japan | |||
3745110 | 3745110 | 2022-09-07 | Japan | Ishikawa | 146634 | 258 | 0 | 36.769464 | 136.771027 | 2022-09-08 04:21:02 | Ishikawa, Japan | |||
114750 | 114750 | 2022-09-06 | Japan | Ishikawa | 145143 | 256 | 0 | 36.769464 | 136.771027 | 2022-09-07 04:20:59 | Ishikawa, Japan | |||
2633722 | 2633722 | 2022-09-05 | Japan | Ishikawa | 144558 | 255 | 0 | 36.769464 | 136.771027 | 2022-09-06 04:21:02 | Ishikawa, Japan | |||
2987286 | 2987286 | 2022-09-04 | Japan | Ishikawa | 143543 | 254 | 0 | 36.769464 | 136.771027 | 2022-09-05 04:21:01 | Ishikawa, Japan | |||
2712971 | 2712971 | 2022-09-03 | Japan | Ishikawa | 142252 | 250 | 0 | 36.769464 | 136.771027 | 2022-09-04 04:21:22 | Ishikawa, Japan | |||
1393676 | 1393676 | 2022-09-02 | Japan | Ishikawa | 140971 | 243 | 0 | 36.769464 | 136.771027 | 2022-09-03 04:21:04 | Ishikawa, Japan | |||
3547505 | 3547505 | 2022-09-01 | Japan | Ishikawa | 139515 | 240 | 0 | 36.769464 | 136.771027 | 2022-09-02 04:21:07 | Ishikawa, Japan | |||
2343425 | 2343425 | 2022-08-31 | Japan | Ishikawa | 137620 | 237 | 0 | 36.769464 | 136.771027 | 2022-09-01 04:21:03 | Ishikawa, Japan | |||
3773905 | 3773905 | 2022-08-30 | Japan | Ishikawa | 135535 | 233 | 0 | 36.769464 | 136.771027 | 2022-08-31 04:20:57 | Ishikawa, Japan | |||
1680501 | 1680501 | 2022-08-29 | Japan | Ishikawa | 134844 | 226 | 0 | 36.769464 | 136.771027 | 2022-08-30 04:21:03 | Ishikawa, Japan | |||
1876985 | 1876985 | 2022-08-28 | Japan | Ishikawa | 133373 | 226 | 0 | 36.769464 | 136.771027 | 2022-08-29 04:21:06 | Ishikawa, Japan | |||
2096112 | 2096112 | 2022-08-27 | Japan | Ishikawa | 131400 | 223 | 0 | 36.769464 | 136.771027 | 2022-08-28 04:21:02 | Ishikawa, Japan | |||
1531927 | 1531927 | 2022-08-26 | Japan | Ishikawa | 129463 | 222 | 0 | 36.769464 | 136.771027 | 2022-08-27 04:20:57 | Ishikawa, Japan | |||
2828814 | 2828814 | 2022-08-25 | Japan | Ishikawa | 127431 | 222 | 0 | 36.769464 | 136.771027 | 2022-08-26 04:21:02 | Ishikawa, Japan | |||
2323347 | 2323347 | 2022-08-24 | Japan | Ishikawa | 124736 | 217 | 0 | 36.769464 | 136.771027 | 2022-08-25 04:21:13 | Ishikawa, Japan | |||
1250756 | 1250756 | 2022-08-23 | Japan | Ishikawa | 122104 | 216 | 0 | 36.769464 | 136.771027 | 2022-08-24 04:20:46 | Ishikawa, Japan | |||
2852860 | 2852860 | 2022-08-22 | Japan | Ishikawa | 121243 | 215 | 0 | 36.769464 | 136.771027 | 2022-08-23 04:20:56 | Ishikawa, Japan | |||
2402832 | 2402832 | 2022-08-21 | Japan | Ishikawa | 119218 | 215 | 0 | 36.769464 | 136.771027 | 2022-08-22 04:20:38 | Ishikawa, Japan | |||
3797910 | 3797910 | 2022-08-20 | Japan | Ishikawa | 116588 | 215 | 0 | 36.769464 | 136.771027 | 2022-08-21 04:20:44 | Ishikawa, Japan | |||
2363496 | 2363496 | 2022-08-19 | Japan | Ishikawa | 113945 | 214 | 0 | 36.769464 | 136.771027 | 2022-08-20 04:21:01 | Ishikawa, Japan | |||
1161167 | 1161167 | 2022-08-18 | Japan | Ishikawa | 111060 | 213 | 0 | 36.769464 | 136.771027 | 2022-08-19 04:20:54 | Ishikawa, Japan | |||
3950491 | 3950491 | 2022-08-17 | Japan | Ishikawa | 108717 | 213 | 0 | 36.769464 | 136.771027 | 2022-08-18 04:21:11 | Ishikawa, Japan | |||
990993 | 990993 | 2022-08-16 | Japan | Ishikawa | 107422 | 212 | 0 | 36.769464 | 136.771027 | 2022-08-17 04:20:59 | Ishikawa, Japan | |||
2494032 | 2494032 | 2022-08-15 | Japan | Ishikawa | 106360 | 212 | 0 | 36.769464 | 136.771027 | 2022-08-16 04:20:58 | Ishikawa, Japan | |||
3647582 | 3647582 | 2022-08-14 | Japan | Ishikawa | 104625 | 211 | 0 | 36.769464 | 136.771027 | 2022-08-15 04:20:59 | Ishikawa, Japan | |||
1968588 | 1968588 | 2022-08-13 | Japan | Ishikawa | 102630 | 211 | 0 | 36.769464 | 136.771027 | 2022-08-14 04:20:55 | Ishikawa, Japan | |||
2888397 | 2888397 | 2022-08-12 | Japan | Ishikawa | 101711 | 209 | 0 | 36.769464 | 136.771027 | 2022-08-13 04:20:52 | Ishikawa, Japan | |||
3908002 | 3908002 | 2022-08-11 | Japan | Ishikawa | 99669 | 208 | 0 | 36.769464 | 136.771027 | 2022-08-12 04:20:54 | Ishikawa, Japan | |||
1346319 | 1346319 | 2022-08-10 | Japan | Ishikawa | 97404 | 207 | 0 | 36.769464 | 136.771027 | 2022-08-11 04:20:49 | Ishikawa, Japan | |||
1086074 | 1086074 | 2022-08-09 | Japan | Ishikawa | 95257 | 207 | 0 | 36.769464 | 136.771027 | 2022-08-10 04:20:57 | Ishikawa, Japan | |||
3543489 | 3543489 | 2022-08-08 | Japan | Ishikawa | 94566 | 207 | 0 | 36.769464 | 136.771027 | 2022-08-09 04:20:34 | Ishikawa, Japan | |||
1069892 | 1069892 | 2022-08-07 | Japan | Ishikawa | 93070 | 204 | 0 | 36.769464 | 136.771027 | 2022-08-08 04:21:08 | Ishikawa, Japan | |||
1940480 | 1940480 | 2022-08-06 | Japan | Ishikawa | 91416 | 204 | 0 | 36.769464 | 136.771027 | 2022-08-07 04:20:54 | Ishikawa, Japan | |||
880279 | 880279 | 2022-08-05 | Japan | Ishikawa | 90013 | 204 | 0 | 36.769464 | 136.771027 | 2022-08-06 04:20:56 | Ishikawa, Japan | |||
2008690 | 2008690 | 2022-08-04 | Japan | Ishikawa | 88367 | 202 | 0 | 36.769464 | 136.771027 | 2022-08-05 04:20:52 | Ishikawa, Japan | |||
1098117 | 1098117 | 2022-08-03 | Japan | Ishikawa | 86536 | 202 | 0 | 36.769464 | 136.771027 | 2022-08-04 04:20:58 | Ishikawa, Japan | |||
1405042 | 1405042 | 2022-08-02 | Japan | Ishikawa | 84775 | 201 | 0 | 36.769464 | 136.771027 | 2022-08-03 04:20:59 | Ishikawa, Japan | |||
3617080 | 3617080 | 2022-08-01 | Japan | Ishikawa | 84221 | 201 | 0 | 36.769464 | 136.771027 | 2022-08-02 04:20:53 | Ishikawa, Japan | |||
3871560 | 3871560 | 2022-07-31 | Japan | Ishikawa | 83032 | 201 | 0 | 36.769464 | 136.771027 | 2022-08-01 04:21:03 | Ishikawa, Japan | |||
674314 | 674314 | 2022-07-30 | Japan | Ishikawa | 81554 | 201 | 0 | 36.769464 | 136.771027 | 2022-07-31 04:21:02 | Ishikawa, Japan | |||
1783513 | 1783513 | 2022-07-29 | Japan | Ishikawa | 80022 | 201 | 0 | 36.769464 | 136.771027 | 2022-07-30 04:20:42 | Ishikawa, Japan | |||
1065876 | 1065876 | 2022-07-28 | Japan | Ishikawa | 78438 | 200 | 0 | 36.769464 | 136.771027 | 2022-07-29 04:20:45 | Ishikawa, Japan | |||
2335395 | 2335395 | 2022-07-27 | Japan | Ishikawa | 76839 | 200 | 0 | 36.769464 | 136.771027 | 2022-07-28 04:20:56 | Ishikawa, Japan | |||
1487585 | 1487585 | 2022-07-26 | Japan | Ishikawa | 75064 | 200 | 0 | 36.769464 | 136.771027 | 2022-07-27 04:21:04 | Ishikawa, Japan | |||
2594031 | 2594031 | 2022-07-25 | Japan | Ishikawa | 74566 | 200 | 0 | 36.769464 | 136.771027 | 2022-07-26 04:20:58 | Ishikawa, Japan | |||
896146 | 896146 | 2022-07-24 | Japan | Ishikawa | 73471 | 200 | 0 | 36.769464 | 136.771027 | 2022-07-25 04:20:51 | Ishikawa, Japan | |||
91140 | 91140 | 2022-07-23 | Japan | Ishikawa | 72155 | 200 | 0 | 36.769464 | 136.771027 | 2022-07-24 04:20:47 | Ishikawa, Japan | |||
900162 | 900162 | 2022-07-22 | Japan | Ishikawa | 70833 | 200 | 0 | 36.769464 | 136.771027 | 2022-07-23 04:20:53 | Ishikawa, Japan | |||
670298 | 670298 | 2022-07-21 | Japan | Ishikawa | 69284 | 200 | 0 | 36.769464 | 136.771027 | 2022-07-22 04:21:15 | Ishikawa, Japan | |||
1608261 | 1608261 | 2022-07-20 | Japan | Ishikawa | 67656 | 200 | 0 | 36.769464 | 136.771027 | 2022-07-21 04:21:10 | Ishikawa, Japan | |||
958894 | 958894 | 2022-07-19 | Japan | Ishikawa | 67266 | 199 | 0 | 36.769464 | 136.771027 | 2022-07-20 04:20:59 | Ishikawa, Japan | |||
3210281 | 3210281 | 2022-07-18 | Japan | Ishikawa | 66935 | 199 | 0 | 36.769464 | 136.771027 | 2022-07-19 04:20:58 | Ishikawa, Japan | |||
3405456 | 3405456 | 2022-07-17 | Japan | Ishikawa | 66320 | 199 | 0 | 36.769464 | 136.771027 | 2022-07-18 04:20:59 | Ishikawa, Japan | |||
2151656 | 2151656 | 2022-07-16 | Japan | Ishikawa | 65641 | 199 | 0 | 36.769464 | 136.771027 | 2022-07-17 04:21:15 | Ishikawa, Japan | |||
2418889 | 2418889 | 2022-07-15 | Japan | Ishikawa | 65023 | 199 | 0 | 36.769464 | 136.771027 | 2022-07-16 04:21:05 | Ishikawa, Japan | |||
3428964 | 3428964 | 2022-07-14 | Japan | Ishikawa | 64319 | 199 | 0 | 36.769464 | 136.771027 | 2022-07-15 04:20:53 | Ishikawa, Japan | |||
3109484 | 3109484 | 2022-07-13 | Japan | Ishikawa | 63672 | 199 | 0 | 36.769464 | 136.771027 | 2022-07-14 04:20:57 | Ishikawa, Japan | |||
629907 | 629907 | 2022-07-12 | Japan | Ishikawa | 62963 | 199 | 0 | 36.769464 | 136.771027 | 2022-07-13 04:20:58 | Ishikawa, Japan | |||
1211551 | 1211551 | 2022-07-11 | Japan | Ishikawa | 62771 | 199 | 0 | 36.769464 | 136.771027 | 2022-07-12 04:20:51 | Ishikawa, Japan | |||
2789033 | 2789033 | 2022-07-10 | Japan | Ishikawa | 62418 | 199 | 0 | 36.769464 | 136.771027 | 2022-07-11 04:20:46 | Ishikawa, Japan | |||
141986 | 141986 | 2022-07-09 | Japan | Ishikawa | 62041 | 199 | 0 | 36.769464 | 136.771027 | 2022-07-10 04:20:54 | Ishikawa, Japan | |||
1417086 | 1417086 | 2022-07-08 | Japan | Ishikawa | 61708 | 199 | 0 | 36.769464 | 136.771027 | 2022-07-09 04:20:59 | Ishikawa, Japan | |||
2741011 | 2741011 | 2022-07-07 | Japan | Ishikawa | 61433 | 198 | 0 | 36.769464 | 136.771027 | 2022-07-08 04:20:56 | Ishikawa, Japan | |||
1199806 | 1199806 | 2022-07-06 | Japan | Ishikawa | 61125 | 198 | 0 | 36.769464 | 136.771027 | 2022-07-07 04:20:55 | Ishikawa, Japan | |||
3966549 | 3966549 | 2022-07-05 | Japan | Ishikawa | 60782 | 198 | 0 | 36.769464 | 136.771027 | 2022-07-06 04:20:58 | Ishikawa, Japan | |||
3078060 | 3078060 | 2022-07-04 | Japan | Ishikawa | 60697 | 198 | 0 | 36.769464 | 136.771027 | 2022-07-05 04:20:45 | Ishikawa, Japan | |||
1767342 | 1767342 | 2022-07-03 | Japan | Ishikawa | 60575 | 198 | 0 | 36.769464 | 136.771027 | 2022-07-04 04:20:54 | Ishikawa, Japan | |||
3365328 | 3365328 | 2022-07-02 | Japan | Ishikawa | 60408 | 198 | 0 | 36.769464 | 136.771027 | 2022-07-03 04:20:59 | Ishikawa, Japan | |||
593657 | 593657 | 2022-07-01 | Japan | Ishikawa | 60258 | 198 | 0 | 36.769464 | 136.771027 | 2022-07-02 04:21:16 | Ishikawa, Japan | |||
3940058 | 3940058 | 2022-06-30 | Japan | Ishikawa | 60111 | 197 | 0 | 36.769464 | 136.771027 | 2022-07-01 04:21:10 | Ishikawa, Japan | |||
2490016 | 2490016 | 2022-06-29 | Japan | Ishikawa | 59967 | 197 | 0 | 36.769464 | 136.771027 | 2022-06-30 04:21:01 | Ishikawa, Japan | |||
2239398 | 2239398 | 2022-06-28 | Japan | Ishikawa | 59812 | 197 | 0 | 36.769464 | 136.771027 | 2022-06-29 04:20:59 | Ishikawa, Japan | |||
2147640 | 2147640 | 2022-06-27 | Japan | Ishikawa | 59771 | 197 | 0 | 36.769464 | 136.771027 | 2022-06-28 04:20:58 | Ishikawa, Japan | |||
475441 | 475441 | 2022-06-26 | Japan | Ishikawa | 59681 | 197 | 0 | 36.769464 | 136.771027 | 2022-06-27 04:21:00 | Ishikawa, Japan | |||
938816 | 938816 | 2022-06-25 | Japan | Ishikawa | 59588 | 197 | 0 | 36.769464 | 136.771027 | 2022-06-26 04:21:02 | Ishikawa, Japan | |||
3346636 | 3346636 | 2022-06-24 | Japan | Ishikawa | 59491 | 197 | 0 | 36.769464 | 136.771027 | 2022-06-25 04:20:57 | Ishikawa, Japan | |||
1648377 | 1648377 | 2022-06-23 | Japan | Ishikawa | 59373 | 197 | 0 | 36.769464 | 136.771027 | 2022-06-24 04:20:58 | Ishikawa, Japan | |||
2187612 | 2187612 | 2022-06-22 | Japan | Ishikawa | 59216 | 197 | 0 | 36.769464 | 136.771027 | 2022-06-23 04:20:55 | Ishikawa, Japan | |||
166043 | 166043 | 2022-06-21 | Japan | Ishikawa | 59038 | 197 | 0 | 36.769464 | 136.771027 | 2022-06-22 04:20:54 | Ishikawa, Japan | |||
1763326 | 1763326 | 2022-06-20 | Japan | Ishikawa | 58991 | 197 | 0 | 36.769464 | 136.771027 | 2022-06-21 04:20:56 | Ishikawa, Japan | |||
3269512 | 3269512 | 2022-06-19 | Japan | Ishikawa | 58887 | 197 | 0 | 36.769464 | 136.771027 | 2022-06-20 04:21:01 | Ishikawa, Japan | |||
3397424 | 3397424 | 2022-06-18 | Japan | Ishikawa | 58743 | 197 | 0 | 36.769464 | 136.771027 | 2022-06-19 04:20:51 | Ishikawa, Japan | |||
2311301 | 2311301 | 2022-06-17 | Japan | Ishikawa | 58615 | 197 | 0 | 36.769464 | 136.771027 | 2022-06-18 04:21:10 | Ishikawa, Japan | |||
558805 | 558805 | 2022-06-16 | Japan | Ishikawa | 58450 | 197 | 0 | 36.769464 | 136.771027 | 2022-06-17 04:20:56 | Ishikawa, Japan | |||
3982607 | 3982607 | 2022-06-15 | Japan | Ishikawa | 58282 | 197 | 0 | 36.769464 | 136.771027 | 2022-06-16 04:20:55 | Ishikawa, Japan | |||
946848 | 946848 | 2022-06-14 | Japan | Ishikawa | 58104 | 197 | 0 | 36.769464 | 136.771027 | 2022-06-15 04:20:54 | Ishikawa, Japan | |||
2979256 | 2979256 | 2022-06-13 | Japan | Ishikawa | 58024 | 197 | 0 | 36.769464 | 136.771027 | 2022-06-14 04:20:52 | 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]);