ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
60 rows where deaths = 161 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2398634 | 2398634 | 2022-04-12 | Chambers | Alabama | 1017 | 8476 | 161 |
2395379 | 2395379 | 2022-04-11 | Chambers | Alabama | 1017 | 8474 | 161 |
2392123 | 2392123 | 2022-04-10 | Chambers | Alabama | 1017 | 8471 | 161 |
2388867 | 2388867 | 2022-04-09 | Chambers | Alabama | 1017 | 8471 | 161 |
2385612 | 2385612 | 2022-04-08 | Chambers | Alabama | 1017 | 8471 | 161 |
2382357 | 2382357 | 2022-04-07 | Chambers | Alabama | 1017 | 8471 | 161 |
2379102 | 2379102 | 2022-04-06 | Chambers | Alabama | 1017 | 8469 | 161 |
2375848 | 2375848 | 2022-04-05 | Chambers | Alabama | 1017 | 8469 | 161 |
2372596 | 2372596 | 2022-04-04 | Chambers | Alabama | 1017 | 8469 | 161 |
2369343 | 2369343 | 2022-04-03 | Chambers | Alabama | 1017 | 8468 | 161 |
2366090 | 2366090 | 2022-04-02 | Chambers | Alabama | 1017 | 8468 | 161 |
2362837 | 2362837 | 2022-04-01 | Chambers | Alabama | 1017 | 8468 | 161 |
2359583 | 2359583 | 2022-03-31 | Chambers | Alabama | 1017 | 8468 | 161 |
2356329 | 2356329 | 2022-03-30 | Chambers | Alabama | 1017 | 8468 | 161 |
2353076 | 2353076 | 2022-03-29 | Chambers | Alabama | 1017 | 8467 | 161 |
2349824 | 2349824 | 2022-03-28 | Chambers | Alabama | 1017 | 8465 | 161 |
2346571 | 2346571 | 2022-03-27 | Chambers | Alabama | 1017 | 8464 | 161 |
2343318 | 2343318 | 2022-03-26 | Chambers | Alabama | 1017 | 8464 | 161 |
2340065 | 2340065 | 2022-03-25 | Chambers | Alabama | 1017 | 8464 | 161 |
2291291 | 2291291 | 2022-03-10 | Escambia | Alabama | 1053 | 9971 | 161 |
2288039 | 2288039 | 2022-03-09 | Escambia | Alabama | 1053 | 9968 | 161 |
2086369 | 2086369 | 2022-01-06 | Autauga | Alabama | 1001 | 11638 | 161 |
2083117 | 2083117 | 2022-01-05 | Autauga | Alabama | 1001 | 11478 | 161 |
2079865 | 2079865 | 2022-01-04 | Autauga | Alabama | 1001 | 11347 | 161 |
1839367 | 1839367 | 2021-10-22 | Chilton | Alabama | 1021 | 6633 | 161 |
1836118 | 1836118 | 2021-10-21 | Chilton | Alabama | 1021 | 6627 | 161 |
1832869 | 1832869 | 2021-10-20 | Chilton | Alabama | 1021 | 6608 | 161 |
1771129 | 1771129 | 2021-10-01 | Blount | Alabama | 1009 | 9842 | 161 |
1764662 | 1764662 | 2021-09-29 | Jackson | Alabama | 1071 | 9455 | 161 |
1761413 | 1761413 | 2021-09-28 | Jackson | Alabama | 1071 | 9429 | 161 |
1735403 | 1735403 | 2021-09-20 | Coffee | Alabama | 1031 | 8681 | 161 |
1732153 | 1732153 | 2021-09-19 | Coffee | Alabama | 1031 | 8663 | 161 |
1728903 | 1728903 | 2021-09-18 | Coffee | Alabama | 1031 | 8646 | 161 |
1667229 | 1667229 | 2021-08-30 | Tallapoosa | Alabama | 1123 | 5524 | 161 |
1663981 | 1663981 | 2021-08-29 | Tallapoosa | Alabama | 1123 | 5489 | 161 |
1660733 | 1660733 | 2021-08-28 | Tallapoosa | Alabama | 1123 | 5468 | 161 |
1602243 | 1602243 | 2021-08-10 | Limestone | Alabama | 1083 | 11171 | 161 |
1598995 | 1598995 | 2021-08-09 | Limestone | Alabama | 1083 | 11095 | 161 |
1595746 | 1595746 | 2021-08-08 | Limestone | Alabama | 1083 | 11027 | 161 |
1592497 | 1592497 | 2021-08-07 | Limestone | Alabama | 1083 | 11027 | 161 |
1530768 | 1530768 | 2021-07-19 | Dallas | Alabama | 1047 | 3658 | 161 |
1527521 | 1527521 | 2021-07-18 | Dallas | Alabama | 1047 | 3658 | 161 |
1524274 | 1524274 | 2021-07-17 | Dallas | Alabama | 1047 | 3657 | 161 |
1521026 | 1521026 | 2021-07-16 | Dallas | Alabama | 1047 | 3654 | 161 |
1517778 | 1517778 | 2021-07-15 | Dallas | Alabama | 1047 | 3649 | 161 |
1514531 | 1514531 | 2021-07-14 | Dallas | Alabama | 1047 | 3645 | 161 |
1105479 | 1105479 | 2021-03-10 | Lee | Alabama | 1081 | 15108 | 161 |
1102233 | 1102233 | 2021-03-09 | Lee | Alabama | 1081 | 15087 | 161 |
1098987 | 1098987 | 2021-03-08 | Lee | Alabama | 1081 | 15084 | 161 |
1095739 | 1095739 | 2021-03-07 | Lee | Alabama | 1081 | 15083 | 161 |
1092493 | 1092493 | 2021-03-06 | Lee | Alabama | 1081 | 15070 | 161 |
1056812 | 1056812 | 2021-02-23 | Talladega | Alabama | 1121 | 7424 | 161 |
1053566 | 1053566 | 2021-02-22 | Talladega | Alabama | 1121 | 7407 | 161 |
1050319 | 1050319 | 2021-02-21 | Talladega | Alabama | 1121 | 7400 | 161 |
1047072 | 1047072 | 2021-02-20 | Talladega | Alabama | 1121 | 7391 | 161 |
1043827 | 1043827 | 2021-02-19 | Talladega | Alabama | 1121 | 7373 | 161 |
1014583 | 1014583 | 2021-02-10 | DeKalb | Alabama | 1049 | 8294 | 161 |
995105 | 995105 | 2021-02-04 | Cullman | Alabama | 1043 | 8670 | 161 |
881494 | 881494 | 2020-12-31 | Baldwin | Alabama | 1003 | 13601 | 161 |
806893 | 806893 | 2020-12-08 | Madison | Alabama | 1089 | 15575 | 161 |
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);