ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 28113 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175667 | 2175667 | 2022-02-02 | Pike | Mississippi | 28113 | 8526 | 167 |
2172414 | 2172414 | 2022-02-01 | Pike | Mississippi | 28113 | 8395 | 164 |
2169161 | 2169161 | 2022-01-31 | Pike | Mississippi | 28113 | 8290 | 162 |
2165906 | 2165906 | 2022-01-30 | Pike | Mississippi | 28113 | 8157 | 161 |
2162651 | 2162651 | 2022-01-29 | Pike | Mississippi | 28113 | 8157 | 161 |
2159396 | 2159396 | 2022-01-28 | Pike | Mississippi | 28113 | 8157 | 161 |
2156142 | 2156142 | 2022-01-27 | Pike | Mississippi | 28113 | 8112 | 161 |
2152889 | 2152889 | 2022-01-26 | Pike | Mississippi | 28113 | 8021 | 161 |
2149637 | 2149637 | 2022-01-25 | Pike | Mississippi | 28113 | 7961 | 161 |
2146385 | 2146385 | 2022-01-24 | Pike | Mississippi | 28113 | 7921 | 160 |
2143130 | 2143130 | 2022-01-23 | Pike | Mississippi | 28113 | 7830 | 160 |
2139875 | 2139875 | 2022-01-22 | Pike | Mississippi | 28113 | 7830 | 160 |
2136619 | 2136619 | 2022-01-21 | Pike | Mississippi | 28113 | 7830 | 160 |
2133367 | 2133367 | 2022-01-20 | Pike | Mississippi | 28113 | 7746 | 160 |
2130114 | 2130114 | 2022-01-19 | Pike | Mississippi | 28113 | 7648 | 160 |
2126860 | 2126860 | 2022-01-18 | Pike | Mississippi | 28113 | 7586 | 160 |
2123608 | 2123608 | 2022-01-17 | Pike | Mississippi | 28113 | 7378 | 159 |
2120356 | 2120356 | 2022-01-16 | Pike | Mississippi | 28113 | 7378 | 159 |
2117104 | 2117104 | 2022-01-15 | Pike | Mississippi | 28113 | 7378 | 159 |
2113853 | 2113853 | 2022-01-14 | Pike | Mississippi | 28113 | 7378 | 159 |
2110601 | 2110601 | 2022-01-13 | Pike | Mississippi | 28113 | 7294 | 159 |
2107350 | 2107350 | 2022-01-12 | Pike | Mississippi | 28113 | 7214 | 159 |
2104099 | 2104099 | 2022-01-11 | Pike | Mississippi | 28113 | 7096 | 159 |
2100848 | 2100848 | 2022-01-10 | Pike | Mississippi | 28113 | 7031 | 159 |
2097597 | 2097597 | 2022-01-09 | Pike | Mississippi | 28113 | 6853 | 159 |
2094345 | 2094345 | 2022-01-08 | Pike | Mississippi | 28113 | 6853 | 159 |
2091093 | 2091093 | 2022-01-07 | Pike | Mississippi | 28113 | 6853 | 159 |
2087842 | 2087842 | 2022-01-06 | Pike | Mississippi | 28113 | 6748 | 159 |
2084590 | 2084590 | 2022-01-05 | Pike | Mississippi | 28113 | 6620 | 159 |
2081338 | 2081338 | 2022-01-04 | Pike | Mississippi | 28113 | 6512 | 158 |
2078086 | 2078086 | 2022-01-03 | Pike | Mississippi | 28113 | 6394 | 158 |
2074835 | 2074835 | 2022-01-02 | Pike | Mississippi | 28113 | 6146 | 158 |
2071584 | 2071584 | 2022-01-01 | Pike | Mississippi | 28113 | 6146 | 158 |
2068333 | 2068333 | 2021-12-31 | Pike | Mississippi | 28113 | 6146 | 158 |
2065082 | 2065082 | 2021-12-30 | Pike | Mississippi | 28113 | 6146 | 158 |
2061832 | 2061832 | 2021-12-29 | Pike | Mississippi | 28113 | 6110 | 158 |
2058583 | 2058583 | 2021-12-28 | Pike | Mississippi | 28113 | 6083 | 158 |
2055334 | 2055334 | 2021-12-27 | Pike | Mississippi | 28113 | 6056 | 158 |
2052084 | 2052084 | 2021-12-26 | Pike | Mississippi | 28113 | 6015 | 158 |
2048834 | 2048834 | 2021-12-25 | Pike | Mississippi | 28113 | 6015 | 158 |
2045584 | 2045584 | 2021-12-24 | Pike | Mississippi | 28113 | 6015 | 158 |
2042334 | 2042334 | 2021-12-23 | Pike | Mississippi | 28113 | 6015 | 158 |
2039085 | 2039085 | 2021-12-22 | Pike | Mississippi | 28113 | 6015 | 158 |
2035835 | 2035835 | 2021-12-21 | Pike | Mississippi | 28113 | 6010 | 158 |
2032585 | 2032585 | 2021-12-20 | Pike | Mississippi | 28113 | 6008 | 158 |
2029334 | 2029334 | 2021-12-19 | Pike | Mississippi | 28113 | 6004 | 157 |
2026083 | 2026083 | 2021-12-18 | Pike | Mississippi | 28113 | 6004 | 157 |
2022832 | 2022832 | 2021-12-17 | Pike | Mississippi | 28113 | 6004 | 157 |
2019581 | 2019581 | 2021-12-16 | Pike | Mississippi | 28113 | 5998 | 157 |
2016331 | 2016331 | 2021-12-15 | Pike | Mississippi | 28113 | 5988 | 157 |
2013080 | 2013080 | 2021-12-14 | Pike | Mississippi | 28113 | 5986 | 157 |
2009829 | 2009829 | 2021-12-13 | Pike | Mississippi | 28113 | 5977 | 157 |
2006578 | 2006578 | 2021-12-12 | Pike | Mississippi | 28113 | 5967 | 157 |
2003327 | 2003327 | 2021-12-11 | Pike | Mississippi | 28113 | 5967 | 157 |
2000077 | 2000077 | 2021-12-10 | Pike | Mississippi | 28113 | 5967 | 157 |
1996826 | 1996826 | 2021-12-09 | Pike | Mississippi | 28113 | 5964 | 157 |
1993575 | 1993575 | 2021-12-08 | Pike | Mississippi | 28113 | 5960 | 157 |
1990324 | 1990324 | 2021-12-07 | Pike | Mississippi | 28113 | 5953 | 157 |
1987074 | 1987074 | 2021-12-06 | Pike | Mississippi | 28113 | 5947 | 157 |
1983824 | 1983824 | 2021-12-05 | Pike | Mississippi | 28113 | 5942 | 157 |
1980574 | 1980574 | 2021-12-04 | Pike | Mississippi | 28113 | 5942 | 157 |
1977324 | 1977324 | 2021-12-03 | Pike | Mississippi | 28113 | 5942 | 157 |
1974074 | 1974074 | 2021-12-02 | Pike | Mississippi | 28113 | 5941 | 157 |
1970825 | 1970825 | 2021-12-01 | Pike | Mississippi | 28113 | 5936 | 156 |
1967575 | 1967575 | 2021-11-30 | Pike | Mississippi | 28113 | 5933 | 156 |
1964323 | 1964323 | 2021-11-29 | Pike | Mississippi | 28113 | 5928 | 156 |
1961072 | 1961072 | 2021-11-28 | Pike | Mississippi | 28113 | 5924 | 156 |
1957821 | 1957821 | 2021-11-27 | Pike | Mississippi | 28113 | 5924 | 156 |
1954570 | 1954570 | 2021-11-26 | Pike | Mississippi | 28113 | 5924 | 156 |
1951319 | 1951319 | 2021-11-25 | Pike | Mississippi | 28113 | 5924 | 156 |
1948068 | 1948068 | 2021-11-24 | Pike | Mississippi | 28113 | 5924 | 156 |
1944817 | 1944817 | 2021-11-23 | Pike | Mississippi | 28113 | 5917 | 156 |
1941566 | 1941566 | 2021-11-22 | Pike | Mississippi | 28113 | 5916 | 155 |
1938316 | 1938316 | 2021-11-21 | Pike | Mississippi | 28113 | 5913 | 155 |
1935066 | 1935066 | 2021-11-20 | Pike | Mississippi | 28113 | 5913 | 155 |
1931816 | 1931816 | 2021-11-19 | Pike | Mississippi | 28113 | 5913 | 155 |
1928565 | 1928565 | 2021-11-18 | Pike | Mississippi | 28113 | 5910 | 155 |
1925315 | 1925315 | 2021-11-17 | Pike | Mississippi | 28113 | 5909 | 155 |
1922066 | 1922066 | 2021-11-16 | Pike | Mississippi | 28113 | 5908 | 155 |
1918816 | 1918816 | 2021-11-15 | Pike | Mississippi | 28113 | 5906 | 155 |
1915566 | 1915566 | 2021-11-14 | Pike | Mississippi | 28113 | 5903 | 155 |
1912316 | 1912316 | 2021-11-13 | Pike | Mississippi | 28113 | 5903 | 155 |
1909066 | 1909066 | 2021-11-12 | Pike | Mississippi | 28113 | 5903 | 155 |
1905817 | 1905817 | 2021-11-11 | Pike | Mississippi | 28113 | 5901 | 155 |
1902568 | 1902568 | 2021-11-10 | Pike | Mississippi | 28113 | 5901 | 155 |
1899318 | 1899318 | 2021-11-09 | Pike | Mississippi | 28113 | 5895 | 155 |
1896068 | 1896068 | 2021-11-08 | Pike | Mississippi | 28113 | 5890 | 155 |
1892818 | 1892818 | 2021-11-07 | Pike | Mississippi | 28113 | 5882 | 155 |
1889568 | 1889568 | 2021-11-06 | Pike | Mississippi | 28113 | 5882 | 155 |
1886318 | 1886318 | 2021-11-05 | Pike | Mississippi | 28113 | 5882 | 155 |
1883069 | 1883069 | 2021-11-04 | Pike | Mississippi | 28113 | 5878 | 155 |
1879820 | 1879820 | 2021-11-03 | Pike | Mississippi | 28113 | 5874 | 155 |
1876571 | 1876571 | 2021-11-02 | Pike | Mississippi | 28113 | 5870 | 155 |
1873322 | 1873322 | 2021-11-01 | Pike | Mississippi | 28113 | 5868 | 155 |
1870073 | 1870073 | 2021-10-31 | Pike | Mississippi | 28113 | 5863 | 154 |
1866824 | 1866824 | 2021-10-30 | Pike | Mississippi | 28113 | 5863 | 154 |
1863575 | 1863575 | 2021-10-29 | Pike | Mississippi | 28113 | 5863 | 154 |
1860326 | 1860326 | 2021-10-28 | Pike | Mississippi | 28113 | 5862 | 154 |
1857077 | 1857077 | 2021-10-27 | Pike | Mississippi | 28113 | 5859 | 154 |
1853828 | 1853828 | 2021-10-26 | Pike | Mississippi | 28113 | 5849 | 154 |
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);