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

52,312 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 >30

county >30

state 1

  • Alabama · 52,312 ✖
Link rowid date ▲ county state fips cases deaths
2499575 2499575 2022-05-13 Autauga Alabama 1001 15863 216
2499576 2499576 2022-05-13 Baldwin Alabama 1003 55862 681
2499577 2499577 2022-05-13 Barbour Alabama 1005 5681 98
2499578 2499578 2022-05-13 Bibb Alabama 1007 6457 105
2499579 2499579 2022-05-13 Blount Alabama 1009 15005 243
2499580 2499580 2022-05-13 Bullock Alabama 1011 2319 54
2499581 2499581 2022-05-13 Butler Alabama 1013 5068 129
2499582 2499582 2022-05-13 Calhoun Alabama 1015 32453 627
2499583 2499583 2022-05-13 Chambers Alabama 1017 8508 162
2499584 2499584 2022-05-13 Cherokee Alabama 1019 5131 86
2499585 2499585 2022-05-13 Chilton Alabama 1021 11131 207
2499586 2499586 2022-05-13 Choctaw Alabama 1023 2051 36
2499587 2499587 2022-05-13 Clarke Alabama 1025 7154 101
2499588 2499588 2022-05-13 Clay Alabama 1027 4099 82
2499589 2499589 2022-05-13 Cleburne Alabama 1029 3566 69
2499590 2499590 2022-05-13 Coffee Alabama 1031 13643 231
2499591 2499591 2022-05-13 Colbert Alabama 1033 16356 261
2499592 2499592 2022-05-13 Conecuh Alabama 1035 2869 70
2499593 2499593 2022-05-13 Coosa Alabama 1037 2977 58
2499594 2499594 2022-05-13 Covington Alabama 1039 9355 232
2499595 2499595 2022-05-13 Crenshaw Alabama 1041 3834 100
2499596 2499596 2022-05-13 Cullman Alabama 1043 24649 367
2499597 2499597 2022-05-13 Dale Alabama 1045 12947 231
2499598 2499598 2022-05-13 Dallas Alabama 1047 8429 244
2499599 2499599 2022-05-13 DeKalb Alabama 1049 18799 330
2499600 2499600 2022-05-13 Elmore Alabama 1051 23420 347
2499601 2499601 2022-05-13 Escambia Alabama 1053 10081 171
2499602 2499602 2022-05-13 Etowah Alabama 1055 28779 651
2499603 2499603 2022-05-13 Fayette Alabama 1057 4986 96
2499604 2499604 2022-05-13 Franklin Alabama 1059 9903 139
2499605 2499605 2022-05-13 Geneva Alabama 1061 6494 164
2499606 2499606 2022-05-13 Greene Alabama 1063 1877 49
2499607 2499607 2022-05-13 Hale Alabama 1065 4741 106
2499608 2499608 2022-05-13 Henry Alabama 1067 4584 76
2499609 2499609 2022-05-13 Houston Alabama 1069 25800 506
2499610 2499610 2022-05-13 Jackson Alabama 1071 15049 241
2499611 2499611 2022-05-13 Jefferson Alabama 1073 185930 2373
2499612 2499612 2022-05-13 Lamar Alabama 1075 3745 65
2499613 2499613 2022-05-13 Lauderdale Alabama 1077 24193 397
2499614 2499614 2022-05-13 Lawrence Alabama 1079 7682 160
2499615 2499615 2022-05-13 Lee Alabama 1081 37888 341
2499616 2499616 2022-05-13 Limestone Alabama 1083 25065 293
2499617 2499617 2022-05-13 Lowndes Alabama 1085 2628 77
2499618 2499618 2022-05-13 Macon Alabama 1087 3885 85
2499619 2499619 2022-05-13 Madison Alabama 1089 90395 968
2499620 2499620 2022-05-13 Marengo Alabama 1091 5196 108
2499621 2499621 2022-05-13 Marion Alabama 1093 8157 152
2499622 2499622 2022-05-13 Marshall Alabama 1095 27438 394
2499623 2499623 2022-05-13 Mobile Alabama 1097 113300 1653
2499624 2499624 2022-05-13 Monroe Alabama 1099 5276 80
2499625 2499625 2022-05-13 Montgomery Alabama 1101 55316 948
2499626 2499626 2022-05-13 Morgan Alabama 1103 36167 518
2499627 2499627 2022-05-13 Perry Alabama 1105 2096 47
2499628 2499628 2022-05-13 Pickens Alabama 1107 5271 102
2499629 2499629 2022-05-13 Pike Alabama 1109 7590 134
2499630 2499630 2022-05-13 Randolph Alabama 1111 5085 75
2499631 2499631 2022-05-13 Russell Alabama 1113 10112 93
2499632 2499632 2022-05-13 Shelby Alabama 1117 61273 452
2499633 2499633 2022-05-13 St. Clair Alabama 1115 25395 416
2499634 2499634 2022-05-13 Sumter Alabama 1119 2594 51
2499635 2499635 2022-05-13 Talladega Alabama 1121 22396 377
2499636 2499636 2022-05-13 Tallapoosa Alabama 1123 11445 234
2499637 2499637 2022-05-13 Tuscaloosa Alabama 1125 56301 786
2499638 2499638 2022-05-13 Walker Alabama 1127 18767 447
2499639 2499639 2022-05-13 Washington Alabama 1129 3736 59
2499640 2499640 2022-05-13 Wilcox Alabama 1131 2892 46
2499641 2499641 2022-05-13 Winston Alabama 1133 7576 131
2496317 2496317 2022-05-12 Autauga Alabama 1001 15860 216
2496318 2496318 2022-05-12 Baldwin Alabama 1003 55831 680
2496319 2496319 2022-05-12 Barbour Alabama 1005 5678 98
2496320 2496320 2022-05-12 Bibb Alabama 1007 6455 105
2496321 2496321 2022-05-12 Blount Alabama 1009 15004 243
2496322 2496322 2022-05-12 Bullock Alabama 1011 2318 54
2496323 2496323 2022-05-12 Butler Alabama 1013 5068 129
2496324 2496324 2022-05-12 Calhoun Alabama 1015 32451 627
2496325 2496325 2022-05-12 Chambers Alabama 1017 8506 162
2496326 2496326 2022-05-12 Cherokee Alabama 1019 5131 86
2496327 2496327 2022-05-12 Chilton Alabama 1021 11128 207
2496328 2496328 2022-05-12 Choctaw Alabama 1023 2050 36
2496329 2496329 2022-05-12 Clarke Alabama 1025 7152 101
2496330 2496330 2022-05-12 Clay Alabama 1027 4097 82
2496331 2496331 2022-05-12 Cleburne Alabama 1029 3564 69
2496332 2496332 2022-05-12 Coffee Alabama 1031 13638 231
2496333 2496333 2022-05-12 Colbert Alabama 1033 16354 261
2496334 2496334 2022-05-12 Conecuh Alabama 1035 2869 70
2496335 2496335 2022-05-12 Coosa Alabama 1037 2975 58
2496336 2496336 2022-05-12 Covington Alabama 1039 9354 232
2496337 2496337 2022-05-12 Crenshaw Alabama 1041 3834 100
2496338 2496338 2022-05-12 Cullman Alabama 1043 24645 367
2496339 2496339 2022-05-12 Dale Alabama 1045 12939 231
2496340 2496340 2022-05-12 Dallas Alabama 1047 8428 244
2496341 2496341 2022-05-12 DeKalb Alabama 1049 18794 329
2496342 2496342 2022-05-12 Elmore Alabama 1051 23419 347
2496343 2496343 2022-05-12 Escambia Alabama 1053 10076 171
2496344 2496344 2022-05-12 Etowah Alabama 1055 28780 651
2496345 2496345 2022-05-12 Fayette Alabama 1057 4983 96
2496346 2496346 2022-05-12 Franklin Alabama 1059 9901 139
2496347 2496347 2022-05-12 Geneva Alabama 1061 6491 164
2496348 2496348 2022-05-12 Greene Alabama 1063 1876 49
2496349 2496349 2022-05-12 Hale Alabama 1065 4741 106

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