ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Franklin", fips = 20059 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175121 | 2175121 | 2022-02-02 | Franklin | Kansas | 20059 | 6681 | 76 |
2171868 | 2171868 | 2022-02-01 | Franklin | Kansas | 20059 | 6606 | 70 |
2168615 | 2168615 | 2022-01-31 | Franklin | Kansas | 20059 | 6606 | 70 |
2165360 | 2165360 | 2022-01-30 | Franklin | Kansas | 20059 | 6555 | 70 |
2162105 | 2162105 | 2022-01-29 | Franklin | Kansas | 20059 | 6555 | 70 |
2158850 | 2158850 | 2022-01-28 | Franklin | Kansas | 20059 | 6555 | 70 |
2155596 | 2155596 | 2022-01-27 | Franklin | Kansas | 20059 | 6483 | 69 |
2152343 | 2152343 | 2022-01-26 | Franklin | Kansas | 20059 | 6483 | 69 |
2149091 | 2149091 | 2022-01-25 | Franklin | Kansas | 20059 | 6401 | 68 |
2145839 | 2145839 | 2022-01-24 | Franklin | Kansas | 20059 | 6401 | 68 |
2142584 | 2142584 | 2022-01-23 | Franklin | Kansas | 20059 | 6308 | 68 |
2139329 | 2139329 | 2022-01-22 | Franklin | Kansas | 20059 | 6308 | 68 |
2136073 | 2136073 | 2022-01-21 | Franklin | Kansas | 20059 | 6308 | 68 |
2132821 | 2132821 | 2022-01-20 | Franklin | Kansas | 20059 | 6154 | 68 |
2129568 | 2129568 | 2022-01-19 | Franklin | Kansas | 20059 | 6154 | 68 |
2126314 | 2126314 | 2022-01-18 | Franklin | Kansas | 20059 | 5832 | 67 |
2123062 | 2123062 | 2022-01-17 | Franklin | Kansas | 20059 | 5832 | 67 |
2119810 | 2119810 | 2022-01-16 | Franklin | Kansas | 20059 | 5832 | 67 |
2116558 | 2116558 | 2022-01-15 | Franklin | Kansas | 20059 | 5832 | 67 |
2113307 | 2113307 | 2022-01-14 | Franklin | Kansas | 20059 | 5832 | 67 |
2110055 | 2110055 | 2022-01-13 | Franklin | Kansas | 20059 | 5628 | 67 |
2106804 | 2106804 | 2022-01-12 | Franklin | Kansas | 20059 | 5628 | 67 |
2103553 | 2103553 | 2022-01-11 | Franklin | Kansas | 20059 | 5399 | 68 |
2100302 | 2100302 | 2022-01-10 | Franklin | Kansas | 20059 | 5399 | 68 |
2097051 | 2097051 | 2022-01-09 | Franklin | Kansas | 20059 | 5278 | 68 |
2093799 | 2093799 | 2022-01-08 | Franklin | Kansas | 20059 | 5278 | 68 |
2090547 | 2090547 | 2022-01-07 | Franklin | Kansas | 20059 | 5278 | 68 |
2087296 | 2087296 | 2022-01-06 | Franklin | Kansas | 20059 | 5123 | 68 |
2084044 | 2084044 | 2022-01-05 | Franklin | Kansas | 20059 | 5123 | 68 |
2080792 | 2080792 | 2022-01-04 | Franklin | Kansas | 20059 | 5000 | 68 |
2077540 | 2077540 | 2022-01-03 | Franklin | Kansas | 20059 | 5000 | 68 |
2074289 | 2074289 | 2022-01-02 | Franklin | Kansas | 20059 | 4773 | 67 |
2071038 | 2071038 | 2022-01-01 | Franklin | Kansas | 20059 | 4773 | 67 |
2067787 | 2067787 | 2021-12-31 | Franklin | Kansas | 20059 | 4773 | 67 |
2064536 | 2064536 | 2021-12-30 | Franklin | Kansas | 20059 | 4773 | 67 |
2061286 | 2061286 | 2021-12-29 | Franklin | Kansas | 20059 | 4773 | 67 |
2058037 | 2058037 | 2021-12-28 | Franklin | Kansas | 20059 | 4663 | 67 |
2054788 | 2054788 | 2021-12-27 | Franklin | Kansas | 20059 | 4663 | 67 |
2051538 | 2051538 | 2021-12-26 | Franklin | Kansas | 20059 | 4539 | 67 |
2048288 | 2048288 | 2021-12-25 | Franklin | Kansas | 20059 | 4539 | 67 |
2045038 | 2045038 | 2021-12-24 | Franklin | Kansas | 20059 | 4539 | 67 |
2041789 | 2041789 | 2021-12-23 | Franklin | Kansas | 20059 | 4539 | 67 |
2038539 | 2038539 | 2021-12-22 | Franklin | Kansas | 20059 | 4539 | 67 |
2035289 | 2035289 | 2021-12-21 | Franklin | Kansas | 20059 | 4462 | 66 |
2032039 | 2032039 | 2021-12-20 | Franklin | Kansas | 20059 | 4462 | 66 |
2028788 | 2028788 | 2021-12-19 | Franklin | Kansas | 20059 | 4421 | 66 |
2025537 | 2025537 | 2021-12-18 | Franklin | Kansas | 20059 | 4421 | 66 |
2022286 | 2022286 | 2021-12-17 | Franklin | Kansas | 20059 | 4421 | 66 |
2019035 | 2019035 | 2021-12-16 | Franklin | Kansas | 20059 | 4376 | 65 |
2015785 | 2015785 | 2021-12-15 | Franklin | Kansas | 20059 | 4376 | 65 |
2012534 | 2012534 | 2021-12-14 | Franklin | Kansas | 20059 | 4325 | 67 |
2009283 | 2009283 | 2021-12-13 | Franklin | Kansas | 20059 | 4325 | 67 |
2006032 | 2006032 | 2021-12-12 | Franklin | Kansas | 20059 | 4291 | 67 |
2002781 | 2002781 | 2021-12-11 | Franklin | Kansas | 20059 | 4291 | 67 |
1999531 | 1999531 | 2021-12-10 | Franklin | Kansas | 20059 | 4291 | 67 |
1996280 | 1996280 | 2021-12-09 | Franklin | Kansas | 20059 | 4229 | 67 |
1993029 | 1993029 | 2021-12-08 | Franklin | Kansas | 20059 | 4229 | 67 |
1989778 | 1989778 | 2021-12-07 | Franklin | Kansas | 20059 | 4193 | 63 |
1986528 | 1986528 | 2021-12-06 | Franklin | Kansas | 20059 | 4193 | 63 |
1983278 | 1983278 | 2021-12-05 | Franklin | Kansas | 20059 | 4151 | 63 |
1980028 | 1980028 | 2021-12-04 | Franklin | Kansas | 20059 | 4151 | 63 |
1976778 | 1976778 | 2021-12-03 | Franklin | Kansas | 20059 | 4151 | 63 |
1973529 | 1973529 | 2021-12-02 | Franklin | Kansas | 20059 | 4112 | 62 |
1970279 | 1970279 | 2021-12-01 | Franklin | Kansas | 20059 | 4112 | 62 |
1967029 | 1967029 | 2021-11-30 | Franklin | Kansas | 20059 | 4062 | 61 |
1963777 | 1963777 | 2021-11-29 | Franklin | Kansas | 20059 | 4062 | 61 |
1960526 | 1960526 | 2021-11-28 | Franklin | Kansas | 20059 | 4032 | 61 |
1957275 | 1957275 | 2021-11-27 | Franklin | Kansas | 20059 | 4032 | 61 |
1954024 | 1954024 | 2021-11-26 | Franklin | Kansas | 20059 | 4032 | 61 |
1950773 | 1950773 | 2021-11-25 | Franklin | Kansas | 20059 | 4032 | 61 |
1947522 | 1947522 | 2021-11-24 | Franklin | Kansas | 20059 | 4032 | 61 |
1944271 | 1944271 | 2021-11-23 | Franklin | Kansas | 20059 | 4009 | 60 |
1941021 | 1941021 | 2021-11-22 | Franklin | Kansas | 20059 | 4009 | 60 |
1937771 | 1937771 | 2021-11-21 | Franklin | Kansas | 20059 | 3989 | 60 |
1934521 | 1934521 | 2021-11-20 | Franklin | Kansas | 20059 | 3989 | 60 |
1931270 | 1931270 | 2021-11-19 | Franklin | Kansas | 20059 | 3989 | 60 |
1928019 | 1928019 | 2021-11-18 | Franklin | Kansas | 20059 | 3967 | 60 |
1924769 | 1924769 | 2021-11-17 | Franklin | Kansas | 20059 | 3967 | 60 |
1921520 | 1921520 | 2021-11-16 | Franklin | Kansas | 20059 | 3937 | 60 |
1918270 | 1918270 | 2021-11-15 | Franklin | Kansas | 20059 | 3937 | 60 |
1915020 | 1915020 | 2021-11-14 | Franklin | Kansas | 20059 | 3923 | 60 |
1911770 | 1911770 | 2021-11-13 | Franklin | Kansas | 20059 | 3923 | 60 |
1908521 | 1908521 | 2021-11-12 | Franklin | Kansas | 20059 | 3923 | 60 |
1905272 | 1905272 | 2021-11-11 | Franklin | Kansas | 20059 | 3909 | 60 |
1902022 | 1902022 | 2021-11-10 | Franklin | Kansas | 20059 | 3909 | 60 |
1898772 | 1898772 | 2021-11-09 | Franklin | Kansas | 20059 | 3885 | 60 |
1895522 | 1895522 | 2021-11-08 | Franklin | Kansas | 20059 | 3885 | 60 |
1892272 | 1892272 | 2021-11-07 | Franklin | Kansas | 20059 | 3864 | 60 |
1889022 | 1889022 | 2021-11-06 | Franklin | Kansas | 20059 | 3864 | 60 |
1885772 | 1885772 | 2021-11-05 | Franklin | Kansas | 20059 | 3864 | 60 |
1882523 | 1882523 | 2021-11-04 | Franklin | Kansas | 20059 | 3839 | 59 |
1879274 | 1879274 | 2021-11-03 | Franklin | Kansas | 20059 | 3839 | 59 |
1876025 | 1876025 | 2021-11-02 | Franklin | Kansas | 20059 | 3806 | 59 |
1872776 | 1872776 | 2021-11-01 | Franklin | Kansas | 20059 | 3806 | 59 |
1869527 | 1869527 | 2021-10-31 | Franklin | Kansas | 20059 | 3798 | 59 |
1866278 | 1866278 | 2021-10-30 | Franklin | Kansas | 20059 | 3798 | 59 |
1863029 | 1863029 | 2021-10-29 | Franklin | Kansas | 20059 | 3798 | 59 |
1859780 | 1859780 | 2021-10-28 | Franklin | Kansas | 20059 | 3773 | 58 |
1856531 | 1856531 | 2021-10-27 | Franklin | Kansas | 20059 | 3773 | 58 |
1853282 | 1853282 | 2021-10-26 | Franklin | Kansas | 20059 | 3755 | 58 |
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);