ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
189 rows where deaths = 140 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2302505 | 2302505 | 2022-03-13 | Tate | Mississippi | 28137 | 7294 | 140 |
2299253 | 2299253 | 2022-03-12 | Tate | Mississippi | 28137 | 7294 | 140 |
2296001 | 2296001 | 2022-03-11 | Tate | Mississippi | 28137 | 7294 | 140 |
2292749 | 2292749 | 2022-03-10 | Tate | Mississippi | 28137 | 7294 | 140 |
2289497 | 2289497 | 2022-03-09 | Tate | Mississippi | 28137 | 7294 | 140 |
2286246 | 2286246 | 2022-03-08 | Tate | Mississippi | 28137 | 7294 | 140 |
2260160 | 2260160 | 2022-02-28 | Adams | Mississippi | 28001 | 7104 | 140 |
2256909 | 2256909 | 2022-02-27 | Adams | Mississippi | 28001 | 7102 | 140 |
2253658 | 2253658 | 2022-02-26 | Adams | Mississippi | 28001 | 7102 | 140 |
2250407 | 2250407 | 2022-02-25 | Adams | Mississippi | 28001 | 7102 | 140 |
2247156 | 2247156 | 2022-02-24 | Adams | Mississippi | 28001 | 7102 | 140 |
2247219 | 2247219 | 2022-02-24 | Simpson | Mississippi | 28127 | 6921 | 140 |
2243905 | 2243905 | 2022-02-23 | Adams | Mississippi | 28001 | 7102 | 140 |
2243968 | 2243968 | 2022-02-23 | Simpson | Mississippi | 28127 | 6918 | 140 |
2240654 | 2240654 | 2022-02-22 | Adams | Mississippi | 28001 | 7099 | 140 |
2237403 | 2237403 | 2022-02-21 | Adams | Mississippi | 28001 | 7070 | 140 |
2234152 | 2234152 | 2022-02-20 | Adams | Mississippi | 28001 | 7070 | 140 |
2230901 | 2230901 | 2022-02-19 | Adams | Mississippi | 28001 | 7070 | 140 |
2227650 | 2227650 | 2022-02-18 | Adams | Mississippi | 28001 | 7070 | 140 |
2224399 | 2224399 | 2022-02-17 | Adams | Mississippi | 28001 | 7063 | 140 |
2221148 | 2221148 | 2022-02-16 | Adams | Mississippi | 28001 | 7055 | 140 |
2110567 | 2110567 | 2022-01-13 | Hancock | Mississippi | 28045 | 9250 | 140 |
2110581 | 2110581 | 2022-01-13 | Lamar | Mississippi | 28073 | 13178 | 140 |
2107347 | 2107347 | 2022-01-12 | Panola | Mississippi | 28107 | 8312 | 140 |
2104079 | 2104079 | 2022-01-11 | Lamar | Mississippi | 28073 | 12653 | 140 |
2104096 | 2104096 | 2022-01-11 | Panola | Mississippi | 28107 | 8214 | 140 |
2100828 | 2100828 | 2022-01-10 | Lamar | Mississippi | 28073 | 12569 | 140 |
2100845 | 2100845 | 2022-01-10 | Panola | Mississippi | 28107 | 8045 | 140 |
2097577 | 2097577 | 2022-01-09 | Lamar | Mississippi | 28073 | 12186 | 140 |
2097594 | 2097594 | 2022-01-09 | Panola | Mississippi | 28107 | 7745 | 140 |
2094325 | 2094325 | 2022-01-08 | Lamar | Mississippi | 28073 | 12186 | 140 |
2094342 | 2094342 | 2022-01-08 | Panola | Mississippi | 28107 | 7745 | 140 |
2091073 | 2091073 | 2022-01-07 | Lamar | Mississippi | 28073 | 12186 | 140 |
2091090 | 2091090 | 2022-01-07 | Panola | Mississippi | 28107 | 7745 | 140 |
2087822 | 2087822 | 2022-01-06 | Lamar | Mississippi | 28073 | 11979 | 140 |
2087839 | 2087839 | 2022-01-06 | Panola | Mississippi | 28107 | 7640 | 140 |
2084570 | 2084570 | 2022-01-05 | Lamar | Mississippi | 28073 | 11823 | 140 |
2084587 | 2084587 | 2022-01-05 | Panola | Mississippi | 28107 | 7508 | 140 |
2081318 | 2081318 | 2022-01-04 | Lamar | Mississippi | 28073 | 11660 | 140 |
2081335 | 2081335 | 2022-01-04 | Panola | Mississippi | 28107 | 7411 | 140 |
2078066 | 2078066 | 2022-01-03 | Lamar | Mississippi | 28073 | 11559 | 140 |
2078083 | 2078083 | 2022-01-03 | Panola | Mississippi | 28107 | 7357 | 140 |
2074815 | 2074815 | 2022-01-02 | Lamar | Mississippi | 28073 | 11225 | 140 |
2074832 | 2074832 | 2022-01-02 | Panola | Mississippi | 28107 | 7142 | 140 |
2071564 | 2071564 | 2022-01-01 | Lamar | Mississippi | 28073 | 11225 | 140 |
2071581 | 2071581 | 2022-01-01 | Panola | Mississippi | 28107 | 7142 | 140 |
2068313 | 2068313 | 2021-12-31 | Lamar | Mississippi | 28073 | 11225 | 140 |
2068330 | 2068330 | 2021-12-31 | Panola | Mississippi | 28107 | 7142 | 140 |
2065062 | 2065062 | 2021-12-30 | Lamar | Mississippi | 28073 | 11225 | 140 |
2065079 | 2065079 | 2021-12-30 | Panola | Mississippi | 28107 | 7142 | 140 |
2061812 | 2061812 | 2021-12-29 | Lamar | Mississippi | 28073 | 11117 | 140 |
2061829 | 2061829 | 2021-12-29 | Panola | Mississippi | 28107 | 7069 | 140 |
2058563 | 2058563 | 2021-12-28 | Lamar | Mississippi | 28073 | 11038 | 140 |
2058580 | 2058580 | 2021-12-28 | Panola | Mississippi | 28107 | 7020 | 140 |
2055314 | 2055314 | 2021-12-27 | Lamar | Mississippi | 28073 | 11001 | 140 |
2055330 | 2055330 | 2021-12-27 | Oktibbeha | Mississippi | 28105 | 7353 | 140 |
2052064 | 2052064 | 2021-12-26 | Lamar | Mississippi | 28073 | 10865 | 140 |
2052080 | 2052080 | 2021-12-26 | Oktibbeha | Mississippi | 28105 | 7318 | 140 |
2048814 | 2048814 | 2021-12-25 | Lamar | Mississippi | 28073 | 10865 | 140 |
2048830 | 2048830 | 2021-12-25 | Oktibbeha | Mississippi | 28105 | 7318 | 140 |
2045564 | 2045564 | 2021-12-24 | Lamar | Mississippi | 28073 | 10865 | 140 |
2045580 | 2045580 | 2021-12-24 | Oktibbeha | Mississippi | 28105 | 7318 | 140 |
2042314 | 2042314 | 2021-12-23 | Lamar | Mississippi | 28073 | 10865 | 140 |
2042330 | 2042330 | 2021-12-23 | Oktibbeha | Mississippi | 28105 | 7318 | 140 |
2039065 | 2039065 | 2021-12-22 | Lamar | Mississippi | 28073 | 10865 | 140 |
2039081 | 2039081 | 2021-12-22 | Oktibbeha | Mississippi | 28105 | 7318 | 140 |
2035815 | 2035815 | 2021-12-21 | Lamar | Mississippi | 28073 | 10845 | 140 |
2035831 | 2035831 | 2021-12-21 | Oktibbeha | Mississippi | 28105 | 7312 | 140 |
2032565 | 2032565 | 2021-12-20 | Lamar | Mississippi | 28073 | 10837 | 140 |
2032581 | 2032581 | 2021-12-20 | Oktibbeha | Mississippi | 28105 | 7310 | 140 |
2029314 | 2029314 | 2021-12-19 | Lamar | Mississippi | 28073 | 10796 | 140 |
2029330 | 2029330 | 2021-12-19 | Oktibbeha | Mississippi | 28105 | 7297 | 140 |
2026063 | 2026063 | 2021-12-18 | Lamar | Mississippi | 28073 | 10796 | 140 |
2026079 | 2026079 | 2021-12-18 | Oktibbeha | Mississippi | 28105 | 7297 | 140 |
2022812 | 2022812 | 2021-12-17 | Lamar | Mississippi | 28073 | 10796 | 140 |
2022828 | 2022828 | 2021-12-17 | Oktibbeha | Mississippi | 28105 | 7297 | 140 |
2019561 | 2019561 | 2021-12-16 | Lamar | Mississippi | 28073 | 10779 | 140 |
2019577 | 2019577 | 2021-12-16 | Oktibbeha | Mississippi | 28105 | 7290 | 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 |
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);