johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
942 rows where country_or_region = "Russia" and province_or_state = "Kamchatka Krai" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
538 | 538 | 2021-12-02 | Russia | Kamchatka Krai | 22501 | 483 | 0 | 57.191488199999995 | 160.03838190000005 | 2021-12-03 04:23:05 | Kamchatka Krai, Russia | |||
4554 | 4554 | 2021-10-28 | Russia | Kamchatka Krai | 20871 | 431 | 0 | 57.191488199999995 | 160.03838190000005 | 2021-10-29 04:22:03 | Kamchatka Krai, Russia | |||
8533 | 8533 | 2020-10-25 | Russia | Kamchatka Krai | 5470 | 70 | 3541 | 1859 | 57.1914882 | 160.03838190000005 | 2020-10-26 04:25:02 | Kamchatka Krai, Russia | ||
12544 | 12544 | 2021-01-26 | Russia | Kamchatka Krai | 11979 | 84 | 10570 | 1325 | 57.1914882 | 160.03838190000005 | 2021-01-27 05:23:41 | Kamchatka Krai, Russia | ||
16562 | 16562 | 2021-09-18 | Russia | Kamchatka Krai | 19235 | 299 | 0 | 57.191488199999995 | 160.03838190000005 | 2021-09-19 04:21:34 | Kamchatka Krai, Russia | |||
20575 | 20575 | 2021-05-28 | Russia | Kamchatka Krai | 14663 | 231 | 14040 | 392 | 57.1914882 | 160.03838190000005 | 2021-05-29 04:20:41 | Kamchatka Krai, Russia | ||
24609 | 24609 | 2022-03-20 | Russia | Kamchatka Krai | 38709 | 609 | 0 | 57.191488199999995 | 160.03838190000005 | 2022-03-21 04:20:50 | Kamchatka Krai, Russia | |||
28624 | 28624 | 2021-11-11 | Russia | Kamchatka Krai | 21505 | 467 | 0 | 57.191488199999995 | 160.03838190000005 | 2021-11-12 04:22:01 | Kamchatka Krai, Russia | |||
32623 | 32623 | 2021-08-25 | Russia | Kamchatka Krai | 18107 | 247 | 0 | 57.191488199999995 | 160.03838190000005 | 2021-08-26 04:21:28 | Kamchatka Krai, Russia | |||
36634 | 36634 | 2021-04-12 | Russia | Kamchatka Krai | 14276 | 213 | 13548 | 515 | 57.1914882 | 160.03838190000005 | 2021-04-13 04:20:37 | Kamchatka Krai, Russia | ||
43916 | 43916 | 2021-11-02 | Russia | Kamchatka Krai | 21088 | 443 | 0 | 57.191488199999995 | 160.03838190000005 | 2021-11-03 06:22:09 | Kamchatka Krai, Russia | |||
50996 | 50996 | 2021-05-29 | Russia | Kamchatka Krai | 14671 | 231 | 14048 | 392 | 57.1914882 | 160.03838190000005 | 2021-05-30 04:20:55 | Kamchatka Krai, Russia | ||
55009 | 55009 | 2021-03-07 | Russia | Kamchatka Krai | 13705 | 133 | 12461 | 1111 | 57.1914882 | 160.03838190000005 | 2021-03-08 05:24:48 | Kamchatka Krai, Russia | ||
61936 | 61936 | 2020-07-23 | Russia | Kamchatka Krai | 3122 | 42 | 2499 | 581 | 57.191488199999995 | 160.03838190000005 | 2020-07-24 05:30:40 | Kamchatka Krai, Russia | ||
63273 | 63273 | 2022-11-12 | Russia | Kamchatka Krai | 44351 | 625 | 0 | 57.1914882 | 160.0383819 | 2022-11-13 04:21:14 | Kamchatka Krai, Russia | |||
67268 | 67268 | 2021-09-01 | Russia | Kamchatka Krai | 18449 | 259 | 0 | 57.191488199999995 | 160.03838190000005 | 2021-09-02 04:21:15 | Kamchatka Krai, Russia | |||
71299 | 71299 | 2022-02-07 | Russia | Kamchatka Krai | 28026 | 556 | 0 | 57.191488199999995 | 160.03838190000005 | 2022-02-08 04:21:15 | Kamchatka Krai, Russia | |||
75292 | 75292 | 2020-12-03 | Russia | Kamchatka Krai | 7876 | 79 | 5987 | 1810 | 57.1914882 | 160.03838190000005 | 2020-12-04 05:27:27 | Kamchatka Krai, Russia | ||
79289 | 79289 | 2020-10-14 | Russia | Kamchatka Krai | 4937 | 70 | 3404 | 1463 | 57.1914882 | 160.03838190000005 | 2020-10-15 04:24:28 | Kamchatka Krai, Russia | ||
83299 | 83299 | 2021-05-25 | Russia | Kamchatka Krai | 14641 | 231 | 14008 | 402 | 57.1914882 | 160.03838190000005 | 2021-05-26 04:20:35 | Kamchatka Krai, Russia | ||
87333 | 87333 | 2021-11-09 | Russia | Kamchatka Krai | 21410 | 465 | 0 | 57.191488199999995 | 160.03838190000005 | 2021-11-10 04:21:38 | Kamchatka Krai, Russia | |||
91351 | 91351 | 2022-07-23 | Russia | Kamchatka Krai | 40370 | 617 | 0 | 57.1914882 | 160.0383819 | 2022-07-24 04:20:47 | Kamchatka Krai, Russia | |||
98280 | 98280 | 2020-08-04 | Russia | Kamchatka Krai | 3427 | 42 | 3014 | 371 | 57.191488199999995 | 160.03838190000005 | 2020-08-05 04:34:43 | Kamchatka Krai, Russia | ||
99534 | 99534 | 2022-01-14 | Russia | Kamchatka Krai | 24104 | 517 | 0 | 57.191488199999995 | 160.03838190000005 | 2022-01-15 04:21:07 | Kamchatka Krai, Russia | |||
103533 | 103533 | 2021-08-15 | Russia | Kamchatka Krai | 17593 | 244 | 0 | 57.191488199999995 | 160.03838190000005 | 2021-08-16 04:21:31 | Kamchatka Krai, Russia | |||
107658 | 107658 | 2021-06-19 | Russia | Kamchatka Krai | 14901 | 238 | 14093 | 570 | 57.1914882 | 160.03838190000005 | 2021-06-20 04:21:48 | Kamchatka Krai, Russia | ||
114961 | 114961 | 2022-09-06 | Russia | Kamchatka Krai | 42443 | 621 | 0 | 57.1914882 | 160.0383819 | 2022-09-07 04:20:59 | Kamchatka Krai, Russia | |||
121873 | 121873 | 2020-07-19 | Russia | Kamchatka Krai | 2982 | 42 | 2183 | 757 | 57.1914882 | 160.03838190000005 | 2020-07-20 05:34:40 | Kamchatka Krai, Russia | ||
122907 | 122907 | 2020-11-18 | Russia | Kamchatka Krai | 6834 | 70 | 4483 | 2281 | 57.1914882 | 160.03838190000005 | 2020-11-19 05:25:23 | Kamchatka Krai, Russia | ||
126941 | 126941 | 2022-01-09 | Russia | Kamchatka Krai | 23902 | 512 | 0 | 57.191488199999995 | 160.03838190000005 | 2022-01-10 04:22:07 | Kamchatka Krai, Russia | |||
130961 | 130961 | 2022-10-04 | Russia | Kamchatka Krai | 43823 | 624 | 0 | 57.1914882 | 160.0383819 | 2022-10-05 04:23:06 | Kamchatka Krai, Russia | |||
138179 | 138179 | 2021-12-04 | Russia | Kamchatka Krai | 22601 | 485 | 0 | 57.191488199999995 | 160.03838190000005 | 2021-12-05 04:22:25 | Kamchatka Krai, Russia | |||
142197 | 142197 | 2022-07-09 | Russia | Kamchatka Krai | 40263 | 617 | 0 | 57.1914882 | 160.0383819 | 2022-07-10 04:20:54 | Kamchatka Krai, Russia | |||
146173 | 146173 | 2020-08-15 | Russia | Kamchatka Krai | 3601 | 42 | 3082 | 477 | 57.1914882 | 160.03838190000005 | 2020-08-16 04:27:42 | Kamchatka Krai, Russia | ||
150192 | 150192 | 2021-11-29 | Russia | Kamchatka Krai | 22357 | 482 | 0 | 57.191488199999995 | 160.03838190000005 | 2021-11-30 04:22:53 | Kamchatka Krai, Russia | |||
154186 | 154186 | 2021-01-08 | Russia | Kamchatka Krai | 10701 | 82 | 9361 | 1258 | 57.1914882 | 160.03838190000005 | 2021-01-09 05:22:18 | Kamchatka Krai, Russia | ||
158221 | 158221 | 2022-03-29 | Russia | Kamchatka Krai | 39008 | 609 | 0 | 57.191488199999995 | 160.03838190000005 | 2022-03-30 04:20:45 | Kamchatka Krai, Russia | |||
162236 | 162236 | 2021-11-19 | Russia | Kamchatka Krai | 21879 | 475 | 0 | 57.191488199999995 | 160.03838190000005 | 2021-11-20 04:22:17 | Kamchatka Krai, Russia | |||
166254 | 166254 | 2022-06-21 | Russia | Kamchatka Krai | 40143 | 617 | 0 | 57.1914882 | 160.0383819 | 2022-06-22 04:20:54 | Kamchatka Krai, Russia | |||
170248 | 170248 | 2021-04-16 | Russia | Kamchatka Krai | 14323 | 213 | 13636 | 474 | 57.1914882 | 160.03838190000005 | 2021-04-17 04:20:40 | Kamchatka Krai, Russia | ||
177191 | 177191 | 2020-07-27 | Russia | Kamchatka Krai | 3270 | 42 | 2765 | 463 | 57.191488199999995 | 160.03838190000005 | 2020-07-28 04:58:43 | Kamchatka Krai, Russia | ||
178233 | 178233 | 2021-09-02 | Russia | Kamchatka Krai | 18498 | 261 | 0 | 57.191488199999995 | 160.03838190000005 | 2021-09-03 04:21:20 | Kamchatka Krai, Russia | |||
182244 | 182244 | 2021-02-21 | Russia | Kamchatka Krai | 13261 | 118 | 11802 | 1341 | 57.1914882 | 160.03838190000005 | 2021-02-22 05:24:21 | Kamchatka Krai, Russia | ||
186279 | 186279 | 2022-02-13 | Russia | Kamchatka Krai | 30184 | 561 | 0 | 57.191488199999995 | 160.03838190000005 | 2022-02-14 04:20:51 | Kamchatka Krai, Russia | |||
190272 | 190272 | 2021-01-11 | Russia | Kamchatka Krai | 10926 | 82 | 9553 | 1291 | 57.1914882 | 160.03838190000005 | 2021-01-12 05:22:15 | Kamchatka Krai, Russia | ||
194268 | 194268 | 2020-08-31 | Russia | Kamchatka Krai | 3852 | 42 | 3157 | 653 | 57.1914882 | 160.03838190000005 | 2020-09-01 04:28:31 | Kamchatka Krai, Russia | ||
198470 | 198470 | 2022-10-19 | Russia | Kamchatka Krai | 44130 | 625 | 0 | 57.1914882 | 160.0383819 | 2022-10-20 04:22:59 | Kamchatka Krai, Russia | |||
202459 | 202459 | 2020-12-25 | Russia | Kamchatka Krai | 9641 | 82 | 8509 | 1050 | 57.1914882 | 160.03838190000005 | 2020-12-26 05:22:28 | Kamchatka Krai, Russia | ||
206455 | 206455 | 2020-08-19 | Russia | Kamchatka Krai | 3654 | 42 | 3100 | 512 | 57.1914882 | 160.03838190000005 | 2020-08-20 04:27:43 | Kamchatka Krai, Russia | ||
210442 | 210442 | 2020-10-29 | Russia | Kamchatka Krai | 5672 | 70 | 3638 | 1964 | 57.1914882 | 160.03838190000005 | 2020-10-30 04:24:49 | Kamchatka Krai, Russia | ||
217161 | 217161 | 2020-06-08 | Russia | Kamchatka Krai | 1168 | 10 | 310 | 848 | 57.191488199999995 | 160.03838190000005 | 2020-06-09 03:33:03 | Kamchatka Krai, Russia | ||
218191 | 218191 | 2022-12-26 | Russia | Kamchatka Krai | 44575 | 625 | 0 | 57.1914882 | 160.0383819 | 2022-12-27 04:21:07 | Kamchatka Krai, Russia | |||
222204 | 222204 | 2022-05-09 | Russia | Kamchatka Krai | 39687 | 613 | 0 | 57.1914882 | 160.0383819 | 2022-05-10 04:20:50 | Kamchatka Krai, Russia | |||
229436 | 229436 | 2022-05-31 | Russia | Kamchatka Krai | 39937 | 615 | 0 | 57.1914882 | 160.0383819 | 2022-06-01 04:20:55 | Kamchatka Krai, Russia | |||
233451 | 233451 | 2022-02-11 | Russia | Kamchatka Krai | 29517 | 561 | 0 | 57.191488199999995 | 160.03838190000005 | 2022-02-12 04:21:06 | Kamchatka Krai, Russia | |||
237444 | 237444 | 2021-01-18 | Russia | Kamchatka Krai | 11432 | 82 | 10029 | 1321 | 57.1914882 | 160.03838190000005 | 2021-01-19 05:22:15 | Kamchatka Krai, Russia | ||
241459 | 241459 | 2021-04-02 | Russia | Kamchatka Krai | 14149 | 201 | 13276 | 672 | 57.1914882 | 160.03838190000005 | 2021-04-03 04:20:44 | Kamchatka Krai, Russia | ||
245476 | 245476 | 2021-08-17 | Russia | Kamchatka Krai | 17698 | 244 | 0 | 57.191488199999995 | 160.03838190000005 | 2021-08-18 04:21:35 | Kamchatka Krai, Russia | |||
249490 | 249490 | 2021-09-04 | Russia | Kamchatka Krai | 18595 | 264 | 0 | 57.191488199999995 | 160.03838190000005 | 2021-09-05 04:21:33 | Kamchatka Krai, Russia | |||
253523 | 253523 | 2022-09-08 | Russia | Kamchatka Krai | 42549 | 621 | 0 | 57.1914882 | 160.0383819 | 2022-09-09 04:21:11 | Kamchatka Krai, Russia | |||
257541 | 257541 | 2022-12-10 | Russia | Kamchatka Krai | 44523 | 625 | 0 | 57.1914882 | 160.0383819 | 2022-12-11 04:20:50 | Kamchatka Krai, Russia | |||
261741 | 261741 | 2022-03-15 | Russia | Kamchatka Krai | 38446 | 609 | 0 | 57.191488199999995 | 160.03838190000005 | 2022-03-16 04:20:50 | Kamchatka Krai, Russia | |||
272357 | 272357 | 2020-11-10 | Russia | Kamchatka Krai | 6360 | 70 | 4052 | 2238 | 57.1914882 | 160.03838190000005 | 2020-11-11 05:25:30 | Kamchatka Krai, Russia | ||
276391 | 276391 | 2021-11-03 | Russia | Kamchatka Krai | 21133 | 444 | 0 | 57.191488199999995 | 160.03838190000005 | 2021-11-04 04:22:20 | Kamchatka Krai, Russia | |||
280387 | 280387 | 2021-02-24 | Russia | Kamchatka Krai | 13375 | 118 | 11944 | 1313 | 57.1914882 | 160.03838190000005 | 2021-02-25 05:24:57 | Kamchatka Krai, Russia | ||
287157 | 287157 | 2020-06-15 | Russia | Kamchatka Krai | 1496 | 10 | 439 | 1047 | 57.1914882 | 160.03838190000005 | 2020-06-16 04:33:09 | Kamchatka Krai, Russia | ||
288204 | 288204 | 2021-10-31 | Russia | Kamchatka Krai | 21001 | 437 | 0 | 57.191488199999995 | 160.03838190000005 | 2021-11-01 04:22:01 | Kamchatka Krai, Russia | |||
292224 | 292224 | 2022-11-15 | Russia | Kamchatka Krai | 44375 | 625 | 0 | 57.1914882 | 160.0383819 | 2022-11-16 04:21:09 | Kamchatka Krai, Russia | |||
296219 | 296219 | 2021-07-15 | Russia | Kamchatka Krai | 15951 | 238 | 14308 | 1405 | 57.1914882 | 160.03838190000005 | 2021-07-16 04:21:22 | Kamchatka Krai, Russia | ||
303029 | 303029 | 2020-07-01 | Russia | Kamchatka Krai | 2245 | 28 | 963 | 1254 | 57.1914882 | 160.03838190000005 | 2020-07-02 04:33:46 | Kamchatka Krai, Russia | ||
304077 | 304077 | 2022-04-16 | Russia | Kamchatka Krai | 39372 | 609 | 0 | 57.191488199999995 | 160.03838190000005 | 2022-04-17 04:20:59 | Kamchatka Krai, Russia | |||
308096 | 308096 | 2022-12-13 | Russia | Kamchatka Krai | 44533 | 625 | 0 | 57.1914882 | 160.0383819 | 2022-12-14 04:21:04 | Kamchatka Krai, Russia | |||
312112 | 312112 | 2022-11-13 | Russia | Kamchatka Krai | 44358 | 625 | 0 | 57.1914882 | 160.0383819 | 2022-11-14 04:21:09 | Kamchatka Krai, Russia | |||
316125 | 316125 | 2022-02-12 | Russia | Kamchatka Krai | 29847 | 561 | 0 | 57.191488199999995 | 160.03838190000005 | 2022-02-13 04:21:00 | Kamchatka Krai, Russia | |||
320144 | 320144 | 2022-10-30 | Russia | Kamchatka Krai | 44235 | 625 | 0 | 57.1914882 | 160.0383819 | 2022-10-31 04:21:36 | Kamchatka Krai, Russia | |||
326968 | 326968 | 2020-07-20 | Russia | Kamchatka Krai | 3017 | 42 | 2209 | 766 | 57.1914882 | 160.03838190000005 | 2020-07-21 04:38:46 | Kamchatka Krai, Russia | ||
328118 | 328118 | 2022-12-27 | Russia | Kamchatka Krai | 44578 | 625 | 0 | 57.1914882 | 160.0383819 | 2022-12-28 04:21:04 | Kamchatka Krai, Russia | |||
332113 | 332113 | 2021-08-04 | Russia | Kamchatka Krai | 16997 | 242 | 14555 | 2200 | 57.1914882 | 160.03838190000005 | 2021-08-05 04:21:51 | Kamchatka Krai, Russia | ||
336145 | 336145 | 2022-03-18 | Russia | Kamchatka Krai | 38609 | 609 | 0 | 57.191488199999995 | 160.03838190000005 | 2022-03-19 04:20:47 | Kamchatka Krai, Russia | |||
340479 | 340479 | 2021-02-03 | Russia | Kamchatka Krai | 12448 | 84 | 11038 | 1326 | 57.1914882 | 160.03838190000005 | 2021-02-04 05:22:26 | Kamchatka Krai, Russia | ||
344476 | 344476 | 2020-09-14 | Russia | Kamchatka Krai | 4099 | 60 | 3218 | 821 | 57.1914882 | 160.03838190000005 | 2020-09-15 03:22:50 | Kamchatka Krai, Russia | ||
348508 | 348508 | 2022-12-14 | Russia | Kamchatka Krai | 44534 | 625 | 0 | 57.1914882 | 160.0383819 | 2022-12-15 04:20:58 | Kamchatka Krai, Russia | |||
352500 | 352500 | 2021-03-11 | Russia | Kamchatka Krai | 13791 | 149 | 12601 | 1041 | 57.1914882 | 160.03838190000005 | 2021-03-12 05:26:50 | Kamchatka Krai, Russia | ||
356535 | 356535 | 2022-03-11 | Russia | Kamchatka Krai | 38174 | 603 | 0 | 57.191488199999995 | 160.03838190000005 | 2022-03-12 04:20:50 | Kamchatka Krai, Russia | |||
360551 | 360551 | 2022-05-07 | Russia | Kamchatka Krai | 39662 | 611 | 0 | 57.1914882 | 160.0383819 | 2022-05-08 04:20:49 | Kamchatka Krai, Russia | |||
367377 | 367377 | 2020-07-16 | Russia | Kamchatka Krai | 2876 | 35 | 2081 | 760 | 57.191488199999995 | 160.03838190000005 | 2020-07-17 04:34:50 | Kamchatka Krai, Russia | ||
371345 | 371345 | 2020-08-08 | Russia | Kamchatka Krai | 3501 | 42 | 3047 | 412 | 57.191488199999995 | 160.03838190000005 | 2020-08-09 04:34:54 | Kamchatka Krai, Russia | ||
372408 | 372408 | 2022-09-13 | Russia | Kamchatka Krai | 42831 | 621 | 0 | 57.1914882 | 160.0383819 | 2022-09-14 04:20:44 | Kamchatka Krai, Russia | |||
376384 | 376384 | 2020-11-06 | Russia | Kamchatka Krai | 6122 | 70 | 3916 | 2136 | 57.1914882 | 160.03838190000005 | 2020-11-07 05:24:52 | Kamchatka Krai, Russia | ||
380397 | 380397 | 2021-04-30 | Russia | Kamchatka Krai | 14452 | 230 | 13802 | 420 | 57.1914882 | 160.03838190000005 | 2021-05-01 04:20:47 | Kamchatka Krai, Russia | ||
384435 | 384435 | 2022-09-23 | Russia | Kamchatka Krai | 43351 | 623 | 0 | 57.1914882 | 160.0383819 | 2022-09-24 04:21:40 | Kamchatka Krai, Russia | |||
388427 | 388427 | 2021-04-04 | Russia | Kamchatka Krai | 14176 | 204 | 13316 | 656 | 57.1914882 | 160.03838190000005 | 2021-04-05 04:20:35 | Kamchatka Krai, Russia | ||
392438 | 392438 | 2020-11-27 | Russia | Kamchatka Krai | 7416 | 75 | 5202 | 2139 | 57.1914882 | 160.03838190000005 | 2020-11-28 05:25:50 | Kamchatka Krai, Russia | ||
396476 | 396476 | 2022-10-07 | Russia | Kamchatka Krai | 43935 | 624 | 0 | 57.1914882 | 160.0383819 | 2022-10-08 04:22:56 | Kamchatka Krai, Russia | |||
400471 | 400471 | 2021-06-29 | Russia | Kamchatka Krai | 15236 | 238 | 14131 | 867 | 57.1914882 | 160.03838190000005 | 2021-06-30 04:21:41 | Kamchatka Krai, Russia | ||
404502 | 404502 | 2021-12-07 | Russia | Kamchatka Krai | 22747 | 487 | 0 | 57.191488199999995 | 160.03838190000005 | 2021-12-08 04:22:46 | Kamchatka Krai, Russia | |||
408501 | 408501 | 2021-07-28 | Russia | Kamchatka Krai | 16616 | 242 | 14456 | 1918 | 57.1914882 | 160.03838190000005 | 2021-07-29 04:21:33 | Kamchatka Krai, Russia | ||
415321 | 415321 | 2020-07-05 | Russia | Kamchatka Krai | 2422 | 28 | 1256 | 1138 | 57.1914882 | 160.03838190000005 | 2020-07-06 04:33:57 | Kamchatka Krai, Russia | ||
419547 | 419547 | 2022-09-18 | Russia | Kamchatka Krai | 43095 | 621 | 0 | 57.1914882 | 160.0383819 | 2022-09-19 04:21:49 | Kamchatka Krai, Russia | |||
423559 | 423559 | 2021-10-10 | Russia | Kamchatka Krai | 20129 | 381 | 0 | 57.191488199999995 | 160.03838190000005 | 2021-10-11 04:21:31 | Kamchatka Krai, 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]);