ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 27099 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921813 | 921813 | 2021-01-12 | Mower | Minnesota | 27099 | 3537 | 26 |
918568 | 918568 | 2021-01-11 | Mower | Minnesota | 27099 | 3494 | 26 |
915323 | 915323 | 2021-01-10 | Mower | Minnesota | 27099 | 3492 | 26 |
912078 | 912078 | 2021-01-09 | Mower | Minnesota | 27099 | 3479 | 26 |
908833 | 908833 | 2021-01-08 | Mower | Minnesota | 27099 | 3444 | 26 |
905587 | 905587 | 2021-01-07 | Mower | Minnesota | 27099 | 3417 | 26 |
902342 | 902342 | 2021-01-06 | Mower | Minnesota | 27099 | 3401 | 26 |
899097 | 899097 | 2021-01-05 | Mower | Minnesota | 27099 | 3392 | 25 |
895852 | 895852 | 2021-01-04 | Mower | Minnesota | 27099 | 3378 | 25 |
892605 | 892605 | 2021-01-03 | Mower | Minnesota | 27099 | 3355 | 25 |
889359 | 889359 | 2021-01-02 | Mower | Minnesota | 27099 | 3343 | 25 |
886113 | 886113 | 2021-01-01 | Mower | Minnesota | 27099 | 3321 | 25 |
882868 | 882868 | 2020-12-31 | Mower | Minnesota | 27099 | 3321 | 25 |
879623 | 879623 | 2020-12-30 | Mower | Minnesota | 27099 | 3304 | 25 |
876378 | 876378 | 2020-12-29 | Mower | Minnesota | 27099 | 3299 | 24 |
873133 | 873133 | 2020-12-28 | Mower | Minnesota | 27099 | 3296 | 24 |
869888 | 869888 | 2020-12-27 | Mower | Minnesota | 27099 | 3293 | 24 |
866643 | 866643 | 2020-12-26 | Mower | Minnesota | 27099 | 3278 | 24 |
863398 | 863398 | 2020-12-25 | Mower | Minnesota | 27099 | 3265 | 24 |
860153 | 860153 | 2020-12-24 | Mower | Minnesota | 27099 | 3265 | 24 |
856908 | 856908 | 2020-12-23 | Mower | Minnesota | 27099 | 3245 | 23 |
853663 | 853663 | 2020-12-22 | Mower | Minnesota | 27099 | 3236 | 23 |
850418 | 850418 | 2020-12-21 | Mower | Minnesota | 27099 | 3228 | 23 |
847173 | 847173 | 2020-12-20 | Mower | Minnesota | 27099 | 3221 | 23 |
843927 | 843927 | 2020-12-19 | Mower | Minnesota | 27099 | 3205 | 23 |
840682 | 840682 | 2020-12-18 | Mower | Minnesota | 27099 | 3187 | 23 |
837437 | 837437 | 2020-12-17 | Mower | Minnesota | 27099 | 3143 | 23 |
834191 | 834191 | 2020-12-16 | Mower | Minnesota | 27099 | 3128 | 24 |
830944 | 830944 | 2020-12-15 | Mower | Minnesota | 27099 | 3113 | 23 |
827698 | 827698 | 2020-12-14 | Mower | Minnesota | 27099 | 3105 | 23 |
824451 | 824451 | 2020-12-13 | Mower | Minnesota | 27099 | 3086 | 23 |
821205 | 821205 | 2020-12-12 | Mower | Minnesota | 27099 | 3060 | 23 |
817959 | 817959 | 2020-12-11 | Mower | Minnesota | 27099 | 3027 | 23 |
814713 | 814713 | 2020-12-10 | Mower | Minnesota | 27099 | 3006 | 23 |
811468 | 811468 | 2020-12-09 | Mower | Minnesota | 27099 | 2981 | 23 |
808223 | 808223 | 2020-12-08 | Mower | Minnesota | 27099 | 2946 | 23 |
804978 | 804978 | 2020-12-07 | Mower | Minnesota | 27099 | 2921 | 23 |
801733 | 801733 | 2020-12-06 | Mower | Minnesota | 27099 | 2886 | 23 |
798488 | 798488 | 2020-12-05 | Mower | Minnesota | 27099 | 2861 | 23 |
795243 | 795243 | 2020-12-04 | Mower | Minnesota | 27099 | 2791 | 23 |
791998 | 791998 | 2020-12-03 | Mower | Minnesota | 27099 | 2748 | 23 |
788753 | 788753 | 2020-12-02 | Mower | Minnesota | 27099 | 2706 | 23 |
785508 | 785508 | 2020-12-01 | Mower | Minnesota | 27099 | 2674 | 23 |
782264 | 782264 | 2020-11-30 | Mower | Minnesota | 27099 | 2658 | 23 |
779018 | 779018 | 2020-11-29 | Mower | Minnesota | 27099 | 2616 | 23 |
775773 | 775773 | 2020-11-28 | Mower | Minnesota | 27099 | 2574 | 23 |
772528 | 772528 | 2020-11-27 | Mower | Minnesota | 27099 | 2485 | 23 |
769283 | 769283 | 2020-11-26 | Mower | Minnesota | 27099 | 2413 | 23 |
766037 | 766037 | 2020-11-25 | Mower | Minnesota | 27099 | 2413 | 23 |
762792 | 762792 | 2020-11-24 | Mower | Minnesota | 27099 | 2397 | 23 |
759547 | 759547 | 2020-11-23 | Mower | Minnesota | 27099 | 2367 | 22 |
756300 | 756300 | 2020-11-22 | Mower | Minnesota | 27099 | 2328 | 22 |
753054 | 753054 | 2020-11-21 | Mower | Minnesota | 27099 | 2256 | 22 |
749808 | 749808 | 2020-11-20 | Mower | Minnesota | 27099 | 2228 | 22 |
746562 | 746562 | 2020-11-19 | Mower | Minnesota | 27099 | 2155 | 22 |
743315 | 743315 | 2020-11-18 | Mower | Minnesota | 27099 | 2081 | 22 |
740068 | 740068 | 2020-11-17 | Mower | Minnesota | 27099 | 2065 | 22 |
736824 | 736824 | 2020-11-16 | Mower | Minnesota | 27099 | 2037 | 21 |
733578 | 733578 | 2020-11-15 | Mower | Minnesota | 27099 | 1931 | 21 |
730333 | 730333 | 2020-11-14 | Mower | Minnesota | 27099 | 1752 | 21 |
727090 | 727090 | 2020-11-13 | Mower | Minnesota | 27099 | 1720 | 21 |
723847 | 723847 | 2020-11-12 | Mower | Minnesota | 27099 | 1713 | 21 |
720604 | 720604 | 2020-11-11 | Mower | Minnesota | 27099 | 1704 | 21 |
717361 | 717361 | 2020-11-10 | Mower | Minnesota | 27099 | 1703 | 21 |
714117 | 714117 | 2020-11-09 | Mower | Minnesota | 27099 | 1698 | 21 |
710873 | 710873 | 2020-11-08 | Mower | Minnesota | 27099 | 1683 | 21 |
707629 | 707629 | 2020-11-07 | Mower | Minnesota | 27099 | 1677 | 21 |
704386 | 704386 | 2020-11-06 | Mower | Minnesota | 27099 | 1647 | 21 |
701144 | 701144 | 2020-11-05 | Mower | Minnesota | 27099 | 1621 | 21 |
697900 | 697900 | 2020-11-04 | Mower | Minnesota | 27099 | 1614 | 20 |
694657 | 694657 | 2020-11-03 | Mower | Minnesota | 27099 | 1597 | 20 |
691415 | 691415 | 2020-11-02 | Mower | Minnesota | 27099 | 1595 | 19 |
688170 | 688170 | 2020-11-01 | Mower | Minnesota | 27099 | 1572 | 19 |
684926 | 684926 | 2020-10-31 | Mower | Minnesota | 27099 | 1560 | 19 |
681683 | 681683 | 2020-10-30 | Mower | Minnesota | 27099 | 1553 | 18 |
678439 | 678439 | 2020-10-29 | Mower | Minnesota | 27099 | 1545 | 18 |
675197 | 675197 | 2020-10-28 | Mower | Minnesota | 27099 | 1539 | 18 |
671954 | 671954 | 2020-10-27 | Mower | Minnesota | 27099 | 1535 | 17 |
668712 | 668712 | 2020-10-26 | Mower | Minnesota | 27099 | 1529 | 17 |
665468 | 665468 | 2020-10-25 | Mower | Minnesota | 27099 | 1517 | 17 |
662223 | 662223 | 2020-10-24 | Mower | Minnesota | 27099 | 1508 | 15 |
658979 | 658979 | 2020-10-23 | Mower | Minnesota | 27099 | 1503 | 15 |
655734 | 655734 | 2020-10-22 | Mower | Minnesota | 27099 | 1499 | 15 |
652489 | 652489 | 2020-10-21 | Mower | Minnesota | 27099 | 1494 | 15 |
649244 | 649244 | 2020-10-20 | Mower | Minnesota | 27099 | 1491 | 13 |
646000 | 646000 | 2020-10-19 | Mower | Minnesota | 27099 | 1489 | 12 |
642753 | 642753 | 2020-10-18 | Mower | Minnesota | 27099 | 1489 | 12 |
639506 | 639506 | 2020-10-17 | Mower | Minnesota | 27099 | 1484 | 11 |
636260 | 636260 | 2020-10-16 | Mower | Minnesota | 27099 | 1473 | 11 |
633014 | 633014 | 2020-10-15 | Mower | Minnesota | 27099 | 1454 | 7 |
629769 | 629769 | 2020-10-14 | Mower | Minnesota | 27099 | 1453 | 7 |
626525 | 626525 | 2020-10-13 | Mower | Minnesota | 27099 | 1431 | 7 |
623283 | 623283 | 2020-10-12 | Mower | Minnesota | 27099 | 1429 | 7 |
620040 | 620040 | 2020-10-11 | Mower | Minnesota | 27099 | 1427 | 7 |
616798 | 616798 | 2020-10-10 | Mower | Minnesota | 27099 | 1421 | 7 |
613557 | 613557 | 2020-10-09 | Mower | Minnesota | 27099 | 1401 | 7 |
610315 | 610315 | 2020-10-08 | Mower | Minnesota | 27099 | 1395 | 7 |
607073 | 607073 | 2020-10-07 | Mower | Minnesota | 27099 | 1391 | 6 |
603830 | 603830 | 2020-10-06 | Mower | Minnesota | 27099 | 1384 | 6 |
600588 | 600588 | 2020-10-05 | Mower | Minnesota | 27099 | 1377 | 6 |
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);