ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where fips = 40101 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176399 | 2176399 | 2022-02-02 | Muskogee | Oklahoma | 40101 | 19064 | 293 |
2173145 | 2173145 | 2022-02-01 | Muskogee | Oklahoma | 40101 | 17427 | 291 |
2169893 | 2169893 | 2022-01-31 | Muskogee | Oklahoma | 40101 | 17427 | 291 |
2166638 | 2166638 | 2022-01-30 | Muskogee | Oklahoma | 40101 | 17427 | 291 |
2163383 | 2163383 | 2022-01-29 | Muskogee | Oklahoma | 40101 | 17427 | 291 |
2160128 | 2160128 | 2022-01-28 | Muskogee | Oklahoma | 40101 | 17427 | 291 |
2156873 | 2156873 | 2022-01-27 | Muskogee | Oklahoma | 40101 | 17427 | 291 |
2153620 | 2153620 | 2022-01-26 | Muskogee | Oklahoma | 40101 | 17427 | 291 |
2150368 | 2150368 | 2022-01-25 | Muskogee | Oklahoma | 40101 | 16181 | 288 |
2147116 | 2147116 | 2022-01-24 | Muskogee | Oklahoma | 40101 | 16181 | 288 |
2143862 | 2143862 | 2022-01-23 | Muskogee | Oklahoma | 40101 | 16181 | 288 |
2140607 | 2140607 | 2022-01-22 | Muskogee | Oklahoma | 40101 | 16181 | 288 |
2137351 | 2137351 | 2022-01-21 | Muskogee | Oklahoma | 40101 | 16181 | 288 |
2134097 | 2134097 | 2022-01-20 | Muskogee | Oklahoma | 40101 | 16181 | 288 |
2130845 | 2130845 | 2022-01-19 | Muskogee | Oklahoma | 40101 | 16181 | 288 |
2127591 | 2127591 | 2022-01-18 | Muskogee | Oklahoma | 40101 | 15015 | 286 |
2124339 | 2124339 | 2022-01-17 | Muskogee | Oklahoma | 40101 | 15015 | 286 |
2121087 | 2121087 | 2022-01-16 | Muskogee | Oklahoma | 40101 | 15015 | 286 |
2117835 | 2117835 | 2022-01-15 | Muskogee | Oklahoma | 40101 | 15015 | 286 |
2114584 | 2114584 | 2022-01-14 | Muskogee | Oklahoma | 40101 | 15015 | 286 |
2111332 | 2111332 | 2022-01-13 | Muskogee | Oklahoma | 40101 | 15015 | 286 |
2108080 | 2108080 | 2022-01-12 | Muskogee | Oklahoma | 40101 | 15015 | 286 |
2104829 | 2104829 | 2022-01-11 | Muskogee | Oklahoma | 40101 | 14441 | 282 |
2101578 | 2101578 | 2022-01-10 | Muskogee | Oklahoma | 40101 | 14441 | 282 |
2098327 | 2098327 | 2022-01-09 | Muskogee | Oklahoma | 40101 | 14441 | 282 |
2095075 | 2095075 | 2022-01-08 | Muskogee | Oklahoma | 40101 | 14441 | 282 |
2091823 | 2091823 | 2022-01-07 | Muskogee | Oklahoma | 40101 | 14441 | 282 |
2088571 | 2088571 | 2022-01-06 | Muskogee | Oklahoma | 40101 | 14441 | 282 |
2085320 | 2085320 | 2022-01-05 | Muskogee | Oklahoma | 40101 | 14441 | 282 |
2082068 | 2082068 | 2022-01-04 | Muskogee | Oklahoma | 40101 | 14243 | 279 |
2078816 | 2078816 | 2022-01-03 | Muskogee | Oklahoma | 40101 | 14243 | 279 |
2075565 | 2075565 | 2022-01-02 | Muskogee | Oklahoma | 40101 | 14243 | 279 |
2072314 | 2072314 | 2022-01-01 | Muskogee | Oklahoma | 40101 | 14243 | 279 |
2069063 | 2069063 | 2021-12-31 | Muskogee | Oklahoma | 40101 | 14243 | 279 |
2065812 | 2065812 | 2021-12-30 | Muskogee | Oklahoma | 40101 | 14243 | 279 |
2062562 | 2062562 | 2021-12-29 | Muskogee | Oklahoma | 40101 | 14243 | 279 |
2059312 | 2059312 | 2021-12-28 | Muskogee | Oklahoma | 40101 | 14147 | 276 |
2056063 | 2056063 | 2021-12-27 | Muskogee | Oklahoma | 40101 | 14147 | 276 |
2052814 | 2052814 | 2021-12-26 | Muskogee | Oklahoma | 40101 | 14147 | 276 |
2049564 | 2049564 | 2021-12-25 | Muskogee | Oklahoma | 40101 | 14147 | 276 |
2046314 | 2046314 | 2021-12-24 | Muskogee | Oklahoma | 40101 | 14147 | 276 |
2043064 | 2043064 | 2021-12-23 | Muskogee | Oklahoma | 40101 | 14147 | 276 |
2039815 | 2039815 | 2021-12-22 | Muskogee | Oklahoma | 40101 | 14147 | 276 |
2036565 | 2036565 | 2021-12-21 | Muskogee | Oklahoma | 40101 | 14058 | 275 |
2033315 | 2033315 | 2021-12-20 | Muskogee | Oklahoma | 40101 | 14058 | 275 |
2030065 | 2030065 | 2021-12-19 | Muskogee | Oklahoma | 40101 | 14058 | 275 |
2026814 | 2026814 | 2021-12-18 | Muskogee | Oklahoma | 40101 | 14058 | 275 |
2023563 | 2023563 | 2021-12-17 | Muskogee | Oklahoma | 40101 | 14058 | 275 |
2020312 | 2020312 | 2021-12-16 | Muskogee | Oklahoma | 40101 | 14058 | 275 |
2017061 | 2017061 | 2021-12-15 | Muskogee | Oklahoma | 40101 | 14058 | 275 |
2013811 | 2013811 | 2021-12-14 | Muskogee | Oklahoma | 40101 | 13970 | 274 |
2010560 | 2010560 | 2021-12-13 | Muskogee | Oklahoma | 40101 | 13970 | 274 |
2007309 | 2007309 | 2021-12-12 | Muskogee | Oklahoma | 40101 | 13970 | 274 |
2004058 | 2004058 | 2021-12-11 | Muskogee | Oklahoma | 40101 | 13970 | 274 |
2000807 | 2000807 | 2021-12-10 | Muskogee | Oklahoma | 40101 | 13970 | 274 |
1997557 | 1997557 | 2021-12-09 | Muskogee | Oklahoma | 40101 | 13970 | 274 |
1994306 | 1994306 | 2021-12-08 | Muskogee | Oklahoma | 40101 | 13970 | 274 |
1991055 | 1991055 | 2021-12-07 | Muskogee | Oklahoma | 40101 | 13852 | 271 |
1987804 | 1987804 | 2021-12-06 | Muskogee | Oklahoma | 40101 | 13852 | 271 |
1984554 | 1984554 | 2021-12-05 | Muskogee | Oklahoma | 40101 | 13852 | 271 |
1981304 | 1981304 | 2021-12-04 | Muskogee | Oklahoma | 40101 | 13852 | 271 |
1978054 | 1978054 | 2021-12-03 | Muskogee | Oklahoma | 40101 | 13852 | 271 |
1974804 | 1974804 | 2021-12-02 | Muskogee | Oklahoma | 40101 | 13852 | 262 |
1971555 | 1971555 | 2021-12-01 | Muskogee | Oklahoma | 40101 | 13852 | 262 |
1968305 | 1968305 | 2021-11-30 | Muskogee | Oklahoma | 40101 | 13787 | 262 |
1965054 | 1965054 | 2021-11-29 | Muskogee | Oklahoma | 40101 | 13787 | 262 |
1961802 | 1961802 | 2021-11-28 | Muskogee | Oklahoma | 40101 | 13787 | 262 |
1958551 | 1958551 | 2021-11-27 | Muskogee | Oklahoma | 40101 | 13787 | 262 |
1955300 | 1955300 | 2021-11-26 | Muskogee | Oklahoma | 40101 | 13787 | 262 |
1952049 | 1952049 | 2021-11-25 | Muskogee | Oklahoma | 40101 | 13787 | 262 |
1948798 | 1948798 | 2021-11-24 | Muskogee | Oklahoma | 40101 | 13787 | 262 |
1945547 | 1945547 | 2021-11-23 | Muskogee | Oklahoma | 40101 | 13676 | 262 |
1942296 | 1942296 | 2021-11-22 | Muskogee | Oklahoma | 40101 | 13676 | 262 |
1939046 | 1939046 | 2021-11-21 | Muskogee | Oklahoma | 40101 | 13676 | 262 |
1935796 | 1935796 | 2021-11-20 | Muskogee | Oklahoma | 40101 | 13676 | 262 |
1932546 | 1932546 | 2021-11-19 | Muskogee | Oklahoma | 40101 | 13676 | 262 |
1929295 | 1929295 | 2021-11-18 | Muskogee | Oklahoma | 40101 | 13676 | 262 |
1926045 | 1926045 | 2021-11-17 | Muskogee | Oklahoma | 40101 | 13676 | 262 |
1922795 | 1922795 | 2021-11-16 | Muskogee | Oklahoma | 40101 | 13589 | 262 |
1919546 | 1919546 | 2021-11-15 | Muskogee | Oklahoma | 40101 | 13589 | 262 |
1916296 | 1916296 | 2021-11-14 | Muskogee | Oklahoma | 40101 | 13589 | 262 |
1913046 | 1913046 | 2021-11-13 | Muskogee | Oklahoma | 40101 | 13589 | 262 |
1909796 | 1909796 | 2021-11-12 | Muskogee | Oklahoma | 40101 | 13589 | 262 |
1906547 | 1906547 | 2021-11-11 | Muskogee | Oklahoma | 40101 | 13589 | 262 |
1903298 | 1903298 | 2021-11-10 | Muskogee | Oklahoma | 40101 | 13589 | 262 |
1900048 | 1900048 | 2021-11-09 | Muskogee | Oklahoma | 40101 | 13528 | 262 |
1896798 | 1896798 | 2021-11-08 | Muskogee | Oklahoma | 40101 | 13528 | 262 |
1893548 | 1893548 | 2021-11-07 | Muskogee | Oklahoma | 40101 | 13528 | 262 |
1890298 | 1890298 | 2021-11-06 | Muskogee | Oklahoma | 40101 | 13528 | 262 |
1887048 | 1887048 | 2021-11-05 | Muskogee | Oklahoma | 40101 | 13528 | 262 |
1883798 | 1883798 | 2021-11-04 | Muskogee | Oklahoma | 40101 | 13528 | 262 |
1880549 | 1880549 | 2021-11-03 | Muskogee | Oklahoma | 40101 | 13528 | 262 |
1877300 | 1877300 | 2021-11-02 | Muskogee | Oklahoma | 40101 | 13440 | 261 |
1874051 | 1874051 | 2021-11-01 | Muskogee | Oklahoma | 40101 | 13440 | 261 |
1870802 | 1870802 | 2021-10-31 | Muskogee | Oklahoma | 40101 | 13440 | 261 |
1867553 | 1867553 | 2021-10-30 | Muskogee | Oklahoma | 40101 | 13440 | 261 |
1864304 | 1864304 | 2021-10-29 | Muskogee | Oklahoma | 40101 | 13440 | 261 |
1861055 | 1861055 | 2021-10-28 | Muskogee | Oklahoma | 40101 | 13440 | 261 |
1857806 | 1857806 | 2021-10-27 | Muskogee | Oklahoma | 40101 | 13440 | 261 |
1854557 | 1854557 | 2021-10-26 | Muskogee | Oklahoma | 40101 | 13336 | 256 |
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);