ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
142 rows where deaths = 76 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499608 | 2499608 | 2022-05-13 | Henry | Alabama | 1067 | 4584 | 76 |
2496350 | 2496350 | 2022-05-12 | Henry | Alabama | 1067 | 4582 | 76 |
2493092 | 2493092 | 2022-05-11 | Henry | Alabama | 1067 | 4581 | 76 |
2489834 | 2489834 | 2022-05-10 | Henry | Alabama | 1067 | 4579 | 76 |
2486577 | 2486577 | 2022-05-09 | Henry | Alabama | 1067 | 4577 | 76 |
2483319 | 2483319 | 2022-05-08 | Henry | Alabama | 1067 | 4574 | 76 |
2480061 | 2480061 | 2022-05-07 | Henry | Alabama | 1067 | 4574 | 76 |
2476803 | 2476803 | 2022-05-06 | Henry | Alabama | 1067 | 4574 | 76 |
2473545 | 2473545 | 2022-05-05 | Henry | Alabama | 1067 | 4572 | 76 |
2470288 | 2470288 | 2022-05-04 | Henry | Alabama | 1067 | 4572 | 76 |
2467032 | 2467032 | 2022-05-03 | Henry | Alabama | 1067 | 4571 | 76 |
2444250 | 2444250 | 2022-04-26 | Lowndes | Alabama | 1085 | 2615 | 76 |
2440994 | 2440994 | 2022-04-25 | Lowndes | Alabama | 1085 | 2615 | 76 |
2437738 | 2437738 | 2022-04-24 | Lowndes | Alabama | 1085 | 2612 | 76 |
2434482 | 2434482 | 2022-04-23 | Lowndes | Alabama | 1085 | 2612 | 76 |
2431226 | 2431226 | 2022-04-22 | Lowndes | Alabama | 1085 | 2612 | 76 |
2427970 | 2427970 | 2022-04-21 | Lowndes | Alabama | 1085 | 2612 | 76 |
2424714 | 2424714 | 2022-04-20 | Lowndes | Alabama | 1085 | 2611 | 76 |
2421458 | 2421458 | 2022-04-19 | Lowndes | Alabama | 1085 | 2611 | 76 |
2418202 | 2418202 | 2022-04-18 | Lowndes | Alabama | 1085 | 2610 | 76 |
2414946 | 2414946 | 2022-04-17 | Lowndes | Alabama | 1085 | 2610 | 76 |
2411690 | 2411690 | 2022-04-16 | Lowndes | Alabama | 1085 | 2610 | 76 |
2408434 | 2408434 | 2022-04-15 | Lowndes | Alabama | 1085 | 2610 | 76 |
2405178 | 2405178 | 2022-04-14 | Lowndes | Alabama | 1085 | 2610 | 76 |
2401923 | 2401923 | 2022-04-13 | Lowndes | Alabama | 1085 | 2610 | 76 |
2398668 | 2398668 | 2022-04-12 | Lowndes | Alabama | 1085 | 2609 | 76 |
2395413 | 2395413 | 2022-04-11 | Lowndes | Alabama | 1085 | 2609 | 76 |
2392157 | 2392157 | 2022-04-10 | Lowndes | Alabama | 1085 | 2609 | 76 |
2388901 | 2388901 | 2022-04-09 | Lowndes | Alabama | 1085 | 2609 | 76 |
2385646 | 2385646 | 2022-04-08 | Lowndes | Alabama | 1085 | 2609 | 76 |
2382391 | 2382391 | 2022-04-07 | Lowndes | Alabama | 1085 | 2609 | 76 |
2379136 | 2379136 | 2022-04-06 | Lowndes | Alabama | 1085 | 2609 | 76 |
2268541 | 2268541 | 2022-03-03 | Macon | Alabama | 1087 | 3834 | 76 |
2265258 | 2265258 | 2022-03-02 | Clay | Alabama | 1027 | 4069 | 76 |
2262008 | 2262008 | 2022-03-01 | Clay | Alabama | 1027 | 4066 | 76 |
2258757 | 2258757 | 2022-02-28 | Clay | Alabama | 1027 | 4065 | 76 |
2255506 | 2255506 | 2022-02-27 | Clay | Alabama | 1027 | 4065 | 76 |
2252255 | 2252255 | 2022-02-26 | Clay | Alabama | 1027 | 4065 | 76 |
2249004 | 2249004 | 2022-02-25 | Clay | Alabama | 1027 | 4064 | 76 |
1946616 | 1946616 | 2021-11-24 | Crenshaw | Alabama | 1041 | 2602 | 76 |
1943365 | 1943365 | 2021-11-23 | Crenshaw | Alabama | 1041 | 2597 | 76 |
1940115 | 1940115 | 2021-11-22 | Crenshaw | Alabama | 1041 | 2592 | 76 |
1936865 | 1936865 | 2021-11-21 | Crenshaw | Alabama | 1041 | 2592 | 76 |
1933615 | 1933615 | 2021-11-20 | Crenshaw | Alabama | 1041 | 2592 | 76 |
1930363 | 1930363 | 2021-11-19 | Crenshaw | Alabama | 1041 | 2576 | 76 |
1878350 | 1878350 | 2021-11-03 | Barbour | Alabama | 1005 | 3607 | 76 |
1878368 | 1878368 | 2021-11-03 | Crenshaw | Alabama | 1041 | 2514 | 76 |
1875101 | 1875101 | 2021-11-02 | Barbour | Alabama | 1005 | 3605 | 76 |
1871852 | 1871852 | 2021-11-01 | Barbour | Alabama | 1005 | 3601 | 76 |
1868603 | 1868603 | 2021-10-31 | Barbour | Alabama | 1005 | 3601 | 76 |
1865354 | 1865354 | 2021-10-30 | Barbour | Alabama | 1005 | 3599 | 76 |
1862105 | 1862105 | 2021-10-29 | Barbour | Alabama | 1005 | 3596 | 76 |
1858856 | 1858856 | 2021-10-28 | Barbour | Alabama | 1005 | 3596 | 76 |
1855607 | 1855607 | 2021-10-27 | Barbour | Alabama | 1005 | 3595 | 76 |
1852358 | 1852358 | 2021-10-26 | Barbour | Alabama | 1005 | 3583 | 76 |
1849108 | 1849108 | 2021-10-25 | Barbour | Alabama | 1005 | 3578 | 76 |
1845858 | 1845858 | 2021-10-24 | Barbour | Alabama | 1005 | 3578 | 76 |
1842608 | 1842608 | 2021-10-23 | Barbour | Alabama | 1005 | 3577 | 76 |
1839359 | 1839359 | 2021-10-22 | Barbour | Alabama | 1005 | 3575 | 76 |
1836110 | 1836110 | 2021-10-21 | Barbour | Alabama | 1005 | 3566 | 76 |
1832861 | 1832861 | 2021-10-20 | Barbour | Alabama | 1005 | 3565 | 76 |
1829612 | 1829612 | 2021-10-19 | Barbour | Alabama | 1005 | 3563 | 76 |
1793898 | 1793898 | 2021-10-08 | Fayette | Alabama | 1057 | 2853 | 76 |
1771178 | 1771178 | 2021-10-01 | Pickens | Alabama | 1107 | 3094 | 76 |
1767929 | 1767929 | 2021-09-30 | Pickens | Alabama | 1107 | 3084 | 76 |
1764680 | 1764680 | 2021-09-29 | Pickens | Alabama | 1107 | 3082 | 76 |
1741898 | 1741898 | 2021-09-22 | Clarke | Alabama | 1025 | 4570 | 76 |
1725641 | 1725641 | 2021-09-17 | Bibb | Alabama | 1007 | 3947 | 76 |
1722392 | 1722392 | 2021-09-16 | Bibb | Alabama | 1007 | 3929 | 76 |
1712692 | 1712692 | 2021-09-13 | Marengo | Alabama | 1091 | 3157 | 76 |
1709445 | 1709445 | 2021-09-12 | Marengo | Alabama | 1091 | 3152 | 76 |
1706198 | 1706198 | 2021-09-11 | Marengo | Alabama | 1091 | 3145 | 76 |
1702911 | 1702911 | 2021-09-10 | Butler | Alabama | 1013 | 2979 | 76 |
1702950 | 1702950 | 2021-09-10 | Marengo | Alabama | 1091 | 3128 | 76 |
1699661 | 1699661 | 2021-09-09 | Butler | Alabama | 1013 | 2952 | 76 |
1696412 | 1696412 | 2021-09-08 | Butler | Alabama | 1013 | 2938 | 76 |
1693164 | 1693164 | 2021-09-07 | Butler | Alabama | 1013 | 2925 | 76 |
1689915 | 1689915 | 2021-09-06 | Butler | Alabama | 1013 | 2912 | 76 |
1686665 | 1686665 | 2021-09-05 | Butler | Alabama | 1013 | 2902 | 76 |
1683415 | 1683415 | 2021-09-04 | Butler | Alabama | 1013 | 2887 | 76 |
1680164 | 1680164 | 2021-09-03 | Butler | Alabama | 1013 | 2866 | 76 |
1654242 | 1654242 | 2021-08-26 | Winston | Alabama | 1133 | 3451 | 76 |
1303542 | 1303542 | 2021-05-10 | Escambia | Alabama | 1053 | 3934 | 76 |
1300295 | 1300295 | 2021-05-09 | Escambia | Alabama | 1053 | 3933 | 76 |
1297048 | 1297048 | 2021-05-08 | Escambia | Alabama | 1053 | 3933 | 76 |
1293802 | 1293802 | 2021-05-07 | Escambia | Alabama | 1053 | 3932 | 76 |
1290556 | 1290556 | 2021-05-06 | Escambia | Alabama | 1053 | 3932 | 76 |
1287310 | 1287310 | 2021-05-05 | Escambia | Alabama | 1053 | 3930 | 76 |
1287314 | 1287314 | 2021-05-05 | Geneva | Alabama | 1061 | 2476 | 76 |
1287316 | 1287316 | 2021-05-05 | Hale | Alabama | 1065 | 2222 | 76 |
1284070 | 1284070 | 2021-05-04 | Hale | Alabama | 1065 | 2217 | 76 |
1280823 | 1280823 | 2021-05-03 | Hale | Alabama | 1065 | 2217 | 76 |
1277576 | 1277576 | 2021-05-02 | Hale | Alabama | 1065 | 2217 | 76 |
1274329 | 1274329 | 2021-05-01 | Hale | Alabama | 1065 | 2217 | 76 |
1261363 | 1261363 | 2021-04-27 | Pike | Alabama | 1109 | 3079 | 76 |
1258116 | 1258116 | 2021-04-26 | Pike | Alabama | 1109 | 3075 | 76 |
1254869 | 1254869 | 2021-04-25 | Pike | Alabama | 1109 | 3074 | 76 |
1251622 | 1251622 | 2021-04-24 | Pike | Alabama | 1109 | 3074 | 76 |
1248375 | 1248375 | 2021-04-23 | Pike | Alabama | 1109 | 3071 | 76 |
1245128 | 1245128 | 2021-04-22 | Pike | Alabama | 1109 | 3067 | 76 |
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);