johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
640 rows where country_or_region = "Ukraine" and latitude = "50.053" sorted by confirmed
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1269722 | 1269722 | 2020-06-05 | Ukraine | Kiev Oblast | 1711 | 37 | 472 | 1202 | 50.053 | 30.7667 | 2020-06-06 02:33:00 | Kiev Oblast, Ukraine | ||
574025 | 574025 | 2020-06-06 | Ukraine | Kiev Oblast | 1748 | 37 | 533 | 1178 | 50.053 | 30.7667 | 2020-06-07 03:53:30 | Kiev Oblast, Ukraine | ||
2799969 | 2799969 | 2020-06-07 | Ukraine | Kiev Oblast | 1784 | 37 | 558 | 1189 | 50.053 | 30.7667 | 2020-06-08 03:33:22 | Kiev Oblast, Ukraine | ||
217173 | 217173 | 2020-06-08 | Ukraine | Kiev Oblast | 1812 | 37 | 577 | 1198 | 50.053 | 30.7667 | 2020-06-09 03:33:03 | Kiev Oblast, Ukraine | ||
1210746 | 1210746 | 2020-06-09 | Ukraine | Kiev Oblast | 1836 | 37 | 577 | 1222 | 50.053 | 30.7667 | 2020-06-10 04:07:00 | Kiev Oblast, Ukraine | ||
2863908 | 2863908 | 2020-06-10 | Ukraine | Kiev Oblast | 1865 | 38 | 595 | 1232 | 50.053 | 30.7667 | 2020-06-11 03:33:41 | Kiev Oblast, Ukraine | ||
2632899 | 2632899 | 2020-06-29 | Ukraine | Kiev Oblast | 2546 | 50 | 1318 | 1178 | 50.053 | 30.7667 | 2020-06-30 04:33:48 | Kiev Oblast, Ukraine | ||
3045353 | 3045353 | 2020-07-02 | Ukraine | Kiev Oblast | 2655 | 51 | 1398 | 1206 | 50.053 | 30.7667 | 2020-07-03 04:33:54 | Kiev Oblast, Ukraine | ||
2748060 | 2748060 | 2020-07-15 | Ukraine | Kiev Oblast | 3128 | 58 | 2054 | 1016 | 50.053 | 30.7667 | 2020-07-16 04:44:59 | Kiev Oblast, Ukraine | ||
367392 | 367392 | 2020-07-16 | Ukraine | Kiev Oblast | 3144 | 59 | 2140 | 945 | 50.053 | 30.7667 | 2020-07-17 04:34:50 | Kiev Oblast, Ukraine | ||
844753 | 844753 | 2020-07-22 | Ukraine | Kiev Oblast | 3359 | 59 | 2397 | 903 | 50.053 | 30.7667 | 2020-07-23 05:15:04 | Kiev Oblast, Ukraine | ||
61951 | 61951 | 2020-07-23 | Ukraine | Kiev Oblast | 3391 | 59 | 2465 | 867 | 50.053 | 30.7667 | 2020-07-24 05:30:40 | Kiev Oblast, Ukraine | ||
2563733 | 2563733 | 2020-07-24 | Ukraine | Kiev Oblast | 3421 | 59 | 2511 | 851 | 50.053 | 30.7667 | 2020-07-25 04:47:39 | Kiev Oblast, Ukraine | ||
1502763 | 1502763 | 2020-07-25 | Ukraine | Kiev Oblast | 3461 | 59 | 2561 | 841 | 50.053 | 30.7667 | 2020-07-26 04:35:00 | Kiev Oblast, Ukraine | ||
442519 | 442519 | 2020-07-26 | Ukraine | Kiev Oblast | 3503 | 60 | 2561 | 882 | 50.053 | 30.7667 | 2020-07-27 04:35:02 | Kiev Oblast, Ukraine | ||
177206 | 177206 | 2020-07-27 | Ukraine | Kiev Oblast | 3548 | 60 | 2561 | 927 | 50.053 | 30.7667 | 2020-07-28 04:58:43 | Kiev Oblast, Ukraine | ||
3185154 | 3185154 | 2020-07-28 | Ukraine | Kiev Oblast | 3590 | 60 | 2574 | 956 | 50.053 | 30.7667 | 2020-07-29 04:35:11 | Kiev Oblast, Ukraine | ||
2958538 | 2958538 | 2020-07-29 | Ukraine | Kiev Oblast | 3629 | 60 | 2602 | 967 | 50.053 | 30.7667 | 2020-07-30 04:35:05 | Kiev Oblast, Ukraine | ||
1928370 | 1928370 | 2020-07-30 | Ukraine | Kiev Oblast | 3672 | 62 | 2638 | 972 | 50.053 | 30.7667 | 2020-07-31 04:35:18 | Kiev Oblast, Ukraine | ||
3264663 | 3264663 | 2020-07-31 | Ukraine | Kiev Oblast | 3716 | 63 | 2660 | 993 | 50.053 | 30.7667 | 2020-08-01 04:36:27 | Kiev Oblast, Ukraine | ||
753498 | 753498 | 2020-08-01 | Ukraine | Kiev Oblast | 3787 | 64 | 2697 | 1026 | 50.053 | 30.7667 | 2020-08-02 04:34:47 | Kiev Oblast, Ukraine | ||
2807930 | 2807930 | 2020-08-02 | Ukraine | Kiev Oblast | 3823 | 64 | 2697 | 1062 | 50.053 | 30.7667 | 2020-08-03 04:34:35 | Kiev Oblast, Ukraine | ||
2740178 | 2740178 | 2020-08-03 | Ukraine | Kiev Oblast | 3845 | 64 | 2717 | 1064 | 50.053 | 30.7667 | 2020-08-04 04:41:59 | Kiev Oblast, Ukraine | ||
98295 | 98295 | 2020-08-04 | Ukraine | Kiev Oblast | 3877 | 65 | 2766 | 1046 | 50.053 | 30.7667 | 2020-08-05 04:34:43 | Kiev Oblast, Ukraine | ||
3793059 | 3793059 | 2020-08-05 | Ukraine | Kiev Oblast | 3942 | 66 | 2834 | 1042 | 50.053 | 30.7667 | 2020-08-06 04:35:02 | Kiev Oblast, Ukraine | ||
3612229 | 3612229 | 2020-08-06 | Ukraine | Kiev Oblast | 3980 | 67 | 2880 | 1033 | 50.053 | 30.7667 | 2020-08-07 04:35:11 | Kiev Oblast, Ukraine | ||
458544 | 458544 | 2020-08-07 | Ukraine | Kiev Oblast | 4058 | 67 | 2902 | 1089 | 50.053 | 30.7667 | 2020-08-08 04:34:53 | Kiev Oblast, Ukraine | ||
371360 | 371360 | 2020-08-08 | Ukraine | Kiev Oblast | 4128 | 68 | 2920 | 1140 | 50.053 | 30.7667 | 2020-08-09 04:34:54 | Kiev Oblast, Ukraine | ||
3923192 | 3923192 | 2020-08-09 | Ukraine | Kiev Oblast | 4176 | 68 | 2953 | 1155 | 50.053 | 30.7667 | 2020-08-10 04:34:55 | Kiev Oblast, Ukraine | ||
1920383 | 1920383 | 2020-08-10 | Ukraine | Kiev Oblast | 4197 | 69 | 2962 | 1166 | 50.053 | 30.7667 | 2020-08-11 04:35:08 | Kiev Oblast, Ukraine | ||
662645 | 662645 | 2020-08-11 | Ukraine | Kiev Oblast | 4239 | 70 | 2970 | 1199 | 50.053 | 30.7667 | 2020-08-12 04:27:29 | Kiev Oblast, Ukraine | ||
3535055 | 3535055 | 2020-08-12 | Ukraine | Kiev Oblast | 4307 | 71 | 3021 | 1215 | 50.053 | 30.7667 | 2020-08-13 04:29:15 | 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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 |
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]);