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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
193692 | 193692 | 2021-01-11 | Ukraine | Kiev Oblast | 63700 | 1019 | 41830 | 20851 | 50.053 | 30.7667 | 2021-01-12 05:22:15 | Kiev Oblast, Ukraine | ||
2629495 | 2629495 | 2021-01-10 | Ukraine | Kiev Oblast | 63335 | 1019 | 41576 | 20740 | 50.053 | 30.7667 | 2021-01-11 05:21:50 | Kiev Oblast, Ukraine | ||
3903583 | 3903583 | 2021-01-09 | Ukraine | Kiev Oblast | 62930 | 1017 | 41053 | 20860 | 50.053 | 30.7667 | 2021-01-10 05:22:12 | Kiev Oblast, Ukraine | ||
157606 | 157606 | 2021-01-08 | Ukraine | Kiev Oblast | 62555 | 1014 | 40583 | 20958 | 50.053 | 30.7667 | 2021-01-09 05:22:18 | Kiev Oblast, Ukraine | ||
2545030 | 2545030 | 2021-01-07 | Ukraine | Kiev Oblast | 62184 | 1014 | 40166 | 21004 | 50.053 | 30.7667 | 2021-01-08 05:22:42 | Kiev Oblast, Ukraine | ||
2868339 | 2868339 | 2021-01-06 | Ukraine | Kiev Oblast | 61704 | 1000 | 39242 | 21462 | 50.053 | 30.7667 | 2021-01-07 05:22:03 | Kiev Oblast, Ukraine | ||
3037926 | 3037926 | 2021-01-05 | Ukraine | Kiev Oblast | 61108 | 986 | 38039 | 22083 | 50.053 | 30.7667 | 2021-01-06 05:22:16 | Kiev Oblast, Ukraine | ||
1065471 | 1065471 | 2021-01-04 | Ukraine | Kiev Oblast | 60842 | 979 | 37218 | 22645 | 50.053 | 30.7667 | 2021-01-05 05:21:49 | Kiev Oblast, Ukraine | ||
3234074 | 3234074 | 2021-01-03 | Ukraine | Kiev Oblast | 60541 | 977 | 36923 | 22641 | 50.053 | 30.7667 | 2021-01-04 05:22:02 | Kiev Oblast, Ukraine | ||
2231143 | 2231143 | 2021-01-02 | Ukraine | Kiev Oblast | 60238 | 976 | 36583 | 22679 | 50.053 | 30.7667 | 2021-01-03 05:22:52 | Kiev Oblast, Ukraine | ||
1140507 | 1140507 | 2021-01-01 | Ukraine | Kiev Oblast | 59831 | 976 | 36191 | 22664 | 50.053 | 30.7667 | 2021-01-02 05:22:33 | Kiev Oblast, Ukraine | ||
3699113 | 3699113 | 2020-12-31 | Ukraine | Kiev Oblast | 59204 | 966 | 34965 | 23273 | 50.053 | 30.7667 | 2021-01-01 05:23:07 | Kiev Oblast, Ukraine | ||
1013928 | 1013928 | 2020-12-30 | Ukraine | Kiev Oblast | 58535 | 955 | 33996 | 23584 | 50.053 | 30.7667 | 2020-12-31 05:22:49 | Kiev Oblast, Ukraine | ||
769943 | 769943 | 2020-12-29 | Ukraine | Kiev Oblast | 57912 | 941 | 32341 | 24630 | 50.053 | 30.7667 | 2020-12-30 05:22:34 | Kiev Oblast, Ukraine | ||
3765207 | 3765207 | 2020-12-28 | Ukraine | Kiev Oblast | 57614 | 934 | 31804 | 24876 | 50.053 | 30.7667 | 2020-12-29 05:22:37 | Kiev Oblast, Ukraine | ||
3781527 | 3781527 | 2020-12-27 | Ukraine | Kiev Oblast | 57331 | 933 | 31586 | 24812 | 50.053 | 30.7667 | 2020-12-28 05:22:06 | Kiev Oblast, Ukraine | ||
2227132 | 2227132 | 2020-12-26 | Ukraine | Kiev Oblast | 56942 | 931 | 31124 | 24887 | 50.053 | 30.7667 | 2020-12-27 05:22:55 | Kiev Oblast, Ukraine | ||
205879 | 205879 | 2020-12-25 | Ukraine | Kiev Oblast | 56374 | 928 | 30475 | 24971 | 50.053 | 30.7667 | 2020-12-26 05:22:28 | Kiev Oblast, Ukraine | ||
3695102 | 3695102 | 2020-12-24 | Ukraine | Kiev Oblast | 55497 | 917 | 28836 | 25744 | 50.053 | 30.7667 | 2020-12-25 05:22:48 | Kiev Oblast, Ukraine | ||
2410454 | 2410454 | 2020-12-23 | Ukraine | Kiev Oblast | 54831 | 899 | 27354 | 26578 | 50.053 | 30.7667 | 2020-12-24 05:23:04 | Kiev Oblast, Ukraine | ||
3773500 | 3773500 | 2020-12-22 | Ukraine | Kiev Oblast | 54022 | 888 | 25928 | 27206 | 50.053 | 30.7667 | 2020-12-23 05:22:03 | Kiev Oblast, Ukraine | ||
931316 | 931316 | 2020-12-21 | Ukraine | Kiev Oblast | 53463 | 881 | 24812 | 27770 | 50.053 | 30.7667 | 2020-12-22 05:22:33 | Kiev Oblast, Ukraine | ||
2123337 | 2123337 | 2020-12-20 | Ukraine | Kiev Oblast | 53007 | 881 | 24612 | 27514 | 50.053 | 30.7667 | 2020-12-21 05:27:58 | Kiev Oblast, Ukraine | ||
2934844 | 2934844 | 2020-12-19 | Ukraine | Kiev Oblast | 52415 | 879 | 24286 | 27250 | 50.053 | 30.7667 | 2020-12-20 05:27:32 | Kiev Oblast, Ukraine | ||
1904790 | 1904790 | 2020-12-18 | Ukraine | Kiev Oblast | 51588 | 859 | 23476 | 27253 | 50.053 | 30.7667 | 2020-12-19 05:27:52 | Kiev Oblast, Ukraine | ||
2131616 | 2131616 | 2020-12-17 | Ukraine | Kiev Oblast | 50666 | 849 | 22485 | 27332 | 50.053 | 30.7667 | 2020-12-18 05:28:18 | Kiev Oblast, Ukraine | ||
3153216 | 3153216 | 2020-12-16 | Ukraine | Kiev Oblast | 50040 | 840 | 21612 | 27588 | 50.053 | 30.7667 | 2020-12-17 05:28:12 | Kiev Oblast, Ukraine | ||
1037997 | 1037997 | 2020-12-15 | Ukraine | Kiev Oblast | 49335 | 834 | 20884 | 27617 | 50.053 | 30.7667 | 2020-12-16 05:28:04 | Kiev Oblast, Ukraine | ||
1754891 | 1754891 | 2020-12-14 | Ukraine | Kiev Oblast | 49044 | 820 | 20099 | 28125 | 50.053 | 30.7667 | 2020-12-15 05:26:38 | Kiev Oblast, Ukraine | ||
3851411 | 3851411 | 2020-12-13 | Ukraine | Kiev Oblast | 48523 | 818 | 19862 | 27843 | 50.053 | 30.7667 | 2020-12-14 05:26:27 | Kiev Oblast, Ukraine | ||
849193 | 849193 | 2020-12-12 | Ukraine | Kiev Oblast | 47783 | 817 | 19626 | 27340 | 50.053 | 30.7667 | 2020-12-13 05:27:20 | Kiev Oblast, Ukraine | ||
864300 | 864300 | 2020-12-11 | Ukraine | Kiev Oblast | 46998 | 805 | 18864 | 27329 | 50.053 | 30.7667 | 2020-12-12 05:26:19 | Kiev Oblast, Ukraine | ||
1603842 | 1603842 | 2020-12-10 | Ukraine | Kiev Oblast | 46211 | 789 | 18270 | 27152 | 50.053 | 30.7667 | 2020-12-11 05:26:59 | Kiev Oblast, Ukraine | ||
2978851 | 2978851 | 2020-12-09 | Ukraine | Kiev Oblast | 45497 | 780 | 17476 | 27241 | 50.053 | 30.7667 | 2020-12-10 05:26:19 | Kiev Oblast, Ukraine | ||
1822411 | 1822411 | 2020-12-08 | Ukraine | Kiev Oblast | 44554 | 764 | 16673 | 27117 | 50.053 | 30.7667 | 2020-12-09 05:28:01 | Kiev Oblast, Ukraine | ||
2351047 | 2351047 | 2020-12-07 | Ukraine | Kiev Oblast | 43854 | 746 | 16077 | 27031 | 50.053 | 30.7667 | 2020-12-08 05:27:42 | Kiev Oblast, Ukraine | ||
1009917 | 1009917 | 2020-12-06 | Ukraine | Kiev Oblast | 43219 | 744 | 15735 | 26740 | 50.053 | 30.7667 | 2020-12-07 05:26:14 | Kiev Oblast, Ukraine | ||
1635926 | 1635926 | 2020-12-05 | Ukraine | Kiev Oblast | 42410 | 740 | 15494 | 26176 | 50.053 | 30.7667 | 2020-12-06 05:26:18 | Kiev Oblast, Ukraine | ||
3863454 | 3863454 | 2020-12-04 | Ukraine | Kiev Oblast | 41415 | 727 | 14648 | 26040 | 50.053 | 30.7667 | 2020-12-05 05:27:36 | Kiev Oblast, Ukraine | ||
78712 | 78712 | 2020-12-03 | Ukraine | Kiev Oblast | 40427 | 719 | 13898 | 25810 | 50.053 | 30.7667 | 2020-12-04 05:27:27 | Kiev Oblast, Ukraine | ||
741924 | 741924 | 2020-12-02 | Ukraine | Kiev Oblast | 39503 | 703 | 13240 | 25560 | 50.053 | 30.7667 | 2020-12-03 05:28:22 | Kiev Oblast, Ukraine | ||
2541018 | 2541018 | 2020-12-01 | Ukraine | Kiev Oblast | 38528 | 691 | 12880 | 24957 | 50.053 | 30.7667 | 2020-12-02 05:27:41 | Kiev Oblast, Ukraine | ||
1587787 | 1587787 | 2020-11-30 | Ukraine | Kiev Oblast | 37687 | 678 | 12694 | 24315 | 50.053 | 30.7667 | 2020-12-01 05:26:18 | Kiev Oblast, Ukraine | ||
3570190 | 3570190 | 2020-11-29 | Ukraine | Kiev Oblast | 36996 | 678 | 12646 | 23672 | 50.053 | 30.7667 | 2020-11-30 05:26:13 | Kiev Oblast, Ukraine | ||
2938855 | 2938855 | 2020-11-28 | Ukraine | Kiev Oblast | 36214 | 675 | 12504 | 23035 | 50.053 | 30.7667 | 2020-11-29 05:25:55 | Kiev Oblast, Ukraine | ||
395858 | 395858 | 2020-11-27 | Ukraine | Kiev Oblast | 35235 | 667 | 12096 | 22472 | 50.053 | 30.7667 | 2020-11-28 05:25:50 | Kiev Oblast, Ukraine | ||
927305 | 927305 | 2020-11-26 | Ukraine | Kiev Oblast | 34241 | 652 | 11853 | 21736 | 50.053 | 30.7667 | 2020-11-27 05:26:53 | Kiev Oblast, Ukraine | ||
1976210 | 1976210 | 2020-11-25 | Ukraine | Kiev Oblast | 33262 | 644 | 11673 | 20945 | 50.053 | 30.7667 | 2020-11-26 05:27:44 | Kiev Oblast, Ukraine | ||
1353941 | 1353941 | 2020-11-24 | Ukraine | Kiev Oblast | 32301 | 629 | 11389 | 20283 | 50.053 | 30.7667 | 2020-11-25 05:27:20 | Kiev Oblast, Ukraine | ||
681935 | 681935 | 2020-11-23 | Ukraine | Kiev Oblast | 31212 | 626 | 11218 | 19368 | 50.053 | 30.7667 | 2020-11-24 05:27:31 | Kiev Oblast, Ukraine | ||
3193611 | 3193611 | 2020-11-22 | Ukraine | Kiev Oblast | 30342 | 624 | 11163 | 18555 | 50.053 | 30.7667 | 2020-11-23 05:25:26 | Kiev Oblast, Ukraine | ||
3840105 | 3840105 | 2020-11-21 | Ukraine | Kiev Oblast | 29380 | 620 | 11091 | 17669 | 50.053 | 30.7667 | 2020-11-22 05:25:45 | Kiev Oblast, Ukraine | ||
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 |
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]);