johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
611 rows where active = 357 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 534
- Russia 9
- Japan 8
- Madagascar 7
- Colombia 5
- Chile 4
- India 4
- Sao Tome and Principe 4
- Gambia 3
- Germany 3
- Malaysia 3
- United Kingdom 3
- Chad 2
- Guyana 2
- Mexico 2
- Suriname 2
- Ukraine 2
- Andorra 1
- Australia 1
- Brazil 1
- Cabo Verde 1
- Georgia 1
- Italy 1
- Latvia 1
- Lithuania 1
- Mali 1
- Mongolia 1
- Nigeria 1
- Sierra Leone 1
- Togo 1
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3389044 | 3389044 | 2021-07-29 | United Kingdom | Gibraltar | 4922 | 94 | 4471 | 357 | 36.1408 | -5.3536 | 2021-07-30 04:21:34 | Gibraltar, United Kingdom | ||
3741000 | 3741000 | 2021-07-12 | Germany | Sachsen | 286028 | 10103 | 275600 | 357 | 51.1045 | 13.2017 | 2021-07-13 04:21:18 | Sachsen, Germany | ||
3659339 | 3659339 | 2021-07-11 | Brazil | Piaui | 302309 | 6706 | 295113 | 357 | -7.7183 | -42.7289 | 2021-07-12 04:21:34 | Piaui, Brazil | ||
1164963 | 1164963 | 2021-07-04 | Chile | Tarapaca | 39177 | 742 | 38078 | 357 | -19.9232 | -69.5132 | 2021-07-05 04:21:28 | Tarapaca, Chile | ||
2590040 | 2590040 | 2021-06-27 | Japan | Shizuoka | 9248 | 150 | 8741 | 357 | 34.916975 | 138.40778400000002 | 2021-06-28 04:21:29 | Shizuoka, Japan | ||
1712528 | 1712528 | 2021-06-25 | Russia | Kabardino-Balkarian Republic | 24753 | 491 | 23905 | 357 | 43.4806048 | 43.5978976 | 2021-06-26 04:21:43 | Kabardino-Balkarian Republic, Russia | ||
2315136 | 2315136 | 2021-06-04 | Colombia | Arauca | 8239 | 240 | 7642 | 357 | 7.0762 | -70.7105 | 2021-06-05 04:23:03 | Arauca, Colombia | ||
20387 | 20387 | 2021-05-28 | Japan | Kagoshima | 3256 | 30 | 2869 | 357 | 31.009484000000004 | 130.430665 | 2021-05-29 04:20:41 | Kagoshima, Japan | ||
1771368 | 1771368 | 2021-05-23 | Japan | Nagano | 4621 | 76 | 4188 | 357 | 36.132134 | 138.045528 | 2021-05-24 04:20:53 | Nagano, Japan | ||
641603 | 641603 | 2021-03-31 | Malaysia | Perak | 12964 | 44 | 12563 | 357 | 4.5921 | 101.0901 | 2021-04-01 04:27:05 | Perak, Malaysia | ||
702630 | 702630 | 2021-03-16 | Russia | Murmansk Oblast | 47948 | 1025 | 46566 | 357 | 68.00004179999999 | 33.9999151 | 2021-03-17 05:25:07 | Murmansk Oblast, Russia | ||
2056092 | 2056092 | 2021-03-15 | Russia | Khakassia Republic | 21571 | 483 | 20731 | 357 | 53.72258845 | 91.44293627 | 2021-03-16 05:25:13 | Khakassia Republic, Russia | ||
1732185 | 1732185 | 2021-03-14 | Andorra | 11266 | 113 | 10796 | 357 | 42.5063 | 1.5218 | 2021-03-15 05:25:51 | Andorra | |||
1580361 | 1580361 | 2021-03-13 | Russia | Khakassia Republic | 21537 | 483 | 20697 | 357 | 53.72258845 | 91.44293627 | 2021-03-14 05:25:37 | Khakassia Republic, Russia | ||
2359247 | 2359247 | 2021-03-08 | Chad | 4193 | 146 | 3690 | 357 | 15.4542 | 18.7322 | 2021-03-09 05:28:19 | Chad | |||
3671219 | 3671219 | 2021-03-06 | US | Wyoming | Hot Springs | 56017 | 360 | 3 | 0 | 357 | 43.71930657 | -108.4423174 | 2021-03-07 05:21:54 | Hot Springs, Wyoming, US |
3669522 | 3669522 | 2021-03-06 | US | Missouri | Holt | 29087 | 367 | 10 | 0 | 357 | 40.09799248 | -95.2163888 | 2021-03-07 05:21:54 | Holt, Missouri, US |
3669264 | 3669264 | 2021-03-06 | US | Michigan | Lake | 26085 | 368 | 11 | 0 | 357 | 43.99050893 | -85.802173 | 2021-03-07 05:21:54 | Lake, Michigan, US |
3668531 | 3668531 | 2021-03-06 | US | Idaho | Bear Lake | 16007 | 359 | 2 | 0 | 357 | 42.28269683 | -111.32892379999998 | 2021-03-07 05:21:54 | Bear Lake, Idaho, US |
1619840 | 1619840 | 2021-03-05 | US | Wyoming | Hot Springs | 56017 | 360 | 3 | 0 | 357 | 43.71930657 | -108.4423174 | 2021-03-06 04:23:41 | Hot Springs, Wyoming, US |
1618143 | 1618143 | 2021-03-05 | US | Missouri | Holt | 29087 | 367 | 10 | 0 | 357 | 40.09799248 | -95.2163888 | 2021-03-06 04:23:41 | Holt, Missouri, US |
1617152 | 1617152 | 2021-03-05 | US | Idaho | Bear Lake | 16007 | 359 | 2 | 0 | 357 | 42.28269683 | -111.32892379999998 | 2021-03-06 04:23:41 | Bear Lake, Idaho, US |
2211251 | 2211251 | 2021-03-04 | US | Wyoming | Hot Springs | 56017 | 360 | 3 | 0 | 357 | 43.71930657 | -108.4423174 | 2021-03-05 05:26:29 | Hot Springs, Wyoming, US |
2209554 | 2209554 | 2021-03-04 | US | Missouri | Holt | 29087 | 367 | 10 | 0 | 357 | 40.09799248 | -95.2163888 | 2021-03-05 05:26:29 | Holt, Missouri, US |
2209402 | 2209402 | 2021-03-04 | US | Minnesota | Red Lake | 27125 | 362 | 5 | 0 | 357 | 47.87197525 | -96.09561104 | 2021-03-05 05:26:29 | Red Lake, Minnesota, US |
1093672 | 1093672 | 2021-03-03 | US | Wyoming | Hot Springs | 56017 | 360 | 3 | 0 | 357 | 43.71930657 | -108.4423174 | 2021-03-04 05:24:24 | Hot Springs, Wyoming, US |
1091975 | 1091975 | 2021-03-03 | US | Missouri | Holt | 29087 | 367 | 10 | 0 | 357 | 40.09799248 | -95.2163888 | 2021-03-04 05:24:24 | Holt, Missouri, US |
1091823 | 1091823 | 2021-03-03 | US | Minnesota | Red Lake | 27125 | 362 | 5 | 0 | 357 | 47.87197525 | -96.09561104 | 2021-03-04 05:24:24 | Red Lake, Minnesota, US |
3257744 | 3257744 | 2021-03-02 | US | Wyoming | Hot Springs | 56017 | 360 | 3 | 0 | 357 | 43.71930657 | -108.4423174 | 2021-03-03 05:23:28 | Hot Springs, Wyoming, US |
3257553 | 3257553 | 2021-03-02 | US | Virginia | Surry | 51181 | 364 | 7 | 0 | 357 | 37.11781893 | -76.88450012 | 2021-03-03 05:23:28 | Surry, Virginia, US |
3256047 | 3256047 | 2021-03-02 | US | Missouri | Holt | 29087 | 367 | 10 | 0 | 357 | 40.09799248 | -95.2163888 | 2021-03-03 05:23:28 | Holt, Missouri, US |
3255895 | 3255895 | 2021-03-02 | US | Minnesota | Red Lake | 27125 | 362 | 5 | 0 | 357 | 47.87197525 | -96.09561104 | 2021-03-03 05:23:28 | Red Lake, Minnesota, US |
3255426 | 3255426 | 2021-03-02 | US | Kansas | Gove | 20063 | 376 | 19 | 0 | 357 | 38.91588178 | -100.4829321 | 2021-03-03 05:23:28 | Gove, Kansas, US |
1002036 | 1002036 | 2021-03-01 | US | Wyoming | Hot Springs | 56017 | 360 | 3 | 0 | 357 | 43.71930657 | -108.4423174 | 2021-03-02 05:23:30 | Hot Springs, Wyoming, US |
1000187 | 1000187 | 2021-03-01 | US | Minnesota | Red Lake | 27125 | 362 | 5 | 0 | 357 | 47.87197525 | -96.09561104 | 2021-03-02 05:23:30 | Red Lake, Minnesota, US |
999718 | 999718 | 2021-03-01 | US | Kansas | Gove | 20063 | 376 | 19 | 0 | 357 | 38.91588178 | -100.4829321 | 2021-03-02 05:23:30 | Gove, Kansas, US |
2371010 | 2371010 | 2021-02-28 | US | West Virginia | Wirt | 54105 | 359 | 2 | 0 | 357 | 39.02775007 | -81.37473928 | 2021-03-01 05:23:01 | Wirt, West Virginia, US |
2370689 | 2370689 | 2021-02-28 | US | Texas | Reagan | 48383 | 319 | 8 | 0 | 357 | 31.36607041 | -101.5232659 | 2021-03-01 05:23:01 | Reagan, Texas, US |
2369245 | 2369245 | 2021-02-28 | US | Minnesota | Red Lake | 27125 | 362 | 5 | 0 | 357 | 47.87197525 | -96.09561104 | 2021-03-01 05:23:01 | Red Lake, Minnesota, US |
2368776 | 2368776 | 2021-02-28 | US | Kansas | Gove | 20063 | 376 | 19 | 0 | 357 | 38.91588178 | -100.4829321 | 2021-03-01 05:23:01 | Gove, Kansas, US |
2367510 | 2367510 | 2021-02-28 | Japan | Ibaraki | 5755 | 109 | 5289 | 357 | 36.303588 | 140.319591 | 2021-03-01 05:23:01 | Ibaraki, Japan | ||
3069512 | 3069512 | 2021-02-27 | US | West Virginia | Wirt | 54105 | 359 | 2 | 0 | 357 | 39.02775007 | -81.37473928 | 2021-02-28 05:22:20 | Wirt, West Virginia, US |
3069191 | 3069191 | 2021-02-27 | US | Texas | Reagan | 48383 | 319 | 8 | 0 | 357 | 31.36607041 | -101.5232659 | 2021-02-28 05:22:20 | Reagan, Texas, US |
3068865 | 3068865 | 2021-02-27 | US | South Dakota | Hanson | 46061 | 361 | 4 | 0 | 357 | 43.6746384 | -97.78715148 | 2021-02-28 05:22:20 | Hanson, South Dakota, US |
3067747 | 3067747 | 2021-02-27 | US | Minnesota | Red Lake | 27125 | 362 | 5 | 0 | 357 | 47.87197525 | -96.09561104 | 2021-02-28 05:22:20 | Red Lake, Minnesota, US |
3067278 | 3067278 | 2021-02-27 | US | Kansas | Gove | 20063 | 376 | 19 | 0 | 357 | 38.91588178 | -100.4829321 | 2021-02-28 05:22:20 | Gove, Kansas, US |
3065940 | 3065940 | 2021-02-27 | India | Chandigarh | 21719 | 351 | 21011 | 357 | 30.733839 | 76.76827800000002 | 2021-02-28 05:22:20 | Chandigarh, India | ||
2186775 | 2186775 | 2021-02-26 | US | Texas | Reagan | 48383 | 319 | 8 | 0 | 357 | 31.36607041 | -101.5232659 | 2021-02-27 05:22:28 | Reagan, Texas, US |
2184862 | 2184862 | 2021-02-26 | US | Kansas | Gove | 20063 | 376 | 19 | 0 | 357 | 38.91588178 | -100.4829321 | 2021-02-27 05:22:28 | Gove, Kansas, US |
1861197 | 1861197 | 2021-02-25 | US | Texas | Reagan | 48383 | 319 | 8 | 0 | 357 | 31.36607041 | -101.5232659 | 2021-02-26 05:22:40 | Reagan, Texas, US |
1859284 | 1859284 | 2021-02-25 | US | Kansas | Gove | 20063 | 376 | 19 | 0 | 357 | 38.91588178 | -100.4829321 | 2021-02-26 05:22:40 | Gove, Kansas, US |
281462 | 281462 | 2021-02-24 | US | Kansas | Gove | 20063 | 376 | 19 | 0 | 357 | 38.91588178 | -100.4829321 | 2021-02-25 05:24:57 | Gove, Kansas, US |
280453 | 280453 | 2021-02-24 | Sao Tome and Principe | 1672 | 27 | 1288 | 357 | 0.1864 | 6.6131 | 2021-02-25 05:24:57 | Sao Tome and Principe | |||
1937730 | 1937730 | 2021-02-23 | US | Kansas | Gove | 20063 | 376 | 19 | 0 | 357 | 38.91588178 | -100.4829321 | 2021-02-24 05:29:16 | Gove, Kansas, US |
1937049 | 1937049 | 2021-02-23 | US | Colorado | Clear Creek | 8019 | 375 | 2 | 0 | 357 | 39.68864463 | -105.6463118 | 2021-02-24 05:29:16 | Clear Creek, Colorado, US |
533554 | 533554 | 2021-02-22 | US | South Dakota | Clark | 46025 | 362 | 5 | 0 | 357 | 44.85834507 | -97.72925109 | 2021-02-23 05:23:41 | Clark, South Dakota, US |
531985 | 531985 | 2021-02-22 | US | Kansas | Gove | 20063 | 376 | 19 | 0 | 357 | 38.91588178 | -100.4829321 | 2021-02-23 05:23:41 | Gove, Kansas, US |
531304 | 531304 | 2021-02-22 | US | Colorado | Clear Creek | 8019 | 375 | 2 | 0 | 357 | 39.68864463 | -105.6463118 | 2021-02-23 05:23:41 | Clear Creek, Colorado, US |
184888 | 184888 | 2021-02-21 | US | South Dakota | Clark | 46025 | 362 | 5 | 0 | 357 | 44.85834507 | -97.72925109 | 2021-02-22 05:24:21 | Clark, South Dakota, US |
183319 | 183319 | 2021-02-21 | US | Kansas | Gove | 20063 | 376 | 19 | 0 | 357 | 38.91588178 | -100.4829321 | 2021-02-22 05:24:21 | Gove, Kansas, US |
183291 | 183291 | 2021-02-21 | US | Kansas | Barber | 20007 | 364 | 7 | 0 | 357 | 37.2288586 | -98.68460053 | 2021-02-22 05:24:21 | Barber, Kansas, US |
745506 | 745506 | 2021-02-20 | US | Texas | Reagan | 48383 | 319 | 8 | 0 | 357 | 31.36607041 | -101.5232659 | 2021-02-21 05:24:33 | Reagan, Texas, US |
745162 | 745162 | 2021-02-20 | US | South Dakota | Clark | 46025 | 362 | 5 | 0 | 357 | 44.85834507 | -97.72925109 | 2021-02-21 05:24:33 | Clark, South Dakota, US |
743593 | 743593 | 2021-02-20 | US | Kansas | Gove | 20063 | 376 | 19 | 0 | 357 | 38.91588178 | -100.4829321 | 2021-02-21 05:24:33 | Gove, Kansas, US |
743565 | 743565 | 2021-02-20 | US | Kansas | Barber | 20007 | 364 | 7 | 0 | 357 | 37.2288586 | -98.68460053 | 2021-02-21 05:24:33 | Barber, Kansas, US |
742619 | 742619 | 2021-02-20 | Suriname | 8856 | 168 | 8331 | 357 | 3.9193 | -56.0278 | 2021-02-21 05:24:33 | Suriname | |||
474604 | 474604 | 2021-02-19 | US | Texas | Reagan | 48383 | 319 | 8 | 0 | 357 | 31.36607041 | -101.5232659 | 2021-02-20 05:22:51 | Reagan, Texas, US |
472691 | 472691 | 2021-02-19 | US | Kansas | Gove | 20063 | 376 | 19 | 0 | 357 | 38.91588178 | -100.4829321 | 2021-02-20 05:22:51 | Gove, Kansas, US |
472663 | 472663 | 2021-02-19 | US | Kansas | Barber | 20007 | 364 | 7 | 0 | 357 | 37.2288586 | -98.68460053 | 2021-02-20 05:22:51 | Barber, Kansas, US |
1156313 | 1156313 | 2021-02-18 | US | Texas | Reagan | 48383 | 319 | 8 | 0 | 357 | 31.36607041 | -101.5232659 | 2021-02-19 05:24:16 | Reagan, Texas, US |
1155508 | 1155508 | 2021-02-18 | US | North Dakota | Dunn | 38025 | 366 | 7 | 0 | 357 | 47.35423935 | -102.6160468 | 2021-02-19 05:24:16 | Dunn, North Dakota, US |
3604233 | 3604233 | 2021-02-17 | US | Texas | Reagan | 48383 | 319 | 8 | 0 | 357 | 31.36607041 | -101.5232659 | 2021-02-18 05:22:58 | Reagan, Texas, US |
3603428 | 3603428 | 2021-02-17 | US | North Dakota | Dunn | 38025 | 365 | 7 | 0 | 357 | 47.35423935 | -102.6160468 | 2021-02-18 05:22:58 | Dunn, North Dakota, US |
3053368 | 3053368 | 2021-02-16 | US | Texas | Reagan | 48383 | 319 | 8 | 0 | 357 | 31.36607041 | -101.5232659 | 2021-02-17 05:23:10 | Reagan, Texas, US |
3053024 | 3053024 | 2021-02-16 | US | South Dakota | Clark | 46025 | 361 | 4 | 0 | 357 | 44.85834507 | -97.72925109 | 2021-02-17 05:23:10 | Clark, South Dakota, US |
3052563 | 3052563 | 2021-02-16 | US | North Dakota | Dunn | 38025 | 365 | 7 | 0 | 357 | 47.35423935 | -102.6160468 | 2021-02-17 05:23:10 | Dunn, North Dakota, US |
3050827 | 3050827 | 2021-02-16 | US | Colorado | Washington | 8121 | 392 | 12 | 0 | 357 | 39.97015535 | -103.202587 | 2021-02-17 05:23:10 | Washington, Colorado, US |
1341467 | 1341467 | 2021-02-15 | US | Texas | Reagan | 48383 | 319 | 8 | 0 | 357 | 31.36607041 | -101.5232659 | 2021-02-16 05:24:38 | Reagan, Texas, US |
1340039 | 1340039 | 2021-02-15 | US | Minnesota | Unassigned | 90027 | 425 | 68 | 0 | 357 | 48.77754106 | 0.0 | 2021-02-16 05:24:38 | Unassigned, Minnesota, US |
1338545 | 1338545 | 2021-02-15 | Sao Tome and Principe | 1482 | 19 | 1106 | 357 | 0.1864 | 6.6131 | 2021-02-16 05:24:38 | Sao Tome and Principe | |||
1338115 | 1338115 | 2021-02-15 | Colombia | Caqueta | 16925 | 615 | 15953 | 357 | 0.8699 | -73.8419 | 2021-02-16 05:24:38 | Caqueta, Colombia | ||
2286618 | 2286618 | 2021-02-14 | US | Texas | Reagan | 48383 | 319 | 8 | 0 | 357 | 31.36607041 | -101.5232659 | 2021-02-15 05:24:49 | Reagan, Texas, US |
2285190 | 2285190 | 2021-02-14 | US | Minnesota | Unassigned | 90027 | 425 | 68 | 0 | 357 | 48.77754106 | 0.0 | 2021-02-15 05:24:49 | Unassigned, Minnesota, US |
2283696 | 2283696 | 2021-02-14 | Sao Tome and Principe | 1482 | 19 | 1106 | 357 | 0.1864 | 6.6131 | 2021-02-15 05:24:49 | Sao Tome and Principe | |||
2681018 | 2681018 | 2021-02-13 | US | Texas | Reagan | 48383 | 319 | 8 | 0 | 357 | 31.36607041 | -101.5232659 | 2021-02-14 05:23:43 | Reagan, Texas, US |
2678096 | 2678096 | 2021-02-13 | Sao Tome and Principe | 1482 | 19 | 1106 | 357 | 0.1864 | 6.6131 | 2021-02-14 05:23:43 | Sao Tome and Principe | |||
1531364 | 1531364 | 2021-02-09 | US | West Virginia | Clay | 54015 | 361 | 4 | 0 | 357 | 38.46231092 | -81.07652217 | 2021-02-10 05:22:41 | Clay, West Virginia, US |
617155 | 617155 | 2021-02-08 | US | West Virginia | Clay | 54015 | 361 | 4 | 0 | 357 | 38.46231092 | -81.07652217 | 2021-02-09 05:23:30 | Clay, West Virginia, US |
1675924 | 1675924 | 2021-02-07 | US | West Virginia | Clay | 54015 | 361 | 4 | 0 | 357 | 38.46231092 | -81.07652217 | 2021-02-08 05:22:39 | Clay, West Virginia, US |
1591448 | 1591448 | 2021-02-05 | US | Vermont | Caledonia | 50005 | 361 | 4 | 0 | 357 | 44.46548598 | -72.10314651 | 2021-02-06 05:23:55 | Caledonia, Vermont, US |
1590563 | 1590563 | 2021-02-05 | US | North Dakota | Dunn | 38025 | 363 | 7 | 0 | 357 | 47.35423935 | -102.6160468 | 2021-02-06 05:23:55 | Dunn, North Dakota, US |
1589613 | 1589613 | 2021-02-05 | US | Kentucky | Menifee | 21165 | 368 | 11 | 0 | 357 | 37.94090733 | -83.59985712 | 2021-02-06 05:23:55 | Menifee, Kentucky, US |
792770 | 792770 | 2021-02-04 | US | North Dakota | Dunn | 38025 | 363 | 7 | 0 | 357 | 47.35423935 | -102.6160468 | 2021-02-05 05:22:38 | Dunn, North Dakota, US |
343005 | 343005 | 2021-02-03 | US | Puerto Rico | Florida | 72054 | 357 | 0 | 0 | 357 | 18.373715 | -66.560488 | 2021-02-04 05:22:26 | Florida, Puerto Rico, US |
342662 | 342662 | 2021-02-03 | US | North Dakota | Dunn | 38025 | 363 | 7 | 0 | 357 | 47.35423935 | -102.6160468 | 2021-02-04 05:22:26 | Dunn, North Dakota, US |
1687231 | 1687231 | 2021-02-02 | US | Puerto Rico | Florida | 72054 | 357 | 0 | 0 | 357 | 18.373715 | -66.560488 | 2021-02-03 05:22:52 | Florida, Puerto Rico, US |
1679201 | 1679201 | 2021-02-01 | US | Puerto Rico | Florida | 72054 | 357 | 0 | 0 | 357 | 18.373715 | -66.560488 | 2021-02-02 05:22:49 | Florida, Puerto Rico, US |
1461427 | 1461427 | 2021-01-31 | US | Michigan | Oscoda | 26135 | 375 | 18 | 0 | 357 | 44.68192279 | -84.12939244 | 2021-02-01 05:22:53 | Oscoda, Michigan, US |
2215322 | 2215322 | 2021-01-30 | United Kingdom | Turks and Caicos Islands | 1459 | 8 | 1094 | 357 | 21.694000000000006 | -71.7979 | 2021-01-31 05:22:42 | Turks and Caicos Islands, United Kingdom | ||
2213335 | 2213335 | 2021-01-30 | US | Michigan | Oscoda | 26135 | 375 | 18 | 0 | 357 | 44.68192279 | -84.12939244 | 2021-01-31 05:22:42 | Oscoda, Michigan, 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]);