ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
68 rows where cases = 27 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Grenada 6
- Issaquena 5
- Benton 4
- Wayne 4
- Perry 3
- Tallahatchie 3
- Walthall 3
- Webster 3
- Clay 2
- Franklin 2
- Leake 2
- Oktibbeha 2
- Panola 2
- Pearl River 2
- Tate 2
- Adams 1
- Bolivar 1
- Calhoun 1
- Choctaw 1
- Claiborne 1
- Clarke 1
- Coahoma 1
- Copiah 1
- Forrest 1
- Holmes 1
- Humphreys 1
- Itawamba 1
- Jasper 1
- Jefferson Davis 1
- Kemper 1
- …
state 1
- Mississippi · 68 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
435675 | 435675 | 2020-08-15 | Issaquena | Mississippi | 28055 | 27 | 2 |
432449 | 432449 | 2020-08-14 | Issaquena | Mississippi | 28055 | 27 | 2 |
429222 | 429222 | 2020-08-13 | Issaquena | Mississippi | 28055 | 27 | 2 |
425998 | 425998 | 2020-08-12 | Issaquena | Mississippi | 28055 | 27 | 2 |
422776 | 422776 | 2020-08-11 | Issaquena | Mississippi | 28055 | 27 | 2 |
294777 | 294777 | 2020-07-02 | Benton | Mississippi | 28009 | 27 | 0 |
294835 | 294835 | 2020-07-02 | Sharkey | Mississippi | 28125 | 27 | 0 |
291623 | 291623 | 2020-07-01 | Benton | Mississippi | 28009 | 27 | 0 |
288472 | 288472 | 2020-06-30 | Benton | Mississippi | 28009 | 27 | 0 |
285322 | 285322 | 2020-06-29 | Benton | Mississippi | 28009 | 27 | 0 |
198281 | 198281 | 2020-06-01 | Tallahatchie | Mississippi | 28135 | 27 | 1 |
195210 | 195210 | 2020-05-31 | Tallahatchie | Mississippi | 28135 | 27 | 1 |
192142 | 192142 | 2020-05-30 | Tallahatchie | Mississippi | 28135 | 27 | 1 |
182916 | 182916 | 2020-05-27 | Franklin | Mississippi | 28037 | 27 | 2 |
179870 | 179870 | 2020-05-26 | Franklin | Mississippi | 28037 | 27 | 2 |
173841 | 173841 | 2020-05-24 | Webster | Mississippi | 28155 | 27 | 1 |
170799 | 170799 | 2020-05-23 | Webster | Mississippi | 28155 | 27 | 1 |
167749 | 167749 | 2020-05-22 | Stone | Mississippi | 28131 | 27 | 0 |
167761 | 167761 | 2020-05-22 | Webster | Mississippi | 28155 | 27 | 1 |
164658 | 164658 | 2020-05-21 | Choctaw | Mississippi | 28019 | 27 | 2 |
131651 | 131651 | 2020-05-10 | Wayne | Mississippi | 28153 | 27 | 0 |
128661 | 128661 | 2020-05-09 | Wayne | Mississippi | 28153 | 27 | 0 |
125674 | 125674 | 2020-05-08 | Wayne | Mississippi | 28153 | 27 | 0 |
125678 | 125678 | 2020-05-08 | Yalobusha | Mississippi | 28161 | 27 | 0 |
122692 | 122692 | 2020-05-07 | Wayne | Mississippi | 28153 | 27 | 0 |
119669 | 119669 | 2020-05-06 | Humphreys | Mississippi | 28053 | 27 | 4 |
110993 | 110993 | 2020-05-03 | Union | Mississippi | 28145 | 27 | 2 |
108061 | 108061 | 2020-05-02 | Claiborne | Mississippi | 28021 | 27 | 0 |
108105 | 108105 | 2020-05-02 | Perry | Mississippi | 28111 | 27 | 1 |
105240 | 105240 | 2020-05-01 | Perry | Mississippi | 28111 | 27 | 1 |
102379 | 102379 | 2020-04-30 | Perry | Mississippi | 28111 | 27 | 1 |
93812 | 93812 | 2020-04-27 | Grenada | Mississippi | 28043 | 27 | 0 |
93822 | 93822 | 2020-04-27 | Jefferson Davis | Mississippi | 28065 | 27 | 1 |
90991 | 90991 | 2020-04-26 | Grenada | Mississippi | 28043 | 27 | 0 |
88175 | 88175 | 2020-04-25 | Grenada | Mississippi | 28043 | 27 | 0 |
88226 | 88226 | 2020-04-25 | Walthall | Mississippi | 28147 | 27 | 0 |
85365 | 85365 | 2020-04-24 | Grenada | Mississippi | 28043 | 27 | 0 |
85416 | 85416 | 2020-04-24 | Walthall | Mississippi | 28147 | 27 | 0 |
82561 | 82561 | 2020-04-23 | Grenada | Mississippi | 28043 | 27 | 0 |
82569 | 82569 | 2020-04-23 | Jasper | Mississippi | 28061 | 27 | 1 |
82573 | 82573 | 2020-04-23 | Kemper | Mississippi | 28069 | 27 | 0 |
82612 | 82612 | 2020-04-23 | Walthall | Mississippi | 28147 | 27 | 0 |
79756 | 79756 | 2020-04-22 | Clay | Mississippi | 28025 | 27 | 2 |
79765 | 79765 | 2020-04-22 | Grenada | Mississippi | 28043 | 27 | 0 |
79771 | 79771 | 2020-04-22 | Itawamba | Mississippi | 28057 | 27 | 1 |
76971 | 76971 | 2020-04-21 | Clay | Mississippi | 28025 | 27 | 1 |
77016 | 77016 | 2020-04-21 | Prentiss | Mississippi | 28117 | 27 | 0 |
71416 | 71416 | 2020-04-19 | Clarke | Mississippi | 28023 | 27 | 2 |
65939 | 65939 | 2020-04-17 | Panola | Mississippi | 28107 | 27 | 2 |
65954 | 65954 | 2020-04-17 | Tate | Mississippi | 28137 | 27 | 0 |
65965 | 65965 | 2020-04-17 | Winston | Mississippi | 28159 | 27 | 0 |
63199 | 63199 | 2020-04-16 | Panola | Mississippi | 28107 | 27 | 2 |
63214 | 63214 | 2020-04-16 | Tate | Mississippi | 28137 | 27 | 0 |
60431 | 60431 | 2020-04-15 | Calhoun | Mississippi | 28013 | 27 | 2 |
60467 | 60467 | 2020-04-15 | Lowndes | Mississippi | 28087 | 27 | 0 |
52372 | 52372 | 2020-04-12 | Leake | Mississippi | 28079 | 27 | 0 |
49699 | 49699 | 2020-04-11 | Leake | Mississippi | 28079 | 27 | 0 |
44406 | 44406 | 2020-04-09 | Adams | Mississippi | 28001 | 27 | 1 |
44420 | 44420 | 2020-04-09 | Copiah | Mississippi | 28029 | 27 | 0 |
41855 | 41855 | 2020-04-08 | Holmes | Mississippi | 28051 | 27 | 3 |
41894 | 41894 | 2020-04-08 | Sunflower | Mississippi | 28133 | 27 | 1 |
36815 | 36815 | 2020-04-06 | Oktibbeha | Mississippi | 28105 | 27 | 0 |
34352 | 34352 | 2020-04-05 | Oktibbeha | Mississippi | 28105 | 27 | 0 |
31889 | 31889 | 2020-04-04 | Coahoma | Mississippi | 28027 | 27 | 1 |
27182 | 27182 | 2020-04-02 | Bolivar | Mississippi | 28011 | 27 | 1 |
24940 | 24940 | 2020-04-01 | Forrest | Mississippi | 28035 | 27 | 0 |
20673 | 20673 | 2020-03-30 | Pearl River | Mississippi | 28109 | 27 | 0 |
18649 | 18649 | 2020-03-29 | Pearl River | Mississippi | 28109 | 27 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
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);