ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,246 rows where date = "2021-01-23" 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
- 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 |
---|---|---|---|---|---|---|---|
956137 | 956137 | 2021-01-23 | Autauga | Alabama | 1001 | 5358 | 62 |
956138 | 956138 | 2021-01-23 | Baldwin | Alabama | 1003 | 17128 | 189 |
956139 | 956139 | 2021-01-23 | Barbour | Alabama | 1005 | 1805 | 38 |
956140 | 956140 | 2021-01-23 | Bibb | Alabama | 1007 | 2223 | 48 |
956141 | 956141 | 2021-01-23 | Blount | Alabama | 1009 | 5462 | 86 |
956142 | 956142 | 2021-01-23 | Bullock | Alabama | 1011 | 1033 | 28 |
956143 | 956143 | 2021-01-23 | Butler | Alabama | 1013 | 1731 | 60 |
956144 | 956144 | 2021-01-23 | Calhoun | Alabama | 1015 | 11496 | 206 |
956145 | 956145 | 2021-01-23 | Chambers | Alabama | 1017 | 3034 | 70 |
956146 | 956146 | 2021-01-23 | Cherokee | Alabama | 1019 | 1651 | 31 |
956147 | 956147 | 2021-01-23 | Chilton | Alabama | 1021 | 3443 | 73 |
956148 | 956148 | 2021-01-23 | Choctaw | Alabama | 1023 | 519 | 24 |
956149 | 956149 | 2021-01-23 | Clarke | Alabama | 1025 | 2980 | 36 |
956150 | 956150 | 2021-01-23 | Clay | Alabama | 1027 | 1297 | 46 |
956151 | 956151 | 2021-01-23 | Cleburne | Alabama | 1029 | 1215 | 25 |
956152 | 956152 | 2021-01-23 | Coffee | Alabama | 1031 | 4607 | 64 |
956153 | 956153 | 2021-01-23 | Colbert | Alabama | 1033 | 5486 | 94 |
956154 | 956154 | 2021-01-23 | Conecuh | Alabama | 1035 | 978 | 22 |
956155 | 956155 | 2021-01-23 | Coosa | Alabama | 1037 | 634 | 18 |
956156 | 956156 | 2021-01-23 | Covington | Alabama | 1039 | 3385 | 80 |
956157 | 956157 | 2021-01-23 | Crenshaw | Alabama | 1041 | 1237 | 45 |
956158 | 956158 | 2021-01-23 | Cullman | Alabama | 1043 | 8257 | 124 |
956159 | 956159 | 2021-01-23 | Dale | Alabama | 1045 | 4096 | 85 |
956160 | 956160 | 2021-01-23 | Dallas | Alabama | 1047 | 3129 | 96 |
956161 | 956161 | 2021-01-23 | DeKalb | Alabama | 1049 | 7871 | 107 |
956162 | 956162 | 2021-01-23 | Elmore | Alabama | 1051 | 8183 | 110 |
956163 | 956163 | 2021-01-23 | Escambia | Alabama | 1053 | 3345 | 44 |
956164 | 956164 | 2021-01-23 | Etowah | Alabama | 1055 | 12070 | 181 |
956165 | 956165 | 2021-01-23 | Fayette | Alabama | 1057 | 1778 | 29 |
956166 | 956166 | 2021-01-23 | Franklin | Alabama | 1059 | 3741 | 50 |
956167 | 956167 | 2021-01-23 | Geneva | Alabama | 1061 | 2102 | 47 |
956168 | 956168 | 2021-01-23 | Greene | Alabama | 1063 | 779 | 23 |
956169 | 956169 | 2021-01-23 | Hale | Alabama | 1065 | 1849 | 44 |
956170 | 956170 | 2021-01-23 | Henry | Alabama | 1067 | 1595 | 25 |
956171 | 956171 | 2021-01-23 | Houston | Alabama | 1069 | 8988 | 164 |
956172 | 956172 | 2021-01-23 | Jackson | Alabama | 1071 | 5991 | 45 |
956173 | 956173 | 2021-01-23 | Jefferson | Alabama | 1073 | 64437 | 1007 |
956174 | 956174 | 2021-01-23 | Lamar | Alabama | 1075 | 1199 | 22 |
956175 | 956175 | 2021-01-23 | Lauderdale | Alabama | 1077 | 7847 | 107 |
956176 | 956176 | 2021-01-23 | Lawrence | Alabama | 1079 | 2533 | 55 |
956177 | 956177 | 2021-01-23 | Lee | Alabama | 1081 | 13137 | 107 |
956178 | 956178 | 2021-01-23 | Limestone | Alabama | 1083 | 8320 | 81 |
956179 | 956179 | 2021-01-23 | Lowndes | Alabama | 1085 | 1148 | 36 |
956180 | 956180 | 2021-01-23 | Macon | Alabama | 1087 | 1219 | 37 |
956181 | 956181 | 2021-01-23 | Madison | Alabama | 1089 | 28158 | 217 |
956182 | 956182 | 2021-01-23 | Marengo | Alabama | 1091 | 2082 | 31 |
956183 | 956183 | 2021-01-23 | Marion | Alabama | 1093 | 2531 | 61 |
956184 | 956184 | 2021-01-23 | Marshall | Alabama | 1095 | 10420 | 123 |
956185 | 956185 | 2021-01-23 | Mobile | Alabama | 1097 | 31435 | 569 |
956186 | 956186 | 2021-01-23 | Monroe | Alabama | 1099 | 1520 | 21 |
956187 | 956187 | 2021-01-23 | Montgomery | Alabama | 1101 | 19873 | 332 |
956188 | 956188 | 2021-01-23 | Morgan | Alabama | 1103 | 12594 | 142 |
956189 | 956189 | 2021-01-23 | Perry | Alabama | 1105 | 999 | 18 |
956190 | 956190 | 2021-01-23 | Pickens | Alabama | 1107 | 1995 | 31 |
956191 | 956191 | 2021-01-23 | Pike | Alabama | 1109 | 2624 | 31 |
956192 | 956192 | 2021-01-23 | Randolph | Alabama | 1111 | 1455 | 36 |
956193 | 956193 | 2021-01-23 | Russell | Alabama | 1113 | 3542 | 15 |
956194 | 956194 | 2021-01-23 | Shelby | Alabama | 1117 | 19248 | 132 |
956195 | 956195 | 2021-01-23 | St. Clair | Alabama | 1115 | 7808 | 130 |
956196 | 956196 | 2021-01-23 | Sumter | Alabama | 1119 | 905 | 27 |
956197 | 956197 | 2021-01-23 | Talladega | Alabama | 1121 | 6445 | 112 |
956198 | 956198 | 2021-01-23 | Tallapoosa | Alabama | 1123 | 3143 | 109 |
956199 | 956199 | 2021-01-23 | Tuscaloosa | Alabama | 1125 | 21492 | 275 |
956200 | 956200 | 2021-01-23 | Walker | Alabama | 1127 | 6028 | 183 |
956201 | 956201 | 2021-01-23 | Washington | Alabama | 1129 | 1417 | 27 |
956202 | 956202 | 2021-01-23 | Wilcox | Alabama | 1131 | 1079 | 22 |
956203 | 956203 | 2021-01-23 | Winston | Alabama | 1133 | 2333 | 42 |
956204 | 956204 | 2021-01-23 | Aleutians East Borough | Alaska | 2013 | 70 | 0 |
956205 | 956205 | 2021-01-23 | Aleutians West Census Area | Alaska | 2016 | 292 | 0 |
956206 | 956206 | 2021-01-23 | Anchorage | Alaska | 2020 | 24911 | 139 |
956207 | 956207 | 2021-01-23 | Bethel Census Area | Alaska | 2050 | 3137 | 14 |
956208 | 956208 | 2021-01-23 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 168 | 0 |
956209 | 956209 | 2021-01-23 | Denali Borough | Alaska | 2068 | 63 | 0 |
956210 | 956210 | 2021-01-23 | Dillingham Census Area | Alaska | 2070 | 162 | 1 |
956211 | 956211 | 2021-01-23 | Fairbanks North Star Borough | Alaska | 2090 | 5729 | 25 |
956212 | 956212 | 2021-01-23 | Haines Borough | Alaska | 2100 | 21 | 0 |
956213 | 956213 | 2021-01-23 | Juneau City and Borough | Alaska | 2110 | 1107 | 3 |
956214 | 956214 | 2021-01-23 | Kenai Peninsula Borough | Alaska | 2122 | 3850 | 18 |
956215 | 956215 | 2021-01-23 | Ketchikan Gateway Borough | Alaska | 2130 | 268 | 1 |
956216 | 956216 | 2021-01-23 | Kodiak Island Borough | Alaska | 2150 | 1018 | 5 |
956217 | 956217 | 2021-01-23 | Kusilvak Census Area | Alaska | 2158 | 1073 | 3 |
956218 | 956218 | 2021-01-23 | Matanuska-Susitna Borough | Alaska | 2170 | 7307 | 27 |
956219 | 956219 | 2021-01-23 | Nome Census Area | Alaska | 2180 | 305 | 0 |
956220 | 956220 | 2021-01-23 | North Slope Borough | Alaska | 2185 | 966 | 3 |
956221 | 956221 | 2021-01-23 | Northwest Arctic Borough | Alaska | 2188 | 556 | 0 |
956222 | 956222 | 2021-01-23 | Petersburg Borough | Alaska | 2195 | 43 | 0 |
956223 | 956223 | 2021-01-23 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 69 | 1 |
956224 | 956224 | 2021-01-23 | Sitka City and Borough | Alaska | 2220 | 291 | 0 |
956225 | 956225 | 2021-01-23 | Skagway Municipality | Alaska | 2230 | 15 | 0 |
956226 | 956226 | 2021-01-23 | Southeast Fairbanks Census Area | Alaska | 2240 | 420 | 3 |
956227 | 956227 | 2021-01-23 | Unknown | Alaska | 232 | 0 | |
956228 | 956228 | 2021-01-23 | Valdez-Cordova Census Area | Alaska | 2261 | 402 | 2 |
956229 | 956229 | 2021-01-23 | Wrangell City and Borough | Alaska | 2275 | 24 | 0 |
956230 | 956230 | 2021-01-23 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 62 | 1 |
956231 | 956231 | 2021-01-23 | Yukon-Koyukuk Census Area | Alaska | 2290 | 259 | 4 |
956232 | 956232 | 2021-01-23 | Apache | Arizona | 4001 | 8900 | 293 |
956233 | 956233 | 2021-01-23 | Cochise | Arizona | 4003 | 10086 | 207 |
956234 | 956234 | 2021-01-23 | Coconino | Arizona | 4005 | 14627 | 261 |
956235 | 956235 | 2021-01-23 | Gila | Arizona | 4007 | 5704 | 179 |
956236 | 956236 | 2021-01-23 | Graham | Arizona | 4009 | 4779 | 63 |
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);