ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
241 rows where cases = 2060 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kentucky 22
- Missouri 15
- Georgia 12
- Tennessee 12
- West Virginia 12
- Michigan 11
- Montana 11
- Alabama 10
- Iowa 10
- Mississippi 10
- Texas 10
- Illinois 9
- Minnesota 7
- Oklahoma 7
- Virginia 7
- Arkansas 6
- New Hampshire 6
- North Carolina 6
- Indiana 5
- Louisiana 5
- South Carolina 4
- Florida 3
- Kansas 3
- New York 3
- Ohio 3
- Puerto Rico 3
- Vermont 3
- California 2
- Maine 2
- New Mexico 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2439318 | 2439318 | 2022-04-24 | Carbon | Montana | 30009 | 2060 | 28 |
2436062 | 2436062 | 2022-04-23 | Carbon | Montana | 30009 | 2060 | 28 |
2432806 | 2432806 | 2022-04-22 | Carbon | Montana | 30009 | 2060 | 28 |
2429550 | 2429550 | 2022-04-21 | Carbon | Montana | 30009 | 2060 | 28 |
2333436 | 2333436 | 2022-03-22 | Pleasants | West Virginia | 54073 | 2060 | 34 |
2328409 | 2328409 | 2022-03-21 | Lake | Minnesota | 27075 | 2060 | 28 |
2330182 | 2330182 | 2022-03-21 | Pleasants | West Virginia | 54073 | 2060 | 34 |
2326930 | 2326930 | 2022-03-20 | Pleasants | West Virginia | 54073 | 2060 | 34 |
2323677 | 2323677 | 2022-03-19 | Pleasants | West Virginia | 54073 | 2060 | 34 |
2320423 | 2320423 | 2022-03-18 | Pleasants | West Virginia | 54073 | 2060 | 34 |
2315344 | 2315344 | 2022-03-17 | Presque Isle | Michigan | 26141 | 2060 | 56 |
2312091 | 2312091 | 2022-03-16 | Presque Isle | Michigan | 26141 | 2060 | 56 |
2312142 | 2312142 | 2022-03-16 | Lake | Minnesota | 27075 | 2060 | 28 |
2305890 | 2305890 | 2022-03-14 | Blaine | Montana | 30005 | 2060 | 31 |
2302639 | 2302639 | 2022-03-13 | Blaine | Montana | 30005 | 2060 | 31 |
2299387 | 2299387 | 2022-03-12 | Blaine | Montana | 30005 | 2060 | 31 |
2296135 | 2296135 | 2022-03-11 | Blaine | Montana | 30005 | 2060 | 31 |
2262417 | 2262417 | 2022-03-01 | Clinch | Georgia | 13065 | 2060 | 38 |
2255667 | 2255667 | 2022-02-27 | Searcy | Arkansas | 5129 | 2060 | 41 |
2199805 | 2199805 | 2022-02-09 | Somervell | Texas | 48425 | 2060 | 31 |
2188739 | 2188739 | 2022-02-06 | Gentry | Missouri | 29075 | 2060 | 28 |
2190353 | 2190353 | 2022-02-06 | Tyler | West Virginia | 54095 | 2060 | 27 |
2182228 | 2182228 | 2022-02-04 | DeKalb | Missouri | 29063 | 2060 | 42 |
2175621 | 2175621 | 2022-02-02 | Claiborne | Mississippi | 28021 | 2060 | 44 |
2171043 | 2171043 | 2022-02-01 | Greenlee | Arizona | 4011 | 2060 | 30 |
2172013 | 2172013 | 2022-02-01 | Livingston | Kentucky | 21139 | 2060 | 51 |
2154384 | 2154384 | 2022-01-26 | Essex | Virginia | 51057 | 2060 | 22 |
2138461 | 2138461 | 2022-01-22 | Sumter | Alabama | 1119 | 2060 | 42 |
2131531 | 2131531 | 2022-01-19 | Emery | Utah | 49015 | 2060 | 25 |
2125551 | 2125551 | 2022-01-18 | Perry | Arkansas | 5105 | 2060 | 27 |
2110660 | 2110660 | 2022-01-13 | Douglas | Missouri | 29067 | 2060 | 68 |
2103141 | 2103141 | 2022-01-11 | Screven | Georgia | 13251 | 2060 | 62 |
2100791 | 2100791 | 2022-01-10 | Yellow Medicine | Minnesota | 27173 | 2060 | 25 |
2084675 | 2084675 | 2022-01-05 | Linn | Missouri | 29115 | 2060 | 58 |
2062937 | 2062937 | 2021-12-29 | Lake | Tennessee | 47095 | 2060 | 34 |
2047481 | 2047481 | 2021-12-25 | Chicot | Arkansas | 5017 | 2060 | 48 |
2044231 | 2044231 | 2021-12-24 | Chicot | Arkansas | 5017 | 2060 | 48 |
1975259 | 1975259 | 2021-12-02 | Camp | Texas | 48063 | 2060 | 67 |
1960849 | 1960849 | 2021-11-28 | Arenac | Michigan | 26011 | 2060 | 44 |
1957598 | 1957598 | 2021-11-27 | Arenac | Michigan | 26011 | 2060 | 44 |
1954347 | 1954347 | 2021-11-26 | Arenac | Michigan | 26011 | 2060 | 44 |
1951096 | 1951096 | 2021-11-25 | Arenac | Michigan | 26011 | 2060 | 44 |
1947845 | 1947845 | 2021-11-24 | Arenac | Michigan | 26011 | 2060 | 44 |
1929443 | 1929443 | 2021-11-18 | Cayey | Puerto Rico | 72035 | 2060 | |
1915108 | 1915108 | 2021-11-14 | Breathitt | Kentucky | 21025 | 2060 | 38 |
1915433 | 1915433 | 2021-11-14 | Chippewa | Minnesota | 27023 | 2060 | 40 |
1915671 | 1915671 | 2021-11-14 | Pemiscot | Missouri | 29155 | 2060 | 44 |
1911858 | 1911858 | 2021-11-13 | Breathitt | Kentucky | 21025 | 2060 | 38 |
1912183 | 1912183 | 2021-11-13 | Chippewa | Minnesota | 27023 | 2060 | 40 |
1912421 | 1912421 | 2021-11-13 | Pemiscot | Missouri | 29155 | 2060 | 44 |
1908609 | 1908609 | 2021-11-12 | Breathitt | Kentucky | 21025 | 2060 | 38 |
1908933 | 1908933 | 2021-11-12 | Chippewa | Minnesota | 27023 | 2060 | 40 |
1909171 | 1909171 | 2021-11-12 | Pemiscot | Missouri | 29155 | 2060 | 44 |
1898812 | 1898812 | 2021-11-09 | Osage | Kansas | 20139 | 2060 | 38 |
1895562 | 1895562 | 2021-11-08 | Osage | Kansas | 20139 | 2060 | 38 |
1892443 | 1892443 | 2021-11-07 | Pendleton | Kentucky | 21191 | 2060 | 20 |
1889193 | 1889193 | 2021-11-06 | Pendleton | Kentucky | 21191 | 2060 | 20 |
1885943 | 1885943 | 2021-11-05 | Pendleton | Kentucky | 21191 | 2060 | 20 |
1879023 | 1879023 | 2021-11-03 | Piatt | Illinois | 17147 | 2060 | 20 |
1856237 | 1856237 | 2021-10-27 | Greene | Illinois | 17061 | 2060 | 53 |
1852988 | 1852988 | 2021-10-26 | Greene | Illinois | 17061 | 2060 | 53 |
1853774 | 1853774 | 2021-10-26 | Amite | Mississippi | 28005 | 2060 | 56 |
1832182 | 1832182 | 2021-10-19 | Jackson | Tennessee | 47087 | 2060 | 40 |
1815013 | 1815013 | 2021-10-14 | Park | Montana | 30067 | 2060 | 27 |
1790771 | 1790771 | 2021-10-07 | Lee | Arkansas | 5077 | 2060 | 48 |
1782123 | 1782123 | 2021-10-04 | Antrim | Michigan | 26009 | 2060 | 35 |
1762579 | 1762579 | 2021-09-28 | Waldo | Maine | 23027 | 2060 | 29 |
1763202 | 1763202 | 2021-09-28 | Grant | New Mexico | 35017 | 2060 | 48 |
1746589 | 1746589 | 2021-09-23 | Lawrence | Mississippi | 28077 | 2060 | 33 |
1746701 | 1746701 | 2021-09-23 | Mississippi | Missouri | 29133 | 2060 | 34 |
1744696 | 1744696 | 2021-09-22 | Pecos | Texas | 48371 | 2060 | 41 |
1741579 | 1741579 | 2021-09-21 | Buchanan | Virginia | 51027 | 2060 | 47 |
1723406 | 1723406 | 2021-09-16 | Butler | Kentucky | 21031 | 2060 | 29 |
1723964 | 1723964 | 2021-09-16 | Osage | Missouri | 29151 | 2060 | 20 |
1724864 | 1724864 | 2021-09-16 | Clay | South Dakota | 46027 | 2060 | 15 |
1718127 | 1718127 | 2021-09-14 | Crook | Oregon | 41013 | 2060 | 37 |
1719102 | 1719102 | 2021-09-14 | Sawyer | Wisconsin | 55113 | 2060 | 29 |
1702779 | 1702779 | 2021-09-09 | McDowell | West Virginia | 54047 | 2060 | 28 |
1671306 | 1671306 | 2021-08-31 | Winneshiek | Iowa | 19191 | 2060 | 37 |
1668059 | 1668059 | 2021-08-30 | Winneshiek | Iowa | 19191 | 2060 | 37 |
1668280 | 1668280 | 2021-08-30 | Union | Kentucky | 21225 | 2060 | 20 |
1664812 | 1664812 | 2021-08-29 | Winneshiek | Iowa | 19191 | 2060 | 37 |
1661564 | 1661564 | 2021-08-28 | Winneshiek | Iowa | 19191 | 2060 | 37 |
1658316 | 1658316 | 2021-08-27 | Winneshiek | Iowa | 19191 | 2060 | 37 |
1655068 | 1655068 | 2021-08-26 | Winneshiek | Iowa | 19191 | 2060 | 37 |
1651821 | 1651821 | 2021-08-25 | Winneshiek | Iowa | 19191 | 2060 | 37 |
1652898 | 1652898 | 2021-08-25 | Northampton | North Carolina | 37131 | 2060 | 62 |
1649991 | 1649991 | 2021-08-24 | Montour | Pennsylvania | 42093 | 2060 | 67 |
1630228 | 1630228 | 2021-08-18 | Richland | North Dakota | 38077 | 2060 | 17 |
1618639 | 1618639 | 2021-08-15 | Del Norte | California | 6015 | 2060 | 10 |
1606638 | 1606638 | 2021-08-11 | Aroostook | Maine | 23003 | 2060 | 53 |
1602836 | 1602836 | 2021-08-10 | Hancock | Illinois | 17067 | 2060 | 42 |
1549365 | 1549365 | 2021-07-24 | Naranjito | Puerto Rico | 72105 | 2060 | |
1546118 | 1546118 | 2021-07-23 | Naranjito | Puerto Rico | 72105 | 2060 | |
1540148 | 1540148 | 2021-07-21 | Bennington | Vermont | 50003 | 2060 | 15 |
1536901 | 1536901 | 2021-07-20 | Bennington | Vermont | 50003 | 2060 | 15 |
1536989 | 1536989 | 2021-07-20 | Louisa | Virginia | 51109 | 2060 | 34 |
1533653 | 1533653 | 2021-07-19 | Bennington | Vermont | 50003 | 2060 | 15 |
1494934 | 1494934 | 2021-07-07 | Wyoming | West Virginia | 54109 | 2060 | 41 |
1490729 | 1490729 | 2021-07-06 | Marshall | Oklahoma | 40095 | 2060 | 23 |
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);