| Index: trunk/extensions/CongressLookup/data/cl_house.sql |
| — | — | @@ -65,7 +65,7 @@ |
| 66 | 66 | (400076, 'C000556', 'M', 'Rep. Howard Coble [R, NC-6]', 'Rep.', 'NC', '6', '202-225-3065', '202-225-8611', 'http://www.house.gov/writerep', NULL), |
| 67 | 67 | (400077, 'C001053', 'M', 'Rep. Tom Cole [R, OK-4]', 'Rep.', 'OK', '4', '202-225-6165', '202-225-3512', 'http://www.cole.house.gov/contact-tom.html', NULL), |
| 68 | 68 | (400080, 'C000714', 'M', 'Rep. John Conyers [D, MI-14]', 'Rep.', 'MI', '14', '202-225-5126', '202-225-0072', 'http://conyers.house.gov/index.cfm?FuseAction=Contact.OnlineContactForm', 'repjohnconyers'), |
| 69 | | -(400081, 'C000754', 'M', 'Rep. Jim Cooper [D, TN-5]', 'Rep.', 'TN', '5', '202-225-4311', '202-226-1035', 'http://www.cooper.house.gov/index.php?option=com_content&task=view&id=117&Itemid=61', 'repjimcooper'), |
| | 69 | +(400081, 'C000754', 'M', 'Rep. Jim Cooper [D, TN-5]', 'Rep.', 'TN', '5', '202-225-4311', '202-226-1035', 'https://forms.house.gov/cooper/webforms/issue_subscribe.html', 'repjimcooper'), |
| 70 | 70 | (400082, 'C000794', 'M', 'Rep. Jerry Costello [D, IL-12]', 'Rep.', 'IL', '12', '202-225-5661', '202-225-0285', 'http://costello.house.gov/IMA/issue_subscribe.shtml', 'JerryCostello'), |
| 71 | 71 | (400086, 'C001045', 'M', 'Rep. Ander Crenshaw [R, FL-4]', 'Rep.', 'FL', '4', '202-225-2501', '202-225-2504', 'https://forms.house.gov/wyr/welcome.shtml', 'AnderCrenshaw'), |
| 72 | 72 | (400087, 'C001038', 'M', 'Rep. Joseph Crowley [D, NY-7]', 'Rep.', 'NY', '7', '202-225-3965', '202-225-1909', 'https://forms.house.gov/crowley/contact.shtml', NULL), |
| — | — | @@ -182,7 +182,7 @@ |
| 183 | 183 | (400311, 'P000583', 'M', 'Rep. Ronald Paul [R, TX-14]', 'Rep.', 'TX', '14', '202-225-2831', '202-226-6553', 'http://www.house.gov/paul/contact.shtml', 'RepRonPaul'), |
| 184 | 184 | (400312, 'P000149', 'M', 'Rep. Donald Payne [D, NJ-10]', 'Rep.', 'NJ', '10', '202-225-3436', '202-225-4160', 'http://www.house.gov/payne/IMA/email.shtml', NULL), |
| 185 | 185 | (400313, 'P000588', 'M', 'Rep. Steven Pearce [R, NM-2]', 'Rep.', 'NM', '2', '202-225-2365', '', 'https://pearce.house.gov/contact-me/email-me', 'RepStevePearce'), |
| 186 | | -(400314, 'P000197', 'F', 'Rep. Nancy Pelosi [D, CA-8]', 'Rep.', 'CA', '8', '202-225-4965', '202-225-8259', 'http://www.house.gov/pelosi/contact/contact.html', 'nancypelosi'), |
| | 186 | +(400314, 'P000197', 'F', 'Rep. Nancy Pelosi [D, CA-8]', 'Rep.', 'CA', '8', '202-225-4965', '202-225-8259', 'https://pelosi.house.gov/contact/email-me.shtml', 'nancypelosi'), |
| 187 | 187 | (400315, 'P000587', 'M', 'Rep. Mike Pence [R, IN-6]', 'Rep.', 'IN', '6', '202-225-3021', '202-225-3382', 'https://forms.house.gov/pence/IMA/contact_form.htm', 'RepMikePence'), |
| 188 | 188 | (400316, 'P000258', 'M', 'Rep. Collin Peterson [D, MN-7]', 'Rep.', 'MN', '7', '202-225-2165', '202-225-1593', 'http://collinpeterson.house.gov//email.html', NULL), |
| 189 | 189 | (400318, 'P000265', 'M', 'Rep. Thomas Petri [R, WI-6]', 'Rep.', 'WI', '6', '202-225-2476', '202-225-2356', 'https://forms.house.gov/petri/zip_authen.shtml', NULL), |