johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
2,356 rows where deaths = 224 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 2,041
- Spain 55
- Sweden 35
- Netherlands 28
- Russia 28
- Germany 25
- Japan 23
- Colombia 15
- India 10
- Zimbabwe 8
- Chile 7
- Nicaragua 7
- Brazil 5
- Malaysia 5
- Mexico 5
- Peru 5
- Ukraine 4
- Australia 3
- France 3
- Gabon 3
- Qatar 3
- Saint Lucia 3
- United Kingdom 3
- Brunei 2
- Congo (Kinshasa) 2
- Pakistan 2
- Afghanistan 1
- Bahrain 1
- Belarus 1
- Belize 1
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2755364 | 2755364 | 2022-12-29 | US | Ohio | Crawford | 39033 | 13888 | 224 | 0 | 40.85065156 | -82.91989099 | 2022-12-30 04:21:04 | Crawford, Ohio, US | |
2755165 | 2755165 | 2022-12-29 | US | New York | Oswego | 36075 | 33690 | 224 | 0 | 43.42778894 | -76.14635194 | 2022-12-30 04:21:04 | Oswego, New York, US | |
1076370 | 1076370 | 2022-12-28 | US | Ohio | Crawford | 39033 | 13829 | 224 | 0 | 40.85065156 | -82.91989099 | 2022-12-29 04:21:01 | Crawford, Ohio, US | |
1076171 | 1076171 | 2022-12-28 | US | New York | Oswego | 36075 | 33682 | 224 | 0 | 43.42778894 | -76.14635194 | 2022-12-29 04:21:01 | Oswego, New York, US | |
330367 | 330367 | 2022-12-27 | US | Ohio | Crawford | 39033 | 13829 | 224 | 0 | 40.85065156 | -82.91989099 | 2022-12-28 04:21:04 | Crawford, Ohio, US | |
220440 | 220440 | 2022-12-26 | US | Ohio | Crawford | 39033 | 13829 | 224 | 0 | 40.85065156 | -82.91989099 | 2022-12-27 04:21:07 | Crawford, Ohio, US | |
3224897 | 3224897 | 2022-12-25 | US | Ohio | Crawford | 39033 | 13829 | 224 | 0 | 40.85065156 | -82.91989099 | 2022-12-26 04:21:06 | Crawford, Ohio, US | |
1020811 | 1020811 | 2022-12-24 | US | Ohio | Crawford | 39033 | 13829 | 224 | 0 | 40.85065156 | -82.91989099 | 2022-12-25 04:21:04 | Crawford, Ohio, US | |
692834 | 692834 | 2022-12-23 | US | Ohio | Crawford | 39033 | 13829 | 224 | 0 | 40.85065156 | -82.91989099 | 2022-12-24 04:21:02 | Crawford, Ohio, US | |
2182044 | 2182044 | 2022-12-22 | US | Ohio | Crawford | 39033 | 13829 | 224 | 0 | 40.85065156 | -82.91989099 | 2022-12-23 04:21:04 | Crawford, Ohio, US | |
453848 | 453848 | 2022-12-21 | US | Ohio | Crawford | 39033 | 13761 | 224 | 0 | 40.85065156 | -82.91989099 | 2022-12-22 04:20:56 | Crawford, Ohio, US | |
2953847 | 2953847 | 2022-12-20 | US | Ohio | Crawford | 39033 | 13761 | 224 | 0 | 40.85065156 | -82.91989099 | 2022-12-21 04:21:03 | Crawford, Ohio, US | |
3176249 | 3176249 | 2022-12-19 | US | Ohio | Crawford | 39033 | 13761 | 224 | 0 | 40.85065156 | -82.91989099 | 2022-12-20 04:21:04 | Crawford, Ohio, US | |
1630766 | 1630766 | 2022-12-18 | US | Ohio | Crawford | 39033 | 13761 | 224 | 0 | 40.85065156 | -82.91989099 | 2022-12-19 04:21:03 | Crawford, Ohio, US | |
506145 | 506145 | 2022-12-17 | US | Ohio | Crawford | 39033 | 13761 | 224 | 0 | 40.85065156 | -82.91989099 | 2022-12-18 04:21:03 | Crawford, Ohio, US | |
3326717 | 3326717 | 2022-12-16 | US | Ohio | Crawford | 39033 | 13761 | 224 | 0 | 40.85065156 | -82.91989099 | 2022-12-17 04:21:04 | Crawford, Ohio, US | |
545229 | 545229 | 2022-12-15 | US | Ohio | Crawford | 39033 | 13761 | 224 | 0 | 40.85065156 | -82.91989099 | 2022-12-16 04:21:01 | Crawford, Ohio, US | |
350757 | 350757 | 2022-12-14 | US | Ohio | Crawford | 39033 | 13679 | 224 | 0 | 40.85065156 | -82.91989099 | 2022-12-15 04:20:58 | Crawford, Ohio, US | |
310345 | 310345 | 2022-12-13 | US | Ohio | Crawford | 39033 | 13679 | 224 | 0 | 40.85065156 | -82.91989099 | 2022-12-14 04:21:04 | Crawford, Ohio, US | |
1151406 | 1151406 | 2022-12-12 | US | Ohio | Crawford | 39033 | 13679 | 224 | 0 | 40.85065156 | -82.91989099 | 2022-12-13 04:21:01 | Crawford, Ohio, US | |
871260 | 871260 | 2022-12-11 | US | Ohio | Crawford | 39033 | 13679 | 224 | 0 | 40.85065156 | -82.91989099 | 2022-12-12 04:21:01 | Crawford, Ohio, US | |
259790 | 259790 | 2022-12-10 | US | Ohio | Crawford | 39033 | 13679 | 224 | 0 | 40.85065156 | -82.91989099 | 2022-12-11 04:20:50 | Crawford, Ohio, US | |
3936068 | 3936068 | 2022-12-09 | Japan | Tokushima | 112670 | 224 | 0 | 33.919178 | 134.242091 | 2022-12-10 04:21:02 | Tokushima, Japan | |||
3378341 | 3378341 | 2022-12-08 | US | Illinois | Adams | 17001 | 26794 | 224 | 0 | 39.98815591 | -91.18786813 | 2022-12-09 04:21:05 | Adams, Illinois, US | |
3377400 | 3377400 | 2022-12-08 | Japan | Tokushima | 112054 | 224 | 0 | 33.919178 | 134.242091 | 2022-12-09 04:21:05 | Tokushima, Japan | |||
1985612 | 1985612 | 2022-12-07 | US | Illinois | Adams | 17001 | 26760 | 224 | 0 | 39.98815591 | -91.18786813 | 2022-12-08 04:21:07 | Adams, Illinois, US | |
1985170 | 1985170 | 2022-12-07 | US | Arkansas | Pope | 5115 | 20523 | 224 | 0 | 35.44871474 | -93.03212219 | 2022-12-08 04:21:07 | Pope, Arkansas, US | |
1984671 | 1984671 | 2022-12-07 | Japan | Tokushima | 111315 | 224 | 0 | 33.919178 | 134.242091 | 2022-12-08 04:21:07 | Tokushima, Japan | |||
3717614 | 3717614 | 2022-12-06 | US | Washington | Franklin | 53021 | 36273 | 224 | 0 | 46.53351425 | -118.9018212 | 2022-12-07 04:20:58 | Franklin, Washington, US | |
3717137 | 3717137 | 2022-12-06 | US | Tennessee | Lawrence | 47099 | 16503 | 224 | 0 | 35.21675201 | -87.39787695 | 2022-12-07 04:20:58 | Lawrence, Tennessee, US | |
3715135 | 3715135 | 2022-12-06 | US | Illinois | Adams | 17001 | 26719 | 224 | 0 | 39.98815591 | -91.18786813 | 2022-12-07 04:20:58 | Adams, Illinois, US | |
3714693 | 3714693 | 2022-12-06 | US | Arkansas | Pope | 5115 | 20518 | 224 | 0 | 35.44871474 | -93.03212219 | 2022-12-07 04:20:58 | Pope, Arkansas, US | |
2418319 | 2418319 | 2022-12-05 | US | Washington | Franklin | 53021 | 36273 | 224 | 0 | 46.53351425 | -118.9018212 | 2022-12-06 04:21:03 | Franklin, Washington, US | |
2417842 | 2417842 | 2022-12-05 | US | Tennessee | Lawrence | 47099 | 16494 | 224 | 0 | 35.21675201 | -87.39787695 | 2022-12-06 04:21:03 | Lawrence, Tennessee, US | |
2415840 | 2415840 | 2022-12-05 | US | Illinois | Adams | 17001 | 26690 | 224 | 0 | 39.98815591 | -91.18786813 | 2022-12-06 04:21:03 | Adams, Illinois, US | |
2415398 | 2415398 | 2022-12-05 | US | Arkansas | Pope | 5115 | 20511 | 224 | 0 | 35.44871474 | -93.03212219 | 2022-12-06 04:21:03 | Pope, Arkansas, US | |
721927 | 721927 | 2022-12-04 | US | Washington | Franklin | 53021 | 36273 | 224 | 0 | 46.53351425 | -118.9018212 | 2022-12-05 04:20:58 | Franklin, Washington, US | |
721450 | 721450 | 2022-12-04 | US | Tennessee | Lawrence | 47099 | 16470 | 224 | 0 | 35.21675201 | -87.39787695 | 2022-12-05 04:20:58 | Lawrence, Tennessee, US | |
719448 | 719448 | 2022-12-04 | US | Illinois | Adams | 17001 | 26643 | 224 | 0 | 39.98815591 | -91.18786813 | 2022-12-05 04:20:58 | Adams, Illinois, US | |
719006 | 719006 | 2022-12-04 | US | Arkansas | Pope | 5115 | 20506 | 224 | 0 | 35.44871474 | -93.03212219 | 2022-12-05 04:20:58 | Pope, Arkansas, US | |
2820216 | 2820216 | 2022-12-03 | US | Washington | Franklin | 53021 | 36273 | 224 | 0 | 46.53351425 | -118.9018212 | 2022-12-04 04:20:56 | Franklin, Washington, US | |
2819739 | 2819739 | 2022-12-03 | US | Tennessee | Lawrence | 47099 | 16470 | 224 | 0 | 35.21675201 | -87.39787695 | 2022-12-04 04:20:56 | Lawrence, Tennessee, US | |
2817737 | 2817737 | 2022-12-03 | US | Illinois | Adams | 17001 | 26643 | 224 | 0 | 39.98815591 | -91.18786813 | 2022-12-04 04:20:56 | Adams, Illinois, US | |
2817295 | 2817295 | 2022-12-03 | US | Arkansas | Pope | 5115 | 20499 | 224 | 0 | 35.44871474 | -93.03212219 | 2022-12-04 04:20:56 | Pope, Arkansas, US | |
837072 | 837072 | 2022-12-02 | US | Washington | Franklin | 53021 | 36273 | 224 | 0 | 46.53351425 | -118.9018212 | 2022-12-03 04:21:02 | Franklin, Washington, US | |
836595 | 836595 | 2022-12-02 | US | Tennessee | Lawrence | 47099 | 16466 | 224 | 0 | 35.21675201 | -87.39787695 | 2022-12-03 04:21:02 | Lawrence, Tennessee, US | |
834593 | 834593 | 2022-12-02 | US | Illinois | Adams | 17001 | 26643 | 224 | 0 | 39.98815591 | -91.18786813 | 2022-12-03 04:21:02 | Adams, Illinois, US | |
834151 | 834151 | 2022-12-02 | US | Arkansas | Pope | 5115 | 20491 | 224 | 0 | 35.44871474 | -93.03212219 | 2022-12-03 04:21:02 | Pope, Arkansas, US | |
2139602 | 2139602 | 2022-12-01 | US | Washington | Franklin | 53021 | 36273 | 224 | 0 | 46.53351425 | -118.9018212 | 2022-12-02 04:21:07 | Franklin, Washington, US | |
2139125 | 2139125 | 2022-12-01 | US | Tennessee | Lawrence | 47099 | 16459 | 224 | 0 | 35.21675201 | -87.39787695 | 2022-12-02 04:21:07 | Lawrence, Tennessee, US | |
2137123 | 2137123 | 2022-12-01 | US | Illinois | Adams | 17001 | 26602 | 224 | 0 | 39.98815591 | -91.18786813 | 2022-12-02 04:21:07 | Adams, Illinois, US | |
2136681 | 2136681 | 2022-12-01 | US | Arkansas | Pope | 5115 | 20483 | 224 | 0 | 35.44871474 | -93.03212219 | 2022-12-02 04:21:07 | Pope, Arkansas, US | |
1968018 | 1968018 | 2022-11-30 | US | Washington | Franklin | 53021 | 36273 | 224 | 0 | 46.53351425 | -118.9018212 | 2022-12-01 04:21:03 | Franklin, Washington, US | |
1967541 | 1967541 | 2022-11-30 | US | Tennessee | Lawrence | 47099 | 16450 | 224 | 0 | 35.21675201 | -87.39787695 | 2022-12-01 04:21:03 | Lawrence, Tennessee, US | |
1967142 | 1967142 | 2022-11-30 | US | Oklahoma | Kay | 40071 | 14442 | 224 | 0 | 36.81799745 | -97.14421435 | 2022-12-01 04:21:03 | Kay, Oklahoma, US | |
1965539 | 1965539 | 2022-11-30 | US | Illinois | Adams | 17001 | 26579 | 224 | 0 | 39.98815591 | -91.18786813 | 2022-12-01 04:21:03 | Adams, Illinois, US | |
1965097 | 1965097 | 2022-11-30 | US | Arkansas | Pope | 5115 | 20473 | 224 | 0 | 35.44871474 | -93.03212219 | 2022-12-01 04:21:03 | Pope, Arkansas, US | |
2560032 | 2560032 | 2022-11-29 | US | Washington | Franklin | 53021 | 36234 | 224 | 0 | 46.53351425 | -118.9018212 | 2022-11-30 04:21:07 | Franklin, Washington, US | |
2559555 | 2559555 | 2022-11-29 | US | Tennessee | Lawrence | 47099 | 16441 | 224 | 0 | 35.21675201 | -87.39787695 | 2022-11-30 04:21:07 | Lawrence, Tennessee, US | |
2559156 | 2559156 | 2022-11-29 | US | Oklahoma | Kay | 40071 | 14442 | 224 | 0 | 36.81799745 | -97.14421435 | 2022-11-30 04:21:07 | Kay, Oklahoma, US | |
2557553 | 2557553 | 2022-11-29 | US | Illinois | Adams | 17001 | 26514 | 224 | 0 | 39.98815591 | -91.18786813 | 2022-11-30 04:21:07 | Adams, Illinois, US | |
2557111 | 2557111 | 2022-11-29 | US | Arkansas | Pope | 5115 | 20463 | 224 | 0 | 35.44871474 | -93.03212219 | 2022-11-30 04:21:07 | Pope, Arkansas, US | |
1243106 | 1243106 | 2022-11-28 | US | Washington | Franklin | 53021 | 36234 | 224 | 0 | 46.53351425 | -118.9018212 | 2022-11-29 04:21:05 | Franklin, Washington, US | |
1242629 | 1242629 | 2022-11-28 | US | Tennessee | Lawrence | 47099 | 16432 | 224 | 0 | 35.21675201 | -87.39787695 | 2022-11-29 04:21:05 | Lawrence, Tennessee, US | |
1242230 | 1242230 | 2022-11-28 | US | Oklahoma | Kay | 40071 | 14442 | 224 | 0 | 36.81799745 | -97.14421435 | 2022-11-29 04:21:05 | Kay, Oklahoma, US | |
1240627 | 1240627 | 2022-11-28 | US | Illinois | Adams | 17001 | 26475 | 224 | 0 | 39.98815591 | -91.18786813 | 2022-11-29 04:21:05 | Adams, Illinois, US | |
1240185 | 1240185 | 2022-11-28 | US | Arkansas | Pope | 5115 | 20458 | 224 | 0 | 35.44871474 | -93.03212219 | 2022-11-29 04:21:05 | Pope, Arkansas, US | |
3555094 | 3555094 | 2022-11-27 | US | Washington | Franklin | 53021 | 36234 | 224 | 0 | 46.53351425 | -118.9018212 | 2022-11-28 04:21:02 | Franklin, Washington, US | |
3554617 | 3554617 | 2022-11-27 | US | Tennessee | Lawrence | 47099 | 16418 | 224 | 0 | 35.21675201 | -87.39787695 | 2022-11-28 04:21:02 | Lawrence, Tennessee, US | |
3554218 | 3554218 | 2022-11-27 | US | Oklahoma | Kay | 40071 | 14442 | 224 | 0 | 36.81799745 | -97.14421435 | 2022-11-28 04:21:02 | Kay, Oklahoma, US | |
3552615 | 3552615 | 2022-11-27 | US | Illinois | Adams | 17001 | 26413 | 224 | 0 | 39.98815591 | -91.18786813 | 2022-11-28 04:21:02 | Adams, Illinois, US | |
3552173 | 3552173 | 2022-11-27 | US | Arkansas | Pope | 5115 | 20457 | 224 | 0 | 35.44871474 | -93.03212219 | 2022-11-28 04:21:02 | Pope, Arkansas, US | |
2103574 | 2103574 | 2022-11-26 | US | Washington | Franklin | 53021 | 36234 | 224 | 0 | 46.53351425 | -118.9018212 | 2022-11-27 04:21:05 | Franklin, Washington, US | |
2103097 | 2103097 | 2022-11-26 | US | Tennessee | Lawrence | 47099 | 16409 | 224 | 0 | 35.21675201 | -87.39787695 | 2022-11-27 04:21:05 | Lawrence, Tennessee, US | |
2102698 | 2102698 | 2022-11-26 | US | Oklahoma | Kay | 40071 | 14442 | 224 | 0 | 36.81799745 | -97.14421435 | 2022-11-27 04:21:05 | Kay, Oklahoma, US | |
2101095 | 2101095 | 2022-11-26 | US | Illinois | Adams | 17001 | 26413 | 224 | 0 | 39.98815591 | -91.18786813 | 2022-11-27 04:21:05 | Adams, Illinois, US | |
2100653 | 2100653 | 2022-11-26 | US | Arkansas | Pope | 5115 | 20452 | 224 | 0 | 35.44871474 | -93.03212219 | 2022-11-27 04:21:05 | Pope, Arkansas, US | |
491065 | 491065 | 2022-11-25 | US | Washington | Franklin | 53021 | 36234 | 224 | 0 | 46.53351425 | -118.9018212 | 2022-11-26 04:21:11 | Franklin, Washington, US | |
490588 | 490588 | 2022-11-25 | US | Tennessee | Lawrence | 47099 | 16409 | 224 | 0 | 35.21675201 | -87.39787695 | 2022-11-26 04:21:11 | Lawrence, Tennessee, US | |
490189 | 490189 | 2022-11-25 | US | Oklahoma | Kay | 40071 | 14442 | 224 | 0 | 36.81799745 | -97.14421435 | 2022-11-26 04:21:11 | Kay, Oklahoma, US | |
488586 | 488586 | 2022-11-25 | US | Illinois | Adams | 17001 | 26413 | 224 | 0 | 39.98815591 | -91.18786813 | 2022-11-26 04:21:11 | Adams, Illinois, US | |
488144 | 488144 | 2022-11-25 | US | Arkansas | Pope | 5115 | 20448 | 224 | 0 | 35.44871474 | -93.03212219 | 2022-11-26 04:21:11 | Pope, Arkansas, US | |
3526894 | 3526894 | 2022-11-24 | US | Washington | Franklin | 53021 | 36234 | 224 | 0 | 46.53351425 | -118.9018212 | 2022-11-25 04:21:06 | Franklin, Washington, US | |
3526417 | 3526417 | 2022-11-24 | US | Tennessee | Lawrence | 47099 | 16406 | 224 | 0 | 35.21675201 | -87.39787695 | 2022-11-25 04:21:06 | Lawrence, Tennessee, US | |
3526018 | 3526018 | 2022-11-24 | US | Oklahoma | Kay | 40071 | 14442 | 224 | 0 | 36.81799745 | -97.14421435 | 2022-11-25 04:21:06 | Kay, Oklahoma, US | |
3524415 | 3524415 | 2022-11-24 | US | Illinois | Adams | 17001 | 26413 | 224 | 0 | 39.98815591 | -91.18786813 | 2022-11-25 04:21:06 | Adams, Illinois, US | |
3523973 | 3523973 | 2022-11-24 | US | Arkansas | Pope | 5115 | 20446 | 224 | 0 | 35.44871474 | -93.03212219 | 2022-11-25 04:21:06 | Pope, Arkansas, US | |
3315677 | 3315677 | 2022-11-23 | US | Washington | Franklin | 53021 | 36234 | 224 | 0 | 46.53351425 | -118.9018212 | 2022-11-24 04:21:09 | Franklin, Washington, US | |
3315200 | 3315200 | 2022-11-23 | US | Tennessee | Lawrence | 47099 | 16405 | 224 | 0 | 35.21675201 | -87.39787695 | 2022-11-24 04:21:09 | Lawrence, Tennessee, US | |
3314827 | 3314827 | 2022-11-23 | US | Oklahoma | Pittsburg | 40121 | 13096 | 224 | 0 | 34.92065823 | -95.7513432 | 2022-11-24 04:21:09 | Pittsburg, Oklahoma, US | |
3314801 | 3314801 | 2022-11-23 | US | Oklahoma | Kay | 40071 | 14425 | 224 | 0 | 36.81799745 | -97.14421435 | 2022-11-24 04:21:09 | Kay, Oklahoma, US | |
3313198 | 3313198 | 2022-11-23 | US | Illinois | Adams | 17001 | 26413 | 224 | 0 | 39.98815591 | -91.18786813 | 2022-11-24 04:21:09 | Adams, Illinois, US | |
3312756 | 3312756 | 2022-11-23 | US | Arkansas | Pope | 5115 | 20439 | 224 | 0 | 35.44871474 | -93.03212219 | 2022-11-24 04:21:09 | Pope, Arkansas, US | |
1623718 | 1623718 | 2022-11-22 | US | Washington | Franklin | 53021 | 36194 | 224 | 0 | 46.53351425 | -118.9018212 | 2022-11-23 04:21:06 | Franklin, Washington, US | |
1623241 | 1623241 | 2022-11-22 | US | Tennessee | Lawrence | 47099 | 16400 | 224 | 0 | 35.21675201 | -87.39787695 | 2022-11-23 04:21:06 | Lawrence, Tennessee, US | |
1622868 | 1622868 | 2022-11-22 | US | Oklahoma | Pittsburg | 40121 | 13096 | 224 | 0 | 34.92065823 | -95.7513432 | 2022-11-23 04:21:06 | Pittsburg, Oklahoma, US | |
1622842 | 1622842 | 2022-11-22 | US | Oklahoma | Kay | 40071 | 14425 | 224 | 0 | 36.81799745 | -97.14421435 | 2022-11-23 04:21:06 | Kay, Oklahoma, US | |
1621239 | 1621239 | 2022-11-22 | US | Illinois | Adams | 17001 | 26384 | 224 | 0 | 39.98815591 | -91.18786813 | 2022-11-23 04:21:06 | Adams, Illinois, US | |
1620797 | 1620797 | 2022-11-22 | US | Arkansas | Pope | 5115 | 20433 | 224 | 0 | 35.44871474 | -93.03212219 | 2022-11-23 04:21:06 | Pope, Arkansas, US | |
3463606 | 3463606 | 2022-11-21 | US | Washington | Franklin | 53021 | 36194 | 224 | 0 | 46.53351425 | -118.9018212 | 2022-11-22 04:20:47 | Franklin, Washington, 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]);