ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
285 rows where cases = 1778 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 20
- Iowa 18
- Mississippi 18
- Missouri 15
- Colorado 14
- Alabama 13
- Oklahoma 13
- Louisiana 12
- Puerto Rico 12
- Nebraska 11
- Texas 11
- Kansas 9
- Montana 9
- Virginia 9
- Illinois 8
- Arkansas 7
- Ohio 7
- Indiana 6
- Michigan 6
- Florida 5
- Kentucky 5
- Minnesota 5
- Tennessee 5
- West Virginia 5
- New York 4
- Pennsylvania 4
- Wisconsin 4
- North Carolina 3
- Rhode Island 3
- South Carolina 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2456803 | 2456803 | 2022-04-29 | Refugio | Texas | 48391 | 1778 | 36 |
2319041 | 2319041 | 2022-03-18 | Thurston | Nebraska | 31173 | 1778 | 21 |
2315788 | 2315788 | 2022-03-17 | Thurston | Nebraska | 31173 | 1778 | 21 |
2312535 | 2312535 | 2022-03-16 | Thurston | Nebraska | 31173 | 1778 | 21 |
2302779 | 2302779 | 2022-03-13 | Thurston | Nebraska | 31173 | 1778 | 21 |
2304018 | 2304018 | 2022-03-13 | Lancaster | Virginia | 51103 | 1778 | 30 |
2299527 | 2299527 | 2022-03-12 | Thurston | Nebraska | 31173 | 1778 | 21 |
2300766 | 2300766 | 2022-03-12 | Lancaster | Virginia | 51103 | 1778 | 30 |
2296275 | 2296275 | 2022-03-11 | Thurston | Nebraska | 31173 | 1778 | 21 |
2297514 | 2297514 | 2022-03-11 | Lancaster | Virginia | 51103 | 1778 | 30 |
2285041 | 2285041 | 2022-03-08 | Lake | Colorado | 8065 | 1778 | 2 |
2285695 | 2285695 | 2022-03-08 | Greenwood | Kansas | 20073 | 1778 | 22 |
2281789 | 2281789 | 2022-03-07 | Lake | Colorado | 8065 | 1778 | 2 |
2282443 | 2282443 | 2022-03-07 | Greenwood | Kansas | 20073 | 1778 | 22 |
2245176 | 2245176 | 2022-02-23 | Delta | Texas | 48119 | 1778 | 24 |
2238996 | 2238996 | 2022-02-21 | Middlesex | Virginia | 51119 | 1778 | 42 |
2221270 | 2221270 | 2022-02-16 | Harrison | Missouri | 29081 | 1778 | 28 |
2221374 | 2221374 | 2022-02-16 | Madison | Montana | 30057 | 1778 | 20 |
2219322 | 2219322 | 2022-02-15 | Stephens | Texas | 48429 | 1778 | 39 |
2211264 | 2211264 | 2022-02-13 | Lake | Michigan | 26085 | 1778 | 34 |
2208011 | 2208011 | 2022-02-12 | Lake | Michigan | 26085 | 1778 | 34 |
2204758 | 2204758 | 2022-02-11 | Lake | Michigan | 26085 | 1778 | 34 |
2202561 | 2202561 | 2022-02-10 | Arroyo | Puerto Rico | 72015 | 1778 | |
2192139 | 2192139 | 2022-02-07 | Butler | Nebraska | 31023 | 1778 | 14 |
2167700 | 2167700 | 2022-01-31 | Choctaw | Alabama | 1023 | 1778 | 33 |
2146355 | 2146355 | 2022-01-24 | Humphreys | Mississippi | 28053 | 1778 | 39 |
2133510 | 2133510 | 2022-01-20 | Beaverhead | Montana | 30001 | 1778 | 24 |
2112949 | 2112949 | 2022-01-14 | Boundary | Idaho | 16021 | 1778 | 51 |
2109252 | 2109252 | 2022-01-13 | Cleveland | Arkansas | 5025 | 1778 | 33 |
2110671 | 2110671 | 2022-01-13 | Howard | Missouri | 29089 | 1778 | 21 |
2110755 | 2110755 | 2022-01-13 | Deer Lodge | Montana | 30023 | 1778 | 28 |
2079388 | 2079388 | 2022-01-03 | Live Oak | Texas | 48297 | 1778 | 38 |
2056686 | 2056686 | 2021-12-27 | Runnels | Texas | 48399 | 1778 | 56 |
2049773 | 2049773 | 2021-12-25 | Yauco | Puerto Rico | 72153 | 1778 | |
2012206 | 2012206 | 2021-12-14 | Teton | Idaho | 16081 | 1778 | 7 |
2005398 | 2005398 | 2021-12-12 | Park | Colorado | 8093 | 1778 | 13 |
2002147 | 2002147 | 2021-12-11 | Park | Colorado | 8093 | 1778 | 13 |
1998897 | 1998897 | 2021-12-10 | Park | Colorado | 8093 | 1778 | 13 |
1994571 | 1994571 | 2021-12-08 | Bon Homme | South Dakota | 46009 | 1778 | 30 |
1973965 | 1973965 | 2021-12-02 | Koochiching | Minnesota | 27071 | 1778 | 25 |
1970884 | 1970884 | 2021-12-01 | Douglas | Missouri | 29067 | 1778 | 63 |
1944207 | 1944207 | 2021-11-23 | Mitchell | Iowa | 19131 | 1778 | 43 |
1940957 | 1940957 | 2021-11-22 | Mitchell | Iowa | 19131 | 1778 | 43 |
1941852 | 1941852 | 2021-11-22 | Unknown | Nebraska | 1778 | 210 | |
1937707 | 1937707 | 2021-11-21 | Mitchell | Iowa | 19131 | 1778 | 43 |
1939215 | 1939215 | 2021-11-21 | Juana Diaz | Puerto Rico | 72075 | 1778 | |
1934457 | 1934457 | 2021-11-20 | Mitchell | Iowa | 19131 | 1778 | 43 |
1935965 | 1935965 | 2021-11-20 | Juana Diaz | Puerto Rico | 72075 | 1778 | |
1931206 | 1931206 | 2021-11-19 | Mitchell | Iowa | 19131 | 1778 | 43 |
1932715 | 1932715 | 2021-11-19 | Juana Diaz | Puerto Rico | 72075 | 1778 | |
1927135 | 1927135 | 2021-11-18 | Lowndes | Alabama | 1085 | 1778 | 68 |
1927955 | 1927955 | 2021-11-18 | Mitchell | Iowa | 19131 | 1778 | 43 |
1928984 | 1928984 | 2021-11-18 | Schuyler | New York | 36097 | 1778 | 19 |
1929238 | 1929238 | 2021-11-18 | Vinton | Ohio | 39163 | 1778 | 33 |
1929464 | 1929464 | 2021-11-18 | Juana Diaz | Puerto Rico | 72075 | 1778 | |
1924705 | 1924705 | 2021-11-17 | Mitchell | Iowa | 19131 | 1778 | 43 |
1907637 | 1907637 | 2021-11-12 | Lowndes | Alabama | 1085 | 1778 | 67 |
1904388 | 1904388 | 2021-11-11 | Lowndes | Alabama | 1085 | 1778 | 67 |
1901138 | 1901138 | 2021-11-10 | Lowndes | Alabama | 1085 | 1778 | 67 |
1899474 | 1899474 | 2021-11-09 | Fergus | Montana | 30027 | 1778 | 43 |
1895125 | 1895125 | 2021-11-08 | Towns | Georgia | 13281 | 1778 | 82 |
1891388 | 1891388 | 2021-11-07 | Lowndes | Alabama | 1085 | 1778 | 65 |
1891875 | 1891875 | 2021-11-07 | Towns | Georgia | 13281 | 1778 | 82 |
1888138 | 1888138 | 2021-11-06 | Lowndes | Alabama | 1085 | 1778 | 65 |
1888625 | 1888625 | 2021-11-06 | Towns | Georgia | 13281 | 1778 | 82 |
1885375 | 1885375 | 2021-11-05 | Towns | Georgia | 13281 | 1778 | 82 |
1879459 | 1879459 | 2021-11-03 | Todd | Kentucky | 21219 | 1778 | 31 |
1876755 | 1876755 | 2021-11-02 | Richland | Montana | 30083 | 1778 | 21 |
1853490 | 1853490 | 2021-10-26 | Catahoula | Louisiana | 22025 | 1778 | 48 |
1854559 | 1854559 | 2021-10-26 | Nowata | Oklahoma | 40105 | 1778 | 28 |
1851310 | 1851310 | 2021-10-25 | Nowata | Oklahoma | 40105 | 1778 | 28 |
1852018 | 1852018 | 2021-10-25 | Caledonia | Vermont | 50005 | 1778 | 15 |
1848060 | 1848060 | 2021-10-24 | Nowata | Oklahoma | 40105 | 1778 | 28 |
1844810 | 1844810 | 2021-10-23 | Nowata | Oklahoma | 40105 | 1778 | 28 |
1841560 | 1841560 | 2021-10-22 | Nowata | Oklahoma | 40105 | 1778 | 28 |
1841702 | 1841702 | 2021-10-22 | Camuy | Puerto Rico | 72027 | 1778 | |
1838311 | 1838311 | 2021-10-21 | Nowata | Oklahoma | 40105 | 1778 | 28 |
1835062 | 1835062 | 2021-10-20 | Nowata | Oklahoma | 40105 | 1778 | 28 |
1835341 | 1835341 | 2021-10-20 | Dewey | South Dakota | 46041 | 1778 | 31 |
1821958 | 1821958 | 2021-10-16 | Harrison | Ohio | 39067 | 1778 | 42 |
1800639 | 1800639 | 2021-10-10 | Gunnison | Colorado | 8051 | 1778 | 9 |
1797390 | 1797390 | 2021-10-09 | Gunnison | Colorado | 8051 | 1778 | 9 |
1794141 | 1794141 | 2021-10-08 | Gunnison | Colorado | 8051 | 1778 | 9 |
1768773 | 1768773 | 2021-09-30 | Allen | Kansas | 20001 | 1778 | 25 |
1765524 | 1765524 | 2021-09-29 | Allen | Kansas | 20001 | 1778 | 25 |
1761335 | 1761335 | 2021-09-27 | Richland | Wisconsin | 55103 | 1778 | 19 |
1751516 | 1751516 | 2021-09-24 | Morgan | West Virginia | 54065 | 1778 | 31 |
1730445 | 1730445 | 2021-09-18 | Linn | Missouri | 29115 | 1778 | 24 |
1727195 | 1727195 | 2021-09-17 | Linn | Missouri | 29115 | 1778 | 24 |
1720788 | 1720788 | 2021-09-15 | Park | Montana | 30067 | 1778 | 24 |
1682500 | 1682500 | 2021-09-03 | Barranquitas | Puerto Rico | 72019 | 1778 | |
1668183 | 1668183 | 2021-08-30 | Butler | Kentucky | 21031 | 1778 | 28 |
1664389 | 1664389 | 2021-08-29 | Jasper | Georgia | 13159 | 1778 | 41 |
1661141 | 1661141 | 2021-08-28 | Jasper | Georgia | 13159 | 1778 | 41 |
1657893 | 1657893 | 2021-08-27 | Jasper | Georgia | 13159 | 1778 | 41 |
1655310 | 1655310 | 2021-08-26 | Claiborne | Louisiana | 22027 | 1778 | 57 |
1649133 | 1649133 | 2021-08-24 | Lawrence | Mississippi | 28077 | 1778 | 28 |
1649168 | 1649168 | 2021-08-24 | Walthall | Mississippi | 28147 | 1778 | 53 |
1634558 | 1634558 | 2021-08-19 | McDowell | West Virginia | 54047 | 1778 | 27 |
1585700 | 1585700 | 2021-08-04 | King George | Virginia | 51099 | 1778 | 20 |
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);