Something a little like this happens on our elections app: politicians have a name and party, but sometimes run in an election under a different name (eg. "Robe

Something a little like this happens on our elections app: politicians have a name and party, but sometimes run in an election under a different name (eg. "Robert" runs as "Bob") and party (eg. Joe Lieberman lost his primary but won in the general as an independent). And sometimes they're doing this in multiple elections at once.