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

23,100 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 · 23,100 ✖
Link rowid date ▲ county state fips cases deaths
1082716 1082716 2021-03-03 Autauga Alabama 1001 6313 91
1082717 1082717 2021-03-03 Baldwin Alabama 1003 19856 285
1082718 1082718 2021-03-03 Barbour Alabama 1005 2129 51
1082719 1082719 2021-03-03 Bibb Alabama 1007 2459 60
1082720 1082720 2021-03-03 Blount Alabama 1009 6229 127
1082721 1082721 2021-03-03 Bullock Alabama 1011 1172 36
1082722 1082722 2021-03-03 Butler Alabama 1013 2011 66
1082723 1082723 2021-03-03 Calhoun Alabama 1015 13755 288
1082724 1082724 2021-03-03 Chambers Alabama 1017 3423 111
1082725 1082725 2021-03-03 Cherokee Alabama 1019 1777 39
1082726 1082726 2021-03-03 Chilton Alabama 1021 3891 100
1082727 1082727 2021-03-03 Choctaw Alabama 1023 551 23
1082728 1082728 2021-03-03 Clarke Alabama 1025 3439 53
1082729 1082729 2021-03-03 Clay Alabama 1027 1455 54
1082730 1082730 2021-03-03 Cleburne Alabama 1029 1397 41
1082731 1082731 2021-03-03 Coffee Alabama 1031 5259 103
1082732 1082732 2021-03-03 Colbert Alabama 1033 5998 120
1082733 1082733 2021-03-03 Conecuh Alabama 1035 1070 24
1082734 1082734 2021-03-03 Coosa Alabama 1037 896 24
1082735 1082735 2021-03-03 Covington Alabama 1039 3989 106
1082736 1082736 2021-03-03 Crenshaw Alabama 1041 1462 54
1082737 1082737 2021-03-03 Cullman Alabama 1043 8979 182
1082738 1082738 2021-03-03 Dale Alabama 1045 4657 107
1082739 1082739 2021-03-03 Dallas Alabama 1047 3419 142
1082740 1082740 2021-03-03 DeKalb Alabama 1049 8486 175
1082741 1082741 2021-03-03 Elmore Alabama 1051 9451 185
1082742 1082742 2021-03-03 Escambia Alabama 1053 3787 72
1082743 1082743 2021-03-03 Etowah Alabama 1055 13379 320
1082744 1082744 2021-03-03 Fayette Alabama 1057 2013 57
1082745 1082745 2021-03-03 Franklin Alabama 1059 3997 78
1082746 1082746 2021-03-03 Geneva Alabama 1061 2402 70
1082747 1082747 2021-03-03 Greene Alabama 1063 885 32
1082748 1082748 2021-03-03 Hale Alabama 1065 2119 69
1082749 1082749 2021-03-03 Henry Alabama 1067 1829 41
1082750 1082750 2021-03-03 Houston Alabama 1069 10110 262
1082751 1082751 2021-03-03 Jackson Alabama 1071 6542 103
1082752 1082752 2021-03-03 Jefferson Alabama 1073 71400 1387
1082753 1082753 2021-03-03 Lamar Alabama 1075 1337 33
1082754 1082754 2021-03-03 Lauderdale Alabama 1077 8610 212
1082755 1082755 2021-03-03 Lawrence Alabama 1079 2846 83
1082756 1082756 2021-03-03 Lee Alabama 1081 15021 155
1082757 1082757 2021-03-03 Limestone Alabama 1083 9413 136
1082758 1082758 2021-03-03 Lowndes Alabama 1085 1325 51
1082759 1082759 2021-03-03 Macon Alabama 1087 1472 43
1082760 1082760 2021-03-03 Madison Alabama 1089 32573 462
1082761 1082761 2021-03-03 Marengo Alabama 1091 2383 57
1082762 1082762 2021-03-03 Marion Alabama 1093 2888 95
1082763 1082763 2021-03-03 Marshall Alabama 1095 11439 210
1082764 1082764 2021-03-03 Mobile Alabama 1097 36252 736
1082765 1082765 2021-03-03 Monroe Alabama 1099 1666 39
1082766 1082766 2021-03-03 Montgomery Alabama 1101 22708 519
1082767 1082767 2021-03-03 Morgan Alabama 1103 13742 252
1082768 1082768 2021-03-03 Perry Alabama 1105 1059 27
1082769 1082769 2021-03-03 Pickens Alabama 1107 2250 55
1082770 1082770 2021-03-03 Pike Alabama 1109 2933 72
1082771 1082771 2021-03-03 Randolph Alabama 1111 1646 40
1082772 1082772 2021-03-03 Russell Alabama 1113 4064 33
1082773 1082773 2021-03-03 Shelby Alabama 1117 22112 215
1082774 1082774 2021-03-03 St. Clair Alabama 1115 9003 225
1082775 1082775 2021-03-03 Sumter Alabama 1119 994 32
1082776 1082776 2021-03-03 Talladega Alabama 1121 7582 165
1082777 1082777 2021-03-03 Tallapoosa Alabama 1123 3613 143
1082778 1082778 2021-03-03 Tuscaloosa Alabama 1125 24289 414
1082779 1082779 2021-03-03 Walker Alabama 1127 6571 259
1082780 1082780 2021-03-03 Washington Alabama 1129 1566 35
1082781 1082781 2021-03-03 Wilcox Alabama 1131 1225 25
1082782 1082782 2021-03-03 Winston Alabama 1133 2586 68
1079470 1079470 2021-03-02 Autauga Alabama 1001 6303 91
1079471 1079471 2021-03-02 Baldwin Alabama 1003 19790 284
1079472 1079472 2021-03-02 Barbour Alabama 1005 2124 51
1079473 1079473 2021-03-02 Bibb Alabama 1007 2454 60
1079474 1079474 2021-03-02 Blount Alabama 1009 6106 127
1079475 1079475 2021-03-02 Bullock Alabama 1011 1171 36
1079476 1079476 2021-03-02 Butler Alabama 1013 1975 66
1079477 1079477 2021-03-02 Calhoun Alabama 1015 13307 287
1079478 1079478 2021-03-02 Chambers Alabama 1017 3421 111
1079479 1079479 2021-03-02 Cherokee Alabama 1019 1771 39
1079480 1079480 2021-03-02 Chilton Alabama 1021 3883 100
1079481 1079481 2021-03-02 Choctaw Alabama 1023 551 23
1079482 1079482 2021-03-02 Clarke Alabama 1025 3437 53
1079483 1079483 2021-03-02 Clay Alabama 1027 1450 54
1079484 1079484 2021-03-02 Cleburne Alabama 1029 1378 41
1079485 1079485 2021-03-02 Coffee Alabama 1031 5254 102
1079486 1079486 2021-03-02 Colbert Alabama 1033 5993 119
1079487 1079487 2021-03-02 Conecuh Alabama 1035 1067 24
1079488 1079488 2021-03-02 Coosa Alabama 1037 892 24
1079489 1079489 2021-03-02 Covington Alabama 1039 3970 106
1079490 1079490 2021-03-02 Crenshaw Alabama 1041 1452 54
1079491 1079491 2021-03-02 Cullman Alabama 1043 8903 181
1079492 1079492 2021-03-02 Dale Alabama 1045 4648 107
1079493 1079493 2021-03-02 Dallas Alabama 1047 3412 141
1079494 1079494 2021-03-02 DeKalb Alabama 1049 8465 175
1079495 1079495 2021-03-02 Elmore Alabama 1051 9408 185
1079496 1079496 2021-03-02 Escambia Alabama 1053 3781 72
1079497 1079497 2021-03-02 Etowah Alabama 1055 13192 320
1079498 1079498 2021-03-02 Fayette Alabama 1057 2009 57
1079499 1079499 2021-03-02 Franklin Alabama 1059 3994 78
1079500 1079500 2021-03-02 Geneva Alabama 1061 2402 70
1079501 1079501 2021-03-02 Greene Alabama 1063 882 32
1079502 1079502 2021-03-02 Hale Alabama 1065 2106 68

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