johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
695 rows where active = 269 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 629
- Japan 8
- Russia 7
- Chile 5
- Colombia 5
- Ukraine 5
- Congo (Brazzaville) 3
- Spain 3
- Canada 2
- China 2
- Germany 2
- India 2
- Malaysia 2
- Mauritius 2
- Mexico 2
- Albania 1
- Burkina Faso 1
- France 1
- Georgia 1
- Haiti 1
- Laos 1
- Latvia 1
- Namibia 1
- Pakistan 1
- San Marino 1
- Singapore 1
- Sweden 1
- Togo 1
- Trinidad and Tobago 1
- United Kingdom 1
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3683362 | 3683362 | 2021-08-02 | Germany | Bremen | 27916 | 493 | 27170 | 269 | 53.0793 | 8.8017 | 2021-08-03 04:21:39 | Bremen, Germany | ||
3683232 | 3683232 | 2021-08-02 | Chile | Antofagasta | 59710 | 1199 | 58242 | 269 | -23.6509 | -70.3975 | 2021-08-03 04:21:39 | Antofagasta, Chile | ||
3137747 | 3137747 | 2021-07-23 | Russia | Chukotka Autonomous Okrug | 1069 | 8 | 792 | 269 | 66.0006475 | 169.4900869 | 2021-07-24 00:21:36 | Chukotka Autonomous Okrug, Russia | ||
487218 | 487218 | 2021-07-19 | Ukraine | Kherson Oblast | 36039 | 1157 | 34613 | 269 | 46.6354 | 32.6169 | 2021-07-20 04:21:48 | Kherson Oblast, Ukraine | ||
778640 | 778640 | 2021-07-08 | Singapore | 62668 | 36 | 62363 | 269 | 1.2833 | 103.8333 | 2021-07-09 04:21:21 | Singapore | |||
2071956 | 2071956 | 2021-07-02 | Japan | Tochigi | 7081 | 81 | 6731 | 269 | 36.689912 | 139.819213 | 2021-07-03 04:21:37 | Tochigi, Japan | ||
3381414 | 3381414 | 2021-06-13 | Japan | Tochigi | 6671 | 80 | 6322 | 269 | 36.689912 | 139.819213 | 2021-06-14 04:22:46 | Tochigi, Japan | ||
523060 | 523060 | 2021-06-09 | Russia | Kalmykia Republic | 20964 | 386 | 20309 | 269 | 46.2313018 | 45.3275745 | 2021-06-10 04:23:17 | Kalmykia Republic, Russia | ||
2315359 | 2315359 | 2021-06-04 | Laos | 1952 | 3 | 1680 | 269 | 19.85627 | 102.495496 | 2021-06-05 04:23:03 | Laos | |||
2315160 | 2315160 | 2021-06-04 | Colombia | San Andres y Providencia | 5838 | 106 | 5463 | 269 | 12.5567 | -81.7185 | 2021-06-05 04:23:03 | San Andres y Providencia, Colombia | ||
1636525 | 1636525 | 2021-04-29 | Russia | Khakassia Republic | 22335 | 523 | 21543 | 269 | 53.72258845 | 91.44293627 | 2021-04-30 04:21:03 | Khakassia Republic, Russia | ||
954867 | 954867 | 2021-04-25 | Japan | Aomori | 1482 | 22 | 1191 | 269 | 40.781541 | 140.828896 | 2021-04-26 04:21:04 | Aomori, Japan | ||
388064 | 388064 | 2021-04-04 | Colombia | Casanare | 13170 | 307 | 12594 | 269 | 5.7589 | -71.5724 | 2021-04-05 04:20:35 | Casanare, Colombia | ||
3713813 | 3713813 | 2021-04-03 | Malaysia | Kedah | 8508 | 25 | 8214 | 269 | 6.1184 | 100.3685 | 2021-04-04 04:20:49 | Kedah, Malaysia | ||
638259 | 638259 | 2021-03-31 | Trinidad and Tobago | 8026 | 142 | 7615 | 269 | 10.6918 | -61.2225 | 2021-04-01 04:27:05 | Trinidad and Tobago | |||
637945 | 637945 | 2021-03-31 | Japan | Kyoto | 9517 | 169 | 9079 | 269 | 35.253815 | 135.443341 | 2021-04-01 04:27:05 | Kyoto, Japan | ||
1219641 | 1219641 | 2021-03-27 | Mauritius | 870 | 10 | 592 | 269 | -20.348404 | 57.552152 | 2021-03-28 05:28:10 | Mauritius | |||
1881059 | 1881059 | 2021-03-26 | Mauritius | 860 | 10 | 592 | 269 | -20.348404 | 57.552152 | 2021-03-27 05:25:04 | Mauritius | |||
1798848 | 1798848 | 2021-03-23 | Russia | Khakassia Republic | 21713 | 495 | 20949 | 269 | 53.72258845 | 91.44293627 | 2021-03-24 05:25:40 | Khakassia Republic, Russia | ||
1798449 | 1798449 | 2021-03-23 | China | Hong Kong | 11409 | 203 | 10936 | 269 | 22.3 | 114.2 | 2021-03-24 05:25:40 | Hong Kong, China | ||
3668214 | 3668214 | 2021-03-06 | US | Colorado | Baca | 8009 | 280 | 4 | 0 | 269 | 37.31940883 | -102.5603223 | 2021-03-07 05:21:54 | Baca, Colorado, US |
1616835 | 1616835 | 2021-03-05 | US | Colorado | Baca | 8009 | 280 | 4 | 0 | 269 | 37.31940883 | -102.5603223 | 2021-03-06 04:23:41 | Baca, Colorado, US |
2210375 | 2210375 | 2021-03-04 | US | Puerto Rico | Ceiba | 72037 | 269 | 0 | 0 | 269 | 18.251818 | -65.666416 | 2021-03-05 05:26:29 | Ceiba, Puerto Rico, US |
2208246 | 2208246 | 2021-03-04 | US | Colorado | Baca | 8009 | 280 | 4 | 0 | 269 | 37.31940883 | -102.5603223 | 2021-03-05 05:26:29 | Baca, Colorado, US |
1092796 | 1092796 | 2021-03-03 | US | Puerto Rico | Ceiba | 72037 | 269 | 0 | 0 | 269 | 18.251818 | -65.666416 | 2021-03-04 05:24:24 | Ceiba, Puerto Rico, US |
1090667 | 1090667 | 2021-03-03 | US | Colorado | Baca | 8009 | 280 | 4 | 0 | 269 | 37.31940883 | -102.5603223 | 2021-03-04 05:24:24 | Baca, Colorado, US |
3256868 | 3256868 | 2021-03-02 | US | Puerto Rico | Ceiba | 72037 | 269 | 0 | 0 | 269 | 18.251818 | -65.666416 | 2021-03-03 05:23:28 | Ceiba, Puerto Rico, US |
3256757 | 3256757 | 2021-03-02 | US | Oregon | Harney | 41025 | 275 | 6 | 0 | 269 | 43.06422669 | -118.9666306 | 2021-03-03 05:23:28 | Harney, Oregon, US |
3254739 | 3254739 | 2021-03-02 | US | Colorado | Baca | 8009 | 280 | 4 | 0 | 269 | 37.31940883 | -102.5603223 | 2021-03-03 05:23:28 | Baca, Colorado, US |
3253957 | 3253957 | 2021-03-02 | China | Hong Kong | 11032 | 200 | 10563 | 269 | 22.3 | 114.2 | 2021-03-03 05:23:28 | Hong Kong, China | ||
3253904 | 3253904 | 2021-03-02 | Burkina Faso | 12047 | 143 | 11635 | 269 | 12.2383 | -1.5616 | 2021-03-03 05:23:28 | Burkina Faso | |||
1001160 | 1001160 | 2021-03-01 | US | Puerto Rico | Ceiba | 72037 | 269 | 0 | 0 | 269 | 18.251818 | -65.666416 | 2021-03-02 05:23:30 | Ceiba, Puerto Rico, US |
998470 | 998470 | 2021-03-01 | Japan | Okinawa | 8200 | 119 | 7812 | 269 | 25.768923 | 126.668016 | 2021-03-02 05:23:30 | Okinawa, Japan | ||
2370218 | 2370218 | 2021-02-28 | US | Puerto Rico | Ceiba | 72037 | 269 | 0 | 0 | 269 | 18.251818 | -65.666416 | 2021-03-01 05:23:01 | Ceiba, Puerto Rico, US |
3052406 | 3052406 | 2021-02-16 | US | New York | Hamilton | 36041 | 271 | 2 | 0 | 269 | 43.66146647 | -74.49721957 | 2021-02-17 05:23:10 | Hamilton, New York, US |
978270 | 978270 | 2021-02-06 | US | Virginia | King and Queen | 51097 | 272 | 3 | 0 | 269 | 37.71044922 | -76.88689628 | 2021-02-07 05:23:00 | King and Queen, Virginia, US |
1590867 | 1590867 | 2021-02-05 | US | Pennsylvania | Sullivan | 42113 | 282 | 13 | 0 | 269 | 41.44634738 | -76.51246591 | 2021-02-06 05:23:55 | Sullivan, Pennsylvania, US |
793531 | 793531 | 2021-02-04 | US | Texas | Lipscomb | 48295 | 331 | 11 | 0 | 269 | 36.27783108 | -100.2733151 | 2021-02-05 05:22:38 | Lipscomb, Texas, US |
791701 | 791701 | 2021-02-04 | US | Kansas | Osborne | 20141 | 273 | 4 | 0 | 269 | 39.3503437 | -98.76753828 | 2021-02-05 05:22:38 | Osborne, Kansas, US |
790652 | 790652 | 2021-02-04 | San Marino | 3111 | 68 | 2774 | 269 | 43.9424 | 12.4578 | 2021-02-05 05:22:38 | San Marino | |||
343423 | 343423 | 2021-02-03 | US | Texas | Lipscomb | 48295 | 331 | 11 | 0 | 269 | 36.27783108 | -100.2733151 | 2021-02-04 05:22:26 | Lipscomb, Texas, US |
341593 | 341593 | 2021-02-03 | US | Kansas | Osborne | 20141 | 273 | 4 | 0 | 269 | 39.3503437 | -98.76753828 | 2021-02-04 05:22:26 | Osborne, Kansas, US |
1898561 | 1898561 | 2021-01-29 | US | Kentucky | Hickman | 21105 | 276 | 7 | 0 | 269 | 36.67948079999999 | -88.97875928 | 2021-01-30 05:22:49 | Hickman, Kentucky, US |
2485046 | 2485046 | 2021-01-28 | US | Texas | Fisher | 48151 | 305 | 12 | 0 | 269 | 32.74281316 | -100.4019302 | 2021-01-29 05:22:23 | Fisher, Texas, US |
2483377 | 2483377 | 2021-01-28 | US | Kentucky | Hickman | 21105 | 276 | 7 | 0 | 269 | 36.67948079999999 | -88.97875928 | 2021-01-29 05:22:23 | Hickman, Kentucky, US |
3156681 | 3156681 | 2021-01-27 | US | Texas | Fisher | 48151 | 305 | 12 | 0 | 269 | 32.74281316 | -100.4019302 | 2021-01-28 05:22:24 | Fisher, Texas, US |
2570401 | 2570401 | 2021-01-25 | US | Puerto Rico | Hormigueros | 72067 | 269 | 0 | 0 | 269 | 18.134532 | -67.113972 | 2021-01-26 05:22:02 | Hormigueros, Puerto Rico, US |
2569650 | 2569650 | 2021-01-25 | US | Montana | Fallon | 30025 | 271 | 2 | 0 | 269 | 46.33478338 | -104.4183565 | 2021-01-26 05:22:02 | Fallon, Montana, US |
2568524 | 2568524 | 2021-01-25 | US | Georgia | Schley | 13249 | 271 | 2 | 0 | 269 | 32.2654021 | -84.31258912 | 2021-01-26 05:22:02 | Schley, Georgia, US |
1762033 | 1762033 | 2021-01-24 | US | Puerto Rico | Hormigueros | 72067 | 269 | 0 | 0 | 269 | 18.134532 | -67.113972 | 2021-01-25 05:22:16 | Hormigueros, Puerto Rico, US |
1761282 | 1761282 | 2021-01-24 | US | Montana | Fallon | 30025 | 271 | 2 | 0 | 269 | 46.33478338 | -104.4183565 | 2021-01-25 05:22:16 | Fallon, Montana, US |
2428889 | 2428889 | 2021-01-23 | US | Montana | Fallon | 30025 | 271 | 2 | 0 | 269 | 46.33478338 | -104.4183565 | 2021-01-24 05:22:35 | Fallon, Montana, US |
2468791 | 2468791 | 2021-01-22 | US | Montana | Fallon | 30025 | 271 | 2 | 0 | 269 | 46.33478338 | -104.4183565 | 2021-01-23 05:22:03 | Fallon, Montana, US |
437342 | 437342 | 2021-01-21 | US | Montana | Fallon | 30025 | 271 | 2 | 0 | 269 | 46.33478338 | -104.4183565 | 2021-01-22 05:22:10 | Fallon, Montana, US |
1096073 | 1096073 | 2021-01-20 | US | Montana | Fallon | 30025 | 271 | 2 | 0 | 269 | 46.33478338 | -104.4183565 | 2021-01-21 05:22:01 | Fallon, Montana, US |
1094703 | 1094703 | 2021-01-20 | US | Colorado | Huerfano | 8055 | 291 | 16 | 0 | 269 | 37.68473101 | -104.9612585 | 2021-01-21 05:22:01 | Huerfano, Colorado, US |
1094105 | 1094105 | 2021-01-20 | Japan | Kagoshima | 1460 | 15 | 1176 | 269 | 31.009484000000004 | 130.430665 | 2021-01-21 05:22:01 | Kagoshima, Japan | ||
910163 | 910163 | 2021-01-19 | US | Montana | Fallon | 30025 | 271 | 2 | 0 | 269 | 46.33478338 | -104.4183565 | 2021-01-20 05:21:54 | Fallon, Montana, US |
908793 | 908793 | 2021-01-19 | US | Colorado | Huerfano | 8055 | 291 | 16 | 0 | 269 | 37.68473101 | -104.9612585 | 2021-01-20 05:21:54 | Huerfano, Colorado, US |
908317 | 908317 | 2021-01-19 | Pakistan | Azad Jammu and Kashmir | 8672 | 245 | 8158 | 269 | 34.027401 | 73.947253 | 2021-01-20 05:21:54 | Azad Jammu and Kashmir, Pakistan | ||
239226 | 239226 | 2021-01-18 | US | Montana | Fallon | 30025 | 271 | 2 | 0 | 269 | 46.33478338 | -104.4183565 | 2021-01-19 05:22:15 | Fallon, Montana, US |
238153 | 238153 | 2021-01-18 | US | Idaho | Boise | 16015 | 271 | 2 | 0 | 269 | 43.98829931 | -115.7309284 | 2021-01-19 05:22:15 | Boise, Idaho, US |
237856 | 237856 | 2021-01-18 | US | Colorado | Huerfano | 8055 | 291 | 16 | 0 | 269 | 37.68473101 | -104.9612585 | 2021-01-19 05:22:15 | Huerfano, Colorado, US |
237648 | 237648 | 2021-01-18 | US | Alaska | Aleutians West | 2016 | 269 | 0 | 0 | 269 | 52.3233 | -174.1596 | 2021-01-19 05:22:15 | Aleutians West, Alaska, US |
3506120 | 3506120 | 2021-01-17 | US | Puerto Rico | Rincon | 72117 | 269 | 0 | 0 | 269 | 18.335443 | -67.23174 | 2021-01-18 05:22:34 | Rincon, Puerto Rico, US |
3505343 | 3505343 | 2021-01-17 | US | Montana | Fallon | 30025 | 271 | 2 | 0 | 269 | 46.33478338 | -104.4183565 | 2021-01-18 05:22:34 | Fallon, Montana, US |
3504270 | 3504270 | 2021-01-17 | US | Idaho | Boise | 16015 | 271 | 2 | 0 | 269 | 43.98829931 | -115.7309284 | 2021-01-18 05:22:34 | Boise, Idaho, US |
3503973 | 3503973 | 2021-01-17 | US | Colorado | Huerfano | 8055 | 291 | 16 | 0 | 269 | 37.68473101 | -104.9612585 | 2021-01-18 05:22:34 | Huerfano, Colorado, US |
3503765 | 3503765 | 2021-01-17 | US | Alaska | Aleutians West | 2016 | 269 | 0 | 0 | 269 | 52.3233 | -174.1596 | 2021-01-18 05:22:34 | Aleutians West, Alaska, US |
3103426 | 3103426 | 2021-01-16 | US | Montana | Fallon | 30025 | 271 | 2 | 0 | 269 | 46.33478338 | -104.4183565 | 2021-01-17 05:22:17 | Fallon, Montana, US |
3517388 | 3517388 | 2021-01-15 | US | Montana | Fallon | 30025 | 271 | 2 | 0 | 269 | 46.33478338 | -104.4183565 | 2021-01-16 05:22:40 | Fallon, Montana, US |
3882980 | 3882980 | 2021-01-14 | US | Virginia | Surry | 51181 | 274 | 5 | 0 | 269 | 37.11781893 | -76.88450012 | 2021-01-15 05:22:24 | Surry, Virginia, US |
3882453 | 3882453 | 2021-01-14 | US | South Dakota | Marshall | 46091 | 274 | 5 | 0 | 269 | 45.75870838 | -97.59855639 | 2021-01-15 05:22:24 | Marshall, South Dakota, US |
3881986 | 3881986 | 2021-01-14 | US | North Dakota | Renville | 38075 | 282 | 12 | 0 | 269 | 48.71982533 | -101.6603912 | 2021-01-15 05:22:24 | Renville, North Dakota, US |
3881560 | 3881560 | 2021-01-14 | US | Montana | Fallon | 30025 | 271 | 2 | 0 | 269 | 46.33478338 | -104.4183565 | 2021-01-15 05:22:24 | Fallon, Montana, US |
3310613 | 3310613 | 2021-01-13 | US | North Dakota | Renville | 38075 | 280 | 12 | 0 | 269 | 48.71982533 | -101.6603912 | 2021-01-14 05:22:32 | Renville, North Dakota, US |
3310389 | 3310389 | 2021-01-13 | US | New Mexico | Hidalgo | 35023 | 278 | 9 | 0 | 269 | 31.91383467 | -108.7151824 | 2021-01-14 05:22:32 | Hidalgo, New Mexico, US |
3310187 | 3310187 | 2021-01-13 | US | Montana | Fallon | 30025 | 271 | 2 | 0 | 269 | 46.33478338 | -104.4183565 | 2021-01-14 05:22:32 | Fallon, Montana, US |
777859 | 777859 | 2021-01-12 | US | West Virginia | Wirt | 54105 | 270 | 1 | 0 | 269 | 39.02775007 | -81.37473928 | 2021-01-13 05:22:15 | Wirt, West Virginia, US |
776534 | 776534 | 2021-01-12 | US | New Mexico | Hidalgo | 35023 | 278 | 9 | 0 | 269 | 31.91383467 | -108.7151824 | 2021-01-13 05:22:15 | Hidalgo, New Mexico, US |
776332 | 776332 | 2021-01-12 | US | Montana | Fallon | 30025 | 271 | 2 | 0 | 269 | 46.33478338 | -104.4183565 | 2021-01-13 05:22:15 | Fallon, Montana, US |
774991 | 774991 | 2021-01-12 | US | Colorado | Saguache | 8109 | 292 | 4 | 0 | 269 | 38.08054629 | -106.282466 | 2021-01-13 05:22:15 | Saguache, Colorado, US |
192053 | 192053 | 2021-01-11 | US | Montana | Fallon | 30025 | 271 | 2 | 0 | 269 | 46.33478338 | -104.4183565 | 2021-01-12 05:22:15 | Fallon, Montana, US |
191009 | 191009 | 2021-01-11 | US | Idaho | Oneida | 16071 | 271 | 2 | 0 | 269 | 42.19494279999999 | -112.5407838 | 2021-01-12 05:22:15 | Oneida, Idaho, US |
2627856 | 2627856 | 2021-01-10 | US | Montana | Fallon | 30025 | 271 | 2 | 0 | 269 | 46.33478338 | -104.4183565 | 2021-01-11 05:21:50 | Fallon, Montana, US |
3901944 | 3901944 | 2021-01-09 | US | Montana | Fallon | 30025 | 271 | 2 | 0 | 269 | 46.33478338 | -104.4183565 | 2021-01-10 05:22:12 | Fallon, Montana, US |
157422 | 157422 | 2021-01-08 | US | Washington | Lincoln | 53043 | 274 | 5 | 0 | 269 | 47.57705241 | -118.4194388 | 2021-01-09 05:22:18 | Lincoln, Washington, US |
156393 | 156393 | 2021-01-08 | US | North Dakota | Renville | 38075 | 280 | 12 | 0 | 269 | 48.71982533 | -101.6603912 | 2021-01-09 05:22:18 | Renville, North Dakota, US |
155967 | 155967 | 2021-01-08 | US | Montana | Fallon | 30025 | 271 | 2 | 0 | 269 | 46.33478338 | -104.4183565 | 2021-01-09 05:22:18 | Fallon, Montana, US |
2543827 | 2543827 | 2021-01-07 | US | North Dakota | Towner | 38095 | 279 | 10 | 0 | 269 | 48.68565745 | -99.24564265 | 2021-01-08 05:22:42 | Towner, North Dakota, US |
2543817 | 2543817 | 2021-01-07 | US | North Dakota | Renville | 38075 | 279 | 12 | 0 | 269 | 48.71982533 | -101.6603912 | 2021-01-08 05:22:42 | Renville, North Dakota, US |
2867136 | 2867136 | 2021-01-06 | US | North Dakota | Towner | 38095 | 278 | 10 | 0 | 269 | 48.68565745 | -99.24564265 | 2021-01-07 05:22:03 | Towner, North Dakota, US |
3036696 | 3036696 | 2021-01-05 | US | North Dakota | Hettinger | 38041 | 270 | 4 | 0 | 269 | 46.43375068 | -102.4632417 | 2021-01-06 05:22:16 | Hettinger, North Dakota, US |
1065521 | 1065521 | 2021-01-04 | Malaysia | Kedah | 3189 | 13 | 2907 | 269 | 6.1184 | 100.3685 | 2021-01-05 05:21:49 | Kedah, Malaysia | ||
1063968 | 1063968 | 2021-01-04 | US | Nebraska | Webster | 31181 | 273 | 4 | 0 | 269 | 40.17642643 | -98.50019851 | 2021-01-05 05:21:49 | Webster, Nebraska, US |
3231599 | 3231599 | 2021-01-03 | US | Iowa | Adams | 19003 | 271 | 2 | 0 | 269 | 41.02903567 | -94.69932645 | 2021-01-04 05:22:02 | Adams, Iowa, US |
2227947 | 2227947 | 2021-01-02 | US | Alaska | Sitka | 2220 | 269 | 0 | 0 | 269 | 57.24124555 | -135.3206587 | 2021-01-03 05:22:52 | Sitka, Alaska, US |
768440 | 768440 | 2020-12-29 | US | Nebraska | Webster | 31181 | 272 | 3 | 0 | 269 | 40.17642643 | -98.50019851 | 2020-12-30 05:22:34 | Webster, Nebraska, US |
767684 | 767684 | 2020-12-29 | US | Kentucky | Bracken | 21023 | 272 | 3 | 0 | 269 | 38.69158994 | -84.08532444 | 2020-12-30 05:22:34 | Bracken, Kentucky, US |
766917 | 766917 | 2020-12-29 | US | Colorado | Clear Creek | 8019 | 308 | 2 | 0 | 269 | 39.68864463 | -105.6463118 | 2020-12-30 05:22:34 | Clear Creek, Colorado, 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]);