ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where county = "Franklin" and fips = 48159 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176902 | 2176902 | 2022-02-02 | Franklin | Texas | 48159 | 1983 | 37 |
2173648 | 2173648 | 2022-02-01 | Franklin | Texas | 48159 | 1963 | 37 |
2170396 | 2170396 | 2022-01-31 | Franklin | Texas | 48159 | 1959 | 37 |
2167142 | 2167142 | 2022-01-30 | Franklin | Texas | 48159 | 1954 | 37 |
2163887 | 2163887 | 2022-01-29 | Franklin | Texas | 48159 | 1949 | 37 |
2160632 | 2160632 | 2022-01-28 | Franklin | Texas | 48159 | 1915 | 37 |
2157376 | 2157376 | 2022-01-27 | Franklin | Texas | 48159 | 1898 | 37 |
2154123 | 2154123 | 2022-01-26 | Franklin | Texas | 48159 | 1888 | 37 |
2150871 | 2150871 | 2022-01-25 | Franklin | Texas | 48159 | 1882 | 37 |
2147619 | 2147619 | 2022-01-24 | Franklin | Texas | 48159 | 1872 | 37 |
2144365 | 2144365 | 2022-01-23 | Franklin | Texas | 48159 | 1859 | 37 |
2141110 | 2141110 | 2022-01-22 | Franklin | Texas | 48159 | 1854 | 37 |
2137854 | 2137854 | 2022-01-21 | Franklin | Texas | 48159 | 1849 | 37 |
2134600 | 2134600 | 2022-01-20 | Franklin | Texas | 48159 | 1820 | 37 |
2131348 | 2131348 | 2022-01-19 | Franklin | Texas | 48159 | 1794 | 37 |
2128094 | 2128094 | 2022-01-18 | Franklin | Texas | 48159 | 1780 | 37 |
2124842 | 2124842 | 2022-01-17 | Franklin | Texas | 48159 | 1763 | 37 |
2121590 | 2121590 | 2022-01-16 | Franklin | Texas | 48159 | 1753 | 37 |
2118338 | 2118338 | 2022-01-15 | Franklin | Texas | 48159 | 1750 | 37 |
2115087 | 2115087 | 2022-01-14 | Franklin | Texas | 48159 | 1727 | 37 |
2111835 | 2111835 | 2022-01-13 | Franklin | Texas | 48159 | 1606 | 37 |
2108583 | 2108583 | 2022-01-12 | Franklin | Texas | 48159 | 1592 | 37 |
2105332 | 2105332 | 2022-01-11 | Franklin | Texas | 48159 | 1563 | 37 |
2102081 | 2102081 | 2022-01-10 | Franklin | Texas | 48159 | 1550 | 37 |
2098830 | 2098830 | 2022-01-09 | Franklin | Texas | 48159 | 1538 | 37 |
2095578 | 2095578 | 2022-01-08 | Franklin | Texas | 48159 | 1533 | 37 |
2092326 | 2092326 | 2022-01-07 | Franklin | Texas | 48159 | 1524 | 37 |
2089074 | 2089074 | 2022-01-06 | Franklin | Texas | 48159 | 1511 | 37 |
2085823 | 2085823 | 2022-01-05 | Franklin | Texas | 48159 | 1502 | 37 |
2082571 | 2082571 | 2022-01-04 | Franklin | Texas | 48159 | 1498 | 37 |
2079319 | 2079319 | 2022-01-03 | Franklin | Texas | 48159 | 1488 | 37 |
2076068 | 2076068 | 2022-01-02 | Franklin | Texas | 48159 | 1460 | 37 |
2072817 | 2072817 | 2022-01-01 | Franklin | Texas | 48159 | 1460 | 37 |
2069566 | 2069566 | 2021-12-31 | Franklin | Texas | 48159 | 1460 | 37 |
2066315 | 2066315 | 2021-12-30 | Franklin | Texas | 48159 | 1460 | 37 |
2063065 | 2063065 | 2021-12-29 | Franklin | Texas | 48159 | 1457 | 37 |
2059815 | 2059815 | 2021-12-28 | Franklin | Texas | 48159 | 1454 | 37 |
2056566 | 2056566 | 2021-12-27 | Franklin | Texas | 48159 | 1449 | 37 |
2053317 | 2053317 | 2021-12-26 | Franklin | Texas | 48159 | 1443 | 37 |
2050067 | 2050067 | 2021-12-25 | Franklin | Texas | 48159 | 1443 | 37 |
2046817 | 2046817 | 2021-12-24 | Franklin | Texas | 48159 | 1443 | 37 |
2043567 | 2043567 | 2021-12-23 | Franklin | Texas | 48159 | 1443 | 37 |
2040318 | 2040318 | 2021-12-22 | Franklin | Texas | 48159 | 1441 | 37 |
2037068 | 2037068 | 2021-12-21 | Franklin | Texas | 48159 | 1440 | 37 |
2033818 | 2033818 | 2021-12-20 | Franklin | Texas | 48159 | 1418 | 37 |
2030568 | 2030568 | 2021-12-19 | Franklin | Texas | 48159 | 1417 | 37 |
2027317 | 2027317 | 2021-12-18 | Franklin | Texas | 48159 | 1417 | 37 |
2024066 | 2024066 | 2021-12-17 | Franklin | Texas | 48159 | 1414 | 37 |
2020815 | 2020815 | 2021-12-16 | Franklin | Texas | 48159 | 1410 | 37 |
2017564 | 2017564 | 2021-12-15 | Franklin | Texas | 48159 | 1398 | 37 |
2014314 | 2014314 | 2021-12-14 | Franklin | Texas | 48159 | 1391 | 37 |
2011063 | 2011063 | 2021-12-13 | Franklin | Texas | 48159 | 1390 | 37 |
2007812 | 2007812 | 2021-12-12 | Franklin | Texas | 48159 | 1389 | 37 |
2004561 | 2004561 | 2021-12-11 | Franklin | Texas | 48159 | 1389 | 37 |
2001310 | 2001310 | 2021-12-10 | Franklin | Texas | 48159 | 1383 | 37 |
1998060 | 1998060 | 2021-12-09 | Franklin | Texas | 48159 | 1373 | 37 |
1994809 | 1994809 | 2021-12-08 | Franklin | Texas | 48159 | 1370 | 37 |
1991558 | 1991558 | 2021-12-07 | Franklin | Texas | 48159 | 1366 | 37 |
1988307 | 1988307 | 2021-12-06 | Franklin | Texas | 48159 | 1366 | 37 |
1985057 | 1985057 | 2021-12-05 | Franklin | Texas | 48159 | 1366 | 37 |
1981807 | 1981807 | 2021-12-04 | Franklin | Texas | 48159 | 1366 | 37 |
1978557 | 1978557 | 2021-12-03 | Franklin | Texas | 48159 | 1366 | 37 |
1975307 | 1975307 | 2021-12-02 | Franklin | Texas | 48159 | 1365 | 37 |
1972058 | 1972058 | 2021-12-01 | Franklin | Texas | 48159 | 1363 | 37 |
1968808 | 1968808 | 2021-11-30 | Franklin | Texas | 48159 | 1363 | 37 |
1965557 | 1965557 | 2021-11-29 | Franklin | Texas | 48159 | 1360 | 37 |
1962305 | 1962305 | 2021-11-28 | Franklin | Texas | 48159 | 1360 | 37 |
1959054 | 1959054 | 2021-11-27 | Franklin | Texas | 48159 | 1360 | 37 |
1955803 | 1955803 | 2021-11-26 | Franklin | Texas | 48159 | 1360 | 37 |
1952552 | 1952552 | 2021-11-25 | Franklin | Texas | 48159 | 1360 | 37 |
1949301 | 1949301 | 2021-11-24 | Franklin | Texas | 48159 | 1360 | 37 |
1946050 | 1946050 | 2021-11-23 | Franklin | Texas | 48159 | 1354 | 37 |
1942799 | 1942799 | 2021-11-22 | Franklin | Texas | 48159 | 1351 | 37 |
1939549 | 1939549 | 2021-11-21 | Franklin | Texas | 48159 | 1351 | 37 |
1936299 | 1936299 | 2021-11-20 | Franklin | Texas | 48159 | 1351 | 37 |
1933049 | 1933049 | 2021-11-19 | Franklin | Texas | 48159 | 1350 | 37 |
1929798 | 1929798 | 2021-11-18 | Franklin | Texas | 48159 | 1350 | 37 |
1926548 | 1926548 | 2021-11-17 | Franklin | Texas | 48159 | 1350 | 37 |
1923298 | 1923298 | 2021-11-16 | Franklin | Texas | 48159 | 1350 | 37 |
1920049 | 1920049 | 2021-11-15 | Franklin | Texas | 48159 | 1350 | 37 |
1916799 | 1916799 | 2021-11-14 | Franklin | Texas | 48159 | 1350 | 37 |
1913549 | 1913549 | 2021-11-13 | Franklin | Texas | 48159 | 1350 | 37 |
1910299 | 1910299 | 2021-11-12 | Franklin | Texas | 48159 | 1349 | 37 |
1907050 | 1907050 | 2021-11-11 | Franklin | Texas | 48159 | 1349 | 37 |
1903801 | 1903801 | 2021-11-10 | Franklin | Texas | 48159 | 1345 | 36 |
1900551 | 1900551 | 2021-11-09 | Franklin | Texas | 48159 | 1345 | 36 |
1897301 | 1897301 | 2021-11-08 | Franklin | Texas | 48159 | 1345 | 36 |
1894051 | 1894051 | 2021-11-07 | Franklin | Texas | 48159 | 1345 | 36 |
1890801 | 1890801 | 2021-11-06 | Franklin | Texas | 48159 | 1345 | 36 |
1887551 | 1887551 | 2021-11-05 | Franklin | Texas | 48159 | 1344 | 35 |
1884301 | 1884301 | 2021-11-04 | Franklin | Texas | 48159 | 1344 | 35 |
1881052 | 1881052 | 2021-11-03 | Franklin | Texas | 48159 | 1342 | 35 |
1877803 | 1877803 | 2021-11-02 | Franklin | Texas | 48159 | 1342 | 35 |
1874554 | 1874554 | 2021-11-01 | Franklin | Texas | 48159 | 1342 | 35 |
1871305 | 1871305 | 2021-10-31 | Franklin | Texas | 48159 | 1342 | 35 |
1868056 | 1868056 | 2021-10-30 | Franklin | Texas | 48159 | 1342 | 35 |
1864807 | 1864807 | 2021-10-29 | Franklin | Texas | 48159 | 1336 | 35 |
1861558 | 1861558 | 2021-10-28 | Franklin | Texas | 48159 | 1335 | 35 |
1858309 | 1858309 | 2021-10-27 | Franklin | Texas | 48159 | 1331 | 35 |
1855060 | 1855060 | 2021-10-26 | Franklin | Texas | 48159 | 1330 | 35 |
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);