ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
328 rows where cases = 1644 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 31
- Iowa 24
- Missouri 19
- Kentucky 17
- Michigan 16
- Arkansas 15
- Illinois 14
- Minnesota 14
- Oklahoma 14
- Puerto Rico 12
- Mississippi 11
- Tennessee 11
- Alabama 10
- Georgia 9
- Kansas 8
- North Carolina 8
- Virginia 8
- South Dakota 7
- Colorado 6
- Florida 6
- New Mexico 5
- New York 5
- Washington 5
- West Virginia 5
- Wisconsin 5
- California 4
- Nebraska 4
- Vermont 4
- Virgin Islands 4
- Louisiana 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2495732 | 2495732 | 2022-05-11 | Coleman | Texas | 48083 | 1644 | 71 |
2315442 | 2315442 | 2022-03-17 | Wilkin | Minnesota | 27167 | 1644 | 22 |
2316274 | 2316274 | 2022-03-17 | Grant | Oregon | 41023 | 1644 | 18 |
2262292 | 2262292 | 2022-03-01 | Rio Blanco | Colorado | 8103 | 1644 | 13 |
2255023 | 2255023 | 2022-02-26 | Marion | Texas | 48315 | 1644 | 58 |
2237718 | 2237718 | 2022-02-21 | Merrick | Nebraska | 31121 | 1644 | 15 |
2188448 | 2188448 | 2022-02-06 | Alcona | Michigan | 26001 | 1644 | 67 |
2185195 | 2185195 | 2022-02-05 | Alcona | Michigan | 26001 | 1644 | 67 |
2181943 | 2181943 | 2022-02-04 | Alcona | Michigan | 26001 | 1644 | 67 |
2171837 | 2171837 | 2022-02-01 | Worth | Iowa | 19195 | 1644 | 11 |
2168584 | 2168584 | 2022-01-31 | Worth | Iowa | 19195 | 1644 | 11 |
2165329 | 2165329 | 2022-01-30 | Worth | Iowa | 19195 | 1644 | 11 |
2162074 | 2162074 | 2022-01-29 | Worth | Iowa | 19195 | 1644 | 11 |
2158819 | 2158819 | 2022-01-28 | Worth | Iowa | 19195 | 1644 | 11 |
2155565 | 2155565 | 2022-01-27 | Worth | Iowa | 19195 | 1644 | 11 |
2157157 | 2157157 | 2022-01-27 | Fall River | South Dakota | 46047 | 1644 | 36 |
2152312 | 2152312 | 2022-01-26 | Worth | Iowa | 19195 | 1644 | 11 |
2141966 | 2141966 | 2022-01-23 | Yuma | Colorado | 8125 | 1644 | 22 |
2138711 | 2138711 | 2022-01-22 | Yuma | Colorado | 8125 | 1644 | 22 |
2135455 | 2135455 | 2022-01-21 | Yuma | Colorado | 8125 | 1644 | 22 |
2136685 | 2136685 | 2022-01-21 | Harrison | Missouri | 29081 | 1644 | 27 |
2089506 | 2089506 | 2022-01-06 | Pleasants | West Virginia | 54073 | 1644 | 31 |
2076027 | 2076027 | 2022-01-02 | Clay | Texas | 48077 | 1644 | 26 |
2072776 | 2072776 | 2022-01-01 | Clay | Texas | 48077 | 1644 | 26 |
2069525 | 2069525 | 2021-12-31 | Clay | Texas | 48077 | 1644 | 26 |
2066274 | 2066274 | 2021-12-30 | Clay | Texas | 48077 | 1644 | 26 |
2062903 | 2062903 | 2021-12-29 | Clay | Tennessee | 47027 | 1644 | 40 |
2058182 | 2058182 | 2021-12-28 | Livingston | Kentucky | 21139 | 1644 | 49 |
2058653 | 2058653 | 2021-12-28 | Howard | Missouri | 29089 | 1644 | 19 |
2055233 | 2055233 | 2021-12-27 | Marshall | Minnesota | 27089 | 1644 | 23 |
2053622 | 2053622 | 2021-12-26 | Nelson | Virginia | 51125 | 1644 | 22 |
2050372 | 2050372 | 2021-12-25 | Nelson | Virginia | 51125 | 1644 | 22 |
2047122 | 2047122 | 2021-12-24 | Nelson | Virginia | 51125 | 1644 | 22 |
2039148 | 2039148 | 2021-12-22 | Gentry | Missouri | 29075 | 1644 | 28 |
2031429 | 2031429 | 2021-12-20 | Unknown | Connecticut | 1644 | 1 | |
2028827 | 2028827 | 2021-12-19 | Norton | Kansas | 20137 | 1644 | 35 |
2029154 | 2029154 | 2021-12-19 | Mackinac | Michigan | 26097 | 1644 | 18 |
2025576 | 2025576 | 2021-12-18 | Norton | Kansas | 20137 | 1644 | 35 |
2025903 | 2025903 | 2021-12-18 | Mackinac | Michigan | 26097 | 1644 | 18 |
2026666 | 2026666 | 2021-12-18 | Traill | North Dakota | 38097 | 1644 | 21 |
2022325 | 2022325 | 2021-12-17 | Norton | Kansas | 20137 | 1644 | 35 |
2022652 | 2022652 | 2021-12-17 | Mackinac | Michigan | 26097 | 1644 | 18 |
2006635 | 2006635 | 2021-12-12 | DeKalb | Missouri | 29063 | 1644 | 37 |
2003384 | 2003384 | 2021-12-11 | DeKalb | Missouri | 29063 | 1644 | 37 |
1996330 | 1996330 | 2021-12-09 | Rice | Kansas | 20159 | 1644 | 16 |
1993079 | 1993079 | 2021-12-08 | Rice | Kansas | 20159 | 1644 | 16 |
1968956 | 1968956 | 2021-11-30 | Trinity | Texas | 48455 | 1644 | 62 |
1946432 | 1946432 | 2021-11-23 | Pend Oreille | Washington | 53051 | 1644 | 24 |
1937984 | 1937984 | 2021-11-21 | East Carroll | Louisiana | 22035 | 1644 | 31 |
1934734 | 1934734 | 2021-11-20 | East Carroll | Louisiana | 22035 | 1644 | 31 |
1931483 | 1931483 | 2021-11-19 | East Carroll | Louisiana | 22035 | 1644 | 31 |
1926753 | 1926753 | 2021-11-17 | Addison | Vermont | 50001 | 1644 | 8 |
1909886 | 1909886 | 2021-11-12 | Forest | Pennsylvania | 42053 | 1644 | 25 |
1909930 | 1909930 | 2021-11-12 | Aguas Buenas | Puerto Rico | 72007 | 1644 | |
1906681 | 1906681 | 2021-11-11 | Aguas Buenas | Puerto Rico | 72007 | 1644 | |
1903432 | 1903432 | 2021-11-10 | Aguas Buenas | Puerto Rico | 72007 | 1644 | |
1900182 | 1900182 | 2021-11-09 | Aguas Buenas | Puerto Rico | 72007 | 1644 | |
1896932 | 1896932 | 2021-11-08 | Aguas Buenas | Puerto Rico | 72007 | 1644 | |
1878430 | 1878430 | 2021-11-03 | Nome Census Area | Alaska | 2180 | 1644 | 2 |
1880870 | 1880870 | 2021-11-03 | Todd | South Dakota | 46121 | 1644 | 36 |
1877565 | 1877565 | 2021-11-02 | Bon Homme | South Dakota | 46009 | 1644 | 29 |
1838904 | 1838904 | 2021-10-21 | Morris | Texas | 48343 | 1644 | 52 |
1835655 | 1835655 | 2021-10-20 | Morris | Texas | 48343 | 1644 | 52 |
1836106 | 1836106 | 2021-10-20 | Washakie | Wyoming | 56043 | 1644 | 32 |
1832406 | 1832406 | 2021-10-19 | Morris | Texas | 48343 | 1644 | 51 |
1823324 | 1823324 | 2021-10-17 | Mono | California | 6051 | 1644 | 5 |
1820075 | 1820075 | 2021-10-16 | Mono | California | 6051 | 1644 | 5 |
1816826 | 1816826 | 2021-10-15 | Mono | California | 6051 | 1644 | 5 |
1801479 | 1801479 | 2021-10-10 | Todd | Kentucky | 21219 | 1644 | 30 |
1798230 | 1798230 | 2021-10-09 | Todd | Kentucky | 21219 | 1644 | 30 |
1794981 | 1794981 | 2021-10-08 | Todd | Kentucky | 21219 | 1644 | 30 |
1792032 | 1792032 | 2021-10-07 | Watonwan | Minnesota | 27165 | 1644 | 11 |
1784189 | 1784189 | 2021-10-05 | Wilcox | Alabama | 1131 | 1644 | 37 |
1783768 | 1783768 | 2021-10-04 | Morgan | Utah | 49029 | 1644 | 11 |
1771290 | 1771290 | 2021-10-01 | Pike | Arkansas | 5109 | 1644 | 35 |
1770955 | 1770955 | 2021-09-30 | Klickitat | Washington | 53039 | 1644 | 15 |
1767100 | 1767100 | 2021-09-29 | Charles Mix | South Dakota | 46023 | 1644 | 26 |
1758303 | 1758303 | 2021-09-27 | Scott | Arkansas | 5127 | 1644 | 24 |
1739937 | 1739937 | 2021-09-21 | Missaukee | Michigan | 26113 | 1644 | 30 |
1736485 | 1736485 | 2021-09-20 | Pendleton | Kentucky | 21191 | 1644 | 12 |
1736688 | 1736688 | 2021-09-20 | Missaukee | Michigan | 26113 | 1644 | 30 |
1716729 | 1716729 | 2021-09-14 | Hancock | Iowa | 19081 | 1644 | 35 |
1713483 | 1713483 | 2021-09-13 | Hancock | Iowa | 19081 | 1644 | 35 |
1715126 | 1715126 | 2021-09-13 | Dewey | South Dakota | 46041 | 1644 | 30 |
1710236 | 1710236 | 2021-09-12 | Hancock | Iowa | 19081 | 1644 | 35 |
1710296 | 1710296 | 2021-09-12 | Allen | Kansas | 20001 | 1644 | 24 |
1706989 | 1706989 | 2021-09-11 | Hancock | Iowa | 19081 | 1644 | 35 |
1707049 | 1707049 | 2021-09-11 | Allen | Kansas | 20001 | 1644 | 24 |
1703741 | 1703741 | 2021-09-10 | Hancock | Iowa | 19081 | 1644 | 35 |
1703801 | 1703801 | 2021-09-10 | Allen | Kansas | 20001 | 1644 | 24 |
1700491 | 1700491 | 2021-09-09 | Hancock | Iowa | 19081 | 1644 | 35 |
1696423 | 1696423 | 2021-09-08 | Conecuh | Alabama | 1035 | 1644 | 36 |
1697242 | 1697242 | 2021-09-08 | Hancock | Iowa | 19081 | 1644 | 35 |
1681687 | 1681687 | 2021-09-03 | Dent | Missouri | 29065 | 1644 | 28 |
1671752 | 1671752 | 2021-08-31 | Chippewa | Minnesota | 27023 | 1644 | 39 |
1655523 | 1655523 | 2021-08-26 | Faribault | Minnesota | 27043 | 1644 | 22 |
1642245 | 1642245 | 2021-08-22 | Larue | Kentucky | 21123 | 1644 | 29 |
1638995 | 1638995 | 2021-08-21 | Larue | Kentucky | 21123 | 1644 | 29 |
1640855 | 1640855 | 2021-08-21 | Windsor | Vermont | 50027 | 1644 | 14 |
1635745 | 1635745 | 2021-08-20 | Larue | Kentucky | 21123 | 1644 | 29 |
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);