ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,216 rows where date = "2020-07-28" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state >30
- Texas 250
- Georgia 160
- Virginia 133
- Kentucky 120
- Missouri 117
- Illinois 103
- Kansas 103
- Iowa 100
- North Carolina 100
- Tennessee 96
- Indiana 92
- Minnesota 88
- Ohio 88
- Nebraska 85
- Michigan 84
- Mississippi 83
- Puerto Rico 79
- Oklahoma 77
- Arkansas 76
- Wisconsin 73
- Florida 68
- Alabama 67
- Pennsylvania 67
- Louisiana 65
- South Dakota 65
- Colorado 63
- New York 58
- California 57
- West Virginia 55
- North Dakota 54
- …
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 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 |
---|---|---|---|---|---|---|---|
376289 | 376289 | 2020-07-28 | Autauga | Alabama | 1001 | 974 | 21 |
376290 | 376290 | 2020-07-28 | Baldwin | Alabama | 1003 | 2835 | 18 |
376291 | 376291 | 2020-07-28 | Barbour | Alabama | 1005 | 575 | 4 |
376292 | 376292 | 2020-07-28 | Bibb | Alabama | 1007 | 338 | 2 |
376293 | 376293 | 2020-07-28 | Blount | Alabama | 1009 | 675 | 1 |
376294 | 376294 | 2020-07-28 | Bullock | Alabama | 1011 | 429 | 12 |
376295 | 376295 | 2020-07-28 | Butler | Alabama | 1013 | 734 | 36 |
376296 | 376296 | 2020-07-28 | Calhoun | Alabama | 1015 | 1244 | 6 |
376297 | 376297 | 2020-07-28 | Chambers | Alabama | 1017 | 836 | 38 |
376298 | 376298 | 2020-07-28 | Cherokee | Alabama | 1019 | 221 | 8 |
376299 | 376299 | 2020-07-28 | Chilton | Alabama | 1021 | 646 | 6 |
376300 | 376300 | 2020-07-28 | Choctaw | Alabama | 1023 | 268 | 12 |
376301 | 376301 | 2020-07-28 | Clarke | Alabama | 1025 | 456 | 9 |
376302 | 376302 | 2020-07-28 | Clay | Alabama | 1027 | 180 | 4 |
376303 | 376303 | 2020-07-28 | Cleburne | Alabama | 1029 | 105 | 1 |
376304 | 376304 | 2020-07-28 | Coffee | Alabama | 1031 | 670 | 5 |
376305 | 376305 | 2020-07-28 | Colbert | Alabama | 1033 | 946 | 11 |
376306 | 376306 | 2020-07-28 | Conecuh | Alabama | 1035 | 350 | 9 |
376307 | 376307 | 2020-07-28 | Coosa | Alabama | 1037 | 92 | 2 |
376308 | 376308 | 2020-07-28 | Covington | Alabama | 1039 | 726 | 20 |
376309 | 376309 | 2020-07-28 | Crenshaw | Alabama | 1041 | 244 | 4 |
376310 | 376310 | 2020-07-28 | Cullman | Alabama | 1043 | 1047 | 10 |
376311 | 376311 | 2020-07-28 | Dale | Alabama | 1045 | 725 | 17 |
376312 | 376312 | 2020-07-28 | Dallas | Alabama | 1047 | 1279 | 21 |
376313 | 376313 | 2020-07-28 | DeKalb | Alabama | 1049 | 1547 | 10 |
376314 | 376314 | 2020-07-28 | Elmore | Alabama | 1051 | 1527 | 34 |
376315 | 376315 | 2020-07-28 | Escambia | Alabama | 1053 | 911 | 13 |
376316 | 376316 | 2020-07-28 | Etowah | Alabama | 1055 | 1768 | 17 |
376317 | 376317 | 2020-07-28 | Fayette | Alabama | 1057 | 158 | 5 |
376318 | 376318 | 2020-07-28 | Franklin | Alabama | 1059 | 1117 | 20 |
376319 | 376319 | 2020-07-28 | Geneva | Alabama | 1061 | 200 | 1 |
376320 | 376320 | 2020-07-28 | Greene | Alabama | 1063 | 239 | 11 |
376321 | 376321 | 2020-07-28 | Hale | Alabama | 1065 | 439 | 23 |
376322 | 376322 | 2020-07-28 | Henry | Alabama | 1067 | 235 | 4 |
376323 | 376323 | 2020-07-28 | Houston | Alabama | 1069 | 1190 | 14 |
376324 | 376324 | 2020-07-28 | Jackson | Alabama | 1071 | 679 | 5 |
376325 | 376325 | 2020-07-28 | Jefferson | Alabama | 1073 | 10715 | 205 |
376326 | 376326 | 2020-07-28 | Lamar | Alabama | 1075 | 178 | 1 |
376327 | 376327 | 2020-07-28 | Lauderdale | Alabama | 1077 | 932 | 9 |
376328 | 376328 | 2020-07-28 | Lawrence | Alabama | 1079 | 265 | 0 |
376329 | 376329 | 2020-07-28 | Lee | Alabama | 1081 | 2449 | 43 |
376330 | 376330 | 2020-07-28 | Limestone | Alabama | 1083 | 1064 | 11 |
376331 | 376331 | 2020-07-28 | Lowndes | Alabama | 1085 | 551 | 26 |
376332 | 376332 | 2020-07-28 | Macon | Alabama | 1087 | 304 | 12 |
376333 | 376333 | 2020-07-28 | Madison | Alabama | 1089 | 4522 | 25 |
376334 | 376334 | 2020-07-28 | Marengo | Alabama | 1091 | 497 | 13 |
376335 | 376335 | 2020-07-28 | Marion | Alabama | 1093 | 509 | 24 |
376336 | 376336 | 2020-07-28 | Marshall | Alabama | 1095 | 2760 | 26 |
376337 | 376337 | 2020-07-28 | Mobile | Alabama | 1097 | 7528 | 182 |
376338 | 376338 | 2020-07-28 | Monroe | Alabama | 1099 | 402 | 4 |
376339 | 376339 | 2020-07-28 | Montgomery | Alabama | 1101 | 5921 | 141 |
376340 | 376340 | 2020-07-28 | Morgan | Alabama | 1103 | 2023 | 14 |
376341 | 376341 | 2020-07-28 | Perry | Alabama | 1105 | 418 | 3 |
376342 | 376342 | 2020-07-28 | Pickens | Alabama | 1107 | 344 | 9 |
376343 | 376343 | 2020-07-28 | Pike | Alabama | 1109 | 622 | 7 |
376344 | 376344 | 2020-07-28 | Randolph | Alabama | 1111 | 381 | 11 |
376345 | 376345 | 2020-07-28 | Russell | Alabama | 1113 | 1129 | 1 |
376346 | 376346 | 2020-07-28 | Shelby | Alabama | 1117 | 2855 | 30 |
376347 | 376347 | 2020-07-28 | St. Clair | Alabama | 1115 | 1104 | 9 |
376348 | 376348 | 2020-07-28 | Sumter | Alabama | 1119 | 354 | 15 |
376349 | 376349 | 2020-07-28 | Talladega | Alabama | 1121 | 877 | 10 |
376350 | 376350 | 2020-07-28 | Tallapoosa | Alabama | 1123 | 810 | 79 |
376351 | 376351 | 2020-07-28 | Tuscaloosa | Alabama | 1125 | 3731 | 60 |
376352 | 376352 | 2020-07-28 | Walker | Alabama | 1127 | 1429 | 58 |
376353 | 376353 | 2020-07-28 | Washington | Alabama | 1129 | 291 | 10 |
376354 | 376354 | 2020-07-28 | Wilcox | Alabama | 1131 | 397 | 9 |
376355 | 376355 | 2020-07-28 | Winston | Alabama | 1133 | 399 | 10 |
376356 | 376356 | 2020-07-28 | Aleutians East Borough | Alaska | 2013 | 3 | 0 |
376357 | 376357 | 2020-07-28 | Aleutians West Census Area | Alaska | 2016 | 87 | 0 |
376358 | 376358 | 2020-07-28 | Anchorage | Alaska | 2020 | 1601 | 9 |
376359 | 376359 | 2020-07-28 | Bethel Census Area | Alaska | 2050 | 20 | 0 |
376360 | 376360 | 2020-07-28 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 68 | 0 |
376361 | 376361 | 2020-07-28 | Denali Borough | Alaska | 2068 | 4 | 0 |
376362 | 376362 | 2020-07-28 | Dillingham Census Area | Alaska | 2070 | 21 | 0 |
376363 | 376363 | 2020-07-28 | Fairbanks North Star Borough | Alaska | 2090 | 412 | 5 |
376364 | 376364 | 2020-07-28 | Haines Borough | Alaska | 2100 | 8 | 0 |
376365 | 376365 | 2020-07-28 | Juneau City and Borough | Alaska | 2110 | 126 | 2 |
376366 | 376366 | 2020-07-28 | Kenai Peninsula Borough | Alaska | 2122 | 388 | 1 |
376367 | 376367 | 2020-07-28 | Ketchikan Gateway Borough | Alaska | 2130 | 47 | 0 |
376368 | 376368 | 2020-07-28 | Kodiak Island Borough | Alaska | 2150 | 14 | 0 |
376369 | 376369 | 2020-07-28 | Kusilvak Census Area | Alaska | 2158 | 4 | 0 |
376370 | 376370 | 2020-07-28 | Matanuska-Susitna Borough | Alaska | 2170 | 249 | 2 |
376371 | 376371 | 2020-07-28 | Nome Census Area | Alaska | 2180 | 20 | 0 |
376372 | 376372 | 2020-07-28 | North Slope Borough | Alaska | 2185 | 13 | 0 |
376373 | 376373 | 2020-07-28 | Northwest Arctic Borough | Alaska | 2188 | 19 | 0 |
376374 | 376374 | 2020-07-28 | Petersburg Borough | Alaska | 2195 | 9 | 0 |
376375 | 376375 | 2020-07-28 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 6 | 0 |
376376 | 376376 | 2020-07-28 | Sitka City and Borough | Alaska | 2220 | 30 | 0 |
376377 | 376377 | 2020-07-28 | Southeast Fairbanks Census Area | Alaska | 2240 | 26 | 0 |
376378 | 376378 | 2020-07-28 | Unknown | Alaska | 35 | 0 | |
376379 | 376379 | 2020-07-28 | Valdez-Cordova Census Area | Alaska | 2261 | 83 | 0 |
376380 | 376380 | 2020-07-28 | Wrangell City and Borough | Alaska | 2275 | 8 | 0 |
376381 | 376381 | 2020-07-28 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 5 | 0 |
376382 | 376382 | 2020-07-28 | Yukon-Koyukuk Census Area | Alaska | 2290 | 42 | 1 |
376383 | 376383 | 2020-07-28 | Apache | Arizona | 4001 | 2945 | 128 |
376384 | 376384 | 2020-07-28 | Cochise | Arizona | 4003 | 1422 | 45 |
376385 | 376385 | 2020-07-28 | Coconino | Arizona | 4005 | 2880 | 112 |
376386 | 376386 | 2020-07-28 | Gila | Arizona | 4007 | 724 | 22 |
376387 | 376387 | 2020-07-28 | Graham | Arizona | 4009 | 431 | 6 |
376388 | 376388 | 2020-07-28 | Greenlee | Arizona | 4011 | 52 | 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);