ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
860 rows where cases = 239 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
These facets timed out: county, fips
state >30
- Texas 81
- Nebraska 73
- Georgia 67
- Kentucky 42
- Virginia 38
- Colorado 33
- Indiana 30
- Kansas 28
- Puerto Rico 28
- North Carolina 27
- South Dakota 24
- Missouri 23
- Oklahoma 23
- New York 21
- Michigan 19
- Iowa 18
- Pennsylvania 18
- Washington 18
- Tennessee 17
- Minnesota 16
- Wisconsin 16
- Illinois 15
- Louisiana 15
- Montana 15
- Arkansas 14
- Idaho 14
- Mississippi 14
- Nevada 14
- North Dakota 14
- Ohio 14
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2406627 | 2406627 | 2022-04-14 | Unknown | Mississippi | 239 | 7 | |
2179970 | 2179970 | 2022-02-03 | Sully | South Dakota | 46119 | 239 | 3 |
2175849 | 2175849 | 2022-02-02 | Prairie | Montana | 30079 | 239 | 3 |
2176719 | 2176719 | 2022-02-02 | Sully | South Dakota | 46119 | 239 | 3 |
2172596 | 2172596 | 2022-02-01 | Prairie | Montana | 30079 | 239 | 3 |
2173465 | 2173465 | 2022-02-01 | Sully | South Dakota | 46119 | 239 | 3 |
2169132 | 2169132 | 2022-01-31 | Issaquena | Mississippi | 28055 | 239 | 7 |
2160768 | 2160768 | 2022-01-28 | Sterling | Texas | 48431 | 239 | 5 |
2147154 | 2147154 | 2022-01-24 | Gilliam | Oregon | 41021 | 239 | 4 |
2027937 | 2027937 | 2021-12-19 | Haines Borough | Alaska | 2100 | 239 | 1 |
2024686 | 2024686 | 2021-12-18 | Haines Borough | Alaska | 2100 | 239 | 1 |
2021435 | 2021435 | 2021-12-17 | Haines Borough | Alaska | 2100 | 239 | 1 |
2013387 | 2013387 | 2021-12-14 | Storey | Nevada | 32029 | 239 | 8 |
2010136 | 2010136 | 2021-12-13 | Storey | Nevada | 32029 | 239 | 8 |
2006885 | 2006885 | 2021-12-12 | Storey | Nevada | 32029 | 239 | 8 |
2003634 | 2003634 | 2021-12-11 | Storey | Nevada | 32029 | 239 | 8 |
2000384 | 2000384 | 2021-12-10 | Storey | Nevada | 32029 | 239 | 8 |
1997133 | 1997133 | 2021-12-09 | Storey | Nevada | 32029 | 239 | 8 |
1998197 | 1998197 | 2021-12-09 | Stonewall | Texas | 48433 | 239 | 6 |
1993882 | 1993882 | 2021-12-08 | Storey | Nevada | 32029 | 239 | 8 |
1994946 | 1994946 | 2021-12-08 | Stonewall | Texas | 48433 | 239 | 6 |
1989106 | 1989106 | 2021-12-07 | Cheyenne | Colorado | 8017 | 239 | 7 |
1990631 | 1990631 | 2021-12-07 | Storey | Nevada | 32029 | 239 | 6 |
1991695 | 1991695 | 2021-12-07 | Stonewall | Texas | 48433 | 239 | 6 |
1985856 | 1985856 | 2021-12-06 | Cheyenne | Colorado | 8017 | 239 | 7 |
1987381 | 1987381 | 2021-12-06 | Storey | Nevada | 32029 | 239 | 6 |
1984131 | 1984131 | 2021-12-05 | Storey | Nevada | 32029 | 239 | 6 |
1980881 | 1980881 | 2021-12-04 | Storey | Nevada | 32029 | 239 | 6 |
1977631 | 1977631 | 2021-12-03 | Storey | Nevada | 32029 | 239 | 6 |
1962276 | 1962276 | 2021-11-28 | Cottle | Texas | 48101 | 239 | 9 |
1959025 | 1959025 | 2021-11-27 | Cottle | Texas | 48101 | 239 | 9 |
1955774 | 1955774 | 2021-11-26 | Cottle | Texas | 48101 | 239 | 9 |
1952523 | 1952523 | 2021-11-25 | Cottle | Texas | 48101 | 239 | 9 |
1949272 | 1949272 | 2021-11-24 | Cottle | Texas | 48101 | 239 | 9 |
1946021 | 1946021 | 2021-11-23 | Cottle | Texas | 48101 | 239 | 9 |
1942770 | 1942770 | 2021-11-22 | Cottle | Texas | 48101 | 239 | 9 |
1939520 | 1939520 | 2021-11-21 | Cottle | Texas | 48101 | 239 | 9 |
1936270 | 1936270 | 2021-11-20 | Cottle | Texas | 48101 | 239 | 9 |
1933020 | 1933020 | 2021-11-19 | Cottle | Texas | 48101 | 239 | 9 |
1928798 | 1928798 | 2021-11-18 | Garden | Nebraska | 31069 | 239 | 1 |
1929769 | 1929769 | 2021-11-18 | Cottle | Texas | 48101 | 239 | 9 |
1925548 | 1925548 | 2021-11-17 | Garden | Nebraska | 31069 | 239 | 1 |
1926519 | 1926519 | 2021-11-17 | Cottle | Texas | 48101 | 239 | 9 |
1922299 | 1922299 | 2021-11-16 | Garden | Nebraska | 31069 | 239 | 1 |
1919049 | 1919049 | 2021-11-15 | Garden | Nebraska | 31069 | 239 | 1 |
1915799 | 1915799 | 2021-11-14 | Garden | Nebraska | 31069 | 239 | 1 |
1912549 | 1912549 | 2021-11-13 | Garden | Nebraska | 31069 | 239 | 1 |
1909299 | 1909299 | 2021-11-12 | Garden | Nebraska | 31069 | 239 | 1 |
1906050 | 1906050 | 2021-11-11 | Garden | Nebraska | 31069 | 239 | 1 |
1902801 | 1902801 | 2021-11-10 | Garden | Nebraska | 31069 | 239 | 1 |
1881859 | 1881859 | 2021-11-04 | Dolores | Colorado | 8033 | 239 | 3 |
1878610 | 1878610 | 2021-11-03 | Dolores | Colorado | 8033 | 239 | 3 |
1875361 | 1875361 | 2021-11-02 | Dolores | Colorado | 8033 | 239 | 3 |
1839015 | 1839015 | 2021-10-21 | Wayne | Utah | 49055 | 239 | 0 |
1835766 | 1835766 | 2021-10-20 | Wayne | Utah | 49055 | 239 | 0 |
1831317 | 1831317 | 2021-10-19 | Gosper | Nebraska | 31073 | 239 | 5 |
1828068 | 1828068 | 2021-10-18 | Gosper | Nebraska | 31073 | 239 | 5 |
1829432 | 1829432 | 2021-10-18 | Garfield | Washington | 53023 | 239 | 7 |
1826183 | 1826183 | 2021-10-17 | Garfield | Washington | 53023 | 239 | 7 |
1822934 | 1822934 | 2021-10-16 | Garfield | Washington | 53023 | 239 | 7 |
1819685 | 1819685 | 2021-10-15 | Garfield | Washington | 53023 | 239 | 7 |
1805261 | 1805261 | 2021-10-11 | Meagher | Montana | 30059 | 239 | 8 |
1802012 | 1802012 | 2021-10-10 | Meagher | Montana | 30059 | 239 | 8 |
1798763 | 1798763 | 2021-10-09 | Meagher | Montana | 30059 | 239 | 8 |
1799170 | 1799170 | 2021-10-09 | Steele | North Dakota | 38091 | 239 | 2 |
1795514 | 1795514 | 2021-10-08 | Meagher | Montana | 30059 | 239 | 8 |
1792265 | 1792265 | 2021-10-07 | Meagher | Montana | 30059 | 239 | 8 |
1788996 | 1788996 | 2021-10-06 | Daniels | Montana | 30019 | 239 | 9 |
1759835 | 1759835 | 2021-09-27 | Garfield | Nebraska | 31071 | 239 | 1 |
1756587 | 1756587 | 2021-09-26 | Garfield | Nebraska | 31071 | 239 | 1 |
1757975 | 1757975 | 2021-09-26 | Wahkiakum | Washington | 53069 | 239 | 5 |
1753339 | 1753339 | 2021-09-25 | Garfield | Nebraska | 31071 | 239 | 1 |
1754727 | 1754727 | 2021-09-25 | Wahkiakum | Washington | 53069 | 239 | 5 |
1750091 | 1750091 | 2021-09-24 | Garfield | Nebraska | 31071 | 239 | 1 |
1751479 | 1751479 | 2021-09-24 | Wahkiakum | Washington | 53069 | 239 | 5 |
1708175 | 1708175 | 2021-09-11 | Grant | North Dakota | 38037 | 239 | 7 |
1680478 | 1680478 | 2021-09-03 | Unknown | Delaware | 239 | 0 | |
1677907 | 1677907 | 2021-09-02 | Wichita | Kansas | 20203 | 239 | 5 |
1679539 | 1679539 | 2021-09-02 | Armstrong | Texas | 48011 | 239 | 7 |
1674660 | 1674660 | 2021-09-01 | Wichita | Kansas | 20203 | 239 | 5 |
1671411 | 1671411 | 2021-08-31 | Wichita | Kansas | 20203 | 239 | 5 |
1673480 | 1673480 | 2021-08-31 | Columbia | Washington | 53013 | 239 | 6 |
1668164 | 1668164 | 2021-08-30 | Wichita | Kansas | 20203 | 239 | 5 |
1664917 | 1664917 | 2021-08-29 | Wichita | Kansas | 20203 | 239 | 5 |
1661669 | 1661669 | 2021-08-28 | Wichita | Kansas | 20203 | 239 | 5 |
1658421 | 1658421 | 2021-08-27 | Wichita | Kansas | 20203 | 239 | 5 |
1655173 | 1655173 | 2021-08-26 | Wichita | Kansas | 20203 | 239 | 5 |
1651926 | 1651926 | 2021-08-25 | Wichita | Kansas | 20203 | 239 | 5 |
1640847 | 1640847 | 2021-08-21 | Grand Isle | Vermont | 50013 | 239 | 2 |
1637597 | 1637597 | 2021-08-20 | Grand Isle | Vermont | 50013 | 239 | 2 |
1607084 | 1607084 | 2021-08-11 | Granite | Montana | 30039 | 239 | 2 |
1604990 | 1604990 | 2021-08-10 | Menard | Texas | 48327 | 239 | 9 |
1601741 | 1601741 | 2021-08-09 | Menard | Texas | 48327 | 239 | 9 |
1595963 | 1595963 | 2021-08-08 | Custer | Colorado | 8027 | 239 | 3 |
1596007 | 1596007 | 2021-08-08 | Sedgwick | Colorado | 8115 | 239 | 3 |
1598493 | 1598493 | 2021-08-08 | Menard | Texas | 48327 | 239 | 9 |
1592714 | 1592714 | 2021-08-07 | Custer | Colorado | 8027 | 239 | 3 |
1592758 | 1592758 | 2021-08-07 | Sedgwick | Colorado | 8115 | 239 | 3 |
1589465 | 1589465 | 2021-08-06 | Custer | Colorado | 8027 | 239 | 3 |
1589509 | 1589509 | 2021-08-06 | Sedgwick | Colorado | 8115 | 239 | 3 |
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);