ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
297 rows where cases = 1748 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 29
- Illinois 22
- Iowa 18
- Michigan 16
- Kentucky 13
- Virginia 13
- Oklahoma 12
- Georgia 11
- Puerto Rico 11
- Missouri 9
- Nebraska 9
- Arkansas 8
- Minnesota 8
- Mississippi 8
- Tennessee 8
- West Virginia 8
- Colorado 7
- Indiana 7
- New Mexico 7
- Louisiana 6
- Pennsylvania 6
- Alabama 5
- Florida 5
- North Carolina 5
- North Dakota 5
- South Carolina 5
- Vermont 5
- California 4
- Ohio 4
- Kansas 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2493684 | 2493684 | 2022-05-11 | Edwards | Illinois | 17047 | 1748 | 29 |
2445574 | 2445574 | 2022-04-26 | Lac qui Parle | Minnesota | 27073 | 1748 | 29 |
2356946 | 2356946 | 2022-03-30 | Edwards | Illinois | 17047 | 1748 | 29 |
2353693 | 2353693 | 2022-03-29 | Edwards | Illinois | 17047 | 1748 | 29 |
2353923 | 2353923 | 2022-03-29 | Lucas | Iowa | 19117 | 1748 | 32 |
2354386 | 2354386 | 2022-03-29 | Schoolcraft | Michigan | 26153 | 1748 | 17 |
2350441 | 2350441 | 2022-03-28 | Edwards | Illinois | 17047 | 1748 | 29 |
2350671 | 2350671 | 2022-03-28 | Lucas | Iowa | 19117 | 1748 | 32 |
2351134 | 2351134 | 2022-03-28 | Schoolcraft | Michigan | 26153 | 1748 | 17 |
2352874 | 2352874 | 2022-03-28 | Williamsburg city | Virginia | 51830 | 1748 | 22 |
2347418 | 2347418 | 2022-03-27 | Lucas | Iowa | 19117 | 1748 | 32 |
2347881 | 2347881 | 2022-03-27 | Schoolcraft | Michigan | 26153 | 1748 | 17 |
2344165 | 2344165 | 2022-03-26 | Lucas | Iowa | 19117 | 1748 | 32 |
2344628 | 2344628 | 2022-03-26 | Schoolcraft | Michigan | 26153 | 1748 | 17 |
2340912 | 2340912 | 2022-03-25 | Lucas | Iowa | 19117 | 1748 | 32 |
2341375 | 2341375 | 2022-03-25 | Schoolcraft | Michigan | 26153 | 1748 | 17 |
2337659 | 2337659 | 2022-03-24 | Lucas | Iowa | 19117 | 1748 | 32 |
2334405 | 2334405 | 2022-03-23 | Lucas | Iowa | 19117 | 1748 | 32 |
2325161 | 2325161 | 2022-03-20 | Mahnomen | Minnesota | 27087 | 1748 | 17 |
2321907 | 2321907 | 2022-03-19 | Mahnomen | Minnesota | 27087 | 1748 | 17 |
2318653 | 2318653 | 2022-03-18 | Mahnomen | Minnesota | 27087 | 1748 | 17 |
2315348 | 2315348 | 2022-03-17 | Schoolcraft | Michigan | 26153 | 1748 | 16 |
2315400 | 2315400 | 2022-03-17 | Mahnomen | Minnesota | 27087 | 1748 | 17 |
2312095 | 2312095 | 2022-03-16 | Schoolcraft | Michigan | 26153 | 1748 | 16 |
2302339 | 2302339 | 2022-03-13 | Schoolcraft | Michigan | 26153 | 1748 | 16 |
2299087 | 2299087 | 2022-03-12 | Schoolcraft | Michigan | 26153 | 1748 | 16 |
2295835 | 2295835 | 2022-03-11 | Schoolcraft | Michigan | 26153 | 1748 | 16 |
2288638 | 2288638 | 2022-03-09 | Edwards | Illinois | 17047 | 1748 | 28 |
2285387 | 2285387 | 2022-03-08 | Edwards | Illinois | 17047 | 1748 | 28 |
2285657 | 2285657 | 2022-03-08 | Worth | Iowa | 19195 | 1748 | 14 |
2282135 | 2282135 | 2022-03-07 | Edwards | Illinois | 17047 | 1748 | 28 |
2282405 | 2282405 | 2022-03-07 | Worth | Iowa | 19195 | 1748 | 14 |
2279152 | 2279152 | 2022-03-06 | Worth | Iowa | 19195 | 1748 | 14 |
2275899 | 2275899 | 2022-03-05 | Worth | Iowa | 19195 | 1748 | 14 |
2272646 | 2272646 | 2022-03-04 | Worth | Iowa | 19195 | 1748 | 14 |
2269394 | 2269394 | 2022-03-03 | Worth | Iowa | 19195 | 1748 | 14 |
2270256 | 2270256 | 2022-03-03 | Thurston | Nebraska | 31173 | 1748 | 20 |
2266141 | 2266141 | 2022-03-02 | Worth | Iowa | 19195 | 1748 | 14 |
2267003 | 2267003 | 2022-03-02 | Thurston | Nebraska | 31173 | 1748 | 20 |
2263752 | 2263752 | 2022-03-01 | Thurston | Nebraska | 31173 | 1748 | 20 |
2264816 | 2264816 | 2022-03-01 | Refugio | Texas | 48391 | 1748 | 31 |
2261566 | 2261566 | 2022-02-28 | Refugio | Texas | 48391 | 1748 | 31 |
2261684 | 2261684 | 2022-02-28 | Bland | Virginia | 51021 | 1748 | 20 |
2257183 | 2257183 | 2022-02-27 | Cuming | Nebraska | 31039 | 1748 | 15 |
2258315 | 2258315 | 2022-02-27 | Refugio | Texas | 48391 | 1748 | 31 |
2253932 | 2253932 | 2022-02-26 | Cuming | Nebraska | 31039 | 1748 | 15 |
2255064 | 2255064 | 2022-02-26 | Refugio | Texas | 48391 | 1748 | 31 |
2250681 | 2250681 | 2022-02-25 | Cuming | Nebraska | 31039 | 1748 | 15 |
2235843 | 2235843 | 2022-02-20 | Calhoun | West Virginia | 54013 | 1748 | 11 |
2232592 | 2232592 | 2022-02-19 | Calhoun | West Virginia | 54013 | 1748 | 11 |
2229341 | 2229341 | 2022-02-18 | Calhoun | West Virginia | 54013 | 1748 | 11 |
2218171 | 2218171 | 2022-02-15 | Cuming | Nebraska | 31039 | 1748 | 15 |
2188698 | 2188698 | 2022-02-06 | Wilkinson | Mississippi | 28157 | 1748 | 42 |
2185445 | 2185445 | 2022-02-05 | Wilkinson | Mississippi | 28157 | 1748 | 42 |
2186792 | 2186792 | 2022-02-05 | Stephens | Texas | 48429 | 1748 | 39 |
2182193 | 2182193 | 2022-02-04 | Wilkinson | Mississippi | 28157 | 1748 | 42 |
2177012 | 2177012 | 2022-02-02 | Rains | Texas | 48379 | 1748 | 53 |
2154211 | 2154211 | 2022-01-26 | Mitchell | Texas | 48335 | 1748 | 45 |
2133337 | 2133337 | 2022-01-20 | Humphreys | Mississippi | 28053 | 1748 | 39 |
2128405 | 2128405 | 2022-01-18 | Northampton | Virginia | 51131 | 1748 | 51 |
2080310 | 2080310 | 2022-01-04 | Evans | Georgia | 13109 | 1748 | 56 |
2080434 | 2080434 | 2022-01-04 | Boundary | Idaho | 16021 | 1748 | 51 |
2082916 | 2082916 | 2022-01-04 | Sussex | Virginia | 51183 | 1748 | 31 |
2074395 | 2074395 | 2022-01-02 | Edmonson | Kentucky | 21061 | 1748 | 34 |
2075362 | 2075362 | 2022-01-02 | Washington | North Carolina | 37187 | 1748 | 39 |
2071144 | 2071144 | 2022-01-01 | Edmonson | Kentucky | 21061 | 1748 | 34 |
2072111 | 2072111 | 2022-01-01 | Washington | North Carolina | 37187 | 1748 | 39 |
2067893 | 2067893 | 2021-12-31 | Edmonson | Kentucky | 21061 | 1748 | 34 |
2068860 | 2068860 | 2021-12-31 | Washington | North Carolina | 37187 | 1748 | 39 |
2064642 | 2064642 | 2021-12-30 | Edmonson | Kentucky | 21061 | 1748 | 34 |
2061392 | 2061392 | 2021-12-29 | Edmonson | Kentucky | 21061 | 1748 | 34 |
2058193 | 2058193 | 2021-12-28 | McLean | Kentucky | 21149 | 1748 | 41 |
1992635 | 1992635 | 2021-12-08 | Turner | Georgia | 13287 | 1748 | 49 |
1962510 | 1962510 | 2021-11-28 | Addison | Vermont | 50001 | 1748 | 9 |
1959259 | 1959259 | 2021-11-27 | Addison | Vermont | 50001 | 1748 | 9 |
1956008 | 1956008 | 2021-11-26 | Addison | Vermont | 50001 | 1748 | 9 |
1952757 | 1952757 | 2021-11-25 | Addison | Vermont | 50001 | 1748 | 9 |
1946761 | 1946761 | 2021-11-24 | Pike | Arkansas | 5109 | 1748 | 37 |
1949506 | 1949506 | 2021-11-24 | Addison | Vermont | 50001 | 1748 | 9 |
1943510 | 1943510 | 2021-11-23 | Pike | Arkansas | 5109 | 1748 | 37 |
1933768 | 1933768 | 2021-11-20 | Scott | Arkansas | 5127 | 1748 | 30 |
1930516 | 1930516 | 2021-11-19 | Scott | Arkansas | 5127 | 1748 | 30 |
1912989 | 1912989 | 2021-11-13 | Vinton | Ohio | 39163 | 1748 | 33 |
1889651 | 1889651 | 2021-11-06 | Lewis | Missouri | 29111 | 1748 | 22 |
1856086 | 1856086 | 2021-10-27 | Long | Georgia | 13183 | 1748 | 25 |
1852837 | 1852837 | 2021-10-26 | Long | Georgia | 13183 | 1748 | 25 |
1834892 | 1834892 | 2021-10-20 | McLean | North Dakota | 38055 | 1748 | 34 |
1809071 | 1809071 | 2021-10-12 | Nowata | Oklahoma | 40105 | 1748 | 24 |
1805821 | 1805821 | 2021-10-11 | Nowata | Oklahoma | 40105 | 1748 | 24 |
1802571 | 1802571 | 2021-10-10 | Nowata | Oklahoma | 40105 | 1748 | 24 |
1799322 | 1799322 | 2021-10-09 | Nowata | Oklahoma | 40105 | 1748 | 24 |
1796073 | 1796073 | 2021-10-08 | Nowata | Oklahoma | 40105 | 1748 | 24 |
1792824 | 1792824 | 2021-10-07 | Nowata | Oklahoma | 40105 | 1748 | 24 |
1787902 | 1787902 | 2021-10-06 | Towns | Georgia | 13281 | 1748 | 77 |
1789575 | 1789575 | 2021-10-06 | Nowata | Oklahoma | 40105 | 1748 | 24 |
1782235 | 1782235 | 2021-10-04 | Kanabec | Minnesota | 27065 | 1748 | 29 |
1773471 | 1773471 | 2021-10-01 | Camuy | Puerto Rico | 72027 | 1748 | |
1765705 | 1765705 | 2021-09-29 | Martin | Kentucky | 21159 | 1748 | 30 |
1767854 | 1767854 | 2021-09-29 | Big Horn | Wyoming | 56003 | 1748 | 39 |
1759264 | 1759264 | 2021-09-27 | Catahoula | Louisiana | 22025 | 1748 | 46 |
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);