ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 28045 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175633 | 2175633 | 2022-02-02 | Hancock | Mississippi | 28045 | 11118 | 145 |
2172380 | 2172380 | 2022-02-01 | Hancock | Mississippi | 28045 | 11033 | 142 |
2169127 | 2169127 | 2022-01-31 | Hancock | Mississippi | 28045 | 10899 | 142 |
2165872 | 2165872 | 2022-01-30 | Hancock | Mississippi | 28045 | 10636 | 142 |
2162617 | 2162617 | 2022-01-29 | Hancock | Mississippi | 28045 | 10636 | 142 |
2159362 | 2159362 | 2022-01-28 | Hancock | Mississippi | 28045 | 10636 | 142 |
2156108 | 2156108 | 2022-01-27 | Hancock | Mississippi | 28045 | 10533 | 142 |
2152855 | 2152855 | 2022-01-26 | Hancock | Mississippi | 28045 | 10415 | 141 |
2149603 | 2149603 | 2022-01-25 | Hancock | Mississippi | 28045 | 10339 | 141 |
2146351 | 2146351 | 2022-01-24 | Hancock | Mississippi | 28045 | 10282 | 141 |
2143096 | 2143096 | 2022-01-23 | Hancock | Mississippi | 28045 | 10062 | 141 |
2139841 | 2139841 | 2022-01-22 | Hancock | Mississippi | 28045 | 10062 | 141 |
2136585 | 2136585 | 2022-01-21 | Hancock | Mississippi | 28045 | 10062 | 141 |
2133333 | 2133333 | 2022-01-20 | Hancock | Mississippi | 28045 | 9955 | 141 |
2130080 | 2130080 | 2022-01-19 | Hancock | Mississippi | 28045 | 9815 | 141 |
2126826 | 2126826 | 2022-01-18 | Hancock | Mississippi | 28045 | 9740 | 141 |
2123574 | 2123574 | 2022-01-17 | Hancock | Mississippi | 28045 | 9411 | 141 |
2120322 | 2120322 | 2022-01-16 | Hancock | Mississippi | 28045 | 9411 | 141 |
2117070 | 2117070 | 2022-01-15 | Hancock | Mississippi | 28045 | 9411 | 141 |
2113819 | 2113819 | 2022-01-14 | Hancock | Mississippi | 28045 | 9411 | 141 |
2110567 | 2110567 | 2022-01-13 | Hancock | Mississippi | 28045 | 9250 | 140 |
2107316 | 2107316 | 2022-01-12 | Hancock | Mississippi | 28045 | 9117 | 139 |
2104065 | 2104065 | 2022-01-11 | Hancock | Mississippi | 28045 | 8963 | 138 |
2100814 | 2100814 | 2022-01-10 | Hancock | Mississippi | 28045 | 8877 | 136 |
2097563 | 2097563 | 2022-01-09 | Hancock | Mississippi | 28045 | 8660 | 134 |
2094311 | 2094311 | 2022-01-08 | Hancock | Mississippi | 28045 | 8660 | 134 |
2091059 | 2091059 | 2022-01-07 | Hancock | Mississippi | 28045 | 8660 | 134 |
2087808 | 2087808 | 2022-01-06 | Hancock | Mississippi | 28045 | 8525 | 134 |
2084556 | 2084556 | 2022-01-05 | Hancock | Mississippi | 28045 | 8442 | 134 |
2081304 | 2081304 | 2022-01-04 | Hancock | Mississippi | 28045 | 8318 | 134 |
2078052 | 2078052 | 2022-01-03 | Hancock | Mississippi | 28045 | 8258 | 133 |
2074801 | 2074801 | 2022-01-02 | Hancock | Mississippi | 28045 | 8103 | 132 |
2071550 | 2071550 | 2022-01-01 | Hancock | Mississippi | 28045 | 8103 | 132 |
2068299 | 2068299 | 2021-12-31 | Hancock | Mississippi | 28045 | 8103 | 132 |
2065048 | 2065048 | 2021-12-30 | Hancock | Mississippi | 28045 | 8103 | 132 |
2061798 | 2061798 | 2021-12-29 | Hancock | Mississippi | 28045 | 8038 | 132 |
2058549 | 2058549 | 2021-12-28 | Hancock | Mississippi | 28045 | 7994 | 132 |
2055300 | 2055300 | 2021-12-27 | Hancock | Mississippi | 28045 | 7976 | 132 |
2052050 | 2052050 | 2021-12-26 | Hancock | Mississippi | 28045 | 7909 | 132 |
2048800 | 2048800 | 2021-12-25 | Hancock | Mississippi | 28045 | 7909 | 132 |
2045550 | 2045550 | 2021-12-24 | Hancock | Mississippi | 28045 | 7909 | 132 |
2042300 | 2042300 | 2021-12-23 | Hancock | Mississippi | 28045 | 7909 | 132 |
2039051 | 2039051 | 2021-12-22 | Hancock | Mississippi | 28045 | 7909 | 132 |
2035801 | 2035801 | 2021-12-21 | Hancock | Mississippi | 28045 | 7905 | 132 |
2032551 | 2032551 | 2021-12-20 | Hancock | Mississippi | 28045 | 7897 | 132 |
2029300 | 2029300 | 2021-12-19 | Hancock | Mississippi | 28045 | 7886 | 132 |
2026049 | 2026049 | 2021-12-18 | Hancock | Mississippi | 28045 | 7886 | 132 |
2022798 | 2022798 | 2021-12-17 | Hancock | Mississippi | 28045 | 7886 | 132 |
2019547 | 2019547 | 2021-12-16 | Hancock | Mississippi | 28045 | 7883 | 132 |
2016297 | 2016297 | 2021-12-15 | Hancock | Mississippi | 28045 | 7873 | 132 |
2013046 | 2013046 | 2021-12-14 | Hancock | Mississippi | 28045 | 7870 | 132 |
2009795 | 2009795 | 2021-12-13 | Hancock | Mississippi | 28045 | 7869 | 132 |
2006544 | 2006544 | 2021-12-12 | Hancock | Mississippi | 28045 | 7864 | 132 |
2003293 | 2003293 | 2021-12-11 | Hancock | Mississippi | 28045 | 7864 | 132 |
2000043 | 2000043 | 2021-12-10 | Hancock | Mississippi | 28045 | 7864 | 132 |
1996792 | 1996792 | 2021-12-09 | Hancock | Mississippi | 28045 | 7864 | 132 |
1993541 | 1993541 | 2021-12-08 | Hancock | Mississippi | 28045 | 7858 | 132 |
1990290 | 1990290 | 2021-12-07 | Hancock | Mississippi | 28045 | 7854 | 132 |
1987040 | 1987040 | 2021-12-06 | Hancock | Mississippi | 28045 | 7848 | 132 |
1983790 | 1983790 | 2021-12-05 | Hancock | Mississippi | 28045 | 7849 | 132 |
1980540 | 1980540 | 2021-12-04 | Hancock | Mississippi | 28045 | 7849 | 132 |
1977290 | 1977290 | 2021-12-03 | Hancock | Mississippi | 28045 | 7849 | 132 |
1974040 | 1974040 | 2021-12-02 | Hancock | Mississippi | 28045 | 7847 | 132 |
1970791 | 1970791 | 2021-12-01 | Hancock | Mississippi | 28045 | 7843 | 132 |
1967541 | 1967541 | 2021-11-30 | Hancock | Mississippi | 28045 | 7839 | 132 |
1964289 | 1964289 | 2021-11-29 | Hancock | Mississippi | 28045 | 7836 | 132 |
1961038 | 1961038 | 2021-11-28 | Hancock | Mississippi | 28045 | 7835 | 132 |
1957787 | 1957787 | 2021-11-27 | Hancock | Mississippi | 28045 | 7835 | 132 |
1954536 | 1954536 | 2021-11-26 | Hancock | Mississippi | 28045 | 7835 | 132 |
1951285 | 1951285 | 2021-11-25 | Hancock | Mississippi | 28045 | 7835 | 132 |
1948034 | 1948034 | 2021-11-24 | Hancock | Mississippi | 28045 | 7835 | 132 |
1944783 | 1944783 | 2021-11-23 | Hancock | Mississippi | 28045 | 7831 | 132 |
1941532 | 1941532 | 2021-11-22 | Hancock | Mississippi | 28045 | 7828 | 131 |
1938282 | 1938282 | 2021-11-21 | Hancock | Mississippi | 28045 | 7816 | 130 |
1935032 | 1935032 | 2021-11-20 | Hancock | Mississippi | 28045 | 7816 | 130 |
1931782 | 1931782 | 2021-11-19 | Hancock | Mississippi | 28045 | 7816 | 130 |
1928531 | 1928531 | 2021-11-18 | Hancock | Mississippi | 28045 | 7814 | 130 |
1925281 | 1925281 | 2021-11-17 | Hancock | Mississippi | 28045 | 7813 | 130 |
1922032 | 1922032 | 2021-11-16 | Hancock | Mississippi | 28045 | 7812 | 130 |
1918782 | 1918782 | 2021-11-15 | Hancock | Mississippi | 28045 | 7809 | 130 |
1915532 | 1915532 | 2021-11-14 | Hancock | Mississippi | 28045 | 7803 | 130 |
1912282 | 1912282 | 2021-11-13 | Hancock | Mississippi | 28045 | 7803 | 130 |
1909032 | 1909032 | 2021-11-12 | Hancock | Mississippi | 28045 | 7803 | 130 |
1905783 | 1905783 | 2021-11-11 | Hancock | Mississippi | 28045 | 7799 | 130 |
1902534 | 1902534 | 2021-11-10 | Hancock | Mississippi | 28045 | 7799 | 130 |
1899284 | 1899284 | 2021-11-09 | Hancock | Mississippi | 28045 | 7796 | 130 |
1896034 | 1896034 | 2021-11-08 | Hancock | Mississippi | 28045 | 7785 | 130 |
1892784 | 1892784 | 2021-11-07 | Hancock | Mississippi | 28045 | 7782 | 130 |
1889534 | 1889534 | 2021-11-06 | Hancock | Mississippi | 28045 | 7782 | 130 |
1886284 | 1886284 | 2021-11-05 | Hancock | Mississippi | 28045 | 7782 | 130 |
1883035 | 1883035 | 2021-11-04 | Hancock | Mississippi | 28045 | 7781 | 130 |
1879786 | 1879786 | 2021-11-03 | Hancock | Mississippi | 28045 | 7773 | 130 |
1876537 | 1876537 | 2021-11-02 | Hancock | Mississippi | 28045 | 7772 | 130 |
1873288 | 1873288 | 2021-11-01 | Hancock | Mississippi | 28045 | 7770 | 130 |
1870039 | 1870039 | 2021-10-31 | Hancock | Mississippi | 28045 | 7758 | 130 |
1866790 | 1866790 | 2021-10-30 | Hancock | Mississippi | 28045 | 7758 | 130 |
1863541 | 1863541 | 2021-10-29 | Hancock | Mississippi | 28045 | 7758 | 130 |
1860292 | 1860292 | 2021-10-28 | Hancock | Mississippi | 28045 | 7755 | 130 |
1857043 | 1857043 | 2021-10-27 | Hancock | Mississippi | 28045 | 7753 | 130 |
1853794 | 1853794 | 2021-10-26 | Hancock | Mississippi | 28045 | 7751 | 130 |
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);