ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Stearns" and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054905 | 1054905 | 2021-02-22 | Stearns | Minnesota | 27145 | 18664 | 200 |
1051658 | 1051658 | 2021-02-21 | Stearns | Minnesota | 27145 | 18645 | 200 |
1048411 | 1048411 | 2021-02-20 | Stearns | Minnesota | 27145 | 18615 | 200 |
1045165 | 1045165 | 2021-02-19 | Stearns | Minnesota | 27145 | 18595 | 200 |
1041920 | 1041920 | 2021-02-18 | Stearns | Minnesota | 27145 | 18577 | 199 |
1038675 | 1038675 | 2021-02-17 | Stearns | Minnesota | 27145 | 18562 | 199 |
1035430 | 1035430 | 2021-02-16 | Stearns | Minnesota | 27145 | 18540 | 199 |
1032185 | 1032185 | 2021-02-15 | Stearns | Minnesota | 27145 | 18529 | 199 |
1028938 | 1028938 | 2021-02-14 | Stearns | Minnesota | 27145 | 18517 | 199 |
1025692 | 1025692 | 2021-02-13 | Stearns | Minnesota | 27145 | 18507 | 199 |
1022447 | 1022447 | 2021-02-12 | Stearns | Minnesota | 27145 | 18488 | 198 |
1019202 | 1019202 | 2021-02-11 | Stearns | Minnesota | 27145 | 18469 | 198 |
1015957 | 1015957 | 2021-02-10 | Stearns | Minnesota | 27145 | 18450 | 198 |
1012712 | 1012712 | 2021-02-09 | Stearns | Minnesota | 27145 | 18436 | 198 |
1009467 | 1009467 | 2021-02-08 | Stearns | Minnesota | 27145 | 18422 | 198 |
1006220 | 1006220 | 2021-02-07 | Stearns | Minnesota | 27145 | 18404 | 198 |
1002974 | 1002974 | 2021-02-06 | Stearns | Minnesota | 27145 | 18392 | 198 |
999729 | 999729 | 2021-02-05 | Stearns | Minnesota | 27145 | 18359 | 197 |
996483 | 996483 | 2021-02-04 | Stearns | Minnesota | 27145 | 18321 | 195 |
993237 | 993237 | 2021-02-03 | Stearns | Minnesota | 27145 | 18291 | 195 |
989991 | 989991 | 2021-02-02 | Stearns | Minnesota | 27145 | 18272 | 193 |
986744 | 986744 | 2021-02-01 | Stearns | Minnesota | 27145 | 18260 | 193 |
983497 | 983497 | 2021-01-31 | Stearns | Minnesota | 27145 | 18244 | 193 |
980251 | 980251 | 2021-01-30 | Stearns | Minnesota | 27145 | 18234 | 193 |
977005 | 977005 | 2021-01-29 | Stearns | Minnesota | 27145 | 18199 | 193 |
973760 | 973760 | 2021-01-28 | Stearns | Minnesota | 27145 | 18172 | 192 |
970515 | 970515 | 2021-01-27 | Stearns | Minnesota | 27145 | 18152 | 190 |
967270 | 967270 | 2021-01-26 | Stearns | Minnesota | 27145 | 18137 | 190 |
964026 | 964026 | 2021-01-25 | Stearns | Minnesota | 27145 | 18111 | 190 |
960781 | 960781 | 2021-01-24 | Stearns | Minnesota | 27145 | 18091 | 190 |
957535 | 957535 | 2021-01-23 | Stearns | Minnesota | 27145 | 18051 | 190 |
954290 | 954290 | 2021-01-22 | Stearns | Minnesota | 27145 | 17995 | 189 |
951045 | 951045 | 2021-01-21 | Stearns | Minnesota | 27145 | 17957 | 188 |
947799 | 947799 | 2021-01-20 | Stearns | Minnesota | 27145 | 17922 | 188 |
944552 | 944552 | 2021-01-19 | Stearns | Minnesota | 27145 | 17871 | 187 |
941307 | 941307 | 2021-01-18 | Stearns | Minnesota | 27145 | 17847 | 187 |
938062 | 938062 | 2021-01-17 | Stearns | Minnesota | 27145 | 17813 | 187 |
934817 | 934817 | 2021-01-16 | Stearns | Minnesota | 27145 | 17775 | 185 |
931572 | 931572 | 2021-01-15 | Stearns | Minnesota | 27145 | 17728 | 184 |
928327 | 928327 | 2021-01-14 | Stearns | Minnesota | 27145 | 17686 | 184 |
925081 | 925081 | 2021-01-13 | Stearns | Minnesota | 27145 | 17648 | 180 |
921836 | 921836 | 2021-01-12 | Stearns | Minnesota | 27145 | 17600 | 179 |
918591 | 918591 | 2021-01-11 | Stearns | Minnesota | 27145 | 17568 | 179 |
915346 | 915346 | 2021-01-10 | Stearns | Minnesota | 27145 | 17548 | 179 |
912101 | 912101 | 2021-01-09 | Stearns | Minnesota | 27145 | 17499 | 179 |
908856 | 908856 | 2021-01-08 | Stearns | Minnesota | 27145 | 17441 | 177 |
905610 | 905610 | 2021-01-07 | Stearns | Minnesota | 27145 | 17384 | 177 |
902365 | 902365 | 2021-01-06 | Stearns | Minnesota | 27145 | 17327 | 175 |
899120 | 899120 | 2021-01-05 | Stearns | Minnesota | 27145 | 17249 | 175 |
895875 | 895875 | 2021-01-04 | Stearns | Minnesota | 27145 | 17190 | 175 |
892628 | 892628 | 2021-01-03 | Stearns | Minnesota | 27145 | 17093 | 173 |
889382 | 889382 | 2021-01-02 | Stearns | Minnesota | 27145 | 17019 | 173 |
886136 | 886136 | 2021-01-01 | Stearns | Minnesota | 27145 | 16946 | 172 |
882891 | 882891 | 2020-12-31 | Stearns | Minnesota | 27145 | 16946 | 172 |
879646 | 879646 | 2020-12-30 | Stearns | Minnesota | 27145 | 16881 | 171 |
876401 | 876401 | 2020-12-29 | Stearns | Minnesota | 27145 | 16811 | 170 |
873156 | 873156 | 2020-12-28 | Stearns | Minnesota | 27145 | 16797 | 168 |
869911 | 869911 | 2020-12-27 | Stearns | Minnesota | 27145 | 16759 | 168 |
866666 | 866666 | 2020-12-26 | Stearns | Minnesota | 27145 | 16701 | 167 |
863421 | 863421 | 2020-12-25 | Stearns | Minnesota | 27145 | 16630 | 165 |
860176 | 860176 | 2020-12-24 | Stearns | Minnesota | 27145 | 16630 | 165 |
856931 | 856931 | 2020-12-23 | Stearns | Minnesota | 27145 | 16569 | 164 |
853686 | 853686 | 2020-12-22 | Stearns | Minnesota | 27145 | 16524 | 161 |
850441 | 850441 | 2020-12-21 | Stearns | Minnesota | 27145 | 16478 | 160 |
847196 | 847196 | 2020-12-20 | Stearns | Minnesota | 27145 | 16422 | 159 |
843950 | 843950 | 2020-12-19 | Stearns | Minnesota | 27145 | 16354 | 157 |
840705 | 840705 | 2020-12-18 | Stearns | Minnesota | 27145 | 16285 | 155 |
837460 | 837460 | 2020-12-17 | Stearns | Minnesota | 27145 | 16209 | 153 |
834214 | 834214 | 2020-12-16 | Stearns | Minnesota | 27145 | 16133 | 151 |
830967 | 830967 | 2020-12-15 | Stearns | Minnesota | 27145 | 16065 | 145 |
827721 | 827721 | 2020-12-14 | Stearns | Minnesota | 27145 | 16011 | 145 |
824474 | 824474 | 2020-12-13 | Stearns | Minnesota | 27145 | 15926 | 145 |
821228 | 821228 | 2020-12-12 | Stearns | Minnesota | 27145 | 15854 | 142 |
817982 | 817982 | 2020-12-11 | Stearns | Minnesota | 27145 | 15746 | 141 |
814736 | 814736 | 2020-12-10 | Stearns | Minnesota | 27145 | 15611 | 139 |
811491 | 811491 | 2020-12-09 | Stearns | Minnesota | 27145 | 15469 | 138 |
808246 | 808246 | 2020-12-08 | Stearns | Minnesota | 27145 | 15303 | 133 |
805001 | 805001 | 2020-12-07 | Stearns | Minnesota | 27145 | 15227 | 133 |
801756 | 801756 | 2020-12-06 | Stearns | Minnesota | 27145 | 15064 | 132 |
798511 | 798511 | 2020-12-05 | Stearns | Minnesota | 27145 | 14916 | 130 |
795266 | 795266 | 2020-12-04 | Stearns | Minnesota | 27145 | 14679 | 126 |
792021 | 792021 | 2020-12-03 | Stearns | Minnesota | 27145 | 14564 | 125 |
788776 | 788776 | 2020-12-02 | Stearns | Minnesota | 27145 | 14314 | 121 |
785531 | 785531 | 2020-12-01 | Stearns | Minnesota | 27145 | 14131 | 117 |
782287 | 782287 | 2020-11-30 | Stearns | Minnesota | 27145 | 13976 | 117 |
779041 | 779041 | 2020-11-29 | Stearns | Minnesota | 27145 | 13733 | 116 |
775796 | 775796 | 2020-11-28 | Stearns | Minnesota | 27145 | 13524 | 108 |
772551 | 772551 | 2020-11-27 | Stearns | Minnesota | 27145 | 13245 | 106 |
769306 | 769306 | 2020-11-26 | Stearns | Minnesota | 27145 | 12910 | 98 |
766060 | 766060 | 2020-11-25 | Stearns | Minnesota | 27145 | 12910 | 98 |
762815 | 762815 | 2020-11-24 | Stearns | Minnesota | 27145 | 12547 | 93 |
759570 | 759570 | 2020-11-23 | Stearns | Minnesota | 27145 | 12266 | 89 |
756323 | 756323 | 2020-11-22 | Stearns | Minnesota | 27145 | 12003 | 89 |
753077 | 753077 | 2020-11-21 | Stearns | Minnesota | 27145 | 11795 | 88 |
749831 | 749831 | 2020-11-20 | Stearns | Minnesota | 27145 | 11593 | 84 |
746585 | 746585 | 2020-11-19 | Stearns | Minnesota | 27145 | 11238 | 79 |
743338 | 743338 | 2020-11-18 | Stearns | Minnesota | 27145 | 10739 | 76 |
740091 | 740091 | 2020-11-17 | Stearns | Minnesota | 27145 | 10524 | 74 |
736847 | 736847 | 2020-11-16 | Stearns | Minnesota | 27145 | 10199 | 74 |
733601 | 733601 | 2020-11-15 | Stearns | Minnesota | 27145 | 9883 | 74 |
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);