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 longitude descending
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 | ||
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 | |||
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 | ||
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 | |||
138179 | 138179 | 2021-12-04 | Russia | Kamchatka Krai | 22601 | 485 | 0 | 57.191488199999995 | 160.03838190000005 | 2021-12-05 04:22:25 | 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 | |||
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 | ||
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 | ||
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 | |||
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 | |||
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 | |||
316125 | 316125 | 2022-02-12 | Russia | Kamchatka Krai | 29847 | 561 | 0 | 57.191488199999995 | 160.03838190000005 | 2022-02-13 04:21:00 | 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 | ||
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 | ||
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 | |||
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 | ||
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 | ||
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 | ||
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 | ||
423559 | 423559 | 2021-10-10 | Russia | Kamchatka Krai | 20129 | 381 | 0 | 57.191488199999995 | 160.03838190000005 | 2021-10-11 04:21:31 | Kamchatka Krai, Russia | |||
427537 | 427537 | 2020-09-07 | Russia | Kamchatka Krai | 3955 | 42 | 3195 | 718 | 57.1914882 | 160.03838190000005 | 2020-09-08 04:28:25 | Kamchatka Krai, Russia | ||
435560 | 435560 | 2021-01-21 | Russia | Kamchatka Krai | 11647 | 83 | 10220 | 1344 | 57.1914882 | 160.03838190000005 | 2021-01-22 05:22:10 | Kamchatka Krai, Russia | ||
442504 | 442504 | 2020-07-26 | Russia | Kamchatka Krai | 3240 | 42 | 2663 | 535 | 57.191488199999995 | 160.03838190000005 | 2020-07-27 04:35:02 | Kamchatka Krai, Russia | ||
443563 | 443563 | 2021-10-20 | Russia | Kamchatka Krai | 20535 | 409 | 0 | 57.191488199999995 | 160.03838190000005 | 2021-10-21 04:21:18 | Kamchatka Krai, Russia | |||
447579 | 447579 | 2021-11-17 | Russia | Kamchatka Krai | 21788 | 474 | 0 | 57.191488199999995 | 160.03838190000005 | 2021-11-18 04:21:33 | Kamchatka Krai, Russia | |||
458529 | 458529 | 2020-08-07 | Russia | Kamchatka Krai | 3483 | 42 | 3036 | 405 | 57.191488199999995 | 160.03838190000005 | 2020-08-08 04:34:53 | Kamchatka Krai, Russia | ||
459588 | 459588 | 2022-02-02 | Russia | Kamchatka Krai | 26454 | 542 | 0 | 57.191488199999995 | 160.03838190000005 | 2022-02-03 04:21:21 | Kamchatka Krai, Russia | |||
467620 | 467620 | 2021-10-07 | Russia | Kamchatka Krai | 20006 | 369 | 0 | 57.191488199999995 | 160.03838190000005 | 2021-10-08 04:21:25 | Kamchatka Krai, Russia | |||
471616 | 471616 | 2021-02-19 | Russia | Kamchatka Krai | 13185 | 118 | 11705 | 1362 | 57.1914882 | 160.03838190000005 | 2021-02-20 05:22:51 | Kamchatka Krai, Russia | ||
483797 | 483797 | 2021-07-19 | Russia | Kamchatka Krai | 16149 | 238 | 14356 | 1555 | 57.1914882 | 160.03838190000005 | 2021-07-20 04:21:48 | Kamchatka Krai, Russia | ||
491844 | 491844 | 2021-10-14 | Russia | Kamchatka Krai | 20291 | 391 | 0 | 57.191488199999995 | 160.03838190000005 | 2021-10-15 04:21:26 | Kamchatka Krai, Russia | |||
495860 | 495860 | 2021-11-06 | Russia | Kamchatka Krai | 21270 | 460 | 0 | 57.191488199999995 | 160.03838190000005 | 2021-11-07 04:21:53 | Kamchatka Krai, Russia | |||
499877 | 499877 | 2022-04-02 | Russia | Kamchatka Krai | 39099 | 609 | 0 | 57.191488199999995 | 160.03838190000005 | 2022-04-03 04:20:48 | Kamchatka Krai, Russia | |||
507891 | 507891 | 2021-08-14 | Russia | Kamchatka Krai | 17540 | 244 | 0 | 57.191488199999995 | 160.03838190000005 | 2021-08-15 04:21:41 | Kamchatka Krai, Russia | |||
511905 | 511905 | 2021-08-19 | Russia | Kamchatka Krai | 17802 | 244 | 0 | 57.191488199999995 | 160.03838190000005 | 2021-08-20 04:21:33 | Kamchatka Krai, Russia | |||
523062 | 523062 | 2021-06-09 | Russia | Kamchatka Krai | 14781 | 238 | 14083 | 460 | 57.1914882 | 160.03838190000005 | 2021-06-10 04:23:17 | Kamchatka Krai, Russia | ||
529883 | 529883 | 2020-07-04 | Russia | Kamchatka Krai | 2380 | 28 | 1175 | 1177 | 57.1914882 | 160.03838190000005 | 2020-07-05 04:33:46 | Kamchatka Krai, Russia | ||
530910 | 530910 | 2021-02-22 | Russia | Kamchatka Krai | 13300 | 118 | 11840 | 1342 | 57.1914882 | 160.03838190000005 | 2021-02-23 05:23:41 | Kamchatka Krai, Russia | ||
534944 | 534944 | 2021-10-27 | Russia | Kamchatka Krai | 20828 | 428 | 0 | 57.191488199999995 | 160.03838190000005 | 2021-10-28 04:22:08 | Kamchatka Krai, Russia | |||
546954 | 546954 | 2020-09-12 | Russia | Kamchatka Krai | 4053 | 54 | 3218 | 781 | 57.1914882 | 160.03838190000005 | 2020-09-13 04:30:52 | Kamchatka Krai, Russia | ||
550982 | 550982 | 2021-12-08 | Russia | Kamchatka Krai | 22796 | 490 | 0 | 57.191488199999995 | 160.03838190000005 | 2021-12-09 04:22:49 | Kamchatka Krai, Russia | |||
554998 | 554998 | 2022-01-16 | Russia | Kamchatka Krai | 24216 | 519 | 0 | 57.191488199999995 | 160.03838190000005 | 2022-01-17 04:21:08 | Kamchatka Krai, Russia | |||
563174 | 563174 | 2021-06-22 | Russia | Kamchatka Krai | 14967 | 238 | 14096 | 633 | 57.1914882 | 160.03838190000005 | 2021-06-23 04:21:46 | 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]);