ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,085 rows where cases = 271 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kansas 273
- Georgia 68
- Texas 66
- North Dakota 51
- Virginia 49
- Nebraska 42
- Montana 41
- South Dakota 33
- North Carolina 25
- Puerto Rico 24
- Arkansas 23
- Minnesota 23
- Indiana 22
- Missouri 22
- Colorado 21
- New York 21
- Ohio 20
- Washington 19
- Iowa 18
- Oregon 17
- Kentucky 16
- Mississippi 15
- Illinois 14
- West Virginia 14
- Pennsylvania 13
- Michigan 12
- Oklahoma 11
- Alabama 9
- Florida 9
- Idaho 9
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502431 | 2502431 | 2022-05-13 | Throckmorton | Texas | 48447 | 271 | 8 |
2499173 | 2499173 | 2022-05-12 | Throckmorton | Texas | 48447 | 271 | 8 |
2495915 | 2495915 | 2022-05-11 | Throckmorton | Texas | 48447 | 271 | 8 |
2492657 | 2492657 | 2022-05-10 | Throckmorton | Texas | 48447 | 271 | 8 |
2307072 | 2307072 | 2022-03-14 | Motley | Texas | 48345 | 271 | 13 |
2303821 | 2303821 | 2022-03-13 | Motley | Texas | 48345 | 271 | 13 |
2300569 | 2300569 | 2022-03-12 | Motley | Texas | 48345 | 271 | 13 |
2297317 | 2297317 | 2022-03-11 | Motley | Texas | 48345 | 271 | 13 |
2294065 | 2294065 | 2022-03-10 | Motley | Texas | 48345 | 271 | 13 |
2290813 | 2290813 | 2022-03-09 | Motley | Texas | 48345 | 271 | 12 |
2221973 | 2221973 | 2022-02-16 | Gilliam | Oregon | 41021 | 271 | 4 |
2218722 | 2218722 | 2022-02-15 | Gilliam | Oregon | 41021 | 271 | 4 |
2202461 | 2202461 | 2022-02-10 | Gilliam | Oregon | 41021 | 271 | 4 |
2199207 | 2199207 | 2022-02-09 | Gilliam | Oregon | 41021 | 271 | 4 |
2195953 | 2195953 | 2022-02-08 | Gilliam | Oregon | 41021 | 271 | 4 |
2172990 | 2172990 | 2022-02-01 | Sheridan | North Dakota | 38083 | 271 | 6 |
2163858 | 2163858 | 2022-01-29 | Cottle | Texas | 48101 | 271 | 9 |
2150663 | 2150663 | 2022-01-25 | Hyde | South Dakota | 46069 | 271 | 5 |
2119138 | 2119138 | 2022-01-16 | Cheyenne | Colorado | 8017 | 271 | 9 |
2120579 | 2120579 | 2022-01-16 | Deuel | Nebraska | 31049 | 271 | 2 |
2121727 | 2121727 | 2022-01-16 | Stonewall | Texas | 48433 | 271 | 6 |
2115886 | 2115886 | 2022-01-15 | Cheyenne | Colorado | 8017 | 271 | 9 |
2117327 | 2117327 | 2022-01-15 | Deuel | Nebraska | 31049 | 271 | 2 |
2118475 | 2118475 | 2022-01-15 | Stonewall | Texas | 48433 | 271 | 6 |
2112635 | 2112635 | 2022-01-14 | Cheyenne | Colorado | 8017 | 271 | 9 |
2114076 | 2114076 | 2022-01-14 | Deuel | Nebraska | 31049 | 271 | 2 |
2110824 | 2110824 | 2022-01-13 | Deuel | Nebraska | 31049 | 271 | 2 |
2110908 | 2110908 | 2022-01-13 | Storey | Nevada | 32029 | 271 | 8 |
2112118 | 2112118 | 2022-01-13 | Highland | Virginia | 51091 | 271 | 4 |
2029561 | 2029561 | 2021-12-19 | Dundy | Nebraska | 31057 | 271 | 5 |
2030935 | 2030935 | 2021-12-19 | Garfield | Washington | 53023 | 271 | 7 |
2026310 | 2026310 | 2021-12-18 | Dundy | Nebraska | 31057 | 271 | 5 |
2027684 | 2027684 | 2021-12-18 | Garfield | Washington | 53023 | 271 | 7 |
2023059 | 2023059 | 2021-12-17 | Dundy | Nebraska | 31057 | 271 | 5 |
2024433 | 2024433 | 2021-12-17 | Garfield | Washington | 53023 | 271 | 7 |
2019808 | 2019808 | 2021-12-16 | Dundy | Nebraska | 31057 | 271 | 5 |
2021182 | 2021182 | 2021-12-16 | Garfield | Washington | 53023 | 271 | 7 |
2016558 | 2016558 | 2021-12-15 | Dundy | Nebraska | 31057 | 271 | 5 |
2017547 | 2017547 | 2021-12-15 | Dickens | Texas | 48125 | 271 | 14 |
2013307 | 2013307 | 2021-12-14 | Dundy | Nebraska | 31057 | 271 | 5 |
2014297 | 2014297 | 2021-12-14 | Dickens | Texas | 48125 | 271 | 14 |
2010056 | 2010056 | 2021-12-13 | Dundy | Nebraska | 31057 | 271 | 5 |
2005368 | 2005368 | 2021-12-12 | Dolores | Colorado | 8033 | 271 | 5 |
2002117 | 2002117 | 2021-12-11 | Dolores | Colorado | 8033 | 271 | 5 |
1998867 | 1998867 | 2021-12-10 | Dolores | Colorado | 8033 | 271 | 5 |
1984020 | 1984020 | 2021-12-05 | Wheatland | Montana | 30107 | 271 | 13 |
1980770 | 1980770 | 2021-12-04 | Wheatland | Montana | 30107 | 271 | 13 |
1977520 | 1977520 | 2021-12-03 | Wheatland | Montana | 30107 | 271 | 13 |
1974270 | 1974270 | 2021-12-02 | Wheatland | Montana | 30107 | 271 | 13 |
1970966 | 1970966 | 2021-12-01 | Worth | Missouri | 29227 | 271 | 2 |
1971021 | 1971021 | 2021-12-01 | Wheatland | Montana | 30107 | 271 | 13 |
1972249 | 1972249 | 2021-12-01 | Rich | Utah | 49033 | 271 | 0 |
1967771 | 1967771 | 2021-11-30 | Wheatland | Montana | 30107 | 271 | 13 |
1968999 | 1968999 | 2021-11-30 | Rich | Utah | 49033 | 271 | 0 |
1961244 | 1961244 | 2021-11-28 | Meagher | Montana | 30059 | 271 | 9 |
1957993 | 1957993 | 2021-11-27 | Meagher | Montana | 30059 | 271 | 9 |
1954742 | 1954742 | 2021-11-26 | Meagher | Montana | 30059 | 271 | 9 |
1952755 | 1952755 | 2021-11-25 | Wayne | Utah | 49055 | 271 | 0 |
1949504 | 1949504 | 2021-11-24 | Wayne | Utah | 49055 | 271 | 0 |
1936938 | 1936938 | 2021-11-21 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 271 | 3 |
1937388 | 1937388 | 2021-11-21 | Webster | Georgia | 13307 | 271 | 6 |
1938550 | 1938550 | 2021-11-21 | Garfield | Nebraska | 31071 | 271 | 2 |
1933688 | 1933688 | 2021-11-20 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 271 | 3 |
1934138 | 1934138 | 2021-11-20 | Webster | Georgia | 13307 | 271 | 6 |
1935300 | 1935300 | 2021-11-20 | Garfield | Nebraska | 31071 | 271 | 2 |
1930436 | 1930436 | 2021-11-19 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 271 | 3 |
1930886 | 1930886 | 2021-11-19 | Webster | Georgia | 13307 | 271 | 6 |
1932050 | 1932050 | 2021-11-19 | Garfield | Nebraska | 31071 | 271 | 2 |
1927636 | 1927636 | 2021-11-18 | Webster | Georgia | 13307 | 271 | 6 |
1929144 | 1929144 | 2021-11-18 | Steele | North Dakota | 38091 | 271 | 2 |
1924386 | 1924386 | 2021-11-17 | Webster | Georgia | 13307 | 271 | 6 |
1925521 | 1925521 | 2021-11-17 | Boyd | Nebraska | 31015 | 271 | 4 |
1921137 | 1921137 | 2021-11-16 | Webster | Georgia | 13307 | 271 | 6 |
1873493 | 1873493 | 2021-11-01 | McCone | Montana | 30055 | 271 | 3 |
1854068 | 1854068 | 2021-10-26 | Harlan | Nebraska | 31083 | 271 | 0 |
1850819 | 1850819 | 2021-10-25 | Harlan | Nebraska | 31083 | 271 | 0 |
1846770 | 1846770 | 2021-10-24 | Comanche | Kansas | 20033 | 271 | 12 |
1847509 | 1847509 | 2021-10-24 | Powder River | Montana | 30075 | 271 | 9 |
1847569 | 1847569 | 2021-10-24 | Harlan | Nebraska | 31083 | 271 | 0 |
1843520 | 1843520 | 2021-10-23 | Comanche | Kansas | 20033 | 271 | 12 |
1844259 | 1844259 | 2021-10-23 | Powder River | Montana | 30075 | 271 | 9 |
1844319 | 1844319 | 2021-10-23 | Harlan | Nebraska | 31083 | 271 | 0 |
1840270 | 1840270 | 2021-10-22 | Comanche | Kansas | 20033 | 271 | 12 |
1841009 | 1841009 | 2021-10-22 | Powder River | Montana | 30075 | 271 | 9 |
1841069 | 1841069 | 2021-10-22 | Harlan | Nebraska | 31083 | 271 | 0 |
1837042 | 1837042 | 2021-10-21 | Hamilton | Kansas | 20075 | 271 | 1 |
1837760 | 1837760 | 2021-10-21 | Powder River | Montana | 30075 | 271 | 9 |
1837820 | 1837820 | 2021-10-21 | Harlan | Nebraska | 31083 | 271 | 0 |
1833793 | 1833793 | 2021-10-20 | Hamilton | Kansas | 20075 | 271 | 1 |
1830600 | 1830600 | 2021-10-19 | Stanton | Kansas | 20187 | 271 | 6 |
1827351 | 1827351 | 2021-10-18 | Stanton | Kansas | 20187 | 271 | 6 |
1829455 | 1829455 | 2021-10-18 | Wahkiakum | Washington | 53069 | 271 | 5 |
1824102 | 1824102 | 2021-10-17 | Stanton | Kansas | 20187 | 271 | 6 |
1826206 | 1826206 | 2021-10-17 | Wahkiakum | Washington | 53069 | 271 | 5 |
1820853 | 1820853 | 2021-10-16 | Stanton | Kansas | 20187 | 271 | 6 |
1822957 | 1822957 | 2021-10-16 | Wahkiakum | Washington | 53069 | 271 | 5 |
1817604 | 1817604 | 2021-10-15 | Stanton | Kansas | 20187 | 271 | 6 |
1819708 | 1819708 | 2021-10-15 | Wahkiakum | Washington | 53069 | 271 | 5 |
1807789 | 1807789 | 2021-10-12 | Elk | Kansas | 20049 | 271 | 6 |
1809498 | 1809498 | 2021-10-12 | Armstrong | Texas | 48011 | 271 | 7 |
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);