ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
611 rows where cases = 538 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 51
- Georgia 47
- Nebraska 34
- Alaska 32
- Virginia 31
- Iowa 28
- Oklahoma 25
- North Dakota 21
- Kentucky 18
- North Carolina 18
- Missouri 17
- Kansas 15
- Mississippi 15
- Tennessee 15
- Idaho 14
- Minnesota 14
- Rhode Island 14
- Puerto Rico 13
- South Dakota 12
- West Virginia 12
- Alabama 11
- Arkansas 11
- Colorado 11
- Illinois 11
- Michigan 10
- Montana 10
- New Mexico 10
- Louisiana 9
- California 8
- Ohio 8
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2468740 | 2468740 | 2022-05-03 | Perkins | Nebraska | 31135 | 538 | 12 |
2444300 | 2444300 | 2022-04-26 | Wrangell City and Borough | Alaska | 2275 | 538 | 1 |
2444301 | 2444301 | 2022-04-26 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 538 | 5 |
2441044 | 2441044 | 2022-04-25 | Wrangell City and Borough | Alaska | 2275 | 538 | 1 |
2441045 | 2441045 | 2022-04-25 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 538 | 5 |
2437788 | 2437788 | 2022-04-24 | Wrangell City and Borough | Alaska | 2275 | 538 | 1 |
2437789 | 2437789 | 2022-04-24 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 538 | 5 |
2434532 | 2434532 | 2022-04-23 | Wrangell City and Borough | Alaska | 2275 | 538 | 1 |
2434533 | 2434533 | 2022-04-23 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 538 | 5 |
2431276 | 2431276 | 2022-04-22 | Wrangell City and Borough | Alaska | 2275 | 538 | 1 |
2431277 | 2431277 | 2022-04-22 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 538 | 5 |
2428020 | 2428020 | 2022-04-21 | Wrangell City and Borough | Alaska | 2275 | 538 | 1 |
2428021 | 2428021 | 2022-04-21 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 538 | 5 |
2424764 | 2424764 | 2022-04-20 | Wrangell City and Borough | Alaska | 2275 | 538 | 1 |
2424765 | 2424765 | 2022-04-20 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 538 | 5 |
2312464 | 2312464 | 2022-03-16 | Cherry | Nebraska | 31031 | 538 | 8 |
2258589 | 2258589 | 2022-02-27 | Wahkiakum | Washington | 53069 | 538 | 6 |
2255338 | 2255338 | 2022-02-26 | Wahkiakum | Washington | 53069 | 538 | 6 |
2252087 | 2252087 | 2022-02-25 | Wahkiakum | Washington | 53069 | 538 | 6 |
2247083 | 2247083 | 2022-02-24 | Cook | Minnesota | 27031 | 538 | 4 |
2194640 | 2194640 | 2022-02-08 | Graham | Kansas | 20065 | 538 | 13 |
2191386 | 2191386 | 2022-02-07 | Graham | Kansas | 20065 | 538 | 13 |
2189247 | 2189247 | 2022-02-06 | Renville | North Dakota | 38075 | 538 | 15 |
2185994 | 2185994 | 2022-02-05 | Renville | North Dakota | 38075 | 538 | 15 |
2173435 | 2173435 | 2022-02-01 | Hand | South Dakota | 46059 | 538 | 8 |
2166186 | 2166186 | 2022-01-30 | Sherman | Nebraska | 31163 | 538 | 4 |
2162931 | 2162931 | 2022-01-29 | Sherman | Nebraska | 31163 | 538 | 4 |
2159676 | 2159676 | 2022-01-28 | Sherman | Nebraska | 31163 | 538 | 4 |
2155590 | 2155590 | 2022-01-27 | Edwards | Kansas | 20047 | 538 | 13 |
2152337 | 2152337 | 2022-01-26 | Edwards | Kansas | 20047 | 538 | 13 |
2122395 | 2122395 | 2022-01-17 | Custer | Colorado | 8027 | 538 | 16 |
2087286 | 2087286 | 2022-01-06 | Decatur | Kansas | 20039 | 538 | 16 |
2084034 | 2084034 | 2022-01-05 | Decatur | Kansas | 20039 | 538 | 16 |
2079279 | 2079279 | 2022-01-03 | Cochran | Texas | 48079 | 538 | 20 |
2056377 | 2056377 | 2021-12-27 | Perkins | South Dakota | 46105 | 538 | 16 |
2050702 | 2050702 | 2021-12-26 | Unknown | Alaska | 538 | 1 | |
2047452 | 2047452 | 2021-12-25 | Unknown | Alaska | 538 | 1 | |
2044202 | 2044202 | 2021-12-24 | Unknown | Alaska | 538 | 1 | |
2046143 | 2046143 | 2021-12-24 | McIntosh | North Dakota | 38051 | 538 | 9 |
2040953 | 2040953 | 2021-12-23 | Unknown | Alaska | 538 | 1 | |
2042893 | 2042893 | 2021-12-23 | McIntosh | North Dakota | 38051 | 538 | 9 |
2037703 | 2037703 | 2021-12-22 | Unknown | Alaska | 538 | 1 | |
2027952 | 2027952 | 2021-12-19 | Unknown | Alaska | 538 | 1 | |
2024701 | 2024701 | 2021-12-18 | Unknown | Alaska | 538 | 1 | |
2021450 | 2021450 | 2021-12-17 | Unknown | Alaska | 538 | 1 | |
2018199 | 2018199 | 2021-12-16 | Unknown | Alaska | 538 | 1 | |
2020616 | 2020616 | 2021-12-16 | Marshall | South Dakota | 46091 | 538 | 8 |
2014949 | 2014949 | 2021-12-15 | Unknown | Alaska | 538 | 1 | |
2011899 | 2011899 | 2021-12-14 | Ouray | Colorado | 8091 | 538 | 6 |
1988942 | 1988942 | 2021-12-07 | Unknown | Alaska | 538 | 1 | |
1985692 | 1985692 | 2021-12-06 | Unknown | Alaska | 538 | 1 | |
1982442 | 1982442 | 2021-12-05 | Unknown | Alaska | 538 | 1 | |
1982621 | 1982621 | 2021-12-05 | Gilpin | Colorado | 8047 | 538 | 3 |
1984114 | 1984114 | 2021-12-05 | Webster | Nebraska | 31181 | 538 | 9 |
1979192 | 1979192 | 2021-12-04 | Unknown | Alaska | 538 | 1 | |
1979371 | 1979371 | 2021-12-04 | Gilpin | Colorado | 8047 | 538 | 3 |
1980864 | 1980864 | 2021-12-04 | Webster | Nebraska | 31181 | 538 | 9 |
1975942 | 1975942 | 2021-12-03 | Unknown | Alaska | 538 | 1 | |
1976121 | 1976121 | 2021-12-03 | Gilpin | Colorado | 8047 | 538 | 3 |
1977614 | 1977614 | 2021-12-03 | Webster | Nebraska | 31181 | 538 | 9 |
1972872 | 1972872 | 2021-12-02 | Gilpin | Colorado | 8047 | 538 | 3 |
1974364 | 1974364 | 2021-12-02 | Webster | Nebraska | 31181 | 538 | 9 |
1971112 | 1971112 | 2021-12-01 | Valley | Nebraska | 31175 | 538 | 5 |
1966174 | 1966174 | 2021-11-30 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 538 | 1 |
1962922 | 1962922 | 2021-11-29 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 538 | 1 |
1961260 | 1961260 | 2021-11-28 | Sheridan | Montana | 30091 | 538 | 8 |
1958009 | 1958009 | 2021-11-27 | Sheridan | Montana | 30091 | 538 | 8 |
1954758 | 1954758 | 2021-11-26 | Sheridan | Montana | 30091 | 538 | 8 |
1951873 | 1951873 | 2021-11-25 | Hettinger | North Dakota | 38041 | 538 | 6 |
1948622 | 1948622 | 2021-11-24 | Hettinger | North Dakota | 38041 | 538 | 6 |
1896329 | 1896329 | 2021-11-08 | Nance | Nebraska | 31125 | 538 | 10 |
1839064 | 1839064 | 2021-10-21 | Craig | Virginia | 51045 | 538 | 6 |
1834879 | 1834879 | 2021-10-20 | Emmons | North Dakota | 38029 | 538 | 15 |
1831630 | 1831630 | 2021-10-19 | Emmons | North Dakota | 38029 | 538 | 15 |
1825132 | 1825132 | 2021-10-17 | Emmons | North Dakota | 38029 | 538 | 15 |
1821883 | 1821883 | 2021-10-16 | Emmons | North Dakota | 38029 | 538 | 15 |
1819334 | 1819334 | 2021-10-15 | Hall | Texas | 48191 | 538 | 15 |
1815359 | 1815359 | 2021-10-14 | Tyrrell | North Carolina | 37177 | 538 | 7 |
1816001 | 1816001 | 2021-10-14 | Baylor | Texas | 48023 | 538 | 19 |
1812111 | 1812111 | 2021-10-13 | Tyrrell | North Carolina | 37177 | 538 | 7 |
1812128 | 1812128 | 2021-10-13 | Bowman | North Dakota | 38011 | 538 | 7 |
1812753 | 1812753 | 2021-10-13 | Baylor | Texas | 48023 | 538 | 19 |
1813132 | 1813132 | 2021-10-13 | Norton city | Virginia | 51720 | 538 | 13 |
1808862 | 1808862 | 2021-10-12 | Tyrrell | North Carolina | 37177 | 538 | 7 |
1804671 | 1804671 | 2021-10-11 | Hickman | Kentucky | 21105 | 538 | 19 |
1806648 | 1806648 | 2021-10-11 | Rappahannock | Virginia | 51157 | 538 | 4 |
1803398 | 1803398 | 2021-10-10 | Rappahannock | Virginia | 51157 | 538 | 4 |
1800149 | 1800149 | 2021-10-09 | Rappahannock | Virginia | 51157 | 538 | 4 |
1796900 | 1796900 | 2021-10-08 | Rappahannock | Virginia | 51157 | 538 | 4 |
1764194 | 1764194 | 2021-09-28 | Reagan | Texas | 48383 | 538 | 9 |
1750706 | 1750706 | 2021-09-24 | Sullivan | Pennsylvania | 42113 | 538 | 23 |
1751074 | 1751074 | 2021-09-24 | Donley | Texas | 48129 | 538 | 18 |
1735688 | 1735688 | 2021-09-20 | Saguache | Colorado | 8109 | 538 | 8 |
1727977 | 1727977 | 2021-09-17 | Arroyo | Puerto Rico | 72015 | 538 | |
1724728 | 1724728 | 2021-09-16 | Arroyo | Puerto Rico | 72015 | 538 | |
1725074 | 1725074 | 2021-09-16 | Delta | Texas | 48119 | 538 | 17 |
1722187 | 1722187 | 2021-09-15 | Surry | Virginia | 51181 | 538 | 9 |
1718885 | 1718885 | 2021-09-14 | King and Queen | Virginia | 51097 | 538 | 7 |
1713325 | 1713325 | 2021-09-13 | Putnam | Illinois | 17155 | 538 | 5 |
1702827 | 1702827 | 2021-09-09 | Florence | Wisconsin | 55037 | 538 | 13 |
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);