ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
65 rows where deaths = 140, fips = 28073 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2110581 | 2110581 | 2022-01-13 | Lamar | Mississippi | 28073 | 13178 | 140 |
2104079 | 2104079 | 2022-01-11 | Lamar | Mississippi | 28073 | 12653 | 140 |
2100828 | 2100828 | 2022-01-10 | Lamar | Mississippi | 28073 | 12569 | 140 |
2097577 | 2097577 | 2022-01-09 | Lamar | Mississippi | 28073 | 12186 | 140 |
2094325 | 2094325 | 2022-01-08 | Lamar | Mississippi | 28073 | 12186 | 140 |
2091073 | 2091073 | 2022-01-07 | Lamar | Mississippi | 28073 | 12186 | 140 |
2087822 | 2087822 | 2022-01-06 | Lamar | Mississippi | 28073 | 11979 | 140 |
2084570 | 2084570 | 2022-01-05 | Lamar | Mississippi | 28073 | 11823 | 140 |
2081318 | 2081318 | 2022-01-04 | Lamar | Mississippi | 28073 | 11660 | 140 |
2078066 | 2078066 | 2022-01-03 | Lamar | Mississippi | 28073 | 11559 | 140 |
2074815 | 2074815 | 2022-01-02 | Lamar | Mississippi | 28073 | 11225 | 140 |
2071564 | 2071564 | 2022-01-01 | Lamar | Mississippi | 28073 | 11225 | 140 |
2068313 | 2068313 | 2021-12-31 | Lamar | Mississippi | 28073 | 11225 | 140 |
2065062 | 2065062 | 2021-12-30 | Lamar | Mississippi | 28073 | 11225 | 140 |
2061812 | 2061812 | 2021-12-29 | Lamar | Mississippi | 28073 | 11117 | 140 |
2058563 | 2058563 | 2021-12-28 | Lamar | Mississippi | 28073 | 11038 | 140 |
2055314 | 2055314 | 2021-12-27 | Lamar | Mississippi | 28073 | 11001 | 140 |
2052064 | 2052064 | 2021-12-26 | Lamar | Mississippi | 28073 | 10865 | 140 |
2048814 | 2048814 | 2021-12-25 | Lamar | Mississippi | 28073 | 10865 | 140 |
2045564 | 2045564 | 2021-12-24 | Lamar | Mississippi | 28073 | 10865 | 140 |
2042314 | 2042314 | 2021-12-23 | Lamar | Mississippi | 28073 | 10865 | 140 |
2039065 | 2039065 | 2021-12-22 | Lamar | Mississippi | 28073 | 10865 | 140 |
2035815 | 2035815 | 2021-12-21 | Lamar | Mississippi | 28073 | 10845 | 140 |
2032565 | 2032565 | 2021-12-20 | Lamar | Mississippi | 28073 | 10837 | 140 |
2029314 | 2029314 | 2021-12-19 | Lamar | Mississippi | 28073 | 10796 | 140 |
2026063 | 2026063 | 2021-12-18 | Lamar | Mississippi | 28073 | 10796 | 140 |
2022812 | 2022812 | 2021-12-17 | Lamar | Mississippi | 28073 | 10796 | 140 |
2019561 | 2019561 | 2021-12-16 | Lamar | Mississippi | 28073 | 10779 | 140 |
2016311 | 2016311 | 2021-12-15 | Lamar | Mississippi | 28073 | 10765 | 140 |
2013060 | 2013060 | 2021-12-14 | Lamar | Mississippi | 28073 | 10754 | 140 |
2009809 | 2009809 | 2021-12-13 | Lamar | Mississippi | 28073 | 10752 | 140 |
2006558 | 2006558 | 2021-12-12 | Lamar | Mississippi | 28073 | 10739 | 140 |
2003307 | 2003307 | 2021-12-11 | Lamar | Mississippi | 28073 | 10739 | 140 |
2000057 | 2000057 | 2021-12-10 | Lamar | Mississippi | 28073 | 10739 | 140 |
1996806 | 1996806 | 2021-12-09 | Lamar | Mississippi | 28073 | 10734 | 140 |
1993555 | 1993555 | 2021-12-08 | Lamar | Mississippi | 28073 | 10730 | 140 |
1990304 | 1990304 | 2021-12-07 | Lamar | Mississippi | 28073 | 10715 | 140 |
1987054 | 1987054 | 2021-12-06 | Lamar | Mississippi | 28073 | 10713 | 140 |
1983804 | 1983804 | 2021-12-05 | Lamar | Mississippi | 28073 | 10693 | 140 |
1980554 | 1980554 | 2021-12-04 | Lamar | Mississippi | 28073 | 10693 | 140 |
1977304 | 1977304 | 2021-12-03 | Lamar | Mississippi | 28073 | 10693 | 140 |
1974054 | 1974054 | 2021-12-02 | Lamar | Mississippi | 28073 | 10687 | 140 |
1970805 | 1970805 | 2021-12-01 | Lamar | Mississippi | 28073 | 10680 | 140 |
1967555 | 1967555 | 2021-11-30 | Lamar | Mississippi | 28073 | 10663 | 140 |
1964303 | 1964303 | 2021-11-29 | Lamar | Mississippi | 28073 | 10659 | 140 |
1961052 | 1961052 | 2021-11-28 | Lamar | Mississippi | 28073 | 10644 | 140 |
1957801 | 1957801 | 2021-11-27 | Lamar | Mississippi | 28073 | 10644 | 140 |
1954550 | 1954550 | 2021-11-26 | Lamar | Mississippi | 28073 | 10644 | 140 |
1951299 | 1951299 | 2021-11-25 | Lamar | Mississippi | 28073 | 10644 | 140 |
1948048 | 1948048 | 2021-11-24 | Lamar | Mississippi | 28073 | 10644 | 140 |
1944797 | 1944797 | 2021-11-23 | Lamar | Mississippi | 28073 | 10634 | 140 |
1941546 | 1941546 | 2021-11-22 | Lamar | Mississippi | 28073 | 10633 | 140 |
1938296 | 1938296 | 2021-11-21 | Lamar | Mississippi | 28073 | 10620 | 140 |
1935046 | 1935046 | 2021-11-20 | Lamar | Mississippi | 28073 | 10620 | 140 |
1931796 | 1931796 | 2021-11-19 | Lamar | Mississippi | 28073 | 10620 | 140 |
1928545 | 1928545 | 2021-11-18 | Lamar | Mississippi | 28073 | 10612 | 140 |
1925295 | 1925295 | 2021-11-17 | Lamar | Mississippi | 28073 | 10610 | 140 |
1922046 | 1922046 | 2021-11-16 | Lamar | Mississippi | 28073 | 10606 | 140 |
1918796 | 1918796 | 2021-11-15 | Lamar | Mississippi | 28073 | 10600 | 140 |
1915546 | 1915546 | 2021-11-14 | Lamar | Mississippi | 28073 | 10587 | 140 |
1912296 | 1912296 | 2021-11-13 | Lamar | Mississippi | 28073 | 10587 | 140 |
1909046 | 1909046 | 2021-11-12 | Lamar | Mississippi | 28073 | 10587 | 140 |
1905797 | 1905797 | 2021-11-11 | Lamar | Mississippi | 28073 | 10575 | 140 |
1902548 | 1902548 | 2021-11-10 | Lamar | Mississippi | 28073 | 10575 | 140 |
1899298 | 1899298 | 2021-11-09 | Lamar | Mississippi | 28073 | 10566 | 140 |
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);