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 |
---|---|---|---|---|---|---|---|
1948035 | 1948035 | 2021-11-24 | Harrison | Mississippi | 28047 | 34853 | 555 |
1944784 | 1944784 | 2021-11-23 | Harrison | Mississippi | 28047 | 34825 | 554 |
1941533 | 1941533 | 2021-11-22 | Harrison | Mississippi | 28047 | 34806 | 553 |
1938283 | 1938283 | 2021-11-21 | Harrison | Mississippi | 28047 | 34758 | 553 |
1935033 | 1935033 | 2021-11-20 | Harrison | Mississippi | 28047 | 34758 | 553 |
1931783 | 1931783 | 2021-11-19 | Harrison | Mississippi | 28047 | 34758 | 553 |
1928532 | 1928532 | 2021-11-18 | Harrison | Mississippi | 28047 | 34724 | 552 |
1925282 | 1925282 | 2021-11-17 | Harrison | Mississippi | 28047 | 34694 | 552 |
1922033 | 1922033 | 2021-11-16 | Harrison | Mississippi | 28047 | 34679 | 552 |
1918783 | 1918783 | 2021-11-15 | Harrison | Mississippi | 28047 | 34667 | 552 |
1915533 | 1915533 | 2021-11-14 | Harrison | Mississippi | 28047 | 34641 | 552 |
1912283 | 1912283 | 2021-11-13 | Harrison | Mississippi | 28047 | 34641 | 552 |
1909033 | 1909033 | 2021-11-12 | Harrison | Mississippi | 28047 | 34641 | 552 |
1905784 | 1905784 | 2021-11-11 | Harrison | Mississippi | 28047 | 34617 | 551 |
1902535 | 1902535 | 2021-11-10 | Harrison | Mississippi | 28047 | 34617 | 551 |
1899285 | 1899285 | 2021-11-09 | Harrison | Mississippi | 28047 | 34599 | 551 |
1896035 | 1896035 | 2021-11-08 | Harrison | Mississippi | 28047 | 34582 | 549 |
1892785 | 1892785 | 2021-11-07 | Harrison | Mississippi | 28047 | 34563 | 548 |
1889535 | 1889535 | 2021-11-06 | Harrison | Mississippi | 28047 | 34563 | 548 |
1886285 | 1886285 | 2021-11-05 | Harrison | Mississippi | 28047 | 34563 | 548 |
1883036 | 1883036 | 2021-11-04 | Harrison | Mississippi | 28047 | 34531 | 546 |
1879787 | 1879787 | 2021-11-03 | Harrison | Mississippi | 28047 | 34498 | 546 |
1876538 | 1876538 | 2021-11-02 | Harrison | Mississippi | 28047 | 34485 | 546 |
1873289 | 1873289 | 2021-11-01 | Harrison | Mississippi | 28047 | 34465 | 543 |
1870040 | 1870040 | 2021-10-31 | Harrison | Mississippi | 28047 | 34446 | 542 |
1866791 | 1866791 | 2021-10-30 | Harrison | Mississippi | 28047 | 34446 | 542 |
1863542 | 1863542 | 2021-10-29 | Harrison | Mississippi | 28047 | 34446 | 542 |
1860293 | 1860293 | 2021-10-28 | Harrison | Mississippi | 28047 | 34445 | 541 |
1857044 | 1857044 | 2021-10-27 | Harrison | Mississippi | 28047 | 34423 | 541 |
1853795 | 1853795 | 2021-10-26 | Harrison | Mississippi | 28047 | 34400 | 541 |
1850546 | 1850546 | 2021-10-25 | Harrison | Mississippi | 28047 | 34353 | 540 |
1847296 | 1847296 | 2021-10-24 | Harrison | Mississippi | 28047 | 34338 | 538 |
1844046 | 1844046 | 2021-10-23 | Harrison | Mississippi | 28047 | 34338 | 538 |
1840796 | 1840796 | 2021-10-22 | Harrison | Mississippi | 28047 | 34338 | 538 |
1837547 | 1837547 | 2021-10-21 | Harrison | Mississippi | 28047 | 34312 | 538 |
1834298 | 1834298 | 2021-10-20 | Harrison | Mississippi | 28047 | 34281 | 537 |
1831049 | 1831049 | 2021-10-19 | Harrison | Mississippi | 28047 | 34258 | 537 |
1827800 | 1827800 | 2021-10-18 | Harrison | Mississippi | 28047 | 34150 | 535 |
1824551 | 1824551 | 2021-10-17 | Harrison | Mississippi | 28047 | 34102 | 530 |
1821302 | 1821302 | 2021-10-16 | Harrison | Mississippi | 28047 | 34102 | 530 |
1818053 | 1818053 | 2021-10-15 | Harrison | Mississippi | 28047 | 34102 | 530 |
1814804 | 1814804 | 2021-10-14 | Harrison | Mississippi | 28047 | 34085 | 530 |
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 |
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);