ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
153 rows where deaths = 645 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Michigan 17
- Florida 15
- California 12
- Pennsylvania 10
- Delaware 9
- New York 9
- Texas 8
- New Jersey 7
- Alabama 5
- Massachusetts 5
- Missouri 5
- Ohio 5
- Washington 5
- Indiana 4
- Louisiana 4
- Tennessee 4
- Maryland 3
- New Hampshire 3
- Wisconsin 3
- Arizona 2
- Arkansas 2
- Georgia 2
- Illinois 2
- Mississippi 2
- Nevada 2
- South Carolina 2
- District of Columbia 1
- Nebraska 1
- North Carolina 1
- Oklahoma 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2460806 | 2460806 | 2022-05-01 | Kent | Delaware | 10001 | 50914 | 645 |
2457550 | 2457550 | 2022-04-30 | Kent | Delaware | 10001 | 50914 | 645 |
2454294 | 2454294 | 2022-04-29 | Kent | Delaware | 10001 | 50914 | 645 |
2451038 | 2451038 | 2022-04-28 | Kent | Delaware | 10001 | 50861 | 645 |
2447782 | 2447782 | 2022-04-27 | Kent | Delaware | 10001 | 50816 | 645 |
2444526 | 2444526 | 2022-04-26 | Kent | Delaware | 10001 | 50776 | 645 |
2441270 | 2441270 | 2022-04-25 | Kent | Delaware | 10001 | 50752 | 645 |
2438014 | 2438014 | 2022-04-24 | Kent | Delaware | 10001 | 50702 | 645 |
2434758 | 2434758 | 2022-04-23 | Kent | Delaware | 10001 | 50702 | 645 |
2422722 | 2422722 | 2022-04-19 | Muskegon | Michigan | 26121 | 41807 | 645 |
2419466 | 2419466 | 2022-04-18 | Muskegon | Michigan | 26121 | 41807 | 645 |
2416210 | 2416210 | 2022-04-17 | Muskegon | Michigan | 26121 | 41807 | 645 |
2412954 | 2412954 | 2022-04-16 | Muskegon | Michigan | 26121 | 41807 | 645 |
2409698 | 2409698 | 2022-04-15 | Muskegon | Michigan | 26121 | 41807 | 645 |
2405163 | 2405163 | 2022-04-14 | Etowah | Alabama | 1055 | 28754 | 645 |
2406442 | 2406442 | 2022-04-14 | Muskegon | Michigan | 26121 | 41807 | 645 |
2403186 | 2403186 | 2022-04-13 | Muskegon | Michigan | 26121 | 41807 | 645 |
2353420 | 2353420 | 2022-03-29 | Indian River | Florida | 12061 | 32366 | 645 |
2350168 | 2350168 | 2022-03-28 | Indian River | Florida | 12061 | 32366 | 645 |
2346915 | 2346915 | 2022-03-27 | Indian River | Florida | 12061 | 32366 | 645 |
2343662 | 2343662 | 2022-03-26 | Indian River | Florida | 12061 | 32366 | 645 |
2340409 | 2340409 | 2022-03-25 | Indian River | Florida | 12061 | 32366 | 645 |
2337156 | 2337156 | 2022-03-24 | Indian River | Florida | 12061 | 32248 | 645 |
2339135 | 2339135 | 2022-03-24 | Washington | Pennsylvania | 42125 | 50685 | 645 |
2335881 | 2335881 | 2022-03-23 | Washington | Pennsylvania | 42125 | 50669 | 645 |
2332627 | 2332627 | 2022-03-22 | Washington | Pennsylvania | 42125 | 50653 | 645 |
2314782 | 2314782 | 2022-03-17 | Madison | Indiana | 18095 | 32625 | 645 |
2311529 | 2311529 | 2022-03-16 | Madison | Indiana | 18095 | 32614 | 645 |
2308276 | 2308276 | 2022-03-15 | Madison | Indiana | 18095 | 32608 | 645 |
2305025 | 2305025 | 2022-03-14 | Madison | Indiana | 18095 | 32604 | 645 |
2268499 | 2268499 | 2022-03-03 | Baldwin | Alabama | 1003 | 55061 | 645 |
2260183 | 2260183 | 2022-02-28 | Harrison | Mississippi | 28047 | 53152 | 645 |
2261362 | 2261362 | 2022-02-28 | Unknown | Tennessee | 24982 | 645 | |
2255111 | 2255111 | 2022-02-26 | Wichita | Texas | 48485 | 33864 | 645 |
2245696 | 2245696 | 2022-02-23 | Racine | Wisconsin | 55101 | 55741 | 645 |
2241098 | 2241098 | 2022-02-22 | Dutchess | New York | 36027 | 63010 | 645 |
2242445 | 2242445 | 2022-02-22 | Racine | Wisconsin | 55101 | 55718 | 645 |
2237847 | 2237847 | 2022-02-21 | Dutchess | New York | 36027 | 62981 | 645 |
2234596 | 2234596 | 2022-02-20 | Dutchess | New York | 36027 | 62966 | 645 |
2231345 | 2231345 | 2022-02-19 | Dutchess | New York | 36027 | 62941 | 645 |
2228094 | 2228094 | 2022-02-18 | Dutchess | New York | 36027 | 62902 | 645 |
2228852 | 2228852 | 2022-02-18 | Unknown | Tennessee | 28218 | 645 | |
2211207 | 2211207 | 2022-02-13 | Barnstable | Massachusetts | 25001 | 33838 | 645 |
2207954 | 2207954 | 2022-02-12 | Barnstable | Massachusetts | 25001 | 33838 | 645 |
2204701 | 2204701 | 2022-02-11 | Barnstable | Massachusetts | 25001 | 33838 | 645 |
2202514 | 2202514 | 2022-02-10 | Franklin | Pennsylvania | 42055 | 39471 | 645 |
2167283 | 2167283 | 2022-01-30 | Taylor | Texas | 48441 | 31050 | 645 |
2164028 | 2164028 | 2022-01-29 | Taylor | Texas | 48441 | 31050 | 645 |
2146044 | 2146044 | 2022-01-24 | Calcasieu | Louisiana | 22019 | 46676 | 645 |
2130912 | 2130912 | 2022-01-19 | Beaver | Pennsylvania | 42007 | 35004 | 645 |
2127328 | 2127328 | 2022-01-18 | Forsyth | North Carolina | 37067 | 76196 | 645 |
2074964 | 2074964 | 2022-01-02 | St. Louis city | Missouri | 29510 | 38978 | 645 |
2060573 | 2060573 | 2021-12-29 | Monterey | California | 6053 | 54595 | 645 |
2057324 | 2057324 | 2021-12-28 | Monterey | California | 6053 | 54540 | 645 |
1998667 | 1998667 | 2021-12-10 | Tuscaloosa | Alabama | 1125 | 36310 | 645 |
1993543 | 1993543 | 2021-12-08 | Hinds | Mississippi | 28049 | 32859 | 645 |
1987711 | 1987711 | 2021-12-06 | Lorain | Ohio | 39093 | 42941 | 645 |
1984461 | 1984461 | 2021-12-05 | Lorain | Ohio | 39093 | 42754 | 645 |
1981211 | 1981211 | 2021-12-04 | Lorain | Ohio | 39093 | 42555 | 645 |
1977961 | 1977961 | 2021-12-03 | Lorain | Ohio | 39093 | 42330 | 645 |
1929379 | 1929379 | 2021-11-18 | Cumberland | Pennsylvania | 42041 | 30216 | 645 |
1924244 | 1924244 | 2021-11-17 | Bibb | Georgia | 13021 | 25957 | 645 |
1914304 | 1914304 | 2021-11-14 | Merced | California | 6047 | 44566 | 645 |
1911054 | 1911054 | 2021-11-13 | Merced | California | 6047 | 44566 | 645 |
1907805 | 1907805 | 2021-11-12 | Merced | California | 6047 | 44566 | 645 |
1861140 | 1861140 | 2021-10-28 | Dauphin | Pennsylvania | 42043 | 34746 | 645 |
1849795 | 1849795 | 2021-10-25 | St. Clair | Illinois | 17163 | 40361 | 645 |
1833083 | 1833083 | 2021-10-20 | San Francisco | California | 6075 | 54302 | 645 |
1832171 | 1832171 | 2021-10-19 | Hamilton | Tennessee | 47065 | 63454 | 645 |
1823336 | 1823336 | 2021-10-17 | San Francisco | California | 6075 | 54034 | 645 |
1820087 | 1820087 | 2021-10-16 | San Francisco | California | 6075 | 54034 | 645 |
1816838 | 1816838 | 2021-10-15 | San Francisco | California | 6075 | 54034 | 645 |
1807283 | 1807283 | 2021-10-12 | Chatham | Georgia | 13051 | 38248 | 645 |
1780984 | 1780984 | 2021-10-04 | Yavapai | Arizona | 4025 | 26442 | 645 |
1782420 | 1782420 | 2021-10-04 | Jackson | Missouri | 29095 | 54203 | 645 |
1777734 | 1777734 | 2021-10-03 | Yavapai | Arizona | 4025 | 26387 | 645 |
1779170 | 1779170 | 2021-10-03 | Jackson | Missouri | 29095 | 54147 | 645 |
1775920 | 1775920 | 2021-10-02 | Jackson | Missouri | 29095 | 54069 | 645 |
1772670 | 1772670 | 2021-10-01 | Jackson | Missouri | 29095 | 53940 | 645 |
1767053 | 1767053 | 2021-09-29 | Charleston | South Carolina | 45019 | 62799 | 645 |
1764214 | 1764214 | 2021-09-28 | Smith | Texas | 48423 | 34432 | 645 |
1760383 | 1760383 | 2021-09-27 | Multnomah | Oregon | 41051 | 52543 | 645 |
1744334 | 1744334 | 2021-09-22 | Lexington | South Carolina | 45063 | 51010 | 645 |
1736046 | 1736046 | 2021-09-20 | Madison | Illinois | 17119 | 37960 | 645 |
1719191 | 1719191 | 2021-09-15 | Montgomery | Alabama | 1101 | 32249 | 645 |
1717065 | 1717065 | 2021-09-14 | St. Tammany | Louisiana | 22103 | 41470 | 645 |
1657265 | 1657265 | 2021-08-26 | Snohomish | Washington | 53061 | 49615 | 645 |
1648995 | 1648995 | 2021-08-24 | Saginaw | Michigan | 26145 | 23554 | 645 |
1650666 | 1650666 | 2021-08-24 | Henrico | Virginia | 51087 | 28592 | 645 |
1645746 | 1645746 | 2021-08-23 | Saginaw | Michigan | 26145 | 23554 | 645 |
1642497 | 1642497 | 2021-08-22 | Saginaw | Michigan | 26145 | 23459 | 645 |
1639247 | 1639247 | 2021-08-21 | Saginaw | Michigan | 26145 | 23459 | 645 |
1635997 | 1635997 | 2021-08-20 | Saginaw | Michigan | 26145 | 23459 | 645 |
1632747 | 1632747 | 2021-08-19 | Saginaw | Michigan | 26145 | 23358 | 645 |
1629500 | 1629500 | 2021-08-18 | Saginaw | Michigan | 26145 | 23358 | 645 |
1630979 | 1630979 | 2021-08-18 | Montgomery | Texas | 48339 | 66368 | 645 |
1626253 | 1626253 | 2021-08-17 | Saginaw | Michigan | 26145 | 23282 | 645 |
1623006 | 1623006 | 2021-08-16 | Saginaw | Michigan | 26145 | 23282 | 645 |
1559942 | 1559942 | 2021-07-27 | Waukesha | Wisconsin | 55133 | 49796 | 645 |
1483840 | 1483840 | 2021-07-04 | Gloucester | New Jersey | 34015 | 30746 | 645 |
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);