ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
737 rows where county = "Lake" and fips = 27075 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054870 | 1054870 | 2021-02-22 | Lake | Minnesota | 27075 | 721 | 17 |
1051623 | 1051623 | 2021-02-21 | Lake | Minnesota | 27075 | 719 | 17 |
1048376 | 1048376 | 2021-02-20 | Lake | Minnesota | 27075 | 718 | 17 |
1045130 | 1045130 | 2021-02-19 | Lake | Minnesota | 27075 | 714 | 17 |
1041885 | 1041885 | 2021-02-18 | Lake | Minnesota | 27075 | 713 | 17 |
1038640 | 1038640 | 2021-02-17 | Lake | Minnesota | 27075 | 710 | 17 |
1035395 | 1035395 | 2021-02-16 | Lake | Minnesota | 27075 | 706 | 17 |
1032150 | 1032150 | 2021-02-15 | Lake | Minnesota | 27075 | 702 | 17 |
1028903 | 1028903 | 2021-02-14 | Lake | Minnesota | 27075 | 697 | 17 |
1025657 | 1025657 | 2021-02-13 | Lake | Minnesota | 27075 | 695 | 17 |
1022412 | 1022412 | 2021-02-12 | Lake | Minnesota | 27075 | 692 | 17 |
1019167 | 1019167 | 2021-02-11 | Lake | Minnesota | 27075 | 690 | 17 |
1015922 | 1015922 | 2021-02-10 | Lake | Minnesota | 27075 | 689 | 16 |
1012677 | 1012677 | 2021-02-09 | Lake | Minnesota | 27075 | 686 | 16 |
1009432 | 1009432 | 2021-02-08 | Lake | Minnesota | 27075 | 684 | 16 |
1006185 | 1006185 | 2021-02-07 | Lake | Minnesota | 27075 | 682 | 16 |
1002939 | 1002939 | 2021-02-06 | Lake | Minnesota | 27075 | 681 | 16 |
999694 | 999694 | 2021-02-05 | Lake | Minnesota | 27075 | 681 | 16 |
996448 | 996448 | 2021-02-04 | Lake | Minnesota | 27075 | 680 | 16 |
993202 | 993202 | 2021-02-03 | Lake | Minnesota | 27075 | 678 | 16 |
989956 | 989956 | 2021-02-02 | Lake | Minnesota | 27075 | 674 | 16 |
986709 | 986709 | 2021-02-01 | Lake | Minnesota | 27075 | 675 | 16 |
983462 | 983462 | 2021-01-31 | Lake | Minnesota | 27075 | 675 | 16 |
980216 | 980216 | 2021-01-30 | Lake | Minnesota | 27075 | 673 | 16 |
976970 | 976970 | 2021-01-29 | Lake | Minnesota | 27075 | 669 | 15 |
973725 | 973725 | 2021-01-28 | Lake | Minnesota | 27075 | 669 | 15 |
970480 | 970480 | 2021-01-27 | Lake | Minnesota | 27075 | 665 | 15 |
967235 | 967235 | 2021-01-26 | Lake | Minnesota | 27075 | 665 | 15 |
963991 | 963991 | 2021-01-25 | Lake | Minnesota | 27075 | 664 | 15 |
960746 | 960746 | 2021-01-24 | Lake | Minnesota | 27075 | 663 | 15 |
957500 | 957500 | 2021-01-23 | Lake | Minnesota | 27075 | 663 | 15 |
954255 | 954255 | 2021-01-22 | Lake | Minnesota | 27075 | 660 | 15 |
951010 | 951010 | 2021-01-21 | Lake | Minnesota | 27075 | 656 | 15 |
947764 | 947764 | 2021-01-20 | Lake | Minnesota | 27075 | 649 | 15 |
944517 | 944517 | 2021-01-19 | Lake | Minnesota | 27075 | 637 | 15 |
941272 | 941272 | 2021-01-18 | Lake | Minnesota | 27075 | 636 | 15 |
938027 | 938027 | 2021-01-17 | Lake | Minnesota | 27075 | 632 | 15 |
934782 | 934782 | 2021-01-16 | Lake | Minnesota | 27075 | 629 | 15 |
931537 | 931537 | 2021-01-15 | Lake | Minnesota | 27075 | 626 | 15 |
928292 | 928292 | 2021-01-14 | Lake | Minnesota | 27075 | 622 | 15 |
925046 | 925046 | 2021-01-13 | Lake | Minnesota | 27075 | 614 | 15 |
921801 | 921801 | 2021-01-12 | Lake | Minnesota | 27075 | 604 | 15 |
918556 | 918556 | 2021-01-11 | Lake | Minnesota | 27075 | 603 | 15 |
915311 | 915311 | 2021-01-10 | Lake | Minnesota | 27075 | 599 | 15 |
912066 | 912066 | 2021-01-09 | Lake | Minnesota | 27075 | 589 | 15 |
908821 | 908821 | 2021-01-08 | Lake | Minnesota | 27075 | 581 | 15 |
905575 | 905575 | 2021-01-07 | Lake | Minnesota | 27075 | 576 | 15 |
902330 | 902330 | 2021-01-06 | Lake | Minnesota | 27075 | 574 | 15 |
899085 | 899085 | 2021-01-05 | Lake | Minnesota | 27075 | 566 | 15 |
895840 | 895840 | 2021-01-04 | Lake | Minnesota | 27075 | 565 | 15 |
892593 | 892593 | 2021-01-03 | Lake | Minnesota | 27075 | 560 | 15 |
889347 | 889347 | 2021-01-02 | Lake | Minnesota | 27075 | 556 | 15 |
886101 | 886101 | 2021-01-01 | Lake | Minnesota | 27075 | 547 | 15 |
882856 | 882856 | 2020-12-31 | Lake | Minnesota | 27075 | 547 | 15 |
879611 | 879611 | 2020-12-30 | Lake | Minnesota | 27075 | 544 | 15 |
876366 | 876366 | 2020-12-29 | Lake | Minnesota | 27075 | 539 | 15 |
873121 | 873121 | 2020-12-28 | Lake | Minnesota | 27075 | 539 | 15 |
869876 | 869876 | 2020-12-27 | Lake | Minnesota | 27075 | 536 | 15 |
866631 | 866631 | 2020-12-26 | Lake | Minnesota | 27075 | 529 | 15 |
863386 | 863386 | 2020-12-25 | Lake | Minnesota | 27075 | 528 | 15 |
860141 | 860141 | 2020-12-24 | Lake | Minnesota | 27075 | 528 | 15 |
856896 | 856896 | 2020-12-23 | Lake | Minnesota | 27075 | 527 | 15 |
853651 | 853651 | 2020-12-22 | Lake | Minnesota | 27075 | 525 | 14 |
850406 | 850406 | 2020-12-21 | Lake | Minnesota | 27075 | 522 | 14 |
847161 | 847161 | 2020-12-20 | Lake | Minnesota | 27075 | 515 | 14 |
843915 | 843915 | 2020-12-19 | Lake | Minnesota | 27075 | 514 | 14 |
840670 | 840670 | 2020-12-18 | Lake | Minnesota | 27075 | 507 | 14 |
837425 | 837425 | 2020-12-17 | Lake | Minnesota | 27075 | 506 | 13 |
834179 | 834179 | 2020-12-16 | Lake | Minnesota | 27075 | 505 | 13 |
830932 | 830932 | 2020-12-15 | Lake | Minnesota | 27075 | 502 | 11 |
827686 | 827686 | 2020-12-14 | Lake | Minnesota | 27075 | 497 | 11 |
824439 | 824439 | 2020-12-13 | Lake | Minnesota | 27075 | 496 | 11 |
821193 | 821193 | 2020-12-12 | Lake | Minnesota | 27075 | 492 | 11 |
817947 | 817947 | 2020-12-11 | Lake | Minnesota | 27075 | 486 | 10 |
814701 | 814701 | 2020-12-10 | Lake | Minnesota | 27075 | 481 | 10 |
811456 | 811456 | 2020-12-09 | Lake | Minnesota | 27075 | 480 | 10 |
808211 | 808211 | 2020-12-08 | Lake | Minnesota | 27075 | 477 | 8 |
804966 | 804966 | 2020-12-07 | Lake | Minnesota | 27075 | 477 | 8 |
801721 | 801721 | 2020-12-06 | Lake | Minnesota | 27075 | 470 | 8 |
798476 | 798476 | 2020-12-05 | Lake | Minnesota | 27075 | 462 | 8 |
795231 | 795231 | 2020-12-04 | Lake | Minnesota | 27075 | 457 | 8 |
791986 | 791986 | 2020-12-03 | Lake | Minnesota | 27075 | 451 | 8 |
788741 | 788741 | 2020-12-02 | Lake | Minnesota | 27075 | 443 | 7 |
785496 | 785496 | 2020-12-01 | Lake | Minnesota | 27075 | 433 | 6 |
782252 | 782252 | 2020-11-30 | Lake | Minnesota | 27075 | 432 | 6 |
779006 | 779006 | 2020-11-29 | Lake | Minnesota | 27075 | 422 | 6 |
775761 | 775761 | 2020-11-28 | Lake | Minnesota | 27075 | 406 | 6 |
772516 | 772516 | 2020-11-27 | Lake | Minnesota | 27075 | 391 | 6 |
769271 | 769271 | 2020-11-26 | Lake | Minnesota | 27075 | 381 | 6 |
766025 | 766025 | 2020-11-25 | Lake | Minnesota | 27075 | 381 | 6 |
762780 | 762780 | 2020-11-24 | Lake | Minnesota | 27075 | 365 | 4 |
759535 | 759535 | 2020-11-23 | Lake | Minnesota | 27075 | 358 | 4 |
756288 | 756288 | 2020-11-22 | Lake | Minnesota | 27075 | 346 | 3 |
753042 | 753042 | 2020-11-21 | Lake | Minnesota | 27075 | 326 | 3 |
749796 | 749796 | 2020-11-20 | Lake | Minnesota | 27075 | 304 | 3 |
746550 | 746550 | 2020-11-19 | Lake | Minnesota | 27075 | 285 | 1 |
743303 | 743303 | 2020-11-18 | Lake | Minnesota | 27075 | 266 | 1 |
740056 | 740056 | 2020-11-17 | Lake | Minnesota | 27075 | 255 | 1 |
736812 | 736812 | 2020-11-16 | Lake | Minnesota | 27075 | 240 | 1 |
733566 | 733566 | 2020-11-15 | Lake | Minnesota | 27075 | 233 | 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);