ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
129 rows where deaths = 91 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2427984 | 2427984 | 2022-04-21 | Russell | Alabama | 1113 | 10067 | 91 |
2424728 | 2424728 | 2022-04-20 | Russell | Alabama | 1113 | 10064 | 91 |
2421472 | 2421472 | 2022-04-19 | Russell | Alabama | 1113 | 10064 | 91 |
2418216 | 2418216 | 2022-04-18 | Russell | Alabama | 1113 | 10062 | 91 |
2414960 | 2414960 | 2022-04-17 | Russell | Alabama | 1113 | 10062 | 91 |
2411704 | 2411704 | 2022-04-16 | Russell | Alabama | 1113 | 10062 | 91 |
2408448 | 2408448 | 2022-04-15 | Russell | Alabama | 1113 | 10062 | 91 |
2405192 | 2405192 | 2022-04-14 | Russell | Alabama | 1113 | 10060 | 91 |
2401937 | 2401937 | 2022-04-13 | Russell | Alabama | 1113 | 10058 | 91 |
2398682 | 2398682 | 2022-04-12 | Russell | Alabama | 1113 | 10057 | 91 |
2258764 | 2258764 | 2022-02-28 | Crenshaw | Alabama | 1041 | 3770 | 91 |
2255513 | 2255513 | 2022-02-27 | Crenshaw | Alabama | 1041 | 3770 | 91 |
2252262 | 2252262 | 2022-02-26 | Crenshaw | Alabama | 1041 | 3770 | 91 |
2249011 | 2249011 | 2022-02-25 | Crenshaw | Alabama | 1041 | 3768 | 91 |
2245760 | 2245760 | 2022-02-24 | Crenshaw | Alabama | 1041 | 3770 | 91 |
2222985 | 2222985 | 2022-02-17 | Barbour | Alabama | 1005 | 5422 | 91 |
2219734 | 2219734 | 2022-02-16 | Barbour | Alabama | 1005 | 5413 | 91 |
2170954 | 2170954 | 2022-02-01 | Clarke | Alabama | 1025 | 6781 | 91 |
2115664 | 2115664 | 2022-01-15 | Hale | Alabama | 1065 | 3705 | 91 |
2112412 | 2112412 | 2022-01-14 | Hale | Alabama | 1065 | 3705 | 91 |
2109160 | 2109160 | 2022-01-13 | Hale | Alabama | 1065 | 3705 | 91 |
2105909 | 2105909 | 2022-01-12 | Hale | Alabama | 1065 | 3705 | 91 |
2102658 | 2102658 | 2022-01-11 | Hale | Alabama | 1065 | 3659 | 91 |
2099407 | 2099407 | 2022-01-10 | Hale | Alabama | 1065 | 3613 | 91 |
2096156 | 2096156 | 2022-01-09 | Hale | Alabama | 1065 | 3583 | 91 |
2092904 | 2092904 | 2022-01-08 | Hale | Alabama | 1065 | 3539 | 91 |
2089652 | 2089652 | 2022-01-07 | Hale | Alabama | 1065 | 3514 | 91 |
2086401 | 2086401 | 2022-01-06 | Hale | Alabama | 1065 | 3467 | 91 |
2086422 | 2086422 | 2022-01-06 | Pickens | Alabama | 1107 | 3609 | 91 |
2083149 | 2083149 | 2022-01-05 | Hale | Alabama | 1065 | 3440 | 91 |
2083170 | 2083170 | 2022-01-05 | Pickens | Alabama | 1107 | 3566 | 91 |
2079897 | 2079897 | 2022-01-04 | Hale | Alabama | 1065 | 3408 | 91 |
2079918 | 2079918 | 2022-01-04 | Pickens | Alabama | 1107 | 3518 | 91 |
2076645 | 2076645 | 2022-01-03 | Hale | Alabama | 1065 | 3364 | 91 |
2076666 | 2076666 | 2022-01-03 | Pickens | Alabama | 1107 | 3500 | 91 |
2073394 | 2073394 | 2022-01-02 | Hale | Alabama | 1065 | 3355 | 91 |
2073415 | 2073415 | 2022-01-02 | Pickens | Alabama | 1107 | 3492 | 91 |
2070143 | 2070143 | 2022-01-01 | Hale | Alabama | 1065 | 3309 | 91 |
2070164 | 2070164 | 2022-01-01 | Pickens | Alabama | 1107 | 3467 | 91 |
2066892 | 2066892 | 2021-12-31 | Hale | Alabama | 1065 | 3309 | 91 |
2066913 | 2066913 | 2021-12-31 | Pickens | Alabama | 1107 | 3467 | 91 |
2063642 | 2063642 | 2021-12-30 | Hale | Alabama | 1065 | 3295 | 91 |
2063663 | 2063663 | 2021-12-30 | Pickens | Alabama | 1107 | 3437 | 91 |
2060392 | 2060392 | 2021-12-29 | Hale | Alabama | 1065 | 3275 | 91 |
2060413 | 2060413 | 2021-12-29 | Pickens | Alabama | 1107 | 3420 | 91 |
2057143 | 2057143 | 2021-12-28 | Hale | Alabama | 1065 | 3253 | 91 |
2057164 | 2057164 | 2021-12-28 | Pickens | Alabama | 1107 | 3403 | 91 |
2053894 | 2053894 | 2021-12-27 | Hale | Alabama | 1065 | 3249 | 91 |
2053915 | 2053915 | 2021-12-27 | Pickens | Alabama | 1107 | 3398 | 91 |
2050644 | 2050644 | 2021-12-26 | Hale | Alabama | 1065 | 3248 | 91 |
2050665 | 2050665 | 2021-12-26 | Pickens | Alabama | 1107 | 3397 | 91 |
2047394 | 2047394 | 2021-12-25 | Hale | Alabama | 1065 | 3247 | 91 |
2047415 | 2047415 | 2021-12-25 | Pickens | Alabama | 1107 | 3397 | 91 |
2044144 | 2044144 | 2021-12-24 | Hale | Alabama | 1065 | 3243 | 91 |
2044165 | 2044165 | 2021-12-24 | Pickens | Alabama | 1107 | 3396 | 91 |
2040895 | 2040895 | 2021-12-23 | Hale | Alabama | 1065 | 3238 | 91 |
2040916 | 2040916 | 2021-12-23 | Pickens | Alabama | 1107 | 3389 | 91 |
2037666 | 2037666 | 2021-12-22 | Pickens | Alabama | 1107 | 3386 | 91 |
2034416 | 2034416 | 2021-12-21 | Pickens | Alabama | 1107 | 3384 | 91 |
2031166 | 2031166 | 2021-12-20 | Pickens | Alabama | 1107 | 3382 | 91 |
2027915 | 2027915 | 2021-12-19 | Pickens | Alabama | 1107 | 3381 | 91 |
2024664 | 2024664 | 2021-12-18 | Pickens | Alabama | 1107 | 3378 | 91 |
2021413 | 2021413 | 2021-12-17 | Pickens | Alabama | 1107 | 3374 | 91 |
2018162 | 2018162 | 2021-12-16 | Pickens | Alabama | 1107 | 3370 | 91 |
2014912 | 2014912 | 2021-12-15 | Pickens | Alabama | 1107 | 3369 | 91 |
2011661 | 2011661 | 2021-12-14 | Pickens | Alabama | 1107 | 3364 | 91 |
2008410 | 2008410 | 2021-12-13 | Pickens | Alabama | 1107 | 3359 | 91 |
2005159 | 2005159 | 2021-12-12 | Pickens | Alabama | 1107 | 3359 | 91 |
2001908 | 2001908 | 2021-12-11 | Pickens | Alabama | 1107 | 3358 | 91 |
1998658 | 1998658 | 2021-12-10 | Pickens | Alabama | 1107 | 3355 | 91 |
1884891 | 1884891 | 2021-11-05 | Marengo | Alabama | 1091 | 3402 | 91 |
1881642 | 1881642 | 2021-11-04 | Marengo | Alabama | 1091 | 3403 | 91 |
1878351 | 1878351 | 2021-11-03 | Bibb | Alabama | 1007 | 4286 | 91 |
1784130 | 1784130 | 2021-10-05 | Butler | Alabama | 1013 | 3213 | 91 |
1780881 | 1780881 | 2021-10-04 | Butler | Alabama | 1013 | 3210 | 91 |
1777631 | 1777631 | 2021-10-03 | Butler | Alabama | 1013 | 3210 | 91 |
1774381 | 1774381 | 2021-10-02 | Butler | Alabama | 1013 | 3209 | 91 |
1735442 | 1735442 | 2021-09-20 | Pike | Alabama | 1109 | 4529 | 91 |
1732192 | 1732192 | 2021-09-19 | Pike | Alabama | 1109 | 4518 | 91 |
1728942 | 1728942 | 2021-09-18 | Pike | Alabama | 1109 | 4500 | 91 |
1702934 | 1702934 | 2021-09-10 | Franklin | Alabama | 1059 | 5505 | 91 |
1699684 | 1699684 | 2021-09-09 | Franklin | Alabama | 1059 | 5490 | 91 |
1696435 | 1696435 | 2021-09-08 | Franklin | Alabama | 1059 | 5443 | 91 |
1676940 | 1676940 | 2021-09-02 | Geneva | Alabama | 1061 | 3768 | 91 |
1673689 | 1673689 | 2021-09-01 | Escambia | Alabama | 1053 | 5773 | 91 |
1670441 | 1670441 | 2021-08-31 | Escambia | Alabama | 1053 | 5719 | 91 |
1082716 | 1082716 | 2021-03-03 | Autauga | Alabama | 1001 | 6313 | 91 |
1079470 | 1079470 | 2021-03-02 | Autauga | Alabama | 1001 | 6303 | 91 |
1076225 | 1076225 | 2021-03-01 | Autauga | Alabama | 1001 | 6270 | 91 |
1072979 | 1072979 | 2021-02-28 | Autauga | Alabama | 1001 | 6264 | 91 |
1069733 | 1069733 | 2021-02-27 | Autauga | Alabama | 1001 | 6248 | 91 |
1040537 | 1040537 | 2021-02-18 | Coffee | Alabama | 1031 | 5194 | 91 |
1037292 | 1037292 | 2021-02-17 | Coffee | Alabama | 1031 | 5169 | 91 |
1037323 | 1037323 | 2021-02-17 | Marion | Alabama | 1093 | 2716 | 91 |
1034047 | 1034047 | 2021-02-16 | Coffee | Alabama | 1031 | 5161 | 91 |
1034078 | 1034078 | 2021-02-16 | Marion | Alabama | 1093 | 2714 | 91 |
1030801 | 1030801 | 2021-02-15 | Coffee | Alabama | 1031 | 5155 | 91 |
1030832 | 1030832 | 2021-02-15 | Marion | Alabama | 1093 | 2709 | 91 |
1027554 | 1027554 | 2021-02-14 | Coffee | Alabama | 1031 | 5149 | 91 |
1027585 | 1027585 | 2021-02-14 | Marion | Alabama | 1093 | 2706 | 91 |
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);