johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
66,723 rows where province_or_state = "Louisiana" sorted by latitude
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
808659 | 808659 | 2020-03-27 | US | Louisiana | Unassigned | 16 | 1 | 0 | 15 | 0.0 | 0.0 | 2020-03-27 22:14:55 | Unassigned, Louisiana, US | |
918758 | 918758 | 2020-03-26 | US | Louisiana | Unassigned | 13 | 1 | 0 | 12 | 0.0 | 0.0 | 2020-03-26 23:48:35 | Unassigned, Louisiana, US | |
1132159 | 1132159 | 2020-03-25 | US | Louisiana | Unassigned | 11 | 1 | 0 | 10 | 0.0 | 0.0 | 2020-03-25 23:33:19 | Unassigned, Louisiana, US | |
1478668 | 1478668 | 2020-03-24 | US | Louisiana | Unassigned | 12 | 1 | 0 | 11 | 0.0 | 0.0 | 2020-03-24 23:37:31 | Unassigned, Louisiana, US | |
1872031 | 1872031 | 2020-03-30 | US | Louisiana | Unassigned | 14 | 0 | 0 | 14 | 0.0 | 0.0 | 3/30/20 22:52 | Unassigned, Louisiana, US | |
2146723 | 2146723 | 2020-03-23 | US | Louisiana | Unassigned | 11 | 0 | 0 | 11 | 0.0 | 0.0 | 2020-03-23 23:19:34 | Unassigned, Louisiana, US | |
2875271 | 2875271 | 2020-03-29 | US | Louisiana | Unassigned | 8 | 0 | 0 | 8 | 0.0 | 0.0 | 3/29/20 23:08 | Unassigned, Louisiana, US | |
2907652 | 2907652 | 2020-03-22 | US | Louisiana | Unassigned | 50 | 0 | 0 | 50 | 0.0 | 0.0 | 3/22/20 23:45 | Unassigned, Louisiana, US | |
3364463 | 3364463 | 2020-04-01 | US | Louisiana | Unassigned | 28 | 0 | 0 | 28 | 0.0 | 0.0 | 2020-04-01 21:58:49 | Unassigned, Louisiana, US | |
3815560 | 3815560 | 2020-03-31 | US | Louisiana | Unassigned | 22 | 4 | 0 | 18 | 0.0 | 0.0 | 2020-03-31 23:43:56 | Unassigned, Louisiana, US | |
3946610 | 3946610 | 2020-03-28 | US | Louisiana | Unassigned | 9 | 1 | 0 | 8 | 0.0 | 0.0 | 3/28/20 23:05 | Unassigned, Louisiana, US | |
1871 | 1871 | 2021-12-02 | US | Louisiana | Terrebonne | 22109 | 19780 | 355 | 0 | 29.37343766 | -90.82626855 | 2021-12-03 04:23:05 | Terrebonne, Louisiana, US | |
5886 | 5886 | 2021-10-28 | US | Louisiana | Terrebonne | 22109 | 19382 | 342 | 0 | 29.37343766 | -90.82626855 | 2021-10-29 04:22:03 | Terrebonne, Louisiana, US | |
9858 | 9858 | 2020-10-25 | US | Louisiana | Terrebonne | 22109 | 3866 | 123 | 0 | 3743 | 29.37343766 | -90.82626855 | 2020-10-26 04:25:02 | Terrebonne, Louisiana, US |
13871 | 13871 | 2021-01-26 | US | Louisiana | Terrebonne | 22109 | 8331 | 168 | 0 | 8163 | 29.37343766 | -90.82626855 | 2021-01-27 05:23:41 | Terrebonne, Louisiana, US |
17893 | 17893 | 2021-09-18 | US | Louisiana | Terrebonne | 22109 | 18749 | 290 | 0 | 29.37343766 | -90.82626855 | 2021-09-19 04:21:34 | Terrebonne, Louisiana, US | |
21904 | 21904 | 2021-05-28 | US | Louisiana | Terrebonne | 22109 | 10549 | 224 | 0 | 29.37343766 | -90.82626855 | 2021-05-29 04:20:41 | Terrebonne, Louisiana, US | |
25942 | 25942 | 2022-03-20 | US | Louisiana | Terrebonne | 22109 | 30795 | 408 | 0 | 29.37343766 | -90.82626855 | 2022-03-21 04:20:50 | Terrebonne, Louisiana, US | |
29957 | 29957 | 2021-11-11 | US | Louisiana | Terrebonne | 22109 | 19506 | 350 | 0 | 29.37343766 | -90.82626855 | 2021-11-12 04:22:01 | Terrebonne, Louisiana, US | |
33953 | 33953 | 2021-08-25 | US | Louisiana | Terrebonne | 22109 | 17393 | 264 | 0 | 29.37343766 | -90.82626855 | 2021-08-26 04:21:28 | Terrebonne, Louisiana, US | |
37963 | 37963 | 2021-04-12 | US | Louisiana | Terrebonne | 22109 | 9928 | 219 | 0 | 29.37343766 | -90.82626855 | 2021-04-13 04:20:37 | Terrebonne, Louisiana, US | |
42714 | 42714 | 2020-04-13 | US | Louisiana | Terrebonne | 22109 | 260 | 14 | 0 | 246 | 29.37343766 | -90.82626855 | 2020-04-13 23:07:54 | Terrebonne, Louisiana, US |
45249 | 45249 | 2021-11-02 | US | Louisiana | Terrebonne | 22109 | 19421 | 345 | 0 | 29.37343766 | -90.82626855 | 2021-11-03 06:22:09 | Terrebonne, Louisiana, US | |
49806 | 49806 | 2020-04-17 | US | Louisiana | Terrebonne | 22109 | 293 | 18 | 0 | 275 | 29.37343766 | -90.82626855 | 2020-04-17 23:30:52 | Terrebonne, Louisiana, US |
52325 | 52325 | 2021-05-29 | US | Louisiana | Terrebonne | 22109 | 10549 | 224 | 0 | 29.37343766 | -90.82626855 | 2021-05-30 04:20:55 | Terrebonne, Louisiana, US | |
56336 | 56336 | 2021-03-07 | US | Louisiana | Terrebonne | 22109 | 9637 | 206 | 0 | 29.37343766 | -90.82626855 | 2021-03-08 05:24:48 | Terrebonne, Louisiana, US | |
61318 | 61318 | 2020-07-23 | US | Louisiana | Terrebonne | 22109 | 2254 | 69 | 0 | 2185 | 29.37343766 | -90.82626855 | 2020-07-24 05:30:40 | Terrebonne, Louisiana, US |
64607 | 64607 | 2022-11-12 | US | Louisiana | Terrebonne | 22109 | 36907 | 433 | 0 | 29.37343766 | -90.82626855 | 2022-11-13 04:21:14 | Terrebonne, Louisiana, US | |
68598 | 68598 | 2021-09-01 | US | Louisiana | Terrebonne | 22109 | 18024 | 269 | 0 | 29.37343766 | -90.82626855 | 2021-09-02 04:21:15 | Terrebonne, Louisiana, US | |
72632 | 72632 | 2022-02-07 | US | Louisiana | Terrebonne | 22109 | 29990 | 384 | 0 | 29.37343766 | -90.82626855 | 2022-02-08 04:21:15 | Terrebonne, Louisiana, US | |
76618 | 76618 | 2020-12-03 | US | Louisiana | Terrebonne | 22109 | 4685 | 139 | 0 | 4546 | 29.37343766 | -90.82626855 | 2020-12-04 05:27:27 | Terrebonne, Louisiana, US |
80612 | 80612 | 2020-10-14 | US | Louisiana | Terrebonne | 22109 | 3747 | 121 | 0 | 3626 | 29.37343766 | -90.82626855 | 2020-10-15 04:24:28 | Terrebonne, Louisiana, US |
84628 | 84628 | 2021-05-25 | US | Louisiana | Terrebonne | 22109 | 10480 | 224 | 0 | 29.37343766 | -90.82626855 | 2021-05-26 04:20:35 | Terrebonne, Louisiana, US | |
88666 | 88666 | 2021-11-09 | US | Louisiana | Terrebonne | 22109 | 19496 | 350 | 0 | 29.37343766 | -90.82626855 | 2021-11-10 04:21:38 | Terrebonne, Louisiana, US | |
92684 | 92684 | 2022-07-23 | US | Louisiana | Terrebonne | 22109 | 34483 | 424 | 0 | 29.37343766 | -90.82626855 | 2022-07-24 04:20:47 | Terrebonne, Louisiana, US | |
97648 | 97648 | 2020-08-04 | US | Louisiana | Terrebonne | 22109 | 2866 | 80 | 0 | 2786 | 29.37343766 | -90.82626855 | 2020-08-05 04:34:43 | Terrebonne, Louisiana, US |
100867 | 100867 | 2022-01-14 | US | Louisiana | Terrebonne | 22109 | 24742 | 369 | 0 | 29.37343766 | -90.82626855 | 2022-01-15 04:21:07 | Terrebonne, Louisiana, US | |
104863 | 104863 | 2021-08-15 | US | Louisiana | Terrebonne | 22109 | 15082 | 250 | 0 | 29.37343766 | -90.82626855 | 2021-08-16 04:21:31 | Terrebonne, Louisiana, US | |
108987 | 108987 | 2021-06-19 | US | Louisiana | Terrebonne | 22109 | 10856 | 225 | 0 | 29.37343766 | -90.82626855 | 2021-06-20 04:21:48 | Terrebonne, Louisiana, US | |
113720 | 113720 | 2020-05-08 | US | Louisiana | Terrebonne | 22109 | 501 | 36 | 0 | 465 | 29.37343766 | -90.82626855 | 2020-05-09 02:32:35 | Terrebonne, Louisiana, US |
116294 | 116294 | 2022-09-06 | US | Louisiana | Terrebonne | 22109 | 36444 | 427 | 0 | 29.37343766 | -90.82626855 | 2022-09-07 04:20:59 | Terrebonne, Louisiana, US | |
121242 | 121242 | 2020-07-19 | US | Louisiana | Terrebonne | 22109 | 2071 | 68 | 0 | 2003 | 29.37343766 | -90.82626855 | 2020-07-20 05:34:40 | Terrebonne, Louisiana, US |
124233 | 124233 | 2020-11-18 | US | Louisiana | Terrebonne | 22109 | 4223 | 134 | 0 | 4089 | 29.37343766 | -90.82626855 | 2020-11-19 05:25:23 | Terrebonne, Louisiana, US |
128274 | 128274 | 2022-01-09 | US | Louisiana | Terrebonne | 22109 | 22813 | 364 | 0 | 29.37343766 | -90.82626855 | 2022-01-10 04:22:07 | Terrebonne, Louisiana, US | |
132295 | 132295 | 2022-10-04 | US | Louisiana | Terrebonne | 22109 | 36802 | 432 | 0 | 29.37343766 | -90.82626855 | 2022-10-05 04:23:06 | Terrebonne, Louisiana, US | |
136950 | 136950 | 2020-04-29 | US | Louisiana | Terrebonne | 22109 | 389 | 31 | 0 | 358 | 29.37343766 | -90.82626855 | 2020-04-30 02:32:27 | Terrebonne, Louisiana, US |
139512 | 139512 | 2021-12-04 | US | Louisiana | Terrebonne | 22109 | 19817 | 355 | 0 | 29.37343766 | -90.82626855 | 2021-12-05 04:22:25 | Terrebonne, Louisiana, US | |
143530 | 143530 | 2022-07-09 | US | Louisiana | Terrebonne | 22109 | 33448 | 420 | 0 | 29.37343766 | -90.82626855 | 2022-07-10 04:20:54 | Terrebonne, Louisiana, US | |
147492 | 147492 | 2020-08-15 | US | Louisiana | Terrebonne | 22109 | 3160 | 86 | 0 | 3074 | 29.37343766 | -90.82626855 | 2020-08-16 04:27:42 | Terrebonne, Louisiana, US |
151525 | 151525 | 2021-11-29 | US | Louisiana | Terrebonne | 22109 | 19720 | 355 | 0 | 29.37343766 | -90.82626855 | 2021-11-30 04:22:53 | Terrebonne, Louisiana, US | |
155512 | 155512 | 2021-01-08 | US | Louisiana | Terrebonne | 22109 | 6974 | 155 | 0 | 6819 | 29.37343766 | -90.82626855 | 2021-01-09 05:22:18 | Terrebonne, Louisiana, US |
159554 | 159554 | 2022-03-29 | US | Louisiana | Terrebonne | 22109 | 30814 | 410 | 0 | 29.37343766 | -90.82626855 | 2022-03-30 04:20:45 | Terrebonne, Louisiana, US | |
163569 | 163569 | 2021-11-19 | US | Louisiana | Terrebonne | 22109 | 19594 | 353 | 0 | 29.37343766 | -90.82626855 | 2021-11-20 04:22:17 | Terrebonne, Louisiana, US | |
167587 | 167587 | 2022-06-21 | US | Louisiana | Terrebonne | 22109 | 32403 | 420 | 0 | 29.37343766 | -90.82626855 | 2022-06-22 04:20:54 | Terrebonne, Louisiana, US | |
171577 | 171577 | 2021-04-16 | US | Louisiana | Terrebonne | 22109 | 9964 | 219 | 0 | 29.37343766 | -90.82626855 | 2021-04-17 04:20:40 | Terrebonne, Louisiana, US | |
176558 | 176558 | 2020-07-27 | US | Louisiana | Terrebonne | 22109 | 2519 | 72 | 0 | 2447 | 29.37343766 | -90.82626855 | 2020-07-28 04:58:43 | Terrebonne, Louisiana, US |
179563 | 179563 | 2021-09-02 | US | Louisiana | Terrebonne | 22109 | 18076 | 272 | 0 | 29.37343766 | -90.82626855 | 2021-09-03 04:21:20 | Terrebonne, Louisiana, US | |
183571 | 183571 | 2021-02-21 | US | Louisiana | Terrebonne | 22109 | 9337 | 192 | 0 | 9145 | 29.37343766 | -90.82626855 | 2021-02-22 05:24:21 | Terrebonne, Louisiana, US |
187612 | 187612 | 2022-02-13 | US | Louisiana | Terrebonne | 22109 | 30310 | 391 | 0 | 29.37343766 | -90.82626855 | 2022-02-14 04:20:51 | Terrebonne, Louisiana, US | |
191598 | 191598 | 2021-01-11 | US | Louisiana | Terrebonne | 22109 | 7148 | 156 | 0 | 6992 | 29.37343766 | -90.82626855 | 2021-01-12 05:22:15 | Terrebonne, Louisiana, US |
195590 | 195590 | 2020-08-31 | US | Louisiana | Terrebonne | 22109 | 3343 | 99 | 0 | 3244 | 29.37343766 | -90.82626855 | 2020-09-01 04:28:31 | Terrebonne, Louisiana, US |
199804 | 199804 | 2022-10-19 | US | Louisiana | Terrebonne | 22109 | 36850 | 432 | 0 | 29.37343766 | -90.82626855 | 2022-10-20 04:22:59 | Terrebonne, Louisiana, US | |
203785 | 203785 | 2020-12-25 | US | Louisiana | Terrebonne | 22109 | 5705 | 147 | 0 | 5558 | 29.37343766 | -90.82626855 | 2020-12-26 05:22:28 | Terrebonne, Louisiana, US |
207776 | 207776 | 2020-08-19 | US | Louisiana | Terrebonne | 22109 | 3239 | 90 | 0 | 3149 | 29.37343766 | -90.82626855 | 2020-08-20 04:27:43 | Terrebonne, Louisiana, US |
211767 | 211767 | 2020-10-29 | US | Louisiana | Terrebonne | 22109 | 3870 | 125 | 0 | 3745 | 29.37343766 | -90.82626855 | 2020-10-30 04:24:49 | Terrebonne, Louisiana, US |
216578 | 216578 | 2020-06-08 | US | Louisiana | Terrebonne | 22109 | 748 | 55 | 0 | 693 | 29.37343766 | -90.82626855 | 2020-06-09 03:33:03 | Terrebonne, Louisiana, US |
219525 | 219525 | 2022-12-26 | US | Louisiana | Terrebonne | 22109 | 37428 | 437 | 0 | 29.37343766 | -90.82626855 | 2022-12-27 04:21:07 | Terrebonne, Louisiana, US | |
223537 | 223537 | 2022-05-09 | US | Louisiana | Terrebonne | 22109 | 30951 | 419 | 0 | 29.37343766 | -90.82626855 | 2022-05-10 04:20:50 | Terrebonne, Louisiana, US | |
228202 | 228202 | 2020-04-30 | US | Louisiana | Terrebonne | 22109 | 437 | 32 | 0 | 405 | 29.37343766 | -90.82626855 | 2020-05-01 02:32:28 | Terrebonne, Louisiana, US |
230769 | 230769 | 2022-05-31 | US | Louisiana | Terrebonne | 22109 | 31331 | 419 | 0 | 29.37343766 | -90.82626855 | 2022-06-01 04:20:55 | Terrebonne, Louisiana, US | |
234784 | 234784 | 2022-02-11 | US | Louisiana | Terrebonne | 22109 | 30310 | 391 | 0 | 29.37343766 | -90.82626855 | 2022-02-12 04:21:06 | Terrebonne, Louisiana, US | |
238771 | 238771 | 2021-01-18 | US | Louisiana | Terrebonne | 22109 | 7616 | 163 | 0 | 7453 | 29.37343766 | -90.82626855 | 2021-01-19 05:22:15 | Terrebonne, Louisiana, US |
242788 | 242788 | 2021-04-02 | US | Louisiana | Terrebonne | 22109 | 9867 | 218 | 0 | 29.37343766 | -90.82626855 | 2021-04-03 04:20:44 | Terrebonne, Louisiana, US | |
246806 | 246806 | 2021-08-17 | US | Louisiana | Terrebonne | 22109 | 15891 | 253 | 0 | 29.37343766 | -90.82626855 | 2021-08-18 04:21:35 | Terrebonne, Louisiana, US | |
250820 | 250820 | 2021-09-04 | US | Louisiana | Terrebonne | 22109 | 18110 | 273 | 0 | 29.37343766 | -90.82626855 | 2021-09-05 04:21:33 | Terrebonne, Louisiana, US | |
254856 | 254856 | 2022-09-08 | US | Louisiana | Terrebonne | 22109 | 36505 | 429 | 0 | 29.37343766 | -90.82626855 | 2022-09-09 04:21:11 | Terrebonne, Louisiana, US | |
258875 | 258875 | 2022-12-10 | US | Louisiana | Terrebonne | 22109 | 37122 | 435 | 0 | 29.37343766 | -90.82626855 | 2022-12-11 04:20:50 | Terrebonne, Louisiana, US | |
263074 | 263074 | 2022-03-15 | US | Louisiana | Terrebonne | 22109 | 30788 | 408 | 0 | 29.37343766 | -90.82626855 | 2022-03-16 04:20:50 | Terrebonne, Louisiana, US | |
267820 | 267820 | 2020-05-21 | US | Louisiana | Terrebonne | 22109 | 614 | 45 | 0 | 569 | 29.37343766 | -90.82626855 | 2020-05-22 02:36:51 | Terrebonne, Louisiana, US |
271164 | 271164 | 2020-04-28 | US | Louisiana | Terrebonne | 22109 | 382 | 31 | 0 | 351 | 29.37343766 | -90.82626855 | 2020-04-29 02:32:29 | Terrebonne, Louisiana, US |
273683 | 273683 | 2020-11-10 | US | Louisiana | Terrebonne | 22109 | 3972 | 126 | 0 | 3846 | 29.37343766 | -90.82626855 | 2020-11-11 05:25:30 | Terrebonne, Louisiana, US |
277724 | 277724 | 2021-11-03 | US | Louisiana | Terrebonne | 22109 | 19430 | 347 | 0 | 29.37343766 | -90.82626855 | 2021-11-04 04:22:20 | Terrebonne, Louisiana, US | |
281714 | 281714 | 2021-02-24 | US | Louisiana | Terrebonne | 22109 | 9446 | 198 | 0 | 9248 | 29.37343766 | -90.82626855 | 2021-02-25 05:24:57 | Terrebonne, Louisiana, US |
286552 | 286552 | 2020-06-15 | US | Louisiana | Terrebonne | 22109 | 812 | 57 | 0 | 755 | 29.37343766 | -90.82626855 | 2020-06-16 04:33:09 | Terrebonne, Louisiana, US |
289536 | 289536 | 2021-10-31 | US | Louisiana | Terrebonne | 22109 | 19389 | 342 | 0 | 29.37343766 | -90.82626855 | 2021-11-01 04:22:01 | Terrebonne, Louisiana, US | |
293558 | 293558 | 2022-11-15 | US | Louisiana | Terrebonne | 22109 | 36907 | 433 | 0 | 29.37343766 | -90.82626855 | 2022-11-16 04:21:09 | Terrebonne, Louisiana, US | |
297549 | 297549 | 2021-07-15 | US | Louisiana | Terrebonne | 22109 | 11361 | 229 | 0 | 29.37343766 | -90.82626855 | 2021-07-16 04:21:22 | Terrebonne, Louisiana, US | |
302416 | 302416 | 2020-07-01 | US | Louisiana | Terrebonne | 22109 | 1068 | 61 | 0 | 1007 | 29.37343766 | -90.82626855 | 2020-07-02 04:33:46 | Terrebonne, Louisiana, US |
305410 | 305410 | 2022-04-16 | US | Louisiana | Terrebonne | 22109 | 30842 | 414 | 0 | 29.37343766 | -90.82626855 | 2022-04-17 04:20:59 | Terrebonne, Louisiana, US | |
309430 | 309430 | 2022-12-13 | US | Louisiana | Terrebonne | 22109 | 37122 | 435 | 0 | 29.37343766 | -90.82626855 | 2022-12-14 04:21:04 | Terrebonne, Louisiana, US | |
313446 | 313446 | 2022-11-13 | US | Louisiana | Terrebonne | 22109 | 36907 | 433 | 0 | 29.37343766 | -90.82626855 | 2022-11-14 04:21:09 | Terrebonne, Louisiana, US | |
317458 | 317458 | 2022-02-12 | US | Louisiana | Terrebonne | 22109 | 30310 | 391 | 0 | 29.37343766 | -90.82626855 | 2022-02-13 04:21:00 | Terrebonne, Louisiana, US | |
321478 | 321478 | 2022-10-30 | US | Louisiana | Terrebonne | 22109 | 36866 | 432 | 0 | 29.37343766 | -90.82626855 | 2022-10-31 04:21:36 | Terrebonne, Louisiana, US | |
326349 | 326349 | 2020-07-20 | US | Louisiana | Terrebonne | 22109 | 2124 | 68 | 0 | 2056 | 29.37343766 | -90.82626855 | 2020-07-21 04:38:46 | Terrebonne, Louisiana, US |
329452 | 329452 | 2022-12-27 | US | Louisiana | Terrebonne | 22109 | 37428 | 437 | 0 | 29.37343766 | -90.82626855 | 2022-12-28 04:21:04 | Terrebonne, Louisiana, US | |
333443 | 333443 | 2021-08-04 | US | Louisiana | Terrebonne | 22109 | 13407 | 234 | 0 | 29.37343766 | -90.82626855 | 2021-08-05 04:21:51 | Terrebonne, Louisiana, US | |
337478 | 337478 | 2022-03-18 | US | Louisiana | Terrebonne | 22109 | 30795 | 408 | 0 | 29.37343766 | -90.82626855 | 2022-03-19 04:20:47 | Terrebonne, Louisiana, US | |
341806 | 341806 | 2021-02-03 | US | Louisiana | Terrebonne | 22109 | 8793 | 186 | 0 | 8607 | 29.37343766 | -90.82626855 | 2021-02-04 05:22:26 | Terrebonne, Louisiana, US |
345798 | 345798 | 2020-09-14 | US | Louisiana | Terrebonne | 22109 | 3519 | 106 | 0 | 3413 | 29.37343766 | -90.82626855 | 2020-09-15 03:22:50 | Terrebonne, Louisiana, US |
349842 | 349842 | 2022-12-14 | US | Louisiana | Terrebonne | 22109 | 37266 | 435 | 0 | 29.37343766 | -90.82626855 | 2022-12-15 04:20:58 | Terrebonne, 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]);