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
- Elmore 588
- Jefferson 588
- Limestone 588
- Montgomery 588
- Tuscaloosa 588
- Baldwin 587
- Lee 586
- Shelby 586
- Madison 584
- St. Clair 584
- Calhoun 583
- Talladega 583
- Chambers 582
- Mobile 582
- Walker 582
- Cullman 581
- Jackson 581
- Lamar 581
- Lauderdale 581
- Washington 581
- Marion 580
- Franklin 578
- Houston 578
- Tallapoosa 578
- Autauga 577
- Morgan 577
- Blount 576
- Butler 576
- Cherokee 576
- Chilton 576
- …
state 1
- Alabama · 38,644 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1836108 | 1836108 | 2021-10-21 | Autauga | Alabama | 1001 | 9954 | 146 |
1836109 | 1836109 | 2021-10-21 | Baldwin | Alabama | 1003 | 37192 | 547 |
1836110 | 1836110 | 2021-10-21 | Barbour | Alabama | 1005 | 3566 | 76 |
1836111 | 1836111 | 2021-10-21 | Bibb | Alabama | 1007 | 4240 | 86 |
1836112 | 1836112 | 2021-10-21 | Blount | Alabama | 1009 | 10162 | 175 |
1836113 | 1836113 | 2021-10-21 | Bullock | Alabama | 1011 | 1516 | 44 |
1836114 | 1836114 | 2021-10-21 | Butler | Alabama | 1013 | 3256 | 96 |
1836115 | 1836115 | 2021-10-21 | Calhoun | Alabama | 1015 | 22205 | 476 |
1836116 | 1836116 | 2021-10-21 | Chambers | Alabama | 1017 | 5567 | 142 |
1836117 | 1836117 | 2021-10-21 | Cherokee | Alabama | 1019 | 3017 | 60 |
1836118 | 1836118 | 2021-10-21 | Chilton | Alabama | 1021 | 6627 | 161 |
1836119 | 1836119 | 2021-10-21 | Choctaw | Alabama | 1023 | 881 | 27 |
1836120 | 1836120 | 2021-10-21 | Clarke | Alabama | 1025 | 4745 | 83 |
1836121 | 1836121 | 2021-10-21 | Clay | Alabama | 1027 | 2417 | 68 |
1836122 | 1836122 | 2021-10-21 | Cleburne | Alabama | 1029 | 2473 | 60 |
1836123 | 1836123 | 2021-10-21 | Coffee | Alabama | 1031 | 9195 | 191 |
1836124 | 1836124 | 2021-10-21 | Colbert | Alabama | 1033 | 8826 | 201 |
1836125 | 1836125 | 2021-10-21 | Conecuh | Alabama | 1035 | 1858 | 53 |
1836126 | 1836126 | 2021-10-21 | Coosa | Alabama | 1037 | 1797 | 39 |
1836127 | 1836127 | 2021-10-21 | Covington | Alabama | 1039 | 6699 | 183 |
1836128 | 1836128 | 2021-10-21 | Crenshaw | Alabama | 1041 | 2443 | 75 |
1836129 | 1836129 | 2021-10-21 | Cullman | Alabama | 1043 | 15383 | 292 |
1836130 | 1836130 | 2021-10-21 | Dale | Alabama | 1045 | 8880 | 185 |
1836131 | 1836131 | 2021-10-21 | Dallas | Alabama | 1047 | 4936 | 200 |
1836132 | 1836132 | 2021-10-21 | DeKalb | Alabama | 1049 | 12622 | 260 |
1836133 | 1836133 | 2021-10-21 | Elmore | Alabama | 1051 | 15161 | 284 |
1836134 | 1836134 | 2021-10-21 | Escambia | Alabama | 1053 | 6764 | 130 |
1836135 | 1836135 | 2021-10-21 | Etowah | Alabama | 1055 | 19811 | 497 |
1836136 | 1836136 | 2021-10-21 | Fayette | Alabama | 1057 | 2918 | 79 |
1836137 | 1836137 | 2021-10-21 | Franklin | Alabama | 1059 | 5955 | 105 |
1836138 | 1836138 | 2021-10-21 | Geneva | Alabama | 1061 | 4566 | 126 |
1836139 | 1836139 | 2021-10-21 | Greene | Alabama | 1063 | 1266 | 44 |
1836140 | 1836140 | 2021-10-21 | Hale | Alabama | 1065 | 3110 | 88 |
1836141 | 1836141 | 2021-10-21 | Henry | Alabama | 1067 | 3119 | 65 |
1836142 | 1836142 | 2021-10-21 | Houston | Alabama | 1069 | 17345 | 411 |
1836143 | 1836143 | 2021-10-21 | Jackson | Alabama | 1071 | 9844 | 182 |
1836144 | 1836144 | 2021-10-21 | Jefferson | Alabama | 1073 | 114550 | 1922 |
1836145 | 1836145 | 2021-10-21 | Lamar | Alabama | 1075 | 2220 | 47 |
1836146 | 1836146 | 2021-10-21 | Lauderdale | Alabama | 1077 | 14225 | 294 |
1836147 | 1836147 | 2021-10-21 | Lawrence | Alabama | 1079 | 4296 | 117 |
1836148 | 1836148 | 2021-10-21 | Lee | Alabama | 1081 | 23195 | 245 |
1836149 | 1836149 | 2021-10-21 | Limestone | Alabama | 1083 | 15298 | 198 |
1836150 | 1836150 | 2021-10-21 | Lowndes | Alabama | 1085 | 1745 | 64 |
1836151 | 1836151 | 2021-10-21 | Macon | Alabama | 1087 | 2323 | 63 |
1836152 | 1836152 | 2021-10-21 | Madison | Alabama | 1089 | 52172 | 694 |
1836153 | 1836153 | 2021-10-21 | Marengo | Alabama | 1091 | 3377 | 89 |
1836154 | 1836154 | 2021-10-21 | Marion | Alabama | 1093 | 4982 | 126 |
1836155 | 1836155 | 2021-10-21 | Marshall | Alabama | 1095 | 18317 | 302 |
1836156 | 1836156 | 2021-10-21 | Mobile | Alabama | 1097 | 72460 | 1333 |
1836157 | 1836157 | 2021-10-21 | Monroe | Alabama | 1099 | 3314 | 63 |
1836158 | 1836158 | 2021-10-21 | Montgomery | Alabama | 1101 | 34067 | 734 |
1836159 | 1836159 | 2021-10-21 | Morgan | Alabama | 1103 | 20754 | 376 |
1836160 | 1836160 | 2021-10-21 | Perry | Alabama | 1105 | 1383 | 40 |
1836161 | 1836161 | 2021-10-21 | Pickens | Alabama | 1107 | 3156 | 82 |
1836162 | 1836162 | 2021-10-21 | Pike | Alabama | 1109 | 4722 | 105 |
1836163 | 1836163 | 2021-10-21 | Randolph | Alabama | 1111 | 3287 | 63 |
1836164 | 1836164 | 2021-10-21 | Russell | Alabama | 1113 | 6279 | 59 |
1836165 | 1836165 | 2021-10-21 | Shelby | Alabama | 1117 | 37533 | 348 |
1836166 | 1836166 | 2021-10-21 | St. Clair | Alabama | 1115 | 15983 | 339 |
1836167 | 1836167 | 2021-10-21 | Sumter | Alabama | 1119 | 1327 | 38 |
1836168 | 1836168 | 2021-10-21 | Talladega | Alabama | 1121 | 13802 | 276 |
1836169 | 1836169 | 2021-10-21 | Tallapoosa | Alabama | 1123 | 7071 | 198 |
1836170 | 1836170 | 2021-10-21 | Tuscaloosa | Alabama | 1125 | 35044 | 606 |
1836171 | 1836171 | 2021-10-21 | Walker | Alabama | 1127 | 11162 | 369 |
1836172 | 1836172 | 2021-10-21 | Washington | Alabama | 1129 | 2513 | 51 |
1836173 | 1836173 | 2021-10-21 | Wilcox | Alabama | 1131 | 1679 | 39 |
1836174 | 1836174 | 2021-10-21 | Winston | Alabama | 1133 | 4502 | 103 |
1832859 | 1832859 | 2021-10-20 | Autauga | Alabama | 1001 | 9910 | 146 |
1832860 | 1832860 | 2021-10-20 | Baldwin | Alabama | 1003 | 37167 | 547 |
1832861 | 1832861 | 2021-10-20 | Barbour | Alabama | 1005 | 3565 | 76 |
1832862 | 1832862 | 2021-10-20 | Bibb | Alabama | 1007 | 4236 | 86 |
1832863 | 1832863 | 2021-10-20 | Blount | Alabama | 1009 | 10132 | 175 |
1832864 | 1832864 | 2021-10-20 | Bullock | Alabama | 1011 | 1516 | 44 |
1832865 | 1832865 | 2021-10-20 | Butler | Alabama | 1013 | 3253 | 96 |
1832866 | 1832866 | 2021-10-20 | Calhoun | Alabama | 1015 | 22190 | 476 |
1832867 | 1832867 | 2021-10-20 | Chambers | Alabama | 1017 | 5563 | 142 |
1832868 | 1832868 | 2021-10-20 | Cherokee | Alabama | 1019 | 3016 | 60 |
1832869 | 1832869 | 2021-10-20 | Chilton | Alabama | 1021 | 6608 | 161 |
1832870 | 1832870 | 2021-10-20 | Choctaw | Alabama | 1023 | 878 | 27 |
1832871 | 1832871 | 2021-10-20 | Clarke | Alabama | 1025 | 4740 | 83 |
1832872 | 1832872 | 2021-10-20 | Clay | Alabama | 1027 | 2412 | 68 |
1832873 | 1832873 | 2021-10-20 | Cleburne | Alabama | 1029 | 2471 | 60 |
1832874 | 1832874 | 2021-10-20 | Coffee | Alabama | 1031 | 9190 | 191 |
1832875 | 1832875 | 2021-10-20 | Colbert | Alabama | 1033 | 8803 | 201 |
1832876 | 1832876 | 2021-10-20 | Conecuh | Alabama | 1035 | 1857 | 53 |
1832877 | 1832877 | 2021-10-20 | Coosa | Alabama | 1037 | 1794 | 39 |
1832878 | 1832878 | 2021-10-20 | Covington | Alabama | 1039 | 6695 | 184 |
1832879 | 1832879 | 2021-10-20 | Crenshaw | Alabama | 1041 | 2440 | 75 |
1832880 | 1832880 | 2021-10-20 | Cullman | Alabama | 1043 | 15365 | 292 |
1832881 | 1832881 | 2021-10-20 | Dale | Alabama | 1045 | 8874 | 185 |
1832882 | 1832882 | 2021-10-20 | Dallas | Alabama | 1047 | 4902 | 200 |
1832883 | 1832883 | 2021-10-20 | DeKalb | Alabama | 1049 | 12598 | 260 |
1832884 | 1832884 | 2021-10-20 | Elmore | Alabama | 1051 | 15126 | 284 |
1832885 | 1832885 | 2021-10-20 | Escambia | Alabama | 1053 | 6755 | 130 |
1832886 | 1832886 | 2021-10-20 | Etowah | Alabama | 1055 | 19774 | 497 |
1832887 | 1832887 | 2021-10-20 | Fayette | Alabama | 1057 | 2913 | 79 |
1832888 | 1832888 | 2021-10-20 | Franklin | Alabama | 1059 | 5947 | 105 |
1832889 | 1832889 | 2021-10-20 | Geneva | Alabama | 1061 | 4567 | 126 |
1832890 | 1832890 | 2021-10-20 | Greene | Alabama | 1063 | 1262 | 44 |
1832891 | 1832891 | 2021-10-20 | Hale | Alabama | 1065 | 3106 | 88 |
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);