ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Jackson" and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054864 | 1054864 | 2021-02-22 | Jackson | Minnesota | 27063 | 921 | 10 |
1051617 | 1051617 | 2021-02-21 | Jackson | Minnesota | 27063 | 920 | 10 |
1048370 | 1048370 | 2021-02-20 | Jackson | Minnesota | 27063 | 919 | 10 |
1045124 | 1045124 | 2021-02-19 | Jackson | Minnesota | 27063 | 917 | 10 |
1041879 | 1041879 | 2021-02-18 | Jackson | Minnesota | 27063 | 914 | 10 |
1038634 | 1038634 | 2021-02-17 | Jackson | Minnesota | 27063 | 910 | 10 |
1035389 | 1035389 | 2021-02-16 | Jackson | Minnesota | 27063 | 910 | 10 |
1032144 | 1032144 | 2021-02-15 | Jackson | Minnesota | 27063 | 910 | 10 |
1028897 | 1028897 | 2021-02-14 | Jackson | Minnesota | 27063 | 908 | 10 |
1025651 | 1025651 | 2021-02-13 | Jackson | Minnesota | 27063 | 906 | 10 |
1022406 | 1022406 | 2021-02-12 | Jackson | Minnesota | 27063 | 905 | 10 |
1019161 | 1019161 | 2021-02-11 | Jackson | Minnesota | 27063 | 903 | 10 |
1015916 | 1015916 | 2021-02-10 | Jackson | Minnesota | 27063 | 898 | 10 |
1012671 | 1012671 | 2021-02-09 | Jackson | Minnesota | 27063 | 897 | 10 |
1009426 | 1009426 | 2021-02-08 | Jackson | Minnesota | 27063 | 897 | 10 |
1006179 | 1006179 | 2021-02-07 | Jackson | Minnesota | 27063 | 895 | 10 |
1002933 | 1002933 | 2021-02-06 | Jackson | Minnesota | 27063 | 893 | 10 |
999688 | 999688 | 2021-02-05 | Jackson | Minnesota | 27063 | 891 | 10 |
996442 | 996442 | 2021-02-04 | Jackson | Minnesota | 27063 | 891 | 10 |
993196 | 993196 | 2021-02-03 | Jackson | Minnesota | 27063 | 890 | 10 |
989950 | 989950 | 2021-02-02 | Jackson | Minnesota | 27063 | 888 | 10 |
986703 | 986703 | 2021-02-01 | Jackson | Minnesota | 27063 | 887 | 10 |
983456 | 983456 | 2021-01-31 | Jackson | Minnesota | 27063 | 887 | 10 |
980210 | 980210 | 2021-01-30 | Jackson | Minnesota | 27063 | 886 | 10 |
976964 | 976964 | 2021-01-29 | Jackson | Minnesota | 27063 | 883 | 10 |
973719 | 973719 | 2021-01-28 | Jackson | Minnesota | 27063 | 881 | 10 |
970474 | 970474 | 2021-01-27 | Jackson | Minnesota | 27063 | 879 | 10 |
967229 | 967229 | 2021-01-26 | Jackson | Minnesota | 27063 | 875 | 10 |
963985 | 963985 | 2021-01-25 | Jackson | Minnesota | 27063 | 873 | 10 |
960740 | 960740 | 2021-01-24 | Jackson | Minnesota | 27063 | 873 | 10 |
957494 | 957494 | 2021-01-23 | Jackson | Minnesota | 27063 | 873 | 10 |
954249 | 954249 | 2021-01-22 | Jackson | Minnesota | 27063 | 871 | 10 |
951004 | 951004 | 2021-01-21 | Jackson | Minnesota | 27063 | 863 | 10 |
947758 | 947758 | 2021-01-20 | Jackson | Minnesota | 27063 | 860 | 10 |
944511 | 944511 | 2021-01-19 | Jackson | Minnesota | 27063 | 856 | 10 |
941266 | 941266 | 2021-01-18 | Jackson | Minnesota | 27063 | 853 | 10 |
938021 | 938021 | 2021-01-17 | Jackson | Minnesota | 27063 | 852 | 10 |
934776 | 934776 | 2021-01-16 | Jackson | Minnesota | 27063 | 850 | 10 |
931531 | 931531 | 2021-01-15 | Jackson | Minnesota | 27063 | 850 | 10 |
928286 | 928286 | 2021-01-14 | Jackson | Minnesota | 27063 | 845 | 10 |
925040 | 925040 | 2021-01-13 | Jackson | Minnesota | 27063 | 839 | 10 |
921795 | 921795 | 2021-01-12 | Jackson | Minnesota | 27063 | 830 | 10 |
918550 | 918550 | 2021-01-11 | Jackson | Minnesota | 27063 | 829 | 10 |
915305 | 915305 | 2021-01-10 | Jackson | Minnesota | 27063 | 824 | 10 |
912060 | 912060 | 2021-01-09 | Jackson | Minnesota | 27063 | 822 | 10 |
908815 | 908815 | 2021-01-08 | Jackson | Minnesota | 27063 | 821 | 10 |
905569 | 905569 | 2021-01-07 | Jackson | Minnesota | 27063 | 817 | 9 |
902324 | 902324 | 2021-01-06 | Jackson | Minnesota | 27063 | 811 | 8 |
899079 | 899079 | 2021-01-05 | Jackson | Minnesota | 27063 | 804 | 8 |
895834 | 895834 | 2021-01-04 | Jackson | Minnesota | 27063 | 802 | 8 |
892587 | 892587 | 2021-01-03 | Jackson | Minnesota | 27063 | 800 | 8 |
889341 | 889341 | 2021-01-02 | Jackson | Minnesota | 27063 | 798 | 8 |
886095 | 886095 | 2021-01-01 | Jackson | Minnesota | 27063 | 791 | 8 |
882850 | 882850 | 2020-12-31 | Jackson | Minnesota | 27063 | 791 | 8 |
879605 | 879605 | 2020-12-30 | Jackson | Minnesota | 27063 | 784 | 8 |
876360 | 876360 | 2020-12-29 | Jackson | Minnesota | 27063 | 781 | 8 |
873115 | 873115 | 2020-12-28 | Jackson | Minnesota | 27063 | 779 | 8 |
869870 | 869870 | 2020-12-27 | Jackson | Minnesota | 27063 | 777 | 8 |
866625 | 866625 | 2020-12-26 | Jackson | Minnesota | 27063 | 772 | 7 |
863380 | 863380 | 2020-12-25 | Jackson | Minnesota | 27063 | 767 | 6 |
860135 | 860135 | 2020-12-24 | Jackson | Minnesota | 27063 | 767 | 6 |
856890 | 856890 | 2020-12-23 | Jackson | Minnesota | 27063 | 763 | 5 |
853645 | 853645 | 2020-12-22 | Jackson | Minnesota | 27063 | 752 | 5 |
850400 | 850400 | 2020-12-21 | Jackson | Minnesota | 27063 | 746 | 5 |
847155 | 847155 | 2020-12-20 | Jackson | Minnesota | 27063 | 740 | 5 |
843909 | 843909 | 2020-12-19 | Jackson | Minnesota | 27063 | 729 | 4 |
840664 | 840664 | 2020-12-18 | Jackson | Minnesota | 27063 | 725 | 4 |
837419 | 837419 | 2020-12-17 | Jackson | Minnesota | 27063 | 719 | 4 |
834173 | 834173 | 2020-12-16 | Jackson | Minnesota | 27063 | 704 | 4 |
830926 | 830926 | 2020-12-15 | Jackson | Minnesota | 27063 | 697 | 3 |
827680 | 827680 | 2020-12-14 | Jackson | Minnesota | 27063 | 691 | 3 |
824433 | 824433 | 2020-12-13 | Jackson | Minnesota | 27063 | 688 | 3 |
821187 | 821187 | 2020-12-12 | Jackson | Minnesota | 27063 | 680 | 2 |
817941 | 817941 | 2020-12-11 | Jackson | Minnesota | 27063 | 666 | 2 |
814695 | 814695 | 2020-12-10 | Jackson | Minnesota | 27063 | 649 | 2 |
811450 | 811450 | 2020-12-09 | Jackson | Minnesota | 27063 | 628 | 2 |
808205 | 808205 | 2020-12-08 | Jackson | Minnesota | 27063 | 607 | 1 |
804960 | 804960 | 2020-12-07 | Jackson | Minnesota | 27063 | 595 | 1 |
801715 | 801715 | 2020-12-06 | Jackson | Minnesota | 27063 | 582 | 1 |
798470 | 798470 | 2020-12-05 | Jackson | Minnesota | 27063 | 572 | 1 |
795225 | 795225 | 2020-12-04 | Jackson | Minnesota | 27063 | 546 | 1 |
791980 | 791980 | 2020-12-03 | Jackson | Minnesota | 27063 | 532 | 1 |
788735 | 788735 | 2020-12-02 | Jackson | Minnesota | 27063 | 518 | 1 |
785490 | 785490 | 2020-12-01 | Jackson | Minnesota | 27063 | 506 | 1 |
782246 | 782246 | 2020-11-30 | Jackson | Minnesota | 27063 | 496 | 1 |
779000 | 779000 | 2020-11-29 | Jackson | Minnesota | 27063 | 488 | 1 |
775755 | 775755 | 2020-11-28 | Jackson | Minnesota | 27063 | 484 | 1 |
772510 | 772510 | 2020-11-27 | Jackson | Minnesota | 27063 | 458 | 1 |
769265 | 769265 | 2020-11-26 | Jackson | Minnesota | 27063 | 436 | 1 |
766019 | 766019 | 2020-11-25 | Jackson | Minnesota | 27063 | 436 | 1 |
762774 | 762774 | 2020-11-24 | Jackson | Minnesota | 27063 | 429 | 1 |
759529 | 759529 | 2020-11-23 | Jackson | Minnesota | 27063 | 409 | 1 |
756282 | 756282 | 2020-11-22 | Jackson | Minnesota | 27063 | 398 | 1 |
753036 | 753036 | 2020-11-21 | Jackson | Minnesota | 27063 | 384 | 1 |
749790 | 749790 | 2020-11-20 | Jackson | Minnesota | 27063 | 373 | 1 |
746544 | 746544 | 2020-11-19 | Jackson | Minnesota | 27063 | 358 | 1 |
743297 | 743297 | 2020-11-18 | Jackson | Minnesota | 27063 | 356 | 1 |
740050 | 740050 | 2020-11-17 | Jackson | Minnesota | 27063 | 350 | 1 |
736806 | 736806 | 2020-11-16 | Jackson | Minnesota | 27063 | 340 | 1 |
733560 | 733560 | 2020-11-15 | Jackson | Minnesota | 27063 | 326 | 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);