ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Marion" and fips = 28091 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535879 | 535879 | 2020-09-15 | Marion | Mississippi | 28091 | 824 | 31 |
532644 | 532644 | 2020-09-14 | Marion | Mississippi | 28091 | 823 | 30 |
529408 | 529408 | 2020-09-13 | Marion | Mississippi | 28091 | 823 | 29 |
526172 | 526172 | 2020-09-12 | Marion | Mississippi | 28091 | 820 | 29 |
522936 | 522936 | 2020-09-11 | Marion | Mississippi | 28091 | 819 | 28 |
519699 | 519699 | 2020-09-10 | Marion | Mississippi | 28091 | 809 | 28 |
516464 | 516464 | 2020-09-09 | Marion | Mississippi | 28091 | 806 | 28 |
513230 | 513230 | 2020-09-08 | Marion | Mississippi | 28091 | 806 | 27 |
509998 | 509998 | 2020-09-07 | Marion | Mississippi | 28091 | 802 | 27 |
506765 | 506765 | 2020-09-06 | Marion | Mississippi | 28091 | 801 | 27 |
503532 | 503532 | 2020-09-05 | Marion | Mississippi | 28091 | 798 | 26 |
500298 | 500298 | 2020-09-04 | Marion | Mississippi | 28091 | 798 | 26 |
497064 | 497064 | 2020-09-03 | Marion | Mississippi | 28091 | 790 | 26 |
493831 | 493831 | 2020-09-02 | Marion | Mississippi | 28091 | 787 | 26 |
490597 | 490597 | 2020-09-01 | Marion | Mississippi | 28091 | 783 | 26 |
487364 | 487364 | 2020-08-31 | Marion | Mississippi | 28091 | 781 | 26 |
484130 | 484130 | 2020-08-30 | Marion | Mississippi | 28091 | 781 | 26 |
480895 | 480895 | 2020-08-29 | Marion | Mississippi | 28091 | 775 | 26 |
477663 | 477663 | 2020-08-28 | Marion | Mississippi | 28091 | 775 | 25 |
474430 | 474430 | 2020-08-27 | Marion | Mississippi | 28091 | 776 | 25 |
471198 | 471198 | 2020-08-26 | Marion | Mississippi | 28091 | 766 | 25 |
467968 | 467968 | 2020-08-25 | Marion | Mississippi | 28091 | 761 | 25 |
464739 | 464739 | 2020-08-24 | Marion | Mississippi | 28091 | 760 | 25 |
461508 | 461508 | 2020-08-23 | Marion | Mississippi | 28091 | 756 | 25 |
458281 | 458281 | 2020-08-22 | Marion | Mississippi | 28091 | 750 | 24 |
455053 | 455053 | 2020-08-21 | Marion | Mississippi | 28091 | 739 | 24 |
451825 | 451825 | 2020-08-20 | Marion | Mississippi | 28091 | 725 | 24 |
448597 | 448597 | 2020-08-19 | Marion | Mississippi | 28091 | 722 | 24 |
445371 | 445371 | 2020-08-18 | Marion | Mississippi | 28091 | 716 | 23 |
442145 | 442145 | 2020-08-17 | Marion | Mississippi | 28091 | 713 | 22 |
438918 | 438918 | 2020-08-16 | Marion | Mississippi | 28091 | 708 | 21 |
435693 | 435693 | 2020-08-15 | Marion | Mississippi | 28091 | 707 | 21 |
432467 | 432467 | 2020-08-14 | Marion | Mississippi | 28091 | 698 | 21 |
429240 | 429240 | 2020-08-13 | Marion | Mississippi | 28091 | 692 | 21 |
426016 | 426016 | 2020-08-12 | Marion | Mississippi | 28091 | 689 | 21 |
422794 | 422794 | 2020-08-11 | Marion | Mississippi | 28091 | 684 | 20 |
419572 | 419572 | 2020-08-10 | Marion | Mississippi | 28091 | 684 | 20 |
416351 | 416351 | 2020-08-09 | Marion | Mississippi | 28091 | 677 | 20 |
413131 | 413131 | 2020-08-08 | Marion | Mississippi | 28091 | 657 | 20 |
409911 | 409911 | 2020-08-07 | Marion | Mississippi | 28091 | 643 | 20 |
406691 | 406691 | 2020-08-06 | Marion | Mississippi | 28091 | 638 | 19 |
403473 | 403473 | 2020-08-05 | Marion | Mississippi | 28091 | 634 | 19 |
400256 | 400256 | 2020-08-04 | Marion | Mississippi | 28091 | 625 | 19 |
397042 | 397042 | 2020-08-03 | Marion | Mississippi | 28091 | 601 | 18 |
393826 | 393826 | 2020-08-02 | Marion | Mississippi | 28091 | 599 | 18 |
390609 | 390609 | 2020-08-01 | Marion | Mississippi | 28091 | 594 | 18 |
387392 | 387392 | 2020-07-31 | Marion | Mississippi | 28091 | 581 | 17 |
384174 | 384174 | 2020-07-30 | Marion | Mississippi | 28091 | 569 | 16 |
380957 | 380957 | 2020-07-29 | Marion | Mississippi | 28091 | 550 | 16 |
377740 | 377740 | 2020-07-28 | Marion | Mississippi | 28091 | 532 | 16 |
374525 | 374525 | 2020-07-27 | Marion | Mississippi | 28091 | 516 | 16 |
371313 | 371313 | 2020-07-26 | Marion | Mississippi | 28091 | 502 | 16 |
368103 | 368103 | 2020-07-25 | Marion | Mississippi | 28091 | 487 | 15 |
364895 | 364895 | 2020-07-24 | Marion | Mississippi | 28091 | 476 | 14 |
361688 | 361688 | 2020-07-23 | Marion | Mississippi | 28091 | 462 | 15 |
358483 | 358483 | 2020-07-22 | Marion | Mississippi | 28091 | 449 | 15 |
355280 | 355280 | 2020-07-21 | Marion | Mississippi | 28091 | 433 | 12 |
352078 | 352078 | 2020-07-20 | Marion | Mississippi | 28091 | 414 | 12 |
348878 | 348878 | 2020-07-19 | Marion | Mississippi | 28091 | 398 | 12 |
345677 | 345677 | 2020-07-18 | Marion | Mississippi | 28091 | 383 | 12 |
342477 | 342477 | 2020-07-17 | Marion | Mississippi | 28091 | 381 | 12 |
339281 | 339281 | 2020-07-16 | Marion | Mississippi | 28091 | 372 | 12 |
336085 | 336085 | 2020-07-15 | Marion | Mississippi | 28091 | 363 | 12 |
332892 | 332892 | 2020-07-14 | Marion | Mississippi | 28091 | 356 | 12 |
329705 | 329705 | 2020-07-13 | Marion | Mississippi | 28091 | 349 | 12 |
326519 | 326519 | 2020-07-12 | Marion | Mississippi | 28091 | 345 | 12 |
323336 | 323336 | 2020-07-11 | Marion | Mississippi | 28091 | 327 | 12 |
320157 | 320157 | 2020-07-10 | Marion | Mississippi | 28091 | 324 | 12 |
316982 | 316982 | 2020-07-09 | Marion | Mississippi | 28091 | 313 | 12 |
313808 | 313808 | 2020-07-08 | Marion | Mississippi | 28091 | 308 | 12 |
310638 | 310638 | 2020-07-07 | Marion | Mississippi | 28091 | 300 | 12 |
307470 | 307470 | 2020-07-06 | Marion | Mississippi | 28091 | 284 | 11 |
304303 | 304303 | 2020-07-05 | Marion | Mississippi | 28091 | 281 | 11 |
301139 | 301139 | 2020-07-04 | Marion | Mississippi | 28091 | 275 | 11 |
297976 | 297976 | 2020-07-03 | Marion | Mississippi | 28091 | 270 | 11 |
294818 | 294818 | 2020-07-02 | Marion | Mississippi | 28091 | 263 | 11 |
291664 | 291664 | 2020-07-01 | Marion | Mississippi | 28091 | 248 | 11 |
288513 | 288513 | 2020-06-30 | Marion | Mississippi | 28091 | 240 | 11 |
285363 | 285363 | 2020-06-29 | Marion | Mississippi | 28091 | 233 | 11 |
282218 | 282218 | 2020-06-28 | Marion | Mississippi | 28091 | 228 | 11 |
279070 | 279070 | 2020-06-27 | Marion | Mississippi | 28091 | 225 | 11 |
275922 | 275922 | 2020-06-26 | Marion | Mississippi | 28091 | 223 | 11 |
272779 | 272779 | 2020-06-25 | Marion | Mississippi | 28091 | 215 | 10 |
269641 | 269641 | 2020-06-24 | Marion | Mississippi | 28091 | 203 | 10 |
266508 | 266508 | 2020-06-23 | Marion | Mississippi | 28091 | 196 | 10 |
263382 | 263382 | 2020-06-22 | Marion | Mississippi | 28091 | 186 | 10 |
260253 | 260253 | 2020-06-21 | Marion | Mississippi | 28091 | 163 | 9 |
257127 | 257127 | 2020-06-20 | Marion | Mississippi | 28091 | 163 | 9 |
254007 | 254007 | 2020-06-19 | Marion | Mississippi | 28091 | 163 | 9 |
250892 | 250892 | 2020-06-18 | Marion | Mississippi | 28091 | 163 | 9 |
247780 | 247780 | 2020-06-17 | Marion | Mississippi | 28091 | 163 | 9 |
244667 | 244667 | 2020-06-16 | Marion | Mississippi | 28091 | 152 | 9 |
241556 | 241556 | 2020-06-15 | Marion | Mississippi | 28091 | 145 | 9 |
238447 | 238447 | 2020-06-14 | Marion | Mississippi | 28091 | 141 | 9 |
235340 | 235340 | 2020-06-13 | Marion | Mississippi | 28091 | 140 | 9 |
232234 | 232234 | 2020-06-12 | Marion | Mississippi | 28091 | 137 | 9 |
229130 | 229130 | 2020-06-11 | Marion | Mississippi | 28091 | 132 | 9 |
226028 | 226028 | 2020-06-10 | Marion | Mississippi | 28091 | 132 | 9 |
222930 | 222930 | 2020-06-09 | Marion | Mississippi | 28091 | 129 | 9 |
219835 | 219835 | 2020-06-08 | Marion | Mississippi | 28091 | 127 | 9 |
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);