johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
436 rows where active = 526 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 371
- Japan 7
- Lesotho 7
- Russia 6
- Ukraine 5
- Lebanon 4
- Mexico 4
- Equatorial Guinea 3
- Cabo Verde 2
- Chile 2
- Guinea 2
- Malaysia 2
- Mauritius 2
- Azerbaijan 1
- Burkina Faso 1
- Canada 1
- Colombia 1
- Cuba 1
- France 1
- Guinea-Bissau 1
- Kenya 1
- Lithuania 1
- Mali 1
- San Marino 1
- Seychelles 1
- Spain 1
- Sri Lanka 1
- Suriname 1
- Sweden 1
- Togo 1
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3385156 | 3385156 | 2021-07-29 | Canada | Manitoba | 57548 | 1177 | 55845 | 526 | 53.7609 | -98.8139 | 2021-07-30 04:21:34 | Manitoba, Canada | ||
3137564 | 3137564 | 2021-07-23 | Japan | Ibaraki | 11418 | 166 | 10726 | 526 | 36.303588 | 140.319591 | 2021-07-24 00:21:36 | Ibaraki, Japan | ||
483350 | 483350 | 2021-07-19 | Cabo Verde | 33317 | 295 | 32496 | 526 | 16.5388 | -23.0418 | 2021-07-20 04:21:48 | Cabo Verde | |||
296350 | 296350 | 2021-07-15 | Togo | 14426 | 134 | 13766 | 526 | 8.6195 | 0.8248 | 2021-07-16 04:21:22 | Togo | |||
778435 | 778435 | 2021-07-08 | Mauritius | 2078 | 18 | 1534 | 526 | -20.348404 | 57.552152 | 2021-07-09 04:21:21 | Mauritius | |||
1440657 | 1440657 | 2021-07-07 | Mauritius | 2078 | 18 | 1534 | 526 | -20.348404 | 57.552152 | 2021-07-08 04:21:26 | Mauritius | |||
2295639 | 2295639 | 2021-06-24 | Russia | Astrakhan Oblast | 35367 | 834 | 34007 | 526 | 47.1878186 | 47.608851 | 2021-06-25 04:21:33 | Astrakhan Oblast, Russia | ||
3362303 | 3362303 | 2021-06-21 | Ukraine | Mykolaiv Oblast | 69757 | 1833 | 67398 | 526 | 46.975 | 31.9946 | 2021-06-22 04:21:34 | Mykolaiv Oblast, Ukraine | ||
2888005 | 2888005 | 2021-06-20 | Ukraine | Rivne Oblast | 79324 | 1204 | 77594 | 526 | 50.6199 | 26.2516 | 2021-06-21 04:21:41 | Rivne Oblast, Ukraine | ||
1771379 | 1771379 | 2021-05-23 | Japan | Shiga | 4792 | 75 | 4191 | 526 | 35.21582700000001 | 136.138064 | 2021-05-24 04:20:53 | Shiga, Japan | ||
1873003 | 1873003 | 2021-05-15 | Japan | Yamaguchi | 2386 | 51 | 1809 | 526 | 34.201190000000004 | 131.573293 | 2021-05-16 04:20:49 | Yamaguchi, Japan | ||
3675859 | 3675859 | 2021-05-04 | Russia | Kemerovo Oblast | 35356 | 672 | 34158 | 526 | 54.53357809999999 | 87.342861 | 2021-05-05 04:20:43 | Kemerovo Oblast, Russia | ||
2828463 | 2828463 | 2021-05-01 | Malaysia | Pahang | 5228 | 19 | 4683 | 526 | 3.8126 | 103.3256 | 2021-05-02 04:20:48 | Pahang, Malaysia | ||
380215 | 380215 | 2021-04-30 | Japan | Mie | 3765 | 81 | 3158 | 526 | 34.508018 | 136.376013 | 2021-05-01 04:20:47 | Mie, Japan | ||
1302321 | 1302321 | 2021-04-01 | San Marino | 4738 | 84 | 4128 | 526 | 43.9424 | 12.4578 | 2021-04-02 04:20:36 | San Marino | |||
1881231 | 1881231 | 2021-03-26 | Russia | Smolensk Oblast | 27920 | 745 | 26649 | 526 | 55.03434960000001 | 33.0192065 | 2021-03-27 05:25:04 | Smolensk Oblast, Russia | ||
1980890 | 1980890 | 2021-03-25 | Seychelles | 3862 | 18 | 3318 | 526 | -4.6796 | 55.492 | 2021-03-26 05:26:55 | Seychelles | |||
1980400 | 1980400 | 2021-03-25 | Chile | Atacama | 13810 | 168 | 13116 | 526 | -27.5661 | -70.0503 | 2021-03-26 05:26:55 | Atacama, Chile | ||
2055768 | 2055768 | 2021-03-15 | Equatorial Guinea | 6562 | 98 | 5938 | 526 | 1.6508 | 10.2679 | 2021-03-16 05:25:13 | Equatorial Guinea | |||
1732380 | 1732380 | 2021-03-14 | Equatorial Guinea | 6562 | 98 | 5938 | 526 | 1.6508 | 10.2679 | 2021-03-15 05:25:51 | Equatorial Guinea | |||
1580037 | 1580037 | 2021-03-13 | Equatorial Guinea | 6562 | 98 | 5938 | 526 | 1.6508 | 10.2679 | 2021-03-14 05:25:37 | Equatorial Guinea | |||
3670481 | 3670481 | 2021-03-06 | US | South Dakota | Fall River | 46047 | 541 | 15 | 0 | 526 | 43.23929297 | -103.5275691 | 2021-03-07 05:21:54 | Fall River, South Dakota, US |
3667628 | 3667628 | 2021-03-06 | Japan | Fukuoka | 18225 | 303 | 17396 | 526 | 33.526032 | 130.666949 | 2021-03-07 05:21:54 | Fukuoka, Japan | ||
1619102 | 1619102 | 2021-03-05 | US | South Dakota | Fall River | 46047 | 541 | 15 | 0 | 526 | 43.23929297 | -103.5275691 | 2021-03-06 04:23:41 | Fall River, South Dakota, US |
3255259 | 3255259 | 2021-03-02 | US | Indiana | Ohio | 18115 | 537 | 11 | 0 | 526 | 38.955305 | -84.96515993 | 2021-03-03 05:23:28 | Ohio, Indiana, US |
1001599 | 1001599 | 2021-03-01 | US | Texas | McCulloch | 48307 | 518 | 15 | 0 | 526 | 31.1925468 | -99.34682807 | 2021-03-02 05:23:30 | McCulloch, Texas, US |
999551 | 999551 | 2021-03-01 | US | Indiana | Ohio | 18115 | 537 | 11 | 0 | 526 | 38.955305 | -84.96515993 | 2021-03-02 05:23:30 | Ohio, Indiana, US |
999059 | 999059 | 2021-03-01 | US | Colorado | Kit Carson | 8063 | 557 | 11 | 0 | 526 | 39.30497777 | -102.6022199 | 2021-03-02 05:23:30 | Kit Carson, Colorado, US |
2370657 | 2370657 | 2021-02-28 | US | Texas | McCulloch | 48307 | 518 | 15 | 0 | 526 | 31.1925468 | -99.34682807 | 2021-03-01 05:23:01 | McCulloch, Texas, US |
2367986 | 2367986 | 2021-02-28 | US | Arkansas | Lafayette | 5073 | 534 | 8 | 0 | 526 | 33.24116713 | -93.60677071 | 2021-03-01 05:23:01 | Lafayette, Arkansas, US |
3069159 | 3069159 | 2021-02-27 | US | Texas | McCulloch | 48307 | 518 | 15 | 0 | 526 | 31.1925468 | -99.34682807 | 2021-02-28 05:22:20 | McCulloch, Texas, US |
2186123 | 2186123 | 2021-02-26 | US | Oklahoma | Dewey | 40043 | 532 | 6 | 0 | 526 | 35.98772922 | -99.00730714 | 2021-02-27 05:22:28 | Dewey, Oklahoma, US |
2183932 | 2183932 | 2021-02-26 | US | Alabama | Choctaw | 1023 | 549 | 23 | 0 | 526 | 32.02227341 | -88.26564429999998 | 2021-02-27 05:22:28 | Choctaw, Alabama, US |
282728 | 282728 | 2021-02-24 | US | Oklahoma | Grant | 40053 | 533 | 7 | 0 | 526 | 36.796297 | -97.78638765 | 2021-02-25 05:24:57 | Grant, Oklahoma, US |
1938996 | 1938996 | 2021-02-23 | US | Oklahoma | Grant | 40053 | 533 | 7 | 0 | 526 | 36.796297 | -97.78638765 | 2021-02-24 05:29:16 | Grant, Oklahoma, US |
532625 | 532625 | 2021-02-22 | US | Missouri | Maries | 29125 | 533 | 7 | 0 | 526 | 38.16193985 | -91.92249662 | 2021-02-23 05:23:41 | Maries, Missouri, US |
183959 | 183959 | 2021-02-21 | US | Missouri | Maries | 29125 | 533 | 7 | 0 | 526 | 38.16193985 | -91.92249662 | 2021-02-22 05:24:21 | Maries, Missouri, US |
744233 | 744233 | 2021-02-20 | US | Missouri | Maries | 29125 | 533 | 7 | 0 | 526 | 38.16193985 | -91.92249662 | 2021-02-21 05:24:33 | Maries, Missouri, US |
473331 | 473331 | 2021-02-19 | US | Missouri | Maries | 29125 | 533 | 7 | 0 | 526 | 38.16193985 | -91.92249662 | 2021-02-20 05:22:51 | Maries, Missouri, US |
471341 | 471341 | 2021-02-19 | Guinea-Bissau | 3064 | 46 | 2492 | 526 | 11.8037 | -15.1804 | 2021-02-20 05:22:51 | Guinea-Bissau | |||
3603785 | 3603785 | 2021-02-17 | US | Puerto Rico | Lares | 72081 | 526 | 0 | 0 | 526 | 18.269035 | -66.867236 | 2021-02-18 05:22:58 | Lares, Puerto Rico, US |
1340563 | 1340563 | 2021-02-15 | US | North Carolina | Camden | 37029 | 531 | 5 | 0 | 526 | 36.33804939 | -76.15568396 | 2021-02-16 05:24:38 | Camden, North Carolina, US |
3540633 | 3540633 | 2021-02-12 | US | Iowa | Decatur | 19053 | 534 | 8 | 0 | 526 | 40.73742757 | -93.78645949 | 2021-02-13 05:22:12 | Decatur, Iowa, US |
2639637 | 2639637 | 2021-02-11 | US | Missouri | Linn | 29115 | 537 | 11 | 0 | 526 | 39.87001769 | -93.10704106 | 2021-02-12 05:23:29 | Linn, Missouri, US |
1530287 | 1530287 | 2021-02-09 | US | North Dakota | Foster | 38031 | 547 | 19 | 0 | 526 | 47.4571084 | -98.88279923 | 2021-02-10 05:22:41 | Foster, North Dakota, US |
1529812 | 1529812 | 2021-02-09 | US | Missouri | Linn | 29115 | 536 | 10 | 0 | 526 | 39.87001769 | -93.10704106 | 2021-02-10 05:22:41 | Linn, Missouri, US |
1528652 | 1528652 | 2021-02-09 | US | Georgia | Calhoun | 13037 | 539 | 13 | 0 | 526 | 31.53169785 | -84.62725131 | 2021-02-10 05:22:41 | Calhoun, Georgia, US |
1674768 | 1674768 | 2021-02-07 | US | North Carolina | Graham | 37075 | 538 | 12 | 0 | 526 | 35.3506925 | -83.83369267 | 2021-02-08 05:22:39 | Graham, North Carolina, US |
1673776 | 1673776 | 2021-02-07 | US | Kansas | Ottawa | 20143 | 537 | 11 | 0 | 526 | 39.13237408 | -97.65020313 | 2021-02-08 05:22:39 | Ottawa, Kansas, US |
977684 | 977684 | 2021-02-06 | US | Puerto Rico | Salinas | 72123 | 526 | 0 | 0 | 526 | 18.010386999999994 | -66.256592 | 2021-02-07 05:23:00 | Salinas, Puerto Rico, US |
977229 | 977229 | 2021-02-06 | US | North Carolina | Graham | 37075 | 538 | 12 | 0 | 526 | 35.3506925 | -83.83369267 | 2021-02-07 05:23:00 | Graham, North Carolina, US |
976852 | 976852 | 2021-02-06 | US | Missouri | Ozark | 29153 | 537 | 11 | 0 | 526 | 36.64916339 | -92.44459066 | 2021-02-07 05:23:00 | Ozark, Missouri, US |
976237 | 976237 | 2021-02-06 | US | Kansas | Ottawa | 20143 | 537 | 11 | 0 | 526 | 39.13237408 | -97.65020313 | 2021-02-07 05:23:00 | Ottawa, Kansas, US |
1590487 | 1590487 | 2021-02-05 | US | North Carolina | Graham | 37075 | 538 | 12 | 0 | 526 | 35.3506925 | -83.83369267 | 2021-02-06 05:23:55 | Graham, North Carolina, US |
1589495 | 1589495 | 2021-02-05 | US | Kansas | Ottawa | 20143 | 537 | 11 | 0 | 526 | 39.13237408 | -97.65020313 | 2021-02-06 05:23:55 | Ottawa, Kansas, US |
343328 | 343328 | 2021-02-03 | US | Texas | Crockett | 48105 | 397 | 15 | 0 | 526 | 30.72367027 | -101.4134238 | 2021-02-04 05:22:26 | Crockett, Texas, US |
341132 | 341132 | 2021-02-03 | US | Georgia | Randolph | 13243 | 557 | 31 | 0 | 526 | 31.76622818 | -84.75732369 | 2021-02-04 05:22:26 | Randolph, Georgia, US |
1677937 | 1677937 | 2021-02-01 | US | Kentucky | Trimble | 21223 | 529 | 3 | 0 | 526 | 38.61056487 | -85.33775972 | 2021-02-02 05:22:49 | Trimble, Kentucky, US |
1677654 | 1677654 | 2021-02-01 | US | Iowa | Fremont | 19071 | 534 | 8 | 0 | 526 | 40.74542720000001 | -95.60129045 | 2021-02-02 05:22:49 | Fremont, Iowa, US |
1900475 | 1900475 | 2021-01-29 | US | Virginia | Emporia | 51595 | 558 | 32 | 0 | 526 | 36.69455571 | -77.53406129 | 2021-01-30 05:22:49 | Emporia, Virginia, US |
2485094 | 2485094 | 2021-01-28 | US | Texas | Jim Hogg | 48247 | 618 | 13 | 0 | 526 | 27.04453923 | -98.6968187 | 2021-01-29 05:22:23 | Jim Hogg, Texas, US |
2481990 | 2481990 | 2021-01-28 | Japan | Kumamoto | 3299 | 59 | 2714 | 526 | 32.608154 | 130.74523100000002 | 2021-01-29 05:22:23 | Kumamoto, Japan | ||
3155995 | 3155995 | 2021-01-27 | US | North Dakota | Foster | 38031 | 543 | 19 | 0 | 526 | 47.4571084 | -98.88279923 | 2021-01-28 05:22:24 | Foster, North Dakota, US |
1760605 | 1760605 | 2021-01-24 | US | Kansas | Mitchell | 20123 | 533 | 7 | 0 | 526 | 39.39331582 | -98.20906732 | 2021-01-25 05:22:16 | Mitchell, Kansas, US |
2428212 | 2428212 | 2021-01-23 | US | Kansas | Mitchell | 20123 | 533 | 7 | 0 | 526 | 39.39331582 | -98.20906732 | 2021-01-24 05:22:35 | Mitchell, Kansas, US |
2470163 | 2470163 | 2021-01-22 | US | Virginia | Lunenburg | 51111 | 529 | 3 | 0 | 526 | 36.94618528 | -78.24133319 | 2021-01-23 05:22:03 | Lunenburg, Virginia, US |
2468823 | 2468823 | 2021-01-22 | US | Montana | Sanders | 30089 | 531 | 5 | 0 | 526 | 47.67657534 | -115.1329916 | 2021-01-23 05:22:03 | Sanders, Montana, US |
2468114 | 2468114 | 2021-01-22 | US | Kansas | Mitchell | 20123 | 533 | 7 | 0 | 526 | 39.39331582 | -98.20906732 | 2021-01-23 05:22:03 | Mitchell, Kansas, US |
436642 | 436642 | 2021-01-21 | US | Kansas | Harper | 20077 | 545 | 19 | 0 | 526 | 37.19175361 | -98.07578384 | 2021-01-22 05:22:10 | Harper, Kansas, US |
1095373 | 1095373 | 2021-01-20 | US | Kansas | Harper | 20077 | 545 | 19 | 0 | 526 | 37.19175361 | -98.07578384 | 2021-01-21 05:22:01 | Harper, Kansas, US |
1094967 | 1094967 | 2021-01-20 | US | Georgia | Twiggs | 13289 | 550 | 24 | 0 | 526 | 32.67435595 | -83.43078662 | 2021-01-21 05:22:01 | Twiggs, Georgia, US |
910195 | 910195 | 2021-01-19 | US | Montana | Sanders | 30089 | 531 | 5 | 0 | 526 | 47.67657534 | -115.1329916 | 2021-01-20 05:21:54 | Sanders, Montana, US |
240844 | 240844 | 2021-01-18 | US | Wyoming | Platte | 56031 | 535 | 9 | 0 | 526 | 42.13299116 | -104.966331 | 2021-01-19 05:22:15 | Platte, Wyoming, US |
239258 | 239258 | 2021-01-18 | US | Montana | Sanders | 30089 | 531 | 5 | 0 | 526 | 47.67657534 | -115.1329916 | 2021-01-19 05:22:15 | Sanders, Montana, US |
3506827 | 3506827 | 2021-01-17 | US | West Virginia | Gilmer | 54021 | 532 | 6 | 0 | 526 | 38.9251277 | -80.85952723 | 2021-01-18 05:22:34 | Gilmer, West Virginia, US |
3506137 | 3506137 | 2021-01-17 | US | Puerto Rico | Villalba | 72149 | 526 | 0 | 0 | 526 | 18.127951 | -66.473115 | 2021-01-18 05:22:34 | Villalba, Puerto Rico, US |
3103735 | 3103735 | 2021-01-16 | US | North Carolina | Clay | 37043 | 531 | 5 | 0 | 526 | 35.05704275 | -83.74353633 | 2021-01-17 05:22:17 | Clay, North Carolina, US |
3102331 | 3102331 | 2021-01-16 | US | Georgia | Wheeler | 13309 | 546 | 20 | 0 | 526 | 32.12009104 | -82.72574721 | 2021-01-17 05:22:17 | Wheeler, Georgia, US |
3881668 | 3881668 | 2021-01-14 | US | Nebraska | Nemaha | 31127 | 538 | 12 | 0 | 526 | 40.38514847 | -95.85433992 | 2021-01-15 05:22:24 | Nemaha, Nebraska, US |
776745 | 776745 | 2021-01-12 | US | North Dakota | McHenry | 38049 | 542 | 19 | 0 | 526 | 48.23104458 | -100.6324822 | 2021-01-13 05:22:15 | McHenry, North Dakota, US |
776387 | 776387 | 2021-01-12 | US | Nebraska | Burt | 31021 | 536 | 10 | 0 | 526 | 41.85056773 | -96.32605633 | 2021-01-13 05:22:15 | Burt, Nebraska, US |
776273 | 776273 | 2021-01-12 | US | Missouri | Montgomery | 29139 | 535 | 9 | 0 | 526 | 38.94022054 | -91.47000721 | 2021-01-13 05:22:15 | Montgomery, Missouri, US |
193119 | 193119 | 2021-01-11 | US | Texas | Crane | 48103 | 402 | 10 | 0 | 526 | 31.43052248 | -102.5143314 | 2021-01-12 05:22:15 | Crane, Texas, US |
192108 | 192108 | 2021-01-11 | US | Nebraska | Burt | 31021 | 536 | 10 | 0 | 526 | 41.85056773 | -96.32605633 | 2021-01-12 05:22:15 | Burt, Nebraska, US |
3903255 | 3903255 | 2021-01-09 | US | Virginia | Bland | 51021 | 532 | 6 | 0 | 526 | 37.13128068 | -81.13599391 | 2021-01-10 05:22:12 | Bland, Virginia, US |
3900475 | 3900475 | 2021-01-09 | US | Arkansas | Searcy | 5129 | 539 | 13 | 0 | 526 | 35.9109364 | -92.69936482 | 2021-01-10 05:22:12 | Searcy, Arkansas, US |
157420 | 157420 | 2021-01-08 | US | Washington | Klickitat | 53039 | 529 | 3 | 0 | 526 | 45.87325839 | -120.7913598 | 2021-01-09 05:22:18 | Klickitat, Washington, US |
157265 | 157265 | 2021-01-08 | US | Vermont | Windsor | 50027 | 529 | 3 | 0 | 526 | 43.58010937 | -72.58595157 | 2021-01-09 05:22:18 | Windsor, Vermont, US |
154454 | 154454 | 2021-01-08 | US | Arkansas | Dallas | 5039 | 538 | 12 | 0 | 526 | 33.97042763 | -92.65167437 | 2021-01-09 05:22:18 | Dallas, Arkansas, US |
2543406 | 2543406 | 2021-01-07 | US | Montana | Madison | 30057 | 529 | 3 | 0 | 526 | 45.30080065 | -111.9173017 | 2021-01-08 05:22:42 | Madison, Montana, US |
2868312 | 2868312 | 2021-01-06 | US | Wyoming | Johnson | 56019 | 533 | 7 | 0 | 526 | 44.04057166 | -106.5845174 | 2021-01-07 05:22:03 | Johnson, Wyoming, US |
2866894 | 2866894 | 2021-01-06 | US | New Mexico | Colfax | 35007 | 549 | 23 | 0 | 526 | 36.60569702 | -104.64726740000002 | 2021-01-07 05:22:03 | Colfax, New Mexico, US |
3037491 | 3037491 | 2021-01-05 | US | Texas | Rains | 48379 | 283 | 18 | 0 | 526 | 32.87109387 | -95.79232691 | 2021-01-06 05:22:16 | Rains, Texas, US |
3037155 | 3037155 | 2021-01-05 | US | South Dakota | Day | 46037 | 546 | 20 | 0 | 526 | 45.367281 | -97.60737498 | 2021-01-06 05:22:16 | Day, South Dakota, US |
3037093 | 3037093 | 2021-01-05 | US | South Carolina | Allendale | 45005 | 535 | 9 | 0 | 526 | 32.98837386 | -81.35321066 | 2021-01-06 05:22:16 | Allendale, South Carolina, US |
3232375 | 3232375 | 2021-01-03 | US | Missouri | Monroe | 29137 | 531 | 5 | 0 | 526 | 39.49593978 | -92.00043978 | 2021-01-04 05:22:02 | Monroe, Missouri, US |
3697541 | 3697541 | 2020-12-31 | US | Nebraska | Dawes | 31045 | 544 | 18 | 0 | 526 | 42.71985036 | -103.1313774 | 2021-01-01 05:23:07 | Dawes, Nebraska, US |
1013641 | 1013641 | 2020-12-30 | US | Virginia | Greene | 51079 | 530 | 4 | 0 | 526 | 38.29545894 | -78.46525378 | 2020-12-31 05:22:49 | Greene, Virginia, US |
767533 | 767533 | 2020-12-29 | US | Iowa | Monona | 19133 | 541 | 15 | 0 | 526 | 42.05220391 | -95.95743843 | 2020-12-30 05:22:34 | Monona, Iowa, US |
766248 | 766248 | 2020-12-29 | Guinea | 13688 | 80 | 13082 | 526 | 9.9456 | -9.6966 | 2020-12-30 05:22:34 | Guinea |
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]);