ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
317 rows where deaths = 59 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Clay 71
- Washington 53
- Barbour 26
- Pickens 26
- Crenshaw 19
- Dale 17
- Fayette 14
- Elmore 10
- Lee 10
- Russell 10
- Calhoun 7
- Bibb 6
- Colbert 6
- Lamar 6
- Hale 5
- Cullman 3
- Marengo 3
- Tuscaloosa 3
- Clarke 2
- DeKalb 2
- Marshall 2
- Randolph 2
- Tallapoosa 2
- Butler 1
- Conecuh 1
- Escambia 1
- Geneva 1
- Henry 1
- Jefferson 1
- Lawrence 1
- …
state 1
- Alabama · 317 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499639 | 2499639 | 2022-05-13 | Washington | Alabama | 1129 | 3736 | 59 |
2496381 | 2496381 | 2022-05-12 | Washington | Alabama | 1129 | 3735 | 59 |
2493123 | 2493123 | 2022-05-11 | Washington | Alabama | 1129 | 3735 | 59 |
2489865 | 2489865 | 2022-05-10 | Washington | Alabama | 1129 | 3734 | 59 |
2486608 | 2486608 | 2022-05-09 | Washington | Alabama | 1129 | 3733 | 59 |
2483350 | 2483350 | 2022-05-08 | Washington | Alabama | 1129 | 3731 | 59 |
2480092 | 2480092 | 2022-05-07 | Washington | Alabama | 1129 | 3731 | 59 |
2476834 | 2476834 | 2022-05-06 | Washington | Alabama | 1129 | 3731 | 59 |
2473576 | 2473576 | 2022-05-05 | Washington | Alabama | 1129 | 3731 | 59 |
2470319 | 2470319 | 2022-05-04 | Washington | Alabama | 1129 | 3730 | 59 |
2467063 | 2467063 | 2022-05-03 | Washington | Alabama | 1129 | 3730 | 59 |
2463808 | 2463808 | 2022-05-02 | Washington | Alabama | 1129 | 3730 | 59 |
2460552 | 2460552 | 2022-05-01 | Washington | Alabama | 1129 | 3730 | 59 |
2457296 | 2457296 | 2022-04-30 | Washington | Alabama | 1129 | 3730 | 59 |
2454040 | 2454040 | 2022-04-29 | Washington | Alabama | 1129 | 3730 | 59 |
2450784 | 2450784 | 2022-04-28 | Washington | Alabama | 1129 | 3730 | 59 |
2447528 | 2447528 | 2022-04-27 | Washington | Alabama | 1129 | 3731 | 59 |
2444272 | 2444272 | 2022-04-26 | Washington | Alabama | 1129 | 3730 | 59 |
2441016 | 2441016 | 2022-04-25 | Washington | Alabama | 1129 | 3730 | 59 |
2437760 | 2437760 | 2022-04-24 | Washington | Alabama | 1129 | 3730 | 59 |
2434504 | 2434504 | 2022-04-23 | Washington | Alabama | 1129 | 3730 | 59 |
2431248 | 2431248 | 2022-04-22 | Washington | Alabama | 1129 | 3730 | 59 |
2427992 | 2427992 | 2022-04-21 | Washington | Alabama | 1129 | 3730 | 59 |
2424736 | 2424736 | 2022-04-20 | Washington | Alabama | 1129 | 3730 | 59 |
2421480 | 2421480 | 2022-04-19 | Washington | Alabama | 1129 | 3730 | 59 |
2418224 | 2418224 | 2022-04-18 | Washington | Alabama | 1129 | 3731 | 59 |
2414968 | 2414968 | 2022-04-17 | Washington | Alabama | 1129 | 3731 | 59 |
2411712 | 2411712 | 2022-04-16 | Washington | Alabama | 1129 | 3731 | 59 |
2408456 | 2408456 | 2022-04-15 | Washington | Alabama | 1129 | 3731 | 59 |
2405200 | 2405200 | 2022-04-14 | Washington | Alabama | 1129 | 3731 | 59 |
2401945 | 2401945 | 2022-04-13 | Washington | Alabama | 1129 | 3731 | 59 |
2398690 | 2398690 | 2022-04-12 | Washington | Alabama | 1129 | 3731 | 59 |
2395435 | 2395435 | 2022-04-11 | Washington | Alabama | 1129 | 3731 | 59 |
2392179 | 2392179 | 2022-04-10 | Washington | Alabama | 1129 | 3731 | 59 |
2388923 | 2388923 | 2022-04-09 | Washington | Alabama | 1129 | 3731 | 59 |
2385668 | 2385668 | 2022-04-08 | Washington | Alabama | 1129 | 3731 | 59 |
2382413 | 2382413 | 2022-04-07 | Washington | Alabama | 1129 | 3731 | 59 |
2379158 | 2379158 | 2022-04-06 | Washington | Alabama | 1129 | 3731 | 59 |
2375904 | 2375904 | 2022-04-05 | Washington | Alabama | 1129 | 3731 | 59 |
2372652 | 2372652 | 2022-04-04 | Washington | Alabama | 1129 | 3730 | 59 |
2369399 | 2369399 | 2022-04-03 | Washington | Alabama | 1129 | 3730 | 59 |
2366146 | 2366146 | 2022-04-02 | Washington | Alabama | 1129 | 3730 | 59 |
2362893 | 2362893 | 2022-04-01 | Washington | Alabama | 1129 | 3730 | 59 |
2359639 | 2359639 | 2022-03-31 | Washington | Alabama | 1129 | 3730 | 59 |
2356385 | 2356385 | 2022-03-30 | Washington | Alabama | 1129 | 3730 | 59 |
2353132 | 2353132 | 2022-03-29 | Washington | Alabama | 1129 | 3728 | 59 |
2349880 | 2349880 | 2022-03-28 | Washington | Alabama | 1129 | 3728 | 59 |
2346627 | 2346627 | 2022-03-27 | Washington | Alabama | 1129 | 3725 | 59 |
2343374 | 2343374 | 2022-03-26 | Washington | Alabama | 1129 | 3725 | 59 |
2340121 | 2340121 | 2022-03-25 | Washington | Alabama | 1129 | 3725 | 59 |
2336868 | 2336868 | 2022-03-24 | Washington | Alabama | 1129 | 3724 | 59 |
2333614 | 2333614 | 2022-03-23 | Washington | Alabama | 1129 | 3724 | 59 |
2330360 | 2330360 | 2022-03-22 | Washington | Alabama | 1129 | 3724 | 59 |
2076650 | 2076650 | 2022-01-03 | Lamar | Alabama | 1075 | 2624 | 59 |
2073399 | 2073399 | 2022-01-02 | Lamar | Alabama | 1075 | 2617 | 59 |
2070148 | 2070148 | 2022-01-01 | Lamar | Alabama | 1075 | 2613 | 59 |
2066897 | 2066897 | 2021-12-31 | Lamar | Alabama | 1075 | 2613 | 59 |
2063647 | 2063647 | 2021-12-30 | Lamar | Alabama | 1075 | 2603 | 59 |
2060397 | 2060397 | 2021-12-29 | Lamar | Alabama | 1075 | 2595 | 59 |
1875116 | 1875116 | 2021-11-02 | Conecuh | Alabama | 1035 | 1893 | 59 |
1862159 | 1862159 | 2021-10-29 | Russell | Alabama | 1113 | 6978 | 59 |
1858910 | 1858910 | 2021-10-28 | Russell | Alabama | 1113 | 6976 | 59 |
1855661 | 1855661 | 2021-10-27 | Russell | Alabama | 1113 | 6963 | 59 |
1852412 | 1852412 | 2021-10-26 | Russell | Alabama | 1113 | 6376 | 59 |
1849162 | 1849162 | 2021-10-25 | Russell | Alabama | 1113 | 6375 | 59 |
1845912 | 1845912 | 2021-10-24 | Russell | Alabama | 1113 | 6370 | 59 |
1842662 | 1842662 | 2021-10-23 | Russell | Alabama | 1113 | 6366 | 59 |
1839413 | 1839413 | 2021-10-22 | Russell | Alabama | 1113 | 6352 | 59 |
1836164 | 1836164 | 2021-10-21 | Russell | Alabama | 1113 | 6279 | 59 |
1832915 | 1832915 | 2021-10-20 | Russell | Alabama | 1113 | 6266 | 59 |
1793919 | 1793919 | 2021-10-08 | Monroe | Alabama | 1099 | 3257 | 59 |
1790676 | 1790676 | 2021-10-07 | Randolph | Alabama | 1111 | 3223 | 59 |
1787416 | 1787416 | 2021-10-06 | Macon | Alabama | 1087 | 2256 | 59 |
1787428 | 1787428 | 2021-10-06 | Randolph | Alabama | 1111 | 3215 | 59 |
1767909 | 1767909 | 2021-09-30 | Henry | Alabama | 1067 | 3049 | 59 |
1650950 | 1650950 | 2021-08-25 | Crenshaw | Alabama | 1041 | 1938 | 59 |
1647701 | 1647701 | 2021-08-24 | Crenshaw | Alabama | 1041 | 1938 | 59 |
1644452 | 1644452 | 2021-08-23 | Crenshaw | Alabama | 1041 | 1938 | 59 |
1641202 | 1641202 | 2021-08-22 | Crenshaw | Alabama | 1041 | 1933 | 59 |
1637952 | 1637952 | 2021-08-21 | Crenshaw | Alabama | 1041 | 1923 | 59 |
1634702 | 1634702 | 2021-08-20 | Crenshaw | Alabama | 1041 | 1893 | 59 |
1631454 | 1631454 | 2021-08-19 | Crenshaw | Alabama | 1041 | 1882 | 59 |
1628207 | 1628207 | 2021-08-18 | Crenshaw | Alabama | 1041 | 1863 | 59 |
1624960 | 1624960 | 2021-08-17 | Crenshaw | Alabama | 1041 | 1847 | 59 |
1621706 | 1621706 | 2021-08-16 | Clay | Alabama | 1027 | 1757 | 59 |
1621713 | 1621713 | 2021-08-16 | Crenshaw | Alabama | 1041 | 1840 | 59 |
1618458 | 1618458 | 2021-08-15 | Clay | Alabama | 1027 | 1751 | 59 |
1618465 | 1618465 | 2021-08-15 | Crenshaw | Alabama | 1041 | 1832 | 59 |
1615210 | 1615210 | 2021-08-14 | Clay | Alabama | 1027 | 1725 | 59 |
1615217 | 1615217 | 2021-08-14 | Crenshaw | Alabama | 1041 | 1809 | 59 |
1611961 | 1611961 | 2021-08-13 | Clay | Alabama | 1027 | 1725 | 59 |
1611968 | 1611968 | 2021-08-13 | Crenshaw | Alabama | 1041 | 1809 | 59 |
1608714 | 1608714 | 2021-08-12 | Clay | Alabama | 1027 | 1719 | 59 |
1608721 | 1608721 | 2021-08-12 | Crenshaw | Alabama | 1041 | 1801 | 59 |
1605465 | 1605465 | 2021-08-11 | Clay | Alabama | 1027 | 1712 | 59 |
1605472 | 1605472 | 2021-08-11 | Crenshaw | Alabama | 1041 | 1789 | 59 |
1602215 | 1602215 | 2021-08-10 | Clay | Alabama | 1027 | 1708 | 59 |
1602222 | 1602222 | 2021-08-10 | Crenshaw | Alabama | 1041 | 1779 | 59 |
1598967 | 1598967 | 2021-08-09 | Clay | Alabama | 1027 | 1704 | 59 |
1598974 | 1598974 | 2021-08-09 | Crenshaw | Alabama | 1041 | 1765 | 59 |
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);