johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,085 rows where deaths = 331 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 866
- Netherlands 40
- Russia 35
- Japan 26
- Sweden 22
- Ukraine 7
- India 6
- Colombia 5
- Chile 4
- Finland 4
- Ghana 4
- Italy 4
- Mexico 4
- Peru 4
- Uganda 4
- Barbados 3
- Belize 3
- Canada 3
- Congo (Brazzaville) 3
- France 3
- Pakistan 3
- Senegal 3
- Congo (Kinshasa) 2
- Guyana 2
- Jamaica 2
- Spain 2
- Zambia 2
- Afghanistan 1
- Australia 1
- Bahrain 1
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2756320 | 2756320 | 2022-12-29 | US | Virginia | Spotsylvania | 51177 | 34216 | 331 | 0 | 38.18574462 | -77.655399 | 2022-12-30 04:21:04 | Spotsylvania, Virginia, US | |
2755134 | 2755134 | 2022-12-29 | US | New York | Chautauqua | 36013 | 28716 | 331 | 0 | 42.2276921 | -79.36691763 | 2022-12-30 04:21:04 | Chautauqua, New York, US | |
2755076 | 2755076 | 2022-12-29 | US | New Jersey | Cape May | 34009 | 28977 | 331 | 0 | 39.15008829 | -74.80170244 | 2022-12-30 04:21:04 | Cape May, New Jersey, US | |
2754690 | 2754690 | 2022-12-29 | US | Minnesota | Wright | 27171 | 42030 | 331 | 0 | 45.17297924 | -93.96234781 | 2022-12-30 04:21:04 | Wright, Minnesota, US | |
1077326 | 1077326 | 2022-12-28 | US | Virginia | Spotsylvania | 51177 | 34216 | 331 | 0 | 38.18574462 | -77.655399 | 2022-12-29 04:21:01 | Spotsylvania, Virginia, US | |
1076140 | 1076140 | 2022-12-28 | US | New York | Chautauqua | 36013 | 28698 | 331 | 0 | 42.2276921 | -79.36691763 | 2022-12-29 04:21:01 | Chautauqua, New York, US | |
1075696 | 1075696 | 2022-12-28 | US | Minnesota | Wright | 27171 | 41908 | 331 | 0 | 45.17297924 | -93.96234781 | 2022-12-29 04:21:01 | Wright, Minnesota, US | |
331323 | 331323 | 2022-12-27 | US | Virginia | Spotsylvania | 51177 | 34186 | 331 | 0 | 38.18574462 | -77.655399 | 2022-12-28 04:21:04 | Spotsylvania, Virginia, US | |
330137 | 330137 | 2022-12-27 | US | New York | Chautauqua | 36013 | 28688 | 331 | 0 | 42.2276921 | -79.36691763 | 2022-12-28 04:21:04 | Chautauqua, New York, US | |
329693 | 329693 | 2022-12-27 | US | Minnesota | Wright | 27171 | 41908 | 331 | 0 | 45.17297924 | -93.96234781 | 2022-12-28 04:21:04 | Wright, Minnesota, US | |
221396 | 221396 | 2022-12-26 | US | Virginia | Spotsylvania | 51177 | 34159 | 331 | 0 | 38.18574462 | -77.655399 | 2022-12-27 04:21:07 | Spotsylvania, Virginia, US | |
220210 | 220210 | 2022-12-26 | US | New York | Chautauqua | 36013 | 28680 | 331 | 0 | 42.2276921 | -79.36691763 | 2022-12-27 04:21:07 | Chautauqua, New York, US | |
219766 | 219766 | 2022-12-26 | US | Minnesota | Wright | 27171 | 41908 | 331 | 0 | 45.17297924 | -93.96234781 | 2022-12-27 04:21:07 | Wright, Minnesota, US | |
3225853 | 3225853 | 2022-12-25 | US | Virginia | Spotsylvania | 51177 | 34098 | 331 | 0 | 38.18574462 | -77.655399 | 2022-12-26 04:21:06 | Spotsylvania, Virginia, US | |
3224667 | 3224667 | 2022-12-25 | US | New York | Chautauqua | 36013 | 28676 | 331 | 0 | 42.2276921 | -79.36691763 | 2022-12-26 04:21:06 | Chautauqua, New York, US | |
3224223 | 3224223 | 2022-12-25 | US | Minnesota | Wright | 27171 | 41908 | 331 | 0 | 45.17297924 | -93.96234781 | 2022-12-26 04:21:06 | Wright, Minnesota, US | |
1021767 | 1021767 | 2022-12-24 | US | Virginia | Spotsylvania | 51177 | 34098 | 331 | 0 | 38.18574462 | -77.655399 | 2022-12-25 04:21:04 | Spotsylvania, Virginia, US | |
1020581 | 1020581 | 2022-12-24 | US | New York | Chautauqua | 36013 | 28673 | 331 | 0 | 42.2276921 | -79.36691763 | 2022-12-25 04:21:04 | Chautauqua, New York, US | |
1020137 | 1020137 | 2022-12-24 | US | Minnesota | Wright | 27171 | 41908 | 331 | 0 | 45.17297924 | -93.96234781 | 2022-12-25 04:21:04 | Wright, Minnesota, US | |
693790 | 693790 | 2022-12-23 | US | Virginia | Spotsylvania | 51177 | 34098 | 331 | 0 | 38.18574462 | -77.655399 | 2022-12-24 04:21:02 | Spotsylvania, Virginia, US | |
692604 | 692604 | 2022-12-23 | US | New York | Chautauqua | 36013 | 28660 | 331 | 0 | 42.2276921 | -79.36691763 | 2022-12-24 04:21:02 | Chautauqua, New York, US | |
692160 | 692160 | 2022-12-23 | US | Minnesota | Wright | 27171 | 41908 | 331 | 0 | 45.17297924 | -93.96234781 | 2022-12-24 04:21:02 | Wright, Minnesota, US | |
2183000 | 2183000 | 2022-12-22 | US | Virginia | Spotsylvania | 51177 | 34060 | 331 | 0 | 38.18574462 | -77.655399 | 2022-12-23 04:21:04 | Spotsylvania, Virginia, US | |
2181814 | 2181814 | 2022-12-22 | US | New York | Chautauqua | 36013 | 28649 | 331 | 0 | 42.2276921 | -79.36691763 | 2022-12-23 04:21:04 | Chautauqua, New York, US | |
2181370 | 2181370 | 2022-12-22 | US | Minnesota | Wright | 27171 | 41908 | 331 | 0 | 45.17297924 | -93.96234781 | 2022-12-23 04:21:04 | Wright, Minnesota, US | |
454804 | 454804 | 2022-12-21 | US | Virginia | Spotsylvania | 51177 | 34015 | 331 | 0 | 38.18574462 | -77.655399 | 2022-12-22 04:20:56 | Spotsylvania, Virginia, US | |
453618 | 453618 | 2022-12-21 | US | New York | Chautauqua | 36013 | 28637 | 331 | 0 | 42.2276921 | -79.36691763 | 2022-12-22 04:20:56 | Chautauqua, New York, US | |
2954803 | 2954803 | 2022-12-20 | US | Virginia | Spotsylvania | 51177 | 33971 | 331 | 0 | 38.18574462 | -77.655399 | 2022-12-21 04:21:03 | Spotsylvania, Virginia, US | |
3177205 | 3177205 | 2022-12-19 | US | Virginia | Spotsylvania | 51177 | 33947 | 331 | 0 | 38.18574462 | -77.655399 | 2022-12-20 04:21:04 | Spotsylvania, Virginia, US | |
1631722 | 1631722 | 2022-12-18 | US | Virginia | Spotsylvania | 51177 | 33872 | 331 | 0 | 38.18574462 | -77.655399 | 2022-12-19 04:21:03 | Spotsylvania, Virginia, US | |
1628335 | 1628335 | 2022-12-18 | Japan | Wakayama | 175049 | 331 | 0 | 33.911879 | 135.505446 | 2022-12-19 04:21:03 | Wakayama, Japan | |||
507101 | 507101 | 2022-12-17 | US | Virginia | Spotsylvania | 51177 | 33872 | 331 | 0 | 38.18574462 | -77.655399 | 2022-12-18 04:21:03 | Spotsylvania, Virginia, US | |
3327673 | 3327673 | 2022-12-16 | US | Virginia | Spotsylvania | 51177 | 33872 | 331 | 0 | 38.18574462 | -77.655399 | 2022-12-17 04:21:04 | Spotsylvania, Virginia, US | |
872156 | 872156 | 2022-12-11 | US | Virginia | Hanover | 51085 | 27363 | 331 | 0 | 37.7583355 | -77.49464673 | 2022-12-12 04:21:01 | Hanover, Virginia, US | |
260686 | 260686 | 2022-12-10 | US | Virginia | Hanover | 51085 | 27363 | 331 | 0 | 37.7583355 | -77.49464673 | 2022-12-11 04:20:50 | Hanover, Virginia, US | |
3939400 | 3939400 | 2022-12-09 | US | Virginia | Hanover | 51085 | 27363 | 331 | 0 | 37.7583355 | -77.49464673 | 2022-12-10 04:21:02 | Hanover, Virginia, US | |
718483 | 718483 | 2022-12-04 | Japan | Kagawa | 171717 | 331 | 0 | 34.217292 | 133.969047 | 2022-12-05 04:20:58 | Kagawa, Japan | |||
718468 | 718468 | 2022-12-04 | Japan | Akita | 148844 | 331 | 0 | 39.748679 | 140.408228 | 2022-12-05 04:20:58 | Akita, Japan | |||
3462981 | 3462981 | 2022-11-21 | US | South Carolina | Darlington | 45031 | 21305 | 331 | 0 | 34.33358335 | -79.96027485 | 2022-11-22 04:20:47 | Darlington, South Carolina, US | |
1643166 | 1643166 | 2022-11-20 | US | South Carolina | Darlington | 45031 | 21305 | 331 | 0 | 34.33358335 | -79.96027485 | 2022-11-21 04:21:05 | Darlington, South Carolina, US | |
2066723 | 2066723 | 2022-11-19 | US | South Carolina | Darlington | 45031 | 21305 | 331 | 0 | 34.33358335 | -79.96027485 | 2022-11-20 04:21:08 | Darlington, South Carolina, US | |
1758117 | 1758117 | 2022-11-18 | US | South Carolina | Darlington | 45031 | 21305 | 331 | 0 | 34.33358335 | -79.96027485 | 2022-11-19 04:21:14 | Darlington, South Carolina, US | |
3029110 | 3029110 | 2022-11-17 | US | South Carolina | Darlington | 45031 | 21305 | 331 | 0 | 34.33358335 | -79.96027485 | 2022-11-18 04:21:15 | Darlington, South Carolina, US | |
2488821 | 2488821 | 2022-11-16 | US | South Carolina | Darlington | 45031 | 21305 | 331 | 0 | 34.33358335 | -79.96027485 | 2022-11-17 04:21:11 | Darlington, South Carolina, US | |
294832 | 294832 | 2022-11-15 | US | South Carolina | Darlington | 45031 | 21305 | 331 | 0 | 34.33358335 | -79.96027485 | 2022-11-16 04:21:09 | Darlington, South Carolina, US | |
3599862 | 3599862 | 2022-11-14 | US | South Carolina | Darlington | 45031 | 21284 | 331 | 0 | 34.33358335 | -79.96027485 | 2022-11-15 04:21:16 | Darlington, South Carolina, US | |
3598616 | 3598616 | 2022-11-14 | US | Maine | York | 23031 | 49235 | 331 | 0 | 43.47808377 | -70.71052375 | 2022-11-15 04:21:16 | York, Maine, US | |
3597719 | 3597719 | 2022-11-14 | US | Connecticut | Windham | 9015 | 30186 | 331 | 0 | 41.82972709 | -71.98182316 | 2022-11-15 04:21:16 | Windham, Connecticut, US | |
314720 | 314720 | 2022-11-13 | US | South Carolina | Darlington | 45031 | 21284 | 331 | 0 | 34.33358335 | -79.96027485 | 2022-11-14 04:21:09 | Darlington, South Carolina, US | |
313474 | 313474 | 2022-11-13 | US | Maine | York | 23031 | 49235 | 331 | 0 | 43.47808377 | -70.71052375 | 2022-11-14 04:21:09 | York, Maine, US | |
312577 | 312577 | 2022-11-13 | US | Connecticut | Windham | 9015 | 30177 | 331 | 0 | 41.82972709 | -71.98182316 | 2022-11-14 04:21:09 | Windham, Connecticut, US | |
65881 | 65881 | 2022-11-12 | US | South Carolina | Darlington | 45031 | 21284 | 331 | 0 | 34.33358335 | -79.96027485 | 2022-11-13 04:21:14 | Darlington, South Carolina, US | |
64635 | 64635 | 2022-11-12 | US | Maine | York | 23031 | 49235 | 331 | 0 | 43.47808377 | -70.71052375 | 2022-11-13 04:21:14 | York, Maine, US | |
63738 | 63738 | 2022-11-12 | US | Connecticut | Windham | 9015 | 30173 | 331 | 0 | 41.82972709 | -71.98182316 | 2022-11-13 04:21:14 | Windham, Connecticut, US | |
2930043 | 2930043 | 2022-11-11 | US | South Carolina | Darlington | 45031 | 21284 | 331 | 0 | 34.33358335 | -79.96027485 | 2022-11-12 04:20:41 | Darlington, South Carolina, US | |
2928797 | 2928797 | 2022-11-11 | US | Maine | York | 23031 | 49235 | 331 | 0 | 43.47808377 | -70.71052375 | 2022-11-12 04:20:41 | York, Maine, US | |
2927900 | 2927900 | 2022-11-11 | US | Connecticut | Windham | 9015 | 30164 | 331 | 0 | 41.82972709 | -71.98182316 | 2022-11-12 04:20:41 | Windham, Connecticut, US | |
2508879 | 2508879 | 2022-11-10 | US | South Carolina | Darlington | 45031 | 21284 | 331 | 0 | 34.33358335 | -79.96027485 | 2022-11-11 04:21:22 | Darlington, South Carolina, US | |
2507633 | 2507633 | 2022-11-10 | US | Maine | York | 23031 | 49211 | 331 | 0 | 43.47808377 | -70.71052375 | 2022-11-11 04:21:22 | York, Maine, US | |
2506736 | 2506736 | 2022-11-10 | US | Connecticut | Windham | 9015 | 30143 | 331 | 0 | 41.82972709 | -71.98182316 | 2022-11-11 04:21:22 | Windham, Connecticut, US | |
2433754 | 2433754 | 2022-11-09 | US | South Carolina | Darlington | 45031 | 21284 | 331 | 0 | 34.33358335 | -79.96027485 | 2022-11-10 04:21:16 | Darlington, South Carolina, US | |
2432508 | 2432508 | 2022-11-09 | US | Maine | York | 23031 | 49186 | 331 | 0 | 43.47808377 | -70.71052375 | 2022-11-10 04:21:16 | York, Maine, US | |
482410 | 482410 | 2022-11-08 | US | South Carolina | Darlington | 45031 | 21284 | 331 | 0 | 34.33358335 | -79.96027485 | 2022-11-09 04:21:22 | Darlington, South Carolina, US | |
481164 | 481164 | 2022-11-08 | US | Maine | York | 23031 | 49155 | 331 | 0 | 43.47808377 | -70.71052375 | 2022-11-09 04:21:22 | York, Maine, US | |
1366464 | 1366464 | 2022-10-28 | Japan | Aomori | 172849 | 331 | 0 | 40.781541 | 140.828896 | 2022-10-29 04:21:13 | Aomori, Japan | |||
3251387 | 3251387 | 2022-10-11 | US | Iowa | Pottawattamie | 19155 | 26687 | 331 | 0 | 41.33640314 | -95.53907776 | 2022-10-12 04:22:51 | Pottawattamie, Iowa, US | |
2968646 | 2968646 | 2022-10-10 | US | Iowa | Pottawattamie | 19155 | 26687 | 331 | 0 | 41.33640314 | -95.53907776 | 2022-10-11 04:23:05 | Pottawattamie, Iowa, US | |
3098682 | 3098682 | 2022-10-09 | US | Iowa | Pottawattamie | 19155 | 26687 | 331 | 0 | 41.33640314 | -95.53907776 | 2022-10-10 04:22:32 | Pottawattamie, Iowa, US | |
4003907 | 4003907 | 2022-10-08 | US | Iowa | Pottawattamie | 19155 | 26687 | 331 | 0 | 41.33640314 | -95.53907776 | 2022-10-09 04:21:16 | Pottawattamie, Iowa, US | |
397504 | 397504 | 2022-10-07 | US | Iowa | Pottawattamie | 19155 | 26687 | 331 | 0 | 41.33640314 | -95.53907776 | 2022-10-08 04:22:56 | Pottawattamie, Iowa, US | |
2531271 | 2531271 | 2022-10-06 | US | Missouri | Cass | 29037 | 28532 | 331 | 0 | 38.64789422 | -94.353399 | 2022-10-07 04:23:08 | Cass, Missouri, US | |
2530621 | 2530621 | 2022-10-06 | US | Iowa | Pottawattamie | 19155 | 26687 | 331 | 0 | 41.33640314 | -95.53907776 | 2022-10-07 04:23:08 | Pottawattamie, Iowa, US | |
1812665 | 1812665 | 2022-10-05 | US | Missouri | Cass | 29037 | 28532 | 331 | 0 | 38.64789422 | -94.353399 | 2022-10-06 04:21:22 | Cass, Missouri, US | |
1812015 | 1812015 | 2022-10-05 | US | Iowa | Pottawattamie | 19155 | 26687 | 331 | 0 | 41.33640314 | -95.53907776 | 2022-10-06 04:21:22 | Pottawattamie, Iowa, US | |
132639 | 132639 | 2022-10-04 | US | Missouri | Cass | 29037 | 28532 | 331 | 0 | 38.64789422 | -94.353399 | 2022-10-05 04:23:06 | Cass, Missouri, US | |
2687586 | 2687586 | 2022-10-03 | US | Missouri | Cass | 29037 | 28532 | 331 | 0 | 38.64789422 | -94.353399 | 2022-10-04 04:22:55 | Cass, Missouri, US | |
2261653 | 2261653 | 2022-10-02 | US | Missouri | Cass | 29037 | 28532 | 331 | 0 | 38.64789422 | -94.353399 | 2022-10-03 04:23:11 | Cass, Missouri, US | |
2997179 | 2997179 | 2022-10-01 | US | Missouri | Cass | 29037 | 28532 | 331 | 0 | 38.64789422 | -94.353399 | 2022-10-02 04:21:23 | Cass, Missouri, US | |
2995300 | 2995300 | 2022-10-01 | Japan | Nagasaki | 212645 | 331 | 0 | 33.235712 | 129.608033 | 2022-10-02 04:21:23 | Nagasaki, Japan | |||
855505 | 855505 | 2022-09-30 | US | Missouri | Cass | 29037 | 28532 | 331 | 0 | 38.64789422 | -94.353399 | 2022-10-01 04:23:01 | Cass, Missouri, US | |
853626 | 853626 | 2022-09-30 | Japan | Nagasaki | 212338 | 331 | 0 | 33.235712 | 129.608033 | 2022-10-01 04:23:01 | Nagasaki, Japan | |||
2020195 | 2020195 | 2022-09-20 | US | Washington | Whatcom | 53073 | 46354 | 331 | 0 | 48.82227976 | -121.7490018 | 2022-09-21 04:23:22 | Whatcom, Washington, US | |
2017597 | 2017597 | 2022-09-20 | US | Georgia | Rockdale | 13247 | 22024 | 331 | 0 | 33.65145002 | -84.02202167 | 2022-09-21 04:23:22 | Rockdale, Georgia, US | |
3574068 | 3574068 | 2022-09-19 | US | Washington | Whatcom | 53073 | 46354 | 331 | 0 | 48.82227976 | -121.7490018 | 2022-09-20 04:22:48 | Whatcom, Washington, US | |
3571470 | 3571470 | 2022-09-19 | US | Georgia | Rockdale | 13247 | 22024 | 331 | 0 | 33.65145002 | -84.02202167 | 2022-09-20 04:22:48 | Rockdale, Georgia, US | |
3571085 | 3571085 | 2022-09-19 | US | Arkansas | Faulkner | 5045 | 40414 | 331 | 0 | 35.14719007 | -92.33717519 | 2022-09-20 04:22:48 | Faulkner, Arkansas, US | |
420209 | 420209 | 2022-09-18 | US | Georgia | Rockdale | 13247 | 22024 | 331 | 0 | 33.65145002 | -84.02202167 | 2022-09-19 04:21:49 | Rockdale, Georgia, US | |
419824 | 419824 | 2022-09-18 | US | Arkansas | Faulkner | 5045 | 40404 | 331 | 0 | 35.14719007 | -92.33717519 | 2022-09-19 04:21:49 | Faulkner, Arkansas, US | |
3374233 | 3374233 | 2022-09-17 | US | Georgia | Rockdale | 13247 | 22024 | 331 | 0 | 33.65145002 | -84.02202167 | 2022-09-18 04:22:50 | Rockdale, Georgia, US | |
3373848 | 3373848 | 2022-09-17 | US | Arkansas | Faulkner | 5045 | 40393 | 331 | 0 | 35.14719007 | -92.33717519 | 2022-09-18 04:22:50 | Faulkner, Arkansas, US | |
2356341 | 2356341 | 2022-09-16 | US | Georgia | Rockdale | 13247 | 22024 | 331 | 0 | 33.65145002 | -84.02202167 | 2022-09-17 04:20:19 | Rockdale, Georgia, US | |
2355956 | 2355956 | 2022-09-16 | US | Arkansas | Faulkner | 5045 | 40356 | 331 | 0 | 35.14719007 | -92.33717519 | 2022-09-17 04:20:19 | Faulkner, Arkansas, US | |
3987498 | 3987498 | 2022-09-15 | US | Georgia | Rockdale | 13247 | 22024 | 331 | 0 | 33.65145002 | -84.02202167 | 2022-09-16 04:21:19 | Rockdale, Georgia, US | |
3987113 | 3987113 | 2022-09-15 | US | Arkansas | Faulkner | 5045 | 40331 | 331 | 0 | 35.14719007 | -92.33717519 | 2022-09-16 04:21:19 | Faulkner, Arkansas, US | |
3986638 | 3986638 | 2022-09-15 | Japan | Oita | 169318 | 331 | 0 | 33.200697 | 131.43324 | 2022-09-16 04:21:19 | Oita, Japan | |||
1890015 | 1890015 | 2022-09-14 | US | Georgia | Rockdale | 13247 | 22024 | 331 | 0 | 33.65145002 | -84.02202167 | 2022-09-15 04:21:02 | Rockdale, Georgia, US | |
1889630 | 1889630 | 2022-09-14 | US | Arkansas | Faulkner | 5045 | 40291 | 331 | 0 | 35.14719007 | -92.33717519 | 2022-09-15 04:21:02 | Faulkner, Arkansas, US | |
1889155 | 1889155 | 2022-09-14 | Japan | Oita | 168676 | 331 | 0 | 33.200697 | 131.43324 | 2022-09-15 04:21:02 | Oita, Japan | |||
374467 | 374467 | 2022-09-13 | US | New York | Schenectady | 36093 | 39945 | 331 | 0 | 42.81668777 | -74.05278291 | 2022-09-14 04:20:44 | Schenectady, New York, US | |
372685 | 372685 | 2022-09-13 | US | Arkansas | Faulkner | 5045 | 40231 | 331 | 0 | 35.14719007 | -92.33717519 | 2022-09-14 04:20:44 | Faulkner, Arkansas, 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]);