ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
50 rows where deaths = 14, fips = 28131 and state = "Mississippi" 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 |
---|---|---|---|---|---|---|---|
775877 | 775877 | 2020-11-28 | Stone | Mississippi | 28131 | 770 | 14 |
772632 | 772632 | 2020-11-27 | Stone | Mississippi | 28131 | 761 | 14 |
769387 | 769387 | 2020-11-26 | Stone | Mississippi | 28131 | 752 | 14 |
766141 | 766141 | 2020-11-25 | Stone | Mississippi | 28131 | 731 | 14 |
762896 | 762896 | 2020-11-24 | Stone | Mississippi | 28131 | 724 | 14 |
759651 | 759651 | 2020-11-23 | Stone | Mississippi | 28131 | 723 | 14 |
756404 | 756404 | 2020-11-22 | Stone | Mississippi | 28131 | 710 | 14 |
753158 | 753158 | 2020-11-21 | Stone | Mississippi | 28131 | 704 | 14 |
749912 | 749912 | 2020-11-20 | Stone | Mississippi | 28131 | 687 | 14 |
746666 | 746666 | 2020-11-19 | Stone | Mississippi | 28131 | 663 | 14 |
743419 | 743419 | 2020-11-18 | Stone | Mississippi | 28131 | 652 | 14 |
740172 | 740172 | 2020-11-17 | Stone | Mississippi | 28131 | 636 | 14 |
736928 | 736928 | 2020-11-16 | Stone | Mississippi | 28131 | 632 | 14 |
733682 | 733682 | 2020-11-15 | Stone | Mississippi | 28131 | 629 | 14 |
730437 | 730437 | 2020-11-14 | Stone | Mississippi | 28131 | 621 | 14 |
727194 | 727194 | 2020-11-13 | Stone | Mississippi | 28131 | 608 | 14 |
723951 | 723951 | 2020-11-12 | Stone | Mississippi | 28131 | 598 | 14 |
720708 | 720708 | 2020-11-11 | Stone | Mississippi | 28131 | 580 | 14 |
717465 | 717465 | 2020-11-10 | Stone | Mississippi | 28131 | 569 | 14 |
714221 | 714221 | 2020-11-09 | Stone | Mississippi | 28131 | 563 | 14 |
710977 | 710977 | 2020-11-08 | Stone | Mississippi | 28131 | 558 | 14 |
707733 | 707733 | 2020-11-07 | Stone | Mississippi | 28131 | 554 | 14 |
704490 | 704490 | 2020-11-06 | Stone | Mississippi | 28131 | 540 | 14 |
701248 | 701248 | 2020-11-05 | Stone | Mississippi | 28131 | 531 | 14 |
698004 | 698004 | 2020-11-04 | Stone | Mississippi | 28131 | 522 | 14 |
694761 | 694761 | 2020-11-03 | Stone | Mississippi | 28131 | 519 | 14 |
691519 | 691519 | 2020-11-02 | Stone | Mississippi | 28131 | 513 | 14 |
688274 | 688274 | 2020-11-01 | Stone | Mississippi | 28131 | 510 | 14 |
685030 | 685030 | 2020-10-31 | Stone | Mississippi | 28131 | 507 | 14 |
681787 | 681787 | 2020-10-30 | Stone | Mississippi | 28131 | 506 | 14 |
678543 | 678543 | 2020-10-29 | Stone | Mississippi | 28131 | 498 | 14 |
675301 | 675301 | 2020-10-28 | Stone | Mississippi | 28131 | 491 | 14 |
672058 | 672058 | 2020-10-27 | Stone | Mississippi | 28131 | 486 | 14 |
668816 | 668816 | 2020-10-26 | Stone | Mississippi | 28131 | 477 | 14 |
665572 | 665572 | 2020-10-25 | Stone | Mississippi | 28131 | 475 | 14 |
662327 | 662327 | 2020-10-24 | Stone | Mississippi | 28131 | 475 | 14 |
659083 | 659083 | 2020-10-23 | Stone | Mississippi | 28131 | 464 | 14 |
655838 | 655838 | 2020-10-22 | Stone | Mississippi | 28131 | 462 | 14 |
652593 | 652593 | 2020-10-21 | Stone | Mississippi | 28131 | 455 | 14 |
649348 | 649348 | 2020-10-20 | Stone | Mississippi | 28131 | 450 | 14 |
646104 | 646104 | 2020-10-19 | Stone | Mississippi | 28131 | 450 | 14 |
642857 | 642857 | 2020-10-18 | Stone | Mississippi | 28131 | 446 | 14 |
639610 | 639610 | 2020-10-17 | Stone | Mississippi | 28131 | 446 | 14 |
636364 | 636364 | 2020-10-16 | Stone | Mississippi | 28131 | 443 | 14 |
633118 | 633118 | 2020-10-15 | Stone | Mississippi | 28131 | 437 | 14 |
629873 | 629873 | 2020-10-14 | Stone | Mississippi | 28131 | 433 | 14 |
626629 | 626629 | 2020-10-13 | Stone | Mississippi | 28131 | 424 | 14 |
623387 | 623387 | 2020-10-12 | Stone | Mississippi | 28131 | 422 | 14 |
620144 | 620144 | 2020-10-11 | Stone | Mississippi | 28131 | 421 | 14 |
616902 | 616902 | 2020-10-10 | Stone | Mississippi | 28131 | 419 | 14 |
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);