ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
39 rows where county = "Ottawa" and deaths = 106 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 |
---|---|---|---|---|---|---|---|
2127598 | 2127598 | 2022-01-18 | Ottawa | Oklahoma | 40115 | 6951 | 106 |
2124346 | 2124346 | 2022-01-17 | Ottawa | Oklahoma | 40115 | 6951 | 106 |
2121094 | 2121094 | 2022-01-16 | Ottawa | Oklahoma | 40115 | 6951 | 106 |
2117842 | 2117842 | 2022-01-15 | Ottawa | Oklahoma | 40115 | 6951 | 106 |
2114591 | 2114591 | 2022-01-14 | Ottawa | Oklahoma | 40115 | 6951 | 106 |
2111339 | 2111339 | 2022-01-13 | Ottawa | Oklahoma | 40115 | 6951 | 106 |
2108087 | 2108087 | 2022-01-12 | Ottawa | Oklahoma | 40115 | 6951 | 106 |
2082075 | 2082075 | 2022-01-04 | Ottawa | Oklahoma | 40115 | 6667 | 106 |
2078823 | 2078823 | 2022-01-03 | Ottawa | Oklahoma | 40115 | 6667 | 106 |
2075572 | 2075572 | 2022-01-02 | Ottawa | Oklahoma | 40115 | 6667 | 106 |
2072321 | 2072321 | 2022-01-01 | Ottawa | Oklahoma | 40115 | 6667 | 106 |
2069070 | 2069070 | 2021-12-31 | Ottawa | Oklahoma | 40115 | 6667 | 106 |
2065819 | 2065819 | 2021-12-30 | Ottawa | Oklahoma | 40115 | 6667 | 106 |
2062569 | 2062569 | 2021-12-29 | Ottawa | Oklahoma | 40115 | 6667 | 106 |
2059319 | 2059319 | 2021-12-28 | Ottawa | Oklahoma | 40115 | 6587 | 106 |
2056070 | 2056070 | 2021-12-27 | Ottawa | Oklahoma | 40115 | 6587 | 106 |
2052821 | 2052821 | 2021-12-26 | Ottawa | Oklahoma | 40115 | 6587 | 106 |
2049571 | 2049571 | 2021-12-25 | Ottawa | Oklahoma | 40115 | 6587 | 106 |
2046321 | 2046321 | 2021-12-24 | Ottawa | Oklahoma | 40115 | 6587 | 106 |
2043071 | 2043071 | 2021-12-23 | Ottawa | Oklahoma | 40115 | 6587 | 106 |
2039822 | 2039822 | 2021-12-22 | Ottawa | Oklahoma | 40115 | 6587 | 106 |
2036572 | 2036572 | 2021-12-21 | Ottawa | Oklahoma | 40115 | 6508 | 106 |
2033237 | 2033237 | 2021-12-20 | Ottawa | Ohio | 39123 | 6046 | 106 |
2033322 | 2033322 | 2021-12-20 | Ottawa | Oklahoma | 40115 | 6508 | 106 |
2029987 | 2029987 | 2021-12-19 | Ottawa | Ohio | 39123 | 6019 | 106 |
2030072 | 2030072 | 2021-12-19 | Ottawa | Oklahoma | 40115 | 6508 | 106 |
2026736 | 2026736 | 2021-12-18 | Ottawa | Ohio | 39123 | 6006 | 106 |
2026821 | 2026821 | 2021-12-18 | Ottawa | Oklahoma | 40115 | 6508 | 106 |
2023485 | 2023485 | 2021-12-17 | Ottawa | Ohio | 39123 | 5970 | 106 |
2023570 | 2023570 | 2021-12-17 | Ottawa | Oklahoma | 40115 | 6508 | 106 |
2020319 | 2020319 | 2021-12-16 | Ottawa | Oklahoma | 40115 | 6508 | 106 |
2017068 | 2017068 | 2021-12-15 | Ottawa | Oklahoma | 40115 | 6508 | 106 |
2013818 | 2013818 | 2021-12-14 | Ottawa | Oklahoma | 40115 | 6430 | 106 |
2010567 | 2010567 | 2021-12-13 | Ottawa | Oklahoma | 40115 | 6430 | 106 |
2007316 | 2007316 | 2021-12-12 | Ottawa | Oklahoma | 40115 | 6430 | 106 |
2004065 | 2004065 | 2021-12-11 | Ottawa | Oklahoma | 40115 | 6430 | 106 |
2000814 | 2000814 | 2021-12-10 | Ottawa | Oklahoma | 40115 | 6430 | 106 |
1997564 | 1997564 | 2021-12-09 | Ottawa | Oklahoma | 40115 | 6430 | 106 |
1994313 | 1994313 | 2021-12-08 | Ottawa | Oklahoma | 40115 | 6430 | 106 |
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);