ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 28001 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054921 | 1054921 | 2021-02-22 | Adams | Mississippi | 28001 | 2319 | 74 |
1051674 | 1051674 | 2021-02-21 | Adams | Mississippi | 28001 | 2319 | 74 |
1048427 | 1048427 | 2021-02-20 | Adams | Mississippi | 28001 | 2316 | 74 |
1045181 | 1045181 | 2021-02-19 | Adams | Mississippi | 28001 | 2315 | 74 |
1041936 | 1041936 | 2021-02-18 | Adams | Mississippi | 28001 | 2311 | 74 |
1038691 | 1038691 | 2021-02-17 | Adams | Mississippi | 28001 | 2310 | 74 |
1035446 | 1035446 | 2021-02-16 | Adams | Mississippi | 28001 | 2299 | 74 |
1032201 | 1032201 | 2021-02-15 | Adams | Mississippi | 28001 | 2292 | 74 |
1028954 | 1028954 | 2021-02-14 | Adams | Mississippi | 28001 | 2291 | 74 |
1025708 | 1025708 | 2021-02-13 | Adams | Mississippi | 28001 | 2277 | 74 |
1022463 | 1022463 | 2021-02-12 | Adams | Mississippi | 28001 | 2273 | 74 |
1019218 | 1019218 | 2021-02-11 | Adams | Mississippi | 28001 | 2266 | 74 |
1015973 | 1015973 | 2021-02-10 | Adams | Mississippi | 28001 | 2262 | 74 |
1012728 | 1012728 | 2021-02-09 | Adams | Mississippi | 28001 | 2260 | 74 |
1009483 | 1009483 | 2021-02-08 | Adams | Mississippi | 28001 | 2256 | 74 |
1006236 | 1006236 | 2021-02-07 | Adams | Mississippi | 28001 | 2255 | 74 |
1002990 | 1002990 | 2021-02-06 | Adams | Mississippi | 28001 | 2253 | 74 |
999745 | 999745 | 2021-02-05 | Adams | Mississippi | 28001 | 2250 | 73 |
996499 | 996499 | 2021-02-04 | Adams | Mississippi | 28001 | 2232 | 72 |
993253 | 993253 | 2021-02-03 | Adams | Mississippi | 28001 | 2228 | 72 |
990007 | 990007 | 2021-02-02 | Adams | Mississippi | 28001 | 2226 | 72 |
986760 | 986760 | 2021-02-01 | Adams | Mississippi | 28001 | 2217 | 72 |
983513 | 983513 | 2021-01-31 | Adams | Mississippi | 28001 | 2212 | 72 |
980267 | 980267 | 2021-01-30 | Adams | Mississippi | 28001 | 2208 | 72 |
977021 | 977021 | 2021-01-29 | Adams | Mississippi | 28001 | 2199 | 72 |
973776 | 973776 | 2021-01-28 | Adams | Mississippi | 28001 | 2188 | 72 |
970531 | 970531 | 2021-01-27 | Adams | Mississippi | 28001 | 2181 | 72 |
967286 | 967286 | 2021-01-26 | Adams | Mississippi | 28001 | 2162 | 71 |
964042 | 964042 | 2021-01-25 | Adams | Mississippi | 28001 | 2153 | 71 |
960797 | 960797 | 2021-01-24 | Adams | Mississippi | 28001 | 2151 | 71 |
957551 | 957551 | 2021-01-23 | Adams | Mississippi | 28001 | 2136 | 71 |
954306 | 954306 | 2021-01-22 | Adams | Mississippi | 28001 | 2123 | 70 |
951061 | 951061 | 2021-01-21 | Adams | Mississippi | 28001 | 2101 | 70 |
947815 | 947815 | 2021-01-20 | Adams | Mississippi | 28001 | 2078 | 70 |
944568 | 944568 | 2021-01-19 | Adams | Mississippi | 28001 | 2070 | 70 |
941323 | 941323 | 2021-01-18 | Adams | Mississippi | 28001 | 2058 | 70 |
938078 | 938078 | 2021-01-17 | Adams | Mississippi | 28001 | 2046 | 70 |
934833 | 934833 | 2021-01-16 | Adams | Mississippi | 28001 | 2032 | 70 |
931588 | 931588 | 2021-01-15 | Adams | Mississippi | 28001 | 2016 | 66 |
928343 | 928343 | 2021-01-14 | Adams | Mississippi | 28001 | 2000 | 65 |
925097 | 925097 | 2021-01-13 | Adams | Mississippi | 28001 | 1993 | 65 |
921852 | 921852 | 2021-01-12 | Adams | Mississippi | 28001 | 1981 | 65 |
918607 | 918607 | 2021-01-11 | Adams | Mississippi | 28001 | 1960 | 65 |
915362 | 915362 | 2021-01-10 | Adams | Mississippi | 28001 | 1945 | 64 |
912117 | 912117 | 2021-01-09 | Adams | Mississippi | 28001 | 1924 | 64 |
908872 | 908872 | 2021-01-08 | Adams | Mississippi | 28001 | 1892 | 64 |
905626 | 905626 | 2021-01-07 | Adams | Mississippi | 28001 | 1876 | 64 |
902381 | 902381 | 2021-01-06 | Adams | Mississippi | 28001 | 1868 | 63 |
899136 | 899136 | 2021-01-05 | Adams | Mississippi | 28001 | 1846 | 62 |
895891 | 895891 | 2021-01-04 | Adams | Mississippi | 28001 | 1830 | 60 |
892644 | 892644 | 2021-01-03 | Adams | Mississippi | 28001 | 1821 | 60 |
889398 | 889398 | 2021-01-02 | Adams | Mississippi | 28001 | 1812 | 58 |
886152 | 886152 | 2021-01-01 | Adams | Mississippi | 28001 | 1807 | 58 |
882907 | 882907 | 2020-12-31 | Adams | Mississippi | 28001 | 1801 | 58 |
879662 | 879662 | 2020-12-30 | Adams | Mississippi | 28001 | 1794 | 58 |
876417 | 876417 | 2020-12-29 | Adams | Mississippi | 28001 | 1777 | 58 |
873172 | 873172 | 2020-12-28 | Adams | Mississippi | 28001 | 1761 | 57 |
869927 | 869927 | 2020-12-27 | Adams | Mississippi | 28001 | 1754 | 57 |
866682 | 866682 | 2020-12-26 | Adams | Mississippi | 28001 | 1745 | 57 |
863437 | 863437 | 2020-12-25 | Adams | Mississippi | 28001 | 1744 | 57 |
860192 | 860192 | 2020-12-24 | Adams | Mississippi | 28001 | 1742 | 57 |
856947 | 856947 | 2020-12-23 | Adams | Mississippi | 28001 | 1738 | 57 |
853702 | 853702 | 2020-12-22 | Adams | Mississippi | 28001 | 1728 | 56 |
850457 | 850457 | 2020-12-21 | Adams | Mississippi | 28001 | 1719 | 53 |
847212 | 847212 | 2020-12-20 | Adams | Mississippi | 28001 | 1709 | 53 |
843966 | 843966 | 2020-12-19 | Adams | Mississippi | 28001 | 1683 | 53 |
840721 | 840721 | 2020-12-18 | Adams | Mississippi | 28001 | 1669 | 53 |
837476 | 837476 | 2020-12-17 | Adams | Mississippi | 28001 | 1644 | 52 |
834230 | 834230 | 2020-12-16 | Adams | Mississippi | 28001 | 1633 | 52 |
830983 | 830983 | 2020-12-15 | Adams | Mississippi | 28001 | 1630 | 52 |
827737 | 827737 | 2020-12-14 | Adams | Mississippi | 28001 | 1617 | 52 |
824490 | 824490 | 2020-12-13 | Adams | Mississippi | 28001 | 1602 | 52 |
821244 | 821244 | 2020-12-12 | Adams | Mississippi | 28001 | 1587 | 52 |
817998 | 817998 | 2020-12-11 | Adams | Mississippi | 28001 | 1572 | 52 |
814752 | 814752 | 2020-12-10 | Adams | Mississippi | 28001 | 1557 | 52 |
811507 | 811507 | 2020-12-09 | Adams | Mississippi | 28001 | 1550 | 52 |
808262 | 808262 | 2020-12-08 | Adams | Mississippi | 28001 | 1541 | 52 |
805017 | 805017 | 2020-12-07 | Adams | Mississippi | 28001 | 1532 | 52 |
801772 | 801772 | 2020-12-06 | Adams | Mississippi | 28001 | 1523 | 52 |
798527 | 798527 | 2020-12-05 | Adams | Mississippi | 28001 | 1515 | 52 |
795282 | 795282 | 2020-12-04 | Adams | Mississippi | 28001 | 1488 | 52 |
792037 | 792037 | 2020-12-03 | Adams | Mississippi | 28001 | 1483 | 52 |
788792 | 788792 | 2020-12-02 | Adams | Mississippi | 28001 | 1472 | 52 |
785547 | 785547 | 2020-12-01 | Adams | Mississippi | 28001 | 1447 | 52 |
782303 | 782303 | 2020-11-30 | Adams | Mississippi | 28001 | 1444 | 51 |
779057 | 779057 | 2020-11-29 | Adams | Mississippi | 28001 | 1431 | 51 |
775812 | 775812 | 2020-11-28 | Adams | Mississippi | 28001 | 1419 | 50 |
772567 | 772567 | 2020-11-27 | Adams | Mississippi | 28001 | 1411 | 50 |
769322 | 769322 | 2020-11-26 | Adams | Mississippi | 28001 | 1392 | 50 |
766076 | 766076 | 2020-11-25 | Adams | Mississippi | 28001 | 1379 | 49 |
762831 | 762831 | 2020-11-24 | Adams | Mississippi | 28001 | 1365 | 48 |
759586 | 759586 | 2020-11-23 | Adams | Mississippi | 28001 | 1359 | 48 |
756339 | 756339 | 2020-11-22 | Adams | Mississippi | 28001 | 1341 | 48 |
753093 | 753093 | 2020-11-21 | Adams | Mississippi | 28001 | 1337 | 48 |
749847 | 749847 | 2020-11-20 | Adams | Mississippi | 28001 | 1318 | 48 |
746601 | 746601 | 2020-11-19 | Adams | Mississippi | 28001 | 1296 | 48 |
743354 | 743354 | 2020-11-18 | Adams | Mississippi | 28001 | 1276 | 48 |
740107 | 740107 | 2020-11-17 | Adams | Mississippi | 28001 | 1259 | 47 |
736863 | 736863 | 2020-11-16 | Adams | Mississippi | 28001 | 1250 | 47 |
733617 | 733617 | 2020-11-15 | Adams | Mississippi | 28001 | 1236 | 47 |
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);