ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
131 rows where deaths = 91 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2354025 | 2354025 | 2022-03-29 | Miami | Kansas | 20121 | 7723 | 91 |
2350773 | 2350773 | 2022-03-28 | Miami | Kansas | 20121 | 7723 | 91 |
2347520 | 2347520 | 2022-03-27 | Miami | Kansas | 20121 | 7721 | 91 |
2344267 | 2344267 | 2022-03-26 | Miami | Kansas | 20121 | 7721 | 91 |
2341014 | 2341014 | 2022-03-25 | Miami | Kansas | 20121 | 7721 | 91 |
1973539 | 1973539 | 2021-12-02 | Harvey | Kansas | 20079 | 5608 | 91 |
1970289 | 1970289 | 2021-12-01 | Harvey | Kansas | 20079 | 5608 | 91 |
1967039 | 1967039 | 2021-11-30 | Harvey | Kansas | 20079 | 5547 | 91 |
1963787 | 1963787 | 2021-11-29 | Harvey | Kansas | 20079 | 5547 | 91 |
1960536 | 1960536 | 2021-11-28 | Harvey | Kansas | 20079 | 5471 | 91 |
1957285 | 1957285 | 2021-11-27 | Harvey | Kansas | 20079 | 5471 | 91 |
1954034 | 1954034 | 2021-11-26 | Harvey | Kansas | 20079 | 5471 | 91 |
1928017 | 1928017 | 2021-11-18 | Finney | Kansas | 20055 | 7892 | 91 |
1924767 | 1924767 | 2021-11-17 | Finney | Kansas | 20055 | 7872 | 91 |
1921518 | 1921518 | 2021-11-16 | Finney | Kansas | 20055 | 7809 | 91 |
1918268 | 1918268 | 2021-11-15 | Finney | Kansas | 20055 | 7809 | 91 |
1915018 | 1915018 | 2021-11-14 | Finney | Kansas | 20055 | 7723 | 91 |
1915030 | 1915030 | 2021-11-14 | Harvey | Kansas | 20079 | 5280 | 91 |
1911768 | 1911768 | 2021-11-13 | Finney | Kansas | 20055 | 7723 | 91 |
1911780 | 1911780 | 2021-11-13 | Harvey | Kansas | 20079 | 5280 | 91 |
1908519 | 1908519 | 2021-11-12 | Finney | Kansas | 20055 | 7723 | 91 |
1908531 | 1908531 | 2021-11-12 | Harvey | Kansas | 20079 | 5280 | 91 |
1905270 | 1905270 | 2021-11-11 | Finney | Kansas | 20055 | 7703 | 91 |
1905282 | 1905282 | 2021-11-11 | Harvey | Kansas | 20079 | 5255 | 91 |
1902020 | 1902020 | 2021-11-10 | Finney | Kansas | 20055 | 7703 | 91 |
1902032 | 1902032 | 2021-11-10 | Harvey | Kansas | 20079 | 5255 | 91 |
1853281 | 1853281 | 2021-10-26 | Ford | Kansas | 20057 | 7120 | 91 |
1850032 | 1850032 | 2021-10-25 | Ford | Kansas | 20057 | 7120 | 91 |
1830562 | 1830562 | 2021-10-19 | Lyon | Kansas | 20111 | 5387 | 91 |
1827313 | 1827313 | 2021-10-18 | Lyon | Kansas | 20111 | 5387 | 91 |
1824064 | 1824064 | 2021-10-17 | Lyon | Kansas | 20111 | 5365 | 91 |
1820815 | 1820815 | 2021-10-16 | Lyon | Kansas | 20111 | 5365 | 91 |
1817566 | 1817566 | 2021-10-15 | Lyon | Kansas | 20111 | 5365 | 91 |
1814318 | 1814318 | 2021-10-14 | Lyon | Kansas | 20111 | 5338 | 91 |
1811069 | 1811069 | 2021-10-13 | Lyon | Kansas | 20111 | 5338 | 91 |
1807820 | 1807820 | 2021-10-12 | Lyon | Kansas | 20111 | 5313 | 91 |
1804569 | 1804569 | 2021-10-11 | Lyon | Kansas | 20111 | 5313 | 91 |
1801320 | 1801320 | 2021-10-10 | Lyon | Kansas | 20111 | 5306 | 91 |
1798071 | 1798071 | 2021-10-09 | Lyon | Kansas | 20111 | 5306 | 91 |
1794822 | 1794822 | 2021-10-08 | Lyon | Kansas | 20111 | 5306 | 91 |
1791574 | 1791574 | 2021-10-07 | Lyon | Kansas | 20111 | 5282 | 91 |
1788325 | 1788325 | 2021-10-06 | Lyon | Kansas | 20111 | 5282 | 91 |
1785076 | 1785076 | 2021-10-05 | Lyon | Kansas | 20111 | 5249 | 91 |
1785079 | 1785079 | 2021-10-05 | McPherson | Kansas | 20113 | 4208 | 91 |
1781827 | 1781827 | 2021-10-04 | Lyon | Kansas | 20111 | 5249 | 91 |
1781830 | 1781830 | 2021-10-04 | McPherson | Kansas | 20113 | 4208 | 91 |
1778577 | 1778577 | 2021-10-03 | Lyon | Kansas | 20111 | 5227 | 91 |
1778580 | 1778580 | 2021-10-03 | McPherson | Kansas | 20113 | 4208 | 91 |
1775327 | 1775327 | 2021-10-02 | Lyon | Kansas | 20111 | 5227 | 91 |
1775330 | 1775330 | 2021-10-02 | McPherson | Kansas | 20113 | 4208 | 91 |
1772077 | 1772077 | 2021-10-01 | Lyon | Kansas | 20111 | 5227 | 91 |
1772080 | 1772080 | 2021-10-01 | McPherson | Kansas | 20113 | 4208 | 91 |
1768828 | 1768828 | 2021-09-30 | Lyon | Kansas | 20111 | 5209 | 91 |
1768831 | 1768831 | 2021-09-30 | McPherson | Kansas | 20113 | 4208 | 91 |
1765579 | 1765579 | 2021-09-29 | Lyon | Kansas | 20111 | 5209 | 91 |
1765582 | 1765582 | 2021-09-29 | McPherson | Kansas | 20113 | 4172 | 91 |
1762330 | 1762330 | 2021-09-28 | Lyon | Kansas | 20111 | 5190 | 91 |
1759082 | 1759082 | 2021-09-27 | Lyon | Kansas | 20111 | 5190 | 91 |
1755834 | 1755834 | 2021-09-26 | Lyon | Kansas | 20111 | 5171 | 91 |
1752586 | 1752586 | 2021-09-25 | Lyon | Kansas | 20111 | 5171 | 91 |
1749337 | 1749337 | 2021-09-24 | Lyon | Kansas | 20111 | 5171 | 91 |
1560883 | 1560883 | 2021-07-28 | Crawford | Kansas | 20037 | 5486 | 91 |
1557636 | 1557636 | 2021-07-27 | Crawford | Kansas | 20037 | 5389 | 91 |
1554389 | 1554389 | 2021-07-26 | Crawford | Kansas | 20037 | 5335 | 91 |
1551142 | 1551142 | 2021-07-25 | Crawford | Kansas | 20037 | 5335 | 91 |
1547895 | 1547895 | 2021-07-24 | Crawford | Kansas | 20037 | 5335 | 91 |
1544648 | 1544648 | 2021-07-23 | Crawford | Kansas | 20037 | 5335 | 91 |
1495932 | 1495932 | 2021-07-08 | Butler | Kansas | 20015 | 7665 | 91 |
1492686 | 1492686 | 2021-07-07 | Butler | Kansas | 20015 | 7665 | 91 |
1489439 | 1489439 | 2021-07-06 | Butler | Kansas | 20015 | 7664 | 91 |
1486192 | 1486192 | 2021-07-05 | Butler | Kansas | 20015 | 7664 | 91 |
1482946 | 1482946 | 2021-07-04 | Butler | Kansas | 20015 | 7664 | 91 |
1479699 | 1479699 | 2021-07-03 | Butler | Kansas | 20015 | 7664 | 91 |
1476453 | 1476453 | 2021-07-02 | Butler | Kansas | 20015 | 7664 | 91 |
1473207 | 1473207 | 2021-07-01 | Butler | Kansas | 20015 | 7664 | 91 |
1469961 | 1469961 | 2021-06-30 | Butler | Kansas | 20015 | 7664 | 91 |
1466716 | 1466716 | 2021-06-29 | Butler | Kansas | 20015 | 7653 | 91 |
1463471 | 1463471 | 2021-06-28 | Butler | Kansas | 20015 | 7653 | 91 |
1460226 | 1460226 | 2021-06-27 | Butler | Kansas | 20015 | 7648 | 91 |
1456981 | 1456981 | 2021-06-26 | Butler | Kansas | 20015 | 7648 | 91 |
1453736 | 1453736 | 2021-06-25 | Butler | Kansas | 20015 | 7648 | 91 |
1450490 | 1450490 | 2021-06-24 | Butler | Kansas | 20015 | 7647 | 91 |
1447245 | 1447245 | 2021-06-23 | Butler | Kansas | 20015 | 7647 | 91 |
1444000 | 1444000 | 2021-06-22 | Butler | Kansas | 20015 | 7643 | 91 |
1440755 | 1440755 | 2021-06-21 | Butler | Kansas | 20015 | 7643 | 91 |
1437508 | 1437508 | 2021-06-20 | Butler | Kansas | 20015 | 7635 | 91 |
1434261 | 1434261 | 2021-06-19 | Butler | Kansas | 20015 | 7635 | 91 |
1431015 | 1431015 | 2021-06-18 | Butler | Kansas | 20015 | 7635 | 91 |
1427770 | 1427770 | 2021-06-17 | Butler | Kansas | 20015 | 7635 | 91 |
1424525 | 1424525 | 2021-06-16 | Butler | Kansas | 20015 | 7635 | 91 |
1421277 | 1421277 | 2021-06-15 | Butler | Kansas | 20015 | 7627 | 91 |
1418032 | 1418032 | 2021-06-14 | Butler | Kansas | 20015 | 7627 | 91 |
1359656 | 1359656 | 2021-05-27 | Leavenworth | Kansas | 20103 | 7252 | 91 |
1356410 | 1356410 | 2021-05-26 | Leavenworth | Kansas | 20103 | 7252 | 91 |
1353164 | 1353164 | 2021-05-25 | Leavenworth | Kansas | 20103 | 7246 | 91 |
1349918 | 1349918 | 2021-05-24 | Leavenworth | Kansas | 20103 | 7246 | 91 |
1346671 | 1346671 | 2021-05-23 | Leavenworth | Kansas | 20103 | 7243 | 91 |
1343423 | 1343423 | 2021-05-22 | Leavenworth | Kansas | 20103 | 7243 | 91 |
1340175 | 1340175 | 2021-05-21 | Leavenworth | Kansas | 20103 | 7243 | 91 |
1336928 | 1336928 | 2021-05-20 | Leavenworth | Kansas | 20103 | 7238 | 91 |
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);