ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Tallapoosa" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174255 | 2174255 | 2022-02-02 | Tallapoosa | Alabama | 1123 | 10934 | 213 |
2171003 | 2171003 | 2022-02-01 | Tallapoosa | Alabama | 1123 | 10890 | 212 |
2167750 | 2167750 | 2022-01-31 | Tallapoosa | Alabama | 1123 | 10835 | 212 |
2164495 | 2164495 | 2022-01-30 | Tallapoosa | Alabama | 1123 | 10792 | 212 |
2161240 | 2161240 | 2022-01-29 | Tallapoosa | Alabama | 1123 | 10753 | 212 |
2157984 | 2157984 | 2022-01-28 | Tallapoosa | Alabama | 1123 | 10289 | 209 |
2154731 | 2154731 | 2022-01-27 | Tallapoosa | Alabama | 1123 | 10289 | 209 |
2151478 | 2151478 | 2022-01-26 | Tallapoosa | Alabama | 1123 | 10289 | 209 |
2148226 | 2148226 | 2022-01-25 | Tallapoosa | Alabama | 1123 | 10289 | 209 |
2144974 | 2144974 | 2022-01-24 | Tallapoosa | Alabama | 1123 | 10289 | 209 |
2141719 | 2141719 | 2022-01-23 | Tallapoosa | Alabama | 1123 | 10262 | 209 |
2138463 | 2138463 | 2022-01-22 | Tallapoosa | Alabama | 1123 | 10207 | 209 |
2135208 | 2135208 | 2022-01-21 | Tallapoosa | Alabama | 1123 | 10048 | 209 |
2131956 | 2131956 | 2022-01-20 | Tallapoosa | Alabama | 1123 | 9820 | 209 |
2128702 | 2128702 | 2022-01-19 | Tallapoosa | Alabama | 1123 | 9688 | 208 |
2125449 | 2125449 | 2022-01-18 | Tallapoosa | Alabama | 1123 | 9484 | 208 |
2122197 | 2122197 | 2022-01-17 | Tallapoosa | Alabama | 1123 | 9347 | 208 |
2118945 | 2118945 | 2022-01-16 | Tallapoosa | Alabama | 1123 | 9267 | 208 |
2115693 | 2115693 | 2022-01-15 | Tallapoosa | Alabama | 1123 | 8858 | 207 |
2112441 | 2112441 | 2022-01-14 | Tallapoosa | Alabama | 1123 | 8858 | 207 |
2109189 | 2109189 | 2022-01-13 | Tallapoosa | Alabama | 1123 | 8858 | 207 |
2105938 | 2105938 | 2022-01-12 | Tallapoosa | Alabama | 1123 | 8858 | 207 |
2102687 | 2102687 | 2022-01-11 | Tallapoosa | Alabama | 1123 | 8717 | 207 |
2099436 | 2099436 | 2022-01-10 | Tallapoosa | Alabama | 1123 | 8669 | 207 |
2096185 | 2096185 | 2022-01-09 | Tallapoosa | Alabama | 1123 | 8626 | 207 |
2092933 | 2092933 | 2022-01-08 | Tallapoosa | Alabama | 1123 | 8530 | 207 |
2089681 | 2089681 | 2022-01-07 | Tallapoosa | Alabama | 1123 | 8435 | 206 |
2086430 | 2086430 | 2022-01-06 | Tallapoosa | Alabama | 1123 | 8329 | 206 |
2083178 | 2083178 | 2022-01-05 | Tallapoosa | Alabama | 1123 | 8158 | 205 |
2079926 | 2079926 | 2022-01-04 | Tallapoosa | Alabama | 1123 | 7997 | 205 |
2076674 | 2076674 | 2022-01-03 | Tallapoosa | Alabama | 1123 | 7934 | 204 |
2073423 | 2073423 | 2022-01-02 | Tallapoosa | Alabama | 1123 | 7828 | 204 |
2070172 | 2070172 | 2022-01-01 | Tallapoosa | Alabama | 1123 | 7750 | 204 |
2066921 | 2066921 | 2021-12-31 | Tallapoosa | Alabama | 1123 | 7750 | 204 |
2063671 | 2063671 | 2021-12-30 | Tallapoosa | Alabama | 1123 | 7679 | 204 |
2060421 | 2060421 | 2021-12-29 | Tallapoosa | Alabama | 1123 | 7623 | 204 |
2057172 | 2057172 | 2021-12-28 | Tallapoosa | Alabama | 1123 | 7549 | 204 |
2053923 | 2053923 | 2021-12-27 | Tallapoosa | Alabama | 1123 | 7502 | 204 |
2050673 | 2050673 | 2021-12-26 | Tallapoosa | Alabama | 1123 | 7487 | 204 |
2047423 | 2047423 | 2021-12-25 | Tallapoosa | Alabama | 1123 | 7485 | 204 |
2044173 | 2044173 | 2021-12-24 | Tallapoosa | Alabama | 1123 | 7475 | 204 |
2040924 | 2040924 | 2021-12-23 | Tallapoosa | Alabama | 1123 | 7468 | 204 |
2037674 | 2037674 | 2021-12-22 | Tallapoosa | Alabama | 1123 | 7452 | 204 |
2034424 | 2034424 | 2021-12-21 | Tallapoosa | Alabama | 1123 | 7449 | 204 |
2031174 | 2031174 | 2021-12-20 | Tallapoosa | Alabama | 1123 | 7431 | 204 |
2027923 | 2027923 | 2021-12-19 | Tallapoosa | Alabama | 1123 | 7424 | 204 |
2024672 | 2024672 | 2021-12-18 | Tallapoosa | Alabama | 1123 | 7419 | 204 |
2021421 | 2021421 | 2021-12-17 | Tallapoosa | Alabama | 1123 | 7402 | 204 |
2018170 | 2018170 | 2021-12-16 | Tallapoosa | Alabama | 1123 | 7383 | 203 |
2014920 | 2014920 | 2021-12-15 | Tallapoosa | Alabama | 1123 | 7372 | 203 |
2011669 | 2011669 | 2021-12-14 | Tallapoosa | Alabama | 1123 | 7355 | 203 |
2008418 | 2008418 | 2021-12-13 | Tallapoosa | Alabama | 1123 | 7327 | 203 |
2005167 | 2005167 | 2021-12-12 | Tallapoosa | Alabama | 1123 | 7325 | 203 |
2001916 | 2001916 | 2021-12-11 | Tallapoosa | Alabama | 1123 | 7321 | 203 |
1998666 | 1998666 | 2021-12-10 | Tallapoosa | Alabama | 1123 | 7310 | 202 |
1995415 | 1995415 | 2021-12-09 | Tallapoosa | Alabama | 1123 | 7302 | 202 |
1992164 | 1992164 | 2021-12-08 | Tallapoosa | Alabama | 1123 | 7295 | 202 |
1988913 | 1988913 | 2021-12-07 | Tallapoosa | Alabama | 1123 | 7291 | 202 |
1985663 | 1985663 | 2021-12-06 | Tallapoosa | Alabama | 1123 | 7287 | 202 |
1982413 | 1982413 | 2021-12-05 | Tallapoosa | Alabama | 1123 | 7286 | 202 |
1979163 | 1979163 | 2021-12-04 | Tallapoosa | Alabama | 1123 | 7285 | 202 |
1975913 | 1975913 | 2021-12-03 | Tallapoosa | Alabama | 1123 | 7283 | 202 |
1972664 | 1972664 | 2021-12-02 | Tallapoosa | Alabama | 1123 | 7283 | 202 |
1969414 | 1969414 | 2021-12-01 | Tallapoosa | Alabama | 1123 | 7278 | 201 |
1966164 | 1966164 | 2021-11-30 | Tallapoosa | Alabama | 1123 | 7273 | 201 |
1962912 | 1962912 | 2021-11-29 | Tallapoosa | Alabama | 1123 | 7256 | 201 |
1959661 | 1959661 | 2021-11-28 | Tallapoosa | Alabama | 1123 | 7255 | 201 |
1956410 | 1956410 | 2021-11-27 | Tallapoosa | Alabama | 1123 | 7254 | 201 |
1953159 | 1953159 | 2021-11-26 | Tallapoosa | Alabama | 1123 | 7248 | 201 |
1949908 | 1949908 | 2021-11-25 | Tallapoosa | Alabama | 1123 | 7248 | 201 |
1946657 | 1946657 | 2021-11-24 | Tallapoosa | Alabama | 1123 | 7235 | 201 |
1943406 | 1943406 | 2021-11-23 | Tallapoosa | Alabama | 1123 | 7227 | 201 |
1940156 | 1940156 | 2021-11-22 | Tallapoosa | Alabama | 1123 | 7202 | 201 |
1936906 | 1936906 | 2021-11-21 | Tallapoosa | Alabama | 1123 | 7201 | 201 |
1933656 | 1933656 | 2021-11-20 | Tallapoosa | Alabama | 1123 | 7196 | 201 |
1930404 | 1930404 | 2021-11-19 | Tallapoosa | Alabama | 1123 | 7186 | 202 |
1927154 | 1927154 | 2021-11-18 | Tallapoosa | Alabama | 1123 | 7195 | 202 |
1923904 | 1923904 | 2021-11-17 | Tallapoosa | Alabama | 1123 | 7212 | 201 |
1920655 | 1920655 | 2021-11-16 | Tallapoosa | Alabama | 1123 | 7219 | 202 |
1917405 | 1917405 | 2021-11-15 | Tallapoosa | Alabama | 1123 | 7215 | 202 |
1914155 | 1914155 | 2021-11-14 | Tallapoosa | Alabama | 1123 | 7211 | 202 |
1910905 | 1910905 | 2021-11-13 | Tallapoosa | Alabama | 1123 | 7210 | 202 |
1907656 | 1907656 | 2021-11-12 | Tallapoosa | Alabama | 1123 | 7202 | 202 |
1904407 | 1904407 | 2021-11-11 | Tallapoosa | Alabama | 1123 | 7195 | 202 |
1901157 | 1901157 | 2021-11-10 | Tallapoosa | Alabama | 1123 | 7186 | 202 |
1897907 | 1897907 | 2021-11-09 | Tallapoosa | Alabama | 1123 | 7185 | 202 |
1894657 | 1894657 | 2021-11-08 | Tallapoosa | Alabama | 1123 | 7165 | 202 |
1891407 | 1891407 | 2021-11-07 | Tallapoosa | Alabama | 1123 | 7163 | 202 |
1888157 | 1888157 | 2021-11-06 | Tallapoosa | Alabama | 1123 | 7159 | 202 |
1884907 | 1884907 | 2021-11-05 | Tallapoosa | Alabama | 1123 | 7148 | 202 |
1881658 | 1881658 | 2021-11-04 | Tallapoosa | Alabama | 1123 | 7148 | 202 |
1878409 | 1878409 | 2021-11-03 | Tallapoosa | Alabama | 1123 | 7153 | 200 |
1875160 | 1875160 | 2021-11-02 | Tallapoosa | Alabama | 1123 | 7159 | 200 |
1871911 | 1871911 | 2021-11-01 | Tallapoosa | Alabama | 1123 | 7162 | 199 |
1868662 | 1868662 | 2021-10-31 | Tallapoosa | Alabama | 1123 | 7158 | 199 |
1865413 | 1865413 | 2021-10-30 | Tallapoosa | Alabama | 1123 | 7151 | 199 |
1862164 | 1862164 | 2021-10-29 | Tallapoosa | Alabama | 1123 | 7145 | 198 |
1858915 | 1858915 | 2021-10-28 | Tallapoosa | Alabama | 1123 | 7146 | 198 |
1855666 | 1855666 | 2021-10-27 | Tallapoosa | Alabama | 1123 | 7142 | 198 |
1852417 | 1852417 | 2021-10-26 | Tallapoosa | Alabama | 1123 | 7103 | 198 |
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);