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 81,226
- Georgia 54,169
- Virginia 44,334
- Kentucky 39,532
- Missouri 37,885
- Illinois 33,976
- North Carolina 33,609
- Iowa 32,870
- Kansas 32,797
- Tennessee 32,287
- Indiana 31,222
- Ohio 29,770
- Minnesota 28,987
- Michigan 28,074
- Mississippi 27,846
- Nebraska 27,791
- Oklahoma 25,447
- Arkansas 25,440
- Wisconsin 24,167
- Puerto Rico 23,479
- Florida 23,306
- Pennsylvania 22,827
- Alabama 22,646
- Louisiana 22,173
- Colorado 21,239
- South Dakota 20,380
- New York 20,056
- California 20,049
- West Virginia 17,926
- North Dakota 16,631
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1063295 | 1063295 | 2021-02-25 | Perry | Alabama | 1105 | 1053 | 27 |
1063296 | 1063296 | 2021-02-25 | Pickens | Alabama | 1107 | 2239 | 54 |
1063297 | 1063297 | 2021-02-25 | Pike | Alabama | 1109 | 2930 | 71 |
1063298 | 1063298 | 2021-02-25 | Randolph | Alabama | 1111 | 1631 | 40 |
1063299 | 1063299 | 2021-02-25 | Russell | Alabama | 1113 | 4018 | 31 |
1063300 | 1063300 | 2021-02-25 | Shelby | Alabama | 1117 | 21820 | 215 |
1063301 | 1063301 | 2021-02-25 | St. Clair | Alabama | 1115 | 8783 | 220 |
1063302 | 1063302 | 2021-02-25 | Sumter | Alabama | 1119 | 984 | 31 |
1063303 | 1063303 | 2021-02-25 | Talladega | Alabama | 1121 | 7481 | 163 |
1063304 | 1063304 | 2021-02-25 | Tallapoosa | Alabama | 1123 | 3572 | 141 |
1063305 | 1063305 | 2021-02-25 | Tuscaloosa | Alabama | 1125 | 23996 | 409 |
1063306 | 1063306 | 2021-02-25 | Walker | Alabama | 1127 | 6504 | 251 |
1063307 | 1063307 | 2021-02-25 | Washington | Alabama | 1129 | 1566 | 34 |
1063308 | 1063308 | 2021-02-25 | Wilcox | Alabama | 1131 | 1208 | 25 |
1063309 | 1063309 | 2021-02-25 | Winston | Alabama | 1133 | 2461 | 66 |
1063310 | 1063310 | 2021-02-25 | Aleutians East Borough | Alaska | 2013 | 358 | 1 |
1063311 | 1063311 | 2021-02-25 | Aleutians West Census Area | Alaska | 2016 | 552 | 0 |
1063312 | 1063312 | 2021-02-25 | Anchorage | Alaska | 2020 | 26382 | 152 |
1063313 | 1063313 | 2021-02-25 | Bethel Census Area | Alaska | 2050 | 3556 | 18 |
1063314 | 1063314 | 2021-02-25 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 176 | 0 |
1063315 | 1063315 | 2021-02-25 | Denali Borough | Alaska | 2068 | 71 | 0 |
1063316 | 1063316 | 2021-02-25 | Dillingham Census Area | Alaska | 2070 | 202 | 1 |
1063317 | 1063317 | 2021-02-25 | Fairbanks North Star Borough | Alaska | 2090 | 6163 | 26 |
1063318 | 1063318 | 2021-02-25 | Haines Borough | Alaska | 2100 | 24 | 0 |
1063319 | 1063319 | 2021-02-25 | Juneau City and Borough | Alaska | 2110 | 1214 | 3 |
1063320 | 1063320 | 2021-02-25 | Kenai Peninsula Borough | Alaska | 2122 | 3958 | 19 |
1063321 | 1063321 | 2021-02-25 | Ketchikan Gateway Borough | Alaska | 2130 | 349 | 2 |
1063322 | 1063322 | 2021-02-25 | Kodiak Island Borough | Alaska | 2150 | 1052 | 5 |
1063323 | 1063323 | 2021-02-25 | Kusilvak Census Area | Alaska | 2158 | 1196 | 3 |
1063324 | 1063324 | 2021-02-25 | Matanuska-Susitna Borough | Alaska | 2170 | 8495 | 33 |
1063325 | 1063325 | 2021-02-25 | Nome Census Area | Alaska | 2180 | 324 | 0 |
1063326 | 1063326 | 2021-02-25 | North Slope Borough | Alaska | 2185 | 1000 | 4 |
1063327 | 1063327 | 2021-02-25 | Northwest Arctic Borough | Alaska | 2188 | 586 | 1 |
1063328 | 1063328 | 2021-02-25 | Petersburg Borough | Alaska | 2195 | 78 | 0 |
1063329 | 1063329 | 2021-02-25 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 71 | 1 |
1063330 | 1063330 | 2021-02-25 | Sitka City and Borough | Alaska | 2220 | 305 | 0 |
1063331 | 1063331 | 2021-02-25 | Skagway Municipality | Alaska | 2230 | 19 | 0 |
1063332 | 1063332 | 2021-02-25 | Southeast Fairbanks Census Area | Alaska | 2240 | 445 | 3 |
1063333 | 1063333 | 2021-02-25 | Unknown | Alaska | 258 | 0 | |
1063334 | 1063334 | 2021-02-25 | Valdez-Cordova Census Area | Alaska | 2261 | 477 | 2 |
1063335 | 1063335 | 2021-02-25 | Wrangell City and Borough | Alaska | 2275 | 26 | 0 |
1063336 | 1063336 | 2021-02-25 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 65 | 1 |
1063337 | 1063337 | 2021-02-25 | Yukon-Koyukuk Census Area | Alaska | 2290 | 333 | 4 |
1063338 | 1063338 | 2021-02-25 | Apache | Arizona | 4001 | 10391 | 380 |
1063339 | 1063339 | 2021-02-25 | Cochise | Arizona | 4003 | 11128 | 264 |
1063340 | 1063340 | 2021-02-25 | Coconino | Arizona | 4005 | 16385 | 309 |
1063341 | 1063341 | 2021-02-25 | Gila | Arizona | 4007 | 6387 | 211 |
1063342 | 1063342 | 2021-02-25 | Graham | Arizona | 4009 | 5280 | 72 |
1063343 | 1063343 | 2021-02-25 | Greenlee | Arizona | 4011 | 558 | 10 |
1063344 | 1063344 | 2021-02-25 | La Paz | Arizona | 4012 | 2390 | 71 |
1063345 | 1063345 | 2021-02-25 | Maricopa | Arizona | 4013 | 508456 | 9005 |
1063346 | 1063346 | 2021-02-25 | Mohave | Arizona | 4015 | 21050 | 641 |
1063347 | 1063347 | 2021-02-25 | Navajo | Arizona | 4017 | 15525 | 488 |
1063348 | 1063348 | 2021-02-25 | Pima | Arizona | 4019 | 108952 | 2202 |
1063349 | 1063349 | 2021-02-25 | Pinal | Arizona | 4021 | 45925 | 763 |
1063350 | 1063350 | 2021-02-25 | Santa Cruz | Arizona | 4023 | 7620 | 167 |
1063351 | 1063351 | 2021-02-25 | Yavapai | Arizona | 4025 | 17476 | 457 |
1063352 | 1063352 | 2021-02-25 | Yuma | Arizona | 4027 | 36375 | 781 |
1063353 | 1063353 | 2021-02-25 | Arkansas | Arkansas | 5001 | 1967 | 38 |
1063354 | 1063354 | 2021-02-25 | Ashley | Arkansas | 5003 | 1767 | 33 |
1063355 | 1063355 | 2021-02-25 | Baxter | Arkansas | 5005 | 2813 | 94 |
1063356 | 1063356 | 2021-02-25 | Benton | Arkansas | 5007 | 27042 | 385 |
1063357 | 1063357 | 2021-02-25 | Boone | Arkansas | 5009 | 3620 | 79 |
1063358 | 1063358 | 2021-02-25 | Bradley | Arkansas | 5011 | 1322 | 31 |
1063359 | 1063359 | 2021-02-25 | Calhoun | Arkansas | 5013 | 391 | 3 |
1063360 | 1063360 | 2021-02-25 | Carroll | Arkansas | 5015 | 2714 | 41 |
1063361 | 1063361 | 2021-02-25 | Chicot | Arkansas | 5017 | 1585 | 40 |
1063362 | 1063362 | 2021-02-25 | Clark | Arkansas | 5019 | 2021 | 37 |
1063363 | 1063363 | 2021-02-25 | Clay | Arkansas | 5021 | 1676 | 46 |
1063364 | 1063364 | 2021-02-25 | Cleburne | Arkansas | 5023 | 1872 | 67 |
1063365 | 1063365 | 2021-02-25 | Cleveland | Arkansas | 5025 | 914 | 23 |
1063366 | 1063366 | 2021-02-25 | Columbia | Arkansas | 5027 | 2132 | 54 |
1063367 | 1063367 | 2021-02-25 | Conway | Arkansas | 5029 | 2144 | 31 |
1063368 | 1063368 | 2021-02-25 | Craighead | Arkansas | 5031 | 12738 | 177 |
1063369 | 1063369 | 2021-02-25 | Crawford | Arkansas | 5033 | 6735 | 107 |
1063370 | 1063370 | 2021-02-25 | Crittenden | Arkansas | 5035 | 5666 | 94 |
1063371 | 1063371 | 2021-02-25 | Cross | Arkansas | 5037 | 1898 | 48 |
1063372 | 1063372 | 2021-02-25 | Dallas | Arkansas | 5039 | 719 | 12 |
1063373 | 1063373 | 2021-02-25 | Desha | Arkansas | 5041 | 1326 | 21 |
1063374 | 1063374 | 2021-02-25 | Drew | Arkansas | 5043 | 1949 | 35 |
1063375 | 1063375 | 2021-02-25 | Faulkner | Arkansas | 5045 | 11666 | 154 |
1063376 | 1063376 | 2021-02-25 | Franklin | Arkansas | 5047 | 1624 | 34 |
1063377 | 1063377 | 2021-02-25 | Fulton | Arkansas | 5049 | 1074 | 47 |
1063378 | 1063378 | 2021-02-25 | Garland | Arkansas | 5051 | 9627 | 232 |
1063379 | 1063379 | 2021-02-25 | Grant | Arkansas | 5053 | 1555 | 32 |
1063380 | 1063380 | 2021-02-25 | Greene | Arkansas | 5055 | 5800 | 75 |
1063381 | 1063381 | 2021-02-25 | Hempstead | Arkansas | 5057 | 1817 | 18 |
1063382 | 1063382 | 2021-02-25 | Hot Spring | Arkansas | 5059 | 4782 | 68 |
1063383 | 1063383 | 2021-02-25 | Howard | Arkansas | 5061 | 1528 | 24 |
1063384 | 1063384 | 2021-02-25 | Independence | Arkansas | 5063 | 3656 | 120 |
1063385 | 1063385 | 2021-02-25 | Izard | Arkansas | 5065 | 1652 | 40 |
1063386 | 1063386 | 2021-02-25 | Jackson | Arkansas | 5067 | 3133 | 33 |
1063387 | 1063387 | 2021-02-25 | Jefferson | Arkansas | 5069 | 8578 | 165 |
1063388 | 1063388 | 2021-02-25 | Johnson | Arkansas | 5071 | 2724 | 31 |
1063389 | 1063389 | 2021-02-25 | Lafayette | Arkansas | 5073 | 502 | 7 |
1063390 | 1063390 | 2021-02-25 | Lawrence | Arkansas | 5075 | 2008 | 41 |
1063391 | 1063391 | 2021-02-25 | Lee | Arkansas | 5077 | 1636 | 35 |
1063392 | 1063392 | 2021-02-25 | Lincoln | Arkansas | 5079 | 3153 | 43 |
1063393 | 1063393 | 2021-02-25 | Little River | Arkansas | 5081 | 1126 | 40 |
1063394 | 1063394 | 2021-02-25 | Logan | Arkansas | 5083 | 2168 | 18 |
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);