johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
265 rows where confirmed = 2912 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3175451 | 3175451 | 2022-12-19 | US | Michigan | Mackinac | 26097 | 2912 | 38 | 0 | 46.07028979 | -85.04980537 | 2022-12-20 04:21:04 | Mackinac, Michigan, US | |
1629968 | 1629968 | 2022-12-18 | US | Michigan | Mackinac | 26097 | 2912 | 38 | 0 | 46.07028979 | -85.04980537 | 2022-12-19 04:21:03 | Mackinac, Michigan, US | |
505347 | 505347 | 2022-12-17 | US | Michigan | Mackinac | 26097 | 2912 | 38 | 0 | 46.07028979 | -85.04980537 | 2022-12-18 04:21:03 | Mackinac, Michigan, US | |
3325919 | 3325919 | 2022-12-16 | US | Michigan | Mackinac | 26097 | 2912 | 38 | 0 | 46.07028979 | -85.04980537 | 2022-12-17 04:21:04 | Mackinac, Michigan, US | |
544431 | 544431 | 2022-12-15 | US | Michigan | Mackinac | 26097 | 2912 | 38 | 0 | 46.07028979 | -85.04980537 | 2022-12-16 04:21:01 | Mackinac, Michigan, US | |
349959 | 349959 | 2022-12-14 | US | Michigan | Mackinac | 26097 | 2912 | 38 | 0 | 46.07028979 | -85.04980537 | 2022-12-15 04:20:58 | Mackinac, Michigan, US | |
309547 | 309547 | 2022-12-13 | US | Michigan | Mackinac | 26097 | 2912 | 38 | 0 | 46.07028979 | -85.04980537 | 2022-12-14 04:21:04 | Mackinac, Michigan, US | |
2415393 | 2415393 | 2022-12-05 | US | Arkansas | Perry | 5105 | 2912 | 42 | 0 | 34.9459153 | -92.94372564 | 2022-12-06 04:21:03 | Perry, Arkansas, US | |
719001 | 719001 | 2022-12-04 | US | Arkansas | Perry | 5105 | 2912 | 42 | 0 | 34.9459153 | -92.94372564 | 2022-12-05 04:20:58 | Perry, Arkansas, US | |
1242079 | 1242079 | 2022-11-28 | US | North Dakota | Mercer | 38057 | 2912 | 24 | 0 | 47.31213126 | -101.8318399 | 2022-11-29 04:21:05 | Mercer, North Dakota, US | |
3041707 | 3041707 | 2022-10-27 | US | Virginia | Madison | 51113 | 2912 | 44 | 0 | 38.41531222 | -78.28220331 | 2022-10-28 04:22:31 | Madison, Virginia, US | |
420750 | 420750 | 2022-09-18 | US | Kentucky | Hancock | 21091 | 2912 | 27 | 0 | 37.83766422 | -86.78280584 | 2022-09-19 04:21:49 | Hancock, Kentucky, US | |
3374774 | 3374774 | 2022-09-17 | US | Kentucky | Hancock | 21091 | 2912 | 27 | 0 | 37.83766422 | -86.78280584 | 2022-09-18 04:22:50 | Hancock, Kentucky, US | |
2356882 | 2356882 | 2022-09-16 | US | Kentucky | Hancock | 21091 | 2912 | 27 | 0 | 37.83766422 | -86.78280584 | 2022-09-17 04:20:19 | Hancock, Kentucky, US | |
3988039 | 3988039 | 2022-09-15 | US | Kentucky | Hancock | 21091 | 2912 | 27 | 0 | 37.83766422 | -86.78280584 | 2022-09-16 04:21:19 | Hancock, Kentucky, US | |
1890556 | 1890556 | 2022-09-14 | US | Kentucky | Hancock | 21091 | 2912 | 27 | 0 | 37.83766422 | -86.78280584 | 2022-09-15 04:21:02 | Hancock, Kentucky, US | |
373611 | 373611 | 2022-09-13 | US | Kentucky | Hancock | 21091 | 2912 | 27 | 0 | 37.83766422 | -86.78280584 | 2022-09-14 04:20:44 | Hancock, Kentucky, US | |
2396213 | 2396213 | 2022-09-12 | US | Kentucky | Hancock | 21091 | 2912 | 27 | 0 | 37.83766422 | -86.78280584 | 2022-09-13 04:20:57 | Hancock, Kentucky, US | |
2856231 | 2856231 | 2022-08-22 | US | Virginia | Lunenburg | 51111 | 2912 | 40 | 0 | 36.94618528 | -78.24133319 | 2022-08-23 04:20:56 | Lunenburg, Virginia, US | |
3910417 | 3910417 | 2022-08-11 | US | North Dakota | McLean | 38055 | 2912 | 49 | 0 | 47.60766714 | -101.3182418 | 2022-08-12 04:20:54 | McLean, North Dakota, US | |
1346708 | 1346708 | 2022-08-10 | US | Alabama | Lowndes | 1085 | 2912 | 79 | 0 | 32.1597283 | -86.65158371 | 2022-08-11 04:20:49 | Lowndes, Alabama, US | |
1086463 | 1086463 | 2022-08-09 | US | Alabama | Lowndes | 1085 | 2912 | 79 | 0 | 32.1597283 | -86.65158371 | 2022-08-10 04:20:57 | Lowndes, Alabama, US | |
3543878 | 3543878 | 2022-08-08 | US | Alabama | Lowndes | 1085 | 2912 | 79 | 0 | 32.1597283 | -86.65158371 | 2022-08-09 04:20:34 | Lowndes, Alabama, US | |
1070281 | 1070281 | 2022-08-07 | US | Alabama | Lowndes | 1085 | 2912 | 79 | 0 | 32.1597283 | -86.65158371 | 2022-08-08 04:21:08 | Lowndes, Alabama, US | |
1940869 | 1940869 | 2022-08-06 | US | Alabama | Lowndes | 1085 | 2912 | 79 | 0 | 32.1597283 | -86.65158371 | 2022-08-07 04:20:54 | Lowndes, Alabama, US | |
880668 | 880668 | 2022-08-05 | US | Alabama | Lowndes | 1085 | 2912 | 79 | 0 | 32.1597283 | -86.65158371 | 2022-08-06 04:20:56 | Lowndes, Alabama, US | |
2012028 | 2012028 | 2022-08-04 | US | Virginia | Falls Church | 51610 | 2912 | 17 | 0 | 38.88485255 | -77.17560759 | 2022-08-05 04:20:52 | Falls Church, Virginia, US | |
2009079 | 2009079 | 2022-08-04 | US | Alabama | Lowndes | 1085 | 2912 | 79 | 0 | 32.1597283 | -86.65158371 | 2022-08-05 04:20:52 | Lowndes, Alabama, US | |
671256 | 671256 | 2022-07-21 | US | Idaho | Shoshone | 16079 | 2912 | 77 | 0 | 47.35364087 | -115.8916749 | 2022-07-22 04:21:15 | Shoshone, Idaho, US | |
1609219 | 1609219 | 2022-07-20 | US | Idaho | Shoshone | 16079 | 2912 | 77 | 0 | 47.35364087 | -115.8916749 | 2022-07-21 04:21:10 | Shoshone, Idaho, US | |
3112736 | 3112736 | 2022-07-13 | US | Texas | Ward | 48475 | 2912 | 44 | 0 | 31.50999644 | -103.0927909 | 2022-07-14 04:20:57 | Ward, Texas, US | |
478486 | 478486 | 2022-06-26 | US | Texas | Camp | 48063 | 2912 | 75 | 0 | 32.97195142 | -94.97790104 | 2022-06-27 04:21:00 | Camp, Texas, US | |
167244 | 167244 | 2022-06-21 | US | Iowa | Hancock | 19081 | 2912 | 48 | 0 | 43.08178477 | -93.73454884 | 2022-06-22 04:20:54 | Hancock, Iowa, US | |
1765145 | 1765145 | 2022-06-20 | US | Mississippi | Jefferson Davis | 28065 | 2912 | 54 | 0 | 31.56884708 | -89.8267099 | 2022-06-21 04:20:56 | Jefferson Davis, Mississippi, US | |
1764527 | 1764527 | 2022-06-20 | US | Iowa | Hancock | 19081 | 2912 | 48 | 0 | 43.08178477 | -93.73454884 | 2022-06-21 04:20:56 | Hancock, Iowa, US | |
3271331 | 3271331 | 2022-06-19 | US | Mississippi | Jefferson Davis | 28065 | 2912 | 54 | 0 | 31.56884708 | -89.8267099 | 2022-06-20 04:21:01 | Jefferson Davis, Mississippi, US | |
3270713 | 3270713 | 2022-06-19 | US | Iowa | Hancock | 19081 | 2912 | 48 | 0 | 43.08178477 | -93.73454884 | 2022-06-20 04:21:01 | Hancock, Iowa, US | |
3399243 | 3399243 | 2022-06-18 | US | Mississippi | Jefferson Davis | 28065 | 2912 | 54 | 0 | 31.56884708 | -89.8267099 | 2022-06-19 04:20:51 | Jefferson Davis, Mississippi, US | |
3398625 | 3398625 | 2022-06-18 | US | Iowa | Hancock | 19081 | 2912 | 48 | 0 | 43.08178477 | -93.73454884 | 2022-06-19 04:20:51 | Hancock, Iowa, US | |
2313120 | 2313120 | 2022-06-17 | US | Mississippi | Jefferson Davis | 28065 | 2912 | 54 | 0 | 31.56884708 | -89.8267099 | 2022-06-18 04:21:10 | Jefferson Davis, Mississippi, US | |
2312502 | 2312502 | 2022-06-17 | US | Iowa | Hancock | 19081 | 2912 | 48 | 0 | 43.08178477 | -93.73454884 | 2022-06-18 04:21:10 | Hancock, Iowa, US | |
560624 | 560624 | 2022-06-16 | US | Mississippi | Jefferson Davis | 28065 | 2912 | 54 | 0 | 31.56884708 | -89.8267099 | 2022-06-17 04:20:56 | Jefferson Davis, Mississippi, US | |
560006 | 560006 | 2022-06-16 | US | Iowa | Hancock | 19081 | 2912 | 48 | 0 | 43.08178477 | -93.73454884 | 2022-06-17 04:20:56 | Hancock, Iowa, US | |
3984426 | 3984426 | 2022-06-15 | US | Mississippi | Jefferson Davis | 28065 | 2912 | 54 | 0 | 31.56884708 | -89.8267099 | 2022-06-16 04:20:55 | Jefferson Davis, Mississippi, US | |
3983808 | 3983808 | 2022-06-15 | US | Iowa | Hancock | 19081 | 2912 | 48 | 0 | 43.08178477 | -93.73454884 | 2022-06-16 04:20:55 | Hancock, Iowa, US | |
948667 | 948667 | 2022-06-14 | US | Mississippi | Jefferson Davis | 28065 | 2912 | 54 | 0 | 31.56884708 | -89.8267099 | 2022-06-15 04:20:54 | Jefferson Davis, Mississippi, US | |
2982773 | 2982773 | 2022-06-13 | US | West Virginia | Summers | 54089 | 2912 | 55 | 0 | 37.65390597 | -80.86009693 | 2022-06-14 04:20:52 | Summers, West Virginia, US | |
2981075 | 2981075 | 2022-06-13 | US | Mississippi | Jefferson Davis | 28065 | 2912 | 54 | 0 | 31.56884708 | -89.8267099 | 2022-06-14 04:20:52 | Jefferson Davis, Mississippi, US | |
3159188 | 3159188 | 2022-06-09 | US | Louisiana | West Feliciana | 22125 | 2912 | 46 | 0 | 30.87882871 | -91.4148538 | 2022-06-10 04:20:55 | West Feliciana, Louisiana, US | |
3158049 | 3158049 | 2022-06-09 | US | Alabama | Wilcox | 1131 | 2912 | 46 | 0 | 31.98773215 | -87.30891118 | 2022-06-10 04:20:55 | Wilcox, Alabama, US | |
1504253 | 1504253 | 2022-05-16 | US | Colorado | Rio Grande | 8105 | 2912 | 46 | 0 | 37.5836865 | -106.3847838 | 2022-05-17 04:20:59 | Rio Grande, Colorado, US | |
1504101 | 1504101 | 2022-05-16 | US | Arkansas | Lee | 5077 | 2912 | 59 | 0 | 34.78498904 | -90.78383866 | 2022-05-17 04:20:59 | Lee, Arkansas, US | |
2084460 | 2084460 | 2022-05-15 | US | Arkansas | Lee | 5077 | 2912 | 59 | 0 | 34.78498904 | -90.78383866 | 2022-05-16 04:20:47 | Lee, Arkansas, US | |
3355170 | 3355170 | 2022-05-14 | US | Arkansas | Lee | 5077 | 2912 | 59 | 0 | 34.78498904 | -90.78383866 | 2022-05-15 04:20:53 | Lee, Arkansas, US | |
658815 | 658815 | 2022-05-13 | US | Arkansas | Lee | 5077 | 2912 | 59 | 0 | 34.78498904 | -90.78383866 | 2022-05-14 04:20:48 | Lee, Arkansas, US | |
2533898 | 2533898 | 2022-05-12 | US | Arkansas | Lee | 5077 | 2912 | 59 | 0 | 34.78498904 | -90.78383866 | 2022-05-13 04:20:51 | Lee, Arkansas, US | |
3445344 | 3445344 | 2022-05-11 | US | Arkansas | Lee | 5077 | 2912 | 59 | 0 | 34.78498904 | -90.78383866 | 2022-05-12 04:20:54 | Lee, Arkansas, US | |
3535961 | 3535961 | 2022-05-10 | US | Arkansas | Lee | 5077 | 2912 | 59 | 0 | 34.78498904 | -90.78383866 | 2022-05-11 04:20:48 | Lee, Arkansas, US | |
222496 | 222496 | 2022-05-09 | US | Arkansas | Lee | 5077 | 2912 | 59 | 0 | 34.78498904 | -90.78383866 | 2022-05-10 04:20:50 | Lee, Arkansas, US | |
2331881 | 2331881 | 2022-05-08 | US | Arkansas | Lee | 5077 | 2912 | 59 | 0 | 34.78498904 | -90.78383866 | 2022-05-09 04:20:54 | Lee, Arkansas, US | |
360843 | 360843 | 2022-05-07 | US | Arkansas | Lee | 5077 | 2912 | 59 | 0 | 34.78498904 | -90.78383866 | 2022-05-08 04:20:49 | Lee, Arkansas, US | |
1398194 | 1398194 | 2022-05-06 | US | Arkansas | Lee | 5077 | 2912 | 59 | 0 | 34.78498904 | -90.78383866 | 2022-05-07 04:21:09 | Lee, Arkansas, US | |
2598549 | 2598549 | 2022-05-05 | US | Arkansas | Lee | 5077 | 2912 | 59 | 0 | 34.78498904 | -90.78383866 | 2022-05-06 04:21:00 | Lee, Arkansas, US | |
2670344 | 2670344 | 2022-04-15 | US | Arkansas | Stone | 5137 | 2912 | 67 | 0 | 35.86251946 | -92.15684085 | 2022-04-16 04:20:48 | Stone, Arkansas, US | |
1224129 | 1224129 | 2022-04-14 | US | Arkansas | Stone | 5137 | 2912 | 67 | 0 | 35.86251946 | -92.15684085 | 2022-04-15 04:20:57 | Stone, Arkansas, US | |
3240214 | 3240214 | 2022-03-21 | US | Missouri | Cedar | 29039 | 2912 | 52 | 0 | 37.72391475 | -93.85445441 | 2022-03-22 04:20:54 | Cedar, Missouri, US | |
25047 | 25047 | 2022-03-20 | US | Colorado | Park | 8093 | 2912 | 20 | 0 | 39.120926000000004 | -105.7182065 | 2022-03-21 04:20:50 | Park, Colorado, US | |
1657057 | 1657057 | 2022-03-19 | US | Colorado | Park | 8093 | 2912 | 20 | 0 | 39.120926000000004 | -105.7182065 | 2022-03-20 04:20:45 | Park, Colorado, US | |
336583 | 336583 | 2022-03-18 | US | Colorado | Park | 8093 | 2912 | 20 | 0 | 39.120926000000004 | -105.7182065 | 2022-03-19 04:20:47 | Park, Colorado, US | |
2322778 | 2322778 | 2022-03-16 | US | Washington | Jefferson | 53031 | 2912 | 28 | 0 | 47.75003077 | -123.56097040000002 | 2022-03-17 04:20:56 | Jefferson, Washington, US | |
264978 | 264978 | 2022-03-15 | US | Washington | Jefferson | 53031 | 2912 | 28 | 0 | 47.75003077 | -123.56097040000002 | 2022-03-16 04:20:50 | Jefferson, Washington, US | |
2267337 | 2267337 | 2022-03-14 | US | Washington | Jefferson | 53031 | 2912 | 28 | 0 | 47.75003077 | -123.56097040000002 | 2022-03-15 04:20:47 | Jefferson, Washington, US | |
953642 | 953642 | 2022-03-12 | US | Puerto Rico | Salinas | 72123 | 2912 | 0 | 0 | 18.010386999999994 | -66.256592 | 2022-03-13 04:20:49 | Salinas, Puerto Rico, US | |
2140775 | 2140775 | 2022-03-09 | US | Colorado | Archuleta | 8007 | 2912 | 16 | 0 | 37.19474156 | -107.04768670000001 | 2022-03-10 04:20:48 | Archuleta, Colorado, US | |
921248 | 921248 | 2022-03-08 | US | Maine | Piscataquis | 23021 | 2912 | 30 | 0 | 45.83839062 | -69.2860223 | 2022-03-09 04:20:59 | Piscataquis, Maine, US | |
920286 | 920286 | 2022-03-08 | US | Colorado | Archuleta | 8007 | 2912 | 16 | 0 | 37.19474156 | -107.04768670000001 | 2022-03-09 04:20:59 | Archuleta, Colorado, US | |
945691 | 945691 | 2022-02-28 | US | South Dakota | Charles Mix | 46023 | 2912 | 33 | 0 | 43.20660134 | -98.58856175 | 2022-03-01 04:21:09 | Charles Mix, South Dakota, US | |
2734804 | 2734804 | 2022-02-27 | US | Minnesota | Watonwan | 27165 | 2912 | 22 | 0 | 43.97823903 | -94.61413846 | 2022-02-28 04:21:05 | Watonwan, Minnesota, US | |
3047957 | 3047957 | 2022-02-26 | US | Minnesota | Watonwan | 27165 | 2912 | 22 | 0 | 43.97823903 | -94.61413846 | 2022-02-27 04:21:04 | Watonwan, Minnesota, US | |
576612 | 576612 | 2022-02-25 | US | Minnesota | Watonwan | 27165 | 2912 | 22 | 0 | 43.97823903 | -94.61413846 | 2022-02-26 04:21:12 | Watonwan, Minnesota, US | |
575195 | 575195 | 2022-02-25 | US | Alabama | Coosa | 1037 | 2912 | 54 | 0 | 32.93690146 | -86.24847739 | 2022-02-26 04:21:12 | Coosa, Alabama, US | |
1059606 | 1059606 | 2022-02-23 | US | Minnesota | Pope | 27121 | 2912 | 17 | 0 | 45.58606667 | -95.44451209 | 2022-02-24 04:21:14 | Pope, Minnesota, US | |
2447945 | 2447945 | 2022-02-22 | US | Iowa | Cass | 19029 | 2912 | 75 | 0 | 41.33149454 | -94.92792482 | 2022-02-23 04:21:09 | Cass, Iowa, US | |
3719358 | 3719358 | 2022-02-21 | US | Iowa | Cass | 19029 | 2912 | 75 | 0 | 41.33149454 | -94.92792482 | 2022-02-22 04:21:01 | Cass, Iowa, US | |
3913192 | 3913192 | 2022-02-20 | US | Iowa | Cass | 19029 | 2912 | 75 | 0 | 41.33149454 | -94.92792482 | 2022-02-21 04:21:05 | Cass, Iowa, US | |
3876750 | 3876750 | 2022-02-19 | US | Iowa | Cass | 19029 | 2912 | 75 | 0 | 41.33149454 | -94.92792482 | 2022-02-20 04:21:00 | Cass, Iowa, US | |
3857006 | 3857006 | 2022-02-18 | US | Iowa | Cass | 19029 | 2912 | 75 | 0 | 41.33149454 | -94.92792482 | 2022-02-19 04:21:11 | Cass, Iowa, US | |
1299225 | 1299225 | 2022-02-17 | US | Iowa | Cass | 19029 | 2912 | 75 | 0 | 41.33149454 | -94.92792482 | 2022-02-18 04:21:04 | Cass, Iowa, US | |
3822384 | 3822384 | 2022-02-16 | US | Missouri | Pemiscot | 29155 | 2912 | 68 | 0 | 36.2130572 | -89.78742322 | 2022-02-17 04:20:56 | Pemiscot, Missouri, US | |
3821611 | 3821611 | 2022-02-16 | US | Iowa | Cass | 19029 | 2912 | 75 | 0 | 41.33149454 | -94.92792482 | 2022-02-17 04:20:56 | Cass, Iowa, US | |
3672828 | 3672828 | 2022-02-15 | US | Iowa | Cherokee | 19035 | 2912 | 55 | 0 | 42.73538914 | -95.62389402 | 2022-02-16 04:21:10 | Cherokee, Iowa, US | |
2642929 | 2642929 | 2022-02-14 | US | Iowa | Cherokee | 19035 | 2912 | 55 | 0 | 42.73538914 | -95.62389402 | 2022-02-15 04:21:09 | Cherokee, Iowa, US | |
187246 | 187246 | 2022-02-13 | US | Iowa | Cherokee | 19035 | 2912 | 55 | 0 | 42.73538914 | -95.62389402 | 2022-02-14 04:20:51 | Cherokee, Iowa, US | |
317092 | 317092 | 2022-02-12 | US | Iowa | Cherokee | 19035 | 2912 | 55 | 0 | 42.73538914 | -95.62389402 | 2022-02-13 04:21:00 | Cherokee, Iowa, US | |
234418 | 234418 | 2022-02-11 | US | Iowa | Cherokee | 19035 | 2912 | 55 | 0 | 42.73538914 | -95.62389402 | 2022-02-12 04:21:06 | Cherokee, Iowa, US | |
1465260 | 1465260 | 2022-02-10 | US | Iowa | Cherokee | 19035 | 2912 | 55 | 0 | 42.73538914 | -95.62389402 | 2022-02-11 04:21:09 | Cherokee, Iowa, US | |
3075221 | 3075221 | 2022-02-09 | US | Iowa | Cherokee | 19035 | 2912 | 55 | 0 | 42.73538914 | -95.62389402 | 2022-02-10 04:21:14 | Cherokee, Iowa, US | |
1364060 | 1364060 | 2022-02-08 | US | Minnesota | Chippewa | 27023 | 2912 | 46 | 0 | 45.02343421 | -95.56403693 | 2022-02-09 04:21:04 | Chippewa, Minnesota, US | |
1229734 | 1229734 | 2022-01-24 | US | Nebraska | Seward | 31159 | 2912 | 32 | 0 | 40.87241834 | -97.139673 | 2022-01-25 04:21:05 | Seward, Nebraska, US | |
3614961 | 3614961 | 2022-01-12 | US | Missouri | Dallas | 29059 | 2912 | 62 | 0 | 37.681135499999996 | -93.02127031 | 2022-01-13 08:00:09 | Dallas, 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]);