ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Jefferson" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174230 | 2174230 | 2022-02-02 | Jefferson | Alabama | 1073 | 176555 | 2089 |
2170978 | 2170978 | 2022-02-01 | Jefferson | Alabama | 1073 | 175899 | 2084 |
2167725 | 2167725 | 2022-01-31 | Jefferson | Alabama | 1073 | 175014 | 2080 |
2164470 | 2164470 | 2022-01-30 | Jefferson | Alabama | 1073 | 174260 | 2080 |
2161215 | 2161215 | 2022-01-29 | Jefferson | Alabama | 1073 | 173425 | 2080 |
2157959 | 2157959 | 2022-01-28 | Jefferson | Alabama | 1073 | 166471 | 2041 |
2154706 | 2154706 | 2022-01-27 | Jefferson | Alabama | 1073 | 166471 | 2041 |
2151453 | 2151453 | 2022-01-26 | Jefferson | Alabama | 1073 | 166471 | 2041 |
2148201 | 2148201 | 2022-01-25 | Jefferson | Alabama | 1073 | 166471 | 2041 |
2144949 | 2144949 | 2022-01-24 | Jefferson | Alabama | 1073 | 166471 | 2041 |
2141694 | 2141694 | 2022-01-23 | Jefferson | Alabama | 1073 | 165605 | 2041 |
2138438 | 2138438 | 2022-01-22 | Jefferson | Alabama | 1073 | 164161 | 2041 |
2135183 | 2135183 | 2022-01-21 | Jefferson | Alabama | 1073 | 162000 | 2041 |
2131931 | 2131931 | 2022-01-20 | Jefferson | Alabama | 1073 | 159848 | 2041 |
2128677 | 2128677 | 2022-01-19 | Jefferson | Alabama | 1073 | 157776 | 2037 |
2125424 | 2125424 | 2022-01-18 | Jefferson | Alabama | 1073 | 155617 | 2037 |
2122172 | 2122172 | 2022-01-17 | Jefferson | Alabama | 1073 | 154647 | 2037 |
2118920 | 2118920 | 2022-01-16 | Jefferson | Alabama | 1073 | 153340 | 2037 |
2115668 | 2115668 | 2022-01-15 | Jefferson | Alabama | 1073 | 145464 | 2034 |
2112416 | 2112416 | 2022-01-14 | Jefferson | Alabama | 1073 | 145464 | 2034 |
2109164 | 2109164 | 2022-01-13 | Jefferson | Alabama | 1073 | 145464 | 2034 |
2105913 | 2105913 | 2022-01-12 | Jefferson | Alabama | 1073 | 145464 | 2034 |
2102662 | 2102662 | 2022-01-11 | Jefferson | Alabama | 1073 | 143747 | 2034 |
2099411 | 2099411 | 2022-01-10 | Jefferson | Alabama | 1073 | 142396 | 2033 |
2096160 | 2096160 | 2022-01-09 | Jefferson | Alabama | 1073 | 141189 | 2033 |
2092908 | 2092908 | 2022-01-08 | Jefferson | Alabama | 1073 | 138918 | 2033 |
2089656 | 2089656 | 2022-01-07 | Jefferson | Alabama | 1073 | 137434 | 2030 |
2086405 | 2086405 | 2022-01-06 | Jefferson | Alabama | 1073 | 135392 | 2029 |
2083153 | 2083153 | 2022-01-05 | Jefferson | Alabama | 1073 | 133216 | 2029 |
2079901 | 2079901 | 2022-01-04 | Jefferson | Alabama | 1073 | 131549 | 2029 |
2076649 | 2076649 | 2022-01-03 | Jefferson | Alabama | 1073 | 130048 | 2024 |
2073398 | 2073398 | 2022-01-02 | Jefferson | Alabama | 1073 | 129265 | 2024 |
2070147 | 2070147 | 2022-01-01 | Jefferson | Alabama | 1073 | 126583 | 2024 |
2066896 | 2066896 | 2021-12-31 | Jefferson | Alabama | 1073 | 126583 | 2024 |
2063646 | 2063646 | 2021-12-30 | Jefferson | Alabama | 1073 | 124773 | 2024 |
2060396 | 2060396 | 2021-12-29 | Jefferson | Alabama | 1073 | 122863 | 2024 |
2057147 | 2057147 | 2021-12-28 | Jefferson | Alabama | 1073 | 121516 | 2024 |
2053898 | 2053898 | 2021-12-27 | Jefferson | Alabama | 1073 | 120618 | 2024 |
2050648 | 2050648 | 2021-12-26 | Jefferson | Alabama | 1073 | 120143 | 2024 |
2047398 | 2047398 | 2021-12-25 | Jefferson | Alabama | 1073 | 119973 | 2024 |
2044148 | 2044148 | 2021-12-24 | Jefferson | Alabama | 1073 | 119371 | 2024 |
2040899 | 2040899 | 2021-12-23 | Jefferson | Alabama | 1073 | 118779 | 2024 |
2037649 | 2037649 | 2021-12-22 | Jefferson | Alabama | 1073 | 118230 | 2021 |
2034399 | 2034399 | 2021-12-21 | Jefferson | Alabama | 1073 | 117886 | 2021 |
2031149 | 2031149 | 2021-12-20 | Jefferson | Alabama | 1073 | 117647 | 2021 |
2027898 | 2027898 | 2021-12-19 | Jefferson | Alabama | 1073 | 117532 | 2021 |
2024647 | 2024647 | 2021-12-18 | Jefferson | Alabama | 1073 | 117421 | 2021 |
2021396 | 2021396 | 2021-12-17 | Jefferson | Alabama | 1073 | 117304 | 2022 |
2018145 | 2018145 | 2021-12-16 | Jefferson | Alabama | 1073 | 117170 | 2012 |
2014895 | 2014895 | 2021-12-15 | Jefferson | Alabama | 1073 | 117065 | 2012 |
2011644 | 2011644 | 2021-12-14 | Jefferson | Alabama | 1073 | 116986 | 2009 |
2008393 | 2008393 | 2021-12-13 | Jefferson | Alabama | 1073 | 116718 | 2004 |
2005142 | 2005142 | 2021-12-12 | Jefferson | Alabama | 1073 | 116659 | 2004 |
2001891 | 2001891 | 2021-12-11 | Jefferson | Alabama | 1073 | 116616 | 2004 |
1998641 | 1998641 | 2021-12-10 | Jefferson | Alabama | 1073 | 116555 | 2004 |
1995390 | 1995390 | 2021-12-09 | Jefferson | Alabama | 1073 | 116530 | 2004 |
1992139 | 1992139 | 2021-12-08 | Jefferson | Alabama | 1073 | 116541 | 2005 |
1988888 | 1988888 | 2021-12-07 | Jefferson | Alabama | 1073 | 116504 | 2004 |
1985638 | 1985638 | 2021-12-06 | Jefferson | Alabama | 1073 | 116458 | 2005 |
1982388 | 1982388 | 2021-12-05 | Jefferson | Alabama | 1073 | 116429 | 2005 |
1979138 | 1979138 | 2021-12-04 | Jefferson | Alabama | 1073 | 116405 | 2005 |
1975888 | 1975888 | 2021-12-03 | Jefferson | Alabama | 1073 | 116375 | 2005 |
1972639 | 1972639 | 2021-12-02 | Jefferson | Alabama | 1073 | 116370 | 2006 |
1969389 | 1969389 | 2021-12-01 | Jefferson | Alabama | 1073 | 116268 | 2006 |
1966139 | 1966139 | 2021-11-30 | Jefferson | Alabama | 1073 | 116186 | 2004 |
1962887 | 1962887 | 2021-11-29 | Jefferson | Alabama | 1073 | 116155 | 2006 |
1959636 | 1959636 | 2021-11-28 | Jefferson | Alabama | 1073 | 116124 | 2006 |
1956385 | 1956385 | 2021-11-27 | Jefferson | Alabama | 1073 | 116100 | 2006 |
1953134 | 1953134 | 2021-11-26 | Jefferson | Alabama | 1073 | 116061 | 2006 |
1949883 | 1949883 | 2021-11-25 | Jefferson | Alabama | 1073 | 116061 | 2006 |
1946632 | 1946632 | 2021-11-24 | Jefferson | Alabama | 1073 | 116056 | 2005 |
1943381 | 1943381 | 2021-11-23 | Jefferson | Alabama | 1073 | 116087 | 2006 |
1940131 | 1940131 | 2021-11-22 | Jefferson | Alabama | 1073 | 116084 | 2002 |
1936881 | 1936881 | 2021-11-21 | Jefferson | Alabama | 1073 | 116056 | 2002 |
1933631 | 1933631 | 2021-11-20 | Jefferson | Alabama | 1073 | 116023 | 2002 |
1930379 | 1930379 | 2021-11-19 | Jefferson | Alabama | 1073 | 115983 | 2002 |
1927129 | 1927129 | 2021-11-18 | Jefferson | Alabama | 1073 | 116022 | 2000 |
1923879 | 1923879 | 2021-11-17 | Jefferson | Alabama | 1073 | 116001 | 1999 |
1920630 | 1920630 | 2021-11-16 | Jefferson | Alabama | 1073 | 116006 | 1999 |
1917380 | 1917380 | 2021-11-15 | Jefferson | Alabama | 1073 | 115970 | 1994 |
1914130 | 1914130 | 2021-11-14 | Jefferson | Alabama | 1073 | 115936 | 1994 |
1910880 | 1910880 | 2021-11-13 | Jefferson | Alabama | 1073 | 115899 | 1994 |
1907631 | 1907631 | 2021-11-12 | Jefferson | Alabama | 1073 | 115918 | 1993 |
1904382 | 1904382 | 2021-11-11 | Jefferson | Alabama | 1073 | 115849 | 1993 |
1901132 | 1901132 | 2021-11-10 | Jefferson | Alabama | 1073 | 115832 | 1989 |
1897882 | 1897882 | 2021-11-09 | Jefferson | Alabama | 1073 | 115843 | 1982 |
1894632 | 1894632 | 2021-11-08 | Jefferson | Alabama | 1073 | 115760 | 1978 |
1891382 | 1891382 | 2021-11-07 | Jefferson | Alabama | 1073 | 115726 | 1978 |
1888132 | 1888132 | 2021-11-06 | Jefferson | Alabama | 1073 | 115693 | 1978 |
1884882 | 1884882 | 2021-11-05 | Jefferson | Alabama | 1073 | 115649 | 1970 |
1881633 | 1881633 | 2021-11-04 | Jefferson | Alabama | 1073 | 115643 | 1973 |
1878384 | 1878384 | 2021-11-03 | Jefferson | Alabama | 1073 | 115645 | 1969 |
1875135 | 1875135 | 2021-11-02 | Jefferson | Alabama | 1073 | 115638 | 1966 |
1871886 | 1871886 | 2021-11-01 | Jefferson | Alabama | 1073 | 115628 | 1953 |
1868637 | 1868637 | 2021-10-31 | Jefferson | Alabama | 1073 | 115597 | 1953 |
1865388 | 1865388 | 2021-10-30 | Jefferson | Alabama | 1073 | 115560 | 1953 |
1862139 | 1862139 | 2021-10-29 | Jefferson | Alabama | 1073 | 115555 | 1953 |
1858890 | 1858890 | 2021-10-28 | Jefferson | Alabama | 1073 | 115591 | 1952 |
1855641 | 1855641 | 2021-10-27 | Jefferson | Alabama | 1073 | 115483 | 1937 |
1852392 | 1852392 | 2021-10-26 | Jefferson | Alabama | 1073 | 114905 | 1930 |
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);