ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
637 rows where cases = 429 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Virginia 46
- North Dakota 37
- Kansas 36
- Texas 36
- Nebraska 30
- South Dakota 30
- Iowa 26
- Minnesota 26
- Kentucky 23
- Oklahoma 22
- Georgia 20
- Missouri 19
- Wyoming 17
- Alaska 16
- Puerto Rico 16
- Illinois 15
- Pennsylvania 15
- Michigan 14
- North Carolina 14
- Arkansas 13
- Alabama 12
- California 12
- Mississippi 12
- Oregon 11
- Idaho 10
- Louisiana 10
- Montana 10
- Ohio 10
- Colorado 9
- New York 9
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2337794 | 2337794 | 2022-03-24 | Stanton | Kansas | 20187 | 429 | 8 |
2334540 | 2334540 | 2022-03-23 | Stanton | Kansas | 20187 | 429 | 8 |
2331286 | 2331286 | 2022-03-22 | Stanton | Kansas | 20187 | 429 | 8 |
2328034 | 2328034 | 2022-03-21 | Stanton | Kansas | 20187 | 429 | 8 |
2329734 | 2329734 | 2022-03-21 | Dickens | Texas | 48125 | 429 | 16 |
2324781 | 2324781 | 2022-03-20 | Stanton | Kansas | 20187 | 429 | 8 |
2326482 | 2326482 | 2022-03-20 | Dickens | Texas | 48125 | 429 | 16 |
2321527 | 2321527 | 2022-03-19 | Stanton | Kansas | 20187 | 429 | 8 |
2323229 | 2323229 | 2022-03-19 | Dickens | Texas | 48125 | 429 | 16 |
2318273 | 2318273 | 2022-03-18 | Stanton | Kansas | 20187 | 429 | 8 |
2319975 | 2319975 | 2022-03-18 | Dickens | Texas | 48125 | 429 | 16 |
2315020 | 2315020 | 2022-03-17 | Stanton | Kansas | 20187 | 429 | 8 |
2311767 | 2311767 | 2022-03-16 | Stanton | Kansas | 20187 | 429 | 8 |
2251003 | 2251003 | 2022-02-25 | Burke | North Dakota | 38013 | 429 | 3 |
2247752 | 2247752 | 2022-02-24 | Burke | North Dakota | 38013 | 429 | 3 |
2247769 | 2247769 | 2022-02-24 | Logan | North Dakota | 38047 | 429 | 12 |
2244501 | 2244501 | 2022-02-23 | Burke | North Dakota | 38013 | 429 | 3 |
2241250 | 2241250 | 2022-02-22 | Burke | North Dakota | 38013 | 429 | 3 |
2237999 | 2237999 | 2022-02-21 | Burke | North Dakota | 38013 | 429 | 3 |
2238896 | 2238896 | 2022-02-21 | Wayne | Utah | 49055 | 429 | 0 |
2234748 | 2234748 | 2022-02-20 | Burke | North Dakota | 38013 | 429 | 3 |
2235645 | 2235645 | 2022-02-20 | Wayne | Utah | 49055 | 429 | 0 |
2232394 | 2232394 | 2022-02-19 | Wayne | Utah | 49055 | 429 | 0 |
2229143 | 2229143 | 2022-02-18 | Wayne | Utah | 49055 | 429 | 0 |
2225892 | 2225892 | 2022-02-17 | Wayne | Utah | 49055 | 429 | 0 |
2217471 | 2217471 | 2022-02-15 | Stanton | Kansas | 20187 | 429 | 8 |
2214220 | 2214220 | 2022-02-14 | Stanton | Kansas | 20187 | 429 | 8 |
2210968 | 2210968 | 2022-02-13 | Stanton | Kansas | 20187 | 429 | 8 |
2207715 | 2207715 | 2022-02-12 | Stanton | Kansas | 20187 | 429 | 8 |
2204462 | 2204462 | 2022-02-11 | Stanton | Kansas | 20187 | 429 | 8 |
2201209 | 2201209 | 2022-02-10 | Stanton | Kansas | 20187 | 429 | 8 |
2197955 | 2197955 | 2022-02-09 | Stanton | Kansas | 20187 | 429 | 8 |
2199710 | 2199710 | 2022-02-09 | Irion | Texas | 48235 | 429 | 3 |
2193801 | 2193801 | 2022-02-08 | Wrangell City and Borough | Alaska | 2275 | 429 | 1 |
2190548 | 2190548 | 2022-02-07 | Wrangell City and Borough | Alaska | 2275 | 429 | 1 |
2150656 | 2150656 | 2022-01-25 | Haakon | South Dakota | 46055 | 429 | 11 |
2134658 | 2134658 | 2022-01-20 | Knox | Texas | 48275 | 429 | 22 |
2117660 | 2117660 | 2022-01-15 | Kidder | North Dakota | 38043 | 429 | 13 |
2104791 | 2104791 | 2022-01-11 | Cimarron | Oklahoma | 40025 | 429 | 0 |
2101540 | 2101540 | 2022-01-10 | Cimarron | Oklahoma | 40025 | 429 | 0 |
2098289 | 2098289 | 2022-01-09 | Cimarron | Oklahoma | 40025 | 429 | 0 |
2095037 | 2095037 | 2022-01-08 | Cimarron | Oklahoma | 40025 | 429 | 0 |
2091785 | 2091785 | 2022-01-07 | Cimarron | Oklahoma | 40025 | 429 | 0 |
2088533 | 2088533 | 2022-01-06 | Cimarron | Oklahoma | 40025 | 429 | 0 |
2085282 | 2085282 | 2022-01-05 | Cimarron | Oklahoma | 40025 | 429 | 0 |
2081928 | 2081928 | 2022-01-04 | Unknown | Northern Mariana Islands | 429 | 7 | |
2014101 | 2014101 | 2021-12-14 | Hand | South Dakota | 46059 | 429 | 8 |
1997068 | 1997068 | 2021-12-09 | Hitchcock | Nebraska | 31087 | 429 | 5 |
1990566 | 1990566 | 2021-12-07 | Hitchcock | Nebraska | 31087 | 429 | 5 |
1974354 | 1974354 | 2021-12-02 | Sherman | Nebraska | 31163 | 429 | 4 |
1968128 | 1968128 | 2021-11-30 | Griggs | North Dakota | 38039 | 429 | 2 |
1969019 | 1969019 | 2021-11-30 | Grand Isle | Vermont | 50013 | 429 | 2 |
1965768 | 1965768 | 2021-11-29 | Grand Isle | Vermont | 50013 | 429 | 2 |
1945398 | 1945398 | 2021-11-23 | Towner | North Dakota | 38095 | 429 | 11 |
1942147 | 1942147 | 2021-11-22 | Towner | North Dakota | 38095 | 429 | 11 |
1942581 | 1942581 | 2021-11-22 | Faulk | South Dakota | 46049 | 429 | 15 |
1938897 | 1938897 | 2021-11-21 | Towner | North Dakota | 38095 | 429 | 11 |
1932350 | 1932350 | 2021-11-19 | Adams | North Dakota | 38001 | 429 | 5 |
1928081 | 1928081 | 2021-11-18 | Smith | Kansas | 20183 | 429 | 3 |
1928093 | 1928093 | 2021-11-18 | Woodson | Kansas | 20207 | 429 | 10 |
1924831 | 1924831 | 2021-11-17 | Smith | Kansas | 20183 | 429 | 3 |
1924843 | 1924843 | 2021-11-17 | Woodson | Kansas | 20207 | 429 | 10 |
1904605 | 1904605 | 2021-11-11 | Custer | Colorado | 8027 | 429 | 9 |
1893862 | 1893862 | 2021-11-07 | Perkins | South Dakota | 46105 | 429 | 16 |
1890612 | 1890612 | 2021-11-06 | Perkins | South Dakota | 46105 | 429 | 16 |
1887362 | 1887362 | 2021-11-05 | Perkins | South Dakota | 46105 | 429 | 16 |
1869574 | 1869574 | 2021-10-31 | Rawlins | Kansas | 20153 | 429 | 7 |
1866325 | 1866325 | 2021-10-30 | Rawlins | Kansas | 20153 | 429 | 7 |
1863076 | 1863076 | 2021-10-29 | Rawlins | Kansas | 20153 | 429 | 7 |
1837016 | 1837016 | 2021-10-21 | Cheyenne | Kansas | 20023 | 429 | 13 |
1833767 | 1833767 | 2021-10-20 | Cheyenne | Kansas | 20023 | 429 | 13 |
1826432 | 1826432 | 2021-10-18 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 429 | 0 |
1827988 | 1827988 | 2021-10-18 | Fallon | Montana | 30025 | 429 | 4 |
1823183 | 1823183 | 2021-10-17 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 429 | 0 |
1819934 | 1819934 | 2021-10-16 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 429 | 0 |
1816685 | 1816685 | 2021-10-15 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 429 | 0 |
1811984 | 1811984 | 2021-10-13 | Hamilton | New York | 36041 | 429 | 3 |
1809360 | 1809360 | 2021-10-12 | Hanson | South Dakota | 46061 | 429 | 4 |
1806110 | 1806110 | 2021-10-11 | Hanson | South Dakota | 46061 | 429 | 4 |
1806554 | 1806554 | 2021-10-11 | Bath | Virginia | 51017 | 429 | 14 |
1800435 | 1800435 | 2021-10-10 | Aleutians East Borough | Alaska | 2013 | 429 | 3 |
1802860 | 1802860 | 2021-10-10 | Hanson | South Dakota | 46061 | 429 | 4 |
1803304 | 1803304 | 2021-10-10 | Bath | Virginia | 51017 | 429 | 14 |
1797186 | 1797186 | 2021-10-09 | Aleutians East Borough | Alaska | 2013 | 429 | 3 |
1799611 | 1799611 | 2021-10-09 | Hanson | South Dakota | 46061 | 429 | 4 |
1800055 | 1800055 | 2021-10-09 | Bath | Virginia | 51017 | 429 | 14 |
1793937 | 1793937 | 2021-10-08 | Aleutians East Borough | Alaska | 2013 | 429 | 3 |
1796362 | 1796362 | 2021-10-08 | Hanson | South Dakota | 46061 | 429 | 4 |
1796628 | 1796628 | 2021-10-08 | Kimble | Texas | 48267 | 429 | 11 |
1796806 | 1796806 | 2021-10-08 | Bath | Virginia | 51017 | 429 | 14 |
1790688 | 1790688 | 2021-10-07 | Aleutians East Borough | Alaska | 2013 | 429 | 3 |
1793379 | 1793379 | 2021-10-07 | Kimble | Texas | 48267 | 429 | 11 |
1787440 | 1787440 | 2021-10-06 | Aleutians East Borough | Alaska | 2013 | 429 | 3 |
1789648 | 1789648 | 2021-10-06 | Cameron | Pennsylvania | 42023 | 429 | 10 |
1790130 | 1790130 | 2021-10-06 | Kimble | Texas | 48267 | 429 | 11 |
1784191 | 1784191 | 2021-10-05 | Aleutians East Borough | Alaska | 2013 | 429 | 3 |
1782906 | 1782906 | 2021-10-04 | McIntosh | North Dakota | 38051 | 429 | 8 |
1778991 | 1778991 | 2021-10-03 | Lake of the Woods | Minnesota | 27077 | 429 | 4 |
1779657 | 1779657 | 2021-10-03 | McIntosh | North Dakota | 38051 | 429 | 8 |
1775741 | 1775741 | 2021-10-02 | Lake of the Woods | Minnesota | 27077 | 429 | 4 |
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);