ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where county = "Warren" and fips = 28149 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175685 | 2175685 | 2022-02-02 | Warren | Mississippi | 28149 | 9505 | 189 |
2172432 | 2172432 | 2022-02-01 | Warren | Mississippi | 28149 | 9474 | 187 |
2169179 | 2169179 | 2022-01-31 | Warren | Mississippi | 28149 | 9449 | 185 |
2165924 | 2165924 | 2022-01-30 | Warren | Mississippi | 28149 | 9343 | 184 |
2162669 | 2162669 | 2022-01-29 | Warren | Mississippi | 28149 | 9343 | 184 |
2159414 | 2159414 | 2022-01-28 | Warren | Mississippi | 28149 | 9343 | 184 |
2156160 | 2156160 | 2022-01-27 | Warren | Mississippi | 28149 | 9315 | 184 |
2152907 | 2152907 | 2022-01-26 | Warren | Mississippi | 28149 | 9253 | 184 |
2149655 | 2149655 | 2022-01-25 | Warren | Mississippi | 28149 | 9204 | 184 |
2146403 | 2146403 | 2022-01-24 | Warren | Mississippi | 28149 | 9154 | 184 |
2143148 | 2143148 | 2022-01-23 | Warren | Mississippi | 28149 | 9040 | 184 |
2139893 | 2139893 | 2022-01-22 | Warren | Mississippi | 28149 | 9040 | 184 |
2136637 | 2136637 | 2022-01-21 | Warren | Mississippi | 28149 | 9040 | 184 |
2133385 | 2133385 | 2022-01-20 | Warren | Mississippi | 28149 | 8928 | 184 |
2130132 | 2130132 | 2022-01-19 | Warren | Mississippi | 28149 | 8825 | 184 |
2126878 | 2126878 | 2022-01-18 | Warren | Mississippi | 28149 | 8715 | 182 |
2123626 | 2123626 | 2022-01-17 | Warren | Mississippi | 28149 | 8320 | 182 |
2120374 | 2120374 | 2022-01-16 | Warren | Mississippi | 28149 | 8320 | 182 |
2117122 | 2117122 | 2022-01-15 | Warren | Mississippi | 28149 | 8320 | 182 |
2113871 | 2113871 | 2022-01-14 | Warren | Mississippi | 28149 | 8320 | 182 |
2110619 | 2110619 | 2022-01-13 | Warren | Mississippi | 28149 | 8221 | 181 |
2107368 | 2107368 | 2022-01-12 | Warren | Mississippi | 28149 | 8148 | 181 |
2104117 | 2104117 | 2022-01-11 | Warren | Mississippi | 28149 | 8101 | 181 |
2100866 | 2100866 | 2022-01-10 | Warren | Mississippi | 28149 | 8023 | 181 |
2097615 | 2097615 | 2022-01-09 | Warren | Mississippi | 28149 | 7737 | 181 |
2094363 | 2094363 | 2022-01-08 | Warren | Mississippi | 28149 | 7737 | 181 |
2091111 | 2091111 | 2022-01-07 | Warren | Mississippi | 28149 | 7737 | 181 |
2087860 | 2087860 | 2022-01-06 | Warren | Mississippi | 28149 | 7655 | 181 |
2084608 | 2084608 | 2022-01-05 | Warren | Mississippi | 28149 | 7599 | 181 |
2081356 | 2081356 | 2022-01-04 | Warren | Mississippi | 28149 | 7544 | 181 |
2078104 | 2078104 | 2022-01-03 | Warren | Mississippi | 28149 | 7493 | 180 |
2074853 | 2074853 | 2022-01-02 | Warren | Mississippi | 28149 | 7174 | 180 |
2071602 | 2071602 | 2022-01-01 | Warren | Mississippi | 28149 | 7174 | 180 |
2068351 | 2068351 | 2021-12-31 | Warren | Mississippi | 28149 | 7174 | 180 |
2065100 | 2065100 | 2021-12-30 | Warren | Mississippi | 28149 | 7174 | 180 |
2061850 | 2061850 | 2021-12-29 | Warren | Mississippi | 28149 | 7127 | 180 |
2058601 | 2058601 | 2021-12-28 | Warren | Mississippi | 28149 | 7097 | 180 |
2055352 | 2055352 | 2021-12-27 | Warren | Mississippi | 28149 | 7074 | 180 |
2052102 | 2052102 | 2021-12-26 | Warren | Mississippi | 28149 | 7000 | 180 |
2048852 | 2048852 | 2021-12-25 | Warren | Mississippi | 28149 | 7000 | 180 |
2045602 | 2045602 | 2021-12-24 | Warren | Mississippi | 28149 | 7000 | 180 |
2042352 | 2042352 | 2021-12-23 | Warren | Mississippi | 28149 | 7000 | 180 |
2039103 | 2039103 | 2021-12-22 | Warren | Mississippi | 28149 | 7000 | 180 |
2035853 | 2035853 | 2021-12-21 | Warren | Mississippi | 28149 | 6996 | 180 |
2032603 | 2032603 | 2021-12-20 | Warren | Mississippi | 28149 | 6988 | 179 |
2029352 | 2029352 | 2021-12-19 | Warren | Mississippi | 28149 | 6983 | 179 |
2026101 | 2026101 | 2021-12-18 | Warren | Mississippi | 28149 | 6983 | 179 |
2022850 | 2022850 | 2021-12-17 | Warren | Mississippi | 28149 | 6983 | 179 |
2019599 | 2019599 | 2021-12-16 | Warren | Mississippi | 28149 | 6968 | 179 |
2016349 | 2016349 | 2021-12-15 | Warren | Mississippi | 28149 | 6962 | 179 |
2013098 | 2013098 | 2021-12-14 | Warren | Mississippi | 28149 | 6951 | 179 |
2009847 | 2009847 | 2021-12-13 | Warren | Mississippi | 28149 | 6949 | 179 |
2006596 | 2006596 | 2021-12-12 | Warren | Mississippi | 28149 | 6942 | 179 |
2003345 | 2003345 | 2021-12-11 | Warren | Mississippi | 28149 | 6942 | 179 |
2000095 | 2000095 | 2021-12-10 | Warren | Mississippi | 28149 | 6942 | 179 |
1996844 | 1996844 | 2021-12-09 | Warren | Mississippi | 28149 | 6940 | 179 |
1993593 | 1993593 | 2021-12-08 | Warren | Mississippi | 28149 | 6923 | 179 |
1990342 | 1990342 | 2021-12-07 | Warren | Mississippi | 28149 | 6915 | 179 |
1987092 | 1987092 | 2021-12-06 | Warren | Mississippi | 28149 | 6892 | 178 |
1983842 | 1983842 | 2021-12-05 | Warren | Mississippi | 28149 | 6885 | 178 |
1980592 | 1980592 | 2021-12-04 | Warren | Mississippi | 28149 | 6885 | 178 |
1977342 | 1977342 | 2021-12-03 | Warren | Mississippi | 28149 | 6885 | 178 |
1974092 | 1974092 | 2021-12-02 | Warren | Mississippi | 28149 | 6883 | 178 |
1970843 | 1970843 | 2021-12-01 | Warren | Mississippi | 28149 | 6875 | 178 |
1967593 | 1967593 | 2021-11-30 | Warren | Mississippi | 28149 | 6872 | 178 |
1964341 | 1964341 | 2021-11-29 | Warren | Mississippi | 28149 | 6863 | 178 |
1961090 | 1961090 | 2021-11-28 | Warren | Mississippi | 28149 | 6849 | 178 |
1957839 | 1957839 | 2021-11-27 | Warren | Mississippi | 28149 | 6849 | 178 |
1954588 | 1954588 | 2021-11-26 | Warren | Mississippi | 28149 | 6849 | 178 |
1951337 | 1951337 | 2021-11-25 | Warren | Mississippi | 28149 | 6849 | 178 |
1948086 | 1948086 | 2021-11-24 | Warren | Mississippi | 28149 | 6849 | 178 |
1944835 | 1944835 | 2021-11-23 | Warren | Mississippi | 28149 | 6846 | 178 |
1941584 | 1941584 | 2021-11-22 | Warren | Mississippi | 28149 | 6845 | 178 |
1938334 | 1938334 | 2021-11-21 | Warren | Mississippi | 28149 | 6831 | 178 |
1935084 | 1935084 | 2021-11-20 | Warren | Mississippi | 28149 | 6831 | 178 |
1931834 | 1931834 | 2021-11-19 | Warren | Mississippi | 28149 | 6831 | 178 |
1928583 | 1928583 | 2021-11-18 | Warren | Mississippi | 28149 | 6829 | 177 |
1925333 | 1925333 | 2021-11-17 | Warren | Mississippi | 28149 | 6825 | 177 |
1922084 | 1922084 | 2021-11-16 | Warren | Mississippi | 28149 | 6822 | 177 |
1918834 | 1918834 | 2021-11-15 | Warren | Mississippi | 28149 | 6819 | 177 |
1915584 | 1915584 | 2021-11-14 | Warren | Mississippi | 28149 | 6809 | 176 |
1912334 | 1912334 | 2021-11-13 | Warren | Mississippi | 28149 | 6809 | 176 |
1909084 | 1909084 | 2021-11-12 | Warren | Mississippi | 28149 | 6809 | 176 |
1905835 | 1905835 | 2021-11-11 | Warren | Mississippi | 28149 | 6801 | 176 |
1902586 | 1902586 | 2021-11-10 | Warren | Mississippi | 28149 | 6801 | 176 |
1899336 | 1899336 | 2021-11-09 | Warren | Mississippi | 28149 | 6800 | 176 |
1896086 | 1896086 | 2021-11-08 | Warren | Mississippi | 28149 | 6796 | 176 |
1892836 | 1892836 | 2021-11-07 | Warren | Mississippi | 28149 | 6789 | 176 |
1889586 | 1889586 | 2021-11-06 | Warren | Mississippi | 28149 | 6789 | 176 |
1886336 | 1886336 | 2021-11-05 | Warren | Mississippi | 28149 | 6789 | 176 |
1883087 | 1883087 | 2021-11-04 | Warren | Mississippi | 28149 | 6782 | 176 |
1879838 | 1879838 | 2021-11-03 | Warren | Mississippi | 28149 | 6781 | 176 |
1876589 | 1876589 | 2021-11-02 | Warren | Mississippi | 28149 | 6767 | 176 |
1873340 | 1873340 | 2021-11-01 | Warren | Mississippi | 28149 | 6762 | 176 |
1870091 | 1870091 | 2021-10-31 | Warren | Mississippi | 28149 | 6757 | 176 |
1866842 | 1866842 | 2021-10-30 | Warren | Mississippi | 28149 | 6757 | 176 |
1863593 | 1863593 | 2021-10-29 | Warren | Mississippi | 28149 | 6757 | 176 |
1860344 | 1860344 | 2021-10-28 | Warren | Mississippi | 28149 | 6757 | 176 |
1857095 | 1857095 | 2021-10-27 | Warren | Mississippi | 28149 | 6754 | 176 |
1853846 | 1853846 | 2021-10-26 | Warren | Mississippi | 28149 | 6752 | 176 |
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);