johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
619 rows where active = 335 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 532
- Japan 11
- Colombia 10
- Russia 7
- Chile 6
- Italy 5
- Mexico 5
- Chad 4
- Germany 4
- Ukraine 4
- India 3
- Canada 2
- Gabon 2
- Malaysia 2
- Montenegro 2
- Suriname 2
- Andorra 1
- Congo (Kinshasa) 1
- Costa Rica 1
- Cyprus 1
- Estonia 1
- France 1
- Georgia 1
- Jamaica 1
- Kuwait 1
- Kyrgyzstan 1
- Lebanon 1
- Lithuania 1
- Niger 1
- Pakistan 1
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3221953 | 3221953 | 2021-07-26 | United Kingdom | Gibraltar | 4822 | 94 | 4393 | 335 | 36.1408 | -5.3536 | 2021-07-27 04:21:18 | Gibraltar, United Kingdom | ||
3218079 | 3218079 | 2021-07-26 | Chile | Antofagasta | 59519 | 1186 | 57998 | 335 | -23.6509 | -70.3975 | 2021-07-27 04:21:18 | Antofagasta, Chile | ||
2371433 | 2371433 | 2021-07-20 | Germany | Thuringen | 128966 | 4362 | 124300 | 335 | 51.011 | 10.8453 | 2021-07-21 04:21:40 | Thuringen, Germany | ||
483280 | 483280 | 2021-07-19 | Andorra | 14359 | 127 | 13897 | 335 | 42.5063 | 1.5218 | 2021-07-20 04:21:48 | Andorra | |||
3706237 | 3706237 | 2021-07-17 | Montenegro | 100622 | 1623 | 98664 | 335 | 42.708678000000006 | 19.37439 | 2021-07-18 04:22:07 | Montenegro | |||
296291 | 296291 | 2021-07-15 | Singapore | 62852 | 36 | 62481 | 335 | 1.2833 | 103.8333 | 2021-07-16 04:21:22 | Singapore | |||
295846 | 295846 | 2021-07-15 | Colombia | Arauca | 11908 | 363 | 11210 | 335 | 7.0762 | -70.7105 | 2021-07-16 04:21:22 | Arauca, Colombia | ||
2593639 | 2593639 | 2021-06-27 | Ukraine | Poltava Oblast | 77804 | 1855 | 75614 | 335 | 49.5883 | 34.5514 | 2021-06-28 04:21:29 | Poltava Oblast, Ukraine | ||
1736364 | 1736364 | 2021-06-12 | Colombia | Putumayo | 12576 | 530 | 11711 | 335 | 0.436 | -75.5277 | 2021-06-13 04:22:44 | Putumayo, Colombia | ||
825438 | 825438 | 2021-06-06 | Colombia | Putumayo | 12329 | 511 | 11483 | 335 | 0.436 | -75.5277 | 2021-06-07 04:22:51 | Putumayo, Colombia | ||
825423 | 825423 | 2021-06-06 | Colombia | Caqueta | 18653 | 695 | 17623 | 335 | 0.8699 | -73.8419 | 2021-06-07 04:22:51 | Caqueta, Colombia | ||
1913237 | 1913237 | 2021-05-20 | Japan | Nagano | 4500 | 76 | 4089 | 335 | 36.132134 | 138.045528 | 2021-05-21 04:20:43 | Nagano, Japan | ||
1872944 | 1872944 | 2021-05-15 | Italy | Molise | 13500 | 488 | 12677 | 335 | 41.55774754 | 14.65916051 | 2021-05-16 04:20:49 | Molise, Italy | ||
982977 | 982977 | 2021-04-17 | Japan | Niigata | 1915 | 18 | 1562 | 335 | 37.521819 | 138.918647 | 2021-04-18 04:20:41 | Niigata, Japan | ||
1842157 | 1842157 | 2021-04-14 | Russia | Komi Republic | 42513 | 845 | 41333 | 335 | 63.9881421 | 54.3326073 | 2021-04-15 04:20:54 | Komi Republic, Russia | ||
244933 | 244933 | 2021-04-02 | Malaysia | Pahang | 4340 | 17 | 3988 | 335 | 3.8126 | 103.3256 | 2021-04-03 04:20:44 | Pahang, Malaysia | ||
637970 | 637970 | 2021-03-31 | Japan | Yamagata | 948 | 17 | 596 | 335 | 38.448396 | 140.102154 | 2021-04-01 04:27:05 | Yamagata, Japan | ||
1289908 | 1289908 | 2021-03-29 | France | Wallis and Futuna | 383 | 4 | 44 | 335 | -14.2938 | -178.1165 | 2021-03-30 04:26:23 | Wallis and Futuna, France | ||
1980921 | 1980921 | 2021-03-25 | Suriname | 9085 | 177 | 8573 | 335 | 3.9193 | -56.0278 | 2021-03-26 05:26:55 | Suriname | |||
352076 | 352076 | 2021-03-11 | Chad | 4246 | 151 | 3760 | 335 | 15.4542 | 18.7322 | 2021-03-12 05:26:50 | Chad | |||
3670487 | 3670487 | 2021-03-06 | US | South Dakota | Hand | 46059 | 341 | 6 | 0 | 335 | 44.54708407 | -99.00386459 | 2021-03-07 05:21:54 | Hand, South Dakota, US |
1619108 | 1619108 | 2021-03-05 | US | South Dakota | Hand | 46059 | 341 | 6 | 0 | 335 | 44.54708407 | -99.00386459 | 2021-03-06 04:23:41 | Hand, South Dakota, US |
1619014 | 1619014 | 2021-03-05 | US | Puerto Rico | Santa Isabel | 72133 | 335 | 0 | 0 | 335 | 17.994525 | -66.388913 | 2021-03-06 04:23:41 | Santa Isabel, Puerto Rico, US |
1616548 | 1616548 | 2021-03-05 | Suriname | 8966 | 175 | 8456 | 335 | 3.9193 | -56.0278 | 2021-03-06 04:23:41 | Suriname | |||
2211095 | 2211095 | 2021-03-04 | US | Washington | Lincoln | 53043 | 340 | 5 | 0 | 335 | 47.57705241 | -118.4194388 | 2021-03-05 05:26:29 | Lincoln, Washington, US |
2210719 | 2210719 | 2021-03-04 | US | Texas | Donley | 48129 | 441 | 14 | 0 | 335 | 34.96517499 | -100.8140093 | 2021-03-05 05:26:29 | Donley, Texas, US |
2210519 | 2210519 | 2021-03-04 | US | South Dakota | Hand | 46059 | 341 | 6 | 0 | 335 | 44.54708407 | -99.00386459 | 2021-03-05 05:26:29 | Hand, South Dakota, US |
2210425 | 2210425 | 2021-03-04 | US | Puerto Rico | Santa Isabel | 72133 | 335 | 0 | 0 | 335 | 17.994525 | -66.388913 | 2021-03-05 05:26:29 | Santa Isabel, Puerto Rico, US |
1093516 | 1093516 | 2021-03-03 | US | Washington | Lincoln | 53043 | 340 | 5 | 0 | 335 | 47.57705241 | -118.4194388 | 2021-03-04 05:24:24 | Lincoln, Washington, US |
1093510 | 1093510 | 2021-03-03 | US | Washington | Jefferson | 53031 | 337 | 2 | 0 | 335 | 47.75003077 | -123.56097040000002 | 2021-03-04 05:24:24 | Jefferson, Washington, US |
1092846 | 1092846 | 2021-03-03 | US | Puerto Rico | Santa Isabel | 72133 | 335 | 0 | 0 | 335 | 17.994525 | -66.388913 | 2021-03-04 05:24:24 | Santa Isabel, Puerto Rico, US |
3257588 | 3257588 | 2021-03-02 | US | Washington | Lincoln | 53043 | 340 | 5 | 0 | 335 | 47.57705241 | -118.4194388 | 2021-03-03 05:23:28 | Lincoln, Washington, US |
3257582 | 3257582 | 2021-03-02 | US | Washington | Jefferson | 53031 | 337 | 2 | 0 | 335 | 47.75003077 | -123.56097040000002 | 2021-03-03 05:23:28 | Jefferson, Washington, US |
3256918 | 3256918 | 2021-03-02 | US | Puerto Rico | Santa Isabel | 72133 | 335 | 0 | 0 | 335 | 17.994525 | -66.388913 | 2021-03-03 05:23:28 | Santa Isabel, Puerto Rico, US |
3253937 | 3253937 | 2021-03-02 | Chile | Magallanes | 21939 | 316 | 21288 | 335 | -52.368 | -70.9863 | 2021-03-03 05:23:28 | Magallanes, Chile | ||
1001874 | 1001874 | 2021-03-01 | US | Washington | Jefferson | 53031 | 337 | 2 | 0 | 335 | 47.75003077 | -123.56097040000002 | 2021-03-02 05:23:30 | Jefferson, Washington, US |
1001210 | 1001210 | 2021-03-01 | US | Puerto Rico | Santa Isabel | 72133 | 335 | 0 | 0 | 335 | 17.994525 | -66.388913 | 2021-03-02 05:23:30 | Santa Isabel, Puerto Rico, US |
2370932 | 2370932 | 2021-02-28 | US | Washington | Jefferson | 53031 | 337 | 2 | 0 | 335 | 47.75003077 | -123.56097040000002 | 2021-03-01 05:23:01 | Jefferson, Washington, US |
3069434 | 3069434 | 2021-02-27 | US | Washington | Jefferson | 53031 | 337 | 2 | 0 | 335 | 47.75003077 | -123.56097040000002 | 2021-02-28 05:22:20 | Jefferson, Washington, US |
2187018 | 2187018 | 2021-02-26 | US | Washington | Jefferson | 53031 | 337 | 2 | 0 | 335 | 47.75003077 | -123.56097040000002 | 2021-02-27 05:22:28 | Jefferson, Washington, US |
1861330 | 1861330 | 2021-02-25 | US | Virginia | Falls Church | 51610 | 342 | 7 | 0 | 335 | 38.88485255 | -77.17560759 | 2021-02-26 05:22:40 | Falls Church, Virginia, US |
283508 | 283508 | 2021-02-24 | US | Virginia | Falls Church | 51610 | 342 | 7 | 0 | 335 | 38.88485255 | -77.17560759 | 2021-02-25 05:24:57 | Falls Church, Virginia, US |
283238 | 283238 | 2021-02-24 | US | Texas | Culberson | 48109 | 316 | 7 | 0 | 335 | 31.44506775 | -104.5185739 | 2021-02-25 05:24:57 | Culberson, Texas, US |
533761 | 533761 | 2021-02-22 | US | Texas | Culberson | 48109 | 316 | 7 | 0 | 335 | 31.44506775 | -104.5185739 | 2021-02-23 05:23:41 | Culberson, Texas, US |
185365 | 185365 | 2021-02-21 | US | Virginia | Falls Church | 51610 | 342 | 7 | 0 | 335 | 38.88485255 | -77.17560759 | 2021-02-22 05:24:21 | Falls Church, Virginia, US |
185095 | 185095 | 2021-02-21 | US | Texas | Culberson | 48109 | 316 | 7 | 0 | 335 | 31.44506775 | -104.5185739 | 2021-02-22 05:24:21 | Culberson, Texas, US |
184228 | 184228 | 2021-02-21 | US | New Mexico | Hidalgo | 35023 | 344 | 9 | 0 | 335 | 31.91383467 | -108.7151824 | 2021-02-22 05:24:21 | Hidalgo, New Mexico, US |
745369 | 745369 | 2021-02-20 | US | Texas | Culberson | 48109 | 316 | 7 | 0 | 335 | 31.44506775 | -104.5185739 | 2021-02-21 05:24:33 | Culberson, Texas, US |
471547 | 471547 | 2021-02-19 | Niger | 4725 | 170 | 4220 | 335 | 17.607789 | 8.081666 | 2021-02-20 05:22:51 | Niger | |||
3603155 | 3603155 | 2021-02-17 | US | Nebraska | Stanton | 31167 | 344 | 9 | 0 | 335 | 41.9169835 | -97.19394708 | 2021-02-18 05:22:58 | Stanton, Nebraska, US |
3052290 | 3052290 | 2021-02-16 | US | Nebraska | Stanton | 31167 | 344 | 9 | 0 | 335 | 41.9169835 | -97.19394708 | 2021-02-17 05:23:10 | Stanton, Nebraska, US |
3051924 | 3051924 | 2021-02-16 | US | Minnesota | Red Lake | 27125 | 339 | 4 | 0 | 335 | 47.87197525 | -96.09561104 | 2021-02-17 05:23:10 | Red Lake, Minnesota, US |
1340389 | 1340389 | 2021-02-15 | US | Nebraska | Stanton | 31167 | 344 | 9 | 0 | 335 | 41.9169835 | -97.19394708 | 2021-02-16 05:24:38 | Stanton, Nebraska, US |
2285540 | 2285540 | 2021-02-14 | US | Nebraska | Stanton | 31167 | 344 | 9 | 0 | 335 | 41.9169835 | -97.19394708 | 2021-02-15 05:24:49 | Stanton, Nebraska, US |
2285448 | 2285448 | 2021-02-14 | US | Montana | Sweet Grass | 30097 | 341 | 6 | 0 | 335 | 45.81367654 | -109.9425686 | 2021-02-15 05:24:49 | Sweet Grass, Montana, US |
2679940 | 2679940 | 2021-02-13 | US | Nebraska | Stanton | 31167 | 344 | 9 | 0 | 335 | 41.9169835 | -97.19394708 | 2021-02-14 05:23:43 | Stanton, Nebraska, US |
2679848 | 2679848 | 2021-02-13 | US | Montana | Sweet Grass | 30097 | 341 | 6 | 0 | 335 | 45.81367654 | -109.9425686 | 2021-02-14 05:23:43 | Sweet Grass, Montana, US |
3541573 | 3541573 | 2021-02-12 | US | Nebraska | Stanton | 31167 | 344 | 9 | 0 | 335 | 41.9169835 | -97.19394708 | 2021-02-13 05:22:12 | Stanton, Nebraska, US |
3541481 | 3541481 | 2021-02-12 | US | Montana | Sweet Grass | 30097 | 341 | 6 | 0 | 335 | 45.81367654 | -109.9425686 | 2021-02-13 05:22:12 | Sweet Grass, Montana, US |
2639836 | 2639836 | 2021-02-11 | US | Nebraska | Stanton | 31167 | 344 | 9 | 0 | 335 | 41.9169835 | -97.19394708 | 2021-02-12 05:23:29 | Stanton, Nebraska, US |
2639744 | 2639744 | 2021-02-11 | US | Montana | Sweet Grass | 30097 | 341 | 6 | 0 | 335 | 45.81367654 | -109.9425686 | 2021-02-12 05:23:29 | Sweet Grass, Montana, US |
3980691 | 3980691 | 2021-02-10 | US | Nebraska | Stanton | 31167 | 344 | 9 | 0 | 335 | 41.9169835 | -97.19394708 | 2021-02-11 05:23:55 | Stanton, Nebraska, US |
3980237 | 3980237 | 2021-02-10 | US | Michigan | Montmorency | 26119 | 352 | 17 | 0 | 335 | 45.0275929 | -84.12696227 | 2021-02-11 05:23:55 | Montmorency, Michigan, US |
616787 | 616787 | 2021-02-08 | US | Texas | Hardeman | 48197 | 339 | 12 | 0 | 335 | 34.28944521 | -99.74632408 | 2021-02-09 05:23:30 | Hardeman, Texas, US |
1675556 | 1675556 | 2021-02-07 | US | Texas | Hardeman | 48197 | 339 | 12 | 0 | 335 | 34.28944521 | -99.74632408 | 2021-02-08 05:22:39 | Hardeman, Texas, US |
978017 | 978017 | 2021-02-06 | US | Texas | Hardeman | 48197 | 339 | 12 | 0 | 335 | 34.28944521 | -99.74632408 | 2021-02-07 05:23:00 | Hardeman, Texas, US |
974957 | 974957 | 2021-02-06 | Japan | Tochigi | 3871 | 53 | 3483 | 335 | 36.689912 | 139.819213 | 2021-02-07 05:23:00 | Tochigi, Japan | ||
1591493 | 1591493 | 2021-02-05 | US | Virginia | Cumberland | 51049 | 339 | 4 | 0 | 335 | 37.51328851 | -78.24398086 | 2021-02-06 05:23:55 | Cumberland, Virginia, US |
343308 | 343308 | 2021-02-03 | US | Texas | Carson | 48065 | 617 | 12 | 0 | 335 | 35.40365929 | -101.3542669 | 2021-02-04 05:22:26 | Carson, Texas, US |
343141 | 343141 | 2021-02-03 | US | South Dakota | Hanson | 46061 | 339 | 4 | 0 | 335 | 43.6746384 | -97.78715148 | 2021-02-04 05:22:26 | Hanson, South Dakota, US |
342816 | 342816 | 2021-02-03 | US | Oklahoma | Ellis | 40045 | 336 | 1 | 0 | 335 | 36.2180194 | -99.75324573 | 2021-02-04 05:22:26 | Ellis, Oklahoma, US |
1687349 | 1687349 | 2021-02-02 | US | South Dakota | Clark | 46025 | 339 | 4 | 0 | 335 | 44.85834507 | -97.72925109 | 2021-02-03 05:22:52 | Clark, South Dakota, US |
1686143 | 1686143 | 2021-02-02 | US | Michigan | Lake | 26085 | 346 | 11 | 0 | 335 | 43.99050893 | -85.802173 | 2021-02-03 05:22:52 | Lake, Michigan, US |
1679319 | 1679319 | 2021-02-01 | US | South Dakota | Clark | 46025 | 339 | 4 | 0 | 335 | 44.85834507 | -97.72925109 | 2021-02-02 05:22:49 | Clark, South Dakota, US |
1678235 | 1678235 | 2021-02-01 | US | Minnesota | Unassigned | 90027 | 403 | 68 | 0 | 335 | 48.77754106 | 0.0 | 2021-02-02 05:22:49 | Unassigned, Minnesota, US |
1678113 | 1678113 | 2021-02-01 | US | Michigan | Lake | 26085 | 346 | 11 | 0 | 335 | 43.99050893 | -85.802173 | 2021-02-02 05:22:49 | Lake, Michigan, US |
1462607 | 1462607 | 2021-01-31 | US | South Dakota | Clark | 46025 | 339 | 4 | 0 | 335 | 44.85834507 | -97.72925109 | 2021-02-01 05:22:53 | Clark, South Dakota, US |
2485202 | 2485202 | 2021-01-28 | US | Texas | Upton | 48461 | 303 | 7 | 0 | 335 | 31.36868194 | -102.0423217 | 2021-01-29 05:22:23 | Upton, Texas, US |
3157072 | 3157072 | 2021-01-27 | US | West Virginia | Clay | 54015 | 339 | 4 | 0 | 335 | 38.46231092 | -81.07652217 | 2021-01-28 05:22:24 | Clay, West Virginia, US |
1759495 | 1759495 | 2021-01-24 | Russia | Jewish Autonomous Okrug | 4071 | 100 | 3636 | 335 | 48.57527615 | 132.66307460000002 | 2021-01-25 05:22:16 | Jewish Autonomous Okrug, Russia | ||
1759065 | 1759065 | 2021-01-24 | Canada | New Brunswick | 1124 | 13 | 776 | 335 | 46.5653 | -66.4619 | 2021-01-25 05:22:16 | New Brunswick, Canada | ||
2430182 | 2430182 | 2021-01-23 | US | Vermont | Orleans | 50019 | 340 | 5 | 0 | 335 | 44.82964024 | -72.24562697 | 2021-01-24 05:22:35 | Orleans, Vermont, US |
2468900 | 2468900 | 2021-01-22 | US | Nebraska | Nuckolls | 31129 | 336 | 1 | 0 | 335 | 40.17637905 | -98.04743961 | 2021-01-23 05:22:03 | Nuckolls, Nebraska, US |
2467403 | 2467403 | 2021-01-22 | US | Colorado | Clear Creek | 8019 | 354 | 2 | 0 | 335 | 39.68864463 | -105.6463118 | 2021-01-23 05:22:03 | Clear Creek, Colorado, US |
438246 | 438246 | 2021-01-21 | US | South Dakota | Potter | 46107 | 338 | 3 | 0 | 335 | 45.06583079 | -99.95498503 | 2021-01-22 05:22:10 | Potter, South Dakota, US |
435954 | 435954 | 2021-01-21 | US | Colorado | Clear Creek | 8019 | 353 | 2 | 0 | 335 | 39.68864463 | -105.6463118 | 2021-01-22 05:22:10 | Clear Creek, Colorado, US |
1096201 | 1096201 | 2021-01-20 | US | Nebraska | Stanton | 31167 | 343 | 8 | 0 | 335 | 41.9169835 | -97.19394708 | 2021-01-21 05:22:01 | Stanton, Nebraska, US |
1094685 | 1094685 | 2021-01-20 | US | Colorado | Clear Creek | 8019 | 353 | 2 | 0 | 335 | 39.68864463 | -105.6463118 | 2021-01-21 05:22:01 | Clear Creek, Colorado, US |
240130 | 240130 | 2021-01-18 | US | South Dakota | Potter | 46107 | 338 | 3 | 0 | 335 | 45.06583079 | -99.95498503 | 2021-01-19 05:22:15 | Potter, South Dakota, US |
3506247 | 3506247 | 2021-01-17 | US | South Dakota | Potter | 46107 | 338 | 3 | 0 | 335 | 45.06583079 | -99.95498503 | 2021-01-18 05:22:34 | Potter, South Dakota, US |
3518557 | 3518557 | 2021-01-15 | US | Texas | Marion | 48315 | 436 | 19 | 0 | 335 | 32.79868409 | -94.3566123 | 2021-01-16 05:22:40 | Marion, Texas, US |
3517302 | 3517302 | 2021-01-15 | US | Missouri | Holt | 29087 | 344 | 9 | 0 | 335 | 40.09799248 | -95.2163888 | 2021-01-16 05:22:40 | Holt, Missouri, US |
156711 | 156711 | 2021-01-08 | US | Puerto Rico | Florida | 72054 | 335 | 0 | 0 | 335 | 18.373715 | -66.560488 | 2021-01-09 05:22:18 | Florida, Puerto Rico, US |
155581 | 155581 | 2021-01-08 | US | Michigan | Alger | 26003 | 338 | 3 | 0 | 335 | 46.41292944 | -86.60260122 | 2021-01-09 05:22:18 | Alger, Michigan, US |
154581 | 154581 | 2021-01-08 | US | Colorado | Conejos | 8021 | 380 | 4 | 0 | 335 | 37.201606 | -106.19174879999998 | 2021-01-09 05:22:18 | Conejos, Colorado, US |
2541188 | 2541188 | 2021-01-07 | Chad | 2358 | 105 | 1918 | 335 | 15.4542 | 18.7322 | 2021-01-08 05:22:42 | Chad | |||
2864497 | 2864497 | 2021-01-06 | Chad | 2328 | 105 | 1888 | 335 | 15.4542 | 18.7322 | 2021-01-07 05:22:03 | Chad | |||
3035632 | 3035632 | 2021-01-05 | US | Kansas | Rush | 20165 | 343 | 8 | 0 | 335 | 38.52275276 | -99.30863983 | 2021-01-06 05:22:16 | Rush, Kansas, US |
3034330 | 3034330 | 2021-01-05 | Japan | Nara | 2121 | 26 | 1760 | 335 | 34.317451 | 135.871644 | 2021-01-06 05:22:16 | Nara, Japan | ||
1064783 | 1064783 | 2021-01-04 | US | Tennessee | Hancock | 47067 | 376 | 5 | 0 | 335 | 36.52692871 | -83.22375847 | 2021-01-05 05:21:49 | Hancock, 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]);