johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
173 rows where active = 1280 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2674032 | 2674032 | 2021-07-18 | Russia | Kurgan Oblast | 24149 | 476 | 22393 | 1280 | 55.7655302 | 64.5632681 | 2021-07-19 04:21:24 | Kurgan Oblast, Russia | ||
3741327 | 3741327 | 2021-07-12 | Russia | Samara Oblast | 70262 | 2407 | 66575 | 1280 | 53.2128813 | 50.8914633 | 2021-07-13 04:21:18 | Samara Oblast, Russia | ||
1440570 | 1440570 | 2021-07-07 | Italy | Marche | 103882 | 3038 | 99564 | 1280 | 43.61675973 | 13.5188753 | 2021-07-08 04:21:26 | Marche, Italy | ||
2071904 | 2071904 | 2021-07-02 | Italy | Marche | 103714 | 3037 | 99397 | 1280 | 43.61675973 | 13.5188753 | 2021-07-03 04:21:37 | Marche, Italy | ||
2071877 | 2071877 | 2021-07-02 | India | Nagaland | 25382 | 498 | 23604 | 1280 | 26.06702 | 94.470302 | 2021-07-03 04:21:37 | Nagaland, India | ||
2295405 | 2295405 | 2021-06-24 | India | Madhya Pradesh | 789561 | 8849 | 779432 | 1280 | 23.541513 | 78.289633 | 2021-06-25 04:21:33 | Madhya Pradesh, India | ||
3358875 | 3358875 | 2021-06-21 | Russia | Kaluga Oblast | 36764 | 358 | 35126 | 1280 | 54.4382773 | 35.5272854 | 2021-06-22 04:21:34 | Kaluga Oblast, Russia | ||
1952437 | 1952437 | 2021-05-21 | Ghana | 93521 | 783 | 91458 | 1280 | 7.9465 | -1.0232 | 2021-05-22 04:20:45 | Ghana | |||
379974 | 379974 | 2021-04-30 | Chile | Antofagasta | 48754 | 963 | 46511 | 1280 | -23.6509 | -70.3975 | 2021-05-01 04:20:47 | Antofagasta, Chile | ||
1409054 | 1409054 | 2021-04-23 | Japan | Hokkaido | 23000 | 826 | 20894 | 1280 | 43.385711 | 142.552318 | 2021-04-24 04:20:38 | Hokkaido, Japan | ||
1568109 | 1568109 | 2021-04-22 | Japan | Chiba | 32056 | 613 | 30163 | 1280 | 35.510141 | 140.198917 | 2021-04-23 04:20:52 | Chiba, Japan | ||
3085067 | 3085067 | 2021-04-05 | Canada | Manitoba | 34487 | 940 | 32267 | 1280 | 53.7609 | -98.8139 | 2021-04-06 04:20:32 | Manitoba, Canada | ||
3668002 | 3668002 | 2021-03-06 | US | Alabama | Lowndes | 1085 | 1331 | 51 | 0 | 1280 | 32.1597283 | -86.65158371 | 2021-03-07 05:21:54 | Lowndes, Alabama, US |
1619920 | 1619920 | 2021-03-05 | Malaysia | Negeri Sembilan | 16284 | 30 | 14974 | 1280 | 2.7258 | 101.9424 | 2021-03-06 04:23:41 | Negeri Sembilan, Malaysia | ||
2208431 | 2208431 | 2021-03-04 | US | Georgia | Dade | 13083 | 1290 | 10 | 0 | 1280 | 34.854916700000004 | -85.50490424 | 2021-03-05 05:26:29 | Dade, Georgia, US |
2208414 | 2208414 | 2021-03-04 | US | Georgia | Charlton | 13049 | 1307 | 27 | 0 | 1280 | 30.78371028 | -82.13951596 | 2021-03-05 05:26:29 | Charlton, Georgia, US |
1093645 | 1093645 | 2021-03-03 | US | Wisconsin | Rusk | 55107 | 1297 | 17 | 0 | 1280 | 45.47498854 | -91.1333012 | 2021-03-04 05:24:24 | Rusk, Wisconsin, US |
1090835 | 1090835 | 2021-03-03 | US | Georgia | Charlton | 13049 | 1307 | 27 | 0 | 1280 | 30.78371028 | -82.13951596 | 2021-03-04 05:24:24 | Charlton, Georgia, US |
3257717 | 3257717 | 2021-03-02 | US | Wisconsin | Rusk | 55107 | 1297 | 17 | 0 | 1280 | 45.47498854 | -91.1333012 | 2021-03-03 05:23:28 | Rusk, Wisconsin, US |
3069279 | 3069279 | 2021-02-27 | US | Vermont | Rutland | 50021 | 1291 | 11 | 0 | 1280 | 43.57723578 | -73.03741676 | 2021-02-28 05:22:20 | Rutland, Vermont, US |
471885 | 471885 | 2021-02-19 | US | Arkansas | Desha | 5041 | 1301 | 21 | 0 | 1280 | 33.83011025 | -91.25500948 | 2021-02-20 05:22:51 | Desha, Arkansas, US |
1155469 | 1155469 | 2021-02-18 | US | North Carolina | Polk | 37149 | 1305 | 25 | 0 | 1280 | 35.27820615 | -82.16812354 | 2021-02-19 05:24:16 | Polk, North Carolina, US |
1154166 | 1154166 | 2021-02-18 | US | Illinois | Wabash | 17185 | 1292 | 12 | 0 | 1280 | 38.44272901 | -87.84922065 | 2021-02-19 05:24:16 | Wabash, Illinois, US |
1154146 | 1154146 | 2021-02-18 | US | Illinois | Piatt | 17147 | 1293 | 13 | 0 | 1280 | 40.01360584 | -88.59319339 | 2021-02-19 05:24:16 | Piatt, Illinois, US |
3601047 | 3601047 | 2021-02-17 | Japan | Fukuoka | 17555 | 251 | 16024 | 1280 | 33.526032 | 130.666949 | 2021-02-18 05:22:58 | Fukuoka, Japan | ||
2286203 | 2286203 | 2021-02-14 | US | Puerto Rico | Vega Alta | 72143 | 1280 | 0 | 0 | 1280 | 18.409346 | -66.33725 | 2021-02-15 05:24:49 | Vega Alta, Puerto Rico, US |
976350 | 976350 | 2021-02-06 | US | Kentucky | Mason | 21161 | 1306 | 26 | 0 | 1280 | 38.59471935 | -83.82151043 | 2021-02-07 05:23:00 | Mason, Kentucky, US |
1685346 | 1685346 | 2021-02-02 | US | Georgia | Oglethorpe | 13221 | 1297 | 17 | 0 | 1280 | 33.878629600000004 | -83.08278123 | 2021-02-03 05:22:52 | Oglethorpe, Georgia, US |
1676822 | 1676822 | 2021-02-01 | US | Alabama | Clay | 1027 | 1330 | 50 | 0 | 1280 | 33.26984193 | -85.85836077 | 2021-02-02 05:22:49 | Clay, Alabama, US |
1462523 | 1462523 | 2021-01-31 | US | Puerto Rico | Rio Grande | 72119 | 1280 | 0 | 0 | 1280 | 18.346329 | -65.813742 | 2021-02-01 05:22:53 | Rio Grande, Puerto Rico, US |
1461444 | 1461444 | 2021-01-31 | US | Michigan | Wexford | 26165 | 1300 | 20 | 0 | 1280 | 44.33853602 | -85.57712739 | 2021-02-01 05:22:53 | Wexford, Michigan, US |
2213352 | 2213352 | 2021-01-30 | US | Michigan | Wexford | 26165 | 1300 | 20 | 0 | 1280 | 44.33853602 | -85.57712739 | 2021-01-31 05:22:42 | Wexford, Michigan, US |
1898148 | 1898148 | 2021-01-29 | US | Illinois | Johnson | 17087 | 1289 | 9 | 0 | 1280 | 37.45939802 | -88.88165419 | 2021-01-30 05:22:49 | Johnson, Illinois, US |
1896990 | 1896990 | 2021-01-29 | Colombia | Bolivar | 63212 | 1262 | 60670 | 1280 | 8.6704 | -74.03 | 2021-01-30 05:22:49 | Bolivar, Colombia | ||
3156347 | 3156347 | 2021-01-27 | US | Puerto Rico | Juncos | 72077 | 1280 | 0 | 0 | 1280 | 18.223793 | -65.909109 | 2021-01-28 05:22:24 | Juncos, Puerto Rico, US |
3155578 | 3155578 | 2021-01-27 | US | Missouri | Wright | 29229 | 1304 | 24 | 0 | 1280 | 37.27029221 | -92.46914488 | 2021-01-28 05:22:24 | Wright, Missouri, US |
12408 | 12408 | 2021-01-26 | Maldives | 15247 | 51 | 13916 | 1280 | 3.2028 | 73.2207 | 2021-01-27 05:23:41 | Maldives | |||
2570702 | 2570702 | 2021-01-25 | US | Texas | Childress | 48075 | 1413 | 13 | 0 | 1280 | 34.529304100000004 | -100.2077916 | 2021-01-26 05:22:02 | Childress, Texas, US |
2568413 | 2568413 | 2021-01-25 | US | Georgia | Brantley | 13025 | 1305 | 25 | 0 | 1280 | 31.19576557 | -81.97743999 | 2021-01-26 05:22:02 | Brantley, Georgia, US |
2568147 | 2568147 | 2021-01-25 | US | Arkansas | Howard | 5061 | 1301 | 21 | 0 | 1280 | 34.09007427 | -93.9934871 | 2021-01-26 05:22:02 | Howard, Arkansas, US |
1762341 | 1762341 | 2021-01-24 | US | Texas | Colorado | 48089 | 1326 | 19 | 0 | 1280 | 29.622098 | -96.5273805 | 2021-01-25 05:22:16 | Colorado, Texas, US |
1762334 | 1762334 | 2021-01-24 | US | Texas | Childress | 48075 | 1413 | 13 | 0 | 1280 | 34.529304100000004 | -100.2077916 | 2021-01-25 05:22:16 | Childress, Texas, US |
2429941 | 2429941 | 2021-01-23 | US | Texas | Childress | 48075 | 1413 | 13 | 0 | 1280 | 34.529304100000004 | -100.2077916 | 2021-01-24 05:22:35 | Childress, Texas, US |
2469759 | 2469759 | 2021-01-22 | US | Tennessee | Lewis | 47101 | 1335 | 21 | 0 | 1280 | 35.52853208 | -87.49022694 | 2021-01-23 05:22:03 | Lewis, Tennessee, US |
239158 | 239158 | 2021-01-18 | US | Missouri | Madison | 29123 | 1291 | 11 | 0 | 1280 | 37.47865134 | -90.3467143 | 2021-01-19 05:22:15 | Madison, Missouri, US |
3101390 | 3101390 | 2021-01-16 | India | Jammu and Kashmir | 123217 | 1921 | 120016 | 1280 | 33.75943 | 76.612638 | 2021-01-17 05:22:17 | Jammu and Kashmir, India | ||
3309803 | 3309803 | 2021-01-13 | US | Michigan | Alpena | 26007 | 1319 | 39 | 0 | 1280 | 45.03477666 | -83.62212411 | 2021-01-14 05:22:32 | Alpena, Michigan, US |
2628171 | 2628171 | 2021-01-10 | US | North Carolina | Dare | 37055 | 1285 | 5 | 0 | 1280 | 35.66520691 | -75.71767334 | 2021-01-11 05:21:50 | Dare, North Carolina, US |
155417 | 155417 | 2021-01-08 | US | Kentucky | Meade | 21163 | 1284 | 4 | 0 | 1280 | 37.96163597 | -86.21028219 | 2021-01-09 05:22:18 | Meade, Kentucky, US |
2868286 | 2868286 | 2021-01-06 | US | Wisconsin | Sawyer | 55113 | 1292 | 12 | 0 | 1280 | 45.87931905 | -91.14504927 | 2021-01-07 05:22:03 | Sawyer, Wisconsin, US |
1063241 | 1063241 | 2021-01-04 | US | Kentucky | Grant | 21081 | 1290 | 10 | 0 | 1280 | 38.64962758 | -84.62415957 | 2021-01-05 05:21:49 | Grant, Kentucky, US |
2229041 | 2229041 | 2021-01-02 | US | Louisiana | St. James | 22093 | 1323 | 43 | 0 | 1280 | 30.02531716 | -90.80212061 | 2021-01-03 05:22:52 | St. James, Louisiana, US |
1138405 | 1138405 | 2021-01-01 | US | Louisiana | St. James | 22093 | 1323 | 43 | 0 | 1280 | 30.02531716 | -90.80212061 | 2021-01-02 05:22:33 | St. James, Louisiana, US |
3697011 | 3697011 | 2020-12-31 | US | Louisiana | St. James | 22093 | 1323 | 43 | 0 | 1280 | 30.02531716 | -90.80212061 | 2021-01-01 05:23:07 | St. James, Louisiana, US |
766163 | 766163 | 2020-12-29 | Colombia | Cauca | 18388 | 496 | 16612 | 1280 | 2.705 | -76.82600000000002 | 2020-12-30 05:22:34 | Cauca, Colombia | ||
3779867 | 3779867 | 2020-12-27 | US | Missouri | Texas | 29215 | 1296 | 16 | 0 | 1280 | 37.31728859 | -91.96564727 | 2020-12-28 05:22:06 | Texas, Missouri, US |
3778679 | 3778679 | 2020-12-27 | US | Georgia | Crisp | 13081 | 1318 | 38 | 0 | 1280 | 31.92289565 | -83.76811843 | 2020-12-28 05:22:06 | Crisp, Georgia, US |
3772866 | 3772866 | 2020-12-22 | US | Tennessee | Unicoi | 47171 | 1314 | 38 | 0 | 1280 | 36.10890856 | -82.43709629 | 2020-12-23 05:22:03 | Unicoi, Tennessee, US |
3771375 | 3771375 | 2020-12-22 | US | Louisiana | Jackson | 22049 | 1317 | 37 | 0 | 1280 | 32.30251776 | -92.55692092 | 2020-12-23 05:22:03 | Jackson, Louisiana, US |
929181 | 929181 | 2020-12-21 | US | Louisiana | Concordia | 22029 | 1313 | 33 | 0 | 1280 | 31.44817835 | -91.63814433 | 2020-12-22 05:22:33 | Concordia, Louisiana, US |
2123108 | 2123108 | 2020-12-20 | US | Virginia | Russell | 51167 | 1294 | 14 | 0 | 1280 | 36.93028320000001 | -82.10095486 | 2020-12-21 05:27:58 | Russell, Virginia, US |
1902329 | 1902329 | 2020-12-18 | US | Iowa | Cedar | 19031 | 1297 | 17 | 0 | 1280 | 41.77233777 | -91.13246684 | 2020-12-19 05:27:52 | Cedar, Iowa, US |
3150971 | 3150971 | 2020-12-16 | US | Kentucky | Clay | 21051 | 1288 | 8 | 0 | 1280 | 37.16451126 | -83.712575 | 2020-12-17 05:28:12 | Clay, Kentucky, US |
3150520 | 3150520 | 2020-12-16 | US | Idaho | Gem | 16045 | 1295 | 15 | 0 | 1280 | 44.06482372 | -116.398376 | 2020-12-17 05:28:12 | Gem, Idaho, US |
1037206 | 1037206 | 2020-12-15 | US | South Carolina | Union | 45087 | 1314 | 34 | 0 | 1280 | 34.68835752 | -81.61730349 | 2020-12-16 05:28:04 | Union, South Carolina, US |
1036388 | 1036388 | 2020-12-15 | US | Montana | Roosevelt | 30085 | 1322 | 42 | 0 | 1280 | 48.29607488 | -105.0079268 | 2020-12-16 05:28:04 | Roosevelt, Montana, US |
1754740 | 1754740 | 2020-12-14 | US | West Virginia | Hancock | 54029 | 1292 | 12 | 0 | 1280 | 40.51943859 | -80.57461608 | 2020-12-15 05:26:38 | Hancock, West Virginia, US |
1751812 | 1751812 | 2020-12-14 | US | California | Lake | 6033 | 1301 | 21 | 0 | 1280 | 39.10124298 | -122.7536244 | 2020-12-15 05:26:38 | Lake, California, US |
3848248 | 3848248 | 2020-12-13 | US | Arkansas | Chicot | 5017 | 1310 | 30 | 0 | 1280 | 33.26458973 | -91.29539209 | 2020-12-14 05:26:27 | Chicot, Arkansas, US |
1600475 | 1600475 | 2020-12-10 | Russia | Vladimir Oblast | 14724 | 360 | 13084 | 1280 | 56.0503336 | 40.6561633 | 2020-12-11 05:26:59 | Vladimir Oblast, Russia | ||
1822365 | 1822365 | 2020-12-08 | US | Wisconsin | Vernon | 55123 | 1295 | 15 | 0 | 1280 | 43.59422667 | -90.8324691 | 2020-12-09 05:28:01 | Vernon, Wisconsin, US |
1008176 | 1008176 | 2020-12-06 | US | Missouri | Crawford | 29055 | 1294 | 14 | 0 | 1280 | 37.97663738 | -91.30528104 | 2020-12-07 05:26:14 | Crawford, Missouri, US |
3863011 | 3863011 | 2020-12-04 | US | Texas | Palo Pinto | 48363 | 1269 | 35 | 0 | 1280 | 32.75310985 | -98.31319001 | 2020-12-05 05:27:36 | Palo Pinto, Texas, US |
3861754 | 3861754 | 2020-12-04 | US | Missouri | Moniteau | 29135 | 1295 | 15 | 0 | 1280 | 38.63571781 | -92.57976951 | 2020-12-05 05:27:36 | Moniteau, Missouri, US |
740602 | 740602 | 2020-12-02 | US | North Carolina | Davie | 37059 | 1293 | 13 | 0 | 1280 | 35.93099927 | -80.54496571 | 2020-12-03 05:28:22 | Davie, North Carolina, US |
2538641 | 2538641 | 2020-12-01 | US | Iowa | Wright | 19197 | 1287 | 7 | 0 | 1280 | 42.73305373 | -93.73515113 | 2020-12-02 05:27:41 | Wright, Iowa, US |
1584540 | 1584540 | 2020-11-30 | US | Alabama | Lawrence | 1079 | 1316 | 36 | 0 | 1280 | 34.52041498 | -87.31069453 | 2020-12-01 05:26:18 | Lawrence, Alabama, US |
3567478 | 3567478 | 2020-11-29 | US | Idaho | Blaine | 16013 | 1287 | 7 | 0 | 1280 | 43.4085812 | -113.9752658 | 2020-11-30 05:26:13 | Blaine, Idaho, US |
2938717 | 2938717 | 2020-11-28 | US | West Virginia | Mercer | 54055 | 1317 | 37 | 0 | 1280 | 37.40481169 | -81.11023142 | 2020-11-29 05:25:55 | Mercer, West Virginia, US |
1972834 | 1972834 | 2020-11-25 | Russia | Tambov Oblast | 12589 | 75 | 11234 | 1280 | 52.9019574 | 41.3578918 | 2020-11-26 05:27:44 | Tambov Oblast, Russia | ||
3193406 | 3193406 | 2020-11-22 | US | Washington | Adams | 53001 | 1292 | 12 | 0 | 1280 | 46.98299757 | -118.5601734 | 2020-11-23 05:25:26 | Adams, Washington, US |
3191711 | 3191711 | 2020-11-22 | US | Minnesota | Le Sueur | 27079 | 1289 | 9 | 0 | 1280 | 44.37136597 | -93.72844721 | 2020-11-23 05:25:26 | Le Sueur, Minnesota, US |
3190447 | 3190447 | 2020-11-22 | US | Arkansas | Carroll | 5015 | 1301 | 21 | 0 | 1280 | 36.34038560000001 | -93.54270261 | 2020-11-23 05:25:26 | Carroll, Arkansas, US |
3837325 | 3837325 | 2020-11-21 | US | Georgia | Oconee | 13219 | 1315 | 35 | 0 | 1280 | 33.83749973 | -83.43679568 | 2020-11-22 05:25:45 | Oconee, Georgia, US |
2704759 | 2704759 | 2020-11-20 | US | Texas | Wood | 48499 | 517 | 47 | 0 | 1280 | 32.78722382 | -95.38236368 | 2020-11-21 05:25:51 | Wood, Texas, US |
825107 | 825107 | 2020-11-19 | US | Wisconsin | Green Lake | 55047 | 1285 | 5 | 0 | 1280 | 43.80025981 | -89.04679553 | 2020-11-20 05:26:28 | Green Lake, Wisconsin, US |
823479 | 823479 | 2020-11-19 | US | Missouri | Lafayette | 29107 | 1309 | 29 | 0 | 1280 | 39.06986886 | -93.78076396 | 2020-11-20 05:26:28 | Lafayette, Missouri, US |
2786737 | 2786737 | 2020-11-13 | US | Minnesota | Morrison | 27097 | 1296 | 16 | 0 | 1280 | 46.01265363 | -94.27341528 | 2020-11-14 05:25:37 | Morrison, Minnesota, US |
2785676 | 2785676 | 2020-11-13 | US | Florida | Bradford | 12007 | 1295 | 15 | 0 | 1280 | 29.95079741 | -82.16611613 | 2020-11-14 05:25:37 | Bradford, Florida, US |
866352 | 866352 | 2020-11-12 | US | Maryland | Worcester | 24047 | 1311 | 31 | 0 | 1280 | 38.21274277 | -75.33200012 | 2020-11-13 05:25:30 | Worcester, Maryland, US |
3441939 | 3441939 | 2020-11-11 | US | Indiana | Shelby | 18145 | 1329 | 49 | 0 | 1280 | 39.52305623 | -85.79158570000001 | 2020-11-12 05:25:55 | Shelby, Indiana, US |
1990416 | 1990416 | 2020-11-09 | US | Mississippi | Coahoma | 28027 | 1317 | 37 | 0 | 1280 | 34.22772299 | -90.60415045 | 2020-11-10 05:40:07 | Coahoma, Mississippi, US |
1729460 | 1729460 | 2020-11-08 | US | Illinois | Franklin | 17055 | 1293 | 13 | 0 | 1280 | 37.99189086 | -88.92567818 | 2020-11-09 05:25:45 | Franklin, Illinois, US |
378980 | 378980 | 2020-11-06 | US | South Carolina | Chester | 45023 | 1310 | 30 | 0 | 1280 | 34.69249168 | -81.1583216 | 2020-11-07 05:24:52 | Chester, South Carolina, US |
2921089 | 2921089 | 2020-11-04 | US | Missouri | Laclede | 29105 | 1303 | 23 | 0 | 1280 | 37.65896829 | -92.5888493 | 2020-11-05 06:05:03 | Laclede, Missouri, US |
2498917 | 2498917 | 2020-11-03 | US | Hawaii | Hawaii | 15001 | 1311 | 31 | 0 | 1280 | 19.60121157 | -155.5210167 | 2020-11-04 05:25:09 | Hawaii, Hawaii, US |
3307188 | 3307188 | 2020-11-02 | US | Tennessee | White | 47185 | 1269 | 15 | 0 | 1280 | 35.92929884 | -85.45591799 | 2020-11-03 06:00:16 | White, Tennessee, US |
3304971 | 3304971 | 2020-11-02 | US | Georgia | Decatur | 13087 | 1315 | 35 | 0 | 1280 | 30.87967778 | -84.57619536 | 2020-11-03 06:00:16 | Decatur, Georgia, US |
3410220 | 3410220 | 2020-11-01 | US | Georgia | Decatur | 13087 | 1315 | 35 | 0 | 1280 | 30.87967778 | -84.57619536 | 2020-11-02 05:25:04 | Decatur, Georgia, US |
2244466 | 2244466 | 2020-10-30 | US | Indiana | Hancock | 18059 | 1324 | 44 | 0 | 1280 | 39.82304555 | -85.77566351 | 2020-10-31 04:24:44 | Hancock, Indiana, 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]);