legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
44,551 rows sorted by end descending
This data as json, copyable, CSV (advanced)
Suggested facets: how, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||
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 | |||||||
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 | |||||||
42788 | 42788 | Ben Luján L000570 | sen | NM | 2021-01-03 | 2027-01-03 | 2 | Democrat | https://www.lujan.senate.gov | 498 Russell Senate Office Building Washington DC 20510 | 202-224-6621 | https://www.lujan.senate.gov/contact/ | 498 Russell Senate Office Building | junior | |||||||
42837 | 42837 | Edward Markey M000133 | sen | MA | 2021-01-03 | 2027-01-03 | 2 | Democrat | https://www.markey.senate.gov | 255 Dirksen Senate Office Building Washington DC 20510 | 202-224-2742 | https://www.markey.senate.gov/contact | 255 Dirksen Senate Office Building | junior | |||||||
43102 | 43102 | Gary Peters P000595 | sen | MI | 2021-01-03 | 2027-01-03 | 2 | Democrat | https://www.peters.senate.gov | 724 Hart Senate Office Building Washington DC 20510 | 202-224-6221 | https://www.peters.senate.gov/contact/email-gary | 724 Hart Senate Office Building | junior | |||||||
43703 | 43703 | Tom Cotton C001095 | sen | AR | 2021-01-03 | 2027-01-03 | 2 | Republican | https://www.cotton.senate.gov | 326 Russell Senate Office Building Washington DC 20510 | 202-224-2353 | https://www.cotton.senate.gov/contact/contact-tom | 326 Russell Senate Office Building | junior | |||||||
43802 | 43802 | Steve Daines D000618 | sen | MT | 2021-01-03 | 2027-01-03 | 2 | Republican | https://www.daines.senate.gov | 320 Hart Senate Office Building Washington DC 20510 | 202-224-2651 | https://www.daines.senate.gov/connect/email-steve | 320 Hart Senate Office Building | junior | |||||||
43920 | 43920 | Cory Booker B001288 | sen | NJ | 2021-01-03 | 2027-01-03 | 2 | Democrat | https://www.booker.senate.gov | 717 Hart Senate Office Building Washington DC 20510 | 202-224-3224 | https://www.booker.senate.gov/?p=contact | 717 Hart Senate Office Building | junior | |||||||
44073 | 44073 | Dan Sullivan S001198 | sen | AK | 2021-01-03 | 2027-01-03 | 2 | Republican | https://www.sullivan.senate.gov | 302 Hart Senate Office Building Washington DC 20510 | 202-224-3004 | https://www.sullivan.senate.gov/contact/email | 302 Hart Senate Office Building | junior | |||||||
44075 | 44075 | Joni Ernst E000295 | sen | IA | 2021-01-03 | 2027-01-03 | 2 | Republican | https://www.ernst.senate.gov | 730 Hart Senate Office Building Washington DC 20510 | 202-224-3254 | https://www.ernst.senate.gov/public/index.cfm/contact | 730 Hart Senate Office Building | junior | |||||||
44077 | 44077 | Thom Tillis T000476 | sen | NC | 2021-01-03 | 2027-01-03 | 2 | Republican | https://www.tillis.senate.gov | 113 Dirksen Senate Office Building Washington DC 20510 | 202-224-6342 | https://www.tillis.senate.gov/public/index.cfm/email-me | 113 Dirksen Senate Office Building | junior | |||||||
44079 | 44079 | Mike Rounds R000605 | sen | SD | 2021-01-03 | 2027-01-03 | 2 | Republican | https://www.rounds.senate.gov | 716 Hart Senate Office Building Washington DC 20510 | 202-224-5842 | https://www.rounds.senate.gov/contact/email-mike | 716 Hart Senate Office Building | junior | |||||||
44081 | 44081 | Benjamin Sasse S001197 | sen | NE | 2021-01-03 | 2027-01-03 | 2 | Republican | https://www.sasse.senate.gov/public | 139 Russell Senate Office Building Washington DC 20510 | 202-224-4224 | https://www.sasse.senate.gov/public/index.cfm/email-ben | 139 Russell Senate Office Building | junior | |||||||
44171 | 44171 | Roger Marshall M001198 | sen | KS | 2021-01-03 | 2027-01-03 | 2 | Republican | https://www.marshall.senate.gov | 479A Russell Senate Office Building Washington DC 20510 | 202-224-4774 | https://www.marshall.senate.gov/contact/ | 479a Russell Senate Office Building | junior | |||||||
44244 | 44244 | Tina Smith S001203 | sen | MN | 2021-01-03 | 2027-01-03 | 2 | Democrat | https://www.smith.senate.gov | 720 Hart Senate Office Building Washington DC 20510 | 202-224-5641 | https://www.smith.senate.gov/share-your-opinion/ | 720 Hart Senate Office Building | junior | |||||||
44247 | 44247 | Cindy Hyde-Smith H001079 | sen | MS | 2021-01-03 | 2027-01-03 | 2 | Republican | https://www.hydesmith.senate.gov | 702 Hart Senate Office Building Washington DC 20510 | 202-224-5054 | https://www.hydesmith.senate.gov/content/contact-senator | 702 Hart Senate Office Building | junior | |||||||
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 | |||||||
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 | |||||||
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 | |||||||
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 | |||||||
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 | |||||||
41739 | 41739 | Sherrod Brown B000944 | sen | OH | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.brown.senate.gov | 503 Hart Senate Office Building Washington DC 20510 | 202-224-2315 | https://www.brown.senate.gov/contact/ | 503 Hart Senate Office Building | senior | http://www.brown.senate.gov/rss/feeds/?type=all& | ||||||
41744 | 41744 | Maria Cantwell C000127 | sen | WA | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.cantwell.senate.gov | 511 Hart Senate Office Building Washington DC 20510 | 202-224-3441 | https://www.cantwell.senate.gov/public/index.cfm/email-maria | 511 Hart Senate Office Building | junior | http://www.cantwell.senate.gov/public/index.cfm/rss/feed | ||||||
41757 | 41757 | Benjamin Cardin C000141 | sen | MD | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.cardin.senate.gov | 509 Hart Senate Office Building Washington DC 20510 | 202-224-4524 | https://www.cardin.senate.gov/contact/ | 509 Hart Senate Office Building | senior | http://www.cardin.senate.gov/rss/feeds/?type=all | ||||||
41766 | 41766 | Thomas Carper C000174 | sen | DE | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.carper.senate.gov/public | 513 Hart Senate Office Building Washington DC 20510 | 202-224-2441 | https://www.carper.senate.gov/public/index.cfm/email-senator-carper | 513 Hart Senate Office Building | senior | http://www.carper.senate.gov/public/index.cfm/rss/feed | ||||||
41769 | 41769 | Robert Casey C001070 | sen | PA | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.casey.senate.gov | 393 Russell Senate Office Building Washington DC 20510 | 202-224-6324 | https://www.casey.senate.gov/contact | 393 Russell Senate Office Building | senior | http://www.casey.senate.gov/rss/feeds/?all | ||||||
41775 | 41775 | Dianne Feinstein F000062 | sen | CA | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.feinstein.senate.gov | 331 Hart Senate Office Building Washington DC 20510 | 202-224-3841 | https://www.feinstein.senate.gov/public/index.cfm/e-mail-me | 331 Hart Senate Office Building | senior | http://www.feinstein.senate.gov/public/?a=rss.feed | ||||||
41778 | 41778 | Amy Klobuchar K000367 | sen | MN | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.klobuchar.senate.gov | 425 Dirksen Senate Office Building Washington DC 20510 | 202-224-3244 | https://www.klobuchar.senate.gov/public/index.cfm/contact | 425 Dirksen Senate Office Building | senior | |||||||
41789 | 41789 | Robert Menendez M000639 | sen | NJ | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.menendez.senate.gov | 528 Hart Senate Office Building Washington DC 20510 | 202-224-4744 | https://www.menendez.senate.gov/contact | 528 Hart Senate Office Building | senior | http://www.menendez.senate.gov/rss/feeds/index.cfm?type=news | ||||||
41800 | 41800 | Bernard Sanders S000033 | sen | VT | 2019-01-03 | 2025-01-03 | 1 | Independent | https://www.sanders.senate.gov | Democrat | 332 Dirksen Senate Office Building Washington DC 20510 | 202-224-5141 | https://www.sanders.senate.gov/contact/ | 332 Dirksen Senate Office Building | junior | http://www.sanders.senate.gov/rss/ | |||||
41806 | 41806 | Debbie Stabenow S000770 | sen | MI | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.stabenow.senate.gov | 731 Hart Senate Office Building Washington DC 20510 | 202-224-4822 | https://www.stabenow.senate.gov/contact | 731 Hart Senate Office Building | senior | http://stabenow.senate.gov/rss/?p=news | ||||||
41809 | 41809 | Jon Tester T000464 | sen | MT | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.tester.senate.gov | 311 Hart Senate Office Building Washington DC 20510 | 202-224-2644 | https://www.tester.senate.gov/?p=email_senator | 311 Hart Senate Office Building | senior | http://www.tester.senate.gov/rss/?p=hot_topic | ||||||
41812 | 41812 | Sheldon Whitehouse W000802 | sen | RI | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.whitehouse.senate.gov | 530 Hart Senate Office Building Washington DC 20510 | 202-224-2921 | https://www.whitehouse.senate.gov/contact/email-sheldon | 530 Hart Senate Office Building | junior | http://www.whitehouse.senate.gov/rss/feeds/?type=all&cachebuster=1 | ||||||
41815 | 41815 | John Barrasso B001261 | sen | WY | 2019-01-03 | 2025-01-03 | 1 | Republican | https://www.barrasso.senate.gov | 307 Dirksen Senate Office Building Washington DC 20510 | 202-224-6441 | https://www.barrasso.senate.gov/public/index.cfm/contact-form | 307 Dirksen Senate Office Building | senior | http://www.barrasso.senate.gov/public/index.cfm?FuseAction=Rss.Feed | ||||||
41825 | 41825 | Roger Wicker W000437 | sen | MS | 2019-01-03 | 2025-01-03 | 1 | Republican | https://www.wicker.senate.gov | 555 Dirksen Senate Office Building Washington DC 20510 | 202-224-6253 | https://www.wicker.senate.gov/public/index.cfm/contact | 555 Dirksen Senate Office Building | senior | |||||||
41897 | 41897 | Kirsten Gillibrand G000555 | sen | NY | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.gillibrand.senate.gov | 478 Russell Senate Office Building Washington DC 20510 | 202-224-4451 | https://www.gillibrand.senate.gov/contact/email-me | 478 Russell Senate Office Building | junior | http://www.gillibrand.senate.gov/rss/ | ||||||
41903 | 41903 | Joe Manchin M001183 | sen | WV | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.manchin.senate.gov | 306 Hart Senate Office Building Washington DC 20510 | 202-224-3954 | https://www.manchin.senate.gov/public/index.cfm/contact-form | 306 Hart Senate Office Building | senior | http://www.manchin.senate.gov/public/index.cfm/rss/feed | ||||||
41925 | 41925 | Tammy Baldwin B001230 | sen | WI | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.baldwin.senate.gov | 709 Hart Senate Office Building Washington DC 20510 | 202-224-5653 | https://www.baldwin.senate.gov/feedback | 709 Hart Senate Office Building | junior | http://www.baldwin.senate.gov/rss/feeds/?type=all | ||||||
41966 | 41966 | Marsha Blackburn B001243 | sen | TN | 2019-01-03 | 2025-01-03 | 1 | Republican | https://www.blackburn.senate.gov | 357 Dirksen Senate Office Building Washington DC 20510 | 202-224-3344 | https://www.blackburn.senate.gov/email-me | 357 Dirksen Senate Office Building | senior | |||||||
42502 | 42502 | Martin Heinrich H001046 | sen | NM | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.heinrich.senate.gov | 303 Hart Senate Office Building Washington DC 20510 | 202-224-5521 | https://www.heinrich.senate.gov/contact | 303 Hart Senate Office Building | senior | |||||||
42529 | 42529 | Mazie Hirono H001042 | sen | HI | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.hirono.senate.gov | 109 Hart Senate Office Building Washington DC 20510 | 202-224-6361 | https://www.hirono.senate.gov/contact | 109 Hart Senate Office Building | junior | http://www.hirono.senate.gov/rss/feeds/?type=all | ||||||
42966 | 42966 | Christopher Murphy M001169 | sen | CT | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.murphy.senate.gov | 136 Hart Senate Office Building Washington DC 20510 | 202-224-4041 | https://www.murphy.senate.gov/contact | 136 Hart Senate Office Building | junior | http://www.theday.com/article/20121216/nws12/312169935/1069/rss | ||||||
43707 | 43707 | Kyrsten Sinema S001191 | sen | AZ | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.sinema.senate.gov | 317 Hart Senate Office Building Washington DC 20510 | 202-224-4521 | https://www.sinema.senate.gov/contact-kyrsten | 317 Hart Senate Office Building | senior | |||||||
43787 | 43787 | Elizabeth Warren W000817 | sen | MA | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.warren.senate.gov | 309 Hart Senate Office Building Washington DC 20510 | 202-224-4543 | https://www.warren.senate.gov/?p=email_senator | 309 Hart Senate Office Building | senior | http://www.warren.senate.gov/rss/?p=hot_topic | ||||||
43789 | 43789 | Angus King K000383 | sen | ME | 2019-01-03 | 2025-01-03 | 1 | Independent | https://www.king.senate.gov | Democrat | 133 Hart Senate Office Building Washington DC 20510 | 202-224-5344 | https://www.king.senate.gov/contact | 133 Hart Senate Office Building | junior | http://www.king.senate.gov/rss/feeds/?type=all | |||||
43811 | 43811 | Kevin Cramer C001096 | sen | ND | 2019-01-03 | 2025-01-03 | 1 | Republican | https://www.cramer.senate.gov | 330 Hart Senate Office Building Washington DC 20510 | 202-224-2043 | https://www.cramer.senate.gov/contact/contact-kevin | 330 Hart Senate Office Building | junior | |||||||
43813 | 43813 | Deb Fischer F000463 | sen | NE | 2019-01-03 | 2025-01-03 | 1 | Republican | https://www.fischer.senate.gov | 454 Russell Senate Office Building Washington DC 20510 | 202-224-6551 | https://www.fischer.senate.gov/public/index.cfm/contact | 454 Russell Senate Office Building | senior | http://www.fischer.senate.gov/public/index.cfm/rss/feed | ||||||
43870 | 43870 | Ted Cruz C001098 | sen | TX | 2019-01-03 | 2025-01-03 | 1 | Republican | https://www.cruz.senate.gov | 127A Russell Senate Office Building Washington DC 20510 | 202-224-5922 | https://www.cruz.senate.gov/?p=form&id=16 | 127a Russell Senate Office Building | junior | |||||||
43897 | 43897 | Timothy Kaine K000384 | sen | VA | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.kaine.senate.gov | 231 Russell Senate Office Building Washington DC 20510 | 202-224-4024 | https://www.kaine.senate.gov/contact | 231 Russell Senate Office Building | junior | http://www.kaine.senate.gov/rss/feeds/?type=all | ||||||
44197 | 44197 | Jacky Rosen R000608 | sen | NV | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.rosen.senate.gov | 713 Hart Senate Office Building Washington DC 20510 | 202-224-6244 | https://www.rosen.senate.gov/contact_jacky | 713 Hart Senate Office Building | junior | |||||||
44414 | 44414 | Rick Scott S001217 | sen | FL | 2019-01-08 | 2025-01-03 | 1 | Republican | https://www.rickscott.senate.gov | 502 Hart Senate Office Building Washington DC 20510 | 202-224-5274 | https://www.rickscott.senate.gov/contact/contact | 502 Hart Senate Office Building | junior | |||||||
44415 | 44415 | Mike Braun B001310 | sen | IN | 2019-01-03 | 2025-01-03 | 1 | Republican | https://www.braun.senate.gov | 404 Russell Senate Office Building Washington DC 20510 | 202-224-4814 | https://www.braun.senate.gov/contact-mike | 404 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 | |||||||
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 | |||||||
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 | ||||||||
41934 | 41934 | Michael Bennet B001267 | sen | CO | 2017-01-03 | 2023-01-03 | 3 | Democrat | https://www.bennet.senate.gov/public | 261 Russell Senate Office Building Washington DC 20510 | 202-224-5852 | 202-228-5097 | https://www.bennet.senate.gov/public/index.cfm/contact | 261 Russell Senate Office Building | senior | http://www.bennet.senate.gov/rss/feeds/?type=news | |||||
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 | ||||||||
41982 | 41982 | Richard Blumenthal B001277 | sen | CT | 2017-01-03 | 2023-01-03 | 3 | Democrat | https://www.blumenthal.senate.gov | 706 Hart Senate Office Building Washington DC 20510 | 202-224-2823 | 202-224-9673 | https://www.blumenthal.senate.gov/contact/ | 706 Hart Senate Office Building | senior | http://www.blumenthal.senate.gov/rss/feeds/?type=all | |||||
41991 | 41991 | Roy Blunt B000575 | sen | MO | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.blunt.senate.gov | 260 Russell Senate Office Building Washington DC 20510 | 202-224-5721 | 202-224-8149 | https://www.blunt.senate.gov/public/index.cfm/contact-roy | 260 Russell Senate Office Building | senior | http://www.blunt.senate.gov/public/?a=rss.feed | |||||
41998 | 41998 | John Boozman B001236 | sen | AR | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.boozman.senate.gov/public | 141 Hart Senate Office Building Washington DC 20510 | 202-224-4843 | 202-228-1371 | https://www.boozman.senate.gov/public/index.cfm/contact | 141 Hart Senate Office Building | senior | http://www.boozman.senate.gov/public/index.cfm/rss/feed | |||||
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 | ||||||||
42049 | 42049 | Richard Burr B001135 | sen | NC | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.burr.senate.gov | 217 Russell Senate Office Building Washington DC 20510 | 202-224-3154 | 202-228-2981 | https://www.burr.senate.gov/contact | 217 Russell Senate Office Building | senior | http://www.burr.senate.gov/public/index.cfm?fuseaction=rss.feed | |||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
42237 | 42237 | Michael Crapo C000880 | sen | ID | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.crapo.senate.gov | 239 Dirksen Senate Office Building Washington DC 20510 | 202-224-6142 | 202-228-1375 | https://www.crapo.senate.gov/contact | 239 Dirksen Senate Office Building | senior | ||||||
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 |
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);