johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,013 rows where combined_key = "Morehouse, Louisiana, US" and province_or_state = "Louisiana" sorted by day descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2754427 | 2754427 | 2022-12-29 | US | Louisiana | Morehouse | 22067 | 8346 | 144 | 0 | 32.81686191 | -91.80421614 | 2022-12-30 04:21:04 | Morehouse, Louisiana, US | |
1075433 | 1075433 | 2022-12-28 | US | Louisiana | Morehouse | 22067 | 8346 | 144 | 0 | 32.81686191 | -91.80421614 | 2022-12-29 04:21:01 | Morehouse, Louisiana, US | |
329430 | 329430 | 2022-12-27 | US | Louisiana | Morehouse | 22067 | 8334 | 144 | 0 | 32.81686191 | -91.80421614 | 2022-12-28 04:21:04 | Morehouse, Louisiana, US | |
219503 | 219503 | 2022-12-26 | US | Louisiana | Morehouse | 22067 | 8334 | 144 | 0 | 32.81686191 | -91.80421614 | 2022-12-27 04:21:07 | Morehouse, Louisiana, US | |
3223960 | 3223960 | 2022-12-25 | US | Louisiana | Morehouse | 22067 | 8334 | 144 | 0 | 32.81686191 | -91.80421614 | 2022-12-26 04:21:06 | Morehouse, Louisiana, US | |
1019874 | 1019874 | 2022-12-24 | US | Louisiana | Morehouse | 22067 | 8334 | 144 | 0 | 32.81686191 | -91.80421614 | 2022-12-25 04:21:04 | Morehouse, Louisiana, US | |
691897 | 691897 | 2022-12-23 | US | Louisiana | Morehouse | 22067 | 8334 | 144 | 0 | 32.81686191 | -91.80421614 | 2022-12-24 04:21:02 | Morehouse, Louisiana, US | |
2181107 | 2181107 | 2022-12-22 | US | Louisiana | Morehouse | 22067 | 8334 | 144 | 0 | 32.81686191 | -91.80421614 | 2022-12-23 04:21:04 | Morehouse, Louisiana, US | |
452911 | 452911 | 2022-12-21 | US | Louisiana | Morehouse | 22067 | 8334 | 144 | 0 | 32.81686191 | -91.80421614 | 2022-12-22 04:20:56 | Morehouse, Louisiana, US | |
2952910 | 2952910 | 2022-12-20 | US | Louisiana | Morehouse | 22067 | 8295 | 144 | 0 | 32.81686191 | -91.80421614 | 2022-12-21 04:21:03 | Morehouse, Louisiana, US | |
3175312 | 3175312 | 2022-12-19 | US | Louisiana | Morehouse | 22067 | 8295 | 144 | 0 | 32.81686191 | -91.80421614 | 2022-12-20 04:21:04 | Morehouse, Louisiana, US | |
1629829 | 1629829 | 2022-12-18 | US | Louisiana | Morehouse | 22067 | 8295 | 144 | 0 | 32.81686191 | -91.80421614 | 2022-12-19 04:21:03 | Morehouse, Louisiana, US | |
505208 | 505208 | 2022-12-17 | US | Louisiana | Morehouse | 22067 | 8295 | 144 | 0 | 32.81686191 | -91.80421614 | 2022-12-18 04:21:03 | Morehouse, Louisiana, US | |
3325780 | 3325780 | 2022-12-16 | US | Louisiana | Morehouse | 22067 | 8295 | 144 | 0 | 32.81686191 | -91.80421614 | 2022-12-17 04:21:04 | Morehouse, Louisiana, US | |
544292 | 544292 | 2022-12-15 | US | Louisiana | Morehouse | 22067 | 8295 | 144 | 0 | 32.81686191 | -91.80421614 | 2022-12-16 04:21:01 | Morehouse, Louisiana, US | |
349820 | 349820 | 2022-12-14 | US | Louisiana | Morehouse | 22067 | 8295 | 144 | 0 | 32.81686191 | -91.80421614 | 2022-12-15 04:20:58 | Morehouse, Louisiana, US | |
309408 | 309408 | 2022-12-13 | US | Louisiana | Morehouse | 22067 | 8278 | 143 | 0 | 32.81686191 | -91.80421614 | 2022-12-14 04:21:04 | Morehouse, Louisiana, US | |
1150469 | 1150469 | 2022-12-12 | US | Louisiana | Morehouse | 22067 | 8278 | 143 | 0 | 32.81686191 | -91.80421614 | 2022-12-13 04:21:01 | Morehouse, Louisiana, US | |
870323 | 870323 | 2022-12-11 | US | Louisiana | Morehouse | 22067 | 8278 | 143 | 0 | 32.81686191 | -91.80421614 | 2022-12-12 04:21:01 | Morehouse, Louisiana, US | |
258853 | 258853 | 2022-12-10 | US | Louisiana | Morehouse | 22067 | 8278 | 143 | 0 | 32.81686191 | -91.80421614 | 2022-12-11 04:20:50 | Morehouse, Louisiana, US | |
3937567 | 3937567 | 2022-12-09 | US | Louisiana | Morehouse | 22067 | 8278 | 143 | 0 | 32.81686191 | -91.80421614 | 2022-12-10 04:21:02 | Morehouse, Louisiana, US | |
3378899 | 3378899 | 2022-12-08 | US | Louisiana | Morehouse | 22067 | 8278 | 143 | 0 | 32.81686191 | -91.80421614 | 2022-12-09 04:21:05 | Morehouse, Louisiana, US | |
1986170 | 1986170 | 2022-12-07 | US | Louisiana | Morehouse | 22067 | 8278 | 143 | 0 | 32.81686191 | -91.80421614 | 2022-12-08 04:21:07 | Morehouse, Louisiana, US | |
3715693 | 3715693 | 2022-12-06 | US | Louisiana | Morehouse | 22067 | 8262 | 143 | 0 | 32.81686191 | -91.80421614 | 2022-12-07 04:20:58 | Morehouse, Louisiana, US | |
2416398 | 2416398 | 2022-12-05 | US | Louisiana | Morehouse | 22067 | 8262 | 143 | 0 | 32.81686191 | -91.80421614 | 2022-12-06 04:21:03 | Morehouse, Louisiana, US | |
720006 | 720006 | 2022-12-04 | US | Louisiana | Morehouse | 22067 | 8262 | 143 | 0 | 32.81686191 | -91.80421614 | 2022-12-05 04:20:58 | Morehouse, Louisiana, US | |
2818295 | 2818295 | 2022-12-03 | US | Louisiana | Morehouse | 22067 | 8262 | 143 | 0 | 32.81686191 | -91.80421614 | 2022-12-04 04:20:56 | Morehouse, Louisiana, US | |
835151 | 835151 | 2022-12-02 | US | Louisiana | Morehouse | 22067 | 8262 | 143 | 0 | 32.81686191 | -91.80421614 | 2022-12-03 04:21:02 | Morehouse, Louisiana, US | |
2137681 | 2137681 | 2022-12-01 | US | Louisiana | Morehouse | 22067 | 8262 | 143 | 0 | 32.81686191 | -91.80421614 | 2022-12-02 04:21:07 | Morehouse, Louisiana, US | |
1966097 | 1966097 | 2022-11-30 | US | Louisiana | Morehouse | 22067 | 8262 | 143 | 0 | 32.81686191 | -91.80421614 | 2022-12-01 04:21:03 | Morehouse, Louisiana, US | |
2558111 | 2558111 | 2022-11-29 | US | Louisiana | Morehouse | 22067 | 8256 | 143 | 0 | 32.81686191 | -91.80421614 | 2022-11-30 04:21:07 | Morehouse, Louisiana, US | |
1241185 | 1241185 | 2022-11-28 | US | Louisiana | Morehouse | 22067 | 8256 | 143 | 0 | 32.81686191 | -91.80421614 | 2022-11-29 04:21:05 | Morehouse, Louisiana, US | |
3553173 | 3553173 | 2022-11-27 | US | Louisiana | Morehouse | 22067 | 8256 | 143 | 0 | 32.81686191 | -91.80421614 | 2022-11-28 04:21:02 | Morehouse, Louisiana, US | |
2101653 | 2101653 | 2022-11-26 | US | Louisiana | Morehouse | 22067 | 8256 | 143 | 0 | 32.81686191 | -91.80421614 | 2022-11-27 04:21:05 | Morehouse, Louisiana, US | |
489144 | 489144 | 2022-11-25 | US | Louisiana | Morehouse | 22067 | 8256 | 143 | 0 | 32.81686191 | -91.80421614 | 2022-11-26 04:21:11 | Morehouse, Louisiana, US | |
3524973 | 3524973 | 2022-11-24 | US | Louisiana | Morehouse | 22067 | 8256 | 143 | 0 | 32.81686191 | -91.80421614 | 2022-11-25 04:21:06 | Morehouse, Louisiana, US | |
3313756 | 3313756 | 2022-11-23 | US | Louisiana | Morehouse | 22067 | 8256 | 143 | 0 | 32.81686191 | -91.80421614 | 2022-11-24 04:21:09 | Morehouse, Louisiana, US | |
1621797 | 1621797 | 2022-11-22 | US | Louisiana | Morehouse | 22067 | 8219 | 143 | 0 | 32.81686191 | -91.80421614 | 2022-11-23 04:21:06 | Morehouse, Louisiana, US | |
3461685 | 3461685 | 2022-11-21 | US | Louisiana | Morehouse | 22067 | 8219 | 143 | 0 | 32.81686191 | -91.80421614 | 2022-11-22 04:20:47 | Morehouse, Louisiana, US | |
1641870 | 1641870 | 2022-11-20 | US | Louisiana | Morehouse | 22067 | 8219 | 143 | 0 | 32.81686191 | -91.80421614 | 2022-11-21 04:21:05 | Morehouse, Louisiana, US | |
2065427 | 2065427 | 2022-11-19 | US | Louisiana | Morehouse | 22067 | 8219 | 143 | 0 | 32.81686191 | -91.80421614 | 2022-11-20 04:21:08 | Morehouse, Louisiana, US | |
1756821 | 1756821 | 2022-11-18 | US | Louisiana | Morehouse | 22067 | 8219 | 143 | 0 | 32.81686191 | -91.80421614 | 2022-11-19 04:21:14 | Morehouse, Louisiana, US | |
3027814 | 3027814 | 2022-11-17 | US | Louisiana | Morehouse | 22067 | 8219 | 143 | 0 | 32.81686191 | -91.80421614 | 2022-11-18 04:21:15 | Morehouse, Louisiana, US | |
2487525 | 2487525 | 2022-11-16 | US | Louisiana | Morehouse | 22067 | 8219 | 143 | 0 | 32.81686191 | -91.80421614 | 2022-11-17 04:21:11 | Morehouse, Louisiana, US | |
293536 | 293536 | 2022-11-15 | US | Louisiana | Morehouse | 22067 | 8203 | 143 | 0 | 32.81686191 | -91.80421614 | 2022-11-16 04:21:09 | Morehouse, Louisiana, US | |
3598566 | 3598566 | 2022-11-14 | US | Louisiana | Morehouse | 22067 | 8203 | 143 | 0 | 32.81686191 | -91.80421614 | 2022-11-15 04:21:16 | Morehouse, Louisiana, US | |
313424 | 313424 | 2022-11-13 | US | Louisiana | Morehouse | 22067 | 8203 | 143 | 0 | 32.81686191 | -91.80421614 | 2022-11-14 04:21:09 | Morehouse, Louisiana, US | |
64585 | 64585 | 2022-11-12 | US | Louisiana | Morehouse | 22067 | 8203 | 143 | 0 | 32.81686191 | -91.80421614 | 2022-11-13 04:21:14 | Morehouse, Louisiana, US | |
2928747 | 2928747 | 2022-11-11 | US | Louisiana | Morehouse | 22067 | 8203 | 143 | 0 | 32.81686191 | -91.80421614 | 2022-11-12 04:20:41 | Morehouse, Louisiana, US | |
2507583 | 2507583 | 2022-11-10 | US | Louisiana | Morehouse | 22067 | 8203 | 143 | 0 | 32.81686191 | -91.80421614 | 2022-11-11 04:21:22 | Morehouse, Louisiana, US | |
2432458 | 2432458 | 2022-11-09 | US | Louisiana | Morehouse | 22067 | 8203 | 143 | 0 | 32.81686191 | -91.80421614 | 2022-11-10 04:21:16 | Morehouse, Louisiana, US | |
481114 | 481114 | 2022-11-08 | US | Louisiana | Morehouse | 22067 | 8197 | 143 | 0 | 32.81686191 | -91.80421614 | 2022-11-09 04:21:22 | Morehouse, Louisiana, US | |
2440264 | 2440264 | 2022-11-07 | US | Louisiana | Morehouse | 22067 | 8197 | 143 | 0 | 32.81686191 | -91.80421614 | 2022-11-08 04:21:21 | Morehouse, Louisiana, US | |
1051362 | 1051362 | 2022-11-06 | US | Louisiana | Morehouse | 22067 | 8197 | 143 | 0 | 32.81686191 | -91.80421614 | 2022-11-07 04:21:26 | Morehouse, Louisiana, US | |
619386 | 619386 | 2022-11-05 | US | Louisiana | Morehouse | 22067 | 8197 | 143 | 0 | 32.81686191 | -91.80421614 | 2022-11-06 04:21:24 | Morehouse, Louisiana, US | |
1023890 | 1023890 | 2022-11-04 | US | Louisiana | Morehouse | 22067 | 8197 | 143 | 0 | 32.81686191 | -91.80421614 | 2022-11-05 04:21:52 | Morehouse, Louisiana, US | |
432881 | 432881 | 2022-11-03 | US | Louisiana | Morehouse | 22067 | 8197 | 143 | 0 | 32.81686191 | -91.80421614 | 2022-11-04 04:22:11 | Morehouse, Louisiana, US | |
851123 | 851123 | 2022-11-02 | US | Louisiana | Morehouse | 22067 | 8197 | 143 | 0 | 32.81686191 | -91.80421614 | 2022-11-03 04:22:05 | Morehouse, Louisiana, US | |
711974 | 711974 | 2022-11-01 | US | Louisiana | Morehouse | 22067 | 8173 | 143 | 0 | 32.81686191 | -91.80421614 | 2022-11-02 04:22:09 | Morehouse, Louisiana, US | |
3286423 | 3286423 | 2022-10-31 | US | Louisiana | Morehouse | 22067 | 8173 | 143 | 0 | 32.81686191 | -91.80421614 | 2022-11-01 04:22:36 | Morehouse, Louisiana, US | |
321456 | 321456 | 2022-10-30 | US | Louisiana | Morehouse | 22067 | 8173 | 143 | 0 | 32.81686191 | -91.80421614 | 2022-10-31 04:21:36 | Morehouse, Louisiana, US | |
913732 | 913732 | 2022-10-29 | US | Louisiana | Morehouse | 22067 | 8173 | 143 | 0 | 32.81686191 | -91.80421614 | 2022-10-30 04:22:14 | Morehouse, Louisiana, US | |
1368001 | 1368001 | 2022-10-28 | US | Louisiana | Morehouse | 22067 | 8173 | 143 | 0 | 32.81686191 | -91.80421614 | 2022-10-29 04:21:13 | Morehouse, Louisiana, US | |
3039856 | 3039856 | 2022-10-27 | US | Louisiana | Morehouse | 22067 | 8173 | 143 | 0 | 32.81686191 | -91.80421614 | 2022-10-28 04:22:31 | Morehouse, Louisiana, US | |
540276 | 540276 | 2022-10-26 | US | Louisiana | Morehouse | 22067 | 8173 | 143 | 0 | 32.81686191 | -91.80421614 | 2022-10-27 04:22:01 | Morehouse, Louisiana, US | |
1831677 | 1831677 | 2022-10-25 | US | Louisiana | Morehouse | 22067 | 8165 | 142 | 0 | 32.81686191 | -91.80421614 | 2022-10-26 04:22:19 | Morehouse, Louisiana, US | |
795938 | 795938 | 2022-10-24 | US | Louisiana | Morehouse | 22067 | 8165 | 142 | 0 | 32.81686191 | -91.80421614 | 2022-10-25 04:21:53 | Morehouse, Louisiana, US | |
3278393 | 3278393 | 2022-10-23 | US | Louisiana | Morehouse | 22067 | 8165 | 142 | 0 | 32.81686191 | -91.80421614 | 2022-10-24 04:22:29 | Morehouse, Louisiana, US | |
2269431 | 2269431 | 2022-10-22 | US | Louisiana | Morehouse | 22067 | 8165 | 142 | 0 | 32.81686191 | -91.80421614 | 2022-10-23 04:22:46 | Morehouse, Louisiana, US | |
1593731 | 1593731 | 2022-10-21 | US | Louisiana | Morehouse | 22067 | 8165 | 142 | 0 | 32.81686191 | -91.80421614 | 2022-10-22 04:22:53 | Morehouse, Louisiana, US | |
2273447 | 2273447 | 2022-10-20 | US | Louisiana | Morehouse | 22067 | 8165 | 142 | 0 | 32.81686191 | -91.80421614 | 2022-10-21 04:22:23 | Morehouse, Louisiana, US | |
199782 | 199782 | 2022-10-19 | US | Louisiana | Morehouse | 22067 | 8165 | 142 | 0 | 32.81686191 | -91.80421614 | 2022-10-20 04:22:59 | Morehouse, Louisiana, US | |
2758443 | 2758443 | 2022-10-18 | US | Louisiana | Morehouse | 22067 | 8163 | 142 | 0 | 32.81686191 | -91.80421614 | 2022-10-19 04:22:26 | Morehouse, Louisiana, US | |
2026277 | 2026277 | 2022-10-17 | US | Louisiana | Morehouse | 22067 | 8163 | 142 | 0 | 32.81686191 | -91.80421614 | 2022-10-18 04:22:42 | Morehouse, Louisiana, US | |
2161055 | 2161055 | 2022-10-16 | US | Louisiana | Morehouse | 22067 | 8163 | 142 | 0 | 32.81686191 | -91.80421614 | 2022-10-17 04:20:31 | Morehouse, Louisiana, US | |
517252 | 517252 | 2022-10-15 | US | Louisiana | Morehouse | 22067 | 8163 | 142 | 0 | 32.81686191 | -91.80421614 | 2022-10-16 04:22:39 | Morehouse, Louisiana, US | |
2034309 | 2034309 | 2022-10-14 | US | Louisiana | Morehouse | 22067 | 8163 | 142 | 0 | 32.81686191 | -91.80421614 | 2022-10-15 04:22:00 | Morehouse, Louisiana, US | |
3754997 | 3754997 | 2022-10-13 | US | Louisiana | Morehouse | 22067 | 8163 | 142 | 0 | 32.81686191 | -91.80421614 | 2022-10-14 04:22:28 | Morehouse, Louisiana, US | |
3215822 | 3215822 | 2022-10-12 | US | Louisiana | Morehouse | 22067 | 8162 | 142 | 0 | 32.81686191 | -91.80421614 | 2022-10-13 04:22:39 | Morehouse, Louisiana, US | |
3251671 | 3251671 | 2022-10-11 | US | Louisiana | Morehouse | 22067 | 8161 | 142 | 0 | 32.81686191 | -91.80421614 | 2022-10-12 04:22:51 | Morehouse, Louisiana, US | |
2968930 | 2968930 | 2022-10-10 | US | Louisiana | Morehouse | 22067 | 8148 | 142 | 0 | 32.81686191 | -91.80421614 | 2022-10-11 04:23:05 | Morehouse, Louisiana, US | |
3098966 | 3098966 | 2022-10-09 | US | Louisiana | Morehouse | 22067 | 8143 | 142 | 0 | 32.81686191 | -91.80421614 | 2022-10-10 04:22:32 | Morehouse, Louisiana, US | |
4004191 | 4004191 | 2022-10-08 | US | Louisiana | Morehouse | 22067 | 8143 | 142 | 0 | 32.81686191 | -91.80421614 | 2022-10-09 04:21:16 | Morehouse, Louisiana, US | |
397788 | 397788 | 2022-10-07 | US | Louisiana | Morehouse | 22067 | 8143 | 142 | 0 | 32.81686191 | -91.80421614 | 2022-10-08 04:22:56 | Morehouse, Louisiana, US | |
2530905 | 2530905 | 2022-10-06 | US | Louisiana | Morehouse | 22067 | 8139 | 142 | 0 | 32.81686191 | -91.80421614 | 2022-10-07 04:23:08 | Morehouse, Louisiana, US | |
1812299 | 1812299 | 2022-10-05 | US | Louisiana | Morehouse | 22067 | 8139 | 142 | 0 | 32.81686191 | -91.80421614 | 2022-10-06 04:21:22 | Morehouse, Louisiana, US | |
132273 | 132273 | 2022-10-04 | US | Louisiana | Morehouse | 22067 | 8133 | 142 | 0 | 32.81686191 | -91.80421614 | 2022-10-05 04:23:06 | Morehouse, Louisiana, US | |
2687220 | 2687220 | 2022-10-03 | US | Louisiana | Morehouse | 22067 | 8127 | 142 | 0 | 32.81686191 | -91.80421614 | 2022-10-04 04:22:55 | Morehouse, Louisiana, US | |
2261287 | 2261287 | 2022-10-02 | US | Louisiana | Morehouse | 22067 | 8114 | 142 | 0 | 32.81686191 | -91.80421614 | 2022-10-03 04:23:11 | Morehouse, Louisiana, US | |
2996813 | 2996813 | 2022-10-01 | US | Louisiana | Morehouse | 22067 | 8114 | 142 | 0 | 32.81686191 | -91.80421614 | 2022-10-02 04:21:23 | Morehouse, Louisiana, US | |
855139 | 855139 | 2022-09-30 | US | Louisiana | Morehouse | 22067 | 8114 | 142 | 0 | 32.81686191 | -91.80421614 | 2022-10-01 04:23:01 | Morehouse, Louisiana, US | |
2377065 | 2377065 | 2022-09-29 | US | Louisiana | Morehouse | 22067 | 8108 | 142 | 0 | 32.81686191 | -91.80421614 | 2022-09-30 04:23:09 | Morehouse, Louisiana, US | |
1561616 | 1561616 | 2022-09-28 | US | Louisiana | Morehouse | 22067 | 8101 | 142 | 0 | 32.81686191 | -91.80421614 | 2022-09-29 04:22:34 | Morehouse, Louisiana, US | |
3996159 | 3996159 | 2022-09-27 | US | Louisiana | Morehouse | 22067 | 8087 | 142 | 0 | 32.81686191 | -91.80421614 | 2022-09-28 04:23:01 | Morehouse, Louisiana, US | |
2770487 | 2770487 | 2022-09-26 | US | Louisiana | Morehouse | 22067 | 8069 | 142 | 0 | 32.81686191 | -91.80421614 | 2022-09-27 04:23:01 | Morehouse, Louisiana, US | |
1978140 | 1978140 | 2022-09-25 | US | Louisiana | Morehouse | 22067 | 8063 | 142 | 0 | 32.81686191 | -91.80421614 | 2022-09-26 04:20:52 | Morehouse, Louisiana, US | |
2651307 | 2651307 | 2022-09-24 | US | Louisiana | Morehouse | 22067 | 8063 | 142 | 0 | 32.81686191 | -91.80421614 | 2022-09-25 04:23:31 | Morehouse, Louisiana, US | |
385747 | 385747 | 2022-09-23 | US | Louisiana | Morehouse | 22067 | 8063 | 142 | 0 | 32.81686191 | -91.80421614 | 2022-09-24 04:21:40 | Morehouse, Louisiana, US | |
1625813 | 1625813 | 2022-09-22 | US | Louisiana | Morehouse | 22067 | 8056 | 142 | 0 | 32.81686191 | -91.80421614 | 2022-09-23 04:23:13 | Morehouse, Louisiana, US | |
1372017 | 1372017 | 2022-09-21 | US | Louisiana | Morehouse | 22067 | 8047 | 142 | 0 | 32.81686191 | -91.80421614 | 2022-09-22 04:22:56 | Morehouse, 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]);