ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where fips = 40081 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176389 | 2176389 | 2022-02-02 | Lincoln | Oklahoma | 40081 | 7382 | 119 |
2173135 | 2173135 | 2022-02-01 | Lincoln | Oklahoma | 40081 | 6845 | 119 |
2169883 | 2169883 | 2022-01-31 | Lincoln | Oklahoma | 40081 | 6845 | 119 |
2166628 | 2166628 | 2022-01-30 | Lincoln | Oklahoma | 40081 | 6845 | 119 |
2163373 | 2163373 | 2022-01-29 | Lincoln | Oklahoma | 40081 | 6845 | 119 |
2160118 | 2160118 | 2022-01-28 | Lincoln | Oklahoma | 40081 | 6845 | 119 |
2156863 | 2156863 | 2022-01-27 | Lincoln | Oklahoma | 40081 | 6845 | 119 |
2153610 | 2153610 | 2022-01-26 | Lincoln | Oklahoma | 40081 | 6845 | 119 |
2150358 | 2150358 | 2022-01-25 | Lincoln | Oklahoma | 40081 | 6196 | 119 |
2147106 | 2147106 | 2022-01-24 | Lincoln | Oklahoma | 40081 | 6196 | 119 |
2143852 | 2143852 | 2022-01-23 | Lincoln | Oklahoma | 40081 | 6196 | 119 |
2140597 | 2140597 | 2022-01-22 | Lincoln | Oklahoma | 40081 | 6196 | 119 |
2137341 | 2137341 | 2022-01-21 | Lincoln | Oklahoma | 40081 | 6196 | 119 |
2134087 | 2134087 | 2022-01-20 | Lincoln | Oklahoma | 40081 | 6196 | 119 |
2130835 | 2130835 | 2022-01-19 | Lincoln | Oklahoma | 40081 | 6196 | 119 |
2127581 | 2127581 | 2022-01-18 | Lincoln | Oklahoma | 40081 | 5744 | 119 |
2124329 | 2124329 | 2022-01-17 | Lincoln | Oklahoma | 40081 | 5744 | 119 |
2121077 | 2121077 | 2022-01-16 | Lincoln | Oklahoma | 40081 | 5744 | 119 |
2117825 | 2117825 | 2022-01-15 | Lincoln | Oklahoma | 40081 | 5744 | 119 |
2114574 | 2114574 | 2022-01-14 | Lincoln | Oklahoma | 40081 | 5744 | 119 |
2111322 | 2111322 | 2022-01-13 | Lincoln | Oklahoma | 40081 | 5744 | 119 |
2108070 | 2108070 | 2022-01-12 | Lincoln | Oklahoma | 40081 | 5744 | 119 |
2104819 | 2104819 | 2022-01-11 | Lincoln | Oklahoma | 40081 | 5508 | 119 |
2101568 | 2101568 | 2022-01-10 | Lincoln | Oklahoma | 40081 | 5508 | 119 |
2098317 | 2098317 | 2022-01-09 | Lincoln | Oklahoma | 40081 | 5508 | 119 |
2095065 | 2095065 | 2022-01-08 | Lincoln | Oklahoma | 40081 | 5508 | 119 |
2091813 | 2091813 | 2022-01-07 | Lincoln | Oklahoma | 40081 | 5508 | 119 |
2088561 | 2088561 | 2022-01-06 | Lincoln | Oklahoma | 40081 | 5508 | 119 |
2085310 | 2085310 | 2022-01-05 | Lincoln | Oklahoma | 40081 | 5508 | 119 |
2082058 | 2082058 | 2022-01-04 | Lincoln | Oklahoma | 40081 | 5272 | 118 |
2078806 | 2078806 | 2022-01-03 | Lincoln | Oklahoma | 40081 | 5272 | 118 |
2075555 | 2075555 | 2022-01-02 | Lincoln | Oklahoma | 40081 | 5272 | 118 |
2072304 | 2072304 | 2022-01-01 | Lincoln | Oklahoma | 40081 | 5272 | 118 |
2069053 | 2069053 | 2021-12-31 | Lincoln | Oklahoma | 40081 | 5272 | 118 |
2065802 | 2065802 | 2021-12-30 | Lincoln | Oklahoma | 40081 | 5272 | 118 |
2062552 | 2062552 | 2021-12-29 | Lincoln | Oklahoma | 40081 | 5272 | 118 |
2059302 | 2059302 | 2021-12-28 | Lincoln | Oklahoma | 40081 | 5215 | 118 |
2056053 | 2056053 | 2021-12-27 | Lincoln | Oklahoma | 40081 | 5215 | 118 |
2052804 | 2052804 | 2021-12-26 | Lincoln | Oklahoma | 40081 | 5215 | 118 |
2049554 | 2049554 | 2021-12-25 | Lincoln | Oklahoma | 40081 | 5215 | 118 |
2046304 | 2046304 | 2021-12-24 | Lincoln | Oklahoma | 40081 | 5215 | 118 |
2043054 | 2043054 | 2021-12-23 | Lincoln | Oklahoma | 40081 | 5215 | 118 |
2039805 | 2039805 | 2021-12-22 | Lincoln | Oklahoma | 40081 | 5215 | 118 |
2036555 | 2036555 | 2021-12-21 | Lincoln | Oklahoma | 40081 | 5164 | 117 |
2033305 | 2033305 | 2021-12-20 | Lincoln | Oklahoma | 40081 | 5164 | 117 |
2030055 | 2030055 | 2021-12-19 | Lincoln | Oklahoma | 40081 | 5164 | 117 |
2026804 | 2026804 | 2021-12-18 | Lincoln | Oklahoma | 40081 | 5164 | 117 |
2023553 | 2023553 | 2021-12-17 | Lincoln | Oklahoma | 40081 | 5164 | 117 |
2020302 | 2020302 | 2021-12-16 | Lincoln | Oklahoma | 40081 | 5164 | 117 |
2017051 | 2017051 | 2021-12-15 | Lincoln | Oklahoma | 40081 | 5164 | 117 |
2013801 | 2013801 | 2021-12-14 | Lincoln | Oklahoma | 40081 | 5120 | 117 |
2010550 | 2010550 | 2021-12-13 | Lincoln | Oklahoma | 40081 | 5120 | 117 |
2007299 | 2007299 | 2021-12-12 | Lincoln | Oklahoma | 40081 | 5120 | 117 |
2004048 | 2004048 | 2021-12-11 | Lincoln | Oklahoma | 40081 | 5120 | 117 |
2000797 | 2000797 | 2021-12-10 | Lincoln | Oklahoma | 40081 | 5120 | 117 |
1997547 | 1997547 | 2021-12-09 | Lincoln | Oklahoma | 40081 | 5120 | 117 |
1994296 | 1994296 | 2021-12-08 | Lincoln | Oklahoma | 40081 | 5120 | 117 |
1991045 | 1991045 | 2021-12-07 | Lincoln | Oklahoma | 40081 | 5060 | 116 |
1987794 | 1987794 | 2021-12-06 | Lincoln | Oklahoma | 40081 | 5060 | 116 |
1984544 | 1984544 | 2021-12-05 | Lincoln | Oklahoma | 40081 | 5060 | 116 |
1981294 | 1981294 | 2021-12-04 | Lincoln | Oklahoma | 40081 | 5060 | 116 |
1978044 | 1978044 | 2021-12-03 | Lincoln | Oklahoma | 40081 | 5060 | 116 |
1974794 | 1974794 | 2021-12-02 | Lincoln | Oklahoma | 40081 | 5060 | 112 |
1971545 | 1971545 | 2021-12-01 | Lincoln | Oklahoma | 40081 | 5060 | 112 |
1968295 | 1968295 | 2021-11-30 | Lincoln | Oklahoma | 40081 | 5024 | 112 |
1965044 | 1965044 | 2021-11-29 | Lincoln | Oklahoma | 40081 | 5024 | 112 |
1961792 | 1961792 | 2021-11-28 | Lincoln | Oklahoma | 40081 | 5024 | 112 |
1958541 | 1958541 | 2021-11-27 | Lincoln | Oklahoma | 40081 | 5024 | 112 |
1955290 | 1955290 | 2021-11-26 | Lincoln | Oklahoma | 40081 | 5024 | 112 |
1952039 | 1952039 | 2021-11-25 | Lincoln | Oklahoma | 40081 | 5024 | 112 |
1948788 | 1948788 | 2021-11-24 | Lincoln | Oklahoma | 40081 | 5024 | 112 |
1945537 | 1945537 | 2021-11-23 | Lincoln | Oklahoma | 40081 | 4995 | 112 |
1942286 | 1942286 | 2021-11-22 | Lincoln | Oklahoma | 40081 | 4995 | 112 |
1939036 | 1939036 | 2021-11-21 | Lincoln | Oklahoma | 40081 | 4995 | 112 |
1935786 | 1935786 | 2021-11-20 | Lincoln | Oklahoma | 40081 | 4995 | 112 |
1932536 | 1932536 | 2021-11-19 | Lincoln | Oklahoma | 40081 | 4995 | 112 |
1929285 | 1929285 | 2021-11-18 | Lincoln | Oklahoma | 40081 | 4995 | 112 |
1926035 | 1926035 | 2021-11-17 | Lincoln | Oklahoma | 40081 | 4995 | 112 |
1922785 | 1922785 | 2021-11-16 | Lincoln | Oklahoma | 40081 | 4952 | 112 |
1919536 | 1919536 | 2021-11-15 | Lincoln | Oklahoma | 40081 | 4952 | 112 |
1916286 | 1916286 | 2021-11-14 | Lincoln | Oklahoma | 40081 | 4952 | 112 |
1913036 | 1913036 | 2021-11-13 | Lincoln | Oklahoma | 40081 | 4952 | 112 |
1909786 | 1909786 | 2021-11-12 | Lincoln | Oklahoma | 40081 | 4952 | 112 |
1906537 | 1906537 | 2021-11-11 | Lincoln | Oklahoma | 40081 | 4952 | 112 |
1903288 | 1903288 | 2021-11-10 | Lincoln | Oklahoma | 40081 | 4952 | 112 |
1900038 | 1900038 | 2021-11-09 | Lincoln | Oklahoma | 40081 | 4913 | 112 |
1896788 | 1896788 | 2021-11-08 | Lincoln | Oklahoma | 40081 | 4913 | 112 |
1893538 | 1893538 | 2021-11-07 | Lincoln | Oklahoma | 40081 | 4913 | 112 |
1890288 | 1890288 | 2021-11-06 | Lincoln | Oklahoma | 40081 | 4913 | 112 |
1887038 | 1887038 | 2021-11-05 | Lincoln | Oklahoma | 40081 | 4913 | 112 |
1883788 | 1883788 | 2021-11-04 | Lincoln | Oklahoma | 40081 | 4913 | 112 |
1880539 | 1880539 | 2021-11-03 | Lincoln | Oklahoma | 40081 | 4913 | 112 |
1877290 | 1877290 | 2021-11-02 | Lincoln | Oklahoma | 40081 | 4887 | 110 |
1874041 | 1874041 | 2021-11-01 | Lincoln | Oklahoma | 40081 | 4887 | 110 |
1870792 | 1870792 | 2021-10-31 | Lincoln | Oklahoma | 40081 | 4887 | 110 |
1867543 | 1867543 | 2021-10-30 | Lincoln | Oklahoma | 40081 | 4887 | 110 |
1864294 | 1864294 | 2021-10-29 | Lincoln | Oklahoma | 40081 | 4887 | 110 |
1861045 | 1861045 | 2021-10-28 | Lincoln | Oklahoma | 40081 | 4887 | 110 |
1857796 | 1857796 | 2021-10-27 | Lincoln | Oklahoma | 40081 | 4887 | 110 |
1854547 | 1854547 | 2021-10-26 | Lincoln | Oklahoma | 40081 | 4839 | 107 |
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);