ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Chisago" and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921776 | 921776 | 2021-01-12 | Chisago | Minnesota | 27025 | 4442 | 29 |
918531 | 918531 | 2021-01-11 | Chisago | Minnesota | 27025 | 4427 | 29 |
915286 | 915286 | 2021-01-10 | Chisago | Minnesota | 27025 | 4419 | 29 |
912041 | 912041 | 2021-01-09 | Chisago | Minnesota | 27025 | 4402 | 29 |
908796 | 908796 | 2021-01-08 | Chisago | Minnesota | 27025 | 4366 | 29 |
905550 | 905550 | 2021-01-07 | Chisago | Minnesota | 27025 | 4351 | 28 |
902305 | 902305 | 2021-01-06 | Chisago | Minnesota | 27025 | 4330 | 28 |
899060 | 899060 | 2021-01-05 | Chisago | Minnesota | 27025 | 4295 | 28 |
895815 | 895815 | 2021-01-04 | Chisago | Minnesota | 27025 | 4266 | 28 |
892568 | 892568 | 2021-01-03 | Chisago | Minnesota | 27025 | 4228 | 28 |
889322 | 889322 | 2021-01-02 | Chisago | Minnesota | 27025 | 4185 | 28 |
886076 | 886076 | 2021-01-01 | Chisago | Minnesota | 27025 | 4149 | 27 |
882831 | 882831 | 2020-12-31 | Chisago | Minnesota | 27025 | 4149 | 27 |
879586 | 879586 | 2020-12-30 | Chisago | Minnesota | 27025 | 4127 | 27 |
876341 | 876341 | 2020-12-29 | Chisago | Minnesota | 27025 | 4106 | 27 |
873096 | 873096 | 2020-12-28 | Chisago | Minnesota | 27025 | 4094 | 27 |
869851 | 869851 | 2020-12-27 | Chisago | Minnesota | 27025 | 4079 | 27 |
866606 | 866606 | 2020-12-26 | Chisago | Minnesota | 27025 | 4047 | 27 |
863361 | 863361 | 2020-12-25 | Chisago | Minnesota | 27025 | 4018 | 26 |
860116 | 860116 | 2020-12-24 | Chisago | Minnesota | 27025 | 4018 | 26 |
856871 | 856871 | 2020-12-23 | Chisago | Minnesota | 27025 | 4008 | 26 |
853626 | 853626 | 2020-12-22 | Chisago | Minnesota | 27025 | 3996 | 26 |
850381 | 850381 | 2020-12-21 | Chisago | Minnesota | 27025 | 3973 | 26 |
847136 | 847136 | 2020-12-20 | Chisago | Minnesota | 27025 | 3962 | 25 |
843890 | 843890 | 2020-12-19 | Chisago | Minnesota | 27025 | 3936 | 25 |
840645 | 840645 | 2020-12-18 | Chisago | Minnesota | 27025 | 3911 | 24 |
837400 | 837400 | 2020-12-17 | Chisago | Minnesota | 27025 | 3877 | 24 |
834154 | 834154 | 2020-12-16 | Chisago | Minnesota | 27025 | 3848 | 24 |
830907 | 830907 | 2020-12-15 | Chisago | Minnesota | 27025 | 3825 | 24 |
827661 | 827661 | 2020-12-14 | Chisago | Minnesota | 27025 | 3794 | 24 |
824414 | 824414 | 2020-12-13 | Chisago | Minnesota | 27025 | 3759 | 24 |
821168 | 821168 | 2020-12-12 | Chisago | Minnesota | 27025 | 3704 | 24 |
817922 | 817922 | 2020-12-11 | Chisago | Minnesota | 27025 | 3659 | 22 |
814676 | 814676 | 2020-12-10 | Chisago | Minnesota | 27025 | 3629 | 20 |
811431 | 811431 | 2020-12-09 | Chisago | Minnesota | 27025 | 3596 | 19 |
808186 | 808186 | 2020-12-08 | Chisago | Minnesota | 27025 | 3550 | 18 |
804941 | 804941 | 2020-12-07 | Chisago | Minnesota | 27025 | 3517 | 18 |
801696 | 801696 | 2020-12-06 | Chisago | Minnesota | 27025 | 3463 | 18 |
798451 | 798451 | 2020-12-05 | Chisago | Minnesota | 27025 | 3431 | 17 |
795206 | 795206 | 2020-12-04 | Chisago | Minnesota | 27025 | 3381 | 17 |
791961 | 791961 | 2020-12-03 | Chisago | Minnesota | 27025 | 3345 | 16 |
788716 | 788716 | 2020-12-02 | Chisago | Minnesota | 27025 | 3269 | 14 |
785471 | 785471 | 2020-12-01 | Chisago | Minnesota | 27025 | 3204 | 13 |
782227 | 782227 | 2020-11-30 | Chisago | Minnesota | 27025 | 3156 | 12 |
778981 | 778981 | 2020-11-29 | Chisago | Minnesota | 27025 | 3116 | 11 |
775736 | 775736 | 2020-11-28 | Chisago | Minnesota | 27025 | 3044 | 10 |
772491 | 772491 | 2020-11-27 | Chisago | Minnesota | 27025 | 2979 | 9 |
769246 | 769246 | 2020-11-26 | Chisago | Minnesota | 27025 | 2935 | 8 |
766000 | 766000 | 2020-11-25 | Chisago | Minnesota | 27025 | 2935 | 8 |
762755 | 762755 | 2020-11-24 | Chisago | Minnesota | 27025 | 2883 | 8 |
759510 | 759510 | 2020-11-23 | Chisago | Minnesota | 27025 | 2839 | 8 |
756263 | 756263 | 2020-11-22 | Chisago | Minnesota | 27025 | 2777 | 8 |
753017 | 753017 | 2020-11-21 | Chisago | Minnesota | 27025 | 2700 | 8 |
749771 | 749771 | 2020-11-20 | Chisago | Minnesota | 27025 | 2624 | 7 |
746525 | 746525 | 2020-11-19 | Chisago | Minnesota | 27025 | 2547 | 7 |
743278 | 743278 | 2020-11-18 | Chisago | Minnesota | 27025 | 2465 | 5 |
740031 | 740031 | 2020-11-17 | Chisago | Minnesota | 27025 | 2398 | 4 |
736787 | 736787 | 2020-11-16 | Chisago | Minnesota | 27025 | 2341 | 4 |
733541 | 733541 | 2020-11-15 | Chisago | Minnesota | 27025 | 2273 | 4 |
730296 | 730296 | 2020-11-14 | Chisago | Minnesota | 27025 | 2208 | 4 |
727053 | 727053 | 2020-11-13 | Chisago | Minnesota | 27025 | 2098 | 3 |
723810 | 723810 | 2020-11-12 | Chisago | Minnesota | 27025 | 2015 | 2 |
720567 | 720567 | 2020-11-11 | Chisago | Minnesota | 27025 | 1899 | 2 |
717324 | 717324 | 2020-11-10 | Chisago | Minnesota | 27025 | 1798 | 2 |
714080 | 714080 | 2020-11-09 | Chisago | Minnesota | 27025 | 1728 | 2 |
710836 | 710836 | 2020-11-08 | Chisago | Minnesota | 27025 | 1681 | 2 |
707592 | 707592 | 2020-11-07 | Chisago | Minnesota | 27025 | 1622 | 2 |
704349 | 704349 | 2020-11-06 | Chisago | Minnesota | 27025 | 1561 | 2 |
701107 | 701107 | 2020-11-05 | Chisago | Minnesota | 27025 | 1505 | 2 |
697863 | 697863 | 2020-11-04 | Chisago | Minnesota | 27025 | 1453 | 2 |
694620 | 694620 | 2020-11-03 | Chisago | Minnesota | 27025 | 1405 | 2 |
691378 | 691378 | 2020-11-02 | Chisago | Minnesota | 27025 | 1356 | 2 |
688133 | 688133 | 2020-11-01 | Chisago | Minnesota | 27025 | 1249 | 2 |
684889 | 684889 | 2020-10-31 | Chisago | Minnesota | 27025 | 1228 | 2 |
681646 | 681646 | 2020-10-30 | Chisago | Minnesota | 27025 | 1191 | 2 |
678402 | 678402 | 2020-10-29 | Chisago | Minnesota | 27025 | 1156 | 2 |
675160 | 675160 | 2020-10-28 | Chisago | Minnesota | 27025 | 1114 | 2 |
671917 | 671917 | 2020-10-27 | Chisago | Minnesota | 27025 | 1083 | 2 |
668675 | 668675 | 2020-10-26 | Chisago | Minnesota | 27025 | 1040 | 2 |
665431 | 665431 | 2020-10-25 | Chisago | Minnesota | 27025 | 1002 | 2 |
662186 | 662186 | 2020-10-24 | Chisago | Minnesota | 27025 | 981 | 2 |
658942 | 658942 | 2020-10-23 | Chisago | Minnesota | 27025 | 950 | 2 |
655697 | 655697 | 2020-10-22 | Chisago | Minnesota | 27025 | 920 | 2 |
652452 | 652452 | 2020-10-21 | Chisago | Minnesota | 27025 | 890 | 2 |
649207 | 649207 | 2020-10-20 | Chisago | Minnesota | 27025 | 879 | 2 |
645963 | 645963 | 2020-10-19 | Chisago | Minnesota | 27025 | 855 | 2 |
642716 | 642716 | 2020-10-18 | Chisago | Minnesota | 27025 | 831 | 2 |
639469 | 639469 | 2020-10-17 | Chisago | Minnesota | 27025 | 811 | 2 |
636223 | 636223 | 2020-10-16 | Chisago | Minnesota | 27025 | 787 | 2 |
632977 | 632977 | 2020-10-15 | Chisago | Minnesota | 27025 | 763 | 2 |
629732 | 629732 | 2020-10-14 | Chisago | Minnesota | 27025 | 743 | 2 |
626488 | 626488 | 2020-10-13 | Chisago | Minnesota | 27025 | 717 | 2 |
623246 | 623246 | 2020-10-12 | Chisago | Minnesota | 27025 | 702 | 2 |
620003 | 620003 | 2020-10-11 | Chisago | Minnesota | 27025 | 682 | 2 |
616761 | 616761 | 2020-10-10 | Chisago | Minnesota | 27025 | 665 | 2 |
613520 | 613520 | 2020-10-09 | Chisago | Minnesota | 27025 | 645 | 2 |
610278 | 610278 | 2020-10-08 | Chisago | Minnesota | 27025 | 630 | 2 |
607036 | 607036 | 2020-10-07 | Chisago | Minnesota | 27025 | 613 | 2 |
603793 | 603793 | 2020-10-06 | Chisago | Minnesota | 27025 | 604 | 2 |
600551 | 600551 | 2020-10-05 | Chisago | Minnesota | 27025 | 594 | 2 |
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);