I'm accounting for indirection via state legislatures, since it's the latter who ratify by simple majority - so the MPs in the state legislature who vote to ratify don't necessarily represent all the residents of that state (in fact, given the quirks of FPTP and tricks like gerrymandering, things can be ratified against popular majority in the state).