ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Lawrence", fips = 46081 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 |
---|---|---|---|---|---|---|---|
2176700 | 2176700 | 2022-02-02 | Lawrence | South Dakota | 46081 | 6295 | 79 |
2173446 | 2173446 | 2022-02-01 | Lawrence | South Dakota | 46081 | 6258 | 79 |
2170194 | 2170194 | 2022-01-31 | Lawrence | South Dakota | 46081 | 6202 | 79 |
2166940 | 2166940 | 2022-01-30 | Lawrence | South Dakota | 46081 | 6150 | 79 |
2163685 | 2163685 | 2022-01-29 | Lawrence | South Dakota | 46081 | 6150 | 79 |
2160430 | 2160430 | 2022-01-28 | Lawrence | South Dakota | 46081 | 6150 | 79 |
2157174 | 2157174 | 2022-01-27 | Lawrence | South Dakota | 46081 | 6102 | 79 |
2153921 | 2153921 | 2022-01-26 | Lawrence | South Dakota | 46081 | 6066 | 78 |
2150669 | 2150669 | 2022-01-25 | Lawrence | South Dakota | 46081 | 6010 | 77 |
2147417 | 2147417 | 2022-01-24 | Lawrence | South Dakota | 46081 | 5922 | 77 |
2144163 | 2144163 | 2022-01-23 | Lawrence | South Dakota | 46081 | 5863 | 77 |
2140908 | 2140908 | 2022-01-22 | Lawrence | South Dakota | 46081 | 5863 | 77 |
2137652 | 2137652 | 2022-01-21 | Lawrence | South Dakota | 46081 | 5863 | 77 |
2134398 | 2134398 | 2022-01-20 | Lawrence | South Dakota | 46081 | 5800 | 77 |
2131146 | 2131146 | 2022-01-19 | Lawrence | South Dakota | 46081 | 5718 | 77 |
2127892 | 2127892 | 2022-01-18 | Lawrence | South Dakota | 46081 | 5575 | 77 |
2124640 | 2124640 | 2022-01-17 | Lawrence | South Dakota | 46081 | 5494 | 77 |
2121388 | 2121388 | 2022-01-16 | Lawrence | South Dakota | 46081 | 5494 | 77 |
2118136 | 2118136 | 2022-01-15 | Lawrence | South Dakota | 46081 | 5494 | 77 |
2114885 | 2114885 | 2022-01-14 | Lawrence | South Dakota | 46081 | 5494 | 77 |
2111633 | 2111633 | 2022-01-13 | Lawrence | South Dakota | 46081 | 5426 | 77 |
2108381 | 2108381 | 2022-01-12 | Lawrence | South Dakota | 46081 | 5355 | 77 |
2105130 | 2105130 | 2022-01-11 | Lawrence | South Dakota | 46081 | 5295 | 77 |
2101879 | 2101879 | 2022-01-10 | Lawrence | South Dakota | 46081 | 5198 | 77 |
2098628 | 2098628 | 2022-01-09 | Lawrence | South Dakota | 46081 | 5147 | 77 |
2095376 | 2095376 | 2022-01-08 | Lawrence | South Dakota | 46081 | 5147 | 77 |
2092124 | 2092124 | 2022-01-07 | Lawrence | South Dakota | 46081 | 5147 | 77 |
2088872 | 2088872 | 2022-01-06 | Lawrence | South Dakota | 46081 | 5107 | 77 |
2085621 | 2085621 | 2022-01-05 | Lawrence | South Dakota | 46081 | 5053 | 76 |
2082369 | 2082369 | 2022-01-04 | Lawrence | South Dakota | 46081 | 5019 | 76 |
2079117 | 2079117 | 2022-01-03 | Lawrence | South Dakota | 46081 | 4964 | 76 |
2075866 | 2075866 | 2022-01-02 | Lawrence | South Dakota | 46081 | 4942 | 76 |
2072615 | 2072615 | 2022-01-01 | Lawrence | South Dakota | 46081 | 4942 | 76 |
2069364 | 2069364 | 2021-12-31 | Lawrence | South Dakota | 46081 | 4942 | 76 |
2066113 | 2066113 | 2021-12-30 | Lawrence | South Dakota | 46081 | 4942 | 76 |
2062863 | 2062863 | 2021-12-29 | Lawrence | South Dakota | 46081 | 4931 | 75 |
2059613 | 2059613 | 2021-12-28 | Lawrence | South Dakota | 46081 | 4919 | 74 |
2056364 | 2056364 | 2021-12-27 | Lawrence | South Dakota | 46081 | 4903 | 74 |
2053115 | 2053115 | 2021-12-26 | Lawrence | South Dakota | 46081 | 4901 | 73 |
2049865 | 2049865 | 2021-12-25 | Lawrence | South Dakota | 46081 | 4901 | 73 |
2046615 | 2046615 | 2021-12-24 | Lawrence | South Dakota | 46081 | 4901 | 73 |
2043365 | 2043365 | 2021-12-23 | Lawrence | South Dakota | 46081 | 4901 | 73 |
2040116 | 2040116 | 2021-12-22 | Lawrence | South Dakota | 46081 | 4895 | 73 |
2036866 | 2036866 | 2021-12-21 | Lawrence | South Dakota | 46081 | 4887 | 73 |
2033616 | 2033616 | 2021-12-20 | Lawrence | South Dakota | 46081 | 4870 | 73 |
2030366 | 2030366 | 2021-12-19 | Lawrence | South Dakota | 46081 | 4863 | 73 |
2027115 | 2027115 | 2021-12-18 | Lawrence | South Dakota | 46081 | 4863 | 73 |
2023864 | 2023864 | 2021-12-17 | Lawrence | South Dakota | 46081 | 4863 | 73 |
2020613 | 2020613 | 2021-12-16 | Lawrence | South Dakota | 46081 | 4855 | 72 |
2017362 | 2017362 | 2021-12-15 | Lawrence | South Dakota | 46081 | 4844 | 72 |
2014112 | 2014112 | 2021-12-14 | Lawrence | South Dakota | 46081 | 4836 | 72 |
2010861 | 2010861 | 2021-12-13 | Lawrence | South Dakota | 46081 | 4823 | 71 |
2007610 | 2007610 | 2021-12-12 | Lawrence | South Dakota | 46081 | 4810 | 71 |
2004359 | 2004359 | 2021-12-11 | Lawrence | South Dakota | 46081 | 4810 | 71 |
2001108 | 2001108 | 2021-12-10 | Lawrence | South Dakota | 46081 | 4810 | 71 |
1997858 | 1997858 | 2021-12-09 | Lawrence | South Dakota | 46081 | 4803 | 70 |
1994607 | 1994607 | 2021-12-08 | Lawrence | South Dakota | 46081 | 4793 | 69 |
1991356 | 1991356 | 2021-12-07 | Lawrence | South Dakota | 46081 | 4783 | 68 |
1988105 | 1988105 | 2021-12-06 | Lawrence | South Dakota | 46081 | 4757 | 68 |
1984855 | 1984855 | 2021-12-05 | Lawrence | South Dakota | 46081 | 4748 | 68 |
1981605 | 1981605 | 2021-12-04 | Lawrence | South Dakota | 46081 | 4748 | 68 |
1978355 | 1978355 | 2021-12-03 | Lawrence | South Dakota | 46081 | 4748 | 68 |
1975105 | 1975105 | 2021-12-02 | Lawrence | South Dakota | 46081 | 4731 | 68 |
1971856 | 1971856 | 2021-12-01 | Lawrence | South Dakota | 46081 | 4720 | 67 |
1968606 | 1968606 | 2021-11-30 | Lawrence | South Dakota | 46081 | 4705 | 66 |
1965355 | 1965355 | 2021-11-29 | Lawrence | South Dakota | 46081 | 4668 | 65 |
1962103 | 1962103 | 2021-11-28 | Lawrence | South Dakota | 46081 | 4658 | 65 |
1958852 | 1958852 | 2021-11-27 | Lawrence | South Dakota | 46081 | 4658 | 65 |
1955601 | 1955601 | 2021-11-26 | Lawrence | South Dakota | 46081 | 4658 | 65 |
1952350 | 1952350 | 2021-11-25 | Lawrence | South Dakota | 46081 | 4658 | 65 |
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 |
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);