r109100 MediaWiki - Code Review archive

Repository:MediaWiki
Revision:< r109099‎ | r109100 | r109101 >
Date:02:13, 17 January 2012
Author:kaldari
Status:ok (Comments)
Tags:
Comment:
fixing schema, adding twitter and missing contact pages
Modified paths:
  • /trunk/extensions/CongressLookup/CongressLookup.db.php (modified) (history)
  • /trunk/extensions/CongressLookup/data/cl_house.sql (modified) (history)
  • /trunk/extensions/CongressLookup/data/cl_senate.sql (modified) (history)
  • /trunk/extensions/CongressLookup/data/cl_zip3.sql (modified) (history)
  • /trunk/extensions/CongressLookup/data/cl_zip5.sql (modified) (history)
  • /trunk/extensions/CongressLookup/patches/CongressLookup.sql (modified) (history)

Diff [purge]

Index: trunk/extensions/CongressLookup/CongressLookup.db.php
——@@ -16,38 +16,40 @@
1717 $zip = self::trimZip( $zip, 5 ); // Trim it to 5 digit
1818 $zip = intval( $zip ); // Convert into an integer
1919
20 - $row = $dbr->selectRow( 'cl_zip5', 'sz5_rep_id', array( 'sz5_zip' => $zip ) );
 20+ $row = $dbr->selectRow( 'cl_zip5', 'clz5_rep_id', array( 'clz5_zip' => $zip ) );
