ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where fips = 28023 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1061424 | 1061424 | 2021-02-24 | Clarke | Mississippi | 28023 | 1682 | 71 |
1058178 | 1058178 | 2021-02-23 | Clarke | Mississippi | 28023 | 1676 | 71 |
1054932 | 1054932 | 2021-02-22 | Clarke | Mississippi | 28023 | 1673 | 70 |
1051685 | 1051685 | 2021-02-21 | Clarke | Mississippi | 28023 | 1673 | 70 |
1048438 | 1048438 | 2021-02-20 | Clarke | Mississippi | 28023 | 1670 | 70 |
1045192 | 1045192 | 2021-02-19 | Clarke | Mississippi | 28023 | 1668 | 70 |
1041947 | 1041947 | 2021-02-18 | Clarke | Mississippi | 28023 | 1666 | 70 |
1038702 | 1038702 | 2021-02-17 | Clarke | Mississippi | 28023 | 1664 | 69 |
1035457 | 1035457 | 2021-02-16 | Clarke | Mississippi | 28023 | 1660 | 69 |
1032212 | 1032212 | 2021-02-15 | Clarke | Mississippi | 28023 | 1655 | 69 |
1028965 | 1028965 | 2021-02-14 | Clarke | Mississippi | 28023 | 1648 | 69 |
1025719 | 1025719 | 2021-02-13 | Clarke | Mississippi | 28023 | 1634 | 69 |
1022474 | 1022474 | 2021-02-12 | Clarke | Mississippi | 28023 | 1628 | 68 |
1019229 | 1019229 | 2021-02-11 | Clarke | Mississippi | 28023 | 1625 | 67 |
1015984 | 1015984 | 2021-02-10 | Clarke | Mississippi | 28023 | 1617 | 67 |
1012739 | 1012739 | 2021-02-09 | Clarke | Mississippi | 28023 | 1614 | 66 |
1009494 | 1009494 | 2021-02-08 | Clarke | Mississippi | 28023 | 1609 | 66 |
1006247 | 1006247 | 2021-02-07 | Clarke | Mississippi | 28023 | 1608 | 66 |
1003001 | 1003001 | 2021-02-06 | Clarke | Mississippi | 28023 | 1604 | 66 |
999756 | 999756 | 2021-02-05 | Clarke | Mississippi | 28023 | 1598 | 66 |
996510 | 996510 | 2021-02-04 | Clarke | Mississippi | 28023 | 1592 | 65 |
993264 | 993264 | 2021-02-03 | Clarke | Mississippi | 28023 | 1583 | 65 |
990018 | 990018 | 2021-02-02 | Clarke | Mississippi | 28023 | 1577 | 65 |
986771 | 986771 | 2021-02-01 | Clarke | Mississippi | 28023 | 1575 | 64 |
983524 | 983524 | 2021-01-31 | Clarke | Mississippi | 28023 | 1574 | 64 |
980278 | 980278 | 2021-01-30 | Clarke | Mississippi | 28023 | 1561 | 64 |
977032 | 977032 | 2021-01-29 | Clarke | Mississippi | 28023 | 1554 | 64 |
973787 | 973787 | 2021-01-28 | Clarke | Mississippi | 28023 | 1533 | 62 |
970542 | 970542 | 2021-01-27 | Clarke | Mississippi | 28023 | 1510 | 62 |
967297 | 967297 | 2021-01-26 | Clarke | Mississippi | 28023 | 1487 | 62 |
964053 | 964053 | 2021-01-25 | Clarke | Mississippi | 28023 | 1486 | 62 |
960808 | 960808 | 2021-01-24 | Clarke | Mississippi | 28023 | 1481 | 62 |
957562 | 957562 | 2021-01-23 | Clarke | Mississippi | 28023 | 1472 | 62 |
954317 | 954317 | 2021-01-22 | Clarke | Mississippi | 28023 | 1447 | 62 |
951072 | 951072 | 2021-01-21 | Clarke | Mississippi | 28023 | 1435 | 62 |
947826 | 947826 | 2021-01-20 | Clarke | Mississippi | 28023 | 1417 | 62 |
944579 | 944579 | 2021-01-19 | Clarke | Mississippi | 28023 | 1398 | 62 |
941334 | 941334 | 2021-01-18 | Clarke | Mississippi | 28023 | 1389 | 60 |
938089 | 938089 | 2021-01-17 | Clarke | Mississippi | 28023 | 1386 | 60 |
934844 | 934844 | 2021-01-16 | Clarke | Mississippi | 28023 | 1374 | 60 |
931599 | 931599 | 2021-01-15 | Clarke | Mississippi | 28023 | 1364 | 60 |
928354 | 928354 | 2021-01-14 | Clarke | Mississippi | 28023 | 1351 | 60 |
925108 | 925108 | 2021-01-13 | Clarke | Mississippi | 28023 | 1345 | 60 |
921863 | 921863 | 2021-01-12 | Clarke | Mississippi | 28023 | 1332 | 60 |
918618 | 918618 | 2021-01-11 | Clarke | Mississippi | 28023 | 1322 | 60 |
915373 | 915373 | 2021-01-10 | Clarke | Mississippi | 28023 | 1315 | 60 |
912128 | 912128 | 2021-01-09 | Clarke | Mississippi | 28023 | 1302 | 60 |
908883 | 908883 | 2021-01-08 | Clarke | Mississippi | 28023 | 1276 | 60 |
905637 | 905637 | 2021-01-07 | Clarke | Mississippi | 28023 | 1265 | 59 |
902392 | 902392 | 2021-01-06 | Clarke | Mississippi | 28023 | 1251 | 59 |
899147 | 899147 | 2021-01-05 | Clarke | Mississippi | 28023 | 1239 | 59 |
895902 | 895902 | 2021-01-04 | Clarke | Mississippi | 28023 | 1227 | 59 |
892655 | 892655 | 2021-01-03 | Clarke | Mississippi | 28023 | 1224 | 59 |
889409 | 889409 | 2021-01-02 | Clarke | Mississippi | 28023 | 1214 | 58 |
886163 | 886163 | 2021-01-01 | Clarke | Mississippi | 28023 | 1206 | 58 |
882918 | 882918 | 2020-12-31 | Clarke | Mississippi | 28023 | 1202 | 58 |
879673 | 879673 | 2020-12-30 | Clarke | Mississippi | 28023 | 1186 | 58 |
876428 | 876428 | 2020-12-29 | Clarke | Mississippi | 28023 | 1174 | 58 |
873183 | 873183 | 2020-12-28 | Clarke | Mississippi | 28023 | 1165 | 58 |
869938 | 869938 | 2020-12-27 | Clarke | Mississippi | 28023 | 1155 | 58 |
866693 | 866693 | 2020-12-26 | Clarke | Mississippi | 28023 | 1151 | 57 |
863448 | 863448 | 2020-12-25 | Clarke | Mississippi | 28023 | 1149 | 57 |
860203 | 860203 | 2020-12-24 | Clarke | Mississippi | 28023 | 1146 | 57 |
856958 | 856958 | 2020-12-23 | Clarke | Mississippi | 28023 | 1135 | 57 |
853713 | 853713 | 2020-12-22 | Clarke | Mississippi | 28023 | 1127 | 55 |
850468 | 850468 | 2020-12-21 | Clarke | Mississippi | 28023 | 1117 | 55 |
847223 | 847223 | 2020-12-20 | Clarke | Mississippi | 28023 | 1112 | 55 |
843977 | 843977 | 2020-12-19 | Clarke | Mississippi | 28023 | 1106 | 55 |
840732 | 840732 | 2020-12-18 | Clarke | Mississippi | 28023 | 1096 | 55 |
837487 | 837487 | 2020-12-17 | Clarke | Mississippi | 28023 | 1085 | 55 |
834241 | 834241 | 2020-12-16 | Clarke | Mississippi | 28023 | 1056 | 55 |
830994 | 830994 | 2020-12-15 | Clarke | Mississippi | 28023 | 1051 | 55 |
827748 | 827748 | 2020-12-14 | Clarke | Mississippi | 28023 | 1046 | 55 |
824501 | 824501 | 2020-12-13 | Clarke | Mississippi | 28023 | 1038 | 55 |
821255 | 821255 | 2020-12-12 | Clarke | Mississippi | 28023 | 1036 | 55 |
818009 | 818009 | 2020-12-11 | Clarke | Mississippi | 28023 | 1029 | 55 |
814763 | 814763 | 2020-12-10 | Clarke | Mississippi | 28023 | 1025 | 55 |
811518 | 811518 | 2020-12-09 | Clarke | Mississippi | 28023 | 1008 | 55 |
808273 | 808273 | 2020-12-08 | Clarke | Mississippi | 28023 | 999 | 55 |
805028 | 805028 | 2020-12-07 | Clarke | Mississippi | 28023 | 993 | 55 |
801783 | 801783 | 2020-12-06 | Clarke | Mississippi | 28023 | 986 | 55 |
798538 | 798538 | 2020-12-05 | Clarke | Mississippi | 28023 | 980 | 55 |
795293 | 795293 | 2020-12-04 | Clarke | Mississippi | 28023 | 969 | 54 |
792048 | 792048 | 2020-12-03 | Clarke | Mississippi | 28023 | 956 | 53 |
788803 | 788803 | 2020-12-02 | Clarke | Mississippi | 28023 | 948 | 53 |
785558 | 785558 | 2020-12-01 | Clarke | Mississippi | 28023 | 936 | 53 |
782314 | 782314 | 2020-11-30 | Clarke | Mississippi | 28023 | 930 | 53 |
779068 | 779068 | 2020-11-29 | Clarke | Mississippi | 28023 | 924 | 53 |
775823 | 775823 | 2020-11-28 | Clarke | Mississippi | 28023 | 905 | 53 |
772578 | 772578 | 2020-11-27 | Clarke | Mississippi | 28023 | 893 | 53 |
769333 | 769333 | 2020-11-26 | Clarke | Mississippi | 28023 | 891 | 53 |
766087 | 766087 | 2020-11-25 | Clarke | Mississippi | 28023 | 888 | 53 |
762842 | 762842 | 2020-11-24 | Clarke | Mississippi | 28023 | 885 | 53 |
759597 | 759597 | 2020-11-23 | Clarke | Mississippi | 28023 | 882 | 53 |
756350 | 756350 | 2020-11-22 | Clarke | Mississippi | 28023 | 881 | 53 |
753104 | 753104 | 2020-11-21 | Clarke | Mississippi | 28023 | 877 | 53 |
749858 | 749858 | 2020-11-20 | Clarke | Mississippi | 28023 | 866 | 53 |
746612 | 746612 | 2020-11-19 | Clarke | Mississippi | 28023 | 859 | 53 |
743365 | 743365 | 2020-11-18 | Clarke | Mississippi | 28023 | 852 | 53 |
740118 | 740118 | 2020-11-17 | Clarke | Mississippi | 28023 | 848 | 53 |
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);