ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
82 rows where deaths = 192 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2278266 | 2278266 | 2022-03-06 | Chilton | Alabama | 1021 | 10656 | 192 |
2275013 | 2275013 | 2022-03-05 | Chilton | Alabama | 1021 | 10656 | 192 |
2271760 | 2271760 | 2022-03-04 | Chilton | Alabama | 1021 | 10656 | 192 |
2245740 | 2245740 | 2022-02-24 | Autauga | Alabama | 1001 | 15468 | 192 |
2008372 | 2008372 | 2021-12-13 | Coffee | Alabama | 1031 | 9469 | 192 |
2005121 | 2005121 | 2021-12-12 | Coffee | Alabama | 1031 | 9463 | 192 |
2001870 | 2001870 | 2021-12-11 | Coffee | Alabama | 1031 | 9461 | 192 |
1998620 | 1998620 | 2021-12-10 | Coffee | Alabama | 1031 | 9457 | 192 |
1998627 | 1998627 | 2021-12-10 | Dale | Alabama | 1045 | 9072 | 192 |
1995369 | 1995369 | 2021-12-09 | Coffee | Alabama | 1031 | 9454 | 192 |
1995376 | 1995376 | 2021-12-09 | Dale | Alabama | 1045 | 9066 | 192 |
1992118 | 1992118 | 2021-12-08 | Coffee | Alabama | 1031 | 9449 | 192 |
1992125 | 1992125 | 2021-12-08 | Dale | Alabama | 1045 | 9063 | 192 |
1988867 | 1988867 | 2021-12-07 | Coffee | Alabama | 1031 | 9447 | 192 |
1988874 | 1988874 | 2021-12-07 | Dale | Alabama | 1045 | 9052 | 192 |
1985617 | 1985617 | 2021-12-06 | Coffee | Alabama | 1031 | 9440 | 192 |
1985624 | 1985624 | 2021-12-06 | Dale | Alabama | 1045 | 9049 | 192 |
1982367 | 1982367 | 2021-12-05 | Coffee | Alabama | 1031 | 9439 | 192 |
1982374 | 1982374 | 2021-12-05 | Dale | Alabama | 1045 | 9045 | 192 |
1979117 | 1979117 | 2021-12-04 | Coffee | Alabama | 1031 | 9435 | 192 |
1979124 | 1979124 | 2021-12-04 | Dale | Alabama | 1045 | 9044 | 192 |
1975867 | 1975867 | 2021-12-03 | Coffee | Alabama | 1031 | 9435 | 192 |
1975874 | 1975874 | 2021-12-03 | Dale | Alabama | 1045 | 9038 | 192 |
1972618 | 1972618 | 2021-12-02 | Coffee | Alabama | 1031 | 9431 | 192 |
1972625 | 1972625 | 2021-12-02 | Dale | Alabama | 1045 | 9035 | 192 |
1969368 | 1969368 | 2021-12-01 | Coffee | Alabama | 1031 | 9428 | 192 |
1969375 | 1969375 | 2021-12-01 | Dale | Alabama | 1045 | 9030 | 192 |
1966107 | 1966107 | 2021-11-30 | Blount | Alabama | 1009 | 10729 | 192 |
1966118 | 1966118 | 2021-11-30 | Coffee | Alabama | 1031 | 9425 | 192 |
1966125 | 1966125 | 2021-11-30 | Dale | Alabama | 1045 | 9024 | 192 |
1962855 | 1962855 | 2021-11-29 | Blount | Alabama | 1009 | 10717 | 192 |
1962866 | 1962866 | 2021-11-29 | Coffee | Alabama | 1031 | 9417 | 192 |
1959604 | 1959604 | 2021-11-28 | Blount | Alabama | 1009 | 10715 | 192 |
1959615 | 1959615 | 2021-11-28 | Coffee | Alabama | 1031 | 9415 | 192 |
1956353 | 1956353 | 2021-11-27 | Blount | Alabama | 1009 | 10714 | 192 |
1956364 | 1956364 | 2021-11-27 | Coffee | Alabama | 1031 | 9414 | 192 |
1953102 | 1953102 | 2021-11-26 | Blount | Alabama | 1009 | 10700 | 192 |
1953113 | 1953113 | 2021-11-26 | Coffee | Alabama | 1031 | 9412 | 192 |
1949851 | 1949851 | 2021-11-25 | Blount | Alabama | 1009 | 10700 | 192 |
1949862 | 1949862 | 2021-11-25 | Coffee | Alabama | 1031 | 9412 | 192 |
1946600 | 1946600 | 2021-11-24 | Blount | Alabama | 1009 | 10696 | 192 |
1946611 | 1946611 | 2021-11-24 | Coffee | Alabama | 1031 | 9412 | 192 |
1943360 | 1943360 | 2021-11-23 | Coffee | Alabama | 1031 | 9411 | 192 |
1940110 | 1940110 | 2021-11-22 | Coffee | Alabama | 1031 | 9402 | 192 |
1936860 | 1936860 | 2021-11-21 | Coffee | Alabama | 1031 | 9401 | 192 |
1933610 | 1933610 | 2021-11-20 | Coffee | Alabama | 1031 | 9396 | 192 |
1923858 | 1923858 | 2021-11-17 | Coffee | Alabama | 1031 | 9373 | 192 |
1917359 | 1917359 | 2021-11-15 | Coffee | Alabama | 1031 | 9369 | 192 |
1914109 | 1914109 | 2021-11-14 | Coffee | Alabama | 1031 | 9369 | 192 |
1910859 | 1910859 | 2021-11-13 | Coffee | Alabama | 1031 | 9366 | 192 |
1897881 | 1897881 | 2021-11-09 | Jackson | Alabama | 1071 | 10122 | 192 |
1894631 | 1894631 | 2021-11-08 | Jackson | Alabama | 1071 | 10118 | 192 |
1891381 | 1891381 | 2021-11-07 | Jackson | Alabama | 1071 | 10117 | 192 |
1888131 | 1888131 | 2021-11-06 | Jackson | Alabama | 1071 | 10116 | 192 |
1884881 | 1884881 | 2021-11-05 | Jackson | Alabama | 1071 | 10118 | 192 |
1881612 | 1881612 | 2021-11-04 | Coffee | Alabama | 1031 | 9307 | 192 |
1878363 | 1878363 | 2021-11-03 | Coffee | Alabama | 1031 | 9299 | 192 |
1875114 | 1875114 | 2021-11-02 | Coffee | Alabama | 1031 | 9291 | 192 |
1790644 | 1790644 | 2021-10-07 | Dallas | Alabama | 1047 | 4783 | 192 |
1790682 | 1790682 | 2021-10-07 | Tallapoosa | Alabama | 1123 | 6916 | 192 |
1787396 | 1787396 | 2021-10-06 | Dallas | Alabama | 1047 | 4777 | 192 |
1667208 | 1667208 | 2021-08-30 | Lee | Alabama | 1081 | 20020 | 192 |
1663960 | 1663960 | 2021-08-29 | Lee | Alabama | 1081 | 19938 | 192 |
1660712 | 1660712 | 2021-08-28 | Lee | Alabama | 1081 | 19854 | 192 |
1657464 | 1657464 | 2021-08-27 | Lee | Alabama | 1081 | 19702 | 192 |
1654216 | 1654216 | 2021-08-26 | Lee | Alabama | 1081 | 19577 | 192 |
1650970 | 1650970 | 2021-08-25 | Lee | Alabama | 1081 | 19342 | 192 |
1647721 | 1647721 | 2021-08-24 | Lee | Alabama | 1081 | 19342 | 192 |
1644472 | 1644472 | 2021-08-23 | Lee | Alabama | 1081 | 19342 | 192 |
1641222 | 1641222 | 2021-08-22 | Lee | Alabama | 1081 | 19291 | 192 |
1637972 | 1637972 | 2021-08-21 | Lee | Alabama | 1081 | 19198 | 192 |
1579482 | 1579482 | 2021-08-03 | DeKalb | Alabama | 1049 | 9594 | 192 |
1576234 | 1576234 | 2021-08-02 | DeKalb | Alabama | 1049 | 9517 | 192 |
1572986 | 1572986 | 2021-08-01 | DeKalb | Alabama | 1049 | 9508 | 192 |
1569738 | 1569738 | 2021-07-31 | DeKalb | Alabama | 1049 | 9498 | 192 |
1566490 | 1566490 | 2021-07-30 | DeKalb | Alabama | 1049 | 9437 | 192 |
1563242 | 1563242 | 2021-07-29 | DeKalb | Alabama | 1049 | 9437 | 192 |
1267824 | 1267824 | 2021-04-29 | Cullman | Alabama | 1043 | 9586 | 192 |
1108710 | 1108710 | 2021-03-11 | Elmore | Alabama | 1051 | 9611 | 192 |
1017861 | 1017861 | 2021-02-11 | Shelby | Alabama | 1117 | 21098 | 192 |
385988 | 385988 | 2020-07-31 | Mobile | Alabama | 1097 | 8135 | 192 |
357071 | 357071 | 2020-07-22 | Jefferson | Alabama | 1073 | 9400 | 192 |
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);