ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
43 rows where deaths = 19 and fips = 28159 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 |
---|---|---|---|---|---|---|---|
607191 | 607191 | 2020-10-07 | Winston | Mississippi | 28159 | 771 | 19 |
603948 | 603948 | 2020-10-06 | Winston | Mississippi | 28159 | 765 | 19 |
600706 | 600706 | 2020-10-05 | Winston | Mississippi | 28159 | 763 | 19 |
597463 | 597463 | 2020-10-04 | Winston | Mississippi | 28159 | 763 | 19 |
594222 | 594222 | 2020-10-03 | Winston | Mississippi | 28159 | 760 | 19 |
590981 | 590981 | 2020-10-02 | Winston | Mississippi | 28159 | 752 | 19 |
587740 | 587740 | 2020-10-01 | Winston | Mississippi | 28159 | 749 | 19 |
584500 | 584500 | 2020-09-30 | Winston | Mississippi | 28159 | 746 | 19 |
581259 | 581259 | 2020-09-29 | Winston | Mississippi | 28159 | 746 | 19 |
578018 | 578018 | 2020-09-28 | Winston | Mississippi | 28159 | 742 | 19 |
574777 | 574777 | 2020-09-27 | Winston | Mississippi | 28159 | 742 | 19 |
571534 | 571534 | 2020-09-26 | Winston | Mississippi | 28159 | 742 | 19 |
568292 | 568292 | 2020-09-25 | Winston | Mississippi | 28159 | 738 | 19 |
565052 | 565052 | 2020-09-24 | Winston | Mississippi | 28159 | 737 | 19 |
561812 | 561812 | 2020-09-23 | Winston | Mississippi | 28159 | 735 | 19 |
558575 | 558575 | 2020-09-22 | Winston | Mississippi | 28159 | 731 | 19 |
555338 | 555338 | 2020-09-21 | Winston | Mississippi | 28159 | 725 | 19 |
552100 | 552100 | 2020-09-20 | Winston | Mississippi | 28159 | 724 | 19 |
548861 | 548861 | 2020-09-19 | Winston | Mississippi | 28159 | 723 | 19 |
545623 | 545623 | 2020-09-18 | Winston | Mississippi | 28159 | 720 | 19 |
542386 | 542386 | 2020-09-17 | Winston | Mississippi | 28159 | 719 | 19 |
539150 | 539150 | 2020-09-16 | Winston | Mississippi | 28159 | 718 | 19 |
535913 | 535913 | 2020-09-15 | Winston | Mississippi | 28159 | 718 | 19 |
532678 | 532678 | 2020-09-14 | Winston | Mississippi | 28159 | 717 | 19 |
529442 | 529442 | 2020-09-13 | Winston | Mississippi | 28159 | 717 | 19 |
526206 | 526206 | 2020-09-12 | Winston | Mississippi | 28159 | 715 | 19 |
522970 | 522970 | 2020-09-11 | Winston | Mississippi | 28159 | 712 | 19 |
519733 | 519733 | 2020-09-10 | Winston | Mississippi | 28159 | 710 | 19 |
516498 | 516498 | 2020-09-09 | Winston | Mississippi | 28159 | 710 | 19 |
513264 | 513264 | 2020-09-08 | Winston | Mississippi | 28159 | 710 | 19 |
510032 | 510032 | 2020-09-07 | Winston | Mississippi | 28159 | 709 | 19 |
506799 | 506799 | 2020-09-06 | Winston | Mississippi | 28159 | 709 | 19 |
503566 | 503566 | 2020-09-05 | Winston | Mississippi | 28159 | 709 | 19 |
500332 | 500332 | 2020-09-04 | Winston | Mississippi | 28159 | 708 | 19 |
497098 | 497098 | 2020-09-03 | Winston | Mississippi | 28159 | 704 | 19 |
493865 | 493865 | 2020-09-02 | Winston | Mississippi | 28159 | 701 | 19 |
490631 | 490631 | 2020-09-01 | Winston | Mississippi | 28159 | 696 | 19 |
487398 | 487398 | 2020-08-31 | Winston | Mississippi | 28159 | 695 | 19 |
484164 | 484164 | 2020-08-30 | Winston | Mississippi | 28159 | 694 | 19 |
480929 | 480929 | 2020-08-29 | Winston | Mississippi | 28159 | 691 | 19 |
477697 | 477697 | 2020-08-28 | Winston | Mississippi | 28159 | 690 | 19 |
474464 | 474464 | 2020-08-27 | Winston | Mississippi | 28159 | 688 | 19 |
471232 | 471232 | 2020-08-26 | Winston | Mississippi | 28159 | 691 | 19 |
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);