ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Jefferson" and fips = 36045 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-03-18 1
- 2020-03-19 1
- 2020-03-20 1
- 2020-03-21 1
- 2020-03-22 1
- 2020-03-23 1
- 2020-03-24 1
- 2020-03-25 1
- 2020-03-26 1
- 2020-03-27 1
- 2020-03-28 1
- 2020-03-29 1
- 2020-03-30 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-02 1
- 2020-04-03 1
- 2020-04-04 1
- 2020-04-05 1
- 2020-04-06 1
- 2020-04-07 1
- 2020-04-08 1
- 2020-04-09 1
- 2020-04-10 1
- 2020-04-11 1
- 2020-04-12 1
- 2020-04-13 1
- 2020-04-14 1
- 2020-04-15 1
- 2020-04-16 1
- …
state 1
- New York 687
fips 1
- 36045 · 687 ✖
county 1
- Jefferson · 687 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176065 | 2176065 | 2022-02-02 | Jefferson | New York | 36045 | 18626 | 125 |
2172812 | 2172812 | 2022-02-01 | Jefferson | New York | 36045 | 18526 | 125 |
2169559 | 2169559 | 2022-01-31 | Jefferson | New York | 36045 | 18463 | 125 |
2166304 | 2166304 | 2022-01-30 | Jefferson | New York | 36045 | 18410 | 125 |
2163049 | 2163049 | 2022-01-29 | Jefferson | New York | 36045 | 18328 | 125 |
2159794 | 2159794 | 2022-01-28 | Jefferson | New York | 36045 | 18197 | 125 |
2156539 | 2156539 | 2022-01-27 | Jefferson | New York | 36045 | 18070 | 124 |
2153286 | 2153286 | 2022-01-26 | Jefferson | New York | 36045 | 17935 | 123 |
2150034 | 2150034 | 2022-01-25 | Jefferson | New York | 36045 | 17794 | 123 |
2146782 | 2146782 | 2022-01-24 | Jefferson | New York | 36045 | 17685 | 123 |
2143528 | 2143528 | 2022-01-23 | Jefferson | New York | 36045 | 17586 | 123 |
2140273 | 2140273 | 2022-01-22 | Jefferson | New York | 36045 | 17446 | 123 |
2137017 | 2137017 | 2022-01-21 | Jefferson | New York | 36045 | 17236 | 121 |
2133764 | 2133764 | 2022-01-20 | Jefferson | New York | 36045 | 16984 | 120 |
2130512 | 2130512 | 2022-01-19 | Jefferson | New York | 36045 | 16766 | 120 |
2127258 | 2127258 | 2022-01-18 | Jefferson | New York | 36045 | 16619 | 120 |
2124006 | 2124006 | 2022-01-17 | Jefferson | New York | 36045 | 16495 | 120 |
2120754 | 2120754 | 2022-01-16 | Jefferson | New York | 36045 | 16337 | 120 |
2117502 | 2117502 | 2022-01-15 | Jefferson | New York | 36045 | 16135 | 119 |
2114251 | 2114251 | 2022-01-14 | Jefferson | New York | 36045 | 15920 | 119 |
2110999 | 2110999 | 2022-01-13 | Jefferson | New York | 36045 | 15671 | 119 |
2107747 | 2107747 | 2022-01-12 | Jefferson | New York | 36045 | 15433 | 119 |
2104496 | 2104496 | 2022-01-11 | Jefferson | New York | 36045 | 15223 | 119 |
2101245 | 2101245 | 2022-01-10 | Jefferson | New York | 36045 | 15032 | 119 |
2097994 | 2097994 | 2022-01-09 | Jefferson | New York | 36045 | 14816 | 119 |
2094742 | 2094742 | 2022-01-08 | Jefferson | New York | 36045 | 14586 | 119 |
2091490 | 2091490 | 2022-01-07 | Jefferson | New York | 36045 | 14355 | 118 |
2088239 | 2088239 | 2022-01-06 | Jefferson | New York | 36045 | 14082 | 118 |
2084987 | 2084987 | 2022-01-05 | Jefferson | New York | 36045 | 13814 | 118 |
2081735 | 2081735 | 2022-01-04 | Jefferson | New York | 36045 | 13641 | 118 |
2078483 | 2078483 | 2022-01-03 | Jefferson | New York | 36045 | 13524 | 118 |
2075232 | 2075232 | 2022-01-02 | Jefferson | New York | 36045 | 13437 | 118 |
2071981 | 2071981 | 2022-01-01 | Jefferson | New York | 36045 | 13354 | 118 |
2068730 | 2068730 | 2021-12-31 | Jefferson | New York | 36045 | 13251 | 118 |
2065479 | 2065479 | 2021-12-30 | Jefferson | New York | 36045 | 13131 | 118 |
2062229 | 2062229 | 2021-12-29 | Jefferson | New York | 36045 | 13033 | 116 |
2058980 | 2058980 | 2021-12-28 | Jefferson | New York | 36045 | 12949 | 116 |
2055731 | 2055731 | 2021-12-27 | Jefferson | New York | 36045 | 12903 | 116 |
2052481 | 2052481 | 2021-12-26 | Jefferson | New York | 36045 | 12884 | 114 |
2049231 | 2049231 | 2021-12-25 | Jefferson | New York | 36045 | 12825 | 114 |
2045981 | 2045981 | 2021-12-24 | Jefferson | New York | 36045 | 12825 | 114 |
2042731 | 2042731 | 2021-12-23 | Jefferson | New York | 36045 | 12776 | 114 |
2039482 | 2039482 | 2021-12-22 | Jefferson | New York | 36045 | 12733 | 114 |
2036232 | 2036232 | 2021-12-21 | Jefferson | New York | 36045 | 12702 | 114 |
2032982 | 2032982 | 2021-12-20 | Jefferson | New York | 36045 | 12665 | 114 |
2029732 | 2029732 | 2021-12-19 | Jefferson | New York | 36045 | 12629 | 114 |
2026481 | 2026481 | 2021-12-18 | Jefferson | New York | 36045 | 12609 | 113 |
2023230 | 2023230 | 2021-12-17 | Jefferson | New York | 36045 | 12573 | 113 |
2019979 | 2019979 | 2021-12-16 | Jefferson | New York | 36045 | 12501 | 113 |
2016728 | 2016728 | 2021-12-15 | Jefferson | New York | 36045 | 12448 | 113 |
2013478 | 2013478 | 2021-12-14 | Jefferson | New York | 36045 | 12406 | 113 |
2010227 | 2010227 | 2021-12-13 | Jefferson | New York | 36045 | 12363 | 112 |
2006976 | 2006976 | 2021-12-12 | Jefferson | New York | 36045 | 12324 | 112 |
2003725 | 2003725 | 2021-12-11 | Jefferson | New York | 36045 | 12251 | 112 |
2000474 | 2000474 | 2021-12-10 | Jefferson | New York | 36045 | 12162 | 112 |
1997224 | 1997224 | 2021-12-09 | Jefferson | New York | 36045 | 12093 | 111 |
1993973 | 1993973 | 2021-12-08 | Jefferson | New York | 36045 | 12022 | 108 |
1990722 | 1990722 | 2021-12-07 | Jefferson | New York | 36045 | 11931 | 108 |
1987471 | 1987471 | 2021-12-06 | Jefferson | New York | 36045 | 11856 | 108 |
1984221 | 1984221 | 2021-12-05 | Jefferson | New York | 36045 | 11798 | 108 |
1980971 | 1980971 | 2021-12-04 | Jefferson | New York | 36045 | 11736 | 108 |
1977721 | 1977721 | 2021-12-03 | Jefferson | New York | 36045 | 11657 | 108 |
1974471 | 1974471 | 2021-12-02 | Jefferson | New York | 36045 | 11567 | 108 |
1971222 | 1971222 | 2021-12-01 | Jefferson | New York | 36045 | 11484 | 106 |
1967972 | 1967972 | 2021-11-30 | Jefferson | New York | 36045 | 11388 | 106 |
1964721 | 1964721 | 2021-11-29 | Jefferson | New York | 36045 | 11301 | 105 |
1961469 | 1961469 | 2021-11-28 | Jefferson | New York | 36045 | 11237 | 105 |
1958218 | 1958218 | 2021-11-27 | Jefferson | New York | 36045 | 11202 | 105 |
1954967 | 1954967 | 2021-11-26 | Jefferson | New York | 36045 | 11123 | 105 |
1951716 | 1951716 | 2021-11-25 | Jefferson | New York | 36045 | 11088 | 105 |
1948465 | 1948465 | 2021-11-24 | Jefferson | New York | 36045 | 10998 | 105 |
1945214 | 1945214 | 2021-11-23 | Jefferson | New York | 36045 | 10919 | 105 |
1941963 | 1941963 | 2021-11-22 | Jefferson | New York | 36045 | 10839 | 105 |
1938713 | 1938713 | 2021-11-21 | Jefferson | New York | 36045 | 10799 | 103 |
1935463 | 1935463 | 2021-11-20 | Jefferson | New York | 36045 | 10743 | 101 |
1932213 | 1932213 | 2021-11-19 | Jefferson | New York | 36045 | 10672 | 101 |
1928962 | 1928962 | 2021-11-18 | Jefferson | New York | 36045 | 10564 | 101 |
1925712 | 1925712 | 2021-11-17 | Jefferson | New York | 36045 | 10461 | 101 |
1922463 | 1922463 | 2021-11-16 | Jefferson | New York | 36045 | 10387 | 99 |
1919213 | 1919213 | 2021-11-15 | Jefferson | New York | 36045 | 10315 | 99 |
1915963 | 1915963 | 2021-11-14 | Jefferson | New York | 36045 | 10285 | 99 |
1912713 | 1912713 | 2021-11-13 | Jefferson | New York | 36045 | 10235 | 99 |
1909463 | 1909463 | 2021-11-12 | Jefferson | New York | 36045 | 10144 | 98 |
1906214 | 1906214 | 2021-11-11 | Jefferson | New York | 36045 | 10061 | 97 |
1902965 | 1902965 | 2021-11-10 | Jefferson | New York | 36045 | 9970 | 95 |
1899715 | 1899715 | 2021-11-09 | Jefferson | New York | 36045 | 9902 | 95 |
1896465 | 1896465 | 2021-11-08 | Jefferson | New York | 36045 | 9818 | 95 |
1893215 | 1893215 | 2021-11-07 | Jefferson | New York | 36045 | 9788 | 92 |
1889965 | 1889965 | 2021-11-06 | Jefferson | New York | 36045 | 9747 | 91 |
1886715 | 1886715 | 2021-11-05 | Jefferson | New York | 36045 | 9680 | 88 |
1883466 | 1883466 | 2021-11-04 | Jefferson | New York | 36045 | 9615 | 87 |
1880217 | 1880217 | 2021-11-03 | Jefferson | New York | 36045 | 9556 | 87 |
1876968 | 1876968 | 2021-11-02 | Jefferson | New York | 36045 | 9482 | 86 |
1873719 | 1873719 | 2021-11-01 | Jefferson | New York | 36045 | 9425 | 84 |
1870470 | 1870470 | 2021-10-31 | Jefferson | New York | 36045 | 9387 | 83 |
1867221 | 1867221 | 2021-10-30 | Jefferson | New York | 36045 | 9356 | 81 |
1863972 | 1863972 | 2021-10-29 | Jefferson | New York | 36045 | 9297 | 80 |
1860723 | 1860723 | 2021-10-28 | Jefferson | New York | 36045 | 9199 | 80 |
1857474 | 1857474 | 2021-10-27 | Jefferson | New York | 36045 | 9157 | 78 |
1854225 | 1854225 | 2021-10-26 | Jefferson | New York | 36045 | 9086 | 78 |
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);