johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
151 rows where active = 1484 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3218501 | 3218501 | 2021-07-26 | Russia | Kabardino-Balkarian Republic | 26567 | 578 | 24505 | 1484 | 43.4806048 | 43.5978976 | 2021-07-27 04:21:18 | Kabardino-Balkarian Republic, Russia | ||
579091 | 579091 | 2021-07-13 | Russia | Ulyanovsk Oblast | 61091 | 1799 | 57808 | 1484 | 54.1463177 | 47.2324921 | 2021-07-14 04:21:35 | Ulyanovsk Oblast, Russia | ||
829742 | 829742 | 2021-07-09 | Pakistan | Islamabad | 83513 | 782 | 81247 | 1484 | 33.665087 | 73.121219 | 2021-07-10 04:21:25 | Islamabad, Pakistan | ||
2884258 | 2884258 | 2021-06-20 | Fiji | 1964 | 7 | 473 | 1484 | -17.7134 | 178.065 | 2021-06-21 04:21:41 | Fiji | |||
2911363 | 2911363 | 2021-06-17 | Russia | Belgorod Oblast | 39834 | 724 | 37626 | 1484 | 50.7080119 | 37.5837615 | 2021-06-18 04:22:16 | Belgorod Oblast, Russia | ||
1708071 | 1708071 | 2021-06-02 | Cabo Verde | 30694 | 266 | 28944 | 1484 | 16.5388 | -23.0418 | 2021-06-03 04:23:32 | Cabo Verde | |||
1873214 | 1873214 | 2021-05-15 | Russia | Volgograd Oblast | 58329 | 1201 | 55644 | 1484 | 49.6048339 | 44.29035820000001 | 2021-05-16 04:20:49 | Volgograd Oblast, Russia | ||
645955 | 645955 | 2021-05-05 | Japan | Chiba | 33862 | 627 | 31751 | 1484 | 35.510141 | 140.198917 | 2021-05-06 04:20:38 | Chiba, Japan | ||
2410694 | 2410694 | 2021-04-19 | Colombia | La Guajira | 23932 | 793 | 21655 | 1484 | 11.3548 | -72.5205 | 2021-04-20 04:20:41 | La Guajira, Colombia | ||
2575298 | 2575298 | 2021-04-13 | Ukraine | Crimea Republic* | 38775 | 1135 | 36156 | 1484 | 45.2835 | 34.2008 | 2021-04-14 04:20:41 | Crimea Republic*, Ukraine | ||
241101 | 241101 | 2021-04-02 | Colombia | Cundinamarca | 111526 | 3079 | 106963 | 1484 | 5.026 | -74.03 | 2021-04-03 04:20:44 | Cundinamarca, Colombia | ||
1580184 | 1580184 | 2021-03-13 | Japan | Osaka | 48213 | 1154 | 45575 | 1484 | 34.620965000000005 | 135.507481 | 2021-03-14 05:25:37 | Osaka, Japan | ||
3668141 | 3668141 | 2021-03-06 | US | Arkansas | Sharp | 5135 | 1529 | 45 | 0 | 1484 | 36.16258158 | -91.47819342 | 2021-03-07 05:21:54 | Sharp, Arkansas, US |
1616762 | 1616762 | 2021-03-05 | US | Arkansas | Sharp | 5135 | 1529 | 45 | 0 | 1484 | 36.16258158 | -91.47819342 | 2021-03-06 04:23:41 | Sharp, Arkansas, US |
1616473 | 1616473 | 2021-03-05 | Russia | Novosibirsk Oblast | 36288 | 1475 | 33329 | 1484 | 54.9720169 | 79.48139240000002 | 2021-03-06 04:23:41 | Novosibirsk Oblast, Russia | ||
2370951 | 2370951 | 2021-02-28 | US | Washington | Unassigned | 90053 | 1488 | 4 | 0 | 1484 | 48.82227976 | 0.0 | 2021-03-01 05:23:01 | Unassigned, Washington, US |
2368246 | 2368246 | 2021-02-28 | US | Georgia | Brantley | 13025 | 1513 | 29 | 0 | 1484 | 31.19576557 | -81.97743999 | 2021-03-01 05:23:01 | Brantley, Georgia, US |
3069453 | 3069453 | 2021-02-27 | US | Washington | Unassigned | 90053 | 1488 | 4 | 0 | 1484 | 48.82227976 | 0.0 | 2021-02-28 05:22:20 | Unassigned, Washington, US |
2185045 | 2185045 | 2021-02-26 | US | Kentucky | Spencer | 21215 | 1497 | 13 | 0 | 1484 | 38.03223971 | -85.32749335 | 2021-02-27 05:22:28 | Spencer, Kentucky, US |
283656 | 283656 | 2021-02-24 | US | West Virginia | Hampshire | 54027 | 1511 | 27 | 0 | 1484 | 39.32103553 | -78.60826476 | 2021-02-25 05:24:57 | Hampshire, West Virginia, US |
282021 | 282021 | 2021-02-24 | US | Mississippi | Smith | 28129 | 1515 | 31 | 0 | 1484 | 32.01744532 | -89.50644846 | 2021-02-25 05:24:57 | Smith, Mississippi, US |
1937806 | 1937806 | 2021-02-23 | US | Kentucky | Adair | 21001 | 1533 | 49 | 0 | 1484 | 37.10459774 | -85.28129668 | 2021-02-24 05:29:16 | Adair, Kentucky, US |
533751 | 533751 | 2021-02-22 | US | Texas | Colorado | 48089 | 1535 | 24 | 0 | 1484 | 29.622098 | -96.5273805 | 2021-02-23 05:23:41 | Colorado, Texas, US |
185085 | 185085 | 2021-02-21 | US | Texas | Colorado | 48089 | 1535 | 24 | 0 | 1484 | 29.622098 | -96.5273805 | 2021-02-22 05:24:21 | Colorado, Texas, US |
3603057 | 3603057 | 2021-02-17 | US | Montana | Roosevelt | 30085 | 1536 | 52 | 0 | 1484 | 48.29607488 | -105.0079268 | 2021-02-18 05:22:58 | Roosevelt, Montana, US |
3053157 | 3053157 | 2021-02-16 | US | Tennessee | Sequatchie | 47153 | 1500 | 26 | 0 | 1484 | 35.36979721 | -85.41022136 | 2021-02-17 05:23:10 | Sequatchie, Tennessee, US |
3053006 | 3053006 | 2021-02-16 | US | South Carolina | Saluda | 45081 | 1526 | 42 | 0 | 1484 | 34.00795823 | -81.72713237 | 2021-02-17 05:23:10 | Saluda, South Carolina, US |
1339946 | 1339946 | 2021-02-15 | US | Michigan | Out of MI | 80026 | 1495 | 11 | 0 | 1484 | 47.63197653 | 0.0 | 2021-02-16 05:24:38 | Out of MI, Michigan, US |
2285131 | 2285131 | 2021-02-14 | US | Minnesota | Dodge | 27039 | 1488 | 4 | 0 | 1484 | 44.02238415 | -92.86244324 | 2021-02-15 05:24:49 | Dodge, Minnesota, US |
2637559 | 2637559 | 2021-02-11 | Colombia | Boyaca | 44231 | 990 | 41757 | 1484 | 5.4545 | -73.362 | 2021-02-12 05:23:29 | Boyaca, Colombia | ||
1529379 | 1529379 | 2021-02-09 | US | Louisiana | Bienville | 22013 | 1552 | 68 | 0 | 1484 | 32.34569994 | -93.05398492 | 2021-02-10 05:22:41 | Bienville, Louisiana, US |
1589149 | 1589149 | 2021-02-05 | US | Illinois | Edgar | 17045 | 1518 | 34 | 0 | 1484 | 39.6809186 | -87.74759563 | 2021-02-06 05:23:55 | Edgar, Illinois, US |
341233 | 341233 | 2021-02-03 | US | Illinois | Carroll | 17015 | 1516 | 32 | 0 | 1484 | 42.06823429 | -89.93395545 | 2021-02-04 05:22:26 | Carroll, Illinois, US |
1687621 | 1687621 | 2021-02-02 | US | Texas | Jackson | 48239 | 1551 | 26 | 0 | 1484 | 28.95472367 | -96.57749563 | 2021-02-03 05:22:52 | Jackson, Texas, US |
1679395 | 1679395 | 2021-02-01 | US | Tennessee | Decatur | 47039 | 1514 | 29 | 0 | 1484 | 35.60048904 | -88.11043779 | 2021-02-02 05:22:49 | Decatur, Tennessee, US |
1460450 | 1460450 | 2021-01-31 | US | Florida | Hamilton | 12047 | 1501 | 17 | 0 | 1484 | 30.49673973 | -82.94998918 | 2021-02-01 05:22:53 | Hamilton, Florida, US |
2215024 | 2215024 | 2021-01-30 | US | Virginia | Louisa | 51109 | 1496 | 12 | 0 | 1484 | 37.97850256 | -77.96274807 | 2021-01-31 05:22:42 | Louisa, Virginia, US |
2483261 | 2483261 | 2021-01-28 | US | Kansas | Jefferson | 20087 | 1510 | 26 | 0 | 1484 | 39.2347941 | -95.38289232 | 2021-01-29 05:22:23 | Jefferson, Kansas, US |
2483048 | 2483048 | 2021-01-28 | US | Indiana | Franklin | 18047 | 1518 | 34 | 0 | 1484 | 39.4142482 | -85.06062647 | 2021-01-29 05:22:23 | Franklin, Indiana, US |
2481981 | 2481981 | 2021-01-28 | Japan | Hokkaido | 17124 | 588 | 15052 | 1484 | 43.385711 | 142.552318 | 2021-01-29 05:22:23 | Hokkaido, Japan | ||
3154896 | 3154896 | 2021-01-27 | US | Kansas | Jefferson | 20087 | 1510 | 26 | 0 | 1484 | 39.2347941 | -95.38289232 | 2021-01-28 05:22:24 | Jefferson, Kansas, US |
13387 | 13387 | 2021-01-26 | US | Illinois | Washington | 17189 | 1504 | 20 | 0 | 1484 | 38.35309213 | -89.40982703 | 2021-01-27 05:23:41 | Washington, Illinois, US |
2571212 | 2571212 | 2021-01-25 | US | Wisconsin | Lafayette | 55065 | 1492 | 8 | 0 | 1484 | 42.66005229 | -90.1317729 | 2021-01-26 05:22:02 | Lafayette, Wisconsin, US |
1762325 | 1762325 | 2021-01-24 | US | Texas | Calhoun | 48057 | 1564 | 13 | 0 | 1484 | 28.47048236 | -96.61633945 | 2021-01-25 05:22:16 | Calhoun, Texas, US |
1759939 | 1759939 | 2021-01-24 | US | Colorado | Routt | 8107 | 1576 | 19 | 0 | 1484 | 40.48596505 | -106.9905548 | 2021-01-25 05:22:16 | Routt, Colorado, US |
2429932 | 2429932 | 2021-01-23 | US | Texas | Calhoun | 48057 | 1564 | 13 | 0 | 1484 | 28.47048236 | -96.61633945 | 2021-01-24 05:22:35 | Calhoun, Texas, US |
2427388 | 2427388 | 2021-01-23 | US | Arkansas | Izard | 5065 | 1515 | 31 | 0 | 1484 | 36.09604046 | -91.90847954 | 2021-01-24 05:22:35 | Izard, Arkansas, US |
2467964 | 2467964 | 2021-01-22 | US | Iowa | Butler | 19023 | 1508 | 24 | 0 | 1484 | 42.73172833 | -92.79015971 | 2021-01-23 05:22:03 | Butler, Iowa, US |
436472 | 436472 | 2021-01-21 | US | Indiana | Perry | 18123 | 1512 | 28 | 0 | 1484 | 38.07809328 | -86.63741946 | 2021-01-22 05:22:10 | Perry, Indiana, US |
436349 | 436349 | 2021-01-21 | US | Illinois | Jo Daviess | 17085 | 1505 | 21 | 0 | 1484 | 42.36542373 | -90.21094405 | 2021-01-22 05:22:10 | Jo Daviess, Illinois, US |
3504937 | 3504937 | 2021-01-17 | US | Maryland | Talbot | 24041 | 1499 | 15 | 0 | 1484 | 38.76618159 | -76.10882561 | 2021-01-18 05:22:34 | Talbot, Maryland, US |
3880265 | 3880265 | 2021-01-14 | US | Florida | Gulf | 12045 | 1514 | 30 | 0 | 1484 | 29.93543004 | -85.24270990000002 | 2021-01-15 05:22:24 | Gulf, Florida, US |
3311602 | 3311602 | 2021-01-13 | US | Virginia | Southampton | 51175 | 1526 | 42 | 0 | 1484 | 36.72231125 | -77.10642712 | 2021-01-14 05:22:32 | Southampton, Virginia, US |
3900847 | 3900847 | 2021-01-09 | US | Georgia | Washington | 13303 | 1530 | 46 | 0 | 1484 | 32.96711864 | -82.79357039 | 2021-01-10 05:22:12 | Washington, Georgia, US |
157241 | 157241 | 2021-01-08 | US | Utah | San Juan | 49037 | 1519 | 35 | 0 | 1484 | 37.62762978 | -109.80337140000002 | 2021-01-09 05:22:18 | San Juan, Utah, US |
2543960 | 2543960 | 2021-01-07 | US | Oklahoma | Kingfisher | 40073 | 1496 | 12 | 0 | 1484 | 35.94530008 | -97.94193268 | 2021-01-08 05:22:42 | Kingfisher, Oklahoma, US |
2230972 | 2230972 | 2021-01-02 | US | Washington | Unassigned | 90053 | 1489 | 5 | 0 | 1484 | 48.82227976 | 0.0 | 2021-01-03 05:22:52 | Unassigned, Washington, US |
1140336 | 1140336 | 2021-01-01 | US | Washington | Unassigned | 90053 | 1489 | 5 | 0 | 1484 | 48.82227976 | 0.0 | 2021-01-02 05:22:33 | Unassigned, Washington, US |
1137752 | 1137752 | 2021-01-01 | US | Georgia | Tattnall | 13267 | 1520 | 36 | 0 | 1484 | 32.04785085 | -82.05539188 | 2021-01-02 05:22:33 | Tattnall, Georgia, US |
1137223 | 1137223 | 2021-01-01 | US | Alabama | Barbour | 1005 | 1517 | 33 | 0 | 1484 | 31.868263 | -85.3871286 | 2021-01-02 05:22:33 | Barbour, Alabama, US |
1137067 | 1137067 | 2021-01-01 | Russia | Amur Oblast | 16004 | 105 | 14415 | 1484 | 52.8032368 | 128.437295 | 2021-01-02 05:22:33 | Amur Oblast, Russia | ||
3698942 | 3698942 | 2020-12-31 | US | Washington | Unassigned | 90053 | 1489 | 5 | 0 | 1484 | 48.82227976 | 0.0 | 2021-01-01 05:23:07 | Unassigned, Washington, US |
3762712 | 3762712 | 2020-12-28 | US | Indiana | Starke | 18149 | 1529 | 45 | 0 | 1484 | 41.27890281 | -86.64686895 | 2020-12-29 05:22:37 | Starke, Indiana, US |
205161 | 205161 | 2020-12-25 | US | Tennessee | Bledsoe | 47007 | 1555 | 9 | 0 | 1484 | 35.59942968 | -85.20611967 | 2020-12-26 05:22:28 | Bledsoe, Tennessee, US |
3694384 | 3694384 | 2020-12-24 | US | Tennessee | Bledsoe | 47007 | 1533 | 9 | 0 | 1484 | 35.59942968 | -85.20611967 | 2020-12-25 05:22:48 | Bledsoe, Tennessee, US |
2409242 | 2409242 | 2020-12-23 | US | North Dakota | Richland | 38077 | 1507 | 15 | 0 | 1484 | 46.26440649 | -96.94852979 | 2020-12-24 05:23:04 | Richland, North Dakota, US |
2407584 | 2407584 | 2020-12-23 | US | Georgia | Butts | 13035 | 1531 | 47 | 0 | 1484 | 33.283094500000004 | -83.95435040000002 | 2020-12-24 05:23:04 | Butts, Georgia, US |
3770613 | 3770613 | 2020-12-22 | US | Georgia | Appling | 13001 | 1527 | 43 | 0 | 1484 | 31.74847232 | -82.28909114 | 2020-12-23 05:22:03 | Appling, Georgia, US |
930611 | 930611 | 2020-12-21 | US | Tennessee | Crockett | 47033 | 1520 | 29 | 0 | 1484 | 35.81830662 | -89.14916269 | 2020-12-22 05:22:33 | Crockett, Tennessee, US |
2120931 | 2120931 | 2020-12-20 | US | Iowa | O'Brien | 19141 | 1532 | 48 | 0 | 1484 | 43.08310673 | -95.62474482 | 2020-12-21 05:27:58 | O'Brien, Iowa, US |
2120844 | 2120844 | 2020-12-20 | US | Indiana | Sullivan | 18153 | 1508 | 24 | 0 | 1484 | 39.08952258 | -87.41414469 | 2020-12-21 05:27:58 | Sullivan, Indiana, US |
2120579 | 2120579 | 2020-12-20 | US | Georgia | Sumter | 13261 | 1557 | 73 | 0 | 1484 | 32.03650571 | -84.19821492 | 2020-12-21 05:27:58 | Sumter, Georgia, US |
2131445 | 2131445 | 2020-12-17 | US | Washington | Unassigned | 90053 | 1487 | 3 | 0 | 1484 | 48.82227976 | 0.0 | 2020-12-18 05:28:18 | Unassigned, Washington, US |
2129505 | 2129505 | 2020-12-17 | US | Louisiana | Plaquemines | 22075 | 1504 | 20 | 0 | 1484 | 29.42245447 | -89.60322085 | 2020-12-18 05:28:18 | Plaquemines, Louisiana, US |
1035285 | 1035285 | 2020-12-15 | US | Idaho | Blaine | 16013 | 1494 | 10 | 0 | 1484 | 43.4085812 | -113.9752658 | 2020-12-16 05:28:04 | Blaine, Idaho, US |
847086 | 847086 | 2020-12-12 | US | Louisiana | Richland | 22083 | 1517 | 33 | 0 | 1484 | 32.41391005 | -91.76634876 | 2020-12-13 05:27:20 | Richland, Louisiana, US |
864118 | 864118 | 2020-12-11 | US | Washington | Okanogan | 53047 | 1509 | 25 | 0 | 1484 | 48.54855019 | -119.7387224 | 2020-12-12 05:26:19 | Okanogan, Washington, US |
863524 | 863524 | 2020-12-11 | US | South Dakota | Clay | 46027 | 1495 | 11 | 0 | 1484 | 42.91296147 | -96.97656917 | 2020-12-12 05:26:19 | Clay, South Dakota, US |
862193 | 862193 | 2020-12-11 | US | Louisiana | Richland | 22083 | 1517 | 33 | 0 | 1484 | 32.41391005 | -91.76634876 | 2020-12-12 05:26:19 | Richland, Louisiana, US |
1601337 | 1601337 | 2020-12-10 | US | Indiana | Posey | 18129 | 1507 | 23 | 0 | 1484 | 38.02097333 | -87.86480429 | 2020-12-11 05:26:59 | Posey, Indiana, US |
1634726 | 1634726 | 2020-12-05 | US | North Dakota | Walsh | 38099 | 1487 | 16 | 0 | 1484 | 48.36876964 | -97.72574783 | 2020-12-06 05:26:18 | Walsh, North Dakota, US |
3862073 | 3862073 | 2020-12-04 | US | New York | Ontario | 36069 | 1521 | 37 | 0 | 1484 | 42.85145728 | -77.30874425 | 2020-12-05 05:27:36 | Ontario, New York, US |
2540324 | 2540324 | 2020-12-01 | US | Tennessee | Giles | 47055 | 1556 | 49 | 0 | 1484 | 35.20222469 | -87.03992678 | 2020-12-02 05:27:41 | Giles, Tennessee, US |
2539180 | 2539180 | 2020-12-01 | US | Mississippi | Coahoma | 28027 | 1527 | 43 | 0 | 1484 | 34.22772299 | -90.60415045 | 2020-12-02 05:27:41 | Coahoma, Mississippi, US |
3567430 | 3567430 | 2020-11-29 | US | Georgia | Stephens | 13257 | 1531 | 47 | 0 | 1484 | 34.55151201 | -83.29405315 | 2020-11-30 05:26:13 | Stephens, Georgia, US |
3567214 | 3567214 | 2020-11-29 | US | Colorado | Summit | 8117 | 1631 | 5 | 0 | 1484 | 39.63803232 | -106.1150762 | 2020-11-30 05:26:13 | Summit, Colorado, US |
392970 | 392970 | 2020-11-27 | US | Florida | Washington | 12133 | 1508 | 24 | 0 | 1484 | 30.61359259 | -85.66002461 | 2020-11-28 05:25:50 | Washington, Florida, US |
1974521 | 1974521 | 2020-11-25 | US | Missouri | Perry | 29157 | 1496 | 12 | 0 | 1484 | 37.70660776 | -89.82741088 | 2020-11-26 05:27:44 | Perry, Missouri, US |
1350457 | 1350457 | 2020-11-24 | Pakistan | Azad Jammu and Kashmir | 6316 | 151 | 4681 | 1484 | 34.027401 | 73.947253 | 2020-11-25 05:27:20 | Azad Jammu and Kashmir, Pakistan | ||
681595 | 681595 | 2020-11-23 | US | Virgin Islands | 78 | 1507 | 23 | 0 | 1484 | 18.3358 | -64.8963 | 2020-11-24 05:27:31 | Virgin Islands, US | |
680259 | 680259 | 2020-11-23 | US | Missouri | Saline | 29195 | 1496 | 12 | 0 | 1484 | 39.13734288 | -93.20259964 | 2020-11-24 05:27:31 | Saline, Missouri, US |
824628 | 824628 | 2020-11-19 | US | Texas | Deaf Smith | 48117 | 1667 | 36 | 0 | 1484 | 34.96522957 | -102.6054267 | 2020-11-20 05:26:28 | Deaf Smith, Texas, US |
125344 | 125344 | 2020-11-18 | US | Pennsylvania | Bradford | 42015 | 1513 | 29 | 0 | 1484 | 41.78869215 | -76.51570822 | 2020-11-19 05:25:23 | Bradford, Pennsylvania, US |
124622 | 124622 | 2020-11-18 | US | Missouri | Marion | 29127 | 1499 | 15 | 0 | 1484 | 39.80601912 | -91.62203062 | 2020-11-19 05:25:23 | Marion, Missouri, US |
3173165 | 3173165 | 2020-11-16 | US | Wisconsin | Door | 55029 | 1494 | 10 | 0 | 1484 | 44.95856458 | -87.30002707 | 2020-11-17 05:25:54 | Door, Wisconsin, US |
867048 | 867048 | 2020-11-12 | US | North Carolina | Beaufort | 37013 | 1531 | 47 | 0 | 1484 | 35.48531943 | -76.84325809 | 2020-11-13 05:25:30 | Beaufort, North Carolina, US |
274150 | 274150 | 2020-11-10 | US | Montana | Lewis and Clark | 30049 | 1491 | 7 | 0 | 1484 | 47.12610041 | -112.394698 | 2020-11-11 05:25:30 | Lewis and Clark, Montana, US |
272093 | 272093 | 2020-11-10 | India | Arunachal Pradesh | 15581 | 46 | 14051 | 1484 | 27.768456 | 96.384277 | 2020-11-11 05:25:30 | Arunachal Pradesh, India | ||
1991731 | 1991731 | 2020-11-09 | US | Texas | Harrison | 48203 | 1298 | 39 | 0 | 1484 | 32.54935988 | -94.36934071 | 2020-11-10 05:40:07 | Harrison, Texas, US |
1991558 | 1991558 | 2020-11-09 | US | Tennessee | Franklin | 47051 | 1510 | 27 | 0 | 1484 | 35.15634626 | -86.09201039 | 2020-11-10 05:40:07 | Franklin, Tennessee, 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]);