johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
332 rows where active = 679 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1378651 | 1378651 | 2021-07-25 | Pakistan | Gilgit-Baltistan | 7747 | 123 | 6945 | 679 | 35.792146 | 74.982138 | 2021-07-26 04:21:28 | Gilgit-Baltistan, Pakistan | ||
3331312 | 3331312 | 2021-07-21 | Chile | Araucania | 95929 | 1330 | 93920 | 679 | -38.9489 | -72.3311 | 2021-07-22 04:21:19 | Araucania, Chile | ||
578843 | 578843 | 2021-07-13 | Japan | Hokkaido | 41935 | 1413 | 39843 | 679 | 43.385711 | 142.552318 | 2021-07-14 04:21:35 | Hokkaido, Japan | ||
1712085 | 1712085 | 2021-06-25 | Cabo Verde | 32313 | 286 | 31348 | 679 | 16.5388 | -23.0418 | 2021-06-26 04:21:43 | Cabo Verde | |||
825774 | 825774 | 2021-06-06 | Russia | Buryatia Republic | 39046 | 912 | 37455 | 679 | 52.7182426 | 109.492143 | 2021-06-07 04:22:51 | Buryatia Republic, Russia | ||
1708349 | 1708349 | 2021-06-02 | Japan | Shizuoka | 8473 | 138 | 7656 | 679 | 34.916975 | 138.40778400000002 | 2021-06-03 04:23:32 | Shizuoka, Japan | ||
3089278 | 3089278 | 2021-05-30 | Colombia | Quindio | 43685 | 1310 | 41696 | 679 | 4.461 | -75.6674 | 2021-05-31 03:08:59 | Quindio, Colombia | ||
2390761 | 2390761 | 2021-05-18 | Italy | P.A. Trento | 44965 | 1353 | 42933 | 679 | 46.06893511 | 11.12123097 | 2021-05-19 04:20:42 | P.A. Trento, Italy | ||
1424945 | 1424945 | 2021-05-09 | Colombia | Cauca | 31388 | 839 | 29870 | 679 | 2.705 | -76.82600000000002 | 2021-05-10 04:20:38 | Cauca, Colombia | ||
954825 | 954825 | 2021-04-25 | India | Nagaland | 13183 | 98 | 12406 | 679 | 26.06702 | 94.470302 | 2021-04-26 04:21:04 | Nagaland, India | ||
3883449 | 3883449 | 2021-04-11 | Colombia | Sucre | 24127 | 887 | 22561 | 679 | 8.814 | -74.7233 | 2021-04-12 04:21:00 | Sucre, Colombia | ||
1980837 | 1980837 | 2021-03-25 | Russia | Mari El Republic | 12412 | 200 | 11533 | 679 | 56.5767504 | 47.8817512 | 2021-03-26 05:26:55 | Mari El Republic, Russia | ||
1732737 | 1732737 | 2021-03-14 | Russia | Sakhalin Oblast | 21817 | 35 | 21103 | 679 | 49.7219665 | 143.448533 | 2021-03-15 05:25:51 | Sakhalin Oblast, Russia | ||
3670664 | 3670664 | 2021-03-06 | US | Texas | Coleman | 48083 | 781 | 30 | 0 | 679 | 31.76736834 | -99.45240766 | 2021-03-07 05:21:54 | Coleman, Texas, US |
1619285 | 1619285 | 2021-03-05 | US | Texas | Coleman | 48083 | 781 | 30 | 0 | 679 | 31.76736834 | -99.45240766 | 2021-03-06 04:23:41 | Coleman, Texas, US |
2210696 | 2210696 | 2021-03-04 | US | Texas | Coleman | 48083 | 781 | 30 | 0 | 679 | 31.76736834 | -99.45240766 | 2021-03-05 05:26:29 | Coleman, Texas, US |
1093117 | 1093117 | 2021-03-03 | US | Texas | Coleman | 48083 | 781 | 30 | 0 | 679 | 31.76736834 | -99.45240766 | 2021-03-04 05:24:24 | Coleman, Texas, US |
1092939 | 1092939 | 2021-03-03 | US | South Dakota | Hamlin | 46057 | 717 | 38 | 0 | 679 | 44.67385954 | -97.18829593 | 2021-03-04 05:24:24 | Hamlin, South Dakota, US |
3257189 | 3257189 | 2021-03-02 | US | Texas | Coleman | 48083 | 781 | 30 | 0 | 679 | 31.76736834 | -99.45240766 | 2021-03-03 05:23:28 | Coleman, Texas, US |
3255930 | 3255930 | 2021-03-02 | US | Mississippi | Choctaw | 28019 | 696 | 17 | 0 | 679 | 33.34598242 | -89.24809382 | 2021-03-03 05:23:28 | Choctaw, Mississippi, US |
1001943 | 1001943 | 2021-03-01 | US | West Virginia | Summers | 54089 | 702 | 23 | 0 | 679 | 37.65390597 | -80.86009693 | 2021-03-02 05:23:30 | Summers, West Virginia, US |
1001481 | 1001481 | 2021-03-01 | US | Texas | Coleman | 48083 | 781 | 30 | 0 | 679 | 31.76736834 | -99.45240766 | 2021-03-02 05:23:30 | Coleman, Texas, US |
1000222 | 1000222 | 2021-03-01 | US | Mississippi | Choctaw | 28019 | 695 | 16 | 0 | 679 | 33.34598242 | -89.24809382 | 2021-03-02 05:23:30 | Choctaw, Mississippi, US |
998664 | 998664 | 2021-03-01 | Russia | Murmansk Oblast | 46846 | 946 | 45221 | 679 | 68.00004179999999 | 33.9999151 | 2021-03-02 05:23:30 | Murmansk Oblast, Russia | ||
2371001 | 2371001 | 2021-02-28 | US | West Virginia | Summers | 54089 | 702 | 23 | 0 | 679 | 37.65390597 | -80.86009693 | 2021-03-01 05:23:01 | Summers, West Virginia, US |
2370539 | 2370539 | 2021-02-28 | US | Texas | Coleman | 48083 | 781 | 30 | 0 | 679 | 31.76736834 | -99.45240766 | 2021-03-01 05:23:01 | Coleman, Texas, US |
2369280 | 2369280 | 2021-02-28 | US | Mississippi | Choctaw | 28019 | 695 | 16 | 0 | 679 | 33.34598242 | -89.24809382 | 2021-03-01 05:23:01 | Choctaw, Mississippi, US |
3067782 | 3067782 | 2021-02-27 | US | Mississippi | Choctaw | 28019 | 695 | 16 | 0 | 679 | 33.34598242 | -89.24809382 | 2021-02-28 05:22:20 | Choctaw, Mississippi, US |
2185366 | 2185366 | 2021-02-26 | US | Mississippi | Choctaw | 28019 | 695 | 16 | 0 | 679 | 33.34598242 | -89.24809382 | 2021-02-27 05:22:28 | Choctaw, Mississippi, US |
1861047 | 1861047 | 2021-02-25 | US | Texas | Coleman | 48083 | 779 | 28 | 0 | 679 | 31.76736834 | -99.45240766 | 2021-02-26 05:22:40 | Coleman, Texas, US |
1859788 | 1859788 | 2021-02-25 | US | Mississippi | Choctaw | 28019 | 695 | 16 | 0 | 679 | 33.34598242 | -89.24809382 | 2021-02-26 05:22:40 | Choctaw, Mississippi, US |
1859327 | 1859327 | 2021-02-25 | US | Kansas | Phillips | 20147 | 702 | 23 | 0 | 679 | 39.78465501 | -99.34668865 | 2021-02-26 05:22:40 | Phillips, Kansas, US |
1858115 | 1858115 | 2021-02-25 | Mongolia | 2801 | 2 | 2150 | 679 | 46.8625 | 103.8467 | 2021-02-26 05:22:40 | Mongolia | |||
281505 | 281505 | 2021-02-24 | US | Kansas | Phillips | 20147 | 702 | 23 | 0 | 679 | 39.78465501 | -99.34668865 | 2021-02-25 05:24:57 | Phillips, Kansas, US |
1937657 | 1937657 | 2021-02-23 | US | Iowa | Lucas | 19117 | 700 | 21 | 0 | 679 | 41.02958964 | -93.32780803 | 2021-02-24 05:29:16 | Lucas, Iowa, US |
533549 | 533549 | 2021-02-22 | US | South Dakota | Brule | 46015 | 688 | 9 | 0 | 679 | 43.71756379 | -99.08118954 | 2021-02-23 05:23:41 | Brule, South Dakota, US |
184883 | 184883 | 2021-02-21 | US | South Dakota | Brule | 46015 | 688 | 9 | 0 | 679 | 43.71756379 | -99.08118954 | 2021-02-22 05:24:21 | Brule, South Dakota, US |
474661 | 474661 | 2021-02-19 | US | Texas | Winkler | 48495 | 691 | 20 | 0 | 679 | 31.85008651 | -103.0485163 | 2021-02-20 05:22:51 | Winkler, Texas, US |
1156370 | 1156370 | 2021-02-18 | US | Texas | Winkler | 48495 | 691 | 20 | 0 | 679 | 31.85008651 | -103.0485163 | 2021-02-19 05:24:16 | Winkler, Texas, US |
2284984 | 2284984 | 2021-02-14 | US | Maine | Washington | 23029 | 692 | 13 | 0 | 679 | 45.01607142 | -67.62813524 | 2021-02-15 05:24:49 | Washington, Maine, US |
3543135 | 3543135 | 2021-02-12 | Malaysia | Kelantan | 3867 | 17 | 3171 | 679 | 6.1254 | 102.2381 | 2021-02-13 05:22:12 | Kelantan, Malaysia | ||
3540285 | 3540285 | 2021-02-12 | US | Georgia | Lincoln | 13181 | 698 | 19 | 0 | 679 | 33.79201475 | -82.45024131 | 2021-02-13 05:22:12 | Lincoln, Georgia, US |
1531341 | 1531341 | 2021-02-09 | US | Washington | Pacific | 53049 | 687 | 8 | 0 | 679 | 46.55418369 | -123.7285716 | 2021-02-10 05:22:41 | Pacific, Washington, US |
1675784 | 1675784 | 2021-02-07 | US | Virginia | Floyd | 51063 | 697 | 18 | 0 | 679 | 36.9302126 | -80.36738849 | 2021-02-08 05:22:39 | Floyd, Virginia, US |
1591253 | 1591253 | 2021-02-05 | US | Texas | Floyd | 48153 | 930 | 29 | 0 | 679 | 34.07227468 | -101.3031546 | 2021-02-06 05:23:55 | Floyd, Texas, US |
793572 | 793572 | 2021-02-04 | US | Texas | Presidio | 48377 | 636 | 22 | 0 | 679 | 29.99954402 | -104.2408079 | 2021-02-05 05:22:38 | Presidio, Texas, US |
792083 | 792083 | 2021-02-04 | US | Minnesota | Clearwater | 27029 | 693 | 14 | 0 | 679 | 47.57992111 | -95.37790562 | 2021-02-05 05:22:38 | Clearwater, Minnesota, US |
792040 | 792040 | 2021-02-04 | US | Michigan | Missaukee | 26113 | 696 | 17 | 0 | 679 | 44.33772443 | -85.09256478 | 2021-02-05 05:22:38 | Missaukee, Michigan, US |
1685323 | 1685323 | 2021-02-02 | US | Georgia | Lanier | 13173 | 689 | 10 | 0 | 679 | 31.038285700000007 | -83.06472457 | 2021-02-03 05:22:52 | Lanier, Georgia, US |
1899978 | 1899978 | 2021-01-29 | US | South Carolina | McCormick | 45065 | 692 | 13 | 0 | 679 | 33.90161443 | -82.30794338 | 2021-01-30 05:22:49 | McCormick, South Carolina, US |
1898302 | 1898302 | 2021-01-29 | US | Iowa | Adair | 19001 | 702 | 23 | 0 | 679 | 41.33075609 | -94.47105874 | 2021-01-30 05:22:49 | Adair, Iowa, US |
3154753 | 3154753 | 2021-01-27 | US | Iowa | Adair | 19001 | 699 | 20 | 0 | 679 | 41.33075609 | -94.47105874 | 2021-01-28 05:22:24 | Adair, Iowa, US |
2567425 | 2567425 | 2021-01-25 | Cabo Verde | 13557 | 127 | 12751 | 679 | 16.5388 | -23.0418 | 2021-01-26 05:22:02 | Cabo Verde | |||
2430552 | 2430552 | 2021-01-23 | United Kingdom | Gibraltar | 3935 | 62 | 3194 | 679 | 36.1408 | -5.3536 | 2021-01-24 05:22:35 | Gibraltar, United Kingdom | ||
2429804 | 2429804 | 2021-01-23 | US | South Dakota | Walworth | 46129 | 693 | 14 | 0 | 679 | 45.43019636 | -100.0307514 | 2021-01-24 05:22:35 | Walworth, South Dakota, US |
2428797 | 2428797 | 2021-01-23 | US | Missouri | Gentry | 29075 | 697 | 18 | 0 | 679 | 40.21097916 | -94.40944419 | 2021-01-24 05:22:35 | Gentry, Missouri, US |
2468706 | 2468706 | 2021-01-22 | US | Missouri | Howard | 29089 | 683 | 4 | 0 | 679 | 39.1435761 | -92.69756691 | 2021-01-23 05:22:03 | Howard, Missouri, US |
2468597 | 2468597 | 2021-01-22 | US | Mississippi | Franklin | 28037 | 696 | 17 | 0 | 679 | 31.47786634 | -90.89672989 | 2021-01-23 05:22:03 | Franklin, Mississippi, US |
2467978 | 2467978 | 2021-01-22 | US | Iowa | Davis | 19051 | 700 | 21 | 0 | 679 | 40.74773536 | -92.41005468 | 2021-01-23 05:22:03 | Davis, Iowa, US |
1094096 | 1094096 | 2021-01-20 | Japan | Gifu | 3673 | 60 | 2934 | 679 | 35.778671 | 137.055925 | 2021-01-21 05:22:01 | Gifu, Japan | ||
3103785 | 3103785 | 2021-01-16 | US | North Carolina | Perquimans | 37143 | 684 | 5 | 0 | 679 | 36.17847453 | -76.40603143 | 2021-01-17 05:22:17 | Perquimans, North Carolina, US |
3516586 | 3516586 | 2021-01-15 | US | Iowa | Greene | 19073 | 686 | 7 | 0 | 679 | 42.03614551 | -94.39658081 | 2021-01-16 05:22:40 | Greene, Iowa, US |
3881959 | 3881959 | 2021-01-14 | US | North Dakota | Dickey | 38021 | 709 | 32 | 0 | 679 | 46.11017712 | -98.5049008 | 2021-01-15 05:22:24 | Dickey, North Dakota, US |
777701 | 777701 | 2021-01-12 | US | Virginia | Lexington | 51678 | 686 | 7 | 0 | 679 | 37.78258621 | -79.44262866 | 2021-01-13 05:22:15 | Lexington, Virginia, US |
2627921 | 2627921 | 2021-01-10 | US | Nebraska | Custer | 31041 | 693 | 14 | 0 | 679 | 41.39374521 | -99.72805369 | 2021-01-11 05:21:50 | Custer, Nebraska, US |
3903454 | 3903454 | 2021-01-09 | US | West Virginia | Pleasants | 54073 | 685 | 6 | 0 | 679 | 39.37091679 | -81.16771771 | 2021-01-10 05:22:12 | Pleasants, West Virginia, US |
3902694 | 3902694 | 2021-01-09 | US | Puerto Rico | Hatillo | 72065 | 679 | 0 | 0 | 679 | 18.410928 | -66.79632600000001 | 2021-01-10 05:22:12 | Hatillo, Puerto Rico, US |
157311 | 157311 | 2021-01-08 | US | Virginia | Franklin City | 51620 | 697 | 18 | 0 | 679 | 36.6831435 | -76.93859681 | 2021-01-09 05:22:18 | Franklin City, Virginia, US |
2543892 | 2543892 | 2021-01-07 | US | Ohio | Morgan | 39115 | 693 | 14 | 0 | 679 | 39.62081738 | -81.85308173 | 2021-01-08 05:22:42 | Morgan, Ohio, US |
2542271 | 2542271 | 2021-01-07 | US | Georgia | Stewart | 13259 | 696 | 17 | 0 | 679 | 32.07996777 | -84.83208037 | 2021-01-08 05:22:42 | Stewart, Georgia, US |
2866607 | 2866607 | 2021-01-06 | US | Missouri | Gasconade | 29073 | 709 | 30 | 0 | 679 | 38.43947277 | -91.50847147 | 2021-01-07 05:22:03 | Gasconade, Missouri, US |
3036577 | 3036577 | 2021-01-05 | US | North Carolina | Alleghany | 37005 | 681 | 2 | 0 | 679 | 36.49360862 | -81.12857041 | 2021-01-06 05:22:16 | Alleghany, North Carolina, US |
1065338 | 1065338 | 2021-01-04 | US | West Virginia | Morgan | 54065 | 687 | 8 | 0 | 679 | 39.55439028 | -78.26311676 | 2021-01-05 05:21:49 | Morgan, West Virginia, US |
3232427 | 3232427 | 2021-01-03 | US | Montana | Carbon | 30009 | 687 | 8 | 0 | 679 | 45.22850116 | -109.0274047 | 2021-01-04 05:22:02 | Carbon, Montana, US |
3231665 | 3231665 | 2021-01-03 | US | Iowa | Monroe | 19135 | 696 | 17 | 0 | 679 | 41.02988815 | -92.8690667 | 2021-01-04 05:22:02 | Monroe, Iowa, US |
2229664 | 2229664 | 2021-01-02 | US | New Hampshire | Coos | 33007 | 694 | 15 | 0 | 679 | 44.69063265 | -71.30633239 | 2021-01-03 05:22:52 | Coos, New Hampshire, US |
2228381 | 2228381 | 2021-01-02 | US | Georgia | Seminole | 13253 | 691 | 12 | 0 | 679 | 30.93464824 | -84.86823924 | 2021-01-03 05:22:52 | Seminole, Georgia, US |
1139775 | 1139775 | 2021-01-01 | US | South Dakota | Spink | 46115 | 703 | 24 | 0 | 679 | 44.93837606 | -98.34626602 | 2021-01-02 05:22:33 | Spink, South Dakota, US |
3698381 | 3698381 | 2020-12-31 | US | South Dakota | Spink | 46115 | 703 | 24 | 0 | 679 | 44.93837606 | -98.34626602 | 2021-01-01 05:23:07 | Spink, South Dakota, US |
3697374 | 3697374 | 2020-12-31 | US | Missouri | Dallas | 29059 | 697 | 18 | 0 | 679 | 37.6811355 | -93.02127031 | 2021-01-01 05:23:07 | Dallas, Missouri, US |
3763930 | 3763930 | 2020-12-28 | US | North Carolina | Polk | 37149 | 692 | 13 | 0 | 679 | 35.27820615 | -82.16812354 | 2020-12-29 05:22:37 | Polk, North Carolina, US |
3779973 | 3779973 | 2020-12-27 | US | Nebraska | Hamilton | 31081 | 692 | 13 | 0 | 679 | 40.87349452 | -98.02099117 | 2020-12-28 05:22:06 | Hamilton, Nebraska, US |
2226223 | 2226223 | 2020-12-26 | US | Puerto Rico | Camuy | 72027 | 679 | 0 | 0 | 679 | 18.418578 | -66.860206 | 2020-12-27 05:22:55 | Camuy, Puerto Rico, US |
2225359 | 2225359 | 2020-12-26 | US | Mississippi | Webster | 28155 | 697 | 18 | 0 | 679 | 33.61300486 | -89.28392912 | 2020-12-27 05:22:55 | Webster, Mississippi, US |
205678 | 205678 | 2020-12-25 | US | Washington | Clallam | 53009 | 683 | 4 | 0 | 679 | 48.04754642 | -123.9226319 | 2020-12-26 05:22:28 | Clallam, Washington, US |
3694901 | 3694901 | 2020-12-24 | US | Washington | Clallam | 53009 | 683 | 4 | 0 | 679 | 48.04754642 | -123.9226319 | 2020-12-25 05:22:48 | Clallam, Washington, US |
931281 | 931281 | 2020-12-21 | US | Wyoming | Big Horn | 56003 | 694 | 15 | 0 | 679 | 44.52405055 | -107.9960365 | 2020-12-22 05:22:33 | Big Horn, Wyoming, US |
931246 | 931246 | 2020-12-21 | US | Wisconsin | Menominee | 55078 | 689 | 10 | 0 | 679 | 45.00422544 | -88.70950714 | 2020-12-22 05:22:33 | Menominee, Wisconsin, US |
2121044 | 2121044 | 2020-12-20 | US | Kansas | Russell | 20167 | 696 | 17 | 0 | 679 | 38.91462787 | -98.76254297 | 2020-12-21 05:27:58 | Russell, Kansas, US |
2932551 | 2932551 | 2020-12-19 | US | Kansas | Russell | 20167 | 696 | 17 | 0 | 679 | 38.91462787 | -98.76254297 | 2020-12-20 05:27:32 | Russell, Kansas, US |
1904776 | 1904776 | 2020-12-18 | US | Wyoming | Washakie | 56043 | 690 | 11 | 0 | 679 | 43.90451606 | -107.68018700000002 | 2020-12-19 05:27:52 | Washakie, Wyoming, US |
1904674 | 1904674 | 2020-12-18 | US | West Virginia | Upshur | 54097 | 683 | 4 | 0 | 679 | 38.89285061 | -80.23689136 | 2020-12-19 05:27:52 | Upshur, West Virginia, US |
1901981 | 1901981 | 2020-12-18 | US | Georgia | Jasper | 13159 | 686 | 7 | 0 | 679 | 33.31535543 | -83.68844964 | 2020-12-19 05:27:52 | Jasper, Georgia, US |
2128485 | 2128485 | 2020-12-17 | US | Arkansas | Little River | 5081 | 716 | 37 | 0 | 679 | 33.70375665 | -94.23468591 | 2020-12-18 05:28:18 | Little River, Arkansas, US |
1754275 | 1754275 | 2020-12-14 | US | Texas | Bailey | 48017 | 746 | 11 | 0 | 679 | 34.06854817 | -102.8299707 | 2020-12-15 05:26:38 | Bailey, Texas, US |
3850795 | 3850795 | 2020-12-13 | US | Texas | Bailey | 48017 | 746 | 11 | 0 | 679 | 34.06854817 | -102.8299707 | 2020-12-14 05:26:27 | Bailey, Texas, US |
3850528 | 3850528 | 2020-12-13 | US | Puerto Rico | Juncos | 72077 | 679 | 0 | 0 | 679 | 18.223793 | -65.909109 | 2020-12-14 05:26:27 | Juncos, Puerto Rico, US |
848577 | 848577 | 2020-12-12 | US | Texas | Bailey | 48017 | 746 | 11 | 0 | 679 | 34.06854817 | -102.8299707 | 2020-12-13 05:27:20 | Bailey, Texas, US |
1603593 | 1603593 | 2020-12-10 | US | Virginia | Orange | 51137 | 686 | 7 | 0 | 679 | 38.24530219 | -78.01560400000002 | 2020-12-11 05:26:59 | Orange, Virginia, US |
2978573 | 2978573 | 2020-12-09 | US | Virginia | Hopewell | 51670 | 688 | 9 | 0 | 679 | 37.29186313 | -77.29754684 | 2020-12-10 05:26:19 | Hopewell, Virginia, 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]);