ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 40087 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176395 | 2176395 | 2022-02-02 | McClain | Oklahoma | 40087 | 11079 | 115 |
2173141 | 2173141 | 2022-02-01 | McClain | Oklahoma | 40087 | 10440 | 111 |
2169889 | 2169889 | 2022-01-31 | McClain | Oklahoma | 40087 | 10440 | 111 |
2166634 | 2166634 | 2022-01-30 | McClain | Oklahoma | 40087 | 10440 | 111 |
2163379 | 2163379 | 2022-01-29 | McClain | Oklahoma | 40087 | 10440 | 111 |
2160124 | 2160124 | 2022-01-28 | McClain | Oklahoma | 40087 | 10440 | 111 |
2156869 | 2156869 | 2022-01-27 | McClain | Oklahoma | 40087 | 10440 | 111 |
2153616 | 2153616 | 2022-01-26 | McClain | Oklahoma | 40087 | 10440 | 111 |
2150364 | 2150364 | 2022-01-25 | McClain | Oklahoma | 40087 | 9573 | 107 |
2147112 | 2147112 | 2022-01-24 | McClain | Oklahoma | 40087 | 9573 | 107 |
2143858 | 2143858 | 2022-01-23 | McClain | Oklahoma | 40087 | 9573 | 107 |
2140603 | 2140603 | 2022-01-22 | McClain | Oklahoma | 40087 | 9573 | 107 |
2137347 | 2137347 | 2022-01-21 | McClain | Oklahoma | 40087 | 9573 | 107 |
2134093 | 2134093 | 2022-01-20 | McClain | Oklahoma | 40087 | 9573 | 107 |
2130841 | 2130841 | 2022-01-19 | McClain | Oklahoma | 40087 | 9573 | 107 |
2127587 | 2127587 | 2022-01-18 | McClain | Oklahoma | 40087 | 8768 | 106 |
2124335 | 2124335 | 2022-01-17 | McClain | Oklahoma | 40087 | 8768 | 106 |
2121083 | 2121083 | 2022-01-16 | McClain | Oklahoma | 40087 | 8768 | 106 |
2117831 | 2117831 | 2022-01-15 | McClain | Oklahoma | 40087 | 8768 | 106 |
2114580 | 2114580 | 2022-01-14 | McClain | Oklahoma | 40087 | 8768 | 106 |
2111328 | 2111328 | 2022-01-13 | McClain | Oklahoma | 40087 | 8768 | 106 |
2108076 | 2108076 | 2022-01-12 | McClain | Oklahoma | 40087 | 8768 | 106 |
2104825 | 2104825 | 2022-01-11 | McClain | Oklahoma | 40087 | 8230 | 106 |
2101574 | 2101574 | 2022-01-10 | McClain | Oklahoma | 40087 | 8230 | 106 |
2098323 | 2098323 | 2022-01-09 | McClain | Oklahoma | 40087 | 8230 | 106 |
2095071 | 2095071 | 2022-01-08 | McClain | Oklahoma | 40087 | 8230 | 106 |
2091819 | 2091819 | 2022-01-07 | McClain | Oklahoma | 40087 | 8230 | 106 |
2088567 | 2088567 | 2022-01-06 | McClain | Oklahoma | 40087 | 8230 | 106 |
2085316 | 2085316 | 2022-01-05 | McClain | Oklahoma | 40087 | 8230 | 106 |
2082064 | 2082064 | 2022-01-04 | McClain | Oklahoma | 40087 | 8112 | 107 |
2078812 | 2078812 | 2022-01-03 | McClain | Oklahoma | 40087 | 8112 | 107 |
2075561 | 2075561 | 2022-01-02 | McClain | Oklahoma | 40087 | 8112 | 107 |
2072310 | 2072310 | 2022-01-01 | McClain | Oklahoma | 40087 | 8112 | 107 |
2069059 | 2069059 | 2021-12-31 | McClain | Oklahoma | 40087 | 8112 | 107 |
2065808 | 2065808 | 2021-12-30 | McClain | Oklahoma | 40087 | 8112 | 107 |
2062558 | 2062558 | 2021-12-29 | McClain | Oklahoma | 40087 | 8112 | 107 |
2059308 | 2059308 | 2021-12-28 | McClain | Oklahoma | 40087 | 7962 | 107 |
2056059 | 2056059 | 2021-12-27 | McClain | Oklahoma | 40087 | 7962 | 107 |
2052810 | 2052810 | 2021-12-26 | McClain | Oklahoma | 40087 | 7962 | 107 |
2049560 | 2049560 | 2021-12-25 | McClain | Oklahoma | 40087 | 7962 | 107 |
2046310 | 2046310 | 2021-12-24 | McClain | Oklahoma | 40087 | 7962 | 107 |
2043060 | 2043060 | 2021-12-23 | McClain | Oklahoma | 40087 | 7962 | 107 |
2039811 | 2039811 | 2021-12-22 | McClain | Oklahoma | 40087 | 7962 | 107 |
2036561 | 2036561 | 2021-12-21 | McClain | Oklahoma | 40087 | 7855 | 107 |
2033311 | 2033311 | 2021-12-20 | McClain | Oklahoma | 40087 | 7855 | 107 |
2030061 | 2030061 | 2021-12-19 | McClain | Oklahoma | 40087 | 7855 | 107 |
2026810 | 2026810 | 2021-12-18 | McClain | Oklahoma | 40087 | 7855 | 107 |
2023559 | 2023559 | 2021-12-17 | McClain | Oklahoma | 40087 | 7855 | 107 |
2020308 | 2020308 | 2021-12-16 | McClain | Oklahoma | 40087 | 7855 | 107 |
2017057 | 2017057 | 2021-12-15 | McClain | Oklahoma | 40087 | 7855 | 107 |
2013807 | 2013807 | 2021-12-14 | McClain | Oklahoma | 40087 | 7775 | 107 |
2010556 | 2010556 | 2021-12-13 | McClain | Oklahoma | 40087 | 7775 | 107 |
2007305 | 2007305 | 2021-12-12 | McClain | Oklahoma | 40087 | 7775 | 107 |
2004054 | 2004054 | 2021-12-11 | McClain | Oklahoma | 40087 | 7775 | 107 |
2000803 | 2000803 | 2021-12-10 | McClain | Oklahoma | 40087 | 7775 | 107 |
1997553 | 1997553 | 2021-12-09 | McClain | Oklahoma | 40087 | 7775 | 107 |
1994302 | 1994302 | 2021-12-08 | McClain | Oklahoma | 40087 | 7775 | 107 |
1991051 | 1991051 | 2021-12-07 | McClain | Oklahoma | 40087 | 7698 | 106 |
1987800 | 1987800 | 2021-12-06 | McClain | Oklahoma | 40087 | 7698 | 106 |
1984550 | 1984550 | 2021-12-05 | McClain | Oklahoma | 40087 | 7698 | 106 |
1981300 | 1981300 | 2021-12-04 | McClain | Oklahoma | 40087 | 7698 | 106 |
1978050 | 1978050 | 2021-12-03 | McClain | Oklahoma | 40087 | 7698 | 106 |
1974800 | 1974800 | 2021-12-02 | McClain | Oklahoma | 40087 | 7698 | 106 |
1971551 | 1971551 | 2021-12-01 | McClain | Oklahoma | 40087 | 7698 | 106 |
1968301 | 1968301 | 2021-11-30 | McClain | Oklahoma | 40087 | 7661 | 106 |
1965050 | 1965050 | 2021-11-29 | McClain | Oklahoma | 40087 | 7661 | 106 |
1961798 | 1961798 | 2021-11-28 | McClain | Oklahoma | 40087 | 7661 | 106 |
1958547 | 1958547 | 2021-11-27 | McClain | Oklahoma | 40087 | 7661 | 106 |
1955296 | 1955296 | 2021-11-26 | McClain | Oklahoma | 40087 | 7661 | 106 |
1952045 | 1952045 | 2021-11-25 | McClain | Oklahoma | 40087 | 7661 | 106 |
1948794 | 1948794 | 2021-11-24 | McClain | Oklahoma | 40087 | 7661 | 106 |
1945543 | 1945543 | 2021-11-23 | McClain | Oklahoma | 40087 | 7609 | 106 |
1942292 | 1942292 | 2021-11-22 | McClain | Oklahoma | 40087 | 7609 | 106 |
1939042 | 1939042 | 2021-11-21 | McClain | Oklahoma | 40087 | 7609 | 106 |
1935792 | 1935792 | 2021-11-20 | McClain | Oklahoma | 40087 | 7609 | 106 |
1932542 | 1932542 | 2021-11-19 | McClain | Oklahoma | 40087 | 7609 | 106 |
1929291 | 1929291 | 2021-11-18 | McClain | Oklahoma | 40087 | 7609 | 106 |
1926041 | 1926041 | 2021-11-17 | McClain | Oklahoma | 40087 | 7609 | 106 |
1922791 | 1922791 | 2021-11-16 | McClain | Oklahoma | 40087 | 7550 | 106 |
1919542 | 1919542 | 2021-11-15 | McClain | Oklahoma | 40087 | 7550 | 106 |
1916292 | 1916292 | 2021-11-14 | McClain | Oklahoma | 40087 | 7550 | 106 |
1913042 | 1913042 | 2021-11-13 | McClain | Oklahoma | 40087 | 7550 | 106 |
1909792 | 1909792 | 2021-11-12 | McClain | Oklahoma | 40087 | 7550 | 106 |
1906543 | 1906543 | 2021-11-11 | McClain | Oklahoma | 40087 | 7550 | 106 |
1903294 | 1903294 | 2021-11-10 | McClain | Oklahoma | 40087 | 7550 | 106 |
1900044 | 1900044 | 2021-11-09 | McClain | Oklahoma | 40087 | 7480 | 106 |
1896794 | 1896794 | 2021-11-08 | McClain | Oklahoma | 40087 | 7480 | 106 |
1893544 | 1893544 | 2021-11-07 | McClain | Oklahoma | 40087 | 7480 | 106 |
1890294 | 1890294 | 2021-11-06 | McClain | Oklahoma | 40087 | 7480 | 106 |
1887044 | 1887044 | 2021-11-05 | McClain | Oklahoma | 40087 | 7480 | 106 |
1883794 | 1883794 | 2021-11-04 | McClain | Oklahoma | 40087 | 7480 | 106 |
1880545 | 1880545 | 2021-11-03 | McClain | Oklahoma | 40087 | 7480 | 106 |
1877296 | 1877296 | 2021-11-02 | McClain | Oklahoma | 40087 | 7449 | 104 |
1874047 | 1874047 | 2021-11-01 | McClain | Oklahoma | 40087 | 7449 | 104 |
1870798 | 1870798 | 2021-10-31 | McClain | Oklahoma | 40087 | 7449 | 104 |
1867549 | 1867549 | 2021-10-30 | McClain | Oklahoma | 40087 | 7449 | 104 |
1864300 | 1864300 | 2021-10-29 | McClain | Oklahoma | 40087 | 7449 | 104 |
1861051 | 1861051 | 2021-10-28 | McClain | Oklahoma | 40087 | 7449 | 104 |
1857802 | 1857802 | 2021-10-27 | McClain | Oklahoma | 40087 | 7449 | 104 |
1854553 | 1854553 | 2021-10-26 | McClain | Oklahoma | 40087 | 7399 | 100 |
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);