CREATE TABLE Country (
  id VARCHAR(5) NOT NULL,
  name VARCHAR(50),
  CONSTRAINT country_pk_id PRIMARY KEY (id)
);
CREATE TABLE Congress (
  id INTEGER NOT NULL,
  country_id VARCHAR(5) NOT NULL,
  CONSTRAINT congress_pk_id PRIMARY KEY (id),
  CONSTRAINT congress_fk_country_id FOREIGN KEY (country_id) REFERENCES Country (id) ON DELETE CASCADE
);
CREATE TABLE Senate (
  id INTEGER NOT NULL,
  congress_id INTEGER NOT NULL,
  CONSTRAINT senate_pk_id PRIMARY KEY (id),
  CONSTRAINT senate_fk_congress_id FOREIGN KEY (congress_id) REFERENCES Congress (id) ON DELETE CASCADE
);
CREATE TABLE Senator (
  id VARCHAR(15) NOT NULL,
  party VARCHAR(2) NOT NULL,
  firstName VARCHAR(20) NOT NULL,
  middleInitial VARCHAR(5) NULL,
  lastName VARCHAR(20) NOT NULL,
  suffix VARCHAR(5) NULL,
  state VARCHAR(2) NOT NULL,
  birthdate DATE NULL,
  dateAssumedOffice DATE NULL,
  senate_id INTEGER NOT NULL,
  CONSTRAINT senator_pk_id PRIMARY KEY (id),
  CONSTRAINT senator_fk_senate_id FOREIGN KEY (senate_id) REFERENCES Senate (id) ON DELETE CASCADE
);
CREATE TABLE State (
  id VARCHAR(2) NOT NULL,
  name VARCHAR(20) NOT NULL,
  country_id VARCHAR(5) NOT NULL,
  CONSTRAINT state_pk_id PRIMARY KEY (id),
  CONSTRAINT state_fk_country_id FOREIGN KEY (country_id) REFERENCES Country (id) ON DELETE CASCADE
);
ALTER TABLE Senator
  ADD CONSTRAINT senator_fk_state_id FOREIGN KEY (state) REFERENCES State (id) ON DELETE CASCADE;
CREATE TABLE Governor (
  id VARCHAR(15) NOT NULL,
  party VARCHAR(2) NOT NULL,
  firstName VARCHAR(20) NOT NULL,
  middleInitial VARCHAR(5) NULL,
  lastName VARCHAR(20) NOT NULL,
  suffix VARCHAR(5) NULL,
  dateAssumedOffice DATE NULL,
  state_id VARCHAR(15) NOT NULL,
  CONSTRAINT governor_pk_id PRIMARY KEY (id),
  CONSTRAINT governor_fk_state_id FOREIGN KEY (state_id) REFERENCES State (id) ON DELETE CASCADE
);
INSERT INTO country (id,name) VALUES 
  ('USA','United States of America');
INSERT INTO congress (id,country_id) VALUES 
  (1,'USA');
INSERT INTO senate (id,congress_id) VALUES 
  (1,1);
INSERT INTO state (id,name,country_id) VALUES 
  ('AK','Alaska','USA');
INSERT INTO state (id,name,country_id) VALUES 
  ('AL','Alabama','USA');
INSERT INTO state (id,name,country_id) VALUES 
  ('AR','Arkansas','USA');
INSERT INTO state (id,name,country_id) VALUES 
  ('AZ','Arizona','USA');
INSERT INTO state (id,name,country_id) VALUES 
  ('CA','California','USA');
INSERT INTO state (id,name,country_id) VALUES 
  ('CO','Colorado','USA');
INSERT INTO state (id,name,country_id) VALUES 
  ('DE','Delaware','USA');
INSERT INTO state (id,name,country_id) VALUES 
  ('FL','Florida','USA');
INSERT INTO state (id,name,country_id) VALUES 
  ('GA','Georgia','USA');
