ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
358 rows where cases = 1025 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kentucky 26
- Mississippi 25
- Virginia 22
- Puerto Rico 21
- Texas 21
- Georgia 16
- Michigan 14
- Missouri 12
- Nebraska 12
- Oklahoma 12
- North Carolina 11
- Alabama 10
- Colorado 10
- Illinois 10
- Arkansas 9
- Tennessee 9
- Minnesota 8
- North Dakota 8
- West Virginia 8
- Indiana 7
- Kansas 7
- South Dakota 7
- California 6
- Montana 6
- Vermont 6
- Idaho 5
- Iowa 5
- New Mexico 5
- New York 4
- South Carolina 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2380501 | 2380501 | 2022-04-06 | Unknown | Minnesota | 1025 | 240 | |
2372254 | 2372254 | 2022-04-03 | Grand Isle | Vermont | 50013 | 1025 | 5 |
2369001 | 2369001 | 2022-04-02 | Grand Isle | Vermont | 50013 | 1025 | 5 |
2365748 | 2365748 | 2022-04-01 | Grand Isle | Vermont | 50013 | 1025 | 5 |
2255560 | 2255560 | 2022-02-27 | Aleutians East Borough | Alaska | 2013 | 1025 | 3 |
2252309 | 2252309 | 2022-02-26 | Aleutians East Borough | Alaska | 2013 | 1025 | 3 |
2249058 | 2249058 | 2022-02-25 | Aleutians East Borough | Alaska | 2013 | 1025 | 3 |
2251037 | 2251037 | 2022-02-25 | Sargent | North Dakota | 38081 | 1025 | 9 |
2247786 | 2247786 | 2022-02-24 | Sargent | North Dakota | 38081 | 1025 | 9 |
2244535 | 2244535 | 2022-02-23 | Sargent | North Dakota | 38081 | 1025 | 9 |
2239544 | 2239544 | 2022-02-22 | Washington | Colorado | 8121 | 1025 | 26 |
2217381 | 2217381 | 2022-02-15 | Barber | Kansas | 20007 | 1025 | 8 |
2214130 | 2214130 | 2022-02-14 | Barber | Kansas | 20007 | 1025 | 8 |
2216059 | 2216059 | 2022-02-14 | San Augustine | Texas | 48405 | 1025 | 39 |
2212808 | 2212808 | 2022-02-13 | San Augustine | Texas | 48405 | 1025 | 39 |
2192102 | 2192102 | 2022-02-07 | Mineral | Montana | 30061 | 1025 | 15 |
2193335 | 2193335 | 2022-02-07 | Yoakum | Texas | 48501 | 1025 | 38 |
2189683 | 2189683 | 2022-02-06 | Corson | South Dakota | 46031 | 1025 | 16 |
2190082 | 2190082 | 2022-02-06 | Yoakum | Texas | 48501 | 1025 | 38 |
2186430 | 2186430 | 2022-02-05 | Corson | South Dakota | 46031 | 1025 | 16 |
2183178 | 2183178 | 2022-02-04 | Corson | South Dakota | 46031 | 1025 | 16 |
2172697 | 2172697 | 2022-02-01 | Thayer | Nebraska | 31169 | 1025 | 8 |
2169444 | 2169444 | 2022-01-31 | Thayer | Nebraska | 31169 | 1025 | 8 |
2164734 | 2164734 | 2022-01-30 | Saguache | Colorado | 8109 | 1025 | 10 |
2158223 | 2158223 | 2022-01-28 | Saguache | Colorado | 8109 | 1025 | 10 |
2130374 | 2130374 | 2022-01-19 | Morrill | Nebraska | 31123 | 1025 | 17 |
2122767 | 2122767 | 2022-01-17 | Gallatin | Illinois | 17059 | 1025 | 11 |
2119515 | 2119515 | 2022-01-16 | Gallatin | Illinois | 17059 | 1025 | 11 |
2116263 | 2116263 | 2022-01-15 | Gallatin | Illinois | 17059 | 1025 | 11 |
2113012 | 2113012 | 2022-01-14 | Gallatin | Illinois | 17059 | 1025 | 11 |
2098476 | 2098476 | 2022-01-09 | Ceiba | Puerto Rico | 72037 | 1025 | |
2088035 | 2088035 | 2022-01-06 | Toole | Montana | 30101 | 1025 | 21 |
2088088 | 2088088 | 2022-01-06 | Jefferson | Nebraska | 31095 | 1025 | 3 |
2084783 | 2084783 | 2022-01-05 | Toole | Montana | 30101 | 1025 | 21 |
2060002 | 2060002 | 2021-12-28 | Kane | Utah | 49025 | 1025 | 12 |
2014617 | 2014617 | 2021-12-14 | Middlesex | Virginia | 51119 | 1025 | 33 |
2007900 | 2007900 | 2021-12-12 | Mitchell | Texas | 48335 | 1025 | 43 |
2004649 | 2004649 | 2021-12-11 | Mitchell | Texas | 48335 | 1025 | 43 |
1996345 | 1996345 | 2021-12-09 | Stevens | Kansas | 20189 | 1025 | 15 |
1992342 | 1992342 | 2021-12-08 | Trinity | California | 6105 | 1025 | 17 |
1993094 | 1993094 | 2021-12-08 | Stevens | Kansas | 20189 | 1025 | 15 |
1971087 | 1971087 | 2021-12-01 | Nemaha | Nebraska | 31127 | 1025 | 16 |
1925635 | 1925635 | 2021-11-17 | Unknown | New Hampshire | 1025 | 6 | |
1914666 | 1914666 | 2021-11-14 | Caribou | Idaho | 16029 | 1025 | 21 |
1911416 | 1911416 | 2021-11-13 | Caribou | Idaho | 16029 | 1025 | 21 |
1892591 | 1892591 | 2021-11-07 | Alger | Michigan | 26003 | 1025 | 9 |
1893832 | 1893832 | 2021-11-07 | Fall River | South Dakota | 46047 | 1025 | 23 |
1889341 | 1889341 | 2021-11-06 | Alger | Michigan | 26003 | 1025 | 9 |
1890582 | 1890582 | 2021-11-06 | Fall River | South Dakota | 46047 | 1025 | 23 |
1886091 | 1886091 | 2021-11-05 | Alger | Michigan | 26003 | 1025 | 9 |
1887332 | 1887332 | 2021-11-05 | Fall River | South Dakota | 46047 | 1025 | 23 |
1849386 | 1849386 | 2021-10-25 | Lake | Colorado | 8065 | 1025 | 1 |
1831128 | 1831128 | 2021-10-19 | Chariton | Missouri | 29041 | 1025 | 8 |
1823737 | 1823737 | 2021-10-17 | Edwards | Illinois | 17047 | 1025 | 19 |
1820488 | 1820488 | 2021-10-16 | Edwards | Illinois | 17047 | 1025 | 19 |
1822199 | 1822199 | 2021-10-16 | Aibonito | Puerto Rico | 72009 | 1025 | |
1817239 | 1817239 | 2021-10-15 | Edwards | Illinois | 17047 | 1025 | 19 |
1813991 | 1813991 | 2021-10-14 | Edwards | Illinois | 17047 | 1025 | 18 |
1806617 | 1806617 | 2021-10-11 | Lunenburg | Virginia | 51111 | 1025 | 19 |
1802310 | 1802310 | 2021-10-10 | Gates | North Carolina | 37073 | 1025 | 17 |
1803367 | 1803367 | 2021-10-10 | Lunenburg | Virginia | 51111 | 1025 | 19 |
1799061 | 1799061 | 2021-10-09 | Gates | North Carolina | 37073 | 1025 | 17 |
1800118 | 1800118 | 2021-10-09 | Lunenburg | Virginia | 51111 | 1025 | 19 |
1795812 | 1795812 | 2021-10-08 | Gates | North Carolina | 37073 | 1025 | 17 |
1796869 | 1796869 | 2021-10-08 | Lunenburg | Virginia | 51111 | 1025 | 19 |
1788737 | 1788737 | 2021-10-06 | Lake | Minnesota | 27075 | 1025 | 21 |
1769168 | 1769168 | 2021-09-30 | Mackinac | Michigan | 26097 | 1025 | 6 |
1770473 | 1770473 | 2021-09-30 | Pickett | Tennessee | 47137 | 1025 | 24 |
1771012 | 1771012 | 2021-09-30 | Pocahontas | West Virginia | 54075 | 1025 | 16 |
1765919 | 1765919 | 2021-09-29 | Mackinac | Michigan | 26097 | 1025 | 6 |
1764485 | 1764485 | 2021-09-28 | Doddridge | West Virginia | 54017 | 1025 | 6 |
1760775 | 1760775 | 2021-09-27 | Brewster | Texas | 48043 | 1025 | 19 |
1757527 | 1757527 | 2021-09-26 | Brewster | Texas | 48043 | 1025 | 19 |
1743401 | 1743401 | 2021-09-22 | Carter | Missouri | 29035 | 1025 | 13 |
1718735 | 1718735 | 2021-09-14 | Swisher | Texas | 48437 | 1025 | 21 |
1714046 | 1714046 | 2021-09-13 | Stevens | Minnesota | 27149 | 1025 | 11 |
1702570 | 1702570 | 2021-09-09 | Lamoille | Vermont | 50015 | 1025 | 3 |
1696713 | 1696713 | 2021-09-08 | Yuma | Colorado | 8125 | 1025 | 18 |
1684946 | 1684946 | 2021-09-04 | Harrison | Missouri | 29081 | 1025 | 15 |
1686553 | 1686553 | 2021-09-04 | Summers | West Virginia | 54089 | 1025 | 23 |
1674187 | 1674187 | 2021-09-01 | Terrell | Georgia | 13273 | 1025 | 50 |
1675024 | 1675024 | 2021-09-01 | Koochiching | Minnesota | 27071 | 1025 | 19 |
1672371 | 1672371 | 2021-08-31 | Jones | North Carolina | 37103 | 1025 | 29 |
1645031 | 1645031 | 2021-08-23 | Valley | Idaho | 16085 | 1025 | 6 |
1645855 | 1645855 | 2021-08-23 | Choctaw | Mississippi | 28019 | 1025 | 21 |
1631116 | 1631116 | 2021-08-18 | Amelia | Virginia | 51007 | 1025 | 36 |
1622222 | 1622222 | 2021-08-16 | Treutlen | Georgia | 13283 | 1025 | 36 |
1605915 | 1605915 | 2021-08-11 | Heard | Georgia | 13149 | 1025 | 23 |
1583188 | 1583188 | 2021-08-04 | Long | Georgia | 13183 | 1025 | 14 |
1584148 | 1584148 | 2021-08-04 | Humphreys | Mississippi | 28053 | 1025 | 33 |
1582419 | 1582419 | 2021-08-03 | Dickenson | Virginia | 51051 | 1025 | 19 |
1579169 | 1579169 | 2021-08-02 | Dickenson | Virginia | 51051 | 1025 | 19 |
1537093 | 1537093 | 2021-07-20 | Braxton | West Virginia | 54007 | 1025 | 4 |
1533845 | 1533845 | 2021-07-19 | Braxton | West Virginia | 54007 | 1025 | 4 |
1511775 | 1511775 | 2021-07-13 | Screven | Georgia | 13251 | 1025 | 33 |
1513473 | 1513473 | 2021-07-13 | Pushmataha | Oklahoma | 40127 | 1025 | 22 |
1510227 | 1510227 | 2021-07-12 | Pushmataha | Oklahoma | 40127 | 1025 | 22 |
1506980 | 1506980 | 2021-07-11 | Pushmataha | Oklahoma | 40127 | 1025 | 22 |
1503734 | 1503734 | 2021-07-10 | Pushmataha | Oklahoma | 40127 | 1025 | 22 |
1500488 | 1500488 | 2021-07-09 | Pushmataha | Oklahoma | 40127 | 1025 | 22 |
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);