ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Adams" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1948012 | 1948012 | 2021-11-24 | Adams | Mississippi | 28001 | 4766 | 125 |
1944761 | 1944761 | 2021-11-23 | Adams | Mississippi | 28001 | 4764 | 125 |
1941510 | 1941510 | 2021-11-22 | Adams | Mississippi | 28001 | 4747 | 125 |
1938260 | 1938260 | 2021-11-21 | Adams | Mississippi | 28001 | 4688 | 125 |
1935010 | 1935010 | 2021-11-20 | Adams | Mississippi | 28001 | 4688 | 125 |
1931760 | 1931760 | 2021-11-19 | Adams | Mississippi | 28001 | 4688 | 125 |
1928509 | 1928509 | 2021-11-18 | Adams | Mississippi | 28001 | 4684 | 125 |
1925259 | 1925259 | 2021-11-17 | Adams | Mississippi | 28001 | 4682 | 125 |
1922010 | 1922010 | 2021-11-16 | Adams | Mississippi | 28001 | 4680 | 125 |
1918760 | 1918760 | 2021-11-15 | Adams | Mississippi | 28001 | 4675 | 125 |
1915510 | 1915510 | 2021-11-14 | Adams | Mississippi | 28001 | 4667 | 125 |
1912260 | 1912260 | 2021-11-13 | Adams | Mississippi | 28001 | 4667 | 125 |
1909010 | 1909010 | 2021-11-12 | Adams | Mississippi | 28001 | 4667 | 125 |
1905761 | 1905761 | 2021-11-11 | Adams | Mississippi | 28001 | 4665 | 125 |
1902512 | 1902512 | 2021-11-10 | Adams | Mississippi | 28001 | 4665 | 125 |
1899262 | 1899262 | 2021-11-09 | Adams | Mississippi | 28001 | 4665 | 124 |
1896012 | 1896012 | 2021-11-08 | Adams | Mississippi | 28001 | 4664 | 123 |
1892762 | 1892762 | 2021-11-07 | Adams | Mississippi | 28001 | 4660 | 123 |
1889512 | 1889512 | 2021-11-06 | Adams | Mississippi | 28001 | 4660 | 123 |
1886262 | 1886262 | 2021-11-05 | Adams | Mississippi | 28001 | 4660 | 123 |
1883013 | 1883013 | 2021-11-04 | Adams | Mississippi | 28001 | 4652 | 122 |
1879764 | 1879764 | 2021-11-03 | Adams | Mississippi | 28001 | 4652 | 122 |
1876515 | 1876515 | 2021-11-02 | Adams | Mississippi | 28001 | 4647 | 122 |
1873266 | 1873266 | 2021-11-01 | Adams | Mississippi | 28001 | 4630 | 122 |
1870017 | 1870017 | 2021-10-31 | Adams | Mississippi | 28001 | 4623 | 120 |
1866768 | 1866768 | 2021-10-30 | Adams | Mississippi | 28001 | 4623 | 120 |
1863519 | 1863519 | 2021-10-29 | Adams | Mississippi | 28001 | 4623 | 120 |
1860270 | 1860270 | 2021-10-28 | Adams | Mississippi | 28001 | 4622 | 120 |
1857021 | 1857021 | 2021-10-27 | Adams | Mississippi | 28001 | 4618 | 120 |
1853772 | 1853772 | 2021-10-26 | Adams | Mississippi | 28001 | 4617 | 120 |
1850523 | 1850523 | 2021-10-25 | Adams | Mississippi | 28001 | 4592 | 119 |
1847273 | 1847273 | 2021-10-24 | Adams | Mississippi | 28001 | 4587 | 119 |
1844023 | 1844023 | 2021-10-23 | Adams | Mississippi | 28001 | 4587 | 119 |
1840773 | 1840773 | 2021-10-22 | Adams | Mississippi | 28001 | 4587 | 119 |
1837524 | 1837524 | 2021-10-21 | Adams | Mississippi | 28001 | 4586 | 119 |
1834275 | 1834275 | 2021-10-20 | Adams | Mississippi | 28001 | 4584 | 119 |
1831026 | 1831026 | 2021-10-19 | Adams | Mississippi | 28001 | 4584 | 119 |
1827777 | 1827777 | 2021-10-18 | Adams | Mississippi | 28001 | 4577 | 119 |
1824528 | 1824528 | 2021-10-17 | Adams | Mississippi | 28001 | 4570 | 119 |
1821279 | 1821279 | 2021-10-16 | Adams | Mississippi | 28001 | 4570 | 119 |
1818030 | 1818030 | 2021-10-15 | Adams | Mississippi | 28001 | 4570 | 119 |
1814781 | 1814781 | 2021-10-14 | Adams | Mississippi | 28001 | 4570 | 119 |
1811533 | 1811533 | 2021-10-13 | Adams | Mississippi | 28001 | 4567 | 119 |
1808284 | 1808284 | 2021-10-12 | Adams | Mississippi | 28001 | 4563 | 119 |
1805033 | 1805033 | 2021-10-11 | Adams | Mississippi | 28001 | 4537 | 119 |
1801784 | 1801784 | 2021-10-10 | Adams | Mississippi | 28001 | 4528 | 119 |
1798535 | 1798535 | 2021-10-09 | Adams | Mississippi | 28001 | 4528 | 119 |
1795286 | 1795286 | 2021-10-08 | Adams | Mississippi | 28001 | 4528 | 119 |
1792037 | 1792037 | 2021-10-07 | Adams | Mississippi | 28001 | 4524 | 119 |
1788788 | 1788788 | 2021-10-06 | Adams | Mississippi | 28001 | 4506 | 119 |
1785540 | 1785540 | 2021-10-05 | Adams | Mississippi | 28001 | 4498 | 119 |
1782291 | 1782291 | 2021-10-04 | Adams | Mississippi | 28001 | 4471 | 119 |
1779041 | 1779041 | 2021-10-03 | Adams | Mississippi | 28001 | 4462 | 118 |
1775791 | 1775791 | 2021-10-02 | Adams | Mississippi | 28001 | 4462 | 118 |
1772541 | 1772541 | 2021-10-01 | Adams | Mississippi | 28001 | 4462 | 118 |
1769292 | 1769292 | 2021-09-30 | Adams | Mississippi | 28001 | 4458 | 117 |
1766043 | 1766043 | 2021-09-29 | Adams | Mississippi | 28001 | 4443 | 117 |
1762794 | 1762794 | 2021-09-28 | Adams | Mississippi | 28001 | 4436 | 117 |
1759545 | 1759545 | 2021-09-27 | Adams | Mississippi | 28001 | 4429 | 117 |
1756297 | 1756297 | 2021-09-26 | Adams | Mississippi | 28001 | 4416 | 116 |
1753049 | 1753049 | 2021-09-25 | Adams | Mississippi | 28001 | 4416 | 116 |
1749801 | 1749801 | 2021-09-24 | Adams | Mississippi | 28001 | 4416 | 116 |
1746551 | 1746551 | 2021-09-23 | Adams | Mississippi | 28001 | 4403 | 116 |
1743302 | 1743302 | 2021-09-22 | Adams | Mississippi | 28001 | 4376 | 116 |
1740053 | 1740053 | 2021-09-21 | Adams | Mississippi | 28001 | 4365 | 116 |
1736804 | 1736804 | 2021-09-20 | Adams | Mississippi | 28001 | 4309 | 114 |
1733554 | 1733554 | 2021-09-19 | Adams | Mississippi | 28001 | 4219 | 114 |
1730304 | 1730304 | 2021-09-18 | Adams | Mississippi | 28001 | 4219 | 114 |
1727054 | 1727054 | 2021-09-17 | Adams | Mississippi | 28001 | 4219 | 114 |
1723805 | 1723805 | 2021-09-16 | Adams | Mississippi | 28001 | 4184 | 110 |
1720556 | 1720556 | 2021-09-15 | Adams | Mississippi | 28001 | 4174 | 109 |
1717308 | 1717308 | 2021-09-14 | Adams | Mississippi | 28001 | 4166 | 109 |
1714060 | 1714060 | 2021-09-13 | Adams | Mississippi | 28001 | 4141 | 109 |
1710814 | 1710814 | 2021-09-12 | Adams | Mississippi | 28001 | 4125 | 109 |
1707567 | 1707567 | 2021-09-11 | Adams | Mississippi | 28001 | 4125 | 109 |
1704320 | 1704320 | 2021-09-10 | Adams | Mississippi | 28001 | 4125 | 109 |
1701070 | 1701070 | 2021-09-09 | Adams | Mississippi | 28001 | 4116 | 109 |
1697821 | 1697821 | 2021-09-08 | Adams | Mississippi | 28001 | 4103 | 109 |
1694573 | 1694573 | 2021-09-07 | Adams | Mississippi | 28001 | 4101 | 109 |
1691324 | 1691324 | 2021-09-06 | Adams | Mississippi | 28001 | 4095 | 109 |
1688074 | 1688074 | 2021-09-05 | Adams | Mississippi | 28001 | 4038 | 107 |
1684824 | 1684824 | 2021-09-04 | Adams | Mississippi | 28001 | 4038 | 107 |
1681573 | 1681573 | 2021-09-03 | Adams | Mississippi | 28001 | 4038 | 107 |
1678325 | 1678325 | 2021-09-02 | Adams | Mississippi | 28001 | 3990 | 107 |
1675077 | 1675077 | 2021-09-01 | Adams | Mississippi | 28001 | 3982 | 107 |
1671829 | 1671829 | 2021-08-31 | Adams | Mississippi | 28001 | 3972 | 106 |
1668582 | 1668582 | 2021-08-30 | Adams | Mississippi | 28001 | 3971 | 106 |
1665335 | 1665335 | 2021-08-29 | Adams | Mississippi | 28001 | 3947 | 105 |
1662087 | 1662087 | 2021-08-28 | Adams | Mississippi | 28001 | 3947 | 105 |
1658839 | 1658839 | 2021-08-27 | Adams | Mississippi | 28001 | 3947 | 105 |
1655590 | 1655590 | 2021-08-26 | Adams | Mississippi | 28001 | 3922 | 102 |
1652343 | 1652343 | 2021-08-25 | Adams | Mississippi | 28001 | 3910 | 102 |
1649095 | 1649095 | 2021-08-24 | Adams | Mississippi | 28001 | 3888 | 101 |
1645846 | 1645846 | 2021-08-23 | Adams | Mississippi | 28001 | 3872 | 99 |
1642597 | 1642597 | 2021-08-22 | Adams | Mississippi | 28001 | 3853 | 98 |
1639347 | 1639347 | 2021-08-21 | Adams | Mississippi | 28001 | 3853 | 98 |
1636097 | 1636097 | 2021-08-20 | Adams | Mississippi | 28001 | 3853 | 98 |
1632847 | 1632847 | 2021-08-19 | Adams | Mississippi | 28001 | 3840 | 94 |
1629600 | 1629600 | 2021-08-18 | Adams | Mississippi | 28001 | 3822 | 94 |
1626353 | 1626353 | 2021-08-17 | Adams | Mississippi | 28001 | 3800 | 93 |
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);