ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Jackson" and fips = 28059 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175640 | 2175640 | 2022-02-02 | Jackson | Mississippi | 28059 | 34627 | 406 |
2172387 | 2172387 | 2022-02-01 | Jackson | Mississippi | 28059 | 34362 | 404 |
2169134 | 2169134 | 2022-01-31 | Jackson | Mississippi | 28059 | 34152 | 402 |
2165879 | 2165879 | 2022-01-30 | Jackson | Mississippi | 28059 | 33817 | 400 |
2162624 | 2162624 | 2022-01-29 | Jackson | Mississippi | 28059 | 33817 | 400 |
2159369 | 2159369 | 2022-01-28 | Jackson | Mississippi | 28059 | 33817 | 400 |
2156115 | 2156115 | 2022-01-27 | Jackson | Mississippi | 28059 | 33567 | 399 |
2152862 | 2152862 | 2022-01-26 | Jackson | Mississippi | 28059 | 33259 | 398 |
2149610 | 2149610 | 2022-01-25 | Jackson | Mississippi | 28059 | 33026 | 398 |
2146358 | 2146358 | 2022-01-24 | Jackson | Mississippi | 28059 | 32741 | 398 |
2143103 | 2143103 | 2022-01-23 | Jackson | Mississippi | 28059 | 32118 | 398 |
2139848 | 2139848 | 2022-01-22 | Jackson | Mississippi | 28059 | 32118 | 398 |
2136592 | 2136592 | 2022-01-21 | Jackson | Mississippi | 28059 | 32118 | 398 |
2133340 | 2133340 | 2022-01-20 | Jackson | Mississippi | 28059 | 31821 | 398 |
2130087 | 2130087 | 2022-01-19 | Jackson | Mississippi | 28059 | 31446 | 398 |
2126833 | 2126833 | 2022-01-18 | Jackson | Mississippi | 28059 | 31040 | 398 |
2123581 | 2123581 | 2022-01-17 | Jackson | Mississippi | 28059 | 29940 | 398 |
2120329 | 2120329 | 2022-01-16 | Jackson | Mississippi | 28059 | 29940 | 398 |
2117077 | 2117077 | 2022-01-15 | Jackson | Mississippi | 28059 | 29940 | 398 |
2113826 | 2113826 | 2022-01-14 | Jackson | Mississippi | 28059 | 29940 | 398 |
2110574 | 2110574 | 2022-01-13 | Jackson | Mississippi | 28059 | 29475 | 397 |
2107323 | 2107323 | 2022-01-12 | Jackson | Mississippi | 28059 | 29025 | 397 |
2104072 | 2104072 | 2022-01-11 | Jackson | Mississippi | 28059 | 28609 | 397 |
2100821 | 2100821 | 2022-01-10 | Jackson | Mississippi | 28059 | 28236 | 397 |
2097570 | 2097570 | 2022-01-09 | Jackson | Mississippi | 28059 | 27545 | 396 |
2094318 | 2094318 | 2022-01-08 | Jackson | Mississippi | 28059 | 27545 | 396 |
2091066 | 2091066 | 2022-01-07 | Jackson | Mississippi | 28059 | 27545 | 396 |
2087815 | 2087815 | 2022-01-06 | Jackson | Mississippi | 28059 | 27175 | 396 |
2084563 | 2084563 | 2022-01-05 | Jackson | Mississippi | 28059 | 26767 | 396 |
2081311 | 2081311 | 2022-01-04 | Jackson | Mississippi | 28059 | 26397 | 396 |
2078059 | 2078059 | 2022-01-03 | Jackson | Mississippi | 28059 | 26139 | 396 |
2074808 | 2074808 | 2022-01-02 | Jackson | Mississippi | 28059 | 25614 | 396 |
2071557 | 2071557 | 2022-01-01 | Jackson | Mississippi | 28059 | 25614 | 396 |
2068306 | 2068306 | 2021-12-31 | Jackson | Mississippi | 28059 | 25614 | 396 |
2065055 | 2065055 | 2021-12-30 | Jackson | Mississippi | 28059 | 25614 | 396 |
2061805 | 2061805 | 2021-12-29 | Jackson | Mississippi | 28059 | 25480 | 393 |
2058556 | 2058556 | 2021-12-28 | Jackson | Mississippi | 28059 | 25336 | 393 |
2055307 | 2055307 | 2021-12-27 | Jackson | Mississippi | 28059 | 25257 | 393 |
2052057 | 2052057 | 2021-12-26 | Jackson | Mississippi | 28059 | 25110 | 393 |
2048807 | 2048807 | 2021-12-25 | Jackson | Mississippi | 28059 | 25110 | 393 |
2045557 | 2045557 | 2021-12-24 | Jackson | Mississippi | 28059 | 25110 | 393 |
2042307 | 2042307 | 2021-12-23 | Jackson | Mississippi | 28059 | 25110 | 393 |
2039058 | 2039058 | 2021-12-22 | Jackson | Mississippi | 28059 | 25110 | 393 |
2035808 | 2035808 | 2021-12-21 | Jackson | Mississippi | 28059 | 25102 | 393 |
2032558 | 2032558 | 2021-12-20 | Jackson | Mississippi | 28059 | 25084 | 393 |
2029307 | 2029307 | 2021-12-19 | Jackson | Mississippi | 28059 | 25056 | 393 |
2026056 | 2026056 | 2021-12-18 | Jackson | Mississippi | 28059 | 25056 | 393 |
2022805 | 2022805 | 2021-12-17 | Jackson | Mississippi | 28059 | 25056 | 393 |
2019554 | 2019554 | 2021-12-16 | Jackson | Mississippi | 28059 | 25034 | 393 |
2016304 | 2016304 | 2021-12-15 | Jackson | Mississippi | 28059 | 25023 | 393 |
2013053 | 2013053 | 2021-12-14 | Jackson | Mississippi | 28059 | 25017 | 392 |
2009802 | 2009802 | 2021-12-13 | Jackson | Mississippi | 28059 | 25009 | 392 |
2006551 | 2006551 | 2021-12-12 | Jackson | Mississippi | 28059 | 24987 | 392 |
2003300 | 2003300 | 2021-12-11 | Jackson | Mississippi | 28059 | 24987 | 392 |
2000050 | 2000050 | 2021-12-10 | Jackson | Mississippi | 28059 | 24987 | 392 |
1996799 | 1996799 | 2021-12-09 | Jackson | Mississippi | 28059 | 24976 | 392 |
1993548 | 1993548 | 2021-12-08 | Jackson | Mississippi | 28059 | 24959 | 392 |
1990297 | 1990297 | 2021-12-07 | Jackson | Mississippi | 28059 | 24938 | 392 |
1987047 | 1987047 | 2021-12-06 | Jackson | Mississippi | 28059 | 24926 | 392 |
1983797 | 1983797 | 2021-12-05 | Jackson | Mississippi | 28059 | 24906 | 392 |
1980547 | 1980547 | 2021-12-04 | Jackson | Mississippi | 28059 | 24906 | 392 |
1977297 | 1977297 | 2021-12-03 | Jackson | Mississippi | 28059 | 24906 | 392 |
1974047 | 1974047 | 2021-12-02 | Jackson | Mississippi | 28059 | 24896 | 391 |
1970798 | 1970798 | 2021-12-01 | Jackson | Mississippi | 28059 | 24886 | 391 |
1967548 | 1967548 | 2021-11-30 | Jackson | Mississippi | 28059 | 24876 | 391 |
1964296 | 1964296 | 2021-11-29 | Jackson | Mississippi | 28059 | 24854 | 389 |
1961045 | 1961045 | 2021-11-28 | Jackson | Mississippi | 28059 | 24830 | 389 |
1957794 | 1957794 | 2021-11-27 | Jackson | Mississippi | 28059 | 24830 | 389 |
1954543 | 1954543 | 2021-11-26 | Jackson | Mississippi | 28059 | 24830 | 389 |
1951292 | 1951292 | 2021-11-25 | Jackson | Mississippi | 28059 | 24830 | 389 |
1948041 | 1948041 | 2021-11-24 | Jackson | Mississippi | 28059 | 24830 | 389 |
1944790 | 1944790 | 2021-11-23 | Jackson | Mississippi | 28059 | 24827 | 389 |
1941539 | 1941539 | 2021-11-22 | Jackson | Mississippi | 28059 | 24809 | 389 |
1938289 | 1938289 | 2021-11-21 | Jackson | Mississippi | 28059 | 24790 | 388 |
1935039 | 1935039 | 2021-11-20 | Jackson | Mississippi | 28059 | 24790 | 388 |
1931789 | 1931789 | 2021-11-19 | Jackson | Mississippi | 28059 | 24790 | 388 |
1928538 | 1928538 | 2021-11-18 | Jackson | Mississippi | 28059 | 24784 | 388 |
1925288 | 1925288 | 2021-11-17 | Jackson | Mississippi | 28059 | 24778 | 388 |
1922039 | 1922039 | 2021-11-16 | Jackson | Mississippi | 28059 | 24766 | 388 |
1918789 | 1918789 | 2021-11-15 | Jackson | Mississippi | 28059 | 24757 | 386 |
1915539 | 1915539 | 2021-11-14 | Jackson | Mississippi | 28059 | 24726 | 386 |
1912289 | 1912289 | 2021-11-13 | Jackson | Mississippi | 28059 | 24726 | 386 |
1909039 | 1909039 | 2021-11-12 | Jackson | Mississippi | 28059 | 24726 | 386 |
1905790 | 1905790 | 2021-11-11 | Jackson | Mississippi | 28059 | 24699 | 386 |
1902541 | 1902541 | 2021-11-10 | Jackson | Mississippi | 28059 | 24699 | 386 |
1899291 | 1899291 | 2021-11-09 | Jackson | Mississippi | 28059 | 24693 | 386 |
1896041 | 1896041 | 2021-11-08 | Jackson | Mississippi | 28059 | 24675 | 386 |
1892791 | 1892791 | 2021-11-07 | Jackson | Mississippi | 28059 | 24658 | 386 |
1889541 | 1889541 | 2021-11-06 | Jackson | Mississippi | 28059 | 24658 | 386 |
1886291 | 1886291 | 2021-11-05 | Jackson | Mississippi | 28059 | 24658 | 386 |
1883042 | 1883042 | 2021-11-04 | Jackson | Mississippi | 28059 | 24640 | 386 |
1879793 | 1879793 | 2021-11-03 | Jackson | Mississippi | 28059 | 24631 | 386 |
1876544 | 1876544 | 2021-11-02 | Jackson | Mississippi | 28059 | 24627 | 386 |
1873295 | 1873295 | 2021-11-01 | Jackson | Mississippi | 28059 | 24602 | 386 |
1870046 | 1870046 | 2021-10-31 | Jackson | Mississippi | 28059 | 24582 | 386 |
1866797 | 1866797 | 2021-10-30 | Jackson | Mississippi | 28059 | 24582 | 386 |
1863548 | 1863548 | 2021-10-29 | Jackson | Mississippi | 28059 | 24582 | 386 |
1860299 | 1860299 | 2021-10-28 | Jackson | Mississippi | 28059 | 24569 | 386 |
1857050 | 1857050 | 2021-10-27 | Jackson | Mississippi | 28059 | 24557 | 386 |
1853801 | 1853801 | 2021-10-26 | Jackson | Mississippi | 28059 | 24551 | 386 |
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);