r109573 MediaWiki - Code Review archive

Repository:MediaWiki
Revision:< r109572‎ | r109573 | r109574 >
Date:22:01, 19 January 2012
Author:awjrichards
Status:ok
Tags:
Comment:
Updates to zip/rep mapping, and some rep/senator contact info
Modified paths:
  • /trunk/extensions/CongressLookup/data/cl_house.sql (modified) (history)
  • /trunk/extensions/CongressLookup/data/cl_senate.sql (modified) (history)
  • /trunk/extensions/CongressLookup/data/cl_zip5.sql (modified) (history)

Diff [purge]

Index: trunk/extensions/CongressLookup/data/cl_house.sql
——@@ -6,7 +6,7 @@
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),
88 (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'),
10 -(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'),
 10+(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', 'TammyBaldwinWI'),
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),
1212 (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'),
1313 (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'),
Index: trunk/extensions/CongressLookup/data/cl_zip5.sql
——@@ -12108,6 +12108,7 @@
1210912109 ( 25396, 400061 ),
1211012110 ( 25401, 400061 ),
1211112111 ( 25402, 400061 ),
 12112+ ( 25405, 400061 ),
1211212113 ( 25410, 400061 ),
1211312114 ( 25411, 400061 ),
1211412115 ( 25413, 400061 ),
——@@ -15165,7 +15166,8 @@
1516615167 ( 30357, 400240 ),
1516715168 ( 30358, 400240 ),
1516815169 ( 30359, 412199 ),
15169 - ( 30360, 412199 ),
 15170+ ( 30360, 412416 ),
 15171+ ( 30360, 400626 ),
1517015172 ( 30361, 400240 ),
1517115173 ( 30362, 412199 ),
1517215174 ( 30364, 400240 ),
——@@ -19148,7 +19150,7 @@
1914919151 ( 37165, 412479 ),
1915019152 ( 37166, 412478 ),
1915119153 ( 37166, 412477 ),
19152 - ( 37167, 400032 ) ;
 19154+ ( 37167, 412478 ) ;
1915319155 REPLACE INTO /*$wgDBprefix*/cl_zip5 ( `clz5_zip`, `clz5_rep_id` ) VALUES
1915419156 ( 37171, 412479 ),
1915519157 ( 37172, 412478 ),
——@@ -33155,7 +33157,6 @@
3315633158 ( 63118, 400638 ),
3315733159 ( 63119, 400638 ),
3315833160 ( 63119, 400005 ),
33159 - ( 63119, 400074 ),
3316033161 ( 63120, 400074 ),
3316133162 ( 63121, 400074 ),
3316233163 ( 63122, 400005 ),
——@@ -34212,6 +34213,7 @@
3421334214 ( 65559, 400121 ),
3421434215 ( 65559, 412292 ),
3421534216 ( 65560, 412292 ),
 34217+ ( 65560, 400121 ),
3421634218 ( 65564, 400121 ),
3421734219 ( 65565, 400121 ),
3421834220 ( 65565, 412292 ),
——@@ -41862,6 +41864,7 @@
4186341865 ( 80106, 412271 ),
4186441866 ( 80106, 412191 ),
4186541867 ( 80107, 412271 ),
 41868+ ( 80108, 412271 ),
4186641869 ( 80110, 400101 ),
4186741870 ( 80111, 412271 ),
4186841871 ( 80111, 400101 ),
——@@ -42459,6 +42462,7 @@
4246042463 ( 81251, 412405 ),
4246142464 ( 81251, 412191 ),
4246242465 ( 81252, 412405 ),
 42466+ ( 81252, 412191 ),
4246342467 ( 81253, 412405 ),
4246442468 ( 81253, 412191 ),
4246542469 ( 81290, 412191 ),
——@@ -43594,6 +43598,10 @@
4359543599 ( 85087, 412398 ),
4359643600 ( 85098, 400310 ),
4359743601 ( 85099, 400310 ),
 43602+ ( 85128, 400626 ),
 43603+ ( 85128, 412397 ),
 43604+ ( 85132, 412397 ),
 43605+ ( 85132, 400134 ),
4359843606 ( 85201, 400134 ),
4359943607 ( 85201, 412399 ),
4360043608 ( 85202, 412399 ),
——@@ -43936,6 +43944,7 @@
4393743945 ( 85754, 400162 ),
4393843946 ( 85756, 400162 ),
4393943947 ( 85756, 412188 ),
 43948+ ( 85757, 400162 ),
4394043949 ( 85775, NULL ),
4394143950 ( 85777, NULL ),
4394243951 ( 85901, 412397 ),
Index: trunk/extensions/CongressLookup/data/cl_senate.sql
——@@ -12,7 +12,7 @@
1313 (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),
1414 (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'),
1515 (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),
16 -(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'),
 16+(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', 'SenatorDurbin'),
1717 (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),
1818 (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),
1919 (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'),
——@@ -46,7 +46,7 @@
4747 (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),
4848 (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),
4949 (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'),
50 -(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'),
 50+(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', 'SenShelbyPress'),
5151 (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'),
5252 (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'),
5353 (300100, 'W000779', 'M', 'Sen. Ron Wyden [D, OR]', 'Sen.', 'OR', '202-224-5244', '202-228-2717', 'http://www.wyden.senate.gov/contact/', 'RonWyden'),
——@@ -57,7 +57,7 @@
5858 (400064, 'C000141', 'M', 'Sen. Benjamin Cardin [D, MD]', 'Sen.', 'MD', '202-224-4524', '202-224-1651', 'http://www.cardin.senate.gov/contact/', 'SenatorCardin'),
5959 (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'),
6060 (400194, 'I000055', 'M', 'Sen. John Isakson [R, GA]', 'Sen.', 'GA', '202-224-3643', '202-228-0724', 'http://www.isakson.senate.gov/contact.cfm', NULL),
61 -(400222, 'K000360', 'M', 'Sen. Mark Kirk [R, IL]', 'Sen.', 'IL', '202-224-2854', '', 'http://www.kirk.senate.gov/?p=contact', 'markkirk'),
 61+(400222, 'K000360', 'M', 'Sen. Mark Kirk [R, IL]', 'Sen.', 'IL', '202-224-2854', '', 'http://www.kirk.senate.gov/?p=contact', 'SenatorKirk'),
6262 (400272, 'M000639', 'M', 'Sen. Robert Menéndez [D, NJ]', 'Sen.', 'NJ', '202-224-4744', '202-228-2197', 'http://menendez.senate.gov/contact/', 'senatormenendez'),
6363 (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'),
6464 (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'),

Follow-up revisions

RevisionCommit summaryAuthorDate
r109598MFT r109573awjrichards01:13, 20 January 2012

Status & tagging log