ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
44 rows where county = "Major", deaths = 32 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1974797 | 1974797 | 2021-12-02 | Major | Oklahoma | 40093 | 1425 | 32 |
1971548 | 1971548 | 2021-12-01 | Major | Oklahoma | 40093 | 1425 | 32 |
1968298 | 1968298 | 2021-11-30 | Major | Oklahoma | 40093 | 1397 | 32 |
1965047 | 1965047 | 2021-11-29 | Major | Oklahoma | 40093 | 1397 | 32 |
1961795 | 1961795 | 2021-11-28 | Major | Oklahoma | 40093 | 1397 | 32 |
1958544 | 1958544 | 2021-11-27 | Major | Oklahoma | 40093 | 1397 | 32 |
1955293 | 1955293 | 2021-11-26 | Major | Oklahoma | 40093 | 1397 | 32 |
1952042 | 1952042 | 2021-11-25 | Major | Oklahoma | 40093 | 1397 | 32 |
1948791 | 1948791 | 2021-11-24 | Major | Oklahoma | 40093 | 1397 | 32 |
1945540 | 1945540 | 2021-11-23 | Major | Oklahoma | 40093 | 1363 | 32 |
1942289 | 1942289 | 2021-11-22 | Major | Oklahoma | 40093 | 1363 | 32 |
1939039 | 1939039 | 2021-11-21 | Major | Oklahoma | 40093 | 1363 | 32 |
1935789 | 1935789 | 2021-11-20 | Major | Oklahoma | 40093 | 1363 | 32 |
1932539 | 1932539 | 2021-11-19 | Major | Oklahoma | 40093 | 1363 | 32 |
1929288 | 1929288 | 2021-11-18 | Major | Oklahoma | 40093 | 1363 | 32 |
1926038 | 1926038 | 2021-11-17 | Major | Oklahoma | 40093 | 1363 | 32 |
1922788 | 1922788 | 2021-11-16 | Major | Oklahoma | 40093 | 1327 | 32 |
1919539 | 1919539 | 2021-11-15 | Major | Oklahoma | 40093 | 1327 | 32 |
1916289 | 1916289 | 2021-11-14 | Major | Oklahoma | 40093 | 1327 | 32 |
1913039 | 1913039 | 2021-11-13 | Major | Oklahoma | 40093 | 1327 | 32 |
1909789 | 1909789 | 2021-11-12 | Major | Oklahoma | 40093 | 1327 | 32 |
1906540 | 1906540 | 2021-11-11 | Major | Oklahoma | 40093 | 1327 | 32 |
1903291 | 1903291 | 2021-11-10 | Major | Oklahoma | 40093 | 1327 | 32 |
1900041 | 1900041 | 2021-11-09 | Major | Oklahoma | 40093 | 1293 | 32 |
1896791 | 1896791 | 2021-11-08 | Major | Oklahoma | 40093 | 1293 | 32 |
1893541 | 1893541 | 2021-11-07 | Major | Oklahoma | 40093 | 1293 | 32 |
1890291 | 1890291 | 2021-11-06 | Major | Oklahoma | 40093 | 1293 | 32 |
1887041 | 1887041 | 2021-11-05 | Major | Oklahoma | 40093 | 1293 | 32 |
1883791 | 1883791 | 2021-11-04 | Major | Oklahoma | 40093 | 1293 | 32 |
1880542 | 1880542 | 2021-11-03 | Major | Oklahoma | 40093 | 1293 | 32 |
1877293 | 1877293 | 2021-11-02 | Major | Oklahoma | 40093 | 1278 | 32 |
1874044 | 1874044 | 2021-11-01 | Major | Oklahoma | 40093 | 1278 | 32 |
1870795 | 1870795 | 2021-10-31 | Major | Oklahoma | 40093 | 1278 | 32 |
1867546 | 1867546 | 2021-10-30 | Major | Oklahoma | 40093 | 1278 | 32 |
1864297 | 1864297 | 2021-10-29 | Major | Oklahoma | 40093 | 1278 | 32 |
1861048 | 1861048 | 2021-10-28 | Major | Oklahoma | 40093 | 1278 | 32 |
1857799 | 1857799 | 2021-10-27 | Major | Oklahoma | 40093 | 1278 | 32 |
1854550 | 1854550 | 2021-10-26 | Major | Oklahoma | 40093 | 1251 | 32 |
1851301 | 1851301 | 2021-10-25 | Major | Oklahoma | 40093 | 1251 | 32 |
1848051 | 1848051 | 2021-10-24 | Major | Oklahoma | 40093 | 1251 | 32 |
1844801 | 1844801 | 2021-10-23 | Major | Oklahoma | 40093 | 1251 | 32 |
1841551 | 1841551 | 2021-10-22 | Major | Oklahoma | 40093 | 1251 | 32 |
1838302 | 1838302 | 2021-10-21 | Major | Oklahoma | 40093 | 1251 | 32 |
1835053 | 1835053 | 2021-10-20 | Major | Oklahoma | 40093 | 1251 | 32 |
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);