legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
472 rows where "end" is on date 2023-01-03 sorted by state
This data as json, copyable, CSV (advanced)
Suggested facets: state, party, state_rank
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
42961 | 42961 | Lisa Murkowski M001153 | sen | AK | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.murkowski.senate.gov | 522 Hart Senate Office Building Washington DC 20510 | 202-224-6665 | 202-224-5301 | https://www.murkowski.senate.gov/public/index.cfm/contact | 522 Hart Senate Office Building | senior | http://www.murkowski.senate.gov/public/?a=rss.feed | |||||
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 | |||||||||
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 | ||||||||
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 | ||||||||
43180 | 43180 | Mike Rogers R000575 | rep | AL | 2021-01-03 | 2023-01-03 | Republican | 3 | https://mikerogers.house.gov | 2469 Rayburn House Office Building Washington DC 20515-0103 | 202-225-3261 | 2469 Rayburn House Office Building | http://mikerogers.house.gov/rss.xml | ||||||||
43345 | 43345 | Terri Sewell S001185 | rep | AL | 2021-01-03 | 2023-01-03 | Democrat | 7 | https://sewell.house.gov | 2201 Rayburn House Office Building Washington DC 20515-0107 | 202-225-2665 | 2201 Rayburn House Office Building | http://sewell.house.gov/rss.xml | ||||||||
43355 | 43355 | Richard Shelby S000320 | sen | AL | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.shelby.senate.gov | 304 Russell Senate Office Building Washington DC 20510 | 202-224-5744 | 202-224-3416 | https://www.shelby.senate.gov/public/index.cfm/emailsenatorshelby | 304 Russell Senate Office Building | senior | http://www.shelby.senate.gov/public/index.cfm/rss/feed | |||||
43939 | 43939 | Gary Palmer P000609 | rep | AL | 2021-01-03 | 2023-01-03 | Republican | 6 | https://palmer.house.gov | 170 Cannon House Office Building Washington DC 20515-0106 | 202-225-4921 | 170 Cannon 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 | |||||||||
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 | |||||||||
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 | |||||
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 | ||||||||
43629 | 43629 | Steve Womack W000809 | rep | AR | 2021-01-03 | 2023-01-03 | Republican | 3 | https://womack.house.gov | 2412 Rayburn House Office Building Washington DC 20515-0403 | 202-225-4301 | 2412 Rayburn House Office Building | http://womack.house.gov/news/rss.aspx | ||||||||
43943 | 43943 | J. Hill H001072 | rep | AR | 2021-01-03 | 2023-01-03 | Republican | 2 | https://hill.house.gov | 1533 Longworth House Office Building Washington DC 20515-0402 | 202-225-2506 | 1533 Longworth House Office Building | |||||||||
43947 | 43947 | Bruce Westerman W000821 | rep | AR | 2021-01-03 | 2023-01-03 | Republican | 4 | https://westerman.house.gov | 202 Cannon House Office Building Washington DC 20515-0404 | 202-225-3772 | 202 Cannon House Office Building | |||||||||
44071 | 44071 | Aumua Amata Radewagen R000600 | rep | AS | 2021-01-03 | 2023-01-03 | Republican | 0 | https://radewagen.house.gov | 1339 Longworth House Office Building Washington DC 20515-5200 | 202-225-8577 | 1339 Longworth House Office Building | |||||||||
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 | ||||||||
42479 | 42479 | Raúl Grijalva G000551 | rep | AZ | 2021-01-03 | 2023-01-03 | Democrat | 3 | https://grijalva.house.gov | 1511 Longworth House Office Building Washington DC 20515-0303 | 202-225-2435 | 1511 Longworth House Office Building | http://grijalva.house.gov/common/rss/?rss=13 | ||||||||
43304 | 43304 | David Schweikert S001183 | rep | AZ | 2021-01-03 | 2023-01-03 | Republican | 6 | https://schweikert.house.gov | 304 Cannon House Office Building Washington DC 20515-0306 | 202-225-2190 | 304 Cannon House Office Building | http://schweikert.house.gov/rss/press-releases.xml | ||||||||
43951 | 43951 | Ruben Gallego G000574 | rep | AZ | 2021-01-03 | 2023-01-03 | Democrat | 7 | https://rubengallego.house.gov | 1131 Longworth House Office Building Washington DC 20515-0307 | 202-225-4065 | 1131 Longworth House Office Building | |||||||||
44111 | 44111 | Tom O’Halleran O000171 | rep | AZ | 2021-01-03 | 2023-01-03 | Democrat | 1 | https://ohalleran.house.gov | 318 Cannon House Office Building Washington DC 20515-0301 | 202-225-3361 | 318 Cannon House Office Building | |||||||||
44114 | 44114 | Andy Biggs B001302 | rep | AZ | 2021-01-03 | 2023-01-03 | Republican | 5 | https://biggs.house.gov | 171 Cannon House Office Building Washington DC 20515-0305 | 202-225-2635 | 171 Cannon House Office Building | |||||||||
44253 | 44253 | Debbie Lesko L000589 | rep | AZ | 2021-01-03 | 2023-01-03 | Republican | 8 | https://lesko.house.gov | 1214 Longworth House Office Building Washington DC 20515-0308 | 202-225-4576 | 1214 Longworth House Office Building | |||||||||
44283 | 44283 | Ann Kirkpatrick K000368 | rep | AZ | 2021-01-03 | 2023-01-03 | Democrat | 2 | https://kirkpatrick.house.gov | 309 Cannon House Office Building Washington DC 20515-0302 | 202-225-2542 | 309 Cannon House Office Building | http://kirkpatrick.house.gov/rss.xml | ||||||||
44285 | 44285 | Greg Stanton S001211 | rep | AZ | 2021-01-03 | 2023-01-03 | Democrat | 9 | https://stanton.house.gov | 207 Cannon House Office Building Washington DC 20515-0309 | 202-225-9888 | 207 Cannon House Office Building | |||||||||
44439 | 44439 | Mark Kelly K000377 | sen | AZ | 2020-12-02 | 2023-01-03 | 3 | Democrat | special-election | https://www.kelly.senate.gov | 516 Hart Senate Office Building Washington DC 20510 | 202-224-2235 | https://www.kelly.senate.gov | 516 Hart Senate Office Building | junior | ||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
42737 | 42737 | Barbara Lee L000551 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 13 | https://lee.house.gov | 2470 Rayburn House Office Building Washington DC 20515-0513 | 202-225-2661 | 2470 Rayburn House Office Building | http://lee.house.gov/rss.xml | ||||||||
42753 | 42753 | Zoe Lofgren L000397 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 19 | https://lofgren.house.gov | 1401 Longworth House Office Building Washington DC 20515-0519 | 202-225-3072 | 1401 Longworth House Office Building | http://lofgren.house.gov/index.php?format=feed&type=rss | ||||||||
42846 | 42846 | Doris Matsui M001163 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 6 | https://matsui.house.gov | 2311 Rayburn House Office Building Washington DC 20515-0506 | 202-225-7163 | 2311 Rayburn House Office Building | http://matsui.house.gov/index.php?format=feed&type=rss | ||||||||
42854 | 42854 | Kevin McCarthy M001165 | rep | CA | 2021-01-03 | 2023-01-03 | Republican | 23 | https://kevinmccarthy.house.gov | 2468 Rayburn House Office Building Washington DC 20515-0523 | 202-225-2915 | 2468 Rayburn House Office Building | http://kevinmccarthy.house.gov/index.php?format=feed&type=rss | ||||||||
42870 | 42870 | Tom McClintock M001177 | rep | CA | 2021-01-03 | 2023-01-03 | Republican | 4 | https://mcclintock.house.gov | 2312 Rayburn House Office Building Washington DC 20515-0504 | 202-225-2511 | 2312 Rayburn House Office Building | http://mcclintock.house.gov/atom.xml | ||||||||
42926 | 42926 | Jerry McNerney M001166 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 9 | https://mcnerney.house.gov | 2265 Rayburn House Office Building Washington DC 20515-0509 | 202-225-1947 | 2265 Rayburn House Office Building | http://mcnerney.house.gov/rss.xml | ||||||||
42999 | 42999 | Grace Napolitano N000179 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 32 | https://napolitano.house.gov | 1610 Longworth House Office Building Washington DC 20515-0532 | 202-225-5256 | 1610 Longworth House Office Building | http://napolitano.house.gov/rss.xml | ||||||||
43089 | 43089 | Nancy Pelosi P000197 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 12 | https://pelosi.house.gov | 1236 Longworth House Office Building Washington DC 20515-0512 | 202-225-4965 | 1236 Longworth House Office Building | http://pelosi.house.gov/atom.xml | ||||||||
43195 | 43195 | Lucille Roybal-Allard R000486 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 40 | https://roybal-allard.house.gov | 2083 Rayburn House Office Building Washington DC 20515-0540 | 202-225-1766 | 2083 Rayburn House Office Building | http://roybal-allard.house.gov/news/rss.aspx | ||||||||
43278 | 43278 | Adam Schiff S001150 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 28 | https://schiff.house.gov | 2309 Rayburn House Office Building Washington DC 20515-0528 | 202-225-4176 | 2309 Rayburn House Office Building | http://schiff.house.gov/common/rss/?rss=49 | ||||||||
43368 | 43368 | Brad Sherman S000344 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 30 | https://sherman.house.gov | 2181 Rayburn House Office Building Washington DC 20515-0530 | 202-225-5911 | 2181 Rayburn House Office Building | http://bradsherman.house.gov/press-releases-and-columns/rss.shtml | ||||||||
43439 | 43439 | Jackie Speier S001175 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 14 | https://speier.house.gov | 2465 Rayburn House Office Building Washington DC 20515-0514 | 202-225-3531 | 2465 Rayburn House Office Building | http://speier.house.gov/index.php?format=feed&type=rss | ||||||||
43449 | 43449 | Linda Sánchez S001156 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 38 | https://lindasanchez.house.gov | 2329 Rayburn House Office Building Washington DC 20515-0538 | 202-225-6676 | 2329 Rayburn House Office Building | http://lindasanchez.house.gov/index.php?format=feed&type=rss | ||||||||
43476 | 43476 | Mike Thompson T000460 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 5 | https://mikethompson.house.gov | 268 Cannon House Office Building Washington DC 20515-0505 | 202-225-3311 | 268 Cannon House Office Building | http://mikethompson.house.gov/news/rss.aspx | ||||||||
43584 | 43584 | Maxine Waters W000187 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 43 | https://waters.house.gov | 2221 Rayburn House Office Building Washington DC 20515-0543 | 202-225-2201 | 2221 Rayburn House Office Building | http://waters.house.gov/news/rss.aspx | ||||||||
43712 | 43712 | Doug LaMalfa L000578 | rep | CA | 2021-01-03 | 2023-01-03 | Republican | 1 | https://lamalfa.house.gov | 408 Cannon House Office Building Washington DC 20515-0501 | 202-225-3076 | 408 Cannon House Office Building | http://lamalfa.house.gov/rss.xml | ||||||||
43717 | 43717 | Jared Huffman H001068 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 2 | https://huffman.house.gov | 1527 Longworth House Office Building Washington DC 20515-0502 | 202-225-5161 | 1527 Longworth House Office Building | http://huffman.house.gov/rss.xml | ||||||||
43722 | 43722 | Ami Bera B001287 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 7 | https://bera.house.gov | 172 Cannon House Office Building Washington DC 20515-0507 | 202-225-5716 | 172 Cannon House Office Building | http://bera.house.gov/rss.xml | ||||||||
43727 | 43727 | Eric Swalwell S001193 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 15 | https://swalwell.house.gov | 174 Cannon House Office Building Washington DC 20515-0515 | 202-225-5065 | 174 Cannon House Office Building | |||||||||
43732 | 43732 | Julia Brownley B001285 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 26 | https://juliabrownley.house.gov | 2262 Rayburn House Office Building Washington DC 20515-0526 | 202-225-5811 | 2262 Rayburn House Office Building | http://juliabrownley.house.gov/rss.xml | ||||||||
43737 | 43737 | Tony Cárdenas C001097 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 29 | https://cardenas.house.gov | 2438 Rayburn House Office Building Washington DC 20515-0529 | 202-225-6131 | 2438 Rayburn House Office Building | http://cardenas.house.gov/rss.xml | ||||||||
43742 | 43742 | Raul Ruiz R000599 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 36 | https://ruiz.house.gov | 2342 Rayburn House Office Building Washington DC 20515-0536 | 202-225-5330 | 2342 Rayburn House Office Building | http://ruiz.house.gov/rss.xml | ||||||||
43747 | 43747 | Mark Takano T000472 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 41 | https://takano.house.gov | 420 Cannon House Office Building Washington DC 20515-0541 | 202-225-2305 | 420 Cannon House Office Building | http://takano.house.gov/rss.xml | ||||||||
43752 | 43752 | Alan Lowenthal L000579 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 47 | https://lowenthal.house.gov | 108 Cannon House Office Building Washington DC 20515-0547 | 202-225-7924 | 108 Cannon House Office Building | http://lowenthal.house.gov/news/rss.aspx | ||||||||
43757 | 43757 | Juan Vargas V000130 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 51 | https://vargas.house.gov | 2244 Rayburn House Office Building Washington DC 20515-0551 | 202-225-8045 | 2244 Rayburn House Office Building | http://vargas.house.gov/rss.xml | ||||||||
43762 | 43762 | Scott Peters P000608 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 52 | https://scottpeters.house.gov | 1201 Longworth House Office Building Washington DC 20515-0552 | 202-225-0508 | 1201 Longworth House Office Building | http://scottpeters.house.gov/rss.xml | ||||||||
43955 | 43955 | Mark DeSaulnier D000623 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 11 | https://desaulnier.house.gov | 503 Cannon House Office Building Washington DC 20515-0511 | 202-225-2095 | 503 Cannon House Office Building | |||||||||
43959 | 43959 | Pete Aguilar A000371 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 31 | https://aguilar.house.gov | 109 Cannon House Office Building Washington DC 20515-0531 | 202-225-3201 | 109 Cannon House Office Building | |||||||||
43963 | 43963 | Ted Lieu L000582 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 33 | https://lieu.house.gov | 403 Cannon House Office Building Washington DC 20515-0533 | 202-225-3976 | 403 Cannon House Office Building | |||||||||
43967 | 43967 | Norma Torres T000474 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 35 | https://torres.house.gov | 2227 Rayburn House Office Building Washington DC 20515-0535 | 202-225-6161 | 2227 Rayburn House Office Building | |||||||||
44117 | 44117 | Ro Khanna K000389 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 17 | https://khanna.house.gov | 306 Cannon House Office Building Washington DC 20515-0517 | 202-225-2631 | 306 Cannon House Office Building | |||||||||
44120 | 44120 | Jimmy Panetta P000613 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 20 | https://panetta.house.gov | 406 Cannon House Office Building Washington DC 20515-0520 | 202-225-2861 | 406 Cannon House Office Building | |||||||||
44123 | 44123 | Salud Carbajal C001112 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 24 | https://carbajal.house.gov | 2331 Rayburn House Office Building Washington DC 20515-0524 | 202-225-3601 | 2331 Rayburn House Office Building | |||||||||
44126 | 44126 | Nanette Barragán B001300 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 44 | https://barragan.house.gov | 2246 Rayburn House Office Building Washington DC 20515-0544 | 202-225-8220 | 2246 Rayburn House Office Building | |||||||||
44129 | 44129 | J. Correa C001110 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 46 | https://correa.house.gov | 2301 Rayburn House Office Building Washington DC 20515-0546 | 202-225-2965 | 2301 Rayburn House Office Building | |||||||||
44238 | 44238 | Jimmy Gomez G000585 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 34 | https://gomez.house.gov | 1530 Longworth House Office Building Washington DC 20515-0534 | 202-225-6235 | 1530 Longworth House Office Building | |||||||||
44287 | 44287 | Josh Harder H001090 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 10 | https://harder.house.gov | 209 Cannon House Office Building Washington DC 20515-0510 | 202-225-4540 | 209 Cannon House Office Building | |||||||||
44289 | 44289 | Katie Porter P000618 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 45 | https://porter.house.gov | 1117 Longworth House Office Building Washington DC 20515-0545 | 202-225-5611 | 1117 Longworth House Office Building | |||||||||
44291 | 44291 | Mike Levin L000593 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 49 | https://mikelevin.house.gov | 1030 Longworth House Office Building Washington DC 20515-0549 | 202-225-3906 | 1030 Longworth 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 | |||||||||
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/ | ||||||||
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 | ||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | ||||||
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 | ||||||||||
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 | |||||
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 | ||||||||
42670 | 42670 | Doug Lamborn L000564 | rep | CO | 2021-01-03 | 2023-01-03 | Republican | 5 | https://lamborn.house.gov | 2371 Rayburn House Office Building Washington DC 20515-0605 | 202-225-4422 | 2371 Rayburn House Office Building | http://lamborn.house.gov/news-rss-graphic/news-rss-graphic/ | ||||||||
43097 | 43097 | Ed Perlmutter P000593 | rep | CO | 2021-01-03 | 2023-01-03 | Democrat | 7 | https://perlmutter.house.gov | 1226 Longworth House Office Building Washington DC 20515-0607 | 202-225-2645 | 1226 Longworth House Office Building | http://perlmutter.house.gov/index.php?format=feed&type=rss | ||||||||
43971 | 43971 | Ken Buck B001297 | rep | CO | 2021-01-03 | 2023-01-03 | Republican | 4 | https://buck.house.gov | 2455 Rayburn House Office Building Washington DC 20515-0604 | 202-225-4676 | 2455 Rayburn House Office Building | |||||||||
44293 | 44293 | Joe Neguse N000191 | rep | CO | 2021-01-03 | 2023-01-03 | Democrat | 2 | https://neguse.house.gov | 1419 Longworth House Office Building Washington DC 20515-0602 | 202-225-2161 | 1419 Longworth House Office Building | |||||||||
44295 | 44295 | Jason Crow C001121 | rep | CO | 2021-01-03 | 2023-01-03 | Democrat | 6 | https://crow.house.gov | 1229 Longworth House Office Building Washington DC 20515-0606 | 202-225-7882 | 1229 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 | |||||||||
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 | |||||
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 | ||||||||
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 | ||||||||
42524 | 42524 | James Himes H001047 | rep | CT | 2021-01-03 | 2023-01-03 | Democrat | 4 | https://himes.house.gov | 2137 Rayburn House Office Building Washington DC 20515-0704 | 202-225-5541 | 2137 Rayburn House Office Building | http://himes.house.gov/rss.xml | ||||||||
42708 | 42708 | John Larson L000557 | rep | CT | 2021-01-03 | 2023-01-03 | Democrat | 1 | https://larson.house.gov | 1501 Longworth House Office Building Washington DC 20515-0701 | 202-225-2265 | 1501 Longworth House Office Building | http://www.larson.house.gov/index.php?format=feed&type=rss | ||||||||
44297 | 44297 | Jahana Hayes H001081 | rep | CT | 2021-01-03 | 2023-01-03 | Democrat | 5 | https://hayes.house.gov | 1415 Longworth House Office Building Washington DC 20515-0705 | 202-225-4476 | 1415 Longworth House Office Building | |||||||||
43032 | 43032 | Eleanor Norton N000147 | rep | DC | 2021-01-03 | 2023-01-03 | Democrat | 0 | https://norton.house.gov | 2136 Rayburn House Office Building Washington DC 20515-5101 | 202-225-8050 | 2136 Rayburn House Office Building | http://norton.house.gov/index.php?format=feed&type=rss | ||||||||
44132 | 44132 | Lisa Blunt Rochester B001303 | rep | DE | 2021-01-03 | 2023-01-03 | Democrat | 0 | https://bluntrochester.house.gov | 1724 Longworth House Office Building Washington DC 20515-0800 | 202-225-4165 | 1724 Longworth House Office Building | |||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 |
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);