ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
155 rows where deaths = 824 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 25
- Pennsylvania 34
- Texas 13
- California 10
- North Carolina 10
- Arizona 9
- Delaware 8
- Florida 8
- Louisiana 8
- Michigan 8
- Iowa 7
- Indiana 5
- Ohio 5
- Virginia 5
- Georgia 4
- South Carolina 4
- Alabama 3
- Colorado 3
- New Jersey 3
- Kansas 2
- Illinois 1
- Massachusetts 1
- Nebraska 1
- New York 1
- Utah 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501519 | 2501519 | 2022-05-13 | Forsyth | North Carolina | 37067 | 94312 | 824 |
2502633 | 2502633 | 2022-05-13 | Virginia Beach city | Virginia | 51810 | 91483 | 824 |
2498261 | 2498261 | 2022-05-12 | Forsyth | North Carolina | 37067 | 94312 | 824 |
2495003 | 2495003 | 2022-05-11 | Forsyth | North Carolina | 37067 | 94312 | 824 |
2491745 | 2491745 | 2022-05-10 | Forsyth | North Carolina | 37067 | 93499 | 824 |
2488487 | 2488487 | 2022-05-09 | Forsyth | North Carolina | 37067 | 93499 | 824 |
2489601 | 2489601 | 2022-05-09 | Virginia Beach city | Virginia | 51810 | 91047 | 824 |
2485230 | 2485230 | 2022-05-08 | Forsyth | North Carolina | 37067 | 93499 | 824 |
2481972 | 2481972 | 2022-05-07 | Forsyth | North Carolina | 37067 | 93499 | 824 |
2478714 | 2478714 | 2022-05-06 | Forsyth | North Carolina | 37067 | 93499 | 824 |
2475456 | 2475456 | 2022-05-05 | Forsyth | North Carolina | 37067 | 93499 | 824 |
2472199 | 2472199 | 2022-05-04 | Forsyth | North Carolina | 37067 | 93499 | 824 |
2356780 | 2356780 | 2022-03-30 | Hall | Georgia | 13139 | 53727 | 824 |
2357641 | 2357641 | 2022-03-30 | St. Clair | Michigan | 26147 | 40483 | 824 |
2353527 | 2353527 | 2022-03-29 | Hall | Georgia | 13139 | 53698 | 824 |
2354388 | 2354388 | 2022-03-29 | St. Clair | Michigan | 26147 | 40467 | 824 |
2350275 | 2350275 | 2022-03-28 | Hall | Georgia | 13139 | 53695 | 824 |
2351136 | 2351136 | 2022-03-28 | St. Clair | Michigan | 26147 | 40446 | 824 |
2347883 | 2347883 | 2022-03-27 | St. Clair | Michigan | 26147 | 40442 | 824 |
2344630 | 2344630 | 2022-03-26 | St. Clair | Michigan | 26147 | 40426 | 824 |
2341377 | 2341377 | 2022-03-25 | St. Clair | Michigan | 26147 | 40426 | 824 |
2339555 | 2339555 | 2022-03-24 | Jefferson | Texas | 48245 | 46139 | 824 |
2336301 | 2336301 | 2022-03-23 | Jefferson | Texas | 48245 | 46051 | 824 |
2333047 | 2333047 | 2022-03-22 | Jefferson | Texas | 48245 | 45970 | 824 |
2329794 | 2329794 | 2022-03-21 | Jefferson | Texas | 48245 | 45891 | 824 |
2307748 | 2307748 | 2022-03-15 | San Francisco | California | 6075 | 132103 | 824 |
2304497 | 2304497 | 2022-03-14 | San Francisco | California | 6075 | 132150 | 824 |
2263168 | 2263168 | 2022-03-01 | St. Tammany | Louisiana | 22103 | 71663 | 824 |
2259917 | 2259917 | 2022-02-28 | St. Tammany | Louisiana | 22103 | 71663 | 824 |
2256666 | 2256666 | 2022-02-27 | St. Tammany | Louisiana | 22103 | 71663 | 824 |
2253415 | 2253415 | 2022-02-26 | St. Tammany | Louisiana | 22103 | 71663 | 824 |
2250164 | 2250164 | 2022-02-25 | St. Tammany | Louisiana | 22103 | 71663 | 824 |
2251701 | 2251701 | 2022-02-25 | Galveston | Texas | 48167 | 94541 | 824 |
2239749 | 2239749 | 2022-02-22 | Richmond | Georgia | 13245 | 49302 | 824 |
2212967 | 2212967 | 2022-02-13 | Henrico | Virginia | 51087 | 61900 | 824 |
2209714 | 2209714 | 2022-02-12 | Henrico | Virginia | 51087 | 61900 | 824 |
2206461 | 2206461 | 2022-02-11 | Henrico | Virginia | 51087 | 61900 | 824 |
2203092 | 2203092 | 2022-02-10 | Williamson | Texas | 48491 | 128570 | 824 |
2193814 | 2193814 | 2022-02-08 | Navajo | Arizona | 4017 | 36435 | 824 |
2192745 | 2192745 | 2022-02-07 | Cumberland | Pennsylvania | 42041 | 49300 | 824 |
2187253 | 2187253 | 2022-02-06 | Montgomery | Alabama | 1101 | 53150 | 824 |
2189491 | 2189491 | 2022-02-06 | Cumberland | Pennsylvania | 42041 | 49169 | 824 |
2184000 | 2184000 | 2022-02-05 | Montgomery | Alabama | 1101 | 53150 | 824 |
2186238 | 2186238 | 2022-02-05 | Cumberland | Pennsylvania | 42041 | 49121 | 824 |
2180748 | 2180748 | 2022-02-04 | Montgomery | Alabama | 1101 | 53075 | 824 |
2134182 | 2134182 | 2022-01-20 | Dauphin | Pennsylvania | 42043 | 53936 | 824 |
2123936 | 2123936 | 2022-01-17 | Gloucester | New Jersey | 34015 | 62782 | 824 |
2012481 | 2012481 | 2021-12-14 | Polk | Iowa | 19153 | 83876 | 824 |
2009230 | 2009230 | 2021-12-13 | Polk | Iowa | 19153 | 83876 | 824 |
2005979 | 2005979 | 2021-12-12 | Polk | Iowa | 19153 | 83876 | 824 |
2002728 | 2002728 | 2021-12-11 | Polk | Iowa | 19153 | 83876 | 824 |
1999478 | 1999478 | 2021-12-10 | Polk | Iowa | 19153 | 83876 | 824 |
1996227 | 1996227 | 2021-12-09 | Polk | Iowa | 19153 | 83876 | 824 |
1992976 | 1992976 | 2021-12-08 | Polk | Iowa | 19153 | 83876 | 824 |
1984665 | 1984665 | 2021-12-05 | Northampton | Pennsylvania | 42095 | 49958 | 824 |
1980981 | 1980981 | 2021-12-04 | Onondaga | New York | 36067 | 60869 | 824 |
1981415 | 1981415 | 2021-12-04 | Northampton | Pennsylvania | 42095 | 49658 | 824 |
1965689 | 1965689 | 2021-11-29 | Smith | Texas | 48423 | 37172 | 824 |
1867996 | 1867996 | 2021-10-30 | Brazoria | Texas | 48039 | 59756 | 824 |
1864747 | 1864747 | 2021-10-29 | Brazoria | Texas | 48039 | 59705 | 824 |
1834557 | 1834557 | 2021-10-20 | Douglas | Nebraska | 31055 | 86036 | 824 |
1823491 | 1823491 | 2021-10-17 | Seminole | Florida | 12117 | 61582 | 824 |
1820242 | 1820242 | 2021-10-16 | Seminole | Florida | 12117 | 61582 | 824 |
1816993 | 1816993 | 2021-10-15 | Seminole | Florida | 12117 | 61582 | 824 |
1789814 | 1789814 | 2021-10-06 | Horry | South Carolina | 45051 | 60350 | 824 |
1737717 | 1737717 | 2021-09-20 | Westmoreland | Pennsylvania | 42129 | 39288 | 824 |
1734467 | 1734467 | 2021-09-19 | Westmoreland | Pennsylvania | 42129 | 39216 | 824 |
1731217 | 1731217 | 2021-09-18 | Westmoreland | Pennsylvania | 42129 | 39057 | 824 |
1726000 | 1726000 | 2021-09-17 | Manatee | Florida | 12081 | 61644 | 824 |
1722751 | 1722751 | 2021-09-16 | Manatee | Florida | 12081 | 60130 | 824 |
1719502 | 1719502 | 2021-09-15 | Manatee | Florida | 12081 | 60130 | 824 |
1716254 | 1716254 | 2021-09-14 | Manatee | Florida | 12081 | 60130 | 824 |
1660109 | 1660109 | 2021-08-27 | Denton | Texas | 48121 | 88221 | 824 |
1660199 | 1660199 | 2021-08-27 | Lubbock | Texas | 48303 | 55901 | 824 |
1655117 | 1655117 | 2021-08-26 | Johnson | Kansas | 20091 | 68446 | 824 |
1651870 | 1651870 | 2021-08-25 | Johnson | Kansas | 20091 | 68446 | 824 |
1587114 | 1587114 | 2021-08-05 | Orleans | Louisiana | 22071 | 37050 | 824 |
1527690 | 1527690 | 2021-07-18 | Contra Costa | California | 6013 | 73679 | 824 |
1524443 | 1524443 | 2021-07-17 | Contra Costa | California | 6013 | 73679 | 824 |
1521195 | 1521195 | 2021-07-16 | Contra Costa | California | 6013 | 73679 | 824 |
1500553 | 1500553 | 2021-07-09 | Chester | Pennsylvania | 42029 | 40876 | 824 |
1497307 | 1497307 | 2021-07-08 | Chester | Pennsylvania | 42029 | 40872 | 824 |
1494060 | 1494060 | 2021-07-07 | Chester | Pennsylvania | 42029 | 40861 | 824 |
1490813 | 1490813 | 2021-07-06 | Chester | Pennsylvania | 42029 | 40851 | 824 |
1487566 | 1487566 | 2021-07-05 | Chester | Pennsylvania | 42029 | 40846 | 824 |
1484319 | 1484319 | 2021-07-04 | Chester | Pennsylvania | 42029 | 40842 | 824 |
1481073 | 1481073 | 2021-07-03 | Chester | Pennsylvania | 42029 | 40838 | 824 |
1477826 | 1477826 | 2021-07-02 | Chester | Pennsylvania | 42029 | 40835 | 824 |
1474580 | 1474580 | 2021-07-01 | Chester | Pennsylvania | 42029 | 40830 | 824 |
1471334 | 1471334 | 2021-06-30 | Chester | Pennsylvania | 42029 | 40827 | 824 |
1468089 | 1468089 | 2021-06-29 | Chester | Pennsylvania | 42029 | 40827 | 824 |
1464844 | 1464844 | 2021-06-28 | Chester | Pennsylvania | 42029 | 40822 | 824 |
1461599 | 1461599 | 2021-06-27 | Chester | Pennsylvania | 42029 | 40820 | 824 |
1458354 | 1458354 | 2021-06-26 | Chester | Pennsylvania | 42029 | 40813 | 824 |
1455109 | 1455109 | 2021-06-25 | Chester | Pennsylvania | 42029 | 40805 | 824 |
1455134 | 1455134 | 2021-06-25 | Luzerne | Pennsylvania | 42079 | 32088 | 824 |
1451694 | 1451694 | 2021-06-24 | Lucas | Ohio | 39095 | 43387 | 824 |
1451889 | 1451889 | 2021-06-24 | Luzerne | Pennsylvania | 42079 | 32085 | 824 |
1448448 | 1448448 | 2021-06-23 | Lucas | Ohio | 39095 | 43384 | 824 |
1448643 | 1448643 | 2021-06-23 | Luzerne | Pennsylvania | 42079 | 32074 | 824 |
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);