ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
658 rows where county = "Lake of the Woods" and state = "Minnesota" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
368008 | 368008 | 2020-07-25 | Lake of the Woods | Minnesota | 27077 | 1 | 0 |
371218 | 371218 | 2020-07-26 | Lake of the Woods | Minnesota | 27077 | 1 | 0 |
374430 | 374430 | 2020-07-27 | Lake of the Woods | Minnesota | 27077 | 1 | 0 |
377645 | 377645 | 2020-07-28 | Lake of the Woods | Minnesota | 27077 | 1 | 0 |
380862 | 380862 | 2020-07-29 | Lake of the Woods | Minnesota | 27077 | 1 | 0 |
384079 | 384079 | 2020-07-30 | Lake of the Woods | Minnesota | 27077 | 1 | 0 |
387297 | 387297 | 2020-07-31 | Lake of the Woods | Minnesota | 27077 | 1 | 0 |
390514 | 390514 | 2020-08-01 | Lake of the Woods | Minnesota | 27077 | 1 | 0 |
393731 | 393731 | 2020-08-02 | Lake of the Woods | Minnesota | 27077 | 1 | 0 |
396947 | 396947 | 2020-08-03 | Lake of the Woods | Minnesota | 27077 | 1 | 0 |
400161 | 400161 | 2020-08-04 | Lake of the Woods | Minnesota | 27077 | 1 | 0 |
403378 | 403378 | 2020-08-05 | Lake of the Woods | Minnesota | 27077 | 1 | 0 |
406596 | 406596 | 2020-08-06 | Lake of the Woods | Minnesota | 27077 | 1 | 0 |
409816 | 409816 | 2020-08-07 | Lake of the Woods | Minnesota | 27077 | 2 | 0 |
413036 | 413036 | 2020-08-08 | Lake of the Woods | Minnesota | 27077 | 2 | 0 |
416256 | 416256 | 2020-08-09 | Lake of the Woods | Minnesota | 27077 | 2 | 0 |
419477 | 419477 | 2020-08-10 | Lake of the Woods | Minnesota | 27077 | 4 | 0 |
422699 | 422699 | 2020-08-11 | Lake of the Woods | Minnesota | 27077 | 4 | 0 |
425921 | 425921 | 2020-08-12 | Lake of the Woods | Minnesota | 27077 | 4 | 0 |
429145 | 429145 | 2020-08-13 | Lake of the Woods | Minnesota | 27077 | 4 | 0 |
432372 | 432372 | 2020-08-14 | Lake of the Woods | Minnesota | 27077 | 7 | 0 |
435598 | 435598 | 2020-08-15 | Lake of the Woods | Minnesota | 27077 | 7 | 0 |
438823 | 438823 | 2020-08-16 | Lake of the Woods | Minnesota | 27077 | 7 | 0 |
442050 | 442050 | 2020-08-17 | Lake of the Woods | Minnesota | 27077 | 7 | 0 |
445276 | 445276 | 2020-08-18 | Lake of the Woods | Minnesota | 27077 | 7 | 0 |
448502 | 448502 | 2020-08-19 | Lake of the Woods | Minnesota | 27077 | 7 | 0 |
451730 | 451730 | 2020-08-20 | Lake of the Woods | Minnesota | 27077 | 7 | 0 |
454958 | 454958 | 2020-08-21 | Lake of the Woods | Minnesota | 27077 | 7 | 0 |
458186 | 458186 | 2020-08-22 | Lake of the Woods | Minnesota | 27077 | 7 | 0 |
461413 | 461413 | 2020-08-23 | Lake of the Woods | Minnesota | 27077 | 7 | 0 |
464644 | 464644 | 2020-08-24 | Lake of the Woods | Minnesota | 27077 | 7 | 0 |
467873 | 467873 | 2020-08-25 | Lake of the Woods | Minnesota | 27077 | 7 | 0 |
471103 | 471103 | 2020-08-26 | Lake of the Woods | Minnesota | 27077 | 7 | 0 |
474335 | 474335 | 2020-08-27 | Lake of the Woods | Minnesota | 27077 | 7 | 0 |
477568 | 477568 | 2020-08-28 | Lake of the Woods | Minnesota | 27077 | 7 | 0 |
480800 | 480800 | 2020-08-29 | Lake of the Woods | Minnesota | 27077 | 7 | 0 |
484035 | 484035 | 2020-08-30 | Lake of the Woods | Minnesota | 27077 | 7 | 0 |
487269 | 487269 | 2020-08-31 | Lake of the Woods | Minnesota | 27077 | 7 | 0 |
490502 | 490502 | 2020-09-01 | Lake of the Woods | Minnesota | 27077 | 10 | 0 |
493736 | 493736 | 2020-09-02 | Lake of the Woods | Minnesota | 27077 | 13 | 0 |
496969 | 496969 | 2020-09-03 | Lake of the Woods | Minnesota | 27077 | 13 | 1 |
500203 | 500203 | 2020-09-04 | Lake of the Woods | Minnesota | 27077 | 14 | 1 |
503437 | 503437 | 2020-09-05 | Lake of the Woods | Minnesota | 27077 | 14 | 1 |
506670 | 506670 | 2020-09-06 | Lake of the Woods | Minnesota | 27077 | 14 | 1 |
509903 | 509903 | 2020-09-07 | Lake of the Woods | Minnesota | 27077 | 16 | 1 |
513135 | 513135 | 2020-09-08 | Lake of the Woods | Minnesota | 27077 | 16 | 1 |
516369 | 516369 | 2020-09-09 | Lake of the Woods | Minnesota | 27077 | 16 | 1 |
519604 | 519604 | 2020-09-10 | Lake of the Woods | Minnesota | 27077 | 16 | 1 |
522841 | 522841 | 2020-09-11 | Lake of the Woods | Minnesota | 27077 | 16 | 1 |
526077 | 526077 | 2020-09-12 | Lake of the Woods | Minnesota | 27077 | 18 | 1 |
529313 | 529313 | 2020-09-13 | Lake of the Woods | Minnesota | 27077 | 18 | 1 |
532549 | 532549 | 2020-09-14 | Lake of the Woods | Minnesota | 27077 | 20 | 1 |
535784 | 535784 | 2020-09-15 | Lake of the Woods | Minnesota | 27077 | 20 | 1 |
539021 | 539021 | 2020-09-16 | Lake of the Woods | Minnesota | 27077 | 20 | 1 |
542257 | 542257 | 2020-09-17 | Lake of the Woods | Minnesota | 27077 | 20 | 1 |
545494 | 545494 | 2020-09-18 | Lake of the Woods | Minnesota | 27077 | 20 | 1 |
548732 | 548732 | 2020-09-19 | Lake of the Woods | Minnesota | 27077 | 20 | 1 |
551971 | 551971 | 2020-09-20 | Lake of the Woods | Minnesota | 27077 | 20 | 1 |
555209 | 555209 | 2020-09-21 | Lake of the Woods | Minnesota | 27077 | 21 | 1 |
558446 | 558446 | 2020-09-22 | Lake of the Woods | Minnesota | 27077 | 21 | 1 |
561683 | 561683 | 2020-09-23 | Lake of the Woods | Minnesota | 27077 | 21 | 1 |
564923 | 564923 | 2020-09-24 | Lake of the Woods | Minnesota | 27077 | 21 | 1 |
568163 | 568163 | 2020-09-25 | Lake of the Woods | Minnesota | 27077 | 21 | 1 |
571405 | 571405 | 2020-09-26 | Lake of the Woods | Minnesota | 27077 | 22 | 1 |
574648 | 574648 | 2020-09-27 | Lake of the Woods | Minnesota | 27077 | 23 | 1 |
577889 | 577889 | 2020-09-28 | Lake of the Woods | Minnesota | 27077 | 23 | 1 |
581130 | 581130 | 2020-09-29 | Lake of the Woods | Minnesota | 27077 | 24 | 1 |
584371 | 584371 | 2020-09-30 | Lake of the Woods | Minnesota | 27077 | 24 | 1 |
587611 | 587611 | 2020-10-01 | Lake of the Woods | Minnesota | 27077 | 24 | 1 |
590852 | 590852 | 2020-10-02 | Lake of the Woods | Minnesota | 27077 | 25 | 1 |
594093 | 594093 | 2020-10-03 | Lake of the Woods | Minnesota | 27077 | 26 | 1 |
597334 | 597334 | 2020-10-04 | Lake of the Woods | Minnesota | 27077 | 26 | 1 |
600577 | 600577 | 2020-10-05 | Lake of the Woods | Minnesota | 27077 | 27 | 1 |
603819 | 603819 | 2020-10-06 | Lake of the Woods | Minnesota | 27077 | 26 | 1 |
607062 | 607062 | 2020-10-07 | Lake of the Woods | Minnesota | 27077 | 31 | 1 |
610304 | 610304 | 2020-10-08 | Lake of the Woods | Minnesota | 27077 | 34 | 1 |
613546 | 613546 | 2020-10-09 | Lake of the Woods | Minnesota | 27077 | 35 | 1 |
616787 | 616787 | 2020-10-10 | Lake of the Woods | Minnesota | 27077 | 35 | 1 |
620029 | 620029 | 2020-10-11 | Lake of the Woods | Minnesota | 27077 | 35 | 1 |
623272 | 623272 | 2020-10-12 | Lake of the Woods | Minnesota | 27077 | 37 | 1 |
626514 | 626514 | 2020-10-13 | Lake of the Woods | Minnesota | 27077 | 39 | 1 |
629758 | 629758 | 2020-10-14 | Lake of the Woods | Minnesota | 27077 | 39 | 1 |
633003 | 633003 | 2020-10-15 | Lake of the Woods | Minnesota | 27077 | 39 | 1 |
636249 | 636249 | 2020-10-16 | Lake of the Woods | Minnesota | 27077 | 39 | 1 |
639495 | 639495 | 2020-10-17 | Lake of the Woods | Minnesota | 27077 | 40 | 1 |
642742 | 642742 | 2020-10-18 | Lake of the Woods | Minnesota | 27077 | 40 | 1 |
645989 | 645989 | 2020-10-19 | Lake of the Woods | Minnesota | 27077 | 42 | 1 |
649233 | 649233 | 2020-10-20 | Lake of the Woods | Minnesota | 27077 | 42 | 1 |
652478 | 652478 | 2020-10-21 | Lake of the Woods | Minnesota | 27077 | 43 | 1 |
655723 | 655723 | 2020-10-22 | Lake of the Woods | Minnesota | 27077 | 43 | 1 |
658968 | 658968 | 2020-10-23 | Lake of the Woods | Minnesota | 27077 | 44 | 1 |
662212 | 662212 | 2020-10-24 | Lake of the Woods | Minnesota | 27077 | 44 | 1 |
665457 | 665457 | 2020-10-25 | Lake of the Woods | Minnesota | 27077 | 44 | 1 |
668701 | 668701 | 2020-10-26 | Lake of the Woods | Minnesota | 27077 | 44 | 1 |
671943 | 671943 | 2020-10-27 | Lake of the Woods | Minnesota | 27077 | 44 | 1 |
675186 | 675186 | 2020-10-28 | Lake of the Woods | Minnesota | 27077 | 45 | 1 |
678428 | 678428 | 2020-10-29 | Lake of the Woods | Minnesota | 27077 | 44 | 1 |
681672 | 681672 | 2020-10-30 | Lake of the Woods | Minnesota | 27077 | 47 | 1 |
684915 | 684915 | 2020-10-31 | Lake of the Woods | Minnesota | 27077 | 49 | 1 |
688159 | 688159 | 2020-11-01 | Lake of the Woods | Minnesota | 27077 | 50 | 1 |
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);