ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
816 rows where cases = 275 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 70
- South Dakota 53
- Georgia 51
- Kansas 44
- Virginia 42
- North Dakota 30
- Missouri 27
- Nebraska 27
- Puerto Rico 27
- Iowa 22
- Arkansas 21
- Colorado 21
- Montana 21
- Illinois 20
- Indiana 20
- Mississippi 20
- New York 20
- Idaho 18
- Alaska 17
- North Carolina 17
- Alabama 16
- Kentucky 16
- Minnesota 16
- Washington 16
- Ohio 15
- Michigan 14
- Oregon 12
- California 11
- Florida 11
- Oklahoma 11
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2273815 | 2273815 | 2022-03-04 | Unknown | Northern Mariana Islands | 275 | 0 | |
2257734 | 2257734 | 2022-02-27 | Gilliam | Oregon | 41021 | 275 | 5 |
2254483 | 2254483 | 2022-02-26 | Gilliam | Oregon | 41021 | 275 | 5 |
2251232 | 2251232 | 2022-02-25 | Gilliam | Oregon | 41021 | 275 | 5 |
2247981 | 2247981 | 2022-02-24 | Gilliam | Oregon | 41021 | 275 | 5 |
2244730 | 2244730 | 2022-02-23 | Gilliam | Oregon | 41021 | 275 | 5 |
2241915 | 2241915 | 2022-02-22 | Cottle | Texas | 48101 | 275 | 9 |
2238664 | 2238664 | 2022-02-21 | Cottle | Texas | 48101 | 275 | 9 |
2235413 | 2235413 | 2022-02-20 | Cottle | Texas | 48101 | 275 | 9 |
2232162 | 2232162 | 2022-02-19 | Cottle | Texas | 48101 | 275 | 9 |
2228911 | 2228911 | 2022-02-18 | Cottle | Texas | 48101 | 275 | 9 |
2225660 | 2225660 | 2022-02-17 | Cottle | Texas | 48101 | 275 | 9 |
2222409 | 2222409 | 2022-02-16 | Cottle | Texas | 48101 | 275 | 9 |
2219158 | 2219158 | 2022-02-15 | Cottle | Texas | 48101 | 275 | 9 |
2215907 | 2215907 | 2022-02-14 | Cottle | Texas | 48101 | 275 | 9 |
2212656 | 2212656 | 2022-02-13 | Cottle | Texas | 48101 | 275 | 9 |
2209403 | 2209403 | 2022-02-12 | Cottle | Texas | 48101 | 275 | 9 |
2206150 | 2206150 | 2022-02-11 | Cottle | Texas | 48101 | 275 | 9 |
2202897 | 2202897 | 2022-02-10 | Cottle | Texas | 48101 | 275 | 9 |
2199643 | 2199643 | 2022-02-09 | Cottle | Texas | 48101 | 275 | 9 |
2196389 | 2196389 | 2022-02-08 | Cottle | Texas | 48101 | 275 | 9 |
2193135 | 2193135 | 2022-02-07 | Cottle | Texas | 48101 | 275 | 9 |
2189881 | 2189881 | 2022-02-06 | Cottle | Texas | 48101 | 275 | 9 |
2186628 | 2186628 | 2022-02-05 | Cottle | Texas | 48101 | 275 | 9 |
2147810 | 2147810 | 2022-01-24 | Piute | Utah | 49031 | 275 | 5 |
2144556 | 2144556 | 2022-01-23 | Piute | Utah | 49031 | 275 | 5 |
2141301 | 2141301 | 2022-01-22 | Piute | Utah | 49031 | 275 | 5 |
2138045 | 2138045 | 2022-01-21 | Piute | Utah | 49031 | 275 | 5 |
2128231 | 2128231 | 2022-01-18 | Stonewall | Texas | 48433 | 275 | 6 |
2123915 | 2123915 | 2022-01-17 | Storey | Nevada | 32029 | 275 | 8 |
2124979 | 2124979 | 2022-01-17 | Stonewall | Texas | 48433 | 275 | 6 |
2120663 | 2120663 | 2022-01-16 | Storey | Nevada | 32029 | 275 | 8 |
2117411 | 2117411 | 2022-01-15 | Storey | Nevada | 32029 | 275 | 8 |
2114160 | 2114160 | 2022-01-14 | Storey | Nevada | 32029 | 275 | 8 |
2089017 | 2089017 | 2022-01-06 | Briscoe | Texas | 48045 | 275 | 7 |
2076435 | 2076435 | 2022-01-02 | Garfield | Washington | 53023 | 275 | 7 |
2073184 | 2073184 | 2022-01-01 | Garfield | Washington | 53023 | 275 | 7 |
2069933 | 2069933 | 2021-12-31 | Garfield | Washington | 53023 | 275 | 7 |
2066682 | 2066682 | 2021-12-30 | Garfield | Washington | 53023 | 275 | 7 |
2052280 | 2052280 | 2021-12-26 | Wheatland | Montana | 30107 | 275 | 13 |
2049030 | 2049030 | 2021-12-25 | Wheatland | Montana | 30107 | 275 | 13 |
2045780 | 2045780 | 2021-12-24 | Wheatland | Montana | 30107 | 275 | 13 |
2042530 | 2042530 | 2021-12-23 | Wheatland | Montana | 30107 | 275 | 13 |
2034625 | 2034625 | 2021-12-21 | Dolores | Colorado | 8033 | 275 | 5 |
2033801 | 2033801 | 2021-12-20 | Dickens | Texas | 48125 | 275 | 15 |
2030551 | 2030551 | 2021-12-19 | Dickens | Texas | 48125 | 275 | 15 |
2027300 | 2027300 | 2021-12-18 | Dickens | Texas | 48125 | 275 | 15 |
2005382 | 2005382 | 2021-12-12 | Kiowa | Colorado | 8061 | 275 | 4 |
2002131 | 2002131 | 2021-12-11 | Kiowa | Colorado | 8061 | 275 | 4 |
1998881 | 1998881 | 2021-12-10 | Kiowa | Colorado | 8061 | 275 | 4 |
1995630 | 1995630 | 2021-12-09 | Kiowa | Colorado | 8061 | 275 | 4 |
1997061 | 1997061 | 2021-12-09 | Gosper | Nebraska | 31073 | 275 | 7 |
1998251 | 1998251 | 2021-12-09 | Rich | Utah | 49033 | 275 | 0 |
1992379 | 1992379 | 2021-12-08 | Kiowa | Colorado | 8061 | 275 | 4 |
1993810 | 1993810 | 2021-12-08 | Gosper | Nebraska | 31073 | 275 | 7 |
1995000 | 1995000 | 2021-12-08 | Rich | Utah | 49033 | 275 | 0 |
1983996 | 1983996 | 2021-12-05 | Meagher | Montana | 30059 | 275 | 9 |
1980746 | 1980746 | 2021-12-04 | Meagher | Montana | 30059 | 275 | 9 |
1977496 | 1977496 | 2021-12-03 | Meagher | Montana | 30059 | 275 | 9 |
1972696 | 1972696 | 2021-12-02 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 275 | 3 |
1973146 | 1973146 | 2021-12-02 | Webster | Georgia | 13307 | 275 | 6 |
1969446 | 1969446 | 2021-12-01 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 275 | 3 |
1972261 | 1972261 | 2021-12-01 | Wayne | Utah | 49055 | 275 | 0 |
1966196 | 1966196 | 2021-11-30 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 275 | 3 |
1969011 | 1969011 | 2021-11-30 | Wayne | Utah | 49055 | 275 | 0 |
1962944 | 1962944 | 2021-11-29 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 275 | 3 |
1959693 | 1959693 | 2021-11-28 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 275 | 3 |
1956442 | 1956442 | 2021-11-27 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 275 | 3 |
1953191 | 1953191 | 2021-11-26 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 275 | 3 |
1938522 | 1938522 | 2021-11-21 | Boyd | Nebraska | 31015 | 275 | 4 |
1935272 | 1935272 | 2021-11-20 | Boyd | Nebraska | 31015 | 275 | 4 |
1932022 | 1932022 | 2021-11-19 | Boyd | Nebraska | 31015 | 275 | 4 |
1929501 | 1929501 | 2021-11-18 | Vieques | Puerto Rico | 72147 | 275 | |
1926251 | 1926251 | 2021-11-17 | Vieques | Puerto Rico | 72147 | 275 | |
1915437 | 1915437 | 2021-11-14 | Cook | Minnesota | 27031 | 275 | 0 |
1912187 | 1912187 | 2021-11-13 | Cook | Minnesota | 27031 | 275 | 0 |
1908937 | 1908937 | 2021-11-12 | Cook | Minnesota | 27031 | 275 | 0 |
1860566 | 1860566 | 2021-10-28 | Harlan | Nebraska | 31083 | 275 | 0 |
1857317 | 1857317 | 2021-10-27 | Harlan | Nebraska | 31083 | 275 | 0 |
1846847 | 1846847 | 2021-10-24 | Stanton | Kansas | 20187 | 275 | 6 |
1843597 | 1843597 | 2021-10-23 | Stanton | Kansas | 20187 | 275 | 6 |
1840347 | 1840347 | 2021-10-22 | Stanton | Kansas | 20187 | 275 | 6 |
1824033 | 1824033 | 2021-10-17 | Elk | Kansas | 20049 | 275 | 6 |
1820784 | 1820784 | 2021-10-16 | Elk | Kansas | 20049 | 275 | 6 |
1817535 | 1817535 | 2021-10-15 | Elk | Kansas | 20049 | 275 | 6 |
1808928 | 1808928 | 2021-10-12 | Saipan | Northern Mariana Islands | 69110 | 275 | 3 |
1769900 | 1769900 | 2021-09-30 | Grant | North Dakota | 38037 | 275 | 7 |
1763057 | 1763057 | 2021-09-28 | Brown | Nebraska | 31017 | 275 | 4 |
1739206 | 1739206 | 2021-09-21 | Butte | Idaho | 16023 | 275 | 1 |
1733079 | 1733079 | 2021-09-19 | Jewell | Kansas | 20089 | 275 | 6 |
1729829 | 1729829 | 2021-09-18 | Jewell | Kansas | 20089 | 275 | 6 |
1726579 | 1726579 | 2021-09-17 | Jewell | Kansas | 20089 | 275 | 6 |
1724023 | 1724023 | 2021-09-16 | Granite | Montana | 30039 | 275 | 2 |
1693733 | 1693733 | 2021-09-07 | Custer | Idaho | 16037 | 275 | 3 |
1690484 | 1690484 | 2021-09-06 | Custer | Idaho | 16037 | 275 | 3 |
1687234 | 1687234 | 2021-09-05 | Custer | Idaho | 16037 | 275 | 3 |
1683984 | 1683984 | 2021-09-04 | Custer | Idaho | 16037 | 275 | 3 |
1680733 | 1680733 | 2021-09-03 | Custer | Idaho | 16037 | 275 | 3 |
1677485 | 1677485 | 2021-09-02 | Custer | Idaho | 16037 | 275 | 3 |
1674238 | 1674238 | 2021-09-01 | Custer | Idaho | 16037 | 275 | 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);