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

64,147 rows where state = "Mississippi" 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

  • Mississippi · 64,147 ✖
Link rowid date ▲ county state fips cases deaths
2500993 2500993 2022-05-13 Adams Mississippi 28001 7224 143
2500994 2500994 2022-05-13 Alcorn Mississippi 28003 10080 160
2500995 2500995 2022-05-13 Amite Mississippi 28005 3259 69
2500996 2500996 2022-05-13 Attala Mississippi 28007 5361 113
2500997 2500997 2022-05-13 Benton Mississippi 28009 2274 49
2500998 2500998 2022-05-13 Bolivar Mississippi 28011 9354 179
2500999 2500999 2022-05-13 Calhoun Mississippi 28013 4641 71
2501000 2501000 2022-05-13 Carroll Mississippi 28015 2565 54
2501001 2501001 2022-05-13 Chickasaw Mississippi 28017 5603 96
2501002 2501002 2022-05-13 Choctaw Mississippi 28019 2318 33
2501003 2501003 2022-05-13 Claiborne Mississippi 28021 2152 46
2501004 2501004 2022-05-13 Clarke Mississippi 28023 4239 108
2501005 2501005 2022-05-13 Clay Mississippi 28025 4974 98
2501006 2501006 2022-05-13 Coahoma Mississippi 28027 6486 126
2501007 2501007 2022-05-13 Copiah Mississippi 28029 7287 121
2501008 2501008 2022-05-13 Covington Mississippi 28031 7086 113
2501009 2501009 2022-05-13 DeSoto Mississippi 28033 50344 554
2501010 2501010 2022-05-13 Forrest Mississippi 28035 22076 315
2501011 2501011 2022-05-13 Franklin Mississippi 28037 1927 38
2501012 2501012 2022-05-13 George Mississippi 28039 7163 87
2501013 2501013 2022-05-13 Greene Mississippi 28041 3198 59
2501014 2501014 2022-05-13 Grenada Mississippi 28043 5533 131
2501015 2501015 2022-05-13 Hancock Mississippi 28045 12277 152
2501016 2501016 2022-05-13 Harrison Mississippi 28047 53859 665
2501017 2501017 2022-05-13 Hinds Mississippi 28049 52682 791
2501018 2501018 2022-05-13 Holmes Mississippi 28051 4455 104
2501019 2501019 2022-05-13 Humphreys Mississippi 28053 2030 46
2501020 2501020 2022-05-13 Issaquena Mississippi 28055 262 9
2501021 2501021 2022-05-13 Itawamba Mississippi 28057 7430 144
2501022 2501022 2022-05-13 Jackson Mississippi 28059 37055 463
2501023 2501023 2022-05-13 Jasper Mississippi 28061 4943 75
2501024 2501024 2022-05-13 Jefferson Mississippi 28063 1494 37
2501025 2501025 2022-05-13 Jefferson Davis Mississippi 28065 2865 53
2501026 2501026 2022-05-13 Jones Mississippi 28067 21234 295
2501027 2501027 2022-05-13 Kemper Mississippi 28069 2187 48
2501028 2501028 2022-05-13 Lafayette Mississippi 28071 15364 179
2501029 2501029 2022-05-13 Lamar Mississippi 28073 17441 160
2501030 2501030 2022-05-13 Lauderdale Mississippi 28075 18898 367
2501031 2501031 2022-05-13 Lawrence Mississippi 28077 3590 56
2501032 2501032 2022-05-13 Leake Mississippi 28079 6427 120
2501033 2501033 2022-05-13 Lee Mississippi 28081 26783 301
2501034 2501034 2022-05-13 Leflore Mississippi 28083 7326 169
2501035 2501035 2022-05-13 Lincoln Mississippi 28085 8324 157
2501036 2501036 2022-05-13 Lowndes Mississippi 28087 17528 238
2501037 2501037 2022-05-13 Madison Mississippi 28089 24189 329
2501038 2501038 2022-05-13 Marion Mississippi 28091 6974 135
2501039 2501039 2022-05-13 Marshall Mississippi 28093 9941 174
2501040 2501040 2022-05-13 Monroe Mississippi 28095 10997 220
2501041 2501041 2022-05-13 Montgomery Mississippi 28097 2963 77
2501042 2501042 2022-05-13 Neshoba Mississippi 28099 10622 241
2501043 2501043 2022-05-13 Newton Mississippi 28101 6059 98
2501044 2501044 2022-05-13 Noxubee Mississippi 28103 2730 48
2501045 2501045 2022-05-13 Oktibbeha Mississippi 28105 11127 162
2501046 2501046 2022-05-13 Panola Mississippi 28107 10566 169
2501047 2501047 2022-05-13 Pearl River Mississippi 28109 15151 275
2501048 2501048 2022-05-13 Perry Mississippi 28111 3048 64
2501049 2501049 2022-05-13 Pike Mississippi 28113 9751 189
2501050 2501050 2022-05-13 Pontotoc Mississippi 28115 10364 145
2501051 2501051 2022-05-13 Prentiss Mississippi 28117 8245 103
2501052 2501052 2022-05-13 Quitman Mississippi 28119 1579 31
2501053 2501053 2022-05-13 Rankin Mississippi 28121 36738 489
2501054 2501054 2022-05-13 Scott Mississippi 28123 6559 119
2501055 2501055 2022-05-13 Sharkey Mississippi 28125 953 26
2501056 2501056 2022-05-13 Simpson Mississippi 28127 7026 149
2501057 2501057 2022-05-13 Smith Mississippi 28129 4127 68
2501058 2501058 2022-05-13 Stone Mississippi 28131 5409 71
2501059 2501059 2022-05-13 Sunflower Mississippi 28133 5773 125
2501060 2501060 2022-05-13 Tallahatchie Mississippi 28135 3203 60
2501061 2501061 2022-05-13 Tate Mississippi 28137 7396 143
2501062 2501062 2022-05-13 Tippah Mississippi 28139 7361 109
2501063 2501063 2022-05-13 Tishomingo Mississippi 28141 6172 122
2501064 2501064 2022-05-13 Tunica Mississippi 28143 2559 48
2501065 2501065 2022-05-13 Union Mississippi 28145 9487 122
2501066 2501066 2022-05-13 Unknown Mississippi   1919 3
2501067 2501067 2022-05-13 Walthall Mississippi 28147 3622 79
2501068 2501068 2022-05-13 Warren Mississippi 28149 10250 202
2501069 2501069 2022-05-13 Washington Mississippi 28151 10470 199
2501070 2501070 2022-05-13 Wayne Mississippi 28153 6008 87
2501071 2501071 2022-05-13 Webster Mississippi 28155 3388 70
2501072 2501072 2022-05-13 Wilkinson Mississippi 28157 1804 46
2501073 2501073 2022-05-13 Winston Mississippi 28159 5231 104
2501074 2501074 2022-05-13 Yalobusha Mississippi 28161 4114 57
2501075 2501075 2022-05-13 Yazoo Mississippi 28163 8054 107
2497735 2497735 2022-05-12 Adams Mississippi 28001 7224 143
2497736 2497736 2022-05-12 Alcorn Mississippi 28003 10080 160
2497737 2497737 2022-05-12 Amite Mississippi 28005 3259 69
2497738 2497738 2022-05-12 Attala Mississippi 28007 5361 113
2497739 2497739 2022-05-12 Benton Mississippi 28009 2274 49
2497740 2497740 2022-05-12 Bolivar Mississippi 28011 9354 179
2497741 2497741 2022-05-12 Calhoun Mississippi 28013 4641 71
2497742 2497742 2022-05-12 Carroll Mississippi 28015 2565 54
2497743 2497743 2022-05-12 Chickasaw Mississippi 28017 5603 96
2497744 2497744 2022-05-12 Choctaw Mississippi 28019 2318 33
2497745 2497745 2022-05-12 Claiborne Mississippi 28021 2152 46
2497746 2497746 2022-05-12 Clarke Mississippi 28023 4239 108
2497747 2497747 2022-05-12 Clay Mississippi 28025 4974 98
2497748 2497748 2022-05-12 Coahoma Mississippi 28027 6486 126
2497749 2497749 2022-05-12 Copiah Mississippi 28029 7287 121
2497750 2497750 2022-05-12 Covington Mississippi 28031 7086 113
2497751 2497751 2022-05-12 DeSoto Mississippi 28033 50344 554

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