ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
701 rows where cases = 337 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 67
- South Dakota 48
- Kansas 44
- Virginia 39
- Georgia 31
- Iowa 24
- Oklahoma 24
- Nebraska 23
- Colorado 22
- Kentucky 22
- Missouri 21
- North Dakota 21
- Ohio 21
- Arkansas 20
- Idaho 19
- Illinois 19
- North Carolina 17
- Virgin Islands 17
- Indiana 15
- Michigan 13
- Mississippi 13
- Washington 13
- Minnesota 12
- New York 12
- Alaska 9
- Tennessee 9
- Alabama 8
- Florida 8
- Louisiana 8
- New Mexico 7
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2339703 | 2339703 | 2022-03-24 | Rich | Utah | 49033 | 337 | 0 |
2336449 | 2336449 | 2022-03-23 | Rich | Utah | 49033 | 337 | 0 |
2333195 | 2333195 | 2022-03-22 | Rich | Utah | 49033 | 337 | 0 |
2187466 | 2187466 | 2022-02-06 | Dolores | Colorado | 8033 | 337 | 7 |
2184213 | 2184213 | 2022-02-05 | Dolores | Colorado | 8033 | 337 | 7 |
2180961 | 2180961 | 2022-02-04 | Dolores | Colorado | 8033 | 337 | 7 |
2180436 | 2180436 | 2022-02-03 | Highland | Virginia | 51091 | 337 | 5 |
2154742 | 2154742 | 2022-01-27 | Denali Borough | Alaska | 2068 | 337 | 1 |
2151489 | 2151489 | 2022-01-26 | Denali Borough | Alaska | 2068 | 337 | 1 |
2146557 | 2146557 | 2022-01-24 | Meagher | Montana | 30059 | 337 | 10 |
2133538 | 2133538 | 2022-01-20 | McCone | Montana | 30055 | 337 | 9 |
2133946 | 2133946 | 2022-01-20 | Steele | North Dakota | 38091 | 337 | 2 |
2127204 | 2127204 | 2022-01-18 | Catron | New Mexico | 35003 | 337 | 11 |
2112038 | 2112038 | 2022-01-13 | Wayne | Utah | 49055 | 337 | 0 |
2101113 | 2101113 | 2022-01-10 | Pawnee | Nebraska | 31133 | 337 | 4 |
2079113 | 2079113 | 2022-01-03 | Jerauld | South Dakota | 46073 | 337 | 19 |
2075862 | 2075862 | 2022-01-02 | Jerauld | South Dakota | 46073 | 337 | 19 |
2072611 | 2072611 | 2022-01-01 | Jerauld | South Dakota | 46073 | 337 | 19 |
2069360 | 2069360 | 2021-12-31 | Jerauld | South Dakota | 46073 | 337 | 19 |
2066109 | 2066109 | 2021-12-30 | Jerauld | South Dakota | 46073 | 337 | 19 |
2062072 | 2062072 | 2021-12-29 | Harlan | Nebraska | 31083 | 337 | 2 |
2058823 | 2058823 | 2021-12-28 | Harlan | Nebraska | 31083 | 337 | 2 |
2055574 | 2055574 | 2021-12-27 | Harlan | Nebraska | 31083 | 337 | 2 |
2052324 | 2052324 | 2021-12-26 | Harlan | Nebraska | 31083 | 337 | 2 |
2053243 | 2053243 | 2021-12-26 | Armstrong | Texas | 48011 | 337 | 8 |
2049074 | 2049074 | 2021-12-25 | Harlan | Nebraska | 31083 | 337 | 2 |
2049993 | 2049993 | 2021-12-25 | Armstrong | Texas | 48011 | 337 | 8 |
2045824 | 2045824 | 2021-12-24 | Harlan | Nebraska | 31083 | 337 | 2 |
2046743 | 2046743 | 2021-12-24 | Armstrong | Texas | 48011 | 337 | 8 |
2042574 | 2042574 | 2021-12-23 | Harlan | Nebraska | 31083 | 337 | 2 |
2043493 | 2043493 | 2021-12-23 | Armstrong | Texas | 48011 | 337 | 8 |
2039325 | 2039325 | 2021-12-22 | Harlan | Nebraska | 31083 | 337 | 2 |
2014303 | 2014303 | 2021-12-14 | Edwards | Texas | 48137 | 337 | 8 |
2011052 | 2011052 | 2021-12-13 | Edwards | Texas | 48137 | 337 | 8 |
2006040 | 2006040 | 2021-12-12 | Hamilton | Kansas | 20075 | 337 | 3 |
2007801 | 2007801 | 2021-12-12 | Edwards | Texas | 48137 | 337 | 8 |
2002789 | 2002789 | 2021-12-11 | Hamilton | Kansas | 20075 | 337 | 3 |
2004550 | 2004550 | 2021-12-11 | Edwards | Texas | 48137 | 337 | 8 |
1999539 | 1999539 | 2021-12-10 | Hamilton | Kansas | 20075 | 337 | 3 |
2001299 | 2001299 | 2021-12-10 | Edwards | Texas | 48137 | 337 | 8 |
1984173 | 1984173 | 2021-12-05 | De Baca | New Mexico | 35011 | 337 | 3 |
1980923 | 1980923 | 2021-12-04 | De Baca | New Mexico | 35011 | 337 | 3 |
1977673 | 1977673 | 2021-12-03 | De Baca | New Mexico | 35011 | 337 | 3 |
1972279 | 1972279 | 2021-12-01 | St. John | Virgin Islands | 78020 | 337 | 4 |
1969029 | 1969029 | 2021-11-30 | St. John | Virgin Islands | 78020 | 337 | 3 |
1964881 | 1964881 | 2021-11-29 | Logan | North Dakota | 38047 | 337 | 11 |
1965778 | 1965778 | 2021-11-29 | St. John | Virgin Islands | 78020 | 337 | 3 |
1960529 | 1960529 | 2021-11-28 | Graham | Kansas | 20065 | 337 | 12 |
1961629 | 1961629 | 2021-11-28 | Logan | North Dakota | 38047 | 337 | 11 |
1962526 | 1962526 | 2021-11-28 | St. John | Virgin Islands | 78020 | 337 | 3 |
1957278 | 1957278 | 2021-11-27 | Graham | Kansas | 20065 | 337 | 12 |
1958378 | 1958378 | 2021-11-27 | Logan | North Dakota | 38047 | 337 | 11 |
1959275 | 1959275 | 2021-11-27 | St. John | Virgin Islands | 78020 | 337 | 3 |
1954027 | 1954027 | 2021-11-26 | Graham | Kansas | 20065 | 337 | 12 |
1955127 | 1955127 | 2021-11-26 | Logan | North Dakota | 38047 | 337 | 11 |
1956024 | 1956024 | 2021-11-26 | St. John | Virgin Islands | 78020 | 337 | 3 |
1950776 | 1950776 | 2021-11-25 | Graham | Kansas | 20065 | 337 | 12 |
1951876 | 1951876 | 2021-11-25 | Logan | North Dakota | 38047 | 337 | 11 |
1952773 | 1952773 | 2021-11-25 | St. John | Virgin Islands | 78020 | 337 | 3 |
1947525 | 1947525 | 2021-11-24 | Graham | Kansas | 20065 | 337 | 12 |
1948625 | 1948625 | 2021-11-24 | Logan | North Dakota | 38047 | 337 | 11 |
1949522 | 1949522 | 2021-11-24 | St. John | Virgin Islands | 78020 | 337 | 3 |
1945374 | 1945374 | 2021-11-23 | Logan | North Dakota | 38047 | 337 | 11 |
1945509 | 1945509 | 2021-11-23 | Cimarron | Oklahoma | 40025 | 337 | 2 |
1946271 | 1946271 | 2021-11-23 | St. John | Virgin Islands | 78020 | 337 | 3 |
1942123 | 1942123 | 2021-11-22 | Logan | North Dakota | 38047 | 337 | 11 |
1942258 | 1942258 | 2021-11-22 | Cimarron | Oklahoma | 40025 | 337 | 2 |
1943020 | 1943020 | 2021-11-22 | St. John | Virgin Islands | 78020 | 337 | 3 |
1938873 | 1938873 | 2021-11-21 | Logan | North Dakota | 38047 | 337 | 11 |
1939008 | 1939008 | 2021-11-21 | Cimarron | Oklahoma | 40025 | 337 | 2 |
1939770 | 1939770 | 2021-11-21 | St. John | Virgin Islands | 78020 | 337 | 3 |
1935623 | 1935623 | 2021-11-20 | Logan | North Dakota | 38047 | 337 | 11 |
1935758 | 1935758 | 2021-11-20 | Cimarron | Oklahoma | 40025 | 337 | 2 |
1936520 | 1936520 | 2021-11-20 | St. John | Virgin Islands | 78020 | 337 | 3 |
1932373 | 1932373 | 2021-11-19 | Logan | North Dakota | 38047 | 337 | 11 |
1932508 | 1932508 | 2021-11-19 | Cimarron | Oklahoma | 40025 | 337 | 2 |
1933270 | 1933270 | 2021-11-19 | St. John | Virgin Islands | 78020 | 337 | 3 |
1929257 | 1929257 | 2021-11-18 | Cimarron | Oklahoma | 40025 | 337 | 2 |
1930019 | 1930019 | 2021-11-18 | St. John | Virgin Islands | 78020 | 337 | 3 |
1926007 | 1926007 | 2021-11-17 | Cimarron | Oklahoma | 40025 | 337 | 2 |
1926769 | 1926769 | 2021-11-17 | St. John | Virgin Islands | 78020 | 337 | 3 |
1923083 | 1923083 | 2021-11-16 | Haakon | South Dakota | 46055 | 337 | 11 |
1923519 | 1923519 | 2021-11-16 | St. John | Virgin Islands | 78020 | 337 | 3 |
1920270 | 1920270 | 2021-11-15 | St. John | Virgin Islands | 78020 | 337 | 3 |
1898755 | 1898755 | 2021-11-09 | Clark | Kansas | 20025 | 337 | 7 |
1895505 | 1895505 | 2021-11-08 | Clark | Kansas | 20025 | 337 | 7 |
1892255 | 1892255 | 2021-11-07 | Clark | Kansas | 20025 | 337 | 7 |
1889005 | 1889005 | 2021-11-06 | Clark | Kansas | 20025 | 337 | 7 |
1885755 | 1885755 | 2021-11-05 | Clark | Kansas | 20025 | 337 | 7 |
1879450 | 1879450 | 2021-11-03 | Robertson | Kentucky | 21201 | 337 | 16 |
1876201 | 1876201 | 2021-11-02 | Robertson | Kentucky | 21201 | 337 | 16 |
1872952 | 1872952 | 2021-11-01 | Robertson | Kentucky | 21201 | 337 | 16 |
1848944 | 1848944 | 2021-10-24 | San Juan | Washington | 53055 | 337 | 0 |
1845694 | 1845694 | 2021-10-23 | San Juan | Washington | 53055 | 337 | 0 |
1842444 | 1842444 | 2021-10-22 | San Juan | Washington | 53055 | 337 | 0 |
1830179 | 1830179 | 2021-10-19 | Butte | Idaho | 16023 | 337 | 3 |
1831362 | 1831362 | 2021-10-19 | Sherman | Nebraska | 31163 | 337 | 4 |
1832414 | 1832414 | 2021-10-19 | Oldham | Texas | 48359 | 337 | 6 |
1829165 | 1829165 | 2021-10-18 | Oldham | Texas | 48359 | 337 | 6 |
1824073 | 1824073 | 2021-10-17 | Morton | Kansas | 20129 | 337 | 9 |
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);