ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,333 rows where county = "Osage" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 1
- Osage · 1,823 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1947562 | 1947562 | 2021-11-24 | Osage | Kansas | 20139 | 2199 | 39 |
1948171 | 1948171 | 2021-11-24 | Osage | Missouri | 29151 | 2284 | 35 |
1948804 | 1948804 | 2021-11-24 | Osage | Oklahoma | 40113 | 7155 | 127 |
1944311 | 1944311 | 2021-11-23 | Osage | Kansas | 20139 | 2177 | 39 |
1944920 | 1944920 | 2021-11-23 | Osage | Missouri | 29151 | 2284 | 35 |
1945553 | 1945553 | 2021-11-23 | Osage | Oklahoma | 40113 | 7089 | 127 |
1941061 | 1941061 | 2021-11-22 | Osage | Kansas | 20139 | 2177 | 39 |
1941669 | 1941669 | 2021-11-22 | Osage | Missouri | 29151 | 2279 | 35 |
1942302 | 1942302 | 2021-11-22 | Osage | Oklahoma | 40113 | 7089 | 127 |
1937811 | 1937811 | 2021-11-21 | Osage | Kansas | 20139 | 2154 | 39 |
1938419 | 1938419 | 2021-11-21 | Osage | Missouri | 29151 | 2277 | 35 |
1939052 | 1939052 | 2021-11-21 | Osage | Oklahoma | 40113 | 7089 | 127 |
1934561 | 1934561 | 2021-11-20 | Osage | Kansas | 20139 | 2154 | 39 |
1935169 | 1935169 | 2021-11-20 | Osage | Missouri | 29151 | 2275 | 35 |
1935802 | 1935802 | 2021-11-20 | Osage | Oklahoma | 40113 | 7089 | 127 |
1931310 | 1931310 | 2021-11-19 | Osage | Kansas | 20139 | 2154 | 39 |
1931919 | 1931919 | 2021-11-19 | Osage | Missouri | 29151 | 2273 | 35 |
1932552 | 1932552 | 2021-11-19 | Osage | Oklahoma | 40113 | 7089 | 127 |
1928059 | 1928059 | 2021-11-18 | Osage | Kansas | 20139 | 2143 | 39 |
1928668 | 1928668 | 2021-11-18 | Osage | Missouri | 29151 | 2270 | 35 |
1929301 | 1929301 | 2021-11-18 | Osage | Oklahoma | 40113 | 7089 | 127 |
1924809 | 1924809 | 2021-11-17 | Osage | Kansas | 20139 | 2143 | 39 |
1925418 | 1925418 | 2021-11-17 | Osage | Missouri | 29151 | 2234 | 23 |
1926051 | 1926051 | 2021-11-17 | Osage | Oklahoma | 40113 | 7089 | 127 |
1921560 | 1921560 | 2021-11-16 | Osage | Kansas | 20139 | 2119 | 39 |
1922169 | 1922169 | 2021-11-16 | Osage | Missouri | 29151 | 2224 | 23 |
1922801 | 1922801 | 2021-11-16 | Osage | Oklahoma | 40113 | 7024 | 127 |
1918310 | 1918310 | 2021-11-15 | Osage | Kansas | 20139 | 2119 | 39 |
1918919 | 1918919 | 2021-11-15 | Osage | Missouri | 29151 | 2218 | 23 |
1919552 | 1919552 | 2021-11-15 | Osage | Oklahoma | 40113 | 7024 | 127 |
1915060 | 1915060 | 2021-11-14 | Osage | Kansas | 20139 | 2106 | 39 |
1915669 | 1915669 | 2021-11-14 | Osage | Missouri | 29151 | 2217 | 23 |
1916302 | 1916302 | 2021-11-14 | Osage | Oklahoma | 40113 | 7024 | 127 |
1911810 | 1911810 | 2021-11-13 | Osage | Kansas | 20139 | 2106 | 39 |
1912419 | 1912419 | 2021-11-13 | Osage | Missouri | 29151 | 2217 | 23 |
1913052 | 1913052 | 2021-11-13 | Osage | Oklahoma | 40113 | 7024 | 127 |
1908561 | 1908561 | 2021-11-12 | Osage | Kansas | 20139 | 2106 | 39 |
1909169 | 1909169 | 2021-11-12 | Osage | Missouri | 29151 | 2211 | 23 |
1909802 | 1909802 | 2021-11-12 | Osage | Oklahoma | 40113 | 7024 | 127 |
1905312 | 1905312 | 2021-11-11 | Osage | Kansas | 20139 | 2081 | 39 |
1905920 | 1905920 | 2021-11-11 | Osage | Missouri | 29151 | 2203 | 23 |
1906553 | 1906553 | 2021-11-11 | Osage | Oklahoma | 40113 | 7024 | 127 |
1902062 | 1902062 | 2021-11-10 | Osage | Kansas | 20139 | 2081 | 39 |
1902671 | 1902671 | 2021-11-10 | Osage | Missouri | 29151 | 2203 | 23 |
1903304 | 1903304 | 2021-11-10 | Osage | Oklahoma | 40113 | 7024 | 127 |
1898812 | 1898812 | 2021-11-09 | Osage | Kansas | 20139 | 2060 | 38 |
1899421 | 1899421 | 2021-11-09 | Osage | Missouri | 29151 | 2198 | 23 |
1900054 | 1900054 | 2021-11-09 | Osage | Oklahoma | 40113 | 6945 | 127 |
1895562 | 1895562 | 2021-11-08 | Osage | Kansas | 20139 | 2060 | 38 |
1896171 | 1896171 | 2021-11-08 | Osage | Missouri | 29151 | 2194 | 23 |
1896804 | 1896804 | 2021-11-08 | Osage | Oklahoma | 40113 | 6945 | 127 |
1892312 | 1892312 | 2021-11-07 | Osage | Kansas | 20139 | 2044 | 38 |
1892921 | 1892921 | 2021-11-07 | Osage | Missouri | 29151 | 2194 | 23 |
1893554 | 1893554 | 2021-11-07 | Osage | Oklahoma | 40113 | 6945 | 127 |
1889062 | 1889062 | 2021-11-06 | Osage | Kansas | 20139 | 2044 | 38 |
1889671 | 1889671 | 2021-11-06 | Osage | Missouri | 29151 | 2193 | 23 |
1890304 | 1890304 | 2021-11-06 | Osage | Oklahoma | 40113 | 6945 | 127 |
1885812 | 1885812 | 2021-11-05 | Osage | Kansas | 20139 | 2044 | 38 |
1886421 | 1886421 | 2021-11-05 | Osage | Missouri | 29151 | 2187 | 23 |
1887054 | 1887054 | 2021-11-05 | Osage | Oklahoma | 40113 | 6945 | 127 |
1882563 | 1882563 | 2021-11-04 | Osage | Kansas | 20139 | 2031 | 38 |
1883172 | 1883172 | 2021-11-04 | Osage | Missouri | 29151 | 2183 | 23 |
1883804 | 1883804 | 2021-11-04 | Osage | Oklahoma | 40113 | 6945 | 127 |
1879314 | 1879314 | 2021-11-03 | Osage | Kansas | 20139 | 2031 | 38 |
1879923 | 1879923 | 2021-11-03 | Osage | Missouri | 29151 | 2178 | 23 |
1880555 | 1880555 | 2021-11-03 | Osage | Oklahoma | 40113 | 6945 | 127 |
1876065 | 1876065 | 2021-11-02 | Osage | Kansas | 20139 | 2009 | 37 |
1876674 | 1876674 | 2021-11-02 | Osage | Missouri | 29151 | 2174 | 23 |
1877306 | 1877306 | 2021-11-02 | Osage | Oklahoma | 40113 | 6877 | 124 |
1872816 | 1872816 | 2021-11-01 | Osage | Kansas | 20139 | 2009 | 37 |
1873425 | 1873425 | 2021-11-01 | Osage | Missouri | 29151 | 2146 | 23 |
1874057 | 1874057 | 2021-11-01 | Osage | Oklahoma | 40113 | 6877 | 124 |
1869567 | 1869567 | 2021-10-31 | Osage | Kansas | 20139 | 2003 | 37 |
1870176 | 1870176 | 2021-10-31 | Osage | Missouri | 29151 | 2146 | 23 |
1870808 | 1870808 | 2021-10-31 | Osage | Oklahoma | 40113 | 6877 | 124 |
1866318 | 1866318 | 2021-10-30 | Osage | Kansas | 20139 | 2003 | 37 |
1866927 | 1866927 | 2021-10-30 | Osage | Missouri | 29151 | 2146 | 23 |
1867559 | 1867559 | 2021-10-30 | Osage | Oklahoma | 40113 | 6877 | 124 |
1863069 | 1863069 | 2021-10-29 | Osage | Kansas | 20139 | 2003 | 37 |
1863678 | 1863678 | 2021-10-29 | Osage | Missouri | 29151 | 2144 | 23 |
1864310 | 1864310 | 2021-10-29 | Osage | Oklahoma | 40113 | 6877 | 124 |
1859820 | 1859820 | 2021-10-28 | Osage | Kansas | 20139 | 1991 | 37 |
1860429 | 1860429 | 2021-10-28 | Osage | Missouri | 29151 | 2138 | 23 |
1861061 | 1861061 | 2021-10-28 | Osage | Oklahoma | 40113 | 6877 | 124 |
1856571 | 1856571 | 2021-10-27 | Osage | Kansas | 20139 | 1991 | 37 |
1857180 | 1857180 | 2021-10-27 | Osage | Missouri | 29151 | 2137 | 23 |
1857812 | 1857812 | 2021-10-27 | Osage | Oklahoma | 40113 | 6877 | 124 |
1853322 | 1853322 | 2021-10-26 | Osage | Kansas | 20139 | 1975 | 35 |
1853931 | 1853931 | 2021-10-26 | Osage | Missouri | 29151 | 2132 | 23 |
1854563 | 1854563 | 2021-10-26 | Osage | Oklahoma | 40113 | 6827 | 125 |
1850073 | 1850073 | 2021-10-25 | Osage | Kansas | 20139 | 1975 | 35 |
1850682 | 1850682 | 2021-10-25 | Osage | Missouri | 29151 | 2132 | 23 |
1851314 | 1851314 | 2021-10-25 | Osage | Oklahoma | 40113 | 6827 | 125 |
1846823 | 1846823 | 2021-10-24 | Osage | Kansas | 20139 | 1972 | 34 |
1847432 | 1847432 | 2021-10-24 | Osage | Missouri | 29151 | 2131 | 23 |
1848064 | 1848064 | 2021-10-24 | Osage | Oklahoma | 40113 | 6827 | 125 |
1843573 | 1843573 | 2021-10-23 | Osage | Kansas | 20139 | 1972 | 34 |
1844182 | 1844182 | 2021-10-23 | Osage | Missouri | 29151 | 2129 | 23 |
1844814 | 1844814 | 2021-10-23 | Osage | Oklahoma | 40113 | 6827 | 125 |
1840323 | 1840323 | 2021-10-22 | Osage | Kansas | 20139 | 1972 | 34 |
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);