ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 20155 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1947570 | 1947570 | 2021-11-24 | Reno | Kansas | 20155 | 12366 | 173 |
1944319 | 1944319 | 2021-11-23 | Reno | Kansas | 20155 | 12228 | 172 |
1941069 | 1941069 | 2021-11-22 | Reno | Kansas | 20155 | 12228 | 172 |
1937819 | 1937819 | 2021-11-21 | Reno | Kansas | 20155 | 12168 | 172 |
1934569 | 1934569 | 2021-11-20 | Reno | Kansas | 20155 | 12168 | 172 |
1931318 | 1931318 | 2021-11-19 | Reno | Kansas | 20155 | 12168 | 172 |
1928067 | 1928067 | 2021-11-18 | Reno | Kansas | 20155 | 12010 | 172 |
1924817 | 1924817 | 2021-11-17 | Reno | Kansas | 20155 | 12010 | 172 |
1921568 | 1921568 | 2021-11-16 | Reno | Kansas | 20155 | 11899 | 171 |
1918318 | 1918318 | 2021-11-15 | Reno | Kansas | 20155 | 11899 | 171 |
1915068 | 1915068 | 2021-11-14 | Reno | Kansas | 20155 | 11830 | 171 |
1911818 | 1911818 | 2021-11-13 | Reno | Kansas | 20155 | 11830 | 171 |
1908569 | 1908569 | 2021-11-12 | Reno | Kansas | 20155 | 11830 | 171 |
1905320 | 1905320 | 2021-11-11 | Reno | Kansas | 20155 | 11735 | 171 |
1902070 | 1902070 | 2021-11-10 | Reno | Kansas | 20155 | 11735 | 171 |
1898820 | 1898820 | 2021-11-09 | Reno | Kansas | 20155 | 11590 | 168 |
1895570 | 1895570 | 2021-11-08 | Reno | Kansas | 20155 | 11590 | 168 |
1892320 | 1892320 | 2021-11-07 | Reno | Kansas | 20155 | 11508 | 168 |
1889070 | 1889070 | 2021-11-06 | Reno | Kansas | 20155 | 11508 | 168 |
1885820 | 1885820 | 2021-11-05 | Reno | Kansas | 20155 | 11508 | 168 |
1882571 | 1882571 | 2021-11-04 | Reno | Kansas | 20155 | 11447 | 168 |
1879322 | 1879322 | 2021-11-03 | Reno | Kansas | 20155 | 11447 | 168 |
1876073 | 1876073 | 2021-11-02 | Reno | Kansas | 20155 | 11383 | 168 |
1872824 | 1872824 | 2021-11-01 | Reno | Kansas | 20155 | 11383 | 168 |
1869575 | 1869575 | 2021-10-31 | Reno | Kansas | 20155 | 11343 | 168 |
1866326 | 1866326 | 2021-10-30 | Reno | Kansas | 20155 | 11343 | 168 |
1863077 | 1863077 | 2021-10-29 | Reno | Kansas | 20155 | 11343 | 168 |
1859828 | 1859828 | 2021-10-28 | Reno | Kansas | 20155 | 11280 | 168 |
1856579 | 1856579 | 2021-10-27 | Reno | Kansas | 20155 | 11280 | 168 |
1853330 | 1853330 | 2021-10-26 | Reno | Kansas | 20155 | 11204 | 163 |
1850081 | 1850081 | 2021-10-25 | Reno | Kansas | 20155 | 11204 | 163 |
1846831 | 1846831 | 2021-10-24 | Reno | Kansas | 20155 | 11181 | 163 |
1843581 | 1843581 | 2021-10-23 | Reno | Kansas | 20155 | 11181 | 163 |
1840331 | 1840331 | 2021-10-22 | Reno | Kansas | 20155 | 11181 | 163 |
1837082 | 1837082 | 2021-10-21 | Reno | Kansas | 20155 | 11122 | 163 |
1833833 | 1833833 | 2021-10-20 | Reno | Kansas | 20155 | 11122 | 163 |
1830584 | 1830584 | 2021-10-19 | Reno | Kansas | 20155 | 11071 | 163 |
1827335 | 1827335 | 2021-10-18 | Reno | Kansas | 20155 | 11071 | 163 |
1824086 | 1824086 | 2021-10-17 | Reno | Kansas | 20155 | 11025 | 163 |
1820837 | 1820837 | 2021-10-16 | Reno | Kansas | 20155 | 11025 | 163 |
1817588 | 1817588 | 2021-10-15 | Reno | Kansas | 20155 | 11025 | 163 |
1814340 | 1814340 | 2021-10-14 | Reno | Kansas | 20155 | 10979 | 163 |
1811091 | 1811091 | 2021-10-13 | Reno | Kansas | 20155 | 10979 | 163 |
1807842 | 1807842 | 2021-10-12 | Reno | Kansas | 20155 | 10909 | 163 |
1804591 | 1804591 | 2021-10-11 | Reno | Kansas | 20155 | 10909 | 163 |
1801342 | 1801342 | 2021-10-10 | Reno | Kansas | 20155 | 10866 | 161 |
1798093 | 1798093 | 2021-10-09 | Reno | Kansas | 20155 | 10866 | 161 |
1794844 | 1794844 | 2021-10-08 | Reno | Kansas | 20155 | 10866 | 161 |
1791596 | 1791596 | 2021-10-07 | Reno | Kansas | 20155 | 10794 | 161 |
1788347 | 1788347 | 2021-10-06 | Reno | Kansas | 20155 | 10794 | 161 |
1785098 | 1785098 | 2021-10-05 | Reno | Kansas | 20155 | 10723 | 161 |
1781849 | 1781849 | 2021-10-04 | Reno | Kansas | 20155 | 10723 | 161 |
1778599 | 1778599 | 2021-10-03 | Reno | Kansas | 20155 | 10664 | 161 |
1775349 | 1775349 | 2021-10-02 | Reno | Kansas | 20155 | 10664 | 161 |
1772099 | 1772099 | 2021-10-01 | Reno | Kansas | 20155 | 10664 | 161 |
1768850 | 1768850 | 2021-09-30 | Reno | Kansas | 20155 | 10586 | 161 |
1765601 | 1765601 | 2021-09-29 | Reno | Kansas | 20155 | 10586 | 161 |
1762352 | 1762352 | 2021-09-28 | Reno | Kansas | 20155 | 10507 | 159 |
1759104 | 1759104 | 2021-09-27 | Reno | Kansas | 20155 | 10507 | 159 |
1755856 | 1755856 | 2021-09-26 | Reno | Kansas | 20155 | 10466 | 157 |
1752608 | 1752608 | 2021-09-25 | Reno | Kansas | 20155 | 10466 | 157 |
1749359 | 1749359 | 2021-09-24 | Reno | Kansas | 20155 | 10466 | 157 |
1746109 | 1746109 | 2021-09-23 | Reno | Kansas | 20155 | 10403 | 157 |
1742860 | 1742860 | 2021-09-22 | Reno | Kansas | 20155 | 10403 | 157 |
1739611 | 1739611 | 2021-09-21 | Reno | Kansas | 20155 | 10311 | 156 |
1736362 | 1736362 | 2021-09-20 | Reno | Kansas | 20155 | 10311 | 156 |
1733112 | 1733112 | 2021-09-19 | Reno | Kansas | 20155 | 10256 | 155 |
1729862 | 1729862 | 2021-09-18 | Reno | Kansas | 20155 | 10256 | 155 |
1726612 | 1726612 | 2021-09-17 | Reno | Kansas | 20155 | 10256 | 155 |
1723363 | 1723363 | 2021-09-16 | Reno | Kansas | 20155 | 10146 | 153 |
1720114 | 1720114 | 2021-09-15 | Reno | Kansas | 20155 | 10146 | 153 |
1716866 | 1716866 | 2021-09-14 | Reno | Kansas | 20155 | 10051 | 150 |
1713620 | 1713620 | 2021-09-13 | Reno | Kansas | 20155 | 10051 | 150 |
1710373 | 1710373 | 2021-09-12 | Reno | Kansas | 20155 | 9977 | 150 |
1707126 | 1707126 | 2021-09-11 | Reno | Kansas | 20155 | 9977 | 150 |
1703878 | 1703878 | 2021-09-10 | Reno | Kansas | 20155 | 9977 | 150 |
1700628 | 1700628 | 2021-09-09 | Reno | Kansas | 20155 | 9880 | 148 |
1697379 | 1697379 | 2021-09-08 | Reno | Kansas | 20155 | 9880 | 148 |
1694131 | 1694131 | 2021-09-07 | Reno | Kansas | 20155 | 9740 | 145 |
1690882 | 1690882 | 2021-09-06 | Reno | Kansas | 20155 | 9740 | 145 |
1687632 | 1687632 | 2021-09-05 | Reno | Kansas | 20155 | 9740 | 145 |
1684382 | 1684382 | 2021-09-04 | Reno | Kansas | 20155 | 9740 | 145 |
1681131 | 1681131 | 2021-09-03 | Reno | Kansas | 20155 | 9740 | 145 |
1677883 | 1677883 | 2021-09-02 | Reno | Kansas | 20155 | 9636 | 145 |
1674636 | 1674636 | 2021-09-01 | Reno | Kansas | 20155 | 9636 | 145 |
1671387 | 1671387 | 2021-08-31 | Reno | Kansas | 20155 | 9526 | 145 |
1668140 | 1668140 | 2021-08-30 | Reno | Kansas | 20155 | 9526 | 145 |
1664893 | 1664893 | 2021-08-29 | Reno | Kansas | 20155 | 9443 | 144 |
1661645 | 1661645 | 2021-08-28 | Reno | Kansas | 20155 | 9443 | 144 |
1658397 | 1658397 | 2021-08-27 | Reno | Kansas | 20155 | 9443 | 144 |
1655149 | 1655149 | 2021-08-26 | Reno | Kansas | 20155 | 9351 | 144 |
1651902 | 1651902 | 2021-08-25 | Reno | Kansas | 20155 | 9351 | 144 |
1648653 | 1648653 | 2021-08-24 | Reno | Kansas | 20155 | 9250 | 143 |
1645405 | 1645405 | 2021-08-23 | Reno | Kansas | 20155 | 9250 | 143 |
1642156 | 1642156 | 2021-08-22 | Reno | Kansas | 20155 | 9176 | 143 |
1638906 | 1638906 | 2021-08-21 | Reno | Kansas | 20155 | 9176 | 143 |
1635656 | 1635656 | 2021-08-20 | Reno | Kansas | 20155 | 9176 | 143 |
1632406 | 1632406 | 2021-08-19 | Reno | Kansas | 20155 | 9121 | 142 |
1629159 | 1629159 | 2021-08-18 | Reno | Kansas | 20155 | 9121 | 142 |
1625912 | 1625912 | 2021-08-17 | Reno | Kansas | 20155 | 9073 | 142 |
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);