ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Lee" and fips = 45061 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1767074 | 1767074 | 2021-09-29 | Lee | South Carolina | 45061 | 2421 | 68 |
1763825 | 1763825 | 2021-09-28 | Lee | South Carolina | 45061 | 2415 | 68 |
1760576 | 1760576 | 2021-09-27 | Lee | South Carolina | 45061 | 2408 | 68 |
1757328 | 1757328 | 2021-09-26 | Lee | South Carolina | 45061 | 2391 | 68 |
1754080 | 1754080 | 2021-09-25 | Lee | South Carolina | 45061 | 2391 | 68 |
1750832 | 1750832 | 2021-09-24 | Lee | South Carolina | 45061 | 2391 | 68 |
1747583 | 1747583 | 2021-09-23 | Lee | South Carolina | 45061 | 2381 | 68 |
1744333 | 1744333 | 2021-09-22 | Lee | South Carolina | 45061 | 2373 | 68 |
1741084 | 1741084 | 2021-09-21 | Lee | South Carolina | 45061 | 2370 | 68 |
1737835 | 1737835 | 2021-09-20 | Lee | South Carolina | 45061 | 2366 | 68 |
1734585 | 1734585 | 2021-09-19 | Lee | South Carolina | 45061 | 2330 | 68 |
1731335 | 1731335 | 2021-09-18 | Lee | South Carolina | 45061 | 2330 | 68 |
1728085 | 1728085 | 2021-09-17 | Lee | South Carolina | 45061 | 2330 | 68 |
1724836 | 1724836 | 2021-09-16 | Lee | South Carolina | 45061 | 2323 | 68 |
1721587 | 1721587 | 2021-09-15 | Lee | South Carolina | 45061 | 2313 | 68 |
1718339 | 1718339 | 2021-09-14 | Lee | South Carolina | 45061 | 2305 | 67 |
1715091 | 1715091 | 2021-09-13 | Lee | South Carolina | 45061 | 2300 | 67 |
1711845 | 1711845 | 2021-09-12 | Lee | South Carolina | 45061 | 2273 | 68 |
1708598 | 1708598 | 2021-09-11 | Lee | South Carolina | 45061 | 2273 | 68 |
1705351 | 1705351 | 2021-09-10 | Lee | South Carolina | 45061 | 2273 | 68 |
1702101 | 1702101 | 2021-09-09 | Lee | South Carolina | 45061 | 2266 | 67 |
1698852 | 1698852 | 2021-09-08 | Lee | South Carolina | 45061 | 2264 | 67 |
1695604 | 1695604 | 2021-09-07 | Lee | South Carolina | 45061 | 2254 | 67 |
1692356 | 1692356 | 2021-09-06 | Lee | South Carolina | 45061 | 2248 | 67 |
1689107 | 1689107 | 2021-09-05 | Lee | South Carolina | 45061 | 2222 | 67 |
1685857 | 1685857 | 2021-09-04 | Lee | South Carolina | 45061 | 2222 | 67 |
1682606 | 1682606 | 2021-09-03 | Lee | South Carolina | 45061 | 2222 | 67 |
1679356 | 1679356 | 2021-09-02 | Lee | South Carolina | 45061 | 2211 | 66 |
1676108 | 1676108 | 2021-09-01 | Lee | South Carolina | 45061 | 2206 | 66 |
1672861 | 1672861 | 2021-08-31 | Lee | South Carolina | 45061 | 2196 | 66 |
1669613 | 1669613 | 2021-08-30 | Lee | South Carolina | 45061 | 2190 | 66 |
1666366 | 1666366 | 2021-08-29 | Lee | South Carolina | 45061 | 2161 | 66 |
1663118 | 1663118 | 2021-08-28 | Lee | South Carolina | 45061 | 2161 | 66 |
1659870 | 1659870 | 2021-08-27 | Lee | South Carolina | 45061 | 2161 | 66 |
1656621 | 1656621 | 2021-08-26 | Lee | South Carolina | 45061 | 2155 | 66 |
1653374 | 1653374 | 2021-08-25 | Lee | South Carolina | 45061 | 2150 | 66 |
1650127 | 1650127 | 2021-08-24 | Lee | South Carolina | 45061 | 2148 | 66 |
1646878 | 1646878 | 2021-08-23 | Lee | South Carolina | 45061 | 2142 | 66 |
1643629 | 1643629 | 2021-08-22 | Lee | South Carolina | 45061 | 2117 | 66 |
1640379 | 1640379 | 2021-08-21 | Lee | South Carolina | 45061 | 2117 | 66 |
1637129 | 1637129 | 2021-08-20 | Lee | South Carolina | 45061 | 2117 | 66 |
1633879 | 1633879 | 2021-08-19 | Lee | South Carolina | 45061 | 2103 | 66 |
1630632 | 1630632 | 2021-08-18 | Lee | South Carolina | 45061 | 2102 | 66 |
1627385 | 1627385 | 2021-08-17 | Lee | South Carolina | 45061 | 2099 | 66 |
1624138 | 1624138 | 2021-08-16 | Lee | South Carolina | 45061 | 2092 | 66 |
1620891 | 1620891 | 2021-08-15 | Lee | South Carolina | 45061 | 2055 | 66 |
1617643 | 1617643 | 2021-08-14 | Lee | South Carolina | 45061 | 2055 | 66 |
1614395 | 1614395 | 2021-08-13 | Lee | South Carolina | 45061 | 2055 | 66 |
1611146 | 1611146 | 2021-08-12 | Lee | South Carolina | 45061 | 2046 | 66 |
1607898 | 1607898 | 2021-08-11 | Lee | South Carolina | 45061 | 2042 | 65 |
1604649 | 1604649 | 2021-08-10 | Lee | South Carolina | 45061 | 2039 | 65 |
1601400 | 1601400 | 2021-08-09 | Lee | South Carolina | 45061 | 2028 | 65 |
1598152 | 1598152 | 2021-08-08 | Lee | South Carolina | 45061 | 2012 | 65 |
1594903 | 1594903 | 2021-08-07 | Lee | South Carolina | 45061 | 2012 | 65 |
1591654 | 1591654 | 2021-08-06 | Lee | South Carolina | 45061 | 2012 | 65 |
1588405 | 1588405 | 2021-08-05 | Lee | South Carolina | 45061 | 2007 | 65 |
1585155 | 1585155 | 2021-08-04 | Lee | South Carolina | 45061 | 2003 | 65 |
1581905 | 1581905 | 2021-08-03 | Lee | South Carolina | 45061 | 2002 | 65 |
1578656 | 1578656 | 2021-08-02 | Lee | South Carolina | 45061 | 1999 | 65 |
1575408 | 1575408 | 2021-08-01 | Lee | South Carolina | 45061 | 1986 | 65 |
1572160 | 1572160 | 2021-07-31 | Lee | South Carolina | 45061 | 1986 | 65 |
1568912 | 1568912 | 2021-07-30 | Lee | South Carolina | 45061 | 1986 | 65 |
1565664 | 1565664 | 2021-07-29 | Lee | South Carolina | 45061 | 1982 | 65 |
1562416 | 1562416 | 2021-07-28 | Lee | South Carolina | 45061 | 1979 | 64 |
1559168 | 1559168 | 2021-07-27 | Lee | South Carolina | 45061 | 1973 | 64 |
1555921 | 1555921 | 2021-07-26 | Lee | South Carolina | 45061 | 1971 | 64 |
1552674 | 1552674 | 2021-07-25 | Lee | South Carolina | 45061 | 1962 | 64 |
1549427 | 1549427 | 2021-07-24 | Lee | South Carolina | 45061 | 1962 | 64 |
1546180 | 1546180 | 2021-07-23 | Lee | South Carolina | 45061 | 1962 | 64 |
1542933 | 1542933 | 2021-07-22 | Lee | South Carolina | 45061 | 1962 | 64 |
1539685 | 1539685 | 2021-07-21 | Lee | South Carolina | 45061 | 1959 | 64 |
1536438 | 1536438 | 2021-07-20 | Lee | South Carolina | 45061 | 1958 | 64 |
1533190 | 1533190 | 2021-07-19 | Lee | South Carolina | 45061 | 1957 | 64 |
1529943 | 1529943 | 2021-07-18 | Lee | South Carolina | 45061 | 1956 | 64 |
1526696 | 1526696 | 2021-07-17 | Lee | South Carolina | 45061 | 1956 | 64 |
1523449 | 1523449 | 2021-07-16 | Lee | South Carolina | 45061 | 1956 | 64 |
1520201 | 1520201 | 2021-07-15 | Lee | South Carolina | 45061 | 1954 | 64 |
1516953 | 1516953 | 2021-07-14 | Lee | South Carolina | 45061 | 1953 | 64 |
1513706 | 1513706 | 2021-07-13 | Lee | South Carolina | 45061 | 1951 | 64 |
1510460 | 1510460 | 2021-07-12 | Lee | South Carolina | 45061 | 1951 | 64 |
1507213 | 1507213 | 2021-07-11 | Lee | South Carolina | 45061 | 1951 | 64 |
1503967 | 1503967 | 2021-07-10 | Lee | South Carolina | 45061 | 1951 | 64 |
1500721 | 1500721 | 2021-07-09 | Lee | South Carolina | 45061 | 1951 | 64 |
1497475 | 1497475 | 2021-07-08 | Lee | South Carolina | 45061 | 1945 | 64 |
1494228 | 1494228 | 2021-07-07 | Lee | South Carolina | 45061 | 1944 | 64 |
1490981 | 1490981 | 2021-07-06 | Lee | South Carolina | 45061 | 1945 | 64 |
1487734 | 1487734 | 2021-07-05 | Lee | South Carolina | 45061 | 1945 | 64 |
1484487 | 1484487 | 2021-07-04 | Lee | South Carolina | 45061 | 1941 | 64 |
1481241 | 1481241 | 2021-07-03 | Lee | South Carolina | 45061 | 1941 | 64 |
1477994 | 1477994 | 2021-07-02 | Lee | South Carolina | 45061 | 1941 | 64 |
1474748 | 1474748 | 2021-07-01 | Lee | South Carolina | 45061 | 1940 | 64 |
1471502 | 1471502 | 2021-06-30 | Lee | South Carolina | 45061 | 1939 | 64 |
1468257 | 1468257 | 2021-06-29 | Lee | South Carolina | 45061 | 1939 | 64 |
1465012 | 1465012 | 2021-06-28 | Lee | South Carolina | 45061 | 1939 | 64 |
1461767 | 1461767 | 2021-06-27 | Lee | South Carolina | 45061 | 1938 | 64 |
1458522 | 1458522 | 2021-06-26 | Lee | South Carolina | 45061 | 1938 | 64 |
1455277 | 1455277 | 2021-06-25 | Lee | South Carolina | 45061 | 1938 | 64 |
1452032 | 1452032 | 2021-06-24 | Lee | South Carolina | 45061 | 1936 | 64 |
1448786 | 1448786 | 2021-06-23 | Lee | South Carolina | 45061 | 1937 | 64 |
1445541 | 1445541 | 2021-06-22 | Lee | South Carolina | 45061 | 1936 | 64 |
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);