johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
942 rows where province_or_state = "Zaporizhia Oblast" sorted by active
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, active, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3979 | 3979 | 2021-12-02 | Ukraine | Zaporizhia Oblast | 172575 | 4486 | 0 | 47.8388 | 35.1396 | 2021-12-03 04:23:05 | Zaporizhia Oblast, Ukraine | |||
7994 | 7994 | 2021-10-28 | Ukraine | Zaporizhia Oblast | 138903 | 3256 | 0 | 47.8388 | 35.1396 | 2021-10-29 04:22:03 | Zaporizhia Oblast, Ukraine | |||
20001 | 20001 | 2021-09-18 | Ukraine | Zaporizhia Oblast | 109322 | 2555 | 0 | 47.8388 | 35.1396 | 2021-09-19 04:21:34 | Zaporizhia Oblast, Ukraine | |||
28050 | 28050 | 2022-03-20 | Ukraine | Zaporizhia Oblast | 215070 | 5866 | 0 | 47.8388 | 35.1396 | 2022-03-01 23:21:04 | Zaporizhia Oblast, Ukraine | |||
32065 | 32065 | 2021-11-11 | Ukraine | Zaporizhia Oblast | 154715 | 3672 | 0 | 47.8388 | 35.1396 | 2021-11-12 04:22:01 | Zaporizhia Oblast, Ukraine | |||
36061 | 36061 | 2021-08-25 | Ukraine | Zaporizhia Oblast | 106479 | 2470 | 0 | 47.8388 | 35.1396 | 2021-08-26 04:21:28 | Zaporizhia Oblast, Ukraine | |||
47357 | 47357 | 2021-11-02 | Ukraine | Zaporizhia Oblast | 144446 | 3411 | 0 | 47.8388 | 35.1396 | 2021-11-03 06:22:09 | Zaporizhia Oblast, Ukraine | |||
66716 | 66716 | 2022-11-12 | Ukraine | Zaporizhia Oblast | 215070 | 5866 | 0 | 47.8388 | 35.1396 | 2022-11-13 04:21:14 | Zaporizhia Oblast, Ukraine | |||
70706 | 70706 | 2021-09-01 | Ukraine | Zaporizhia Oblast | 106928 | 2484 | 0 | 47.8388 | 35.1396 | 2021-09-02 04:21:15 | Zaporizhia Oblast, Ukraine | |||
74740 | 74740 | 2022-02-07 | Ukraine | Zaporizhia Oblast | 194516 | 5623 | 0 | 47.8388 | 35.1396 | 2022-02-08 04:21:15 | Zaporizhia Oblast, Ukraine | |||
90774 | 90774 | 2021-11-09 | Ukraine | Zaporizhia Oblast | 152446 | 3620 | 0 | 47.8388 | 35.1396 | 2021-11-10 04:21:38 | Zaporizhia Oblast, Ukraine | |||
94793 | 94793 | 2022-07-23 | Ukraine | Zaporizhia Oblast | 215070 | 5866 | 0 | 47.8388 | 35.1396 | 2022-07-24 04:20:47 | Zaporizhia Oblast, Ukraine | |||
102975 | 102975 | 2022-01-14 | Ukraine | Zaporizhia Oblast | 183674 | 5421 | 0 | 47.8388 | 35.1396 | 2022-01-15 04:21:07 | Zaporizhia Oblast, Ukraine | |||
106971 | 106971 | 2021-08-15 | Ukraine | Zaporizhia Oblast | 105894 | 2465 | 0 | 47.8388 | 35.1396 | 2021-08-16 04:21:31 | Zaporizhia Oblast, Ukraine | |||
118403 | 118403 | 2022-09-06 | Ukraine | Zaporizhia Oblast | 215070 | 5866 | 0 | 47.8388 | 35.1396 | 2022-09-07 04:20:59 | Zaporizhia Oblast, Ukraine | |||
130382 | 130382 | 2022-01-09 | Ukraine | Zaporizhia Oblast | 182957 | 5355 | 0 | 47.8388 | 35.1396 | 2022-01-10 04:22:07 | Zaporizhia Oblast, Ukraine | |||
134404 | 134404 | 2022-10-04 | Ukraine | Zaporizhia Oblast | 215070 | 5866 | 0 | 47.8388 | 35.1396 | 2022-10-05 04:23:06 | Zaporizhia Oblast, Ukraine | |||
141620 | 141620 | 2021-12-04 | Ukraine | Zaporizhia Oblast | 173750 | 4583 | 0 | 47.8388 | 35.1396 | 2021-12-05 04:22:25 | Zaporizhia Oblast, Ukraine | |||
145638 | 145638 | 2022-07-09 | Ukraine | Zaporizhia Oblast | 215070 | 5866 | 0 | 47.8388 | 35.1396 | 2022-03-01 23:21:04 | Zaporizhia Oblast, Ukraine | |||
153633 | 153633 | 2021-11-29 | Ukraine | Zaporizhia Oblast | 170514 | 4335 | 0 | 47.8388 | 35.1396 | 2021-11-30 04:22:53 | Zaporizhia Oblast, Ukraine | |||
161662 | 161662 | 2022-03-29 | Ukraine | Zaporizhia Oblast | 215070 | 5866 | 0 | 47.8388 | 35.1396 | 2022-03-01 23:21:04 | Zaporizhia Oblast, Ukraine | |||
165677 | 165677 | 2021-11-19 | Ukraine | Zaporizhia Oblast | 163110 | 4003 | 0 | 47.8388 | 35.1396 | 2021-11-20 04:22:17 | Zaporizhia Oblast, Ukraine | |||
169695 | 169695 | 2022-06-21 | Ukraine | Zaporizhia Oblast | 215070 | 5866 | 0 | 47.8388 | 35.1396 | 2022-03-01 23:21:04 | Zaporizhia Oblast, Ukraine | |||
181671 | 181671 | 2021-09-02 | Ukraine | Zaporizhia Oblast | 106994 | 2484 | 0 | 47.8388 | 35.1396 | 2021-09-03 04:21:20 | Zaporizhia Oblast, Ukraine | |||
189720 | 189720 | 2022-02-13 | Ukraine | Zaporizhia Oblast | 202344 | 5712 | 0 | 47.8388 | 35.1396 | 2022-02-14 04:20:51 | Zaporizhia Oblast, Ukraine | |||
201913 | 201913 | 2022-10-19 | Ukraine | Zaporizhia Oblast | 215070 | 5866 | 0 | 47.8388 | 35.1396 | 2022-10-20 04:22:59 | Zaporizhia Oblast, Ukraine | |||
221634 | 221634 | 2022-12-26 | Ukraine | Zaporizhia Oblast | 215070 | 5866 | 0 | 47.8388 | 35.1396 | 2022-12-27 04:21:07 | Zaporizhia Oblast, Ukraine | |||
225645 | 225645 | 2022-05-09 | Ukraine | Zaporizhia Oblast | 215070 | 5866 | 0 | 47.8388 | 35.1396 | 2022-03-01 23:21:04 | Zaporizhia Oblast, Ukraine | |||
232877 | 232877 | 2022-05-31 | Ukraine | Zaporizhia Oblast | 215070 | 5866 | 0 | 47.8388 | 35.1396 | 2022-03-01 23:21:04 | Zaporizhia Oblast, Ukraine | |||
236892 | 236892 | 2022-02-11 | Ukraine | Zaporizhia Oblast | 200281 | 5688 | 0 | 47.8388 | 35.1396 | 2022-02-12 04:21:06 | Zaporizhia Oblast, Ukraine | |||
248914 | 248914 | 2021-08-17 | Ukraine | Zaporizhia Oblast | 105968 | 2465 | 0 | 47.8388 | 35.1396 | 2021-08-18 04:21:35 | Zaporizhia Oblast, Ukraine | |||
252928 | 252928 | 2021-09-04 | Ukraine | Zaporizhia Oblast | 107190 | 2496 | 0 | 47.8388 | 35.1396 | 2021-09-05 04:21:33 | Zaporizhia Oblast, Ukraine | |||
256965 | 256965 | 2022-09-08 | Ukraine | Zaporizhia Oblast | 215070 | 5866 | 0 | 47.8388 | 35.1396 | 2022-09-09 04:21:11 | Zaporizhia Oblast, Ukraine | |||
260984 | 260984 | 2022-12-10 | Ukraine | Zaporizhia Oblast | 215070 | 5866 | 0 | 47.8388 | 35.1396 | 2022-12-11 04:20:50 | Zaporizhia Oblast, Ukraine | |||
265182 | 265182 | 2022-03-15 | Ukraine | Zaporizhia Oblast | 215070 | 5866 | 0 | 47.8388 | 35.1396 | 2022-03-01 23:21:04 | Zaporizhia Oblast, Ukraine | |||
279832 | 279832 | 2021-11-03 | Ukraine | Zaporizhia Oblast | 146004 | 3450 | 0 | 47.8388 | 35.1396 | 2021-11-04 04:22:20 | Zaporizhia Oblast, Ukraine | |||
291644 | 291644 | 2021-10-31 | Ukraine | Zaporizhia Oblast | 142210 | 3332 | 0 | 47.8388 | 35.1396 | 2021-11-01 04:22:01 | Zaporizhia Oblast, Ukraine | |||
295667 | 295667 | 2022-11-15 | Ukraine | Zaporizhia Oblast | 215070 | 5866 | 0 | 47.8388 | 35.1396 | 2022-11-16 04:21:09 | Zaporizhia Oblast, Ukraine | |||
307518 | 307518 | 2022-04-16 | Ukraine | Zaporizhia Oblast | 215070 | 5866 | 0 | 47.8388 | 35.1396 | 2022-03-01 23:21:04 | Zaporizhia Oblast, Ukraine | |||
311539 | 311539 | 2022-12-13 | Ukraine | Zaporizhia Oblast | 215070 | 5866 | 0 | 47.8388 | 35.1396 | 2022-12-14 04:21:04 | Zaporizhia Oblast, Ukraine | |||
315555 | 315555 | 2022-11-13 | Ukraine | Zaporizhia Oblast | 215070 | 5866 | 0 | 47.8388 | 35.1396 | 2022-11-14 04:21:09 | Zaporizhia Oblast, Ukraine | |||
319566 | 319566 | 2022-02-12 | Ukraine | Zaporizhia Oblast | 201557 | 5701 | 0 | 47.8388 | 35.1396 | 2022-02-13 04:21:00 | Zaporizhia Oblast, Ukraine | |||
323587 | 323587 | 2022-10-30 | Ukraine | Zaporizhia Oblast | 215070 | 5866 | 0 | 47.8388 | 35.1396 | 2022-10-31 04:21:36 | Zaporizhia Oblast, Ukraine | |||
331561 | 331561 | 2022-12-27 | Ukraine | Zaporizhia Oblast | 215070 | 5866 | 0 | 47.8388 | 35.1396 | 2022-12-28 04:21:04 | Zaporizhia Oblast, Ukraine | |||
339586 | 339586 | 2022-03-18 | Ukraine | Zaporizhia Oblast | 215070 | 5866 | 0 | 47.8388 | 35.1396 | 2022-03-01 23:21:04 | Zaporizhia Oblast, Ukraine | |||
351951 | 351951 | 2022-12-14 | Ukraine | Zaporizhia Oblast | 215070 | 5866 | 0 | 47.8388 | 35.1396 | 2022-12-15 04:20:58 | Zaporizhia Oblast, Ukraine | |||
359976 | 359976 | 2022-03-11 | Ukraine | Zaporizhia Oblast | 215070 | 5866 | 0 | 47.8388 | 35.1396 | 2022-03-01 23:21:04 | Zaporizhia Oblast, Ukraine | |||
363992 | 363992 | 2022-05-07 | Ukraine | Zaporizhia Oblast | 215070 | 5866 | 0 | 47.8388 | 35.1396 | 2022-03-01 23:21:04 | Zaporizhia Oblast, Ukraine | |||
375851 | 375851 | 2022-09-13 | Ukraine | Zaporizhia Oblast | 215070 | 5866 | 0 | 47.8388 | 35.1396 | 2022-09-14 04:20:44 | Zaporizhia Oblast, Ukraine | |||
387878 | 387878 | 2022-09-23 | Ukraine | Zaporizhia Oblast | 215070 | 5866 | 0 | 47.8388 | 35.1396 | 2022-09-24 04:21:40 | Zaporizhia Oblast, Ukraine | |||
399919 | 399919 | 2022-10-07 | Ukraine | Zaporizhia Oblast | 215070 | 5866 | 0 | 47.8388 | 35.1396 | 2022-10-08 04:22:56 | Zaporizhia Oblast, Ukraine | |||
407943 | 407943 | 2021-12-07 | Ukraine | Zaporizhia Oblast | 174720 | 4683 | 0 | 47.8388 | 35.1396 | 2021-12-08 04:22:46 | Zaporizhia Oblast, Ukraine | |||
422990 | 422990 | 2022-09-18 | Ukraine | Zaporizhia Oblast | 215070 | 5866 | 0 | 47.8388 | 35.1396 | 2022-09-19 04:21:49 | Zaporizhia Oblast, Ukraine | |||
426999 | 426999 | 2021-10-10 | Ukraine | Zaporizhia Oblast | 120099 | 2751 | 0 | 47.8388 | 35.1396 | 2021-10-11 04:21:31 | Zaporizhia Oblast, Ukraine | |||
435012 | 435012 | 2022-11-03 | Ukraine | Zaporizhia Oblast | 215070 | 5866 | 0 | 47.8388 | 35.1396 | 2022-11-04 04:22:11 | Zaporizhia Oblast, Ukraine | |||
447003 | 447003 | 2021-10-20 | Ukraine | Zaporizhia Oblast | 128844 | 2961 | 0 | 47.8388 | 35.1396 | 2021-10-21 04:21:18 | Zaporizhia Oblast, Ukraine | |||
451020 | 451020 | 2021-11-17 | Ukraine | Zaporizhia Oblast | 160683 | 3914 | 0 | 47.8388 | 35.1396 | 2021-11-18 04:21:33 | Zaporizhia Oblast, Ukraine | |||
455042 | 455042 | 2022-12-21 | Ukraine | Zaporizhia Oblast | 215070 | 5866 | 0 | 47.8388 | 35.1396 | 2022-12-22 04:20:56 | Zaporizhia Oblast, Ukraine | |||
463029 | 463029 | 2022-02-02 | Ukraine | Zaporizhia Oblast | 190399 | 5532 | 0 | 47.8388 | 35.1396 | 2022-02-03 04:21:21 | Zaporizhia Oblast, Ukraine | |||
467046 | 467046 | 2022-05-02 | Ukraine | Zaporizhia Oblast | 215070 | 5866 | 0 | 47.8388 | 35.1396 | 2022-03-01 23:21:04 | Zaporizhia Oblast, Ukraine | |||
471060 | 471060 | 2021-10-07 | Ukraine | Zaporizhia Oblast | 117682 | 2720 | 0 | 47.8388 | 35.1396 | 2021-10-08 04:21:25 | Zaporizhia Oblast, Ukraine | |||
479093 | 479093 | 2022-06-26 | Ukraine | Zaporizhia Oblast | 215070 | 5866 | 0 | 47.8388 | 35.1396 | 2022-03-01 23:21:04 | Zaporizhia Oblast, Ukraine | |||
483245 | 483245 | 2022-11-08 | Ukraine | Zaporizhia Oblast | 215070 | 5866 | 0 | 47.8388 | 35.1396 | 2022-11-09 04:21:22 | Zaporizhia Oblast, Ukraine | |||
491275 | 491275 | 2022-11-25 | Ukraine | Zaporizhia Oblast | 215070 | 5866 | 0 | 47.8388 | 35.1396 | 2022-11-26 04:21:11 | Zaporizhia Oblast, Ukraine | |||
495284 | 495284 | 2021-10-14 | Ukraine | Zaporizhia Oblast | 123536 | 2852 | 0 | 47.8388 | 35.1396 | 2021-10-15 04:21:26 | Zaporizhia Oblast, Ukraine | |||
499301 | 499301 | 2021-11-06 | Ukraine | Zaporizhia Oblast | 150045 | 3514 | 0 | 47.8388 | 35.1396 | 2021-11-07 04:21:53 | Zaporizhia Oblast, Ukraine | |||
503318 | 503318 | 2022-04-02 | Ukraine | Zaporizhia Oblast | 215070 | 5866 | 0 | 47.8388 | 35.1396 | 2022-03-01 23:21:04 | Zaporizhia Oblast, Ukraine | |||
507339 | 507339 | 2022-12-17 | Ukraine | Zaporizhia Oblast | 215070 | 5866 | 0 | 47.8388 | 35.1396 | 2022-12-18 04:21:03 | Zaporizhia Oblast, Ukraine | |||
511329 | 511329 | 2021-08-14 | Ukraine | Zaporizhia Oblast | 105874 | 2465 | 0 | 47.8388 | 35.1396 | 2021-08-15 04:21:41 | Zaporizhia Oblast, Ukraine | |||
515343 | 515343 | 2021-08-19 | Ukraine | Zaporizhia Oblast | 106099 | 2469 | 0 | 47.8388 | 35.1396 | 2021-08-20 04:21:33 | Zaporizhia Oblast, Ukraine | |||
519383 | 519383 | 2022-10-15 | Ukraine | Zaporizhia Oblast | 215070 | 5866 | 0 | 47.8388 | 35.1396 | 2022-10-16 04:22:39 | Zaporizhia Oblast, Ukraine | |||
538384 | 538384 | 2021-10-27 | Ukraine | Zaporizhia Oblast | 137454 | 3224 | 0 | 47.8388 | 35.1396 | 2021-10-28 04:22:08 | Zaporizhia Oblast, Ukraine | |||
542407 | 542407 | 2022-10-26 | Ukraine | Zaporizhia Oblast | 215070 | 5866 | 0 | 47.8388 | 35.1396 | 2022-10-27 04:22:01 | Zaporizhia Oblast, Ukraine | |||
546423 | 546423 | 2022-12-15 | Ukraine | Zaporizhia Oblast | 215070 | 5866 | 0 | 47.8388 | 35.1396 | 2022-12-16 04:21:01 | Zaporizhia Oblast, Ukraine | |||
554423 | 554423 | 2021-12-08 | Ukraine | Zaporizhia Oblast | 175250 | 4723 | 0 | 47.8388 | 35.1396 | 2021-12-09 04:22:49 | Zaporizhia Oblast, Ukraine | |||
558439 | 558439 | 2022-01-16 | Ukraine | Zaporizhia Oblast | 183857 | 5428 | 0 | 47.8388 | 35.1396 | 2022-01-17 04:21:08 | Zaporizhia Oblast, Ukraine | |||
562457 | 562457 | 2022-06-16 | Ukraine | Zaporizhia Oblast | 215070 | 5866 | 0 | 47.8388 | 35.1396 | 2022-03-01 23:21:04 | Zaporizhia Oblast, Ukraine | |||
570752 | 570752 | 2021-10-29 | Ukraine | Zaporizhia Oblast | 140201 | 3302 | 0 | 47.8388 | 35.1396 | 2021-10-30 04:22:03 | Zaporizhia Oblast, Ukraine | |||
578482 | 578482 | 2022-02-25 | Ukraine | Zaporizhia Oblast | 215070 | 5866 | 0 | 47.8388 | 35.1396 | 2022-02-26 04:21:12 | Zaporizhia Oblast, Ukraine | |||
593273 | 593273 | 2021-08-08 | Ukraine | Zaporizhia Oblast | 105548 | 2458 | 0 | 47.8388 | 35.1396 | 2021-08-09 04:21:24 | Zaporizhia Oblast, Ukraine | |||
597309 | 597309 | 2022-07-01 | Ukraine | Zaporizhia Oblast | 215070 | 5866 | 0 | 47.8388 | 35.1396 | 2022-03-01 23:21:04 | Zaporizhia Oblast, Ukraine | |||
601322 | 601322 | 2021-10-19 | Ukraine | Zaporizhia Oblast | 127619 | 2943 | 0 | 47.8388 | 35.1396 | 2021-10-20 04:21:00 | Zaporizhia Oblast, Ukraine | |||
605337 | 605337 | 2021-09-23 | Ukraine | Zaporizhia Oblast | 110422 | 2579 | 0 | 47.8388 | 35.1396 | 2021-09-24 04:21:44 | Zaporizhia Oblast, Ukraine | |||
621517 | 621517 | 2022-11-05 | Ukraine | Zaporizhia Oblast | 215070 | 5866 | 0 | 47.8388 | 35.1396 | 2022-11-06 04:21:24 | Zaporizhia Oblast, Ukraine | |||
625529 | 625529 | 2022-05-22 | Ukraine | Zaporizhia Oblast | 215070 | 5866 | 0 | 47.8388 | 35.1396 | 2022-03-01 23:21:04 | Zaporizhia Oblast, Ukraine | |||
633560 | 633560 | 2022-07-12 | Ukraine | Zaporizhia Oblast | 215070 | 5866 | 0 | 47.8388 | 35.1396 | 2022-03-01 23:21:04 | Zaporizhia Oblast, Ukraine | |||
637572 | 637572 | 2021-10-13 | Ukraine | Zaporizhia Oblast | 122549 | 2826 | 0 | 47.8388 | 35.1396 | 2021-10-14 04:21:29 | Zaporizhia Oblast, Ukraine | |||
645583 | 645583 | 2021-09-07 | Ukraine | Zaporizhia Oblast | 107460 | 2500 | 0 | 47.8388 | 35.1396 | 2021-09-08 04:21:31 | Zaporizhia Oblast, Ukraine | |||
653611 | 653611 | 2021-08-09 | Ukraine | Zaporizhia Oblast | 105548 | 2458 | 0 | 47.8388 | 35.1396 | 2021-08-10 04:21:27 | Zaporizhia Oblast, Ukraine | |||
657644 | 657644 | 2021-10-22 | Ukraine | Zaporizhia Oblast | 131590 | 3003 | 0 | 47.8388 | 35.1396 | 2021-10-23 04:21:32 | Zaporizhia Oblast, Ukraine | |||
661964 | 661964 | 2022-05-13 | Ukraine | Zaporizhia Oblast | 215070 | 5866 | 0 | 47.8388 | 35.1396 | 2022-03-01 23:21:04 | Zaporizhia Oblast, Ukraine | |||
673951 | 673951 | 2022-07-21 | Ukraine | Zaporizhia Oblast | 215070 | 5866 | 0 | 47.8388 | 35.1396 | 2022-07-22 04:21:15 | Zaporizhia Oblast, Ukraine | |||
677967 | 677967 | 2022-07-30 | Ukraine | Zaporizhia Oblast | 215070 | 5866 | 0 | 47.8388 | 35.1396 | 2022-07-31 04:21:02 | Zaporizhia Oblast, Ukraine | |||
685989 | 685989 | 2021-10-24 | Ukraine | Zaporizhia Oblast | 133786 | 3074 | 0 | 47.8388 | 35.1396 | 2021-10-25 04:22:31 | Zaporizhia Oblast, Ukraine | |||
690006 | 690006 | 2021-11-13 | Ukraine | Zaporizhia Oblast | 156746 | 3771 | 0 | 47.8388 | 35.1396 | 2021-11-14 04:21:31 | Zaporizhia Oblast, Ukraine | |||
694028 | 694028 | 2022-12-23 | Ukraine | Zaporizhia Oblast | 215070 | 5866 | 0 | 47.8388 | 35.1396 | 2022-12-24 04:21:02 | Zaporizhia Oblast, Ukraine | |||
698039 | 698039 | 2022-03-17 | Ukraine | Zaporizhia Oblast | 215070 | 5866 | 0 | 47.8388 | 35.1396 | 2022-03-01 23:21:04 | Zaporizhia Oblast, Ukraine | |||
702054 | 702054 | 2021-11-04 | Ukraine | Zaporizhia Oblast | 147354 | 3478 | 0 | 47.8388 | 35.1396 | 2021-11-05 04:21:54 | Zaporizhia Oblast, Ukraine | |||
710082 | 710082 | 2021-09-29 | Ukraine | Zaporizhia Oblast | 112878 | 2626 | 0 | 47.8388 | 35.1396 | 2021-09-30 04:21:20 | Zaporizhia Oblast, Ukraine | |||
714105 | 714105 | 2022-11-01 | Ukraine | Zaporizhia Oblast | 215070 | 5866 | 0 | 47.8388 | 35.1396 | 2022-11-02 04:22:09 | Zaporizhia Oblast, Ukraine |
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]);