ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 28157 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1623184 | 1623184 | 2021-08-16 | Wilkinson | Mississippi | 28157 | 878 | 33 |
1619937 | 1619937 | 2021-08-15 | Wilkinson | Mississippi | 28157 | 870 | 33 |
1616689 | 1616689 | 2021-08-14 | Wilkinson | Mississippi | 28157 | 870 | 33 |
1613441 | 1613441 | 2021-08-13 | Wilkinson | Mississippi | 28157 | 870 | 33 |
1610192 | 1610192 | 2021-08-12 | Wilkinson | Mississippi | 28157 | 844 | 33 |
1606944 | 1606944 | 2021-08-11 | Wilkinson | Mississippi | 28157 | 837 | 33 |
1603695 | 1603695 | 2021-08-10 | Wilkinson | Mississippi | 28157 | 822 | 33 |
1600446 | 1600446 | 2021-08-09 | Wilkinson | Mississippi | 28157 | 816 | 33 |
1597198 | 1597198 | 2021-08-08 | Wilkinson | Mississippi | 28157 | 806 | 32 |
1593949 | 1593949 | 2021-08-07 | Wilkinson | Mississippi | 28157 | 806 | 32 |
1590700 | 1590700 | 2021-08-06 | Wilkinson | Mississippi | 28157 | 806 | 32 |
1587451 | 1587451 | 2021-08-05 | Wilkinson | Mississippi | 28157 | 800 | 32 |
1584200 | 1584200 | 2021-08-04 | Wilkinson | Mississippi | 28157 | 796 | 32 |
1580951 | 1580951 | 2021-08-03 | Wilkinson | Mississippi | 28157 | 793 | 32 |
1577702 | 1577702 | 2021-08-02 | Wilkinson | Mississippi | 28157 | 793 | 32 |
1574454 | 1574454 | 2021-08-01 | Wilkinson | Mississippi | 28157 | 780 | 32 |
1571206 | 1571206 | 2021-07-31 | Wilkinson | Mississippi | 28157 | 780 | 32 |
1567958 | 1567958 | 2021-07-30 | Wilkinson | Mississippi | 28157 | 780 | 32 |
1564710 | 1564710 | 2021-07-29 | Wilkinson | Mississippi | 28157 | 777 | 32 |
1561462 | 1561462 | 2021-07-28 | Wilkinson | Mississippi | 28157 | 771 | 32 |
1558214 | 1558214 | 2021-07-27 | Wilkinson | Mississippi | 28157 | 765 | 32 |
1554967 | 1554967 | 2021-07-26 | Wilkinson | Mississippi | 28157 | 759 | 32 |
1551720 | 1551720 | 2021-07-25 | Wilkinson | Mississippi | 28157 | 746 | 32 |
1548473 | 1548473 | 2021-07-24 | Wilkinson | Mississippi | 28157 | 746 | 32 |
1545226 | 1545226 | 2021-07-23 | Wilkinson | Mississippi | 28157 | 746 | 32 |
1541978 | 1541978 | 2021-07-22 | Wilkinson | Mississippi | 28157 | 732 | 32 |
1538731 | 1538731 | 2021-07-21 | Wilkinson | Mississippi | 28157 | 730 | 32 |
1535484 | 1535484 | 2021-07-20 | Wilkinson | Mississippi | 28157 | 728 | 32 |
1532236 | 1532236 | 2021-07-19 | Wilkinson | Mississippi | 28157 | 726 | 32 |
1528989 | 1528989 | 2021-07-18 | Wilkinson | Mississippi | 28157 | 712 | 32 |
1525742 | 1525742 | 2021-07-17 | Wilkinson | Mississippi | 28157 | 712 | 32 |
1522495 | 1522495 | 2021-07-16 | Wilkinson | Mississippi | 28157 | 712 | 32 |
1519246 | 1519246 | 2021-07-15 | Wilkinson | Mississippi | 28157 | 708 | 32 |
1515999 | 1515999 | 2021-07-14 | Wilkinson | Mississippi | 28157 | 705 | 32 |
1512753 | 1512753 | 2021-07-13 | Wilkinson | Mississippi | 28157 | 705 | 32 |
1509506 | 1509506 | 2021-07-12 | Wilkinson | Mississippi | 28157 | 705 | 32 |
1506260 | 1506260 | 2021-07-11 | Wilkinson | Mississippi | 28157 | 702 | 32 |
1503014 | 1503014 | 2021-07-10 | Wilkinson | Mississippi | 28157 | 702 | 32 |
1499768 | 1499768 | 2021-07-09 | Wilkinson | Mississippi | 28157 | 702 | 32 |
1496522 | 1496522 | 2021-07-08 | Wilkinson | Mississippi | 28157 | 702 | 32 |
1493275 | 1493275 | 2021-07-07 | Wilkinson | Mississippi | 28157 | 702 | 32 |
1490028 | 1490028 | 2021-07-06 | Wilkinson | Mississippi | 28157 | 702 | 32 |
1486781 | 1486781 | 2021-07-05 | Wilkinson | Mississippi | 28157 | 702 | 32 |
1483535 | 1483535 | 2021-07-04 | Wilkinson | Mississippi | 28157 | 702 | 32 |
1480289 | 1480289 | 2021-07-03 | Wilkinson | Mississippi | 28157 | 702 | 32 |
1477042 | 1477042 | 2021-07-02 | Wilkinson | Mississippi | 28157 | 702 | 32 |
1473796 | 1473796 | 2021-07-01 | Wilkinson | Mississippi | 28157 | 700 | 32 |
1470550 | 1470550 | 2021-06-30 | Wilkinson | Mississippi | 28157 | 700 | 32 |
1467305 | 1467305 | 2021-06-29 | Wilkinson | Mississippi | 28157 | 700 | 32 |
1464060 | 1464060 | 2021-06-28 | Wilkinson | Mississippi | 28157 | 699 | 32 |
1460815 | 1460815 | 2021-06-27 | Wilkinson | Mississippi | 28157 | 697 | 32 |
1457570 | 1457570 | 2021-06-26 | Wilkinson | Mississippi | 28157 | 697 | 32 |
1454325 | 1454325 | 2021-06-25 | Wilkinson | Mississippi | 28157 | 697 | 32 |
1451080 | 1451080 | 2021-06-24 | Wilkinson | Mississippi | 28157 | 697 | 32 |
1447834 | 1447834 | 2021-06-23 | Wilkinson | Mississippi | 28157 | 696 | 32 |
1444589 | 1444589 | 2021-06-22 | Wilkinson | Mississippi | 28157 | 696 | 32 |
1441344 | 1441344 | 2021-06-21 | Wilkinson | Mississippi | 28157 | 696 | 32 |
1438098 | 1438098 | 2021-06-20 | Wilkinson | Mississippi | 28157 | 696 | 32 |
1434851 | 1434851 | 2021-06-19 | Wilkinson | Mississippi | 28157 | 696 | 32 |
1431604 | 1431604 | 2021-06-18 | Wilkinson | Mississippi | 28157 | 696 | 32 |
1428359 | 1428359 | 2021-06-17 | Wilkinson | Mississippi | 28157 | 695 | 32 |
1425114 | 1425114 | 2021-06-16 | Wilkinson | Mississippi | 28157 | 694 | 32 |
1421866 | 1421866 | 2021-06-15 | Wilkinson | Mississippi | 28157 | 693 | 32 |
1418621 | 1418621 | 2021-06-14 | Wilkinson | Mississippi | 28157 | 693 | 32 |
1415376 | 1415376 | 2021-06-13 | Wilkinson | Mississippi | 28157 | 693 | 32 |
1412130 | 1412130 | 2021-06-12 | Wilkinson | Mississippi | 28157 | 693 | 32 |
1408885 | 1408885 | 2021-06-11 | Wilkinson | Mississippi | 28157 | 693 | 32 |
1405640 | 1405640 | 2021-06-10 | Wilkinson | Mississippi | 28157 | 692 | 32 |
1402394 | 1402394 | 2021-06-09 | Wilkinson | Mississippi | 28157 | 692 | 32 |
1399149 | 1399149 | 2021-06-08 | Wilkinson | Mississippi | 28157 | 692 | 32 |
1395903 | 1395903 | 2021-06-07 | Wilkinson | Mississippi | 28157 | 692 | 32 |
1392657 | 1392657 | 2021-06-06 | Wilkinson | Mississippi | 28157 | 687 | 31 |
1389412 | 1389412 | 2021-06-05 | Wilkinson | Mississippi | 28157 | 687 | 31 |
1386167 | 1386167 | 2021-06-04 | Wilkinson | Mississippi | 28157 | 687 | 31 |
1382922 | 1382922 | 2021-06-03 | Wilkinson | Mississippi | 28157 | 688 | 31 |
1379676 | 1379676 | 2021-06-02 | Wilkinson | Mississippi | 28157 | 687 | 31 |
1376431 | 1376431 | 2021-06-01 | Wilkinson | Mississippi | 28157 | 686 | 31 |
1373185 | 1373185 | 2021-05-31 | Wilkinson | Mississippi | 28157 | 684 | 31 |
1369940 | 1369940 | 2021-05-30 | Wilkinson | Mississippi | 28157 | 684 | 31 |
1366694 | 1366694 | 2021-05-29 | Wilkinson | Mississippi | 28157 | 684 | 31 |
1363448 | 1363448 | 2021-05-28 | Wilkinson | Mississippi | 28157 | 684 | 31 |
1360201 | 1360201 | 2021-05-27 | Wilkinson | Mississippi | 28157 | 684 | 31 |
1356955 | 1356955 | 2021-05-26 | Wilkinson | Mississippi | 28157 | 684 | 31 |
1353709 | 1353709 | 2021-05-25 | Wilkinson | Mississippi | 28157 | 684 | 31 |
1350463 | 1350463 | 2021-05-24 | Wilkinson | Mississippi | 28157 | 684 | 31 |
1347217 | 1347217 | 2021-05-23 | Wilkinson | Mississippi | 28157 | 680 | 31 |
1343969 | 1343969 | 2021-05-22 | Wilkinson | Mississippi | 28157 | 680 | 31 |
1340720 | 1340720 | 2021-05-21 | Wilkinson | Mississippi | 28157 | 680 | 31 |
1337473 | 1337473 | 2021-05-20 | Wilkinson | Mississippi | 28157 | 680 | 31 |
1334226 | 1334226 | 2021-05-19 | Wilkinson | Mississippi | 28157 | 679 | 31 |
1330979 | 1330979 | 2021-05-18 | Wilkinson | Mississippi | 28157 | 679 | 31 |
1327732 | 1327732 | 2021-05-17 | Wilkinson | Mississippi | 28157 | 676 | 31 |
1324486 | 1324486 | 2021-05-16 | Wilkinson | Mississippi | 28157 | 675 | 31 |
1321240 | 1321240 | 2021-05-15 | Wilkinson | Mississippi | 28157 | 675 | 31 |
1317994 | 1317994 | 2021-05-14 | Wilkinson | Mississippi | 28157 | 675 | 31 |
1314746 | 1314746 | 2021-05-13 | Wilkinson | Mississippi | 28157 | 673 | 31 |
1311500 | 1311500 | 2021-05-12 | Wilkinson | Mississippi | 28157 | 672 | 31 |
1308253 | 1308253 | 2021-05-11 | Wilkinson | Mississippi | 28157 | 672 | 30 |
1305007 | 1305007 | 2021-05-10 | Wilkinson | Mississippi | 28157 | 671 | 30 |
1301761 | 1301761 | 2021-05-09 | Wilkinson | Mississippi | 28157 | 669 | 30 |
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);