ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
169 rows where deaths = 723 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- New York 35
- Pennsylvania 17
- Texas 13
- Indiana 12
- Georgia 8
- Massachusetts 8
- Illinois 7
- Oklahoma 7
- New Mexico 6
- West Virginia 6
- Louisiana 4
- Michigan 4
- New Hampshire 4
- New Jersey 4
- Tennessee 4
- Arizona 3
- Florida 3
- Maryland 3
- Ohio 3
- South Carolina 3
- Colorado 2
- Minnesota 2
- North Carolina 2
- Alabama 1
- Arkansas 1
- California 1
- Connecticut 1
- Missouri 1
- Oregon 1
- Utah 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2492928 | 2492928 | 2022-05-10 | Kanawha | West Virginia | 54039 | 47574 | 723 |
2489670 | 2489670 | 2022-05-09 | Kanawha | West Virginia | 54039 | 47574 | 723 |
2486413 | 2486413 | 2022-05-08 | Kanawha | West Virginia | 54039 | 47500 | 723 |
2483155 | 2483155 | 2022-05-07 | Kanawha | West Virginia | 54039 | 47500 | 723 |
2479897 | 2479897 | 2022-05-06 | Kanawha | West Virginia | 54039 | 47500 | 723 |
2476639 | 2476639 | 2022-05-05 | Kanawha | West Virginia | 54039 | 47464 | 723 |
2473107 | 2473107 | 2022-05-04 | Taylor | Texas | 48441 | 35116 | 723 |
2400907 | 2400907 | 2022-04-12 | Cambria | Pennsylvania | 42021 | 34574 | 723 |
2397652 | 2397652 | 2022-04-11 | Cambria | Pennsylvania | 42021 | 34568 | 723 |
2394397 | 2394397 | 2022-04-10 | Cambria | Pennsylvania | 42021 | 34568 | 723 |
2391141 | 2391141 | 2022-04-09 | Cambria | Pennsylvania | 42021 | 34567 | 723 |
2387885 | 2387885 | 2022-04-08 | Cambria | Pennsylvania | 42021 | 34561 | 723 |
2332574 | 2332574 | 2022-03-22 | Butler | Pennsylvania | 42019 | 44306 | 723 |
2328867 | 2328867 | 2022-03-21 | Doña Ana | New Mexico | 35013 | 62983 | 723 |
2316784 | 2316784 | 2022-03-17 | Johnson | Texas | 48251 | 42403 | 723 |
2313531 | 2313531 | 2022-03-16 | Johnson | Texas | 48251 | 42339 | 723 |
2310278 | 2310278 | 2022-03-15 | Johnson | Texas | 48251 | 42268 | 723 |
2310555 | 2310555 | 2022-03-15 | Prince William | Virginia | 51153 | 94100 | 723 |
2293372 | 2293372 | 2022-03-10 | Lake | Ohio | 39085 | 48667 | 723 |
2290120 | 2290120 | 2022-03-09 | Lake | Ohio | 39085 | 48656 | 723 |
2285486 | 2285486 | 2022-03-08 | Elkhart | Indiana | 18039 | 54053 | 723 |
2286868 | 2286868 | 2022-03-08 | Lake | Ohio | 39085 | 48646 | 723 |
2282234 | 2282234 | 2022-03-07 | Elkhart | Indiana | 18039 | 54045 | 723 |
2283348 | 2283348 | 2022-03-07 | San Juan | New Mexico | 35045 | 40357 | 723 |
2280095 | 2280095 | 2022-03-06 | San Juan | New Mexico | 35045 | 40313 | 723 |
2276842 | 2276842 | 2022-03-05 | San Juan | New Mexico | 35045 | 40313 | 723 |
2273589 | 2273589 | 2022-03-04 | San Juan | New Mexico | 35045 | 40313 | 723 |
2270337 | 2270337 | 2022-03-03 | San Juan | New Mexico | 35045 | 40277 | 723 |
2262057 | 2262057 | 2022-03-01 | Tuscaloosa | Alabama | 1125 | 54630 | 723 |
2251292 | 2251292 | 2022-02-25 | Lackawanna | Pennsylvania | 42069 | 42724 | 723 |
2218772 | 2218772 | 2022-02-15 | Erie | Pennsylvania | 42049 | 55872 | 723 |
2191803 | 2191803 | 2022-02-07 | Dakota | Minnesota | 27037 | 104727 | 723 |
2172255 | 2172255 | 2022-02-01 | Ottawa | Michigan | 26139 | 70822 | 723 |
2169002 | 2169002 | 2022-01-31 | Ottawa | Michigan | 26139 | 70822 | 723 |
2151876 | 2151876 | 2022-01-26 | Hall | Georgia | 13139 | 50628 | 723 |
2148624 | 2148624 | 2022-01-25 | Hall | Georgia | 13139 | 50351 | 723 |
2148853 | 2148853 | 2022-01-25 | St. Clair | Illinois | 17163 | 64421 | 723 |
2130521 | 2130521 | 2022-01-19 | Oneida | New York | 36065 | 47078 | 723 |
2125598 | 2125598 | 2022-01-18 | Merced | California | 6047 | 55997 | 723 |
2127267 | 2127267 | 2022-01-18 | Oneida | New York | 36065 | 46781 | 723 |
2124015 | 2124015 | 2022-01-17 | Oneida | New York | 36065 | 46553 | 723 |
2120763 | 2120763 | 2022-01-16 | Oneida | New York | 36065 | 46305 | 723 |
2106581 | 2106581 | 2022-01-12 | Winnebago | Illinois | 17201 | 62521 | 723 |
2074021 | 2074021 | 2022-01-02 | Madison | Illinois | 17119 | 48340 | 723 |
2070770 | 2070770 | 2022-01-01 | Madison | Illinois | 17119 | 48340 | 723 |
2067519 | 2067519 | 2021-12-31 | Madison | Illinois | 17119 | 48340 | 723 |
2064268 | 2064268 | 2021-12-30 | Madison | Illinois | 17119 | 48340 | 723 |
2062964 | 2062964 | 2021-12-29 | Rutherford | Tennessee | 47149 | 67523 | 723 |
2005521 | 2005521 | 2021-12-12 | Chatham | Georgia | 13051 | 39458 | 723 |
2002270 | 2002270 | 2021-12-11 | Chatham | Georgia | 13051 | 39458 | 723 |
1999020 | 1999020 | 2021-12-10 | Chatham | Georgia | 13051 | 39458 | 723 |
1995769 | 1995769 | 2021-12-09 | Chatham | Georgia | 13051 | 39429 | 723 |
1997917 | 1997917 | 2021-12-09 | Hamilton | Tennessee | 47065 | 66358 | 723 |
1994553 | 1994553 | 2021-12-08 | Lexington | South Carolina | 45063 | 55958 | 723 |
1994666 | 1994666 | 2021-12-08 | Hamilton | Tennessee | 47065 | 66181 | 723 |
1984139 | 1984139 | 2021-12-05 | Hillsborough | New Hampshire | 33011 | 55547 | 723 |
1980889 | 1980889 | 2021-12-04 | Hillsborough | New Hampshire | 33011 | 55547 | 723 |
1977639 | 1977639 | 2021-12-03 | Hillsborough | New Hampshire | 33011 | 55547 | 723 |
1973918 | 1973918 | 2021-12-02 | Saginaw | Michigan | 26145 | 33225 | 723 |
1974389 | 1974389 | 2021-12-02 | Hillsborough | New Hampshire | 33011 | 55058 | 723 |
1970669 | 1970669 | 2021-12-01 | Saginaw | Michigan | 26145 | 33225 | 723 |
1944942 | 1944942 | 2021-11-23 | St. Charles | Missouri | 29183 | 64252 | 723 |
1936342 | 1936342 | 2021-11-20 | Jefferson | Texas | 48245 | 31877 | 723 |
1933092 | 1933092 | 2021-11-19 | Jefferson | Texas | 48245 | 31865 | 723 |
1929841 | 1929841 | 2021-11-18 | Jefferson | Texas | 48245 | 31856 | 723 |
1920215 | 1920215 | 2021-11-15 | Williamson | Texas | 48491 | 77807 | 723 |
1903735 | 1903735 | 2021-11-10 | Bell | Texas | 48027 | 39146 | 723 |
1900485 | 1900485 | 2021-11-09 | Bell | Texas | 48027 | 39146 | 723 |
1877353 | 1877353 | 2021-11-02 | Multnomah | Oregon | 41051 | 57273 | 723 |
1860027 | 1860027 | 2021-10-28 | St. Tammany | Louisiana | 22103 | 43557 | 723 |
1841157 | 1841157 | 2021-10-22 | Gloucester | New Jersey | 34015 | 37965 | 723 |
1767083 | 1767083 | 2021-09-29 | Richland | South Carolina | 45079 | 66283 | 723 |
1756760 | 1756760 | 2021-09-26 | Onondaga | New York | 36067 | 46663 | 723 |
1747780 | 1747780 | 2021-09-23 | Brazoria | Texas | 48039 | 56061 | 723 |
1733931 | 1733931 | 2021-09-19 | Atlantic | New Jersey | 34001 | 36526 | 723 |
1730681 | 1730681 | 2021-09-18 | Atlantic | New Jersey | 34001 | 36413 | 723 |
1631276 | 1631276 | 2021-08-18 | Spokane | Washington | 53063 | 53103 | 723 |
1624003 | 1624003 | 2021-08-16 | Northampton | Pennsylvania | 42095 | 37422 | 723 |
1620756 | 1620756 | 2021-08-15 | Northampton | Pennsylvania | 42095 | 37359 | 723 |
1617508 | 1617508 | 2021-08-14 | Northampton | Pennsylvania | 42095 | 37290 | 723 |
1614260 | 1614260 | 2021-08-13 | Northampton | Pennsylvania | 42095 | 37211 | 723 |
1611011 | 1611011 | 2021-08-12 | Northampton | Pennsylvania | 42095 | 37126 | 723 |
1599658 | 1599658 | 2021-08-09 | Allen | Indiana | 18003 | 44255 | 723 |
1596410 | 1596410 | 2021-08-08 | Allen | Indiana | 18003 | 43914 | 723 |
1593161 | 1593161 | 2021-08-07 | Allen | Indiana | 18003 | 43914 | 723 |
1589912 | 1589912 | 2021-08-06 | Allen | Indiana | 18003 | 43914 | 723 |
1586663 | 1586663 | 2021-08-05 | Allen | Indiana | 18003 | 43766 | 723 |
1583413 | 1583413 | 2021-08-04 | Allen | Indiana | 18003 | 43648 | 723 |
1579627 | 1579627 | 2021-08-03 | Pulaski | Arkansas | 5119 | 47827 | 723 |
1580163 | 1580163 | 2021-08-03 | Allen | Indiana | 18003 | 43556 | 723 |
1576914 | 1576914 | 2021-08-02 | Allen | Indiana | 18003 | 43442 | 723 |
1532623 | 1532623 | 2021-07-19 | Orange | New York | 36071 | 48627 | 723 |
1529376 | 1529376 | 2021-07-18 | Orange | New York | 36071 | 48610 | 723 |
1526129 | 1526129 | 2021-07-17 | Orange | New York | 36071 | 48592 | 723 |
1522882 | 1522882 | 2021-07-16 | Orange | New York | 36071 | 48576 | 723 |
1519634 | 1519634 | 2021-07-15 | Orange | New York | 36071 | 48561 | 723 |
1516386 | 1516386 | 2021-07-14 | Orange | New York | 36071 | 48555 | 723 |
1513139 | 1513139 | 2021-07-13 | Orange | New York | 36071 | 48539 | 723 |
1509893 | 1509893 | 2021-07-12 | Orange | New York | 36071 | 48533 | 723 |
1506646 | 1506646 | 2021-07-11 | Orange | New York | 36071 | 48532 | 723 |
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);