ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where fips = 20079 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175131 | 2175131 | 2022-02-02 | Harvey | Kansas | 20079 | 9141 | 113 |
2171878 | 2171878 | 2022-02-01 | Harvey | Kansas | 20079 | 9003 | 112 |
2168625 | 2168625 | 2022-01-31 | Harvey | Kansas | 20079 | 9003 | 112 |
2165370 | 2165370 | 2022-01-30 | Harvey | Kansas | 20079 | 8888 | 112 |
2162115 | 2162115 | 2022-01-29 | Harvey | Kansas | 20079 | 8888 | 112 |
2158860 | 2158860 | 2022-01-28 | Harvey | Kansas | 20079 | 8888 | 112 |
2155606 | 2155606 | 2022-01-27 | Harvey | Kansas | 20079 | 8689 | 109 |
2152353 | 2152353 | 2022-01-26 | Harvey | Kansas | 20079 | 8689 | 109 |
2149101 | 2149101 | 2022-01-25 | Harvey | Kansas | 20079 | 8462 | 108 |
2145849 | 2145849 | 2022-01-24 | Harvey | Kansas | 20079 | 8462 | 108 |
2142594 | 2142594 | 2022-01-23 | Harvey | Kansas | 20079 | 8225 | 108 |
2139339 | 2139339 | 2022-01-22 | Harvey | Kansas | 20079 | 8225 | 108 |
2136083 | 2136083 | 2022-01-21 | Harvey | Kansas | 20079 | 8225 | 108 |
2132831 | 2132831 | 2022-01-20 | Harvey | Kansas | 20079 | 7998 | 108 |
2129578 | 2129578 | 2022-01-19 | Harvey | Kansas | 20079 | 7998 | 108 |
2126324 | 2126324 | 2022-01-18 | Harvey | Kansas | 20079 | 7510 | 108 |
2123072 | 2123072 | 2022-01-17 | Harvey | Kansas | 20079 | 7510 | 108 |
2119820 | 2119820 | 2022-01-16 | Harvey | Kansas | 20079 | 7510 | 108 |
2116568 | 2116568 | 2022-01-15 | Harvey | Kansas | 20079 | 7510 | 108 |
2113317 | 2113317 | 2022-01-14 | Harvey | Kansas | 20079 | 7510 | 108 |
2110065 | 2110065 | 2022-01-13 | Harvey | Kansas | 20079 | 7256 | 108 |
2106814 | 2106814 | 2022-01-12 | Harvey | Kansas | 20079 | 7256 | 108 |
2103563 | 2103563 | 2022-01-11 | Harvey | Kansas | 20079 | 6985 | 107 |
2100312 | 2100312 | 2022-01-10 | Harvey | Kansas | 20079 | 6985 | 107 |
2097061 | 2097061 | 2022-01-09 | Harvey | Kansas | 20079 | 6869 | 106 |
2093809 | 2093809 | 2022-01-08 | Harvey | Kansas | 20079 | 6869 | 106 |
2090557 | 2090557 | 2022-01-07 | Harvey | Kansas | 20079 | 6869 | 106 |
2087306 | 2087306 | 2022-01-06 | Harvey | Kansas | 20079 | 6696 | 106 |
2084054 | 2084054 | 2022-01-05 | Harvey | Kansas | 20079 | 6696 | 106 |
2080802 | 2080802 | 2022-01-04 | Harvey | Kansas | 20079 | 6540 | 107 |
2077550 | 2077550 | 2022-01-03 | Harvey | Kansas | 20079 | 6540 | 107 |
2074299 | 2074299 | 2022-01-02 | Harvey | Kansas | 20079 | 6383 | 105 |
2071048 | 2071048 | 2022-01-01 | Harvey | Kansas | 20079 | 6383 | 105 |
2067797 | 2067797 | 2021-12-31 | Harvey | Kansas | 20079 | 6383 | 105 |
2064546 | 2064546 | 2021-12-30 | Harvey | Kansas | 20079 | 6383 | 105 |
2061296 | 2061296 | 2021-12-29 | Harvey | Kansas | 20079 | 6383 | 105 |
2058047 | 2058047 | 2021-12-28 | Harvey | Kansas | 20079 | 6289 | 102 |
2054798 | 2054798 | 2021-12-27 | Harvey | Kansas | 20079 | 6289 | 102 |
2051548 | 2051548 | 2021-12-26 | Harvey | Kansas | 20079 | 6198 | 102 |
2048298 | 2048298 | 2021-12-25 | Harvey | Kansas | 20079 | 6198 | 102 |
2045048 | 2045048 | 2021-12-24 | Harvey | Kansas | 20079 | 6198 | 102 |
2041799 | 2041799 | 2021-12-23 | Harvey | Kansas | 20079 | 6198 | 102 |
2038549 | 2038549 | 2021-12-22 | Harvey | Kansas | 20079 | 6198 | 102 |
2035299 | 2035299 | 2021-12-21 | Harvey | Kansas | 20079 | 6107 | 100 |
2032049 | 2032049 | 2021-12-20 | Harvey | Kansas | 20079 | 6107 | 100 |
2028798 | 2028798 | 2021-12-19 | Harvey | Kansas | 20079 | 6064 | 101 |
2025547 | 2025547 | 2021-12-18 | Harvey | Kansas | 20079 | 6064 | 101 |
2022296 | 2022296 | 2021-12-17 | Harvey | Kansas | 20079 | 6064 | 101 |
2019045 | 2019045 | 2021-12-16 | Harvey | Kansas | 20079 | 5984 | 100 |
2015795 | 2015795 | 2021-12-15 | Harvey | Kansas | 20079 | 5984 | 100 |
2012544 | 2012544 | 2021-12-14 | Harvey | Kansas | 20079 | 5908 | 100 |
2009293 | 2009293 | 2021-12-13 | Harvey | Kansas | 20079 | 5908 | 100 |
2006042 | 2006042 | 2021-12-12 | Harvey | Kansas | 20079 | 5869 | 100 |
2002791 | 2002791 | 2021-12-11 | Harvey | Kansas | 20079 | 5869 | 100 |
1999541 | 1999541 | 2021-12-10 | Harvey | Kansas | 20079 | 5869 | 100 |
1996290 | 1996290 | 2021-12-09 | Harvey | Kansas | 20079 | 5816 | 94 |
1993039 | 1993039 | 2021-12-08 | Harvey | Kansas | 20079 | 5816 | 94 |
1989788 | 1989788 | 2021-12-07 | Harvey | Kansas | 20079 | 5756 | 93 |
1986538 | 1986538 | 2021-12-06 | Harvey | Kansas | 20079 | 5756 | 93 |
1983288 | 1983288 | 2021-12-05 | Harvey | Kansas | 20079 | 5687 | 93 |
1980038 | 1980038 | 2021-12-04 | Harvey | Kansas | 20079 | 5687 | 93 |
1976788 | 1976788 | 2021-12-03 | Harvey | Kansas | 20079 | 5687 | 93 |
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 |
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 |
1915030 | 1915030 | 2021-11-14 | Harvey | Kansas | 20079 | 5280 | 91 |
1911780 | 1911780 | 2021-11-13 | Harvey | Kansas | 20079 | 5280 | 91 |
1908531 | 1908531 | 2021-11-12 | Harvey | Kansas | 20079 | 5280 | 91 |
1905282 | 1905282 | 2021-11-11 | Harvey | Kansas | 20079 | 5255 | 91 |
1902032 | 1902032 | 2021-11-10 | Harvey | Kansas | 20079 | 5255 | 91 |
1898782 | 1898782 | 2021-11-09 | Harvey | Kansas | 20079 | 5210 | 88 |
1895532 | 1895532 | 2021-11-08 | Harvey | Kansas | 20079 | 5210 | 88 |
1892282 | 1892282 | 2021-11-07 | Harvey | Kansas | 20079 | 5193 | 87 |
1889032 | 1889032 | 2021-11-06 | Harvey | Kansas | 20079 | 5193 | 87 |
1885782 | 1885782 | 2021-11-05 | Harvey | Kansas | 20079 | 5193 | 87 |
1882533 | 1882533 | 2021-11-04 | Harvey | Kansas | 20079 | 5165 | 84 |
1879284 | 1879284 | 2021-11-03 | Harvey | Kansas | 20079 | 5165 | 84 |
1876035 | 1876035 | 2021-11-02 | Harvey | Kansas | 20079 | 5139 | 84 |
1872786 | 1872786 | 2021-11-01 | Harvey | Kansas | 20079 | 5139 | 84 |
1869537 | 1869537 | 2021-10-31 | Harvey | Kansas | 20079 | 5107 | 84 |
1866288 | 1866288 | 2021-10-30 | Harvey | Kansas | 20079 | 5107 | 84 |
1863039 | 1863039 | 2021-10-29 | Harvey | Kansas | 20079 | 5107 | 84 |
1859790 | 1859790 | 2021-10-28 | Harvey | Kansas | 20079 | 5071 | 81 |
1856541 | 1856541 | 2021-10-27 | Harvey | Kansas | 20079 | 5071 | 81 |
1853292 | 1853292 | 2021-10-26 | Harvey | Kansas | 20079 | 5032 | 80 |
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);