johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
669 rows where active = 279 and country_or_region = "US" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state >30
- Texas 80
- Georgia 39
- Kansas 32
- Puerto Rico 32
- Virginia 29
- Illinois 27
- North Carolina 24
- Kentucky 22
- Missouri 21
- New York 21
- Indiana 20
- Tennessee 19
- Iowa 17
- Ohio 17
- Arkansas 16
- Michigan 16
- Minnesota 16
- South Dakota 16
- Colorado 15
- Mississippi 15
- Nebraska 14
- Oklahoma 14
- Louisiana 11
- Pennsylvania 11
- California 10
- Idaho 10
- New Mexico 10
- Wisconsin 10
- Alabama 9
- Montana 9
- …
country_or_region 1
- US · 669 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3255174 | 3255174 | 2021-03-02 | US | Illinois | Pope | 17151 | 282 | 3 | 0 | 279 | 37.41391284 | -88.56152109 | 2021-03-03 05:23:28 | Pope, Illinois, US |
3257159 | 3257159 | 2021-03-02 | US | Texas | Baylor | 48023 | 271 | 11 | 0 | 279 | 33.61640794 | -99.21352901 | 2021-03-03 05:23:28 | Baylor, Texas, US |
999466 | 999466 | 2021-03-01 | US | Illinois | Pope | 17151 | 282 | 3 | 0 | 279 | 37.41391284 | -88.56152109 | 2021-03-02 05:23:30 | Pope, Illinois, US |
1001451 | 1001451 | 2021-03-01 | US | Texas | Baylor | 48023 | 271 | 11 | 0 | 279 | 33.61640794 | -99.21352901 | 2021-03-02 05:23:30 | Baylor, Texas, US |
2368524 | 2368524 | 2021-02-28 | US | Illinois | Pope | 17151 | 282 | 3 | 0 | 279 | 37.41391284 | -88.56152109 | 2021-03-01 05:23:01 | Pope, Illinois, US |
2370509 | 2370509 | 2021-02-28 | US | Texas | Baylor | 48023 | 271 | 11 | 0 | 279 | 33.61640794 | -99.21352901 | 2021-03-01 05:23:01 | Baylor, Texas, US |
3067026 | 3067026 | 2021-02-27 | US | Illinois | Pope | 17151 | 282 | 3 | 0 | 279 | 37.41391284 | -88.56152109 | 2021-02-28 05:22:20 | Pope, Illinois, US |
3069011 | 3069011 | 2021-02-27 | US | Texas | Baylor | 48023 | 271 | 11 | 0 | 279 | 33.61640794 | -99.21352901 | 2021-02-28 05:22:20 | Baylor, Texas, US |
2184610 | 2184610 | 2021-02-26 | US | Illinois | Pope | 17151 | 282 | 3 | 0 | 279 | 37.41391284 | -88.56152109 | 2021-02-27 05:22:28 | Pope, Illinois, US |
2185813 | 2185813 | 2021-02-26 | US | New York | Hamilton | 36041 | 281 | 2 | 0 | 279 | 43.66146647 | -74.49721957 | 2021-02-27 05:22:28 | Hamilton, New York, US |
2186595 | 2186595 | 2021-02-26 | US | Texas | Baylor | 48023 | 271 | 11 | 0 | 279 | 33.61640794 | -99.21352901 | 2021-02-27 05:22:28 | Baylor, Texas, US |
1859032 | 1859032 | 2021-02-25 | US | Illinois | Pope | 17151 | 282 | 3 | 0 | 279 | 37.41391284 | -88.56152109 | 2021-02-26 05:22:40 | Pope, Illinois, US |
1861017 | 1861017 | 2021-02-25 | US | Texas | Baylor | 48023 | 271 | 11 | 0 | 279 | 33.61640794 | -99.21352901 | 2021-02-26 05:22:40 | Baylor, Texas, US |
283195 | 283195 | 2021-02-24 | US | Texas | Baylor | 48023 | 271 | 11 | 0 | 279 | 33.61640794 | -99.21352901 | 2021-02-25 05:24:57 | Baylor, Texas, US |
1939463 | 1939463 | 2021-02-23 | US | Texas | Baylor | 48023 | 271 | 11 | 0 | 279 | 33.61640794 | -99.21352901 | 2021-02-24 05:29:16 | Baylor, Texas, US |
533718 | 533718 | 2021-02-22 | US | Texas | Baylor | 48023 | 271 | 11 | 0 | 279 | 33.61640794 | -99.21352901 | 2021-02-23 05:23:41 | Baylor, Texas, US |
185052 | 185052 | 2021-02-21 | US | Texas | Baylor | 48023 | 271 | 11 | 0 | 279 | 33.61640794 | -99.21352901 | 2021-02-22 05:24:21 | Baylor, Texas, US |
745326 | 745326 | 2021-02-20 | US | Texas | Baylor | 48023 | 271 | 11 | 0 | 279 | 33.61640794 | -99.21352901 | 2021-02-21 05:24:33 | Baylor, Texas, US |
745375 | 745375 | 2021-02-20 | US | Texas | Delta | 48119 | 924 | 10 | 0 | 279 | 33.38570922 | -95.66921122 | 2021-02-21 05:24:33 | Delta, Texas, US |
474424 | 474424 | 2021-02-19 | US | Texas | Baylor | 48023 | 271 | 11 | 0 | 279 | 33.61640794 | -99.21352901 | 2021-02-20 05:22:51 | Baylor, Texas, US |
474473 | 474473 | 2021-02-19 | US | Texas | Delta | 48119 | 924 | 10 | 0 | 279 | 33.38570922 | -95.66921122 | 2021-02-20 05:22:51 | Delta, Texas, US |
474560 | 474560 | 2021-02-19 | US | Texas | Lipscomb | 48295 | 341 | 11 | 0 | 279 | 36.27783108 | -100.2733151 | 2021-02-20 05:22:51 | Lipscomb, Texas, US |
1156133 | 1156133 | 2021-02-18 | US | Texas | Baylor | 48023 | 271 | 11 | 0 | 279 | 33.61640794 | -99.21352901 | 2021-02-19 05:24:16 | Baylor, Texas, US |
1156269 | 1156269 | 2021-02-18 | US | Texas | Lipscomb | 48295 | 341 | 11 | 0 | 279 | 36.27783108 | -100.2733151 | 2021-02-19 05:24:16 | Lipscomb, Texas, US |
3604053 | 3604053 | 2021-02-17 | US | Texas | Baylor | 48023 | 271 | 11 | 0 | 279 | 33.61640794 | -99.21352901 | 2021-02-18 05:22:58 | Baylor, Texas, US |
3604189 | 3604189 | 2021-02-17 | US | Texas | Lipscomb | 48295 | 341 | 11 | 0 | 279 | 36.27783108 | -100.2733151 | 2021-02-18 05:22:58 | Lipscomb, Texas, US |
3051501 | 3051501 | 2021-02-16 | US | Kansas | Rawlins | 20153 | 286 | 7 | 0 | 279 | 39.78525843 | -101.0761617 | 2021-02-17 05:23:10 | Rawlins, Kansas, US |
3053188 | 3053188 | 2021-02-16 | US | Texas | Baylor | 48023 | 271 | 11 | 0 | 279 | 33.61640794 | -99.21352901 | 2021-02-17 05:23:10 | Baylor, Texas, US |
3053324 | 3053324 | 2021-02-16 | US | Texas | Lipscomb | 48295 | 341 | 11 | 0 | 279 | 36.27783108 | -100.2733151 | 2021-02-17 05:23:10 | Lipscomb, Texas, US |
1339600 | 1339600 | 2021-02-15 | US | Kansas | Rawlins | 20153 | 286 | 7 | 0 | 279 | 39.78525843 | -101.0761617 | 2021-02-16 05:24:38 | Rawlins, Kansas, US |
1341287 | 1341287 | 2021-02-15 | US | Texas | Baylor | 48023 | 271 | 11 | 0 | 279 | 33.61640794 | -99.21352901 | 2021-02-16 05:24:38 | Baylor, Texas, US |
1341423 | 1341423 | 2021-02-15 | US | Texas | Lipscomb | 48295 | 341 | 11 | 0 | 279 | 36.27783108 | -100.2733151 | 2021-02-16 05:24:38 | Lipscomb, Texas, US |
2284751 | 2284751 | 2021-02-14 | US | Kansas | Rawlins | 20153 | 286 | 7 | 0 | 279 | 39.78525843 | -101.0761617 | 2021-02-15 05:24:49 | Rawlins, Kansas, US |
2285973 | 2285973 | 2021-02-14 | US | Oklahoma | Harmon | 40057 | 281 | 2 | 0 | 279 | 34.7440135 | -99.84741652 | 2021-02-15 05:24:49 | Harmon, Oklahoma, US |
2286438 | 2286438 | 2021-02-14 | US | Texas | Baylor | 48023 | 271 | 11 | 0 | 279 | 33.61640794 | -99.21352901 | 2021-02-15 05:24:49 | Baylor, Texas, US |
2286574 | 2286574 | 2021-02-14 | US | Texas | Lipscomb | 48295 | 341 | 11 | 0 | 279 | 36.27783108 | -100.2733151 | 2021-02-15 05:24:49 | Lipscomb, Texas, US |
2679151 | 2679151 | 2021-02-13 | US | Kansas | Rawlins | 20153 | 286 | 7 | 0 | 279 | 39.78525843 | -101.0761617 | 2021-02-14 05:23:43 | Rawlins, Kansas, US |
2680373 | 2680373 | 2021-02-13 | US | Oklahoma | Harmon | 40057 | 281 | 2 | 0 | 279 | 34.7440135 | -99.84741652 | 2021-02-14 05:23:43 | Harmon, Oklahoma, US |
2680838 | 2680838 | 2021-02-13 | US | Texas | Baylor | 48023 | 271 | 11 | 0 | 279 | 33.61640794 | -99.21352901 | 2021-02-14 05:23:43 | Baylor, Texas, US |
2680874 | 2680874 | 2021-02-13 | US | Texas | Concho | 48095 | 341 | 7 | 0 | 279 | 31.32635934 | -99.86473038 | 2021-02-14 05:23:43 | Concho, Texas, US |
2680974 | 2680974 | 2021-02-13 | US | Texas | Lipscomb | 48295 | 341 | 11 | 0 | 279 | 36.27783108 | -100.2733151 | 2021-02-14 05:23:43 | Lipscomb, Texas, US |
3540784 | 3540784 | 2021-02-12 | US | Kansas | Rawlins | 20153 | 286 | 7 | 0 | 279 | 39.78525843 | -101.0761617 | 2021-02-13 05:22:12 | Rawlins, Kansas, US |
3541821 | 3541821 | 2021-02-12 | US | North Carolina | Tyrrell | 37177 | 285 | 6 | 0 | 279 | 35.87147226 | -76.17055253 | 2021-02-13 05:22:12 | Tyrrell, North Carolina, US |
3542471 | 3542471 | 2021-02-12 | US | Texas | Baylor | 48023 | 271 | 11 | 0 | 279 | 33.61640794 | -99.21352901 | 2021-02-13 05:22:12 | Baylor, Texas, US |
3542507 | 3542507 | 2021-02-12 | US | Texas | Concho | 48095 | 341 | 7 | 0 | 279 | 31.32635934 | -99.86473038 | 2021-02-13 05:22:12 | Concho, Texas, US |
3542607 | 3542607 | 2021-02-12 | US | Texas | Lipscomb | 48295 | 341 | 11 | 0 | 279 | 36.27783108 | -100.2733151 | 2021-02-13 05:22:12 | Lipscomb, Texas, US |
2640084 | 2640084 | 2021-02-11 | US | North Carolina | Tyrrell | 37177 | 285 | 6 | 0 | 279 | 35.87147226 | -76.17055253 | 2021-02-12 05:23:29 | Tyrrell, North Carolina, US |
3980939 | 3980939 | 2021-02-10 | US | North Carolina | Tyrrell | 37177 | 285 | 6 | 0 | 279 | 35.87147226 | -76.17055253 | 2021-02-11 05:23:55 | Tyrrell, North Carolina, US |
3982088 | 3982088 | 2021-02-10 | US | West Virginia | Webster | 54101 | 279 | 0 | 0 | 279 | 38.49370949 | -80.4202023 | 2021-02-11 05:23:55 | Webster, West Virginia, US |
1591224 | 1591224 | 2021-02-05 | US | Texas | Concho | 48095 | 340 | 6 | 0 | 279 | 31.32635934 | -99.86473038 | 2021-02-06 05:23:55 | Concho, Texas, US |
791243 | 791243 | 2021-02-04 | US | Georgia | Schley | 13249 | 281 | 2 | 0 | 279 | 32.2654021 | -84.31258912 | 2021-02-05 05:22:38 | Schley, Georgia, US |
791708 | 791708 | 2021-02-04 | US | Kansas | Rawlins | 20153 | 285 | 6 | 0 | 279 | 39.78525843 | -101.0761617 | 2021-02-05 05:22:38 | Rawlins, Kansas, US |
793395 | 793395 | 2021-02-04 | US | Texas | Baylor | 48023 | 271 | 11 | 0 | 279 | 33.61640794 | -99.21352901 | 2021-02-05 05:22:38 | Baylor, Texas, US |
341600 | 341600 | 2021-02-03 | US | Kansas | Rawlins | 20153 | 285 | 6 | 0 | 279 | 39.78525843 | -101.0761617 | 2021-02-04 05:22:26 | Rawlins, Kansas, US |
343012 | 343012 | 2021-02-03 | US | Puerto Rico | Hormigueros | 72067 | 279 | 0 | 0 | 279 | 18.134532 | -67.113972 | 2021-02-04 05:22:26 | Hormigueros, Puerto Rico, US |
1685826 | 1685826 | 2021-02-02 | US | Kansas | Rawlins | 20153 | 285 | 6 | 0 | 279 | 39.78525843 | -101.0761617 | 2021-02-03 05:22:52 | Rawlins, Kansas, US |
1677796 | 1677796 | 2021-02-01 | US | Kansas | Rawlins | 20153 | 285 | 6 | 0 | 279 | 39.78525843 | -101.0761617 | 2021-02-02 05:22:49 | Rawlins, Kansas, US |
1678234 | 1678234 | 2021-02-01 | US | Minnesota | Traverse | 27155 | 283 | 4 | 0 | 279 | 45.77298854 | -96.47062949 | 2021-02-02 05:22:49 | Traverse, Minnesota, US |
1461084 | 1461084 | 2021-01-31 | US | Kansas | Rawlins | 20153 | 285 | 6 | 0 | 279 | 39.78525843 | -101.0761617 | 2021-02-01 05:22:53 | Rawlins, Kansas, US |
1461522 | 1461522 | 2021-01-31 | US | Minnesota | Traverse | 27155 | 283 | 4 | 0 | 279 | 45.77298854 | -96.47062949 | 2021-02-01 05:22:53 | Traverse, Minnesota, US |
2212992 | 2212992 | 2021-01-30 | US | Kansas | Rawlins | 20153 | 285 | 6 | 0 | 279 | 39.78525843 | -101.0761617 | 2021-01-31 05:22:42 | Rawlins, Kansas, US |
1898479 | 1898479 | 2021-01-29 | US | Kansas | Rawlins | 20153 | 285 | 6 | 0 | 279 | 39.78525843 | -101.0761617 | 2021-01-30 05:22:49 | Rawlins, Kansas, US |
2482389 | 2482389 | 2021-01-28 | US | Alaska | Ketchikan Gateway | 2130 | 280 | 1 | 0 | 279 | 55.57445008 | -130.975561 | 2021-01-29 05:22:23 | Ketchikan Gateway, Alaska, US |
2483295 | 2483295 | 2021-01-28 | US | Kansas | Rawlins | 20153 | 285 | 6 | 0 | 279 | 39.78525843 | -101.0761617 | 2021-01-29 05:22:23 | Rawlins, Kansas, US |
3154930 | 3154930 | 2021-01-27 | US | Kansas | Rawlins | 20153 | 285 | 6 | 0 | 279 | 39.78525843 | -101.0761617 | 2021-01-28 05:22:24 | Rawlins, Kansas, US |
3155611 | 3155611 | 2021-01-27 | US | Montana | Musselshell | 30065 | 287 | 8 | 0 | 279 | 46.49684637 | -108.39498 | 2021-01-28 05:22:24 | Musselshell, Montana, US |
3156484 | 3156484 | 2021-01-27 | US | South Dakota | Marshall | 46091 | 284 | 5 | 0 | 279 | 45.75870838 | -97.59855639 | 2021-01-28 05:22:24 | Marshall, South Dakota, US |
3156930 | 3156930 | 2021-01-27 | US | Virginia | Falls Church | 51610 | 285 | 6 | 0 | 279 | 38.88485255 | -77.17560759 | 2021-01-28 05:22:24 | Falls Church, Virginia, US |
14346 | 14346 | 2021-01-26 | US | Montana | Musselshell | 30065 | 287 | 8 | 0 | 279 | 46.49684637 | -108.39498 | 2021-01-27 05:23:41 | Musselshell, Montana, US |
15103 | 15103 | 2021-01-26 | US | Puerto Rico | Rincon | 72117 | 279 | 0 | 0 | 279 | 18.335443 | -67.23174 | 2021-01-27 05:23:41 | Rincon, Puerto Rico, US |
2571099 | 2571099 | 2021-01-25 | US | Washington | Jefferson | 53031 | 281 | 2 | 0 | 279 | 47.75003077 | -123.56097040000002 | 2021-01-26 05:22:02 | Jefferson, Washington, US |
1762731 | 1762731 | 2021-01-24 | US | Washington | Jefferson | 53031 | 281 | 2 | 0 | 279 | 47.75003077 | -123.56097040000002 | 2021-01-25 05:22:16 | Jefferson, Washington, US |
2430338 | 2430338 | 2021-01-23 | US | Washington | Jefferson | 53031 | 281 | 2 | 0 | 279 | 47.75003077 | -123.56097040000002 | 2021-01-24 05:22:35 | Jefferson, Washington, US |
436658 | 436658 | 2021-01-21 | US | Kansas | Logan | 20109 | 285 | 6 | 0 | 279 | 38.91735806 | -101.148475 | 2021-01-22 05:22:10 | Logan, Kansas, US |
1095389 | 1095389 | 2021-01-20 | US | Kansas | Logan | 20109 | 285 | 6 | 0 | 279 | 38.91735806 | -101.148475 | 2021-01-21 05:22:01 | Logan, Kansas, US |
1096275 | 1096275 | 2021-01-20 | US | New Mexico | Hidalgo | 35023 | 288 | 9 | 0 | 279 | 31.91383467 | -108.7151824 | 2021-01-21 05:22:01 | Hidalgo, New Mexico, US |
1096858 | 1096858 | 2021-01-20 | US | Puerto Rico | Santa Isabel | 72133 | 279 | 0 | 0 | 279 | 17.994525 | -66.388913 | 2021-01-21 05:22:01 | Santa Isabel, Puerto Rico, US |
910365 | 910365 | 2021-01-19 | US | New Mexico | Hidalgo | 35023 | 288 | 9 | 0 | 279 | 31.91383467 | -108.7151824 | 2021-01-20 05:21:54 | Hidalgo, New Mexico, US |
911409 | 911409 | 2021-01-19 | US | Texas | Upton | 48461 | 247 | 7 | 0 | 279 | 31.36868194 | -102.0423217 | 2021-01-20 05:21:54 | Upton, Texas, US |
238181 | 238181 | 2021-01-18 | US | Idaho | Oneida | 16071 | 282 | 3 | 0 | 279 | 42.19494279999999 | -112.5407838 | 2021-01-19 05:22:15 | Oneida, Idaho, US |
239428 | 239428 | 2021-01-18 | US | New Mexico | Hidalgo | 35023 | 288 | 9 | 0 | 279 | 31.91383467 | -108.7151824 | 2021-01-19 05:22:15 | Hidalgo, New Mexico, US |
240472 | 240472 | 2021-01-18 | US | Texas | Upton | 48461 | 247 | 7 | 0 | 279 | 31.36868194 | -102.0423217 | 2021-01-19 05:22:15 | Upton, Texas, US |
3504298 | 3504298 | 2021-01-17 | US | Idaho | Oneida | 16071 | 282 | 3 | 0 | 279 | 42.19494279999999 | -112.5407838 | 2021-01-18 05:22:34 | Oneida, Idaho, US |
3506589 | 3506589 | 2021-01-17 | US | Texas | Upton | 48461 | 247 | 7 | 0 | 279 | 31.36868194 | -102.0423217 | 2021-01-18 05:22:34 | Upton, Texas, US |
3102084 | 3102084 | 2021-01-16 | US | Colorado | Saguache | 8109 | 294 | 4 | 0 | 279 | 38.08054629 | -106.282466 | 2021-01-17 05:22:17 | Saguache, Colorado, US |
3102381 | 3102381 | 2021-01-16 | US | Idaho | Oneida | 16071 | 282 | 3 | 0 | 279 | 42.19494279999999 | -112.5407838 | 2021-01-17 05:22:17 | Oneida, Idaho, US |
3104672 | 3104672 | 2021-01-16 | US | Texas | Upton | 48461 | 247 | 7 | 0 | 279 | 31.36868194 | -102.0423217 | 2021-01-17 05:22:17 | Upton, Texas, US |
3880034 | 3880034 | 2021-01-14 | US | Arkansas | Calhoun | 5013 | 280 | 1 | 0 | 279 | 33.55598792 | -92.49974403 | 2021-01-15 05:22:24 | Calhoun, Arkansas, US |
3881433 | 3881433 | 2021-01-14 | US | Missouri | Atchison | 29005 | 285 | 6 | 0 | 279 | 40.43238737 | -95.42970639 | 2021-01-15 05:22:24 | Atchison, Missouri, US |
3310060 | 3310060 | 2021-01-13 | US | Missouri | Atchison | 29005 | 285 | 6 | 0 | 279 | 40.43238737 | -95.42970639 | 2021-01-14 05:22:32 | Atchison, Missouri, US |
191926 | 191926 | 2021-01-11 | US | Missouri | Atchison | 29005 | 284 | 5 | 0 | 279 | 40.43238737 | -95.42970639 | 2021-01-12 05:22:15 | Atchison, Missouri, US |
192189 | 192189 | 2021-01-11 | US | Nebraska | Webster | 31181 | 283 | 4 | 0 | 279 | 40.17642643 | -98.50019851 | 2021-01-12 05:22:15 | Webster, Nebraska, US |
193122 | 193122 | 2021-01-11 | US | Texas | Culberson | 48109 | 257 | 4 | 0 | 279 | 31.44506775 | -104.5185739 | 2021-01-12 05:22:15 | Culberson, Texas, US |
2627992 | 2627992 | 2021-01-10 | US | Nebraska | Webster | 31181 | 283 | 4 | 0 | 279 | 40.17642643 | -98.50019851 | 2021-01-11 05:21:50 | Webster, Nebraska, US |
2628925 | 2628925 | 2021-01-10 | US | Texas | Culberson | 48109 | 257 | 4 | 0 | 279 | 31.44506775 | -104.5185739 | 2021-01-11 05:21:50 | Culberson, Texas, US |
3902080 | 3902080 | 2021-01-09 | US | Nebraska | Webster | 31181 | 283 | 4 | 0 | 279 | 40.17642643 | -98.50019851 | 2021-01-10 05:22:12 | Webster, Nebraska, US |
3903013 | 3903013 | 2021-01-09 | US | Texas | Culberson | 48109 | 257 | 4 | 0 | 279 | 31.44506775 | -104.5185739 | 2021-01-10 05:22:12 | Culberson, Texas, US |
3903425 | 3903425 | 2021-01-09 | US | West Virginia | Clay | 54015 | 283 | 4 | 0 | 279 | 38.46231092 | -81.07652217 | 2021-01-10 05:22:12 | Clay, West Virginia, US |
156103 | 156103 | 2021-01-08 | US | Nebraska | Webster | 31181 | 283 | 4 | 0 | 279 | 40.17642643 | -98.50019851 | 2021-01-09 05:22:18 | Webster, Nebraska, US |
2865622 | 2865622 | 2021-01-06 | US | Idaho | Adams | 16003 | 282 | 3 | 0 | 279 | 44.89333571 | -116.4545247 | 2021-01-07 05:22:03 | Adams, Idaho, 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]);