ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,246 rows where date = "2021-05-28" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state >30
- Texas 254
- Georgia 160
- Virginia 133
- Kentucky 120
- Missouri 117
- Kansas 105
- Illinois 103
- Iowa 100
- North Carolina 100
- Tennessee 96
- Nebraska 93
- Indiana 92
- Ohio 89
- Minnesota 88
- Michigan 84
- Mississippi 82
- Puerto Rico 79
- Oklahoma 78
- Arkansas 76
- Wisconsin 72
- Florida 68
- Alabama 67
- Pennsylvania 67
- South Dakota 66
- Louisiana 65
- Colorado 64
- California 58
- New York 58
- Montana 56
- West Virginia 55
- …
fips >30
county >30
- Washington 31
- Jefferson 26
- Franklin 25
- Unknown 25
- Jackson 24
- Lincoln 24
- Madison 20
- Clay 18
- Montgomery 18
- Union 18
- Marion 17
- Monroe 17
- Wayne 16
- Grant 15
- 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 |
---|---|---|---|---|---|---|---|
1361956 | 1361956 | 2021-05-28 | Autauga | Alabama | 1001 | 7142 | 110 |
1361957 | 1361957 | 2021-05-28 | Baldwin | Alabama | 1003 | 21620 | 311 |
1361958 | 1361958 | 2021-05-28 | Barbour | Alabama | 1005 | 2334 | 59 |
1361959 | 1361959 | 2021-05-28 | Bibb | Alabama | 1007 | 2664 | 64 |
1361960 | 1361960 | 2021-05-28 | Blount | Alabama | 1009 | 6864 | 139 |
1361961 | 1361961 | 2021-05-28 | Bullock | Alabama | 1011 | 1233 | 42 |
1361962 | 1361962 | 2021-05-28 | Butler | Alabama | 1013 | 2219 | 71 |
1361963 | 1361963 | 2021-05-28 | Calhoun | Alabama | 1015 | 14622 | 324 |
1361964 | 1361964 | 2021-05-28 | Chambers | Alabama | 1017 | 3665 | 123 |
1361965 | 1361965 | 2021-05-28 | Cherokee | Alabama | 1019 | 1862 | 45 |
1361966 | 1361966 | 2021-05-28 | Chilton | Alabama | 1021 | 4430 | 115 |
1361967 | 1361967 | 2021-05-28 | Choctaw | Alabama | 1023 | 613 | 25 |
1361968 | 1361968 | 2021-05-28 | Clarke | Alabama | 1025 | 3521 | 61 |
1361969 | 1361969 | 2021-05-28 | Clay | Alabama | 1027 | 1578 | 57 |
1361970 | 1361970 | 2021-05-28 | Cleburne | Alabama | 1029 | 1504 | 42 |
1361971 | 1361971 | 2021-05-28 | Coffee | Alabama | 1031 | 5605 | 121 |
1361972 | 1361972 | 2021-05-28 | Colbert | Alabama | 1033 | 6347 | 137 |
1361973 | 1361973 | 2021-05-28 | Conecuh | Alabama | 1035 | 1119 | 30 |
1361974 | 1361974 | 2021-05-28 | Coosa | Alabama | 1037 | 1100 | 29 |
1361975 | 1361975 | 2021-05-28 | Covington | Alabama | 1039 | 4217 | 119 |
1361976 | 1361976 | 2021-05-28 | Crenshaw | Alabama | 1041 | 1540 | 57 |
1361977 | 1361977 | 2021-05-28 | Cullman | Alabama | 1043 | 9843 | 198 |
1361978 | 1361978 | 2021-05-28 | Dale | Alabama | 1045 | 4902 | 114 |
1361979 | 1361979 | 2021-05-28 | Dallas | Alabama | 1047 | 3597 | 154 |
1361980 | 1361980 | 2021-05-28 | DeKalb | Alabama | 1049 | 8896 | 188 |
1361981 | 1361981 | 2021-05-28 | Elmore | Alabama | 1051 | 10233 | 208 |
1361982 | 1361982 | 2021-05-28 | Escambia | Alabama | 1053 | 3968 | 77 |
1361983 | 1361983 | 2021-05-28 | Etowah | Alabama | 1055 | 13981 | 359 |
1361984 | 1361984 | 2021-05-28 | Fayette | Alabama | 1057 | 2147 | 62 |
1361985 | 1361985 | 2021-05-28 | Franklin | Alabama | 1059 | 4273 | 82 |
1361986 | 1361986 | 2021-05-28 | Geneva | Alabama | 1061 | 2559 | 81 |
1361987 | 1361987 | 2021-05-28 | Greene | Alabama | 1063 | 928 | 34 |
1361988 | 1361988 | 2021-05-28 | Hale | Alabama | 1065 | 2252 | 78 |
1361989 | 1361989 | 2021-05-28 | Henry | Alabama | 1067 | 1934 | 43 |
1361990 | 1361990 | 2021-05-28 | Houston | Alabama | 1069 | 10714 | 285 |
1361991 | 1361991 | 2021-05-28 | Jackson | Alabama | 1071 | 6866 | 112 |
1361992 | 1361992 | 2021-05-28 | Jefferson | Alabama | 1073 | 80195 | 1539 |
1361993 | 1361993 | 2021-05-28 | Lamar | Alabama | 1075 | 1450 | 37 |
1361994 | 1361994 | 2021-05-28 | Lauderdale | Alabama | 1077 | 9511 | 245 |
1361995 | 1361995 | 2021-05-28 | Lawrence | Alabama | 1079 | 3076 | 100 |
1361996 | 1361996 | 2021-05-28 | Lee | Alabama | 1081 | 16115 | 173 |
1361997 | 1361997 | 2021-05-28 | Limestone | Alabama | 1083 | 10118 | 156 |
1361998 | 1361998 | 2021-05-28 | Lowndes | Alabama | 1085 | 1412 | 54 |
1361999 | 1361999 | 2021-05-28 | Macon | Alabama | 1087 | 1622 | 50 |
1362000 | 1362000 | 2021-05-28 | Madison | Alabama | 1089 | 35344 | 513 |
1362001 | 1362001 | 2021-05-28 | Marengo | Alabama | 1091 | 2502 | 65 |
1362002 | 1362002 | 2021-05-28 | Marion | Alabama | 1093 | 3178 | 102 |
1362003 | 1362003 | 2021-05-28 | Marshall | Alabama | 1095 | 12338 | 227 |
1362004 | 1362004 | 2021-05-28 | Mobile | Alabama | 1097 | 41551 | 815 |
1362005 | 1362005 | 2021-05-28 | Monroe | Alabama | 1099 | 1790 | 41 |
1362006 | 1362006 | 2021-05-28 | Montgomery | Alabama | 1101 | 24871 | 600 |
1362007 | 1362007 | 2021-05-28 | Morgan | Alabama | 1103 | 14520 | 283 |
1362008 | 1362008 | 2021-05-28 | Perry | Alabama | 1105 | 1081 | 26 |
1362009 | 1362009 | 2021-05-28 | Pickens | Alabama | 1107 | 2356 | 62 |
1362010 | 1362010 | 2021-05-28 | Pike | Alabama | 1109 | 3132 | 77 |
1362011 | 1362011 | 2021-05-28 | Randolph | Alabama | 1111 | 1846 | 43 |
1362012 | 1362012 | 2021-05-28 | Russell | Alabama | 1113 | 4505 | 40 |
1362013 | 1362013 | 2021-05-28 | Shelby | Alabama | 1117 | 25401 | 253 |
1362014 | 1362014 | 2021-05-28 | St. Clair | Alabama | 1115 | 10034 | 247 |
1362015 | 1362015 | 2021-05-28 | Sumter | Alabama | 1119 | 1056 | 32 |
1362016 | 1362016 | 2021-05-28 | Talladega | Alabama | 1121 | 8373 | 180 |
1362017 | 1362017 | 2021-05-28 | Tallapoosa | Alabama | 1123 | 4077 | 153 |
1362018 | 1362018 | 2021-05-28 | Tuscaloosa | Alabama | 1125 | 26031 | 457 |
1362019 | 1362019 | 2021-05-28 | Walker | Alabama | 1127 | 7284 | 278 |
1362020 | 1362020 | 2021-05-28 | Washington | Alabama | 1129 | 1687 | 39 |
1362021 | 1362021 | 2021-05-28 | Wilcox | Alabama | 1131 | 1271 | 30 |
1362022 | 1362022 | 2021-05-28 | Winston | Alabama | 1133 | 2786 | 73 |
1362023 | 1362023 | 2021-05-28 | Aleutians East Borough | Alaska | 2013 | 367 | 3 |
1362024 | 1362024 | 2021-05-28 | Aleutians West Census Area | Alaska | 2016 | 704 | 0 |
1362025 | 1362025 | 2021-05-28 | Anchorage | Alaska | 2020 | 30556 | 174 |
1362026 | 1362026 | 2021-05-28 | Bethel Census Area | Alaska | 2050 | 3900 | 22 |
1362027 | 1362027 | 2021-05-28 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 196 | 0 |
1362028 | 1362028 | 2021-05-28 | Denali Borough | Alaska | 2068 | 109 | 0 |
1362029 | 1362029 | 2021-05-28 | Dillingham Census Area | Alaska | 2070 | 229 | 2 |
1362030 | 1362030 | 2021-05-28 | Fairbanks North Star Borough | Alaska | 2090 | 7938 | 43 |
1362031 | 1362031 | 2021-05-28 | Haines Borough | Alaska | 2100 | 28 | 0 |
1362032 | 1362032 | 2021-05-28 | Juneau City and Borough | Alaska | 2110 | 1414 | 3 |
1362033 | 1362033 | 2021-05-28 | Kenai Peninsula Borough | Alaska | 2122 | 4513 | 19 |
1362034 | 1362034 | 2021-05-28 | Ketchikan Gateway Borough | Alaska | 2130 | 637 | 1 |
1362035 | 1362035 | 2021-05-28 | Kodiak Island Borough | Alaska | 2150 | 1119 | 6 |
1362036 | 1362036 | 2021-05-28 | Kusilvak Census Area | Alaska | 2158 | 1308 | 4 |
1362037 | 1362037 | 2021-05-28 | Matanuska-Susitna Borough | Alaska | 2170 | 11666 | 55 |
1362038 | 1362038 | 2021-05-28 | Nome Census Area | Alaska | 2180 | 367 | 0 |
1362039 | 1362039 | 2021-05-28 | North Slope Borough | Alaska | 2185 | 1080 | 4 |
1362040 | 1362040 | 2021-05-28 | Northwest Arctic Borough | Alaska | 2188 | 619 | 2 |
1362041 | 1362041 | 2021-05-28 | Petersburg Borough | Alaska | 2195 | 165 | 0 |
1362042 | 1362042 | 2021-05-28 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 142 | 1 |
1362043 | 1362043 | 2021-05-28 | Sitka City and Borough | Alaska | 2220 | 357 | 0 |
1362044 | 1362044 | 2021-05-28 | Skagway Municipality | Alaska | 2230 | 20 | 0 |
1362045 | 1362045 | 2021-05-28 | Southeast Fairbanks Census Area | Alaska | 2240 | 722 | 5 |
1362046 | 1362046 | 2021-05-28 | Unknown | Alaska | 295 | 0 | |
1362047 | 1362047 | 2021-05-28 | Valdez-Cordova Census Area | Alaska | 2261 | 671 | 2 |
1362048 | 1362048 | 2021-05-28 | Wrangell City and Borough | Alaska | 2275 | 54 | 0 |
1362049 | 1362049 | 2021-05-28 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 85 | 2 |
1362050 | 1362050 | 2021-05-28 | Yukon-Koyukuk Census Area | Alaska | 2290 | 366 | 4 |
1362051 | 1362051 | 2021-05-28 | Apache | Arizona | 4001 | 11403 | 432 |
1362052 | 1362052 | 2021-05-28 | Cochise | Arizona | 4003 | 12069 | 288 |
1362053 | 1362053 | 2021-05-28 | Coconino | Arizona | 4005 | 17857 | 330 |
1362054 | 1362054 | 2021-05-28 | Gila | Arizona | 4007 | 6933 | 230 |
1362055 | 1362055 | 2021-05-28 | Graham | Arizona | 4009 | 5616 | 82 |
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);