johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,766 rows where confirmed = 93 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 29
- US 1,648
- Mainland China 17
- China 16
- Malaysia 16
- Japan 12
- Australia 7
- Antigua and Barbuda 5
- France 5
- Monaco 5
- Guyana 3
- Madagascar 3
- Singapore 3
- Ukraine 3
- United Kingdom 3
- Bahamas 2
- Colombia 2
- Gambia 2
- Netherlands 2
- Sierra Leone 2
- Azerbaijan 1
- Bosnia and Herzegovina 1
- El Salvador 1
- Germany 1
- Ghana 1
- Lebanon 1
- Liechtenstein 1
- Mexico 1
- New Zealand 1
- Winter Olympics 2022 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3026429 | 3026429 | 2022-11-17 | New Zealand | Niue | 93 | 0 | 0 | -19.0544 | -169.8672 | 2022-11-18 04:21:15 | Niue, New Zealand | |||
3754530 | 3754530 | 2022-10-13 | US | Illinois | Unassigned | 90017 | 93 | 4712 | 0 | 42.36542373 | 0.0 | 2022-10-14 04:22:28 | Unassigned, Illinois, US | |
1561149 | 1561149 | 2022-09-28 | US | Illinois | Unassigned | 90017 | 93 | 4681 | 0 | 42.36542373 | 0.0 | 2022-09-29 04:22:34 | Unassigned, Illinois, US | |
1371550 | 1371550 | 2022-09-21 | US | Illinois | Unassigned | 90017 | 93 | 4674 | 0 | 42.36542373 | 0.0 | 2022-09-22 04:22:56 | Unassigned, Illinois, US | |
373253 | 373253 | 2022-09-13 | US | Illinois | Unassigned | 90017 | 93 | 4638 | 0 | 42.36542373 | 0.0 | 2022-09-14 04:20:44 | Unassigned, Illinois, US | |
2635922 | 2635922 | 2022-09-05 | US | New Mexico | Harding | 35021 | 93 | 4 | 0 | 35.85751555 | -103.8220938 | 2022-09-06 04:21:02 | Harding, New Mexico, US | |
2989486 | 2989486 | 2022-09-04 | US | New Mexico | Harding | 35021 | 93 | 4 | 0 | 35.85751555 | -103.8220938 | 2022-09-05 04:21:01 | Harding, New Mexico, US | |
2715171 | 2715171 | 2022-09-03 | US | New Mexico | Harding | 35021 | 93 | 4 | 0 | 35.85751555 | -103.8220938 | 2022-09-04 04:21:22 | Harding, New Mexico, US | |
1395876 | 1395876 | 2022-09-02 | US | New Mexico | Harding | 35021 | 93 | 4 | 0 | 35.85751555 | -103.8220938 | 2022-09-03 04:21:04 | Harding, New Mexico, US | |
3549705 | 3549705 | 2022-09-01 | US | New Mexico | Harding | 35021 | 93 | 4 | 0 | 35.85751555 | -103.8220938 | 2022-09-02 04:21:07 | Harding, New Mexico, US | |
2345625 | 2345625 | 2022-08-31 | US | New Mexico | Harding | 35021 | 93 | 4 | 0 | 35.85751555 | -103.8220938 | 2022-09-01 04:21:03 | Harding, New Mexico, US | |
3776105 | 3776105 | 2022-08-30 | US | New Mexico | Harding | 35021 | 93 | 4 | 0 | 35.85751555 | -103.8220938 | 2022-08-31 04:20:57 | Harding, New Mexico, US | |
1682701 | 1682701 | 2022-08-29 | US | New Mexico | Harding | 35021 | 93 | 4 | 0 | 35.85751555 | -103.8220938 | 2022-08-30 04:21:03 | Harding, New Mexico, US | |
1879185 | 1879185 | 2022-08-28 | US | New Mexico | Harding | 35021 | 93 | 4 | 0 | 35.85751555 | -103.8220938 | 2022-08-29 04:21:06 | Harding, New Mexico, US | |
2098312 | 2098312 | 2022-08-27 | US | New Mexico | Harding | 35021 | 93 | 4 | 0 | 35.85751555 | -103.8220938 | 2022-08-28 04:21:02 | Harding, New Mexico, US | |
1534127 | 1534127 | 2022-08-26 | US | New Mexico | Harding | 35021 | 93 | 4 | 0 | 35.85751555 | -103.8220938 | 2022-08-27 04:20:57 | Harding, New Mexico, US | |
2831014 | 2831014 | 2022-08-25 | US | New Mexico | Harding | 35021 | 93 | 4 | 0 | 35.85751555 | -103.8220938 | 2022-08-26 04:21:02 | Harding, New Mexico, US | |
2325547 | 2325547 | 2022-08-24 | US | New Mexico | Harding | 35021 | 93 | 4 | 0 | 35.85751555 | -103.8220938 | 2022-08-25 04:21:13 | Harding, New Mexico, US | |
1252956 | 1252956 | 2022-08-23 | US | New Mexico | Harding | 35021 | 93 | 4 | 0 | 35.85751555 | -103.8220938 | 2022-08-24 04:20:46 | Harding, New Mexico, US | |
2855060 | 2855060 | 2022-08-22 | US | New Mexico | Harding | 35021 | 93 | 4 | 0 | 35.85751555 | -103.8220938 | 2022-08-23 04:20:56 | Harding, New Mexico, US | |
2405032 | 2405032 | 2022-08-21 | US | New Mexico | Harding | 35021 | 93 | 4 | 0 | 35.85751555 | -103.8220938 | 2022-08-22 04:20:38 | Harding, New Mexico, US | |
3800110 | 3800110 | 2022-08-20 | US | New Mexico | Harding | 35021 | 93 | 4 | 0 | 35.85751555 | -103.8220938 | 2022-08-21 04:20:44 | Harding, New Mexico, US | |
2365696 | 2365696 | 2022-08-19 | US | New Mexico | Harding | 35021 | 93 | 4 | 0 | 35.85751555 | -103.8220938 | 2022-08-20 04:21:01 | Harding, New Mexico, US | |
1163367 | 1163367 | 2022-08-18 | US | New Mexico | Harding | 35021 | 93 | 4 | 0 | 35.85751555 | -103.8220938 | 2022-08-19 04:20:54 | Harding, New Mexico, US | |
2009745 | 2009745 | 2022-08-04 | US | Illinois | Unassigned | 90017 | 93 | 4544 | 0 | 42.36542373 | 0.0 | 2022-08-05 04:20:52 | Unassigned, Illinois, US | |
1649432 | 1649432 | 2022-06-23 | US | Illinois | Unassigned | 90017 | 93 | 4429 | 0 | 42.36542373 | 0.0 | 2022-06-24 04:20:58 | Unassigned, Illinois, US | |
1763130 | 1763130 | 2022-06-20 | China | Macau | 93 | 0 | 0 | 22.1667 | 113.55 | 2022-06-21 04:20:56 | Macau, China | |||
1697387 | 1697387 | 2022-04-28 | US | Illinois | Unassigned | 90017 | 93 | 4289 | 0 | 42.36542373 | 0.0 | 2022-04-29 04:20:59 | Unassigned, Illinois, US | |
2028574 | 2028574 | 2022-04-24 | China | Qinghai | 93 | 0 | 0 | 35.7452 | 95.9956 | 2022-04-25 04:20:56 | Qinghai, China | |||
2735069 | 2735069 | 2022-02-27 | US | Nebraska | Banner | 31007 | 93 | 0 | 0 | 41.54634427 | -103.7114332 | 2022-02-28 04:21:05 | Banner, Nebraska, US | |
3048222 | 3048222 | 2022-02-26 | US | Nebraska | Banner | 31007 | 93 | 0 | 0 | 41.54634427 | -103.7114332 | 2022-02-27 04:21:04 | Banner, Nebraska, US | |
576877 | 576877 | 2022-02-25 | US | Nebraska | Banner | 31007 | 93 | 0 | 0 | 41.54634427 | -103.7114332 | 2022-02-26 04:21:12 | Banner, Nebraska, US | |
1513453 | 1513453 | 2022-02-24 | US | Nebraska | Banner | 31007 | 93 | 0 | 0 | 41.54634427 | -103.7114332 | 2022-02-25 04:21:11 | Banner, Nebraska, US | |
1059894 | 1059894 | 2022-02-23 | US | Nebraska | Banner | 31007 | 93 | 0 | 0 | 41.54634427 | -103.7114332 | 2022-02-24 04:21:14 | Banner, Nebraska, US | |
2448817 | 2448817 | 2022-02-22 | US | Nebraska | Banner | 31007 | 93 | 0 | 0 | 41.54634427 | -103.7114332 | 2022-02-23 04:21:09 | Banner, Nebraska, US | |
3720230 | 3720230 | 2022-02-21 | US | Nebraska | Banner | 31007 | 93 | 0 | 0 | 41.54634427 | -103.7114332 | 2022-02-22 04:21:01 | Banner, Nebraska, US | |
3914064 | 3914064 | 2022-02-20 | US | Nebraska | Banner | 31007 | 93 | 0 | 0 | 41.54634427 | -103.7114332 | 2022-02-21 04:21:05 | Banner, Nebraska, US | |
3877622 | 3877622 | 2022-02-19 | US | Nebraska | Banner | 31007 | 93 | 0 | 0 | 41.54634427 | -103.7114332 | 2022-02-20 04:21:00 | Banner, Nebraska, US | |
3857878 | 3857878 | 2022-02-18 | US | Nebraska | Banner | 31007 | 93 | 0 | 0 | 41.54634427 | -103.7114332 | 2022-02-19 04:21:11 | Banner, Nebraska, US | |
1300097 | 1300097 | 2022-02-17 | US | Nebraska | Banner | 31007 | 93 | 0 | 0 | 41.54634427 | -103.7114332 | 2022-02-18 04:21:04 | Banner, Nebraska, US | |
3822483 | 3822483 | 2022-02-16 | US | Nebraska | Banner | 31007 | 93 | 0 | 0 | 41.54634427 | -103.7114332 | 2022-02-17 04:20:56 | Banner, Nebraska, US | |
3673697 | 3673697 | 2022-02-15 | US | Nebraska | Banner | 31007 | 93 | 0 | 0 | 41.54634427 | -103.7114332 | 2022-02-16 04:21:10 | Banner, Nebraska, US | |
2643798 | 2643798 | 2022-02-14 | US | Nebraska | Banner | 31007 | 93 | 0 | 0 | 41.54634427 | -103.7114332 | 2022-02-15 04:21:09 | Banner, Nebraska, US | |
188115 | 188115 | 2022-02-13 | US | Nebraska | Banner | 31007 | 93 | 0 | 0 | 41.54634427 | -103.7114332 | 2022-02-14 04:20:51 | Banner, Nebraska, US | |
317961 | 317961 | 2022-02-12 | US | Nebraska | Banner | 31007 | 93 | 0 | 0 | 41.54634427 | -103.7114332 | 2022-02-13 04:21:00 | Banner, Nebraska, US | |
235287 | 235287 | 2022-02-11 | US | Nebraska | Banner | 31007 | 93 | 0 | 0 | 41.54634427 | -103.7114332 | 2022-02-12 04:21:06 | Banner, Nebraska, US | |
1466129 | 1466129 | 2022-02-10 | US | Nebraska | Banner | 31007 | 93 | 0 | 0 | 41.54634427 | -103.7114332 | 2022-02-11 04:21:09 | Banner, Nebraska, US | |
3076090 | 3076090 | 2022-02-09 | US | Nebraska | Banner | 31007 | 93 | 0 | 0 | 41.54634427 | -103.7114332 | 2022-02-10 04:21:14 | Banner, Nebraska, US | |
1364397 | 1364397 | 2022-02-08 | US | Nebraska | Banner | 31007 | 93 | 0 | 0 | 41.54634427 | -103.7114332 | 2022-02-09 04:21:04 | Banner, Nebraska, US | |
73135 | 73135 | 2022-02-07 | US | Nebraska | Banner | 31007 | 93 | 0 | 0 | 41.54634427 | -103.7114332 | 2022-02-08 04:21:15 | Banner, Nebraska, US | |
2660818 | 2660818 | 2022-01-31 | US | Texas | Borden | 48033 | 93 | 2 | 0 | 32.74363984 | -101.43165090000001 | 2022-02-01 04:21:11 | Borden, Texas, US | |
3303235 | 3303235 | 2022-01-30 | US | Texas | Borden | 48033 | 93 | 2 | 0 | 32.74363984 | -101.43165090000001 | 2022-01-31 04:21:09 | Borden, Texas, US | |
3065026 | 3065026 | 2022-01-29 | US | Texas | Borden | 48033 | 93 | 2 | 0 | 32.74363984 | -101.43165090000001 | 2022-01-30 04:21:26 | Borden, Texas, US | |
3812960 | 3812960 | 2022-01-28 | US | Texas | Borden | 48033 | 93 | 2 | 0 | 32.74363984 | -101.43165090000001 | 2022-01-29 04:21:10 | Borden, Texas, US | |
2055560 | 2055560 | 2022-01-25 | Winter Olympics 2022 | 93 | 0 | 0 | 0 | 39.9042 | 116.4074 | 2022-01-26 04:21:07 | Winter Olympics 2022 | |||
2055044 | 2055044 | 2022-01-25 | US | Texas | Loving | 48301 | 93 | 0 | 0 | 31.84947612 | -103.5818571 | 2022-01-26 04:21:07 | Loving, Texas, US | |
128816 | 128816 | 2022-01-09 | US | Nebraska | Hayes | 31085 | 93 | 0 | 0 | 40.52451972 | -101.0603568 | 2022-01-10 04:22:07 | Hayes, Nebraska, US | |
1217651 | 1217651 | 2022-01-08 | US | Nebraska | Hayes | 31085 | 93 | 0 | 0 | 40.52451972 | -101.0603568 | 2022-01-09 04:21:46 | Hayes, Nebraska, US | |
1391744 | 1391744 | 2022-01-07 | US | Nebraska | Hayes | 31085 | 93 | 0 | 0 | 40.52451972 | -101.0603568 | 2022-01-08 04:21:53 | Hayes, Nebraska, US | |
2612131 | 2612131 | 2022-01-06 | US | Nebraska | Hayes | 31085 | 93 | 0 | 0 | 40.52451972 | -101.0603568 | 2022-01-07 04:22:09 | Hayes, Nebraska, US | |
1284073 | 1284073 | 2022-01-05 | US | Nebraska | Hayes | 31085 | 93 | 0 | 0 | 40.52451972 | -101.0603568 | 2022-01-06 04:22:09 | Hayes, Nebraska, US | |
1282922 | 1282922 | 2022-01-05 | US | Idaho | Clark | 16033 | 93 | 0 | 0 | 44.28496071 | -112.35057040000001 | 2022-01-06 04:22:09 | Clark, Idaho, US | |
1288089 | 1288089 | 2022-01-04 | US | Nebraska | Hayes | 31085 | 93 | 0 | 0 | 40.52451972 | -101.0603568 | 2022-01-05 04:21:59 | Hayes, Nebraska, US | |
1286938 | 1286938 | 2022-01-04 | US | Idaho | Clark | 16033 | 93 | 0 | 0 | 44.28496071 | -112.35057040000001 | 2022-01-05 04:21:59 | Clark, Idaho, US | |
1702433 | 1702433 | 2022-01-03 | US | Nebraska | Hayes | 31085 | 93 | 0 | 0 | 40.52451972 | -101.0603568 | 2022-01-04 04:22:17 | Hayes, Nebraska, US | |
1701282 | 1701282 | 2022-01-03 | US | Idaho | Clark | 16033 | 93 | 0 | 0 | 44.28496071 | -112.35057040000001 | 2022-01-04 04:22:17 | Clark, Idaho, US | |
3521516 | 3521516 | 2022-01-02 | US | Nebraska | Hayes | 31085 | 93 | 0 | 0 | 40.52451972 | -101.0603568 | 2022-01-03 02:22:25 | Hayes, Nebraska, US | |
3520365 | 3520365 | 2022-01-02 | US | Idaho | Clark | 16033 | 93 | 0 | 0 | 44.28496071 | -112.35057040000001 | 2022-01-03 02:22:25 | Clark, Idaho, US | |
2169646 | 2169646 | 2022-01-01 | US | Nebraska | Hayes | 31085 | 93 | 0 | 0 | 40.52451972 | -101.0603568 | 2022-01-02 04:20:52 | Hayes, Nebraska, US | |
2168495 | 2168495 | 2022-01-01 | US | Idaho | Clark | 16033 | 93 | 0 | 0 | 44.28496071 | -112.35057040000001 | 2022-01-02 04:20:52 | Clark, Idaho, US | |
2779077 | 2779077 | 2021-12-31 | US | Nebraska | Hayes | 31085 | 93 | 0 | 0 | 40.52451972 | -101.0603568 | 2022-01-01 04:22:14 | Hayes, Nebraska, US | |
2777926 | 2777926 | 2021-12-31 | US | Idaho | Clark | 16033 | 93 | 0 | 0 | 44.28496071 | -112.35057040000001 | 2022-01-01 04:22:14 | Clark, Idaho, US | |
4000734 | 4000734 | 2021-12-30 | US | Nebraska | Hayes | 31085 | 93 | 0 | 0 | 40.52451972 | -101.0603568 | 2021-12-31 04:21:50 | Hayes, Nebraska, US | |
3999583 | 3999583 | 2021-12-30 | US | Idaho | Clark | 16033 | 93 | 0 | 0 | 44.28496071 | -112.35057040000001 | 2021-12-31 04:21:50 | Clark, Idaho, US | |
1670591 | 1670591 | 2021-12-29 | US | Nebraska | Wheeler | 31183 | 93 | 0 | 0 | 41.91482725 | -98.52798941 | 2021-12-30 04:21:25 | Wheeler, Nebraska, US | |
1670541 | 1670541 | 2021-12-29 | US | Nebraska | Hayes | 31085 | 93 | 0 | 0 | 40.52451972 | -101.0603568 | 2021-12-30 04:21:25 | Hayes, Nebraska, US | |
1669390 | 1669390 | 2021-12-29 | US | Idaho | Clark | 16033 | 93 | 0 | 0 | 44.28496071 | -112.35057040000001 | 2021-12-30 04:21:25 | Clark, Idaho, US | |
1434700 | 1434700 | 2021-12-28 | US | Nebraska | Wheeler | 31183 | 93 | 0 | 0 | 41.91482725 | -98.52798941 | 2021-12-29 03:21:43 | Wheeler, Nebraska, US | |
1434650 | 1434650 | 2021-12-28 | US | Nebraska | Hayes | 31085 | 93 | 0 | 0 | 40.52451972 | -101.0603568 | 2021-12-29 03:21:43 | Hayes, Nebraska, US | |
732661 | 732661 | 2021-12-27 | US | Nebraska | Wheeler | 31183 | 93 | 0 | 0 | 41.91482725 | -98.52798941 | 2021-12-28 04:21:47 | Wheeler, Nebraska, US | |
2113833 | 2113833 | 2021-12-26 | US | Nebraska | Wheeler | 31183 | 93 | 0 | 0 | 41.91482725 | -98.52798941 | 2021-12-27 04:21:58 | Wheeler, Nebraska, US | |
3607205 | 3607205 | 2021-12-25 | US | Nebraska | Wheeler | 31183 | 93 | 0 | 0 | 41.91482725 | -98.52798941 | 2021-12-26 04:21:50 | Wheeler, Nebraska, US | |
2965523 | 2965523 | 2021-12-24 | US | Nebraska | Wheeler | 31183 | 93 | 0 | 0 | 41.91482725 | -98.52798941 | 2021-12-25 04:21:37 | Wheeler, Nebraska, US | |
3818555 | 3818555 | 2021-12-23 | US | Nebraska | Wheeler | 31183 | 93 | 0 | 0 | 41.91482725 | -98.52798941 | 2021-12-24 04:21:34 | Wheeler, Nebraska, US | |
800563 | 800563 | 2021-12-22 | US | Nebraska | Wheeler | 31183 | 93 | 0 | 0 | 41.91482725 | -98.52798941 | 2021-12-23 04:21:21 | Wheeler, Nebraska, US | |
3830603 | 3830603 | 2021-12-21 | US | Nebraska | Wheeler | 31183 | 93 | 0 | 0 | 41.91482725 | -98.52798941 | 2021-12-22 04:21:54 | Wheeler, Nebraska, US | |
1256906 | 1256906 | 2021-12-20 | US | Nebraska | Wheeler | 31183 | 93 | 0 | 0 | 41.91482725 | -98.52798941 | 2021-12-21 03:21:27 | Wheeler, Nebraska, US | |
2905849 | 2905849 | 2021-12-19 | US | Nebraska | Wheeler | 31183 | 93 | 0 | 0 | 41.91482725 | -98.52798941 | 2021-12-20 04:21:43 | Wheeler, Nebraska, US | |
1260922 | 1260922 | 2021-12-18 | US | Nebraska | Wheeler | 31183 | 93 | 0 | 0 | 41.91482725 | -98.52798941 | 2021-12-19 04:21:11 | Wheeler, Nebraska, US | |
2400950 | 2400950 | 2021-12-17 | US | Nebraska | Wheeler | 31183 | 93 | 0 | 0 | 41.91482725 | -98.52798941 | 2021-12-18 02:22:20 | Wheeler, Nebraska, US | |
1718488 | 1718488 | 2021-12-16 | US | Nebraska | Wheeler | 31183 | 93 | 0 | 0 | 41.91482725 | -98.52798941 | 2021-12-17 04:22:14 | Wheeler, Nebraska, US | |
1716792 | 1716792 | 2021-12-16 | US | Alaska | Skagway | 2230 | 93 | 0 | 0 | 59.56149996 | -135.33377480000001 | 2021-12-17 04:22:14 | Skagway, Alaska, US | |
3498322 | 3498322 | 2021-12-15 | US | Nebraska | Wheeler | 31183 | 93 | 0 | 0 | 41.91482725 | -98.52798941 | 2021-12-16 04:22:11 | Wheeler, Nebraska, US | |
3496626 | 3496626 | 2021-12-15 | US | Alaska | Skagway | 2230 | 93 | 0 | 0 | 59.56149996 | -135.33377480000001 | 2021-12-16 04:22:11 | Skagway, Alaska, US | |
2090107 | 2090107 | 2021-12-14 | US | Nebraska | Wheeler | 31183 | 93 | 0 | 0 | 41.91482725 | -98.52798941 | 2021-12-15 03:22:16 | Wheeler, Nebraska, US | |
2088411 | 2088411 | 2021-12-14 | US | Alaska | Skagway | 2230 | 93 | 0 | 0 | 59.56149996 | -135.33377480000001 | 2021-12-15 03:22:16 | Skagway, Alaska, US | |
784524 | 784524 | 2021-12-13 | US | Nebraska | Wheeler | 31183 | 93 | 0 | 0 | 41.91482725 | -98.52798941 | 2021-12-14 04:22:38 | Wheeler, Nebraska, US | |
782828 | 782828 | 2021-12-13 | US | Alaska | Skagway | 2230 | 93 | 0 | 0 | 59.56149996 | -135.33377480000001 | 2021-12-14 04:22:38 | Skagway, Alaska, US | |
1662559 | 1662559 | 2021-12-12 | US | Nebraska | Wheeler | 31183 | 93 | 0 | 0 | 41.91482725 | -98.52798941 | 2021-12-13 04:22:02 | Wheeler, Nebraska, US | |
1660863 | 1660863 | 2021-12-12 | US | Alaska | Skagway | 2230 | 93 | 0 | 0 | 59.56149996 | -135.33377480000001 | 2021-12-13 04:22:02 | Skagway, Alaska, 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]);