ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 28083 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387388 | 387388 | 2020-07-31 | Leflore | Mississippi | 28083 | 814 | 59 |
384170 | 384170 | 2020-07-30 | Leflore | Mississippi | 28083 | 791 | 59 |
380953 | 380953 | 2020-07-29 | Leflore | Mississippi | 28083 | 785 | 57 |
377736 | 377736 | 2020-07-28 | Leflore | Mississippi | 28083 | 767 | 57 |
374521 | 374521 | 2020-07-27 | Leflore | Mississippi | 28083 | 736 | 57 |
371309 | 371309 | 2020-07-26 | Leflore | Mississippi | 28083 | 735 | 57 |
368099 | 368099 | 2020-07-25 | Leflore | Mississippi | 28083 | 719 | 57 |
364891 | 364891 | 2020-07-24 | Leflore | Mississippi | 28083 | 708 | 57 |
361684 | 361684 | 2020-07-23 | Leflore | Mississippi | 28083 | 691 | 57 |
358479 | 358479 | 2020-07-22 | Leflore | Mississippi | 28083 | 681 | 57 |
355276 | 355276 | 2020-07-21 | Leflore | Mississippi | 28083 | 663 | 56 |
352074 | 352074 | 2020-07-20 | Leflore | Mississippi | 28083 | 648 | 56 |
348874 | 348874 | 2020-07-19 | Leflore | Mississippi | 28083 | 632 | 56 |
345673 | 345673 | 2020-07-18 | Leflore | Mississippi | 28083 | 628 | 56 |
342473 | 342473 | 2020-07-17 | Leflore | Mississippi | 28083 | 612 | 56 |
339277 | 339277 | 2020-07-16 | Leflore | Mississippi | 28083 | 601 | 56 |
336081 | 336081 | 2020-07-15 | Leflore | Mississippi | 28083 | 588 | 56 |
332888 | 332888 | 2020-07-14 | Leflore | Mississippi | 28083 | 569 | 56 |
329701 | 329701 | 2020-07-13 | Leflore | Mississippi | 28083 | 539 | 56 |
326515 | 326515 | 2020-07-12 | Leflore | Mississippi | 28083 | 534 | 56 |
323332 | 323332 | 2020-07-11 | Leflore | Mississippi | 28083 | 531 | 56 |
320153 | 320153 | 2020-07-10 | Leflore | Mississippi | 28083 | 528 | 56 |
316978 | 316978 | 2020-07-09 | Leflore | Mississippi | 28083 | 522 | 56 |
313804 | 313804 | 2020-07-08 | Leflore | Mississippi | 28083 | 507 | 56 |
310634 | 310634 | 2020-07-07 | Leflore | Mississippi | 28083 | 500 | 53 |
307466 | 307466 | 2020-07-06 | Leflore | Mississippi | 28083 | 491 | 51 |
304299 | 304299 | 2020-07-05 | Leflore | Mississippi | 28083 | 487 | 51 |
301135 | 301135 | 2020-07-04 | Leflore | Mississippi | 28083 | 486 | 51 |
297972 | 297972 | 2020-07-03 | Leflore | Mississippi | 28083 | 480 | 49 |
294814 | 294814 | 2020-07-02 | Leflore | Mississippi | 28083 | 474 | 49 |
291660 | 291660 | 2020-07-01 | Leflore | Mississippi | 28083 | 472 | 49 |
288509 | 288509 | 2020-06-30 | Leflore | Mississippi | 28083 | 469 | 48 |
285359 | 285359 | 2020-06-29 | Leflore | Mississippi | 28083 | 455 | 48 |
282214 | 282214 | 2020-06-28 | Leflore | Mississippi | 28083 | 454 | 48 |
279066 | 279066 | 2020-06-27 | Leflore | Mississippi | 28083 | 449 | 48 |
275918 | 275918 | 2020-06-26 | Leflore | Mississippi | 28083 | 441 | 48 |
272775 | 272775 | 2020-06-25 | Leflore | Mississippi | 28083 | 439 | 48 |
269637 | 269637 | 2020-06-24 | Leflore | Mississippi | 28083 | 434 | 48 |
266504 | 266504 | 2020-06-23 | Leflore | Mississippi | 28083 | 430 | 48 |
263378 | 263378 | 2020-06-22 | Leflore | Mississippi | 28083 | 420 | 47 |
260249 | 260249 | 2020-06-21 | Leflore | Mississippi | 28083 | 385 | 47 |
257123 | 257123 | 2020-06-20 | Leflore | Mississippi | 28083 | 385 | 47 |
254003 | 254003 | 2020-06-19 | Leflore | Mississippi | 28083 | 385 | 47 |
250888 | 250888 | 2020-06-18 | Leflore | Mississippi | 28083 | 385 | 47 |
247776 | 247776 | 2020-06-17 | Leflore | Mississippi | 28083 | 385 | 47 |
244663 | 244663 | 2020-06-16 | Leflore | Mississippi | 28083 | 376 | 45 |
241552 | 241552 | 2020-06-15 | Leflore | Mississippi | 28083 | 368 | 45 |
238443 | 238443 | 2020-06-14 | Leflore | Mississippi | 28083 | 358 | 45 |
235336 | 235336 | 2020-06-13 | Leflore | Mississippi | 28083 | 352 | 45 |
232230 | 232230 | 2020-06-12 | Leflore | Mississippi | 28083 | 350 | 44 |
229126 | 229126 | 2020-06-11 | Leflore | Mississippi | 28083 | 330 | 44 |
226024 | 226024 | 2020-06-10 | Leflore | Mississippi | 28083 | 330 | 44 |
222926 | 222926 | 2020-06-09 | Leflore | Mississippi | 28083 | 322 | 43 |
219831 | 219831 | 2020-06-08 | Leflore | Mississippi | 28083 | 309 | 42 |
216739 | 216739 | 2020-06-07 | Leflore | Mississippi | 28083 | 288 | 40 |
213651 | 213651 | 2020-06-06 | Leflore | Mississippi | 28083 | 287 | 39 |
210567 | 210567 | 2020-06-05 | Leflore | Mississippi | 28083 | 282 | 38 |
207486 | 207486 | 2020-06-04 | Leflore | Mississippi | 28083 | 277 | 36 |
204405 | 204405 | 2020-06-03 | Leflore | Mississippi | 28083 | 273 | 36 |
201328 | 201328 | 2020-06-02 | Leflore | Mississippi | 28083 | 273 | 34 |
198255 | 198255 | 2020-06-01 | Leflore | Mississippi | 28083 | 265 | 32 |
195184 | 195184 | 2020-05-31 | Leflore | Mississippi | 28083 | 264 | 31 |
192116 | 192116 | 2020-05-30 | Leflore | Mississippi | 28083 | 258 | 31 |
189052 | 189052 | 2020-05-29 | Leflore | Mississippi | 28083 | 255 | 30 |
185994 | 185994 | 2020-05-28 | Leflore | Mississippi | 28083 | 251 | 30 |
182938 | 182938 | 2020-05-27 | Leflore | Mississippi | 28083 | 250 | 30 |
179892 | 179892 | 2020-05-26 | Leflore | Mississippi | 28083 | 246 | 27 |
176848 | 176848 | 2020-05-25 | Leflore | Mississippi | 28083 | 241 | 26 |
173805 | 173805 | 2020-05-24 | Leflore | Mississippi | 28083 | 239 | 25 |
170763 | 170763 | 2020-05-23 | Leflore | Mississippi | 28083 | 240 | 25 |
167725 | 167725 | 2020-05-22 | Leflore | Mississippi | 28083 | 211 | 25 |
164689 | 164689 | 2020-05-21 | Leflore | Mississippi | 28083 | 206 | 24 |
161660 | 161660 | 2020-05-20 | Leflore | Mississippi | 28083 | 205 | 23 |
158634 | 158634 | 2020-05-19 | Leflore | Mississippi | 28083 | 202 | 22 |
155616 | 155616 | 2020-05-18 | Leflore | Mississippi | 28083 | 200 | 22 |
152602 | 152602 | 2020-05-17 | Leflore | Mississippi | 28083 | 200 | 22 |
149591 | 149591 | 2020-05-16 | Leflore | Mississippi | 28083 | 200 | 22 |
146586 | 146586 | 2020-05-15 | Leflore | Mississippi | 28083 | 199 | 22 |
143586 | 143586 | 2020-05-14 | Leflore | Mississippi | 28083 | 197 | 22 |
140591 | 140591 | 2020-05-13 | Leflore | Mississippi | 28083 | 192 | 21 |
137597 | 137597 | 2020-05-12 | Leflore | Mississippi | 28083 | 191 | 20 |
134607 | 134607 | 2020-05-11 | Leflore | Mississippi | 28083 | 185 | 18 |
131616 | 131616 | 2020-05-10 | Leflore | Mississippi | 28083 | 185 | 18 |
128626 | 128626 | 2020-05-09 | Leflore | Mississippi | 28083 | 185 | 18 |
125639 | 125639 | 2020-05-08 | Leflore | Mississippi | 28083 | 182 | 18 |
122657 | 122657 | 2020-05-07 | Leflore | Mississippi | 28083 | 180 | 18 |
119683 | 119683 | 2020-05-06 | Leflore | Mississippi | 28083 | 177 | 18 |
116723 | 116723 | 2020-05-05 | Leflore | Mississippi | 28083 | 175 | 18 |
113841 | 113841 | 2020-05-04 | Leflore | Mississippi | 28083 | 174 | 17 |
110962 | 110962 | 2020-05-03 | Leflore | Mississippi | 28083 | 168 | 17 |
108091 | 108091 | 2020-05-02 | Leflore | Mississippi | 28083 | 165 | 17 |
105226 | 105226 | 2020-05-01 | Leflore | Mississippi | 28083 | 164 | 17 |
102365 | 102365 | 2020-04-30 | Leflore | Mississippi | 28083 | 148 | 17 |
99513 | 99513 | 2020-04-29 | Leflore | Mississippi | 28083 | 145 | 16 |
96667 | 96667 | 2020-04-28 | Leflore | Mississippi | 28083 | 141 | 15 |
93831 | 93831 | 2020-04-27 | Leflore | Mississippi | 28083 | 137 | 15 |
91010 | 91010 | 2020-04-26 | Leflore | Mississippi | 28083 | 136 | 15 |
88194 | 88194 | 2020-04-25 | Leflore | Mississippi | 28083 | 131 | 15 |
85384 | 85384 | 2020-04-24 | Leflore | Mississippi | 28083 | 124 | 14 |
82580 | 82580 | 2020-04-23 | Leflore | Mississippi | 28083 | 119 | 13 |
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);