2121 if ( $row ) {
22 - $rep_id = $row->sz5_rep_id;
 22+ $rep_id = $row->clz5_rep_id;
2323 $res = $dbr->select(
2424 'cl_house',
2525 array(
26 - 'sh_bioguideid',
27 - 'sh_gender',
28 - 'sh_name',
29 - 'sh_title',
30 - 'sh_state',
31 - 'sh_district',
32 - 'sh_phone',
33 - 'sh_fax',
34 - 'sh_contactform'
 26+ 'clh_bioguideid',
 27+ 'clh_gender',
 28+ 'clh_name',
 29+ 'clh_title',
 30+ 'clh_state',
 31+ 'clh_district',
 32+ 'clh_phone',
 33+ 'clh_fax',
 34+ 'clh_contactform',
 35+ 'clh_twitter'
3536 ),
3637 array(
37 - 'sh_id' => $rep_id,
 38+ 'clh_id' => $rep_id,
3839 ),
3940 __METHOD__
4041 );
4142 foreach ( $res as $row ) {
4243 $oneHouseRep = array(
43 - 'bioguideid' => $row->sh_bioguideid,
44 - 'gender' => $row->sh_gender,
45 - 'name' => $row->sh_name,
46 - 'title' => $row->sh_title,
47 - 'state' => $row->sh_state,
48 - 'district' => $row->sh_district,
49 - 'phone' => $row->sh_phone,
50 - 'fax' => $row->sh_fax,
51 - 'contactform' => $row->sh_contactform
 44+ 'bioguideid' => $row->clh_bioguideid,
 45+ 'gender' => $row->clh_gender,
 46+ 'name' => $row->clh_name,
 47+ 'title' => $row->clh_title,
 48+ 'state' => $row->clh_state,
 49+ 'district' => $row->clh_district,
 50+ 'phone' => $row->clh_phone,
 51+ 'fax' => $row->clh_fax,
 52+ 'contactform' => $row->clh_contactform,
 53+ 'twitter' => $row->clh_twitter,
5254 );
5355 $repData[] = $oneHouseRep;
5456 }
——@@ -68,36 +70,38 @@
6971 $zip = self::trimZip( $zip, 3 ); // Trim it to 3 digit
7072 $zip = intval( $zip ); // Convert into an integer
7173
72 - $row = $dbr->selectRow( 'cl_zip3', 'sz3_state', array( 'sz3_zip' => $zip ) );
 74+ $row = $dbr->selectRow( 'cl_zip3', 'clz3_state', array( 'clz3_zip' => $zip ) );
7375 if ( $row ) {
74 - $state = $row->sz3_state;
 76+ $state = $row->clz3_state;
7577 $res = $dbr->select(
7678 'cl_senate',
7779 array(
78 - 'ss_bioguideid',
79 - 'ss_gender',
80 - 'ss_name',
81 - 'ss_title',
82 - 'ss_state',
83 - 'ss_phone',
84 - 'ss_fax',
85 - 'ss_contactform'
 80+ 'cls_bioguideid',
 81+ 'cls_gender',
 82+ 'cls_name',
 83+ 'cls_title',
 84+ 'cls_state',
 85+ 'cls_phone',
 86+ 'cls_fax',
 87+ 'cls_contactform',
 88+ 'cls_twitter'
8689 ),
8790 array(
88 - 'ss_state' => $state,
 91+ 'cls_state' => $state,
8992 ),
9093 __METHOD__
9194 );
9295 foreach ( $res as $row ) {
9396 $oneSenator = array(
94 - 'bioguideid' => $row->ss_bioguideid,
95 - 'gender' => $row->ss_gender,
96 - 'name' => $row->ss_name,
97 - 'title' => $row->ss_title,
98 - 'state' => $row->ss_state,
99 - 'phone' => $row->ss_phone,
100 - 'fax' => $row->ss_fax,
101 - 'contactform' => $row->ss_contactform
 97+ 'bioguideid' => $row->cls_bioguideid,
 98+ 'gender' => $row->cls_gender,
 99+ 'name' => $row->cls_name,
 100+ 'title' => $row->cls_title,
 101+ 'state' => $row->cls_state,
 102+ 'phone' => $row->cls_phone,
 103+ 'fax' => $row->cls_fax,
 104+ 'contactform' => $row->cls_contactform,
 105+ 'twitter' => $row->cls_twitter
102106 );
103107 $senatorData[] = $oneSenator;
104108 }
Index: trunk/extensions/CongressLookup/patches/CongressLookup.sql
——@@ -1,37 +1,37 @@
22 CREATE TABLE IF NOT EXISTS /*$wgDBprefix*/cl_senate (
3 - `ss_id` int(10) unsigned NOT NULL PRIMARY KEY,
4 - `ss_bioguideid` varchar(32) NOT NULL,
5 - `ss_gender` varchar(1) NOT NULL,
6 - `ss_name` varchar(255) NOT NULL,
7 - `ss_title` varchar(8) NOT NULL,
8 - `ss_state` varchar(2) NOT NULL,
9 - `ss_phone` varchar(32) NOT NULL,
10 - `ss_fax` varchar(32) NOT NULL,
11 - `ss_contactform` varchar(255) NOT NULL,
12 - `ss_twitter` varchar(64) DEFAULT NULL
 3+ `cls_id` int(10) unsigned NOT NULL PRIMARY KEY,
 4+ `cls_bioguideid` varchar(32) NOT NULL,
 5+ `cls_gender` varchar(1) NOT NULL,
 6+ `cls_name` varchar(255) NOT NULL,
 7+ `cls_title` varchar(8) NOT NULL,
 8+ `cls_state` varchar(2) NOT NULL,
 9+ `cls_phone` varchar(32) NOT NULL,
 10+ `cls_fax` varchar(32) NOT NULL,
 11+ `cls_contactform` varchar(255) NOT NULL,
 12+ `cls_twitter` varchar(64) DEFAULT NULL
1313 ) /*$wgDBTableOptions*/;
14 -CREATE INDEX /*i*/ss_state ON /*$wgDBprefix*/cl_senate (ss_state);
 14+CREATE INDEX /*i*/cls_state ON /*$wgDBprefix*/cl_senate (cls_state);
1515
1616 CREATE TABLE IF NOT EXISTS /*$wgDBprefix*/cl_house (
17 - `sh_id` int(10) unsigned NOT NULL PRIMARY KEY,
18 - `sh_bioguideid` varchar(32) NOT NULL,
19 - `sh_gender` varchar(1) NOT NULL,
20 - `sh_name` varchar(255) NOT NULL,
21 - `sh_title` varchar(8) NOT NULL,
22 - `sh_state` varchar(2) NOT NULL,
23 - `sh_district` varchar(32) NOT NULL,
24 - `sh_phone` varchar(32) NOT NULL,
25 - `sh_fax` varchar(32) NOT NULL,
26 - `sh_contactform` varchar(255) NOT NULL,
27 - `sh_twitter` varchar(64) DEFAULT NULL
 17+ `clh_id` int(10) unsigned NOT NULL PRIMARY KEY,
 18+ `clh_bioguideid` varchar(32) NOT NULL,
 19+ `clh_gender` varchar(1) NOT NULL,
 20+ `clh_name` varchar(255) NOT NULL,
 21+ `clh_title` varchar(8) NOT NULL,
 22+ `clh_state` varchar(2) NOT NULL,
 23+ `clh_district` varchar(32) NOT NULL,
 24+ `clh_phone` varchar(32) NOT NULL,
 25+ `clh_fax` varchar(32) NOT NULL,
 26+ `clh_contactform` varchar(255) NOT NULL,
 27+ `clh_twitter` varchar(64) DEFAULT NULL
2828 ) /*$wgDBTableOptions*/;
2929
3030 CREATE TABLE IF NOT EXISTS /*$wgDBprefix*/cl_zip3 (
31 - `sz3_zip` int(3) unsigned NOT NULL PRIMARY KEY,
32 - `sz3_state` varchar(2) DEFAULT NULL
 31+ `clz3_zip` int(3) unsigned NOT NULL PRIMARY KEY,
 32+ `clz3_state` varchar(2) DEFAULT NULL
3333 ) /*$wgDBTableOptions*/;
3434
3535 CREATE TABLE IF NOT EXISTS /*$wgDBprefix*/cl_zip5 (
36 - `sz5_zip` int(5) unsigned NOT NULL PRIMARY KEY,
37 - `sz5_rep_id` int(10) unsigned DEFAULT NULL
 36+ `clz5_zip` int(5) unsigned NOT NULL PRIMARY KEY,
 37+ `clz5_rep_id` int(10) unsigned DEFAULT NULL
3838 ) /*$wgDBTableOptions*/;
Index: trunk/extensions/CongressLookup/data/cl_house.sql
——@@ -3,7 +3,7 @@
44 -- http://www.phpmyadmin.net
55 --
66 -- Host: 127.0.0.1
 7+-- Generation Time: Jan 16, 2012 at 06:01 PM
78 -- Server version: 5.1.47
89 -- PHP Version: 5.3.6
910
——@@ -19,445 +19,445 @@
2020 -- Dumping data for table `cl_house`
2121 --
2222
23 -INSERT INTO `cl_house` (`sh_id`, `sh_bioguideid`, `sh_gender`, `sh_name`, `sh_title`, `sh_state`, `sh_district`, `sh_phone`, `sh_fax`, `sh_contactform`) VALUES
24 -(400003, 'A000022', 'M', 'Rep. Gary Ackerman [D, NY-5]', 'Rep.', 'NY', '5', '202-225-2601', '202-225-1589', 'http://www.house.gov/writerep'),
25 -(400004, 'A000055', 'M', 'Rep. Robert Aderholt [R, AL-4]', 'Rep.', 'AL', '4', '202-225-4876', '202-225-5587', 'http://aderholt.house.gov/?sectionid=195&sectiontree=195'),
26 -(400005, 'A000358', 'M', 'Rep. Todd Akin [R, MO-2]', 'Rep.', 'MO', '2', '202-225-2561', '202-225-2563', 'http://akin.house.gov/email.shtml'),
27 -(400006, 'A000361', 'M', 'Rep. Rodney Alexander [R, LA-5]', 'Rep.', 'LA', '5', '202-225-8490', '202-225-5639', 'http://www.house.gov/alexander/content/webform/zipauth.htm'),
28 -(400008, 'A000210', 'M', 'Rep. Robert Andrews [D, NJ-1]', 'Rep.', 'NJ', '1', '202-225-6501', '', 'http://www.house.gov/andrews/contact_form_za.shtml'),
29 -(400009, 'B001234', 'M', 'Rep. Joe Baca [D, CA-43]', 'Rep.', 'CA', '43', '202-225-6161', '202-225-8671', 'http://www.house.gov/baca/zipauth.shtml'),
30 -(400010, 'B000013', 'M', 'Rep. Spencer Bachus [R, AL-6]', 'Rep.', 'AL', '6', '202-225-4921', '202-225-2082', 'http://www.house.gov/writerep/'),
31 -(400013, 'B001230', 'F', 'Rep. Tammy Baldwin [D, WI-2]', 'Rep.', 'WI', '2', '202-225-2906', '202-225-6942', 'http://www.house.gov/formbaldwin/IMA/get_address.htm'),
32 -(400017, 'B000208', 'M', 'Rep. Roscoe Bartlett [R, MD-6]', 'Rep.', 'MD', '6', '202-225-2721', '202-225-2193', 'http://www.bartlett.house.gov/Email_Roscoe/'),
33 -(400018, 'B000213', 'M', 'Rep. Joe Barton [R, TX-6]', 'Rep.', 'TX', '6', '202-225-2002', '202-225-3052', 'http://joebarton.house.gov/ContactJoe.aspx?Type=Email'),
34 -(400019, 'B000220', 'M', 'Rep. Charles Bass [R, NH-2]', 'Rep.', 'NH', '2', '202-225-5206', '202-225-2946', ''),
35 -(400021, 'B000287', 'M', 'Rep. Xavier Becerra [D, CA-31]', 'Rep.', 'CA', '31', '202-225-6235', '202-225-2202', 'http://becerra.house.gov/HoR/CA31/Hidden+Content/Email+Signup+Form.htm'),
36 -(400024, 'B001231', 'F', 'Rep. Shelley Berkley [D, NV-1]', 'Rep.', 'NV', '1', '202-225-5965', '202-225-3119', 'http://berkley.house.gov/contact/email.html'),
37 -(400025, 'B000410', 'M', 'Rep. Howard Berman [D, CA-28]', 'Rep.', 'CA', '28', '202-225-4695', '202-225-3196', 'http://www.house.gov/berman/contact/'),
38 -(400027, 'B001232', 'F', 'Rep. Judy Biggert [R, IL-13]', 'Rep.', 'IL', '13', '202-225-3515', '202-225-9420', 'http://judybiggert.house.gov/ContactJudy.aspx'),
39 -(400029, 'B001250', 'M', 'Rep. Rob Bishop [R, UT-1]', 'Rep.', 'UT', '1', '202-225-0453', '202-225-5857', 'http://robbishop.house.gov/ZipAuth.aspx'),
40 -(400030, 'B000490', 'M', 'Rep. Sanford Bishop [D, GA-2]', 'Rep.', 'GA', '2', '202-225-3631', '202-225-2203', 'http://bishop.house.gov/display.cfm?section_id=13'),
41 -(400031, 'B001242', 'M', 'Rep. Timothy Bishop [D, NY-1]', 'Rep.', 'NY', '1', '202-225-3826', '202-225-3143', 'http://timbishop.house.gov/?sectionid=96&sectiontree=7,96'),
42 -(400032, 'B001243', 'F', 'Rep. Marsha Blackburn [R, TN-7]', 'Rep.', 'TN', '7', '202-225-2811', '202-225-3004', 'http://blackburn.house.gov/contactform/'),
43 -(400033, 'B000574', 'M', 'Rep. Earl Blumenauer [D, OR-3]', 'Rep.', 'OR', '3', '202-225-4811', '202-225-8941', 'http://blumenauer.house.gov/index.php?option=com_email_form&Itemid=206'),
44 -(400036, 'B000589', 'M', 'Rep. John Boehner [R, OH-8]', 'Rep.', 'OH', '8', '202-225-6205', '202-225-0704', 'http://www.johnboehner.house.gov/Contact/'),
45 -(400038, 'B001244', 'M', 'Rep. Jo Bonner [R, AL-1]', 'Rep.', 'AL', '1', '202-225-4931', '202-225-0562', 'https://forms.house.gov/bonner/webforms/issue_subscribe.html'),
46 -(400039, 'B001228', 'F', 'Rep. Mary Bono Mack [R, CA-45]', 'Rep.', 'CA', '45', '202-225-5330', '202-225-2961', 'http://www.house.gov/formbono/issue.htm'),
47 -(400041, 'B001245', 'F', 'Del. Madeleine Bordallo [D, GU-0]', 'Del.', 'GU', '0', '', '', ''),
48 -(400042, 'B000652', 'M', 'Rep. Leonard Boswell [D, IA-3]', 'Rep.', 'IA', '3', '202-225-3806', '202-225-5608', 'http://boswell.house.gov/messageform.htm'),
49 -(400046, 'B000755', 'M', 'Rep. Kevin Brady [R, TX-8]', 'Rep.', 'TX', '8', '202-225-4901', '202-225-5524', 'http://www.house.gov/brady/contact_page.html'),
50 -(400047, 'B001227', 'M', 'Rep. Robert Brady [D, PA-1]', 'Rep.', 'PA', '1', '202-225-4731', '202-225-0088', 'http://www.house.gov/formrobertbrady/issue.htm'),
51 -(400048, 'B000911', 'F', 'Rep. Corrine Brown [D, FL-3]', 'Rep.', 'FL', '3', '202-225-0123', '202-225-2256', 'http://www.house.gov/corrinebrown/IMA/issue.shtml'),
52 -(400052, 'B001248', 'M', 'Rep. Michael Burgess [R, TX-26]', 'Rep.', 'TX', '26', '202-225-7772', '202-225-2919', 'https://forms.house.gov/wyr/welcome.shtml'),
53 -(400055, 'B001149', 'M', 'Rep. Dan Burton [R, IN-5]', 'Rep.', 'IN', '5', '202-225-2276', '202-225-0016', 'http://burton.house.gov/contacts/new'),
54 -(400057, 'C000059', 'M', 'Rep. Ken Calvert [R, CA-44]', 'Rep.', 'CA', '44', '202-225-1986', '202-225-2004', 'http://calvert.house.gov/awenhnjafe.asp'),
55 -(400058, 'C000071', 'M', 'Rep. David Camp [R, MI-4]', 'Rep.', 'MI', '4', '202-225-3561', '202-225-9679', 'http://camp.house.gov/WriteRep.aspx'),
56 -(400060, 'C001046', 'M', 'Rep. Eric Cantor [R, VA-7]', 'Rep.', 'VA', '7', '202-225-2815', '202-225-0011', 'https://writerep.house.gov/writerep/welcome.shtml'),
57 -(400061, 'C001047', 'F', 'Rep. Shelley Capito [R, WV-2]', 'Rep.', 'WV', '2', '202-225-2711', '202-225-7856', 'https://forms.house.gov/wyr/welcome.shtml'),
58 -(400062, 'C001036', 'F', 'Rep. Lois Capps [D, CA-23]', 'Rep.', 'CA', '23', '202-225-3601', '202-225-5632', 'http://www.house.gov/capps/contact/send_an_email.shtml'),
59 -(400063, 'C001037', 'M', 'Rep. Michael Capuano [D, MA-8]', 'Rep.', 'MA', '8', '202-225-5111', '202-225-9322', 'http://www.house.gov/capuano/contact/email.shtml'),
60 -(400065, 'C001050', 'M', 'Rep. Dennis Cardoza [D, CA-18]', 'Rep.', 'CA', '18', '202-225-6131', '202-225-0819', 'https://forms.house.gov/wyr/welcome.shtml'),
61 -(400068, 'C001051', 'M', 'Rep. John Carter [R, TX-31]', 'Rep.', 'TX', '31', '202-225-3864', '202-225-5886', 'https://forms.house.gov/wyr/welcome.shtml'),
62 -(400071, 'C000266', 'M', 'Rep. Steven Chabot [R, OH-1]', 'Rep.', 'OH', '1', '202-225-2216', '202-225-3012', ''),
63 -(400073, 'C000380', 'F', 'Del. Donna Christensen [D, VI-0]', 'Del.', 'VI', '0', '', '', ''),
64 -(400074, 'C001049', 'M', 'Rep. William Clay [D, MO-1]', 'Rep.', 'MO', '1', '202-225-2406', '202-226-3717', 'http://lacyclay.house.gov/contact.htm'),
65 -(400075, 'C000537', 'M', 'Rep. James Clyburn [D, SC-6]', 'Rep.', 'SC', '6', '202-225-3315', '202-225-2313', 'http://clyburn.house.gov/contact.cfm'),
66 -(400076, 'C000556', 'M', 'Rep. Howard Coble [R, NC-6]', 'Rep.', 'NC', '6', '202-225-3065', '202-225-8611', 'http://www.house.gov/writerep'),
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'),
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'),
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'),
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'),
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'),
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'),
73 -(400089, 'C001048', 'M', 'Rep. John Culberson [R, TX-7]', 'Rep.', 'TX', '7', '202-225-2571', '202-225-4381', 'http://www.culberson.house.gov/contactinfo.aspx'),
74 -(400090, 'C000984', 'M', 'Rep. Elijah Cummings [D, MD-7]', 'Rep.', 'MD', '7', '202-225-4741', '202-225-3178', 'https://forms.house.gov/wyr/welcome.shtml'),
75 -(400093, 'D000096', 'M', 'Rep. Danny Davis [D, IL-7]', 'Rep.', 'IL', '7', '202-225-5006', '202-225-5641', 'https://forms.house.gov/davis/webforms/issue_subscribe.htm'),
76 -(400097, 'D000598', 'F', 'Rep. Susan Davis [D, CA-53]', 'Rep.', 'CA', '53', '202-225-2040', '202-225-2948', 'http://www.house.gov/susandavis/contact.shtml'),
77 -(400100, 'D000191', 'M', 'Rep. Peter DeFazio [D, OR-4]', 'Rep.', 'OR', '4', '202-225-6416', '202-225-0032', 'http://www.house.gov/formdefazio/contact.html'),
78 -(400101, 'D000197', 'F', 'Rep. Diana DeGette [D, CO-1]', 'Rep.', 'CO', '1', '202-225-4431', '202-225-5657', 'http://www.house.gov/formdegette/zip_auth.htm'),
79 -(400103, 'D000216', 'F', 'Rep. Rosa DeLauro [D, CT-3]', 'Rep.', 'CT', '3', '202-225-3661', '202-225-4890', 'http://delauro.house.gov/contact_form_email.cfm'),
80 -(400108, 'D000600', 'M', 'Rep. Mario Diaz-Balart [R, FL-21]', 'Rep.', 'FL', '21', '202-225-4211', '202-225-8576', 'Http://mariodiaz-balart.house.gov//index.cfm?sectionid=11'),
81 -(400109, 'D000327', 'M', 'Rep. Norman Dicks [D, WA-6]', 'Rep.', 'WA', '6', '202-225-5916', '202-226-1176', 'http://www.house.gov/dicks/email.shtml'),
82 -(400110, 'D000355', 'M', 'Rep. John Dingell [D, MI-15]', 'Rep.', 'MI', '15', '202-225-4071', '202-226-0371', 'https://forms.house.gov/wyr/welcome.shtml'),
83 -(400111, 'D000399', 'M', 'Rep. Lloyd Doggett [D, TX-25]', 'Rep.', 'TX', '25', '202-225-4865', '202-225-3073', 'http://www.house.gov/doggett/doggett_ima/doggett_get_address.shtml'),
84 -(400114, 'D000482', 'M', 'Rep. Michael Doyle [D, PA-14]', 'Rep.', 'PA', '14', '202-225-2135', '202-225-3084', 'http://www.house.gov/doyle/email_mike.shtml'),
85 -(400115, 'D000492', 'M', 'Rep. David Dreier [R, CA-26]', 'Rep.', 'CA', '26', '202-225-2305', '202-225-7018', 'http://doyle.house.gov/email_mike.shtml'),
86 -(400116, 'D000533', 'M', 'Rep. John Duncan [R, TN-2]', 'Rep.', 'TN', '2', '202-225-5435', '202-225-6440', 'http://www.house.gov/duncan/contactform_zipcheck.shtml'),
87 -(400121, 'E000172', 'F', 'Rep. Jo Ann Emerson [R, MO-8]', 'Rep.', 'MO', '8', '202-225-4404', '202-226-0326', 'http://www.house.gov/emerson/contact/'),
88 -(400122, 'E000179', 'M', 'Rep. Eliot Engel [D, NY-17]', 'Rep.', 'NY', '17', '202-225-2464', '202-225-5513', 'http://www.house.gov/writerep'),
89 -(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'),
90 -(400128, 'F000010', 'M', 'Del. Eni Faleomavaega [D, AS-0]', 'Del.', 'AS', '0', '', '', ''),
91 -(400129, 'F000030', 'M', 'Rep. Sam Farr [D, CA-17]', 'Rep.', 'CA', '17', '202-225-2861', '202-225-6791', 'http://www.farr.house.gov/index.php?option=com_content&task=view&id=202'),
92 -(400130, 'F000043', 'M', 'Rep. Chaka Fattah [D, PA-2]', 'Rep.', 'PA', '2', '202-225-4001', '202-225-5392', 'http://fattah.house.gov/?sectionid=8&sectiontree=8'),
93 -(400133, 'F000116', 'M', 'Rep. Bob Filner [D, CA-51]', 'Rep.', 'CA', '51', '202-225-8045', '202-225-9073', 'http://www.house.gov/writerep'),
94 -(400134, 'F000444', 'M', 'Rep. Jeff Flake [R, AZ-6]', 'Rep.', 'AZ', '6', '202-225-2635', '202-226-4386', 'http://www.house.gov/writerep'),
95 -(400137, 'F000445', 'M', 'Rep. Randy Forbes [R, VA-4]', 'Rep.', 'VA', '4', '202-225-6365', '202-226-1170', 'http://forbes.house.gov/zipauth.html'),
96 -(400140, 'F000339', 'M', 'Rep. Barney Frank [D, MA-4]', 'Rep.', 'MA', '4', '202-225-5931', '202-225-0182', 'http://www.house.gov/writerep'),
97 -(400141, 'F000448', 'M', 'Rep. Trent Franks [R, AZ-2]', 'Rep.', 'AZ', '2', '202-225-4576', '202-225-6328', 'https://forms.house.gov/franks/email_zipcheck.shtml'),
98 -(400142, 'F000372', 'M', 'Rep. Rodney Frelinghuysen [R, NJ-11]', 'Rep.', 'NJ', '11', '202-225-5034', '202-225-3186', 'http://frelinghuysen.house.gov/contactus/form.cfm'),
99 -(400144, 'G000021', 'M', 'Rep. Elton Gallegly [R, CA-24]', 'Rep.', 'CA', '24', '202-225-5811', '202-225-1100', 'http://www.house.gov/writerep'),
100 -(400145, 'G000548', 'M', 'Rep. Scott Garrett [R, NJ-5]', 'Rep.', 'NJ', '5', '202-225-4465', '202-225-9048', 'http://www.house.gov/formgarrett/contact.shtml'),
101 -(400147, 'G000549', 'M', 'Rep. Jim Gerlach [R, PA-6]', 'Rep.', 'PA', '6', '202-225-4315', '202-225-8440', 'http://www.house.gov/writerep'),
102 -(400151, 'G000550', 'M', 'Rep. John Gingrey [R, GA-11]', 'Rep.', 'GA', '11', '202-225-2931', '202-225-2944', 'http://www.house.gov/formgingrey/IMA/issue.htm'),
103 -(400152, 'G000544', 'M', 'Rep. Charles Gonzalez [D, TX-20]', 'Rep.', 'TX', '20', '202-225-3236', '202-225-1915', 'http://www.gonzalez.house.gov/index.php?option=com_content&task=view&id=170'),
104 -(400154, 'G000289', 'M', 'Rep. Robert Goodlatte [R, VA-6]', 'Rep.', 'VA', '6', '202-225-5431', '202-225-9681', 'http://www.house.gov/goodlatte/emailbob.htm'),
105 -(400157, 'G000377', 'F', 'Rep. Kay Granger [R, TX-12]', 'Rep.', 'TX', '12', '202-225-5071', '202-225-5683', 'http://kaygranger.house.gov/?sectionid=46&sectiontree=46'),
106 -(400158, 'G000546', 'M', 'Rep. Samuel Graves [R, MO-6]', 'Rep.', 'MO', '6', '202-225-7041', '202-225-8221', 'http://www.house.gov/graves/contact.shtml'),
107 -(400160, 'G000410', 'M', 'Rep. Raymond Green [D, TX-29]', 'Rep.', 'TX', '29', '202-225-1688', '202-225-9903', 'http://www.house.gov/green/contact'),
108 -(400162, 'G000551', 'M', 'Rep. Raul Grijalva [D, AZ-7]', 'Rep.', 'AZ', '7', '202-225-2435', '202-225-1541', 'http://grijalva.house.gov/?sectionid=49&sectiontree=2,49'),
109 -(400163, 'G000535', 'M', 'Rep. Luis Gutiérrez [D, IL-4]', 'Rep.', 'IL', '4', '202-225-8203', '202-225-7810', 'http://www.house.gov/writerep'),
110 -(400165, 'H000067', 'M', 'Rep. Ralph Hall [R, TX-4]', 'Rep.', 'TX', '4', '202-225-6673', '202-225-3332', 'http://www.house.gov/ralphhall/IMA/zipauth.htm'),
111 -(400170, 'H000324', 'M', 'Rep. Alcee Hastings [D, FL-23]', 'Rep.', 'FL', '23', '202-225-1313', '202-225-1171', 'http://www.alceehastings.house.gov/index.php?option=com_content&task=view&id=104&Itemid='),
112 -(400171, 'H000329', 'M', 'Rep. Doc Hastings [R, WA-4]', 'Rep.', 'WA', '4', '202-225-5816', '202-225-3251', 'http://hastings.house.gov/ContactForm.aspx'),
113 -(400175, 'H001036', 'M', 'Rep. Jeb Hensarling [R, TX-5]', 'Rep.', 'TX', '5', '202-225-3484', '202-226-4888', 'http://www.house.gov/hensarling/contact_web.shtml'),
114 -(400176, 'H000528', 'M', 'Rep. Walter Herger [R, CA-2]', 'Rep.', 'CA', '2', '202-225-3076', '202-225-1740', 'http://www.house.gov/herger/contact.shtml'),
115 -(400178, 'H000627', 'M', 'Rep. Maurice Hinchey [D, NY-22]', 'Rep.', 'NY', '22', '202-225-6335', '202-226-0774', 'http://www.house.gov/hinchey/contact/zipauth.shtml'),
116 -(400179, 'H000636', 'M', 'Rep. Rubén Hinojosa [D, TX-15]', 'Rep.', 'TX', '15', '202-225-2531', '202-225-5688', 'http://www.house.gov/writerep'),
117 -(400183, 'H000712', 'M', 'Rep. Tim Holden [D, PA-17]', 'Rep.', 'PA', '17', '202-225-5546', '202-226-0996', 'http://www.holden.house.gov/contactform_zipcheck.shtml'),
118 -(400184, 'H001032', 'M', 'Rep. Rush Holt [D, NJ-12]', 'Rep.', 'NJ', '12', '202-225-5801', '202-225-6025', 'http://www.holt.house.gov/contact.shtml'),
119 -(400185, 'H001034', 'M', 'Rep. Michael Honda [D, CA-15]', 'Rep.', 'CA', '15', '202-225-2631', '202-225-2699', 'http://honda.house.gov/contactmike.shtml'),
120 -(400189, 'H000874', 'M', 'Rep. Steny Hoyer [D, MD-5]', 'Rep.', 'MD', '5', '202-225-4131', '202-225-4300', 'http://hoyer.house.gov/contact/email.asp'),
121 -(400193, 'I000026', 'M', 'Rep. Jay Inslee [D, WA-1]', 'Rep.', 'WA', '1', '202-225-6311', '202-226-1606', 'http://www.house.gov/inslee/contact/email.html'),
122 -(400195, 'I000057', 'M', 'Rep. Steve Israel [D, NY-2]', 'Rep.', 'NY', '2', '202-225-3335', '202-225-4669', 'http://www.house.gov/formisrael/contact.html'),
123 -(400196, 'I000056', 'M', 'Rep. Darrell Issa [R, CA-49]', 'Rep.', 'CA', '49', '202-225-3906', '202-225-3303', 'http://issa.house.gov/index.cfm?FuseAction=Contact.ContactForm'),
124 -(400198, 'J000283', 'M', 'Rep. Jesse Jackson [D, IL-2]', 'Rep.', 'IL', '2', '202-225-0773', '202-225-0899', 'http://www.house.gov/jackson/ContactByEMail.shtml'),
125 -(400199, 'J000032', 'F', 'Rep. Sheila Jackson-Lee [D, TX-18]', 'Rep.', 'TX', '18', '202-225-3816', '202-225-3317', 'http://www.jacksonlee.house.gov/contact-form.shtml'),
126 -(400204, 'J000126', 'F', 'Rep. Eddie Johnson [D, TX-30]', 'Rep.', 'TX', '30', '202-225-8885', '202-226-1477', 'http://www.house.gov/ebjohnson/IMA/issue_subscribe.shtml'),
127 -(400206, 'J000174', 'M', 'Rep. Samuel Johnson [R, TX-3]', 'Rep.', 'TX', '3', '202-225-4201', '202-225-1485', 'http://www.house.gov/formsamjohnson/IMA/issue.htm'),
128 -(400207, 'J000285', 'M', 'Rep. Timothy Johnson [R, IL-15]', 'Rep.', 'IL', '15', '202-225-2371', '202-226-0791', 'http://www.house.gov/timjohnson/contact/index.shtml'),
129 -(400209, 'J000255', 'M', 'Rep. Walter Jones [R, NC-3]', 'Rep.', 'NC', '3', '202-225-3415', '202-225-3286', 'http://jones.house.gov/contact_form_email.cfm'),
130 -(400211, 'K000009', 'F', 'Rep. Marcy Kaptur [D, OH-9]', 'Rep.', 'OH', '9', '202-225-4146', '202-225-7711', 'http://www.kaptur.house.gov/index.php?option=com_content&task=view&id=152'),
131 -(400216, 'K000172', 'M', 'Rep. Dale Kildee [D, MI-5]', 'Rep.', 'MI', '5', '202-225-3611', '202-225-6393', 'http://www.house.gov/writerep'),
132 -(400218, 'K000188', 'M', 'Rep. Ronald Kind [D, WI-3]', 'Rep.', 'WI', '3', '202-225-5506', '202-225-5739', 'http://www.house.gov/kind/contact.shtml'),
133 -(400219, 'K000210', 'M', 'Rep. Peter King [R, NY-3]', 'Rep.', 'NY', '3', '202-225-7896', '202-226-2279', 'http://peteking.house.gov/zip.shtml'),
134 -(400220, 'K000362', 'M', 'Rep. Steve King [R, IA-5]', 'Rep.', 'IA', '5', '202-225-4426', '202-225-3193', 'http://www.house.gov/steveking/email.shtm'),
135 -(400221, 'K000220', 'M', 'Rep. Jack Kingston [R, GA-1]', 'Rep.', 'GA', '1', '202-225-5831', '202-226-2269', 'http://kingston.house.gov/ContactForm/'),
136 -(400224, 'K000363', 'M', 'Rep. John Kline [R, MN-2]', 'Rep.', 'MN', '2', '202-225-2271', '202-225-2595', 'http://kline.house.gov/index.cfm?FuseAction=ContactInformation.ContactForm&To=mn02hwyr@housemail.house.gov&CFID=22307054&CFTOKEN=28173710'),
137 -(400227, 'K000336', 'M', 'Rep. Dennis Kucinich [D, OH-10]', 'Rep.', 'OH', '10', '202-225-5871', '202-225-5745', 'http://kucinich.house.gov/Contact/Starter.htm'),
138 -(400230, 'L000559', 'M', 'Rep. James Langevin [D, RI-2]', 'Rep.', 'RI', '2', '202-225-2735', '202-225-5976', 'http://langevin.house.gov/comments.shtml'),
139 -(400232, 'L000560', 'M', 'Rep. Rick Larsen [D, WA-2]', 'Rep.', 'WA', '2', '202-225-2605', '202-225-4420', 'http://www.house.gov/larsen/contact/'),
140 -(400233, 'L000557', 'M', 'Rep. John Larson [D, CT-1]', 'Rep.', 'CT', '1', '202-225-2265', '202-225-1031', 'http://www.house.gov/writerep'),
141 -(400234, 'L000111', 'M', 'Rep. Thomas Latham [R, IA-4]', 'Rep.', 'IA', '4', '202-225-5476', '202-225-3301', 'http://www.tomlatham.house.gov/Contact/'),
142 -(400235, 'L000553', 'M', 'Rep. Steven LaTourette [R, OH-14]', 'Rep.', 'OH', '14', '202-225-5731', '202-225-3307', 'http://latourette.house.gov/ContactSteve.aspx'),
143 -(400237, 'L000551', 'F', 'Rep. Barbara Lee [D, CA-9]', 'Rep.', 'CA', '9', '202-225-2661', '202-225-9817', 'http://lee.house.gov/?sectionid=44&sectiontree=18,44'),
144 -(400238, 'L000263', 'M', 'Rep. Sander Levin [D, MI-12]', 'Rep.', 'MI', '12', '202-225-4961', '202-226-1033', 'http://www.house.gov/levin/levin_contact_email.shtml'),
145 -(400239, 'L000274', 'M', 'Rep. Jerry Lewis [R, CA-41]', 'Rep.', 'CA', '41', '202-225-5861', '202-225-6498', 'http://www.house.gov/jerrylewis/IMA/WritetoRepresentativeLewis.htm'),
146 -(400240, 'L000287', 'M', 'Rep. John Lewis [D, GA-5]', 'Rep.', 'GA', '5', '202-225-3801', '202-225-0351', 'http://www.house.gov/formjohnlewis/contact.html'),
147 -(400244, 'L000554', 'M', 'Rep. Frank LoBiondo [R, NJ-2]', 'Rep.', 'NJ', '2', '202-225-6572', '202-225-3318', 'http://www.house.gov/lobiondo/IMA/issue.htm'),
148 -(400245, 'L000397', 'F', 'Rep. Zoe Lofgren [D, CA-16]', 'Rep.', 'CA', '16', '202-225-3072', '202-225-3336', 'http://lofgren.house.gov/emailform.shtml'),
149 -(400246, 'L000480', 'F', 'Rep. Nita Lowey [D, NY-18]', 'Rep.', 'NY', '18', '202-225-6506', '202-225-0546', 'http://lowey.house.gov/?sectionid=56&sectiontree=56'),
150 -(400247, 'L000491', 'M', 'Rep. Frank Lucas [R, OK-3]', 'Rep.', 'OK', '3', '202-225-5565', '202-225-8698', 'http://www.house.gov/lucas/zipauth.htm'),
151 -(400249, 'L000562', 'M', 'Rep. Stephen Lynch [D, MA-9]', 'Rep.', 'MA', '9', '202-225-8273', '202-225-3984', 'http://www.house.gov/writerep'),
152 -(400251, 'M000087', 'F', 'Rep. Carolyn Maloney [D, NY-14]', 'Rep.', 'NY', '14', '202-225-7944', '202-225-4709', 'http://maloney.house.gov/index.php?option=com_email_form&Itemid=73'),
153 -(400252, 'M001138', 'M', 'Rep. Donald Manzullo [R, IL-16]', 'Rep.', 'IL', '16', '202-225-5676', '202-225-5284', 'http://manzullo.house.gov/zipauth.aspx'),
154 -(400253, 'M000133', 'M', 'Rep. Edward Markey [D, MA-7]', 'Rep.', 'MA', '7', '202-225-2836', '202-226-0092', 'http://markey.house.gov/index.php?option=com_email_form&Itemid=124'),
155 -(400255, 'M001142', 'M', 'Rep. Jim Matheson [D, UT-2]', 'Rep.', 'UT', '2', '202-225-3011', '202-225-5638', 'https://forms.house.gov/matheson/contact.shtml'),
156 -(400257, 'M000309', 'F', 'Rep. Carolyn McCarthy [D, NY-4]', 'Rep.', 'NY', '4', '202-225-5516', '202-225-5758', 'http://www.house.gov/writerep'),
157 -(400259, 'M001143', 'F', 'Rep. Betty McCollum [D, MN-4]', 'Rep.', 'MN', '4', '202-225-6631', '202-225-1968', 'http://www.mccollum.house.gov/index.asp?Type=NONE&SEC={AC61FD79-AD5F-440D-A7F0-555B12349E5B}'),
158 -(400260, 'M001147', 'M', 'Rep. Thaddeus McCotter [R, MI-11]', 'Rep.', 'MI', '11', '202-225-8171', '202-225-2667', 'http://mccotter.house.gov/HoR/MI11/Contact/Office+Contact+Information/Zipcode+Authentication+Page.htm'),
159 -(400262, 'M000404', 'M', 'Rep. James McDermott [D, WA-7]', 'Rep.', 'WA', '7', '202-225-3106', '202-225-6197', 'http://www.house.gov/mcdermott/contact.shtml'),
160 -(400263, 'M000312', 'M', 'Rep. James McGovern [D, MA-3]', 'Rep.', 'MA', '3', '202-225-6101', '202-225-5759', 'http://www.house.gov/writerep'),
161 -(400266, 'M000485', 'M', 'Rep. Mike McIntyre [D, NC-7]', 'Rep.', 'NC', '7', '202-225-2731', '202-225-5773', 'http://www.house.gov/mcintyre/IMA/issue.htm'),
162 -(400267, 'M000508', 'M', 'Rep. Howard McKeon [R, CA-25]', 'Rep.', 'CA', '25', '202-225-1956', '202-226-0683', 'http://mckeon.house.gov/contact.shtml'),
163 -(400271, 'M001137', 'M', 'Rep. Gregory Meeks [D, NY-6]', 'Rep.', 'NY', '6', '202-225-3461', '202-226-4169', 'http://www.house.gov/meeks/contactform_zipcheck.shtml'),
164 -(400273, 'M000689', 'M', 'Rep. John Mica [R, FL-7]', 'Rep.', 'FL', '7', '202-225-4035', '202-226-0821', 'http://www.house.gov/mica/messageform.shtml'),
165 -(400274, 'M001149', 'M', 'Rep. Michael Michaud [D, ME-2]', 'Rep.', 'ME', '2', '202-225-6306', '202-225-2943', 'https://forms.house.gov/michaud/webforms/issue_subscribe.htm'),
166 -(400276, 'M001150', 'F', 'Rep. Candice Miller [R, MI-10]', 'Rep.', 'MI', '10', '202-225-2106', '202-226-1169', 'http://candicemiller.house.gov/Contact.aspx'),
167 -(400277, 'M001139', 'M', 'Rep. Gary Miller [R, CA-42]', 'Rep.', 'CA', '42', '202-225-3201', '202-226-6962', 'http://garymiller.house.gov/Contact/'),
168 -(400278, 'M000725', 'M', 'Rep. George Miller [D, CA-7]', 'Rep.', 'CA', '7', '202-225-2095', '202-225-5609', 'http://georgemiller.house.gov/contactus/2007/08/post_1.html'),
169 -(400279, 'M001144', 'M', 'Rep. Jeff Miller [R, FL-1]', 'Rep.', 'FL', '1', '202-225-4136', '202-225-3414', 'http://jeffmiller.house.gov/index.cfm?FuseAction=Contact.Home'),
170 -(400280, 'M001154', 'M', 'Rep. Bradley Miller [D, NC-13]', 'Rep.', 'NC', '13', '202-225-3032', '202-225-0181', 'http://bradmiller.house.gov/?sectionid=17&sectiontree=9,17'),
171 -(400283, 'M000933', 'M', 'Rep. James Moran [D, VA-8]', 'Rep.', 'VA', '8', '202-225-4376', '202-225-0017', 'http://moran.house.gov/zipauth.shtml'),
172 -(400285, 'M001151', 'M', 'Rep. Tim Murphy [R, PA-18]', 'Rep.', 'PA', '18', '202-225-2301', '202-225-1844', 'http://murphy.house.gov/Contact/zipauth.htm'),
173 -(400288, 'M001134', 'F', 'Rep. Sue Myrick [R, NC-9]', 'Rep.', 'NC', '9', '202-225-1976', '202-225-3389', 'http://myrick.house.gov/zipauth.shtml'),
174 -(400289, 'N000002', 'M', 'Rep. Jerrold Nadler [D, NY-8]', 'Rep.', 'NY', '8', '202-225-5635', '202-225-6923', 'http://www.house.gov/nadler/emailform.shtml'),
175 -(400290, 'N000179', 'F', 'Rep. Grace Napolitano [D, CA-38]', 'Rep.', 'CA', '38', '202-225-5256', '202-225-0027', 'http://www.napolitano.house.gov/contact/feedback.htm'),
176 -(400291, 'N000015', 'M', 'Rep. Richard Neal [D, MA-2]', 'Rep.', 'MA', '2', '202-225-5601', '202-225-8112', 'http://www.house.gov/neal/write_neal.html'),
177 -(400295, 'N000147', 'F', 'Del. Eleanor Norton [D, DC-0]', 'Del.', 'DC', '0', '202-225-8050', '202-225-3002', ''),
178 -(400297, 'N000181', 'M', 'Rep. Devin Nunes [R, CA-21]', 'Rep.', 'CA', '21', '202-225-2523', '202-225-3404', 'http://www.nunes.house.gov/index.cfm?FuseAction=ContactUs.ContactForm'),
179 -(400301, 'O000085', 'M', 'Rep. John Olver [D, MA-1]', 'Rep.', 'MA', '1', '202-225-5335', '202-226-1224', 'http://www.house.gov/olver/contactme.html'),
180 -(400308, 'P000034', 'M', 'Rep. Frank Pallone [D, NJ-6]', 'Rep.', 'NJ', '6', '202-225-4671', '202-225-9665', 'http://www.house.gov/pallone/contact.shtml'),
181 -(400309, 'P000096', 'M', 'Rep. William Pascrell [D, NJ-8]', 'Rep.', 'NJ', '8', '202-225-5751', '202-225-5782', 'http://pascrell.house.gov/contact/'),
182 -(400310, 'P000099', 'M', 'Rep. Edward Pastor [D, AZ-4]', 'Rep.', 'AZ', '4', '202-225-4065', '202-225-1655', 'http://www.house.gov/writerep'),
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'),
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'),
185 -(400313, 'P000588', 'M', 'Rep. Steven Pearce [R, NM-2]', 'Rep.', 'NM', '2', '202-225-2365', '', ''),
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'),
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'),
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'),
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'),
190 -(400320, 'P000373', 'M', 'Rep. Joseph Pitts [R, PA-16]', 'Rep.', 'PA', '16', '202-225-2411', '202-225-2013', 'http://www.house.gov/pitts/contact.shtml'),
191 -(400321, 'P000585', 'M', 'Rep. Todd Platts [R, PA-19]', 'Rep.', 'PA', '19', '202-225-5836', '202-226-1000', 'http://www.house.gov/platts/email.shtml'),
192 -(400326, 'P000523', 'M', 'Rep. David Price [D, NC-4]', 'Rep.', 'NC', '4', '202-225-1784', '202-225-2014', 'http://price.house.gov/contact/contact_form.shtml'),
193 -(400331, 'R000011', 'M', 'Rep. Nick Rahall [D, WV-3]', 'Rep.', 'WV', '3', '202-225-3452', '202-225-9061', 'http://www.rahall.house.gov/?sectionid=9&sectiontree=9'),
194 -(400333, 'R000053', 'M', 'Rep. Charles Rangel [D, NY-15]', 'Rep.', 'NY', '15', '202-225-4365', '202-225-0816', 'https://forms.house.gov/rangel/forms/contact.shtml'),
195 -(400335, 'R000571', 'M', 'Rep. Dennis Rehberg [R, MT-0]', 'Rep.', 'MT', '0', '202-225-3211', '202-225-5687', 'http://www.house.gov/rehberg/issue.shtml'),
196 -(400337, 'R000170', 'M', 'Rep. Silvestre Reyes [D, TX-16]', 'Rep.', 'TX', '16', '202-225-4831', '202-225-2016', 'http://wwwc.house.gov/reyes/voice_your_opinion.asp'),
197 -(400340, 'R000395', 'M', 'Rep. Harold Rogers [R, KY-5]', 'Rep.', 'KY', '5', '202-225-4601', '202-225-0940', 'http://halrogers.house.gov/Contact.aspx'),
198 -(400341, 'R000575', 'M', 'Rep. Michael Rogers [R, AL-3]', 'Rep.', 'AL', '3', '202-225-3261', '202-226-8485', 'http://www.house.gov/mike-rogers/contact.shtml'),
199 -(400342, 'R000572', 'M', 'Rep. Michael Rogers [R, MI-8]', 'Rep.', 'MI', '8', '202-225-4872', '202-225-5820', 'http://www.mikerogers.house.gov/Contact.aspx'),
200 -(400343, 'R000409', 'M', 'Rep. Dana Rohrabacher [R, CA-46]', 'Rep.', 'CA', '46', '202-225-2415', '202-225-0145', 'http://rohrabacher.house.gov/Contact/Zip.htm'),
201 -(400344, 'R000435', 'F', 'Rep. Ileana Ros-Lehtinen [R, FL-18]', 'Rep.', 'FL', '18', '202-225-3931', '202-225-5620', 'http://www.house.gov/writerep'),
202 -(400345, 'R000573', 'M', 'Rep. Mike Ross [D, AR-4]', 'Rep.', 'AR', '4', '202-225-3772', '202-225-1314', 'http://ross.house.gov/?sectionid=77&sectiontree=76,77'),
203 -(400346, 'R000462', 'M', 'Rep. Steven Rothman [D, NJ-9]', 'Rep.', 'NJ', '9', '202-225-5061', '202-225-5851', 'https://forms.house.gov/rothman/webforms/issue_subscribe.htm'),
204 -(400347, 'R000486', 'F', 'Rep. Lucille Roybal-Allard [D, CA-34]', 'Rep.', 'CA', '34', '202-225-1766', '202-226-0350', 'http://www.house.gov/writerep'),
205 -(400348, 'R000487', 'M', 'Rep. Edward Royce [R, CA-40]', 'Rep.', 'CA', '40', '202-225-4111', '202-226-0335', 'http://www.house.gov/writerep'),
206 -(400349, 'R000576', 'M', 'Rep. Dutch Ruppersberger [D, MD-2]', 'Rep.', 'MD', '2', '202-225-3061', '202-225-3094', 'http://dutch.house.gov/writedutch_za.shtml'),
207 -(400350, 'R000515', 'M', 'Rep. Bobby Rush [D, IL-1]', 'Rep.', 'IL', '1', '202-225-4372', '202-226-0333', 'http://www.house.gov/rush/zipauth.shtml'),
208 -(400351, 'R000570', 'M', 'Rep. Paul Ryan [R, WI-1]', 'Rep.', 'WI', '1', '202-225-3031', '202-225-3393', 'http://www.house.gov/ryan/email.htm'),
209 -(400352, 'R000577', 'M', 'Rep. Timothy Ryan [D, OH-17]', 'Rep.', 'OH', '17', '202-225-5261', '202-225-3719', 'http://timryan.house.gov/index.php?option=com_content&task=view&id=129&Itemid=42'),
210 -(400355, 'S001156', 'F', 'Rep. Linda Sánchez [D, CA-39]', 'Rep.', 'CA', '39', '202-225-6676', '202-226-1012', 'http://www.house.gov/writerep'),
211 -(400356, 'S000030', 'F', 'Rep. Loretta Sanchez [D, CA-47]', 'Rep.', 'CA', '47', '202-225-2965', '202-225-5859', 'http://www.lorettasanchez.house.gov/index.php?option=com_content&task=view&id=218&Itemid=17'),
212 -(400360, 'S001145', 'F', 'Rep. Janice Schakowsky [D, IL-9]', 'Rep.', 'IL', '9', '202-225-2111', '202-226-6890', 'http://www.house.gov/schakowsky/contact.shtml'),
213 -(400361, 'S001150', 'M', 'Rep. Adam Schiff [D, CA-29]', 'Rep.', 'CA', '29', '202-225-4176', '202-225-5828', 'http://schiff.house.gov/HoR/CA29/Contact+Information/Contact+Form.htm'),
214 -(400363, 'S001157', 'M', 'Rep. David Scott [D, GA-13]', 'Rep.', 'GA', '13', '202-225-2939', '202-225-4628', 'http://www.house.gov/writerep'),
215 -(400364, 'S000185', 'M', 'Rep. Robert Scott [D, VA-3]', 'Rep.', 'VA', '3', '202-225-8351', '202-225-8354', 'http://www.house.gov/writerep'),
216 -(400365, 'S000244', 'M', 'Rep. James Sensenbrenner [R, WI-5]', 'Rep.', 'WI', '5', '202-225-5101', '202-225-3190', 'http://sensenbrenner.house.gov/email_zip.htm'),
217 -(400366, 'S000248', 'M', 'Rep. José Serrano [D, NY-16]', 'Rep.', 'NY', '16', '202-225-4361', '202-225-6001', 'http://serrano.house.gov/Forms/Contact.aspx'),
218 -(400367, 'S000250', 'M', 'Rep. Peter Sessions [R, TX-32]', 'Rep.', 'TX', '32', '202-225-2231', '202-225-5878', 'http://www.house.gov/sessionsform/emailform.htm'),
219 -(400371, 'S000344', 'M', 'Rep. Brad Sherman [D, CA-27]', 'Rep.', 'CA', '27', '202-225-5911', '202-225-5879', 'http://www.house.gov/sherman/contact/'),
220 -(400373, 'S000364', 'M', 'Rep. John Shimkus [R, IL-19]', 'Rep.', 'IL', '19', '202-225-5271', '202-225-5880', 'http://www.house.gov/shimkus/emailme.shtml'),
221 -(400376, 'S001148', 'M', 'Rep. Michael Simpson [R, ID-2]', 'Rep.', 'ID', '2', '202-225-5531', '202-225-8216', 'http://www.house.gov/simpson/emailme.shtml'),
222 -(400378, 'S000480', 'F', 'Rep. Louise Slaughter [D, NY-28]', 'Rep.', 'NY', '28', '202-225-3615', '202-225-7822', 'http://www.louise.house.gov/index.php?option=com_content&task=view&id=506&Itemid=150'),
223 -(400379, 'S000510', 'M', 'Rep. Adam Smith [D, WA-9]', 'Rep.', 'WA', '9', '202-225-8901', '202-225-5893', 'http://adamsmith.house.gov/Contact/'),
224 -(400380, 'S000522', 'M', 'Rep. Christopher Smith [R, NJ-4]', 'Rep.', 'NJ', '4', '202-225-3765', '202-225-7768', 'http://chrissmith.house.gov/zipauth.html'),
225 -(400381, 'S000583', 'M', 'Rep. Lamar Smith [R, TX-21]', 'Rep.', 'TX', '21', '202-225-4236', '202-225-8628', 'http://lamarsmith.house.gov/contact.aspx?section=Mail'),
226 -(400387, 'S000810', 'M', 'Rep. Fortney Stark [D, CA-13]', 'Rep.', 'CA', '13', '202-225-5065', '202-226-3805', 'http://www.house.gov/stark/contact/index.htm'),
227 -(400388, 'S000822', 'M', 'Rep. Clifford Stearns [R, FL-6]', 'Rep.', 'FL', '6', '202-225-5744', '202-225-3973', 'http://www.house.gov/writerep'),
228 -(400392, 'S001155', 'M', 'Rep. John Sullivan [R, OK-1]', 'Rep.', 'OK', '1', '202-225-2211', '202-225-9187', 'http://sullivan.house.gov/zipauth.html'),
229 -(400400, 'T000459', 'M', 'Rep. Lee Terry [R, NE-2]', 'Rep.', 'NE', '2', '202-225-4155', '202-226-5452', 'http://www.house.gov/formleeterry/IMA/issue.htm'),
230 -(400402, 'T000193', 'M', 'Rep. Bennie Thompson [D, MS-2]', 'Rep.', 'MS', '2', '202-225-5876', '202-225-5898', 'https://forms.house.gov/benniethompson/contact-form.shtml'),
231 -(400403, 'T000460', 'M', 'Rep. Michael Thompson [D, CA-1]', 'Rep.', 'CA', '1', '202-225-3311', '202-225-4335', 'http://mikethompson.house.gov/contact/email.shtml'),
232 -(400404, 'T000238', 'M', 'Rep. William Thornberry [R, TX-13]', 'Rep.', 'TX', '13', '202-225-3706', '202-225-3486', 'http://www.house.gov/writerep'),
233 -(400406, 'T000462', 'M', 'Rep. Patrick Tiberi [R, OH-12]', 'Rep.', 'OH', '12', '202-225-5355', '202-226-4523', 'http://www.house.gov/writerep'),
234 -(400407, 'T000266', 'M', 'Rep. John Tierney [D, MA-6]', 'Rep.', 'MA', '6', '202-225-8020', '202-225-5915', 'http://www.house.gov/tierney/IMA/email.shtml'),
235 -(400409, 'T000326', 'M', 'Rep. Edolphus Towns [D, NY-10]', 'Rep.', 'NY', '10', '202-225-5936', '202-225-1018', 'http://www.house.gov/towns/contact_form_zipcheck.shtml'),
236 -(400411, 'T000463', 'M', 'Rep. Michael Turner [R, OH-3]', 'Rep.', 'OH', '3', '202-225-6465', '202-225-6754', 'http://turner.house.gov/Contact/'),
237 -(400414, 'U000031', 'M', 'Rep. Frederick Upton [R, MI-6]', 'Rep.', 'MI', '6', '202-225-3761', '202-225-4986', 'http://www.house.gov/writerep'),
238 -(400415, 'V000128', 'M', 'Rep. Christopher Van Hollen [D, MD-8]', 'Rep.', 'MD', '8', '202-225-5341', '202-225-0375', 'http://vanhollen.house.gov/HoR/MD08/Contact+Information/Web+Contact/Contact+Form.htm'),
239 -(400416, 'V000081', 'F', 'Rep. Nydia Velázquez [D, NY-12]', 'Rep.', 'NY', '12', '202-225-2361', '202-226-0327', 'http://www.house.gov/velazquez/IMA/issue_subscribe.htm'),
240 -(400417, 'V000108', 'M', 'Rep. Peter Visclosky [D, IN-1]', 'Rep.', 'IN', '1', '202-225-2461', '202-225-2493', 'http://www.house.gov/writerep'),
241 -(400419, 'W000791', 'M', 'Rep. Greg Walden [R, OR-2]', 'Rep.', 'OR', '2', '202-225-6730', '202-225-5774', 'http://www.walden.house.gov/ContactGreg.ContactFormIQ.shtml'),
242 -(400422, 'W000187', 'F', 'Rep. Maxine Waters [D, CA-35]', 'Rep.', 'CA', '35', '202-225-2201', '202-225-7854', 'http://www.house.gov/waters/IMA/issue.htm'),
243 -(400424, 'W000207', 'M', 'Rep. Melvin Watt [D, NC-12]', 'Rep.', 'NC', '12', '202-225-1510', '202-225-1512', 'http://www.house.gov/formwatt/IMA/issue_subscribe.htm'),
244 -(400425, 'W000215', 'M', 'Rep. Henry Waxman [D, CA-30]', 'Rep.', 'CA', '30', '202-225-3976', '202-225-4099', 'http://waxman.house.gov/Contact/'),
245 -(400431, 'W000413', 'M', 'Rep. Edward Whitfield [R, KY-1]', 'Rep.', 'KY', '1', '202-225-3115', '202-225-3547', 'http://whitfield.house.gov/contact/index.shtml'),
246 -(400433, 'W000795', 'M', 'Rep. Addison Wilson [R, SC-2]', 'Rep.', 'SC', '2', '202-225-2452', '202-225-2455', 'http://www.house.gov/formwilson/IMA/issue.htm'),
247 -(400435, 'W000672', 'M', 'Rep. Frank Wolf [R, VA-10]', 'Rep.', 'VA', '10', '202-225-5136', '202-225-0437', 'http://www.house.gov/formwolf/contact_email/emailzip.shtml'),
248 -(400436, 'W000738', 'F', 'Rep. Lynn Woolsey [D, CA-6]', 'Rep.', 'CA', '6', '202-225-5161', '202-225-5163', 'http://woolsey.house.gov/contactemailform.asp'),
249 -(400439, 'Y000031', 'M', 'Rep. Bill Young [R, FL-10]', 'Rep.', 'FL', '10', '202-225-5961', '202-225-9764', 'http://www.house.gov/writerep'),
250 -(400440, 'Y000033', 'M', 'Rep. Donald Young [R, AK-0]', 'Rep.', 'AK', '0', '202-225-5765', '202-225-0425', 'http://donyoung.house.gov/Contact/'),
251 -(400441, 'N000182', 'M', 'Rep. Randy Neugebauer [R, TX-19]', 'Rep.', 'TX', '19', '202-225-4005', '202-225-9615', 'http://www.randy.house.gov/?sectionid=65&sectiontree=8,65'),
252 -(400442, 'C001058', 'M', 'Rep. Ben Chandler [D, KY-6]', 'Rep.', 'KY', '6', '202-225-4706', '202-225-2122', 'https://forms.house.gov/wyr/welcome.shtml'),
253 -(400570, 'B000461', 'M', 'Rep. Brian Bilbray [R, CA-50]', 'Rep.', 'CA', '50', '202-225-0508', '202-225-2558', 'http://www.house.gov/bilbray/contact.shtml'),
254 -(400616, 'B001251', 'M', 'Rep. George Butterfield [D, NC-1]', 'Rep.', 'NC', '1', '202-225-3101', '202-225-3354', 'http://butterfield.house.gov/contactinfo.asp'),
255 -(400617, 'L000517', 'M', 'Rep. Daniel Lungren [R, CA-3]', 'Rep.', 'CA', '3', '202-225-5716', '202-226-1298', 'https://forms.house.gov/lungren/forms/email.shtml'),
256 -(400618, 'C001059', 'M', 'Rep. Jim Costa [D, CA-20]', 'Rep.', 'CA', '20', '202-225-3341', '202-225-9308', 'http://www.house.gov/formcosta/issue.htm'),
257 -(400622, 'M001155', 'M', 'Rep. Connie Mack [R, FL-14]', 'Rep.', 'FL', '14', '202-225-2536', '202-226-0439', 'http://mack.house.gov/index.cfm?FuseAction=ContactConnie.ContactForm'),
258 -(400623, 'W000797', 'F', 'Rep. Debbie Wasserman Schultz [D, FL-20]', 'Rep.', 'FL', '20', '202-225-7931', '202-225-2052', 'http://wassermanschultz.house.gov/zipauth.htm'),
259 -(400626, 'P000591', 'M', 'Rep. Tom Price [R, GA-6]', 'Rep.', 'GA', '6', '202-225-4501', '202-225-4656', 'http://tom.house.gov/html/contact_form_email.cfm'),
260 -(400627, 'W000796', 'M', 'Rep. Lynn Westmoreland [R, GA-3]', 'Rep.', 'GA', '3', '202-225-5901', '202-225-2515', 'http://www.house.gov/writerep'),
261 -(400628, 'B001252', 'M', 'Rep. John Barrow [D, GA-12]', 'Rep.', 'GA', '12', '202-225-2823', '202-225-3377', 'https://forms.house.gov/barrow/webforms/issue_subscribe.htm'),
262 -(400630, 'L000563', 'M', 'Rep. Daniel Lipinski [D, IL-3]', 'Rep.', 'IL', '3', '202-225-5701', '202-225-1012', 'http://www.house.gov/formlipinski/zipauth.html'),
263 -(400633, 'D000603', 'M', 'Rep. Geoff Davis [R, KY-4]', 'Rep.', 'KY', '4', '202-225-3465', '202-225-0003', 'http://geoffdavis.house.gov/Contact.aspx'),
264 -(400636, 'B001255', 'M', 'Rep. Charles Boustany [R, LA-7]', 'Rep.', 'LA', '7', '202-225-2031', '202-225-5724', 'http://boustany.house.gov/ContactCharles.asp'),
265 -(400638, 'C001060', 'M', 'Rep. Russ Carnahan [D, MO-3]', 'Rep.', 'MO', '3', '202-225-2671', '202-225-7452', 'http://carnahan.house.gov/contact.shtml'),
266 -(400639, 'C001061', 'M', 'Rep. Emanuel Cleaver [D, MO-5]', 'Rep.', 'MO', '5', '202-225-4535', '202-225-4403', 'http://www.house.gov/cleaver/IMA/issue.htm'),
267 -(400640, 'F000449', 'M', 'Rep. Jeffrey Fortenberry [R, NE-1]', 'Rep.', 'NE', '1', '202-225-4806', '202-225-5686', 'http://fortenberry.house.gov/contactform_zipcheck.shtml'),
268 -(400641, 'H001038', 'M', 'Rep. Brian Higgins [D, NY-27]', 'Rep.', 'NY', '27', '202-225-3306', '202-226-0347', 'http://higgins.house.gov/email.asp'),
269 -(400643, 'F000450', 'F', 'Rep. Virginia Foxx [R, NC-5]', 'Rep.', 'NC', '5', '202-225-2071', '202-225-2995', 'http://www.house.gov/formfoxx/IMA/issue_subscribe.htm'),
270 -(400644, 'M001156', 'M', 'Rep. Patrick McHenry [R, NC-10]', 'Rep.', 'NC', '10', '202-225-2576', '202-225-0316', 'http://mchenry.house.gov/zipauth.htm'),
271 -(400645, 'B001254', 'M', 'Rep. Dan Boren [D, OK-2]', 'Rep.', 'OK', '2', '202-225-2701', '202-225-3038', 'http://www.house.gov/boren/emailsignup.shtml'),
272 -(400646, 'F000451', 'M', 'Rep. Michael Fitzpatrick [R, PA-8]', 'Rep.', 'PA', '8', '202-225-4276', '202- 225-9511', ''),
273 -(400647, 'S001162', 'F', 'Rep. Allyson Schwartz [D, PA-13]', 'Rep.', 'PA', '13', '202-225-6111', '202-226-0611', 'http://schwartz.house.gov/issue_subscribe.shtml'),
274 -(400648, 'D000604', 'M', 'Rep. Charles Dent [R, PA-15]', 'Rep.', 'PA', '15', '202-225-6411', '202-226-0778', 'http://dent.house.gov/verifyemail.shtml'),
275 -(400651, 'G000552', 'M', 'Rep. Louis Gohmert [R, TX-1]', 'Rep.', 'TX', '1', '202-225-3035', '202-226-1230', 'http://gohmert.house.gov/contact_louie.htm'),
276 -(400652, 'P000592', 'M', 'Rep. Ted Poe [R, TX-2]', 'Rep.', 'TX', '2', '202-225-6565', '202-225-5547', 'http://poe.house.gov/email/'),
277 -(400653, 'G000553', 'M', 'Rep. Al Green [D, TX-9]', 'Rep.', 'TX', '9', '202-225-7508', '202-225-2947', 'http://www.house.gov/writerep'),
278 -(400654, 'M001157', 'M', 'Rep. Michael McCaul [R, TX-10]', 'Rep.', 'TX', '10', '202-225-2401', '202-225-5955', 'http://www.house.gov/writerep'),
279 -(400655, 'C001062', 'M', 'Rep. Michael Conaway [R, TX-11]', 'Rep.', 'TX', '11', '202-225-3605', '202-225-1783', 'http://conaway.house.gov/Contact/default.aspx#email'),
280 -(400656, 'M001158', 'M', 'Rep. Kenny Marchant [R, TX-24]', 'Rep.', 'TX', '24', '202-225-6605', '202-225-0074', 'http://marchant.house.gov/emailkenny.shtml'),
281 -(400657, 'C001063', 'M', 'Rep. Henry Cuellar [D, TX-28]', 'Rep.', 'TX', '28', '202-225-1640', '202-225-1641', 'http://cuellar.house.gov/Contact/SendMeAnEmail.htm'),
282 -(400659, 'M001159', 'F', 'Rep. Cathy McMorris Rodgers [R, WA-5]', 'Rep.', 'WA', '5', '202-225-2006', '202-225-3392', 'http://www.mcmorris.house.gov/IMA/issue_subscribe.htm'),
283 -(400660, 'R000578', 'M', 'Rep. Dave Reichert [R, WA-8]', 'Rep.', 'WA', '8', '202-225-7761', '202-225-4282', 'http://reichert.house.gov/Contact/ZipAuth.htm'),
284 -(400661, 'M001160', 'F', 'Rep. Gwen Moore [D, WI-4]', 'Rep.', 'WI', '4', '202-225-4572', '202-225-8135', 'http://www.house.gov/gwenmoore/contact.shtml'),
285 -(400663, 'M001163', 'F', 'Rep. Doris Matsui [D, CA-5]', 'Rep.', 'CA', '5', '202-225-7163', '202-225-0566', 'https://forms.house.gov/matsui/webforms/issue_subscribe.htm'),
286 -(409888, 'S001154', 'M', 'Rep. William Shuster [R, PA-9]', 'Rep.', 'PA', '9', '202-225-2431', '202-225-2486', 'http://www.house.gov/shuster/zipauth.htm'),
287 -(412010, 'S001164', 'F', 'Rep. Jean Schmidt [R, OH-2]', 'Rep.', 'OH', '2', '202-225-3164', '202-225-1992', 'http://www.house.gov/schmidt/contact.shtml'),
288 -(412011, 'C001064', 'M', 'Rep. John Campbell [R, CA-48]', 'Rep.', 'CA', '48', '202-225-5611', '202-225-9177', 'http://campbell.house.gov/Contact/ContactForm.htm'),
289 -(412186, 'S001165', 'M', 'Rep. Albio Sires [D, NJ-13]', 'Rep.', 'NJ', '13', '202-225-7919', '202-226-0792', 'https://forms.house.gov/sires/webforms/issue_subscribe.htm'),
290 -(412188, 'G000554', 'F', 'Rep. Gabrielle Giffords [D, AZ-8]', 'Rep.', 'AZ', '8', '202-225-2542', '202-225-0378', 'http://giffords.house.gov/contact/mailing-list/'),
291 -(412189, 'M001166', 'M', 'Rep. Jerry McNerney [D, CA-11]', 'Rep.', 'CA', '11', '202-225-1947', '202-225-4060', 'http://mcnerney.house.gov/contact.shtml'),
292 -(412190, 'M001165', 'M', 'Rep. Kevin McCarthy [R, CA-22]', 'Rep.', 'CA', '22', '202-225-2915', '202-225-2908', 'http://kevinmccarthy.house.gov/showpage.asp?ID=69'),
293 -(412191, 'L000564', 'M', 'Rep. Doug Lamborn [R, CO-5]', 'Rep.', 'CO', '5', '202-225-4422', '202-226-2638', 'http://lamborn.house.gov/ZipAuth.aspx'),
294 -(412192, 'P000593', 'M', 'Rep. Ed Perlmutter [D, CO-7]', 'Rep.', 'CO', '7', '202-225-2645', '202-225-5278', 'http://perlmutter.house.gov/IMA/issue_subscribe.htm'),
295 -(412193, 'C001069', 'M', 'Rep. Joe Courtney [D, CT-2]', 'Rep.', 'CT', '2', '202-225-2076', '202-225-4977', 'http://courtney.house.gov/email/'),
296 -(412194, 'M001169', 'M', 'Rep. Christopher Murphy [D, CT-5]', 'Rep.', 'CT', '5', '202-225-4476', '202-225-5933', 'http://www.house.gov/formchrismurphy/ic_zip_auth.htm'),
297 -(412195, 'C001066', 'F', 'Rep. Kathy Castor [D, FL-11]', 'Rep.', 'FL', '11', '202-225-3376', '202-225-5652', 'https://forms.house.gov/wyr/welcome.shtml'),
298 -(412196, 'B001260', 'M', 'Rep. Vern Buchanan [R, FL-13]', 'Rep.', 'FL', '13', '202-225-5015', '202-226-0828', 'http://buchanan.house.gov/contact.shtml'),
299 -(412199, 'J000288', 'M', 'Rep. Henry Johnson [D, GA-4]', 'Rep.', 'GA', '4', '202-225-1605', '202-226-0691', 'http://hankjohnson.house.gov/contact_hank_write.shtml'),
300 -(412200, 'H001042', 'F', 'Rep. Mazie Hirono [D, HI-2]', 'Rep.', 'HI', '2', '202-225-4906', '202-225-4987', 'http://hirono.house.gov/IMA/issue_subscribe.htm'),
301 -(412202, 'R000580', 'M', 'Rep. Peter Roskam [R, IL-6]', 'Rep.', 'IL', '6', '202-225-4561', '202-225-1166', 'http://www.house.gov/writerep'),
302 -(412205, 'D000607', 'M', 'Rep. Joe Donnelly [D, IN-2]', 'Rep.', 'IN', '2', '202-225-3915', '202-225-6798', 'http://donnelly.house.gov/issue_subscribe.shtml'),
303 -(412208, 'B001259', 'M', 'Rep. Bruce Braley [D, IA-1]', 'Rep.', 'IA', '1', '202-225-2911', '202-225-6666', 'https://forms.house.gov/braley/webforms/issue_subscribe.html'),
304 -(412209, 'L000565', 'M', 'Rep. David Loebsack [D, IA-2]', 'Rep.', 'IA', '2', '202-225-6576', '202-226-0757', 'http://loebsack.house.gov/contactform/'),
305 -(412211, 'Y000062', 'M', 'Rep. John Yarmuth [D, KY-3]', 'Rep.', 'KY', '3', '202-225-5401', '202-225-5776', 'http://yarmuth.house.gov/?sectionid=68&sectiontree=6,29,68'),
306 -(412212, 'S001168', 'M', 'Rep. John Sarbanes [D, MD-3]', 'Rep.', 'MD', '3', '202-225-4016', '202-225-9219', 'http://sarbanes.house.gov/federal.asp'),
307 -(412213, 'W000798', 'M', 'Rep. Timothy Walberg [R, MI-7]', 'Rep.', 'MI', '7', '202-225-6276', '202-225-6281', ''),
308 -(412214, 'W000799', 'M', 'Rep. Timothy Walz [D, MN-1]', 'Rep.', 'MN', '1', '202-225-2472', '202-225-3433', 'http://walz.house.gov/zip_auth.shtm'),
309 -(412215, 'E000288', 'M', 'Rep. Keith Ellison [D, MN-5]', 'Rep.', 'MN', '5', '202-225-4755', '202-225-4886', 'http://ellison.house.gov/index.php?option=com_content&task=view&id=87'),
310 -(412216, 'B001256', 'F', 'Rep. Michele Bachmann [R, MN-6]', 'Rep.', 'MN', '6', '202-225-2331', '202-225-6475', 'http://bachmann.house.gov/Email_zip.htm'),
311 -(412217, 'S001172', 'M', 'Rep. Adrian Smith [R, NE-3]', 'Rep.', 'NE', '3', '202-225-6435', '202-225-0207', 'http://www.house.gov/formadriansmith/issues_subscribe.htm'),
312 -(412221, 'C001067', 'F', 'Rep. Yvette Clarke [D, NY-11]', 'Rep.', 'NY', '11', '202-225-6231', '202-226-0112', 'http://clarke.house.gov/contactform_zipcheck.shtml'),
313 -(412225, 'S001171', 'M', 'Rep. Heath Shuler [D, NC-11]', 'Rep.', 'NC', '11', '202-225-6401', '202-226-6422', 'http://shuler.house.gov/zipauth.htm'),
314 -(412226, 'J000289', 'M', 'Rep. Jim Jordan [R, OH-4]', 'Rep.', 'OH', '4', '202-225-2676', '202-226-0577', 'http://jordan.house.gov/contactform_zipcheck.shtml'),
315 -(412228, 'S001174', 'F', 'Rep. Betty Sutton [D, OH-13]', 'Rep.', 'OH', '13', '202-225-3401', '202-225-2266', 'http://sutton.house.gov/about/emailform.cfm'),
316 -(412231, 'A000362', 'M', 'Rep. Jason Altmire [D, PA-4]', 'Rep.', 'PA', '4', '202-225-2565', '202-226-2274', 'https://forms.house.gov/altmire/webforms/issue_subscribe.htm'),
317 -(412236, 'C001068', 'M', 'Rep. Steve Cohen [D, TN-9]', 'Rep.', 'TN', '9', '202-225-3265', '202-225-5663', 'http://cohen.house.gov/index.php?option=com_email_form&Itemid=113'),
318 -(412239, 'W000800', 'M', 'Rep. Peter Welch [D, VT-0]', 'Rep.', 'VT', '0', '202-225-4115', '202-225-6790', 'http://www.house.gov/formwelch/issue_subscribe.htm'),
319 -(412250, 'B001257', 'M', 'Rep. Gus Bilirakis [R, FL-9]', 'Rep.', 'FL', '9', '202-225-5755', '202-225-4085', 'http://bilirakis.house.gov/index.php?option=com_content&task=view&id=212&Itemid=44'),
320 -(412252, 'B001262', 'M', 'Rep. Paul Broun [R, GA-10]', 'Rep.', 'GA', '10', '202-225-4101', '202-226-0776', 'http://broun.house.gov/email.shtml'),
321 -(412253, 'R000581', 'F', 'Rep. Laura Richardson [D, CA-37]', 'Rep.', 'CA', '37', '202-225-7924', '202-225-7926', 'http://richardson.house.gov/IMA/issue_subscribe.htm'),
322 -(412254, 'T000465', 'F', 'Rep. Niki Tsongas [D, MA-5]', 'Rep.', 'MA', '5', '202-225-3411', '202-226-0771', 'http://tsongas.house.gov/?sectionid=11&sectiontree=3,11'),
323 -(412255, 'W000804', 'M', 'Rep. Rob Wittman [R, VA-1]', 'Rep.', 'VA', '1', '202-225-4261', '202-225-4382', 'https://forms.house.gov/wittman/IMA/webforms/issue_subscribe.htm'),
324 -(412256, 'L000566', 'M', 'Rep. Robert Latta [R, OH-5]', 'Rep.', 'OH', '5', '202-225-6405', '202-225-1985', 'http://latta.house.gov/contactform_zipcheck.shtml'),
325 -(412258, 'C001072', 'M', 'Rep. André Carson [D, IN-7]', 'Rep.', 'IN', '7', '202-225-4011', '202-225-5633', 'http://carson.house.gov/contact.me.shtml'),
326 -(412259, 'S001175', 'F', 'Rep. Jackie Speier [D, CA-12]', 'Rep.', 'CA', '12', '202-225-3531', '202-347-0956', 'http://speier.house.gov/IMA/issue_subscribe.htm'),
327 -(412261, 'S001176', 'M', 'Rep. Steve Scalise [R, LA-1]', 'Rep.', 'LA', '1', '202-225-3015', '202-226-0386', 'http://www.scalise.house.gov/contactform_zipcheck.shtml'),
328 -(412263, 'E000290', 'F', 'Rep. Donna Edwards [D, MD-4]', 'Rep.', 'MD', '4', '202-225-8699', '202-225-8714', 'http://www.house.gov/writerep'),
329 -(412265, 'A000365', 'M', 'Rep. Steve Austria [R, OH-7]', 'Rep.', 'OH', '7', '202-225-4324', '202-225-1984', 'https://forms.house.gov/austria/contact-form.shtml'),
330 -(412269, 'C001075', 'M', 'Rep. Bill Cassidy [R, LA-6]', 'Rep.', 'LA', '6', '202-225-3901', '202-225-7313', 'https://forms.house.gov/cassidy/contact-form.shtml'),
331 -(412270, 'C001076', 'M', 'Rep. Jason Chaffetz [R, UT-3]', 'Rep.', 'UT', '3', '202-225-7751', '202-225-5629', 'https://forms.house.gov/chaffetz/contact-form.shtml'),
332 -(412271, 'C001077', 'M', 'Rep. Mike Coffman [R, CO-6]', 'Rep.', 'CO', '6', '202-225-7882', '202-226-4623', 'https://forms.house.gov/coffman/contact-form.shtml'),
333 -(412272, 'C001078', 'M', 'Rep. Gerald Connolly [D, VA-11]', 'Rep.', 'VA', '11', '202-225-1492', '202-225-3071', 'https://forms.house.gov/connolly/contact-form.shtml'),
334 -(412275, 'F000456', 'M', 'Rep. John Fleming [R, LA-4]', 'Rep.', 'LA', '4', '202-225-2777', '202-225-8039', 'https://forms.house.gov/fleming/contact-form.shtml'),
335 -(412278, 'G000558', 'M', 'Rep. Brett Guthrie [R, KY-2]', 'Rep.', 'KY', '2', '202-225-3501', '202-226-2019', 'https://forms.house.gov/guthrie/contact-form.shtml'),
336 -(412280, 'H001045', 'M', 'Rep. Gregg Harper [R, MS-3]', 'Rep.', 'MS', '3', '202-225-5031', '202-225-5797', 'http://harper.house.gov/contact/'),
337 -(412281, 'H001046', 'M', 'Rep. Martin Heinrich [D, NM-1]', 'Rep.', 'NM', '1', '202-225-6316', '202-225-4975', 'https://forms.house.gov/heinrich/contact-form.shtml'),
338 -(412282, 'H001047', 'M', 'Rep. James Himes [D, CT-4]', 'Rep.', 'CT', '4', '202-225-5541', '202-225-9629', 'https://forms.house.gov/himes/contact-form.shtml'),
339 -(412283, 'H001048', 'M', 'Rep. Duncan Hunter [R, CA-52]', 'Rep.', 'CA', '52', '202-225-5672', '202-225-0235', 'https://forms.house.gov/hunter/zipauthen_contact.shtml'),
340 -(412284, 'J000290', 'F', 'Rep. Lynn Jenkins [R, KS-2]', 'Rep.', 'KS', '2', '202-225-6601', '202-225-7986', 'https://forms.house.gov/lynnjenkins/contact-form.shtml'),
341 -(412287, 'K000369', 'M', 'Rep. Larry Kissell [D, NC-8]', 'Rep.', 'NC', '8', '202-225-3715', '202-225-4036', 'https://forms.house.gov/kissell/contact-form.shtml');
342 -INSERT INTO `cl_house` (`sh_id`, `sh_bioguideid`, `sh_gender`, `sh_name`, `sh_title`, `sh_state`, `sh_district`, `sh_phone`, `sh_fax`, `sh_contactform`) VALUES
343 -(412290, 'L000567', 'M', 'Rep. Leonard Lance [R, NJ-7]', 'Rep.', 'NJ', '7', '202-225-5361', '202-225-9460', 'https://forms.house.gov/lance/contact-form.shtml'),
344 -(412292, 'L000569', 'M', 'Rep. Blaine Luetkemeyer [R, MO-9]', 'Rep.', 'MO', '9', '202-225-2956', '202-225-5712', 'https://forms.house.gov/luetkemeyer/contact-form.shtml'),
345 -(412293, 'L000570', 'M', 'Rep. Ben Luján [D, NM-3]', 'Rep.', 'NM', '3', '202-225-6190', '202-226-1528', 'https://forms.house.gov/lujan/contact-form.shtml'),
346 -(412294, 'L000571', 'F', 'Rep. Cynthia Lummis [R, WY-0]', 'Rep.', 'WY', '0', '202-225-2311', '202-225-3057', 'https://forms.house.gov/lummis/contact-form.shtml'),
347 -(412295, 'M001177', 'M', 'Rep. Tom McClintock [R, CA-4]', 'Rep.', 'CA', '4', '202-225-2511', '202-225-5444', 'https://forms.house.gov/mcclintock/contact-form.shtml'),
348 -(412302, 'O000168', 'M', 'Rep. Pete Olson [R, TX-22]', 'Rep.', 'TX', '22', '202-225-5951', '202-225-5241', 'https://forms.house.gov/olson/contact-form.shtml'),
349 -(412303, 'P000594', 'M', 'Rep. Erik Paulsen [R, MN-3]', 'Rep.', 'MN', '3', '202-225-2871', '202-225-6351', 'https://forms.house.gov/paulsen/contact-form.shtml'),
350 -(412305, 'P000595', 'M', 'Rep. Gary Peters [D, MI-9]', 'Rep.', 'MI', '9', '202-225-5802', '202-226-2356', 'https://forms.house.gov/peters/contact-form.shtml'),
351 -(412306, 'P000596', 'M', 'Res.Comm. Pedro Pierluisi [D, PR-0]', 'Res.Comm', 'PR', '0', '202-225-2615', '202-225-2154', ''),
352 -(412307, 'P000597', 'F', 'Rep. Chellie Pingree [D, ME-1]', 'Rep.', 'ME', '1', '202-225-6116', '202-225-5590', 'https://forms.house.gov/pingree/contact-form.shtml'),
353 -(412308, 'P000598', 'M', 'Rep. Jared Polis [D, CO-2]', 'Rep.', 'CO', '2', '202-225-2161', '202-226-7840', 'http://polis.house.gov/Contact/'),
354 -(412309, 'P000599', 'M', 'Rep. Bill Posey [R, FL-15]', 'Rep.', 'FL', '15', '202-225-3671', '202-225-3516', 'http://posey.house.gov/Contact/'),
355 -(412310, 'R000582', 'M', 'Rep. Phil Roe [R, TN-1]', 'Rep.', 'TN', '1', '202-225-6356', '202-225-6356', 'https://forms.house.gov/roe/contact-form.shtml'),
356 -(412311, 'R000583', 'M', 'Rep. Thomas Rooney [R, FL-16]', 'Rep.', 'FL', '16', '202-225-5792', '202-225-3132', 'https://forms.house.gov/rooney/contact-form.shtml'),
357 -(412312, 'S001177', 'M', 'Del. Gregorio Sablan [D, MP-0]', 'Del.', 'MP', '0', '', '', ''),
358 -(412314, 'S001179', 'M', 'Rep. Aaron Schock [R, IL-18]', 'Rep.', 'IL', '18', '202-225-6201', '202-225-9249', 'https://forms.house.gov/schock/contact-form.shtml'),
359 -(412315, 'S001180', 'M', 'Rep. Kurt Schrader [D, OR-5]', 'Rep.', 'OR', '5', '202-225-5711', '202-225-5699', 'https://forms.house.gov/schrader/contact-form.shtml'),
360 -(412317, 'T000467', 'M', 'Rep. Glenn Thompson [R, PA-5]', 'Rep.', 'PA', '5', '202-225-5121', '202-225-5796', 'https://forms.house.gov/thompson/contact-form.shtml'),
361 -(412319, 'T000469', 'M', 'Rep. Paul Tonko [D, NY-21]', 'Rep.', 'NY', '21', '202-225-5076', '202-225-5077', 'https://forms.house.gov/tonko/contact-form.shtml'),
362 -(412327, 'F000455', 'F', 'Rep. Marcia Fudge [D, OH-11]', 'Rep.', 'OH', '11', '202-225-7032', '202-225-1339', 'https://forms.house.gov/fudge/contact-form.shtml'),
363 -(412331, 'Q000023', 'M', 'Rep. Mike Quigley [D, IL-5]', 'Rep.', 'IL', '5', '202-225-4061', '202-225-5603', 'https://forms.house.gov/quigley/contact-form.shtml'),
364 -(412379, 'C001080', 'F', 'Rep. Judy Chu [D, CA-32]', 'Rep.', 'CA', '32', '202-225-5464', '202-225-5467', 'https://forms.house.gov/chu/contact-form.shtml'),
365 -(412382, 'G000559', 'M', 'Rep. John Garamendi [D, CA-10]', 'Rep.', 'CA', '10', '202-225-1880', '202-225-5914', 'http://garamendi.house.gov/contact/email-me.shtml'),
366 -(412383, 'O000169', 'M', 'Rep. William Owens [D, NY-23]', 'Rep.', 'NY', '23', '202-225-4611', '202-226-0621', 'http://owens.house.gov/contact/email-me.shtml'),
367 -(412385, 'D000610', 'M', 'Rep. Ted Deutch [D, FL-19]', 'Rep.', 'FL', '19', '202-225-3001', '202-225-5974', 'https://teddeutch.house.gov/Forms/WriteYourRep/default.aspx'),
368 -(412386, 'C001081', 'M', 'Rep. Mark Critz [D, PA-12]', 'Rep.', 'PA', '12', '202-225-2065', '202-225-5974', 'https://critz.house.gov/contact/email-me.shtml'),
369 -(412388, 'G000560', 'M', 'Rep. Tom Graves [R, GA-9]', 'Rep.', 'GA', '9', '202-225-5211', '202-225-8272', 'http://tomgraves.house.gov/contact/'),
370 -(412392, 'S001188', 'M', 'Rep. Marlin Stutzman [R, IN-3]', 'Rep.', 'IN', '3', '202-225-4436', '202-225-3479', ''),
371 -(412393, 'R000585', 'M', 'Rep. Tom Reed [R, NY-29]', 'Rep.', 'NY', '29', '202-225-3161', '202-226-6599', ''),
372 -(412394, 'R000591', 'F', 'Rep. Martha Roby [R, AL-2]', 'Rep.', 'AL', '2', '202-225-2901', '202-225-8913', ''),
373 -(412395, 'B001274', 'M', 'Rep. Mo Brooks [R, AL-5]', 'Rep.', 'AL', '5', '202-225-4801', '202-225-4392', ''),
374 -(412396, 'S001185', 'F', 'Rep. Terri Sewell [D, AL-7]', 'Rep.', 'AL', '7', '202-225-2665', '202-226-9567', ''),
375 -(412397, 'G000565', 'M', 'Rep. Paul Gosar [R, AZ-1]', 'Rep.', 'AZ', '1', '202-225-2315', '200-226-9739', ''),
376 -(412398, 'Q000024', 'M', 'Rep. Ben Quayle [R, AZ-3]', 'Rep.', 'AZ', '3', '202-225-3361', '202-225-3462', ''),
377 -(412399, 'S001183', 'M', 'Rep. David Schweikert [R, AZ-5]', 'Rep.', 'AZ', '5', '202-225-2190', '', ''),
378 -(412400, 'C001087', 'M', 'Rep. Rick Crawford [R, AR-1]', 'Rep.', 'AR', '1', '202-225-4076', '202-225-5602', ''),
379 -(412401, 'G000567', 'M', 'Rep. Tim Griffin [R, AR-2]', 'Rep.', 'AR', '2', '202-225-2506', '202-225-5903', ''),
380 -(412402, 'W000809', 'M', 'Rep. Steve Womack [R, AR-3]', 'Rep.', 'AR', '3', '202-225-4301', '202-225-5713', ''),
381 -(412403, 'D000612', 'M', 'Rep. Jeff Denham [R, CA-19]', 'Rep.', 'CA', '19', '202-225-4540', '202-225-3402', ''),
382 -(412404, 'B001270', 'F', 'Rep. Karen Bass [D, CA-33]', 'Rep.', 'CA', '33', '202-225-7084', '202- 225-2422', ''),
383 -(412405, 'T000470', 'M', 'Rep. Scott Tipton [R, CO-3]', 'Rep.', 'CO', '3', '202-225-4761', '202-226-9669', ''),
384 -(412406, 'G000562', 'M', 'Rep. Cory Gardner [R, CO-4]', 'Rep.', 'CO', '4', '202-225-4676', '', ''),
385 -(412407, 'C001083', 'M', 'Rep. John Carney [D, DE-0]', 'Rep.', 'DE', '0', '202-225-4165', '202-225-2291', ''),
386 -(412408, 'S001186', 'M', 'Rep. Steve Southerland [R, FL-2]', 'Rep.', 'FL', '2', '202-225-5235', '202-225-5615', ''),
387 -(412409, 'N000185', 'M', 'Rep. Richard Nugent [R, FL-5]', 'Rep.', 'FL', '5', '202-225-1002', '202- 226-6559', ''),
388 -(412410, 'W000806', 'M', 'Rep. Daniel Webster [R, FL-8]', 'Rep.', 'FL', '8', '202-225-2176', '202-225-0999', ''),
389 -(412411, 'R000593', 'M', 'Rep. Dennis Ross [R, FL-12]', 'Rep.', 'FL', '12', '202-225-1252', '202- 226-0585', ''),
390 -(412412, 'W000808', 'F', 'Rep. Frederica Wilson [D, FL-17]', 'Rep.', 'FL', '17', '202-225-4506', '202-226-0777', ''),
391 -(412413, 'W000807', 'M', 'Rep. Allen West [R, FL-22]', 'Rep.', 'FL', '22', '202-225-3026', '202-225-8398', ''),
392 -(412414, 'A000366', 'F', 'Rep. Sandy Adams [R, FL-24]', 'Rep.', 'FL', '24', '202-225-2706', '202-226-6299', ''),
393 -(412415, 'R000590', 'M', 'Rep. David Rivera [R, FL-25]', 'Rep.', 'FL', '25', '202-225-2778', '202-226-0346', ''),
394 -(412416, 'W000810', 'M', 'Rep. Rob Woodall [R, GA-7]', 'Rep.', 'GA', '7', '202-225-4272', '202-225-4696', ''),
395 -(412417, 'S001189', 'M', 'Rep. Austin Scott [R, GA-8]', 'Rep.', 'GA', '8', '202-225-6531', '202-225-3013', ''),
396 -(412418, 'H001050', 'F', 'Rep. Colleen Hanabusa [D, HI-1]', 'Rep.', 'HI', '1', '202-225-2726', '202-225-4580', ''),
397 -(412419, 'L000573', 'M', 'Rep. Raúl Labrador [R, ID-1]', 'Rep.', 'ID', '1', '202-225-6611', '202-225-3029', ''),
398 -(412420, 'D000613', 'M', 'Rep. Bob Dold [R, IL-10]', 'Rep.', 'IL', '10', '202-225-4835', '202-225-0837', ''),
399 -(412421, 'K000378', 'M', 'Rep. Adam Kinzinger [R, IL-11]', 'Rep.', 'IL', '11', '202-225-3635', '202- 225-3521', ''),
400 -(412422, 'H001059', 'M', 'Rep. Randy Hultgren [R, IL-14]', 'Rep.', 'IL', '14', '202-225-2976', '202- 225-0697', ''),
401 -(412423, 'S001182', 'M', 'Rep. Robert Schilling [R, IL-17]', 'Rep.', 'IL', '17', '202-225-5905', '202- 225-5396', ''),
402 -(412424, 'W000811', 'M', 'Rep. Joe Walsh [R, IL-8]', 'Rep.', 'IL', '8', '202-225-3711', '202-225-7830', 'https://walsh.house.gov/contact-me'),
403 -(412426, 'R000592', 'M', 'Rep. Todd Rokita [R, IN-4]', 'Rep.', 'IN', '4', '202-225-5037', '', ''),
404 -(412427, 'B001275', 'M', 'Rep. Larry Bucshon [R, IN-8]', 'Rep.', 'IN', '8', '202-225-4636', '202-225-3284', ''),
405 -(412428, 'Y000064', 'M', 'Rep. Todd Young [R, IN-9]', 'Rep.', 'IN', '9', '202-225-5315', '202-226-6866', ''),
406 -(412429, 'H001057', 'M', 'Rep. Tim Huelskamp [R, KS-1]', 'Rep.', 'KS', '1', '202-225-2715', '202- 225-5124', ''),
407 -(412430, 'Y000063', 'M', 'Rep. Kevin Yoder [R, KS-3]', 'Rep.', 'KS', '3', '202-225-2865', '202- 225-2807', ''),
408 -(412431, 'P000602', 'M', 'Rep. Mike Pompeo [R, KS-4]', 'Rep.', 'KS', '4', '202-225-6216', '202-225-3489', ''),
409 -(412432, 'R000588', 'M', 'Rep. Cedric Richmond [D, LA-2]', 'Rep.', 'LA', '2', '202-225-6636', '202- 225-1988', ''),
410 -(412433, 'L000574', 'M', 'Rep. Jeff Landry [R, LA-3]', 'Rep.', 'LA', '3', '202-225-4031', '202- 226-3944', ''),
411 -(412434, 'H001052', 'M', 'Rep. Andy Harris [R, MD-1]', 'Rep.', 'MD', '1', '202-225-5311', '202-225-0254', ''),
412 -(412435, 'K000375', 'M', 'Rep. William Keating [D, MA-10]', 'Rep.', 'MA', '10', '202-225-3111', '202- 225-5658', ''),
413 -(412436, 'B001271', 'M', 'Rep. Dan Benishek [R, MI-1]', 'Rep.', 'MI', '1', '202-225-4735', '202- 225-4744', ''),
414 -(412437, 'H001058', 'M', 'Rep. Bill Huizenga [R, MI-2]', 'Rep.', 'MI', '2', '202-225-4401', '202- 226-0779', ''),
415 -(412438, 'A000367', 'M', 'Rep. Justin Amash [R, MI-3]', 'Rep.', 'MI', '3', '202-225-3831', '202-225-5144', ''),
416 -(412440, 'C001085', 'M', 'Rep. Hansen Clarke [D, MI-13]', 'Rep.', 'MI', '13', '202-225-2261', '202-225-5730', ''),
417 -(412441, 'C001086', 'M', 'Rep. Chip Cravaack [R, MN-8]', 'Rep.', 'MN', '8', '202-225-6211', '202- 225-6211', ''),
418 -(412442, 'N000186', 'M', 'Rep. Alan Nunnelee [R, MS-1]', 'Rep.', 'MS', '1', '202-225-4306', '202- 225-3549', ''),
419 -(412443, 'P000601', 'M', 'Rep. Steven Palazzo [R, MS-4]', 'Rep.', 'MS', '4', '202-225-5772', '202- 225-7074', ''),
420 -(412444, 'H001053', 'F', 'Rep. Vicky Hartzler [R, MO-4]', 'Rep.', 'MO', '4', '202-225-2876', '202- 225-2695', ''),
421 -(412445, 'L000576', 'M', 'Rep. Billy Long [R, MO-7]', 'Rep.', 'MO', '7', '202-225-6536', '202-225-5604', ''),
422 -(412446, 'H001055', 'M', 'Rep. Joe Heck [R, NV-3]', 'Rep.', 'NV', '3', '202-225-3252', '202- 225-2185', ''),
423 -(412447, 'G000570', 'M', 'Rep. Frank Guinta [R, NH-1]', 'Rep.', 'NH', '1', '202-225-5456', '202-225-5822', ''),
424 -(412449, 'R000594', 'M', 'Rep. Jon Runyan [R, NJ-3]', 'Rep.', 'NJ', '3', '202-225-4765', '202-225-0778', ''),
425 -(412451, 'G000569', 'M', 'Rep. Michael Grimm [R, NY-13]', 'Rep.', 'NY', '13', '202-225-3371', '202- 226-1272', ''),
426 -(412452, 'H001054', 'F', 'Rep. Nan Hayworth [R, NY-19]', 'Rep.', 'NY', '19', '202-225-5441', '202- 225-3289', ''),
427 -(412453, 'G000564', 'M', 'Rep. Chris Gibson [R, NY-20]', 'Rep.', 'NY', '20', '202-225-5614', '202-225-1168', ''),
428 -(412454, 'H001051', 'M', 'Rep. Richard Hanna [R, NY-24]', 'Rep.', 'NY', '24', '202-225-3665', '202-225-1891', ''),
429 -(412456, 'B001276', 'F', 'Rep. Ann Marie Buerkle [R, NY-25]', 'Rep.', 'NY', '25', '202-225-3701', '202-225-4042', ''),
430 -(412457, 'E000291', 'F', 'Rep. Renee Ellmers [R, NC-2]', 'Rep.', 'NC', '2', '202-225-4531', '202- 225-5662 ', ''),
431 -(412458, 'B001272', 'M', 'Rep. Rick Berg [R, ND-0]', 'Rep.', 'ND', '0', '202-225-2611', '202-226-0893', ''),
432 -(412460, 'J000292', 'M', 'Rep. Bill Johnson [R, OH-6]', 'Rep.', 'OH', '6', '202-225-5705', '202-225-5907', ''),
433 -(412461, 'S001187', 'M', 'Rep. Steve Stivers [R, OH-15]', 'Rep.', 'OH', '15', '202-225-2015', '202-225-3529', ''),
434 -(412462, 'R000586', 'M', 'Rep. Jim Renacci [R, OH-16]', 'Rep.', 'OH', '16', '202-225-3876', '202-225-3059', ''),
435 -(412463, 'G000563', 'M', 'Rep. Bob Gibbs [R, OH-18]', 'Rep.', 'OH', '18', '202-225-6265', '202-225-3394', ''),
436 -(412464, 'L000575', 'M', 'Rep. James Lankford [R, OK-5]', 'Rep.', 'OK', '5', '202-225-2132', '202-226-1463', ''),
437 -(412465, 'K000376', 'M', 'Rep. Mike Kelly [R, PA-3]', 'Rep.', 'PA', '3', '202-225-5406', '202-225-3103', ''),
438 -(412466, 'M001181', 'M', 'Rep. Patrick Meehan [R, PA-7]', 'Rep.', 'PA', '7', '202-225-2011', '202- 226-0280', ''),
439 -(412468, 'M001179', 'M', 'Rep. Thomas Marino [R, PA-10]', 'Rep.', 'PA', '10', '202-225-3731', '202-225-9594 ', ''),
440 -(412469, 'B001269', 'M', 'Rep. Lou Barletta [R, PA-11]', 'Rep.', 'PA', '11', '202-225-6511', '202-225-0764', ''),
441 -(412470, 'C001084', 'M', 'Rep. David Cicilline [D, RI-1]', 'Rep.', 'RI', '1', '202-225-4911', '202- 225-3290', ''),
442 -(412471, 'S001184', 'M', 'Rep. Tim Scott [R, SC-1]', 'Rep.', 'SC', '1', '202-225-3176', '202-225-3407', ''),
443 -(412472, 'D000615', 'M', 'Rep. Jeff Duncan [R, SC-3]', 'Rep.', 'SC', '3', '202-225-3365', '202- 225-3216', ''),
444 -(412473, 'G000566', 'M', 'Rep. Trey Gowdy [R, SC-4]', 'Rep.', 'SC', '4', '202-225-6030', '202-226-1177', ''),
445 -(412474, 'M001182', 'M', 'Rep. Mick Mulvaney [R, SC-5]', 'Rep.', 'SC', '5', '202-225-5501', '202-225-0464', ''),
446 -(412475, 'N000184', 'F', 'Rep. Kristi Noem [R, SD-0]', 'Rep.', 'SD', '0', '202-225-2801', '202-225-5823', ''),
447 -(412476, 'F000459', 'M', 'Rep. Chuck Fleischmann [R, TN-3]', 'Rep.', 'TN', '3', '202-225-3271', '202-225-3494', ''),
448 -(412477, 'D000616', 'M', 'Rep. Scott DesJarlais [R, TN-4]', 'Rep.', 'TN', '4', '202-225-6831', '202-226-5172', ''),
449 -(412478, 'B001273', 'F', 'Rep. Diane Black [R, TN-6]', 'Rep.', 'TN', '6', '202-225-4231', '202- 225-6887', ''),
450 -(412479, 'F000458', 'M', 'Rep. Stephen Fincher [R, TN-8]', 'Rep.', 'TN', '8', '202-225-4714', '202-225-1765', ''),
451 -(412480, 'F000461', 'M', 'Rep. Bill Flores [R, TX-17]', 'Rep.', 'TX', '17', '202-225-6105', '202-225-0350', ''),
452 -(412481, 'C001082', 'M', 'Rep. Francisco Canseco [R, TX-23]', 'Rep.', 'TX', '23', '202-225-4511', '202-225-2237', ''),
453 -(412482, 'F000460', 'M', 'Rep. Blake Farenthold [R, TX-27]', 'Rep.', 'TX', '27', '202-225-7742', '202-226-1134', ''),
454 -(412483, 'R000589', 'M', 'Rep. Scott Rigell [R, VA-2]', 'Rep.', 'VA', '2', '202-225-4215', '202-225-4218', ''),
455 -(412484, 'H001060', 'M', 'Rep. Robert Hurt [R, VA-5]', 'Rep.', 'VA', '5', '202-225-4711', '202-225-5681', ''),
456 -(412485, 'G000568', 'M', 'Rep. Morgan Griffith [R, VA-9]', 'Rep.', 'VA', '9', '202-225-3861', '202- 225-0076', ''),
457 -(412486, 'H001056', 'F', 'Rep. Jaime Herrera Beutler [R, WA-3]', 'Rep.', 'WA', '3', '202-225-3536', '202-225-3478', ''),
458 -(412487, 'M001180', 'M', 'Rep. David McKinley [R, WV-1]', 'Rep.', 'WV', '1', '202-225-4172', '202-225-7564', ''),
459 -(412488, 'D000614', 'M', 'Rep. Sean Duffy [R, WI-7]', 'Rep.', 'WI', '7', '202-225-3365', '', ''),
460 -(412489, 'R000587', 'M', 'Rep. Reid Ribble [R, WI-8]', 'Rep.', 'WI', '8', '202-225-5665', '202- 225-5729', ''),
461 -(412497, 'H001062', 'F', 'Rep. Kathleen Hochul [D, NY-26]', 'Rep.', 'NY', '26', '202-225-5265', '', ''),
462 -(412498, 'H001063', 'F', 'Rep. Janice Hahn [D, CA-36]', 'Rep.', 'CA', '36', '202-225-8220', '202-226-7290', 'https://hahn.house.gov/contact-me/email-me'),
463 -(412499, 'T000471', 'M', 'Rep. Robert Turner [R, NY-9]', 'Rep.', 'NY', '9', '202-225-6616', '202-226-0218', 'https://bobturner.house.gov/contact-me'),
464 -(412500, 'A000369', 'M', 'Rep. Mark Amodei [R, NV-2]', 'Rep.', 'NV', '2', '202-225-6155', '202-225-5679', 'https://amodei.house.gov/contact-me');
 23+INSERT INTO `cl_house` (`clh_id`, `clh_bioguideid`, `clh_gender`, `clh_name`, `clh_title`, `clh_state`, `clh_district`, `clh_phone`, `clh_fax`, `clh_contactform`, `clh_twitter`) VALUES
 24+(400003, 'A000022', 'M', 'Rep. Gary Ackerman [D, NY-5]', 'Rep.', 'NY', '5', '202-225-2601', '202-225-1589', 'http://www.house.gov/writerep', NULL),
 25+(400004, 'A000055', 'M', 'Rep. Robert Aderholt [R, AL-4]', 'Rep.', 'AL', '4', '202-225-4876', '202-225-5587', 'http://aderholt.house.gov/?sectionid=195&sectiontree=195', 'Robert_Aderholt'),
 26+(400005, 'A000358', 'M', 'Rep. Todd Akin [R, MO-2]', 'Rep.', 'MO', '2', '202-225-2561', '202-225-2563', 'http://akin.house.gov/email.shtml', 'ToddAkin'),
 27+(400006, 'A000361', 'M', 'Rep. Rodney Alexander [R, LA-5]', 'Rep.', 'LA', '5', '202-225-8490', '202-225-5639', 'http://www.house.gov/alexander/content/webform/zipauth.htm', 'USRepAlexander'),
 28+(400008, 'A000210', 'M', 'Rep. Robert Andrews [D, NJ-1]', 'Rep.', 'NJ', '1', '202-225-6501', '', 'http://www.house.gov/andrews/contact_form_za.shtml', NULL),
 29+(400009, 'B001234', 'M', 'Rep. Joe Baca [D, CA-43]', 'Rep.', 'CA', '43', '202-225-6161', '202-225-8671', 'http://www.house.gov/baca/zipauth.shtml', 'BacaCA43'),
 30+(400010, 'B000013', 'M', 'Rep. Spencer Bachus [R, AL-6]', 'Rep.', 'AL', '6', '202-225-4921', '202-225-2082', 'http://www.house.gov/writerep/', 'BachusAL06'),
 31+(400013, 'B001230', 'F', 'Rep. Tammy Baldwin [D, WI-2]', 'Rep.', 'WI', '2', '202-225-2906', '202-225-6942', 'http://www.house.gov/formbaldwin/IMA/get_address.htm', 'RepTammyBaldwin'),
 32+(400017, 'B000208', 'M', 'Rep. Roscoe Bartlett [R, MD-6]', 'Rep.', 'MD', '6', '202-225-2721', '202-225-2193', 'http://www.bartlett.house.gov/Email_Roscoe/', NULL),
 33+(400018, 'B000213', 'M', 'Rep. Joe Barton [R, TX-6]', 'Rep.', 'TX', '6', '202-225-2002', '202-225-3052', 'http://joebarton.house.gov/ContactJoe.aspx?Type=Email', 'RepJoeBarton'),
 34+(400019, 'B000220', 'M', 'Rep. Charles Bass [R, NH-2]', 'Rep.', 'NH', '2', '202-225-5206', '202-225-2946', 'https://forms.house.gov/bass/webforms/contact-form.shtml', 'RepCharlesBass'),
 35+(400021, 'B000287', 'M', 'Rep. Xavier Becerra [D, CA-31]', 'Rep.', 'CA', '31', '202-225-6235', '202-225-2202', 'http://becerra.house.gov/HoR/CA31/Hidden+Content/Email+Signup+Form.htm', 'RepBecerra'),
 36+(400024, 'B001231', 'F', 'Rep. Shelley Berkley [D, NV-1]', 'Rep.', 'NV', '1', '202-225-5965', '202-225-3119', 'http://berkley.house.gov/contact/email.html', 'RepBerkley'),
 37+(400025, 'B000410', 'M', 'Rep. Howard Berman [D, CA-28]', 'Rep.', 'CA', '28', '202-225-4695', '202-225-3196', 'http://www.house.gov/berman/contact/', NULL),
 38+(400027, 'B001232', 'F', 'Rep. Judy Biggert [R, IL-13]', 'Rep.', 'IL', '13', '202-225-3515', '202-225-9420', 'http://judybiggert.house.gov/ContactJudy.aspx', 'JudyBiggert'),
 39+(400029, 'B001250', 'M', 'Rep. Rob Bishop [R, UT-1]', 'Rep.', 'UT', '1', '202-225-0453', '202-225-5857', 'http://robbishop.house.gov/ZipAuth.aspx', NULL),
 40+(400030, 'B000490', 'M', 'Rep. Sanford Bishop [D, GA-2]', 'Rep.', 'GA', '2', '202-225-3631', '202-225-2203', 'http://bishop.house.gov/display.cfm?section_id=13', 'SanfordBishop'),
 41+(400031, 'B001242', 'M', 'Rep. Timothy Bishop [D, NY-1]', 'Rep.', 'NY', '1', '202-225-3826', '202-225-3143', 'http://timbishop.house.gov/?sectionid=96&sectiontree=7,96', NULL),
 42+(400032, 'B001243', 'F', 'Rep. Marsha Blackburn [R, TN-7]', 'Rep.', 'TN', '7', '202-225-2811', '202-225-3004', 'http://blackburn.house.gov/contactform/', NULL),
 43+(400033, 'B000574', 'M', 'Rep. Earl Blumenauer [D, OR-3]', 'Rep.', 'OR', '3', '202-225-4811', '202-225-8941', 'http://blumenauer.house.gov/index.php?option=com_email_form&Itemid=206', 'repblumenauer'),
 44+(400036, 'B000589', 'M', 'Rep. John Boehner [R, OH-8]', 'Rep.', 'OH', '8', '202-225-6205', '202-225-0704', 'http://www.johnboehner.house.gov/Contact/', 'johnboehner'),
 45+(400038, 'B001244', 'M', 'Rep. Jo Bonner [R, AL-1]', 'Rep.', 'AL', '1', '202-225-4931', '202-225-0562', 'https://forms.house.gov/bonner/webforms/issue_subscribe.html', 'RepJoBonner'),
 46+(400039, 'B001228', 'F', 'Rep. Mary Bono Mack [R, CA-45]', 'Rep.', 'CA', '45', '202-225-5330', '202-225-2961', 'http://www.house.gov/formbono/issue.htm', 'MaryBonoMack'),
 47+(400041, 'B001245', 'F', 'Del. Madeleine Bordallo [D, GU-0]', 'Del.', 'GU', '0', '', '', 'http://www.house.gov/bordallo/contact.shtml', NULL),
 48+(400042, 'B000652', 'M', 'Rep. Leonard Boswell [D, IA-3]', 'Rep.', 'IA', '3', '202-225-3806', '202-225-5608', 'http://boswell.house.gov/messageform.htm', 'LeonardBoswell'),
 49+(400046, 'B000755', 'M', 'Rep. Kevin Brady [R, TX-8]', 'Rep.', 'TX', '8', '202-225-4901', '202-225-5524', 'http://www.house.gov/brady/contact_page.html', 'RepKevinBrady'),
 50+(400047, 'B001227', 'M', 'Rep. Robert Brady [D, PA-1]', 'Rep.', 'PA', '1', '202-225-4731', '202-225-0088', 'http://www.house.gov/formrobertbrady/issue.htm', 'RepBrady'),
 51+(400048, 'B000911', 'F', 'Rep. Corrine Brown [D, FL-3]', 'Rep.', 'FL', '3', '202-225-0123', '202-225-2256', 'http://www.house.gov/corrinebrown/IMA/issue.shtml', NULL),
 52+(400052, 'B001248', 'M', 'Rep. Michael Burgess [R, TX-26]', 'Rep.', 'TX', '26', '202-225-7772', '202-225-2919', 'https://forms.house.gov/wyr/welcome.shtml', 'michaelcburgess'),
 53+(400055, 'B001149', 'M', 'Rep. Dan Burton [R, IN-5]', 'Rep.', 'IN', '5', '202-225-2276', '202-225-0016', 'http://burton.house.gov/contacts/new', 'RepDanBurton'),
 54+(400057, 'C000059', 'M', 'Rep. Ken Calvert [R, CA-44]', 'Rep.', 'CA', '44', '202-225-1986', '202-225-2004', 'http://calvert.house.gov/awenhnjafe.asp', 'KenCalvert'),
 55+(400058, 'C000071', 'M', 'Rep. David Camp [R, MI-4]', 'Rep.', 'MI', '4', '202-225-3561', '202-225-9679', 'http://camp.house.gov/WriteRep.aspx', 'RepDaveCamp'),
 56+(400060, 'C001046', 'M', 'Rep. Eric Cantor [R, VA-7]', 'Rep.', 'VA', '7', '202-225-2815', '202-225-0011', 'https://writerep.house.gov/writerep/welcome.shtml', 'EricCantor'),
 57+(400061, 'C001047', 'F', 'Rep. Shelley Capito [R, WV-2]', 'Rep.', 'WV', '2', '202-225-2711', '202-225-7856', 'https://forms.house.gov/wyr/welcome.shtml', 'RepShelley'),
 58+(400062, 'C001036', 'F', 'Rep. Lois Capps [D, CA-23]', 'Rep.', 'CA', '23', '202-225-3601', '202-225-5632', 'http://www.house.gov/capps/contact/send_an_email.shtml', NULL),
 59+(400063, 'C001037', 'M', 'Rep. Michael Capuano [D, MA-8]', 'Rep.', 'MA', '8', '202-225-5111', '202-225-9322', 'http://www.house.gov/capuano/contact/email.shtml', NULL),
 60+(400065, 'C001050', 'M', 'Rep. Dennis Cardoza [D, CA-18]', 'Rep.', 'CA', '18', '202-225-6131', '202-225-0819', 'https://forms.house.gov/wyr/welcome.shtml', 'RepCardoza'),
 61+(400068, 'C001051', 'M', 'Rep. John Carter [R, TX-31]', 'Rep.', 'TX', '31', '202-225-3864', '202-225-5886', 'https://forms.house.gov/wyr/welcome.shtml', 'judgecarter'),
 62+(400071, 'C000266', 'M', 'Rep. Steven Chabot [R, OH-1]', 'Rep.', 'OH', '1', '202-225-2216', '202-225-3012', 'https://chabotforms.house.gov/email-me', 'RepSteveChabot'),
 63+(400073, 'C000380', 'F', 'Del. Donna Christensen [D, VI-0]', 'Del.', 'VI', '0', '', '', 'https://donnachristensen.house.gov/contact-me/email-me', NULL),
 64+(400074, 'C001049', 'M', 'Rep. William Clay [D, MO-1]', 'Rep.', 'MO', '1', '202-225-2406', '202-226-3717', 'http://lacyclay.house.gov/contact.htm', NULL),
 65+(400075, 'C000537', 'M', 'Rep. James Clyburn [D, SC-6]', 'Rep.', 'SC', '6', '202-225-3315', '202-225-2313', 'http://clyburn.house.gov/contact.cfm', NULL),
 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+(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+(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'),
 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+(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+(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),
 73+(400089, 'C001048', 'M', 'Rep. John Culberson [R, TX-7]', 'Rep.', 'TX', '7', '202-225-2571', '202-225-4381', 'http://www.culberson.house.gov/contactinfo.aspx', 'johnculberson'),
 74+(400090, 'C000984', 'M', 'Rep. Elijah Cummings [D, MD-7]', 'Rep.', 'MD', '7', '202-225-4741', '202-225-3178', 'https://forms.house.gov/wyr/welcome.shtml', NULL),
 75+(400093, 'D000096', 'M', 'Rep. Danny Davis [D, IL-7]', 'Rep.', 'IL', '7', '202-225-5006', '202-225-5641', 'https://forms.house.gov/davis/webforms/issue_subscribe.htm', NULL),
 76+(400097, 'D000598', 'F', 'Rep. Susan Davis [D, CA-53]', 'Rep.', 'CA', '53', '202-225-2040', '202-225-2948', 'http://www.house.gov/susandavis/contact.shtml', NULL),
 77+(400100, 'D000191', 'M', 'Rep. Peter DeFazio [D, OR-4]', 'Rep.', 'OR', '4', '202-225-6416', '202-225-0032', 'http://www.house.gov/formdefazio/contact.html', NULL),
 78+(400101, 'D000197', 'F', 'Rep. Diana DeGette [D, CO-1]', 'Rep.', 'CO', '1', '202-225-4431', '202-225-5657', 'http://www.house.gov/formdegette/zip_auth.htm', 'RepDianaDeGette'),
 79+(400103, 'D000216', 'F', 'Rep. Rosa DeLauro [D, CT-3]', 'Rep.', 'CT', '3', '202-225-3661', '202-225-4890', 'http://delauro.house.gov/contact_form_email.cfm', 'rosadelauro'),
 80+(400108, 'D000600', 'M', 'Rep. Mario Diaz-Balart [R, FL-21]', 'Rep.', 'FL', '21', '202-225-4211', '202-225-8576', 'Http://mariodiaz-balart.house.gov//index.cfm?sectionid=11', 'MarioDB'),
 81+(400109, 'D000327', 'M', 'Rep. Norman Dicks [D, WA-6]', 'Rep.', 'WA', '6', '202-225-5916', '202-226-1176', 'http://www.house.gov/dicks/email.shtml', 'RepNormDicks'),
 82+(400110, 'D000355', 'M', 'Rep. John Dingell [D, MI-15]', 'Rep.', 'MI', '15', '202-225-4071', '202-226-0371', 'https://forms.house.gov/wyr/welcome.shtml', 'john_dingell'),
 83+(400111, 'D000399', 'M', 'Rep. Lloyd Doggett [D, TX-25]', 'Rep.', 'TX', '25', '202-225-4865', '202-225-3073', 'http://www.house.gov/doggett/doggett_ima/doggett_get_address.shtml', NULL),
 84+(400114, 'D000482', 'M', 'Rep. Michael Doyle [D, PA-14]', 'Rep.', 'PA', '14', '202-225-2135', '202-225-3084', 'http://www.house.gov/doyle/email_mike.shtml', 'USRepMikeDoyle'),
 85+(400115, 'D000492', 'M', 'Rep. David Dreier [R, CA-26]', 'Rep.', 'CA', '26', '202-225-2305', '202-225-7018', 'http://doyle.house.gov/email_mike.shtml', NULL),
 86+(400116, 'D000533', 'M', 'Rep. John Duncan [R, TN-2]', 'Rep.', 'TN', '2', '202-225-5435', '202-225-6440', 'http://www.house.gov/duncan/contactform_zipcheck.shtml', NULL),
 87+(400121, 'E000172', 'F', 'Rep. Jo Ann Emerson [R, MO-8]', 'Rep.', 'MO', '8', '202-225-4404', '202-226-0326', 'http://www.house.gov/emerson/contact/', 'joannemerson'),
 88+(400122, 'E000179', 'M', 'Rep. Eliot Engel [D, NY-17]', 'Rep.', 'NY', '17', '202-225-2464', '202-225-5513', 'http://www.house.gov/writerep', NULL),
 89+(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'),
 90+(400128, 'F000010', 'M', 'Del. Eni Faleomavaega [D, AS-0]', 'Del.', 'AS', '0', '', '', '', NULL),
 91+(400129, 'F000030', 'M', 'Rep. Sam Farr [D, CA-17]', 'Rep.', 'CA', '17', '202-225-2861', '202-225-6791', 'http://www.farr.house.gov/index.php?option=com_content&task=view&id=202', NULL),
 92+(400130, 'F000043', 'M', 'Rep. Chaka Fattah [D, PA-2]', 'Rep.', 'PA', '2', '202-225-4001', '202-225-5392', 'http://fattah.house.gov/?sectionid=8&sectiontree=8', 'chakafattah'),
 93+(400133, 'F000116', 'M', 'Rep. Bob Filner [D, CA-51]', 'Rep.', 'CA', '51', '202-225-8045', '202-225-9073', 'http://www.house.gov/writerep', 'CongBobFilner'),
 94+(400134, 'F000444', 'M', 'Rep. Jeff Flake [R, AZ-6]', 'Rep.', 'AZ', '6', '202-225-2635', '202-226-4386', 'http://www.house.gov/writerep', 'JeffFlake'),
 95+(400137, 'F000445', 'M', 'Rep. Randy Forbes [R, VA-4]', 'Rep.', 'VA', '4', '202-225-6365', '202-226-1170', 'http://forbes.house.gov/zipauth.html', 'Randy_Forbes'),
 96+(400140, 'F000339', 'M', 'Rep. Barney Frank [D, MA-4]', 'Rep.', 'MA', '4', '202-225-5931', '202-225-0182', 'http://www.house.gov/writerep', NULL),
 97+(400141, 'F000448', 'M', 'Rep. Trent Franks [R, AZ-2]', 'Rep.', 'AZ', '2', '202-225-4576', '202-225-6328', 'https://forms.house.gov/franks/email_zipcheck.shtml', 'RepTrentFranks'),
 98+(400142, 'F000372', 'M', 'Rep. Rodney Frelinghuysen [R, NJ-11]', 'Rep.', 'NJ', '11', '202-225-5034', '202-225-3186', 'http://frelinghuysen.house.gov/contactus/form.cfm', NULL),
 99+(400144, 'G000021', 'M', 'Rep. Elton Gallegly [R, CA-24]', 'Rep.', 'CA', '24', '202-225-5811', '202-225-1100', 'http://www.house.gov/writerep', 'eltongallegly24'),
 100+(400145, 'G000548', 'M', 'Rep. Scott Garrett [R, NJ-5]', 'Rep.', 'NJ', '5', '202-225-4465', '202-225-9048', 'http://www.house.gov/formgarrett/contact.shtml', NULL),
 101+(400147, 'G000549', 'M', 'Rep. Jim Gerlach [R, PA-6]', 'Rep.', 'PA', '6', '202-225-4315', '202-225-8440', 'http://www.house.gov/writerep', 'JimGerlach'),
 102+(400151, 'G000550', 'M', 'Rep. John Gingrey [R, GA-11]', 'Rep.', 'GA', '11', '202-225-2931', '202-225-2944', 'http://www.house.gov/formgingrey/IMA/issue.htm', 'RepPhilGingrey'),
 103+(400152, 'G000544', 'M', 'Rep. Charles Gonzalez [D, TX-20]', 'Rep.', 'TX', '20', '202-225-3236', '202-225-1915', 'http://www.gonzalez.house.gov/index.php?option=com_content&task=view&id=170', NULL),
 104+(400154, 'G000289', 'M', 'Rep. Robert Goodlatte [R, VA-6]', 'Rep.', 'VA', '6', '202-225-5431', '202-225-9681', 'http://www.house.gov/goodlatte/emailbob.htm', 'RepGoodlatte'),
 105+(400157, 'G000377', 'F', 'Rep. Kay Granger [R, TX-12]', 'Rep.', 'TX', '12', '202-225-5071', '202-225-5683', 'http://kaygranger.house.gov/?sectionid=46&sectiontree=46', 'RepKayGranger'),
 106+(400158, 'G000546', 'M', 'Rep. Samuel Graves [R, MO-6]', 'Rep.', 'MO', '6', '202-225-7041', '202-225-8221', 'http://www.house.gov/graves/contact.shtml', NULL),
 107+(400160, 'G000410', 'M', 'Rep. Raymond Green [D, TX-29]', 'Rep.', 'TX', '29', '202-225-1688', '202-225-9903', 'http://www.house.gov/green/contact', NULL),
 108+(400162, 'G000551', 'M', 'Rep. Raul Grijalva [D, AZ-7]', 'Rep.', 'AZ', '7', '202-225-2435', '202-225-1541', 'http://grijalva.house.gov/?sectionid=49&sectiontree=2,49', 'RepRaulGrijalva'),
 109+(400163, 'G000535', 'M', 'Rep. Luis Gutiérrez [D, IL-4]', 'Rep.', 'IL', '4', '202-225-8203', '202-225-7810', 'http://www.house.gov/writerep', 'RepGutierrez'),
 110+(400165, 'H000067', 'M', 'Rep. Ralph Hall [R, TX-4]', 'Rep.', 'TX', '4', '202-225-6673', '202-225-3332', 'http://www.house.gov/ralphhall/IMA/zipauth.htm', NULL),
 111+(400170, 'H000324', 'M', 'Rep. Alcee Hastings [D, FL-23]', 'Rep.', 'FL', '23', '202-225-1313', '202-225-1171', 'http://www.alceehastings.house.gov/index.php?option=com_content&task=view&id=104&Itemid=', NULL),
 112+(400171, 'H000329', 'M', 'Rep. Doc Hastings [R, WA-4]', 'Rep.', 'WA', '4', '202-225-5816', '202-225-3251', 'http://hastings.house.gov/ContactForm.aspx', NULL),
 113+(400175, 'H001036', 'M', 'Rep. Jeb Hensarling [R, TX-5]', 'Rep.', 'TX', '5', '202-225-3484', '202-226-4888', 'http://www.house.gov/hensarling/contact_web.shtml', 'RepHensarling'),
 114+(400176, 'H000528', 'M', 'Rep. Walter Herger [R, CA-2]', 'Rep.', 'CA', '2', '202-225-3076', '202-225-1740', 'http://www.house.gov/herger/contact.shtml', NULL),
 115+(400178, 'H000627', 'M', 'Rep. Maurice Hinchey [D, NY-22]', 'Rep.', 'NY', '22', '202-225-6335', '202-226-0774', 'http://www.house.gov/hinchey/contact/zipauth.shtml', 'mauricehinchey'),
 116+(400179, 'H000636', 'M', 'Rep. Rubén Hinojosa [D, TX-15]', 'Rep.', 'TX', '15', '202-225-2531', '202-225-5688', 'http://www.house.gov/writerep', 'USRepRHinojosa'),
 117+(400183, 'H000712', 'M', 'Rep. Tim Holden [D, PA-17]', 'Rep.', 'PA', '17', '202-225-5546', '202-226-0996', 'http://www.holden.house.gov/contactform_zipcheck.shtml', NULL),
 118+(400184, 'H001032', 'M', 'Rep. Rush Holt [D, NJ-12]', 'Rep.', 'NJ', '12', '202-225-5801', '202-225-6025', 'http://www.holt.house.gov/contact.shtml', NULL),
 119+(400185, 'H001034', 'M', 'Rep. Michael Honda [D, CA-15]', 'Rep.', 'CA', '15', '202-225-2631', '202-225-2699', 'http://honda.house.gov/contactmike.shtml', 'RepMikeHonda'),
 120+(400189, 'H000874', 'M', 'Rep. Steny Hoyer [D, MD-5]', 'Rep.', 'MD', '5', '202-225-4131', '202-225-4300', 'http://hoyer.house.gov/contact/email.asp', 'WhipHoyer'),
 121+(400193, 'I000026', 'M', 'Rep. Jay Inslee [D, WA-1]', 'Rep.', 'WA', '1', '202-225-6311', '202-226-1606', 'http://www.house.gov/inslee/contact/email.html', 'RepInsleeNews'),
 122+(400195, 'I000057', 'M', 'Rep. Steve Israel [D, NY-2]', 'Rep.', 'NY', '2', '202-225-3335', '202-225-4669', 'http://www.house.gov/formisrael/contact.html', 'RepSteveIsrael'),
 123+(400196, 'I000056', 'M', 'Rep. Darrell Issa [R, CA-49]', 'Rep.', 'CA', '49', '202-225-3906', '202-225-3303', 'http://issa.house.gov/index.cfm?FuseAction=Contact.ContactForm', 'DarrellIssa'),
 124+(400198, 'J000283', 'M', 'Rep. Jesse Jackson [D, IL-2]', 'Rep.', 'IL', '2', '202-225-0773', '202-225-0899', 'http://www.house.gov/jackson/ContactByEMail.shtml', NULL),
 125+(400199, 'J000032', 'F', 'Rep. Sheila Jackson-Lee [D, TX-18]', 'Rep.', 'TX', '18', '202-225-3816', '202-225-3317', 'http://www.jacksonlee.house.gov/contact-form.shtml', 'JacksonLeeTX18'),
 126+(400204, 'J000126', 'F', 'Rep. Eddie Johnson [D, TX-30]', 'Rep.', 'TX', '30', '202-225-8885', '202-226-1477', 'http://www.house.gov/ebjohnson/IMA/issue_subscribe.shtml', 'RepEBJ'),
 127+(400206, 'J000174', 'M', 'Rep. Samuel Johnson [R, TX-3]', 'Rep.', 'TX', '3', '202-225-4201', '202-225-1485', 'http://www.house.gov/formsamjohnson/IMA/issue.htm', NULL),
 128+(400207, 'J000285', 'M', 'Rep. Timothy Johnson [R, IL-15]', 'Rep.', 'IL', '15', '202-225-2371', '202-226-0791', 'http://www.house.gov/timjohnson/contact/index.shtml', NULL),
 129+(400209, 'J000255', 'M', 'Rep. Walter Jones [R, NC-3]', 'Rep.', 'NC', '3', '202-225-3415', '202-225-3286', 'http://jones.house.gov/contact_form_email.cfm', 'RepWalterJones'),
 130+(400211, 'K000009', 'F', 'Rep. Marcy Kaptur [D, OH-9]', 'Rep.', 'OH', '9', '202-225-4146', '202-225-7711', 'http://www.kaptur.house.gov/index.php?option=com_content&task=view&id=152', NULL),
 131+(400216, 'K000172', 'M', 'Rep. Dale Kildee [D, MI-5]', 'Rep.', 'MI', '5', '202-225-3611', '202-225-6393', 'http://www.house.gov/writerep', NULL),
 132+(400218, 'K000188', 'M', 'Rep. Ronald Kind [D, WI-3]', 'Rep.', 'WI', '3', '202-225-5506', '202-225-5739', 'http://www.house.gov/kind/contact.shtml', NULL),
 133+(400219, 'K000210', 'M', 'Rep. Peter King [R, NY-3]', 'Rep.', 'NY', '3', '202-225-7896', '202-226-2279', 'http://peteking.house.gov/zip.shtml', 'RepPeteKing'),
 134+(400220, 'K000362', 'M', 'Rep. Steve King [R, IA-5]', 'Rep.', 'IA', '5', '202-225-4426', '202-225-3193', 'http://www.house.gov/steveking/email.shtm', 'SteveKingPress'),
 135+(400221, 'K000220', 'M', 'Rep. Jack Kingston [R, GA-1]', 'Rep.', 'GA', '1', '202-225-5831', '202-226-2269', 'http://kingston.house.gov/ContactForm/', 'JackKingston'),
 136+(400224, 'K000363', 'M', 'Rep. John Kline [R, MN-2]', 'Rep.', 'MN', '2', '202-225-2271', '202-225-2595', 'http://kline.house.gov/index.cfm?FuseAction=ContactInformation.ContactForm&To=mn02hwyr@housemail.house.gov&CFID=22307054&CFTOKEN=28173710', NULL),
 137+(400227, 'K000336', 'M', 'Rep. Dennis Kucinich [D, OH-10]', 'Rep.', 'OH', '10', '202-225-5871', '202-225-5745', 'http://kucinich.house.gov/Contact/Starter.htm', 'dennis_kucinich'),
 138+(400230, 'L000559', 'M', 'Rep. James Langevin [D, RI-2]', 'Rep.', 'RI', '2', '202-225-2735', '202-225-5976', 'http://langevin.house.gov/comments.shtml', 'jimlangevin'),
 139+(400232, 'L000560', 'M', 'Rep. Rick Larsen [D, WA-2]', 'Rep.', 'WA', '2', '202-225-2605', '202-225-4420', 'http://www.house.gov/larsen/contact/', NULL),
 140+(400233, 'L000557', 'M', 'Rep. John Larson [D, CT-1]', 'Rep.', 'CT', '1', '202-225-2265', '202-225-1031', 'http://www.house.gov/writerep', 'RepJohnLarson'),
 141+(400234, 'L000111', 'M', 'Rep. Thomas Latham [R, IA-4]', 'Rep.', 'IA', '4', '202-225-5476', '202-225-3301', 'http://www.tomlatham.house.gov/Contact/', 'TomLatham'),
 142+(400235, 'L000553', 'M', 'Rep. Steven LaTourette [R, OH-14]', 'Rep.', 'OH', '14', '202-225-5731', '202-225-3307', 'http://latourette.house.gov/ContactSteve.aspx', 'SteveLaTourette'),
 143+(400237, 'L000551', 'F', 'Rep. Barbara Lee [D, CA-9]', 'Rep.', 'CA', '9', '202-225-2661', '202-225-9817', 'http://lee.house.gov/?sectionid=44&sectiontree=18,44', NULL),
 144+(400238, 'L000263', 'M', 'Rep. Sander Levin [D, MI-12]', 'Rep.', 'MI', '12', '202-225-4961', '202-226-1033', 'http://www.house.gov/levin/levin_contact_email.shtml', 'repsandylevin'),
 145+(400239, 'L000274', 'M', 'Rep. Jerry Lewis [R, CA-41]', 'Rep.', 'CA', '41', '202-225-5861', '202-225-6498', 'http://www.house.gov/jerrylewis/IMA/WritetoRepresentativeLewis.htm', 'RepJerryLewis'),
 146+(400240, 'L000287', 'M', 'Rep. John Lewis [D, GA-5]', 'Rep.', 'GA', '5', '202-225-3801', '202-225-0351', 'http://www.house.gov/formjohnlewis/contact.html', NULL),
 147+(400244, 'L000554', 'M', 'Rep. Frank LoBiondo [R, NJ-2]', 'Rep.', 'NJ', '2', '202-225-6572', '202-225-3318', 'http://www.house.gov/lobiondo/IMA/issue.htm', 'RepLoBiondo'),
 148+(400245, 'L000397', 'F', 'Rep. Zoe Lofgren [D, CA-16]', 'Rep.', 'CA', '16', '202-225-3072', '202-225-3336', 'http://lofgren.house.gov/emailform.shtml', NULL),
 149+(400246, 'L000480', 'F', 'Rep. Nita Lowey [D, NY-18]', 'Rep.', 'NY', '18', '202-225-6506', '202-225-0546', 'http://lowey.house.gov/?sectionid=56&sectiontree=56', 'NitaLowey'),
 150+(400247, 'L000491', 'M', 'Rep. Frank Lucas [R, OK-3]', 'Rep.', 'OK', '3', '202-225-5565', '202-225-8698', 'http://www.house.gov/lucas/zipauth.htm', NULL),
 151+(400249, 'L000562', 'M', 'Rep. Stephen Lynch [D, MA-9]', 'Rep.', 'MA', '9', '202-225-8273', '202-225-3984', 'http://www.house.gov/writerep', NULL),
 152+(400251, 'M000087', 'F', 'Rep. Carolyn Maloney [D, NY-14]', 'Rep.', 'NY', '14', '202-225-7944', '202-225-4709', 'http://maloney.house.gov/index.php?option=com_email_form&Itemid=73', NULL),
 153+(400252, 'M001138', 'M', 'Rep. Donald Manzullo [R, IL-16]', 'Rep.', 'IL', '16', '202-225-5676', '202-225-5284', 'http://manzullo.house.gov/zipauth.aspx', 'donmanzullo'),
 154+(400253, 'M000133', 'M', 'Rep. Edward Markey [D, MA-7]', 'Rep.', 'MA', '7', '202-225-2836', '202-226-0092', 'http://markey.house.gov/index.php?option=com_email_form&Itemid=124', 'MarkeyMemo'),
 155+(400255, 'M001142', 'M', 'Rep. Jim Matheson [D, UT-2]', 'Rep.', 'UT', '2', '202-225-3011', '202-225-5638', 'https://forms.house.gov/matheson/contact.shtml', 'RepJimMatheson'),
 156+(400257, 'M000309', 'F', 'Rep. Carolyn McCarthy [D, NY-4]', 'Rep.', 'NY', '4', '202-225-5516', '202-225-5758', 'http://www.house.gov/writerep', 'RepMcCarthyNY'),
 157+(400259, 'M001143', 'F', 'Rep. Betty McCollum [D, MN-4]', 'Rep.', 'MN', '4', '202-225-6631', '202-225-1968', 'http://www.mccollum.house.gov/index.asp?Type=NONE&SEC={AC61FD79-AD5F-440D-A7F0-555B12349E5B}', NULL),
 158+(400260, 'M001147', 'M', 'Rep. Thaddeus McCotter [R, MI-11]', 'Rep.', 'MI', '11', '202-225-8171', '202-225-2667', 'http://mccotter.house.gov/HoR/MI11/Contact/Office+Contact+Information/Zipcode+Authentication+Page.htm', 'ThadMcCotter'),
 159+(400262, 'M000404', 'M', 'Rep. James McDermott [D, WA-7]', 'Rep.', 'WA', '7', '202-225-3106', '202-225-6197', 'http://www.house.gov/mcdermott/contact.shtml', 'RepJimMcDermott'),
 160+(400263, 'M000312', 'M', 'Rep. James McGovern [D, MA-3]', 'Rep.', 'MA', '3', '202-225-6101', '202-225-5759', 'http://www.house.gov/writerep', 'RepMcGovern'),
 161+(400266, 'M000485', 'M', 'Rep. Mike McIntyre [D, NC-7]', 'Rep.', 'NC', '7', '202-225-2731', '202-225-5773', 'http://www.house.gov/mcintyre/IMA/issue.htm', 'RepMikeMcIntyre'),
 162+(400267, 'M000508', 'M', 'Rep. Howard McKeon [R, CA-25]', 'Rep.', 'CA', '25', '202-225-1956', '202-226-0683', 'http://mckeon.house.gov/contact.shtml', 'BuckMcKeon'),
 163+(400271, 'M001137', 'M', 'Rep. Gregory Meeks [D, NY-6]', 'Rep.', 'NY', '6', '202-225-3461', '202-226-4169', 'http://www.house.gov/meeks/contactform_zipcheck.shtml', 'GregoryMeeks'),
 164+(400273, 'M000689', 'M', 'Rep. John Mica [R, FL-7]', 'Rep.', 'FL', '7', '202-225-4035', '202-226-0821', 'http://www.house.gov/mica/messageform.shtml', NULL),
 165+(400274, 'M001149', 'M', 'Rep. Michael Michaud [D, ME-2]', 'Rep.', 'ME', '2', '202-225-6306', '202-225-2943', 'https://forms.house.gov/michaud/webforms/issue_subscribe.htm', 'RepMikeMichaud'),
 166+(400276, 'M001150', 'F', 'Rep. Candice Miller [R, MI-10]', 'Rep.', 'MI', '10', '202-225-2106', '202-226-1169', 'http://candicemiller.house.gov/Contact.aspx', 'candicemiller'),
 167+(400277, 'M001139', 'M', 'Rep. Gary Miller [R, CA-42]', 'Rep.', 'CA', '42', '202-225-3201', '202-226-6962', 'http://garymiller.house.gov/Contact/', 'RepGaryMiller'),
 168+(400278, 'M000725', 'M', 'Rep. George Miller [D, CA-7]', 'Rep.', 'CA', '7', '202-225-2095', '202-225-5609', 'http://georgemiller.house.gov/contactus/2007/08/post_1.html', 'askgeorge'),
 169+(400279, 'M001144', 'M', 'Rep. Jeff Miller [R, FL-1]', 'Rep.', 'FL', '1', '202-225-4136', '202-225-3414', 'http://jeffmiller.house.gov/index.cfm?FuseAction=Contact.Home', 'CongJeffMiller'),
 170+(400280, 'M001154', 'M', 'Rep. Bradley Miller [D, NC-13]', 'Rep.', 'NC', '13', '202-225-3032', '202-225-0181', 'http://bradmiller.house.gov/?sectionid=17&sectiontree=9,17', NULL),
 171+(400283, 'M000933', 'M', 'Rep. James Moran [D, VA-8]', 'Rep.', 'VA', '8', '202-225-4376', '202-225-0017', 'http://moran.house.gov/zipauth.shtml', 'Jim_Moran'),
 172+(400285, 'M001151', 'M', 'Rep. Tim Murphy [R, PA-18]', 'Rep.', 'PA', '18', '202-225-2301', '202-225-1844', 'http://murphy.house.gov/Contact/zipauth.htm', 'RepTimMurphy'),
 173+(400288, 'M001134', 'F', 'Rep. Sue Myrick [R, NC-9]', 'Rep.', 'NC', '9', '202-225-1976', '202-225-3389', 'http://myrick.house.gov/zipauth.shtml', 'SueMyrick'),
 174+(400289, 'N000002', 'M', 'Rep. Jerrold Nadler [D, NY-8]', 'Rep.', 'NY', '8', '202-225-5635', '202-225-6923', 'http://www.house.gov/nadler/emailform.shtml', NULL),
 175+(400290, 'N000179', 'F', 'Rep. Grace Napolitano [D, CA-38]', 'Rep.', 'CA', '38', '202-225-5256', '202-225-0027', 'http://www.napolitano.house.gov/contact/feedback.htm', NULL),
 176+(400291, 'N000015', 'M', 'Rep. Richard Neal [D, MA-2]', 'Rep.', 'MA', '2', '202-225-5601', '202-225-8112', 'http://www.house.gov/neal/write_neal.html', NULL),
 177+(400295, 'N000147', 'F', 'Del. Eleanor Norton [D, DC-0]', 'Del.', 'DC', '0', '202-225-8050', '202-225-3002', 'https://forms.house.gov/norton/webforms/issue_subscribe.htm', 'EleanorNorton'),
 178+(400297, 'N000181', 'M', 'Rep. Devin Nunes [R, CA-21]', 'Rep.', 'CA', '21', '202-225-2523', '202-225-3404', 'http://www.nunes.house.gov/index.cfm?FuseAction=ContactUs.ContactForm', NULL),
 179+(400301, 'O000085', 'M', 'Rep. John Olver [D, MA-1]', 'Rep.', 'MA', '1', '202-225-5335', '202-226-1224', 'http://www.house.gov/olver/contactme.html', NULL),
 180+(400308, 'P000034', 'M', 'Rep. Frank Pallone [D, NJ-6]', 'Rep.', 'NJ', '6', '202-225-4671', '202-225-9665', 'http://www.house.gov/pallone/contact.shtml', 'FrankPallone'),
 181+(400309, 'P000096', 'M', 'Rep. William Pascrell [D, NJ-8]', 'Rep.', 'NJ', '8', '202-225-5751', '202-225-5782', 'http://pascrell.house.gov/contact/', NULL),
 182+(400310, 'P000099', 'M', 'Rep. Edward Pastor [D, AZ-4]', 'Rep.', 'AZ', '4', '202-225-4065', '202-225-1655', 'http://www.house.gov/writerep', NULL),
 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+(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+(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'),
 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+(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+(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),
 190+(400320, 'P000373', 'M', 'Rep. Joseph Pitts [R, PA-16]', 'Rep.', 'PA', '16', '202-225-2411', '202-225-2013', 'http://www.house.gov/pitts/contact.shtml', NULL),
 191+(400321, 'P000585', 'M', 'Rep. Todd Platts [R, PA-19]', 'Rep.', 'PA', '19', '202-225-5836', '202-226-1000', 'http://www.house.gov/platts/email.shtml', NULL),
 192+(400326, 'P000523', 'M', 'Rep. David Price [D, NC-4]', 'Rep.', 'NC', '4', '202-225-1784', '202-225-2014', 'http://price.house.gov/contact/contact_form.shtml', NULL),
 193+(400331, 'R000011', 'M', 'Rep. Nick Rahall [D, WV-3]', 'Rep.', 'WV', '3', '202-225-3452', '202-225-9061', 'http://www.rahall.house.gov/?sectionid=9&sectiontree=9', NULL),
 194+(400333, 'R000053', 'M', 'Rep. Charles Rangel [D, NY-15]', 'Rep.', 'NY', '15', '202-225-4365', '202-225-0816', 'https://forms.house.gov/rangel/forms/contact.shtml', 'cbrangel'),
 195+(400335, 'R000571', 'M', 'Rep. Dennis Rehberg [R, MT-0]', 'Rep.', 'MT', '0', '202-225-3211', '202-225-5687', 'http://www.house.gov/rehberg/issue.shtml', 'dennyrehberg'),
 196+(400337, 'R000170', 'M', 'Rep. Silvestre Reyes [D, TX-16]', 'Rep.', 'TX', '16', '202-225-4831', '202-225-2016', 'http://wwwc.house.gov/reyes/voice_your_opinion.asp', NULL),
 197+(400340, 'R000395', 'M', 'Rep. Harold Rogers [R, KY-5]', 'Rep.', 'KY', '5', '202-225-4601', '202-225-0940', 'http://halrogers.house.gov/Contact.aspx', NULL),
 198+(400341, 'R000575', 'M', 'Rep. Michael Rogers [R, AL-3]', 'Rep.', 'AL', '3', '202-225-3261', '202-226-8485', 'http://www.house.gov/mike-rogers/contact.shtml', 'RepMikeRogersAL'),
 199+(400342, 'R000572', 'M', 'Rep. Michael Rogers [R, MI-8]', 'Rep.', 'MI', '8', '202-225-4872', '202-225-5820', 'http://www.mikerogers.house.gov/Contact.aspx', NULL),
 200+(400343, 'R000409', 'M', 'Rep. Dana Rohrabacher [R, CA-46]', 'Rep.', 'CA', '46', '202-225-2415', '202-225-0145', 'http://rohrabacher.house.gov/Contact/Zip.htm', 'DanaRohrabacher'),
 201+(400344, 'R000435', 'F', 'Rep. Ileana Ros-Lehtinen [R, FL-18]', 'Rep.', 'FL', '18', '202-225-3931', '202-225-5620', 'http://www.house.gov/writerep', 'RosLehtinen'),
 202+(400345, 'R000573', 'M', 'Rep. Mike Ross [D, AR-4]', 'Rep.', 'AR', '4', '202-225-3772', '202-225-1314', 'http://ross.house.gov/?sectionid=77&sectiontree=76,77', 'RepMikeRoss'),
 203+(400346, 'R000462', 'M', 'Rep. Steven Rothman [D, NJ-9]', 'Rep.', 'NJ', '9', '202-225-5061', '202-225-5851', 'https://forms.house.gov/rothman/webforms/issue_subscribe.htm', NULL),
 204+(400347, 'R000486', 'F', 'Rep. Lucille Roybal-Allard [D, CA-34]', 'Rep.', 'CA', '34', '202-225-1766', '202-226-0350', 'http://www.house.gov/writerep', NULL),
 205+(400348, 'R000487', 'M', 'Rep. Edward Royce [R, CA-40]', 'Rep.', 'CA', '40', '202-225-4111', '202-226-0335', 'http://www.house.gov/writerep', NULL),
 206+(400349, 'R000576', 'M', 'Rep. Dutch Ruppersberger [D, MD-2]', 'Rep.', 'MD', '2', '202-225-3061', '202-225-3094', 'http://dutch.house.gov/writedutch_za.shtml', NULL),
 207+(400350, 'R000515', 'M', 'Rep. Bobby Rush [D, IL-1]', 'Rep.', 'IL', '1', '202-225-4372', '202-226-0333', 'http://www.house.gov/rush/zipauth.shtml', NULL),
 208+(400351, 'R000570', 'M', 'Rep. Paul Ryan [R, WI-1]', 'Rep.', 'WI', '1', '202-225-3031', '202-225-3393', 'http://www.house.gov/ryan/email.htm', 'reppaulryan'),
 209+(400352, 'R000577', 'M', 'Rep. Timothy Ryan [D, OH-17]', 'Rep.', 'OH', '17', '202-225-5261', '202-225-3719', 'http://timryan.house.gov/index.php?option=com_content&task=view&id=129&Itemid=42', 'timryan'),
 210+(400355, 'S001156', 'F', 'Rep. Linda Sánchez [D, CA-39]', 'Rep.', 'CA', '39', '202-225-6676', '202-226-1012', 'http://www.house.gov/writerep', NULL),
 211+(400356, 'S000030', 'F', 'Rep. Loretta Sanchez [D, CA-47]', 'Rep.', 'CA', '47', '202-225-2965', '202-225-5859', 'http://www.lorettasanchez.house.gov/index.php?option=com_content&task=view&id=218&Itemid=17', 'lorettasanchez'),
 212+(400360, 'S001145', 'F', 'Rep. Janice Schakowsky [D, IL-9]', 'Rep.', 'IL', '9', '202-225-2111', '202-226-6890', 'http://www.house.gov/schakowsky/contact.shtml', 'janschakowsky'),
 213+(400361, 'S001150', 'M', 'Rep. Adam Schiff [D, CA-29]', 'Rep.', 'CA', '29', '202-225-4176', '202-225-5828', 'http://schiff.house.gov/HoR/CA29/Contact+Information/Contact+Form.htm', 'RepAdamSchiff'),
 214+(400363, 'S001157', 'M', 'Rep. David Scott [D, GA-13]', 'Rep.', 'GA', '13', '202-225-2939', '202-225-4628', 'http://www.house.gov/writerep', 'RepDavidScott'),
 215+(400364, 'S000185', 'M', 'Rep. Robert Scott [D, VA-3]', 'Rep.', 'VA', '3', '202-225-8351', '202-225-8354', 'http://www.house.gov/writerep', 'RepBobbyScott'),
 216+(400365, 'S000244', 'M', 'Rep. James Sensenbrenner [R, WI-5]', 'Rep.', 'WI', '5', '202-225-5101', '202-225-3190', 'http://sensenbrenner.house.gov/email_zip.htm', NULL),
 217+(400366, 'S000248', 'M', 'Rep. José Serrano [D, NY-16]', 'Rep.', 'NY', '16', '202-225-4361', '202-225-6001', 'http://serrano.house.gov/Forms/Contact.aspx', NULL),
 218+(400367, 'S000250', 'M', 'Rep. Peter Sessions [R, TX-32]', 'Rep.', 'TX', '32', '202-225-2231', '202-225-5878', 'http://www.house.gov/sessionsform/emailform.htm', 'PeteSessions'),
 219+(400371, 'S000344', 'M', 'Rep. Brad Sherman [D, CA-27]', 'Rep.', 'CA', '27', '202-225-5911', '202-225-5879', 'http://www.house.gov/sherman/contact/', 'BradSherman'),
 220+(400373, 'S000364', 'M', 'Rep. John Shimkus [R, IL-19]', 'Rep.', 'IL', '19', '202-225-5271', '202-225-5880', 'http://www.house.gov/shimkus/emailme.shtml', 'RepShimkus'),
 221+(400376, 'S001148', 'M', 'Rep. Michael Simpson [R, ID-2]', 'Rep.', 'ID', '2', '202-225-5531', '202-225-8216', 'http://www.house.gov/simpson/emailme.shtml', 'CongMikeSimpson'),
 222+(400378, 'S000480', 'F', 'Rep. Louise Slaughter [D, NY-28]', 'Rep.', 'NY', '28', '202-225-3615', '202-225-7822', 'http://www.louise.house.gov/index.php?option=com_content&task=view&id=506&Itemid=150', 'louiseslaughter'),
 223+(400379, 'S000510', 'M', 'Rep. Adam Smith [D, WA-9]', 'Rep.', 'WA', '9', '202-225-8901', '202-225-5893', 'http://adamsmith.house.gov/Contact/', 'Rep_Adam_Smith'),
 224+(400380, 'S000522', 'M', 'Rep. Christopher Smith [R, NJ-4]', 'Rep.', 'NJ', '4', '202-225-3765', '202-225-7768', 'http://chrissmith.house.gov/zipauth.html', NULL),
 225+(400381, 'S000583', 'M', 'Rep. Lamar Smith [R, TX-21]', 'Rep.', 'TX', '21', '202-225-4236', '202-225-8628', 'http://lamarsmith.house.gov/contact.aspx?section=Mail', 'LamarSmithTX21'),
 226+(400387, 'S000810', 'M', 'Rep. Fortney Stark [D, CA-13]', 'Rep.', 'CA', '13', '202-225-5065', '202-226-3805', 'http://www.house.gov/stark/contact/index.htm', NULL),
 227+(400388, 'S000822', 'M', 'Rep. Clifford Stearns [R, FL-6]', 'Rep.', 'FL', '6', '202-225-5744', '202-225-3973', 'http://www.house.gov/writerep', 'RepCliffStearns'),
 228+(400392, 'S001155', 'M', 'Rep. John Sullivan [R, OK-1]', 'Rep.', 'OK', '1', '202-225-2211', '202-225-9187', 'http://sullivan.house.gov/zipauth.html', 'USRepSullivan'),
 229+(400400, 'T000459', 'M', 'Rep. Lee Terry [R, NE-2]', 'Rep.', 'NE', '2', '202-225-4155', '202-226-5452', 'http://www.house.gov/formleeterry/IMA/issue.htm', 'LEETERRYNE'),
 230+(400402, 'T000193', 'M', 'Rep. Bennie Thompson [D, MS-2]', 'Rep.', 'MS', '2', '202-225-5876', '202-225-5898', 'https://forms.house.gov/benniethompson/contact-form.shtml', NULL),
 231+(400403, 'T000460', 'M', 'Rep. Michael Thompson [D, CA-1]', 'Rep.', 'CA', '1', '202-225-3311', '202-225-4335', 'http://mikethompson.house.gov/contact/email.shtml', NULL),
 232+(400404, 'T000238', 'M', 'Rep. William Thornberry [R, TX-13]', 'Rep.', 'TX', '13', '202-225-3706', '202-225-3486', 'http://www.house.gov/writerep', NULL),
 233+(400406, 'T000462', 'M', 'Rep. Patrick Tiberi [R, OH-12]', 'Rep.', 'OH', '12', '202-225-5355', '202-226-4523', 'http://www.house.gov/writerep', NULL),
 234+(400407, 'T000266', 'M', 'Rep. John Tierney [D, MA-6]', 'Rep.', 'MA', '6', '202-225-8020', '202-225-5915', 'http://www.house.gov/tierney/IMA/email.shtml', NULL),
 235+(400409, 'T000326', 'M', 'Rep. Edolphus Towns [D, NY-10]', 'Rep.', 'NY', '10', '202-225-5936', '202-225-1018', 'http://www.house.gov/towns/contact_form_zipcheck.shtml', NULL),
 236+(400411, 'T000463', 'M', 'Rep. Michael Turner [R, OH-3]', 'Rep.', 'OH', '3', '202-225-6465', '202-225-6754', 'http://turner.house.gov/Contact/', NULL),
 237+(400414, 'U000031', 'M', 'Rep. Frederick Upton [R, MI-6]', 'Rep.', 'MI', '6', '202-225-3761', '202-225-4986', 'http://www.house.gov/writerep', 'RepFredUpton'),
 238+(400415, 'V000128', 'M', 'Rep. Christopher Van Hollen [D, MD-8]', 'Rep.', 'MD', '8', '202-225-5341', '202-225-0375', 'http://vanhollen.house.gov/HoR/MD08/Contact+Information/Web+Contact/Contact+Form.htm', NULL),
 239+(400416, 'V000081', 'F', 'Rep. Nydia Velázquez [D, NY-12]', 'Rep.', 'NY', '12', '202-225-2361', '202-226-0327', 'http://www.house.gov/velazquez/IMA/issue_subscribe.htm', NULL),
 240+(400417, 'V000108', 'M', 'Rep. Peter Visclosky [D, IN-1]', 'Rep.', 'IN', '1', '202-225-2461', '202-225-2493', 'http://www.house.gov/writerep', 'RepVisclosky'),
 241+(400419, 'W000791', 'M', 'Rep. Greg Walden [R, OR-2]', 'Rep.', 'OR', '2', '202-225-6730', '202-225-5774', 'http://www.walden.house.gov/ContactGreg.ContactFormIQ.shtml', 'repgregwalden'),
 242+(400422, 'W000187', 'F', 'Rep. Maxine Waters [D, CA-35]', 'Rep.', 'CA', '35', '202-225-2201', '202-225-7854', 'http://www.house.gov/waters/IMA/issue.htm', 'MaxineWaters'),
 243+(400424, 'W000207', 'M', 'Rep. Melvin Watt [D, NC-12]', 'Rep.', 'NC', '12', '202-225-1510', '202-225-1512', 'http://www.house.gov/formwatt/IMA/issue_subscribe.htm', NULL),
 244+(400425, 'W000215', 'M', 'Rep. Henry Waxman [D, CA-30]', 'Rep.', 'CA', '30', '202-225-3976', '202-225-4099', 'http://waxman.house.gov/Contact/', NULL),
 245+(400431, 'W000413', 'M', 'Rep. Edward Whitfield [R, KY-1]', 'Rep.', 'KY', '1', '202-225-3115', '202-225-3547', 'http://whitfield.house.gov/contact/index.shtml', NULL),
 246+(400433, 'W000795', 'M', 'Rep. Addison Wilson [R, SC-2]', 'Rep.', 'SC', '2', '202-225-2452', '202-225-2455', 'http://www.house.gov/formwilson/IMA/issue.htm', 'CongJoeWilson'),
 247+(400435, 'W000672', 'M', 'Rep. Frank Wolf [R, VA-10]', 'Rep.', 'VA', '10', '202-225-5136', '202-225-0437', 'http://www.house.gov/formwolf/contact_email/emailzip.shtml', NULL),
 248+(400436, 'W000738', 'F', 'Rep. Lynn Woolsey [D, CA-6]', 'Rep.', 'CA', '6', '202-225-5161', '202-225-5163', 'http://woolsey.house.gov/contactemailform.asp', 'RepLynnWoolsey'),
 249+(400439, 'Y000031', 'M', 'Rep. Bill Young [R, FL-10]', 'Rep.', 'FL', '10', '202-225-5961', '202-225-9764', 'http://www.house.gov/writerep', NULL),
 250+(400440, 'Y000033', 'M', 'Rep. Donald Young [R, AK-0]', 'Rep.', 'AK', '0', '202-225-5765', '202-225-0425', 'http://donyoung.house.gov/Contact/', 'repdonyoung'),
 251+(400441, 'N000182', 'M', 'Rep. Randy Neugebauer [R, TX-19]', 'Rep.', 'TX', '19', '202-225-4005', '202-225-9615', 'http://www.randy.house.gov/?sectionid=65&sectiontree=8,65', 'RandyNeugebauer'),
 252+(400442, 'C001058', 'M', 'Rep. Ben Chandler [D, KY-6]', 'Rep.', 'KY', '6', '202-225-4706', '202-225-2122', 'https://forms.house.gov/wyr/welcome.shtml', NULL),
 253+(400570, 'B000461', 'M', 'Rep. Brian Bilbray [R, CA-50]', 'Rep.', 'CA', '50', '202-225-0508', '202-225-2558', 'http://www.house.gov/bilbray/contact.shtml', 'BilbrayCA50'),
 254+(400616, 'B001251', 'M', 'Rep. George Butterfield [D, NC-1]', 'Rep.', 'NC', '1', '202-225-3101', '202-225-3354', 'http://butterfield.house.gov/contactinfo.asp', NULL),
 255+(400617, 'L000517', 'M', 'Rep. Daniel Lungren [R, CA-3]', 'Rep.', 'CA', '3', '202-225-5716', '202-226-1298', 'https://forms.house.gov/lungren/forms/email.shtml', NULL),
 256+(400618, 'C001059', 'M', 'Rep. Jim Costa [D, CA-20]', 'Rep.', 'CA', '20', '202-225-3341', '202-225-9308', 'http://www.house.gov/formcosta/issue.htm', NULL),
 257+(400622, 'M001155', 'M', 'Rep. Connie Mack [R, FL-14]', 'Rep.', 'FL', '14', '202-225-2536', '202-226-0439', 'http://mack.house.gov/index.cfm?FuseAction=ContactConnie.ContactForm', 'RepConnieMack'),
 258+(400623, 'W000797', 'F', 'Rep. Debbie Wasserman Schultz [D, FL-20]', 'Rep.', 'FL', '20', '202-225-7931', '202-225-2052', 'http://wassermanschultz.house.gov/zipauth.htm', 'DWStweets'),
 259+(400626, 'P000591', 'M', 'Rep. Tom Price [R, GA-6]', 'Rep.', 'GA', '6', '202-225-4501', '202-225-4656', 'http://tom.house.gov/html/contact_form_email.cfm', 'RepTomPrice'),
 260+(400627, 'W000796', 'M', 'Rep. Lynn Westmoreland [R, GA-3]', 'Rep.', 'GA', '3', '202-225-5901', '202-225-2515', 'http://www.house.gov/writerep', NULL),
 261+(400628, 'B001252', 'M', 'Rep. John Barrow [D, GA-12]', 'Rep.', 'GA', '12', '202-225-2823', '202-225-3377', 'https://forms.house.gov/barrow/webforms/issue_subscribe.htm', 'repjohnbarrow'),
 262+(400630, 'L000563', 'M', 'Rep. Daniel Lipinski [D, IL-3]', 'Rep.', 'IL', '3', '202-225-5701', '202-225-1012', 'http://www.house.gov/formlipinski/zipauth.html', NULL),
 263+(400633, 'D000603', 'M', 'Rep. Geoff Davis [R, KY-4]', 'Rep.', 'KY', '4', '202-225-3465', '202-225-0003', 'http://geoffdavis.house.gov/Contact.aspx', NULL),
 264+(400636, 'B001255', 'M', 'Rep. Charles Boustany [R, LA-7]', 'Rep.', 'LA', '7', '202-225-2031', '202-225-5724', 'http://boustany.house.gov/ContactCharles.asp', 'RepBoustany'),
 265+(400638, 'C001060', 'M', 'Rep. Russ Carnahan [D, MO-3]', 'Rep.', 'MO', '3', '202-225-2671', '202-225-7452', 'http://carnahan.house.gov/contact.shtml', 'RepCarnahan'),
 266+(400639, 'C001061', 'M', 'Rep. Emanuel Cleaver [D, MO-5]', 'Rep.', 'MO', '5', '202-225-4535', '202-225-4403', 'http://www.house.gov/cleaver/IMA/issue.htm', NULL),
 267+(400640, 'F000449', 'M', 'Rep. Jeffrey Fortenberry [R, NE-1]', 'Rep.', 'NE', '1', '202-225-4806', '202-225-5686', 'http://fortenberry.house.gov/contactform_zipcheck.shtml', 'JeffFortenberry'),
 268+(400641, 'H001038', 'M', 'Rep. Brian Higgins [D, NY-27]', 'Rep.', 'NY', '27', '202-225-3306', '202-226-0347', 'http://higgins.house.gov/email.asp', 'RepBrianHiggins'),
 269+(400643, 'F000450', 'F', 'Rep. Virginia Foxx [R, NC-5]', 'Rep.', 'NC', '5', '202-225-2071', '202-225-2995', 'http://www.house.gov/formfoxx/IMA/issue_subscribe.htm', 'virginiafoxx'),
 270+(400644, 'M001156', 'M', 'Rep. Patrick McHenry [R, NC-10]', 'Rep.', 'NC', '10', '202-225-2576', '202-225-0316', 'http://mchenry.house.gov/zipauth.htm', 'PatrickMcHenry'),
 271+(400645, 'B001254', 'M', 'Rep. Dan Boren [D, OK-2]', 'Rep.', 'OK', '2', '202-225-2701', '202-225-3038', 'http://www.house.gov/boren/emailsignup.shtml', NULL),
 272+(400646, 'F000451', 'M', 'Rep. Michael Fitzpatrick [R, PA-8]', 'Rep.', 'PA', '8', '202-225-4276', '202- 225-9511', 'https://fitzpatrick.house.gov/contact-me', 'RepFitzpatrick'),
 273+(400647, 'S001162', 'F', 'Rep. Allyson Schwartz [D, PA-13]', 'Rep.', 'PA', '13', '202-225-6111', '202-226-0611', 'http://schwartz.house.gov/issue_subscribe.shtml', NULL),
 274+(400648, 'D000604', 'M', 'Rep. Charles Dent [R, PA-15]', 'Rep.', 'PA', '15', '202-225-6411', '202-226-0778', 'http://dent.house.gov/verifyemail.shtml', NULL),
 275+(400651, 'G000552', 'M', 'Rep. Louis Gohmert [R, TX-1]', 'Rep.', 'TX', '1', '202-225-3035', '202-226-1230', 'http://gohmert.house.gov/contact_louie.htm', 'replouiegohmert'),
 276+(400652, 'P000592', 'M', 'Rep. Ted Poe [R, TX-2]', 'Rep.', 'TX', '2', '202-225-6565', '202-225-5547', 'http://poe.house.gov/email/', 'JudgeTedPoe'),
 277+(400653, 'G000553', 'M', 'Rep. Al Green [D, TX-9]', 'Rep.', 'TX', '9', '202-225-7508', '202-225-2947', 'http://www.house.gov/writerep', NULL),
 278+(400654, 'M001157', 'M', 'Rep. Michael McCaul [R, TX-10]', 'Rep.', 'TX', '10', '202-225-2401', '202-225-5955', 'http://www.house.gov/writerep', 'McCaulPressShop'),
 279+(400655, 'C001062', 'M', 'Rep. Michael Conaway [R, TX-11]', 'Rep.', 'TX', '11', '202-225-3605', '202-225-1783', 'http://conaway.house.gov/Contact/default.aspx#email', NULL),
 280+(400656, 'M001158', 'M', 'Rep. Kenny Marchant [R, TX-24]', 'Rep.', 'TX', '24', '202-225-6605', '202-225-0074', 'http://marchant.house.gov/emailkenny.shtml', 'RepKenMarchant'),
 281+(400657, 'C001063', 'M', 'Rep. Henry Cuellar [D, TX-28]', 'Rep.', 'TX', '28', '202-225-1640', '202-225-1641', 'http://cuellar.house.gov/Contact/SendMeAnEmail.htm', NULL),
 282+(400659, 'M001159', 'F', 'Rep. Cathy McMorris Rodgers [R, WA-5]', 'Rep.', 'WA', '5', '202-225-2006', '202-225-3392', 'http://www.mcmorris.house.gov/IMA/issue_subscribe.htm', 'cathymcmorris'),
 283+(400660, 'R000578', 'M', 'Rep. Dave Reichert [R, WA-8]', 'Rep.', 'WA', '8', '202-225-7761', '202-225-4282', 'http://reichert.house.gov/Contact/ZipAuth.htm', 'davereichert'),
 284+(400661, 'M001160', 'F', 'Rep. Gwen Moore [D, WI-4]', 'Rep.', 'WI', '4', '202-225-4572', '202-225-8135', 'http://www.house.gov/gwenmoore/contact.shtml', 'RepGwenMoore'),
 285+(400663, 'M001163', 'F', 'Rep. Doris Matsui [D, CA-5]', 'Rep.', 'CA', '5', '202-225-7163', '202-225-0566', 'https://forms.house.gov/matsui/webforms/issue_subscribe.htm', NULL),
 286+(409888, 'S001154', 'M', 'Rep. William Shuster [R, PA-9]', 'Rep.', 'PA', '9', '202-225-2431', '202-225-2486', 'http://www.house.gov/shuster/zipauth.htm', 'RepBillShuster'),
 287+(412010, 'S001164', 'F', 'Rep. Jean Schmidt [R, OH-2]', 'Rep.', 'OH', '2', '202-225-3164', '202-225-1992', 'http://www.house.gov/schmidt/contact.shtml', NULL),
 288+(412011, 'C001064', 'M', 'Rep. John Campbell [R, CA-48]', 'Rep.', 'CA', '48', '202-225-5611', '202-225-9177', 'http://campbell.house.gov/Contact/ContactForm.htm', 'RepJohnCampbell'),
 289+(412186, 'S001165', 'M', 'Rep. Albio Sires [D, NJ-13]', 'Rep.', 'NJ', '13', '202-225-7919', '202-226-0792', 'https://forms.house.gov/sires/webforms/issue_subscribe.htm', 'Rep_Albio_Sires'),
 290+(412188, 'G000554', 'F', 'Rep. Gabrielle Giffords [D, AZ-8]', 'Rep.', 'AZ', '8', '202-225-2542', '202-225-0378', 'http://giffords.house.gov/contact/mailing-list/', 'Rep_Giffords'),
 291+(412189, 'M001166', 'M', 'Rep. Jerry McNerney [D, CA-11]', 'Rep.', 'CA', '11', '202-225-1947', '202-225-4060', 'http://mcnerney.house.gov/contact.shtml', NULL),
 292+(412190, 'M001165', 'M', 'Rep. Kevin McCarthy [R, CA-22]', 'Rep.', 'CA', '22', '202-225-2915', '202-225-2908', 'http://kevinmccarthy.house.gov/showpage.asp?ID=69', 'kevinomccarthy'),
 293+(412191, 'L000564', 'M', 'Rep. Doug Lamborn [R, CO-5]', 'Rep.', 'CO', '5', '202-225-4422', '202-226-2638', 'http://lamborn.house.gov/ZipAuth.aspx', NULL),
 294+(412192, 'P000593', 'M', 'Rep. Ed Perlmutter [D, CO-7]', 'Rep.', 'CO', '7', '202-225-2645', '202-225-5278', 'http://perlmutter.house.gov/IMA/issue_subscribe.htm', 'RepPerlmutter'),
 295+(412193, 'C001069', 'M', 'Rep. Joe Courtney [D, CT-2]', 'Rep.', 'CT', '2', '202-225-2076', '202-225-4977', 'http://courtney.house.gov/email/', 'connecticutjoe'),
 296+(412194, 'M001169', 'M', 'Rep. Christopher Murphy [D, CT-5]', 'Rep.', 'CT', '5', '202-225-4476', '202-225-5933', 'http://www.house.gov/formchrismurphy/ic_zip_auth.htm', NULL),
 297+(412195, 'C001066', 'F', 'Rep. Kathy Castor [D, FL-11]', 'Rep.', 'FL', '11', '202-225-3376', '202-225-5652', 'https://forms.house.gov/wyr/welcome.shtml', NULL),
 298+(412196, 'B001260', 'M', 'Rep. Vern Buchanan [R, FL-13]', 'Rep.', 'FL', '13', '202-225-5015', '202-226-0828', 'http://buchanan.house.gov/contact.shtml', 'VernBuchanan'),
 299+(412199, 'J000288', 'M', 'Rep. Henry Johnson [D, GA-4]', 'Rep.', 'GA', '4', '202-225-1605', '202-226-0691', 'http://hankjohnson.house.gov/contact_hank_write.shtml', 'RepHankJohnson'),
 300+(412200, 'H001042', 'F', 'Rep. Mazie Hirono [D, HI-2]', 'Rep.', 'HI', '2', '202-225-4906', '202-225-4987', 'http://hirono.house.gov/IMA/issue_subscribe.htm', 'maziehirono'),
 301+(412202, 'R000580', 'M', 'Rep. Peter Roskam [R, IL-6]', 'Rep.', 'IL', '6', '202-225-4561', '202-225-1166', 'http://www.house.gov/writerep', 'PeterRoskam'),
 302+(412205, 'D000607', 'M', 'Rep. Joe Donnelly [D, IN-2]', 'Rep.', 'IN', '2', '202-225-3915', '202-225-6798', 'http://donnelly.house.gov/issue_subscribe.shtml', 'RepDonnelly'),
 303+(412208, 'B001259', 'M', 'Rep. Bruce Braley [D, IA-1]', 'Rep.', 'IA', '1', '202-225-2911', '202-225-6666', 'https://forms.house.gov/braley/webforms/issue_subscribe.html', NULL),
 304+(412209, 'L000565', 'M', 'Rep. David Loebsack [D, IA-2]', 'Rep.', 'IA', '2', '202-225-6576', '202-226-0757', 'http://loebsack.house.gov/contactform/', NULL),
 305+(412211, 'Y000062', 'M', 'Rep. John Yarmuth [D, KY-3]', 'Rep.', 'KY', '3', '202-225-5401', '202-225-5776', 'http://yarmuth.house.gov/?sectionid=68&sectiontree=6,29,68', NULL),
 306+(412212, 'S001168', 'M', 'Rep. John Sarbanes [D, MD-3]', 'Rep.', 'MD', '3', '202-225-4016', '202-225-9219', 'http://sarbanes.house.gov/federal.asp', NULL),
 307+(412213, 'W000798', 'M', 'Rep. Timothy Walberg [R, MI-7]', 'Rep.', 'MI', '7', '202-225-6276', '202-225-6281', 'http://walberg.house.gov/contact/', 'RepWalberg'),
 308+(412214, 'W000799', 'M', 'Rep. Timothy Walz [D, MN-1]', 'Rep.', 'MN', '1', '202-225-2472', '202-225-3433', 'http://walz.house.gov/zip_auth.shtm', NULL),
 309+(412215, 'E000288', 'M', 'Rep. Keith Ellison [D, MN-5]', 'Rep.', 'MN', '5', '202-225-4755', '202-225-4886', 'http://ellison.house.gov/index.php?option=com_content&task=view&id=87', 'keithellison'),
 310+(412216, 'B001256', 'F', 'Rep. Michele Bachmann [R, MN-6]', 'Rep.', 'MN', '6', '202-225-2331', '202-225-6475', 'http://bachmann.house.gov/Email_zip.htm', 'MicheleBachmann'),
 311+(412217, 'S001172', 'M', 'Rep. Adrian Smith [R, NE-3]', 'Rep.', 'NE', '3', '202-225-6435', '202-225-0207', 'http://www.house.gov/formadriansmith/issues_subscribe.htm', NULL),
 312+(412221, 'C001067', 'F', 'Rep. Yvette Clarke [D, NY-11]', 'Rep.', 'NY', '11', '202-225-6231', '202-226-0112', 'http://clarke.house.gov/contactform_zipcheck.shtml', 'YvetteClarke'),
 313+(412225, 'S001171', 'M', 'Rep. Heath Shuler [D, NC-11]', 'Rep.', 'NC', '11', '202-225-6401', '202-226-6422', 'http://shuler.house.gov/zipauth.htm', NULL),
 314+(412226, 'J000289', 'M', 'Rep. Jim Jordan [R, OH-4]', 'Rep.', 'OH', '4', '202-225-2676', '202-226-0577', 'http://jordan.house.gov/contactform_zipcheck.shtml', 'Jim_Jordan'),
 315+(412228, 'S001174', 'F', 'Rep. Betty Sutton [D, OH-13]', 'Rep.', 'OH', '13', '202-225-3401', '202-225-2266', 'http://sutton.house.gov/about/emailform.cfm', NULL),
 316+(412231, 'A000362', 'M', 'Rep. Jason Altmire [D, PA-4]', 'Rep.', 'PA', '4', '202-225-2565', '202-226-2274', 'https://forms.house.gov/altmire/webforms/issue_subscribe.htm', NULL),
 317+(412236, 'C001068', 'M', 'Rep. Steve Cohen [D, TN-9]', 'Rep.', 'TN', '9', '202-225-3265', '202-225-5663', 'http://cohen.house.gov/index.php?option=com_email_form&Itemid=113', 'RepCohen');
 318+INSERT INTO `cl_house` (`clh_id`, `clh_bioguideid`, `clh_gender`, `clh_name`, `clh_title`, `clh_state`, `clh_district`, `clh_phone`, `clh_fax`, `clh_contactform`, `clh_twitter`) VALUES
 319+(412239, 'W000800', 'M', 'Rep. Peter Welch [D, VT-0]', 'Rep.', 'VT', '0', '202-225-4115', '202-225-6790', 'http://www.house.gov/formwelch/issue_subscribe.htm', NULL),
 320+(412250, 'B001257', 'M', 'Rep. Gus Bilirakis [R, FL-9]', 'Rep.', 'FL', '9', '202-225-5755', '202-225-4085', 'http://bilirakis.house.gov/index.php?option=com_content&task=view&id=212&Itemid=44', 'RepGusBilirakis'),
 321+(412252, 'B001262', 'M', 'Rep. Paul Broun [R, GA-10]', 'Rep.', 'GA', '10', '202-225-4101', '202-226-0776', 'http://broun.house.gov/email.shtml', 'RepPaulBrounMD'),
 322+(412253, 'R000581', 'F', 'Rep. Laura Richardson [D, CA-37]', 'Rep.', 'CA', '37', '202-225-7924', '202-225-7926', 'http://richardson.house.gov/IMA/issue_subscribe.htm', NULL),
 323+(412254, 'T000465', 'F', 'Rep. Niki Tsongas [D, MA-5]', 'Rep.', 'MA', '5', '202-225-3411', '202-226-0771', 'http://tsongas.house.gov/?sectionid=11&sectiontree=3,11', 'nikiinthehouse'),
 324+(412255, 'W000804', 'M', 'Rep. Rob Wittman [R, VA-1]', 'Rep.', 'VA', '1', '202-225-4261', '202-225-4382', 'https://forms.house.gov/wittman/IMA/webforms/issue_subscribe.htm', 'RobWittman'),
 325+(412256, 'L000566', 'M', 'Rep. Robert Latta [R, OH-5]', 'Rep.', 'OH', '5', '202-225-6405', '202-225-1985', 'http://latta.house.gov/contactform_zipcheck.shtml', 'boblatta'),
 326+(412258, 'C001072', 'M', 'Rep. André Carson [D, IN-7]', 'Rep.', 'IN', '7', '202-225-4011', '202-225-5633', 'http://carson.house.gov/contact.me.shtml', 'RepAndreCarson'),
 327+(412259, 'S001175', 'F', 'Rep. Jackie Speier [D, CA-12]', 'Rep.', 'CA', '12', '202-225-3531', '202-347-0956', 'http://speier.house.gov/IMA/issue_subscribe.htm', 'RepSpeier'),
 328+(412261, 'S001176', 'M', 'Rep. Steve Scalise [R, LA-1]', 'Rep.', 'LA', '1', '202-225-3015', '202-226-0386', 'http://www.scalise.house.gov/contactform_zipcheck.shtml', NULL),
 329+(412263, 'E000290', 'F', 'Rep. Donna Edwards [D, MD-4]', 'Rep.', 'MD', '4', '202-225-8699', '202-225-8714', 'http://www.house.gov/writerep', NULL),
 330+(412265, 'A000365', 'M', 'Rep. Steve Austria [R, OH-7]', 'Rep.', 'OH', '7', '202-225-4324', '202-225-1984', 'https://forms.house.gov/austria/contact-form.shtml', 'SteveAustria'),
 331+(412269, 'C001075', 'M', 'Rep. Bill Cassidy [R, LA-6]', 'Rep.', 'LA', '6', '202-225-3901', '202-225-7313', 'https://forms.house.gov/cassidy/contact-form.shtml', 'DrCassidy'),
 332+(412270, 'C001076', 'M', 'Rep. Jason Chaffetz [R, UT-3]', 'Rep.', 'UT', '3', '202-225-7751', '202-225-5629', 'https://forms.house.gov/chaffetz/contact-form.shtml', 'jasoninthehouse'),
 333+(412271, 'C001077', 'M', 'Rep. Mike Coffman [R, CO-6]', 'Rep.', 'CO', '6', '202-225-7882', '202-226-4623', 'https://forms.house.gov/coffman/contact-form.shtml', 'RepMikeCoffman'),
 334+(412272, 'C001078', 'M', 'Rep. Gerald Connolly [D, VA-11]', 'Rep.', 'VA', '11', '202-225-1492', '202-225-3071', 'https://forms.house.gov/connolly/contact-form.shtml', NULL),
 335+(412275, 'F000456', 'M', 'Rep. John Fleming [R, LA-4]', 'Rep.', 'LA', '4', '202-225-2777', '202-225-8039', 'https://forms.house.gov/fleming/contact-form.shtml', 'RepFleming'),
 336+(412278, 'G000558', 'M', 'Rep. Brett Guthrie [R, KY-2]', 'Rep.', 'KY', '2', '202-225-3501', '202-226-2019', 'https://forms.house.gov/guthrie/contact-form.shtml', NULL),
 337+(412280, 'H001045', 'M', 'Rep. Gregg Harper [R, MS-3]', 'Rep.', 'MS', '3', '202-225-5031', '202-225-5797', 'http://harper.house.gov/contact/', 'GreggHarper'),
 338+(412281, 'H001046', 'M', 'Rep. Martin Heinrich [D, NM-1]', 'Rep.', 'NM', '1', '202-225-6316', '202-225-4975', 'https://forms.house.gov/heinrich/contact-form.shtml', NULL),
 339+(412282, 'H001047', 'M', 'Rep. James Himes [D, CT-4]', 'Rep.', 'CT', '4', '202-225-5541', '202-225-9629', 'https://forms.house.gov/himes/contact-form.shtml', 'jahimes'),
 340+(412283, 'H001048', 'M', 'Rep. Duncan Hunter [R, CA-52]', 'Rep.', 'CA', '52', '202-225-5672', '202-225-0235', 'https://forms.house.gov/hunter/zipauthen_contact.shtml', 'duncanhunter'),
 341+(412284, 'J000290', 'F', 'Rep. Lynn Jenkins [R, KS-2]', 'Rep.', 'KS', '2', '202-225-6601', '202-225-7986', 'https://forms.house.gov/lynnjenkins/contact-form.shtml', 'RepLynnJenkins'),
 342+(412287, 'K000369', 'M', 'Rep. Larry Kissell [D, NC-8]', 'Rep.', 'NC', '8', '202-225-3715', '202-225-4036', 'https://forms.house.gov/kissell/contact-form.shtml', NULL),
 343+(412290, 'L000567', 'M', 'Rep. Leonard Lance [R, NJ-7]', 'Rep.', 'NJ', '7', '202-225-5361', '202-225-9460', 'https://forms.house.gov/lance/contact-form.shtml', NULL),
 344+(412292, 'L000569', 'M', 'Rep. Blaine Luetkemeyer [R, MO-9]', 'Rep.', 'MO', '9', '202-225-2956', '202-225-5712', 'https://forms.house.gov/luetkemeyer/contact-form.shtml', NULL),
 345+(412293, 'L000570', 'M', 'Rep. Ben Luján [D, NM-3]', 'Rep.', 'NM', '3', '202-225-6190', '202-226-1528', 'https://forms.house.gov/lujan/contact-form.shtml', 'repbenraylujan'),
 346+(412294, 'L000571', 'F', 'Rep. Cynthia Lummis [R, WY-0]', 'Rep.', 'WY', '0', '202-225-2311', '202-225-3057', 'https://forms.house.gov/lummis/contact-form.shtml', 'CynthiaLummis'),
 347+(412295, 'M001177', 'M', 'Rep. Tom McClintock [R, CA-4]', 'Rep.', 'CA', '4', '202-225-2511', '202-225-5444', 'https://forms.house.gov/mcclintock/contact-form.shtml', 'RepMcClintock'),
 348+(412302, 'O000168', 'M', 'Rep. Pete Olson [R, TX-22]', 'Rep.', 'TX', '22', '202-225-5951', '202-225-5241', 'https://forms.house.gov/olson/contact-form.shtml', 'PeteOlson '),
 349+(412303, 'P000594', 'M', 'Rep. Erik Paulsen [R, MN-3]', 'Rep.', 'MN', '3', '202-225-2871', '202-225-6351', 'https://forms.house.gov/paulsen/contact-form.shtml', 'Erik_Paulsen '),
 350+(412305, 'P000595', 'M', 'Rep. Gary Peters [D, MI-9]', 'Rep.', 'MI', '9', '202-225-5802', '202-226-2356', 'https://forms.house.gov/peters/contact-form.shtml', 'RepGaryPeters'),
 351+(412306, 'P000596', 'M', 'Res.Comm. Pedro Pierluisi [D, PR-0]', 'Res.Comm', 'PR', '0', '202-225-2615', '202-225-2154', 'http://pierluisi.house.gov/english/contact-us.html', 'pedropierluisi'),
 352+(412307, 'P000597', 'F', 'Rep. Chellie Pingree [D, ME-1]', 'Rep.', 'ME', '1', '202-225-6116', '202-225-5590', 'https://forms.house.gov/pingree/contact-form.shtml', 'chelliepingree'),
 353+(412308, 'P000598', 'M', 'Rep. Jared Polis [D, CO-2]', 'Rep.', 'CO', '2', '202-225-2161', '202-226-7840', 'http://polis.house.gov/Contact/', 'jaredpolis'),
 354+(412309, 'P000599', 'M', 'Rep. Bill Posey [R, FL-15]', 'Rep.', 'FL', '15', '202-225-3671', '202-225-3516', 'http://posey.house.gov/Contact/', 'congbillposey'),
 355+(412310, 'R000582', 'M', 'Rep. Phil Roe [R, TN-1]', 'Rep.', 'TN', '1', '202-225-6356', '202-225-6356', 'https://forms.house.gov/roe/contact-form.shtml', 'DrPhilRoe'),
 356+(412311, 'R000583', 'M', 'Rep. Thomas Rooney [R, FL-16]', 'Rep.', 'FL', '16', '202-225-5792', '202-225-3132', 'https://forms.house.gov/rooney/contact-form.shtml', 'TomRooney'),
 357+(412312, 'S001177', 'M', 'Del. Gregorio Sablan [D, MP-0]', 'Del.', 'MP', '0', '', '', 'https://forms.house.gov/sablan/contact-form.shtml', NULL),
 358+(412314, 'S001179', 'M', 'Rep. Aaron Schock [R, IL-18]', 'Rep.', 'IL', '18', '202-225-6201', '202-225-9249', 'https://forms.house.gov/schock/contact-form.shtml', 'repaaronschock'),
 359+(412315, 'S001180', 'M', 'Rep. Kurt Schrader [D, OR-5]', 'Rep.', 'OR', '5', '202-225-5711', '202-225-5699', 'https://forms.house.gov/schrader/contact-form.shtml', 'repschrader'),
 360+(412317, 'T000467', 'M', 'Rep. Glenn Thompson [R, PA-5]', 'Rep.', 'PA', '5', '202-225-5121', '202-225-5796', 'https://forms.house.gov/thompson/contact-form.shtml', 'CongressmanGT'),
 361+(412319, 'T000469', 'M', 'Rep. Paul Tonko [D, NY-21]', 'Rep.', 'NY', '21', '202-225-5076', '202-225-5077', 'https://forms.house.gov/tonko/contact-form.shtml', 'paultonko'),
 362+(412327, 'F000455', 'F', 'Rep. Marcia Fudge [D, OH-11]', 'Rep.', 'OH', '11', '202-225-7032', '202-225-1339', 'https://forms.house.gov/fudge/contact-form.shtml', 'mlfudge'),
 363+(412331, 'Q000023', 'M', 'Rep. Mike Quigley [D, IL-5]', 'Rep.', 'IL', '5', '202-225-4061', '202-225-5603', 'https://forms.house.gov/quigley/contact-form.shtml', 'RepMikeQuigley'),
 364+(412379, 'C001080', 'F', 'Rep. Judy Chu [D, CA-32]', 'Rep.', 'CA', '32', '202-225-5464', '202-225-5467', 'https://forms.house.gov/chu/contact-form.shtml', NULL),
 365+(412382, 'G000559', 'M', 'Rep. John Garamendi [D, CA-10]', 'Rep.', 'CA', '10', '202-225-1880', '202-225-5914', 'http://garamendi.house.gov/contact/email-me.shtml', 'RepGaramendi'),
 366+(412383, 'O000169', 'M', 'Rep. William Owens [D, NY-23]', 'Rep.', 'NY', '23', '202-225-4611', '202-226-0621', 'http://owens.house.gov/contact/email-me.shtml', 'BillOwensNY'),
 367+(412385, 'D000610', 'M', 'Rep. Ted Deutch [D, FL-19]', 'Rep.', 'FL', '19', '202-225-3001', '202-225-5974', 'https://teddeutch.house.gov/Forms/WriteYourRep/default.aspx', 'RepTedDeutch'),
 368+(412386, 'C001081', 'M', 'Rep. Mark Critz [D, PA-12]', 'Rep.', 'PA', '12', '202-225-2065', '202-225-5974', 'https://critz.house.gov/contact/email-me.shtml', 'RepMarkCritz'),
 369+(412388, 'G000560', 'M', 'Rep. Tom Graves [R, GA-9]', 'Rep.', 'GA', '9', '202-225-5211', '202-225-8272', 'http://tomgraves.house.gov/contact/', 'RepTomGraves'),
 370+(412392, 'S001188', 'M', 'Rep. Marlin Stutzman [R, IN-3]', 'Rep.', 'IN', '3', '202-225-4436', '202-225-3479', 'http://stutzman.house.gov/contact/', NULL),
 371+(412393, 'R000585', 'M', 'Rep. Tom Reed [R, NY-29]', 'Rep.', 'NY', '29', '202-225-3161', '202-226-6599', 'https://reed.house.gov/contact-me', 'TomReedCongress'),
 372+(412394, 'R000591', 'F', 'Rep. Martha Roby [R, AL-2]', 'Rep.', 'AL', '2', '202-225-2901', '202-225-8913', 'https://roby.house.gov/contact-me/email-me', 'RepMarthaRoby'),
 373+(412395, 'B001274', 'M', 'Rep. Mo Brooks [R, AL-5]', 'Rep.', 'AL', '5', '202-225-4801', '202-225-4392', 'http://brooks.house.gov/contact-me/', 'RepMoBrooks'),
 374+(412396, 'S001185', 'F', 'Rep. Terri Sewell [D, AL-7]', 'Rep.', 'AL', '7', '202-225-2665', '202-226-9567', 'https://sewell.house.gov/contact-me/email-me', NULL),
 375+(412397, 'G000565', 'M', 'Rep. Paul Gosar [R, AZ-1]', 'Rep.', 'AZ', '1', '202-225-2315', '200-226-9739', 'https://gosar.house.gov/contact-me/email-me', 'RepGosar'),
 376+(412398, 'Q000024', 'M', 'Rep. Ben Quayle [R, AZ-3]', 'Rep.', 'AZ', '3', '202-225-3361', '202-225-3462', 'http://quayle.house.gov/index.cfm?sectionid=58', 'benquayle'),
 377+(412399, 'S001183', 'M', 'Rep. David Schweikert [R, AZ-5]', 'Rep.', 'AZ', '5', '202-225-2190', '', 'http://schweikert.house.gov/Contact/', 'RepDavid'),
 378+(412400, 'C001087', 'M', 'Rep. Rick Crawford [R, AR-1]', 'Rep.', 'AR', '1', '202-225-4076', '202-225-5602', 'http://crawford.house.gov/Contact/', NULL),
 379+(412401, 'G000567', 'M', 'Rep. Tim Griffin [R, AR-2]', 'Rep.', 'AR', '2', '202-225-2506', '202-225-5903', 'https://griffin.house.gov/contact-me/email-me', 'RepTimGriffin'),
 380+(412402, 'W000809', 'M', 'Rep. Steve Womack [R, AR-3]', 'Rep.', 'AR', '3', '202-225-4301', '202-225-5713', 'http://womack.house.gov/Contact/', 'rep_stevewomack'),
 381+(412403, 'D000612', 'M', 'Rep. Jeff Denham [R, CA-19]', 'Rep.', 'CA', '19', '202-225-4540', '202-225-3402', 'https://denham.house.gov/contact-me', 'RepJeffDenham'),
 382+(412404, 'B001270', 'F', 'Rep. Karen Bass [D, CA-33]', 'Rep.', 'CA', '33', '202-225-7084', '202- 225-2422', 'https://karenbass.house.gov/contact-me', 'RepKarenBass'),
 383+(412405, 'T000470', 'M', 'Rep. Scott Tipton [R, CO-3]', 'Rep.', 'CO', '3', '202-225-4761', '202-226-9669', 'https://tipton.house.gov/contact-me/email-me', 'RepTipton'),
 384+(412406, 'G000562', 'M', 'Rep. Cory Gardner [R, CO-4]', 'Rep.', 'CO', '4', '202-225-4676', '', 'https://gardner.house.gov/contact-me/email-me', 'RepCory'),
 385+(412407, 'C001083', 'M', 'Rep. John Carney [D, DE-0]', 'Rep.', 'DE', '0', '202-225-4165', '202-225-2291', 'https://forms.house.gov/carney/webforms/email-me.shtml', NULL),
 386+(412408, 'S001186', 'M', 'Rep. Steve Southerland [R, FL-2]', 'Rep.', 'FL', '2', '202-225-5235', '202-225-5615', 'https://southerland.house.gov/index.cfm/email-me', 'Rep_Southerland'),
 387+(412409, 'N000185', 'M', 'Rep. Richard Nugent [R, FL-5]', 'Rep.', 'FL', '5', '202-225-1002', '202- 226-6559', 'https://forms.house.gov/nugent/webforms/zipauthen_contact.shtml', 'RepRichNugent'),
 388+(412410, 'W000806', 'M', 'Rep. Daniel Webster [R, FL-8]', 'Rep.', 'FL', '8', '202-225-2176', '202-225-0999', 'http://webster.house.gov/Contact/', NULL),
 389+(412411, 'R000593', 'M', 'Rep. Dennis Ross [R, FL-12]', 'Rep.', 'FL', '12', '202-225-1252', '202- 226-0585', 'http://dennisross.house.gov/Contact/', 'RepDennisRoss'),
 390+(412412, 'W000808', 'F', 'Rep. Frederica Wilson [D, FL-17]', 'Rep.', 'FL', '17', '202-225-4506', '202-226-0777', 'http://wilson.house.gov/index.cfm?sectionid=3&sectiontree=3', NULL),
 391+(412413, 'W000807', 'M', 'Rep. Allen West [R, FL-22]', 'Rep.', 'FL', '22', '202-225-3026', '202-225-8398', 'https://forms.house.gov/west/webforms/contact-form.shtml', 'AllenWest'),
 392+(412414, 'A000366', 'F', 'Rep. Sandy Adams [R, FL-24]', 'Rep.', 'FL', '24', '202-225-2706', '202-226-6299', 'http://adams.house.gov/Contact/', NULL),
 393+(412415, 'R000590', 'M', 'Rep. David Rivera [R, FL-25]', 'Rep.', 'FL', '25', '202-225-2778', '202-226-0346', 'https://rivera.house.gov/contact-me/email-me', NULL),
 394+(412416, 'W000810', 'M', 'Rep. Rob Woodall [R, GA-7]', 'Rep.', 'GA', '7', '202-225-4272', '202-225-4696', 'https://woodall.house.gov/contact-me/email-me', NULL),
 395+(412417, 'S001189', 'M', 'Rep. Austin Scott [R, GA-8]', 'Rep.', 'GA', '8', '202-225-6531', '202-225-3013', 'http://austinscott.house.gov/index.php?option=com_content&view=article&id=4195&Itemid=300112', NULL),
 396+(412418, 'H001050', 'F', 'Rep. Colleen Hanabusa [D, HI-1]', 'Rep.', 'HI', '1', '202-225-2726', '202-225-4580', 'https://hanabusa.house.gov/contact-me/email-me', 'RepHanabusa'),
 397+(412419, 'L000573', 'M', 'Rep. Raúl Labrador [R, ID-1]', 'Rep.', 'ID', '1', '202-225-6611', '202-225-3029', 'https://labradorforms.house.gov/index.cfm?sectionid=58&sectiontree=3,58', NULL),
 398+(412420, 'D000613', 'M', 'Rep. Bob Dold [R, IL-10]', 'Rep.', 'IL', '10', '202-225-4835', '202-225-0837', 'https://dold.house.gov/contact-me/email-me', 'RepDold'),
 399+(412421, 'K000378', 'M', 'Rep. Adam Kinzinger [R, IL-11]', 'Rep.', 'IL', '11', '202-225-3635', '202- 225-3521', 'https://kinzingerforms.house.gov/index.cfm?sectionid=58&sectiontree=3,58', NULL),
 400+(412422, 'H001059', 'M', 'Rep. Randy Hultgren [R, IL-14]', 'Rep.', 'IL', '14', '202-225-2976', '202- 225-0697', 'https://hultgrenforms.house.gov/index.cfm?sectionid=89', 'RepHultgren'),
 401+(412423, 'S001182', 'M', 'Rep. Robert Schilling [R, IL-17]', 'Rep.', 'IL', '17', '202-225-5905', '202- 225-5396', 'http://schilling.house.gov/Contact/', 'RepSchilling'),
 402+(412424, 'W000811', 'M', 'Rep. Joe Walsh [R, IL-8]', 'Rep.', 'IL', '8', '202-225-3711', '202-225-7830', 'https://walsh.house.gov/contact-me', 'RepJoeWalsh'),
 403+(412426, 'R000592', 'M', 'Rep. Todd Rokita [R, IN-4]', 'Rep.', 'IN', '4', '202-225-5037', '', 'https://rokita.house.gov/contact-me/email-me', 'ToddRokita'),
 404+(412427, 'B001275', 'M', 'Rep. Larry Bucshon [R, IN-8]', 'Rep.', 'IN', '8', '202-225-4636', '202-225-3284', 'https://bucshon.house.gov/contact-me/email-me', 'RepLarryBucshon'),
 405+(412428, 'Y000064', 'M', 'Rep. Todd Young [R, IN-9]', 'Rep.', 'IN', '9', '202-225-5315', '202-226-6866', 'http://toddyoung.house.gov/index.cfm?sectionid=114', NULL),
 406+(412429, 'H001057', 'M', 'Rep. Tim Huelskamp [R, KS-1]', 'Rep.', 'KS', '1', '202-225-2715', '202- 225-5124', 'https://forms.house.gov/huelskamp/webforms/zipauthen_contact.shtml', 'CongHuelskamp'),
 407+(412430, 'Y000063', 'M', 'Rep. Kevin Yoder [R, KS-3]', 'Rep.', 'KS', '3', '202-225-2865', '202- 225-2807', 'https://yoderforms.house.gov/email-me', 'KevinYoder'),
 408+(412431, 'P000602', 'M', 'Rep. Mike Pompeo [R, KS-4]', 'Rep.', 'KS', '4', '202-225-6216', '202-225-3489', 'https://pompeo.house.gov/contact-me/email-me', NULL),
 409+(412432, 'R000588', 'M', 'Rep. Cedric Richmond [D, LA-2]', 'Rep.', 'LA', '2', '202-225-6636', '202- 225-1988', 'https://richmond.house.gov/contact-me/', NULL),
 410+(412433, 'L000574', 'M', 'Rep. Jeff Landry [R, LA-3]', 'Rep.', 'LA', '3', '202-225-4031', '202- 226-3944', 'https://landry.house.gov/contact-me', 'repjefflandry'),
 411+(412434, 'H001052', 'M', 'Rep. Andy Harris [R, MD-1]', 'Rep.', 'MD', '1', '202-225-5311', '202-225-0254', 'https://harris.house.gov/contact-me', NULL),
 412+(412435, 'K000375', 'M', 'Rep. William Keating [D, MA-10]', 'Rep.', 'MA', '10', '202-225-3111', '202- 225-5658', 'https://forms.house.gov/keating/webforms/contact.shtml', NULL),
 413+(412436, 'B001271', 'M', 'Rep. Dan Benishek [R, MI-1]', 'Rep.', 'MI', '1', '202-225-4735', '202- 225-4744', 'https://benishek.house.gov/contact-me/email-me', NULL),
 414+(412437, 'H001058', 'M', 'Rep. Bill Huizenga [R, MI-2]', 'Rep.', 'MI', '2', '202-225-4401', '202- 226-0779', 'http://huizenga.house.gov/Contact/', 'RepHuizenga'),
 415+(412438, 'A000367', 'M', 'Rep. Justin Amash [R, MI-3]', 'Rep.', 'MI', '3', '202-225-3831', '202-225-5144', 'https://amash.house.gov/contact-me/email-me', 'repjustinamash'),
 416+(412440, 'C001085', 'M', 'Rep. Hansen Clarke [D, MI-13]', 'Rep.', 'MI', '13', '202-225-2261', '202-225-5730', 'https://hansenclarke.house.gov/contact-me/email-me', NULL),
 417+(412441, 'C001086', 'M', 'Rep. Chip Cravaack [R, MN-8]', 'Rep.', 'MN', '8', '202-225-6211', '202- 225-6211', 'https://cravaackforms.house.gov/index.cfm?sectionid=58&sectiontree=3,58', 'RepChipCravaack'),
 418+(412442, 'N000186', 'M', 'Rep. Alan Nunnelee [R, MS-1]', 'Rep.', 'MS', '1', '202-225-4306', '202- 225-3549', 'http://nunnelee.house.gov/index.cfm?sectionid=58&sectiontree=3,58', 'RepAlanNunnelee'),
 419+(412443, 'P000601', 'M', 'Rep. Steven Palazzo [R, MS-4]', 'Rep.', 'MS', '4', '202-225-5772', '202- 225-7074', 'https://palazzo.house.gov/contact-me/email-me', NULL),
 420+(412444, 'H001053', 'F', 'Rep. Vicky Hartzler [R, MO-4]', 'Rep.', 'MO', '4', '202-225-2876', '202- 225-2695', 'https://hartzler.house.gov/contact-me/email-me', NULL),
 421+(412445, 'L000576', 'M', 'Rep. Billy Long [R, MO-7]', 'Rep.', 'MO', '7', '202-225-6536', '202-225-5604', 'https://longforms.house.gov/index.cfm?sectionid=58&sectiontree=3,58', NULL),
 422+(412446, 'H001055', 'M', 'Rep. Joe Heck [R, NV-3]', 'Rep.', 'NV', '3', '202-225-3252', '202- 225-2185', 'https://heck.house.gov/contact-me/email-me', 'RepJoeHeck'),
 423+(412447, 'G000570', 'M', 'Rep. Frank Guinta [R, NH-1]', 'Rep.', 'NH', '1', '202-225-5456', '202-225-5822', 'https://guinta.house.gov/contact-me/email-me', 'RepFrankGuinta'),
 424+(412449, 'R000594', 'M', 'Rep. Jon Runyan [R, NJ-3]', 'Rep.', 'NJ', '3', '202-225-4765', '202-225-0778', 'http://runyan.house.gov/contact-me/email-me', NULL),
 425+(412451, 'G000569', 'M', 'Rep. Michael Grimm [R, NY-13]', 'Rep.', 'NY', '13', '202-225-3371', '202- 226-1272', 'https://grimm.house.gov/contact-me', NULL),
 426+(412452, 'H001054', 'F', 'Rep. Nan Hayworth [R, NY-19]', 'Rep.', 'NY', '19', '202-225-5441', '202- 225-3289', 'https://hayworthforms.house.gov/contact', 'RepNanHayworth'),
 427+(412453, 'G000564', 'M', 'Rep. Chris Gibson [R, NY-20]', 'Rep.', 'NY', '20', '202-225-5614', '202-225-1168', 'http://gibson.house.gov/Contact/', 'RepChrisGibson'),
 428+(412454, 'H001051', 'M', 'Rep. Richard Hanna [R, NY-24]', 'Rep.', 'NY', '24', '202-225-3665', '202-225-1891', 'https://forms.house.gov/hanna/webforms/zipauthen_contact.shtml', 'RepRichardHanna'),
 429+(412456, 'B001276', 'F', 'Rep. Ann Marie Buerkle [R, NY-25]', 'Rep.', 'NY', '25', '202-225-3701', '202-225-4042', 'https://buerkle.house.gov/contact-me/email-me', 'RepBuerkle'),
 430+(412457, 'E000291', 'F', 'Rep. Renee Ellmers [R, NC-2]', 'Rep.', 'NC', '2', '202-225-4531', '202- 225-5662 ', 'https://ellmersforms.house.gov/index.cfm?sectionid=58&sectiontree=3,58', NULL),
 431+(412458, 'B001272', 'M', 'Rep. Rick Berg [R, ND-0]', 'Rep.', 'ND', '0', '202-225-2611', '202-226-0893', 'https://bergforms.house.gov/email-rick', 'RepRickBerg'),
 432+(412460, 'J000292', 'M', 'Rep. Bill Johnson [R, OH-6]', 'Rep.', 'OH', '6', '202-225-5705', '202-225-5907', 'http://billjohnson.house.gov/Contact/', 'RepBillJohnson'),
 433+(412461, 'S001187', 'M', 'Rep. Steve Stivers [R, OH-15]', 'Rep.', 'OH', '15', '202-225-2015', '202-225-3529', 'http://stivers.house.gov/Contact/', 'RepSteveStivers'),
 434+(412462, 'R000586', 'M', 'Rep. Jim Renacci [R, OH-16]', 'Rep.', 'OH', '16', '202-225-3876', '202-225-3059', 'http://renacci.house.gov/index.cfm?sectionid=58&sectiontree=3,58', 'RepJimRenacci'),
 435+(412463, 'G000563', 'M', 'Rep. Bob Gibbs [R, OH-18]', 'Rep.', 'OH', '18', '202-225-6265', '202-225-3394', 'https://gibbs.house.gov/contact-me/email-me', 'RepBobGibbs'),
 436+(412464, 'L000575', 'M', 'Rep. James Lankford [R, OK-5]', 'Rep.', 'OK', '5', '202-225-2132', '202-226-1463', 'https://forms.house.gov/lankford/webforms/zipauthen_contact.shtml', 'RepLankford'),
 437+(412465, 'K000376', 'M', 'Rep. Mike Kelly [R, PA-3]', 'Rep.', 'PA', '3', '202-225-5406', '202-225-3103', 'https://kelly.house.gov/contact-me/email-me', NULL),
 438+(412466, 'M001181', 'M', 'Rep. Patrick Meehan [R, PA-7]', 'Rep.', 'PA', '7', '202-225-2011', '202- 226-0280', 'https://meehanforms.house.gov/email-me', 'RepMeehan'),
 439+(412468, 'M001179', 'M', 'Rep. Thomas Marino [R, PA-10]', 'Rep.', 'PA', '10', '202-225-3731', '202-225-9594 ', 'https://marino.house.gov/contact-me/email-me', 'RepTomMarino'),
 440+(412469, 'B001269', 'M', 'Rep. Lou Barletta [R, PA-11]', 'Rep.', 'PA', '11', '202-225-6511', '202-225-0764', 'https://barlettaforms.house.gov/index.cfm?sectionid=58&sectiontree=3,58', 'RepLouBarletta'),
 441+(412470, 'C001084', 'M', 'Rep. David Cicilline [D, RI-1]', 'Rep.', 'RI', '1', '202-225-4911', '202- 225-3290', 'https://cicilline.house.gov/contact-me/email-me', NULL),
 442+(412471, 'S001184', 'M', 'Rep. Tim Scott [R, SC-1]', 'Rep.', 'SC', '1', '202-225-3176', '202-225-3407', 'http://timscott.house.gov/Contact/', 'RepTimScott'),
 443+(412472, 'D000615', 'M', 'Rep. Jeff Duncan [R, SC-3]', 'Rep.', 'SC', '3', '202-225-3365', '202- 225-3216', 'https://jeffduncan.house.gov/contact-me/email-me', NULL),
 444+(412473, 'G000566', 'M', 'Rep. Trey Gowdy [R, SC-4]', 'Rep.', 'SC', '4', '202-225-6030', '202-226-1177', 'http://gowdy.house.gov/Contact/', 'TGowdySC'),
 445+(412474, 'M001182', 'M', 'Rep. Mick Mulvaney [R, SC-5]', 'Rep.', 'SC', '5', '202-225-5501', '202-225-0464', 'http://mulvaney.house.gov/Contact/', 'RepMickMulvaney'),
 446+(412475, 'N000184', 'F', 'Rep. Kristi Noem [R, SD-0]', 'Rep.', 'SD', '0', '202-225-2801', '202-225-5823', 'http://noem.house.gov/index.cfm/email-kristi', 'RepKristiNoem'),
 447+(412476, 'F000459', 'M', 'Rep. Chuck Fleischmann [R, TN-3]', 'Rep.', 'TN', '3', '202-225-3271', '202-225-3494', 'https://fleischmann.house.gov/contact-me/email-me', 'RepChuck'),
 448+(412477, 'D000616', 'M', 'Rep. Scott DesJarlais [R, TN-4]', 'Rep.', 'TN', '4', '202-225-6831', '202-226-5172', 'https://desjarlais.house.gov/contact-me/email-me', 'DesJarlaisTN04'),
 449+(412478, 'B001273', 'F', 'Rep. Diane Black [R, TN-6]', 'Rep.', 'TN', '6', '202-225-4231', '202- 225-6887', 'https://black.house.gov/contact-me/email-me', 'DianeBlackTN06'),
 450+(412479, 'F000458', 'M', 'Rep. Stephen Fincher [R, TN-8]', 'Rep.', 'TN', '8', '202-225-4714', '202-225-1765', 'https://fincher.house.gov/contact-me/email-me', NULL),
 451+(412480, 'F000461', 'M', 'Rep. Bill Flores [R, TX-17]', 'Rep.', 'TX', '17', '202-225-6105', '202-225-0350', 'http://flores.house.gov/index.cfm?sectionid=58&sectiontree=3,58', 'RepFlores'),
 452+(412481, 'C001082', 'M', 'Rep. Francisco Canseco [R, TX-23]', 'Rep.', 'TX', '23', '202-225-4511', '202-225-2237', 'http://franciscocanseco.house.gov/contact/', 'RepCanseco'),
 453+(412482, 'F000460', 'M', 'Rep. Blake Farenthold [R, TX-27]', 'Rep.', 'TX', '27', '202-225-7742', '202-226-1134', 'https://forms.house.gov/farenthold/webforms/zipauthen_contact.shtml', NULL),
 454+(412483, 'R000589', 'M', 'Rep. Scott Rigell [R, VA-2]', 'Rep.', 'VA', '2', '202-225-4215', '202-225-4218', 'http://rigell.house.gov/Contact/', 'RepScottRigell'),
 455+(412484, 'H001060', 'M', 'Rep. Robert Hurt [R, VA-5]', 'Rep.', 'VA', '5', '202-225-4711', '202-225-5681', 'https://hurt.house.gov/contact-me/email-me', 'RepRobertHurt'),
 456+(412485, 'G000568', 'M', 'Rep. Morgan Griffith [R, VA-9]', 'Rep.', 'VA', '9', '202-225-3861', '202- 225-0076', 'http://morgangriffith.house.gov/Contact/', 'RepMGriffith'),
 457+(412486, 'H001056', 'F', 'Rep. Jaime Herrera Beutler [R, WA-3]', 'Rep.', 'WA', '3', '202-225-3536', '202-225-3478', 'http://herrerabeutler.house.gov/Contact/', NULL),
 458+(412487, 'M001180', 'M', 'Rep. David McKinley [R, WV-1]', 'Rep.', 'WV', '1', '202-225-4172', '202-225-7564', 'https://mckinleyforms.house.gov/index.cfm?sectionid=58&sectiontree=3,58', 'RepMcKinley'),
 459+(412488, 'D000614', 'M', 'Rep. Sean Duffy [R, WI-7]', 'Rep.', 'WI', '7', '202-225-3365', '', 'https://duffy.house.gov/contact-me/email-me', 'RepSeanDuffy'),
 460+(412489, 'R000587', 'M', 'Rep. Reid Ribble [R, WI-8]', 'Rep.', 'WI', '8', '202-225-5665', '202- 225-5729', 'https://ribble.house.gov/contact-me/email-me', 'RepRibble'),
 461+(412497, 'H001062', 'F', 'Rep. Kathleen Hochul [D, NY-26]', 'Rep.', 'NY', '26', '202-225-5265', '', 'https://hochul.house.gov/contact-me/email-me', NULL),
 462+(412498, 'H001063', 'F', 'Rep. Janice Hahn [D, CA-36]', 'Rep.', 'CA', '36', '202-225-8220', '202-226-7290', 'https://hahn.house.gov/contact-me/email-me', NULL),
 463+(412499, 'T000471', 'M', 'Rep. Robert Turner [R, NY-9]', 'Rep.', 'NY', '9', '202-225-6616', '202-226-0218', 'https://bobturner.house.gov/contact-me', 'RepMikeTurner'),
 464+(412500, 'A000369', 'M', 'Rep. Mark Amodei [R, NV-2]', 'Rep.', 'NV', '2', '202-225-6155', '202-225-5679', 'https://amodei.house.gov/contact-me', NULL);
Index: trunk/extensions/CongressLookup/data/cl_zip3.sql
——@@ -19,7 +19,7 @@
2020 -- Dumping data for table `cl_zip3`
2121 --
2222
23 -INSERT INTO `cl_zip3` (`sz3_zip`, `sz3_state`) VALUES
 23+INSERT INTO `cl_zip3` (`clz3_zip`, `clz3_state`) VALUES
2424 (5, 'NY'),
2525 (6, 'PR'),
2626 (7, 'PR'),
Index: trunk/extensions/CongressLookup/data/cl_zip5.sql
——@@ -19,7 +19,7 @@
2020 -- Dumping data for table `cl_zip5`
2121 --
2222
23 -INSERT INTO `cl_zip5` (`sz5_zip`, `sz5_rep_id`) VALUES
 23+INSERT INTO `cl_zip5` (`clz5_zip`, `clz5_rep_id`) VALUES
2424 (501, NULL),
2525 (544, NULL),
2626 (601, 412306),
——@@ -7138,7 +7138,7 @@
71397139 (17569, 400320),
71407140 (17570, 400320),
71417141 (17572, 400320);
7142 -INSERT INTO `cl_zip5` (`sz5_zip`, `sz5_rep_id`) VALUES
 7142+INSERT INTO `cl_zip5` (`clz5_zip`, `clz5_rep_id`) VALUES
71437143 (17573, NULL),
71447144 (17575, NULL),
71457145 (17576, 400320),
——@@ -14005,7 +14005,7 @@
1400614006 (32254, 400048),
1400714007 (32255, NULL),
1400814008 (32256, 400273);
14009 -INSERT INTO `cl_zip5` (`sz5_zip`, `sz5_rep_id`) VALUES
 14009+INSERT INTO `cl_zip5` (`clz5_zip`, `clz5_rep_id`) VALUES
1401014010 (32257, 400086),
1401114011 (32258, 400086),
1401214012 (32259, 400273),
——@@ -20840,7 +20840,7 @@
2084120841 (47654, 412427),
2084220842 (47660, 412427),
2084320843 (47665, 412427);
20844 -INSERT INTO `cl_zip5` (`sz5_zip`, `sz5_rep_id`) VALUES
 20844+INSERT INTO `cl_zip5` (`clz5_zip`, `clz5_rep_id`) VALUES
2084520845 (47666, 412427),
2084620846 (47670, 412427),
2084720847 (47683, 412427),
——@@ -27573,7 +27573,7 @@
2757427574 (62275, 400373),
2757527575 (62277, 400082),
2757627576 (62278, 400082);
27577 -INSERT INTO `cl_zip5` (`sz5_zip`, `sz5_rep_id`) VALUES
 27577+INSERT INTO `cl_zip5` (`clz5_zip`, `clz5_rep_id`) VALUES
2757827578 (62279, 400082),
2757927579 (62280, 400082),
2758027580 (62281, 400082),
——@@ -34339,7 +34339,7 @@
3434034340 (77641, NULL),
3434134341 (77642, 400652),
3434234342 (77643, NULL);
34343 -INSERT INTO `cl_zip5` (`sz5_zip`, `sz5_rep_id`) VALUES
 34343+INSERT INTO `cl_zip5` (`clz5_zip`, `clz5_rep_id`) VALUES
3434434344 (77650, 400311),
3434534345 (77651, 400652),
3434634346 (77655, 400636),
——@@ -41239,7 +41239,7 @@
4124041240 (96827, NULL),
4124141241 (96828, NULL),
4124241242 (96830, NULL);
41243 -INSERT INTO `cl_zip5` (`sz5_zip`, `sz5_rep_id`) VALUES
 41243+INSERT INTO `cl_zip5` (`clz5_zip`, `clz5_rep_id`) VALUES
4124441244 (96835, NULL),
4124541245 (96836, NULL),
4124641246 (96837, NULL),
Index: trunk/extensions/CongressLookup/data/cl_senate.sql
——@@ -3,7 +3,7 @@
44 -- http://www.phpmyadmin.net
55 --
66 -- Host: 127.0.0.1
 7+-- Generation Time: Jan 16, 2012 at 06:02 PM
78 -- Server version: 5.1.47
89 -- PHP Version: 5.3.6
910
——@@ -19,104 +19,104 @@
2020 -- Dumping data for table `cl_senate`
2121 --
2222
23 -INSERT INTO `cl_senate` (`ss_id`, `ss_bioguideid`, `ss_gender`, `ss_name`, `ss_title`, `ss_state`, `ss_phone`, `ss_fax`, `ss_contactform`) VALUES
24 -(300001, 'A000069', 'M', 'Sen. Daniel Akaka [D, HI]', 'Sen.', 'HI', '202-224-6361', '202-224-2126', 'http://www.akaka.senate.gov/email-senator-akaka.cfm'),
25 -(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'),
26 -(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'),
27 -(300009, 'B000468', 'M', 'Sen. Jeff Bingaman [D, NM]', 'Sen.', 'NM', '202-224-5521', '202-224-2852', 'http://www.bingaman.senate.gov/contact/'),
28 -(300011, 'B000711', 'F', 'Sen. Barbara Boxer [D, CA]', 'Sen.', 'CA', '202-224-3553', '202-224-0454', 'http://www.boxer.senate.gov/en/contact/'),
29 -(300018, 'C000127', 'F', 'Sen. Maria Cantwell [D, WA]', 'Sen.', 'WA', '202-224-3441', '202-228-0514', 'http://www.cantwell.senate.gov/contact/'),
30 -(300019, 'C000174', 'M', 'Sen. Thomas Carper [D, DE]', 'Sen.', 'DE', '202-224-2441', '202-228-2190', 'http://www.carper.senate.gov/contact/'),
31 -(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'),
32 -(300023, 'C000567', 'M', 'Sen. Thad Cochran [R, MS]', 'Sen.', 'MS', '202-224-5054', '202-224-9450', 'http://www.cochran.senate.gov/email.html'),
33 -(300025, 'C001035', 'F', 'Sen. Susan Collins [R, ME]', 'Sen.', 'ME', '202-224-2523', '202-224-2693', 'http://www.collins.senate.gov/public/continue.cfm?FuseAction=ContactSenatorCollins.EmailIssue'),
34 -(300026, 'C000705', 'M', 'Sen. Kent Conrad [D, ND]', 'Sen.', 'ND', '202-224-2043', '202-224-7776', 'http://www.conrad.senate.gov/contact/webform.cfm'),
35 -(300027, 'C001056', 'M', 'Sen. John Cornyn [R, TX]', 'Sen.', 'TX', '202-224-2934', '202-228-2856', 'http://www.cornyn.senate.gov/public/index.cfm?p=ContactForm'),
36 -(300030, 'C000880', 'M', 'Sen. Michael Crapo [R, ID]', 'Sen.', 'ID', '202-224-6142', '202-228-1375', 'http://www.crapo.senate.gov/contact/email.cfm'),
37 -(300038, 'D000563', 'M', 'Sen. Richard Durbin [D, IL]', 'Sen.', 'IL', '202-224-2152', '202-228-0400', 'http://www.durbin.senate.gov/public/index.cfm/contact'),
38 -(300041, 'E000285', 'M', 'Sen. Michael Enzi [R, WY]', 'Sen.', 'WY', '202-224-3424', '202-228-0359', 'http://www.enzi.senate.gov/public/index.cfm/contact?p=e-mail-senator-enzi'),
39 -(300043, 'F000062', 'F', 'Sen. Dianne Feinstein [D, CA]', 'Sen.', 'CA', '202-224-3841', '202-228-3954', 'http://www.feinstein.senate.gov/public/index.cfm/e-mail-me'),
40 -(300047, 'G000359', 'M', 'Sen. Lindsey Graham [R, SC]', 'Sen.', 'SC', '202-224-5972', '202-224-3808', 'http://www.lgraham.senate.gov/public/index.cfm?FuseAction=Contact.EmailSenatorGraham'),
41 -(300048, 'G000386', 'M', 'Sen. Charles Grassley [R, IA]', 'Sen.', 'IA', '202-224-3744', '202-224-6020', 'http://www.grassley.senate.gov/contact.cfm'),
42 -(300051, 'H000206', 'M', 'Sen. Thomas Harkin [D, IA]', 'Sen.', 'IA', '202-224-3254', '202-224-9369', 'http://www.harkin.senate.gov/contact.cfm'),
43 -(300052, 'H000338', 'M', 'Sen. Orrin Hatch [R, UT]', 'Sen.', 'UT', '202-224-5251', '202-224-6331', 'http://www.hatch.senate.gov/public/index.cfm/contact?p=Email-Orrin'),
44 -(300054, 'H001016', 'F', 'Sen. Kay Hutchison [R, TX]', 'Sen.', 'TX', '202-224-5922', '202-224-0776', 'http://www.hutchison.senate.gov/?p=email_kay'),
45 -(300055, 'I000024', 'M', 'Sen. James Inhofe [R, OK]', 'Sen.', 'OK', '202-224-4721', '202-228-0380', 'http://www.inhofe.senate.gov/public/index.cfm?FuseAction=Contact.ContactForm'),
46 -(300056, 'I000025', 'M', 'Sen. Daniel Inouye [D, HI]', 'Sen.', 'HI', '202-224-3934', '202-224-6747', 'http://www.inouye.senate.gov/Contact/ContactDKI.cfm'),
47 -(300058, 'J000177', 'M', 'Sen. Tim Johnson [D, SD]', 'Sen.', 'SD', '202-224-5842', '202-228-5765', 'http://www.johnson.senate.gov/public/index.cfm?p=Contact'),
48 -(300060, 'K000148', 'M', 'Sen. John Kerry [D, MA]', 'Sen.', 'MA', '202-224-2742', '202-224-8525', 'http://www.kerry.senate.gov/contact/'),
49 -(300061, 'K000305', 'M', 'Sen. Herbert Kohl [D, WI]', 'Sen.', 'WI', '202-224-5653', '202-224-9787', 'http://www.kohl.senate.gov/contact.cfm'),
50 -(300062, 'K000352', 'M', 'Sen. Jon Kyl [R, AZ]', 'Sen.', 'AZ', '202-224-4521', '202-224-2207', 'http://www.kyl.senate.gov/contact.cfm'),
51 -(300063, 'L000550', 'F', 'Sen. Mary Landrieu [D, LA]', 'Sen.', 'LA', '202-224-5824', '202-224-9735', 'http://www.landrieu.senate.gov/about/contact.cfm'),
52 -(300064, 'L000123', 'M', 'Sen. Frank Lautenberg [D, NJ]', 'Sen.', 'NJ', '202-224-3224', '202-228-4054', 'http://www.lautenberg.senate.gov/contact/routing.cfm'),
53 -(300065, 'L000174', 'M', 'Sen. Patrick Leahy [D, VT]', 'Sen.', 'VT', '202-224-4242', '202-224-3479', 'http://www.leahy.senate.gov/contact/'),
54 -(300066, 'L000261', 'M', 'Sen. Carl Levin [D, MI]', 'Sen.', 'MI', '202-224-6221', '202-224-1388', 'http://www.levin.senate.gov/contact/'),
55 -(300067, 'L000304', 'M', 'Sen. Joseph Lieberman [I, CT]', 'Sen.', 'CT', '202-224-4041', '202-224-9750', 'http://www.lieberman.senate.gov/index.cfm/contact/email-me-about-an-issue'),
56 -(300070, 'L000504', 'M', 'Sen. Richard Lugar [R, IN]', 'Sen.', 'IN', '202-224-4814', '202-228-0360', 'http://www.lugar.senate.gov/contact/'),
57 -(300071, 'M000303', 'M', 'Sen. John McCain [R, AZ]', 'Sen.', 'AZ', '202-224-2235', '202-228-2862', 'http://www.mccain.senate.gov/public/index.cfm?FuseAction=Contact.ContactForm'),
58 -(300072, 'M000355', 'M', 'Sen. Mitch McConnell [R, KY]', 'Sen.', 'KY', '202-224-2541', '202-224-2499', 'http://www.mcconnell.senate.gov/public/index.cfm?p=contact'),
59 -(300073, 'M000702', 'F', 'Sen. Barbara Mikulski [D, MD]', 'Sen.', 'MD', '202-224-4654', '202-224-8858', 'http://www.mikulski.senate.gov/contact/'),
60 -(300075, 'M001153', 'F', 'Sen. Lisa Murkowski [R, AK]', 'Sen.', 'AK', '202-224-6665', '202-224-5301', 'http://www.murkowski.senate.gov/public/index.cfm?p=Contact'),
61 -(300076, 'M001111', 'F', 'Sen. Patty Murray [D, WA]', 'Sen.', 'WA', '202-224-2621', '202-224-0238', 'http://www.murray.senate.gov/email/index.cfm'),
62 -(300077, 'N000180', 'M', 'Sen. Ben Nelson [D, NE]', 'Sen.', 'NE', '202-224-6551', '202-228-0012', 'http://www.bennelson.senate.gov/contact-me.cfm'),
63 -(300078, 'N000032', 'M', 'Sen. Bill Nelson [D, FL]', 'Sen.', 'FL', '202-224-5274', '202-228-2183', 'http://www.billnelson.senate.gov/contact/index.cfm'),
64 -(300080, 'P000590', 'M', 'Sen. Mark Pryor [D, AR]', 'Sen.', 'AR', '202-224-2353', '202-228-0908', 'http://www.pryor.senate.gov/public/index.cfm?p=ContactMe'),
65 -(300081, 'R000122', 'M', 'Sen. John Reed [D, RI]', 'Sen.', 'RI', '202-224-4642', '202-224-4680', 'http://www.reed.senate.gov/contact/'),
66 -(300082, 'R000146', 'M', 'Sen. Harry Reid [D, NV]', 'Sen.', 'NV', '202-224-3542', '202-224-7327', 'http://www.reid.senate.gov/contact/index.cfm'),
67 -(300083, 'R000307', 'M', 'Sen. Pat Roberts [R, KS]', 'Sen.', 'KS', '202-224-4774', '202-224-3514', 'http://www.roberts.senate.gov/public/index.cfm?p=EmailPat'),
68 -(300084, 'R000361', 'M', 'Sen. John Rockefeller [D, WV]', 'Sen.', 'WV', '202-224-6472', '202-224-7665', 'http://www.rockefeller.senate.gov/contact/email.cfm'),
69 -(300087, 'S000148', 'M', 'Sen. Charles Schumer [D, NY]', 'Sen.', 'NY', '202-224-6542', '202-228-3027', 'http://www.schumer.senate.gov/Contact/contact_chuck.cfm'),
70 -(300088, 'S001141', 'M', 'Sen. Jefferson Sessions [R, AL]', 'Sen.', 'AL', '202-224-4124', '202-224-3149', 'http://www.sessions.senate.gov/public/index.cfm?FuseAction=ConstituentServices.ContactMe'),
71 -(300089, 'S000320', 'M', 'Sen. Richard Shelby [R, AL]', 'Sen.', 'AL', '202-224-5744', '202-224-3416', 'http://www.shelby.senate.gov/public/index.cfm/emailsenatorshelby'),
72 -(300091, 'S000663', 'F', 'Sen. Olympia Snowe [R, ME]', 'Sen.', 'ME', '202-224-5344', '202-224-1946', 'http://www.snowe.senate.gov/public/index.cfm/contact?p=email'),
73 -(300093, 'S000770', 'F', 'Sen. Debbie Ann Stabenow [D, MI]', 'Sen.', 'MI', '202-224-4822', '202-228-0325', 'http://www.stabenow.senate.gov/?p=contact'),
74 -(300100, 'W000779', 'M', 'Sen. Ron Wyden [D, OR]', 'Sen.', 'OR', '202-224-5244', '202-228-2717', 'http://www.wyden.senate.gov/contact/'),
75 -(400034, 'B000575', 'M', 'Sen. Roy Blunt [R, MO]', 'Sen.', 'MO', '202-224-5721', '', 'http://www.blunt.senate.gov/public/index.cfm/contact-form?p=contact-roy'),
76 -(400040, 'B001236', 'M', 'Sen. John Boozman [R, AR]', 'Sen.', 'AR', '202-224-4843', '', 'http://www.boozman.senate.gov/public/index.cfm/e-mail-me'),
77 -(400050, 'B000944', 'M', 'Sen. Sherrod Brown [D, OH]', 'Sen.', 'OH', '202-224-2315', '202-228-6321', 'http://www.brown.senate.gov/contact/'),
78 -(400054, 'B001135', 'M', 'Sen. Richard Burr [R, NC]', 'Sen.', 'NC', '202-224-3154', '202-228-2981', 'http://www.burr.senate.gov/public/index.cfm?FuseAction=Contact.ContactForm'),
79 -(400064, 'C000141', 'M', 'Sen. Benjamin Cardin [D, MD]', 'Sen.', 'MD', '202-224-4524', '202-224-1651', 'http://www.cardin.senate.gov/contact/'),
80 -(400105, 'D000595', 'M', 'Sen. Jim DeMint [R, SC]', 'Sen.', 'SC', '202-224-6121', '202-228-5143', 'http://www.demint.senate.gov/public/index.cfm?p=ContactInformation'),
81 -(400194, 'I000055', 'M', 'Sen. John Isakson [R, GA]', 'Sen.', 'GA', '202-224-3643', '202-228-0724', 'http://www.isakson.senate.gov/contact.cfm'),
82 -(400222, 'K000360', 'M', 'Sen. Mark Kirk [R, IL]', 'Sen.', 'IL', '202-224-2854', '', 'http://www.kirk.senate.gov/?p=contact'),
83 -(400272, 'M000639', 'M', 'Sen. Robert Menéndez [D, NJ]', 'Sen.', 'NJ', '202-224-4744', '202-228-2197', 'http://menendez.senate.gov/contact/'),
84 -(400284, 'M000934', 'M', 'Sen. Jerry Moran [R, KS]', 'Sen.', 'KS', '202-224-6521', '', 'http://www.moran.senate.gov/public/index.cfm?p=e-mail-jerry'),
85 -(400325, 'P000449', 'M', 'Sen. Robert Portman [R, OH]', 'Sen.', 'OH', '202-224-3353', '', 'http://www.portman.senate.gov/public/index.cfm/contact?p=contact-form'),
86 -(400357, 'S000033', 'M', 'Sen. Bernard Sanders [I, VT]', 'Sen.', 'VT', '202-224-5141', '202-228-0776', 'http://www.sanders.senate.gov/contact/'),
87 -(400408, 'T000461', 'M', 'Sen. Patrick Toomey [R, PA]', 'Sen.', 'PA', '202-224-4254', '', 'http://www.toomey.senate.gov/?p=contact'),
88 -(400412, 'U000038', 'M', 'Sen. Mark Udall [D, CO]', 'Sen.', 'CO', '202-224-5941', '202-226-7840', 'http://www.markudall.senate.gov/?p=contact'),
89 -(400413, 'U000039', 'M', 'Sen. Tom Udall [D, NM]', 'Sen.', 'NM', '202-224-6621', '202-226-1331', 'http://www.tomudall.senate.gov/?p=contact'),
90 -(400418, 'V000127', 'M', 'Sen. David Vitter [R, LA]', 'Sen.', 'LA', '202-224-4623', '202-228-5061', 'http://www.vitter.senate.gov/public/index.cfm?FuseAction=Contact.ContactForm'),
91 -(400432, 'W000437', 'M', 'Sen. Roger Wicker [R, MS]', 'Sen.', 'MS', '202-224-6253', '202-228-0378', 'http://www.wicker.senate.gov/public/index.cfm?FuseAction=Contact.EMailSenatorWicker'),
92 -(400546, 'T000250', 'M', 'Sen. John Thune [R, SD]', 'Sen.', 'SD', '202-224-2321', '202-228-5429', 'http://www.thune.senate.gov/public/index.cfm/contact'),
93 -(400576, 'C000560', 'M', 'Sen. Thomas Coburn [R, OK]', 'Sen.', 'OK', '202-224-5754', '202-224-6008', 'http://www.coburn.senate.gov/public/index.cfm/contactsenatorcoburn?p=ContactForm'),
94 -(402675, 'C000542', 'M', 'Sen. Daniel Coats [R, IN]', 'Sen.', 'IN', '202-224-5623', '', 'http://www.coats.senate.gov/contact/'),
95 -(412218, 'H001041', 'M', 'Sen. Dean Heller [R, NV]', 'Sen.', 'NV', '202-224-6244', '', 'http://www.heller.senate.gov/public/index.cfm/contact-form'),
96 -(412223, 'G000555', 'F', 'Sen. Kirsten Gillibrand [D, NY]', 'Sen.', 'NY', '202-224-4451', '202-225-1168', 'http://www.gillibrand.senate.gov/contact/'),
97 -(412242, 'K000367', 'F', 'Sen. Amy Klobuchar [D, MN]', 'Sen.', 'MN', '202-224-3244', '202-228-2186', 'http://www.klobuchar.senate.gov/emailamy.cfm'),
98 -(412243, 'M001170', 'F', 'Sen. Claire McCaskill [D, MO]', 'Sen.', 'MO', '202-224-6154', '202-228-6326', 'http://www.mccaskill.senate.gov/?p=contact'),
99 -(412244, 'T000464', 'M', 'Sen. Jon Tester [D, MT]', 'Sen.', 'MT', '202-224-2644', '202-224-8594', 'http://www.tester.senate.gov/Contact/index.cfm'),
100 -(412246, 'C001070', 'M', 'Sen. Robert Casey [D, PA]', 'Sen.', 'PA', '202-224-6324', '202-228-0604', 'http://www.casey.senate.gov/contact/'),
101 -(412247, 'W000802', 'M', 'Sen. Sheldon Whitehouse [D, RI]', 'Sen.', 'RI', '202-224-2921', '202-228-6362', 'http://www.whitehouse.senate.gov/contact/'),
102 -(412248, 'C001071', 'M', 'Sen. Bob Corker [R, TN]', 'Sen.', 'TN', '202-224-3344', '202-228-0566', 'http://www.corker.senate.gov/public/index.cfm?p=ContactMe'),
103 -(412249, 'W000803', 'M', 'Sen. Jim Webb [D, VA]', 'Sen.', 'VA', '202-224-4024', '202-228-6363', 'http://www.webb.senate.gov/contact.cfm'),
104 -(412251, 'B001261', 'M', 'Sen. John Barrasso [R, WY]', 'Sen.', 'WY', '202-224-6441', '202-224-1724', 'http://www.barrasso.senate.gov/public/index.cfm?FuseAction=ContactUs.ContactForm'),
105 -(412320, 'J000291', 'M', 'Sen. Mike Johanns [R, NE]', 'Sen.', 'NE', '202-224-4224', '202-228-0436', 'http://www.johanns.senate.gov/public/?p=ContactSenatorJohanns'),
106 -(412321, 'W000805', 'M', 'Sen. Mark Warner [D, VA]', 'Sen.', 'VA', '202-224-2023', '202-224-6295', 'http://www.warner.senate.gov/public/index.cfm?p=Contact'),
107 -(412322, 'R000584', 'M', 'Sen. James Risch [R, ID]', 'Sen.', 'ID', '202-224-2752', '202-224-2573', 'http://www.risch.senate.gov/public/index.cfm?p=Email'),
108 -(412323, 'S001181', 'F', 'Sen. Jeanne Shaheen [D, NH]', 'Sen.', 'NH', '202-224-2841', '', 'http://www.shaheen.senate.gov/contact/'),
109 -(412324, 'H001049', 'F', 'Sen. Kay Hagan [D, NC]', 'Sen.', 'NC', '202-224-6342', '202-228-2563', 'http://www.hagan.senate.gov/?p=contact'),
110 -(412325, 'M001176', 'M', 'Sen. Jeff Merkley [D, OR]', 'Sen.', 'OR', '202-224-3753', '202-228-3997', 'http://www.merkley.senate.gov/contact/'),
111 -(412326, 'B001265', 'M', 'Sen. Mark Begich [D, AK]', 'Sen.', 'AK', '202-224-3004', '202-224-2354', 'http://www.begich.senate.gov/public/index.cfm?p=EmailSenator'),
112 -(412330, 'B001267', 'M', 'Sen. Michael Bennet [D, CO]', 'Sen.', 'CO', '202-224-5852', '202-228-5036', 'http://www.bennet.senate.gov/contact/'),
113 -(412378, 'F000457', 'M', 'Sen. Al Franken [D, MN]', 'Sen.', 'MN', '202-224-5641', '', 'http://www.franken.senate.gov/?p=contact'),
114 -(412384, 'B001268', 'M', 'Sen. Scott Brown [R, MA]', 'Sen.', 'MA', '202-224-4543', '', 'http://www.scottbrown.senate.gov/public/index.cfm/emailscottbrown'),
115 -(412390, 'C001088', 'M', 'Sen. Chris Coons [D, DE]', 'Sen.', 'DE', '202-224-5042', '', 'http://www.coons.senate.gov/contact/'),
116 -(412391, 'M001183', 'M', 'Sen. Joe Manchin [D, WV]', 'Sen.', 'WV', '202-224-3954', '', 'http://www.manchin.senate.gov/contact_form.cfm'),
117 -(412490, 'B001277', 'M', 'Sen. Richard Blumenthal [D, CT]', 'Sen.', 'CT', '202-224-2823', '', 'http://www.blumenthal.senate.gov/contact/'),
118 -(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'),
119 -(412492, 'P000603', 'M', 'Sen. Rand Paul [R, KY]', 'Sen.', 'KY', '202-224-4343', '', 'http://www.paul.senate.gov/?p=contact'),
120 -(412493, 'A000368', 'F', 'Sen. Kelly Ayotte [R, NH]', 'Sen.', 'NH', '202-224-3324', '', 'http://www.ayotte.senate.gov/?p=contact'),
121 -(412494, 'H001061', 'M', 'Sen. John Hoeven [R, ND]', 'Sen.', 'ND', '202-224-2551', '', 'http://www.hoeven.senate.gov/public/index.cfm/email-the-senator'),
122 -(412495, 'L000577', 'M', 'Sen. Mike Lee [R, UT]', 'Sen.', 'UT', '202-224-5444', '', 'http://www.lee.senate.gov/public/index.cfm/contact'),
123 -(412496, 'J000293', 'M', 'Sen. Ron Johnson [R, WI]', 'Sen.', 'WI', '202-224-5323', '', 'http://www.ronjohnson.senate.gov/public/index.cfm/contact');
 23+INSERT INTO `cl_senate` (`cls_id`, `cls_bioguideid`, `cls_gender`, `cls_name`, `cls_title`, `cls_state`, `cls_phone`, `cls_fax`, `cls_contactform`, `cls_twitter`) VALUES
 24+(300001, 'A000069', 'M', 'Sen. Daniel Akaka [D, HI]', 'Sen.', 'HI', '202-224-6361', '202-224-2126', 'http://www.akaka.senate.gov/email-senator-akaka.cfm', NULL),
 25+(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'),
 26+(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),
 27+(300009, 'B000468', 'M', 'Sen. Jeff Bingaman [D, NM]', 'Sen.', 'NM', '202-224-5521', '202-224-2852', 'http://www.bingaman.senate.gov/contact/', NULL),
 28+(300011, 'B000711', 'F', 'Sen. Barbara Boxer [D, CA]', 'Sen.', 'CA', '202-224-3553', '202-224-0454', 'http://www.boxer.senate.gov/en/contact/', 'Barbara_Boxer'),
 29+(300018, 'C000127', 'F', 'Sen. Maria Cantwell [D, WA]', 'Sen.', 'WA', '202-224-3441', '202-228-0514', 'http://www.cantwell.senate.gov/contact/', NULL),
 30+(300019, 'C000174', 'M', 'Sen. Thomas Carper [D, DE]', 'Sen.', 'DE', '202-224-2441', '202-228-2190', 'http://www.carper.senate.gov/contact/', NULL),
 31+(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),
 32+(300023, 'C000567', 'M', 'Sen. Thad Cochran [R, MS]', 'Sen.', 'MS', '202-224-5054', '202-224-9450', 'http://www.cochran.senate.gov/email.html', NULL),
 33+(300025, 'C001035', 'F', 'Sen. Susan Collins [R, ME]', 'Sen.', 'ME', '202-224-2523', '202-224-2693', 'http://www.collins.senate.gov/public/continue.cfm?FuseAction=ContactSenatorCollins.EmailIssue', 'senatorcollins'),
 34+(300026, 'C000705', 'M', 'Sen. Kent Conrad [D, ND]', 'Sen.', 'ND', '202-224-2043', '202-224-7776', 'http://www.conrad.senate.gov/contact/webform.cfm', NULL),
 35+(300027, 'C001056', 'M', 'Sen. John Cornyn [R, TX]', 'Sen.', 'TX', '202-224-2934', '202-228-2856', 'http://www.cornyn.senate.gov/public/index.cfm?p=ContactForm', 'JohnCornyn'),
 36+(300030, 'C000880', 'M', 'Sen. Michael Crapo [R, ID]', 'Sen.', 'ID', '202-224-6142', '202-228-1375', 'http://www.crapo.senate.gov/contact/email.cfm', NULL),
 37+(300038, 'D000563', 'M', 'Sen. Richard Durbin [D, IL]', 'Sen.', 'IL', '202-224-2152', '202-228-0400', 'http://www.durbin.senate.gov/public/index.cfm/contact', 'dickdurbin'),
 38+(300041, 'E000285', 'M', 'Sen. Michael Enzi [R, WY]', 'Sen.', 'WY', '202-224-3424', '202-228-0359', 'http://www.enzi.senate.gov/public/index.cfm/contact?p=e-mail-senator-enzi', NULL),
 39+(300043, 'F000062', 'F', 'Sen. Dianne Feinstein [D, CA]', 'Sen.', 'CA', '202-224-3841', '202-228-3954', 'http://www.feinstein.senate.gov/public/index.cfm/e-mail-me', NULL),
 40+(300047, 'G000359', 'M', 'Sen. Lindsey Graham [R, SC]', 'Sen.', 'SC', '202-224-5972', '202-224-3808', 'http://www.lgraham.senate.gov/public/index.cfm?FuseAction=Contact.EmailSenatorGraham', 'GrahamBlog'),
 41+(300048, 'G000386', 'M', 'Sen. Charles Grassley [R, IA]', 'Sen.', 'IA', '202-224-3744', '202-224-6020', 'http://www.grassley.senate.gov/contact.cfm', 'ChuckGrassley'),
 42+(300051, 'H000206', 'M', 'Sen. Thomas Harkin [D, IA]', 'Sen.', 'IA', '202-224-3254', '202-224-9369', 'http://www.harkin.senate.gov/contact.cfm', 'SenatorHarkin'),
 43+(300052, 'H000338', 'M', 'Sen. Orrin Hatch [R, UT]', 'Sen.', 'UT', '202-224-5251', '202-224-6331', 'http://www.hatch.senate.gov/public/index.cfm/contact?p=Email-Orrin', 'OrrinHatch'),
 44+(300054, 'H001016', 'F', 'Sen. Kay Hutchison [R, TX]', 'Sen.', 'TX', '202-224-5922', '202-224-0776', 'http://www.hutchison.senate.gov/?p=email_kay', 'kaybaileyhutch'),
 45+(300055, 'I000024', 'M', 'Sen. James Inhofe [R, OK]', 'Sen.', 'OK', '202-224-4721', '202-228-0380', 'http://www.inhofe.senate.gov/public/index.cfm?FuseAction=Contact.ContactForm', 'jiminhofe'),
 46+(300056, 'I000025', 'M', 'Sen. Daniel Inouye [D, HI]', 'Sen.', 'HI', '202-224-3934', '202-224-6747', 'http://www.inouye.senate.gov/Contact/ContactDKI.cfm', NULL),
 47+(300058, 'J000177', 'M', 'Sen. Tim Johnson [D, SD]', 'Sen.', 'SD', '202-224-5842', '202-228-5765', 'http://www.johnson.senate.gov/public/index.cfm?p=Contact', 'SenJohnsonSD'),
 48+(300060, 'K000148', 'M', 'Sen. John Kerry [D, MA]', 'Sen.', 'MA', '202-224-2742', '202-224-8525', 'http://www.kerry.senate.gov/contact/', 'JohnKerry'),
 49+(300061, 'K000305', 'M', 'Sen. Herbert Kohl [D, WI]', 'Sen.', 'WI', '202-224-5653', '202-224-9787', 'http://www.kohl.senate.gov/contact.cfm', NULL),
 50+(300062, 'K000352', 'M', 'Sen. Jon Kyl [R, AZ]', 'Sen.', 'AZ', '202-224-4521', '202-224-2207', 'http://www.kyl.senate.gov/contact.cfm', 'SenJonKyl'),
 51+(300063, 'L000550', 'F', 'Sen. Mary Landrieu [D, LA]', 'Sen.', 'LA', '202-224-5824', '202-224-9735', 'http://www.landrieu.senate.gov/about/contact.cfm', NULL),
 52+(300064, 'L000123', 'M', 'Sen. Frank Lautenberg [D, NJ]', 'Sen.', 'NJ', '202-224-3224', '202-228-4054', 'http://www.lautenberg.senate.gov/contact/routing.cfm', NULL),
 53+(300065, 'L000174', 'M', 'Sen. Patrick Leahy [D, VT]', 'Sen.', 'VT', '202-224-4242', '202-224-3479', 'http://www.leahy.senate.gov/contact/', 'SenatorLeahy'),
 54+(300066, 'L000261', 'M', 'Sen. Carl Levin [D, MI]', 'Sen.', 'MI', '202-224-6221', '202-224-1388', 'http://www.levin.senate.gov/contact/', NULL),
 55+(300067, 'L000304', 'M', 'Sen. Joseph Lieberman [I, CT]', 'Sen.', 'CT', '202-224-4041', '202-224-9750', 'http://www.lieberman.senate.gov/index.cfm/contact/email-me-about-an-issue', 'JoeLieberman'),
 56+(300070, 'L000504', 'M', 'Sen. Richard Lugar [R, IN]', 'Sen.', 'IN', '202-224-4814', '202-228-0360', 'http://www.lugar.senate.gov/contact/', 'senatorlugar'),
 57+(300071, 'M000303', 'M', 'Sen. John McCain [R, AZ]', 'Sen.', 'AZ', '202-224-2235', '202-228-2862', 'http://www.mccain.senate.gov/public/index.cfm?FuseAction=Contact.ContactForm', 'SenJohnMccain'),
 58+(300072, 'M000355', 'M', 'Sen. Mitch McConnell [R, KY]', 'Sen.', 'KY', '202-224-2541', '202-224-2499', 'http://www.mcconnell.senate.gov/public/index.cfm?p=contact', NULL),
 59+(300073, 'M000702', 'F', 'Sen. Barbara Mikulski [D, MD]', 'Sen.', 'MD', '202-224-4654', '202-224-8858', 'http://www.mikulski.senate.gov/contact/', NULL),
 60+(300075, 'M001153', 'F', 'Sen. Lisa Murkowski [R, AK]', 'Sen.', 'AK', '202-224-6665', '202-224-5301', 'http://www.murkowski.senate.gov/public/index.cfm?p=Contact', 'lisamurkowski'),
 61+(300076, 'M001111', 'F', 'Sen. Patty Murray [D, WA]', 'Sen.', 'WA', '202-224-2621', '202-224-0238', 'http://www.murray.senate.gov/email/index.cfm', 'PattyMurray'),
 62+(300077, 'N000180', 'M', 'Sen. Ben Nelson [D, NE]', 'Sen.', 'NE', '202-224-6551', '202-228-0012', 'http://www.bennelson.senate.gov/contact-me.cfm', 'SenBenNelson'),
 63+(300078, 'N000032', 'M', 'Sen. Bill Nelson [D, FL]', 'Sen.', 'FL', '202-224-5274', '202-228-2183', 'http://www.billnelson.senate.gov/contact/index.cfm', 'SenBillNelson'),
 64+(300080, 'P000590', 'M', 'Sen. Mark Pryor [D, AR]', 'Sen.', 'AR', '202-224-2353', '202-228-0908', 'http://www.pryor.senate.gov/public/index.cfm?p=ContactMe', NULL),
 65+(300081, 'R000122', 'M', 'Sen. John Reed [D, RI]', 'Sen.', 'RI', '202-224-4642', '202-224-4680', 'http://www.reed.senate.gov/contact/', NULL),
 66+(300082, 'R000146', 'M', 'Sen. Harry Reid [D, NV]', 'Sen.', 'NV', '202-224-3542', '202-224-7327', 'http://www.reid.senate.gov/contact/index.cfm', 'SenatorReid'),
 67+(300083, 'R000307', 'M', 'Sen. Pat Roberts [R, KS]', 'Sen.', 'KS', '202-224-4774', '202-224-3514', 'http://www.roberts.senate.gov/public/index.cfm?p=EmailPat', 'SenPatRoberts'),
 68+(300084, 'R000361', 'M', 'Sen. John Rockefeller [D, WV]', 'Sen.', 'WV', '202-224-6472', '202-224-7665', 'http://www.rockefeller.senate.gov/contact/email.cfm', NULL),
 69+(300087, 'S000148', 'M', 'Sen. Charles Schumer [D, NY]', 'Sen.', 'NY', '202-224-6542', '202-228-3027', 'http://www.schumer.senate.gov/Contact/contact_chuck.cfm', NULL),
 70+(300088, 'S001141', 'M', 'Sen. Jefferson Sessions [R, AL]', 'Sen.', 'AL', '202-224-4124', '202-224-3149', 'http://www.sessions.senate.gov/public/index.cfm?FuseAction=ConstituentServices.ContactMe', 'SenatorSessions'),
 71+(300089, 'S000320', 'M', 'Sen. Richard Shelby [R, AL]', 'Sen.', 'AL', '202-224-5744', '202-224-3416', 'http://www.shelby.senate.gov/public/index.cfm/emailsenatorshelby', 'RichardShelby'),
 72+(300091, 'S000663', 'F', 'Sen. Olympia Snowe [R, ME]', 'Sen.', 'ME', '202-224-5344', '202-224-1946', 'http://www.snowe.senate.gov/public/index.cfm/contact?p=email', 'senatorsnowe'),
 73+(300093, 'S000770', 'F', 'Sen. Debbie Ann Stabenow [D, MI]', 'Sen.', 'MI', '202-224-4822', '202-228-0325', 'http://www.stabenow.senate.gov/?p=contact', 'StabenowPress'),
 74+(300100, 'W000779', 'M', 'Sen. Ron Wyden [D, OR]', 'Sen.', 'OR', '202-224-5244', '202-228-2717', 'http://www.wyden.senate.gov/contact/', 'RonWyden'),
 75+(400034, 'B000575', 'M', 'Sen. Roy Blunt [R, MO]', 'Sen.', 'MO', '202-224-5721', '', 'http://www.blunt.senate.gov/public/index.cfm/contact-form?p=contact-roy', 'RoyBlunt'),
 76+(400040, 'B001236', 'M', 'Sen. John Boozman [R, AR]', 'Sen.', 'AR', '202-224-4843', '', 'http://www.boozman.senate.gov/public/index.cfm/e-mail-me', 'JohnBoozman'),
 77+(400050, 'B000944', 'M', 'Sen. Sherrod Brown [D, OH]', 'Sen.', 'OH', '202-224-2315', '202-228-6321', 'http://www.brown.senate.gov/contact/', 'SenSherrodBrown'),
 78+(400054, 'B001135', 'M', 'Sen. Richard Burr [R, NC]', 'Sen.', 'NC', '202-224-3154', '202-228-2981', 'http://www.burr.senate.gov/public/index.cfm?FuseAction=Contact.ContactForm', 'burrforsenate'),
 79+(400064, 'C000141', 'M', 'Sen. Benjamin Cardin [D, MD]', 'Sen.', 'MD', '202-224-4524', '202-224-1651', 'http://www.cardin.senate.gov/contact/', 'SenatorCardin'),
 80+(400105, 'D000595', 'M', 'Sen. Jim DeMint [R, SC]', 'Sen.', 'SC', '202-224-6121', '202-228-5143', 'http://www.demint.senate.gov/public/index.cfm?p=ContactInformation', 'jimdemint'),
 81+(400194, 'I000055', 'M', 'Sen. John Isakson [R, GA]', 'Sen.', 'GA', '202-224-3643', '202-228-0724', 'http://www.isakson.senate.gov/contact.cfm', NULL),
 82+(400222, 'K000360', 'M', 'Sen. Mark Kirk [R, IL]', 'Sen.', 'IL', '202-224-2854', '', 'http://www.kirk.senate.gov/?p=contact', 'markkirk'),
 83+(400272, 'M000639', 'M', 'Sen. Robert Menéndez [D, NJ]', 'Sen.', 'NJ', '202-224-4744', '202-228-2197', 'http://menendez.senate.gov/contact/', 'senatormenendez'),
 84+(400284, 'M000934', 'M', 'Sen. Jerry Moran [R, KS]', 'Sen.', 'KS', '202-224-6521', '', 'http://www.moran.senate.gov/public/index.cfm?p=e-mail-jerry', 'JerryMoran'),
 85+(400325, 'P000449', 'M', 'Sen. Robert Portman [R, OH]', 'Sen.', 'OH', '202-224-3353', '', 'http://www.portman.senate.gov/public/index.cfm/contact?p=contact-form', 'robportman'),
 86+(400357, 'S000033', 'M', 'Sen. Bernard Sanders [I, VT]', 'Sen.', 'VT', '202-224-5141', '202-228-0776', 'http://www.sanders.senate.gov/contact/', 'senatorsanders'),
 87+(400408, 'T000461', 'M', 'Sen. Patrick Toomey [R, PA]', 'Sen.', 'PA', '202-224-4254', '', 'http://www.toomey.senate.gov/?p=contact', NULL),
 88+(400412, 'U000038', 'M', 'Sen. Mark Udall [D, CO]', 'Sen.', 'CO', '202-224-5941', '202-226-7840', 'http://www.markudall.senate.gov/?p=contact', 'MarkUdall'),
 89+(400413, 'U000039', 'M', 'Sen. Tom Udall [D, NM]', 'Sen.', 'NM', '202-224-6621', '202-226-1331', 'http://www.tomudall.senate.gov/?p=contact', 'SenatorTomUdall'),
 90+(400418, 'V000127', 'M', 'Sen. David Vitter [R, LA]', 'Sen.', 'LA', '202-224-4623', '202-228-5061', 'http://www.vitter.senate.gov/public/index.cfm?FuseAction=Contact.ContactForm', 'DavidVitter'),
 91+(400432, 'W000437', 'M', 'Sen. Roger Wicker [R, MS]', 'Sen.', 'MS', '202-224-6253', '202-228-0378', 'http://www.wicker.senate.gov/public/index.cfm?FuseAction=Contact.EMailSenatorWicker', 'rogerwicker'),
 92+(400546, 'T000250', 'M', 'Sen. John Thune [R, SD]', 'Sen.', 'SD', '202-224-2321', '202-228-5429', 'http://www.thune.senate.gov/public/index.cfm/contact', 'johnthune'),
 93+(400576, 'C000560', 'M', 'Sen. Thomas Coburn [R, OK]', 'Sen.', 'OK', '202-224-5754', '202-224-6008', 'http://www.coburn.senate.gov/public/index.cfm/contactsenatorcoburn?p=ContactForm', 'TomCoburn'),
 94+(402675, 'C000542', 'M', 'Sen. Daniel Coats [R, IN]', 'Sen.', 'IN', '202-224-5623', '', 'http://www.coats.senate.gov/contact/', 'SenDanCoats'),
 95+(412218, 'H001041', 'M', 'Sen. Dean Heller [R, NV]', 'Sen.', 'NV', '202-224-6244', '', 'http://www.heller.senate.gov/public/index.cfm/contact-form', 'DeanHeller'),
 96+(412223, 'G000555', 'F', 'Sen. Kirsten Gillibrand [D, NY]', 'Sen.', 'NY', '202-224-4451', '202-225-1168', 'http://www.gillibrand.senate.gov/contact/', 'SenGillibrand'),
 97+(412242, 'K000367', 'F', 'Sen. Amy Klobuchar [D, MN]', 'Sen.', 'MN', '202-224-3244', '202-228-2186', 'http://www.klobuchar.senate.gov/emailamy.cfm', NULL),
 98+(412243, 'M001170', 'F', 'Sen. Claire McCaskill [D, MO]', 'Sen.', 'MO', '202-224-6154', '202-228-6326', 'http://www.mccaskill.senate.gov/?p=contact', 'clairecmc'),
 99+(412244, 'T000464', 'M', 'Sen. Jon Tester [D, MT]', 'Sen.', 'MT', '202-224-2644', '202-224-8594', 'http://www.tester.senate.gov/Contact/index.cfm', NULL),
 100+(412246, 'C001070', 'M', 'Sen. Robert Casey [D, PA]', 'Sen.', 'PA', '202-224-6324', '202-228-0604', 'http://www.casey.senate.gov/contact/', NULL),
 101+(412247, 'W000802', 'M', 'Sen. Sheldon Whitehouse [D, RI]', 'Sen.', 'RI', '202-224-2921', '202-228-6362', 'http://www.whitehouse.senate.gov/contact/', NULL),
 102+(412248, 'C001071', 'M', 'Sen. Bob Corker [R, TN]', 'Sen.', 'TN', '202-224-3344', '202-228-0566', 'http://www.corker.senate.gov/public/index.cfm?p=ContactMe', 'SenBobCorker'),
 103+(412249, 'W000803', 'M', 'Sen. Jim Webb [D, VA]', 'Sen.', 'VA', '202-224-4024', '202-228-6363', 'http://www.webb.senate.gov/contact.cfm', NULL),
 104+(412251, 'B001261', 'M', 'Sen. John Barrasso [R, WY]', 'Sen.', 'WY', '202-224-6441', '202-224-1724', 'http://www.barrasso.senate.gov/public/index.cfm?FuseAction=ContactUs.ContactForm', 'SenJohnBarrasso'),
 105+(412320, 'J000291', 'M', 'Sen. Mike Johanns [R, NE]', 'Sen.', 'NE', '202-224-4224', '202-228-0436', 'http://www.johanns.senate.gov/public/?p=ContactSenatorJohanns', 'Mike_Johanns'),
 106+(412321, 'W000805', 'M', 'Sen. Mark Warner [D, VA]', 'Sen.', 'VA', '202-224-2023', '202-224-6295', 'http://www.warner.senate.gov/public/index.cfm?p=Contact', 'markwarner'),
 107+(412322, 'R000584', 'M', 'Sen. James Risch [R, ID]', 'Sen.', 'ID', '202-224-2752', '202-224-2573', 'http://www.risch.senate.gov/public/index.cfm?p=Email', NULL),
 108+(412323, 'S001181', 'F', 'Sen. Jeanne Shaheen [D, NH]', 'Sen.', 'NH', '202-224-2841', '', 'http://www.shaheen.senate.gov/contact/', 'JeanneShaheen'),
 109+(412324, 'H001049', 'F', 'Sen. Kay Hagan [D, NC]', 'Sen.', 'NC', '202-224-6342', '202-228-2563', 'http://www.hagan.senate.gov/?p=contact', 'SenatorHagan'),
 110+(412325, 'M001176', 'M', 'Sen. Jeff Merkley [D, OR]', 'Sen.', 'OR', '202-224-3753', '202-228-3997', 'http://www.merkley.senate.gov/contact/', 'senjeffmerkley'),
 111+(412326, 'B001265', 'M', 'Sen. Mark Begich [D, AK]', 'Sen.', 'AK', '202-224-3004', '202-224-2354', 'http://www.begich.senate.gov/public/index.cfm?p=EmailSenator', 'SenMarkBegich'),
 112+(412330, 'B001267', 'M', 'Sen. Michael Bennet [D, CO]', 'Sen.', 'CO', '202-224-5852', '202-228-5036', 'http://www.bennet.senate.gov/contact/', 'SenBennetCO'),
 113+(412378, 'F000457', 'M', 'Sen. Al Franken [D, MN]', 'Sen.', 'MN', '202-224-5641', '', 'http://www.franken.senate.gov/?p=contact', 'alfranken'),
 114+(412384, 'B001268', 'M', 'Sen. Scott Brown [R, MA]', 'Sen.', 'MA', '202-224-4543', '', 'http://www.scottbrown.senate.gov/public/index.cfm/emailscottbrown', 'USSenScottBrown'),
 115+(412390, 'C001088', 'M', 'Sen. Chris Coons [D, DE]', 'Sen.', 'DE', '202-224-5042', '', 'http://www.coons.senate.gov/contact/', NULL),
 116+(412391, 'M001183', 'M', 'Sen. Joe Manchin [D, WV]', 'Sen.', 'WV', '202-224-3954', '', 'http://www.manchin.senate.gov/contact_form.cfm', 'Sen_JoeManchin'),
 117+(412490, 'B001277', 'M', 'Sen. Richard Blumenthal [D, CT]', 'Sen.', 'CT', '202-224-2823', '', 'http://www.blumenthal.senate.gov/contact/', NULL),
 118+(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'),
 119+(412492, 'P000603', 'M', 'Sen. Rand Paul [R, KY]', 'Sen.', 'KY', '202-224-4343', '', 'http://www.paul.senate.gov/?p=contact', 'SenRandPaul'),
 120+(412493, 'A000368', 'F', 'Sen. Kelly Ayotte [R, NH]', 'Sen.', 'NH', '202-224-3324', '', 'http://www.ayotte.senate.gov/?p=contact', NULL),
 121+(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),
 122+(412495, 'L000577', 'M', 'Sen. Mike Lee [R, UT]', 'Sen.', 'UT', '202-224-5444', '', 'http://www.lee.senate.gov/public/index.cfm/contact', NULL),
 123+(412496, 'J000293', 'M', 'Sen. Ron Johnson [R, WI]', 'Sen.', 'WI', '202-224-5323', '', 'http://www.ronjohnson.senate.gov/public/index.cfm/contact', 'SenRonJohnson');

Follow-up revisions

RevisionCommit summaryAuthorDate
r109121adding db prefixeskaldari08:45, 17 January 2012

Comments

#Comment by NeilK (talk | contribs)   07:24, 17 January 2012

should have used standard database prefixes, but this is okay for these special circumstances (SOPA Blackout)

#Comment by NeilK (talk | contribs)   08:49, 17 January 2012

Actually... it's not ok. Fixed in 109121

Status & tagging log