johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
189 rows where active = 1236 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1378538 | 1378538 | 2021-07-25 | Japan | Okinawa | 22705 | 231 | 21238 | 1236 | 25.768923 | 126.668016 | 2021-07-26 04:21:28 | Okinawa, Japan | ||
3631845 | 3631845 | 2021-07-14 | Eswatini | 20489 | 696 | 18557 | 1236 | -26.5225 | 31.4659 | 2021-07-15 04:21:48 | Eswatini | |||
1495836 | 1495836 | 2021-07-03 | Russia | Omsk Oblast | 51588 | 1511 | 48841 | 1236 | 56.09352629999999 | 73.5099936 | 2021-07-04 04:21:38 | Omsk Oblast, Russia | ||
2593683 | 2593683 | 2021-06-27 | Malaysia | Pulau Pinang | 34159 | 119 | 32804 | 1236 | 5.4141 | 100.3288 | 2021-06-28 04:21:29 | Pulau Pinang, Malaysia | ||
3958697 | 3958697 | 2021-06-26 | Russia | Belgorod Oblast | 40503 | 742 | 38525 | 1236 | 50.7080119 | 37.5837615 | 2021-06-27 04:21:39 | Belgorod Oblast, Russia | ||
2295710 | 2295710 | 2021-06-24 | Russia | Vladimir Oblast | 35047 | 1260 | 32551 | 1236 | 56.0503336 | 40.6561633 | 2021-06-25 04:21:33 | Vladimir Oblast, Russia | ||
562946 | 562946 | 2021-06-22 | Italy | Basilicata | 26844 | 589 | 25019 | 1236 | 40.63947052 | 15.80514834 | 2021-06-23 04:21:46 | Basilicata, Italy | ||
522718 | 522718 | 2021-06-09 | Colombia | Tolima | 79303 | 2561 | 75506 | 1236 | 4.0925 | -75.1545 | 2021-06-10 04:23:17 | Tolima, Colombia | ||
3145785 | 3145785 | 2021-06-07 | Russia | Kaluga Oblast | 36023 | 345 | 34442 | 1236 | 54.4382773 | 35.5272854 | 2021-06-08 04:22:35 | Kaluga Oblast, Russia | ||
2586237 | 2586237 | 2021-06-05 | Russia | Tambov Oblast | 33126 | 548 | 31342 | 1236 | 52.9019574 | 41.3578918 | 2021-06-06 04:24:03 | Tambov Oblast, Russia | ||
2315506 | 2315506 | 2021-06-04 | Russia | Kaluga Oblast | 35872 | 341 | 34295 | 1236 | 54.4382773 | 35.5272854 | 2021-06-05 04:23:03 | Kaluga Oblast, Russia | ||
1806676 | 1806676 | 2021-05-27 | Haiti | 14565 | 317 | 12509 | 1236 | 18.9712 | -72.2852 | 2021-05-28 04:20:36 | Haiti | |||
1310100 | 1310100 | 2021-05-26 | Haiti | 14453 | 311 | 12509 | 1236 | 18.9712 | -72.2852 | 2021-05-27 04:20:59 | Haiti | |||
1413263 | 1413263 | 2021-05-24 | Russia | Karelia Republic | 46846 | 531 | 45079 | 1236 | 62.61940309999999 | 33.4920267 | 2021-05-25 04:21:08 | Karelia Republic, Russia | ||
1771599 | 1771599 | 2021-05-23 | Russia | Ulyanovsk Oblast | 55271 | 1342 | 52693 | 1236 | 54.1463177 | 47.2324921 | 2021-05-24 04:20:53 | Ulyanovsk Oblast, Russia | ||
1636578 | 1636578 | 2021-04-29 | Russia | Yaroslavl Oblast | 38554 | 529 | 36789 | 1236 | 57.77819760000001 | 39.0021095 | 2021-04-30 04:21:03 | Yaroslavl Oblast, Russia | ||
3129374 | 3129374 | 2021-04-18 | Colombia | Narino | 51750 | 1729 | 48785 | 1236 | 1.2892 | -77.3579 | 2021-04-19 04:20:57 | Narino, Colombia | ||
605941 | 605941 | 2021-04-09 | Russia | Tver Oblast | 38249 | 766 | 36247 | 1236 | 57.1134475 | 35.174442799999994 | 2021-04-10 04:20:59 | Tver Oblast, Russia | ||
1535940 | 1535940 | 2021-03-28 | Japan | Hyogo | 19601 | 584 | 17781 | 1236 | 35.039913 | 134.828057 | 2021-03-29 04:28:35 | Hyogo, Japan | ||
1616171 | 1616171 | 2021-03-05 | Guinea | 16420 | 93 | 15091 | 1236 | 9.9456 | -9.6966 | 2021-03-06 04:23:41 | Guinea | |||
2207582 | 2207582 | 2021-03-04 | Guinea | 16420 | 93 | 15091 | 1236 | 9.9456 | -9.6966 | 2021-03-05 05:26:29 | Guinea | |||
1091237 | 1091237 | 2021-03-03 | US | Iowa | Cass | 19029 | 1287 | 51 | 0 | 1236 | 41.33149454 | -94.92792482 | 2021-03-04 05:24:24 | Cass, Iowa, US |
3257516 | 3257516 | 2021-03-02 | US | Virginia | New Kent | 51127 | 1249 | 13 | 0 | 1236 | 37.50694406 | -76.99828634 | 2021-03-03 05:23:28 | New Kent, Virginia, US |
2367348 | 2367348 | 2021-02-28 | Colombia | Magdalena | 33608 | 1291 | 31081 | 1236 | 10.4113 | -74.4057 | 2021-03-01 05:23:01 | Magdalena, Colombia | ||
2186547 | 2186547 | 2021-02-26 | US | Tennessee | Meigs | 47121 | 1261 | 21 | 0 | 1236 | 35.51558739 | -84.81482914 | 2021-02-27 05:22:28 | Meigs, Tennessee, US |
2184594 | 2184594 | 2021-02-26 | US | Illinois | Massac | 17127 | 1269 | 33 | 0 | 1236 | 37.22078441 | -88.71036614 | 2021-02-27 05:22:28 | Massac, Illinois, US |
283577 | 283577 | 2021-02-24 | US | Virginia | Rockbridge | 51163 | 1267 | 31 | 0 | 1236 | 37.81204314 | -79.44605905 | 2021-02-25 05:24:57 | Rockbridge, Virginia, US |
185606 | 185606 | 2021-02-21 | US | Wisconsin | Price | 55099 | 1243 | 7 | 0 | 1236 | 45.68051754 | -90.3609888 | 2021-02-22 05:24:21 | Price, Wisconsin, US |
182855 | 182855 | 2021-02-21 | US | Georgia | Jasper | 13159 | 1266 | 30 | 0 | 1236 | 33.31535543 | -83.68844964 | 2021-02-22 05:24:21 | Jasper, Georgia, US |
182653 | 182653 | 2021-02-21 | US | Colorado | Grand | 8049 | 1273 | 6 | 0 | 1236 | 40.10603347 | -106.1178042 | 2021-02-22 05:24:21 | Grand, Colorado, US |
182282 | 182282 | 2021-02-21 | Russia | Sakhalin Oblast | 21200 | 33 | 19931 | 1236 | 49.7219665 | 143.448533 | 2021-02-22 05:24:21 | Sakhalin Oblast, Russia | ||
745880 | 745880 | 2021-02-20 | US | Wisconsin | Price | 55099 | 1243 | 7 | 0 | 1236 | 45.68051754 | -90.3609888 | 2021-02-21 05:24:33 | Price, Wisconsin, US |
743431 | 743431 | 2021-02-20 | US | Indiana | Pike | 18125 | 1268 | 32 | 0 | 1236 | 38.40112197 | -87.23574907 | 2021-02-21 05:24:33 | Pike, Indiana, US |
473902 | 473902 | 2021-02-19 | US | Ohio | Noble | 39121 | 1274 | 38 | 0 | 1236 | 39.76818851 | -81.45937183 | 2021-02-20 05:22:51 | Noble, Ohio, US |
1156596 | 1156596 | 2021-02-18 | US | West Virginia | Hardy | 54031 | 1256 | 20 | 0 | 1236 | 39.00683177 | -78.85855301 | 2021-02-19 05:24:16 | Hardy, West Virginia, US |
1155346 | 1155346 | 2021-02-18 | US | New York | Essex | 36031 | 1262 | 26 | 0 | 1236 | 44.11630765 | -73.77297842 | 2021-02-19 05:24:16 | Essex, New York, US |
3053597 | 3053597 | 2021-02-16 | US | Washington | Asotin | 53003 | 1264 | 28 | 0 | 1236 | 46.18894415 | -117.2022851 | 2021-02-17 05:23:10 | Asotin, Washington, US |
3051429 | 3051429 | 2021-02-16 | US | Kansas | Bourbon | 20011 | 1258 | 22 | 0 | 1236 | 37.85508555 | -94.84865997 | 2021-02-17 05:23:10 | Bourbon, Kansas, US |
1339528 | 1339528 | 2021-02-15 | US | Kansas | Bourbon | 20011 | 1258 | 22 | 0 | 1236 | 37.85508555 | -94.84865997 | 2021-02-16 05:24:38 | Bourbon, Kansas, US |
1338113 | 1338113 | 2021-02-15 | Colombia | Caldas | 45999 | 950 | 43813 | 1236 | 5.2983 | -75.2479 | 2021-02-16 05:24:38 | Caldas, Colombia | ||
2678795 | 2678795 | 2021-02-13 | US | Illinois | De Witt | 17039 | 1258 | 22 | 0 | 1236 | 40.17514519 | -88.90959682 | 2021-02-14 05:23:43 | De Witt, Illinois, US |
3541612 | 3541612 | 2021-02-12 | US | New Hampshire | Unassigned | 90033 | 1241 | 5 | 0 | 1236 | 44.69063265 | 0.0 | 2021-02-13 05:22:12 | Unassigned, New Hampshire, US |
3540829 | 3540829 | 2021-02-12 | US | Kentucky | Butler | 21031 | 1258 | 22 | 0 | 1236 | 37.20946153 | -86.68748787 | 2021-02-13 05:22:12 | Butler, Kentucky, US |
1528277 | 1528277 | 2021-02-09 | US | Alabama | Lowndes | 1085 | 1278 | 42 | 0 | 1236 | 32.1597283 | -86.65158371 | 2021-02-10 05:22:41 | Lowndes, Alabama, US |
1588649 | 1588649 | 2021-02-05 | US | Arkansas | Desha | 5041 | 1253 | 17 | 0 | 1236 | 33.83011025 | -91.25500948 | 2021-02-06 05:23:55 | Desha, Arkansas, US |
340961 | 340961 | 2021-02-03 | US | Florida | Franklin | 12037 | 1246 | 10 | 0 | 1236 | 29.83791238 | -84.82731662 | 2021-02-04 05:22:26 | Franklin, Florida, US |
340389 | 340389 | 2021-02-03 | Namibia | 34372 | 359 | 32777 | 1236 | -22.9576 | 18.4904 | 2021-02-04 05:22:26 | Namibia | |||
1686906 | 1686906 | 2021-02-02 | US | North Dakota | Mountrail | 38061 | 1248 | 17 | 0 | 1236 | 48.20197971 | -102.3555315 | 2021-02-03 05:22:52 | Mountrail, North Dakota, US |
1677516 | 1677516 | 2021-02-01 | US | Illinois | Wabash | 17185 | 1248 | 12 | 0 | 1236 | 38.44272901 | -87.84922065 | 2021-02-02 05:22:49 | Wabash, Illinois, US |
2483130 | 2483130 | 2021-01-28 | US | Iowa | Calhoun | 19025 | 1245 | 9 | 0 | 1236 | 42.38521079 | -94.64046046 | 2021-01-29 05:22:23 | Calhoun, Iowa, US |
2568260 | 2568260 | 2021-01-25 | US | Colorado | Chaffee | 8015 | 1328 | 23 | 0 | 1236 | 38.74745778 | -106.19265729999998 | 2021-01-26 05:22:02 | Chaffee, Colorado, US |
2430473 | 2430473 | 2021-01-23 | US | Wisconsin | Rusk | 55107 | 1251 | 15 | 0 | 1236 | 45.47498854 | -91.1333012 | 2021-01-24 05:22:35 | Rusk, Wisconsin, US |
1096648 | 1096648 | 2021-01-20 | US | Oklahoma | Love | 40085 | 1244 | 8 | 0 | 1236 | 33.95273467 | -97.23906784 | 2021-01-21 05:22:01 | Love, Oklahoma, US |
3103630 | 3103630 | 2021-01-16 | US | New Mexico | Lincoln | 35027 | 1249 | 13 | 0 | 1236 | 33.74526079 | -105.4586166 | 2021-01-17 05:22:17 | Lincoln, New Mexico, US |
3102943 | 3102943 | 2021-01-16 | US | Louisiana | LaSalle | 22059 | 1264 | 28 | 0 | 1236 | 31.67884782 | -92.15907765 | 2021-01-17 05:22:17 | LaSalle, Louisiana, US |
3516905 | 3516905 | 2021-01-15 | US | Louisiana | LaSalle | 22059 | 1264 | 28 | 0 | 1236 | 31.67884782 | -92.15907765 | 2021-01-16 05:22:40 | LaSalle, Louisiana, US |
3516552 | 3516552 | 2021-01-15 | US | Iowa | Allamakee | 19005 | 1263 | 27 | 0 | 1236 | 43.28383218 | -91.37860922 | 2021-01-16 05:22:40 | Allamakee, Iowa, US |
3310577 | 3310577 | 2021-01-13 | US | North Dakota | Barnes | 38003 | 1255 | 30 | 0 | 1236 | 46.93579637 | -98.06605978 | 2021-01-14 05:22:32 | Barnes, North Dakota, US |
3308464 | 3308464 | 2021-01-13 | Russia | Yaroslavl Oblast | 24754 | 244 | 23274 | 1236 | 57.77819760000001 | 39.0021095 | 2021-01-14 05:22:32 | Yaroslavl Oblast, Russia | ||
192645 | 192645 | 2021-01-11 | US | Oklahoma | Pawnee | 40117 | 1252 | 16 | 0 | 1236 | 36.31743373 | -96.7033176 | 2021-01-12 05:22:15 | Pawnee, Oklahoma, US |
2627411 | 2627411 | 2021-01-10 | US | Louisiana | Winn | 22127 | 1269 | 33 | 0 | 1236 | 31.94449367 | -92.63789413 | 2021-01-11 05:21:50 | Winn, Louisiana, US |
2625803 | 2625803 | 2021-01-10 | Haiti | 10241 | 237 | 8768 | 1236 | 18.9712 | -72.2852 | 2021-01-11 05:21:50 | Haiti | |||
3899891 | 3899891 | 2021-01-09 | Haiti | 10241 | 237 | 8768 | 1236 | 18.9712 | -72.2852 | 2021-01-10 05:22:12 | Haiti | |||
156282 | 156282 | 2021-01-08 | US | North Carolina | Dare | 37055 | 1241 | 5 | 0 | 1236 | 35.66520691 | -75.71767334 | 2021-01-09 05:22:18 | Dare, North Carolina, US |
2543781 | 2543781 | 2021-01-07 | US | North Dakota | Barnes | 38003 | 1247 | 29 | 0 | 1236 | 46.93579637 | -98.06605978 | 2021-01-08 05:22:42 | Barnes, North Dakota, US |
2543021 | 2543021 | 2021-01-07 | US | Michigan | Clare | 26035 | 1282 | 46 | 0 | 1236 | 43.98794227 | -84.84819859999998 | 2021-01-08 05:22:42 | Clare, Michigan, US |
2542632 | 2542632 | 2021-01-07 | US | Iowa | Poweshiek | 19157 | 1260 | 24 | 0 | 1236 | 41.68625425 | -92.53155731 | 2021-01-08 05:22:42 | Poweshiek, Iowa, US |
2867277 | 2867277 | 2021-01-06 | US | Oklahoma | Marshall | 40095 | 1242 | 6 | 0 | 1236 | 34.02311222 | -96.76855464 | 2021-01-07 05:22:03 | Marshall, Oklahoma, US |
3037330 | 3037330 | 2021-01-05 | US | Texas | Calhoun | 48057 | 1313 | 10 | 0 | 1236 | 28.47048236 | -96.61633945 | 2021-01-06 05:22:16 | Calhoun, Texas, US |
3035418 | 3035418 | 2021-01-05 | US | Indiana | Perry | 18123 | 1261 | 25 | 0 | 1236 | 38.07809328 | -86.63741946 | 2021-01-06 05:22:16 | Perry, Indiana, US |
3034555 | 3034555 | 2021-01-05 | Russia | Tyumen Oblast | 24147 | 207 | 22704 | 1236 | 58.8206488 | 70.36588370000001 | 2021-01-06 05:22:16 | Tyumen Oblast, Russia | ||
3696262 | 3696262 | 2020-12-31 | US | Georgia | Cook | 13075 | 1261 | 25 | 0 | 1236 | 31.16068491 | -83.42947229 | 2021-01-01 05:23:07 | Cook, Georgia, US |
1012596 | 1012596 | 2020-12-30 | US | North Carolina | Cherokee | 37039 | 1251 | 15 | 0 | 1236 | 35.1349263 | -84.05970864 | 2020-12-31 05:22:49 | Cherokee, North Carolina, US |
3762050 | 3762050 | 2020-12-28 | US | Arkansas | Conway | 5029 | 1249 | 13 | 0 | 1236 | 35.26205537 | -92.70506566 | 2020-12-29 05:22:37 | Conway, Arkansas, US |
2225442 | 2225442 | 2020-12-26 | US | Missouri | Pemiscot | 29155 | 1256 | 20 | 0 | 1236 | 36.2130572 | -89.78742322 | 2020-12-27 05:22:55 | Pemiscot, Missouri, US |
205070 | 205070 | 2020-12-25 | US | South Carolina | Jasper | 45053 | 1261 | 25 | 0 | 1236 | 32.43171982 | -81.02487495 | 2020-12-26 05:22:28 | Jasper, South Carolina, US |
203239 | 203239 | 2020-12-25 | US | Illinois | Hancock | 17067 | 1256 | 20 | 0 | 1236 | 40.40423981 | -91.16313899 | 2020-12-26 05:22:28 | Hancock, Illinois, US |
3694293 | 3694293 | 2020-12-24 | US | South Carolina | Jasper | 45053 | 1261 | 25 | 0 | 1236 | 32.43171982 | -81.02487495 | 2020-12-25 05:22:48 | Jasper, South Carolina, US |
2408042 | 2408042 | 2020-12-23 | US | Iowa | Mills | 19129 | 1249 | 13 | 0 | 1236 | 41.03299766 | -95.61920963 | 2020-12-24 05:23:04 | Mills, Iowa, US |
3773041 | 3773041 | 2020-12-22 | US | Texas | Milam | 48331 | 780 | 11 | 0 | 1236 | 30.785818300000006 | -96.97718698 | 2020-12-23 05:22:03 | Milam, Texas, US |
3772430 | 3772430 | 2020-12-22 | US | Oklahoma | Kingfisher | 40073 | 1244 | 8 | 0 | 1236 | 35.94530008 | -97.94193268 | 2020-12-23 05:22:03 | Kingfisher, Oklahoma, US |
2121677 | 2121677 | 2020-12-20 | US | Missouri | Texas | 29215 | 1249 | 13 | 0 | 1236 | 37.31728859 | -91.96564727 | 2020-12-21 05:27:58 | Texas, Missouri, US |
2932299 | 2932299 | 2020-12-19 | US | Indiana | Fulton | 18049 | 1265 | 29 | 0 | 1236 | 41.0469907 | -86.26252745 | 2020-12-20 05:27:32 | Fulton, Indiana, US |
2131545 | 2131545 | 2020-12-17 | US | Wisconsin | Marquette | 55077 | 1254 | 18 | 0 | 1236 | 43.81911946 | -89.40073763 | 2020-12-18 05:28:18 | Marquette, Wisconsin, US |
3152897 | 3152897 | 2020-12-16 | US | Virginia | Carroll | 51035 | 1267 | 31 | 0 | 1236 | 36.73066666 | -80.73455942 | 2020-12-17 05:28:12 | Carroll, Virginia, US |
848402 | 848402 | 2020-12-12 | US | South Carolina | Union | 45087 | 1269 | 33 | 0 | 1236 | 34.68835752 | -81.61730349 | 2020-12-13 05:27:20 | Union, South Carolina, US |
847120 | 847120 | 2020-12-12 | US | Maine | Penobscot | 23019 | 1251 | 15 | 0 | 1236 | 45.40194593 | -68.65020455 | 2020-12-13 05:27:20 | Penobscot, Maine, US |
1601663 | 1601663 | 2020-12-10 | US | Kentucky | Ohio | 21183 | 1255 | 19 | 0 | 1236 | 37.47751843 | -86.85368087 | 2020-12-11 05:26:59 | Ohio, Kentucky, US |
1821737 | 1821737 | 2020-12-08 | US | Tennessee | Lake | 47095 | 1253 | 8 | 0 | 1236 | 36.34180170000001 | -89.48921915 | 2020-12-09 05:28:01 | Lake, Tennessee, US |
2349438 | 2349438 | 2020-12-07 | US | Montana | Roosevelt | 30085 | 1278 | 42 | 0 | 1236 | 48.29607488 | -105.0079268 | 2020-12-08 05:27:42 | Roosevelt, Montana, US |
1006163 | 1006163 | 2020-12-06 | Congo (Kinshasa) | 13527 | 344 | 11947 | 1236 | -4.0383 | 21.7587 | 2020-12-07 05:26:14 | Congo (Kinshasa) | |||
1584764 | 1584764 | 2020-11-30 | US | Colorado | Crowley | 8025 | 1297 | 13 | 0 | 1236 | 38.32608609 | -103.7844965 | 2020-12-01 05:26:18 | Crowley, Colorado, US |
2937474 | 2937474 | 2020-11-28 | US | New York | Ontario | 36069 | 1273 | 37 | 0 | 1236 | 42.85145728 | -77.30874425 | 2020-11-29 05:25:55 | Ontario, New York, US |
392722 | 392722 | 2020-11-27 | US | Arkansas | Johnson | 5071 | 1247 | 11 | 0 | 1236 | 35.56759135 | -93.46036368 | 2020-11-28 05:25:50 | Johnson, Arkansas, US |
927120 | 927120 | 2020-11-26 | US | Washington | Lewis | 53041 | 1254 | 18 | 0 | 1236 | 46.57756476 | -122.3925769 | 2020-11-27 05:26:53 | Lewis, Washington, US |
924803 | 924803 | 2020-11-26 | US | Indiana | Randolph | 18135 | 1261 | 25 | 0 | 1236 | 40.15734772 | -85.01139319 | 2020-11-27 05:26:53 | Randolph, Indiana, US |
1352365 | 1352365 | 2020-11-24 | US | Nebraska | Colfax | 31037 | 1246 | 10 | 0 | 1236 | 41.57486951 | -97.0868542 | 2020-11-25 05:27:20 | Colfax, Nebraska, US |
1351209 | 1351209 | 2020-11-24 | US | Georgia | White | 13311 | 1263 | 27 | 0 | 1236 | 34.64624278 | -83.74905525 | 2020-11-25 05:27:20 | White, Georgia, US |
681159 | 681159 | 2020-11-23 | US | South Dakota | Clay | 46027 | 1245 | 9 | 0 | 1236 | 42.91296147 | -96.97656917 | 2020-11-24 05:27:31 | Clay, South Dakota, US |
680961 | 680961 | 2020-11-23 | US | Pennsylvania | Clearfield | 42033 | 1246 | 10 | 0 | 1236 | 41.00110782 | -78.47592663 | 2020-11-24 05:27:31 | Clearfield, Pennsylvania, 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]);