ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 28067 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175644 | 2175644 | 2022-02-02 | Jones | Mississippi | 28067 | 19863 | 264 |
2172391 | 2172391 | 2022-02-01 | Jones | Mississippi | 28067 | 19756 | 262 |
2169138 | 2169138 | 2022-01-31 | Jones | Mississippi | 28067 | 19678 | 261 |
2165883 | 2165883 | 2022-01-30 | Jones | Mississippi | 28067 | 19400 | 259 |
2162628 | 2162628 | 2022-01-29 | Jones | Mississippi | 28067 | 19400 | 259 |
2159373 | 2159373 | 2022-01-28 | Jones | Mississippi | 28067 | 19400 | 259 |
2156119 | 2156119 | 2022-01-27 | Jones | Mississippi | 28067 | 19251 | 256 |
2152866 | 2152866 | 2022-01-26 | Jones | Mississippi | 28067 | 18973 | 251 |
2149614 | 2149614 | 2022-01-25 | Jones | Mississippi | 28067 | 18781 | 251 |
2146362 | 2146362 | 2022-01-24 | Jones | Mississippi | 28067 | 18689 | 251 |
2143107 | 2143107 | 2022-01-23 | Jones | Mississippi | 28067 | 18117 | 251 |
2139852 | 2139852 | 2022-01-22 | Jones | Mississippi | 28067 | 18117 | 251 |
2136596 | 2136596 | 2022-01-21 | Jones | Mississippi | 28067 | 18117 | 251 |
2133344 | 2133344 | 2022-01-20 | Jones | Mississippi | 28067 | 17767 | 251 |
2130091 | 2130091 | 2022-01-19 | Jones | Mississippi | 28067 | 17499 | 251 |
2126837 | 2126837 | 2022-01-18 | Jones | Mississippi | 28067 | 17287 | 250 |
2123585 | 2123585 | 2022-01-17 | Jones | Mississippi | 28067 | 16691 | 250 |
2120333 | 2120333 | 2022-01-16 | Jones | Mississippi | 28067 | 16691 | 250 |
2117081 | 2117081 | 2022-01-15 | Jones | Mississippi | 28067 | 16691 | 250 |
2113830 | 2113830 | 2022-01-14 | Jones | Mississippi | 28067 | 16691 | 250 |
2110578 | 2110578 | 2022-01-13 | Jones | Mississippi | 28067 | 16464 | 250 |
2107327 | 2107327 | 2022-01-12 | Jones | Mississippi | 28067 | 16191 | 250 |
2104076 | 2104076 | 2022-01-11 | Jones | Mississippi | 28067 | 15985 | 250 |
2100825 | 2100825 | 2022-01-10 | Jones | Mississippi | 28067 | 15899 | 250 |
2097574 | 2097574 | 2022-01-09 | Jones | Mississippi | 28067 | 15457 | 250 |
2094322 | 2094322 | 2022-01-08 | Jones | Mississippi | 28067 | 15457 | 250 |
2091070 | 2091070 | 2022-01-07 | Jones | Mississippi | 28067 | 15457 | 250 |
2087819 | 2087819 | 2022-01-06 | Jones | Mississippi | 28067 | 15266 | 250 |
2084567 | 2084567 | 2022-01-05 | Jones | Mississippi | 28067 | 15163 | 250 |
2081315 | 2081315 | 2022-01-04 | Jones | Mississippi | 28067 | 15019 | 250 |
2078063 | 2078063 | 2022-01-03 | Jones | Mississippi | 28067 | 14932 | 250 |
2074812 | 2074812 | 2022-01-02 | Jones | Mississippi | 28067 | 14546 | 250 |
2071561 | 2071561 | 2022-01-01 | Jones | Mississippi | 28067 | 14546 | 250 |
2068310 | 2068310 | 2021-12-31 | Jones | Mississippi | 28067 | 14546 | 250 |
2065059 | 2065059 | 2021-12-30 | Jones | Mississippi | 28067 | 14546 | 250 |
2061809 | 2061809 | 2021-12-29 | Jones | Mississippi | 28067 | 14469 | 250 |
2058560 | 2058560 | 2021-12-28 | Jones | Mississippi | 28067 | 14439 | 250 |
2055311 | 2055311 | 2021-12-27 | Jones | Mississippi | 28067 | 14408 | 248 |
2052061 | 2052061 | 2021-12-26 | Jones | Mississippi | 28067 | 14299 | 248 |
2048811 | 2048811 | 2021-12-25 | Jones | Mississippi | 28067 | 14299 | 248 |
2045561 | 2045561 | 2021-12-24 | Jones | Mississippi | 28067 | 14299 | 248 |
2042311 | 2042311 | 2021-12-23 | Jones | Mississippi | 28067 | 14299 | 248 |
2039062 | 2039062 | 2021-12-22 | Jones | Mississippi | 28067 | 14299 | 248 |
2035812 | 2035812 | 2021-12-21 | Jones | Mississippi | 28067 | 14295 | 248 |
2032562 | 2032562 | 2021-12-20 | Jones | Mississippi | 28067 | 14277 | 248 |
2029311 | 2029311 | 2021-12-19 | Jones | Mississippi | 28067 | 14264 | 248 |
2026060 | 2026060 | 2021-12-18 | Jones | Mississippi | 28067 | 14264 | 248 |
2022809 | 2022809 | 2021-12-17 | Jones | Mississippi | 28067 | 14264 | 248 |
2019558 | 2019558 | 2021-12-16 | Jones | Mississippi | 28067 | 14256 | 248 |
2016308 | 2016308 | 2021-12-15 | Jones | Mississippi | 28067 | 14250 | 248 |
2013057 | 2013057 | 2021-12-14 | Jones | Mississippi | 28067 | 14245 | 248 |
2009806 | 2009806 | 2021-12-13 | Jones | Mississippi | 28067 | 14243 | 248 |
2006555 | 2006555 | 2021-12-12 | Jones | Mississippi | 28067 | 14233 | 248 |
2003304 | 2003304 | 2021-12-11 | Jones | Mississippi | 28067 | 14233 | 248 |
2000054 | 2000054 | 2021-12-10 | Jones | Mississippi | 28067 | 14233 | 248 |
1996803 | 1996803 | 2021-12-09 | Jones | Mississippi | 28067 | 14220 | 248 |
1993552 | 1993552 | 2021-12-08 | Jones | Mississippi | 28067 | 14208 | 248 |
1990301 | 1990301 | 2021-12-07 | Jones | Mississippi | 28067 | 14195 | 248 |
1987051 | 1987051 | 2021-12-06 | Jones | Mississippi | 28067 | 14191 | 248 |
1983801 | 1983801 | 2021-12-05 | Jones | Mississippi | 28067 | 14158 | 248 |
1980551 | 1980551 | 2021-12-04 | Jones | Mississippi | 28067 | 14158 | 248 |
1977301 | 1977301 | 2021-12-03 | Jones | Mississippi | 28067 | 14158 | 248 |
1974051 | 1974051 | 2021-12-02 | Jones | Mississippi | 28067 | 14155 | 248 |
1970802 | 1970802 | 2021-12-01 | Jones | Mississippi | 28067 | 14137 | 247 |
1967552 | 1967552 | 2021-11-30 | Jones | Mississippi | 28067 | 14129 | 247 |
1964300 | 1964300 | 2021-11-29 | Jones | Mississippi | 28067 | 14113 | 247 |
1961049 | 1961049 | 2021-11-28 | Jones | Mississippi | 28067 | 14086 | 247 |
1957798 | 1957798 | 2021-11-27 | Jones | Mississippi | 28067 | 14086 | 247 |
1954547 | 1954547 | 2021-11-26 | Jones | Mississippi | 28067 | 14086 | 247 |
1951296 | 1951296 | 2021-11-25 | Jones | Mississippi | 28067 | 14086 | 247 |
1948045 | 1948045 | 2021-11-24 | Jones | Mississippi | 28067 | 14086 | 247 |
1944794 | 1944794 | 2021-11-23 | Jones | Mississippi | 28067 | 14083 | 247 |
1941543 | 1941543 | 2021-11-22 | Jones | Mississippi | 28067 | 14078 | 247 |
1938293 | 1938293 | 2021-11-21 | Jones | Mississippi | 28067 | 14054 | 246 |
1935043 | 1935043 | 2021-11-20 | Jones | Mississippi | 28067 | 14054 | 246 |
1931793 | 1931793 | 2021-11-19 | Jones | Mississippi | 28067 | 14054 | 246 |
1928542 | 1928542 | 2021-11-18 | Jones | Mississippi | 28067 | 14038 | 246 |
1925292 | 1925292 | 2021-11-17 | Jones | Mississippi | 28067 | 14032 | 246 |
1922043 | 1922043 | 2021-11-16 | Jones | Mississippi | 28067 | 14031 | 246 |
1918793 | 1918793 | 2021-11-15 | Jones | Mississippi | 28067 | 14030 | 246 |
1915543 | 1915543 | 2021-11-14 | Jones | Mississippi | 28067 | 14000 | 244 |
1912293 | 1912293 | 2021-11-13 | Jones | Mississippi | 28067 | 14000 | 244 |
1909043 | 1909043 | 2021-11-12 | Jones | Mississippi | 28067 | 14000 | 244 |
1905794 | 1905794 | 2021-11-11 | Jones | Mississippi | 28067 | 13986 | 244 |
1902545 | 1902545 | 2021-11-10 | Jones | Mississippi | 28067 | 13986 | 244 |
1899295 | 1899295 | 2021-11-09 | Jones | Mississippi | 28067 | 13970 | 243 |
1896045 | 1896045 | 2021-11-08 | Jones | Mississippi | 28067 | 13961 | 243 |
1892795 | 1892795 | 2021-11-07 | Jones | Mississippi | 28067 | 13947 | 243 |
1889545 | 1889545 | 2021-11-06 | Jones | Mississippi | 28067 | 13947 | 243 |
1886295 | 1886295 | 2021-11-05 | Jones | Mississippi | 28067 | 13947 | 243 |
1883046 | 1883046 | 2021-11-04 | Jones | Mississippi | 28067 | 13941 | 243 |
1879797 | 1879797 | 2021-11-03 | Jones | Mississippi | 28067 | 13934 | 243 |
1876548 | 1876548 | 2021-11-02 | Jones | Mississippi | 28067 | 13923 | 243 |
1873299 | 1873299 | 2021-11-01 | Jones | Mississippi | 28067 | 13920 | 243 |
1870050 | 1870050 | 2021-10-31 | Jones | Mississippi | 28067 | 13913 | 243 |
1866801 | 1866801 | 2021-10-30 | Jones | Mississippi | 28067 | 13913 | 243 |
1863552 | 1863552 | 2021-10-29 | Jones | Mississippi | 28067 | 13913 | 243 |
1860303 | 1860303 | 2021-10-28 | Jones | Mississippi | 28067 | 13911 | 243 |
1857054 | 1857054 | 2021-10-27 | Jones | Mississippi | 28067 | 13904 | 243 |
1853805 | 1853805 | 2021-10-26 | Jones | Mississippi | 28067 | 13894 | 243 |
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);