johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
603 rows where active = 339 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 30
- US 520
- Japan 14
- Colombia 9
- Mexico 9
- Ukraine 7
- Russia 5
- China 4
- India 4
- Malaysia 4
- Chile 3
- Netherlands 2
- Saint Vincent and the Grenadines 2
- United Kingdom 2
- Vietnam 2
- Barbados 1
- Cabo Verde 1
- Congo (Kinshasa) 1
- Estonia 1
- France 1
- Germany 1
- Ireland 1
- Italy 1
- Lebanon 1
- Namibia 1
- Pakistan 1
- Singapore 1
- Suriname 1
- Syria 1
- Togo 1
- Zambia 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3015386 | 3015386 | 2021-08-01 | Japan | Shiga | 6067 | 93 | 5635 | 339 | 35.21582700000001 | 136.138064 | 2021-08-02 04:21:36 | Shiga, Japan | ||
408324 | 408324 | 2021-07-28 | Japan | Okayama | 7984 | 127 | 7518 | 339 | 34.89246 | 133.826252 | 2021-07-29 04:21:33 | Okayama, Japan | ||
2950976 | 2950976 | 2021-07-16 | Ukraine | Cherkasy Oblast | 81996 | 1319 | 80338 | 339 | 49.4444 | 32.0598 | 2021-07-17 04:22:22 | Cherkasy Oblast, Ukraine | ||
781982 | 781982 | 2021-07-08 | Ukraine | Chernihiv Oblast | 57592 | 1350 | 55903 | 339 | 51.4982 | 31.2893 | 2021-07-09 04:21:21 | Chernihiv Oblast, Ukraine | ||
1444212 | 1444212 | 2021-07-07 | Ukraine | Khmelnytskyi Oblast | 88974 | 1879 | 86756 | 339 | 49.423 | 26.9871 | 2021-07-08 04:21:26 | Khmelnytskyi Oblast, Ukraine | ||
3362310 | 3362310 | 2021-06-21 | Ukraine | Vinnytsia Oblast | 70995 | 1686 | 68970 | 339 | 49.2331 | 28.4682 | 2021-06-22 04:21:34 | Vinnytsia Oblast, Ukraine | ||
2716827 | 2716827 | 2021-06-10 | Colombia | Putumayo | 12478 | 527 | 11612 | 339 | 0.436 | -75.5277 | 2021-06-11 04:23:20 | Putumayo, Colombia | ||
2586002 | 2586002 | 2021-06-05 | Japan | Ishikawa | 3824 | 108 | 3377 | 339 | 36.769464 | 136.771027 | 2021-06-06 04:24:03 | Ishikawa, Japan | ||
2585843 | 2585843 | 2021-06-05 | Colombia | Putumayo | 12280 | 507 | 11434 | 339 | 0.436 | -75.5277 | 2021-06-06 04:24:03 | Putumayo, Colombia | ||
1708646 | 1708646 | 2021-06-02 | Togo | 13496 | 125 | 13032 | 339 | 8.6195 | 0.8248 | 2021-06-03 04:23:32 | Togo | |||
3089365 | 3089365 | 2021-05-30 | India | Dadra and Nagar Haveli and Daman and Diu | 10256 | 4 | 9913 | 339 | 20.194742 | 73.080901 | 2021-05-31 03:08:59 | Dadra and Nagar Haveli and Daman and Diu, India | ||
50808 | 50808 | 2021-05-29 | Japan | Kagoshima | 3285 | 30 | 2916 | 339 | 31.009484000000004 | 130.430665 | 2021-05-30 04:20:55 | Kagoshima, Japan | ||
2390626 | 2390626 | 2021-05-18 | Colombia | Putumayo | 11108 | 435 | 10334 | 339 | 0.436 | -75.5277 | 2021-05-19 04:20:42 | Putumayo, Colombia | ||
2502053 | 2502053 | 2021-05-07 | Japan | Miyazaki | 2457 | 23 | 2095 | 339 | 32.193203999999994 | 131.299374 | 2021-05-08 04:21:04 | Miyazaki, Japan | ||
2764586 | 2764586 | 2021-05-03 | Zambia | 91722 | 1253 | 90130 | 339 | -13.133897 | 27.849332 | 2021-05-04 04:20:34 | Zambia | |||
888396 | 888396 | 2021-04-26 | Singapore | 61051 | 30 | 60682 | 339 | 1.2833 | 103.8333 | 2021-04-27 04:20:52 | Singapore | |||
954875 | 954875 | 2021-04-25 | Japan | Hiroshima | 5701 | 109 | 5253 | 339 | 34.605309000000005 | 132.788719 | 2021-04-26 04:21:04 | Hiroshima, Japan | ||
1409159 | 1409159 | 2021-04-23 | Netherlands | Aruba | 10505 | 97 | 10069 | 339 | 12.5211 | -69.9683 | 2021-04-24 04:20:38 | Aruba, Netherlands | ||
3246003 | 3246003 | 2021-04-21 | Malaysia | Melaka | 7006 | 22 | 6645 | 339 | 2.1896 | 102.2501 | 2021-04-22 04:20:53 | Melaka, Malaysia | ||
36642 | 36642 | 2021-04-12 | Russia | Komi Republic | 42392 | 836 | 41217 | 339 | 63.9881421 | 54.3326073 | 2021-04-13 04:20:37 | Komi Republic, Russia | ||
3883596 | 3883596 | 2021-04-11 | Japan | Fukushima | 2809 | 118 | 2352 | 339 | 37.378867 | 140.223295 | 2021-04-12 04:21:00 | Fukushima, Japan | ||
2983469 | 2983469 | 2021-04-10 | Russia | Komi Republic | 42270 | 831 | 41100 | 339 | 63.9881421 | 54.3326073 | 2021-04-11 04:20:56 | Komi Republic, Russia | ||
388072 | 388072 | 2021-04-04 | Colombia | Huila | 51099 | 1794 | 48966 | 339 | 2.5359 | -75.5277 | 2021-04-05 04:20:35 | Huila, Colombia | ||
3643402 | 3643402 | 2021-03-30 | Colombia | Huila | 50876 | 1789 | 48748 | 339 | 2.5359 | -75.5277 | 2021-03-31 04:26:25 | Huila, Colombia | ||
1535935 | 1535935 | 2021-03-28 | Japan | Fukushima | 2461 | 112 | 2010 | 339 | 37.378867 | 140.223295 | 2021-03-29 04:28:35 | Fukushima, Japan | ||
1535778 | 1535778 | 2021-03-28 | Colombia | La Guajira | 17638 | 657 | 16642 | 339 | 11.3548 | -72.5205 | 2021-03-29 04:28:35 | La Guajira, Colombia | ||
3373004 | 3373004 | 2021-03-21 | Malaysia | Kelantan | 5621 | 23 | 5259 | 339 | 6.1254 | 102.2381 | 2021-03-22 05:25:43 | Kelantan, Malaysia | ||
3372991 | 3372991 | 2021-03-21 | Vietnam | 2572 | 35 | 2198 | 339 | 14.058324 | 108.277199 | 2021-03-22 05:25:43 | Vietnam | |||
1748201 | 1748201 | 2021-03-20 | Vietnam | 2572 | 35 | 2198 | 339 | 14.058324 | 108.277199 | 2021-03-21 05:25:44 | Vietnam | |||
3453162 | 3453162 | 2021-03-18 | Suriname | 9049 | 176 | 8534 | 339 | 3.9193 | -56.0278 | 2021-03-19 05:26:09 | Suriname | |||
2055693 | 2055693 | 2021-03-15 | China | Hong Kong | 11311 | 203 | 10769 | 339 | 22.3 | 114.2 | 2021-03-16 05:25:13 | Hong Kong, China | ||
1093130 | 1093130 | 2021-03-03 | US | Texas | Culberson | 48109 | 320 | 7 | 0 | 339 | 31.44506775 | -104.5185739 | 2021-03-04 05:24:24 | Culberson, Texas, US |
3257202 | 3257202 | 2021-03-02 | US | Texas | Culberson | 48109 | 320 | 7 | 0 | 339 | 31.44506775 | -104.5185739 | 2021-03-03 05:23:28 | Culberson, Texas, US |
2368756 | 2368756 | 2021-02-28 | US | Kansas | Cheyenne | 20023 | 352 | 13 | 0 | 339 | 39.78580976 | -101.7318201 | 2021-03-01 05:23:01 | Cheyenne, Kansas, US |
3067258 | 3067258 | 2021-02-27 | US | Kansas | Cheyenne | 20023 | 352 | 13 | 0 | 339 | 39.78580976 | -101.7318201 | 2021-02-28 05:22:20 | Cheyenne, Kansas, US |
2186908 | 2186908 | 2021-02-26 | US | Virginia | Falls Church | 51610 | 346 | 7 | 0 | 339 | 38.88485255 | -77.17560759 | 2021-02-27 05:22:28 | Falls Church, Virginia, US |
2185697 | 2185697 | 2021-02-26 | US | Nebraska | Stanton | 31167 | 348 | 9 | 0 | 339 | 41.9169835 | -97.19394708 | 2021-02-27 05:22:28 | Stanton, Nebraska, US |
2184842 | 2184842 | 2021-02-26 | US | Kansas | Cheyenne | 20023 | 352 | 13 | 0 | 339 | 39.78580976 | -101.7318201 | 2021-02-27 05:22:28 | Cheyenne, Kansas, US |
1860119 | 1860119 | 2021-02-25 | US | Nebraska | Stanton | 31167 | 348 | 9 | 0 | 339 | 41.9169835 | -97.19394708 | 2021-02-26 05:22:40 | Stanton, Nebraska, US |
282297 | 282297 | 2021-02-24 | US | Nebraska | Stanton | 31167 | 348 | 9 | 0 | 339 | 41.9169835 | -97.19394708 | 2021-02-25 05:24:57 | Stanton, Nebraska, US |
1940136 | 1940136 | 2021-02-23 | Malaysia | Terengganu | 3146 | 10 | 2797 | 339 | 5.3117 | 103.1324 | 2021-02-24 05:29:16 | Terengganu, Malaysia | ||
1938565 | 1938565 | 2021-02-23 | US | Nebraska | Stanton | 31167 | 348 | 9 | 0 | 339 | 41.9169835 | -97.19394708 | 2021-02-24 05:29:16 | Stanton, Nebraska, US |
532892 | 532892 | 2021-02-22 | US | New Mexico | Guadalupe | 35019 | 348 | 9 | 0 | 339 | 34.86319296 | -104.790669 | 2021-02-23 05:23:41 | Guadalupe, New Mexico, US |
184226 | 184226 | 2021-02-21 | US | New Mexico | Guadalupe | 35019 | 348 | 9 | 0 | 339 | 34.86319296 | -104.790669 | 2021-02-22 05:24:21 | Guadalupe, New Mexico, US |
745827 | 745827 | 2021-02-20 | US | West Virginia | Wirt | 54105 | 341 | 2 | 0 | 339 | 39.02775007 | -81.37473928 | 2021-02-21 05:24:33 | Wirt, West Virginia, US |
744500 | 744500 | 2021-02-20 | US | New Mexico | Guadalupe | 35019 | 348 | 9 | 0 | 339 | 34.86319296 | -104.790669 | 2021-02-21 05:24:33 | Guadalupe, New Mexico, US |
742895 | 742895 | 2021-02-20 | US | California | Trinity | 6105 | 357 | 3 | 0 | 339 | 40.64917670000001 | -123.114713 | 2021-02-21 05:24:33 | Trinity, California, US |
474925 | 474925 | 2021-02-19 | US | West Virginia | Wirt | 54105 | 341 | 2 | 0 | 339 | 39.02775007 | -81.37473928 | 2021-02-20 05:22:51 | Wirt, West Virginia, US |
1156634 | 1156634 | 2021-02-18 | US | West Virginia | Wirt | 54105 | 341 | 2 | 0 | 339 | 39.02775007 | -81.37473928 | 2021-02-19 05:24:16 | Wirt, West Virginia, US |
1154781 | 1154781 | 2021-02-18 | US | Michigan | Montmorency | 26119 | 356 | 17 | 0 | 339 | 45.0275929 | -84.12696227 | 2021-02-19 05:24:16 | Montmorency, Michigan, US |
1154030 | 1154030 | 2021-02-18 | US | Idaho | Bear Lake | 16007 | 341 | 2 | 0 | 339 | 42.28269683 | -111.32892379999998 | 2021-02-19 05:24:16 | Bear Lake, Idaho, US |
3604554 | 3604554 | 2021-02-17 | US | West Virginia | Wirt | 54105 | 341 | 2 | 0 | 339 | 39.02775007 | -81.37473928 | 2021-02-18 05:22:58 | Wirt, West Virginia, US |
1341135 | 1341135 | 2021-02-15 | US | South Dakota | Faulk | 46049 | 352 | 13 | 0 | 339 | 45.07082625 | -99.14535601 | 2021-02-16 05:24:38 | Faulk, South Dakota, US |
2286286 | 2286286 | 2021-02-14 | US | South Dakota | Faulk | 46049 | 352 | 13 | 0 | 339 | 45.07082625 | -99.14535601 | 2021-02-15 05:24:49 | Faulk, South Dakota, US |
3539168 | 3539168 | 2021-02-12 | Barbados | 1947 | 21 | 1587 | 339 | 13.1939 | -59.5432 | 2021-02-13 05:22:12 | Barbados | |||
1530763 | 1530763 | 2021-02-09 | US | South Dakota | Hanson | 46061 | 343 | 4 | 0 | 339 | 43.6746384 | -97.78715148 | 2021-02-10 05:22:41 | Hanson, South Dakota, US |
617005 | 617005 | 2021-02-08 | US | Virginia | Cumberland | 51049 | 343 | 4 | 0 | 339 | 37.51328851 | -78.24398086 | 2021-02-09 05:23:30 | Cumberland, Virginia, US |
616721 | 616721 | 2021-02-08 | US | Texas | Carson | 48065 | 621 | 12 | 0 | 339 | 35.40365929 | -101.3542669 | 2021-02-09 05:23:30 | Carson, Texas, US |
1675490 | 1675490 | 2021-02-07 | US | Texas | Carson | 48065 | 621 | 12 | 0 | 339 | 35.40365929 | -101.3542669 | 2021-02-08 05:22:39 | Carson, Texas, US |
1674998 | 1674998 | 2021-02-07 | US | Oklahoma | Ellis | 40045 | 340 | 1 | 0 | 339 | 36.2180194 | -99.75324573 | 2021-02-08 05:22:39 | Ellis, Oklahoma, US |
1672479 | 1672479 | 2021-02-07 | Japan | Mie | 2331 | 35 | 1957 | 339 | 34.508018 | 136.376013 | 2021-02-08 05:22:39 | Mie, Japan | ||
977951 | 977951 | 2021-02-06 | US | Texas | Carson | 48065 | 621 | 12 | 0 | 339 | 35.40365929 | -101.3542669 | 2021-02-07 05:23:00 | Carson, Texas, US |
977523 | 977523 | 2021-02-06 | US | Oregon | Curry | 41015 | 345 | 6 | 0 | 339 | 42.45911325 | -124.157282 | 2021-02-07 05:23:00 | Curry, Oregon, US |
977459 | 977459 | 2021-02-06 | US | Oklahoma | Ellis | 40045 | 340 | 1 | 0 | 339 | 36.2180194 | -99.75324573 | 2021-02-07 05:23:00 | Ellis, Oklahoma, US |
1589818 | 1589818 | 2021-02-05 | US | Michigan | Lake | 26085 | 350 | 11 | 0 | 339 | 43.99050893 | -85.802173 | 2021-02-06 05:23:55 | Lake, Michigan, US |
343582 | 343582 | 2021-02-03 | US | Virginia | Charles City | 51036 | 348 | 9 | 0 | 339 | 37.35358063 | -77.05634116 | 2021-02-04 05:22:26 | Charles City, Virginia, US |
343123 | 343123 | 2021-02-03 | US | South Dakota | Clark | 46025 | 343 | 4 | 0 | 339 | 44.85834507 | -97.72925109 | 2021-02-04 05:22:26 | Clark, South Dakota, US |
1897613 | 1897613 | 2021-01-29 | US | Arkansas | Calhoun | 5013 | 341 | 2 | 0 | 339 | 33.55598792 | -92.49974403 | 2021-01-30 05:22:49 | Calhoun, Arkansas, US |
2481918 | 2481918 | 2021-01-28 | India | Himachal Pradesh | 57356 | 974 | 56043 | 339 | 31.927213 | 77.233081 | 2021-01-29 05:22:23 | Himachal Pradesh, India | ||
3155739 | 3155739 | 2021-01-27 | US | Nevada | Lincoln | 32017 | 340 | 1 | 0 | 339 | 37.64268459 | -114.8790388 | 2021-01-28 05:22:24 | Lincoln, Nevada, US |
14474 | 14474 | 2021-01-26 | US | Nevada | Lincoln | 32017 | 340 | 1 | 0 | 339 | 37.64268459 | -114.8790388 | 2021-01-27 05:23:41 | Lincoln, Nevada, US |
2570941 | 2570941 | 2021-01-25 | US | Vermont | Lamoille | 50015 | 340 | 1 | 0 | 339 | 44.60353043 | -72.64356694 | 2021-01-26 05:22:02 | Lamoille, Vermont, US |
2569798 | 2569798 | 2021-01-25 | US | Nevada | Lincoln | 32017 | 340 | 1 | 0 | 339 | 37.64268459 | -114.8790388 | 2021-01-26 05:22:02 | Lincoln, Nevada, US |
1762575 | 1762575 | 2021-01-24 | US | Vermont | Orleans | 50019 | 344 | 5 | 0 | 339 | 44.82964024 | -72.24562697 | 2021-01-25 05:22:16 | Orleans, Vermont, US |
2429793 | 2429793 | 2021-01-23 | US | South Dakota | Potter | 46107 | 342 | 3 | 0 | 339 | 45.06583079 | -99.95498503 | 2021-01-24 05:22:35 | Potter, South Dakota, US |
2469695 | 2469695 | 2021-01-22 | US | South Dakota | Potter | 46107 | 342 | 3 | 0 | 339 | 45.06583079 | -99.95498503 | 2021-01-23 05:22:03 | Potter, South Dakota, US |
437256 | 437256 | 2021-01-21 | US | Missouri | Holt | 29087 | 349 | 10 | 0 | 339 | 40.09799248 | -95.2163888 | 2021-01-22 05:22:10 | Holt, Missouri, US |
910937 | 910937 | 2021-01-19 | US | Puerto Rico | Penuelas | 72111 | 339 | 0 | 0 | 339 | 18.059645 | -66.721572 | 2021-01-20 05:21:54 | Penuelas, Puerto Rico, US |
910154 | 910154 | 2021-01-19 | US | Montana | Broadwater | 30007 | 341 | 2 | 0 | 339 | 46.33277565 | -111.4955813 | 2021-01-20 05:21:54 | Broadwater, Montana, US |
240606 | 240606 | 2021-01-18 | US | Virginia | Middlesex | 51119 | 352 | 13 | 0 | 339 | 37.63191998 | -76.55064617 | 2021-01-19 05:22:15 | Middlesex, Virginia, US |
240000 | 240000 | 2021-01-18 | US | Puerto Rico | Penuelas | 72111 | 339 | 0 | 0 | 339 | 18.059645 | -66.721572 | 2021-01-19 05:22:15 | Penuelas, Puerto Rico, US |
239217 | 239217 | 2021-01-18 | US | Montana | Broadwater | 30007 | 341 | 2 | 0 | 339 | 46.33277565 | -111.4955813 | 2021-01-19 05:22:15 | Broadwater, Montana, US |
3101990 | 3101990 | 2021-01-16 | US | California | Mariposa | 6043 | 343 | 4 | 0 | 339 | 37.57978556 | -119.9073334 | 2021-01-17 05:22:17 | Mariposa, California, US |
3101707 | 3101707 | 2021-01-16 | Saint Vincent and the Grenadines | 450 | 1 | 110 | 339 | 12.9843 | -61.2872 | 2021-01-17 05:22:17 | Saint Vincent and the Grenadines | |||
3515669 | 3515669 | 2021-01-15 | Saint Vincent and the Grenadines | 450 | 1 | 110 | 339 | 12.9843 | -61.2872 | 2021-01-16 05:22:40 | Saint Vincent and the Grenadines | |||
3881023 | 3881023 | 2021-01-14 | US | Kentucky | Owsley | 21189 | 349 | 10 | 0 | 339 | 37.42823949 | -83.68811419 | 2021-01-15 05:22:24 | Owsley, Kentucky, US |
3880920 | 3880920 | 2021-01-14 | US | Kansas | Trego | 20195 | 345 | 6 | 0 | 339 | 38.91467218 | -99.87284448 | 2021-01-15 05:22:24 | Trego, Kansas, US |
3311305 | 3311305 | 2021-01-13 | US | Texas | Haskell | 48207 | 351 | 13 | 0 | 339 | 33.17823584 | -99.73037358 | 2021-01-14 05:22:32 | Haskell, Texas, US |
3309547 | 3309547 | 2021-01-13 | US | Kansas | Trego | 20195 | 345 | 6 | 0 | 339 | 38.91467218 | -99.87284448 | 2021-01-14 05:22:32 | Trego, Kansas, US |
776066 | 776066 | 2021-01-12 | US | Minnesota | Kittson | 27069 | 358 | 19 | 0 | 339 | 48.77754106 | -96.78317184 | 2021-01-13 05:22:15 | Kittson, Minnesota, US |
191541 | 191541 | 2021-01-11 | US | Kentucky | Wolfe | 21237 | 343 | 4 | 0 | 339 | 37.73941626 | -83.49303612 | 2021-01-12 05:22:15 | Wolfe, Kentucky, US |
190955 | 190955 | 2021-01-11 | US | Georgia | Warren | 13301 | 348 | 9 | 0 | 339 | 33.41146451 | -82.67795848 | 2021-01-12 05:22:15 | Warren, Georgia, US |
2626900 | 2626900 | 2021-01-10 | US | Illinois | Putnam | 17155 | 340 | 1 | 0 | 339 | 41.2013541 | -89.2869272 | 2021-01-11 05:21:50 | Putnam, Illinois, US |
2544769 | 2544769 | 2021-01-07 | US | Virginia | Mathews | 51115 | 343 | 4 | 0 | 339 | 37.44164146 | -76.34098896 | 2021-01-08 05:22:42 | Mathews, Virginia, US |
2542831 | 2542831 | 2021-01-07 | US | Kentucky | Lyon | 21143 | 346 | 7 | 0 | 339 | 37.02080035 | -88.07886257 | 2021-01-08 05:22:42 | Lyon, Kentucky, US |
2542057 | 2542057 | 2021-01-07 | US | Colorado | Washington | 8121 | 377 | 11 | 0 | 339 | 39.97015535 | -103.202587 | 2021-01-08 05:22:42 | Washington, Colorado, US |
2866910 | 2866910 | 2021-01-06 | US | New Mexico | Quay | 35037 | 346 | 7 | 0 | 339 | 35.10403332 | -103.5481727 | 2021-01-07 05:22:03 | Quay, New Mexico, US |
2866797 | 2866797 | 2021-01-06 | US | Nebraska | Kimball | 31105 | 344 | 5 | 0 | 339 | 41.19774275 | -103.7148131 | 2021-01-07 05:22:03 | Kimball, Nebraska, US |
1063445 | 1063445 | 2021-01-04 | US | Michigan | Alcona | 26001 | 353 | 14 | 0 | 339 | 44.6846864 | -83.59507875 | 2021-01-05 05:21:49 | Alcona, Michigan, US |
1061963 | 1061963 | 2021-01-04 | Netherlands | Aruba | 5606 | 49 | 5218 | 339 | 12.5211 | -69.9683 | 2021-01-05 05:21:49 | Aruba, Netherlands |
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]);