ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Putnam" 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 |
---|---|---|---|---|---|---|---|
2176081 | 2176081 | 2022-02-02 | Putnam | New York | 36079 | 22878 | 118 |
2172828 | 2172828 | 2022-02-01 | Putnam | New York | 36079 | 22846 | 117 |
2169575 | 2169575 | 2022-01-31 | Putnam | New York | 36079 | 22828 | 117 |
2166320 | 2166320 | 2022-01-30 | Putnam | New York | 36079 | 22817 | 117 |
2163065 | 2163065 | 2022-01-29 | Putnam | New York | 36079 | 22781 | 117 |
2159810 | 2159810 | 2022-01-28 | Putnam | New York | 36079 | 22726 | 117 |
2156555 | 2156555 | 2022-01-27 | Putnam | New York | 36079 | 22661 | 117 |
2153302 | 2153302 | 2022-01-26 | Putnam | New York | 36079 | 22581 | 116 |
2150050 | 2150050 | 2022-01-25 | Putnam | New York | 36079 | 22529 | 116 |
2146798 | 2146798 | 2022-01-24 | Putnam | New York | 36079 | 22447 | 116 |
2143544 | 2143544 | 2022-01-23 | Putnam | New York | 36079 | 22373 | 116 |
2140289 | 2140289 | 2022-01-22 | Putnam | New York | 36079 | 22308 | 116 |
2137033 | 2137033 | 2022-01-21 | Putnam | New York | 36079 | 22208 | 115 |
2133780 | 2133780 | 2022-01-20 | Putnam | New York | 36079 | 22097 | 115 |
2130528 | 2130528 | 2022-01-19 | Putnam | New York | 36079 | 21931 | 113 |
2127274 | 2127274 | 2022-01-18 | Putnam | New York | 36079 | 21827 | 113 |
2124022 | 2124022 | 2022-01-17 | Putnam | New York | 36079 | 21747 | 112 |
2120770 | 2120770 | 2022-01-16 | Putnam | New York | 36079 | 21613 | 112 |
2117518 | 2117518 | 2022-01-15 | Putnam | New York | 36079 | 21431 | 112 |
2114267 | 2114267 | 2022-01-14 | Putnam | New York | 36079 | 21197 | 111 |
2111015 | 2111015 | 2022-01-13 | Putnam | New York | 36079 | 20931 | 110 |
2107763 | 2107763 | 2022-01-12 | Putnam | New York | 36079 | 20671 | 110 |
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 |
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);