ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Coahoma" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175624 | 2175624 | 2022-02-02 | Coahoma | Mississippi | 28027 | 6038 | 119 |
2172371 | 2172371 | 2022-02-01 | Coahoma | Mississippi | 28027 | 6001 | 118 |
2169118 | 2169118 | 2022-01-31 | Coahoma | Mississippi | 28027 | 5988 | 117 |
2165863 | 2165863 | 2022-01-30 | Coahoma | Mississippi | 28027 | 5942 | 116 |
2162608 | 2162608 | 2022-01-29 | Coahoma | Mississippi | 28027 | 5942 | 116 |
2159353 | 2159353 | 2022-01-28 | Coahoma | Mississippi | 28027 | 5942 | 116 |
2156099 | 2156099 | 2022-01-27 | Coahoma | Mississippi | 28027 | 5907 | 116 |
2152846 | 2152846 | 2022-01-26 | Coahoma | Mississippi | 28027 | 5834 | 116 |
2149594 | 2149594 | 2022-01-25 | Coahoma | Mississippi | 28027 | 5715 | 116 |
2146342 | 2146342 | 2022-01-24 | Coahoma | Mississippi | 28027 | 5705 | 116 |
2143087 | 2143087 | 2022-01-23 | Coahoma | Mississippi | 28027 | 5648 | 116 |
2139832 | 2139832 | 2022-01-22 | Coahoma | Mississippi | 28027 | 5648 | 116 |
2136576 | 2136576 | 2022-01-21 | Coahoma | Mississippi | 28027 | 5648 | 116 |
2133324 | 2133324 | 2022-01-20 | Coahoma | Mississippi | 28027 | 5618 | 116 |
2130071 | 2130071 | 2022-01-19 | Coahoma | Mississippi | 28027 | 5575 | 116 |
2126817 | 2126817 | 2022-01-18 | Coahoma | Mississippi | 28027 | 5538 | 115 |
2123565 | 2123565 | 2022-01-17 | Coahoma | Mississippi | 28027 | 5472 | 114 |
2120313 | 2120313 | 2022-01-16 | Coahoma | Mississippi | 28027 | 5472 | 114 |
2117061 | 2117061 | 2022-01-15 | Coahoma | Mississippi | 28027 | 5472 | 114 |
2113810 | 2113810 | 2022-01-14 | Coahoma | Mississippi | 28027 | 5472 | 114 |
2110558 | 2110558 | 2022-01-13 | Coahoma | Mississippi | 28027 | 5383 | 114 |
2107307 | 2107307 | 2022-01-12 | Coahoma | Mississippi | 28027 | 5328 | 114 |
2104056 | 2104056 | 2022-01-11 | Coahoma | Mississippi | 28027 | 5257 | 114 |
2100805 | 2100805 | 2022-01-10 | Coahoma | Mississippi | 28027 | 5232 | 114 |
2097554 | 2097554 | 2022-01-09 | Coahoma | Mississippi | 28027 | 5086 | 114 |
2094302 | 2094302 | 2022-01-08 | Coahoma | Mississippi | 28027 | 5086 | 114 |
2091050 | 2091050 | 2022-01-07 | Coahoma | Mississippi | 28027 | 5086 | 114 |
2087799 | 2087799 | 2022-01-06 | Coahoma | Mississippi | 28027 | 4977 | 114 |
2084547 | 2084547 | 2022-01-05 | Coahoma | Mississippi | 28027 | 4917 | 114 |
2081295 | 2081295 | 2022-01-04 | Coahoma | Mississippi | 28027 | 4850 | 114 |
2078043 | 2078043 | 2022-01-03 | Coahoma | Mississippi | 28027 | 4813 | 113 |
2074792 | 2074792 | 2022-01-02 | Coahoma | Mississippi | 28027 | 4591 | 113 |
2071541 | 2071541 | 2022-01-01 | Coahoma | Mississippi | 28027 | 4591 | 113 |
2068290 | 2068290 | 2021-12-31 | Coahoma | Mississippi | 28027 | 4591 | 113 |
2065039 | 2065039 | 2021-12-30 | Coahoma | Mississippi | 28027 | 4591 | 113 |
2061789 | 2061789 | 2021-12-29 | Coahoma | Mississippi | 28027 | 4529 | 113 |
2058540 | 2058540 | 2021-12-28 | Coahoma | Mississippi | 28027 | 4496 | 113 |
2055291 | 2055291 | 2021-12-27 | Coahoma | Mississippi | 28027 | 4454 | 113 |
2052041 | 2052041 | 2021-12-26 | Coahoma | Mississippi | 28027 | 4364 | 113 |
2048791 | 2048791 | 2021-12-25 | Coahoma | Mississippi | 28027 | 4364 | 113 |
2045541 | 2045541 | 2021-12-24 | Coahoma | Mississippi | 28027 | 4364 | 113 |
2042291 | 2042291 | 2021-12-23 | Coahoma | Mississippi | 28027 | 4364 | 113 |
2039042 | 2039042 | 2021-12-22 | Coahoma | Mississippi | 28027 | 4364 | 113 |
2035792 | 2035792 | 2021-12-21 | Coahoma | Mississippi | 28027 | 4359 | 113 |
2032542 | 2032542 | 2021-12-20 | Coahoma | Mississippi | 28027 | 4357 | 112 |
2029291 | 2029291 | 2021-12-19 | Coahoma | Mississippi | 28027 | 4352 | 112 |
2026040 | 2026040 | 2021-12-18 | Coahoma | Mississippi | 28027 | 4352 | 112 |
2022789 | 2022789 | 2021-12-17 | Coahoma | Mississippi | 28027 | 4352 | 112 |
2019538 | 2019538 | 2021-12-16 | Coahoma | Mississippi | 28027 | 4338 | 112 |
2016288 | 2016288 | 2021-12-15 | Coahoma | Mississippi | 28027 | 4321 | 112 |
2013037 | 2013037 | 2021-12-14 | Coahoma | Mississippi | 28027 | 4320 | 112 |
2009786 | 2009786 | 2021-12-13 | Coahoma | Mississippi | 28027 | 4319 | 112 |
2006535 | 2006535 | 2021-12-12 | Coahoma | Mississippi | 28027 | 4304 | 112 |
2003284 | 2003284 | 2021-12-11 | Coahoma | Mississippi | 28027 | 4304 | 112 |
2000034 | 2000034 | 2021-12-10 | Coahoma | Mississippi | 28027 | 4304 | 112 |
1996783 | 1996783 | 2021-12-09 | Coahoma | Mississippi | 28027 | 4302 | 111 |
1993532 | 1993532 | 2021-12-08 | Coahoma | Mississippi | 28027 | 4276 | 111 |
1990281 | 1990281 | 2021-12-07 | Coahoma | Mississippi | 28027 | 4263 | 111 |
1987031 | 1987031 | 2021-12-06 | Coahoma | Mississippi | 28027 | 4259 | 110 |
1983781 | 1983781 | 2021-12-05 | Coahoma | Mississippi | 28027 | 4244 | 110 |
1980531 | 1980531 | 2021-12-04 | Coahoma | Mississippi | 28027 | 4244 | 110 |
1977281 | 1977281 | 2021-12-03 | Coahoma | Mississippi | 28027 | 4244 | 110 |
1974031 | 1974031 | 2021-12-02 | Coahoma | Mississippi | 28027 | 4243 | 109 |
1970782 | 1970782 | 2021-12-01 | Coahoma | Mississippi | 28027 | 4240 | 109 |
1967532 | 1967532 | 2021-11-30 | Coahoma | Mississippi | 28027 | 4238 | 109 |
1964280 | 1964280 | 2021-11-29 | Coahoma | Mississippi | 28027 | 4237 | 109 |
1961029 | 1961029 | 2021-11-28 | Coahoma | Mississippi | 28027 | 4227 | 109 |
1957778 | 1957778 | 2021-11-27 | Coahoma | Mississippi | 28027 | 4227 | 109 |
1954527 | 1954527 | 2021-11-26 | Coahoma | Mississippi | 28027 | 4227 | 109 |
1951276 | 1951276 | 2021-11-25 | Coahoma | Mississippi | 28027 | 4227 | 109 |
1948025 | 1948025 | 2021-11-24 | Coahoma | Mississippi | 28027 | 4227 | 109 |
1944774 | 1944774 | 2021-11-23 | Coahoma | Mississippi | 28027 | 4227 | 109 |
1941523 | 1941523 | 2021-11-22 | Coahoma | Mississippi | 28027 | 4226 | 109 |
1938273 | 1938273 | 2021-11-21 | Coahoma | Mississippi | 28027 | 4219 | 109 |
1935023 | 1935023 | 2021-11-20 | Coahoma | Mississippi | 28027 | 4219 | 109 |
1931773 | 1931773 | 2021-11-19 | Coahoma | Mississippi | 28027 | 4219 | 109 |
1928522 | 1928522 | 2021-11-18 | Coahoma | Mississippi | 28027 | 4218 | 109 |
1925272 | 1925272 | 2021-11-17 | Coahoma | Mississippi | 28027 | 4214 | 109 |
1922023 | 1922023 | 2021-11-16 | Coahoma | Mississippi | 28027 | 4212 | 109 |
1918773 | 1918773 | 2021-11-15 | Coahoma | Mississippi | 28027 | 4212 | 109 |
1915523 | 1915523 | 2021-11-14 | Coahoma | Mississippi | 28027 | 4207 | 109 |
1912273 | 1912273 | 2021-11-13 | Coahoma | Mississippi | 28027 | 4207 | 109 |
1909023 | 1909023 | 2021-11-12 | Coahoma | Mississippi | 28027 | 4207 | 109 |
1905774 | 1905774 | 2021-11-11 | Coahoma | Mississippi | 28027 | 4204 | 109 |
1902525 | 1902525 | 2021-11-10 | Coahoma | Mississippi | 28027 | 4204 | 109 |
1899275 | 1899275 | 2021-11-09 | Coahoma | Mississippi | 28027 | 4205 | 109 |
1896025 | 1896025 | 2021-11-08 | Coahoma | Mississippi | 28027 | 4205 | 109 |
1892775 | 1892775 | 2021-11-07 | Coahoma | Mississippi | 28027 | 4201 | 109 |
1889525 | 1889525 | 2021-11-06 | Coahoma | Mississippi | 28027 | 4201 | 109 |
1886275 | 1886275 | 2021-11-05 | Coahoma | Mississippi | 28027 | 4201 | 109 |
1883026 | 1883026 | 2021-11-04 | Coahoma | Mississippi | 28027 | 4198 | 109 |
1879777 | 1879777 | 2021-11-03 | Coahoma | Mississippi | 28027 | 4198 | 109 |
1876528 | 1876528 | 2021-11-02 | Coahoma | Mississippi | 28027 | 4192 | 109 |
1873279 | 1873279 | 2021-11-01 | Coahoma | Mississippi | 28027 | 4189 | 109 |
1870030 | 1870030 | 2021-10-31 | Coahoma | Mississippi | 28027 | 4186 | 109 |
1866781 | 1866781 | 2021-10-30 | Coahoma | Mississippi | 28027 | 4186 | 109 |
1863532 | 1863532 | 2021-10-29 | Coahoma | Mississippi | 28027 | 4186 | 109 |
1860283 | 1860283 | 2021-10-28 | Coahoma | Mississippi | 28027 | 4186 | 108 |
1857034 | 1857034 | 2021-10-27 | Coahoma | Mississippi | 28027 | 4182 | 108 |
1853785 | 1853785 | 2021-10-26 | Coahoma | Mississippi | 28027 | 4178 | 108 |
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);