ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
750 rows where county = "Grant" and fips = 20067 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175125 | 2175125 | 2022-02-02 | Grant | Kansas | 20067 | 2214 | 34 |
2171872 | 2171872 | 2022-02-01 | Grant | Kansas | 20067 | 2191 | 34 |
2168619 | 2168619 | 2022-01-31 | Grant | Kansas | 20067 | 2151 | 34 |
2165364 | 2165364 | 2022-01-30 | Grant | Kansas | 20067 | 2151 | 34 |
2162109 | 2162109 | 2022-01-29 | Grant | Kansas | 20067 | 2151 | 34 |
2158854 | 2158854 | 2022-01-28 | Grant | Kansas | 20067 | 2151 | 34 |
2155600 | 2155600 | 2022-01-27 | Grant | Kansas | 20067 | 2151 | 33 |
2152347 | 2152347 | 2022-01-26 | Grant | Kansas | 20067 | 2144 | 33 |
2149095 | 2149095 | 2022-01-25 | Grant | Kansas | 20067 | 2127 | 33 |
2145843 | 2145843 | 2022-01-24 | Grant | Kansas | 20067 | 2091 | 33 |
2142588 | 2142588 | 2022-01-23 | Grant | Kansas | 20067 | 2016 | 33 |
2139333 | 2139333 | 2022-01-22 | Grant | Kansas | 20067 | 2016 | 33 |
2136077 | 2136077 | 2022-01-21 | Grant | Kansas | 20067 | 2016 | 33 |
2132825 | 2132825 | 2022-01-20 | Grant | Kansas | 20067 | 1966 | 33 |
2129572 | 2129572 | 2022-01-19 | Grant | Kansas | 20067 | 1966 | 33 |
2126318 | 2126318 | 2022-01-18 | Grant | Kansas | 20067 | 1847 | 33 |
2123066 | 2123066 | 2022-01-17 | Grant | Kansas | 20067 | 1847 | 33 |
2119814 | 2119814 | 2022-01-16 | Grant | Kansas | 20067 | 1841 | 33 |
2116562 | 2116562 | 2022-01-15 | Grant | Kansas | 20067 | 1841 | 33 |
2113311 | 2113311 | 2022-01-14 | Grant | Kansas | 20067 | 1841 | 33 |
2110059 | 2110059 | 2022-01-13 | Grant | Kansas | 20067 | 1775 | 33 |
2106808 | 2106808 | 2022-01-12 | Grant | Kansas | 20067 | 1775 | 33 |
2103557 | 2103557 | 2022-01-11 | Grant | Kansas | 20067 | 1738 | 33 |
2100306 | 2100306 | 2022-01-10 | Grant | Kansas | 20067 | 1738 | 33 |
2097055 | 2097055 | 2022-01-09 | Grant | Kansas | 20067 | 1713 | 33 |
2093803 | 2093803 | 2022-01-08 | Grant | Kansas | 20067 | 1713 | 33 |
2090551 | 2090551 | 2022-01-07 | Grant | Kansas | 20067 | 1713 | 33 |
2087300 | 2087300 | 2022-01-06 | Grant | Kansas | 20067 | 1678 | 33 |
2084048 | 2084048 | 2022-01-05 | Grant | Kansas | 20067 | 1678 | 33 |
2080796 | 2080796 | 2022-01-04 | Grant | Kansas | 20067 | 1639 | 33 |
2077544 | 2077544 | 2022-01-03 | Grant | Kansas | 20067 | 1639 | 33 |
2074293 | 2074293 | 2022-01-02 | Grant | Kansas | 20067 | 1602 | 33 |
2071042 | 2071042 | 2022-01-01 | Grant | Kansas | 20067 | 1602 | 33 |
2067791 | 2067791 | 2021-12-31 | Grant | Kansas | 20067 | 1602 | 33 |
2064540 | 2064540 | 2021-12-30 | Grant | Kansas | 20067 | 1602 | 33 |
2061290 | 2061290 | 2021-12-29 | Grant | Kansas | 20067 | 1602 | 33 |
2058041 | 2058041 | 2021-12-28 | Grant | Kansas | 20067 | 1590 | 33 |
2054792 | 2054792 | 2021-12-27 | Grant | Kansas | 20067 | 1590 | 33 |
2051542 | 2051542 | 2021-12-26 | Grant | Kansas | 20067 | 1578 | 32 |
2048292 | 2048292 | 2021-12-25 | Grant | Kansas | 20067 | 1578 | 32 |
2045042 | 2045042 | 2021-12-24 | Grant | Kansas | 20067 | 1578 | 32 |
2041793 | 2041793 | 2021-12-23 | Grant | Kansas | 20067 | 1578 | 32 |
2038543 | 2038543 | 2021-12-22 | Grant | Kansas | 20067 | 1578 | 32 |
2035293 | 2035293 | 2021-12-21 | Grant | Kansas | 20067 | 1566 | 32 |
2032043 | 2032043 | 2021-12-20 | Grant | Kansas | 20067 | 1566 | 32 |
2028792 | 2028792 | 2021-12-19 | Grant | Kansas | 20067 | 1561 | 32 |
2025541 | 2025541 | 2021-12-18 | Grant | Kansas | 20067 | 1561 | 32 |
2022290 | 2022290 | 2021-12-17 | Grant | Kansas | 20067 | 1561 | 32 |
2019039 | 2019039 | 2021-12-16 | Grant | Kansas | 20067 | 1549 | 32 |
2015789 | 2015789 | 2021-12-15 | Grant | Kansas | 20067 | 1549 | 32 |
2012538 | 2012538 | 2021-12-14 | Grant | Kansas | 20067 | 1531 | 32 |
2009287 | 2009287 | 2021-12-13 | Grant | Kansas | 20067 | 1531 | 32 |
2006036 | 2006036 | 2021-12-12 | Grant | Kansas | 20067 | 1522 | 32 |
2002785 | 2002785 | 2021-12-11 | Grant | Kansas | 20067 | 1522 | 32 |
1999535 | 1999535 | 2021-12-10 | Grant | Kansas | 20067 | 1522 | 32 |
1996284 | 1996284 | 2021-12-09 | Grant | Kansas | 20067 | 1506 | 31 |
1993033 | 1993033 | 2021-12-08 | Grant | Kansas | 20067 | 1506 | 31 |
1989782 | 1989782 | 2021-12-07 | Grant | Kansas | 20067 | 1488 | 31 |
1986532 | 1986532 | 2021-12-06 | Grant | Kansas | 20067 | 1488 | 31 |
1983282 | 1983282 | 2021-12-05 | Grant | Kansas | 20067 | 1476 | 31 |
1980032 | 1980032 | 2021-12-04 | Grant | Kansas | 20067 | 1476 | 31 |
1976782 | 1976782 | 2021-12-03 | Grant | Kansas | 20067 | 1476 | 31 |
1973533 | 1973533 | 2021-12-02 | Grant | Kansas | 20067 | 1464 | 30 |
1970283 | 1970283 | 2021-12-01 | Grant | Kansas | 20067 | 1464 | 30 |
1967033 | 1967033 | 2021-11-30 | Grant | Kansas | 20067 | 1445 | 30 |
1963781 | 1963781 | 2021-11-29 | Grant | Kansas | 20067 | 1445 | 30 |
1960530 | 1960530 | 2021-11-28 | Grant | Kansas | 20067 | 1436 | 30 |
1957279 | 1957279 | 2021-11-27 | Grant | Kansas | 20067 | 1436 | 30 |
1954028 | 1954028 | 2021-11-26 | Grant | Kansas | 20067 | 1436 | 30 |
1950777 | 1950777 | 2021-11-25 | Grant | Kansas | 20067 | 1436 | 30 |
1947526 | 1947526 | 2021-11-24 | Grant | Kansas | 20067 | 1436 | 30 |
1944275 | 1944275 | 2021-11-23 | Grant | Kansas | 20067 | 1413 | 30 |
1941025 | 1941025 | 2021-11-22 | Grant | Kansas | 20067 | 1413 | 30 |
1937775 | 1937775 | 2021-11-21 | Grant | Kansas | 20067 | 1401 | 30 |
1934525 | 1934525 | 2021-11-20 | Grant | Kansas | 20067 | 1401 | 30 |
1931274 | 1931274 | 2021-11-19 | Grant | Kansas | 20067 | 1401 | 30 |
1928023 | 1928023 | 2021-11-18 | Grant | Kansas | 20067 | 1388 | 30 |
1924773 | 1924773 | 2021-11-17 | Grant | Kansas | 20067 | 1388 | 30 |
1921524 | 1921524 | 2021-11-16 | Grant | Kansas | 20067 | 1371 | 30 |
1918274 | 1918274 | 2021-11-15 | Grant | Kansas | 20067 | 1371 | 30 |
1915024 | 1915024 | 2021-11-14 | Grant | Kansas | 20067 | 1353 | 30 |
1911774 | 1911774 | 2021-11-13 | Grant | Kansas | 20067 | 1353 | 30 |
1908525 | 1908525 | 2021-11-12 | Grant | Kansas | 20067 | 1353 | 30 |
1905276 | 1905276 | 2021-11-11 | Grant | Kansas | 20067 | 1345 | 30 |
1902026 | 1902026 | 2021-11-10 | Grant | Kansas | 20067 | 1345 | 30 |
1898776 | 1898776 | 2021-11-09 | Grant | Kansas | 20067 | 1326 | 29 |
1895526 | 1895526 | 2021-11-08 | Grant | Kansas | 20067 | 1317 | 29 |
1892276 | 1892276 | 2021-11-07 | Grant | Kansas | 20067 | 1309 | 29 |
1889026 | 1889026 | 2021-11-06 | Grant | Kansas | 20067 | 1309 | 29 |
1885776 | 1885776 | 2021-11-05 | Grant | Kansas | 20067 | 1309 | 29 |
1882527 | 1882527 | 2021-11-04 | Grant | Kansas | 20067 | 1307 | 29 |
1879278 | 1879278 | 2021-11-03 | Grant | Kansas | 20067 | 1301 | 29 |
1876029 | 1876029 | 2021-11-02 | Grant | Kansas | 20067 | 1293 | 29 |
1872780 | 1872780 | 2021-11-01 | Grant | Kansas | 20067 | 1285 | 29 |
1869531 | 1869531 | 2021-10-31 | Grant | Kansas | 20067 | 1267 | 29 |
1866282 | 1866282 | 2021-10-30 | Grant | Kansas | 20067 | 1267 | 29 |
1863033 | 1863033 | 2021-10-29 | Grant | Kansas | 20067 | 1267 | 29 |
1859784 | 1859784 | 2021-10-28 | Grant | Kansas | 20067 | 1267 | 27 |
1856535 | 1856535 | 2021-10-27 | Grant | Kansas | 20067 | 1265 | 27 |
1853286 | 1853286 | 2021-10-26 | Grant | Kansas | 20067 | 1261 | 27 |
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);