johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
947 rows where confirmed = 223 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 19
- US 905
- Brunei 8
- China 6
- Colombia 5
- Japan 4
- United Kingdom 4
- Jamaica 2
- Malaysia 2
- Albania 1
- Chile 1
- Congo (Kinshasa) 1
- Ireland 1
- Liberia 1
- Mexico 1
- Monaco 1
- Paraguay 1
- Saint Lucia 1
- San Marino 1
- Ukraine 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3717271 | 3717271 | 2022-12-06 | US | Texas | Glasscock | 48173 | 223 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-12-07 04:20:58 | Glasscock, Texas, US | |
2417976 | 2417976 | 2022-12-05 | US | Texas | Glasscock | 48173 | 223 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-12-06 04:21:03 | Glasscock, Texas, US | |
721584 | 721584 | 2022-12-04 | US | Texas | Glasscock | 48173 | 223 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-12-05 04:20:58 | Glasscock, Texas, US | |
2819873 | 2819873 | 2022-12-03 | US | Texas | Glasscock | 48173 | 223 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-12-04 04:20:56 | Glasscock, Texas, US | |
836729 | 836729 | 2022-12-02 | US | Texas | Glasscock | 48173 | 223 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-12-03 04:21:02 | Glasscock, Texas, US | |
2139259 | 2139259 | 2022-12-01 | US | Texas | Glasscock | 48173 | 223 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-12-02 04:21:07 | Glasscock, Texas, US | |
1967675 | 1967675 | 2022-11-30 | US | Texas | Glasscock | 48173 | 223 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-12-01 04:21:03 | Glasscock, Texas, US | |
2559689 | 2559689 | 2022-11-29 | US | Texas | Glasscock | 48173 | 223 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-11-30 04:21:07 | Glasscock, Texas, US | |
1242763 | 1242763 | 2022-11-28 | US | Texas | Glasscock | 48173 | 223 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-11-29 04:21:05 | Glasscock, Texas, US | |
3554751 | 3554751 | 2022-11-27 | US | Texas | Glasscock | 48173 | 223 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-11-28 04:21:02 | Glasscock, Texas, US | |
2103231 | 2103231 | 2022-11-26 | US | Texas | Glasscock | 48173 | 223 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-11-27 04:21:05 | Glasscock, Texas, US | |
490722 | 490722 | 2022-11-25 | US | Texas | Glasscock | 48173 | 223 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-11-26 04:21:11 | Glasscock, Texas, US | |
3526551 | 3526551 | 2022-11-24 | US | Texas | Glasscock | 48173 | 223 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-11-25 04:21:06 | Glasscock, Texas, US | |
3315334 | 3315334 | 2022-11-23 | US | Texas | Glasscock | 48173 | 223 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-11-24 04:21:09 | Glasscock, Texas, US | |
1623375 | 1623375 | 2022-11-22 | US | Texas | Glasscock | 48173 | 223 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-11-23 04:21:06 | Glasscock, Texas, US | |
3463263 | 3463263 | 2022-11-21 | US | Texas | Glasscock | 48173 | 223 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-11-22 04:20:47 | Glasscock, Texas, US | |
617666 | 617666 | 2022-11-05 | China | Ningxia | 223 | 0 | 0 | 37.2692 | 106.1655 | 2022-11-06 04:21:24 | Ningxia, China | |||
1022170 | 1022170 | 2022-11-04 | China | Ningxia | 223 | 0 | 0 | 37.2692 | 106.1655 | 2022-11-05 04:21:52 | Ningxia, China | |||
903253 | 903253 | 2022-07-22 | US | Texas | Foard | 48155 | 223 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-07-23 04:20:53 | Foard, Texas, US | |
941980 | 941980 | 2022-06-25 | US | Texas | Loving | 48301 | 223 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-06-26 04:21:02 | Loving, Texas, US | |
3349800 | 3349800 | 2022-06-24 | US | Texas | Loving | 48301 | 223 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-06-25 04:20:57 | Loving, Texas, US | |
1651541 | 1651541 | 2022-06-23 | US | Texas | Loving | 48301 | 223 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-06-24 04:20:58 | Loving, Texas, US | |
2190776 | 2190776 | 2022-06-22 | US | Texas | Loving | 48301 | 223 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-06-23 04:20:55 | Loving, Texas, US | |
3538593 | 3538593 | 2022-05-10 | US | Texas | Jeff Davis | 48243 | 223 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-05-11 04:20:48 | Jeff Davis, Texas, US | |
225128 | 225128 | 2022-05-09 | US | Texas | Jeff Davis | 48243 | 223 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-05-10 04:20:50 | Jeff Davis, Texas, US | |
2334513 | 2334513 | 2022-05-08 | US | Texas | Jeff Davis | 48243 | 223 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-05-09 04:20:54 | Jeff Davis, Texas, US | |
363475 | 363475 | 2022-05-07 | US | Texas | Jeff Davis | 48243 | 223 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-05-08 04:20:49 | Jeff Davis, Texas, US | |
1400826 | 1400826 | 2022-05-06 | US | Texas | Jeff Davis | 48243 | 223 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-05-07 04:21:09 | Jeff Davis, Texas, US | |
2601181 | 2601181 | 2022-05-05 | US | Texas | Jeff Davis | 48243 | 223 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-05-06 04:21:00 | Jeff Davis, Texas, US | |
3268630 | 3268630 | 2022-05-04 | US | Texas | Jeff Davis | 48243 | 223 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-05-05 04:20:55 | Jeff Davis, Texas, US | |
1575269 | 1575269 | 2022-05-03 | US | Texas | Jeff Davis | 48243 | 223 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-05-04 04:20:59 | Jeff Davis, Texas, US | |
1574143 | 1574143 | 2022-05-03 | US | Montana | Judith Basin | 30045 | 223 | 1 | 0 | 47.04581276 | -110.2660688 | 2022-05-04 04:20:59 | Judith Basin, Montana, US | |
466529 | 466529 | 2022-05-02 | US | Texas | Jeff Davis | 48243 | 223 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-05-03 04:21:00 | Jeff Davis, Texas, US | |
465403 | 465403 | 2022-05-02 | US | Montana | Judith Basin | 30045 | 223 | 1 | 0 | 47.04581276 | -110.2660688 | 2022-05-03 04:21:00 | Judith Basin, Montana, US | |
3919168 | 3919168 | 2022-05-01 | US | Texas | Jeff Davis | 48243 | 223 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-05-02 04:21:10 | Jeff Davis, Texas, US | |
2843972 | 2843972 | 2022-04-30 | US | Texas | Jeff Davis | 48243 | 223 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-05-01 04:20:57 | Jeff Davis, Texas, US | |
1160285 | 1160285 | 2022-04-29 | US | Texas | Jeff Davis | 48243 | 223 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-04-30 04:21:05 | Jeff Davis, Texas, US | |
1699467 | 1699467 | 2022-04-28 | US | Texas | Jeff Davis | 48243 | 223 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-04-29 04:20:59 | Jeff Davis, Texas, US | |
3854950 | 3854950 | 2022-04-27 | US | Texas | Jeff Davis | 48243 | 223 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-04-28 04:20:47 | Jeff Davis, Texas, US | |
1329380 | 1329380 | 2022-04-26 | US | Texas | Jeff Davis | 48243 | 223 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-04-27 04:20:52 | Jeff Davis, Texas, US | |
3725334 | 3725334 | 2022-04-25 | US | Texas | Jeff Davis | 48243 | 223 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-04-26 04:20:51 | Jeff Davis, Texas, US | |
2031902 | 2031902 | 2022-04-24 | US | Texas | Jeff Davis | 48243 | 223 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-04-25 04:20:56 | Jeff Davis, Texas, US | |
749477 | 749477 | 2022-04-23 | US | Texas | Jeff Davis | 48243 | 223 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-04-24 04:20:56 | Jeff Davis, Texas, US | |
3439962 | 3439962 | 2022-04-22 | US | Texas | Jeff Davis | 48243 | 223 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-04-23 04:20:50 | Jeff Davis, Texas, US | |
2895547 | 2895547 | 2022-04-21 | US | Texas | Jeff Davis | 48243 | 223 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-04-22 04:20:45 | Jeff Davis, Texas, US | |
2310419 | 2310419 | 2022-04-20 | US | Texas | Jeff Davis | 48243 | 223 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-04-21 04:20:46 | Jeff Davis, Texas, US | |
2254558 | 2254558 | 2022-04-19 | US | Texas | Jeff Davis | 48243 | 223 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-04-20 04:20:45 | Jeff Davis, Texas, US | |
1849108 | 1849108 | 2022-04-18 | US | Texas | Jeff Davis | 48243 | 223 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-04-19 04:21:00 | Jeff Davis, Texas, US | |
3420052 | 3420052 | 2022-04-17 | US | Texas | Jeff Davis | 48243 | 223 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-04-18 04:21:12 | Jeff Davis, Texas, US | |
307001 | 307001 | 2022-04-16 | US | Texas | Jeff Davis | 48243 | 223 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-04-17 04:20:59 | Jeff Davis, Texas, US | |
2672946 | 2672946 | 2022-04-15 | US | Texas | Jeff Davis | 48243 | 223 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-04-16 04:20:48 | Jeff Davis, Texas, US | |
1226731 | 1226731 | 2022-04-14 | US | Texas | Jeff Davis | 48243 | 223 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-04-15 04:20:57 | Jeff Davis, Texas, US | |
2445889 | 2445889 | 2022-04-13 | US | Texas | Jeff Davis | 48243 | 223 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-04-13 23:21:06 | Jeff Davis, Texas, US | |
1951646 | 1951646 | 2022-04-12 | US | Texas | Jeff Davis | 48243 | 223 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-04-13 04:21:03 | Jeff Davis, Texas, US | |
3209399 | 3209399 | 2022-04-11 | US | Texas | Jeff Davis | 48243 | 223 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-04-12 04:20:49 | Jeff Davis, Texas, US | |
1579285 | 1579285 | 2022-04-10 | US | Texas | Jeff Davis | 48243 | 223 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-04-11 04:21:02 | Jeff Davis, Texas, US | |
1655527 | 1655527 | 2022-04-09 | US | Texas | Jeff Davis | 48243 | 223 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-04-10 04:20:52 | Jeff Davis, Texas, US | |
2118849 | 2118849 | 2022-04-08 | US | Texas | Jeff Davis | 48243 | 223 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-04-09 04:20:42 | Jeff Davis, Texas, US | |
3323373 | 3323373 | 2022-04-07 | US | Texas | Jeff Davis | 48243 | 223 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-04-08 04:20:48 | Jeff Davis, Texas, US | |
2803909 | 2803909 | 2022-04-06 | US | Texas | Jeff Davis | 48243 | 223 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-04-07 04:20:53 | Jeff Davis, Texas, US | |
3870678 | 3870678 | 2022-04-05 | US | Texas | Jeff Davis | 48243 | 223 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-04-06 04:20:49 | Jeff Davis, Texas, US | |
2752020 | 2752020 | 2022-04-04 | US | Texas | Jeff Davis | 48243 | 223 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-04-05 04:20:48 | Jeff Davis, Texas, US | |
3733366 | 3733366 | 2022-04-03 | US | Texas | Jeff Davis | 48243 | 223 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-04-04 04:20:51 | Jeff Davis, Texas, US | |
502801 | 502801 | 2022-04-02 | US | Texas | Jeff Davis | 48243 | 223 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-04-03 04:20:48 | Jeff Davis, Texas, US | |
3353786 | 3353786 | 2022-04-01 | US | Texas | Jeff Davis | 48243 | 223 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-04-02 04:20:47 | Jeff Davis, Texas, US | |
1543091 | 1543091 | 2022-03-31 | US | Texas | Jeff Davis | 48243 | 223 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-04-01 04:20:28 | Jeff Davis, Texas, US | |
2481104 | 2481104 | 2022-03-30 | US | Texas | Jeff Davis | 48243 | 223 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-03-31 04:20:56 | Jeff Davis, Texas, US | |
161145 | 161145 | 2022-03-29 | US | Texas | Jeff Davis | 48243 | 223 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-03-30 04:20:45 | Jeff Davis, Texas, US | |
1439716 | 1439716 | 2022-03-28 | US | Texas | Jeff Davis | 48243 | 223 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-03-29 04:20:46 | Jeff Davis, Texas, US | |
879397 | 879397 | 2022-03-27 | US | Texas | Jeff Davis | 48243 | 223 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-03-28 04:20:33 | Jeff Davis, Texas, US | |
2166680 | 2166680 | 2022-03-26 | US | Texas | Jeff Davis | 48243 | 223 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-03-27 04:20:47 | Jeff Davis, Texas, US | |
1723616 | 1723616 | 2022-03-25 | US | Texas | Jeff Davis | 48243 | 223 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-03-26 04:20:23 | Jeff Davis, Texas, US | |
1471233 | 1471233 | 2022-03-24 | US | Texas | Jeff Davis | 48243 | 223 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-03-25 04:20:46 | Jeff Davis, Texas, US | |
1549972 | 1549972 | 2022-03-07 | US | Montana | Garfield | 30033 | 223 | 3 | 0 | 47.27545948 | -107.0002351 | 2022-03-08 04:20:54 | Garfield, Montana, US | |
2201641 | 2201641 | 2022-03-06 | US | Montana | Garfield | 30033 | 223 | 3 | 0 | 47.27545948 | -107.0002351 | 2022-03-07 04:20:47 | Garfield, Montana, US | |
2094098 | 2094098 | 2022-03-05 | US | Montana | Garfield | 30033 | 223 | 3 | 0 | 47.27545948 | -107.0002351 | 2022-03-06 04:20:49 | Garfield, Montana, US | |
2667798 | 2667798 | 2022-03-04 | US | Montana | Garfield | 30033 | 223 | 3 | 0 | 47.27545948 | -107.0002351 | 2022-03-05 04:21:10 | Garfield, Montana, US | |
1318853 | 1318853 | 2022-01-26 | US | Colorado | Mineral | 8079 | 223 | 2 | 0 | 37.66954283 | -106.92816979999999 | 2022-01-27 04:21:19 | Mineral, Colorado, US | |
3467082 | 3467082 | 2022-01-18 | US | South Dakota | Sully | 46119 | 223 | 3 | 0 | 44.71571812 | -100.1278092 | 2022-01-19 04:21:23 | Sully, South Dakota, US | |
1475021 | 1475021 | 2022-01-17 | US | South Dakota | Sully | 46119 | 223 | 3 | 0 | 44.71571812 | -100.1278092 | 2022-01-18 04:21:04 | Sully, South Dakota, US | |
557695 | 557695 | 2022-01-16 | US | South Dakota | Sully | 46119 | 223 | 3 | 0 | 44.71571812 | -100.1278092 | 2022-01-17 04:21:08 | Sully, South Dakota, US | |
3843416 | 3843416 | 2022-01-15 | US | South Dakota | Sully | 46119 | 223 | 3 | 0 | 44.71571812 | -100.1278092 | 2022-01-16 04:21:12 | Sully, South Dakota, US | |
102231 | 102231 | 2022-01-14 | US | South Dakota | Sully | 46119 | 223 | 3 | 0 | 44.71571812 | -100.1278092 | 2022-01-15 04:21:07 | Sully, South Dakota, US | |
3615921 | 3615921 | 2022-01-12 | US | South Dakota | Campbell | 46021 | 223 | 6 | 0 | 45.77074915 | -100.0510181 | 2022-01-13 08:00:09 | Campbell, South Dakota, US | |
3615700 | 3615700 | 2022-01-12 | US | Oregon | Sherman | 41055 | 223 | 3 | 0 | 45.41501554 | -120.6827834 | 2022-01-13 08:00:09 | Sherman, Oregon, US | |
2112284 | 2112284 | 2021-12-26 | US | California | Sierra | 6091 | 223 | 0 | 0 | 39.57713498 | -120.52007009999998 | 2021-12-27 04:21:58 | Sierra, California, US | |
3605656 | 3605656 | 2021-12-25 | US | California | Sierra | 6091 | 223 | 0 | 0 | 39.57713498 | -120.52007009999998 | 2021-12-26 04:21:50 | Sierra, California, US | |
2963974 | 2963974 | 2021-12-24 | US | California | Sierra | 6091 | 223 | 0 | 0 | 39.57713498 | -120.52007009999998 | 2021-12-25 04:21:37 | Sierra, California, US | |
3819778 | 3819778 | 2021-12-23 | US | Virginia | Highland | 51091 | 223 | 4 | 0 | 38.35799465 | -79.56124594 | 2021-12-24 04:21:34 | Highland, Virginia, US | |
3817006 | 3817006 | 2021-12-23 | US | California | Sierra | 6091 | 223 | 0 | 0 | 39.57713498 | -120.52007009999998 | 2021-12-24 04:21:34 | Sierra, California, US | |
799014 | 799014 | 2021-12-22 | US | California | Sierra | 6091 | 223 | 0 | 0 | 39.57713498 | -120.52007009999998 | 2021-12-23 04:21:21 | Sierra, California, US | |
1257653 | 1257653 | 2021-12-20 | US | South Dakota | Hyde | 46069 | 223 | 5 | 0 | 44.54747703 | -99.48572582 | 2021-12-21 03:21:27 | Hyde, South Dakota, US | |
152133 | 152133 | 2021-11-29 | US | Nevada | Storey | 32029 | 223 | 5 | 0 | 39.44875482 | -119.5250207 | 2021-11-30 04:22:53 | Storey, Nevada, US | |
150425 | 150425 | 2021-11-29 | US | Alaska | Wrangell | 2275 | 223 | 1 | 0 | 56.3202004 | -132.05837309999998 | 2021-11-30 04:22:53 | Wrangell, Alaska, US | |
3513591 | 3513591 | 2021-11-01 | US | New Mexico | Catron | 35003 | 223 | 7 | 0 | 33.91514144 | -108.4046587 | 2021-11-02 04:22:03 | Catron, New Mexico, US | |
2722983 | 2722983 | 2021-10-30 | US | Missouri | Worth | 29227 | 223 | 2 | 0 | 40.47945588 | -94.42328751 | 2021-10-31 04:22:08 | Worth, Missouri, US | |
569085 | 569085 | 2021-10-29 | US | Missouri | Worth | 29227 | 223 | 2 | 0 | 40.47945588 | -94.42328751 | 2021-10-30 04:22:03 | Worth, Missouri, US | |
6327 | 6327 | 2021-10-28 | US | Missouri | Worth | 29227 | 223 | 2 | 0 | 40.47945588 | -94.42328751 | 2021-10-29 04:22:03 | Worth, Missouri, US | |
536717 | 536717 | 2021-10-27 | US | Missouri | Worth | 29227 | 223 | 2 | 0 | 40.47945588 | -94.42328751 | 2021-10-28 04:22:08 | Worth, Missouri, US | |
3494154 | 3494154 | 2021-10-26 | US | Missouri | Worth | 29227 | 223 | 2 | 0 | 40.47945588 | -94.42328751 | 2021-10-27 04:22:32 | Worth, Missouri, 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]);