ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 28113 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387403 | 387403 | 2020-07-31 | Pike | Mississippi | 28113 | 808 | 30 |
384185 | 384185 | 2020-07-30 | Pike | Mississippi | 28113 | 803 | 30 |
380968 | 380968 | 2020-07-29 | Pike | Mississippi | 28113 | 781 | 30 |
377751 | 377751 | 2020-07-28 | Pike | Mississippi | 28113 | 751 | 29 |
374536 | 374536 | 2020-07-27 | Pike | Mississippi | 28113 | 730 | 28 |
371324 | 371324 | 2020-07-26 | Pike | Mississippi | 28113 | 720 | 29 |
368114 | 368114 | 2020-07-25 | Pike | Mississippi | 28113 | 703 | 28 |
364906 | 364906 | 2020-07-24 | Pike | Mississippi | 28113 | 685 | 28 |
361699 | 361699 | 2020-07-23 | Pike | Mississippi | 28113 | 664 | 27 |
358494 | 358494 | 2020-07-22 | Pike | Mississippi | 28113 | 649 | 26 |
355291 | 355291 | 2020-07-21 | Pike | Mississippi | 28113 | 624 | 25 |
352089 | 352089 | 2020-07-20 | Pike | Mississippi | 28113 | 596 | 25 |
348889 | 348889 | 2020-07-19 | Pike | Mississippi | 28113 | 582 | 25 |
345688 | 345688 | 2020-07-18 | Pike | Mississippi | 28113 | 576 | 25 |
342488 | 342488 | 2020-07-17 | Pike | Mississippi | 28113 | 562 | 25 |
339292 | 339292 | 2020-07-16 | Pike | Mississippi | 28113 | 553 | 24 |
336096 | 336096 | 2020-07-15 | Pike | Mississippi | 28113 | 537 | 24 |
332903 | 332903 | 2020-07-14 | Pike | Mississippi | 28113 | 528 | 21 |
329716 | 329716 | 2020-07-13 | Pike | Mississippi | 28113 | 511 | 20 |
326530 | 326530 | 2020-07-12 | Pike | Mississippi | 28113 | 505 | 20 |
323347 | 323347 | 2020-07-11 | Pike | Mississippi | 28113 | 499 | 20 |
320168 | 320168 | 2020-07-10 | Pike | Mississippi | 28113 | 488 | 20 |
316993 | 316993 | 2020-07-09 | Pike | Mississippi | 28113 | 470 | 20 |
313819 | 313819 | 2020-07-08 | Pike | Mississippi | 28113 | 466 | 17 |
310649 | 310649 | 2020-07-07 | Pike | Mississippi | 28113 | 454 | 16 |
307481 | 307481 | 2020-07-06 | Pike | Mississippi | 28113 | 441 | 12 |
304314 | 304314 | 2020-07-05 | Pike | Mississippi | 28113 | 431 | 12 |
301150 | 301150 | 2020-07-04 | Pike | Mississippi | 28113 | 431 | 12 |
297987 | 297987 | 2020-07-03 | Pike | Mississippi | 28113 | 407 | 12 |
294829 | 294829 | 2020-07-02 | Pike | Mississippi | 28113 | 393 | 12 |
291675 | 291675 | 2020-07-01 | Pike | Mississippi | 28113 | 367 | 12 |
288524 | 288524 | 2020-06-30 | Pike | Mississippi | 28113 | 356 | 12 |
285374 | 285374 | 2020-06-29 | Pike | Mississippi | 28113 | 347 | 11 |
282229 | 282229 | 2020-06-28 | Pike | Mississippi | 28113 | 334 | 11 |
279081 | 279081 | 2020-06-27 | Pike | Mississippi | 28113 | 331 | 11 |
275933 | 275933 | 2020-06-26 | Pike | Mississippi | 28113 | 328 | 11 |
272790 | 272790 | 2020-06-25 | Pike | Mississippi | 28113 | 321 | 11 |
269652 | 269652 | 2020-06-24 | Pike | Mississippi | 28113 | 298 | 11 |
266519 | 266519 | 2020-06-23 | Pike | Mississippi | 28113 | 289 | 11 |
263393 | 263393 | 2020-06-22 | Pike | Mississippi | 28113 | 278 | 11 |
260264 | 260264 | 2020-06-21 | Pike | Mississippi | 28113 | 248 | 11 |
257138 | 257138 | 2020-06-20 | Pike | Mississippi | 28113 | 248 | 11 |
254018 | 254018 | 2020-06-19 | Pike | Mississippi | 28113 | 248 | 11 |
250903 | 250903 | 2020-06-18 | Pike | Mississippi | 28113 | 248 | 11 |
247791 | 247791 | 2020-06-17 | Pike | Mississippi | 28113 | 248 | 11 |
244678 | 244678 | 2020-06-16 | Pike | Mississippi | 28113 | 247 | 11 |
241567 | 241567 | 2020-06-15 | Pike | Mississippi | 28113 | 244 | 11 |
238458 | 238458 | 2020-06-14 | Pike | Mississippi | 28113 | 226 | 11 |
235351 | 235351 | 2020-06-13 | Pike | Mississippi | 28113 | 224 | 11 |
232245 | 232245 | 2020-06-12 | Pike | Mississippi | 28113 | 220 | 11 |
229141 | 229141 | 2020-06-11 | Pike | Mississippi | 28113 | 213 | 11 |
226039 | 226039 | 2020-06-10 | Pike | Mississippi | 28113 | 213 | 11 |
222941 | 222941 | 2020-06-09 | Pike | Mississippi | 28113 | 211 | 11 |
219846 | 219846 | 2020-06-08 | Pike | Mississippi | 28113 | 211 | 11 |
216754 | 216754 | 2020-06-07 | Pike | Mississippi | 28113 | 207 | 11 |
213666 | 213666 | 2020-06-06 | Pike | Mississippi | 28113 | 204 | 11 |
210582 | 210582 | 2020-06-05 | Pike | Mississippi | 28113 | 204 | 11 |
207501 | 207501 | 2020-06-04 | Pike | Mississippi | 28113 | 204 | 11 |
204420 | 204420 | 2020-06-03 | Pike | Mississippi | 28113 | 205 | 11 |
201343 | 201343 | 2020-06-02 | Pike | Mississippi | 28113 | 204 | 11 |
198270 | 198270 | 2020-06-01 | Pike | Mississippi | 28113 | 203 | 11 |
195199 | 195199 | 2020-05-31 | Pike | Mississippi | 28113 | 203 | 11 |
192131 | 192131 | 2020-05-30 | Pike | Mississippi | 28113 | 202 | 11 |
189067 | 189067 | 2020-05-29 | Pike | Mississippi | 28113 | 202 | 11 |
186009 | 186009 | 2020-05-28 | Pike | Mississippi | 28113 | 203 | 11 |
182953 | 182953 | 2020-05-27 | Pike | Mississippi | 28113 | 202 | 11 |
179907 | 179907 | 2020-05-26 | Pike | Mississippi | 28113 | 201 | 11 |
176863 | 176863 | 2020-05-25 | Pike | Mississippi | 28113 | 200 | 11 |
173820 | 173820 | 2020-05-24 | Pike | Mississippi | 28113 | 196 | 11 |
170778 | 170778 | 2020-05-23 | Pike | Mississippi | 28113 | 194 | 11 |
167740 | 167740 | 2020-05-22 | Pike | Mississippi | 28113 | 190 | 11 |
164704 | 164704 | 2020-05-21 | Pike | Mississippi | 28113 | 188 | 11 |
161675 | 161675 | 2020-05-20 | Pike | Mississippi | 28113 | 186 | 11 |
158649 | 158649 | 2020-05-19 | Pike | Mississippi | 28113 | 184 | 11 |
155631 | 155631 | 2020-05-18 | Pike | Mississippi | 28113 | 178 | 11 |
152617 | 152617 | 2020-05-17 | Pike | Mississippi | 28113 | 176 | 11 |
149606 | 149606 | 2020-05-16 | Pike | Mississippi | 28113 | 176 | 11 |
146601 | 146601 | 2020-05-15 | Pike | Mississippi | 28113 | 174 | 10 |
143601 | 143601 | 2020-05-14 | Pike | Mississippi | 28113 | 173 | 10 |
140606 | 140606 | 2020-05-13 | Pike | Mississippi | 28113 | 173 | 10 |
137612 | 137612 | 2020-05-12 | Pike | Mississippi | 28113 | 173 | 10 |
134622 | 134622 | 2020-05-11 | Pike | Mississippi | 28113 | 170 | 10 |
131631 | 131631 | 2020-05-10 | Pike | Mississippi | 28113 | 168 | 10 |
128641 | 128641 | 2020-05-09 | Pike | Mississippi | 28113 | 168 | 10 |
125654 | 125654 | 2020-05-08 | Pike | Mississippi | 28113 | 163 | 10 |
122672 | 122672 | 2020-05-07 | Pike | Mississippi | 28113 | 162 | 9 |
119698 | 119698 | 2020-05-06 | Pike | Mississippi | 28113 | 159 | 9 |
116738 | 116738 | 2020-05-05 | Pike | Mississippi | 28113 | 160 | 9 |
113856 | 113856 | 2020-05-04 | Pike | Mississippi | 28113 | 155 | 7 |
110977 | 110977 | 2020-05-03 | Pike | Mississippi | 28113 | 155 | 7 |
108106 | 108106 | 2020-05-02 | Pike | Mississippi | 28113 | 153 | 7 |
105241 | 105241 | 2020-05-01 | Pike | Mississippi | 28113 | 149 | 7 |
102380 | 102380 | 2020-04-30 | Pike | Mississippi | 28113 | 148 | 7 |
99528 | 99528 | 2020-04-29 | Pike | Mississippi | 28113 | 143 | 7 |
96682 | 96682 | 2020-04-28 | Pike | Mississippi | 28113 | 142 | 7 |
93846 | 93846 | 2020-04-27 | Pike | Mississippi | 28113 | 136 | 5 |
91025 | 91025 | 2020-04-26 | Pike | Mississippi | 28113 | 136 | 5 |
88209 | 88209 | 2020-04-25 | Pike | Mississippi | 28113 | 133 | 5 |
85399 | 85399 | 2020-04-24 | Pike | Mississippi | 28113 | 127 | 4 |
82595 | 82595 | 2020-04-23 | Pike | Mississippi | 28113 | 126 | 3 |
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);