drop table if exists senate_members;
create table senate_members (
  bioguideID varchar(7),
  first varchar(20),
  middle varchar(20),
  nick varchar(20),
  last varchar(30),
  suffix varchar(10),
  state varchar(30),
  stateRank varchar(4),
  class varchar(5),
  homeTown varchar(30),
  party varchar(1),
  dsafe float,
  rsafe float,
  pvi float,
  pp20 float,
  nom1 float,
  nom2 float,
  approval float,
  neutapp float,
  disapp float,
  oldnom1 float,
  oldnom2 float,
  ReEl varchar(10),
  imp2 varchar(10),
  phone varchar(20),
  web_contact_form varchar(100),
  website varchar(100),
  office varchar(15),
  committee varchar(100),
  subcommittee varchar(200),
  leadership_position varchar(100)
);
insert into senate_members (bioguideID, first, middle, nick, last, suffix, state, stateRank, class, homeTown, party, dsafe, rsafe, pvi, pp20, nom1, nom2, approval, neutapp, disapp, oldnom1, oldnom2, ReEl, imp2, phone, web_contact_form, website, office, committee, subcommittee, leadership_position) values
('M001153','Lisa','',null,'Murkowski','','AK','1','III','Girdwood','R',null,17,9.00,5.26,0.212,-0.29,null,null,null,0.192,-0.320,'','Yes','(202) 224-6665','https://www.murkowski.senate.gov/public/index.cfm/contact','https://www.murkowski.senate.gov/','522 Hart','SLIA00(VC); SSAP00; SSEG00; SSHR00','SSAP16; SSAP02; SSAP22; SSAP14; SSAP17(rm); SSAP19; SSEG01; SSEG04; SSEG03; SSHR09; SSHR12',null),
('S001198','Dan','',null,'Sullivan','','AK','2','II','Anchorage','R',null,18,9.00,5.26,0.47,0.062,null,null,null,null,null,'','No','(202) 224-3004','https://www.sullivan.senate.gov/contact/email','https://www.sullivan.senate.gov','302 Hart','SSAS00; SSCM00; SSEV00; SSVA00','SSAS14; SSAS15(rm); SSAS16; SSCM34; SSCM36(rm); SSCM38; SSCM39; SSEV09; SSEV15; SSEV08',null),
('S000320','Richard','C.',null,'Shelby','','AL','1','III','Tuscaloosa','R',null,34,14.43,12.91,0.43,0.523,null,null,null,0.428,0.431,'','No','(202) 224-5744','https://www.shelby.senate.gov/public/index.cfm/emailsenatorshelby','https://www.shelby.senate.gov/','304 Russell','JSLC00; SSAP00(rm); SSBK00; SSEV00; SSRA00','SSAP01; SSAP16; SSAP02(rm); SSAP22; SSAP23; SSAP14; SSAP17; SSAP18; SSAP08; SSAP19; SSAP20; SSAP24; SSBK08; SSBK09; SSBK04; SSEV09; SSEV10; SSEV08',null),
('T000278','Tommy','',null,'Tuberville','','AL','2','II','Auburn','R',null,35,14.43,12.91,0.767,0.212,null,null,null,null,null,'','No','(202) 224-4124','https://www.tuberville.senate.gov/contact/contact-form/','https://www.tuberville.senate.gov','142 Russell','SSAF00; SSAS00; SSHR00; SSVA00','SSAF13; SSAF14; SSAF15; SSAS20; SSAS17; SSAS16; SSHR09; SSHR11',null),
('B001236','John','',null,'Boozman','','AR','1','III','Rogers','R',null,36,15.00,14.21,0.4,0.248,null,null,null,null,null,'','No','(202) 224-4843','https://www.boozman.senate.gov/public/index.cfm/contact','https://www.boozman.senate.gov/','141 Hart','JCSE00; SSAF00(rm); SSAP00; SSEV00; SSVA00','SSAF13; SSAF14; SSAF16; SSAF17; SSAF15; SSAP16; SSAP02; SSAP23; SSAP19(rm); SSAP20; SSAP24; SSEV10; SSEV15; SSEV08',null),
('C001095','Tom','',null,'Cotton','','AR','2','II','Little Rock','R',null,37,15.00,14.21,0.575,0.062,null,null,null,null,null,'','No','(202) 224-2353','https://www.cotton.senate.gov/contact/contact-tom','https://www.cotton.senate.gov','326 Russell','JSEC00; SLIN00; SSAS00; SSJU00','SSAS14(rm); SSAS13; SSAS16; SSJU01; SSJU22(rm); SSJU04; SSJU26',null),
('S001191','Kyrsten','',null,'Sinema','','AZ','1','I','Phoenix','D',7,null,2.33,-0.16,-0.101,0.063,null,null,null,null,null,'','Yes','(202) 224-4521','https://www.sinema.senate.gov/contact-kyrsten','https://www.sinema.senate.gov','317 Hart','SSBK00; SSCM00; SSGA00; SSVA00','SSBK08; SSBK05; SSBK04; SSCM33(Ch); SSCM34; SSCM37; SSCM39; SSGA20; SSGA22(Ch)',null),
('K000377','Mark','',null,'Kelly','','AZ','2','III','Tucson','D',6,null,2.33,-0.16,-0.16,0.558,null,null,null,null,null,'','Yes','(202) 224-2235','https://www.kelly.senate.gov','https://www.kelly.senate.gov','516 Hart','JSEC00; SPAG00; SSAS00; SSEG00; SSEV00','SSAS14; SSAS20(Ch); SSAS16; SSEG04; SSEG03; SSEG07; SSEV09; SSEV15; SSEV08',null),
('F000062','Dianne','',null,'Feinstein','','CA','1','I','San Francisco','D',43,null,-12.91,-14.91,-0.267,-0.183,null,null,null,-0.279,-0.116,'','Yes','(202) 224-3841','https://www.feinstein.senate.gov/public/index.cfm/e-mail-me','https://www.feinstein.senate.gov','331 Hart','SLIN00; SSAP00; SSJU00; SSRA00','SSAP01; SSAP16; SSAP02; SSAP22(Ch); SSAP17; SSAP24; SSJU22; SSJU27(Ch); SSJU04; SSJU21',null),
('P000145','Alex','',null,'Padilla','','CA','2','III','Porter Ranch','D',42,null,-12.91,-14.91,-0.428,0.14,null,null,null,null,null,'short appt','Yes','(202) 224-3553','https://www.padilla.senate.gov/contact/','https://www.padilla.senate.gov','112 Hart','JSPR00; SSBU00; SSEV00; SSGA00; SSJU00; SSRA00','SSEV09; SSEV10; SSEV08; SSGA01; SSGA22; SSJU22; SSJU25; SSJU04(Ch); SSJU26',null),
('B001267','Michael','F.',null,'Bennet','','CO','1','III','Denver','D',13,null,-0.71,-6.94,-0.227,-0.182,null,null,null,null,null,'','Yes','(202) 224-5852','https://www.bennet.senate.gov/public/index.cfm/contact','https://www.bennet.senate.gov','261 Russell','SLIN00; SSAF00; SSFI00','SSAF14(Ch); SSAF16; SSAF15; SSFI12(Ch); SSFI13; SSFI02',null),
('H000273','John','W.',null,'Hickenlooper','','CO','2','II','Denver','D',12,null,-0.71,-6.94,-0.206,0.254,null,null,null,null,null,'','Yes','(202) 224-5941','https://www.hickenlooper.senate.gov/contact/','https://www.hickenlooper.senate.gov','374 Russell','SSCM00; SSEG00; SSHR00; SSSB00','SSCM33; SSCM34; SSCM37(Ch); SSCM39; SSEG01; SSEG03; SSEG07; SSHR09; SSHR11(Ch)',null),
('B001277','Richard','',null,'Blumenthal','','CT','1','III','Greenwich','D',31,null,-6.60,-10.20,-0.439,-0.163,null,null,null,null,null,'','Yes','(202) 224-2823','https://www.blumenthal.senate.gov/contact/','https://www.blumenthal.senate.gov','706 Hart','JCSE00; SCNC00; SPAG00; SSAS00; SSCM00; SSJU00; SSVA00','SSAS21; SSAS15; SSAS13; SSCM34; SSCM35(Ch); SSCM36; SSCM37; SSCM38; SSJU01; SSJU27; SSJU04; SSJU21(Ch)',null),
('M001169','Christopher','',null,'Murphy','','CT','2','I','Hartford','D',30,null,-6.60,-10.20,-0.269,-0.195,null,null,null,null,null,'','Yes','(202) 224-4041','https://www.murphy.senate.gov/contact','https://www.murphy.senate.gov/','136 Hart','SSAP00; SSFR00; SSHR00','SSAP14(Ch); SSAP18; SSAP08; SSAP20; SSAP24; SSFR02; SSFR01; SSFR07(Ch); SSFR14; SSHR09; SSHR12',null),
('C000174','Thomas','R.',null,'Carper','','DE','1','I','Wilmington','D',29,null,-6.00,-9.63,-0.176,-0.222,null,null,null,-0.182,-0.176,'','Yes','(202) 224-2441','https://www.carper.senate.gov/contact/','https://www.carper.senate.gov','513 Hart','SSEV00(Ch); SSFI00; SSGA00','SSEV09; SSEV10; SSEV15; SSEV08; SSFI12; SSFI10; SSFI13(Ch); SSGA01; SSGA22',null),
('C001088','Christopher','A.',null,'Coons','','DE','2','II','Wilmington','D',28,null,-6.00,-9.63,-0.229,-0.216,null,null,null,null,null,'','Yes','(202) 224-5042','https://www.coons.senate.gov/contact','https://www.coons.senate.gov/','218 Russell','SLET00(Ch); SSAP00; SSFR00; SSJU00; SSSB00','SSAP16; SSAP22; SSAP23; SSAP19; SSAP20(Ch); SSAP24; SSFR09; SSFR02; SSFR01; SSFR15(Ch); SSJU27; SSJU04; SSJU26; SSJU28(Ch)',null),
('R000595','Marco','',null,'Rubio','','FL','1','III','Miami','R',null,3,0.59,1.69,0.568,-0.269,null,null,null,null,null,'','No','(202) 224-3041','https://www.rubio.senate.gov/public/index.cfm/contact','https://www.rubio.senate.gov','284 Russell','SLIN00(VC); SPAG00; SSAP00; SSFR00; SSSB00','SSAP17; SSAP18; SSAP08; SSAP19; SSAP20; SSFR09; SSFR14; SSFR06(rm)',null),
('S001217','Rick','',null,'Scott','','FL','2','I','Naples','R',null,4,0.59,1.69,0.587,-0.009,null,null,null,null,null,'','No','(202) 224-5274','https://www.rickscott.senate.gov/contact/contact','https://www.rickscott.senate.gov/','502 Hart','SPAG00; SSAS00; SSBU00; SSCM00; SSGA00','SSAS14; SSAS20; SSAS13; SSCM34; SSCM37; SSCM38; SSCM39(rm); SSGA01; SSGA20',null),
('O000174','Jon','',null,'Ossoff','','GA','1','II','Atlanta','D',4,null,5.29,-0.12,-0.428,0.14,null,null,null,null,null,'','Yes','(202) 224-3521','https://www.ossoff.senate.gov/contact-us/','https://www.ossoff.senate.gov','455 Russell','SSBK00; SSGA00; SSJU00; SSRA00','SSBK12; SSBK09; SSBK05; SSGA01(Ch); SSGA20; SSGA22; SSJU01; SSJU22; SSJU25; SSJU28; SSJU21',null),
('W000790','Raphael','G.',null,'Warnock','','GA','2','III','Atlanta','D',3,null,5.29,-0.12,-0.428,0.14,null,null,null,null,null,'','Yes','(202) 224-3643','https://www.warnock.senate.gov/contact/','https://www.warnock.senate.gov','388 Russell','JSEC00; SPAG00; SSAF00; SSBK00; SSCM00','SSAF13(Ch); SSAF16; SSAF17; SSBK08(Ch); SSBK09; SSBK04; SSCM33; SSCM34; SSCM37; SSCM38',null),
('S001194','Brian','',null,'Schatz','','HI','1','III','Honolulu','D',48,null,-18.00,-15.03,-0.443,-0.112,null,null,null,null,null,'','Yes','(202) 224-3934','https://www.schatz.senate.gov/contact','https://www.schatz.senate.gov','722 Hart','SLET00; SLIA00(Ch); SSAP00; SSCM00; SSFR00','SSAP01; SSAP16; SSAP02; SSAP18; SSAP19; SSAP24(Ch); SSCM34; SSCM35; SSCM36; SSCM38; SSFR02; SSFR15; SSFR14',null),
('H001042','Mazie','K.',null,'Hirono','','HI','2','I','Honolulu','D',47,null,-18.00,-15.03,-0.512,-0.084,null,null,null,null,null,'','Yes','(202) 224-6361','https://www.hirono.senate.gov/contact','https://www.hirono.senate.gov/','109 Hart','SSAS00; SSEG00; SSJU00; SSSB00; SSVA00','SSAS17; SSAS15; SSAS13(Ch); SSEG01(Ch); SSEG04; SSEG03; SSJU25; SSJU04; SSJU26; SSJU28',null),
('G000386','Chuck','',null,'Grassley','','IA','1','III','New Hartford','R',null,6,2.50,4.18,0.346,-0.064,null,null,null,0.343,-0.086,'','No','(202) 224-3744','https://www.grassley.senate.gov/contact','https://www.grassley.senate.gov','135 Hart','JSTX00; SCNC00(VC); SSAF00; SSBU00; SSFI00; SSJU00(rm)','SSAF13; SSAF17; SSAF15; SSFI10; SSFI13; SSFI11',null),
('E000295','Joni','',null,'Ernst','','IA','2','II','Red Oak','R',null,7,2.50,4.18,0.531,-0.051,null,null,null,null,null,'','No','(202) 224-3254','https://www.ernst.senate.gov/public/index.cfm/contact','https://www.ernst.senate.gov','730 Hart','SSAF00; SSAS00; SSEV00; SSSB00','SSAF16; SSAF17; SSAF15(rm); SSAS21; SSAS20(rm); SSAS15; SSEV09; SSEV10; SSEV15',null),
('C000880','Mike','',null,'Crapo','','ID','1','III','Idaho Falls','R',null,42,19.00,15.88,0.51,0.293,null,null,null,0.501,0.174,'','No','(202) 224-6142','https://www.crapo.senate.gov/contact','https://www.crapo.senate.gov','239 Dirksen','JSTX00; SSBK00; SSBU00; SSFI00(rm)','SSBK09; SSBK05; SSBK04; SSFI12; SSFI14; SSFI10; SSFI13; SSFI02; SSFI11',null),
('R000584','James','E.',null,'Risch','','ID','2','II','Boise','R',null,43,19.00,15.88,0.623,0.551,null,null,null,null,null,'','No','(202) 224-2752','https://www.risch.senate.gov/public/index.cfm?p=Email','https://www.risch.senate.gov','483 Russell','SCNC00; SLET00; SLIN00; SSEG00; SSFR00(rm); SSSB00','SSEG01; SSEG03; SSEG07; SSFR09; SSFR02; SSFR01; SSFR15; SSFR07; SSFR14; SSFR06',null),
('D000563','Richard','J.',null,'Durbin','','IL','1','II','Springfield','D',33,null,-7.89,-8.66,-0.348,-0.307,null,null,null,-0.375,-0.350,'','Yes','(202) 224-2152','https://www.durbin.senate.gov/contact/','https://www.durbin.senate.gov','711 Hart','SSAF00; SSAP00; SSJU00(Ch)','SSAF13; SSAF17; SSAF15; SSAP02; SSAP22; SSAP23; SSAP18; SSAP20; SSAP24','Majority Whip'),
('D000622','Tammy','',null,'Duckworth','','IL','2','III','Hoffman Estates','D',32,null,-7.89,-8.66,-0.336,0.109,null,null,null,null,null,'','Yes','(202) 224-2854','https://www.duckworth.senate.gov/content/contact-senator','https://www.duckworth.senate.gov','524 Hart','SSAS00; SSCM00; SSEV00; SSSB00','SSAS14(Ch); SSAS15; SSAS16; SSCM33; SSCM34; SSCM38; SSCM39; SSEV10; SSEV15(Ch); SSEV08',null),
('Y000064','Todd','',null,'Young','','IN','1','III','Greenwood','R',null,21,9.11,8.20,0.473,-0.027,null,null,null,null,null,'','No','(202) 224-5623','https://www.young.senate.gov/contact','https://www.young.senate.gov','185 Dirksen','SSCM00; SSFI00; SSFR00; SSSB00','SSCM34; SSCM35; SSCM36; SSCM37; SSCM38; SSFI10; SSFI13; SSFI02(rm); SSFR09; SSFR01; SSFR15; SSFR07(rm)',null),
('B001310','Mike','',null,'Braun','','IN','2','I','Jasper','R',null,22,9.11,8.20,0.8,0.6,null,null,null,null,null,'nrr','No','(202) 224-4814','https://www.braun.senate.gov/contact-mike','https://www.braun.senate.gov','404 Russell','SPAG00; SSAF00; SSAP00; SSBU00; SSHR00','SSAF14; SSAF16(rm); SSAF15; SSAP01; SSAP16; SSAP18; SSAP08(rm); SSAP24; SSHR11(rm); SSHR12',null),
('M000934','Jerry','',null,'Moran','','KS','1','III','Manhattan','R',null,28,13.25,7.49,0.415,0.206,null,null,null,null,null,'','No','(202) 224-6521','https://www.moran.senate.gov/public/index.cfm/e-mail-jerry','https://www.moran.senate.gov','521 Dirksen','SLIA00; SSAP00; SSBK00; SSCM00; SSHR00; SSVA00(rm)','SSAP01; SSAP16(rm); SSAP02; SSAP23; SSAP18; SSAP20; SSBK08; SSBK09; SSBK04; SSCM33; SSCM34; SSCM35; SSCM37; SSHR09; SSHR12',null),
('M001198','Roger','',null,'Marshall','','KS','2','II','Great Bend','R',null,29,13.25,7.49,0.542,0.134,null,null,null,null,null,'','No','(202) 224-4774','https://www.marshall.senate.gov/contact/','https://www.marshall.senate.gov','479A Russell','SSAF00; SSEG00; SSHR00; SSSB00','SSAF14(rm); SSAF16; SSAF17; SSEG01; SSEG07; SSHR09; SSHR12',null),
('M000355','Mitch','',null,'McConnell','','KY','1','II','Louisville','R',null,38,15.67,13.20,0.401,0.008,null,null,null,0.419,-0.022,'','No','(202) 224-2541','https://www.mcconnell.senate.gov/public/index.cfm?p=contact','https://www.mcconnell.senate.gov/','317 Russell','SLIN00; SSAF00; SSAP00; SSRA00','SSAF13; SSAF16; SSAF15; SSAP01; SSAP02; SSAP22; SSAP17; SSAP19; SSAP20','Republican Leader'),
('P000603','Rand','',null,'Paul','','KY','2','III','Bowling Green','R',null,39,15.67,13.20,0.876,-0.482,null,null,null,null,null,'','No','(202) 224-4343','https://www.paul.senate.gov/connect/email-rand','https://www.paul.senate.gov','167 Russell','SSFR00; SSGA00; SSHR00; SSSB00(rm)','SSFR09; SSFR15; SSFR07; SSFR14; SSGA01; SSGA20(rm); SSHR11; SSHR12',null),
('C001075','Bill','',null,'Cassidy','','LA','1','II','Baton Rouge','R',null,23,11.00,9.46,0.457,-0.095,null,null,null,null,null,'','Yes','(202) 224-5824','https://www.cassidy.senate.gov/contact','https://www.cassidy.senate.gov','520 Hart','JSEC00; SSEG00; SSFI00; SSHR00; SSVA00','SSEG01; SSEG03; SSFI14(rm); SSFI10; SSFI02; SSHR09(rm); SSHR12',null),
('K000393','John','',null,'Kennedy','','LA','2','III','Madisonville','R',null,24,11.00,9.46,0.594,0.206,null,null,null,null,null,'','No','(202) 224-4623','https://www.kennedy.senate.gov/public/email-me','https://www.kennedy.senate.gov','416 Russell','SSAP00; SSBK00; SSBU00; SSJU00; SSSB00','SSAP16; SSAP22(rm); SSAP23; SSAP14; SSAP18; SSAP24; SSBK12(rm); SSBK05; SSBK04; SSJU22; SSJU25(rm); SSJU27; SSJU04; SSJU28',null),
('W000817','Elizabeth','',null,'Warren','','MA','1','I','Cambridge','D',39,null,-12.33,-17.12,-0.773,-0.308,null,null,null,null,null,'','Yes','(202) 224-4543','https://www.warren.senate.gov/?p=email_senator','https://www.warren.senate.gov','309 Hart','SPAG00; SSAS00; SSBK00; SSFI00','SSAS20; SSAS17; SSAS16; SSBK12(Ch); SSBK08(rm); SSBK04; SSFI14(Ch); SSFI10; SSFI11',null),
('M000133','Edward','J.',null,'Markey','','MA','2','II','Malden','D',38,null,-12.33,-17.12,-0.512,-0.457,null,null,null,null,null,'','Yes','(202) 224-2742','https://www.markey.senate.gov/contact','https://www.markey.senate.gov','255 Dirksen','SSCM00; SSEV00; SSFR00; SSSB00','SSCM34; SSCM35; SSCM36; SSCM37; SSCM38; SSEV09; SSEV10(Ch); SSEV15; SSFR02(Ch); SSFR07; SSFR14; SSFR06',null),
('C000141','Benjamin','L.',null,'Cardin','','MD','1','I','Baltimore','D',41,null,-12.50,-17.03,-0.319,-0.223,null,null,null,-0.337,-0.275,'','Yes','(202) 224-4524','https://www.cardin.senate.gov/contact/','https://www.cardin.senate.gov/','509 Hart','JCSE00(Ch); SSEV00; SSFI00; SSFR00; SSSB00(Ch)','SSEV10; SSEV15; SSEV08(Ch); SSFI10; SSFI13; SSFI11; SSFR01; SSFR15; SSFR14(Ch); SSFR06',null),
('V000128','Chris','',null,'Van Hollen','','MD','2','III','Kensington','D',40,null,-12.50,-17.03,-0.392,-0.21,null,null,null,null,null,'','Yes','(202) 224-4654','https://www.vanhollen.senate.gov/contact/email','https://www.vanhollen.senate.gov','110 Hart','SSAP00; SSBK00; SSBU00; SSFR00','SSAP16; SSAP23(Ch); SSAP17; SSAP20; SSAP24; SSBK12; SSBK08; SSBK09; SSFR09(Ch); SSFR01; SSFR07',null),
('C001035','Susan','M.',null,'Collins','','ME','1','II','Bangor','R',null,1,-3.00,-4.67,0.114,-0.537,null,null,null,0.088,-0.567,'','Yes','(202) 224-2523','https://www.collins.senate.gov/contact','https://www.collins.senate.gov','413 Dirksen','SLIN00; SPAG00; SSAP00; SSHR00','SSAP01; SSAP16; SSAP02; SSAP22; SSAP19; SSAP24(rm); SSHR09; SSHR12(rm)',null),
('K000383','Angus','S.',null,'King','Jr.','ME','2','I','Brunswick','I',null,null,-3.00,-4.67,-0.157,-0.226,null,null,null,null,null,'','Yes','(202) 224-5344','https://www.king.senate.gov/contact','https://www.king.senate.gov/','133 Hart','JSPR00; SLIN00; SSAS00; SSEG00; SSRA00','SSAS14; SSAS13; SSAS16(Ch); SSEG01; SSEG04(Ch); SSEG03',null),
('S000770','Debbie','',null,'Stabenow','','MI','1','I','Lansing','D',19,null,-1.36,-1.41,-0.343,-0.013,null,null,null,-0.335,0.020,'','Yes','(202) 224-4822','https://www.stabenow.senate.gov/contact','https://www.stabenow.senate.gov/','731 Hart','JSTX00; SSAF00(Ch); SSBU00; SSEV00; SSFI00','SSAF13; SSAF14; SSAF16; SSAF17; SSAF15; SSEV10; SSEV15; SSEV08; SSFI10(Ch); SSFI13; SSFI11',null),
('P000595','Gary','C.',null,'Peters','','MI','2','II','Bloomfield Hills','D',18,null,-1.36,-1.41,-0.245,-0.187,null,null,null,null,null,'','Yes','(202) 224-6221','https://www.peters.senate.gov/contact/email-gary','https://www.peters.senate.gov','724 Hart','SSAS00; SSCM00; SSGA00(Ch)','SSAS14; SSAS20; SSAS13; SSCM34; SSCM36; SSCM37; SSCM38(Ch); SSGA01; SSGA20; SSGA22',null),
('K000367','Amy','',null,'Klobuchar','','MN','1','I','Minneapolis','D',17,null,-0.75,-3.64,-0.284,-0.379,null,null,null,-0.254,-0.172,'','Yes','(202) 224-3244','https://www.klobuchar.senate.gov/public/index.cfm/contact','https://www.klobuchar.senate.gov/','425 Dirksen','JSEC00; JSLC00(VC); JSPR00(Ch); SSAF00; SSCM00; SSJU00; SSRA00(Ch)','SSAF14; SSAF16; SSAF15; SSCM34; SSCM35; SSCM38; SSCM39; SSJU01(Ch); SSJU22; SSJU04; SSJU28',null),
('S001203','Tina','',null,'Smith','','MN','2','II','Minneapolis','D',16,null,-0.75,-3.64,-0.396,-0.058,null,null,null,null,null,'','Yes','(202) 224-5641','https://www.smith.senate.gov/share-your-opinion/','https://www.smith.senate.gov','720 Hart','JCSE00; SLIA00; SSAF00; SSBK00; SSHR00','SSAF13; SSAF17; SSAF15(Ch); SSBK12; SSBK09(Ch); SSBK04; SSHR09; SSHR11',null),
('B000575','Roy','',null,'Blunt','','MO','1','III','Springfield','R',null,15,8.75,7.84,0.426,0.275,null,null,null,null,null,'','No','(202) 224-5721','https://www.blunt.senate.gov/public/index.cfm/contact-roy','https://www.blunt.senate.gov','260 Russell','JSLC00; JSPR00; SLIN00; SSAP00; SSCM00; SSRA00(rm)','SSAP01; SSAP02; SSAP17; SSAP18(rm); SSAP20; SSAP24; SSCM33; SSCM34; SSCM35; SSCM38',null),
('H001089','Josh','',null,'Hawley','','MO','2','I','Springfield','R',null,16,8.75,7.84,0.636,-0.385,null,null,null,null,null,'','No','(202) 224-6154','https://www.hawley.senate.gov/contact-senator-hawley','https://www.hawley.senate.gov','115 Russell','SSAS00; SSGA00; SSJU00; SSSB00','SSAS14; SSAS17; SSAS13; SSGA20; SSGA22; SSJU01; SSJU22; SSJU27(rm); SSJU28',null),
('W000437','Roger','F.',null,'Wicker','','MS','1','I','Tupelo','R',null,19,9.00,8.38,0.376,0.347,null,null,null,null,null,'','No','(202) 224-6253','https://www.wicker.senate.gov/public/index.cfm/contact','https://www.wicker.senate.gov','555 Dirksen','JCSE00(Co); JSPR00; SSAS00; SSCM00(rm); SSEV00; SSRA00','SSAS14; SSAS21; SSAS13; SSCM33; SSCM34; SSCM35; SSCM36; SSCM37; SSCM38; SSCM39; SSEV09(rm); SSEV10; SSEV08',null),
('H001079','Cindy','',null,'Hyde-Smith','','MS','2','II','Brookhaven','R',null,20,9.00,8.38,0.384,0.357,null,null,null,null,null,'','No','(202) 224-5054','https://www.hydesmith.senate.gov/content/contact-senator','https://www.hydesmith.senate.gov/','702 Hart','SSAF00; SSAP00; SSEG00; SSRA00','SSAF13; SSAF14; SSAF17(rm); SSAP01; SSAP22; SSAP23(rm); SSAP14; SSAP17; SSAP18; SSEG01; SSEG03; SSEG07(rm)',null),
('T000464','Jon','',null,'Tester','','MT','1','I','Big Sandy','D',2,null,11.00,8.40,-0.216,0.146,null,null,null,-0.230,0.321,'','Yes','(202) 224-2644','https://www.tester.senate.gov/?p=email_senator','https://www.tester.senate.gov/','311 Hart','SLIA00; SSAP00; SSBK00; SSCM00; SSVA00(Ch)','SSAP01; SSAP02(Ch); SSAP22; SSAP14; SSAP17; SSAP19; SSBK08; SSBK09; SSBK05; SSCM33; SSCM34; SSCM38; SSCM39',null),
('D000618','Steve','',null,'Daines','','MT','2','II','Bozeman','R',null,25,11.00,8.40,0.555,-0.119,null,null,null,null,null,'','No','(202) 224-2651','https://www.daines.senate.gov/connect/email-steve','https://www.daines.senate.gov','320 Hart','SLIA00; SSBK00; SSEG00; SSFI00','SSBK12; SSBK09; SSBK05; SSEG04(rm); SSEG03; SSFI12; SSFI10(rm); SSFI13',null),
('B001135','Richard','',null,'Burr','','NC','1','III','Winston-Salem','R',null,9,3.31,0.68,0.45,-0.053,null,null,null,0.469,-0.118,'','Yes','(202) 224-3154','https://www.burr.senate.gov/contact','https://www.burr.senate.gov','217 Russell','SLIN00; SPAG00; SSFI00; SSHR00(rm)','SSFI14; SSFI10; SSFI11; SSHR09; SSHR11; SSHR12',null),
('T000476','Thom','',null,'Tillis','','NC','2','II','Huntersville','R',null,10,3.31,0.68,0.426,0.069,null,null,null,null,null,'','No','(202) 224-6342','https://www.tillis.senate.gov/public/index.cfm/email-me','https://www.tillis.senate.gov','113 Dirksen','JCSE00; SSAS00; SSBK00; SSJU00; SSVA00','SSAS14; SSAS17(rm); SSAS13; SSBK12; SSBK08(rm); SSBK04; SSJU01; SSJU25; SSJU04; SSJU26(rm)',null),
('H001061','John','',null,'Hoeven','','ND','1','III','Bismarck','R',null,40,16.00,17.22,0.345,0.332,null,null,null,null,null,'','No','(202) 224-2551','https://www.hoeven.senate.gov/public/index.cfm/email-the-senator','https://www.hoeven.senate.gov','338 Russell','SLIA00; SSAF00; SSAP00; SSEG00','SSAF13(rm); SSAF14; SSAF16; SSAP01(rm); SSAP02; SSAP22; SSAP14; SSAP19; SSAP24; SSEG01(rm); SSEG04; SSEG07',null),
('C001096','Kevin','',null,'Cramer','','ND','2','I','Bismarck','R',null,41,16.00,17.22,0.389,0.294,null,null,null,null,null,'','No','(202) 224-2043','https://www.cramer.senate.gov/contact/contact-kevin','https://www.cramer.senate.gov','330 Hart','SSAS00; SSBK00; SSBU00; SSEV00; SSVA00','SSAS20; SSAS13(rm); SSAS16; SSBK12; SSBK08; SSBK09; SSEV10; SSEV15; SSEV08(rm)',null),
('F000463','Deb','',null,'Fischer','','NE','1','I','Lincoln','R',null,30,14.00,9.78,0.47,0.331,null,null,null,null,null,'','No','(202) 224-6551','https://www.fischer.senate.gov/public/index.cfm/contact','https://www.fischer.senate.gov','454 Russell','SLET00; SSAF00; SSAS00; SSCM00; SSRA00','SSAF16; SSAF17; SSAF15; SSAS20; SSAS15; SSAS16(rm); SSCM34; SSCM36; SSCM37; SSCM38(rm)',null),
('S001197','Ben','',null,'Sasse','','NE','2','II','Fremont','R',null,31,14.00,9.78,0.766,-0.213,null,null,null,null,null,'','Yes','(202) 224-4224','https://www.sasse.senate.gov/public/index.cfm/email-ben','https://www.sasse.senate.gov','139 Russell','SLIN00; SSBU00; SSFI00; SSJU00','SSFI13; SSFI02; SSFI11; SSJU25; SSJU27; SSJU28(rm); SSJU21',null),
('S001181','Jeanne','',null,'Shaheen','','NH','1','II','Madbury','D',10,null,0.00,-3.75,-0.238,-0.141,null,null,null,null,null,'','Yes','(202) 224-2841','https://www.shaheen.senate.gov/contact/contact-jeanne','https://www.shaheen.senate.gov','506 Hart','JCSE00; SLET00; SSAP00; SSAS00; SSFR00; SSSB00','SSAP16(Ch); SSAP02; SSAP22; SSAP14; SSAP18; SSAP20; SSAS20; SSAS15; SSAS13; SSFR01(Ch); SSFR15; SSFR07; SSFR06',null),
('H001076','Margaret','Wood',null,'Hassan','','NH','2','III','Newfields','D',9,null,0.00,-3.75,-0.232,-0.027,null,null,null,null,null,'','Yes','(202) 224-3324','https://www.hassan.senate.gov/content/contact-senator','https://www.hassan.senate.gov','324 Hart','JSEC00; SCNC00; SSFI00; SSGA00; SSHR00; SSVA00','SSFI12; SSFI10; SSFI02; SSGA01; SSGA20(Ch); SSHR09; SSHR12',null),
('M000639','Robert','',null,'Menendez','','NJ','1','I','Englewood Cliffs','D',35,null,-8.08,-8.07,-0.366,-0.124,null,null,null,-0.372,-0.117,'','Yes','(202) 224-4744','https://www.menendez.senate.gov/contact','https://www.menendez.senate.gov/','528 Hart','SSBK00; SSFI00; SSFR00(Ch)','SSBK08; SSBK09; SSBK04(Ch); SSFI10; SSFI13; SSFI11; SSFR09; SSFR02; SSFR01; SSFR15; SSFR07; SSFR14; SSFR06',null),
('B001288','Cory','A.',null,'Booker','','NJ','2','II','Newark','D',34,null,-8.08,-8.07,-0.592,-0.257,null,null,null,null,null,'','Yes','(202) 224-3224','https://www.booker.senate.gov/?p=contact','https://www.booker.senate.gov','717 Hart','SSAF00; SSFR00; SSJU00; SSSB00','SSAF14; SSAF16(Ch); SSAF17; SSFR09; SSFR15; SSFR07; SSJU01; SSJU22(Ch); SSJU25; SSJU04',null),
('H001046','Martin','',null,'Heinrich','','NM','1','I','Albuquerque','D',23,null,-3.00,-5.52,-0.328,-0.022,null,null,null,null,null,'','Yes','(202) 224-5521','https://www.heinrich.senate.gov/contact','https://www.heinrich.senate.gov/','303 Hart','JSEC00(VC); SLIN00; SSAP00; SSEG00','SSAP01; SSAP22; SSAP17; SSAP08; SSAP19(Ch); SSEG01; SSEG04; SSEG03',null),
('L000570','Ben','Ray',null,'Lujan','','NM','2','II','Santa Fe','D',22,null,-3.00,-5.52,-0.367,0.015,null,null,null,null,null,'','Yes','(202) 224-6621','https://www.lujan.senate.gov/contact/','https://www.lujan.senate.gov','498 Russell','SCNC00; SLIA00; SSAF00; SSBU00; SSCM00; SSHR00','SSAF13; SSAF14; SSAF15; SSCM34(Ch); SSCM35; SSCM36; SSCM37; SSHR11; SSHR12',null),
('C001113','Catherine','',null,'Cortez Masto','','NV','1','III','Las Vegas','D',21,null,-2.25,-1.22,-0.369,0.331,null,null,null,null,null,'','Yes','(202) 224-3542','https://www.cortezmasto.senate.gov/contact','https://www.cortezmasto.senate.gov','313 Hart','SLIA00; SSBK00; SSEG00; SSFI00','SSBK08; SSBK09; SSBK04; SSEG01; SSEG03(Ch); SSEG07; SSFI10; SSFI13; SSFI11',null),
('R000608','Jacky','',null,'Rosen','','NV','2','I','Henderson','D',20,null,-2.25,-1.22,-0.285,0.287,null,null,null,null,null,'','Yes','(202) 224-6244','https://www.rosen.senate.gov/contact_jacky','https://www.rosen.senate.gov','713 Hart','SPAG00; SSAS00; SSCM00; SSGA00; SSHR00; SSSB00','SSAS14; SSAS21; SSAS16; SSCM33; SSCM34; SSCM39(Ch); SSGA20; SSHR11; SSHR12',null),
('S000148','Charles','E.',null,'Schumer','','NY','1','III','Brooklyn','D',45,null,-13.26,-11.72,-0.359,-0.404,null,null,null,-0.362,-0.377,'','Yes','(202) 224-6542','https://www.schumer.senate.gov/contact/email-chuck','https://www.schumer.senate.gov/','322 Hart','SLIN00; SSRA00',null,'Democratic Leader Chairman of the Conference'),
('G000555','Kirsten','E.',null,'Gillibrand','','NY','2','I','Brunswick','D',44,null,-13.26,-11.72,-0.475,-0.422,null,null,null,null,null,'','Yes','(202) 224-4451','https://www.gillibrand.senate.gov/contact/email-me','https://www.gillibrand.senate.gov','478 Russell','SLIN00; SPAG00; SSAF00; SSAS00','SSAF13; SSAF16; SSAF17(Ch); SSAS21; SSAS20; SSAS17(Ch)',null),
('B000944','Sherrod','',null,'Brown','','OH','1','I','Cleveland','D',5,null,2.69,4.08,-0.428,-0.11,null,null,null,-0.452,-0.123,'','Yes','(202) 224-2315','https://www.brown.senate.gov/contact/','https://www.brown.senate.gov/','503 Hart','SSAF00; SSBK00(Ch); SSFI00; SSVA00','SSAF13; SSAF14; SSAF15; SSBK12; SSBK08; SSBK09; SSBK05; SSBK04; SSFI13; SSFI02(Ch); SSFI11',null),
('P000449','Rob','',null,'Portman','','OH','2','III','Terrace Park','R',null,8,2.69,4.08,0.372,-0.233,null,null,null,null,null,'','No','(202) 224-3353','https://www.portman.senate.gov/public/index.cfm/contact?p=contact-form','https://www.portman.senate.gov','448 Russell','JSEC00; SSFI00; SSFR00; SSGA00(rm)','SSFI13; SSFI02; SSFI11; SSFR01; SSFR15(rm); SSFR06; SSGA01; SSGA20; SSGA22',null),
('I000024','James','M.',null,'Inhofe','','OK','1','II','Tulsa','R',null,44,19.60,16.94,0.554,0.043,null,null,null,0.556,0.002,'','No','(202) 224-4721','https://www.inhofe.senate.gov/contact','https://www.inhofe.senate.gov/','205 Russell','SLIN00; SSAS00(rm); SSEV00; SSSB00','SSAS14; SSAS21; SSAS20; SSAS17; SSAS15; SSAS13; SSAS16; SSEV10(rm); SSEV15; SSEV08',null),
('L000575','James','',null,'Lankford','','OK','2','III','Edmond','R',null,45,19.60,16.94,0.59,0.179,null,null,null,null,null,'','No','(202) 224-5754','https://www.lankford.senate.gov/contact/email','https://www.lankford.senate.gov','316 Hart','SLET00(VC); SLIA00; SSEG00; SSFI00; SSGA00','SSEG01; SSEG04; SSEG03; SSFI12(rm); SSFI10; SSFI02; SSGA01; SSGA22(rm)',null),
('W000779','Ron','',null,'Wyden','','OR','1','III','Portland','D',25,null,-4.40,-8.31,-0.33,-0.476,null,null,null,-0.324,-0.351,'','Yes','(202) 224-5244','https://www.wyden.senate.gov/contact/','https://www.wyden.senate.gov/','221 Dirksen','JSTX00(VC); SLIN00; SSBU00; SSEG00; SSFI00(Ch)','SSEG01; SSEG03; SSEG07(Ch); SSFI12; SSFI14; SSFI10; SSFI13; SSFI02; SSFI11',null),
('M001176','Jeff','',null,'Merkley','','OR','2','II','Portland','D',24,null,-4.40,-8.31,-0.44,-0.744,null,null,null,null,null,'','Yes','(202) 224-3753','https://www.merkley.senate.gov/contact/','https://www.merkley.senate.gov','531 Hart','SSAP00; SSBU00; SSEV00; SSFR00; SSRA00','SSAP01; SSAP16; SSAP22; SSAP17(Ch); SSAP18; SSAP20; SSEV09(Ch); SSEV10; SSEV08; SSFR09; SSFR02; SSFR06',null),
('C001070','Robert','P.',null,'Casey','Jr.','PA','1','I','Scranton','D',8,null,1.00,-0.59,-0.315,0.193,null,null,null,-0.308,0.290,'','Yes','(202) 224-6324','https://www.casey.senate.gov/contact','https://www.casey.senate.gov/','393 Russell','SLIN00; SPAG00(Ch); SSFI00; SSHR00','SSFI10; SSFI13; SSFI02; SSHR09(Ch); SSHR12',null),
('T000461','Patrick','J.',null,'Toomey','','PA','2','III','Zionsville','R',null,5,1.00,-0.59,0.646,-0.288,null,null,null,null,null,'','Yes','(202) 224-4254','https://www.toomey.senate.gov/?p=contact','https://www.toomey.senate.gov/','455 Dirksen','SSBK00(rm); SSBU00; SSFI00','SSBK12; SSBK08; SSBK09; SSBK05; SSBK04; SSFI10; SSFI13; SSFI11',null),
('R000122','Jack','',null,'Reed','','RI','1','II','Jamestown','D',37,null,-10.00,-10.60,-0.367,-0.171,null,null,null,-0.401,-0.205,'','Yes','(202) 224-4642','https://www.reed.senate.gov/contact/','https://www.reed.senate.gov/','728 Hart','SLIN00; SSAP00; SSAS00(Ch); SSBK00','SSAP16; SSAP02; SSAP17; SSAP18; SSAP08(Ch); SSAP19; SSAP24; SSAS14; SSAS21; SSAS20; SSAS17; SSAS15; SSAS13; SSAS16; SSBK12; SSBK09; SSBK04',null),
('W000802','Sheldon','',null,'Whitehouse','','RI','2','I','Newport','D',36,null,-10.00,-10.60,-0.355,-0.078,null,null,null,-0.457,-0.211,'','Yes','(202) 224-2921','https://www.whitehouse.senate.gov/contact/email-sheldon','https://www.whitehouse.senate.gov/','530 Hart','JCSE00; SCNC00(Ch); SSBU00; SSEV00; SSFI00; SSJU00','SSEV10; SSEV15; SSEV08; SSFI12; SSFI10; SSFI11(Ch); SSJU22; SSJU25(Ch); SSJU28; SSJU21',null),
('G000359','Lindsey','',null,'Graham','','SC','1','II','Seneca','R',null,13,7.86,5.93,0.405,-0.17,null,null,null,0.422,-0.202,'','No','(202) 224-5972','https://www.lgraham.senate.gov/public/index.cfm/e-mail-senator-graham','https://www.lgraham.senate.gov/','290 Russell','SSAP00; SSBU00(rm); SSEV00; SSJU00','SSAP16; SSAP02; SSAP22; SSAP18; SSAP20(rm); SSAP24; SSEV09; SSEV10; SSEV08; SSJU22; SSJU25; SSJU04; SSJU28',null),
('S001184','Tim','',null,'Scott','','SC','2','III','Hanahan','R',null,14,7.86,5.93,0.637,-0.008,null,null,null,null,null,'','No','(202) 224-6121','https://www.scott.senate.gov/contact/email-me','https://www.scott.senate.gov/','104 Hart','JCSE00; SPAG00(rm); SSBK00; SSFI00; SSHR00; SSSB00','SSBK12; SSBK08; SSBK04(rm); SSFI12; SSFI10; SSFI13; SSHR11; SSHR12',null),
('T000250','John','',null,'Thune','','SD','1','III','Sioux Falls','R',null,32,14.00,13.43,0.411,0.137,null,null,null,0.416,0.085,'','No','(202) 224-2321','https://www.thune.senate.gov/public/index.cfm/contact','https://www.thune.senate.gov/','511 Dirksen','SSAF00; SSCM00; SSFI00','SSAF13; SSAF14; SSAF17; SSCM33; SSCM34(rm); SSCM35; SSCM38; SSFI10; SSFI13; SSFI11(rm)','Whip'),
('R000605','Mike','',null,'Rounds','','SD','2','II','Fort Pierre','R',null,33,14.00,13.43,0.406,0.126,null,null,null,null,null,'','No','(202) 224-5842','https://www.rounds.senate.gov/contact/email-mike','https://www.rounds.senate.gov','716 Hart','SLIA00; SSAS00; SSBK00; SSFR00; SSVA00','SSAS21(rm); SSAS15; SSAS16; SSBK08; SSBK09(rm); SSBK04; SSFR09(rm); SSFR02; SSFR15',null),
('B001243','Marsha','',null,'Blackburn','','TN','1','I','Brentwood','R',null,26,12.67,11.83,0.62,0.133,null,null,null,null,null,'','No','(202) 224-3344','https://www.blackburn.senate.gov/email-me','https://www.blackburn.senate.gov','357 Dirksen','SSAS00; SSCM00; SSJU00; SSVA00','SSAS21; SSAS20; SSAS15; SSCM34; SSCM35(rm); SSCM36; SSCM39; SSJU01; SSJU04; SSJU26; SSJU28',null),
('H000601','Bill','',null,'Hagerty','','TN','2','II','Nashville','R',null,27,12.67,11.83,0.781,-0.615,null,null,null,null,null,'','No','(202) 224-4944','https://www.hagerty.senate.gov/email-me/','https://www.hagerty.senate.gov','248 Russell','SSAP00; SSBK00; SSFR00; SSRA00','SSAP16; SSAP22; SSAP17; SSAP19; SSAP20; SSBK08; SSBK09; SSBK05(rm); SSFR02; SSFR07; SSFR14(rm); SSFR06',null),
('C001056','John','',null,'Cornyn','','TX','1','II','San Antonio','R',null,11,5.50,2.83,0.492,-0.009,null,null,null,0.517,-0.015,'','No','(202) 224-2934','https://www.cornyn.senate.gov/contact','https://www.cornyn.senate.gov/','517 Hart','SCNC00; SLIN00; SSFI00; SSJU00','SSFI12; SSFI13(rm); SSFI11; SSJU22; SSJU04(rm); SSJU26; SSJU21',null),
('C001098','Ted','',null,'Cruz','','TX','2','I','Houston','R',null,12,5.50,2.83,0.831,-0.284,null,null,null,null,null,'','No','(202) 224-5922','https://www.cruz.senate.gov/?p=form&id=16','https://www.cruz.senate.gov','127A Russell','JSEC00; SSCM00; SSFR00; SSJU00; SSRA00','SSCM33(rm); SSCM34; SSCM36; SSCM37; SSFR02; SSFR07; SSFR14; SSFR06; SSJU22; SSJU25; SSJU04; SSJU21(rm)',null),
('L000577','Mike','',null,'Lee','','UT','1','III','Alpine','R',null,47,20.00,10.69,0.917,-0.398,null,null,null,null,null,'','No','(202) 224-5444','https://www.lee.senate.gov/public/index.cfm/contact','https://www.lee.senate.gov/','363 Russell','JSEC00; SPAG00; SSCM00; SSEG00; SSJU00','SSCM33; SSCM34; SSCM35; SSCM37; SSEG04; SSEG03(rm); SSEG07; SSJU01(rm); SSJU22; SSJU25; SSJU21',null),
('R000615','Mitt','',null,'Romney','','UT','2','I','Holladay','R',null,48,20.00,10.69,0.36,0.606,null,null,null,null,null,'','Yes','(202) 224-5251','https://www.romney.senate.gov/contact-senator-romney','https://www.romney.senate.gov','354 Russell','SSBU00; SSFR00; SSGA00; SSHR00','SSFR02(rm); SSFR01; SSFR07; SSGA20; SSGA22; SSHR09; SSHR11',null),
('W000805','Mark','R.',null,'Warner','','VA','1','II','Alexandria','D',15,null,-0.73,-5.15,-0.202,-0.036,null,null,null,null,null,'','Yes','(202) 224-2023','https://www.warner.senate.gov/public/index.cfm?p=Contact','https://www.warner.senate.gov','703 Hart','JSLC00; SLIN00(Ch); SSBK00; SSBU00; SSFI00; SSRA00','SSBK08; SSBK05(Ch); SSBK04(rm); SSFI12; SSFI10; SSFI13',null),
('K000384','Tim','',null,'Kaine','','VA','2','I','Richmond','D',14,null,-0.73,-5.15,-0.243,-0.06,null,null,null,null,null,'','Yes','(202) 224-4024','https://www.kaine.senate.gov/contact','https://www.kaine.senate.gov/','231 Russell','SSAS00; SSBU00; SSFR00; SSHR00','SSAS20; SSAS15(Ch); SSAS13; SSFR09; SSFR14; SSFR06(Ch); SSHR09; SSHR12',null),
('L000174','Patrick','J.',null,'Leahy','','VT','1','III','Middlesex','D',46,null,-15.00,-18.30,-0.36,-0.12,null,null,null,-0.386,-0.101,'','Yes','(202) 224-4242','https://www.leahy.senate.gov/contact/','https://www.leahy.senate.gov/','437 Russell','JSLC00; SSAF00; SSAP00(Ch); SSJU00; SSRA00','SSAF14; SSAF16; SSAF17; SSAP01; SSAP16; SSAP02; SSAP22; SSAP23; SSAP14; SSAP17; SSAP18; SSAP08; SSAP19; SSAP20; SSAP24; SSJU01; SSJU22; SSJU25; SSJU26(Ch)','President Pro Tempore'),
('S000033','Bernard','',null,'Sanders','','VT','2','I','Burlington','I',null,null,-15.00,-18.30,-0.529,-0.389,null,null,null,-0.523,-0.286,'','Yes','(202) 224-5141','https://www.sanders.senate.gov/contact/','https://www.sanders.senate.gov/','332 Dirksen','SSBU00(Ch); SSEG00; SSEV00; SSHR00; SSVA00','SSEG01; SSEG04; SSEG07; SSEV09; SSEV10; SSEV08; SSHR09; SSHR12(Ch)',null),
('M001111','Patty','',null,'Murray','','WA','1','III','Freeland','D',27,null,-5.60,-9.93,-0.352,-0.311,null,null,null,-0.357,-0.215,'','Yes','(202) 224-2621','https://www.murray.senate.gov/write-to-patty/','https://www.murray.senate.gov/','154 Russell','SSAP00; SSBU00; SSHR00(Ch); SSVA00','SSAP02; SSAP22; SSAP14; SSAP18(Ch); SSAP19; SSAP24; SSHR09; SSHR11; SSHR12','Assistant Democratic Leader'),
('C000127','Maria','',null,'Cantwell','','WA','2','I','Edmonds','D',26,null,-5.60,-9.93,-0.304,-0.42,null,null,null,-0.301,-0.321,'','Yes','(202) 224-3441','https://www.cantwell.senate.gov/public/index.cfm/email-maria','https://www.cantwell.senate.gov','511 Hart','JSTX00; SLIA00; SSCM00(Ch); SSEG00; SSFI00; SSSB00','SSCM33; SSCM34; SSCM35; SSCM36; SSCM37; SSCM38; SSCM39',null),
('J000293','Ron','',null,'Johnson','','WI','1','III','Oshkosh','R',null,2,-0.25,-0.32,0.605,-0.271,null,null,null,null,null,'','No','(202) 224-5323','https://www.ronjohnson.senate.gov/public/index.cfm/email-the-senator','https://www.ronjohnson.senate.gov/','328 Hart','SSBU00; SSCM00; SSFR00; SSGA00','SSCM34; SSCM36; SSCM38; SSCM39; SSFR02; SSFR01(rm); SSFR14; SSGA01(rm); SSGA22',null),
('B001230','Tammy','',null,'Baldwin','','WI','2','I','Madison','D',11,null,-0.25,-0.32,-0.493,-0.139,null,null,null,null,null,'','Yes','(202) 224-5653','https://www.baldwin.senate.gov/feedback','https://www.baldwin.senate.gov/','709 Hart','SSAP00; SSCM00; SSHR00','SSAP01(Ch); SSAP02; SSAP22; SSAP14; SSAP18; SSAP19; SSCM34; SSCM35; SSCM36(Ch); SSCM38; SSHR11; SSHR12',null),
('M001183','Joe','',null,'Manchin','III','WV','1','I','Charleston','D',1,null,19.67,19.80,-0.055,0.444,null,null,null,null,null,'','Yes','(202) 224-3954','https://www.manchin.senate.gov/public/index.cfm/contact-form','https://www.manchin.senate.gov/','306 Hart','SSAP00; SSAS00; SSEG00(Ch); SSVA00','SSAP16; SSAP23; SSAP18; SSAP19; SSAP24; SSAS14; SSAS21(Ch); SSAS16; SSEG01; SSEG04; SSEG03; SSEG07',null),
('C001047','Shelley','Moore',null,'Capito','','WV','2','II','Charleston','R',null,46,19.67,19.80,0.263,0.059,null,null,null,null,null,'','No','(202) 224-6472','https://www.capito.senate.gov/contact/contact-shelley','https://www.capito.senate.gov','172 Russell','SSAP00; SSCM00; SSEV00(rm); SSRA00','SSAP16; SSAP14(rm); SSAP17; SSAP18; SSAP19; SSAP24; SSCM33; SSCM34; SSCM38; SSCM39; SSEV09; SSEV10; SSEV15; SSEV08',null),
('B001261','John','',null,'Barrasso','','WY','1','I','Casper','R',null,49,25.00,22.48,0.541,0.249,null,null,null,0.554,0.220,'','No','(202) 224-6441','https://www.barrasso.senate.gov/public/index.cfm/contact-form','https://www.barrasso.senate.gov','307 Dirksen','SSEG00(rm); SSFI00; SSFR00','SSEG01; SSEG04; SSEG03; SSEG07; SSFI12; SSFI10; SSFI13; SSFR09; SSFR01; SSFR15; SSFR06',null),
('L000571','Cynthia','M.',null,'Lummis','','WY','2','II','Cheyenne','R',null,50,25.00,22.48,0.674,-0.392,null,null,null,null,null,'','No','(202) 224-3424','https://www.lummis.senate.gov/contact/contact-form/','https://www.lummis.senate.gov','124 Russell','SSBK00; SSCM00; SSEV00','SSBK08; SSBK09; SSBK04; SSCM34; SSCM37(rm); SSCM38; SSCM39; SSEV10; SSEV15(rm); SSEV08',null);
