johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
451 rows where confirmed = 1201 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 14
- US 425
- China 6
- Niger 4
- Sweden 4
- Antigua and Barbuda 2
- Australia 2
- Armenia 1
- Japan 1
- Jordan 1
- Netherlands 1
- Pakistan 1
- Russia 1
- Seychelles 1
- Ukraine 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2755780 | 2755780 | 2022-12-29 | US | South Dakota | Gregory | 46053 | 1201 | 34 | 0 | 43.19419064 | -99.18883902 | 2022-12-30 04:21:04 | Gregory, South Dakota, US | |
1076786 | 1076786 | 2022-12-28 | US | South Dakota | Gregory | 46053 | 1201 | 34 | 0 | 43.19419064 | -99.18883902 | 2022-12-29 04:21:01 | Gregory, South Dakota, US | |
2137199 | 2137199 | 2022-12-01 | US | Illinois | Pope | 17151 | 1201 | 9 | 0 | 37.41391284 | -88.56152109 | 2022-12-02 04:21:07 | Pope, Illinois, US | |
133179 | 133179 | 2022-10-04 | US | North Dakota | Sargent | 38081 | 1201 | 9 | 0 | 46.10830372 | -97.63217159 | 2022-10-05 04:23:06 | Sargent, North Dakota, US | |
131999 | 131999 | 2022-10-04 | US | Iowa | Unassigned | 90019 | 1201 | 0 | 0 | 43.38107862 | 0.0 | 2022-10-05 04:23:06 | Unassigned, Iowa, US | |
1562652 | 1562652 | 2022-09-28 | US | Oklahoma | Grant | 40053 | 1201 | 17 | 0 | 36.796297 | -97.78638765 | 2022-09-29 04:22:34 | Grant, Oklahoma, US | |
3997195 | 3997195 | 2022-09-27 | US | Oklahoma | Grant | 40053 | 1201 | 17 | 0 | 36.796297 | -97.78638765 | 2022-09-28 04:23:01 | Grant, Oklahoma, US | |
2771523 | 2771523 | 2022-09-26 | US | Oklahoma | Grant | 40053 | 1201 | 17 | 0 | 36.796297 | -97.78638765 | 2022-09-27 04:23:01 | Grant, Oklahoma, US | |
1979176 | 1979176 | 2022-09-25 | US | Oklahoma | Grant | 40053 | 1201 | 17 | 0 | 36.796297 | -97.78638765 | 2022-09-26 04:20:52 | Grant, Oklahoma, US | |
2652343 | 2652343 | 2022-09-24 | US | Oklahoma | Grant | 40053 | 1201 | 17 | 0 | 36.796297 | -97.78638765 | 2022-09-25 04:23:31 | Grant, Oklahoma, US | |
386783 | 386783 | 2022-09-23 | US | Oklahoma | Grant | 40053 | 1201 | 17 | 0 | 36.796297 | -97.78638765 | 2022-09-24 04:21:40 | Grant, Oklahoma, US | |
1626849 | 1626849 | 2022-09-22 | US | Oklahoma | Grant | 40053 | 1201 | 17 | 0 | 36.796297 | -97.78638765 | 2022-09-23 04:23:13 | Grant, Oklahoma, US | |
3572277 | 3572277 | 2022-09-19 | US | Michigan | Ontonagon | 26131 | 1201 | 43 | 0 | 46.6652262 | -89.31390481 | 2022-09-20 04:22:48 | Ontonagon, Michigan, US | |
421016 | 421016 | 2022-09-18 | US | Michigan | Ontonagon | 26131 | 1201 | 43 | 0 | 46.6652262 | -89.31390481 | 2022-09-19 04:21:49 | Ontonagon, Michigan, US | |
3375040 | 3375040 | 2022-09-17 | US | Michigan | Ontonagon | 26131 | 1201 | 43 | 0 | 46.6652262 | -89.31390481 | 2022-09-18 04:22:50 | Ontonagon, Michigan, US | |
2357148 | 2357148 | 2022-09-16 | US | Michigan | Ontonagon | 26131 | 1201 | 43 | 0 | 46.6652262 | -89.31390481 | 2022-09-17 04:20:19 | Ontonagon, Michigan, US | |
3988305 | 3988305 | 2022-09-15 | US | Michigan | Ontonagon | 26131 | 1201 | 43 | 0 | 46.6652262 | -89.31390481 | 2022-09-16 04:21:19 | Ontonagon, Michigan, US | |
3987576 | 3987576 | 2022-09-15 | US | Idaho | Lincoln | 16063 | 1201 | 15 | 0 | 43.0012336 | -114.1358773 | 2022-09-16 04:21:19 | Lincoln, Idaho, US | |
1890822 | 1890822 | 2022-09-14 | US | Michigan | Ontonagon | 26131 | 1201 | 43 | 0 | 46.6652262 | -89.31390481 | 2022-09-15 04:21:02 | Ontonagon, Michigan, US | |
1890093 | 1890093 | 2022-09-14 | US | Idaho | Lincoln | 16063 | 1201 | 15 | 0 | 43.0012336 | -114.1358773 | 2022-09-15 04:21:02 | Lincoln, Idaho, US | |
373877 | 373877 | 2022-09-13 | US | Michigan | Ontonagon | 26131 | 1201 | 43 | 0 | 46.6652262 | -89.31390481 | 2022-09-14 04:20:44 | Ontonagon, Michigan, US | |
3765691 | 3765691 | 2022-09-11 | China | Tibet | 1201 | 0 | 0 | 31.6927 | 88.0924 | 2022-09-12 04:20:58 | Tibet, China | |||
115915 | 115915 | 2022-09-06 | US | Iowa | Audubon | 19009 | 1201 | 21 | 0 | 41.6844628 | -94.90581859 | 2022-09-07 04:20:59 | Audubon, Iowa, US | |
115650 | 115650 | 2022-09-06 | US | Georgia | Warren | 13301 | 1201 | 31 | 0 | 33.41146451 | -82.67795848 | 2022-09-07 04:20:59 | Warren, Georgia, US | |
2634887 | 2634887 | 2022-09-05 | US | Iowa | Audubon | 19009 | 1201 | 21 | 0 | 41.6844628 | -94.90581859 | 2022-09-06 04:21:02 | Audubon, Iowa, US | |
2634622 | 2634622 | 2022-09-05 | US | Georgia | Warren | 13301 | 1201 | 31 | 0 | 33.41146451 | -82.67795848 | 2022-09-06 04:21:02 | Warren, Georgia, US | |
2988451 | 2988451 | 2022-09-04 | US | Iowa | Audubon | 19009 | 1201 | 21 | 0 | 41.6844628 | -94.90581859 | 2022-09-05 04:21:01 | Audubon, Iowa, US | |
2988186 | 2988186 | 2022-09-04 | US | Georgia | Warren | 13301 | 1201 | 31 | 0 | 33.41146451 | -82.67795848 | 2022-09-05 04:21:01 | Warren, Georgia, US | |
2714136 | 2714136 | 2022-09-03 | US | Iowa | Audubon | 19009 | 1201 | 21 | 0 | 41.6844628 | -94.90581859 | 2022-09-04 04:21:22 | Audubon, Iowa, US | |
2713871 | 2713871 | 2022-09-03 | US | Georgia | Warren | 13301 | 1201 | 31 | 0 | 33.41146451 | -82.67795848 | 2022-09-04 04:21:22 | Warren, Georgia, US | |
1394841 | 1394841 | 2022-09-02 | US | Iowa | Audubon | 19009 | 1201 | 21 | 0 | 41.6844628 | -94.90581859 | 2022-09-03 04:21:04 | Audubon, Iowa, US | |
1394576 | 1394576 | 2022-09-02 | US | Georgia | Warren | 13301 | 1201 | 31 | 0 | 33.41146451 | -82.67795848 | 2022-09-03 04:21:04 | Warren, Georgia, US | |
3548670 | 3548670 | 2022-09-01 | US | Iowa | Audubon | 19009 | 1201 | 21 | 0 | 41.6844628 | -94.90581859 | 2022-09-02 04:21:07 | Audubon, Iowa, US | |
3548405 | 3548405 | 2022-09-01 | US | Georgia | Warren | 13301 | 1201 | 31 | 0 | 33.41146451 | -82.67795848 | 2022-09-02 04:21:07 | Warren, Georgia, US | |
2344590 | 2344590 | 2022-08-31 | US | Iowa | Audubon | 19009 | 1201 | 21 | 0 | 41.6844628 | -94.90581859 | 2022-09-01 04:21:03 | Audubon, Iowa, US | |
2344325 | 2344325 | 2022-08-31 | US | Georgia | Warren | 13301 | 1201 | 31 | 0 | 33.41146451 | -82.67795848 | 2022-09-01 04:21:03 | Warren, Georgia, US | |
1682606 | 1682606 | 2022-08-29 | US | Nebraska | Morrill | 31123 | 1201 | 20 | 0 | 41.71711774 | -103.0061405 | 2022-08-30 04:21:03 | Morrill, Nebraska, US | |
1879090 | 1879090 | 2022-08-28 | US | Nebraska | Morrill | 31123 | 1201 | 20 | 0 | 41.71711774 | -103.0061405 | 2022-08-29 04:21:06 | Morrill, Nebraska, US | |
2098217 | 2098217 | 2022-08-27 | US | Nebraska | Morrill | 31123 | 1201 | 20 | 0 | 41.71711774 | -103.0061405 | 2022-08-28 04:21:02 | Morrill, Nebraska, US | |
1534032 | 1534032 | 2022-08-26 | US | Nebraska | Morrill | 31123 | 1201 | 20 | 0 | 41.71711774 | -103.0061405 | 2022-08-27 04:20:57 | Morrill, Nebraska, US | |
2830919 | 2830919 | 2022-08-25 | US | Nebraska | Morrill | 31123 | 1201 | 20 | 0 | 41.71711774 | -103.0061405 | 2022-08-26 04:21:02 | Morrill, Nebraska, US | |
2325452 | 2325452 | 2022-08-24 | US | Nebraska | Morrill | 31123 | 1201 | 20 | 0 | 41.71711774 | -103.0061405 | 2022-08-25 04:21:13 | Morrill, Nebraska, US | |
1252861 | 1252861 | 2022-08-23 | US | Nebraska | Morrill | 31123 | 1201 | 20 | 0 | 41.71711774 | -103.0061405 | 2022-08-24 04:20:46 | Morrill, Nebraska, US | |
2854965 | 2854965 | 2022-08-22 | US | Nebraska | Morrill | 31123 | 1201 | 20 | 0 | 41.71711774 | -103.0061405 | 2022-08-23 04:20:56 | Morrill, Nebraska, US | |
2406379 | 2406379 | 2022-08-21 | US | Wisconsin | Florence | 55037 | 1201 | 17 | 0 | 45.84963535 | -88.39804137 | 2022-08-22 04:20:38 | Florence, Wisconsin, US | |
2404937 | 2404937 | 2022-08-21 | US | Nebraska | Morrill | 31123 | 1201 | 20 | 0 | 41.71711774 | -103.0061405 | 2022-08-22 04:20:38 | Morrill, Nebraska, US | |
3801457 | 3801457 | 2022-08-20 | US | Wisconsin | Florence | 55037 | 1201 | 17 | 0 | 45.84963535 | -88.39804137 | 2022-08-21 04:20:44 | Florence, Wisconsin, US | |
3800015 | 3800015 | 2022-08-20 | US | Nebraska | Morrill | 31123 | 1201 | 20 | 0 | 41.71711774 | -103.0061405 | 2022-08-21 04:20:44 | Morrill, Nebraska, US | |
2367043 | 2367043 | 2022-08-19 | US | Wisconsin | Florence | 55037 | 1201 | 17 | 0 | 45.84963535 | -88.39804137 | 2022-08-20 04:21:01 | Florence, Wisconsin, US | |
2365601 | 2365601 | 2022-08-19 | US | Nebraska | Morrill | 31123 | 1201 | 20 | 0 | 41.71711774 | -103.0061405 | 2022-08-20 04:21:01 | Morrill, Nebraska, US | |
1163272 | 1163272 | 2022-08-18 | US | Nebraska | Morrill | 31123 | 1201 | 20 | 0 | 41.71711774 | -103.0061405 | 2022-08-19 04:20:54 | Morrill, Nebraska, US | |
3952596 | 3952596 | 2022-08-17 | US | Nebraska | Morrill | 31123 | 1201 | 20 | 0 | 41.71711774 | -103.0061405 | 2022-08-18 04:21:11 | Morrill, Nebraska, US | |
993098 | 993098 | 2022-08-16 | US | Nebraska | Morrill | 31123 | 1201 | 20 | 0 | 41.71711774 | -103.0061405 | 2022-08-17 04:20:59 | Morrill, Nebraska, US | |
2496137 | 2496137 | 2022-08-15 | US | Nebraska | Morrill | 31123 | 1201 | 20 | 0 | 41.71711774 | -103.0061405 | 2022-08-16 04:20:58 | Morrill, Nebraska, US | |
3967429 | 3967429 | 2022-07-05 | US | Georgia | Talbot | 13263 | 1201 | 33 | 0 | 32.69642758 | -84.53351366 | 2022-07-06 04:20:58 | Talbot, Georgia, US | |
3078940 | 3078940 | 2022-07-04 | US | Georgia | Talbot | 13263 | 1201 | 33 | 0 | 32.69642758 | -84.53351366 | 2022-07-05 04:20:45 | Talbot, Georgia, US | |
1768222 | 1768222 | 2022-07-03 | US | Georgia | Talbot | 13263 | 1201 | 33 | 0 | 32.69642758 | -84.53351366 | 2022-07-04 04:20:54 | Talbot, Georgia, US | |
3366208 | 3366208 | 2022-07-02 | US | Georgia | Talbot | 13263 | 1201 | 33 | 0 | 32.69642758 | -84.53351366 | 2022-07-03 04:20:59 | Talbot, Georgia, US | |
594537 | 594537 | 2022-07-01 | US | Georgia | Talbot | 13263 | 1201 | 33 | 0 | 32.69642758 | -84.53351366 | 2022-07-02 04:21:16 | Talbot, Georgia, US | |
3940938 | 3940938 | 2022-06-30 | US | Georgia | Talbot | 13263 | 1201 | 33 | 0 | 32.69642758 | -84.53351366 | 2022-07-01 04:21:10 | Talbot, Georgia, US | |
2490896 | 2490896 | 2022-06-29 | US | Georgia | Talbot | 13263 | 1201 | 33 | 0 | 32.69642758 | -84.53351366 | 2022-06-30 04:21:01 | Talbot, Georgia, US | |
478697 | 478697 | 2022-06-26 | US | Texas | Wheeler | 48483 | 1201 | 22 | 0 | 35.40114335 | -100.2699514 | 2022-06-27 04:21:00 | Wheeler, Texas, US | |
476483 | 476483 | 2022-06-26 | US | Illinois | Putnam | 17155 | 1201 | 9 | 0 | 41.2013541 | -89.2869272 | 2022-06-27 04:21:00 | Putnam, Illinois, US | |
942072 | 942072 | 2022-06-25 | US | Texas | Wheeler | 48483 | 1201 | 22 | 0 | 35.40114335 | -100.2699514 | 2022-06-26 04:21:02 | Wheeler, Texas, US | |
939858 | 939858 | 2022-06-25 | US | Illinois | Putnam | 17155 | 1201 | 9 | 0 | 41.2013541 | -89.2869272 | 2022-06-26 04:21:02 | Putnam, Illinois, US | |
3349892 | 3349892 | 2022-06-24 | US | Texas | Wheeler | 48483 | 1201 | 22 | 0 | 35.40114335 | -100.2699514 | 2022-06-25 04:20:57 | Wheeler, Texas, US | |
3347678 | 3347678 | 2022-06-24 | US | Illinois | Putnam | 17155 | 1201 | 9 | 0 | 41.2013541 | -89.2869272 | 2022-06-25 04:20:57 | Putnam, Illinois, US | |
1651633 | 1651633 | 2022-06-23 | US | Texas | Wheeler | 48483 | 1201 | 22 | 0 | 35.40114335 | -100.2699514 | 2022-06-24 04:20:58 | Wheeler, Texas, US | |
2236882 | 2236882 | 2022-06-12 | US | Louisiana | Cameron | 22023 | 1201 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-06-13 04:21:14 | Cameron, Louisiana, US | |
3143080 | 3143080 | 2022-06-11 | US | Louisiana | Cameron | 22023 | 1201 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-06-12 04:20:53 | Cameron, Louisiana, US | |
1945996 | 1945996 | 2022-06-10 | US | Louisiana | Cameron | 22023 | 1201 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-06-11 04:21:01 | Cameron, Louisiana, US | |
3159135 | 3159135 | 2022-06-09 | US | Louisiana | Cameron | 22023 | 1201 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-06-10 04:20:55 | Cameron, Louisiana, US | |
3509477 | 3509477 | 2022-06-05 | US | Nebraska | Howard | 31093 | 1201 | 15 | 0 | 41.2200529 | -98.5166499 | 2022-06-06 04:20:57 | Howard, Nebraska, US | |
3508386 | 3508386 | 2022-06-05 | US | Illinois | Henderson | 17071 | 1201 | 19 | 0 | 40.81908672 | -90.92491462 | 2022-06-06 04:20:57 | Henderson, Illinois, US | |
3529554 | 3529554 | 2022-06-04 | US | Nebraska | Howard | 31093 | 1201 | 15 | 0 | 41.2200529 | -98.5166499 | 2022-06-05 04:20:55 | Howard, Nebraska, US | |
3528463 | 3528463 | 2022-06-04 | US | Illinois | Henderson | 17071 | 1201 | 19 | 0 | 40.81908672 | -90.92491462 | 2022-06-05 04:20:55 | Henderson, Illinois, US | |
3134549 | 3134549 | 2022-06-03 | US | Illinois | Henderson | 17071 | 1201 | 19 | 0 | 40.81908672 | -90.92491462 | 2022-06-04 04:20:58 | Henderson, Illinois, US | |
3188105 | 3188105 | 2022-05-30 | US | Nebraska | Polk | 31143 | 1201 | 12 | 0 | 41.18813488 | -97.56630712 | 2022-05-31 04:20:51 | Polk, Nebraska, US | |
3200254 | 3200254 | 2022-05-29 | US | Nebraska | Polk | 31143 | 1201 | 12 | 0 | 41.18813488 | -97.56630712 | 2022-05-30 04:20:50 | Polk, Nebraska, US | |
2727132 | 2727132 | 2022-05-28 | US | Nebraska | Polk | 31143 | 1201 | 12 | 0 | 41.18813488 | -97.56630712 | 2022-05-29 04:20:53 | Polk, Nebraska, US | |
3002638 | 3002638 | 2022-05-24 | US | Virginia | Emporia | 51595 | 1201 | 55 | 0 | 36.69455571 | -77.53406129 | 2022-05-25 04:20:56 | Emporia, Virginia, US | |
3725368 | 3725368 | 2022-04-25 | US | Texas | Martin | 48317 | 1201 | 26 | 0 | 32.30600051 | -101.9513518 | 2022-04-26 04:20:51 | Martin, Texas, US | |
2031936 | 2031936 | 2022-04-24 | US | Texas | Martin | 48317 | 1201 | 26 | 0 | 32.30600051 | -101.9513518 | 2022-04-25 04:20:56 | Martin, Texas, US | |
749511 | 749511 | 2022-04-23 | US | Texas | Martin | 48317 | 1201 | 26 | 0 | 32.30600051 | -101.9513518 | 2022-04-24 04:20:56 | Martin, Texas, US | |
3439996 | 3439996 | 2022-04-22 | US | Texas | Martin | 48317 | 1201 | 26 | 0 | 32.30600051 | -101.9513518 | 2022-04-23 04:20:50 | Martin, Texas, US | |
2895581 | 2895581 | 2022-04-21 | US | Texas | Martin | 48317 | 1201 | 26 | 0 | 32.30600051 | -101.9513518 | 2022-04-22 04:20:45 | Martin, Texas, US | |
2254524 | 2254524 | 2022-04-19 | US | Texas | Goliad | 48175 | 1201 | 32 | 0 | 28.65696592 | -97.42760647 | 2022-04-20 04:20:45 | Goliad, Texas, US | |
1849074 | 1849074 | 2022-04-18 | US | Texas | Goliad | 48175 | 1201 | 32 | 0 | 28.65696592 | -97.42760647 | 2022-04-19 04:21:00 | Goliad, Texas, US | |
3868200 | 3868200 | 2022-04-05 | US | Colorado | Saguache | 8109 | 1201 | 12 | 0 | 38.08054629 | -106.28246599999999 | 2022-04-06 04:20:49 | Saguache, Colorado, US | |
2749542 | 2749542 | 2022-04-04 | US | Colorado | Saguache | 8109 | 1201 | 12 | 0 | 38.08054629 | -106.28246599999999 | 2022-04-05 04:20:48 | Saguache, Colorado, US | |
3733691 | 3733691 | 2022-04-03 | US | Washington | San Juan | 53055 | 1201 | 2 | 0 | 48.60182783 | -122.96745 | 2022-04-04 04:20:51 | San Juan, Washington, US | |
3730888 | 3730888 | 2022-04-03 | US | Colorado | Saguache | 8109 | 1201 | 12 | 0 | 38.08054629 | -106.28246599999999 | 2022-04-04 04:20:51 | Saguache, Colorado, US | |
503126 | 503126 | 2022-04-02 | US | Washington | San Juan | 53055 | 1201 | 2 | 0 | 48.60182783 | -122.96745 | 2022-04-03 04:20:48 | San Juan, Washington, US | |
500323 | 500323 | 2022-04-02 | US | Colorado | Saguache | 8109 | 1201 | 12 | 0 | 38.08054629 | -106.28246599999999 | 2022-04-03 04:20:48 | Saguache, Colorado, US | |
3354111 | 3354111 | 2022-04-01 | US | Washington | San Juan | 53055 | 1201 | 2 | 0 | 48.60182783 | -122.96745 | 2022-04-02 04:20:47 | San Juan, Washington, US | |
3351308 | 3351308 | 2022-04-01 | US | Colorado | Saguache | 8109 | 1201 | 12 | 0 | 38.08054629 | -106.28246599999999 | 2022-04-02 04:20:47 | Saguache, Colorado, US | |
1540613 | 1540613 | 2022-03-31 | US | Colorado | Saguache | 8109 | 1201 | 12 | 0 | 38.08054629 | -106.28246599999999 | 2022-04-01 04:20:28 | Saguache, Colorado, US | |
2478626 | 2478626 | 2022-03-30 | US | Colorado | Saguache | 8109 | 1201 | 12 | 0 | 38.08054629 | -106.28246599999999 | 2022-03-31 04:20:56 | Saguache, Colorado, US | |
158667 | 158667 | 2022-03-29 | US | Colorado | Saguache | 8109 | 1201 | 12 | 0 | 38.08054629 | -106.28246599999999 | 2022-03-30 04:20:45 | Saguache, Colorado, US | |
1437238 | 1437238 | 2022-03-28 | US | Colorado | Saguache | 8109 | 1201 | 12 | 0 | 38.08054629 | -106.28246599999999 | 2022-03-29 04:20:46 | Saguache, Colorado, 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]);