ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
81 rows where deaths = 959 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 22
- Texas 11
- New Jersey 8
- Florida 7
- Louisiana 6
- Tennessee 6
- Delaware 5
- Pennsylvania 5
- Massachusetts 4
- Alabama 3
- California 3
- Kansas 3
- Michigan 3
- Colorado 2
- Georgia 2
- Illinois 2
- Indiana 2
- Minnesota 2
- North Carolina 2
- South Carolina 2
- Arizona 1
- New Mexico 1
- New York 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2427972 | 2427972 | 2022-04-21 | Madison | Alabama | 1089 | 89517 | 959 |
2424716 | 2424716 | 2022-04-20 | Madison | Alabama | 1089 | 89474 | 959 |
2421460 | 2421460 | 2022-04-19 | Madison | Alabama | 1089 | 89441 | 959 |
2387896 | 2387896 | 2022-04-08 | Dauphin | Pennsylvania | 42043 | 59051 | 959 |
2384641 | 2384641 | 2022-04-07 | Dauphin | Pennsylvania | 42043 | 59048 | 959 |
2342897 | 2342897 | 2022-03-25 | Smith | Texas | 48423 | 45330 | 959 |
2290436 | 2290436 | 2022-03-09 | Anderson | South Carolina | 45007 | 57592 | 959 |
2287184 | 2287184 | 2022-03-08 | Anderson | South Carolina | 45007 | 57589 | 959 |
2245135 | 2245135 | 2022-02-23 | Brazoria | Texas | 48039 | 92456 | 959 |
2241048 | 2241048 | 2022-02-22 | Somerset | New Jersey | 34035 | 66119 | 959 |
2237797 | 2237797 | 2022-02-21 | Somerset | New Jersey | 34035 | 66089 | 959 |
2234546 | 2234546 | 2022-02-20 | Somerset | New Jersey | 34035 | 66060 | 959 |
2231295 | 2231295 | 2022-02-19 | Somerset | New Jersey | 34035 | 65976 | 959 |
2031819 | 2031819 | 2021-12-20 | Allen | Indiana | 18003 | 72068 | 959 |
1943590 | 1943590 | 2021-11-23 | Adams | Colorado | 8001 | 84507 | 959 |
1940340 | 1940340 | 2021-11-22 | Adams | Colorado | 8001 | 84508 | 959 |
1942424 | 1942424 | 2021-11-22 | Westmoreland | Pennsylvania | 42129 | 50074 | 959 |
1909899 | 1909899 | 2021-11-12 | Luzerne | Pennsylvania | 42079 | 42603 | 959 |
1846840 | 1846840 | 2021-10-24 | Sedgwick | Kansas | 20173 | 80543 | 959 |
1843590 | 1843590 | 2021-10-23 | Sedgwick | Kansas | 20173 | 80543 | 959 |
1840340 | 1840340 | 2021-10-22 | Sedgwick | Kansas | 20173 | 80543 | 959 |
1814649 | 1814649 | 2021-10-14 | Kent | Michigan | 26081 | 89258 | 959 |
1811401 | 1811401 | 2021-10-13 | Kent | Michigan | 26081 | 89258 | 959 |
1806482 | 1806482 | 2021-10-11 | Webb | Texas | 48479 | 56295 | 959 |
1803232 | 1803232 | 2021-10-10 | Webb | Texas | 48479 | 56295 | 959 |
1799983 | 1799983 | 2021-10-09 | Webb | Texas | 48479 | 56295 | 959 |
1796734 | 1796734 | 2021-10-08 | Webb | Texas | 48479 | 56249 | 959 |
1793485 | 1793485 | 2021-10-07 | Webb | Texas | 48479 | 56224 | 959 |
1790236 | 1790236 | 2021-10-06 | Webb | Texas | 48479 | 56157 | 959 |
1785513 | 1785513 | 2021-10-05 | Ramsey | Minnesota | 27123 | 60958 | 959 |
1758449 | 1758449 | 2021-09-27 | New Castle | Delaware | 10003 | 75822 | 959 |
1755201 | 1755201 | 2021-09-26 | New Castle | Delaware | 10003 | 75622 | 959 |
1756039 | 1756039 | 2021-09-26 | Orleans | Louisiana | 22071 | 45585 | 959 |
1751953 | 1751953 | 2021-09-25 | New Castle | Delaware | 10003 | 75442 | 959 |
1752791 | 1752791 | 2021-09-25 | Orleans | Louisiana | 22071 | 45585 | 959 |
1748704 | 1748704 | 2021-09-24 | New Castle | Delaware | 10003 | 75137 | 959 |
1749542 | 1749542 | 2021-09-24 | Orleans | Louisiana | 22071 | 45585 | 959 |
1745454 | 1745454 | 2021-09-23 | New Castle | Delaware | 10003 | 74873 | 959 |
1746292 | 1746292 | 2021-09-23 | Orleans | Louisiana | 22071 | 45530 | 959 |
1743043 | 1743043 | 2021-09-22 | Orleans | Louisiana | 22071 | 45456 | 959 |
1725056 | 1725056 | 2021-09-16 | Collin | Texas | 48085 | 119342 | 959 |
1609846 | 1609846 | 2021-08-12 | Jefferson | Louisiana | 22051 | 59130 | 959 |
1559268 | 1559268 | 2021-07-27 | Davidson | Tennessee | 47037 | 101057 | 959 |
1556021 | 1556021 | 2021-07-26 | Davidson | Tennessee | 47037 | 101057 | 959 |
1552774 | 1552774 | 2021-07-25 | Davidson | Tennessee | 47037 | 100523 | 959 |
1549527 | 1549527 | 2021-07-24 | Davidson | Tennessee | 47037 | 100523 | 959 |
1546280 | 1546280 | 2021-07-23 | Davidson | Tennessee | 47037 | 100523 | 959 |
1543033 | 1543033 | 2021-07-22 | Davidson | Tennessee | 47037 | 100360 | 959 |
1470858 | 1470858 | 2021-06-30 | Mercer | New Jersey | 34021 | 34203 | 959 |
1428679 | 1428679 | 2021-06-17 | Bernalillo | New Mexico | 35001 | 58858 | 959 |
1408659 | 1408659 | 2021-06-11 | Genesee | Michigan | 26049 | 41678 | 959 |
1334697 | 1334697 | 2021-05-19 | Mecklenburg | North Carolina | 37119 | 112524 | 959 |
1331450 | 1331450 | 2021-05-18 | Mecklenburg | North Carolina | 37119 | 112429 | 959 |
1284394 | 1284394 | 2021-05-04 | Lee | Florida | 12071 | 70144 | 959 |
1281147 | 1281147 | 2021-05-03 | Lee | Florida | 12071 | 69973 | 959 |
1277900 | 1277900 | 2021-05-02 | Lee | Florida | 12071 | 69836 | 959 |
1274653 | 1274653 | 2021-05-01 | Lee | Florida | 12071 | 69650 | 959 |
1271406 | 1271406 | 2021-04-30 | Lee | Florida | 12071 | 69445 | 959 |
1268159 | 1268159 | 2021-04-29 | Lee | Florida | 12071 | 69160 | 959 |
1227858 | 1227858 | 2021-04-16 | Berks | Pennsylvania | 42011 | 43132 | 959 |
1209783 | 1209783 | 2021-04-11 | DeKalb | Georgia | 13089 | 63097 | 959 |
1206534 | 1206534 | 2021-04-10 | DeKalb | Georgia | 13089 | 62895 | 959 |
1199207 | 1199207 | 2021-04-07 | Travis | Texas | 48453 | 79922 | 959 |
1102428 | 1102428 | 2021-03-09 | Stanislaus | California | 6099 | 56985 | 959 |
1099182 | 1099182 | 2021-03-08 | Stanislaus | California | 6099 | 56885 | 959 |
998979 | 998979 | 2021-02-05 | Lake | Illinois | 17097 | 56869 | 959 |
975793 | 975793 | 2021-01-29 | Alameda | California | 6001 | 73136 | 959 |
852909 | 852909 | 2020-12-22 | DuPage | Illinois | 17043 | 58402 | 959 |
847036 | 847036 | 2020-12-20 | Plymouth | Massachusetts | 25023 | 20729 | 959 |
837864 | 837864 | 2020-12-17 | Monmouth | New Jersey | 34025 | 26920 | 959 |
797463 | 797463 | 2020-12-05 | Hillsborough | Florida | 12057 | 60761 | 959 |
794618 | 794618 | 2020-12-04 | Marion | Indiana | 18097 | 50080 | 959 |
629746 | 629746 | 2020-10-14 | Hennepin | Minnesota | 27053 | 30923 | 959 |
491808 | 491808 | 2020-09-01 | Dallas | Texas | 48113 | 75268 | 959 |
332671 | 332671 | 2020-07-14 | Norfolk | Massachusetts | 25021 | 9530 | 959 |
329488 | 329488 | 2020-07-13 | Worcester | Massachusetts | 25027 | 12679 | 959 |
312466 | 312466 | 2020-07-08 | Maricopa | Arizona | 4013 | 70128 | 959 |
291974 | 291974 | 2020-07-01 | Ocean | New Jersey | 34029 | 9695 | 959 |
247563 | 247563 | 2020-06-17 | Suffolk | Massachusetts | 25025 | 19434 | 959 |
180173 | 180173 | 2020-05-26 | Middlesex | New Jersey | 34023 | 15499 | 959 |
80127 | 80127 | 2020-04-22 | Suffolk | New York | 36103 | 28854 | 959 |
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);