ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

38,778 rows where state = "Alabama" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

fips

county

state

  • Alabama · 38,778 ✖
Link rowid date ▲ county state fips cases deaths
1842606 1842606 2021-10-23 Autauga Alabama 1001 10043 148
1842607 1842607 2021-10-23 Baldwin Alabama 1003 37245 552
1842608 1842608 2021-10-23 Barbour Alabama 1005 3577 76
1842609 1842609 2021-10-23 Bibb Alabama 1007 4251 86
1842610 1842610 2021-10-23 Blount Alabama 1009 10192 176
1842611 1842611 2021-10-23 Bullock Alabama 1011 1516 44
1842612 1842612 2021-10-23 Butler Alabama 1013 3263 96
1842613 1842613 2021-10-23 Calhoun Alabama 1015 22225 488
1842614 1842614 2021-10-23 Chambers Alabama 1017 5607 142
1842615 1842615 2021-10-23 Cherokee Alabama 1019 3028 60
1842616 1842616 2021-10-23 Chilton Alabama 1021 6641 162
1842617 1842617 2021-10-23 Choctaw Alabama 1023 885 27
1842618 1842618 2021-10-23 Clarke Alabama 1025 4755 84
1842619 1842619 2021-10-23 Clay Alabama 1027 2433 68
1842620 1842620 2021-10-23 Cleburne Alabama 1029 2477 60
1842621 1842621 2021-10-23 Coffee Alabama 1031 9210 191
1842622 1842622 2021-10-23 Colbert Alabama 1033 8860 201
1842623 1842623 2021-10-23 Conecuh Alabama 1035 1861 53
1842624 1842624 2021-10-23 Coosa Alabama 1037 1802 40
1842625 1842625 2021-10-23 Covington Alabama 1039 6712 183
1842626 1842626 2021-10-23 Crenshaw Alabama 1041 2452 75
1842627 1842627 2021-10-23 Cullman Alabama 1043 15443 293
1842628 1842628 2021-10-23 Dale Alabama 1045 8897 185
1842629 1842629 2021-10-23 Dallas Alabama 1047 4973 200
1842630 1842630 2021-10-23 DeKalb Alabama 1049 12649 261
1842631 1842631 2021-10-23 Elmore Alabama 1051 15241 286
1842632 1842632 2021-10-23 Escambia Alabama 1053 6772 134
1842633 1842633 2021-10-23 Etowah Alabama 1055 19825 500
1842634 1842634 2021-10-23 Fayette Alabama 1057 2928 80
1842635 1842635 2021-10-23 Franklin Alabama 1059 5959 105
1842636 1842636 2021-10-23 Geneva Alabama 1061 4571 127
1842637 1842637 2021-10-23 Greene Alabama 1063 1267 44
1842638 1842638 2021-10-23 Hale Alabama 1065 3113 88
1842639 1842639 2021-10-23 Henry Alabama 1067 3126 66
1842640 1842640 2021-10-23 Houston Alabama 1069 17384 412
1842641 1842641 2021-10-23 Jackson Alabama 1071 9871 184
1842642 1842642 2021-10-23 Jefferson Alabama 1073 114790 1924
1842643 1842643 2021-10-23 Lamar Alabama 1075 2241 47
1842644 1842644 2021-10-23 Lauderdale Alabama 1077 14302 295
1842645 1842645 2021-10-23 Lawrence Alabama 1079 4321 117
1842646 1842646 2021-10-23 Lee Alabama 1081 23526 246
1842647 1842647 2021-10-23 Limestone Alabama 1083 15343 199
1842648 1842648 2021-10-23 Lowndes Alabama 1085 1751 64
1842649 1842649 2021-10-23 Macon Alabama 1087 2346 63
1842650 1842650 2021-10-23 Madison Alabama 1089 52306 697
1842651 1842651 2021-10-23 Marengo Alabama 1091 3380 90
1842652 1842652 2021-10-23 Marion Alabama 1093 5005 127
1842653 1842653 2021-10-23 Marshall Alabama 1095 18361 304
1842654 1842654 2021-10-23 Mobile Alabama 1097 72579 1338
1842655 1842655 2021-10-23 Monroe Alabama 1099 3314 64
1842656 1842656 2021-10-23 Montgomery Alabama 1101 34106 740
1842657 1842657 2021-10-23 Morgan Alabama 1103 20941 378
1842658 1842658 2021-10-23 Perry Alabama 1105 1388 40
1842659 1842659 2021-10-23 Pickens Alabama 1107 3162 84
1842660 1842660 2021-10-23 Pike Alabama 1109 4795 106
1842661 1842661 2021-10-23 Randolph Alabama 1111 3297 64
1842662 1842662 2021-10-23 Russell Alabama 1113 6366 59
1842663 1842663 2021-10-23 Shelby Alabama 1117 37597 350
1842664 1842664 2021-10-23 St. Clair Alabama 1115 16054 339
1842665 1842665 2021-10-23 Sumter Alabama 1119 1330 38
1842666 1842666 2021-10-23 Talladega Alabama 1121 13836 283
1842667 1842667 2021-10-23 Tallapoosa Alabama 1123 7084 198
1842668 1842668 2021-10-23 Tuscaloosa Alabama 1125 35101 612
1842669 1842669 2021-10-23 Walker Alabama 1127 11202 370
1842670 1842670 2021-10-23 Washington Alabama 1129 2515 51
1842671 1842671 2021-10-23 Wilcox Alabama 1131 1688 39
1842672 1842672 2021-10-23 Winston Alabama 1133 4516 103
1839357 1839357 2021-10-22 Autauga Alabama 1001 9967 148
1839358 1839358 2021-10-22 Baldwin Alabama 1003 37224 549
1839359 1839359 2021-10-22 Barbour Alabama 1005 3575 76
1839360 1839360 2021-10-22 Bibb Alabama 1007 4246 86
1839361 1839361 2021-10-22 Blount Alabama 1009 10179 176
1839362 1839362 2021-10-22 Bullock Alabama 1011 1516 44
1839363 1839363 2021-10-22 Butler Alabama 1013 3258 96
1839364 1839364 2021-10-22 Calhoun Alabama 1015 22221 482
1839365 1839365 2021-10-22 Chambers Alabama 1017 5607 142
1839366 1839366 2021-10-22 Cherokee Alabama 1019 3023 60
1839367 1839367 2021-10-22 Chilton Alabama 1021 6633 161
1839368 1839368 2021-10-22 Choctaw Alabama 1023 882 27
1839369 1839369 2021-10-22 Clarke Alabama 1025 4754 84
1839370 1839370 2021-10-22 Clay Alabama 1027 2430 68
1839371 1839371 2021-10-22 Cleburne Alabama 1029 2474 60
1839372 1839372 2021-10-22 Coffee Alabama 1031 9205 191
1839373 1839373 2021-10-22 Colbert Alabama 1033 8840 201
1839374 1839374 2021-10-22 Conecuh Alabama 1035 1859 53
1839375 1839375 2021-10-22 Coosa Alabama 1037 1800 40
1839376 1839376 2021-10-22 Covington Alabama 1039 6706 183
1839377 1839377 2021-10-22 Crenshaw Alabama 1041 2448 75
1839378 1839378 2021-10-22 Cullman Alabama 1043 15406 293
1839379 1839379 2021-10-22 Dale Alabama 1045 8884 185
1839380 1839380 2021-10-22 Dallas Alabama 1047 4949 200
1839381 1839381 2021-10-22 DeKalb Alabama 1049 12637 261
1839382 1839382 2021-10-22 Elmore Alabama 1051 15186 286
1839383 1839383 2021-10-22 Escambia Alabama 1053 6766 132
1839384 1839384 2021-10-22 Etowah Alabama 1055 19816 498
1839385 1839385 2021-10-22 Fayette Alabama 1057 2923 79
1839386 1839386 2021-10-22 Franklin Alabama 1059 5959 105
1839387 1839387 2021-10-22 Geneva Alabama 1061 4568 127
1839388 1839388 2021-10-22 Greene Alabama 1063 1266 44
1839389 1839389 2021-10-22 Hale Alabama 1065 3111 88

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);