legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
470 rows where "end" is on date 2013-01-03 sorted by contact_form
This data as json, copyable, CSV (advanced)
Suggested facets: type, start (date)
Link | rowid | legislator_id | type | state | start | end | class | party | district | how | party_affiliations | url | caucus | address | phone | fax | contact_form ▼ | office | state_rank | rss_url | end-type |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
39099 | 39099 | Sandy Adams A000366 | rep | FL | 2011-01-05 | 2013-01-03 | Republican | 24 | http://adams.house.gov/ | 216 Cannon HOB; Washington DC 20515-0924 | 202-225-2706 | 202-226-6299 | 216 Cannon House Office Building | ||||||||
39134 | 39134 | Charles Bass B000220 | rep | NH | 2011-01-05 | 2013-01-03 | Republican | 2 | http://bass.house.gov/ | 2350 Rayburn HOB; Washington DC 20515-2902 | 202-225-5206 | 202-225-2946 | 2350 Rayburn House Office Building | ||||||||
39135 | 39135 | Rick Berg B001272 | rep | ND | 2011-01-05 | 2013-01-03 | Republican | 0 | http://berg.house.gov/ | 323 Cannon HOB; Washington DC 20515-3401 | 202-225-2611 | 202-226-0893 | 323 Cannon House Office Building | ||||||||
39192 | 39192 | Ann Marie Buerkle B001276 | rep | NY | 2011-01-05 | 2013-01-03 | Republican | 25 | http://buerkle.house.gov/ | 1630 Longworth HOB; Washington DC 20515-3225 | 202-225-3701 | 202-225-4042 | 1630 Longworth House Office Building | ||||||||
39208 | 39208 | Francisco Canseco C001082 | rep | TX | 2011-01-05 | 2013-01-03 | Republican | 23 | http://canseco.house.gov/ | 1339 Longworth HOB; Washington DC 20515-4323 | 202-225-4511 | 202-225-2237 | 1339 Longworth House Office Building | ||||||||
39218 | 39218 | Hansen Clarke C001085 | rep | MI | 2011-01-05 | 2013-01-03 | Democrat | 13 | http://hansenclarke.house.gov/ | 1319 Longworth HOB; Washington DC 20515-2213 | 202-225-2261 | 202-225-5730 | 1319 Longworth House Office Building | ||||||||
39232 | 39232 | Chip Cravaack C001086 | rep | MN | 2011-01-05 | 2013-01-03 | Republican | 8 | http://cravaack.house.gov/ | 508 Cannon HOB; Washington DC 20515-2308 | 202-225-6211 | 202- 225-6211 | 508 Cannon House Office Building | ||||||||
39305 | 39305 | Nan Hayworth H001054 | rep | NY | 2011-01-05 | 2013-01-03 | Republican | 19 | http://hayworth.house.gov/ | 1440 Longworth HOB; Washington DC 20515-3219 | 202-225-5441 | 202- 225-3289 | 1440 Longworth House Office Building | ||||||||
39382 | 39382 | Jeff Landry L000574 | rep | LA | 2011-01-05 | 2013-01-03 | Republican | 3 | http://landry.house.gov/ | 206 Cannon HOB; Washington DC 20515-1803 | 202-225-4031 | 202- 226-3944 | 206 Cannon House Office Building | ||||||||
39472 | 39472 | Ben Quayle Q000024 | rep | AZ | 2011-01-05 | 2013-01-03 | Republican | 3 | http://quayle.house.gov/ | 1419 Longworth HOB; Washington DC 20515-0303 | 202-225-3361 | 202-225-3462 | 1419 Longworth House Office Building | ||||||||
39490 | 39490 | David Rivera R000590 | rep | FL | 2011-01-05 | 2013-01-03 | Republican | 25 | http://rivera.house.gov/ | 417 Cannon HOB; Washington DC 20515-0925 | 202-225-2778 | 202-226-0346 | 417 Cannon House Office Building | ||||||||
39505 | 39505 | Robert Schilling S001182 | rep | IL | 2011-01-05 | 2013-01-03 | Republican | 17 | http://schilling.house.gov/ | 507 Cannon HOB; Washington DC 20515-1317 | 202-225-5905 | 202- 225-5396 | 507 Cannon House Office Building | ||||||||
39570 | 39570 | Allen West W000807 | rep | FL | 2011-01-05 | 2013-01-03 | Republican | 22 | http://west.house.gov/ | 1708 Longworth HOB; Washington DC 20515-0922 | 202-225-3026 | 202-225-8398 | 1708 Longworth House Office Building | ||||||||
39581 | 39581 | Kathleen Hochul H001062 | rep | NY | 2011-06-01 | 2013-01-03 | Democrat | 26 | http://hochul.house.gov/ | 1711 Longworth HOB; Washington DC 20515-3226 | 202-225-5265 | 1711 Longworth House Office Building | |||||||||
39583 | 39583 | David Curson C001089 | rep | MI | 2012-11-13 | 2013-01-03 | Democrat | 11 | http://curson.house.gov | 2243 Rayburn HOB; Washington DC 20515-2211 | 202-225-8171 | 2243 Rayburn House Office Building | |||||||||
39747 | 39747 | Spencer Bachus B000013 | rep | AL | 2011-01-05 | 2013-01-03 | Republican | 6 | http://bachus.house.gov | 2246 Rayburn HOB; Washington DC 20515-0106 | 202-225-4921 | 202-225-2082 | |||||||||
39792 | 39792 | Donna Christensen C000380 | rep | VI | 2011-01-05 | 2013-01-03 | Democrat | 0 | http://www.donnachristensen.house.gov/ | 1510 Longworth HOB; Washington DC 20515-5501 | 202-225-1790 | 202-225-5517 | |||||||||
39854 | 39854 | Tim Griffin G000567 | rep | AR | 2011-01-05 | 2013-01-03 | Republican | 2 | http://griffin.house.gov/ | 1232 Longworth HOB; Washington DC 20515-0402 | 202-225-2506 | 202-225-5903 | 1232 Longworth House Office Building | ||||||||
40053 | 40053 | Jon Runyan R000594 | rep | NJ | 2011-01-05 | 2013-01-03 | Republican | 3 | http://runyan.house.gov/ | 1239 Longworth HOB; Washington DC 20515-3003 | 202-225-4765 | 202-225-0778 | 1239 Longworth House Office Building | ||||||||
40060 | 40060 | Steve Southerland S001186 | rep | FL | 2011-01-05 | 2013-01-03 | Republican | 2 | http://southerland.house.gov/ | 1229 Longworth HOB; Washington DC 20515-0902 | 202-225-5235 | 202-225-5615 | 1229 Longworth House Office Building | ||||||||
40129 | 40129 | Michael Grimm G000569 | rep | NY | 2011-01-05 | 2013-01-03 | Republican | 13 | http://grimm.house.gov/ | 512 Cannon HOB; Washington DC 20515-3213 | 202-225-3371 | 202-226-1272 | 512 Cannon House Office Building | ||||||||
40147 | 40147 | Alan Nunnelee N000186 | rep | MS | 2011-01-05 | 2013-01-03 | Republican | 1 | http://nunnelee.house.gov/ | 1432 Longworth HOB; Washington DC 20515-2401 | 202-225-4306 | 202- 225-3549 | 1432 Longworth House Office Building | ||||||||
40246 | 40246 | Dan Benishek B001271 | rep | MI | 2011-01-05 | 2013-01-03 | Republican | 1 | http://benishek.house.gov/ | 514 Cannon HOB; Washington DC 20515-2201 | 202-225-4735 | 202- 225-4744 | 514 Cannon House Office Building | ||||||||
40293 | 40293 | Renee Ellmers E000291 | rep | NC | 2011-01-05 | 2013-01-03 | Republican | 2 | http://ellmers.house.gov/ | 1533 Longworth HOB; Washington DC 20515-3302 | 202-225-4531 | 202- 225-5662 | 1533 Longworth House Office Building | ||||||||
40308 | 40308 | Stephen Fincher F000458 | rep | TN | 2011-01-05 | 2013-01-03 | Republican | 8 | http://fincher.house.gov/ | 1118 Longworth HOB; Washington DC 20515-4208 | 202-225-4714 | 202-225-1765 | 1118 Longworth House Office Building | ||||||||
40312 | 40312 | Michael Fitzpatrick F000451 | rep | PA | 2011-01-05 | 2013-01-03 | Republican | 8 | http://fitzpatrick.house.gov/ | 1224 Longworth HOB; Washington DC 20515-3808 | 202-225-4276 | 202- 225-9511 | 1224 Longworth House Office Building | ||||||||
40334 | 40334 | Christopher Gibson G000564 | rep | NY | 2011-01-05 | 2013-01-03 | Republican | 20 | http://gibson.house.gov/ | 502 Cannon HOB; Washington DC 20515-3220 | 202-225-5614 | 202-225-1168 | 502 Cannon House Office Building | ||||||||
40337 | 40337 | Richard Hanna H001051 | rep | NY | 2011-01-05 | 2013-01-03 | Republican | 24 | http://hanna.house.gov/ | 319 Cannon HOB; Washington DC 20515-3224 | 202-225-3665 | 202-225-1891 | 319 Cannon House Office Building | ||||||||
40340 | 40340 | Joseph Heck H001055 | rep | NV | 2011-01-05 | 2013-01-03 | Republican | 3 | http://heck.house.gov/ | 132 Cannon HOB; Washington DC 20515-2803 | 202-225-3252 | 202- 225-2185 | 132 Cannon House Office Building | ||||||||
40361 | 40361 | Tim Huelskamp H001057 | rep | KS | 2011-01-05 | 2013-01-03 | Republican | 1 | http://huelskamp.house.gov/ | 126 Cannon HOB; Washington DC 20515-1601 | 202-225-2715 | 202- 225-5124 | 126 Cannon House Office Building | ||||||||
40364 | 40364 | Robert Hurt H001060 | rep | VA | 2011-01-05 | 2013-01-03 | Republican | 5 | http://hurt.house.gov/ | 1516 Longworth HOB; Washington DC 20515-4605 | 202-225-4711 | 202-225-5681 | 1516 Longworth House Office Building | ||||||||
40423 | 40423 | Richard Nugent N000185 | rep | FL | 2011-01-05 | 2013-01-03 | Republican | 5 | http://nugent.house.gov/ | 1517 Longworth HOB; Washington DC 20515-0905 | 202-225-1002 | 202- 226-6559 | 1517 Longworth House Office Building | ||||||||
40461 | 40461 | Reid Ribble R000587 | rep | WI | 2011-01-05 | 2013-01-03 | Republican | 8 | http://ribble.house.gov/ | 1513 Longworth HOB; Washington DC 20515-4908 | 202-225-5665 | 202- 225-5729 | 1513 Longworth House Office Building | ||||||||
40464 | 40464 | Edward Rigell R000589 | rep | VA | 2011-01-05 | 2013-01-03 | Republican | 2 | http://rigell.house.gov/ | 327 Cannon HOB; Washington DC 20515-4602 | 202-225-4215 | 202-225-4218 | 327 Cannon House Office Building | ||||||||
40478 | 40478 | Marlin Stutzman S001188 | rep | IN | 2011-01-05 | 2013-01-03 | Republican | 3 | http://stutzman.house.gov | 1728 Longworth HOB; Washington DC 20515-1403 | 202-225-4436 | 202-225-3479 | 1728 Longworth House Office Building | ||||||||
40501 | 40501 | Bob Dold D000613 | rep | IL | 2011-01-05 | 2013-01-03 | Republican | 10 | http://dold.house.gov/ | 212 Cannon HOB; Washington DC 20515-1310 | 202-225-4835 | 202-225-0837 | 212 Cannon House Office Building | ||||||||
40503 | 40503 | Frank Guinta G000570 | rep | NH | 2011-01-05 | 2013-01-03 | Republican | 1 | http://guinta.house.gov/ | 1223 Longworth HOB; Washington DC 20515-2901 | 202-225-5456 | 202-225-5822 | 1223 Longworth House Office Building | ||||||||
40508 | 40508 | Mike Pompeo P000602 | rep | KS | 2011-01-05 | 2013-01-03 | Republican | 4 | http://pompeo.house.gov/ | 107 Cannon HOB; Washington DC 20515-1604 | 202-225-6216 | 202-225-3489 | 107 Cannon House Office Building | ||||||||
40536 | 40536 | Mick Mulvaney M001182 | rep | SC | 2011-01-05 | 2013-01-03 | Republican | 5 | http://mulvaney.house.gov/ | 1004 Longworth HOB; Washington DC 20515-4005 | 202-225-5501 | 202-225-0464 | 1004 Longworth House Office Building | ||||||||
40628 | 40628 | Blake Farenthold F000460 | rep | TX | 2011-01-05 | 2013-01-03 | Republican | 27 | http://farenthold.house.gov/ | 2110 Rayburn HOB; Washington DC 20515-4327 | 202-225-7742 | 202-226-1134 | 2110 Rayburn House Office Building | ||||||||
40632 | 40632 | Patrick Meehan M001181 | rep | PA | 2011-01-05 | 2013-01-03 | Republican | 7 | http://meehan.house.gov/ | 513 Cannon HOB; Washington DC 20515-3807 | 202-225-2011 | 202-226-0280 | 513 Cannon House Office Building | ||||||||
40690 | 40690 | Lou Barletta B001269 | rep | PA | 2011-01-05 | 2013-01-03 | Republican | 11 | http://barletta.house.gov/ | 510 Cannon HOB; Washington DC 20515-3811 | 202-225-6511 | 202-225-0764 | 510 Cannon House Office Building | ||||||||
40711 | 40711 | Diane Black B001273 | rep | TN | 2011-01-05 | 2013-01-03 | Republican | 6 | http://black.house.gov/ | 1531 Longworth HOB; Washington DC 20515-4206 | 202-225-4231 | 202-225-6887 | 1531 Longworth House Office Building | ||||||||
40768 | 40768 | Jeff Denham D000612 | rep | CA | 2011-01-05 | 2013-01-03 | Republican | 19 | http://denham.house.gov/ | 1605 Longworth HOB; Washington DC 20515-0519 | 202-225-4540 | 202-225-3402 | 1605 Longworth House Office Building | ||||||||
40830 | 40830 | Trey Gowdy G000566 | rep | SC | 2011-01-05 | 2013-01-03 | Republican | 4 | http://gowdy.house.gov/ | 1237 Longworth HOB; Washington DC 20515-4004 | 202-225-6030 | 202-226-1177 | 1237 Longworth House Office Building | ||||||||
40873 | 40873 | Randy Hultgren H001059 | rep | IL | 2011-01-05 | 2013-01-03 | Republican | 14 | http://hultgren.house.gov/ | 427 Cannon HOB; Washington DC 20515-1314 | 202-225-2976 | 202-225-0697 | 427 Cannon House Office Building | ||||||||
40896 | 40896 | Raúl Labrador L000573 | rep | ID | 2011-01-05 | 2013-01-03 | Republican | 1 | http://labrador.house.gov/ | 1523 Longworth HOB; Washington DC 20515-1201 | 202-225-6611 | 202-225-3029 | 1523 Longworth House Office Building | ||||||||
40935 | 40935 | Kristi Noem N000184 | rep | SD | 2011-01-05 | 2013-01-03 | Republican | 0 | http://noem.house.gov/ | 226 Cannon HOB; Washington DC 20515-4101 | 202-225-2801 | 202-225-5823 | 226 Cannon House Office Building | ||||||||
40947 | 40947 | Stevan Pearce P000588 | rep | NM | 2011-01-05 | 2013-01-03 | Republican | 2 | http://pearce.house.gov/ | 2432 Rayburn HOB; Washington DC 20515-3102 | 202-225-2365 | 2432 Rayburn House Office Building | |||||||||
40970 | 40970 | James Renacci R000586 | rep | OH | 2011-01-05 | 2013-01-03 | Republican | 16 | http://renacci.house.gov/ | 130 Cannon HOB; Washington DC 20515-3516 | 202-225-3876 | 202-225-3059 | 130 Cannon House Office Building | ||||||||
40989 | 40989 | Todd Rokita R000592 | rep | IN | 2011-01-05 | 2013-01-03 | Republican | 4 | http://rokita.house.gov/ | 236 Cannon HOB; Washington DC 20515-1404 | 202-225-5037 | 236 Cannon House Office Building | |||||||||
41019 | 41019 | Dennis Ross R000593 | rep | FL | 2011-01-05 | 2013-01-03 | Republican | 12 | http://dennisross.house.gov/ | 404 Cannon HOB; Washington DC 20515-0912 | 202-225-1252 | 202-226-0585 | 404 Cannon House Office Building | ||||||||
41083 | 41083 | Kevin Yoder Y000063 | rep | KS | 2011-01-05 | 2013-01-03 | Republican | 3 | http://yoder.house.gov/ | 214 Cannon HOB; Washington DC 20515-1603 | 202-225-2865 | 202-225-2807 | 214 Cannon House Office Building | ||||||||
41154 | 41154 | Colleen Hanabusa H001050 | rep | HI | 2011-01-05 | 2013-01-03 | Democrat | 1 | http://hanabusa.house.gov/ | 238 Cannon HOB; Washington DC 20515-1101 | 202-225-2726 | 202-225-4580 | 238 Cannon House Office Building | ||||||||
41169 | 41169 | Tom Marino M001179 | rep | PA | 2011-01-05 | 2013-01-03 | Republican | 10 | http://marino.house.gov/ | 410 Cannon HOB; Washington DC 20515-3810 | 202-225-3731 | 202-225-9594 | 410 Cannon House Office Building | ||||||||
41187 | 41187 | Sean Duffy D000614 | rep | WI | 2011-01-05 | 2013-01-03 | Republican | 7 | http://duffy.house.gov/ | 1208 Longworth HOB; Washington DC 20515-4907 | 202-225-3365 | 1208 Longworth House Office Building | |||||||||
41285 | 41285 | Justin Amash A000367 | rep | MI | 2011-01-05 | 2013-01-03 | Republican | 3 | http://amash.house.gov/ | 114 Cannon HOB; Washington DC 20515-2203 | 202-225-3831 | 202-225-5144 | 114 Cannon House Office Building | ||||||||
41343 | 41343 | Bill Flores F000461 | rep | TX | 2011-01-05 | 2013-01-03 | Republican | 17 | http://flores.house.gov/ | 1505 Longworth HOB; Washington DC 20515-4317 | 202-225-6105 | 202-225-0350 | 1505 Longworth House Office Building | ||||||||
41348 | 41348 | Cory Gardner G000562 | rep | CO | 2011-01-05 | 2013-01-03 | Republican | 4 | http://gardner.house.gov/ | 213 Cannon HOB; Washington DC 20515-0604 | 202-225-4676 | 213 Cannon House Office Building | |||||||||
41434 | 41434 | Martha Roby R000591 | rep | AL | 2011-01-05 | 2013-01-03 | Republican | 2 | http://roby.house.gov/ | 414 Cannon HOB; Washington DC 20515-0102 | 202-225-2901 | 202-225-8913 | 414 Cannon House Office Building | ||||||||
41507 | 41507 | Scott Tipton T000470 | rep | CO | 2011-01-05 | 2013-01-03 | Republican | 3 | http://tipton.house.gov/ | 218 Cannon HOB; Washington DC 20515-0603 | 202-225-4761 | 202-226-9669 | 218 Cannon House Office Building | ||||||||
41541 | 41541 | Rob Woodall W000810 | rep | GA | 2011-01-05 | 2013-01-03 | Republican | 7 | http://woodall.house.gov/ | 1725 Longworth HOB; Washington DC 20515-1007 | 202-225-4272 | 202-225-4696 | 1725 Longworth House Office Building | ||||||||
41611 | 41611 | Cedric Richmond R000588 | rep | LA | 2011-01-05 | 2013-01-03 | Democrat | 2 | http://richmond.house.gov/ | 415 Cannon HOB; Washington DC 20515-1802 | 202-225-6636 | 202-225-1988 | 415 Cannon House Office Building | ||||||||
41646 | 41646 | Steve Stivers S001187 | rep | OH | 2011-01-05 | 2013-01-03 | Republican | 15 | http://stivers.house.gov/ | 1007 Longworth HOB; Washington DC 20515-3515 | 202-225-2015 | 202-225-3529 | 1007 Longworth House Office Building | ||||||||
41704 | 41704 | Tom Reed R000585 | rep | NY | 2011-01-05 | 2013-01-03 | Republican | 29 | http://reed.house.gov/ | 1037 Longworth HOB; Washington DC 20515-3229 | 202-225-3161 | 202-226-6599 | 1037 Longworth House Office Building | ||||||||
41926 | 41926 | Karen Bass B001270 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 33 | http://karenbass.house.gov/ | 408 Cannon HOB; Washington DC 20515-0533 | 202-225-7084 | 202-225-2422 | 408 Cannon House Office Building | ||||||||
42012 | 42012 | Mo Brooks B001274 | rep | AL | 2011-01-05 | 2013-01-03 | Republican | 5 | http://brooks.house.gov/ | 1641 Longworth HOB; Washington DC 20515-0105 | 202-225-4801 | 202-225-4392 | 1641 Longworth House Office Building | ||||||||
42026 | 42026 | Larry Bucshon B001275 | rep | IN | 2011-01-05 | 2013-01-03 | Republican | 8 | http://bucshon.house.gov/ | 1123 Longworth HOB; Washington DC 20515-1408 | 202-225-4636 | 202-225-3284 | 1123 Longworth House Office Building | ||||||||
42122 | 42122 | Steve Chabot C000266 | rep | OH | 2011-01-05 | 2013-01-03 | Republican | 1 | http://chabot.house.gov/ | 2351 Rayburn HOB; Washington DC 20515-3501 | 202-225-2216 | 202-225-3012 | 2351 Rayburn House Office Building | ||||||||
42135 | 42135 | David Cicilline C001084 | rep | RI | 2011-01-05 | 2013-01-03 | Democrat | 1 | http://cicilline.house.gov/ | 128 Cannon HOB; Washington DC 20515-3901 | 202-225-4911 | 202-225-3290 | 128 Cannon House Office Building | ||||||||
42238 | 42238 | Eric Crawford C001087 | rep | AR | 2011-01-05 | 2013-01-03 | Republican | 1 | http://crawford.house.gov/ | 1408 Longworth HOB; Washington DC 20515-0401 | 202-225-4076 | 202-225-5602 | 1408 Longworth House Office Building | ||||||||
42313 | 42313 | Scott DesJarlais D000616 | rep | TN | 2011-01-05 | 2013-01-03 | Republican | 4 | http://desjarlais.house.gov/ | 413 Cannon HOB; Washington DC 20515-4204 | 202-225-6831 | 202-226-5172 | 413 Cannon House Office Building | ||||||||
42357 | 42357 | Jeff Duncan D000615 | rep | SC | 2011-01-05 | 2013-01-03 | Republican | 3 | http://jeffduncan.house.gov/ | 116 Cannon HOB; Washington DC 20515-4003 | 202-225-5301 | 202-225-3216 | 116 Cannon House Office Building | ||||||||
42378 | 42378 | Charles Fleischmann F000459 | rep | TN | 2011-01-05 | 2013-01-03 | Republican | 3 | http://fleischmann.house.gov/ | 511 Cannon HOB; Washington DC 20515-4203 | 202-225-3271 | 202-225-3494 | 511 Cannon House Office Building | ||||||||
42400 | 42400 | Bob Gibbs G000563 | rep | OH | 2011-01-05 | 2013-01-03 | Republican | 18 | http://gibbs.house.gov/ | 329 Cannon HOB; Washington DC 20515-3518 | 202-225-6265 | 202-225-3394 | 329 Cannon House Office Building | ||||||||
42415 | 42415 | Paul Gosar G000565 | rep | AZ | 2011-01-05 | 2013-01-03 | Republican | 1 | http://gosar.house.gov/ | 504 Cannon HOB; Washington DC 20515-0301 | 202-225-2315 | 200-226-9739 | 504 Cannon House Office Building | ||||||||
42464 | 42464 | H. Griffith G000568 | rep | VA | 2011-01-05 | 2013-01-03 | Republican | 9 | http://morgangriffith.house.gov/ | 1108 Longworth HOB; Washington DC 20515-4609 | 202-225-3861 | 202-225-0076 | 1108 Longworth House Office Building | ||||||||
42487 | 42487 | Andy Harris H001052 | rep | MD | 2011-01-05 | 2013-01-03 | Republican | 1 | http://harris.house.gov/ | 506 Cannon HOB; Washington DC 20515-2001 | 202-225-5311 | 202-225-0254 | 506 Cannon House Office Building | ||||||||
42493 | 42493 | Vicky Hartzler H001053 | rep | MO | 2011-01-05 | 2013-01-03 | Republican | 4 | http://hartzler.house.gov/ | 1023 Longworth HOB; Washington DC 20515-2504 | 202-225-2876 | 202-225-2695 | 1023 Longworth House Office Building | ||||||||
42503 | 42503 | Jaime Herrera Beutler H001056 | rep | WA | 2011-01-05 | 2013-01-03 | Republican | 3 | http://herrerabeutler.house.gov/ | 1130 Longworth HOB; Washington DC 20515-4703 | 202-225-3536 | 202-225-3478 | 1130 Longworth House Office Building | ||||||||
42553 | 42553 | Bill Huizenga H001058 | rep | MI | 2011-01-05 | 2013-01-03 | Republican | 2 | http://huizenga.house.gov/ | 1217 Longworth HOB; Washington DC 20515-2202 | 202-225-4401 | 202-226-0779 | 1217 Longworth House Office Building | ||||||||
42573 | 42573 | Bill Johnson J000292 | rep | OH | 2011-01-05 | 2013-01-03 | Republican | 6 | http://billjohnson.house.gov/ | 317 Cannon HOB; Washington DC 20515-3506 | 202-225-5705 | 202-225-5907 | 317 Cannon House Office Building | ||||||||
42632 | 42632 | William Keating K000375 | rep | MA | 2011-01-05 | 2013-01-03 | Democrat | 10 | http://keating.house.gov/ | 315 Cannon HOB; Washington DC 20515-2110 | 202-225-3111 | 202-225-5658 | 315 Cannon House Office Building | ||||||||
42638 | 42638 | Mike Kelly K000376 | rep | PA | 2011-01-05 | 2013-01-03 | Republican | 3 | http://kelly.house.gov/ | 515 Cannon HOB; Washington DC 20515-3803 | 202-225-5406 | 202-225-3103 | 515 Cannon House Office Building | ||||||||
42657 | 42657 | Adam Kinzinger K000378 | rep | IL | 2011-01-05 | 2013-01-03 | Republican | 11 | http://kinzinger.house.gov/ | 1218 Longworth HOB; Washington DC 20515-1311 | 202-225-3635 | 202-225-3521 | 1218 Longworth House Office Building | ||||||||
42682 | 42682 | James Lankford L000575 | rep | OK | 2011-01-05 | 2013-01-03 | Republican | 5 | http://lankford.house.gov/ | 509 Cannon HOB; Washington DC 20515-3605 | 202-225-2132 | 202-226-1463 | 509 Cannon House Office Building | ||||||||
42754 | 42754 | Billy Long L000576 | rep | MO | 2011-01-05 | 2013-01-03 | Republican | 7 | http://long.house.gov/ | 1541 Longworth HOB; Washington DC 20515-2507 | 202-225-6536 | 202-225-5604 | 1541 Longworth House Office Building | ||||||||
42904 | 42904 | David McKinley M001180 | rep | WV | 2011-01-05 | 2013-01-03 | Republican | 1 | http://mckinley.house.gov/ | 313 Cannon HOB; Washington DC 20515-4801 | 202-225-4172 | 202-225-7564 | 313 Cannon House Office Building | ||||||||
43033 | 43033 | Steven Palazzo P000601 | rep | MS | 2011-01-05 | 2013-01-03 | Republican | 4 | http://palazzo.house.gov/ | 331 Cannon HOB; Washington DC 20515-2404 | 202-225-5772 | 202-225-7074 | 331 Cannon House Office Building | ||||||||
43299 | 43299 | David Schweikert S001183 | rep | AZ | 2011-01-05 | 2013-01-03 | Republican | 5 | http://schweikert.house.gov/ | 1205 Longworth HOB; Washington DC 20515-0305 | 202-225-2190 | 1205 Longworth House Office Building | |||||||||
43305 | 43305 | Austin Scott S001189 | rep | GA | 2011-01-05 | 2013-01-03 | Republican | 8 | http://austinscott.house.gov/ | 516 Cannon HOB; Washington DC 20515-1003 | 202-225-6531 | 202-225-3013 | 516 Cannon House Office Building | ||||||||
43340 | 43340 | Terri Sewell S001185 | rep | AL | 2011-01-05 | 2013-01-03 | Democrat | 7 | http://sewell.house.gov/ | 1133 Longworth HOB; Washington DC 20515-0107 | 202-225-2665 | 202-226-9567 | 1133 Longworth House Office Building | ||||||||
43554 | 43554 | Tim Walberg W000798 | rep | MI | 2011-01-05 | 2013-01-03 | Republican | 7 | http://walberg.house.gov/ | 418 Cannon HOB; Washington DC 20515-2207 | 202-225-6276 | 202-225-6281 | 418 Cannon House Office Building | ||||||||
43585 | 43585 | Daniel Webster W000806 | rep | FL | 2011-01-05 | 2013-01-03 | Republican | 8 | http://webster.house.gov/ | 1039 Longworth HOB; Washington DC 20515-0908 | 202-225-2176 | 202-225-0999 | 1039 Longworth House Office Building | ||||||||
43610 | 43610 | Frederica Wilson W000808 | rep | FL | 2011-01-05 | 2013-01-03 | Democrat | 17 | http://wilson.house.gov/ | 208 Cannon HOB; Washington DC 20515-0917 | 202-225-4506 | 202-226-0777 | 208 Cannon House Office Building | ||||||||
43624 | 43624 | Steve Womack W000809 | rep | AR | 2011-01-05 | 2013-01-03 | Republican | 3 | http://womack.house.gov/ | 1508 Longworth HOB; Washington DC 20515-0403 | 202-225-4301 | 202-225-5713 | 1508 Longworth House Office Building | ||||||||
43651 | 43651 | Todd Young Y000064 | rep | IN | 2011-01-05 | 2013-01-03 | Republican | 9 | http://toddyoung.house.gov/ | 1721 Longworth HOB; Washington DC 20515-1409 | 202-225-5315 | 202-226-6866 | 1721 Longworth House Office Building | ||||||||
43667 | 43667 | Suzan DelBene D000617 | rep | WA | 2012-11-13 | 2013-01-03 | Democrat | 1 | http://delbene.house.gov | 2329 Rayburn HOB; Washington DC 20515-4701 | 202-225-6311 | 2329 Rayburn House Office Building | |||||||||
43673 | 43673 | Thomas Massie M001184 | rep | KY | 2012-11-13 | 2013-01-03 | Republican | 4 | http://massie.house.gov | 1119 Longworth HOB; Washington DC 20515-1704 | 202-225-3465 | 1119 Longworth House Office Building | |||||||||
43679 | 43679 | Donald Payne P000604 | rep | NJ | 2012-11-15 | 2013-01-03 | Democrat | 10 | 2310 Rayburn HOB; Washington DC 20515-3010 | 202-225-3436 | 2310 Rayburn House Office Building |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [legislator_terms] ( [legislator_id] TEXT REFERENCES [legislators]([id]), [type] TEXT, [state] TEXT, [start] TEXT, [end] TEXT, [class] INTEGER, [party] TEXT , [district] INTEGER, [how] TEXT, [party_affiliations] TEXT, [url] TEXT, [caucus] TEXT, [address] TEXT, [phone] TEXT, [fax] TEXT, [contact_form] TEXT, [office] TEXT, [state_rank] TEXT, [rss_url] TEXT, [end-type] TEXT);