johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
180 rows where active = 1282 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3331781 | 3331781 | 2021-07-21 | Russia | Tambov Oblast | 36726 | 665 | 34779 | 1282 | 52.9019574 | 41.3578918 | 2021-07-22 04:21:19 | Tambov Oblast, Russia | ||
3705898 | 3705898 | 2021-07-17 | Canada | Ontario | 551884 | 9288 | 544879 | 1282 | 51.2538 | -85.3232 | 2021-07-18 04:22:07 | Ontario, Canada | ||
299662 | 299662 | 2021-07-15 | United Kingdom | British Virgin Islands | 1602 | 8 | 312 | 1282 | 18.4207 | -64.64 | 2021-07-16 04:21:22 | British Virgin Islands, United Kingdom | ||
3033969 | 3033969 | 2021-06-16 | Malaysia | Perak | 23914 | 115 | 22517 | 1282 | 4.5921 | 101.0901 | 2021-06-17 04:22:36 | Perak, Malaysia | ||
1448836 | 1448836 | 2021-06-03 | Russia | Tambov Oblast | 33006 | 542 | 31182 | 1282 | 52.9019574 | 41.3578918 | 2021-06-04 04:23:37 | Tambov Oblast, Russia | ||
82882 | 82882 | 2021-05-25 | Chile | Coquimbo | 36411 | 676 | 34453 | 1282 | -29.959 | -71.3389 | 2021-05-26 04:20:35 | Coquimbo, Chile | ||
2390977 | 2390977 | 2021-05-18 | Russia | Karelia Republic | 46502 | 515 | 44705 | 1282 | 62.61940309999999 | 33.4920267 | 2021-05-19 04:20:42 | Karelia Republic, Russia | ||
2390725 | 2390725 | 2021-05-18 | India | Lakshadweep | 5212 | 15 | 3915 | 1282 | 13.6999972 | 72.18333259999999 | 2021-05-19 04:20:42 | Lakshadweep, India | ||
3242589 | 3242589 | 2021-04-21 | Russia | Yaroslavl Oblast | 37894 | 513 | 36099 | 1282 | 57.77819760000001 | 39.0021095 | 2021-04-22 04:20:53 | Yaroslavl Oblast, Russia | ||
36646 | 36646 | 2021-04-12 | Russia | Kurgan Oblast | 19701 | 362 | 18057 | 1282 | 55.7655302 | 64.5632681 | 2021-04-13 04:20:37 | Kurgan Oblast, Russia | ||
3085552 | 3085552 | 2021-04-05 | Russia | Tver Oblast | 37878 | 748 | 35848 | 1282 | 57.1134475 | 35.174442799999994 | 2021-04-06 04:20:32 | Tver Oblast, Russia | ||
3709984 | 3709984 | 2021-04-03 | Colombia | Cordoba | 43841 | 2034 | 40525 | 1282 | 8.0493 | -75.574 | 2021-04-04 04:20:49 | Cordoba, Colombia | ||
1301833 | 1301833 | 2021-04-01 | Chile | Antofagasta | 43473 | 874 | 41317 | 1282 | -23.6509 | -70.3975 | 2021-04-02 04:20:36 | Antofagasta, Chile | ||
1536043 | 1536043 | 2021-03-28 | Nepal | 276839 | 3027 | 272530 | 1282 | 28.1667 | 84.25 | 2021-03-29 04:28:35 | Nepal | |||
3452634 | 3452634 | 2021-03-18 | Canada | Saskatchewan | 31085 | 411 | 29392 | 1282 | 52.9399 | -106.4509 | 2021-03-19 05:26:09 | Saskatchewan, Canada | ||
3621191 | 3621191 | 2021-03-17 | Mongolia | 4340 | 4 | 3212 | 1282 | 46.8625 | 103.8467 | 2021-03-18 05:26:22 | Mongolia | |||
2055664 | 2055664 | 2021-03-15 | Chile | Antofagasta | 40424 | 824 | 38318 | 1282 | -23.6509 | -70.3975 | 2021-03-16 05:25:13 | Antofagasta, Chile | ||
1579939 | 1579939 | 2021-03-13 | Chile | Coquimbo | 23449 | 446 | 21721 | 1282 | -29.959 | -71.3389 | 2021-03-14 05:25:37 | Coquimbo, Chile | ||
1616856 | 1616856 | 2021-03-05 | US | Colorado | Grand | 8049 | 1307 | 6 | 0 | 1282 | 40.10603347 | -106.1178042 | 2021-03-06 04:23:41 | Grand, Colorado, US |
1091235 | 1091235 | 2021-03-03 | US | Iowa | Calhoun | 19025 | 1293 | 11 | 0 | 1282 | 42.38521079 | -94.64046046 | 2021-03-04 05:24:24 | Calhoun, Iowa, US |
3069327 | 3069327 | 2021-02-27 | US | Virginia | Fluvanna | 51065 | 1296 | 14 | 0 | 1282 | 37.84157909 | -78.27715475 | 2021-02-28 05:22:20 | Fluvanna, Virginia, US |
3067765 | 3067765 | 2021-02-27 | US | Minnesota | Wadena | 27159 | 1302 | 20 | 0 | 1282 | 46.58589171 | -94.96968506 | 2021-02-28 05:22:20 | Wadena, Minnesota, US |
743359 | 743359 | 2021-02-20 | US | Illinois | Wabash | 17185 | 1294 | 12 | 0 | 1282 | 38.44272901 | -87.84922065 | 2021-02-21 05:24:33 | Wabash, Illinois, US |
473508 | 473508 | 2021-02-19 | US | Nebraska | Otoe | 31131 | 1289 | 7 | 0 | 1282 | 40.64843556 | -96.13374142 | 2021-02-20 05:22:51 | Otoe, Nebraska, US |
1155603 | 1155603 | 2021-02-18 | US | Ohio | Meigs | 39105 | 1316 | 34 | 0 | 1282 | 39.09224872 | -82.0305041 | 2021-02-19 05:24:16 | Meigs, Ohio, US |
3051632 | 3051632 | 2021-02-16 | US | Kentucky | Rockcastle | 21203 | 1295 | 13 | 0 | 1282 | 37.36642393 | -84.31176452 | 2021-02-17 05:23:10 | Rockcastle, Kentucky, US |
1341843 | 1341843 | 2021-02-15 | US | Wisconsin | Richland | 55103 | 1295 | 13 | 0 | 1282 | 43.3762778 | -90.43012729 | 2021-02-16 05:24:38 | Richland, Wisconsin, US |
1340828 | 1340828 | 2021-02-15 | US | Oklahoma | Johnston | 40069 | 1299 | 17 | 0 | 1282 | 34.31440473 | -96.66011537 | 2021-02-16 05:24:38 | Johnston, Oklahoma, US |
3539917 | 3539917 | 2021-02-12 | US | Arkansas | Bradley | 5011 | 1312 | 30 | 0 | 1282 | 33.46755808 | -92.15980837 | 2021-02-13 05:22:12 | Bradley, Arkansas, US |
2638180 | 2638180 | 2021-02-11 | US | Arkansas | Bradley | 5011 | 1312 | 30 | 0 | 1282 | 33.46755808 | -92.15980837 | 2021-02-12 05:23:29 | Bradley, Arkansas, US |
3978720 | 3978720 | 2021-02-10 | Pakistan | Islamabad | 42279 | 481 | 40516 | 1282 | 33.665087 | 73.121219 | 2021-02-11 05:23:55 | Islamabad, Pakistan | ||
3978375 | 3978375 | 2021-02-10 | Chile | Valparaiso | 45290 | 1454 | 42554 | 1282 | -33.0472 | -71.6127 | 2021-02-11 05:23:55 | Valparaiso, Chile | ||
1530691 | 1530691 | 2021-02-09 | US | South Carolina | Bamberg | 45009 | 1328 | 46 | 0 | 1282 | 33.21927586 | -81.05659969 | 2021-02-10 05:22:41 | Bamberg, South Carolina, US |
1675027 | 1675027 | 2021-02-07 | US | Oklahoma | Noble | 40103 | 1291 | 9 | 0 | 1282 | 36.38953329 | -97.22928674 | 2021-02-08 05:22:39 | Noble, Oklahoma, US |
1673889 | 1673889 | 2021-02-07 | US | Kentucky | Mason | 21161 | 1308 | 26 | 0 | 1282 | 38.59471935 | -83.82151043 | 2021-02-08 05:22:39 | Mason, Kentucky, US |
978200 | 978200 | 2021-02-06 | US | Vermont | Washington | 50023 | 1294 | 12 | 0 | 1282 | 44.27343241 | -72.61604978 | 2021-02-07 05:23:00 | Washington, Vermont, US |
343339 | 343339 | 2021-02-03 | US | Texas | Dimmit | 48127 | 1397 | 18 | 0 | 1282 | 28.42270064 | -99.75645095 | 2021-02-04 05:22:26 | Dimmit, Texas, US |
1463341 | 1463341 | 2021-01-31 | US | Wisconsin | Washburn | 55129 | 1302 | 20 | 0 | 1282 | 45.89838588 | -91.79050449 | 2021-02-01 05:22:53 | Washburn, Wisconsin, US |
1900675 | 1900675 | 2021-01-29 | US | Wisconsin | Buffalo | 55011 | 1289 | 7 | 0 | 1282 | 44.37835084 | -91.75332578 | 2021-01-30 05:22:49 | Buffalo, Wisconsin, US |
1900537 | 1900537 | 2021-01-29 | US | Virginia | Powhatan | 51145 | 1289 | 7 | 0 | 1282 | 37.55016038 | -77.91267882 | 2021-01-30 05:22:49 | Powhatan, Virginia, US |
1898856 | 1898856 | 2021-01-29 | US | Minnesota | Cottonwood | 27033 | 1300 | 18 | 0 | 1282 | 44.00715262 | -95.18138802 | 2021-01-30 05:22:49 | Cottonwood, Minnesota, US |
2483459 | 2483459 | 2021-01-28 | US | Louisiana | Claiborne | 22027 | 1330 | 48 | 0 | 1282 | 32.82308512 | -92.99526883 | 2021-01-29 05:22:23 | Claiborne, Louisiana, US |
2569631 | 2569631 | 2021-01-25 | US | Missouri | Vernon | 29217 | 1313 | 31 | 0 | 1282 | 37.8457799 | -94.34127305 | 2021-01-26 05:22:02 | Vernon, Missouri, US |
438394 | 438394 | 2021-01-21 | US | Texas | Childress | 48075 | 1415 | 13 | 0 | 1282 | 34.529304100000004 | -100.2077916 | 2021-01-22 05:22:10 | Childress, Texas, US |
1097125 | 1097125 | 2021-01-20 | US | Texas | Childress | 48075 | 1415 | 13 | 0 | 1282 | 34.529304100000004 | -100.2077916 | 2021-01-21 05:22:01 | Childress, Texas, US |
910095 | 910095 | 2021-01-19 | US | Missouri | Madison | 29123 | 1293 | 11 | 0 | 1282 | 37.47865134 | -90.3467143 | 2021-01-20 05:21:54 | Madison, Missouri, US |
3504898 | 3504898 | 2021-01-17 | US | Louisiana | Winn | 22127 | 1316 | 34 | 0 | 1282 | 31.94449367 | -92.63789413 | 2021-01-18 05:22:34 | Winn, Louisiana, US |
3880051 | 3880051 | 2021-01-14 | US | Arkansas | Franklin | 5047 | 1309 | 27 | 0 | 1282 | 35.51202821 | -93.89299569 | 2021-01-15 05:22:24 | Franklin, Arkansas, US |
3309826 | 3309826 | 2021-01-13 | US | Michigan | Gladwin | 26051 | 1317 | 35 | 0 | 1282 | 43.98901072 | -84.38774817 | 2021-01-14 05:22:32 | Gladwin, Michigan, US |
776464 | 776464 | 2021-01-12 | US | Nebraska | Unassigned | 90031 | 1289 | 7 | 0 | 1282 | 42.8997274 | 0.0 | 2021-01-13 05:22:15 | Unassigned, Nebraska, US |
192191 | 192191 | 2021-01-11 | US | Nebraska | York | 31185 | 1290 | 8 | 0 | 1282 | 40.87272618 | -97.59710186 | 2021-01-12 05:22:15 | York, Nebraska, US |
191275 | 191275 | 2021-01-11 | US | Iowa | Lyon | 19119 | 1312 | 30 | 0 | 1282 | 43.38107862 | -96.20926845 | 2021-01-12 05:22:15 | Lyon, Iowa, US |
3901822 | 3901822 | 2021-01-09 | US | Missouri | Benton | 29015 | 1300 | 18 | 0 | 1282 | 38.29503305 | -93.28756116 | 2021-01-10 05:22:12 | Benton, Missouri, US |
3901370 | 3901370 | 2021-01-09 | US | Kentucky | Johnson | 21115 | 1298 | 16 | 0 | 1282 | 37.85106355 | -82.8264322 | 2021-01-10 05:22:12 | Johnson, Kentucky, US |
3900936 | 3900936 | 2021-01-09 | US | Illinois | Ford | 17053 | 1321 | 39 | 0 | 1282 | 40.59706922 | -88.22350769 | 2021-01-10 05:22:12 | Ford, Illinois, US |
2542426 | 2542426 | 2021-01-07 | US | Illinois | Moultrie | 17139 | 1300 | 18 | 0 | 1282 | 39.64187451 | -88.62099969 | 2021-01-08 05:22:42 | Moultrie, Illinois, US |
2541800 | 2541800 | 2021-01-07 | US | Alabama | Randolph | 1111 | 1313 | 31 | 0 | 1282 | 33.29526734 | -85.45708831 | 2021-01-08 05:22:42 | Randolph, Alabama, US |
3034783 | 3034783 | 2021-01-05 | US | Arkansas | Hempstead | 5057 | 1293 | 11 | 0 | 1282 | 33.73325583 | -93.66935133 | 2021-01-06 05:22:16 | Hempstead, Arkansas, US |
1064880 | 1064880 | 2021-01-04 | US | Texas | Cass | 48067 | 1308 | 50 | 0 | 1282 | 33.07499881 | -94.34646905 | 2021-01-05 05:21:49 | Cass, Texas, US |
1063006 | 1063006 | 2021-01-04 | US | Iowa | Butler | 19023 | 1305 | 23 | 0 | 1282 | 42.73172833 | -92.79015971 | 2021-01-05 05:21:49 | Butler, Iowa, US |
1138631 | 1138631 | 2021-01-01 | US | Minnesota | Redwood | 27127 | 1308 | 26 | 0 | 1282 | 44.40555844 | -95.25207021 | 2021-01-02 05:22:33 | Redwood, Minnesota, US |
3697237 | 3697237 | 2020-12-31 | US | Minnesota | Redwood | 27127 | 1308 | 26 | 0 | 1282 | 44.40555844 | -95.25207021 | 2021-01-01 05:23:07 | Redwood, Minnesota, US |
767632 | 767632 | 2020-12-29 | US | Kansas | Nemaha | 20131 | 1331 | 49 | 0 | 1282 | 39.78345387 | -96.01392079 | 2020-12-30 05:22:34 | Nemaha, Kansas, US |
767110 | 767110 | 2020-12-29 | US | Georgia | Fannin | 13111 | 1324 | 42 | 0 | 1282 | 34.86430205 | -84.316964 | 2020-12-30 05:22:34 | Fannin, Georgia, US |
3780570 | 3780570 | 2020-12-27 | US | Pennsylvania | Juniata | 42067 | 1322 | 40 | 0 | 1282 | 40.53358749 | -77.39975129999998 | 2020-12-28 05:22:06 | Juniata, Pennsylvania, US |
3778876 | 3778876 | 2020-12-27 | US | Illinois | Edgar | 17045 | 1308 | 26 | 0 | 1282 | 39.6809186 | -87.74759563 | 2020-12-28 05:22:06 | Edgar, Illinois, US |
2226106 | 2226106 | 2020-12-26 | US | Oregon | Benton | 41003 | 1293 | 11 | 0 | 1282 | 44.49167306 | -123.4316987 | 2020-12-27 05:22:55 | Benton, Oregon, US |
204531 | 204531 | 2020-12-25 | US | North Carolina | Anson | 37007 | 1305 | 23 | 0 | 1282 | 34.97403241 | -80.09953279 | 2020-12-26 05:22:28 | Anson, North Carolina, US |
202789 | 202789 | 2020-12-25 | US | California | Colusa | 6011 | 1289 | 7 | 0 | 1282 | 39.17881957 | -122.2331726 | 2020-12-26 05:22:28 | Colusa, California, US |
202262 | 202262 | 2020-12-25 | Japan | Fukuoka | 7994 | 117 | 6595 | 1282 | 33.526032 | 130.666949 | 2020-12-26 05:22:28 | Fukuoka, Japan | ||
3693754 | 3693754 | 2020-12-24 | US | North Carolina | Anson | 37007 | 1305 | 23 | 0 | 1282 | 34.97403241 | -80.09953279 | 2020-12-25 05:22:48 | Anson, North Carolina, US |
2409106 | 2409106 | 2020-12-23 | US | North Carolina | Anson | 37007 | 1305 | 23 | 0 | 1282 | 34.97403241 | -80.09953279 | 2020-12-24 05:23:04 | Anson, North Carolina, US |
3770370 | 3770370 | 2020-12-22 | US | Arkansas | Logan | 5083 | 1293 | 11 | 0 | 1282 | 35.21413234 | -93.71951016 | 2020-12-23 05:22:03 | Logan, Arkansas, US |
3770140 | 3770140 | 2020-12-22 | Rwanda | 7511 | 66 | 6163 | 1282 | -1.9403 | 29.8739 | 2020-12-23 05:22:03 | Rwanda | |||
928936 | 928936 | 2020-12-21 | US | Iowa | Winneshiek | 19191 | 1299 | 17 | 0 | 1282 | 43.29094334 | -91.84422722 | 2020-12-22 05:22:33 | Winneshiek, Iowa, US |
1902544 | 1902544 | 2020-12-18 | US | Kentucky | Clark | 21049 | 1296 | 14 | 0 | 1282 | 37.9689263 | -84.14615986 | 2020-12-19 05:27:52 | Clark, Kentucky, US |
2130189 | 2130189 | 2020-12-17 | US | New Mexico | Roosevelt | 35041 | 1301 | 19 | 0 | 1282 | 34.02097406 | -103.4799493 | 2020-12-18 05:28:18 | Roosevelt, New Mexico, US |
1753194 | 1753194 | 2020-12-14 | US | Missouri | Morgan | 29141 | 1296 | 14 | 0 | 1282 | 38.4181765 | -92.88791859 | 2020-12-15 05:26:38 | Morgan, Missouri, US |
849177 | 849177 | 2020-12-12 | US | Wyoming | Uinta | 56041 | 1289 | 7 | 0 | 1282 | 41.2878183 | -110.54757820000002 | 2020-12-13 05:27:20 | Uinta, Wyoming, US |
847828 | 847828 | 2020-12-12 | US | New York | St. Lawrence | 36089 | 1306 | 24 | 0 | 1282 | 44.4976179 | -75.06550039 | 2020-12-13 05:27:20 | St. Lawrence, New York, US |
846522 | 846522 | 2020-12-12 | US | Illinois | Bond | 17005 | 1295 | 13 | 0 | 1282 | 38.88829622 | -89.43534887 | 2020-12-13 05:27:20 | Bond, Illinois, US |
862138 | 862138 | 2020-12-11 | US | Kentucky | Taylor | 21217 | 1290 | 8 | 0 | 1282 | 37.3677562 | -85.3329931 | 2020-12-12 05:26:19 | Taylor, Kentucky, US |
1603566 | 1603566 | 2020-12-10 | US | Virginia | James City | 51095 | 1304 | 22 | 0 | 1282 | 37.31156958 | -76.76950618 | 2020-12-11 05:26:59 | James City, Virginia, US |
2975040 | 2975040 | 2020-12-09 | China | Hong Kong | 7179 | 114 | 5783 | 1282 | 22.3 | 114.2 | 2020-12-10 05:26:19 | Hong Kong, China | ||
1819944 | 1819944 | 2020-12-08 | US | Iowa | Buchanan | 19019 | 1292 | 10 | 0 | 1282 | 42.4709188 | -91.83510825 | 2020-12-09 05:28:01 | Buchanan, Iowa, US |
1006550 | 1006550 | 2020-12-06 | Russia | Vladimir Oblast | 14099 | 344 | 12473 | 1282 | 56.0503336 | 40.6561633 | 2020-12-07 05:26:14 | Vladimir Oblast, Russia | ||
3862099 | 3862099 | 2020-12-04 | US | New York | Wayne | 36117 | 1300 | 18 | 0 | 1282 | 43.15494365 | -77.02976528 | 2020-12-05 05:27:36 | Wayne, New York, US |
3861797 | 3861797 | 2020-12-04 | US | Missouri | Warren | 29219 | 1285 | 3 | 0 | 1282 | 38.76529479 | -91.16124662 | 2020-12-05 05:27:36 | Warren, Missouri, US |
78381 | 78381 | 2020-12-03 | US | Virginia | Augusta | 51015 | 1294 | 12 | 0 | 1282 | 38.16404586 | -79.12461614 | 2020-12-04 05:27:27 | Augusta, Virginia, US |
2540482 | 2540482 | 2020-12-01 | US | Texas | Gonzales | 48177 | 1253 | 24 | 0 | 1282 | 29.45634206 | -97.49424032 | 2020-12-02 05:27:41 | Gonzales, Texas, US |
1586270 | 1586270 | 2020-11-30 | US | Nebraska | Saunders | 31155 | 1289 | 7 | 0 | 1282 | 41.2278103 | -96.63773905 | 2020-12-01 05:26:18 | Saunders, Nebraska, US |
3569056 | 3569056 | 2020-11-29 | US | Ohio | Ottawa | 39123 | 1320 | 38 | 0 | 1282 | 41.53781826 | -83.0940185 | 2020-11-30 05:26:13 | Ottawa, Ohio, US |
393305 | 393305 | 2020-11-27 | US | Indiana | Decatur | 18031 | 1325 | 43 | 0 | 1282 | 39.30712658 | -85.50087166 | 2020-11-28 05:25:50 | Decatur, Indiana, US |
924488 | 924488 | 2020-11-26 | US | Georgia | Haralson | 13143 | 1305 | 23 | 0 | 1282 | 33.79602175 | -85.21005667 | 2020-11-27 05:26:53 | Haralson, Georgia, US |
3192435 | 3192435 | 2020-11-22 | US | Ohio | Defiance | 39039 | 1311 | 29 | 0 | 1282 | 41.32398837 | -84.49076944 | 2020-11-23 05:25:26 | Defiance, Ohio, US |
3190831 | 3190831 | 2020-11-22 | US | Georgia | Oconee | 13219 | 1317 | 35 | 0 | 1282 | 33.83749973 | -83.43679568 | 2020-11-23 05:25:26 | Oconee, Georgia, US |
3838013 | 3838013 | 2020-11-21 | US | Louisiana | Union | 22111 | 1338 | 56 | 0 | 1282 | 32.83121059 | -92.3749373 | 2020-11-22 05:25:45 | Union, Louisiana, US |
3837182 | 3837182 | 2020-11-21 | US | Florida | Lafayette | 12067 | 1301 | 19 | 0 | 1282 | 29.98484137 | -83.18166636 | 2020-11-22 05:25:45 | Lafayette, Florida, US |
2703041 | 2703041 | 2020-11-20 | US | Louisiana | Union | 22111 | 1338 | 56 | 0 | 1282 | 32.83121059 | -92.3749373 | 2020-11-21 05:25:51 | Union, Louisiana, US |
824894 | 824894 | 2020-11-19 | US | Virginia | Fauquier | 51061 | 1309 | 27 | 0 | 1282 | 38.73564842 | -77.80647472 | 2020-11-20 05:26:28 | Fauquier, Virginia, 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]);