johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
942 rows where province_or_state = "Lipetsk Oblast" sorted by admin2
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: recovered, active, longitude, last_update, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
553 | 553 | 2021-12-02 | Russia | Lipetsk Oblast | 75381 | 2453 | 0 | 52.693517799999995 | 39.112266399999996 | 2021-12-03 04:23:05 | Lipetsk Oblast, Russia | |||
4569 | 4569 | 2021-10-28 | Russia | Lipetsk Oblast | 61448 | 2002 | 0 | 52.693517799999995 | 39.112266399999996 | 2021-10-29 04:22:03 | Lipetsk Oblast, Russia | |||
8548 | 8548 | 2020-10-25 | Russia | Lipetsk Oblast | 7604 | 65 | 6421 | 1118 | 52.6935178 | 39.1122664 | 2020-10-26 04:25:02 | Lipetsk Oblast, Russia | ||
12559 | 12559 | 2021-01-26 | Russia | Lipetsk Oblast | 20182 | 358 | 16197 | 3627 | 52.6935178 | 39.1122664 | 2021-01-27 05:23:41 | Lipetsk Oblast, Russia | ||
16577 | 16577 | 2021-09-18 | Russia | Lipetsk Oblast | 50433 | 1554 | 0 | 52.693517799999995 | 39.112266399999996 | 2021-09-19 04:21:34 | Lipetsk Oblast, Russia | |||
20590 | 20590 | 2021-05-28 | Russia | Lipetsk Oblast | 31500 | 746 | 28591 | 2163 | 52.6935178 | 39.1122664 | 2021-05-29 04:20:41 | Lipetsk Oblast, Russia | ||
24624 | 24624 | 2022-03-20 | Russia | Lipetsk Oblast | 139637 | 3450 | 0 | 52.693517799999995 | 39.112266399999996 | 2022-03-21 04:20:50 | Lipetsk Oblast, Russia | |||
28639 | 28639 | 2021-11-11 | Russia | Lipetsk Oblast | 67068 | 2180 | 0 | 52.693517799999995 | 39.112266399999996 | 2021-11-12 04:22:01 | Lipetsk Oblast, Russia | |||
32638 | 32638 | 2021-08-25 | Russia | Lipetsk Oblast | 45586 | 1348 | 0 | 52.693517799999995 | 39.112266399999996 | 2021-08-26 04:21:28 | Lipetsk Oblast, Russia | |||
36649 | 36649 | 2021-04-12 | Russia | Lipetsk Oblast | 28587 | 579 | 25374 | 2634 | 52.6935178 | 39.1122664 | 2021-04-13 04:20:37 | Lipetsk Oblast, Russia | ||
43931 | 43931 | 2021-11-02 | Russia | Lipetsk Oblast | 63417 | 2064 | 0 | 52.693517799999995 | 39.112266399999996 | 2021-11-03 06:22:09 | Lipetsk Oblast, Russia | |||
51011 | 51011 | 2021-05-29 | Russia | Lipetsk Oblast | 31557 | 750 | 28677 | 2130 | 52.6935178 | 39.1122664 | 2021-05-30 04:20:55 | Lipetsk Oblast, Russia | ||
55024 | 55024 | 2021-03-07 | Russia | Lipetsk Oblast | 25393 | 453 | 22037 | 2903 | 52.6935178 | 39.1122664 | 2021-03-08 05:24:48 | Lipetsk Oblast, Russia | ||
61975 | 61975 | 2020-07-23 | Russia | Lipetsk Oblast | 4448 | 21 | 3487 | 940 | 52.693517799999995 | 39.112266399999996 | 2020-07-24 05:30:40 | Lipetsk Oblast, Russia | ||
63288 | 63288 | 2022-11-12 | Russia | Lipetsk Oblast | 174965 | 3924 | 0 | 52.6935178 | 39.1122664 | 2022-11-13 04:21:14 | Lipetsk Oblast, Russia | |||
67283 | 67283 | 2021-09-01 | Russia | Lipetsk Oblast | 47079 | 1410 | 0 | 52.693517799999995 | 39.112266399999996 | 2021-09-02 04:21:15 | Lipetsk Oblast, Russia | |||
71314 | 71314 | 2022-02-07 | Russia | Lipetsk Oblast | 99728 | 3095 | 0 | 52.693517799999995 | 39.112266399999996 | 2022-02-08 04:21:15 | Lipetsk Oblast, Russia | |||
75307 | 75307 | 2020-12-03 | Russia | Lipetsk Oblast | 11650 | 125 | 9426 | 2099 | 52.6935178 | 39.1122664 | 2020-12-04 05:27:27 | Lipetsk Oblast, Russia | ||
79304 | 79304 | 2020-10-14 | Russia | Lipetsk Oblast | 6793 | 54 | 5785 | 954 | 52.6935178 | 39.1122664 | 2020-10-15 04:24:28 | Lipetsk Oblast, Russia | ||
83314 | 83314 | 2021-05-25 | Russia | Lipetsk Oblast | 31328 | 735 | 28289 | 2304 | 52.6935178 | 39.1122664 | 2021-05-26 04:20:35 | Lipetsk Oblast, Russia | ||
87348 | 87348 | 2021-11-09 | Russia | Lipetsk Oblast | 66261 | 2158 | 0 | 52.693517799999995 | 39.112266399999996 | 2021-11-10 04:21:38 | Lipetsk Oblast, Russia | |||
91366 | 91366 | 2022-07-23 | Russia | Lipetsk Oblast | 153625 | 3803 | 0 | 52.6935178 | 39.1122664 | 2022-07-24 04:20:47 | Lipetsk Oblast, Russia | |||
98320 | 98320 | 2020-08-04 | Russia | Lipetsk Oblast | 4612 | 22 | 3708 | 882 | 52.693517799999995 | 39.112266399999996 | 2020-08-05 04:34:43 | Lipetsk Oblast, Russia | ||
99549 | 99549 | 2022-01-14 | Russia | Lipetsk Oblast | 85666 | 2913 | 0 | 52.693517799999995 | 39.112266399999996 | 2022-01-15 04:21:07 | Lipetsk Oblast, Russia | |||
103548 | 103548 | 2021-08-15 | Russia | Lipetsk Oblast | 43321 | 1269 | 0 | 52.693517799999995 | 39.112266399999996 | 2021-08-16 04:21:31 | Lipetsk Oblast, Russia | |||
107673 | 107673 | 2021-06-19 | Russia | Lipetsk Oblast | 32740 | 835 | 29604 | 2301 | 52.6935178 | 39.1122664 | 2021-06-20 04:21:48 | Lipetsk Oblast, Russia | ||
114976 | 114976 | 2022-09-06 | Russia | Lipetsk Oblast | 161787 | 3827 | 0 | 52.6935178 | 39.1122664 | 2022-09-07 04:20:59 | Lipetsk Oblast, Russia | |||
121912 | 121912 | 2020-07-19 | Russia | Lipetsk Oblast | 4395 | 20 | 3364 | 1011 | 52.6935178 | 39.1122664 | 2020-07-20 05:34:40 | Lipetsk Oblast, Russia | ||
122922 | 122922 | 2020-11-18 | Russia | Lipetsk Oblast | 9825 | 88 | 7800 | 1937 | 52.6935178 | 39.1122664 | 2020-11-19 05:25:23 | Lipetsk Oblast, Russia | ||
126956 | 126956 | 2022-01-09 | Russia | Lipetsk Oblast | 85058 | 2875 | 0 | 52.693517799999995 | 39.112266399999996 | 2022-01-10 04:22:07 | Lipetsk Oblast, Russia | |||
130976 | 130976 | 2022-10-04 | Russia | Lipetsk Oblast | 172319 | 3868 | 0 | 52.6935178 | 39.1122664 | 2022-10-05 04:23:06 | Lipetsk Oblast, Russia | |||
138194 | 138194 | 2021-12-04 | Russia | Lipetsk Oblast | 76117 | 2476 | 0 | 52.693517799999995 | 39.112266399999996 | 2021-12-05 04:22:25 | Lipetsk Oblast, Russia | |||
142212 | 142212 | 2022-07-09 | Russia | Lipetsk Oblast | 153096 | 3795 | 0 | 52.6935178 | 39.1122664 | 2022-07-10 04:20:54 | Lipetsk Oblast, Russia | |||
146188 | 146188 | 2020-08-15 | Russia | Lipetsk Oblast | 4800 | 23 | 4205 | 572 | 52.6935178 | 39.1122664 | 2020-08-16 04:27:42 | Lipetsk Oblast, Russia | ||
150207 | 150207 | 2021-11-29 | Russia | Lipetsk Oblast | 74236 | 2419 | 0 | 52.693517799999995 | 39.112266399999996 | 2021-11-30 04:22:53 | Lipetsk Oblast, Russia | |||
154201 | 154201 | 2021-01-08 | Russia | Lipetsk Oblast | 17358 | 285 | 12876 | 4197 | 52.6935178 | 39.1122664 | 2021-01-09 05:22:18 | Lipetsk Oblast, Russia | ||
158236 | 158236 | 2022-03-29 | Russia | Lipetsk Oblast | 143664 | 3522 | 0 | 52.693517799999995 | 39.112266399999996 | 2022-03-30 04:20:45 | Lipetsk Oblast, Russia | |||
162251 | 162251 | 2021-11-19 | Russia | Lipetsk Oblast | 70281 | 2286 | 0 | 52.693517799999995 | 39.112266399999996 | 2021-11-20 04:22:17 | Lipetsk Oblast, Russia | |||
166269 | 166269 | 2022-06-21 | Russia | Lipetsk Oblast | 152375 | 3785 | 0 | 52.6935178 | 39.1122664 | 2022-06-22 04:20:54 | Lipetsk Oblast, Russia | |||
170263 | 170263 | 2021-04-16 | Russia | Lipetsk Oblast | 28890 | 595 | 25620 | 2675 | 52.6935178 | 39.1122664 | 2021-04-17 04:20:40 | Lipetsk Oblast, Russia | ||
177230 | 177230 | 2020-07-27 | Russia | Lipetsk Oblast | 4499 | 21 | 3548 | 930 | 52.693517799999995 | 39.112266399999996 | 2020-07-28 04:58:43 | Lipetsk Oblast, Russia | ||
178248 | 178248 | 2021-09-02 | Russia | Lipetsk Oblast | 47283 | 1418 | 0 | 52.693517799999995 | 39.112266399999996 | 2021-09-03 04:21:20 | Lipetsk Oblast, Russia | |||
182259 | 182259 | 2021-02-21 | Russia | Lipetsk Oblast | 23861 | 418 | 20186 | 3257 | 52.6935178 | 39.1122664 | 2021-02-22 05:24:21 | Lipetsk Oblast, Russia | ||
186294 | 186294 | 2022-02-13 | Russia | Lipetsk Oblast | 109937 | 3148 | 0 | 52.693517799999995 | 39.112266399999996 | 2022-02-14 04:20:51 | Lipetsk Oblast, Russia | |||
190287 | 190287 | 2021-01-11 | Russia | Lipetsk Oblast | 17853 | 299 | 13070 | 4484 | 52.6935178 | 39.1122664 | 2021-01-12 05:22:15 | Lipetsk Oblast, Russia | ||
194283 | 194283 | 2020-08-31 | Russia | Lipetsk Oblast | 5094 | 26 | 4593 | 475 | 52.6935178 | 39.1122664 | 2020-09-01 04:28:31 | Lipetsk Oblast, Russia | ||
198485 | 198485 | 2022-10-19 | Russia | Lipetsk Oblast | 173980 | 3894 | 0 | 52.6935178 | 39.1122664 | 2022-10-20 04:22:59 | Lipetsk Oblast, Russia | |||
202474 | 202474 | 2020-12-25 | Russia | Lipetsk Oblast | 15067 | 229 | 11700 | 3138 | 52.6935178 | 39.1122664 | 2020-12-26 05:22:28 | Lipetsk Oblast, Russia | ||
206470 | 206470 | 2020-08-19 | Russia | Lipetsk Oblast | 4867 | 24 | 4399 | 444 | 52.6935178 | 39.1122664 | 2020-08-20 04:27:43 | Lipetsk Oblast, Russia | ||
210457 | 210457 | 2020-10-29 | Russia | Lipetsk Oblast | 7937 | 69 | 6591 | 1277 | 52.6935178 | 39.1122664 | 2020-10-30 04:24:49 | Lipetsk Oblast, Russia | ||
217195 | 217195 | 2020-06-08 | Russia | Lipetsk Oblast | 2637 | 8 | 1018 | 1611 | 52.693517799999995 | 39.112266399999996 | 2020-06-09 03:33:03 | Lipetsk Oblast, Russia | ||
218206 | 218206 | 2022-12-26 | Russia | Lipetsk Oblast | 176175 | 3939 | 0 | 52.6935178 | 39.1122664 | 2022-12-27 04:21:07 | Lipetsk Oblast, Russia | |||
222219 | 222219 | 2022-05-09 | Russia | Lipetsk Oblast | 150125 | 3729 | 0 | 52.6935178 | 39.1122664 | 2022-05-10 04:20:50 | Lipetsk Oblast, Russia | |||
229451 | 229451 | 2022-05-31 | Russia | Lipetsk Oblast | 151412 | 3764 | 0 | 52.6935178 | 39.1122664 | 2022-06-01 04:20:55 | Lipetsk Oblast, Russia | |||
233466 | 233466 | 2022-02-11 | Russia | Lipetsk Oblast | 106344 | 3129 | 0 | 52.693517799999995 | 39.112266399999996 | 2022-02-12 04:21:06 | Lipetsk Oblast, Russia | |||
237459 | 237459 | 2021-01-18 | Russia | Lipetsk Oblast | 18953 | 332 | 14340 | 4281 | 52.6935178 | 39.1122664 | 2021-01-19 05:22:15 | Lipetsk Oblast, Russia | ||
241474 | 241474 | 2021-04-02 | Russia | Lipetsk Oblast | 27774 | 537 | 24601 | 2636 | 52.6935178 | 39.1122664 | 2021-04-03 04:20:44 | Lipetsk Oblast, Russia | ||
245491 | 245491 | 2021-08-17 | Russia | Lipetsk Oblast | 43795 | 1285 | 0 | 52.693517799999995 | 39.112266399999996 | 2021-08-18 04:21:35 | Lipetsk Oblast, Russia | |||
249505 | 249505 | 2021-09-04 | Russia | Lipetsk Oblast | 47679 | 1437 | 0 | 52.693517799999995 | 39.112266399999996 | 2021-09-05 04:21:33 | Lipetsk Oblast, Russia | |||
253538 | 253538 | 2022-09-08 | Russia | Lipetsk Oblast | 162494 | 3829 | 0 | 52.6935178 | 39.1122664 | 2022-09-09 04:21:11 | Lipetsk Oblast, Russia | |||
257556 | 257556 | 2022-12-10 | Russia | Lipetsk Oblast | 175807 | 3932 | 0 | 52.6935178 | 39.1122664 | 2022-12-11 04:20:50 | Lipetsk Oblast, Russia | |||
261756 | 261756 | 2022-03-15 | Russia | Lipetsk Oblast | 137343 | 3410 | 0 | 52.693517799999995 | 39.112266399999996 | 2022-03-16 04:20:50 | Lipetsk Oblast, Russia | |||
272372 | 272372 | 2020-11-10 | Russia | Lipetsk Oblast | 9034 | 79 | 7235 | 1720 | 52.6935178 | 39.1122664 | 2020-11-11 05:25:30 | Lipetsk Oblast, Russia | ||
276406 | 276406 | 2021-11-03 | Russia | Lipetsk Oblast | 63825 | 2078 | 0 | 52.693517799999995 | 39.112266399999996 | 2021-11-04 04:22:20 | Lipetsk Oblast, Russia | |||
280402 | 280402 | 2021-02-24 | Russia | Lipetsk Oblast | 24213 | 426 | 20441 | 3346 | 52.6935178 | 39.1122664 | 2021-02-25 05:24:57 | Lipetsk Oblast, Russia | ||
287195 | 287195 | 2020-06-15 | Russia | Lipetsk Oblast | 3053 | 10 | 1291 | 1752 | 52.6935178 | 39.1122664 | 2020-06-16 04:33:09 | Lipetsk Oblast, Russia | ||
288219 | 288219 | 2021-10-31 | Russia | Lipetsk Oblast | 62622 | 2040 | 0 | 52.693517799999995 | 39.112266399999996 | 2021-11-01 04:22:01 | Lipetsk Oblast, Russia | |||
292239 | 292239 | 2022-11-15 | Russia | Lipetsk Oblast | 175053 | 3925 | 0 | 52.6935178 | 39.1122664 | 2022-11-16 04:21:09 | Lipetsk Oblast, Russia | |||
296234 | 296234 | 2021-07-15 | Russia | Lipetsk Oblast | 35860 | 994 | 31420 | 3446 | 52.6935178 | 39.1122664 | 2021-07-16 04:21:22 | Lipetsk Oblast, Russia | ||
303067 | 303067 | 2020-07-01 | Russia | Lipetsk Oblast | 3816 | 16 | 2409 | 1391 | 52.6935178 | 39.1122664 | 2020-07-02 04:33:46 | Lipetsk Oblast, Russia | ||
304092 | 304092 | 2022-04-16 | Russia | Lipetsk Oblast | 147986 | 3639 | 0 | 52.693517799999995 | 39.112266399999996 | 2022-04-17 04:20:59 | Lipetsk Oblast, Russia | |||
308111 | 308111 | 2022-12-13 | Russia | Lipetsk Oblast | 175900 | 3934 | 0 | 52.6935178 | 39.1122664 | 2022-12-14 04:21:04 | Lipetsk Oblast, Russia | |||
312127 | 312127 | 2022-11-13 | Russia | Lipetsk Oblast | 174999 | 3924 | 0 | 52.6935178 | 39.1122664 | 2022-11-14 04:21:09 | Lipetsk Oblast, Russia | |||
316140 | 316140 | 2022-02-12 | Russia | Lipetsk Oblast | 108235 | 3138 | 0 | 52.693517799999995 | 39.112266399999996 | 2022-02-13 04:21:00 | Lipetsk Oblast, Russia | |||
320159 | 320159 | 2022-10-30 | Russia | Lipetsk Oblast | 174475 | 3911 | 0 | 52.6935178 | 39.1122664 | 2022-10-31 04:21:36 | Lipetsk Oblast, Russia | |||
327007 | 327007 | 2020-07-20 | Russia | Lipetsk Oblast | 4410 | 20 | 3364 | 1026 | 52.6935178 | 39.1122664 | 2020-07-21 04:38:46 | Lipetsk Oblast, Russia | ||
328133 | 328133 | 2022-12-27 | Russia | Lipetsk Oblast | 176184 | 3939 | 0 | 52.6935178 | 39.1122664 | 2022-12-28 04:21:04 | Lipetsk Oblast, Russia | |||
332128 | 332128 | 2021-08-04 | Russia | Lipetsk Oblast | 40693 | 1176 | 34944 | 4573 | 52.6935178 | 39.1122664 | 2021-08-05 04:21:51 | Lipetsk Oblast, Russia | ||
336160 | 336160 | 2022-03-18 | Russia | Lipetsk Oblast | 138690 | 3433 | 0 | 52.693517799999995 | 39.112266399999996 | 2022-03-19 04:20:47 | Lipetsk Oblast, Russia | |||
340494 | 340494 | 2021-02-03 | Russia | Lipetsk Oblast | 21374 | 380 | 17395 | 3599 | 52.6935178 | 39.1122664 | 2021-02-04 05:22:26 | Lipetsk Oblast, Russia | ||
344491 | 344491 | 2020-09-14 | Russia | Lipetsk Oblast | 5549 | 34 | 4903 | 612 | 52.6935178 | 39.1122664 | 2020-09-15 03:22:50 | Lipetsk Oblast, Russia | ||
348523 | 348523 | 2022-12-14 | Russia | Lipetsk Oblast | 175936 | 3934 | 0 | 52.6935178 | 39.1122664 | 2022-12-15 04:20:58 | Lipetsk Oblast, Russia | |||
352515 | 352515 | 2021-03-11 | Russia | Lipetsk Oblast | 25786 | 466 | 22395 | 2925 | 52.6935178 | 39.1122664 | 2021-03-12 05:26:50 | Lipetsk Oblast, Russia | ||
356550 | 356550 | 2022-03-11 | Russia | Lipetsk Oblast | 135273 | 3376 | 0 | 52.693517799999995 | 39.112266399999996 | 2022-03-12 04:20:50 | Lipetsk Oblast, Russia | |||
360566 | 360566 | 2022-05-07 | Russia | Lipetsk Oblast | 149987 | 3722 | 0 | 52.6935178 | 39.1122664 | 2022-05-08 04:20:49 | Lipetsk Oblast, Russia | |||
367415 | 367415 | 2020-07-16 | Russia | Lipetsk Oblast | 4318 | 19 | 3173 | 1126 | 52.693517799999995 | 39.112266399999996 | 2020-07-17 04:34:50 | Lipetsk Oblast, Russia | ||
371385 | 371385 | 2020-08-08 | Russia | Lipetsk Oblast | 4682 | 22 | 3842 | 818 | 52.693517799999995 | 39.112266399999996 | 2020-08-09 04:34:54 | Lipetsk Oblast, Russia | ||
372423 | 372423 | 2022-09-13 | Russia | Lipetsk Oblast | 164242 | 3835 | 0 | 52.6935178 | 39.1122664 | 2022-09-14 04:20:44 | Lipetsk Oblast, Russia | |||
376399 | 376399 | 2020-11-06 | Russia | Lipetsk Oblast | 8645 | 76 | 7017 | 1552 | 52.6935178 | 39.1122664 | 2020-11-07 05:24:52 | Lipetsk Oblast, Russia | ||
380412 | 380412 | 2021-04-30 | Russia | Lipetsk Oblast | 29839 | 654 | 27098 | 2087 | 52.6935178 | 39.1122664 | 2021-05-01 04:20:47 | Lipetsk Oblast, Russia | ||
384450 | 384450 | 2022-09-23 | Russia | Lipetsk Oblast | 168957 | 3849 | 0 | 52.6935178 | 39.1122664 | 2022-09-24 04:21:40 | Lipetsk Oblast, Russia | |||
388442 | 388442 | 2021-04-04 | Russia | Lipetsk Oblast | 27942 | 543 | 24744 | 2655 | 52.6935178 | 39.1122664 | 2021-04-05 04:20:35 | Lipetsk Oblast, Russia | ||
392453 | 392453 | 2020-11-27 | Russia | Lipetsk Oblast | 10860 | 105 | 8704 | 2051 | 52.6935178 | 39.1122664 | 2020-11-28 05:25:50 | Lipetsk Oblast, Russia | ||
396491 | 396491 | 2022-10-07 | Russia | Lipetsk Oblast | 172826 | 3875 | 0 | 52.6935178 | 39.1122664 | 2022-10-08 04:22:56 | Lipetsk Oblast, Russia | |||
400486 | 400486 | 2021-06-29 | Russia | Lipetsk Oblast | 33413 | 890 | 30243 | 2280 | 52.6935178 | 39.1122664 | 2021-06-30 04:21:41 | Lipetsk Oblast, Russia | ||
404517 | 404517 | 2021-12-07 | Russia | Lipetsk Oblast | 77177 | 2512 | 0 | 52.693517799999995 | 39.112266399999996 | 2021-12-08 04:22:46 | Lipetsk Oblast, Russia | |||
408516 | 408516 | 2021-07-28 | Russia | Lipetsk Oblast | 38995 | 1112 | 33597 | 4286 | 52.6935178 | 39.1122664 | 2021-07-29 04:21:33 | Lipetsk Oblast, Russia | ||
415359 | 415359 | 2020-07-05 | Russia | Lipetsk Oblast | 3958 | 18 | 2561 | 1379 | 52.6935178 | 39.1122664 | 2020-07-06 04:33:57 | Lipetsk Oblast, Russia | ||
419562 | 419562 | 2022-09-18 | Russia | Lipetsk Oblast | 166496 | 3842 | 0 | 52.6935178 | 39.1122664 | 2022-09-19 04:21:49 | Lipetsk Oblast, Russia | |||
423574 | 423574 | 2021-10-10 | Russia | Lipetsk Oblast | 55553 | 1766 | 0 | 52.693517799999995 | 39.112266399999996 | 2021-10-11 04:21:31 | Lipetsk Oblast, Russia |
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]);