ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,245 rows where date = "2021-01-11" 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 102
- Iowa 100
- North Carolina 100
- Tennessee 96
- Nebraska 93
- Indiana 92
- Minnesota 88
- Ohio 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
- Jackson 24
- Lincoln 24
- Unknown 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 |
---|---|---|---|---|---|---|---|
917193 | 917193 | 2021-01-11 | Autauga | Alabama | 1001 | 4902 | 55 |
917194 | 917194 | 2021-01-11 | Baldwin | Alabama | 1003 | 15417 | 173 |
917195 | 917195 | 2021-01-11 | Barbour | Alabama | 1005 | 1663 | 35 |
917196 | 917196 | 2021-01-11 | Bibb | Alabama | 1007 | 2060 | 48 |
917197 | 917197 | 2021-01-11 | Blount | Alabama | 1009 | 5080 | 77 |
917198 | 917198 | 2021-01-11 | Bullock | Alabama | 1011 | 957 | 28 |
917199 | 917199 | 2021-01-11 | Butler | Alabama | 1013 | 1637 | 57 |
917200 | 917200 | 2021-01-11 | Calhoun | Alabama | 1015 | 10537 | 178 |
917201 | 917201 | 2021-01-11 | Chambers | Alabama | 1017 | 2651 | 66 |
917202 | 917202 | 2021-01-11 | Cherokee | Alabama | 1019 | 1545 | 24 |
917203 | 917203 | 2021-01-11 | Chilton | Alabama | 1021 | 3277 | 54 |
917204 | 917204 | 2021-01-11 | Choctaw | Alabama | 1023 | 501 | 22 |
917205 | 917205 | 2021-01-11 | Clarke | Alabama | 1025 | 2643 | 26 |
917206 | 917206 | 2021-01-11 | Clay | Alabama | 1027 | 1233 | 35 |
917207 | 917207 | 2021-01-11 | Cleburne | Alabama | 1029 | 1128 | 18 |
917208 | 917208 | 2021-01-11 | Coffee | Alabama | 1031 | 4181 | 43 |
917209 | 917209 | 2021-01-11 | Colbert | Alabama | 1033 | 5109 | 62 |
917210 | 917210 | 2021-01-11 | Conecuh | Alabama | 1035 | 908 | 18 |
917211 | 917211 | 2021-01-11 | Coosa | Alabama | 1037 | 581 | 10 |
917212 | 917212 | 2021-01-11 | Covington | Alabama | 1039 | 3177 | 52 |
917213 | 917213 | 2021-01-11 | Crenshaw | Alabama | 1041 | 1127 | 38 |
917214 | 917214 | 2021-01-11 | Cullman | Alabama | 1043 | 7719 | 80 |
917215 | 917215 | 2021-01-11 | Dale | Alabama | 1045 | 3748 | 64 |
917216 | 917216 | 2021-01-11 | Dallas | Alabama | 1047 | 2929 | 45 |
917217 | 917217 | 2021-01-11 | DeKalb | Alabama | 1049 | 7413 | 63 |
917218 | 917218 | 2021-01-11 | Elmore | Alabama | 1051 | 7433 | 85 |
917219 | 917219 | 2021-01-11 | Escambia | Alabama | 1053 | 2997 | 34 |
917220 | 917220 | 2021-01-11 | Etowah | Alabama | 1055 | 11151 | 107 |
917221 | 917221 | 2021-01-11 | Fayette | Alabama | 1057 | 1585 | 21 |
917222 | 917222 | 2021-01-11 | Franklin | Alabama | 1059 | 3552 | 39 |
917223 | 917223 | 2021-01-11 | Geneva | Alabama | 1061 | 1920 | 23 |
917224 | 917224 | 2021-01-11 | Greene | Alabama | 1063 | 734 | 20 |
917225 | 917225 | 2021-01-11 | Hale | Alabama | 1065 | 1667 | 41 |
917226 | 917226 | 2021-01-11 | Henry | Alabama | 1067 | 1442 | 11 |
917227 | 917227 | 2021-01-11 | Houston | Alabama | 1069 | 8203 | 72 |
917228 | 917228 | 2021-01-11 | Jackson | Alabama | 1071 | 5631 | 34 |
917229 | 917229 | 2021-01-11 | Jefferson | Alabama | 1073 | 59248 | 784 |
917230 | 917230 | 2021-01-11 | Lamar | Alabama | 1075 | 1146 | 16 |
917231 | 917231 | 2021-01-11 | Lauderdale | Alabama | 1077 | 7214 | 72 |
917232 | 917232 | 2021-01-11 | Lawrence | Alabama | 1079 | 2340 | 44 |
917233 | 917233 | 2021-01-11 | Lee | Alabama | 1081 | 11626 | 79 |
917234 | 917234 | 2021-01-11 | Limestone | Alabama | 1083 | 7638 | 60 |
917235 | 917235 | 2021-01-11 | Lowndes | Alabama | 1085 | 1058 | 35 |
917236 | 917236 | 2021-01-11 | Macon | Alabama | 1087 | 1100 | 35 |
917237 | 917237 | 2021-01-11 | Madison | Alabama | 1089 | 25643 | 178 |
917238 | 917238 | 2021-01-11 | Marengo | Alabama | 1091 | 1947 | 27 |
917239 | 917239 | 2021-01-11 | Marion | Alabama | 1093 | 2335 | 46 |
917240 | 917240 | 2021-01-11 | Marshall | Alabama | 1095 | 9863 | 92 |
917241 | 917241 | 2021-01-11 | Mobile | Alabama | 1097 | 28793 | 527 |
917242 | 917242 | 2021-01-11 | Monroe | Alabama | 1099 | 1387 | 12 |
917243 | 917243 | 2021-01-11 | Montgomery | Alabama | 1101 | 18176 | 286 |
917244 | 917244 | 2021-01-11 | Morgan | Alabama | 1103 | 11781 | 104 |
917245 | 917245 | 2021-01-11 | Perry | Alabama | 1105 | 934 | 19 |
917246 | 917246 | 2021-01-11 | Pickens | Alabama | 1107 | 1895 | 31 |
917247 | 917247 | 2021-01-11 | Pike | Alabama | 1109 | 2341 | 23 |
917248 | 917248 | 2021-01-11 | Randolph | Alabama | 1111 | 1353 | 32 |
917249 | 917249 | 2021-01-11 | Russell | Alabama | 1113 | 3075 | 7 |
917250 | 917250 | 2021-01-11 | Shelby | Alabama | 1117 | 17690 | 106 |
917251 | 917251 | 2021-01-11 | St. Clair | Alabama | 1115 | 7250 | 115 |
917252 | 917252 | 2021-01-11 | Sumter | Alabama | 1119 | 890 | 26 |
917253 | 917253 | 2021-01-11 | Talladega | Alabama | 1121 | 5825 | 109 |
917254 | 917254 | 2021-01-11 | Tallapoosa | Alabama | 1123 | 2554 | 107 |
917255 | 917255 | 2021-01-11 | Tuscaloosa | Alabama | 1125 | 20211 | 267 |
917256 | 917256 | 2021-01-11 | Walker | Alabama | 1127 | 5758 | 170 |
917257 | 917257 | 2021-01-11 | Washington | Alabama | 1129 | 1323 | 26 |
917258 | 917258 | 2021-01-11 | Wilcox | Alabama | 1131 | 977 | 20 |
917259 | 917259 | 2021-01-11 | Winston | Alabama | 1133 | 2191 | 34 |
917260 | 917260 | 2021-01-11 | Aleutians East Borough | Alaska | 2013 | 38 | 0 |
917261 | 917261 | 2021-01-11 | Aleutians West Census Area | Alaska | 2016 | 228 | 0 |
917262 | 917262 | 2021-01-11 | Anchorage | Alaska | 2020 | 24066 | 124 |
917263 | 917263 | 2021-01-11 | Bethel Census Area | Alaska | 2050 | 2809 | 12 |
917264 | 917264 | 2021-01-11 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 160 | 0 |
917265 | 917265 | 2021-01-11 | Denali Borough | Alaska | 2068 | 61 | 0 |
917266 | 917266 | 2021-01-11 | Dillingham Census Area | Alaska | 2070 | 146 | 1 |
917267 | 917267 | 2021-01-11 | Fairbanks North Star Borough | Alaska | 2090 | 5363 | 21 |
917268 | 917268 | 2021-01-11 | Haines Borough | Alaska | 2100 | 20 | 0 |
917269 | 917269 | 2021-01-11 | Juneau City and Borough | Alaska | 2110 | 1052 | 3 |
917270 | 917270 | 2021-01-11 | Kenai Peninsula Borough | Alaska | 2122 | 3745 | 16 |
917271 | 917271 | 2021-01-11 | Ketchikan Gateway Borough | Alaska | 2130 | 255 | 1 |
917272 | 917272 | 2021-01-11 | Kodiak Island Borough | Alaska | 2150 | 974 | 2 |
917273 | 917273 | 2021-01-11 | Kusilvak Census Area | Alaska | 2158 | 922 | 3 |
917274 | 917274 | 2021-01-11 | Matanuska-Susitna Borough | Alaska | 2170 | 6906 | 18 |
917275 | 917275 | 2021-01-11 | Nome Census Area | Alaska | 2180 | 285 | 0 |
917276 | 917276 | 2021-01-11 | North Slope Borough | Alaska | 2185 | 875 | 3 |
917277 | 917277 | 2021-01-11 | Northwest Arctic Borough | Alaska | 2188 | 492 | 0 |
917278 | 917278 | 2021-01-11 | Petersburg Borough | Alaska | 2195 | 34 | 0 |
917279 | 917279 | 2021-01-11 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 69 | 1 |
917280 | 917280 | 2021-01-11 | Sitka City and Borough | Alaska | 2220 | 276 | 0 |
917281 | 917281 | 2021-01-11 | Skagway Municipality | Alaska | 2230 | 15 | 0 |
917282 | 917282 | 2021-01-11 | Southeast Fairbanks Census Area | Alaska | 2240 | 412 | 3 |
917283 | 917283 | 2021-01-11 | Unknown | Alaska | 211 | 0 | |
917284 | 917284 | 2021-01-11 | Valdez-Cordova Census Area | Alaska | 2261 | 377 | 2 |
917285 | 917285 | 2021-01-11 | Wrangell City and Borough | Alaska | 2275 | 24 | 0 |
917286 | 917286 | 2021-01-11 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 58 | 1 |
917287 | 917287 | 2021-01-11 | Yukon-Koyukuk Census Area | Alaska | 2290 | 238 | 4 |
917288 | 917288 | 2021-01-11 | Apache | Arizona | 4001 | 8309 | 259 |
917289 | 917289 | 2021-01-11 | Cochise | Arizona | 4003 | 8969 | 164 |
917290 | 917290 | 2021-01-11 | Coconino | Arizona | 4005 | 12996 | 233 |
917291 | 917291 | 2021-01-11 | Gila | Arizona | 4007 | 5098 | 155 |
917292 | 917292 | 2021-01-11 | Graham | Arizona | 4009 | 4071 | 56 |
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);