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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2533396 | 2533396 | 2022-05-12 | Japan | Ishikawa | 47890 | 193 | 0 | 36.769464 | 136.771027 | 2022-05-13 04:20:51 | Ishikawa, Japan | |||
3444842 | 3444842 | 2022-05-11 | Japan | Ishikawa | 47314 | 192 | 0 | 36.769464 | 136.771027 | 2022-05-12 04:20:54 | Ishikawa, Japan | |||
3535459 | 3535459 | 2022-05-10 | Japan | Ishikawa | 46689 | 192 | 0 | 36.769464 | 136.771027 | 2022-05-11 04:20:48 | Ishikawa, Japan | |||
221994 | 221994 | 2022-05-09 | Japan | Ishikawa | 46454 | 192 | 0 | 36.769464 | 136.771027 | 2022-05-10 04:20:50 | Ishikawa, Japan | |||
2331379 | 2331379 | 2022-05-08 | Japan | Ishikawa | 45933 | 192 | 0 | 36.769464 | 136.771027 | 2022-05-09 04:20:54 | Ishikawa, Japan | |||
360341 | 360341 | 2022-05-07 | Japan | Ishikawa | 45336 | 192 | 0 | 36.769464 | 136.771027 | 2022-05-08 04:20:49 | Ishikawa, Japan | |||
1397692 | 1397692 | 2022-05-06 | Japan | Ishikawa | 45064 | 192 | 0 | 36.769464 | 136.771027 | 2022-05-07 04:21:09 | Ishikawa, Japan | |||
2598047 | 2598047 | 2022-05-05 | Japan | Ishikawa | 44833 | 192 | 0 | 36.769464 | 136.771027 | 2022-05-06 04:21:00 | Ishikawa, Japan | |||
3265496 | 3265496 | 2022-05-04 | Japan | Ishikawa | 44602 | 192 | 0 | 36.769464 | 136.771027 | 2022-05-05 04:20:55 | Ishikawa, Japan | |||
1572135 | 1572135 | 2022-05-03 | Japan | Ishikawa | 44109 | 192 | 0 | 36.769464 | 136.771027 | 2022-05-04 04:20:59 | Ishikawa, Japan | |||
463395 | 463395 | 2022-05-02 | Japan | Ishikawa | 43945 | 192 | 0 | 36.769464 | 136.771027 | 2022-05-03 04:21:00 | Ishikawa, Japan | |||
3916034 | 3916034 | 2022-05-01 | Japan | Ishikawa | 43691 | 192 | 0 | 36.769464 | 136.771027 | 2022-05-02 04:21:10 | Ishikawa, Japan | |||
2840838 | 2840838 | 2022-04-30 | Japan | Ishikawa | 43548 | 191 | 0 | 36.769464 | 136.771027 | 2022-05-01 04:20:57 | Ishikawa, Japan | |||
1157151 | 1157151 | 2022-04-29 | Japan | Ishikawa | 43220 | 191 | 0 | 36.769464 | 136.771027 | 2022-04-30 04:21:05 | Ishikawa, Japan | |||
1696333 | 1696333 | 2022-04-28 | Japan | Ishikawa | 42848 | 190 | 0 | 36.769464 | 136.771027 | 2022-04-29 04:20:59 | Ishikawa, Japan | |||
3851816 | 3851816 | 2022-04-27 | Japan | Ishikawa | 42414 | 190 | 0 | 36.769464 | 136.771027 | 2022-04-28 04:20:47 | Ishikawa, Japan | |||
1326246 | 1326246 | 2022-04-26 | Japan | Ishikawa | 42040 | 190 | 0 | 36.769464 | 136.771027 | 2022-04-27 04:20:52 | Ishikawa, Japan | |||
3722200 | 3722200 | 2022-04-25 | Japan | Ishikawa | 41892 | 189 | 0 | 36.769464 | 136.771027 | 2022-04-26 04:20:51 | Ishikawa, Japan | |||
2028768 | 2028768 | 2022-04-24 | Japan | Ishikawa | 41561 | 189 | 0 | 36.769464 | 136.771027 | 2022-04-25 04:20:56 | Ishikawa, Japan | |||
746343 | 746343 | 2022-04-23 | Japan | Ishikawa | 41193 | 189 | 0 | 36.769464 | 136.771027 | 2022-04-24 04:20:56 | Ishikawa, Japan | |||
3436828 | 3436828 | 2022-04-22 | Japan | Ishikawa | 40831 | 188 | 0 | 36.769464 | 136.771027 | 2022-04-23 04:20:50 | Ishikawa, Japan | |||
2892413 | 2892413 | 2022-04-21 | Japan | Ishikawa | 40499 | 187 | 0 | 36.769464 | 136.771027 | 2022-04-22 04:20:45 | Ishikawa, Japan | |||
2307285 | 2307285 | 2022-04-20 | Japan | Ishikawa | 40185 | 187 | 0 | 36.769464 | 136.771027 | 2022-04-21 04:20:46 | Ishikawa, Japan | |||
2251424 | 2251424 | 2022-04-19 | Japan | Ishikawa | 39849 | 187 | 0 | 36.769464 | 136.771027 | 2022-04-20 04:20:45 | Ishikawa, Japan | |||
1845974 | 1845974 | 2022-04-18 | Japan | Ishikawa | 39724 | 186 | 0 | 36.769464 | 136.771027 | 2022-04-19 04:21:00 | Ishikawa, Japan | |||
3416918 | 3416918 | 2022-04-17 | Japan | Ishikawa | 39516 | 186 | 0 | 36.769464 | 136.771027 | 2022-04-18 04:21:12 | Ishikawa, Japan | |||
303867 | 303867 | 2022-04-16 | Japan | Ishikawa | 39246 | 186 | 0 | 36.769464 | 136.771027 | 2022-04-17 04:20:59 | Ishikawa, Japan | |||
2669812 | 2669812 | 2022-04-15 | Japan | Ishikawa | 38921 | 186 | 0 | 36.769464 | 136.771027 | 2022-04-16 04:20:48 | Ishikawa, Japan | |||
1223597 | 1223597 | 2022-04-14 | Japan | Ishikawa | 38581 | 186 | 0 | 36.769464 | 136.771027 | 2022-04-15 04:20:57 | Ishikawa, Japan | |||
2442755 | 2442755 | 2022-04-13 | Japan | Ishikawa | 38207 | 186 | 0 | 36.769464 | 136.771027 | 2022-04-13 23:21:06 | Ishikawa, Japan | |||
1948512 | 1948512 | 2022-04-12 | Japan | Ishikawa | 37835 | 186 | 0 | 36.769464 | 136.771027 | 2022-04-13 04:21:03 | Ishikawa, Japan | |||
3206265 | 3206265 | 2022-04-11 | Japan | Ishikawa | 37660 | 186 | 0 | 36.769464 | 136.771027 | 2022-04-12 04:20:49 | Ishikawa, Japan | |||
1576151 | 1576151 | 2022-04-10 | Japan | Ishikawa | 37387 | 186 | 0 | 36.769464 | 136.771027 | 2022-04-11 04:21:02 | Ishikawa, Japan | |||
1652393 | 1652393 | 2022-04-09 | Japan | Ishikawa | 37094 | 186 | 0 | 36.769464 | 136.771027 | 2022-04-10 04:20:52 | Ishikawa, Japan | |||
2115715 | 2115715 | 2022-04-08 | Japan | Ishikawa | 36793 | 186 | 0 | 36.769464 | 136.771027 | 2022-04-09 04:20:42 | Ishikawa, Japan | |||
3320239 | 3320239 | 2022-04-07 | Japan | Ishikawa | 36468 | 186 | 0 | 36.769464 | 136.771027 | 2022-04-08 04:20:48 | Ishikawa, Japan | |||
2800775 | 2800775 | 2022-04-06 | Japan | Ishikawa | 36121 | 186 | 0 | 36.769464 | 136.771027 | 2022-04-07 04:20:53 | Ishikawa, Japan | |||
3867544 | 3867544 | 2022-04-05 | Japan | Ishikawa | 35782 | 186 | 0 | 36.769464 | 136.771027 | 2022-04-06 04:20:49 | Ishikawa, Japan | |||
2748886 | 2748886 | 2022-04-04 | Japan | Ishikawa | 35660 | 186 | 0 | 36.769464 | 136.771027 | 2022-04-05 04:20:48 | Ishikawa, Japan | |||
3730232 | 3730232 | 2022-04-03 | Japan | Ishikawa | 35457 | 186 | 0 | 36.769464 | 136.771027 | 2022-04-04 04:20:51 | Ishikawa, Japan | |||
499667 | 499667 | 2022-04-02 | Japan | Ishikawa | 35151 | 185 | 0 | 36.769464 | 136.771027 | 2022-04-03 04:20:48 | Ishikawa, Japan | |||
3350652 | 3350652 | 2022-04-01 | Japan | Ishikawa | 34874 | 184 | 0 | 36.769464 | 136.771027 | 2022-04-02 04:20:47 | Ishikawa, Japan | |||
1539957 | 1539957 | 2022-03-31 | Japan | Ishikawa | 34553 | 184 | 0 | 36.769464 | 136.771027 | 2022-04-01 04:20:28 | Ishikawa, Japan | |||
2477970 | 2477970 | 2022-03-30 | Japan | Ishikawa | 34165 | 184 | 0 | 36.769464 | 136.771027 | 2022-03-31 04:20:56 | Ishikawa, Japan | |||
158011 | 158011 | 2022-03-29 | Japan | Ishikawa | 33865 | 184 | 0 | 36.769464 | 136.771027 | 2022-03-30 04:20:45 | Ishikawa, Japan | |||
1436582 | 1436582 | 2022-03-28 | Japan | Ishikawa | 33752 | 184 | 0 | 36.769464 | 136.771027 | 2022-03-29 04:20:46 | Ishikawa, Japan | |||
876263 | 876263 | 2022-03-27 | Japan | Ishikawa | 33502 | 184 | 0 | 36.769464 | 136.771027 | 2022-03-28 04:20:33 | Ishikawa, Japan | |||
2163546 | 2163546 | 2022-03-26 | Japan | Ishikawa | 33248 | 184 | 0 | 36.769464 | 136.771027 | 2022-03-27 04:20:47 | Ishikawa, Japan | |||
1720482 | 1720482 | 2022-03-25 | Japan | Ishikawa | 33014 | 183 | 0 | 36.769464 | 136.771027 | 2022-03-26 04:20:23 | Ishikawa, Japan | |||
1468099 | 1468099 | 2022-03-24 | Japan | Ishikawa | 32679 | 183 | 0 | 36.769464 | 136.771027 | 2022-03-25 04:20:46 | Ishikawa, Japan | |||
3022273 | 3022273 | 2022-03-23 | Japan | Ishikawa | 32639 | 181 | 0 | 36.769464 | 136.771027 | 2022-03-24 04:20:43 | Ishikawa, Japan | |||
1905195 | 1905195 | 2022-03-22 | Japan | Ishikawa | 32536 | 181 | 0 | 36.769464 | 136.771027 | 2022-03-23 04:20:48 | Ishikawa, Japan | |||
3238326 | 3238326 | 2022-03-21 | Japan | Ishikawa | 32439 | 181 | 0 | 36.769464 | 136.771027 | 2022-03-22 04:20:54 | Ishikawa, Japan | |||
24399 | 24399 | 2022-03-20 | Japan | Ishikawa | 32213 | 181 | 0 | 36.769464 | 136.771027 | 2022-03-21 04:20:50 | Ishikawa, Japan | |||
1656409 | 1656409 | 2022-03-19 | Japan | Ishikawa | 31960 | 181 | 0 | 36.769464 | 136.771027 | 2022-03-20 04:20:45 | Ishikawa, Japan | |||
335935 | 335935 | 2022-03-18 | Japan | Ishikawa | 31635 | 180 | 0 | 36.769464 | 136.771027 | 2022-03-19 04:20:47 | Ishikawa, Japan | |||
694388 | 694388 | 2022-03-17 | Japan | Ishikawa | 31307 | 179 | 0 | 36.769464 | 136.771027 | 2022-03-18 04:20:55 | Ishikawa, Japan | |||
2319331 | 2319331 | 2022-03-16 | Japan | Ishikawa | 30856 | 179 | 0 | 36.769464 | 136.771027 | 2022-03-17 04:20:56 | Ishikawa, Japan | |||
261531 | 261531 | 2022-03-15 | Japan | Ishikawa | 30450 | 179 | 0 | 36.769464 | 136.771027 | 2022-03-16 04:20:50 | Ishikawa, Japan | |||
2263890 | 2263890 | 2022-03-14 | Japan | Ishikawa | 30255 | 178 | 0 | 36.769464 | 136.771027 | 2022-03-15 04:20:47 | Ishikawa, Japan | |||
3627956 | 3627956 | 2022-03-13 | Japan | Ishikawa | 29921 | 178 | 0 | 36.769464 | 136.771027 | 2022-03-14 04:20:46 | Ishikawa, Japan | |||
950864 | 950864 | 2022-03-12 | Japan | Ishikawa | 29530 | 178 | 0 | 36.769464 | 136.771027 | 2022-03-13 04:20:49 | Ishikawa, Japan | |||
356325 | 356325 | 2022-03-11 | Japan | Ishikawa | 29172 | 178 | 0 | 36.769464 | 136.771027 | 2022-03-12 04:20:50 | Ishikawa, Japan | |||
1865477 | 1865477 | 2022-03-10 | Japan | Ishikawa | 28728 | 178 | 0 | 36.769464 | 136.771027 | 2022-03-11 04:20:50 | Ishikawa, Japan | |||
2140172 | 2140172 | 2022-03-09 | Japan | Ishikawa | 28240 | 176 | 0 | 36.769464 | 136.771027 | 2022-03-10 04:20:48 | Ishikawa, Japan | |||
919683 | 919683 | 2022-03-08 | Japan | Ishikawa | 27802 | 176 | 0 | 36.769464 | 136.771027 | 2022-03-09 04:20:59 | Ishikawa, Japan | |||
1547970 | 1547970 | 2022-03-07 | Japan | Ishikawa | 27637 | 176 | 0 | 36.769464 | 136.771027 | 2022-03-08 04:20:54 | Ishikawa, Japan | |||
2199639 | 2199639 | 2022-03-06 | Japan | Ishikawa | 27347 | 175 | 0 | 36.769464 | 136.771027 | 2022-03-07 04:20:47 | Ishikawa, Japan | |||
2092096 | 2092096 | 2022-03-05 | Japan | Ishikawa | 26944 | 173 | 0 | 36.769464 | 136.771027 | 2022-03-06 04:20:49 | Ishikawa, Japan | |||
2665796 | 2665796 | 2022-03-04 | Japan | Ishikawa | 26537 | 172 | 0 | 36.769464 | 136.771027 | 2022-03-05 04:21:10 | Ishikawa, Japan | |||
1644361 | 1644361 | 2022-03-03 | Japan | Ishikawa | 26100 | 172 | 0 | 36.769464 | 136.771027 | 2022-03-04 04:21:09 | Ishikawa, Japan | |||
2525364 | 2525364 | 2022-03-02 | Japan | Ishikawa | 25545 | 170 | 0 | 36.769464 | 136.771027 | 2022-03-03 04:21:01 | Ishikawa, Japan | |||
1992658 | 1992658 | 2022-03-01 | Japan | Ishikawa | 25027 | 169 | 0 | 36.769464 | 136.771027 | 2022-03-02 04:21:07 | Ishikawa, Japan | |||
942832 | 942832 | 2022-02-28 | Japan | Ishikawa | 24698 | 166 | 0 | 36.769464 | 136.771027 | 2022-03-01 04:21:09 | Ishikawa, Japan | |||
2733023 | 2733023 | 2022-02-27 | Japan | Ishikawa | 24341 | 164 | 0 | 36.769464 | 136.771027 | 2022-02-28 04:21:05 | Ishikawa, Japan | |||
3046176 | 3046176 | 2022-02-26 | Japan | Ishikawa | 23750 | 163 | 0 | 36.769464 | 136.771027 | 2022-02-27 04:21:04 | Ishikawa, Japan | |||
574831 | 574831 | 2022-02-25 | Japan | Ishikawa | 23280 | 161 | 0 | 36.769464 | 136.771027 | 2022-02-26 04:21:12 | Ishikawa, Japan | |||
1511407 | 1511407 | 2022-02-24 | Japan | Ishikawa | 22999 | 160 | 0 | 36.769464 | 136.771027 | 2022-02-25 04:21:11 | Ishikawa, Japan | |||
1057848 | 1057848 | 2022-02-23 | Japan | Ishikawa | 22460 | 159 | 0 | 36.769464 | 136.771027 | 2022-02-24 04:21:14 | Ishikawa, Japan | |||
2446771 | 2446771 | 2022-02-22 | Japan | Ishikawa | 21990 | 159 | 0 | 36.769464 | 136.771027 | 2022-02-23 04:21:09 | Ishikawa, Japan | |||
3718184 | 3718184 | 2022-02-21 | Japan | Ishikawa | 21789 | 159 | 0 | 36.769464 | 136.771027 | 2022-02-22 04:21:01 | Ishikawa, Japan | |||
3912018 | 3912018 | 2022-02-20 | Japan | Ishikawa | 21438 | 158 | 0 | 36.769464 | 136.771027 | 2022-02-21 04:21:05 | Ishikawa, Japan | |||
3875576 | 3875576 | 2022-02-19 | Japan | Ishikawa | 21039 | 157 | 0 | 36.769464 | 136.771027 | 2022-02-20 04:21:00 | Ishikawa, Japan | |||
3855832 | 3855832 | 2022-02-18 | Japan | Ishikawa | 20630 | 155 | 0 | 36.769464 | 136.771027 | 2022-02-19 04:21:11 | Ishikawa, Japan | |||
1298051 | 1298051 | 2022-02-17 | Japan | Ishikawa | 20154 | 155 | 0 | 36.769464 | 136.771027 | 2022-02-18 04:21:04 | Ishikawa, Japan | |||
3820437 | 3820437 | 2022-02-16 | Japan | Ishikawa | 19636 | 154 | 0 | 36.769464 | 136.771027 | 2022-02-17 04:20:56 | Ishikawa, Japan | |||
3671651 | 3671651 | 2022-02-15 | Japan | Ishikawa | 19222 | 154 | 0 | 36.769464 | 136.771027 | 2022-02-16 04:21:10 | Ishikawa, Japan | |||
2641752 | 2641752 | 2022-02-14 | Japan | Ishikawa | 18946 | 151 | 0 | 36.769464 | 136.771027 | 2022-02-15 04:21:09 | Ishikawa, Japan | |||
186069 | 186069 | 2022-02-13 | Japan | Ishikawa | 18642 | 150 | 0 | 36.769464 | 136.771027 | 2022-02-14 04:20:51 | Ishikawa, Japan | |||
315915 | 315915 | 2022-02-12 | Japan | Ishikawa | 18418 | 149 | 0 | 36.769464 | 136.771027 | 2022-02-13 04:21:00 | Ishikawa, Japan | |||
233241 | 233241 | 2022-02-11 | Japan | Ishikawa | 17986 | 147 | 0 | 36.769464 | 136.771027 | 2022-02-12 04:21:06 | Ishikawa, Japan | |||
1464083 | 1464083 | 2022-02-10 | Japan | Ishikawa | 17520 | 147 | 0 | 36.769464 | 136.771027 | 2022-02-11 04:21:09 | Ishikawa, Japan | |||
3074044 | 3074044 | 2022-02-09 | Japan | Ishikawa | 16974 | 145 | 0 | 36.769464 | 136.771027 | 2022-02-10 04:21:14 | Ishikawa, Japan | |||
1362351 | 1362351 | 2022-02-08 | Japan | Ishikawa | 16434 | 145 | 0 | 36.769464 | 136.771027 | 2022-02-09 04:21:04 | Ishikawa, Japan | |||
71089 | 71089 | 2022-02-07 | Japan | Ishikawa | 16213 | 144 | 0 | 36.769464 | 136.771027 | 2022-02-08 04:21:15 | Ishikawa, Japan | |||
2012705 | 2012705 | 2022-02-06 | Japan | Ishikawa | 15827 | 144 | 0 | 36.769464 | 136.771027 | 2022-02-07 04:21:05 | Ishikawa, Japan | |||
1294034 | 1294034 | 2022-02-05 | Japan | Ishikawa | 15325 | 144 | 0 | 36.769464 | 136.771027 | 2022-02-06 04:21:00 | Ishikawa, Japan | |||
2327362 | 2327362 | 2022-02-04 | Japan | Ishikawa | 14826 | 144 | 0 | 36.769464 | 136.771027 | 2022-02-05 04:21:05 | Ishikawa, Japan | |||
2473953 | 2473953 | 2022-02-03 | Japan | Ishikawa | 14275 | 143 | 0 | 36.769464 | 136.771027 | 2022-02-04 04:21:10 | Ishikawa, Japan | |||
459378 | 459378 | 2022-02-02 | Japan | Ishikawa | 13561 | 141 | 0 | 36.769464 | 136.771027 | 2022-02-03 04:21:21 | 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]);