| Index: trunk/extensions/CongressLookup/data/cl_senate.sql |
| — | — | @@ -3,7 +3,7 @@ |
| 4 | 4 | (300002, 'A000360', 'M', 'Sen. Lamar Alexander [R, TN]', 'Sen.', 'TN', '202-224-4944', '202-228-3398', 'http://www.alexander.senate.gov/public/index.cfm?p=Email', 'SenAlexander'), |
| 5 | 5 | (300005, 'B000243', 'M', 'Sen. Max Baucus [D, MT]', 'Sen.', 'MT', '202-224-2651', '202-224-0515', 'http://www.baucus.senate.gov/contact/emailForm.cfm?subj=issue', NULL), |
| 6 | 6 | (300009, 'B000468', 'M', 'Sen. Jeff Bingaman [D, NM]', 'Sen.', 'NM', '202-224-5521', '202-224-2852', 'http://www.bingaman.senate.gov/contact/', NULL), |
| 7 | | -(300011, 'B000711', 'F', 'Sen. Barbara Boxer [D, CA]', 'Sen.', 'CA', '202-224-3553', '202-224-0454', 'https://boxer.senate.gov/en/contact/policycomments.cfm', 'Barbara_Boxer'), |
| | 7 | +(300011, 'B000711', 'F', 'Sen. Barbara Boxer [D, CA]', 'Sen.', 'CA', '202-224-3553', '202-224-0454', 'https://boxer.senate.gov/en/contact/policycomments.cfm', 'senatorboxer'), |
| 8 | 8 | (300018, 'C000127', 'F', 'Sen. Maria Cantwell [D, WA]', 'Sen.', 'WA', '202-224-3441', '202-228-0514', 'http://www.cantwell.senate.gov/contact/', NULL), |
| 9 | 9 | (300019, 'C000174', 'M', 'Sen. Thomas Carper [D, DE]', 'Sen.', 'DE', '202-224-2441', '202-228-2190', 'http://www.carper.senate.gov/contact/', NULL), |
| 10 | 10 | (300021, 'C000286', 'M', 'Sen. Saxby Chambliss [R, GA]', 'Sen.', 'GA', '202-224-3521', '202-224-0103', 'http://www.chambliss.senate.gov/public/index.cfm?p=Email', NULL), |
| — | — | @@ -92,10 +92,10 @@ |
| 93 | 93 | (412384, 'B001268', 'M', 'Sen. Scott Brown [R, MA]', 'Sen.', 'MA', '202-224-4543', '', 'http://www.scottbrown.senate.gov/public/index.cfm/emailscottbrown', 'USSenScottBrown'), |
| 94 | 94 | (412390, 'C001088', 'M', 'Sen. Chris Coons [D, DE]', 'Sen.', 'DE', '202-224-5042', '', 'http://www.coons.senate.gov/contact/', NULL), |
| 95 | 95 | (412391, 'M001183', 'M', 'Sen. Joe Manchin [D, WV]', 'Sen.', 'WV', '202-224-3954', '', 'http://www.manchin.senate.gov/contact_form.cfm', 'Sen_JoeManchin'), |
| 96 | | -(412490, 'B001277', 'M', 'Sen. Richard Blumenthal [D, CT]', 'Sen.', 'CT', '202-224-2823', '', 'http://www.blumenthal.senate.gov/contact/', NULL), |
| | 96 | +(412490, 'B001277', 'M', 'Sen. Richard Blumenthal [D, CT]', 'Sen.', 'CT', '202-224-2823', '202-224-9673', 'http://www.blumenthal.senate.gov/contact/', 'SenBlumenthal'), |
| 97 | 97 | (412491, 'R000595', 'M', 'Sen. Marco Rubio [R, FL]', 'Sen.', 'FL', '202-224-3041', '202-224-3041', 'http://www.rubio.senate.gov/public/index.cfm/contact', 'marcorubio'), |
| 98 | 98 | (412492, 'P000603', 'M', 'Sen. Rand Paul [R, KY]', 'Sen.', 'KY', '202-224-4343', '', 'http://www.paul.senate.gov/?p=contact', 'SenRandPaul'), |
| 99 | | -(412493, 'A000368', 'F', 'Sen. Kelly Ayotte [R, NH]', 'Sen.', 'NH', '202-224-3324', '', 'http://www.ayotte.senate.gov/?p=contact', NULL), |
| 100 | | -(412494, 'H001061', 'M', 'Sen. John Hoeven [R, ND]', 'Sen.', 'ND', '202-224-2551', '', 'http://www.hoeven.senate.gov/public/index.cfm/email-the-senator', NULL), |
| 101 | | -(412495, 'L000577', 'M', 'Sen. Mike Lee [R, UT]', 'Sen.', 'UT', '202-224-5444', '', 'http://www.lee.senate.gov/public/index.cfm/contact', NULL), |
| | 99 | +(412493, 'A000368', 'F', 'Sen. Kelly Ayotte [R, NH]', 'Sen.', 'NH', '202-224-3324', '202-224-4952', 'http://www.ayotte.senate.gov/?p=contact', 'SenatorAyotte'), |
| | 100 | +(412494, 'H001061', 'M', 'Sen. John Hoeven [R, ND]', 'Sen.', 'ND', '202-224-2551', '202-224-7999', 'http://www.hoeven.senate.gov/public/index.cfm/email-the-senator', NULL), |
| | 101 | +(412495, 'L000577', 'M', 'Sen. Mike Lee [R, UT]', 'Sen.', 'UT', '202-224-5444', '202-228-1168', 'http://www.lee.senate.gov/public/index.cfm/contact', 'SenMikeLee'), |
| 102 | 102 | (412496, 'J000293', 'M', 'Sen. Ron Johnson [R, WI]', 'Sen.', 'WI', '202-224-5323', '', 'http://www.ronjohnson.senate.gov/public/index.cfm/contact', 'SenRonJohnson'); |