ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 28145 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175683 | 2175683 | 2022-02-02 | Union | Mississippi | 28145 | 8832 | 109 |
2172430 | 2172430 | 2022-02-01 | Union | Mississippi | 28145 | 8734 | 107 |
2169177 | 2169177 | 2022-01-31 | Union | Mississippi | 28145 | 8658 | 106 |
2165922 | 2165922 | 2022-01-30 | Union | Mississippi | 28145 | 8573 | 106 |
2162667 | 2162667 | 2022-01-29 | Union | Mississippi | 28145 | 8573 | 106 |
2159412 | 2159412 | 2022-01-28 | Union | Mississippi | 28145 | 8573 | 106 |
2156158 | 2156158 | 2022-01-27 | Union | Mississippi | 28145 | 8522 | 106 |
2152905 | 2152905 | 2022-01-26 | Union | Mississippi | 28145 | 8467 | 106 |
2149653 | 2149653 | 2022-01-25 | Union | Mississippi | 28145 | 8401 | 105 |
2146401 | 2146401 | 2022-01-24 | Union | Mississippi | 28145 | 8323 | 104 |
2143146 | 2143146 | 2022-01-23 | Union | Mississippi | 28145 | 8174 | 104 |
2139891 | 2139891 | 2022-01-22 | Union | Mississippi | 28145 | 8174 | 104 |
2136635 | 2136635 | 2022-01-21 | Union | Mississippi | 28145 | 8174 | 104 |
2133383 | 2133383 | 2022-01-20 | Union | Mississippi | 28145 | 8095 | 104 |
2130130 | 2130130 | 2022-01-19 | Union | Mississippi | 28145 | 7985 | 101 |
2126876 | 2126876 | 2022-01-18 | Union | Mississippi | 28145 | 7891 | 101 |
2123624 | 2123624 | 2022-01-17 | Union | Mississippi | 28145 | 7628 | 101 |
2120372 | 2120372 | 2022-01-16 | Union | Mississippi | 28145 | 7628 | 101 |
2117120 | 2117120 | 2022-01-15 | Union | Mississippi | 28145 | 7628 | 101 |
2113869 | 2113869 | 2022-01-14 | Union | Mississippi | 28145 | 7628 | 101 |
2110617 | 2110617 | 2022-01-13 | Union | Mississippi | 28145 | 7489 | 101 |
2107366 | 2107366 | 2022-01-12 | Union | Mississippi | 28145 | 7385 | 101 |
2104115 | 2104115 | 2022-01-11 | Union | Mississippi | 28145 | 7299 | 101 |
2100864 | 2100864 | 2022-01-10 | Union | Mississippi | 28145 | 7234 | 101 |
2097613 | 2097613 | 2022-01-09 | Union | Mississippi | 28145 | 7146 | 100 |
2094361 | 2094361 | 2022-01-08 | Union | Mississippi | 28145 | 7146 | 100 |
2091109 | 2091109 | 2022-01-07 | Union | Mississippi | 28145 | 7146 | 100 |
2087858 | 2087858 | 2022-01-06 | Union | Mississippi | 28145 | 7101 | 100 |
2084606 | 2084606 | 2022-01-05 | Union | Mississippi | 28145 | 7031 | 100 |
2081354 | 2081354 | 2022-01-04 | Union | Mississippi | 28145 | 6984 | 100 |
2078102 | 2078102 | 2022-01-03 | Union | Mississippi | 28145 | 6923 | 99 |
2074851 | 2074851 | 2022-01-02 | Union | Mississippi | 28145 | 6804 | 99 |
2071600 | 2071600 | 2022-01-01 | Union | Mississippi | 28145 | 6804 | 99 |
2068349 | 2068349 | 2021-12-31 | Union | Mississippi | 28145 | 6804 | 99 |
2065098 | 2065098 | 2021-12-30 | Union | Mississippi | 28145 | 6804 | 99 |
2061848 | 2061848 | 2021-12-29 | Union | Mississippi | 28145 | 6769 | 99 |
2058599 | 2058599 | 2021-12-28 | Union | Mississippi | 28145 | 6738 | 99 |
2055350 | 2055350 | 2021-12-27 | Union | Mississippi | 28145 | 6713 | 99 |
2052100 | 2052100 | 2021-12-26 | Union | Mississippi | 28145 | 6635 | 99 |
2048850 | 2048850 | 2021-12-25 | Union | Mississippi | 28145 | 6635 | 99 |
2045600 | 2045600 | 2021-12-24 | Union | Mississippi | 28145 | 6635 | 99 |
2042350 | 2042350 | 2021-12-23 | Union | Mississippi | 28145 | 6635 | 99 |
2039101 | 2039101 | 2021-12-22 | Union | Mississippi | 28145 | 6635 | 99 |
2035851 | 2035851 | 2021-12-21 | Union | Mississippi | 28145 | 6631 | 99 |
2032601 | 2032601 | 2021-12-20 | Union | Mississippi | 28145 | 6617 | 99 |
2029350 | 2029350 | 2021-12-19 | Union | Mississippi | 28145 | 6601 | 99 |
2026099 | 2026099 | 2021-12-18 | Union | Mississippi | 28145 | 6601 | 99 |
2022848 | 2022848 | 2021-12-17 | Union | Mississippi | 28145 | 6601 | 99 |
2019597 | 2019597 | 2021-12-16 | Union | Mississippi | 28145 | 6582 | 99 |
2016347 | 2016347 | 2021-12-15 | Union | Mississippi | 28145 | 6568 | 99 |
2013096 | 2013096 | 2021-12-14 | Union | Mississippi | 28145 | 6557 | 99 |
2009845 | 2009845 | 2021-12-13 | Union | Mississippi | 28145 | 6545 | 99 |
2006594 | 2006594 | 2021-12-12 | Union | Mississippi | 28145 | 6534 | 99 |
2003343 | 2003343 | 2021-12-11 | Union | Mississippi | 28145 | 6534 | 99 |
2000093 | 2000093 | 2021-12-10 | Union | Mississippi | 28145 | 6534 | 99 |
1996842 | 1996842 | 2021-12-09 | Union | Mississippi | 28145 | 6517 | 99 |
1993591 | 1993591 | 2021-12-08 | Union | Mississippi | 28145 | 6505 | 99 |
1990340 | 1990340 | 2021-12-07 | Union | Mississippi | 28145 | 6470 | 99 |
1987090 | 1987090 | 2021-12-06 | Union | Mississippi | 28145 | 6456 | 99 |
1983840 | 1983840 | 2021-12-05 | Union | Mississippi | 28145 | 6435 | 98 |
1980590 | 1980590 | 2021-12-04 | Union | Mississippi | 28145 | 6435 | 98 |
1977340 | 1977340 | 2021-12-03 | Union | Mississippi | 28145 | 6435 | 98 |
1974090 | 1974090 | 2021-12-02 | Union | Mississippi | 28145 | 6428 | 98 |
1970841 | 1970841 | 2021-12-01 | Union | Mississippi | 28145 | 6416 | 98 |
1967591 | 1967591 | 2021-11-30 | Union | Mississippi | 28145 | 6408 | 98 |
1964339 | 1964339 | 2021-11-29 | Union | Mississippi | 28145 | 6382 | 97 |
1961088 | 1961088 | 2021-11-28 | Union | Mississippi | 28145 | 6338 | 97 |
1957837 | 1957837 | 2021-11-27 | Union | Mississippi | 28145 | 6338 | 97 |
1954586 | 1954586 | 2021-11-26 | Union | Mississippi | 28145 | 6338 | 97 |
1951335 | 1951335 | 2021-11-25 | Union | Mississippi | 28145 | 6338 | 97 |
1948084 | 1948084 | 2021-11-24 | Union | Mississippi | 28145 | 6338 | 97 |
1944833 | 1944833 | 2021-11-23 | Union | Mississippi | 28145 | 6314 | 96 |
1941582 | 1941582 | 2021-11-22 | Union | Mississippi | 28145 | 6304 | 96 |
1938332 | 1938332 | 2021-11-21 | Union | Mississippi | 28145 | 6257 | 96 |
1935082 | 1935082 | 2021-11-20 | Union | Mississippi | 28145 | 6257 | 96 |
1931832 | 1931832 | 2021-11-19 | Union | Mississippi | 28145 | 6257 | 96 |
1928581 | 1928581 | 2021-11-18 | Union | Mississippi | 28145 | 6246 | 96 |
1925331 | 1925331 | 2021-11-17 | Union | Mississippi | 28145 | 6232 | 96 |
1922082 | 1922082 | 2021-11-16 | Union | Mississippi | 28145 | 6222 | 96 |
1918832 | 1918832 | 2021-11-15 | Union | Mississippi | 28145 | 6208 | 95 |
1915582 | 1915582 | 2021-11-14 | Union | Mississippi | 28145 | 6191 | 95 |
1912332 | 1912332 | 2021-11-13 | Union | Mississippi | 28145 | 6191 | 95 |
1909082 | 1909082 | 2021-11-12 | Union | Mississippi | 28145 | 6191 | 95 |
1905833 | 1905833 | 2021-11-11 | Union | Mississippi | 28145 | 6175 | 94 |
1902584 | 1902584 | 2021-11-10 | Union | Mississippi | 28145 | 6175 | 94 |
1899334 | 1899334 | 2021-11-09 | Union | Mississippi | 28145 | 6167 | 94 |
1896084 | 1896084 | 2021-11-08 | Union | Mississippi | 28145 | 6158 | 94 |
1892834 | 1892834 | 2021-11-07 | Union | Mississippi | 28145 | 6148 | 94 |
1889584 | 1889584 | 2021-11-06 | Union | Mississippi | 28145 | 6148 | 94 |
1886334 | 1886334 | 2021-11-05 | Union | Mississippi | 28145 | 6148 | 94 |
1883085 | 1883085 | 2021-11-04 | Union | Mississippi | 28145 | 6139 | 94 |
1879836 | 1879836 | 2021-11-03 | Union | Mississippi | 28145 | 6130 | 94 |
1876587 | 1876587 | 2021-11-02 | Union | Mississippi | 28145 | 6128 | 94 |
1873338 | 1873338 | 2021-11-01 | Union | Mississippi | 28145 | 6120 | 94 |
1870089 | 1870089 | 2021-10-31 | Union | Mississippi | 28145 | 6106 | 94 |
1866840 | 1866840 | 2021-10-30 | Union | Mississippi | 28145 | 6106 | 94 |
1863591 | 1863591 | 2021-10-29 | Union | Mississippi | 28145 | 6106 | 94 |
1860342 | 1860342 | 2021-10-28 | Union | Mississippi | 28145 | 6092 | 94 |
1857093 | 1857093 | 2021-10-27 | Union | Mississippi | 28145 | 6085 | 94 |
1853844 | 1853844 | 2021-10-26 | Union | Mississippi | 28145 | 6077 | 94 |
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);