johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
946 rows where country_or_region = "Colombia" and province_or_state = "Valle del Cauca" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1089938 | 1089938 | 2021-03-03 | Colombia | Valle del Cauca | 196532 | 6222 | 186041 | 4269 | 3.8009 | -76.6413 | 2021-03-04 05:24:24 | Valle del Cauca, Colombia | ||
3254010 | 3254010 | 2021-03-02 | Colombia | Valle del Cauca | 196155 | 6208 | 185761 | 4186 | 3.8009 | -76.6413 | 2021-03-03 05:23:28 | Valle del Cauca, Colombia | ||
998302 | 998302 | 2021-03-01 | Colombia | Valle del Cauca | 195869 | 6198 | 185451 | 4220 | 3.8009 | -76.6413 | 2021-03-02 05:23:30 | Valle del Cauca, Colombia | ||
2367360 | 2367360 | 2021-02-28 | Colombia | Valle del Cauca | 195638 | 6187 | 185007 | 4444 | 3.8009 | -76.6413 | 2021-03-01 05:23:01 | Valle del Cauca, Colombia | ||
3065862 | 3065862 | 2021-02-27 | Colombia | Valle del Cauca | 195284 | 6171 | 184690 | 4423 | 3.8009 | -76.6413 | 2021-02-28 05:22:20 | Valle del Cauca, Colombia | ||
2183446 | 2183446 | 2021-02-26 | Colombia | Valle del Cauca | 194879 | 6153 | 184301 | 4425 | 3.8009 | -76.6413 | 2021-02-27 05:22:28 | Valle del Cauca, Colombia | ||
1857868 | 1857868 | 2021-02-25 | Colombia | Valle del Cauca | 194432 | 6142 | 183926 | 4364 | 3.8009 | -76.6413 | 2021-02-26 05:22:40 | Valle del Cauca, Colombia | ||
280046 | 280046 | 2021-02-24 | Colombia | Valle del Cauca | 194047 | 6128 | 183507 | 4412 | 3.8009 | -76.6413 | 2021-02-25 05:24:57 | Valle del Cauca, Colombia | ||
1936314 | 1936314 | 2021-02-23 | Colombia | Valle del Cauca | 193667 | 6114 | 183084 | 4469 | 3.8009 | -76.6413 | 2021-02-24 05:29:16 | Valle del Cauca, Colombia | ||
530569 | 530569 | 2021-02-22 | Colombia | Valle del Cauca | 193277 | 6100 | 182532 | 4645 | 3.8009 | -76.6413 | 2021-02-23 05:23:41 | Valle del Cauca, Colombia | ||
181903 | 181903 | 2021-02-21 | Colombia | Valle del Cauca | 192857 | 6085 | 181976 | 4796 | 3.8009 | -76.6413 | 2021-02-22 05:24:21 | Valle del Cauca, Colombia | ||
742177 | 742177 | 2021-02-20 | Colombia | Valle del Cauca | 192361 | 6046 | 181486 | 4829 | 3.8009 | -76.6413 | 2021-02-21 05:24:33 | Valle del Cauca, Colombia | ||
471275 | 471275 | 2021-02-19 | Colombia | Valle del Cauca | 191789 | 6043 | 180925 | 4821 | 3.8009 | -76.6413 | 2021-02-20 05:22:51 | Valle del Cauca, Colombia | ||
1152984 | 1152984 | 2021-02-18 | Colombia | Valle del Cauca | 191264 | 6018 | 180241 | 5005 | 3.8009 | -76.6413 | 2021-02-19 05:24:16 | Valle del Cauca, Colombia | ||
3600904 | 3600904 | 2021-02-17 | Colombia | Valle del Cauca | 190600 | 5998 | 179567 | 5035 | 3.8009 | -76.6413 | 2021-02-18 05:22:58 | Valle del Cauca, Colombia | ||
3050039 | 3050039 | 2021-02-16 | Colombia | Valle del Cauca | 190101 | 5981 | 178918 | 5202 | 3.8009 | -76.6413 | 2021-02-17 05:23:10 | Valle del Cauca, Colombia | ||
1338138 | 1338138 | 2021-02-15 | Colombia | Valle del Cauca | 189439 | 5964 | 178306 | 5169 | 3.8009 | -76.6413 | 2021-02-16 05:24:38 | Valle del Cauca, Colombia | ||
2283289 | 2283289 | 2021-02-14 | Colombia | Valle del Cauca | 189004 | 5940 | 177690 | 5374 | 3.8009 | -76.6413 | 2021-02-15 05:24:49 | Valle del Cauca, Colombia | ||
2677689 | 2677689 | 2021-02-13 | Colombia | Valle del Cauca | 188511 | 5915 | 177174 | 5422 | 3.8009 | -76.6413 | 2021-02-14 05:23:43 | Valle del Cauca, Colombia | ||
3539322 | 3539322 | 2021-02-12 | Colombia | Valle del Cauca | 188102 | 5890 | 176478 | 5734 | 3.8009 | -76.6413 | 2021-02-13 05:22:12 | Valle del Cauca, Colombia | ||
2637585 | 2637585 | 2021-02-11 | Colombia | Valle del Cauca | 187395 | 5859 | 175678 | 5858 | 3.8009 | -76.6413 | 2021-02-12 05:23:29 | Valle del Cauca, Colombia | ||
3978440 | 3978440 | 2021-02-10 | Colombia | Valle del Cauca | 186685 | 5818 | 174289 | 6578 | 3.8009 | -76.6413 | 2021-02-11 05:23:55 | Valle del Cauca, Colombia | ||
1527760 | 1527760 | 2021-02-09 | Colombia | Valle del Cauca | 185760 | 5794 | 173405 | 6561 | 3.8009 | -76.6413 | 2021-02-10 05:22:41 | Valle del Cauca, Colombia | ||
613551 | 613551 | 2021-02-08 | Colombia | Valle del Cauca | 185034 | 5771 | 171986 | 7277 | 3.8009 | -76.6413 | 2021-02-09 05:23:30 | Valle del Cauca, Colombia | ||
1672320 | 1672320 | 2021-02-07 | Colombia | Valle del Cauca | 184578 | 5719 | 170822 | 8037 | 3.8009 | -76.6413 | 2021-02-08 05:22:39 | Valle del Cauca, Colombia | ||
974781 | 974781 | 2021-02-06 | Colombia | Valle del Cauca | 183398 | 5672 | 169828 | 7898 | 3.8009 | -76.6413 | 2021-02-07 05:23:00 | Valle del Cauca, Colombia | ||
1588039 | 1588039 | 2021-02-05 | Colombia | Valle del Cauca | 181734 | 5634 | 168343 | 7757 | 3.8009 | -76.6413 | 2021-02-06 05:23:55 | Valle del Cauca, Colombia | ||
790246 | 790246 | 2021-02-04 | Colombia | Valle del Cauca | 180679 | 5601 | 167159 | 7919 | 3.8009 | -76.6413 | 2021-02-05 05:22:38 | Valle del Cauca, Colombia | ||
340138 | 340138 | 2021-02-03 | Colombia | Valle del Cauca | 179283 | 5569 | 165947 | 7767 | 3.8009 | -76.6413 | 2021-02-04 05:22:26 | Valle del Cauca, Colombia | ||
1684364 | 1684364 | 2021-02-02 | Colombia | Valle del Cauca | 178104 | 5531 | 163889 | 8684 | 3.8009 | -76.6413 | 2021-02-03 05:22:52 | Valle del Cauca, Colombia | ||
1676334 | 1676334 | 2021-02-01 | Colombia | Valle del Cauca | 176733 | 5484 | 159122 | 12127 | 3.8009 | -76.6413 | 2021-02-02 05:22:49 | Valle del Cauca, Colombia | ||
1459622 | 1459622 | 2021-01-31 | Colombia | Valle del Cauca | 173449 | 5456 | 157368 | 10625 | 3.8009 | -76.6413 | 2021-02-01 05:22:53 | Valle del Cauca, Colombia | ||
2211530 | 2211530 | 2021-01-30 | Colombia | Valle del Cauca | 172607 | 5423 | 156360 | 10824 | 3.8009 | -76.6413 | 2021-01-31 05:22:42 | Valle del Cauca, Colombia | ||
1897017 | 1897017 | 2021-01-29 | Colombia | Valle del Cauca | 171438 | 5376 | 155292 | 10770 | 3.8009 | -76.6413 | 2021-01-30 05:22:49 | Valle del Cauca, Colombia | ||
2481833 | 2481833 | 2021-01-28 | Colombia | Valle del Cauca | 170516 | 5338 | 153479 | 11699 | 3.8009 | -76.6413 | 2021-01-29 05:22:23 | Valle del Cauca, Colombia | ||
3153468 | 3153468 | 2021-01-27 | Colombia | Valle del Cauca | 168849 | 5295 | 152118 | 11436 | 3.8009 | -76.6413 | 2021-01-28 05:22:24 | Valle del Cauca, Colombia | ||
12203 | 12203 | 2021-01-26 | Colombia | Valle del Cauca | 165238 | 5183 | 150194 | 9861 | 3.8009 | -76.6413 | 2021-01-27 05:23:41 | Valle del Cauca, Colombia | ||
2567527 | 2567527 | 2021-01-25 | Colombia | Valle del Cauca | 165238 | 5183 | 150194 | 9861 | 3.8009 | -76.6413 | 2021-01-26 05:22:02 | Valle del Cauca, Colombia | ||
1759159 | 1759159 | 2021-01-24 | Colombia | Valle del Cauca | 163715 | 5140 | 149829 | 8746 | 3.8009 | -76.6413 | 2021-01-25 05:22:16 | Valle del Cauca, Colombia | ||
2426766 | 2426766 | 2021-01-23 | Colombia | Valle del Cauca | 162173 | 5088 | 148793 | 8292 | 3.8009 | -76.6413 | 2021-01-24 05:22:35 | Valle del Cauca, Colombia | ||
2466668 | 2466668 | 2021-01-22 | Colombia | Valle del Cauca | 160839 | 5045 | 147447 | 8347 | 3.8009 | -76.6413 | 2021-01-23 05:22:03 | Valle del Cauca, Colombia | ||
435219 | 435219 | 2021-01-21 | Colombia | Valle del Cauca | 159546 | 4993 | 145649 | 8904 | 3.8009 | -76.6413 | 2021-01-22 05:22:10 | Valle del Cauca, Colombia | ||
1093951 | 1093951 | 2021-01-20 | Colombia | Valle del Cauca | 158021 | 4953 | 145410 | 7658 | 3.8009 | -76.6413 | 2021-01-21 05:22:01 | Valle del Cauca, Colombia | ||
908041 | 908041 | 2021-01-19 | Colombia | Valle del Cauca | 157186 | 4918 | 143374 | 8894 | 3.8009 | -76.6413 | 2021-01-20 05:21:54 | Valle del Cauca, Colombia | ||
237104 | 237104 | 2021-01-18 | Colombia | Valle del Cauca | 155727 | 4877 | 142847 | 8003 | 3.8009 | -76.6413 | 2021-01-19 05:22:15 | Valle del Cauca, Colombia | ||
3503221 | 3503221 | 2021-01-17 | Colombia | Valle del Cauca | 154378 | 4847 | 141791 | 7740 | 3.8009 | -76.6413 | 2021-01-18 05:22:34 | Valle del Cauca, Colombia | ||
3101304 | 3101304 | 2021-01-16 | Colombia | Valle del Cauca | 154000 | 4795 | 139727 | 9478 | 3.8009 | -76.6413 | 2021-01-17 05:22:17 | Valle del Cauca, Colombia | ||
3515266 | 3515266 | 2021-01-15 | Colombia | Valle del Cauca | 152667 | 4760 | 138712 | 9195 | 3.8009 | -76.6413 | 2021-01-16 05:22:40 | Valle del Cauca, Colombia | ||
3879439 | 3879439 | 2021-01-14 | Colombia | Valle del Cauca | 151261 | 4720 | 137903 | 8638 | 3.8009 | -76.6413 | 2021-01-15 05:22:24 | Valle del Cauca, Colombia | ||
3308066 | 3308066 | 2021-01-13 | Colombia | Valle del Cauca | 150027 | 4676 | 137536 | 7815 | 3.8009 | -76.6413 | 2021-01-14 05:22:32 | Valle del Cauca, Colombia | ||
774211 | 774211 | 2021-01-12 | Colombia | Valle del Cauca | 148437 | 4644 | 136214 | 7579 | 3.8009 | -76.6413 | 2021-01-13 05:22:15 | Valle del Cauca, Colombia | ||
189932 | 189932 | 2021-01-11 | Colombia | Valle del Cauca | 147826 | 4629 | 135492 | 7705 | 3.8009 | -76.6413 | 2021-01-12 05:22:15 | Valle del Cauca, Colombia | ||
2625735 | 2625735 | 2021-01-10 | Colombia | Valle del Cauca | 146871 | 4591 | 135031 | 7249 | 3.8009 | -76.6413 | 2021-01-11 05:21:50 | Valle del Cauca, Colombia | ||
3899823 | 3899823 | 2021-01-09 | Colombia | Valle del Cauca | 146281 | 4555 | 134213 | 7513 | 3.8009 | -76.6413 | 2021-01-10 05:22:12 | Valle del Cauca, Colombia | ||
153846 | 153846 | 2021-01-08 | Colombia | Valle del Cauca | 145281 | 4513 | 133231 | 7537 | 3.8009 | -76.6413 | 2021-01-09 05:22:18 | Valle del Cauca, Colombia | ||
2541270 | 2541270 | 2021-01-07 | Colombia | Valle del Cauca | 144010 | 4481 | 132237 | 7292 | 3.8009 | -76.6413 | 2021-01-08 05:22:42 | Valle del Cauca, Colombia | ||
2864579 | 2864579 | 2021-01-06 | Colombia | Valle del Cauca | 142758 | 4439 | 131964 | 6355 | 3.8009 | -76.6413 | 2021-01-07 05:22:03 | Valle del Cauca, Colombia | ||
3034166 | 3034166 | 2021-01-05 | Colombia | Valle del Cauca | 141498 | 4397 | 131506 | 5595 | 3.8009 | -76.6413 | 2021-01-06 05:22:16 | Valle del Cauca, Colombia | ||
1061711 | 1061711 | 2021-01-04 | Colombia | Valle del Cauca | 140721 | 4349 | 130939 | 5433 | 3.8009 | -76.6413 | 2021-01-05 05:21:49 | Valle del Cauca, Colombia | ||
3230314 | 3230314 | 2021-01-03 | Colombia | Valle del Cauca | 140303 | 4345 | 129924 | 6034 | 3.8009 | -76.6413 | 2021-01-04 05:22:02 | Valle del Cauca, Colombia | ||
2227384 | 2227384 | 2021-01-02 | Colombia | Valle del Cauca | 139616 | 4329 | 129343 | 5944 | 3.8009 | -76.6413 | 2021-01-03 05:22:52 | Valle del Cauca, Colombia | ||
1136748 | 1136748 | 2021-01-01 | Colombia | Valle del Cauca | 138870 | 4297 | 127897 | 6676 | 3.8009 | -76.6413 | 2021-01-02 05:22:33 | Valle del Cauca, Colombia | ||
3695354 | 3695354 | 2020-12-31 | Colombia | Valle del Cauca | 137867 | 4274 | 126646 | 6947 | 3.8009 | -76.6413 | 2021-01-01 05:23:07 | Valle del Cauca, Colombia | ||
1010169 | 1010169 | 2020-12-30 | Colombia | Valle del Cauca | 136522 | 4232 | 124756 | 7534 | 3.8009 | -76.6413 | 2020-12-31 05:22:49 | Valle del Cauca, Colombia | ||
766184 | 766184 | 2020-12-29 | Colombia | Valle del Cauca | 135455 | 4214 | 122990 | 8251 | 3.8009 | -76.6413 | 2020-12-30 05:22:34 | Valle del Cauca, Colombia | ||
3761448 | 3761448 | 2020-12-28 | Colombia | Valle del Cauca | 134166 | 4181 | 122785 | 7200 | 3.8009 | -76.6413 | 2020-12-29 05:22:37 | Valle del Cauca, Colombia | ||
3777768 | 3777768 | 2020-12-27 | Colombia | Valle del Cauca | 133536 | 4162 | 121281 | 8093 | 3.8009 | -76.6413 | 2020-12-28 05:22:06 | Valle del Cauca, Colombia | ||
2223373 | 2223373 | 2020-12-26 | Colombia | Valle del Cauca | 132781 | 4138 | 120178 | 8465 | 3.8009 | -76.6413 | 2020-12-27 05:22:55 | Valle del Cauca, Colombia | ||
202120 | 202120 | 2020-12-25 | Colombia | Valle del Cauca | 131644 | 4105 | 118960 | 8579 | 3.8009 | -76.6413 | 2020-12-26 05:22:28 | Valle del Cauca, Colombia | ||
3691343 | 3691343 | 2020-12-24 | Colombia | Valle del Cauca | 130202 | 4069 | 118009 | 8124 | 3.8009 | -76.6413 | 2020-12-25 05:22:48 | Valle del Cauca, Colombia | ||
2406695 | 2406695 | 2020-12-23 | Colombia | Valle del Cauca | 129046 | 4050 | 116674 | 8322 | 3.8009 | -76.6413 | 2020-12-24 05:23:04 | Valle del Cauca, Colombia | ||
3769741 | 3769741 | 2020-12-22 | Colombia | Valle del Cauca | 127509 | 4028 | 116001 | 7480 | 3.8009 | -76.6413 | 2020-12-23 05:22:03 | Valle del Cauca, Colombia | ||
927557 | 927557 | 2020-12-21 | Colombia | Valle del Cauca | 126708 | 4007 | 115478 | 7223 | 3.8009 | -76.6413 | 2020-12-22 05:22:33 | Valle del Cauca, Colombia | ||
2119578 | 2119578 | 2020-12-20 | Colombia | Valle del Cauca | 125849 | 3980 | 114931 | 6938 | 3.8009 | -76.6413 | 2020-12-21 05:27:58 | Valle del Cauca, Colombia | ||
2931085 | 2931085 | 2020-12-19 | Colombia | Valle del Cauca | 125081 | 3958 | 114281 | 6842 | 3.8009 | -76.6413 | 2020-12-20 05:27:32 | Valle del Cauca, Colombia | ||
1901031 | 1901031 | 2020-12-18 | Colombia | Valle del Cauca | 124174 | 3928 | 113675 | 6571 | 3.8009 | -76.6413 | 2020-12-19 05:27:52 | Valle del Cauca, Colombia | ||
2127857 | 2127857 | 2020-12-17 | Colombia | Valle del Cauca | 123331 | 3883 | 112150 | 7298 | 3.8009 | -76.6413 | 2020-12-18 05:28:18 | Valle del Cauca, Colombia | ||
3149457 | 3149457 | 2020-12-16 | Colombia | Valle del Cauca | 122199 | 3877 | 111820 | 6502 | 3.8009 | -76.6413 | 2020-12-17 05:28:12 | Valle del Cauca, Colombia | ||
1034238 | 1034238 | 2020-12-15 | Colombia | Valle del Cauca | 121146 | 3845 | 110932 | 6369 | 3.8009 | -76.6413 | 2020-12-16 05:28:04 | Valle del Cauca, Colombia | ||
1751132 | 1751132 | 2020-12-14 | Colombia | Valle del Cauca | 120087 | 3827 | 110311 | 5949 | 3.8009 | -76.6413 | 2020-12-15 05:26:38 | Valle del Cauca, Colombia | ||
3847652 | 3847652 | 2020-12-13 | Colombia | Valle del Cauca | 119351 | 3812 | 109519 | 6020 | 3.8009 | -76.6413 | 2020-12-14 05:26:27 | Valle del Cauca, Colombia | ||
845434 | 845434 | 2020-12-12 | Colombia | Valle del Cauca | 118737 | 3790 | 109095 | 5852 | 3.8009 | -76.6413 | 2020-12-13 05:27:20 | Valle del Cauca, Colombia | ||
860541 | 860541 | 2020-12-11 | Colombia | Valle del Cauca | 117941 | 3767 | 108319 | 5855 | 3.8009 | -76.6413 | 2020-12-12 05:26:19 | Valle del Cauca, Colombia | ||
1600083 | 1600083 | 2020-12-10 | Colombia | Valle del Cauca | 117241 | 3744 | 107396 | 6101 | 3.8009 | -76.6413 | 2020-12-11 05:26:59 | Valle del Cauca, Colombia | ||
2975092 | 2975092 | 2020-12-09 | Colombia | Valle del Cauca | 116273 | 3718 | 106538 | 6017 | 3.8009 | -76.6413 | 2020-12-10 05:26:19 | Valle del Cauca, Colombia | ||
1818652 | 1818652 | 2020-12-08 | Colombia | Valle del Cauca | 115538 | 3681 | 105130 | 6727 | 3.8009 | -76.6413 | 2020-12-09 05:28:01 | Valle del Cauca, Colombia | ||
2347288 | 2347288 | 2020-12-07 | Colombia | Valle del Cauca | 114136 | 3663 | 103481 | 6992 | 3.8009 | -76.6413 | 2020-12-08 05:27:42 | Valle del Cauca, Colombia | ||
1006158 | 1006158 | 2020-12-06 | Colombia | Valle del Cauca | 113414 | 3631 | 102582 | 7201 | 3.8009 | -76.6413 | 2020-12-07 05:26:14 | Valle del Cauca, Colombia | ||
1632167 | 1632167 | 2020-12-05 | Colombia | Valle del Cauca | 112671 | 3607 | 101831 | 7233 | 3.8009 | -76.6413 | 2020-12-06 05:26:18 | Valle del Cauca, Colombia | ||
3859695 | 3859695 | 2020-12-04 | Colombia | Valle del Cauca | 111822 | 3572 | 101014 | 7236 | 3.8009 | -76.6413 | 2020-12-05 05:27:36 | Valle del Cauca, Colombia | ||
74953 | 74953 | 2020-12-03 | Colombia | Valle del Cauca | 111017 | 3557 | 100220 | 7240 | 3.8009 | -76.6413 | 2020-12-04 05:27:27 | Valle del Cauca, Colombia | ||
738165 | 738165 | 2020-12-02 | Colombia | Valle del Cauca | 110006 | 3530 | 99433 | 7043 | 3.8009 | -76.6413 | 2020-12-03 05:28:22 | Valle del Cauca, Colombia | ||
2537259 | 2537259 | 2020-12-01 | Colombia | Valle del Cauca | 108948 | 3507 | 98445 | 6996 | 3.8009 | -76.6413 | 2020-12-02 05:27:41 | Valle del Cauca, Colombia | ||
1584028 | 1584028 | 2020-11-30 | Colombia | Valle del Cauca | 108058 | 3495 | 98136 | 6427 | 3.8009 | -76.6413 | 2020-12-01 05:26:18 | Valle del Cauca, Colombia | ||
3566431 | 3566431 | 2020-11-29 | Colombia | Valle del Cauca | 107558 | 3467 | 97279 | 6812 | 3.8009 | -76.6413 | 2020-11-30 05:26:13 | Valle del Cauca, Colombia | ||
2935096 | 2935096 | 2020-11-28 | Colombia | Valle del Cauca | 106573 | 3441 | 96794 | 6338 | 3.8009 | -76.6413 | 2020-11-29 05:25:55 | Valle del Cauca, Colombia | ||
392099 | 392099 | 2020-11-27 | Colombia | Valle del Cauca | 105872 | 3413 | 95980 | 6479 | 3.8009 | -76.6413 | 2020-11-28 05:25:50 | Valle del Cauca, Colombia | ||
923546 | 923546 | 2020-11-26 | Colombia | Valle del Cauca | 105253 | 3392 | 95110 | 6751 | 3.8009 | -76.6413 | 2020-11-27 05:26:53 | Valle del Cauca, Colombia | ||
1972451 | 1972451 | 2020-11-25 | Colombia | Valle del Cauca | 104372 | 3371 | 94511 | 6490 | 3.8009 | -76.6413 | 2020-11-26 05:27:44 | Valle del Cauca, Colombia | ||
1350182 | 1350182 | 2020-11-24 | Colombia | Valle del Cauca | 103586 | 3341 | 93533 | 6712 | 3.8009 | -76.6413 | 2020-11-25 05:27:20 | Valle del Cauca, Colombia |
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]);