johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
162 rows where country_or_region = "US", deaths = 123 and province_or_state = "Louisiana" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
711984 | 711984 | 2022-11-01 | US | Louisiana | Sabine | 22085 | 7695 | 123 | 0 | 31.56388699 | -93.55433981 | 2022-11-02 04:22:09 | Sabine, Louisiana, US | |
3286433 | 3286433 | 2022-10-31 | US | Louisiana | Sabine | 22085 | 7695 | 123 | 0 | 31.56388699 | -93.55433981 | 2022-11-01 04:22:36 | Sabine, Louisiana, US | |
321466 | 321466 | 2022-10-30 | US | Louisiana | Sabine | 22085 | 7695 | 123 | 0 | 31.56388699 | -93.55433981 | 2022-10-31 04:21:36 | Sabine, Louisiana, US | |
913742 | 913742 | 2022-10-29 | US | Louisiana | Sabine | 22085 | 7695 | 123 | 0 | 31.56388699 | -93.55433981 | 2022-10-30 04:22:14 | Sabine, Louisiana, US | |
1368011 | 1368011 | 2022-10-28 | US | Louisiana | Sabine | 22085 | 7695 | 123 | 0 | 31.56388699 | -93.55433981 | 2022-10-29 04:21:13 | Sabine, Louisiana, US | |
3039866 | 3039866 | 2022-10-27 | US | Louisiana | Sabine | 22085 | 7695 | 123 | 0 | 31.56388699 | -93.55433981 | 2022-10-28 04:22:31 | Sabine, Louisiana, US | |
540286 | 540286 | 2022-10-26 | US | Louisiana | Sabine | 22085 | 7695 | 123 | 0 | 31.56388699 | -93.55433981 | 2022-10-27 04:22:01 | Sabine, Louisiana, US | |
3913563 | 3913563 | 2022-02-20 | US | Louisiana | Union | 22111 | 6836 | 123 | 0 | 32.83121059 | -92.3749373 | 2022-02-21 04:21:05 | Union, Louisiana, US | |
3877121 | 3877121 | 2022-02-19 | US | Louisiana | Union | 22111 | 6836 | 123 | 0 | 32.83121059 | -92.3749373 | 2022-02-20 04:21:00 | Union, Louisiana, US | |
3857377 | 3857377 | 2022-02-18 | US | Louisiana | Union | 22111 | 6836 | 123 | 0 | 32.83121059 | -92.3749373 | 2022-02-19 04:21:11 | Union, Louisiana, US | |
2014194 | 2014194 | 2022-02-06 | US | Louisiana | Allen | 22003 | 7666 | 123 | 0 | 30.65385745 | -92.82442028 | 2022-02-07 04:21:05 | Allen, Louisiana, US | |
1295523 | 1295523 | 2022-02-05 | US | Louisiana | Allen | 22003 | 7666 | 123 | 0 | 30.65385745 | -92.82442028 | 2022-02-06 04:21:00 | Allen, Louisiana, US | |
2328851 | 2328851 | 2022-02-04 | US | Louisiana | Allen | 22003 | 7666 | 123 | 0 | 30.65385745 | -92.82442028 | 2022-02-05 04:21:05 | Allen, Louisiana, US | |
2475442 | 2475442 | 2022-02-03 | US | Louisiana | Allen | 22003 | 7604 | 123 | 0 | 30.65385745 | -92.82442028 | 2022-02-04 04:21:10 | Allen, Louisiana, US | |
460867 | 460867 | 2022-02-02 | US | Louisiana | Allen | 22003 | 7469 | 123 | 0 | 30.65385745 | -92.82442028 | 2022-02-03 04:21:21 | Allen, Louisiana, US | |
980436 | 980436 | 2022-02-01 | US | Louisiana | Allen | 22003 | 7446 | 123 | 0 | 30.65385745 | -92.82442028 | 2022-02-02 04:21:09 | Allen, Louisiana, US | |
1780903 | 1780903 | 2022-01-27 | US | Louisiana | Lincoln | 22061 | 11096 | 123 | 0 | 32.6003154 | -92.66597409999999 | 2022-01-28 04:21:09 | Lincoln, Louisiana, US | |
1319731 | 1319731 | 2022-01-26 | US | Louisiana | Lincoln | 22061 | 10997 | 123 | 0 | 32.6003154 | -92.66597409999999 | 2022-01-27 04:21:19 | Lincoln, Louisiana, US | |
2053399 | 2053399 | 2022-01-25 | US | Louisiana | Lincoln | 22061 | 10279 | 123 | 0 | 32.6003154 | -92.66597409999999 | 2022-01-26 04:21:07 | Lincoln, Louisiana, US | |
1229115 | 1229115 | 2022-01-24 | US | Louisiana | De Soto | 22031 | 6487 | 123 | 0 | 32.05457447 | -93.74130302 | 2022-01-25 04:21:05 | De Soto, Louisiana, US | |
5836 | 5836 | 2021-10-28 | US | Louisiana | Beauregard | 22011 | 6084 | 123 | 0 | 30.64836518 | -93.34173616 | 2021-10-29 04:22:03 | Beauregard, Louisiana, US | |
536226 | 536226 | 2021-10-27 | US | Louisiana | Beauregard | 22011 | 6079 | 123 | 0 | 30.64836518 | -93.34173616 | 2021-10-28 04:22:08 | Beauregard, Louisiana, US | |
3493663 | 3493663 | 2021-10-26 | US | Louisiana | Beauregard | 22011 | 6073 | 123 | 0 | 30.64836518 | -93.34173616 | 2021-10-27 04:22:32 | Beauregard, Louisiana, US | |
3795385 | 3795385 | 2021-10-25 | US | Louisiana | Beauregard | 22011 | 6072 | 123 | 0 | 30.64836518 | -93.34173616 | 2021-10-26 04:22:09 | Beauregard, Louisiana, US | |
1493113 | 1493113 | 2021-10-12 | US | Louisiana | Jefferson Davis | 22053 | 4663 | 123 | 0 | 30.26896765 | -92.81210004 | 2021-10-13 04:20:51 | Jefferson Davis, Louisiana, US | |
3008865 | 3008865 | 2021-10-11 | US | Louisiana | St. Charles | 22089 | 8784 | 123 | 0 | 29.90709658 | -90.35555967 | 2021-10-12 04:21:09 | St. Charles, Louisiana, US | |
424881 | 424881 | 2021-10-10 | US | Louisiana | St. Charles | 22089 | 8754 | 123 | 0 | 29.90709658 | -90.35555967 | 2021-10-11 04:21:31 | St. Charles, Louisiana, US | |
2877738 | 2877738 | 2021-10-09 | US | Louisiana | St. Charles | 22089 | 8754 | 123 | 0 | 29.90709658 | -90.35555967 | 2021-10-10 04:21:38 | St. Charles, Louisiana, US | |
2960904 | 2960904 | 2021-10-08 | US | Louisiana | St. Charles | 22089 | 8754 | 123 | 0 | 29.90709658 | -90.35555967 | 2021-10-09 04:21:34 | St. Charles, Louisiana, US | |
3012837 | 3012837 | 2021-09-22 | US | Louisiana | Evangeline | 22039 | 5561 | 123 | 0 | 30.72985248 | -92.39915924 | 2021-09-23 04:21:43 | Evangeline, Louisiana, US | |
3758990 | 3758990 | 2021-09-21 | US | Louisiana | Natchitoches | 22069 | 6232 | 123 | 0 | 31.72321584 | -93.09816516 | 2021-09-22 04:21:45 | Natchitoches, Louisiana, US | |
2069446 | 2069446 | 2021-08-31 | US | Louisiana | Webster | 22119 | 5648 | 123 | 0 | 32.70847669 | -93.33121835 | 2021-09-01 04:21:38 | Webster, Louisiana, US | |
1776900 | 1776900 | 2021-08-30 | US | Louisiana | Webster | 22119 | 5648 | 123 | 0 | 32.70847669 | -93.33121835 | 2021-08-31 04:21:46 | Webster, Louisiana, US | |
3893474 | 3893474 | 2021-08-29 | US | Louisiana | Webster | 22119 | 5648 | 123 | 0 | 32.70847669 | -93.33121835 | 2021-08-30 04:21:23 | Webster, Louisiana, US | |
2794577 | 2794577 | 2021-08-28 | US | Louisiana | Webster | 22119 | 5648 | 123 | 0 | 32.70847669 | -93.33121835 | 2021-08-29 04:21:14 | Webster, Louisiana, US | |
2924736 | 2924736 | 2021-08-27 | US | Louisiana | Webster | 22119 | 5648 | 123 | 0 | 32.70847669 | -93.33121835 | 2021-08-28 04:21:28 | Webster, Louisiana, US | |
1597750 | 1597750 | 2021-08-26 | US | Louisiana | Webster | 22119 | 5632 | 123 | 0 | 32.70847669 | -93.33121835 | 2021-08-27 04:21:37 | Webster, Louisiana, US | |
33959 | 33959 | 2021-08-25 | US | Louisiana | Webster | 22119 | 5577 | 123 | 0 | 32.70847669 | -93.33121835 | 2021-08-26 04:21:28 | Webster, Louisiana, US | |
3106998 | 3106998 | 2021-08-24 | US | Louisiana | Webster | 22119 | 5535 | 123 | 0 | 32.70847669 | -93.33121835 | 2021-08-25 04:21:41 | Webster, Louisiana, US | |
246810 | 246810 | 2021-08-17 | US | Louisiana | Vernon | 22115 | 4351 | 123 | 0 | 31.10884837 | -93.18153838 | 2021-08-18 04:21:35 | Vernon, Louisiana, US | |
651498 | 651498 | 2021-08-09 | US | Louisiana | St. Martin | 22099 | 6791 | 123 | 0 | 30.13112107 | -91.61403569 | 2021-08-10 04:21:27 | St. Martin, Louisiana, US | |
591160 | 591160 | 2021-08-08 | US | Louisiana | St. Martin | 22099 | 6583 | 123 | 0 | 30.13112107 | -91.61403569 | 2021-08-09 04:21:24 | St. Martin, Louisiana, US | |
2205172 | 2205172 | 2021-08-07 | US | Louisiana | St. Martin | 22099 | 6583 | 123 | 0 | 30.13112107 | -91.61403569 | 2021-08-08 04:21:33 | St. Martin, Louisiana, US | |
1119122 | 1119122 | 2021-08-06 | US | Louisiana | St. Martin | 22099 | 6583 | 123 | 0 | 30.13112107 | -91.61403569 | 2021-08-07 04:21:30 | St. Martin, Louisiana, US | |
1958059 | 1958059 | 2021-08-05 | US | Louisiana | St. Martin | 22099 | 6512 | 123 | 0 | 30.13112107 | -91.61403569 | 2021-08-06 04:21:18 | St. Martin, Louisiana, US | |
3469709 | 3469709 | 2021-08-03 | US | Louisiana | St. Martin | 22099 | 6464 | 123 | 0 | 30.13112107 | -91.61403569 | 2021-08-04 04:21:25 | St. Martin, Louisiana, US | |
564452 | 564452 | 2021-06-22 | US | Louisiana | Avoyelles | 22009 | 4340 | 123 | 0 | 31.07796211 | -92.00079449 | 2021-06-23 04:21:46 | Avoyelles, Louisiana, US | |
3360154 | 3360154 | 2021-06-21 | US | Louisiana | Avoyelles | 22009 | 4334 | 123 | 0 | 31.07796211 | -92.00079449 | 2021-06-22 04:21:34 | Avoyelles, Louisiana, US | |
2885853 | 2885853 | 2021-06-20 | US | Louisiana | Avoyelles | 22009 | 4334 | 123 | 0 | 31.07796211 | -92.00079449 | 2021-06-21 04:21:41 | Avoyelles, Louisiana, US | |
108936 | 108936 | 2021-06-19 | US | Louisiana | Avoyelles | 22009 | 4334 | 123 | 0 | 31.07796211 | -92.00079449 | 2021-06-20 04:21:48 | Avoyelles, Louisiana, US | |
1127079 | 1127079 | 2021-06-18 | US | Louisiana | Avoyelles | 22009 | 4334 | 123 | 0 | 31.07796211 | -92.00079449 | 2021-06-19 04:22:33 | Avoyelles, Louisiana, US | |
2912657 | 2912657 | 2021-06-17 | US | Louisiana | Avoyelles | 22009 | 4334 | 123 | 0 | 31.07796211 | -92.00079449 | 2021-06-18 04:22:16 | Avoyelles, Louisiana, US | |
3031773 | 3031773 | 2021-06-16 | US | Louisiana | Avoyelles | 22009 | 4330 | 123 | 0 | 31.07796211 | -92.00079449 | 2021-06-17 04:22:36 | Avoyelles, Louisiana, US | |
2340879 | 2340879 | 2021-06-15 | US | Louisiana | Avoyelles | 22009 | 4333 | 123 | 0 | 31.07796211 | -92.00079449 | 2021-06-16 04:22:32 | Avoyelles, Louisiana, US | |
1565575 | 1565575 | 2021-06-14 | US | Louisiana | Avoyelles | 22009 | 4330 | 123 | 0 | 31.07796211 | -92.00079449 | 2021-06-15 04:22:22 | Avoyelles, Louisiana, US | |
3382858 | 3382858 | 2021-06-13 | US | Louisiana | Avoyelles | 22009 | 4326 | 123 | 0 | 31.07796211 | -92.00079449 | 2021-06-14 04:22:46 | Avoyelles, Louisiana, US | |
1737992 | 1737992 | 2021-06-12 | US | Louisiana | Avoyelles | 22009 | 4326 | 123 | 0 | 31.07796211 | -92.00079449 | 2021-06-13 04:22:44 | Avoyelles, Louisiana, US | |
3972033 | 3972033 | 2021-06-11 | US | Louisiana | Avoyelles | 22009 | 4326 | 123 | 0 | 31.07796211 | -92.00079449 | 2021-06-12 04:22:22 | Avoyelles, Louisiana, US | |
2718455 | 2718455 | 2021-06-10 | US | Louisiana | Avoyelles | 22009 | 4327 | 123 | 0 | 31.07796211 | -92.00079449 | 2021-06-11 04:23:20 | Avoyelles, Louisiana, US | |
524340 | 524340 | 2021-06-09 | US | Louisiana | Avoyelles | 22009 | 4323 | 123 | 0 | 31.07796211 | -92.00079449 | 2021-06-10 04:23:17 | Avoyelles, Louisiana, US | |
3473780 | 3473780 | 2021-06-08 | US | Louisiana | Avoyelles | 22009 | 4321 | 123 | 0 | 31.07796211 | -92.00079449 | 2021-06-09 04:23:31 | Avoyelles, Louisiana, US | |
3147064 | 3147064 | 2021-06-07 | US | Louisiana | Avoyelles | 22009 | 4317 | 123 | 0 | 31.07796211 | -92.00079449 | 2021-06-08 04:22:35 | Avoyelles, Louisiana, US | |
827066 | 827066 | 2021-06-06 | US | Louisiana | Avoyelles | 22009 | 4311 | 123 | 0 | 31.07796211 | -92.00079449 | 2021-06-07 04:22:51 | Avoyelles, Louisiana, US | |
2587471 | 2587471 | 2021-06-05 | US | Louisiana | Avoyelles | 22009 | 4311 | 123 | 0 | 31.07796211 | -92.00079449 | 2021-06-06 04:24:03 | Avoyelles, Louisiana, US | |
2316785 | 2316785 | 2021-06-04 | US | Louisiana | Avoyelles | 22009 | 4311 | 123 | 0 | 31.07796211 | -92.00079449 | 2021-06-05 04:23:03 | Avoyelles, Louisiana, US | |
1450070 | 1450070 | 2021-06-03 | US | Louisiana | Avoyelles | 22009 | 4306 | 123 | 0 | 31.07796211 | -92.00079449 | 2021-06-04 04:23:37 | Avoyelles, Louisiana, US | |
1709794 | 1709794 | 2021-06-02 | US | Louisiana | Avoyelles | 22009 | 4302 | 123 | 0 | 31.07796211 | -92.00079449 | 2021-06-03 04:23:32 | Avoyelles, Louisiana, US | |
2105612 | 2105612 | 2021-06-01 | US | Louisiana | Avoyelles | 22009 | 4298 | 123 | 0 | 31.07796211 | -92.00079449 | 2021-06-02 04:24:34 | Avoyelles, Louisiana, US | |
1190228 | 1190228 | 2021-05-31 | US | Louisiana | Avoyelles | 22009 | 4283 | 123 | 0 | 31.07796211 | -92.00079449 | 2021-06-01 04:23:09 | Avoyelles, Louisiana, US | |
3090905 | 3090905 | 2021-05-30 | US | Louisiana | Avoyelles | 22009 | 4283 | 123 | 0 | 31.07796211 | -92.00079449 | 2021-05-31 03:08:59 | Avoyelles, Louisiana, US | |
52274 | 52274 | 2021-05-29 | US | Louisiana | Avoyelles | 22009 | 4283 | 123 | 0 | 31.07796211 | -92.00079449 | 2021-05-30 04:20:55 | Avoyelles, Louisiana, US | |
21853 | 21853 | 2021-05-28 | US | Louisiana | Avoyelles | 22009 | 4283 | 123 | 0 | 31.07796211 | -92.00079449 | 2021-05-29 04:20:41 | Avoyelles, Louisiana, US | |
1808228 | 1808228 | 2021-05-27 | US | Louisiana | Avoyelles | 22009 | 4282 | 123 | 0 | 31.07796211 | -92.00079449 | 2021-05-28 04:20:36 | Avoyelles, Louisiana, US | |
1311651 | 1311651 | 2021-05-26 | US | Louisiana | Avoyelles | 22009 | 4272 | 123 | 0 | 31.07796211 | -92.00079449 | 2021-05-27 04:20:59 | Avoyelles, Louisiana, US | |
84577 | 84577 | 2021-05-25 | US | Louisiana | Avoyelles | 22009 | 4266 | 123 | 0 | 31.07796211 | -92.00079449 | 2021-05-26 04:20:35 | Avoyelles, Louisiana, US | |
1414539 | 1414539 | 2021-05-24 | US | Louisiana | Avoyelles | 22009 | 4253 | 123 | 0 | 31.07796211 | -92.00079449 | 2021-05-25 04:21:08 | Avoyelles, Louisiana, US | |
1772825 | 1772825 | 2021-05-23 | US | Louisiana | Avoyelles | 22009 | 4246 | 123 | 0 | 31.07796211 | -92.00079449 | 2021-05-24 04:20:53 | Avoyelles, Louisiana, US | |
727980 | 727980 | 2021-05-22 | US | Louisiana | Avoyelles | 22009 | 4246 | 123 | 0 | 31.07796211 | -92.00079449 | 2021-05-23 04:20:51 | Avoyelles, Louisiana, US | |
1953995 | 1953995 | 2021-05-21 | US | Louisiana | Avoyelles | 22009 | 4246 | 123 | 0 | 31.07796211 | -92.00079449 | 2021-05-22 04:20:45 | Avoyelles, Louisiana, US | |
1914694 | 1914694 | 2021-05-20 | US | Louisiana | Avoyelles | 22009 | 4246 | 123 | 0 | 31.07796211 | -92.00079449 | 2021-05-21 04:20:43 | Avoyelles, Louisiana, US | |
2257215 | 2257215 | 2021-05-19 | US | Louisiana | Avoyelles | 22009 | 4243 | 123 | 0 | 31.07796211 | -92.00079449 | 2021-05-20 04:21:05 | Avoyelles, Louisiana, US | |
2392253 | 2392253 | 2021-05-18 | US | Louisiana | Avoyelles | 22009 | 4240 | 123 | 0 | 31.07796211 | -92.00079449 | 2021-05-19 04:20:42 | Avoyelles, Louisiana, US | |
3576078 | 3576078 | 2021-05-17 | US | Louisiana | Avoyelles | 22009 | 4233 | 123 | 0 | 31.07796211 | -92.00079449 | 2021-05-18 04:20:33 | Avoyelles, Louisiana, US | |
2940808 | 2940808 | 2021-05-16 | US | Louisiana | Avoyelles | 22009 | 4226 | 123 | 0 | 31.07796211 | -92.00079449 | 2021-05-17 04:20:34 | Avoyelles, Louisiana, US | |
1874438 | 1874438 | 2021-05-15 | US | Louisiana | Avoyelles | 22009 | 4226 | 123 | 0 | 31.07796211 | -92.00079449 | 2021-05-16 04:20:49 | Avoyelles, Louisiana, US | |
1083407 | 1083407 | 2021-05-14 | US | Louisiana | Avoyelles | 22009 | 4226 | 123 | 0 | 31.07796211 | -92.00079449 | 2021-05-15 04:20:58 | Avoyelles, Louisiana, US | |
3055673 | 3055673 | 2021-05-13 | US | Louisiana | Avoyelles | 22009 | 4222 | 123 | 0 | 31.07796211 | -92.00079449 | 2021-05-14 04:20:41 | Avoyelles, Louisiana, US | |
2006143 | 2006143 | 2021-05-12 | US | Louisiana | Avoyelles | 22009 | 4227 | 123 | 0 | 31.07796211 | -92.00079449 | 2021-05-13 04:20:51 | Avoyelles, Louisiana, US | |
3955974 | 3955974 | 2021-05-11 | US | Louisiana | Avoyelles | 22009 | 4215 | 123 | 0 | 31.07796211 | -92.00079449 | 2021-05-12 04:21:29 | Avoyelles, Louisiana, US | |
2822253 | 2822253 | 2021-05-10 | US | Louisiana | Avoyelles | 22009 | 4213 | 123 | 0 | 31.07796211 | -92.00079449 | 2021-05-11 04:20:41 | Avoyelles, Louisiana, US | |
1426585 | 1426585 | 2021-05-09 | US | Louisiana | Avoyelles | 22009 | 4208 | 123 | 0 | 31.07796211 | -92.00079449 | 2021-05-10 04:20:38 | Avoyelles, Louisiana, US | |
1553453 | 1553453 | 2021-05-08 | US | Louisiana | Avoyelles | 22009 | 4208 | 123 | 0 | 31.07796211 | -92.00079449 | 2021-05-09 04:20:35 | Avoyelles, Louisiana, US | |
2503511 | 2503511 | 2021-05-07 | US | Louisiana | Avoyelles | 22009 | 4208 | 123 | 0 | 31.07796211 | -92.00079449 | 2021-05-08 04:21:04 | Avoyelles, Louisiana, US | |
3114967 | 3114967 | 2021-05-06 | US | Louisiana | Avoyelles | 22009 | 4196 | 123 | 0 | 31.07796211 | -92.00079449 | 2021-05-07 04:20:40 | Avoyelles, Louisiana, US | |
647434 | 647434 | 2021-05-05 | US | Louisiana | Avoyelles | 22009 | 4197 | 123 | 0 | 31.07796211 | -92.00079449 | 2021-05-06 04:20:38 | Avoyelles, Louisiana, US | |
3677134 | 3677134 | 2021-05-04 | US | Louisiana | Avoyelles | 22009 | 4190 | 123 | 0 | 31.07796211 | -92.00079449 | 2021-05-05 04:20:43 | Avoyelles, Louisiana, US | |
2762401 | 2762401 | 2021-05-03 | US | Louisiana | Avoyelles | 22009 | 4183 | 123 | 0 | 31.07796211 | -92.00079449 | 2021-05-04 04:20:34 | Avoyelles, Louisiana, US | |
2452254 | 2452254 | 2021-05-02 | US | Louisiana | Avoyelles | 22009 | 4178 | 123 | 0 | 31.07796211 | -92.00079449 | 2021-05-03 04:20:39 | Avoyelles, Louisiana, US | |
2826267 | 2826267 | 2021-05-01 | US | Louisiana | Avoyelles | 22009 | 4178 | 123 | 0 | 31.07796211 | -92.00079449 | 2021-05-02 04:20:48 | Avoyelles, Louisiana, US | |
381675 | 381675 | 2021-04-30 | US | Louisiana | Avoyelles | 22009 | 4178 | 123 | 0 | 31.07796211 | -92.00079449 | 2021-05-01 04:20:47 | Avoyelles, Louisiana, US |
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]);