johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
636 rows where confirmed = 814 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 17
- US 613
- Burkina Faso 3
- Japan 3
- China 2
- Mexico 2
- Ukraine 2
- Australia 1
- Chile 1
- Cuba 1
- Malaysia 1
- Malta 1
- Netherlands 1
- Peru 1
- Russia 1
- Sweden 1
- United Arab Emirates 1
- United Kingdom 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1076471 | 1076471 | 2022-12-28 | US | Oklahoma | Harmon | 40057 | 814 | 12 | 0 | 34.7440135 | -99.84741652 | 2022-12-29 04:21:01 | Harmon, Oklahoma, US | |
330468 | 330468 | 2022-12-27 | US | Oklahoma | Harmon | 40057 | 814 | 12 | 0 | 34.7440135 | -99.84741652 | 2022-12-28 04:21:04 | Harmon, Oklahoma, US | |
220541 | 220541 | 2022-12-26 | US | Oklahoma | Harmon | 40057 | 814 | 12 | 0 | 34.7440135 | -99.84741652 | 2022-12-27 04:21:07 | Harmon, Oklahoma, US | |
3224998 | 3224998 | 2022-12-25 | US | Oklahoma | Harmon | 40057 | 814 | 12 | 0 | 34.7440135 | -99.84741652 | 2022-12-26 04:21:06 | Harmon, Oklahoma, US | |
1020912 | 1020912 | 2022-12-24 | US | Oklahoma | Harmon | 40057 | 814 | 12 | 0 | 34.7440135 | -99.84741652 | 2022-12-25 04:21:04 | Harmon, Oklahoma, US | |
692935 | 692935 | 2022-12-23 | US | Oklahoma | Harmon | 40057 | 814 | 12 | 0 | 34.7440135 | -99.84741652 | 2022-12-24 04:21:02 | Harmon, Oklahoma, US | |
2182145 | 2182145 | 2022-12-22 | US | Oklahoma | Harmon | 40057 | 814 | 12 | 0 | 34.7440135 | -99.84741652 | 2022-12-23 04:21:04 | Harmon, Oklahoma, US | |
2954537 | 2954537 | 2022-12-20 | US | Texas | Kinney | 48271 | 814 | 13 | 0 | 29.34967888 | -100.4186638 | 2022-12-21 04:21:03 | Kinney, Texas, US | |
3176939 | 3176939 | 2022-12-19 | US | Texas | Kinney | 48271 | 814 | 13 | 0 | 29.34967888 | -100.4186638 | 2022-12-20 04:21:04 | Kinney, Texas, US | |
1631456 | 1631456 | 2022-12-18 | US | Texas | Kinney | 48271 | 814 | 13 | 0 | 29.34967888 | -100.4186638 | 2022-12-19 04:21:03 | Kinney, Texas, US | |
506835 | 506835 | 2022-12-17 | US | Texas | Kinney | 48271 | 814 | 13 | 0 | 29.34967888 | -100.4186638 | 2022-12-18 04:21:03 | Kinney, Texas, US | |
3327407 | 3327407 | 2022-12-16 | US | Texas | Kinney | 48271 | 814 | 13 | 0 | 29.34967888 | -100.4186638 | 2022-12-17 04:21:04 | Kinney, Texas, US | |
545919 | 545919 | 2022-12-15 | US | Texas | Kinney | 48271 | 814 | 13 | 0 | 29.34967888 | -100.4186638 | 2022-12-16 04:21:01 | Kinney, Texas, US | |
351447 | 351447 | 2022-12-14 | US | Texas | Kinney | 48271 | 814 | 13 | 0 | 29.34967888 | -100.4186638 | 2022-12-15 04:20:58 | Kinney, Texas, US | |
1986425 | 1986425 | 2022-12-07 | US | Minnesota | Unassigned | 90027 | 814 | 378 | 0 | 48.77754106 | 0.0 | 2022-12-08 04:21:07 | Unassigned, Minnesota, US | |
3715948 | 3715948 | 2022-12-06 | US | Minnesota | Unassigned | 90027 | 814 | 378 | 0 | 48.77754106 | 0.0 | 2022-12-07 04:20:58 | Unassigned, Minnesota, US | |
2416653 | 2416653 | 2022-12-05 | US | Minnesota | Unassigned | 90027 | 814 | 378 | 0 | 48.77754106 | 0.0 | 2022-12-06 04:21:03 | Unassigned, Minnesota, US | |
720261 | 720261 | 2022-12-04 | US | Minnesota | Unassigned | 90027 | 814 | 378 | 0 | 48.77754106 | 0.0 | 2022-12-05 04:20:58 | Unassigned, Minnesota, US | |
2818550 | 2818550 | 2022-12-03 | US | Minnesota | Unassigned | 90027 | 814 | 378 | 0 | 48.77754106 | 0.0 | 2022-12-04 04:20:56 | Unassigned, Minnesota, US | |
835406 | 835406 | 2022-12-02 | US | Minnesota | Unassigned | 90027 | 814 | 378 | 0 | 48.77754106 | 0.0 | 2022-12-03 04:21:02 | Unassigned, Minnesota, US | |
2137936 | 2137936 | 2022-12-01 | US | Minnesota | Unassigned | 90027 | 814 | 378 | 0 | 48.77754106 | 0.0 | 2022-12-02 04:21:07 | Unassigned, Minnesota, US | |
1967136 | 1967136 | 2022-11-30 | US | Oklahoma | Harper | 40059 | 814 | 12 | 0 | 36.78836519 | -99.6679804 | 2022-12-01 04:21:03 | Harper, Oklahoma, US | |
2559150 | 2559150 | 2022-11-29 | US | Oklahoma | Harper | 40059 | 814 | 12 | 0 | 36.78836519 | -99.6679804 | 2022-11-30 04:21:07 | Harper, Oklahoma, US | |
1242224 | 1242224 | 2022-11-28 | US | Oklahoma | Harper | 40059 | 814 | 12 | 0 | 36.78836519 | -99.6679804 | 2022-11-29 04:21:05 | Harper, Oklahoma, US | |
3554212 | 3554212 | 2022-11-27 | US | Oklahoma | Harper | 40059 | 814 | 12 | 0 | 36.78836519 | -99.6679804 | 2022-11-28 04:21:02 | Harper, Oklahoma, US | |
2102692 | 2102692 | 2022-11-26 | US | Oklahoma | Harper | 40059 | 814 | 12 | 0 | 36.78836519 | -99.6679804 | 2022-11-27 04:21:05 | Harper, Oklahoma, US | |
490183 | 490183 | 2022-11-25 | US | Oklahoma | Harper | 40059 | 814 | 12 | 0 | 36.78836519 | -99.6679804 | 2022-11-26 04:21:11 | Harper, Oklahoma, US | |
3526012 | 3526012 | 2022-11-24 | US | Oklahoma | Harper | 40059 | 814 | 12 | 0 | 36.78836519 | -99.6679804 | 2022-11-25 04:21:06 | Harper, Oklahoma, US | |
3599176 | 3599176 | 2022-11-14 | US | Nebraska | Valley | 31175 | 814 | 11 | 0 | 41.56730777 | -98.98197724 | 2022-11-15 04:21:16 | Valley, Nebraska, US | |
314034 | 314034 | 2022-11-13 | US | Nebraska | Valley | 31175 | 814 | 11 | 0 | 41.56730777 | -98.98197724 | 2022-11-14 04:21:09 | Valley, Nebraska, US | |
65195 | 65195 | 2022-11-12 | US | Nebraska | Valley | 31175 | 814 | 11 | 0 | 41.56730777 | -98.98197724 | 2022-11-13 04:21:14 | Valley, Nebraska, US | |
2929357 | 2929357 | 2022-11-11 | US | Nebraska | Valley | 31175 | 814 | 11 | 0 | 41.56730777 | -98.98197724 | 2022-11-12 04:20:41 | Valley, Nebraska, US | |
2508193 | 2508193 | 2022-11-10 | US | Nebraska | Valley | 31175 | 814 | 11 | 0 | 41.56730777 | -98.98197724 | 2022-11-11 04:21:22 | Valley, Nebraska, US | |
2433068 | 2433068 | 2022-11-09 | US | Nebraska | Valley | 31175 | 814 | 11 | 0 | 41.56730777 | -98.98197724 | 2022-11-10 04:21:16 | Valley, Nebraska, US | |
481724 | 481724 | 2022-11-08 | US | Nebraska | Valley | 31175 | 814 | 11 | 0 | 41.56730777 | -98.98197724 | 2022-11-09 04:21:22 | Valley, Nebraska, US | |
2440874 | 2440874 | 2022-11-07 | US | Nebraska | Valley | 31175 | 814 | 11 | 0 | 41.56730777 | -98.98197724 | 2022-11-08 04:21:21 | Valley, Nebraska, US | |
1051972 | 1051972 | 2022-11-06 | US | Nebraska | Valley | 31175 | 814 | 11 | 0 | 41.56730777 | -98.98197724 | 2022-11-07 04:21:26 | Valley, Nebraska, US | |
619996 | 619996 | 2022-11-05 | US | Nebraska | Valley | 31175 | 814 | 11 | 0 | 41.56730777 | -98.98197724 | 2022-11-06 04:21:24 | Valley, Nebraska, US | |
1024500 | 1024500 | 2022-11-04 | US | Nebraska | Valley | 31175 | 814 | 11 | 0 | 41.56730777 | -98.98197724 | 2022-11-05 04:21:52 | Valley, Nebraska, US | |
433491 | 433491 | 2022-11-03 | US | Nebraska | Valley | 31175 | 814 | 11 | 0 | 41.56730777 | -98.98197724 | 2022-11-04 04:22:11 | Valley, Nebraska, US | |
851733 | 851733 | 2022-11-02 | US | Nebraska | Valley | 31175 | 814 | 11 | 0 | 41.56730777 | -98.98197724 | 2022-11-03 04:22:05 | Valley, Nebraska, US | |
712584 | 712584 | 2022-11-01 | US | Nebraska | Valley | 31175 | 814 | 11 | 0 | 41.56730777 | -98.98197724 | 2022-11-02 04:22:09 | Valley, Nebraska, US | |
3287033 | 3287033 | 2022-10-31 | US | Nebraska | Valley | 31175 | 814 | 11 | 0 | 41.56730777 | -98.98197724 | 2022-11-01 04:22:36 | Valley, Nebraska, US | |
322066 | 322066 | 2022-10-30 | US | Nebraska | Valley | 31175 | 814 | 11 | 0 | 41.56730777 | -98.98197724 | 2022-10-31 04:21:36 | Valley, Nebraska, US | |
914342 | 914342 | 2022-10-29 | US | Nebraska | Valley | 31175 | 814 | 11 | 0 | 41.56730777 | -98.98197724 | 2022-10-30 04:22:14 | Valley, Nebraska, US | |
1368611 | 1368611 | 2022-10-28 | US | Nebraska | Valley | 31175 | 814 | 11 | 0 | 41.56730777 | -98.98197724 | 2022-10-29 04:21:13 | Valley, Nebraska, US | |
3040466 | 3040466 | 2022-10-27 | US | Nebraska | Valley | 31175 | 814 | 11 | 0 | 41.56730777 | -98.98197724 | 2022-10-28 04:22:31 | Valley, Nebraska, US | |
540886 | 540886 | 2022-10-26 | US | Nebraska | Valley | 31175 | 814 | 11 | 0 | 41.56730777 | -98.98197724 | 2022-10-27 04:22:01 | Valley, Nebraska, US | |
3988561 | 3988561 | 2022-09-15 | US | Missouri | Mercer | 29129 | 814 | 14 | 0 | 40.42212303 | -93.5682959 | 2022-09-16 04:21:19 | Mercer, Missouri, US | |
1891078 | 1891078 | 2022-09-14 | US | Missouri | Mercer | 29129 | 814 | 14 | 0 | 40.42212303 | -93.5682959 | 2022-09-15 04:21:02 | Mercer, Missouri, US | |
374133 | 374133 | 2022-09-13 | US | Missouri | Mercer | 29129 | 814 | 14 | 0 | 40.42212303 | -93.5682959 | 2022-09-14 04:20:44 | Mercer, Missouri, US | |
2396735 | 2396735 | 2022-09-12 | US | Missouri | Mercer | 29129 | 814 | 14 | 0 | 40.42212303 | -93.5682959 | 2022-09-13 04:20:57 | Mercer, Missouri, US | |
3767813 | 3767813 | 2022-09-11 | US | Missouri | Mercer | 29129 | 814 | 14 | 0 | 40.42212303 | -93.5682959 | 2022-09-12 04:20:58 | Mercer, Missouri, US | |
3826388 | 3826388 | 2022-09-10 | US | Missouri | Mercer | 29129 | 814 | 14 | 0 | 40.42212303 | -93.5682959 | 2022-09-11 04:20:50 | Mercer, Missouri, US | |
964845 | 964845 | 2022-09-09 | US | Missouri | Mercer | 29129 | 814 | 14 | 0 | 40.42212303 | -93.5682959 | 2022-09-10 04:21:10 | Mercer, Missouri, US | |
1072293 | 1072293 | 2022-08-07 | US | North Dakota | Eddy | 38027 | 814 | 6 | 0 | 47.71701474 | -98.90432337 | 2022-08-08 04:21:08 | Eddy, North Dakota, US | |
1942881 | 1942881 | 2022-08-06 | US | North Dakota | Eddy | 38027 | 814 | 6 | 0 | 47.71701474 | -98.90432337 | 2022-08-07 04:20:54 | Eddy, North Dakota, US | |
3111221 | 3111221 | 2022-07-13 | US | Minnesota | Lake of the Woods | 27077 | 814 | 6 | 0 | 48.77217001 | -94.90274472 | 2022-07-14 04:20:57 | Lake of the Woods, Minnesota, US | |
631644 | 631644 | 2022-07-12 | US | Minnesota | Lake of the Woods | 27077 | 814 | 6 | 0 | 48.77217001 | -94.90274472 | 2022-07-13 04:20:58 | Lake of the Woods, Minnesota, US | |
630520 | 630520 | 2022-07-12 | US | Colorado | Costilla | 8023 | 814 | 18 | 0 | 37.27732493 | -105.4276548 | 2022-07-13 04:20:58 | Costilla, Colorado, US | |
1213288 | 1213288 | 2022-07-11 | US | Minnesota | Lake of the Woods | 27077 | 814 | 6 | 0 | 48.77217001 | -94.90274472 | 2022-07-12 04:20:51 | Lake of the Woods, Minnesota, US | |
2790770 | 2790770 | 2022-07-10 | US | Minnesota | Lake of the Woods | 27077 | 814 | 6 | 0 | 48.77217001 | -94.90274472 | 2022-07-11 04:20:46 | Lake of the Woods, Minnesota, US | |
143723 | 143723 | 2022-07-09 | US | Minnesota | Lake of the Woods | 27077 | 814 | 6 | 0 | 48.77217001 | -94.90274472 | 2022-07-10 04:20:54 | Lake of the Woods, Minnesota, US | |
1418823 | 1418823 | 2022-07-08 | US | Minnesota | Lake of the Woods | 27077 | 814 | 6 | 0 | 48.77217001 | -94.90274472 | 2022-07-09 04:20:59 | Lake of the Woods, Minnesota, US | |
2742748 | 2742748 | 2022-07-07 | US | Minnesota | Lake of the Woods | 27077 | 814 | 6 | 0 | 48.77217001 | -94.90274472 | 2022-07-08 04:20:56 | Lake of the Woods, Minnesota, US | |
3969399 | 3969399 | 2022-07-05 | US | South Dakota | Aurora | 46003 | 814 | 17 | 0 | 43.71757685 | -98.56050467 | 2022-07-06 04:20:58 | Aurora, South Dakota, US | |
3080910 | 3080910 | 2022-07-04 | US | South Dakota | Aurora | 46003 | 814 | 17 | 0 | 43.71757685 | -98.56050467 | 2022-07-05 04:20:45 | Aurora, South Dakota, US | |
1770192 | 1770192 | 2022-07-03 | US | South Dakota | Aurora | 46003 | 814 | 17 | 0 | 43.71757685 | -98.56050467 | 2022-07-04 04:20:54 | Aurora, South Dakota, US | |
3368178 | 3368178 | 2022-07-02 | US | South Dakota | Aurora | 46003 | 814 | 17 | 0 | 43.71757685 | -98.56050467 | 2022-07-03 04:20:59 | Aurora, South Dakota, US | |
596507 | 596507 | 2022-07-01 | US | South Dakota | Aurora | 46003 | 814 | 17 | 0 | 43.71757685 | -98.56050467 | 2022-07-02 04:21:16 | Aurora, South Dakota, US | |
3942908 | 3942908 | 2022-06-30 | US | South Dakota | Aurora | 46003 | 814 | 17 | 0 | 43.71757685 | -98.56050467 | 2022-07-01 04:21:10 | Aurora, South Dakota, US | |
3942279 | 3942279 | 2022-06-30 | US | New Mexico | Union | 35059 | 814 | 17 | 0 | 36.48126404 | -103.4709624 | 2022-07-01 04:21:10 | Union, New Mexico, US | |
2492866 | 2492866 | 2022-06-29 | US | South Dakota | Aurora | 46003 | 814 | 17 | 0 | 43.71757685 | -98.56050467 | 2022-06-30 04:21:01 | Aurora, South Dakota, US | |
2240729 | 2240729 | 2022-06-28 | US | Kansas | Osborne | 20141 | 814 | 19 | 0 | 39.3503437 | -98.76753828 | 2022-06-29 04:20:59 | Osborne, Kansas, US | |
2148971 | 2148971 | 2022-06-27 | US | Kansas | Osborne | 20141 | 814 | 19 | 0 | 39.3503437 | -98.76753828 | 2022-06-28 04:20:58 | Osborne, Kansas, US | |
476772 | 476772 | 2022-06-26 | US | Kansas | Osborne | 20141 | 814 | 19 | 0 | 39.3503437 | -98.76753828 | 2022-06-27 04:21:00 | Osborne, Kansas, US | |
940147 | 940147 | 2022-06-25 | US | Kansas | Osborne | 20141 | 814 | 19 | 0 | 39.3503437 | -98.76753828 | 2022-06-26 04:21:02 | Osborne, Kansas, US | |
3347967 | 3347967 | 2022-06-24 | US | Kansas | Osborne | 20141 | 814 | 19 | 0 | 39.3503437 | -98.76753828 | 2022-06-25 04:20:57 | Osborne, Kansas, US | |
1649708 | 1649708 | 2022-06-23 | US | Kansas | Osborne | 20141 | 814 | 19 | 0 | 39.3503437 | -98.76753828 | 2022-06-24 04:20:58 | Osborne, Kansas, US | |
2188943 | 2188943 | 2022-06-22 | US | Kansas | Osborne | 20141 | 814 | 19 | 0 | 39.3503437 | -98.76753828 | 2022-06-23 04:20:55 | Osborne, Kansas, US | |
948179 | 948179 | 2022-06-14 | US | Kansas | Osborne | 20141 | 814 | 19 | 0 | 39.3503437 | -98.76753828 | 2022-06-15 04:20:54 | Osborne, Kansas, US | |
2980587 | 2980587 | 2022-06-13 | US | Kansas | Osborne | 20141 | 814 | 19 | 0 | 39.3503437 | -98.76753828 | 2022-06-14 04:20:52 | Osborne, Kansas, US | |
2236713 | 2236713 | 2022-06-12 | US | Kansas | Osborne | 20141 | 814 | 19 | 0 | 39.3503437 | -98.76753828 | 2022-06-13 04:21:14 | Osborne, Kansas, US | |
3142911 | 3142911 | 2022-06-11 | US | Kansas | Osborne | 20141 | 814 | 19 | 0 | 39.3503437 | -98.76753828 | 2022-06-12 04:20:53 | Osborne, Kansas, US | |
1945827 | 1945827 | 2022-06-10 | US | Kansas | Osborne | 20141 | 814 | 19 | 0 | 39.3503437 | -98.76753828 | 2022-06-11 04:21:01 | Osborne, Kansas, US | |
3158966 | 3158966 | 2022-06-09 | US | Kansas | Osborne | 20141 | 814 | 19 | 0 | 39.3503437 | -98.76753828 | 2022-06-10 04:20:55 | Osborne, Kansas, US | |
1422433 | 1422433 | 2022-06-08 | US | Kansas | Osborne | 20141 | 814 | 19 | 0 | 39.3503437 | -98.76753828 | 2022-06-09 04:20:54 | Osborne, Kansas, US | |
1400897 | 1400897 | 2022-05-06 | US | Texas | Real | 48385 | 814 | 25 | 0 | 29.83321503 | -99.82018052 | 2022-05-07 04:21:09 | Real, Texas, US | |
2601252 | 2601252 | 2022-05-05 | US | Texas | Real | 48385 | 814 | 25 | 0 | 29.83321503 | -99.82018052 | 2022-05-06 04:21:00 | Real, Texas, US | |
3268701 | 3268701 | 2022-05-04 | US | Texas | Real | 48385 | 814 | 25 | 0 | 29.83321503 | -99.82018052 | 2022-05-05 04:20:55 | Real, Texas, US | |
1575340 | 1575340 | 2022-05-03 | US | Texas | Real | 48385 | 814 | 25 | 0 | 29.83321503 | -99.82018052 | 2022-05-04 04:20:59 | Real, Texas, US | |
466600 | 466600 | 2022-05-02 | US | Texas | Real | 48385 | 814 | 25 | 0 | 29.83321503 | -99.82018052 | 2022-05-03 04:21:00 | Real, Texas, US | |
1578809 | 1578809 | 2022-04-10 | US | Pennsylvania | Cameron | 42023 | 814 | 20 | 0 | 41.43625568 | -78.20376845 | 2022-04-11 04:21:02 | Cameron, Pennsylvania, US | |
1655051 | 1655051 | 2022-04-09 | US | Pennsylvania | Cameron | 42023 | 814 | 20 | 0 | 41.43625568 | -78.20376845 | 2022-04-10 04:20:52 | Cameron, Pennsylvania, US | |
2118373 | 2118373 | 2022-04-08 | US | Pennsylvania | Cameron | 42023 | 814 | 20 | 0 | 41.43625568 | -78.20376845 | 2022-04-09 04:20:42 | Cameron, Pennsylvania, US | |
3322897 | 3322897 | 2022-04-07 | US | Pennsylvania | Cameron | 42023 | 814 | 20 | 0 | 41.43625568 | -78.20376845 | 2022-04-08 04:20:48 | Cameron, Pennsylvania, US | |
2803433 | 2803433 | 2022-04-06 | US | Pennsylvania | Cameron | 42023 | 814 | 20 | 0 | 41.43625568 | -78.20376845 | 2022-04-07 04:20:53 | Cameron, Pennsylvania, US | |
3870202 | 3870202 | 2022-04-05 | US | Pennsylvania | Cameron | 42023 | 814 | 20 | 0 | 41.43625568 | -78.20376845 | 2022-04-06 04:20:49 | Cameron, Pennsylvania, US | |
2751544 | 2751544 | 2022-04-04 | US | Pennsylvania | Cameron | 42023 | 814 | 20 | 0 | 41.43625568 | -78.20376845 | 2022-04-05 04:20:48 | Cameron, Pennsylvania, US | |
2751282 | 2751282 | 2022-04-04 | US | North Dakota | Cavalier | 38019 | 814 | 7 | 0 | 48.77286211 | -98.46685243 | 2022-04-05 04:20:48 | Cavalier, North Dakota, 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]);