ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 28037 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1194541 | 1194541 | 2021-04-06 | Franklin | Mississippi | 28037 | 810 | 23 |
1191292 | 1191292 | 2021-04-05 | Franklin | Mississippi | 28037 | 810 | 23 |
1188044 | 1188044 | 2021-04-04 | Franklin | Mississippi | 28037 | 810 | 23 |
1184797 | 1184797 | 2021-04-03 | Franklin | Mississippi | 28037 | 810 | 23 |
1181551 | 1181551 | 2021-04-02 | Franklin | Mississippi | 28037 | 810 | 23 |
1178304 | 1178304 | 2021-04-01 | Franklin | Mississippi | 28037 | 807 | 23 |
1175057 | 1175057 | 2021-03-31 | Franklin | Mississippi | 28037 | 806 | 22 |
1171810 | 1171810 | 2021-03-30 | Franklin | Mississippi | 28037 | 803 | 22 |
1168562 | 1168562 | 2021-03-29 | Franklin | Mississippi | 28037 | 803 | 22 |
1165314 | 1165314 | 2021-03-28 | Franklin | Mississippi | 28037 | 803 | 22 |
1162066 | 1162066 | 2021-03-27 | Franklin | Mississippi | 28037 | 802 | 22 |
1158818 | 1158818 | 2021-03-26 | Franklin | Mississippi | 28037 | 802 | 22 |
1155571 | 1155571 | 2021-03-25 | Franklin | Mississippi | 28037 | 801 | 22 |
1152324 | 1152324 | 2021-03-24 | Franklin | Mississippi | 28037 | 799 | 22 |
1149077 | 1149077 | 2021-03-23 | Franklin | Mississippi | 28037 | 799 | 22 |
1145830 | 1145830 | 2021-03-22 | Franklin | Mississippi | 28037 | 795 | 22 |
1142583 | 1142583 | 2021-03-21 | Franklin | Mississippi | 28037 | 795 | 22 |
1139336 | 1139336 | 2021-03-20 | Franklin | Mississippi | 28037 | 795 | 22 |
1136090 | 1136090 | 2021-03-19 | Franklin | Mississippi | 28037 | 792 | 21 |
1132844 | 1132844 | 2021-03-18 | Franklin | Mississippi | 28037 | 788 | 21 |
1129596 | 1129596 | 2021-03-17 | Franklin | Mississippi | 28037 | 786 | 21 |
1126349 | 1126349 | 2021-03-16 | Franklin | Mississippi | 28037 | 785 | 21 |
1123103 | 1123103 | 2021-03-15 | Franklin | Mississippi | 28037 | 785 | 21 |
1119856 | 1119856 | 2021-03-14 | Franklin | Mississippi | 28037 | 783 | 21 |
1116609 | 1116609 | 2021-03-13 | Franklin | Mississippi | 28037 | 781 | 21 |
1113363 | 1113363 | 2021-03-12 | Franklin | Mississippi | 28037 | 776 | 21 |
1110117 | 1110117 | 2021-03-11 | Franklin | Mississippi | 28037 | 775 | 21 |
1106871 | 1106871 | 2021-03-10 | Franklin | Mississippi | 28037 | 769 | 20 |
1103625 | 1103625 | 2021-03-09 | Franklin | Mississippi | 28037 | 766 | 20 |
1100379 | 1100379 | 2021-03-08 | Franklin | Mississippi | 28037 | 765 | 20 |
1097132 | 1097132 | 2021-03-07 | Franklin | Mississippi | 28037 | 765 | 20 |
1093885 | 1093885 | 2021-03-06 | Franklin | Mississippi | 28037 | 764 | 20 |
1090639 | 1090639 | 2021-03-05 | Franklin | Mississippi | 28037 | 764 | 20 |
1087394 | 1087394 | 2021-03-04 | Franklin | Mississippi | 28037 | 762 | 19 |
1084149 | 1084149 | 2021-03-03 | Franklin | Mississippi | 28037 | 761 | 19 |
1080903 | 1080903 | 2021-03-02 | Franklin | Mississippi | 28037 | 761 | 19 |
1077657 | 1077657 | 2021-03-01 | Franklin | Mississippi | 28037 | 761 | 19 |
1074411 | 1074411 | 2021-02-28 | Franklin | Mississippi | 28037 | 760 | 19 |
1071165 | 1071165 | 2021-02-27 | Franklin | Mississippi | 28037 | 759 | 19 |
1067920 | 1067920 | 2021-02-26 | Franklin | Mississippi | 28037 | 756 | 19 |
1064675 | 1064675 | 2021-02-25 | Franklin | Mississippi | 28037 | 755 | 19 |
1061431 | 1061431 | 2021-02-24 | Franklin | Mississippi | 28037 | 754 | 19 |
1058185 | 1058185 | 2021-02-23 | Franklin | Mississippi | 28037 | 753 | 19 |
1054939 | 1054939 | 2021-02-22 | Franklin | Mississippi | 28037 | 750 | 19 |
1051692 | 1051692 | 2021-02-21 | Franklin | Mississippi | 28037 | 750 | 19 |
1048445 | 1048445 | 2021-02-20 | Franklin | Mississippi | 28037 | 750 | 19 |
1045199 | 1045199 | 2021-02-19 | Franklin | Mississippi | 28037 | 750 | 19 |
1041954 | 1041954 | 2021-02-18 | Franklin | Mississippi | 28037 | 750 | 19 |
1038709 | 1038709 | 2021-02-17 | Franklin | Mississippi | 28037 | 750 | 19 |
1035464 | 1035464 | 2021-02-16 | Franklin | Mississippi | 28037 | 748 | 19 |
1032219 | 1032219 | 2021-02-15 | Franklin | Mississippi | 28037 | 747 | 19 |
1028972 | 1028972 | 2021-02-14 | Franklin | Mississippi | 28037 | 745 | 19 |
1025726 | 1025726 | 2021-02-13 | Franklin | Mississippi | 28037 | 743 | 19 |
1022481 | 1022481 | 2021-02-12 | Franklin | Mississippi | 28037 | 739 | 19 |
1019236 | 1019236 | 2021-02-11 | Franklin | Mississippi | 28037 | 737 | 19 |
1015991 | 1015991 | 2021-02-10 | Franklin | Mississippi | 28037 | 736 | 19 |
1012746 | 1012746 | 2021-02-09 | Franklin | Mississippi | 28037 | 737 | 19 |
1009501 | 1009501 | 2021-02-08 | Franklin | Mississippi | 28037 | 735 | 19 |
1006254 | 1006254 | 2021-02-07 | Franklin | Mississippi | 28037 | 735 | 19 |
1003008 | 1003008 | 2021-02-06 | Franklin | Mississippi | 28037 | 733 | 19 |
999763 | 999763 | 2021-02-05 | Franklin | Mississippi | 28037 | 730 | 19 |
996517 | 996517 | 2021-02-04 | Franklin | Mississippi | 28037 | 726 | 19 |
993271 | 993271 | 2021-02-03 | Franklin | Mississippi | 28037 | 726 | 19 |
990025 | 990025 | 2021-02-02 | Franklin | Mississippi | 28037 | 725 | 19 |
986778 | 986778 | 2021-02-01 | Franklin | Mississippi | 28037 | 723 | 19 |
983531 | 983531 | 2021-01-31 | Franklin | Mississippi | 28037 | 722 | 19 |
980285 | 980285 | 2021-01-30 | Franklin | Mississippi | 28037 | 719 | 18 |
977039 | 977039 | 2021-01-29 | Franklin | Mississippi | 28037 | 716 | 17 |
973794 | 973794 | 2021-01-28 | Franklin | Mississippi | 28037 | 715 | 17 |
970549 | 970549 | 2021-01-27 | Franklin | Mississippi | 28037 | 715 | 17 |
967304 | 967304 | 2021-01-26 | Franklin | Mississippi | 28037 | 710 | 17 |
964060 | 964060 | 2021-01-25 | Franklin | Mississippi | 28037 | 707 | 17 |
960815 | 960815 | 2021-01-24 | Franklin | Mississippi | 28037 | 706 | 17 |
957569 | 957569 | 2021-01-23 | Franklin | Mississippi | 28037 | 699 | 17 |
954324 | 954324 | 2021-01-22 | Franklin | Mississippi | 28037 | 696 | 17 |
951079 | 951079 | 2021-01-21 | Franklin | Mississippi | 28037 | 687 | 16 |
947833 | 947833 | 2021-01-20 | Franklin | Mississippi | 28037 | 671 | 15 |
944586 | 944586 | 2021-01-19 | Franklin | Mississippi | 28037 | 667 | 15 |
941341 | 941341 | 2021-01-18 | Franklin | Mississippi | 28037 | 666 | 15 |
938096 | 938096 | 2021-01-17 | Franklin | Mississippi | 28037 | 664 | 15 |
934851 | 934851 | 2021-01-16 | Franklin | Mississippi | 28037 | 658 | 15 |
931606 | 931606 | 2021-01-15 | Franklin | Mississippi | 28037 | 653 | 15 |
928361 | 928361 | 2021-01-14 | Franklin | Mississippi | 28037 | 646 | 13 |
925115 | 925115 | 2021-01-13 | Franklin | Mississippi | 28037 | 643 | 13 |
921870 | 921870 | 2021-01-12 | Franklin | Mississippi | 28037 | 640 | 13 |
918625 | 918625 | 2021-01-11 | Franklin | Mississippi | 28037 | 640 | 12 |
915380 | 915380 | 2021-01-10 | Franklin | Mississippi | 28037 | 639 | 12 |
912135 | 912135 | 2021-01-09 | Franklin | Mississippi | 28037 | 638 | 12 |
908890 | 908890 | 2021-01-08 | Franklin | Mississippi | 28037 | 629 | 12 |
905644 | 905644 | 2021-01-07 | Franklin | Mississippi | 28037 | 624 | 11 |
902399 | 902399 | 2021-01-06 | Franklin | Mississippi | 28037 | 620 | 11 |
899154 | 899154 | 2021-01-05 | Franklin | Mississippi | 28037 | 618 | 9 |
895909 | 895909 | 2021-01-04 | Franklin | Mississippi | 28037 | 610 | 9 |
892662 | 892662 | 2021-01-03 | Franklin | Mississippi | 28037 | 603 | 9 |
889416 | 889416 | 2021-01-02 | Franklin | Mississippi | 28037 | 601 | 9 |
886170 | 886170 | 2021-01-01 | Franklin | Mississippi | 28037 | 596 | 9 |
882925 | 882925 | 2020-12-31 | Franklin | Mississippi | 28037 | 586 | 9 |
879680 | 879680 | 2020-12-30 | Franklin | Mississippi | 28037 | 578 | 8 |
876435 | 876435 | 2020-12-29 | Franklin | Mississippi | 28037 | 574 | 8 |
873190 | 873190 | 2020-12-28 | Franklin | Mississippi | 28037 | 562 | 7 |
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);