ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Clay" and fips = 20027 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175105 | 2175105 | 2022-02-02 | Clay | Kansas | 20027 | 1897 | 32 |
2171852 | 2171852 | 2022-02-01 | Clay | Kansas | 20027 | 1869 | 32 |
2168599 | 2168599 | 2022-01-31 | Clay | Kansas | 20027 | 1869 | 32 |
2165344 | 2165344 | 2022-01-30 | Clay | Kansas | 20027 | 1856 | 32 |
2162089 | 2162089 | 2022-01-29 | Clay | Kansas | 20027 | 1856 | 32 |
2158834 | 2158834 | 2022-01-28 | Clay | Kansas | 20027 | 1856 | 32 |
2155580 | 2155580 | 2022-01-27 | Clay | Kansas | 20027 | 1833 | 32 |
2152327 | 2152327 | 2022-01-26 | Clay | Kansas | 20027 | 1833 | 32 |
2149075 | 2149075 | 2022-01-25 | Clay | Kansas | 20027 | 1790 | 32 |
2145823 | 2145823 | 2022-01-24 | Clay | Kansas | 20027 | 1790 | 32 |
2142568 | 2142568 | 2022-01-23 | Clay | Kansas | 20027 | 1754 | 32 |
2139313 | 2139313 | 2022-01-22 | Clay | Kansas | 20027 | 1754 | 32 |
2136057 | 2136057 | 2022-01-21 | Clay | Kansas | 20027 | 1754 | 32 |
2132805 | 2132805 | 2022-01-20 | Clay | Kansas | 20027 | 1709 | 32 |
2129552 | 2129552 | 2022-01-19 | Clay | Kansas | 20027 | 1709 | 32 |
2126298 | 2126298 | 2022-01-18 | Clay | Kansas | 20027 | 1620 | 32 |
2123046 | 2123046 | 2022-01-17 | Clay | Kansas | 20027 | 1620 | 32 |
2119794 | 2119794 | 2022-01-16 | Clay | Kansas | 20027 | 1620 | 32 |
2116542 | 2116542 | 2022-01-15 | Clay | Kansas | 20027 | 1620 | 32 |
2113291 | 2113291 | 2022-01-14 | Clay | Kansas | 20027 | 1620 | 32 |
2110039 | 2110039 | 2022-01-13 | Clay | Kansas | 20027 | 1569 | 31 |
2106788 | 2106788 | 2022-01-12 | Clay | Kansas | 20027 | 1569 | 31 |
2103537 | 2103537 | 2022-01-11 | Clay | Kansas | 20027 | 1526 | 31 |
2100286 | 2100286 | 2022-01-10 | Clay | Kansas | 20027 | 1526 | 31 |
2097035 | 2097035 | 2022-01-09 | Clay | Kansas | 20027 | 1515 | 31 |
2093783 | 2093783 | 2022-01-08 | Clay | Kansas | 20027 | 1515 | 31 |
2090531 | 2090531 | 2022-01-07 | Clay | Kansas | 20027 | 1515 | 31 |
2087280 | 2087280 | 2022-01-06 | Clay | Kansas | 20027 | 1494 | 31 |
2084028 | 2084028 | 2022-01-05 | Clay | Kansas | 20027 | 1494 | 31 |
2080776 | 2080776 | 2022-01-04 | Clay | Kansas | 20027 | 1464 | 31 |
2077524 | 2077524 | 2022-01-03 | Clay | Kansas | 20027 | 1464 | 31 |
2074273 | 2074273 | 2022-01-02 | Clay | Kansas | 20027 | 1435 | 31 |
2071022 | 2071022 | 2022-01-01 | Clay | Kansas | 20027 | 1435 | 31 |
2067771 | 2067771 | 2021-12-31 | Clay | Kansas | 20027 | 1435 | 31 |
2064520 | 2064520 | 2021-12-30 | Clay | Kansas | 20027 | 1435 | 31 |
2061270 | 2061270 | 2021-12-29 | Clay | Kansas | 20027 | 1435 | 31 |
2058021 | 2058021 | 2021-12-28 | Clay | Kansas | 20027 | 1427 | 31 |
2054772 | 2054772 | 2021-12-27 | Clay | Kansas | 20027 | 1427 | 31 |
2051522 | 2051522 | 2021-12-26 | Clay | Kansas | 20027 | 1409 | 31 |
2048272 | 2048272 | 2021-12-25 | Clay | Kansas | 20027 | 1409 | 31 |
2045022 | 2045022 | 2021-12-24 | Clay | Kansas | 20027 | 1409 | 31 |
2041773 | 2041773 | 2021-12-23 | Clay | Kansas | 20027 | 1409 | 31 |
2038523 | 2038523 | 2021-12-22 | Clay | Kansas | 20027 | 1409 | 31 |
2035273 | 2035273 | 2021-12-21 | Clay | Kansas | 20027 | 1387 | 31 |
2032023 | 2032023 | 2021-12-20 | Clay | Kansas | 20027 | 1387 | 31 |
2028772 | 2028772 | 2021-12-19 | Clay | Kansas | 20027 | 1379 | 31 |
2025521 | 2025521 | 2021-12-18 | Clay | Kansas | 20027 | 1379 | 31 |
2022270 | 2022270 | 2021-12-17 | Clay | Kansas | 20027 | 1379 | 31 |
2019019 | 2019019 | 2021-12-16 | Clay | Kansas | 20027 | 1368 | 31 |
2015769 | 2015769 | 2021-12-15 | Clay | Kansas | 20027 | 1368 | 31 |
2012518 | 2012518 | 2021-12-14 | Clay | Kansas | 20027 | 1362 | 31 |
2009267 | 2009267 | 2021-12-13 | Clay | Kansas | 20027 | 1362 | 31 |
2006016 | 2006016 | 2021-12-12 | Clay | Kansas | 20027 | 1358 | 31 |
2002765 | 2002765 | 2021-12-11 | Clay | Kansas | 20027 | 1358 | 31 |
1999515 | 1999515 | 2021-12-10 | Clay | Kansas | 20027 | 1358 | 31 |
1996264 | 1996264 | 2021-12-09 | Clay | Kansas | 20027 | 1352 | 31 |
1993013 | 1993013 | 2021-12-08 | Clay | Kansas | 20027 | 1352 | 31 |
1989762 | 1989762 | 2021-12-07 | Clay | Kansas | 20027 | 1350 | 31 |
1986512 | 1986512 | 2021-12-06 | Clay | Kansas | 20027 | 1350 | 31 |
1983262 | 1983262 | 2021-12-05 | Clay | Kansas | 20027 | 1342 | 31 |
1980012 | 1980012 | 2021-12-04 | Clay | Kansas | 20027 | 1342 | 31 |
1976762 | 1976762 | 2021-12-03 | Clay | Kansas | 20027 | 1342 | 31 |
1973513 | 1973513 | 2021-12-02 | Clay | Kansas | 20027 | 1342 | 31 |
1970263 | 1970263 | 2021-12-01 | Clay | Kansas | 20027 | 1342 | 31 |
1967013 | 1967013 | 2021-11-30 | Clay | Kansas | 20027 | 1349 | 31 |
1963761 | 1963761 | 2021-11-29 | Clay | Kansas | 20027 | 1349 | 31 |
1960510 | 1960510 | 2021-11-28 | Clay | Kansas | 20027 | 1311 | 31 |
1957259 | 1957259 | 2021-11-27 | Clay | Kansas | 20027 | 1311 | 31 |
1954008 | 1954008 | 2021-11-26 | Clay | Kansas | 20027 | 1311 | 31 |
1950757 | 1950757 | 2021-11-25 | Clay | Kansas | 20027 | 1311 | 31 |
1947506 | 1947506 | 2021-11-24 | Clay | Kansas | 20027 | 1311 | 31 |
1944255 | 1944255 | 2021-11-23 | Clay | Kansas | 20027 | 1301 | 31 |
1941005 | 1941005 | 2021-11-22 | Clay | Kansas | 20027 | 1301 | 31 |
1937755 | 1937755 | 2021-11-21 | Clay | Kansas | 20027 | 1296 | 31 |
1934505 | 1934505 | 2021-11-20 | Clay | Kansas | 20027 | 1296 | 31 |
1931254 | 1931254 | 2021-11-19 | Clay | Kansas | 20027 | 1296 | 31 |
1928003 | 1928003 | 2021-11-18 | Clay | Kansas | 20027 | 1286 | 31 |
1924753 | 1924753 | 2021-11-17 | Clay | Kansas | 20027 | 1286 | 31 |
1921504 | 1921504 | 2021-11-16 | Clay | Kansas | 20027 | 1280 | 31 |
1918254 | 1918254 | 2021-11-15 | Clay | Kansas | 20027 | 1280 | 31 |
1915004 | 1915004 | 2021-11-14 | Clay | Kansas | 20027 | 1279 | 31 |
1911754 | 1911754 | 2021-11-13 | Clay | Kansas | 20027 | 1279 | 31 |
1908505 | 1908505 | 2021-11-12 | Clay | Kansas | 20027 | 1279 | 31 |
1905256 | 1905256 | 2021-11-11 | Clay | Kansas | 20027 | 1277 | 31 |
1902006 | 1902006 | 2021-11-10 | Clay | Kansas | 20027 | 1277 | 31 |
1898756 | 1898756 | 2021-11-09 | Clay | Kansas | 20027 | 1273 | 31 |
1895506 | 1895506 | 2021-11-08 | Clay | Kansas | 20027 | 1273 | 31 |
1892256 | 1892256 | 2021-11-07 | Clay | Kansas | 20027 | 1268 | 31 |
1889006 | 1889006 | 2021-11-06 | Clay | Kansas | 20027 | 1268 | 31 |
1885756 | 1885756 | 2021-11-05 | Clay | Kansas | 20027 | 1268 | 31 |
1882507 | 1882507 | 2021-11-04 | Clay | Kansas | 20027 | 1263 | 31 |
1879258 | 1879258 | 2021-11-03 | Clay | Kansas | 20027 | 1263 | 31 |
1876009 | 1876009 | 2021-11-02 | Clay | Kansas | 20027 | 1259 | 31 |
1872760 | 1872760 | 2021-11-01 | Clay | Kansas | 20027 | 1259 | 31 |
1869511 | 1869511 | 2021-10-31 | Clay | Kansas | 20027 | 1255 | 31 |
1866262 | 1866262 | 2021-10-30 | Clay | Kansas | 20027 | 1255 | 31 |
1863013 | 1863013 | 2021-10-29 | Clay | Kansas | 20027 | 1255 | 31 |
1859764 | 1859764 | 2021-10-28 | Clay | Kansas | 20027 | 1249 | 31 |
1856515 | 1856515 | 2021-10-27 | Clay | Kansas | 20027 | 1249 | 31 |
1853266 | 1853266 | 2021-10-26 | Clay | Kansas | 20027 | 1240 | 31 |
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);