ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
120 rows where deaths = 57 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2487516 | 2487516 | 2022-05-09 | Pottawatomie | Kansas | 20149 | 5760 | 57 |
2484258 | 2484258 | 2022-05-08 | Pottawatomie | Kansas | 20149 | 5760 | 57 |
2481000 | 2481000 | 2022-05-07 | Pottawatomie | Kansas | 20149 | 5760 | 57 |
2477742 | 2477742 | 2022-05-06 | Pottawatomie | Kansas | 20149 | 5760 | 57 |
2474484 | 2474484 | 2022-05-05 | Pottawatomie | Kansas | 20149 | 5754 | 57 |
2471227 | 2471227 | 2022-05-04 | Pottawatomie | Kansas | 20149 | 5754 | 57 |
2467971 | 2467971 | 2022-05-03 | Pottawatomie | Kansas | 20149 | 5754 | 57 |
2464716 | 2464716 | 2022-05-02 | Pottawatomie | Kansas | 20149 | 5754 | 57 |
2461460 | 2461460 | 2022-05-01 | Pottawatomie | Kansas | 20149 | 5754 | 57 |
2458204 | 2458204 | 2022-04-30 | Pottawatomie | Kansas | 20149 | 5754 | 57 |
2454948 | 2454948 | 2022-04-29 | Pottawatomie | Kansas | 20149 | 5754 | 57 |
2451692 | 2451692 | 2022-04-28 | Pottawatomie | Kansas | 20149 | 5741 | 57 |
2448436 | 2448436 | 2022-04-27 | Pottawatomie | Kansas | 20149 | 5741 | 57 |
2354052 | 2354052 | 2022-03-29 | Seward | Kansas | 20175 | 6906 | 57 |
2194651 | 2194651 | 2022-02-08 | Jefferson | Kansas | 20087 | 4622 | 57 |
2191397 | 2191397 | 2022-02-07 | Jefferson | Kansas | 20087 | 4622 | 57 |
2188144 | 2188144 | 2022-02-06 | Jefferson | Kansas | 20087 | 4597 | 57 |
2184891 | 2184891 | 2022-02-05 | Jefferson | Kansas | 20087 | 4597 | 57 |
2181639 | 2181639 | 2022-02-04 | Jefferson | Kansas | 20087 | 4597 | 57 |
2155633 | 2155633 | 2022-01-27 | Neosho | Kansas | 20133 | 4676 | 57 |
2152380 | 2152380 | 2022-01-26 | Neosho | Kansas | 20133 | 4676 | 57 |
2149128 | 2149128 | 2022-01-25 | Neosho | Kansas | 20133 | 4562 | 57 |
2145876 | 2145876 | 2022-01-24 | Neosho | Kansas | 20133 | 4562 | 57 |
2142621 | 2142621 | 2022-01-23 | Neosho | Kansas | 20133 | 4452 | 57 |
2139366 | 2139366 | 2022-01-22 | Neosho | Kansas | 20133 | 4452 | 57 |
2136110 | 2136110 | 2022-01-21 | Neosho | Kansas | 20133 | 4452 | 57 |
2132858 | 2132858 | 2022-01-20 | Neosho | Kansas | 20133 | 4288 | 57 |
2129605 | 2129605 | 2022-01-19 | Neosho | Kansas | 20133 | 4288 | 57 |
2080850 | 2080850 | 2022-01-04 | Seward | Kansas | 20175 | 5702 | 57 |
2077598 | 2077598 | 2022-01-03 | Seward | Kansas | 20175 | 5702 | 57 |
2074347 | 2074347 | 2022-01-02 | Seward | Kansas | 20175 | 5444 | 57 |
2071096 | 2071096 | 2022-01-01 | Seward | Kansas | 20175 | 5444 | 57 |
2067845 | 2067845 | 2021-12-31 | Seward | Kansas | 20175 | 5444 | 57 |
2064594 | 2064594 | 2021-12-30 | Seward | Kansas | 20175 | 5444 | 57 |
2061344 | 2061344 | 2021-12-29 | Seward | Kansas | 20175 | 5444 | 57 |
2058073 | 2058073 | 2021-12-28 | Nemaha | Kansas | 20131 | 2446 | 57 |
2054824 | 2054824 | 2021-12-27 | Nemaha | Kansas | 20131 | 2446 | 57 |
2051574 | 2051574 | 2021-12-26 | Nemaha | Kansas | 20131 | 2420 | 57 |
2048324 | 2048324 | 2021-12-25 | Nemaha | Kansas | 20131 | 2420 | 57 |
2045074 | 2045074 | 2021-12-24 | Nemaha | Kansas | 20131 | 2420 | 57 |
2041825 | 2041825 | 2021-12-23 | Nemaha | Kansas | 20131 | 2420 | 57 |
2038575 | 2038575 | 2021-12-22 | Nemaha | Kansas | 20131 | 2420 | 57 |
2035325 | 2035325 | 2021-12-21 | Nemaha | Kansas | 20131 | 2400 | 57 |
2032075 | 2032075 | 2021-12-20 | Nemaha | Kansas | 20131 | 2400 | 57 |
2028824 | 2028824 | 2021-12-19 | Nemaha | Kansas | 20131 | 2380 | 57 |
2025573 | 2025573 | 2021-12-18 | Nemaha | Kansas | 20131 | 2380 | 57 |
2022322 | 2022322 | 2021-12-17 | Nemaha | Kansas | 20131 | 2380 | 57 |
1882524 | 1882524 | 2021-11-04 | Geary | Kansas | 20061 | 4795 | 57 |
1879275 | 1879275 | 2021-11-03 | Geary | Kansas | 20061 | 4795 | 57 |
1876026 | 1876026 | 2021-11-02 | Geary | Kansas | 20061 | 4784 | 57 |
1872777 | 1872777 | 2021-11-01 | Geary | Kansas | 20061 | 4784 | 57 |
1869528 | 1869528 | 2021-10-31 | Geary | Kansas | 20061 | 4780 | 57 |
1866279 | 1866279 | 2021-10-30 | Geary | Kansas | 20061 | 4780 | 57 |
1863030 | 1863030 | 2021-10-29 | Geary | Kansas | 20061 | 4780 | 57 |
1859781 | 1859781 | 2021-10-28 | Geary | Kansas | 20061 | 4769 | 57 |
1856532 | 1856532 | 2021-10-27 | Geary | Kansas | 20061 | 4769 | 57 |
1853257 | 1853257 | 2021-10-26 | Barton | Kansas | 20009 | 3872 | 57 |
1850008 | 1850008 | 2021-10-25 | Barton | Kansas | 20009 | 3872 | 57 |
1762335 | 1762335 | 2021-09-28 | Miami | Kansas | 20121 | 4046 | 57 |
1759087 | 1759087 | 2021-09-27 | Miami | Kansas | 20121 | 4046 | 57 |
1755799 | 1755799 | 2021-09-26 | Dickinson | Kansas | 20041 | 2585 | 57 |
1755839 | 1755839 | 2021-09-26 | Miami | Kansas | 20121 | 4014 | 57 |
1752551 | 1752551 | 2021-09-25 | Dickinson | Kansas | 20041 | 2585 | 57 |
1752591 | 1752591 | 2021-09-25 | Miami | Kansas | 20121 | 4014 | 57 |
1749302 | 1749302 | 2021-09-24 | Dickinson | Kansas | 20041 | 2585 | 57 |
1749342 | 1749342 | 2021-09-24 | Miami | Kansas | 20121 | 4014 | 57 |
1742863 | 1742863 | 2021-09-22 | Riley | Kansas | 20161 | 7793 | 57 |
1739554 | 1739554 | 2021-09-21 | Dickinson | Kansas | 20041 | 2525 | 57 |
1739614 | 1739614 | 2021-09-21 | Riley | Kansas | 20161 | 7793 | 57 |
1736305 | 1736305 | 2021-09-20 | Dickinson | Kansas | 20041 | 2525 | 57 |
1736365 | 1736365 | 2021-09-20 | Riley | Kansas | 20161 | 7793 | 57 |
1733115 | 1733115 | 2021-09-19 | Riley | Kansas | 20161 | 7770 | 57 |
1733130 | 1733130 | 2021-09-19 | Sumner | Kansas | 20191 | 2856 | 57 |
1729865 | 1729865 | 2021-09-18 | Riley | Kansas | 20161 | 7770 | 57 |
1729880 | 1729880 | 2021-09-18 | Sumner | Kansas | 20191 | 2856 | 57 |
1726615 | 1726615 | 2021-09-17 | Riley | Kansas | 20161 | 7770 | 57 |
1726630 | 1726630 | 2021-09-17 | Sumner | Kansas | 20191 | 2856 | 57 |
1723366 | 1723366 | 2021-09-16 | Riley | Kansas | 20161 | 7693 | 57 |
1723381 | 1723381 | 2021-09-16 | Sumner | Kansas | 20191 | 2820 | 57 |
1720117 | 1720117 | 2021-09-15 | Riley | Kansas | 20161 | 7693 | 57 |
1720132 | 1720132 | 2021-09-15 | Sumner | Kansas | 20191 | 2820 | 57 |
1716869 | 1716869 | 2021-09-14 | Riley | Kansas | 20161 | 7575 | 57 |
1716884 | 1716884 | 2021-09-14 | Sumner | Kansas | 20191 | 2794 | 57 |
1713623 | 1713623 | 2021-09-13 | Riley | Kansas | 20161 | 7575 | 57 |
1713638 | 1713638 | 2021-09-13 | Sumner | Kansas | 20191 | 2794 | 57 |
1710376 | 1710376 | 2021-09-12 | Riley | Kansas | 20161 | 7575 | 57 |
1710391 | 1710391 | 2021-09-12 | Sumner | Kansas | 20191 | 2764 | 57 |
1707129 | 1707129 | 2021-09-11 | Riley | Kansas | 20161 | 7575 | 57 |
1707144 | 1707144 | 2021-09-11 | Sumner | Kansas | 20191 | 2764 | 57 |
1703881 | 1703881 | 2021-09-10 | Riley | Kansas | 20161 | 7575 | 57 |
1703896 | 1703896 | 2021-09-10 | Sumner | Kansas | 20191 | 2764 | 57 |
1700600 | 1700600 | 2021-09-09 | Labette | Kansas | 20099 | 3368 | 57 |
1700631 | 1700631 | 2021-09-09 | Riley | Kansas | 20161 | 7575 | 57 |
1697351 | 1697351 | 2021-09-08 | Labette | Kansas | 20099 | 3368 | 57 |
1697382 | 1697382 | 2021-09-08 | Riley | Kansas | 20161 | 7575 | 57 |
1694134 | 1694134 | 2021-09-07 | Riley | Kansas | 20161 | 7467 | 57 |
1690885 | 1690885 | 2021-09-06 | Riley | Kansas | 20161 | 7467 | 57 |
1687635 | 1687635 | 2021-09-05 | Riley | Kansas | 20161 | 7467 | 57 |
1580364 | 1580364 | 2021-08-03 | Cherokee | Kansas | 20021 | 3000 | 57 |
1577115 | 1577115 | 2021-08-02 | Cherokee | Kansas | 20021 | 3000 | 57 |
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);