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 |
---|---|---|---|---|---|---|---|
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 |
730310 | 730310 | 2020-11-14 | Hennepin | Minnesota | 27053 | 49262 | 1039 |
727067 | 727067 | 2020-11-13 | Hennepin | Minnesota | 27053 | 47534 | 1035 |
723824 | 723824 | 2020-11-12 | Hennepin | Minnesota | 27053 | 46555 | 1033 |
720581 | 720581 | 2020-11-11 | Hennepin | Minnesota | 27053 | 45372 | 1030 |
717338 | 717338 | 2020-11-10 | Hennepin | Minnesota | 27053 | 44547 | 1025 |
714094 | 714094 | 2020-11-09 | Hennepin | Minnesota | 27053 | 43570 | 1023 |
710850 | 710850 | 2020-11-08 | Hennepin | Minnesota | 27053 | 42695 | 1023 |
707606 | 707606 | 2020-11-07 | Hennepin | Minnesota | 27053 | 41436 | 1020 |
704363 | 704363 | 2020-11-06 | Hennepin | Minnesota | 27053 | 40559 | 1016 |
701121 | 701121 | 2020-11-05 | Hennepin | Minnesota | 27053 | 39724 | 1012 |
697877 | 697877 | 2020-11-04 | Hennepin | Minnesota | 27053 | 38911 | 1009 |
694634 | 694634 | 2020-11-03 | Hennepin | Minnesota | 27053 | 38272 | 1006 |
691392 | 691392 | 2020-11-02 | Hennepin | Minnesota | 27053 | 37513 | 1004 |
688147 | 688147 | 2020-11-01 | Hennepin | Minnesota | 27053 | 36936 | 1002 |
684903 | 684903 | 2020-10-31 | Hennepin | Minnesota | 27053 | 36580 | 1000 |
681660 | 681660 | 2020-10-30 | Hennepin | Minnesota | 27053 | 36126 | 997 |
678416 | 678416 | 2020-10-29 | Hennepin | Minnesota | 27053 | 35484 | 995 |
675174 | 675174 | 2020-10-28 | Hennepin | Minnesota | 27053 | 34988 | 995 |
671931 | 671931 | 2020-10-27 | Hennepin | Minnesota | 27053 | 34657 | 994 |
668689 | 668689 | 2020-10-26 | Hennepin | Minnesota | 27053 | 34290 | 991 |
665445 | 665445 | 2020-10-25 | Hennepin | Minnesota | 27053 | 34033 | 991 |
662200 | 662200 | 2020-10-24 | Hennepin | Minnesota | 27053 | 33719 | 984 |
658956 | 658956 | 2020-10-23 | Hennepin | Minnesota | 27053 | 33310 | 981 |
655711 | 655711 | 2020-10-22 | Hennepin | Minnesota | 27053 | 33024 | 980 |
652466 | 652466 | 2020-10-21 | Hennepin | Minnesota | 27053 | 32743 | 974 |
649221 | 649221 | 2020-10-20 | Hennepin | Minnesota | 27053 | 32544 | 966 |
645977 | 645977 | 2020-10-19 | Hennepin | Minnesota | 27053 | 32336 | 965 |
642730 | 642730 | 2020-10-18 | Hennepin | Minnesota | 27053 | 32050 | 965 |
639483 | 639483 | 2020-10-17 | Hennepin | Minnesota | 27053 | 31749 | 962 |
636237 | 636237 | 2020-10-16 | Hennepin | Minnesota | 27053 | 31472 | 962 |
632991 | 632991 | 2020-10-15 | Hennepin | Minnesota | 27053 | 31161 | 962 |
629746 | 629746 | 2020-10-14 | Hennepin | Minnesota | 27053 | 30923 | 959 |
626502 | 626502 | 2020-10-13 | Hennepin | Minnesota | 27053 | 30698 | 955 |
623260 | 623260 | 2020-10-12 | Hennepin | Minnesota | 27053 | 30456 | 954 |
620017 | 620017 | 2020-10-11 | Hennepin | Minnesota | 27053 | 30218 | 953 |
616775 | 616775 | 2020-10-10 | Hennepin | Minnesota | 27053 | 29929 | 951 |
613534 | 613534 | 2020-10-09 | Hennepin | Minnesota | 27053 | 29661 | 951 |
610292 | 610292 | 2020-10-08 | Hennepin | Minnesota | 27053 | 29404 | 947 |
607050 | 607050 | 2020-10-07 | Hennepin | Minnesota | 27053 | 29207 | 946 |
603807 | 603807 | 2020-10-06 | Hennepin | Minnesota | 27053 | 29045 | 944 |
600565 | 600565 | 2020-10-05 | Hennepin | Minnesota | 27053 | 28843 | 944 |
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);