ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 36079 and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2104512 | 2104512 | 2022-01-11 | Putnam | New York | 36079 | 20439 | 109 |
2101261 | 2101261 | 2022-01-10 | Putnam | New York | 36079 | 20268 | 108 |
2098010 | 2098010 | 2022-01-09 | Putnam | New York | 36079 | 20016 | 108 |
2094758 | 2094758 | 2022-01-08 | Putnam | New York | 36079 | 19693 | 106 |
2091506 | 2091506 | 2022-01-07 | Putnam | New York | 36079 | 19290 | 106 |
2088255 | 2088255 | 2022-01-06 | Putnam | New York | 36079 | 18882 | 106 |
2085003 | 2085003 | 2022-01-05 | Putnam | New York | 36079 | 18503 | 106 |
2081751 | 2081751 | 2022-01-04 | Putnam | New York | 36079 | 18156 | 106 |
2078499 | 2078499 | 2022-01-03 | Putnam | New York | 36079 | 17828 | 106 |
2075248 | 2075248 | 2022-01-02 | Putnam | New York | 36079 | 17569 | 106 |
2071997 | 2071997 | 2022-01-01 | Putnam | New York | 36079 | 17260 | 106 |
2068746 | 2068746 | 2021-12-31 | Putnam | New York | 36079 | 16740 | 106 |
2065495 | 2065495 | 2021-12-30 | Putnam | New York | 36079 | 16221 | 106 |
2062245 | 2062245 | 2021-12-29 | Putnam | New York | 36079 | 15754 | 106 |
2058996 | 2058996 | 2021-12-28 | Putnam | New York | 36079 | 15124 | 106 |
2055747 | 2055747 | 2021-12-27 | Putnam | New York | 36079 | 15104 | 106 |
2052497 | 2052497 | 2021-12-26 | Putnam | New York | 36079 | 15093 | 105 |
2049247 | 2049247 | 2021-12-25 | Putnam | New York | 36079 | 15020 | 104 |
2045997 | 2045997 | 2021-12-24 | Putnam | New York | 36079 | 15020 | 104 |
2042747 | 2042747 | 2021-12-23 | Putnam | New York | 36079 | 14811 | 104 |
2039498 | 2039498 | 2021-12-22 | Putnam | New York | 36079 | 14667 | 104 |
2036248 | 2036248 | 2021-12-21 | Putnam | New York | 36079 | 14533 | 104 |
2032998 | 2032998 | 2021-12-20 | Putnam | New York | 36079 | 14430 | 104 |
2029748 | 2029748 | 2021-12-19 | Putnam | New York | 36079 | 14320 | 104 |
2026497 | 2026497 | 2021-12-18 | Putnam | New York | 36079 | 14215 | 103 |
2023246 | 2023246 | 2021-12-17 | Putnam | New York | 36079 | 14119 | 103 |
2019995 | 2019995 | 2021-12-16 | Putnam | New York | 36079 | 14000 | 102 |
2016744 | 2016744 | 2021-12-15 | Putnam | New York | 36079 | 13932 | 102 |
2013494 | 2013494 | 2021-12-14 | Putnam | New York | 36079 | 13857 | 101 |
2010243 | 2010243 | 2021-12-13 | Putnam | New York | 36079 | 13808 | 101 |
2006992 | 2006992 | 2021-12-12 | Putnam | New York | 36079 | 13772 | 101 |
2003741 | 2003741 | 2021-12-11 | Putnam | New York | 36079 | 13714 | 101 |
2000490 | 2000490 | 2021-12-10 | Putnam | New York | 36079 | 13630 | 101 |
1997240 | 1997240 | 2021-12-09 | Putnam | New York | 36079 | 13565 | 101 |
1993989 | 1993989 | 2021-12-08 | Putnam | New York | 36079 | 13508 | 101 |
1990738 | 1990738 | 2021-12-07 | Putnam | New York | 36079 | 13437 | 101 |
1987487 | 1987487 | 2021-12-06 | Putnam | New York | 36079 | 13401 | 101 |
1984237 | 1984237 | 2021-12-05 | Putnam | New York | 36079 | 13365 | 101 |
1980987 | 1980987 | 2021-12-04 | Putnam | New York | 36079 | 13335 | 101 |
1977737 | 1977737 | 2021-12-03 | Putnam | New York | 36079 | 13290 | 101 |
1974487 | 1974487 | 2021-12-02 | Putnam | New York | 36079 | 13249 | 101 |
1971238 | 1971238 | 2021-12-01 | Putnam | New York | 36079 | 13194 | 101 |
1967988 | 1967988 | 2021-11-30 | Putnam | New York | 36079 | 13145 | 101 |
1964737 | 1964737 | 2021-11-29 | Putnam | New York | 36079 | 13122 | 101 |
1961485 | 1961485 | 2021-11-28 | Putnam | New York | 36079 | 13091 | 101 |
1958234 | 1958234 | 2021-11-27 | Putnam | New York | 36079 | 13074 | 101 |
1954983 | 1954983 | 2021-11-26 | Putnam | New York | 36079 | 13055 | 101 |
1951732 | 1951732 | 2021-11-25 | Putnam | New York | 36079 | 13013 | 101 |
1948481 | 1948481 | 2021-11-24 | Putnam | New York | 36079 | 12997 | 101 |
1945230 | 1945230 | 2021-11-23 | Putnam | New York | 36079 | 12972 | 101 |
1941979 | 1941979 | 2021-11-22 | Putnam | New York | 36079 | 12954 | 101 |
1938729 | 1938729 | 2021-11-21 | Putnam | New York | 36079 | 12937 | 101 |
1935479 | 1935479 | 2021-11-20 | Putnam | New York | 36079 | 12920 | 100 |
1932229 | 1932229 | 2021-11-19 | Putnam | New York | 36079 | 12905 | 100 |
1928978 | 1928978 | 2021-11-18 | Putnam | New York | 36079 | 12875 | 100 |
1925728 | 1925728 | 2021-11-17 | Putnam | New York | 36079 | 12852 | 99 |
1922479 | 1922479 | 2021-11-16 | Putnam | New York | 36079 | 12840 | 99 |
1919229 | 1919229 | 2021-11-15 | Putnam | New York | 36079 | 12824 | 99 |
1915979 | 1915979 | 2021-11-14 | Putnam | New York | 36079 | 12812 | 98 |
1912729 | 1912729 | 2021-11-13 | Putnam | New York | 36079 | 12802 | 98 |
1909479 | 1909479 | 2021-11-12 | Putnam | New York | 36079 | 12780 | 98 |
1906230 | 1906230 | 2021-11-11 | Putnam | New York | 36079 | 12764 | 98 |
1902981 | 1902981 | 2021-11-10 | Putnam | New York | 36079 | 12747 | 98 |
1899731 | 1899731 | 2021-11-09 | Putnam | New York | 36079 | 12734 | 98 |
1896481 | 1896481 | 2021-11-08 | Putnam | New York | 36079 | 12726 | 98 |
1893231 | 1893231 | 2021-11-07 | Putnam | New York | 36079 | 12716 | 98 |
1889981 | 1889981 | 2021-11-06 | Putnam | New York | 36079 | 12707 | 98 |
1886731 | 1886731 | 2021-11-05 | Putnam | New York | 36079 | 12698 | 98 |
1883482 | 1883482 | 2021-11-04 | Putnam | New York | 36079 | 12677 | 98 |
1880233 | 1880233 | 2021-11-03 | Putnam | New York | 36079 | 12669 | 98 |
1876984 | 1876984 | 2021-11-02 | Putnam | New York | 36079 | 12659 | 98 |
1873735 | 1873735 | 2021-11-01 | Putnam | New York | 36079 | 12650 | 98 |
1870486 | 1870486 | 2021-10-31 | Putnam | New York | 36079 | 12643 | 98 |
1867237 | 1867237 | 2021-10-30 | Putnam | New York | 36079 | 12632 | 98 |
1863988 | 1863988 | 2021-10-29 | Putnam | New York | 36079 | 12620 | 98 |
1860739 | 1860739 | 2021-10-28 | Putnam | New York | 36079 | 12600 | 98 |
1857490 | 1857490 | 2021-10-27 | Putnam | New York | 36079 | 12578 | 98 |
1854241 | 1854241 | 2021-10-26 | Putnam | New York | 36079 | 12557 | 98 |
1850992 | 1850992 | 2021-10-25 | Putnam | New York | 36079 | 12550 | 98 |
1847742 | 1847742 | 2021-10-24 | Putnam | New York | 36079 | 12541 | 98 |
1844492 | 1844492 | 2021-10-23 | Putnam | New York | 36079 | 12529 | 98 |
1841242 | 1841242 | 2021-10-22 | Putnam | New York | 36079 | 12509 | 98 |
1837993 | 1837993 | 2021-10-21 | Putnam | New York | 36079 | 12492 | 98 |
1834744 | 1834744 | 2021-10-20 | Putnam | New York | 36079 | 12469 | 97 |
1831495 | 1831495 | 2021-10-19 | Putnam | New York | 36079 | 12448 | 96 |
1828246 | 1828246 | 2021-10-18 | Putnam | New York | 36079 | 12439 | 96 |
1824997 | 1824997 | 2021-10-17 | Putnam | New York | 36079 | 12420 | 96 |
1821748 | 1821748 | 2021-10-16 | Putnam | New York | 36079 | 12405 | 96 |
1818499 | 1818499 | 2021-10-15 | Putnam | New York | 36079 | 12385 | 96 |
1815250 | 1815250 | 2021-10-14 | Putnam | New York | 36079 | 12358 | 96 |
1812002 | 1812002 | 2021-10-13 | Putnam | New York | 36079 | 12328 | 96 |
1808753 | 1808753 | 2021-10-12 | Putnam | New York | 36079 | 12290 | 96 |
1805502 | 1805502 | 2021-10-11 | Putnam | New York | 36079 | 12275 | 96 |
1802253 | 1802253 | 2021-10-10 | Putnam | New York | 36079 | 12244 | 96 |
1799004 | 1799004 | 2021-10-09 | Putnam | New York | 36079 | 12239 | 96 |
1795755 | 1795755 | 2021-10-08 | Putnam | New York | 36079 | 12209 | 96 |
1792506 | 1792506 | 2021-10-07 | Putnam | New York | 36079 | 12172 | 96 |
1789257 | 1789257 | 2021-10-06 | Putnam | New York | 36079 | 12141 | 96 |
1786009 | 1786009 | 2021-10-05 | Putnam | New York | 36079 | 12119 | 96 |
1782760 | 1782760 | 2021-10-04 | Putnam | New York | 36079 | 12103 | 96 |
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);