ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
566 rows where cases = 588 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 52
- Kansas 43
- South Dakota 39
- Missouri 26
- Georgia 22
- Minnesota 22
- Oklahoma 22
- Kentucky 20
- Nebraska 20
- Puerto Rico 18
- Virginia 18
- Illinois 17
- Ohio 16
- Mississippi 15
- Alabama 14
- Iowa 14
- Tennessee 14
- Louisiana 13
- Michigan 12
- North Dakota 11
- West Virginia 11
- Arkansas 10
- Indiana 10
- New Mexico 10
- North Carolina 10
- California 9
- Colorado 8
- Wisconsin 8
- Oregon 7
- Montana 6
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2498142 | 2498142 | 2022-05-12 | De Baca | New Mexico | 35011 | 588 | 6 |
2494884 | 2494884 | 2022-05-11 | De Baca | New Mexico | 35011 | 588 | 6 |
2446593 | 2446593 | 2022-04-26 | Maricao | Puerto Rico | 72093 | 588 | |
2443338 | 2443338 | 2022-04-25 | Maricao | Puerto Rico | 72093 | 588 | |
2440082 | 2440082 | 2022-04-24 | Maricao | Puerto Rico | 72093 | 588 | |
2170189 | 2170189 | 2022-01-31 | Jackson | South Dakota | 46071 | 588 | 20 |
2164693 | 2164693 | 2022-01-30 | Custer | Colorado | 8027 | 588 | 17 |
2165350 | 2165350 | 2022-01-30 | Decatur | Kansas | 20039 | 588 | 17 |
2162095 | 2162095 | 2022-01-29 | Decatur | Kansas | 20039 | 588 | 17 |
2158182 | 2158182 | 2022-01-28 | Custer | Colorado | 8027 | 588 | 17 |
2158840 | 2158840 | 2022-01-28 | Decatur | Kansas | 20039 | 588 | 17 |
2148250 | 2148250 | 2022-01-25 | Petersburg Borough | Alaska | 2195 | 588 | 2 |
2149126 | 2149126 | 2022-01-25 | Morton | Kansas | 20129 | 588 | 10 |
2150637 | 2150637 | 2022-01-25 | Buffalo | South Dakota | 46017 | 588 | 17 |
2144998 | 2144998 | 2022-01-24 | Petersburg Borough | Alaska | 2195 | 588 | 2 |
2145874 | 2145874 | 2022-01-24 | Morton | Kansas | 20129 | 588 | 10 |
2134416 | 2134416 | 2022-01-20 | Stanley | South Dakota | 46117 | 588 | 5 |
2127570 | 2127570 | 2022-01-18 | Harper | Oklahoma | 40059 | 588 | 10 |
2124318 | 2124318 | 2022-01-17 | Harper | Oklahoma | 40059 | 588 | 10 |
2121066 | 2121066 | 2022-01-16 | Harper | Oklahoma | 40059 | 588 | 10 |
2121554 | 2121554 | 2022-01-16 | Collingsworth | Texas | 48087 | 588 | 13 |
2117814 | 2117814 | 2022-01-15 | Harper | Oklahoma | 40059 | 588 | 10 |
2114563 | 2114563 | 2022-01-14 | Harper | Oklahoma | 40059 | 588 | 10 |
2111311 | 2111311 | 2022-01-13 | Harper | Oklahoma | 40059 | 588 | 10 |
2108059 | 2108059 | 2022-01-12 | Harper | Oklahoma | 40059 | 588 | 10 |
2105461 | 2105461 | 2022-01-11 | Shackelford | Texas | 48417 | 588 | 9 |
2101402 | 2101402 | 2022-01-10 | Hettinger | North Dakota | 38041 | 588 | 7 |
2097887 | 2097887 | 2022-01-09 | Webster | Nebraska | 31181 | 588 | 9 |
2094635 | 2094635 | 2022-01-08 | Webster | Nebraska | 31181 | 588 | 9 |
2091383 | 2091383 | 2022-01-07 | Webster | Nebraska | 31181 | 588 | 9 |
2075122 | 2075122 | 2022-01-02 | Valley | Nebraska | 31175 | 588 | 5 |
2071871 | 2071871 | 2022-01-01 | Valley | Nebraska | 31175 | 588 | 5 |
2068620 | 2068620 | 2021-12-31 | Valley | Nebraska | 31175 | 588 | 5 |
2065369 | 2065369 | 2021-12-30 | Valley | Nebraska | 31175 | 588 | 5 |
2062119 | 2062119 | 2021-12-29 | Valley | Nebraska | 31175 | 588 | 5 |
2062844 | 2062844 | 2021-12-29 | Douglas | South Dakota | 46043 | 588 | 14 |
2051585 | 2051585 | 2021-12-26 | Rawlins | Kansas | 20153 | 588 | 8 |
2053087 | 2053087 | 2021-12-26 | Clark | South Dakota | 46025 | 588 | 6 |
2048335 | 2048335 | 2021-12-25 | Rawlins | Kansas | 20153 | 588 | 8 |
2049381 | 2049381 | 2021-12-25 | Eddy | North Dakota | 38027 | 588 | 6 |
2049837 | 2049837 | 2021-12-25 | Clark | South Dakota | 46025 | 588 | 6 |
2045085 | 2045085 | 2021-12-24 | Rawlins | Kansas | 20153 | 588 | 8 |
2046131 | 2046131 | 2021-12-24 | Eddy | North Dakota | 38027 | 588 | 6 |
2046587 | 2046587 | 2021-12-24 | Clark | South Dakota | 46025 | 588 | 6 |
2041836 | 2041836 | 2021-12-23 | Rawlins | Kansas | 20153 | 588 | 8 |
2043337 | 2043337 | 2021-12-23 | Clark | South Dakota | 46025 | 588 | 6 |
2038586 | 2038586 | 2021-12-22 | Rawlins | Kansas | 20153 | 588 | 8 |
2036378 | 2036378 | 2021-12-21 | Cavalier | North Dakota | 38019 | 588 | 6 |
2036703 | 2036703 | 2021-12-21 | Arroyo | Puerto Rico | 72015 | 588 | |
2033128 | 2033128 | 2021-12-20 | Cavalier | North Dakota | 38019 | 588 | 6 |
2029878 | 2029878 | 2021-12-19 | Cavalier | North Dakota | 38019 | 588 | 6 |
2012594 | 2012594 | 2021-12-14 | Sheridan | Kansas | 20179 | 588 | 16 |
2009343 | 2009343 | 2021-12-13 | Sheridan | Kansas | 20179 | 588 | 16 |
1989145 | 1989145 | 2021-12-07 | Phillips | Colorado | 8095 | 588 | 15 |
1991069 | 1991069 | 2021-12-07 | Roger Mills | Oklahoma | 40129 | 588 | 12 |
1987818 | 1987818 | 2021-12-06 | Roger Mills | Oklahoma | 40129 | 588 | 12 |
1983406 | 1983406 | 2021-12-05 | Hickman | Kentucky | 21105 | 588 | 22 |
1983530 | 1983530 | 2021-12-05 | Unknown | Louisiana | 588 | 0 | |
1984568 | 1984568 | 2021-12-05 | Roger Mills | Oklahoma | 40129 | 588 | 12 |
1980156 | 1980156 | 2021-12-04 | Hickman | Kentucky | 21105 | 588 | 22 |
1980280 | 1980280 | 2021-12-04 | Unknown | Louisiana | 588 | 0 | |
1981318 | 1981318 | 2021-12-04 | Roger Mills | Oklahoma | 40129 | 588 | 12 |
1976906 | 1976906 | 2021-12-03 | Hickman | Kentucky | 21105 | 588 | 22 |
1977030 | 1977030 | 2021-12-03 | Unknown | Louisiana | 588 | 0 | |
1978068 | 1978068 | 2021-12-03 | Roger Mills | Oklahoma | 40129 | 588 | 12 |
1973657 | 1973657 | 2021-12-02 | Hickman | Kentucky | 21105 | 588 | 22 |
1973781 | 1973781 | 2021-12-02 | Unknown | Louisiana | 588 | 0 | |
1974818 | 1974818 | 2021-12-02 | Roger Mills | Oklahoma | 40129 | 588 | 12 |
1969439 | 1969439 | 2021-12-01 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 588 | 6 |
1971373 | 1971373 | 2021-12-01 | Emmons | North Dakota | 38029 | 588 | 16 |
1971569 | 1971569 | 2021-12-01 | Roger Mills | Oklahoma | 40129 | 588 | 12 |
1966780 | 1966780 | 2021-11-30 | Pope | Illinois | 17151 | 588 | 6 |
1965489 | 1965489 | 2021-11-29 | Baylor | Texas | 48023 | 588 | 24 |
1955375 | 1955375 | 2021-11-26 | Cameron | Pennsylvania | 42023 | 588 | 13 |
1922440 | 1922440 | 2021-11-16 | Union | New Mexico | 35059 | 588 | 12 |
1914773 | 1914773 | 2021-11-14 | Putnam | Illinois | 17155 | 588 | 5 |
1911523 | 1911523 | 2021-11-13 | Putnam | Illinois | 17155 | 588 | 5 |
1908274 | 1908274 | 2021-11-12 | Putnam | Illinois | 17155 | 588 | 5 |
1898783 | 1898783 | 2021-11-09 | Haskell | Kansas | 20081 | 588 | 9 |
1895533 | 1895533 | 2021-11-08 | Haskell | Kansas | 20081 | 588 | 9 |
1891010 | 1891010 | 2021-11-06 | Essex | Vermont | 50009 | 588 | 2 |
1850754 | 1850754 | 2021-10-25 | Musselshell | Montana | 30065 | 588 | 17 |
1818660 | 1818660 | 2021-10-15 | Sargent | North Dakota | 38081 | 588 | 7 |
1800641 | 1800641 | 2021-10-10 | Huerfano | Colorado | 8055 | 588 | 19 |
1797392 | 1797392 | 2021-10-09 | Huerfano | Colorado | 8055 | 588 | 19 |
1794143 | 1794143 | 2021-10-08 | Huerfano | Colorado | 8055 | 588 | 19 |
1762334 | 1762334 | 2021-09-28 | Meade | Kansas | 20119 | 588 | 14 |
1759086 | 1759086 | 2021-09-27 | Meade | Kansas | 20119 | 588 | 14 |
1707651 | 1707651 | 2021-09-11 | Atchison | Missouri | 29005 | 588 | 6 |
1702131 | 1702131 | 2021-09-09 | Corson | South Dakota | 46031 | 588 | 12 |
1698882 | 1698882 | 2021-09-08 | Corson | South Dakota | 46031 | 588 | 12 |
1691314 | 1691314 | 2021-09-06 | Unknown | Minnesota | 588 | 93 | |
1688064 | 1688064 | 2021-09-05 | Unknown | Minnesota | 588 | 93 | |
1689502 | 1689502 | 2021-09-05 | Sutton | Texas | 48435 | 588 | 10 |
1684814 | 1684814 | 2021-09-04 | Unknown | Minnesota | 588 | 93 | |
1681563 | 1681563 | 2021-09-03 | Unknown | Minnesota | 588 | 93 | |
1676895 | 1676895 | 2021-09-01 | Hot Springs | Wyoming | 56017 | 588 | 4 |
1654783 | 1654783 | 2021-08-26 | Calhoun | Illinois | 17013 | 588 | 5 |
1647891 | 1647891 | 2021-08-24 | Modoc | California | 6049 | 588 | 7 |
1644643 | 1644643 | 2021-08-23 | Modoc | California | 6049 | 588 | 7 |
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);