ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
52,312 rows where state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Jefferson 304
- Limestone 304
- Montgomery 304
- Tuscaloosa 304
- Elmore 303
- Baldwin 302
- Lee 302
- Shelby 302
- Madison 300
- St. Clair 300
- Talladega 299
- Calhoun 298
- Mobile 298
- Walker 298
- Chambers 297
- Jackson 297
- Lamar 297
- Lauderdale 297
- Washington 297
- Cullman 296
- Marion 296
- Houston 294
- Tallapoosa 294
- Franklin 293
- Morgan 293
- Autauga 292
- Lawrence 292
- Marshall 292
- Pickens 292
- Pike 292
- …
state 1
- Alabama · 19,583 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
913981 | 913981 | 2021-01-10 | Henry | Alabama | 1067 | 1433 | 11 |
913982 | 913982 | 2021-01-10 | Houston | Alabama | 1069 | 8167 | 72 |
913983 | 913983 | 2021-01-10 | Jackson | Alabama | 1071 | 5611 | 34 |
913984 | 913984 | 2021-01-10 | Jefferson | Alabama | 1073 | 58896 | 784 |
913985 | 913985 | 2021-01-10 | Lamar | Alabama | 1075 | 1137 | 16 |
913986 | 913986 | 2021-01-10 | Lauderdale | Alabama | 1077 | 7191 | 72 |
913987 | 913987 | 2021-01-10 | Lawrence | Alabama | 1079 | 2324 | 44 |
913988 | 913988 | 2021-01-10 | Lee | Alabama | 1081 | 11565 | 79 |
913989 | 913989 | 2021-01-10 | Limestone | Alabama | 1083 | 7599 | 60 |
913990 | 913990 | 2021-01-10 | Lowndes | Alabama | 1085 | 1052 | 35 |
913991 | 913991 | 2021-01-10 | Macon | Alabama | 1087 | 1093 | 35 |
913992 | 913992 | 2021-01-10 | Madison | Alabama | 1089 | 25463 | 178 |
913993 | 913993 | 2021-01-10 | Marengo | Alabama | 1091 | 1946 | 27 |
913994 | 913994 | 2021-01-10 | Marion | Alabama | 1093 | 2320 | 46 |
913995 | 913995 | 2021-01-10 | Marshall | Alabama | 1095 | 9854 | 92 |
913996 | 913996 | 2021-01-10 | Mobile | Alabama | 1097 | 28584 | 523 |
913997 | 913997 | 2021-01-10 | Monroe | Alabama | 1099 | 1384 | 12 |
913998 | 913998 | 2021-01-10 | Montgomery | Alabama | 1101 | 18064 | 285 |
913999 | 913999 | 2021-01-10 | Morgan | Alabama | 1103 | 11727 | 104 |
914000 | 914000 | 2021-01-10 | Perry | Alabama | 1105 | 930 | 19 |
914001 | 914001 | 2021-01-10 | Pickens | Alabama | 1107 | 1888 | 31 |
914002 | 914002 | 2021-01-10 | Pike | Alabama | 1109 | 2338 | 23 |
914003 | 914003 | 2021-01-10 | Randolph | Alabama | 1111 | 1349 | 32 |
914004 | 914004 | 2021-01-10 | Russell | Alabama | 1113 | 3067 | 7 |
914005 | 914005 | 2021-01-10 | Shelby | Alabama | 1117 | 17562 | 106 |
914006 | 914006 | 2021-01-10 | St. Clair | Alabama | 1115 | 7213 | 115 |
914007 | 914007 | 2021-01-10 | Sumter | Alabama | 1119 | 889 | 26 |
914008 | 914008 | 2021-01-10 | Talladega | Alabama | 1121 | 5796 | 109 |
914009 | 914009 | 2021-01-10 | Tallapoosa | Alabama | 1123 | 2552 | 107 |
914010 | 914010 | 2021-01-10 | Tuscaloosa | Alabama | 1125 | 20142 | 267 |
914011 | 914011 | 2021-01-10 | Walker | Alabama | 1127 | 5734 | 170 |
914012 | 914012 | 2021-01-10 | Washington | Alabama | 1129 | 1320 | 26 |
914013 | 914013 | 2021-01-10 | Wilcox | Alabama | 1131 | 974 | 20 |
914014 | 914014 | 2021-01-10 | Winston | Alabama | 1133 | 2182 | 34 |
910703 | 910703 | 2021-01-09 | Autauga | Alabama | 1001 | 4847 | 53 |
910704 | 910704 | 2021-01-09 | Baldwin | Alabama | 1003 | 15202 | 173 |
910705 | 910705 | 2021-01-09 | Barbour | Alabama | 1005 | 1648 | 35 |
910706 | 910706 | 2021-01-09 | Bibb | Alabama | 1007 | 2038 | 48 |
910707 | 910707 | 2021-01-09 | Blount | Alabama | 1009 | 5047 | 77 |
910708 | 910708 | 2021-01-09 | Bullock | Alabama | 1011 | 950 | 28 |
910709 | 910709 | 2021-01-09 | Butler | Alabama | 1013 | 1625 | 55 |
910710 | 910710 | 2021-01-09 | Calhoun | Alabama | 1015 | 10453 | 168 |
910711 | 910711 | 2021-01-09 | Chambers | Alabama | 1017 | 2620 | 63 |
910712 | 910712 | 2021-01-09 | Cherokee | Alabama | 1019 | 1523 | 24 |
910713 | 910713 | 2021-01-09 | Chilton | Alabama | 1021 | 3237 | 54 |
910714 | 910714 | 2021-01-09 | Choctaw | Alabama | 1023 | 500 | 22 |
910715 | 910715 | 2021-01-09 | Clarke | Alabama | 1025 | 2619 | 26 |
910716 | 910716 | 2021-01-09 | Clay | Alabama | 1027 | 1223 | 35 |
910717 | 910717 | 2021-01-09 | Cleburne | Alabama | 1029 | 1117 | 17 |
910718 | 910718 | 2021-01-09 | Coffee | Alabama | 1031 | 4106 | 42 |
910719 | 910719 | 2021-01-09 | Colbert | Alabama | 1033 | 5054 | 61 |
910720 | 910720 | 2021-01-09 | Conecuh | Alabama | 1035 | 905 | 18 |
910721 | 910721 | 2021-01-09 | Coosa | Alabama | 1037 | 578 | 9 |
910722 | 910722 | 2021-01-09 | Covington | Alabama | 1039 | 3145 | 43 |
910723 | 910723 | 2021-01-09 | Crenshaw | Alabama | 1041 | 1119 | 36 |
910724 | 910724 | 2021-01-09 | Cullman | Alabama | 1043 | 7666 | 78 |
910725 | 910725 | 2021-01-09 | Dale | Alabama | 1045 | 3687 | 64 |
910726 | 910726 | 2021-01-09 | Dallas | Alabama | 1047 | 2916 | 44 |
910727 | 910727 | 2021-01-09 | DeKalb | Alabama | 1049 | 7352 | 62 |
910728 | 910728 | 2021-01-09 | Elmore | Alabama | 1051 | 7334 | 85 |
910729 | 910729 | 2021-01-09 | Escambia | Alabama | 1053 | 2953 | 34 |
910730 | 910730 | 2021-01-09 | Etowah | Alabama | 1055 | 11058 | 106 |
910731 | 910731 | 2021-01-09 | Fayette | Alabama | 1057 | 1561 | 21 |
910732 | 910732 | 2021-01-09 | Franklin | Alabama | 1059 | 3514 | 39 |
910733 | 910733 | 2021-01-09 | Geneva | Alabama | 1061 | 1882 | 23 |
910734 | 910734 | 2021-01-09 | Greene | Alabama | 1063 | 726 | 20 |
910735 | 910735 | 2021-01-09 | Hale | Alabama | 1065 | 1656 | 41 |
910736 | 910736 | 2021-01-09 | Henry | Alabama | 1067 | 1424 | 10 |
910737 | 910737 | 2021-01-09 | Houston | Alabama | 1069 | 8112 | 72 |
910738 | 910738 | 2021-01-09 | Jackson | Alabama | 1071 | 5567 | 34 |
910739 | 910739 | 2021-01-09 | Jefferson | Alabama | 1073 | 58394 | 784 |
910740 | 910740 | 2021-01-09 | Lamar | Alabama | 1075 | 1132 | 16 |
910741 | 910741 | 2021-01-09 | Lauderdale | Alabama | 1077 | 7149 | 72 |
910742 | 910742 | 2021-01-09 | Lawrence | Alabama | 1079 | 2315 | 44 |
910743 | 910743 | 2021-01-09 | Lee | Alabama | 1081 | 11498 | 79 |
910744 | 910744 | 2021-01-09 | Limestone | Alabama | 1083 | 7548 | 60 |
910745 | 910745 | 2021-01-09 | Lowndes | Alabama | 1085 | 1046 | 34 |
910746 | 910746 | 2021-01-09 | Macon | Alabama | 1087 | 1082 | 35 |
910747 | 910747 | 2021-01-09 | Madison | Alabama | 1089 | 25219 | 177 |
910748 | 910748 | 2021-01-09 | Marengo | Alabama | 1091 | 1934 | 27 |
910749 | 910749 | 2021-01-09 | Marion | Alabama | 1093 | 2304 | 46 |
910750 | 910750 | 2021-01-09 | Marshall | Alabama | 1095 | 9819 | 92 |
910751 | 910751 | 2021-01-09 | Mobile | Alabama | 1097 | 28266 | 523 |
910752 | 910752 | 2021-01-09 | Monroe | Alabama | 1099 | 1378 | 12 |
910753 | 910753 | 2021-01-09 | Montgomery | Alabama | 1101 | 17916 | 282 |
910754 | 910754 | 2021-01-09 | Morgan | Alabama | 1103 | 11634 | 104 |
910755 | 910755 | 2021-01-09 | Perry | Alabama | 1105 | 925 | 19 |
910756 | 910756 | 2021-01-09 | Pickens | Alabama | 1107 | 1877 | 31 |
910757 | 910757 | 2021-01-09 | Pike | Alabama | 1109 | 2328 | 23 |
910758 | 910758 | 2021-01-09 | Randolph | Alabama | 1111 | 1334 | 32 |
910759 | 910759 | 2021-01-09 | Russell | Alabama | 1113 | 3052 | 7 |
910760 | 910760 | 2021-01-09 | Shelby | Alabama | 1117 | 17449 | 106 |
910761 | 910761 | 2021-01-09 | St. Clair | Alabama | 1115 | 7167 | 115 |
910762 | 910762 | 2021-01-09 | Sumter | Alabama | 1119 | 887 | 26 |
910763 | 910763 | 2021-01-09 | Talladega | Alabama | 1121 | 5766 | 109 |
910764 | 910764 | 2021-01-09 | Tallapoosa | Alabama | 1123 | 2540 | 107 |
910765 | 910765 | 2021-01-09 | Tuscaloosa | Alabama | 1125 | 20062 | 267 |
910766 | 910766 | 2021-01-09 | Walker | Alabama | 1127 | 5714 | 170 |
910767 | 910767 | 2021-01-09 | Washington | Alabama | 1129 | 1312 | 26 |
910768 | 910768 | 2021-01-09 | Wilcox | Alabama | 1131 | 964 | 20 |
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);