ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
61 rows where deaths = 203 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2281509 | 2281509 | 2022-03-07 | Autauga | Alabama | 1001 | 15539 | 203 |
2167704 | 2167704 | 2022-01-31 | Coffee | Alabama | 1031 | 12807 | 203 |
2164449 | 2164449 | 2022-01-30 | Coffee | Alabama | 1031 | 12773 | 203 |
2161194 | 2161194 | 2022-01-29 | Coffee | Alabama | 1031 | 12705 | 203 |
2157942 | 2157942 | 2022-01-28 | Covington | Alabama | 1039 | 8579 | 203 |
2154689 | 2154689 | 2022-01-27 | Covington | Alabama | 1039 | 8579 | 203 |
2151436 | 2151436 | 2022-01-26 | Covington | Alabama | 1039 | 8579 | 203 |
2148184 | 2148184 | 2022-01-25 | Covington | Alabama | 1039 | 8579 | 203 |
2144932 | 2144932 | 2022-01-24 | Covington | Alabama | 1039 | 8579 | 203 |
2141677 | 2141677 | 2022-01-23 | Covington | Alabama | 1039 | 8525 | 203 |
2138421 | 2138421 | 2022-01-22 | Covington | Alabama | 1039 | 8480 | 203 |
2135166 | 2135166 | 2022-01-21 | Covington | Alabama | 1039 | 8381 | 203 |
2131914 | 2131914 | 2022-01-20 | Covington | Alabama | 1039 | 8281 | 203 |
2128645 | 2128645 | 2022-01-19 | Blount | Alabama | 1009 | 12825 | 203 |
2128660 | 2128660 | 2022-01-19 | Covington | Alabama | 1039 | 8183 | 203 |
2125392 | 2125392 | 2022-01-18 | Blount | Alabama | 1009 | 12648 | 203 |
2125407 | 2125407 | 2022-01-18 | Covington | Alabama | 1039 | 8083 | 203 |
2122140 | 2122140 | 2022-01-17 | Blount | Alabama | 1009 | 12579 | 203 |
2122155 | 2122155 | 2022-01-17 | Covington | Alabama | 1039 | 8020 | 203 |
2118888 | 2118888 | 2022-01-16 | Blount | Alabama | 1009 | 12520 | 203 |
2118903 | 2118903 | 2022-01-16 | Covington | Alabama | 1039 | 7946 | 203 |
2115651 | 2115651 | 2022-01-15 | Covington | Alabama | 1039 | 7587 | 203 |
2112399 | 2112399 | 2022-01-14 | Covington | Alabama | 1039 | 7587 | 203 |
2109147 | 2109147 | 2022-01-13 | Covington | Alabama | 1039 | 7587 | 203 |
2105896 | 2105896 | 2022-01-12 | Covington | Alabama | 1039 | 7587 | 203 |
2102645 | 2102645 | 2022-01-11 | Covington | Alabama | 1039 | 7524 | 203 |
2102661 | 2102661 | 2022-01-11 | Jackson | Alabama | 1071 | 11225 | 203 |
2099394 | 2099394 | 2022-01-10 | Covington | Alabama | 1039 | 7507 | 203 |
2099410 | 2099410 | 2022-01-10 | Jackson | Alabama | 1071 | 11143 | 203 |
2096143 | 2096143 | 2022-01-09 | Covington | Alabama | 1039 | 7468 | 203 |
2096159 | 2096159 | 2022-01-09 | Jackson | Alabama | 1071 | 11121 | 203 |
2092891 | 2092891 | 2022-01-08 | Covington | Alabama | 1039 | 7401 | 203 |
2092907 | 2092907 | 2022-01-08 | Jackson | Alabama | 1071 | 11060 | 203 |
2089639 | 2089639 | 2022-01-07 | Covington | Alabama | 1039 | 7375 | 203 |
2018170 | 2018170 | 2021-12-16 | Tallapoosa | Alabama | 1123 | 7383 | 203 |
2014920 | 2014920 | 2021-12-15 | Tallapoosa | Alabama | 1123 | 7372 | 203 |
2011669 | 2011669 | 2021-12-14 | Tallapoosa | Alabama | 1123 | 7355 | 203 |
2008418 | 2008418 | 2021-12-13 | Tallapoosa | Alabama | 1123 | 7327 | 203 |
2005167 | 2005167 | 2021-12-12 | Tallapoosa | Alabama | 1123 | 7325 | 203 |
2001916 | 2001916 | 2021-12-11 | Tallapoosa | Alabama | 1123 | 7321 | 203 |
1878364 | 1878364 | 2021-11-03 | Colbert | Alabama | 1033 | 9149 | 203 |
1862144 | 1862144 | 2021-10-29 | Limestone | Alabama | 1083 | 15728 | 203 |
1858877 | 1858877 | 2021-10-28 | Dallas | Alabama | 1047 | 5197 | 203 |
1725678 | 1725678 | 2021-09-17 | Lee | Alabama | 1081 | 21787 | 203 |
1722449 | 1722449 | 2021-09-16 | Talladega | Alabama | 1121 | 12235 | 203 |
1530766 | 1530766 | 2021-07-19 | Cullman | Alabama | 1043 | 10127 | 203 |
1527519 | 1527519 | 2021-07-18 | Cullman | Alabama | 1043 | 10115 | 203 |
1524272 | 1524272 | 2021-07-17 | Cullman | Alabama | 1043 | 10106 | 203 |
1521024 | 1521024 | 2021-07-16 | Cullman | Alabama | 1043 | 10103 | 203 |
1517776 | 1517776 | 2021-07-15 | Cullman | Alabama | 1043 | 10098 | 203 |
1514529 | 1514529 | 2021-07-14 | Cullman | Alabama | 1043 | 10081 | 203 |
1511283 | 1511283 | 2021-07-13 | Cullman | Alabama | 1043 | 10062 | 203 |
1508036 | 1508036 | 2021-07-12 | Cullman | Alabama | 1043 | 10062 | 203 |
1504790 | 1504790 | 2021-07-11 | Cullman | Alabama | 1043 | 10051 | 203 |
1501544 | 1501544 | 2021-07-10 | Cullman | Alabama | 1043 | 10051 | 203 |
1248346 | 1248346 | 2021-04-23 | Elmore | Alabama | 1051 | 10006 | 203 |
1235358 | 1235358 | 2021-04-19 | Elmore | Alabama | 1051 | 10024 | 203 |
1232110 | 1232110 | 2021-04-18 | Elmore | Alabama | 1051 | 10022 | 203 |
1228862 | 1228862 | 2021-04-17 | Elmore | Alabama | 1051 | 10018 | 203 |
1060045 | 1060045 | 2021-02-24 | Marshall | Alabama | 1095 | 11212 | 203 |
398854 | 398854 | 2020-08-04 | Mobile | Alabama | 1097 | 9228 | 203 |
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);