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 67
- 1051 550
- 1073 550
- 1083 550
- 1101 550
- 1125 550
- 1003 549
- 1081 548
- 1117 548
- 1089 546
- 1115 546
- 1015 545
- 1121 545
- 1017 544
- 1097 544
- 1127 544
- 1043 543
- 1071 543
- 1075 543
- 1077 543
- 1129 543
- 1093 542
- 1059 540
- 1069 540
- 1123 540
- 1001 539
- 1103 539
- 1009 538
- 1013 538
- 1019 538
- 1021 538
- 1027 538
- 1029 538
- 1033 538
- 1047 538
- 1055 538
- 1079 538
- 1095 538
- 1107 538
- 1109 538
- 1113 538
- 1131 538
- 1011 537
- 1023 537
- 1037 537
- 1041 537
- 1049 537
- 1085 537
- 1091 537
- 1039 536
- 1053 536
- 1063 536
- 1111 536
- 1133 536
- 1099 535
- 1087 534
- 1007 533
- 1057 533
- 1065 533
- 1119 533
- 1025 531
- 1035 531
- 1045 531
- 1031 530
- 1005 529
- 1067 529
- 1105 523
- 1061 520
county 67
- Elmore 550
- Jefferson 550
- Limestone 550
- Montgomery 550
- Tuscaloosa 550
- Baldwin 549
- Lee 548
- Shelby 548
- Madison 546
- St. Clair 546
- Calhoun 545
- Talladega 545
- Chambers 544
- Mobile 544
- Walker 544
- Cullman 543
- Jackson 543
- Lamar 543
- Lauderdale 543
- Washington 543
- Marion 542
- Franklin 540
- Houston 540
- Tallapoosa 540
- Autauga 539
- Morgan 539
- Blount 538
- Butler 538
- Cherokee 538
- Chilton 538
- Clay 538
- Cleburne 538
- Colbert 538
- Dallas 538
- Etowah 538
- Lawrence 538
- Marshall 538
- Pickens 538
- Pike 538
- Russell 538
- Wilcox 538
- Bullock 537
- Choctaw 537
- Coosa 537
- Crenshaw 537
- DeKalb 537
- Lowndes 537
- Marengo 537
- Covington 536
- Escambia 536
- Greene 536
- Randolph 536
- Winston 536
- Monroe 535
- Macon 534
- Bibb 533
- Fayette 533
- Hale 533
- Sumter 533
- Clarke 531
- Conecuh 531
- Dale 531
- Coffee 530
- Barbour 529
- Henry 529
- Perry 523
- Geneva 520
state 1
- Alabama · 36,098 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1712647 | 1712647 | 2021-09-13 | Autauga | Alabama | 1001 | 9317 | 119 |
1712648 | 1712648 | 2021-09-13 | Baldwin | Alabama | 1003 | 35039 | 412 |
1712649 | 1712649 | 2021-09-13 | Barbour | Alabama | 1005 | 3315 | 67 |
1712650 | 1712650 | 2021-09-13 | Bibb | Alabama | 1007 | 3821 | 75 |
1712651 | 1712651 | 2021-09-13 | Blount | Alabama | 1009 | 9199 | 146 |
1712652 | 1712652 | 2021-09-13 | Bullock | Alabama | 1011 | 1442 | 42 |
1712653 | 1712653 | 2021-09-13 | Butler | Alabama | 1013 | 3024 | 77 |
1712654 | 1712654 | 2021-09-13 | Calhoun | Alabama | 1015 | 19359 | 363 |
1712655 | 1712655 | 2021-09-13 | Chambers | Alabama | 1017 | 5084 | 127 |
1712656 | 1712656 | 2021-09-13 | Cherokee | Alabama | 1019 | 2714 | 49 |
1712657 | 1712657 | 2021-09-13 | Chilton | Alabama | 1021 | 6100 | 127 |
1712658 | 1712658 | 2021-09-13 | Choctaw | Alabama | 1023 | 713 | 25 |
1712659 | 1712659 | 2021-09-13 | Clarke | Alabama | 1025 | 4424 | 68 |
1712660 | 1712660 | 2021-09-13 | Clay | Alabama | 1027 | 2159 | 60 |
1712661 | 1712661 | 2021-09-13 | Cleburne | Alabama | 1029 | 2042 | 46 |
1712662 | 1712662 | 2021-09-13 | Coffee | Alabama | 1031 | 8468 | 149 |
1712663 | 1712663 | 2021-09-13 | Colbert | Alabama | 1033 | 8142 | 159 |
1712664 | 1712664 | 2021-09-13 | Conecuh | Alabama | 1035 | 1712 | 37 |
1712665 | 1712665 | 2021-09-13 | Coosa | Alabama | 1037 | 1564 | 31 |
1712666 | 1712666 | 2021-09-13 | Covington | Alabama | 1039 | 6133 | 153 |
1712667 | 1712667 | 2021-09-13 | Crenshaw | Alabama | 1041 | 2244 | 62 |
1712668 | 1712668 | 2021-09-13 | Cullman | Alabama | 1043 | 13566 | 226 |
1712669 | 1712669 | 2021-09-13 | Dale | Alabama | 1045 | 8069 | 141 |
1712670 | 1712670 | 2021-09-13 | Dallas | Alabama | 1047 | 4546 | 173 |
1712671 | 1712671 | 2021-09-13 | DeKalb | Alabama | 1049 | 11568 | 220 |
1712672 | 1712672 | 2021-09-13 | Elmore | Alabama | 1051 | 13694 | 239 |
1712673 | 1712673 | 2021-09-13 | Escambia | Alabama | 1053 | 6228 | 97 |
1712674 | 1712674 | 2021-09-13 | Etowah | Alabama | 1055 | 18201 | 410 |
1712675 | 1712675 | 2021-09-13 | Fayette | Alabama | 1057 | 2662 | 67 |
1712676 | 1712676 | 2021-09-13 | Franklin | Alabama | 1059 | 5539 | 92 |
1712677 | 1712677 | 2021-09-13 | Geneva | Alabama | 1061 | 4089 | 98 |
1712678 | 1712678 | 2021-09-13 | Greene | Alabama | 1063 | 1174 | 41 |
1712679 | 1712679 | 2021-09-13 | Hale | Alabama | 1065 | 2806 | 81 |
1712680 | 1712680 | 2021-09-13 | Henry | Alabama | 1067 | 2854 | 50 |
1712681 | 1712681 | 2021-09-13 | Houston | Alabama | 1069 | 15732 | 331 |
1712682 | 1712682 | 2021-09-13 | Jackson | Alabama | 1071 | 8834 | 132 |
1712683 | 1712683 | 2021-09-13 | Jefferson | Alabama | 1073 | 107467 | 1701 |
1712684 | 1712684 | 2021-09-13 | Lamar | Alabama | 1075 | 1827 | 38 |
1712685 | 1712685 | 2021-09-13 | Lauderdale | Alabama | 1077 | 12734 | 263 |
1712686 | 1712686 | 2021-09-13 | Lawrence | Alabama | 1079 | 3976 | 101 |
1712687 | 1712687 | 2021-09-13 | Lee | Alabama | 1081 | 21353 | 199 |
1712688 | 1712688 | 2021-09-13 | Limestone | Alabama | 1083 | 13682 | 176 |
1712689 | 1712689 | 2021-09-13 | Lowndes | Alabama | 1085 | 1664 | 55 |
1712690 | 1712690 | 2021-09-13 | Macon | Alabama | 1087 | 2091 | 54 |
1712691 | 1712691 | 2021-09-13 | Madison | Alabama | 1089 | 47216 | 560 |
1712692 | 1712692 | 2021-09-13 | Marengo | Alabama | 1091 | 3157 | 76 |
1712693 | 1712693 | 2021-09-13 | Marion | Alabama | 1093 | 4438 | 113 |
1712694 | 1712694 | 2021-09-13 | Marshall | Alabama | 1095 | 16790 | 250 |
1712695 | 1712695 | 2021-09-13 | Mobile | Alabama | 1097 | 69037 | 1126 |
1712696 | 1712696 | 2021-09-13 | Monroe | Alabama | 1099 | 3031 | 44 |
1712697 | 1712697 | 2021-09-13 | Montgomery | Alabama | 1101 | 32012 | 643 |
1712698 | 1712698 | 2021-09-13 | Morgan | Alabama | 1103 | 18881 | 307 |
1712699 | 1712699 | 2021-09-13 | Perry | Alabama | 1105 | 1320 | 30 |
1712700 | 1712700 | 2021-09-13 | Pickens | Alabama | 1107 | 2920 | 65 |
1712701 | 1712701 | 2021-09-13 | Pike | Alabama | 1109 | 4315 | 87 |
1712702 | 1712702 | 2021-09-13 | Randolph | Alabama | 1111 | 2832 | 55 |
1712703 | 1712703 | 2021-09-13 | Russell | Alabama | 1113 | 5821 | 51 |
1712704 | 1712704 | 2021-09-13 | Shelby | Alabama | 1117 | 34429 | 280 |
1712705 | 1712705 | 2021-09-13 | St. Clair | Alabama | 1115 | 14539 | 267 |
1712706 | 1712706 | 2021-09-13 | Sumter | Alabama | 1119 | 1224 | 35 |
1712707 | 1712707 | 2021-09-13 | Talladega | Alabama | 1121 | 11886 | 197 |
1712708 | 1712708 | 2021-09-13 | Tallapoosa | Alabama | 1123 | 6149 | 163 |
1712709 | 1712709 | 2021-09-13 | Tuscaloosa | Alabama | 1125 | 32196 | 491 |
1712710 | 1712710 | 2021-09-13 | Walker | Alabama | 1127 | 9886 | 302 |
1712711 | 1712711 | 2021-09-13 | Washington | Alabama | 1129 | 2392 | 43 |
1712712 | 1712712 | 2021-09-13 | Wilcox | Alabama | 1131 | 1519 | 33 |
1712713 | 1712713 | 2021-09-13 | Winston | Alabama | 1133 | 3937 | 81 |
1709400 | 1709400 | 2021-09-12 | Autauga | Alabama | 1001 | 9287 | 119 |
1709401 | 1709401 | 2021-09-12 | Baldwin | Alabama | 1003 | 34950 | 412 |
1709402 | 1709402 | 2021-09-12 | Barbour | Alabama | 1005 | 3295 | 67 |
1709403 | 1709403 | 2021-09-12 | Bibb | Alabama | 1007 | 3795 | 75 |
1709404 | 1709404 | 2021-09-12 | Blount | Alabama | 1009 | 9176 | 146 |
1709405 | 1709405 | 2021-09-12 | Bullock | Alabama | 1011 | 1441 | 42 |
1709406 | 1709406 | 2021-09-12 | Butler | Alabama | 1013 | 3012 | 77 |
1709407 | 1709407 | 2021-09-12 | Calhoun | Alabama | 1015 | 19273 | 363 |
1709408 | 1709408 | 2021-09-12 | Chambers | Alabama | 1017 | 5062 | 127 |
1709409 | 1709409 | 2021-09-12 | Cherokee | Alabama | 1019 | 2703 | 49 |
1709410 | 1709410 | 2021-09-12 | Chilton | Alabama | 1021 | 6063 | 127 |
1709411 | 1709411 | 2021-09-12 | Choctaw | Alabama | 1023 | 712 | 25 |
1709412 | 1709412 | 2021-09-12 | Clarke | Alabama | 1025 | 4417 | 68 |
1709413 | 1709413 | 2021-09-12 | Clay | Alabama | 1027 | 2148 | 60 |
1709414 | 1709414 | 2021-09-12 | Cleburne | Alabama | 1029 | 2030 | 46 |
1709415 | 1709415 | 2021-09-12 | Coffee | Alabama | 1031 | 8445 | 149 |
1709416 | 1709416 | 2021-09-12 | Colbert | Alabama | 1033 | 8115 | 159 |
1709417 | 1709417 | 2021-09-12 | Conecuh | Alabama | 1035 | 1699 | 37 |
1709418 | 1709418 | 2021-09-12 | Coosa | Alabama | 1037 | 1551 | 31 |
1709419 | 1709419 | 2021-09-12 | Covington | Alabama | 1039 | 6115 | 153 |
1709420 | 1709420 | 2021-09-12 | Crenshaw | Alabama | 1041 | 2239 | 62 |
1709421 | 1709421 | 2021-09-12 | Cullman | Alabama | 1043 | 13465 | 226 |
1709422 | 1709422 | 2021-09-12 | Dale | Alabama | 1045 | 8034 | 141 |
1709423 | 1709423 | 2021-09-12 | Dallas | Alabama | 1047 | 4532 | 173 |
1709424 | 1709424 | 2021-09-12 | DeKalb | Alabama | 1049 | 11550 | 220 |
1709425 | 1709425 | 2021-09-12 | Elmore | Alabama | 1051 | 13636 | 239 |
1709426 | 1709426 | 2021-09-12 | Escambia | Alabama | 1053 | 6202 | 97 |
1709427 | 1709427 | 2021-09-12 | Etowah | Alabama | 1055 | 18169 | 410 |
1709428 | 1709428 | 2021-09-12 | Fayette | Alabama | 1057 | 2648 | 67 |
1709429 | 1709429 | 2021-09-12 | Franklin | Alabama | 1059 | 5532 | 92 |
1709430 | 1709430 | 2021-09-12 | Geneva | Alabama | 1061 | 4075 | 98 |
1709431 | 1709431 | 2021-09-12 | Greene | Alabama | 1063 | 1173 | 41 |
1709432 | 1709432 | 2021-09-12 | Hale | Alabama | 1065 | 2800 | 81 |
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);