ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 29169 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175779 | 2175779 | 2022-02-02 | Pulaski | Missouri | 29169 | 8489 | 106 |
2172526 | 2172526 | 2022-02-01 | Pulaski | Missouri | 29169 | 8380 | 105 |
2169273 | 2169273 | 2022-01-31 | Pulaski | Missouri | 29169 | 8356 | 104 |
2166018 | 2166018 | 2022-01-30 | Pulaski | Missouri | 29169 | 8338 | 104 |
2162763 | 2162763 | 2022-01-29 | Pulaski | Missouri | 29169 | 8328 | 104 |
2159508 | 2159508 | 2022-01-28 | Pulaski | Missouri | 29169 | 8231 | 104 |
2156254 | 2156254 | 2022-01-27 | Pulaski | Missouri | 29169 | 8181 | 104 |
2153001 | 2153001 | 2022-01-26 | Pulaski | Missouri | 29169 | 8012 | 104 |
2149749 | 2149749 | 2022-01-25 | Pulaski | Missouri | 29169 | 7827 | 104 |
2146497 | 2146497 | 2022-01-24 | Pulaski | Missouri | 29169 | 7773 | 104 |
2143242 | 2143242 | 2022-01-23 | Pulaski | Missouri | 29169 | 7758 | 104 |
2139987 | 2139987 | 2022-01-22 | Pulaski | Missouri | 29169 | 7722 | 104 |
2136731 | 2136731 | 2022-01-21 | Pulaski | Missouri | 29169 | 7685 | 104 |
2133479 | 2133479 | 2022-01-20 | Pulaski | Missouri | 29169 | 7654 | 104 |
2130226 | 2130226 | 2022-01-19 | Pulaski | Missouri | 29169 | 7485 | 104 |
2126972 | 2126972 | 2022-01-18 | Pulaski | Missouri | 29169 | 7328 | 104 |
2123720 | 2123720 | 2022-01-17 | Pulaski | Missouri | 29169 | 7121 | 104 |
2120468 | 2120468 | 2022-01-16 | Pulaski | Missouri | 29169 | 7121 | 104 |
2117216 | 2117216 | 2022-01-15 | Pulaski | Missouri | 29169 | 7121 | 104 |
2113965 | 2113965 | 2022-01-14 | Pulaski | Missouri | 29169 | 6973 | 104 |
2110713 | 2110713 | 2022-01-13 | Pulaski | Missouri | 29169 | 6956 | 104 |
2107462 | 2107462 | 2022-01-12 | Pulaski | Missouri | 29169 | 6389 | 104 |
2104211 | 2104211 | 2022-01-11 | Pulaski | Missouri | 29169 | 6310 | 104 |
2100960 | 2100960 | 2022-01-10 | Pulaski | Missouri | 29169 | 6209 | 102 |
2097709 | 2097709 | 2022-01-09 | Pulaski | Missouri | 29169 | 6170 | 102 |
2094457 | 2094457 | 2022-01-08 | Pulaski | Missouri | 29169 | 6167 | 102 |
2091205 | 2091205 | 2022-01-07 | Pulaski | Missouri | 29169 | 6105 | 101 |
2087954 | 2087954 | 2022-01-06 | Pulaski | Missouri | 29169 | 6051 | 101 |
2084702 | 2084702 | 2022-01-05 | Pulaski | Missouri | 29169 | 6003 | 101 |
2081450 | 2081450 | 2022-01-04 | Pulaski | Missouri | 29169 | 5958 | 101 |
2078198 | 2078198 | 2022-01-03 | Pulaski | Missouri | 29169 | 5939 | 100 |
2074947 | 2074947 | 2022-01-02 | Pulaski | Missouri | 29169 | 5880 | 100 |
2071696 | 2071696 | 2022-01-01 | Pulaski | Missouri | 29169 | 5880 | 100 |
2068445 | 2068445 | 2021-12-31 | Pulaski | Missouri | 29169 | 5880 | 100 |
2065194 | 2065194 | 2021-12-30 | Pulaski | Missouri | 29169 | 5880 | 100 |
2061944 | 2061944 | 2021-12-29 | Pulaski | Missouri | 29169 | 5860 | 100 |
2058695 | 2058695 | 2021-12-28 | Pulaski | Missouri | 29169 | 5851 | 100 |
2055446 | 2055446 | 2021-12-27 | Pulaski | Missouri | 29169 | 5839 | 99 |
2052196 | 2052196 | 2021-12-26 | Pulaski | Missouri | 29169 | 5822 | 99 |
2048946 | 2048946 | 2021-12-25 | Pulaski | Missouri | 29169 | 5822 | 99 |
2045696 | 2045696 | 2021-12-24 | Pulaski | Missouri | 29169 | 5822 | 99 |
2042446 | 2042446 | 2021-12-23 | Pulaski | Missouri | 29169 | 5821 | 99 |
2039197 | 2039197 | 2021-12-22 | Pulaski | Missouri | 29169 | 5811 | 98 |
2035947 | 2035947 | 2021-12-21 | Pulaski | Missouri | 29169 | 5805 | 98 |
2032697 | 2032697 | 2021-12-20 | Pulaski | Missouri | 29169 | 5797 | 97 |
2029446 | 2029446 | 2021-12-19 | Pulaski | Missouri | 29169 | 5788 | 97 |
2026195 | 2026195 | 2021-12-18 | Pulaski | Missouri | 29169 | 5783 | 97 |
2022944 | 2022944 | 2021-12-17 | Pulaski | Missouri | 29169 | 5771 | 97 |
2019693 | 2019693 | 2021-12-16 | Pulaski | Missouri | 29169 | 5761 | 97 |
2016443 | 2016443 | 2021-12-15 | Pulaski | Missouri | 29169 | 5750 | 97 |
2013192 | 2013192 | 2021-12-14 | Pulaski | Missouri | 29169 | 5738 | 97 |
2009941 | 2009941 | 2021-12-13 | Pulaski | Missouri | 29169 | 5732 | 97 |
2006690 | 2006690 | 2021-12-12 | Pulaski | Missouri | 29169 | 5726 | 97 |
2003439 | 2003439 | 2021-12-11 | Pulaski | Missouri | 29169 | 5722 | 97 |
2000189 | 2000189 | 2021-12-10 | Pulaski | Missouri | 29169 | 5714 | 97 |
1996938 | 1996938 | 2021-12-09 | Pulaski | Missouri | 29169 | 5694 | 97 |
1993687 | 1993687 | 2021-12-08 | Pulaski | Missouri | 29169 | 5685 | 97 |
1990436 | 1990436 | 2021-12-07 | Pulaski | Missouri | 29169 | 5669 | 97 |
1987186 | 1987186 | 2021-12-06 | Pulaski | Missouri | 29169 | 5660 | 97 |
1983936 | 1983936 | 2021-12-05 | Pulaski | Missouri | 29169 | 5649 | 97 |
1980686 | 1980686 | 2021-12-04 | Pulaski | Missouri | 29169 | 5648 | 97 |
1977436 | 1977436 | 2021-12-03 | Pulaski | Missouri | 29169 | 5624 | 97 |
1974186 | 1974186 | 2021-12-02 | Pulaski | Missouri | 29169 | 5624 | 97 |
1970937 | 1970937 | 2021-12-01 | Pulaski | Missouri | 29169 | 5601 | 97 |
1967687 | 1967687 | 2021-11-30 | Pulaski | Missouri | 29169 | 5590 | 97 |
1964435 | 1964435 | 2021-11-29 | Pulaski | Missouri | 29169 | 5580 | 97 |
1961184 | 1961184 | 2021-11-28 | Pulaski | Missouri | 29169 | 5549 | 97 |
1957933 | 1957933 | 2021-11-27 | Pulaski | Missouri | 29169 | 5549 | 97 |
1954682 | 1954682 | 2021-11-26 | Pulaski | Missouri | 29169 | 5549 | 97 |
1951431 | 1951431 | 2021-11-25 | Pulaski | Missouri | 29169 | 5549 | 97 |
1948180 | 1948180 | 2021-11-24 | Pulaski | Missouri | 29169 | 5549 | 97 |
1944929 | 1944929 | 2021-11-23 | Pulaski | Missouri | 29169 | 5540 | 97 |
1941678 | 1941678 | 2021-11-22 | Pulaski | Missouri | 29169 | 5534 | 96 |
1938428 | 1938428 | 2021-11-21 | Pulaski | Missouri | 29169 | 5531 | 96 |
1935178 | 1935178 | 2021-11-20 | Pulaski | Missouri | 29169 | 5526 | 96 |
1931928 | 1931928 | 2021-11-19 | Pulaski | Missouri | 29169 | 5521 | 96 |
1928677 | 1928677 | 2021-11-18 | Pulaski | Missouri | 29169 | 5513 | 96 |
1925427 | 1925427 | 2021-11-17 | Pulaski | Missouri | 29169 | 5453 | 82 |
1922178 | 1922178 | 2021-11-16 | Pulaski | Missouri | 29169 | 5446 | 82 |
1918928 | 1918928 | 2021-11-15 | Pulaski | Missouri | 29169 | 5437 | 80 |
1915678 | 1915678 | 2021-11-14 | Pulaski | Missouri | 29169 | 5433 | 80 |
1912428 | 1912428 | 2021-11-13 | Pulaski | Missouri | 29169 | 5426 | 80 |
1909178 | 1909178 | 2021-11-12 | Pulaski | Missouri | 29169 | 5420 | 80 |
1905929 | 1905929 | 2021-11-11 | Pulaski | Missouri | 29169 | 5396 | 80 |
1902680 | 1902680 | 2021-11-10 | Pulaski | Missouri | 29169 | 5396 | 80 |
1899430 | 1899430 | 2021-11-09 | Pulaski | Missouri | 29169 | 5381 | 80 |
1896180 | 1896180 | 2021-11-08 | Pulaski | Missouri | 29169 | 5366 | 79 |
1892930 | 1892930 | 2021-11-07 | Pulaski | Missouri | 29169 | 5362 | 79 |
1889680 | 1889680 | 2021-11-06 | Pulaski | Missouri | 29169 | 5356 | 79 |
1886430 | 1886430 | 2021-11-05 | Pulaski | Missouri | 29169 | 5340 | 79 |
1883181 | 1883181 | 2021-11-04 | Pulaski | Missouri | 29169 | 5334 | 79 |
1879932 | 1879932 | 2021-11-03 | Pulaski | Missouri | 29169 | 5320 | 79 |
1876683 | 1876683 | 2021-11-02 | Pulaski | Missouri | 29169 | 5309 | 79 |
1873434 | 1873434 | 2021-11-01 | Pulaski | Missouri | 29169 | 5295 | 79 |
1870185 | 1870185 | 2021-10-31 | Pulaski | Missouri | 29169 | 5290 | 79 |
1866936 | 1866936 | 2021-10-30 | Pulaski | Missouri | 29169 | 5282 | 79 |
1863687 | 1863687 | 2021-10-29 | Pulaski | Missouri | 29169 | 5271 | 79 |
1860438 | 1860438 | 2021-10-28 | Pulaski | Missouri | 29169 | 5257 | 79 |
1857189 | 1857189 | 2021-10-27 | Pulaski | Missouri | 29169 | 5237 | 79 |
1853940 | 1853940 | 2021-10-26 | Pulaski | Missouri | 29169 | 5224 | 79 |
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);