johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
594 rows where active = 319 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 28
- US 518
- Japan 10
- Ukraine 9
- Malaysia 8
- Russia 8
- Colombia 4
- India 4
- Mexico 4
- Canada 3
- Mauritania 3
- Australia 2
- Congo (Kinshasa) 2
- Germany 2
- Liechtenstein 2
- Montenegro 2
- Chile 1
- Cote d'Ivoire 1
- Cyprus 1
- Denmark 1
- France 1
- Georgia 1
- Italy 1
- Mali 1
- Malta 1
- Pakistan 1
- Rwanda 1
- Singapore 1
- South Sudan 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1333880 | 1333880 | 2021-07-24 | Ukraine | Luhansk Oblast | 26994 | 967 | 25708 | 319 | 48.574 | 39.3078 | 2021-07-25 04:22:12 | Luhansk Oblast, Ukraine | ||
1330286 | 1330286 | 2021-07-24 | Japan | Tochigi | 7586 | 84 | 7183 | 319 | 36.689912 | 139.819213 | 2021-07-25 04:22:12 | Tochigi, Japan | ||
3744709 | 3744709 | 2021-07-12 | Ukraine | Kherson Oblast | 35936 | 1147 | 34470 | 319 | 46.6354 | 32.6169 | 2021-07-13 04:21:18 | Kherson Oblast, Ukraine | ||
829709 | 829709 | 2021-07-09 | Montenegro | 100430 | 1620 | 98491 | 319 | 42.708678000000006 | 19.37439 | 2021-07-10 04:21:25 | Montenegro | |||
778473 | 778473 | 2021-07-08 | Montenegro | 100414 | 1619 | 98476 | 319 | 42.708678000000006 | 19.37439 | 2021-07-09 04:21:21 | Montenegro | |||
1440360 | 1440360 | 2021-07-07 | Canada | Saskatchewan | 49039 | 570 | 48150 | 319 | 52.9399 | -106.4509 | 2021-07-08 04:21:26 | Saskatchewan, Canada | ||
2693597 | 2693597 | 2021-07-06 | Germany | Berlin | 180322 | 3561 | 176500 | 319 | 52.52 | 13.405 | 2021-07-07 04:21:20 | Berlin, Germany | ||
1168853 | 1168853 | 2021-07-04 | Malaysia | Terengganu | 11402 | 78 | 11005 | 319 | 5.3117 | 103.1324 | 2021-07-05 04:21:28 | Terengganu, Malaysia | ||
2765212 | 2765212 | 2021-07-01 | Singapore | 62589 | 36 | 62234 | 319 | 1.2833 | 103.8333 | 2021-07-02 04:21:47 | Singapore | |||
2299135 | 2299135 | 2021-06-24 | Malaysia | Terengganu | 11048 | 74 | 10655 | 319 | 5.3117 | 103.1324 | 2021-06-25 04:21:33 | Terengganu, Malaysia | ||
563170 | 563170 | 2021-06-22 | Russia | Kabardino-Balkarian Republic | 24668 | 486 | 23863 | 319 | 43.4806048 | 43.5978976 | 2021-06-23 04:21:46 | Kabardino-Balkarian Republic, Russia | ||
3358623 | 3358623 | 2021-06-21 | India | Lakshadweep | 9471 | 46 | 9106 | 319 | 13.6999972 | 72.18333259999999 | 2021-06-22 04:21:34 | Lakshadweep, India | ||
2884322 | 2884322 | 2021-06-20 | India | Lakshadweep | 9443 | 46 | 9078 | 319 | 13.6999972 | 72.18333259999999 | 2021-06-21 04:21:41 | Lakshadweep, India | ||
107295 | 107295 | 2021-06-19 | Colombia | Choco | 13442 | 329 | 12794 | 319 | 5.2528 | -76.82600000000002 | 2021-06-20 04:21:48 | Choco, Colombia | ||
20372 | 20372 | 2021-05-28 | Japan | Aomori | 2315 | 30 | 1966 | 319 | 40.781541 | 140.828896 | 2021-05-29 04:20:41 | Aomori, Japan | ||
2820810 | 2820810 | 2021-05-10 | Japan | Tochigi | 5628 | 73 | 5236 | 319 | 36.689912 | 139.819213 | 2021-05-11 04:20:41 | Tochigi, Japan | ||
1551973 | 1551973 | 2021-05-08 | Japan | Aomori | 1768 | 26 | 1423 | 319 | 40.781541 | 140.828896 | 2021-05-09 04:20:35 | Aomori, Japan | ||
891796 | 891796 | 2021-04-26 | Malaysia | Melaka | 7196 | 22 | 6855 | 319 | 2.1896 | 102.2501 | 2021-04-27 04:20:52 | Melaka, Malaysia | ||
1568115 | 1568115 | 2021-04-22 | Japan | Gunma | 5602 | 102 | 5181 | 319 | 36.504479 | 138.985605 | 2021-04-23 04:20:52 | Gunma, Japan | ||
3129528 | 3129528 | 2021-04-18 | Japan | Fukushima | 2985 | 118 | 2548 | 319 | 37.378867 | 140.223295 | 2021-04-19 04:20:57 | Fukushima, Japan | ||
170251 | 170251 | 2021-04-16 | Russia | Kemerovo Oblast | 34155 | 642 | 33194 | 319 | 54.53357809999999 | 87.342861 | 2021-04-17 04:20:40 | Kemerovo Oblast, Russia | ||
388505 | 388505 | 2021-04-04 | South Sudan | 10267 | 113 | 9835 | 319 | 6.877000000000002 | 31.307 | 2021-04-05 04:20:35 | South Sudan | |||
641600 | 641600 | 2021-03-31 | Malaysia | Melaka | 6537 | 22 | 6196 | 319 | 2.1896 | 102.2501 | 2021-04-01 04:27:05 | Melaka, Malaysia | ||
1290248 | 1290248 | 2021-03-29 | Russia | Sakhalin Oblast | 21985 | 39 | 21627 | 319 | 49.7219665 | 143.448533 | 2021-03-30 04:26:23 | Sakhalin Oblast, Russia | ||
1219640 | 1219640 | 2021-03-27 | Mauritania | 17756 | 448 | 16989 | 319 | 21.0079 | -10.9408 | 2021-03-28 05:28:10 | Mauritania | |||
1219470 | 1219470 | 2021-03-27 | France | Wallis and Futuna | 367 | 4 | 44 | 319 | -14.2938 | -178.1165 | 2021-03-28 05:28:10 | Wallis and Futuna, France | ||
2211287 | 2211287 | 2021-03-04 | Ukraine | Sevastopol* | 12176 | 506 | 11351 | 319 | 44.6054 | 33.522 | 2021-03-05 05:26:29 | Sevastopol*, Ukraine | ||
1090719 | 1090719 | 2021-03-03 | US | Colorado | Saguache | 8109 | 329 | 4 | 0 | 319 | 38.08054629 | -106.282466 | 2021-03-04 05:24:24 | Saguache, Colorado, US |
3254791 | 3254791 | 2021-03-02 | US | Colorado | Saguache | 8109 | 329 | 4 | 0 | 319 | 38.08054629 | -106.282466 | 2021-03-03 05:23:28 | Saguache, Colorado, US |
3254575 | 3254575 | 2021-03-02 | US | Alaska | Sitka | 2220 | 319 | 0 | 0 | 319 | 57.24124555 | -135.3206587 | 2021-03-03 05:23:28 | Sitka, Alaska, US |
3068762 | 3068762 | 2021-02-27 | US | Puerto Rico | Rincon | 72117 | 319 | 0 | 0 | 319 | 18.335443 | -67.23174 | 2021-02-28 05:22:20 | Rincon, Puerto Rico, US |
1936658 | 1936658 | 2021-02-23 | Russia | Kemerovo Oblast | 31307 | 553 | 30435 | 319 | 54.53357809999999 | 87.342861 | 2021-02-24 05:29:16 | Kemerovo Oblast, Russia | ||
3601476 | 3601476 | 2021-02-17 | US | Alaska | Yukon-Koyukuk | 2290 | 323 | 4 | 0 | 319 | 65.50815459 | -151.3907387 | 2021-02-18 05:22:58 | Yukon-Koyukuk, Alaska, US |
3050813 | 3050813 | 2021-02-16 | US | Colorado | Phillips | 8095 | 354 | 13 | 0 | 319 | 40.59414277 | -102.3577703 | 2021-02-17 05:23:10 | Phillips, Colorado, US |
1341046 | 1341046 | 2021-02-15 | US | Puerto Rico | Santa Isabel | 72133 | 319 | 0 | 0 | 319 | 17.994525 | -66.388913 | 2021-02-16 05:24:38 | Santa Isabel, Puerto Rico, US |
1338912 | 1338912 | 2021-02-15 | US | Colorado | Phillips | 8095 | 354 | 13 | 0 | 319 | 40.59414277 | -102.3577703 | 2021-02-16 05:24:38 | Phillips, Colorado, US |
3542353 | 3542353 | 2021-02-12 | US | South Dakota | Stanley | 46117 | 321 | 2 | 0 | 319 | 44.41381872 | -100.7349153 | 2021-02-13 05:22:12 | Stanley, South Dakota, US |
2640616 | 2640616 | 2021-02-11 | US | South Dakota | Stanley | 46117 | 321 | 2 | 0 | 319 | 44.41381872 | -100.7349153 | 2021-02-12 05:23:29 | Stanley, South Dakota, US |
2639063 | 2639063 | 2021-02-11 | US | Kansas | Stafford | 20185 | 328 | 9 | 0 | 319 | 38.03100851 | -98.71762001 | 2021-02-12 05:23:29 | Stafford, Kansas, US |
3982018 | 3982018 | 2021-02-10 | US | Washington | Lincoln | 53043 | 324 | 5 | 0 | 319 | 47.57705241 | -118.4194388 | 2021-02-11 05:23:55 | Lincoln, Washington, US |
3981471 | 3981471 | 2021-02-10 | US | South Dakota | Stanley | 46117 | 321 | 2 | 0 | 319 | 44.41381872 | -100.7349153 | 2021-02-11 05:23:55 | Stanley, South Dakota, US |
3979918 | 3979918 | 2021-02-10 | US | Kansas | Stafford | 20185 | 328 | 9 | 0 | 319 | 38.03100851 | -98.71762001 | 2021-02-11 05:23:55 | Stafford, Kansas, US |
3979214 | 3979214 | 2021-02-10 | US | Colorado | Phillips | 8095 | 351 | 13 | 0 | 319 | 40.59414277 | -102.3577703 | 2021-02-11 05:23:55 | Phillips, Colorado, US |
1531338 | 1531338 | 2021-02-09 | US | Washington | Lincoln | 53043 | 324 | 5 | 0 | 319 | 47.57705241 | -118.4194388 | 2021-02-10 05:22:41 | Lincoln, Washington, US |
1529255 | 1529255 | 2021-02-09 | US | Kentucky | Ballard | 21007 | 324 | 5 | 0 | 319 | 37.05842757 | -88.99427697 | 2021-02-10 05:22:41 | Ballard, Kentucky, US |
1528320 | 1528320 | 2021-02-09 | US | Alaska | Nome | 2180 | 319 | 0 | 0 | 319 | 64.90320724 | -164.0353804 | 2021-02-10 05:22:41 | Nome, Alaska, US |
1673442 | 1673442 | 2021-02-07 | US | Illinois | Hardin | 17069 | 329 | 10 | 0 | 319 | 37.51810645 | -88.26873022 | 2021-02-08 05:22:39 | Hardin, Illinois, US |
1590364 | 1590364 | 2021-02-05 | US | New Mexico | Hidalgo | 35023 | 328 | 9 | 0 | 319 | 31.91383467 | -108.7151824 | 2021-02-06 05:23:55 | Hidalgo, New Mexico, US |
793448 | 793448 | 2021-02-04 | US | Texas | Donley | 48129 | 423 | 12 | 0 | 319 | 34.96517499 | -100.8140093 | 2021-02-05 05:22:38 | Donley, Texas, US |
792571 | 792571 | 2021-02-04 | US | New Mexico | Hidalgo | 35023 | 328 | 9 | 0 | 319 | 31.91383467 | -108.7151824 | 2021-02-05 05:22:38 | Hidalgo, New Mexico, US |
792131 | 792131 | 2021-02-04 | US | Minnesota | Red Lake | 27125 | 323 | 4 | 0 | 319 | 47.87197525 | -96.09561104 | 2021-02-05 05:22:38 | Red Lake, Minnesota, US |
343340 | 343340 | 2021-02-03 | US | Texas | Donley | 48129 | 423 | 12 | 0 | 319 | 34.96517499 | -100.8140093 | 2021-02-04 05:22:26 | Donley, Texas, US |
342023 | 342023 | 2021-02-03 | US | Minnesota | Red Lake | 27125 | 323 | 4 | 0 | 319 | 47.87197525 | -96.09561104 | 2021-02-04 05:22:26 | Red Lake, Minnesota, US |
1686249 | 1686249 | 2021-02-02 | US | Minnesota | Red Lake | 27125 | 323 | 4 | 0 | 319 | 47.87197525 | -96.09561104 | 2021-02-03 05:22:52 | Red Lake, Minnesota, US |
1679877 | 1679877 | 2021-02-01 | US | Virginia | Surry | 51181 | 324 | 5 | 0 | 319 | 37.11781893 | -76.88450012 | 2021-02-02 05:22:49 | Surry, Virginia, US |
1463165 | 1463165 | 2021-01-31 | US | Virginia | Surry | 51181 | 324 | 5 | 0 | 319 | 37.11781893 | -76.88450012 | 2021-02-01 05:22:53 | Surry, Virginia, US |
1461507 | 1461507 | 2021-01-31 | US | Minnesota | Red Lake | 27125 | 323 | 4 | 0 | 319 | 47.87197525 | -96.09561104 | 2021-02-01 05:22:53 | Red Lake, Minnesota, US |
2215073 | 2215073 | 2021-01-30 | US | Virginia | Surry | 51181 | 324 | 5 | 0 | 319 | 37.11781893 | -76.88450012 | 2021-01-31 05:22:42 | Surry, Virginia, US |
2214939 | 2214939 | 2021-01-30 | US | Vermont | Caledonia | 50005 | 323 | 4 | 0 | 319 | 44.46548598 | -72.10314651 | 2021-01-31 05:22:42 | Caledonia, Vermont, US |
2214803 | 2214803 | 2021-01-30 | US | Texas | Kinney | 48271 | 375 | 3 | 0 | 319 | 29.34967888 | -100.4186638 | 2021-01-31 05:22:42 | Kinney, Texas, US |
2211866 | 2211866 | 2021-01-30 | Russia | Jewish Autonomous Okrug | 4161 | 106 | 3736 | 319 | 48.57527615 | 132.66307460000002 | 2021-01-31 05:22:42 | Jewish Autonomous Okrug, Russia | ||
1900560 | 1900560 | 2021-01-29 | US | Virginia | Surry | 51181 | 324 | 5 | 0 | 319 | 37.11781893 | -76.88450012 | 2021-01-30 05:22:49 | Surry, Virginia, US |
2485069 | 2485069 | 2021-01-28 | US | Texas | Hardeman | 48197 | 323 | 12 | 0 | 319 | 34.28944521 | -99.74632408 | 2021-01-29 05:22:23 | Hardeman, Texas, US |
15853 | 15853 | 2021-01-26 | US | West Virginia | Wirt | 54105 | 320 | 1 | 0 | 319 | 39.02775007 | -81.37473928 | 2021-01-27 05:23:41 | Wirt, West Virginia, US |
15647 | 15647 | 2021-01-26 | US | Virginia | Charles City | 51036 | 328 | 9 | 0 | 319 | 37.35358063 | -77.05634116 | 2021-01-27 05:23:41 | Charles City, Virginia, US |
15200 | 15200 | 2021-01-26 | US | South Dakota | Faulk | 46049 | 332 | 13 | 0 | 319 | 45.07082625 | -99.14535601 | 2021-01-27 05:23:41 | Faulk, South Dakota, US |
2429508 | 2429508 | 2021-01-23 | US | Oregon | Curry | 41015 | 324 | 5 | 0 | 319 | 42.45911325 | -124.157282 | 2021-01-24 05:22:35 | Curry, Oregon, US |
2426737 | 2426737 | 2021-01-23 | Colombia | Arauca | 5187 | 149 | 4719 | 319 | 7.0762 | -70.7105 | 2021-01-24 05:22:35 | Arauca, Colombia | ||
2469410 | 2469410 | 2021-01-22 | US | Oregon | Curry | 41015 | 324 | 5 | 0 | 319 | 42.45911325 | -124.157282 | 2021-01-23 05:22:03 | Curry, Oregon, US |
2467714 | 2467714 | 2021-01-22 | US | Idaho | Bear Lake | 16007 | 321 | 2 | 0 | 319 | 42.28269683 | -111.32892379999998 | 2021-01-23 05:22:03 | Bear Lake, Idaho, US |
437022 | 437022 | 2021-01-21 | US | Michigan | Ontonagon | 26131 | 336 | 17 | 0 | 319 | 46.665226200000006 | -89.31390481 | 2021-01-22 05:22:10 | Ontonagon, Michigan, US |
910782 | 910782 | 2021-01-19 | US | Oregon | Curry | 41015 | 324 | 5 | 0 | 319 | 42.45911325 | -124.157282 | 2021-01-20 05:21:54 | Curry, Oregon, US |
909436 | 909436 | 2021-01-19 | US | Kansas | Cheyenne | 20023 | 330 | 11 | 0 | 319 | 39.78580976 | -101.7318201 | 2021-01-20 05:21:54 | Cheyenne, Kansas, US |
240273 | 240273 | 2021-01-18 | US | Texas | Carson | 48065 | 600 | 11 | 0 | 319 | 35.40365929 | -101.3542669 | 2021-01-19 05:22:15 | Carson, Texas, US |
239845 | 239845 | 2021-01-18 | US | Oregon | Curry | 41015 | 324 | 5 | 0 | 319 | 42.45911325 | -124.157282 | 2021-01-19 05:22:15 | Curry, Oregon, US |
239262 | 239262 | 2021-01-18 | US | Montana | Sweet Grass | 30097 | 325 | 6 | 0 | 319 | 45.81367654 | -109.9425686 | 2021-01-19 05:22:15 | Sweet Grass, Montana, US |
238499 | 238499 | 2021-01-18 | US | Kansas | Cheyenne | 20023 | 330 | 11 | 0 | 319 | 39.78580976 | -101.7318201 | 2021-01-19 05:22:15 | Cheyenne, Kansas, US |
3506390 | 3506390 | 2021-01-17 | US | Texas | Carson | 48065 | 600 | 11 | 0 | 319 | 35.40365929 | -101.3542669 | 2021-01-18 05:22:34 | Carson, Texas, US |
3505962 | 3505962 | 2021-01-17 | US | Oregon | Curry | 41015 | 324 | 5 | 0 | 319 | 42.45911325 | -124.157282 | 2021-01-18 05:22:34 | Curry, Oregon, US |
3505379 | 3505379 | 2021-01-17 | US | Montana | Sweet Grass | 30097 | 325 | 6 | 0 | 319 | 45.81367654 | -109.9425686 | 2021-01-18 05:22:34 | Sweet Grass, Montana, US |
3104473 | 3104473 | 2021-01-16 | US | Texas | Carson | 48065 | 600 | 11 | 0 | 319 | 35.40365929 | -101.3542669 | 2021-01-17 05:22:17 | Carson, Texas, US |
3103574 | 3103574 | 2021-01-16 | US | Nevada | Lincoln | 32017 | 320 | 1 | 0 | 319 | 37.64268459 | -114.8790388 | 2021-01-17 05:22:17 | Lincoln, Nevada, US |
3103462 | 3103462 | 2021-01-16 | US | Montana | Sweet Grass | 30097 | 325 | 6 | 0 | 319 | 45.81367654 | -109.9425686 | 2021-01-17 05:22:17 | Sweet Grass, Montana, US |
3518768 | 3518768 | 2021-01-15 | US | Virginia | Middlesex | 51119 | 332 | 13 | 0 | 319 | 37.63191998 | -76.55064617 | 2021-01-16 05:22:40 | Middlesex, Virginia, US |
3517424 | 3517424 | 2021-01-15 | US | Montana | Sweet Grass | 30097 | 325 | 6 | 0 | 319 | 45.81367654 | -109.9425686 | 2021-01-16 05:22:40 | Sweet Grass, Montana, US |
3882477 | 3882477 | 2021-01-14 | US | South Dakota | Ziebach | 46137 | 327 | 8 | 0 | 319 | 44.97881876 | -101.6654622 | 2021-01-15 05:22:24 | Ziebach, South Dakota, US |
3881596 | 3881596 | 2021-01-14 | US | Montana | Sweet Grass | 30097 | 325 | 6 | 0 | 319 | 45.81367654 | -109.9425686 | 2021-01-15 05:22:24 | Sweet Grass, Montana, US |
3881528 | 3881528 | 2021-01-14 | US | Missouri | Shelby | 29205 | 323 | 4 | 0 | 319 | 39.79742518 | -92.07634971 | 2021-01-15 05:22:24 | Shelby, Missouri, US |
3881216 | 3881216 | 2021-01-14 | US | Michigan | Lake | 26085 | 329 | 10 | 0 | 319 | 43.99050893 | -85.802173 | 2021-01-15 05:22:24 | Lake, Michigan, US |
3310968 | 3310968 | 2021-01-13 | US | Puerto Rico | San German | 72125 | 319 | 0 | 0 | 319 | 18.111484 | -67.03858100000001 | 2021-01-14 05:22:32 | San German, Puerto Rico, US |
3310296 | 3310296 | 2021-01-13 | US | Nebraska | Nuckolls | 31129 | 320 | 1 | 0 | 319 | 40.17637905 | -98.04743961 | 2021-01-14 05:22:32 | Nuckolls, Nebraska, US |
3310223 | 3310223 | 2021-01-13 | US | Montana | Sweet Grass | 30097 | 325 | 6 | 0 | 319 | 45.81367654 | -109.9425686 | 2021-01-14 05:22:32 | Sweet Grass, Montana, US |
777501 | 777501 | 2021-01-12 | US | Texas | Marion | 48315 | 420 | 19 | 0 | 319 | 32.79868409 | -94.3566123 | 2021-01-13 05:22:15 | Marion, Texas, US |
777113 | 777113 | 2021-01-12 | US | Puerto Rico | San German | 72125 | 319 | 0 | 0 | 319 | 18.111484 | -67.03858100000001 | 2021-01-13 05:22:15 | San German, Puerto Rico, US |
192933 | 192933 | 2021-01-11 | US | South Dakota | Hanson | 46061 | 322 | 3 | 0 | 319 | 43.6746384 | -97.78715148 | 2021-01-12 05:22:15 | Hanson, South Dakota, US |
192608 | 192608 | 2021-01-11 | US | Oklahoma | Ellis | 40045 | 320 | 1 | 0 | 319 | 36.2180194 | -99.75324573 | 2021-01-12 05:22:15 | Ellis, Oklahoma, US |
192447 | 192447 | 2021-01-11 | US | North Dakota | Bowman | 38011 | 323 | 4 | 0 | 319 | 46.11285362 | -103.5203343 | 2021-01-12 05:22:15 | Bowman, North Dakota, US |
2628411 | 2628411 | 2021-01-10 | US | Oklahoma | Ellis | 40045 | 320 | 1 | 0 | 319 | 36.2180194 | -99.75324573 | 2021-01-11 05:21:50 | Ellis, Oklahoma, US |
2627150 | 2627150 | 2021-01-10 | US | Kansas | Gove | 20063 | 341 | 22 | 0 | 319 | 38.91588178 | -100.4829321 | 2021-01-11 05:21:50 | Gove, Kansas, US |
3901238 | 3901238 | 2021-01-09 | US | Kansas | Gove | 20063 | 341 | 22 | 0 | 319 | 38.91588178 | -100.4829321 | 2021-01-10 05:22:12 | Gove, Kansas, 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]);