ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 28053 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1064683 | 1064683 | 2021-02-25 | Humphreys | Mississippi | 28053 | 916 | 26 |
1061439 | 1061439 | 2021-02-24 | Humphreys | Mississippi | 28053 | 913 | 26 |
1058193 | 1058193 | 2021-02-23 | Humphreys | Mississippi | 28053 | 912 | 26 |
1054947 | 1054947 | 2021-02-22 | Humphreys | Mississippi | 28053 | 911 | 26 |
1051700 | 1051700 | 2021-02-21 | Humphreys | Mississippi | 28053 | 911 | 26 |
1048453 | 1048453 | 2021-02-20 | Humphreys | Mississippi | 28053 | 909 | 26 |
1045207 | 1045207 | 2021-02-19 | Humphreys | Mississippi | 28053 | 909 | 26 |
1041962 | 1041962 | 2021-02-18 | Humphreys | Mississippi | 28053 | 908 | 26 |
1038717 | 1038717 | 2021-02-17 | Humphreys | Mississippi | 28053 | 908 | 26 |
1035472 | 1035472 | 2021-02-16 | Humphreys | Mississippi | 28053 | 904 | 26 |
1032227 | 1032227 | 2021-02-15 | Humphreys | Mississippi | 28053 | 902 | 26 |
1028980 | 1028980 | 2021-02-14 | Humphreys | Mississippi | 28053 | 898 | 26 |
1025734 | 1025734 | 2021-02-13 | Humphreys | Mississippi | 28053 | 898 | 26 |
1022489 | 1022489 | 2021-02-12 | Humphreys | Mississippi | 28053 | 896 | 26 |
1019244 | 1019244 | 2021-02-11 | Humphreys | Mississippi | 28053 | 896 | 26 |
1015999 | 1015999 | 2021-02-10 | Humphreys | Mississippi | 28053 | 891 | 26 |
1012754 | 1012754 | 2021-02-09 | Humphreys | Mississippi | 28053 | 891 | 26 |
1009509 | 1009509 | 2021-02-08 | Humphreys | Mississippi | 28053 | 890 | 26 |
1006262 | 1006262 | 2021-02-07 | Humphreys | Mississippi | 28053 | 888 | 26 |
1003016 | 1003016 | 2021-02-06 | Humphreys | Mississippi | 28053 | 887 | 26 |
999771 | 999771 | 2021-02-05 | Humphreys | Mississippi | 28053 | 884 | 25 |
996525 | 996525 | 2021-02-04 | Humphreys | Mississippi | 28053 | 881 | 25 |
993279 | 993279 | 2021-02-03 | Humphreys | Mississippi | 28053 | 881 | 25 |
990033 | 990033 | 2021-02-02 | Humphreys | Mississippi | 28053 | 879 | 25 |
986786 | 986786 | 2021-02-01 | Humphreys | Mississippi | 28053 | 878 | 25 |
983539 | 983539 | 2021-01-31 | Humphreys | Mississippi | 28053 | 876 | 25 |
980293 | 980293 | 2021-01-30 | Humphreys | Mississippi | 28053 | 876 | 25 |
977047 | 977047 | 2021-01-29 | Humphreys | Mississippi | 28053 | 873 | 25 |
973802 | 973802 | 2021-01-28 | Humphreys | Mississippi | 28053 | 868 | 25 |
970557 | 970557 | 2021-01-27 | Humphreys | Mississippi | 28053 | 862 | 25 |
967312 | 967312 | 2021-01-26 | Humphreys | Mississippi | 28053 | 856 | 25 |
964068 | 964068 | 2021-01-25 | Humphreys | Mississippi | 28053 | 848 | 24 |
960823 | 960823 | 2021-01-24 | Humphreys | Mississippi | 28053 | 847 | 24 |
957577 | 957577 | 2021-01-23 | Humphreys | Mississippi | 28053 | 846 | 24 |
954332 | 954332 | 2021-01-22 | Humphreys | Mississippi | 28053 | 842 | 24 |
951087 | 951087 | 2021-01-21 | Humphreys | Mississippi | 28053 | 836 | 24 |
947841 | 947841 | 2021-01-20 | Humphreys | Mississippi | 28053 | 833 | 24 |
944594 | 944594 | 2021-01-19 | Humphreys | Mississippi | 28053 | 831 | 24 |
941349 | 941349 | 2021-01-18 | Humphreys | Mississippi | 28053 | 830 | 24 |
938104 | 938104 | 2021-01-17 | Humphreys | Mississippi | 28053 | 829 | 24 |
934859 | 934859 | 2021-01-16 | Humphreys | Mississippi | 28053 | 826 | 24 |
931614 | 931614 | 2021-01-15 | Humphreys | Mississippi | 28053 | 815 | 24 |
928369 | 928369 | 2021-01-14 | Humphreys | Mississippi | 28053 | 803 | 24 |
925123 | 925123 | 2021-01-13 | Humphreys | Mississippi | 28053 | 798 | 24 |
921878 | 921878 | 2021-01-12 | Humphreys | Mississippi | 28053 | 794 | 24 |
918633 | 918633 | 2021-01-11 | Humphreys | Mississippi | 28053 | 788 | 22 |
915388 | 915388 | 2021-01-10 | Humphreys | Mississippi | 28053 | 786 | 22 |
912143 | 912143 | 2021-01-09 | Humphreys | Mississippi | 28053 | 784 | 22 |
908898 | 908898 | 2021-01-08 | Humphreys | Mississippi | 28053 | 773 | 22 |
905652 | 905652 | 2021-01-07 | Humphreys | Mississippi | 28053 | 770 | 22 |
902407 | 902407 | 2021-01-06 | Humphreys | Mississippi | 28053 | 763 | 22 |
899162 | 899162 | 2021-01-05 | Humphreys | Mississippi | 28053 | 752 | 22 |
895917 | 895917 | 2021-01-04 | Humphreys | Mississippi | 28053 | 749 | 22 |
892670 | 892670 | 2021-01-03 | Humphreys | Mississippi | 28053 | 742 | 22 |
889424 | 889424 | 2021-01-02 | Humphreys | Mississippi | 28053 | 739 | 22 |
886178 | 886178 | 2021-01-01 | Humphreys | Mississippi | 28053 | 739 | 22 |
882933 | 882933 | 2020-12-31 | Humphreys | Mississippi | 28053 | 726 | 22 |
879688 | 879688 | 2020-12-30 | Humphreys | Mississippi | 28053 | 712 | 22 |
876443 | 876443 | 2020-12-29 | Humphreys | Mississippi | 28053 | 707 | 22 |
873198 | 873198 | 2020-12-28 | Humphreys | Mississippi | 28053 | 705 | 22 |
869953 | 869953 | 2020-12-27 | Humphreys | Mississippi | 28053 | 704 | 22 |
866708 | 866708 | 2020-12-26 | Humphreys | Mississippi | 28053 | 702 | 22 |
863463 | 863463 | 2020-12-25 | Humphreys | Mississippi | 28053 | 702 | 22 |
860218 | 860218 | 2020-12-24 | Humphreys | Mississippi | 28053 | 697 | 22 |
856973 | 856973 | 2020-12-23 | Humphreys | Mississippi | 28053 | 688 | 22 |
853728 | 853728 | 2020-12-22 | Humphreys | Mississippi | 28053 | 680 | 22 |
850483 | 850483 | 2020-12-21 | Humphreys | Mississippi | 28053 | 675 | 22 |
847238 | 847238 | 2020-12-20 | Humphreys | Mississippi | 28053 | 669 | 22 |
843992 | 843992 | 2020-12-19 | Humphreys | Mississippi | 28053 | 664 | 22 |
840747 | 840747 | 2020-12-18 | Humphreys | Mississippi | 28053 | 657 | 21 |
837502 | 837502 | 2020-12-17 | Humphreys | Mississippi | 28053 | 651 | 21 |
834256 | 834256 | 2020-12-16 | Humphreys | Mississippi | 28053 | 648 | 21 |
831009 | 831009 | 2020-12-15 | Humphreys | Mississippi | 28053 | 641 | 21 |
827763 | 827763 | 2020-12-14 | Humphreys | Mississippi | 28053 | 632 | 21 |
824516 | 824516 | 2020-12-13 | Humphreys | Mississippi | 28053 | 626 | 21 |
821270 | 821270 | 2020-12-12 | Humphreys | Mississippi | 28053 | 616 | 21 |
818024 | 818024 | 2020-12-11 | Humphreys | Mississippi | 28053 | 610 | 21 |
814778 | 814778 | 2020-12-10 | Humphreys | Mississippi | 28053 | 597 | 21 |
811533 | 811533 | 2020-12-09 | Humphreys | Mississippi | 28053 | 596 | 21 |
808288 | 808288 | 2020-12-08 | Humphreys | Mississippi | 28053 | 588 | 20 |
805043 | 805043 | 2020-12-07 | Humphreys | Mississippi | 28053 | 586 | 19 |
801798 | 801798 | 2020-12-06 | Humphreys | Mississippi | 28053 | 577 | 19 |
798553 | 798553 | 2020-12-05 | Humphreys | Mississippi | 28053 | 569 | 19 |
795308 | 795308 | 2020-12-04 | Humphreys | Mississippi | 28053 | 561 | 19 |
792063 | 792063 | 2020-12-03 | Humphreys | Mississippi | 28053 | 557 | 19 |
788818 | 788818 | 2020-12-02 | Humphreys | Mississippi | 28053 | 552 | 19 |
785573 | 785573 | 2020-12-01 | Humphreys | Mississippi | 28053 | 547 | 19 |
782329 | 782329 | 2020-11-30 | Humphreys | Mississippi | 28053 | 547 | 19 |
779083 | 779083 | 2020-11-29 | Humphreys | Mississippi | 28053 | 543 | 19 |
775838 | 775838 | 2020-11-28 | Humphreys | Mississippi | 28053 | 536 | 19 |
772593 | 772593 | 2020-11-27 | Humphreys | Mississippi | 28053 | 531 | 19 |
769348 | 769348 | 2020-11-26 | Humphreys | Mississippi | 28053 | 531 | 19 |
766102 | 766102 | 2020-11-25 | Humphreys | Mississippi | 28053 | 529 | 18 |
762857 | 762857 | 2020-11-24 | Humphreys | Mississippi | 28053 | 526 | 18 |
759612 | 759612 | 2020-11-23 | Humphreys | Mississippi | 28053 | 525 | 18 |
756365 | 756365 | 2020-11-22 | Humphreys | Mississippi | 28053 | 523 | 18 |
753119 | 753119 | 2020-11-21 | Humphreys | Mississippi | 28053 | 519 | 18 |
749873 | 749873 | 2020-11-20 | Humphreys | Mississippi | 28053 | 515 | 18 |
746627 | 746627 | 2020-11-19 | Humphreys | Mississippi | 28053 | 509 | 18 |
743380 | 743380 | 2020-11-18 | Humphreys | Mississippi | 28053 | 509 | 18 |
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);