ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where fips = 28031 and state = "Mississippi" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
16692 | 16692 | 2020-03-28 | Covington | Mississippi | 28031 | 1 | 0 |
18614 | 18614 | 2020-03-29 | Covington | Mississippi | 28031 | 1 | 0 |
20638 | 20638 | 2020-03-30 | Covington | Mississippi | 28031 | 2 | 0 |
22755 | 22755 | 2020-03-31 | Covington | Mississippi | 28031 | 2 | 0 |
24938 | 24938 | 2020-04-01 | Covington | Mississippi | 28031 | 3 | 0 |
27192 | 27192 | 2020-04-02 | Covington | Mississippi | 28031 | 3 | 0 |
29511 | 29511 | 2020-04-03 | Covington | Mississippi | 28031 | 4 | 0 |
31891 | 31891 | 2020-04-04 | Covington | Mississippi | 28031 | 4 | 0 |
34318 | 34318 | 2020-04-05 | Covington | Mississippi | 28031 | 6 | 0 |
36780 | 36780 | 2020-04-06 | Covington | Mississippi | 28031 | 6 | 0 |
39291 | 39291 | 2020-04-07 | Covington | Mississippi | 28031 | 7 | 0 |
41845 | 41845 | 2020-04-08 | Covington | Mississippi | 28031 | 7 | 0 |
44421 | 44421 | 2020-04-09 | Covington | Mississippi | 28031 | 7 | 0 |
47030 | 47030 | 2020-04-10 | Covington | Mississippi | 28031 | 8 | 0 |
49676 | 49676 | 2020-04-11 | Covington | Mississippi | 28031 | 12 | 0 |
52349 | 52349 | 2020-04-12 | Covington | Mississippi | 28031 | 14 | 0 |
55031 | 55031 | 2020-04-13 | Covington | Mississippi | 28031 | 15 | 0 |
57729 | 57729 | 2020-04-14 | Covington | Mississippi | 28031 | 15 | 0 |
60440 | 60440 | 2020-04-15 | Covington | Mississippi | 28031 | 19 | 0 |
63162 | 63162 | 2020-04-16 | Covington | Mississippi | 28031 | 19 | 0 |
65902 | 65902 | 2020-04-17 | Covington | Mississippi | 28031 | 22 | 0 |
68654 | 68654 | 2020-04-18 | Covington | Mississippi | 28031 | 28 | 0 |
71420 | 71420 | 2020-04-19 | Covington | Mississippi | 28031 | 29 | 0 |
74193 | 74193 | 2020-04-20 | Covington | Mississippi | 28031 | 33 | 0 |
76974 | 76974 | 2020-04-21 | Covington | Mississippi | 28031 | 37 | 0 |
79759 | 79759 | 2020-04-22 | Covington | Mississippi | 28031 | 38 | 0 |
82555 | 82555 | 2020-04-23 | Covington | Mississippi | 28031 | 40 | 0 |
85359 | 85359 | 2020-04-24 | Covington | Mississippi | 28031 | 43 | 0 |
88169 | 88169 | 2020-04-25 | Covington | Mississippi | 28031 | 45 | 0 |
90985 | 90985 | 2020-04-26 | Covington | Mississippi | 28031 | 50 | 0 |
93806 | 93806 | 2020-04-27 | Covington | Mississippi | 28031 | 51 | 0 |
96642 | 96642 | 2020-04-28 | Covington | Mississippi | 28031 | 54 | 0 |
99488 | 99488 | 2020-04-29 | Covington | Mississippi | 28031 | 55 | 0 |
102340 | 102340 | 2020-04-30 | Covington | Mississippi | 28031 | 62 | 0 |
105201 | 105201 | 2020-05-01 | Covington | Mississippi | 28031 | 67 | 0 |
108066 | 108066 | 2020-05-02 | Covington | Mississippi | 28031 | 67 | 0 |
110937 | 110937 | 2020-05-03 | Covington | Mississippi | 28031 | 66 | 0 |
113816 | 113816 | 2020-05-04 | Covington | Mississippi | 28031 | 74 | 0 |
116698 | 116698 | 2020-05-05 | Covington | Mississippi | 28031 | 84 | 0 |
119658 | 119658 | 2020-05-06 | Covington | Mississippi | 28031 | 82 | 0 |
122632 | 122632 | 2020-05-07 | Covington | Mississippi | 28031 | 84 | 0 |
125614 | 125614 | 2020-05-08 | Covington | Mississippi | 28031 | 88 | 1 |
128601 | 128601 | 2020-05-09 | Covington | Mississippi | 28031 | 89 | 1 |
131591 | 131591 | 2020-05-10 | Covington | Mississippi | 28031 | 90 | 1 |
134582 | 134582 | 2020-05-11 | Covington | Mississippi | 28031 | 93 | 1 |
137572 | 137572 | 2020-05-12 | Covington | Mississippi | 28031 | 100 | 1 |
140566 | 140566 | 2020-05-13 | Covington | Mississippi | 28031 | 99 | 1 |
143561 | 143561 | 2020-05-14 | Covington | Mississippi | 28031 | 101 | 1 |
146561 | 146561 | 2020-05-15 | Covington | Mississippi | 28031 | 104 | 0 |
149566 | 149566 | 2020-05-16 | Covington | Mississippi | 28031 | 105 | 0 |
152577 | 152577 | 2020-05-17 | Covington | Mississippi | 28031 | 105 | 0 |
155591 | 155591 | 2020-05-18 | Covington | Mississippi | 28031 | 108 | 0 |
158609 | 158609 | 2020-05-19 | Covington | Mississippi | 28031 | 110 | 1 |
161635 | 161635 | 2020-05-20 | Covington | Mississippi | 28031 | 117 | 1 |
164664 | 164664 | 2020-05-21 | Covington | Mississippi | 28031 | 123 | 1 |
167700 | 167700 | 2020-05-22 | Covington | Mississippi | 28031 | 125 | 1 |
170738 | 170738 | 2020-05-23 | Covington | Mississippi | 28031 | 127 | 1 |
173780 | 173780 | 2020-05-24 | Covington | Mississippi | 28031 | 127 | 1 |
176823 | 176823 | 2020-05-25 | Covington | Mississippi | 28031 | 131 | 1 |
179867 | 179867 | 2020-05-26 | Covington | Mississippi | 28031 | 140 | 1 |
182913 | 182913 | 2020-05-27 | Covington | Mississippi | 28031 | 141 | 1 |
185969 | 185969 | 2020-05-28 | Covington | Mississippi | 28031 | 143 | 1 |
189027 | 189027 | 2020-05-29 | Covington | Mississippi | 28031 | 159 | 2 |
192091 | 192091 | 2020-05-30 | Covington | Mississippi | 28031 | 165 | 2 |
195159 | 195159 | 2020-05-31 | Covington | Mississippi | 28031 | 164 | 2 |
198230 | 198230 | 2020-06-01 | Covington | Mississippi | 28031 | 173 | 2 |
201303 | 201303 | 2020-06-02 | Covington | Mississippi | 28031 | 173 | 2 |
204380 | 204380 | 2020-06-03 | Covington | Mississippi | 28031 | 177 | 2 |
207461 | 207461 | 2020-06-04 | Covington | Mississippi | 28031 | 179 | 2 |
210542 | 210542 | 2020-06-05 | Covington | Mississippi | 28031 | 183 | 2 |
213626 | 213626 | 2020-06-06 | Covington | Mississippi | 28031 | 186 | 2 |
216714 | 216714 | 2020-06-07 | Covington | Mississippi | 28031 | 188 | 2 |
219806 | 219806 | 2020-06-08 | Covington | Mississippi | 28031 | 190 | 2 |
222901 | 222901 | 2020-06-09 | Covington | Mississippi | 28031 | 189 | 2 |
225999 | 225999 | 2020-06-10 | Covington | Mississippi | 28031 | 200 | 2 |
229101 | 229101 | 2020-06-11 | Covington | Mississippi | 28031 | 200 | 2 |
232205 | 232205 | 2020-06-12 | Covington | Mississippi | 28031 | 201 | 2 |
235311 | 235311 | 2020-06-13 | Covington | Mississippi | 28031 | 203 | 3 |
238418 | 238418 | 2020-06-14 | Covington | Mississippi | 28031 | 205 | 3 |
241527 | 241527 | 2020-06-15 | Covington | Mississippi | 28031 | 206 | 3 |
244638 | 244638 | 2020-06-16 | Covington | Mississippi | 28031 | 209 | 3 |
247751 | 247751 | 2020-06-17 | Covington | Mississippi | 28031 | 213 | 3 |
250863 | 250863 | 2020-06-18 | Covington | Mississippi | 28031 | 213 | 3 |
253978 | 253978 | 2020-06-19 | Covington | Mississippi | 28031 | 213 | 3 |
257098 | 257098 | 2020-06-20 | Covington | Mississippi | 28031 | 213 | 3 |
260224 | 260224 | 2020-06-21 | Covington | Mississippi | 28031 | 213 | 3 |
263353 | 263353 | 2020-06-22 | Covington | Mississippi | 28031 | 238 | 3 |
266479 | 266479 | 2020-06-23 | Covington | Mississippi | 28031 | 246 | 5 |
269612 | 269612 | 2020-06-24 | Covington | Mississippi | 28031 | 248 | 5 |
272749 | 272749 | 2020-06-25 | Covington | Mississippi | 28031 | 253 | 5 |
275892 | 275892 | 2020-06-26 | Covington | Mississippi | 28031 | 256 | 5 |
279040 | 279040 | 2020-06-27 | Covington | Mississippi | 28031 | 264 | 5 |
282188 | 282188 | 2020-06-28 | Covington | Mississippi | 28031 | 268 | 5 |
285333 | 285333 | 2020-06-29 | Covington | Mississippi | 28031 | 269 | 5 |
288483 | 288483 | 2020-06-30 | Covington | Mississippi | 28031 | 290 | 5 |
291634 | 291634 | 2020-07-01 | Covington | Mississippi | 28031 | 302 | 5 |
294788 | 294788 | 2020-07-02 | Covington | Mississippi | 28031 | 317 | 5 |
297946 | 297946 | 2020-07-03 | Covington | Mississippi | 28031 | 334 | 5 |
301109 | 301109 | 2020-07-04 | Covington | Mississippi | 28031 | 347 | 5 |
304273 | 304273 | 2020-07-05 | Covington | Mississippi | 28031 | 356 | 5 |
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);