ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 28047 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1811556 | 1811556 | 2021-10-13 | Harrison | Mississippi | 28047 | 34022 | 530 |
1808307 | 1808307 | 2021-10-12 | Harrison | Mississippi | 28047 | 33979 | 529 |
1805056 | 1805056 | 2021-10-11 | Harrison | Mississippi | 28047 | 33919 | 525 |
1801807 | 1801807 | 2021-10-10 | Harrison | Mississippi | 28047 | 33835 | 522 |
1798558 | 1798558 | 2021-10-09 | Harrison | Mississippi | 28047 | 33835 | 522 |
1795309 | 1795309 | 2021-10-08 | Harrison | Mississippi | 28047 | 33835 | 522 |
1792060 | 1792060 | 2021-10-07 | Harrison | Mississippi | 28047 | 33790 | 521 |
1788811 | 1788811 | 2021-10-06 | Harrison | Mississippi | 28047 | 33728 | 518 |
1785563 | 1785563 | 2021-10-05 | Harrison | Mississippi | 28047 | 33686 | 518 |
1782314 | 1782314 | 2021-10-04 | Harrison | Mississippi | 28047 | 33619 | 513 |
1779064 | 1779064 | 2021-10-03 | Harrison | Mississippi | 28047 | 33547 | 507 |
1775814 | 1775814 | 2021-10-02 | Harrison | Mississippi | 28047 | 33547 | 507 |
1772564 | 1772564 | 2021-10-01 | Harrison | Mississippi | 28047 | 33547 | 507 |
1769315 | 1769315 | 2021-09-30 | Harrison | Mississippi | 28047 | 33492 | 505 |
1766066 | 1766066 | 2021-09-29 | Harrison | Mississippi | 28047 | 33418 | 504 |
1762817 | 1762817 | 2021-09-28 | Harrison | Mississippi | 28047 | 33248 | 501 |
1759568 | 1759568 | 2021-09-27 | Harrison | Mississippi | 28047 | 33151 | 493 |
1756320 | 1756320 | 2021-09-26 | Harrison | Mississippi | 28047 | 33063 | 488 |
1753072 | 1753072 | 2021-09-25 | Harrison | Mississippi | 28047 | 33063 | 488 |
1749824 | 1749824 | 2021-09-24 | Harrison | Mississippi | 28047 | 33063 | 488 |
1746574 | 1746574 | 2021-09-23 | Harrison | Mississippi | 28047 | 32996 | 486 |
1743325 | 1743325 | 2021-09-22 | Harrison | Mississippi | 28047 | 32779 | 484 |
1740076 | 1740076 | 2021-09-21 | Harrison | Mississippi | 28047 | 32698 | 481 |
1736827 | 1736827 | 2021-09-20 | Harrison | Mississippi | 28047 | 32559 | 478 |
1733577 | 1733577 | 2021-09-19 | Harrison | Mississippi | 28047 | 32339 | 474 |
1730327 | 1730327 | 2021-09-18 | Harrison | Mississippi | 28047 | 32339 | 474 |
1727077 | 1727077 | 2021-09-17 | Harrison | Mississippi | 28047 | 32339 | 474 |
1723828 | 1723828 | 2021-09-16 | Harrison | Mississippi | 28047 | 32160 | 471 |
1720579 | 1720579 | 2021-09-15 | Harrison | Mississippi | 28047 | 31907 | 468 |
1717331 | 1717331 | 2021-09-14 | Harrison | Mississippi | 28047 | 31767 | 460 |
1714083 | 1714083 | 2021-09-13 | Harrison | Mississippi | 28047 | 31603 | 458 |
1710837 | 1710837 | 2021-09-12 | Harrison | Mississippi | 28047 | 31264 | 449 |
1707590 | 1707590 | 2021-09-11 | Harrison | Mississippi | 28047 | 31264 | 449 |
1704343 | 1704343 | 2021-09-10 | Harrison | Mississippi | 28047 | 31264 | 449 |
1701093 | 1701093 | 2021-09-09 | Harrison | Mississippi | 28047 | 31179 | 446 |
1697844 | 1697844 | 2021-09-08 | Harrison | Mississippi | 28047 | 30897 | 433 |
1694596 | 1694596 | 2021-09-07 | Harrison | Mississippi | 28047 | 30728 | 430 |
1691347 | 1691347 | 2021-09-06 | Harrison | Mississippi | 28047 | 30666 | 427 |
1688097 | 1688097 | 2021-09-05 | Harrison | Mississippi | 28047 | 30193 | 416 |
1684847 | 1684847 | 2021-09-04 | Harrison | Mississippi | 28047 | 30193 | 416 |
1681596 | 1681596 | 2021-09-03 | Harrison | Mississippi | 28047 | 30193 | 416 |
1678348 | 1678348 | 2021-09-02 | Harrison | Mississippi | 28047 | 29962 | 411 |
1675100 | 1675100 | 2021-09-01 | Harrison | Mississippi | 28047 | 29690 | 411 |
1671852 | 1671852 | 2021-08-31 | Harrison | Mississippi | 28047 | 29462 | 399 |
1668605 | 1668605 | 2021-08-30 | Harrison | Mississippi | 28047 | 29387 | 395 |
1665358 | 1665358 | 2021-08-29 | Harrison | Mississippi | 28047 | 28793 | 386 |
1662110 | 1662110 | 2021-08-28 | Harrison | Mississippi | 28047 | 28793 | 386 |
1658862 | 1658862 | 2021-08-27 | Harrison | Mississippi | 28047 | 28793 | 386 |
1655613 | 1655613 | 2021-08-26 | Harrison | Mississippi | 28047 | 28472 | 381 |
1652366 | 1652366 | 2021-08-25 | Harrison | Mississippi | 28047 | 28104 | 379 |
1649118 | 1649118 | 2021-08-24 | Harrison | Mississippi | 28047 | 27814 | 376 |
1645869 | 1645869 | 2021-08-23 | Harrison | Mississippi | 28047 | 27625 | 361 |
1642620 | 1642620 | 2021-08-22 | Harrison | Mississippi | 28047 | 26670 | 357 |
1639370 | 1639370 | 2021-08-21 | Harrison | Mississippi | 28047 | 26670 | 357 |
1636120 | 1636120 | 2021-08-20 | Harrison | Mississippi | 28047 | 26670 | 357 |
1632870 | 1632870 | 2021-08-19 | Harrison | Mississippi | 28047 | 26270 | 351 |
1629623 | 1629623 | 2021-08-18 | Harrison | Mississippi | 28047 | 25777 | 350 |
1626376 | 1626376 | 2021-08-17 | Harrison | Mississippi | 28047 | 25536 | 349 |
1623129 | 1623129 | 2021-08-16 | Harrison | Mississippi | 28047 | 25279 | 345 |
1619882 | 1619882 | 2021-08-15 | Harrison | Mississippi | 28047 | 24410 | 345 |
1616634 | 1616634 | 2021-08-14 | Harrison | Mississippi | 28047 | 24410 | 345 |
1613386 | 1613386 | 2021-08-13 | Harrison | Mississippi | 28047 | 24410 | 345 |
1610137 | 1610137 | 2021-08-12 | Harrison | Mississippi | 28047 | 23811 | 344 |
1606889 | 1606889 | 2021-08-11 | Harrison | Mississippi | 28047 | 23382 | 343 |
1603640 | 1603640 | 2021-08-10 | Harrison | Mississippi | 28047 | 23161 | 343 |
1600391 | 1600391 | 2021-08-09 | Harrison | Mississippi | 28047 | 22765 | 339 |
1597143 | 1597143 | 2021-08-08 | Harrison | Mississippi | 28047 | 21876 | 336 |
1593894 | 1593894 | 2021-08-07 | Harrison | Mississippi | 28047 | 21876 | 336 |
1590645 | 1590645 | 2021-08-06 | Harrison | Mississippi | 28047 | 21876 | 336 |
1587396 | 1587396 | 2021-08-05 | Harrison | Mississippi | 28047 | 21667 | 336 |
1584145 | 1584145 | 2021-08-04 | Harrison | Mississippi | 28047 | 21395 | 335 |
1580896 | 1580896 | 2021-08-03 | Harrison | Mississippi | 28047 | 21172 | 335 |
1577647 | 1577647 | 2021-08-02 | Harrison | Mississippi | 28047 | 21066 | 330 |
1574399 | 1574399 | 2021-08-01 | Harrison | Mississippi | 28047 | 20527 | 329 |
1571151 | 1571151 | 2021-07-31 | Harrison | Mississippi | 28047 | 20527 | 329 |
1567903 | 1567903 | 2021-07-30 | Harrison | Mississippi | 28047 | 20527 | 329 |
1564655 | 1564655 | 2021-07-29 | Harrison | Mississippi | 28047 | 20365 | 329 |
1561407 | 1561407 | 2021-07-28 | Harrison | Mississippi | 28047 | 20194 | 328 |
1558159 | 1558159 | 2021-07-27 | Harrison | Mississippi | 28047 | 20064 | 328 |
1554912 | 1554912 | 2021-07-26 | Harrison | Mississippi | 28047 | 19932 | 327 |
1551665 | 1551665 | 2021-07-25 | Harrison | Mississippi | 28047 | 19569 | 326 |
1548418 | 1548418 | 2021-07-24 | Harrison | Mississippi | 28047 | 19569 | 326 |
1545171 | 1545171 | 2021-07-23 | Harrison | Mississippi | 28047 | 19569 | 326 |
1541923 | 1541923 | 2021-07-22 | Harrison | Mississippi | 28047 | 19462 | 326 |
1538676 | 1538676 | 2021-07-21 | Harrison | Mississippi | 28047 | 19332 | 323 |
1535429 | 1535429 | 2021-07-20 | Harrison | Mississippi | 28047 | 19268 | 323 |
1532181 | 1532181 | 2021-07-19 | Harrison | Mississippi | 28047 | 19221 | 322 |
1528934 | 1528934 | 2021-07-18 | Harrison | Mississippi | 28047 | 18989 | 322 |
1525687 | 1525687 | 2021-07-17 | Harrison | Mississippi | 28047 | 18989 | 322 |
1522440 | 1522440 | 2021-07-16 | Harrison | Mississippi | 28047 | 18989 | 322 |
1519191 | 1519191 | 2021-07-15 | Harrison | Mississippi | 28047 | 18942 | 322 |
1515944 | 1515944 | 2021-07-14 | Harrison | Mississippi | 28047 | 18888 | 321 |
1512698 | 1512698 | 2021-07-13 | Harrison | Mississippi | 28047 | 18840 | 320 |
1509451 | 1509451 | 2021-07-12 | Harrison | Mississippi | 28047 | 18823 | 318 |
1506205 | 1506205 | 2021-07-11 | Harrison | Mississippi | 28047 | 18790 | 318 |
1502959 | 1502959 | 2021-07-10 | Harrison | Mississippi | 28047 | 18790 | 318 |
1499713 | 1499713 | 2021-07-09 | Harrison | Mississippi | 28047 | 18790 | 318 |
1496467 | 1496467 | 2021-07-08 | Harrison | Mississippi | 28047 | 18749 | 317 |
1493220 | 1493220 | 2021-07-07 | Harrison | Mississippi | 28047 | 18712 | 317 |
1489973 | 1489973 | 2021-07-06 | Harrison | Mississippi | 28047 | 18686 | 317 |
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);