ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Pike" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1811589 | 1811589 | 2021-10-13 | Pike | Mississippi | 28113 | 5749 | 152 |
1808340 | 1808340 | 2021-10-12 | Pike | Mississippi | 28113 | 5724 | 151 |
1805089 | 1805089 | 2021-10-11 | Pike | Mississippi | 28113 | 5708 | 150 |
1801840 | 1801840 | 2021-10-10 | Pike | Mississippi | 28113 | 5697 | 150 |
1798591 | 1798591 | 2021-10-09 | Pike | Mississippi | 28113 | 5697 | 150 |
1795342 | 1795342 | 2021-10-08 | Pike | Mississippi | 28113 | 5697 | 150 |
1792093 | 1792093 | 2021-10-07 | Pike | Mississippi | 28113 | 5695 | 150 |
1788844 | 1788844 | 2021-10-06 | Pike | Mississippi | 28113 | 5686 | 150 |
1785596 | 1785596 | 2021-10-05 | Pike | Mississippi | 28113 | 5682 | 150 |
1782347 | 1782347 | 2021-10-04 | Pike | Mississippi | 28113 | 5672 | 145 |
1779097 | 1779097 | 2021-10-03 | Pike | Mississippi | 28113 | 5664 | 142 |
1775847 | 1775847 | 2021-10-02 | Pike | Mississippi | 28113 | 5664 | 142 |
1772597 | 1772597 | 2021-10-01 | Pike | Mississippi | 28113 | 5664 | 142 |
1769348 | 1769348 | 2021-09-30 | Pike | Mississippi | 28113 | 5660 | 141 |
1766099 | 1766099 | 2021-09-29 | Pike | Mississippi | 28113 | 5651 | 141 |
1762850 | 1762850 | 2021-09-28 | Pike | Mississippi | 28113 | 5643 | 141 |
1759601 | 1759601 | 2021-09-27 | Pike | Mississippi | 28113 | 5626 | 138 |
1756353 | 1756353 | 2021-09-26 | Pike | Mississippi | 28113 | 5613 | 136 |
1753105 | 1753105 | 2021-09-25 | Pike | Mississippi | 28113 | 5613 | 136 |
1749857 | 1749857 | 2021-09-24 | Pike | Mississippi | 28113 | 5613 | 136 |
1746607 | 1746607 | 2021-09-23 | Pike | Mississippi | 28113 | 5590 | 136 |
1743358 | 1743358 | 2021-09-22 | Pike | Mississippi | 28113 | 5574 | 135 |
1740109 | 1740109 | 2021-09-21 | Pike | Mississippi | 28113 | 5553 | 135 |
1736860 | 1736860 | 2021-09-20 | Pike | Mississippi | 28113 | 5533 | 135 |
1733610 | 1733610 | 2021-09-19 | Pike | Mississippi | 28113 | 5491 | 133 |
1730360 | 1730360 | 2021-09-18 | Pike | Mississippi | 28113 | 5491 | 133 |
1727110 | 1727110 | 2021-09-17 | Pike | Mississippi | 28113 | 5491 | 133 |
1723861 | 1723861 | 2021-09-16 | Pike | Mississippi | 28113 | 5450 | 133 |
1720612 | 1720612 | 2021-09-15 | Pike | Mississippi | 28113 | 5424 | 133 |
1717364 | 1717364 | 2021-09-14 | Pike | Mississippi | 28113 | 5397 | 133 |
1714116 | 1714116 | 2021-09-13 | Pike | Mississippi | 28113 | 5362 | 128 |
1710870 | 1710870 | 2021-09-12 | Pike | Mississippi | 28113 | 5306 | 128 |
1707623 | 1707623 | 2021-09-11 | Pike | Mississippi | 28113 | 5306 | 128 |
1704376 | 1704376 | 2021-09-10 | Pike | Mississippi | 28113 | 5306 | 128 |
1701126 | 1701126 | 2021-09-09 | Pike | Mississippi | 28113 | 5245 | 128 |
1697877 | 1697877 | 2021-09-08 | Pike | Mississippi | 28113 | 5203 | 126 |
1694629 | 1694629 | 2021-09-07 | Pike | Mississippi | 28113 | 5158 | 125 |
1691380 | 1691380 | 2021-09-06 | Pike | Mississippi | 28113 | 5145 | 125 |
1688130 | 1688130 | 2021-09-05 | Pike | Mississippi | 28113 | 5075 | 125 |
1684880 | 1684880 | 2021-09-04 | Pike | Mississippi | 28113 | 5075 | 125 |
1681629 | 1681629 | 2021-09-03 | Pike | Mississippi | 28113 | 5075 | 125 |
1678381 | 1678381 | 2021-09-02 | Pike | Mississippi | 28113 | 5044 | 125 |
1675133 | 1675133 | 2021-09-01 | Pike | Mississippi | 28113 | 4968 | 125 |
1671885 | 1671885 | 2021-08-31 | Pike | Mississippi | 28113 | 4908 | 123 |
1668638 | 1668638 | 2021-08-30 | Pike | Mississippi | 28113 | 4892 | 123 |
1665391 | 1665391 | 2021-08-29 | Pike | Mississippi | 28113 | 4797 | 122 |
1662143 | 1662143 | 2021-08-28 | Pike | Mississippi | 28113 | 4797 | 122 |
1658895 | 1658895 | 2021-08-27 | Pike | Mississippi | 28113 | 4797 | 122 |
1655646 | 1655646 | 2021-08-26 | Pike | Mississippi | 28113 | 4695 | 122 |
1652399 | 1652399 | 2021-08-25 | Pike | Mississippi | 28113 | 4660 | 122 |
1649151 | 1649151 | 2021-08-24 | Pike | Mississippi | 28113 | 4595 | 122 |
1645902 | 1645902 | 2021-08-23 | Pike | Mississippi | 28113 | 4516 | 120 |
1642653 | 1642653 | 2021-08-22 | Pike | Mississippi | 28113 | 4439 | 118 |
1639403 | 1639403 | 2021-08-21 | Pike | Mississippi | 28113 | 4439 | 118 |
1636153 | 1636153 | 2021-08-20 | Pike | Mississippi | 28113 | 4439 | 118 |
1632903 | 1632903 | 2021-08-19 | Pike | Mississippi | 28113 | 4342 | 117 |
1629656 | 1629656 | 2021-08-18 | Pike | Mississippi | 28113 | 4268 | 117 |
1626409 | 1626409 | 2021-08-17 | Pike | Mississippi | 28113 | 4218 | 116 |
1623162 | 1623162 | 2021-08-16 | Pike | Mississippi | 28113 | 4190 | 116 |
1619915 | 1619915 | 2021-08-15 | Pike | Mississippi | 28113 | 4075 | 116 |
1616667 | 1616667 | 2021-08-14 | Pike | Mississippi | 28113 | 4075 | 116 |
1613419 | 1613419 | 2021-08-13 | Pike | Mississippi | 28113 | 4075 | 116 |
1610170 | 1610170 | 2021-08-12 | Pike | Mississippi | 28113 | 4008 | 116 |
1606922 | 1606922 | 2021-08-11 | Pike | Mississippi | 28113 | 3978 | 116 |
1603673 | 1603673 | 2021-08-10 | Pike | Mississippi | 28113 | 3934 | 116 |
1600424 | 1600424 | 2021-08-09 | Pike | Mississippi | 28113 | 3887 | 115 |
1597176 | 1597176 | 2021-08-08 | Pike | Mississippi | 28113 | 3814 | 115 |
1593927 | 1593927 | 2021-08-07 | Pike | Mississippi | 28113 | 3814 | 115 |
1590678 | 1590678 | 2021-08-06 | Pike | Mississippi | 28113 | 3814 | 115 |
1587429 | 1587429 | 2021-08-05 | Pike | Mississippi | 28113 | 3797 | 115 |
1584178 | 1584178 | 2021-08-04 | Pike | Mississippi | 28113 | 3771 | 114 |
1580929 | 1580929 | 2021-08-03 | Pike | Mississippi | 28113 | 3739 | 114 |
1577680 | 1577680 | 2021-08-02 | Pike | Mississippi | 28113 | 3711 | 113 |
1574432 | 1574432 | 2021-08-01 | Pike | Mississippi | 28113 | 3667 | 113 |
1571184 | 1571184 | 2021-07-31 | Pike | Mississippi | 28113 | 3667 | 113 |
1567936 | 1567936 | 2021-07-30 | Pike | Mississippi | 28113 | 3667 | 113 |
1564688 | 1564688 | 2021-07-29 | Pike | Mississippi | 28113 | 3650 | 113 |
1561440 | 1561440 | 2021-07-28 | Pike | Mississippi | 28113 | 3624 | 113 |
1558192 | 1558192 | 2021-07-27 | Pike | Mississippi | 28113 | 3605 | 113 |
1554945 | 1554945 | 2021-07-26 | Pike | Mississippi | 28113 | 3592 | 112 |
1551698 | 1551698 | 2021-07-25 | Pike | Mississippi | 28113 | 3530 | 112 |
1548451 | 1548451 | 2021-07-24 | Pike | Mississippi | 28113 | 3530 | 112 |
1545204 | 1545204 | 2021-07-23 | Pike | Mississippi | 28113 | 3530 | 112 |
1541956 | 1541956 | 2021-07-22 | Pike | Mississippi | 28113 | 3511 | 111 |
1538709 | 1538709 | 2021-07-21 | Pike | Mississippi | 28113 | 3488 | 111 |
1535462 | 1535462 | 2021-07-20 | Pike | Mississippi | 28113 | 3477 | 111 |
1532214 | 1532214 | 2021-07-19 | Pike | Mississippi | 28113 | 3466 | 111 |
1528967 | 1528967 | 2021-07-18 | Pike | Mississippi | 28113 | 3436 | 111 |
1525720 | 1525720 | 2021-07-17 | Pike | Mississippi | 28113 | 3436 | 111 |
1522473 | 1522473 | 2021-07-16 | Pike | Mississippi | 28113 | 3436 | 111 |
1519224 | 1519224 | 2021-07-15 | Pike | Mississippi | 28113 | 3430 | 111 |
1515977 | 1515977 | 2021-07-14 | Pike | Mississippi | 28113 | 3422 | 111 |
1512731 | 1512731 | 2021-07-13 | Pike | Mississippi | 28113 | 3407 | 111 |
1509484 | 1509484 | 2021-07-12 | Pike | Mississippi | 28113 | 3406 | 111 |
1506238 | 1506238 | 2021-07-11 | Pike | Mississippi | 28113 | 3403 | 111 |
1502992 | 1502992 | 2021-07-10 | Pike | Mississippi | 28113 | 3403 | 111 |
1499746 | 1499746 | 2021-07-09 | Pike | Mississippi | 28113 | 3403 | 111 |
1496500 | 1496500 | 2021-07-08 | Pike | Mississippi | 28113 | 3399 | 111 |
1493253 | 1493253 | 2021-07-07 | Pike | Mississippi | 28113 | 3398 | 111 |
1490006 | 1490006 | 2021-07-06 | Pike | Mississippi | 28113 | 3395 | 111 |
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);