{ mayor, deputy, citizen, invitee, applicant } are the keys, make into a loop and reduce to one SQL call
An enumeration may be good so that valid statuses can be edited once