ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,805 rows where deaths = 139 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Indiana 197
- Oklahoma 153
- Alabama 149
- Mississippi 139
- Texas 129
- Georgia 128
- Minnesota 121
- Ohio 116
- Louisiana 111
- Illinois 110
- Wisconsin 109
- North Carolina 108
- Michigan 101
- Missouri 101
- Virginia 92
- Kansas 86
- South Carolina 75
- Tennessee 67
- Pennsylvania 59
- Washington 59
- Kentucky 56
- Florida 52
- Iowa 51
- New York 49
- West Virginia 38
- California 36
- Arkansas 34
- New Mexico 32
- Connecticut 31
- Maryland 30
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499604 | 2499604 | 2022-05-13 | Franklin | Alabama | 1059 | 9903 | 139 |
2500307 | 2500307 | 2022-05-13 | Greene | Indiana | 18055 | 7262 | 139 |
2500401 | 2500401 | 2022-05-13 | Des Moines | Iowa | 19057 | 9192 | 139 |
2500495 | 2500495 | 2022-05-13 | Douglas | Kansas | 20045 | 27394 | 139 |
2500635 | 2500635 | 2022-05-13 | Jessamine | Kentucky | 21113 | 15289 | 139 |
2500824 | 2500824 | 2022-05-13 | Alpena | Michigan | 26007 | 5809 | 139 |
2500938 | 2500938 | 2022-05-13 | Kandiyohi | Minnesota | 27067 | 13649 | 139 |
2501487 | 2501487 | 2022-05-13 | Alexander | North Carolina | 37003 | 10479 | 139 |
2502665 | 2502665 | 2022-05-13 | Mason | Washington | 53045 | 12661 | 139 |
2502781 | 2502781 | 2022-05-13 | Oneida | Wisconsin | 55085 | 8605 | 139 |
2496346 | 2496346 | 2022-05-12 | Franklin | Alabama | 1059 | 9901 | 139 |
2497049 | 2497049 | 2022-05-12 | Greene | Indiana | 18055 | 7252 | 139 |
2497143 | 2497143 | 2022-05-12 | Des Moines | Iowa | 19057 | 9192 | 139 |
2497237 | 2497237 | 2022-05-12 | Douglas | Kansas | 20045 | 27394 | 139 |
2497377 | 2497377 | 2022-05-12 | Jessamine | Kentucky | 21113 | 15289 | 139 |
2497566 | 2497566 | 2022-05-12 | Alpena | Michigan | 26007 | 5809 | 139 |
2497680 | 2497680 | 2022-05-12 | Kandiyohi | Minnesota | 27067 | 13625 | 139 |
2498229 | 2498229 | 2022-05-12 | Alexander | North Carolina | 37003 | 10479 | 139 |
2499407 | 2499407 | 2022-05-12 | Mason | Washington | 53045 | 12589 | 139 |
2499523 | 2499523 | 2022-05-12 | Oneida | Wisconsin | 55085 | 8599 | 139 |
2493088 | 2493088 | 2022-05-11 | Franklin | Alabama | 1059 | 9900 | 139 |
2493791 | 2493791 | 2022-05-11 | Greene | Indiana | 18055 | 7252 | 139 |
2493885 | 2493885 | 2022-05-11 | Des Moines | Iowa | 19057 | 9192 | 139 |
2493979 | 2493979 | 2022-05-11 | Douglas | Kansas | 20045 | 27259 | 139 |
2494119 | 2494119 | 2022-05-11 | Jessamine | Kentucky | 21113 | 15289 | 139 |
2494308 | 2494308 | 2022-05-11 | Alpena | Michigan | 26007 | 5809 | 139 |
2494422 | 2494422 | 2022-05-11 | Kandiyohi | Minnesota | 27067 | 13613 | 139 |
2494971 | 2494971 | 2022-05-11 | Alexander | North Carolina | 37003 | 10479 | 139 |
2496149 | 2496149 | 2022-05-11 | Mason | Washington | 53045 | 12589 | 139 |
2496265 | 2496265 | 2022-05-11 | Oneida | Wisconsin | 55085 | 8591 | 139 |
2489830 | 2489830 | 2022-05-10 | Franklin | Alabama | 1059 | 9899 | 139 |
2490533 | 2490533 | 2022-05-10 | Greene | Indiana | 18055 | 7245 | 139 |
2490721 | 2490721 | 2022-05-10 | Douglas | Kansas | 20045 | 27259 | 139 |
2490861 | 2490861 | 2022-05-10 | Jessamine | Kentucky | 21113 | 15289 | 139 |
2491050 | 2491050 | 2022-05-10 | Alpena | Michigan | 26007 | 5767 | 139 |
2491164 | 2491164 | 2022-05-10 | Kandiyohi | Minnesota | 27067 | 13591 | 139 |
2491713 | 2491713 | 2022-05-10 | Alexander | North Carolina | 37003 | 10465 | 139 |
2492891 | 2492891 | 2022-05-10 | Mason | Washington | 53045 | 12575 | 139 |
2493007 | 2493007 | 2022-05-10 | Oneida | Wisconsin | 55085 | 8576 | 139 |
2486573 | 2486573 | 2022-05-09 | Franklin | Alabama | 1059 | 9898 | 139 |
2487276 | 2487276 | 2022-05-09 | Greene | Indiana | 18055 | 7245 | 139 |
2487604 | 2487604 | 2022-05-09 | Jessamine | Kentucky | 21113 | 15289 | 139 |
2487793 | 2487793 | 2022-05-09 | Alpena | Michigan | 26007 | 5767 | 139 |
2487907 | 2487907 | 2022-05-09 | Kandiyohi | Minnesota | 27067 | 13561 | 139 |
2488455 | 2488455 | 2022-05-09 | Alexander | North Carolina | 37003 | 10465 | 139 |
2489633 | 2489633 | 2022-05-09 | Mason | Washington | 53045 | 12575 | 139 |
2489749 | 2489749 | 2022-05-09 | Oneida | Wisconsin | 55085 | 8570 | 139 |
2483315 | 2483315 | 2022-05-08 | Franklin | Alabama | 1059 | 9898 | 139 |
2484018 | 2484018 | 2022-05-08 | Greene | Indiana | 18055 | 7236 | 139 |
2484535 | 2484535 | 2022-05-08 | Alpena | Michigan | 26007 | 5767 | 139 |
2484649 | 2484649 | 2022-05-08 | Kandiyohi | Minnesota | 27067 | 13548 | 139 |
2485198 | 2485198 | 2022-05-08 | Alexander | North Carolina | 37003 | 10465 | 139 |
2486376 | 2486376 | 2022-05-08 | Mason | Washington | 53045 | 12503 | 139 |
2486492 | 2486492 | 2022-05-08 | Oneida | Wisconsin | 55085 | 8556 | 139 |
2480057 | 2480057 | 2022-05-07 | Franklin | Alabama | 1059 | 9898 | 139 |
2480760 | 2480760 | 2022-05-07 | Greene | Indiana | 18055 | 7236 | 139 |
2481277 | 2481277 | 2022-05-07 | Alpena | Michigan | 26007 | 5767 | 139 |
2481391 | 2481391 | 2022-05-07 | Kandiyohi | Minnesota | 27067 | 13548 | 139 |
2481940 | 2481940 | 2022-05-07 | Alexander | North Carolina | 37003 | 10465 | 139 |
2483118 | 2483118 | 2022-05-07 | Mason | Washington | 53045 | 12503 | 139 |
2483234 | 2483234 | 2022-05-07 | Oneida | Wisconsin | 55085 | 8556 | 139 |
2476799 | 2476799 | 2022-05-06 | Franklin | Alabama | 1059 | 9898 | 139 |
2477502 | 2477502 | 2022-05-06 | Greene | Indiana | 18055 | 7236 | 139 |
2478019 | 2478019 | 2022-05-06 | Alpena | Michigan | 26007 | 5767 | 139 |
2478133 | 2478133 | 2022-05-06 | Kandiyohi | Minnesota | 27067 | 13548 | 139 |
2478682 | 2478682 | 2022-05-06 | Alexander | North Carolina | 37003 | 10465 | 139 |
2479860 | 2479860 | 2022-05-06 | Mason | Washington | 53045 | 12503 | 139 |
2479976 | 2479976 | 2022-05-06 | Oneida | Wisconsin | 55085 | 8556 | 139 |
2473541 | 2473541 | 2022-05-05 | Franklin | Alabama | 1059 | 9898 | 139 |
2474244 | 2474244 | 2022-05-05 | Greene | Indiana | 18055 | 7236 | 139 |
2474761 | 2474761 | 2022-05-05 | Alpena | Michigan | 26007 | 5767 | 139 |
2474875 | 2474875 | 2022-05-05 | Kandiyohi | Minnesota | 27067 | 13529 | 139 |
2475424 | 2475424 | 2022-05-05 | Alexander | North Carolina | 37003 | 10465 | 139 |
2476602 | 2476602 | 2022-05-05 | Mason | Washington | 53045 | 12503 | 139 |
2476718 | 2476718 | 2022-05-05 | Oneida | Wisconsin | 55085 | 8551 | 139 |
2470284 | 2470284 | 2022-05-04 | Franklin | Alabama | 1059 | 9898 | 139 |
2470987 | 2470987 | 2022-05-04 | Greene | Indiana | 18055 | 7236 | 139 |
2471504 | 2471504 | 2022-05-04 | Alpena | Michigan | 26007 | 5767 | 139 |
2471618 | 2471618 | 2022-05-04 | Kandiyohi | Minnesota | 27067 | 13517 | 139 |
2472167 | 2472167 | 2022-05-04 | Alexander | North Carolina | 37003 | 10465 | 139 |
2473344 | 2473344 | 2022-05-04 | Mason | Washington | 53045 | 12503 | 139 |
2467555 | 2467555 | 2022-05-03 | Maui | Hawaii | 15009 | 30809 | 139 |
2467731 | 2467731 | 2022-05-03 | Greene | Indiana | 18055 | 7231 | 139 |
2468248 | 2468248 | 2022-05-03 | Alpena | Michigan | 26007 | 5728 | 139 |
2468362 | 2468362 | 2022-05-03 | Kandiyohi | Minnesota | 27067 | 13508 | 139 |
2470088 | 2470088 | 2022-05-03 | Mason | Washington | 53045 | 12528 | 139 |
2464300 | 2464300 | 2022-05-02 | Maui | Hawaii | 15009 | 30809 | 139 |
2464476 | 2464476 | 2022-05-02 | Greene | Indiana | 18055 | 7231 | 139 |
2464869 | 2464869 | 2022-05-02 | Allen | Louisiana | 22003 | 7874 | 139 |
2464993 | 2464993 | 2022-05-02 | Alpena | Michigan | 26007 | 5728 | 139 |
2465107 | 2465107 | 2022-05-02 | Kandiyohi | Minnesota | 27067 | 13491 | 139 |
2466832 | 2466832 | 2022-05-02 | Mason | Washington | 53045 | 12528 | 139 |
2461044 | 2461044 | 2022-05-01 | Maui | Hawaii | 15009 | 30809 | 139 |
2461220 | 2461220 | 2022-05-01 | Greene | Indiana | 18055 | 7230 | 139 |
2461613 | 2461613 | 2022-05-01 | Allen | Louisiana | 22003 | 7874 | 139 |
2461737 | 2461737 | 2022-05-01 | Alpena | Michigan | 26007 | 5728 | 139 |
2461851 | 2461851 | 2022-05-01 | Kandiyohi | Minnesota | 27067 | 13483 | 139 |
2463515 | 2463515 | 2022-05-01 | Petersburg city | Virginia | 51730 | 8269 | 139 |
2463577 | 2463577 | 2022-05-01 | Mason | Washington | 53045 | 12468 | 139 |
2457788 | 2457788 | 2022-04-30 | Maui | Hawaii | 15009 | 30809 | 139 |
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);