johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
178 rows where active = 1339 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3019019 | 3019019 | 2021-08-01 | West Bank and Gaza | 316861 | 3604 | 311918 | 1339 | 31.9522 | 35.2332 | 2021-08-02 04:21:36 | West Bank and Gaza | |||
2947601 | 2947601 | 2021-07-16 | Russia | Sakhalin Oblast | 25878 | 85 | 24454 | 1339 | 49.7219665 | 143.448533 | 2021-07-17 04:22:22 | Sakhalin Oblast, Russia | ||
2947326 | 2947326 | 2021-07-16 | India | Uttar Pradesh | 1707741 | 22711 | 1683691 | 1339 | 26.925425 | 80.560982 | 2021-07-17 04:22:22 | Uttar Pradesh, India | ||
578819 | 578819 | 2021-07-13 | Italy | Marche | 104047 | 3038 | 99670 | 1339 | 43.61675973 | 13.5188753 | 2021-07-14 04:21:35 | Marche, Italy | ||
1708560 | 1708560 | 2021-06-02 | Russia | Tambov Oblast | 32950 | 540 | 31071 | 1339 | 52.9019574 | 41.3578918 | 2021-06-03 04:23:32 | Tambov Oblast, Russia | ||
1085602 | 1085602 | 2021-05-14 | Malaysia | Negeri Sembilan | 20373 | 42 | 18992 | 1339 | 2.7258 | 101.9424 | 2021-05-15 04:20:58 | Negeri Sembilan, Malaysia | ||
2824445 | 2824445 | 2021-05-10 | Malaysia | Kedah | 11422 | 32 | 10051 | 1339 | 6.1184 | 100.3685 | 2021-05-11 04:20:41 | Kedah, Malaysia | ||
2821000 | 2821000 | 2021-05-10 | Russia | Novgorod Oblast | 30239 | 127 | 28773 | 1339 | 58.2843833 | 32.5169757 | 2021-05-11 04:20:41 | Novgorod Oblast, Russia | ||
1425437 | 1425437 | 2021-05-09 | Togo | 13154 | 124 | 11691 | 1339 | 8.6195 | 0.8248 | 2021-05-10 04:20:38 | Togo | |||
170283 | 170283 | 2021-04-16 | Russia | Ryazan Oblast | 27123 | 413 | 25371 | 1339 | 54.42267320000001 | 40.57052460000001 | 2021-04-17 04:20:40 | Ryazan Oblast, Russia | ||
170158 | 170158 | 2021-04-16 | Namibia | 46330 | 599 | 44392 | 1339 | -22.9576 | 18.4904 | 2021-04-17 04:20:40 | Namibia | |||
2247611 | 2247611 | 2021-04-07 | Russia | Kurgan Oblast | 19500 | 362 | 17799 | 1339 | 55.7655302 | 64.5632681 | 2021-04-08 04:21:13 | Kurgan Oblast, Russia | ||
1219539 | 1219539 | 2021-03-27 | India | Uttarakhand | 99515 | 1709 | 96467 | 1339 | 30.156447 | 79.197608 | 2021-03-28 05:28:10 | Uttarakhand, India | ||
3421124 | 3421124 | 2021-03-19 | Russia | Karachay-Cherkess Republic | 19471 | 68 | 18064 | 1339 | 43.7368326 | 41.7267991 | 2021-03-20 05:25:46 | Karachay-Cherkess Republic, Russia | ||
1618813 | 1618813 | 2021-03-05 | US | Oklahoma | Noble | 40103 | 1352 | 13 | 0 | 1339 | 36.38953329 | -97.22928674 | 2021-03-06 04:23:41 | Noble, Oklahoma, US |
1617945 | 1617945 | 2021-03-05 | US | Minnesota | Cottonwood | 27033 | 1359 | 20 | 0 | 1339 | 44.00715262 | -95.18138802 | 2021-03-06 04:23:41 | Cottonwood, Minnesota, US |
1091456 | 1091456 | 2021-03-03 | US | Kentucky | Clinton | 21053 | 1365 | 26 | 0 | 1339 | 36.72581156 | -85.13377529 | 2021-03-04 05:24:24 | Clinton, Kentucky, US |
1091069 | 1091069 | 2021-03-03 | US | Illinois | Johnson | 17087 | 1351 | 12 | 0 | 1339 | 37.45939802 | -88.88165419 | 2021-03-04 05:24:24 | Johnson, Illinois, US |
1090272 | 1090272 | 2021-03-03 | Russia | Irkutsk Oblast | 56325 | 1806 | 53180 | 1339 | 56.6370122 | 104.719221 | 2021-03-04 05:24:24 | Irkutsk Oblast, Russia | ||
998791 | 998791 | 2021-03-01 | US | Alabama | Cleburne | 1029 | 1378 | 39 | 0 | 1339 | 33.67679204 | -85.52005899 | 2021-03-02 05:23:30 | Cleburne, Alabama, US |
282483 | 282483 | 2021-02-24 | US | North Carolina | Currituck | 37053 | 1354 | 15 | 0 | 1339 | 36.36123664 | -75.95876401 | 2021-02-25 05:24:57 | Currituck, North Carolina, US |
532679 | 532679 | 2021-02-22 | US | Missouri | Wright | 29229 | 1366 | 27 | 0 | 1339 | 37.27029221 | -92.46914488 | 2021-02-23 05:23:41 | Wright, Missouri, US |
531894 | 531894 | 2021-02-22 | US | Iowa | Hancock | 19081 | 1368 | 29 | 0 | 1339 | 43.08178477 | -93.73454884 | 2021-02-23 05:23:41 | Hancock, Iowa, US |
743159 | 743159 | 2021-02-20 | US | Georgia | Oglethorpe | 13221 | 1364 | 25 | 0 | 1339 | 33.878629600000004 | -83.08278123 | 2021-02-21 05:24:33 | Oglethorpe, Georgia, US |
3603008 | 3603008 | 2021-02-17 | US | Missouri | Vernon | 29217 | 1373 | 34 | 0 | 1339 | 37.8457799 | -94.34127305 | 2021-02-18 05:22:58 | Vernon, Missouri, US |
3051608 | 3051608 | 2021-02-16 | US | Kentucky | Mason | 21161 | 1366 | 27 | 0 | 1339 | 38.59471935 | -83.82151043 | 2021-02-17 05:23:10 | Mason, Kentucky, US |
3051326 | 3051326 | 2021-02-16 | US | Iowa | Allamakee | 19005 | 1380 | 41 | 0 | 1339 | 43.28383218 | -91.37860922 | 2021-02-17 05:23:10 | Allamakee, Iowa, US |
3051157 | 3051157 | 2021-02-16 | US | Illinois | Greene | 17061 | 1370 | 31 | 0 | 1339 | 39.35907414 | -90.388865 | 2021-02-17 05:23:10 | Greene, Illinois, US |
1339707 | 1339707 | 2021-02-15 | US | Kentucky | Mason | 21161 | 1365 | 26 | 0 | 1339 | 38.59471935 | -83.82151043 | 2021-02-16 05:24:38 | Mason, Kentucky, US |
2678184 | 2678184 | 2021-02-13 | US | Alabama | Crenshaw | 1041 | 1390 | 51 | 0 | 1339 | 31.72941803 | -86.31593104 | 2021-02-14 05:23:43 | Crenshaw, Alabama, US |
1529752 | 1529752 | 2021-02-09 | US | Mississippi | Yalobusha | 28161 | 1375 | 36 | 0 | 1339 | 34.02824175 | -89.70762049999998 | 2021-02-10 05:22:41 | Yalobusha, Mississippi, US |
794058 | 794058 | 2021-02-04 | Malaysia | Kedah | 6067 | 18 | 4710 | 1339 | 6.1184 | 100.3685 | 2021-02-05 05:22:38 | Kedah, Malaysia | ||
1687884 | 1687884 | 2021-02-02 | US | Virginia | Powhatan | 51145 | 1346 | 7 | 0 | 1339 | 37.55016038 | -77.91267882 | 2021-02-03 05:22:52 | Powhatan, Virginia, US |
1687455 | 1687455 | 2021-02-02 | US | Tennessee | Lewis | 47101 | 1398 | 23 | 0 | 1339 | 35.52853208 | -87.49022694 | 2021-02-03 05:22:52 | Lewis, Tennessee, US |
1687407 | 1687407 | 2021-02-02 | US | Tennessee | Benton | 47005 | 1449 | 36 | 0 | 1339 | 36.07110411 | -88.06849355 | 2021-02-03 05:22:52 | Benton, Tennessee, US |
1679377 | 1679377 | 2021-02-01 | US | Tennessee | Benton | 47005 | 1445 | 35 | 0 | 1339 | 36.07110411 | -88.06849355 | 2021-02-02 05:22:49 | Benton, Tennessee, US |
2214877 | 2214877 | 2021-01-30 | US | Texas | Shelby | 48419 | 1471 | 49 | 0 | 1339 | 31.79211404 | -94.14550696 | 2021-01-31 05:22:42 | Shelby, Texas, US |
2570737 | 2570737 | 2021-01-25 | US | Texas | Falls | 48145 | 1619 | 23 | 0 | 1339 | 31.25350609 | -96.93630086 | 2021-01-26 05:22:02 | Falls, Texas, US |
2428849 | 2428849 | 2021-01-23 | US | Missouri | Ray | 29177 | 1356 | 17 | 0 | 1339 | 39.3537468 | -93.98905745 | 2021-01-24 05:22:35 | Ray, Missouri, US |
2428337 | 2428337 | 2021-01-23 | US | Kentucky | McCreary | 21147 | 1351 | 12 | 0 | 1339 | 36.73874143 | -84.48102924 | 2021-01-24 05:22:35 | McCreary, Kentucky, US |
2468555 | 2468555 | 2021-01-22 | US | Minnesota | Renville | 27129 | 1379 | 40 | 0 | 1339 | 44.72836381 | -94.94553734 | 2021-01-23 05:22:03 | Renville, Minnesota, US |
2468430 | 2468430 | 2021-01-22 | US | Michigan | Gladwin | 26051 | 1377 | 38 | 0 | 1339 | 43.98901072 | -84.38774817 | 2021-01-23 05:22:03 | Gladwin, Michigan, US |
2467009 | 2467009 | 2021-01-22 | Russia | Kamchatka Krai | 11715 | 83 | 10293 | 1339 | 57.1914882 | 160.03838190000005 | 2021-01-23 05:22:03 | Kamchatka Krai, Russia | ||
911629 | 911629 | 2021-01-19 | US | Washington | Stevens | 53065 | 1358 | 19 | 0 | 1339 | 48.40035475 | -117.8542701 | 2021-01-20 05:21:54 | Stevens, Washington, US |
238945 | 238945 | 2021-01-18 | US | Minnesota | Dodge | 27039 | 1343 | 4 | 0 | 1339 | 44.02238415 | -92.86244324 | 2021-01-19 05:22:15 | Dodge, Minnesota, US |
3102186 | 3102186 | 2021-01-16 | US | Georgia | Berrien | 13019 | 1371 | 32 | 0 | 1339 | 31.27590016 | -83.22529920000002 | 2021-01-17 05:22:17 | Berrien, Georgia, US |
3516823 | 3516823 | 2021-01-15 | US | Kentucky | Letcher | 21133 | 1343 | 4 | 0 | 1339 | 37.12306748 | -82.85346474 | 2021-01-16 05:22:40 | Letcher, Kentucky, US |
3516614 | 3516614 | 2021-01-15 | US | Iowa | Mills | 19129 | 1355 | 16 | 0 | 1339 | 41.03299766 | -95.61920963 | 2021-01-16 05:22:40 | Mills, Iowa, US |
3515806 | 3515806 | 2021-01-15 | US | Alabama | Washington | 1129 | 1365 | 26 | 0 | 1339 | 31.4092794 | -88.20689944 | 2021-01-16 05:22:40 | Washington, Alabama, US |
3515109 | 3515109 | 2021-01-15 | Bahamas | 8021 | 175 | 6507 | 1339 | 25.025885 | -78.035889 | 2021-01-16 05:22:40 | Bahamas | |||
3883089 | 3883089 | 2021-01-14 | US | West Virginia | Wyoming | 54109 | 1363 | 24 | 0 | 1339 | 37.612327 | -81.54511071 | 2021-01-15 05:22:24 | Wyoming, West Virginia, US |
3882721 | 3882721 | 2021-01-14 | US | Texas | Limestone | 48293 | 1557 | 32 | 0 | 1339 | 31.5454767 | -96.58095444 | 2021-01-15 05:22:24 | Limestone, Texas, US |
3309367 | 3309367 | 2021-01-13 | US | Iowa | Cherokee | 19035 | 1364 | 25 | 0 | 1339 | 42.73538914 | -95.62389402 | 2021-01-14 05:22:32 | Cherokee, Iowa, US |
777320 | 777320 | 2021-01-12 | US | Tennessee | Polk | 47139 | 1337 | 17 | 0 | 1339 | 35.12245443 | -84.52075859 | 2021-01-13 05:22:15 | Polk, Tennessee, US |
777280 | 777280 | 2021-01-12 | US | Tennessee | Grundy | 47061 | 1411 | 20 | 0 | 1339 | 35.38433717 | -85.72142731 | 2021-01-13 05:22:15 | Grundy, Tennessee, US |
776095 | 776095 | 2021-01-12 | US | Minnesota | Redwood | 27127 | 1366 | 27 | 0 | 1339 | 44.40555844 | -95.25207021 | 2021-01-13 05:22:15 | Redwood, Minnesota, US |
2627861 | 2627861 | 2021-01-10 | US | Montana | Glacier | 30035 | 1363 | 24 | 0 | 1339 | 48.70513576 | -112.9934235 | 2021-01-11 05:21:50 | Glacier, Montana, US |
3902105 | 3902105 | 2021-01-09 | US | New Hampshire | Grafton | 33009 | 1348 | 9 | 0 | 1339 | 43.93779815 | -71.82057197 | 2021-01-10 05:22:12 | Grafton, New Hampshire, US |
2866111 | 2866111 | 2021-01-06 | US | Kentucky | Grayson | 21085 | 1372 | 33 | 0 | 1339 | 37.46231118 | -86.34248968 | 2021-01-07 05:22:03 | Grayson, Kentucky, US |
2864850 | 2864850 | 2021-01-06 | Niger | 3634 | 113 | 2182 | 1339 | 17.607789 | 8.081666 | 2021-01-07 05:22:03 | Niger | |||
1062332 | 1062332 | 2021-01-04 | US | Arkansas | Izard | 5065 | 1354 | 15 | 0 | 1339 | 36.09604046 | -91.90847954 | 2021-01-05 05:21:49 | Izard, Arkansas, US |
3230935 | 3230935 | 2021-01-03 | US | Arkansas | Izard | 5065 | 1352 | 13 | 0 | 1339 | 36.09604046 | -91.90847954 | 2021-01-04 05:22:02 | Izard, Arkansas, US |
1138898 | 1138898 | 2021-01-01 | US | Montana | Roosevelt | 30085 | 1390 | 51 | 0 | 1339 | 48.29607488 | -105.0079268 | 2021-01-02 05:22:33 | Roosevelt, Montana, US |
3697504 | 3697504 | 2020-12-31 | US | Montana | Roosevelt | 30085 | 1390 | 51 | 0 | 1339 | 48.29607488 | -105.0079268 | 2021-01-01 05:23:07 | Roosevelt, Montana, US |
1010439 | 1010439 | 2020-12-30 | Niger | 3208 | 102 | 1767 | 1339 | 17.607789 | 8.081666 | 2020-12-31 05:22:49 | Niger | |||
769004 | 769004 | 2020-12-29 | US | Pennsylvania | Pike | 42103 | 1372 | 33 | 0 | 1339 | 41.33155042 | -75.03208106 | 2020-12-30 05:22:34 | Pike, Pennsylvania, US |
768976 | 768976 | 2020-12-29 | US | Pennsylvania | Elk | 42047 | 1354 | 15 | 0 | 1339 | 41.42822061 | -78.64524744 | 2020-12-30 05:22:34 | Elk, Pennsylvania, US |
766454 | 766454 | 2020-12-29 | Niger | 3208 | 102 | 1767 | 1339 | 17.607789 | 8.081666 | 2020-12-30 05:22:34 | Niger | |||
3764842 | 3764842 | 2020-12-28 | US | Utah | San Juan | 49037 | 1371 | 32 | 0 | 1339 | 37.62762978 | -109.80337140000002 | 2020-12-29 05:22:37 | San Juan, Utah, US |
3763598 | 3763598 | 2020-12-28 | US | Montana | Roosevelt | 30085 | 1381 | 42 | 0 | 1339 | 48.29607488 | -105.0079268 | 2020-12-29 05:22:37 | Roosevelt, Montana, US |
2226498 | 2226498 | 2020-12-26 | US | Tennessee | Unicoi | 47171 | 1370 | 38 | 0 | 1339 | 36.10890856 | -82.43709629 | 2020-12-27 05:22:55 | Unicoi, Tennessee, US |
3692471 | 3692471 | 2020-12-24 | US | Illinois | Jo Daviess | 17085 | 1360 | 21 | 0 | 1339 | 42.36542373 | -90.21094405 | 2020-12-25 05:22:48 | Jo Daviess, Illinois, US |
3692223 | 3692223 | 2020-12-24 | US | Georgia | Ben Hill | 13017 | 1381 | 42 | 0 | 1339 | 31.76095874 | -83.22145359 | 2020-12-25 05:22:48 | Ben Hill, Georgia, US |
2409915 | 2409915 | 2020-12-23 | US | Texas | Gillespie | 48171 | 1457 | 16 | 0 | 1339 | 30.31824095 | -98.94676915 | 2020-12-24 05:23:04 | Gillespie, Texas, US |
2407291 | 2407291 | 2020-12-23 | US | Arkansas | Chicot | 5017 | 1368 | 29 | 0 | 1339 | 33.26458973 | -91.29539209 | 2020-12-24 05:23:04 | Chicot, Arkansas, US |
2406841 | 2406841 | 2020-12-23 | Japan | Hiroshima | 2578 | 19 | 1220 | 1339 | 34.605309000000005 | 132.788719 | 2020-12-24 05:23:04 | Hiroshima, Japan | ||
2123166 | 2123166 | 2020-12-20 | US | Washington | Unassigned | 90053 | 1342 | 3 | 0 | 1339 | 48.82227976 | 0.0 | 2020-12-21 05:27:58 | Unassigned, Washington, US |
2121092 | 2121092 | 2020-12-20 | US | Kentucky | Clay | 21051 | 1347 | 8 | 0 | 1339 | 37.16451126 | -83.712575 | 2020-12-21 05:27:58 | Clay, Kentucky, US |
2119952 | 2119952 | 2020-12-20 | Russia | Ryazan Oblast | 16634 | 126 | 15169 | 1339 | 54.42267320000001 | 40.57052460000001 | 2020-12-21 05:27:58 | Ryazan Oblast, Russia | ||
2934673 | 2934673 | 2020-12-19 | US | Washington | Unassigned | 90053 | 1342 | 3 | 0 | 1339 | 48.82227976 | 0.0 | 2020-12-20 05:27:32 | Unassigned, Washington, US |
1901510 | 1901510 | 2020-12-18 | US | Alabama | Butler | 1013 | 1384 | 45 | 0 | 1339 | 31.75300095 | -86.68057478 | 2020-12-19 05:27:52 | Butler, Alabama, US |
2131474 | 2131474 | 2020-12-17 | US | West Virginia | Marion | 54049 | 1347 | 8 | 0 | 1339 | 39.50984542 | -80.24244659 | 2020-12-18 05:28:18 | Marion, West Virginia, US |
2129622 | 2129622 | 2020-12-17 | US | Michigan | Huron | 26063 | 1373 | 34 | 0 | 1339 | 43.83353985 | -83.04078453 | 2020-12-18 05:28:18 | Huron, Michigan, US |
1035006 | 1035006 | 2020-12-15 | US | Colorado | Otero | 8089 | 1531 | 49 | 0 | 1339 | 37.9014485 | -103.7173385 | 2020-12-16 05:28:04 | Otero, Colorado, US |
1753477 | 1753477 | 2020-12-14 | US | New York | Allegany | 36003 | 1403 | 64 | 0 | 1339 | 42.25748406 | -78.02750466 | 2020-12-15 05:26:38 | Allegany, New York, US |
3848989 | 3848989 | 2020-12-13 | US | Iowa | Kossuth | 19109 | 1361 | 22 | 0 | 1339 | 43.20405458 | -94.20691791 | 2020-12-14 05:26:27 | Kossuth, Iowa, US |
861429 | 861429 | 2020-12-11 | US | Georgia | Burke | 13033 | 1355 | 16 | 0 | 1339 | 33.05917989 | -81.99928721 | 2020-12-12 05:26:19 | Burke, Georgia, US |
2975595 | 2975595 | 2020-12-09 | US | Alabama | Geneva | 1061 | 1351 | 12 | 0 | 1339 | 31.09389027 | -85.83572839 | 2020-12-10 05:26:19 | Geneva, Alabama, US |
1008609 | 1008609 | 2020-12-06 | US | North Carolina | Haywood | 37087 | 1382 | 43 | 0 | 1339 | 35.55269063 | -82.98196486 | 2020-12-07 05:26:14 | Haywood, North Carolina, US |
739292 | 739292 | 2020-12-02 | US | Illinois | Jersey | 17083 | 1361 | 22 | 0 | 1339 | 39.08869046 | -90.35393073 | 2020-12-03 05:28:22 | Jersey, Illinois, US |
3568378 | 3568378 | 2020-11-29 | US | Mississippi | Leake | 28079 | 1383 | 44 | 0 | 1339 | 32.7536828 | -89.52402044 | 2020-11-30 05:26:13 | Leake, Mississippi, US |
2938079 | 2938079 | 2020-11-28 | US | South Dakota | Clay | 46027 | 1349 | 10 | 0 | 1339 | 42.91296147 | -96.97656917 | 2020-11-29 05:25:55 | Clay, South Dakota, US |
1975516 | 1975516 | 2020-11-25 | US | Tennessee | Giles | 47055 | 1398 | 46 | 0 | 1339 | 35.20222469 | -87.03992678 | 2020-11-26 05:27:44 | Giles, Tennessee, US |
1353567 | 1353567 | 2020-11-24 | US | Texas | Wood | 48499 | 566 | 48 | 0 | 1339 | 32.78722382 | -95.38236368 | 2020-11-25 05:27:20 | Wood, Texas, US |
681849 | 681849 | 2020-11-23 | US | Wisconsin | Green Lake | 55047 | 1344 | 5 | 0 | 1339 | 43.80025981 | -89.04679553 | 2020-11-24 05:27:31 | Green Lake, Wisconsin, US |
3192165 | 3192165 | 2020-11-22 | US | New Mexico | Cibola | 35006 | 1375 | 36 | 0 | 1339 | 34.91131525 | -107.998876 | 2020-11-23 05:25:26 | Cibola, New Mexico, US |
2703245 | 2703245 | 2020-11-20 | US | Minnesota | Nicollet | 27103 | 1361 | 22 | 0 | 1339 | 44.35291112 | -94.24710352 | 2020-11-21 05:25:51 | Nicollet, Minnesota, US |
2702181 | 2702181 | 2020-11-20 | US | Florida | Bradford | 12007 | 1355 | 16 | 0 | 1339 | 29.95079741 | -82.16611613 | 2020-11-21 05:25:51 | Bradford, Florida, US |
822500 | 822500 | 2020-11-19 | US | Idaho | Jefferson | 16051 | 1349 | 10 | 0 | 1339 | 43.82078483 | -112.3131749 | 2020-11-20 05:26:28 | Jefferson, Idaho, US |
124954 | 124954 | 2020-11-18 | US | New York | Rensselaer | 36083 | 1389 | 50 | 0 | 1339 | 42.71348136 | -73.51089874 | 2020-11-19 05:25:23 | Rensselaer, New York, 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]);