johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
161 rows where active = 1354 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3385232 | 3385232 | 2021-07-29 | Colombia | Cesar | 86316 | 2392 | 82570 | 1354 | 9.3373 | -73.6536 | 2021-07-30 04:21:34 | Cesar, Colombia | ||
3137754 | 3137754 | 2021-07-23 | Russia | Kabardino-Balkarian Republic | 26318 | 568 | 24396 | 1354 | 43.4806048 | 43.5978976 | 2021-07-24 00:21:36 | Kabardino-Balkarian Republic, Russia | ||
2339730 | 2339730 | 2021-06-15 | Timor-Leste | 8412 | 19 | 7039 | 1354 | -8.874217 | 125.727539 | 2021-06-16 04:22:32 | Timor-Leste | |||
2315255 | 2315255 | 2021-06-04 | India | Ladakh | 19076 | 194 | 17528 | 1354 | 34.1526 | 77.5771 | 2021-06-05 04:23:03 | Ladakh, India | ||
380046 | 380046 | 2021-04-30 | Colombia | Narino | 53761 | 1764 | 50643 | 1354 | 1.2892 | -77.3579 | 2021-05-01 04:20:47 | Narino, Colombia | ||
2571460 | 2571460 | 2021-04-13 | Chile | Antofagasta | 45767 | 909 | 43504 | 1354 | -23.6509 | -70.3975 | 2021-04-14 04:20:41 | Antofagasta, Chile | ||
638182 | 638182 | 2021-03-31 | Russia | Volgograd Oblast | 53623 | 955 | 51314 | 1354 | 49.6048339 | 44.29035820000001 | 2021-04-01 04:27:05 | Volgograd Oblast, Russia | ||
1980874 | 1980874 | 2021-03-25 | Russia | Volgograd Oblast | 52920 | 924 | 50642 | 1354 | 49.6048339 | 44.29035820000001 | 2021-03-26 05:26:55 | Volgograd Oblast, Russia | ||
3369174 | 3369174 | 2021-03-21 | Colombia | Cordoba | 40892 | 1936 | 37602 | 1354 | 8.0493 | -75.574 | 2021-03-22 05:25:43 | Cordoba, Colombia | ||
3668603 | 3668603 | 2021-03-06 | US | Illinois | Greene | 17061 | 1386 | 32 | 0 | 1354 | 39.35907414 | -90.388865 | 2021-03-07 05:21:54 | Greene, Illinois, US |
2209396 | 2209396 | 2021-03-04 | US | Minnesota | Pennington | 27113 | 1370 | 16 | 0 | 1354 | 48.06642577 | -96.0370814 | 2021-03-05 05:26:29 | Pennington, Minnesota, US |
1092736 | 1092736 | 2021-03-03 | US | Pennsylvania | Forest | 42053 | 1375 | 21 | 0 | 1354 | 41.51095103 | -79.23229292 | 2021-03-04 05:24:24 | Forest, Pennsylvania, US |
3256808 | 3256808 | 2021-03-02 | US | Pennsylvania | Forest | 42053 | 1375 | 21 | 0 | 1354 | 41.51095103 | -79.23229292 | 2021-03-03 05:23:28 | Forest, Pennsylvania, US |
1001100 | 1001100 | 2021-03-01 | US | Pennsylvania | Forest | 42053 | 1375 | 21 | 0 | 1354 | 41.51095103 | -79.23229292 | 2021-03-02 05:23:30 | Forest, Pennsylvania, US |
1000406 | 1000406 | 2021-03-01 | US | Missouri | Vernon | 29217 | 1391 | 37 | 0 | 1354 | 37.8457799 | -94.34127305 | 2021-03-02 05:23:30 | Vernon, Missouri, US |
2370158 | 2370158 | 2021-02-28 | US | Pennsylvania | Forest | 42053 | 1375 | 21 | 0 | 1354 | 41.51095103 | -79.23229292 | 2021-03-01 05:23:01 | Forest, Pennsylvania, US |
2369464 | 2369464 | 2021-02-28 | US | Missouri | Vernon | 29217 | 1391 | 37 | 0 | 1354 | 37.8457799 | -94.34127305 | 2021-03-01 05:23:01 | Vernon, Missouri, US |
3068660 | 3068660 | 2021-02-27 | US | Pennsylvania | Forest | 42053 | 1375 | 21 | 0 | 1354 | 41.51095103 | -79.23229292 | 2021-02-28 05:22:20 | Forest, Pennsylvania, US |
1937646 | 1937646 | 2021-02-23 | US | Iowa | Iowa | 19095 | 1377 | 23 | 0 | 1354 | 41.68630265 | -92.0643373 | 2021-02-24 05:29:16 | Iowa, Iowa, US |
533470 | 533470 | 2021-02-22 | US | Puerto Rico | Rio Grande | 72119 | 1354 | 0 | 0 | 1354 | 18.346329 | -65.813742 | 2021-02-23 05:23:41 | Rio Grande, Puerto Rico, US |
184804 | 184804 | 2021-02-21 | US | Puerto Rico | Rio Grande | 72119 | 1354 | 0 | 0 | 1354 | 18.346329 | -65.813742 | 2021-02-22 05:24:21 | Rio Grande, Puerto Rico, US |
183748 | 183748 | 2021-02-21 | US | Minnesota | Fillmore | 27045 | 1362 | 8 | 0 | 1354 | 43.67394126 | -92.08980382 | 2021-02-22 05:24:21 | Fillmore, Minnesota, US |
1153472 | 1153472 | 2021-02-18 | US | Alabama | Clay | 1027 | 1407 | 53 | 0 | 1354 | 33.26984193 | -85.85836077 | 2021-02-19 05:24:16 | Clay, Alabama, US |
3050534 | 3050534 | 2021-02-16 | US | Alabama | Crenshaw | 1041 | 1405 | 51 | 0 | 1354 | 31.72941803 | -86.31593104 | 2021-02-17 05:23:10 | Crenshaw, Alabama, US |
1527885 | 1527885 | 2021-02-09 | Italy | Molise | 8972 | 295 | 7323 | 1354 | 41.55774754 | 14.65916051 | 2021-02-10 05:22:41 | Molise, Italy | ||
616805 | 616805 | 2021-02-08 | US | Texas | Hutchinson | 48233 | 2447 | 64 | 0 | 1354 | 35.84006574 | -101.3546643 | 2021-02-09 05:23:30 | Hutchinson, Texas, US |
613486 | 613486 | 2021-02-08 | Chile | Valparaiso | 44982 | 1453 | 42175 | 1354 | -33.0472 | -71.6127 | 2021-02-09 05:23:30 | Valparaiso, Chile | ||
1675574 | 1675574 | 2021-02-07 | US | Texas | Hutchinson | 48233 | 2447 | 64 | 0 | 1354 | 35.84006574 | -101.3546643 | 2021-02-08 05:22:39 | Hutchinson, Texas, US |
1672953 | 1672953 | 2021-02-07 | US | Arkansas | Madison | 5087 | 1373 | 19 | 0 | 1354 | 36.01038185 | -93.72524943 | 2021-02-08 05:22:39 | Madison, Arkansas, US |
975414 | 975414 | 2021-02-06 | US | Arkansas | Madison | 5087 | 1373 | 19 | 0 | 1354 | 36.01038185 | -93.72524943 | 2021-02-07 05:23:00 | Madison, Arkansas, US |
793337 | 793337 | 2021-02-04 | US | Tennessee | Lewis | 47101 | 1411 | 23 | 0 | 1354 | 35.52853208 | -87.49022694 | 2021-02-05 05:22:38 | Lewis, Tennessee, US |
2214712 | 2214712 | 2021-01-30 | US | Texas | Colorado | 48089 | 1402 | 21 | 0 | 1354 | 29.622098 | -96.5273805 | 2021-01-31 05:22:42 | Colorado, Texas, US |
2483720 | 2483720 | 2021-01-28 | US | Minnesota | Renville | 27129 | 1394 | 40 | 0 | 1354 | 44.72836381 | -94.94553734 | 2021-01-29 05:22:23 | Renville, Minnesota, US |
3154812 | 3154812 | 2021-01-27 | US | Iowa | Lyon | 19119 | 1387 | 33 | 0 | 1354 | 43.38107862 | -96.20926845 | 2021-01-28 05:22:24 | Lyon, Iowa, US |
3153395 | 3153395 | 2021-01-27 | Chile | Los Rios | 13892 | 143 | 12395 | 1354 | -40.231 | -72.3311 | 2021-01-28 05:22:24 | Los Rios, Chile | ||
2569289 | 2569289 | 2021-01-25 | US | Michigan | Gladwin | 26051 | 1395 | 41 | 0 | 1354 | 43.98901072 | -84.38774817 | 2021-01-26 05:22:02 | Gladwin, Michigan, US |
2569019 | 2569019 | 2021-01-25 | US | Kentucky | Adair | 21001 | 1400 | 46 | 0 | 1354 | 37.10459774 | -85.28129668 | 2021-01-26 05:22:02 | Adair, Kentucky, US |
2428903 | 2428903 | 2021-01-23 | US | Montana | Lincoln | 30053 | 1363 | 9 | 0 | 1354 | 48.54265777 | -115.4046155 | 2021-01-24 05:22:35 | Lincoln, Montana, US |
2468923 | 2468923 | 2021-01-22 | US | Nebraska | Unassigned | 90031 | 1357 | 3 | 0 | 1354 | 42.8997274 | 0.0 | 2021-01-23 05:22:03 | Unassigned, Nebraska, US |
438212 | 438212 | 2021-01-21 | US | South Dakota | Dewey | 46041 | 1372 | 18 | 0 | 1354 | 45.15639647 | -100.8709139 | 2021-01-22 05:22:10 | Dewey, South Dakota, US |
910905 | 910905 | 2021-01-19 | US | Puerto Rico | Dorado | 72051 | 1354 | 0 | 0 | 1354 | 18.436115 | -66.278669 | 2021-01-20 05:21:54 | Dorado, Puerto Rico, US |
909490 | 909490 | 2021-01-19 | US | Kansas | Nemaha | 20131 | 1404 | 50 | 0 | 1354 | 39.78345387 | -96.01392079 | 2021-01-20 05:21:54 | Nemaha, Kansas, US |
909197 | 909197 | 2021-01-19 | US | Illinois | Moultrie | 17139 | 1374 | 20 | 0 | 1354 | 39.64187451 | -88.62099969 | 2021-01-20 05:21:54 | Moultrie, Illinois, US |
908923 | 908923 | 2021-01-19 | US | Georgia | Berrien | 13019 | 1389 | 35 | 0 | 1354 | 31.27590016 | -83.22529920000002 | 2021-01-20 05:21:54 | Berrien, Georgia, US |
238553 | 238553 | 2021-01-18 | US | Kansas | Nemaha | 20131 | 1404 | 50 | 0 | 1354 | 39.78345387 | -96.01392079 | 2021-01-19 05:22:15 | Nemaha, Kansas, US |
237093 | 237093 | 2021-01-18 | Colombia | Meta | 38046 | 823 | 35869 | 1354 | 3.272 | -73.0877 | 2021-01-19 05:22:15 | Meta, Colombia | ||
3506911 | 3506911 | 2021-01-17 | US | Wisconsin | Marquette | 55077 | 1379 | 25 | 0 | 1354 | 43.81911946 | -89.40073763 | 2021-01-18 05:22:34 | Marquette, Wisconsin, US |
3504778 | 3504778 | 2021-01-17 | US | Kentucky | Letcher | 21133 | 1358 | 4 | 0 | 1354 | 37.12306748 | -82.85346474 | 2021-01-18 05:22:34 | Letcher, Kentucky, US |
3102605 | 3102605 | 2021-01-16 | US | Iowa | Cherokee | 19035 | 1381 | 27 | 0 | 1354 | 42.73538914 | -95.62389402 | 2021-01-17 05:22:17 | Cherokee, Iowa, US |
3882508 | 3882508 | 2021-01-14 | US | Tennessee | Grundy | 47061 | 1427 | 20 | 0 | 1354 | 35.38433717 | -85.72142731 | 2021-01-15 05:22:24 | Grundy, Tennessee, US |
192506 | 192506 | 2021-01-11 | US | Ohio | Carroll | 39019 | 1385 | 31 | 0 | 1354 | 40.5789686 | -81.09178213 | 2021-01-12 05:22:15 | Carroll, Ohio, US |
192083 | 192083 | 2021-01-11 | US | Montana | Roosevelt | 30085 | 1405 | 51 | 0 | 1354 | 48.29607488 | -105.0079268 | 2021-01-12 05:22:15 | Roosevelt, Montana, US |
2626833 | 2626833 | 2021-01-10 | US | Illinois | Clark | 17023 | 1378 | 24 | 0 | 1354 | 39.33425789 | -87.78705622 | 2021-01-11 05:21:50 | Clark, Illinois, US |
2626546 | 2626546 | 2021-01-10 | US | Florida | Calhoun | 12013 | 1383 | 29 | 0 | 1354 | 30.40666734 | -85.19394153 | 2021-01-11 05:21:50 | Calhoun, Florida, US |
3902131 | 3902131 | 2021-01-09 | US | New Jersey | Unassigned | 90034 | 1354 | 0 | 0 | 1354 | 41.13891592 | 0.0 | 2021-01-10 05:22:12 | Unassigned, New Jersey, US |
2542379 | 2542379 | 2021-01-07 | US | Illinois | Edgar | 17045 | 1385 | 31 | 0 | 1354 | 39.6809186 | -87.74759563 | 2021-01-08 05:22:42 | Edgar, Illinois, US |
3035416 | 3035416 | 2021-01-05 | US | Indiana | Owen | 18119 | 1394 | 40 | 0 | 1354 | 39.31145587 | -86.83900724 | 2021-01-06 05:22:16 | Owen, Indiana, US |
3035333 | 3035333 | 2021-01-05 | US | Illinois | Richland | 17159 | 1385 | 31 | 0 | 1354 | 38.71240969 | -88.08475366 | 2021-01-06 05:22:16 | Richland, Illinois, US |
1065394 | 1065394 | 2021-01-04 | US | Wisconsin | Lafayette | 55065 | 1360 | 6 | 0 | 1354 | 42.66005229 | -90.1317729 | 2021-01-05 05:21:49 | Lafayette, Wisconsin, US |
1065264 | 1065264 | 2021-01-04 | US | Virginia | Wythe | 51197 | 1382 | 28 | 0 | 1354 | 36.91582035 | -81.07834059 | 2021-01-05 05:21:49 | Wythe, Virginia, US |
3233997 | 3233997 | 2021-01-03 | US | Wisconsin | Lafayette | 55065 | 1360 | 6 | 0 | 1354 | 42.66005229 | -90.1317729 | 2021-01-04 05:22:02 | Lafayette, Wisconsin, US |
2230334 | 2230334 | 2021-01-02 | US | South Carolina | Jasper | 45053 | 1379 | 25 | 0 | 1354 | 32.43171982 | -81.02487495 | 2021-01-03 05:22:52 | Jasper, South Carolina, US |
2229797 | 2229797 | 2021-01-02 | US | North Carolina | Avery | 37011 | 1369 | 15 | 0 | 1354 | 36.07569796 | -81.92308483 | 2021-01-03 05:22:52 | Avery, North Carolina, US |
2229018 | 2229018 | 2021-01-02 | US | Louisiana | Jackson | 22049 | 1392 | 38 | 0 | 1354 | 32.30251776 | -92.55692092 | 2021-01-03 05:22:52 | Jackson, Louisiana, US |
2228373 | 2228373 | 2021-01-02 | US | Georgia | Putnam | 13237 | 1385 | 31 | 0 | 1354 | 33.32056115 | -83.37552891 | 2021-01-03 05:22:52 | Putnam, Georgia, US |
1138382 | 1138382 | 2021-01-01 | US | Louisiana | Jackson | 22049 | 1392 | 38 | 0 | 1354 | 32.30251776 | -92.55692092 | 2021-01-02 05:22:33 | Jackson, Louisiana, US |
3696988 | 3696988 | 2020-12-31 | US | Louisiana | Jackson | 22049 | 1392 | 38 | 0 | 1354 | 32.30251776 | -92.55692092 | 2021-01-01 05:23:07 | Jackson, Louisiana, US |
3696392 | 3696392 | 2020-12-31 | US | Hawaii | Maui | 15009 | 1371 | 17 | 0 | 1354 | 20.86399628 | -156.56890969999995 | 2021-01-01 05:23:07 | Maui, Hawaii, US |
1010746 | 1010746 | 2020-12-30 | US | Arizona | La Paz | 4012 | 1387 | 33 | 0 | 1354 | 33.72854224 | -113.9810029 | 2020-12-31 05:22:49 | La Paz, Arizona, US |
766853 | 766853 | 2020-12-29 | US | California | Colusa | 6011 | 1357 | 7 | 0 | 1354 | 39.17881957 | -122.2331726 | 2020-12-30 05:22:34 | Colusa, California, US |
203925 | 203925 | 2020-12-25 | US | Michigan | Out of MI | 80026 | 1364 | 10 | 0 | 1354 | 47.63197653 | 0.0 | 2020-12-26 05:22:28 | Out of MI, Michigan, US |
202716 | 202716 | 2020-12-25 | US | Arkansas | Chicot | 5017 | 1383 | 29 | 0 | 1354 | 33.26458973 | -91.29539209 | 2020-12-26 05:22:28 | Chicot, Arkansas, US |
3693148 | 3693148 | 2020-12-24 | US | Michigan | Out of MI | 80026 | 1364 | 10 | 0 | 1354 | 47.63197653 | 0.0 | 2020-12-25 05:22:48 | Out of MI, Michigan, US |
2409744 | 2409744 | 2020-12-23 | US | Tennessee | Chester | 47023 | 1421 | 28 | 0 | 1354 | 35.42527478 | -88.6095842 | 2020-12-24 05:23:04 | Chester, Tennessee, US |
2408500 | 2408500 | 2020-12-23 | US | Michigan | Out of MI | 80026 | 1364 | 10 | 0 | 1354 | 47.63197653 | 0.0 | 2020-12-24 05:23:04 | Out of MI, Michigan, US |
927931 | 927931 | 2020-12-21 | Russia | Ryazan Oblast | 16771 | 126 | 15291 | 1354 | 54.42267320000001 | 40.57052460000001 | 2020-12-22 05:22:33 | Ryazan Oblast, Russia | ||
2120057 | 2120057 | 2020-12-20 | US | Alabama | Butler | 1013 | 1399 | 45 | 0 | 1354 | 31.75300095 | -86.68057478 | 2020-12-21 05:27:58 | Butler, Alabama, US |
1902796 | 1902796 | 2020-12-18 | US | Michigan | Huron | 26063 | 1388 | 34 | 0 | 1354 | 43.83353985 | -83.04078453 | 2020-12-19 05:27:52 | Huron, Michigan, US |
1902355 | 1902355 | 2020-12-18 | US | Iowa | Hardin | 19083 | 1376 | 22 | 0 | 1354 | 42.38353877 | -93.23654611 | 2020-12-19 05:27:52 | Hardin, Iowa, US |
2128537 | 2128537 | 2020-12-17 | US | California | Lake | 6033 | 1374 | 20 | 0 | 1354 | 39.10124298 | -122.7536244 | 2020-12-18 05:28:18 | Lake, California, US |
3851365 | 3851365 | 2020-12-13 | US | Wisconsin | Vernon | 55123 | 1371 | 17 | 0 | 1354 | 43.59422667 | -90.8324691 | 2020-12-14 05:26:27 | Vernon, Wisconsin, US |
863364 | 863364 | 2020-12-11 | US | Pennsylvania | Snyder | 42109 | 1384 | 30 | 0 | 1354 | 40.77129231 | -77.06840691 | 2020-12-12 05:26:19 | Snyder, Pennsylvania, US |
860539 | 860539 | 2020-12-11 | Colombia | Tolima | 33405 | 1009 | 31042 | 1354 | 4.0925 | -75.1545 | 2020-12-12 05:26:19 | Tolima, Colombia | ||
2977171 | 2977171 | 2020-12-09 | US | Missouri | Randolph | 29175 | 1363 | 9 | 0 | 1354 | 39.44007257 | -92.4971374 | 2020-12-10 05:26:19 | Randolph, Missouri, US |
2975828 | 2975828 | 2020-12-09 | US | Colorado | Crowley | 8025 | 1526 | 13 | 0 | 1354 | 38.32608609 | -103.7844965 | 2020-12-10 05:26:19 | Crowley, Colorado, US |
1820201 | 1820201 | 2020-12-08 | US | Kentucky | Knox | 21121 | 1364 | 10 | 0 | 1354 | 36.89225732 | -83.85403396 | 2020-12-09 05:28:01 | Knox, Kentucky, US |
2350563 | 2350563 | 2020-12-07 | US | Texas | Lamb | 48279 | 1656 | 51 | 0 | 1354 | 34.06859623 | -102.3516289 | 2020-12-08 05:27:42 | Lamb, Texas, US |
2348632 | 2348632 | 2020-12-07 | US | Iowa | Mahaska | 19123 | 1383 | 29 | 0 | 1354 | 41.33521503 | -92.64083907 | 2020-12-08 05:27:42 | Mahaska, Iowa, US |
1009433 | 1009433 | 2020-12-06 | US | Texas | Lamb | 48279 | 1639 | 51 | 0 | 1354 | 34.06859623 | -102.3516289 | 2020-12-07 05:26:14 | Lamb, Texas, US |
1007653 | 1007653 | 2020-12-06 | US | Kentucky | Bell | 21013 | 1374 | 20 | 0 | 1354 | 36.73355174 | -83.67766671 | 2020-12-07 05:26:14 | Bell, Kentucky, US |
1635442 | 1635442 | 2020-12-05 | US | Texas | Lamb | 48279 | 1632 | 51 | 0 | 1354 | 34.06859623 | -102.3516289 | 2020-12-06 05:26:18 | Lamb, Texas, US |
74951 | 74951 | 2020-12-03 | Colombia | Tolima | 30528 | 931 | 28243 | 1354 | 4.0925 | -75.1545 | 2020-12-04 05:27:27 | Tolima, Colombia | ||
2538539 | 2538539 | 2020-12-01 | US | Indiana | Wells | 18179 | 1392 | 38 | 0 | 1354 | 40.72934187 | -85.22132966 | 2020-12-02 05:27:41 | Wells, Indiana, US |
2537232 | 2537232 | 2020-12-01 | Colombia | Bolivar | 38692 | 914 | 36424 | 1354 | 8.6704 | -74.03 | 2020-12-02 05:27:41 | Bolivar, Colombia | ||
2936673 | 2936673 | 2020-11-28 | US | Kentucky | Muhlenberg | 21177 | 1373 | 19 | 0 | 1354 | 37.21425819 | -87.14632053 | 2020-11-29 05:25:55 | Muhlenberg, Kentucky, US |
2935686 | 2935686 | 2020-11-28 | US | Arkansas | Baxter | 5005 | 1381 | 27 | 0 | 1354 | 36.28784385 | -92.33782872 | 2020-11-29 05:25:55 | Baxter, Arkansas, US |
395196 | 395196 | 2020-11-27 | US | Tennessee | McNairy | 47109 | 1372 | 33 | 0 | 1354 | 35.17468549 | -88.5647812 | 2020-11-28 05:25:50 | McNairy, Tennessee, US |
1974554 | 1974554 | 2020-11-25 | US | Missouri | Washington | 29221 | 1377 | 23 | 0 | 1354 | 37.96130078 | -90.87948158 | 2020-11-26 05:27:44 | Washington, Missouri, US |
3191528 | 3191528 | 2020-11-22 | US | Maine | Androscoggin | 23001 | 1370 | 16 | 0 | 1354 | 44.1664747 | -70.20380627 | 2020-11-23 05:25:26 | Androscoggin, Maine, US |
3191459 | 3191459 | 2020-11-22 | US | Kentucky | Whitley | 21235 | 1362 | 8 | 0 | 1354 | 36.75700531 | -84.14541217 | 2020-11-23 05:25:26 | Whitley, Kentucky, 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]);