ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
75 rows where deaths = 216 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499575 | 2499575 | 2022-05-13 | Autauga | Alabama | 1001 | 15863 | 216 |
2496317 | 2496317 | 2022-05-12 | Autauga | Alabama | 1001 | 15860 | 216 |
2493059 | 2493059 | 2022-05-11 | Autauga | Alabama | 1001 | 15853 | 216 |
2489801 | 2489801 | 2022-05-10 | Autauga | Alabama | 1001 | 15852 | 216 |
2486544 | 2486544 | 2022-05-09 | Autauga | Alabama | 1001 | 15846 | 216 |
2483286 | 2483286 | 2022-05-08 | Autauga | Alabama | 1001 | 15840 | 216 |
2480028 | 2480028 | 2022-05-07 | Autauga | Alabama | 1001 | 15840 | 216 |
2476770 | 2476770 | 2022-05-06 | Autauga | Alabama | 1001 | 15840 | 216 |
2473512 | 2473512 | 2022-05-05 | Autauga | Alabama | 1001 | 15840 | 216 |
2470255 | 2470255 | 2022-05-04 | Autauga | Alabama | 1001 | 15839 | 216 |
2466999 | 2466999 | 2022-05-03 | Autauga | Alabama | 1001 | 15835 | 216 |
2463744 | 2463744 | 2022-05-02 | Autauga | Alabama | 1001 | 15833 | 216 |
2460488 | 2460488 | 2022-05-01 | Autauga | Alabama | 1001 | 15827 | 216 |
2457232 | 2457232 | 2022-04-30 | Autauga | Alabama | 1001 | 15827 | 216 |
2453976 | 2453976 | 2022-04-29 | Autauga | Alabama | 1001 | 15827 | 216 |
2450720 | 2450720 | 2022-04-28 | Autauga | Alabama | 1001 | 15826 | 216 |
2447464 | 2447464 | 2022-04-27 | Autauga | Alabama | 1001 | 15821 | 216 |
2258766 | 2258766 | 2022-02-28 | Dale | Alabama | 1045 | 12424 | 216 |
2255515 | 2255515 | 2022-02-27 | Dale | Alabama | 1045 | 12422 | 216 |
2252264 | 2252264 | 2022-02-26 | Dale | Alabama | 1045 | 12420 | 216 |
2249013 | 2249013 | 2022-02-25 | Dale | Alabama | 1045 | 12419 | 216 |
2245744 | 2245744 | 2022-02-24 | Blount | Alabama | 1009 | 14710 | 216 |
2245759 | 2245759 | 2022-02-24 | Covington | Alabama | 1039 | 9226 | 216 |
2245762 | 2245762 | 2022-02-24 | Dale | Alabama | 1045 | 12414 | 216 |
2242493 | 2242493 | 2022-02-23 | Blount | Alabama | 1009 | 14706 | 216 |
2242504 | 2242504 | 2022-02-23 | Coffee | Alabama | 1031 | 13279 | 216 |
2242508 | 2242508 | 2022-02-23 | Covington | Alabama | 1039 | 9223 | 216 |
2239242 | 2239242 | 2022-02-22 | Blount | Alabama | 1009 | 14688 | 216 |
2239253 | 2239253 | 2022-02-22 | Coffee | Alabama | 1031 | 13272 | 216 |
2235991 | 2235991 | 2022-02-21 | Blount | Alabama | 1009 | 14682 | 216 |
2236002 | 2236002 | 2022-02-21 | Coffee | Alabama | 1031 | 13266 | 216 |
2232740 | 2232740 | 2022-02-20 | Blount | Alabama | 1009 | 14672 | 216 |
2232751 | 2232751 | 2022-02-20 | Coffee | Alabama | 1031 | 13262 | 216 |
2229489 | 2229489 | 2022-02-19 | Blount | Alabama | 1009 | 14663 | 216 |
2229500 | 2229500 | 2022-02-19 | Coffee | Alabama | 1031 | 13259 | 216 |
2226249 | 2226249 | 2022-02-18 | Coffee | Alabama | 1031 | 13254 | 216 |
2216517 | 2216517 | 2022-02-15 | Jackson | Alabama | 1071 | 14770 | 216 |
2216543 | 2216543 | 2022-02-15 | Tallapoosa | Alabama | 1123 | 11203 | 216 |
2213292 | 2213292 | 2022-02-14 | Tallapoosa | Alabama | 1123 | 11193 | 216 |
2210039 | 2210039 | 2022-02-13 | Tallapoosa | Alabama | 1123 | 11188 | 216 |
2206786 | 2206786 | 2022-02-12 | Tallapoosa | Alabama | 1123 | 11181 | 216 |
2203533 | 2203533 | 2022-02-11 | Tallapoosa | Alabama | 1123 | 11166 | 216 |
2200279 | 2200279 | 2022-02-10 | Tallapoosa | Alabama | 1123 | 11148 | 216 |
2131918 | 2131918 | 2022-01-20 | Dallas | Alabama | 1047 | 6992 | 216 |
2128664 | 2128664 | 2022-01-19 | Dallas | Alabama | 1047 | 6865 | 216 |
2125411 | 2125411 | 2022-01-18 | Dallas | Alabama | 1047 | 6767 | 216 |
2122159 | 2122159 | 2022-01-17 | Dallas | Alabama | 1047 | 6748 | 216 |
2118907 | 2118907 | 2022-01-16 | Dallas | Alabama | 1047 | 6714 | 216 |
2086385 | 2086385 | 2022-01-06 | Colbert | Alabama | 1033 | 10380 | 216 |
1741926 | 1741926 | 2021-09-22 | Lee | Alabama | 1081 | 22231 | 216 |
1530770 | 1530770 | 2021-07-19 | Elmore | Alabama | 1051 | 10518 | 216 |
1527523 | 1527523 | 2021-07-18 | Elmore | Alabama | 1051 | 10502 | 216 |
1524276 | 1524276 | 2021-07-17 | Elmore | Alabama | 1051 | 10483 | 216 |
1521028 | 1521028 | 2021-07-16 | Elmore | Alabama | 1051 | 10465 | 216 |
1517780 | 1517780 | 2021-07-15 | Elmore | Alabama | 1051 | 10445 | 216 |
1514533 | 1514533 | 2021-07-14 | Elmore | Alabama | 1051 | 10429 | 216 |
1154185 | 1154185 | 2021-03-25 | Marshall | Alabama | 1095 | 11828 | 216 |
1131448 | 1131448 | 2021-03-18 | Lauderdale | Alabama | 1077 | 9000 | 216 |
1128201 | 1128201 | 2021-03-17 | Lauderdale | Alabama | 1077 | 8993 | 216 |
1124955 | 1124955 | 2021-03-16 | Lauderdale | Alabama | 1077 | 8973 | 216 |
1121709 | 1121709 | 2021-03-15 | Lauderdale | Alabama | 1077 | 8962 | 216 |
1118462 | 1118462 | 2021-03-14 | Lauderdale | Alabama | 1077 | 8692 | 216 |
1115215 | 1115215 | 2021-03-13 | Lauderdale | Alabama | 1077 | 8683 | 216 |
1111978 | 1111978 | 2021-03-12 | Marshall | Alabama | 1095 | 11491 | 216 |
1108732 | 1108732 | 2021-03-11 | Marshall | Alabama | 1095 | 11488 | 216 |
1105486 | 1105486 | 2021-03-10 | Marshall | Alabama | 1095 | 11475 | 216 |
995135 | 995135 | 2021-02-04 | Morgan | Alabama | 1103 | 13143 | 216 |
965874 | 965874 | 2021-01-26 | Baldwin | Alabama | 1003 | 17496 | 216 |
878310 | 878310 | 2020-12-30 | Tuscaloosa | Alabama | 1125 | 18341 | 216 |
875065 | 875065 | 2020-12-29 | Tuscaloosa | Alabama | 1125 | 18086 | 216 |
871820 | 871820 | 2020-12-28 | Tuscaloosa | Alabama | 1125 | 17859 | 216 |
868575 | 868575 | 2020-12-27 | Tuscaloosa | Alabama | 1125 | 17772 | 216 |
865330 | 865330 | 2020-12-26 | Tuscaloosa | Alabama | 1125 | 17684 | 216 |
862085 | 862085 | 2020-12-25 | Tuscaloosa | Alabama | 1125 | 17635 | 216 |
858840 | 858840 | 2020-12-24 | Tuscaloosa | Alabama | 1125 | 17473 | 216 |
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);