johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
946 rows where province_or_state = "Kagawa" sorted by recovered
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, active, day (date), last_update (date)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered ▼ | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
330 | 330 | 2021-12-02 | Japan | Kagawa | 4702 | 38 | 0 | 34.217292 | 133.969047 | 2021-12-03 04:23:05 | Kagawa, Japan | |||
4346 | 4346 | 2021-10-28 | Japan | Kagawa | 4700 | 38 | 0 | 34.217292 | 133.969047 | 2021-10-29 04:22:03 | Kagawa, Japan | |||
16371 | 16371 | 2021-09-18 | Japan | Kagawa | 4632 | 36 | 0 | 34.217292 | 133.969047 | 2021-09-19 04:21:34 | Kagawa, Japan | |||
24401 | 24401 | 2022-03-20 | Japan | Kagawa | 26319 | 100 | 0 | 34.217292 | 133.969047 | 2022-03-21 04:20:50 | Kagawa, Japan | |||
28416 | 28416 | 2021-11-11 | Japan | Kagawa | 4700 | 38 | 0 | 34.217292 | 133.969047 | 2021-11-12 04:22:01 | Kagawa, Japan | |||
32432 | 32432 | 2021-08-25 | Japan | Kagawa | 3828 | 34 | 0 | 34.217292 | 133.969047 | 2021-08-26 04:21:28 | Kagawa, Japan | |||
43708 | 43708 | 2021-11-02 | Japan | Kagawa | 4700 | 38 | 0 | 34.217292 | 133.969047 | 2021-11-03 06:22:09 | Kagawa, Japan | |||
63062 | 63062 | 2022-11-12 | Japan | Kagawa | 158139 | 315 | 0 | 34.217292 | 133.969047 | 2022-11-13 04:21:14 | Kagawa, Japan | |||
67077 | 67077 | 2021-09-01 | Japan | Kagawa | 4298 | 34 | 0 | 34.217292 | 133.969047 | 2021-09-02 04:21:15 | Kagawa, Japan | |||
71091 | 71091 | 2022-02-07 | Japan | Kagawa | 10772 | 47 | 0 | 34.217292 | 133.969047 | 2022-02-08 04:21:15 | Kagawa, Japan | |||
87125 | 87125 | 2021-11-09 | Japan | Kagawa | 4700 | 38 | 0 | 34.217292 | 133.969047 | 2021-11-10 04:21:38 | Kagawa, Japan | |||
91142 | 91142 | 2022-07-23 | Japan | Kagawa | 60973 | 138 | 0 | 34.217292 | 133.969047 | 2022-07-24 04:20:47 | Kagawa, Japan | |||
99326 | 99326 | 2022-01-14 | Japan | Kagawa | 5021 | 38 | 0 | 34.217292 | 133.969047 | 2022-01-15 04:21:07 | Kagawa, Japan | |||
103342 | 103342 | 2021-08-15 | Japan | Kagawa | 2984 | 32 | 0 | 34.217292 | 133.969047 | 2021-08-16 04:21:31 | Kagawa, Japan | |||
114752 | 114752 | 2022-09-06 | Japan | Kagawa | 128379 | 264 | 0 | 34.217292 | 133.969047 | 2022-09-07 04:20:59 | Kagawa, Japan | |||
126733 | 126733 | 2022-01-09 | Japan | Kagawa | 4791 | 38 | 0 | 34.217292 | 133.969047 | 2022-01-10 04:22:07 | Kagawa, Japan | |||
130750 | 130750 | 2022-10-04 | Japan | Kagawa | 143412 | 297 | 0 | 34.217292 | 133.969047 | 2022-10-05 04:23:06 | Kagawa, Japan | |||
137971 | 137971 | 2021-12-04 | Japan | Kagawa | 4702 | 38 | 0 | 34.217292 | 133.969047 | 2021-12-05 04:22:25 | Kagawa, Japan | |||
141988 | 141988 | 2022-07-09 | Japan | Kagawa | 52278 | 129 | 0 | 34.217292 | 133.969047 | 2022-07-10 04:20:54 | Kagawa, Japan | |||
149984 | 149984 | 2021-11-29 | Japan | Kagawa | 4702 | 38 | 0 | 34.217292 | 133.969047 | 2021-11-30 04:22:53 | Kagawa, Japan | |||
158013 | 158013 | 2022-03-29 | Japan | Kagawa | 28884 | 108 | 0 | 34.217292 | 133.969047 | 2022-03-30 04:20:45 | Kagawa, Japan | |||
162028 | 162028 | 2021-11-19 | Japan | Kagawa | 4702 | 38 | 0 | 34.217292 | 133.969047 | 2021-11-20 04:22:17 | Kagawa, Japan | |||
166045 | 166045 | 2022-06-21 | Japan | Kagawa | 50167 | 128 | 0 | 34.217292 | 133.969047 | 2022-06-22 04:20:54 | Kagawa, Japan | |||
178042 | 178042 | 2021-09-02 | Japan | Kagawa | 4356 | 34 | 0 | 34.217292 | 133.969047 | 2021-09-03 04:21:20 | Kagawa, Japan | |||
186071 | 186071 | 2022-02-13 | Japan | Kagawa | 12830 | 53 | 0 | 34.217292 | 133.969047 | 2022-02-14 04:20:51 | Kagawa, Japan | |||
198259 | 198259 | 2022-10-19 | Japan | Kagawa | 146872 | 304 | 0 | 34.217292 | 133.969047 | 2022-10-20 04:22:59 | Kagawa, Japan | |||
217980 | 217980 | 2022-12-26 | Japan | Kagawa | 197366 | 396 | 0 | 34.217292 | 133.969047 | 2022-12-27 04:21:07 | Kagawa, Japan | |||
221996 | 221996 | 2022-05-09 | Japan | Kagawa | 41595 | 122 | 0 | 34.217292 | 133.969047 | 2022-05-10 04:20:50 | Kagawa, Japan | |||
229227 | 229227 | 2022-05-31 | Japan | Kagawa | 48124 | 126 | 0 | 34.217292 | 133.969047 | 2022-06-01 04:20:55 | Kagawa, Japan | |||
233243 | 233243 | 2022-02-11 | Japan | Kagawa | 12283 | 50 | 0 | 34.217292 | 133.969047 | 2022-02-12 04:21:06 | Kagawa, Japan | |||
245285 | 245285 | 2021-08-17 | Japan | Kagawa | 3124 | 34 | 0 | 34.217292 | 133.969047 | 2021-08-18 04:21:35 | Kagawa, Japan | |||
249299 | 249299 | 2021-09-04 | Japan | Kagawa | 4427 | 34 | 0 | 34.217292 | 133.969047 | 2021-09-05 04:21:33 | Kagawa, Japan | |||
253314 | 253314 | 2022-09-08 | Japan | Kagawa | 130224 | 267 | 0 | 34.217292 | 133.969047 | 2022-09-09 04:21:11 | Kagawa, Japan | |||
257330 | 257330 | 2022-12-10 | Japan | Kagawa | 176909 | 347 | 0 | 34.217292 | 133.969047 | 2022-12-11 04:20:50 | Kagawa, Japan | |||
261533 | 261533 | 2022-03-15 | Japan | Kagawa | 24465 | 95 | 0 | 34.217292 | 133.969047 | 2022-03-16 04:20:50 | Kagawa, Japan | |||
276183 | 276183 | 2021-11-03 | Japan | Kagawa | 4700 | 38 | 0 | 34.217292 | 133.969047 | 2021-11-04 04:22:20 | Kagawa, Japan | |||
287996 | 287996 | 2021-10-31 | Japan | Kagawa | 4700 | 38 | 0 | 34.217292 | 133.969047 | 2021-11-01 04:22:01 | Kagawa, Japan | |||
292013 | 292013 | 2022-11-15 | Japan | Kagawa | 159333 | 313 | 0 | 34.217292 | 133.969047 | 2022-11-16 04:21:09 | Kagawa, Japan | |||
303869 | 303869 | 2022-04-16 | Japan | Kagawa | 34858 | 116 | 0 | 34.217292 | 133.969047 | 2022-04-17 04:20:59 | Kagawa, Japan | |||
307885 | 307885 | 2022-12-13 | Japan | Kagawa | 179980 | 355 | 0 | 34.217292 | 133.969047 | 2022-12-14 04:21:04 | Kagawa, Japan | |||
311901 | 311901 | 2022-11-13 | Japan | Kagawa | 158606 | 315 | 0 | 34.217292 | 133.969047 | 2022-11-14 04:21:09 | Kagawa, Japan | |||
315917 | 315917 | 2022-02-12 | Japan | Kagawa | 12508 | 52 | 0 | 34.217292 | 133.969047 | 2022-02-13 04:21:00 | Kagawa, Japan | |||
319933 | 319933 | 2022-10-30 | Japan | Kagawa | 151165 | 306 | 0 | 34.217292 | 133.969047 | 2022-10-31 04:21:36 | Kagawa, Japan | |||
327907 | 327907 | 2022-12-27 | Japan | Kagawa | 199961 | 400 | 0 | 34.217292 | 133.969047 | 2022-12-28 04:21:04 | Kagawa, Japan | |||
335937 | 335937 | 2022-03-18 | Japan | Kagawa | 25685 | 98 | 0 | 34.217292 | 133.969047 | 2022-03-19 04:20:47 | Kagawa, Japan | |||
348297 | 348297 | 2022-12-14 | Japan | Kagawa | 181476 | 358 | 0 | 34.217292 | 133.969047 | 2022-12-15 04:20:58 | Kagawa, Japan | |||
356327 | 356327 | 2022-03-11 | Japan | Kagawa | 22950 | 87 | 0 | 34.217292 | 133.969047 | 2022-03-12 04:20:50 | Kagawa, Japan | |||
360343 | 360343 | 2022-05-07 | Japan | Kagawa | 40813 | 121 | 0 | 34.217292 | 133.969047 | 2022-05-08 04:20:49 | Kagawa, Japan | |||
372197 | 372197 | 2022-09-13 | Japan | Kagawa | 133846 | 274 | 0 | 34.217292 | 133.969047 | 2022-09-14 04:20:44 | Kagawa, Japan | |||
384224 | 384224 | 2022-09-23 | Japan | Kagawa | 140216 | 287 | 0 | 34.217292 | 133.969047 | 2022-09-24 04:21:40 | Kagawa, Japan | |||
396265 | 396265 | 2022-10-07 | Japan | Kagawa | 144098 | 297 | 0 | 34.217292 | 133.969047 | 2022-10-08 04:22:56 | Kagawa, Japan | |||
404294 | 404294 | 2021-12-07 | Japan | Kagawa | 4702 | 38 | 0 | 34.217292 | 133.969047 | 2021-12-08 04:22:46 | Kagawa, Japan | |||
419336 | 419336 | 2022-09-18 | Japan | Kagawa | 137722 | 282 | 0 | 34.217292 | 133.969047 | 2022-09-19 04:21:49 | Kagawa, Japan | |||
423351 | 423351 | 2021-10-10 | Japan | Kagawa | 4690 | 38 | 0 | 34.217292 | 133.969047 | 2021-10-11 04:21:31 | Kagawa, Japan | |||
431358 | 431358 | 2022-11-03 | Japan | Kagawa | 153298 | 308 | 0 | 34.217292 | 133.969047 | 2022-11-04 04:22:11 | Kagawa, Japan | |||
443355 | 443355 | 2021-10-20 | Japan | Kagawa | 4695 | 38 | 0 | 34.217292 | 133.969047 | 2021-10-21 04:21:18 | Kagawa, Japan | |||
447371 | 447371 | 2021-11-17 | Japan | Kagawa | 4702 | 38 | 0 | 34.217292 | 133.969047 | 2021-11-18 04:21:33 | Kagawa, Japan | |||
451388 | 451388 | 2022-12-21 | Japan | Kagawa | 190357 | 380 | 0 | 34.217292 | 133.969047 | 2022-12-22 04:20:56 | Kagawa, Japan | |||
459380 | 459380 | 2022-02-02 | Japan | Kagawa | 9142 | 43 | 0 | 34.217292 | 133.969047 | 2022-02-03 04:21:21 | Kagawa, Japan | |||
463397 | 463397 | 2022-05-02 | Japan | Kagawa | 39579 | 120 | 0 | 34.217292 | 133.969047 | 2022-05-03 04:21:00 | Kagawa, Japan | |||
467412 | 467412 | 2021-10-07 | Japan | Kagawa | 4690 | 38 | 0 | 34.217292 | 133.969047 | 2021-10-08 04:21:25 | Kagawa, Japan | |||
475443 | 475443 | 2022-06-26 | Japan | Kagawa | 50513 | 128 | 0 | 34.217292 | 133.969047 | 2022-06-27 04:21:00 | Kagawa, Japan | |||
479591 | 479591 | 2022-11-08 | Japan | Kagawa | 155822 | 311 | 0 | 34.217292 | 133.969047 | 2022-11-09 04:21:22 | Kagawa, Japan | |||
487621 | 487621 | 2022-11-25 | Japan | Kagawa | 165426 | 321 | 0 | 34.217292 | 133.969047 | 2022-11-26 04:21:11 | Kagawa, Japan | |||
491636 | 491636 | 2021-10-14 | Japan | Kagawa | 4693 | 38 | 0 | 34.217292 | 133.969047 | 2021-10-15 04:21:26 | Kagawa, Japan | |||
495652 | 495652 | 2021-11-06 | Japan | Kagawa | 4700 | 38 | 0 | 34.217292 | 133.969047 | 2021-11-07 04:21:53 | Kagawa, Japan | |||
499669 | 499669 | 2022-04-02 | Japan | Kagawa | 30241 | 113 | 0 | 34.217292 | 133.969047 | 2022-04-03 04:20:48 | Kagawa, Japan | |||
503685 | 503685 | 2022-12-17 | Japan | Kagawa | 185235 | 366 | 0 | 34.217292 | 133.969047 | 2022-12-18 04:21:03 | Kagawa, Japan | |||
507700 | 507700 | 2021-08-14 | Japan | Kagawa | 2935 | 32 | 0 | 34.217292 | 133.969047 | 2021-08-15 04:21:41 | Kagawa, Japan | |||
511714 | 511714 | 2021-08-19 | Japan | Kagawa | 3300 | 34 | 0 | 34.217292 | 133.969047 | 2021-08-20 04:21:33 | Kagawa, Japan | |||
515729 | 515729 | 2022-10-15 | Japan | Kagawa | 145751 | 301 | 0 | 34.217292 | 133.969047 | 2022-10-16 04:22:39 | Kagawa, Japan | |||
534736 | 534736 | 2021-10-27 | Japan | Kagawa | 4700 | 38 | 0 | 34.217292 | 133.969047 | 2021-10-28 04:22:08 | Kagawa, Japan | |||
538753 | 538753 | 2022-10-26 | Japan | Kagawa | 149435 | 305 | 0 | 34.217292 | 133.969047 | 2022-10-27 04:22:01 | Kagawa, Japan | |||
542769 | 542769 | 2022-12-15 | Japan | Kagawa | 182668 | 362 | 0 | 34.217292 | 133.969047 | 2022-12-16 04:21:01 | Kagawa, Japan | |||
550774 | 550774 | 2021-12-08 | Japan | Kagawa | 4702 | 38 | 0 | 34.217292 | 133.969047 | 2021-12-09 04:22:49 | Kagawa, Japan | |||
554790 | 554790 | 2022-01-16 | Japan | Kagawa | 5168 | 38 | 0 | 34.217292 | 133.969047 | 2022-01-17 04:21:08 | Kagawa, Japan | |||
558807 | 558807 | 2022-06-16 | Japan | Kagawa | 49825 | 128 | 0 | 34.217292 | 133.969047 | 2022-06-17 04:20:56 | Kagawa, Japan | |||
567104 | 567104 | 2021-10-29 | Japan | Kagawa | 4700 | 38 | 0 | 34.217292 | 133.969047 | 2021-10-30 04:22:03 | Kagawa, Japan | |||
574833 | 574833 | 2022-02-25 | Japan | Kagawa | 17432 | 71 | 0 | 34.217292 | 133.969047 | 2022-02-26 04:21:12 | Kagawa, Japan | |||
589644 | 589644 | 2021-08-08 | Japan | Kagawa | 2573 | 32 | 0 | 34.217292 | 133.969047 | 2021-08-09 04:21:24 | Kagawa, Japan | |||
593659 | 593659 | 2022-07-01 | Japan | Kagawa | 50984 | 128 | 0 | 34.217292 | 133.969047 | 2022-07-02 04:21:16 | Kagawa, Japan | |||
597674 | 597674 | 2021-10-19 | Japan | Kagawa | 4695 | 38 | 0 | 34.217292 | 133.969047 | 2021-10-20 04:21:00 | Kagawa, Japan | |||
601690 | 601690 | 2021-09-23 | Japan | Kagawa | 4659 | 36 | 0 | 34.217292 | 133.969047 | 2021-09-24 04:21:44 | Kagawa, Japan | |||
617863 | 617863 | 2022-11-05 | Japan | Kagawa | 154370 | 310 | 0 | 34.217292 | 133.969047 | 2022-11-06 04:21:24 | Kagawa, Japan | |||
621879 | 621879 | 2022-05-22 | Japan | Kagawa | 47044 | 123 | 0 | 34.217292 | 133.969047 | 2022-05-26 04:20:50 | Kagawa, Japan | |||
629909 | 629909 | 2022-07-12 | Japan | Kagawa | 53092 | 132 | 0 | 34.217292 | 133.969047 | 2022-07-13 04:20:58 | Kagawa, Japan | |||
633924 | 633924 | 2021-10-13 | Japan | Kagawa | 4693 | 38 | 0 | 34.217292 | 133.969047 | 2021-10-14 04:21:29 | Kagawa, Japan | |||
641954 | 641954 | 2021-09-07 | Japan | Kagawa | 4499 | 34 | 0 | 34.217292 | 133.969047 | 2021-09-08 04:21:31 | Kagawa, Japan | |||
649982 | 649982 | 2021-08-09 | Japan | Kagawa | 2599 | 32 | 0 | 34.217292 | 133.969047 | 2021-08-10 04:21:27 | Kagawa, Japan | |||
653996 | 653996 | 2021-10-22 | Japan | Kagawa | 4697 | 38 | 0 | 34.217292 | 133.969047 | 2021-10-23 04:21:32 | Kagawa, Japan | |||
658315 | 658315 | 2022-05-13 | Japan | Kagawa | 43198 | 123 | 0 | 34.217292 | 133.969047 | 2022-05-14 04:20:48 | Kagawa, Japan | |||
670300 | 670300 | 2022-07-21 | Japan | Kagawa | 58695 | 137 | 0 | 34.217292 | 133.969047 | 2022-07-22 04:21:15 | Kagawa, Japan | |||
674316 | 674316 | 2022-07-30 | Japan | Kagawa | 68870 | 145 | 0 | 34.217292 | 133.969047 | 2022-07-31 04:21:02 | Kagawa, Japan | |||
682341 | 682341 | 2021-10-24 | Japan | Kagawa | 4699 | 38 | 0 | 34.217292 | 133.969047 | 2021-10-25 04:22:31 | Kagawa, Japan | |||
686357 | 686357 | 2021-11-13 | Japan | Kagawa | 4702 | 38 | 0 | 34.217292 | 133.969047 | 2021-11-14 04:21:31 | Kagawa, Japan | |||
690374 | 690374 | 2022-12-23 | Japan | Kagawa | 193439 | 387 | 0 | 34.217292 | 133.969047 | 2022-12-24 04:21:02 | Kagawa, Japan | |||
694390 | 694390 | 2022-03-17 | Japan | Kagawa | 25316 | 96 | 0 | 34.217292 | 133.969047 | 2022-03-18 04:20:55 | Kagawa, Japan | |||
698405 | 698405 | 2021-11-04 | Japan | Kagawa | 4700 | 38 | 0 | 34.217292 | 133.969047 | 2021-11-05 04:21:54 | Kagawa, Japan | |||
706435 | 706435 | 2021-09-29 | Japan | Kagawa | 4679 | 36 | 0 | 34.217292 | 133.969047 | 2021-09-30 04:21:20 | Kagawa, Japan | |||
710451 | 710451 | 2022-11-01 | Japan | Kagawa | 152114 | 306 | 0 | 34.217292 | 133.969047 | 2022-11-02 04:22:09 | Kagawa, 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]);