Spreadsheet: 806059d1669085281-how-to-find-the-majority-value-of-a-column-until-a-value-changes-in-another-column-s666-pq-how-to-find-the-majority-value-of-a-column-until-a-value-changes-in-another-column3
Sheet: Sheet1

Year | STATE | STATE ABBREVIATION | dist | PARTY |  |  |  | Year | STATE | STATE ABBREVIATION | dist | PARTY | Majority
2020 | Alabama | AL | AL1 | Republican |  |  |  | 2020 | Connecticut | CT | CT4 | Democrat | Democrat
2020 | Alabama | AL | AL2 | Republican |  |  |  | 2020 | Connecticut | CT | CT3 | Democrat | Democrat
2020 | Alabama | AL | AL3 | Republican |  |  |  | 2020 | Connecticut | CT | CT5 | Democrat | Democrat
2020 | Alabama | AL | AL4 | Republican |  |  |  | 2020 | Hawaii | HI | HI2 | Democrat | Democrat
2020 | Alabama | AL | AL5 | Republican |  |  |  | 2020 | District of Columbia | DC | DC0 | Democrat | Democrat
2020 | Alabama | AL | AL6 | Republican |  |  |  | 2020 | Hawaii | HI | HI1 | Democrat | Democrat
2020 | Alabama | AL | AL7 | Democrat |  |  |  | 2020 | Delaware | DE | DE0 | Democrat | Democrat
2020 | Alaska | AK | AK0 | Republican |  |  |  | 2020 | Connecticut | CT | CT2 | Democrat | Democrat
2020 | Arizona | AZ | AZ1 | Democrat |  |  |  | 2020 | Connecticut | CT | CT1 | Democrat | Democrat
2020 | Arizona | AZ | AZ2 | Democrat |  |  |  | 2020 | Idaho | ID | ID2 | Republican | Republican
2020 | Arizona | AZ | AZ3 | Democrat |  |  |  | 2020 | Arkansas | AR | AR2 | Republican | Republican
2020 | Arizona | AZ | AZ4 | Republican |  |  |  | 2020 | Arkansas | AR | AR1 | Republican | Republican
2020 | Arizona | AZ | AZ5 | Republican |  |  |  | 2020 | Arkansas | AR | AR4 | Republican | Republican
2020 | Arizona | AZ | AZ6 | Republican |  |  |  | 2020 | Arkansas | AR | AR3 | Republican | Republican
2020 | Arizona | AZ | AZ7 | Democrat |  |  |  | 2020 | Alaska | AK | AK0 | Republican | Republican
2020 | Arizona | AZ | AZ8 | Republican |  |  |  | 2020 | Idaho | ID | ID1 | Republican | Republican
2020 | Arizona | AZ | AZ9 | Democrat |  |  |  | 2020 | Florida | FL | FL13 | Democrat | Split
2020 | Arkansas | AR | AR1 | Republican |  |  |  | 2020 | Florida | FL | FL12 | Republican | Split
2020 | Arkansas | AR | AR2 | Republican |  |  |  | 2020 | Florida | FL | FL14 | Democrat | Split
2020 | Arkansas | AR | AR3 | Republican |  |  |  | 2020 | Florida | FL | FL15 | Republican | Split
2020 | Arkansas | AR | AR4 | Republican |  |  |  | 2020 | Florida | FL | FL22 | Democrat | Split
2020 | California | CA | CA1 | Republican |  |  |  | 2020 | Florida | FL | FL21 | Democrat | Split
2020 | California | CA | CA2 | Democrat |  |  |  | 2020 | Florida | FL | FL24 | Democrat | Split
2020 | California | CA | CA3 | Democrat |  |  |  | 2020 | Florida | FL | FL23 | Democrat | Split
2020 | California | CA | CA4 | Republican |  |  |  | 2020 | Florida | FL | FL20 | Democrat | Split
2020 | California | CA | CA5 | Democrat |  |  |  | 2020 | Florida | FL | FL17 | Republican | Split
2020 | California | CA | CA6 | Democrat |  |  |  | 2020 | Florida | FL | FL16 | Republican | Split
2020 | California | CA | CA7 | Democrat |  |  |  | 2020 | Florida | FL | FL19 | Republican | Split
2020 | California | CA | CA8 | Republican |  |  |  | 2020 | Florida | FL | FL18 | Republican | Split
2020 | California | CA | CA9 | Democrat |  |  |  | 2020 | Florida | FL | FL11 | Republican | Split
2020 | California | CA | CA10 | Democrat |  |  |  | 2020 | Florida | FL | FL1 | Republican | Split
2020 | California | CA | CA11 | Democrat |  |  |  | 2020 | Florida | FL | FL2 | Republican | Split
2020 | California | CA | CA12 | Democrat |  |  |  | 2020 | Florida | FL | FL3 | Republican | Split
2020 | California | CA | CA13 | Democrat |  |  |  | 2020 | Colorado | CO | CO5 | Republican | Split
2020 | California | CA | CA14 | Democrat |  |  |  | 2020 | Colorado | CO | CO6 | Democrat | Split
2020 | California | CA | CA15 | Democrat |  |  |  | 2020 | Colorado | CO | CO7 | Democrat | Split
2020 | California | CA | CA16 | Democrat |  |  |  | 2020 | Florida | FL | FL4 | Republican | Split
2020 | California | CA | CA17 | Democrat |  |  |  | 2020 | Florida | FL | FL8 | Republican | Split
2020 | California | CA | CA18 | Democrat |  |  |  | 2020 | Florida | FL | FL9 | Democrat | Split
2020 | California | CA | [NAME] | Democrat |  |  |  | 2020 | Florida | FL | FL10 | Democrat | Split
2020 | California | CA | CA20 | Democrat |  |  |  | 2020 | Florida | FL | FL5 | Democrat | Split
2020 | California | CA | CA21 | Republican |  |  |  | 2020 | Florida | FL | FL6 | Republican | Split
2020 | California | CA | CA22 | Republican |  |  |  | 2020 | Florida | FL | FL7 | Democrat | Split
2020 | California | CA | CA23 | Republican |  |  |  | 2020 | Florida | FL | FL25 | Democrat | Split
2020 | California | CA | CA24 | Democrat |  |  |  | 2020 | Illinois | IL | IL7 | Democrat | Split
2020 | California | CA | CA25 | Republican |  |  |  | 2020 | Illinois | IL | IL6 | Democrat | Split
2020 | California | CA | CA26 | Democrat |  |  |  | 2020 | Illinois | IL | IL9 | Democrat | Split
2020 | California | CA | CA27 | Democrat |  |  |  | 2020 | Illinois | IL | IL8 | Democrat | Split
2020 | California | CA | CA28 | Democrat |  |  |  | 2020 | Illinois | IL | IL3 | Democrat | Split
2020 | California | CA | CA29 | Democrat |  |  |  | 2020 | Illinois | IL | IL2 | Democrat | Split
2020 | California | CA | CA30 | Democrat |  |  |  | 2020 | Illinois | IL | IL5 | Democrat | Split
2020 | California | CA | CA31 | Democrat |  |  |  | 2020 | Illinois | IL | IL4 | Democrat | Split
2020 | California | CA | CA32 | Democrat |  |  |  | 2020 | Illinois | IL | IL10 | Democrat | Split
2020 | California | CA | CA33 | Democrat |  |  |  | 2020 | Illinois | IL | IL16 | Republican | Split
2020 | California | CA | CA34 | Democrat |  |  |  | 2020 | Illinois | IL | IL15 | Republican | Split
2020 | California | CA | CA35 | Democrat |  |  |  | 2020 | Illinois | IL | IL18 | Republican | Split
2020 | California | CA | CA36 | Democrat |  |  |  | 2020 | Illinois | IL | IL17 | Democrat | Split
2020 | California | CA | CA37 | Democrat |  |  |  | 2020 | Illinois | IL | IL12 | Republican | Split
2020 | California | CA | CA38 | Democrat |  |  |  | 2020 | Illinois | IL | IL11 | Democrat | Split
2020 | California | CA | CA39 | Republican |  |  |  | 2020 | Illinois | IL | IL14 | Democrat | Split
2020 | California | CA | CA40 | Democrat |  |  |  | 2020 | Illinois | IL | IL13 | Republican | Split
2020 | California | CA | CA41 | Democrat |  |  |  | 2020 | Georgia | GA | GA4 | Democrat | Split
2020 | California | CA | CA42 | Republican |  |  |  | 2020 | Georgia | GA | GA3 | Republican | Split
2020 | California | CA | CA43 | Democrat |  |  |  | 2020 | Georgia | GA | GA6 | Democrat | Split
2020 | California | CA | CA44 | Democrat |  |  |  | 2020 | Georgia | GA | [NAME] | Democrat | Split
2020 | California | CA | CA45 | Democrat |  |  |  | 2020 | Florida | FL | FL27 | Republican | Split
2020 | California | CA | CA46 | Democrat |  |  |  | 2020 | Florida | FL | FL26 | Republican | Split
2020 | California | CA | CA47 | Democrat |  |  |  | 2020 | Georgia | GA | GA2 | Democrat | Split
2020 | California | CA | CA48 | Republican |  |  |  | 2020 | Georgia | GA | GA1 | Republican | Split
2020 | California | CA | CA49 | Democrat |  |  |  | 2020 | Georgia | GA | GA7 | Democrat | Split
2020 | California | CA | CA50 | Republican |  |  |  | 2020 | Georgia | GA | GA13 | Democrat | Split
2020 | California | CA | CA51 | Democrat |  |  |  | 2020 | Georgia | GA | GA12 | Republican | Split
2020 | California | CA | CA52 | Democrat |  |  |  | 2020 | Illinois | IL | IL1 | Democrat | Split
2020 | California | CA | CA53 | Democrat |  |  |  | 2020 | Georgia | GA | GA14 | Republican | Split
2020 | Colorado | CO | CO1 | Democrat |  |  |  | 2020 | Georgia | GA | GA9 | Republican | Split
2020 | Colorado | CO | CO2 | Democrat |  |  |  | 2020 | Georgia | GA | GA8 | Republican | Split
2020 | Colorado | CO | CO3 | Republican |  |  |  | 2020 | Georgia | GA | GA11 | Republican | Split
2020 | Colorado | CO | CO4 | Republican |  |  |  | 2020 | Georgia | GA | GA10 | Republican | Split
2020 | Colorado | CO | CO5 | Republican |  |  |  | 2020 | California | CA | CA9 | Democrat | Split
2020 | Colorado | CO | CO6 | Democrat |  |  |  | 2020 | California | CA | CA8 | Republican | Split
2020 | Colorado | CO | CO7 | Democrat |  |  |  | 2020 | California | CA | CA11 | Democrat | Split
2020 | Connecticut | CT | CT1 | Democrat |  |  |  | 2020 | California | CA | CA10 | Democrat | Split
2020 | Connecticut | CT | CT2 | Democrat |  |  |  | 2020 | California | CA | CA7 | Democrat | Split
2020 | Connecticut | CT | CT3 | Democrat |  |  |  | 2020 | California | CA | CA4 | Republican | Split
2020 | Connecticut | CT | CT4 | Democrat |  |  |  | 2020 | California | CA | CA3 | Democrat | Split
2020 | Connecticut | CT | CT5 | Democrat |  |  |  | 2020 | California | CA | CA6 | Democrat | Split
2020 | Delaware | DE | DE0 | Democrat |  |  |  | 2020 | California | CA | CA5 | Democrat | Split
2020 | District of Columbia | DC | DC0 | Democrat |  |  |  | 2020 | California | CA | CA18 | Democrat | Split
2020 | Florida | FL | FL1 | Republican |  |  |  | 2020 | California | CA | CA17 | Democrat | Split
2020 | Florida | FL | FL2 | Republican |  |  |  | 2020 | California | CA | CA20 | Democrat | Split
2020 | Florida | FL | FL3 | Republican |  |  |  | 2020 | California | CA | [NAME] | Democrat | Split
2020 | Florida | FL | FL4 | Republican |  |  |  | 2020 | California | CA | CA16 | Democrat | Split
2020 | Florida | FL | FL5 | Democrat |  |  |  | 2020 | California | CA | CA13 | Democrat | Split
2020 | Florida | FL | FL6 | Republican |  |  |  | 2020 | California | CA | CA12 | Democrat | Split
2020 | Florida | FL | FL7 | Democrat |  |  |  | 2020 | California | CA | CA15 | Democrat | Split
2020 | Florida | FL | FL8 | Republican |  |  |  | 2020 | California | CA | CA14 | Democrat | Split
2020 | Florida | FL | FL9 | Democrat |  |  |  | 2020 | Alabama | AL | AL7 | Democrat | Split
2020 | Florida | FL | FL10 | Democrat |  |  |  | 2020 | Alabama | AL | AL6 | Republican | Split
2020 | Florida | FL | FL11 | Republican |  |  |  | 2020 | Arizona | AZ | AZ2 | Democrat | Split
2020 | Florida | FL | FL12 | Republican |  |  |  | 2020 | Arizona | AZ | AZ1 | Democrat | Split
2020 | Florida | FL | FL13 | Democrat |  |  |  | 2020 | Alabama | AL | AL5 | Republican | Split |  |  | ... | ... | ... | ... | ... | ...
2020 | Florida | FL | FL14 | Democrat |  |  |  | 2020 | Alabama | AL | AL2 | Republican | Split
2020 | Florida | FL | FL15 | Republican |  |  |  | 2020 | Alabama | AL | AL1 | Republican | Split
2020 | Florida | FL | FL16 | Republican |  |  |  | 2020 | Alabama | AL | AL4 | Republican | Split
2020 | Florida | FL | FL17 | Republican |  |  |  | 2020 | Alabama | AL | AL3 | Republican | Split
2020 | Florida | FL | FL18 | Republican |  |  |  | 2020 | Arizona | AZ | AZ9 | Democrat | Split
2020 | Florida | FL | FL19 | Republican |  |  |  | 2020 | Arizona | AZ | AZ8 | Republican | Split
2020 | Florida | FL | FL20 | Democrat |  |  |  | 2020 | California | CA | CA2 | Democrat | Split
2020 | Florida | FL | FL21 | Democrat |  |  |  | 2020 | California | CA | CA1 | Republican | Split
2020 | Florida | FL | FL22 | Democrat |  |  |  | 2020 | Arizona | AZ | AZ7 | Democrat | Split
2020 | Florida | FL | FL23 | Democrat |  |  |  | 2020 | Arizona | AZ | AZ4 | Republican | Split
2020 | Florida | FL | FL24 | Democrat |  |  |  | 2020 | Arizona | AZ | AZ3 | Democrat | Split
2020 | Florida | FL | FL25 | Democrat |  |  |  | 2020 | Arizona | AZ | AZ6 | Republican | Split
2020 | Florida | FL | FL26 | Republican |  |  |  | 2020 | Arizona | AZ | AZ5 | Republican | Split
2020 | Florida | FL | FL27 | Republican |  |  |  | 2020 | California | CA | CA21 | Republican | Split
2020 | Georgia | GA | GA1 | Republican |  |  |  | 2020 | California | CA | CA46 | Democrat | Split
2020 | Georgia | GA | GA2 | Democrat |  |  |  | 2020 | California | CA | CA45 | Democrat | Split
2020 | Georgia | GA | GA3 | Republican |  |  |  | 2020 | California | CA | CA48 | Republican | Split
2020 | Georgia | GA | GA4 | Democrat |  |  |  | 2020 | California | CA | CA47 | Democrat | Split
2020 | Georgia | GA | [NAME] | Democrat |  |  |  | 2020 | California | CA | CA44 | Democrat | Split
2020 | Georgia | GA | GA6 | Democrat |  |  |  | 2020 | California | CA | CA41 | Democrat | Split
2020 | Georgia | GA | GA7 | Democrat |  |  |  | 2020 | California | CA | CA40 | Democrat | Split
2020 | Georgia | GA | GA8 | Republican |  |  |  | 2020 | California | CA | CA43 | Democrat | Split
2020 | Georgia | GA | GA9 | Republican |  |  |  | 2020 | California | CA | CA42 | Republican | Split
2020 | Georgia | GA | GA10 | Republican |  |  |  | 2020 | Colorado | CO | CO2 | Democrat | Split
2020 | Georgia | GA | GA11 | Republican |  |  |  | 2020 | Colorado | CO | CO1 | Democrat | Split
2020 | Georgia | GA | GA12 | Republican |  |  |  | 2020 | Colorado | CO | CO4 | Republican | Split
2020 | Georgia | GA | GA13 | Democrat |  |  |  | 2020 | Colorado | CO | CO3 | Republican | Split
2020 | Georgia | GA | GA14 | Republican |  |  |  | 2020 | California | CA | CA53 | Democrat | Split
2020 | Hawaii | HI | HI1 | Democrat |  |  |  | 2020 | California | CA | CA50 | Republican | Split
2020 | Hawaii | HI | HI2 | Democrat |  |  |  | 2020 | California | CA | CA49 | Democrat | Split
2020 | Idaho | ID | ID1 | Republican |  |  |  | 2020 | California | CA | CA52 | Democrat | Split
2020 | Idaho | ID | ID2 | Republican |  |  |  | 2020 | California | CA | CA51 | Democrat | Split
2020 | Illinois | IL | IL1 | Democrat |  |  |  | 2020 | California | CA | CA28 | Democrat | Split
2020 | Illinois | IL | IL2 | Democrat |  |  |  | 2020 | California | CA | CA27 | Democrat | Split
2020 | Illinois | IL | IL3 | Democrat |  |  |  | 2020 | California | CA | CA30 | Democrat | Split
2020 | Illinois | IL | IL4 | Democrat |  |  |  | 2020 | California | CA | CA29 | Democrat | Split
2020 | Illinois | IL | IL5 | Democrat |  |  |  | 2020 | California | CA | CA26 | Democrat | Split
2020 | Illinois | IL | IL6 | Democrat |  |  |  | 2020 | California | CA | CA23 | Republican | Split
2020 | Illinois | IL | IL7 | Democrat |  |  |  | 2020 | California | CA | CA22 | Republican | Split
2020 | Illinois | IL | IL8 | Democrat |  |  |  | 2020 | California | CA | CA25 | Republican | Split
2020 | Illinois | IL | IL9 | Democrat |  |  |  | 2020 | California | CA | CA24 | Democrat | Split
2020 | Illinois | IL | IL10 | Democrat |  |  |  | 2020 | California | CA | CA37 | Democrat | Split
2020 | Illinois | IL | IL11 | Democrat |  |  |  | 2020 | California | CA | CA36 | Democrat | Split
2020 | Illinois | IL | IL12 | Republican |  |  |  | 2020 | California | CA | CA39 | Republican | Split
2020 | Illinois | IL | IL13 | Republican |  |  |  | 2020 | California | CA | CA38 | Democrat | Split
2020 | Illinois | IL | IL14 | Democrat |  |  |  | 2020 | California | CA | CA35 | Democrat | Split
2020 | Illinois | IL | IL15 | Republican |  |  |  | 2020 | California | CA | CA32 | Democrat | Split
2020 | Illinois | IL | IL16 | Republican |  |  |  | 2020 | California | CA | CA31 | Democrat | Split
2020 | Illinois | IL | IL17 | Democrat |  |  |  | 2020 | California | CA | CA34 | Democrat | Split
2020 | Illinois | IL | IL18 | Republican |  |  |  | 2020 | California | CA | CA33 | Democrat | Split