ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,247 rows where date = "2021-03-25" 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 106
- 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
- Unknown 26
- Franklin 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 |
---|---|---|---|---|---|---|---|
1154138 | 1154138 | 2021-03-25 | Autauga | Alabama | 1001 | 6540 | 99 |
1154139 | 1154139 | 2021-03-25 | Baldwin | Alabama | 1003 | 20417 | 300 |
1154140 | 1154140 | 2021-03-25 | Barbour | Alabama | 1005 | 2218 | 54 |
1154141 | 1154141 | 2021-03-25 | Bibb | Alabama | 1007 | 2534 | 58 |
1154142 | 1154142 | 2021-03-25 | Blount | Alabama | 1009 | 6408 | 131 |
1154143 | 1154143 | 2021-03-25 | Bullock | Alabama | 1011 | 1200 | 39 |
1154144 | 1154144 | 2021-03-25 | Butler | Alabama | 1013 | 2082 | 66 |
1154145 | 1154145 | 2021-03-25 | Calhoun | Alabama | 1015 | 14188 | 304 |
1154146 | 1154146 | 2021-03-25 | Chambers | Alabama | 1017 | 3478 | 116 |
1154147 | 1154147 | 2021-03-25 | Cherokee | Alabama | 1019 | 1798 | 43 |
1154148 | 1154148 | 2021-03-25 | Chilton | Alabama | 1021 | 4014 | 109 |
1154149 | 1154149 | 2021-03-25 | Choctaw | Alabama | 1023 | 583 | 24 |
1154150 | 1154150 | 2021-03-25 | Clarke | Alabama | 1025 | 3467 | 58 |
1154151 | 1154151 | 2021-03-25 | Clay | Alabama | 1027 | 1480 | 54 |
1154152 | 1154152 | 2021-03-25 | Cleburne | Alabama | 1029 | 1447 | 41 |
1154153 | 1154153 | 2021-03-25 | Coffee | Alabama | 1031 | 5368 | 107 |
1154154 | 1154154 | 2021-03-25 | Colbert | Alabama | 1033 | 6150 | 125 |
1154155 | 1154155 | 2021-03-25 | Conecuh | Alabama | 1035 | 1086 | 26 |
1154156 | 1154156 | 2021-03-25 | Coosa | Alabama | 1037 | 942 | 24 |
1154157 | 1154157 | 2021-03-25 | Covington | Alabama | 1039 | 4033 | 111 |
1154158 | 1154158 | 2021-03-25 | Crenshaw | Alabama | 1041 | 1494 | 57 |
1154159 | 1154159 | 2021-03-25 | Cullman | Alabama | 1043 | 9335 | 186 |
1154160 | 1154160 | 2021-03-25 | Dale | Alabama | 1045 | 4741 | 109 |
1154161 | 1154161 | 2021-03-25 | Dallas | Alabama | 1047 | 3509 | 147 |
1154162 | 1154162 | 2021-03-25 | DeKalb | Alabama | 1049 | 8684 | 179 |
1154163 | 1154163 | 2021-03-25 | Elmore | Alabama | 1051 | 9878 | 201 |
1154164 | 1154164 | 2021-03-25 | Escambia | Alabama | 1053 | 3850 | 74 |
1154165 | 1154165 | 2021-03-25 | Etowah | Alabama | 1055 | 13629 | 342 |
1154166 | 1154166 | 2021-03-25 | Fayette | Alabama | 1057 | 2060 | 59 |
1154167 | 1154167 | 2021-03-25 | Franklin | Alabama | 1059 | 4183 | 82 |
1154168 | 1154168 | 2021-03-25 | Geneva | Alabama | 1061 | 2440 | 73 |
1154169 | 1154169 | 2021-03-25 | Greene | Alabama | 1063 | 901 | 33 |
1154170 | 1154170 | 2021-03-25 | Hale | Alabama | 1065 | 2156 | 72 |
1154171 | 1154171 | 2021-03-25 | Henry | Alabama | 1067 | 1863 | 42 |
1154172 | 1154172 | 2021-03-25 | Houston | Alabama | 1069 | 10280 | 269 |
1154173 | 1154173 | 2021-03-25 | Jackson | Alabama | 1071 | 6711 | 106 |
1154174 | 1154174 | 2021-03-25 | Jefferson | Alabama | 1073 | 74348 | 1455 |
1154175 | 1154175 | 2021-03-25 | Lamar | Alabama | 1075 | 1378 | 33 |
1154176 | 1154176 | 2021-03-25 | Lauderdale | Alabama | 1077 | 9070 | 218 |
1154177 | 1154177 | 2021-03-25 | Lawrence | Alabama | 1079 | 2912 | 93 |
1154178 | 1154178 | 2021-03-25 | Lee | Alabama | 1081 | 15355 | 166 |
1154179 | 1154179 | 2021-03-25 | Limestone | Alabama | 1083 | 9699 | 145 |
1154180 | 1154180 | 2021-03-25 | Lowndes | Alabama | 1085 | 1358 | 53 |
1154181 | 1154181 | 2021-03-25 | Macon | Alabama | 1087 | 1527 | 47 |
1154182 | 1154182 | 2021-03-25 | Madison | Alabama | 1089 | 33362 | 487 |
1154183 | 1154183 | 2021-03-25 | Marengo | Alabama | 1091 | 2492 | 59 |
1154184 | 1154184 | 2021-03-25 | Marion | Alabama | 1093 | 3046 | 99 |
1154185 | 1154185 | 2021-03-25 | Marshall | Alabama | 1095 | 11828 | 216 |
1154186 | 1154186 | 2021-03-25 | Mobile | Alabama | 1097 | 37395 | 785 |
1154187 | 1154187 | 2021-03-25 | Monroe | Alabama | 1099 | 1699 | 39 |
1154188 | 1154188 | 2021-03-25 | Montgomery | Alabama | 1101 | 23526 | 546 |
1154189 | 1154189 | 2021-03-25 | Morgan | Alabama | 1103 | 14105 | 263 |
1154190 | 1154190 | 2021-03-25 | Perry | Alabama | 1105 | 1077 | 27 |
1154191 | 1154191 | 2021-03-25 | Pickens | Alabama | 1107 | 2319 | 57 |
1154192 | 1154192 | 2021-03-25 | Pike | Alabama | 1109 | 3014 | 74 |
1154193 | 1154193 | 2021-03-25 | Randolph | Alabama | 1111 | 1736 | 41 |
1154194 | 1154194 | 2021-03-25 | Russell | Alabama | 1113 | 4201 | 35 |
1154195 | 1154195 | 2021-03-25 | Shelby | Alabama | 1117 | 22906 | 232 |
1154196 | 1154196 | 2021-03-25 | St. Clair | Alabama | 1115 | 9308 | 232 |
1154197 | 1154197 | 2021-03-25 | Sumter | Alabama | 1119 | 1024 | 32 |
1154198 | 1154198 | 2021-03-25 | Talladega | Alabama | 1121 | 7915 | 167 |
1154199 | 1154199 | 2021-03-25 | Tallapoosa | Alabama | 1123 | 3841 | 143 |
1154200 | 1154200 | 2021-03-25 | Tuscaloosa | Alabama | 1125 | 24931 | 434 |
1154201 | 1154201 | 2021-03-25 | Walker | Alabama | 1127 | 7029 | 272 |
1154202 | 1154202 | 2021-03-25 | Washington | Alabama | 1129 | 1637 | 38 |
1154203 | 1154203 | 2021-03-25 | Wilcox | Alabama | 1131 | 1247 | 25 |
1154204 | 1154204 | 2021-03-25 | Winston | Alabama | 1133 | 2706 | 71 |
1154205 | 1154205 | 2021-03-25 | Aleutians East Borough | Alaska | 2013 | 363 | 2 |
1154206 | 1154206 | 2021-03-25 | Aleutians West Census Area | Alaska | 2016 | 648 | 0 |
1154207 | 1154207 | 2021-03-25 | Anchorage | Alaska | 2020 | 27858 | 161 |
1154208 | 1154208 | 2021-03-25 | Bethel Census Area | Alaska | 2050 | 3749 | 20 |
1154209 | 1154209 | 2021-03-25 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 184 | 0 |
1154210 | 1154210 | 2021-03-25 | Denali Borough | Alaska | 2068 | 81 | 0 |
1154211 | 1154211 | 2021-03-25 | Dillingham Census Area | Alaska | 2070 | 207 | 1 |
1154212 | 1154212 | 2021-03-25 | Fairbanks North Star Borough | Alaska | 2090 | 6487 | 32 |
1154213 | 1154213 | 2021-03-25 | Haines Borough | Alaska | 2100 | 26 | 0 |
1154214 | 1154214 | 2021-03-25 | Juneau City and Borough | Alaska | 2110 | 1257 | 3 |
1154215 | 1154215 | 2021-03-25 | Kenai Peninsula Borough | Alaska | 2122 | 4068 | 19 |
1154216 | 1154216 | 2021-03-25 | Ketchikan Gateway Borough | Alaska | 2130 | 372 | 1 |
1154217 | 1154217 | 2021-03-25 | Kodiak Island Borough | Alaska | 2150 | 1063 | 5 |
1154218 | 1154218 | 2021-03-25 | Kusilvak Census Area | Alaska | 2158 | 1218 | 3 |
1154219 | 1154219 | 2021-03-25 | Matanuska-Susitna Borough | Alaska | 2170 | 9625 | 35 |
1154220 | 1154220 | 2021-03-25 | Nome Census Area | Alaska | 2180 | 335 | 0 |
1154221 | 1154221 | 2021-03-25 | North Slope Borough | Alaska | 2185 | 1030 | 4 |
1154222 | 1154222 | 2021-03-25 | Northwest Arctic Borough | Alaska | 2188 | 596 | 2 |
1154223 | 1154223 | 2021-03-25 | Petersburg Borough | Alaska | 2195 | 145 | 0 |
1154224 | 1154224 | 2021-03-25 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 77 | 1 |
1154225 | 1154225 | 2021-03-25 | Sitka City and Borough | Alaska | 2220 | 317 | 0 |
1154226 | 1154226 | 2021-03-25 | Skagway Municipality | Alaska | 2230 | 19 | 0 |
1154227 | 1154227 | 2021-03-25 | Southeast Fairbanks Census Area | Alaska | 2240 | 590 | 3 |
1154228 | 1154228 | 2021-03-25 | Unknown | Alaska | 266 | 0 | |
1154229 | 1154229 | 2021-03-25 | Valdez-Cordova Census Area | Alaska | 2261 | 533 | 2 |
1154230 | 1154230 | 2021-03-25 | Wrangell City and Borough | Alaska | 2275 | 30 | 0 |
1154231 | 1154231 | 2021-03-25 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 69 | 1 |
1154232 | 1154232 | 2021-03-25 | Yukon-Koyukuk Census Area | Alaska | 2290 | 345 | 4 |
1154233 | 1154233 | 2021-03-25 | Apache | Arizona | 4001 | 10785 | 413 |
1154234 | 1154234 | 2021-03-25 | Cochise | Arizona | 4003 | 11563 | 277 |
1154235 | 1154235 | 2021-03-25 | Coconino | Arizona | 4005 | 16978 | 324 |
1154236 | 1154236 | 2021-03-25 | Gila | Arizona | 4007 | 6510 | 219 |
1154237 | 1154237 | 2021-03-25 | Graham | Arizona | 4009 | 5355 | 76 |
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);