ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
155 rows where deaths = 759 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 27
- Pennsylvania 25
- Florida 13
- Michigan 12
- Colorado 10
- Louisiana 10
- Virginia 10
- Kansas 9
- North Carolina 8
- Massachusetts 6
- Texas 6
- Wisconsin 6
- Arizona 5
- California 4
- Georgia 4
- Minnesota 4
- South Carolina 4
- Washington 4
- New Jersey 3
- Illinois 2
- Indiana 2
- Tennessee 2
- Alabama 1
- Delaware 1
- Maryland 1
- Mississippi 1
- New Mexico 1
- Ohio 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2492097 | 2492097 | 2022-05-10 | Erie | Pennsylvania | 42049 | 57747 | 759 |
2488839 | 2488839 | 2022-05-09 | Erie | Pennsylvania | 42049 | 57747 | 759 |
2485582 | 2485582 | 2022-05-08 | Erie | Pennsylvania | 42049 | 57747 | 759 |
2482324 | 2482324 | 2022-05-07 | Erie | Pennsylvania | 42049 | 57747 | 759 |
2479066 | 2479066 | 2022-05-06 | Erie | Pennsylvania | 42049 | 57747 | 759 |
2475808 | 2475808 | 2022-05-05 | Erie | Pennsylvania | 42049 | 57747 | 759 |
2472551 | 2472551 | 2022-05-04 | Erie | Pennsylvania | 42049 | 57747 | 759 |
2473214 | 2473214 | 2022-05-04 | Chesterfield | Virginia | 51041 | 74435 | 759 |
2469958 | 2469958 | 2022-05-03 | Chesterfield | Virginia | 51041 | 74275 | 759 |
2466039 | 2466039 | 2022-05-02 | Erie | Pennsylvania | 42049 | 57660 | 759 |
2466702 | 2466702 | 2022-05-02 | Chesterfield | Virginia | 51041 | 74217 | 759 |
2462784 | 2462784 | 2022-05-01 | Erie | Pennsylvania | 42049 | 57638 | 759 |
2463447 | 2463447 | 2022-05-01 | Chesterfield | Virginia | 51041 | 74033 | 759 |
2459528 | 2459528 | 2022-04-30 | Erie | Pennsylvania | 42049 | 57602 | 759 |
2460191 | 2460191 | 2022-04-30 | Chesterfield | Virginia | 51041 | 74033 | 759 |
2456272 | 2456272 | 2022-04-29 | Erie | Pennsylvania | 42049 | 57558 | 759 |
2456935 | 2456935 | 2022-04-29 | Chesterfield | Virginia | 51041 | 74033 | 759 |
2452546 | 2452546 | 2022-04-28 | Doña Ana | New Mexico | 35013 | 63577 | 759 |
2453016 | 2453016 | 2022-04-28 | Erie | Pennsylvania | 42049 | 57517 | 759 |
2453679 | 2453679 | 2022-04-28 | Chesterfield | Virginia | 51041 | 73925 | 759 |
2449760 | 2449760 | 2022-04-27 | Erie | Pennsylvania | 42049 | 57477 | 759 |
2450423 | 2450423 | 2022-04-27 | Chesterfield | Virginia | 51041 | 73810 | 759 |
2446503 | 2446503 | 2022-04-26 | Erie | Pennsylvania | 42049 | 57439 | 759 |
2447166 | 2447166 | 2022-04-26 | Chesterfield | Virginia | 51041 | 73721 | 759 |
2443911 | 2443911 | 2022-04-25 | Chesterfield | Virginia | 51041 | 73623 | 759 |
2314431 | 2314431 | 2022-03-17 | Bibb | Georgia | 13021 | 36869 | 759 |
2307854 | 2307854 | 2022-03-15 | Charlotte | Florida | 12015 | 35466 | 759 |
2304603 | 2304603 | 2022-03-14 | Charlotte | Florida | 12015 | 35466 | 759 |
2301351 | 2301351 | 2022-03-13 | Charlotte | Florida | 12015 | 35466 | 759 |
2298099 | 2298099 | 2022-03-12 | Charlotte | Florida | 12015 | 35466 | 759 |
2294847 | 2294847 | 2022-03-11 | Charlotte | Florida | 12015 | 35466 | 759 |
2291595 | 2291595 | 2022-03-10 | Charlotte | Florida | 12015 | 35336 | 759 |
2292611 | 2292611 | 2022-03-10 | Dakota | Minnesota | 27037 | 108708 | 759 |
2288343 | 2288343 | 2022-03-09 | Charlotte | Florida | 12015 | 35336 | 759 |
2289359 | 2289359 | 2022-03-09 | Dakota | Minnesota | 27037 | 108676 | 759 |
2286108 | 2286108 | 2022-03-08 | Dakota | Minnesota | 27037 | 108626 | 759 |
2281325 | 2281325 | 2022-03-06 | Clark | Washington | 53011 | 84903 | 759 |
2278072 | 2278072 | 2022-03-05 | Clark | Washington | 53011 | 84903 | 759 |
2274819 | 2274819 | 2022-03-04 | Clark | Washington | 53011 | 84903 | 759 |
2259432 | 2259432 | 2022-02-28 | St. Clair | Illinois | 17163 | 68629 | 759 |
2260184 | 2260184 | 2022-02-28 | Hinds | Mississippi | 28049 | 51884 | 759 |
2257432 | 2257432 | 2022-02-27 | Forsyth | North Carolina | 37067 | 91094 | 759 |
2254181 | 2254181 | 2022-02-26 | Forsyth | North Carolina | 37067 | 91094 | 759 |
2250930 | 2250930 | 2022-02-25 | Forsyth | North Carolina | 37067 | 91094 | 759 |
2241179 | 2241179 | 2022-02-22 | Gaston | North Carolina | 37071 | 64353 | 759 |
2230798 | 2230798 | 2022-02-19 | Ottawa | Michigan | 26139 | 73433 | 759 |
2227547 | 2227547 | 2022-02-18 | Ottawa | Michigan | 26139 | 73433 | 759 |
2223279 | 2223279 | 2022-02-17 | Pueblo | Colorado | 8101 | 43519 | 759 |
2224296 | 2224296 | 2022-02-17 | Ottawa | Michigan | 26139 | 73433 | 759 |
2221045 | 2221045 | 2022-02-16 | Ottawa | Michigan | 26139 | 73433 | 759 |
2217810 | 2217810 | 2022-02-15 | Anoka | Minnesota | 27003 | 96536 | 759 |
2178767 | 2178767 | 2022-02-03 | St. Clair | Michigan | 26147 | 38986 | 759 |
2175515 | 2175515 | 2022-02-02 | St. Clair | Michigan | 26147 | 38914 | 759 |
2163930 | 2163930 | 2022-01-29 | Jefferson | Texas | 48245 | 40407 | 759 |
2155085 | 2155085 | 2022-01-27 | Chatham | Georgia | 13051 | 57373 | 759 |
2134604 | 2134604 | 2022-01-20 | Galveston | Texas | 48167 | 85366 | 759 |
2111769 | 2111769 | 2022-01-13 | Bell | Texas | 48027 | 46969 | 759 |
2083222 | 2083222 | 2022-01-05 | Navajo | Arizona | 4017 | 27555 | 759 |
2060871 | 2060871 | 2021-12-29 | Richmond | Georgia | 13245 | 37184 | 759 |
2003655 | 2003655 | 2021-12-11 | Gloucester | New Jersey | 34015 | 43075 | 759 |
1966075 | 1966075 | 2021-11-29 | Waukesha | Wisconsin | 55133 | 69038 | 759 |
1962823 | 1962823 | 2021-11-28 | Waukesha | Wisconsin | 55133 | 69028 | 759 |
1959572 | 1959572 | 2021-11-27 | Waukesha | Wisconsin | 55133 | 69028 | 759 |
1956321 | 1956321 | 2021-11-26 | Waukesha | Wisconsin | 55133 | 69028 | 759 |
1953070 | 1953070 | 2021-11-25 | Waukesha | Wisconsin | 55133 | 69028 | 759 |
1949819 | 1949819 | 2021-11-24 | Waukesha | Wisconsin | 55133 | 68707 | 759 |
1927514 | 1927514 | 2021-11-18 | Clayton | Georgia | 13063 | 39887 | 759 |
1881647 | 1881647 | 2021-11-04 | Montgomery | Alabama | 1101 | 34289 | 759 |
1858061 | 1858061 | 2021-10-27 | Richland | South Carolina | 45079 | 68801 | 759 |
1832446 | 1832446 | 2021-10-19 | Smith | Texas | 48423 | 36127 | 759 |
1800567 | 1800567 | 2021-10-10 | Imperial | California | 6025 | 35225 | 759 |
1797318 | 1797318 | 2021-10-09 | Imperial | California | 6025 | 35225 | 759 |
1794069 | 1794069 | 2021-10-08 | Imperial | California | 6025 | 35225 | 759 |
1790821 | 1790821 | 2021-10-07 | Imperial | California | 6025 | 35166 | 759 |
1770188 | 1770188 | 2021-09-30 | Northampton | Pennsylvania | 42095 | 42137 | 759 |
1725475 | 1725475 | 2021-09-16 | Pierce | Washington | 53053 | 78096 | 759 |
1718467 | 1718467 | 2021-09-14 | Knox | Tennessee | 47093 | 69460 | 759 |
1623687 | 1623687 | 2021-08-16 | Wake | North Carolina | 37183 | 100235 | 759 |
1620440 | 1620440 | 2021-08-15 | Wake | North Carolina | 37183 | 99719 | 759 |
1617192 | 1617192 | 2021-08-14 | Wake | North Carolina | 37183 | 99719 | 759 |
1613944 | 1613944 | 2021-08-13 | Wake | North Carolina | 37183 | 99719 | 759 |
1498380 | 1498380 | 2021-07-09 | Mohave | Arizona | 4015 | 24154 | 759 |
1495133 | 1495133 | 2021-07-08 | Mohave | Arizona | 4015 | 24080 | 759 |
1495274 | 1495274 | 2021-07-08 | Adams | Colorado | 8001 | 62296 | 759 |
1491886 | 1491886 | 2021-07-07 | Mohave | Arizona | 4015 | 24013 | 759 |
1492028 | 1492028 | 2021-07-07 | Adams | Colorado | 8001 | 62282 | 759 |
1488639 | 1488639 | 2021-07-06 | Mohave | Arizona | 4015 | 23985 | 759 |
1488781 | 1488781 | 2021-07-06 | Adams | Colorado | 8001 | 62235 | 759 |
1485534 | 1485534 | 2021-07-05 | Adams | Colorado | 8001 | 62222 | 759 |
1482288 | 1482288 | 2021-07-04 | Adams | Colorado | 8001 | 62209 | 759 |
1437734 | 1437734 | 2021-06-20 | Caddo | Louisiana | 22017 | 27089 | 759 |
1434487 | 1434487 | 2021-06-19 | Caddo | Louisiana | 22017 | 27089 | 759 |
1431241 | 1431241 | 2021-06-18 | Caddo | Louisiana | 22017 | 27089 | 759 |
1427996 | 1427996 | 2021-06-17 | Caddo | Louisiana | 22017 | 27060 | 759 |
1424751 | 1424751 | 2021-06-16 | Caddo | Louisiana | 22017 | 27041 | 759 |
1421503 | 1421503 | 2021-06-15 | Caddo | Louisiana | 22017 | 27023 | 759 |
1418258 | 1418258 | 2021-06-14 | Caddo | Louisiana | 22017 | 26972 | 759 |
1415012 | 1415012 | 2021-06-13 | Caddo | Louisiana | 22017 | 26944 | 759 |
1411767 | 1411767 | 2021-06-12 | Caddo | Louisiana | 22017 | 26944 | 759 |
1408522 | 1408522 | 2021-06-11 | Caddo | Louisiana | 22017 | 26944 | 759 |
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);