ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
815 rows where cases = 279 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 85
- Kansas 62
- North Dakota 49
- Georgia 38
- Virginia 35
- Montana 32
- Nebraska 31
- Illinois 30
- Iowa 26
- Indiana 25
- Puerto Rico 25
- Oklahoma 22
- South Dakota 22
- Colorado 21
- Minnesota 20
- Pennsylvania 20
- Kentucky 18
- New York 17
- North Carolina 16
- Missouri 15
- Ohio 15
- Alaska 13
- Wisconsin 13
- Florida 12
- Michigan 12
- Mississippi 12
- Washington 12
- Arkansas 11
- Alabama 10
- Maryland 9
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2284187 | 2284187 | 2022-03-07 | Cottle | Texas | 48101 | 279 | 9 |
2280935 | 2280935 | 2022-03-06 | Cottle | Texas | 48101 | 279 | 9 |
2277682 | 2277682 | 2022-03-05 | Cottle | Texas | 48101 | 279 | 9 |
2274429 | 2274429 | 2022-03-04 | Cottle | Texas | 48101 | 279 | 9 |
2271176 | 2271176 | 2022-03-03 | Cottle | Texas | 48101 | 279 | 9 |
2267488 | 2267488 | 2022-03-02 | Gilliam | Oregon | 41021 | 279 | 5 |
2267924 | 2267924 | 2022-03-02 | Cottle | Texas | 48101 | 279 | 9 |
2264671 | 2264671 | 2022-03-01 | Cottle | Texas | 48101 | 279 | 9 |
2137991 | 2137991 | 2022-01-21 | Stonewall | Texas | 48433 | 279 | 7 |
2130337 | 2130337 | 2022-01-19 | Deuel | Nebraska | 31049 | 279 | 2 |
2128379 | 2128379 | 2022-01-18 | Highland | Virginia | 51091 | 279 | 4 |
2117671 | 2117671 | 2022-01-15 | Oliver | North Dakota | 38065 | 279 | 4 |
2101044 | 2101044 | 2022-01-10 | Wheatland | Montana | 30107 | 279 | 13 |
2097793 | 2097793 | 2022-01-09 | Wheatland | Montana | 30107 | 279 | 13 |
2094541 | 2094541 | 2022-01-08 | Wheatland | Montana | 30107 | 279 | 13 |
2091289 | 2091289 | 2022-01-07 | Wheatland | Montana | 30107 | 279 | 13 |
2076890 | 2076890 | 2022-01-03 | Kiowa | Colorado | 8061 | 279 | 4 |
2073639 | 2073639 | 2022-01-02 | Kiowa | Colorado | 8061 | 279 | 4 |
2070388 | 2070388 | 2022-01-01 | Kiowa | Colorado | 8061 | 279 | 4 |
2067137 | 2067137 | 2021-12-31 | Kiowa | Colorado | 8061 | 279 | 4 |
2063886 | 2063886 | 2021-12-30 | Kiowa | Colorado | 8061 | 279 | 4 |
2063048 | 2063048 | 2021-12-29 | Dickens | Texas | 48125 | 279 | 15 |
2058755 | 2058755 | 2021-12-28 | Meagher | Montana | 30059 | 279 | 9 |
2055506 | 2055506 | 2021-12-27 | Meagher | Montana | 30059 | 279 | 9 |
2052256 | 2052256 | 2021-12-26 | Meagher | Montana | 30059 | 279 | 9 |
2053508 | 2053508 | 2021-12-26 | Rich | Utah | 49033 | 279 | 0 |
2049006 | 2049006 | 2021-12-25 | Meagher | Montana | 30059 | 279 | 9 |
2050258 | 2050258 | 2021-12-25 | Rich | Utah | 49033 | 279 | 0 |
2045756 | 2045756 | 2021-12-24 | Meagher | Montana | 30059 | 279 | 9 |
2047008 | 2047008 | 2021-12-24 | Rich | Utah | 49033 | 279 | 0 |
2042506 | 2042506 | 2021-12-23 | Meagher | Montana | 30059 | 279 | 9 |
2043758 | 2043758 | 2021-12-23 | Rich | Utah | 49033 | 279 | 0 |
2040509 | 2040509 | 2021-12-22 | Rich | Utah | 49033 | 279 | 0 |
2028800 | 2028800 | 2021-12-19 | Hodgeman | Kansas | 20083 | 279 | 10 |
2029678 | 2029678 | 2021-12-19 | Catron | New Mexico | 35003 | 279 | 9 |
2025549 | 2025549 | 2021-12-18 | Hodgeman | Kansas | 20083 | 279 | 10 |
2026427 | 2026427 | 2021-12-18 | Catron | New Mexico | 35003 | 279 | 9 |
2022298 | 2022298 | 2021-12-17 | Hodgeman | Kansas | 20083 | 279 | 10 |
2023176 | 2023176 | 2021-12-17 | Catron | New Mexico | 35003 | 279 | 9 |
1941772 | 1941772 | 2021-11-22 | Boyd | Nebraska | 31015 | 279 | 4 |
1921590 | 1921590 | 2021-11-16 | Wallace | Kansas | 20199 | 279 | 4 |
1918340 | 1918340 | 2021-11-15 | Wallace | Kansas | 20199 | 279 | 4 |
1906054 | 1906054 | 2021-11-11 | Greeley | Nebraska | 31077 | 279 | 2 |
1899489 | 1899489 | 2021-11-09 | McCone | Montana | 30055 | 279 | 3 |
1893363 | 1893363 | 2021-11-07 | Divide | North Dakota | 38023 | 279 | 3 |
1861948 | 1861948 | 2021-10-28 | Wahkiakum | Washington | 53069 | 279 | 5 |
1837106 | 1837106 | 2021-10-21 | Wichita | Kansas | 20203 | 279 | 6 |
1833857 | 1833857 | 2021-10-20 | Wichita | Kansas | 20203 | 279 | 6 |
1826446 | 1826446 | 2021-10-18 | Petersburg Borough | Alaska | 2195 | 279 | 2 |
1828991 | 1828991 | 2021-10-18 | Armstrong | Texas | 48011 | 279 | 7 |
1823197 | 1823197 | 2021-10-17 | Petersburg Borough | Alaska | 2195 | 279 | 2 |
1825742 | 1825742 | 2021-10-17 | Armstrong | Texas | 48011 | 279 | 7 |
1819948 | 1819948 | 2021-10-16 | Petersburg Borough | Alaska | 2195 | 279 | 2 |
1822493 | 1822493 | 2021-10-16 | Armstrong | Texas | 48011 | 279 | 7 |
1816699 | 1816699 | 2021-10-15 | Petersburg Borough | Alaska | 2195 | 279 | 2 |
1819244 | 1819244 | 2021-10-15 | Armstrong | Texas | 48011 | 279 | 7 |
1813451 | 1813451 | 2021-10-14 | Petersburg Borough | Alaska | 2195 | 279 | 2 |
1810202 | 1810202 | 2021-10-13 | Petersburg Borough | Alaska | 2195 | 279 | 2 |
1806953 | 1806953 | 2021-10-12 | Petersburg Borough | Alaska | 2195 | 279 | 2 |
1787676 | 1787676 | 2021-10-06 | Sedgwick | Colorado | 8115 | 279 | 4 |
1779362 | 1779362 | 2021-10-03 | Pawnee | Nebraska | 31133 | 279 | 4 |
1776112 | 1776112 | 2021-10-02 | Pawnee | Nebraska | 31133 | 279 | 4 |
1772862 | 1772862 | 2021-10-01 | Pawnee | Nebraska | 31133 | 279 | 4 |
1769613 | 1769613 | 2021-09-30 | Pawnee | Nebraska | 31133 | 279 | 4 |
1766364 | 1766364 | 2021-09-29 | Pawnee | Nebraska | 31133 | 279 | 4 |
1763115 | 1763115 | 2021-09-28 | Pawnee | Nebraska | 31133 | 279 | 4 |
1759866 | 1759866 | 2021-09-27 | Pawnee | Nebraska | 31133 | 279 | 4 |
1756618 | 1756618 | 2021-09-26 | Pawnee | Nebraska | 31133 | 279 | 4 |
1753370 | 1753370 | 2021-09-25 | Pawnee | Nebraska | 31133 | 279 | 4 |
1750122 | 1750122 | 2021-09-24 | Pawnee | Nebraska | 31133 | 279 | 4 |
1746872 | 1746872 | 2021-09-23 | Pawnee | Nebraska | 31133 | 279 | 4 |
1743623 | 1743623 | 2021-09-22 | Pawnee | Nebraska | 31133 | 279 | 4 |
1738475 | 1738475 | 2021-09-20 | San Juan | Washington | 53055 | 279 | 0 |
1735226 | 1735226 | 2021-09-19 | San Juan | Washington | 53055 | 279 | 0 |
1731976 | 1731976 | 2021-09-18 | San Juan | Washington | 53055 | 279 | 0 |
1728726 | 1728726 | 2021-09-17 | San Juan | Washington | 53055 | 279 | 0 |
1725476 | 1725476 | 2021-09-16 | San Juan | Washington | 53055 | 279 | 0 |
1722227 | 1722227 | 2021-09-15 | San Juan | Washington | 53055 | 279 | 0 |
1715479 | 1715479 | 2021-09-13 | Sherman | Texas | 48421 | 279 | 13 |
1712233 | 1712233 | 2021-09-12 | Sherman | Texas | 48421 | 279 | 13 |
1708986 | 1708986 | 2021-09-11 | Sherman | Texas | 48421 | 279 | 13 |
1702163 | 1702163 | 2021-09-09 | Mellette | South Dakota | 46095 | 279 | 2 |
1699320 | 1699320 | 2021-09-08 | Grand Isle | Vermont | 50013 | 279 | 2 |
1696072 | 1696072 | 2021-09-07 | Grand Isle | Vermont | 50013 | 279 | 2 |
1644852 | 1644852 | 2021-08-23 | Clay | Georgia | 13061 | 279 | 3 |
1646920 | 1646920 | 2021-08-23 | Haakon | South Dakota | 46055 | 279 | 10 |
1633453 | 1633453 | 2021-08-19 | Golden Valley | North Dakota | 38033 | 279 | 3 |
1625899 | 1625899 | 2021-08-17 | Morton | Kansas | 20129 | 279 | 9 |
1627874 | 1627874 | 2021-08-17 | Bath | Virginia | 51017 | 279 | 11 |
1622652 | 1622652 | 2021-08-16 | Morton | Kansas | 20129 | 279 | 9 |
1624627 | 1624627 | 2021-08-16 | Bath | Virginia | 51017 | 279 | 11 |
1601878 | 1601878 | 2021-08-09 | St. John | Virgin Islands | 78020 | 279 | 1 |
1586351 | 1586351 | 2021-08-05 | Baker | Georgia | 13007 | 279 | 11 |
1576661 | 1576661 | 2021-08-02 | Glascock | Georgia | 13125 | 279 | 19 |
1559554 | 1559554 | 2021-07-27 | Shackelford | Texas | 48417 | 279 | 5 |
1555500 | 1555500 | 2021-07-26 | Kidder | North Dakota | 38043 | 279 | 10 |
1556307 | 1556307 | 2021-07-26 | Shackelford | Texas | 48417 | 279 | 5 |
1552253 | 1552253 | 2021-07-25 | Kidder | North Dakota | 38043 | 279 | 10 |
1553060 | 1553060 | 2021-07-25 | Shackelford | Texas | 48417 | 279 | 5 |
1549006 | 1549006 | 2021-07-24 | Kidder | North Dakota | 38043 | 279 | 10 |
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);