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 office
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, district, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
44551 | 44551 | Rudy Yakym Y000067 | rep | IN | 2022-11-14 | 2023-01-03 | Republican | 2 | special-election | ||||||||||||
44529 | 44529 | Marilyn Strickland S001159 | rep | WA | 2021-01-03 | 2023-01-03 | Democrat | 10 | https://strickland.house.gov | 1004 Longworth House Office Building Washington DC 20515-4710 | 202-225-9740 | 1004 Longworth House Office Building | |||||||||
44395 | 44395 | Chip Roy R000614 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 21 | https://roy.house.gov | 1005 Longworth House Office Building Washington DC 20515-4321 | 202-225-4236 | 1005 Longworth House Office Building | |||||||||
44549 | 44549 | Patrick Ryan R000579 | rep | NY | 2022-09-13 | 2023-01-03 | Democrat | 19 | 1007 Longworth House Office Building Washington DC 20515-3219 | 202-225-5614 | 1007 Longworth House Office Building | ||||||||||
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 | |||||||||
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 | ||||||||
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 | ||||||||||
44515 | 44515 | Mondaire Jones J000306 | rep | NY | 2021-01-03 | 2023-01-03 | Democrat | 17 | https://jones.house.gov | 1017 Longworth House Office Building Washington DC 20515-3217 | 202-225-6506 | 1017 Longworth House Office Building | |||||||||
44262 | 44262 | Kevin Hern H001082 | rep | OK | 2021-01-03 | 2023-01-03 | Republican | 1 | https://hern.house.gov | 1019 Longworth House Office Building Washington DC 20515-3601 | 202-225-2211 | 1019 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 | |||||||||
44494 | 44494 | Marie Newman N000192 | rep | IL | 2021-01-03 | 2023-01-03 | Democrat | 3 | https://newman.house.gov | 1022 Longworth House Office Building Washington DC 20515-1303 | 202-225-5701 | 1022 Longworth House Office Building | |||||||||
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 | |||||||||
44192 | 44192 | Don Bacon B001298 | rep | NE | 2021-01-03 | 2023-01-03 | Republican | 2 | https://bacon.house.gov | 1024 Longworth House Office Building Washington DC 20515-2702 | 202-225-4155 | 1024 Longworth House Office Building | |||||||||
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 | ||||||||
44271 | 44271 | Susan Wild W000826 | rep | PA | 2021-01-03 | 2023-01-03 | Democrat | 7 | https://wild.house.gov | 1027 Longworth House Office Building Washington DC 20515-3807 | 202-225-6411 | 1027 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 | |||||||||
44189 | 44189 | Ted Budd B001305 | rep | NC | 2021-01-03 | 2023-01-03 | Republican | 13 | https://budd.house.gov | 103 Cannon House Office Building Washington DC 20515-3313 | 202-225-4531 | 103 Cannon 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 | |||||||||
44159 | 44159 | A. Ferguson F000465 | rep | GA | 2021-01-03 | 2023-01-03 | Republican | 3 | https://ferguson.house.gov | 1032 Longworth House Office Building Washington DC 20515-1003 | 202-225-5901 | 1032 Longworth House Office Building | |||||||||
44307 | 44307 | Cynthia Axne A000378 | rep | IA | 2021-01-03 | 2023-01-03 | Democrat | 3 | https://axne.house.gov | 1034 Longworth House Office Building Washington DC 20515-1503 | 202-225-5476 | 1034 Longworth House Office Building | |||||||||
42918 | 42918 | Cathy McMorris Rodgers M001159 | rep | WA | 2021-01-03 | 2023-01-03 | Republican | 5 | https://mcmorris.house.gov | 1035 Longworth House Office Building Washington DC 20515-4705 | 202-225-2006 | 1035 Longworth House Office Building | http://mcmorris.house.gov/common/rss/?rss=96 | ||||||||
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 | |||||||||
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 | |||||||||
43660 | 43660 | Mark Amodei A000369 | rep | NV | 2021-01-03 | 2023-01-03 | Republican | 2 | https://amodei.house.gov | 104 Cannon House Office Building Washington DC 20515-2802 | 202-225-6155 | 104 Cannon House Office Building | http://amodei.house.gov/common/rss//?rss=49 | ||||||||
43339 | 43339 | Tim Scott S001184 | sen | SC | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.scott.senate.gov | 104 Hart Senate Office Building Washington DC 20510 | 202-224-6121 | 202-225-3407 | https://www.scott.senate.gov/contact/email-me | 104 Hart Senate Office Building | junior | http://www.scott.senate.gov/rss.xml | |||||
43684 | 43684 | Donald Payne P000604 | rep | NJ | 2021-01-03 | 2023-01-03 | Democrat | 10 | https://payne.house.gov | 106 Cannon House Office Building Washington DC 20515-3010 | 202-225-3436 | 106 Cannon House Office Building | http://payne.house.gov/rss.xml | ||||||||
43875 | 43875 | Randy Weber W000814 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 14 | https://weber.house.gov | 107 Cannon House Office Building Washington DC 20515-4314 | 202-225-2831 | 107 Cannon House Office Building | http://weber.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 | ||||||||
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 | |||||||||
43537 | 43537 | Chris Van Hollen V000128 | sen | MD | 2017-01-03 | 2023-01-03 | 3 | Democrat | https://www.vanhollen.senate.gov | 110 Hart Senate Office Building Washington DC 20510 | 202-224-4654 | 202-225-0375 | https://www.vanhollen.senate.gov/contact/email | 110 Hart Senate Office Building | junior | ||||||
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 | |||||||||
44101 | 44101 | Dwight Evans E000296 | rep | PA | 2021-01-03 | 2023-01-03 | Democrat | 3 | https://evans.house.gov | 1105 Longworth House Office Building Washington DC 20515-3803 | 202-225-4001 | 1105 Longworth House Office Building | https://evans.house.gov/rss.xml | ||||||||
44220 | 44220 | Jodey Arrington A000375 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 19 | https://arrington.house.gov | 1107 Longworth House Office Building Washington DC 20515-4319 | 202-225-4005 | 1107 Longworth House Office Building | |||||||||
44325 | 44325 | Ayanna Pressley P000617 | rep | MA | 2021-01-03 | 2023-01-03 | Democrat | 7 | https://pressley.house.gov | 1108 Longworth House Office Building Washington DC 20515-2107 | 202-225-5111 | 1108 Longworth House Office Building | |||||||||
44327 | 44327 | David Trone T000483 | rep | MD | 2021-01-03 | 2023-01-03 | Democrat | 6 | https://trone.house.gov | 1110 Longworth House Office Building Washington DC 20515-2006 | 202-225-2721 | 1110 Longworth House Office Building | |||||||||
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 | ||||||||
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 | |||||||||
43568 | 43568 | Debbie Wasserman Schultz W000797 | rep | FL | 2021-01-03 | 2023-01-03 | Democrat | 23 | https://wassermanschultz.house.gov | 1114 Longworth House Office Building Washington DC 20515-0923 | 202-225-7931 | 1114 Longworth House Office Building | http://wassermanschultz.house.gov/atom.xml | ||||||||
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 | |||||||||
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 | |||||||||
44051 | 44051 | Donald Beyer B001292 | rep | VA | 2021-01-03 | 2023-01-03 | Democrat | 8 | https://beyer.house.gov | 1119 Longworth House Office Building Washington DC 20515-4608 | 202-225-4376 | 1119 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 | ||||||
44379 | 44379 | Tim Burchett B001309 | rep | TN | 2021-01-03 | 2023-01-03 | Republican | 2 | https://burchett.house.gov | 1122 Longworth House Office Building Washington DC 20515-4202 | 202-225-5435 | 1122 Longworth House Office Building | |||||||||
44409 | 44409 | Kim Schrier S001216 | rep | WA | 2021-01-03 | 2023-01-03 | Democrat | 8 | https://schrier.house.gov | 1123 Longworth House Office Building Washington DC 20515-4708 | 202-225-7761 | 1123 Longworth House Office Building | |||||||||
44381 | 44381 | John Rose R000612 | rep | TN | 2021-01-03 | 2023-01-03 | Republican | 6 | https://johnrose.house.gov | 1124 Longworth House Office Building Washington DC 20515-4206 | 202-225-4231 | 1124 Longworth House Office Building | |||||||||
43232 | 43232 | Tim Ryan R000577 | rep | OH | 2021-01-03 | 2023-01-03 | Democrat | 13 | https://timryan.house.gov | 1126 Longworth House Office Building Washington DC 20515-3513 | 202-225-5261 | 1126 Longworth House Office Building | http://timryan.house.gov/rss.xml | ||||||||
43999 | 43999 | Seth Moulton M001196 | rep | MA | 2021-01-03 | 2023-01-03 | Democrat | 6 | https://moulton.house.gov | 1127 Longworth House Office Building Washington DC 20515-2106 | 202-225-8020 | 1127 Longworth House Office Building | |||||||||
44217 | 44217 | Vicente Gonzalez G000581 | rep | TX | 2021-01-03 | 2023-01-03 | Democrat | 15 | https://gonzalez.house.gov | 113 Cannon House Office Building Washington DC 20515-4315 | 202-225-2531 | 113 Cannon House Office Building | |||||||||
44315 | 44315 | Lauren Underwood U000040 | rep | IL | 2021-01-03 | 2023-01-03 | Democrat | 14 | https://underwood.house.gov | 1130 Longworth House Office Building Washington DC 20515-1314 | 202-225-2976 | 1130 Longworth House Office Building | |||||||||
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 | |||||||||
44043 | 44043 | Brendan Boyle B001296 | rep | PA | 2021-01-03 | 2023-01-03 | Democrat | 2 | https://boyle.house.gov | 1133 Longworth House Office Building Washington DC 20515-3802 | 202-225-6111 | 1133 Longworth House Office Building | |||||||||
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 | ||||||||
44399 | 44399 | Colin Allred A000376 | rep | TX | 2021-01-03 | 2023-01-03 | Democrat | 32 | https://allred.house.gov | 114 Cannon House Office Building Washington DC 20515-4332 | 202-225-2231 | 114 Cannon House Office Building | |||||||||
44162 | 44162 | Raja Krishnamoorthi K000391 | rep | IL | 2021-01-03 | 2023-01-03 | Democrat | 8 | https://krishnamoorthi.house.gov | 115 Cannon House Office Building Washington DC 20515-1308 | 202-225-3711 | 115 Cannon House Office Building | |||||||||
44007 | 44007 | Debbie Dingell D000624 | rep | MI | 2021-01-03 | 2023-01-03 | Democrat | 12 | https://debbiedingell.house.gov | 116 Cannon House Office Building Washington DC 20515-2212 | 202-225-4071 | 116 Cannon House Office Building | |||||||||
44003 | 44003 | John Moolenaar M001194 | rep | MI | 2021-01-03 | 2023-01-03 | Republican | 4 | https://moolenaar.house.gov | 117 Cannon House Office Building Washington DC 20515-2204 | 202-225-3561 | 117 Cannon 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 | |||||||||
44391 | 44391 | Lizzie Fletcher F000468 | rep | TX | 2021-01-03 | 2023-01-03 | Democrat | 7 | https://fletcher.house.gov | 119 Cannon House Office Building Washington DC 20515-4307 | 202-225-2571 | 119 Cannon House Office Building | |||||||||
44365 | 44365 | Madeleine Dean D000631 | rep | PA | 2021-01-03 | 2023-01-03 | Democrat | 4 | https://dean.house.gov | 120 Cannon House Office Building Washington DC 20515-3804 | 202-225-4731 | 120 Cannon House Office Building | |||||||||
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 | ||||||||
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 | ||||||||||
44490 | 44490 | Kaialiʻi Kahele K000396 | rep | HI | 2021-01-03 | 2023-01-03 | Democrat | 2 | https://kahele.house.gov | 1205 Longworth House Office Building Washington DC 20515-1102 | 202-225-4906 | 1205 Longworth House Office Building | |||||||||
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 | |||||||||
44506 | 44506 | Deborah Ross R000305 | rep | NC | 2021-01-03 | 2023-01-03 | Democrat | 2 | https://ross.house.gov | 1208 Longworth House Office Building Washington DC 20515-3302 | 202-225-3032 | 1208 Longworth House Office Building | |||||||||
44329 | 44329 | Elissa Slotkin S001208 | rep | MI | 2021-01-03 | 2023-01-03 | Democrat | 8 | https://slotkin.house.gov | 1210 Longworth House Office Building Washington DC 20515-2208 | 202-225-4872 | 1210 Longworth House Office Building | |||||||||
43991 | 43991 | Mike Bost B001295 | rep | IL | 2021-01-03 | 2023-01-03 | Republican | 12 | https://bost.house.gov | 1211 Longworth House Office Building Washington DC 20515-1312 | 202-225-5661 | 1211 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 | |||||||||
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 | |||||||||
44407 | 44407 | Jennifer Wexton W000825 | rep | VA | 2021-01-03 | 2023-01-03 | Democrat | 10 | https://wexton.house.gov | 1217 Longworth House Office Building Washington DC 20515-4610 | 202-225-5136 | 1217 Longworth House Office Building | |||||||||
44367 | 44367 | Chrissy Houlahan H001085 | rep | PA | 2021-01-03 | 2023-01-03 | Democrat | 6 | https://houlahan.house.gov | 1218 Longworth House Office Building Washington DC 20515-3806 | 202-225-4315 | 1218 Longworth House Office Building | |||||||||
44371 | 44371 | John Joyce J000302 | rep | PA | 2021-01-03 | 2023-01-03 | Republican | 13 | https://johnjoyce.house.gov | 1221 Longworth House Office Building Washington DC 20515-3813 | 202-225-2431 | 1221 Longworth House Office Building | |||||||||
44419 | 44419 | Jared Golden G000592 | rep | ME | 2021-01-03 | 2023-01-03 | Democrat | 2 | https://golden.house.gov | 1222 Longworth House Office Building Washington DC 20515-1902 | 202-225-6306 | 1222 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 | |||||||||
44250 | 44250 | Conor Lamb L000588 | rep | PA | 2021-01-03 | 2023-01-03 | Democrat | 17 | https://lamb.house.gov | 1224 Longworth House Office Building Washington DC 20515-3817 | 202-225-2301 | 1224 Longworth House Office Building | |||||||||
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 | ||||||||
44268 | 44268 | Mary Scanlon S001205 | rep | PA | 2021-01-03 | 2023-01-03 | Democrat | 5 | https://scanlon.house.gov | 1227 Longworth House Office Building Washington DC 20515-3805 | 202-225-2011 | 1227 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 | |||||||||
44226 | 44226 | Mike Gallagher G000579 | rep | WI | 2021-01-03 | 2023-01-03 | Republican | 8 | https://gallagher.house.gov | 1230 Longworth House Office Building Washington DC 20515-4908 | 202-225-5665 | 1230 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 | |||||||||
43780 | 43780 | Cheri Bustos B001286 | rep | IL | 2021-01-03 | 2023-01-03 | Democrat | 17 | https://bustos.house.gov | 1233 Longworth House Office Building Washington DC 20515-1317 | 202-225-5905 | 1233 Longworth House Office Building | http://bustos.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 | ||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
44317 | 44317 | James Baird B001307 | rep | IN | 2021-01-03 | 2023-01-03 | Republican | 4 | https://baird.house.gov | 1314 Longworth House Office Building Washington DC 20515-1404 | 202-225-5037 | 1314 Longworth House Office Building | |||||||||
44265 | 44265 | Joseph Morelle M001206 | rep | NY | 2021-01-03 | 2023-01-03 | Democrat | 25 | https://morelle.house.gov | 1317 Longworth House Office Building Washington DC 20515-3225 | 202-225-3615 | 1317 Longworth House Office Building | |||||||||
44355 | 44355 | Tom Malinowski M001203 | rep | NJ | 2021-01-03 | 2023-01-03 | Democrat | 7 | https://malinowski.house.gov | 1318 Longworth House Office Building Washington DC 20515-3007 | 202-225-5361 | 1318 Longworth House Office Building | |||||||||
44487 | 44487 | Carolyn Bourdeaux B001312 | rep | GA | 2021-01-03 | 2023-01-03 | Democrat | 7 | https://bourdeaux.house.gov | 1319 Longworth House Office Building Washington DC 20515-1007 | 202-225-4272 | 1319 Longworth House Office Building | |||||||||
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 | |||||||||
44180 | 44180 | Anthony Brown B001304 | rep | MD | 2021-01-03 | 2023-01-03 | Democrat | 4 | https://anthonybrown.house.gov | 1323 Longworth House Office Building Washington DC 20515-2004 | 202-225-8699 | 1323 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 | |||||||||
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 | |||||||||
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 | |||||||||
42443 | 42443 | Charles Grassley G000386 | sen | IA | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.grassley.senate.gov | 135 Hart Senate Office Building Washington DC 20510 | 202-224-3744 | 202-224-6020 | https://www.grassley.senate.gov/contact | 135 Hart Senate Office Building | senior | http://grassley.senate.gov/customcf/rss_feed.cfm | |||||
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 | ||||||||
44387 | 44387 | Van Taylor T000479 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 3 | https://vantaylor.house.gov | 1404 Longworth House Office Building Washington DC 20515-4303 | 202-225-4201 | 1404 Longworth House Office Building | |||||||||
44486 | 44486 | Nikema Williams W000788 | rep | GA | 2021-01-03 | 2023-01-03 | Democrat | 5 | https://nikemawilliams.house.gov | 1406 Longworth House Office Building Washington DC 20515-1005 | 202-225-3801 | 1406 Longworth House Office Building | |||||||||
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 | |||||||||
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 |
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);