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

82 rows where date = "2022-02-26" and state = "Mississippi" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Mississippi · 82 ✖
Link rowid date ▲ county state fips cases deaths
2253658 2253658 2022-02-26 Adams Mississippi 28001 7102 140
2253659 2253659 2022-02-26 Alcorn Mississippi 28003 9854 146
2253660 2253660 2022-02-26 Amite Mississippi 28005 3206 67
2253661 2253661 2022-02-26 Attala Mississippi 28007 5223 110
2253662 2253662 2022-02-26 Benton Mississippi 28009 2257 49
2253663 2253663 2022-02-26 Bolivar Mississippi 28011 9198 174
2253664 2253664 2022-02-26 Calhoun Mississippi 28013 4622 65
2253665 2253665 2022-02-26 Carroll Mississippi 28015 2546 50
2253666 2253666 2022-02-26 Chickasaw Mississippi 28017 5566 95
2253667 2253667 2022-02-26 Choctaw Mississippi 28019 2178 33
2253668 2253668 2022-02-26 Claiborne Mississippi 28021 2132 46
2253669 2253669 2022-02-26 Clarke Mississippi 28023 4197 104
2253670 2253670 2022-02-26 Clay Mississippi 28025 4929 93
2253671 2253671 2022-02-26 Coahoma Mississippi 28027 6423 120
2253672 2253672 2022-02-26 Copiah Mississippi 28029 7085 111
2253673 2253673 2022-02-26 Covington Mississippi 28031 7043 107
2253674 2253674 2022-02-26 DeSoto Mississippi 28033 49772 536
2253675 2253675 2022-02-26 Forrest Mississippi 28035 21856 302
2253676 2253676 2022-02-26 Franklin Mississippi 28037 1918 37
2253677 2253677 2022-02-26 George Mississippi 28039 7105 86
2253678 2253678 2022-02-26 Greene Mississippi 28041 3170 56
2253679 2253679 2022-02-26 Grenada Mississippi 28043 5482 126
2253680 2253680 2022-02-26 Hancock Mississippi 28045 12116 146
2253681 2253681 2022-02-26 Harrison Mississippi 28047 53089 644
2253682 2253682 2022-02-26 Hinds Mississippi 28049 51843 757
2253683 2253683 2022-02-26 Holmes Mississippi 28051 4415 104
2253684 2253684 2022-02-26 Humphreys Mississippi 28053 2004 44
2253685 2253685 2022-02-26 Issaquena Mississippi 28055 260 9
2253686 2253686 2022-02-26 Itawamba Mississippi 28057 7344 141
2253687 2253687 2022-02-26 Jackson Mississippi 28059 36680 439
2253688 2253688 2022-02-26 Jasper Mississippi 28061 4771 72
2253689 2253689 2022-02-26 Jefferson Mississippi 28063 1470 37
2253690 2253690 2022-02-26 Jefferson Davis Mississippi 28065 2838 50
2253691 2253691 2022-02-26 Jones Mississippi 28067 21082 285
2253692 2253692 2022-02-26 Kemper Mississippi 28069 2158 46
2253693 2253693 2022-02-26 Lafayette Mississippi 28071 15072 174
2253694 2253694 2022-02-26 Lamar Mississippi 28073 17282 157
2253695 2253695 2022-02-26 Lauderdale Mississippi 28075 18678 357
2253696 2253696 2022-02-26 Lawrence Mississippi 28077 3556 53
2253697 2253697 2022-02-26 Leake Mississippi 28079 6330 113
2253698 2253698 2022-02-26 Lee Mississippi 28081 26454 291
2253699 2253699 2022-02-26 Leflore Mississippi 28083 7283 166
2253700 2253700 2022-02-26 Lincoln Mississippi 28085 8235 155
2253701 2253701 2022-02-26 Lowndes Mississippi 28087 17444 229
2253702 2253702 2022-02-26 Madison Mississippi 28089 23838 318
2253703 2253703 2022-02-26 Marion Mississippi 28091 6928 133
2253704 2253704 2022-02-26 Marshall Mississippi 28093 9857 171
2253705 2253705 2022-02-26 Monroe Mississippi 28095 10920 210
2253706 2253706 2022-02-26 Montgomery Mississippi 28097 2936 71
2253707 2253707 2022-02-26 Neshoba Mississippi 28099 10445 233
2253708 2253708 2022-02-26 Newton Mississippi 28101 5942 96
2253709 2253709 2022-02-26 Noxubee Mississippi 28103 2710 48
2253710 2253710 2022-02-26 Oktibbeha Mississippi 28105 11035 158
2253711 2253711 2022-02-26 Panola Mississippi 28107 10349 163
2253712 2253712 2022-02-26 Pearl River Mississippi 28109 14954 265
2253713 2253713 2022-02-26 Perry Mississippi 28111 3028 63
2253714 2253714 2022-02-26 Pike Mississippi 28113 9421 180
2253715 2253715 2022-02-26 Pontotoc Mississippi 28115 10210 134
2253716 2253716 2022-02-26 Prentiss Mississippi 28117 8127 101
2253717 2253717 2022-02-26 Quitman Mississippi 28119 1558 31
2253718 2253718 2022-02-26 Rankin Mississippi 28121 36270 470
2253719 2253719 2022-02-26 Scott Mississippi 28123 6471 114
2253720 2253720 2022-02-26 Sharkey Mississippi 28125 950 24
2253721 2253721 2022-02-26 Simpson Mississippi 28127 6926 141
2253722 2253722 2022-02-26 Smith Mississippi 28129 4070 66
2253723 2253723 2022-02-26 Stone Mississippi 28131 5375 70
2253724 2253724 2022-02-26 Sunflower Mississippi 28133 5722 117
2253725 2253725 2022-02-26 Tallahatchie Mississippi 28135 3173 60
2253726 2253726 2022-02-26 Tate Mississippi 28137 7248 139
2253727 2253727 2022-02-26 Tippah Mississippi 28139 7175 106
2253728 2253728 2022-02-26 Tishomingo Mississippi 28141 6079 120
2253729 2253729 2022-02-26 Tunica Mississippi 28143 2506 44
2253730 2253730 2022-02-26 Union Mississippi 28145 9427 115
2253731 2253731 2022-02-26 Walthall Mississippi 28147 3568 78
2253732 2253732 2022-02-26 Warren Mississippi 28149 10168 199
2253733 2253733 2022-02-26 Washington Mississippi 28151 10156 194
2253734 2253734 2022-02-26 Wayne Mississippi 28153 5922 84
2253735 2253735 2022-02-26 Webster Mississippi 28155 3322 66
2253736 2253736 2022-02-26 Wilkinson Mississippi 28157 1790 45
2253737 2253737 2022-02-26 Winston Mississippi 28159 5176 102
2253738 2253738 2022-02-26 Yalobusha Mississippi 28161 4048 54
2253739 2253739 2022-02-26 Yazoo Mississippi 28163 7988 103

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