ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Autauga" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174194 | 2174194 | 2022-02-02 | Autauga | Alabama | 1001 | 14826 | 168 |
2170942 | 2170942 | 2022-02-01 | Autauga | Alabama | 1001 | 14782 | 167 |
2167689 | 2167689 | 2022-01-31 | Autauga | Alabama | 1001 | 14742 | 166 |
2164434 | 2164434 | 2022-01-30 | Autauga | Alabama | 1001 | 14498 | 166 |
2161179 | 2161179 | 2022-01-29 | Autauga | Alabama | 1001 | 14291 | 166 |
2157923 | 2157923 | 2022-01-28 | Autauga | Alabama | 1001 | 13251 | 163 |
2154670 | 2154670 | 2022-01-27 | Autauga | Alabama | 1001 | 13251 | 163 |
2151417 | 2151417 | 2022-01-26 | Autauga | Alabama | 1001 | 13251 | 163 |
2148165 | 2148165 | 2022-01-25 | Autauga | Alabama | 1001 | 13251 | 163 |
2144913 | 2144913 | 2022-01-24 | Autauga | Alabama | 1001 | 13251 | 163 |
2141658 | 2141658 | 2022-01-23 | Autauga | Alabama | 1001 | 13191 | 163 |
2138402 | 2138402 | 2022-01-22 | Autauga | Alabama | 1001 | 13133 | 163 |
2135147 | 2135147 | 2022-01-21 | Autauga | Alabama | 1001 | 13019 | 163 |
2131895 | 2131895 | 2022-01-20 | Autauga | Alabama | 1001 | 12928 | 163 |
2128641 | 2128641 | 2022-01-19 | Autauga | Alabama | 1001 | 12833 | 163 |
2125388 | 2125388 | 2022-01-18 | Autauga | Alabama | 1001 | 12738 | 163 |
2122136 | 2122136 | 2022-01-17 | Autauga | Alabama | 1001 | 12682 | 163 |
2118884 | 2118884 | 2022-01-16 | Autauga | Alabama | 1001 | 12624 | 163 |
2115632 | 2115632 | 2022-01-15 | Autauga | Alabama | 1001 | 12180 | 162 |
2112380 | 2112380 | 2022-01-14 | Autauga | Alabama | 1001 | 12180 | 162 |
2109128 | 2109128 | 2022-01-13 | Autauga | Alabama | 1001 | 12180 | 162 |
2105877 | 2105877 | 2022-01-12 | Autauga | Alabama | 1001 | 12180 | 162 |
2102626 | 2102626 | 2022-01-11 | Autauga | Alabama | 1001 | 12102 | 162 |
2099375 | 2099375 | 2022-01-10 | Autauga | Alabama | 1001 | 12029 | 162 |
2096124 | 2096124 | 2022-01-09 | Autauga | Alabama | 1001 | 11975 | 162 |
2092872 | 2092872 | 2022-01-08 | Autauga | Alabama | 1001 | 11856 | 162 |
2089620 | 2089620 | 2022-01-07 | Autauga | Alabama | 1001 | 11789 | 162 |
2086369 | 2086369 | 2022-01-06 | Autauga | Alabama | 1001 | 11638 | 161 |
2083117 | 2083117 | 2022-01-05 | Autauga | Alabama | 1001 | 11478 | 161 |
2079865 | 2079865 | 2022-01-04 | Autauga | Alabama | 1001 | 11347 | 161 |
2076613 | 2076613 | 2022-01-03 | Autauga | Alabama | 1001 | 11256 | 160 |
2073362 | 2073362 | 2022-01-02 | Autauga | Alabama | 1001 | 11184 | 160 |
2070111 | 2070111 | 2022-01-01 | Autauga | Alabama | 1001 | 11018 | 160 |
2066860 | 2066860 | 2021-12-31 | Autauga | Alabama | 1001 | 11018 | 160 |
2063610 | 2063610 | 2021-12-30 | Autauga | Alabama | 1001 | 10953 | 160 |
2060360 | 2060360 | 2021-12-29 | Autauga | Alabama | 1001 | 10886 | 160 |
2057111 | 2057111 | 2021-12-28 | Autauga | Alabama | 1001 | 10828 | 160 |
2053862 | 2053862 | 2021-12-27 | Autauga | Alabama | 1001 | 10800 | 160 |
2050612 | 2050612 | 2021-12-26 | Autauga | Alabama | 1001 | 10789 | 160 |
2047362 | 2047362 | 2021-12-25 | Autauga | Alabama | 1001 | 10785 | 160 |
2044112 | 2044112 | 2021-12-24 | Autauga | Alabama | 1001 | 10758 | 160 |
2040863 | 2040863 | 2021-12-23 | Autauga | Alabama | 1001 | 10746 | 160 |
2037613 | 2037613 | 2021-12-22 | Autauga | Alabama | 1001 | 10711 | 160 |
2034363 | 2034363 | 2021-12-21 | Autauga | Alabama | 1001 | 10692 | 160 |
2031113 | 2031113 | 2021-12-20 | Autauga | Alabama | 1001 | 10679 | 159 |
2027862 | 2027862 | 2021-12-19 | Autauga | Alabama | 1001 | 10669 | 159 |
2024611 | 2024611 | 2021-12-18 | Autauga | Alabama | 1001 | 10663 | 159 |
2021360 | 2021360 | 2021-12-17 | Autauga | Alabama | 1001 | 10661 | 159 |
2018109 | 2018109 | 2021-12-16 | Autauga | Alabama | 1001 | 10646 | 158 |
2014859 | 2014859 | 2021-12-15 | Autauga | Alabama | 1001 | 10641 | 158 |
2011608 | 2011608 | 2021-12-14 | Autauga | Alabama | 1001 | 10637 | 158 |
2008357 | 2008357 | 2021-12-13 | Autauga | Alabama | 1001 | 10605 | 158 |
2005106 | 2005106 | 2021-12-12 | Autauga | Alabama | 1001 | 10599 | 158 |
2001855 | 2001855 | 2021-12-11 | Autauga | Alabama | 1001 | 10596 | 158 |
1998605 | 1998605 | 2021-12-10 | Autauga | Alabama | 1001 | 10589 | 158 |
1995354 | 1995354 | 2021-12-09 | Autauga | Alabama | 1001 | 10584 | 157 |
1992103 | 1992103 | 2021-12-08 | Autauga | Alabama | 1001 | 10575 | 157 |
1988852 | 1988852 | 2021-12-07 | Autauga | Alabama | 1001 | 10566 | 157 |
1985602 | 1985602 | 2021-12-06 | Autauga | Alabama | 1001 | 10562 | 157 |
1982352 | 1982352 | 2021-12-05 | Autauga | Alabama | 1001 | 10561 | 157 |
1979102 | 1979102 | 2021-12-04 | Autauga | Alabama | 1001 | 10560 | 157 |
1975852 | 1975852 | 2021-12-03 | Autauga | Alabama | 1001 | 10545 | 157 |
1972603 | 1972603 | 2021-12-02 | Autauga | Alabama | 1001 | 10531 | 157 |
1969353 | 1969353 | 2021-12-01 | Autauga | Alabama | 1001 | 10527 | 157 |
1966103 | 1966103 | 2021-11-30 | Autauga | Alabama | 1001 | 10526 | 157 |
1962851 | 1962851 | 2021-11-29 | Autauga | Alabama | 1001 | 10517 | 157 |
1959600 | 1959600 | 2021-11-28 | Autauga | Alabama | 1001 | 10517 | 157 |
1956349 | 1956349 | 2021-11-27 | Autauga | Alabama | 1001 | 10517 | 157 |
1953098 | 1953098 | 2021-11-26 | Autauga | Alabama | 1001 | 10512 | 157 |
1949847 | 1949847 | 2021-11-25 | Autauga | Alabama | 1001 | 10512 | 157 |
1946596 | 1946596 | 2021-11-24 | Autauga | Alabama | 1001 | 10508 | 156 |
1943345 | 1943345 | 2021-11-23 | Autauga | Alabama | 1001 | 10495 | 156 |
1940095 | 1940095 | 2021-11-22 | Autauga | Alabama | 1001 | 10477 | 156 |
1936845 | 1936845 | 2021-11-21 | Autauga | Alabama | 1001 | 10471 | 156 |
1933595 | 1933595 | 2021-11-20 | Autauga | Alabama | 1001 | 10468 | 156 |
1930343 | 1930343 | 2021-11-19 | Autauga | Alabama | 1001 | 10457 | 156 |
1927093 | 1927093 | 2021-11-18 | Autauga | Alabama | 1001 | 10439 | 156 |
1923843 | 1923843 | 2021-11-17 | Autauga | Alabama | 1001 | 10423 | 155 |
1920594 | 1920594 | 2021-11-16 | Autauga | Alabama | 1001 | 10419 | 154 |
1917344 | 1917344 | 2021-11-15 | Autauga | Alabama | 1001 | 10407 | 154 |
1914094 | 1914094 | 2021-11-14 | Autauga | Alabama | 1001 | 10403 | 154 |
1910844 | 1910844 | 2021-11-13 | Autauga | Alabama | 1001 | 10401 | 154 |
1907595 | 1907595 | 2021-11-12 | Autauga | Alabama | 1001 | 10383 | 152 |
1904346 | 1904346 | 2021-11-11 | Autauga | Alabama | 1001 | 10373 | 152 |
1901096 | 1901096 | 2021-11-10 | Autauga | Alabama | 1001 | 10355 | 152 |
1897846 | 1897846 | 2021-11-09 | Autauga | Alabama | 1001 | 10350 | 152 |
1894596 | 1894596 | 2021-11-08 | Autauga | Alabama | 1001 | 10335 | 151 |
1891346 | 1891346 | 2021-11-07 | Autauga | Alabama | 1001 | 10331 | 151 |
1888096 | 1888096 | 2021-11-06 | Autauga | Alabama | 1001 | 10327 | 151 |
1884846 | 1884846 | 2021-11-05 | Autauga | Alabama | 1001 | 10314 | 151 |
1881597 | 1881597 | 2021-11-04 | Autauga | Alabama | 1001 | 10304 | 151 |
1878348 | 1878348 | 2021-11-03 | Autauga | Alabama | 1001 | 10284 | 150 |
1875099 | 1875099 | 2021-11-02 | Autauga | Alabama | 1001 | 10271 | 148 |
1871850 | 1871850 | 2021-11-01 | Autauga | Alabama | 1001 | 10258 | 148 |
1868601 | 1868601 | 2021-10-31 | Autauga | Alabama | 1001 | 10252 | 148 |
1865352 | 1865352 | 2021-10-30 | Autauga | Alabama | 1001 | 10239 | 148 |
1862103 | 1862103 | 2021-10-29 | Autauga | Alabama | 1001 | 10228 | 148 |
1858854 | 1858854 | 2021-10-28 | Autauga | Alabama | 1001 | 10219 | 148 |
1855605 | 1855605 | 2021-10-27 | Autauga | Alabama | 1001 | 10083 | 148 |
1852356 | 1852356 | 2021-10-26 | Autauga | Alabama | 1001 | 10061 | 148 |
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);