ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 28123 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175672 | 2175672 | 2022-02-02 | Scott | Mississippi | 28123 | 6260 | 106 |
2172419 | 2172419 | 2022-02-01 | Scott | Mississippi | 28123 | 6229 | 105 |
2169166 | 2169166 | 2022-01-31 | Scott | Mississippi | 28123 | 6202 | 104 |
2165911 | 2165911 | 2022-01-30 | Scott | Mississippi | 28123 | 6163 | 103 |
2162656 | 2162656 | 2022-01-29 | Scott | Mississippi | 28123 | 6163 | 103 |
2159401 | 2159401 | 2022-01-28 | Scott | Mississippi | 28123 | 6163 | 103 |
2156147 | 2156147 | 2022-01-27 | Scott | Mississippi | 28123 | 6133 | 103 |
2152894 | 2152894 | 2022-01-26 | Scott | Mississippi | 28123 | 6092 | 103 |
2149642 | 2149642 | 2022-01-25 | Scott | Mississippi | 28123 | 6052 | 101 |
2146390 | 2146390 | 2022-01-24 | Scott | Mississippi | 28123 | 6019 | 101 |
2143135 | 2143135 | 2022-01-23 | Scott | Mississippi | 28123 | 5928 | 101 |
2139880 | 2139880 | 2022-01-22 | Scott | Mississippi | 28123 | 5928 | 101 |
2136624 | 2136624 | 2022-01-21 | Scott | Mississippi | 28123 | 5928 | 101 |
2133372 | 2133372 | 2022-01-20 | Scott | Mississippi | 28123 | 5864 | 101 |
2130119 | 2130119 | 2022-01-19 | Scott | Mississippi | 28123 | 5804 | 101 |
2126865 | 2126865 | 2022-01-18 | Scott | Mississippi | 28123 | 5726 | 101 |
2123613 | 2123613 | 2022-01-17 | Scott | Mississippi | 28123 | 5624 | 101 |
2120361 | 2120361 | 2022-01-16 | Scott | Mississippi | 28123 | 5624 | 101 |
2117109 | 2117109 | 2022-01-15 | Scott | Mississippi | 28123 | 5624 | 101 |
2113858 | 2113858 | 2022-01-14 | Scott | Mississippi | 28123 | 5624 | 101 |
2110606 | 2110606 | 2022-01-13 | Scott | Mississippi | 28123 | 5547 | 101 |
2107355 | 2107355 | 2022-01-12 | Scott | Mississippi | 28123 | 5489 | 101 |
2104104 | 2104104 | 2022-01-11 | Scott | Mississippi | 28123 | 5437 | 101 |
2100853 | 2100853 | 2022-01-10 | Scott | Mississippi | 28123 | 5392 | 101 |
2097602 | 2097602 | 2022-01-09 | Scott | Mississippi | 28123 | 5314 | 101 |
2094350 | 2094350 | 2022-01-08 | Scott | Mississippi | 28123 | 5314 | 101 |
2091098 | 2091098 | 2022-01-07 | Scott | Mississippi | 28123 | 5314 | 101 |
2087847 | 2087847 | 2022-01-06 | Scott | Mississippi | 28123 | 5275 | 101 |
2084595 | 2084595 | 2022-01-05 | Scott | Mississippi | 28123 | 5207 | 101 |
2081343 | 2081343 | 2022-01-04 | Scott | Mississippi | 28123 | 5169 | 100 |
2078091 | 2078091 | 2022-01-03 | Scott | Mississippi | 28123 | 5120 | 99 |
2074840 | 2074840 | 2022-01-02 | Scott | Mississippi | 28123 | 4983 | 99 |
2071589 | 2071589 | 2022-01-01 | Scott | Mississippi | 28123 | 4983 | 99 |
2068338 | 2068338 | 2021-12-31 | Scott | Mississippi | 28123 | 4983 | 99 |
2065087 | 2065087 | 2021-12-30 | Scott | Mississippi | 28123 | 4983 | 99 |
2061837 | 2061837 | 2021-12-29 | Scott | Mississippi | 28123 | 4955 | 99 |
2058588 | 2058588 | 2021-12-28 | Scott | Mississippi | 28123 | 4929 | 99 |
2055339 | 2055339 | 2021-12-27 | Scott | Mississippi | 28123 | 4911 | 99 |
2052089 | 2052089 | 2021-12-26 | Scott | Mississippi | 28123 | 4853 | 99 |
2048839 | 2048839 | 2021-12-25 | Scott | Mississippi | 28123 | 4853 | 99 |
2045589 | 2045589 | 2021-12-24 | Scott | Mississippi | 28123 | 4853 | 99 |
2042339 | 2042339 | 2021-12-23 | Scott | Mississippi | 28123 | 4853 | 99 |
2039090 | 2039090 | 2021-12-22 | Scott | Mississippi | 28123 | 4853 | 99 |
2035840 | 2035840 | 2021-12-21 | Scott | Mississippi | 28123 | 4850 | 99 |
2032590 | 2032590 | 2021-12-20 | Scott | Mississippi | 28123 | 4846 | 99 |
2029339 | 2029339 | 2021-12-19 | Scott | Mississippi | 28123 | 4839 | 99 |
2026088 | 2026088 | 2021-12-18 | Scott | Mississippi | 28123 | 4839 | 99 |
2022837 | 2022837 | 2021-12-17 | Scott | Mississippi | 28123 | 4839 | 99 |
2019586 | 2019586 | 2021-12-16 | Scott | Mississippi | 28123 | 4829 | 99 |
2016336 | 2016336 | 2021-12-15 | Scott | Mississippi | 28123 | 4817 | 99 |
2013085 | 2013085 | 2021-12-14 | Scott | Mississippi | 28123 | 4813 | 99 |
2009834 | 2009834 | 2021-12-13 | Scott | Mississippi | 28123 | 4811 | 99 |
2006583 | 2006583 | 2021-12-12 | Scott | Mississippi | 28123 | 4806 | 99 |
2003332 | 2003332 | 2021-12-11 | Scott | Mississippi | 28123 | 4806 | 99 |
2000082 | 2000082 | 2021-12-10 | Scott | Mississippi | 28123 | 4806 | 99 |
1996831 | 1996831 | 2021-12-09 | Scott | Mississippi | 28123 | 4806 | 99 |
1993580 | 1993580 | 2021-12-08 | Scott | Mississippi | 28123 | 4801 | 99 |
1990329 | 1990329 | 2021-12-07 | Scott | Mississippi | 28123 | 4795 | 99 |
1987079 | 1987079 | 2021-12-06 | Scott | Mississippi | 28123 | 4794 | 99 |
1983829 | 1983829 | 2021-12-05 | Scott | Mississippi | 28123 | 4789 | 99 |
1980579 | 1980579 | 2021-12-04 | Scott | Mississippi | 28123 | 4789 | 99 |
1977329 | 1977329 | 2021-12-03 | Scott | Mississippi | 28123 | 4789 | 99 |
1974079 | 1974079 | 2021-12-02 | Scott | Mississippi | 28123 | 4787 | 99 |
1970830 | 1970830 | 2021-12-01 | Scott | Mississippi | 28123 | 4782 | 99 |
1967580 | 1967580 | 2021-11-30 | Scott | Mississippi | 28123 | 4781 | 99 |
1964328 | 1964328 | 2021-11-29 | Scott | Mississippi | 28123 | 4778 | 99 |
1961077 | 1961077 | 2021-11-28 | Scott | Mississippi | 28123 | 4774 | 99 |
1957826 | 1957826 | 2021-11-27 | Scott | Mississippi | 28123 | 4774 | 99 |
1954575 | 1954575 | 2021-11-26 | Scott | Mississippi | 28123 | 4774 | 99 |
1951324 | 1951324 | 2021-11-25 | Scott | Mississippi | 28123 | 4774 | 99 |
1948073 | 1948073 | 2021-11-24 | Scott | Mississippi | 28123 | 4774 | 99 |
1944822 | 1944822 | 2021-11-23 | Scott | Mississippi | 28123 | 4773 | 99 |
1941571 | 1941571 | 2021-11-22 | Scott | Mississippi | 28123 | 4773 | 99 |
1938321 | 1938321 | 2021-11-21 | Scott | Mississippi | 28123 | 4758 | 99 |
1935071 | 1935071 | 2021-11-20 | Scott | Mississippi | 28123 | 4758 | 99 |
1931821 | 1931821 | 2021-11-19 | Scott | Mississippi | 28123 | 4758 | 99 |
1928570 | 1928570 | 2021-11-18 | Scott | Mississippi | 28123 | 4758 | 99 |
1925320 | 1925320 | 2021-11-17 | Scott | Mississippi | 28123 | 4758 | 98 |
1922071 | 1922071 | 2021-11-16 | Scott | Mississippi | 28123 | 4758 | 98 |
1918821 | 1918821 | 2021-11-15 | Scott | Mississippi | 28123 | 4756 | 98 |
1915571 | 1915571 | 2021-11-14 | Scott | Mississippi | 28123 | 4751 | 98 |
1912321 | 1912321 | 2021-11-13 | Scott | Mississippi | 28123 | 4751 | 98 |
1909071 | 1909071 | 2021-11-12 | Scott | Mississippi | 28123 | 4751 | 98 |
1905822 | 1905822 | 2021-11-11 | Scott | Mississippi | 28123 | 4751 | 98 |
1902573 | 1902573 | 2021-11-10 | Scott | Mississippi | 28123 | 4751 | 98 |
1899323 | 1899323 | 2021-11-09 | Scott | Mississippi | 28123 | 4750 | 98 |
1896073 | 1896073 | 2021-11-08 | Scott | Mississippi | 28123 | 4748 | 98 |
1892823 | 1892823 | 2021-11-07 | Scott | Mississippi | 28123 | 4749 | 98 |
1889573 | 1889573 | 2021-11-06 | Scott | Mississippi | 28123 | 4749 | 98 |
1886323 | 1886323 | 2021-11-05 | Scott | Mississippi | 28123 | 4749 | 98 |
1883074 | 1883074 | 2021-11-04 | Scott | Mississippi | 28123 | 4747 | 98 |
1879825 | 1879825 | 2021-11-03 | Scott | Mississippi | 28123 | 4747 | 98 |
1876576 | 1876576 | 2021-11-02 | Scott | Mississippi | 28123 | 4746 | 98 |
1873327 | 1873327 | 2021-11-01 | Scott | Mississippi | 28123 | 4743 | 98 |
1870078 | 1870078 | 2021-10-31 | Scott | Mississippi | 28123 | 4743 | 98 |
1866829 | 1866829 | 2021-10-30 | Scott | Mississippi | 28123 | 4743 | 98 |
1863580 | 1863580 | 2021-10-29 | Scott | Mississippi | 28123 | 4743 | 98 |
1860331 | 1860331 | 2021-10-28 | Scott | Mississippi | 28123 | 4742 | 98 |
1857082 | 1857082 | 2021-10-27 | Scott | Mississippi | 28123 | 4740 | 98 |
1853833 | 1853833 | 2021-10-26 | Scott | Mississippi | 28123 | 4741 | 98 |
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);