ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 28001 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175611 | 2175611 | 2022-02-02 | Adams | Mississippi | 28001 | 6476 | 132 |
2172358 | 2172358 | 2022-02-01 | Adams | Mississippi | 28001 | 6360 | 132 |
2169105 | 2169105 | 2022-01-31 | Adams | Mississippi | 28001 | 6307 | 129 |
2165850 | 2165850 | 2022-01-30 | Adams | Mississippi | 28001 | 6221 | 129 |
2162595 | 2162595 | 2022-01-29 | Adams | Mississippi | 28001 | 6221 | 129 |
2159340 | 2159340 | 2022-01-28 | Adams | Mississippi | 28001 | 6221 | 129 |
2156086 | 2156086 | 2022-01-27 | Adams | Mississippi | 28001 | 6156 | 126 |
2152833 | 2152833 | 2022-01-26 | Adams | Mississippi | 28001 | 6089 | 125 |
2149581 | 2149581 | 2022-01-25 | Adams | Mississippi | 28001 | 6037 | 125 |
2146329 | 2146329 | 2022-01-24 | Adams | Mississippi | 28001 | 6008 | 125 |
2143074 | 2143074 | 2022-01-23 | Adams | Mississippi | 28001 | 5922 | 125 |
2139819 | 2139819 | 2022-01-22 | Adams | Mississippi | 28001 | 5922 | 125 |
2136563 | 2136563 | 2022-01-21 | Adams | Mississippi | 28001 | 5922 | 125 |
2133311 | 2133311 | 2022-01-20 | Adams | Mississippi | 28001 | 5886 | 125 |
2130058 | 2130058 | 2022-01-19 | Adams | Mississippi | 28001 | 5798 | 125 |
2126804 | 2126804 | 2022-01-18 | Adams | Mississippi | 28001 | 5751 | 125 |
2123552 | 2123552 | 2022-01-17 | Adams | Mississippi | 28001 | 5600 | 125 |
2120300 | 2120300 | 2022-01-16 | Adams | Mississippi | 28001 | 5600 | 125 |
2117048 | 2117048 | 2022-01-15 | Adams | Mississippi | 28001 | 5600 | 125 |
2113797 | 2113797 | 2022-01-14 | Adams | Mississippi | 28001 | 5600 | 125 |
2110545 | 2110545 | 2022-01-13 | Adams | Mississippi | 28001 | 5531 | 125 |
2107294 | 2107294 | 2022-01-12 | Adams | Mississippi | 28001 | 5465 | 125 |
2104043 | 2104043 | 2022-01-11 | Adams | Mississippi | 28001 | 5401 | 125 |
2100792 | 2100792 | 2022-01-10 | Adams | Mississippi | 28001 | 5355 | 125 |
2097541 | 2097541 | 2022-01-09 | Adams | Mississippi | 28001 | 5291 | 125 |
2094289 | 2094289 | 2022-01-08 | Adams | Mississippi | 28001 | 5291 | 125 |
2091037 | 2091037 | 2022-01-07 | Adams | Mississippi | 28001 | 5291 | 125 |
2087786 | 2087786 | 2022-01-06 | Adams | Mississippi | 28001 | 5226 | 125 |
2084534 | 2084534 | 2022-01-05 | Adams | Mississippi | 28001 | 5167 | 125 |
2081282 | 2081282 | 2022-01-04 | Adams | Mississippi | 28001 | 5131 | 125 |
2078030 | 2078030 | 2022-01-03 | Adams | Mississippi | 28001 | 5098 | 125 |
2074779 | 2074779 | 2022-01-02 | Adams | Mississippi | 28001 | 4955 | 125 |
2071528 | 2071528 | 2022-01-01 | Adams | Mississippi | 28001 | 4955 | 125 |
2068277 | 2068277 | 2021-12-31 | Adams | Mississippi | 28001 | 4955 | 125 |
2065026 | 2065026 | 2021-12-30 | Adams | Mississippi | 28001 | 4955 | 125 |
2061776 | 2061776 | 2021-12-29 | Adams | Mississippi | 28001 | 4912 | 125 |
2058527 | 2058527 | 2021-12-28 | Adams | Mississippi | 28001 | 4883 | 125 |
2055278 | 2055278 | 2021-12-27 | Adams | Mississippi | 28001 | 4866 | 125 |
2052028 | 2052028 | 2021-12-26 | Adams | Mississippi | 28001 | 4838 | 125 |
2048778 | 2048778 | 2021-12-25 | Adams | Mississippi | 28001 | 4838 | 125 |
2045528 | 2045528 | 2021-12-24 | Adams | Mississippi | 28001 | 4838 | 125 |
2042278 | 2042278 | 2021-12-23 | Adams | Mississippi | 28001 | 4838 | 125 |
2039029 | 2039029 | 2021-12-22 | Adams | Mississippi | 28001 | 4838 | 125 |
2035779 | 2035779 | 2021-12-21 | Adams | Mississippi | 28001 | 4832 | 125 |
2032529 | 2032529 | 2021-12-20 | Adams | Mississippi | 28001 | 4830 | 125 |
2029278 | 2029278 | 2021-12-19 | Adams | Mississippi | 28001 | 4823 | 125 |
2026027 | 2026027 | 2021-12-18 | Adams | Mississippi | 28001 | 4823 | 125 |
2022776 | 2022776 | 2021-12-17 | Adams | Mississippi | 28001 | 4823 | 125 |
2019525 | 2019525 | 2021-12-16 | Adams | Mississippi | 28001 | 4818 | 125 |
2016275 | 2016275 | 2021-12-15 | Adams | Mississippi | 28001 | 4814 | 125 |
2013024 | 2013024 | 2021-12-14 | Adams | Mississippi | 28001 | 4810 | 125 |
2009773 | 2009773 | 2021-12-13 | Adams | Mississippi | 28001 | 4809 | 125 |
2006522 | 2006522 | 2021-12-12 | Adams | Mississippi | 28001 | 4803 | 125 |
2003271 | 2003271 | 2021-12-11 | Adams | Mississippi | 28001 | 4803 | 125 |
2000021 | 2000021 | 2021-12-10 | Adams | Mississippi | 28001 | 4803 | 125 |
1996770 | 1996770 | 2021-12-09 | Adams | Mississippi | 28001 | 4798 | 125 |
1993519 | 1993519 | 2021-12-08 | Adams | Mississippi | 28001 | 4795 | 125 |
1990268 | 1990268 | 2021-12-07 | Adams | Mississippi | 28001 | 4789 | 125 |
1987018 | 1987018 | 2021-12-06 | Adams | Mississippi | 28001 | 4784 | 125 |
1983768 | 1983768 | 2021-12-05 | Adams | Mississippi | 28001 | 4776 | 125 |
1980518 | 1980518 | 2021-12-04 | Adams | Mississippi | 28001 | 4776 | 125 |
1977268 | 1977268 | 2021-12-03 | Adams | Mississippi | 28001 | 4776 | 125 |
1974018 | 1974018 | 2021-12-02 | Adams | Mississippi | 28001 | 4775 | 125 |
1970769 | 1970769 | 2021-12-01 | Adams | Mississippi | 28001 | 4772 | 125 |
1967519 | 1967519 | 2021-11-30 | Adams | Mississippi | 28001 | 4771 | 125 |
1964267 | 1964267 | 2021-11-29 | Adams | Mississippi | 28001 | 4768 | 125 |
1961016 | 1961016 | 2021-11-28 | Adams | Mississippi | 28001 | 4766 | 125 |
1957765 | 1957765 | 2021-11-27 | Adams | Mississippi | 28001 | 4766 | 125 |
1954514 | 1954514 | 2021-11-26 | Adams | Mississippi | 28001 | 4766 | 125 |
1951263 | 1951263 | 2021-11-25 | Adams | Mississippi | 28001 | 4766 | 125 |
1948012 | 1948012 | 2021-11-24 | Adams | Mississippi | 28001 | 4766 | 125 |
1944761 | 1944761 | 2021-11-23 | Adams | Mississippi | 28001 | 4764 | 125 |
1941510 | 1941510 | 2021-11-22 | Adams | Mississippi | 28001 | 4747 | 125 |
1938260 | 1938260 | 2021-11-21 | Adams | Mississippi | 28001 | 4688 | 125 |
1935010 | 1935010 | 2021-11-20 | Adams | Mississippi | 28001 | 4688 | 125 |
1931760 | 1931760 | 2021-11-19 | Adams | Mississippi | 28001 | 4688 | 125 |
1928509 | 1928509 | 2021-11-18 | Adams | Mississippi | 28001 | 4684 | 125 |
1925259 | 1925259 | 2021-11-17 | Adams | Mississippi | 28001 | 4682 | 125 |
1922010 | 1922010 | 2021-11-16 | Adams | Mississippi | 28001 | 4680 | 125 |
1918760 | 1918760 | 2021-11-15 | Adams | Mississippi | 28001 | 4675 | 125 |
1915510 | 1915510 | 2021-11-14 | Adams | Mississippi | 28001 | 4667 | 125 |
1912260 | 1912260 | 2021-11-13 | Adams | Mississippi | 28001 | 4667 | 125 |
1909010 | 1909010 | 2021-11-12 | Adams | Mississippi | 28001 | 4667 | 125 |
1905761 | 1905761 | 2021-11-11 | Adams | Mississippi | 28001 | 4665 | 125 |
1902512 | 1902512 | 2021-11-10 | Adams | Mississippi | 28001 | 4665 | 125 |
1899262 | 1899262 | 2021-11-09 | Adams | Mississippi | 28001 | 4665 | 124 |
1896012 | 1896012 | 2021-11-08 | Adams | Mississippi | 28001 | 4664 | 123 |
1892762 | 1892762 | 2021-11-07 | Adams | Mississippi | 28001 | 4660 | 123 |
1889512 | 1889512 | 2021-11-06 | Adams | Mississippi | 28001 | 4660 | 123 |
1886262 | 1886262 | 2021-11-05 | Adams | Mississippi | 28001 | 4660 | 123 |
1883013 | 1883013 | 2021-11-04 | Adams | Mississippi | 28001 | 4652 | 122 |
1879764 | 1879764 | 2021-11-03 | Adams | Mississippi | 28001 | 4652 | 122 |
1876515 | 1876515 | 2021-11-02 | Adams | Mississippi | 28001 | 4647 | 122 |
1873266 | 1873266 | 2021-11-01 | Adams | Mississippi | 28001 | 4630 | 122 |
1870017 | 1870017 | 2021-10-31 | Adams | Mississippi | 28001 | 4623 | 120 |
1866768 | 1866768 | 2021-10-30 | Adams | Mississippi | 28001 | 4623 | 120 |
1863519 | 1863519 | 2021-10-29 | Adams | Mississippi | 28001 | 4623 | 120 |
1860270 | 1860270 | 2021-10-28 | Adams | Mississippi | 28001 | 4622 | 120 |
1857021 | 1857021 | 2021-10-27 | Adams | Mississippi | 28001 | 4618 | 120 |
1853772 | 1853772 | 2021-10-26 | Adams | Mississippi | 28001 | 4617 | 120 |
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);