INSERT INTO state (id,name,country_id) VALUES 
  ('HI','Hawaii','USA');
INSERT INTO state (id,name,country_id) VALUES 
  ('IA','Iowa','USA');
INSERT INTO state (id,name,country_id) VALUES 
  ('ID','Idaho','USA');
INSERT INTO state (id,name,country_id) VALUES 
  ('IL','Illinois','USA');
INSERT INTO state (id,name,country_id) VALUES 
  ('KS','Kansas','USA');
INSERT INTO state (id,name,country_id) VALUES 
  ('KY','Kentucky','USA');
INSERT INTO state (id,name,country_id) VALUES 
  ('LA','Louisiana','USA');
INSERT INTO state (id,name,country_id) VALUES 
  ('MD','Maryland','USA');
INSERT INTO state (id,name,country_id) VALUES 
  ('ME','Maine','USA');
INSERT INTO state (id,name,country_id) VALUES 
  ('MI','Michigan','USA');
INSERT INTO state (id,name,country_id) VALUES 
  ('MN','Minnesota','USA');
INSERT INTO state (id,name,country_id) VALUES 
  ('MO','Missouri','USA');
INSERT INTO state (id,name,country_id) VALUES 
  ('MS','Mississippi','USA');
INSERT INTO state (id,name,country_id) VALUES 
  ('MT','Montana','USA');
INSERT INTO state (id,name,country_id) VALUES 
  ('NC','North Carolina','USA');
INSERT INTO state (id,name,country_id) VALUES 
  ('ND','North Dakota','USA');
INSERT INTO state (id,name,country_id) VALUES 
  ('NE','Nebraska','USA');
INSERT INTO state (id,name,country_id) VALUES 
  ('NH','New Hampshire','USA');
INSERT INTO state (id,name,country_id) VALUES 
  ('NJ','New Jersey','USA');
INSERT INTO state (id,name,country_id) VALUES 
  ('NM','New Mexico','USA');
INSERT INTO state (id,name,country_id) VALUES 
  ('NV','Nevada','USA');
INSERT INTO state (id,name,country_id) VALUES 
  ('NY','New York','USA');
INSERT INTO state (id,name,country_id) VALUES 
  ('OH','Ohio','USA');
INSERT INTO state (id,name,country_id) VALUES 
  ('OK','Oklahoma','USA');
INSERT INTO state (id,name,country_id) VALUES 
  ('OR','Oregon','USA');
INSERT INTO state (id,name,country_id) VALUES 
  ('PA','Pennsylvania','USA');
INSERT INTO state (id,name,country_id) VALUES 
  ('RI','Rhode Island','USA');
INSERT INTO state (id,name,country_id) VALUES 
  ('SC','South Carolina','USA');
INSERT INTO state (id,name,country_id) VALUES 
  ('SD','South Dakota','USA');
INSERT INTO state (id,name,country_id) VALUES 
  ('TN','Tennessee','USA');
INSERT INTO state (id,name,country_id) VALUES 
  ('TX','Texas','USA');
INSERT INTO state (id,name,country_id) VALUES 
  ('UT','Utah','USA');
INSERT INTO state (id,name,country_id) VALUES 
  ('VA','Virginia','USA');
INSERT INTO state (id,name,country_id) VALUES 
  ('VT','Vermont','USA');
INSERT INTO state (id,name,country_id) VALUES 
  ('WA','Washington','USA');
INSERT INTO state (id,name,country_id) VALUES 
  ('WI','Wisconsin','USA');
INSERT INTO state (id,name,country_id) VALUES 
  ('WV','West Virginia','USA');
INSERT INTO state (id,name,country_id) VALUES 
  ('WY','Wyoming','USA');
INSERT INTO governor (id,party,firstName,middleInitial,lastName,suffix,dateAssumedOffice,state_id) VALUES 
  ('BDSchweitzer','D','Brian','D','Schweitzer','','03-Jan-2005','MT');
