ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
135 rows where deaths = 662 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Pennsylvania 22
- Georgia 17
- Texas 17
- Illinois 10
- Ohio 10
- Arizona 6
- New Hampshire 6
- Colorado 5
- Louisiana 4
- Alabama 3
- New Jersey 3
- Washington 3
- Arkansas 2
- Connecticut 2
- Idaho 2
- Indiana 2
- Maryland 2
- Massachusetts 2
- Michigan 2
- Missouri 2
- Nevada 2
- Virginia 2
- California 1
- Florida 1
- Hawaii 1
- Minnesota 1
- Mississippi 1
- New Mexico 1
- Oregon 1
- South Carolina 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499889 | 2499889 | 2022-05-13 | New London | Connecticut | 9011 | 58138 | 662 |
2337269 | 2337269 | 2022-03-24 | Henry | Georgia | 13151 | 57608 | 662 |
2335844 | 2335844 | 2022-03-23 | Fayette | Pennsylvania | 42051 | 30940 | 662 |
2332590 | 2332590 | 2022-03-22 | Fayette | Pennsylvania | 42051 | 30934 | 662 |
2329337 | 2329337 | 2022-03-21 | Fayette | Pennsylvania | 42051 | 30924 | 662 |
2326085 | 2326085 | 2022-03-20 | Fayette | Pennsylvania | 42051 | 30917 | 662 |
2322832 | 2322832 | 2022-03-19 | Fayette | Pennsylvania | 42051 | 30912 | 662 |
2319578 | 2319578 | 2022-03-18 | Fayette | Pennsylvania | 42051 | 30901 | 662 |
2316901 | 2316901 | 2022-03-17 | Wichita | Texas | 48485 | 33968 | 662 |
2306593 | 2306593 | 2022-03-14 | Schuylkill | Pennsylvania | 42107 | 34305 | 662 |
2306991 | 2306991 | 2022-03-14 | Gregg | Texas | 48183 | 23079 | 662 |
2301022 | 2301022 | 2022-03-13 | Baldwin | Alabama | 1003 | 55171 | 662 |
2303342 | 2303342 | 2022-03-13 | Schuylkill | Pennsylvania | 42107 | 34305 | 662 |
2303740 | 2303740 | 2022-03-13 | Gregg | Texas | 48183 | 23075 | 662 |
2297770 | 2297770 | 2022-03-12 | Baldwin | Alabama | 1003 | 55171 | 662 |
2300090 | 2300090 | 2022-03-12 | Schuylkill | Pennsylvania | 42107 | 34300 | 662 |
2300488 | 2300488 | 2022-03-12 | Gregg | Texas | 48183 | 23074 | 662 |
2294518 | 2294518 | 2022-03-11 | Baldwin | Alabama | 1003 | 55171 | 662 |
2296838 | 2296838 | 2022-03-11 | Schuylkill | Pennsylvania | 42107 | 34286 | 662 |
2293586 | 2293586 | 2022-03-10 | Schuylkill | Pennsylvania | 42107 | 34268 | 662 |
2290334 | 2290334 | 2022-03-09 | Schuylkill | Pennsylvania | 42107 | 34253 | 662 |
2283764 | 2283764 | 2022-03-07 | Marion | Oregon | 41047 | 68454 | 662 |
2261038 | 2261038 | 2022-02-28 | Franklin | Pennsylvania | 42055 | 40067 | 662 |
2257787 | 2257787 | 2022-02-27 | Franklin | Pennsylvania | 42055 | 40058 | 662 |
2254536 | 2254536 | 2022-02-26 | Franklin | Pennsylvania | 42055 | 40048 | 662 |
2251285 | 2251285 | 2022-02-25 | Franklin | Pennsylvania | 42055 | 39979 | 662 |
2246311 | 2246311 | 2022-02-24 | Canyon | Idaho | 16027 | 59793 | 662 |
2248034 | 2248034 | 2022-02-24 | Franklin | Pennsylvania | 42055 | 39959 | 662 |
2243060 | 2243060 | 2022-02-23 | Canyon | Idaho | 16027 | 59426 | 662 |
2233043 | 2233043 | 2022-02-20 | Weld | Colorado | 8123 | 79956 | 662 |
2235550 | 2235550 | 2022-02-20 | Potter | Texas | 48375 | 35119 | 662 |
2229792 | 2229792 | 2022-02-19 | Weld | Colorado | 8123 | 79956 | 662 |
2232299 | 2232299 | 2022-02-19 | Potter | Texas | 48375 | 35119 | 662 |
2226541 | 2226541 | 2022-02-18 | Weld | Colorado | 8123 | 79956 | 662 |
2228928 | 2228928 | 2022-02-18 | Ector | Texas | 48135 | 36763 | 662 |
2229048 | 2229048 | 2022-02-18 | Potter | Texas | 48375 | 35119 | 662 |
2225797 | 2225797 | 2022-02-17 | Potter | Texas | 48375 | 35101 | 662 |
2193412 | 2193412 | 2022-02-07 | Chesterfield | Virginia | 51041 | 68645 | 662 |
2153694 | 2153694 | 2022-01-26 | Cambria | Pennsylvania | 42021 | 31713 | 662 |
2132619 | 2132619 | 2022-01-20 | Elkhart | Indiana | 18039 | 49503 | 662 |
2107318 | 2107318 | 2022-01-12 | Hinds | Mississippi | 28049 | 43503 | 662 |
2081212 | 2081212 | 2022-01-04 | Dakota | Minnesota | 27037 | 78475 | 662 |
2065750 | 2065750 | 2021-12-30 | Trumbull | Ohio | 39155 | 31696 | 662 |
2062500 | 2062500 | 2021-12-29 | Trumbull | Ohio | 39155 | 31362 | 662 |
2059250 | 2059250 | 2021-12-28 | Trumbull | Ohio | 39155 | 31111 | 662 |
2056001 | 2056001 | 2021-12-27 | Trumbull | Ohio | 39155 | 30864 | 662 |
2052752 | 2052752 | 2021-12-26 | Trumbull | Ohio | 39155 | 30733 | 662 |
2049502 | 2049502 | 2021-12-25 | Trumbull | Ohio | 39155 | 30343 | 662 |
2046252 | 2046252 | 2021-12-24 | Trumbull | Ohio | 39155 | 30343 | 662 |
2043002 | 2043002 | 2021-12-23 | Trumbull | Ohio | 39155 | 30163 | 662 |
2039753 | 2039753 | 2021-12-22 | Trumbull | Ohio | 39155 | 29928 | 662 |
2036503 | 2036503 | 2021-12-21 | Trumbull | Ohio | 39155 | 29810 | 662 |
2012009 | 2012009 | 2021-12-14 | Bibb | Georgia | 13021 | 26276 | 662 |
2008758 | 2008758 | 2021-12-13 | Bibb | Georgia | 13021 | 26262 | 662 |
2005507 | 2005507 | 2021-12-12 | Bibb | Georgia | 13021 | 26227 | 662 |
2002256 | 2002256 | 2021-12-11 | Bibb | Georgia | 13021 | 26227 | 662 |
1999006 | 1999006 | 2021-12-10 | Bibb | Georgia | 13021 | 26227 | 662 |
1995755 | 1995755 | 2021-12-09 | Bibb | Georgia | 13021 | 26215 | 662 |
1992504 | 1992504 | 2021-12-08 | Bibb | Georgia | 13021 | 26203 | 662 |
1989253 | 1989253 | 2021-12-07 | Bibb | Georgia | 13021 | 26180 | 662 |
1966791 | 1966791 | 2021-11-30 | St. Clair | Illinois | 17163 | 42537 | 662 |
1966881 | 1966881 | 2021-11-30 | St. Joseph | Indiana | 18141 | 49004 | 662 |
1963539 | 1963539 | 2021-11-29 | St. Clair | Illinois | 17163 | 42442 | 662 |
1960096 | 1960096 | 2021-11-28 | Muscogee | Georgia | 13215 | 24573 | 662 |
1960288 | 1960288 | 2021-11-28 | St. Clair | Illinois | 17163 | 42040 | 662 |
1956845 | 1956845 | 2021-11-27 | Muscogee | Georgia | 13215 | 24573 | 662 |
1957037 | 1957037 | 2021-11-27 | St. Clair | Illinois | 17163 | 42040 | 662 |
1953594 | 1953594 | 2021-11-26 | Muscogee | Georgia | 13215 | 24573 | 662 |
1953786 | 1953786 | 2021-11-26 | St. Clair | Illinois | 17163 | 42040 | 662 |
1950343 | 1950343 | 2021-11-25 | Muscogee | Georgia | 13215 | 24573 | 662 |
1950535 | 1950535 | 2021-11-25 | St. Clair | Illinois | 17163 | 42040 | 662 |
1947092 | 1947092 | 2021-11-24 | Muscogee | Georgia | 13215 | 24573 | 662 |
1947284 | 1947284 | 2021-11-24 | St. Clair | Illinois | 17163 | 42040 | 662 |
1943841 | 1943841 | 2021-11-23 | Muscogee | Georgia | 13215 | 24554 | 662 |
1944033 | 1944033 | 2021-11-23 | St. Clair | Illinois | 17163 | 41967 | 662 |
1940305 | 1940305 | 2021-11-22 | Merced | California | 6047 | 45124 | 662 |
1940783 | 1940783 | 2021-11-22 | St. Clair | Illinois | 17163 | 41880 | 662 |
1924302 | 1924302 | 2021-11-17 | Hall | Georgia | 13139 | 38891 | 662 |
1900133 | 1900133 | 2021-11-09 | Dauphin | Pennsylvania | 42043 | 35644 | 662 |
1836661 | 1836661 | 2021-10-21 | Honolulu | Hawaii | 15003 | 57211 | 662 |
1813475 | 1813475 | 2021-10-14 | Yavapai | Arizona | 4025 | 27130 | 662 |
1810226 | 1810226 | 2021-10-13 | Yavapai | Arizona | 4025 | 27020 | 662 |
1812864 | 1812864 | 2021-10-13 | Jefferson | Texas | 48245 | 31305 | 662 |
1785440 | 1785440 | 2021-10-05 | Saginaw | Michigan | 26145 | 26251 | 662 |
1782191 | 1782191 | 2021-10-04 | Saginaw | Michigan | 26145 | 26251 | 662 |
1783301 | 1783301 | 2021-10-04 | Charleston | South Carolina | 45019 | 63510 | 662 |
1783660 | 1783660 | 2021-10-04 | McLennan | Texas | 48309 | 40750 | 662 |
1766224 | 1766224 | 2021-09-29 | St. Charles | Missouri | 29183 | 59297 | 662 |
1743673 | 1743673 | 2021-09-22 | Hillsborough | New Hampshire | 33011 | 41045 | 662 |
1739810 | 1739810 | 2021-09-21 | St. Tammany | Louisiana | 22103 | 42019 | 662 |
1740424 | 1740424 | 2021-09-21 | Hillsborough | New Hampshire | 33011 | 40942 | 662 |
1736561 | 1736561 | 2021-09-20 | St. Tammany | Louisiana | 22103 | 41946 | 662 |
1737175 | 1737175 | 2021-09-20 | Hillsborough | New Hampshire | 33011 | 40874 | 662 |
1733925 | 1733925 | 2021-09-19 | Hillsborough | New Hampshire | 33011 | 40585 | 662 |
1730675 | 1730675 | 2021-09-18 | Hillsborough | New Hampshire | 33011 | 40585 | 662 |
1727425 | 1727425 | 2021-09-17 | Hillsborough | New Hampshire | 33011 | 40585 | 662 |
1718877 | 1718877 | 2021-09-14 | Henrico | Virginia | 51087 | 31066 | 662 |
1702298 | 1702298 | 2021-09-09 | Brazoria | Texas | 48039 | 52763 | 662 |
1670387 | 1670387 | 2021-08-30 | Waukesha | Wisconsin | 55133 | 53653 | 662 |
1640726 | 1640726 | 2021-08-21 | Montgomery | Texas | 48339 | 67824 | 662 |
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);