ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
85 rows where deaths = 1, fips = 28097 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
266511 | 266511 | 2020-06-23 | Montgomery | Mississippi | 28097 | 105 | 1 |
263385 | 263385 | 2020-06-22 | Montgomery | Mississippi | 28097 | 104 | 1 |
260256 | 260256 | 2020-06-21 | Montgomery | Mississippi | 28097 | 98 | 1 |
257130 | 257130 | 2020-06-20 | Montgomery | Mississippi | 28097 | 98 | 1 |
254010 | 254010 | 2020-06-19 | Montgomery | Mississippi | 28097 | 98 | 1 |
250895 | 250895 | 2020-06-18 | Montgomery | Mississippi | 28097 | 98 | 1 |
247783 | 247783 | 2020-06-17 | Montgomery | Mississippi | 28097 | 98 | 1 |
244670 | 244670 | 2020-06-16 | Montgomery | Mississippi | 28097 | 98 | 1 |
241559 | 241559 | 2020-06-15 | Montgomery | Mississippi | 28097 | 97 | 1 |
238450 | 238450 | 2020-06-14 | Montgomery | Mississippi | 28097 | 94 | 1 |
235343 | 235343 | 2020-06-13 | Montgomery | Mississippi | 28097 | 94 | 1 |
232237 | 232237 | 2020-06-12 | Montgomery | Mississippi | 28097 | 93 | 1 |
229133 | 229133 | 2020-06-11 | Montgomery | Mississippi | 28097 | 88 | 1 |
226031 | 226031 | 2020-06-10 | Montgomery | Mississippi | 28097 | 88 | 1 |
222933 | 222933 | 2020-06-09 | Montgomery | Mississippi | 28097 | 88 | 1 |
219838 | 219838 | 2020-06-08 | Montgomery | Mississippi | 28097 | 86 | 1 |
216746 | 216746 | 2020-06-07 | Montgomery | Mississippi | 28097 | 85 | 1 |
213658 | 213658 | 2020-06-06 | Montgomery | Mississippi | 28097 | 85 | 1 |
210574 | 210574 | 2020-06-05 | Montgomery | Mississippi | 28097 | 84 | 1 |
207493 | 207493 | 2020-06-04 | Montgomery | Mississippi | 28097 | 84 | 1 |
204412 | 204412 | 2020-06-03 | Montgomery | Mississippi | 28097 | 86 | 1 |
201335 | 201335 | 2020-06-02 | Montgomery | Mississippi | 28097 | 85 | 1 |
198262 | 198262 | 2020-06-01 | Montgomery | Mississippi | 28097 | 85 | 1 |
195191 | 195191 | 2020-05-31 | Montgomery | Mississippi | 28097 | 85 | 1 |
192123 | 192123 | 2020-05-30 | Montgomery | Mississippi | 28097 | 83 | 1 |
189059 | 189059 | 2020-05-29 | Montgomery | Mississippi | 28097 | 81 | 1 |
186001 | 186001 | 2020-05-28 | Montgomery | Mississippi | 28097 | 81 | 1 |
182945 | 182945 | 2020-05-27 | Montgomery | Mississippi | 28097 | 81 | 1 |
179899 | 179899 | 2020-05-26 | Montgomery | Mississippi | 28097 | 80 | 1 |
176855 | 176855 | 2020-05-25 | Montgomery | Mississippi | 28097 | 80 | 1 |
173812 | 173812 | 2020-05-24 | Montgomery | Mississippi | 28097 | 78 | 1 |
170770 | 170770 | 2020-05-23 | Montgomery | Mississippi | 28097 | 78 | 1 |
167732 | 167732 | 2020-05-22 | Montgomery | Mississippi | 28097 | 77 | 1 |
164696 | 164696 | 2020-05-21 | Montgomery | Mississippi | 28097 | 76 | 1 |
161667 | 161667 | 2020-05-20 | Montgomery | Mississippi | 28097 | 75 | 1 |
158641 | 158641 | 2020-05-19 | Montgomery | Mississippi | 28097 | 74 | 1 |
155623 | 155623 | 2020-05-18 | Montgomery | Mississippi | 28097 | 72 | 1 |
152609 | 152609 | 2020-05-17 | Montgomery | Mississippi | 28097 | 72 | 1 |
149598 | 149598 | 2020-05-16 | Montgomery | Mississippi | 28097 | 71 | 1 |
146593 | 146593 | 2020-05-15 | Montgomery | Mississippi | 28097 | 71 | 1 |
143593 | 143593 | 2020-05-14 | Montgomery | Mississippi | 28097 | 70 | 1 |
140598 | 140598 | 2020-05-13 | Montgomery | Mississippi | 28097 | 69 | 1 |
137604 | 137604 | 2020-05-12 | Montgomery | Mississippi | 28097 | 69 | 1 |
134614 | 134614 | 2020-05-11 | Montgomery | Mississippi | 28097 | 69 | 1 |
131623 | 131623 | 2020-05-10 | Montgomery | Mississippi | 28097 | 69 | 1 |
128633 | 128633 | 2020-05-09 | Montgomery | Mississippi | 28097 | 67 | 1 |
125646 | 125646 | 2020-05-08 | Montgomery | Mississippi | 28097 | 65 | 1 |
122664 | 122664 | 2020-05-07 | Montgomery | Mississippi | 28097 | 56 | 1 |
119690 | 119690 | 2020-05-06 | Montgomery | Mississippi | 28097 | 51 | 1 |
116730 | 116730 | 2020-05-05 | Montgomery | Mississippi | 28097 | 47 | 1 |
113848 | 113848 | 2020-05-04 | Montgomery | Mississippi | 28097 | 35 | 1 |
110969 | 110969 | 2020-05-03 | Montgomery | Mississippi | 28097 | 32 | 1 |
108098 | 108098 | 2020-05-02 | Montgomery | Mississippi | 28097 | 32 | 1 |
105233 | 105233 | 2020-05-01 | Montgomery | Mississippi | 28097 | 29 | 1 |
102372 | 102372 | 2020-04-30 | Montgomery | Mississippi | 28097 | 28 | 1 |
99520 | 99520 | 2020-04-29 | Montgomery | Mississippi | 28097 | 20 | 1 |
96674 | 96674 | 2020-04-28 | Montgomery | Mississippi | 28097 | 19 | 1 |
93838 | 93838 | 2020-04-27 | Montgomery | Mississippi | 28097 | 19 | 1 |
91017 | 91017 | 2020-04-26 | Montgomery | Mississippi | 28097 | 19 | 1 |
88201 | 88201 | 2020-04-25 | Montgomery | Mississippi | 28097 | 18 | 1 |
85391 | 85391 | 2020-04-24 | Montgomery | Mississippi | 28097 | 17 | 1 |
82587 | 82587 | 2020-04-23 | Montgomery | Mississippi | 28097 | 16 | 1 |
79791 | 79791 | 2020-04-22 | Montgomery | Mississippi | 28097 | 16 | 1 |
77006 | 77006 | 2020-04-21 | Montgomery | Mississippi | 28097 | 17 | 1 |
74225 | 74225 | 2020-04-20 | Montgomery | Mississippi | 28097 | 15 | 1 |
71452 | 71452 | 2020-04-19 | Montgomery | Mississippi | 28097 | 15 | 1 |
68686 | 68686 | 2020-04-18 | Montgomery | Mississippi | 28097 | 15 | 1 |
65934 | 65934 | 2020-04-17 | Montgomery | Mississippi | 28097 | 15 | 1 |
63194 | 63194 | 2020-04-16 | Montgomery | Mississippi | 28097 | 15 | 1 |
60472 | 60472 | 2020-04-15 | Montgomery | Mississippi | 28097 | 15 | 1 |
57761 | 57761 | 2020-04-14 | Montgomery | Mississippi | 28097 | 15 | 1 |
55063 | 55063 | 2020-04-13 | Montgomery | Mississippi | 28097 | 15 | 1 |
52381 | 52381 | 2020-04-12 | Montgomery | Mississippi | 28097 | 14 | 1 |
49708 | 49708 | 2020-04-11 | Montgomery | Mississippi | 28097 | 14 | 1 |
47062 | 47062 | 2020-04-10 | Montgomery | Mississippi | 28097 | 14 | 1 |
44453 | 44453 | 2020-04-09 | Montgomery | Mississippi | 28097 | 13 | 1 |
41876 | 41876 | 2020-04-08 | Montgomery | Mississippi | 28097 | 12 | 1 |
39322 | 39322 | 2020-04-07 | Montgomery | Mississippi | 28097 | 12 | 1 |
36811 | 36811 | 2020-04-06 | Montgomery | Mississippi | 28097 | 11 | 1 |
34348 | 34348 | 2020-04-05 | Montgomery | Mississippi | 28097 | 11 | 1 |
31921 | 31921 | 2020-04-04 | Montgomery | Mississippi | 28097 | 10 | 1 |
29541 | 29541 | 2020-04-03 | Montgomery | Mississippi | 28097 | 10 | 1 |
27222 | 27222 | 2020-04-02 | Montgomery | Mississippi | 28097 | 8 | 1 |
24968 | 24968 | 2020-04-01 | Montgomery | Mississippi | 28097 | 8 | 1 |
22784 | 22784 | 2020-03-31 | Montgomery | Mississippi | 28097 | 7 | 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);