ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Hennepin" and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054859 | 1054859 | 2021-02-22 | Hennepin | Minnesota | 27053 | 99448 | 1576 |
1051612 | 1051612 | 2021-02-21 | Hennepin | Minnesota | 27053 | 99347 | 1576 |
1048365 | 1048365 | 2021-02-20 | Hennepin | Minnesota | 27053 | 99189 | 1576 |
1045119 | 1045119 | 2021-02-19 | Hennepin | Minnesota | 27053 | 99020 | 1576 |
1041874 | 1041874 | 2021-02-18 | Hennepin | Minnesota | 27053 | 98828 | 1576 |
1038629 | 1038629 | 2021-02-17 | Hennepin | Minnesota | 27053 | 98644 | 1569 |
1035384 | 1035384 | 2021-02-16 | Hennepin | Minnesota | 27053 | 98486 | 1569 |
1032139 | 1032139 | 2021-02-15 | Hennepin | Minnesota | 27053 | 98398 | 1569 |
1028892 | 1028892 | 2021-02-14 | Hennepin | Minnesota | 27053 | 98278 | 1569 |
1025646 | 1025646 | 2021-02-13 | Hennepin | Minnesota | 27053 | 98122 | 1565 |
1022401 | 1022401 | 2021-02-12 | Hennepin | Minnesota | 27053 | 97956 | 1565 |
1019156 | 1019156 | 2021-02-11 | Hennepin | Minnesota | 27053 | 97742 | 1561 |
1015911 | 1015911 | 2021-02-10 | Hennepin | Minnesota | 27053 | 97559 | 1557 |
1012666 | 1012666 | 2021-02-09 | Hennepin | Minnesota | 27053 | 97413 | 1552 |
1009421 | 1009421 | 2021-02-08 | Hennepin | Minnesota | 27053 | 97297 | 1550 |
1006174 | 1006174 | 2021-02-07 | Hennepin | Minnesota | 27053 | 97160 | 1549 |
1002928 | 1002928 | 2021-02-06 | Hennepin | Minnesota | 27053 | 97000 | 1548 |
999683 | 999683 | 2021-02-05 | Hennepin | Minnesota | 27053 | 96785 | 1546 |
996437 | 996437 | 2021-02-04 | Hennepin | Minnesota | 27053 | 96570 | 1541 |
993191 | 993191 | 2021-02-03 | Hennepin | Minnesota | 27053 | 96262 | 1539 |
989945 | 989945 | 2021-02-02 | Hennepin | Minnesota | 27053 | 96097 | 1533 |
986698 | 986698 | 2021-02-01 | Hennepin | Minnesota | 27053 | 95963 | 1530 |
983451 | 983451 | 2021-01-31 | Hennepin | Minnesota | 27053 | 95801 | 1529 |
980205 | 980205 | 2021-01-30 | Hennepin | Minnesota | 27053 | 95579 | 1526 |
976959 | 976959 | 2021-01-29 | Hennepin | Minnesota | 27053 | 95383 | 1522 |
973714 | 973714 | 2021-01-28 | Hennepin | Minnesota | 27053 | 95126 | 1513 |
970469 | 970469 | 2021-01-27 | Hennepin | Minnesota | 27053 | 94872 | 1509 |
967224 | 967224 | 2021-01-26 | Hennepin | Minnesota | 27053 | 94707 | 1506 |
963980 | 963980 | 2021-01-25 | Hennepin | Minnesota | 27053 | 94544 | 1502 |
960735 | 960735 | 2021-01-24 | Hennepin | Minnesota | 27053 | 94378 | 1502 |
957489 | 957489 | 2021-01-23 | Hennepin | Minnesota | 27053 | 94138 | 1495 |
954244 | 954244 | 2021-01-22 | Hennepin | Minnesota | 27053 | 93813 | 1490 |
950999 | 950999 | 2021-01-21 | Hennepin | Minnesota | 27053 | 93511 | 1486 |
947753 | 947753 | 2021-01-20 | Hennepin | Minnesota | 27053 | 93303 | 1483 |
944506 | 944506 | 2021-01-19 | Hennepin | Minnesota | 27053 | 93101 | 1480 |
941261 | 941261 | 2021-01-18 | Hennepin | Minnesota | 27053 | 92930 | 1478 |
938016 | 938016 | 2021-01-17 | Hennepin | Minnesota | 27053 | 92747 | 1474 |
934771 | 934771 | 2021-01-16 | Hennepin | Minnesota | 27053 | 92491 | 1470 |
931526 | 931526 | 2021-01-15 | Hennepin | Minnesota | 27053 | 92172 | 1468 |
928281 | 928281 | 2021-01-14 | Hennepin | Minnesota | 27053 | 91859 | 1461 |
925035 | 925035 | 2021-01-13 | Hennepin | Minnesota | 27053 | 91596 | 1449 |
921790 | 921790 | 2021-01-12 | Hennepin | Minnesota | 27053 | 91292 | 1448 |
918545 | 918545 | 2021-01-11 | Hennepin | Minnesota | 27053 | 91060 | 1447 |
915300 | 915300 | 2021-01-10 | Hennepin | Minnesota | 27053 | 90839 | 1447 |
912055 | 912055 | 2021-01-09 | Hennepin | Minnesota | 27053 | 90265 | 1443 |
908810 | 908810 | 2021-01-08 | Hennepin | Minnesota | 27053 | 89708 | 1434 |
905564 | 905564 | 2021-01-07 | Hennepin | Minnesota | 27053 | 89175 | 1426 |
902319 | 902319 | 2021-01-06 | Hennepin | Minnesota | 27053 | 88832 | 1417 |
899074 | 899074 | 2021-01-05 | Hennepin | Minnesota | 27053 | 88377 | 1408 |
895829 | 895829 | 2021-01-04 | Hennepin | Minnesota | 27053 | 88062 | 1407 |
892582 | 892582 | 2021-01-03 | Hennepin | Minnesota | 27053 | 87386 | 1405 |
889336 | 889336 | 2021-01-02 | Hennepin | Minnesota | 27053 | 86762 | 1390 |
886090 | 886090 | 2021-01-01 | Hennepin | Minnesota | 27053 | 86273 | 1382 |
882845 | 882845 | 2020-12-31 | Hennepin | Minnesota | 27053 | 86273 | 1382 |
879600 | 879600 | 2020-12-30 | Hennepin | Minnesota | 27053 | 85878 | 1370 |
876355 | 876355 | 2020-12-29 | Hennepin | Minnesota | 27053 | 85482 | 1365 |
873110 | 873110 | 2020-12-28 | Hennepin | Minnesota | 27053 | 85354 | 1360 |
869865 | 869865 | 2020-12-27 | Hennepin | Minnesota | 27053 | 85143 | 1357 |
866620 | 866620 | 2020-12-26 | Hennepin | Minnesota | 27053 | 84526 | 1351 |
863375 | 863375 | 2020-12-25 | Hennepin | Minnesota | 27053 | 84116 | 1345 |
860130 | 860130 | 2020-12-24 | Hennepin | Minnesota | 27053 | 84116 | 1345 |
856885 | 856885 | 2020-12-23 | Hennepin | Minnesota | 27053 | 83795 | 1328 |
853640 | 853640 | 2020-12-22 | Hennepin | Minnesota | 27053 | 83520 | 1321 |
850395 | 850395 | 2020-12-21 | Hennepin | Minnesota | 27053 | 83133 | 1318 |
847150 | 847150 | 2020-12-20 | Hennepin | Minnesota | 27053 | 82734 | 1313 |
843904 | 843904 | 2020-12-19 | Hennepin | Minnesota | 27053 | 82158 | 1300 |
840659 | 840659 | 2020-12-18 | Hennepin | Minnesota | 27053 | 81645 | 1288 |
837414 | 837414 | 2020-12-17 | Hennepin | Minnesota | 27053 | 81200 | 1281 |
834168 | 834168 | 2020-12-16 | Hennepin | Minnesota | 27053 | 80696 | 1259 |
830921 | 830921 | 2020-12-15 | Hennepin | Minnesota | 27053 | 80287 | 1252 |
827675 | 827675 | 2020-12-14 | Hennepin | Minnesota | 27053 | 79756 | 1246 |
824428 | 824428 | 2020-12-13 | Hennepin | Minnesota | 27053 | 79134 | 1243 |
821182 | 821182 | 2020-12-12 | Hennepin | Minnesota | 27053 | 78430 | 1231 |
817936 | 817936 | 2020-12-11 | Hennepin | Minnesota | 27053 | 77579 | 1216 |
814690 | 814690 | 2020-12-10 | Hennepin | Minnesota | 27053 | 76902 | 1200 |
811445 | 811445 | 2020-12-09 | Hennepin | Minnesota | 27053 | 76278 | 1186 |
808200 | 808200 | 2020-12-08 | Hennepin | Minnesota | 27053 | 75353 | 1176 |
804955 | 804955 | 2020-12-07 | Hennepin | Minnesota | 27053 | 74735 | 1170 |
801710 | 801710 | 2020-12-06 | Hennepin | Minnesota | 27053 | 73512 | 1167 |
798465 | 798465 | 2020-12-05 | Hennepin | Minnesota | 27053 | 72366 | 1161 |
795220 | 795220 | 2020-12-04 | Hennepin | Minnesota | 27053 | 71192 | 1153 |
791975 | 791975 | 2020-12-03 | Hennepin | Minnesota | 27053 | 70069 | 1145 |
788730 | 788730 | 2020-12-02 | Hennepin | Minnesota | 27053 | 68898 | 1130 |
785485 | 785485 | 2020-12-01 | Hennepin | Minnesota | 27053 | 67913 | 1121 |
782241 | 782241 | 2020-11-30 | Hennepin | Minnesota | 27053 | 67336 | 1116 |
778995 | 778995 | 2020-11-29 | Hennepin | Minnesota | 27053 | 66164 | 1115 |
775750 | 775750 | 2020-11-28 | Hennepin | Minnesota | 27053 | 64142 | 1113 |
772505 | 772505 | 2020-11-27 | Hennepin | Minnesota | 27053 | 62433 | 1107 |
769260 | 769260 | 2020-11-26 | Hennepin | Minnesota | 27053 | 61651 | 1100 |
766014 | 766014 | 2020-11-25 | Hennepin | Minnesota | 27053 | 61651 | 1100 |
762769 | 762769 | 2020-11-24 | Hennepin | Minnesota | 27053 | 60524 | 1095 |
759524 | 759524 | 2020-11-23 | Hennepin | Minnesota | 27053 | 59003 | 1089 |
756277 | 756277 | 2020-11-22 | Hennepin | Minnesota | 27053 | 57926 | 1084 |
753031 | 753031 | 2020-11-21 | Hennepin | Minnesota | 27053 | 56816 | 1080 |
749785 | 749785 | 2020-11-20 | Hennepin | Minnesota | 27053 | 55721 | 1075 |
746539 | 746539 | 2020-11-19 | Hennepin | Minnesota | 27053 | 54662 | 1066 |
743292 | 743292 | 2020-11-18 | Hennepin | Minnesota | 27053 | 53486 | 1061 |
740045 | 740045 | 2020-11-17 | Hennepin | Minnesota | 27053 | 52689 | 1055 |
736801 | 736801 | 2020-11-16 | Hennepin | Minnesota | 27053 | 51712 | 1050 |
733555 | 733555 | 2020-11-15 | Hennepin | Minnesota | 27053 | 50352 | 1044 |
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);