legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
44,551 rows sorted by start descending
This data as json, copyable, CSV (advanced)
Suggested facets: how, state_rank, start (date), end (date)
state >10 ✖
party >10 ✖
- Democrat 20,712
- Republican 19,135
- Whig 1,208
- Jackson 878
- Federalist 821
- Adams 260
- Ind. Republican-Democrat 129
- American 84
- Unionist 77
- Anti Masonic 76
- …
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 | ||||||||||||
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 | ||||||
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 | |||||||||
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 | ||||||||||
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 | ||||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | ||||||
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 | |||||||
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 | ||||||
41616 | 41616 | Cedric Richmond R000588 | rep | LA | 2021-01-03 | 2021-01-15 | Democrat | 2 | https://richmond.house.gov | 506 Cannon House Office Building Washington DC 20515-1802 | 202-225-6636 | 506 Cannon House Office Building | http://richmond.house.gov/rss.xml | ||||||||
41620 | 41620 | Ron Wright W000827 | rep | TX | 2021-01-03 | 2021-02-07 | Republican | 6 | https://wright.house.gov | 1725 Longworth House Office Building Washington DC 20515-4306 | 202-225-2002 | 1725 Longworth House Office Building | |||||||||
41628 | 41628 | Marcia Fudge F000455 | rep | OH | 2021-01-03 | 2021-03-10 | Democrat | 11 | https://fudge.house.gov | 2344 Rayburn House Office Building Washington DC 20515-3511 | 202-225-7032 | 2344 Rayburn House Office Building | http://fudge.house.gov/common/rss//index.cfm?rss=25 | ||||||||
41630 | 41630 | Debra Haaland H001080 | rep | NM | 2021-01-03 | 2021-03-16 | Democrat | 1 | https://haaland.house.gov | 1421 Longworth House Office Building Washington DC 20515-3101 | 202-225-6316 | 1421 Longworth House Office Building | |||||||||
41645 | 41645 | Alcee Hastings H000324 | rep | FL | 2021-01-03 | 2021-04-06 | Democrat | 20 | https://alceehastings.house.gov | 2365 Rayburn House Office Building Washington DC 20515-0920 | 202-225-1313 | 2365 Rayburn House Office Building | http://www.alceehastings.house.gov/news/rss.aspx | ||||||||
41651 | 41651 | Steve Stivers S001187 | rep | OH | 2021-01-03 | 2021-05-16 | Republican | 15 | https://stivers.house.gov | 2234 Rayburn House Office Building Washington DC 20515-3515 | 202-225-2015 | 2234 Rayburn House Office Building | http://stivers.house.gov/news/rss.aspx | ||||||||
41661 | 41661 | Devin Nunes N000181 | rep | CA | 2021-01-03 | 2022-01-03 | Republican | 22 | https://nunes.house.gov | 1013 Longworth House Office Building Washington DC 20515-0522 | 202-225-2523 | 1013 Longworth House Office Building | http://nunes.house.gov/news/rss.aspx | ||||||||
41663 | 41663 | Jim Hagedorn H001088 | rep | MN | 2021-01-03 | 2022-02-17 | Republican | 1 | https://hagedorn.house.gov | 1433 Longworth House Office Building Washington DC 20515-2301 | 202-225-2472 | 1433 Longworth House Office Building | |||||||||
41688 | 41688 | Don Young Y000033 | rep | AK | 2021-01-03 | 2022-03-18 | Republican | 0 | https://donyoung.house.gov | 2314 Rayburn House Office Building Washington DC 20515-0200 | 202-225-5765 | 2314 Rayburn House Office Building | http://donyoung.house.gov/news/rss.aspx | ||||||||
41697 | 41697 | Jeff Fortenberry F000449 | rep | NE | 2021-01-03 | 2022-03-31 | Republican | 1 | https://fortenberry.house.gov | 1514 Longworth House Office Building Washington DC 20515-2701 | 202-225-4806 | 1514 Longworth House Office Building | http://fortenberry.house.gov/index.php?format=feed&type=rss | ||||||||
41702 | 41702 | Filemon Vela V000132 | rep | TX | 2021-01-03 | 2022-03-31 | Democrat | 34 | https://vela.house.gov | 307 Cannon House Office Building Washington DC 20515-4334 | 202-225-9901 | 307 Cannon House Office Building | http://vela.house.gov/rss.xml | ||||||||
41709 | 41709 | Tom Reed R000585 | rep | NY | 2021-01-03 | 2022-05-10 | Republican | 23 | https://reed.house.gov | 1203 Longworth House Office Building Washington DC 20515-3223 | 202-225-3161 | 1203 Longworth House Office Building | http://reed.house.gov/rss.xml | ||||||||
41711 | 41711 | Antonio Delgado D000630 | rep | NY | 2021-01-03 | 2022-05-25 | Democrat | 19 | https://delgado.house.gov | 1007 Longworth House Office Building Washington DC 20515-3219 | 202-225-5614 | 1007 Longworth House Office Building | |||||||||
41716 | 41716 | Jackie Walorski W000813 | rep | IN | 2021-01-03 | 2022-08-03 | Republican | 2 | https://walorski.house.gov | 466 Cannon House Office Building Washington DC 20515-1402 | 202-225-3915 | 466 Cannon House Office Building | http://walorski.house.gov/rss.xml | ||||||||
41719 | 41719 | Charlie Crist C001111 | rep | FL | 2021-01-03 | 2022-08-31 | Democrat | 13 | https://crist.house.gov | 215 Cannon House Office Building Washington DC 20515-0913 | 202-225-5961 | 215 Cannon House Office Building | |||||||||
41726 | 41726 | Theodore Deutch D000610 | rep | FL | 2021-01-03 | 2022-09-30 | Democrat | 22 | https://teddeutch.house.gov | 2323 Rayburn House Office Building Washington DC 20515-0922 | 202-225-3001 | 2323 Rayburn House Office Building | http://teddeutch.house.gov/news/rss.aspx | ||||||||
41729 | 41729 | A. McEachin M001200 | rep | VA | 2021-01-03 | 2022-11-28 | Democrat | 4 | https://mceachin.house.gov | 314 Cannon House Office Building Washington DC 20515-4604 | 202-225-6365 | 314 Cannon House Office Building | |||||||||
41830 | 41830 | Susan Collins C001035 | sen | ME | 2021-01-03 | 2027-01-03 | 2 | Republican | https://www.collins.senate.gov | 413 Dirksen Senate Office Building Washington DC 20510 | 202-224-2523 | https://www.collins.senate.gov/contact | 413 Dirksen Senate Office Building | senior | http://www.collins.senate.gov/public/?a=rss.feed | ||||||
41835 | 41835 | John Cornyn C001056 | sen | TX | 2021-01-03 | 2027-01-03 | 2 | Republican | https://www.cornyn.senate.gov | 517 Hart Senate Office Building Washington DC 20510 | 202-224-2934 | https://www.cornyn.senate.gov/contact | 517 Hart Senate Office Building | senior | http://www.cornyn.senate.gov/public/?a=rss.feed | ||||||
41847 | 41847 | Richard Durbin D000563 | sen | IL | 2021-01-03 | 2027-01-03 | 2 | Democrat | https://www.durbin.senate.gov | 711 Hart Senate Office Building Washington DC 20510 | 202-224-2152 | https://www.durbin.senate.gov/contact/ | 711 Hart Senate Office Building | senior | http://durbin.senate.gov/public/index.cfm/rss/feed | ||||||
41855 | 41855 | Lindsey Graham G000359 | sen | SC | 2021-01-03 | 2027-01-03 | 2 | Republican | https://www.lgraham.senate.gov/public | 290 Russell Senate Office Building Washington DC 20510 | 202-224-5972 | https://www.lgraham.senate.gov/public/index.cfm/e-mail-senator-graham | 290 Russell Senate Office Building | senior | http://www.lgraham.senate.gov/public/index.cfm?FuseAction=Rss.Feed | ||||||
41865 | 41865 | James Inhofe I000024 | sen | OK | 2021-01-03 | 2027-01-03 | 2 | Republican | https://www.inhofe.senate.gov | 205 Russell Senate Office Building Washington DC 20510 | 202-224-4721 | https://www.inhofe.senate.gov/contact | 205 Russell Senate Office Building | senior | http://www.inhofe.senate.gov/rss/feeds/?type=all&cachebuster=eea6c4d7%2d939c%2d5c1e%2db6c7aa3b8b291208 | ||||||
41872 | 41872 | Mitch McConnell M000355 | sen | KY | 2021-01-03 | 2027-01-03 | 2 | Republican | https://www.mcconnell.senate.gov | 317 Russell Senate Office Building Washington DC 20510 | 202-224-2541 | https://www.mcconnell.senate.gov/public/index.cfm?p=contact | 317 Russell Senate Office Building | senior | http://www.mcconnell.senate.gov/public/?a=rss.feed | ||||||
41875 | 41875 | Jeff Merkley M001176 | sen | OR | 2021-01-03 | 2027-01-03 | 2 | Democrat | https://www.merkley.senate.gov | 531 Hart Senate Office Building Washington DC 20510 | 202-224-3753 | https://www.merkley.senate.gov/contact/ | 531 Hart Senate Office Building | junior | http://www.merkley.senate.gov/rss/ | ||||||
41883 | 41883 | John Reed R000122 | sen | RI | 2021-01-03 | 2027-01-03 | 2 | Democrat | https://www.reed.senate.gov | 728 Hart Senate Office Building Washington DC 20510 | 202-224-4642 | https://www.reed.senate.gov/contact/ | 728 Hart Senate Office Building | senior | https://www.reed.senate.gov//rss/feeds/?type=all | ||||||
41886 | 41886 | James Risch R000584 | sen | ID | 2021-01-03 | 2027-01-03 | 2 | Republican | https://www.risch.senate.gov | 483 Russell Senate Office Building Washington DC 20510 | 202-224-2752 | https://www.risch.senate.gov/public/index.cfm?p=Email | 483 Russell Senate Office Building | junior | |||||||
41889 | 41889 | Jeanne Shaheen S001181 | sen | NH | 2021-01-03 | 2027-01-03 | 2 | Democrat | https://www.shaheen.senate.gov | 506 Hart Senate Office Building Washington DC 20510 | 202-224-2841 | https://www.shaheen.senate.gov/contact/contact-jeanne | 506 Hart Senate Office Building | senior | http://www.shaheen.senate.gov/rss/ | ||||||
41892 | 41892 | Mark Warner W000805 | sen | VA | 2021-01-03 | 2027-01-03 | 2 | Democrat | https://www.warner.senate.gov | 703 Hart Senate Office Building Washington DC 20510 | 202-224-2023 | https://www.warner.senate.gov/public/index.cfm?p=Contact | 703 Hart Senate Office Building | senior | http://www.warner.senate.gov/public/?a=rss.feed | ||||||
41900 | 41900 | Christopher Coons C001088 | sen | DE | 2021-01-03 | 2027-01-03 | 2 | Democrat | https://www.coons.senate.gov | 218 Russell Senate Office Building Washington DC 20510 | 202-224-5042 | https://www.coons.senate.gov/contact | 218 Russell Senate Office Building | junior | http://www.coons.senate.gov/rss/feeds/?type=all | ||||||
41916 | 41916 | Robert Aderholt A000055 | rep | AL | 2021-01-03 | 2023-01-03 | Republican | 4 | https://aderholt.house.gov | 266 Cannon House Office Building Washington DC 20515-0104 | 202-225-4876 | 266 Cannon House Office Building | http://aderholt.house.gov/common/rss//index.cfm?rss=20 | ||||||||
41931 | 41931 | Karen Bass B001270 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 37 | https://bass.house.gov | 2021 Rayburn House Office Building Washington DC 20515-0537 | 202-225-7084 | 2021 Rayburn House Office Building | http://bass.house.gov/rss.xml | ||||||||
41942 | 41942 | Gus Bilirakis B001257 | rep | FL | 2021-01-03 | 2023-01-03 | Republican | 12 | https://bilirakis.house.gov | 2354 Rayburn House Office Building Washington DC 20515-0912 | 202-225-5755 | 2354 Rayburn House Office Building | http://bilirakis.house.gov/index.php?format=feed&type=rss | ||||||||
41957 | 41957 | Sanford Bishop B000490 | rep | GA | 2021-01-03 | 2023-01-03 | Democrat | 2 | https://bishop.house.gov | 2407 Rayburn House Office Building Washington DC 20515-1002 | 202-225-3631 | 2407 Rayburn House Office Building | http://bishop.house.gov/rss.xml | ||||||||
41980 | 41980 | Earl Blumenauer B000574 | rep | OR | 2021-01-03 | 2023-01-03 | Democrat | 3 | https://blumenauer.house.gov | 1111 Longworth House Office Building Washington DC 20515-3703 | 202-225-4811 | 1111 Longworth House Office Building | http://blumenauer.house.gov/index.php?format=feed&type=rss | ||||||||
42011 | 42011 | Kevin Brady B000755 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 8 | https://kevinbrady.house.gov | 1011 Longworth House Office Building Washington DC 20515-4308 | 202-225-4901 | 1011 Longworth House Office Building | http://kevinbrady.house.gov/common/rss/index.cfm?rss=49 | ||||||||
42017 | 42017 | Mo Brooks B001274 | rep | AL | 2021-01-03 | 2023-01-03 | Republican | 5 | https://brooks.house.gov | 2185 Rayburn House Office Building Washington DC 20515-0105 | 202-225-4801 | 2185 Rayburn House Office Building | http://brooks.house.gov/rss/press-releases.xml | ||||||||
42025 | 42025 | Vern Buchanan B001260 | rep | FL | 2021-01-03 | 2023-01-03 | Republican | 16 | https://buchanan.house.gov | 2110 Rayburn House Office Building Washington DC 20515-0916 | 202-225-5015 | 2110 Rayburn House Office Building | http://buchanan.house.gov/index.php?option=com_bca-rss-syndicator&feed_id=2 | ||||||||
42031 | 42031 | Larry Bucshon B001275 | rep | IN | 2021-01-03 | 2023-01-03 | Republican | 8 | https://bucshon.house.gov | 2313 Rayburn House Office Building Washington DC 20515-1408 | 202-225-4636 | 2313 Rayburn House Office Building | http://bucshon.house.gov/rss.xml | ||||||||
42041 | 42041 | Michael Burgess B001248 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 26 | https://burgess.house.gov | 2161 Rayburn House Office Building Washington DC 20515-4326 | 202-225-7772 | 2161 Rayburn House Office Building | http://burgess.house.gov/news/rss.aspx | ||||||||
42059 | 42059 | George Butterfield B001251 | rep | NC | 2021-01-03 | 2023-01-03 | Democrat | 1 | https://butterfield.house.gov | 2080 Rayburn House Office Building Washington DC 20515-3301 | 202-225-3101 | 2080 Rayburn House Office Building | http://butterfield.house.gov/rss/press-releases.xml/ | ||||||||
42074 | 42074 | Ken Calvert C000059 | rep | CA | 2021-01-03 | 2023-01-03 | Republican | 42 | https://calvert.house.gov | 2205 Rayburn House Office Building Washington DC 20515-0542 | 202-225-1986 | 2205 Rayburn House Office Building | http://calvert.house.gov/news/rss.aspx | ||||||||
42083 | 42083 | Shelley Capito C001047 | sen | WV | 2021-01-03 | 2027-01-03 | 2 | Republican | https://www.capito.senate.gov | 172 Russell Senate Office Building Washington DC 20510 | 202-224-6472 | https://www.capito.senate.gov/contact/contact-shelley | 172 Russell Senate Office Building | junior | |||||||
42091 | 42091 | André Carson C001072 | rep | IN | 2021-01-03 | 2023-01-03 | Democrat | 7 | https://carson.house.gov | 2135 Rayburn House Office Building Washington DC 20515-1407 | 202-225-4011 | 2135 Rayburn House Office Building | http://carson.house.gov/index.php?option=com_bca-rss-syndicator&feed_id=1 | ||||||||
42101 | 42101 | John Carter C001051 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 31 | https://carter.house.gov | 2208 Rayburn House Office Building Washington DC 20515-4331 | 202-225-3864 | 2208 Rayburn House Office Building | http://carter.house.gov/common/rss/?rss=40 | ||||||||
42106 | 42106 | Bill Cassidy C001075 | sen | LA | 2021-01-03 | 2027-01-03 | 2 | Republican | https://www.cassidy.senate.gov | 520 Hart Senate Office Building Washington DC 20510 | 202-224-5824 | https://www.cassidy.senate.gov/contact | 520 Hart Senate Office Building | senior | |||||||
42114 | 42114 | Kathy Castor C001066 | rep | FL | 2021-01-03 | 2023-01-03 | Democrat | 14 | https://castor.house.gov | 2052 Rayburn House Office Building Washington DC 20515-0914 | 202-225-3376 | 2052 Rayburn House Office Building | http://castor.house.gov/news/rss.aspx | ||||||||
42127 | 42127 | Steve Chabot C000266 | rep | OH | 2021-01-03 | 2023-01-03 | Republican | 1 | https://chabot.house.gov | 2408 Rayburn House Office Building Washington DC 20515-3501 | 202-225-2216 | 2408 Rayburn House Office Building | http://chabot.house.gov/common/rss/index.cfm?rss=49 | ||||||||
42134 | 42134 | Judy Chu C001080 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 27 | https://chu.house.gov | 2423 Rayburn House Office Building Washington DC 20515-0527 | 202-225-5464 | 2423 Rayburn House Office Building | http://chu.house.gov/rss.xml | ||||||||
42140 | 42140 | David Cicilline C001084 | rep | RI | 2021-01-03 | 2023-01-03 | Democrat | 1 | https://cicilline.house.gov | 2233 Rayburn House Office Building Washington DC 20515-3901 | 202-225-4911 | 2233 Rayburn House Office Building | http://cicilline.house.gov/rss.xml | ||||||||
42148 | 42148 | Yvette Clarke C001067 | rep | NY | 2021-01-03 | 2023-01-03 | Democrat | 9 | https://clarke.house.gov | 2058 Rayburn House Office Building Washington DC 20515-3209 | 202-225-6231 | 2058 Rayburn House Office Building | http://clarke.house.gov/news/rss.aspx | ||||||||
42157 | 42157 | Emanuel Cleaver C001061 | rep | MO | 2021-01-03 | 2023-01-03 | Democrat | 5 | https://cleaver.house.gov | 2335 Rayburn House Office Building Washington DC 20515-2505 | 202-225-4535 | 2335 Rayburn House Office Building | http://cleaver.house.gov/rss.xml | ||||||||
42172 | 42172 | James Clyburn C000537 | rep | SC | 2021-01-03 | 2023-01-03 | Democrat | 6 | https://clyburn.house.gov | 274 Cannon House Office Building Washington DC 20515-4006 | 202-225-3315 | 274 Cannon House Office Building | http://clyburn.house.gov/rss.xml | ||||||||
42180 | 42180 | Steve Cohen C001068 | rep | TN | 2021-01-03 | 2023-01-03 | Democrat | 9 | https://cohen.house.gov | 2104 Rayburn House Office Building Washington DC 20515-4209 | 202-225-3265 | 2104 Rayburn House Office Building | http://cohen.house.gov/rss.xml | ||||||||
42190 | 42190 | Tom Cole C001053 | rep | OK | 2021-01-03 | 2023-01-03 | Republican | 4 | https://cole.house.gov | 2207 Rayburn House Office Building Washington DC 20515-3604 | 202-225-6165 | 2207 Rayburn House Office Building | http://cole.house.gov/rss.xml | ||||||||
42197 | 42197 | Gerald Connolly C001078 | rep | VA | 2021-01-03 | 2023-01-03 | Democrat | 11 | https://connolly.house.gov | 2238 Rayburn House Office Building Washington DC 20515-4611 | 202-225-1492 | 2238 Rayburn House Office Building | http://connolly.house.gov/common/rss//index.cfm?rss=44 | ||||||||
42213 | 42213 | Jim Cooper C000754 | rep | TN | 2021-01-03 | 2023-01-03 | Democrat | 5 | https://cooper.house.gov | 1536 Longworth House Office Building Washington DC 20515-4205 | 202-225-4311 | 1536 Longworth House Office Building | http://cooper.house.gov/index.php?format=feed&type=rss | ||||||||
42222 | 42222 | Jim Costa C001059 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 16 | https://costa.house.gov | 2081 Rayburn House Office Building Washington DC 20515-0516 | 202-225-3341 | 2081 Rayburn House Office Building | http://costa.house.gov/index.php?format=feed&type=rss | ||||||||
42230 | 42230 | Joe Courtney C001069 | rep | CT | 2021-01-03 | 2023-01-03 | Democrat | 2 | https://courtney.house.gov | 2449 Rayburn House Office Building Washington DC 20515-0702 | 202-225-2076 | 2449 Rayburn House Office Building | http://courtney.house.gov/index.php?format=feed&type=rss | ||||||||
42243 | 42243 | Eric Crawford C001087 | rep | AR | 2021-01-03 | 2023-01-03 | Republican | 1 | https://crawford.house.gov | 2422 Rayburn House Office Building Washington DC 20515-0401 | 202-225-4076 | 2422 Rayburn House Office Building | http://crawford.house.gov/news/rss.aspx | ||||||||
42252 | 42252 | Henry Cuellar C001063 | rep | TX | 2021-01-03 | 2023-01-03 | Democrat | 28 | https://cuellar.house.gov | 2372 Rayburn House Office Building Washington DC 20515-4328 | 202-225-1640 | 2372 Rayburn House Office Building | http://cuellar.house.gov/news/rss.aspx | ||||||||
42265 | 42265 | Danny Davis D000096 | rep | IL | 2021-01-03 | 2023-01-03 | Democrat | 7 | https://davis.house.gov | 2159 Rayburn House Office Building Washington DC 20515-1307 | 202-225-5006 | 2159 Rayburn House Office Building | http://davis.house.gov/index.php?format=feed&type=rss | ||||||||
42283 | 42283 | Peter DeFazio D000191 | rep | OR | 2021-01-03 | 2023-01-03 | Democrat | 4 | https://defazio.house.gov | 2134 Rayburn House Office Building Washington DC 20515-3704 | 202-225-6416 | 2134 Rayburn House Office Building | http://www.defazio.house.gov/index.php?format=feed&type=rss | ||||||||
42296 | 42296 | Diana DeGette D000197 | rep | CO | 2021-01-03 | 2023-01-03 | Democrat | 1 | https://degette.house.gov | 2111 Rayburn House Office Building Washington DC 20515-0601 | 202-225-4431 | 2111 Rayburn House Office Building | http://degette.house.gov/index.php?option=com_ninjarsssyndicator&feed_id=1&format=raw | ||||||||
42312 | 42312 | Rosa DeLauro D000216 | rep | CT | 2021-01-03 | 2023-01-03 | Democrat | 3 | https://delauro.house.gov | 2413 Rayburn House Office Building Washington DC 20515-0703 | 202-225-3661 | 2413 Rayburn House Office Building | http://delauro.house.gov/index.php?format=feed&type=rss | ||||||||
42318 | 42318 | Scott DesJarlais D000616 | rep | TN | 2021-01-03 | 2023-01-03 | Republican | 4 | https://desjarlais.house.gov | 2304 Rayburn House Office Building Washington DC 20515-4204 | 202-225-6831 | 2304 Rayburn House Office Building | http://desjarlais.house.gov/news/rss.aspx | ||||||||
42328 | 42328 | Mario Diaz-Balart D000600 | rep | FL | 2021-01-03 | 2023-01-03 | Republican | 25 | https://mariodiazbalart.house.gov | 374 Cannon House Office Building Washington DC 20515-0925 | 202-225-4211 | 374 Cannon House Office Building | http://mariodiazbalart.house.gov/rss.xml | ||||||||
42342 | 42342 | Lloyd Doggett D000399 | rep | TX | 2021-01-03 | 2023-01-03 | Democrat | 35 | https://doggett.house.gov | 2307 Rayburn House Office Building Washington DC 20515-4335 | 202-225-4865 | 2307 Rayburn House Office Building | http://doggett.house.gov/index.php/component/ninjarsssyndicator/?feed_id=1&format=raw | ||||||||
42356 | 42356 | Michael Doyle D000482 | rep | PA | 2021-01-03 | 2023-01-03 | Democrat | 18 | https://doyle.house.gov | 270 Cannon House Office Building Washington DC 20515-3818 | 202-225-2135 | 270 Cannon House Office Building | http://doyle.house.gov/rss.xml | ||||||||
42362 | 42362 | Jeff Duncan D000615 | rep | SC | 2021-01-03 | 2023-01-03 | Republican | 3 | https://jeffduncan.house.gov | 2229 Rayburn House Office Building Washington DC 20515-4003 | 202-225-5301 | 2229 Rayburn House Office Building | http://jeffduncan.house.gov/rss.xml | ||||||||
42377 | 42377 | Anna Eshoo E000215 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 18 | https://eshoo.house.gov | 272 Cannon House Office Building Washington DC 20515-0518 | 202-225-8104 | 272 Cannon House Office Building | http://eshoo.house.gov/index.php?format=feed&type=rss | ||||||||
42383 | 42383 | Charles Fleischmann F000459 | rep | TN | 2021-01-03 | 2023-01-03 | Republican | 3 | https://fleischmann.house.gov | 462 Cannon House Office Building Washington DC 20515-4203 | 202-225-3271 | 462 Cannon House Office Building | http://fleischmann.house.gov/rss.xml | ||||||||
42392 | 42392 | Virginia Foxx F000450 | rep | NC | 2021-01-03 | 2023-01-03 | Republican | 5 | https://foxx.house.gov | 2462 Rayburn House Office Building Washington DC 20515-3305 | 202-225-2071 | 2462 Rayburn House Office Building | http://foxx.house.gov/common/rss/?rss=55 | ||||||||
42399 | 42399 | John Garamendi G000559 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 3 | https://garamendi.house.gov | 2368 Rayburn House Office Building Washington DC 20515-0503 | 202-225-1880 | 2368 Rayburn House Office Building | http://garamendi.house.gov/rss.xml | ||||||||
42405 | 42405 | Bob Gibbs G000563 | rep | OH | 2021-01-03 | 2023-01-03 | Republican | 7 | https://gibbs.house.gov | 2217 Rayburn House Office Building Washington DC 20515-3507 | 202-225-6265 | 2217 Rayburn House Office Building | http://gibbs.house.gov/rss.xml | ||||||||
42414 | 42414 | Louie Gohmert G000552 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 1 | https://gohmert.house.gov | 2269 Rayburn House Office Building Washington DC 20515-4301 | 202-225-3035 | 2269 Rayburn House Office Building | http://gohmert.house.gov/news/rss.aspx | ||||||||
42420 | 42420 | Paul Gosar G000565 | rep | AZ | 2021-01-03 | 2023-01-03 | Republican | 4 | https://gosar.house.gov | 2057 Rayburn House Office Building Washington DC 20515-0304 | 202-225-2315 | 2057 Rayburn House Office Building | http://gosar.house.gov/rss.xml | ||||||||
42433 | 42433 | Kay Granger G000377 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 12 | https://kaygranger.house.gov | 1026 Longworth House Office Building Washington DC 20515-4312 | 202-225-5071 | 1026 Longworth House Office Building | http://kaygranger.house.gov/rss.xml | ||||||||
42454 | 42454 | Sam Graves G000546 | rep | MO | 2021-01-03 | 2023-01-03 | Republican | 6 | https://graves.house.gov | 1135 Longworth House Office Building Washington DC 20515-2506 | 202-225-7041 | 1135 Longworth House Office Building | http://graves.house.gov/common/rss/index.cfm?rss=25 | ||||||||
42463 | 42463 | Al Green G000553 | rep | TX | 2021-01-03 | 2023-01-03 | Democrat | 9 | https://algreen.house.gov | 2347 Rayburn House Office Building Washington DC 20515-4309 | 202-225-7508 | 2347 Rayburn House Office Building | http://algreen.house.gov/rss.xml | ||||||||
42469 | 42469 | H. Griffith G000568 | rep | VA | 2021-01-03 | 2023-01-03 | Republican | 9 | https://morgangriffith.house.gov | 2202 Rayburn House Office Building Washington DC 20515-4609 | 202-225-3861 | 2202 Rayburn House Office Building | http://morgangriffith.house.gov/news/rss.aspx |
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);