ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
134 rows where deaths = 666 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Michigan 15
- Missouri 13
- California 11
- Alabama 9
- Pennsylvania 8
- Washington 7
- Louisiana 6
- New York 6
- Wisconsin 6
- Arkansas 5
- Florida 5
- Indiana 4
- Maryland 4
- Ohio 4
- Texas 4
- Illinois 3
- Massachusetts 3
- Virginia 3
- Colorado 2
- Delaware 2
- Georgia 2
- New Mexico 2
- Tennessee 2
- Arizona 1
- New Jersey 1
- North Carolina 1
- Oklahoma 1
- Oregon 1
- South Carolina 1
- Utah 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2384645 | 2384645 | 2022-04-07 | Fayette | Pennsylvania | 42051 | 31022 | 666 |
2354350 | 2354350 | 2022-03-29 | Kalamazoo | Michigan | 26077 | 58912 | 666 |
2351098 | 2351098 | 2022-03-28 | Kalamazoo | Michigan | 26077 | 58912 | 666 |
2347845 | 2347845 | 2022-03-27 | Kalamazoo | Michigan | 26077 | 58867 | 666 |
2344592 | 2344592 | 2022-03-26 | Kalamazoo | Michigan | 26077 | 58867 | 666 |
2341339 | 2341339 | 2022-03-25 | Kalamazoo | Michigan | 26077 | 58867 | 666 |
2338086 | 2338086 | 2022-03-24 | Kalamazoo | Michigan | 26077 | 58811 | 666 |
2334832 | 2334832 | 2022-03-23 | Kalamazoo | Michigan | 26077 | 58811 | 666 |
2320004 | 2320004 | 2022-03-18 | Gregg | Texas | 48183 | 23089 | 666 |
2310733 | 2310733 | 2022-03-15 | Racine | Wisconsin | 55101 | 56009 | 666 |
2304274 | 2304274 | 2022-03-14 | Baldwin | Alabama | 1003 | 55189 | 666 |
2307480 | 2307480 | 2022-03-14 | Racine | Wisconsin | 55101 | 55994 | 666 |
2304229 | 2304229 | 2022-03-13 | Racine | Wisconsin | 55101 | 55978 | 666 |
2300977 | 2300977 | 2022-03-12 | Racine | Wisconsin | 55101 | 55978 | 666 |
2297725 | 2297725 | 2022-03-11 | Racine | Wisconsin | 55101 | 55978 | 666 |
2264612 | 2264612 | 2022-03-01 | Unknown | Tennessee | 27283 | 666 | |
2248860 | 2248860 | 2022-02-24 | Kanawha | West Virginia | 54039 | 46376 | 666 |
2243718 | 2243718 | 2022-02-23 | Barnstable | Massachusetts | 25001 | 34233 | 666 |
2191615 | 2191615 | 2022-02-07 | Ouachita | Louisiana | 22073 | 49257 | 666 |
2192564 | 2192564 | 2022-02-07 | Lake | Ohio | 39085 | 48178 | 666 |
2189310 | 2189310 | 2022-02-06 | Lake | Ohio | 39085 | 48162 | 666 |
2186057 | 2186057 | 2022-02-05 | Lake | Ohio | 39085 | 48148 | 666 |
2182805 | 2182805 | 2022-02-04 | Lake | Ohio | 39085 | 48122 | 666 |
2177248 | 2177248 | 2022-02-02 | Virginia Beach city | Virginia | 51810 | 85839 | 666 |
2169511 | 2169511 | 2022-01-31 | Doña Ana | New Mexico | 35013 | 58314 | 666 |
2165710 | 2165710 | 2022-01-30 | Ingham | Michigan | 26065 | 59438 | 666 |
2166713 | 2166713 | 2022-01-30 | Cambria | Pennsylvania | 42021 | 32593 | 666 |
2162455 | 2162455 | 2022-01-29 | Ingham | Michigan | 26065 | 59438 | 666 |
2163458 | 2163458 | 2022-01-29 | Cambria | Pennsylvania | 42021 | 32505 | 666 |
2159200 | 2159200 | 2022-01-28 | Ingham | Michigan | 26065 | 59438 | 666 |
2156946 | 2156946 | 2022-01-27 | Butler | Pennsylvania | 42019 | 41726 | 666 |
2142382 | 2142382 | 2022-01-23 | Elkhart | Indiana | 18039 | 50146 | 666 |
2139127 | 2139127 | 2022-01-22 | Elkhart | Indiana | 18039 | 50146 | 666 |
2135871 | 2135871 | 2022-01-21 | Elkhart | Indiana | 18039 | 50146 | 666 |
2102688 | 2102688 | 2022-01-11 | Tuscaloosa | Alabama | 1125 | 41502 | 666 |
2104465 | 2104465 | 2022-01-11 | San Juan | New Mexico | 35045 | 30274 | 666 |
2099437 | 2099437 | 2022-01-10 | Tuscaloosa | Alabama | 1125 | 41162 | 666 |
2096186 | 2096186 | 2022-01-09 | Tuscaloosa | Alabama | 1125 | 40948 | 666 |
2092934 | 2092934 | 2022-01-08 | Tuscaloosa | Alabama | 1125 | 40326 | 666 |
2089274 | 2089274 | 2022-01-06 | Utah | Utah | 49049 | 150556 | 666 |
2063906 | 2063906 | 2021-12-30 | Pueblo | Colorado | 8101 | 31496 | 666 |
2038316 | 2038316 | 2021-12-22 | Winnebago | Illinois | 17201 | 52113 | 666 |
2031227 | 2031227 | 2021-12-20 | Benton | Arkansas | 5007 | 45215 | 666 |
2021680 | 2021680 | 2021-12-17 | Sussex | Delaware | 10005 | 39987 | 666 |
2009045 | 2009045 | 2021-12-13 | St. Clair | Illinois | 17163 | 44453 | 666 |
2006985 | 2006985 | 2021-12-12 | Oneida | New York | 36065 | 35309 | 666 |
2003734 | 2003734 | 2021-12-11 | Oneida | New York | 36065 | 35182 | 666 |
2000483 | 2000483 | 2021-12-10 | Oneida | New York | 36065 | 34994 | 666 |
1984638 | 1984638 | 2021-12-05 | Cumberland | Pennsylvania | 42041 | 32305 | 666 |
1981388 | 1981388 | 2021-12-04 | Cumberland | Pennsylvania | 42041 | 32203 | 666 |
1966599 | 1966599 | 2021-11-30 | Muscogee | Georgia | 13215 | 24654 | 666 |
1963347 | 1963347 | 2021-11-29 | Muscogee | Georgia | 13215 | 24622 | 666 |
1943555 | 1943555 | 2021-11-23 | Merced | California | 6047 | 45164 | 666 |
1907819 | 1907819 | 2021-11-12 | San Francisco | California | 6075 | 55827 | 666 |
1904570 | 1904570 | 2021-11-11 | San Francisco | California | 6075 | 55827 | 666 |
1901320 | 1901320 | 2021-11-10 | San Francisco | California | 6075 | 55706 | 666 |
1898070 | 1898070 | 2021-11-09 | San Francisco | California | 6075 | 55652 | 666 |
1894820 | 1894820 | 2021-11-08 | San Francisco | California | 6075 | 55578 | 666 |
1891570 | 1891570 | 2021-11-07 | San Francisco | California | 6075 | 55266 | 666 |
1888320 | 1888320 | 2021-11-06 | San Francisco | California | 6075 | 55266 | 666 |
1885070 | 1885070 | 2021-11-05 | San Francisco | California | 6075 | 55266 | 666 |
1830268 | 1830268 | 2021-10-19 | Madison | Illinois | 17119 | 40041 | 666 |
1816112 | 1816112 | 2021-10-14 | Jefferson | Texas | 48245 | 31374 | 666 |
1806912 | 1806912 | 2021-10-12 | Madison | Alabama | 1089 | 51655 | 666 |
1808184 | 1808184 | 2021-10-12 | Saginaw | Michigan | 26145 | 26926 | 666 |
1808465 | 1808465 | 2021-10-12 | St. Charles | Missouri | 29183 | 60605 | 666 |
1809506 | 1809506 | 2021-10-12 | Bell | Texas | 48027 | 37740 | 666 |
1803661 | 1803661 | 2021-10-11 | Madison | Alabama | 1089 | 51605 | 666 |
1804933 | 1804933 | 2021-10-11 | Saginaw | Michigan | 26145 | 26926 | 666 |
1805214 | 1805214 | 2021-10-11 | St. Charles | Missouri | 29183 | 60499 | 666 |
1800412 | 1800412 | 2021-10-10 | Madison | Alabama | 1089 | 51569 | 666 |
1801684 | 1801684 | 2021-10-10 | Saginaw | Michigan | 26145 | 26717 | 666 |
1801965 | 1801965 | 2021-10-10 | St. Charles | Missouri | 29183 | 60401 | 666 |
1797163 | 1797163 | 2021-10-09 | Madison | Alabama | 1089 | 51509 | 666 |
1798435 | 1798435 | 2021-10-09 | Saginaw | Michigan | 26145 | 26717 | 666 |
1798716 | 1798716 | 2021-10-09 | St. Charles | Missouri | 29183 | 60261 | 666 |
1795186 | 1795186 | 2021-10-08 | Saginaw | Michigan | 26145 | 26717 | 666 |
1795467 | 1795467 | 2021-10-08 | St. Charles | Missouri | 29183 | 60244 | 666 |
1792218 | 1792218 | 2021-10-07 | St. Charles | Missouri | 29183 | 60154 | 666 |
1792875 | 1792875 | 2021-10-07 | Multnomah | Oregon | 41051 | 54040 | 666 |
1788969 | 1788969 | 2021-10-06 | St. Charles | Missouri | 29183 | 60027 | 666 |
1785721 | 1785721 | 2021-10-05 | St. Charles | Missouri | 29183 | 59902 | 666 |
1786909 | 1786909 | 2021-10-05 | McLennan | Texas | 48309 | 41044 | 666 |
1782472 | 1782472 | 2021-10-04 | St. Charles | Missouri | 29183 | 59782 | 666 |
1779222 | 1779222 | 2021-10-03 | St. Charles | Missouri | 29183 | 59699 | 666 |
1775972 | 1775972 | 2021-10-02 | St. Charles | Missouri | 29183 | 59513 | 666 |
1772722 | 1772722 | 2021-10-01 | St. Charles | Missouri | 29183 | 59512 | 666 |
1769473 | 1769473 | 2021-09-30 | St. Charles | Missouri | 29183 | 59418 | 666 |
1767075 | 1767075 | 2021-09-29 | Lexington | South Carolina | 45063 | 52099 | 666 |
1725374 | 1725374 | 2021-09-16 | Henrico | Virginia | 51087 | 31288 | 666 |
1715734 | 1715734 | 2021-09-13 | Snohomish | Washington | 53061 | 54633 | 666 |
1608026 | 1608026 | 2021-08-11 | Knox | Tennessee | 47093 | 55082 | 666 |
1559807 | 1559807 | 2021-07-27 | Pierce | Washington | 53053 | 59189 | 666 |
1556560 | 1556560 | 2021-07-26 | Pierce | Washington | 53053 | 59072 | 666 |
1553313 | 1553313 | 2021-07-25 | Pierce | Washington | 53053 | 58646 | 666 |
1550066 | 1550066 | 2021-07-24 | Pierce | Washington | 53053 | 58646 | 666 |
1546819 | 1546819 | 2021-07-23 | Pierce | Washington | 53053 | 58646 | 666 |
1518957 | 1518957 | 2021-07-15 | Anne Arundel | Maryland | 24003 | 44122 | 666 |
1515710 | 1515710 | 2021-07-14 | Anne Arundel | Maryland | 24003 | 44097 | 666 |
1512464 | 1512464 | 2021-07-13 | Anne Arundel | Maryland | 24003 | 44089 | 666 |
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);