ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
74 rows where deaths = 92 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
county 10
- Lyon 16
- Butler 14
- Leavenworth 12
- Harvey 11
- Saline 7
- McPherson 5
- Johnson 4
- Montgomery 2
- Wyandotte 2
- Crawford 1
state 1
- Kansas · 74 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1950783 | 1950783 | 2021-11-25 | Harvey | Kansas | 20079 | 5471 | 92 |
1947532 | 1947532 | 2021-11-24 | Harvey | Kansas | 20079 | 5471 | 92 |
1944281 | 1944281 | 2021-11-23 | Harvey | Kansas | 20079 | 5433 | 92 |
1941031 | 1941031 | 2021-11-22 | Harvey | Kansas | 20079 | 5433 | 92 |
1937781 | 1937781 | 2021-11-21 | Harvey | Kansas | 20079 | 5393 | 92 |
1934531 | 1934531 | 2021-11-20 | Harvey | Kansas | 20079 | 5393 | 92 |
1931280 | 1931280 | 2021-11-19 | Harvey | Kansas | 20079 | 5393 | 92 |
1928029 | 1928029 | 2021-11-18 | Harvey | Kansas | 20079 | 5349 | 92 |
1924779 | 1924779 | 2021-11-17 | Harvey | Kansas | 20079 | 5349 | 92 |
1921530 | 1921530 | 2021-11-16 | Harvey | Kansas | 20079 | 5312 | 92 |
1918280 | 1918280 | 2021-11-15 | Harvey | Kansas | 20079 | 5312 | 92 |
1882549 | 1882549 | 2021-11-04 | Lyon | Kansas | 20111 | 5523 | 92 |
1879300 | 1879300 | 2021-11-03 | Lyon | Kansas | 20111 | 5523 | 92 |
1876051 | 1876051 | 2021-11-02 | Lyon | Kansas | 20111 | 5490 | 92 |
1872802 | 1872802 | 2021-11-01 | Lyon | Kansas | 20111 | 5490 | 92 |
1869553 | 1869553 | 2021-10-31 | Lyon | Kansas | 20111 | 5483 | 92 |
1866304 | 1866304 | 2021-10-30 | Lyon | Kansas | 20111 | 5483 | 92 |
1863055 | 1863055 | 2021-10-29 | Lyon | Kansas | 20111 | 5483 | 92 |
1859806 | 1859806 | 2021-10-28 | Lyon | Kansas | 20111 | 5462 | 92 |
1856557 | 1856557 | 2021-10-27 | Lyon | Kansas | 20111 | 5462 | 92 |
1853308 | 1853308 | 2021-10-26 | Lyon | Kansas | 20111 | 5435 | 92 |
1850059 | 1850059 | 2021-10-25 | Lyon | Kansas | 20111 | 5435 | 92 |
1846809 | 1846809 | 2021-10-24 | Lyon | Kansas | 20111 | 5426 | 92 |
1843559 | 1843559 | 2021-10-23 | Lyon | Kansas | 20111 | 5426 | 92 |
1840309 | 1840309 | 2021-10-22 | Lyon | Kansas | 20111 | 5426 | 92 |
1837060 | 1837060 | 2021-10-21 | Lyon | Kansas | 20111 | 5401 | 92 |
1833811 | 1833811 | 2021-10-20 | Lyon | Kansas | 20111 | 5401 | 92 |
1801323 | 1801323 | 2021-10-10 | McPherson | Kansas | 20113 | 4291 | 92 |
1798074 | 1798074 | 2021-10-09 | McPherson | Kansas | 20113 | 4291 | 92 |
1794825 | 1794825 | 2021-10-08 | McPherson | Kansas | 20113 | 4291 | 92 |
1791577 | 1791577 | 2021-10-07 | McPherson | Kansas | 20113 | 4291 | 92 |
1788328 | 1788328 | 2021-10-06 | McPherson | Kansas | 20113 | 4257 | 92 |
1677868 | 1677868 | 2021-09-02 | Montgomery | Kansas | 20125 | 4586 | 92 |
1674621 | 1674621 | 2021-09-01 | Montgomery | Kansas | 20125 | 4586 | 92 |
1564131 | 1564131 | 2021-07-29 | Crawford | Kansas | 20037 | 5486 | 92 |
1541389 | 1541389 | 2021-07-22 | Butler | Kansas | 20015 | 7775 | 92 |
1538142 | 1538142 | 2021-07-21 | Butler | Kansas | 20015 | 7775 | 92 |
1534894 | 1534894 | 2021-07-20 | Butler | Kansas | 20015 | 7734 | 92 |
1531647 | 1531647 | 2021-07-19 | Butler | Kansas | 20015 | 7734 | 92 |
1528400 | 1528400 | 2021-07-18 | Butler | Kansas | 20015 | 7717 | 92 |
1525153 | 1525153 | 2021-07-17 | Butler | Kansas | 20015 | 7717 | 92 |
1521905 | 1521905 | 2021-07-16 | Butler | Kansas | 20015 | 7717 | 92 |
1518657 | 1518657 | 2021-07-15 | Butler | Kansas | 20015 | 7679 | 92 |
1515410 | 1515410 | 2021-07-14 | Butler | Kansas | 20015 | 7679 | 92 |
1512164 | 1512164 | 2021-07-13 | Butler | Kansas | 20015 | 7679 | 92 |
1508917 | 1508917 | 2021-07-12 | Butler | Kansas | 20015 | 7679 | 92 |
1505671 | 1505671 | 2021-07-11 | Butler | Kansas | 20015 | 7672 | 92 |
1502425 | 1502425 | 2021-07-10 | Butler | Kansas | 20015 | 7672 | 92 |
1499179 | 1499179 | 2021-07-09 | Butler | Kansas | 20015 | 7672 | 92 |
1392112 | 1392112 | 2021-06-06 | Leavenworth | Kansas | 20103 | 7266 | 92 |
1388867 | 1388867 | 2021-06-05 | Leavenworth | Kansas | 20103 | 7266 | 92 |
1385622 | 1385622 | 2021-06-04 | Leavenworth | Kansas | 20103 | 7266 | 92 |
1382376 | 1382376 | 2021-06-03 | Leavenworth | Kansas | 20103 | 7264 | 92 |
1379131 | 1379131 | 2021-06-02 | Leavenworth | Kansas | 20103 | 7264 | 92 |
1375885 | 1375885 | 2021-06-01 | Leavenworth | Kansas | 20103 | 7255 | 92 |
1372640 | 1372640 | 2021-05-31 | Leavenworth | Kansas | 20103 | 7255 | 92 |
1369395 | 1369395 | 2021-05-30 | Leavenworth | Kansas | 20103 | 7255 | 92 |
1366149 | 1366149 | 2021-05-29 | Leavenworth | Kansas | 20103 | 7255 | 92 |
1362903 | 1362903 | 2021-05-28 | Leavenworth | Kansas | 20103 | 7255 | 92 |
1291476 | 1291476 | 2021-05-06 | Leavenworth | Kansas | 20103 | 7212 | 92 |
1288230 | 1288230 | 2021-05-05 | Leavenworth | Kansas | 20103 | 7212 | 92 |
989571 | 989571 | 2021-02-02 | Saline | Kansas | 20169 | 5606 | 92 |
986324 | 986324 | 2021-02-01 | Saline | Kansas | 20169 | 5606 | 92 |
983077 | 983077 | 2021-01-31 | Saline | Kansas | 20169 | 5542 | 92 |
979831 | 979831 | 2021-01-30 | Saline | Kansas | 20169 | 5542 | 92 |
976585 | 976585 | 2021-01-29 | Saline | Kansas | 20169 | 5542 | 92 |
973340 | 973340 | 2021-01-28 | Saline | Kansas | 20169 | 5501 | 92 |
970095 | 970095 | 2021-01-27 | Saline | Kansas | 20169 | 5501 | 92 |
377280 | 377280 | 2020-07-28 | Wyandotte | Kansas | 20209 | 4294 | 92 |
374065 | 374065 | 2020-07-27 | Wyandotte | Kansas | 20209 | 4287 | 92 |
364379 | 364379 | 2020-07-24 | Johnson | Kansas | 20091 | 4381 | 92 |
322821 | 322821 | 2020-07-11 | Johnson | Kansas | 20091 | 2857 | 92 |
319642 | 319642 | 2020-07-10 | Johnson | Kansas | 20091 | 2804 | 92 |
316469 | 316469 | 2020-07-09 | Johnson | Kansas | 20091 | 2633 | 92 |
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);