r109312 MediaWiki - Code Review archive

Repository:MediaWiki
Revision:< r109311‎ | r109312 | r109313 >
Date:05:14, 18 January 2012
Author:raindrift
Status:ok
Tags:
Comment:
integrating first batch of changes from manual checks by Solitarius, et al.
checked up to line 55
followup to r109285
Modified paths:
  • /trunk/extensions/CongressLookup/data/cl_house.sql (modified) (history)

Diff [purge]

Index: trunk/extensions/CongressLookup/data/cl_house.sql
——@@ -1,10 +1,10 @@
22 REPLACE INTO /*$wgDBprefix*/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
33 (400003, 'A000022', 'M', 'Rep. Gary Ackerman [D, NY-5]', 'Rep.', 'NY', '5', '202-225-2601', '202-225-1589', 'https://ackerman-forms.house.gov/index.cfm?sectionid=128', NULL),
44 (400004, 'A000055', 'M', 'Rep. Robert Aderholt [R, AL-4]', 'Rep.', 'AL', '4', '202-225-4876', '202-225-5587', 'http://aderholt.house.gov/index.cfm?sectionid=195&sectiontree=195', 'Robert_Aderholt'),
5 -(400005, 'A000358', 'M', 'Rep. Todd Akin [R, MO-2]', 'Rep.', 'MO', '2', '202-225-2561', '202-225-2563', 'https://forms.house.gov/akin/webforms/issue_subscribe.htm', 'ToddAkin'),
 5+(400005, 'A000358', 'M', 'Rep. Todd Akin [R, MO-2]', 'Rep.', 'MO', '2', '202-225-2561', '202-225-2563', 'https://forms.house.gov/akin/webforms/issue_subscribe.htm', 'RepToddAkin'),
66 (400006, 'A000361', 'M', 'Rep. Rodney Alexander [R, LA-5]', 'Rep.', 'LA', '5', '202-225-8490', '202-225-5639', 'https://alexanderforms.house.gov/contact-form-cc8', 'USRepAlexander'),
77 (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),
8 -(400009, 'B001234', 'M', 'Rep. Joe Baca [D, CA-43]', 'Rep.', 'CA', '43', '202-225-6161', '202-225-8671', 'https://bacaforms.house.gov/contact-form', 'BacaCA43'),
 8+(400009, 'B001234', 'M', 'Rep. Joe Baca [D, CA-43]', 'Rep.', 'CA', '43', '202-225-6161', '202-225-8671', 'https://bacaforms.house.gov/contact-form', 'RepJoeBaca'),
99 (400010, 'B000013', 'M', 'Rep. Spencer Bachus [R, AL-6]', 'Rep.', 'AL', '6', '202-225-4921', '202-225-2082', 'https://writerep.house.gov/writerep/welcome.shtml', 'BachusAL06'),
1010 (400013, 'B001230', 'F', 'Rep. Tammy Baldwin [D, WI-2]', 'Rep.', 'WI', '2', '202-225-2906', '202-225-6942', 'https://tammybaldwin.house.gov/contact/email-me.shtml', 'RepTammyBaldwin'),
1111 (400017, 'B000208', 'M', 'Rep. Roscoe Bartlett [R, MD-6]', 'Rep.', 'MD', '6', '202-225-2721', '202-225-2193', 'https://bartlettforms.house.gov/Email_Roscoe/default.aspx', NULL),
——@@ -18,10 +18,10 @@
1919 (400030, 'B000490', 'M', 'Rep. Sanford Bishop [D, GA-2]', 'Rep.', 'GA', '2', '202-225-3631', '202-225-2203', 'https://forms.house.gov/bishop/webforms/issue_subscribe.html', 'SanfordBishop'),
2020 (400031, 'B001242', 'M', 'Rep. Timothy Bishop [D, NY-1]', 'Rep.', 'NY', '1', '202-225-3826', '202-225-3143', 'http://timbishop.house.gov/index.cfm?sectionid=96&sectiontree=796', NULL),
2121 (400032, 'B001243', 'F', 'Rep. Marsha Blackburn [R, TN-7]', 'Rep.', 'TN', '7', '202-225-2811', '202-225-3004', 'https://blackburnforms.house.gov/contactform/default.aspx', NULL),
22 -(400033, 'B000574', 'M', 'Rep. Earl Blumenauer [D, OR-3]', 'Rep.', 'OR', '3', '202-225-4811', '202-225-8941', 'https://forms.house.gov/blumenauer/webforms/issue_subscribe.html', 'repblumenauer'),
23 -(400036, 'B000589', 'M', 'Rep. John Boehner [R, OH-8]', 'Rep.', 'OH', '8', '202-225-6205', '202-225-0704', 'http://johnboehner.house.gov/Contact/', 'johnboehner'),
 22+(400033, 'B000574', 'M', 'Rep. Earl Blumenauer [D, OR-3]', 'Rep.', 'OR', '3', '202-225-4811', '202-225-8941', 'https://forms.house.gov/blumenauer/webforms/issue_subscribe.html', 'blumenauermedia'),
 23+(400036, 'B000589', 'M', 'Rep. John Boehner [R, OH-8]', 'Rep.', 'OH', '8', '202-225-6205', '202-225-0704', 'http://johnboehner.house.gov/Contact/', 'SpeakerBoehner'),
