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 = "Chelyabinsk Oblast" sorted by active
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
526 | 526 | 2021-12-02 | Russia | Chelyabinsk Oblast | 128124 | 5197 | 0 | 54.4223954 | 61.1865846 | 2021-12-03 04:23:05 | Chelyabinsk Oblast, Russia | |||
4542 | 4542 | 2021-10-28 | Russia | Chelyabinsk Oblast | 107621 | 4161 | 0 | 54.4223954 | 61.1865846 | 2021-10-29 04:22:03 | Chelyabinsk Oblast, Russia | |||
16550 | 16550 | 2021-09-18 | Russia | Chelyabinsk Oblast | 91593 | 3122 | 0 | 54.4223954 | 61.1865846 | 2021-09-19 04:21:34 | Chelyabinsk Oblast, Russia | |||
24597 | 24597 | 2022-03-20 | Russia | Chelyabinsk Oblast | 310550 | 7296 | 0 | 54.4223954 | 61.1865846 | 2022-03-21 04:20:50 | Chelyabinsk Oblast, Russia | |||
28612 | 28612 | 2021-11-11 | Russia | Chelyabinsk Oblast | 115128 | 4572 | 0 | 54.4223954 | 61.1865846 | 2021-11-12 04:22:01 | Chelyabinsk Oblast, Russia | |||
32611 | 32611 | 2021-08-25 | Russia | Chelyabinsk Oblast | 82696 | 2615 | 0 | 54.4223954 | 61.1865846 | 2021-08-26 04:21:28 | Chelyabinsk Oblast, Russia | |||
43904 | 43904 | 2021-11-02 | Russia | Chelyabinsk Oblast | 110123 | 4306 | 0 | 54.4223954 | 61.1865846 | 2021-11-03 06:22:09 | Chelyabinsk Oblast, Russia | |||
63261 | 63261 | 2022-11-12 | Russia | Chelyabinsk Oblast | 390589 | 8109 | 0 | 54.4223954 | 61.1865846 | 2022-11-13 04:21:14 | Chelyabinsk Oblast, Russia | |||
67256 | 67256 | 2021-09-01 | Russia | Chelyabinsk Oblast | 85335 | 2769 | 0 | 54.4223954 | 61.1865846 | 2021-09-02 04:21:15 | Chelyabinsk Oblast, Russia | |||
71287 | 71287 | 2022-02-07 | Russia | Chelyabinsk Oblast | 193234 | 6569 | 0 | 54.4223954 | 61.1865846 | 2022-02-08 04:21:15 | Chelyabinsk Oblast, Russia | |||
87321 | 87321 | 2021-11-09 | Russia | Chelyabinsk Oblast | 113986 | 4514 | 0 | 54.4223954 | 61.1865846 | 2021-11-10 04:21:38 | Chelyabinsk Oblast, Russia | |||
91339 | 91339 | 2022-07-23 | Russia | Chelyabinsk Oblast | 335674 | 7816 | 0 | 54.4223954 | 61.1865846 | 2022-07-24 04:20:47 | Chelyabinsk Oblast, Russia | |||
99522 | 99522 | 2022-01-14 | Russia | Chelyabinsk Oblast | 149943 | 6362 | 0 | 54.4223954 | 61.1865846 | 2022-01-15 04:21:07 | Chelyabinsk Oblast, Russia | |||
103521 | 103521 | 2021-08-15 | Russia | Chelyabinsk Oblast | 78881 | 2421 | 0 | 54.4223954 | 61.1865846 | 2021-08-16 04:21:31 | Chelyabinsk Oblast, Russia | |||
114949 | 114949 | 2022-09-06 | Russia | Chelyabinsk Oblast | 351016 | 7870 | 0 | 54.4223954 | 61.1865846 | 2022-09-07 04:20:59 | Chelyabinsk Oblast, Russia | |||
126929 | 126929 | 2022-01-09 | Russia | Chelyabinsk Oblast | 148731 | 6276 | 0 | 54.4223954 | 61.1865846 | 2022-01-10 04:22:07 | Chelyabinsk Oblast, Russia | |||
130949 | 130949 | 2022-10-04 | Russia | Chelyabinsk Oblast | 378172 | 7947 | 0 | 54.4223954 | 61.1865846 | 2022-10-05 04:23:06 | Chelyabinsk Oblast, Russia | |||
138167 | 138167 | 2021-12-04 | Russia | Chelyabinsk Oblast | 129416 | 5258 | 0 | 54.4223954 | 61.1865846 | 2021-12-05 04:22:25 | Chelyabinsk Oblast, Russia | |||
142185 | 142185 | 2022-07-09 | Russia | Chelyabinsk Oblast | 334248 | 7791 | 0 | 54.4223954 | 61.1865846 | 2022-07-10 04:20:54 | Chelyabinsk Oblast, Russia | |||
150180 | 150180 | 2021-11-29 | Russia | Chelyabinsk Oblast | 126162 | 5108 | 0 | 54.4223954 | 61.1865846 | 2021-11-30 04:22:53 | Chelyabinsk Oblast, Russia | |||
158209 | 158209 | 2022-03-29 | Russia | Chelyabinsk Oblast | 315782 | 7400 | 0 | 54.4223954 | 61.1865846 | 2022-03-30 04:20:45 | Chelyabinsk Oblast, Russia | |||
162224 | 162224 | 2021-11-19 | Russia | Chelyabinsk Oblast | 119834 | 4810 | 0 | 54.4223954 | 61.1865846 | 2021-11-20 04:22:17 | Chelyabinsk Oblast, Russia | |||
166242 | 166242 | 2022-06-21 | Russia | Chelyabinsk Oblast | 332616 | 7746 | 0 | 54.4223954 | 61.1865846 | 2022-06-22 04:20:54 | Chelyabinsk Oblast, Russia | |||
178221 | 178221 | 2021-09-02 | Russia | Chelyabinsk Oblast | 85709 | 2790 | 0 | 54.4223954 | 61.1865846 | 2021-09-03 04:21:20 | Chelyabinsk Oblast, Russia | |||
186267 | 186267 | 2022-02-13 | Russia | Chelyabinsk Oblast | 221007 | 6672 | 0 | 54.4223954 | 61.1865846 | 2022-02-14 04:20:51 | Chelyabinsk Oblast, Russia | |||
198458 | 198458 | 2022-10-19 | Russia | Chelyabinsk Oblast | 386601 | 8023 | 0 | 54.4223954 | 61.1865846 | 2022-10-20 04:22:59 | Chelyabinsk Oblast, Russia | |||
218179 | 218179 | 2022-12-26 | Russia | Chelyabinsk Oblast | 394746 | 8184 | 0 | 54.4223954 | 61.1865846 | 2022-12-27 04:21:07 | Chelyabinsk Oblast, Russia | |||
222192 | 222192 | 2022-05-09 | Russia | Chelyabinsk Oblast | 327815 | 7615 | 0 | 54.4223954 | 61.1865846 | 2022-05-10 04:20:50 | Chelyabinsk Oblast, Russia | |||
229424 | 229424 | 2022-05-31 | Russia | Chelyabinsk Oblast | 330589 | 7690 | 0 | 54.4223954 | 61.1865846 | 2022-06-01 04:20:55 | Chelyabinsk Oblast, Russia | |||
233439 | 233439 | 2022-02-11 | Russia | Chelyabinsk Oblast | 211006 | 6637 | 0 | 54.4223954 | 61.1865846 | 2022-02-12 04:21:06 | Chelyabinsk Oblast, Russia | |||
245464 | 245464 | 2021-08-17 | Russia | Chelyabinsk Oblast | 79646 | 2462 | 0 | 54.4223954 | 61.1865846 | 2021-08-18 04:21:35 | Chelyabinsk Oblast, Russia | |||
249478 | 249478 | 2021-09-04 | Russia | Chelyabinsk Oblast | 86456 | 2823 | 0 | 54.4223954 | 61.1865846 | 2021-09-05 04:21:33 | Chelyabinsk Oblast, Russia | |||
253511 | 253511 | 2022-09-08 | Russia | Chelyabinsk Oblast | 352479 | 7874 | 0 | 54.4223954 | 61.1865846 | 2022-09-09 04:21:11 | Chelyabinsk Oblast, Russia | |||
257529 | 257529 | 2022-12-10 | Russia | Chelyabinsk Oblast | 393298 | 8164 | 0 | 54.4223954 | 61.1865846 | 2022-12-11 04:20:50 | Chelyabinsk Oblast, Russia | |||
261729 | 261729 | 2022-03-15 | Russia | Chelyabinsk Oblast | 307288 | 7216 | 0 | 54.4223954 | 61.1865846 | 2022-03-16 04:20:50 | Chelyabinsk Oblast, Russia | |||
276379 | 276379 | 2021-11-03 | Russia | Chelyabinsk Oblast | 110654 | 4336 | 0 | 54.4223954 | 61.1865846 | 2021-11-04 04:22:20 | Chelyabinsk Oblast, Russia | |||
288192 | 288192 | 2021-10-31 | Russia | Chelyabinsk Oblast | 109095 | 4248 | 0 | 54.4223954 | 61.1865846 | 2021-11-01 04:22:01 | Chelyabinsk Oblast, Russia | |||
292212 | 292212 | 2022-11-15 | Russia | Chelyabinsk Oblast | 390870 | 8115 | 0 | 54.4223954 | 61.1865846 | 2022-11-16 04:21:09 | Chelyabinsk Oblast, Russia | |||
304065 | 304065 | 2022-04-16 | Russia | Chelyabinsk Oblast | 323499 | 7530 | 0 | 54.4223954 | 61.1865846 | 2022-04-17 04:20:59 | Chelyabinsk Oblast, Russia | |||
308084 | 308084 | 2022-12-13 | Russia | Chelyabinsk Oblast | 393577 | 8168 | 0 | 54.4223954 | 61.1865846 | 2022-12-14 04:21:04 | Chelyabinsk Oblast, Russia | |||
312100 | 312100 | 2022-11-13 | Russia | Chelyabinsk Oblast | 390683 | 8111 | 0 | 54.4223954 | 61.1865846 | 2022-11-14 04:21:09 | Chelyabinsk Oblast, Russia | |||
316113 | 316113 | 2022-02-12 | Russia | Chelyabinsk Oblast | 216003 | 6654 | 0 | 54.4223954 | 61.1865846 | 2022-02-13 04:21:00 | Chelyabinsk Oblast, Russia | |||
320132 | 320132 | 2022-10-30 | Russia | Chelyabinsk Oblast | 389097 | 8069 | 0 | 54.4223954 | 61.1865846 | 2022-10-31 04:21:36 | Chelyabinsk Oblast, Russia | |||
328106 | 328106 | 2022-12-27 | Russia | Chelyabinsk Oblast | 394824 | 8185 | 0 | 54.4223954 | 61.1865846 | 2022-12-28 04:21:04 | Chelyabinsk Oblast, Russia | |||
336133 | 336133 | 2022-03-18 | Russia | Chelyabinsk Oblast | 309348 | 7266 | 0 | 54.4223954 | 61.1865846 | 2022-03-19 04:20:47 | Chelyabinsk Oblast, Russia | |||
348496 | 348496 | 2022-12-14 | Russia | Chelyabinsk Oblast | 393671 | 8169 | 0 | 54.4223954 | 61.1865846 | 2022-12-15 04:20:58 | Chelyabinsk Oblast, Russia | |||
356523 | 356523 | 2022-03-11 | Russia | Chelyabinsk Oblast | 303188 | 7141 | 0 | 54.4223954 | 61.1865846 | 2022-03-12 04:20:50 | Chelyabinsk Oblast, Russia | |||
360539 | 360539 | 2022-05-07 | Russia | Chelyabinsk Oblast | 327490 | 7607 | 0 | 54.4223954 | 61.1865846 | 2022-05-08 04:20:49 | Chelyabinsk Oblast, Russia | |||
372396 | 372396 | 2022-09-13 | Russia | Chelyabinsk Oblast | 356258 | 7882 | 0 | 54.4223954 | 61.1865846 | 2022-09-14 04:20:44 | Chelyabinsk Oblast, Russia | |||
384423 | 384423 | 2022-09-23 | Russia | Chelyabinsk Oblast | 365701 | 7908 | 0 | 54.4223954 | 61.1865846 | 2022-09-24 04:21:40 | Chelyabinsk Oblast, Russia | |||
396464 | 396464 | 2022-10-07 | Russia | Chelyabinsk Oblast | 380562 | 7963 | 0 | 54.4223954 | 61.1865846 | 2022-10-08 04:22:56 | Chelyabinsk Oblast, Russia | |||
404490 | 404490 | 2021-12-07 | Russia | Chelyabinsk Oblast | 131335 | 5347 | 0 | 54.4223954 | 61.1865846 | 2021-12-08 04:22:46 | Chelyabinsk Oblast, Russia | |||
419535 | 419535 | 2022-09-18 | Russia | Chelyabinsk Oblast | 360528 | 7894 | 0 | 54.4223954 | 61.1865846 | 2022-09-19 04:21:49 | Chelyabinsk Oblast, Russia | |||
423547 | 423547 | 2021-10-10 | Russia | Chelyabinsk Oblast | 99962 | 3655 | 0 | 54.4223954 | 61.1865846 | 2021-10-11 04:21:31 | Chelyabinsk Oblast, Russia | |||
431557 | 431557 | 2022-11-03 | Russia | Chelyabinsk Oblast | 389711 | 8081 | 0 | 54.4223954 | 61.1865846 | 2022-11-04 04:22:11 | Chelyabinsk Oblast, Russia | |||
443551 | 443551 | 2021-10-20 | Russia | Chelyabinsk Oblast | 104075 | 3927 | 0 | 54.4223954 | 61.1865846 | 2021-10-21 04:21:18 | Chelyabinsk Oblast, Russia | |||
447567 | 447567 | 2021-11-17 | Russia | Chelyabinsk Oblast | 118636 | 4750 | 0 | 54.4223954 | 61.1865846 | 2021-11-18 04:21:33 | Chelyabinsk Oblast, Russia | |||
451587 | 451587 | 2022-12-21 | Russia | Chelyabinsk Oblast | 394336 | 8180 | 0 | 54.4223954 | 61.1865846 | 2022-12-22 04:20:56 | Chelyabinsk Oblast, Russia | |||
459576 | 459576 | 2022-02-02 | Russia | Chelyabinsk Oblast | 170858 | 6504 | 0 | 54.4223954 | 61.1865846 | 2022-02-03 04:21:21 | Chelyabinsk Oblast, Russia | |||
463593 | 463593 | 2022-05-02 | Russia | Chelyabinsk Oblast | 326635 | 7581 | 0 | 54.4223954 | 61.1865846 | 2022-05-03 04:21:00 | Chelyabinsk Oblast, Russia | |||
467608 | 467608 | 2021-10-07 | Russia | Chelyabinsk Oblast | 98764 | 3574 | 0 | 54.4223954 | 61.1865846 | 2021-10-08 04:21:25 | Chelyabinsk Oblast, Russia | |||
475640 | 475640 | 2022-06-26 | Russia | Chelyabinsk Oblast | 333076 | 7761 | 0 | 54.4223954 | 61.1865846 | 2022-06-27 04:21:00 | Chelyabinsk Oblast, Russia | |||
479790 | 479790 | 2022-11-08 | Russia | Chelyabinsk Oblast | 390215 | 8096 | 0 | 54.4223954 | 61.1865846 | 2022-11-09 04:21:22 | Chelyabinsk Oblast, Russia | |||
487820 | 487820 | 2022-11-25 | Russia | Chelyabinsk Oblast | 391838 | 8140 | 0 | 54.4223954 | 61.1865846 | 2022-11-26 04:21:11 | Chelyabinsk Oblast, Russia | |||
491832 | 491832 | 2021-10-14 | Russia | Chelyabinsk Oblast | 101580 | 3760 | 0 | 54.4223954 | 61.1865846 | 2021-10-15 04:21:26 | Chelyabinsk Oblast, Russia | |||
495848 | 495848 | 2021-11-06 | Russia | Chelyabinsk Oblast | 112295 | 4425 | 0 | 54.4223954 | 61.1865846 | 2021-11-07 04:21:53 | Chelyabinsk Oblast, Russia | |||
499865 | 499865 | 2022-04-02 | Russia | Chelyabinsk Oblast | 317907 | 7434 | 0 | 54.4223954 | 61.1865846 | 2022-04-03 04:20:48 | Chelyabinsk Oblast, Russia | |||
503884 | 503884 | 2022-12-17 | Russia | Chelyabinsk Oblast | 393967 | 8176 | 0 | 54.4223954 | 61.1865846 | 2022-12-18 04:21:03 | Chelyabinsk Oblast, Russia | |||
507879 | 507879 | 2021-08-14 | Russia | Chelyabinsk Oblast | 78503 | 2401 | 0 | 54.4223954 | 61.1865846 | 2021-08-15 04:21:41 | Chelyabinsk Oblast, Russia | |||
511893 | 511893 | 2021-08-19 | Russia | Chelyabinsk Oblast | 80417 | 2503 | 0 | 54.4223954 | 61.1865846 | 2021-08-20 04:21:33 | Chelyabinsk Oblast, Russia | |||
515928 | 515928 | 2022-10-15 | Russia | Chelyabinsk Oblast | 385017 | 8003 | 0 | 54.4223954 | 61.1865846 | 2022-10-16 04:22:39 | Chelyabinsk Oblast, Russia | |||
534932 | 534932 | 2021-10-27 | Russia | Chelyabinsk Oblast | 107148 | 4132 | 0 | 54.4223954 | 61.1865846 | 2021-10-28 04:22:08 | Chelyabinsk Oblast, Russia | |||
538952 | 538952 | 2022-10-26 | Russia | Chelyabinsk Oblast | 388333 | 8050 | 0 | 54.4223954 | 61.1865846 | 2022-10-27 04:22:01 | Chelyabinsk Oblast, Russia | |||
542968 | 542968 | 2022-12-15 | Russia | Chelyabinsk Oblast | 393772 | 8171 | 0 | 54.4223954 | 61.1865846 | 2022-12-16 04:21:01 | Chelyabinsk Oblast, Russia | |||
550970 | 550970 | 2021-12-08 | Russia | Chelyabinsk Oblast | 131968 | 5376 | 0 | 54.4223954 | 61.1865846 | 2021-12-09 04:22:49 | Chelyabinsk Oblast, Russia | |||
554986 | 554986 | 2022-01-16 | Russia | Chelyabinsk Oblast | 150343 | 6373 | 0 | 54.4223954 | 61.1865846 | 2022-01-17 04:21:08 | Chelyabinsk Oblast, Russia | |||
559004 | 559004 | 2022-06-16 | Russia | Chelyabinsk Oblast | 332154 | 7732 | 0 | 54.4223954 | 61.1865846 | 2022-06-17 04:20:56 | Chelyabinsk Oblast, Russia | |||
567300 | 567300 | 2021-10-29 | Russia | Chelyabinsk Oblast | 108101 | 4191 | 0 | 54.4223954 | 61.1865846 | 2021-10-30 04:22:03 | Chelyabinsk Oblast, Russia | |||
575029 | 575029 | 2022-02-25 | Russia | Chelyabinsk Oblast | 270607 | 6904 | 0 | 54.4223954 | 61.1865846 | 2022-02-26 04:21:12 | Chelyabinsk Oblast, Russia | |||
589823 | 589823 | 2021-08-08 | Russia | Chelyabinsk Oblast | 76301 | 2288 | 0 | 54.4223954 | 61.1865846 | 2021-08-09 04:21:24 | Chelyabinsk Oblast, Russia | |||
593856 | 593856 | 2022-07-01 | Russia | Chelyabinsk Oblast | 333531 | 7773 | 0 | 54.4223954 | 61.1865846 | 2022-07-02 04:21:16 | Chelyabinsk Oblast, Russia | |||
597870 | 597870 | 2021-10-19 | Russia | Chelyabinsk Oblast | 103653 | 3899 | 0 | 54.4223954 | 61.1865846 | 2021-10-20 04:21:00 | Chelyabinsk Oblast, Russia | |||
601886 | 601886 | 2021-09-23 | Russia | Chelyabinsk Oblast | 93416 | 3228 | 0 | 54.4223954 | 61.1865846 | 2021-09-24 04:21:44 | Chelyabinsk Oblast, Russia | |||
618062 | 618062 | 2022-11-05 | Russia | Chelyabinsk Oblast | 389926 | 8089 | 0 | 54.4223954 | 61.1865846 | 2022-11-06 04:21:24 | Chelyabinsk Oblast, Russia | |||
622076 | 622076 | 2022-05-22 | Russia | Chelyabinsk Oblast | 329920 | 7674 | 0 | 54.4223954 | 61.1865846 | 2022-05-26 04:20:50 | Chelyabinsk Oblast, Russia | |||
630106 | 630106 | 2022-07-12 | Russia | Chelyabinsk Oblast | 334514 | 7795 | 0 | 54.4223954 | 61.1865846 | 2022-07-13 04:20:58 | Chelyabinsk Oblast, Russia | |||
634120 | 634120 | 2021-10-13 | Russia | Chelyabinsk Oblast | 101173 | 3734 | 0 | 54.4223954 | 61.1865846 | 2021-10-14 04:21:29 | Chelyabinsk Oblast, Russia | |||
642133 | 642133 | 2021-09-07 | Russia | Chelyabinsk Oblast | 87568 | 2886 | 0 | 54.4223954 | 61.1865846 | 2021-09-08 04:21:31 | Chelyabinsk Oblast, Russia | |||
650161 | 650161 | 2021-08-09 | Russia | Chelyabinsk Oblast | 76661 | 2305 | 0 | 54.4223954 | 61.1865846 | 2021-08-10 04:21:27 | Chelyabinsk Oblast, Russia | |||
654192 | 654192 | 2021-10-22 | Russia | Chelyabinsk Oblast | 104929 | 3985 | 0 | 54.4223954 | 61.1865846 | 2021-10-23 04:21:32 | Chelyabinsk Oblast, Russia | |||
658511 | 658511 | 2022-05-13 | Russia | Chelyabinsk Oblast | 328409 | 7631 | 0 | 54.4223954 | 61.1865846 | 2022-05-14 04:20:48 | Chelyabinsk Oblast, Russia | |||
670497 | 670497 | 2022-07-21 | Russia | Chelyabinsk Oblast | 335417 | 7812 | 0 | 54.4223954 | 61.1865846 | 2022-07-22 04:21:15 | Chelyabinsk Oblast, Russia | |||
674513 | 674513 | 2022-07-30 | Russia | Chelyabinsk Oblast | 336775 | 7826 | 0 | 54.4223954 | 61.1865846 | 2022-07-31 04:21:02 | Chelyabinsk Oblast, Russia | |||
682537 | 682537 | 2021-10-24 | Russia | Chelyabinsk Oblast | 105796 | 4044 | 0 | 54.4223954 | 61.1865846 | 2021-10-25 04:22:31 | Chelyabinsk Oblast, Russia | |||
686553 | 686553 | 2021-11-13 | Russia | Chelyabinsk Oblast | 116285 | 4631 | 0 | 54.4223954 | 61.1865846 | 2021-11-14 04:21:31 | Chelyabinsk Oblast, Russia | |||
690573 | 690573 | 2022-12-23 | Russia | Chelyabinsk Oblast | 394505 | 8181 | 0 | 54.4223954 | 61.1865846 | 2022-12-24 04:21:02 | Chelyabinsk Oblast, Russia | |||
694586 | 694586 | 2022-03-17 | Russia | Chelyabinsk Oblast | 308723 | 7251 | 0 | 54.4223954 | 61.1865846 | 2022-03-18 04:20:55 | Chelyabinsk Oblast, Russia | |||
698601 | 698601 | 2021-11-04 | Russia | Chelyabinsk Oblast | 111193 | 4365 | 0 | 54.4223954 | 61.1865846 | 2021-11-05 04:21:54 | Chelyabinsk Oblast, Russia | |||
706631 | 706631 | 2021-09-29 | Russia | Chelyabinsk Oblast | 95652 | 3366 | 0 | 54.4223954 | 61.1865846 | 2021-09-30 04:21:20 | Chelyabinsk Oblast, Russia | |||
710650 | 710650 | 2022-11-01 | Russia | Chelyabinsk Oblast | 389435 | 8075 | 0 | 54.4223954 | 61.1865846 | 2022-11-02 04:22:09 | Chelyabinsk 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]);