ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 28107 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175664 | 2175664 | 2022-02-02 | Panola | Mississippi | 28107 | 9751 | 145 |
2172411 | 2172411 | 2022-02-01 | Panola | Mississippi | 28107 | 9646 | 144 |
2169158 | 2169158 | 2022-01-31 | Panola | Mississippi | 28107 | 9613 | 143 |
2165903 | 2165903 | 2022-01-30 | Panola | Mississippi | 28107 | 9523 | 143 |
2162648 | 2162648 | 2022-01-29 | Panola | Mississippi | 28107 | 9523 | 143 |
2159393 | 2159393 | 2022-01-28 | Panola | Mississippi | 28107 | 9523 | 143 |
2156139 | 2156139 | 2022-01-27 | Panola | Mississippi | 28107 | 9487 | 143 |
2152886 | 2152886 | 2022-01-26 | Panola | Mississippi | 28107 | 9402 | 142 |
2149634 | 2149634 | 2022-01-25 | Panola | Mississippi | 28107 | 9319 | 142 |
2146382 | 2146382 | 2022-01-24 | Panola | Mississippi | 28107 | 9294 | 142 |
2143127 | 2143127 | 2022-01-23 | Panola | Mississippi | 28107 | 9143 | 141 |
2139872 | 2139872 | 2022-01-22 | Panola | Mississippi | 28107 | 9143 | 141 |
2136616 | 2136616 | 2022-01-21 | Panola | Mississippi | 28107 | 9143 | 141 |
2133364 | 2133364 | 2022-01-20 | Panola | Mississippi | 28107 | 9068 | 141 |
2130111 | 2130111 | 2022-01-19 | Panola | Mississippi | 28107 | 8968 | 141 |
2126857 | 2126857 | 2022-01-18 | Panola | Mississippi | 28107 | 8862 | 141 |
2123605 | 2123605 | 2022-01-17 | Panola | Mississippi | 28107 | 8605 | 141 |
2120353 | 2120353 | 2022-01-16 | Panola | Mississippi | 28107 | 8605 | 141 |
2117101 | 2117101 | 2022-01-15 | Panola | Mississippi | 28107 | 8605 | 141 |
2113850 | 2113850 | 2022-01-14 | Panola | Mississippi | 28107 | 8605 | 141 |
2110598 | 2110598 | 2022-01-13 | Panola | Mississippi | 28107 | 8442 | 141 |
2107347 | 2107347 | 2022-01-12 | Panola | Mississippi | 28107 | 8312 | 140 |
2104096 | 2104096 | 2022-01-11 | Panola | Mississippi | 28107 | 8214 | 140 |
2100845 | 2100845 | 2022-01-10 | Panola | Mississippi | 28107 | 8045 | 140 |
2097594 | 2097594 | 2022-01-09 | Panola | Mississippi | 28107 | 7745 | 140 |
2094342 | 2094342 | 2022-01-08 | Panola | Mississippi | 28107 | 7745 | 140 |
2091090 | 2091090 | 2022-01-07 | Panola | Mississippi | 28107 | 7745 | 140 |
2087839 | 2087839 | 2022-01-06 | Panola | Mississippi | 28107 | 7640 | 140 |
2084587 | 2084587 | 2022-01-05 | Panola | Mississippi | 28107 | 7508 | 140 |
2081335 | 2081335 | 2022-01-04 | Panola | Mississippi | 28107 | 7411 | 140 |
2078083 | 2078083 | 2022-01-03 | Panola | Mississippi | 28107 | 7357 | 140 |
2074832 | 2074832 | 2022-01-02 | Panola | Mississippi | 28107 | 7142 | 140 |
2071581 | 2071581 | 2022-01-01 | Panola | Mississippi | 28107 | 7142 | 140 |
2068330 | 2068330 | 2021-12-31 | Panola | Mississippi | 28107 | 7142 | 140 |
2065079 | 2065079 | 2021-12-30 | Panola | Mississippi | 28107 | 7142 | 140 |
2061829 | 2061829 | 2021-12-29 | Panola | Mississippi | 28107 | 7069 | 140 |
2058580 | 2058580 | 2021-12-28 | Panola | Mississippi | 28107 | 7020 | 140 |
2055331 | 2055331 | 2021-12-27 | Panola | Mississippi | 28107 | 6984 | 138 |
2052081 | 2052081 | 2021-12-26 | Panola | Mississippi | 28107 | 6922 | 138 |
2048831 | 2048831 | 2021-12-25 | Panola | Mississippi | 28107 | 6922 | 138 |
2045581 | 2045581 | 2021-12-24 | Panola | Mississippi | 28107 | 6922 | 138 |
2042331 | 2042331 | 2021-12-23 | Panola | Mississippi | 28107 | 6922 | 138 |
2039082 | 2039082 | 2021-12-22 | Panola | Mississippi | 28107 | 6922 | 138 |
2035832 | 2035832 | 2021-12-21 | Panola | Mississippi | 28107 | 6917 | 138 |
2032582 | 2032582 | 2021-12-20 | Panola | Mississippi | 28107 | 6905 | 138 |
2029331 | 2029331 | 2021-12-19 | Panola | Mississippi | 28107 | 6892 | 138 |
2026080 | 2026080 | 2021-12-18 | Panola | Mississippi | 28107 | 6892 | 138 |
2022829 | 2022829 | 2021-12-17 | Panola | Mississippi | 28107 | 6892 | 138 |
2019578 | 2019578 | 2021-12-16 | Panola | Mississippi | 28107 | 6882 | 138 |
2016328 | 2016328 | 2021-12-15 | Panola | Mississippi | 28107 | 6877 | 138 |
2013077 | 2013077 | 2021-12-14 | Panola | Mississippi | 28107 | 6862 | 137 |
2009826 | 2009826 | 2021-12-13 | Panola | Mississippi | 28107 | 6854 | 137 |
2006575 | 2006575 | 2021-12-12 | Panola | Mississippi | 28107 | 6850 | 136 |
2003324 | 2003324 | 2021-12-11 | Panola | Mississippi | 28107 | 6850 | 136 |
2000074 | 2000074 | 2021-12-10 | Panola | Mississippi | 28107 | 6850 | 136 |
1996823 | 1996823 | 2021-12-09 | Panola | Mississippi | 28107 | 6845 | 136 |
1993572 | 1993572 | 2021-12-08 | Panola | Mississippi | 28107 | 6833 | 136 |
1990321 | 1990321 | 2021-12-07 | Panola | Mississippi | 28107 | 6815 | 136 |
1987071 | 1987071 | 2021-12-06 | Panola | Mississippi | 28107 | 6807 | 135 |
1983821 | 1983821 | 2021-12-05 | Panola | Mississippi | 28107 | 6791 | 135 |
1980571 | 1980571 | 2021-12-04 | Panola | Mississippi | 28107 | 6791 | 135 |
1977321 | 1977321 | 2021-12-03 | Panola | Mississippi | 28107 | 6791 | 135 |
1974071 | 1974071 | 2021-12-02 | Panola | Mississippi | 28107 | 6783 | 135 |
1970822 | 1970822 | 2021-12-01 | Panola | Mississippi | 28107 | 6775 | 135 |
1967572 | 1967572 | 2021-11-30 | Panola | Mississippi | 28107 | 6768 | 135 |
1964320 | 1964320 | 2021-11-29 | Panola | Mississippi | 28107 | 6759 | 134 |
1961069 | 1961069 | 2021-11-28 | Panola | Mississippi | 28107 | 6746 | 134 |
1957818 | 1957818 | 2021-11-27 | Panola | Mississippi | 28107 | 6746 | 134 |
1954567 | 1954567 | 2021-11-26 | Panola | Mississippi | 28107 | 6746 | 134 |
1951316 | 1951316 | 2021-11-25 | Panola | Mississippi | 28107 | 6746 | 134 |
1948065 | 1948065 | 2021-11-24 | Panola | Mississippi | 28107 | 6746 | 134 |
1944814 | 1944814 | 2021-11-23 | Panola | Mississippi | 28107 | 6729 | 134 |
1941563 | 1941563 | 2021-11-22 | Panola | Mississippi | 28107 | 6729 | 133 |
1938313 | 1938313 | 2021-11-21 | Panola | Mississippi | 28107 | 6715 | 133 |
1935063 | 1935063 | 2021-11-20 | Panola | Mississippi | 28107 | 6715 | 133 |
1931813 | 1931813 | 2021-11-19 | Panola | Mississippi | 28107 | 6715 | 133 |
1928562 | 1928562 | 2021-11-18 | Panola | Mississippi | 28107 | 6705 | 133 |
1925312 | 1925312 | 2021-11-17 | Panola | Mississippi | 28107 | 6704 | 133 |
1922063 | 1922063 | 2021-11-16 | Panola | Mississippi | 28107 | 6704 | 133 |
1918813 | 1918813 | 2021-11-15 | Panola | Mississippi | 28107 | 6693 | 133 |
1915563 | 1915563 | 2021-11-14 | Panola | Mississippi | 28107 | 6672 | 133 |
1912313 | 1912313 | 2021-11-13 | Panola | Mississippi | 28107 | 6672 | 133 |
1909063 | 1909063 | 2021-11-12 | Panola | Mississippi | 28107 | 6672 | 133 |
1905814 | 1905814 | 2021-11-11 | Panola | Mississippi | 28107 | 6666 | 133 |
1902565 | 1902565 | 2021-11-10 | Panola | Mississippi | 28107 | 6666 | 133 |
1899315 | 1899315 | 2021-11-09 | Panola | Mississippi | 28107 | 6663 | 133 |
1896065 | 1896065 | 2021-11-08 | Panola | Mississippi | 28107 | 6656 | 132 |
1892815 | 1892815 | 2021-11-07 | Panola | Mississippi | 28107 | 6651 | 131 |
1889565 | 1889565 | 2021-11-06 | Panola | Mississippi | 28107 | 6651 | 131 |
1886315 | 1886315 | 2021-11-05 | Panola | Mississippi | 28107 | 6651 | 131 |
1883066 | 1883066 | 2021-11-04 | Panola | Mississippi | 28107 | 6636 | 131 |
1879817 | 1879817 | 2021-11-03 | Panola | Mississippi | 28107 | 6619 | 131 |
1876568 | 1876568 | 2021-11-02 | Panola | Mississippi | 28107 | 6608 | 131 |
1873319 | 1873319 | 2021-11-01 | Panola | Mississippi | 28107 | 6592 | 131 |
1870070 | 1870070 | 2021-10-31 | Panola | Mississippi | 28107 | 6585 | 131 |
1866821 | 1866821 | 2021-10-30 | Panola | Mississippi | 28107 | 6585 | 131 |
1863572 | 1863572 | 2021-10-29 | Panola | Mississippi | 28107 | 6585 | 131 |
1860323 | 1860323 | 2021-10-28 | Panola | Mississippi | 28107 | 6579 | 131 |
1857074 | 1857074 | 2021-10-27 | Panola | Mississippi | 28107 | 6572 | 131 |
1853825 | 1853825 | 2021-10-26 | Panola | Mississippi | 28107 | 6572 | 131 |
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);