ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Winston" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921931 | 921931 | 2021-01-12 | Winston | Mississippi | 28159 | 1948 | 59 |
918686 | 918686 | 2021-01-11 | Winston | Mississippi | 28159 | 1946 | 59 |
915441 | 915441 | 2021-01-10 | Winston | Mississippi | 28159 | 1945 | 59 |
912196 | 912196 | 2021-01-09 | Winston | Mississippi | 28159 | 1937 | 59 |
908951 | 908951 | 2021-01-08 | Winston | Mississippi | 28159 | 1927 | 58 |
905705 | 905705 | 2021-01-07 | Winston | Mississippi | 28159 | 1915 | 58 |
902460 | 902460 | 2021-01-06 | Winston | Mississippi | 28159 | 1899 | 58 |
899215 | 899215 | 2021-01-05 | Winston | Mississippi | 28159 | 1889 | 58 |
895970 | 895970 | 2021-01-04 | Winston | Mississippi | 28159 | 1886 | 53 |
892723 | 892723 | 2021-01-03 | Winston | Mississippi | 28159 | 1872 | 52 |
889477 | 889477 | 2021-01-02 | Winston | Mississippi | 28159 | 1861 | 52 |
886231 | 886231 | 2021-01-01 | Winston | Mississippi | 28159 | 1854 | 51 |
882986 | 882986 | 2020-12-31 | Winston | Mississippi | 28159 | 1834 | 50 |
879741 | 879741 | 2020-12-30 | Winston | Mississippi | 28159 | 1825 | 48 |
876496 | 876496 | 2020-12-29 | Winston | Mississippi | 28159 | 1808 | 48 |
873251 | 873251 | 2020-12-28 | Winston | Mississippi | 28159 | 1802 | 47 |
870006 | 870006 | 2020-12-27 | Winston | Mississippi | 28159 | 1775 | 46 |
866761 | 866761 | 2020-12-26 | Winston | Mississippi | 28159 | 1753 | 44 |
863516 | 863516 | 2020-12-25 | Winston | Mississippi | 28159 | 1746 | 44 |
860271 | 860271 | 2020-12-24 | Winston | Mississippi | 28159 | 1739 | 44 |
857026 | 857026 | 2020-12-23 | Winston | Mississippi | 28159 | 1716 | 44 |
853781 | 853781 | 2020-12-22 | Winston | Mississippi | 28159 | 1674 | 44 |
850536 | 850536 | 2020-12-21 | Winston | Mississippi | 28159 | 1657 | 44 |
847291 | 847291 | 2020-12-20 | Winston | Mississippi | 28159 | 1650 | 44 |
844045 | 844045 | 2020-12-19 | Winston | Mississippi | 28159 | 1638 | 44 |
840800 | 840800 | 2020-12-18 | Winston | Mississippi | 28159 | 1628 | 44 |
837555 | 837555 | 2020-12-17 | Winston | Mississippi | 28159 | 1612 | 44 |
834309 | 834309 | 2020-12-16 | Winston | Mississippi | 28159 | 1567 | 42 |
831062 | 831062 | 2020-12-15 | Winston | Mississippi | 28159 | 1549 | 41 |
827816 | 827816 | 2020-12-14 | Winston | Mississippi | 28159 | 1545 | 37 |
824569 | 824569 | 2020-12-13 | Winston | Mississippi | 28159 | 1529 | 37 |
821323 | 821323 | 2020-12-12 | Winston | Mississippi | 28159 | 1508 | 37 |
818077 | 818077 | 2020-12-11 | Winston | Mississippi | 28159 | 1481 | 35 |
814831 | 814831 | 2020-12-10 | Winston | Mississippi | 28159 | 1457 | 33 |
811586 | 811586 | 2020-12-09 | Winston | Mississippi | 28159 | 1440 | 31 |
808341 | 808341 | 2020-12-08 | Winston | Mississippi | 28159 | 1401 | 30 |
805096 | 805096 | 2020-12-07 | Winston | Mississippi | 28159 | 1390 | 29 |
801851 | 801851 | 2020-12-06 | Winston | Mississippi | 28159 | 1369 | 29 |
798606 | 798606 | 2020-12-05 | Winston | Mississippi | 28159 | 1360 | 29 |
795361 | 795361 | 2020-12-04 | Winston | Mississippi | 28159 | 1343 | 26 |
792116 | 792116 | 2020-12-03 | Winston | Mississippi | 28159 | 1317 | 26 |
788871 | 788871 | 2020-12-02 | Winston | Mississippi | 28159 | 1287 | 26 |
785626 | 785626 | 2020-12-01 | Winston | Mississippi | 28159 | 1255 | 26 |
782382 | 782382 | 2020-11-30 | Winston | Mississippi | 28159 | 1245 | 26 |
779136 | 779136 | 2020-11-29 | Winston | Mississippi | 28159 | 1237 | 26 |
775891 | 775891 | 2020-11-28 | Winston | Mississippi | 28159 | 1222 | 24 |
772646 | 772646 | 2020-11-27 | Winston | Mississippi | 28159 | 1216 | 24 |
769401 | 769401 | 2020-11-26 | Winston | Mississippi | 28159 | 1200 | 24 |
766155 | 766155 | 2020-11-25 | Winston | Mississippi | 28159 | 1191 | 24 |
762910 | 762910 | 2020-11-24 | Winston | Mississippi | 28159 | 1166 | 24 |
759665 | 759665 | 2020-11-23 | Winston | Mississippi | 28159 | 1158 | 24 |
756418 | 756418 | 2020-11-22 | Winston | Mississippi | 28159 | 1158 | 24 |
753172 | 753172 | 2020-11-21 | Winston | Mississippi | 28159 | 1124 | 24 |
749926 | 749926 | 2020-11-20 | Winston | Mississippi | 28159 | 1116 | 24 |
746680 | 746680 | 2020-11-19 | Winston | Mississippi | 28159 | 1076 | 24 |
743433 | 743433 | 2020-11-18 | Winston | Mississippi | 28159 | 1057 | 23 |
740186 | 740186 | 2020-11-17 | Winston | Mississippi | 28159 | 1039 | 23 |
736942 | 736942 | 2020-11-16 | Winston | Mississippi | 28159 | 1020 | 23 |
733696 | 733696 | 2020-11-15 | Winston | Mississippi | 28159 | 1013 | 22 |
730451 | 730451 | 2020-11-14 | Winston | Mississippi | 28159 | 1005 | 22 |
727208 | 727208 | 2020-11-13 | Winston | Mississippi | 28159 | 993 | 22 |
723965 | 723965 | 2020-11-12 | Winston | Mississippi | 28159 | 991 | 22 |
720722 | 720722 | 2020-11-11 | Winston | Mississippi | 28159 | 982 | 22 |
717479 | 717479 | 2020-11-10 | Winston | Mississippi | 28159 | 971 | 22 |
714235 | 714235 | 2020-11-09 | Winston | Mississippi | 28159 | 953 | 22 |
710991 | 710991 | 2020-11-08 | Winston | Mississippi | 28159 | 953 | 22 |
707747 | 707747 | 2020-11-07 | Winston | Mississippi | 28159 | 936 | 22 |
704504 | 704504 | 2020-11-06 | Winston | Mississippi | 28159 | 923 | 22 |
701262 | 701262 | 2020-11-05 | Winston | Mississippi | 28159 | 911 | 22 |
698018 | 698018 | 2020-11-04 | Winston | Mississippi | 28159 | 893 | 22 |
694775 | 694775 | 2020-11-03 | Winston | Mississippi | 28159 | 889 | 22 |
691533 | 691533 | 2020-11-02 | Winston | Mississippi | 28159 | 886 | 22 |
688288 | 688288 | 2020-11-01 | Winston | Mississippi | 28159 | 885 | 22 |
685044 | 685044 | 2020-10-31 | Winston | Mississippi | 28159 | 876 | 21 |
681801 | 681801 | 2020-10-30 | Winston | Mississippi | 28159 | 870 | 21 |
678557 | 678557 | 2020-10-29 | Winston | Mississippi | 28159 | 859 | 21 |
675315 | 675315 | 2020-10-28 | Winston | Mississippi | 28159 | 852 | 21 |
672072 | 672072 | 2020-10-27 | Winston | Mississippi | 28159 | 846 | 21 |
668830 | 668830 | 2020-10-26 | Winston | Mississippi | 28159 | 844 | 21 |
665586 | 665586 | 2020-10-25 | Winston | Mississippi | 28159 | 841 | 21 |
662341 | 662341 | 2020-10-24 | Winston | Mississippi | 28159 | 841 | 21 |
659097 | 659097 | 2020-10-23 | Winston | Mississippi | 28159 | 833 | 21 |
655852 | 655852 | 2020-10-22 | Winston | Mississippi | 28159 | 828 | 21 |
652607 | 652607 | 2020-10-21 | Winston | Mississippi | 28159 | 826 | 21 |
649362 | 649362 | 2020-10-20 | Winston | Mississippi | 28159 | 822 | 21 |
646118 | 646118 | 2020-10-19 | Winston | Mississippi | 28159 | 815 | 21 |
642872 | 642872 | 2020-10-18 | Winston | Mississippi | 28159 | 814 | 21 |
639624 | 639624 | 2020-10-17 | Winston | Mississippi | 28159 | 814 | 21 |
636378 | 636378 | 2020-10-16 | Winston | Mississippi | 28159 | 810 | 21 |
633132 | 633132 | 2020-10-15 | Winston | Mississippi | 28159 | 806 | 21 |
629887 | 629887 | 2020-10-14 | Winston | Mississippi | 28159 | 798 | 21 |
626643 | 626643 | 2020-10-13 | Winston | Mississippi | 28159 | 794 | 21 |
623401 | 623401 | 2020-10-12 | Winston | Mississippi | 28159 | 791 | 21 |
620158 | 620158 | 2020-10-11 | Winston | Mississippi | 28159 | 791 | 21 |
616916 | 616916 | 2020-10-10 | Winston | Mississippi | 28159 | 790 | 21 |
613675 | 613675 | 2020-10-09 | Winston | Mississippi | 28159 | 780 | 20 |
610433 | 610433 | 2020-10-08 | Winston | Mississippi | 28159 | 776 | 20 |
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 |
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);