ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,233 rows where date = "2020-08-31" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state >30
- Texas 251
- Georgia 160
- Virginia 133
- Kentucky 120
- Missouri 117
- Kansas 105
- Illinois 103
- Iowa 100
- North Carolina 100
- Tennessee 96
- Indiana 92
- Nebraska 91
- Minnesota 88
- Ohio 88
- Michigan 84
- Mississippi 82
- Puerto Rico 79
- Oklahoma 78
- Arkansas 76
- Wisconsin 73
- Florida 68
- Alabama 67
- Pennsylvania 67
- South Dakota 66
- Louisiana 65
- Colorado 63
- California 58
- New York 58
- West Virginia 55
- Montana 54
- …
fips >30
county >30
- Washington 31
- Unknown 27
- Jefferson 26
- Franklin 25
- Jackson 24
- Lincoln 24
- Madison 20
- Clay 18
- Montgomery 18
- Union 18
- Marion 17
- Monroe 17
- Wayne 16
- Grant 14
- Greene 14
- Warren 14
- Carroll 13
- Adams 12
- Clark 12
- Douglas 12
- Johnson 12
- Lake 12
- Lee 12
- Marshall 12
- Polk 12
- Calhoun 11
- Crawford 11
- Fayette 11
- Lawrence 11
- Morgan 11
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
485909 | 485909 | 2020-08-31 | Autauga | Alabama | 1001 | 1442 | 23 |
485910 | 485910 | 2020-08-31 | Baldwin | Alabama | 1003 | 4545 | 42 |
485911 | 485911 | 2020-08-31 | Barbour | Alabama | 1005 | 757 | 7 |
485912 | 485912 | 2020-08-31 | Bibb | Alabama | 1007 | 554 | 8 |
485913 | 485913 | 2020-08-31 | Blount | Alabama | 1009 | 1287 | 11 |
485914 | 485914 | 2020-08-31 | Bullock | Alabama | 1011 | 551 | 14 |
485915 | 485915 | 2020-08-31 | Butler | Alabama | 1013 | 866 | 37 |
485916 | 485916 | 2020-08-31 | Calhoun | Alabama | 1015 | 2567 | 36 |
485917 | 485917 | 2020-08-31 | Chambers | Alabama | 1017 | 1033 | 40 |
485918 | 485918 | 2020-08-31 | Cherokee | Alabama | 1019 | 405 | 12 |
485919 | 485919 | 2020-08-31 | Chilton | Alabama | 1021 | 1194 | 13 |
485920 | 485920 | 2020-08-31 | Choctaw | Alabama | 1023 | 326 | 12 |
485921 | 485921 | 2020-08-31 | Clarke | Alabama | 1025 | 992 | 14 |
485922 | 485922 | 2020-08-31 | Clay | Alabama | 1027 | 373 | 6 |
485923 | 485923 | 2020-08-31 | Cleburne | Alabama | 1029 | 206 | 5 |
485924 | 485924 | 2020-08-31 | Coffee | Alabama | 1031 | 1087 | 7 |
485925 | 485925 | 2020-08-31 | Colbert | Alabama | 1033 | 1466 | 22 |
485926 | 485926 | 2020-08-31 | Conecuh | Alabama | 1035 | 485 | 11 |
485927 | 485927 | 2020-08-31 | Coosa | Alabama | 1037 | 135 | 3 |
485928 | 485928 | 2020-08-31 | Covington | Alabama | 1039 | 1096 | 26 |
485929 | 485929 | 2020-08-31 | Crenshaw | Alabama | 1041 | 472 | 27 |
485930 | 485930 | 2020-08-31 | Cullman | Alabama | 1043 | 1644 | 14 |
485931 | 485931 | 2020-08-31 | Dale | Alabama | 1045 | 1103 | 38 |
485932 | 485932 | 2020-08-31 | Dallas | Alabama | 1047 | 1615 | 25 |
485933 | 485933 | 2020-08-31 | DeKalb | Alabama | 1049 | 2152 | 16 |
485934 | 485934 | 2020-08-31 | Elmore | Alabama | 1051 | 2195 | 44 |
485935 | 485935 | 2020-08-31 | Escambia | Alabama | 1053 | 1404 | 22 |
485936 | 485936 | 2020-08-31 | Etowah | Alabama | 1055 | 2806 | 40 |
485937 | 485937 | 2020-08-31 | Fayette | Alabama | 1057 | 315 | 6 |
485938 | 485938 | 2020-08-31 | Franklin | Alabama | 1059 | 1565 | 27 |
485939 | 485939 | 2020-08-31 | Geneva | Alabama | 1061 | 438 | 4 |
485940 | 485940 | 2020-08-31 | Greene | Alabama | 1063 | 285 | 15 |
485941 | 485941 | 2020-08-31 | Hale | Alabama | 1065 | 559 | 28 |
485942 | 485942 | 2020-08-31 | Henry | Alabama | 1067 | 376 | 4 |
485943 | 485943 | 2020-08-31 | Houston | Alabama | 1069 | 2061 | 19 |
485944 | 485944 | 2020-08-31 | Jackson | Alabama | 1071 | 1318 | 9 |
485945 | 485945 | 2020-08-31 | Jefferson | Alabama | 1073 | 16426 | 303 |
485946 | 485946 | 2020-08-31 | Lamar | Alabama | 1075 | 291 | 2 |
485947 | 485947 | 2020-08-31 | Lauderdale | Alabama | 1077 | 1437 | 24 |
485948 | 485948 | 2020-08-31 | Lawrence | Alabama | 1079 | 476 | 5 |
485949 | 485949 | 2020-08-31 | Lee | Alabama | 1081 | 4564 | 54 |
485950 | 485950 | 2020-08-31 | Limestone | Alabama | 1083 | 1687 | 16 |
485951 | 485951 | 2020-08-31 | Lowndes | Alabama | 1085 | 619 | 26 |
485952 | 485952 | 2020-08-31 | Macon | Alabama | 1087 | 435 | 19 |
485953 | 485953 | 2020-08-31 | Madison | Alabama | 1089 | 6473 | 57 |
485954 | 485954 | 2020-08-31 | Marengo | Alabama | 1091 | 639 | 18 |
485955 | 485955 | 2020-08-31 | Marion | Alabama | 1093 | 791 | 28 |
485956 | 485956 | 2020-08-31 | Marshall | Alabama | 1095 | 3622 | 42 |
485957 | 485957 | 2020-08-31 | Mobile | Alabama | 1097 | 12259 | 261 |
485958 | 485958 | 2020-08-31 | Monroe | Alabama | 1099 | 545 | 7 |
485959 | 485959 | 2020-08-31 | Montgomery | Alabama | 1101 | 7992 | 163 |
485960 | 485960 | 2020-08-31 | Morgan | Alabama | 1103 | 2910 | 24 |
485961 | 485961 | 2020-08-31 | Perry | Alabama | 1105 | 517 | 5 |
485962 | 485962 | 2020-08-31 | Pickens | Alabama | 1107 | 563 | 11 |
485963 | 485963 | 2020-08-31 | Pike | Alabama | 1109 | 963 | 8 |
485964 | 485964 | 2020-08-31 | Randolph | Alabama | 1111 | 519 | 12 |
485965 | 485965 | 2020-08-31 | Russell | Alabama | 1113 | 1627 | 2 |
485966 | 485966 | 2020-08-31 | Shelby | Alabama | 1117 | 4561 | 47 |
485967 | 485967 | 2020-08-31 | St. Clair | Alabama | 1115 | 1844 | 29 |
485968 | 485968 | 2020-08-31 | Sumter | Alabama | 1119 | 403 | 19 |
485969 | 485969 | 2020-08-31 | Talladega | Alabama | 1121 | 1764 | 20 |
485970 | 485970 | 2020-08-31 | Tallapoosa | Alabama | 1123 | 1053 | 82 |
485971 | 485971 | 2020-08-31 | Tuscaloosa | Alabama | 1125 | 5877 | 100 |
485972 | 485972 | 2020-08-31 | Walker | Alabama | 1127 | 1914 | 76 |
485973 | 485973 | 2020-08-31 | Washington | Alabama | 1129 | 522 | 13 |
485974 | 485974 | 2020-08-31 | Wilcox | Alabama | 1131 | 514 | 11 |
485975 | 485975 | 2020-08-31 | Winston | Alabama | 1133 | 576 | 11 |
485976 | 485976 | 2020-08-31 | Aleutians East Borough | Alaska | 2013 | 4 | 0 |
485977 | 485977 | 2020-08-31 | Aleutians West Census Area | Alaska | 2016 | 92 | 0 |
485978 | 485978 | 2020-08-31 | Anchorage | Alaska | 2020 | 3139 | 21 |
485979 | 485979 | 2020-08-31 | Bethel Census Area | Alaska | 2050 | 65 | 1 |
485980 | 485980 | 2020-08-31 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 75 | 0 |
485981 | 485981 | 2020-08-31 | Denali Borough | Alaska | 2068 | 4 | 0 |
485982 | 485982 | 2020-08-31 | Dillingham Census Area | Alaska | 2070 | 26 | 0 |
485983 | 485983 | 2020-08-31 | Fairbanks North Star Borough | Alaska | 2090 | 685 | 8 |
485984 | 485984 | 2020-08-31 | Haines Borough | Alaska | 2100 | 10 | 0 |
485985 | 485985 | 2020-08-31 | Juneau City and Borough | Alaska | 2110 | 257 | 0 |
485986 | 485986 | 2020-08-31 | Kenai Peninsula Borough | Alaska | 2122 | 568 | 1 |
485987 | 485987 | 2020-08-31 | Ketchikan Gateway Borough | Alaska | 2130 | 62 | 0 |
485988 | 485988 | 2020-08-31 | Kodiak Island Borough | Alaska | 2150 | 57 | 0 |
485989 | 485989 | 2020-08-31 | Kusilvak Census Area | Alaska | 2158 | 8 | 0 |
485990 | 485990 | 2020-08-31 | Matanuska-Susitna Borough | Alaska | 2170 | 482 | 2 |
485991 | 485991 | 2020-08-31 | Nome Census Area | Alaska | 2180 | 45 | 0 |
485992 | 485992 | 2020-08-31 | North Slope Borough | Alaska | 2185 | 43 | 0 |
485993 | 485993 | 2020-08-31 | Northwest Arctic Borough | Alaska | 2188 | 66 | 0 |
485994 | 485994 | 2020-08-31 | Petersburg Borough | Alaska | 2195 | 11 | 0 |
485995 | 485995 | 2020-08-31 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 25 | 0 |
485996 | 485996 | 2020-08-31 | Sitka City and Borough | Alaska | 2220 | 51 | 0 |
485997 | 485997 | 2020-08-31 | Southeast Fairbanks Census Area | Alaska | 2240 | 32 | 0 |
485998 | 485998 | 2020-08-31 | Unknown | Alaska | 36 | 0 | |
485999 | 485999 | 2020-08-31 | Valdez-Cordova Census Area | Alaska | 2261 | 121 | 0 |
486000 | 486000 | 2020-08-31 | Wrangell City and Borough | Alaska | 2275 | 17 | 0 |
486001 | 486001 | 2020-08-31 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 21 | 0 |
486002 | 486002 | 2020-08-31 | Yukon-Koyukuk Census Area | Alaska | 2290 | 73 | 1 |
486003 | 486003 | 2020-08-31 | Apache | Arizona | 4001 | 3338 | 154 |
486004 | 486004 | 2020-08-31 | Cochise | Arizona | 4003 | 1819 | 62 |
486005 | 486005 | 2020-08-31 | Coconino | Arizona | 4005 | 3324 | 125 |
486006 | 486006 | 2020-08-31 | Gila | Arizona | 4007 | 1106 | 47 |
486007 | 486007 | 2020-08-31 | Graham | Arizona | 4009 | 714 | 22 |
486008 | 486008 | 2020-08-31 | Greenlee | Arizona | 4011 | 58 | 2 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);