ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Mitchell" and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175153 | 2175153 | 2022-02-02 | Mitchell | Kansas | 20123 | 1378 | 18 |
2171900 | 2171900 | 2022-02-01 | Mitchell | Kansas | 20123 | 1356 | 18 |
2168647 | 2168647 | 2022-01-31 | Mitchell | Kansas | 20123 | 1356 | 18 |
2165392 | 2165392 | 2022-01-30 | Mitchell | Kansas | 20123 | 1345 | 18 |
2162137 | 2162137 | 2022-01-29 | Mitchell | Kansas | 20123 | 1345 | 18 |
2158882 | 2158882 | 2022-01-28 | Mitchell | Kansas | 20123 | 1345 | 18 |
2155628 | 2155628 | 2022-01-27 | Mitchell | Kansas | 20123 | 1323 | 18 |
2152375 | 2152375 | 2022-01-26 | Mitchell | Kansas | 20123 | 1323 | 18 |
2149123 | 2149123 | 2022-01-25 | Mitchell | Kansas | 20123 | 1291 | 18 |
2145871 | 2145871 | 2022-01-24 | Mitchell | Kansas | 20123 | 1291 | 18 |
2142616 | 2142616 | 2022-01-23 | Mitchell | Kansas | 20123 | 1259 | 18 |
2139361 | 2139361 | 2022-01-22 | Mitchell | Kansas | 20123 | 1259 | 18 |
2136105 | 2136105 | 2022-01-21 | Mitchell | Kansas | 20123 | 1259 | 18 |
2132853 | 2132853 | 2022-01-20 | Mitchell | Kansas | 20123 | 1202 | 18 |
2129600 | 2129600 | 2022-01-19 | Mitchell | Kansas | 20123 | 1202 | 18 |
2126346 | 2126346 | 2022-01-18 | Mitchell | Kansas | 20123 | 1073 | 18 |
2123094 | 2123094 | 2022-01-17 | Mitchell | Kansas | 20123 | 1073 | 18 |
2119842 | 2119842 | 2022-01-16 | Mitchell | Kansas | 20123 | 1073 | 18 |
2116590 | 2116590 | 2022-01-15 | Mitchell | Kansas | 20123 | 1073 | 18 |
2113339 | 2113339 | 2022-01-14 | Mitchell | Kansas | 20123 | 1073 | 18 |
2110087 | 2110087 | 2022-01-13 | Mitchell | Kansas | 20123 | 1033 | 18 |
2106836 | 2106836 | 2022-01-12 | Mitchell | Kansas | 20123 | 1033 | 18 |
2103585 | 2103585 | 2022-01-11 | Mitchell | Kansas | 20123 | 997 | 17 |
2100334 | 2100334 | 2022-01-10 | Mitchell | Kansas | 20123 | 997 | 17 |
2097083 | 2097083 | 2022-01-09 | Mitchell | Kansas | 20123 | 985 | 17 |
2093831 | 2093831 | 2022-01-08 | Mitchell | Kansas | 20123 | 985 | 17 |
2090579 | 2090579 | 2022-01-07 | Mitchell | Kansas | 20123 | 985 | 17 |
2087328 | 2087328 | 2022-01-06 | Mitchell | Kansas | 20123 | 971 | 17 |
2084076 | 2084076 | 2022-01-05 | Mitchell | Kansas | 20123 | 971 | 17 |
2080824 | 2080824 | 2022-01-04 | Mitchell | Kansas | 20123 | 945 | 17 |
2077572 | 2077572 | 2022-01-03 | Mitchell | Kansas | 20123 | 945 | 17 |
2074321 | 2074321 | 2022-01-02 | Mitchell | Kansas | 20123 | 931 | 17 |
2071070 | 2071070 | 2022-01-01 | Mitchell | Kansas | 20123 | 931 | 17 |
2067819 | 2067819 | 2021-12-31 | Mitchell | Kansas | 20123 | 931 | 17 |
2064568 | 2064568 | 2021-12-30 | Mitchell | Kansas | 20123 | 931 | 17 |
2061318 | 2061318 | 2021-12-29 | Mitchell | Kansas | 20123 | 931 | 17 |
2058069 | 2058069 | 2021-12-28 | Mitchell | Kansas | 20123 | 924 | 17 |
2054820 | 2054820 | 2021-12-27 | Mitchell | Kansas | 20123 | 924 | 17 |
2051570 | 2051570 | 2021-12-26 | Mitchell | Kansas | 20123 | 920 | 17 |
2048320 | 2048320 | 2021-12-25 | Mitchell | Kansas | 20123 | 920 | 17 |
2045070 | 2045070 | 2021-12-24 | Mitchell | Kansas | 20123 | 920 | 17 |
2041821 | 2041821 | 2021-12-23 | Mitchell | Kansas | 20123 | 920 | 17 |
2038571 | 2038571 | 2021-12-22 | Mitchell | Kansas | 20123 | 920 | 17 |
2035321 | 2035321 | 2021-12-21 | Mitchell | Kansas | 20123 | 917 | 17 |
2032071 | 2032071 | 2021-12-20 | Mitchell | Kansas | 20123 | 917 | 17 |
2028820 | 2028820 | 2021-12-19 | Mitchell | Kansas | 20123 | 915 | 17 |
2025569 | 2025569 | 2021-12-18 | Mitchell | Kansas | 20123 | 915 | 17 |
2022318 | 2022318 | 2021-12-17 | Mitchell | Kansas | 20123 | 915 | 17 |
2019067 | 2019067 | 2021-12-16 | Mitchell | Kansas | 20123 | 914 | 17 |
2015817 | 2015817 | 2021-12-15 | Mitchell | Kansas | 20123 | 914 | 17 |
2012566 | 2012566 | 2021-12-14 | Mitchell | Kansas | 20123 | 909 | 17 |
2009315 | 2009315 | 2021-12-13 | Mitchell | Kansas | 20123 | 909 | 17 |
2006064 | 2006064 | 2021-12-12 | Mitchell | Kansas | 20123 | 906 | 17 |
2002813 | 2002813 | 2021-12-11 | Mitchell | Kansas | 20123 | 906 | 17 |
1999563 | 1999563 | 2021-12-10 | Mitchell | Kansas | 20123 | 906 | 17 |
1996312 | 1996312 | 2021-12-09 | Mitchell | Kansas | 20123 | 898 | 17 |
1993061 | 1993061 | 2021-12-08 | Mitchell | Kansas | 20123 | 898 | 17 |
1989810 | 1989810 | 2021-12-07 | Mitchell | Kansas | 20123 | 890 | 17 |
1986560 | 1986560 | 2021-12-06 | Mitchell | Kansas | 20123 | 890 | 17 |
1983310 | 1983310 | 2021-12-05 | Mitchell | Kansas | 20123 | 888 | 17 |
1980060 | 1980060 | 2021-12-04 | Mitchell | Kansas | 20123 | 888 | 17 |
1976810 | 1976810 | 2021-12-03 | Mitchell | Kansas | 20123 | 888 | 17 |
1973561 | 1973561 | 2021-12-02 | Mitchell | Kansas | 20123 | 884 | 17 |
1970311 | 1970311 | 2021-12-01 | Mitchell | Kansas | 20123 | 884 | 17 |
1967061 | 1967061 | 2021-11-30 | Mitchell | Kansas | 20123 | 879 | 17 |
1963809 | 1963809 | 2021-11-29 | Mitchell | Kansas | 20123 | 879 | 17 |
1960558 | 1960558 | 2021-11-28 | Mitchell | Kansas | 20123 | 870 | 17 |
1957307 | 1957307 | 2021-11-27 | Mitchell | Kansas | 20123 | 870 | 17 |
1954056 | 1954056 | 2021-11-26 | Mitchell | Kansas | 20123 | 870 | 17 |
1950805 | 1950805 | 2021-11-25 | Mitchell | Kansas | 20123 | 870 | 17 |
1947554 | 1947554 | 2021-11-24 | Mitchell | Kansas | 20123 | 870 | 17 |
1944303 | 1944303 | 2021-11-23 | Mitchell | Kansas | 20123 | 868 | 17 |
1941053 | 1941053 | 2021-11-22 | Mitchell | Kansas | 20123 | 868 | 17 |
1937803 | 1937803 | 2021-11-21 | Mitchell | Kansas | 20123 | 867 | 17 |
1934553 | 1934553 | 2021-11-20 | Mitchell | Kansas | 20123 | 867 | 17 |
1931302 | 1931302 | 2021-11-19 | Mitchell | Kansas | 20123 | 867 | 17 |
1928051 | 1928051 | 2021-11-18 | Mitchell | Kansas | 20123 | 865 | 17 |
1924801 | 1924801 | 2021-11-17 | Mitchell | Kansas | 20123 | 865 | 17 |
1921552 | 1921552 | 2021-11-16 | Mitchell | Kansas | 20123 | 849 | 17 |
1918302 | 1918302 | 2021-11-15 | Mitchell | Kansas | 20123 | 849 | 17 |
1915052 | 1915052 | 2021-11-14 | Mitchell | Kansas | 20123 | 845 | 17 |
1911802 | 1911802 | 2021-11-13 | Mitchell | Kansas | 20123 | 845 | 17 |
1908553 | 1908553 | 2021-11-12 | Mitchell | Kansas | 20123 | 845 | 17 |
1905304 | 1905304 | 2021-11-11 | Mitchell | Kansas | 20123 | 832 | 17 |
1902054 | 1902054 | 2021-11-10 | Mitchell | Kansas | 20123 | 832 | 17 |
1898804 | 1898804 | 2021-11-09 | Mitchell | Kansas | 20123 | 820 | 16 |
1895554 | 1895554 | 2021-11-08 | Mitchell | Kansas | 20123 | 820 | 16 |
1892304 | 1892304 | 2021-11-07 | Mitchell | Kansas | 20123 | 815 | 16 |
1889054 | 1889054 | 2021-11-06 | Mitchell | Kansas | 20123 | 815 | 16 |
1885804 | 1885804 | 2021-11-05 | Mitchell | Kansas | 20123 | 815 | 16 |
1882555 | 1882555 | 2021-11-04 | Mitchell | Kansas | 20123 | 806 | 16 |
1879306 | 1879306 | 2021-11-03 | Mitchell | Kansas | 20123 | 806 | 16 |
1876057 | 1876057 | 2021-11-02 | Mitchell | Kansas | 20123 | 793 | 16 |
1872808 | 1872808 | 2021-11-01 | Mitchell | Kansas | 20123 | 793 | 16 |
1869559 | 1869559 | 2021-10-31 | Mitchell | Kansas | 20123 | 791 | 16 |
1866310 | 1866310 | 2021-10-30 | Mitchell | Kansas | 20123 | 791 | 16 |
1863061 | 1863061 | 2021-10-29 | Mitchell | Kansas | 20123 | 791 | 16 |
1859812 | 1859812 | 2021-10-28 | Mitchell | Kansas | 20123 | 779 | 16 |
1856563 | 1856563 | 2021-10-27 | Mitchell | Kansas | 20123 | 779 | 16 |
1853314 | 1853314 | 2021-10-26 | Mitchell | Kansas | 20123 | 771 | 16 |
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);