ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
529 rows where cases = 729 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Montana 50
- Georgia 38
- Texas 35
- Virginia 27
- Nebraska 26
- Kansas 20
- Puerto Rico 18
- South Dakota 18
- Oklahoma 17
- Kentucky 16
- New Mexico 14
- North Carolina 14
- Illinois 13
- Michigan 13
- West Virginia 13
- Indiana 12
- Louisiana 12
- Minnesota 11
- Mississippi 11
- Missouri 11
- Idaho 10
- North Dakota 10
- Wyoming 10
- Iowa 9
- Utah 9
- Colorado 8
- South Carolina 8
- Tennessee 8
- Ohio 7
- Washington 7
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2215063 | 2215063 | 2022-02-14 | Mora | New Mexico | 35033 | 729 | 16 |
2182736 | 2182736 | 2022-02-04 | Nelson | North Dakota | 38063 | 729 | 17 |
2179110 | 2179110 | 2022-02-03 | Sweet Grass | Montana | 30097 | 729 | 8 |
2166901 | 2166901 | 2022-01-30 | Aurora | South Dakota | 46003 | 729 | 17 |
2167364 | 2167364 | 2022-01-30 | St. John | Virgin Islands | 78020 | 729 | 5 |
2163646 | 2163646 | 2022-01-29 | Aurora | South Dakota | 46003 | 729 | 17 |
2164109 | 2164109 | 2022-01-29 | St. John | Virgin Islands | 78020 | 729 | 5 |
2160391 | 2160391 | 2022-01-28 | Aurora | South Dakota | 46003 | 729 | 17 |
2160854 | 2160854 | 2022-01-28 | St. John | Virgin Islands | 78020 | 729 | 5 |
2157598 | 2157598 | 2022-01-27 | St. John | Virgin Islands | 78020 | 729 | 5 |
2153432 | 2153432 | 2022-01-26 | Cavalier | North Dakota | 38019 | 729 | 7 |
2154261 | 2154261 | 2022-01-26 | Sutton | Texas | 48435 | 729 | 11 |
2148758 | 2148758 | 2022-01-25 | Oneida | Idaho | 16071 | 729 | 10 |
2146939 | 2146939 | 2022-01-24 | Hettinger | North Dakota | 38041 | 729 | 7 |
2143685 | 2143685 | 2022-01-23 | Hettinger | North Dakota | 38041 | 729 | 7 |
2115111 | 2115111 | 2022-01-14 | Haskell | Texas | 48207 | 729 | 37 |
2110997 | 2110997 | 2022-01-13 | Hamilton | New York | 36041 | 729 | 4 |
2096802 | 2096802 | 2022-01-09 | Pope | Illinois | 17151 | 729 | 7 |
2093550 | 2093550 | 2022-01-08 | Pope | Illinois | 17151 | 729 | 7 |
2090298 | 2090298 | 2022-01-07 | Pope | Illinois | 17151 | 729 | 7 |
2076053 | 2076053 | 2022-01-02 | Donley | Texas | 48129 | 729 | 18 |
2076394 | 2076394 | 2022-01-02 | Rappahannock | Virginia | 51157 | 729 | 7 |
2072493 | 2072493 | 2022-01-01 | Maunabo | Puerto Rico | 72095 | 729 | |
2072802 | 2072802 | 2022-01-01 | Donley | Texas | 48129 | 729 | 18 |
2073143 | 2073143 | 2022-01-01 | Rappahannock | Virginia | 51157 | 729 | 7 |
2069242 | 2069242 | 2021-12-31 | Maunabo | Puerto Rico | 72095 | 729 | |
2069551 | 2069551 | 2021-12-31 | Donley | Texas | 48129 | 729 | 18 |
2069892 | 2069892 | 2021-12-31 | Rappahannock | Virginia | 51157 | 729 | 7 |
2066300 | 2066300 | 2021-12-30 | Donley | Texas | 48129 | 729 | 18 |
2058885 | 2058885 | 2021-12-28 | Lincoln | Nevada | 32017 | 729 | 5 |
2049732 | 2049732 | 2021-12-25 | Jayuya | Puerto Rico | 72073 | 729 | |
2034876 | 2034876 | 2021-12-21 | Schley | Georgia | 13249 | 729 | 8 |
2032503 | 2032503 | 2021-12-20 | Red Lake | Minnesota | 27125 | 729 | 11 |
2030751 | 2030751 | 2021-12-19 | Garfield | Utah | 49017 | 729 | 12 |
2026945 | 2026945 | 2021-12-18 | Adjuntas | Puerto Rico | 72001 | 729 | |
2027500 | 2027500 | 2021-12-18 | Garfield | Utah | 49017 | 729 | 12 |
2024249 | 2024249 | 2021-12-17 | Garfield | Utah | 49017 | 729 | 12 |
2020998 | 2020998 | 2021-12-16 | Garfield | Utah | 49017 | 729 | 12 |
1969914 | 1969914 | 2021-12-01 | Bear Lake | Idaho | 16007 | 729 | 14 |
1966664 | 1966664 | 2021-11-30 | Bear Lake | Idaho | 16007 | 729 | 14 |
1963412 | 1963412 | 2021-11-29 | Bear Lake | Idaho | 16007 | 729 | 14 |
1960161 | 1960161 | 2021-11-28 | Bear Lake | Idaho | 16007 | 729 | 14 |
1956910 | 1956910 | 2021-11-27 | Bear Lake | Idaho | 16007 | 729 | 14 |
1953659 | 1953659 | 2021-11-26 | Bear Lake | Idaho | 16007 | 729 | 14 |
1955126 | 1955126 | 2021-11-26 | LaMoure | North Dakota | 38045 | 729 | 17 |
1949546 | 1949546 | 2021-11-24 | Charles City | Virginia | 51036 | 729 | 21 |
1923552 | 1923552 | 2021-11-16 | Cumberland | Virginia | 51049 | 729 | 19 |
1920303 | 1920303 | 2021-11-15 | Cumberland | Virginia | 51049 | 729 | 18 |
1914534 | 1914534 | 2021-11-14 | Echols | Georgia | 13101 | 729 | 11 |
1915849 | 1915849 | 2021-11-14 | Thayer | Nebraska | 31169 | 729 | 8 |
1911284 | 1911284 | 2021-11-13 | Echols | Georgia | 13101 | 729 | 11 |
1912599 | 1912599 | 2021-11-13 | Thayer | Nebraska | 31169 | 729 | 8 |
1908035 | 1908035 | 2021-11-12 | Echols | Georgia | 13101 | 729 | 11 |
1909349 | 1909349 | 2021-11-12 | Thayer | Nebraska | 31169 | 729 | 8 |
1904786 | 1904786 | 2021-11-11 | Echols | Georgia | 13101 | 729 | 11 |
1901536 | 1901536 | 2021-11-10 | Echols | Georgia | 13101 | 729 | 11 |
1898286 | 1898286 | 2021-11-09 | Echols | Georgia | 13101 | 729 | 11 |
1895036 | 1895036 | 2021-11-08 | Echols | Georgia | 13101 | 729 | 11 |
1891786 | 1891786 | 2021-11-07 | Echols | Georgia | 13101 | 729 | 11 |
1893607 | 1893607 | 2021-11-07 | Wallowa | Oregon | 41063 | 729 | 12 |
1888536 | 1888536 | 2021-11-06 | Echols | Georgia | 13101 | 729 | 11 |
1890357 | 1890357 | 2021-11-06 | Wallowa | Oregon | 41063 | 729 | 12 |
1885286 | 1885286 | 2021-11-05 | Echols | Georgia | 13101 | 729 | 11 |
1887107 | 1887107 | 2021-11-05 | Wallowa | Oregon | 41063 | 729 | 12 |
1854088 | 1854088 | 2021-10-26 | Morrill | Nebraska | 31123 | 729 | 16 |
1850839 | 1850839 | 2021-10-25 | Morrill | Nebraska | 31123 | 729 | 16 |
1847589 | 1847589 | 2021-10-24 | Morrill | Nebraska | 31123 | 729 | 16 |
1844339 | 1844339 | 2021-10-23 | Morrill | Nebraska | 31123 | 729 | 16 |
1841089 | 1841089 | 2021-10-22 | Morrill | Nebraska | 31123 | 729 | 16 |
1837840 | 1837840 | 2021-10-21 | Morrill | Nebraska | 31123 | 729 | 16 |
1834591 | 1834591 | 2021-10-20 | Morrill | Nebraska | 31123 | 729 | 16 |
1828011 | 1828011 | 2021-10-18 | Phillips | Montana | 30071 | 729 | 23 |
1824103 | 1824103 | 2021-10-17 | Stevens | Kansas | 20189 | 729 | 12 |
1820854 | 1820854 | 2021-10-16 | Stevens | Kansas | 20189 | 729 | 12 |
1817605 | 1817605 | 2021-10-15 | Stevens | Kansas | 20189 | 729 | 12 |
1815061 | 1815061 | 2021-10-14 | Dixon | Nebraska | 31051 | 729 | 10 |
1782208 | 1782208 | 2021-10-04 | Big Stone | Minnesota | 27011 | 729 | 4 |
1779006 | 1779006 | 2021-10-03 | Norman | Minnesota | 27107 | 729 | 9 |
1775756 | 1775756 | 2021-10-02 | Norman | Minnesota | 27107 | 729 | 9 |
1772506 | 1772506 | 2021-10-01 | Norman | Minnesota | 27107 | 729 | 9 |
1745675 | 1745675 | 2021-09-23 | Warren | Georgia | 13301 | 729 | 22 |
1741149 | 1741149 | 2021-09-21 | Moody | South Dakota | 46101 | 729 | 20 |
1702331 | 1702331 | 2021-09-09 | Crockett | Texas | 48105 | 729 | 15 |
1692394 | 1692394 | 2021-09-06 | Fall River | South Dakota | 46047 | 729 | 17 |
1689145 | 1689145 | 2021-09-05 | Fall River | South Dakota | 46047 | 729 | 17 |
1689661 | 1689661 | 2021-09-05 | Madison | Virginia | 51113 | 729 | 17 |
1685895 | 1685895 | 2021-09-04 | Fall River | South Dakota | 46047 | 729 | 17 |
1686411 | 1686411 | 2021-09-04 | Madison | Virginia | 51113 | 729 | 17 |
1682644 | 1682644 | 2021-09-03 | Fall River | South Dakota | 46047 | 729 | 17 |
1683160 | 1683160 | 2021-09-03 | Madison | Virginia | 51113 | 729 | 17 |
1674351 | 1674351 | 2021-09-01 | Stark | Illinois | 17175 | 729 | 26 |
1676054 | 1676054 | 2021-09-01 | Sabana Grande | Puerto Rico | 72121 | 729 | |
1671102 | 1671102 | 2021-08-31 | Stark | Illinois | 17175 | 729 | 26 |
1673141 | 1673141 | 2021-08-31 | Hartley | Texas | 48205 | 729 | 2 |
1669893 | 1669893 | 2021-08-30 | Hartley | Texas | 48205 | 729 | 2 |
1666646 | 1666646 | 2021-08-29 | Hartley | Texas | 48205 | 729 | 2 |
1663398 | 1663398 | 2021-08-28 | Hartley | Texas | 48205 | 729 | 2 |
1634681 | 1634681 | 2021-08-19 | Weston | Wyoming | 56045 | 729 | 6 |
1630985 | 1630985 | 2021-08-18 | Newton | Texas | 48351 | 729 | 38 |
1626596 | 1626596 | 2021-08-17 | Sanders | Montana | 30089 | 729 | 15 |
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);