legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
44,551 rows sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: type, class, start (date)
end (date) >30 ✖
- 1919-03-03 506
- 1931-03-03 502
- 1921-03-03 499
- 1933-03-03 499
- 1923-03-03 498
- 1941-01-03 498
- 1915-03-03 494
- 1925-03-03 493
- 1945-01-03 493
- 1939-01-03 492
- 1929-03-03 489
- 1963-01-03 489
- 1943-01-03 488
- 1947-01-03 488
- 1935-01-03 486
- 1949-01-03 486
- 1953-01-03 486
- 1917-03-03 485
- 1937-01-03 485
- 1955-01-03 485
- 1927-03-04 484
- 1961-01-03 483
- 1971-01-03 483
- 1951-01-03 482
- 1965-01-03 482
- 1983-01-03 481
- 1959-01-03 480
- 1977-01-03 480
- 1967-01-03 479
- 1975-01-03 479
- …
how 2 ✖
- appointment 203
- special-election 4
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
44551 | 44551 | Rudy Yakym Y000067 | rep | IN | 2022-11-14 | 2023-01-03 | Republican | 2 | special-election | ||||||||||||
44550 | 44550 | Joseph Sempolinski S001219 | rep | NY | 2022-09-13 | 2023-01-03 | Republican | 23 | 1203 Longworth House Office Building Washington DC 20515-3223 | 202-225-3161 | 1203 Longworth House Office Building | ||||||||||
44549 | 44549 | Patrick Ryan R000579 | rep | NY | 2022-09-13 | 2023-01-03 | Democrat | 19 | 1007 Longworth House Office Building Washington DC 20515-3219 | 202-225-5614 | 1007 Longworth House Office Building | ||||||||||
44548 | 44548 | Mary Peltola P000619 | rep | AK | 2022-09-13 | 2023-01-03 | Democrat | 0 | https://peltola.house.gov | 2314 Rayburn House Office Building Washington DC 20515-0200 | 202-225-5765 | 2314 Rayburn House Office Building | |||||||||
44547 | 44547 | Brad Finstad F000475 | rep | MN | 2022-08-12 | 2023-01-03 | Republican | 1 | 1433 Longworth House Office Building Washington DC 20515-2301 | 202-225-2472 | 1433 Longworth House Office Building | ||||||||||
44546 | 44546 | Mike Flood F000474 | rep | NE | 2022-07-12 | 2023-01-03 | Republican | 1 | 1514 Longworth House Office Building Washington DC 20515-2701 | 202-225-4806 | 1514 Longworth House Office Building | ||||||||||
44545 | 44545 | Mayra Flores F000473 | rep | TX | 2022-06-21 | 2023-01-03 | Republican | 34 | 307 Cannon House Office Building Washington DC 20515-4334 | 202-225-9901 | 307 Cannon House Office Building | ||||||||||
44544 | 44544 | Connie Conway C001128 | rep | CA | 2022-06-07 | 2023-01-03 | Republican | 22 | 1013 Longworth House Office Building Washington DC 20515-0522 | 202-225-2523 | 1013 Longworth House Office Building | ||||||||||
44543 | 44543 | Sheila Cherfilus-McCormick C001127 | rep | FL | 2022-01-18 | 2023-01-03 | Democrat | 20 | https://cherfilus-mccormick.house.gov | 2365 Rayburn House Office Building Washington DC 20515-0920 | 202-225-1313 | 2365 Rayburn House Office Building | |||||||||
44542 | 44542 | Mike Carey C001126 | rep | OH | 2021-11-04 | 2023-01-03 | Republican | 15 | https://carey.house.gov | 2234 Rayburn House Office Building Washington DC 20515-3515 | 202-225-2015 | 2234 Rayburn House Office Building | |||||||||
44541 | 44541 | Shontel Brown B001313 | rep | OH | 2021-11-04 | 2023-01-03 | Democrat | 11 | https://shontelbrown.house.gov | 2344 Rayburn House Office Building Washington DC 20515-3511 | 202-225-7032 | 2344 Rayburn House Office Building | |||||||||
44540 | 44540 | Jake Ellzey E000071 | rep | TX | 2021-07-30 | 2023-01-03 | Republican | 6 | https://ellzey.house.gov | 1725 Longworth House Office Building Washington DC 20515-4306 | 202-225-2002 | 1725 Longworth House Office Building | |||||||||
44539 | 44539 | Melanie Stansbury S001218 | rep | NM | 2021-06-14 | 2023-01-03 | Democrat | 1 | https://stansbury.house.gov | 1421 Longworth House Office Building Washington DC 20515-3101 | 202-225-6316 | 1421 Longworth House Office Building | |||||||||
44538 | 44538 | Troy Carter C001125 | rep | LA | 2021-05-11 | 2023-01-03 | Democrat | 2 | https://troycarter.house.gov | 506 Cannon House Office Building Washington DC 20515-1802 | 202-225-6636 | 506 Cannon House Office Building | |||||||||
44537 | 44537 | Julia Letlow L000595 | rep | LA | 2021-04-14 | 2023-01-03 | Republican | 5 | https://letlow.house.gov | 1408 Longworth House Office Building Washington DC 20515-1805 | 202-225-8490 | 1408 Longworth House Office Building | |||||||||
44536 | 44536 | Claudia Tenney T000478 | rep | NY | 2021-02-11 | 2023-01-03 | Republican | 22 | https://tenney.house.gov | 1410 Longworth House Office Building Washington DC 20515-3222 | 202-225-3665 | 1410 Longworth House Office Building | |||||||||
44535 | 44535 | Claudia Tenney T000478 | rep | NY | 2017-01-03 | 2019-01-03 | Republican | 22 | https://tenney.house.gov | 512 Cannon House Office Building; Washington DC 20515-3222 | 202-225-3665 | 512 Cannon House Office Building | |||||||||
44534 | 44534 | Raphael Warnock W000790 | sen | GA | 2021-01-20 | 2023-01-03 | 3 | Democrat | special-election | https://www.warnock.senate.gov | 388 Russell Senate Office Building Washington DC 20510 | 202-224-3643 | https://www.warnock.senate.gov/contact/ | 388 Russell Senate Office Building | junior | ||||||
44533 | 44533 | Jon Ossoff O000174 | sen | GA | 2021-01-20 | 2027-01-03 | 2 | Democrat | https://www.ossoff.senate.gov | 455 Russell Senate Office Building Washington DC 20510 | 202-224-3521 | https://www.ossoff.senate.gov/contact-us/ | 455 Russell Senate Office Building | senior | |||||||
44532 | 44532 | Alejandro Padilla P000145 | sen | CA | 2022-11-09 | 2023-01-03 | 3 | Democrat | special-election | https://www.padilla.senate.gov | 112 Hart Senate Office Building Washington DC 20510 | 202-224-3553 | https://www.padilla.senate.gov/contact/ | 112 Hart Senate Office Building | junior | ||||||
44531 | 44531 | Alejandro Padilla P000145 | sen | CA | 2021-01-20 | 2022-11-08 | 3 | Democrat | appointment | https://www.padilla.senate.gov | 112 Hart Senate Office Building Washington DC 20510 | 202-224-3553 | https://www.padilla.senate.gov/contact/ | 112 Hart Senate Office Building | junior | ||||||
44530 | 44530 | Scott Fitzgerald F000471 | rep | WI | 2021-01-03 | 2023-01-03 | Republican | 5 | https://fitzgerald.house.gov | 1507 Longworth House Office Building Washington DC 20515-4905 | 202-225-5101 | 1507 Longworth House Office Building | |||||||||
44529 | 44529 | Marilyn Strickland S001159 | rep | WA | 2021-01-03 | 2023-01-03 | Democrat | 10 | https://strickland.house.gov | 1004 Longworth House Office Building Washington DC 20515-4710 | 202-225-9740 | 1004 Longworth House Office Building | |||||||||
44528 | 44528 | Robert Good G000595 | rep | VA | 2021-01-03 | 2023-01-03 | Republican | 5 | https://good.house.gov | 1213 Longworth House Office Building Washington DC 20515-4605 | 202-225-4711 | 1213 Longworth House Office Building | |||||||||
44527 | 44527 | Clarence Owens O000086 | rep | UT | 2021-01-03 | 2023-01-03 | Republican | 4 | https://owens.house.gov | 1039 Longworth House Office Building Washington DC 20515-4404 | 202-225-3011 | 1039 Longworth House Office Building | |||||||||
44526 | 44526 | Blake Moore M001213 | rep | UT | 2021-01-03 | 2023-01-03 | Republican | 1 | https://blakemoore.house.gov | 1320 Longworth House Office Building Washington DC 20515-4401 | 202-225-0453 | 1320 Longworth House Office Building | |||||||||
44525 | 44525 | Beth Van Duyne V000134 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 24 | https://vanduyne.house.gov | 1337 Longworth House Office Building Washington DC 20515-4324 | 202-225-6605 | 1337 Longworth House Office Building | |||||||||
44524 | 44524 | Ernest Gonzales G000594 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 23 | https://gonzales.house.gov | 1009 Longworth House Office Building Washington DC 20515-4323 | 202-225-4511 | 1009 Longworth House Office Building | |||||||||
44523 | 44523 | Troy Nehls N000026 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 22 | https://nehls.house.gov | 1104 Longworth House Office Building Washington DC 20515-4322 | 202-225-5951 | 1104 Longworth House Office Building | |||||||||
44522 | 44522 | Ronny Jackson J000304 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 13 | https://jackson.house.gov | 118 Cannon House Office Building Washington DC 20515-4313 | 202-225-3706 | 118 Cannon House Office Building | |||||||||
44521 | 44521 | August Pfluger P000048 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 11 | https://pfluger.house.gov | 1531 Longworth House Office Building Washington DC 20515-4311 | 202-225-3605 | 1531 Longworth House Office Building | |||||||||
44520 | 44520 | Patrick Fallon F000246 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 4 | https://fallon.house.gov | 1118 Longworth House Office Building Washington DC 20515-4304 | 202-225-6673 | 1118 Longworth House Office Building | |||||||||
44519 | 44519 | Diana Harshbarger H001086 | rep | TN | 2021-01-03 | 2023-01-03 | Republican | 1 | https://harshbarger.house.gov | 167 Cannon House Office Building Washington DC 20515-4201 | 202-225-6356 | 167 Cannon House Office Building | |||||||||
44518 | 44518 | Nancy Mace M000194 | rep | SC | 2021-01-03 | 2023-01-03 | Republican | 1 | https://mace.house.gov | 212 Cannon House Office Building Washington DC 20515-4001 | 202-225-3176 | 212 Cannon House Office Building | |||||||||
44517 | 44517 | Cliff Bentz B000668 | rep | OR | 2021-01-03 | 2023-01-03 | Republican | 2 | https://bentz.house.gov | 1239 Longworth House Office Building Washington DC 20515-3702 | 202-225-6730 | 1239 Longworth House Office Building | |||||||||
44516 | 44516 | Stephanie Bice B000740 | rep | OK | 2021-01-03 | 2023-01-03 | Republican | 5 | https://bice.house.gov | 1223 Longworth House Office Building Washington DC 20515-3605 | 202-225-2132 | 1223 Longworth House Office Building | |||||||||
44515 | 44515 | Mondaire Jones J000306 | rep | NY | 2021-01-03 | 2023-01-03 | Democrat | 17 | https://jones.house.gov | 1017 Longworth House Office Building Washington DC 20515-3217 | 202-225-6506 | 1017 Longworth House Office Building | |||||||||
44514 | 44514 | Jamaal Bowman B001223 | rep | NY | 2021-01-03 | 2023-01-03 | Democrat | 16 | https://bowman.house.gov | 1605 Longworth House Office Building Washington DC 20515-3216 | 202-225-2464 | 1605 Longworth House Office Building | |||||||||
44513 | 44513 | Ritchie Torres T000486 | rep | NY | 2021-01-03 | 2023-01-03 | Democrat | 15 | https://ritchietorres.house.gov | 317 Cannon House Office Building Washington DC 20515-3215 | 202-225-4361 | 317 Cannon House Office Building | |||||||||
44512 | 44512 | Nicole Malliotakis M000317 | rep | NY | 2021-01-03 | 2023-01-03 | Republican | 11 | https://malliotakis.house.gov | 417 Cannon House Office Building Washington DC 20515-3211 | 202-225-3371 | 417 Cannon House Office Building | |||||||||
44511 | 44511 | Andrew Garbarino G000597 | rep | NY | 2021-01-03 | 2023-01-03 | Republican | 2 | https://garbarino.house.gov | 1516 Longworth House Office Building Washington DC 20515-3202 | 202-225-7896 | 1516 Longworth House Office Building | |||||||||
44510 | 44510 | Teresa Leger Fernandez L000273 | rep | NM | 2021-01-03 | 2023-01-03 | Democrat | 3 | https://fernandez.house.gov | 1432 Longworth House Office Building Washington DC 20515-3103 | 202-225-6190 | 1432 Longworth House Office Building | |||||||||
44509 | 44509 | Yvette Herrell H001084 | rep | NM | 2021-01-03 | 2023-01-03 | Republican | 2 | https://herrell.house.gov | 1305 Longworth House Office Building Washington DC 20515-3102 | 202-225-2365 | 1305 Longworth House Office Building | |||||||||
44508 | 44508 | Madison Cawthorn C001104 | rep | NC | 2021-01-03 | 2023-01-03 | Republican | 11 | https://cawthorn.house.gov | 102 Cannon House Office Building Washington DC 20515-3311 | 202-225-6401 | 102 Cannon House Office Building | |||||||||
44507 | 44507 | Kathy Manning M001135 | rep | NC | 2021-01-03 | 2023-01-03 | Democrat | 6 | https://manning.house.gov | 415 Cannon House Office Building Washington DC 20515-3306 | 202-225-3065 | 415 Cannon House Office Building | |||||||||
44506 | 44506 | Deborah Ross R000305 | rep | NC | 2021-01-03 | 2023-01-03 | Democrat | 2 | https://ross.house.gov | 1208 Longworth House Office Building Washington DC 20515-3302 | 202-225-3032 | 1208 Longworth House Office Building | |||||||||
44505 | 44505 | Matthew Rosendale R000103 | rep | MT | 2021-01-03 | 2023-01-03 | Republican | 0 | https://rosendale.house.gov | 1037 Longworth House Office Building Washington DC 20515-2600 | 202-225-3211 | 1037 Longworth House Office Building | |||||||||
44504 | 44504 | Cori Bush B001224 | rep | MO | 2021-01-03 | 2023-01-03 | Democrat | 1 | https://bush.house.gov | 563 Cannon House Office Building Washington DC 20515-2501 | 202-225-2406 | 563 Cannon House Office Building | |||||||||
44503 | 44503 | Michelle Fischbach F000470 | rep | MN | 2021-01-03 | 2023-01-03 | Republican | 7 | https://fischbach.house.gov | 1237 Longworth House Office Building Washington DC 20515-2307 | 202-225-2165 | 1237 Longworth House Office Building | |||||||||
44502 | 44502 | Lisa McClain M001136 | rep | MI | 2021-01-03 | 2023-01-03 | Republican | 10 | https://mcclain.house.gov | 218 Cannon House Office Building Washington DC 20515-2210 | 202-225-2106 | 218 Cannon House Office Building | |||||||||
44501 | 44501 | Peter Meijer M001186 | rep | MI | 2021-01-03 | 2023-01-03 | Republican | 3 | https://meijer.house.gov | 1508 Longworth House Office Building Washington DC 20515-2203 | 202-225-3831 | 1508 Longworth House Office Building | |||||||||
44500 | 44500 | Jake Auchincloss A000148 | rep | MA | 2021-01-03 | 2023-01-03 | Democrat | 4 | https://auchincloss.house.gov | 1524 Longworth House Office Building Washington DC 20515-2104 | 202-225-5931 | 1524 Longworth House Office Building | |||||||||
44499 | 44499 | Jacob LaTurner L000266 | rep | KS | 2021-01-03 | 2023-01-03 | Republican | 2 | https://laturner.house.gov | 1630 Longworth House Office Building Washington DC 20515-1602 | 202-225-6601 | 1630 Longworth House Office Building | |||||||||
44498 | 44498 | Tracey Mann M000871 | rep | KS | 2021-01-03 | 2023-01-03 | Republican | 1 | https://mann.house.gov | 522 Cannon House Office Building Washington DC 20515-1601 | 202-225-2715 | 522 Cannon House Office Building | |||||||||
44497 | 44497 | Victoria Spartz S000929 | rep | IN | 2021-01-03 | 2023-01-03 | Republican | 5 | https://spartz.house.gov | 1523 Longworth House Office Building Washington DC 20515-1405 | 202-225-2276 | 1523 Longworth House Office Building | |||||||||
44496 | 44496 | Frank Mrvan M001214 | rep | IN | 2021-01-03 | 2023-01-03 | Democrat | 1 | https://mrvan.house.gov | 1607 Longworth House Office Building Washington DC 20515-1401 | 202-225-2461 | 1607 Longworth House Office Building | |||||||||
44495 | 44495 | Mary Miller M001211 | rep | IL | 2021-01-03 | 2023-01-03 | Republican | 15 | https://marymiller.house.gov | 1529 Longworth House Office Building Washington DC 20515-1315 | 202-225-5271 | 1529 Longworth House Office Building | |||||||||
44494 | 44494 | Marie Newman N000192 | rep | IL | 2021-01-03 | 2023-01-03 | Democrat | 3 | https://newman.house.gov | 1022 Longworth House Office Building Washington DC 20515-1303 | 202-225-5701 | 1022 Longworth House Office Building | |||||||||
44493 | 44493 | Randy Feenstra F000446 | rep | IA | 2021-01-03 | 2023-01-03 | Republican | 4 | https://feenstra.house.gov | 1440 Longworth House Office Building Washington DC 20515-1504 | 202-225-4426 | 1440 Longworth House Office Building | |||||||||
44492 | 44492 | Mariannette Miller-Meeks M001215 | rep | IA | 2021-01-03 | 2023-01-03 | Republican | 2 | https://millermeeks.house.gov | 1716 Longworth House Office Building Washington DC 20515-1502 | 202-225-6576 | 1716 Longworth House Office Building | |||||||||
44491 | 44491 | Ashley Hinson H001091 | rep | IA | 2021-01-03 | 2023-01-03 | Republican | 1 | https://hinson.house.gov | 1429 Longworth House Office Building Washington DC 20515-1501 | 202-225-2911 | 1429 Longworth House Office Building | |||||||||
44490 | 44490 | Kaialiʻi Kahele K000396 | rep | HI | 2021-01-03 | 2023-01-03 | Democrat | 2 | https://kahele.house.gov | 1205 Longworth House Office Building Washington DC 20515-1102 | 202-225-4906 | 1205 Longworth House Office Building | |||||||||
44489 | 44489 | Marjorie Greene G000596 | rep | GA | 2021-01-03 | 2023-01-03 | Republican | 14 | https://greene.house.gov | 1023 Longworth House Office Building Washington DC 20515-1014 | 202-225-5211 | 1023 Longworth House Office Building | |||||||||
44488 | 44488 | Andrew Clyde C001116 | rep | GA | 2021-01-03 | 2023-01-03 | Republican | 9 | https://clyde.house.gov | 521 Cannon House Office Building Washington DC 20515-1009 | 202-225-9893 | 521 Cannon House Office Building | |||||||||
44487 | 44487 | Carolyn Bourdeaux B001312 | rep | GA | 2021-01-03 | 2023-01-03 | Democrat | 7 | https://bourdeaux.house.gov | 1319 Longworth House Office Building Washington DC 20515-1007 | 202-225-4272 | 1319 Longworth House Office Building | |||||||||
44486 | 44486 | Nikema Williams W000788 | rep | GA | 2021-01-03 | 2023-01-03 | Democrat | 5 | https://nikemawilliams.house.gov | 1406 Longworth House Office Building Washington DC 20515-1005 | 202-225-3801 | 1406 Longworth House Office Building | |||||||||
44485 | 44485 | Maria Salazar S000168 | rep | FL | 2021-01-03 | 2023-01-03 | Republican | 27 | https://salazar.house.gov | 1616 Longworth House Office Building Washington DC 20515-0927 | 202-225-3931 | 1616 Longworth House Office Building | |||||||||
44484 | 44484 | Carlos Gimenez G000593 | rep | FL | 2021-01-03 | 2023-01-03 | Republican | 26 | https://gimenez.house.gov | 419 Cannon House Office Building Washington DC 20515-0926 | 202-225-2778 | 419 Cannon House Office Building | |||||||||
44483 | 44483 | Byron Donalds D000032 | rep | FL | 2021-01-03 | 2023-01-03 | Republican | 19 | https://donalds.house.gov | 523 Cannon House Office Building Washington DC 20515-0919 | 202-225-2536 | 523 Cannon House Office Building | |||||||||
44482 | 44482 | C. Franklin F000472 | rep | FL | 2021-01-03 | 2023-01-03 | Republican | 15 | https://franklin.house.gov | 1517 Longworth House Office Building Washington DC 20515-0915 | 202-225-1252 | 1517 Longworth House Office Building | |||||||||
44481 | 44481 | Katherine Cammack C001039 | rep | FL | 2021-01-03 | 2023-01-03 | Republican | 3 | https://cammack.house.gov | 1626 Longworth House Office Building Washington DC 20515-0903 | 202-225-5744 | 1626 Longworth House Office Building | |||||||||
44480 | 44480 | Lauren Boebert B000825 | rep | CO | 2021-01-03 | 2023-01-03 | Republican | 3 | https://boebert.house.gov | 1609 Longworth House Office Building Washington DC 20515-0603 | 202-225-4761 | 1609 Longworth House Office Building | |||||||||
44479 | 44479 | Sara Jacobs J000305 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 53 | https://sarajacobs.house.gov | 1232 Longworth House Office Building Washington DC 20515-0553 | 202-225-2040 | 1232 Longworth House Office Building | |||||||||
44478 | 44478 | Michelle Steel S001135 | rep | CA | 2021-01-03 | 2023-01-03 | Republican | 48 | https://steel.house.gov | 1113 Longworth House Office Building Washington DC 20515-0548 | 202-225-2415 | 1113 Longworth House Office Building | |||||||||
44477 | 44477 | Young Kim K000397 | rep | CA | 2021-01-03 | 2023-01-03 | Republican | 39 | https://youngkim.house.gov | 1306 Longworth House Office Building Washington DC 20515-0539 | 202-225-4111 | 1306 Longworth House Office Building | |||||||||
44476 | 44476 | Jay Obernolte O000019 | rep | CA | 2021-01-03 | 2023-01-03 | Republican | 8 | https://obernolte.house.gov | 1029 Longworth House Office Building Washington DC 20515-0508 | 202-225-5861 | 1029 Longworth House Office Building | |||||||||
44475 | 44475 | Barry Moore M001212 | rep | AL | 2021-01-03 | 2023-01-03 | Republican | 2 | https://barrymoore.house.gov | 1504 Longworth House Office Building Washington DC 20515-0102 | 202-225-2901 | 1504 Longworth House Office Building | |||||||||
44474 | 44474 | Jerry Carl C001054 | rep | AL | 2021-01-03 | 2023-01-03 | Republican | 1 | https://carl.house.gov | 1330 Longworth House Office Building Washington DC 20515-0101 | 202-225-4931 | 1330 Longworth House Office Building | |||||||||
44473 | 44473 | Bill Hagerty H000601 | sen | TN | 2021-01-03 | 2027-01-03 | 2 | Republican | https://www.hagerty.senate.gov | 248 Russell Senate Office Building Washington DC 20510 | 202-224-4944 | https://www.hagerty.senate.gov/email-me/ | 248 Russell Senate Office Building | junior | |||||||
44472 | 44472 | John Hickenlooper H000273 | sen | CO | 2021-01-03 | 2027-01-03 | 2 | Democrat | https://www.hickenlooper.senate.gov | 374 Russell Senate Office Building Washington DC 20510 | 202-224-5941 | https://www.hickenlooper.senate.gov/contact/ | 374 Russell Senate Office Building | junior | |||||||
44471 | 44471 | Tommy Tuberville T000278 | sen | AL | 2021-01-03 | 2027-01-03 | 2 | Republican | https://www.tuberville.senate.gov | 142 Russell Senate Office Building Washington DC 20510 | 202-224-4124 | https://www.tuberville.senate.gov/contact/contact-form/ | 142 Russell Senate Office Building | junior | |||||||
44470 | 44470 | David Valadao V000129 | rep | CA | 2021-01-03 | 2023-01-03 | Republican | 21 | https://valadao.house.gov | 1728 Longworth House Office Building Washington DC 20515-0521 | 202-225-4695 | 1728 Longworth House Office Building | http://valadao.house.gov/rss.xml | ||||||||
44469 | 44469 | David Valadao V000129 | rep | CA | 2017-01-03 | 2019-01-03 | Republican | 21 | https://valadao.house.gov | 1728 Longworth House Office Building; Washington DC 20515-0521 | 202-225-4695 | 202-226-3196 | 1728 Longworth House Office Building | http://valadao.house.gov/rss.xml | |||||||
44468 | 44468 | David Valadao V000129 | rep | CA | 2015-01-06 | 2017-01-03 | Republican | 21 | http://valadao.house.gov | 1004 Longworth HOB; Washington DC 20515-0521 | 202-225-4695 | 202-226-3196 | http://valadao.house.gov/contact/ | 1004 Longworth House Office Building | http://valadao.house.gov/rss.xml | ||||||
44467 | 44467 | David Valadao V000129 | rep | CA | 2013-01-03 | 2015-01-03 | Republican | 21 | http://valadao.house.gov | 1004 Longworth HOB; Washington DC 20515-0521 | 202-225-4695 | 202-226-3196 | http://valadao.house.gov/contact/ | 1004 Longworth House Office Building | http://valadao.house.gov/rss.xml | ||||||
44466 | 44466 | Pete Sessions S000250 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 17 | https://sessions.house.gov | 2204 Rayburn House Office Building Washington DC 20515-4317 | 202-225-6105 | 2204 Rayburn House Office Building | http://sessions.house.gov/?a=rss.feed | ||||||||
44465 | 44465 | Pete Sessions S000250 | rep | TX | 2017-01-03 | 2019-01-03 | Republican | 32 | https://sessions.house.gov | 2233 Rayburn House Office Building; Washington DC 20515-4332 | 202-225-2231 | 202-225-5878 | 2233 Rayburn House Office Building | http://sessions.house.gov/?a=rss.feed | |||||||
44464 | 44464 | Pete Sessions S000250 | rep | TX | 2015-01-06 | 2017-01-03 | Republican | 32 | https://sessions.house.gov | 2233 Rayburn HOB; Washington DC 20515-4332 | 202-225-2231 | 202-225-5878 | https://sessions.house.gov/index.cfm/contact-form | 2233 Rayburn House Office Building | http://sessions.house.gov/?a=rss.feed | ||||||
44463 | 44463 | Pete Sessions S000250 | rep | TX | 2013-01-03 | 2015-01-03 | Republican | 32 | http://sessions.house.gov | 2233 Rayburn HOB; Washington DC 20515-4332 | 202-225-2231 | 202-225-5878 | https://sessions.house.gov/index.cfm/contact-form | 2233 Rayburn House Office Building | http://sessions.house.gov/?a=rss.feed | ||||||
44462 | 44462 | Pete Sessions S000250 | rep | TX | 2011-01-05 | 2013-01-03 | Republican | 32 | http://www.house.gov/sessions | 2233 Rayburn HOB; Washington DC 20515-4332 | 202-225-2231 | 202-225-5878 | http://www.house.gov/sessionsform/emailform.htm | 2233 Rayburn House Office Building | |||||||
44461 | 44461 | Pete Sessions S000250 | rep | TX | 2009-01-06 | 2011-01-03 | Republican | 32 | http://www.house.gov/sessions | ||||||||||||
44460 | 44460 | Pete Sessions S000250 | rep | TX | 2007-01-04 | 2009-01-03 | Republican | 32 | http://www.house.gov/sessions | ||||||||||||
44459 | 44459 | Pete Sessions S000250 | rep | TX | 2005-01-04 | 2007-01-03 | Republican | 32 | http://www.house.gov/sessions | ||||||||||||
44458 | 44458 | Pete Sessions S000250 | rep | TX | 2003-01-07 | 2005-01-03 | Republican | 32 | http://www.house.gov/sessions | ||||||||||||
44457 | 44457 | Pete Sessions S000250 | rep | TX | 2001-01-03 | 2003-01-03 | Republican | 5 | |||||||||||||
44456 | 44456 | Pete Sessions S000250 | rep | TX | 1999-01-06 | 2001-01-03 | Republican | 5 | |||||||||||||
44455 | 44455 | Pete Sessions S000250 | rep | TX | 1997-01-07 | 1999-01-03 | Republican | 5 | |||||||||||||
44454 | 44454 | Darrell Issa I000056 | rep | CA | 2021-01-03 | 2023-01-03 | Republican | 50 | https://issa.house.gov | 2300 Rayburn House Office Building Washington DC 20515-0550 | 202-225-5672 | 2300 Rayburn House Office Building | http://issa.house.gov/feed/ | ||||||||
44453 | 44453 | Darrell Issa I000056 | rep | CA | 2017-01-03 | 2019-01-03 | Republican | 49 | https://issa.house.gov | 2269 Rayburn House Office Building; Washington DC 20515-0549 | 202-225-3906 | 202-225-3303 | 2269 Rayburn House Office Building | http://issa.house.gov/feed/ | |||||||
44452 | 44452 | Darrell Issa I000056 | rep | CA | 2015-01-06 | 2017-01-03 | Republican | 49 | http://issa.house.gov | 2269 Rayburn HOB; Washington DC 20515-0549 | 202-225-3906 | 202-225-3303 | http://issa.house.gov/contact/contact-me | 2269 Rayburn House Office Building | http://issa.house.gov/feed/ |
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);