johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
2,371 rows where deaths = 213 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: last_update (date)
These facets timed out: province_or_state
country_or_region >30
- US 1,917
- China 149
- Iceland 63
- Japan 39
- Russia 38
- Netherlands 23
- Colombia 14
- India 11
- Chile 10
- Germany 10
- Maldives 10
- Ukraine 9
- Canada 7
- Nicaragua 7
- Belize 4
- Grenada 4
- Morocco 4
- Pakistan 4
- Brazil 3
- Brunei 3
- Gabon 3
- Mauritius 3
- Mexico 3
- Bahrain 2
- Cabo Verde 2
- Italy 2
- Niger 2
- Peru 2
- Togo 2
- United Kingdom 2
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2753793 | 2753793 | 2022-12-29 | US | Georgia | Toombs | 13279 | 7866 | 213 | 0 | 32.12059861 | -82.32957247 | 2022-12-30 04:21:04 | Toombs, Georgia, US | |
2753223 | 2753223 | 2022-12-29 | Sweden | Jamtland Harjedalen | 35072 | 213 | 0 | 63.1712 | 14.9592 | 2022-12-30 04:21:04 | Jamtland Harjedalen, Sweden | |||
1074799 | 1074799 | 2022-12-28 | US | Georgia | Toombs | 13279 | 7866 | 213 | 0 | 32.12059861 | -82.32957247 | 2022-12-29 04:21:01 | Toombs, Georgia, US | |
330614 | 330614 | 2022-12-27 | US | Pennsylvania | Tioga | 42117 | 9956 | 213 | 0 | 41.77255149 | -77.25433032 | 2022-12-28 04:21:04 | Tioga, Pennsylvania, US | |
328796 | 328796 | 2022-12-27 | US | Georgia | Toombs | 13279 | 7855 | 213 | 0 | 32.12059861 | -82.32957247 | 2022-12-28 04:21:04 | Toombs, Georgia, US | |
220819 | 220819 | 2022-12-26 | US | South Carolina | Newberry | 45071 | 15799 | 213 | 0 | 34.28629098 | -81.59935761 | 2022-12-27 04:21:07 | Newberry, South Carolina, US | |
220687 | 220687 | 2022-12-26 | US | Pennsylvania | Tioga | 42117 | 9956 | 213 | 0 | 41.77255149 | -77.25433032 | 2022-12-27 04:21:07 | Tioga, Pennsylvania, US | |
218869 | 218869 | 2022-12-26 | US | Georgia | Toombs | 13279 | 7855 | 213 | 0 | 32.12059861 | -82.32957247 | 2022-12-27 04:21:07 | Toombs, Georgia, US | |
3225276 | 3225276 | 2022-12-25 | US | South Carolina | Newberry | 45071 | 15799 | 213 | 0 | 34.28629098 | -81.59935761 | 2022-12-26 04:21:06 | Newberry, South Carolina, US | |
3225144 | 3225144 | 2022-12-25 | US | Pennsylvania | Tioga | 42117 | 9956 | 213 | 0 | 41.77255149 | -77.25433032 | 2022-12-26 04:21:06 | Tioga, Pennsylvania, US | |
3223326 | 3223326 | 2022-12-25 | US | Georgia | Toombs | 13279 | 7855 | 213 | 0 | 32.12059861 | -82.32957247 | 2022-12-26 04:21:06 | Toombs, Georgia, US | |
1021190 | 1021190 | 2022-12-24 | US | South Carolina | Newberry | 45071 | 15799 | 213 | 0 | 34.28629098 | -81.59935761 | 2022-12-25 04:21:04 | Newberry, South Carolina, US | |
1021058 | 1021058 | 2022-12-24 | US | Pennsylvania | Tioga | 42117 | 9956 | 213 | 0 | 41.77255149 | -77.25433032 | 2022-12-25 04:21:04 | Tioga, Pennsylvania, US | |
1019240 | 1019240 | 2022-12-24 | US | Georgia | Toombs | 13279 | 7855 | 213 | 0 | 32.12059861 | -82.32957247 | 2022-12-25 04:21:04 | Toombs, Georgia, US | |
693213 | 693213 | 2022-12-23 | US | South Carolina | Newberry | 45071 | 15799 | 213 | 0 | 34.28629098 | -81.59935761 | 2022-12-24 04:21:02 | Newberry, South Carolina, US | |
693081 | 693081 | 2022-12-23 | US | Pennsylvania | Tioga | 42117 | 9956 | 213 | 0 | 41.77255149 | -77.25433032 | 2022-12-24 04:21:02 | Tioga, Pennsylvania, US | |
691263 | 691263 | 2022-12-23 | US | Georgia | Toombs | 13279 | 7855 | 213 | 0 | 32.12059861 | -82.32957247 | 2022-12-24 04:21:02 | Toombs, Georgia, US | |
2182423 | 2182423 | 2022-12-22 | US | South Carolina | Newberry | 45071 | 15799 | 213 | 0 | 34.28629098 | -81.59935761 | 2022-12-23 04:21:04 | Newberry, South Carolina, US | |
2182291 | 2182291 | 2022-12-22 | US | Pennsylvania | Tioga | 42117 | 9956 | 213 | 0 | 41.77255149 | -77.25433032 | 2022-12-23 04:21:04 | Tioga, Pennsylvania, US | |
2180473 | 2180473 | 2022-12-22 | US | Georgia | Toombs | 13279 | 7855 | 213 | 0 | 32.12059861 | -82.32957247 | 2022-12-23 04:21:04 | Toombs, Georgia, US | |
454227 | 454227 | 2022-12-21 | US | South Carolina | Newberry | 45071 | 15799 | 213 | 0 | 34.28629098 | -81.59935761 | 2022-12-22 04:20:56 | Newberry, South Carolina, US | |
454095 | 454095 | 2022-12-21 | US | Pennsylvania | Tioga | 42117 | 9956 | 213 | 0 | 41.77255149 | -77.25433032 | 2022-12-22 04:20:56 | Tioga, Pennsylvania, US | |
453142 | 453142 | 2022-12-21 | US | Minnesota | Olmsted | 27109 | 51652 | 213 | 0 | 44.00374114 | -92.40209944 | 2022-12-22 04:20:56 | Olmsted, Minnesota, US | |
452277 | 452277 | 2022-12-21 | US | Georgia | Toombs | 13279 | 7855 | 213 | 0 | 32.12059861 | -82.32957247 | 2022-12-22 04:20:56 | Toombs, Georgia, US | |
2954226 | 2954226 | 2022-12-20 | US | South Carolina | Newberry | 45071 | 15799 | 213 | 0 | 34.28629098 | -81.59935761 | 2022-12-21 04:21:03 | Newberry, South Carolina, US | |
2954094 | 2954094 | 2022-12-20 | US | Pennsylvania | Tioga | 42117 | 9912 | 213 | 0 | 41.77255149 | -77.25433032 | 2022-12-21 04:21:03 | Tioga, Pennsylvania, US | |
2953141 | 2953141 | 2022-12-20 | US | Minnesota | Olmsted | 27109 | 51652 | 213 | 0 | 44.00374114 | -92.40209944 | 2022-12-21 04:21:03 | Olmsted, Minnesota, US | |
3177132 | 3177132 | 2022-12-19 | US | Virginia | Franklin | 51067 | 13488 | 213 | 0 | 36.99536167 | -79.88023649 | 2022-12-20 04:21:04 | Franklin, Virginia, US | |
3176496 | 3176496 | 2022-12-19 | US | Pennsylvania | Tioga | 42117 | 9912 | 213 | 0 | 41.77255149 | -77.25433032 | 2022-12-20 04:21:04 | Tioga, Pennsylvania, US | |
3175543 | 3175543 | 2022-12-19 | US | Minnesota | Olmsted | 27109 | 51652 | 213 | 0 | 44.00374114 | -92.40209944 | 2022-12-20 04:21:04 | Olmsted, Minnesota, US | |
1631649 | 1631649 | 2022-12-18 | US | Virginia | Franklin | 51067 | 13468 | 213 | 0 | 36.99536167 | -79.88023649 | 2022-12-19 04:21:03 | Franklin, Virginia, US | |
1631013 | 1631013 | 2022-12-18 | US | Pennsylvania | Tioga | 42117 | 9912 | 213 | 0 | 41.77255149 | -77.25433032 | 2022-12-19 04:21:03 | Tioga, Pennsylvania, US | |
1630060 | 1630060 | 2022-12-18 | US | Minnesota | Olmsted | 27109 | 51652 | 213 | 0 | 44.00374114 | -92.40209944 | 2022-12-19 04:21:03 | Olmsted, Minnesota, US | |
507028 | 507028 | 2022-12-17 | US | Virginia | Franklin | 51067 | 13468 | 213 | 0 | 36.99536167 | -79.88023649 | 2022-12-18 04:21:03 | Franklin, Virginia, US | |
506392 | 506392 | 2022-12-17 | US | Pennsylvania | Tioga | 42117 | 9912 | 213 | 0 | 41.77255149 | -77.25433032 | 2022-12-18 04:21:03 | Tioga, Pennsylvania, US | |
505439 | 505439 | 2022-12-17 | US | Minnesota | Olmsted | 27109 | 51652 | 213 | 0 | 44.00374114 | -92.40209944 | 2022-12-18 04:21:03 | Olmsted, Minnesota, US | |
3327600 | 3327600 | 2022-12-16 | US | Virginia | Franklin | 51067 | 13468 | 213 | 0 | 36.99536167 | -79.88023649 | 2022-12-17 04:21:04 | Franklin, Virginia, US | |
3326964 | 3326964 | 2022-12-16 | US | Pennsylvania | Tioga | 42117 | 9912 | 213 | 0 | 41.77255149 | -77.25433032 | 2022-12-17 04:21:04 | Tioga, Pennsylvania, US | |
3326011 | 3326011 | 2022-12-16 | US | Minnesota | Olmsted | 27109 | 51652 | 213 | 0 | 44.00374114 | -92.40209944 | 2022-12-17 04:21:04 | Olmsted, Minnesota, US | |
546112 | 546112 | 2022-12-15 | US | Virginia | Franklin | 51067 | 13451 | 213 | 0 | 36.99536167 | -79.88023649 | 2022-12-16 04:21:01 | Franklin, Virginia, US | |
545476 | 545476 | 2022-12-15 | US | Pennsylvania | Tioga | 42117 | 9912 | 213 | 0 | 41.77255149 | -77.25433032 | 2022-12-16 04:21:01 | Tioga, Pennsylvania, US | |
544523 | 544523 | 2022-12-15 | US | Minnesota | Olmsted | 27109 | 51652 | 213 | 0 | 44.00374114 | -92.40209944 | 2022-12-16 04:21:01 | Olmsted, Minnesota, US | |
351640 | 351640 | 2022-12-14 | US | Virginia | Franklin | 51067 | 13440 | 213 | 0 | 36.99536167 | -79.88023649 | 2022-12-15 04:20:58 | Franklin, Virginia, US | |
351004 | 351004 | 2022-12-14 | US | Pennsylvania | Tioga | 42117 | 9912 | 213 | 0 | 41.77255149 | -77.25433032 | 2022-12-15 04:20:58 | Tioga, Pennsylvania, US | |
311228 | 311228 | 2022-12-13 | US | Virginia | Franklin | 51067 | 13423 | 213 | 0 | 36.99536167 | -79.88023649 | 2022-12-14 04:21:04 | Franklin, Virginia, US | |
310592 | 310592 | 2022-12-13 | US | Pennsylvania | Tioga | 42117 | 9890 | 213 | 0 | 41.77255149 | -77.25433032 | 2022-12-14 04:21:04 | Tioga, Pennsylvania, US | |
1152289 | 1152289 | 2022-12-12 | US | Virginia | Franklin | 51067 | 13420 | 213 | 0 | 36.99536167 | -79.88023649 | 2022-12-13 04:21:01 | Franklin, Virginia, US | |
1151653 | 1151653 | 2022-12-12 | US | Pennsylvania | Tioga | 42117 | 9890 | 213 | 0 | 41.77255149 | -77.25433032 | 2022-12-13 04:21:01 | Tioga, Pennsylvania, US | |
1148973 | 1148973 | 2022-12-12 | Japan | Toyama | 180084 | 213 | 0 | 36.637464 | 137.269346 | 2022-12-13 04:21:01 | Toyama, Japan | |||
872143 | 872143 | 2022-12-11 | US | Virginia | Franklin | 51067 | 13411 | 213 | 0 | 36.99536167 | -79.88023649 | 2022-12-12 04:21:01 | Franklin, Virginia, US | |
871507 | 871507 | 2022-12-11 | US | Pennsylvania | Tioga | 42117 | 9890 | 213 | 0 | 41.77255149 | -77.25433032 | 2022-12-12 04:21:01 | Tioga, Pennsylvania, US | |
868827 | 868827 | 2022-12-11 | Japan | Toyama | 179708 | 213 | 0 | 36.637464 | 137.269346 | 2022-12-12 04:21:01 | Toyama, Japan | |||
260673 | 260673 | 2022-12-10 | US | Virginia | Franklin | 51067 | 13411 | 213 | 0 | 36.99536167 | -79.88023649 | 2022-12-11 04:20:50 | Franklin, Virginia, US | |
260037 | 260037 | 2022-12-10 | US | Pennsylvania | Tioga | 42117 | 9890 | 213 | 0 | 41.77255149 | -77.25433032 | 2022-12-11 04:20:50 | Tioga, Pennsylvania, US | |
3939387 | 3939387 | 2022-12-09 | US | Virginia | Franklin | 51067 | 13411 | 213 | 0 | 36.99536167 | -79.88023649 | 2022-12-10 04:21:02 | Franklin, Virginia, US | |
3938751 | 3938751 | 2022-12-09 | US | Pennsylvania | Tioga | 42117 | 9890 | 213 | 0 | 41.77255149 | -77.25433032 | 2022-12-10 04:21:02 | Tioga, Pennsylvania, US | |
3380719 | 3380719 | 2022-12-08 | US | Virginia | Franklin | 51067 | 13396 | 213 | 0 | 36.99536167 | -79.88023649 | 2022-12-09 04:21:05 | Franklin, Virginia, US | |
3380083 | 3380083 | 2022-12-08 | US | Pennsylvania | Tioga | 42117 | 9890 | 213 | 0 | 41.77255149 | -77.25433032 | 2022-12-09 04:21:05 | Tioga, Pennsylvania, US | |
1987990 | 1987990 | 2022-12-07 | US | Virginia | Franklin | 51067 | 13382 | 213 | 0 | 36.99536167 | -79.88023649 | 2022-12-08 04:21:07 | Franklin, Virginia, US | |
1987354 | 1987354 | 2022-12-07 | US | Pennsylvania | Tioga | 42117 | 9890 | 213 | 0 | 41.77255149 | -77.25433032 | 2022-12-08 04:21:07 | Tioga, Pennsylvania, US | |
3717513 | 3717513 | 2022-12-06 | US | Virginia | Franklin | 51067 | 13376 | 213 | 0 | 36.99536167 | -79.88023649 | 2022-12-07 04:20:58 | Franklin, Virginia, US | |
2418218 | 2418218 | 2022-12-05 | US | Virginia | Franklin | 51067 | 13366 | 213 | 0 | 36.99536167 | -79.88023649 | 2022-12-06 04:21:03 | Franklin, Virginia, US | |
721826 | 721826 | 2022-12-04 | US | Virginia | Franklin | 51067 | 13348 | 213 | 0 | 36.99536167 | -79.88023649 | 2022-12-05 04:20:58 | Franklin, Virginia, US | |
2820115 | 2820115 | 2022-12-03 | US | Virginia | Franklin | 51067 | 13348 | 213 | 0 | 36.99536167 | -79.88023649 | 2022-12-04 04:20:56 | Franklin, Virginia, US | |
836971 | 836971 | 2022-12-02 | US | Virginia | Franklin | 51067 | 13348 | 213 | 0 | 36.99536167 | -79.88023649 | 2022-12-03 04:21:02 | Franklin, Virginia, US | |
2139501 | 2139501 | 2022-12-01 | US | Virginia | Franklin | 51067 | 13339 | 213 | 0 | 36.99536167 | -79.88023649 | 2022-12-02 04:21:07 | Franklin, Virginia, US | |
2139460 | 2139460 | 2022-12-01 | US | Virginia | Alexandria | 51510 | 42939 | 213 | 0 | 38.814003 | -77.08183073 | 2022-12-02 04:21:07 | Alexandria, Virginia, US | |
2136182 | 2136182 | 2022-12-01 | Japan | Tokushima | 108431 | 213 | 0 | 33.919178 | 134.242091 | 2022-12-02 04:21:07 | Tokushima, Japan | |||
1967917 | 1967917 | 2022-11-30 | US | Virginia | Franklin | 51067 | 13333 | 213 | 0 | 36.99536167 | -79.88023649 | 2022-12-01 04:21:03 | Franklin, Virginia, US | |
1967876 | 1967876 | 2022-11-30 | US | Virginia | Alexandria | 51510 | 42900 | 213 | 0 | 38.814003 | -77.08183073 | 2022-12-01 04:21:03 | Alexandria, Virginia, US | |
2559931 | 2559931 | 2022-11-29 | US | Virginia | Franklin | 51067 | 13326 | 213 | 0 | 36.99536167 | -79.88023649 | 2022-11-30 04:21:07 | Franklin, Virginia, US | |
2559890 | 2559890 | 2022-11-29 | US | Virginia | Alexandria | 51510 | 42861 | 213 | 0 | 38.814003 | -77.08183073 | 2022-11-30 04:21:07 | Alexandria, Virginia, US | |
1243005 | 1243005 | 2022-11-28 | US | Virginia | Franklin | 51067 | 13320 | 213 | 0 | 36.99536167 | -79.88023649 | 2022-11-29 04:21:05 | Franklin, Virginia, US | |
1242964 | 1242964 | 2022-11-28 | US | Virginia | Alexandria | 51510 | 42828 | 213 | 0 | 38.814003 | -77.08183073 | 2022-11-29 04:21:05 | Alexandria, Virginia, US | |
3554993 | 3554993 | 2022-11-27 | US | Virginia | Franklin | 51067 | 13314 | 213 | 0 | 36.99536167 | -79.88023649 | 2022-11-28 04:21:02 | Franklin, Virginia, US | |
3554952 | 3554952 | 2022-11-27 | US | Virginia | Alexandria | 51510 | 42774 | 213 | 0 | 38.814003 | -77.08183073 | 2022-11-28 04:21:02 | Alexandria, Virginia, US | |
2103473 | 2103473 | 2022-11-26 | US | Virginia | Franklin | 51067 | 13314 | 213 | 0 | 36.99536167 | -79.88023649 | 2022-11-27 04:21:05 | Franklin, Virginia, US | |
2103432 | 2103432 | 2022-11-26 | US | Virginia | Alexandria | 51510 | 42774 | 213 | 0 | 38.814003 | -77.08183073 | 2022-11-27 04:21:05 | Alexandria, Virginia, US | |
490964 | 490964 | 2022-11-25 | US | Virginia | Franklin | 51067 | 13314 | 213 | 0 | 36.99536167 | -79.88023649 | 2022-11-26 04:21:11 | Franklin, Virginia, US | |
490923 | 490923 | 2022-11-25 | US | Virginia | Alexandria | 51510 | 42774 | 213 | 0 | 38.814003 | -77.08183073 | 2022-11-26 04:21:11 | Alexandria, Virginia, US | |
3526793 | 3526793 | 2022-11-24 | US | Virginia | Franklin | 51067 | 13304 | 213 | 0 | 36.99536167 | -79.88023649 | 2022-11-25 04:21:06 | Franklin, Virginia, US | |
3526752 | 3526752 | 2022-11-24 | US | Virginia | Alexandria | 51510 | 42730 | 213 | 0 | 38.814003 | -77.08183073 | 2022-11-25 04:21:06 | Alexandria, Virginia, US | |
3315576 | 3315576 | 2022-11-23 | US | Virginia | Franklin | 51067 | 13304 | 213 | 0 | 36.99536167 | -79.88023649 | 2022-11-24 04:21:09 | Franklin, Virginia, US | |
3315535 | 3315535 | 2022-11-23 | US | Virginia | Alexandria | 51510 | 42730 | 213 | 0 | 38.814003 | -77.08183073 | 2022-11-24 04:21:09 | Alexandria, Virginia, US | |
1623617 | 1623617 | 2022-11-22 | US | Virginia | Franklin | 51067 | 13304 | 213 | 0 | 36.99536167 | -79.88023649 | 2022-11-23 04:21:06 | Franklin, Virginia, US | |
1623576 | 1623576 | 2022-11-22 | US | Virginia | Alexandria | 51510 | 42695 | 213 | 0 | 38.814003 | -77.08183073 | 2022-11-23 04:21:06 | Alexandria, Virginia, US | |
1643778 | 1643778 | 2022-11-20 | US | Virginia | Wise | 51195 | 13142 | 213 | 0 | 36.9746148 | -82.62410519 | 2022-11-21 04:21:05 | Wise, Virginia, US | |
1643690 | 1643690 | 2022-11-20 | US | Virginia | Franklin | 51067 | 13297 | 213 | 0 | 36.99536167 | -79.88023649 | 2022-11-21 04:21:05 | Franklin, Virginia, US | |
2067335 | 2067335 | 2022-11-19 | US | Virginia | Wise | 51195 | 13142 | 213 | 0 | 36.9746148 | -82.62410519 | 2022-11-20 04:21:08 | Wise, Virginia, US | |
2067247 | 2067247 | 2022-11-19 | US | Virginia | Franklin | 51067 | 13297 | 213 | 0 | 36.99536167 | -79.88023649 | 2022-11-20 04:21:08 | Franklin, Virginia, US | |
1758729 | 1758729 | 2022-11-18 | US | Virginia | Wise | 51195 | 13142 | 213 | 0 | 36.9746148 | -82.62410519 | 2022-11-19 04:21:14 | Wise, Virginia, US | |
1758641 | 1758641 | 2022-11-18 | US | Virginia | Franklin | 51067 | 13297 | 213 | 0 | 36.99536167 | -79.88023649 | 2022-11-19 04:21:14 | Franklin, Virginia, US | |
3029722 | 3029722 | 2022-11-17 | US | Virginia | Wise | 51195 | 13118 | 213 | 0 | 36.9746148 | -82.62410519 | 2022-11-18 04:21:15 | Wise, Virginia, US | |
3029634 | 3029634 | 2022-11-17 | US | Virginia | Franklin | 51067 | 13284 | 213 | 0 | 36.99536167 | -79.88023649 | 2022-11-18 04:21:15 | Franklin, Virginia, US | |
2489433 | 2489433 | 2022-11-16 | US | Virginia | Wise | 51195 | 13116 | 213 | 0 | 36.9746148 | -82.62410519 | 2022-11-17 04:21:11 | Wise, Virginia, US | |
2489345 | 2489345 | 2022-11-16 | US | Virginia | Franklin | 51067 | 13278 | 213 | 0 | 36.99536167 | -79.88023649 | 2022-11-17 04:21:11 | Franklin, Virginia, US | |
295444 | 295444 | 2022-11-15 | US | Virginia | Wise | 51195 | 13116 | 213 | 0 | 36.9746148 | -82.62410519 | 2022-11-16 04:21:09 | Wise, Virginia, US | |
294983 | 294983 | 2022-11-15 | US | Tennessee | Loudon | 47105 | 17623 | 213 | 0 | 35.73939663 | -84.31145275 | 2022-11-16 04:21:09 | Loudon, Tennessee, US | |
3600474 | 3600474 | 2022-11-14 | US | Virginia | Wise | 51195 | 13087 | 213 | 0 | 36.9746148 | -82.62410519 | 2022-11-15 04:21:16 | Wise, Virginia, US | |
3600013 | 3600013 | 2022-11-14 | US | Tennessee | Loudon | 47105 | 17614 | 213 | 0 | 35.73939663 | -84.31145275 | 2022-11-15 04:21:16 | Loudon, 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]);