ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
8,775 rows where deaths = 59 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 783
- Georgia 630
- Kentucky 474
- Illinois 422
- Virginia 400
- Minnesota 372
- Indiana 350
- Mississippi 343
- Iowa 333
- Arkansas 319
- Alabama 317
- Ohio 314
- Tennessee 277
- Missouri 275
- Kansas 246
- Michigan 246
- New York 231
- Louisiana 219
- Wisconsin 212
- North Carolina 203
- Florida 156
- Oklahoma 151
- South Carolina 144
- South Dakota 136
- West Virginia 121
- New Mexico 119
- Oregon 111
- California 89
- Virgin Islands 79
- Pennsylvania 75
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499639 | 2499639 | 2022-05-13 | Washington | Alabama | 1129 | 3736 | 59 |
2499724 | 2499724 | 2022-05-13 | Lee | Arkansas | 5077 | 2912 | 59 |
2500274 | 2500274 | 2022-05-13 | White | Illinois | 17193 | 4413 | 59 |
2500587 | 2500587 | 2022-05-13 | Bourbon | Kentucky | 21017 | 6002 | 59 |
2500613 | 2500613 | 2022-05-13 | Fleming | Kentucky | 21069 | 3928 | 59 |
2500680 | 2500680 | 2022-05-13 | Rockcastle | Kentucky | 21203 | 5059 | 59 |
2500686 | 2500686 | 2022-05-13 | Spencer | Kentucky | 21215 | 5384 | 59 |
2500731 | 2500731 | 2022-05-13 | Madison | Louisiana | 22065 | 3264 | 59 |
2500933 | 2500933 | 2022-05-13 | Hubbard | Minnesota | 27057 | 5010 | 59 |
2501013 | 2501013 | 2022-05-13 | Greene | Mississippi | 28041 | 3198 | 59 |
2501144 | 2501144 | 2022-05-13 | Mississippi | Missouri | 29133 | 3521 | 59 |
2502109 | 2502109 | 2022-05-13 | Yankton | South Dakota | 46135 | 5929 | 59 |
2502191 | 2502191 | 2022-05-13 | Stewart | Tennessee | 47161 | 3294 | 59 |
2502326 | 2502326 | 2022-05-13 | Jackson | Texas | 48239 | 3258 | 59 |
2502397 | 2502397 | 2022-05-13 | Rains | Texas | 48379 | 1839 | 59 |
2502509 | 2502509 | 2022-05-13 | St. Thomas | Virgin Islands | 78030 | 8643 | 59 |
2502607 | 2502607 | 2022-05-13 | Powhatan | Virginia | 51145 | 5257 | 59 |
2502768 | 2502768 | 2022-05-13 | Kewaunee | Wisconsin | 55061 | 5927 | 59 |
2496381 | 2496381 | 2022-05-12 | Washington | Alabama | 1129 | 3735 | 59 |
2496466 | 2496466 | 2022-05-12 | Lee | Arkansas | 5077 | 2912 | 59 |
2497016 | 2497016 | 2022-05-12 | White | Illinois | 17193 | 4413 | 59 |
2497329 | 2497329 | 2022-05-12 | Bourbon | Kentucky | 21017 | 6002 | 59 |
2497355 | 2497355 | 2022-05-12 | Fleming | Kentucky | 21069 | 3928 | 59 |
2497422 | 2497422 | 2022-05-12 | Rockcastle | Kentucky | 21203 | 5059 | 59 |
2497428 | 2497428 | 2022-05-12 | Spencer | Kentucky | 21215 | 5384 | 59 |
2497473 | 2497473 | 2022-05-12 | Madison | Louisiana | 22065 | 3264 | 59 |
2497675 | 2497675 | 2022-05-12 | Hubbard | Minnesota | 27057 | 4999 | 59 |
2497755 | 2497755 | 2022-05-12 | Greene | Mississippi | 28041 | 3198 | 59 |
2497886 | 2497886 | 2022-05-12 | Mississippi | Missouri | 29133 | 3514 | 59 |
2498851 | 2498851 | 2022-05-12 | Yankton | South Dakota | 46135 | 5929 | 59 |
2498933 | 2498933 | 2022-05-12 | Stewart | Tennessee | 47161 | 3294 | 59 |
2499068 | 2499068 | 2022-05-12 | Jackson | Texas | 48239 | 3258 | 59 |
2499139 | 2499139 | 2022-05-12 | Rains | Texas | 48379 | 1839 | 59 |
2499251 | 2499251 | 2022-05-12 | St. Thomas | Virgin Islands | 78030 | 8532 | 59 |
2499349 | 2499349 | 2022-05-12 | Powhatan | Virginia | 51145 | 5257 | 59 |
2499510 | 2499510 | 2022-05-12 | Kewaunee | Wisconsin | 55061 | 5922 | 59 |
2493123 | 2493123 | 2022-05-11 | Washington | Alabama | 1129 | 3735 | 59 |
2493208 | 2493208 | 2022-05-11 | Lee | Arkansas | 5077 | 2912 | 59 |
2493758 | 2493758 | 2022-05-11 | White | Illinois | 17193 | 4413 | 59 |
2494071 | 2494071 | 2022-05-11 | Bourbon | Kentucky | 21017 | 6002 | 59 |
2494097 | 2494097 | 2022-05-11 | Fleming | Kentucky | 21069 | 3928 | 59 |
2494164 | 2494164 | 2022-05-11 | Rockcastle | Kentucky | 21203 | 5059 | 59 |
2494170 | 2494170 | 2022-05-11 | Spencer | Kentucky | 21215 | 5384 | 59 |
2494215 | 2494215 | 2022-05-11 | Madison | Louisiana | 22065 | 3262 | 59 |
2494417 | 2494417 | 2022-05-11 | Hubbard | Minnesota | 27057 | 4997 | 59 |
2494497 | 2494497 | 2022-05-11 | Greene | Mississippi | 28041 | 3198 | 59 |
2494628 | 2494628 | 2022-05-11 | Mississippi | Missouri | 29133 | 3514 | 59 |
2495593 | 2495593 | 2022-05-11 | Yankton | South Dakota | 46135 | 5929 | 59 |
2495675 | 2495675 | 2022-05-11 | Stewart | Tennessee | 47161 | 3294 | 59 |
2495810 | 2495810 | 2022-05-11 | Jackson | Texas | 48239 | 3258 | 59 |
2495881 | 2495881 | 2022-05-11 | Rains | Texas | 48379 | 1839 | 59 |
2495993 | 2495993 | 2022-05-11 | St. Thomas | Virgin Islands | 78030 | 8469 | 59 |
2496091 | 2496091 | 2022-05-11 | Powhatan | Virginia | 51145 | 5254 | 59 |
2496252 | 2496252 | 2022-05-11 | Kewaunee | Wisconsin | 55061 | 5921 | 59 |
2489865 | 2489865 | 2022-05-10 | Washington | Alabama | 1129 | 3734 | 59 |
2489950 | 2489950 | 2022-05-10 | Lee | Arkansas | 5077 | 2912 | 59 |
2490500 | 2490500 | 2022-05-10 | White | Illinois | 17193 | 4413 | 59 |
2490813 | 2490813 | 2022-05-10 | Bourbon | Kentucky | 21017 | 6002 | 59 |
2490839 | 2490839 | 2022-05-10 | Fleming | Kentucky | 21069 | 3928 | 59 |
2490906 | 2490906 | 2022-05-10 | Rockcastle | Kentucky | 21203 | 5059 | 59 |
2490912 | 2490912 | 2022-05-10 | Spencer | Kentucky | 21215 | 5384 | 59 |
2490957 | 2490957 | 2022-05-10 | Madison | Louisiana | 22065 | 3261 | 59 |
2490993 | 2490993 | 2022-05-10 | Franklin | Maine | 23007 | 5985 | 59 |
2491159 | 2491159 | 2022-05-10 | Hubbard | Minnesota | 27057 | 4990 | 59 |
2491239 | 2491239 | 2022-05-10 | Greene | Mississippi | 28041 | 3198 | 59 |
2491370 | 2491370 | 2022-05-10 | Mississippi | Missouri | 29133 | 3514 | 59 |
2491668 | 2491668 | 2022-05-10 | Essex | New York | 36031 | 6081 | 59 |
2492335 | 2492335 | 2022-05-10 | Yankton | South Dakota | 46135 | 5916 | 59 |
2492417 | 2492417 | 2022-05-10 | Stewart | Tennessee | 47161 | 3289 | 59 |
2492552 | 2492552 | 2022-05-10 | Jackson | Texas | 48239 | 3258 | 59 |
2492623 | 2492623 | 2022-05-10 | Rains | Texas | 48379 | 1839 | 59 |
2492735 | 2492735 | 2022-05-10 | St. Thomas | Virgin Islands | 78030 | 8272 | 59 |
2492833 | 2492833 | 2022-05-10 | Powhatan | Virginia | 51145 | 5245 | 59 |
2492994 | 2492994 | 2022-05-10 | Kewaunee | Wisconsin | 55061 | 5913 | 59 |
2486608 | 2486608 | 2022-05-09 | Washington | Alabama | 1129 | 3733 | 59 |
2486693 | 2486693 | 2022-05-09 | Lee | Arkansas | 5077 | 2912 | 59 |
2487243 | 2487243 | 2022-05-09 | White | Illinois | 17193 | 4412 | 59 |
2487556 | 2487556 | 2022-05-09 | Bourbon | Kentucky | 21017 | 6002 | 59 |
2487582 | 2487582 | 2022-05-09 | Fleming | Kentucky | 21069 | 3928 | 59 |
2487649 | 2487649 | 2022-05-09 | Rockcastle | Kentucky | 21203 | 5059 | 59 |
2487655 | 2487655 | 2022-05-09 | Spencer | Kentucky | 21215 | 5384 | 59 |
2487700 | 2487700 | 2022-05-09 | Madison | Louisiana | 22065 | 3260 | 59 |
2487736 | 2487736 | 2022-05-09 | Franklin | Maine | 23007 | 5978 | 59 |
2487902 | 2487902 | 2022-05-09 | Hubbard | Minnesota | 27057 | 4986 | 59 |
2487982 | 2487982 | 2022-05-09 | Greene | Mississippi | 28041 | 3198 | 59 |
2488112 | 2488112 | 2022-05-09 | Mississippi | Missouri | 29133 | 3514 | 59 |
2488410 | 2488410 | 2022-05-09 | Essex | New York | 36031 | 6072 | 59 |
2489077 | 2489077 | 2022-05-09 | Yankton | South Dakota | 46135 | 5916 | 59 |
2489159 | 2489159 | 2022-05-09 | Stewart | Tennessee | 47161 | 3289 | 59 |
2489294 | 2489294 | 2022-05-09 | Jackson | Texas | 48239 | 3257 | 59 |
2489365 | 2489365 | 2022-05-09 | Rains | Texas | 48379 | 1839 | 59 |
2489477 | 2489477 | 2022-05-09 | St. Thomas | Virgin Islands | 78030 | 8272 | 59 |
2489575 | 2489575 | 2022-05-09 | Powhatan | Virginia | 51145 | 5234 | 59 |
2489736 | 2489736 | 2022-05-09 | Kewaunee | Wisconsin | 55061 | 5908 | 59 |
2483350 | 2483350 | 2022-05-08 | Washington | Alabama | 1129 | 3731 | 59 |
2483435 | 2483435 | 2022-05-08 | Lee | Arkansas | 5077 | 2912 | 59 |
2483985 | 2483985 | 2022-05-08 | White | Illinois | 17193 | 4411 | 59 |
2484391 | 2484391 | 2022-05-08 | Rockcastle | Kentucky | 21203 | 5049 | 59 |
2484397 | 2484397 | 2022-05-08 | Spencer | Kentucky | 21215 | 5365 | 59 |
2484442 | 2484442 | 2022-05-08 | Madison | Louisiana | 22065 | 3259 | 59 |
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);