ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
6,955 rows where deaths = 78 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 439
- Texas 421
- Virginia 354
- Tennessee 347
- Indiana 338
- Kentucky 319
- Mississippi 306
- Louisiana 304
- Oklahoma 268
- South Dakota 254
- North Carolina 242
- Ohio 236
- Wisconsin 234
- Alabama 221
- Illinois 220
- Michigan 213
- Iowa 206
- Arkansas 195
- Missouri 191
- Kansas 180
- Minnesota 153
- West Virginia 126
- Florida 110
- South Carolina 109
- Pennsylvania 107
- New York 101
- Oregon 99
- Colorado 66
- Wyoming 64
- Arizona 63
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499723 | 2499723 | 2022-05-13 | Lawrence | Arkansas | 5075 | 5324 | 78 |
2499968 | 2499968 | 2022-05-13 | Bacon | Georgia | 13005 | 3692 | 78 |
2500081 | 2500081 | 2022-05-13 | Pulaski | Georgia | 13235 | 2180 | 78 |
2500317 | 2500317 | 2022-05-13 | Jay | Indiana | 18075 | 4866 | 78 |
2500387 | 2500387 | 2022-05-13 | Cass | Iowa | 19029 | 2962 | 78 |
2500493 | 2500493 | 2022-05-13 | Dickinson | Kansas | 20041 | 4815 | 78 |
2500592 | 2500592 | 2022-05-13 | Breckinridge | Kentucky | 21027 | 5170 | 78 |
2500618 | 2500618 | 2022-05-13 | Garrard | Kentucky | 21079 | 4815 | 78 |
2500712 | 2500712 | 2022-05-13 | Claiborne | Louisiana | 22027 | 3280 | 78 |
2501490 | 2501490 | 2022-05-13 | Ashe | North Carolina | 37009 | 6471 | 78 |
2502039 | 2502039 | 2022-05-13 | Saluda | South Carolina | 45081 | 3968 | 78 |
2502253 | 2502253 | 2022-05-13 | Comanche | Texas | 48093 | 3698 | 78 |
2502557 | 2502557 | 2022-05-13 | Galax city | Virginia | 51640 | 2561 | 78 |
2502826 | 2502826 | 2022-05-13 | Sheridan | Wyoming | 56033 | 8097 | 78 |
2496465 | 2496465 | 2022-05-12 | Lawrence | Arkansas | 5075 | 5319 | 78 |
2496710 | 2496710 | 2022-05-12 | Bacon | Georgia | 13005 | 3692 | 78 |
2496823 | 2496823 | 2022-05-12 | Pulaski | Georgia | 13235 | 2180 | 78 |
2497059 | 2497059 | 2022-05-12 | Jay | Indiana | 18075 | 4862 | 78 |
2497129 | 2497129 | 2022-05-12 | Cass | Iowa | 19029 | 2962 | 78 |
2497235 | 2497235 | 2022-05-12 | Dickinson | Kansas | 20041 | 4807 | 78 |
2497334 | 2497334 | 2022-05-12 | Breckinridge | Kentucky | 21027 | 5170 | 78 |
2497360 | 2497360 | 2022-05-12 | Garrard | Kentucky | 21079 | 4815 | 78 |
2497454 | 2497454 | 2022-05-12 | Claiborne | Louisiana | 22027 | 3280 | 78 |
2498232 | 2498232 | 2022-05-12 | Ashe | North Carolina | 37009 | 6471 | 78 |
2498781 | 2498781 | 2022-05-12 | Saluda | South Carolina | 45081 | 3968 | 78 |
2498995 | 2498995 | 2022-05-12 | Comanche | Texas | 48093 | 3698 | 78 |
2499299 | 2499299 | 2022-05-12 | Galax city | Virginia | 51640 | 2559 | 78 |
2499568 | 2499568 | 2022-05-12 | Sheridan | Wyoming | 56033 | 8097 | 78 |
2493207 | 2493207 | 2022-05-11 | Lawrence | Arkansas | 5075 | 5317 | 78 |
2493452 | 2493452 | 2022-05-11 | Bacon | Georgia | 13005 | 3692 | 78 |
2493565 | 2493565 | 2022-05-11 | Pulaski | Georgia | 13235 | 2180 | 78 |
2493801 | 2493801 | 2022-05-11 | Jay | Indiana | 18075 | 4862 | 78 |
2493871 | 2493871 | 2022-05-11 | Cass | Iowa | 19029 | 2962 | 78 |
2493977 | 2493977 | 2022-05-11 | Dickinson | Kansas | 20041 | 4807 | 78 |
2494076 | 2494076 | 2022-05-11 | Breckinridge | Kentucky | 21027 | 5170 | 78 |
2494102 | 2494102 | 2022-05-11 | Garrard | Kentucky | 21079 | 4815 | 78 |
2494196 | 2494196 | 2022-05-11 | Claiborne | Louisiana | 22027 | 3280 | 78 |
2494974 | 2494974 | 2022-05-11 | Ashe | North Carolina | 37009 | 6471 | 78 |
2495523 | 2495523 | 2022-05-11 | Saluda | South Carolina | 45081 | 3968 | 78 |
2495737 | 2495737 | 2022-05-11 | Comanche | Texas | 48093 | 3698 | 78 |
2496041 | 2496041 | 2022-05-11 | Galax city | Virginia | 51640 | 2559 | 78 |
2496310 | 2496310 | 2022-05-11 | Sheridan | Wyoming | 56033 | 8097 | 78 |
2489949 | 2489949 | 2022-05-10 | Lawrence | Arkansas | 5075 | 5317 | 78 |
2490145 | 2490145 | 2022-05-10 | Gulf | Florida | 12045 | 4292 | 78 |
2490307 | 2490307 | 2022-05-10 | Pulaski | Georgia | 13235 | 2179 | 78 |
2490543 | 2490543 | 2022-05-10 | Jay | Indiana | 18075 | 4860 | 78 |
2490613 | 2490613 | 2022-05-10 | Cass | Iowa | 19029 | 2962 | 78 |
2490719 | 2490719 | 2022-05-10 | Dickinson | Kansas | 20041 | 4807 | 78 |
2490818 | 2490818 | 2022-05-10 | Breckinridge | Kentucky | 21027 | 5170 | 78 |
2490844 | 2490844 | 2022-05-10 | Garrard | Kentucky | 21079 | 4815 | 78 |
2491716 | 2491716 | 2022-05-10 | Ashe | North Carolina | 37009 | 6440 | 78 |
2492265 | 2492265 | 2022-05-10 | Saluda | South Carolina | 45081 | 3962 | 78 |
2492479 | 2492479 | 2022-05-10 | Comanche | Texas | 48093 | 3697 | 78 |
2492783 | 2492783 | 2022-05-10 | Galax city | Virginia | 51640 | 2558 | 78 |
2493052 | 2493052 | 2022-05-10 | Sheridan | Wyoming | 56033 | 8097 | 78 |
2486692 | 2486692 | 2022-05-09 | Lawrence | Arkansas | 5075 | 5317 | 78 |
2486888 | 2486888 | 2022-05-09 | Gulf | Florida | 12045 | 4292 | 78 |
2487050 | 2487050 | 2022-05-09 | Pulaski | Georgia | 13235 | 2179 | 78 |
2487286 | 2487286 | 2022-05-09 | Jay | Indiana | 18075 | 4860 | 78 |
2487356 | 2487356 | 2022-05-09 | Cass | Iowa | 19029 | 2962 | 78 |
2487462 | 2487462 | 2022-05-09 | Dickinson | Kansas | 20041 | 4807 | 78 |
2487561 | 2487561 | 2022-05-09 | Breckinridge | Kentucky | 21027 | 5170 | 78 |
2487587 | 2487587 | 2022-05-09 | Garrard | Kentucky | 21079 | 4815 | 78 |
2488458 | 2488458 | 2022-05-09 | Ashe | North Carolina | 37009 | 6440 | 78 |
2489007 | 2489007 | 2022-05-09 | Saluda | South Carolina | 45081 | 3962 | 78 |
2489221 | 2489221 | 2022-05-09 | Comanche | Texas | 48093 | 3697 | 78 |
2489525 | 2489525 | 2022-05-09 | Galax city | Virginia | 51640 | 2557 | 78 |
2489794 | 2489794 | 2022-05-09 | Sheridan | Wyoming | 56033 | 8067 | 78 |
2483434 | 2483434 | 2022-05-08 | Lawrence | Arkansas | 5075 | 5317 | 78 |
2483630 | 2483630 | 2022-05-08 | Gulf | Florida | 12045 | 4292 | 78 |
2483792 | 2483792 | 2022-05-08 | Pulaski | Georgia | 13235 | 2179 | 78 |
2484028 | 2484028 | 2022-05-08 | Jay | Indiana | 18075 | 4856 | 78 |
2484098 | 2484098 | 2022-05-08 | Cass | Iowa | 19029 | 2962 | 78 |
2484204 | 2484204 | 2022-05-08 | Dickinson | Kansas | 20041 | 4807 | 78 |
2484303 | 2484303 | 2022-05-08 | Breckinridge | Kentucky | 21027 | 5154 | 78 |
2485201 | 2485201 | 2022-05-08 | Ashe | North Carolina | 37009 | 6440 | 78 |
2485750 | 2485750 | 2022-05-08 | Saluda | South Carolina | 45081 | 3962 | 78 |
2485964 | 2485964 | 2022-05-08 | Comanche | Texas | 48093 | 3697 | 78 |
2486268 | 2486268 | 2022-05-08 | Galax city | Virginia | 51640 | 2556 | 78 |
2486537 | 2486537 | 2022-05-08 | Sheridan | Wyoming | 56033 | 8067 | 78 |
2480176 | 2480176 | 2022-05-07 | Lawrence | Arkansas | 5075 | 5317 | 78 |
2480372 | 2480372 | 2022-05-07 | Gulf | Florida | 12045 | 4292 | 78 |
2480534 | 2480534 | 2022-05-07 | Pulaski | Georgia | 13235 | 2179 | 78 |
2480770 | 2480770 | 2022-05-07 | Jay | Indiana | 18075 | 4856 | 78 |
2480840 | 2480840 | 2022-05-07 | Cass | Iowa | 19029 | 2962 | 78 |
2480946 | 2480946 | 2022-05-07 | Dickinson | Kansas | 20041 | 4807 | 78 |
2481045 | 2481045 | 2022-05-07 | Breckinridge | Kentucky | 21027 | 5154 | 78 |
2481943 | 2481943 | 2022-05-07 | Ashe | North Carolina | 37009 | 6440 | 78 |
2482492 | 2482492 | 2022-05-07 | Saluda | South Carolina | 45081 | 3962 | 78 |
2482706 | 2482706 | 2022-05-07 | Comanche | Texas | 48093 | 3697 | 78 |
2483010 | 2483010 | 2022-05-07 | Galax city | Virginia | 51640 | 2556 | 78 |
2483279 | 2483279 | 2022-05-07 | Sheridan | Wyoming | 56033 | 8067 | 78 |
2476918 | 2476918 | 2022-05-06 | Lawrence | Arkansas | 5075 | 5314 | 78 |
2477114 | 2477114 | 2022-05-06 | Gulf | Florida | 12045 | 4292 | 78 |
2477276 | 2477276 | 2022-05-06 | Pulaski | Georgia | 13235 | 2179 | 78 |
2477512 | 2477512 | 2022-05-06 | Jay | Indiana | 18075 | 4856 | 78 |
2477582 | 2477582 | 2022-05-06 | Cass | Iowa | 19029 | 2962 | 78 |
2477688 | 2477688 | 2022-05-06 | Dickinson | Kansas | 20041 | 4807 | 78 |
2477787 | 2477787 | 2022-05-06 | Breckinridge | Kentucky | 21027 | 5154 | 78 |
2478685 | 2478685 | 2022-05-06 | Ashe | North Carolina | 37009 | 6440 | 78 |
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);