ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 1009 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174198 | 2174198 | 2022-02-02 | Blount | Alabama | 1009 | 14158 | 208 |
2170946 | 2170946 | 2022-02-01 | Blount | Alabama | 1009 | 14096 | 207 |
2167693 | 2167693 | 2022-01-31 | Blount | Alabama | 1009 | 14056 | 207 |
2164438 | 2164438 | 2022-01-30 | Blount | Alabama | 1009 | 13981 | 207 |
2161183 | 2161183 | 2022-01-29 | Blount | Alabama | 1009 | 13930 | 207 |
2157927 | 2157927 | 2022-01-28 | Blount | Alabama | 1009 | 13427 | 204 |
2154674 | 2154674 | 2022-01-27 | Blount | Alabama | 1009 | 13427 | 204 |
2151421 | 2151421 | 2022-01-26 | Blount | Alabama | 1009 | 13427 | 204 |
2148169 | 2148169 | 2022-01-25 | Blount | Alabama | 1009 | 13427 | 204 |
2144917 | 2144917 | 2022-01-24 | Blount | Alabama | 1009 | 13427 | 204 |
2141662 | 2141662 | 2022-01-23 | Blount | Alabama | 1009 | 13362 | 204 |
2138406 | 2138406 | 2022-01-22 | Blount | Alabama | 1009 | 13259 | 204 |
2135151 | 2135151 | 2022-01-21 | Blount | Alabama | 1009 | 13131 | 204 |
2131899 | 2131899 | 2022-01-20 | Blount | Alabama | 1009 | 13005 | 204 |
2128645 | 2128645 | 2022-01-19 | Blount | Alabama | 1009 | 12825 | 203 |
2125392 | 2125392 | 2022-01-18 | Blount | Alabama | 1009 | 12648 | 203 |
2122140 | 2122140 | 2022-01-17 | Blount | Alabama | 1009 | 12579 | 203 |
2118888 | 2118888 | 2022-01-16 | Blount | Alabama | 1009 | 12520 | 203 |
2115636 | 2115636 | 2022-01-15 | Blount | Alabama | 1009 | 12068 | 202 |
2112384 | 2112384 | 2022-01-14 | Blount | Alabama | 1009 | 12068 | 202 |
2109132 | 2109132 | 2022-01-13 | Blount | Alabama | 1009 | 12068 | 202 |
2105881 | 2105881 | 2022-01-12 | Blount | Alabama | 1009 | 12068 | 202 |
2102630 | 2102630 | 2022-01-11 | Blount | Alabama | 1009 | 11965 | 202 |
2099379 | 2099379 | 2022-01-10 | Blount | Alabama | 1009 | 11893 | 202 |
2096128 | 2096128 | 2022-01-09 | Blount | Alabama | 1009 | 11828 | 202 |
2092876 | 2092876 | 2022-01-08 | Blount | Alabama | 1009 | 11749 | 202 |
2089624 | 2089624 | 2022-01-07 | Blount | Alabama | 1009 | 11690 | 199 |
2086373 | 2086373 | 2022-01-06 | Blount | Alabama | 1009 | 11587 | 198 |
2083121 | 2083121 | 2022-01-05 | Blount | Alabama | 1009 | 11497 | 198 |
2079869 | 2079869 | 2022-01-04 | Blount | Alabama | 1009 | 11430 | 198 |
2076617 | 2076617 | 2022-01-03 | Blount | Alabama | 1009 | 11368 | 198 |
2073366 | 2073366 | 2022-01-02 | Blount | Alabama | 1009 | 11338 | 198 |
2070115 | 2070115 | 2022-01-01 | Blount | Alabama | 1009 | 11256 | 198 |
2066864 | 2066864 | 2021-12-31 | Blount | Alabama | 1009 | 11256 | 198 |
2063614 | 2063614 | 2021-12-30 | Blount | Alabama | 1009 | 11193 | 198 |
2060364 | 2060364 | 2021-12-29 | Blount | Alabama | 1009 | 11128 | 198 |
2057115 | 2057115 | 2021-12-28 | Blount | Alabama | 1009 | 11096 | 197 |
2053866 | 2053866 | 2021-12-27 | Blount | Alabama | 1009 | 11072 | 197 |
2050616 | 2050616 | 2021-12-26 | Blount | Alabama | 1009 | 11064 | 197 |
2047366 | 2047366 | 2021-12-25 | Blount | Alabama | 1009 | 11053 | 197 |
2044116 | 2044116 | 2021-12-24 | Blount | Alabama | 1009 | 11041 | 197 |
2040867 | 2040867 | 2021-12-23 | Blount | Alabama | 1009 | 11031 | 197 |
2037617 | 2037617 | 2021-12-22 | Blount | Alabama | 1009 | 11002 | 197 |
2034367 | 2034367 | 2021-12-21 | Blount | Alabama | 1009 | 10990 | 197 |
2031117 | 2031117 | 2021-12-20 | Blount | Alabama | 1009 | 10969 | 195 |
2027866 | 2027866 | 2021-12-19 | Blount | Alabama | 1009 | 10959 | 195 |
2024615 | 2024615 | 2021-12-18 | Blount | Alabama | 1009 | 10954 | 195 |
2021364 | 2021364 | 2021-12-17 | Blount | Alabama | 1009 | 10941 | 194 |
2018113 | 2018113 | 2021-12-16 | Blount | Alabama | 1009 | 10919 | 194 |
2014863 | 2014863 | 2021-12-15 | Blount | Alabama | 1009 | 10904 | 193 |
2011612 | 2011612 | 2021-12-14 | Blount | Alabama | 1009 | 10878 | 193 |
2008361 | 2008361 | 2021-12-13 | Blount | Alabama | 1009 | 10864 | 193 |
2005110 | 2005110 | 2021-12-12 | Blount | Alabama | 1009 | 10860 | 193 |
2001859 | 2001859 | 2021-12-11 | Blount | Alabama | 1009 | 10857 | 193 |
1998609 | 1998609 | 2021-12-10 | Blount | Alabama | 1009 | 10840 | 193 |
1995358 | 1995358 | 2021-12-09 | Blount | Alabama | 1009 | 10828 | 193 |
1992107 | 1992107 | 2021-12-08 | Blount | Alabama | 1009 | 10817 | 193 |
1988856 | 1988856 | 2021-12-07 | Blount | Alabama | 1009 | 10803 | 193 |
1985606 | 1985606 | 2021-12-06 | Blount | Alabama | 1009 | 10791 | 193 |
1982356 | 1982356 | 2021-12-05 | Blount | Alabama | 1009 | 10782 | 193 |
1979106 | 1979106 | 2021-12-04 | Blount | Alabama | 1009 | 10779 | 193 |
1975856 | 1975856 | 2021-12-03 | Blount | Alabama | 1009 | 10765 | 193 |
1972607 | 1972607 | 2021-12-02 | Blount | Alabama | 1009 | 10756 | 193 |
1969357 | 1969357 | 2021-12-01 | Blount | Alabama | 1009 | 10739 | 193 |
1966107 | 1966107 | 2021-11-30 | Blount | Alabama | 1009 | 10729 | 192 |
1962855 | 1962855 | 2021-11-29 | Blount | Alabama | 1009 | 10717 | 192 |
1959604 | 1959604 | 2021-11-28 | Blount | Alabama | 1009 | 10715 | 192 |
1956353 | 1956353 | 2021-11-27 | Blount | Alabama | 1009 | 10714 | 192 |
1953102 | 1953102 | 2021-11-26 | Blount | Alabama | 1009 | 10700 | 192 |
1949851 | 1949851 | 2021-11-25 | Blount | Alabama | 1009 | 10700 | 192 |
1946600 | 1946600 | 2021-11-24 | Blount | Alabama | 1009 | 10696 | 192 |
1943349 | 1943349 | 2021-11-23 | Blount | Alabama | 1009 | 10659 | 191 |
1940099 | 1940099 | 2021-11-22 | Blount | Alabama | 1009 | 10640 | 190 |
1936849 | 1936849 | 2021-11-21 | Blount | Alabama | 1009 | 10636 | 190 |
1933599 | 1933599 | 2021-11-20 | Blount | Alabama | 1009 | 10626 | 190 |
1930347 | 1930347 | 2021-11-19 | Blount | Alabama | 1009 | 10621 | 190 |
1927097 | 1927097 | 2021-11-18 | Blount | Alabama | 1009 | 10598 | 190 |
1923847 | 1923847 | 2021-11-17 | Blount | Alabama | 1009 | 10568 | 188 |
1920598 | 1920598 | 2021-11-16 | Blount | Alabama | 1009 | 10548 | 188 |
1917348 | 1917348 | 2021-11-15 | Blount | Alabama | 1009 | 10536 | 188 |
1914098 | 1914098 | 2021-11-14 | Blount | Alabama | 1009 | 10534 | 188 |
1910848 | 1910848 | 2021-11-13 | Blount | Alabama | 1009 | 10530 | 188 |
1907599 | 1907599 | 2021-11-12 | Blount | Alabama | 1009 | 10513 | 187 |
1904350 | 1904350 | 2021-11-11 | Blount | Alabama | 1009 | 10494 | 187 |
1901100 | 1901100 | 2021-11-10 | Blount | Alabama | 1009 | 10547 | 187 |
1897850 | 1897850 | 2021-11-09 | Blount | Alabama | 1009 | 10548 | 187 |
1894600 | 1894600 | 2021-11-08 | Blount | Alabama | 1009 | 10534 | 186 |
1891350 | 1891350 | 2021-11-07 | Blount | Alabama | 1009 | 10533 | 186 |
1888100 | 1888100 | 2021-11-06 | Blount | Alabama | 1009 | 10527 | 186 |
1884850 | 1884850 | 2021-11-05 | Blount | Alabama | 1009 | 10510 | 183 |
1881601 | 1881601 | 2021-11-04 | Blount | Alabama | 1009 | 10490 | 182 |
1878352 | 1878352 | 2021-11-03 | Blount | Alabama | 1009 | 10441 | 181 |
1875103 | 1875103 | 2021-11-02 | Blount | Alabama | 1009 | 10423 | 179 |
1871854 | 1871854 | 2021-11-01 | Blount | Alabama | 1009 | 10408 | 178 |
1868605 | 1868605 | 2021-10-31 | Blount | Alabama | 1009 | 10406 | 178 |
1865356 | 1865356 | 2021-10-30 | Blount | Alabama | 1009 | 10395 | 178 |
1862107 | 1862107 | 2021-10-29 | Blount | Alabama | 1009 | 10371 | 178 |
1858858 | 1858858 | 2021-10-28 | Blount | Alabama | 1009 | 10364 | 177 |
1855609 | 1855609 | 2021-10-27 | Blount | Alabama | 1009 | 10338 | 176 |
1852360 | 1852360 | 2021-10-26 | Blount | Alabama | 1009 | 10227 | 176 |
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);