ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
81 rows where cases = 8 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Tishomingo 7
- Copiah 5
- Sharkey 5
- Tallahatchie 5
- Claiborne 4
- Alcorn 3
- Choctaw 3
- George 3
- Jefferson Davis 3
- Panola 3
- Benton 2
- Carroll 2
- Grenada 2
- Lafayette 2
- Montgomery 2
- Tate 2
- Wayne 2
- Webster 2
- Adams 1
- Attala 1
- Clarke 1
- Coahoma 1
- Covington 1
- Franklin 1
- Greene 1
- Harrison 1
- Issaquena 1
- Itawamba 1
- Jefferson 1
- Jones 1
- …
state 1
- Mississippi · 81 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
294800 | 294800 | 2020-07-02 | Issaquena | Mississippi | 28055 | 8 | 1 |
244684 | 244684 | 2020-06-16 | Sharkey | Mississippi | 28125 | 8 | 0 |
241573 | 241573 | 2020-06-15 | Sharkey | Mississippi | 28125 | 8 | 0 |
238464 | 238464 | 2020-06-14 | Sharkey | Mississippi | 28125 | 8 | 0 |
235357 | 235357 | 2020-06-13 | Sharkey | Mississippi | 28125 | 8 | 0 |
232251 | 232251 | 2020-06-12 | Sharkey | Mississippi | 28125 | 8 | 0 |
179872 | 179872 | 2020-05-26 | Greene | Mississippi | 28041 | 8 | 1 |
122686 | 122686 | 2020-05-07 | Tishomingo | Mississippi | 28141 | 8 | 0 |
119712 | 119712 | 2020-05-06 | Tishomingo | Mississippi | 28141 | 8 | 0 |
116752 | 116752 | 2020-05-05 | Tishomingo | Mississippi | 28141 | 8 | 0 |
113870 | 113870 | 2020-05-04 | Tishomingo | Mississippi | 28141 | 8 | 0 |
110991 | 110991 | 2020-05-03 | Tishomingo | Mississippi | 28141 | 8 | 0 |
108120 | 108120 | 2020-05-02 | Tishomingo | Mississippi | 28141 | 8 | 0 |
93792 | 93792 | 2020-04-27 | Alcorn | Mississippi | 28003 | 8 | 0 |
93860 | 93860 | 2020-04-27 | Tishomingo | Mississippi | 28141 | 8 | 0 |
88184 | 88184 | 2020-04-25 | Jefferson | Mississippi | 28063 | 8 | 0 |
82541 | 82541 | 2020-04-23 | Alcorn | Mississippi | 28003 | 8 | 0 |
79748 | 79748 | 2020-04-22 | Benton | Mississippi | 28009 | 8 | 0 |
77025 | 77025 | 2020-04-21 | Tallahatchie | Mississippi | 28135 | 8 | 1 |
74182 | 74182 | 2020-04-20 | Benton | Mississippi | 28009 | 8 | 0 |
74244 | 74244 | 2020-04-20 | Tallahatchie | Mississippi | 28135 | 8 | 1 |
71406 | 71406 | 2020-04-19 | Alcorn | Mississippi | 28003 | 8 | 0 |
71436 | 71436 | 2020-04-19 | Jefferson Davis | Mississippi | 28065 | 8 | 1 |
71471 | 71471 | 2020-04-19 | Tallahatchie | Mississippi | 28135 | 8 | 1 |
68649 | 68649 | 2020-04-18 | Claiborne | Mississippi | 28021 | 8 | 0 |
68670 | 68670 | 2020-04-18 | Jefferson Davis | Mississippi | 28065 | 8 | 1 |
68705 | 68705 | 2020-04-18 | Tallahatchie | Mississippi | 28135 | 8 | 1 |
65897 | 65897 | 2020-04-17 | Claiborne | Mississippi | 28021 | 8 | 0 |
65918 | 65918 | 2020-04-17 | Jefferson Davis | Mississippi | 28065 | 8 | 1 |
65953 | 65953 | 2020-04-17 | Tallahatchie | Mississippi | 28135 | 8 | 1 |
63157 | 63157 | 2020-04-16 | Claiborne | Mississippi | 28021 | 8 | 0 |
63166 | 63166 | 2020-04-16 | George | Mississippi | 28039 | 8 | 0 |
60435 | 60435 | 2020-04-15 | Claiborne | Mississippi | 28021 | 8 | 0 |
60444 | 60444 | 2020-04-15 | George | Mississippi | 28039 | 8 | 0 |
57721 | 57721 | 2020-04-14 | Carroll | Mississippi | 28015 | 8 | 0 |
57785 | 57785 | 2020-04-14 | Union | Mississippi | 28145 | 8 | 1 |
55023 | 55023 | 2020-04-13 | Carroll | Mississippi | 28015 | 8 | 0 |
55035 | 55035 | 2020-04-13 | George | Mississippi | 28039 | 8 | 0 |
52409 | 52409 | 2020-04-12 | Wayne | Mississippi | 28153 | 8 | 0 |
49736 | 49736 | 2020-04-11 | Wayne | Mississippi | 28153 | 8 | 0 |
47030 | 47030 | 2020-04-10 | Covington | Mississippi | 28031 | 8 | 0 |
47042 | 47042 | 2020-04-10 | Itawamba | Mississippi | 28057 | 8 | 0 |
44424 | 44424 | 2020-04-09 | Franklin | Mississippi | 28037 | 8 | 0 |
44443 | 44443 | 2020-04-09 | Lawrence | Mississippi | 28077 | 8 | 0 |
44455 | 44455 | 2020-04-09 | Newton | Mississippi | 28101 | 8 | 0 |
41851 | 41851 | 2020-04-08 | Grenada | Mississippi | 28043 | 8 | 0 |
39297 | 39297 | 2020-04-07 | Grenada | Mississippi | 28043 | 8 | 0 |
36774 | 36774 | 2020-04-06 | Choctaw | Mississippi | 28019 | 8 | 1 |
36776 | 36776 | 2020-04-06 | Clarke | Mississippi | 28023 | 8 | 0 |
36808 | 36808 | 2020-04-06 | Marion | Mississippi | 28091 | 8 | 0 |
34312 | 34312 | 2020-04-05 | Choctaw | Mississippi | 28019 | 8 | 1 |
31885 | 31885 | 2020-04-04 | Choctaw | Mississippi | 28019 | 8 | 0 |
31912 | 31912 | 2020-04-04 | Leake | Mississippi | 28079 | 8 | 0 |
29526 | 29526 | 2020-04-03 | Jones | Mississippi | 28067 | 8 | 0 |
29546 | 29546 | 2020-04-03 | Panola | Mississippi | 28107 | 8 | 1 |
29569 | 29569 | 2020-04-03 | Webster | Mississippi | 28155 | 8 | 1 |
27210 | 27210 | 2020-04-02 | Lamar | Mississippi | 28073 | 8 | 0 |
27222 | 27222 | 2020-04-02 | Montgomery | Mississippi | 28097 | 8 | 1 |
27227 | 27227 | 2020-04-02 | Panola | Mississippi | 28107 | 8 | 1 |
27250 | 27250 | 2020-04-02 | Webster | Mississippi | 28155 | 8 | 1 |
24968 | 24968 | 2020-04-01 | Montgomery | Mississippi | 28097 | 8 | 1 |
24973 | 24973 | 2020-04-01 | Panola | Mississippi | 28107 | 8 | 1 |
20623 | 20623 | 2020-03-30 | Adams | Mississippi | 28001 | 8 | 0 |
20637 | 20637 | 2020-03-30 | Copiah | Mississippi | 28029 | 8 | 0 |
18613 | 18613 | 2020-03-29 | Copiah | Mississippi | 28029 | 8 | 0 |
16691 | 16691 | 2020-03-28 | Copiah | Mississippi | 28029 | 8 | 0 |
16715 | 16715 | 2020-03-28 | Lincoln | Mississippi | 28085 | 8 | 0 |
16740 | 16740 | 2020-03-28 | Tate | Mississippi | 28137 | 8 | 0 |
14860 | 14860 | 2020-03-27 | Attala | Mississippi | 28007 | 8 | 0 |
14868 | 14868 | 2020-03-27 | Copiah | Mississippi | 28029 | 8 | 0 |
14916 | 14916 | 2020-03-27 | Tate | Mississippi | 28137 | 8 | 0 |
13152 | 13152 | 2020-03-26 | Copiah | Mississippi | 28029 | 8 | 0 |
13174 | 13174 | 2020-03-26 | Lowndes | Mississippi | 28087 | 8 | 0 |
13203 | 13203 | 2020-03-26 | Wilkinson | Mississippi | 28157 | 8 | 1 |
11574 | 11574 | 2020-03-25 | Lafayette | Mississippi | 28071 | 8 | 0 |
10154 | 10154 | 2020-03-24 | Lafayette | Mississippi | 28071 | 8 | 0 |
8843 | 8843 | 2020-03-23 | Coahoma | Mississippi | 28027 | 8 | 0 |
8862 | 8862 | 2020-03-23 | Lee | Mississippi | 28081 | 8 | 0 |
8877 | 8877 | 2020-03-23 | Rankin | Mississippi | 28121 | 8 | 0 |
7682 | 7682 | 2020-03-22 | Leflore | Mississippi | 28083 | 8 | 0 |
5610 | 5610 | 2020-03-20 | Harrison | Mississippi | 28047 | 8 | 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);