johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
121 rows where active = 1703 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1306365 | 1306365 | 2021-07-27 | Russia | Kemerovo Oblast | 45051 | 957 | 42391 | 1703 | 54.53357809999999 | 87.342861 | 2021-07-28 04:21:39 | Kemerovo Oblast, Russia | ||
483444 | 483444 | 2021-07-19 | Colombia | Norte de Santander | 82429 | 3833 | 76893 | 1703 | 7.9463 | -72.8988 | 2021-07-20 04:21:48 | Norte de Santander, Colombia | ||
778573 | 778573 | 2021-07-08 | Russia | Khakassia Republic | 26247 | 618 | 23926 | 1703 | 53.72258845 | 91.44293627 | 2021-07-09 04:21:21 | Khakassia Republic, Russia | ||
2072169 | 2072169 | 2021-07-02 | Russia | Tatarstan Republic | 22515 | 543 | 20269 | 1703 | 55.7648572 | 52.43104273 | 2021-07-03 04:21:37 | Tatarstan Republic, Russia | ||
562808 | 562808 | 2021-06-22 | Colombia | Casanare | 27136 | 662 | 24771 | 1703 | 5.7589 | -71.5724 | 2021-06-23 04:21:46 | Casanare, Colombia | ||
1564022 | 1564022 | 2021-06-14 | Guyana | 18446 | 430 | 16313 | 1703 | 4.860416000000002 | -58.93018000000001 | 2021-06-15 04:22:22 | Guyana | |||
3954522 | 3954522 | 2021-05-11 | Japan | Okayama | 5257 | 62 | 3492 | 1703 | 34.89246 | 133.826252 | 2021-05-12 04:21:29 | Okayama, Japan | ||
3702064 | 3702064 | 2021-04-27 | India | Ladakh | 13642 | 139 | 11800 | 1703 | 34.1526 | 77.5771 | 2021-04-28 04:20:32 | Ladakh, India | ||
3667586 | 3667586 | 2021-03-06 | India | Rajasthan | 321356 | 2789 | 316864 | 1703 | 26.583423 | 73.847973 | 2021-03-07 05:21:54 | Rajasthan, India | ||
1619770 | 1619770 | 2021-03-05 | US | Wisconsin | Crawford | 55023 | 1720 | 17 | 0 | 1703 | 43.23870316 | -90.93073686 | 2021-03-06 04:23:41 | Crawford, Wisconsin, US |
2211181 | 2211181 | 2021-03-04 | US | Wisconsin | Crawford | 55023 | 1720 | 17 | 0 | 1703 | 43.23870316 | -90.93073686 | 2021-03-05 05:26:29 | Crawford, Wisconsin, US |
1093602 | 1093602 | 2021-03-03 | US | Wisconsin | Crawford | 55023 | 1720 | 17 | 0 | 1703 | 43.23870316 | -90.93073686 | 2021-03-04 05:24:24 | Crawford, Wisconsin, US |
1001693 | 1001693 | 2021-03-01 | US | Texas | Zapata | 48505 | 1967 | 26 | 0 | 1703 | 27.00156391 | -99.16987152 | 2021-03-02 05:23:30 | Zapata, Texas, US |
2370751 | 2370751 | 2021-02-28 | US | Texas | Zapata | 48505 | 1967 | 26 | 0 | 1703 | 27.00156391 | -99.16987152 | 2021-03-01 05:23:01 | Zapata, Texas, US |
3069080 | 3069080 | 2021-02-27 | US | Texas | Freestone | 48161 | 1976 | 43 | 0 | 1703 | 31.70422788 | -96.15072516 | 2021-02-28 05:22:20 | Freestone, Texas, US |
3066204 | 3066204 | 2021-02-27 | Russia | Karachay-Cherkess Republic | 19012 | 62 | 17247 | 1703 | 43.7368326 | 41.7267991 | 2021-02-28 05:22:20 | Karachay-Cherkess Republic, Russia | ||
1859903 | 1859903 | 2021-02-25 | US | Missouri | Henry | 29083 | 1739 | 36 | 0 | 1703 | 38.38482826 | -93.79293734 | 2021-02-26 05:22:40 | Henry, Missouri, US |
1858266 | 1858266 | 2021-02-25 | Russia | Yamalo-Nenets Autonomous Okrug | 36997 | 396 | 34898 | 1703 | 67.1471631 | 74.3415488 | 2021-02-26 05:22:40 | Yamalo-Nenets Autonomous Okrug, Russia | ||
281595 | 281595 | 2021-02-24 | US | Kentucky | Johnson | 21115 | 1721 | 18 | 0 | 1703 | 37.85106355 | -82.8264322 | 2021-02-25 05:24:57 | Johnson, Kentucky, US |
183655 | 183655 | 2021-02-21 | US | Michigan | Chippewa | 26033 | 1729 | 26 | 0 | 1703 | 46.29552653 | -84.54353449 | 2021-02-22 05:24:21 | Chippewa, Michigan, US |
745646 | 745646 | 2021-02-20 | US | Virginia | Fredericksburg | 51630 | 1717 | 14 | 0 | 1703 | 38.2977863 | -77.4922454 | 2021-02-21 05:24:33 | Fredericksburg, Virginia, US |
743929 | 743929 | 2021-02-20 | US | Michigan | Chippewa | 26033 | 1729 | 26 | 0 | 1703 | 46.29552653 | -84.54353449 | 2021-02-21 05:24:33 | Chippewa, Michigan, US |
742111 | 742111 | 2021-02-20 | Chile | Valparaiso | 47831 | 1544 | 44584 | 1703 | -33.0472 | -71.6127 | 2021-02-21 05:24:33 | Valparaiso, Chile | ||
473027 | 473027 | 2021-02-19 | US | Michigan | Chippewa | 26033 | 1729 | 26 | 0 | 1703 | 46.29552653 | -84.54353449 | 2021-02-20 05:22:51 | Chippewa, Michigan, US |
1156453 | 1156453 | 2021-02-18 | US | Virginia | Fredericksburg | 51630 | 1717 | 14 | 0 | 1703 | 38.2977863 | -77.4922454 | 2021-02-19 05:24:16 | Fredericksburg, Virginia, US |
1154278 | 1154278 | 2021-02-18 | US | Iowa | Buchanan | 19019 | 1730 | 27 | 0 | 1703 | 42.4709188 | -91.83510825 | 2021-02-19 05:24:16 | Buchanan, Iowa, US |
3600987 | 3600987 | 2021-02-17 | India | Gujarat | 266034 | 4403 | 259928 | 1703 | 22.694884 | 71.590923 | 2021-02-18 05:22:58 | Gujarat, India | ||
2286911 | 2286911 | 2021-02-14 | US | West Virginia | Mason | 54053 | 1739 | 36 | 0 | 1703 | 38.77071799 | -82.02524219 | 2021-02-15 05:24:49 | Mason, West Virginia, US |
1530469 | 1530469 | 2021-02-09 | US | Oklahoma | Okfuskee | 40107 | 1721 | 18 | 0 | 1703 | 35.46485198 | -96.32639984 | 2021-02-10 05:22:41 | Okfuskee, Oklahoma, US |
1530258 | 1530258 | 2021-02-09 | US | North Carolina | Transylvania | 37175 | 1725 | 22 | 0 | 1703 | 35.20383864 | -82.79638423 | 2021-02-10 05:22:41 | Transylvania, North Carolina, US |
617372 | 617372 | 2021-02-08 | Malaysia | Sarawak | 5760 | 53 | 4004 | 1703 | 1.5533 | 110.3592 | 2021-02-09 05:23:30 | Sarawak, Malaysia | ||
613526 | 613526 | 2021-02-08 | Colombia | Caldas | 45329 | 922 | 42704 | 1703 | 5.2983 | -75.2479 | 2021-02-09 05:23:30 | Caldas, Colombia | ||
1674243 | 1674243 | 2021-02-07 | US | Mississippi | Clay | 28025 | 1748 | 45 | 0 | 1703 | 33.65358105 | -88.77784255 | 2021-02-08 05:22:39 | Clay, Mississippi, US |
1591577 | 1591577 | 2021-02-05 | US | Virginia | Southampton | 51175 | 1749 | 46 | 0 | 1703 | 36.72231125 | -77.10642712 | 2021-02-06 05:23:55 | Southampton, Virginia, US |
1686430 | 1686430 | 2021-02-02 | US | Missouri | New Madrid | 29143 | 1746 | 43 | 0 | 1703 | 36.59666326 | -89.66070007 | 2021-02-03 05:22:52 | New Madrid, Missouri, US |
1677868 | 1677868 | 2021-02-01 | US | Kentucky | Grayson | 21085 | 1746 | 43 | 0 | 1703 | 37.46231118 | -86.34248968 | 2021-02-02 05:22:49 | Grayson, Kentucky, US |
1463156 | 1463156 | 2021-01-31 | US | Virginia | Salem | 51775 | 1736 | 33 | 0 | 1703 | 37.2836193 | -80.06219455 | 2021-02-01 05:22:53 | Salem, Virginia, US |
2483700 | 2483700 | 2021-01-28 | US | Minnesota | Martin | 27091 | 1729 | 26 | 0 | 1703 | 43.67429718 | -94.55099908 | 2021-01-29 05:22:23 | Martin, Minnesota, US |
3153868 | 3153868 | 2021-01-27 | Russia | Zabaykalsky Krai | 33383 | 458 | 31222 | 1703 | 52.248521 | 115.956325 | 2021-01-28 05:22:24 | Zabaykalsky Krai, Russia | ||
15600 | 15600 | 2021-01-26 | US | Utah | San Juan | 49037 | 1739 | 36 | 0 | 1703 | 37.62762978 | -109.80337140000002 | 2021-01-27 05:23:41 | San Juan, Utah, US |
12032 | 12032 | 2021-01-26 | Angola | 19553 | 462 | 17388 | 1703 | -11.2027 | 17.8739 | 2021-01-27 05:23:41 | Angola | |||
2569235 | 2569235 | 2021-01-25 | US | Maryland | Garrett | 24023 | 1760 | 57 | 0 | 1703 | 39.52786077 | -79.27355126 | 2021-01-26 05:22:02 | Garrett, Maryland, US |
2428382 | 2428382 | 2021-01-23 | US | Louisiana | Assumption | 22007 | 1733 | 30 | 0 | 1703 | 29.89946234 | -91.06461642 | 2021-01-24 05:22:35 | Assumption, Louisiana, US |
2427754 | 2427754 | 2021-01-23 | US | Georgia | Pike | 13231 | 1729 | 26 | 0 | 1703 | 33.09310242 | -84.38790389 | 2021-01-24 05:22:35 | Pike, Georgia, US |
2468356 | 2468356 | 2021-01-22 | US | Maine | Oxford | 23017 | 1737 | 34 | 0 | 1703 | 44.49952995 | -70.75682123 | 2021-01-23 05:22:03 | Oxford, Maine, US |
2468284 | 2468284 | 2021-01-22 | US | Louisiana | Assumption | 22007 | 1733 | 30 | 0 | 1703 | 29.89946234 | -91.06461642 | 2021-01-23 05:22:03 | Assumption, Louisiana, US |
911597 | 911597 | 2021-01-19 | US | Washington | Adams | 53001 | 1721 | 18 | 0 | 1703 | 46.98299757 | -118.5601734 | 2021-01-20 05:21:54 | Adams, Washington, US |
909674 | 909674 | 2021-01-19 | US | Louisiana | Grant | 22043 | 1745 | 42 | 0 | 1703 | 31.59882456 | -92.56124347 | 2021-01-20 05:21:54 | Grant, Louisiana, US |
3505893 | 3505893 | 2021-01-17 | US | Oklahoma | Craig | 40035 | 1710 | 7 | 0 | 1703 | 36.76268118 | -95.20916602 | 2021-01-18 05:22:34 | Craig, Oklahoma, US |
3104289 | 3104289 | 2021-01-16 | US | South Dakota | Clay | 46027 | 1715 | 12 | 0 | 1703 | 42.91296147 | -96.97656917 | 2021-01-17 05:22:17 | Clay, South Dakota, US |
3103437 | 3103437 | 2021-01-16 | US | Montana | Lake | 30047 | 1722 | 19 | 0 | 1703 | 47.64514965 | -114.0898013 | 2021-01-17 05:22:17 | Lake, Montana, US |
3879757 | 3879757 | 2021-01-14 | Russia | Altai Krai | 35752 | 1007 | 33042 | 1703 | 52.6932243 | 82.69314240000001 | 2021-01-15 05:22:24 | Altai Krai, Russia | ||
3311342 | 3311342 | 2021-01-13 | US | Texas | Lamb | 48279 | 2358 | 72 | 0 | 1703 | 34.06859623 | -102.3516289 | 2021-01-14 05:22:32 | Lamb, Texas, US |
2541590 | 2541590 | 2021-01-07 | Russia | Amur Oblast | 16782 | 105 | 14974 | 1703 | 52.8032368 | 128.437295 | 2021-01-08 05:22:42 | Amur Oblast, Russia | ||
1063500 | 1063500 | 2021-01-04 | US | Michigan | Menominee | 26109 | 1728 | 25 | 0 | 1703 | 45.58038692 | -87.55370409 | 2021-01-05 05:21:49 | Menominee, Michigan, US |
2230804 | 2230804 | 2021-01-02 | US | Virginia | Accomack | 51001 | 1730 | 27 | 0 | 1703 | 37.76707161 | -75.63234615 | 2021-01-03 05:22:52 | Accomack, Virginia, US |
3765122 | 3765122 | 2020-12-28 | US | Wisconsin | Iowa | 55049 | 1710 | 7 | 0 | 1703 | 43.00050278 | -90.13469017 | 2020-12-29 05:22:37 | Iowa, Wisconsin, US |
2409778 | 2409778 | 2020-12-23 | US | Tennessee | Johnson | 47091 | 1709 | 28 | 0 | 1703 | 36.45523950000001 | -81.84886538 | 2020-12-24 05:23:04 | Johnson, Tennessee, US |
3773292 | 3773292 | 2020-12-22 | US | Virginia | Wise | 51195 | 1756 | 53 | 0 | 1703 | 36.9746148 | -82.62410519 | 2020-12-23 05:22:03 | Wise, Virginia, US |
930995 | 930995 | 2020-12-21 | US | Virginia | Campbell | 51031 | 1721 | 18 | 0 | 1703 | 37.20553386 | -79.09678609 | 2020-12-22 05:22:33 | Campbell, Virginia, US |
930619 | 930619 | 2020-12-21 | US | Tennessee | Fentress | 47049 | 1760 | 27 | 0 | 1703 | 36.38128818 | -84.92870012 | 2020-12-22 05:22:33 | Fentress, Tennessee, US |
2978853 | 2978853 | 2020-12-09 | Ukraine | Luhansk Oblast | 7275 | 194 | 5378 | 1703 | 48.574 | 39.3078 | 2020-12-10 05:26:19 | Luhansk Oblast, Ukraine | ||
2350309 | 2350309 | 2020-12-07 | US | South Dakota | Oglala Lakota | 46102 | 1730 | 27 | 0 | 1703 | 43.33749164 | -102.5555498 | 2020-12-08 05:27:42 | Oglala Lakota, South Dakota, US |
2348498 | 2348498 | 2020-12-07 | US | Indiana | Fayette | 18041 | 1745 | 42 | 0 | 1703 | 39.63684962 | -85.17797541 | 2020-12-08 05:27:42 | Fayette, Indiana, US |
1632214 | 1632214 | 2020-12-05 | Germany | Bremen | 10632 | 133 | 8936 | 1703 | 53.0793 | 8.8017 | 2020-12-06 05:26:18 | Bremen, Germany | ||
3862743 | 3862743 | 2020-12-04 | US | Tennessee | Cheatham | 47021 | 1722 | 17 | 0 | 1703 | 36.26136216 | -87.08903581 | 2020-12-05 05:27:36 | Cheatham, Tennessee, US |
3862008 | 3862008 | 2020-12-04 | US | New Mexico | Cibola | 35006 | 1752 | 49 | 0 | 1703 | 34.91131525 | -107.998876 | 2020-12-05 05:27:36 | Cibola, New Mexico, US |
740146 | 740146 | 2020-12-02 | US | Mississippi | Union | 28145 | 1729 | 26 | 0 | 1703 | 34.49162015 | -89.00776006 | 2020-12-03 05:28:22 | Union, Mississippi, US |
680861 | 680861 | 2020-11-23 | US | Oklahoma | Jackson | 40065 | 1730 | 27 | 0 | 1703 | 34.58781741 | -99.41138784 | 2020-11-24 05:27:31 | Jackson, Oklahoma, US |
2701622 | 2701622 | 2020-11-20 | Mozambique | 14877 | 121 | 13053 | 1703 | -18.665695 | 35.529562 | 2020-11-21 05:25:51 | Mozambique | |||
3339700 | 3339700 | 2020-11-17 | US | Indiana | Morgan | 18109 | 1747 | 44 | 0 | 1703 | 39.47899078 | -86.44573375 | 2020-11-18 05:40:31 | Morgan, Indiana, US |
3442272 | 3442272 | 2020-11-11 | US | Kentucky | Shelby | 21211 | 1728 | 25 | 0 | 1703 | 38.21476019 | -85.194223 | 2020-11-12 05:25:55 | Shelby, Kentucky, US |
3441897 | 3441897 | 2020-11-11 | US | Indiana | Hancock | 18059 | 1748 | 45 | 0 | 1703 | 39.82304555 | -85.77566351 | 2020-11-12 05:25:55 | Hancock, Indiana, US |
273193 | 273193 | 2020-11-10 | US | Illinois | Stephenson | 17177 | 1719 | 16 | 0 | 1703 | 42.35129217 | -89.662598 | 2020-11-11 05:25:30 | Stephenson, Illinois, US |
1990280 | 1990280 | 2020-11-09 | US | Michigan | Marquette | 26103 | 1722 | 19 | 0 | 1703 | 46.4338914 | -87.64043701 | 2020-11-10 05:40:07 | Marquette, Michigan, US |
2921723 | 2921723 | 2020-11-04 | US | Oklahoma | Grady | 40051 | 1721 | 18 | 0 | 1703 | 35.0167709 | -97.88339847 | 2020-11-05 06:05:03 | Grady, Oklahoma, US |
2501357 | 2501357 | 2020-11-03 | US | Virginia | Hanover | 51085 | 1747 | 44 | 0 | 1703 | 37.7583355 | -77.49464673 | 2020-11-04 05:25:09 | Hanover, Virginia, US |
2245438 | 2245438 | 2020-10-30 | US | Nebraska | Dodge | 31053 | 1723 | 20 | 0 | 1703 | 41.58071748 | -96.65598179 | 2020-10-31 04:24:44 | Dodge, Nebraska, US |
1455507 | 1455507 | 2020-10-27 | US | Tennessee | Dickson | 47043 | 1712 | 19 | 0 | 1703 | 36.14669837 | -87.35891709 | 2020-10-28 04:24:39 | Dickson, Tennessee, US |
3480149 | 3480149 | 2020-10-26 | Colombia | Boyaca | 12726 | 273 | 10750 | 1703 | 5.4545 | -73.362 | 2020-10-27 04:24:45 | Boyaca, Colombia | ||
3992428 | 3992428 | 2020-10-20 | US | Mississippi | Neshoba | 28099 | 1814 | 111 | 0 | 1703 | 32.75339664 | -89.11726492 | 2020-10-21 04:24:14 | Neshoba, Mississippi, US |
1027231 | 1027231 | 2020-10-17 | US | Georgia | Walker | 13295 | 1746 | 43 | 0 | 1703 | 34.73376362 | -85.30165174 | 2020-10-18 04:24:25 | Walker, Georgia, US |
2602831 | 2602831 | 2020-10-10 | US | Georgia | Habersham | 13137 | 1775 | 72 | 0 | 1703 | 34.63331566 | -83.53094677 | 2020-10-11 04:23:46 | Habersham, Georgia, US |
1042193 | 1042193 | 2020-10-07 | US | Alabama | Jackson | 1071 | 1715 | 12 | 0 | 1703 | 34.78144169 | -85.99750489 | 2020-10-08 04:23:56 | Jackson, Alabama, US |
1516722 | 1516722 | 2020-09-28 | US | Kansas | Seward | 20175 | 1708 | 5 | 0 | 1703 | 37.19324632 | -100.8507201 | 2020-09-29 04:23:42 | Seward, Kansas, US |
2583310 | 2583310 | 2020-09-27 | US | Kansas | Seward | 20175 | 1708 | 5 | 0 | 1703 | 37.19324632 | -100.8507201 | 2020-09-28 04:23:00 | Seward, Kansas, US |
2582660 | 2582660 | 2020-09-27 | US | Florida | Flagler | 12035 | 1726 | 23 | 0 | 1703 | 29.45933576 | -81.31508595 | 2020-09-28 04:23:00 | Flagler, Florida, US |
2615362 | 2615362 | 2020-09-26 | US | Kansas | Seward | 20175 | 1708 | 5 | 0 | 1703 | 37.19324632 | -100.8507201 | 2020-09-27 04:23:00 | Seward, Kansas, US |
2814077 | 2814077 | 2020-09-25 | US | Kansas | Seward | 20175 | 1708 | 5 | 0 | 1703 | 37.19324632 | -100.8507201 | 2020-09-26 04:23:00 | Seward, Kansas, US |
3318090 | 3318090 | 2020-09-22 | US | Missouri | Clay | 29047 | 1743 | 40 | 0 | 1703 | 39.31132056 | -94.41850862 | 2020-09-23 04:23:00 | Clay, Missouri, US |
2837602 | 2837602 | 2020-09-21 | US | Georgia | Fayette | 13113 | 1752 | 49 | 0 | 1703 | 33.41357794 | -84.49089434 | 2020-09-22 04:23:00 | Fayette, Georgia, US |
2850441 | 2850441 | 2020-09-18 | US | Michigan | Berrien | 26021 | 1775 | 72 | 0 | 1703 | 41.95447397 | -86.4131308 | 2020-09-19 04:22:00 | Berrien, Michigan, US |
2868570 | 2868570 | 2020-09-13 | Colombia | Norte de Santander | 13652 | 793 | 11156 | 1703 | 7.9463 | -72.8988 | 2020-09-14 04:26:00 | Norte de Santander, Colombia | ||
549271 | 549271 | 2020-09-12 | US | Oklahoma | Canadian | 40017 | 1716 | 13 | 0 | 1703 | 35.5426055 | -97.98465569 | 2020-09-13 04:30:52 | Canadian, Oklahoma, US |
547560 | 547560 | 2020-09-12 | US | Georgia | Jackson | 13157 | 1730 | 27 | 0 | 1703 | 34.13794553 | -83.56814788 | 2020-09-13 04:30:52 | Jackson, Georgia, US |
427799 | 427799 | 2020-09-07 | US | Arkansas | Crittenden | 5035 | 1738 | 35 | 0 | 1703 | 35.21247318 | -90.30839406 | 2020-09-08 04:28:25 | Crittenden, Arkansas, US |
814304 | 814304 | 2020-09-05 | US | Florida | Walton | 12131 | 1723 | 20 | 0 | 1703 | 30.64204028 | -86.16935664 | 2020-09-06 04:28:33 | Walton, Florida, US |
1355835 | 1355835 | 2020-09-03 | US | Louisiana | St. Mary | 22101 | 1774 | 71 | 0 | 1703 | 29.69262097 | -91.44702164 | 2020-09-04 04:28:26 | St. Mary, Louisiana, US |
1107072 | 1107072 | 2020-09-02 | US | Louisiana | St. Mary | 22101 | 1773 | 70 | 0 | 1703 | 29.69262097 | -91.44702164 | 2020-09-03 04:28:22 | St. Mary, Louisiana, US |
610393 | 610393 | 2020-08-29 | US | Florida | Monroe | 12087 | 1719 | 16 | 0 | 1703 | 25.20904673 | -81.07812416 | 2020-08-30 04:28:22 | Monroe, Florida, 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]);