ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 27025 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1194447 | 1194447 | 2021-04-06 | Chisago | Minnesota | 27025 | 5297 | 48 |
1191198 | 1191198 | 2021-04-05 | Chisago | Minnesota | 27025 | 5274 | 48 |
1187950 | 1187950 | 2021-04-04 | Chisago | Minnesota | 27025 | 5264 | 48 |
1184703 | 1184703 | 2021-04-03 | Chisago | Minnesota | 27025 | 5264 | 48 |
1181457 | 1181457 | 2021-04-02 | Chisago | Minnesota | 27025 | 5248 | 48 |
1178210 | 1178210 | 2021-04-01 | Chisago | Minnesota | 27025 | 5233 | 48 |
1174963 | 1174963 | 2021-03-31 | Chisago | Minnesota | 27025 | 5219 | 48 |
1171716 | 1171716 | 2021-03-30 | Chisago | Minnesota | 27025 | 5207 | 48 |
1168468 | 1168468 | 2021-03-29 | Chisago | Minnesota | 27025 | 5196 | 48 |
1165220 | 1165220 | 2021-03-28 | Chisago | Minnesota | 27025 | 5186 | 48 |
1161972 | 1161972 | 2021-03-27 | Chisago | Minnesota | 27025 | 5175 | 48 |
1158724 | 1158724 | 2021-03-26 | Chisago | Minnesota | 27025 | 5160 | 48 |
1155477 | 1155477 | 2021-03-25 | Chisago | Minnesota | 27025 | 5146 | 48 |
1152230 | 1152230 | 2021-03-24 | Chisago | Minnesota | 27025 | 5138 | 48 |
1148983 | 1148983 | 2021-03-23 | Chisago | Minnesota | 27025 | 5132 | 48 |
1145736 | 1145736 | 2021-03-22 | Chisago | Minnesota | 27025 | 5131 | 48 |
1142489 | 1142489 | 2021-03-21 | Chisago | Minnesota | 27025 | 5125 | 48 |
1139242 | 1139242 | 2021-03-20 | Chisago | Minnesota | 27025 | 5120 | 48 |
1135996 | 1135996 | 2021-03-19 | Chisago | Minnesota | 27025 | 5117 | 48 |
1132750 | 1132750 | 2021-03-18 | Chisago | Minnesota | 27025 | 5111 | 48 |
1129502 | 1129502 | 2021-03-17 | Chisago | Minnesota | 27025 | 5107 | 48 |
1126255 | 1126255 | 2021-03-16 | Chisago | Minnesota | 27025 | 5102 | 47 |
1123009 | 1123009 | 2021-03-15 | Chisago | Minnesota | 27025 | 5098 | 47 |
1119762 | 1119762 | 2021-03-14 | Chisago | Minnesota | 27025 | 5086 | 47 |
1116515 | 1116515 | 2021-03-13 | Chisago | Minnesota | 27025 | 5075 | 47 |
1113269 | 1113269 | 2021-03-12 | Chisago | Minnesota | 27025 | 5068 | 47 |
1110023 | 1110023 | 2021-03-11 | Chisago | Minnesota | 27025 | 5061 | 47 |
1106777 | 1106777 | 2021-03-10 | Chisago | Minnesota | 27025 | 5050 | 47 |
1103531 | 1103531 | 2021-03-09 | Chisago | Minnesota | 27025 | 5040 | 47 |
1100285 | 1100285 | 2021-03-08 | Chisago | Minnesota | 27025 | 5030 | 45 |
1097038 | 1097038 | 2021-03-07 | Chisago | Minnesota | 27025 | 5029 | 45 |
1093791 | 1093791 | 2021-03-06 | Chisago | Minnesota | 27025 | 5017 | 45 |
1090545 | 1090545 | 2021-03-05 | Chisago | Minnesota | 27025 | 5010 | 45 |
1087300 | 1087300 | 2021-03-04 | Chisago | Minnesota | 27025 | 5003 | 45 |
1084055 | 1084055 | 2021-03-03 | Chisago | Minnesota | 27025 | 4995 | 45 |
1080809 | 1080809 | 2021-03-02 | Chisago | Minnesota | 27025 | 4990 | 45 |
1077563 | 1077563 | 2021-03-01 | Chisago | Minnesota | 27025 | 4984 | 45 |
1074317 | 1074317 | 2021-02-28 | Chisago | Minnesota | 27025 | 4975 | 45 |
1071071 | 1071071 | 2021-02-27 | Chisago | Minnesota | 27025 | 4968 | 44 |
1067826 | 1067826 | 2021-02-26 | Chisago | Minnesota | 27025 | 4961 | 44 |
1064581 | 1064581 | 2021-02-25 | Chisago | Minnesota | 27025 | 4947 | 44 |
1061337 | 1061337 | 2021-02-24 | Chisago | Minnesota | 27025 | 4936 | 44 |
1058091 | 1058091 | 2021-02-23 | Chisago | Minnesota | 27025 | 4933 | 44 |
1054845 | 1054845 | 2021-02-22 | Chisago | Minnesota | 27025 | 4922 | 44 |
1051598 | 1051598 | 2021-02-21 | Chisago | Minnesota | 27025 | 4917 | 44 |
1048351 | 1048351 | 2021-02-20 | Chisago | Minnesota | 27025 | 4900 | 44 |
1045105 | 1045105 | 2021-02-19 | Chisago | Minnesota | 27025 | 4889 | 44 |
1041860 | 1041860 | 2021-02-18 | Chisago | Minnesota | 27025 | 4872 | 44 |
1038615 | 1038615 | 2021-02-17 | Chisago | Minnesota | 27025 | 4858 | 44 |
1035370 | 1035370 | 2021-02-16 | Chisago | Minnesota | 27025 | 4852 | 44 |
1032125 | 1032125 | 2021-02-15 | Chisago | Minnesota | 27025 | 4838 | 44 |
1028878 | 1028878 | 2021-02-14 | Chisago | Minnesota | 27025 | 4830 | 43 |
1025632 | 1025632 | 2021-02-13 | Chisago | Minnesota | 27025 | 4816 | 43 |
1022387 | 1022387 | 2021-02-12 | Chisago | Minnesota | 27025 | 4795 | 43 |
1019142 | 1019142 | 2021-02-11 | Chisago | Minnesota | 27025 | 4773 | 43 |
1015897 | 1015897 | 2021-02-10 | Chisago | Minnesota | 27025 | 4763 | 43 |
1012652 | 1012652 | 2021-02-09 | Chisago | Minnesota | 27025 | 4759 | 43 |
1009407 | 1009407 | 2021-02-08 | Chisago | Minnesota | 27025 | 4750 | 43 |
1006160 | 1006160 | 2021-02-07 | Chisago | Minnesota | 27025 | 4742 | 42 |
1002914 | 1002914 | 2021-02-06 | Chisago | Minnesota | 27025 | 4727 | 42 |
999669 | 999669 | 2021-02-05 | Chisago | Minnesota | 27025 | 4719 | 41 |
996423 | 996423 | 2021-02-04 | Chisago | Minnesota | 27025 | 4708 | 41 |
993177 | 993177 | 2021-02-03 | Chisago | Minnesota | 27025 | 4693 | 40 |
989931 | 989931 | 2021-02-02 | Chisago | Minnesota | 27025 | 4689 | 39 |
986684 | 986684 | 2021-02-01 | Chisago | Minnesota | 27025 | 4687 | 38 |
983437 | 983437 | 2021-01-31 | Chisago | Minnesota | 27025 | 4673 | 38 |
980191 | 980191 | 2021-01-30 | Chisago | Minnesota | 27025 | 4663 | 38 |
976945 | 976945 | 2021-01-29 | Chisago | Minnesota | 27025 | 4651 | 38 |
973700 | 973700 | 2021-01-28 | Chisago | Minnesota | 27025 | 4642 | 38 |
970455 | 970455 | 2021-01-27 | Chisago | Minnesota | 27025 | 4630 | 38 |
967210 | 967210 | 2021-01-26 | Chisago | Minnesota | 27025 | 4618 | 38 |
963966 | 963966 | 2021-01-25 | Chisago | Minnesota | 27025 | 4604 | 38 |
960721 | 960721 | 2021-01-24 | Chisago | Minnesota | 27025 | 4595 | 38 |
957475 | 957475 | 2021-01-23 | Chisago | Minnesota | 27025 | 4581 | 38 |
954230 | 954230 | 2021-01-22 | Chisago | Minnesota | 27025 | 4564 | 36 |
950985 | 950985 | 2021-01-21 | Chisago | Minnesota | 27025 | 4550 | 36 |
947739 | 947739 | 2021-01-20 | Chisago | Minnesota | 27025 | 4533 | 36 |
944492 | 944492 | 2021-01-19 | Chisago | Minnesota | 27025 | 4527 | 32 |
941247 | 941247 | 2021-01-18 | Chisago | Minnesota | 27025 | 4520 | 32 |
938002 | 938002 | 2021-01-17 | Chisago | Minnesota | 27025 | 4508 | 32 |
934757 | 934757 | 2021-01-16 | Chisago | Minnesota | 27025 | 4497 | 32 |
931512 | 931512 | 2021-01-15 | Chisago | Minnesota | 27025 | 4479 | 32 |
928267 | 928267 | 2021-01-14 | Chisago | Minnesota | 27025 | 4463 | 31 |
925021 | 925021 | 2021-01-13 | Chisago | Minnesota | 27025 | 4445 | 30 |
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 |
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);