johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
184 rows where active = 1313 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3476514 | 3476514 | 2021-07-22 | Russia | Kabardino-Balkarian Republic | 26238 | 564 | 24361 | 1313 | 43.4806048 | 43.5978976 | 2021-07-23 04:21:29 | Kabardino-Balkarian Republic, Russia | ||
3476084 | 3476084 | 2021-07-22 | Canada | Ontario | 552691 | 9307 | 545662 | 1313 | 51.2538 | -85.3232 | 2021-07-23 04:21:29 | Ontario, Canada | ||
3706360 | 3706360 | 2021-07-17 | Russia | Orel Oblast | 38989 | 788 | 36888 | 1313 | 52.96854329999999 | 36.0692477 | 2021-07-18 04:22:07 | Orel Oblast, Russia | ||
1932440 | 1932440 | 2021-07-05 | Japan | Chiba | 40986 | 710 | 38963 | 1313 | 35.510141 | 140.198917 | 2021-07-06 04:21:32 | Chiba, Japan | ||
3125713 | 3125713 | 2021-06-28 | Russia | Kaluga Oblast | 37242 | 371 | 35558 | 1313 | 54.4382773 | 35.5272854 | 2021-06-29 04:21:28 | Kaluga Oblast, Russia | ||
1712516 | 1712516 | 2021-06-25 | Russia | Belgorod Oblast | 40426 | 739 | 38374 | 1313 | 50.7080119 | 37.5837615 | 2021-06-26 04:21:43 | Belgorod Oblast, Russia | ||
2339239 | 2339239 | 2021-06-15 | Colombia | Cesar | 73417 | 2018 | 70086 | 1313 | 9.3373 | -73.6536 | 2021-06-16 04:22:32 | Cesar, Colombia | ||
1563935 | 1563935 | 2021-06-14 | Colombia | Cesar | 73417 | 2018 | 70086 | 1313 | 9.3373 | -73.6536 | 2021-06-15 04:22:22 | Cesar, Colombia | ||
1736838 | 1736838 | 2021-06-12 | Syria | 24789 | 1808 | 21668 | 1313 | 34.802075 | 38.99681500000001 | 2021-06-13 04:22:44 | Syria | |||
825858 | 825858 | 2021-06-06 | Seychelles | 12238 | 42 | 10883 | 1313 | -4.6796 | 55.492 | 2021-06-07 04:22:51 | Seychelles | |||
2315332 | 2315332 | 2021-06-04 | Japan | Okayama | 7444 | 109 | 6022 | 1313 | 34.89246 | 133.826252 | 2021-06-05 04:23:03 | Okayama, Japan | ||
2821028 | 2821028 | 2021-05-10 | Russia | Vladimir Oblast | 32480 | 1140 | 30027 | 1313 | 56.0503336 | 40.6561633 | 2021-05-11 04:20:41 | Vladimir Oblast, Russia | ||
3675879 | 3675879 | 2021-05-04 | Russia | Nizhny Novgorod Oblast | 114542 | 3236 | 109993 | 1313 | 55.47180329999999 | 44.0911594 | 2021-05-05 04:20:43 | Nizhny Novgorod Oblast, Russia | ||
2020468 | 2020468 | 2021-04-20 | Brazil | Piaui | 230952 | 4830 | 223176 | 1313 | -7.7183 | -42.7289 | 2021-04-21 04:21:14 | Piaui, Brazil | ||
2056217 | 2056217 | 2021-03-15 | Togo | 8222 | 96 | 6813 | 1313 | 8.6195 | 0.8248 | 2021-03-16 05:25:13 | Togo | |||
2210207 | 2210207 | 2021-03-04 | US | Oklahoma | Johnston | 40069 | 1333 | 20 | 0 | 1313 | 34.31440473 | -96.66011537 | 2021-03-05 05:26:29 | Johnston, Oklahoma, US |
2209124 | 2209124 | 2021-03-04 | US | Kentucky | Washington | 21229 | 1343 | 30 | 0 | 1313 | 37.75599461 | -85.17407732 | 2021-03-05 05:26:29 | Washington, Kentucky, US |
1090548 | 1090548 | 2021-03-03 | US | Arkansas | Desha | 5041 | 1334 | 21 | 0 | 1313 | 33.83011025 | -91.25500948 | 2021-03-04 05:24:24 | Desha, Arkansas, US |
3254620 | 3254620 | 2021-03-02 | US | Arkansas | Desha | 5041 | 1334 | 21 | 0 | 1313 | 33.83011025 | -91.25500948 | 2021-03-03 05:23:28 | Desha, Arkansas, US |
998912 | 998912 | 2021-03-01 | US | Arkansas | Desha | 5041 | 1334 | 21 | 0 | 1313 | 33.83011025 | -91.25500948 | 2021-03-02 05:23:30 | Desha, Arkansas, US |
2369979 | 2369979 | 2021-02-28 | US | Ohio | Meigs | 39105 | 1348 | 35 | 0 | 1313 | 39.09224872 | -82.0305041 | 2021-03-01 05:23:01 | Meigs, Ohio, US |
2368522 | 2368522 | 2021-02-28 | US | Illinois | Piatt | 17147 | 1327 | 14 | 0 | 1313 | 40.01360584 | -88.59319339 | 2021-03-01 05:23:01 | Piatt, Illinois, US |
3068716 | 3068716 | 2021-02-27 | US | Puerto Rico | Canovanas | 72029 | 1313 | 0 | 0 | 1313 | 18.328802 | -65.887612 | 2021-02-28 05:22:20 | Canovanas, Puerto Rico, US |
280387 | 280387 | 2021-02-24 | Russia | Kamchatka Krai | 13375 | 118 | 11944 | 1313 | 57.1914882 | 160.03838190000005 | 2021-02-25 05:24:57 | Kamchatka Krai, Russia | ||
533744 | 533744 | 2021-02-22 | US | Texas | Childress | 48075 | 1448 | 15 | 0 | 1313 | 34.529304100000004 | -100.2077916 | 2021-02-23 05:23:41 | Childress, Texas, US |
532408 | 532408 | 2021-02-22 | US | Minnesota | Cottonwood | 27033 | 1333 | 20 | 0 | 1313 | 44.00715262 | -95.18138802 | 2021-02-23 05:23:41 | Cottonwood, Minnesota, US |
185078 | 185078 | 2021-02-21 | US | Texas | Childress | 48075 | 1448 | 15 | 0 | 1313 | 34.529304100000004 | -100.2077916 | 2021-02-22 05:24:21 | Childress, Texas, US |
183330 | 183330 | 2021-02-21 | US | Kansas | Jackson | 20085 | 1327 | 14 | 0 | 1313 | 39.41673394 | -95.79356799 | 2021-02-22 05:24:21 | Jackson, Kansas, US |
182779 | 182779 | 2021-02-21 | US | Georgia | Bacon | 13005 | 1346 | 33 | 0 | 1313 | 31.55456473 | -82.45936528 | 2021-02-22 05:24:21 | Bacon, Georgia, US |
745352 | 745352 | 2021-02-20 | US | Texas | Childress | 48075 | 1448 | 15 | 0 | 1313 | 34.529304100000004 | -100.2077916 | 2021-02-21 05:24:33 | Childress, Texas, US |
743604 | 743604 | 2021-02-20 | US | Kansas | Jackson | 20085 | 1327 | 14 | 0 | 1313 | 39.41673394 | -95.79356799 | 2021-02-21 05:24:33 | Jackson, Kansas, US |
742666 | 742666 | 2021-02-20 | US | Alabama | Cleburne | 1029 | 1351 | 38 | 0 | 1313 | 33.67679204 | -85.52005899 | 2021-02-21 05:24:33 | Cleburne, Alabama, US |
472702 | 472702 | 2021-02-19 | US | Kansas | Jackson | 20085 | 1327 | 14 | 0 | 1313 | 39.41673394 | -95.79356799 | 2021-02-20 05:22:51 | Jackson, Kansas, US |
1156607 | 1156607 | 2021-02-18 | US | West Virginia | McDowell | 54047 | 1332 | 19 | 0 | 1313 | 37.38002939 | -81.65083669 | 2021-02-19 05:24:16 | McDowell, West Virginia, US |
1341902 | 1341902 | 2021-02-15 | Ukraine | Luhansk Oblast | 14520 | 430 | 12777 | 1313 | 48.574 | 39.3078 | 2021-02-16 05:24:38 | Luhansk Oblast, Ukraine | ||
3981869 | 3981869 | 2021-02-10 | US | Virginia | Appomattox | 51011 | 1322 | 9 | 0 | 1313 | 37.37569884 | -78.81340003 | 2021-02-11 05:23:55 | Appomattox, Virginia, US |
616970 | 616970 | 2021-02-08 | US | Vermont | Washington | 50023 | 1325 | 12 | 0 | 1313 | 44.27343241 | -72.61604978 | 2021-02-09 05:23:30 | Washington, Vermont, US |
1673438 | 1673438 | 2021-02-07 | US | Illinois | Greene | 17061 | 1343 | 30 | 0 | 1313 | 39.35907414 | -90.388865 | 2021-02-08 05:22:39 | Greene, Illinois, US |
976113 | 976113 | 2021-02-06 | US | Iowa | Iowa | 19095 | 1336 | 23 | 0 | 1313 | 41.68630265 | -92.0643373 | 2021-02-07 05:23:00 | Iowa, Iowa, US |
975899 | 975899 | 2021-02-06 | US | Illinois | Greene | 17061 | 1343 | 30 | 0 | 1313 | 39.35907414 | -90.388865 | 2021-02-07 05:23:00 | Greene, Illinois, US |
974906 | 974906 | 2021-02-06 | Italy | Molise | 8776 | 285 | 7178 | 1313 | 41.55774754 | 14.65916051 | 2021-02-07 05:23:00 | Molise, Italy | ||
1591240 | 1591240 | 2021-02-05 | US | Texas | Dimmit | 48127 | 1429 | 19 | 0 | 1313 | 28.42270064 | -99.75645095 | 2021-02-06 05:23:55 | Dimmit, Texas, US |
1590143 | 1590143 | 2021-02-05 | US | Missouri | Vernon | 29217 | 1346 | 33 | 0 | 1313 | 37.8457799 | -94.34127305 | 2021-02-06 05:23:55 | Vernon, Missouri, US |
1679132 | 1679132 | 2021-02-01 | US | Pennsylvania | Forest | 42053 | 1330 | 17 | 0 | 1313 | 41.51095103 | -79.23229292 | 2021-02-02 05:22:49 | Forest, Pennsylvania, US |
1678845 | 1678845 | 2021-02-01 | US | North Carolina | Yancey | 37199 | 1335 | 22 | 0 | 1313 | 35.90079156 | -82.31237181 | 2021-02-02 05:22:49 | Yancey, North Carolina, US |
16017 | 16017 | 2021-01-26 | Malaysia | Melaka | 3165 | 9 | 1843 | 1313 | 2.1896 | 102.2501 | 2021-01-27 05:23:41 | Melaka, Malaysia | ||
13798 | 13798 | 2021-01-26 | US | Kentucky | Russell | 21207 | 1347 | 34 | 0 | 1313 | 36.99308373 | -85.06070117 | 2021-01-27 05:23:41 | Russell, Kentucky, US |
13303 | 13303 | 2021-01-26 | US | Illinois | Clay | 17025 | 1349 | 36 | 0 | 1313 | 38.75388572 | -88.48914513 | 2021-01-27 05:23:41 | Clay, Illinois, US |
438865 | 438865 | 2021-01-21 | US | West Virginia | Upshur | 54097 | 1333 | 20 | 0 | 1313 | 38.89285061 | -80.23689136 | 2021-01-22 05:22:10 | Upshur, West Virginia, US |
910516 | 910516 | 2021-01-19 | US | North Carolina | Northampton | 37131 | 1340 | 27 | 0 | 1313 | 36.41736238 | -77.39769443 | 2021-01-20 05:21:54 | Northampton, North Carolina, US |
910382 | 910382 | 2021-01-19 | US | New Mexico | Taos | 35055 | 1355 | 42 | 0 | 1313 | 36.58006022 | -105.6310198 | 2021-01-20 05:21:54 | Taos, New Mexico, US |
776281 | 776281 | 2021-01-12 | US | Missouri | Pemiscot | 29155 | 1336 | 23 | 0 | 1313 | 36.2130572 | -89.78742322 | 2021-01-13 05:22:15 | Pemiscot, Missouri, US |
190965 | 190965 | 2021-01-11 | US | Georgia | Worth | 13321 | 1354 | 41 | 0 | 1313 | 31.55162306 | -83.85090513 | 2021-01-12 05:22:15 | Worth, Georgia, US |
3901362 | 3901362 | 2021-01-09 | US | Kentucky | Hart | 21099 | 1322 | 9 | 0 | 1313 | 37.29943898 | -85.88461055 | 2021-01-10 05:22:12 | Hart, Kentucky, US |
2542719 | 2542719 | 2021-01-07 | US | Kansas | Nemaha | 20131 | 1363 | 50 | 0 | 1313 | 39.78345387 | -96.01392079 | 2021-01-08 05:22:42 | Nemaha, Kansas, US |
2542097 | 2542097 | 2021-01-07 | US | Florida | Hamilton | 12047 | 1328 | 15 | 0 | 1313 | 30.49673973 | -82.94998918 | 2021-01-08 05:22:42 | Hamilton, Florida, US |
2866028 | 2866028 | 2021-01-06 | US | Kansas | Nemaha | 20131 | 1363 | 50 | 0 | 1313 | 39.78345387 | -96.01392079 | 2021-01-07 05:22:03 | Nemaha, Kansas, US |
3036519 | 3036519 | 2021-01-05 | US | New York | Chenango | 36017 | 1337 | 24 | 0 | 1313 | 42.49430041 | -75.60887553 | 2021-01-06 05:22:16 | Chenango, New York, US |
3233635 | 3233635 | 2021-01-03 | US | Texas | Pecos | 48371 | 1045 | 23 | 0 | 1313 | 30.78097267 | -102.7241261 | 2021-01-04 05:22:02 | Pecos, Texas, US |
2228503 | 2228503 | 2021-01-02 | US | Illinois | Hancock | 17067 | 1333 | 20 | 0 | 1313 | 40.40423981 | -91.16313899 | 2021-01-03 05:22:52 | Hancock, Illinois, US |
1011192 | 1011192 | 2020-12-30 | US | Georgia | Washington | 13303 | 1359 | 46 | 0 | 1313 | 32.96711864 | -82.79357039 | 2020-12-31 05:22:49 | Washington, Georgia, US |
768597 | 768597 | 2020-12-29 | US | North Carolina | Avery | 37011 | 1328 | 15 | 0 | 1313 | 36.07569796 | -81.92308483 | 2020-12-30 05:22:34 | Avery, North Carolina, US |
767887 | 767887 | 2020-12-29 | US | Maryland | Dorchester | 24019 | 1334 | 21 | 0 | 1313 | 38.45413522 | -76.02752426 | 2020-12-30 05:22:34 | Dorchester, Maryland, US |
3780813 | 3780813 | 2020-12-27 | US | Tennessee | Cannon | 47015 | 1335 | 11 | 0 | 1313 | 35.80990797 | -86.05738983 | 2020-12-28 05:22:06 | Cannon, Tennessee, US |
2225836 | 2225836 | 2020-12-26 | US | North Carolina | Macon | 37113 | 1322 | 9 | 0 | 1313 | 35.14867843 | -83.41696617 | 2020-12-27 05:22:55 | Macon, North Carolina, US |
2224688 | 2224688 | 2020-12-26 | US | Iowa | Fayette | 19065 | 1329 | 16 | 0 | 1313 | 42.86271799 | -91.8441231 | 2020-12-27 05:22:55 | Fayette, Iowa, US |
2224316 | 2224316 | 2020-12-26 | US | Georgia | Harris | 13145 | 1342 | 29 | 0 | 1313 | 32.73709786 | -84.90538572 | 2020-12-27 05:22:55 | Harris, Georgia, US |
203137 | 203137 | 2020-12-25 | US | Georgia | Union | 13291 | 1355 | 42 | 0 | 1313 | 34.82995757 | -83.98967069 | 2020-12-26 05:22:28 | Union, Georgia, US |
2408074 | 2408074 | 2020-12-23 | US | Iowa | Winneshiek | 19191 | 1330 | 17 | 0 | 1313 | 43.29094334 | -91.84422722 | 2020-12-24 05:23:04 | Winneshiek, Iowa, US |
2407654 | 2407654 | 2020-12-23 | US | Georgia | Lee | 13177 | 1346 | 33 | 0 | 1313 | 31.779330600000005 | -84.14324253 | 2020-12-24 05:23:04 | Lee, Georgia, US |
3770745 | 3770745 | 2020-12-22 | US | Georgia | Tattnall | 13267 | 1348 | 35 | 0 | 1313 | 32.04785085 | -82.05539188 | 2020-12-23 05:22:03 | Tattnall, Georgia, US |
2122388 | 2122388 | 2020-12-20 | US | Pennsylvania | McKean | 42083 | 1325 | 12 | 0 | 1313 | 41.80938602 | -78.56478358 | 2020-12-21 05:27:58 | McKean, Pennsylvania, US |
2120641 | 2120641 | 2020-12-20 | US | Idaho | Gem | 16045 | 1330 | 17 | 0 | 1313 | 44.06482372 | -116.398376 | 2020-12-21 05:27:58 | Gem, Idaho, US |
2130337 | 2130337 | 2020-12-17 | US | North Carolina | Person | 37145 | 1331 | 18 | 0 | 1313 | 36.38989032 | -78.97217358 | 2020-12-18 05:28:18 | Person, North Carolina, US |
2128532 | 2128532 | 2020-12-17 | US | California | Humboldt | 6023 | 1327 | 14 | 0 | 1313 | 40.69923009 | -123.876044 | 2020-12-18 05:28:18 | Humboldt, California, US |
3151734 | 3151734 | 2020-12-16 | US | New Hampshire | Belknap | 33001 | 1352 | 39 | 0 | 1313 | 43.51637314 | -71.41684235 | 2020-12-17 05:28:12 | Belknap, New Hampshire, US |
1035670 | 1035670 | 2020-12-15 | US | Kansas | Labette | 20099 | 1328 | 15 | 0 | 1313 | 37.19113093 | -95.29849679 | 2020-12-16 05:28:04 | Labette, Kansas, US |
1034839 | 1034839 | 2020-12-15 | US | Arkansas | Columbia | 5027 | 1348 | 35 | 0 | 1313 | 33.21230701 | -93.22642793 | 2020-12-16 05:28:04 | Columbia, Arkansas, US |
1754682 | 1754682 | 2020-12-14 | US | Virginia | Winchester | 51840 | 1319 | 6 | 0 | 1313 | 39.17054517 | -78.17325058 | 2020-12-15 05:26:38 | Winchester, Virginia, US |
1752564 | 1752564 | 2020-12-14 | US | Kansas | Labette | 20099 | 1328 | 15 | 0 | 1313 | 37.19113093 | -95.29849679 | 2020-12-15 05:26:38 | Labette, Kansas, US |
1752424 | 1752424 | 2020-12-14 | US | Iowa | Buchanan | 19019 | 1328 | 15 | 0 | 1313 | 42.4709188 | -91.83510825 | 2020-12-15 05:26:38 | Buchanan, Iowa, US |
849037 | 849037 | 2020-12-12 | US | West Virginia | Fayette | 54019 | 1352 | 39 | 0 | 1313 | 38.02974928 | -81.08286634 | 2020-12-13 05:27:20 | Fayette, West Virginia, US |
847779 | 847779 | 2020-12-12 | US | New York | Allegany | 36003 | 1377 | 64 | 0 | 1313 | 42.25748406 | -78.02750466 | 2020-12-13 05:27:20 | Allegany, New York, US |
845797 | 845797 | 2020-12-12 | Russia | North Ossetia - Alania Republic | 10348 | 81 | 8954 | 1313 | 42.79336110000001 | 44.6324493 | 2020-12-13 05:27:20 | North Ossetia - Alania Republic, Russia | ||
1602432 | 1602432 | 2020-12-10 | US | New York | Cayuga | 36011 | 1324 | 11 | 0 | 1313 | 42.91261714 | -76.55731592 | 2020-12-11 05:26:59 | Cayuga, New York, US |
1819830 | 1819830 | 2020-12-08 | US | Illinois | Union | 17181 | 1341 | 28 | 0 | 1313 | 37.47119609 | -89.25548938 | 2020-12-09 05:28:01 | Union, Illinois, US |
2350322 | 2350322 | 2020-12-07 | US | South Dakota | Union | 46127 | 1338 | 25 | 0 | 1313 | 42.83112163 | -96.6557828 | 2020-12-08 05:27:42 | Union, South Dakota, US |
2349650 | 2349650 | 2020-12-07 | US | New York | Genesee | 36037 | 1328 | 15 | 0 | 1313 | 43.0022601 | -78.19135193 | 2020-12-08 05:27:42 | Genesee, New York, US |
2348218 | 2348218 | 2020-12-07 | US | Georgia | Franklin | 13119 | 1336 | 23 | 0 | 1313 | 34.37525597 | -83.23159927 | 2020-12-08 05:27:42 | Franklin, Georgia, US |
3860318 | 3860318 | 2020-12-04 | US | Arkansas | Johnson | 5071 | 1326 | 13 | 0 | 1313 | 35.56759135 | -93.46036368 | 2020-12-05 05:27:36 | Johnson, Arkansas, US |
740923 | 740923 | 2020-12-02 | US | Oregon | Polk | 41053 | 1332 | 19 | 0 | 1313 | 44.90322804 | -123.4128888 | 2020-12-03 05:28:22 | Polk, Oregon, US |
1585285 | 1585285 | 2020-11-30 | US | Indiana | Randolph | 18135 | 1340 | 27 | 0 | 1313 | 40.15734772 | -85.01139319 | 2020-12-01 05:26:18 | Randolph, Indiana, US |
3570005 | 3570005 | 2020-11-29 | US | Washington | Lewis | 53041 | 1331 | 18 | 0 | 1313 | 46.57756476 | -122.3925769 | 2020-11-30 05:26:13 | Lewis, Washington, US |
3567373 | 3567373 | 2020-11-29 | US | Georgia | Haralson | 13143 | 1336 | 23 | 0 | 1313 | 33.79602175 | -85.21005667 | 2020-11-30 05:26:13 | Haralson, Georgia, US |
2938673 | 2938673 | 2020-11-28 | US | Washington | Okanogan | 53047 | 1333 | 20 | 0 | 1313 | 48.54855019 | -119.7387224 | 2020-11-29 05:25:55 | Okanogan, Washington, US |
2936302 | 2936302 | 2020-11-28 | US | Indiana | Decatur | 18031 | 1356 | 43 | 0 | 1313 | 39.30712658 | -85.50087166 | 2020-11-29 05:25:55 | Decatur, Indiana, US |
395676 | 395676 | 2020-11-27 | US | Washington | Okanogan | 53047 | 1333 | 20 | 0 | 1313 | 48.54855019 | -119.7387224 | 2020-11-28 05:25:50 | Okanogan, Washington, US |
392180 | 392180 | 2020-11-27 | India | Goa | 47491 | 686 | 45492 | 1313 | 15.359682 | 74.057396 | 2020-11-28 05:25:50 | Goa, India | ||
923941 | 923941 | 2020-11-26 | Russia | Voronezh Oblast | 33117 | 548 | 31256 | 1313 | 50.9800393 | 40.15065070000001 | 2020-11-27 05:26:53 | Voronezh Oblast, Russia | ||
1974999 | 1974999 | 2020-11-25 | US | North Dakota | Rolette | 38079 | 1326 | 14 | 0 | 1313 | 48.77245354 | -99.84097493 | 2020-11-26 05:27:44 | Rolette, North Dakota, 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]);