johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
946 rows where province_or_state = "Kagawa" sorted by admin2
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, recovered, 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 | |||
8348 | 8348 | 2020-10-25 | Japan | Kagawa | 102 | 2 | 95 | 5 | 34.217292 | 133.969047 | 2020-10-26 04:25:02 | Kagawa, Japan | ||
12356 | 12356 | 2021-01-26 | Japan | Kagawa | 597 | 14 | 415 | 168 | 34.217292 | 133.969047 | 2021-01-27 05:23:41 | Kagawa, Japan | ||
16371 | 16371 | 2021-09-18 | Japan | Kagawa | 4632 | 36 | 0 | 34.217292 | 133.969047 | 2021-09-19 04:21:34 | Kagawa, Japan | |||
20386 | 20386 | 2021-05-28 | Japan | Kagawa | 1982 | 24 | 1778 | 180 | 34.217292 | 133.969047 | 2021-05-29 04:20:41 | 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 | |||
36446 | 36446 | 2021-04-12 | Japan | Kagawa | 990 | 19 | 829 | 142 | 34.217292 | 133.969047 | 2021-04-13 04:20:37 | Kagawa, Japan | ||
43708 | 43708 | 2021-11-02 | Japan | Kagawa | 4700 | 38 | 0 | 34.217292 | 133.969047 | 2021-11-03 06:22:09 | Kagawa, Japan | |||
50807 | 50807 | 2021-05-29 | Japan | Kagawa | 1991 | 24 | 1804 | 163 | 34.217292 | 133.969047 | 2021-05-30 04:20:55 | Kagawa, Japan | ||
54821 | 54821 | 2021-03-07 | Japan | Kagawa | 757 | 18 | 726 | 13 | 34.217292 | 133.969047 | 2021-03-08 05:24:48 | Kagawa, Japan | ||
61930 | 61930 | 2020-07-23 | Japan | Kagawa | 45 | 0 | 28 | 17 | 34.217292 | 133.969047 | 2020-07-24 05:30:40 | 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 | |||
75105 | 75105 | 2020-12-03 | Japan | Kagawa | 156 | 2 | 124 | 30 | 34.217292 | 133.969047 | 2020-12-04 05:27:27 | Kagawa, Japan | ||
79104 | 79104 | 2020-10-14 | Japan | Kagawa | 97 | 2 | 91 | 4 | 34.217292 | 133.969047 | 2020-10-15 04:24:28 | Kagawa, Japan | ||
83111 | 83111 | 2021-05-25 | Japan | Kagawa | 1960 | 24 | 1687 | 249 | 34.217292 | 133.969047 | 2021-05-26 04:20:35 | 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 | |||
98274 | 98274 | 2020-08-04 | Japan | Kagawa | 48 | 0 | 42 | 6 | 34.217292 | 133.969047 | 2020-08-05 04:34:43 | 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 | |||
107467 | 107467 | 2021-06-19 | Japan | Kagawa | 2082 | 29 | 2008 | 45 | 34.217292 | 133.969047 | 2021-06-20 04:21:48 | Kagawa, Japan | ||
114752 | 114752 | 2022-09-06 | Japan | Kagawa | 128379 | 264 | 0 | 34.217292 | 133.969047 | 2022-09-07 04:20:59 | Kagawa, Japan | |||
121867 | 121867 | 2020-07-19 | Japan | Kagawa | 44 | 0 | 28 | 16 | 34.217292 | 133.969047 | 2020-07-20 05:34:40 | Kagawa, Japan | ||
122720 | 122720 | 2020-11-18 | Japan | Kagawa | 126 | 2 | 102 | 22 | 34.217292 | 133.969047 | 2020-11-19 05:25:23 | 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 | |||
145988 | 145988 | 2020-08-15 | Japan | Kagawa | 63 | 1 | 50 | 12 | 34.217292 | 133.969047 | 2020-08-16 04:27:42 | Kagawa, Japan | ||
149984 | 149984 | 2021-11-29 | Japan | Kagawa | 4702 | 38 | 0 | 34.217292 | 133.969047 | 2021-11-30 04:22:53 | Kagawa, Japan | |||
153999 | 153999 | 2021-01-08 | Japan | Kagawa | 403 | 3 | 250 | 150 | 34.217292 | 133.969047 | 2021-01-09 05:22:18 | 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 | |||
170060 | 170060 | 2021-04-16 | Japan | Kagawa | 1039 | 19 | 886 | 134 | 34.217292 | 133.969047 | 2021-04-17 04:20:40 | Kagawa, Japan | ||
177185 | 177185 | 2020-07-27 | Japan | Kagawa | 45 | 0 | 33 | 12 | 34.217292 | 133.969047 | 2020-07-28 04:58:43 | Kagawa, Japan | ||
178042 | 178042 | 2021-09-02 | Japan | Kagawa | 4356 | 34 | 0 | 34.217292 | 133.969047 | 2021-09-03 04:21:20 | Kagawa, Japan | |||
182056 | 182056 | 2021-02-21 | Japan | Kagawa | 739 | 18 | 683 | 38 | 34.217292 | 133.969047 | 2021-02-22 05:24:21 | Kagawa, Japan | ||
186071 | 186071 | 2022-02-13 | Japan | Kagawa | 12830 | 53 | 0 | 34.217292 | 133.969047 | 2022-02-14 04:20:51 | Kagawa, Japan | |||
190085 | 190085 | 2021-01-11 | Japan | Kagawa | 441 | 4 | 257 | 180 | 34.217292 | 133.969047 | 2021-01-12 05:22:15 | Kagawa, Japan | ||
194083 | 194083 | 2020-08-31 | Japan | Kagawa | 78 | 1 | 69 | 8 | 34.217292 | 133.969047 | 2020-09-01 04:28:31 | Kagawa, Japan | ||
198259 | 198259 | 2022-10-19 | Japan | Kagawa | 146872 | 304 | 0 | 34.217292 | 133.969047 | 2022-10-20 04:22:59 | Kagawa, Japan | |||
202272 | 202272 | 2020-12-25 | Japan | Kagawa | 265 | 3 | 187 | 75 | 34.217292 | 133.969047 | 2020-12-26 05:22:28 | Kagawa, Japan | ||
206270 | 206270 | 2020-08-19 | Japan | Kagawa | 68 | 1 | 56 | 11 | 34.217292 | 133.969047 | 2020-08-20 04:27:43 | Kagawa, Japan | ||
210256 | 210256 | 2020-10-29 | Japan | Kagawa | 102 | 2 | 95 | 5 | 34.217292 | 133.969047 | 2020-10-30 04:24:49 | Kagawa, Japan | ||
217155 | 217155 | 2020-06-08 | Japan | Kagawa | 28 | 0 | 28 | 0 | 34.217292 | 133.969047 | 2020-06-09 03:33:03 | 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 | |||
237257 | 237257 | 2021-01-18 | Japan | Kagawa | 537 | 5 | 331 | 201 | 34.217292 | 133.969047 | 2021-01-19 05:22:15 | Kagawa, Japan | ||
241271 | 241271 | 2021-04-02 | Japan | Kagawa | 872 | 19 | 754 | 99 | 34.217292 | 133.969047 | 2021-04-03 04:20:44 | 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 | |||
272171 | 272171 | 2020-11-10 | Japan | Kagawa | 108 | 2 | 100 | 6 | 34.217292 | 133.969047 | 2020-11-11 05:25:30 | Kagawa, Japan | ||
276183 | 276183 | 2021-11-03 | Japan | Kagawa | 4700 | 38 | 0 | 34.217292 | 133.969047 | 2021-11-04 04:22:20 | Kagawa, Japan | |||
280199 | 280199 | 2021-02-24 | Japan | Kagawa | 747 | 18 | 691 | 38 | 34.217292 | 133.969047 | 2021-02-25 05:24:57 | Kagawa, Japan | ||
287151 | 287151 | 2020-06-15 | Japan | Kagawa | 28 | 0 | 28 | 0 | 34.217292 | 133.969047 | 2020-06-16 04:33:09 | 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 | |||
296028 | 296028 | 2021-07-15 | Japan | Kagawa | 2123 | 31 | 2071 | 21 | 34.217292 | 133.969047 | 2021-07-16 04:21:22 | Kagawa, Japan | ||
303023 | 303023 | 2020-07-01 | Japan | Kagawa | 28 | 0 | 28 | 0 | 34.217292 | 133.969047 | 2020-07-02 04:33:46 | 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 | |||
326962 | 326962 | 2020-07-20 | Japan | Kagawa | 44 | 0 | 28 | 16 | 34.217292 | 133.969047 | 2020-07-21 04:38:46 | Kagawa, Japan | ||
327907 | 327907 | 2022-12-27 | Japan | Kagawa | 199961 | 400 | 0 | 34.217292 | 133.969047 | 2022-12-28 04:21:04 | Kagawa, Japan | |||
331922 | 331922 | 2021-08-04 | Japan | Kagawa | 2390 | 32 | 2126 | 232 | 34.217292 | 133.969047 | 2021-08-05 04:21:51 | Kagawa, Japan | ||
335937 | 335937 | 2022-03-18 | Japan | Kagawa | 25685 | 98 | 0 | 34.217292 | 133.969047 | 2022-03-19 04:20:47 | Kagawa, Japan | |||
340291 | 340291 | 2021-02-03 | Japan | Kagawa | 668 | 15 | 492 | 161 | 34.217292 | 133.969047 | 2021-02-04 05:22:26 | Kagawa, Japan | ||
344291 | 344291 | 2020-09-14 | Japan | Kagawa | 93 | 2 | 78 | 13 | 34.217292 | 133.969047 | 2020-09-15 03:22:50 | Kagawa, Japan | ||
348297 | 348297 | 2022-12-14 | Japan | Kagawa | 181476 | 358 | 0 | 34.217292 | 133.969047 | 2022-12-15 04:20:58 | Kagawa, Japan | |||
352312 | 352312 | 2021-03-11 | Japan | Kagawa | 764 | 18 | 729 | 17 | 34.217292 | 133.969047 | 2021-03-12 05:26:50 | 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 | |||
367371 | 367371 | 2020-07-16 | Japan | Kagawa | 42 | 0 | 28 | 14 | 34.217292 | 133.969047 | 2020-07-17 04:34:50 | Kagawa, Japan | ||
371339 | 371339 | 2020-08-08 | Japan | Kagawa | 59 | 0 | 45 | 14 | 34.217292 | 133.969047 | 2020-08-09 04:34:54 | Kagawa, Japan | ||
372197 | 372197 | 2022-09-13 | Japan | Kagawa | 133846 | 274 | 0 | 34.217292 | 133.969047 | 2022-09-14 04:20:44 | Kagawa, Japan | |||
376198 | 376198 | 2020-11-06 | Japan | Kagawa | 104 | 2 | 97 | 5 | 34.217292 | 133.969047 | 2020-11-07 05:24:52 | Kagawa, Japan | ||
380209 | 380209 | 2021-04-30 | Japan | Kagawa | 1258 | 22 | 1046 | 190 | 34.217292 | 133.969047 | 2021-05-01 04:20:47 | Kagawa, Japan | ||
384224 | 384224 | 2022-09-23 | Japan | Kagawa | 140216 | 287 | 0 | 34.217292 | 133.969047 | 2022-09-24 04:21:40 | Kagawa, Japan | |||
388239 | 388239 | 2021-04-04 | Japan | Kagawa | 901 | 19 | 759 | 123 | 34.217292 | 133.969047 | 2021-04-05 04:20:35 | Kagawa, Japan | ||
392251 | 392251 | 2020-11-27 | Japan | Kagawa | 139 | 2 | 113 | 24 | 34.217292 | 133.969047 | 2020-11-28 05:25:50 | Kagawa, Japan | ||
396265 | 396265 | 2022-10-07 | Japan | Kagawa | 144098 | 297 | 0 | 34.217292 | 133.969047 | 2022-10-08 04:22:56 | Kagawa, Japan | |||
400280 | 400280 | 2021-06-29 | Japan | Kagawa | 2094 | 30 | 2044 | 20 | 34.217292 | 133.969047 | 2021-06-30 04:21:41 | Kagawa, Japan | ||
404294 | 404294 | 2021-12-07 | Japan | Kagawa | 4702 | 38 | 0 | 34.217292 | 133.969047 | 2021-12-08 04:22:46 | Kagawa, Japan | |||
408310 | 408310 | 2021-07-28 | Japan | Kagawa | 2181 | 32 | 2097 | 52 | 34.217292 | 133.969047 | 2021-07-29 04:21:33 | Kagawa, Japan | ||
415315 | 415315 | 2020-07-05 | Japan | Kagawa | 28 | 0 | 28 | 0 | 34.217292 | 133.969047 | 2020-07-06 04:33:57 | 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 |
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]);