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,482
- Georgia 123,449
- Virginia 102,064
- Kentucky 91,612
- Missouri 88,664
- Illinois 78,575
- Kansas 78,446
- North Carolina 77,009
- Iowa 76,206
- Tennessee 73,951
- Indiana 71,084
- Nebraska 68,503
- Ohio 68,389
- Minnesota 67,179
- Michigan 64,530
- Mississippi 63,484
- Oklahoma 59,299
- Arkansas 58,348
- Puerto Rico 57,765
- Wisconsin 55,417
- Florida 52,750
- Pennsylvania 51,905
- Alabama 51,709
- Louisiana 50,382
- South Dakota 49,024
- Colorado 48,951
- New York 45,228
- California 45,171
- West Virginia 41,798
- Montana 40,208
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2474374 | 2474374 | 2022-05-05 | Mills | Iowa | 19129 | 3363 | 41 |
2474375 | 2474375 | 2022-05-05 | Mitchell | Iowa | 19131 | 2508 | 49 |
2474376 | 2474376 | 2022-05-05 | Monona | Iowa | 19133 | 1720 | 48 |
2474377 | 2474377 | 2022-05-05 | Monroe | Iowa | 19135 | 1882 | 49 |
2474378 | 2474378 | 2022-05-05 | Montgomery | Iowa | 19137 | 2212 | 55 |
2474379 | 2474379 | 2022-05-05 | Muscatine | Iowa | 19139 | 9665 | 130 |
2474380 | 2474380 | 2022-05-05 | O'Brien | Iowa | 19141 | 3452 | 71 |
2474381 | 2474381 | 2022-05-05 | Osceola | Iowa | 19143 | 1394 | 22 |
2474382 | 2474382 | 2022-05-05 | Page | Iowa | 19145 | 3337 | 45 |
2474383 | 2474383 | 2022-05-05 | Palo Alto | Iowa | 19147 | 2046 | 38 |
2474384 | 2474384 | 2022-05-05 | Plymouth | Iowa | 19149 | 6325 | 100 |
2474385 | 2474385 | 2022-05-05 | Pocahontas | Iowa | 19151 | 1607 | 27 |
2474386 | 2474386 | 2022-05-05 | Polk | Iowa | 19153 | 125671 | 1102 |
2474387 | 2474387 | 2022-05-05 | Pottawattamie | Iowa | 19155 | 24347 | 317 |
2474388 | 2474388 | 2022-05-05 | Poweshiek | Iowa | 19157 | 3679 | 61 |
2474389 | 2474389 | 2022-05-05 | Ringgold | Iowa | 19159 | 1133 | 34 |
2474390 | 2474390 | 2022-05-05 | Sac | Iowa | 19161 | 2408 | 33 |
2474391 | 2474391 | 2022-05-05 | Scott | Iowa | 19163 | 41281 | 395 |
2474392 | 2474392 | 2022-05-05 | Shelby | Iowa | 19165 | 2722 | 50 |
2474393 | 2474393 | 2022-05-05 | Sioux | Iowa | 19167 | 7982 | 86 |
2474394 | 2474394 | 2022-05-05 | Story | Iowa | 19169 | 19896 | 90 |
2474395 | 2474395 | 2022-05-05 | Tama | Iowa | 19171 | 3911 | 90 |
2474396 | 2474396 | 2022-05-05 | Taylor | Iowa | 19173 | 1315 | 22 |
2474397 | 2474397 | 2022-05-05 | Union | Iowa | 19175 | 2717 | 51 |
2474398 | 2474398 | 2022-05-05 | Unknown | Iowa | 306 | 0 | |
2474399 | 2474399 | 2022-05-05 | Van Buren | Iowa | 19177 | 1381 | 27 |
2474400 | 2474400 | 2022-05-05 | Wapello | Iowa | 19179 | 8986 | 203 |
2474401 | 2474401 | 2022-05-05 | Warren | Iowa | 19181 | 12547 | 134 |
2474402 | 2474402 | 2022-05-05 | Washington | Iowa | 19183 | 5665 | 79 |
2474403 | 2474403 | 2022-05-05 | Wayne | Iowa | 19185 | 1269 | 33 |
2474404 | 2474404 | 2022-05-05 | Webster | Iowa | 19187 | 10363 | 164 |
2474405 | 2474405 | 2022-05-05 | Winnebago | Iowa | 19189 | 2974 | 47 |
2474406 | 2474406 | 2022-05-05 | Winneshiek | Iowa | 19191 | 3879 | 50 |
2474407 | 2474407 | 2022-05-05 | Woodbury | Iowa | 19193 | 28830 | 339 |
2474408 | 2474408 | 2022-05-05 | Worth | Iowa | 19195 | 1775 | 17 |
2474409 | 2474409 | 2022-05-05 | Wright | Iowa | 19197 | 3614 | 63 |
2474410 | 2474410 | 2022-05-05 | Allen | Kansas | 20001 | 3966 | 53 |
2474411 | 2474411 | 2022-05-05 | Anderson | Kansas | 20003 | 2123 | 29 |
2474412 | 2474412 | 2022-05-05 | Atchison | Kansas | 20005 | 4297 | 34 |
2474413 | 2474413 | 2022-05-05 | Barber | Kansas | 20007 | 1041 | 8 |
2474414 | 2474414 | 2022-05-05 | Barton | Kansas | 20009 | 6496 | 96 |
2474415 | 2474415 | 2022-05-05 | Bourbon | Kansas | 20011 | 4385 | 52 |
2474416 | 2474416 | 2022-05-05 | Brown | Kansas | 20013 | 2687 | 46 |
2474417 | 2474417 | 2022-05-05 | Butler | Kansas | 20015 | 19033 | 189 |
2474418 | 2474418 | 2022-05-05 | Chase | Kansas | 20017 | 673 | 7 |
2474419 | 2474419 | 2022-05-05 | Chautauqua | Kansas | 20019 | 844 | 17 |
2474420 | 2474420 | 2022-05-05 | Cherokee | Kansas | 20021 | 6149 | 84 |
2474421 | 2474421 | 2022-05-05 | Cheyenne | Kansas | 20023 | 652 | 14 |
2474422 | 2474422 | 2022-05-05 | Clark | Kansas | 20025 | 504 | 8 |
2474423 | 2474423 | 2022-05-05 | Clay | Kansas | 20027 | 1975 | 35 |
2474424 | 2474424 | 2022-05-05 | Cloud | Kansas | 20029 | 2219 | 36 |
2474425 | 2474425 | 2022-05-05 | Coffey | Kansas | 20031 | 2424 | 42 |
2474426 | 2474426 | 2022-05-05 | Comanche | Kansas | 20033 | 439 | 16 |
2474427 | 2474427 | 2022-05-05 | Cowley | Kansas | 20035 | 10147 | 152 |
2474428 | 2474428 | 2022-05-05 | Crawford | Kansas | 20037 | 11915 | 130 |
2474429 | 2474429 | 2022-05-05 | Decatur | Kansas | 20039 | 616 | 20 |
2474430 | 2474430 | 2022-05-05 | Dickinson | Kansas | 20041 | 4805 | 78 |
2474431 | 2474431 | 2022-05-05 | Doniphan | Kansas | 20043 | 2447 | 34 |
2474432 | 2474432 | 2022-05-05 | Douglas | Kansas | 20045 | 27058 | 138 |
2474433 | 2474433 | 2022-05-05 | Edwards | Kansas | 20047 | 556 | 13 |
2474434 | 2474434 | 2022-05-05 | Elk | Kansas | 20049 | 570 | 10 |
2474435 | 2474435 | 2022-05-05 | Ellis | Kansas | 20051 | 7143 | 84 |
2474436 | 2474436 | 2022-05-05 | Ellsworth | Kansas | 20053 | 2014 | 32 |
2474437 | 2474437 | 2022-05-05 | Finney | Kansas | 20055 | 11540 | 115 |
2474438 | 2474438 | 2022-05-05 | Ford | Kansas | 20057 | 10621 | 113 |
2474439 | 2474439 | 2022-05-05 | Franklin | Kansas | 20059 | 6979 | 81 |
2474440 | 2474440 | 2022-05-05 | Geary | Kansas | 20061 | 9234 | 75 |
2474441 | 2474441 | 2022-05-05 | Gove | Kansas | 20063 | 786 | 23 |
2474442 | 2474442 | 2022-05-05 | Graham | Kansas | 20065 | 565 | 15 |
2474443 | 2474443 | 2022-05-05 | Grant | Kansas | 20067 | 2263 | 36 |
2474444 | 2474444 | 2022-05-05 | Gray | Kansas | 20069 | 1233 | 23 |
2474445 | 2474445 | 2022-05-05 | Greeley | Kansas | 20071 | 331 | 3 |
2474446 | 2474446 | 2022-05-05 | Greenwood | Kansas | 20073 | 1795 | 23 |
2474447 | 2474447 | 2022-05-05 | Hamilton | Kansas | 20075 | 464 | 3 |
2474448 | 2474448 | 2022-05-05 | Harper | Kansas | 20077 | 1651 | 27 |
2474449 | 2474449 | 2022-05-05 | Harvey | Kansas | 20079 | 9609 | 124 |
2474450 | 2474450 | 2022-05-05 | Haskell | Kansas | 20081 | 962 | 11 |
2474451 | 2474451 | 2022-05-05 | Hodgeman | Kansas | 20083 | 411 | 10 |
2474452 | 2474452 | 2022-05-05 | Jackson | Kansas | 20085 | 3898 | 29 |
2474453 | 2474453 | 2022-05-05 | Jefferson | Kansas | 20087 | 4814 | 63 |
2474454 | 2474454 | 2022-05-05 | Jewell | Kansas | 20089 | 786 | 13 |
2474455 | 2474455 | 2022-05-05 | Johnson | Kansas | 20091 | 146955 | 1215 |
2474456 | 2474456 | 2022-05-05 | Kearny | Kansas | 20093 | 1236 | 20 |
2474457 | 2474457 | 2022-05-05 | Kingman | Kansas | 20095 | 1962 | 28 |
2474458 | 2474458 | 2022-05-05 | Kiowa | Kansas | 20097 | 666 | 7 |
2474459 | 2474459 | 2022-05-05 | Labette | Kansas | 20099 | 6615 | 74 |
2474460 | 2474460 | 2022-05-05 | Lane | Kansas | 20101 | 295 | 12 |
2474461 | 2474461 | 2022-05-05 | Leavenworth | Kansas | 20103 | 19463 | 183 |
2474462 | 2474462 | 2022-05-05 | Lincoln | Kansas | 20105 | 623 | 10 |
2474463 | 2474463 | 2022-05-05 | Linn | Kansas | 20107 | 2823 | 28 |
2474464 | 2474464 | 2022-05-05 | Logan | Kansas | 20109 | 843 | 13 |
2474465 | 2474465 | 2022-05-05 | Lyon | Kansas | 20111 | 9980 | 122 |
2474466 | 2474466 | 2022-05-05 | Marion | Kansas | 20115 | 3333 | 43 |
2474467 | 2474467 | 2022-05-05 | Marshall | Kansas | 20117 | 2557 | 42 |
2474468 | 2474468 | 2022-05-05 | McPherson | Kansas | 20113 | 7944 | 126 |
2474469 | 2474469 | 2022-05-05 | Meade | Kansas | 20119 | 1220 | 20 |
2474470 | 2474470 | 2022-05-05 | Miami | Kansas | 20121 | 7813 | 93 |
2474471 | 2474471 | 2022-05-05 | Mitchell | Kansas | 20123 | 1426 | 22 |
2474472 | 2474472 | 2022-05-05 | Montgomery | Kansas | 20125 | 9428 | 154 |
2474473 | 2474473 | 2022-05-05 | Morris | Kansas | 20127 | 1508 | 28 |
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);