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 |
---|---|---|---|---|---|---|---|
1194466 | 1194466 | 2021-04-06 | Jackson | Minnesota | 27063 | 1092 | 10 |
1191217 | 1191217 | 2021-04-05 | Jackson | Minnesota | 27063 | 1082 | 10 |
1187969 | 1187969 | 2021-04-04 | Jackson | Minnesota | 27063 | 1070 | 10 |
1184722 | 1184722 | 2021-04-03 | Jackson | Minnesota | 27063 | 1070 | 10 |
1181476 | 1181476 | 2021-04-02 | Jackson | Minnesota | 27063 | 1062 | 10 |
1178229 | 1178229 | 2021-04-01 | Jackson | Minnesota | 27063 | 1048 | 10 |
1174982 | 1174982 | 2021-03-31 | Jackson | Minnesota | 27063 | 1039 | 10 |
1171735 | 1171735 | 2021-03-30 | Jackson | Minnesota | 27063 | 1028 | 10 |
1168487 | 1168487 | 2021-03-29 | Jackson | Minnesota | 27063 | 1018 | 10 |
1165239 | 1165239 | 2021-03-28 | Jackson | Minnesota | 27063 | 1011 | 10 |
1161991 | 1161991 | 2021-03-27 | Jackson | Minnesota | 27063 | 999 | 10 |
1158743 | 1158743 | 2021-03-26 | Jackson | Minnesota | 27063 | 991 | 10 |
1155496 | 1155496 | 2021-03-25 | Jackson | Minnesota | 27063 | 984 | 10 |
1152249 | 1152249 | 2021-03-24 | Jackson | Minnesota | 27063 | 980 | 10 |
1149002 | 1149002 | 2021-03-23 | Jackson | Minnesota | 27063 | 972 | 10 |
1145755 | 1145755 | 2021-03-22 | Jackson | Minnesota | 27063 | 969 | 10 |
1142508 | 1142508 | 2021-03-21 | Jackson | Minnesota | 27063 | 968 | 10 |
1139261 | 1139261 | 2021-03-20 | Jackson | Minnesota | 27063 | 966 | 10 |
1136015 | 1136015 | 2021-03-19 | Jackson | Minnesota | 27063 | 964 | 10 |
1132769 | 1132769 | 2021-03-18 | Jackson | Minnesota | 27063 | 959 | 10 |
1129521 | 1129521 | 2021-03-17 | Jackson | Minnesota | 27063 | 957 | 10 |
1126274 | 1126274 | 2021-03-16 | Jackson | Minnesota | 27063 | 954 | 10 |
1123028 | 1123028 | 2021-03-15 | Jackson | Minnesota | 27063 | 952 | 10 |
1119781 | 1119781 | 2021-03-14 | Jackson | Minnesota | 27063 | 952 | 10 |
1116534 | 1116534 | 2021-03-13 | Jackson | Minnesota | 27063 | 952 | 10 |
1113288 | 1113288 | 2021-03-12 | Jackson | Minnesota | 27063 | 952 | 10 |
1110042 | 1110042 | 2021-03-11 | Jackson | Minnesota | 27063 | 951 | 10 |
1106796 | 1106796 | 2021-03-10 | Jackson | Minnesota | 27063 | 949 | 10 |
1103550 | 1103550 | 2021-03-09 | Jackson | Minnesota | 27063 | 947 | 10 |
1100304 | 1100304 | 2021-03-08 | Jackson | Minnesota | 27063 | 947 | 10 |
1097057 | 1097057 | 2021-03-07 | Jackson | Minnesota | 27063 | 947 | 10 |
1093810 | 1093810 | 2021-03-06 | Jackson | Minnesota | 27063 | 946 | 10 |
1090564 | 1090564 | 2021-03-05 | Jackson | Minnesota | 27063 | 942 | 10 |
1087319 | 1087319 | 2021-03-04 | Jackson | Minnesota | 27063 | 940 | 10 |
1084074 | 1084074 | 2021-03-03 | Jackson | Minnesota | 27063 | 936 | 10 |
1080828 | 1080828 | 2021-03-02 | Jackson | Minnesota | 27063 | 935 | 10 |
1077582 | 1077582 | 2021-03-01 | Jackson | Minnesota | 27063 | 935 | 10 |
1074336 | 1074336 | 2021-02-28 | Jackson | Minnesota | 27063 | 934 | 10 |
1071090 | 1071090 | 2021-02-27 | Jackson | Minnesota | 27063 | 933 | 10 |
1067845 | 1067845 | 2021-02-26 | Jackson | Minnesota | 27063 | 930 | 10 |
1064600 | 1064600 | 2021-02-25 | Jackson | Minnesota | 27063 | 926 | 10 |
1061356 | 1061356 | 2021-02-24 | Jackson | Minnesota | 27063 | 925 | 10 |
1058110 | 1058110 | 2021-02-23 | Jackson | Minnesota | 27063 | 923 | 10 |
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 |
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);