ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
49 rows where county = "Otter Tail", deaths = 4 and state = "Minnesota" 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 |
---|---|---|---|---|---|---|---|
584388 | 584388 | 2020-09-30 | Otter Tail | Minnesota | 27111 | 473 | 4 |
581147 | 581147 | 2020-09-29 | Otter Tail | Minnesota | 27111 | 469 | 4 |
577906 | 577906 | 2020-09-28 | Otter Tail | Minnesota | 27111 | 462 | 4 |
574665 | 574665 | 2020-09-27 | Otter Tail | Minnesota | 27111 | 445 | 4 |
571422 | 571422 | 2020-09-26 | Otter Tail | Minnesota | 27111 | 441 | 4 |
568180 | 568180 | 2020-09-25 | Otter Tail | Minnesota | 27111 | 430 | 4 |
564940 | 564940 | 2020-09-24 | Otter Tail | Minnesota | 27111 | 422 | 4 |
561700 | 561700 | 2020-09-23 | Otter Tail | Minnesota | 27111 | 407 | 4 |
558463 | 558463 | 2020-09-22 | Otter Tail | Minnesota | 27111 | 402 | 4 |
555226 | 555226 | 2020-09-21 | Otter Tail | Minnesota | 27111 | 400 | 4 |
551988 | 551988 | 2020-09-20 | Otter Tail | Minnesota | 27111 | 392 | 4 |
548749 | 548749 | 2020-09-19 | Otter Tail | Minnesota | 27111 | 379 | 4 |
545511 | 545511 | 2020-09-18 | Otter Tail | Minnesota | 27111 | 373 | 4 |
542274 | 542274 | 2020-09-17 | Otter Tail | Minnesota | 27111 | 367 | 4 |
539038 | 539038 | 2020-09-16 | Otter Tail | Minnesota | 27111 | 354 | 4 |
535801 | 535801 | 2020-09-15 | Otter Tail | Minnesota | 27111 | 349 | 4 |
532566 | 532566 | 2020-09-14 | Otter Tail | Minnesota | 27111 | 347 | 4 |
529330 | 529330 | 2020-09-13 | Otter Tail | Minnesota | 27111 | 339 | 4 |
526094 | 526094 | 2020-09-12 | Otter Tail | Minnesota | 27111 | 333 | 4 |
522858 | 522858 | 2020-09-11 | Otter Tail | Minnesota | 27111 | 325 | 4 |
519621 | 519621 | 2020-09-10 | Otter Tail | Minnesota | 27111 | 322 | 4 |
516386 | 516386 | 2020-09-09 | Otter Tail | Minnesota | 27111 | 324 | 4 |
513152 | 513152 | 2020-09-08 | Otter Tail | Minnesota | 27111 | 324 | 4 |
509920 | 509920 | 2020-09-07 | Otter Tail | Minnesota | 27111 | 323 | 4 |
506687 | 506687 | 2020-09-06 | Otter Tail | Minnesota | 27111 | 320 | 4 |
503454 | 503454 | 2020-09-05 | Otter Tail | Minnesota | 27111 | 315 | 4 |
500220 | 500220 | 2020-09-04 | Otter Tail | Minnesota | 27111 | 310 | 4 |
496986 | 496986 | 2020-09-03 | Otter Tail | Minnesota | 27111 | 305 | 4 |
493753 | 493753 | 2020-09-02 | Otter Tail | Minnesota | 27111 | 297 | 4 |
490519 | 490519 | 2020-09-01 | Otter Tail | Minnesota | 27111 | 299 | 4 |
487286 | 487286 | 2020-08-31 | Otter Tail | Minnesota | 27111 | 294 | 4 |
484052 | 484052 | 2020-08-30 | Otter Tail | Minnesota | 27111 | 293 | 4 |
480817 | 480817 | 2020-08-29 | Otter Tail | Minnesota | 27111 | 277 | 4 |
477585 | 477585 | 2020-08-28 | Otter Tail | Minnesota | 27111 | 268 | 4 |
474352 | 474352 | 2020-08-27 | Otter Tail | Minnesota | 27111 | 263 | 4 |
471120 | 471120 | 2020-08-26 | Otter Tail | Minnesota | 27111 | 257 | 4 |
467890 | 467890 | 2020-08-25 | Otter Tail | Minnesota | 27111 | 252 | 4 |
464661 | 464661 | 2020-08-24 | Otter Tail | Minnesota | 27111 | 245 | 4 |
461430 | 461430 | 2020-08-23 | Otter Tail | Minnesota | 27111 | 242 | 4 |
458203 | 458203 | 2020-08-22 | Otter Tail | Minnesota | 27111 | 240 | 4 |
454975 | 454975 | 2020-08-21 | Otter Tail | Minnesota | 27111 | 233 | 4 |
451747 | 451747 | 2020-08-20 | Otter Tail | Minnesota | 27111 | 229 | 4 |
448519 | 448519 | 2020-08-19 | Otter Tail | Minnesota | 27111 | 227 | 4 |
445293 | 445293 | 2020-08-18 | Otter Tail | Minnesota | 27111 | 227 | 4 |
442067 | 442067 | 2020-08-17 | Otter Tail | Minnesota | 27111 | 223 | 4 |
438840 | 438840 | 2020-08-16 | Otter Tail | Minnesota | 27111 | 217 | 4 |
435615 | 435615 | 2020-08-15 | Otter Tail | Minnesota | 27111 | 211 | 4 |
432389 | 432389 | 2020-08-14 | Otter Tail | Minnesota | 27111 | 209 | 4 |
429162 | 429162 | 2020-08-13 | Otter Tail | Minnesota | 27111 | 204 | 4 |
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);