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 |
---|---|---|---|---|---|---|---|
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 |
1850584 | 1850584 | 2021-10-25 | Scott | Mississippi | 28123 | 4730 | 98 |
1847334 | 1847334 | 2021-10-24 | Scott | Mississippi | 28123 | 4728 | 98 |
1844084 | 1844084 | 2021-10-23 | Scott | Mississippi | 28123 | 4728 | 98 |
1840834 | 1840834 | 2021-10-22 | Scott | Mississippi | 28123 | 4728 | 98 |
1837585 | 1837585 | 2021-10-21 | Scott | Mississippi | 28123 | 4726 | 98 |
1834336 | 1834336 | 2021-10-20 | Scott | Mississippi | 28123 | 4721 | 98 |
1831087 | 1831087 | 2021-10-19 | Scott | Mississippi | 28123 | 4718 | 98 |
1827838 | 1827838 | 2021-10-18 | Scott | Mississippi | 28123 | 4711 | 98 |
1824589 | 1824589 | 2021-10-17 | Scott | Mississippi | 28123 | 4709 | 98 |
1821340 | 1821340 | 2021-10-16 | Scott | Mississippi | 28123 | 4709 | 98 |
1818091 | 1818091 | 2021-10-15 | Scott | Mississippi | 28123 | 4709 | 98 |
1814842 | 1814842 | 2021-10-14 | Scott | Mississippi | 28123 | 4706 | 98 |
1811594 | 1811594 | 2021-10-13 | Scott | Mississippi | 28123 | 4703 | 98 |
1808345 | 1808345 | 2021-10-12 | Scott | Mississippi | 28123 | 4699 | 97 |
1805094 | 1805094 | 2021-10-11 | Scott | Mississippi | 28123 | 4692 | 96 |
1801845 | 1801845 | 2021-10-10 | Scott | Mississippi | 28123 | 4688 | 96 |
1798596 | 1798596 | 2021-10-09 | Scott | Mississippi | 28123 | 4688 | 96 |
1795347 | 1795347 | 2021-10-08 | Scott | Mississippi | 28123 | 4688 | 96 |
1792098 | 1792098 | 2021-10-07 | Scott | Mississippi | 28123 | 4685 | 96 |
1788849 | 1788849 | 2021-10-06 | Scott | Mississippi | 28123 | 4669 | 96 |
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);