johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
942 rows where country_or_region = "Ukraine" and province_or_state = "Kiev Oblast" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2705133 | 2705133 | 2020-11-20 | Ukraine | Kiev Oblast | 28427 | 615 | 10868 | 16944 | 50.053 | 30.7667 | 2020-11-21 05:25:51 | Kiev Oblast, Ukraine | ||
825193 | 825193 | 2020-11-19 | Ukraine | Kiev Oblast | 27347 | 600 | 10623 | 16124 | 50.053 | 30.7667 | 2020-11-20 05:26:28 | Kiev Oblast, Ukraine | ||
126327 | 126327 | 2020-11-18 | Ukraine | Kiev Oblast | 26561 | 586 | 10346 | 15629 | 50.053 | 30.7667 | 2020-11-19 05:25:23 | Kiev Oblast, Ukraine | ||
3342215 | 3342215 | 2020-11-17 | Ukraine | Kiev Oblast | 25787 | 571 | 10190 | 15026 | 50.053 | 30.7667 | 2020-11-18 05:40:31 | Kiev Oblast, Ukraine | ||
3173260 | 3173260 | 2020-11-16 | Ukraine | Kiev Oblast | 25141 | 560 | 10055 | 14526 | 50.053 | 30.7667 | 2020-11-17 05:25:54 | Kiev Oblast, Ukraine | ||
2883828 | 2883828 | 2020-11-15 | Ukraine | Kiev Oblast | 24493 | 560 | 9986 | 13947 | 50.053 | 30.7667 | 2020-11-16 05:25:57 | Kiev Oblast, Ukraine | ||
2918806 | 2918806 | 2020-11-14 | Ukraine | Kiev Oblast | 23801 | 556 | 9888 | 13357 | 50.053 | 30.7667 | 2020-11-15 05:26:53 | Kiev Oblast, Ukraine | ||
2788628 | 2788628 | 2020-11-13 | Ukraine | Kiev Oblast | 23103 | 535 | 9633 | 12935 | 50.053 | 30.7667 | 2020-11-14 05:25:37 | Kiev Oblast, Ukraine | ||
868393 | 868393 | 2020-11-12 | Ukraine | Kiev Oblast | 22431 | 524 | 9456 | 12451 | 50.053 | 30.7667 | 2020-11-13 05:25:30 | Kiev Oblast, Ukraine | ||
3444437 | 3444437 | 2020-11-11 | Ukraine | Kiev Oblast | 21731 | 510 | 9337 | 11884 | 50.053 | 30.7667 | 2020-11-12 05:25:55 | Kiev Oblast, Ukraine | ||
275777 | 275777 | 2020-11-10 | Ukraine | Kiev Oblast | 21038 | 494 | 9230 | 11314 | 50.053 | 30.7667 | 2020-11-11 05:25:30 | Kiev Oblast, Ukraine | ||
1992254 | 1992254 | 2020-11-09 | Ukraine | Kiev Oblast | 20410 | 470 | 9119 | 10821 | 50.053 | 30.7667 | 2020-11-10 05:40:07 | Kiev Oblast, Ukraine | ||
1732106 | 1732106 | 2020-11-08 | Ukraine | Kiev Oblast | 19820 | 464 | 9072 | 10284 | 50.053 | 30.7667 | 2020-11-09 05:25:45 | Kiev Oblast, Ukraine | ||
1547566 | 1547566 | 2020-11-07 | Ukraine | Kiev Oblast | 19274 | 461 | 9051 | 9762 | 50.053 | 30.7667 | 2020-11-08 05:24:56 | Kiev Oblast, Ukraine | ||
379804 | 379804 | 2020-11-06 | Ukraine | Kiev Oblast | 18763 | 454 | 8911 | 9398 | 50.053 | 30.7667 | 2020-11-07 05:24:52 | Kiev Oblast, Ukraine | ||
895742 | 895742 | 2020-11-05 | Ukraine | Kiev Oblast | 18329 | 444 | 8608 | 9277 | 50.053 | 30.7667 | 2020-11-06 05:24:55 | Kiev Oblast, Ukraine | ||
2922804 | 2922804 | 2020-11-04 | Ukraine | Kiev Oblast | 17918 | 425 | 8382 | 9111 | 50.053 | 30.7667 | 2020-11-05 06:05:03 | Kiev Oblast, Ukraine | ||
2501640 | 2501640 | 2020-11-03 | Ukraine | Kiev Oblast | 17535 | 411 | 8153 | 8971 | 50.053 | 30.7667 | 2020-11-04 05:25:09 | Kiev Oblast, Ukraine | ||
3307815 | 3307815 | 2020-11-02 | Ukraine | Kiev Oblast | 17175 | 406 | 8100 | 8669 | 50.053 | 30.7667 | 2020-11-03 06:00:16 | Kiev Oblast, Ukraine | ||
3413064 | 3413064 | 2020-11-01 | Ukraine | Kiev Oblast | 16816 | 405 | 8037 | 8374 | 50.053 | 30.7667 | 2020-11-02 05:25:04 | Kiev Oblast, Ukraine | ||
2083553 | 2083553 | 2020-10-31 | Ukraine | Kiev Oblast | 16464 | 396 | 7933 | 8135 | 50.053 | 30.7667 | 2020-11-01 04:36:19 | Kiev Oblast, Ukraine | ||
2247006 | 2247006 | 2020-10-30 | Ukraine | Kiev Oblast | 16119 | 377 | 7872 | 7870 | 50.053 | 30.7667 | 2020-10-31 04:24:44 | Kiev Oblast, Ukraine | ||
213861 | 213861 | 2020-10-29 | Ukraine | Kiev Oblast | 15780 | 367 | 7816 | 7597 | 50.053 | 30.7667 | 2020-10-30 04:24:49 | Kiev Oblast, Ukraine | ||
757923 | 757923 | 2020-10-28 | Ukraine | Kiev Oblast | 15465 | 357 | 7762 | 7346 | 50.053 | 30.7667 | 2020-10-29 04:24:49 | Kiev Oblast, Ukraine | ||
1456207 | 1456207 | 2020-10-27 | Ukraine | Kiev Oblast | 15156 | 343 | 7727 | 7086 | 50.053 | 30.7667 | 2020-10-28 04:24:39 | Kiev Oblast, Ukraine | ||
3483931 | 3483931 | 2020-10-26 | Ukraine | Kiev Oblast | 14845 | 335 | 7683 | 6827 | 50.053 | 30.7667 | 2020-10-27 04:24:45 | Kiev Oblast, Ukraine | ||
11952 | 11952 | 2020-10-25 | Ukraine | Kiev Oblast | 14544 | 335 | 7683 | 6526 | 50.053 | 30.7667 | 2020-10-26 04:25:02 | Kiev Oblast, Ukraine | ||
3655189 | 3655189 | 2020-10-24 | Ukraine | Kiev Oblast | 14247 | 329 | 7563 | 6355 | 50.053 | 30.7667 | 2020-10-25 04:24:36 | Kiev Oblast, Ukraine | ||
1057444 | 1057444 | 2020-10-23 | Ukraine | Kiev Oblast | 13958 | 319 | 7528 | 6111 | 50.053 | 30.7667 | 2020-10-24 04:24:46 | Kiev Oblast, Ukraine | ||
1181114 | 1181114 | 2020-10-22 | Ukraine | Kiev Oblast | 13688 | 303 | 7498 | 5887 | 50.053 | 30.7667 | 2020-10-23 04:24:46 | Kiev Oblast, Ukraine | ||
2195219 | 2195219 | 2020-10-21 | Ukraine | Kiev Oblast | 13419 | 295 | 7418 | 5706 | 50.053 | 30.7667 | 2020-10-22 04:24:27 | Kiev Oblast, Ukraine | ||
3994230 | 3994230 | 2020-10-20 | Ukraine | Kiev Oblast | 13166 | 290 | 7358 | 5518 | 50.053 | 30.7667 | 2020-10-21 04:24:14 | Kiev Oblast, Ukraine | ||
1798250 | 1798250 | 2020-10-19 | Ukraine | Kiev Oblast | 12924 | 286 | 7313 | 5325 | 50.053 | 30.7667 | 2020-10-20 04:24:22 | Kiev Oblast, Ukraine | ||
765933 | 765933 | 2020-10-18 | Ukraine | Kiev Oblast | 12684 | 283 | 7196 | 5205 | 50.053 | 30.7667 | 2020-10-19 04:24:16 | Kiev Oblast, Ukraine | ||
1029971 | 1029971 | 2020-10-17 | Ukraine | Kiev Oblast | 12439 | 271 | 7104 | 5064 | 50.053 | 30.7667 | 2020-10-18 04:24:25 | Kiev Oblast, Ukraine | ||
2860466 | 2860466 | 2020-10-16 | Ukraine | Kiev Oblast | 12207 | 261 | 6995 | 4951 | 50.053 | 30.7667 | 2020-10-17 04:24:12 | Kiev Oblast, Ukraine | ||
789995 | 789995 | 2020-10-15 | Ukraine | Kiev Oblast | 11978 | 257 | 6915 | 4806 | 50.053 | 30.7667 | 2020-10-16 04:24:01 | Kiev Oblast, Ukraine | ||
82706 | 82706 | 2020-10-14 | Ukraine | Kiev Oblast | 11751 | 252 | 6867 | 4632 | 50.053 | 30.7667 | 2020-10-15 04:24:28 | Kiev Oblast, Ukraine | ||
3785521 | 3785521 | 2020-10-13 | Ukraine | Kiev Oblast | 11525 | 244 | 6796 | 4485 | 50.053 | 30.7667 | 2020-10-14 04:24:05 | Kiev Oblast, Ukraine | ||
2295061 | 2295061 | 2020-10-12 | Ukraine | Kiev Oblast | 11309 | 237 | 6694 | 4378 | 50.053 | 30.7667 | 2020-10-13 04:24:02 | Kiev Oblast, Ukraine | ||
3789513 | 3789513 | 2020-10-11 | Ukraine | Kiev Oblast | 11096 | 233 | 6598 | 4265 | 50.053 | 30.7667 | 2020-10-12 04:23:45 | Kiev Oblast, Ukraine | ||
2605651 | 2605651 | 2020-10-10 | Ukraine | Kiev Oblast | 10892 | 229 | 6465 | 4198 | 50.053 | 30.7667 | 2020-10-11 04:23:46 | Kiev Oblast, Ukraine | ||
821184 | 821184 | 2020-10-09 | Ukraine | Kiev Oblast | 10689 | 221 | 6294 | 4174 | 50.053 | 30.7667 | 2020-10-10 04:23:57 | Kiev Oblast, Ukraine | ||
2693299 | 2693299 | 2020-10-08 | Ukraine | Kiev Oblast | 10490 | 213 | 6220 | 4057 | 50.053 | 30.7667 | 2020-10-09 04:23:59 | Kiev Oblast, Ukraine | ||
1045441 | 1045441 | 2020-10-07 | Ukraine | Kiev Oblast | 10291 | 209 | 6076 | 4006 | 50.053 | 30.7667 | 2020-10-08 04:23:56 | Kiev Oblast, Ukraine | ||
3121102 | 3121102 | 2020-10-06 | Ukraine | Kiev Oblast | 10099 | 202 | 6016 | 3881 | 50.053 | 30.7667 | 2020-10-07 04:23:40 | Kiev Oblast, Ukraine | ||
3805514 | 3805514 | 2020-10-05 | Ukraine | Kiev Oblast | 9918 | 200 | 5997 | 3721 | 50.053 | 30.7667 | 2020-10-06 04:23:33 | Kiev Oblast, Ukraine | ||
1826404 | 1826404 | 2020-10-04 | Ukraine | Kiev Oblast | 9752 | 200 | 5899 | 3653 | 50.053 | 30.7667 | 2020-10-05 04:23:33 | Kiev Oblast, Ukraine | ||
2517788 | 2517788 | 2020-10-03 | Ukraine | Kiev Oblast | 9591 | 193 | 5819 | 3579 | 50.053 | 30.7667 | 2020-10-04 04:23:44 | Kiev Oblast, Ukraine | ||
3393006 | 3393006 | 2020-10-02 | Ukraine | Kiev Oblast | 9428 | 186 | 5639 | 3603 | 50.053 | 30.7667 | 2020-10-03 04:23:40 | Kiev Oblast, Ukraine | ||
2383247 | 2383247 | 2020-10-01 | Ukraine | Kiev Oblast | 9279 | 178 | 5639 | 3462 | 50.053 | 30.7667 | 2020-10-02 04:23:51 | Kiev Oblast, Ukraine | ||
1049433 | 1049433 | 2020-09-30 | Ukraine | Kiev Oblast | 9139 | 174 | 5569 | 3396 | 50.053 | 30.7667 | 2020-10-01 04:23:42 | Kiev Oblast, Ukraine | ||
970514 | 970514 | 2020-09-29 | Ukraine | Kiev Oblast | 8996 | 173 | 5422 | 3401 | 50.053 | 30.7667 | 2020-09-30 04:23:33 | Kiev Oblast, Ukraine | ||
1519011 | 1519011 | 2020-09-28 | Ukraine | Kiev Oblast | 8854 | 173 | 5365 | 3316 | 50.053 | 30.7667 | 2020-09-29 04:23:42 | Kiev Oblast, Ukraine | ||
2585599 | 2585599 | 2020-09-27 | Ukraine | Kiev Oblast | 8714 | 172 | 5346 | 3196 | 50.053 | 30.7667 | 2020-09-28 04:23:00 | Kiev Oblast, Ukraine | ||
2617651 | 2617651 | 2020-09-26 | Ukraine | Kiev Oblast | 8571 | 171 | 5233 | 3167 | 50.053 | 30.7667 | 2020-09-27 04:23:00 | Kiev Oblast, Ukraine | ||
2816366 | 2816366 | 2020-09-25 | Ukraine | Kiev Oblast | 8430 | 170 | 5175 | 3085 | 50.053 | 30.7667 | 2020-09-26 04:23:00 | Kiev Oblast, Ukraine | ||
2609643 | 2609643 | 2020-09-24 | Ukraine | Kiev Oblast | 8286 | 165 | 5108 | 3013 | 50.053 | 30.7667 | 2020-09-25 04:23:00 | Kiev Oblast, Ukraine | ||
2657386 | 2657386 | 2020-09-23 | Ukraine | Kiev Oblast | 8148 | 165 | 5053 | 2930 | 50.053 | 30.7667 | 2020-09-24 04:23:00 | Kiev Oblast, Ukraine | ||
3319835 | 3319835 | 2020-09-22 | Ukraine | Kiev Oblast | 8020 | 161 | 4999 | 2860 | 50.053 | 30.7667 | 2020-09-23 04:23:00 | Kiev Oblast, Ukraine | ||
2840434 | 2840434 | 2020-09-21 | Ukraine | Kiev Oblast | 7880 | 159 | 4969 | 2752 | 50.053 | 30.7667 | 2020-09-22 04:23:00 | Kiev Oblast, Ukraine | ||
3097037 | 3097037 | 2020-09-20 | Ukraine | Kiev Oblast | 7744 | 159 | 4946 | 2639 | 50.053 | 30.7667 | 2020-09-21 04:23:00 | Kiev Oblast, Ukraine | ||
2458387 | 2458387 | 2020-09-19 | Ukraine | Kiev Oblast | 7611 | 156 | 4929 | 2526 | 50.053 | 30.7667 | 2020-09-20 04:22:00 | Kiev Oblast, Ukraine | ||
2852456 | 2852456 | 2020-09-18 | Ukraine | Kiev Oblast | 7476 | 150 | 4889 | 2437 | 50.053 | 30.7667 | 2020-09-19 04:22:00 | Kiev Oblast, Ukraine | ||
1125205 | 1125205 | 2020-09-17 | Ukraine | Kiev Oblast | 7342 | 146 | 4851 | 2345 | 50.053 | 30.7667 | 2020-09-18 05:05:00 | Kiev Oblast, Ukraine | ||
669894 | 669894 | 2020-09-16 | Ukraine | Kiev Oblast | 7207 | 142 | 4805 | 2260 | 50.053 | 30.7667 | 2020-09-17 04:22:00 | Kiev Oblast, Ukraine | ||
2732619 | 2732619 | 2020-09-15 | Ukraine | Kiev Oblast | 7079 | 138 | 4722 | 2219 | 50.053 | 30.7667 | 2020-09-16 04:22:53 | Kiev Oblast, Ukraine | ||
347891 | 347891 | 2020-09-14 | Ukraine | Kiev Oblast | 6961 | 136 | 4672 | 2153 | 50.053 | 30.7667 | 2020-09-15 03:22:50 | Kiev Oblast, Ukraine | ||
2872330 | 2872330 | 2020-09-13 | Ukraine | Kiev Oblast | 6849 | 135 | 4576 | 2138 | 50.053 | 30.7667 | 2020-09-14 04:26:00 | Kiev Oblast, Ukraine | ||
550369 | 550369 | 2020-09-12 | Ukraine | Kiev Oblast | 6750 | 134 | 4510 | 2106 | 50.053 | 30.7667 | 2020-09-13 04:30:52 | Kiev Oblast, Ukraine | ||
1448198 | 1448198 | 2020-09-11 | Ukraine | Kiev Oblast | 6648 | 128 | 4430 | 2090 | 50.053 | 30.7667 | 2020-09-12 04:25:05 | Kiev Oblast, Ukraine | ||
1176799 | 1176799 | 2020-09-10 | Ukraine | Kiev Oblast | 6554 | 124 | 4389 | 2041 | 50.053 | 30.7667 | 2020-09-11 04:46:23 | Kiev Oblast, Ukraine | ||
2175164 | 2175164 | 2020-09-09 | Ukraine | Kiev Oblast | 6459 | 122 | 4313 | 2024 | 50.053 | 30.7667 | 2020-09-10 04:29:01 | Kiev Oblast, Ukraine | ||
1247373 | 1247373 | 2020-09-08 | Ukraine | Kiev Oblast | 6370 | 117 | 4235 | 2018 | 50.053 | 30.7667 | 2020-09-09 04:28:48 | Kiev Oblast, Ukraine | ||
430952 | 430952 | 2020-09-07 | Ukraine | Kiev Oblast | 6278 | 116 | 4174 | 1988 | 50.053 | 30.7667 | 2020-09-08 04:28:25 | Kiev Oblast, Ukraine | ||
3165237 | 3165237 | 2020-09-06 | Ukraine | Kiev Oblast | 6192 | 116 | 4103 | 1973 | 50.053 | 30.7667 | 2020-09-07 04:28:30 | Kiev Oblast, Ukraine | ||
817192 | 817192 | 2020-09-05 | Ukraine | Kiev Oblast | 6105 | 114 | 4019 | 1972 | 50.053 | 30.7667 | 2020-09-06 04:28:33 | Kiev Oblast, Ukraine | ||
2665392 | 2665392 | 2020-09-04 | Ukraine | Kiev Oblast | 6017 | 109 | 3938 | 1970 | 50.053 | 30.7667 | 2020-09-05 04:28:19 | Kiev Oblast, Ukraine | ||
1357932 | 1357932 | 2020-09-03 | Ukraine | Kiev Oblast | 5931 | 102 | 3825 | 2004 | 50.053 | 30.7667 | 2020-09-04 04:28:26 | Kiev Oblast, Ukraine | ||
1109169 | 1109169 | 2020-09-02 | Ukraine | Kiev Oblast | 5842 | 102 | 3726 | 2014 | 50.053 | 30.7667 | 2020-09-03 04:28:22 | Kiev Oblast, Ukraine | ||
2063498 | 2063498 | 2020-09-01 | Ukraine | Kiev Oblast | 5755 | 97 | 3652 | 2006 | 50.053 | 30.7667 | 2020-09-02 04:28:25 | Kiev Oblast, Ukraine | ||
197683 | 197683 | 2020-08-31 | Ukraine | Kiev Oblast | 5669 | 96 | 3613 | 1960 | 50.053 | 30.7667 | 2020-09-01 04:28:31 | Kiev Oblast, Ukraine | ||
3935638 | 3935638 | 2020-08-30 | Ukraine | Kiev Oblast | 5580 | 96 | 3612 | 1872 | 50.053 | 30.7667 | 2020-08-31 04:28:27 | Kiev Oblast, Ukraine | ||
613300 | 613300 | 2020-08-29 | Ukraine | Kiev Oblast | 5489 | 95 | 3612 | 1782 | 50.053 | 30.7667 | 2020-08-30 04:28:22 | Kiev Oblast, Ukraine | ||
1526795 | 1526795 | 2020-08-28 | Ukraine | Kiev Oblast | 5397 | 93 | 3543 | 1761 | 50.053 | 30.7667 | 2020-08-29 04:28:19 | Kiev Oblast, Ukraine | ||
2513796 | 2513796 | 2020-08-27 | Ukraine | Kiev Oblast | 5305 | 91 | 3507 | 1707 | 50.053 | 30.7667 | 2020-08-28 04:28:11 | Kiev Oblast, Ukraine | ||
2000256 | 2000256 | 2020-08-26 | Ukraine | Kiev Oblast | 5211 | 85 | 3441 | 1685 | 50.053 | 30.7667 | 2020-08-27 04:28:15 | Kiev Oblast, Ukraine | ||
3566180 | 3566180 | 2020-08-25 | Ukraine | Kiev Oblast | 5115 | 84 | 3384 | 1647 | 50.053 | 30.7667 | 2020-08-26 04:28:11 | Kiev Oblast, Ukraine | ||
2994884 | 2994884 | 2020-08-24 | Ukraine | Kiev Oblast | 5025 | 84 | 3321 | 1620 | 50.053 | 30.7667 | 2020-08-25 04:28:02 | Kiev Oblast, Ukraine | ||
2219279 | 2219279 | 2020-08-23 | Ukraine | Kiev Oblast | 4952 | 84 | 3321 | 1547 | 50.053 | 30.7667 | 2020-08-24 04:27:56 | Kiev Oblast, Ukraine | ||
2303061 | 2303061 | 2020-08-22 | Ukraine | Kiev Oblast | 4881 | 84 | 3303 | 1494 | 50.053 | 30.7667 | 2020-08-23 04:27:48 | Kiev Oblast, Ukraine | ||
1483167 | 1483167 | 2020-08-21 | Ukraine | Kiev Oblast | 4805 | 83 | 3273 | 1449 | 50.053 | 30.7667 | 2020-08-22 04:27:49 | Kiev Oblast, Ukraine | ||
3487916 | 3487916 | 2020-08-20 | Ukraine | Kiev Oblast | 4727 | 83 | 3262 | 1382 | 50.053 | 30.7667 | 2020-08-21 04:27:41 | Kiev Oblast, Ukraine | ||
209865 | 209865 | 2020-08-19 | Ukraine | Kiev Oblast | 4685 | 81 | 3213 | 1391 | 50.053 | 30.7667 | 2020-08-20 04:27:43 | Kiev Oblast, Ukraine | ||
3181617 | 3181617 | 2020-08-18 | Ukraine | Kiev Oblast | 4620 | 80 | 3158 | 1382 | 50.053 | 30.7667 | 2020-08-19 04:27:00 | Kiev Oblast, Ukraine | ||
841221 | 841221 | 2020-08-17 | Ukraine | Kiev Oblast | 4554 | 79 | 3111 | 1364 | 50.053 | 30.7667 | 2020-08-18 04:27:56 | Kiev Oblast, Ukraine | ||
1559577 | 1559577 | 2020-08-16 | Ukraine | Kiev Oblast | 4530 | 79 | 3111 | 1340 | 50.053 | 30.7667 | 2020-08-17 04:27:20 | Kiev Oblast, Ukraine | ||
149579 | 149579 | 2020-08-15 | Ukraine | Kiev Oblast | 4495 | 79 | 3110 | 1306 | 50.053 | 30.7667 | 2020-08-16 04:27:42 | Kiev Oblast, Ukraine | ||
1615854 | 1615854 | 2020-08-14 | Ukraine | Kiev Oblast | 4429 | 76 | 3046 | 1307 | 50.053 | 30.7667 | 2020-08-15 04:27:31 | Kiev Oblast, Ukraine | ||
586438 | 586438 | 2020-08-13 | Ukraine | Kiev Oblast | 4377 | 72 | 3044 | 1261 | 50.053 | 30.7667 | 2020-08-14 04:51:19 | Kiev 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]);