ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Creek" and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2111300 | 2111300 | 2022-01-13 | Creek | Oklahoma | 40037 | 13153 | 282 |
2108048 | 2108048 | 2022-01-12 | Creek | Oklahoma | 40037 | 13153 | 282 |
2104797 | 2104797 | 2022-01-11 | Creek | Oklahoma | 40037 | 12601 | 282 |
2101546 | 2101546 | 2022-01-10 | Creek | Oklahoma | 40037 | 12601 | 282 |
2098295 | 2098295 | 2022-01-09 | Creek | Oklahoma | 40037 | 12601 | 282 |
2095043 | 2095043 | 2022-01-08 | Creek | Oklahoma | 40037 | 12601 | 282 |
2091791 | 2091791 | 2022-01-07 | Creek | Oklahoma | 40037 | 12601 | 282 |
2088539 | 2088539 | 2022-01-06 | Creek | Oklahoma | 40037 | 12601 | 282 |
2085288 | 2085288 | 2022-01-05 | Creek | Oklahoma | 40037 | 12601 | 282 |
2082036 | 2082036 | 2022-01-04 | Creek | Oklahoma | 40037 | 12165 | 277 |
2078784 | 2078784 | 2022-01-03 | Creek | Oklahoma | 40037 | 12165 | 277 |
2075533 | 2075533 | 2022-01-02 | Creek | Oklahoma | 40037 | 12165 | 277 |
2072282 | 2072282 | 2022-01-01 | Creek | Oklahoma | 40037 | 12165 | 277 |
2069031 | 2069031 | 2021-12-31 | Creek | Oklahoma | 40037 | 12165 | 277 |
2065780 | 2065780 | 2021-12-30 | Creek | Oklahoma | 40037 | 12165 | 277 |
2062530 | 2062530 | 2021-12-29 | Creek | Oklahoma | 40037 | 12165 | 277 |
2059280 | 2059280 | 2021-12-28 | Creek | Oklahoma | 40037 | 12050 | 274 |
2056031 | 2056031 | 2021-12-27 | Creek | Oklahoma | 40037 | 12050 | 274 |
2052782 | 2052782 | 2021-12-26 | Creek | Oklahoma | 40037 | 12050 | 274 |
2049532 | 2049532 | 2021-12-25 | Creek | Oklahoma | 40037 | 12050 | 274 |
2046282 | 2046282 | 2021-12-24 | Creek | Oklahoma | 40037 | 12050 | 274 |
2043032 | 2043032 | 2021-12-23 | Creek | Oklahoma | 40037 | 12050 | 274 |
2039783 | 2039783 | 2021-12-22 | Creek | Oklahoma | 40037 | 12050 | 274 |
2036533 | 2036533 | 2021-12-21 | Creek | Oklahoma | 40037 | 11926 | 272 |
2033283 | 2033283 | 2021-12-20 | Creek | Oklahoma | 40037 | 11926 | 272 |
2030033 | 2030033 | 2021-12-19 | Creek | Oklahoma | 40037 | 11926 | 272 |
2026782 | 2026782 | 2021-12-18 | Creek | Oklahoma | 40037 | 11926 | 272 |
2023531 | 2023531 | 2021-12-17 | Creek | Oklahoma | 40037 | 11926 | 272 |
2020280 | 2020280 | 2021-12-16 | Creek | Oklahoma | 40037 | 11926 | 272 |
2017029 | 2017029 | 2021-12-15 | Creek | Oklahoma | 40037 | 11926 | 272 |
2013779 | 2013779 | 2021-12-14 | Creek | Oklahoma | 40037 | 11799 | 269 |
2010528 | 2010528 | 2021-12-13 | Creek | Oklahoma | 40037 | 11799 | 269 |
2007277 | 2007277 | 2021-12-12 | Creek | Oklahoma | 40037 | 11799 | 269 |
2004026 | 2004026 | 2021-12-11 | Creek | Oklahoma | 40037 | 11799 | 269 |
2000775 | 2000775 | 2021-12-10 | Creek | Oklahoma | 40037 | 11799 | 269 |
1997525 | 1997525 | 2021-12-09 | Creek | Oklahoma | 40037 | 11799 | 269 |
1994274 | 1994274 | 2021-12-08 | Creek | Oklahoma | 40037 | 11799 | 269 |
1991023 | 1991023 | 2021-12-07 | Creek | Oklahoma | 40037 | 11641 | 269 |
1987772 | 1987772 | 2021-12-06 | Creek | Oklahoma | 40037 | 11641 | 269 |
1984522 | 1984522 | 2021-12-05 | Creek | Oklahoma | 40037 | 11641 | 269 |
1981272 | 1981272 | 2021-12-04 | Creek | Oklahoma | 40037 | 11641 | 269 |
1978022 | 1978022 | 2021-12-03 | Creek | Oklahoma | 40037 | 11641 | 269 |
1974772 | 1974772 | 2021-12-02 | Creek | Oklahoma | 40037 | 11641 | 263 |
1971523 | 1971523 | 2021-12-01 | Creek | Oklahoma | 40037 | 11641 | 263 |
1968273 | 1968273 | 2021-11-30 | Creek | Oklahoma | 40037 | 11549 | 263 |
1965022 | 1965022 | 2021-11-29 | Creek | Oklahoma | 40037 | 11549 | 263 |
1961770 | 1961770 | 2021-11-28 | Creek | Oklahoma | 40037 | 11549 | 263 |
1958519 | 1958519 | 2021-11-27 | Creek | Oklahoma | 40037 | 11549 | 263 |
1955268 | 1955268 | 2021-11-26 | Creek | Oklahoma | 40037 | 11549 | 263 |
1952017 | 1952017 | 2021-11-25 | Creek | Oklahoma | 40037 | 11549 | 263 |
1948766 | 1948766 | 2021-11-24 | Creek | Oklahoma | 40037 | 11549 | 263 |
1945515 | 1945515 | 2021-11-23 | Creek | Oklahoma | 40037 | 11452 | 263 |
1942264 | 1942264 | 2021-11-22 | Creek | Oklahoma | 40037 | 11452 | 263 |
1939014 | 1939014 | 2021-11-21 | Creek | Oklahoma | 40037 | 11452 | 263 |
1935764 | 1935764 | 2021-11-20 | Creek | Oklahoma | 40037 | 11452 | 263 |
1932514 | 1932514 | 2021-11-19 | Creek | Oklahoma | 40037 | 11452 | 263 |
1929263 | 1929263 | 2021-11-18 | Creek | Oklahoma | 40037 | 11452 | 263 |
1926013 | 1926013 | 2021-11-17 | Creek | Oklahoma | 40037 | 11452 | 263 |
1922763 | 1922763 | 2021-11-16 | Creek | Oklahoma | 40037 | 11362 | 263 |
1919514 | 1919514 | 2021-11-15 | Creek | Oklahoma | 40037 | 11362 | 263 |
1916264 | 1916264 | 2021-11-14 | Creek | Oklahoma | 40037 | 11362 | 263 |
1913014 | 1913014 | 2021-11-13 | Creek | Oklahoma | 40037 | 11362 | 263 |
1909764 | 1909764 | 2021-11-12 | Creek | Oklahoma | 40037 | 11362 | 263 |
1906515 | 1906515 | 2021-11-11 | Creek | Oklahoma | 40037 | 11362 | 263 |
1903266 | 1903266 | 2021-11-10 | Creek | Oklahoma | 40037 | 11362 | 263 |
1900016 | 1900016 | 2021-11-09 | Creek | Oklahoma | 40037 | 11277 | 263 |
1896766 | 1896766 | 2021-11-08 | Creek | Oklahoma | 40037 | 11277 | 263 |
1893516 | 1893516 | 2021-11-07 | Creek | Oklahoma | 40037 | 11277 | 263 |
1890266 | 1890266 | 2021-11-06 | Creek | Oklahoma | 40037 | 11277 | 263 |
1887016 | 1887016 | 2021-11-05 | Creek | Oklahoma | 40037 | 11277 | 263 |
1883766 | 1883766 | 2021-11-04 | Creek | Oklahoma | 40037 | 11277 | 263 |
1880517 | 1880517 | 2021-11-03 | Creek | Oklahoma | 40037 | 11277 | 263 |
1877268 | 1877268 | 2021-11-02 | Creek | Oklahoma | 40037 | 11185 | 258 |
1874019 | 1874019 | 2021-11-01 | Creek | Oklahoma | 40037 | 11185 | 258 |
1870770 | 1870770 | 2021-10-31 | Creek | Oklahoma | 40037 | 11185 | 258 |
1867521 | 1867521 | 2021-10-30 | Creek | Oklahoma | 40037 | 11185 | 258 |
1864272 | 1864272 | 2021-10-29 | Creek | Oklahoma | 40037 | 11185 | 258 |
1861023 | 1861023 | 2021-10-28 | Creek | Oklahoma | 40037 | 11185 | 258 |
1857774 | 1857774 | 2021-10-27 | Creek | Oklahoma | 40037 | 11185 | 258 |
1854525 | 1854525 | 2021-10-26 | Creek | Oklahoma | 40037 | 11050 | 252 |
1851276 | 1851276 | 2021-10-25 | Creek | Oklahoma | 40037 | 11050 | 252 |
1848026 | 1848026 | 2021-10-24 | Creek | Oklahoma | 40037 | 11050 | 252 |
1844776 | 1844776 | 2021-10-23 | Creek | Oklahoma | 40037 | 11050 | 252 |
1841526 | 1841526 | 2021-10-22 | Creek | Oklahoma | 40037 | 11050 | 252 |
1838277 | 1838277 | 2021-10-21 | Creek | Oklahoma | 40037 | 11050 | 252 |
1835028 | 1835028 | 2021-10-20 | Creek | Oklahoma | 40037 | 11050 | 252 |
1831779 | 1831779 | 2021-10-19 | Creek | Oklahoma | 40037 | 10901 | 231 |
1828530 | 1828530 | 2021-10-18 | Creek | Oklahoma | 40037 | 10901 | 231 |
1825281 | 1825281 | 2021-10-17 | Creek | Oklahoma | 40037 | 10901 | 231 |
1822032 | 1822032 | 2021-10-16 | Creek | Oklahoma | 40037 | 10901 | 231 |
1818783 | 1818783 | 2021-10-15 | Creek | Oklahoma | 40037 | 10901 | 231 |
1815534 | 1815534 | 2021-10-14 | Creek | Oklahoma | 40037 | 10901 | 231 |
1812286 | 1812286 | 2021-10-13 | Creek | Oklahoma | 40037 | 10901 | 231 |
1809037 | 1809037 | 2021-10-12 | Creek | Oklahoma | 40037 | 10677 | 227 |
1805787 | 1805787 | 2021-10-11 | Creek | Oklahoma | 40037 | 10677 | 227 |
1802537 | 1802537 | 2021-10-10 | Creek | Oklahoma | 40037 | 10677 | 227 |
1799288 | 1799288 | 2021-10-09 | Creek | Oklahoma | 40037 | 10677 | 227 |
1796039 | 1796039 | 2021-10-08 | Creek | Oklahoma | 40037 | 10677 | 227 |
1792790 | 1792790 | 2021-10-07 | Creek | Oklahoma | 40037 | 10677 | 227 |
1789541 | 1789541 | 2021-10-06 | Creek | Oklahoma | 40037 | 10677 | 227 |
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);