ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 20103 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1947544 | 1947544 | 2021-11-24 | Leavenworth | Kansas | 20103 | 10988 | 135 |
1944293 | 1944293 | 2021-11-23 | Leavenworth | Kansas | 20103 | 10949 | 133 |
1941043 | 1941043 | 2021-11-22 | Leavenworth | Kansas | 20103 | 10949 | 133 |
1937793 | 1937793 | 2021-11-21 | Leavenworth | Kansas | 20103 | 10875 | 133 |
1934543 | 1934543 | 2021-11-20 | Leavenworth | Kansas | 20103 | 10875 | 133 |
1931292 | 1931292 | 2021-11-19 | Leavenworth | Kansas | 20103 | 10875 | 133 |
1928041 | 1928041 | 2021-11-18 | Leavenworth | Kansas | 20103 | 10800 | 134 |
1924791 | 1924791 | 2021-11-17 | Leavenworth | Kansas | 20103 | 10800 | 134 |
1921542 | 1921542 | 2021-11-16 | Leavenworth | Kansas | 20103 | 10749 | 134 |
1918292 | 1918292 | 2021-11-15 | Leavenworth | Kansas | 20103 | 10749 | 134 |
1915042 | 1915042 | 2021-11-14 | Leavenworth | Kansas | 20103 | 10694 | 134 |
1911792 | 1911792 | 2021-11-13 | Leavenworth | Kansas | 20103 | 10694 | 134 |
1908543 | 1908543 | 2021-11-12 | Leavenworth | Kansas | 20103 | 10694 | 134 |
1905294 | 1905294 | 2021-11-11 | Leavenworth | Kansas | 20103 | 10625 | 134 |
1902044 | 1902044 | 2021-11-10 | Leavenworth | Kansas | 20103 | 10625 | 134 |
1898794 | 1898794 | 2021-11-09 | Leavenworth | Kansas | 20103 | 10559 | 133 |
1895544 | 1895544 | 2021-11-08 | Leavenworth | Kansas | 20103 | 10559 | 133 |
1892294 | 1892294 | 2021-11-07 | Leavenworth | Kansas | 20103 | 10498 | 133 |
1889044 | 1889044 | 2021-11-06 | Leavenworth | Kansas | 20103 | 10498 | 133 |
1885794 | 1885794 | 2021-11-05 | Leavenworth | Kansas | 20103 | 10498 | 133 |
1882545 | 1882545 | 2021-11-04 | Leavenworth | Kansas | 20103 | 10456 | 131 |
1879296 | 1879296 | 2021-11-03 | Leavenworth | Kansas | 20103 | 10456 | 131 |
1876047 | 1876047 | 2021-11-02 | Leavenworth | Kansas | 20103 | 10410 | 131 |
1872798 | 1872798 | 2021-11-01 | Leavenworth | Kansas | 20103 | 10410 | 131 |
1869549 | 1869549 | 2021-10-31 | Leavenworth | Kansas | 20103 | 10384 | 131 |
1866300 | 1866300 | 2021-10-30 | Leavenworth | Kansas | 20103 | 10384 | 131 |
1863051 | 1863051 | 2021-10-29 | Leavenworth | Kansas | 20103 | 10384 | 131 |
1859802 | 1859802 | 2021-10-28 | Leavenworth | Kansas | 20103 | 10352 | 130 |
1856553 | 1856553 | 2021-10-27 | Leavenworth | Kansas | 20103 | 10352 | 130 |
1853304 | 1853304 | 2021-10-26 | Leavenworth | Kansas | 20103 | 10309 | 125 |
1850055 | 1850055 | 2021-10-25 | Leavenworth | Kansas | 20103 | 10309 | 125 |
1846805 | 1846805 | 2021-10-24 | Leavenworth | Kansas | 20103 | 10279 | 123 |
1843555 | 1843555 | 2021-10-23 | Leavenworth | Kansas | 20103 | 10279 | 123 |
1840305 | 1840305 | 2021-10-22 | Leavenworth | Kansas | 20103 | 10279 | 123 |
1837056 | 1837056 | 2021-10-21 | Leavenworth | Kansas | 20103 | 10246 | 122 |
1833807 | 1833807 | 2021-10-20 | Leavenworth | Kansas | 20103 | 10246 | 122 |
1830558 | 1830558 | 2021-10-19 | Leavenworth | Kansas | 20103 | 10218 | 122 |
1827309 | 1827309 | 2021-10-18 | Leavenworth | Kansas | 20103 | 10218 | 122 |
1824060 | 1824060 | 2021-10-17 | Leavenworth | Kansas | 20103 | 10181 | 121 |
1820811 | 1820811 | 2021-10-16 | Leavenworth | Kansas | 20103 | 10181 | 121 |
1817562 | 1817562 | 2021-10-15 | Leavenworth | Kansas | 20103 | 10181 | 121 |
1814314 | 1814314 | 2021-10-14 | Leavenworth | Kansas | 20103 | 10147 | 120 |
1811065 | 1811065 | 2021-10-13 | Leavenworth | Kansas | 20103 | 10147 | 120 |
1807816 | 1807816 | 2021-10-12 | Leavenworth | Kansas | 20103 | 10112 | 119 |
1804565 | 1804565 | 2021-10-11 | Leavenworth | Kansas | 20103 | 10112 | 119 |
1801316 | 1801316 | 2021-10-10 | Leavenworth | Kansas | 20103 | 10074 | 119 |
1798067 | 1798067 | 2021-10-09 | Leavenworth | Kansas | 20103 | 10074 | 119 |
1794818 | 1794818 | 2021-10-08 | Leavenworth | Kansas | 20103 | 10074 | 119 |
1791570 | 1791570 | 2021-10-07 | Leavenworth | Kansas | 20103 | 10032 | 119 |
1788321 | 1788321 | 2021-10-06 | Leavenworth | Kansas | 20103 | 10032 | 119 |
1785072 | 1785072 | 2021-10-05 | Leavenworth | Kansas | 20103 | 10021 | 118 |
1781823 | 1781823 | 2021-10-04 | Leavenworth | Kansas | 20103 | 10021 | 118 |
1778573 | 1778573 | 2021-10-03 | Leavenworth | Kansas | 20103 | 9972 | 118 |
1775323 | 1775323 | 2021-10-02 | Leavenworth | Kansas | 20103 | 9972 | 118 |
1772073 | 1772073 | 2021-10-01 | Leavenworth | Kansas | 20103 | 9972 | 118 |
1768824 | 1768824 | 2021-09-30 | Leavenworth | Kansas | 20103 | 9924 | 117 |
1765575 | 1765575 | 2021-09-29 | Leavenworth | Kansas | 20103 | 9924 | 117 |
1762326 | 1762326 | 2021-09-28 | Leavenworth | Kansas | 20103 | 9894 | 117 |
1759078 | 1759078 | 2021-09-27 | Leavenworth | Kansas | 20103 | 9894 | 117 |
1755830 | 1755830 | 2021-09-26 | Leavenworth | Kansas | 20103 | 9863 | 117 |
1752582 | 1752582 | 2021-09-25 | Leavenworth | Kansas | 20103 | 9863 | 117 |
1749333 | 1749333 | 2021-09-24 | Leavenworth | Kansas | 20103 | 9863 | 117 |
1746083 | 1746083 | 2021-09-23 | Leavenworth | Kansas | 20103 | 9805 | 117 |
1742834 | 1742834 | 2021-09-22 | Leavenworth | Kansas | 20103 | 9805 | 117 |
1739585 | 1739585 | 2021-09-21 | Leavenworth | Kansas | 20103 | 9771 | 118 |
1736336 | 1736336 | 2021-09-20 | Leavenworth | Kansas | 20103 | 9771 | 118 |
1733086 | 1733086 | 2021-09-19 | Leavenworth | Kansas | 20103 | 9700 | 117 |
1729836 | 1729836 | 2021-09-18 | Leavenworth | Kansas | 20103 | 9700 | 117 |
1726586 | 1726586 | 2021-09-17 | Leavenworth | Kansas | 20103 | 9700 | 117 |
1723337 | 1723337 | 2021-09-16 | Leavenworth | Kansas | 20103 | 9644 | 116 |
1720088 | 1720088 | 2021-09-15 | Leavenworth | Kansas | 20103 | 9644 | 116 |
1716840 | 1716840 | 2021-09-14 | Leavenworth | Kansas | 20103 | 9572 | 116 |
1713594 | 1713594 | 2021-09-13 | Leavenworth | Kansas | 20103 | 9572 | 116 |
1710347 | 1710347 | 2021-09-12 | Leavenworth | Kansas | 20103 | 9465 | 115 |
1707100 | 1707100 | 2021-09-11 | Leavenworth | Kansas | 20103 | 9465 | 115 |
1703852 | 1703852 | 2021-09-10 | Leavenworth | Kansas | 20103 | 9465 | 115 |
1700602 | 1700602 | 2021-09-09 | Leavenworth | Kansas | 20103 | 9373 | 112 |
1697353 | 1697353 | 2021-09-08 | Leavenworth | Kansas | 20103 | 9373 | 112 |
1694105 | 1694105 | 2021-09-07 | Leavenworth | Kansas | 20103 | 9234 | 110 |
1690856 | 1690856 | 2021-09-06 | Leavenworth | Kansas | 20103 | 9234 | 110 |
1687606 | 1687606 | 2021-09-05 | Leavenworth | Kansas | 20103 | 9234 | 110 |
1684356 | 1684356 | 2021-09-04 | Leavenworth | Kansas | 20103 | 9234 | 110 |
1681105 | 1681105 | 2021-09-03 | Leavenworth | Kansas | 20103 | 9234 | 110 |
1677857 | 1677857 | 2021-09-02 | Leavenworth | Kansas | 20103 | 9162 | 108 |
1674610 | 1674610 | 2021-09-01 | Leavenworth | Kansas | 20103 | 9162 | 108 |
1671361 | 1671361 | 2021-08-31 | Leavenworth | Kansas | 20103 | 9071 | 107 |
1668114 | 1668114 | 2021-08-30 | Leavenworth | Kansas | 20103 | 9071 | 107 |
1664867 | 1664867 | 2021-08-29 | Leavenworth | Kansas | 20103 | 8972 | 107 |
1661619 | 1661619 | 2021-08-28 | Leavenworth | Kansas | 20103 | 8972 | 107 |
1658371 | 1658371 | 2021-08-27 | Leavenworth | Kansas | 20103 | 8972 | 107 |
1655123 | 1655123 | 2021-08-26 | Leavenworth | Kansas | 20103 | 8894 | 106 |
1651876 | 1651876 | 2021-08-25 | Leavenworth | Kansas | 20103 | 8894 | 106 |
1648627 | 1648627 | 2021-08-24 | Leavenworth | Kansas | 20103 | 8817 | 106 |
1645379 | 1645379 | 2021-08-23 | Leavenworth | Kansas | 20103 | 8817 | 106 |
1642130 | 1642130 | 2021-08-22 | Leavenworth | Kansas | 20103 | 8729 | 106 |
1638880 | 1638880 | 2021-08-21 | Leavenworth | Kansas | 20103 | 8729 | 106 |
1635630 | 1635630 | 2021-08-20 | Leavenworth | Kansas | 20103 | 8729 | 106 |
1632380 | 1632380 | 2021-08-19 | Leavenworth | Kansas | 20103 | 8652 | 104 |
1629133 | 1629133 | 2021-08-18 | Leavenworth | Kansas | 20103 | 8652 | 104 |
1625886 | 1625886 | 2021-08-17 | Leavenworth | Kansas | 20103 | 8558 | 104 |
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);