ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "McPherson" and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175150 | 2175150 | 2022-02-02 | McPherson | Kansas | 20113 | 7456 | 115 |
2171897 | 2171897 | 2022-02-01 | McPherson | Kansas | 20113 | 7456 | 115 |
2168644 | 2168644 | 2022-01-31 | McPherson | Kansas | 20113 | 7371 | 115 |
2165389 | 2165389 | 2022-01-30 | McPherson | Kansas | 20113 | 7310 | 114 |
2162134 | 2162134 | 2022-01-29 | McPherson | Kansas | 20113 | 7310 | 114 |
2158879 | 2158879 | 2022-01-28 | McPherson | Kansas | 20113 | 7310 | 114 |
2155625 | 2155625 | 2022-01-27 | McPherson | Kansas | 20113 | 7310 | 114 |
2152372 | 2152372 | 2022-01-26 | McPherson | Kansas | 20113 | 7136 | 113 |
2149120 | 2149120 | 2022-01-25 | McPherson | Kansas | 20113 | 7136 | 113 |
2145868 | 2145868 | 2022-01-24 | McPherson | Kansas | 20113 | 6987 | 112 |
2142613 | 2142613 | 2022-01-23 | McPherson | Kansas | 20113 | 6845 | 112 |
2139358 | 2139358 | 2022-01-22 | McPherson | Kansas | 20113 | 6845 | 112 |
2136102 | 2136102 | 2022-01-21 | McPherson | Kansas | 20113 | 6845 | 112 |
2132850 | 2132850 | 2022-01-20 | McPherson | Kansas | 20113 | 6644 | 112 |
2129597 | 2129597 | 2022-01-19 | McPherson | Kansas | 20113 | 6644 | 112 |
2126343 | 2126343 | 2022-01-18 | McPherson | Kansas | 20113 | 6269 | 111 |
2123091 | 2123091 | 2022-01-17 | McPherson | Kansas | 20113 | 6269 | 111 |
2119839 | 2119839 | 2022-01-16 | McPherson | Kansas | 20113 | 6269 | 111 |
2116587 | 2116587 | 2022-01-15 | McPherson | Kansas | 20113 | 6269 | 111 |
2113336 | 2113336 | 2022-01-14 | McPherson | Kansas | 20113 | 6269 | 111 |
2110084 | 2110084 | 2022-01-13 | McPherson | Kansas | 20113 | 6269 | 111 |
2106833 | 2106833 | 2022-01-12 | McPherson | Kansas | 20113 | 6120 | 111 |
2103582 | 2103582 | 2022-01-11 | McPherson | Kansas | 20113 | 6120 | 110 |
2100331 | 2100331 | 2022-01-10 | McPherson | Kansas | 20113 | 5912 | 110 |
2097080 | 2097080 | 2022-01-09 | McPherson | Kansas | 20113 | 5849 | 108 |
2093828 | 2093828 | 2022-01-08 | McPherson | Kansas | 20113 | 5849 | 108 |
2090576 | 2090576 | 2022-01-07 | McPherson | Kansas | 20113 | 5849 | 108 |
2087325 | 2087325 | 2022-01-06 | McPherson | Kansas | 20113 | 5735 | 105 |
2084073 | 2084073 | 2022-01-05 | McPherson | Kansas | 20113 | 5735 | 105 |
2080821 | 2080821 | 2022-01-04 | McPherson | Kansas | 20113 | 5582 | 102 |
2077569 | 2077569 | 2022-01-03 | McPherson | Kansas | 20113 | 5582 | 102 |
2074318 | 2074318 | 2022-01-02 | McPherson | Kansas | 20113 | 5566 | 101 |
2071067 | 2071067 | 2022-01-01 | McPherson | Kansas | 20113 | 5566 | 101 |
2067816 | 2067816 | 2021-12-31 | McPherson | Kansas | 20113 | 5566 | 101 |
2064565 | 2064565 | 2021-12-30 | McPherson | Kansas | 20113 | 5566 | 101 |
2061315 | 2061315 | 2021-12-29 | McPherson | Kansas | 20113 | 5511 | 101 |
2058066 | 2058066 | 2021-12-28 | McPherson | Kansas | 20113 | 5437 | 100 |
2054817 | 2054817 | 2021-12-27 | McPherson | Kansas | 20113 | 5437 | 100 |
2051567 | 2051567 | 2021-12-26 | McPherson | Kansas | 20113 | 5393 | 100 |
2048317 | 2048317 | 2021-12-25 | McPherson | Kansas | 20113 | 5393 | 100 |
2045067 | 2045067 | 2021-12-24 | McPherson | Kansas | 20113 | 5393 | 100 |
2041818 | 2041818 | 2021-12-23 | McPherson | Kansas | 20113 | 5393 | 100 |
2038568 | 2038568 | 2021-12-22 | McPherson | Kansas | 20113 | 5393 | 100 |
2035318 | 2035318 | 2021-12-21 | McPherson | Kansas | 20113 | 5393 | 99 |
2032068 | 2032068 | 2021-12-20 | McPherson | Kansas | 20113 | 5298 | 99 |
2028817 | 2028817 | 2021-12-19 | McPherson | Kansas | 20113 | 5298 | 99 |
2025566 | 2025566 | 2021-12-18 | McPherson | Kansas | 20113 | 5298 | 99 |
2022315 | 2022315 | 2021-12-17 | McPherson | Kansas | 20113 | 5298 | 99 |
2019064 | 2019064 | 2021-12-16 | McPherson | Kansas | 20113 | 5240 | 99 |
2015814 | 2015814 | 2021-12-15 | McPherson | Kansas | 20113 | 5240 | 99 |
2012563 | 2012563 | 2021-12-14 | McPherson | Kansas | 20113 | 5240 | 99 |
2009312 | 2009312 | 2021-12-13 | McPherson | Kansas | 20113 | 5138 | 99 |
2006061 | 2006061 | 2021-12-12 | McPherson | Kansas | 20113 | 5116 | 98 |
2002810 | 2002810 | 2021-12-11 | McPherson | Kansas | 20113 | 5116 | 98 |
1999560 | 1999560 | 2021-12-10 | McPherson | Kansas | 20113 | 5116 | 98 |
1996309 | 1996309 | 2021-12-09 | McPherson | Kansas | 20113 | 5116 | 98 |
1993058 | 1993058 | 2021-12-08 | McPherson | Kansas | 20113 | 5116 | 98 |
1989807 | 1989807 | 2021-12-07 | McPherson | Kansas | 20113 | 5116 | 98 |
1986557 | 1986557 | 2021-12-06 | McPherson | Kansas | 20113 | 5049 | 98 |
1983307 | 1983307 | 2021-12-05 | McPherson | Kansas | 20113 | 5049 | 98 |
1980057 | 1980057 | 2021-12-04 | McPherson | Kansas | 20113 | 5049 | 98 |
1976807 | 1976807 | 2021-12-03 | McPherson | Kansas | 20113 | 5049 | 98 |
1973558 | 1973558 | 2021-12-02 | McPherson | Kansas | 20113 | 5049 | 98 |
1970308 | 1970308 | 2021-12-01 | McPherson | Kansas | 20113 | 5002 | 98 |
1967058 | 1967058 | 2021-11-30 | McPherson | Kansas | 20113 | 5002 | 98 |
1963806 | 1963806 | 2021-11-29 | McPherson | Kansas | 20113 | 4915 | 98 |
1960555 | 1960555 | 2021-11-28 | McPherson | Kansas | 20113 | 4867 | 98 |
1957304 | 1957304 | 2021-11-27 | McPherson | Kansas | 20113 | 4867 | 98 |
1954053 | 1954053 | 2021-11-26 | McPherson | Kansas | 20113 | 4867 | 98 |
1950802 | 1950802 | 2021-11-25 | McPherson | Kansas | 20113 | 4867 | 98 |
1947551 | 1947551 | 2021-11-24 | McPherson | Kansas | 20113 | 4867 | 98 |
1944300 | 1944300 | 2021-11-23 | McPherson | Kansas | 20113 | 4867 | 98 |
1941050 | 1941050 | 2021-11-22 | McPherson | Kansas | 20113 | 4867 | 98 |
1937800 | 1937800 | 2021-11-21 | McPherson | Kansas | 20113 | 4867 | 98 |
1934550 | 1934550 | 2021-11-20 | McPherson | Kansas | 20113 | 4867 | 98 |
1931299 | 1931299 | 2021-11-19 | McPherson | Kansas | 20113 | 4867 | 98 |
1928048 | 1928048 | 2021-11-18 | McPherson | Kansas | 20113 | 4867 | 98 |
1924798 | 1924798 | 2021-11-17 | McPherson | Kansas | 20113 | 4843 | 98 |
1921549 | 1921549 | 2021-11-16 | McPherson | Kansas | 20113 | 4843 | 98 |
1918299 | 1918299 | 2021-11-15 | McPherson | Kansas | 20113 | 4741 | 98 |
1915049 | 1915049 | 2021-11-14 | McPherson | Kansas | 20113 | 4738 | 98 |
1911799 | 1911799 | 2021-11-13 | McPherson | Kansas | 20113 | 4738 | 98 |
1908550 | 1908550 | 2021-11-12 | McPherson | Kansas | 20113 | 4738 | 98 |
1905301 | 1905301 | 2021-11-11 | McPherson | Kansas | 20113 | 4738 | 98 |
1902051 | 1902051 | 2021-11-10 | McPherson | Kansas | 20113 | 4738 | 98 |
1898801 | 1898801 | 2021-11-09 | McPherson | Kansas | 20113 | 4738 | 98 |
1895551 | 1895551 | 2021-11-08 | McPherson | Kansas | 20113 | 4658 | 97 |
1892301 | 1892301 | 2021-11-07 | McPherson | Kansas | 20113 | 4658 | 97 |
1889051 | 1889051 | 2021-11-06 | McPherson | Kansas | 20113 | 4658 | 97 |
1885801 | 1885801 | 2021-11-05 | McPherson | Kansas | 20113 | 4658 | 97 |
1882552 | 1882552 | 2021-11-04 | McPherson | Kansas | 20113 | 4658 | 97 |
1879303 | 1879303 | 2021-11-03 | McPherson | Kansas | 20113 | 4571 | 97 |
1876054 | 1876054 | 2021-11-02 | McPherson | Kansas | 20113 | 4554 | 97 |
1872805 | 1872805 | 2021-11-01 | McPherson | Kansas | 20113 | 4554 | 97 |
1869556 | 1869556 | 2021-10-31 | McPherson | Kansas | 20113 | 4554 | 97 |
1866307 | 1866307 | 2021-10-30 | McPherson | Kansas | 20113 | 4554 | 97 |
1863058 | 1863058 | 2021-10-29 | McPherson | Kansas | 20113 | 4554 | 97 |
1859809 | 1859809 | 2021-10-28 | McPherson | Kansas | 20113 | 4554 | 97 |
1856560 | 1856560 | 2021-10-27 | McPherson | Kansas | 20113 | 4524 | 97 |
1853311 | 1853311 | 2021-10-26 | McPherson | Kansas | 20113 | 4468 | 94 |
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);