ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
673 rows where county = "Lincoln" and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175144 | 2175144 | 2022-02-02 | Lincoln | Kansas | 20105 | 603 | 8 |
2171891 | 2171891 | 2022-02-01 | Lincoln | Kansas | 20105 | 598 | 8 |
2168638 | 2168638 | 2022-01-31 | Lincoln | Kansas | 20105 | 598 | 8 |
2165383 | 2165383 | 2022-01-30 | Lincoln | Kansas | 20105 | 592 | 8 |
2162128 | 2162128 | 2022-01-29 | Lincoln | Kansas | 20105 | 592 | 8 |
2158873 | 2158873 | 2022-01-28 | Lincoln | Kansas | 20105 | 592 | 8 |
2155619 | 2155619 | 2022-01-27 | Lincoln | Kansas | 20105 | 582 | 8 |
2152366 | 2152366 | 2022-01-26 | Lincoln | Kansas | 20105 | 582 | 8 |
2149114 | 2149114 | 2022-01-25 | Lincoln | Kansas | 20105 | 566 | 8 |
2145862 | 2145862 | 2022-01-24 | Lincoln | Kansas | 20105 | 566 | 8 |
2142607 | 2142607 | 2022-01-23 | Lincoln | Kansas | 20105 | 559 | 8 |
2139352 | 2139352 | 2022-01-22 | Lincoln | Kansas | 20105 | 559 | 8 |
2136096 | 2136096 | 2022-01-21 | Lincoln | Kansas | 20105 | 559 | 8 |
2132844 | 2132844 | 2022-01-20 | Lincoln | Kansas | 20105 | 540 | 7 |
2129591 | 2129591 | 2022-01-19 | Lincoln | Kansas | 20105 | 540 | 7 |
2126337 | 2126337 | 2022-01-18 | Lincoln | Kansas | 20105 | 516 | 7 |
2123085 | 2123085 | 2022-01-17 | Lincoln | Kansas | 20105 | 516 | 7 |
2119833 | 2119833 | 2022-01-16 | Lincoln | Kansas | 20105 | 516 | 7 |
2116581 | 2116581 | 2022-01-15 | Lincoln | Kansas | 20105 | 516 | 7 |
2113330 | 2113330 | 2022-01-14 | Lincoln | Kansas | 20105 | 516 | 7 |
2110078 | 2110078 | 2022-01-13 | Lincoln | Kansas | 20105 | 497 | 7 |
2106827 | 2106827 | 2022-01-12 | Lincoln | Kansas | 20105 | 497 | 7 |
2103576 | 2103576 | 2022-01-11 | Lincoln | Kansas | 20105 | 481 | 7 |
2100325 | 2100325 | 2022-01-10 | Lincoln | Kansas | 20105 | 481 | 7 |
2097074 | 2097074 | 2022-01-09 | Lincoln | Kansas | 20105 | 476 | 7 |
2093822 | 2093822 | 2022-01-08 | Lincoln | Kansas | 20105 | 476 | 7 |
2090570 | 2090570 | 2022-01-07 | Lincoln | Kansas | 20105 | 476 | 7 |
2087319 | 2087319 | 2022-01-06 | Lincoln | Kansas | 20105 | 465 | 7 |
2084067 | 2084067 | 2022-01-05 | Lincoln | Kansas | 20105 | 465 | 7 |
2080815 | 2080815 | 2022-01-04 | Lincoln | Kansas | 20105 | 450 | 7 |
2077563 | 2077563 | 2022-01-03 | Lincoln | Kansas | 20105 | 450 | 7 |
2074312 | 2074312 | 2022-01-02 | Lincoln | Kansas | 20105 | 448 | 7 |
2071061 | 2071061 | 2022-01-01 | Lincoln | Kansas | 20105 | 448 | 7 |
2067810 | 2067810 | 2021-12-31 | Lincoln | Kansas | 20105 | 448 | 7 |
2064559 | 2064559 | 2021-12-30 | Lincoln | Kansas | 20105 | 448 | 7 |
2061309 | 2061309 | 2021-12-29 | Lincoln | Kansas | 20105 | 448 | 7 |
2058060 | 2058060 | 2021-12-28 | Lincoln | Kansas | 20105 | 443 | 7 |
2054811 | 2054811 | 2021-12-27 | Lincoln | Kansas | 20105 | 443 | 7 |
2051561 | 2051561 | 2021-12-26 | Lincoln | Kansas | 20105 | 440 | 7 |
2048311 | 2048311 | 2021-12-25 | Lincoln | Kansas | 20105 | 440 | 7 |
2045061 | 2045061 | 2021-12-24 | Lincoln | Kansas | 20105 | 440 | 7 |
2041812 | 2041812 | 2021-12-23 | Lincoln | Kansas | 20105 | 440 | 7 |
2038562 | 2038562 | 2021-12-22 | Lincoln | Kansas | 20105 | 440 | 7 |
2035312 | 2035312 | 2021-12-21 | Lincoln | Kansas | 20105 | 431 | 7 |
2032062 | 2032062 | 2021-12-20 | Lincoln | Kansas | 20105 | 431 | 7 |
2028811 | 2028811 | 2021-12-19 | Lincoln | Kansas | 20105 | 430 | 7 |
2025560 | 2025560 | 2021-12-18 | Lincoln | Kansas | 20105 | 430 | 7 |
2022309 | 2022309 | 2021-12-17 | Lincoln | Kansas | 20105 | 430 | 7 |
2019058 | 2019058 | 2021-12-16 | Lincoln | Kansas | 20105 | 426 | 7 |
2015808 | 2015808 | 2021-12-15 | Lincoln | Kansas | 20105 | 426 | 7 |
2012557 | 2012557 | 2021-12-14 | Lincoln | Kansas | 20105 | 422 | 7 |
2009306 | 2009306 | 2021-12-13 | Lincoln | Kansas | 20105 | 422 | 7 |
2006055 | 2006055 | 2021-12-12 | Lincoln | Kansas | 20105 | 422 | 7 |
2002804 | 2002804 | 2021-12-11 | Lincoln | Kansas | 20105 | 422 | 7 |
1999554 | 1999554 | 2021-12-10 | Lincoln | Kansas | 20105 | 422 | 7 |
1996303 | 1996303 | 2021-12-09 | Lincoln | Kansas | 20105 | 418 | 7 |
1993052 | 1993052 | 2021-12-08 | Lincoln | Kansas | 20105 | 418 | 7 |
1989801 | 1989801 | 2021-12-07 | Lincoln | Kansas | 20105 | 414 | 7 |
1986551 | 1986551 | 2021-12-06 | Lincoln | Kansas | 20105 | 414 | 7 |
1983301 | 1983301 | 2021-12-05 | Lincoln | Kansas | 20105 | 410 | 7 |
1980051 | 1980051 | 2021-12-04 | Lincoln | Kansas | 20105 | 410 | 7 |
1976801 | 1976801 | 2021-12-03 | Lincoln | Kansas | 20105 | 410 | 7 |
1973552 | 1973552 | 2021-12-02 | Lincoln | Kansas | 20105 | 403 | 7 |
1970302 | 1970302 | 2021-12-01 | Lincoln | Kansas | 20105 | 403 | 7 |
1967052 | 1967052 | 2021-11-30 | Lincoln | Kansas | 20105 | 398 | 7 |
1963800 | 1963800 | 2021-11-29 | Lincoln | Kansas | 20105 | 398 | 7 |
1960549 | 1960549 | 2021-11-28 | Lincoln | Kansas | 20105 | 396 | 6 |
1957298 | 1957298 | 2021-11-27 | Lincoln | Kansas | 20105 | 396 | 6 |
1954047 | 1954047 | 2021-11-26 | Lincoln | Kansas | 20105 | 396 | 6 |
1950796 | 1950796 | 2021-11-25 | Lincoln | Kansas | 20105 | 396 | 6 |
1947545 | 1947545 | 2021-11-24 | Lincoln | Kansas | 20105 | 396 | 6 |
1944294 | 1944294 | 2021-11-23 | Lincoln | Kansas | 20105 | 391 | 6 |
1941044 | 1941044 | 2021-11-22 | Lincoln | Kansas | 20105 | 391 | 6 |
1937794 | 1937794 | 2021-11-21 | Lincoln | Kansas | 20105 | 389 | 6 |
1934544 | 1934544 | 2021-11-20 | Lincoln | Kansas | 20105 | 389 | 6 |
1931293 | 1931293 | 2021-11-19 | Lincoln | Kansas | 20105 | 389 | 6 |
1928042 | 1928042 | 2021-11-18 | Lincoln | Kansas | 20105 | 386 | 6 |
1924792 | 1924792 | 2021-11-17 | Lincoln | Kansas | 20105 | 386 | 6 |
1921543 | 1921543 | 2021-11-16 | Lincoln | Kansas | 20105 | 384 | 6 |
1918293 | 1918293 | 2021-11-15 | Lincoln | Kansas | 20105 | 384 | 6 |
1915043 | 1915043 | 2021-11-14 | Lincoln | Kansas | 20105 | 380 | 6 |
1911793 | 1911793 | 2021-11-13 | Lincoln | Kansas | 20105 | 380 | 6 |
1908544 | 1908544 | 2021-11-12 | Lincoln | Kansas | 20105 | 380 | 6 |
1905295 | 1905295 | 2021-11-11 | Lincoln | Kansas | 20105 | 380 | 6 |
1902045 | 1902045 | 2021-11-10 | Lincoln | Kansas | 20105 | 380 | 6 |
1898795 | 1898795 | 2021-11-09 | Lincoln | Kansas | 20105 | 377 | 6 |
1895545 | 1895545 | 2021-11-08 | Lincoln | Kansas | 20105 | 377 | 6 |
1892295 | 1892295 | 2021-11-07 | Lincoln | Kansas | 20105 | 374 | 6 |
1889045 | 1889045 | 2021-11-06 | Lincoln | Kansas | 20105 | 374 | 6 |
1885795 | 1885795 | 2021-11-05 | Lincoln | Kansas | 20105 | 374 | 6 |
1882546 | 1882546 | 2021-11-04 | Lincoln | Kansas | 20105 | 369 | 6 |
1879297 | 1879297 | 2021-11-03 | Lincoln | Kansas | 20105 | 369 | 6 |
1876048 | 1876048 | 2021-11-02 | Lincoln | Kansas | 20105 | 364 | 6 |
1872799 | 1872799 | 2021-11-01 | Lincoln | Kansas | 20105 | 364 | 6 |
1869550 | 1869550 | 2021-10-31 | Lincoln | Kansas | 20105 | 362 | 6 |
1866301 | 1866301 | 2021-10-30 | Lincoln | Kansas | 20105 | 362 | 6 |
1863052 | 1863052 | 2021-10-29 | Lincoln | Kansas | 20105 | 362 | 6 |
1859803 | 1859803 | 2021-10-28 | Lincoln | Kansas | 20105 | 362 | 6 |
1856554 | 1856554 | 2021-10-27 | Lincoln | Kansas | 20105 | 362 | 6 |
1853305 | 1853305 | 2021-10-26 | Lincoln | Kansas | 20105 | 354 | 5 |
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);