r109327 MediaWiki - Code Review archive

Repository:MediaWiki
Revision:< r109326‎ | r109327 | r109328 >
Date:06:54, 18 January 2012
Author:raindrift
Status:ok
Tags:
Comment:
Added second batch of corrected data, per Soli et al
up to line 99
followup to r109285
Modified paths:
  • /trunk/extensions/CongressLookup/data/cl_house.sql (modified) (history)

Diff [purge]

Index: trunk/extensions/CongressLookup/data/cl_house.sql
——@@ -58,15 +58,15 @@
5959 (400108, 'D000600', 'M', 'Rep. Mario Diaz-Balart [R, FL-21]', 'Rep.', 'FL', '21', '202-225-4211', '202-225-8576', 'https://writerep.house.gov/writerep/welcome.shtml', 'MarioDB'),
6060 (400109, 'D000327', 'M', 'Rep. Norman Dicks [D, WA-6]', 'Rep.', 'WA', '6', '202-225-5916', '202-226-1176', 'http://www.house.gov/dicks/newemail.shtml', 'RepNormDicks'),
6161 (400110, 'D000355', 'M', 'Rep. John Dingell [D, MI-15]', 'Rep.', 'MI', '15', '202-225-4071', '202-226-0371', 'https://dingell.house.gov/contact/email-me.shtml', 'john_dingell'),
62 -(400111, 'D000399', 'M', 'Rep. Lloyd Doggett [D, TX-25]', 'Rep.', 'TX', '25', '202-225-4865', '202-225-3073', 'http://forms.house.gov/doggett/webforms/issue_subscribe.htm', NULL),
 62+(400111, 'D000399', 'M', 'Rep. Lloyd Doggett [D, TX-25]', 'Rep.', 'TX', '25', '202-225-4865', '202-225-3073', 'http://forms.house.gov/doggett/webforms/issue_subscribe.htm', 'RepLloydDoggett'),
6363 (400114, 'D000482', 'M', 'Rep. Michael Doyle [D, PA-14]', 'Rep.', 'PA', '14', '202-225-2135', '202-225-3084', 'https://doyle.house.gov/contact/email-me.shtml', 'USRepMikeDoyle'),
6464 (400115, 'D000492', 'M', 'Rep. David Dreier [R, CA-26]', 'Rep.', 'CA', '26', '202-225-2305', '202-225-7018', 'http://dreier.house.gov/contact.shtml', NULL),
6565 (400116, 'D000533', 'M', 'Rep. John Duncan [R, TN-2]', 'Rep.', 'TN', '2', '202-225-5435', '202-225-6440', 'http://duncan.house.gov/services/zip-auth.shtml', NULL),
66 -(400121, 'E000172', 'F', 'Rep. Jo Ann Emerson [R, MO-8]', 'Rep.', 'MO', '8', '202-225-4404', '202-226-0326', 'https://forms.house.gov/emerson/webforms/contact.html', 'joannemerson'),
 66+(400121, 'E000172', 'F', 'Rep. Jo Ann Emerson [R, MO-8]', 'Rep.', 'MO', '8', '202-225-4404', '202-226-0326', 'https://forms.house.gov/emerson/webforms/zipauthen_contact.shtml', 'joannemerson'),
