ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 28051 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054946 | 1054946 | 2021-02-22 | Holmes | Mississippi | 28051 | 1809 | 69 |
1051699 | 1051699 | 2021-02-21 | Holmes | Mississippi | 28051 | 1803 | 69 |
1048452 | 1048452 | 2021-02-20 | Holmes | Mississippi | 28051 | 1803 | 69 |
1045206 | 1045206 | 2021-02-19 | Holmes | Mississippi | 28051 | 1802 | 69 |
1041961 | 1041961 | 2021-02-18 | Holmes | Mississippi | 28051 | 1801 | 69 |
1038716 | 1038716 | 2021-02-17 | Holmes | Mississippi | 28051 | 1801 | 69 |
1035471 | 1035471 | 2021-02-16 | Holmes | Mississippi | 28051 | 1801 | 69 |
1032226 | 1032226 | 2021-02-15 | Holmes | Mississippi | 28051 | 1795 | 69 |
1028979 | 1028979 | 2021-02-14 | Holmes | Mississippi | 28051 | 1795 | 69 |
1025733 | 1025733 | 2021-02-13 | Holmes | Mississippi | 28051 | 1792 | 69 |
1022488 | 1022488 | 2021-02-12 | Holmes | Mississippi | 28051 | 1792 | 69 |
1019243 | 1019243 | 2021-02-11 | Holmes | Mississippi | 28051 | 1790 | 69 |
1015998 | 1015998 | 2021-02-10 | Holmes | Mississippi | 28051 | 1787 | 69 |
1012753 | 1012753 | 2021-02-09 | Holmes | Mississippi | 28051 | 1787 | 69 |
1009508 | 1009508 | 2021-02-08 | Holmes | Mississippi | 28051 | 1785 | 69 |
1006261 | 1006261 | 2021-02-07 | Holmes | Mississippi | 28051 | 1783 | 69 |
1003015 | 1003015 | 2021-02-06 | Holmes | Mississippi | 28051 | 1778 | 69 |
999770 | 999770 | 2021-02-05 | Holmes | Mississippi | 28051 | 1774 | 69 |
996524 | 996524 | 2021-02-04 | Holmes | Mississippi | 28051 | 1770 | 69 |
993278 | 993278 | 2021-02-03 | Holmes | Mississippi | 28051 | 1768 | 69 |
990032 | 990032 | 2021-02-02 | Holmes | Mississippi | 28051 | 1763 | 69 |
986785 | 986785 | 2021-02-01 | Holmes | Mississippi | 28051 | 1761 | 68 |
983538 | 983538 | 2021-01-31 | Holmes | Mississippi | 28051 | 1759 | 68 |
980292 | 980292 | 2021-01-30 | Holmes | Mississippi | 28051 | 1757 | 68 |
977046 | 977046 | 2021-01-29 | Holmes | Mississippi | 28051 | 1753 | 68 |
973801 | 973801 | 2021-01-28 | Holmes | Mississippi | 28051 | 1746 | 68 |
970556 | 970556 | 2021-01-27 | Holmes | Mississippi | 28051 | 1732 | 68 |
967311 | 967311 | 2021-01-26 | Holmes | Mississippi | 28051 | 1725 | 68 |
964067 | 964067 | 2021-01-25 | Holmes | Mississippi | 28051 | 1722 | 68 |
960822 | 960822 | 2021-01-24 | Holmes | Mississippi | 28051 | 1720 | 68 |
957576 | 957576 | 2021-01-23 | Holmes | Mississippi | 28051 | 1717 | 68 |
954331 | 954331 | 2021-01-22 | Holmes | Mississippi | 28051 | 1713 | 68 |
951086 | 951086 | 2021-01-21 | Holmes | Mississippi | 28051 | 1698 | 68 |
947840 | 947840 | 2021-01-20 | Holmes | Mississippi | 28051 | 1691 | 68 |
944593 | 944593 | 2021-01-19 | Holmes | Mississippi | 28051 | 1687 | 67 |
941348 | 941348 | 2021-01-18 | Holmes | Mississippi | 28051 | 1687 | 67 |
938103 | 938103 | 2021-01-17 | Holmes | Mississippi | 28051 | 1685 | 67 |
934858 | 934858 | 2021-01-16 | Holmes | Mississippi | 28051 | 1681 | 67 |
931613 | 931613 | 2021-01-15 | Holmes | Mississippi | 28051 | 1678 | 67 |
928368 | 928368 | 2021-01-14 | Holmes | Mississippi | 28051 | 1674 | 67 |
925122 | 925122 | 2021-01-13 | Holmes | Mississippi | 28051 | 1668 | 67 |
921877 | 921877 | 2021-01-12 | Holmes | Mississippi | 28051 | 1665 | 67 |
918632 | 918632 | 2021-01-11 | Holmes | Mississippi | 28051 | 1656 | 67 |
915387 | 915387 | 2021-01-10 | Holmes | Mississippi | 28051 | 1650 | 67 |
912142 | 912142 | 2021-01-09 | Holmes | Mississippi | 28051 | 1646 | 67 |
908897 | 908897 | 2021-01-08 | Holmes | Mississippi | 28051 | 1636 | 67 |
905651 | 905651 | 2021-01-07 | Holmes | Mississippi | 28051 | 1630 | 67 |
902406 | 902406 | 2021-01-06 | Holmes | Mississippi | 28051 | 1622 | 67 |
899161 | 899161 | 2021-01-05 | Holmes | Mississippi | 28051 | 1618 | 67 |
895916 | 895916 | 2021-01-04 | Holmes | Mississippi | 28051 | 1616 | 67 |
892669 | 892669 | 2021-01-03 | Holmes | Mississippi | 28051 | 1608 | 67 |
889423 | 889423 | 2021-01-02 | Holmes | Mississippi | 28051 | 1606 | 67 |
886177 | 886177 | 2021-01-01 | Holmes | Mississippi | 28051 | 1596 | 65 |
882932 | 882932 | 2020-12-31 | Holmes | Mississippi | 28051 | 1592 | 65 |
879687 | 879687 | 2020-12-30 | Holmes | Mississippi | 28051 | 1577 | 65 |
876442 | 876442 | 2020-12-29 | Holmes | Mississippi | 28051 | 1564 | 65 |
873197 | 873197 | 2020-12-28 | Holmes | Mississippi | 28051 | 1557 | 64 |
869952 | 869952 | 2020-12-27 | Holmes | Mississippi | 28051 | 1547 | 64 |
866707 | 866707 | 2020-12-26 | Holmes | Mississippi | 28051 | 1545 | 64 |
863462 | 863462 | 2020-12-25 | Holmes | Mississippi | 28051 | 1543 | 64 |
860217 | 860217 | 2020-12-24 | Holmes | Mississippi | 28051 | 1539 | 64 |
856972 | 856972 | 2020-12-23 | Holmes | Mississippi | 28051 | 1532 | 64 |
853727 | 853727 | 2020-12-22 | Holmes | Mississippi | 28051 | 1522 | 64 |
850482 | 850482 | 2020-12-21 | Holmes | Mississippi | 28051 | 1513 | 63 |
847237 | 847237 | 2020-12-20 | Holmes | Mississippi | 28051 | 1512 | 63 |
843991 | 843991 | 2020-12-19 | Holmes | Mississippi | 28051 | 1509 | 63 |
840746 | 840746 | 2020-12-18 | Holmes | Mississippi | 28051 | 1505 | 63 |
837501 | 837501 | 2020-12-17 | Holmes | Mississippi | 28051 | 1494 | 63 |
834255 | 834255 | 2020-12-16 | Holmes | Mississippi | 28051 | 1490 | 63 |
831008 | 831008 | 2020-12-15 | Holmes | Mississippi | 28051 | 1478 | 63 |
827762 | 827762 | 2020-12-14 | Holmes | Mississippi | 28051 | 1476 | 62 |
824515 | 824515 | 2020-12-13 | Holmes | Mississippi | 28051 | 1473 | 62 |
821269 | 821269 | 2020-12-12 | Holmes | Mississippi | 28051 | 1467 | 62 |
818023 | 818023 | 2020-12-11 | Holmes | Mississippi | 28051 | 1434 | 62 |
814777 | 814777 | 2020-12-10 | Holmes | Mississippi | 28051 | 1430 | 61 |
811532 | 811532 | 2020-12-09 | Holmes | Mississippi | 28051 | 1422 | 61 |
808287 | 808287 | 2020-12-08 | Holmes | Mississippi | 28051 | 1411 | 61 |
805042 | 805042 | 2020-12-07 | Holmes | Mississippi | 28051 | 1404 | 61 |
801797 | 801797 | 2020-12-06 | Holmes | Mississippi | 28051 | 1396 | 61 |
798552 | 798552 | 2020-12-05 | Holmes | Mississippi | 28051 | 1379 | 61 |
795307 | 795307 | 2020-12-04 | Holmes | Mississippi | 28051 | 1368 | 61 |
792062 | 792062 | 2020-12-03 | Holmes | Mississippi | 28051 | 1357 | 61 |
788817 | 788817 | 2020-12-02 | Holmes | Mississippi | 28051 | 1344 | 61 |
785572 | 785572 | 2020-12-01 | Holmes | Mississippi | 28051 | 1334 | 61 |
782328 | 782328 | 2020-11-30 | Holmes | Mississippi | 28051 | 1323 | 61 |
779082 | 779082 | 2020-11-29 | Holmes | Mississippi | 28051 | 1315 | 61 |
775837 | 775837 | 2020-11-28 | Holmes | Mississippi | 28051 | 1308 | 61 |
772592 | 772592 | 2020-11-27 | Holmes | Mississippi | 28051 | 1299 | 61 |
769347 | 769347 | 2020-11-26 | Holmes | Mississippi | 28051 | 1278 | 61 |
766101 | 766101 | 2020-11-25 | Holmes | Mississippi | 28051 | 1265 | 61 |
762856 | 762856 | 2020-11-24 | Holmes | Mississippi | 28051 | 1249 | 61 |
759611 | 759611 | 2020-11-23 | Holmes | Mississippi | 28051 | 1244 | 61 |
756364 | 756364 | 2020-11-22 | Holmes | Mississippi | 28051 | 1242 | 61 |
753118 | 753118 | 2020-11-21 | Holmes | Mississippi | 28051 | 1231 | 61 |
749872 | 749872 | 2020-11-20 | Holmes | Mississippi | 28051 | 1223 | 60 |
746626 | 746626 | 2020-11-19 | Holmes | Mississippi | 28051 | 1214 | 60 |
743379 | 743379 | 2020-11-18 | Holmes | Mississippi | 28051 | 1210 | 60 |
740132 | 740132 | 2020-11-17 | Holmes | Mississippi | 28051 | 1203 | 60 |
736888 | 736888 | 2020-11-16 | Holmes | Mississippi | 28051 | 1200 | 60 |
733642 | 733642 | 2020-11-15 | Holmes | Mississippi | 28051 | 1196 | 60 |
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);