ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Lawrence" and state = "South Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1949099 | 1949099 | 2021-11-24 | Lawrence | South Dakota | 46081 | 4658 | 65 |
1945848 | 1945848 | 2021-11-23 | Lawrence | South Dakota | 46081 | 4642 | 65 |
1942597 | 1942597 | 2021-11-22 | Lawrence | South Dakota | 46081 | 4621 | 65 |
1939347 | 1939347 | 2021-11-21 | Lawrence | South Dakota | 46081 | 4606 | 65 |
1936097 | 1936097 | 2021-11-20 | Lawrence | South Dakota | 46081 | 4606 | 65 |
1932847 | 1932847 | 2021-11-19 | Lawrence | South Dakota | 46081 | 4606 | 65 |
1929596 | 1929596 | 2021-11-18 | Lawrence | South Dakota | 46081 | 4598 | 65 |
1926346 | 1926346 | 2021-11-17 | Lawrence | South Dakota | 46081 | 4584 | 65 |
1923096 | 1923096 | 2021-11-16 | Lawrence | South Dakota | 46081 | 4573 | 65 |
1919847 | 1919847 | 2021-11-15 | Lawrence | South Dakota | 46081 | 4536 | 65 |
1916597 | 1916597 | 2021-11-14 | Lawrence | South Dakota | 46081 | 4509 | 64 |
1913347 | 1913347 | 2021-11-13 | Lawrence | South Dakota | 46081 | 4509 | 64 |
1910097 | 1910097 | 2021-11-12 | Lawrence | South Dakota | 46081 | 4509 | 64 |
1906848 | 1906848 | 2021-11-11 | Lawrence | South Dakota | 46081 | 4494 | 64 |
1903599 | 1903599 | 2021-11-10 | Lawrence | South Dakota | 46081 | 4494 | 64 |
1900349 | 1900349 | 2021-11-09 | Lawrence | South Dakota | 46081 | 4478 | 64 |
1897099 | 1897099 | 2021-11-08 | Lawrence | South Dakota | 46081 | 4453 | 64 |
1893849 | 1893849 | 2021-11-07 | Lawrence | South Dakota | 46081 | 4436 | 64 |
1890599 | 1890599 | 2021-11-06 | Lawrence | South Dakota | 46081 | 4436 | 64 |
1887349 | 1887349 | 2021-11-05 | Lawrence | South Dakota | 46081 | 4436 | 64 |
1884099 | 1884099 | 2021-11-04 | Lawrence | South Dakota | 46081 | 4420 | 64 |
1880850 | 1880850 | 2021-11-03 | Lawrence | South Dakota | 46081 | 4404 | 61 |
1877601 | 1877601 | 2021-11-02 | Lawrence | South Dakota | 46081 | 4390 | 60 |
1874352 | 1874352 | 2021-11-01 | Lawrence | South Dakota | 46081 | 4368 | 60 |
1871103 | 1871103 | 2021-10-31 | Lawrence | South Dakota | 46081 | 4358 | 59 |
1867854 | 1867854 | 2021-10-30 | Lawrence | South Dakota | 46081 | 4358 | 59 |
1864605 | 1864605 | 2021-10-29 | Lawrence | South Dakota | 46081 | 4358 | 59 |
1861356 | 1861356 | 2021-10-28 | Lawrence | South Dakota | 46081 | 4347 | 59 |
1858107 | 1858107 | 2021-10-27 | Lawrence | South Dakota | 46081 | 4333 | 59 |
1854858 | 1854858 | 2021-10-26 | Lawrence | South Dakota | 46081 | 4317 | 59 |
1851609 | 1851609 | 2021-10-25 | Lawrence | South Dakota | 46081 | 4291 | 59 |
1848359 | 1848359 | 2021-10-24 | Lawrence | South Dakota | 46081 | 4283 | 59 |
1845109 | 1845109 | 2021-10-23 | Lawrence | South Dakota | 46081 | 4283 | 59 |
1841859 | 1841859 | 2021-10-22 | Lawrence | South Dakota | 46081 | 4283 | 59 |
1838610 | 1838610 | 2021-10-21 | Lawrence | South Dakota | 46081 | 4275 | 59 |
1835361 | 1835361 | 2021-10-20 | Lawrence | South Dakota | 46081 | 4273 | 58 |
1832112 | 1832112 | 2021-10-19 | Lawrence | South Dakota | 46081 | 4255 | 58 |
1828863 | 1828863 | 2021-10-18 | Lawrence | South Dakota | 46081 | 4232 | 58 |
1825614 | 1825614 | 2021-10-17 | Lawrence | South Dakota | 46081 | 4223 | 56 |
1822365 | 1822365 | 2021-10-16 | Lawrence | South Dakota | 46081 | 4223 | 56 |
1819116 | 1819116 | 2021-10-15 | Lawrence | South Dakota | 46081 | 4223 | 56 |
1815867 | 1815867 | 2021-10-14 | Lawrence | South Dakota | 46081 | 4221 | 56 |
1812619 | 1812619 | 2021-10-13 | Lawrence | South Dakota | 46081 | 4210 | 55 |
1809370 | 1809370 | 2021-10-12 | Lawrence | South Dakota | 46081 | 4175 | 55 |
1806120 | 1806120 | 2021-10-11 | Lawrence | South Dakota | 46081 | 4163 | 55 |
1802870 | 1802870 | 2021-10-10 | Lawrence | South Dakota | 46081 | 4163 | 55 |
1799621 | 1799621 | 2021-10-09 | Lawrence | South Dakota | 46081 | 4163 | 55 |
1796372 | 1796372 | 2021-10-08 | Lawrence | South Dakota | 46081 | 4163 | 55 |
1793123 | 1793123 | 2021-10-07 | Lawrence | South Dakota | 46081 | 4154 | 55 |
1789874 | 1789874 | 2021-10-06 | Lawrence | South Dakota | 46081 | 4135 | 54 |
1786626 | 1786626 | 2021-10-05 | Lawrence | South Dakota | 46081 | 4120 | 54 |
1783377 | 1783377 | 2021-10-04 | Lawrence | South Dakota | 46081 | 4097 | 55 |
1780128 | 1780128 | 2021-10-03 | Lawrence | South Dakota | 46081 | 4083 | 54 |
1776878 | 1776878 | 2021-10-02 | Lawrence | South Dakota | 46081 | 4083 | 54 |
1773628 | 1773628 | 2021-10-01 | Lawrence | South Dakota | 46081 | 4083 | 54 |
1770378 | 1770378 | 2021-09-30 | Lawrence | South Dakota | 46081 | 4070 | 54 |
1767129 | 1767129 | 2021-09-29 | Lawrence | South Dakota | 46081 | 4049 | 53 |
1763880 | 1763880 | 2021-09-28 | Lawrence | South Dakota | 46081 | 4012 | 53 |
1760631 | 1760631 | 2021-09-27 | Lawrence | South Dakota | 46081 | 3988 | 53 |
1757383 | 1757383 | 2021-09-26 | Lawrence | South Dakota | 46081 | 3982 | 52 |
1754135 | 1754135 | 2021-09-25 | Lawrence | South Dakota | 46081 | 3982 | 52 |
1750887 | 1750887 | 2021-09-24 | Lawrence | South Dakota | 46081 | 3982 | 52 |
1747638 | 1747638 | 2021-09-23 | Lawrence | South Dakota | 46081 | 3966 | 52 |
1744388 | 1744388 | 2021-09-22 | Lawrence | South Dakota | 46081 | 3937 | 52 |
1741139 | 1741139 | 2021-09-21 | Lawrence | South Dakota | 46081 | 3914 | 52 |
1737890 | 1737890 | 2021-09-20 | Lawrence | South Dakota | 46081 | 3888 | 52 |
1734640 | 1734640 | 2021-09-19 | Lawrence | South Dakota | 46081 | 3869 | 52 |
1731390 | 1731390 | 2021-09-18 | Lawrence | South Dakota | 46081 | 3869 | 52 |
1728140 | 1728140 | 2021-09-17 | Lawrence | South Dakota | 46081 | 3869 | 52 |
1724891 | 1724891 | 2021-09-16 | Lawrence | South Dakota | 46081 | 3850 | 52 |
1721642 | 1721642 | 2021-09-15 | Lawrence | South Dakota | 46081 | 3825 | 52 |
1718394 | 1718394 | 2021-09-14 | Lawrence | South Dakota | 46081 | 3802 | 52 |
1715146 | 1715146 | 2021-09-13 | Lawrence | South Dakota | 46081 | 3761 | 52 |
1711900 | 1711900 | 2021-09-12 | Lawrence | South Dakota | 46081 | 3733 | 51 |
1708653 | 1708653 | 2021-09-11 | Lawrence | South Dakota | 46081 | 3733 | 51 |
1705406 | 1705406 | 2021-09-10 | Lawrence | South Dakota | 46081 | 3733 | 51 |
1702156 | 1702156 | 2021-09-09 | Lawrence | South Dakota | 46081 | 3708 | 51 |
1698907 | 1698907 | 2021-09-08 | Lawrence | South Dakota | 46081 | 3671 | 51 |
1695659 | 1695659 | 2021-09-07 | Lawrence | South Dakota | 46081 | 3598 | 50 |
1692411 | 1692411 | 2021-09-06 | Lawrence | South Dakota | 46081 | 3576 | 50 |
1689162 | 1689162 | 2021-09-05 | Lawrence | South Dakota | 46081 | 3576 | 50 |
1685912 | 1685912 | 2021-09-04 | Lawrence | South Dakota | 46081 | 3576 | 50 |
1682661 | 1682661 | 2021-09-03 | Lawrence | South Dakota | 46081 | 3576 | 50 |
1679411 | 1679411 | 2021-09-02 | Lawrence | South Dakota | 46081 | 3542 | 50 |
1676163 | 1676163 | 2021-09-01 | Lawrence | South Dakota | 46081 | 3505 | 50 |
1672916 | 1672916 | 2021-08-31 | Lawrence | South Dakota | 46081 | 3467 | 50 |
1669668 | 1669668 | 2021-08-30 | Lawrence | South Dakota | 46081 | 3399 | 50 |
1666421 | 1666421 | 2021-08-29 | Lawrence | South Dakota | 46081 | 3371 | 50 |
1663173 | 1663173 | 2021-08-28 | Lawrence | South Dakota | 46081 | 3371 | 50 |
1659925 | 1659925 | 2021-08-27 | Lawrence | South Dakota | 46081 | 3371 | 50 |
1656676 | 1656676 | 2021-08-26 | Lawrence | South Dakota | 46081 | 3335 | 50 |
1653429 | 1653429 | 2021-08-25 | Lawrence | South Dakota | 46081 | 3312 | 50 |
1650182 | 1650182 | 2021-08-24 | Lawrence | South Dakota | 46081 | 3285 | 50 |
1646933 | 1646933 | 2021-08-23 | Lawrence | South Dakota | 46081 | 3220 | 50 |
1643684 | 1643684 | 2021-08-22 | Lawrence | South Dakota | 46081 | 3189 | 50 |
1640434 | 1640434 | 2021-08-21 | Lawrence | South Dakota | 46081 | 3189 | 50 |
1637184 | 1637184 | 2021-08-20 | Lawrence | South Dakota | 46081 | 3189 | 50 |
1633934 | 1633934 | 2021-08-19 | Lawrence | South Dakota | 46081 | 3179 | 50 |
1630687 | 1630687 | 2021-08-18 | Lawrence | South Dakota | 46081 | 3164 | 50 |
1627440 | 1627440 | 2021-08-17 | Lawrence | South Dakota | 46081 | 3123 | 50 |
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);