Index: trunk/extensions/CongressLookup/data/cl_house.sql |
— | — | @@ -65,7 +65,7 @@ |
66 | 66 | (400121, 'E000172', 'F', 'Rep. Jo Ann Emerson [R, MO-8]', 'Rep.', 'MO', '8', '202-225-4404', '202-226-0326', 'https://forms.house.gov/emerson/webforms/contact.html', 'joannemerson'), |
67 | 67 | (400122, 'E000179', 'M', 'Rep. Eliot Engel [D, NY-17]', 'Rep.', 'NY', '17', '202-225-2464', '202-225-5513', 'http://engel.house.gov/index.cfm?sectionid=169§iontree=3169', NULL), |
68 | 68 | (400124, 'E000215', 'F', 'Rep. Anna Eshoo [D, CA-14]', 'Rep.', 'CA', '14', '202-225-8104', '202-225-8890', 'https://forms.house.gov/eshoo/webforms/issue_subscribe.htm', 'RepAnnaEshoo'), |
69 | | -(400128, 'F000010', 'M', 'Del. Eni Faleomavaega [D, AS-0]', 'Del.', 'AS', '0', '202-225-8577', '', 'faleomavaega@mail.house.gov', NULL), |
| 69 | +(400128, 'F000010', 'M', 'Del. Eni Faleomavaega [D, AS-0]', 'Del.', 'AS', '0', '202-225-8577', '', 'mailto:faleomavaega@mail.house.gov', NULL), |
70 | 70 | (400129, 'F000030', 'M', 'Rep. Sam Farr [D, CA-17]', 'Rep.', 'CA', '17', '202-225-2861', '202-225-6791', 'https://forms.house.gov/farr/webforms/issue_subscribe.html', NULL), |
71 | 71 | (400130, 'F000043', 'M', 'Rep. Chaka Fattah [D, PA-2]', 'Rep.', 'PA', '2', '202-225-4001', '202-225-5392', 'https://fattahforms.house.gov/index.cfm?sectionid=244§iontree=244', 'chakafattah'), |
72 | 72 | (400133, 'F000116', 'M', 'Rep. Bob Filner [D, CA-51]', 'Rep.', 'CA', '51', '202-225-8045', '202-225-9073', 'https://filner.house.gov/contact-me/email-me', 'CongBobFilner'), |
— | — | @@ -108,7 +108,7 @@ |
109 | 109 | (400211, 'K000009', 'F', 'Rep. Marcy Kaptur [D, OH-9]', 'Rep.', 'OH', '9', '202-225-4146', '202-225-7711', 'https://forms.house.gov/kaptur/webforms/issue_subscribe.htm', NULL), |
110 | 110 | (400216, 'K000172', 'M', 'Rep. Dale Kildee [D, MI-5]', 'Rep.', 'MI', '5', '202-225-3611', '202-225-6393', 'https://kildeeforms.house.gov/contact/contact-form.shtml', NULL), |
111 | 111 | (400218, 'K000188', 'M', 'Rep. Ronald Kind [D, WI-3]', 'Rep.', 'WI', '3', '202-225-5506', '202-225-5739', 'https://kindforms.house.gov/index.cfm?sectionid=146§iontree=18146', NULL), |
112 | | -(400219, 'K000210', 'M', 'Rep. Peter King [R, NY-3]', 'Rep.', 'NY', '3', '202-225-7896', '202-226-2279', 'Pete.King@mail.house.gov', 'RepPeteKing'), |
| 112 | +(400219, 'K000210', 'M', 'Rep. Peter King [R, NY-3]', 'Rep.', 'NY', '3', '202-225-7896', '202-226-2279', 'mailto:Pete.King@mail.house.gov', 'RepPeteKing'), |
113 | 113 | (400220, 'K000362', 'M', 'Rep. Steve King [R, IA-5]', 'Rep.', 'IA', '5', '202-225-4426', '202-225-3193', 'https://forms.house.gov/king/webforms/issue_subscribe.html', 'SteveKingPress'), |
114 | 114 | (400221, 'K000220', 'M', 'Rep. Jack Kingston [R, GA-1]', 'Rep.', 'GA', '1', '202-225-5831', '202-226-2269', 'https://kingstonforms.house.gov/ContactForm/default.aspx', 'JackKingston'), |
115 | 115 | (400224, 'K000363', 'M', 'Rep. John Kline [R, MN-2]', 'Rep.', 'MN', '2', '202-225-2271', '202-225-2595', 'http://kline.house.gov/index.cfm?sectionid=7§iontree=47', NULL), |