ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
192 rows where deaths = 1009 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 27
- Florida 111
- Texas 13
- California 7
- Hawaii 7
- North Carolina 6
- Pennsylvania 5
- Indiana 4
- Louisiana 4
- Utah 4
- Kansas 3
- Michigan 3
- Oregon 3
- Colorado 2
- Idaho 2
- Illinois 2
- Maryland 2
- Minnesota 2
- New Jersey 2
- South Carolina 2
- District of Columbia 1
- Massachusetts 1
- Missouri 1
- Nebraska 1
- New Mexico 1
- New York 1
- Tennessee 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2360133 | 2360133 | 2022-03-31 | Ada | Idaho | 16001 | 133273 | 1009 |
2356879 | 2356879 | 2022-03-30 | Ada | Idaho | 16001 | 133228 | 1009 |
2330849 | 2330849 | 2022-03-22 | Honolulu | Hawaii | 15003 | 165272 | 1009 |
2327597 | 2327597 | 2022-03-21 | Honolulu | Hawaii | 15003 | 165272 | 1009 |
2324344 | 2324344 | 2022-03-20 | Honolulu | Hawaii | 15003 | 165272 | 1009 |
2321090 | 2321090 | 2022-03-19 | Honolulu | Hawaii | 15003 | 165272 | 1009 |
2317836 | 2317836 | 2022-03-18 | Honolulu | Hawaii | 15003 | 165272 | 1009 |
2314583 | 2314583 | 2022-03-17 | Honolulu | Hawaii | 15003 | 165272 | 1009 |
2311330 | 2311330 | 2022-03-16 | Honolulu | Hawaii | 15003 | 165272 | 1009 |
2287628 | 2287628 | 2022-03-08 | Webb | Texas | 48479 | 92407 | 1009 |
2284376 | 2284376 | 2022-03-07 | Webb | Texas | 48479 | 92361 | 1009 |
2281124 | 2281124 | 2022-03-06 | Webb | Texas | 48479 | 92345 | 1009 |
2277871 | 2277871 | 2022-03-05 | Webb | Texas | 48479 | 92328 | 1009 |
2274618 | 2274618 | 2022-03-04 | Webb | Texas | 48479 | 92295 | 1009 |
2262343 | 2262343 | 2022-03-01 | Hernando | Florida | 12053 | 41568 | 1009 |
2259092 | 2259092 | 2022-02-28 | Hernando | Florida | 12053 | 41568 | 1009 |
2255841 | 2255841 | 2022-02-27 | Hernando | Florida | 12053 | 41568 | 1009 |
2252590 | 2252590 | 2022-02-26 | Hernando | Florida | 12053 | 41568 | 1009 |
2249339 | 2249339 | 2022-02-25 | Hernando | Florida | 12053 | 41568 | 1009 |
2246088 | 2246088 | 2022-02-24 | Hernando | Florida | 12053 | 41326 | 1009 |
2242837 | 2242837 | 2022-02-23 | Hernando | Florida | 12053 | 41326 | 1009 |
2244486 | 2244486 | 2022-02-23 | Wake | North Carolina | 37183 | 284016 | 1009 |
2241235 | 2241235 | 2022-02-22 | Wake | North Carolina | 37183 | 283678 | 1009 |
2237984 | 2237984 | 2022-02-21 | Wake | North Carolina | 37183 | 283484 | 1009 |
2234733 | 2234733 | 2022-02-20 | Wake | North Carolina | 37183 | 282503 | 1009 |
2231482 | 2231482 | 2022-02-19 | Wake | North Carolina | 37183 | 282503 | 1009 |
2228231 | 2228231 | 2022-02-18 | Wake | North Carolina | 37183 | 282503 | 1009 |
2215109 | 2215109 | 2022-02-14 | Onondaga | New York | 36067 | 105492 | 1009 |
2212235 | 2212235 | 2022-02-13 | Multnomah | Oregon | 41051 | 107740 | 1009 |
2208982 | 2208982 | 2022-02-12 | Multnomah | Oregon | 41051 | 107740 | 1009 |
2205729 | 2205729 | 2022-02-11 | Multnomah | Oregon | 41051 | 107740 | 1009 |
2198170 | 2198170 | 2022-02-09 | Anne Arundel | Maryland | 24003 | 85431 | 1009 |
2179145 | 2179145 | 2022-02-03 | Douglas | Nebraska | 31055 | 138979 | 1009 |
2173256 | 2173256 | 2022-02-01 | Northampton | Pennsylvania | 42095 | 77061 | 1009 |
2096831 | 2096831 | 2022-01-09 | Allen | Indiana | 18003 | 80867 | 1009 |
2093579 | 2093579 | 2022-01-08 | Allen | Indiana | 18003 | 80867 | 1009 |
2094423 | 2094423 | 2022-01-08 | Kansas City | Missouri | 86770 | 1009 | |
2090327 | 2090327 | 2022-01-07 | Allen | Indiana | 18003 | 80867 | 1009 |
2061517 | 2061517 | 2021-12-29 | Orleans | Louisiana | 22071 | 54760 | 1009 |
2058268 | 2058268 | 2021-12-28 | Orleans | Louisiana | 22071 | 53919 | 1009 |
2060197 | 2060197 | 2021-12-28 | Pierce | Washington | 53053 | 109466 | 1009 |
2055019 | 2055019 | 2021-12-27 | Orleans | Louisiana | 22071 | 53322 | 1009 |
2026916 | 2026916 | 2021-12-18 | Lehigh | Pennsylvania | 42077 | 58253 | 1009 |
1995599 | 1995599 | 2021-12-09 | Adams | Colorado | 8001 | 88492 | 1009 |
1989099 | 1989099 | 2021-12-07 | Arapahoe | Colorado | 8005 | 93000 | 1009 |
1962304 | 1962304 | 2021-11-28 | Fort Bend | Texas | 48157 | 101891 | 1009 |
1959053 | 1959053 | 2021-11-27 | Fort Bend | Texas | 48157 | 101891 | 1009 |
1955802 | 1955802 | 2021-11-26 | Fort Bend | Texas | 48157 | 101891 | 1009 |
1952551 | 1952551 | 2021-11-25 | Fort Bend | Texas | 48157 | 101891 | 1009 |
1949300 | 1949300 | 2021-11-24 | Fort Bend | Texas | 48157 | 101891 | 1009 |
1905734 | 1905734 | 2021-11-11 | Ramsey | Minnesota | 27123 | 68049 | 1009 |
1881124 | 1881124 | 2021-11-03 | Lubbock | Texas | 48303 | 65974 | 1009 |
1861540 | 1861540 | 2021-10-28 | Denton | Texas | 48121 | 107539 | 1009 |
1764045 | 1764045 | 2021-09-28 | Collin | Texas | 48085 | 123388 | 1009 |
1713003 | 1713003 | 2021-09-13 | Lee | Florida | 12071 | 115839 | 1009 |
1709756 | 1709756 | 2021-09-12 | Lee | Florida | 12071 | 115839 | 1009 |
1706509 | 1706509 | 2021-09-11 | Lee | Florida | 12071 | 115839 | 1009 |
1703261 | 1703261 | 2021-09-10 | Lee | Florida | 12071 | 115839 | 1009 |
1700011 | 1700011 | 2021-09-09 | Lee | Florida | 12071 | 110885 | 1009 |
1700922 | 1700922 | 2021-09-09 | Genesee | Michigan | 26049 | 45000 | 1009 |
1696762 | 1696762 | 2021-09-08 | Lee | Florida | 12071 | 110885 | 1009 |
1697673 | 1697673 | 2021-09-08 | Genesee | Michigan | 26049 | 45000 | 1009 |
1693514 | 1693514 | 2021-09-07 | Lee | Florida | 12071 | 110885 | 1009 |
1690265 | 1690265 | 2021-09-06 | Lee | Florida | 12071 | 110885 | 1009 |
1692805 | 1692805 | 2021-09-06 | Salt Lake | Utah | 49035 | 171722 | 1009 |
1687015 | 1687015 | 2021-09-05 | Lee | Florida | 12071 | 110885 | 1009 |
1689556 | 1689556 | 2021-09-05 | Salt Lake | Utah | 49035 | 171722 | 1009 |
1683765 | 1683765 | 2021-09-04 | Lee | Florida | 12071 | 110885 | 1009 |
1686306 | 1686306 | 2021-09-04 | Salt Lake | Utah | 49035 | 171722 | 1009 |
1680514 | 1680514 | 2021-09-03 | Lee | Florida | 12071 | 110885 | 1009 |
1683055 | 1683055 | 2021-09-03 | Salt Lake | Utah | 49035 | 171722 | 1009 |
1677266 | 1677266 | 2021-09-02 | Lee | Florida | 12071 | 103302 | 1009 |
1674019 | 1674019 | 2021-09-01 | Lee | Florida | 12071 | 103302 | 1009 |
1675476 | 1675476 | 2021-09-01 | Bernalillo | New Mexico | 35001 | 66361 | 1009 |
1670771 | 1670771 | 2021-08-31 | Lee | Florida | 12071 | 103302 | 1009 |
1667524 | 1667524 | 2021-08-30 | Lee | Florida | 12071 | 103302 | 1009 |
1664277 | 1664277 | 2021-08-29 | Lee | Florida | 12071 | 103302 | 1009 |
1661029 | 1661029 | 2021-08-28 | Lee | Florida | 12071 | 103302 | 1009 |
1657781 | 1657781 | 2021-08-27 | Lee | Florida | 12071 | 103302 | 1009 |
1654533 | 1654533 | 2021-08-26 | Lee | Florida | 12071 | 95599 | 1009 |
1651286 | 1651286 | 2021-08-25 | Lee | Florida | 12071 | 95599 | 1009 |
1652066 | 1652066 | 2021-08-25 | East Baton Rouge | Louisiana | 22033 | 57766 | 1009 |
1648037 | 1648037 | 2021-08-24 | Lee | Florida | 12071 | 95599 | 1009 |
1644789 | 1644789 | 2021-08-23 | Lee | Florida | 12071 | 95599 | 1009 |
1641539 | 1641539 | 2021-08-22 | Lee | Florida | 12071 | 95599 | 1009 |
1638289 | 1638289 | 2021-08-21 | Lee | Florida | 12071 | 95599 | 1009 |
1635039 | 1635039 | 2021-08-20 | Lee | Florida | 12071 | 95599 | 1009 |
1631790 | 1631790 | 2021-08-19 | Lee | Florida | 12071 | 88946 | 1009 |
1628543 | 1628543 | 2021-08-18 | Lee | Florida | 12071 | 88946 | 1009 |
1625296 | 1625296 | 2021-08-17 | Lee | Florida | 12071 | 88946 | 1009 |
1622049 | 1622049 | 2021-08-16 | Lee | Florida | 12071 | 88946 | 1009 |
1618802 | 1618802 | 2021-08-15 | Lee | Florida | 12071 | 88946 | 1009 |
1615554 | 1615554 | 2021-08-14 | Lee | Florida | 12071 | 88946 | 1009 |
1612305 | 1612305 | 2021-08-13 | Lee | Florida | 12071 | 88946 | 1009 |
1609057 | 1609057 | 2021-08-12 | Lee | Florida | 12071 | 83343 | 1009 |
1605808 | 1605808 | 2021-08-11 | Lee | Florida | 12071 | 83343 | 1009 |
1602559 | 1602559 | 2021-08-10 | Lee | Florida | 12071 | 83343 | 1009 |
1599310 | 1599310 | 2021-08-09 | Lee | Florida | 12071 | 83343 | 1009 |
1596061 | 1596061 | 2021-08-08 | Lee | Florida | 12071 | 83343 | 1009 |
1592812 | 1592812 | 2021-08-07 | Lee | Florida | 12071 | 83343 | 1009 |
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);