⚠️ 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

969,531 rows where country_or_region = "US" sorted by day descending

View and edit SQL

These facets timed out: province_or_state

country_or_region

  • US · 969,531
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
90019 2021-01-22 US Alabama Autauga 1001 5327 61 0 5266 32.53952745 -86.64408227 2021-01-23 05:22:03 Autauga, Alabama, US
90020 2021-01-22 US Alabama Baldwin 1003 16981 188 0 16793 30.72774991 -87.72207058 2021-01-23 05:22:03 Baldwin, Alabama, US
90021 2021-01-22 US Alabama Barbour 1005 1793 37 0 1756 31.868263 -85.3871286 2021-01-23 05:22:03 Barbour, Alabama, US
90022 2021-01-22 US Alabama Bibb 1007 2212 48 0 2164 32.99642064 -87.12511459999997 2021-01-23 05:22:03 Bibb, Alabama, US
90023 2021-01-22 US Alabama Blount 1009 5439 86 0 5353 33.98210918 -86.56790593 2021-01-23 05:22:03 Blount, Alabama, US
90024 2021-01-22 US Alabama Bullock 1011 1022 28 0 994 32.10030533 -85.71265535 2021-01-23 05:22:03 Bullock, Alabama, US
90025 2021-01-22 US Alabama Butler 1013 1724 59 0 1665 31.75300095 -86.68057478 2021-01-23 05:22:03 Butler, Alabama, US
90026 2021-01-22 US Alabama Calhoun 1015 11441 206 0 11235 33.77483727 -85.82630386 2021-01-23 05:22:03 Calhoun, Alabama, US
90027 2021-01-22 US Alabama Chambers 1017 3011 70 0 2941 32.91360079 -85.39072749 2021-01-23 05:22:03 Chambers, Alabama, US
90028 2021-01-22 US Alabama Cherokee 1019 1643 30 0 1613 34.17805983 -85.60638968 2021-01-23 05:22:03 Cherokee, Alabama, US
90029 2021-01-22 US Alabama Chilton 1021 3428 73 0 3355 32.85044126 -86.7173256 2021-01-23 05:22:03 Chilton, Alabama, US
90030 2021-01-22 US Alabama Choctaw 1023 517 24 0 493 32.02227341 -88.26564429999998 2021-01-23 05:22:03 Choctaw, Alabama, US
90031 2021-01-22 US Alabama Clarke 1025 2933 36 0 2897 31.68099859 -87.83548597 2021-01-23 05:22:03 Clarke, Alabama, US
90032 2021-01-22 US Alabama Clay 1027 1291 46 0 1245 33.26984193 -85.85836077 2021-01-23 05:22:03 Clay, Alabama, US
90033 2021-01-22 US Alabama Cleburne 1029 1207 24 0 1183 33.67679204 -85.52005899 2021-01-23 05:22:03 Cleburne, Alabama, US
90034 2021-01-22 US Alabama Coffee 1031 4567 62 0 4505 31.39932826 -85.98901039 2021-01-23 05:22:03 Coffee, Alabama, US
90035 2021-01-22 US Alabama Colbert 1033 5452 76 0 5376 34.69847452 -87.80168544 2021-01-23 05:22:03 Colbert, Alabama, US
90036 2021-01-22 US Alabama Conecuh 1035 968 21 0 947 31.43401703 -86.99320044 2021-01-23 05:22:03 Conecuh, Alabama, US
90037 2021-01-22 US Alabama Coosa 1037 632 15 0 617 32.93690146 -86.24847739 2021-01-23 05:22:03 Coosa, Alabama, US
90038 2021-01-22 US Alabama Covington 1039 3360 68 0 3292 31.2477854 -86.45050893 2021-01-23 05:22:03 Covington, Alabama, US
90039 2021-01-22 US Alabama Crenshaw 1041 1229 44 0 1185 31.72941803 -86.31593104 2021-01-23 05:22:03 Crenshaw, Alabama, US
90040 2021-01-22 US Alabama Cullman 1043 8203 108 0 8095 34.13020303 -86.86888037 2021-01-23 05:22:03 Cullman, Alabama, US
90041 2021-01-22 US Alabama Dale 1045 4068 83 0 3985 31.43037123 -85.61095742 2021-01-23 05:22:03 Dale, Alabama, US
90042 2021-01-22 US Alabama Dallas 1047 3120 96 0 3024 32.32688101 -87.10866709999998 2021-01-23 05:22:03 Dallas, Alabama, US
90043 2021-01-22 US Alabama DeKalb 1049 7828 103 0 7725 34.45946862 -85.80782906 2021-01-23 05:22:03 DeKalb, Alabama, US
90044 2021-01-22 US Alabama Elmore 1051 8120 104 0 8016 32.59785413 -86.14415284 2021-01-23 05:22:03 Elmore, Alabama, US
90045 2021-01-22 US Alabama Escambia 1053 3301 44 0 3257 31.1256789 -87.15918694 2021-01-23 05:22:03 Escambia, Alabama, US
90046 2021-01-22 US Alabama Etowah 1055 11987 179 0 11808 34.04567266 -86.04051873 2021-01-23 05:22:03 Etowah, Alabama, US
90047 2021-01-22 US Alabama Fayette 1057 1770 29 0 1741 33.72076938 -87.73886638 2021-01-23 05:22:03 Fayette, Alabama, US
90048 2021-01-22 US Alabama Franklin 1059 3724 48 0 3676 34.44235334 -87.84289505 2021-01-23 05:22:03 Franklin, Alabama, US
90049 2021-01-22 US Alabama Geneva 1061 2087 46 0 2041 31.09389027 -85.83572839 2021-01-23 05:22:03 Geneva, Alabama, US
90050 2021-01-22 US Alabama Greene 1063 768 23 0 745 32.85504247 -87.95684022 2021-01-23 05:22:03 Greene, Alabama, US
90051 2021-01-22 US Alabama Hale 1065 1827 42 0 1785 32.76039258 -87.63284988 2021-01-23 05:22:03 Hale, Alabama, US
90052 2021-01-22 US Alabama Henry 1067 1582 24 0 1558 31.51148016 -85.24267944 2021-01-23 05:22:03 Henry, Alabama, US
90053 2021-01-22 US Alabama Houston 1069 8886 158 0 8728 31.15197924 -85.29939599 2021-01-23 05:22:03 Houston, Alabama, US
90054 2021-01-22 US Alabama Jackson 1071 5946 44 0 5902 34.78144169 -85.99750489 2021-01-23 05:22:03 Jackson, Alabama, US
90055 2021-01-22 US Alabama Jefferson 1073 63969 994 0 62975 33.55554728 -86.89506300000002 2021-01-23 05:22:03 Jefferson, Alabama, US
90056 2021-01-22 US Alabama Lamar 1075 1197 21 0 1176 33.77995024 -88.09668032 2021-01-23 05:22:03 Lamar, Alabama, US
90057 2021-01-22 US Alabama Lauderdale 1077 7798 103 0 7695 34.90171875 -87.65624729 2021-01-23 05:22:03 Lauderdale, Alabama, US
90058 2021-01-22 US Alabama Lawrence 1079 2507 52 0 2455 34.52041498 -87.31069453 2021-01-23 05:22:03 Lawrence, Alabama, US
90059 2021-01-22 US Alabama Lee 1081 13036 105 0 12931 32.60154883 -85.35132246 2021-01-23 05:22:03 Lee, Alabama, US
90060 2021-01-22 US Alabama Limestone 1083 8278 76 0 8202 34.81185586 -86.98310072 2021-01-23 05:22:03 Limestone, Alabama, US
90061 2021-01-22 US Alabama Lowndes 1085 1137 36 0 1101 32.1597283 -86.65158371 2021-01-23 05:22:03 Lowndes, Alabama, US
90062 2021-01-22 US Alabama Macon 1087 1209 37 0 1172 32.38759944 -85.69267724 2021-01-23 05:22:03 Macon, Alabama, US
90063 2021-01-22 US Alabama Madison 1089 27851 208 0 27643 34.76327133 -86.55069633 2021-01-23 05:22:03 Madison, Alabama, US
90064 2021-01-22 US Alabama Marengo 1091 2065 29 0 2036 32.24767634 -87.78796182 2021-01-23 05:22:03 Marengo, Alabama, US
90065 2021-01-22 US Alabama Marion 1093 2515 58 0 2457 34.13697363 -87.88704173 2021-01-23 05:22:03 Marion, Alabama, US
90066 2021-01-22 US Alabama Marshall 1095 10357 123 0 10234 34.36975964 -86.30486727 2021-01-23 05:22:03 Marshall, Alabama, US
90067 2021-01-22 US Alabama Mobile 1097 31211 565 0 30646 30.78472347 -88.20842409 2021-01-23 05:22:03 Mobile, Alabama, US
90068 2021-01-22 US Alabama Monroe 1099 1513 20 0 1493 31.56729412 -87.36995001 2021-01-23 05:22:03 Monroe, Alabama, US
90069 2021-01-22 US Alabama Montgomery 1101 19698 326 0 19372 32.2206831 -86.20969272 2021-01-23 05:22:03 Montgomery, Alabama, US
90070 2021-01-22 US Alabama Morgan 1103 12526 134 0 12392 34.45500589 -86.85475946 2021-01-23 05:22:03 Morgan, Alabama, US
90071 2021-01-22 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
90072 2021-01-22 US Alabama Perry 1105 991 18 0 973 32.64048341 -87.29770589 2021-01-23 05:22:03 Perry, Alabama, US
90073 2021-01-22 US Alabama Pickens 1107 1990 31 0 1959 33.28094866 -88.08818103 2021-01-23 05:22:03 Pickens, Alabama, US
90074 2021-01-22 US Alabama Pike 1109 2611 31 0 2580 31.80396383 -85.9408295 2021-01-23 05:22:03 Pike, Alabama, US
90075 2021-01-22 US Alabama Randolph 1111 1443 36 0 1407 33.29526734 -85.45708831 2021-01-23 05:22:03 Randolph, Alabama, US
90076 2021-01-22 US Alabama Russell 1113 3492 12 0 3480 32.28725256 -85.18415324 2021-01-23 05:22:03 Russell, Alabama, US
90077 2021-01-22 US Alabama Shelby 1117 19093 130 0 18963 33.26879845 -86.66232561 2021-01-23 05:22:03 Shelby, Alabama, US
90078 2021-01-22 US Alabama St. Clair 1115 7763 125 0 7638 33.71902176 -86.31029372 2021-01-23 05:22:03 St. Clair, Alabama, US
90079 2021-01-22 US Alabama Sumter 1119 900 26 0 874 32.59117397 -88.19916205 2021-01-23 05:22:03 Sumter, Alabama, US
90080 2021-01-22 US Alabama Talladega 1121 6394 111 0 6283 33.37823223 -86.16886178 2021-01-23 05:22:03 Talladega, Alabama, US
90081 2021-01-22 US Alabama Tallapoosa 1123 3120 107 0 3013 32.86698258 -85.79833053 2021-01-23 05:22:03 Tallapoosa, Alabama, US
90082 2021-01-22 US Alabama Tuscaloosa 1125 21233 271 0 20962 33.28726072 -87.52556818 2021-01-23 05:22:03 Tuscaloosa, Alabama, US
90083 2021-01-22 US Alabama Unassigned 90001 0 0 0 0 34.90171875 0.0 2020-12-21 13:27:30 Unassigned, Alabama, US
90084 2021-01-22 US Alabama Walker 1127 6002 177 0 5825 33.80270512 -87.30027177 2021-01-23 05:22:03 Walker, Alabama, US
90085 2021-01-22 US Alabama Washington 1129 1401 27 0 1374 31.4092794 -88.20689944 2021-01-23 05:22:03 Washington, Alabama, US
90086 2021-01-22 US Alabama Wilcox 1131 1066 22 0 1044 31.98773215 -87.30891118 2021-01-23 05:22:03 Wilcox, Alabama, US
90087 2021-01-22 US Alabama Winston 1133 2327 42 0 2285 34.15030532 -87.37325922 2021-01-23 05:22:03 Winston, Alabama, US
90088 2021-01-22 US Alaska Aleutians East 2013 64 0 0 64 55.32222414 -161.9722021 2021-01-23 05:22:03 Aleutians East, Alaska, US
90089 2021-01-22 US Alaska Aleutians West 2016 291 0 0 291 52.3233 -174.1596 2021-01-23 05:22:03 Aleutians West, Alaska, US
90090 2021-01-22 US Alaska Anchorage 2020 24967 140 0 24827 61.14998174 -149.14269860000005 2021-01-23 05:22:03 Anchorage, Alaska, US
90091 2021-01-22 US Alaska Bethel 2050 3059 14 0 3045 60.90980451 -159.8561831 2021-01-23 05:22:03 Bethel, Alaska, US
90092 2021-01-22 US Alaska Bristol Bay 2060 0 0 0 0 58.74513976 -156.701064 2021-01-23 05:22:03 Bristol Bay, Alaska, US
90093 2021-01-22 US Alaska Bristol Bay plus Lake and Peninsula 2164 169 0 0 169 58.62403337 -156.21405890000003 2021-01-23 05:22:03 Bristol Bay plus Lake and Peninsula, Alaska, US
90094 2021-01-22 US Alaska Denali 2068 64 0 0 64 63.67264044 -150.0076108 2021-01-23 05:22:03 Denali, Alaska, US
90095 2021-01-22 US Alaska Dillingham 2070 161 1 0 160 59.79603738 -158.23819419999995 2021-01-23 05:22:03 Dillingham, Alaska, US
90096 2021-01-22 US Alaska Fairbanks North Star 2090 5746 25 0 5721 64.80726247 -146.5692662 2021-01-23 05:22:03 Fairbanks North Star, Alaska, US
90097 2021-01-22 US Alaska Haines 2100 24 0 0 24 59.09893571 -135.4679843 2021-01-23 05:22:03 Haines, Alaska, US
90098 2021-01-22 US Alaska Juneau 2110 1126 5 0 1121 58.45031811 -134.200436 2021-01-23 05:22:03 Juneau, Alaska, US
90099 2021-01-22 US Alaska Kenai Peninsula 2122 3884 21 0 3863 60.24429722 -151.53888840000005 2021-01-23 05:22:03 Kenai Peninsula, Alaska, US
90100 2021-01-22 US Alaska Ketchikan Gateway 2130 274 1 0 273 55.57445008 -130.975561 2021-01-23 05:22:03 Ketchikan Gateway, Alaska, US
90101 2021-01-22 US Alaska Kodiak Island 2150 1023 5 0 1018 57.65529415 -153.7493579 2021-01-23 05:22:03 Kodiak Island, Alaska, US
90102 2021-01-22 US Alaska Kusilvak 2158 1062 3 0 1059 62.15429159999999 -163.39678830000003 2021-01-23 05:22:03 Kusilvak, Alaska, US
90103 2021-01-22 US Alaska Matanuska-Susitna 2170 7312 23 0 7289 62.31305045 -149.5741743 2021-01-23 05:22:03 Matanuska-Susitna, Alaska, US
90104 2021-01-22 US Alaska Nome 2180 304 0 0 304 64.90320724 -164.0353804 2021-01-23 05:22:03 Nome, Alaska, US
90105 2021-01-22 US Alaska North Slope 2185 974 3 0 971 69.31479216 -153.4836093 2021-01-23 05:22:03 North Slope, Alaska, US
90106 2021-01-22 US Alaska Northwest Arctic 2188 557 0 0 557 67.04919196 -159.7503946 2021-01-23 05:22:03 Northwest Arctic, Alaska, US
90107 2021-01-22 US Alaska Petersburg 2195 47 1 0 46 57.13978948 -132.9540995 2021-01-23 05:22:03 Petersburg, Alaska, US
90108 2021-01-22 US Alaska Prince of Wales-Hyder 2198 74 1 0 73 55.76261984 -133.0511621 2021-01-23 05:22:03 Prince of Wales-Hyder, Alaska, US
90109 2021-01-22 US Alaska Sitka 2220 297 0 0 297 57.24124555 -135.3206587 2021-01-23 05:22:03 Sitka, Alaska, US
90110 2021-01-22 US Alaska Skagway 2230 16 0 0 16 59.56149996 -135.3337748 2021-01-23 05:22:03 Skagway, Alaska, US
90111 2021-01-22 US Alaska Southeast Fairbanks 2240 421 3 0 418 63.87692095 -143.2127643 2021-01-23 05:22:03 Southeast Fairbanks, Alaska, US
90112 2021-01-22 US Alaska Unassigned 90002 232 0 0 232 69.31479216 0.0 2021-01-23 05:22:03 Unassigned, Alaska, US
90113 2021-01-22 US Alaska Valdez-Cordova 2261 404 3 0 401 61.47502768 -144.7126799 2021-01-23 05:22:03 Valdez-Cordova, Alaska, US
90114 2021-01-22 US Alaska Wrangell 2275 26 0 0 26 56.3202004 -132.05837309999998 2021-01-23 05:22:03 Wrangell, Alaska, US
90115 2021-01-22 US Alaska Yakutat 2282 64 1 0 63 59.8909808 -140.36014509999998 2021-01-23 05:22:03 Yakutat, Alaska, US
90116 2021-01-22 US Alaska Yukon-Koyukuk 2290 259 4 0 255 65.50815459 -151.3907387 2021-01-23 05:22:03 Yukon-Koyukuk, Alaska, US
90117 2021-01-22 US Arizona Apache 4001 8837 288 0 8549 35.39465006 -109.4892383 2021-01-23 05:22:03 Apache, Arizona, US
90118 2021-01-22 US Arizona Cochise 4003 10014 203 0 9811 31.87934684 -109.7516088 2021-01-23 05:22:03 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]);