INSERT INTO governor (id,party,firstName,middleInitial,lastName,suffix,dateAssumedOffice,state_id) VALUES 
  ('CBHenry','D','Charles','B','Henry','','13-Jan-2003','OK');
INSERT INTO governor (id,party,firstName,middleInitial,lastName,suffix,dateAssumedOffice,state_id) VALUES 
  ('COGGregoire','D','Christine','OG','Gregoire','','12-Jan-2005','WA');
INSERT INTO governor (id,party,firstName,middleInitial,lastName,suffix,dateAssumedOffice,state_id) VALUES 
  ('DAPaterson','D','David','A','Paterson','','17-Mar-2008','NY');
INSERT INTO governor (id,party,firstName,middleInitial,lastName,suffix,dateAssumedOffice,state_id) VALUES 
  ('DDFreudenthal','D','David','D','Freudenthal','','06-Jan-2003','WY');
INSERT INTO governor (id,party,firstName,middleInitial,lastName,suffix,dateAssumedOffice,state_id) VALUES 
  ('DEHeineman','R','Dave','E','Heineman','','20-Jan-2005','NE');
INSERT INTO governor (id,party,firstName,middleInitial,lastName,suffix,dateAssumedOffice,state_id) VALUES 
  ('DLCarcieri','R','Donald','L','Carcieri','','07-Jan-2003','RI');
INSERT INTO governor (id,party,firstName,middleInitial,lastName,suffix,dateAssumedOffice,state_id) VALUES 
  ('EGRendell','D','Edward','G','Rendell','','21-Jan-2003','PA');
INSERT INTO governor (id,party,firstName,middleInitial,lastName,suffix,dateAssumedOffice,state_id) VALUES 
  ('HRBarbour','R','Haley','R','Barbour','','13-Jan-2004','MS');
INSERT INTO governor (id,party,firstName,middleInitial,lastName,suffix,dateAssumedOffice,state_id) VALUES 
  ('JAGibbons','R','Jim','A','Gibbons','','01-Jan-2007','NV');
INSERT INTO governor (id,party,firstName,middleInitial,lastName,suffix,dateAssumedOffice,state_id) VALUES 
  ('JEBaldacci','D','John','E','Baldacci','','08-Jan-2003','ME');
INSERT INTO governor (id,party,firstName,middleInitial,lastName,suffix,dateAssumedOffice,state_id) VALUES 
  ('JEDoyle','D','James','E','Doyle','','06-Jan-2003','WI');
INSERT INTO governor (id,party,firstName,middleInitial,lastName,suffix,dateAssumedOffice,state_id) VALUES 
  ('JHDouglas','R','James','H','Douglas','','09-Jan-2003','VT');
INSERT INTO governor (id,party,firstName,middleInitial,lastName,suffix,dateAssumedOffice,state_id) VALUES 
  ('JHHoevenIII','R','John','H','Hoeven','III','15-Dec-2000','ND');
INSERT INTO governor (id,party,firstName,middleInitial,lastName,suffix,dateAssumedOffice,state_id) VALUES 
  ('JHLynch','D','John','H','Lynch','','06-Jan-2005','NH');
INSERT INTO governor (id,party,firstName,middleInitial,lastName,suffix,dateAssumedOffice,state_id) VALUES 
  ('JManchinIII','D','Joseph','','Manchin','III','17-Jan-2005','WV');
INSERT INTO governor (id,party,firstName,middleInitial,lastName,suffix,dateAssumedOffice,state_id) VALUES 
  ('JMGranholm','D','Jennifer','M','Granholm','','01-Jan-2003','MI');
INSERT INTO governor (id,party,firstName,middleInitial,lastName,suffix,dateAssumedOffice,state_id) VALUES 
  ('JMHuntsmanJr','R','Jon','M','Huntsman','Jr.','03-Jan-2005','UT');
