ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 36051 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 |
---|---|---|---|---|---|---|---|
2176067 | 2176067 | 2022-02-02 | Livingston | New York | 36051 | 11062 | 104 |
2172814 | 2172814 | 2022-02-01 | Livingston | New York | 36051 | 11030 | 102 |
2169561 | 2169561 | 2022-01-31 | Livingston | New York | 36051 | 11015 | 102 |
2166306 | 2166306 | 2022-01-30 | Livingston | New York | 36051 | 10994 | 102 |
2163051 | 2163051 | 2022-01-29 | Livingston | New York | 36051 | 10954 | 102 |
2159796 | 2159796 | 2022-01-28 | Livingston | New York | 36051 | 10884 | 102 |
2156541 | 2156541 | 2022-01-27 | Livingston | New York | 36051 | 10842 | 102 |
2153288 | 2153288 | 2022-01-26 | Livingston | New York | 36051 | 10765 | 102 |
2150036 | 2150036 | 2022-01-25 | Livingston | New York | 36051 | 10716 | 102 |
2146784 | 2146784 | 2022-01-24 | Livingston | New York | 36051 | 10676 | 101 |
2143530 | 2143530 | 2022-01-23 | Livingston | New York | 36051 | 10627 | 100 |
2140275 | 2140275 | 2022-01-22 | Livingston | New York | 36051 | 10566 | 100 |
2137019 | 2137019 | 2022-01-21 | Livingston | New York | 36051 | 10467 | 100 |
2133766 | 2133766 | 2022-01-20 | Livingston | New York | 36051 | 10343 | 100 |
2130514 | 2130514 | 2022-01-19 | Livingston | New York | 36051 | 10227 | 99 |
2127260 | 2127260 | 2022-01-18 | Livingston | New York | 36051 | 10206 | 98 |
2124008 | 2124008 | 2022-01-17 | Livingston | New York | 36051 | 10164 | 98 |
2120756 | 2120756 | 2022-01-16 | Livingston | New York | 36051 | 10114 | 98 |
2117504 | 2117504 | 2022-01-15 | Livingston | New York | 36051 | 9947 | 97 |
2114253 | 2114253 | 2022-01-14 | Livingston | New York | 36051 | 9831 | 97 |
2111001 | 2111001 | 2022-01-13 | Livingston | New York | 36051 | 9722 | 97 |
2107749 | 2107749 | 2022-01-12 | Livingston | New York | 36051 | 9594 | 96 |
2104498 | 2104498 | 2022-01-11 | Livingston | New York | 36051 | 9463 | 96 |
2101247 | 2101247 | 2022-01-10 | Livingston | New York | 36051 | 9394 | 96 |
2097996 | 2097996 | 2022-01-09 | Livingston | New York | 36051 | 9328 | 96 |
2094744 | 2094744 | 2022-01-08 | Livingston | New York | 36051 | 9222 | 96 |
2091492 | 2091492 | 2022-01-07 | Livingston | New York | 36051 | 9077 | 96 |
2088241 | 2088241 | 2022-01-06 | Livingston | New York | 36051 | 8932 | 95 |
2084989 | 2084989 | 2022-01-05 | Livingston | New York | 36051 | 8824 | 94 |
2081737 | 2081737 | 2022-01-04 | Livingston | New York | 36051 | 8757 | 93 |
2078485 | 2078485 | 2022-01-03 | Livingston | New York | 36051 | 8691 | 93 |
2075234 | 2075234 | 2022-01-02 | Livingston | New York | 36051 | 8636 | 93 |
2071983 | 2071983 | 2022-01-01 | Livingston | New York | 36051 | 8605 | 93 |
2068732 | 2068732 | 2021-12-31 | Livingston | New York | 36051 | 8508 | 93 |
2065481 | 2065481 | 2021-12-30 | Livingston | New York | 36051 | 8462 | 93 |
2062231 | 2062231 | 2021-12-29 | Livingston | New York | 36051 | 8371 | 93 |
2058982 | 2058982 | 2021-12-28 | Livingston | New York | 36051 | 8299 | 92 |
2055733 | 2055733 | 2021-12-27 | Livingston | New York | 36051 | 8291 | 92 |
2052483 | 2052483 | 2021-12-26 | Livingston | New York | 36051 | 8284 | 92 |
2049233 | 2049233 | 2021-12-25 | Livingston | New York | 36051 | 8247 | 90 |
2045983 | 2045983 | 2021-12-24 | Livingston | New York | 36051 | 8247 | 90 |
2042733 | 2042733 | 2021-12-23 | Livingston | New York | 36051 | 8198 | 89 |
2039484 | 2039484 | 2021-12-22 | Livingston | New York | 36051 | 8147 | 88 |
2036234 | 2036234 | 2021-12-21 | Livingston | New York | 36051 | 8105 | 88 |
2032984 | 2032984 | 2021-12-20 | Livingston | New York | 36051 | 8092 | 87 |
2029734 | 2029734 | 2021-12-19 | Livingston | New York | 36051 | 8064 | 87 |
2026483 | 2026483 | 2021-12-18 | Livingston | New York | 36051 | 8040 | 87 |
2023232 | 2023232 | 2021-12-17 | Livingston | New York | 36051 | 7976 | 86 |
2019981 | 2019981 | 2021-12-16 | Livingston | New York | 36051 | 7940 | 85 |
2016730 | 2016730 | 2021-12-15 | Livingston | New York | 36051 | 7899 | 85 |
2013480 | 2013480 | 2021-12-14 | Livingston | New York | 36051 | 7841 | 84 |
2010229 | 2010229 | 2021-12-13 | Livingston | New York | 36051 | 7820 | 83 |
2006978 | 2006978 | 2021-12-12 | Livingston | New York | 36051 | 7797 | 82 |
2003727 | 2003727 | 2021-12-11 | Livingston | New York | 36051 | 7760 | 81 |
2000476 | 2000476 | 2021-12-10 | Livingston | New York | 36051 | 7714 | 81 |
1997226 | 1997226 | 2021-12-09 | Livingston | New York | 36051 | 7665 | 81 |
1993975 | 1993975 | 2021-12-08 | Livingston | New York | 36051 | 7603 | 80 |
1990724 | 1990724 | 2021-12-07 | Livingston | New York | 36051 | 7568 | 79 |
1987473 | 1987473 | 2021-12-06 | Livingston | New York | 36051 | 7528 | 79 |
1984223 | 1984223 | 2021-12-05 | Livingston | New York | 36051 | 7513 | 78 |
1980973 | 1980973 | 2021-12-04 | Livingston | New York | 36051 | 7459 | 77 |
1977723 | 1977723 | 2021-12-03 | Livingston | New York | 36051 | 7402 | 77 |
1974473 | 1974473 | 2021-12-02 | Livingston | New York | 36051 | 7327 | 77 |
1971224 | 1971224 | 2021-12-01 | Livingston | New York | 36051 | 7263 | 77 |
1967974 | 1967974 | 2021-11-30 | Livingston | New York | 36051 | 7221 | 76 |
1964723 | 1964723 | 2021-11-29 | Livingston | New York | 36051 | 7172 | 76 |
1961471 | 1961471 | 2021-11-28 | Livingston | New York | 36051 | 7132 | 76 |
1958220 | 1958220 | 2021-11-27 | Livingston | New York | 36051 | 7114 | 76 |
1954969 | 1954969 | 2021-11-26 | Livingston | New York | 36051 | 7079 | 75 |
1951718 | 1951718 | 2021-11-25 | Livingston | New York | 36051 | 7037 | 75 |
1948467 | 1948467 | 2021-11-24 | Livingston | New York | 36051 | 6973 | 74 |
1945216 | 1945216 | 2021-11-23 | Livingston | New York | 36051 | 6936 | 74 |
1941965 | 1941965 | 2021-11-22 | Livingston | New York | 36051 | 6905 | 74 |
1938715 | 1938715 | 2021-11-21 | Livingston | New York | 36051 | 6870 | 74 |
1935465 | 1935465 | 2021-11-20 | Livingston | New York | 36051 | 6819 | 74 |
1932215 | 1932215 | 2021-11-19 | Livingston | New York | 36051 | 6757 | 74 |
1928964 | 1928964 | 2021-11-18 | Livingston | New York | 36051 | 6698 | 72 |
1925714 | 1925714 | 2021-11-17 | Livingston | New York | 36051 | 6622 | 72 |
1922465 | 1922465 | 2021-11-16 | Livingston | New York | 36051 | 6579 | 72 |
1919215 | 1919215 | 2021-11-15 | Livingston | New York | 36051 | 6520 | 72 |
1915965 | 1915965 | 2021-11-14 | Livingston | New York | 36051 | 6474 | 72 |
1912715 | 1912715 | 2021-11-13 | Livingston | New York | 36051 | 6429 | 72 |
1909465 | 1909465 | 2021-11-12 | Livingston | New York | 36051 | 6383 | 72 |
1906216 | 1906216 | 2021-11-11 | Livingston | New York | 36051 | 6331 | 72 |
1902967 | 1902967 | 2021-11-10 | Livingston | New York | 36051 | 6282 | 72 |
1899717 | 1899717 | 2021-11-09 | Livingston | New York | 36051 | 6249 | 72 |
1896467 | 1896467 | 2021-11-08 | Livingston | New York | 36051 | 6215 | 71 |
1893217 | 1893217 | 2021-11-07 | Livingston | New York | 36051 | 6200 | 71 |
1889967 | 1889967 | 2021-11-06 | Livingston | New York | 36051 | 6161 | 71 |
1886717 | 1886717 | 2021-11-05 | Livingston | New York | 36051 | 6117 | 71 |
1883468 | 1883468 | 2021-11-04 | Livingston | New York | 36051 | 6078 | 71 |
1880219 | 1880219 | 2021-11-03 | Livingston | New York | 36051 | 6040 | 71 |
1876970 | 1876970 | 2021-11-02 | Livingston | New York | 36051 | 6007 | 71 |
1873721 | 1873721 | 2021-11-01 | Livingston | New York | 36051 | 5989 | 71 |
1870472 | 1870472 | 2021-10-31 | Livingston | New York | 36051 | 5970 | 71 |
1867223 | 1867223 | 2021-10-30 | Livingston | New York | 36051 | 5935 | 71 |
1863974 | 1863974 | 2021-10-29 | Livingston | New York | 36051 | 5918 | 71 |
1860725 | 1860725 | 2021-10-28 | Livingston | New York | 36051 | 5887 | 71 |
1857476 | 1857476 | 2021-10-27 | Livingston | New York | 36051 | 5845 | 71 |
1854227 | 1854227 | 2021-10-26 | Livingston | New York | 36051 | 5819 | 71 |
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);