ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 28049 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1811557 | 1811557 | 2021-10-13 | Hinds | Mississippi | 28049 | 31778 | 621 |
1808308 | 1808308 | 2021-10-12 | Hinds | Mississippi | 28049 | 31762 | 620 |
1805057 | 1805057 | 2021-10-11 | Hinds | Mississippi | 28049 | 31680 | 614 |
1801808 | 1801808 | 2021-10-10 | Hinds | Mississippi | 28049 | 31623 | 611 |
1798559 | 1798559 | 2021-10-09 | Hinds | Mississippi | 28049 | 31623 | 611 |
1795310 | 1795310 | 2021-10-08 | Hinds | Mississippi | 28049 | 31623 | 611 |
1792061 | 1792061 | 2021-10-07 | Hinds | Mississippi | 28049 | 31599 | 610 |
1788812 | 1788812 | 2021-10-06 | Hinds | Mississippi | 28049 | 31547 | 609 |
1785564 | 1785564 | 2021-10-05 | Hinds | Mississippi | 28049 | 31530 | 609 |
1782315 | 1782315 | 2021-10-04 | Hinds | Mississippi | 28049 | 31507 | 603 |
1779065 | 1779065 | 2021-10-03 | Hinds | Mississippi | 28049 | 31457 | 599 |
1775815 | 1775815 | 2021-10-02 | Hinds | Mississippi | 28049 | 31457 | 599 |
1772565 | 1772565 | 2021-10-01 | Hinds | Mississippi | 28049 | 31457 | 599 |
1769316 | 1769316 | 2021-09-30 | Hinds | Mississippi | 28049 | 31430 | 594 |
1766067 | 1766067 | 2021-09-29 | Hinds | Mississippi | 28049 | 31347 | 593 |
1762818 | 1762818 | 2021-09-28 | Hinds | Mississippi | 28049 | 31307 | 592 |
1759569 | 1759569 | 2021-09-27 | Hinds | Mississippi | 28049 | 31184 | 589 |
1756321 | 1756321 | 2021-09-26 | Hinds | Mississippi | 28049 | 31021 | 589 |
1753073 | 1753073 | 2021-09-25 | Hinds | Mississippi | 28049 | 31021 | 589 |
1749825 | 1749825 | 2021-09-24 | Hinds | Mississippi | 28049 | 31021 | 589 |
1746575 | 1746575 | 2021-09-23 | Hinds | Mississippi | 28049 | 30973 | 586 |
1743326 | 1743326 | 2021-09-22 | Hinds | Mississippi | 28049 | 30924 | 582 |
1740077 | 1740077 | 2021-09-21 | Hinds | Mississippi | 28049 | 30882 | 581 |
1736828 | 1736828 | 2021-09-20 | Hinds | Mississippi | 28049 | 30837 | 579 |
1733578 | 1733578 | 2021-09-19 | Hinds | Mississippi | 28049 | 30703 | 575 |
1730328 | 1730328 | 2021-09-18 | Hinds | Mississippi | 28049 | 30703 | 575 |
1727078 | 1727078 | 2021-09-17 | Hinds | Mississippi | 28049 | 30703 | 575 |
1723829 | 1723829 | 2021-09-16 | Hinds | Mississippi | 28049 | 30628 | 574 |
1720580 | 1720580 | 2021-09-15 | Hinds | Mississippi | 28049 | 30552 | 569 |
1717332 | 1717332 | 2021-09-14 | Hinds | Mississippi | 28049 | 30454 | 568 |
1714084 | 1714084 | 2021-09-13 | Hinds | Mississippi | 28049 | 30337 | 561 |
1710838 | 1710838 | 2021-09-12 | Hinds | Mississippi | 28049 | 30194 | 557 |
1707591 | 1707591 | 2021-09-11 | Hinds | Mississippi | 28049 | 30194 | 557 |
1704344 | 1704344 | 2021-09-10 | Hinds | Mississippi | 28049 | 30194 | 557 |
1701094 | 1701094 | 2021-09-09 | Hinds | Mississippi | 28049 | 30110 | 556 |
1697845 | 1697845 | 2021-09-08 | Hinds | Mississippi | 28049 | 30002 | 555 |
1694597 | 1694597 | 2021-09-07 | Hinds | Mississippi | 28049 | 29947 | 545 |
1691348 | 1691348 | 2021-09-06 | Hinds | Mississippi | 28049 | 29896 | 543 |
1688098 | 1688098 | 2021-09-05 | Hinds | Mississippi | 28049 | 29522 | 541 |
1684848 | 1684848 | 2021-09-04 | Hinds | Mississippi | 28049 | 29522 | 541 |
1681597 | 1681597 | 2021-09-03 | Hinds | Mississippi | 28049 | 29522 | 541 |
1678349 | 1678349 | 2021-09-02 | Hinds | Mississippi | 28049 | 29392 | 535 |
1675101 | 1675101 | 2021-09-01 | Hinds | Mississippi | 28049 | 29309 | 534 |
1671853 | 1671853 | 2021-08-31 | Hinds | Mississippi | 28049 | 29253 | 527 |
1668606 | 1668606 | 2021-08-30 | Hinds | Mississippi | 28049 | 29209 | 525 |
1665359 | 1665359 | 2021-08-29 | Hinds | Mississippi | 28049 | 28436 | 522 |
1662111 | 1662111 | 2021-08-28 | Hinds | Mississippi | 28049 | 28436 | 522 |
1658863 | 1658863 | 2021-08-27 | Hinds | Mississippi | 28049 | 28436 | 522 |
1655614 | 1655614 | 2021-08-26 | Hinds | Mississippi | 28049 | 28293 | 516 |
1652367 | 1652367 | 2021-08-25 | Hinds | Mississippi | 28049 | 28101 | 516 |
1649119 | 1649119 | 2021-08-24 | Hinds | Mississippi | 28049 | 27843 | 515 |
1645870 | 1645870 | 2021-08-23 | Hinds | Mississippi | 28049 | 27729 | 505 |
1642621 | 1642621 | 2021-08-22 | Hinds | Mississippi | 28049 | 27441 | 500 |
1639371 | 1639371 | 2021-08-21 | Hinds | Mississippi | 28049 | 27441 | 500 |
1636121 | 1636121 | 2021-08-20 | Hinds | Mississippi | 28049 | 27441 | 500 |
1632871 | 1632871 | 2021-08-19 | Hinds | Mississippi | 28049 | 27164 | 499 |
1629624 | 1629624 | 2021-08-18 | Hinds | Mississippi | 28049 | 26960 | 494 |
1626377 | 1626377 | 2021-08-17 | Hinds | Mississippi | 28049 | 26784 | 489 |
1623130 | 1623130 | 2021-08-16 | Hinds | Mississippi | 28049 | 26614 | 479 |
1619883 | 1619883 | 2021-08-15 | Hinds | Mississippi | 28049 | 26196 | 473 |
1616635 | 1616635 | 2021-08-14 | Hinds | Mississippi | 28049 | 26196 | 473 |
1613387 | 1613387 | 2021-08-13 | Hinds | Mississippi | 28049 | 26196 | 473 |
1610138 | 1610138 | 2021-08-12 | Hinds | Mississippi | 28049 | 25992 | 470 |
1606890 | 1606890 | 2021-08-11 | Hinds | Mississippi | 28049 | 25781 | 466 |
1603641 | 1603641 | 2021-08-10 | Hinds | Mississippi | 28049 | 25616 | 464 |
1600392 | 1600392 | 2021-08-09 | Hinds | Mississippi | 28049 | 25501 | 458 |
1597144 | 1597144 | 2021-08-08 | Hinds | Mississippi | 28049 | 25039 | 457 |
1593895 | 1593895 | 2021-08-07 | Hinds | Mississippi | 28049 | 25039 | 457 |
1590646 | 1590646 | 2021-08-06 | Hinds | Mississippi | 28049 | 25039 | 457 |
1587397 | 1587397 | 2021-08-05 | Hinds | Mississippi | 28049 | 24906 | 455 |
1584146 | 1584146 | 2021-08-04 | Hinds | Mississippi | 28049 | 24704 | 451 |
1580897 | 1580897 | 2021-08-03 | Hinds | Mississippi | 28049 | 24512 | 449 |
1577648 | 1577648 | 2021-08-02 | Hinds | Mississippi | 28049 | 24427 | 446 |
1574400 | 1574400 | 2021-08-01 | Hinds | Mississippi | 28049 | 23932 | 444 |
1571152 | 1571152 | 2021-07-31 | Hinds | Mississippi | 28049 | 23932 | 444 |
1567904 | 1567904 | 2021-07-30 | Hinds | Mississippi | 28049 | 23932 | 444 |
1564656 | 1564656 | 2021-07-29 | Hinds | Mississippi | 28049 | 23783 | 441 |
1561408 | 1561408 | 2021-07-28 | Hinds | Mississippi | 28049 | 23586 | 440 |
1558160 | 1558160 | 2021-07-27 | Hinds | Mississippi | 28049 | 23409 | 440 |
1554913 | 1554913 | 2021-07-26 | Hinds | Mississippi | 28049 | 23268 | 438 |
1551666 | 1551666 | 2021-07-25 | Hinds | Mississippi | 28049 | 22780 | 438 |
1548419 | 1548419 | 2021-07-24 | Hinds | Mississippi | 28049 | 22780 | 438 |
1545172 | 1545172 | 2021-07-23 | Hinds | Mississippi | 28049 | 22780 | 438 |
1541924 | 1541924 | 2021-07-22 | Hinds | Mississippi | 28049 | 22625 | 437 |
1538677 | 1538677 | 2021-07-21 | Hinds | Mississippi | 28049 | 22483 | 433 |
1535430 | 1535430 | 2021-07-20 | Hinds | Mississippi | 28049 | 22385 | 431 |
1532182 | 1532182 | 2021-07-19 | Hinds | Mississippi | 28049 | 22322 | 429 |
1528935 | 1528935 | 2021-07-18 | Hinds | Mississippi | 28049 | 21935 | 429 |
1525688 | 1525688 | 2021-07-17 | Hinds | Mississippi | 28049 | 21935 | 429 |
1522441 | 1522441 | 2021-07-16 | Hinds | Mississippi | 28049 | 21935 | 429 |
1519192 | 1519192 | 2021-07-15 | Hinds | Mississippi | 28049 | 21843 | 429 |
1515945 | 1515945 | 2021-07-14 | Hinds | Mississippi | 28049 | 21740 | 429 |
1512699 | 1512699 | 2021-07-13 | Hinds | Mississippi | 28049 | 21625 | 428 |
1509452 | 1509452 | 2021-07-12 | Hinds | Mississippi | 28049 | 21573 | 428 |
1506206 | 1506206 | 2021-07-11 | Hinds | Mississippi | 28049 | 21363 | 427 |
1502960 | 1502960 | 2021-07-10 | Hinds | Mississippi | 28049 | 21363 | 427 |
1499714 | 1499714 | 2021-07-09 | Hinds | Mississippi | 28049 | 21363 | 427 |
1496468 | 1496468 | 2021-07-08 | Hinds | Mississippi | 28049 | 21273 | 427 |
1493221 | 1493221 | 2021-07-07 | Hinds | Mississippi | 28049 | 21206 | 427 |
1489974 | 1489974 | 2021-07-06 | Hinds | Mississippi | 28049 | 21150 | 425 |
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);