ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 1013 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174200 | 2174200 | 2022-02-02 | Butler | Alabama | 1013 | 4830 | 109 |
2170948 | 2170948 | 2022-02-01 | Butler | Alabama | 1013 | 4806 | 108 |
2167695 | 2167695 | 2022-01-31 | Butler | Alabama | 1013 | 4784 | 108 |
2164440 | 2164440 | 2022-01-30 | Butler | Alabama | 1013 | 4759 | 108 |
2161185 | 2161185 | 2022-01-29 | Butler | Alabama | 1013 | 4740 | 108 |
2157929 | 2157929 | 2022-01-28 | Butler | Alabama | 1013 | 4519 | 106 |
2154676 | 2154676 | 2022-01-27 | Butler | Alabama | 1013 | 4519 | 106 |
2151423 | 2151423 | 2022-01-26 | Butler | Alabama | 1013 | 4519 | 106 |
2148171 | 2148171 | 2022-01-25 | Butler | Alabama | 1013 | 4519 | 106 |
2144919 | 2144919 | 2022-01-24 | Butler | Alabama | 1013 | 4519 | 106 |
2141664 | 2141664 | 2022-01-23 | Butler | Alabama | 1013 | 4481 | 106 |
2138408 | 2138408 | 2022-01-22 | Butler | Alabama | 1013 | 4450 | 106 |
2135153 | 2135153 | 2022-01-21 | Butler | Alabama | 1013 | 4407 | 106 |
2131901 | 2131901 | 2022-01-20 | Butler | Alabama | 1013 | 4352 | 104 |
2128647 | 2128647 | 2022-01-19 | Butler | Alabama | 1013 | 4319 | 103 |
2125394 | 2125394 | 2022-01-18 | Butler | Alabama | 1013 | 4281 | 102 |
2122142 | 2122142 | 2022-01-17 | Butler | Alabama | 1013 | 4262 | 102 |
2118890 | 2118890 | 2022-01-16 | Butler | Alabama | 1013 | 4232 | 102 |
2115638 | 2115638 | 2022-01-15 | Butler | Alabama | 1013 | 4073 | 102 |
2112386 | 2112386 | 2022-01-14 | Butler | Alabama | 1013 | 4073 | 102 |
2109134 | 2109134 | 2022-01-13 | Butler | Alabama | 1013 | 4073 | 102 |
2105883 | 2105883 | 2022-01-12 | Butler | Alabama | 1013 | 4073 | 102 |
2102632 | 2102632 | 2022-01-11 | Butler | Alabama | 1013 | 4037 | 102 |
2099381 | 2099381 | 2022-01-10 | Butler | Alabama | 1013 | 4021 | 102 |
2096130 | 2096130 | 2022-01-09 | Butler | Alabama | 1013 | 3985 | 102 |
2092878 | 2092878 | 2022-01-08 | Butler | Alabama | 1013 | 3919 | 102 |
2089626 | 2089626 | 2022-01-07 | Butler | Alabama | 1013 | 3896 | 102 |
2086375 | 2086375 | 2022-01-06 | Butler | Alabama | 1013 | 3838 | 102 |
2083123 | 2083123 | 2022-01-05 | Butler | Alabama | 1013 | 3773 | 102 |
2079871 | 2079871 | 2022-01-04 | Butler | Alabama | 1013 | 3695 | 102 |
2076619 | 2076619 | 2022-01-03 | Butler | Alabama | 1013 | 3672 | 102 |
2073368 | 2073368 | 2022-01-02 | Butler | Alabama | 1013 | 3654 | 102 |
2070117 | 2070117 | 2022-01-01 | Butler | Alabama | 1013 | 3613 | 102 |
2066866 | 2066866 | 2021-12-31 | Butler | Alabama | 1013 | 3613 | 102 |
2063616 | 2063616 | 2021-12-30 | Butler | Alabama | 1013 | 3591 | 102 |
2060366 | 2060366 | 2021-12-29 | Butler | Alabama | 1013 | 3558 | 102 |
2057117 | 2057117 | 2021-12-28 | Butler | Alabama | 1013 | 3535 | 102 |
2053868 | 2053868 | 2021-12-27 | Butler | Alabama | 1013 | 3520 | 102 |
2050618 | 2050618 | 2021-12-26 | Butler | Alabama | 1013 | 3514 | 102 |
2047368 | 2047368 | 2021-12-25 | Butler | Alabama | 1013 | 3510 | 102 |
2044118 | 2044118 | 2021-12-24 | Butler | Alabama | 1013 | 3507 | 102 |
2040869 | 2040869 | 2021-12-23 | Butler | Alabama | 1013 | 3498 | 102 |
2037619 | 2037619 | 2021-12-22 | Butler | Alabama | 1013 | 3494 | 102 |
2034369 | 2034369 | 2021-12-21 | Butler | Alabama | 1013 | 3494 | 102 |
2031119 | 2031119 | 2021-12-20 | Butler | Alabama | 1013 | 3493 | 102 |
2027868 | 2027868 | 2021-12-19 | Butler | Alabama | 1013 | 3491 | 102 |
2024617 | 2024617 | 2021-12-18 | Butler | Alabama | 1013 | 3490 | 102 |
2021366 | 2021366 | 2021-12-17 | Butler | Alabama | 1013 | 3487 | 102 |
2018115 | 2018115 | 2021-12-16 | Butler | Alabama | 1013 | 3481 | 102 |
2014865 | 2014865 | 2021-12-15 | Butler | Alabama | 1013 | 3480 | 102 |
2011614 | 2011614 | 2021-12-14 | Butler | Alabama | 1013 | 3479 | 102 |
2008363 | 2008363 | 2021-12-13 | Butler | Alabama | 1013 | 3467 | 102 |
2005112 | 2005112 | 2021-12-12 | Butler | Alabama | 1013 | 3467 | 102 |
2001861 | 2001861 | 2021-12-11 | Butler | Alabama | 1013 | 3466 | 102 |
1998611 | 1998611 | 2021-12-10 | Butler | Alabama | 1013 | 3467 | 101 |
1995360 | 1995360 | 2021-12-09 | Butler | Alabama | 1013 | 3459 | 101 |
1992109 | 1992109 | 2021-12-08 | Butler | Alabama | 1013 | 3448 | 101 |
1988858 | 1988858 | 2021-12-07 | Butler | Alabama | 1013 | 3446 | 101 |
1985608 | 1985608 | 2021-12-06 | Butler | Alabama | 1013 | 3445 | 101 |
1982358 | 1982358 | 2021-12-05 | Butler | Alabama | 1013 | 3445 | 101 |
1979108 | 1979108 | 2021-12-04 | Butler | Alabama | 1013 | 3444 | 101 |
1975858 | 1975858 | 2021-12-03 | Butler | Alabama | 1013 | 3444 | 101 |
1972609 | 1972609 | 2021-12-02 | Butler | Alabama | 1013 | 3445 | 101 |
1969359 | 1969359 | 2021-12-01 | Butler | Alabama | 1013 | 3442 | 101 |
1966109 | 1966109 | 2021-11-30 | Butler | Alabama | 1013 | 3439 | 100 |
1962857 | 1962857 | 2021-11-29 | Butler | Alabama | 1013 | 3435 | 100 |
1959606 | 1959606 | 2021-11-28 | Butler | Alabama | 1013 | 3434 | 100 |
1956355 | 1956355 | 2021-11-27 | Butler | Alabama | 1013 | 3434 | 100 |
1953104 | 1953104 | 2021-11-26 | Butler | Alabama | 1013 | 3433 | 100 |
1949853 | 1949853 | 2021-11-25 | Butler | Alabama | 1013 | 3433 | 100 |
1946602 | 1946602 | 2021-11-24 | Butler | Alabama | 1013 | 3430 | 100 |
1943351 | 1943351 | 2021-11-23 | Butler | Alabama | 1013 | 3430 | 100 |
1940101 | 1940101 | 2021-11-22 | Butler | Alabama | 1013 | 3426 | 100 |
1936851 | 1936851 | 2021-11-21 | Butler | Alabama | 1013 | 3422 | 100 |
1933601 | 1933601 | 2021-11-20 | Butler | Alabama | 1013 | 3419 | 100 |
1930349 | 1930349 | 2021-11-19 | Butler | Alabama | 1013 | 3409 | 100 |
1927099 | 1927099 | 2021-11-18 | Butler | Alabama | 1013 | 3404 | 100 |
1923849 | 1923849 | 2021-11-17 | Butler | Alabama | 1013 | 3398 | 100 |
1920600 | 1920600 | 2021-11-16 | Butler | Alabama | 1013 | 3393 | 100 |
1917350 | 1917350 | 2021-11-15 | Butler | Alabama | 1013 | 3391 | 99 |
1914100 | 1914100 | 2021-11-14 | Butler | Alabama | 1013 | 3390 | 99 |
1910850 | 1910850 | 2021-11-13 | Butler | Alabama | 1013 | 3387 | 99 |
1907601 | 1907601 | 2021-11-12 | Butler | Alabama | 1013 | 3387 | 99 |
1904352 | 1904352 | 2021-11-11 | Butler | Alabama | 1013 | 3387 | 99 |
1901102 | 1901102 | 2021-11-10 | Butler | Alabama | 1013 | 3382 | 99 |
1897852 | 1897852 | 2021-11-09 | Butler | Alabama | 1013 | 3381 | 99 |
1894602 | 1894602 | 2021-11-08 | Butler | Alabama | 1013 | 3377 | 99 |
1891352 | 1891352 | 2021-11-07 | Butler | Alabama | 1013 | 3378 | 99 |
1888102 | 1888102 | 2021-11-06 | Butler | Alabama | 1013 | 3377 | 99 |
1884852 | 1884852 | 2021-11-05 | Butler | Alabama | 1013 | 3377 | 99 |
1881603 | 1881603 | 2021-11-04 | Butler | Alabama | 1013 | 3374 | 99 |
1878354 | 1878354 | 2021-11-03 | Butler | Alabama | 1013 | 3369 | 96 |
1875105 | 1875105 | 2021-11-02 | Butler | Alabama | 1013 | 3365 | 96 |
1871856 | 1871856 | 2021-11-01 | Butler | Alabama | 1013 | 3353 | 96 |
1868607 | 1868607 | 2021-10-31 | Butler | Alabama | 1013 | 3351 | 96 |
1865358 | 1865358 | 2021-10-30 | Butler | Alabama | 1013 | 3349 | 96 |
1862109 | 1862109 | 2021-10-29 | Butler | Alabama | 1013 | 3346 | 97 |
1858860 | 1858860 | 2021-10-28 | Butler | Alabama | 1013 | 3345 | 97 |
1855611 | 1855611 | 2021-10-27 | Butler | Alabama | 1013 | 3335 | 96 |
1852362 | 1852362 | 2021-10-26 | Butler | Alabama | 1013 | 3285 | 96 |
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);