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 last_update
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2712412 | 2712412 | 2020-05-28 | Colombia | Valle del Cauca | 2828 | 138 | 821 | 1869 | 3.8009 | -76.6413 | 2020-05-29 02:32:50 | Valle del Cauca, Colombia | ||
1790533 | 1790533 | 2020-05-29 | Colombia | Valle del Cauca | 2969 | 141 | 840 | 1988 | 3.8009 | -76.6413 | 2020-05-30 02:32:48 | Valle del Cauca, Colombia | ||
3638992 | 3638992 | 2020-05-30 | Colombia | Valle del Cauca | 3083 | 149 | 855 | 2079 | 3.8009 | -76.6413 | 2020-05-31 02:32:45 | Valle del Cauca, Colombia | ||
1794099 | 1794099 | 2020-05-31 | Colombia | Valle del Cauca | 3365 | 154 | 898 | 2313 | 3.8009 | -76.6413 | 2020-06-01 02:32:46 | Valle del Cauca, Colombia | ||
805553 | 805553 | 2020-06-01 | Colombia | Valle del Cauca | 3471 | 161 | 1041 | 2269 | 3.8009 | -76.6413 | 2020-06-02 02:33:08 | Valle del Cauca, Colombia | ||
2556016 | 2556016 | 2020-06-02 | Colombia | Valle del Cauca | 3586 | 169 | 1148 | 2269 | 3.8009 | -76.6413 | 2020-06-03 02:33:13 | Valle del Cauca, Colombia | ||
3866974 | 3866974 | 2020-06-03 | Colombia | Valle del Cauca | 3714 | 179 | 1254 | 2281 | 3.8009 | -76.6413 | 2020-06-04 02:33:14 | Valle del Cauca, Colombia | ||
1281419 | 1281419 | 2020-06-04 | Colombia | Valle del Cauca | 3886 | 190 | 1306 | 2390 | 3.8009 | -76.6413 | 2020-06-05 02:33:06 | Valle del Cauca, Colombia | ||
1269954 | 1269954 | 2020-06-05 | Colombia | Valle del Cauca | 4206 | 202 | 1430 | 2574 | 3.8009 | -76.6413 | 2020-06-06 02:33:00 | Valle del Cauca, Colombia | ||
574257 | 574257 | 2020-06-06 | Colombia | Valle del Cauca | 4206 | 202 | 1430 | 2574 | 3.8009 | -76.6413 | 2020-06-07 03:53:30 | Valle del Cauca, Colombia | ||
2800201 | 2800201 | 2020-06-07 | Colombia | Valle del Cauca | 4355 | 211 | 1474 | 2670 | 3.8009 | -76.6413 | 2020-06-08 03:33:22 | Valle del Cauca, Colombia | ||
217404 | 217404 | 2020-06-08 | Colombia | Valle del Cauca | 4677 | 223 | 1727 | 2727 | 3.8009 | -76.6413 | 2020-06-09 03:33:03 | Valle del Cauca, Colombia | ||
1210977 | 1210977 | 2020-06-09 | Colombia | Valle del Cauca | 4677 | 223 | 1727 | 2727 | 3.8009 | -76.6413 | 2020-06-10 04:07:00 | Valle del Cauca, Colombia | ||
2864159 | 2864159 | 2020-06-10 | Colombia | Valle del Cauca | 4820 | 233 | 1745 | 2842 | 3.8009 | -76.6413 | 2020-06-11 03:33:41 | Valle del Cauca, Colombia | ||
1273719 | 1273719 | 2020-06-11 | Colombia | Valle del Cauca | 4978 | 239 | 1802 | 2937 | 3.8009 | -76.6413 | 2020-06-12 05:09:52 | Valle del Cauca, Colombia | ||
737749 | 737749 | 2020-06-12 | Colombia | Valle del Cauca | 5258 | 245 | 1891 | 3122 | 3.8009 | -76.6413 | 2020-06-13 03:33:14 | Valle del Cauca, Colombia | ||
3061429 | 3061429 | 2020-06-13 | Colombia | Valle del Cauca | 5443 | 250 | 2032 | 3161 | 3.8009 | -76.6413 | 2020-06-14 03:33:15 | Valle del Cauca, Colombia | ||
1837377 | 1837377 | 2020-06-14 | Colombia | Valle del Cauca | 5633 | 255 | 2072 | 3306 | 3.8009 | -76.6413 | 2020-06-15 03:33:14 | Valle del Cauca, Colombia | ||
287426 | 287426 | 2020-06-15 | Colombia | Valle del Cauca | 6077 | 264 | 2110 | 3703 | 3.8009 | -76.6413 | 2020-06-16 04:33:09 | Valle del Cauca, Colombia | ||
2386863 | 2386863 | 2020-06-16 | Colombia | Valle del Cauca | 6077 | 264 | 2110 | 3703 | 3.8009 | -76.6413 | 2020-06-17 04:33:21 | Valle del Cauca, Colombia | ||
1196100 | 1196100 | 2020-06-17 | Colombia | Valle del Cauca | 6289 | 274 | 2161 | 3854 | 3.8009 | -76.6413 | 2020-06-18 04:33:18 | Valle del Cauca, Colombia | ||
3682897 | 3682897 | 2020-06-18 | Colombia | Valle del Cauca | 6516 | 284 | 2325 | 3907 | 3.8009 | -76.6413 | 2020-06-19 04:33:17 | Valle del Cauca, Colombia | ||
1691748 | 1691748 | 2020-06-19 | Colombia | Valle del Cauca | 6789 | 293 | 2452 | 4044 | 3.8009 | -76.6413 | 2020-06-20 04:33:19 | Valle del Cauca, Colombia | ||
2438170 | 2438170 | 2020-06-20 | Colombia | Valle del Cauca | 7032 | 304 | 2636 | 4092 | 3.8009 | -76.6413 | 2020-06-21 04:33:19 | Valle del Cauca, Colombia | ||
3249577 | 3249577 | 2020-06-21 | Colombia | Valle del Cauca | 7525 | 328 | 3004 | 4193 | 3.8009 | -76.6413 | 2020-06-22 04:33:20 | Valle del Cauca, Colombia | ||
1510838 | 1510838 | 2020-06-22 | Colombia | Valle del Cauca | 7660 | 336 | 3156 | 4168 | 3.8009 | -76.6413 | 2020-06-23 04:33:22 | Valle del Cauca, Colombia | ||
1522644 | 1522644 | 2020-06-23 | Colombia | Valle del Cauca | 7914 | 345 | 3311 | 4258 | 3.8009 | -76.6413 | 2020-06-24 04:33:28 | Valle del Cauca, Colombia | ||
2700959 | 2700959 | 2020-06-24 | Colombia | Valle del Cauca | 7914 | 345 | 3311 | 4258 | 3.8009 | -76.6413 | 2020-06-25 05:26:54 | Valle del Cauca, Colombia | ||
2625319 | 2625319 | 2020-06-25 | Colombia | Valle del Cauca | 8342 | 355 | 3463 | 4524 | 3.8009 | -76.6413 | 2020-06-26 04:33:43 | Valle del Cauca, Colombia | ||
1136332 | 1136332 | 2020-06-26 | Colombia | Valle del Cauca | 8689 | 369 | 3649 | 4671 | 3.8009 | -76.6413 | 2020-06-27 04:33:35 | Valle del Cauca, Colombia | ||
2040051 | 2040051 | 2020-06-27 | Colombia | Valle del Cauca | 8938 | 384 | 3806 | 4748 | 3.8009 | -76.6413 | 2020-06-28 04:34:04 | Valle del Cauca, Colombia | ||
2306716 | 2306716 | 2020-06-28 | Colombia | Valle del Cauca | 9468 | 403 | 4286 | 4779 | 3.8009 | -76.6413 | 2020-06-29 04:33:44 | Valle del Cauca, Colombia | ||
2633153 | 2633153 | 2020-06-29 | Colombia | Valle del Cauca | 9468 | 403 | 4286 | 4779 | 3.8009 | -76.6413 | 2020-06-30 04:33:48 | Valle del Cauca, Colombia | ||
2974676 | 2974676 | 2020-06-30 | Colombia | Valle del Cauca | 9628 | 406 | 4391 | 4831 | 3.8009 | -76.6413 | 2020-07-01 04:33:52 | Valle del Cauca, Colombia | ||
303298 | 303298 | 2020-07-01 | Colombia | Valle del Cauca | 9974 | 412 | 4665 | 4897 | 3.8009 | -76.6413 | 2020-07-02 04:33:46 | Valle del Cauca, Colombia | ||
3045607 | 3045607 | 2020-07-02 | Colombia | Valle del Cauca | 10508 | 422 | 4771 | 5315 | 3.8009 | -76.6413 | 2020-07-03 04:33:54 | Valle del Cauca, Colombia | ||
2234812 | 2234812 | 2020-07-03 | Colombia | Valle del Cauca | 10904 | 442 | 4892 | 5570 | 3.8009 | -76.6413 | 2020-07-04 04:33:51 | Valle del Cauca, Colombia | ||
530151 | 530151 | 2020-07-04 | Colombia | Valle del Cauca | 11202 | 452 | 4996 | 5754 | 3.8009 | -76.6413 | 2020-07-05 04:33:46 | Valle del Cauca, Colombia | ||
415589 | 415589 | 2020-07-05 | Colombia | Valle del Cauca | 11677 | 463 | 5115 | 6099 | 3.8009 | -76.6413 | 2020-07-06 04:33:57 | Valle del Cauca, Colombia | ||
2685124 | 2685124 | 2020-07-06 | Colombia | Valle del Cauca | 11860 | 473 | 5262 | 6125 | 3.8009 | -76.6413 | 2020-07-07 04:34:00 | Valle del Cauca, Colombia | ||
887564 | 887564 | 2020-07-07 | Colombia | Valle del Cauca | 12101 | 485 | 5436 | 6180 | 3.8009 | -76.6413 | 2020-07-08 05:33:48 | Valle del Cauca, Colombia | ||
2222955 | 2222955 | 2020-07-08 | Colombia | Valle del Cauca | 12445 | 499 | 5566 | 6380 | 3.8009 | -76.6413 | 2020-07-09 04:34:23 | Valle del Cauca, Colombia | ||
1005740 | 1005740 | 2020-07-09 | Colombia | Valle del Cauca | 12846 | 524 | 5807 | 6515 | 3.8009 | -76.6413 | 2020-07-10 04:34:24 | Valle del Cauca, Colombia | ||
3237755 | 3237755 | 2020-07-10 | Colombia | Valle del Cauca | 13389 | 541 | 6083 | 6765 | 3.8009 | -76.6413 | 2020-07-11 04:34:26 | Valle del Cauca, Colombia | ||
3436257 | 3436257 | 2020-07-11 | Colombia | Valle del Cauca | 13953 | 559 | 6257 | 7137 | 3.8009 | -76.6413 | 2020-07-12 04:34:30 | Valle del Cauca, Colombia | ||
3737862 | 3737862 | 2020-07-12 | Colombia | Valle del Cauca | 14207 | 590 | 6482 | 7135 | 3.8009 | -76.6413 | 2020-07-13 04:43:04 | Valle del Cauca, Colombia | ||
3491599 | 3491599 | 2020-07-13 | Colombia | Valle del Cauca | 14422 | 600 | 6664 | 7158 | 3.8009 | -76.6413 | 2020-07-14 04:34:46 | Valle del Cauca, Colombia | ||
2158958 | 2158958 | 2020-07-14 | Colombia | Valle del Cauca | 14696 | 609 | 6898 | 7189 | 3.8009 | -76.6413 | 2020-07-15 04:34:39 | Valle del Cauca, Colombia | ||
2748314 | 2748314 | 2020-07-15 | Colombia | Valle del Cauca | 15132 | 625 | 7233 | 7274 | 3.8009 | -76.6413 | 2020-07-16 04:44:59 | Valle del Cauca, Colombia | ||
367646 | 367646 | 2020-07-16 | Colombia | Valle del Cauca | 15716 | 642 | 7476 | 7598 | 3.8009 | -76.6413 | 2020-07-17 04:34:50 | Valle del Cauca, Colombia | ||
2708837 | 2708837 | 2020-07-17 | Colombia | Valle del Cauca | 16592 | 635 | 8214 | 7743 | 3.8009 | -76.6413 | 2020-07-18 04:34:45 | Valle del Cauca, Colombia | ||
3205534 | 3205534 | 2020-07-18 | Colombia | Valle del Cauca | 17236 | 658 | 8506 | 8072 | 3.8009 | -76.6413 | 2020-07-19 04:34:58 | Valle del Cauca, Colombia | ||
122145 | 122145 | 2020-07-19 | Colombia | Valle del Cauca | 17457 | 668 | 8923 | 7866 | 3.8009 | -76.6413 | 2020-07-20 05:34:40 | Valle del Cauca, Colombia | ||
327240 | 327240 | 2020-07-20 | Colombia | Valle del Cauca | 17914 | 675 | 9203 | 8036 | 3.8009 | -76.6413 | 2020-07-21 04:38:46 | Valle del Cauca, Colombia | ||
1707749 | 1707749 | 2020-07-21 | Colombia | Valle del Cauca | 18441 | 698 | 9520 | 8223 | 3.8009 | -76.6413 | 2020-07-22 04:34:42 | Valle del Cauca, Colombia | ||
845010 | 845010 | 2020-07-22 | Colombia | Valle del Cauca | 19164 | 722 | 9739 | 8703 | 3.8009 | -76.6413 | 2020-07-23 05:15:04 | Valle del Cauca, Colombia | ||
62193 | 62193 | 2020-07-23 | Colombia | Valle del Cauca | 19921 | 755 | 10280 | 8886 | 3.8009 | -76.6413 | 2020-07-24 05:30:40 | Valle del Cauca, Colombia | ||
2563990 | 2563990 | 2020-07-24 | Colombia | Valle del Cauca | 20416 | 789 | 10859 | 8768 | 3.8009 | -76.6413 | 2020-07-25 04:47:39 | Valle del Cauca, Colombia | ||
1503019 | 1503019 | 2020-07-25 | Colombia | Valle del Cauca | 20875 | 812 | 11243 | 8820 | 3.8009 | -76.6413 | 2020-07-26 04:35:00 | Valle del Cauca, Colombia | ||
442776 | 442776 | 2020-07-26 | Colombia | Valle del Cauca | 20875 | 812 | 11243 | 8820 | 3.8009 | -76.6413 | 2020-07-27 04:35:02 | Valle del Cauca, Colombia | ||
177463 | 177463 | 2020-07-27 | Colombia | Valle del Cauca | 22010 | 855 | 12058 | 9097 | 3.8009 | -76.6413 | 2020-07-28 04:58:43 | Valle del Cauca, Colombia | ||
3185413 | 3185413 | 2020-07-28 | Colombia | Valle del Cauca | 22731 | 888 | 12568 | 9275 | 3.8009 | -76.6413 | 2020-07-29 04:35:11 | Valle del Cauca, Colombia | ||
2958796 | 2958796 | 2020-07-29 | Colombia | Valle del Cauca | 23114 | 918 | 13019 | 9177 | 3.8009 | -76.6413 | 2020-07-30 04:35:05 | Valle del Cauca, Colombia | ||
1928628 | 1928628 | 2020-07-30 | Colombia | Valle del Cauca | 23993 | 941 | 13524 | 9528 | 3.8009 | -76.6413 | 2020-07-31 04:35:18 | Valle del Cauca, Colombia | ||
3264922 | 3264922 | 2020-07-31 | Colombia | Valle del Cauca | 24660 | 963 | 13970 | 9727 | 3.8009 | -76.6413 | 2020-08-01 04:36:27 | Valle del Cauca, Colombia | ||
753757 | 753757 | 2020-08-01 | Colombia | Valle del Cauca | 25628 | 980 | 14411 | 10237 | 3.8009 | -76.6413 | 2020-08-02 04:34:47 | Valle del Cauca, Colombia | ||
2808189 | 2808189 | 2020-08-02 | Colombia | Valle del Cauca | 26270 | 1020 | 14812 | 10438 | 3.8009 | -76.6413 | 2020-08-03 04:34:35 | Valle del Cauca, Colombia | ||
2740437 | 2740437 | 2020-08-03 | Colombia | Valle del Cauca | 27120 | 1058 | 15280 | 10782 | 3.8009 | -76.6413 | 2020-08-04 04:41:59 | Valle del Cauca, Colombia | ||
98554 | 98554 | 2020-08-04 | Colombia | Valle del Cauca | 27592 | 1081 | 15796 | 10715 | 3.8009 | -76.6413 | 2020-08-05 04:34:43 | Valle del Cauca, Colombia | ||
3793318 | 3793318 | 2020-08-05 | Colombia | Valle del Cauca | 28611 | 1106 | 16527 | 10978 | 3.8009 | -76.6413 | 2020-08-06 04:35:02 | Valle del Cauca, Colombia | ||
3612488 | 3612488 | 2020-08-06 | Colombia | Valle del Cauca | 29754 | 1141 | 17085 | 11528 | 3.8009 | -76.6413 | 2020-08-07 04:35:11 | Valle del Cauca, Colombia | ||
458803 | 458803 | 2020-08-07 | Colombia | Valle del Cauca | 30371 | 1177 | 17553 | 11641 | 3.8009 | -76.6413 | 2020-08-08 04:34:53 | Valle del Cauca, Colombia | ||
371619 | 371619 | 2020-08-08 | Colombia | Valle del Cauca | 30858 | 1199 | 18081 | 11578 | 3.8009 | -76.6413 | 2020-08-09 04:34:54 | Valle del Cauca, Colombia | ||
3923451 | 3923451 | 2020-08-09 | Colombia | Valle del Cauca | 31641 | 1226 | 18685 | 11730 | 3.8009 | -76.6413 | 2020-08-10 04:34:55 | Valle del Cauca, Colombia | ||
1920642 | 1920642 | 2020-08-10 | Colombia | Valle del Cauca | 31951 | 1242 | 19450 | 11259 | 3.8009 | -76.6413 | 2020-08-11 04:35:08 | Valle del Cauca, Colombia | ||
662163 | 662163 | 2020-08-11 | Colombia | Valle del Cauca | 32759 | 1268 | 19833 | 11658 | 3.8009 | -76.6413 | 2020-08-12 04:27:29 | Valle del Cauca, Colombia | ||
3531314 | 3531314 | 2020-08-12 | Colombia | Valle del Cauca | 34585 | 1298 | 20248 | 13039 | 3.8009 | -76.6413 | 2020-08-13 04:29:15 | Valle del Cauca, Colombia | ||
582695 | 582695 | 2020-08-13 | Colombia | Valle del Cauca | 35435 | 1321 | 20889 | 13225 | 3.8009 | -76.6413 | 2020-08-14 04:51:19 | Valle del Cauca, Colombia | ||
1612111 | 1612111 | 2020-08-14 | Colombia | Valle del Cauca | 36171 | 1355 | 21664 | 13152 | 3.8009 | -76.6413 | 2020-08-15 04:27:31 | Valle del Cauca, Colombia | ||
145836 | 145836 | 2020-08-15 | Colombia | Valle del Cauca | 36847 | 1374 | 23906 | 11567 | 3.8009 | -76.6413 | 2020-08-16 04:27:42 | Valle del Cauca, Colombia | ||
1555834 | 1555834 | 2020-08-16 | Colombia | Valle del Cauca | 37515 | 1401 | 24926 | 11188 | 3.8009 | -76.6413 | 2020-08-17 04:27:20 | Valle del Cauca, Colombia | ||
837476 | 837476 | 2020-08-17 | Colombia | Valle del Cauca | 37938 | 1420 | 26155 | 10363 | 3.8009 | -76.6413 | 2020-08-18 04:27:56 | Valle del Cauca, Colombia | ||
3177872 | 3177872 | 2020-08-18 | Colombia | Valle del Cauca | 39020 | 1445 | 26686 | 10889 | 3.8009 | -76.6413 | 2020-08-19 04:27:00 | Valle del Cauca, Colombia | ||
206118 | 206118 | 2020-08-19 | Colombia | Valle del Cauca | 40073 | 1465 | 27567 | 11041 | 3.8009 | -76.6413 | 2020-08-20 04:27:43 | Valle del Cauca, Colombia | ||
3484169 | 3484169 | 2020-08-20 | Colombia | Valle del Cauca | 41259 | 1479 | 28260 | 11520 | 3.8009 | -76.6413 | 2020-08-21 04:27:41 | Valle del Cauca, Colombia | ||
1479420 | 1479420 | 2020-08-21 | Colombia | Valle del Cauca | 41887 | 1517 | 28887 | 11483 | 3.8009 | -76.6413 | 2020-08-22 04:27:49 | Valle del Cauca, Colombia | ||
2299313 | 2299313 | 2020-08-22 | Colombia | Valle del Cauca | 41887 | 1517 | 28887 | 11483 | 3.8009 | -76.6413 | 2020-08-23 04:27:48 | Valle del Cauca, Colombia | ||
2215531 | 2215531 | 2020-08-23 | Colombia | Valle del Cauca | 42998 | 1578 | 30361 | 11059 | 3.8009 | -76.6413 | 2020-08-24 04:27:56 | Valle del Cauca, Colombia | ||
2991136 | 2991136 | 2020-08-24 | Colombia | Valle del Cauca | 43598 | 1597 | 31195 | 10806 | 3.8009 | -76.6413 | 2020-08-25 04:28:02 | Valle del Cauca, Colombia | ||
3562432 | 3562432 | 2020-08-25 | Colombia | Valle del Cauca | 44394 | 1622 | 31960 | 10812 | 3.8009 | -76.6413 | 2020-08-26 04:28:11 | Valle del Cauca, Colombia | ||
1996508 | 1996508 | 2020-08-26 | Colombia | Valle del Cauca | 44694 | 1640 | 32756 | 10298 | 3.8009 | -76.6413 | 2020-08-27 04:28:15 | Valle del Cauca, Colombia | ||
2510048 | 2510048 | 2020-08-27 | Colombia | Valle del Cauca | 45180 | 1659 | 33615 | 9906 | 3.8009 | -76.6413 | 2020-08-28 04:28:11 | Valle del Cauca, Colombia | ||
1523047 | 1523047 | 2020-08-28 | Colombia | Valle del Cauca | 45667 | 1679 | 34253 | 9735 | 3.8009 | -76.6413 | 2020-08-29 04:28:19 | Valle del Cauca, Colombia | ||
609552 | 609552 | 2020-08-29 | Colombia | Valle del Cauca | 46086 | 1698 | 35126 | 9262 | 3.8009 | -76.6413 | 2020-08-30 04:28:22 | Valle del Cauca, Colombia | ||
3931890 | 3931890 | 2020-08-30 | Colombia | Valle del Cauca | 46549 | 1731 | 35875 | 8943 | 3.8009 | -76.6413 | 2020-08-31 04:28:27 | Valle del Cauca, Colombia | ||
193931 | 193931 | 2020-08-31 | Colombia | Valle del Cauca | 46944 | 1756 | 36479 | 8709 | 3.8009 | -76.6413 | 2020-09-01 04:28:31 | Valle del Cauca, Colombia | ||
2059746 | 2059746 | 2020-09-01 | Colombia | Valle del Cauca | 47658 | 1781 | 37194 | 8683 | 3.8009 | -76.6413 | 2020-09-02 04:28:25 | Valle del Cauca, Colombia | ||
1105417 | 1105417 | 2020-09-02 | Colombia | Valle del Cauca | 48127 | 1805 | 38093 | 8229 | 3.8009 | -76.6413 | 2020-09-03 04:28:22 | Valle del Cauca, Colombia | ||
1354180 | 1354180 | 2020-09-03 | Colombia | Valle del Cauca | 48471 | 1829 | 38776 | 7866 | 3.8009 | -76.6413 | 2020-09-04 04:28:26 | Valle del Cauca, Colombia | ||
2661640 | 2661640 | 2020-09-04 | Colombia | Valle del Cauca | 48471 | 1829 | 38776 | 7866 | 3.8009 | -76.6413 | 2020-09-05 04:28:19 | 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]);