ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
649 rows where cases = 593 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Nebraska 68
- Texas 68
- Virginia 47
- Minnesota 45
- Georgia 30
- Kentucky 29
- South Dakota 27
- North Carolina 20
- Puerto Rico 20
- Michigan 19
- Mississippi 19
- Tennessee 19
- Missouri 18
- Indiana 16
- Iowa 15
- Kansas 14
- Louisiana 14
- Illinois 12
- North Dakota 11
- Alabama 10
- Arkansas 9
- West Virginia 9
- Alaska 8
- Colorado 8
- Montana 8
- Wisconsin 8
- Florida 7
- Idaho 6
- Maine 6
- Maryland 6
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2314105 | 2314105 | 2022-03-17 | Haines Borough | Alaska | 2100 | 593 | 1 |
2310852 | 2310852 | 2022-03-16 | Haines Borough | Alaska | 2100 | 593 | 1 |
2307599 | 2307599 | 2022-03-15 | Haines Borough | Alaska | 2100 | 593 | 1 |
2304348 | 2304348 | 2022-03-14 | Haines Borough | Alaska | 2100 | 593 | 1 |
2301096 | 2301096 | 2022-03-13 | Haines Borough | Alaska | 2100 | 593 | 1 |
2297844 | 2297844 | 2022-03-12 | Haines Borough | Alaska | 2100 | 593 | 1 |
2294592 | 2294592 | 2022-03-11 | Haines Borough | Alaska | 2100 | 593 | 1 |
2190909 | 2190909 | 2022-02-07 | Glascock | Georgia | 13125 | 593 | 23 |
2176249 | 2176249 | 2022-02-02 | Towner | North Dakota | 38095 | 593 | 11 |
2167948 | 2167948 | 2022-01-31 | Custer | Colorado | 8027 | 593 | 18 |
2157444 | 2157444 | 2022-01-27 | Lipscomb | Texas | 48295 | 593 | 13 |
2144181 | 2144181 | 2022-01-23 | Stanley | South Dakota | 46117 | 593 | 6 |
2139996 | 2139996 | 2022-01-22 | Scotland | Missouri | 29199 | 593 | 17 |
2140926 | 2140926 | 2022-01-22 | Stanley | South Dakota | 46117 | 593 | 6 |
2136711 | 2136711 | 2022-01-21 | Mercer | Missouri | 29129 | 593 | 12 |
2137670 | 2137670 | 2022-01-21 | Stanley | South Dakota | 46117 | 593 | 6 |
2086034 | 2086034 | 2022-01-05 | Grand Isle | Vermont | 50013 | 593 | 3 |
2080115 | 2080115 | 2022-01-04 | Baca | Colorado | 8009 | 593 | 7 |
2078373 | 2078373 | 2022-01-03 | Valley | Nebraska | 31175 | 593 | 5 |
2076181 | 2076181 | 2022-01-02 | Real | Texas | 48385 | 593 | 21 |
2072930 | 2072930 | 2022-01-01 | Real | Texas | 48385 | 593 | 21 |
2069679 | 2069679 | 2021-12-31 | Real | Texas | 48385 | 593 | 21 |
2066428 | 2066428 | 2021-12-30 | Real | Texas | 48385 | 593 | 21 |
2063178 | 2063178 | 2021-12-29 | Real | Texas | 48385 | 593 | 21 |
2059928 | 2059928 | 2021-12-28 | Real | Texas | 48385 | 593 | 21 |
2051563 | 2051563 | 2021-12-26 | Logan | Kansas | 20109 | 593 | 9 |
2048313 | 2048313 | 2021-12-25 | Logan | Kansas | 20109 | 593 | 9 |
2045063 | 2045063 | 2021-12-24 | Logan | Kansas | 20109 | 593 | 9 |
2041814 | 2041814 | 2021-12-23 | Logan | Kansas | 20109 | 593 | 9 |
2038564 | 2038564 | 2021-12-22 | Logan | Kansas | 20109 | 593 | 9 |
2030251 | 2030251 | 2021-12-19 | Patillas | Puerto Rico | 72109 | 593 | |
2019163 | 2019163 | 2021-12-16 | Hickman | Kentucky | 21105 | 593 | 22 |
2015913 | 2015913 | 2021-12-15 | Hickman | Kentucky | 21105 | 593 | 22 |
2012662 | 2012662 | 2021-12-14 | Hickman | Kentucky | 21105 | 593 | 22 |
2009411 | 2009411 | 2021-12-13 | Hickman | Kentucky | 21105 | 593 | 22 |
1996408 | 1996408 | 2021-12-09 | Hickman | Kentucky | 21105 | 593 | 22 |
1997375 | 1997375 | 2021-12-09 | Emmons | North Dakota | 38029 | 593 | 16 |
1994098 | 1994098 | 2021-12-08 | Tyrrell | North Carolina | 37177 | 593 | 7 |
1994124 | 1994124 | 2021-12-08 | Emmons | North Dakota | 38029 | 593 | 16 |
1990873 | 1990873 | 2021-12-07 | Emmons | North Dakota | 38029 | 593 | 16 |
1988239 | 1988239 | 2021-12-06 | Baylor | Texas | 48023 | 593 | 24 |
1941499 | 1941499 | 2021-11-22 | Traverse | Minnesota | 27155 | 593 | 6 |
1938249 | 1938249 | 2021-11-21 | Traverse | Minnesota | 27155 | 593 | 6 |
1934999 | 1934999 | 2021-11-20 | Traverse | Minnesota | 27155 | 593 | 6 |
1931749 | 1931749 | 2021-11-19 | Traverse | Minnesota | 27155 | 593 | 6 |
1928498 | 1928498 | 2021-11-18 | Traverse | Minnesota | 27155 | 593 | 6 |
1907085 | 1907085 | 2021-11-11 | Hudspeth | Texas | 48229 | 593 | 14 |
1896409 | 1896409 | 2021-11-08 | Unknown | New Jersey | 593 | 0 | |
1887536 | 1887536 | 2021-11-05 | Donley | Texas | 48129 | 593 | 18 |
1884286 | 1884286 | 2021-11-04 | Donley | Texas | 48129 | 593 | 18 |
1880669 | 1880669 | 2021-11-03 | Sullivan | Pennsylvania | 42113 | 593 | 24 |
1858971 | 1858971 | 2021-10-28 | Calhoun | Arkansas | 5013 | 593 | 8 |
1855722 | 1855722 | 2021-10-27 | Calhoun | Arkansas | 5013 | 593 | 8 |
1854414 | 1854414 | 2021-10-26 | Wells | North Dakota | 38103 | 593 | 9 |
1824421 | 1824421 | 2021-10-17 | Ontonagon | Michigan | 26131 | 593 | 22 |
1821172 | 1821172 | 2021-10-16 | Ontonagon | Michigan | 26131 | 593 | 22 |
1817923 | 1817923 | 2021-10-15 | Ontonagon | Michigan | 26131 | 593 | 22 |
1816093 | 1816093 | 2021-10-14 | Haskell | Texas | 48207 | 593 | 31 |
1803890 | 1803890 | 2021-10-11 | Huerfano | Colorado | 8055 | 593 | 19 |
1789075 | 1789075 | 2021-10-06 | Furnas | Nebraska | 31065 | 593 | 5 |
1761939 | 1761939 | 2021-09-28 | Bear Lake | Idaho | 16007 | 593 | 11 |
1755903 | 1755903 | 2021-09-26 | Carlisle | Kentucky | 21039 | 593 | 11 |
1756503 | 1756503 | 2021-09-26 | Chouteau | Montana | 30015 | 593 | 8 |
1752655 | 1752655 | 2021-09-25 | Carlisle | Kentucky | 21039 | 593 | 11 |
1753255 | 1753255 | 2021-09-25 | Chouteau | Montana | 30015 | 593 | 8 |
1749406 | 1749406 | 2021-09-24 | Carlisle | Kentucky | 21039 | 593 | 11 |
1750007 | 1750007 | 2021-09-24 | Chouteau | Montana | 30015 | 593 | 8 |
1740178 | 1740178 | 2021-09-21 | Holt | Missouri | 29087 | 593 | 16 |
1733880 | 1733880 | 2021-09-19 | Polk | Nebraska | 31143 | 593 | 18 |
1730630 | 1730630 | 2021-09-18 | Polk | Nebraska | 31143 | 593 | 18 |
1727380 | 1727380 | 2021-09-17 | Polk | Nebraska | 31143 | 593 | 18 |
1724131 | 1724131 | 2021-09-16 | Polk | Nebraska | 31143 | 593 | 18 |
1720882 | 1720882 | 2021-09-15 | Polk | Nebraska | 31143 | 593 | 18 |
1717634 | 1717634 | 2021-09-14 | Polk | Nebraska | 31143 | 593 | 18 |
1718734 | 1718734 | 2021-09-14 | Sutton | Texas | 48435 | 593 | 10 |
1714050 | 1714050 | 2021-09-13 | Unknown | Minnesota | 593 | 93 | |
1714386 | 1714386 | 2021-09-13 | Polk | Nebraska | 31143 | 593 | 18 |
1715486 | 1715486 | 2021-09-13 | Sutton | Texas | 48435 | 593 | 10 |
1711140 | 1711140 | 2021-09-12 | Polk | Nebraska | 31143 | 593 | 18 |
1711875 | 1711875 | 2021-09-12 | Corson | South Dakota | 46031 | 593 | 12 |
1712240 | 1712240 | 2021-09-12 | Sutton | Texas | 48435 | 593 | 10 |
1707893 | 1707893 | 2021-09-11 | Polk | Nebraska | 31143 | 593 | 18 |
1708628 | 1708628 | 2021-09-11 | Corson | South Dakota | 46031 | 593 | 12 |
1708993 | 1708993 | 2021-09-11 | Sutton | Texas | 48435 | 593 | 10 |
1704646 | 1704646 | 2021-09-10 | Polk | Nebraska | 31143 | 593 | 18 |
1705381 | 1705381 | 2021-09-10 | Corson | South Dakota | 46031 | 593 | 12 |
1701060 | 1701060 | 2021-09-09 | Unknown | Minnesota | 593 | 93 | |
1701396 | 1701396 | 2021-09-09 | Polk | Nebraska | 31143 | 593 | 18 |
1698147 | 1698147 | 2021-09-08 | Polk | Nebraska | 31143 | 593 | 18 |
1694899 | 1694899 | 2021-09-07 | Polk | Nebraska | 31143 | 593 | 18 |
1691650 | 1691650 | 2021-09-06 | Polk | Nebraska | 31143 | 593 | 18 |
1688136 | 1688136 | 2021-09-05 | Sharkey | Mississippi | 28125 | 593 | 20 |
1688400 | 1688400 | 2021-09-05 | Polk | Nebraska | 31143 | 593 | 18 |
1689608 | 1689608 | 2021-09-05 | Charles City | Virginia | 51036 | 593 | 16 |
1689618 | 1689618 | 2021-09-05 | Cumberland | Virginia | 51049 | 593 | 10 |
1684886 | 1684886 | 2021-09-04 | Sharkey | Mississippi | 28125 | 593 | 20 |
1685150 | 1685150 | 2021-09-04 | Polk | Nebraska | 31143 | 593 | 18 |
1686358 | 1686358 | 2021-09-04 | Charles City | Virginia | 51036 | 593 | 16 |
1686368 | 1686368 | 2021-09-04 | Cumberland | Virginia | 51049 | 593 | 10 |
1681635 | 1681635 | 2021-09-03 | Sharkey | Mississippi | 28125 | 593 | 20 |
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);