ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Tuscaloosa" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174256 | 2174256 | 2022-02-02 | Tuscaloosa | Alabama | 1125 | 52074 | 691 |
2171004 | 2171004 | 2022-02-01 | Tuscaloosa | Alabama | 1125 | 51874 | 689 |
2167751 | 2167751 | 2022-01-31 | Tuscaloosa | Alabama | 1125 | 51690 | 687 |
2164496 | 2164496 | 2022-01-30 | Tuscaloosa | Alabama | 1125 | 51590 | 687 |
2161241 | 2161241 | 2022-01-29 | Tuscaloosa | Alabama | 1125 | 51382 | 687 |
2157985 | 2157985 | 2022-01-28 | Tuscaloosa | Alabama | 1125 | 49533 | 674 |
2154732 | 2154732 | 2022-01-27 | Tuscaloosa | Alabama | 1125 | 49533 | 674 |
2151479 | 2151479 | 2022-01-26 | Tuscaloosa | Alabama | 1125 | 49533 | 674 |
2148227 | 2148227 | 2022-01-25 | Tuscaloosa | Alabama | 1125 | 49533 | 674 |
2144975 | 2144975 | 2022-01-24 | Tuscaloosa | Alabama | 1125 | 49533 | 674 |
2141720 | 2141720 | 2022-01-23 | Tuscaloosa | Alabama | 1125 | 49312 | 674 |
2138464 | 2138464 | 2022-01-22 | Tuscaloosa | Alabama | 1125 | 48816 | 674 |
2135209 | 2135209 | 2022-01-21 | Tuscaloosa | Alabama | 1125 | 48029 | 674 |
2131957 | 2131957 | 2022-01-20 | Tuscaloosa | Alabama | 1125 | 47148 | 674 |
2128703 | 2128703 | 2022-01-19 | Tuscaloosa | Alabama | 1125 | 46371 | 672 |
2125450 | 2125450 | 2022-01-18 | Tuscaloosa | Alabama | 1125 | 45449 | 671 |
2122198 | 2122198 | 2022-01-17 | Tuscaloosa | Alabama | 1125 | 45186 | 671 |
2118946 | 2118946 | 2022-01-16 | Tuscaloosa | Alabama | 1125 | 44728 | 671 |
2115694 | 2115694 | 2022-01-15 | Tuscaloosa | Alabama | 1125 | 42127 | 667 |
2112442 | 2112442 | 2022-01-14 | Tuscaloosa | Alabama | 1125 | 42127 | 667 |
2109190 | 2109190 | 2022-01-13 | Tuscaloosa | Alabama | 1125 | 42127 | 667 |
2105939 | 2105939 | 2022-01-12 | Tuscaloosa | Alabama | 1125 | 42127 | 667 |
2102688 | 2102688 | 2022-01-11 | Tuscaloosa | Alabama | 1125 | 41502 | 666 |
2099437 | 2099437 | 2022-01-10 | Tuscaloosa | Alabama | 1125 | 41162 | 666 |
2096186 | 2096186 | 2022-01-09 | Tuscaloosa | Alabama | 1125 | 40948 | 666 |
2092934 | 2092934 | 2022-01-08 | Tuscaloosa | Alabama | 1125 | 40326 | 666 |
2089682 | 2089682 | 2022-01-07 | Tuscaloosa | Alabama | 1125 | 40060 | 665 |
2086431 | 2086431 | 2022-01-06 | Tuscaloosa | Alabama | 1125 | 39371 | 664 |
2083179 | 2083179 | 2022-01-05 | Tuscaloosa | Alabama | 1125 | 38986 | 656 |
2079927 | 2079927 | 2022-01-04 | Tuscaloosa | Alabama | 1125 | 38532 | 656 |
2076675 | 2076675 | 2022-01-03 | Tuscaloosa | Alabama | 1125 | 38349 | 655 |
2073424 | 2073424 | 2022-01-02 | Tuscaloosa | Alabama | 1125 | 38186 | 655 |
2070173 | 2070173 | 2022-01-01 | Tuscaloosa | Alabama | 1125 | 37677 | 655 |
2066922 | 2066922 | 2021-12-31 | Tuscaloosa | Alabama | 1125 | 37677 | 655 |
2063672 | 2063672 | 2021-12-30 | Tuscaloosa | Alabama | 1125 | 37476 | 655 |
2060422 | 2060422 | 2021-12-29 | Tuscaloosa | Alabama | 1125 | 37227 | 655 |
2057173 | 2057173 | 2021-12-28 | Tuscaloosa | Alabama | 1125 | 37043 | 653 |
2053924 | 2053924 | 2021-12-27 | Tuscaloosa | Alabama | 1125 | 36914 | 652 |
2050674 | 2050674 | 2021-12-26 | Tuscaloosa | Alabama | 1125 | 36869 | 652 |
2047424 | 2047424 | 2021-12-25 | Tuscaloosa | Alabama | 1125 | 36840 | 652 |
2044174 | 2044174 | 2021-12-24 | Tuscaloosa | Alabama | 1125 | 36776 | 652 |
2040925 | 2040925 | 2021-12-23 | Tuscaloosa | Alabama | 1125 | 36686 | 651 |
2037675 | 2037675 | 2021-12-22 | Tuscaloosa | Alabama | 1125 | 36637 | 649 |
2034425 | 2034425 | 2021-12-21 | Tuscaloosa | Alabama | 1125 | 36591 | 649 |
2031175 | 2031175 | 2021-12-20 | Tuscaloosa | Alabama | 1125 | 36553 | 649 |
2027924 | 2027924 | 2021-12-19 | Tuscaloosa | Alabama | 1125 | 36542 | 649 |
2024673 | 2024673 | 2021-12-18 | Tuscaloosa | Alabama | 1125 | 36535 | 649 |
2021422 | 2021422 | 2021-12-17 | Tuscaloosa | Alabama | 1125 | 36515 | 649 |
2018171 | 2018171 | 2021-12-16 | Tuscaloosa | Alabama | 1125 | 36492 | 649 |
2014921 | 2014921 | 2021-12-15 | Tuscaloosa | Alabama | 1125 | 36465 | 648 |
2011670 | 2011670 | 2021-12-14 | Tuscaloosa | Alabama | 1125 | 36442 | 648 |
2008419 | 2008419 | 2021-12-13 | Tuscaloosa | Alabama | 1125 | 36371 | 646 |
2005168 | 2005168 | 2021-12-12 | Tuscaloosa | Alabama | 1125 | 36368 | 646 |
2001917 | 2001917 | 2021-12-11 | Tuscaloosa | Alabama | 1125 | 36351 | 646 |
1998667 | 1998667 | 2021-12-10 | Tuscaloosa | Alabama | 1125 | 36310 | 645 |
1995416 | 1995416 | 2021-12-09 | Tuscaloosa | Alabama | 1125 | 36279 | 644 |
1992165 | 1992165 | 2021-12-08 | Tuscaloosa | Alabama | 1125 | 36254 | 644 |
1988914 | 1988914 | 2021-12-07 | Tuscaloosa | Alabama | 1125 | 36225 | 644 |
1985664 | 1985664 | 2021-12-06 | Tuscaloosa | Alabama | 1125 | 36172 | 644 |
1982414 | 1982414 | 2021-12-05 | Tuscaloosa | Alabama | 1125 | 36168 | 644 |
1979164 | 1979164 | 2021-12-04 | Tuscaloosa | Alabama | 1125 | 36152 | 644 |
1975914 | 1975914 | 2021-12-03 | Tuscaloosa | Alabama | 1125 | 36131 | 643 |
1972665 | 1972665 | 2021-12-02 | Tuscaloosa | Alabama | 1125 | 36096 | 642 |
1969415 | 1969415 | 2021-12-01 | Tuscaloosa | Alabama | 1125 | 36077 | 641 |
1966165 | 1966165 | 2021-11-30 | Tuscaloosa | Alabama | 1125 | 36052 | 641 |
1962913 | 1962913 | 2021-11-29 | Tuscaloosa | Alabama | 1125 | 36022 | 641 |
1959662 | 1959662 | 2021-11-28 | Tuscaloosa | Alabama | 1125 | 36017 | 641 |
1956411 | 1956411 | 2021-11-27 | Tuscaloosa | Alabama | 1125 | 36009 | 641 |
1953160 | 1953160 | 2021-11-26 | Tuscaloosa | Alabama | 1125 | 35996 | 641 |
1949909 | 1949909 | 2021-11-25 | Tuscaloosa | Alabama | 1125 | 35996 | 641 |
1946658 | 1946658 | 2021-11-24 | Tuscaloosa | Alabama | 1125 | 35953 | 639 |
1943407 | 1943407 | 2021-11-23 | Tuscaloosa | Alabama | 1125 | 35915 | 638 |
1940157 | 1940157 | 2021-11-22 | Tuscaloosa | Alabama | 1125 | 35889 | 638 |
1936907 | 1936907 | 2021-11-21 | Tuscaloosa | Alabama | 1125 | 35875 | 638 |
1933657 | 1933657 | 2021-11-20 | Tuscaloosa | Alabama | 1125 | 35870 | 638 |
1930405 | 1930405 | 2021-11-19 | Tuscaloosa | Alabama | 1125 | 35839 | 638 |
1927155 | 1927155 | 2021-11-18 | Tuscaloosa | Alabama | 1125 | 35798 | 638 |
1923905 | 1923905 | 2021-11-17 | Tuscaloosa | Alabama | 1125 | 35785 | 638 |
1920656 | 1920656 | 2021-11-16 | Tuscaloosa | Alabama | 1125 | 35768 | 636 |
1917406 | 1917406 | 2021-11-15 | Tuscaloosa | Alabama | 1125 | 35716 | 636 |
1914156 | 1914156 | 2021-11-14 | Tuscaloosa | Alabama | 1125 | 35714 | 636 |
1910906 | 1910906 | 2021-11-13 | Tuscaloosa | Alabama | 1125 | 35709 | 636 |
1907657 | 1907657 | 2021-11-12 | Tuscaloosa | Alabama | 1125 | 35641 | 633 |
1904408 | 1904408 | 2021-11-11 | Tuscaloosa | Alabama | 1125 | 35611 | 633 |
1901158 | 1901158 | 2021-11-10 | Tuscaloosa | Alabama | 1125 | 35585 | 632 |
1897908 | 1897908 | 2021-11-09 | Tuscaloosa | Alabama | 1125 | 35573 | 631 |
1894658 | 1894658 | 2021-11-08 | Tuscaloosa | Alabama | 1125 | 35554 | 627 |
1891408 | 1891408 | 2021-11-07 | Tuscaloosa | Alabama | 1125 | 35544 | 627 |
1888158 | 1888158 | 2021-11-06 | Tuscaloosa | Alabama | 1125 | 35535 | 627 |
1884908 | 1884908 | 2021-11-05 | Tuscaloosa | Alabama | 1125 | 35488 | 628 |
1881659 | 1881659 | 2021-11-04 | Tuscaloosa | Alabama | 1125 | 35452 | 624 |
1878410 | 1878410 | 2021-11-03 | Tuscaloosa | Alabama | 1125 | 35420 | 619 |
1875161 | 1875161 | 2021-11-02 | Tuscaloosa | Alabama | 1125 | 35362 | 617 |
1871912 | 1871912 | 2021-11-01 | Tuscaloosa | Alabama | 1125 | 35337 | 617 |
1868663 | 1868663 | 2021-10-31 | Tuscaloosa | Alabama | 1125 | 35327 | 617 |
1865414 | 1865414 | 2021-10-30 | Tuscaloosa | Alabama | 1125 | 35295 | 617 |
1862165 | 1862165 | 2021-10-29 | Tuscaloosa | Alabama | 1125 | 35264 | 617 |
1858916 | 1858916 | 2021-10-28 | Tuscaloosa | Alabama | 1125 | 35235 | 616 |
1855667 | 1855667 | 2021-10-27 | Tuscaloosa | Alabama | 1125 | 35191 | 613 |
1852418 | 1852418 | 2021-10-26 | Tuscaloosa | Alabama | 1125 | 35147 | 613 |
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);