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

2,502,832 rows sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

fips >1000

county >1000

state 56

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
2499642 2499642 2022-05-13 Aleutians East Borough Alaska 2013 1101 3
2499643 2499643 2022-05-13 Aleutians West Census Area Alaska 2016 1685 1
2499644 2499644 2022-05-13 Anchorage Alaska 2020 105418 526
2499645 2499645 2022-05-13 Bethel Census Area Alaska 2050 10362 41
2499646 2499646 2022-05-13 Bristol Bay plus Lake and Peninsula Alaska 2997 870 1
2499647 2499647 2022-05-13 Denali Borough Alaska 2068 424 1
2499648 2499648 2022-05-13 Dillingham Census Area Alaska 2070 1932 11
2499649 2499649 2022-05-13 Fairbanks North Star Borough Alaska 2090 27763 142
2499650 2499650 2022-05-13 Haines Borough Alaska 2100 624 1
2499651 2499651 2022-05-13 Juneau City and Borough Alaska 2110 8798 19
2499652 2499652 2022-05-13 Kenai Peninsula Borough Alaska 2122 18091 101
2499653 2499653 2022-05-13 Ketchikan Gateway Borough Alaska 2130 4154 17
2499654 2499654 2022-05-13 Kodiak Island Borough Alaska 2150 4992 12
2499655 2499655 2022-05-13 Kusilvak Census Area Alaska 2158 4084 14
2499656 2499656 2022-05-13 Matanuska-Susitna Borough Alaska 2170 34981 236
2499657 2499657 2022-05-13 Nome Census Area Alaska 2180 6245 5
2499658 2499658 2022-05-13 North Slope Borough Alaska 2185 4468 11
2499659 2499659 2022-05-13 Northwest Arctic Borough Alaska 2188 4837 13
2499660 2499660 2022-05-13 Petersburg Borough Alaska 2195 785 4
2499661 2499661 2022-05-13 Prince of Wales-Hyder Census Area Alaska 2198 1454 8
2499662 2499662 2022-05-13 Sitka City and Borough Alaska 2220 2681 5
2499663 2499663 2022-05-13 Skagway Municipality Alaska 2230 187 0
2499664 2499664 2022-05-13 Southeast Fairbanks Census Area Alaska 2240 2052 20
2499665 2499665 2022-05-13 Unknown Alaska   958 1
2499666 2499666 2022-05-13 Valdez-Cordova Census Area Alaska 2261 2948 19
2499667 2499667 2022-05-13 Wrangell City and Borough Alaska 2275 579 1
2499668 2499668 2022-05-13 Yakutat plus Hoonah-Angoon Alaska 2998 556 5
2499669 2499669 2022-05-13 Yukon-Koyukuk Census Area Alaska 2290 1438 10
2499670 2499670 2022-05-13 Unknown American Samoa   5930 30
2499671 2499671 2022-05-13 Apache Arizona 4001 22540 614
2499672 2499672 2022-05-13 Cochise Arizona 4003 31614 573
2499673 2499673 2022-05-13 Coconino Arizona 4005 44091 478
2499674 2499674 2022-05-13 Gila Arizona 4007 17398 381

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