title: Database design for list of US Senators in MySQL
body: <p>I'm designing a table that simply keeps a list of current US Senators and some related information (much of which I'm getting from the awesome NY Times Congress API). Creating the table for Representatives was easy, because I just created a <code>PRIMARY KEY</code> on their <code>state</code> and <code>district number</code>. This has stumped me, though.</p>
  
  <p>I need to be updating the information in this table nightly, and will be doing an <code>INSERT...ON DUPLICATE KEY UPDATE</code>.</p>
  
  <p>Any thoughts on how to go about designing this?</p>