ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
76 rows where county = "Ottawa" and deaths = 16 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2360543 | 2360543 | 2022-03-31 | Ottawa | Kansas | 20143 | 1203 | 16 |
2357289 | 2357289 | 2022-03-30 | Ottawa | Kansas | 20143 | 1203 | 16 |
2354036 | 2354036 | 2022-03-29 | Ottawa | Kansas | 20143 | 1202 | 16 |
2350784 | 2350784 | 2022-03-28 | Ottawa | Kansas | 20143 | 1202 | 16 |
2347531 | 2347531 | 2022-03-27 | Ottawa | Kansas | 20143 | 1202 | 16 |
2344278 | 2344278 | 2022-03-26 | Ottawa | Kansas | 20143 | 1202 | 16 |
2341025 | 2341025 | 2022-03-25 | Ottawa | Kansas | 20143 | 1202 | 16 |
2337772 | 2337772 | 2022-03-24 | Ottawa | Kansas | 20143 | 1202 | 16 |
2334518 | 2334518 | 2022-03-23 | Ottawa | Kansas | 20143 | 1202 | 16 |
2331264 | 2331264 | 2022-03-22 | Ottawa | Kansas | 20143 | 1202 | 16 |
2328012 | 2328012 | 2022-03-21 | Ottawa | Kansas | 20143 | 1202 | 16 |
2324759 | 2324759 | 2022-03-20 | Ottawa | Kansas | 20143 | 1202 | 16 |
2321505 | 2321505 | 2022-03-19 | Ottawa | Kansas | 20143 | 1202 | 16 |
2318251 | 2318251 | 2022-03-18 | Ottawa | Kansas | 20143 | 1202 | 16 |
2314998 | 2314998 | 2022-03-17 | Ottawa | Kansas | 20143 | 1199 | 16 |
2311745 | 2311745 | 2022-03-16 | Ottawa | Kansas | 20143 | 1199 | 16 |
2308492 | 2308492 | 2022-03-15 | Ottawa | Kansas | 20143 | 1195 | 16 |
2305241 | 2305241 | 2022-03-14 | Ottawa | Kansas | 20143 | 1195 | 16 |
2301989 | 2301989 | 2022-03-13 | Ottawa | Kansas | 20143 | 1195 | 16 |
2298737 | 2298737 | 2022-03-12 | Ottawa | Kansas | 20143 | 1195 | 16 |
2295485 | 2295485 | 2022-03-11 | Ottawa | Kansas | 20143 | 1195 | 16 |
2292233 | 2292233 | 2022-03-10 | Ottawa | Kansas | 20143 | 1193 | 16 |
2288981 | 2288981 | 2022-03-09 | Ottawa | Kansas | 20143 | 1193 | 16 |
2285730 | 2285730 | 2022-03-08 | Ottawa | Kansas | 20143 | 1190 | 16 |
2282478 | 2282478 | 2022-03-07 | Ottawa | Kansas | 20143 | 1190 | 16 |
2279225 | 2279225 | 2022-03-06 | Ottawa | Kansas | 20143 | 1189 | 16 |
2275972 | 2275972 | 2022-03-05 | Ottawa | Kansas | 20143 | 1189 | 16 |
2272719 | 2272719 | 2022-03-04 | Ottawa | Kansas | 20143 | 1189 | 16 |
2269467 | 2269467 | 2022-03-03 | Ottawa | Kansas | 20143 | 1194 | 16 |
2266214 | 2266214 | 2022-03-02 | Ottawa | Kansas | 20143 | 1194 | 16 |
2262963 | 2262963 | 2022-03-01 | Ottawa | Kansas | 20143 | 1192 | 16 |
2259712 | 2259712 | 2022-02-28 | Ottawa | Kansas | 20143 | 1192 | 16 |
2256461 | 2256461 | 2022-02-27 | Ottawa | Kansas | 20143 | 1190 | 16 |
2253210 | 2253210 | 2022-02-26 | Ottawa | Kansas | 20143 | 1190 | 16 |
2249959 | 2249959 | 2022-02-25 | Ottawa | Kansas | 20143 | 1190 | 16 |
2246708 | 2246708 | 2022-02-24 | Ottawa | Kansas | 20143 | 1190 | 16 |
2243457 | 2243457 | 2022-02-23 | Ottawa | Kansas | 20143 | 1190 | 16 |
2240206 | 2240206 | 2022-02-22 | Ottawa | Kansas | 20143 | 1184 | 16 |
2236955 | 2236955 | 2022-02-21 | Ottawa | Kansas | 20143 | 1184 | 16 |
2233704 | 2233704 | 2022-02-20 | Ottawa | Kansas | 20143 | 1183 | 16 |
2230453 | 2230453 | 2022-02-19 | Ottawa | Kansas | 20143 | 1183 | 16 |
2227202 | 2227202 | 2022-02-18 | Ottawa | Kansas | 20143 | 1183 | 16 |
2223951 | 2223951 | 2022-02-17 | Ottawa | Kansas | 20143 | 1181 | 16 |
2220700 | 2220700 | 2022-02-16 | Ottawa | Kansas | 20143 | 1181 | 16 |
2217449 | 2217449 | 2022-02-15 | Ottawa | Kansas | 20143 | 1177 | 16 |
2214198 | 2214198 | 2022-02-14 | Ottawa | Kansas | 20143 | 1177 | 16 |
2210946 | 2210946 | 2022-02-13 | Ottawa | Kansas | 20143 | 1172 | 16 |
2207693 | 2207693 | 2022-02-12 | Ottawa | Kansas | 20143 | 1172 | 16 |
2204440 | 2204440 | 2022-02-11 | Ottawa | Kansas | 20143 | 1172 | 16 |
2201187 | 2201187 | 2022-02-10 | Ottawa | Kansas | 20143 | 1172 | 16 |
2197933 | 2197933 | 2022-02-09 | Ottawa | Kansas | 20143 | 1172 | 16 |
2194679 | 2194679 | 2022-02-08 | Ottawa | Kansas | 20143 | 1158 | 16 |
2191425 | 2191425 | 2022-02-07 | Ottawa | Kansas | 20143 | 1158 | 16 |
2188172 | 2188172 | 2022-02-06 | Ottawa | Kansas | 20143 | 1151 | 16 |
2184919 | 2184919 | 2022-02-05 | Ottawa | Kansas | 20143 | 1151 | 16 |
2181667 | 2181667 | 2022-02-04 | Ottawa | Kansas | 20143 | 1151 | 16 |
2178416 | 2178416 | 2022-02-03 | Ottawa | Kansas | 20143 | 1144 | 16 |
2175163 | 2175163 | 2022-02-02 | Ottawa | Kansas | 20143 | 1144 | 16 |
2171910 | 2171910 | 2022-02-01 | Ottawa | Kansas | 20143 | 1134 | 16 |
2168657 | 2168657 | 2022-01-31 | Ottawa | Kansas | 20143 | 1134 | 16 |
2165402 | 2165402 | 2022-01-30 | Ottawa | Kansas | 20143 | 1127 | 16 |
2162147 | 2162147 | 2022-01-29 | Ottawa | Kansas | 20143 | 1127 | 16 |
2158892 | 2158892 | 2022-01-28 | Ottawa | Kansas | 20143 | 1127 | 16 |
2155638 | 2155638 | 2022-01-27 | Ottawa | Kansas | 20143 | 1105 | 16 |
2152385 | 2152385 | 2022-01-26 | Ottawa | Kansas | 20143 | 1105 | 16 |
2149133 | 2149133 | 2022-01-25 | Ottawa | Kansas | 20143 | 1089 | 16 |
2145881 | 2145881 | 2022-01-24 | Ottawa | Kansas | 20143 | 1089 | 16 |
2142626 | 2142626 | 2022-01-23 | Ottawa | Kansas | 20143 | 1070 | 16 |
2139371 | 2139371 | 2022-01-22 | Ottawa | Kansas | 20143 | 1070 | 16 |
2136115 | 2136115 | 2022-01-21 | Ottawa | Kansas | 20143 | 1070 | 16 |
2132863 | 2132863 | 2022-01-20 | Ottawa | Kansas | 20143 | 1042 | 16 |
2129610 | 2129610 | 2022-01-19 | Ottawa | Kansas | 20143 | 1042 | 16 |
679268 | 679268 | 2020-10-29 | Ottawa | Oklahoma | 40115 | 1263 | 16 |
198850 | 198850 | 2020-06-01 | Ottawa | Ohio | 39123 | 103 | 16 |
195777 | 195777 | 2020-05-31 | Ottawa | Ohio | 39123 | 99 | 16 |
192707 | 192707 | 2020-05-30 | Ottawa | Ohio | 39123 | 99 | 16 |
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);