⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

1,103,806 rows where country_or_region = "US" sorted by day descending

View and edit SQL

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
901021 2021-03-04 US Alabama Autauga 1001 6324 92 0 6232 32.53952745 -86.64408227 2021-03-05 05:26:29 Autauga, Alabama, US
901022 2021-03-04 US Alabama Baldwin 1003 19873 289 0 19584 30.72774991 -87.72207058 2021-03-05 05:26:29 Baldwin, Alabama, US
901023 2021-03-04 US Alabama Barbour 1005 2136 51 0 2085 31.868263 -85.3871286 2021-03-05 05:26:29 Barbour, Alabama, US
901024 2021-03-04 US Alabama Bibb 1007 2461 60 0 2401 32.99642064 -87.12511459999997 2021-03-05 05:26:29 Bibb, Alabama, US
901025 2021-03-04 US Alabama Blount 1009 6236 127 0 6109 33.98210918 -86.56790593 2021-03-05 05:26:29 Blount, Alabama, US
901026 2021-03-04 US Alabama Bullock 1011 1173 36 0 1137 32.10030533 -85.71265535 2021-03-05 05:26:29 Bullock, Alabama, US
901027 2021-03-04 US Alabama Butler 1013 2014 66 0 1948 31.75300095 -86.68057478 2021-03-05 05:26:29 Butler, Alabama, US
901028 2021-03-04 US Alabama Calhoun 1015 13832 293 0 13539 33.77483727 -85.82630386 2021-03-05 05:26:29 Calhoun, Alabama, US
901029 2021-03-04 US Alabama Chambers 1017 3431 111 0 3320 32.91360079 -85.39072749 2021-03-05 05:26:29 Chambers, Alabama, US
901030 2021-03-04 US Alabama Cherokee 1019 1780 39 0 1741 34.17805983 -85.60638968 2021-03-05 05:26:29 Cherokee, Alabama, US
901031 2021-03-04 US Alabama Chilton 1021 3898 103 0 3795 32.85044126 -86.7173256 2021-03-05 05:26:29 Chilton, Alabama, US
901032 2021-03-04 US Alabama Choctaw 1023 553 23 0 530 32.02227341 -88.26564429999998 2021-03-05 05:26:29 Choctaw, Alabama, US
901033 2021-03-04 US Alabama Clarke 1025 3440 53 0 3387 31.68099859 -87.83548597 2021-03-05 05:26:29 Clarke, Alabama, US
901034 2021-03-04 US Alabama Clay 1027 1459 54 0 1405 33.26984193 -85.85836077 2021-03-05 05:26:29 Clay, Alabama, US
901035 2021-03-04 US Alabama Cleburne 1029 1398 41 0 1357 33.67679204 -85.52005899 2021-03-05 05:26:29 Cleburne, Alabama, US
901036 2021-03-04 US Alabama Coffee 1031 5264 103 0 5161 31.39932826 -85.98901039 2021-03-05 05:26:29 Coffee, Alabama, US
901037 2021-03-04 US Alabama Colbert 1033 6001 121 0 5880 34.69847452 -87.80168544 2021-03-05 05:26:29 Colbert, Alabama, US
901038 2021-03-04 US Alabama Conecuh 1035 1070 24 0 1046 31.43401703 -86.99320044 2021-03-05 05:26:29 Conecuh, Alabama, US
901039 2021-03-04 US Alabama Coosa 1037 902 24 0 878 32.93690146 -86.24847739 2021-03-05 05:26:29 Coosa, Alabama, US
901040 2021-03-04 US Alabama Covington 1039 3993 106 0 3887 31.2477854 -86.45050893 2021-03-05 05:26:29 Covington, Alabama, US
901041 2021-03-04 US Alabama Crenshaw 1041 1462 55 0 1407 31.72941803 -86.31593104 2021-03-05 05:26:29 Crenshaw, Alabama, US
901042 2021-03-04 US Alabama Cullman 1043 8984 182 0 8802 34.13020303 -86.86888037 2021-03-05 05:26:29 Cullman, Alabama, US
901043 2021-03-04 US Alabama Dale 1045 4671 107 0 4564 31.43037123 -85.61095742 2021-03-05 05:26:29 Dale, Alabama, US
901044 2021-03-04 US Alabama Dallas 1047 3422 142 0 3280 32.32688101 -87.10866709999998 2021-03-05 05:26:29 Dallas, Alabama, US
901045 2021-03-04 US Alabama DeKalb 1049 8489 175 0 8314 34.45946862 -85.80782906 2021-03-05 05:26:29 DeKalb, Alabama, US
901046 2021-03-04 US Alabama Elmore 1051 9483 190 0 9293 32.59785413 -86.14415284 2021-03-05 05:26:29 Elmore, Alabama, US
901047 2021-03-04 US Alabama Escambia 1053 3791 73 0 3718 31.1256789 -87.15918694 2021-03-05 05:26:29 Escambia, Alabama, US
901048 2021-03-04 US Alabama Etowah 1055 13390 325 0 13065 34.04567266 -86.04051873 2021-03-05 05:26:29 Etowah, Alabama, US
901049 2021-03-04 US Alabama Fayette 1057 2020 57 0 1963 33.72076938 -87.73886638 2021-03-05 05:26:29 Fayette, Alabama, US
901050 2021-03-04 US Alabama Franklin 1059 3998 78 0 3920 34.44235334 -87.84289505 2021-03-05 05:26:29 Franklin, Alabama, US
901051 2021-03-04 US Alabama Geneva 1061 2403 70 0 2333 31.09389027 -85.83572839 2021-03-05 05:26:29 Geneva, Alabama, US
901052 2021-03-04 US Alabama Greene 1063 885 32 0 853 32.85504247 -87.95684022 2021-03-05 05:26:29 Greene, Alabama, US
901053 2021-03-04 US Alabama Hale 1065 2122 69 0 2053 32.76039258 -87.63284988 2021-03-05 05:26:29 Hale, Alabama, US
901054 2021-03-04 US Alabama Henry 1067 1835 41 0 1794 31.51148016 -85.24267944 2021-03-05 05:26:29 Henry, Alabama, US
901055 2021-03-04 US Alabama Houston 1069 10124 264 0 9860 31.15197924 -85.29939599 2021-03-05 05:26:29 Houston, Alabama, US
901056 2021-03-04 US Alabama Jackson 1071 6545 104 0 6441 34.78144169 -85.99750489 2021-03-05 05:26:29 Jackson, Alabama, US
901057 2021-03-04 US Alabama Jefferson 1073 71671 1387 0 70284 33.55554728 -86.89506300000002 2021-03-05 05:26:29 Jefferson, Alabama, US
901058 2021-03-04 US Alabama Lamar 1075 1337 33 0 1304 33.77995024 -88.09668032 2021-03-05 05:26:29 Lamar, Alabama, US
901059 2021-03-04 US Alabama Lauderdale 1077 8612 214 0 8398 34.90171875 -87.65624729 2021-03-05 05:26:29 Lauderdale, Alabama, US
901060 2021-03-04 US Alabama Lawrence 1079 2849 85 0 2764 34.52041498 -87.31069453 2021-03-05 05:26:29 Lawrence, Alabama, US
901061 2021-03-04 US Alabama Lee 1081 15039 157 0 14882 32.60154883 -85.35132246 2021-03-05 05:26:29 Lee, Alabama, US
901062 2021-03-04 US Alabama Limestone 1083 9420 138 0 9282 34.81185586 -86.98310072 2021-03-05 05:26:29 Limestone, Alabama, US
901063 2021-03-04 US Alabama Lowndes 1085 1327 51 0 1276 32.1597283 -86.65158371 2021-03-05 05:26:29 Lowndes, Alabama, US
901064 2021-03-04 US Alabama Macon 1087 1477 45 0 1432 32.38759944 -85.69267724 2021-03-05 05:26:29 Macon, Alabama, US
901065 2021-03-04 US Alabama Madison 1089 32616 468 0 32148 34.76327133 -86.55069633 2021-03-05 05:26:29 Madison, Alabama, US
901066 2021-03-04 US Alabama Marengo 1091 2388 57 0 2331 32.24767634 -87.78796182 2021-03-05 05:26:29 Marengo, Alabama, US
901067 2021-03-04 US Alabama Marion 1093 2886 95 0 2791 34.13697363 -87.88704173 2021-03-05 05:26:29 Marion, Alabama, US
901068 2021-03-04 US Alabama Marshall 1095 11448 211 0 11237 34.36975964 -86.30486727 2021-03-05 05:26:29 Marshall, Alabama, US
901069 2021-03-04 US Alabama Mobile 1097 36294 737 0 35557 30.78472347 -88.20842409 2021-03-05 05:26:29 Mobile, Alabama, US
901070 2021-03-04 US Alabama Monroe 1099 1667 39 0 1628 31.56729412 -87.36995001 2021-03-05 05:26:29 Monroe, Alabama, US
901071 2021-03-04 US Alabama Montgomery 1101 22739 519 0 22220 32.2206831 -86.20969272 2021-03-05 05:26:29 Montgomery, Alabama, US
901072 2021-03-04 US Alabama Morgan 1103 13753 254 0 13499 34.45500589 -86.85475946 2021-03-05 05:26:29 Morgan, Alabama, US
901073 2021-03-04 US Alabama Out of AL 80001 0 0 0 0 34.90171875 0.0 2020-12-21 13:27:30 Out of AL, Alabama, US
901074 2021-03-04 US Alabama Perry 1105 1061 27 0 1034 32.64048341 -87.29770589 2021-03-05 05:26:29 Perry, Alabama, US
901075 2021-03-04 US Alabama Pickens 1107 2254 57 0 2197 33.28094866 -88.08818103 2021-03-05 05:26:29 Pickens, Alabama, US
901076 2021-03-04 US Alabama Pike 1109 2933 73 0 2860 31.80396383 -85.9408295 2021-03-05 05:26:29 Pike, Alabama, US
901077 2021-03-04 US Alabama Randolph 1111 1648 40 0 1608 33.29526734 -85.45708831 2021-03-05 05:26:29 Randolph, Alabama, US
901078 2021-03-04 US Alabama Russell 1113 4069 33 0 4036 32.28725256 -85.18415324 2021-03-05 05:26:29 Russell, Alabama, US
901079 2021-03-04 US Alabama Shelby 1117 22174 218 0 21956 33.26879845 -86.66232561 2021-03-05 05:26:29 Shelby, Alabama, US
901080 2021-03-04 US Alabama St. Clair 1115 9022 227 0 8795 33.71902176 -86.31029372 2021-03-05 05:26:29 St. Clair, Alabama, US
901081 2021-03-04 US Alabama Sumter 1119 997 32 0 965 32.59117397 -88.19916205 2021-03-05 05:26:29 Sumter, Alabama, US
901082 2021-03-04 US Alabama Talladega 1121 7606 165 0 7441 33.37823223 -86.16886178 2021-03-05 05:26:29 Talladega, Alabama, US
901083 2021-03-04 US Alabama Tallapoosa 1123 3622 143 0 3479 32.86698258 -85.79833053 2021-03-05 05:26:29 Tallapoosa, Alabama, US
901084 2021-03-04 US Alabama Tuscaloosa 1125 24340 421 0 23919 33.28726072 -87.52556818 2021-03-05 05:26:29 Tuscaloosa, Alabama, US
901085 2021-03-04 US Alabama Unassigned 90001 0 0 0 0 34.90171875 0.0 2020-12-21 13:27:30 Unassigned, Alabama, US
901086 2021-03-04 US Alabama Walker 1127 6585 259 0 6326 33.80270512 -87.30027177 2021-03-05 05:26:29 Walker, Alabama, US
901087 2021-03-04 US Alabama Washington 1129 1568 36 0 1532 31.4092794 -88.20689944 2021-03-05 05:26:29 Washington, Alabama, US
901088 2021-03-04 US Alabama Wilcox 1131 1229 25 0 1204 31.98773215 -87.30891118 2021-03-05 05:26:29 Wilcox, Alabama, US
901089 2021-03-04 US Alabama Winston 1133 2583 68 0 2515 34.15030532 -87.37325922 2021-03-05 05:26:29 Winston, Alabama, US
901090 2021-03-04 US Alaska Aleutians East 2013 363 2 0 361 55.32222414 -161.9722021 2021-03-05 05:26:29 Aleutians East, Alaska, US
901091 2021-03-04 US Alaska Aleutians West 2016 626 0 0 626 52.3233 -174.1596 2021-03-05 05:26:29 Aleutians West, Alaska, US
901092 2021-03-04 US Alaska Anchorage 2020 26882 160 0 26722 61.14998174 -149.14269860000005 2021-03-05 05:26:29 Anchorage, Alaska, US
901093 2021-03-04 US Alaska Bethel 2050 3585 19 0 3566 60.90980451 -159.8561831 2021-03-05 05:26:29 Bethel, Alaska, US
901094 2021-03-04 US Alaska Bristol Bay 2060 0 0 0 0 58.74513976 -156.701064 2021-03-05 05:26:29 Bristol Bay, Alaska, US
901095 2021-03-04 US Alaska Bristol Bay plus Lake and Peninsula 2164 177 0 0 177 58.62403337 -156.21405890000003 2021-03-05 05:26:29 Bristol Bay plus Lake and Peninsula, Alaska, US
901096 2021-03-04 US Alaska Denali 2068 75 0 0 75 63.67264044 -150.0076108 2021-03-05 05:26:29 Denali, Alaska, US
901097 2021-03-04 US Alaska Dillingham 2070 208 1 0 207 59.79603738 -158.23819419999995 2021-03-05 05:26:29 Dillingham, Alaska, US
901098 2021-03-04 US Alaska Fairbanks North Star 2090 6307 29 0 6278 64.80726247 -146.5692662 2021-03-05 05:26:29 Fairbanks North Star, Alaska, US
901099 2021-03-04 US Alaska Haines 2100 28 0 0 28 59.09893571 -135.4679843 2021-03-05 05:26:29 Haines, Alaska, US
901100 2021-03-04 US Alaska Juneau 2110 1257 5 0 1252 58.45031811 -134.200436 2021-03-05 05:26:29 Juneau, Alaska, US
901101 2021-03-04 US Alaska Kenai Peninsula 2122 4035 22 0 4013 60.24429722 -151.53888840000005 2021-03-05 05:26:29 Kenai Peninsula, Alaska, US
901102 2021-03-04 US Alaska Ketchikan Gateway 2130 372 2 0 370 55.57445008 -130.975561 2021-03-05 05:26:29 Ketchikan Gateway, Alaska, US
901103 2021-03-04 US Alaska Kodiak Island 2150 1057 5 0 1052 57.65529415 -153.7493579 2021-03-05 05:26:29 Kodiak Island, Alaska, US
901104 2021-03-04 US Alaska Kusilvak 2158 1213 3 0 1210 62.15429159999999 -163.39678830000003 2021-03-05 05:26:29 Kusilvak, Alaska, US
901105 2021-03-04 US Alaska Matanuska-Susitna 2170 8829 36 0 8793 62.31305045 -149.5741743 2021-03-05 05:26:29 Matanuska-Susitna, Alaska, US
901106 2021-03-04 US Alaska Nome 2180 329 0 0 329 64.90320724 -164.0353804 2021-03-05 05:26:29 Nome, Alaska, US
901107 2021-03-04 US Alaska North Slope 2185 1014 4 0 1010 69.31479216 -153.4836093 2021-03-05 05:26:29 North Slope, Alaska, US
901108 2021-03-04 US Alaska Northwest Arctic 2188 588 2 0 586 67.04919196 -159.7503946 2021-03-05 05:26:29 Northwest Arctic, Alaska, US
901109 2021-03-04 US Alaska Petersburg 2195 134 1 0 133 57.13978948 -132.9540995 2021-03-05 05:26:29 Petersburg, Alaska, US
901110 2021-03-04 US Alaska Prince of Wales-Hyder 2198 80 1 0 79 55.76261984 -133.0511621 2021-03-05 05:26:29 Prince of Wales-Hyder, Alaska, US
901111 2021-03-04 US Alaska Sitka 2220 321 0 0 321 57.24124555 -135.3206587 2021-03-05 05:26:29 Sitka, Alaska, US
901112 2021-03-04 US Alaska Skagway 2230 20 0 0 20 59.56149996 -135.3337748 2021-03-05 05:26:29 Skagway, Alaska, US
901113 2021-03-04 US Alaska Southeast Fairbanks 2240 489 3 0 486 63.87692095 -143.2127643 2021-03-05 05:26:29 Southeast Fairbanks, Alaska, US
901114 2021-03-04 US Alaska Unassigned 90002 256 0 0 256 69.31479216 0.0 2021-03-05 05:26:29 Unassigned, Alaska, US
901115 2021-03-04 US Alaska Valdez-Cordova 2261 458 3 0 455 61.47502768 -144.7126799 2021-02-14 23:24:19 Valdez-Cordova, Alaska, US
901116 2021-03-04 US Alaska Wrangell 2275 31 0 0 31 56.3202004 -132.05837309999998 2021-03-05 05:26:29 Wrangell, Alaska, US
901117 2021-03-04 US Alaska Yakutat 2282 69 1 0 68 59.8909808 -140.36014509999998 2021-03-05 05:26:29 Yakutat, Alaska, US
901118 2021-03-04 US Alaska Yukon-Koyukuk 2290 335 4 0 331 65.50815459 -151.3907387 2021-03-05 05:26:29 Yukon-Koyukuk, Alaska, US
901119 2021-03-04 US Arizona Apache 4001 10511 392 0 10119 35.39465006 -109.4892383 2021-03-05 05:26:29 Apache, Arizona, US
901120 2021-03-04 US Arizona Cochise 4003 11273 266 0 11007 31.87934684 -109.7516088 2021-03-05 05:26:29 Cochise, Arizona, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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] INTEGER,
   [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]);