legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
19,135 rows where party = "Republican" sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: class, state_rank, start (date), end (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||||||
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 | ||||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||
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/ | ||||||
44451 | 44451 | Darrell Issa I000056 | rep | CA | 2013-01-03 | 2015-01-03 | Republican | 49 | http://issa.house.gov | 2347 Rayburn HOB; Washington DC 20515-0549 | 202-225-3906 | 202-225-3303 | http://issa.house.gov/contact/contact-me | 2347 Rayburn House Office Building | http://issa.house.gov/feed/ | ||||||
44450 | 44450 | Darrell Issa I000056 | rep | CA | 2011-01-05 | 2013-01-03 | Republican | 49 | http://www.house.gov/issa | 2347 Rayburn HOB; Washington DC 20515-0549 | 202-225-3906 | 202-225-3303 | http://issa.house.gov/index.cfm?FuseAction=Contact.ContactForm | 2347 Rayburn House Office Building | |||||||
44449 | 44449 | Darrell Issa I000056 | rep | CA | 2009-01-06 | 2011-01-03 | Republican | 49 | http://www.house.gov/issa | ||||||||||||
44448 | 44448 | Darrell Issa I000056 | rep | CA | 2007-01-04 | 2009-01-03 | Republican | 49 | http://www.house.gov/issa | ||||||||||||
44447 | 44447 | Darrell Issa I000056 | rep | CA | 2005-01-04 | 2007-01-03 | Republican | 49 | http://www.house.gov/issa | ||||||||||||
44446 | 44446 | Darrell Issa I000056 | rep | CA | 2003-01-07 | 2005-01-03 | Republican | 49 | http://www.house.gov/issa | ||||||||||||
44445 | 44445 | Darrell Issa I000056 | rep | CA | 2001-01-03 | 2003-01-03 | Republican | 48 | |||||||||||||
44444 | 44444 | Cynthia Lummis L000571 | sen | WY | 2021-01-03 | 2027-01-03 | 2 | Republican | https://www.lummis.senate.gov | 124 Russell Senate Office Building Washington DC 20510 | 202-224-3424 | https://www.lummis.senate.gov/contact/contact-form/ | 124 Russell Senate Office Building | junior | |||||||
44443 | 44443 | Cynthia Lummis L000571 | rep | WY | 2015-01-06 | 2017-01-03 | Republican | 0 | http://lummis.house.gov | 2433 Rayburn HOB; Washington DC 20515-5000 | 202-225-2311 | 202-225-3057 | http://lummis.house.gov/contact/ | 2433 Rayburn House Office Building | http://lummis.house.gov/news/rss.aspx | ||||||
44442 | 44442 | Cynthia Lummis L000571 | rep | WY | 2013-01-03 | 2015-01-03 | Republican | 0 | http://lummis.house.gov | 113 Cannon HOB; Washington DC 20515-5000 | 202-225-2311 | 202-225-3057 | http://lummis.house.gov/contact/ | 113 Cannon House Office Building | http://lummis.house.gov/news/rss.aspx | ||||||
44441 | 44441 | Cynthia Lummis L000571 | rep | WY | 2011-01-05 | 2013-01-03 | Republican | 0 | http://lummis.house.gov | 113 Cannon HOB; Washington DC 20515-5001 | 202-225-2311 | 202-225-3057 | https://forms.house.gov/lummis/contact-form.shtml | 113 Cannon House Office Building | |||||||
44440 | 44440 | Cynthia Lummis L000571 | rep | WY | 2009-01-06 | 2011-01-03 | Republican | 0 | http://lummis.house.gov | ||||||||||||
44438 | 44438 | Chris Jacobs J000020 | rep | NY | 2021-01-03 | 2023-01-03 | Republican | 27 | https://jacobs.house.gov | 214 Cannon House Office Building Washington DC 20515-3227 | 202-225-5265 | 214 Cannon House Office Building | |||||||||
44437 | 44437 | Chris Jacobs J000020 | rep | NY | 2020-07-21 | 2021-01-03 | Republican | 27 | 2243 Rayburn House Office Building Washington DC 20515-3227 | 202-225-5265 | 2243 Rayburn House Office Building | ||||||||||
44436 | 44436 | Mike Garcia G000061 | rep | CA | 2021-01-03 | 2023-01-03 | Republican | 25 | https://mikegarcia.house.gov | 1535 Longworth House Office Building Washington DC 20515-0525 | 202-225-1956 | 1535 Longworth House Office Building | |||||||||
44435 | 44435 | Mike Garcia G000061 | rep | CA | 2020-05-19 | 2021-01-03 | Republican | 25 | 1130 Longworth House Office Building Washington DC 20515-0525 | 202-225-1956 | 1130 Longworth House Office Building | ||||||||||
44434 | 44434 | Thomas Tiffany T000165 | rep | WI | 2021-01-03 | 2023-01-03 | Republican | 7 | https://tiffany.house.gov | 1719 Longworth House Office Building Washington DC 20515-4907 | 202-225-3365 | 1719 Longworth House Office Building | |||||||||
44433 | 44433 | Thomas Tiffany T000165 | rep | WI | 2020-05-19 | 2021-01-03 | Republican | 7 | 1714 Longworth House Office Building Washington DC 20515-4907 | 202-225-3365 | 1714 Longworth House Office Building | ||||||||||
44425 | 44425 | Gregory Murphy M001210 | rep | NC | 2021-01-03 | 2023-01-03 | Republican | 3 | https://gregmurphy.house.gov | 313 Cannon House Office Building Washington DC 20515-3303 | 202-225-3415 | 313 Cannon House Office Building | |||||||||
44424 | 44424 | Gregory Murphy M001210 | rep | NC | 2019-09-17 | 2021-01-03 | Republican | 3 | https://gregmurphy.house.gov/ | 2333 Rayburn House Office Building Washington DC 20515-3303 | 202-225-3415 | https://gregmurphy.house.gov/contact/email | 2333 Rayburn House Office Building | ||||||||
44423 | 44423 | Dan Bishop B001311 | rep | NC | 2021-01-03 | 2023-01-03 | Republican | 9 | https://danbishop.house.gov | 1207 Longworth House Office Building Washington DC 20515-3309 | 202-225-1976 | 1207 Longworth House Office Building | |||||||||
44422 | 44422 | Dan Bishop B001311 | rep | NC | 2019-09-17 | 2021-01-03 | Republican | 9 | https://danbishop.house.gov/ | 132 Cannon House Office Building Washington DC 20515-3309 | 202-225-1976 | https://danbishop.house.gov/contact/email | 132 Cannon House Office Building | ||||||||
44421 | 44421 | Fred Keller K000395 | rep | PA | 2021-01-03 | 2023-01-03 | Republican | 12 | https://keller.house.gov | 1717 Longworth House Office Building Washington DC 20515-3812 | 202-225-3731 | 1717 Longworth House Office Building | |||||||||
44420 | 44420 | Fred Keller K000395 | rep | PA | 2019-06-03 | 2021-01-03 | Republican | 12 | https://keller.house.gov | 1717 Longworth House Office Building Washington DC 20515-3812 | 202-225-3731 | 1717 Longworth House Office Building | |||||||||
44417 | 44417 | Mitt Romney R000615 | sen | UT | 2019-01-03 | 2025-01-03 | 1 | Republican | https://www.romney.senate.gov | 354 Russell Senate Office Building Washington DC 20510 | 202-224-5251 | https://www.romney.senate.gov/contact-senator-romney | 354 Russell Senate Office Building | junior | |||||||
44416 | 44416 | Joshua Hawley H001089 | sen | MO | 2019-01-03 | 2025-01-03 | 1 | Republican | https://www.hawley.senate.gov | 115 Russell Senate Office Building Washington DC 20510 | 202-224-6154 | https://www.hawley.senate.gov/contact-senator-hawley | 115 Russell Senate Office Building | junior |
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);