ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 1021 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174204 | 2174204 | 2022-02-02 | Chilton | Alabama | 1021 | 10040 | 183 |
2170952 | 2170952 | 2022-02-01 | Chilton | Alabama | 1021 | 10004 | 183 |
2167699 | 2167699 | 2022-01-31 | Chilton | Alabama | 1021 | 9977 | 183 |
2164444 | 2164444 | 2022-01-30 | Chilton | Alabama | 1021 | 9933 | 183 |
2161189 | 2161189 | 2022-01-29 | Chilton | Alabama | 1021 | 9857 | 183 |
2157933 | 2157933 | 2022-01-28 | Chilton | Alabama | 1021 | 9409 | 179 |
2154680 | 2154680 | 2022-01-27 | Chilton | Alabama | 1021 | 9409 | 179 |
2151427 | 2151427 | 2022-01-26 | Chilton | Alabama | 1021 | 9409 | 179 |
2148175 | 2148175 | 2022-01-25 | Chilton | Alabama | 1021 | 9409 | 179 |
2144923 | 2144923 | 2022-01-24 | Chilton | Alabama | 1021 | 9409 | 179 |
2141668 | 2141668 | 2022-01-23 | Chilton | Alabama | 1021 | 9347 | 179 |
2138412 | 2138412 | 2022-01-22 | Chilton | Alabama | 1021 | 9270 | 179 |
2135157 | 2135157 | 2022-01-21 | Chilton | Alabama | 1021 | 9146 | 179 |
2131905 | 2131905 | 2022-01-20 | Chilton | Alabama | 1021 | 8980 | 179 |
2128651 | 2128651 | 2022-01-19 | Chilton | Alabama | 1021 | 8874 | 178 |
2125398 | 2125398 | 2022-01-18 | Chilton | Alabama | 1021 | 8745 | 177 |
2122146 | 2122146 | 2022-01-17 | Chilton | Alabama | 1021 | 8695 | 177 |
2118894 | 2118894 | 2022-01-16 | Chilton | Alabama | 1021 | 8641 | 177 |
2115642 | 2115642 | 2022-01-15 | Chilton | Alabama | 1021 | 8177 | 175 |
2112390 | 2112390 | 2022-01-14 | Chilton | Alabama | 1021 | 8177 | 175 |
2109138 | 2109138 | 2022-01-13 | Chilton | Alabama | 1021 | 8177 | 175 |
2105887 | 2105887 | 2022-01-12 | Chilton | Alabama | 1021 | 8177 | 175 |
2102636 | 2102636 | 2022-01-11 | Chilton | Alabama | 1021 | 8080 | 175 |
2099385 | 2099385 | 2022-01-10 | Chilton | Alabama | 1021 | 8014 | 175 |
2096134 | 2096134 | 2022-01-09 | Chilton | Alabama | 1021 | 7964 | 175 |
2092882 | 2092882 | 2022-01-08 | Chilton | Alabama | 1021 | 7855 | 175 |
2089630 | 2089630 | 2022-01-07 | Chilton | Alabama | 1021 | 7778 | 175 |
2086379 | 2086379 | 2022-01-06 | Chilton | Alabama | 1021 | 7691 | 174 |
2083127 | 2083127 | 2022-01-05 | Chilton | Alabama | 1021 | 7626 | 173 |
2079875 | 2079875 | 2022-01-04 | Chilton | Alabama | 1021 | 7571 | 173 |
2076623 | 2076623 | 2022-01-03 | Chilton | Alabama | 1021 | 7523 | 173 |
2073372 | 2073372 | 2022-01-02 | Chilton | Alabama | 1021 | 7496 | 173 |
2070121 | 2070121 | 2022-01-01 | Chilton | Alabama | 1021 | 7424 | 173 |
2066870 | 2066870 | 2021-12-31 | Chilton | Alabama | 1021 | 7424 | 173 |
2063620 | 2063620 | 2021-12-30 | Chilton | Alabama | 1021 | 7370 | 173 |
2060370 | 2060370 | 2021-12-29 | Chilton | Alabama | 1021 | 7336 | 173 |
2057121 | 2057121 | 2021-12-28 | Chilton | Alabama | 1021 | 7299 | 173 |
2053872 | 2053872 | 2021-12-27 | Chilton | Alabama | 1021 | 7287 | 173 |
2050622 | 2050622 | 2021-12-26 | Chilton | Alabama | 1021 | 7278 | 173 |
2047372 | 2047372 | 2021-12-25 | Chilton | Alabama | 1021 | 7275 | 173 |
2044122 | 2044122 | 2021-12-24 | Chilton | Alabama | 1021 | 7265 | 173 |
2040873 | 2040873 | 2021-12-23 | Chilton | Alabama | 1021 | 7248 | 173 |
2037623 | 2037623 | 2021-12-22 | Chilton | Alabama | 1021 | 7239 | 173 |
2034373 | 2034373 | 2021-12-21 | Chilton | Alabama | 1021 | 7225 | 172 |
2031123 | 2031123 | 2021-12-20 | Chilton | Alabama | 1021 | 7219 | 172 |
2027872 | 2027872 | 2021-12-19 | Chilton | Alabama | 1021 | 7216 | 172 |
2024621 | 2024621 | 2021-12-18 | Chilton | Alabama | 1021 | 7211 | 172 |
2021370 | 2021370 | 2021-12-17 | Chilton | Alabama | 1021 | 7207 | 172 |
2018119 | 2018119 | 2021-12-16 | Chilton | Alabama | 1021 | 7195 | 172 |
2014869 | 2014869 | 2021-12-15 | Chilton | Alabama | 1021 | 7177 | 172 |
2011618 | 2011618 | 2021-12-14 | Chilton | Alabama | 1021 | 7174 | 172 |
2008367 | 2008367 | 2021-12-13 | Chilton | Alabama | 1021 | 7156 | 172 |
2005116 | 2005116 | 2021-12-12 | Chilton | Alabama | 1021 | 7152 | 172 |
2001865 | 2001865 | 2021-12-11 | Chilton | Alabama | 1021 | 7146 | 172 |
1998615 | 1998615 | 2021-12-10 | Chilton | Alabama | 1021 | 7139 | 171 |
1995364 | 1995364 | 2021-12-09 | Chilton | Alabama | 1021 | 7122 | 171 |
1992113 | 1992113 | 2021-12-08 | Chilton | Alabama | 1021 | 7112 | 171 |
1988862 | 1988862 | 2021-12-07 | Chilton | Alabama | 1021 | 7101 | 171 |
1985612 | 1985612 | 2021-12-06 | Chilton | Alabama | 1021 | 7098 | 170 |
1982362 | 1982362 | 2021-12-05 | Chilton | Alabama | 1021 | 7097 | 170 |
1979112 | 1979112 | 2021-12-04 | Chilton | Alabama | 1021 | 7090 | 170 |
1975862 | 1975862 | 2021-12-03 | Chilton | Alabama | 1021 | 7078 | 170 |
1972613 | 1972613 | 2021-12-02 | Chilton | Alabama | 1021 | 7077 | 170 |
1969363 | 1969363 | 2021-12-01 | Chilton | Alabama | 1021 | 7061 | 170 |
1966113 | 1966113 | 2021-11-30 | Chilton | Alabama | 1021 | 7042 | 170 |
1962861 | 1962861 | 2021-11-29 | Chilton | Alabama | 1021 | 7018 | 170 |
1959610 | 1959610 | 2021-11-28 | Chilton | Alabama | 1021 | 7018 | 170 |
1956359 | 1956359 | 2021-11-27 | Chilton | Alabama | 1021 | 7018 | 170 |
1953108 | 1953108 | 2021-11-26 | Chilton | Alabama | 1021 | 7015 | 170 |
1949857 | 1949857 | 2021-11-25 | Chilton | Alabama | 1021 | 7015 | 170 |
1946606 | 1946606 | 2021-11-24 | Chilton | Alabama | 1021 | 7000 | 170 |
1943355 | 1943355 | 2021-11-23 | Chilton | Alabama | 1021 | 6991 | 170 |
1940105 | 1940105 | 2021-11-22 | Chilton | Alabama | 1021 | 6979 | 170 |
1936855 | 1936855 | 2021-11-21 | Chilton | Alabama | 1021 | 6976 | 170 |
1933605 | 1933605 | 2021-11-20 | Chilton | Alabama | 1021 | 6970 | 170 |
1930353 | 1930353 | 2021-11-19 | Chilton | Alabama | 1021 | 6955 | 170 |
1927103 | 1927103 | 2021-11-18 | Chilton | Alabama | 1021 | 6944 | 169 |
1923853 | 1923853 | 2021-11-17 | Chilton | Alabama | 1021 | 6933 | 169 |
1920604 | 1920604 | 2021-11-16 | Chilton | Alabama | 1021 | 6923 | 169 |
1917354 | 1917354 | 2021-11-15 | Chilton | Alabama | 1021 | 6920 | 169 |
1914104 | 1914104 | 2021-11-14 | Chilton | Alabama | 1021 | 6919 | 169 |
1910854 | 1910854 | 2021-11-13 | Chilton | Alabama | 1021 | 6919 | 169 |
1907605 | 1907605 | 2021-11-12 | Chilton | Alabama | 1021 | 6911 | 168 |
1904356 | 1904356 | 2021-11-11 | Chilton | Alabama | 1021 | 6895 | 168 |
1901106 | 1901106 | 2021-11-10 | Chilton | Alabama | 1021 | 6879 | 168 |
1897856 | 1897856 | 2021-11-09 | Chilton | Alabama | 1021 | 6862 | 167 |
1894606 | 1894606 | 2021-11-08 | Chilton | Alabama | 1021 | 6848 | 166 |
1891356 | 1891356 | 2021-11-07 | Chilton | Alabama | 1021 | 6846 | 166 |
1888106 | 1888106 | 2021-11-06 | Chilton | Alabama | 1021 | 6841 | 166 |
1884856 | 1884856 | 2021-11-05 | Chilton | Alabama | 1021 | 6824 | 165 |
1881607 | 1881607 | 2021-11-04 | Chilton | Alabama | 1021 | 6819 | 165 |
1878358 | 1878358 | 2021-11-03 | Chilton | Alabama | 1021 | 6814 | 164 |
1875109 | 1875109 | 2021-11-02 | Chilton | Alabama | 1021 | 6811 | 164 |
1871860 | 1871860 | 2021-11-01 | Chilton | Alabama | 1021 | 6796 | 164 |
1868611 | 1868611 | 2021-10-31 | Chilton | Alabama | 1021 | 6794 | 164 |
1865362 | 1865362 | 2021-10-30 | Chilton | Alabama | 1021 | 6764 | 164 |
1862113 | 1862113 | 2021-10-29 | Chilton | Alabama | 1021 | 6753 | 163 |
1858864 | 1858864 | 2021-10-28 | Chilton | Alabama | 1021 | 6747 | 162 |
1855615 | 1855615 | 2021-10-27 | Chilton | Alabama | 1021 | 6665 | 162 |
1852366 | 1852366 | 2021-10-26 | Chilton | Alabama | 1021 | 6658 | 162 |
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);