ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
120 rows where deaths = 885 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 27
- Florida 21
- New Jersey 12
- Pennsylvania 12
- Georgia 8
- Louisiana 7
- New York 7
- Colorado 6
- Massachusetts 5
- Washington 5
- South Carolina 4
- Tennessee 4
- Arizona 3
- North Carolina 3
- Ohio 3
- Texas 3
- Wisconsin 3
- Maryland 2
- Michigan 2
- Minnesota 2
- Alabama 1
- Arkansas 1
- California 1
- Illinois 1
- Kansas 1
- Missouri 1
- New Hampshire 1
- New Mexico 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2490216 | 2490216 | 2022-05-10 | Chatham | Georgia | 13051 | 64202 | 885 |
2486959 | 2486959 | 2022-05-09 | Chatham | Georgia | 13051 | 64202 | 885 |
2483701 | 2483701 | 2022-05-08 | Chatham | Georgia | 13051 | 64202 | 885 |
2480443 | 2480443 | 2022-05-07 | Chatham | Georgia | 13051 | 64202 | 885 |
2477185 | 2477185 | 2022-05-06 | Chatham | Georgia | 13051 | 64202 | 885 |
2473927 | 2473927 | 2022-05-05 | Chatham | Georgia | 13051 | 64202 | 885 |
2470670 | 2470670 | 2022-05-04 | Chatham | Georgia | 13051 | 64202 | 885 |
2352104 | 2352104 | 2022-03-28 | Cumberland | Pennsylvania | 42041 | 50811 | 885 |
2352457 | 2352457 | 2022-03-28 | Bell | Texas | 48027 | 66776 | 885 |
2348852 | 2348852 | 2022-03-27 | Cumberland | Pennsylvania | 42041 | 50805 | 885 |
2349205 | 2349205 | 2022-03-27 | Bell | Texas | 48027 | 66773 | 885 |
2345599 | 2345599 | 2022-03-26 | Cumberland | Pennsylvania | 42041 | 50804 | 885 |
2342346 | 2342346 | 2022-03-25 | Cumberland | Pennsylvania | 42041 | 50795 | 885 |
2293053 | 2293053 | 2022-03-10 | Hillsborough | New Hampshire | 33011 | 96074 | 885 |
2265289 | 2265289 | 2022-03-02 | Madison | Alabama | 1089 | 88332 | 885 |
2261172 | 2261172 | 2022-02-28 | Charleston | South Carolina | 45019 | 110950 | 885 |
2244947 | 2244947 | 2022-02-23 | Richland | South Carolina | 45079 | 121191 | 885 |
2239659 | 2239659 | 2022-02-22 | Clayton | Georgia | 13063 | 62974 | 885 |
2241696 | 2241696 | 2022-02-22 | Richland | South Carolina | 45079 | 121134 | 885 |
2218368 | 2218368 | 2022-02-15 | Rockland | New York | 36087 | 90802 | 885 |
2215117 | 2215117 | 2022-02-14 | Rockland | New York | 36087 | 90758 | 885 |
2211866 | 2211866 | 2022-02-13 | Rockland | New York | 36087 | 90723 | 885 |
2208613 | 2208613 | 2022-02-12 | Rockland | New York | 36087 | 90674 | 885 |
2205360 | 2205360 | 2022-02-11 | Rockland | New York | 36087 | 90628 | 885 |
2192880 | 2192880 | 2022-02-07 | Anderson | South Carolina | 45007 | 56402 | 885 |
2144885 | 2144885 | 2022-01-23 | Waukesha | Wisconsin | 55133 | 104287 | 885 |
2141630 | 2141630 | 2022-01-22 | Waukesha | Wisconsin | 55133 | 104287 | 885 |
2138374 | 2138374 | 2022-01-21 | Waukesha | Wisconsin | 55133 | 104287 | 885 |
2127270 | 2127270 | 2022-01-18 | Orange | New York | 36071 | 98262 | 885 |
2128034 | 2128034 | 2022-01-18 | Brazoria | Texas | 48039 | 83069 | 885 |
2071991 | 2071991 | 2022-01-01 | Onondaga | New York | 36067 | 72173 | 885 |
1989231 | 1989231 | 2021-12-07 | Seminole | Florida | 12117 | 63412 | 885 |
1985981 | 1985981 | 2021-12-06 | Seminole | Florida | 12117 | 63412 | 885 |
1982731 | 1982731 | 2021-12-05 | Seminole | Florida | 12117 | 63412 | 885 |
1979481 | 1979481 | 2021-12-04 | Seminole | Florida | 12117 | 63412 | 885 |
1976231 | 1976231 | 2021-12-03 | Seminole | Florida | 12117 | 63412 | 885 |
1972982 | 1972982 | 2021-12-02 | Seminole | Florida | 12117 | 63170 | 885 |
1969732 | 1969732 | 2021-12-01 | Seminole | Florida | 12117 | 63170 | 885 |
1966482 | 1966482 | 2021-11-30 | Seminole | Florida | 12117 | 63170 | 885 |
1963230 | 1963230 | 2021-11-29 | Seminole | Florida | 12117 | 62922 | 885 |
1959979 | 1959979 | 2021-11-28 | Seminole | Florida | 12117 | 62922 | 885 |
1956728 | 1956728 | 2021-11-27 | Seminole | Florida | 12117 | 62922 | 885 |
1953477 | 1953477 | 2021-11-26 | Seminole | Florida | 12117 | 62922 | 885 |
1950226 | 1950226 | 2021-11-25 | Seminole | Florida | 12117 | 62922 | 885 |
1946975 | 1946975 | 2021-11-24 | Seminole | Florida | 12117 | 62922 | 885 |
1943724 | 1943724 | 2021-11-23 | Seminole | Florida | 12117 | 62922 | 885 |
1940474 | 1940474 | 2021-11-22 | Seminole | Florida | 12117 | 62922 | 885 |
1941904 | 1941904 | 2021-11-22 | Somerset | New Jersey | 34035 | 35867 | 885 |
1937224 | 1937224 | 2021-11-21 | Seminole | Florida | 12117 | 62922 | 885 |
1938654 | 1938654 | 2021-11-21 | Somerset | New Jersey | 34035 | 35836 | 885 |
1933974 | 1933974 | 2021-11-20 | Seminole | Florida | 12117 | 62922 | 885 |
1935404 | 1935404 | 2021-11-20 | Somerset | New Jersey | 34035 | 35801 | 885 |
1932154 | 1932154 | 2021-11-19 | Somerset | New Jersey | 34035 | 35738 | 885 |
1883876 | 1883876 | 2021-11-04 | Chester | Pennsylvania | 42029 | 51421 | 885 |
1877045 | 1877045 | 2021-11-02 | Guilford | North Carolina | 37081 | 68236 | 885 |
1825687 | 1825687 | 2021-10-17 | Knox | Tennessee | 47093 | 77415 | 885 |
1822438 | 1822438 | 2021-10-16 | Knox | Tennessee | 47093 | 77415 | 885 |
1819189 | 1819189 | 2021-10-15 | Knox | Tennessee | 47093 | 77415 | 885 |
1815940 | 1815940 | 2021-10-14 | Knox | Tennessee | 47093 | 77226 | 885 |
1805922 | 1805922 | 2021-10-11 | Luzerne | Pennsylvania | 42079 | 38805 | 885 |
1802672 | 1802672 | 2021-10-10 | Luzerne | Pennsylvania | 42079 | 38739 | 885 |
1799423 | 1799423 | 2021-10-09 | Luzerne | Pennsylvania | 42079 | 38610 | 885 |
1796174 | 1796174 | 2021-10-08 | Luzerne | Pennsylvania | 42079 | 38441 | 885 |
1784294 | 1784294 | 2021-10-05 | Pulaski | Arkansas | 5119 | 57657 | 885 |
1764874 | 1764874 | 2021-09-29 | Arapahoe | Colorado | 8005 | 75093 | 885 |
1761625 | 1761625 | 2021-09-28 | Arapahoe | Colorado | 8005 | 75093 | 885 |
1758377 | 1758377 | 2021-09-27 | Arapahoe | Colorado | 8005 | 74787 | 885 |
1755129 | 1755129 | 2021-09-26 | Arapahoe | Colorado | 8005 | 74661 | 885 |
1738747 | 1738747 | 2021-09-21 | Yuma | Arizona | 4027 | 40347 | 885 |
1740968 | 1740968 | 2021-09-21 | York | Pennsylvania | 42133 | 54292 | 885 |
1725742 | 1725742 | 2021-09-17 | Mohave | Arizona | 4015 | 30101 | 885 |
1720270 | 1720270 | 2021-09-15 | Caddo | Louisiana | 22017 | 37203 | 885 |
1700300 | 1700300 | 2021-09-09 | Kane | Illinois | 17089 | 64470 | 885 |
1701957 | 1701957 | 2021-09-09 | Lehigh | Pennsylvania | 42077 | 43673 | 885 |
1555268 | 1555268 | 2021-07-26 | Burlington | New Jersey | 34005 | 44920 | 885 |
1552021 | 1552021 | 2021-07-25 | Burlington | New Jersey | 34005 | 44894 | 885 |
1548774 | 1548774 | 2021-07-24 | Burlington | New Jersey | 34005 | 44860 | 885 |
1545527 | 1545527 | 2021-07-23 | Burlington | New Jersey | 34005 | 44813 | 885 |
1542279 | 1542279 | 2021-07-22 | Burlington | New Jersey | 34005 | 44777 | 885 |
1539032 | 1539032 | 2021-07-21 | Burlington | New Jersey | 34005 | 44741 | 885 |
1535785 | 1535785 | 2021-07-20 | Burlington | New Jersey | 34005 | 44704 | 885 |
1508279 | 1508279 | 2021-07-12 | El Paso | Colorado | 8041 | 74223 | 885 |
1505033 | 1505033 | 2021-07-11 | El Paso | Colorado | 8041 | 74171 | 885 |
1340615 | 1340615 | 2021-05-21 | Ramsey | Minnesota | 27123 | 51842 | 885 |
1336087 | 1336087 | 2021-05-20 | Pinal | Arizona | 4021 | 52423 | 885 |
1291795 | 1291795 | 2021-05-06 | Genesee | Michigan | 26049 | 40376 | 885 |
1236478 | 1236478 | 2021-04-19 | Jefferson | Louisiana | 22051 | 45549 | 885 |
1233231 | 1233231 | 2021-04-18 | Jefferson | Louisiana | 22051 | 45493 | 885 |
1229983 | 1229983 | 2021-04-17 | Jefferson | Louisiana | 22051 | 45493 | 885 |
1226735 | 1226735 | 2021-04-16 | Jefferson | Louisiana | 22051 | 45493 | 885 |
1223488 | 1223488 | 2021-04-15 | Jefferson | Louisiana | 22051 | 45454 | 885 |
1220240 | 1220240 | 2021-04-14 | Jefferson | Louisiana | 22051 | 45410 | 885 |
1179006 | 1179006 | 2021-04-01 | Stark | Ohio | 39151 | 30691 | 885 |
1175759 | 1175759 | 2021-03-31 | Stark | Ohio | 39151 | 30637 | 885 |
1172512 | 1172512 | 2021-03-30 | Stark | Ohio | 39151 | 30592 | 885 |
1116989 | 1116989 | 2021-03-13 | Bernalillo | New Mexico | 35001 | 53555 | 885 |
1094415 | 1094415 | 2021-03-06 | Mecklenburg | North Carolina | 37119 | 97954 | 885 |
1091007 | 1091007 | 2021-03-05 | Mercer | New Jersey | 34021 | 28246 | 885 |
1091169 | 1091169 | 2021-03-05 | Mecklenburg | North Carolina | 37119 | 97767 | 885 |
1070938 | 1070938 | 2021-02-27 | Baltimore city | Maryland | 24510 | 40324 | 885 |
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);