legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
44,551 rows
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
44172 | 44172 | Clay Higgins H001077 | rep | LA | 2017-01-03 | 2019-01-03 | Republican | 3 | https://clayhiggins.house.gov | 1711 Longworth House Office Building; Washington DC 20515-1803 | 202-225-2031 | 1711 Longworth House Office Building | |||||||||
44173 | 44173 | Clay Higgins H001077 | rep | LA | 2019-01-03 | 2021-01-03 | Republican | 3 | https://clayhiggins.house.gov | 424 Cannon House Office Building Washington DC 20515-1803 | 202-225-2031 | 424 Cannon House Office Building | |||||||||
44174 | 44174 | Clay Higgins H001077 | rep | LA | 2021-01-03 | 2023-01-03 | Republican | 3 | https://clayhiggins.house.gov | 572 Cannon House Office Building Washington DC 20515-1803 | 202-225-2031 | 572 Cannon House Office Building | |||||||||
44175 | 44175 | Mike Johnson J000299 | rep | LA | 2017-01-03 | 2019-01-03 | Republican | 4 | https://mikejohnson.house.gov | 327 Cannon House Office Building; Washington DC 20515-1804 | 202-225-2777 | 327 Cannon House Office Building | |||||||||
44176 | 44176 | Mike Johnson J000299 | rep | LA | 2019-01-03 | 2021-01-03 | Republican | 4 | https://mikejohnson.house.gov | 418 Cannon House Office Building Washington DC 20515-1804 | 202-225-2777 | 418 Cannon House Office Building | |||||||||
44177 | 44177 | Mike Johnson J000299 | rep | LA | 2021-01-03 | 2023-01-03 | Republican | 4 | https://mikejohnson.house.gov | 568 Cannon House Office Building Washington DC 20515-1804 | 202-225-2777 | 568 Cannon House Office Building | |||||||||
44178 | 44178 | Anthony Brown B001304 | rep | MD | 2017-01-03 | 2019-01-03 | Democrat | 4 | https://anthonybrown.house.gov | 1505 Longworth House Office Building; Washington DC 20515-2004 | 202-225-8699 | 1505 Longworth House Office Building | |||||||||
44179 | 44179 | Anthony Brown B001304 | rep | MD | 2019-01-03 | 2021-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 | |||||||||
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 | |||||||||
44181 | 44181 | Jamie Raskin R000606 | rep | MD | 2017-01-03 | 2019-01-03 | Democrat | 8 | https://raskin.house.gov | 431 Cannon House Office Building; Washington DC 20515-2008 | 202-225-5341 | 431 Cannon House Office Building | |||||||||
44182 | 44182 | Jamie Raskin R000606 | rep | MD | 2019-01-03 | 2021-01-03 | Democrat | 8 | https://raskin.house.gov | 412 Cannon House Office Building Washington DC 20515-2008 | 202-225-5341 | 412 Cannon House Office Building | |||||||||
44183 | 44183 | Jamie Raskin R000606 | rep | MD | 2021-01-03 | 2023-01-03 | Democrat | 8 | https://raskin.house.gov | 2242 Rayburn House Office Building Washington DC 20515-2008 | 202-225-5341 | 2242 Rayburn House Office Building | |||||||||
44184 | 44184 | Jack Bergman B001301 | rep | MI | 2017-01-03 | 2019-01-03 | Republican | 1 | https://bergman.house.gov | 414 Cannon House Office Building; Washington DC 20515-2201 | 202-225-4735 | 414 Cannon House Office Building | |||||||||
44185 | 44185 | Jack Bergman B001301 | rep | MI | 2019-01-03 | 2021-01-03 | Republican | 1 | https://bergman.house.gov | 414 Cannon House Office Building Washington DC 20515-2201 | 202-225-4735 | 414 Cannon House Office Building | |||||||||
44186 | 44186 | Jack Bergman B001301 | rep | MI | 2021-01-03 | 2023-01-03 | Republican | 1 | https://bergman.house.gov | 566 Cannon House Office Building Washington DC 20515-2201 | 202-225-4735 | 566 Cannon House Office Building | |||||||||
44187 | 44187 | Ted Budd B001305 | rep | NC | 2017-01-03 | 2019-01-03 | Republican | 13 | https://budd.house.gov | 118 Cannon House Office Building; Washington DC 20515-3313 | 202-225-4531 | 118 Cannon House Office Building | |||||||||
44188 | 44188 | Ted Budd B001305 | rep | NC | 2019-01-03 | 2021-01-03 | Republican | 13 | https://budd.house.gov | 118 Cannon House Office Building Washington DC 20515-3313 | 202-225-4531 | 118 Cannon 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 | |||||||||
44190 | 44190 | Don Bacon B001298 | rep | NE | 2017-01-03 | 2019-01-03 | Republican | 2 | https://bacon.house.gov | 1516 Longworth House Office Building; Washington DC 20515-2702 | 202-225-4155 | 1516 Longworth House Office Building | |||||||||
44191 | 44191 | Don Bacon B001298 | rep | NE | 2019-01-03 | 2021-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 | |||||||||
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 | |||||||||
44193 | 44193 | Josh Gottheimer G000583 | rep | NJ | 2017-01-03 | 2019-01-03 | Democrat | 5 | https://gottheimer.house.gov | 213 Cannon House Office Building; Washington DC 20515-3005 | 202-225-4465 | 213 Cannon House Office Building | |||||||||
44194 | 44194 | Josh Gottheimer G000583 | rep | NJ | 2019-01-03 | 2021-01-03 | Democrat | 5 | https://gottheimer.house.gov | 213 Cannon House Office Building Washington DC 20515-3005 | 202-225-4465 | 213 Cannon House Office Building | |||||||||
44195 | 44195 | Josh Gottheimer G000583 | rep | NJ | 2021-01-03 | 2023-01-03 | Democrat | 5 | https://gottheimer.house.gov | 203 Cannon House Office Building Washington DC 20515-3005 | 202-225-4465 | 203 Cannon House Office Building | |||||||||
44196 | 44196 | Jacky Rosen R000608 | rep | NV | 2017-01-03 | 2019-01-03 | Democrat | 3 | https://rosen.house.gov | 413 Cannon House Office Building; Washington DC 20515-2803 | 202-225-3252 | 413 Cannon House Office Building | |||||||||
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 | |||||||
44198 | 44198 | Thomas Suozzi S001201 | rep | NY | 2017-01-03 | 2019-01-03 | Democrat | 3 | https://suozzi.house.gov | 226 Cannon House Office Building; Washington DC 20515-3203 | 202-225-3335 | 202-225-4669 | 226 Cannon House Office Building | ||||||||
44199 | 44199 | Thomas Suozzi S001201 | rep | NY | 2019-01-03 | 2021-01-03 | Democrat | 3 | https://suozzi.house.gov | 214 Cannon House Office Building Washington DC 20515-3203 | 202-225-3335 | 214 Cannon House Office Building | |||||||||
44200 | 44200 | Thomas Suozzi S001201 | rep | NY | 2021-01-03 | 2023-01-03 | Democrat | 3 | https://suozzi.house.gov | 407 Cannon House Office Building Washington DC 20515-3203 | 202-225-3335 | 407 Cannon House Office Building | |||||||||
44201 | 44201 | Adriano Espaillat E000297 | rep | NY | 2017-01-03 | 2019-01-03 | Democrat | 13 | https://espaillat.house.gov | 1630 Longworth House Office Building; Washington DC 20515-3213 | 202-225-4365 | 202-225-0816 | 1630 Longworth House Office Building | ||||||||
44202 | 44202 | Adriano Espaillat E000297 | rep | NY | 2019-01-03 | 2021-01-03 | Democrat | 13 | https://espaillat.house.gov | 1630 Longworth House Office Building Washington DC 20515-3213 | 202-225-4365 | 1630 Longworth House Office Building | |||||||||
44203 | 44203 | Adriano Espaillat E000297 | rep | NY | 2021-01-03 | 2023-01-03 | Democrat | 13 | https://espaillat.house.gov | 2332 Rayburn House Office Building Washington DC 20515-3213 | 202-225-4365 | 2332 Rayburn House Office Building | |||||||||
44204 | 44204 | Brian Fitzpatrick F000466 | rep | PA | 2017-01-03 | 2019-01-03 | Republican | 8 | https://fitzpatrick.house.gov | 514 Cannon House Office Building; Washington DC 20515-3808 | 202-225-4276 | 514 Cannon House Office Building | |||||||||
44205 | 44205 | Brian Fitzpatrick F000466 | rep | PA | 2019-01-03 | 2021-01-03 | Republican | 1 | https://fitzpatrick.house.gov | 1722 Longworth House Office Building Washington DC 20515-3801 | 202-225-4276 | 1722 Longworth House Office Building | |||||||||
44206 | 44206 | Brian Fitzpatrick F000466 | rep | PA | 2021-01-03 | 2023-01-03 | Republican | 1 | https://fitzpatrick.house.gov | 271 Cannon House Office Building Washington DC 20515-3801 | 202-225-4276 | 271 Cannon House Office Building | |||||||||
44207 | 44207 | Lloyd Smucker S001199 | rep | PA | 2017-01-03 | 2019-01-03 | Republican | 16 | https://smucker.house.gov | 516 Cannon House Office Building; Washington DC 20515-3816 | 202-225-2411 | 516 Cannon House Office Building | |||||||||
44208 | 44208 | Lloyd Smucker S001199 | rep | PA | 2019-01-03 | 2021-01-03 | Republican | 11 | https://smucker.house.gov | 127 Cannon House Office Building Washington DC 20515-3811 | 202-225-2411 | 127 Cannon House Office Building | |||||||||
44209 | 44209 | Lloyd Smucker S001199 | rep | PA | 2021-01-03 | 2023-01-03 | Republican | 11 | https://smucker.house.gov | 302 Cannon House Office Building Washington DC 20515-3811 | 202-225-2411 | 302 Cannon House Office Building | |||||||||
44210 | 44210 | Jenniffer González-Colón G000582 | rep | PR | 2017-01-03 | 2021-01-03 | Republican | 0 | https://gonzalez-colon.house.gov | 1609 Longworth House Office Building Washington DC 20515-5401 | 202-225-2615 | 1609 Longworth House Office Building | |||||||||
44211 | 44211 | Jenniffer González-Colón G000582 | rep | PR | 2021-01-03 | 2023-01-03 | Republican | 0 | https://gonzalez-colon.house.gov | 2338 Rayburn House Office Building Washington DC 20515-5401 | 202-225-2615 | 2338 Rayburn House Office Building | |||||||||
44212 | 44212 | David Kustoff K000392 | rep | TN | 2017-01-03 | 2019-01-03 | Republican | 8 | https://kustoff.house.gov | 508 Cannon House Office Building; Washington DC 20515-4208 | 202-225-4714 | 508 Cannon House Office Building | |||||||||
44213 | 44213 | David Kustoff K000392 | rep | TN | 2019-01-03 | 2021-01-03 | Republican | 8 | https://kustoff.house.gov | 523 Cannon House Office Building Washington DC 20515-4208 | 202-225-4714 | 523 Cannon House Office Building | |||||||||
44214 | 44214 | David Kustoff K000392 | rep | TN | 2021-01-03 | 2023-01-03 | Republican | 8 | https://kustoff.house.gov | 560 Cannon House Office Building Washington DC 20515-4208 | 202-225-4714 | 560 Cannon House Office Building | |||||||||
44215 | 44215 | Vicente Gonzalez G000581 | rep | TX | 2017-01-03 | 2019-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 | |||||||||
44216 | 44216 | Vicente Gonzalez G000581 | rep | TX | 2019-01-03 | 2021-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 | |||||||||
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 | |||||||||
44218 | 44218 | Jodey Arrington A000375 | rep | TX | 2017-01-03 | 2019-01-03 | Republican | 19 | https://arrington.house.gov | 1029 Longworth House Office Building; Washington DC 20515-4319 | 202-225-4005 | 1029 Longworth House Office Building | |||||||||
44219 | 44219 | Jodey Arrington A000375 | rep | TX | 2019-01-03 | 2021-01-03 | Republican | 19 | https://arrington.house.gov | 1029 Longworth House Office Building Washington DC 20515-4319 | 202-225-4005 | 1029 Longworth House Office Building | |||||||||
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 | |||||||||
44221 | 44221 | Pramila Jayapal J000298 | rep | WA | 2017-01-03 | 2019-01-03 | Democrat | 7 | https://jayapal.house.gov | 319 Cannon House Office Building; Washington DC 20515-4707 | 202-225-3106 | 319 Cannon House Office Building | |||||||||
44222 | 44222 | Pramila Jayapal J000298 | rep | WA | 2019-01-03 | 2021-01-03 | Democrat | 7 | https://jayapal.house.gov | 1510 Longworth House Office Building Washington DC 20515-4707 | 202-225-3106 | 1510 Longworth House Office Building | |||||||||
44223 | 44223 | Pramila Jayapal J000298 | rep | WA | 2021-01-03 | 2023-01-03 | Democrat | 7 | https://jayapal.house.gov | 2346 Rayburn House Office Building Washington DC 20515-4707 | 202-225-3106 | 2346 Rayburn House Office Building | |||||||||
44224 | 44224 | Mike Gallagher G000579 | rep | WI | 2017-01-03 | 2019-01-03 | Republican | 8 | https://gallagher.house.gov | 1007 Longworth House Office Building; Washington DC 20515-4908 | 202-225-5665 | 1007 Longworth House Office Building | |||||||||
44225 | 44225 | Mike Gallagher G000579 | rep | WI | 2019-01-03 | 2021-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 | |||||||||
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 | |||||||||
44227 | 44227 | Liz Cheney C001109 | rep | WY | 2017-01-03 | 2019-01-03 | Republican | 0 | https://cheney.house.gov | 416 Cannon House Office Building; Washington DC 20515-5000 | 202-225-2311 | 416 Cannon House Office Building | |||||||||
44228 | 44228 | Liz Cheney C001109 | rep | WY | 2019-01-03 | 2021-01-03 | Republican | 0 | https://cheney.house.gov | 416 Cannon House Office Building Washington DC 20515-5000 | 202-225-2311 | 416 Cannon House Office Building | |||||||||
44229 | 44229 | Liz Cheney C001109 | rep | WY | 2021-01-03 | 2023-01-03 | Republican | 0 | https://cheney.house.gov | 416 Cannon House Office Building Washington DC 20515-5000 | 202-225-2311 | 416 Cannon House Office Building | |||||||||
44230 | 44230 | Ron Estes E000298 | rep | KS | 2017-04-25 | 2019-01-03 | Republican | 4 | https://estes.house.gov | 2452 Rayburn House Office Building; Washington DC 20515-1604 | 202-225-6216 | https://estes.house.gov/contact/email | 2452 Rayburn House Office Building | ||||||||
44231 | 44231 | Ron Estes E000298 | rep | KS | 2019-01-03 | 2021-01-03 | Republican | 4 | https://estes.house.gov | 1524 Longworth House Office Building Washington DC 20515-1604 | 202-225-6216 | 1524 Longworth House Office Building | |||||||||
44232 | 44232 | Ron Estes E000298 | rep | KS | 2021-01-03 | 2023-01-03 | Republican | 4 | https://estes.house.gov | 2411 Rayburn House Office Building Washington DC 20515-1604 | 202-225-6216 | 2411 Rayburn House Office Building | |||||||||
44233 | 44233 | Ralph Norman N000190 | rep | SC | 2017-06-26 | 2019-01-03 | Republican | 5 | https://norman.house.gov | 2350 Rayburn House Office Building; Washington DC 20515-4005 | 202-225-5501 | 2350 Rayburn House Office Building | |||||||||
44234 | 44234 | Ralph Norman N000190 | rep | SC | 2019-01-03 | 2021-01-03 | Republican | 5 | https://norman.house.gov | 319 Cannon House Office Building Washington DC 20515-4005 | 202-225-5501 | 319 Cannon House Office Building | |||||||||
44235 | 44235 | Ralph Norman N000190 | rep | SC | 2021-01-03 | 2023-01-03 | Republican | 5 | https://norman.house.gov | 569 Cannon House Office Building Washington DC 20515-4005 | 202-225-5501 | 569 Cannon House Office Building | |||||||||
44236 | 44236 | Jimmy Gomez G000585 | rep | CA | 2017-07-11 | 2019-01-03 | Democrat | 34 | https://gomez.house.gov | 1226 Longworth House Office Building; Washington DC 20515-0534 | 202-225-6235 | 1226 Longworth House Office Building | |||||||||
44237 | 44237 | Jimmy Gomez G000585 | rep | CA | 2019-01-03 | 2021-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 | |||||||||
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 | |||||||||
44239 | 44239 | John Curtis C001114 | rep | UT | 2017-11-13 | 2019-01-03 | Republican | 3 | https://curtis.house.gov | 2236 Rayburn House Office Building; Washington DC 20515-4403 | 202-225-7751 | 2236 Rayburn House Office Building | |||||||||
44240 | 44240 | John Curtis C001114 | rep | UT | 2019-01-03 | 2021-01-03 | Republican | 3 | https://curtis.house.gov | 125 Cannon House Office Building Washington DC 20515-4403 | 202-225-7751 | 125 Cannon House Office Building | |||||||||
44241 | 44241 | John Curtis C001114 | rep | UT | 2021-01-03 | 2023-01-03 | Republican | 3 | https://curtis.house.gov | 2400 Rayburn House Office Building Washington DC 20515-4403 | 202-225-7751 | 2400 Rayburn House Office Building | |||||||||
44242 | 44242 | Tina Smith S001203 | sen | MN | 2018-01-03 | 2018-11-06 | 2 | Democrat | appointment | https://www.smith.senate.gov | 309 Hart Senate Office Building Washington DC 20510 | 202-224-5641 | https://www.smith.senate.gov/content/contact-senator | 309 Hart Senate Office Building | junior | special-election | |||||
44243 | 44243 | Tina Smith S001203 | sen | MN | 2018-11-07 | 2021-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/contact-tina | 720 Hart 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 | |||||||
44245 | 44245 | Cindy Hyde-Smith H001079 | sen | MS | 2018-04-09 | 2018-11-27 | 2 | Republican | appointment | https://www.hydesmith.senate.gov | G12 Dirksen Senate Office Building Washington DC 20510 | 202-224-5054 | https://www.hydesmith.senate.gov/content/contact-senator | G12 Dirksen Senate Office Building | junior | special-election | |||||
44246 | 44246 | Cindy Hyde-Smith H001079 | sen | MS | 2018-11-28 | 2021-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 | |||||||
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 | |||||||
44248 | 44248 | Conor Lamb L000588 | rep | PA | 2018-04-12 | 2019-01-03 | Democrat | 18 | https://lamb.house.gov/ | 2332 Rayburn House Office Building; Washington DC 20515-3818 | 202-225-2301 | 2332 Rayburn House Office Building | |||||||||
44249 | 44249 | Conor Lamb L000588 | rep | PA | 2019-01-03 | 2021-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 | |||||||||
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 | |||||||||
44251 | 44251 | Debbie Lesko L000589 | rep | AZ | 2018-05-07 | 2019-01-03 | Republican | 8 | https://lesko.house.gov/ | 2435 Rayburn House Office Building; Washington DC 20515-0308 | 202-225-4576 | 2435 Rayburn House Office Building | |||||||||
44252 | 44252 | Debbie Lesko L000589 | rep | AZ | 2019-01-03 | 2021-01-03 | Republican | 8 | https://lesko.house.gov | 1113 Longworth House Office Building Washington DC 20515-0308 | 202-225-4576 | 1113 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 | |||||||||
44254 | 44254 | Michael Cloud C001115 | rep | TX | 2018-07-10 | 2019-01-03 | Republican | 27 | https://cloud.house.gov/ | 2331 Rayburn House Office Building; Washington DC 20515-4327 | 202-225-7742 | 2331 Rayburn House Office Building | |||||||||
44255 | 44255 | Michael Cloud C001115 | rep | TX | 2019-01-03 | 2021-01-03 | Republican | 27 | https://cloud.house.gov | 1314 Longworth House Office Building Washington DC 20515-4327 | 202-225-7742 | 1314 Longworth House Office Building | |||||||||
44256 | 44256 | Michael Cloud C001115 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 27 | https://cloud.house.gov | 512 Cannon House Office Building Washington DC 20515-4327 | 202-225-7742 | 512 Cannon House Office Building | |||||||||
44257 | 44257 | Troy Balderson B001306 | rep | OH | 2018-09-05 | 2019-01-03 | Republican | 12 | https://balderson.house.gov/ | 1203 Longworth House Office Building; Washington DC 20515-3512 | 202-225-5355 | 1203 Longworth House Office Building | |||||||||
44258 | 44258 | Troy Balderson B001306 | rep | OH | 2019-01-03 | 2021-01-03 | Republican | 12 | https://balderson.house.gov | 1221 Longworth House Office Building Washington DC 20515-3512 | 202-225-5355 | 1221 Longworth House Office Building | |||||||||
44259 | 44259 | Troy Balderson B001306 | rep | OH | 2021-01-03 | 2023-01-03 | Republican | 12 | https://balderson.house.gov | 2429 Rayburn House Office Building Washington DC 20515-3512 | 202-225-5355 | 2429 Rayburn House Office Building | |||||||||
44260 | 44260 | Kevin Hern H001082 | rep | OK | 2018-11-13 | 2019-01-03 | Republican | 1 | https://hern.house.gov | 216 Cannon House Office Building; Washington DC 20515-3601 | 202-225-2211 | 216 Cannon House Office Building | |||||||||
44261 | 44261 | Kevin Hern H001082 | rep | OK | 2019-01-03 | 2021-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 | |||||||||
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 | |||||||||
44263 | 44263 | Joseph Morelle M001206 | rep | NY | 2018-11-13 | 2019-01-03 | Democrat | 25 | https://morelle.house.gov | 2469 Rayburn House Office Building; Washington DC 20515-3225 | 202-225-3615 | 2469 Rayburn House Office Building | |||||||||
44264 | 44264 | Joseph Morelle M001206 | rep | NY | 2019-01-03 | 2021-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 | |||||||||
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 | |||||||||
44266 | 44266 | Mary Scanlon S001205 | rep | PA | 2018-11-13 | 2019-01-03 | Democrat | 7 | https://scanlon.house.gov | 2305 Rayburn House Office Building; Washington DC 20515-3807 | 202-225-2011 | 2305 Rayburn House Office Building | |||||||||
44267 | 44267 | Mary Scanlon S001205 | rep | PA | 2019-01-03 | 2021-01-03 | Democrat | 5 | https://scanlon.house.gov | 1535 Longworth House Office Building Washington DC 20515-3805 | 202-225-2011 | 1535 Longworth House Office Building | |||||||||
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 | |||||||||
44269 | 44269 | Susan Wild W000826 | rep | PA | 2018-11-27 | 2019-01-03 | Democrat | 15 | https://wild.house.gov | 2082 Rayburn House Office Building; Washington DC 20515-3815 | 202-225-6411 | 2082 Rayburn House Office Building | |||||||||
44270 | 44270 | Susan Wild W000826 | rep | PA | 2019-01-03 | 2021-01-03 | Democrat | 7 | https://wild.house.gov | 1607 Longworth House Office Building Washington DC 20515-3807 | 202-225-6411 | 1607 Longworth House Office Building | |||||||||
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 |
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);