2424 (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'),
25 -(400039, 'B001228', 'F', 'Rep. Mary Bono Mack [R, CA-45]', 'Rep.', 'CA', '45', '202-225-5330', '202-225-2961', 'https://bonoforms.house.gov/Contact_Mary/ContactForm.htm', 'MaryBonoMack'),
 25+(400039, 'B001228', 'F', 'Rep. Mary Bono Mack [R, CA-45]', 'Rep.', 'CA', '45', '202-225-5330', '202-225-2961', 'https://bonoforms.house.gov/Contact_Mary/ContactForm.htm', 'Rep_BonoMack'),
2626 (400041, 'B001245', 'F', 'Del. Madeleine Bordallo [D, GU-0]', 'Del.', 'GU', '0', '202-225-1188', '', 'http://www.house.gov/bordallo/contact.shtml', NULL),
2727 (400042, 'B000652', 'M', 'Rep. Leonard Boswell [D, IA-3]', 'Rep.', 'IA', '3', '202-225-3806', '202-225-5608', 'http://boswell.house.gov/index.cfm?sectionid=81&sectiontree=481', 'LeonardBoswell'),
2828 (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'),
——@@ -31,28 +31,28 @@
3232 (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'),
3333 (400057, 'C000059', 'M', 'Rep. Ken Calvert [R, CA-44]', 'Rep.', 'CA', '44', '202-225-1986', '202-225-2004', 'http://calvert.house.gov/Contact/', 'KenCalvert'),
3434 (400058, 'C000071', 'M', 'Rep. David Camp [R, MI-4]', 'Rep.', 'MI', '4', '202-225-3561', '202-225-9679', 'http://camp.house.gov/Contact/', 'RepDaveCamp'),
35 -(400060, 'C001046', 'M', 'Rep. Eric Cantor [R, VA-7]', 'Rep.', 'VA', '7', '202-225-2815', '202-225-0011', 'http://cantor.house.gov/contact/', 'EricCantor'),
 35+(400060, 'C001046', 'M', 'Rep. Eric Cantor [R, VA-7]', 'Rep.', 'VA', '7', '202-225-2815', '202-225-0011', 'http://cantor.house.gov/contact/', 'GOPLeader'),
3636 (400061, 'C001047', 'F', 'Rep. Shelley Capito [R, WV-2]', 'Rep.', 'WV', '2', '202-225-2711', '202-225-7856', 'https://capitoforms.house.gov/index.cfm?sectionid=58&sectiontree=358', 'RepShelley'),
37 -(400062, 'C001036', 'F', 'Rep. Lois Capps [D, CA-23]', 'Rep.', 'CA', '23', '202-225-3601', '202-225-5632', 'https://capps.house.gov/contact-me/email-me', NULL),
 37+(400062, 'C001036', 'F', 'Rep. Lois Capps [D, CA-23]', 'Rep.', 'CA', '23', '202-225-3601', '202-225-5632', 'https://capps.house.gov/contact-me/email-me', 'RepLoisCapps'),
3838 (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),
3939 (400065, 'C001050', 'M', 'Rep. Dennis Cardoza [D, CA-18]', 'Rep.', 'CA', '18', '202-225-6131', '202-225-0819', 'https://writerep.house.gov/writerep/welcome.shtml', 'RepCardoza'),
4040 (400068, 'C001051', 'M', 'Rep. John Carter [R, TX-31]', 'Rep.', 'TX', '31', '202-225-3864', '202-225-5886', 'https://carterforms.house.gov/index.cfm?sectionid=139&sectiontree=139', 'judgecarter'),
4141 (400071, 'C000266', 'M', 'Rep. Steven Chabot [R, OH-1]', 'Rep.', 'OH', '1', '202-225-2216', '202-225-3012', 'https://chabotforms.house.gov/index.cfm?sectionid=58&sectiontree=358', 'RepSteveChabot'),
42 -(400073, 'C000380', 'F', 'Del. Donna Christensen [D, VI-0]', 'Del.', 'VI', '0', '202-225-1790', '', 'https://donnachristensen.house.gov/contact-me/email-me', NULL),
 42+(400073, 'C000380', 'F', 'Del. Donna Christensen [D, VI-0]', 'Del.', 'VI', '0', '202-225-1790', '', 'https://donnachristensen.house.gov/contact-me/email-me', 'DelegateDonna'),
4343 (400074, 'C001049', 'M', 'Rep. William Clay [D, MO-1]', 'Rep.', 'MO', '1', '202-225-2406', '202-226-3717', 'http://lacyclay.house.gov/index.cfm?sectionid=90&sectiontree=390', NULL),
44 -(400075, 'C000537', 'M', 'Rep. James Clyburn [D, SC-6]', 'Rep.', 'SC', '6', '202-225-3315', '202-225-2313', 'https://forms.house.gov/clyburn/zipauth.shtml', NULL),
 44+(400075, 'C000537', 'M', 'Rep. James Clyburn [D, SC-6]', 'Rep.', 'SC', '6', '202-225-3315', '202-225-2313', 'https://clyburn.house.gov/contact-me/email-me', 'clyburn'),
4545 (400076, 'C000556', 'M', 'Rep. Howard Coble [R, NC-6]', 'Rep.', 'NC', '6', '202-225-3065', '202-225-8611', 'http://coble.house.gov/Contact/ZipCheck.htm', NULL),
4646 (400077, 'C001053', 'M', 'Rep. Tom Cole [R, OK-4]', 'Rep.', 'OK', '4', '202-225-6165', '202-225-3512', 'https://coleforms.house.gov/Contact/', NULL),
4747 (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'),
4848 (400081, 'C000754', 'M', 'Rep. Jim Cooper [D, TN-5]', 'Rep.', 'TN', '5', '202-225-4311', '202-226-1035', 'https://forms.house.gov/cooper/webforms/issue_subscribe.html', 'repjimcooper'),
4949 (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'),
5050 (400086, 'C001045', 'M', 'Rep. Ander Crenshaw [R, FL-4]', 'Rep.', 'FL', '4', '202-225-2501', '202-225-2504', 'https://writerep.house.gov/writerep/welcome.shtml', 'AnderCrenshaw'),
51 -(400087, 'C001038', 'M', 'Rep. Joseph Crowley [D, NY-7]', 'Rep.', 'NY', '7', '202-225-3965', '202-225-1909', 'https://crowley.house.gov/contact-me/email-me', NULL),
 51+(400087, 'C001038', 'M', 'Rep. Joseph Crowley [D, NY-7]', 'Rep.', 'NY', '7', '202-225-3965', '202-225-1909', 'https://crowley.house.gov/contact-me/email-me', 'repjoecrowley'),
5252 (400089, 'C001048', 'M', 'Rep. John Culberson [R, TX-7]', 'Rep.', 'TX', '7', '202-225-2571', '202-225-4381', 'http://culbersonforms.house.gov/Contact/ZipAuth.htm', 'johnculberson'),
53 -(400090, 'C000984', 'M', 'Rep. Elijah Cummings [D, MD-7]', 'Rep.', 'MD', '7', '202-225-4741', '202-225-3178', 'https://cummingsforms.house.gov/contact/message-form.shtml', NULL),
 53+(400090, 'C000984', 'M', 'Rep. Elijah Cummings [D, MD-7]', 'Rep.', 'MD', '7', '202-225-4741', '202-225-3178', 'http://cummings.house.gov/contact/', NULL),
5454 (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),
5555 (400097, 'D000598', 'F', 'Rep. Susan Davis [D, CA-53]', 'Rep.', 'CA', '53', '202-225-2040', '202-225-2948', 'https://susandavisforms.house.gov/forms/writeyourrep/', NULL),
56 -(400100, 'D000191', 'M', 'Rep. Peter DeFazio [D, OR-4]', 'Rep.', 'OR', '4', '202-225-6416', '202-225-0032', 'https://forms.house.gov/defazio/IMA/contact.html', NULL),
 56+(400100, 'D000191', 'M', 'Rep. Peter DeFazio [D, OR-4]', 'Rep.', 'OR', '4', '202-225-6416', '202-225-0032', 'https://forms.house.gov/defazio/IMA/contact.html', 'RepPeterDeFazio'),
5757 (400101, 'D000197', 'F', 'Rep. Diana DeGette [D, CO-1]', 'Rep.', 'CO', '1', '202-225-4431', '202-225-5657', 'http://degette.house.gov/index.php?option=com_content&view=article&id=1045&Itemid=202', 'RepDianaDeGette'),
5858 (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'),
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'),

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