johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
180 rows where active = 1288 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3015533 | 3015533 | 2021-08-01 | Romania | 1083341 | 34286 | 1047767 | 1288 | 45.9432 | 24.9668 | 2021-08-02 04:21:36 | Romania | |||
1378456 | 1378456 | 2021-07-25 | India | Jammu and Kashmir | 320657 | 4374 | 314995 | 1288 | 33.75943 | 76.612638 | 2021-07-26 04:21:28 | Jammu and Kashmir, India | ||
2295656 | 2295656 | 2021-06-24 | Russia | Kaluga Oblast | 36950 | 365 | 35297 | 1288 | 54.4382773 | 35.5272854 | 2021-06-25 04:21:33 | Kaluga Oblast, Russia | ||
829222 | 829222 | 2021-06-06 | Ukraine | Vinnytsia Oblast | 70689 | 1672 | 67729 | 1288 | 49.2331 | 28.4682 | 2021-06-07 04:22:51 | Vinnytsia Oblast, Ukraine | ||
1568337 | 1568337 | 2021-04-22 | Russia | Omsk Oblast | 45246 | 1370 | 42588 | 1288 | 56.09352629999999 | 73.5099936 | 2021-04-23 04:20:52 | Omsk Oblast, Russia | ||
3643391 | 3643391 | 2021-03-30 | Colombia | Caldas | 49397 | 1014 | 47095 | 1288 | 5.2983 | -75.2479 | 2021-03-31 04:26:25 | Caldas, Colombia | ||
1290236 | 1290236 | 2021-03-29 | Russia | Novosibirsk Oblast | 38609 | 1614 | 35707 | 1288 | 54.9720169 | 79.48139240000002 | 2021-03-30 04:26:23 | Novosibirsk Oblast, Russia | ||
1219683 | 1219683 | 2021-03-27 | Nepal | 276750 | 3027 | 272435 | 1288 | 28.1667 | 84.25 | 2021-03-28 05:28:10 | Nepal | |||
3420706 | 3420706 | 2021-03-19 | Chile | Coquimbo | 24602 | 469 | 22845 | 1288 | -29.959 | -71.3389 | 2021-03-20 05:25:46 | Coquimbo, Chile | ||
3670469 | 3670469 | 2021-03-06 | US | South Dakota | Charles Mix | 46023 | 1309 | 21 | 0 | 1288 | 43.20660134 | -98.58856175 | 2021-03-07 05:21:54 | Charles Mix, South Dakota, US |
2208469 | 2208469 | 2021-03-04 | US | Georgia | Jasper | 13159 | 1321 | 33 | 0 | 1288 | 33.31535543 | -83.68844964 | 2021-03-05 05:26:29 | Jasper, Georgia, US |
3255332 | 3255332 | 2021-03-02 | US | Iowa | Grundy | 19075 | 1318 | 30 | 0 | 1288 | 42.40183723 | -92.78829551 | 2021-03-03 05:23:28 | Grundy, Iowa, US |
999484 | 999484 | 2021-03-01 | US | Illinois | Wabash | 17185 | 1300 | 12 | 0 | 1288 | 38.44272901 | -87.84922065 | 2021-03-02 05:23:30 | Wabash, Illinois, US |
998386 | 998386 | 2021-03-01 | India | Haryana | 270950 | 3050 | 266612 | 1288 | 29.20004 | 76.332824 | 2021-03-02 05:23:30 | Haryana, India | ||
2368542 | 2368542 | 2021-02-28 | US | Illinois | Wabash | 17185 | 1300 | 12 | 0 | 1288 | 38.44272901 | -87.84922065 | 2021-03-01 05:23:01 | Wabash, Illinois, US |
3067044 | 3067044 | 2021-02-27 | US | Illinois | Wabash | 17185 | 1300 | 12 | 0 | 1288 | 38.44272901 | -87.84922065 | 2021-02-28 05:22:20 | Wabash, Illinois, US |
3066244 | 3066244 | 2021-02-27 | Russia | Smolensk Oblast | 26131 | 612 | 24231 | 1288 | 55.03434960000001 | 33.0192065 | 2021-02-28 05:22:20 | Smolensk Oblast, Russia | ||
282099 | 282099 | 2021-02-24 | US | Missouri | Livingston | 29117 | 1325 | 37 | 0 | 1288 | 39.78110272 | -93.54645978 | 2021-02-25 05:24:57 | Livingston, Missouri, US |
1938676 | 1938676 | 2021-02-23 | US | New York | Essex | 36031 | 1314 | 26 | 0 | 1288 | 44.11630765 | -73.77297842 | 2021-02-24 05:29:16 | Essex, New York, US |
1938547 | 1938547 | 2021-02-23 | US | Nebraska | Otoe | 31131 | 1295 | 7 | 0 | 1288 | 40.64843556 | -96.13374142 | 2021-02-24 05:29:16 | Otoe, Nebraska, US |
1938367 | 1938367 | 2021-02-23 | US | Missouri | Livingston | 29117 | 1325 | 37 | 0 | 1288 | 39.78110272 | -93.54645978 | 2021-02-24 05:29:16 | Livingston, Missouri, US |
1937921 | 1937921 | 2021-02-23 | US | Kentucky | Washington | 21229 | 1317 | 29 | 0 | 1288 | 37.75599461 | -85.17407732 | 2021-02-24 05:29:16 | Washington, Kentucky, US |
532802 | 532802 | 2021-02-22 | US | Nebraska | Otoe | 31131 | 1295 | 7 | 0 | 1288 | 40.64843556 | -96.13374142 | 2021-02-23 05:23:41 | Otoe, Nebraska, US |
532622 | 532622 | 2021-02-22 | US | Missouri | Livingston | 29117 | 1324 | 36 | 0 | 1288 | 39.78110272 | -93.54645978 | 2021-02-23 05:23:41 | Livingston, Missouri, US |
531731 | 531731 | 2021-02-22 | US | Illinois | Piatt | 17147 | 1302 | 14 | 0 | 1288 | 40.01360584 | -88.59319339 | 2021-02-23 05:23:41 | Piatt, Illinois, US |
183956 | 183956 | 2021-02-21 | US | Missouri | Livingston | 29117 | 1324 | 36 | 0 | 1288 | 39.78110272 | -93.54645978 | 2021-02-22 05:24:21 | Livingston, Missouri, US |
474980 | 474980 | 2021-02-19 | US | Wisconsin | Richland | 55103 | 1301 | 13 | 0 | 1288 | 43.3762778 | -90.43012729 | 2021-02-20 05:22:51 | Richland, Wisconsin, US |
473742 | 473742 | 2021-02-19 | US | North Carolina | Madison | 37115 | 1320 | 32 | 0 | 1288 | 35.85402722 | -82.71346418 | 2021-02-20 05:22:51 | Madison, North Carolina, US |
3052729 | 3052729 | 2021-02-16 | US | Oklahoma | Johnston | 40069 | 1305 | 17 | 0 | 1288 | 34.31440473 | -96.66011537 | 2021-02-17 05:23:10 | Johnston, Oklahoma, US |
3981294 | 3981294 | 2021-02-10 | US | Puerto Rico | Canovanas | 72029 | 1288 | 0 | 0 | 1288 | 18.328802 | -65.887612 | 2021-02-11 05:23:55 | Canovanas, Puerto Rico, US |
1530614 | 1530614 | 2021-02-09 | US | Puerto Rico | Canovanas | 72029 | 1288 | 0 | 0 | 1288 | 18.328802 | -65.887612 | 2021-02-10 05:22:41 | Canovanas, Puerto Rico, US |
616980 | 616980 | 2021-02-08 | US | Virginia | Appomattox | 51011 | 1297 | 9 | 0 | 1288 | 37.37569884 | -78.81340003 | 2021-02-09 05:23:30 | Appomattox, Virginia, US |
790741 | 790741 | 2021-02-04 | US | Alabama | Crenshaw | 1041 | 1336 | 48 | 0 | 1288 | 31.72941803 | -86.31593104 | 2021-02-05 05:22:38 | Crenshaw, Alabama, US |
341977 | 341977 | 2021-02-03 | US | Minnesota | Cottonwood | 27033 | 1307 | 19 | 0 | 1288 | 44.00715262 | -95.18138802 | 2021-02-04 05:22:26 | Cottonwood, Minnesota, US |
1685240 | 1685240 | 2021-02-02 | US | Georgia | Bacon | 13005 | 1319 | 31 | 0 | 1288 | 31.55456473 | -82.45936528 | 2021-02-03 05:22:52 | Bacon, Georgia, US |
1680148 | 1680148 | 2021-02-01 | Malaysia | Melaka | 3655 | 12 | 2355 | 1288 | 2.1896 | 102.2501 | 2021-02-02 05:22:49 | Melaka, Malaysia | ||
1463280 | 1463280 | 2021-01-31 | US | Wisconsin | Buffalo | 55011 | 1295 | 7 | 0 | 1288 | 44.37835084 | -91.75332578 | 2021-02-01 05:22:53 | Buffalo, Wisconsin, US |
1460954 | 1460954 | 2021-01-31 | US | Iowa | Iowa | 19095 | 1311 | 23 | 0 | 1288 | 41.68630265 | -92.0643373 | 2021-02-01 05:22:53 | Iowa, Iowa, US |
2215006 | 2215006 | 2021-01-30 | US | Virginia | Greensville | 51081 | 1306 | 18 | 0 | 1288 | 36.67878901 | -77.56351439 | 2021-01-31 05:22:42 | Greensville, Virginia, US |
2483678 | 2483678 | 2021-01-28 | US | Minnesota | Fillmore | 27045 | 1296 | 8 | 0 | 1288 | 43.67394126 | -92.08980382 | 2021-01-29 05:22:23 | Fillmore, Minnesota, US |
2483120 | 2483120 | 2021-01-28 | US | Iowa | Allamakee | 19005 | 1318 | 30 | 0 | 1288 | 43.28383218 | -91.37860922 | 2021-01-29 05:22:23 | Allamakee, Iowa, US |
15378 | 15378 | 2021-01-26 | US | Texas | Childress | 48075 | 1421 | 13 | 0 | 1288 | 34.529304100000004 | -100.2077916 | 2021-01-27 05:23:41 | Childress, Texas, US |
14493 | 14493 | 2021-01-26 | US | New Hampshire | Unassigned | 90033 | 1289 | 1 | 0 | 1288 | 44.69063265 | 0.0 | 2021-01-27 05:23:41 | Unassigned, New Hampshire, US |
13089 | 13089 | 2021-01-26 | US | Georgia | Brantley | 13025 | 1313 | 25 | 0 | 1288 | 31.19576557 | -81.97743999 | 2021-01-27 05:23:41 | Brantley, Georgia, US |
2429857 | 2429857 | 2021-01-23 | US | Tennessee | Lewis | 47101 | 1343 | 21 | 0 | 1288 | 35.52853208 | -87.49022694 | 2021-01-24 05:22:35 | Lewis, Tennessee, US |
2429129 | 2429129 | 2021-01-23 | US | New York | Franklin | 36033 | 1297 | 9 | 0 | 1288 | 44.59040891 | -74.29926032 | 2021-01-24 05:22:35 | Franklin, New York, US |
2468502 | 2468502 | 2021-01-22 | US | Minnesota | Chippewa | 27023 | 1320 | 32 | 0 | 1288 | 45.02343421 | -95.56403693 | 2021-01-23 05:22:03 | Chippewa, Minnesota, US |
911534 | 911534 | 2021-01-19 | US | Virginia | Louisa | 51109 | 1299 | 11 | 0 | 1288 | 37.97850256 | -77.96274807 | 2021-01-20 05:21:54 | Louisa, Virginia, US |
239240 | 239240 | 2021-01-18 | US | Montana | Lincoln | 30053 | 1297 | 9 | 0 | 1288 | 48.54265777 | -115.4046155 | 2021-01-19 05:22:15 | Lincoln, Montana, US |
3104817 | 3104817 | 2021-01-16 | US | Virginia | Page | 51139 | 1324 | 36 | 0 | 1288 | 38.61807452 | -78.48797204 | 2021-01-17 05:22:17 | Page, Virginia, US |
3882582 | 3882582 | 2021-01-14 | US | Texas | Austin | 48015 | 1376 | 17 | 0 | 1288 | 29.88548725 | -96.27736949 | 2021-01-15 05:22:24 | Austin, Texas, US |
3881176 | 3881176 | 2021-01-14 | US | Michigan | Alpena | 26007 | 1329 | 41 | 0 | 1288 | 45.03477666 | -83.62212411 | 2021-01-15 05:22:24 | Alpena, Michigan, US |
2626848 | 2626848 | 2021-01-10 | US | Illinois | Ford | 17053 | 1327 | 39 | 0 | 1288 | 40.59706922 | -88.22350769 | 2021-01-11 05:21:50 | Ford, Illinois, US |
2626706 | 2626706 | 2021-01-10 | US | Georgia | Meriwether | 13199 | 1308 | 20 | 0 | 1288 | 33.04163534 | -84.68859732 | 2021-01-11 05:21:50 | Meriwether, Georgia, US |
3903356 | 3903356 | 2021-01-09 | US | Virginia | Scott | 51169 | 1327 | 39 | 0 | 1288 | 36.71466456 | -82.60171704 | 2021-01-10 05:22:12 | Scott, Virginia, US |
3901799 | 3901799 | 2021-01-09 | US | Mississippi | Tallahatchie | 28135 | 1321 | 33 | 0 | 1288 | 33.95339918 | -90.1729398 | 2021-01-10 05:22:12 | Tallahatchie, Mississippi, US |
3901394 | 3901394 | 2021-01-09 | US | Kentucky | Meade | 21163 | 1292 | 4 | 0 | 1288 | 37.96163597 | -86.21028219 | 2021-01-10 05:22:12 | Meade, Kentucky, US |
2542226 | 2542226 | 2021-01-07 | US | Georgia | Jones | 13169 | 1312 | 24 | 0 | 1288 | 33.02512137 | -83.56019163 | 2021-01-08 05:22:42 | Jones, Georgia, US |
2867789 | 2867789 | 2021-01-06 | US | Texas | Fayette | 48149 | 1391 | 36 | 0 | 1288 | 29.87788372 | -96.92076062 | 2021-01-07 05:22:03 | Fayette, Texas, US |
1063059 | 1063059 | 2021-01-04 | US | Iowa | Mills | 19129 | 1303 | 15 | 0 | 1288 | 41.03299766 | -95.61920963 | 2021-01-05 05:21:49 | Mills, Iowa, US |
3230914 | 3230914 | 2021-01-03 | US | Arkansas | Cleburne | 5023 | 1326 | 38 | 0 | 1288 | 35.53864922 | -92.02640019 | 2021-01-04 05:22:02 | Cleburne, Arkansas, US |
3230821 | 3230821 | 2021-01-03 | US | Alabama | Henry | 1067 | 1296 | 8 | 0 | 1288 | 31.51148016 | -85.24267944 | 2021-01-04 05:22:02 | Henry, Alabama, US |
2230883 | 2230883 | 2021-01-02 | US | Virginia | Mecklenburg | 51117 | 1327 | 39 | 0 | 1288 | 36.67882005 | -78.36131056 | 2021-01-03 05:22:52 | Mecklenburg, Virginia, US |
2230374 | 2230374 | 2021-01-02 | US | South Dakota | Dewey | 46041 | 1300 | 12 | 0 | 1288 | 45.15639647 | -100.8709139 | 2021-01-03 05:22:52 | Dewey, South Dakota, US |
1013714 | 1013714 | 2020-12-30 | US | Virginia | Warren | 51187 | 1321 | 33 | 0 | 1288 | 38.90847745 | -78.20280433 | 2020-12-31 05:22:49 | Warren, Virginia, US |
769127 | 769127 | 2020-12-29 | US | South Carolina | Fairfield | 45039 | 1340 | 52 | 0 | 1288 | 34.39287073 | -81.1195624 | 2020-12-30 05:22:34 | Fairfield, South Carolina, US |
2224534 | 2224534 | 2020-12-26 | US | Illinois | Pike | 17149 | 1322 | 34 | 0 | 1288 | 39.62265059 | -90.8877017 | 2020-12-27 05:22:55 | Pike, Illinois, US |
3770700 | 3770700 | 2020-12-22 | US | Georgia | Lee | 13177 | 1321 | 33 | 0 | 1288 | 31.779330600000005 | -84.14324253 | 2020-12-23 05:22:03 | Lee, Georgia, US |
2119971 | 2119971 | 2020-12-20 | Russia | Volgograd Oblast | 32403 | 405 | 30710 | 1288 | 49.6048339 | 44.29035820000001 | 2020-12-21 05:27:58 | Volgograd Oblast, Russia | ||
1904607 | 1904607 | 2020-12-18 | US | Washington | Mason | 53045 | 1301 | 13 | 0 | 1288 | 47.35007586 | -123.1863685 | 2020-12-19 05:27:52 | Mason, Washington, US |
1901506 | 1901506 | 2020-12-18 | US | Alabama | Barbour | 1005 | 1318 | 30 | 0 | 1288 | 31.868263 | -85.3871286 | 2020-12-19 05:27:52 | Barbour, Alabama, US |
3149352 | 3149352 | 2020-12-16 | Burkina Faso | 4449 | 73 | 3088 | 1288 | 12.2383 | -1.5616 | 2020-12-17 05:28:12 | Burkina Faso | |||
1035818 | 1035818 | 2020-12-15 | US | Kentucky | Ohio | 21183 | 1310 | 22 | 0 | 1288 | 37.47751843 | -86.85368087 | 2020-12-16 05:28:04 | Ohio, Kentucky, US |
1035502 | 1035502 | 2020-12-15 | US | Indiana | Starke | 18149 | 1325 | 37 | 0 | 1288 | 41.27890281 | -86.64686895 | 2020-12-16 05:28:04 | Starke, Indiana, US |
1034717 | 1034717 | 2020-12-15 | US | Alabama | Butler | 1013 | 1332 | 44 | 0 | 1288 | 31.75300095 | -86.68057478 | 2020-12-16 05:28:04 | Butler, Alabama, US |
1754217 | 1754217 | 2020-12-14 | US | Tennessee | Lake | 47095 | 1300 | 10 | 0 | 1288 | 36.34180170000001 | -89.48921915 | 2020-12-15 05:26:38 | Lake, Tennessee, US |
3848833 | 3848833 | 2020-12-13 | US | Illinois | Warren | 17187 | 1314 | 26 | 0 | 1288 | 40.84925021 | -90.6147432 | 2020-12-14 05:26:27 | Warren, Illinois, US |
862252 | 862252 | 2020-12-11 | US | Maryland | Queen Anne's | 24035 | 1315 | 27 | 0 | 1288 | 39.06198912 | -76.03530977 | 2020-12-12 05:26:19 | Queen Anne's, Maryland, US |
861373 | 861373 | 2020-12-11 | US | Florida | Holmes | 12059 | 1305 | 17 | 0 | 1288 | 30.86747479 | -85.81319222 | 2020-12-12 05:26:19 | Holmes, Florida, US |
2349780 | 2349780 | 2020-12-07 | US | North Carolina | Stokes | 37169 | 1308 | 20 | 0 | 1288 | 36.4017975 | -80.23893369 | 2020-12-08 05:27:42 | Stokes, North Carolina, US |
2348254 | 2348254 | 2020-12-07 | US | Georgia | Madison | 13195 | 1307 | 19 | 0 | 1288 | 34.12920917 | -83.21218732 | 2020-12-08 05:27:42 | Madison, Georgia, US |
1007461 | 1007461 | 2020-12-06 | US | Iowa | Clay | 19041 | 1295 | 7 | 0 | 1288 | 43.08247182 | -95.15096481 | 2020-12-07 05:26:14 | Clay, Iowa, US |
1006676 | 1006676 | 2020-12-06 | US | Alabama | Marengo | 1091 | 1312 | 24 | 0 | 1288 | 32.24767634 | -87.78796182 | 2020-12-07 05:26:14 | Marengo, Alabama, US |
739952 | 739952 | 2020-12-02 | US | Michigan | Mecosta | 26107 | 1296 | 8 | 0 | 1288 | 43.64064262 | -85.32463223 | 2020-12-03 05:28:22 | Mecosta, Michigan, US |
2540973 | 2540973 | 2020-12-01 | US | Wisconsin | Vilas | 55125 | 1301 | 13 | 0 | 1288 | 46.05467334 | -89.51719204 | 2020-12-02 05:27:41 | Vilas, Wisconsin, US |
1585700 | 1585700 | 2020-11-30 | US | Louisiana | West Baton Rouge | 22121 | 1331 | 43 | 0 | 1288 | 30.46058217 | -91.30989571 | 2020-12-01 05:26:18 | West Baton Rouge, Louisiana, US |
2936376 | 2936376 | 2020-11-28 | US | Indiana | Wells | 18179 | 1323 | 35 | 0 | 1288 | 40.72934187 | -85.22132966 | 2020-11-29 05:25:55 | Wells, Indiana, US |
924087 | 924087 | 2020-11-26 | US | Alabama | Winston | 1133 | 1311 | 23 | 0 | 1288 | 34.15030532 | -87.37325922 | 2020-11-27 05:26:53 | Winston, Alabama, US |
679825 | 679825 | 2020-11-23 | US | Louisiana | Pointe Coupee | 22077 | 1337 | 49 | 0 | 1288 | 30.71409502 | -91.60209535 | 2020-11-24 05:27:31 | Pointe Coupee, Louisiana, US |
679155 | 679155 | 2020-11-23 | US | Georgia | Oconee | 13219 | 1323 | 35 | 0 | 1288 | 33.83749973 | -83.43679568 | 2020-11-24 05:27:31 | Oconee, Georgia, US |
3190183 | 3190183 | 2020-11-22 | Russia | Ingushetia Republic | 8848 | 105 | 7455 | 1288 | 43.11542075 | 45.01713552 | 2020-11-23 05:25:26 | Ingushetia Republic, Russia | ||
3839411 | 3839411 | 2020-11-21 | US | Tennessee | Giles | 47055 | 1327 | 40 | 0 | 1288 | 35.20222469 | -87.03992678 | 2020-11-22 05:25:45 | Giles, Tennessee, US |
3839320 | 3839320 | 2020-11-21 | US | South Dakota | Bon Homme | 46009 | 1301 | 13 | 0 | 1288 | 42.98914167 | -97.88592746 | 2020-11-22 05:25:45 | Bon Homme, South Dakota, US |
124918 | 124918 | 2020-11-18 | US | New York | Chautauqua | 36013 | 1304 | 16 | 0 | 1288 | 42.22769210000001 | -79.36691763 | 2020-11-19 05:25:23 | Chautauqua, New York, US |
379704 | 379704 | 2020-11-06 | US | Wisconsin | Clark | 55019 | 1309 | 21 | 0 | 1288 | 44.73483377 | -90.61207486 | 2020-11-07 05:24:52 | Clark, Wisconsin, US |
378856 | 378856 | 2020-11-06 | US | Pennsylvania | Mercer | 42085 | 1316 | 28 | 0 | 1288 | 41.30248872 | -80.25816981 | 2020-11-07 05:24:52 | Mercer, Pennsylvania, US |
378468 | 378468 | 2020-11-06 | US | North Carolina | Carteret | 37031 | 1293 | 5 | 0 | 1288 | 34.8932941 | -76.54120135 | 2020-11-07 05:24:52 | Carteret, North Carolina, US |
2920119 | 2920119 | 2020-11-04 | US | Idaho | Minidoka | 16067 | 1298 | 10 | 0 | 1288 | 42.85518524 | -113.6357257 | 2020-11-05 06:05:03 | Minidoka, Idaho, US |
3412245 | 3412245 | 2020-11-01 | US | South Carolina | Dillon | 45033 | 1336 | 48 | 0 | 1288 | 34.39007791 | -79.37741872 | 2020-11-02 05:25:04 | Dillon, South Carolina, US |
3412026 | 3412026 | 2020-11-01 | US | Oklahoma | Sequoyah | 40135 | 1302 | 14 | 0 | 1288 | 35.49447108 | -94.75463785 | 2020-11-02 05:25:04 | Sequoyah, Oklahoma, 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]);