ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Leflore" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2110586 | 2110586 | 2022-01-13 | Leflore | Mississippi | 28083 | 6447 | 145 |
2107335 | 2107335 | 2022-01-12 | Leflore | Mississippi | 28083 | 6392 | 145 |
2104084 | 2104084 | 2022-01-11 | Leflore | Mississippi | 28083 | 6322 | 145 |
2100833 | 2100833 | 2022-01-10 | Leflore | Mississippi | 28083 | 6272 | 144 |
2097582 | 2097582 | 2022-01-09 | Leflore | Mississippi | 28083 | 6035 | 144 |
2094330 | 2094330 | 2022-01-08 | Leflore | Mississippi | 28083 | 6035 | 144 |
2091078 | 2091078 | 2022-01-07 | Leflore | Mississippi | 28083 | 6035 | 144 |
2087827 | 2087827 | 2022-01-06 | Leflore | Mississippi | 28083 | 5876 | 144 |
2084575 | 2084575 | 2022-01-05 | Leflore | Mississippi | 28083 | 5814 | 144 |
2081323 | 2081323 | 2022-01-04 | Leflore | Mississippi | 28083 | 5707 | 144 |
2078071 | 2078071 | 2022-01-03 | Leflore | Mississippi | 28083 | 5601 | 144 |
2074820 | 2074820 | 2022-01-02 | Leflore | Mississippi | 28083 | 5280 | 144 |
2071569 | 2071569 | 2022-01-01 | Leflore | Mississippi | 28083 | 5280 | 144 |
2068318 | 2068318 | 2021-12-31 | Leflore | Mississippi | 28083 | 5280 | 144 |
2065067 | 2065067 | 2021-12-30 | Leflore | Mississippi | 28083 | 5280 | 144 |
2061817 | 2061817 | 2021-12-29 | Leflore | Mississippi | 28083 | 5225 | 144 |
2058568 | 2058568 | 2021-12-28 | Leflore | Mississippi | 28083 | 5143 | 144 |
2055319 | 2055319 | 2021-12-27 | Leflore | Mississippi | 28083 | 5072 | 144 |
2052069 | 2052069 | 2021-12-26 | Leflore | Mississippi | 28083 | 4888 | 144 |
2048819 | 2048819 | 2021-12-25 | Leflore | Mississippi | 28083 | 4888 | 144 |
2045569 | 2045569 | 2021-12-24 | Leflore | Mississippi | 28083 | 4888 | 144 |
2042319 | 2042319 | 2021-12-23 | Leflore | Mississippi | 28083 | 4888 | 144 |
2039070 | 2039070 | 2021-12-22 | Leflore | Mississippi | 28083 | 4888 | 144 |
2035820 | 2035820 | 2021-12-21 | Leflore | Mississippi | 28083 | 4858 | 144 |
2032570 | 2032570 | 2021-12-20 | Leflore | Mississippi | 28083 | 4845 | 144 |
2029319 | 2029319 | 2021-12-19 | Leflore | Mississippi | 28083 | 4814 | 144 |
2026068 | 2026068 | 2021-12-18 | Leflore | Mississippi | 28083 | 4814 | 144 |
2022817 | 2022817 | 2021-12-17 | Leflore | Mississippi | 28083 | 4814 | 144 |
2019566 | 2019566 | 2021-12-16 | Leflore | Mississippi | 28083 | 4805 | 144 |
2016316 | 2016316 | 2021-12-15 | Leflore | Mississippi | 28083 | 4803 | 144 |
2013065 | 2013065 | 2021-12-14 | Leflore | Mississippi | 28083 | 4796 | 144 |
2009814 | 2009814 | 2021-12-13 | Leflore | Mississippi | 28083 | 4792 | 144 |
2006563 | 2006563 | 2021-12-12 | Leflore | Mississippi | 28083 | 4778 | 144 |
2003312 | 2003312 | 2021-12-11 | Leflore | Mississippi | 28083 | 4778 | 144 |
2000062 | 2000062 | 2021-12-10 | Leflore | Mississippi | 28083 | 4778 | 144 |
1996811 | 1996811 | 2021-12-09 | Leflore | Mississippi | 28083 | 4777 | 144 |
1993560 | 1993560 | 2021-12-08 | Leflore | Mississippi | 28083 | 4773 | 144 |
1990309 | 1990309 | 2021-12-07 | Leflore | Mississippi | 28083 | 4765 | 144 |
1987059 | 1987059 | 2021-12-06 | Leflore | Mississippi | 28083 | 4756 | 144 |
1983809 | 1983809 | 2021-12-05 | Leflore | Mississippi | 28083 | 4749 | 144 |
1980559 | 1980559 | 2021-12-04 | Leflore | Mississippi | 28083 | 4749 | 144 |
1977309 | 1977309 | 2021-12-03 | Leflore | Mississippi | 28083 | 4749 | 144 |
1974059 | 1974059 | 2021-12-02 | Leflore | Mississippi | 28083 | 4747 | 144 |
1970810 | 1970810 | 2021-12-01 | Leflore | Mississippi | 28083 | 4742 | 144 |
1967560 | 1967560 | 2021-11-30 | Leflore | Mississippi | 28083 | 4736 | 144 |
1964308 | 1964308 | 2021-11-29 | Leflore | Mississippi | 28083 | 4729 | 144 |
1961057 | 1961057 | 2021-11-28 | Leflore | Mississippi | 28083 | 4723 | 144 |
1957806 | 1957806 | 2021-11-27 | Leflore | Mississippi | 28083 | 4723 | 144 |
1954555 | 1954555 | 2021-11-26 | Leflore | Mississippi | 28083 | 4723 | 144 |
1951304 | 1951304 | 2021-11-25 | Leflore | Mississippi | 28083 | 4723 | 144 |
1948053 | 1948053 | 2021-11-24 | Leflore | Mississippi | 28083 | 4723 | 144 |
1944802 | 1944802 | 2021-11-23 | Leflore | Mississippi | 28083 | 4721 | 144 |
1941551 | 1941551 | 2021-11-22 | Leflore | Mississippi | 28083 | 4717 | 144 |
1938301 | 1938301 | 2021-11-21 | Leflore | Mississippi | 28083 | 4708 | 144 |
1935051 | 1935051 | 2021-11-20 | Leflore | Mississippi | 28083 | 4708 | 144 |
1931801 | 1931801 | 2021-11-19 | Leflore | Mississippi | 28083 | 4708 | 144 |
1928550 | 1928550 | 2021-11-18 | Leflore | Mississippi | 28083 | 4708 | 144 |
1925300 | 1925300 | 2021-11-17 | Leflore | Mississippi | 28083 | 4706 | 144 |
1922051 | 1922051 | 2021-11-16 | Leflore | Mississippi | 28083 | 4707 | 144 |
1918801 | 1918801 | 2021-11-15 | Leflore | Mississippi | 28083 | 4707 | 144 |
1915551 | 1915551 | 2021-11-14 | Leflore | Mississippi | 28083 | 4703 | 144 |
1912301 | 1912301 | 2021-11-13 | Leflore | Mississippi | 28083 | 4703 | 144 |
1909051 | 1909051 | 2021-11-12 | Leflore | Mississippi | 28083 | 4703 | 144 |
1905802 | 1905802 | 2021-11-11 | Leflore | Mississippi | 28083 | 4699 | 144 |
1902553 | 1902553 | 2021-11-10 | Leflore | Mississippi | 28083 | 4699 | 144 |
1899303 | 1899303 | 2021-11-09 | Leflore | Mississippi | 28083 | 4699 | 144 |
1896053 | 1896053 | 2021-11-08 | Leflore | Mississippi | 28083 | 4696 | 144 |
1892803 | 1892803 | 2021-11-07 | Leflore | Mississippi | 28083 | 4693 | 144 |
1889553 | 1889553 | 2021-11-06 | Leflore | Mississippi | 28083 | 4693 | 144 |
1886303 | 1886303 | 2021-11-05 | Leflore | Mississippi | 28083 | 4693 | 144 |
1883054 | 1883054 | 2021-11-04 | Leflore | Mississippi | 28083 | 4692 | 144 |
1879805 | 1879805 | 2021-11-03 | Leflore | Mississippi | 28083 | 4691 | 144 |
1876556 | 1876556 | 2021-11-02 | Leflore | Mississippi | 28083 | 4692 | 144 |
1873307 | 1873307 | 2021-11-01 | Leflore | Mississippi | 28083 | 4688 | 144 |
1870058 | 1870058 | 2021-10-31 | Leflore | Mississippi | 28083 | 4683 | 144 |
1866809 | 1866809 | 2021-10-30 | Leflore | Mississippi | 28083 | 4683 | 144 |
1863560 | 1863560 | 2021-10-29 | Leflore | Mississippi | 28083 | 4683 | 144 |
1860311 | 1860311 | 2021-10-28 | Leflore | Mississippi | 28083 | 4678 | 144 |
1857062 | 1857062 | 2021-10-27 | Leflore | Mississippi | 28083 | 4677 | 144 |
1853813 | 1853813 | 2021-10-26 | Leflore | Mississippi | 28083 | 4676 | 144 |
1850564 | 1850564 | 2021-10-25 | Leflore | Mississippi | 28083 | 4663 | 144 |
1847314 | 1847314 | 2021-10-24 | Leflore | Mississippi | 28083 | 4658 | 144 |
1844064 | 1844064 | 2021-10-23 | Leflore | Mississippi | 28083 | 4658 | 144 |
1840814 | 1840814 | 2021-10-22 | Leflore | Mississippi | 28083 | 4658 | 144 |
1837565 | 1837565 | 2021-10-21 | Leflore | Mississippi | 28083 | 4657 | 144 |
1834316 | 1834316 | 2021-10-20 | Leflore | Mississippi | 28083 | 4654 | 144 |
1831067 | 1831067 | 2021-10-19 | Leflore | Mississippi | 28083 | 4651 | 144 |
1827818 | 1827818 | 2021-10-18 | Leflore | Mississippi | 28083 | 4631 | 144 |
1824569 | 1824569 | 2021-10-17 | Leflore | Mississippi | 28083 | 4627 | 143 |
1821320 | 1821320 | 2021-10-16 | Leflore | Mississippi | 28083 | 4627 | 143 |
1818071 | 1818071 | 2021-10-15 | Leflore | Mississippi | 28083 | 4627 | 143 |
1814822 | 1814822 | 2021-10-14 | Leflore | Mississippi | 28083 | 4626 | 143 |
1811574 | 1811574 | 2021-10-13 | Leflore | Mississippi | 28083 | 4621 | 142 |
1808325 | 1808325 | 2021-10-12 | Leflore | Mississippi | 28083 | 4618 | 142 |
1805074 | 1805074 | 2021-10-11 | Leflore | Mississippi | 28083 | 4600 | 142 |
1801825 | 1801825 | 2021-10-10 | Leflore | Mississippi | 28083 | 4596 | 142 |
1798576 | 1798576 | 2021-10-09 | Leflore | Mississippi | 28083 | 4596 | 142 |
1795327 | 1795327 | 2021-10-08 | Leflore | Mississippi | 28083 | 4596 | 142 |
1792078 | 1792078 | 2021-10-07 | Leflore | Mississippi | 28083 | 4591 | 141 |
1788829 | 1788829 | 2021-10-06 | Leflore | Mississippi | 28083 | 4585 | 141 |
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);