ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 28079 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175650 | 2175650 | 2022-02-02 | Leake | Mississippi | 28079 | 5762 | 102 |
2172397 | 2172397 | 2022-02-01 | Leake | Mississippi | 28079 | 5717 | 98 |
2169144 | 2169144 | 2022-01-31 | Leake | Mississippi | 28079 | 5656 | 96 |
2165889 | 2165889 | 2022-01-30 | Leake | Mississippi | 28079 | 5589 | 95 |
2162634 | 2162634 | 2022-01-29 | Leake | Mississippi | 28079 | 5589 | 95 |
2159379 | 2159379 | 2022-01-28 | Leake | Mississippi | 28079 | 5589 | 95 |
2156125 | 2156125 | 2022-01-27 | Leake | Mississippi | 28079 | 5557 | 94 |
2152872 | 2152872 | 2022-01-26 | Leake | Mississippi | 28079 | 5520 | 93 |
2149620 | 2149620 | 2022-01-25 | Leake | Mississippi | 28079 | 5477 | 93 |
2146368 | 2146368 | 2022-01-24 | Leake | Mississippi | 28079 | 5434 | 93 |
2143113 | 2143113 | 2022-01-23 | Leake | Mississippi | 28079 | 5339 | 92 |
2139858 | 2139858 | 2022-01-22 | Leake | Mississippi | 28079 | 5339 | 92 |
2136602 | 2136602 | 2022-01-21 | Leake | Mississippi | 28079 | 5339 | 92 |
2133350 | 2133350 | 2022-01-20 | Leake | Mississippi | 28079 | 5290 | 92 |
2130097 | 2130097 | 2022-01-19 | Leake | Mississippi | 28079 | 5244 | 92 |
2126843 | 2126843 | 2022-01-18 | Leake | Mississippi | 28079 | 5171 | 92 |
2123591 | 2123591 | 2022-01-17 | Leake | Mississippi | 28079 | 5009 | 92 |
2120339 | 2120339 | 2022-01-16 | Leake | Mississippi | 28079 | 5009 | 92 |
2117087 | 2117087 | 2022-01-15 | Leake | Mississippi | 28079 | 5009 | 92 |
2113836 | 2113836 | 2022-01-14 | Leake | Mississippi | 28079 | 5009 | 92 |
2110584 | 2110584 | 2022-01-13 | Leake | Mississippi | 28079 | 4948 | 92 |
2107333 | 2107333 | 2022-01-12 | Leake | Mississippi | 28079 | 4900 | 92 |
2104082 | 2104082 | 2022-01-11 | Leake | Mississippi | 28079 | 4815 | 92 |
2100831 | 2100831 | 2022-01-10 | Leake | Mississippi | 28079 | 4762 | 92 |
2097580 | 2097580 | 2022-01-09 | Leake | Mississippi | 28079 | 4647 | 92 |
2094328 | 2094328 | 2022-01-08 | Leake | Mississippi | 28079 | 4647 | 92 |
2091076 | 2091076 | 2022-01-07 | Leake | Mississippi | 28079 | 4647 | 92 |
2087825 | 2087825 | 2022-01-06 | Leake | Mississippi | 28079 | 4594 | 92 |
2084573 | 2084573 | 2022-01-05 | Leake | Mississippi | 28079 | 4545 | 92 |
2081321 | 2081321 | 2022-01-04 | Leake | Mississippi | 28079 | 4490 | 92 |
2078069 | 2078069 | 2022-01-03 | Leake | Mississippi | 28079 | 4434 | 92 |
2074818 | 2074818 | 2022-01-02 | Leake | Mississippi | 28079 | 4315 | 92 |
2071567 | 2071567 | 2022-01-01 | Leake | Mississippi | 28079 | 4315 | 92 |
2068316 | 2068316 | 2021-12-31 | Leake | Mississippi | 28079 | 4315 | 92 |
2065065 | 2065065 | 2021-12-30 | Leake | Mississippi | 28079 | 4315 | 92 |
2061815 | 2061815 | 2021-12-29 | Leake | Mississippi | 28079 | 4281 | 92 |
2058566 | 2058566 | 2021-12-28 | Leake | Mississippi | 28079 | 4258 | 92 |
2055317 | 2055317 | 2021-12-27 | Leake | Mississippi | 28079 | 4223 | 92 |
2052067 | 2052067 | 2021-12-26 | Leake | Mississippi | 28079 | 4175 | 92 |
2048817 | 2048817 | 2021-12-25 | Leake | Mississippi | 28079 | 4175 | 92 |
2045567 | 2045567 | 2021-12-24 | Leake | Mississippi | 28079 | 4175 | 92 |
2042317 | 2042317 | 2021-12-23 | Leake | Mississippi | 28079 | 4175 | 92 |
2039068 | 2039068 | 2021-12-22 | Leake | Mississippi | 28079 | 4175 | 92 |
2035818 | 2035818 | 2021-12-21 | Leake | Mississippi | 28079 | 4172 | 92 |
2032568 | 2032568 | 2021-12-20 | Leake | Mississippi | 28079 | 4170 | 92 |
2029317 | 2029317 | 2021-12-19 | Leake | Mississippi | 28079 | 4161 | 92 |
2026066 | 2026066 | 2021-12-18 | Leake | Mississippi | 28079 | 4161 | 92 |
2022815 | 2022815 | 2021-12-17 | Leake | Mississippi | 28079 | 4161 | 92 |
2019564 | 2019564 | 2021-12-16 | Leake | Mississippi | 28079 | 4159 | 92 |
2016314 | 2016314 | 2021-12-15 | Leake | Mississippi | 28079 | 4158 | 92 |
2013063 | 2013063 | 2021-12-14 | Leake | Mississippi | 28079 | 4157 | 92 |
2009812 | 2009812 | 2021-12-13 | Leake | Mississippi | 28079 | 4153 | 92 |
2006561 | 2006561 | 2021-12-12 | Leake | Mississippi | 28079 | 4151 | 92 |
2003310 | 2003310 | 2021-12-11 | Leake | Mississippi | 28079 | 4151 | 92 |
2000060 | 2000060 | 2021-12-10 | Leake | Mississippi | 28079 | 4151 | 92 |
1996809 | 1996809 | 2021-12-09 | Leake | Mississippi | 28079 | 4150 | 92 |
1993558 | 1993558 | 2021-12-08 | Leake | Mississippi | 28079 | 4148 | 91 |
1990307 | 1990307 | 2021-12-07 | Leake | Mississippi | 28079 | 4144 | 91 |
1987057 | 1987057 | 2021-12-06 | Leake | Mississippi | 28079 | 4144 | 91 |
1983807 | 1983807 | 2021-12-05 | Leake | Mississippi | 28079 | 4141 | 91 |
1980557 | 1980557 | 2021-12-04 | Leake | Mississippi | 28079 | 4141 | 91 |
1977307 | 1977307 | 2021-12-03 | Leake | Mississippi | 28079 | 4141 | 91 |
1974057 | 1974057 | 2021-12-02 | Leake | Mississippi | 28079 | 4140 | 90 |
1970808 | 1970808 | 2021-12-01 | Leake | Mississippi | 28079 | 4140 | 90 |
1967558 | 1967558 | 2021-11-30 | Leake | Mississippi | 28079 | 4140 | 90 |
1964306 | 1964306 | 2021-11-29 | Leake | Mississippi | 28079 | 4139 | 90 |
1961055 | 1961055 | 2021-11-28 | Leake | Mississippi | 28079 | 4137 | 90 |
1957804 | 1957804 | 2021-11-27 | Leake | Mississippi | 28079 | 4137 | 90 |
1954553 | 1954553 | 2021-11-26 | Leake | Mississippi | 28079 | 4137 | 90 |
1951302 | 1951302 | 2021-11-25 | Leake | Mississippi | 28079 | 4137 | 90 |
1948051 | 1948051 | 2021-11-24 | Leake | Mississippi | 28079 | 4137 | 90 |
1944800 | 1944800 | 2021-11-23 | Leake | Mississippi | 28079 | 4134 | 90 |
1941549 | 1941549 | 2021-11-22 | Leake | Mississippi | 28079 | 4133 | 90 |
1938299 | 1938299 | 2021-11-21 | Leake | Mississippi | 28079 | 4129 | 90 |
1935049 | 1935049 | 2021-11-20 | Leake | Mississippi | 28079 | 4129 | 90 |
1931799 | 1931799 | 2021-11-19 | Leake | Mississippi | 28079 | 4129 | 90 |
1928548 | 1928548 | 2021-11-18 | Leake | Mississippi | 28079 | 4127 | 90 |
1925298 | 1925298 | 2021-11-17 | Leake | Mississippi | 28079 | 4124 | 90 |
1922049 | 1922049 | 2021-11-16 | Leake | Mississippi | 28079 | 4124 | 90 |
1918799 | 1918799 | 2021-11-15 | Leake | Mississippi | 28079 | 4119 | 90 |
1915549 | 1915549 | 2021-11-14 | Leake | Mississippi | 28079 | 4113 | 89 |
1912299 | 1912299 | 2021-11-13 | Leake | Mississippi | 28079 | 4113 | 89 |
1909049 | 1909049 | 2021-11-12 | Leake | Mississippi | 28079 | 4113 | 89 |
1905800 | 1905800 | 2021-11-11 | Leake | Mississippi | 28079 | 4107 | 89 |
1902551 | 1902551 | 2021-11-10 | Leake | Mississippi | 28079 | 4107 | 89 |
1899301 | 1899301 | 2021-11-09 | Leake | Mississippi | 28079 | 4107 | 89 |
1896051 | 1896051 | 2021-11-08 | Leake | Mississippi | 28079 | 4107 | 89 |
1892801 | 1892801 | 2021-11-07 | Leake | Mississippi | 28079 | 4107 | 89 |
1889551 | 1889551 | 2021-11-06 | Leake | Mississippi | 28079 | 4107 | 89 |
1886301 | 1886301 | 2021-11-05 | Leake | Mississippi | 28079 | 4107 | 89 |
1883052 | 1883052 | 2021-11-04 | Leake | Mississippi | 28079 | 4104 | 89 |
1879803 | 1879803 | 2021-11-03 | Leake | Mississippi | 28079 | 4104 | 89 |
1876554 | 1876554 | 2021-11-02 | Leake | Mississippi | 28079 | 4104 | 89 |
1873305 | 1873305 | 2021-11-01 | Leake | Mississippi | 28079 | 4102 | 89 |
1870056 | 1870056 | 2021-10-31 | Leake | Mississippi | 28079 | 4100 | 88 |
1866807 | 1866807 | 2021-10-30 | Leake | Mississippi | 28079 | 4100 | 88 |
1863558 | 1863558 | 2021-10-29 | Leake | Mississippi | 28079 | 4100 | 88 |
1860309 | 1860309 | 2021-10-28 | Leake | Mississippi | 28079 | 4100 | 88 |
1857060 | 1857060 | 2021-10-27 | Leake | Mississippi | 28079 | 4100 | 88 |
1853811 | 1853811 | 2021-10-26 | Leake | Mississippi | 28079 | 4098 | 88 |
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);