ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
684 rows where county = "Rush" and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175174 | 2175174 | 2022-02-02 | Rush | Kansas | 20165 | 780 | 17 |
2171921 | 2171921 | 2022-02-01 | Rush | Kansas | 20165 | 774 | 17 |
2168668 | 2168668 | 2022-01-31 | Rush | Kansas | 20165 | 774 | 17 |
2165413 | 2165413 | 2022-01-30 | Rush | Kansas | 20165 | 764 | 17 |
2162158 | 2162158 | 2022-01-29 | Rush | Kansas | 20165 | 764 | 17 |
2158903 | 2158903 | 2022-01-28 | Rush | Kansas | 20165 | 764 | 17 |
2155649 | 2155649 | 2022-01-27 | Rush | Kansas | 20165 | 754 | 17 |
2152396 | 2152396 | 2022-01-26 | Rush | Kansas | 20165 | 754 | 17 |
2149144 | 2149144 | 2022-01-25 | Rush | Kansas | 20165 | 744 | 17 |
2145892 | 2145892 | 2022-01-24 | Rush | Kansas | 20165 | 744 | 17 |
2142637 | 2142637 | 2022-01-23 | Rush | Kansas | 20165 | 737 | 17 |
2139382 | 2139382 | 2022-01-22 | Rush | Kansas | 20165 | 737 | 17 |
2136126 | 2136126 | 2022-01-21 | Rush | Kansas | 20165 | 737 | 17 |
2132874 | 2132874 | 2022-01-20 | Rush | Kansas | 20165 | 726 | 17 |
2129621 | 2129621 | 2022-01-19 | Rush | Kansas | 20165 | 726 | 17 |
2126367 | 2126367 | 2022-01-18 | Rush | Kansas | 20165 | 672 | 16 |
2123115 | 2123115 | 2022-01-17 | Rush | Kansas | 20165 | 672 | 16 |
2119863 | 2119863 | 2022-01-16 | Rush | Kansas | 20165 | 672 | 16 |
2116611 | 2116611 | 2022-01-15 | Rush | Kansas | 20165 | 672 | 16 |
2113360 | 2113360 | 2022-01-14 | Rush | Kansas | 20165 | 672 | 16 |
2110108 | 2110108 | 2022-01-13 | Rush | Kansas | 20165 | 653 | 16 |
2106857 | 2106857 | 2022-01-12 | Rush | Kansas | 20165 | 653 | 16 |
2103606 | 2103606 | 2022-01-11 | Rush | Kansas | 20165 | 639 | 16 |
2100355 | 2100355 | 2022-01-10 | Rush | Kansas | 20165 | 639 | 16 |
2097104 | 2097104 | 2022-01-09 | Rush | Kansas | 20165 | 632 | 16 |
2093852 | 2093852 | 2022-01-08 | Rush | Kansas | 20165 | 632 | 16 |
2090600 | 2090600 | 2022-01-07 | Rush | Kansas | 20165 | 632 | 16 |
2087349 | 2087349 | 2022-01-06 | Rush | Kansas | 20165 | 619 | 16 |
2084097 | 2084097 | 2022-01-05 | Rush | Kansas | 20165 | 619 | 16 |
2080845 | 2080845 | 2022-01-04 | Rush | Kansas | 20165 | 612 | 16 |
2077593 | 2077593 | 2022-01-03 | Rush | Kansas | 20165 | 612 | 16 |
2074342 | 2074342 | 2022-01-02 | Rush | Kansas | 20165 | 608 | 16 |
2071091 | 2071091 | 2022-01-01 | Rush | Kansas | 20165 | 608 | 16 |
2067840 | 2067840 | 2021-12-31 | Rush | Kansas | 20165 | 608 | 16 |
2064589 | 2064589 | 2021-12-30 | Rush | Kansas | 20165 | 608 | 16 |
2061339 | 2061339 | 2021-12-29 | Rush | Kansas | 20165 | 608 | 16 |
2058090 | 2058090 | 2021-12-28 | Rush | Kansas | 20165 | 601 | 16 |
2054841 | 2054841 | 2021-12-27 | Rush | Kansas | 20165 | 601 | 16 |
2051591 | 2051591 | 2021-12-26 | Rush | Kansas | 20165 | 594 | 16 |
2048341 | 2048341 | 2021-12-25 | Rush | Kansas | 20165 | 594 | 16 |
2045091 | 2045091 | 2021-12-24 | Rush | Kansas | 20165 | 594 | 16 |
2041842 | 2041842 | 2021-12-23 | Rush | Kansas | 20165 | 594 | 16 |
2038592 | 2038592 | 2021-12-22 | Rush | Kansas | 20165 | 594 | 16 |
2035342 | 2035342 | 2021-12-21 | Rush | Kansas | 20165 | 589 | 16 |
2032092 | 2032092 | 2021-12-20 | Rush | Kansas | 20165 | 589 | 16 |
2028841 | 2028841 | 2021-12-19 | Rush | Kansas | 20165 | 586 | 16 |
2025590 | 2025590 | 2021-12-18 | Rush | Kansas | 20165 | 586 | 16 |
2022339 | 2022339 | 2021-12-17 | Rush | Kansas | 20165 | 586 | 16 |
2019088 | 2019088 | 2021-12-16 | Rush | Kansas | 20165 | 582 | 16 |
2015838 | 2015838 | 2021-12-15 | Rush | Kansas | 20165 | 582 | 16 |
2012587 | 2012587 | 2021-12-14 | Rush | Kansas | 20165 | 577 | 16 |
2009336 | 2009336 | 2021-12-13 | Rush | Kansas | 20165 | 577 | 16 |
2006085 | 2006085 | 2021-12-12 | Rush | Kansas | 20165 | 575 | 16 |
2002834 | 2002834 | 2021-12-11 | Rush | Kansas | 20165 | 575 | 16 |
1999584 | 1999584 | 2021-12-10 | Rush | Kansas | 20165 | 575 | 16 |
1996333 | 1996333 | 2021-12-09 | Rush | Kansas | 20165 | 573 | 16 |
1993082 | 1993082 | 2021-12-08 | Rush | Kansas | 20165 | 573 | 16 |
1989831 | 1989831 | 2021-12-07 | Rush | Kansas | 20165 | 566 | 16 |
1986581 | 1986581 | 2021-12-06 | Rush | Kansas | 20165 | 566 | 16 |
1983331 | 1983331 | 2021-12-05 | Rush | Kansas | 20165 | 565 | 16 |
1980081 | 1980081 | 2021-12-04 | Rush | Kansas | 20165 | 565 | 16 |
1976831 | 1976831 | 2021-12-03 | Rush | Kansas | 20165 | 565 | 16 |
1973582 | 1973582 | 2021-12-02 | Rush | Kansas | 20165 | 562 | 16 |
1970332 | 1970332 | 2021-12-01 | Rush | Kansas | 20165 | 562 | 16 |
1967082 | 1967082 | 2021-11-30 | Rush | Kansas | 20165 | 556 | 16 |
1963830 | 1963830 | 2021-11-29 | Rush | Kansas | 20165 | 556 | 16 |
1960579 | 1960579 | 2021-11-28 | Rush | Kansas | 20165 | 555 | 16 |
1957328 | 1957328 | 2021-11-27 | Rush | Kansas | 20165 | 555 | 16 |
1954077 | 1954077 | 2021-11-26 | Rush | Kansas | 20165 | 555 | 16 |
1950826 | 1950826 | 2021-11-25 | Rush | Kansas | 20165 | 555 | 16 |
1947575 | 1947575 | 2021-11-24 | Rush | Kansas | 20165 | 555 | 16 |
1944324 | 1944324 | 2021-11-23 | Rush | Kansas | 20165 | 549 | 16 |
1941074 | 1941074 | 2021-11-22 | Rush | Kansas | 20165 | 549 | 16 |
1937824 | 1937824 | 2021-11-21 | Rush | Kansas | 20165 | 547 | 16 |
1934574 | 1934574 | 2021-11-20 | Rush | Kansas | 20165 | 547 | 16 |
1931323 | 1931323 | 2021-11-19 | Rush | Kansas | 20165 | 547 | 16 |
1928072 | 1928072 | 2021-11-18 | Rush | Kansas | 20165 | 543 | 16 |
1924822 | 1924822 | 2021-11-17 | Rush | Kansas | 20165 | 543 | 16 |
1921573 | 1921573 | 2021-11-16 | Rush | Kansas | 20165 | 539 | 16 |
1918323 | 1918323 | 2021-11-15 | Rush | Kansas | 20165 | 539 | 16 |
1915073 | 1915073 | 2021-11-14 | Rush | Kansas | 20165 | 534 | 16 |
1911823 | 1911823 | 2021-11-13 | Rush | Kansas | 20165 | 534 | 16 |
1908574 | 1908574 | 2021-11-12 | Rush | Kansas | 20165 | 534 | 16 |
1905325 | 1905325 | 2021-11-11 | Rush | Kansas | 20165 | 527 | 16 |
1902075 | 1902075 | 2021-11-10 | Rush | Kansas | 20165 | 527 | 16 |
1898825 | 1898825 | 2021-11-09 | Rush | Kansas | 20165 | 524 | 16 |
1895575 | 1895575 | 2021-11-08 | Rush | Kansas | 20165 | 524 | 16 |
1892325 | 1892325 | 2021-11-07 | Rush | Kansas | 20165 | 519 | 16 |
1889075 | 1889075 | 2021-11-06 | Rush | Kansas | 20165 | 519 | 16 |
1885825 | 1885825 | 2021-11-05 | Rush | Kansas | 20165 | 519 | 16 |
1882576 | 1882576 | 2021-11-04 | Rush | Kansas | 20165 | 519 | 16 |
1879327 | 1879327 | 2021-11-03 | Rush | Kansas | 20165 | 519 | 16 |
1876078 | 1876078 | 2021-11-02 | Rush | Kansas | 20165 | 515 | 16 |
1872829 | 1872829 | 2021-11-01 | Rush | Kansas | 20165 | 515 | 16 |
1869580 | 1869580 | 2021-10-31 | Rush | Kansas | 20165 | 515 | 16 |
1866331 | 1866331 | 2021-10-30 | Rush | Kansas | 20165 | 515 | 16 |
1863082 | 1863082 | 2021-10-29 | Rush | Kansas | 20165 | 515 | 16 |
1859833 | 1859833 | 2021-10-28 | Rush | Kansas | 20165 | 508 | 15 |
1856584 | 1856584 | 2021-10-27 | Rush | Kansas | 20165 | 508 | 15 |
1853335 | 1853335 | 2021-10-26 | Rush | Kansas | 20165 | 506 | 15 |
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);