ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 1121 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174254 | 2174254 | 2022-02-02 | Talladega | Alabama | 1121 | 21051 | 325 |
2171002 | 2171002 | 2022-02-01 | Talladega | Alabama | 1121 | 20949 | 322 |
2167749 | 2167749 | 2022-01-31 | Talladega | Alabama | 1121 | 20841 | 319 |
2164494 | 2164494 | 2022-01-30 | Talladega | Alabama | 1121 | 20696 | 319 |
2161239 | 2161239 | 2022-01-29 | Talladega | Alabama | 1121 | 20588 | 319 |
2157983 | 2157983 | 2022-01-28 | Talladega | Alabama | 1121 | 19534 | 316 |
2154730 | 2154730 | 2022-01-27 | Talladega | Alabama | 1121 | 19534 | 316 |
2151477 | 2151477 | 2022-01-26 | Talladega | Alabama | 1121 | 19534 | 316 |
2148225 | 2148225 | 2022-01-25 | Talladega | Alabama | 1121 | 19534 | 316 |
2144973 | 2144973 | 2022-01-24 | Talladega | Alabama | 1121 | 19534 | 316 |
2141718 | 2141718 | 2022-01-23 | Talladega | Alabama | 1121 | 19388 | 316 |
2138462 | 2138462 | 2022-01-22 | Talladega | Alabama | 1121 | 19256 | 316 |
2135207 | 2135207 | 2022-01-21 | Talladega | Alabama | 1121 | 18906 | 316 |
2131955 | 2131955 | 2022-01-20 | Talladega | Alabama | 1121 | 18629 | 314 |
2128701 | 2128701 | 2022-01-19 | Talladega | Alabama | 1121 | 18334 | 313 |
2125448 | 2125448 | 2022-01-18 | Talladega | Alabama | 1121 | 18054 | 313 |
2122196 | 2122196 | 2022-01-17 | Talladega | Alabama | 1121 | 17964 | 313 |
2118944 | 2118944 | 2022-01-16 | Talladega | Alabama | 1121 | 17810 | 313 |
2115692 | 2115692 | 2022-01-15 | Talladega | Alabama | 1121 | 16909 | 313 |
2112440 | 2112440 | 2022-01-14 | Talladega | Alabama | 1121 | 16909 | 313 |
2109188 | 2109188 | 2022-01-13 | Talladega | Alabama | 1121 | 16909 | 313 |
2105937 | 2105937 | 2022-01-12 | Talladega | Alabama | 1121 | 16909 | 313 |
2102686 | 2102686 | 2022-01-11 | Talladega | Alabama | 1121 | 16714 | 313 |
2099435 | 2099435 | 2022-01-10 | Talladega | Alabama | 1121 | 16560 | 313 |
2096184 | 2096184 | 2022-01-09 | Talladega | Alabama | 1121 | 16448 | 313 |
2092932 | 2092932 | 2022-01-08 | Talladega | Alabama | 1121 | 16175 | 313 |
2089680 | 2089680 | 2022-01-07 | Talladega | Alabama | 1121 | 16064 | 311 |
2086429 | 2086429 | 2022-01-06 | Talladega | Alabama | 1121 | 15846 | 311 |
2083177 | 2083177 | 2022-01-05 | Talladega | Alabama | 1121 | 15610 | 311 |
2079925 | 2079925 | 2022-01-04 | Talladega | Alabama | 1121 | 15407 | 311 |
2076673 | 2076673 | 2022-01-03 | Talladega | Alabama | 1121 | 15253 | 307 |
2073422 | 2073422 | 2022-01-02 | Talladega | Alabama | 1121 | 15182 | 307 |
2070171 | 2070171 | 2022-01-01 | Talladega | Alabama | 1121 | 15004 | 307 |
2066920 | 2066920 | 2021-12-31 | Talladega | Alabama | 1121 | 15004 | 307 |
2063670 | 2063670 | 2021-12-30 | Talladega | Alabama | 1121 | 14844 | 307 |
2060420 | 2060420 | 2021-12-29 | Talladega | Alabama | 1121 | 14716 | 307 |
2057171 | 2057171 | 2021-12-28 | Talladega | Alabama | 1121 | 14636 | 307 |
2053922 | 2053922 | 2021-12-27 | Talladega | Alabama | 1121 | 14589 | 307 |
2050672 | 2050672 | 2021-12-26 | Talladega | Alabama | 1121 | 14572 | 307 |
2047422 | 2047422 | 2021-12-25 | Talladega | Alabama | 1121 | 14565 | 307 |
2044172 | 2044172 | 2021-12-24 | Talladega | Alabama | 1121 | 14543 | 307 |
2040923 | 2040923 | 2021-12-23 | Talladega | Alabama | 1121 | 14504 | 306 |
2037673 | 2037673 | 2021-12-22 | Talladega | Alabama | 1121 | 14475 | 304 |
2034423 | 2034423 | 2021-12-21 | Talladega | Alabama | 1121 | 14455 | 304 |
2031173 | 2031173 | 2021-12-20 | Talladega | Alabama | 1121 | 14442 | 304 |
2027922 | 2027922 | 2021-12-19 | Talladega | Alabama | 1121 | 14435 | 304 |
2024671 | 2024671 | 2021-12-18 | Talladega | Alabama | 1121 | 14423 | 304 |
2021420 | 2021420 | 2021-12-17 | Talladega | Alabama | 1121 | 14403 | 304 |
2018169 | 2018169 | 2021-12-16 | Talladega | Alabama | 1121 | 14381 | 304 |
2014919 | 2014919 | 2021-12-15 | Talladega | Alabama | 1121 | 14368 | 304 |
2011668 | 2011668 | 2021-12-14 | Talladega | Alabama | 1121 | 14359 | 304 |
2008417 | 2008417 | 2021-12-13 | Talladega | Alabama | 1121 | 14326 | 304 |
2005166 | 2005166 | 2021-12-12 | Talladega | Alabama | 1121 | 14326 | 304 |
2001915 | 2001915 | 2021-12-11 | Talladega | Alabama | 1121 | 14319 | 304 |
1998665 | 1998665 | 2021-12-10 | Talladega | Alabama | 1121 | 14301 | 304 |
1995414 | 1995414 | 2021-12-09 | Talladega | Alabama | 1121 | 14299 | 302 |
1992163 | 1992163 | 2021-12-08 | Talladega | Alabama | 1121 | 14289 | 302 |
1988912 | 1988912 | 2021-12-07 | Talladega | Alabama | 1121 | 14275 | 302 |
1985662 | 1985662 | 2021-12-06 | Talladega | Alabama | 1121 | 14267 | 302 |
1982412 | 1982412 | 2021-12-05 | Talladega | Alabama | 1121 | 14265 | 302 |
1979162 | 1979162 | 2021-12-04 | Talladega | Alabama | 1121 | 14260 | 302 |
1975912 | 1975912 | 2021-12-03 | Talladega | Alabama | 1121 | 14244 | 302 |
1972663 | 1972663 | 2021-12-02 | Talladega | Alabama | 1121 | 14234 | 301 |
1969413 | 1969413 | 2021-12-01 | Talladega | Alabama | 1121 | 14221 | 301 |
1966163 | 1966163 | 2021-11-30 | Talladega | Alabama | 1121 | 14209 | 299 |
1962911 | 1962911 | 2021-11-29 | Talladega | Alabama | 1121 | 14196 | 299 |
1959660 | 1959660 | 2021-11-28 | Talladega | Alabama | 1121 | 14191 | 299 |
1956409 | 1956409 | 2021-11-27 | Talladega | Alabama | 1121 | 14189 | 299 |
1953158 | 1953158 | 2021-11-26 | Talladega | Alabama | 1121 | 14186 | 299 |
1949907 | 1949907 | 2021-11-25 | Talladega | Alabama | 1121 | 14186 | 299 |
1946656 | 1946656 | 2021-11-24 | Talladega | Alabama | 1121 | 14186 | 299 |
1943405 | 1943405 | 2021-11-23 | Talladega | Alabama | 1121 | 14186 | 297 |
1940155 | 1940155 | 2021-11-22 | Talladega | Alabama | 1121 | 14176 | 297 |
1936905 | 1936905 | 2021-11-21 | Talladega | Alabama | 1121 | 14168 | 297 |
1933655 | 1933655 | 2021-11-20 | Talladega | Alabama | 1121 | 14159 | 297 |
1930403 | 1930403 | 2021-11-19 | Talladega | Alabama | 1121 | 14137 | 298 |
1927153 | 1927153 | 2021-11-18 | Talladega | Alabama | 1121 | 14129 | 299 |
1923903 | 1923903 | 2021-11-17 | Talladega | Alabama | 1121 | 14118 | 299 |
1920654 | 1920654 | 2021-11-16 | Talladega | Alabama | 1121 | 14091 | 297 |
1917404 | 1917404 | 2021-11-15 | Talladega | Alabama | 1121 | 14086 | 296 |
1914154 | 1914154 | 2021-11-14 | Talladega | Alabama | 1121 | 14084 | 296 |
1910904 | 1910904 | 2021-11-13 | Talladega | Alabama | 1121 | 14082 | 296 |
1907655 | 1907655 | 2021-11-12 | Talladega | Alabama | 1121 | 14080 | 292 |
1904406 | 1904406 | 2021-11-11 | Talladega | Alabama | 1121 | 14071 | 292 |
1901156 | 1901156 | 2021-11-10 | Talladega | Alabama | 1121 | 14069 | 292 |
1897906 | 1897906 | 2021-11-09 | Talladega | Alabama | 1121 | 14064 | 292 |
1894656 | 1894656 | 2021-11-08 | Talladega | Alabama | 1121 | 14042 | 291 |
1891406 | 1891406 | 2021-11-07 | Talladega | Alabama | 1121 | 14042 | 291 |
1888156 | 1888156 | 2021-11-06 | Talladega | Alabama | 1121 | 14037 | 291 |
1884906 | 1884906 | 2021-11-05 | Talladega | Alabama | 1121 | 14032 | 291 |
1881657 | 1881657 | 2021-11-04 | Talladega | Alabama | 1121 | 14022 | 288 |
1878408 | 1878408 | 2021-11-03 | Talladega | Alabama | 1121 | 14005 | 287 |
1875159 | 1875159 | 2021-11-02 | Talladega | Alabama | 1121 | 14002 | 287 |
1871910 | 1871910 | 2021-11-01 | Talladega | Alabama | 1121 | 14000 | 286 |
1868661 | 1868661 | 2021-10-31 | Talladega | Alabama | 1121 | 13994 | 286 |
1865412 | 1865412 | 2021-10-30 | Talladega | Alabama | 1121 | 13988 | 286 |
1862163 | 1862163 | 2021-10-29 | Talladega | Alabama | 1121 | 13984 | 285 |
1858914 | 1858914 | 2021-10-28 | Talladega | Alabama | 1121 | 13982 | 283 |
1855665 | 1855665 | 2021-10-27 | Talladega | Alabama | 1121 | 13934 | 283 |
1852416 | 1852416 | 2021-10-26 | Talladega | Alabama | 1121 | 13870 | 283 |
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);