ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
179 rows where deaths = 641 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Florida 19
- Alabama 17
- Georgia 13
- Louisiana 13
- Virginia 13
- New Hampshire 9
- California 7
- Indiana 7
- Kansas 7
- Mississippi 7
- Oklahoma 7
- Colorado 6
- New Jersey 6
- Texas 6
- New Mexico 5
- Tennessee 5
- District of Columbia 4
- New York 4
- North Carolina 4
- Arizona 3
- Pennsylvania 3
- Iowa 2
- Michigan 2
- Minnesota 2
- Oregon 2
- Illinois 1
- Maryland 1
- Massachusetts 1
- Nevada 1
- South Carolina 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2395398 | 2395398 | 2022-04-11 | Etowah | Alabama | 1055 | 28766 | 641 |
2392142 | 2392142 | 2022-04-10 | Etowah | Alabama | 1055 | 28763 | 641 |
2388886 | 2388886 | 2022-04-09 | Etowah | Alabama | 1055 | 28763 | 641 |
2385631 | 2385631 | 2022-04-08 | Etowah | Alabama | 1055 | 28763 | 641 |
2382376 | 2382376 | 2022-04-07 | Etowah | Alabama | 1055 | 28761 | 641 |
2372615 | 2372615 | 2022-04-04 | Etowah | Alabama | 1055 | 28775 | 641 |
2369362 | 2369362 | 2022-04-03 | Etowah | Alabama | 1055 | 28774 | 641 |
2366109 | 2366109 | 2022-04-02 | Etowah | Alabama | 1055 | 28774 | 641 |
2362856 | 2362856 | 2022-04-01 | Etowah | Alabama | 1055 | 28774 | 641 |
2353426 | 2353426 | 2022-03-29 | Leon | Florida | 12073 | 84804 | 641 |
2350174 | 2350174 | 2022-03-28 | Leon | Florida | 12073 | 84804 | 641 |
2346921 | 2346921 | 2022-03-27 | Leon | Florida | 12073 | 84804 | 641 |
2343668 | 2343668 | 2022-03-26 | Leon | Florida | 12073 | 84804 | 641 |
2340415 | 2340415 | 2022-03-25 | Leon | Florida | 12073 | 84804 | 641 |
2337162 | 2337162 | 2022-03-24 | Leon | Florida | 12073 | 84655 | 641 |
2261996 | 2261996 | 2022-03-01 | Baldwin | Alabama | 1003 | 54987 | 641 |
2243928 | 2243928 | 2022-02-23 | Harrison | Mississippi | 28047 | 53005 | 641 |
2226190 | 2226190 | 2022-02-17 | Racine | Wisconsin | 55101 | 55611 | 641 |
2215090 | 2215090 | 2022-02-14 | Dutchess | New York | 36027 | 62749 | 641 |
2199260 | 2199260 | 2022-02-09 | Franklin | Pennsylvania | 42055 | 39393 | 641 |
2180401 | 2180401 | 2022-02-03 | Chesterfield | Virginia | 51041 | 67826 | 641 |
2163933 | 2163933 | 2022-01-29 | Johnson | Texas | 48251 | 39608 | 641 |
2151012 | 2151012 | 2022-01-25 | Taylor | Texas | 48441 | 30130 | 641 |
2140705 | 2140705 | 2022-01-22 | Lackawanna | Pennsylvania | 42069 | 38617 | 641 |
2130464 | 2130464 | 2022-01-19 | Doña Ana | New Mexico | 35013 | 50955 | 641 |
2126519 | 2126519 | 2022-01-18 | Calcasieu | Louisiana | 22019 | 44686 | 641 |
2123267 | 2123267 | 2022-01-17 | Calcasieu | Louisiana | 22019 | 43421 | 641 |
2124076 | 2124076 | 2022-01-17 | Forsyth | North Carolina | 37067 | 71622 | 641 |
2120015 | 2120015 | 2022-01-16 | Calcasieu | Louisiana | 22019 | 43421 | 641 |
2120824 | 2120824 | 2022-01-16 | Forsyth | North Carolina | 37067 | 71622 | 641 |
2116763 | 2116763 | 2022-01-15 | Calcasieu | Louisiana | 22019 | 43421 | 641 |
2117572 | 2117572 | 2022-01-15 | Forsyth | North Carolina | 37067 | 71622 | 641 |
2113512 | 2113512 | 2022-01-14 | Calcasieu | Louisiana | 22019 | 43421 | 641 |
2114321 | 2114321 | 2022-01-14 | Forsyth | North Carolina | 37067 | 71622 | 641 |
2110260 | 2110260 | 2022-01-13 | Calcasieu | Louisiana | 22019 | 41198 | 641 |
2107009 | 2107009 | 2022-01-12 | Calcasieu | Louisiana | 22019 | 41198 | 641 |
2103758 | 2103758 | 2022-01-11 | Calcasieu | Louisiana | 22019 | 41198 | 641 |
2058424 | 2058424 | 2021-12-28 | Ottawa | Michigan | 26139 | 54992 | 641 |
2059275 | 2059275 | 2021-12-28 | Cleveland | Oklahoma | 40027 | 46549 | 641 |
2055175 | 2055175 | 2021-12-27 | Ottawa | Michigan | 26139 | 54992 | 641 |
2056026 | 2056026 | 2021-12-27 | Cleveland | Oklahoma | 40027 | 46549 | 641 |
2052450 | 2052450 | 2021-12-26 | San Juan | New Mexico | 35045 | 28128 | 641 |
2052777 | 2052777 | 2021-12-26 | Cleveland | Oklahoma | 40027 | 46549 | 641 |
2049200 | 2049200 | 2021-12-25 | San Juan | New Mexico | 35045 | 28128 | 641 |
2049527 | 2049527 | 2021-12-25 | Cleveland | Oklahoma | 40027 | 46549 | 641 |
2045950 | 2045950 | 2021-12-24 | San Juan | New Mexico | 35045 | 28128 | 641 |
2046277 | 2046277 | 2021-12-24 | Cleveland | Oklahoma | 40027 | 46549 | 641 |
2042700 | 2042700 | 2021-12-23 | San Juan | New Mexico | 35045 | 28128 | 641 |
2043027 | 2043027 | 2021-12-23 | Cleveland | Oklahoma | 40027 | 46549 | 641 |
2039778 | 2039778 | 2021-12-22 | Cleveland | Oklahoma | 40027 | 46549 | 641 |
2035692 | 2035692 | 2021-12-21 | Anoka | Minnesota | 27003 | 69548 | 641 |
2031326 | 2031326 | 2021-12-20 | Monterey | California | 6053 | 54003 | 641 |
2028075 | 2028075 | 2021-12-19 | Monterey | California | 6053 | 53830 | 641 |
2024824 | 2024824 | 2021-12-18 | Monterey | California | 6053 | 53830 | 641 |
2021573 | 2021573 | 2021-12-17 | Monterey | California | 6053 | 53830 | 641 |
1969415 | 1969415 | 2021-12-01 | Tuscaloosa | Alabama | 1125 | 36077 | 641 |
1966165 | 1966165 | 2021-11-30 | Tuscaloosa | Alabama | 1125 | 36052 | 641 |
1962913 | 1962913 | 2021-11-29 | Tuscaloosa | Alabama | 1125 | 36022 | 641 |
1964291 | 1964291 | 2021-11-29 | Hinds | Mississippi | 28049 | 32638 | 641 |
1959662 | 1959662 | 2021-11-28 | Tuscaloosa | Alabama | 1125 | 36017 | 641 |
1961040 | 1961040 | 2021-11-28 | Hinds | Mississippi | 28049 | 32556 | 641 |
1956411 | 1956411 | 2021-11-27 | Tuscaloosa | Alabama | 1125 | 36009 | 641 |
1957789 | 1957789 | 2021-11-27 | Hinds | Mississippi | 28049 | 32556 | 641 |
1953160 | 1953160 | 2021-11-26 | Tuscaloosa | Alabama | 1125 | 35996 | 641 |
1954538 | 1954538 | 2021-11-26 | Hinds | Mississippi | 28049 | 32556 | 641 |
1949909 | 1949909 | 2021-11-25 | Tuscaloosa | Alabama | 1125 | 35996 | 641 |
1951287 | 1951287 | 2021-11-25 | Hinds | Mississippi | 28049 | 32556 | 641 |
1948036 | 1948036 | 2021-11-24 | Hinds | Mississippi | 28049 | 32556 | 641 |
1920995 | 1920995 | 2021-11-16 | Bibb | Georgia | 13021 | 25941 | 641 |
1895092 | 1895092 | 2021-11-08 | Muscogee | Georgia | 13215 | 24285 | 641 |
1895374 | 1895374 | 2021-11-08 | St. Joseph | Indiana | 18141 | 45818 | 641 |
1891842 | 1891842 | 2021-11-07 | Muscogee | Georgia | 13215 | 24284 | 641 |
1892124 | 1892124 | 2021-11-07 | St. Joseph | Indiana | 18141 | 45559 | 641 |
1888592 | 1888592 | 2021-11-06 | Muscogee | Georgia | 13215 | 24284 | 641 |
1888874 | 1888874 | 2021-11-06 | St. Joseph | Indiana | 18141 | 45559 | 641 |
1885342 | 1885342 | 2021-11-05 | Muscogee | Georgia | 13215 | 24284 | 641 |
1885624 | 1885624 | 2021-11-05 | St. Joseph | Indiana | 18141 | 45559 | 641 |
1882056 | 1882056 | 2021-11-04 | Hall | Georgia | 13139 | 38411 | 641 |
1882093 | 1882093 | 2021-11-04 | Muscogee | Georgia | 13215 | 24268 | 641 |
1882375 | 1882375 | 2021-11-04 | St. Joseph | Indiana | 18141 | 45426 | 641 |
1878807 | 1878807 | 2021-11-03 | Hall | Georgia | 13139 | 38383 | 641 |
1879126 | 1879126 | 2021-11-03 | St. Joseph | Indiana | 18141 | 45329 | 641 |
1875558 | 1875558 | 2021-11-02 | Hall | Georgia | 13139 | 38350 | 641 |
1825673 | 1825673 | 2021-10-17 | Hamilton | Tennessee | 47065 | 63193 | 641 |
1822424 | 1822424 | 2021-10-16 | Hamilton | Tennessee | 47065 | 63193 | 641 |
1819175 | 1819175 | 2021-10-15 | Hamilton | Tennessee | 47065 | 63193 | 641 |
1804032 | 1804032 | 2021-10-11 | Chatham | Georgia | 13051 | 38145 | 641 |
1800783 | 1800783 | 2021-10-10 | Chatham | Georgia | 13051 | 38145 | 641 |
1797534 | 1797534 | 2021-10-09 | Chatham | Georgia | 13051 | 38145 | 641 |
1794285 | 1794285 | 2021-10-08 | Chatham | Georgia | 13051 | 38145 | 641 |
1790846 | 1790846 | 2021-10-07 | San Francisco | California | 6075 | 53453 | 641 |
1787597 | 1787597 | 2021-10-06 | San Francisco | California | 6075 | 53355 | 641 |
1761487 | 1761487 | 2021-09-28 | Yavapai | Arizona | 4025 | 25894 | 641 |
1650122 | 1650122 | 2021-08-24 | Horry | South Carolina | 45051 | 48549 | 641 |
1624485 | 1624485 | 2021-08-16 | Montgomery | Texas | 48339 | 64472 | 641 |
1559706 | 1559706 | 2021-07-27 | Henrico | Virginia | 51087 | 26396 | 641 |
1556459 | 1556459 | 2021-07-26 | Henrico | Virginia | 51087 | 26378 | 641 |
1553212 | 1553212 | 2021-07-25 | Henrico | Virginia | 51087 | 26273 | 641 |
1549965 | 1549965 | 2021-07-24 | Henrico | Virginia | 51087 | 26273 | 641 |
1546718 | 1546718 | 2021-07-23 | Henrico | Virginia | 51087 | 26273 | 641 |
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);