ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Madison" 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 |
---|---|---|---|---|---|---|---|
2176068 | 2176068 | 2022-02-02 | Madison | New York | 36053 | 12115 | 120 |
2172815 | 2172815 | 2022-02-01 | Madison | New York | 36053 | 12058 | 120 |
2169562 | 2169562 | 2022-01-31 | Madison | New York | 36053 | 12032 | 120 |
2166307 | 2166307 | 2022-01-30 | Madison | New York | 36053 | 11995 | 120 |
2163052 | 2163052 | 2022-01-29 | Madison | New York | 36053 | 11952 | 120 |
2159797 | 2159797 | 2022-01-28 | Madison | New York | 36053 | 11882 | 120 |
2156542 | 2156542 | 2022-01-27 | Madison | New York | 36053 | 11830 | 120 |
2153289 | 2153289 | 2022-01-26 | Madison | New York | 36053 | 11734 | 120 |
2150037 | 2150037 | 2022-01-25 | Madison | New York | 36053 | 11625 | 120 |
2146785 | 2146785 | 2022-01-24 | Madison | New York | 36053 | 11560 | 120 |
2143531 | 2143531 | 2022-01-23 | Madison | New York | 36053 | 11492 | 120 |
2140276 | 2140276 | 2022-01-22 | Madison | New York | 36053 | 11445 | 120 |
2137020 | 2137020 | 2022-01-21 | Madison | New York | 36053 | 11311 | 120 |
2133767 | 2133767 | 2022-01-20 | Madison | New York | 36053 | 11211 | 120 |
2130515 | 2130515 | 2022-01-19 | Madison | New York | 36053 | 11092 | 120 |
2127261 | 2127261 | 2022-01-18 | Madison | New York | 36053 | 11011 | 120 |
2124009 | 2124009 | 2022-01-17 | Madison | New York | 36053 | 10949 | 118 |
2120757 | 2120757 | 2022-01-16 | Madison | New York | 36053 | 10877 | 118 |
2117505 | 2117505 | 2022-01-15 | Madison | New York | 36053 | 10797 | 118 |
2114254 | 2114254 | 2022-01-14 | Madison | New York | 36053 | 10677 | 118 |
2111002 | 2111002 | 2022-01-13 | Madison | New York | 36053 | 10528 | 118 |
2107750 | 2107750 | 2022-01-12 | Madison | New York | 36053 | 10412 | 118 |
2104499 | 2104499 | 2022-01-11 | Madison | New York | 36053 | 10299 | 118 |
2101248 | 2101248 | 2022-01-10 | Madison | New York | 36053 | 10177 | 118 |
2097997 | 2097997 | 2022-01-09 | Madison | New York | 36053 | 10111 | 118 |
2094745 | 2094745 | 2022-01-08 | Madison | New York | 36053 | 9976 | 118 |
2091493 | 2091493 | 2022-01-07 | Madison | New York | 36053 | 9815 | 118 |
2088242 | 2088242 | 2022-01-06 | Madison | New York | 36053 | 9701 | 118 |
2084990 | 2084990 | 2022-01-05 | Madison | New York | 36053 | 9544 | 118 |
2081738 | 2081738 | 2022-01-04 | Madison | New York | 36053 | 9430 | 117 |
2078486 | 2078486 | 2022-01-03 | Madison | New York | 36053 | 9357 | 117 |
2075235 | 2075235 | 2022-01-02 | Madison | New York | 36053 | 9306 | 117 |
2071984 | 2071984 | 2022-01-01 | Madison | New York | 36053 | 9237 | 117 |
2068733 | 2068733 | 2021-12-31 | Madison | New York | 36053 | 9086 | 116 |
2065482 | 2065482 | 2021-12-30 | Madison | New York | 36053 | 8976 | 115 |
2062232 | 2062232 | 2021-12-29 | Madison | New York | 36053 | 8869 | 114 |
2058983 | 2058983 | 2021-12-28 | Madison | New York | 36053 | 8717 | 114 |
2055734 | 2055734 | 2021-12-27 | Madison | New York | 36053 | 8703 | 114 |
2052484 | 2052484 | 2021-12-26 | Madison | New York | 36053 | 8702 | 114 |
2049234 | 2049234 | 2021-12-25 | Madison | New York | 36053 | 8672 | 114 |
2045984 | 2045984 | 2021-12-24 | Madison | New York | 36053 | 8672 | 114 |
2042734 | 2042734 | 2021-12-23 | Madison | New York | 36053 | 8609 | 114 |
2039485 | 2039485 | 2021-12-22 | Madison | New York | 36053 | 8518 | 114 |
2036235 | 2036235 | 2021-12-21 | Madison | New York | 36053 | 8461 | 113 |
2032985 | 2032985 | 2021-12-20 | Madison | New York | 36053 | 8415 | 113 |
2029735 | 2029735 | 2021-12-19 | Madison | New York | 36053 | 8387 | 113 |
2026484 | 2026484 | 2021-12-18 | Madison | New York | 36053 | 8341 | 113 |
2023233 | 2023233 | 2021-12-17 | Madison | New York | 36053 | 8280 | 113 |
2019982 | 2019982 | 2021-12-16 | Madison | New York | 36053 | 8229 | 113 |
2016731 | 2016731 | 2021-12-15 | Madison | New York | 36053 | 8165 | 113 |
2013481 | 2013481 | 2021-12-14 | Madison | New York | 36053 | 8097 | 113 |
2010230 | 2010230 | 2021-12-13 | Madison | New York | 36053 | 8059 | 113 |
2006979 | 2006979 | 2021-12-12 | Madison | New York | 36053 | 8026 | 112 |
2003728 | 2003728 | 2021-12-11 | Madison | New York | 36053 | 7968 | 111 |
2000477 | 2000477 | 2021-12-10 | Madison | New York | 36053 | 7908 | 111 |
1997227 | 1997227 | 2021-12-09 | Madison | New York | 36053 | 7844 | 111 |
1993976 | 1993976 | 2021-12-08 | Madison | New York | 36053 | 7789 | 111 |
1990725 | 1990725 | 2021-12-07 | Madison | New York | 36053 | 7721 | 110 |
1987474 | 1987474 | 2021-12-06 | Madison | New York | 36053 | 7680 | 110 |
1984224 | 1984224 | 2021-12-05 | Madison | New York | 36053 | 7654 | 109 |
1980974 | 1980974 | 2021-12-04 | Madison | New York | 36053 | 7614 | 109 |
1977724 | 1977724 | 2021-12-03 | Madison | New York | 36053 | 7563 | 109 |
1974474 | 1974474 | 2021-12-02 | Madison | New York | 36053 | 7504 | 109 |
1971225 | 1971225 | 2021-12-01 | Madison | New York | 36053 | 7412 | 109 |
1967975 | 1967975 | 2021-11-30 | Madison | New York | 36053 | 7365 | 109 |
1964724 | 1964724 | 2021-11-29 | Madison | New York | 36053 | 7321 | 108 |
1961472 | 1961472 | 2021-11-28 | Madison | New York | 36053 | 7285 | 108 |
1958221 | 1958221 | 2021-11-27 | Madison | New York | 36053 | 7259 | 108 |
1954970 | 1954970 | 2021-11-26 | Madison | New York | 36053 | 7246 | 108 |
1951719 | 1951719 | 2021-11-25 | Madison | New York | 36053 | 7219 | 108 |
1948468 | 1948468 | 2021-11-24 | Madison | New York | 36053 | 7179 | 108 |
1945217 | 1945217 | 2021-11-23 | Madison | New York | 36053 | 7146 | 108 |
1941966 | 1941966 | 2021-11-22 | Madison | New York | 36053 | 7118 | 108 |
1938716 | 1938716 | 2021-11-21 | Madison | New York | 36053 | 7097 | 107 |
1935466 | 1935466 | 2021-11-20 | Madison | New York | 36053 | 7059 | 107 |
1932216 | 1932216 | 2021-11-19 | Madison | New York | 36053 | 7030 | 107 |
1928965 | 1928965 | 2021-11-18 | Madison | New York | 36053 | 6994 | 107 |
1925715 | 1925715 | 2021-11-17 | Madison | New York | 36053 | 6936 | 107 |
1922466 | 1922466 | 2021-11-16 | Madison | New York | 36053 | 6905 | 107 |
1919216 | 1919216 | 2021-11-15 | Madison | New York | 36053 | 6878 | 107 |
1915966 | 1915966 | 2021-11-14 | Madison | New York | 36053 | 6853 | 107 |
1912716 | 1912716 | 2021-11-13 | Madison | New York | 36053 | 6830 | 107 |
1909466 | 1909466 | 2021-11-12 | Madison | New York | 36053 | 6780 | 107 |
1906217 | 1906217 | 2021-11-11 | Madison | New York | 36053 | 6740 | 107 |
1902968 | 1902968 | 2021-11-10 | Madison | New York | 36053 | 6701 | 107 |
1899718 | 1899718 | 2021-11-09 | Madison | New York | 36053 | 6671 | 107 |
1896468 | 1896468 | 2021-11-08 | Madison | New York | 36053 | 6639 | 107 |
1893218 | 1893218 | 2021-11-07 | Madison | New York | 36053 | 6620 | 107 |
1889968 | 1889968 | 2021-11-06 | Madison | New York | 36053 | 6604 | 107 |
1886718 | 1886718 | 2021-11-05 | Madison | New York | 36053 | 6581 | 107 |
1883469 | 1883469 | 2021-11-04 | Madison | New York | 36053 | 6541 | 107 |
1880220 | 1880220 | 2021-11-03 | Madison | New York | 36053 | 6490 | 107 |
1876971 | 1876971 | 2021-11-02 | Madison | New York | 36053 | 6470 | 107 |
1873722 | 1873722 | 2021-11-01 | Madison | New York | 36053 | 6452 | 107 |
1870473 | 1870473 | 2021-10-31 | Madison | New York | 36053 | 6435 | 106 |
1867224 | 1867224 | 2021-10-30 | Madison | New York | 36053 | 6418 | 106 |
1863975 | 1863975 | 2021-10-29 | Madison | New York | 36053 | 6390 | 104 |
1860726 | 1860726 | 2021-10-28 | Madison | New York | 36053 | 6365 | 104 |
1857477 | 1857477 | 2021-10-27 | Madison | New York | 36053 | 6334 | 104 |
1854228 | 1854228 | 2021-10-26 | Madison | New York | 36053 | 6303 | 103 |
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);