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

1,845,855 rows sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state

fips

county

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
1842673 1842673 2021-10-23 Aleutians East Borough Alaska 2013 433 3
1842674 1842674 2021-10-23 Aleutians West Census Area Alaska 2016 927 0
1842675 1842675 2021-10-23 Anchorage Alaska 2020 54828 319
1842676 1842676 2021-10-23 Bethel Census Area Alaska 2050 5831 27
1842677 1842677 2021-10-23 Bristol Bay plus Lake and Peninsula Alaska 2997 460 0
1842678 1842678 2021-10-23 Denali Borough Alaska 2068 262 1
1842679 1842679 2021-10-23 Dillingham Census Area Alaska 2070 804 5
1842680 1842680 2021-10-23 Fairbanks North Star Borough Alaska 2090 15093 82
1842681 1842681 2021-10-23 Haines Borough Alaska 2100 222 0
1842682 1842682 2021-10-23 Juneau City and Borough Alaska 2110 3730 9
1842683 1842683 2021-10-23 Kenai Peninsula Borough Alaska 2122 10506 54
1842684 1842684 2021-10-23 Ketchikan Gateway Borough Alaska 2130 1656 9
1842685 1842685 2021-10-23 Kodiak Island Borough Alaska 2150 2479 7
1842686 1842686 2021-10-23 Kusilvak Census Area Alaska 2158 2039 8
1842687 1842687 2021-10-23 Matanuska-Susitna Borough Alaska 2170 21125 105
1842688 1842688 2021-10-23 Nome Census Area Alaska 2180 1357 1
1842689 1842689 2021-10-23 North Slope Borough Alaska 2185 2581 6
1842690 1842690 2021-10-23 Northwest Arctic Borough Alaska 2188 1665 7
1842691 1842691 2021-10-23 Petersburg Borough Alaska 2195 285 2
1842692 1842692 2021-10-23 Prince of Wales-Hyder Census Area Alaska 2198 488 6
1842693 1842693 2021-10-23 Sitka City and Borough Alaska 2220 1163 4
1842694 1842694 2021-10-23 Skagway Municipality Alaska 2230 70 0
1842695 1842695 2021-10-23 Southeast Fairbanks Census Area Alaska 2240 1176 10
1842696 1842696 2021-10-23 Unknown Alaska   515 1
1842697 1842697 2021-10-23 Valdez-Cordova Census Area Alaska 2261 1635 7
1842698 1842698 2021-10-23 Wrangell City and Borough Alaska 2275 139 0
1842699 1842699 2021-10-23 Yakutat plus Hoonah-Angoon Alaska 2998 246 2
1842700 1842700 2021-10-23 Yukon-Koyukuk Census Area Alaska 2290 678 5
1842701 1842701 2021-10-23 Unknown American Samoa   1 0
1842702 1842702 2021-10-23 Apache Arizona 4001 14040 485
1842703 1842703 2021-10-23 Cochise Arizona 4003 15504 339
1842704 1842704 2021-10-23 Coconino Arizona 4005 22771 358
1842705 1842705 2021-10-23 Gila Arizona 4007 9591 256

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