ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
101 rows where county = "Ottawa" and deaths = 2 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 |
---|---|---|---|---|---|---|---|
404205 | 404205 | 2020-08-05 | Ottawa | Oklahoma | 40115 | 352 | 2 |
400987 | 400987 | 2020-08-04 | Ottawa | Oklahoma | 40115 | 348 | 2 |
397772 | 397772 | 2020-08-03 | Ottawa | Oklahoma | 40115 | 347 | 2 |
394555 | 394555 | 2020-08-02 | Ottawa | Oklahoma | 40115 | 345 | 2 |
391339 | 391339 | 2020-08-01 | Ottawa | Oklahoma | 40115 | 337 | 2 |
388122 | 388122 | 2020-07-31 | Ottawa | Oklahoma | 40115 | 327 | 2 |
384905 | 384905 | 2020-07-30 | Ottawa | Oklahoma | 40115 | 311 | 2 |
381687 | 381687 | 2020-07-29 | Ottawa | Oklahoma | 40115 | 304 | 2 |
378470 | 378470 | 2020-07-28 | Ottawa | Oklahoma | 40115 | 297 | 2 |
375253 | 375253 | 2020-07-27 | Ottawa | Oklahoma | 40115 | 277 | 2 |
372041 | 372041 | 2020-07-26 | Ottawa | Oklahoma | 40115 | 269 | 2 |
368829 | 368829 | 2020-07-25 | Ottawa | Oklahoma | 40115 | 260 | 2 |
365620 | 365620 | 2020-07-24 | Ottawa | Oklahoma | 40115 | 248 | 2 |
362414 | 362414 | 2020-07-23 | Ottawa | Oklahoma | 40115 | 244 | 2 |
359208 | 359208 | 2020-07-22 | Ottawa | Oklahoma | 40115 | 233 | 2 |
356004 | 356004 | 2020-07-21 | Ottawa | Oklahoma | 40115 | 224 | 2 |
352801 | 352801 | 2020-07-20 | Ottawa | Oklahoma | 40115 | 219 | 2 |
349598 | 349598 | 2020-07-19 | Ottawa | Oklahoma | 40115 | 219 | 2 |
346398 | 346398 | 2020-07-18 | Ottawa | Oklahoma | 40115 | 219 | 2 |
343198 | 343198 | 2020-07-17 | Ottawa | Oklahoma | 40115 | 203 | 2 |
340000 | 340000 | 2020-07-16 | Ottawa | Oklahoma | 40115 | 195 | 2 |
336804 | 336804 | 2020-07-15 | Ottawa | Oklahoma | 40115 | 190 | 2 |
333610 | 333610 | 2020-07-14 | Ottawa | Oklahoma | 40115 | 183 | 2 |
330418 | 330418 | 2020-07-13 | Ottawa | Oklahoma | 40115 | 157 | 2 |
327231 | 327231 | 2020-07-12 | Ottawa | Oklahoma | 40115 | 148 | 2 |
324046 | 324046 | 2020-07-11 | Ottawa | Oklahoma | 40115 | 141 | 2 |
320866 | 320866 | 2020-07-10 | Ottawa | Oklahoma | 40115 | 137 | 2 |
317689 | 317689 | 2020-07-09 | Ottawa | Oklahoma | 40115 | 132 | 2 |
314516 | 314516 | 2020-07-08 | Ottawa | Oklahoma | 40115 | 121 | 2 |
311344 | 311344 | 2020-07-07 | Ottawa | Oklahoma | 40115 | 120 | 2 |
308175 | 308175 | 2020-07-06 | Ottawa | Oklahoma | 40115 | 85 | 2 |
305008 | 305008 | 2020-07-05 | Ottawa | Oklahoma | 40115 | 81 | 2 |
301845 | 301845 | 2020-07-04 | Ottawa | Oklahoma | 40115 | 80 | 2 |
298682 | 298682 | 2020-07-03 | Ottawa | Oklahoma | 40115 | 77 | 2 |
295523 | 295523 | 2020-07-02 | Ottawa | Oklahoma | 40115 | 76 | 2 |
292367 | 292367 | 2020-07-01 | Ottawa | Oklahoma | 40115 | 73 | 2 |
289214 | 289214 | 2020-06-30 | Ottawa | Oklahoma | 40115 | 70 | 2 |
286064 | 286064 | 2020-06-29 | Ottawa | Oklahoma | 40115 | 50 | 2 |
282919 | 282919 | 2020-06-28 | Ottawa | Oklahoma | 40115 | 47 | 2 |
279773 | 279773 | 2020-06-27 | Ottawa | Oklahoma | 40115 | 44 | 2 |
276625 | 276625 | 2020-06-26 | Ottawa | Oklahoma | 40115 | 44 | 2 |
273478 | 273478 | 2020-06-25 | Ottawa | Oklahoma | 40115 | 44 | 2 |
270339 | 270339 | 2020-06-24 | Ottawa | Oklahoma | 40115 | 43 | 2 |
267205 | 267205 | 2020-06-23 | Ottawa | Oklahoma | 40115 | 43 | 2 |
264077 | 264077 | 2020-06-22 | Ottawa | Oklahoma | 40115 | 44 | 2 |
260949 | 260949 | 2020-06-21 | Ottawa | Oklahoma | 40115 | 44 | 2 |
257822 | 257822 | 2020-06-20 | Ottawa | Oklahoma | 40115 | 43 | 2 |
254696 | 254696 | 2020-06-19 | Ottawa | Oklahoma | 40115 | 42 | 2 |
251581 | 251581 | 2020-06-18 | Ottawa | Oklahoma | 40115 | 42 | 2 |
248466 | 248466 | 2020-06-17 | Ottawa | Oklahoma | 40115 | 42 | 2 |
245353 | 245353 | 2020-06-16 | Ottawa | Oklahoma | 40115 | 41 | 2 |
242241 | 242241 | 2020-06-15 | Ottawa | Oklahoma | 40115 | 37 | 2 |
239132 | 239132 | 2020-06-14 | Ottawa | Oklahoma | 40115 | 37 | 2 |
236024 | 236024 | 2020-06-13 | Ottawa | Oklahoma | 40115 | 37 | 2 |
232919 | 232919 | 2020-06-12 | Ottawa | Oklahoma | 40115 | 36 | 2 |
229814 | 229814 | 2020-06-11 | Ottawa | Oklahoma | 40115 | 36 | 2 |
226710 | 226710 | 2020-06-10 | Ottawa | Oklahoma | 40115 | 35 | 2 |
223610 | 223610 | 2020-06-09 | Ottawa | Oklahoma | 40115 | 35 | 2 |
220515 | 220515 | 2020-06-08 | Ottawa | Oklahoma | 40115 | 35 | 2 |
217423 | 217423 | 2020-06-07 | Ottawa | Oklahoma | 40115 | 35 | 2 |
214333 | 214333 | 2020-06-06 | Ottawa | Oklahoma | 40115 | 35 | 2 |
211247 | 211247 | 2020-06-05 | Ottawa | Oklahoma | 40115 | 35 | 2 |
208165 | 208165 | 2020-06-04 | Ottawa | Oklahoma | 40115 | 35 | 2 |
205084 | 205084 | 2020-06-03 | Ottawa | Oklahoma | 40115 | 35 | 2 |
202007 | 202007 | 2020-06-02 | Ottawa | Oklahoma | 40115 | 35 | 2 |
198932 | 198932 | 2020-06-01 | Ottawa | Oklahoma | 40115 | 35 | 2 |
195859 | 195859 | 2020-05-31 | Ottawa | Oklahoma | 40115 | 35 | 2 |
192790 | 192790 | 2020-05-30 | Ottawa | Oklahoma | 40115 | 35 | 2 |
189725 | 189725 | 2020-05-29 | Ottawa | Oklahoma | 40115 | 35 | 2 |
186664 | 186664 | 2020-05-28 | Ottawa | Oklahoma | 40115 | 35 | 2 |
183607 | 183607 | 2020-05-27 | Ottawa | Oklahoma | 40115 | 35 | 2 |
180558 | 180558 | 2020-05-26 | Ottawa | Oklahoma | 40115 | 35 | 2 |
177515 | 177515 | 2020-05-25 | Ottawa | Oklahoma | 40115 | 35 | 2 |
174471 | 174471 | 2020-05-24 | Ottawa | Oklahoma | 40115 | 35 | 2 |
171429 | 171429 | 2020-05-23 | Ottawa | Oklahoma | 40115 | 35 | 2 |
168390 | 168390 | 2020-05-22 | Ottawa | Oklahoma | 40115 | 35 | 2 |
165354 | 165354 | 2020-05-21 | Ottawa | Oklahoma | 40115 | 35 | 2 |
162325 | 162325 | 2020-05-20 | Ottawa | Oklahoma | 40115 | 35 | 2 |
159298 | 159298 | 2020-05-19 | Ottawa | Oklahoma | 40115 | 35 | 2 |
156277 | 156277 | 2020-05-18 | Ottawa | Oklahoma | 40115 | 35 | 2 |
153260 | 153260 | 2020-05-17 | Ottawa | Oklahoma | 40115 | 35 | 2 |
150249 | 150249 | 2020-05-16 | Ottawa | Oklahoma | 40115 | 34 | 2 |
147242 | 147242 | 2020-05-15 | Ottawa | Oklahoma | 40115 | 35 | 2 |
144161 | 144161 | 2020-05-14 | Ottawa | Ohio | 39123 | 56 | 2 |
144241 | 144241 | 2020-05-14 | Ottawa | Oklahoma | 40115 | 34 | 2 |
141166 | 141166 | 2020-05-13 | Ottawa | Ohio | 39123 | 52 | 2 |
141246 | 141246 | 2020-05-13 | Ottawa | Oklahoma | 40115 | 34 | 2 |
138170 | 138170 | 2020-05-12 | Ottawa | Ohio | 39123 | 49 | 2 |
138250 | 138250 | 2020-05-12 | Ottawa | Oklahoma | 40115 | 34 | 2 |
135180 | 135180 | 2020-05-11 | Ottawa | Ohio | 39123 | 47 | 2 |
132189 | 132189 | 2020-05-10 | Ottawa | Ohio | 39123 | 46 | 2 |
129200 | 129200 | 2020-05-09 | Ottawa | Ohio | 39123 | 46 | 2 |
126211 | 126211 | 2020-05-08 | Ottawa | Ohio | 39123 | 45 | 2 |
123228 | 123228 | 2020-05-07 | Ottawa | Ohio | 39123 | 44 | 2 |
120251 | 120251 | 2020-05-06 | Ottawa | Ohio | 39123 | 44 | 2 |
63060 | 63060 | 2020-04-16 | Ottawa | Michigan | 26139 | 82 | 2 |
60338 | 60338 | 2020-04-15 | Ottawa | Michigan | 26139 | 74 | 2 |
57628 | 57628 | 2020-04-14 | Ottawa | Michigan | 26139 | 67 | 2 |
54930 | 54930 | 2020-04-13 | Ottawa | Michigan | 26139 | 69 | 2 |
52248 | 52248 | 2020-04-12 | Ottawa | Michigan | 26139 | 66 | 2 |
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);