ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
31 rows where cases = 94 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
464721 | 464721 | 2020-08-24 | Issaquena | Mississippi | 28055 | 94 | 2 |
461490 | 461490 | 2020-08-23 | Issaquena | Mississippi | 28055 | 94 | 2 |
377713 | 377713 | 2020-07-28 | Franklin | Mississippi | 28037 | 94 | 2 |
342497 | 342497 | 2020-07-17 | Stone | Mississippi | 28131 | 94 | 2 |
320113 | 320113 | 2020-07-10 | Alcorn | Mississippi | 28003 | 94 | 2 |
313782 | 313782 | 2020-07-08 | George | Mississippi | 28039 | 94 | 3 |
313841 | 313841 | 2020-07-08 | Wilkinson | Mississippi | 28157 | 94 | 9 |
307503 | 307503 | 2020-07-06 | Wilkinson | Mississippi | 28157 | 94 | 9 |
304336 | 304336 | 2020-07-05 | Wilkinson | Mississippi | 28157 | 94 | 9 |
301172 | 301172 | 2020-07-04 | Wilkinson | Mississippi | 28157 | 94 | 9 |
288535 | 288535 | 2020-06-30 | Tallahatchie | Mississippi | 28135 | 94 | 3 |
285376 | 285376 | 2020-06-29 | Prentiss | Mississippi | 28117 | 94 | 3 |
272766 | 272766 | 2020-06-25 | Jefferson Davis | Mississippi | 28065 | 94 | 3 |
241580 | 241580 | 2020-06-15 | Tippah | Mississippi | 28139 | 94 | 11 |
238450 | 238450 | 2020-06-14 | Montgomery | Mississippi | 28097 | 94 | 1 |
235343 | 235343 | 2020-06-13 | Montgomery | Mississippi | 28097 | 94 | 1 |
229108 | 229108 | 2020-06-11 | Hancock | Mississippi | 28045 | 94 | 12 |
226006 | 226006 | 2020-06-10 | Hancock | Mississippi | 28045 | 94 | 12 |
198294 | 198294 | 2020-06-01 | Yalobusha | Mississippi | 28161 | 94 | 5 |
195165 | 195165 | 2020-05-31 | Grenada | Mississippi | 28043 | 94 | 3 |
195211 | 195211 | 2020-05-31 | Tate | Mississippi | 28137 | 94 | 1 |
176845 | 176845 | 2020-05-25 | Lawrence | Mississippi | 28077 | 94 | 1 |
140602 | 140602 | 2020-05-13 | Oktibbeha | Mississippi | 28105 | 94 | 6 |
137565 | 137565 | 2020-05-12 | Chickasaw | Mississippi | 28017 | 94 | 10 |
125672 | 125672 | 2020-05-08 | Warren | Mississippi | 28149 | 94 | 2 |
99476 | 99476 | 2020-04-29 | Attala | Mississippi | 28007 | 94 | 0 |
96662 | 96662 | 2020-04-28 | Lamar | Mississippi | 28073 | 94 | 2 |
88159 | 88159 | 2020-04-25 | Bolivar | Mississippi | 28011 | 94 | 7 |
82572 | 82572 | 2020-04-23 | Jones | Mississippi | 28067 | 94 | 0 |
49720 | 49720 | 2020-04-11 | Rankin | Mississippi | 28121 | 94 | 2 |
24939 | 24939 | 2020-04-01 | DeSoto | Mississippi | 28033 | 94 | 1 |
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);