ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
127 rows where deaths = 827 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 30
- Pennsylvania 17
- New Jersey 11
- Texas 11
- Missouri 9
- South Carolina 8
- Arizona 7
- Florida 7
- Ohio 6
- Georgia 5
- Maryland 4
- North Carolina 4
- Utah 4
- Arkansas 3
- California 3
- Indiana 3
- Kansas 3
- Louisiana 3
- Massachusetts 3
- Washington 3
- Colorado 2
- Illinois 2
- Alabama 1
- Delaware 1
- Michigan 1
- Minnesota 1
- Nebraska 1
- New Hampshire 1
- New York 1
- Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499900 | 2499900 | 2022-05-13 | Bay | Florida | 12005 | 45926 | 827 |
2496642 | 2496642 | 2022-05-12 | Bay | Florida | 12005 | 45926 | 827 |
2493384 | 2493384 | 2022-05-11 | Bay | Florida | 12005 | 45926 | 827 |
2360034 | 2360034 | 2022-03-31 | Hall | Georgia | 13139 | 53740 | 827 |
2355819 | 2355819 | 2022-03-29 | Jefferson | Texas | 48245 | 46345 | 827 |
2330410 | 2330410 | 2022-03-22 | Benton | Arkansas | 5007 | 66493 | 827 |
2327158 | 2327158 | 2022-03-21 | Benton | Arkansas | 5007 | 66479 | 827 |
2323905 | 2323905 | 2022-03-20 | Benton | Arkansas | 5007 | 66436 | 827 |
2281925 | 2281925 | 2022-03-07 | Chatham | Georgia | 13051 | 61580 | 827 |
2269672 | 2269672 | 2022-03-03 | St. Tammany | Louisiana | 22103 | 71757 | 827 |
2264704 | 2264704 | 2022-03-01 | Galveston | Texas | 48167 | 94650 | 827 |
2257943 | 2257943 | 2022-02-27 | Lexington | South Carolina | 45063 | 94986 | 827 |
2254692 | 2254692 | 2022-02-26 | Lexington | South Carolina | 45063 | 94986 | 827 |
2251441 | 2251441 | 2022-02-25 | Lexington | South Carolina | 45063 | 94986 | 827 |
2220390 | 2220390 | 2022-02-16 | Madison | Illinois | 17119 | 69154 | 827 |
2217259 | 2217259 | 2022-02-15 | St. Joseph | Indiana | 18141 | 69825 | 827 |
2197014 | 2197014 | 2022-02-09 | Montgomery | Alabama | 1101 | 53528 | 827 |
2196499 | 2196499 | 2022-02-08 | McLennan | Texas | 48309 | 54514 | 827 |
2164855 | 2164855 | 2022-01-30 | Clayton | Georgia | 13063 | 61143 | 827 |
2161600 | 2161600 | 2022-01-29 | Clayton | Georgia | 13063 | 61143 | 827 |
2158344 | 2158344 | 2022-01-28 | Clayton | Georgia | 13063 | 61143 | 827 |
2156457 | 2156457 | 2022-01-27 | Hillsborough | New Hampshire | 33011 | 88043 | 827 |
2107765 | 2107765 | 2022-01-12 | Rockland | New York | 36087 | 80991 | 827 |
2098546 | 2098546 | 2022-01-09 | Anderson | South Carolina | 45007 | 42592 | 827 |
2095294 | 2095294 | 2022-01-08 | Anderson | South Carolina | 45007 | 42592 | 827 |
2092042 | 2092042 | 2022-01-07 | Anderson | South Carolina | 45007 | 42592 | 827 |
2088790 | 2088790 | 2022-01-06 | Anderson | South Carolina | 45007 | 42062 | 827 |
2081659 | 2081659 | 2022-01-04 | Atlantic | New Jersey | 34001 | 51387 | 827 |
2042974 | 2042974 | 2021-12-23 | Mahoning | Ohio | 39099 | 38965 | 827 |
2039725 | 2039725 | 2021-12-22 | Mahoning | Ohio | 39099 | 38649 | 827 |
2036475 | 2036475 | 2021-12-21 | Mahoning | Ohio | 39099 | 38448 | 827 |
2034335 | 2034335 | 2021-12-20 | Waukesha | Wisconsin | 55133 | 74733 | 827 |
2030954 | 2030954 | 2021-12-19 | Snohomish | Washington | 53061 | 75153 | 827 |
2027703 | 2027703 | 2021-12-18 | Snohomish | Washington | 53061 | 75153 | 827 |
2024452 | 2024452 | 2021-12-17 | Snohomish | Washington | 53061 | 75153 | 827 |
1994941 | 1994941 | 2021-12-08 | Smith | Texas | 48423 | 37309 | 827 |
1991690 | 1991690 | 2021-12-07 | Smith | Texas | 48423 | 37306 | 827 |
1985711 | 1985711 | 2021-12-06 | Yavapai | Arizona | 4025 | 33627 | 827 |
1988439 | 1988439 | 2021-12-06 | Smith | Texas | 48423 | 37283 | 827 |
1982461 | 1982461 | 2021-12-05 | Yavapai | Arizona | 4025 | 33498 | 827 |
1985189 | 1985189 | 2021-12-05 | Smith | Texas | 48423 | 37263 | 827 |
1981939 | 1981939 | 2021-12-04 | Smith | Texas | 48423 | 37260 | 827 |
1977388 | 1977388 | 2021-12-03 | Greene | Missouri | 29077 | 46785 | 827 |
1974138 | 1974138 | 2021-12-02 | Greene | Missouri | 29077 | 46657 | 827 |
1941639 | 1941639 | 2021-11-22 | Jackson | Missouri | 29095 | 58436 | 827 |
1938380 | 1938380 | 2021-11-21 | Greene | Missouri | 29077 | 45806 | 827 |
1935130 | 1935130 | 2021-11-20 | Greene | Missouri | 29077 | 45806 | 827 |
1931880 | 1931880 | 2021-11-19 | Greene | Missouri | 29077 | 45806 | 827 |
1873400 | 1873400 | 2021-11-01 | Kansas City | Missouri | 63761 | 827 | |
1870151 | 1870151 | 2021-10-31 | Kansas City | Missouri | 63718 | 827 | |
1866902 | 1866902 | 2021-10-30 | Kansas City | Missouri | 63647 | 827 | |
1857303 | 1857303 | 2021-10-27 | Douglas | Nebraska | 31055 | 86973 | 827 |
1849813 | 1849813 | 2021-10-25 | Allen | Indiana | 18003 | 58313 | 827 |
1760075 | 1760075 | 2021-09-27 | Guilford | North Carolina | 37081 | 63019 | 827 |
1756827 | 1756827 | 2021-09-26 | Guilford | North Carolina | 37081 | 62241 | 827 |
1753579 | 1753579 | 2021-09-25 | Guilford | North Carolina | 37081 | 62241 | 827 |
1750331 | 1750331 | 2021-09-24 | Guilford | North Carolina | 37081 | 62241 | 827 |
1664861 | 1664861 | 2021-08-29 | Johnson | Kansas | 20091 | 68959 | 827 |
1661613 | 1661613 | 2021-08-28 | Johnson | Kansas | 20091 | 68959 | 827 |
1658365 | 1658365 | 2021-08-27 | Johnson | Kansas | 20091 | 68959 | 827 |
1644707 | 1644707 | 2021-08-23 | Jefferson | Colorado | 8059 | 52599 | 827 |
1634785 | 1634785 | 2021-08-20 | Mohave | Arizona | 4015 | 27290 | 827 |
1623970 | 1623970 | 2021-08-16 | Chester | Pennsylvania | 42029 | 42388 | 827 |
1620723 | 1620723 | 2021-08-15 | Chester | Pennsylvania | 42029 | 42309 | 827 |
1617475 | 1617475 | 2021-08-14 | Chester | Pennsylvania | 42029 | 42213 | 827 |
1614227 | 1614227 | 2021-08-13 | Chester | Pennsylvania | 42029 | 42128 | 827 |
1610978 | 1610978 | 2021-08-12 | Chester | Pennsylvania | 42029 | 42026 | 827 |
1607730 | 1607730 | 2021-08-11 | Chester | Pennsylvania | 42029 | 41937 | 827 |
1604481 | 1604481 | 2021-08-10 | Chester | Pennsylvania | 42029 | 41871 | 827 |
1600109 | 1600109 | 2021-08-09 | Orleans | Louisiana | 22071 | 38451 | 827 |
1601232 | 1601232 | 2021-08-09 | Chester | Pennsylvania | 42029 | 41791 | 827 |
1597984 | 1597984 | 2021-08-08 | Chester | Pennsylvania | 42029 | 41686 | 827 |
1594735 | 1594735 | 2021-08-07 | Chester | Pennsylvania | 42029 | 41686 | 827 |
1591486 | 1591486 | 2021-08-06 | Chester | Pennsylvania | 42029 | 41610 | 827 |
1588237 | 1588237 | 2021-08-05 | Chester | Pennsylvania | 42029 | 41541 | 827 |
1584987 | 1584987 | 2021-08-04 | Chester | Pennsylvania | 42029 | 41470 | 827 |
1474410 | 1474410 | 2021-07-01 | Lucas | Ohio | 39095 | 43451 | 827 |
1474605 | 1474605 | 2021-07-01 | Luzerne | Pennsylvania | 42079 | 32118 | 827 |
1474632 | 1474632 | 2021-07-01 | York | Pennsylvania | 42133 | 47035 | 827 |
1469305 | 1469305 | 2021-06-30 | Arapahoe | Colorado | 8005 | 64075 | 827 |
1471164 | 1471164 | 2021-06-30 | Lucas | Ohio | 39095 | 43446 | 827 |
1471359 | 1471359 | 2021-06-30 | Luzerne | Pennsylvania | 42079 | 32118 | 827 |
1467919 | 1467919 | 2021-06-29 | Lucas | Ohio | 39095 | 43437 | 827 |
1442307 | 1442307 | 2021-06-21 | Spartanburg | South Carolina | 45083 | 41988 | 827 |
1382566 | 1382566 | 2021-06-03 | East Baton Rouge | Louisiana | 22033 | 40403 | 827 |
1378503 | 1378503 | 2021-06-02 | New Castle | Delaware | 10003 | 64578 | 827 |
1313632 | 1313632 | 2021-05-13 | Sarasota | Florida | 12115 | 33104 | 827 |
1276105 | 1276105 | 2021-05-01 | Somerset | New Jersey | 34035 | 29442 | 827 |
1235442 | 1235442 | 2021-04-19 | Yuma | Arizona | 4027 | 36987 | 827 |
1236599 | 1236599 | 2021-04-19 | Genesee | Michigan | 26049 | 36957 | 827 |
1232195 | 1232195 | 2021-04-18 | Yuma | Arizona | 4027 | 36976 | 827 |
1228946 | 1228946 | 2021-04-17 | Yuma | Arizona | 4027 | 36964 | 827 |
1225698 | 1225698 | 2021-04-16 | Yuma | Arizona | 4027 | 36957 | 827 |
1222581 | 1222581 | 2021-04-15 | Tulare | California | 6107 | 49355 | 827 |
1212214 | 1212214 | 2021-04-11 | Webb | Texas | 48479 | 43376 | 827 |
1208965 | 1208965 | 2021-04-10 | Webb | Texas | 48479 | 43376 | 827 |
1205717 | 1205717 | 2021-04-09 | Webb | Texas | 48479 | 43376 | 827 |
1192755 | 1192755 | 2021-04-05 | Salt Lake | Utah | 49035 | 144443 | 827 |
1189506 | 1189506 | 2021-04-04 | Salt Lake | Utah | 49035 | 144361 | 827 |
1186259 | 1186259 | 2021-04-03 | Salt Lake | Utah | 49035 | 144244 | 827 |
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);