ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,502,832 rows sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 191,228
- Georgia 123,449
- Virginia 101,931
- Kentucky 91,492
- Missouri 88,547
- Illinois 78,575
- Kansas 78,340
- North Carolina 76,909
- Iowa 76,170
- Tennessee 73,855
- Indiana 71,084
- Nebraska 68,409
- Ohio 68,300
- Minnesota 67,091
- Michigan 64,446
- Mississippi 63,401
- Oklahoma 59,221
- Arkansas 58,348
- Puerto Rico 57,686
- Wisconsin 55,345
- Florida 52,750
- Pennsylvania 51,838
- Alabama 51,680
- Louisiana 50,317
- South Dakota 48,958
- Colorado 48,951
- California 45,171
- New York 45,170
- West Virginia 41,743
- Montana 40,152
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2470284 | 2470284 | 2022-05-04 | Franklin | Alabama | 1059 | 9898 | 139 |
2470285 | 2470285 | 2022-05-04 | Geneva | Alabama | 1061 | 6482 | 164 |
2470286 | 2470286 | 2022-05-04 | Greene | Alabama | 1063 | 1875 | 49 |
2470287 | 2470287 | 2022-05-04 | Hale | Alabama | 1065 | 4732 | 106 |
2470288 | 2470288 | 2022-05-04 | Henry | Alabama | 1067 | 4572 | 76 |
2470289 | 2470289 | 2022-05-04 | Houston | Alabama | 1069 | 25733 | 506 |
2470290 | 2470290 | 2022-05-04 | Jackson | Alabama | 1071 | 15040 | 241 |
2470291 | 2470291 | 2022-05-04 | Jefferson | Alabama | 1073 | 185389 | 2369 |
2470292 | 2470292 | 2022-05-04 | Lamar | Alabama | 1075 | 3734 | 65 |
2470293 | 2470293 | 2022-05-04 | Lauderdale | Alabama | 1077 | 24151 | 396 |
2470294 | 2470294 | 2022-05-04 | Lawrence | Alabama | 1079 | 7673 | 158 |
2470295 | 2470295 | 2022-05-04 | Lee | Alabama | 1081 | 37789 | 340 |
2470296 | 2470296 | 2022-05-04 | Limestone | Alabama | 1083 | 24989 | 292 |
2470297 | 2470297 | 2022-05-04 | Lowndes | Alabama | 1085 | 2621 | 77 |
2470298 | 2470298 | 2022-05-04 | Macon | Alabama | 1087 | 3874 | 84 |
2470299 | 2470299 | 2022-05-04 | Madison | Alabama | 1089 | 89974 | 963 |
2470300 | 2470300 | 2022-05-04 | Marengo | Alabama | 1091 | 5190 | 108 |
2470301 | 2470301 | 2022-05-04 | Marion | Alabama | 1093 | 8136 | 152 |
2470302 | 2470302 | 2022-05-04 | Marshall | Alabama | 1095 | 27396 | 393 |
2470303 | 2470303 | 2022-05-04 | Mobile | Alabama | 1097 | 113166 | 1650 |
2470304 | 2470304 | 2022-05-04 | Monroe | Alabama | 1099 | 5275 | 80 |
2470305 | 2470305 | 2022-05-04 | Montgomery | Alabama | 1101 | 55146 | 948 |
2470306 | 2470306 | 2022-05-04 | Morgan | Alabama | 1103 | 36105 | 516 |
2470307 | 2470307 | 2022-05-04 | Perry | Alabama | 1105 | 2095 | 46 |
2470308 | 2470308 | 2022-05-04 | Pickens | Alabama | 1107 | 5262 | 102 |
2470309 | 2470309 | 2022-05-04 | Pike | Alabama | 1109 | 7580 | 134 |
2470310 | 2470310 | 2022-05-04 | Randolph | Alabama | 1111 | 5085 | 74 |
2470311 | 2470311 | 2022-05-04 | Russell | Alabama | 1113 | 10089 | 93 |
2470312 | 2470312 | 2022-05-04 | Shelby | Alabama | 1117 | 61067 | 451 |
2470313 | 2470313 | 2022-05-04 | St. Clair | Alabama | 1115 | 25336 | 416 |
2470314 | 2470314 | 2022-05-04 | Sumter | Alabama | 1119 | 2587 | 51 |
2470315 | 2470315 | 2022-05-04 | Talladega | Alabama | 1121 | 22348 | 376 |
2470316 | 2470316 | 2022-05-04 | Tallapoosa | Alabama | 1123 | 11426 | 234 |
2470317 | 2470317 | 2022-05-04 | Tuscaloosa | Alabama | 1125 | 56182 | 785 |
2470318 | 2470318 | 2022-05-04 | Walker | Alabama | 1127 | 18743 | 445 |
2470319 | 2470319 | 2022-05-04 | Washington | Alabama | 1129 | 3730 | 59 |
2470320 | 2470320 | 2022-05-04 | Wilcox | Alabama | 1131 | 2889 | 46 |
2470321 | 2470321 | 2022-05-04 | Winston | Alabama | 1133 | 7569 | 131 |
2470322 | 2470322 | 2022-05-04 | Aleutians East Borough | Alaska | 2013 | 1099 | 3 |
2470323 | 2470323 | 2022-05-04 | Aleutians West Census Area | Alaska | 2016 | 1683 | 1 |
2470324 | 2470324 | 2022-05-04 | Anchorage | Alaska | 2020 | 104774 | 521 |
2470325 | 2470325 | 2022-05-04 | Bethel Census Area | Alaska | 2050 | 10295 | 41 |
2470326 | 2470326 | 2022-05-04 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 866 | 1 |
2470327 | 2470327 | 2022-05-04 | Denali Borough | Alaska | 2068 | 415 | 1 |
2470328 | 2470328 | 2022-05-04 | Dillingham Census Area | Alaska | 2070 | 1929 | 11 |
2470329 | 2470329 | 2022-05-04 | Fairbanks North Star Borough | Alaska | 2090 | 27635 | 140 |
2470330 | 2470330 | 2022-05-04 | Haines Borough | Alaska | 2100 | 619 | 1 |
2470331 | 2470331 | 2022-05-04 | Juneau City and Borough | Alaska | 2110 | 8622 | 19 |
2470332 | 2470332 | 2022-05-04 | Kenai Peninsula Borough | Alaska | 2122 | 18007 | 100 |
2470333 | 2470333 | 2022-05-04 | Ketchikan Gateway Borough | Alaska | 2130 | 4091 | 17 |
2470334 | 2470334 | 2022-05-04 | Kodiak Island Borough | Alaska | 2150 | 4983 | 12 |
2470335 | 2470335 | 2022-05-04 | Kusilvak Census Area | Alaska | 2158 | 4073 | 12 |
2470336 | 2470336 | 2022-05-04 | Matanuska-Susitna Borough | Alaska | 2170 | 34817 | 232 |
2470337 | 2470337 | 2022-05-04 | Nome Census Area | Alaska | 2180 | 6235 | 5 |
2470338 | 2470338 | 2022-05-04 | North Slope Borough | Alaska | 2185 | 4464 | 11 |
2470339 | 2470339 | 2022-05-04 | Northwest Arctic Borough | Alaska | 2188 | 4805 | 13 |
2470340 | 2470340 | 2022-05-04 | Petersburg Borough | Alaska | 2195 | 777 | 4 |
2470341 | 2470341 | 2022-05-04 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 1444 | 8 |
2470342 | 2470342 | 2022-05-04 | Sitka City and Borough | Alaska | 2220 | 2607 | 5 |
2470343 | 2470343 | 2022-05-04 | Skagway Municipality | Alaska | 2230 | 169 | 0 |
2470344 | 2470344 | 2022-05-04 | Southeast Fairbanks Census Area | Alaska | 2240 | 2046 | 20 |
2470345 | 2470345 | 2022-05-04 | Unknown | Alaska | 914 | 1 | |
2470346 | 2470346 | 2022-05-04 | Valdez-Cordova Census Area | Alaska | 2261 | 2925 | 18 |
2470347 | 2470347 | 2022-05-04 | Wrangell City and Borough | Alaska | 2275 | 569 | 1 |
2470348 | 2470348 | 2022-05-04 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 549 | 5 |
2470349 | 2470349 | 2022-05-04 | Yukon-Koyukuk Census Area | Alaska | 2290 | 1435 | 10 |
2470350 | 2470350 | 2022-05-04 | Unknown | American Samoa | 5793 | 26 | |
2470351 | 2470351 | 2022-05-04 | Apache | Arizona | 4001 | 22508 | 612 |
2470352 | 2470352 | 2022-05-04 | Cochise | Arizona | 4003 | 31538 | 573 |
2470353 | 2470353 | 2022-05-04 | Coconino | Arizona | 4005 | 43931 | 478 |
2470354 | 2470354 | 2022-05-04 | Gila | Arizona | 4007 | 17341 | 381 |
2470355 | 2470355 | 2022-05-04 | Graham | Arizona | 4009 | 12001 | 177 |
2470356 | 2470356 | 2022-05-04 | Greenlee | Arizona | 4011 | 2218 | 33 |
2470357 | 2470357 | 2022-05-04 | La Paz | Arizona | 4012 | 5211 | 144 |
2470358 | 2470358 | 2022-05-04 | Maricopa | Arizona | 4013 | 1279872 | 17305 |
2470359 | 2470359 | 2022-05-04 | Mohave | Arizona | 4015 | 57505 | 1450 |
2470360 | 2470360 | 2022-05-04 | Navajo | Arizona | 4017 | 38331 | 908 |
2470361 | 2470361 | 2022-05-04 | Pima | Arizona | 4019 | 254912 | 3843 |
2470362 | 2470362 | 2022-05-04 | Pinal | Arizona | 4021 | 132530 | 1665 |
2470363 | 2470363 | 2022-05-04 | Santa Cruz | Arizona | 4023 | 16670 | 232 |
2470364 | 2470364 | 2022-05-04 | Yavapai | Arizona | 4025 | 48151 | 1208 |
2470365 | 2470365 | 2022-05-04 | Yuma | Arizona | 4027 | 62716 | 1180 |
2470366 | 2470366 | 2022-05-04 | Arkansas | Arkansas | 5001 | 5686 | 79 |
2470367 | 2470367 | 2022-05-04 | Ashley | Arkansas | 5003 | 5114 | 66 |
2470368 | 2470368 | 2022-05-04 | Baxter | Arkansas | 5005 | 8808 | 247 |
2470369 | 2470369 | 2022-05-04 | Benton | Arkansas | 5007 | 66897 | 846 |
2470370 | 2470370 | 2022-05-04 | Boone | Arkansas | 5009 | 9448 | 180 |
2470371 | 2470371 | 2022-05-04 | Bradley | Arkansas | 5011 | 2994 | 49 |
2470372 | 2470372 | 2022-05-04 | Calhoun | Arkansas | 5013 | 965 | 10 |
2470373 | 2470373 | 2022-05-04 | Carroll | Arkansas | 5015 | 6121 | 102 |
2470374 | 2470374 | 2022-05-04 | Chicot | Arkansas | 5017 | 2775 | 60 |
2470375 | 2470375 | 2022-05-04 | Clark | Arkansas | 5019 | 5344 | 79 |
2470376 | 2470376 | 2022-05-04 | Clay | Arkansas | 5021 | 4134 | 93 |
2470377 | 2470377 | 2022-05-04 | Cleburne | Arkansas | 5023 | 6460 | 128 |
2470378 | 2470378 | 2022-05-04 | Cleveland | Arkansas | 5025 | 2264 | 36 |
2470379 | 2470379 | 2022-05-04 | Columbia | Arkansas | 5027 | 5427 | 95 |
2470380 | 2470380 | 2022-05-04 | Conway | Arkansas | 5029 | 5481 | 65 |
2470381 | 2470381 | 2022-05-04 | Craighead | Arkansas | 5031 | 37691 | 329 |
2470382 | 2470382 | 2022-05-04 | Crawford | Arkansas | 5033 | 15852 | 249 |
2470383 | 2470383 | 2022-05-04 | Crittenden | Arkansas | 5035 | 14280 | 226 |
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);