ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Pearl River" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175665 | 2175665 | 2022-02-02 | Pearl River | Mississippi | 28109 | 14039 | 250 |
2172412 | 2172412 | 2022-02-01 | Pearl River | Mississippi | 28109 | 13986 | 250 |
2169159 | 2169159 | 2022-01-31 | Pearl River | Mississippi | 28109 | 13901 | 249 |
2165904 | 2165904 | 2022-01-30 | Pearl River | Mississippi | 28109 | 13660 | 248 |
2162649 | 2162649 | 2022-01-29 | Pearl River | Mississippi | 28109 | 13660 | 248 |
2159394 | 2159394 | 2022-01-28 | Pearl River | Mississippi | 28109 | 13660 | 248 |
2156140 | 2156140 | 2022-01-27 | Pearl River | Mississippi | 28109 | 13524 | 248 |
2152887 | 2152887 | 2022-01-26 | Pearl River | Mississippi | 28109 | 13369 | 248 |
2149635 | 2149635 | 2022-01-25 | Pearl River | Mississippi | 28109 | 13069 | 248 |
2146383 | 2146383 | 2022-01-24 | Pearl River | Mississippi | 28109 | 12958 | 248 |
2143128 | 2143128 | 2022-01-23 | Pearl River | Mississippi | 28109 | 12602 | 248 |
2139873 | 2139873 | 2022-01-22 | Pearl River | Mississippi | 28109 | 12602 | 248 |
2136617 | 2136617 | 2022-01-21 | Pearl River | Mississippi | 28109 | 12602 | 248 |
2133365 | 2133365 | 2022-01-20 | Pearl River | Mississippi | 28109 | 12397 | 248 |
2130112 | 2130112 | 2022-01-19 | Pearl River | Mississippi | 28109 | 12244 | 248 |
2126858 | 2126858 | 2022-01-18 | Pearl River | Mississippi | 28109 | 12026 | 247 |
2123606 | 2123606 | 2022-01-17 | Pearl River | Mississippi | 28109 | 11492 | 246 |
2120354 | 2120354 | 2022-01-16 | Pearl River | Mississippi | 28109 | 11492 | 246 |
2117102 | 2117102 | 2022-01-15 | Pearl River | Mississippi | 28109 | 11492 | 246 |
2113851 | 2113851 | 2022-01-14 | Pearl River | Mississippi | 28109 | 11492 | 246 |
2110599 | 2110599 | 2022-01-13 | Pearl River | Mississippi | 28109 | 11369 | 245 |
2107348 | 2107348 | 2022-01-12 | Pearl River | Mississippi | 28109 | 11223 | 245 |
2104097 | 2104097 | 2022-01-11 | Pearl River | Mississippi | 28109 | 11059 | 245 |
2100846 | 2100846 | 2022-01-10 | Pearl River | Mississippi | 28109 | 10995 | 245 |
2097595 | 2097595 | 2022-01-09 | Pearl River | Mississippi | 28109 | 10776 | 245 |
2094343 | 2094343 | 2022-01-08 | Pearl River | Mississippi | 28109 | 10776 | 245 |
2091091 | 2091091 | 2022-01-07 | Pearl River | Mississippi | 28109 | 10776 | 245 |
2087840 | 2087840 | 2022-01-06 | Pearl River | Mississippi | 28109 | 10632 | 245 |
2084588 | 2084588 | 2022-01-05 | Pearl River | Mississippi | 28109 | 10502 | 245 |
2081336 | 2081336 | 2022-01-04 | Pearl River | Mississippi | 28109 | 10374 | 245 |
2078084 | 2078084 | 2022-01-03 | Pearl River | Mississippi | 28109 | 10314 | 244 |
2074833 | 2074833 | 2022-01-02 | Pearl River | Mississippi | 28109 | 10101 | 244 |
2071582 | 2071582 | 2022-01-01 | Pearl River | Mississippi | 28109 | 10101 | 244 |
2068331 | 2068331 | 2021-12-31 | Pearl River | Mississippi | 28109 | 10101 | 244 |
2065080 | 2065080 | 2021-12-30 | Pearl River | Mississippi | 28109 | 10101 | 244 |
2061830 | 2061830 | 2021-12-29 | Pearl River | Mississippi | 28109 | 10007 | 244 |
2058581 | 2058581 | 2021-12-28 | Pearl River | Mississippi | 28109 | 9940 | 244 |
2055332 | 2055332 | 2021-12-27 | Pearl River | Mississippi | 28109 | 9912 | 244 |
2052082 | 2052082 | 2021-12-26 | Pearl River | Mississippi | 28109 | 9849 | 244 |
2048832 | 2048832 | 2021-12-25 | Pearl River | Mississippi | 28109 | 9849 | 244 |
2045582 | 2045582 | 2021-12-24 | Pearl River | Mississippi | 28109 | 9849 | 244 |
2042332 | 2042332 | 2021-12-23 | Pearl River | Mississippi | 28109 | 9849 | 244 |
2039083 | 2039083 | 2021-12-22 | Pearl River | Mississippi | 28109 | 9849 | 244 |
2035833 | 2035833 | 2021-12-21 | Pearl River | Mississippi | 28109 | 9842 | 244 |
2032583 | 2032583 | 2021-12-20 | Pearl River | Mississippi | 28109 | 9833 | 244 |
2029332 | 2029332 | 2021-12-19 | Pearl River | Mississippi | 28109 | 9813 | 244 |
2026081 | 2026081 | 2021-12-18 | Pearl River | Mississippi | 28109 | 9813 | 244 |
2022830 | 2022830 | 2021-12-17 | Pearl River | Mississippi | 28109 | 9813 | 244 |
2019579 | 2019579 | 2021-12-16 | Pearl River | Mississippi | 28109 | 9807 | 244 |
2016329 | 2016329 | 2021-12-15 | Pearl River | Mississippi | 28109 | 9801 | 244 |
2013078 | 2013078 | 2021-12-14 | Pearl River | Mississippi | 28109 | 9796 | 244 |
2009827 | 2009827 | 2021-12-13 | Pearl River | Mississippi | 28109 | 9793 | 244 |
2006576 | 2006576 | 2021-12-12 | Pearl River | Mississippi | 28109 | 9781 | 244 |
2003325 | 2003325 | 2021-12-11 | Pearl River | Mississippi | 28109 | 9781 | 244 |
2000075 | 2000075 | 2021-12-10 | Pearl River | Mississippi | 28109 | 9781 | 244 |
1996824 | 1996824 | 2021-12-09 | Pearl River | Mississippi | 28109 | 9773 | 244 |
1993573 | 1993573 | 2021-12-08 | Pearl River | Mississippi | 28109 | 9769 | 244 |
1990322 | 1990322 | 2021-12-07 | Pearl River | Mississippi | 28109 | 9762 | 244 |
1987072 | 1987072 | 2021-12-06 | Pearl River | Mississippi | 28109 | 9759 | 244 |
1983822 | 1983822 | 2021-12-05 | Pearl River | Mississippi | 28109 | 9748 | 244 |
1980572 | 1980572 | 2021-12-04 | Pearl River | Mississippi | 28109 | 9748 | 244 |
1977322 | 1977322 | 2021-12-03 | Pearl River | Mississippi | 28109 | 9748 | 244 |
1974072 | 1974072 | 2021-12-02 | Pearl River | Mississippi | 28109 | 9739 | 244 |
1970823 | 1970823 | 2021-12-01 | Pearl River | Mississippi | 28109 | 9732 | 244 |
1967573 | 1967573 | 2021-11-30 | Pearl River | Mississippi | 28109 | 9720 | 244 |
1964321 | 1964321 | 2021-11-29 | Pearl River | Mississippi | 28109 | 9719 | 244 |
1961070 | 1961070 | 2021-11-28 | Pearl River | Mississippi | 28109 | 9707 | 244 |
1957819 | 1957819 | 2021-11-27 | Pearl River | Mississippi | 28109 | 9707 | 244 |
1954568 | 1954568 | 2021-11-26 | Pearl River | Mississippi | 28109 | 9707 | 244 |
1951317 | 1951317 | 2021-11-25 | Pearl River | Mississippi | 28109 | 9707 | 244 |
1948066 | 1948066 | 2021-11-24 | Pearl River | Mississippi | 28109 | 9707 | 244 |
1944815 | 1944815 | 2021-11-23 | Pearl River | Mississippi | 28109 | 9704 | 244 |
1941564 | 1941564 | 2021-11-22 | Pearl River | Mississippi | 28109 | 9700 | 243 |
1938314 | 1938314 | 2021-11-21 | Pearl River | Mississippi | 28109 | 9680 | 243 |
1935064 | 1935064 | 2021-11-20 | Pearl River | Mississippi | 28109 | 9680 | 243 |
1931814 | 1931814 | 2021-11-19 | Pearl River | Mississippi | 28109 | 9680 | 243 |
1928563 | 1928563 | 2021-11-18 | Pearl River | Mississippi | 28109 | 9679 | 243 |
1925313 | 1925313 | 2021-11-17 | Pearl River | Mississippi | 28109 | 9674 | 243 |
1922064 | 1922064 | 2021-11-16 | Pearl River | Mississippi | 28109 | 9674 | 242 |
1918814 | 1918814 | 2021-11-15 | Pearl River | Mississippi | 28109 | 9672 | 242 |
1915564 | 1915564 | 2021-11-14 | Pearl River | Mississippi | 28109 | 9668 | 242 |
1912314 | 1912314 | 2021-11-13 | Pearl River | Mississippi | 28109 | 9668 | 242 |
1909064 | 1909064 | 2021-11-12 | Pearl River | Mississippi | 28109 | 9668 | 242 |
1905815 | 1905815 | 2021-11-11 | Pearl River | Mississippi | 28109 | 9650 | 241 |
1902566 | 1902566 | 2021-11-10 | Pearl River | Mississippi | 28109 | 9650 | 241 |
1899316 | 1899316 | 2021-11-09 | Pearl River | Mississippi | 28109 | 9646 | 241 |
1896066 | 1896066 | 2021-11-08 | Pearl River | Mississippi | 28109 | 9644 | 241 |
1892816 | 1892816 | 2021-11-07 | Pearl River | Mississippi | 28109 | 9631 | 241 |
1889566 | 1889566 | 2021-11-06 | Pearl River | Mississippi | 28109 | 9631 | 241 |
1886316 | 1886316 | 2021-11-05 | Pearl River | Mississippi | 28109 | 9631 | 241 |
1883067 | 1883067 | 2021-11-04 | Pearl River | Mississippi | 28109 | 9623 | 240 |
1879818 | 1879818 | 2021-11-03 | Pearl River | Mississippi | 28109 | 9618 | 240 |
1876569 | 1876569 | 2021-11-02 | Pearl River | Mississippi | 28109 | 9608 | 240 |
1873320 | 1873320 | 2021-11-01 | Pearl River | Mississippi | 28109 | 9605 | 240 |
1870071 | 1870071 | 2021-10-31 | Pearl River | Mississippi | 28109 | 9591 | 240 |
1866822 | 1866822 | 2021-10-30 | Pearl River | Mississippi | 28109 | 9591 | 240 |
1863573 | 1863573 | 2021-10-29 | Pearl River | Mississippi | 28109 | 9591 | 240 |
1860324 | 1860324 | 2021-10-28 | Pearl River | Mississippi | 28109 | 9582 | 238 |
1857075 | 1857075 | 2021-10-27 | Pearl River | Mississippi | 28109 | 9564 | 238 |
1853826 | 1853826 | 2021-10-26 | Pearl River | Mississippi | 28109 | 9557 | 238 |
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);