INSERT INTO governor (id,party,firstName,middleInitial,lastName,suffix,dateAssumedOffice,state_id) VALUES 
  ('JRPerry','R','James','R','Perry','','21-Dec-2000','TX');
INSERT INTO governor (id,party,firstName,middleInitial,lastName,suffix,dateAssumedOffice,state_id) VALUES 
  ('JSCorzine','D','Jon','S','Corzine','','17-Jan-2006','NJ');
INSERT INTO governor (id,party,firstName,middleInitial,lastName,suffix,dateAssumedOffice,state_id) VALUES 
  ('MCSanfordJr','R','Marshall','C','Sanford','Jr.','15-Jan-2003','SC');
INSERT INTO governor (id,party,firstName,middleInitial,lastName,suffix,dateAssumedOffice,state_id) VALUES 
  ('MFEasley','D','Michael','F','Easley','','06-Jan-2001','NC');
INSERT INTO governor (id,party,firstName,middleInitial,lastName,suffix,dateAssumedOffice,state_id) VALUES 
  ('MJOMalley','D','Martin','J','O'Malley','','17-Jan-2007','MD');
INSERT INTO governor (id,party,firstName,middleInitial,lastName,suffix,dateAssumedOffice,state_id) VALUES 
  ('MMRounds','R','Marion','M','Rounds','','07-Jan-2003','SD');
INSERT INTO governor (id,party,firstName,middleInitial,lastName,suffix,dateAssumedOffice,state_id) VALUES 
  ('MRBlunt','R','Matt','R','Blunt','','10-Jan-2005','MO');
INSERT INTO governor (id,party,firstName,middleInitial,lastName,suffix,dateAssumedOffice,state_id) VALUES 
  ('PNBredesen','D','Philip','N','Bredesen','','18-Jan-2003','TN');
INSERT INTO governor (id,party,firstName,middleInitial,lastName,suffix,dateAssumedOffice,state_id) VALUES 
  ('TJPawlenty','R','Timothy','J','Pawlenty','','06-Jan-2003','MN');
INSERT INTO governor (id,party,firstName,middleInitial,lastName,suffix,dateAssumedOffice,state_id) VALUES 
  ('TMKaine','D','Timothy','M','Kaine','','14-Jan-2006','VA');
INSERT INTO governor (id,party,firstName,middleInitial,lastName,suffix,dateAssumedOffice,state_id) VALUES 
  ('TRKulongoski','D','Theodore','R','Kulongoski','','13-Jan-2003','OR');
INSERT INTO governor (id,party,firstName,middleInitial,lastName,suffix,dateAssumedOffice,state_id) VALUES 
  ('TStrickland','D','Ted','','Strickland','','08-Jan-2007','OH');
INSERT INTO governor (id,party,firstName,middleInitial,lastName,suffix,dateAssumedOffice,state_id) VALUES 
  ('WBRichardsonIII','D','William','B','Richardson','III','01-Jan-2003','NM');
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('AKlobuchar','D','Amy','','Klobuchar','','MN','25-May-1960','03-Jan-2007',1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('BAMikulski','D','Barbara','A','Mikulski','','MD','20-Jul-1936','06-Jan-1987',1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('BBoxer','D','Barbara','','Boxer','','CA','11-Nov-1940',NULL,1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('BCorker','R','Bob','','Corker','','TN','24-Aug-1952','03-Jan-2007',1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('BENelson','D','Benjamin','E','Nelson','','NE','17-May-1941','03-Jan-2001',1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('BLCardin','D','Benjamin','L','Cardin','','MD','05-Oct-1943',NULL,1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('BLDorgan','D','Byron','L','Dorgan','','ND','14-May-1942','15-Dec-1992',1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('BLLincoln','D','Blanche','L','Lincoln','','AR','30-Sep-1960','06-Jan-1999',1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('BNelson','D','Bill','','Nelson','','FL','29-Sep-1942','03-Jan-2001',1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('BSanders','I','Bernie','','Sanders','','VT',NULL,'03-Jan-2007',1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('CESchumer','D','Charles','E','Schumer','','NY',NULL,'03-Jan-1999',1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('CGrassley','R','Chuck','','Grassley','','IA','17-Sep-1933','05-Jan-1981',1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('CHagel','R','Chuck','','Hagel','','NE','04-Oct-1946','07-Jan-1997',1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('CLevin','D','Carl','','Levin','','MI','28-Jun-1934','15-Jan-1979',1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('CMcCaskill','D','Claire','','McCaskill','','MO','24-Jul-1953','03-Jan-2007',1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('CSBond','R','Christopher','S','Bond','','MO','06-Mar-1939',NULL,1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('DAkaka','D','Daniel','','Akaka','','HI','11-Sep-1924',NULL,1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('DFeinstein','D','Dianne','','Feinstein','','CA','22-Jun-1933','10-Nov-1992',1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('DKInouye','D','Daniel','K','Inouye','','HI','07-Sep-1924','03-Jan-1963',1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('DStabenow','D','Debbie','','Stabenow','','MI',NULL,'03-Jan-2001',1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('DVitter','R','David','','Vitter','','LA',NULL,'03-Jan-2005',1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('FRLautenberg','D','Frank','R','Lautenberg','','NJ','23-Jan-1924','07-Jan-2003',1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('GHSmith','R','Gordon','H','Smith','','OR',NULL,'07-Jan-1997',1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('GVVoinovich','R','George','V','Voinovich','','OH',NULL,'06-Jan-1999',1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('HKohl','D','Herb','','Kohl','','WI','07-Feb-1935','03-Jan-1989',1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('HReid','D','Harry','','Reid','','NV',NULL,'03-Jan-1987',1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('JBarrasso','R','John','','Barrasso','','WY','21-Jul-1952',NULL,1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('JBingaman','D','Jeff','','Bingaman','','NM','03-Oct-1943',NULL,1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('JBunning','R','Jim','','Bunning','','KY','23-Oct-1931',NULL,1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('JCornyn','R','John','','Cornyn','','TX','02-Feb-1952','02-Dec-2002',1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('JDeMint','R','Jim','','DeMint','','SC','02-Sep-1951','03-Jan-2005',1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('JDRockefellerIV','D','John','D','Rockefeller','IV','WV',NULL,'15-Jan-1985',1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('JEnsign','R','John','','Ensign','','NV','25-Mar-1958','03-Jan-2001',1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('JESununu','R','John','E','Sununu','','NH',NULL,'07-Jan-2003',1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('JGregg','R','Judd','','Gregg','','NH','14-Feb-1947','05-Jan-1993',1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('JIsakson','R','Johnny','','Isakson','','GA','28-Dec-1944','03-Jan-2005',1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('JKyl','R','Jon','','Kyl','','AZ','25-Apr-1942','04-Jan-1995',1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('JMInhofe','R','James','M','Inhofe','','OK','17-Nov-1934','17-Nov-1994',1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('JReed','D','Jack','','Reed','','RI',NULL,'07-Jan-1997',1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('JSessions','R','Jeff','','Sessions','','AL',NULL,'07-Jan-1997',1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('JTester','D','Jon','','Tester','','MT',NULL,'03-Jan-2007',1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('JThune','R','John','','Thune','','SD',NULL,'03-Jan-2005',1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('JWarner','R','John','','Warner','','VA',NULL,'02-Jan-1979',1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('JWebb','D','Jim','','Webb','','VA',NULL,'03-Jan-2007',1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('KBHutchison','R','Kay','B','Hutchison','','TX','22-Jul-1943','14-Jun-1993',1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('KConrad','D','Kent','','Conrad','','ND','12-Mar-1948','06-Jan-1987',1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('KSalazar','D','Ken','','Salazar','','CO',NULL,'03-Jan-2005',1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('LECraig','R','Larry','E','Craig','','ID','20-Jul-1945','03-Jan-1991',1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('LGraham','R','Lindsey','','Graham','','SC','09-Jul-1955','07-Jan-2003',1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('LMurkowski','R','Lisa','','Murkowski','','AK','22-May-1957','20-Dec-2002',1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('MBaucus','D','Max','','Baucus','','MT','11-Dec-1941',NULL,1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('MBEnzi','R','Michael','B','Enzi','','WY','01-Feb-1944','07-Jan-1997',1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('MCantwell','D','Maria','','Cantwell','','WA','13-Oct-1958',NULL,1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('MCrapo','R','Mike','','Crapo','','ID','20-May-1951','06-Jan-1999',1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('MLLandrieu','D','Mary','L','Landrieu','','LA','23-Nov-1955','07-Jan-1997',1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('MLPryor','D','Mark','L','Pryor','','AR',NULL,'07-Jan-2003',1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('MMartinez','R','Mel','','Martinez','','FL','23-Oct-1946','03-Jan-2005',1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('MMcConnell','R','Mitch','','McConnell','','KY','20-Feb-1942','03-Jan-1985',1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('NColeman','R','Norm','','Coleman','','MN','17-Aug-1949','07-Jan-2003',1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('OJSnowe','R','Olympia','J','Snowe','','ME',NULL,'04-Jan-1995',1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('PJLeahy','D','Patrick','J','Leahy','','VT','31-Mar-1940','14-Jan-1975',1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('PMurray','D','Patty','','Murray','','WA','11-Oct-1950','05-Jan-1993',1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('PRoberts','R','Pat','','Roberts','','KS',NULL,'07-Jan-1997',1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('PVDomenici','R','Pete','V','Domenici','','NM','07-May-1932','03-Jan-1973',1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('RBurr','R','Richard','','Burr','','NC','30-Nov-1955',NULL,1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('RCShelby','R','Richard','C','Shelby','','AL',NULL,'06-Jan-1987',1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('RDFeingold','D','Russell','D','Feingold','','WI','02-Mar-1953','05-Jan-1993',1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('RDurbin','D','Richard','','Durbin','','IL','21-Nov-1944','07-Jan-1997',1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('RFBennett','R','Robert','F','Bennett','','UT','18-Sep-1933',NULL,1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('RFWicker','R','Roger','F','Wicker','','MS',NULL,'31-Dec-2007',1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('RMenendez','D','Robert','','Menendez','','NJ','01-Jan-1954','18-Jan-2006',1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('RPCaseyJr','D','Robert','P','Casey','Jr.','PA','13-Apr-1960',NULL,1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('RWyden','D','Ron','','Wyden','','OR',NULL,'06-Feb-1996',1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('SBrown','D','Sherrod','','Brown','','OH','09-Nov-1952',NULL,1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('SChambliss','R','Saxby','','Chambliss','','GA','10-Nov-1943',NULL,1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('SMCollins','R','Susan','M','Collins','','ME','07-Dec-1952','07-Jan-1997',1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('SWhitehouse','D','Sheldon','','Whitehouse','','RI',NULL,'03-Jan-2007',1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('TCoburn','R','Tom','','Coburn','','OK','14-Mar-1948',NULL,1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('TCochran','R','Thad','','Cochran','','MS','07-Dec-1937',NULL,1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('TJohnson','D','Tim','','Johnson','','SD','28-Dec-1946','07-Jan-1997',1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('TRCarper','D','Thomas','R','Carper','','DE','23-Jan-1947',NULL,1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('TStevens','R','Ted','','Stevens','','AK',NULL,'24-Dec-1968',1);
INSERT INTO senator (id,party,firstName,middleInitial,lastName,suffix,state,birthdate,dateAssumedOffice,senate_id) VALUES 
  ('WAllard','R','Wayne','','Allard','','CO','02-Dec-1943',NULL,1);