ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
11,088 rows where deaths = 52 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 872
- Iowa 701
- Georgia 686
- Virginia 488
- Minnesota 477
- Florida 468
- Louisiana 424
- Illinois 399
- Arkansas 392
- Tennessee 373
- Kentucky 346
- Missouri 344
- Michigan 309
- North Carolina 306
- Oklahoma 300
- Mississippi 281
- Ohio 264
- Idaho 250
- Wisconsin 245
- Alabama 239
- South Carolina 224
- Montana 208
- South Dakota 208
- New Mexico 203
- Indiana 199
- New York 199
- Kansas 181
- California 164
- West Virginia 149
- Colorado 145
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499861 | 2499861 | 2022-05-13 | Moffat | Colorado | 8081 | 3062 | 52 |
2499915 | 2499915 | 2022-05-13 | Franklin | Florida | 12037 | 3087 | 52 |
2500148 | 2500148 | 2022-05-13 | Cassia | Idaho | 16031 | 5032 | 52 |
2500157 | 2500157 | 2022-05-13 | Idaho | Idaho | 16049 | 2998 | 52 |
2500227 | 2500227 | 2022-05-13 | Lawrence | Illinois | 17101 | 5489 | 52 |
2500246 | 2500246 | 2022-05-13 | Moultrie | Illinois | 17139 | 4100 | 52 |
2500404 | 2500404 | 2022-05-13 | Emmet | Iowa | 19063 | 2365 | 52 |
2500478 | 2500478 | 2022-05-13 | Bourbon | Kansas | 20011 | 4391 | 52 |
2500605 | 2500605 | 2022-05-13 | Clinton | Kentucky | 21053 | 3674 | 52 |
2500630 | 2500630 | 2022-05-13 | Henry | Kentucky | 21103 | 4836 | 52 |
2500643 | 2500643 | 2022-05-13 | Lee | Kentucky | 21129 | 2951 | 52 |
2500926 | 2500926 | 2022-05-13 | Faribault | Minnesota | 27043 | 3843 | 52 |
2501081 | 2501081 | 2022-05-13 | Barton | Missouri | 29011 | 2859 | 52 |
2501770 | 2501770 | 2022-05-13 | Kiowa | Oklahoma | 40075 | 1965 | 52 |
2502049 | 2502049 | 2022-05-13 | Brookings | South Dakota | 46011 | 8149 | 52 |
2502107 | 2502107 | 2022-05-13 | Union | South Dakota | 46127 | 4026 | 52 |
2502230 | 2502230 | 2022-05-13 | Brooks | Texas | 48047 | 1642 | 52 |
2502391 | 2502391 | 2022-05-13 | Parmer | Texas | 48369 | 2363 | 52 |
2502506 | 2502506 | 2022-05-13 | Windsor | Vermont | 50027 | 9638 | 52 |
2502554 | 2502554 | 2022-05-13 | Franklin city | Virginia | 51620 | 2395 | 52 |
2502637 | 2502637 | 2022-05-13 | Westmoreland | Virginia | 51193 | 3284 | 52 |
2502758 | 2502758 | 2022-05-13 | Forest | Wisconsin | 55041 | 2694 | 52 |
2502813 | 2502813 | 2022-05-13 | Carbon | Wyoming | 56007 | 4627 | 52 |
2496603 | 2496603 | 2022-05-12 | Moffat | Colorado | 8081 | 3062 | 52 |
2496657 | 2496657 | 2022-05-12 | Franklin | Florida | 12037 | 3087 | 52 |
2496890 | 2496890 | 2022-05-12 | Cassia | Idaho | 16031 | 5032 | 52 |
2496899 | 2496899 | 2022-05-12 | Idaho | Idaho | 16049 | 2998 | 52 |
2496969 | 2496969 | 2022-05-12 | Lawrence | Illinois | 17101 | 5487 | 52 |
2496988 | 2496988 | 2022-05-12 | Moultrie | Illinois | 17139 | 4097 | 52 |
2497146 | 2497146 | 2022-05-12 | Emmet | Iowa | 19063 | 2365 | 52 |
2497220 | 2497220 | 2022-05-12 | Bourbon | Kansas | 20011 | 4385 | 52 |
2497347 | 2497347 | 2022-05-12 | Clinton | Kentucky | 21053 | 3674 | 52 |
2497372 | 2497372 | 2022-05-12 | Henry | Kentucky | 21103 | 4836 | 52 |
2497385 | 2497385 | 2022-05-12 | Lee | Kentucky | 21129 | 2951 | 52 |
2497823 | 2497823 | 2022-05-12 | Barton | Missouri | 29011 | 2857 | 52 |
2498512 | 2498512 | 2022-05-12 | Kiowa | Oklahoma | 40075 | 1965 | 52 |
2498791 | 2498791 | 2022-05-12 | Brookings | South Dakota | 46011 | 8149 | 52 |
2498849 | 2498849 | 2022-05-12 | Union | South Dakota | 46127 | 4026 | 52 |
2498972 | 2498972 | 2022-05-12 | Brooks | Texas | 48047 | 1642 | 52 |
2499133 | 2499133 | 2022-05-12 | Parmer | Texas | 48369 | 2363 | 52 |
2499248 | 2499248 | 2022-05-12 | Windsor | Vermont | 50027 | 9619 | 52 |
2499296 | 2499296 | 2022-05-12 | Franklin city | Virginia | 51620 | 2396 | 52 |
2499379 | 2499379 | 2022-05-12 | Westmoreland | Virginia | 51193 | 3278 | 52 |
2499500 | 2499500 | 2022-05-12 | Forest | Wisconsin | 55041 | 2692 | 52 |
2499555 | 2499555 | 2022-05-12 | Carbon | Wyoming | 56007 | 4627 | 52 |
2493345 | 2493345 | 2022-05-11 | Moffat | Colorado | 8081 | 3046 | 52 |
2493399 | 2493399 | 2022-05-11 | Franklin | Florida | 12037 | 3087 | 52 |
2493632 | 2493632 | 2022-05-11 | Cassia | Idaho | 16031 | 5032 | 52 |
2493641 | 2493641 | 2022-05-11 | Idaho | Idaho | 16049 | 2998 | 52 |
2493711 | 2493711 | 2022-05-11 | Lawrence | Illinois | 17101 | 5487 | 52 |
2493730 | 2493730 | 2022-05-11 | Moultrie | Illinois | 17139 | 4096 | 52 |
2493888 | 2493888 | 2022-05-11 | Emmet | Iowa | 19063 | 2365 | 52 |
2493962 | 2493962 | 2022-05-11 | Bourbon | Kansas | 20011 | 4385 | 52 |
2494089 | 2494089 | 2022-05-11 | Clinton | Kentucky | 21053 | 3674 | 52 |
2494114 | 2494114 | 2022-05-11 | Henry | Kentucky | 21103 | 4836 | 52 |
2494127 | 2494127 | 2022-05-11 | Lee | Kentucky | 21129 | 2951 | 52 |
2494565 | 2494565 | 2022-05-11 | Barton | Missouri | 29011 | 2857 | 52 |
2495254 | 2495254 | 2022-05-11 | Kiowa | Oklahoma | 40075 | 1964 | 52 |
2495533 | 2495533 | 2022-05-11 | Brookings | South Dakota | 46011 | 8149 | 52 |
2495591 | 2495591 | 2022-05-11 | Union | South Dakota | 46127 | 4026 | 52 |
2495714 | 2495714 | 2022-05-11 | Brooks | Texas | 48047 | 1642 | 52 |
2495875 | 2495875 | 2022-05-11 | Parmer | Texas | 48369 | 2363 | 52 |
2495990 | 2495990 | 2022-05-11 | Windsor | Vermont | 50027 | 9564 | 52 |
2496038 | 2496038 | 2022-05-11 | Franklin city | Virginia | 51620 | 2398 | 52 |
2496121 | 2496121 | 2022-05-11 | Westmoreland | Virginia | 51193 | 3276 | 52 |
2496242 | 2496242 | 2022-05-11 | Forest | Wisconsin | 55041 | 2688 | 52 |
2496297 | 2496297 | 2022-05-11 | Carbon | Wyoming | 56007 | 4627 | 52 |
2490087 | 2490087 | 2022-05-10 | Moffat | Colorado | 8081 | 3045 | 52 |
2490141 | 2490141 | 2022-05-10 | Franklin | Florida | 12037 | 3087 | 52 |
2490265 | 2490265 | 2022-05-10 | Heard | Georgia | 13149 | 2180 | 52 |
2490349 | 2490349 | 2022-05-10 | Wilkes | Georgia | 13317 | 2246 | 52 |
2490374 | 2490374 | 2022-05-10 | Cassia | Idaho | 16031 | 5033 | 52 |
2490383 | 2490383 | 2022-05-10 | Idaho | Idaho | 16049 | 2994 | 52 |
2490453 | 2490453 | 2022-05-10 | Lawrence | Illinois | 17101 | 5487 | 52 |
2490472 | 2490472 | 2022-05-10 | Moultrie | Illinois | 17139 | 4093 | 52 |
2490630 | 2490630 | 2022-05-10 | Emmet | Iowa | 19063 | 2364 | 52 |
2490704 | 2490704 | 2022-05-10 | Bourbon | Kansas | 20011 | 4385 | 52 |
2490831 | 2490831 | 2022-05-10 | Clinton | Kentucky | 21053 | 3674 | 52 |
2490856 | 2490856 | 2022-05-10 | Henry | Kentucky | 21103 | 4836 | 52 |
2490869 | 2490869 | 2022-05-10 | Lee | Kentucky | 21129 | 2951 | 52 |
2491307 | 2491307 | 2022-05-10 | Barton | Missouri | 29011 | 2857 | 52 |
2491996 | 2491996 | 2022-05-10 | Kiowa | Oklahoma | 40075 | 1964 | 52 |
2492275 | 2492275 | 2022-05-10 | Brookings | South Dakota | 46011 | 8133 | 52 |
2492333 | 2492333 | 2022-05-10 | Union | South Dakota | 46127 | 4012 | 52 |
2492456 | 2492456 | 2022-05-10 | Brooks | Texas | 48047 | 1642 | 52 |
2492617 | 2492617 | 2022-05-10 | Parmer | Texas | 48369 | 2363 | 52 |
2492732 | 2492732 | 2022-05-10 | Windsor | Vermont | 50027 | 9542 | 52 |
2492780 | 2492780 | 2022-05-10 | Franklin city | Virginia | 51620 | 2398 | 52 |
2492863 | 2492863 | 2022-05-10 | Westmoreland | Virginia | 51193 | 3278 | 52 |
2492984 | 2492984 | 2022-05-10 | Forest | Wisconsin | 55041 | 2686 | 52 |
2493039 | 2493039 | 2022-05-10 | Carbon | Wyoming | 56007 | 4627 | 52 |
2486830 | 2486830 | 2022-05-09 | Moffat | Colorado | 8081 | 3045 | 52 |
2486884 | 2486884 | 2022-05-09 | Franklin | Florida | 12037 | 3087 | 52 |
2487008 | 2487008 | 2022-05-09 | Heard | Georgia | 13149 | 2180 | 52 |
2487092 | 2487092 | 2022-05-09 | Wilkes | Georgia | 13317 | 2246 | 52 |
2487117 | 2487117 | 2022-05-09 | Cassia | Idaho | 16031 | 5033 | 52 |
2487126 | 2487126 | 2022-05-09 | Idaho | Idaho | 16049 | 2993 | 52 |
2487196 | 2487196 | 2022-05-09 | Lawrence | Illinois | 17101 | 5494 | 52 |
2487215 | 2487215 | 2022-05-09 | Moultrie | Illinois | 17139 | 4092 | 52 |
2487373 | 2487373 | 2022-05-09 | Emmet | Iowa | 19063 | 2364 | 52 |
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);