ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 27131 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054898 | 1054898 | 2021-02-22 | Rice | Minnesota | 27131 | 6638 | 90 |
1051651 | 1051651 | 2021-02-21 | Rice | Minnesota | 27131 | 6632 | 90 |
1048404 | 1048404 | 2021-02-20 | Rice | Minnesota | 27131 | 6629 | 89 |
1045158 | 1045158 | 2021-02-19 | Rice | Minnesota | 27131 | 6622 | 89 |
1041913 | 1041913 | 2021-02-18 | Rice | Minnesota | 27131 | 6614 | 88 |
1038668 | 1038668 | 2021-02-17 | Rice | Minnesota | 27131 | 6601 | 87 |
1035423 | 1035423 | 2021-02-16 | Rice | Minnesota | 27131 | 6598 | 87 |
1032178 | 1032178 | 2021-02-15 | Rice | Minnesota | 27131 | 6594 | 87 |
1028931 | 1028931 | 2021-02-14 | Rice | Minnesota | 27131 | 6588 | 87 |
1025685 | 1025685 | 2021-02-13 | Rice | Minnesota | 27131 | 6583 | 87 |
1022440 | 1022440 | 2021-02-12 | Rice | Minnesota | 27131 | 6566 | 87 |
1019195 | 1019195 | 2021-02-11 | Rice | Minnesota | 27131 | 6551 | 84 |
1015950 | 1015950 | 2021-02-10 | Rice | Minnesota | 27131 | 6535 | 84 |
1012705 | 1012705 | 2021-02-09 | Rice | Minnesota | 27131 | 6522 | 83 |
1009460 | 1009460 | 2021-02-08 | Rice | Minnesota | 27131 | 6510 | 82 |
1006213 | 1006213 | 2021-02-07 | Rice | Minnesota | 27131 | 6506 | 82 |
1002967 | 1002967 | 2021-02-06 | Rice | Minnesota | 27131 | 6487 | 82 |
999722 | 999722 | 2021-02-05 | Rice | Minnesota | 27131 | 6475 | 82 |
996476 | 996476 | 2021-02-04 | Rice | Minnesota | 27131 | 6452 | 82 |
993230 | 993230 | 2021-02-03 | Rice | Minnesota | 27131 | 6419 | 82 |
989984 | 989984 | 2021-02-02 | Rice | Minnesota | 27131 | 6415 | 78 |
986737 | 986737 | 2021-02-01 | Rice | Minnesota | 27131 | 6408 | 78 |
983490 | 983490 | 2021-01-31 | Rice | Minnesota | 27131 | 6391 | 78 |
980244 | 980244 | 2021-01-30 | Rice | Minnesota | 27131 | 6372 | 78 |
976998 | 976998 | 2021-01-29 | Rice | Minnesota | 27131 | 6351 | 78 |
973753 | 973753 | 2021-01-28 | Rice | Minnesota | 27131 | 6335 | 76 |
970508 | 970508 | 2021-01-27 | Rice | Minnesota | 27131 | 6273 | 75 |
967263 | 967263 | 2021-01-26 | Rice | Minnesota | 27131 | 6256 | 74 |
964019 | 964019 | 2021-01-25 | Rice | Minnesota | 27131 | 6247 | 74 |
960774 | 960774 | 2021-01-24 | Rice | Minnesota | 27131 | 6242 | 74 |
957528 | 957528 | 2021-01-23 | Rice | Minnesota | 27131 | 6211 | 70 |
954283 | 954283 | 2021-01-22 | Rice | Minnesota | 27131 | 6180 | 70 |
951038 | 951038 | 2021-01-21 | Rice | Minnesota | 27131 | 6139 | 69 |
947792 | 947792 | 2021-01-20 | Rice | Minnesota | 27131 | 6107 | 69 |
944545 | 944545 | 2021-01-19 | Rice | Minnesota | 27131 | 6068 | 68 |
941300 | 941300 | 2021-01-18 | Rice | Minnesota | 27131 | 6052 | 68 |
938055 | 938055 | 2021-01-17 | Rice | Minnesota | 27131 | 6041 | 68 |
934810 | 934810 | 2021-01-16 | Rice | Minnesota | 27131 | 6001 | 66 |
931565 | 931565 | 2021-01-15 | Rice | Minnesota | 27131 | 5978 | 66 |
928320 | 928320 | 2021-01-14 | Rice | Minnesota | 27131 | 5952 | 66 |
925074 | 925074 | 2021-01-13 | Rice | Minnesota | 27131 | 5918 | 65 |
921829 | 921829 | 2021-01-12 | Rice | Minnesota | 27131 | 5891 | 64 |
918584 | 918584 | 2021-01-11 | Rice | Minnesota | 27131 | 5872 | 64 |
915339 | 915339 | 2021-01-10 | Rice | Minnesota | 27131 | 5853 | 63 |
912094 | 912094 | 2021-01-09 | Rice | Minnesota | 27131 | 5830 | 62 |
908849 | 908849 | 2021-01-08 | Rice | Minnesota | 27131 | 5773 | 62 |
905603 | 905603 | 2021-01-07 | Rice | Minnesota | 27131 | 5724 | 60 |
902358 | 902358 | 2021-01-06 | Rice | Minnesota | 27131 | 5689 | 60 |
899113 | 899113 | 2021-01-05 | Rice | Minnesota | 27131 | 5665 | 57 |
895868 | 895868 | 2021-01-04 | Rice | Minnesota | 27131 | 5626 | 57 |
892621 | 892621 | 2021-01-03 | Rice | Minnesota | 27131 | 5600 | 57 |
889375 | 889375 | 2021-01-02 | Rice | Minnesota | 27131 | 5570 | 55 |
886129 | 886129 | 2021-01-01 | Rice | Minnesota | 27131 | 5516 | 55 |
882884 | 882884 | 2020-12-31 | Rice | Minnesota | 27131 | 5516 | 55 |
879639 | 879639 | 2020-12-30 | Rice | Minnesota | 27131 | 5478 | 55 |
876394 | 876394 | 2020-12-29 | Rice | Minnesota | 27131 | 5463 | 52 |
873149 | 873149 | 2020-12-28 | Rice | Minnesota | 27131 | 5451 | 52 |
869904 | 869904 | 2020-12-27 | Rice | Minnesota | 27131 | 5435 | 52 |
866659 | 866659 | 2020-12-26 | Rice | Minnesota | 27131 | 5358 | 50 |
863414 | 863414 | 2020-12-25 | Rice | Minnesota | 27131 | 5312 | 48 |
860169 | 860169 | 2020-12-24 | Rice | Minnesota | 27131 | 5312 | 48 |
856924 | 856924 | 2020-12-23 | Rice | Minnesota | 27131 | 5264 | 47 |
853679 | 853679 | 2020-12-22 | Rice | Minnesota | 27131 | 5243 | 47 |
850434 | 850434 | 2020-12-21 | Rice | Minnesota | 27131 | 5229 | 47 |
847189 | 847189 | 2020-12-20 | Rice | Minnesota | 27131 | 5201 | 47 |
843943 | 843943 | 2020-12-19 | Rice | Minnesota | 27131 | 5150 | 47 |
840698 | 840698 | 2020-12-18 | Rice | Minnesota | 27131 | 5108 | 47 |
837453 | 837453 | 2020-12-17 | Rice | Minnesota | 27131 | 5015 | 47 |
834207 | 834207 | 2020-12-16 | Rice | Minnesota | 27131 | 4973 | 47 |
830960 | 830960 | 2020-12-15 | Rice | Minnesota | 27131 | 4934 | 46 |
827714 | 827714 | 2020-12-14 | Rice | Minnesota | 27131 | 4916 | 46 |
824467 | 824467 | 2020-12-13 | Rice | Minnesota | 27131 | 4885 | 45 |
821221 | 821221 | 2020-12-12 | Rice | Minnesota | 27131 | 4842 | 45 |
817975 | 817975 | 2020-12-11 | Rice | Minnesota | 27131 | 4765 | 45 |
814729 | 814729 | 2020-12-10 | Rice | Minnesota | 27131 | 4707 | 42 |
811484 | 811484 | 2020-12-09 | Rice | Minnesota | 27131 | 4674 | 40 |
808239 | 808239 | 2020-12-08 | Rice | Minnesota | 27131 | 4642 | 40 |
804994 | 804994 | 2020-12-07 | Rice | Minnesota | 27131 | 4612 | 39 |
801749 | 801749 | 2020-12-06 | Rice | Minnesota | 27131 | 4559 | 39 |
798504 | 798504 | 2020-12-05 | Rice | Minnesota | 27131 | 4527 | 39 |
795259 | 795259 | 2020-12-04 | Rice | Minnesota | 27131 | 4384 | 39 |
792014 | 792014 | 2020-12-03 | Rice | Minnesota | 27131 | 4323 | 38 |
788769 | 788769 | 2020-12-02 | Rice | Minnesota | 27131 | 4277 | 38 |
785524 | 785524 | 2020-12-01 | Rice | Minnesota | 27131 | 4229 | 37 |
782280 | 782280 | 2020-11-30 | Rice | Minnesota | 27131 | 4192 | 37 |
779034 | 779034 | 2020-11-29 | Rice | Minnesota | 27131 | 4128 | 36 |
775789 | 775789 | 2020-11-28 | Rice | Minnesota | 27131 | 4031 | 36 |
772544 | 772544 | 2020-11-27 | Rice | Minnesota | 27131 | 3933 | 35 |
769299 | 769299 | 2020-11-26 | Rice | Minnesota | 27131 | 3860 | 33 |
766053 | 766053 | 2020-11-25 | Rice | Minnesota | 27131 | 3860 | 33 |
762808 | 762808 | 2020-11-24 | Rice | Minnesota | 27131 | 3777 | 32 |
759563 | 759563 | 2020-11-23 | Rice | Minnesota | 27131 | 3614 | 31 |
756316 | 756316 | 2020-11-22 | Rice | Minnesota | 27131 | 3503 | 31 |
753070 | 753070 | 2020-11-21 | Rice | Minnesota | 27131 | 3431 | 30 |
749824 | 749824 | 2020-11-20 | Rice | Minnesota | 27131 | 3358 | 28 |
746578 | 746578 | 2020-11-19 | Rice | Minnesota | 27131 | 3248 | 27 |
743331 | 743331 | 2020-11-18 | Rice | Minnesota | 27131 | 3071 | 27 |
740084 | 740084 | 2020-11-17 | Rice | Minnesota | 27131 | 2954 | 25 |
736840 | 736840 | 2020-11-16 | Rice | Minnesota | 27131 | 2879 | 25 |
733594 | 733594 | 2020-11-15 | Rice | Minnesota | 27131 | 2758 | 25 |
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);