ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
197 rows where deaths = 565 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 15
- Illinois 14
- Ohio 13
- Alabama 12
- Florida 10
- Pennsylvania 10
- California 9
- Maryland 9
- North Carolina 9
- Oregon 9
- Mississippi 7
- New Mexico 7
- Louisiana 6
- New Jersey 6
- South Carolina 6
- Washington 6
- Arizona 5
- Georgia 5
- Tennessee 5
- Colorado 4
- New York 4
- Virginia 4
- Kansas 3
- Arkansas 2
- Connecticut 2
- Hawaii 2
- Massachusetts 2
- Michigan 2
- Delaware 1
- Idaho 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499859 | 2499859 | 2022-05-13 | Mesa | Colorado | 8077 | 43093 | 565 |
2444588 | 2444588 | 2022-04-26 | St. Johns | Florida | 12109 | 62698 | 565 |
2446128 | 2446128 | 2022-04-26 | Buncombe | North Carolina | 37021 | 52680 | 565 |
2441332 | 2441332 | 2022-04-25 | St. Johns | Florida | 12109 | 62698 | 565 |
2442873 | 2442873 | 2022-04-25 | Buncombe | North Carolina | 37021 | 52680 | 565 |
2438076 | 2438076 | 2022-04-24 | St. Johns | Florida | 12109 | 62698 | 565 |
2439617 | 2439617 | 2022-04-24 | Buncombe | North Carolina | 37021 | 52680 | 565 |
2434820 | 2434820 | 2022-04-23 | St. Johns | Florida | 12109 | 62698 | 565 |
2436361 | 2436361 | 2022-04-23 | Buncombe | North Carolina | 37021 | 52680 | 565 |
2431564 | 2431564 | 2022-04-22 | St. Johns | Florida | 12109 | 62698 | 565 |
2433105 | 2433105 | 2022-04-22 | Buncombe | North Carolina | 37021 | 52680 | 565 |
2428308 | 2428308 | 2022-04-21 | St. Johns | Florida | 12109 | 62469 | 565 |
2429849 | 2429849 | 2022-04-21 | Buncombe | North Carolina | 37021 | 52680 | 565 |
2425052 | 2425052 | 2022-04-20 | St. Johns | Florida | 12109 | 62469 | 565 |
2426593 | 2426593 | 2022-04-20 | Buncombe | North Carolina | 37021 | 52680 | 565 |
2326026 | 2326026 | 2022-03-20 | Clackamas | Oregon | 41005 | 59674 | 565 |
2322773 | 2322773 | 2022-03-19 | Clackamas | Oregon | 41005 | 59674 | 565 |
2319519 | 2319519 | 2022-03-18 | Clackamas | Oregon | 41005 | 59674 | 565 |
2316017 | 2316017 | 2022-03-17 | Rowan | North Carolina | 37159 | 40985 | 565 |
2299647 | 2299647 | 2022-03-12 | Niagara | New York | 36063 | 47403 | 565 |
2296395 | 2296395 | 2022-03-11 | Niagara | New York | 36063 | 47389 | 565 |
2279242 | 2279242 | 2022-03-06 | Shawnee | Kansas | 20177 | 47883 | 565 |
2275989 | 2275989 | 2022-03-05 | Shawnee | Kansas | 20177 | 47883 | 565 |
2272736 | 2272736 | 2022-03-04 | Shawnee | Kansas | 20177 | 47883 | 565 |
2266462 | 2266462 | 2022-03-02 | Harford | Maryland | 24025 | 37775 | 565 |
2263211 | 2263211 | 2022-03-01 | Harford | Maryland | 24025 | 37759 | 565 |
2257325 | 2257325 | 2022-02-27 | McKinley | New Mexico | 35031 | 25396 | 565 |
2254074 | 2254074 | 2022-02-26 | McKinley | New Mexico | 35031 | 25396 | 565 |
2250207 | 2250207 | 2022-02-25 | Harford | Maryland | 24025 | 37680 | 565 |
2250217 | 2250217 | 2022-02-25 | Washington | Maryland | 24043 | 34759 | 565 |
2250823 | 2250823 | 2022-02-25 | McKinley | New Mexico | 35031 | 25396 | 565 |
2246956 | 2246956 | 2022-02-24 | Harford | Maryland | 24025 | 37659 | 565 |
2246966 | 2246966 | 2022-02-24 | Washington | Maryland | 24043 | 34731 | 565 |
2247572 | 2247572 | 2022-02-24 | McKinley | New Mexico | 35031 | 25362 | 565 |
2243705 | 2243705 | 2022-02-23 | Harford | Maryland | 24025 | 37631 | 565 |
2244321 | 2244321 | 2022-02-23 | McKinley | New Mexico | 35031 | 25332 | 565 |
2239823 | 2239823 | 2022-02-22 | Kootenai | Idaho | 16055 | 38656 | 565 |
2196971 | 2196971 | 2022-02-09 | Calhoun | Alabama | 1015 | 30989 | 565 |
2193716 | 2193716 | 2022-02-08 | Calhoun | Alabama | 1015 | 30857 | 565 |
2194885 | 2194885 | 2022-02-08 | Tangipahoa | Louisiana | 22105 | 33867 | 565 |
2190463 | 2190463 | 2022-02-07 | Calhoun | Alabama | 1015 | 30725 | 565 |
2187210 | 2187210 | 2022-02-06 | Calhoun | Alabama | 1015 | 30612 | 565 |
2189002 | 2189002 | 2022-02-06 | Cumberland | New Jersey | 34011 | 37456 | 565 |
2183957 | 2183957 | 2022-02-05 | Calhoun | Alabama | 1015 | 30612 | 565 |
2180705 | 2180705 | 2022-02-04 | Calhoun | Alabama | 1015 | 30575 | 565 |
2181017 | 2181017 | 2022-02-04 | Kent | Delaware | 10001 | 48229 | 565 |
2176660 | 2176660 | 2022-02-02 | York | South Carolina | 45091 | 73085 | 565 |
2147242 | 2147242 | 2022-01-24 | Washington | Pennsylvania | 42125 | 46452 | 565 |
2143988 | 2143988 | 2022-01-23 | Washington | Pennsylvania | 42125 | 46146 | 565 |
2133199 | 2133199 | 2022-01-20 | Muskegon | Michigan | 26121 | 37014 | 565 |
2129394 | 2129394 | 2022-01-19 | Madison | Indiana | 18095 | 28760 | 565 |
2129946 | 2129946 | 2022-01-19 | Muskegon | Michigan | 26121 | 37014 | 565 |
2128597 | 2128597 | 2022-01-18 | Racine | Wisconsin | 55101 | 51745 | 565 |
2125006 | 2125006 | 2022-01-17 | Wichita | Texas | 48485 | 27770 | 565 |
2121754 | 2121754 | 2022-01-16 | Wichita | Texas | 48485 | 27770 | 565 |
2117493 | 2117493 | 2022-01-15 | Dutchess | New York | 36027 | 57058 | 565 |
2101481 | 2101481 | 2022-01-10 | Lake | Ohio | 39085 | 44837 | 565 |
2098230 | 2098230 | 2022-01-09 | Lake | Ohio | 39085 | 44577 | 565 |
2094978 | 2094978 | 2022-01-08 | Lake | Ohio | 39085 | 44184 | 565 |
2091726 | 2091726 | 2022-01-07 | Lake | Ohio | 39085 | 43904 | 565 |
2084347 | 2084347 | 2022-01-05 | Barnstable | Massachusetts | 25001 | 26145 | 565 |
2055301 | 2055301 | 2021-12-27 | Harrison | Mississippi | 28047 | 35565 | 565 |
2052051 | 2052051 | 2021-12-26 | Harrison | Mississippi | 28047 | 35351 | 565 |
2048801 | 2048801 | 2021-12-25 | Harrison | Mississippi | 28047 | 35351 | 565 |
2045551 | 2045551 | 2021-12-24 | Harrison | Mississippi | 28047 | 35351 | 565 |
2042301 | 2042301 | 2021-12-23 | Harrison | Mississippi | 28047 | 35351 | 565 |
2039052 | 2039052 | 2021-12-22 | Harrison | Mississippi | 28047 | 35351 | 565 |
2035802 | 2035802 | 2021-12-21 | Harrison | Mississippi | 28047 | 35323 | 565 |
2037056 | 2037056 | 2021-12-21 | Ector | Texas | 48135 | 27696 | 565 |
2018416 | 2018416 | 2021-12-16 | Weld | Colorado | 8123 | 55205 | 565 |
2000905 | 2000905 | 2021-12-10 | Lackawanna | Pennsylvania | 42069 | 26552 | 565 |
1993925 | 1993925 | 2021-12-08 | Doña Ana | New Mexico | 35013 | 38383 | 565 |
1995170 | 1995170 | 2021-12-08 | Clark | Washington | 53011 | 46035 | 565 |
1971629 | 1971629 | 2021-12-01 | Cambria | Pennsylvania | 42021 | 22742 | 565 |
1965665 | 1965665 | 2021-11-29 | Potter | Texas | 48375 | 24759 | 565 |
1962413 | 1962413 | 2021-11-28 | Potter | Texas | 48375 | 24708 | 565 |
1959162 | 1959162 | 2021-11-27 | Potter | Texas | 48375 | 24708 | 565 |
1955911 | 1955911 | 2021-11-26 | Potter | Texas | 48375 | 24708 | 565 |
1952660 | 1952660 | 2021-11-25 | Potter | Texas | 48375 | 24708 | 565 |
1949409 | 1949409 | 2021-11-24 | Potter | Texas | 48375 | 24708 | 565 |
1920395 | 1920395 | 2021-11-15 | Virginia Beach city | Virginia | 51810 | 50586 | 565 |
1896434 | 1896434 | 2021-11-08 | San Juan | New Mexico | 35045 | 23501 | 565 |
1860993 | 1860993 | 2021-10-28 | Trumbull | Ohio | 39155 | 23237 | 565 |
1857744 | 1857744 | 2021-10-27 | Trumbull | Ohio | 39155 | 23143 | 565 |
1854495 | 1854495 | 2021-10-26 | Trumbull | Ohio | 39155 | 23064 | 565 |
1806717 | 1806717 | 2021-10-11 | Yakima | Washington | 53077 | 43360 | 565 |
1773004 | 1773004 | 2021-10-01 | Oneida | New York | 36065 | 26723 | 565 |
1758589 | 1758589 | 2021-09-27 | Hall | Georgia | 13139 | 36382 | 565 |
1752187 | 1752187 | 2021-09-25 | Honolulu | Hawaii | 15003 | 54139 | 565 |
1748938 | 1748938 | 2021-09-24 | Honolulu | Hawaii | 15003 | 53864 | 565 |
1742000 | 1742000 | 2021-09-22 | Benton | Arkansas | 5007 | 40180 | 565 |
1722433 | 1722433 | 2021-09-16 | Madison | Alabama | 1089 | 47959 | 565 |
1705689 | 1705689 | 2021-09-10 | McLennan | Texas | 48309 | 37205 | 565 |
1700357 | 1700357 | 2021-09-09 | Winnebago | Illinois | 17201 | 37844 | 565 |
1697108 | 1697108 | 2021-09-08 | Winnebago | Illinois | 17201 | 37714 | 565 |
1693860 | 1693860 | 2021-09-07 | Winnebago | Illinois | 17201 | 37653 | 565 |
1690611 | 1690611 | 2021-09-06 | Winnebago | Illinois | 17201 | 37384 | 565 |
1692470 | 1692470 | 2021-09-06 | Hamilton | Tennessee | 47065 | 55571 | 565 |
1687361 | 1687361 | 2021-09-05 | Winnebago | Illinois | 17201 | 37384 | 565 |
1689221 | 1689221 | 2021-09-05 | Hamilton | Tennessee | 47065 | 55571 | 565 |
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);