ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where county = "Monroe" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1948059 | 1948059 | 2021-11-24 | Monroe | Mississippi | 28095 | 6989 | 179 |
1944808 | 1944808 | 2021-11-23 | Monroe | Mississippi | 28095 | 6978 | 179 |
1941557 | 1941557 | 2021-11-22 | Monroe | Mississippi | 28095 | 6970 | 179 |
1938307 | 1938307 | 2021-11-21 | Monroe | Mississippi | 28095 | 6940 | 179 |
1935057 | 1935057 | 2021-11-20 | Monroe | Mississippi | 28095 | 6940 | 179 |
1931807 | 1931807 | 2021-11-19 | Monroe | Mississippi | 28095 | 6940 | 179 |
1928556 | 1928556 | 2021-11-18 | Monroe | Mississippi | 28095 | 6931 | 179 |
1925306 | 1925306 | 2021-11-17 | Monroe | Mississippi | 28095 | 6924 | 179 |
1922057 | 1922057 | 2021-11-16 | Monroe | Mississippi | 28095 | 6922 | 179 |
1918807 | 1918807 | 2021-11-15 | Monroe | Mississippi | 28095 | 6912 | 179 |
1915557 | 1915557 | 2021-11-14 | Monroe | Mississippi | 28095 | 6893 | 179 |
1912307 | 1912307 | 2021-11-13 | Monroe | Mississippi | 28095 | 6893 | 179 |
1909057 | 1909057 | 2021-11-12 | Monroe | Mississippi | 28095 | 6893 | 179 |
1905808 | 1905808 | 2021-11-11 | Monroe | Mississippi | 28095 | 6874 | 179 |
1902559 | 1902559 | 2021-11-10 | Monroe | Mississippi | 28095 | 6874 | 179 |
1899309 | 1899309 | 2021-11-09 | Monroe | Mississippi | 28095 | 6871 | 179 |
1896059 | 1896059 | 2021-11-08 | Monroe | Mississippi | 28095 | 6864 | 179 |
1892809 | 1892809 | 2021-11-07 | Monroe | Mississippi | 28095 | 6856 | 179 |
1889559 | 1889559 | 2021-11-06 | Monroe | Mississippi | 28095 | 6856 | 179 |
1886309 | 1886309 | 2021-11-05 | Monroe | Mississippi | 28095 | 6856 | 179 |
1883060 | 1883060 | 2021-11-04 | Monroe | Mississippi | 28095 | 6847 | 179 |
1879811 | 1879811 | 2021-11-03 | Monroe | Mississippi | 28095 | 6842 | 179 |
1876562 | 1876562 | 2021-11-02 | Monroe | Mississippi | 28095 | 6833 | 179 |
1873313 | 1873313 | 2021-11-01 | Monroe | Mississippi | 28095 | 6832 | 179 |
1870064 | 1870064 | 2021-10-31 | Monroe | Mississippi | 28095 | 6822 | 179 |
1866815 | 1866815 | 2021-10-30 | Monroe | Mississippi | 28095 | 6822 | 179 |
1863566 | 1863566 | 2021-10-29 | Monroe | Mississippi | 28095 | 6822 | 179 |
1860317 | 1860317 | 2021-10-28 | Monroe | Mississippi | 28095 | 6807 | 178 |
1857068 | 1857068 | 2021-10-27 | Monroe | Mississippi | 28095 | 6802 | 178 |
1853819 | 1853819 | 2021-10-26 | Monroe | Mississippi | 28095 | 6796 | 178 |
1850570 | 1850570 | 2021-10-25 | Monroe | Mississippi | 28095 | 6787 | 178 |
1847320 | 1847320 | 2021-10-24 | Monroe | Mississippi | 28095 | 6777 | 177 |
1844070 | 1844070 | 2021-10-23 | Monroe | Mississippi | 28095 | 6777 | 177 |
1840820 | 1840820 | 2021-10-22 | Monroe | Mississippi | 28095 | 6777 | 177 |
1837571 | 1837571 | 2021-10-21 | Monroe | Mississippi | 28095 | 6769 | 176 |
1834322 | 1834322 | 2021-10-20 | Monroe | Mississippi | 28095 | 6765 | 176 |
1831073 | 1831073 | 2021-10-19 | Monroe | Mississippi | 28095 | 6763 | 176 |
1827824 | 1827824 | 2021-10-18 | Monroe | Mississippi | 28095 | 6740 | 174 |
1824575 | 1824575 | 2021-10-17 | Monroe | Mississippi | 28095 | 6727 | 174 |
1821326 | 1821326 | 2021-10-16 | Monroe | Mississippi | 28095 | 6727 | 174 |
1818077 | 1818077 | 2021-10-15 | Monroe | Mississippi | 28095 | 6727 | 174 |
1814828 | 1814828 | 2021-10-14 | Monroe | Mississippi | 28095 | 6713 | 173 |
1811580 | 1811580 | 2021-10-13 | Monroe | Mississippi | 28095 | 6702 | 173 |
1808331 | 1808331 | 2021-10-12 | Monroe | Mississippi | 28095 | 6690 | 173 |
1805080 | 1805080 | 2021-10-11 | Monroe | Mississippi | 28095 | 6674 | 173 |
1801831 | 1801831 | 2021-10-10 | Monroe | Mississippi | 28095 | 6661 | 173 |
1798582 | 1798582 | 2021-10-09 | Monroe | Mississippi | 28095 | 6661 | 173 |
1795333 | 1795333 | 2021-10-08 | Monroe | Mississippi | 28095 | 6661 | 173 |
1792084 | 1792084 | 2021-10-07 | Monroe | Mississippi | 28095 | 6656 | 173 |
1788835 | 1788835 | 2021-10-06 | Monroe | Mississippi | 28095 | 6645 | 173 |
1785587 | 1785587 | 2021-10-05 | Monroe | Mississippi | 28095 | 6632 | 173 |
1782338 | 1782338 | 2021-10-04 | Monroe | Mississippi | 28095 | 6623 | 172 |
1779088 | 1779088 | 2021-10-03 | Monroe | Mississippi | 28095 | 6601 | 172 |
1775838 | 1775838 | 2021-10-02 | Monroe | Mississippi | 28095 | 6601 | 172 |
1772588 | 1772588 | 2021-10-01 | Monroe | Mississippi | 28095 | 6601 | 172 |
1769339 | 1769339 | 2021-09-30 | Monroe | Mississippi | 28095 | 6583 | 169 |
1766090 | 1766090 | 2021-09-29 | Monroe | Mississippi | 28095 | 6564 | 169 |
1762841 | 1762841 | 2021-09-28 | Monroe | Mississippi | 28095 | 6550 | 167 |
1759592 | 1759592 | 2021-09-27 | Monroe | Mississippi | 28095 | 6533 | 167 |
1756344 | 1756344 | 2021-09-26 | Monroe | Mississippi | 28095 | 6514 | 164 |
1753096 | 1753096 | 2021-09-25 | Monroe | Mississippi | 28095 | 6514 | 164 |
1749848 | 1749848 | 2021-09-24 | Monroe | Mississippi | 28095 | 6514 | 164 |
1746598 | 1746598 | 2021-09-23 | Monroe | Mississippi | 28095 | 6491 | 161 |
1743349 | 1743349 | 2021-09-22 | Monroe | Mississippi | 28095 | 6459 | 159 |
1740100 | 1740100 | 2021-09-21 | Monroe | Mississippi | 28095 | 6431 | 158 |
1736851 | 1736851 | 2021-09-20 | Monroe | Mississippi | 28095 | 6406 | 158 |
1733601 | 1733601 | 2021-09-19 | Monroe | Mississippi | 28095 | 6372 | 158 |
1730351 | 1730351 | 2021-09-18 | Monroe | Mississippi | 28095 | 6372 | 158 |
1727101 | 1727101 | 2021-09-17 | Monroe | Mississippi | 28095 | 6372 | 158 |
1723852 | 1723852 | 2021-09-16 | Monroe | Mississippi | 28095 | 6343 | 158 |
1720603 | 1720603 | 2021-09-15 | Monroe | Mississippi | 28095 | 6304 | 156 |
1717355 | 1717355 | 2021-09-14 | Monroe | Mississippi | 28095 | 6265 | 156 |
1714107 | 1714107 | 2021-09-13 | Monroe | Mississippi | 28095 | 6239 | 156 |
1710861 | 1710861 | 2021-09-12 | Monroe | Mississippi | 28095 | 6184 | 155 |
1707614 | 1707614 | 2021-09-11 | Monroe | Mississippi | 28095 | 6184 | 155 |
1704367 | 1704367 | 2021-09-10 | Monroe | Mississippi | 28095 | 6184 | 155 |
1701117 | 1701117 | 2021-09-09 | Monroe | Mississippi | 28095 | 6153 | 155 |
1697868 | 1697868 | 2021-09-08 | Monroe | Mississippi | 28095 | 6106 | 155 |
1694620 | 1694620 | 2021-09-07 | Monroe | Mississippi | 28095 | 6071 | 155 |
1691371 | 1691371 | 2021-09-06 | Monroe | Mississippi | 28095 | 6063 | 155 |
1688121 | 1688121 | 2021-09-05 | Monroe | Mississippi | 28095 | 5987 | 152 |
1684871 | 1684871 | 2021-09-04 | Monroe | Mississippi | 28095 | 5987 | 152 |
1681620 | 1681620 | 2021-09-03 | Monroe | Mississippi | 28095 | 5987 | 152 |
1678372 | 1678372 | 2021-09-02 | Monroe | Mississippi | 28095 | 5891 | 150 |
1675124 | 1675124 | 2021-09-01 | Monroe | Mississippi | 28095 | 5835 | 150 |
1671876 | 1671876 | 2021-08-31 | Monroe | Mississippi | 28095 | 5776 | 150 |
1668629 | 1668629 | 2021-08-30 | Monroe | Mississippi | 28095 | 5760 | 150 |
1665382 | 1665382 | 2021-08-29 | Monroe | Mississippi | 28095 | 5634 | 145 |
1662134 | 1662134 | 2021-08-28 | Monroe | Mississippi | 28095 | 5634 | 145 |
1658886 | 1658886 | 2021-08-27 | Monroe | Mississippi | 28095 | 5634 | 145 |
1655637 | 1655637 | 2021-08-26 | Monroe | Mississippi | 28095 | 5555 | 144 |
1652390 | 1652390 | 2021-08-25 | Monroe | Mississippi | 28095 | 5423 | 144 |
1649142 | 1649142 | 2021-08-24 | Monroe | Mississippi | 28095 | 5389 | 144 |
1645893 | 1645893 | 2021-08-23 | Monroe | Mississippi | 28095 | 5324 | 141 |
1642644 | 1642644 | 2021-08-22 | Monroe | Mississippi | 28095 | 5202 | 140 |
1639394 | 1639394 | 2021-08-21 | Monroe | Mississippi | 28095 | 5202 | 140 |
1636144 | 1636144 | 2021-08-20 | Monroe | Mississippi | 28095 | 5202 | 140 |
1632894 | 1632894 | 2021-08-19 | Monroe | Mississippi | 28095 | 5127 | 139 |
1629647 | 1629647 | 2021-08-18 | Monroe | Mississippi | 28095 | 5026 | 139 |
1626400 | 1626400 | 2021-08-17 | Monroe | Mississippi | 28095 | 4978 | 139 |
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);