ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Waseca" and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921845 | 921845 | 2021-01-12 | Waseca | Minnesota | 27161 | 1868 | 15 |
918600 | 918600 | 2021-01-11 | Waseca | Minnesota | 27161 | 1864 | 16 |
915355 | 915355 | 2021-01-10 | Waseca | Minnesota | 27161 | 1860 | 16 |
912110 | 912110 | 2021-01-09 | Waseca | Minnesota | 27161 | 1856 | 16 |
908865 | 908865 | 2021-01-08 | Waseca | Minnesota | 27161 | 1836 | 16 |
905619 | 905619 | 2021-01-07 | Waseca | Minnesota | 27161 | 1825 | 16 |
902374 | 902374 | 2021-01-06 | Waseca | Minnesota | 27161 | 1811 | 16 |
899129 | 899129 | 2021-01-05 | Waseca | Minnesota | 27161 | 1806 | 15 |
895884 | 895884 | 2021-01-04 | Waseca | Minnesota | 27161 | 1794 | 15 |
892637 | 892637 | 2021-01-03 | Waseca | Minnesota | 27161 | 1779 | 15 |
889391 | 889391 | 2021-01-02 | Waseca | Minnesota | 27161 | 1772 | 13 |
886145 | 886145 | 2021-01-01 | Waseca | Minnesota | 27161 | 1755 | 13 |
882900 | 882900 | 2020-12-31 | Waseca | Minnesota | 27161 | 1755 | 13 |
879655 | 879655 | 2020-12-30 | Waseca | Minnesota | 27161 | 1747 | 12 |
876410 | 876410 | 2020-12-29 | Waseca | Minnesota | 27161 | 1717 | 12 |
873165 | 873165 | 2020-12-28 | Waseca | Minnesota | 27161 | 1714 | 12 |
869920 | 869920 | 2020-12-27 | Waseca | Minnesota | 27161 | 1711 | 12 |
866675 | 866675 | 2020-12-26 | Waseca | Minnesota | 27161 | 1699 | 12 |
863430 | 863430 | 2020-12-25 | Waseca | Minnesota | 27161 | 1680 | 12 |
860185 | 860185 | 2020-12-24 | Waseca | Minnesota | 27161 | 1680 | 12 |
856940 | 856940 | 2020-12-23 | Waseca | Minnesota | 27161 | 1669 | 12 |
853695 | 853695 | 2020-12-22 | Waseca | Minnesota | 27161 | 1659 | 12 |
850450 | 850450 | 2020-12-21 | Waseca | Minnesota | 27161 | 1649 | 12 |
847205 | 847205 | 2020-12-20 | Waseca | Minnesota | 27161 | 1645 | 12 |
843959 | 843959 | 2020-12-19 | Waseca | Minnesota | 27161 | 1635 | 12 |
840714 | 840714 | 2020-12-18 | Waseca | Minnesota | 27161 | 1620 | 12 |
837469 | 837469 | 2020-12-17 | Waseca | Minnesota | 27161 | 1608 | 12 |
834223 | 834223 | 2020-12-16 | Waseca | Minnesota | 27161 | 1589 | 12 |
830976 | 830976 | 2020-12-15 | Waseca | Minnesota | 27161 | 1582 | 12 |
827730 | 827730 | 2020-12-14 | Waseca | Minnesota | 27161 | 1568 | 11 |
824483 | 824483 | 2020-12-13 | Waseca | Minnesota | 27161 | 1565 | 11 |
821237 | 821237 | 2020-12-12 | Waseca | Minnesota | 27161 | 1551 | 11 |
817991 | 817991 | 2020-12-11 | Waseca | Minnesota | 27161 | 1536 | 11 |
814745 | 814745 | 2020-12-10 | Waseca | Minnesota | 27161 | 1530 | 11 |
811500 | 811500 | 2020-12-09 | Waseca | Minnesota | 27161 | 1507 | 11 |
808255 | 808255 | 2020-12-08 | Waseca | Minnesota | 27161 | 1489 | 11 |
805010 | 805010 | 2020-12-07 | Waseca | Minnesota | 27161 | 1478 | 11 |
801765 | 801765 | 2020-12-06 | Waseca | Minnesota | 27161 | 1473 | 11 |
798520 | 798520 | 2020-12-05 | Waseca | Minnesota | 27161 | 1463 | 11 |
795275 | 795275 | 2020-12-04 | Waseca | Minnesota | 27161 | 1453 | 11 |
792030 | 792030 | 2020-12-03 | Waseca | Minnesota | 27161 | 1434 | 11 |
788785 | 788785 | 2020-12-02 | Waseca | Minnesota | 27161 | 1418 | 11 |
785540 | 785540 | 2020-12-01 | Waseca | Minnesota | 27161 | 1406 | 11 |
782296 | 782296 | 2020-11-30 | Waseca | Minnesota | 27161 | 1398 | 11 |
779050 | 779050 | 2020-11-29 | Waseca | Minnesota | 27161 | 1392 | 11 |
775805 | 775805 | 2020-11-28 | Waseca | Minnesota | 27161 | 1378 | 11 |
772560 | 772560 | 2020-11-27 | Waseca | Minnesota | 27161 | 1359 | 11 |
769315 | 769315 | 2020-11-26 | Waseca | Minnesota | 27161 | 1340 | 11 |
766069 | 766069 | 2020-11-25 | Waseca | Minnesota | 27161 | 1340 | 11 |
762824 | 762824 | 2020-11-24 | Waseca | Minnesota | 27161 | 1318 | 11 |
759579 | 759579 | 2020-11-23 | Waseca | Minnesota | 27161 | 1297 | 10 |
756332 | 756332 | 2020-11-22 | Waseca | Minnesota | 27161 | 1287 | 10 |
753086 | 753086 | 2020-11-21 | Waseca | Minnesota | 27161 | 1254 | 10 |
749840 | 749840 | 2020-11-20 | Waseca | Minnesota | 27161 | 1223 | 10 |
746594 | 746594 | 2020-11-19 | Waseca | Minnesota | 27161 | 1201 | 10 |
743347 | 743347 | 2020-11-18 | Waseca | Minnesota | 27161 | 1175 | 10 |
740100 | 740100 | 2020-11-17 | Waseca | Minnesota | 27161 | 1157 | 10 |
736856 | 736856 | 2020-11-16 | Waseca | Minnesota | 27161 | 1149 | 10 |
733610 | 733610 | 2020-11-15 | Waseca | Minnesota | 27161 | 1115 | 10 |
730365 | 730365 | 2020-11-14 | Waseca | Minnesota | 27161 | 1048 | 10 |
727122 | 727122 | 2020-11-13 | Waseca | Minnesota | 27161 | 1031 | 10 |
723879 | 723879 | 2020-11-12 | Waseca | Minnesota | 27161 | 1026 | 10 |
720636 | 720636 | 2020-11-11 | Waseca | Minnesota | 27161 | 1017 | 10 |
717393 | 717393 | 2020-11-10 | Waseca | Minnesota | 27161 | 1017 | 10 |
714149 | 714149 | 2020-11-09 | Waseca | Minnesota | 27161 | 1013 | 10 |
710905 | 710905 | 2020-11-08 | Waseca | Minnesota | 27161 | 1012 | 10 |
707661 | 707661 | 2020-11-07 | Waseca | Minnesota | 27161 | 1004 | 10 |
704418 | 704418 | 2020-11-06 | Waseca | Minnesota | 27161 | 995 | 10 |
701176 | 701176 | 2020-11-05 | Waseca | Minnesota | 27161 | 983 | 10 |
697932 | 697932 | 2020-11-04 | Waseca | Minnesota | 27161 | 981 | 10 |
694689 | 694689 | 2020-11-03 | Waseca | Minnesota | 27161 | 967 | 10 |
691447 | 691447 | 2020-11-02 | Waseca | Minnesota | 27161 | 965 | 10 |
688202 | 688202 | 2020-11-01 | Waseca | Minnesota | 27161 | 961 | 10 |
684958 | 684958 | 2020-10-31 | Waseca | Minnesota | 27161 | 956 | 10 |
681715 | 681715 | 2020-10-30 | Waseca | Minnesota | 27161 | 950 | 10 |
678471 | 678471 | 2020-10-29 | Waseca | Minnesota | 27161 | 945 | 10 |
675229 | 675229 | 2020-10-28 | Waseca | Minnesota | 27161 | 941 | 9 |
671986 | 671986 | 2020-10-27 | Waseca | Minnesota | 27161 | 937 | 9 |
668744 | 668744 | 2020-10-26 | Waseca | Minnesota | 27161 | 929 | 9 |
665500 | 665500 | 2020-10-25 | Waseca | Minnesota | 27161 | 928 | 9 |
662255 | 662255 | 2020-10-24 | Waseca | Minnesota | 27161 | 927 | 9 |
659011 | 659011 | 2020-10-23 | Waseca | Minnesota | 27161 | 922 | 9 |
655766 | 655766 | 2020-10-22 | Waseca | Minnesota | 27161 | 919 | 9 |
652521 | 652521 | 2020-10-21 | Waseca | Minnesota | 27161 | 918 | 9 |
649276 | 649276 | 2020-10-20 | Waseca | Minnesota | 27161 | 911 | 9 |
646032 | 646032 | 2020-10-19 | Waseca | Minnesota | 27161 | 912 | 9 |
642785 | 642785 | 2020-10-18 | Waseca | Minnesota | 27161 | 908 | 9 |
639538 | 639538 | 2020-10-17 | Waseca | Minnesota | 27161 | 904 | 9 |
636292 | 636292 | 2020-10-16 | Waseca | Minnesota | 27161 | 893 | 9 |
633046 | 633046 | 2020-10-15 | Waseca | Minnesota | 27161 | 885 | 9 |
629801 | 629801 | 2020-10-14 | Waseca | Minnesota | 27161 | 881 | 9 |
626557 | 626557 | 2020-10-13 | Waseca | Minnesota | 27161 | 878 | 9 |
623315 | 623315 | 2020-10-12 | Waseca | Minnesota | 27161 | 877 | 9 |
620072 | 620072 | 2020-10-11 | Waseca | Minnesota | 27161 | 875 | 9 |
616830 | 616830 | 2020-10-10 | Waseca | Minnesota | 27161 | 852 | 9 |
613589 | 613589 | 2020-10-09 | Waseca | Minnesota | 27161 | 844 | 9 |
610347 | 610347 | 2020-10-08 | Waseca | Minnesota | 27161 | 840 | 9 |
607105 | 607105 | 2020-10-07 | Waseca | Minnesota | 27161 | 837 | 9 |
603862 | 603862 | 2020-10-06 | Waseca | Minnesota | 27161 | 822 | 9 |
600620 | 600620 | 2020-10-05 | Waseca | Minnesota | 27161 | 820 | 9 |
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);