ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
141 rows where deaths = 92 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 |
---|---|---|---|---|---|---|---|
2444264 | 2444264 | 2022-04-26 | Russell | Alabama | 1113 | 10083 | 92 |
2441008 | 2441008 | 2022-04-25 | Russell | Alabama | 1113 | 10081 | 92 |
2437752 | 2437752 | 2022-04-24 | Russell | Alabama | 1113 | 10070 | 92 |
2434496 | 2434496 | 2022-04-23 | Russell | Alabama | 1113 | 10070 | 92 |
2431240 | 2431240 | 2022-04-22 | Russell | Alabama | 1113 | 10070 | 92 |
2265265 | 2265265 | 2022-03-02 | Crenshaw | Alabama | 1041 | 3770 | 92 |
2265273 | 2265273 | 2022-03-02 | Fayette | Alabama | 1057 | 4913 | 92 |
2262015 | 2262015 | 2022-03-01 | Crenshaw | Alabama | 1041 | 3770 | 92 |
2262023 | 2262023 | 2022-03-01 | Fayette | Alabama | 1057 | 4904 | 92 |
2258772 | 2258772 | 2022-02-28 | Fayette | Alabama | 1057 | 4899 | 92 |
2255521 | 2255521 | 2022-02-27 | Fayette | Alabama | 1057 | 4899 | 92 |
2252270 | 2252270 | 2022-02-26 | Fayette | Alabama | 1057 | 4898 | 92 |
2249019 | 2249019 | 2022-02-25 | Fayette | Alabama | 1057 | 4835 | 92 |
2245742 | 2245742 | 2022-02-24 | Barbour | Alabama | 1005 | 5436 | 92 |
2245768 | 2245768 | 2022-02-24 | Fayette | Alabama | 1057 | 4738 | 92 |
2242491 | 2242491 | 2022-02-23 | Barbour | Alabama | 1005 | 5433 | 92 |
2242517 | 2242517 | 2022-02-23 | Fayette | Alabama | 1057 | 4687 | 92 |
2239240 | 2239240 | 2022-02-22 | Barbour | Alabama | 1005 | 5430 | 92 |
2239266 | 2239266 | 2022-02-22 | Fayette | Alabama | 1057 | 4674 | 92 |
2235989 | 2235989 | 2022-02-21 | Barbour | Alabama | 1005 | 5429 | 92 |
2236015 | 2236015 | 2022-02-21 | Fayette | Alabama | 1057 | 4669 | 92 |
2232738 | 2232738 | 2022-02-20 | Barbour | Alabama | 1005 | 5429 | 92 |
2232764 | 2232764 | 2022-02-20 | Fayette | Alabama | 1057 | 4668 | 92 |
2229487 | 2229487 | 2022-02-19 | Barbour | Alabama | 1005 | 5426 | 92 |
2229513 | 2229513 | 2022-02-19 | Fayette | Alabama | 1057 | 4666 | 92 |
2226236 | 2226236 | 2022-02-18 | Barbour | Alabama | 1005 | 5424 | 92 |
2226262 | 2226262 | 2022-02-18 | Fayette | Alabama | 1057 | 4664 | 92 |
2157976 | 2157976 | 2022-01-28 | Pickens | Alabama | 1107 | 4711 | 92 |
2154723 | 2154723 | 2022-01-27 | Pickens | Alabama | 1107 | 4711 | 92 |
2151470 | 2151470 | 2022-01-26 | Pickens | Alabama | 1107 | 4711 | 92 |
2148218 | 2148218 | 2022-01-25 | Pickens | Alabama | 1107 | 4711 | 92 |
2144966 | 2144966 | 2022-01-24 | Pickens | Alabama | 1107 | 4711 | 92 |
2141711 | 2141711 | 2022-01-23 | Pickens | Alabama | 1107 | 4691 | 92 |
2138455 | 2138455 | 2022-01-22 | Pickens | Alabama | 1107 | 4641 | 92 |
2135200 | 2135200 | 2022-01-21 | Pickens | Alabama | 1107 | 4520 | 92 |
2131948 | 2131948 | 2022-01-20 | Pickens | Alabama | 1107 | 4389 | 92 |
2128694 | 2128694 | 2022-01-19 | Pickens | Alabama | 1107 | 4293 | 92 |
2125441 | 2125441 | 2022-01-18 | Pickens | Alabama | 1107 | 4229 | 92 |
2122189 | 2122189 | 2022-01-17 | Pickens | Alabama | 1107 | 4198 | 92 |
2118937 | 2118937 | 2022-01-16 | Pickens | Alabama | 1107 | 4178 | 92 |
2115685 | 2115685 | 2022-01-15 | Pickens | Alabama | 1107 | 3918 | 92 |
2112433 | 2112433 | 2022-01-14 | Pickens | Alabama | 1107 | 3918 | 92 |
2109181 | 2109181 | 2022-01-13 | Pickens | Alabama | 1107 | 3918 | 92 |
2105930 | 2105930 | 2022-01-12 | Pickens | Alabama | 1107 | 3918 | 92 |
2102679 | 2102679 | 2022-01-11 | Pickens | Alabama | 1107 | 3854 | 92 |
2099428 | 2099428 | 2022-01-10 | Pickens | Alabama | 1107 | 3826 | 92 |
2096177 | 2096177 | 2022-01-09 | Pickens | Alabama | 1107 | 3792 | 92 |
2092925 | 2092925 | 2022-01-08 | Pickens | Alabama | 1107 | 3709 | 92 |
2089673 | 2089673 | 2022-01-07 | Pickens | Alabama | 1107 | 3664 | 92 |
1923846 | 1923846 | 2021-11-17 | Bibb | Alabama | 1007 | 4325 | 92 |
1923888 | 1923888 | 2021-11-17 | Marengo | Alabama | 1091 | 3422 | 92 |
1920597 | 1920597 | 2021-11-16 | Bibb | Alabama | 1007 | 4323 | 92 |
1920639 | 1920639 | 2021-11-16 | Marengo | Alabama | 1091 | 3420 | 92 |
1917347 | 1917347 | 2021-11-15 | Bibb | Alabama | 1007 | 4317 | 92 |
1914097 | 1914097 | 2021-11-14 | Bibb | Alabama | 1007 | 4317 | 92 |
1910847 | 1910847 | 2021-11-13 | Bibb | Alabama | 1007 | 4317 | 92 |
1907598 | 1907598 | 2021-11-12 | Bibb | Alabama | 1007 | 4313 | 92 |
1904349 | 1904349 | 2021-11-11 | Bibb | Alabama | 1007 | 4310 | 92 |
1901099 | 1901099 | 2021-11-10 | Bibb | Alabama | 1007 | 4302 | 92 |
1897849 | 1897849 | 2021-11-09 | Bibb | Alabama | 1007 | 4301 | 92 |
1894599 | 1894599 | 2021-11-08 | Bibb | Alabama | 1007 | 4295 | 92 |
1894641 | 1894641 | 2021-11-08 | Marengo | Alabama | 1091 | 3405 | 92 |
1891349 | 1891349 | 2021-11-07 | Bibb | Alabama | 1007 | 4295 | 92 |
1891391 | 1891391 | 2021-11-07 | Marengo | Alabama | 1091 | 3404 | 92 |
1888099 | 1888099 | 2021-11-06 | Bibb | Alabama | 1007 | 4294 | 92 |
1888141 | 1888141 | 2021-11-06 | Marengo | Alabama | 1091 | 3404 | 92 |
1884849 | 1884849 | 2021-11-05 | Bibb | Alabama | 1007 | 4295 | 92 |
1881600 | 1881600 | 2021-11-04 | Bibb | Alabama | 1007 | 4290 | 92 |
1787379 | 1787379 | 2021-10-06 | Butler | Alabama | 1013 | 3217 | 92 |
1745201 | 1745201 | 2021-09-23 | Winston | Alabama | 1133 | 4202 | 92 |
1741952 | 1741952 | 2021-09-22 | Winston | Alabama | 1133 | 4171 | 92 |
1719170 | 1719170 | 2021-09-15 | Franklin | Alabama | 1059 | 5582 | 92 |
1715922 | 1715922 | 2021-09-14 | Franklin | Alabama | 1059 | 5566 | 92 |
1712676 | 1712676 | 2021-09-13 | Franklin | Alabama | 1059 | 5539 | 92 |
1709429 | 1709429 | 2021-09-12 | Franklin | Alabama | 1059 | 5532 | 92 |
1706182 | 1706182 | 2021-09-11 | Franklin | Alabama | 1059 | 5528 | 92 |
1147683 | 1147683 | 2021-03-23 | Lawrence | Alabama | 1079 | 2910 | 92 |
1144436 | 1144436 | 2021-03-22 | Lawrence | Alabama | 1079 | 2910 | 92 |
1141189 | 1141189 | 2021-03-21 | Lawrence | Alabama | 1079 | 2910 | 92 |
1137943 | 1137943 | 2021-03-20 | Lawrence | Alabama | 1079 | 2908 | 92 |
1134697 | 1134697 | 2021-03-19 | Lawrence | Alabama | 1079 | 2910 | 92 |
1131449 | 1131449 | 2021-03-18 | Lawrence | Alabama | 1079 | 2908 | 92 |
1128202 | 1128202 | 2021-03-17 | Lawrence | Alabama | 1079 | 2908 | 92 |
1124956 | 1124956 | 2021-03-16 | Lawrence | Alabama | 1079 | 2906 | 92 |
1121710 | 1121710 | 2021-03-15 | Lawrence | Alabama | 1079 | 2903 | 92 |
1118463 | 1118463 | 2021-03-14 | Lawrence | Alabama | 1079 | 2872 | 92 |
1115216 | 1115216 | 2021-03-13 | Lawrence | Alabama | 1079 | 2870 | 92 |
1111970 | 1111970 | 2021-03-12 | Lawrence | Alabama | 1079 | 2870 | 92 |
1108724 | 1108724 | 2021-03-11 | Lawrence | Alabama | 1079 | 2869 | 92 |
1105478 | 1105478 | 2021-03-10 | Lawrence | Alabama | 1079 | 2864 | 92 |
1102193 | 1102193 | 2021-03-09 | Autauga | Alabama | 1001 | 6371 | 92 |
1098947 | 1098947 | 2021-03-08 | Autauga | Alabama | 1001 | 6364 | 92 |
1095699 | 1095699 | 2021-03-07 | Autauga | Alabama | 1001 | 6347 | 92 |
1092453 | 1092453 | 2021-03-06 | Autauga | Alabama | 1001 | 6344 | 92 |
1089207 | 1089207 | 2021-03-05 | Autauga | Alabama | 1001 | 6333 | 92 |
1085962 | 1085962 | 2021-03-04 | Autauga | Alabama | 1001 | 6324 | 92 |
1056798 | 1056798 | 2021-02-23 | Marion | Alabama | 1093 | 2774 | 92 |
1053552 | 1053552 | 2021-02-22 | Marion | Alabama | 1093 | 2737 | 92 |
1050305 | 1050305 | 2021-02-21 | Marion | Alabama | 1093 | 2736 | 92 |
1047058 | 1047058 | 2021-02-20 | Marion | Alabama | 1093 | 2729 | 92 |
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);