ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
548 rows where cases = 888 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 68
- Minnesota 57
- Georgia 37
- Virginia 27
- Kentucky 23
- Arkansas 20
- Wyoming 20
- Kansas 19
- Vermont 19
- North Carolina 17
- Louisiana 16
- Michigan 16
- West Virginia 14
- Mississippi 13
- Missouri 13
- Nebraska 13
- Illinois 12
- Montana 12
- Colorado 11
- Ohio 10
- Oklahoma 10
- Tennessee 10
- Alabama 9
- Florida 9
- Iowa 8
- Puerto Rico 8
- Wisconsin 7
- South Carolina 6
- South Dakota 6
- Utah 6
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2472477 | 2472477 | 2022-05-04 | Roger Mills | Oklahoma | 40129 | 888 | 16 |
2469221 | 2469221 | 2022-05-03 | Roger Mills | Oklahoma | 40129 | 888 | 16 |
2465965 | 2465965 | 2022-05-02 | Roger Mills | Oklahoma | 40129 | 888 | 16 |
2462710 | 2462710 | 2022-05-01 | Roger Mills | Oklahoma | 40129 | 888 | 16 |
2459454 | 2459454 | 2022-04-30 | Roger Mills | Oklahoma | 40129 | 888 | 16 |
2456198 | 2456198 | 2022-04-29 | Roger Mills | Oklahoma | 40129 | 888 | 16 |
2452942 | 2452942 | 2022-04-28 | Roger Mills | Oklahoma | 40129 | 888 | 16 |
2450135 | 2450135 | 2022-04-27 | Cochran | Texas | 48079 | 888 | 23 |
2446878 | 2446878 | 2022-04-26 | Cochran | Texas | 48079 | 888 | 23 |
2443623 | 2443623 | 2022-04-25 | Cochran | Texas | 48079 | 888 | 23 |
2440367 | 2440367 | 2022-04-24 | Cochran | Texas | 48079 | 888 | 23 |
2437111 | 2437111 | 2022-04-23 | Cochran | Texas | 48079 | 888 | 23 |
2433855 | 2433855 | 2022-04-22 | Cochran | Texas | 48079 | 888 | 23 |
2430599 | 2430599 | 2022-04-21 | Cochran | Texas | 48079 | 888 | 23 |
2426544 | 2426544 | 2022-04-20 | Hamilton | New York | 36041 | 888 | 5 |
2264724 | 2264724 | 2022-03-01 | Haskell | Texas | 48207 | 888 | 39 |
2261474 | 2261474 | 2022-02-28 | Haskell | Texas | 48207 | 888 | 39 |
2258223 | 2258223 | 2022-02-27 | Haskell | Texas | 48207 | 888 | 39 |
2254972 | 2254972 | 2022-02-26 | Haskell | Texas | 48207 | 888 | 39 |
2251721 | 2251721 | 2022-02-25 | Haskell | Texas | 48207 | 888 | 39 |
2188594 | 2188594 | 2022-02-06 | Red Lake | Minnesota | 27125 | 888 | 11 |
2185341 | 2185341 | 2022-02-05 | Red Lake | Minnesota | 27125 | 888 | 11 |
2182089 | 2182089 | 2022-02-04 | Red Lake | Minnesota | 27125 | 888 | 11 |
2174516 | 2174516 | 2022-02-02 | Unknown | Delaware | 888 | 0 | |
2155347 | 2155347 | 2022-01-27 | Pope | Illinois | 17151 | 888 | 7 |
2137839 | 2137839 | 2022-01-21 | Donley | Texas | 48129 | 888 | 20 |
2121762 | 2121762 | 2022-01-16 | Yoakum | Texas | 48501 | 888 | 37 |
2115196 | 2115196 | 2022-01-14 | Presidio | Texas | 48377 | 888 | 32 |
2109642 | 2109642 | 2022-01-13 | Schley | Georgia | 13249 | 888 | 8 |
2107554 | 2107554 | 2022-01-12 | Boone | Nebraska | 31011 | 888 | 4 |
2103306 | 2103306 | 2022-01-11 | Putnam | Illinois | 17155 | 888 | 8 |
2099074 | 2099074 | 2022-01-09 | Charles City | Virginia | 51036 | 888 | 22 |
2095823 | 2095823 | 2022-01-08 | Charles City | Virginia | 51036 | 888 | 22 |
2092571 | 2092571 | 2022-01-07 | Charles City | Virginia | 51036 | 888 | 22 |
2088087 | 2088087 | 2022-01-06 | Howard | Nebraska | 31093 | 888 | 15 |
2082780 | 2082780 | 2022-01-04 | Essex | Vermont | 50009 | 888 | 3 |
2065563 | 2065563 | 2021-12-30 | Hyde | North Carolina | 37095 | 888 | 12 |
2060507 | 2060507 | 2021-12-29 | Lafayette | Arkansas | 5073 | 888 | 28 |
2061493 | 2061493 | 2021-12-29 | Cameron | Louisiana | 22023 | 888 | 8 |
2057797 | 2057797 | 2021-12-28 | Scott | Illinois | 17171 | 888 | 7 |
2059615 | 2059615 | 2021-12-28 | Lyman | South Dakota | 46085 | 888 | 12 |
2018382 | 2018382 | 2021-12-16 | Huerfano | Colorado | 8055 | 888 | 23 |
2009857 | 2009857 | 2021-12-13 | Atchison | Missouri | 29005 | 888 | 18 |
2006606 | 2006606 | 2021-12-12 | Atchison | Missouri | 29005 | 888 | 18 |
2003355 | 2003355 | 2021-12-11 | Atchison | Missouri | 29005 | 888 | 18 |
1998147 | 1998147 | 2021-12-09 | Mills | Texas | 48333 | 888 | 28 |
1983310 | 1983310 | 2021-12-05 | Mitchell | Kansas | 20123 | 888 | 17 |
1983330 | 1983330 | 2021-12-05 | Rooks | Kansas | 20163 | 888 | 14 |
1980060 | 1980060 | 2021-12-04 | Mitchell | Kansas | 20123 | 888 | 17 |
1980080 | 1980080 | 2021-12-04 | Rooks | Kansas | 20163 | 888 | 14 |
1976810 | 1976810 | 2021-12-03 | Mitchell | Kansas | 20123 | 888 | 17 |
1976830 | 1976830 | 2021-12-03 | Rooks | Kansas | 20163 | 888 | 14 |
1973970 | 1973970 | 2021-12-02 | Lincoln | Minnesota | 27081 | 888 | 5 |
1961281 | 1961281 | 2021-11-28 | Burt | Nebraska | 31021 | 888 | 13 |
1958030 | 1958030 | 2021-11-27 | Burt | Nebraska | 31021 | 888 | 13 |
1954779 | 1954779 | 2021-11-26 | Burt | Nebraska | 31021 | 888 | 13 |
1951528 | 1951528 | 2021-11-25 | Burt | Nebraska | 31021 | 888 | 13 |
1948277 | 1948277 | 2021-11-24 | Burt | Nebraska | 31021 | 888 | 13 |
1946581 | 1946581 | 2021-11-23 | Hot Springs | Wyoming | 56017 | 888 | 10 |
1943330 | 1943330 | 2021-11-22 | Hot Springs | Wyoming | 56017 | 888 | 10 |
1940080 | 1940080 | 2021-11-21 | Hot Springs | Wyoming | 56017 | 888 | 10 |
1936830 | 1936830 | 2021-11-20 | Hot Springs | Wyoming | 56017 | 888 | 10 |
1933580 | 1933580 | 2021-11-19 | Hot Springs | Wyoming | 56017 | 888 | 10 |
1930328 | 1930328 | 2021-11-18 | Hot Springs | Wyoming | 56017 | 888 | 10 |
1927078 | 1927078 | 2021-11-17 | Hot Springs | Wyoming | 56017 | 888 | 10 |
1905698 | 1905698 | 2021-11-11 | Grant | Minnesota | 27051 | 888 | 9 |
1876074 | 1876074 | 2021-11-02 | Republic | Kansas | 20157 | 888 | 15 |
1872825 | 1872825 | 2021-11-01 | Republic | Kansas | 20157 | 888 | 15 |
1869576 | 1869576 | 2021-10-31 | Republic | Kansas | 20157 | 888 | 15 |
1866327 | 1866327 | 2021-10-30 | Republic | Kansas | 20157 | 888 | 15 |
1863078 | 1863078 | 2021-10-29 | Republic | Kansas | 20157 | 888 | 15 |
1837411 | 1837411 | 2021-10-21 | Montmorency | Michigan | 26119 | 888 | 26 |
1834162 | 1834162 | 2021-10-20 | Montmorency | Michigan | 26119 | 888 | 26 |
1832437 | 1832437 | 2021-10-19 | San Augustine | Texas | 48405 | 888 | 35 |
1829188 | 1829188 | 2021-10-18 | San Augustine | Texas | 48405 | 888 | 35 |
1825939 | 1825939 | 2021-10-17 | San Augustine | Texas | 48405 | 888 | 35 |
1822690 | 1822690 | 2021-10-16 | San Augustine | Texas | 48405 | 888 | 35 |
1819357 | 1819357 | 2021-10-15 | Jack | Texas | 48237 | 888 | 20 |
1819441 | 1819441 | 2021-10-15 | San Augustine | Texas | 48405 | 888 | 35 |
1816192 | 1816192 | 2021-10-14 | San Augustine | Texas | 48405 | 888 | 35 |
1812944 | 1812944 | 2021-10-13 | San Augustine | Texas | 48405 | 888 | 35 |
1808154 | 1808154 | 2021-10-12 | Lake | Michigan | 26085 | 888 | 19 |
1809374 | 1809374 | 2021-10-12 | McCook | South Dakota | 46087 | 888 | 25 |
1809695 | 1809695 | 2021-10-12 | San Augustine | Texas | 48405 | 888 | 35 |
1804903 | 1804903 | 2021-10-11 | Lake | Michigan | 26085 | 888 | 19 |
1806445 | 1806445 | 2021-10-11 | San Augustine | Texas | 48405 | 888 | 35 |
1803195 | 1803195 | 2021-10-10 | San Augustine | Texas | 48405 | 888 | 35 |
1799946 | 1799946 | 2021-10-09 | San Augustine | Texas | 48405 | 888 | 35 |
1796697 | 1796697 | 2021-10-08 | San Augustine | Texas | 48405 | 888 | 35 |
1770376 | 1770376 | 2021-09-30 | Kingsbury | South Dakota | 46077 | 888 | 18 |
1767820 | 1767820 | 2021-09-29 | Menominee | Wisconsin | 55078 | 888 | 11 |
1746582 | 1746582 | 2021-09-23 | Jefferson | Mississippi | 28063 | 888 | 33 |
1745031 | 1745031 | 2021-09-22 | Tucker | West Virginia | 54093 | 888 | 14 |
1741450 | 1741450 | 2021-09-21 | Presidio | Texas | 48377 | 888 | 26 |
1738201 | 1738201 | 2021-09-20 | Presidio | Texas | 48377 | 888 | 26 |
1734951 | 1734951 | 2021-09-19 | Presidio | Texas | 48377 | 888 | 26 |
1721630 | 1721630 | 2021-09-15 | Hamlin | South Dakota | 46057 | 888 | 40 |
1699744 | 1699744 | 2021-09-09 | Southeast Fairbanks Census Area | Alaska | 2240 | 888 | 7 |
1701596 | 1701596 | 2021-09-09 | Gates | North Carolina | 37073 | 888 | 14 |
1694522 | 1694522 | 2021-09-07 | Lake | Minnesota | 27075 | 888 | 21 |
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);