ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
141 rows where deaths = 857 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 29
- California 18
- Florida 12
- Pennsylvania 12
- Arizona 9
- Colorado 9
- Illinois 8
- Missouri 8
- Iowa 7
- Louisiana 6
- New Jersey 5
- South Carolina 5
- Texas 5
- North Carolina 4
- Ohio 4
- Washington 4
- Indiana 3
- Kansas 3
- Michigan 3
- Alabama 2
- Georgia 2
- Maryland 2
- New York 2
- Utah 2
- Delaware 1
- District of Columbia 1
- Kentucky 1
- Nebraska 1
- Nevada 1
- Tennessee 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499895 | 2499895 | 2022-05-13 | Sussex | Delaware | 10005 | 63138 | 857 |
2450944 | 2450944 | 2022-04-28 | San Francisco | California | 6075 | 137816 | 857 |
2447688 | 2447688 | 2022-04-27 | San Francisco | California | 6075 | 137816 | 857 |
2444432 | 2444432 | 2022-04-26 | San Francisco | California | 6075 | 137816 | 857 |
2441176 | 2441176 | 2022-04-25 | San Francisco | California | 6075 | 136855 | 857 |
2437920 | 2437920 | 2022-04-24 | San Francisco | California | 6075 | 136855 | 857 |
2434664 | 2434664 | 2022-04-23 | San Francisco | California | 6075 | 136855 | 857 |
2431408 | 2431408 | 2022-04-22 | San Francisco | California | 6075 | 136855 | 857 |
2347221 | 2347221 | 2022-03-27 | Madison | Illinois | 17119 | 70112 | 857 |
2343968 | 2343968 | 2022-03-26 | Madison | Illinois | 17119 | 70112 | 857 |
2340715 | 2340715 | 2022-03-25 | Madison | Illinois | 17119 | 70112 | 857 |
2337219 | 2337219 | 2022-03-24 | Chatham | Georgia | 13051 | 63394 | 857 |
2337462 | 2337462 | 2022-03-24 | Madison | Illinois | 17119 | 70105 | 857 |
2334208 | 2334208 | 2022-03-23 | Madison | Illinois | 17119 | 70081 | 857 |
2330954 | 2330954 | 2022-03-22 | Madison | Illinois | 17119 | 70064 | 857 |
2314541 | 2314541 | 2022-03-17 | Richmond | Georgia | 13245 | 49917 | 857 |
2244776 | 2244776 | 2022-02-23 | Cumberland | Pennsylvania | 42041 | 50265 | 857 |
2242025 | 2242025 | 2022-02-22 | McLennan | Texas | 48309 | 55942 | 857 |
2226278 | 2226278 | 2022-02-18 | Madison | Alabama | 1089 | 87457 | 857 |
2166858 | 2166858 | 2022-01-30 | Anderson | South Carolina | 45007 | 54138 | 857 |
2163603 | 2163603 | 2022-01-29 | Anderson | South Carolina | 45007 | 54138 | 857 |
2160214 | 2160214 | 2022-01-28 | Dauphin | Pennsylvania | 42043 | 56327 | 857 |
2160348 | 2160348 | 2022-01-28 | Anderson | South Carolina | 45007 | 54138 | 857 |
2146800 | 2146800 | 2022-01-24 | Rockland | New York | 36087 | 88325 | 857 |
2114174 | 2114174 | 2022-01-14 | Atlantic | New Jersey | 34001 | 59952 | 857 |
2105718 | 2105718 | 2022-01-11 | Snohomish | Washington | 53061 | 97841 | 857 |
2090826 | 2090826 | 2022-01-07 | Anne Arundel | Maryland | 24003 | 72569 | 857 |
2080739 | 2080739 | 2022-01-04 | Polk | Iowa | 19153 | 89063 | 857 |
2077487 | 2077487 | 2022-01-03 | Polk | Iowa | 19153 | 89063 | 857 |
2074236 | 2074236 | 2022-01-02 | Polk | Iowa | 19153 | 89063 | 857 |
2070985 | 2070985 | 2022-01-01 | Polk | Iowa | 19153 | 89063 | 857 |
2067734 | 2067734 | 2021-12-31 | Polk | Iowa | 19153 | 89063 | 857 |
2064483 | 2064483 | 2021-12-30 | Polk | Iowa | 19153 | 89063 | 857 |
2061233 | 2061233 | 2021-12-29 | Polk | Iowa | 19153 | 89063 | 857 |
2032658 | 2032658 | 2021-12-20 | Jackson | Missouri | 29095 | 64133 | 857 |
2033184 | 2033184 | 2021-12-20 | Butler | Ohio | 39017 | 60704 | 857 |
2029407 | 2029407 | 2021-12-19 | Jackson | Missouri | 29095 | 63983 | 857 |
2029934 | 2029934 | 2021-12-19 | Butler | Ohio | 39017 | 60529 | 857 |
2026156 | 2026156 | 2021-12-18 | Jackson | Missouri | 29095 | 63775 | 857 |
2026683 | 2026683 | 2021-12-18 | Butler | Ohio | 39017 | 60399 | 857 |
2023432 | 2023432 | 2021-12-17 | Butler | Ohio | 39017 | 60147 | 857 |
1994749 | 1994749 | 2021-12-08 | Brazoria | Texas | 48039 | 61071 | 857 |
1967801 | 1967801 | 2021-11-30 | Douglas | Nebraska | 31055 | 93516 | 857 |
1925393 | 1925393 | 2021-11-17 | Kansas City | Missouri | 65182 | 857 | |
1922144 | 1922144 | 2021-11-16 | Kansas City | Missouri | 65070 | 857 | |
1891725 | 1891725 | 2021-11-07 | Seminole | Florida | 12117 | 62334 | 857 |
1888475 | 1888475 | 2021-11-06 | Seminole | Florida | 12117 | 62334 | 857 |
1885225 | 1885225 | 2021-11-05 | Seminole | Florida | 12117 | 62334 | 857 |
1881976 | 1881976 | 2021-11-04 | Seminole | Florida | 12117 | 62054 | 857 |
1878727 | 1878727 | 2021-11-03 | Seminole | Florida | 12117 | 62054 | 857 |
1875478 | 1875478 | 2021-11-02 | Seminole | Florida | 12117 | 62054 | 857 |
1872229 | 1872229 | 2021-11-01 | Seminole | Florida | 12117 | 62054 | 857 |
1868980 | 1868980 | 2021-10-31 | Seminole | Florida | 12117 | 62054 | 857 |
1835945 | 1835945 | 2021-10-20 | Pierce | Washington | 53053 | 89986 | 857 |
1828803 | 1828803 | 2021-10-18 | Horry | South Carolina | 45051 | 61463 | 857 |
1825058 | 1825058 | 2021-10-17 | Guilford | North Carolina | 37081 | 66455 | 857 |
1821809 | 1821809 | 2021-10-16 | Guilford | North Carolina | 37081 | 66455 | 857 |
1818560 | 1818560 | 2021-10-15 | Guilford | North Carolina | 37081 | 66455 | 857 |
1805947 | 1805947 | 2021-10-11 | Westmoreland | Pennsylvania | 42129 | 42431 | 857 |
1800613 | 1800613 | 2021-10-10 | Adams | Colorado | 8001 | 73451 | 857 |
1802697 | 1802697 | 2021-10-10 | Westmoreland | Pennsylvania | 42129 | 42361 | 857 |
1799448 | 1799448 | 2021-10-09 | Westmoreland | Pennsylvania | 42129 | 42260 | 857 |
1796199 | 1796199 | 2021-10-08 | Westmoreland | Pennsylvania | 42129 | 42095 | 857 |
1789152 | 1789152 | 2021-10-06 | Washoe | Nevada | 32031 | 62476 | 857 |
1740941 | 1740941 | 2021-09-21 | Luzerne | Pennsylvania | 42079 | 36041 | 857 |
1737692 | 1737692 | 2021-09-20 | Luzerne | Pennsylvania | 42079 | 35950 | 857 |
1734442 | 1734442 | 2021-09-19 | Luzerne | Pennsylvania | 42079 | 35878 | 857 |
1710341 | 1710341 | 2021-09-12 | Johnson | Kansas | 20091 | 71739 | 857 |
1707094 | 1707094 | 2021-09-11 | Johnson | Kansas | 20091 | 71739 | 857 |
1703846 | 1703846 | 2021-09-10 | Johnson | Kansas | 20091 | 71739 | 857 |
1694287 | 1694287 | 2021-09-07 | Caddo | Louisiana | 22017 | 36342 | 857 |
1690155 | 1690155 | 2021-09-06 | Arapahoe | Colorado | 8005 | 71247 | 857 |
1686905 | 1686905 | 2021-09-05 | Arapahoe | Colorado | 8005 | 71247 | 857 |
1657534 | 1657534 | 2021-08-27 | Yuma | Arizona | 4027 | 38868 | 857 |
1654286 | 1654286 | 2021-08-26 | Yuma | Arizona | 4027 | 38802 | 857 |
1651039 | 1651039 | 2021-08-25 | Yuma | Arizona | 4027 | 38708 | 857 |
1647790 | 1647790 | 2021-08-24 | Yuma | Arizona | 4027 | 38708 | 857 |
1647873 | 1647873 | 2021-08-24 | Contra Costa | California | 6013 | 86408 | 857 |
1644542 | 1644542 | 2021-08-23 | Yuma | Arizona | 4027 | 38689 | 857 |
1644625 | 1644625 | 2021-08-23 | Contra Costa | California | 6013 | 86128 | 857 |
1641292 | 1641292 | 2021-08-22 | Yuma | Arizona | 4027 | 38619 | 857 |
1641375 | 1641375 | 2021-08-22 | Contra Costa | California | 6013 | 85893 | 857 |
1641422 | 1641422 | 2021-08-22 | Tulare | California | 6107 | 64029 | 857 |
1638042 | 1638042 | 2021-08-21 | Yuma | Arizona | 4027 | 38555 | 857 |
1638125 | 1638125 | 2021-08-21 | Contra Costa | California | 6013 | 85478 | 857 |
1634792 | 1634792 | 2021-08-20 | Yuma | Arizona | 4027 | 38508 | 857 |
1608961 | 1608961 | 2021-08-12 | Denver | Colorado | 8031 | 77722 | 857 |
1605712 | 1605712 | 2021-08-11 | Denver | Colorado | 8031 | 77514 | 857 |
1556771 | 1556771 | 2021-07-27 | Mobile | Alabama | 1097 | 46611 | 857 |
1549647 | 1549647 | 2021-07-24 | Collin | Texas | 48085 | 94824 | 857 |
1546400 | 1546400 | 2021-07-23 | Collin | Texas | 48085 | 94681 | 857 |
1543288 | 1543288 | 2021-07-22 | Nueces | Texas | 48355 | 41155 | 857 |
1535128 | 1535128 | 2021-07-20 | East Baton Rouge | Louisiana | 22033 | 43093 | 857 |
1447624 | 1447624 | 2021-06-23 | Kent | Michigan | 26081 | 73392 | 857 |
1444379 | 1444379 | 2021-06-22 | Kent | Michigan | 26081 | 73322 | 857 |
1441134 | 1441134 | 2021-06-21 | Kent | Michigan | 26081 | 73291 | 857 |
1420639 | 1420639 | 2021-06-15 | El Paso | Colorado | 8041 | 72254 | 857 |
1417394 | 1417394 | 2021-06-14 | El Paso | Colorado | 8041 | 72148 | 857 |
1414148 | 1414148 | 2021-06-13 | El Paso | Colorado | 8041 | 72095 | 857 |
1410903 | 1410903 | 2021-06-12 | El Paso | Colorado | 8041 | 71977 | 857 |
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);