ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
169 rows where deaths = 591 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Illinois 18
- Indiana 12
- Ohio 12
- Pennsylvania 12
- California 11
- South Carolina 9
- Florida 8
- Georgia 8
- Missouri 8
- Texas 7
- Alabama 6
- Arkansas 6
- Louisiana 6
- Michigan 6
- New Jersey 5
- Washington 5
- Minnesota 3
- Virginia 3
- Connecticut 2
- District of Columbia 2
- New Mexico 2
- New York 2
- Tennessee 2
- Utah 2
- West Virginia 2
- Wisconsin 2
- Arizona 1
- Colorado 1
- Delaware 1
- Maryland 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2472524 | 2472524 | 2022-05-04 | Washington | Oregon | 41067 | 88785 | 591 |
2401248 | 2401248 | 2022-04-12 | Unknown | Tennessee | 19409 | 591 | |
2345110 | 2345110 | 2022-03-26 | Cumberland | New Jersey | 34011 | 39342 | 591 |
2341857 | 2341857 | 2022-03-25 | Cumberland | New Jersey | 34011 | 39341 | 591 |
2338604 | 2338604 | 2022-03-24 | Cumberland | New Jersey | 34011 | 39335 | 591 |
2331470 | 2331470 | 2022-03-22 | Tangipahoa | Louisiana | 22105 | 34614 | 591 |
2284979 | 2284979 | 2022-03-08 | Placer | California | 6061 | 69493 | 591 |
2281693 | 2281693 | 2022-03-07 | Washington | Arkansas | 5143 | 67569 | 591 |
2281727 | 2281727 | 2022-03-07 | Placer | California | 6061 | 69463 | 591 |
2281928 | 2281928 | 2022-03-07 | Cherokee | Georgia | 13057 | 63002 | 591 |
2278440 | 2278440 | 2022-03-06 | Washington | Arkansas | 5143 | 67561 | 591 |
2278474 | 2278474 | 2022-03-06 | Placer | California | 6061 | 69395 | 591 |
2275187 | 2275187 | 2022-03-05 | Washington | Arkansas | 5143 | 67542 | 591 |
2275221 | 2275221 | 2022-03-05 | Placer | California | 6061 | 69395 | 591 |
2271934 | 2271934 | 2022-03-04 | Washington | Arkansas | 5143 | 67515 | 591 |
2271968 | 2271968 | 2022-03-04 | Placer | California | 6061 | 69395 | 591 |
2268682 | 2268682 | 2022-03-03 | Washington | Arkansas | 5143 | 67485 | 591 |
2261201 | 2261201 | 2022-02-28 | Pickens | South Carolina | 45077 | 45603 | 591 |
2241511 | 2241511 | 2022-02-22 | Blair | Pennsylvania | 42013 | 29234 | 591 |
2238260 | 2238260 | 2022-02-21 | Blair | Pennsylvania | 42013 | 29188 | 591 |
2235009 | 2235009 | 2022-02-20 | Blair | Pennsylvania | 42013 | 29188 | 591 |
2220518 | 2220518 | 2022-02-16 | Vanderburgh | Indiana | 18163 | 56533 | 591 |
2183028 | 2183028 | 2022-02-04 | Washington | Pennsylvania | 42125 | 48954 | 591 |
2179739 | 2179739 | 2022-02-03 | Fayette | Pennsylvania | 42051 | 29144 | 591 |
2174509 | 2174509 | 2022-02-02 | New London | Connecticut | 9011 | 51447 | 591 |
2171256 | 2171256 | 2022-02-01 | New London | Connecticut | 9011 | 51271 | 591 |
2165186 | 2165186 | 2022-01-30 | Madison | Indiana | 18095 | 31136 | 591 |
2161931 | 2161931 | 2022-01-29 | Madison | Indiana | 18095 | 31136 | 591 |
2158676 | 2158676 | 2022-01-28 | Madison | Indiana | 18095 | 31136 | 591 |
2155403 | 2155403 | 2022-01-27 | Hamilton | Indiana | 18057 | 76853 | 591 |
2154626 | 2154626 | 2022-01-26 | Racine | Wisconsin | 55101 | 53640 | 591 |
2148393 | 2148393 | 2022-01-25 | Santa Barbara | California | 6083 | 77033 | 591 |
2151286 | 2151286 | 2022-01-25 | Kanawha | West Virginia | 54039 | 39735 | 591 |
2148034 | 2148034 | 2022-01-24 | Kanawha | West Virginia | 54039 | 39489 | 591 |
2127708 | 2127708 | 2022-01-18 | Schuylkill | Pennsylvania | 42107 | 30432 | 591 |
2124456 | 2124456 | 2022-01-17 | Schuylkill | Pennsylvania | 42107 | 30301 | 591 |
2121204 | 2121204 | 2022-01-16 | Schuylkill | Pennsylvania | 42107 | 30185 | 591 |
2117952 | 2117952 | 2022-01-15 | Schuylkill | Pennsylvania | 42107 | 29761 | 591 |
2092338 | 2092338 | 2022-01-07 | Gregg | Texas | 48183 | 20532 | 591 |
2089086 | 2089086 | 2022-01-06 | Gregg | Texas | 48183 | 20410 | 591 |
2085835 | 2085835 | 2022-01-05 | Gregg | Texas | 48183 | 20263 | 591 |
2082583 | 2082583 | 2022-01-04 | Gregg | Texas | 48183 | 20150 | 591 |
2079331 | 2079331 | 2022-01-03 | Gregg | Texas | 48183 | 20052 | 591 |
2056912 | 2056912 | 2021-12-27 | Virginia Beach city | Virginia | 51810 | 55828 | 591 |
2033388 | 2033388 | 2021-12-20 | Butler | Pennsylvania | 42019 | 31299 | 591 |
2034141 | 2034141 | 2021-12-20 | Prince William | Virginia | 51153 | 59986 | 591 |
2028586 | 2028586 | 2021-12-19 | Elkhart | Indiana | 18039 | 42237 | 591 |
2025335 | 2025335 | 2021-12-18 | Elkhart | Indiana | 18039 | 42237 | 591 |
2022084 | 2022084 | 2021-12-17 | Elkhart | Indiana | 18039 | 42237 | 591 |
2018833 | 2018833 | 2021-12-16 | Elkhart | Indiana | 18039 | 42096 | 591 |
2014860 | 2014860 | 2021-12-15 | Baldwin | Alabama | 1003 | 38413 | 591 |
2011609 | 2011609 | 2021-12-14 | Baldwin | Alabama | 1003 | 38398 | 591 |
2012928 | 2012928 | 2021-12-14 | St. Clair | Michigan | 26147 | 28745 | 591 |
2008358 | 2008358 | 2021-12-13 | Baldwin | Alabama | 1003 | 38321 | 591 |
2009677 | 2009677 | 2021-12-13 | St. Clair | Michigan | 26147 | 28629 | 591 |
2005107 | 2005107 | 2021-12-12 | Baldwin | Alabama | 1003 | 38314 | 591 |
2001856 | 2001856 | 2021-12-11 | Baldwin | Alabama | 1003 | 38307 | 591 |
1998383 | 1998383 | 2021-12-09 | Prince William | Virginia | 51153 | 58221 | 591 |
1994043 | 1994043 | 2021-12-08 | Forsyth | North Carolina | 37067 | 55089 | 591 |
1991699 | 1991699 | 2021-12-07 | Taylor | Texas | 48441 | 23892 | 591 |
1983698 | 1983698 | 2021-12-05 | Dakota | Minnesota | 27037 | 68505 | 591 |
1980448 | 1980448 | 2021-12-04 | Dakota | Minnesota | 27037 | 68505 | 591 |
1977198 | 1977198 | 2021-12-03 | Dakota | Minnesota | 27037 | 68505 | 591 |
1952752 | 1952752 | 2021-11-25 | Utah | Utah | 49049 | 134431 | 591 |
1949501 | 1949501 | 2021-11-24 | Utah | Utah | 49049 | 134431 | 591 |
1945183 | 1945183 | 2021-11-23 | San Juan | New Mexico | 35045 | 26031 | 591 |
1941932 | 1941932 | 2021-11-22 | San Juan | New Mexico | 35045 | 25954 | 591 |
1915252 | 1915252 | 2021-11-14 | Ouachita | Louisiana | 22073 | 31765 | 591 |
1912002 | 1912002 | 2021-11-13 | Ouachita | Louisiana | 22073 | 31765 | 591 |
1908753 | 1908753 | 2021-11-12 | Ouachita | Louisiana | 22073 | 31765 | 591 |
1859064 | 1859064 | 2021-10-28 | Merced | California | 6047 | 43377 | 591 |
1860962 | 1860962 | 2021-10-28 | Lorain | Ohio | 39093 | 36118 | 591 |
1861952 | 1861952 | 2021-10-28 | Yakima | Washington | 53077 | 45014 | 591 |
1856308 | 1856308 | 2021-10-27 | Winnebago | Illinois | 17201 | 41587 | 591 |
1857713 | 1857713 | 2021-10-27 | Lorain | Ohio | 39093 | 36003 | 591 |
1858703 | 1858703 | 2021-10-27 | Yakima | Washington | 53077 | 44847 | 591 |
1853059 | 1853059 | 2021-10-26 | Winnebago | Illinois | 17201 | 41507 | 591 |
1854464 | 1854464 | 2021-10-26 | Lorain | Ohio | 39093 | 35859 | 591 |
1849320 | 1849320 | 2021-10-25 | Monterey | California | 6053 | 50911 | 591 |
1849810 | 1849810 | 2021-10-25 | Winnebago | Illinois | 17201 | 41428 | 591 |
1846560 | 1846560 | 2021-10-24 | Winnebago | Illinois | 17201 | 41222 | 591 |
1843310 | 1843310 | 2021-10-23 | Winnebago | Illinois | 17201 | 41222 | 591 |
1840060 | 1840060 | 2021-10-22 | Winnebago | Illinois | 17201 | 41222 | 591 |
1836811 | 1836811 | 2021-10-21 | Winnebago | Illinois | 17201 | 41117 | 591 |
1816728 | 1816728 | 2021-10-15 | Benton | Arkansas | 5007 | 41546 | 591 |
1812402 | 1812402 | 2021-10-13 | Cumberland | Pennsylvania | 42041 | 26792 | 591 |
1784583 | 1784583 | 2021-10-05 | Hall | Georgia | 13139 | 37075 | 591 |
1744633 | 1744633 | 2021-09-22 | Jefferson | Texas | 48245 | 30041 | 591 |
1721701 | 1721701 | 2021-09-15 | Hamilton | Tennessee | 47065 | 59310 | 591 |
1713067 | 1713067 | 2021-09-13 | Clayton | Georgia | 13063 | 35481 | 591 |
1711846 | 1711846 | 2021-09-12 | Lexington | South Carolina | 45063 | 47913 | 591 |
1708599 | 1708599 | 2021-09-11 | Lexington | South Carolina | 45063 | 47913 | 591 |
1705352 | 1705352 | 2021-09-10 | Lexington | South Carolina | 45063 | 47913 | 591 |
1702080 | 1702080 | 2021-09-09 | Charleston | South Carolina | 45019 | 58552 | 591 |
1671101 | 1671101 | 2021-08-31 | St. Clair | Illinois | 17163 | 36980 | 591 |
1664697 | 1664697 | 2021-08-29 | St. Joseph | Indiana | 18141 | 39054 | 591 |
1661449 | 1661449 | 2021-08-28 | St. Joseph | Indiana | 18141 | 39054 | 591 |
1658201 | 1658201 | 2021-08-27 | St. Joseph | Indiana | 18141 | 39054 | 591 |
1626473 | 1626473 | 2021-08-17 | Greene | Missouri | 29077 | 40494 | 591 |
1552669 | 1552669 | 2021-07-25 | Horry | South Carolina | 45051 | 40858 | 591 |
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);