ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
588 rows where cases = 459 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- North Dakota 52
- Texas 43
- Georgia 32
- South Dakota 32
- Kentucky 30
- Puerto Rico 26
- Kansas 25
- Virginia 24
- Oklahoma 23
- Missouri 18
- Nebraska 17
- Iowa 16
- Mississippi 16
- Montana 14
- Illinois 13
- Colorado 12
- Michigan 12
- Alaska 11
- Ohio 11
- Pennsylvania 11
- Louisiana 10
- North Carolina 10
- West Virginia 10
- Alabama 9
- Arkansas 9
- Indiana 9
- New York 9
- Oregon 9
- Idaho 8
- New Mexico 8
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501597 | 2501597 | 2022-05-13 | Divide | North Dakota | 38023 | 459 | 4 |
2498339 | 2498339 | 2022-05-12 | Divide | North Dakota | 38023 | 459 | 4 |
2495081 | 2495081 | 2022-05-11 | Divide | North Dakota | 38023 | 459 | 4 |
2491823 | 2491823 | 2022-05-10 | Divide | North Dakota | 38023 | 459 | 4 |
2488565 | 2488565 | 2022-05-09 | Divide | North Dakota | 38023 | 459 | 4 |
2485308 | 2485308 | 2022-05-08 | Divide | North Dakota | 38023 | 459 | 4 |
2482050 | 2482050 | 2022-05-07 | Divide | North Dakota | 38023 | 459 | 4 |
2478792 | 2478792 | 2022-05-06 | Divide | North Dakota | 38023 | 459 | 4 |
2251686 | 2251686 | 2022-02-25 | Edwards | Texas | 48137 | 459 | 11 |
2248435 | 2248435 | 2022-02-24 | Edwards | Texas | 48137 | 459 | 11 |
2245184 | 2245184 | 2022-02-23 | Edwards | Texas | 48137 | 459 | 11 |
2239331 | 2239331 | 2022-02-22 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 459 | 5 |
2236080 | 2236080 | 2022-02-21 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 459 | 5 |
2232829 | 2232829 | 2022-02-20 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 459 | 5 |
2229578 | 2229578 | 2022-02-19 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 459 | 5 |
2226327 | 2226327 | 2022-02-18 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 459 | 5 |
2194645 | 2194645 | 2022-02-08 | Hamilton | Kansas | 20075 | 459 | 3 |
2191391 | 2191391 | 2022-02-07 | Hamilton | Kansas | 20075 | 459 | 3 |
2172965 | 2172965 | 2022-02-01 | Golden Valley | North Dakota | 38033 | 459 | 4 |
2153444 | 2153444 | 2022-01-26 | Kidder | North Dakota | 38043 | 459 | 13 |
2147677 | 2147677 | 2022-01-24 | Knox | Texas | 48275 | 459 | 22 |
2132471 | 2132471 | 2022-01-20 | Custer | Idaho | 16037 | 459 | 7 |
2130276 | 2130276 | 2022-01-19 | Granite | Montana | 30039 | 459 | 6 |
2127126 | 2127126 | 2022-01-18 | Perkins | Nebraska | 31135 | 459 | 12 |
2110950 | 2110950 | 2022-01-13 | De Baca | New Mexico | 35011 | 459 | 3 |
2088861 | 2088861 | 2022-01-06 | Hand | South Dakota | 46059 | 459 | 8 |
2076122 | 2076122 | 2022-01-02 | Kimble | Texas | 48267 | 459 | 11 |
2072871 | 2072871 | 2022-01-01 | Kimble | Texas | 48267 | 459 | 11 |
2068886 | 2068886 | 2021-12-31 | Griggs | North Dakota | 38039 | 459 | 2 |
2069620 | 2069620 | 2021-12-31 | Kimble | Texas | 48267 | 459 | 11 |
2065635 | 2065635 | 2021-12-30 | Griggs | North Dakota | 38039 | 459 | 2 |
2066369 | 2066369 | 2021-12-30 | Kimble | Texas | 48267 | 459 | 11 |
2058797 | 2058797 | 2021-12-28 | Cherry | Nebraska | 31031 | 459 | 8 |
2030350 | 2030350 | 2021-12-19 | Faulk | South Dakota | 46049 | 459 | 15 |
2027099 | 2027099 | 2021-12-18 | Faulk | South Dakota | 46049 | 459 | 15 |
2023848 | 2023848 | 2021-12-17 | Faulk | South Dakota | 46049 | 459 | 15 |
2020116 | 2020116 | 2021-12-16 | Adams | North Dakota | 38001 | 459 | 8 |
2014333 | 2014333 | 2021-12-14 | Hardeman | Texas | 48197 | 459 | 14 |
2011082 | 2011082 | 2021-12-13 | Hardeman | Texas | 48197 | 459 | 14 |
2007831 | 2007831 | 2021-12-12 | Hardeman | Texas | 48197 | 459 | 14 |
2004580 | 2004580 | 2021-12-11 | Hardeman | Texas | 48197 | 459 | 14 |
2001329 | 2001329 | 2021-12-10 | Hardeman | Texas | 48197 | 459 | 14 |
1998079 | 1998079 | 2021-12-09 | Hardeman | Texas | 48197 | 459 | 14 |
1990906 | 1990906 | 2021-12-07 | Towner | North Dakota | 38095 | 459 | 11 |
1991214 | 1991214 | 2021-12-07 | Guanica | Puerto Rico | 72055 | 459 | |
1987963 | 1987963 | 2021-12-06 | Guanica | Puerto Rico | 72055 | 459 | |
1984713 | 1984713 | 2021-12-05 | Guanica | Puerto Rico | 72055 | 459 | |
1981463 | 1981463 | 2021-12-04 | Guanica | Puerto Rico | 72055 | 459 | |
1978213 | 1978213 | 2021-12-03 | Guanica | Puerto Rico | 72055 | 459 | |
1959859 | 1959859 | 2021-11-28 | Custer | Colorado | 8027 | 459 | 11 |
1945838 | 1945838 | 2021-11-23 | Hanson | South Dakota | 46061 | 459 | 5 |
1945862 | 1945862 | 2021-11-23 | Potter | South Dakota | 46107 | 459 | 5 |
1921502 | 1921502 | 2021-11-16 | Cheyenne | Kansas | 20023 | 459 | 14 |
1918252 | 1918252 | 2021-11-15 | Cheyenne | Kansas | 20023 | 459 | 14 |
1872119 | 1872119 | 2021-11-01 | Gilpin | Colorado | 8047 | 459 | 3 |
1873717 | 1873717 | 2021-11-01 | Hamilton | New York | 36041 | 459 | 3 |
1832075 | 1832075 | 2021-10-19 | Bennett | South Dakota | 46007 | 459 | 9 |
1814294 | 1814294 | 2021-10-14 | Gove | Kansas | 20063 | 459 | 22 |
1811045 | 1811045 | 2021-10-13 | Gove | Kansas | 20063 | 459 | 22 |
1792375 | 1792375 | 2021-10-07 | Stanton | Nebraska | 31167 | 459 | 11 |
1789126 | 1789126 | 2021-10-06 | Stanton | Nebraska | 31167 | 459 | 11 |
1777711 | 1777711 | 2021-10-03 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 459 | 5 |
1778184 | 1778184 | 2021-10-03 | Adams | Idaho | 16003 | 459 | 8 |
1774461 | 1774461 | 2021-10-02 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 459 | 5 |
1771211 | 1771211 | 2021-10-01 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 459 | 5 |
1767962 | 1767962 | 2021-09-30 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 459 | 5 |
1762372 | 1762372 | 2021-09-28 | Trego | Kansas | 20195 | 459 | 8 |
1763593 | 1763593 | 2021-09-28 | Roger Mills | Oklahoma | 40129 | 459 | 12 |
1759124 | 1759124 | 2021-09-27 | Trego | Kansas | 20195 | 459 | 8 |
1760344 | 1760344 | 2021-09-27 | Roger Mills | Oklahoma | 40129 | 459 | 12 |
1755876 | 1755876 | 2021-09-26 | Trego | Kansas | 20195 | 459 | 8 |
1757096 | 1757096 | 2021-09-26 | Roger Mills | Oklahoma | 40129 | 459 | 12 |
1752628 | 1752628 | 2021-09-25 | Trego | Kansas | 20195 | 459 | 8 |
1753848 | 1753848 | 2021-09-25 | Roger Mills | Oklahoma | 40129 | 459 | 12 |
1749379 | 1749379 | 2021-09-24 | Trego | Kansas | 20195 | 459 | 8 |
1750600 | 1750600 | 2021-09-24 | Roger Mills | Oklahoma | 40129 | 459 | 12 |
1746129 | 1746129 | 2021-09-23 | Trego | Kansas | 20195 | 459 | 8 |
1747350 | 1747350 | 2021-09-23 | Roger Mills | Oklahoma | 40129 | 459 | 12 |
1742880 | 1742880 | 2021-09-22 | Trego | Kansas | 20195 | 459 | 8 |
1744101 | 1744101 | 2021-09-22 | Roger Mills | Oklahoma | 40129 | 459 | 12 |
1741593 | 1741593 | 2021-09-21 | Craig | Virginia | 51045 | 459 | 6 |
1695846 | 1695846 | 2021-09-07 | Donley | Texas | 48129 | 459 | 16 |
1692598 | 1692598 | 2021-09-06 | Donley | Texas | 48129 | 459 | 16 |
1689349 | 1689349 | 2021-09-05 | Donley | Texas | 48129 | 459 | 16 |
1686099 | 1686099 | 2021-09-04 | Donley | Texas | 48129 | 459 | 16 |
1686191 | 1686191 | 2021-09-04 | Mason | Texas | 48319 | 459 | 6 |
1682848 | 1682848 | 2021-09-03 | Donley | Texas | 48129 | 459 | 16 |
1682940 | 1682940 | 2021-09-03 | Mason | Texas | 48319 | 459 | 6 |
1679598 | 1679598 | 2021-09-02 | Donley | Texas | 48129 | 459 | 15 |
1675679 | 1675679 | 2021-09-01 | Dunn | North Dakota | 38025 | 459 | 7 |
1671392 | 1671392 | 2021-08-31 | Rush | Kansas | 20165 | 459 | 15 |
1668145 | 1668145 | 2021-08-30 | Rush | Kansas | 20165 | 459 | 15 |
1664898 | 1664898 | 2021-08-29 | Rush | Kansas | 20165 | 459 | 15 |
1666885 | 1666885 | 2021-08-29 | Falls Church city | Virginia | 51610 | 459 | 8 |
1661650 | 1661650 | 2021-08-28 | Rush | Kansas | 20165 | 459 | 15 |
1663637 | 1663637 | 2021-08-28 | Falls Church city | Virginia | 51610 | 459 | 8 |
1658402 | 1658402 | 2021-08-27 | Rush | Kansas | 20165 | 459 | 15 |
1660389 | 1660389 | 2021-08-27 | Falls Church city | Virginia | 51610 | 459 | 8 |
1654736 | 1654736 | 2021-08-26 | Bear Lake | Idaho | 16007 | 459 | 6 |
1655154 | 1655154 | 2021-08-26 | Rush | Kansas | 20165 | 459 | 15 |
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);