ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
330 rows where cases = 1789 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Mississippi 36
- Georgia 23
- Oklahoma 23
- Texas 22
- Iowa 19
- Tennessee 18
- Alabama 15
- Illinois 13
- Kansas 13
- Kentucky 13
- Missouri 13
- Colorado 11
- Virginia 11
- Louisiana 10
- Minnesota 10
- Puerto Rico 10
- Indiana 9
- Arkansas 8
- Ohio 8
- North Carolina 7
- Michigan 6
- Nebraska 5
- Idaho 4
- Pennsylvania 4
- South Dakota 4
- North Dakota 2
- South Carolina 2
- West Virginia 2
- Wisconsin 2
- Florida 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2471627 | 2471627 | 2022-05-04 | Mahnomen | Minnesota | 27087 | 1789 | 17 |
2376119 | 2376119 | 2022-04-05 | Lake | Colorado | 8065 | 1789 | 2 |
2372867 | 2372867 | 2022-04-04 | Lake | Colorado | 8065 | 1789 | 2 |
2369614 | 2369614 | 2022-04-03 | Lake | Colorado | 8065 | 1789 | 2 |
2366361 | 2366361 | 2022-04-02 | Lake | Colorado | 8065 | 1789 | 2 |
2363108 | 2363108 | 2022-04-01 | Lake | Colorado | 8065 | 1789 | 2 |
2359854 | 2359854 | 2022-03-31 | Lake | Colorado | 8065 | 1789 | 2 |
2251678 | 2251678 | 2022-02-25 | Delta | Texas | 48119 | 1789 | 24 |
2248427 | 2248427 | 2022-02-24 | Delta | Texas | 48119 | 1789 | 24 |
2238474 | 2238474 | 2022-02-21 | Fall River | South Dakota | 46047 | 1789 | 39 |
2235223 | 2235223 | 2022-02-20 | Fall River | South Dakota | 46047 | 1789 | 39 |
2231972 | 2231972 | 2022-02-19 | Fall River | South Dakota | 46047 | 1789 | 39 |
2228721 | 2228721 | 2022-02-18 | Fall River | South Dakota | 46047 | 1789 | 39 |
2212320 | 2212320 | 2022-02-13 | Arroyo | Puerto Rico | 72015 | 1789 | |
2209067 | 2209067 | 2022-02-12 | Arroyo | Puerto Rico | 72015 | 1789 | |
2196276 | 2196276 | 2022-02-08 | Hancock | Tennessee | 47067 | 1789 | 29 |
2193022 | 2193022 | 2022-02-07 | Hancock | Tennessee | 47067 | 1789 | 29 |
2189768 | 2189768 | 2022-02-06 | Hancock | Tennessee | 47067 | 1789 | 29 |
2186515 | 2186515 | 2022-02-05 | Hancock | Tennessee | 47067 | 1789 | 29 |
2183263 | 2183263 | 2022-02-04 | Hancock | Tennessee | 47067 | 1789 | 29 |
2178692 | 2178692 | 2022-02-03 | Alger | Michigan | 26003 | 1789 | 12 |
2180011 | 2180011 | 2022-02-03 | Hancock | Tennessee | 47067 | 1789 | 29 |
2175440 | 2175440 | 2022-02-02 | Alger | Michigan | 26003 | 1789 | 12 |
2176760 | 2176760 | 2022-02-02 | Hancock | Tennessee | 47067 | 1789 | 29 |
2176876 | 2176876 | 2022-02-02 | Crosby | Texas | 48107 | 1789 | 44 |
2170484 | 2170484 | 2022-01-31 | Mitchell | Texas | 48335 | 1789 | 46 |
2130186 | 2130186 | 2022-01-19 | Iron | Missouri | 29093 | 1789 | 33 |
2126501 | 2126501 | 2022-01-18 | Trimble | Kentucky | 21223 | 1789 | 30 |
2122528 | 2122528 | 2022-01-17 | Atkinson | Georgia | 13003 | 1789 | 39 |
2125274 | 2125274 | 2022-01-17 | Pleasants | West Virginia | 54073 | 1789 | 32 |
2115046 | 2115046 | 2022-01-14 | Clay | Texas | 48077 | 1789 | 26 |
2106351 | 2106351 | 2022-01-12 | Johnson | Georgia | 13167 | 1789 | 64 |
2106440 | 2106440 | 2022-01-12 | Benewah | Idaho | 16009 | 1789 | 31 |
2103145 | 2103145 | 2022-01-11 | Stewart | Georgia | 13259 | 1789 | 30 |
2104047 | 2104047 | 2022-01-11 | Benton | Mississippi | 28009 | 1789 | 42 |
2104162 | 2104162 | 2022-01-11 | Gentry | Missouri | 29075 | 1789 | 28 |
2105442 | 2105442 | 2022-01-11 | Rains | Texas | 48379 | 1789 | 49 |
2091150 | 2091150 | 2022-01-07 | DeKalb | Missouri | 29063 | 1789 | 38 |
2085892 | 2085892 | 2022-01-05 | Live Oak | Texas | 48297 | 1789 | 39 |
2028570 | 2028570 | 2021-12-19 | Benton | Indiana | 18007 | 1789 | 18 |
2028855 | 2028855 | 2021-12-19 | Thomas | Kansas | 20193 | 1789 | 23 |
2024653 | 2024653 | 2021-12-18 | Lowndes | Alabama | 1085 | 1789 | 68 |
2025319 | 2025319 | 2021-12-18 | Benton | Indiana | 18007 | 1789 | 18 |
2025604 | 2025604 | 2021-12-18 | Thomas | Kansas | 20193 | 1789 | 23 |
2021402 | 2021402 | 2021-12-17 | Lowndes | Alabama | 1085 | 1789 | 68 |
2021525 | 2021525 | 2021-12-17 | Pike | Arkansas | 5109 | 1789 | 38 |
2022068 | 2022068 | 2021-12-17 | Benton | Indiana | 18007 | 1789 | 18 |
2022353 | 2022353 | 2021-12-17 | Thomas | Kansas | 20193 | 1789 | 23 |
2023738 | 2023738 | 2021-12-17 | Loiza | Puerto Rico | 72087 | 1789 | |
2016261 | 2016261 | 2021-12-15 | Stevens | Minnesota | 27149 | 1789 | 11 |
2008422 | 2008422 | 2021-12-13 | Wilcox | Alabama | 1131 | 1789 | 38 |
2011021 | 2011021 | 2021-12-13 | Childress | Texas | 48075 | 1789 | 22 |
2005171 | 2005171 | 2021-12-12 | Wilcox | Alabama | 1131 | 1789 | 38 |
2007770 | 2007770 | 2021-12-12 | Childress | Texas | 48075 | 1789 | 22 |
2001920 | 2001920 | 2021-12-11 | Wilcox | Alabama | 1131 | 1789 | 38 |
2004519 | 2004519 | 2021-12-11 | Childress | Texas | 48075 | 1789 | 22 |
1995995 | 1995995 | 2021-12-09 | Jasper | Illinois | 17079 | 1789 | 23 |
1982833 | 1982833 | 2021-12-05 | Long | Georgia | 13183 | 1789 | 28 |
1983883 | 1983883 | 2021-12-05 | Douglas | Missouri | 29067 | 1789 | 63 |
1979583 | 1979583 | 2021-12-04 | Long | Georgia | 13183 | 1789 | 28 |
1980633 | 1980633 | 2021-12-04 | Douglas | Missouri | 29067 | 1789 | 63 |
1981473 | 1981473 | 2021-12-04 | Juana Diaz | Puerto Rico | 72075 | 1789 | |
1976333 | 1976333 | 2021-12-03 | Long | Georgia | 13183 | 1789 | 28 |
1978223 | 1978223 | 2021-12-03 | Juana Diaz | Puerto Rico | 72075 | 1789 | |
1969834 | 1969834 | 2021-12-01 | Long | Georgia | 13183 | 1789 | 28 |
1960734 | 1960734 | 2021-11-28 | Catahoula | Louisiana | 22025 | 1789 | 48 |
1957483 | 1957483 | 2021-11-27 | Catahoula | Louisiana | 22025 | 1789 | 48 |
1954232 | 1954232 | 2021-11-26 | Catahoula | Louisiana | 22025 | 1789 | 48 |
1950981 | 1950981 | 2021-11-25 | Catahoula | Louisiana | 22025 | 1789 | 48 |
1947730 | 1947730 | 2021-11-24 | Catahoula | Louisiana | 22025 | 1789 | 48 |
1944248 | 1944248 | 2021-11-23 | Brown | Kansas | 20013 | 1789 | 39 |
1940998 | 1940998 | 2021-11-22 | Brown | Kansas | 20013 | 1789 | 39 |
1937374 | 1937374 | 2021-11-21 | Towns | Georgia | 13281 | 1789 | 83 |
1934124 | 1934124 | 2021-11-20 | Towns | Georgia | 13281 | 1789 | 83 |
1930872 | 1930872 | 2021-11-19 | Towns | Georgia | 13281 | 1789 | 83 |
1928159 | 1928159 | 2021-11-18 | Lee | Kentucky | 21129 | 1789 | 34 |
1921436 | 1921436 | 2021-11-16 | Humboldt | Iowa | 19091 | 1789 | 29 |
1918186 | 1918186 | 2021-11-15 | Humboldt | Iowa | 19091 | 1789 | 29 |
1914936 | 1914936 | 2021-11-14 | Humboldt | Iowa | 19091 | 1789 | 29 |
1911686 | 1911686 | 2021-11-13 | Humboldt | Iowa | 19091 | 1789 | 29 |
1908437 | 1908437 | 2021-11-12 | Humboldt | Iowa | 19091 | 1789 | 29 |
1905188 | 1905188 | 2021-11-11 | Humboldt | Iowa | 19091 | 1789 | 29 |
1901938 | 1901938 | 2021-11-10 | Humboldt | Iowa | 19091 | 1789 | 29 |
1900050 | 1900050 | 2021-11-09 | Nowata | Oklahoma | 40105 | 1789 | 29 |
1896800 | 1896800 | 2021-11-08 | Nowata | Oklahoma | 40105 | 1789 | 29 |
1893550 | 1893550 | 2021-11-07 | Nowata | Oklahoma | 40105 | 1789 | 29 |
1890300 | 1890300 | 2021-11-06 | Nowata | Oklahoma | 40105 | 1789 | 29 |
1887050 | 1887050 | 2021-11-05 | Nowata | Oklahoma | 40105 | 1789 | 29 |
1883800 | 1883800 | 2021-11-04 | Nowata | Oklahoma | 40105 | 1789 | 29 |
1880551 | 1880551 | 2021-11-03 | Nowata | Oklahoma | 40105 | 1789 | 29 |
1851140 | 1851140 | 2021-10-25 | McLean | North Dakota | 38055 | 1789 | 37 |
1814829 | 1814829 | 2021-10-14 | Montgomery | Mississippi | 28097 | 1789 | 56 |
1785860 | 1785860 | 2021-10-05 | Otoe | Nebraska | 31131 | 1789 | 13 |
1778522 | 1778522 | 2021-10-03 | Allen | Kansas | 20001 | 1789 | 25 |
1775272 | 1775272 | 2021-10-02 | Allen | Kansas | 20001 | 1789 | 25 |
1777238 | 1777238 | 2021-10-02 | Ward | Texas | 48475 | 1789 | 26 |
1772022 | 1772022 | 2021-10-01 | Allen | Kansas | 20001 | 1789 | 25 |
1756348 | 1756348 | 2021-09-26 | Noxubee | Mississippi | 28103 | 1789 | 39 |
1753100 | 1753100 | 2021-09-25 | Noxubee | Mississippi | 28103 | 1789 | 39 |
1749852 | 1749852 | 2021-09-24 | Noxubee | Mississippi | 28103 | 1789 | 39 |
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);