johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
150 rows where active = 1375 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3137786 | 3137786 | 2021-07-23 | Russia | Orel Oblast | 39504 | 812 | 37317 | 1375 | 52.96854329999999 | 36.0692477 | 2021-07-24 00:21:36 | Orel Oblast, Russia | ||
2339660 | 2339660 | 2021-06-15 | Russia | Zabaykalsky Krai | 44117 | 688 | 42054 | 1375 | 52.248521 | 115.956325 | 2021-06-16 04:22:32 | Zabaykalsky Krai, Russia | ||
2589627 | 2589627 | 2021-06-05 | Ukraine | Vinnytsia Oblast | 70673 | 1671 | 67627 | 1375 | 49.2331 | 28.4682 | 2021-06-06 04:24:03 | Vinnytsia Oblast, Ukraine | ||
1842198 | 1842198 | 2021-04-14 | Russia | Tyumen Oblast | 34329 | 430 | 32524 | 1375 | 58.8206488 | 70.36588370000001 | 2021-04-15 04:20:54 | Tyumen Oblast, Russia | ||
2983017 | 2983017 | 2021-04-10 | Cabo Verde | 18629 | 177 | 17077 | 1375 | 16.5388 | -23.0418 | 2021-04-11 04:20:56 | Cabo Verde | |||
605449 | 605449 | 2021-04-09 | Cabo Verde | 18629 | 177 | 17077 | 1375 | 16.5388 | -23.0418 | 2021-04-10 04:20:59 | Cabo Verde | |||
1884603 | 1884603 | 2021-03-26 | Ukraine | Crimea Republic* | 37283 | 1049 | 34859 | 1375 | 45.2835 | 34.2008 | 2021-03-27 05:25:04 | Crimea Republic*, Ukraine | ||
2780839 | 2780839 | 2021-03-24 | Colombia | Cordoba | 41433 | 1966 | 38092 | 1375 | 8.0493 | -75.574 | 2021-03-25 05:27:00 | Cordoba, Colombia | ||
3663643 | 3663643 | 2021-03-09 | Japan | Saitama | 30223 | 638 | 28210 | 1375 | 35.997101 | 139.347635 | 2021-03-10 05:24:35 | Saitama, Japan | ||
2209362 | 2209362 | 2021-03-04 | US | Minnesota | Fillmore | 27045 | 1383 | 8 | 0 | 1375 | 43.67394126 | -92.08980382 | 2021-03-05 05:26:29 | Fillmore, Minnesota, US |
2208849 | 2208849 | 2021-03-04 | US | Iowa | Iowa | 19095 | 1398 | 23 | 0 | 1375 | 41.68630265 | -92.0643373 | 2021-03-05 05:26:29 | Iowa, Iowa, US |
3255297 | 3255297 | 2021-03-02 | US | Iowa | Allamakee | 19005 | 1422 | 47 | 0 | 1375 | 43.28383218 | -91.37860922 | 2021-03-03 05:23:28 | Allamakee, Iowa, US |
1939203 | 1939203 | 2021-02-23 | US | Puerto Rico | Mayaguez | 72097 | 1375 | 0 | 0 | 1375 | 18.2013 | -67.1452 | 2021-02-24 05:29:16 | Mayaguez, Puerto Rico, US |
1937954 | 1937954 | 2021-02-23 | US | Louisiana | LaSalle | 22059 | 1408 | 33 | 0 | 1375 | 31.67884782 | -92.15907765 | 2021-02-24 05:29:16 | LaSalle, Louisiana, US |
533998 | 533998 | 2021-02-22 | US | Virginia | Appomattox | 51011 | 1385 | 10 | 0 | 1375 | 37.37569884 | -78.81340003 | 2021-02-23 05:23:41 | Appomattox, Virginia, US |
742810 | 742810 | 2021-02-20 | US | Arkansas | Madison | 5087 | 1396 | 21 | 0 | 1375 | 36.01038185 | -93.72524943 | 2021-02-21 05:24:33 | Madison, Arkansas, US |
1155977 | 1155977 | 2021-02-18 | US | South Dakota | Dewey | 46041 | 1397 | 22 | 0 | 1375 | 45.15639647 | -100.8709139 | 2021-02-19 05:24:16 | Dewey, South Dakota, US |
3601299 | 3601299 | 2021-02-17 | Russia | Volgograd Oblast | 47180 | 707 | 45098 | 1375 | 49.6048339 | 44.29035820000001 | 2021-02-18 05:22:58 | Volgograd Oblast, Russia | ||
3052109 | 3052109 | 2021-02-16 | US | Missouri | Osage | 29151 | 1387 | 12 | 0 | 1375 | 38.46036182 | -91.8613635 | 2021-02-17 05:23:10 | Osage, Missouri, US |
1340210 | 1340210 | 2021-02-15 | US | Missouri | Pemiscot | 29155 | 1401 | 26 | 0 | 1375 | 36.2130572 | -89.78742322 | 2021-02-16 05:24:38 | Pemiscot, Missouri, US |
1340208 | 1340208 | 2021-02-15 | US | Missouri | Osage | 29151 | 1387 | 12 | 0 | 1375 | 38.46036182 | -91.8613635 | 2021-02-16 05:24:38 | Osage, Missouri, US |
2285361 | 2285361 | 2021-02-14 | US | Missouri | Pemiscot | 29155 | 1401 | 26 | 0 | 1375 | 36.2130572 | -89.78742322 | 2021-02-15 05:24:49 | Pemiscot, Missouri, US |
3980512 | 3980512 | 2021-02-10 | US | Missouri | Pemiscot | 29155 | 1400 | 25 | 0 | 1375 | 36.2130572 | -89.78742322 | 2021-02-11 05:23:55 | Pemiscot, Missouri, US |
1529359 | 1529359 | 2021-02-09 | US | Kentucky | Spencer | 21215 | 1380 | 5 | 0 | 1375 | 38.03223971 | -85.32749335 | 2021-02-10 05:22:41 | Spencer, Kentucky, US |
615623 | 615623 | 2021-02-08 | US | Missouri | Pemiscot | 29155 | 1400 | 25 | 0 | 1375 | 36.2130572 | -89.78742322 | 2021-02-09 05:23:30 | Pemiscot, Missouri, US |
1674392 | 1674392 | 2021-02-07 | US | Missouri | Pemiscot | 29155 | 1400 | 25 | 0 | 1375 | 36.2130572 | -89.78742322 | 2021-02-08 05:22:39 | Pemiscot, Missouri, US |
1673664 | 1673664 | 2021-02-07 | US | Iowa | Lyon | 19119 | 1412 | 37 | 0 | 1375 | 43.38107862 | -96.20926845 | 2021-02-08 05:22:39 | Lyon, Iowa, US |
791696 | 791696 | 2021-02-04 | US | Kansas | Nemaha | 20131 | 1426 | 51 | 0 | 1375 | 39.78345387 | -96.01392079 | 2021-02-05 05:22:38 | Nemaha, Kansas, US |
341588 | 341588 | 2021-02-03 | US | Kansas | Nemaha | 20131 | 1426 | 51 | 0 | 1375 | 39.78345387 | -96.01392079 | 2021-02-04 05:22:26 | Nemaha, Kansas, US |
1685727 | 1685727 | 2021-02-02 | US | Iowa | Poweshiek | 19157 | 1402 | 27 | 0 | 1375 | 41.68625425 | -92.53155731 | 2021-02-03 05:22:52 | Poweshiek, Iowa, US |
1898779 | 1898779 | 2021-01-29 | US | Michigan | Gladwin | 26051 | 1416 | 41 | 0 | 1375 | 43.98901072 | -84.38774817 | 2021-01-30 05:22:49 | Gladwin, Michigan, US |
3155729 | 3155729 | 2021-01-27 | US | Nebraska | York | 31185 | 1384 | 9 | 0 | 1375 | 40.87272618 | -97.59710186 | 2021-01-28 05:22:24 | York, Nebraska, US |
2469533 | 2469533 | 2021-01-22 | US | Puerto Rico | Dorado | 72051 | 1375 | 0 | 0 | 1375 | 18.436115 | -66.278669 | 2021-01-23 05:22:03 | Dorado, Puerto Rico, US |
2467063 | 2467063 | 2021-01-22 | Russia | Volgograd Oblast | 41144 | 564 | 39205 | 1375 | 49.6048339 | 44.29035820000001 | 2021-01-23 05:22:03 | Volgograd Oblast, Russia | ||
436606 | 436606 | 2021-01-21 | US | Kansas | Atchison | 20005 | 1387 | 12 | 0 | 1375 | 39.53185661 | -95.30870026 | 2021-01-22 05:22:10 | Atchison, Kansas, US |
1095337 | 1095337 | 2021-01-20 | US | Kansas | Atchison | 20005 | 1387 | 12 | 0 | 1375 | 39.53185661 | -95.30870026 | 2021-01-21 05:22:01 | Atchison, Kansas, US |
3104955 | 3104955 | 2021-01-16 | US | West Virginia | Wyoming | 54109 | 1399 | 24 | 0 | 1375 | 37.612327 | -81.54511071 | 2021-01-17 05:22:17 | Wyoming, West Virginia, US |
3102275 | 3102275 | 2021-01-16 | US | Georgia | Meriwether | 13199 | 1398 | 23 | 0 | 1375 | 33.04163534 | -84.68859732 | 2021-01-17 05:22:17 | Meriwether, Georgia, US |
3517683 | 3517683 | 2021-01-15 | US | North Carolina | Bertie | 37015 | 1402 | 27 | 0 | 1375 | 36.0688473 | -76.96545943 | 2021-01-16 05:22:40 | Bertie, North Carolina, US |
776785 | 776785 | 2021-01-12 | US | Ohio | Carroll | 39019 | 1406 | 31 | 0 | 1375 | 40.5789686 | -81.09178213 | 2021-01-13 05:22:15 | Carroll, Ohio, US |
775615 | 775615 | 2021-01-12 | US | Kansas | Dickinson | 20041 | 1393 | 18 | 0 | 1375 | 38.86600962 | -97.15532383 | 2021-01-13 05:22:15 | Dickinson, Kansas, US |
775309 | 775309 | 2021-01-12 | US | Illinois | Clark | 17023 | 1400 | 25 | 0 | 1375 | 39.33425789 | -87.78705622 | 2021-01-13 05:22:15 | Clark, Illinois, US |
191336 | 191336 | 2021-01-11 | US | Kansas | Dickinson | 20041 | 1393 | 18 | 0 | 1375 | 38.86600962 | -97.15532383 | 2021-01-12 05:22:15 | Dickinson, Kansas, US |
190889 | 190889 | 2021-01-11 | US | Georgia | Lamar | 13171 | 1410 | 35 | 0 | 1375 | 33.07841647 | -84.14263877 | 2021-01-12 05:22:15 | Lamar, Georgia, US |
190455 | 190455 | 2021-01-11 | US | Alabama | Monroe | 1099 | 1387 | 12 | 0 | 1375 | 31.56729412 | -87.36995001 | 2021-01-12 05:22:15 | Monroe, Alabama, US |
2542331 | 2542331 | 2021-01-07 | US | Idaho | Elmore | 16039 | 1384 | 9 | 0 | 1375 | 43.3507101 | -115.4701578 | 2021-01-08 05:22:42 | Elmore, Idaho, US |
1062909 | 1062909 | 2021-01-04 | US | Indiana | Carroll | 18015 | 1389 | 14 | 0 | 1375 | 40.580783200000006 | -86.56198812 | 2021-01-05 05:21:49 | Carroll, Indiana, US |
2228763 | 2228763 | 2021-01-02 | US | Iowa | Winneshiek | 19191 | 1393 | 18 | 0 | 1375 | 43.29094334 | -91.84422722 | 2021-01-03 05:22:52 | Winneshiek, Iowa, US |
2227986 | 2227986 | 2021-01-02 | US | Arkansas | Conway | 5029 | 1391 | 16 | 0 | 1375 | 35.26205537 | -92.70506566 | 2021-01-03 05:22:52 | Conway, Arkansas, US |
1013361 | 1013361 | 2020-12-30 | US | Texas | Dawson | 48115 | 944 | 47 | 0 | 1375 | 32.74255572 | -101.9477242 | 2020-12-31 05:22:49 | Dawson, Texas, US |
1012916 | 1012916 | 2020-12-30 | US | Oregon | Jefferson | 41031 | 1392 | 17 | 0 | 1375 | 44.62806839 | -121.17832 | 2020-12-31 05:22:49 | Jefferson, Oregon, US |
3693697 | 3693697 | 2020-12-24 | US | New York | Columbia | 36021 | 1435 | 60 | 0 | 1375 | 42.24819348 | -73.63089095 | 2020-12-25 05:22:48 | Columbia, New York, US |
3692326 | 3692326 | 2020-12-24 | US | Georgia | Peach | 13225 | 1405 | 30 | 0 | 1375 | 32.56934316 | -83.82937 | 2020-12-25 05:22:48 | Peach, Georgia, US |
928158 | 928158 | 2020-12-21 | US | Arkansas | Columbia | 5027 | 1413 | 38 | 0 | 1375 | 33.21230701 | -93.22642793 | 2020-12-22 05:22:33 | Columbia, Arkansas, US |
1901920 | 1901920 | 2020-12-18 | US | Georgia | Butts | 13035 | 1422 | 47 | 0 | 1375 | 33.283094500000004 | -83.95435040000002 | 2020-12-19 05:27:52 | Butts, Georgia, US |
3153170 | 3153170 | 2020-12-16 | US | Wisconsin | Vernon | 55123 | 1395 | 20 | 0 | 1375 | 43.59422667 | -90.8324691 | 2020-12-17 05:28:12 | Vernon, Wisconsin, US |
847387 | 847387 | 2020-12-12 | US | Mississippi | Marion | 28091 | 1429 | 54 | 0 | 1375 | 31.23132643 | -89.8209217 | 2020-12-13 05:27:20 | Marion, Mississippi, US |
845961 | 845961 | 2020-12-12 | US | Alabama | Pickens | 1107 | 1399 | 24 | 0 | 1375 | 33.28094866 | -88.08818103 | 2020-12-13 05:27:20 | Pickens, Alabama, US |
861059 | 861059 | 2020-12-11 | US | Alabama | Marengo | 1091 | 1400 | 25 | 0 | 1375 | 32.24767634 | -87.78796182 | 2020-12-12 05:26:19 | Marengo, Alabama, US |
1601582 | 1601582 | 2020-12-10 | US | Kentucky | Boyle | 21021 | 1375 | 0 | 0 | 1375 | 37.62680923 | -84.8633779 | 2020-12-11 05:26:59 | Boyle, Kentucky, US |
2976641 | 2976641 | 2020-12-09 | US | Kentucky | Knox | 21121 | 1385 | 10 | 0 | 1375 | 36.89225732 | -83.85403396 | 2020-12-10 05:26:19 | Knox, Kentucky, US |
2976474 | 2976474 | 2020-12-09 | US | Iowa | Wright | 19197 | 1383 | 8 | 0 | 1375 | 42.73305373 | -93.73515113 | 2020-12-10 05:26:19 | Wright, Iowa, US |
3861758 | 3861758 | 2020-12-04 | US | Missouri | New Madrid | 29143 | 1399 | 24 | 0 | 1375 | 36.59666326 | -89.66070007 | 2020-12-05 05:27:36 | New Madrid, Missouri, US |
77861 | 77861 | 2020-12-03 | US | Puerto Rico | Trujillo Alto | 72139 | 1375 | 0 | 0 | 1375 | 18.336159 | -65.99888399999999 | 2020-12-04 05:27:27 | Trujillo Alto, Puerto Rico, US |
2538926 | 2538926 | 2020-12-01 | US | Louisiana | Union | 22111 | 1432 | 57 | 0 | 1375 | 32.83121059 | -92.3749373 | 2020-12-02 05:27:41 | Union, Louisiana, US |
1585697 | 1585697 | 2020-11-30 | US | Louisiana | Vernon | 22115 | 1438 | 63 | 0 | 1375 | 31.10884837 | -93.18153838 | 2020-12-01 05:26:18 | Vernon, Louisiana, US |
1975569 | 1975569 | 2020-11-25 | US | Tennessee | Smith | 47159 | 1391 | 19 | 0 | 1375 | 36.25359775 | -85.95411046 | 2020-11-26 05:27:44 | Smith, Tennessee, US |
1975534 | 1975534 | 2020-11-25 | US | Tennessee | Johnson | 47091 | 1383 | 21 | 0 | 1375 | 36.45523950000001 | -81.84886538 | 2020-11-26 05:27:44 | Johnson, Tennessee, US |
1973761 | 1973761 | 2020-11-25 | US | Iowa | Delaware | 19055 | 1396 | 21 | 0 | 1375 | 42.47104597 | -91.3664492 | 2020-11-26 05:27:44 | Delaware, Iowa, US |
1352148 | 1352148 | 2020-11-24 | US | Mississippi | Prentiss | 28117 | 1404 | 29 | 0 | 1375 | 34.61810501 | -88.51986294 | 2020-11-25 05:27:20 | Prentiss, Mississippi, US |
679783 | 679783 | 2020-11-23 | US | Kentucky | Whitley | 21235 | 1383 | 8 | 0 | 1375 | 36.75700531 | -84.14541217 | 2020-11-24 05:27:31 | Whitley, Kentucky, US |
3836442 | 3836442 | 2020-11-21 | India | Nagaland | 10674 | 57 | 9242 | 1375 | 26.06702 | 94.470302 | 2020-11-22 05:25:45 | Nagaland, India | ||
823343 | 823343 | 2020-11-19 | US | Mississippi | Alcorn | 28003 | 1398 | 23 | 0 | 1375 | 34.88084463 | -88.57996173 | 2020-11-20 05:26:28 | Alcorn, Mississippi, US |
822149 | 822149 | 2020-11-19 | US | California | Tehama | 6103 | 1383 | 9 | 0 | 1375 | 40.12570935 | -122.2370171 | 2020-11-20 05:26:28 | Tehama, California, US |
126244 | 126244 | 2020-11-18 | US | Wisconsin | Jackson | 55053 | 1379 | 4 | 0 | 1375 | 44.31864893 | -90.80566792 | 2020-11-19 05:25:23 | Jackson, Wisconsin, US |
125506 | 125506 | 2020-11-18 | US | South Carolina | Colleton | 45029 | 1424 | 49 | 0 | 1375 | 32.87582989 | -80.67641292 | 2020-11-19 05:25:23 | Colleton, South Carolina, US |
2917691 | 2917691 | 2020-11-14 | US | Ohio | Union | 39159 | 1384 | 9 | 0 | 1375 | 40.30016061 | -83.37239023 | 2020-11-15 05:26:53 | Union, Ohio, US |
2788190 | 2788190 | 2020-11-13 | US | Texas | Polk | 48373 | 1546 | 41 | 0 | 1375 | 30.79472531 | -94.8276624 | 2020-11-14 05:25:37 | Polk, Texas, US |
2787809 | 2787809 | 2020-11-13 | US | South Carolina | Dillon | 45033 | 1424 | 49 | 0 | 1375 | 34.39007791 | -79.37741872 | 2020-11-14 05:25:37 | Dillon, South Carolina, US |
867955 | 867955 | 2020-11-12 | US | Texas | Polk | 48373 | 1545 | 41 | 0 | 1375 | 30.79472531 | -94.8276624 | 2020-11-13 05:25:30 | Polk, Texas, US |
273223 | 273223 | 2020-11-10 | US | Indiana | Dearborn | 18029 | 1406 | 31 | 0 | 1375 | 39.14647946 | -84.97333539 | 2020-11-11 05:25:30 | Dearborn, Indiana, US |
1729216 | 1729216 | 2020-11-08 | US | Florida | Wakulla | 12129 | 1386 | 11 | 0 | 1375 | 30.16548905 | -84.39895211 | 2020-11-09 05:25:45 | Wakulla, Florida, US |
3305978 | 3305978 | 2020-11-02 | US | Mississippi | Copiah | 28029 | 1413 | 38 | 0 | 1375 | 31.86977774 | -90.44565118 | 2020-11-03 06:00:16 | Copiah, Mississippi, US |
2080185 | 2080185 | 2020-10-31 | Russia | Udmurt Republic | 8870 | 170 | 7325 | 1375 | 57.1961165 | 52.69598320000001 | 2020-11-01 04:36:19 | Udmurt Republic, Russia | ||
2246697 | 2246697 | 2020-10-30 | US | Virginia | Culpeper | 51047 | 1393 | 18 | 0 | 1375 | 38.48199985 | -77.95630870000002 | 2020-10-31 04:24:44 | Culpeper, Virginia, US |
756873 | 756873 | 2020-10-28 | US | Oklahoma | Osage | 40113 | 1388 | 13 | 0 | 1375 | 36.62888819 | -96.39635704 | 2020-10-29 04:24:49 | Osage, Oklahoma, US |
754407 | 754407 | 2020-10-28 | Mexico | Zacatecas | 10663 | 905 | 8383 | 1375 | 22.7709 | -102.5832 | 2020-10-29 04:24:49 | Zacatecas, Mexico | ||
1453747 | 1453747 | 2020-10-27 | US | Iowa | Cerro Gordo | 19033 | 1402 | 27 | 0 | 1375 | 43.08177563 | -93.2612239 | 2020-10-28 04:24:39 | Cerro Gordo, Iowa, US |
3481801 | 3481801 | 2020-10-26 | US | Louisiana | Evangeline | 22039 | 1414 | 39 | 0 | 1375 | 30.72985248 | -92.39915924 | 2020-10-27 04:24:45 | Evangeline, Louisiana, US |
10856 | 10856 | 2020-10-25 | US | Oklahoma | Cherokee | 40021 | 1383 | 8 | 0 | 1375 | 35.90692775 | -94.99980896 | 2020-10-26 04:25:02 | Cherokee, Oklahoma, US |
3654399 | 3654399 | 2020-10-24 | US | South Carolina | Williamsburg | 45089 | 1424 | 49 | 0 | 1375 | 33.62190129 | -79.72767442 | 2020-10-25 04:24:36 | Williamsburg, South Carolina, US |
1054346 | 1054346 | 2020-10-23 | US | Arkansas | White | 5145 | 1407 | 32 | 0 | 1375 | 35.25688493 | -91.74908296 | 2020-10-24 04:24:46 | White, Arkansas, US |
3993705 | 3993705 | 2020-10-20 | US | Texas | Hardin | 48199 | 848 | 34 | 0 | 1375 | 30.33364686 | -94.38931817 | 2020-10-21 04:24:14 | Hardin, Texas, US |
789318 | 789318 | 2020-10-15 | US | Tennessee | Jefferson | 47089 | 1411 | 18 | 0 | 1375 | 36.04818632 | -83.45148924 | 2020-10-16 04:24:01 | Jefferson, Tennessee, US |
788545 | 788545 | 2020-10-15 | US | New Jersey | Warren | 34041 | 1546 | 171 | 0 | 1375 | 40.85951833 | -74.99556527 | 2020-10-16 04:24:01 | Warren, New Jersey, US |
80580 | 80580 | 2020-10-14 | US | Louisiana | Iberville | 22047 | 1433 | 58 | 0 | 1375 | 30.25734305 | -91.3499598 | 2020-10-15 04:24:28 | Iberville, Louisiana, US |
2291289 | 2291289 | 2020-10-12 | Colombia | Cordoba | 24981 | 1580 | 22026 | 1375 | 8.0493 | -75.574 | 2020-10-13 04:24:02 | Cordoba, Colombia | ||
3789341 | 3789341 | 2020-10-11 | US | Washington | Thurston | 53067 | 1394 | 19 | 0 | 1375 | 46.9291895 | -122.8290656 | 2020-10-12 04:23:45 | Thurston, Washington, US |
3786843 | 3786843 | 2020-10-11 | US | Illinois | Boone | 17007 | 1399 | 24 | 0 | 1375 | 42.32359279 | -88.82345779 | 2020-10-12 04:23:45 | Boone, Illinois, US |
2515406 | 2515406 | 2020-10-03 | US | Iowa | Webster | 19187 | 1389 | 14 | 0 | 1375 | 42.42853483 | -94.17987389 | 2020-10-04 04:23:44 | Webster, Iowa, 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]);