ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where fips = 20091 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175137 | 2175137 | 2022-02-02 | Johnson | Kansas | 20091 | 137868 | 1117 |
2171884 | 2171884 | 2022-02-01 | Johnson | Kansas | 20091 | 135952 | 1108 |
2168631 | 2168631 | 2022-01-31 | Johnson | Kansas | 20091 | 135952 | 1108 |
2165376 | 2165376 | 2022-01-30 | Johnson | Kansas | 20091 | 134139 | 1104 |
2162121 | 2162121 | 2022-01-29 | Johnson | Kansas | 20091 | 134139 | 1104 |
2158866 | 2158866 | 2022-01-28 | Johnson | Kansas | 20091 | 134139 | 1104 |
2155612 | 2155612 | 2022-01-27 | Johnson | Kansas | 20091 | 131829 | 1094 |
2152359 | 2152359 | 2022-01-26 | Johnson | Kansas | 20091 | 131829 | 1094 |
2149107 | 2149107 | 2022-01-25 | Johnson | Kansas | 20091 | 129024 | 1082 |
2145855 | 2145855 | 2022-01-24 | Johnson | Kansas | 20091 | 129024 | 1082 |
2142600 | 2142600 | 2022-01-23 | Johnson | Kansas | 20091 | 126149 | 1075 |
2139345 | 2139345 | 2022-01-22 | Johnson | Kansas | 20091 | 126149 | 1075 |
2136089 | 2136089 | 2022-01-21 | Johnson | Kansas | 20091 | 126149 | 1075 |
2132837 | 2132837 | 2022-01-20 | Johnson | Kansas | 20091 | 122002 | 1065 |
2129584 | 2129584 | 2022-01-19 | Johnson | Kansas | 20091 | 122002 | 1065 |
2126330 | 2126330 | 2022-01-18 | Johnson | Kansas | 20091 | 114647 | 1049 |
2123078 | 2123078 | 2022-01-17 | Johnson | Kansas | 20091 | 114647 | 1049 |
2119826 | 2119826 | 2022-01-16 | Johnson | Kansas | 20091 | 114647 | 1049 |
2116574 | 2116574 | 2022-01-15 | Johnson | Kansas | 20091 | 114647 | 1049 |
2113323 | 2113323 | 2022-01-14 | Johnson | Kansas | 20091 | 114647 | 1049 |
2110071 | 2110071 | 2022-01-13 | Johnson | Kansas | 20091 | 111258 | 1042 |
2106820 | 2106820 | 2022-01-12 | Johnson | Kansas | 20091 | 111258 | 1042 |
2103569 | 2103569 | 2022-01-11 | Johnson | Kansas | 20091 | 107251 | 1036 |
2100318 | 2100318 | 2022-01-10 | Johnson | Kansas | 20091 | 107251 | 1036 |
2097067 | 2097067 | 2022-01-09 | Johnson | Kansas | 20091 | 103796 | 1030 |
2093815 | 2093815 | 2022-01-08 | Johnson | Kansas | 20091 | 103796 | 1030 |
2090563 | 2090563 | 2022-01-07 | Johnson | Kansas | 20091 | 103796 | 1030 |
2087312 | 2087312 | 2022-01-06 | Johnson | Kansas | 20091 | 99894 | 1024 |
2084060 | 2084060 | 2022-01-05 | Johnson | Kansas | 20091 | 99894 | 1024 |
2080808 | 2080808 | 2022-01-04 | Johnson | Kansas | 20091 | 96517 | 1015 |
2077556 | 2077556 | 2022-01-03 | Johnson | Kansas | 20091 | 96517 | 1015 |
2074305 | 2074305 | 2022-01-02 | Johnson | Kansas | 20091 | 92698 | 1005 |
2071054 | 2071054 | 2022-01-01 | Johnson | Kansas | 20091 | 92698 | 1005 |
2067803 | 2067803 | 2021-12-31 | Johnson | Kansas | 20091 | 92698 | 1005 |
2064552 | 2064552 | 2021-12-30 | Johnson | Kansas | 20091 | 92698 | 1005 |
2061302 | 2061302 | 2021-12-29 | Johnson | Kansas | 20091 | 92698 | 1005 |
2058053 | 2058053 | 2021-12-28 | Johnson | Kansas | 20091 | 91226 | 997 |
2054804 | 2054804 | 2021-12-27 | Johnson | Kansas | 20091 | 91226 | 997 |
2051554 | 2051554 | 2021-12-26 | Johnson | Kansas | 20091 | 89623 | 996 |
2048304 | 2048304 | 2021-12-25 | Johnson | Kansas | 20091 | 89623 | 996 |
2045054 | 2045054 | 2021-12-24 | Johnson | Kansas | 20091 | 89623 | 996 |
2041805 | 2041805 | 2021-12-23 | Johnson | Kansas | 20091 | 89623 | 996 |
2038555 | 2038555 | 2021-12-22 | Johnson | Kansas | 20091 | 89623 | 996 |
2035305 | 2035305 | 2021-12-21 | Johnson | Kansas | 20091 | 88797 | 992 |
2032055 | 2032055 | 2021-12-20 | Johnson | Kansas | 20091 | 88797 | 992 |
2028804 | 2028804 | 2021-12-19 | Johnson | Kansas | 20091 | 88199 | 989 |
2025553 | 2025553 | 2021-12-18 | Johnson | Kansas | 20091 | 88199 | 989 |
2022302 | 2022302 | 2021-12-17 | Johnson | Kansas | 20091 | 88199 | 989 |
2019051 | 2019051 | 2021-12-16 | Johnson | Kansas | 20091 | 87345 | 986 |
2015801 | 2015801 | 2021-12-15 | Johnson | Kansas | 20091 | 87345 | 986 |
2012550 | 2012550 | 2021-12-14 | Johnson | Kansas | 20091 | 86681 | 983 |
2009299 | 2009299 | 2021-12-13 | Johnson | Kansas | 20091 | 86681 | 983 |
2006048 | 2006048 | 2021-12-12 | Johnson | Kansas | 20091 | 86028 | 981 |
2002797 | 2002797 | 2021-12-11 | Johnson | Kansas | 20091 | 86028 | 981 |
1999547 | 1999547 | 2021-12-10 | Johnson | Kansas | 20091 | 86028 | 981 |
1996296 | 1996296 | 2021-12-09 | Johnson | Kansas | 20091 | 85316 | 978 |
1993045 | 1993045 | 2021-12-08 | Johnson | Kansas | 20091 | 85316 | 978 |
1989794 | 1989794 | 2021-12-07 | Johnson | Kansas | 20091 | 84641 | 974 |
1986544 | 1986544 | 2021-12-06 | Johnson | Kansas | 20091 | 84641 | 974 |
1983294 | 1983294 | 2021-12-05 | Johnson | Kansas | 20091 | 84047 | 973 |
1980044 | 1980044 | 2021-12-04 | Johnson | Kansas | 20091 | 84047 | 973 |
1976794 | 1976794 | 2021-12-03 | Johnson | Kansas | 20091 | 84047 | 973 |
1973545 | 1973545 | 2021-12-02 | Johnson | Kansas | 20091 | 83128 | 971 |
1970295 | 1970295 | 2021-12-01 | Johnson | Kansas | 20091 | 83128 | 971 |
1967045 | 1967045 | 2021-11-30 | Johnson | Kansas | 20091 | 82542 | 969 |
1963793 | 1963793 | 2021-11-29 | Johnson | Kansas | 20091 | 82542 | 969 |
1960542 | 1960542 | 2021-11-28 | Johnson | Kansas | 20091 | 81815 | 963 |
1957291 | 1957291 | 2021-11-27 | Johnson | Kansas | 20091 | 81815 | 963 |
1954040 | 1954040 | 2021-11-26 | Johnson | Kansas | 20091 | 81815 | 963 |
1950789 | 1950789 | 2021-11-25 | Johnson | Kansas | 20091 | 81815 | 963 |
1947538 | 1947538 | 2021-11-24 | Johnson | Kansas | 20091 | 81815 | 963 |
1944287 | 1944287 | 2021-11-23 | Johnson | Kansas | 20091 | 81472 | 960 |
1941037 | 1941037 | 2021-11-22 | Johnson | Kansas | 20091 | 81472 | 960 |
1937787 | 1937787 | 2021-11-21 | Johnson | Kansas | 20091 | 81055 | 960 |
1934537 | 1934537 | 2021-11-20 | Johnson | Kansas | 20091 | 81055 | 960 |
1931286 | 1931286 | 2021-11-19 | Johnson | Kansas | 20091 | 81055 | 960 |
1928035 | 1928035 | 2021-11-18 | Johnson | Kansas | 20091 | 80595 | 958 |
1924785 | 1924785 | 2021-11-17 | Johnson | Kansas | 20091 | 80595 | 958 |
1921536 | 1921536 | 2021-11-16 | Johnson | Kansas | 20091 | 80155 | 954 |
1918286 | 1918286 | 2021-11-15 | Johnson | Kansas | 20091 | 80155 | 954 |
1915036 | 1915036 | 2021-11-14 | Johnson | Kansas | 20091 | 79838 | 952 |
1911786 | 1911786 | 2021-11-13 | Johnson | Kansas | 20091 | 79838 | 952 |
1908537 | 1908537 | 2021-11-12 | Johnson | Kansas | 20091 | 79838 | 952 |
1905288 | 1905288 | 2021-11-11 | Johnson | Kansas | 20091 | 79476 | 952 |
1902038 | 1902038 | 2021-11-10 | Johnson | Kansas | 20091 | 79476 | 952 |
1898788 | 1898788 | 2021-11-09 | Johnson | Kansas | 20091 | 79145 | 950 |
1895538 | 1895538 | 2021-11-08 | Johnson | Kansas | 20091 | 79145 | 950 |
1892288 | 1892288 | 2021-11-07 | Johnson | Kansas | 20091 | 78852 | 944 |
1889038 | 1889038 | 2021-11-06 | Johnson | Kansas | 20091 | 78852 | 944 |
1885788 | 1885788 | 2021-11-05 | Johnson | Kansas | 20091 | 78852 | 944 |
1882539 | 1882539 | 2021-11-04 | Johnson | Kansas | 20091 | 78574 | 941 |
1879290 | 1879290 | 2021-11-03 | Johnson | Kansas | 20091 | 78574 | 941 |
1876041 | 1876041 | 2021-11-02 | Johnson | Kansas | 20091 | 78348 | 934 |
1872792 | 1872792 | 2021-11-01 | Johnson | Kansas | 20091 | 78348 | 934 |
1869543 | 1869543 | 2021-10-31 | Johnson | Kansas | 20091 | 78177 | 932 |
1866294 | 1866294 | 2021-10-30 | Johnson | Kansas | 20091 | 78177 | 932 |
1863045 | 1863045 | 2021-10-29 | Johnson | Kansas | 20091 | 78177 | 932 |
1859796 | 1859796 | 2021-10-28 | Johnson | Kansas | 20091 | 77880 | 931 |
1856547 | 1856547 | 2021-10-27 | Johnson | Kansas | 20091 | 77880 | 931 |
1853298 | 1853298 | 2021-10-26 | Johnson | Kansas | 20091 | 77583 | 921 |
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);