ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
691 rows where cases = 469 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 101
- Utah 66
- North Dakota 34
- South Dakota 32
- Georgia 31
- Kansas 29
- Puerto Rico 25
- Illinois 22
- Colorado 21
- Kentucky 21
- Minnesota 18
- Mississippi 18
- Nebraska 18
- Virginia 17
- Indiana 13
- Tennessee 13
- West Virginia 13
- Idaho 12
- Missouri 12
- North Carolina 12
- Ohio 12
- Wisconsin 10
- Arkansas 9
- Iowa 9
- Louisiana 9
- Oklahoma 9
- Oregon 9
- South Carolina 9
- Michigan 8
- Pennsylvania 8
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2242792 | 2242792 | 2022-02-23 | Sedgwick | Colorado | 8115 | 469 | 8 |
2244511 | 2244511 | 2022-02-23 | Golden Valley | North Dakota | 38033 | 469 | 4 |
2239541 | 2239541 | 2022-02-22 | Sedgwick | Colorado | 8115 | 469 | 8 |
2236290 | 2236290 | 2022-02-21 | Sedgwick | Colorado | 8115 | 469 | 8 |
2197534 | 2197534 | 2022-02-09 | Butte | Idaho | 16023 | 469 | 7 |
2194280 | 2194280 | 2022-02-08 | Butte | Idaho | 16023 | 469 | 7 |
2193295 | 2193295 | 2022-02-07 | Sherman | Texas | 48421 | 469 | 16 |
2190041 | 2190041 | 2022-02-06 | Sherman | Texas | 48421 | 469 | 16 |
2186788 | 2186788 | 2022-02-05 | Sherman | Texas | 48421 | 469 | 16 |
2160690 | 2160690 | 2022-01-28 | Knox | Texas | 48275 | 469 | 22 |
2149508 | 2149508 | 2022-01-25 | Cook | Minnesota | 27031 | 469 | 1 |
2145489 | 2145489 | 2022-01-24 | Custer | Idaho | 16037 | 469 | 7 |
2104670 | 2104670 | 2022-01-11 | Renville | North Dakota | 38075 | 469 | 15 |
2101062 | 2101062 | 2022-01-10 | Cherry | Nebraska | 31031 | 469 | 8 |
2098168 | 2098168 | 2022-01-09 | Renville | North Dakota | 38075 | 469 | 15 |
2098623 | 2098623 | 2022-01-09 | Jackson | South Dakota | 46071 | 469 | 19 |
2095371 | 2095371 | 2022-01-08 | Jackson | South Dakota | 46071 | 469 | 19 |
2092119 | 2092119 | 2022-01-07 | Jackson | South Dakota | 46071 | 469 | 19 |
2088056 | 2088056 | 2022-01-06 | Cherry | Nebraska | 31031 | 469 | 8 |
2089093 | 2089093 | 2022-01-06 | Hardeman | Texas | 48197 | 469 | 14 |
2085842 | 2085842 | 2022-01-05 | Hardeman | Texas | 48197 | 469 | 14 |
2079101 | 2079101 | 2022-01-03 | Faulk | South Dakota | 46049 | 469 | 16 |
2065616 | 2065616 | 2021-12-30 | Adams | North Dakota | 38001 | 469 | 8 |
2062193 | 2062193 | 2021-12-29 | Mora | New Mexico | 35033 | 469 | 14 |
2062366 | 2062366 | 2021-12-29 | Adams | North Dakota | 38001 | 469 | 8 |
2053083 | 2053083 | 2021-12-26 | Buffalo | South Dakota | 46017 | 469 | 16 |
2049833 | 2049833 | 2021-12-25 | Buffalo | South Dakota | 46017 | 469 | 16 |
2046583 | 2046583 | 2021-12-24 | Buffalo | South Dakota | 46017 | 469 | 16 |
2043333 | 2043333 | 2021-12-23 | Buffalo | South Dakota | 46017 | 469 | 16 |
2035283 | 2035283 | 2021-12-21 | Edwards | Kansas | 20047 | 469 | 13 |
2032033 | 2032033 | 2021-12-20 | Edwards | Kansas | 20047 | 469 | 13 |
2028782 | 2028782 | 2021-12-19 | Edwards | Kansas | 20047 | 469 | 13 |
2025531 | 2025531 | 2021-12-18 | Edwards | Kansas | 20047 | 469 | 13 |
2022280 | 2022280 | 2021-12-17 | Edwards | Kansas | 20047 | 469 | 13 |
2024134 | 2024134 | 2021-12-17 | Lipscomb | Texas | 48295 | 469 | 12 |
2013201 | 2013201 | 2021-12-14 | Scotland | Missouri | 29199 | 469 | 15 |
2004772 | 2004772 | 2021-12-11 | Grand Isle | Vermont | 50013 | 469 | 2 |
1996354 | 1996354 | 2021-12-09 | Woodson | Kansas | 20207 | 469 | 10 |
1993103 | 1993103 | 2021-12-08 | Woodson | Kansas | 20207 | 469 | 10 |
1984823 | 1984823 | 2021-12-05 | Buffalo | South Dakota | 46017 | 469 | 15 |
1981573 | 1981573 | 2021-12-04 | Buffalo | South Dakota | 46017 | 469 | 15 |
1978323 | 1978323 | 2021-12-03 | Buffalo | South Dakota | 46017 | 469 | 15 |
1970917 | 1970917 | 2021-12-01 | Mercer | Missouri | 29129 | 469 | 9 |
1968596 | 1968596 | 2021-11-30 | Hanson | South Dakota | 46061 | 469 | 5 |
1944253 | 1944253 | 2021-11-23 | Cheyenne | Kansas | 20023 | 469 | 14 |
1941003 | 1941003 | 2021-11-22 | Cheyenne | Kansas | 20023 | 469 | 14 |
1942615 | 1942615 | 2021-11-22 | Stanley | South Dakota | 46117 | 469 | 3 |
1897102 | 1897102 | 2021-11-08 | Marshall | South Dakota | 46091 | 469 | 8 |
1893213 | 1893213 | 2021-11-07 | Hamilton | New York | 36041 | 469 | 3 |
1876858 | 1876858 | 2021-11-02 | Valley | Nebraska | 31175 | 469 | 4 |
1877130 | 1877130 | 2021-11-02 | McIntosh | North Dakota | 38051 | 469 | 8 |
1873609 | 1873609 | 2021-11-01 | Valley | Nebraska | 31175 | 469 | 4 |
1846785 | 1846785 | 2021-10-24 | Gove | Kansas | 20063 | 469 | 22 |
1843535 | 1843535 | 2021-10-23 | Gove | Kansas | 20063 | 469 | 22 |
1840285 | 1840285 | 2021-10-22 | Gove | Kansas | 20063 | 469 | 22 |
1837036 | 1837036 | 2021-10-21 | Gove | Kansas | 20063 | 469 | 22 |
1833787 | 1833787 | 2021-10-20 | Gove | Kansas | 20063 | 469 | 22 |
1826025 | 1826025 | 2021-10-17 | Essex | Vermont | 50009 | 469 | 2 |
1740370 | 1740370 | 2021-09-21 | Nance | Nebraska | 31125 | 469 | 10 |
1738148 | 1738148 | 2021-09-20 | Kinney | Texas | 48271 | 469 | 8 |
1724163 | 1724163 | 2021-09-16 | Lincoln | Nevada | 32017 | 469 | 4 |
1719214 | 1719214 | 2021-09-15 | Dillingham Census Area | Alaska | 2070 | 469 | 4 |
1717067 | 1717067 | 2021-09-14 | Tensas | Louisiana | 22107 | 469 | 8 |
1701914 | 1701914 | 2021-09-09 | Wallowa | Oregon | 41063 | 469 | 6 |
1695172 | 1695172 | 2021-09-07 | Cavalier | North Dakota | 38019 | 469 | 5 |
1692690 | 1692690 | 2021-09-06 | Mason | Texas | 48319 | 469 | 6 |
1675982 | 1675982 | 2021-09-01 | Sullivan | Pennsylvania | 42113 | 469 | 21 |
1676346 | 1676346 | 2021-09-01 | Delta | Texas | 48119 | 469 | 15 |
1676627 | 1676627 | 2021-09-01 | Falls Church city | Virginia | 51610 | 469 | 8 |
1669224 | 1669224 | 2021-08-30 | Wells | North Dakota | 38103 | 469 | 8 |
1669640 | 1669640 | 2021-08-30 | Clark | South Dakota | 46025 | 469 | 5 |
1665977 | 1665977 | 2021-08-29 | Wells | North Dakota | 38103 | 469 | 8 |
1666393 | 1666393 | 2021-08-29 | Clark | South Dakota | 46025 | 469 | 5 |
1666402 | 1666402 | 2021-08-29 | Douglas | South Dakota | 46043 | 469 | 9 |
1663145 | 1663145 | 2021-08-28 | Clark | South Dakota | 46025 | 469 | 5 |
1663154 | 1663154 | 2021-08-28 | Douglas | South Dakota | 46043 | 469 | 9 |
1659897 | 1659897 | 2021-08-27 | Clark | South Dakota | 46025 | 469 | 5 |
1659906 | 1659906 | 2021-08-27 | Douglas | South Dakota | 46043 | 469 | 9 |
1655353 | 1655353 | 2021-08-26 | Unknown | Louisiana | 469 | 0 | |
1656648 | 1656648 | 2021-08-26 | Clark | South Dakota | 46025 | 469 | 5 |
1656657 | 1656657 | 2021-08-26 | Douglas | South Dakota | 46043 | 469 | 9 |
1653401 | 1653401 | 2021-08-25 | Clark | South Dakota | 46025 | 469 | 5 |
1653410 | 1653410 | 2021-08-25 | Douglas | South Dakota | 46043 | 469 | 9 |
1632068 | 1632068 | 2021-08-19 | Hardin | Illinois | 17069 | 469 | 12 |
1624419 | 1624419 | 2021-08-16 | Haskell | Texas | 48207 | 469 | 28 |
1621172 | 1621172 | 2021-08-15 | Haskell | Texas | 48207 | 469 | 28 |
1617924 | 1617924 | 2021-08-14 | Haskell | Texas | 48207 | 469 | 28 |
1614676 | 1614676 | 2021-08-13 | Haskell | Texas | 48207 | 469 | 28 |
1611427 | 1611427 | 2021-08-12 | Haskell | Texas | 48207 | 469 | 28 |
1606038 | 1606038 | 2021-08-11 | Lewis | Idaho | 16061 | 469 | 12 |
1604028 | 1604028 | 2021-08-10 | Hidalgo | New Mexico | 35023 | 469 | 9 |
1588199 | 1588199 | 2021-08-05 | Harney | Oregon | 41025 | 469 | 11 |
1576112 | 1576112 | 2021-08-01 | Wirt | West Virginia | 54105 | 469 | 4 |
1572864 | 1572864 | 2021-07-31 | Wirt | West Virginia | 54105 | 469 | 4 |
1569616 | 1569616 | 2021-07-30 | Wirt | West Virginia | 54105 | 469 | 4 |
1565556 | 1565556 | 2021-07-29 | Arroyo | Puerto Rico | 72015 | 469 | |
1566368 | 1566368 | 2021-07-29 | Wirt | West Virginia | 54105 | 469 | 4 |
1562308 | 1562308 | 2021-07-28 | Arroyo | Puerto Rico | 72015 | 469 | |
1563120 | 1563120 | 2021-07-28 | Wirt | West Virginia | 54105 | 469 | 4 |
1559060 | 1559060 | 2021-07-27 | Arroyo | Puerto Rico | 72015 | 469 |
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);