ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Bolivar" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2110550 | 2110550 | 2022-01-13 | Bolivar | Mississippi | 28011 | 7496 | 155 |
2107299 | 2107299 | 2022-01-12 | Bolivar | Mississippi | 28011 | 7396 | 155 |
2104048 | 2104048 | 2022-01-11 | Bolivar | Mississippi | 28011 | 7278 | 155 |
2100797 | 2100797 | 2022-01-10 | Bolivar | Mississippi | 28011 | 7248 | 155 |
2097546 | 2097546 | 2022-01-09 | Bolivar | Mississippi | 28011 | 7100 | 155 |
2094294 | 2094294 | 2022-01-08 | Bolivar | Mississippi | 28011 | 7100 | 155 |
2091042 | 2091042 | 2022-01-07 | Bolivar | Mississippi | 28011 | 7100 | 155 |
2087791 | 2087791 | 2022-01-06 | Bolivar | Mississippi | 28011 | 7070 | 155 |
2084539 | 2084539 | 2022-01-05 | Bolivar | Mississippi | 28011 | 7017 | 155 |
2081287 | 2081287 | 2022-01-04 | Bolivar | Mississippi | 28011 | 6989 | 155 |
2078035 | 2078035 | 2022-01-03 | Bolivar | Mississippi | 28011 | 6912 | 154 |
2074784 | 2074784 | 2022-01-02 | Bolivar | Mississippi | 28011 | 6743 | 154 |
2071533 | 2071533 | 2022-01-01 | Bolivar | Mississippi | 28011 | 6743 | 154 |
2068282 | 2068282 | 2021-12-31 | Bolivar | Mississippi | 28011 | 6743 | 154 |
2065031 | 2065031 | 2021-12-30 | Bolivar | Mississippi | 28011 | 6743 | 154 |
2061781 | 2061781 | 2021-12-29 | Bolivar | Mississippi | 28011 | 6699 | 154 |
2058532 | 2058532 | 2021-12-28 | Bolivar | Mississippi | 28011 | 6670 | 153 |
2055283 | 2055283 | 2021-12-27 | Bolivar | Mississippi | 28011 | 6641 | 153 |
2052033 | 2052033 | 2021-12-26 | Bolivar | Mississippi | 28011 | 6554 | 153 |
2048783 | 2048783 | 2021-12-25 | Bolivar | Mississippi | 28011 | 6554 | 153 |
2045533 | 2045533 | 2021-12-24 | Bolivar | Mississippi | 28011 | 6554 | 153 |
2042283 | 2042283 | 2021-12-23 | Bolivar | Mississippi | 28011 | 6554 | 153 |
2039034 | 2039034 | 2021-12-22 | Bolivar | Mississippi | 28011 | 6554 | 153 |
2035784 | 2035784 | 2021-12-21 | Bolivar | Mississippi | 28011 | 6550 | 153 |
2032534 | 2032534 | 2021-12-20 | Bolivar | Mississippi | 28011 | 6539 | 153 |
2029283 | 2029283 | 2021-12-19 | Bolivar | Mississippi | 28011 | 6534 | 153 |
2026032 | 2026032 | 2021-12-18 | Bolivar | Mississippi | 28011 | 6534 | 153 |
2022781 | 2022781 | 2021-12-17 | Bolivar | Mississippi | 28011 | 6534 | 153 |
2019530 | 2019530 | 2021-12-16 | Bolivar | Mississippi | 28011 | 6527 | 153 |
2016280 | 2016280 | 2021-12-15 | Bolivar | Mississippi | 28011 | 6525 | 153 |
2013029 | 2013029 | 2021-12-14 | Bolivar | Mississippi | 28011 | 6518 | 153 |
2009778 | 2009778 | 2021-12-13 | Bolivar | Mississippi | 28011 | 6514 | 151 |
2006527 | 2006527 | 2021-12-12 | Bolivar | Mississippi | 28011 | 6512 | 151 |
2003276 | 2003276 | 2021-12-11 | Bolivar | Mississippi | 28011 | 6512 | 151 |
2000026 | 2000026 | 2021-12-10 | Bolivar | Mississippi | 28011 | 6512 | 151 |
1996775 | 1996775 | 2021-12-09 | Bolivar | Mississippi | 28011 | 6509 | 151 |
1993524 | 1993524 | 2021-12-08 | Bolivar | Mississippi | 28011 | 6499 | 151 |
1990273 | 1990273 | 2021-12-07 | Bolivar | Mississippi | 28011 | 6484 | 151 |
1987023 | 1987023 | 2021-12-06 | Bolivar | Mississippi | 28011 | 6472 | 151 |
1983773 | 1983773 | 2021-12-05 | Bolivar | Mississippi | 28011 | 6468 | 151 |
1980523 | 1980523 | 2021-12-04 | Bolivar | Mississippi | 28011 | 6468 | 151 |
1977273 | 1977273 | 2021-12-03 | Bolivar | Mississippi | 28011 | 6468 | 151 |
1974023 | 1974023 | 2021-12-02 | Bolivar | Mississippi | 28011 | 6468 | 151 |
1970774 | 1970774 | 2021-12-01 | Bolivar | Mississippi | 28011 | 6461 | 151 |
1967524 | 1967524 | 2021-11-30 | Bolivar | Mississippi | 28011 | 6451 | 151 |
1964272 | 1964272 | 2021-11-29 | Bolivar | Mississippi | 28011 | 6445 | 151 |
1961021 | 1961021 | 2021-11-28 | Bolivar | Mississippi | 28011 | 6440 | 151 |
1957770 | 1957770 | 2021-11-27 | Bolivar | Mississippi | 28011 | 6440 | 151 |
1954519 | 1954519 | 2021-11-26 | Bolivar | Mississippi | 28011 | 6440 | 151 |
1951268 | 1951268 | 2021-11-25 | Bolivar | Mississippi | 28011 | 6440 | 151 |
1948017 | 1948017 | 2021-11-24 | Bolivar | Mississippi | 28011 | 6440 | 151 |
1944766 | 1944766 | 2021-11-23 | Bolivar | Mississippi | 28011 | 6440 | 151 |
1941515 | 1941515 | 2021-11-22 | Bolivar | Mississippi | 28011 | 6438 | 151 |
1938265 | 1938265 | 2021-11-21 | Bolivar | Mississippi | 28011 | 6424 | 151 |
1935015 | 1935015 | 2021-11-20 | Bolivar | Mississippi | 28011 | 6424 | 151 |
1931765 | 1931765 | 2021-11-19 | Bolivar | Mississippi | 28011 | 6424 | 151 |
1928514 | 1928514 | 2021-11-18 | Bolivar | Mississippi | 28011 | 6418 | 151 |
1925264 | 1925264 | 2021-11-17 | Bolivar | Mississippi | 28011 | 6418 | 151 |
1922015 | 1922015 | 2021-11-16 | Bolivar | Mississippi | 28011 | 6418 | 151 |
1918765 | 1918765 | 2021-11-15 | Bolivar | Mississippi | 28011 | 6415 | 151 |
1915515 | 1915515 | 2021-11-14 | Bolivar | Mississippi | 28011 | 6410 | 151 |
1912265 | 1912265 | 2021-11-13 | Bolivar | Mississippi | 28011 | 6410 | 151 |
1909015 | 1909015 | 2021-11-12 | Bolivar | Mississippi | 28011 | 6410 | 151 |
1905766 | 1905766 | 2021-11-11 | Bolivar | Mississippi | 28011 | 6404 | 151 |
1902517 | 1902517 | 2021-11-10 | Bolivar | Mississippi | 28011 | 6404 | 151 |
1899267 | 1899267 | 2021-11-09 | Bolivar | Mississippi | 28011 | 6402 | 151 |
1896017 | 1896017 | 2021-11-08 | Bolivar | Mississippi | 28011 | 6394 | 151 |
1892767 | 1892767 | 2021-11-07 | Bolivar | Mississippi | 28011 | 6389 | 151 |
1889517 | 1889517 | 2021-11-06 | Bolivar | Mississippi | 28011 | 6389 | 151 |
1886267 | 1886267 | 2021-11-05 | Bolivar | Mississippi | 28011 | 6389 | 151 |
1883018 | 1883018 | 2021-11-04 | Bolivar | Mississippi | 28011 | 6380 | 151 |
1879769 | 1879769 | 2021-11-03 | Bolivar | Mississippi | 28011 | 6366 | 151 |
1876520 | 1876520 | 2021-11-02 | Bolivar | Mississippi | 28011 | 6361 | 151 |
1873271 | 1873271 | 2021-11-01 | Bolivar | Mississippi | 28011 | 6348 | 151 |
1870022 | 1870022 | 2021-10-31 | Bolivar | Mississippi | 28011 | 6344 | 151 |
1866773 | 1866773 | 2021-10-30 | Bolivar | Mississippi | 28011 | 6344 | 151 |
1863524 | 1863524 | 2021-10-29 | Bolivar | Mississippi | 28011 | 6344 | 151 |
1860275 | 1860275 | 2021-10-28 | Bolivar | Mississippi | 28011 | 6339 | 150 |
1857026 | 1857026 | 2021-10-27 | Bolivar | Mississippi | 28011 | 6332 | 150 |
1853777 | 1853777 | 2021-10-26 | Bolivar | Mississippi | 28011 | 6331 | 150 |
1850528 | 1850528 | 2021-10-25 | Bolivar | Mississippi | 28011 | 6323 | 150 |
1847278 | 1847278 | 2021-10-24 | Bolivar | Mississippi | 28011 | 6317 | 148 |
1844028 | 1844028 | 2021-10-23 | Bolivar | Mississippi | 28011 | 6317 | 148 |
1840778 | 1840778 | 2021-10-22 | Bolivar | Mississippi | 28011 | 6317 | 148 |
1837529 | 1837529 | 2021-10-21 | Bolivar | Mississippi | 28011 | 6313 | 148 |
1834280 | 1834280 | 2021-10-20 | Bolivar | Mississippi | 28011 | 6302 | 148 |
1831031 | 1831031 | 2021-10-19 | Bolivar | Mississippi | 28011 | 6291 | 147 |
1827782 | 1827782 | 2021-10-18 | Bolivar | Mississippi | 28011 | 6268 | 146 |
1824533 | 1824533 | 2021-10-17 | Bolivar | Mississippi | 28011 | 6266 | 145 |
1821284 | 1821284 | 2021-10-16 | Bolivar | Mississippi | 28011 | 6266 | 145 |
1818035 | 1818035 | 2021-10-15 | Bolivar | Mississippi | 28011 | 6266 | 145 |
1814786 | 1814786 | 2021-10-14 | Bolivar | Mississippi | 28011 | 6264 | 145 |
1811538 | 1811538 | 2021-10-13 | Bolivar | Mississippi | 28011 | 6259 | 145 |
1808289 | 1808289 | 2021-10-12 | Bolivar | Mississippi | 28011 | 6248 | 145 |
1805038 | 1805038 | 2021-10-11 | Bolivar | Mississippi | 28011 | 6242 | 145 |
1801789 | 1801789 | 2021-10-10 | Bolivar | Mississippi | 28011 | 6233 | 145 |
1798540 | 1798540 | 2021-10-09 | Bolivar | Mississippi | 28011 | 6233 | 145 |
1795291 | 1795291 | 2021-10-08 | Bolivar | Mississippi | 28011 | 6233 | 145 |
1792042 | 1792042 | 2021-10-07 | Bolivar | Mississippi | 28011 | 6220 | 145 |
1788793 | 1788793 | 2021-10-06 | Bolivar | Mississippi | 28011 | 6211 | 145 |
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);