ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Franklin" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175629 | 2175629 | 2022-02-02 | Franklin | Mississippi | 28037 | 1791 | 35 |
2172376 | 2172376 | 2022-02-01 | Franklin | Mississippi | 28037 | 1781 | 34 |
2169123 | 2169123 | 2022-01-31 | Franklin | Mississippi | 28037 | 1774 | 34 |
2165868 | 2165868 | 2022-01-30 | Franklin | Mississippi | 28037 | 1751 | 34 |
2162613 | 2162613 | 2022-01-29 | Franklin | Mississippi | 28037 | 1751 | 34 |
2159358 | 2159358 | 2022-01-28 | Franklin | Mississippi | 28037 | 1751 | 34 |
2156104 | 2156104 | 2022-01-27 | Franklin | Mississippi | 28037 | 1736 | 34 |
2152851 | 2152851 | 2022-01-26 | Franklin | Mississippi | 28037 | 1721 | 34 |
2149599 | 2149599 | 2022-01-25 | Franklin | Mississippi | 28037 | 1705 | 34 |
2146347 | 2146347 | 2022-01-24 | Franklin | Mississippi | 28037 | 1697 | 34 |
2143092 | 2143092 | 2022-01-23 | Franklin | Mississippi | 28037 | 1666 | 34 |
2139837 | 2139837 | 2022-01-22 | Franklin | Mississippi | 28037 | 1666 | 34 |
2136581 | 2136581 | 2022-01-21 | Franklin | Mississippi | 28037 | 1666 | 34 |
2133329 | 2133329 | 2022-01-20 | Franklin | Mississippi | 28037 | 1637 | 34 |
2130076 | 2130076 | 2022-01-19 | Franklin | Mississippi | 28037 | 1606 | 34 |
2126822 | 2126822 | 2022-01-18 | Franklin | Mississippi | 28037 | 1567 | 34 |
2123570 | 2123570 | 2022-01-17 | Franklin | Mississippi | 28037 | 1512 | 34 |
2120318 | 2120318 | 2022-01-16 | Franklin | Mississippi | 28037 | 1512 | 34 |
2117066 | 2117066 | 2022-01-15 | Franklin | Mississippi | 28037 | 1512 | 34 |
2113815 | 2113815 | 2022-01-14 | Franklin | Mississippi | 28037 | 1512 | 34 |
2110563 | 2110563 | 2022-01-13 | Franklin | Mississippi | 28037 | 1497 | 34 |
2107312 | 2107312 | 2022-01-12 | Franklin | Mississippi | 28037 | 1472 | 34 |
2104061 | 2104061 | 2022-01-11 | Franklin | Mississippi | 28037 | 1457 | 34 |
2100810 | 2100810 | 2022-01-10 | Franklin | Mississippi | 28037 | 1426 | 33 |
2097559 | 2097559 | 2022-01-09 | Franklin | Mississippi | 28037 | 1400 | 33 |
2094307 | 2094307 | 2022-01-08 | Franklin | Mississippi | 28037 | 1400 | 33 |
2091055 | 2091055 | 2022-01-07 | Franklin | Mississippi | 28037 | 1400 | 33 |
2087804 | 2087804 | 2022-01-06 | Franklin | Mississippi | 28037 | 1391 | 33 |
2084552 | 2084552 | 2022-01-05 | Franklin | Mississippi | 28037 | 1383 | 33 |
2081300 | 2081300 | 2022-01-04 | Franklin | Mississippi | 28037 | 1363 | 32 |
2078048 | 2078048 | 2022-01-03 | Franklin | Mississippi | 28037 | 1350 | 32 |
2074797 | 2074797 | 2022-01-02 | Franklin | Mississippi | 28037 | 1313 | 32 |
2071546 | 2071546 | 2022-01-01 | Franklin | Mississippi | 28037 | 1313 | 32 |
2068295 | 2068295 | 2021-12-31 | Franklin | Mississippi | 28037 | 1313 | 32 |
2065044 | 2065044 | 2021-12-30 | Franklin | Mississippi | 28037 | 1313 | 32 |
2061794 | 2061794 | 2021-12-29 | Franklin | Mississippi | 28037 | 1306 | 32 |
2058545 | 2058545 | 2021-12-28 | Franklin | Mississippi | 28037 | 1300 | 32 |
2055296 | 2055296 | 2021-12-27 | Franklin | Mississippi | 28037 | 1294 | 32 |
2052046 | 2052046 | 2021-12-26 | Franklin | Mississippi | 28037 | 1286 | 32 |
2048796 | 2048796 | 2021-12-25 | Franklin | Mississippi | 28037 | 1286 | 32 |
2045546 | 2045546 | 2021-12-24 | Franklin | Mississippi | 28037 | 1286 | 32 |
2042296 | 2042296 | 2021-12-23 | Franklin | Mississippi | 28037 | 1286 | 32 |
2039047 | 2039047 | 2021-12-22 | Franklin | Mississippi | 28037 | 1286 | 32 |
2035797 | 2035797 | 2021-12-21 | Franklin | Mississippi | 28037 | 1285 | 32 |
2032547 | 2032547 | 2021-12-20 | Franklin | Mississippi | 28037 | 1283 | 31 |
2029296 | 2029296 | 2021-12-19 | Franklin | Mississippi | 28037 | 1283 | 31 |
2026045 | 2026045 | 2021-12-18 | Franklin | Mississippi | 28037 | 1283 | 31 |
2022794 | 2022794 | 2021-12-17 | Franklin | Mississippi | 28037 | 1283 | 31 |
2019543 | 2019543 | 2021-12-16 | Franklin | Mississippi | 28037 | 1281 | 31 |
2016293 | 2016293 | 2021-12-15 | Franklin | Mississippi | 28037 | 1281 | 31 |
2013042 | 2013042 | 2021-12-14 | Franklin | Mississippi | 28037 | 1278 | 31 |
2009791 | 2009791 | 2021-12-13 | Franklin | Mississippi | 28037 | 1275 | 30 |
2006540 | 2006540 | 2021-12-12 | Franklin | Mississippi | 28037 | 1275 | 30 |
2003289 | 2003289 | 2021-12-11 | Franklin | Mississippi | 28037 | 1275 | 30 |
2000039 | 2000039 | 2021-12-10 | Franklin | Mississippi | 28037 | 1275 | 30 |
1996788 | 1996788 | 2021-12-09 | Franklin | Mississippi | 28037 | 1275 | 30 |
1993537 | 1993537 | 2021-12-08 | Franklin | Mississippi | 28037 | 1273 | 30 |
1990286 | 1990286 | 2021-12-07 | Franklin | Mississippi | 28037 | 1271 | 30 |
1987036 | 1987036 | 2021-12-06 | Franklin | Mississippi | 28037 | 1266 | 30 |
1983786 | 1983786 | 2021-12-05 | Franklin | Mississippi | 28037 | 1265 | 30 |
1980536 | 1980536 | 2021-12-04 | Franklin | Mississippi | 28037 | 1265 | 30 |
1977286 | 1977286 | 2021-12-03 | Franklin | Mississippi | 28037 | 1265 | 30 |
1974036 | 1974036 | 2021-12-02 | Franklin | Mississippi | 28037 | 1264 | 30 |
1970787 | 1970787 | 2021-12-01 | Franklin | Mississippi | 28037 | 1260 | 29 |
1967537 | 1967537 | 2021-11-30 | Franklin | Mississippi | 28037 | 1260 | 29 |
1964285 | 1964285 | 2021-11-29 | Franklin | Mississippi | 28037 | 1255 | 29 |
1961034 | 1961034 | 2021-11-28 | Franklin | Mississippi | 28037 | 1249 | 29 |
1957783 | 1957783 | 2021-11-27 | Franklin | Mississippi | 28037 | 1249 | 29 |
1954532 | 1954532 | 2021-11-26 | Franklin | Mississippi | 28037 | 1249 | 29 |
1951281 | 1951281 | 2021-11-25 | Franklin | Mississippi | 28037 | 1249 | 29 |
1948030 | 1948030 | 2021-11-24 | Franklin | Mississippi | 28037 | 1249 | 29 |
1944779 | 1944779 | 2021-11-23 | Franklin | Mississippi | 28037 | 1248 | 29 |
1941528 | 1941528 | 2021-11-22 | Franklin | Mississippi | 28037 | 1245 | 29 |
1938278 | 1938278 | 2021-11-21 | Franklin | Mississippi | 28037 | 1238 | 29 |
1935028 | 1935028 | 2021-11-20 | Franklin | Mississippi | 28037 | 1238 | 29 |
1931778 | 1931778 | 2021-11-19 | Franklin | Mississippi | 28037 | 1238 | 29 |
1928527 | 1928527 | 2021-11-18 | Franklin | Mississippi | 28037 | 1236 | 29 |
1925277 | 1925277 | 2021-11-17 | Franklin | Mississippi | 28037 | 1234 | 29 |
1922028 | 1922028 | 2021-11-16 | Franklin | Mississippi | 28037 | 1234 | 29 |
1918778 | 1918778 | 2021-11-15 | Franklin | Mississippi | 28037 | 1228 | 29 |
1915528 | 1915528 | 2021-11-14 | Franklin | Mississippi | 28037 | 1227 | 28 |
1912278 | 1912278 | 2021-11-13 | Franklin | Mississippi | 28037 | 1227 | 28 |
1909028 | 1909028 | 2021-11-12 | Franklin | Mississippi | 28037 | 1227 | 28 |
1905779 | 1905779 | 2021-11-11 | Franklin | Mississippi | 28037 | 1225 | 28 |
1902530 | 1902530 | 2021-11-10 | Franklin | Mississippi | 28037 | 1225 | 28 |
1899280 | 1899280 | 2021-11-09 | Franklin | Mississippi | 28037 | 1223 | 28 |
1896030 | 1896030 | 2021-11-08 | Franklin | Mississippi | 28037 | 1222 | 28 |
1892780 | 1892780 | 2021-11-07 | Franklin | Mississippi | 28037 | 1217 | 28 |
1889530 | 1889530 | 2021-11-06 | Franklin | Mississippi | 28037 | 1217 | 28 |
1886280 | 1886280 | 2021-11-05 | Franklin | Mississippi | 28037 | 1217 | 28 |
1883031 | 1883031 | 2021-11-04 | Franklin | Mississippi | 28037 | 1217 | 28 |
1879782 | 1879782 | 2021-11-03 | Franklin | Mississippi | 28037 | 1215 | 28 |
1876533 | 1876533 | 2021-11-02 | Franklin | Mississippi | 28037 | 1215 | 28 |
1873284 | 1873284 | 2021-11-01 | Franklin | Mississippi | 28037 | 1214 | 28 |
1870035 | 1870035 | 2021-10-31 | Franklin | Mississippi | 28037 | 1214 | 28 |
1866786 | 1866786 | 2021-10-30 | Franklin | Mississippi | 28037 | 1214 | 28 |
1863537 | 1863537 | 2021-10-29 | Franklin | Mississippi | 28037 | 1214 | 28 |
1860288 | 1860288 | 2021-10-28 | Franklin | Mississippi | 28037 | 1211 | 28 |
1857039 | 1857039 | 2021-10-27 | Franklin | Mississippi | 28037 | 1208 | 28 |
1853790 | 1853790 | 2021-10-26 | Franklin | Mississippi | 28037 | 1207 | 28 |
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);