ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 28159 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175690 | 2175690 | 2022-02-02 | Winston | Mississippi | 28159 | 4795 | 97 |
2172437 | 2172437 | 2022-02-01 | Winston | Mississippi | 28159 | 4767 | 97 |
2169184 | 2169184 | 2022-01-31 | Winston | Mississippi | 28159 | 4743 | 97 |
2165929 | 2165929 | 2022-01-30 | Winston | Mississippi | 28159 | 4625 | 96 |
2162674 | 2162674 | 2022-01-29 | Winston | Mississippi | 28159 | 4625 | 96 |
2159419 | 2159419 | 2022-01-28 | Winston | Mississippi | 28159 | 4625 | 96 |
2156165 | 2156165 | 2022-01-27 | Winston | Mississippi | 28159 | 4515 | 96 |
2152912 | 2152912 | 2022-01-26 | Winston | Mississippi | 28159 | 4445 | 96 |
2149660 | 2149660 | 2022-01-25 | Winston | Mississippi | 28159 | 4371 | 96 |
2146408 | 2146408 | 2022-01-24 | Winston | Mississippi | 28159 | 4359 | 96 |
2143153 | 2143153 | 2022-01-23 | Winston | Mississippi | 28159 | 4280 | 96 |
2139898 | 2139898 | 2022-01-22 | Winston | Mississippi | 28159 | 4280 | 96 |
2136642 | 2136642 | 2022-01-21 | Winston | Mississippi | 28159 | 4280 | 96 |
2133390 | 2133390 | 2022-01-20 | Winston | Mississippi | 28159 | 4220 | 95 |
2130137 | 2130137 | 2022-01-19 | Winston | Mississippi | 28159 | 4148 | 95 |
2126883 | 2126883 | 2022-01-18 | Winston | Mississippi | 28159 | 4093 | 95 |
2123631 | 2123631 | 2022-01-17 | Winston | Mississippi | 28159 | 3969 | 95 |
2120379 | 2120379 | 2022-01-16 | Winston | Mississippi | 28159 | 3969 | 95 |
2117127 | 2117127 | 2022-01-15 | Winston | Mississippi | 28159 | 3969 | 95 |
2113876 | 2113876 | 2022-01-14 | Winston | Mississippi | 28159 | 3969 | 95 |
2110624 | 2110624 | 2022-01-13 | Winston | Mississippi | 28159 | 3919 | 95 |
2107373 | 2107373 | 2022-01-12 | Winston | Mississippi | 28159 | 3854 | 95 |
2104122 | 2104122 | 2022-01-11 | Winston | Mississippi | 28159 | 3753 | 95 |
2100871 | 2100871 | 2022-01-10 | Winston | Mississippi | 28159 | 3730 | 94 |
2097620 | 2097620 | 2022-01-09 | Winston | Mississippi | 28159 | 3560 | 94 |
2094368 | 2094368 | 2022-01-08 | Winston | Mississippi | 28159 | 3560 | 94 |
2091116 | 2091116 | 2022-01-07 | Winston | Mississippi | 28159 | 3560 | 94 |
2087865 | 2087865 | 2022-01-06 | Winston | Mississippi | 28159 | 3506 | 94 |
2084613 | 2084613 | 2022-01-05 | Winston | Mississippi | 28159 | 3452 | 94 |
2081361 | 2081361 | 2022-01-04 | Winston | Mississippi | 28159 | 3392 | 94 |
2078109 | 2078109 | 2022-01-03 | Winston | Mississippi | 28159 | 3379 | 94 |
2074858 | 2074858 | 2022-01-02 | Winston | Mississippi | 28159 | 3278 | 93 |
2071607 | 2071607 | 2022-01-01 | Winston | Mississippi | 28159 | 3278 | 93 |
2068356 | 2068356 | 2021-12-31 | Winston | Mississippi | 28159 | 3278 | 93 |
2065105 | 2065105 | 2021-12-30 | Winston | Mississippi | 28159 | 3278 | 93 |
2061855 | 2061855 | 2021-12-29 | Winston | Mississippi | 28159 | 3264 | 92 |
2058606 | 2058606 | 2021-12-28 | Winston | Mississippi | 28159 | 3243 | 92 |
2055357 | 2055357 | 2021-12-27 | Winston | Mississippi | 28159 | 3240 | 92 |
2052107 | 2052107 | 2021-12-26 | Winston | Mississippi | 28159 | 3228 | 92 |
2048857 | 2048857 | 2021-12-25 | Winston | Mississippi | 28159 | 3228 | 92 |
2045607 | 2045607 | 2021-12-24 | Winston | Mississippi | 28159 | 3228 | 92 |
2042357 | 2042357 | 2021-12-23 | Winston | Mississippi | 28159 | 3228 | 92 |
2039108 | 2039108 | 2021-12-22 | Winston | Mississippi | 28159 | 3228 | 92 |
2035858 | 2035858 | 2021-12-21 | Winston | Mississippi | 28159 | 3220 | 92 |
2032608 | 2032608 | 2021-12-20 | Winston | Mississippi | 28159 | 3219 | 92 |
2029357 | 2029357 | 2021-12-19 | Winston | Mississippi | 28159 | 3216 | 92 |
2026106 | 2026106 | 2021-12-18 | Winston | Mississippi | 28159 | 3216 | 92 |
2022855 | 2022855 | 2021-12-17 | Winston | Mississippi | 28159 | 3216 | 92 |
2019604 | 2019604 | 2021-12-16 | Winston | Mississippi | 28159 | 3215 | 92 |
2016354 | 2016354 | 2021-12-15 | Winston | Mississippi | 28159 | 3210 | 92 |
2013103 | 2013103 | 2021-12-14 | Winston | Mississippi | 28159 | 3207 | 92 |
2009852 | 2009852 | 2021-12-13 | Winston | Mississippi | 28159 | 3206 | 92 |
2006601 | 2006601 | 2021-12-12 | Winston | Mississippi | 28159 | 3203 | 92 |
2003350 | 2003350 | 2021-12-11 | Winston | Mississippi | 28159 | 3203 | 92 |
2000100 | 2000100 | 2021-12-10 | Winston | Mississippi | 28159 | 3203 | 92 |
1996849 | 1996849 | 2021-12-09 | Winston | Mississippi | 28159 | 3199 | 92 |
1993598 | 1993598 | 2021-12-08 | Winston | Mississippi | 28159 | 3197 | 92 |
1990347 | 1990347 | 2021-12-07 | Winston | Mississippi | 28159 | 3190 | 92 |
1987097 | 1987097 | 2021-12-06 | Winston | Mississippi | 28159 | 3188 | 92 |
1983847 | 1983847 | 2021-12-05 | Winston | Mississippi | 28159 | 3183 | 92 |
1980597 | 1980597 | 2021-12-04 | Winston | Mississippi | 28159 | 3183 | 92 |
1977347 | 1977347 | 2021-12-03 | Winston | Mississippi | 28159 | 3183 | 92 |
1974097 | 1974097 | 2021-12-02 | Winston | Mississippi | 28159 | 3179 | 92 |
1970848 | 1970848 | 2021-12-01 | Winston | Mississippi | 28159 | 3179 | 92 |
1967598 | 1967598 | 2021-11-30 | Winston | Mississippi | 28159 | 3178 | 92 |
1964346 | 1964346 | 2021-11-29 | Winston | Mississippi | 28159 | 3178 | 92 |
1961095 | 1961095 | 2021-11-28 | Winston | Mississippi | 28159 | 3177 | 92 |
1957844 | 1957844 | 2021-11-27 | Winston | Mississippi | 28159 | 3177 | 92 |
1954593 | 1954593 | 2021-11-26 | Winston | Mississippi | 28159 | 3177 | 92 |
1951342 | 1951342 | 2021-11-25 | Winston | Mississippi | 28159 | 3177 | 92 |
1948091 | 1948091 | 2021-11-24 | Winston | Mississippi | 28159 | 3177 | 92 |
1944840 | 1944840 | 2021-11-23 | Winston | Mississippi | 28159 | 3177 | 92 |
1941589 | 1941589 | 2021-11-22 | Winston | Mississippi | 28159 | 3177 | 92 |
1938339 | 1938339 | 2021-11-21 | Winston | Mississippi | 28159 | 3177 | 92 |
1935089 | 1935089 | 2021-11-20 | Winston | Mississippi | 28159 | 3177 | 92 |
1931839 | 1931839 | 2021-11-19 | Winston | Mississippi | 28159 | 3177 | 92 |
1928588 | 1928588 | 2021-11-18 | Winston | Mississippi | 28159 | 3176 | 92 |
1925338 | 1925338 | 2021-11-17 | Winston | Mississippi | 28159 | 3174 | 92 |
1922089 | 1922089 | 2021-11-16 | Winston | Mississippi | 28159 | 3174 | 92 |
1918839 | 1918839 | 2021-11-15 | Winston | Mississippi | 28159 | 3173 | 91 |
1915589 | 1915589 | 2021-11-14 | Winston | Mississippi | 28159 | 3172 | 91 |
1912339 | 1912339 | 2021-11-13 | Winston | Mississippi | 28159 | 3172 | 91 |
1909089 | 1909089 | 2021-11-12 | Winston | Mississippi | 28159 | 3172 | 91 |
1905840 | 1905840 | 2021-11-11 | Winston | Mississippi | 28159 | 3168 | 91 |
1902591 | 1902591 | 2021-11-10 | Winston | Mississippi | 28159 | 3168 | 91 |
1899341 | 1899341 | 2021-11-09 | Winston | Mississippi | 28159 | 3168 | 91 |
1896091 | 1896091 | 2021-11-08 | Winston | Mississippi | 28159 | 3167 | 91 |
1892841 | 1892841 | 2021-11-07 | Winston | Mississippi | 28159 | 3164 | 91 |
1889591 | 1889591 | 2021-11-06 | Winston | Mississippi | 28159 | 3164 | 91 |
1886341 | 1886341 | 2021-11-05 | Winston | Mississippi | 28159 | 3164 | 91 |
1883092 | 1883092 | 2021-11-04 | Winston | Mississippi | 28159 | 3161 | 91 |
1879843 | 1879843 | 2021-11-03 | Winston | Mississippi | 28159 | 3161 | 91 |
1876594 | 1876594 | 2021-11-02 | Winston | Mississippi | 28159 | 3160 | 91 |
1873345 | 1873345 | 2021-11-01 | Winston | Mississippi | 28159 | 3160 | 91 |
1870096 | 1870096 | 2021-10-31 | Winston | Mississippi | 28159 | 3160 | 91 |
1866847 | 1866847 | 2021-10-30 | Winston | Mississippi | 28159 | 3160 | 91 |
1863598 | 1863598 | 2021-10-29 | Winston | Mississippi | 28159 | 3160 | 91 |
1860349 | 1860349 | 2021-10-28 | Winston | Mississippi | 28159 | 3158 | 91 |
1857100 | 1857100 | 2021-10-27 | Winston | Mississippi | 28159 | 3153 | 91 |
1853851 | 1853851 | 2021-10-26 | Winston | Mississippi | 28159 | 3153 | 91 |
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);