6767 (400122, 'E000179', 'M', 'Rep. Eliot Engel [D, NY-17]', 'Rep.', 'NY', '17', '202-225-2464', '202-225-5513', 'http://engel.house.gov/index.cfm?sectionid=169&sectiontree=3169', NULL),
6868 (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'),
6969 (400128, 'F000010', 'M', 'Del. Eni Faleomavaega [D, AS-0]', 'Del.', 'AS', '0', '202-225-8577', '', 'mailto:faleomavaega@mail.house.gov', NULL),
70 -(400129, 'F000030', 'M', 'Rep. Sam Farr [D, CA-17]', 'Rep.', 'CA', '17', '202-225-2861', '202-225-6791', 'https://forms.house.gov/farr/webforms/issue_subscribe.html', NULL),
 70+(400129, 'F000030', 'M', 'Rep. Sam Farr [D, CA-17]', 'Rep.', 'CA', '17', '202-225-2861', '202-225-6791', 'https://forms.house.gov/farr/webforms/issue_subscribe.html', 'repsamfarr'),
7171 (400130, 'F000043', 'M', 'Rep. Chaka Fattah [D, PA-2]', 'Rep.', 'PA', '2', '202-225-4001', '202-225-5392', 'https://fattahforms.house.gov/index.cfm?sectionid=244&sectiontree=244', 'chakafattah'),
7272 (400133, 'F000116', 'M', 'Rep. Bob Filner [D, CA-51]', 'Rep.', 'CA', '51', '202-225-8045', '202-225-9073', 'https://filner.house.gov/contact-me/email-me', 'CongBobFilner'),
7373 (400134, 'F000444', 'M', 'Rep. Jeff Flake [R, AZ-6]', 'Rep.', 'AZ', '6', '202-225-2635', '202-226-4386', 'https://writerep.house.gov/writerep/welcome.shtml', 'JeffFlake'),
——@@ -76,27 +76,27 @@
7777 (400142, 'F000372', 'M', 'Rep. Rodney Frelinghuysen [R, NJ-11]', 'Rep.', 'NJ', '11', '202-225-5034', '202-225-3186', 'https://frelinghuysenforms.house.gov/index.cfm?sectionid=29&sectiontree=1029', NULL),
7878 (400144, 'G000021', 'M', 'Rep. Elton Gallegly [R, CA-24]', 'Rep.', 'CA', '24', '202-225-5811', '202-225-1100', 'https://writerep.house.gov/writerep/welcome.shtml', 'eltongallegly24'),
7979 (400145, 'G000548', 'M', 'Rep. Scott Garrett [R, NJ-5]', 'Rep.', 'NJ', '5', '202-225-4465', '202-225-9048', 'https://garrett.house.gov/contact-me/email-me', NULL),
80 -(400147, 'G000549', 'M', 'Rep. Jim Gerlach [R, PA-6]', 'Rep.', 'PA', '6', '202-225-4315', '202-225-8440', 'https://writerep.house.gov/writerep/welcome.shtml', 'JimGerlach'),
 80+(400147, 'G000549', 'M', 'Rep. Jim Gerlach [R, PA-6]', 'Rep.', 'PA', '6', '202-225-4315', '202-225-8440', 'http://gerlach.house.gov/Contact/EmailJim.htm', 'JimGerlach'),
8181 (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'),
8282 (400152, 'G000544', 'M', 'Rep. Charles Gonzalez [D, TX-20]', 'Rep.', 'TX', '20', '202-225-3236', '202-225-1915', 'http://forms.house.gov/gonzalez/webforms/issue_subscribe.htm', NULL),
8383 (400154, 'G000289', 'M', 'Rep. Robert Goodlatte [R, VA-6]', 'Rep.', 'VA', '6', '202-225-5431', '202-225-9681', 'http://goodlatte.house.gov/contacts/new', 'RepGoodlatte'),
8484 (400157, 'G000377', 'F', 'Rep. Kay Granger [R, TX-12]', 'Rep.', 'TX', '12', '202-225-5071', '202-225-5683', 'https://kaygranger.house.gov/contact-me/email-me', 'RepKayGranger'),
85 -(400158, 'G000546', 'M', 'Rep. Samuel Graves [R, MO-6]', 'Rep.', 'MO', '6', '202-225-7041', '202-225-8221', 'https://gravesforms.house.gov/index.cfm?sectionid=84&sectiontree=384', NULL),
86 -(400160, 'G000410', 'M', 'Rep. Raymond Green [D, TX-29]', 'Rep.', 'TX', '29', '202-225-1688', '202-225-9903', 'https://green.house.gov/contact-me/email-me', NULL),
 85+(400158, 'G000546', 'M', 'Rep. Samuel Graves [R, MO-6]', 'Rep.', 'MO', '6', '202-225-7041', '202-225-8221', 'https://gravesforms.house.gov/index.cfm?sectionid=84&sectiontree=384', 'SmallBizGOP'),
 86+(400160, 'G000410', 'M', 'Rep. Gene Green [D, TX-29]', 'Rep.', 'TX', '29', '202-225-1688', '202-225-9903', 'https://green.house.gov/contact-me/email-me', 'RepGeneGreen'),
8787 (400162, 'G000551', 'M', 'Rep. Raul Grijalva [D, AZ-7]', 'Rep.', 'AZ', '7', '202-225-2435', '202-225-1541', 'https://grijalvaforms.house.gov/email-raul', 'RepRaulGrijalva'),
8888 (400163, 'G000535', 'M', 'Rep. Luis Gutiérrez [D, IL-4]', 'Rep.', 'IL', '4', '202-225-8203', '202-225-7810', 'https://forms.house.gov/gutierrez/webforms/zip_auth.shtm', 'RepGutierrez'),
8989 (400165, 'H000067', 'M', 'Rep. Ralph Hall [R, TX-4]', 'Rep.', 'TX', '4', '202-225-6673', '202-225-3332', 'http://writerep.house.gov/writerep/welcome.shtml', NULL),
9090 (400170, 'H000324', 'M', 'Rep. Alcee Hastings [D, FL-23]', 'Rep.', 'FL', '23', '202-225-1313', '202-225-1171', 'https://forms.house.gov/alceehastings/webforms/issue_subscribe.htm', NULL),
9191 (400171, 'H000329', 'M', 'Rep. Doc Hastings [R, WA-4]', 'Rep.', 'WA', '4', '202-225-5816', '202-225-3251', 'http://hastings.house.gov/Contact/', NULL),
9292 (400175, 'H001036', 'M', 'Rep. Jeb Hensarling [R, TX-5]', 'Rep.', 'TX', '5', '202-225-3484', '202-226-4888', 'https://hensarling.house.gov/contact/email-me.shtml', 'RepHensarling'),
93 -(400176, 'H000528', 'M', 'Rep. Walter Herger [R, CA-2]', 'Rep.', 'CA', '2', '202-225-3076', '202-225-1740', 'https://forms.house.gov/herger/webforms/landing.html', NULL),
 93+(400176, 'H000528', 'M', 'Rep. Walter Herger [R, CA-2]', 'Rep.', 'CA', '2', '202-225-3076', '202-225-1740', 'https://forms.house.gov/herger/webforms/contactzipauth.html', NULL),
9494 (400178, 'H000627', 'M', 'Rep. Maurice Hinchey [D, NY-22]', 'Rep.', 'NY', '22', '202-225-6335', '202-226-0774', 'https://forms.house.gov/hinchey/webforms/zip_auth.shtm', 'mauricehinchey'),
9595 (400179, 'H000636', 'M', 'Rep. Rubén Hinojosa [D, TX-15]', 'Rep.', 'TX', '15', '202-225-2531', '202-225-5688', 'http://hinojosa.house.gov/contact/email-me.shtml', 'USRepRHinojosa'),
96 -(400183, 'H000712', 'M', 'Rep. Tim Holden [D, PA-17]', 'Rep.', 'PA', '17', '202-225-5546', '202-226-0996', 'http://holden.house.gov/contactform_zipcheck.shtml', NULL),
 96+(400183, 'H000712', 'M', 'Rep. Tim Holden [D, PA-17]', 'Rep.', 'PA', '17', '202-225-5546', '202-226-0996', 'http://holden.house.gov/contactform_zipcheck.shtml', 'RepTimHolden'),
9797 (400184, 'H001032', 'M', 'Rep. Rush Holt [D, NJ-12]', 'Rep.', 'NJ', '12', '202-225-5801', '202-225-6025', 'https://forms.house.gov/holt/webforms/issue_subscribe.htm', NULL),
9898 (400185, 'H001034', 'M', 'Rep. Michael Honda [D, CA-15]', 'Rep.', 'CA', '15', '202-225-2631', '202-225-2699', 'https://forms.house.gov/honda/webforms/issue_subscribe.htm', 'RepMikeHonda'),
9999 (400189, 'H000874', 'M', 'Rep. Steny Hoyer [D, MD-5]', 'Rep.', 'MD', '5', '202-225-4131', '202-225-4300', 'https://forms.house.gov/hoyer/webforms/zip_auth.shtm', 'WhipHoyer'),
100 -(400193, 'I000026', 'M', 'Rep. Jay Inslee [D, WA-1]', 'Rep.', 'WA', '1', '202-225-6311', '202-226-1606', 'https://inslee.house.gov/contact-me/email-jay', 'RepInsleeNews'),
 100+(400193, 'I000026', 'M', 'Rep. Jay Inslee [D, WA-1]', 'Rep.', 'WA', '1', '202-225-6311', '202-226-1606', 'https://inslee.house.gov/contact-me/email-jay', NULL),
101101 (400195, 'I000057', 'M', 'Rep. Steve Israel [D, NY-2]', 'Rep.', 'NY', '2', '202-225-3335', '202-225-4669', 'https://forms.house.gov/israel/webforms/webforms/zip_auth.shtm', 'RepSteveIsrael'),
102102 (400196, 'I000056', 'M', 'Rep. Darrell Issa [R, CA-49]', 'Rep.', 'CA', '49', '202-225-3906', '202-225-3303', 'http://issa.house.gov/index.php?option=com_content&view=article&id=597&Itemid=73', 'DarrellIssa'),
103103 (400198, 'J000283', 'M', 'Rep. Jesse Jackson [D, IL-2]', 'Rep.', 'IL', '2', '202-225-0773', '202-225-0899', 'http://www.jessejacksonjr.org/contact', NULL),

Past revisions this follows-up on

RevisionCommit summaryAuthorDate
r109285integrated more up-to-date phone and link data from http://www.contactingthec......raindrift02:35, 18 January 2012

Status & tagging log