ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,277 rows where cases = 157 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 194
- Nebraska 115
- Georgia 78
- Kansas 49
- North Dakota 48
- Virginia 48
- Montana 41
- Illinois 38
- Kentucky 38
- North Carolina 34
- Missouri 33
- South Dakota 33
- Indiana 31
- Washington 29
- Iowa 28
- West Virginia 28
- Michigan 27
- Minnesota 27
- Puerto Rico 26
- Colorado 25
- Arkansas 23
- Tennessee 23
- Mississippi 20
- Louisiana 19
- Ohio 19
- New York 17
- Oklahoma 17
- Oregon 17
- Pennsylvania 17
- Alaska 15
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2384408 | 2384408 | 2022-04-07 | Unknown | North Dakota | 157 | 47 | |
2347133 | 2347133 | 2022-03-27 | Camas | Idaho | 16025 | 157 | 2 |
2343880 | 2343880 | 2022-03-26 | Camas | Idaho | 16025 | 157 | 2 |
2340627 | 2340627 | 2022-03-25 | Camas | Idaho | 16025 | 157 | 2 |
2337374 | 2337374 | 2022-03-24 | Camas | Idaho | 16025 | 157 | 2 |
2238764 | 2238764 | 2022-02-21 | Loving | Texas | 48301 | 157 | 0 |
2235513 | 2235513 | 2022-02-20 | Loving | Texas | 48301 | 157 | 0 |
2232262 | 2232262 | 2022-02-19 | Loving | Texas | 48301 | 157 | 0 |
2229011 | 2229011 | 2022-02-18 | Loving | Texas | 48301 | 157 | 0 |
2086655 | 2086655 | 2022-01-06 | Mineral | Colorado | 8079 | 157 | 1 |
2082715 | 2082715 | 2022-01-04 | Throckmorton | Texas | 48447 | 157 | 7 |
2079371 | 2079371 | 2022-01-03 | Kent | Texas | 48263 | 157 | 3 |
1988314 | 1988314 | 2021-12-06 | Glasscock | Texas | 48173 | 157 | 3 |
1985064 | 1985064 | 2021-12-05 | Glasscock | Texas | 48173 | 157 | 3 |
1981814 | 1981814 | 2021-12-04 | Glasscock | Texas | 48173 | 157 | 3 |
1978564 | 1978564 | 2021-12-03 | Glasscock | Texas | 48173 | 157 | 3 |
1974347 | 1974347 | 2021-12-02 | Rock | Nebraska | 31149 | 157 | 2 |
1975314 | 1975314 | 2021-12-02 | Glasscock | Texas | 48173 | 157 | 3 |
1971098 | 1971098 | 2021-12-01 | Rock | Nebraska | 31149 | 157 | 2 |
1972065 | 1972065 | 2021-12-01 | Glasscock | Texas | 48173 | 157 | 3 |
1967848 | 1967848 | 2021-11-30 | Rock | Nebraska | 31149 | 157 | 2 |
1964596 | 1964596 | 2021-11-29 | Rock | Nebraska | 31149 | 157 | 2 |
1961345 | 1961345 | 2021-11-28 | Rock | Nebraska | 31149 | 157 | 2 |
1958094 | 1958094 | 2021-11-27 | Rock | Nebraska | 31149 | 157 | 2 |
1954843 | 1954843 | 2021-11-26 | Rock | Nebraska | 31149 | 157 | 2 |
1951478 | 1951478 | 2021-11-25 | Garfield | Montana | 30033 | 157 | 3 |
1951592 | 1951592 | 2021-11-25 | Rock | Nebraska | 31149 | 157 | 2 |
1948227 | 1948227 | 2021-11-24 | Garfield | Montana | 30033 | 157 | 3 |
1948341 | 1948341 | 2021-11-24 | Rock | Nebraska | 31149 | 157 | 2 |
1944976 | 1944976 | 2021-11-23 | Garfield | Montana | 30033 | 157 | 3 |
1941725 | 1941725 | 2021-11-22 | Garfield | Montana | 30033 | 157 | 3 |
1938475 | 1938475 | 2021-11-21 | Garfield | Montana | 30033 | 157 | 3 |
1935225 | 1935225 | 2021-11-20 | Garfield | Montana | 30033 | 157 | 3 |
1931975 | 1931975 | 2021-11-19 | Garfield | Montana | 30033 | 157 | 3 |
1928724 | 1928724 | 2021-11-18 | Garfield | Montana | 30033 | 157 | 3 |
1925474 | 1925474 | 2021-11-17 | Garfield | Montana | 30033 | 157 | 3 |
1896233 | 1896233 | 2021-11-08 | Judith Basin | Montana | 30045 | 157 | 1 |
1857259 | 1857259 | 2021-10-27 | Prairie | Montana | 30079 | 157 | 2 |
1854010 | 1854010 | 2021-10-26 | Prairie | Montana | 30079 | 157 | 2 |
1854612 | 1854612 | 2021-10-26 | Sherman | Oregon | 41055 | 157 | 3 |
1850761 | 1850761 | 2021-10-25 | Prairie | Montana | 30079 | 157 | 2 |
1847511 | 1847511 | 2021-10-24 | Prairie | Montana | 30079 | 157 | 2 |
1844261 | 1844261 | 2021-10-23 | Prairie | Montana | 30079 | 157 | 2 |
1841011 | 1841011 | 2021-10-22 | Prairie | Montana | 30079 | 157 | 2 |
1837762 | 1837762 | 2021-10-21 | Prairie | Montana | 30079 | 157 | 2 |
1825605 | 1825605 | 2021-10-17 | Harding | South Dakota | 46063 | 157 | 1 |
1825608 | 1825608 | 2021-10-17 | Hyde | South Dakota | 46069 | 157 | 1 |
1822356 | 1822356 | 2021-10-16 | Harding | South Dakota | 46063 | 157 | 1 |
1822359 | 1822359 | 2021-10-16 | Hyde | South Dakota | 46069 | 157 | 1 |
1819107 | 1819107 | 2021-10-15 | Harding | South Dakota | 46063 | 157 | 1 |
1819110 | 1819110 | 2021-10-15 | Hyde | South Dakota | 46069 | 157 | 1 |
1815858 | 1815858 | 2021-10-14 | Harding | South Dakota | 46063 | 157 | 1 |
1815861 | 1815861 | 2021-10-14 | Hyde | South Dakota | 46069 | 157 | 1 |
1812613 | 1812613 | 2021-10-13 | Hyde | South Dakota | 46069 | 157 | 1 |
1809340 | 1809340 | 2021-10-12 | Campbell | South Dakota | 46021 | 157 | 4 |
1806090 | 1806090 | 2021-10-11 | Campbell | South Dakota | 46021 | 157 | 4 |
1800600 | 1800600 | 2021-10-10 | Sierra | California | 6091 | 157 | 0 |
1802840 | 1802840 | 2021-10-10 | Campbell | South Dakota | 46021 | 157 | 4 |
1797351 | 1797351 | 2021-10-09 | Sierra | California | 6091 | 157 | 0 |
1799591 | 1799591 | 2021-10-09 | Campbell | South Dakota | 46021 | 157 | 4 |
1794102 | 1794102 | 2021-10-08 | Sierra | California | 6091 | 157 | 0 |
1796342 | 1796342 | 2021-10-08 | Campbell | South Dakota | 46021 | 157 | 4 |
1762325 | 1762325 | 2021-09-28 | Lane | Kansas | 20101 | 157 | 7 |
1758384 | 1758384 | 2021-09-27 | Cheyenne | Colorado | 8017 | 157 | 7 |
1759077 | 1759077 | 2021-09-27 | Lane | Kansas | 20101 | 157 | 7 |
1733840 | 1733840 | 2021-09-19 | Frontier | Nebraska | 31063 | 157 | 1 |
1730590 | 1730590 | 2021-09-18 | Frontier | Nebraska | 31063 | 157 | 1 |
1727340 | 1727340 | 2021-09-17 | Frontier | Nebraska | 31063 | 157 | 1 |
1722651 | 1722651 | 2021-09-16 | Dolores | Colorado | 8033 | 157 | 1 |
1724091 | 1724091 | 2021-09-16 | Frontier | Nebraska | 31063 | 157 | 1 |
1725229 | 1725229 | 2021-09-16 | Sterling | Texas | 48431 | 157 | 5 |
1720842 | 1720842 | 2021-09-15 | Frontier | Nebraska | 31063 | 157 | 1 |
1721980 | 1721980 | 2021-09-15 | Sterling | Texas | 48431 | 157 | 5 |
1716154 | 1716154 | 2021-09-14 | Dolores | Colorado | 8033 | 157 | 1 |
1717594 | 1717594 | 2021-09-14 | Frontier | Nebraska | 31063 | 157 | 1 |
1718732 | 1718732 | 2021-09-14 | Sterling | Texas | 48431 | 157 | 5 |
1714346 | 1714346 | 2021-09-13 | Frontier | Nebraska | 31063 | 157 | 1 |
1715484 | 1715484 | 2021-09-13 | Sterling | Texas | 48431 | 157 | 5 |
1711100 | 1711100 | 2021-09-12 | Frontier | Nebraska | 31063 | 157 | 1 |
1712238 | 1712238 | 2021-09-12 | Sterling | Texas | 48431 | 157 | 5 |
1707853 | 1707853 | 2021-09-11 | Frontier | Nebraska | 31063 | 157 | 1 |
1708991 | 1708991 | 2021-09-11 | Sterling | Texas | 48431 | 157 | 5 |
1704606 | 1704606 | 2021-09-10 | Frontier | Nebraska | 31063 | 157 | 1 |
1705744 | 1705744 | 2021-09-10 | Sterling | Texas | 48431 | 157 | 5 |
1701356 | 1701356 | 2021-09-09 | Frontier | Nebraska | 31063 | 157 | 1 |
1702494 | 1702494 | 2021-09-09 | Sterling | Texas | 48431 | 157 | 5 |
1696926 | 1696926 | 2021-09-08 | Taliaferro | Georgia | 13265 | 157 | 3 |
1698107 | 1698107 | 2021-09-08 | Frontier | Nebraska | 31063 | 157 | 1 |
1699245 | 1699245 | 2021-09-08 | Sterling | Texas | 48431 | 157 | 5 |
1693678 | 1693678 | 2021-09-07 | Taliaferro | Georgia | 13265 | 157 | 3 |
1694859 | 1694859 | 2021-09-07 | Frontier | Nebraska | 31063 | 157 | 1 |
1695997 | 1695997 | 2021-09-07 | Sterling | Texas | 48431 | 157 | 5 |
1691548 | 1691548 | 2021-09-06 | Liberty | Montana | 30051 | 157 | 1 |
1691610 | 1691610 | 2021-09-06 | Frontier | Nebraska | 31063 | 157 | 1 |
1692749 | 1692749 | 2021-09-06 | Sterling | Texas | 48431 | 157 | 5 |
1688298 | 1688298 | 2021-09-05 | Liberty | Montana | 30051 | 157 | 1 |
1688360 | 1688360 | 2021-09-05 | Frontier | Nebraska | 31063 | 157 | 1 |
1685048 | 1685048 | 2021-09-04 | Liberty | Montana | 30051 | 157 | 1 |
1685110 | 1685110 | 2021-09-04 | Frontier | Nebraska | 31063 | 157 | 1 |
1681797 | 1681797 | 2021-09-03 | Liberty | Montana | 30051 | 157 | 1 |
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);