legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
44,551 rows sorted by rowid descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
44451 | 44451 | Darrell Issa I000056 | rep | CA | 2013-01-03 | 2015-01-03 | Republican | 49 | http://issa.house.gov | 2347 Rayburn HOB; Washington DC 20515-0549 | 202-225-3906 | 202-225-3303 | http://issa.house.gov/contact/contact-me | 2347 Rayburn House Office Building | http://issa.house.gov/feed/ | ||||||
44450 | 44450 | Darrell Issa I000056 | rep | CA | 2011-01-05 | 2013-01-03 | Republican | 49 | http://www.house.gov/issa | 2347 Rayburn HOB; Washington DC 20515-0549 | 202-225-3906 | 202-225-3303 | http://issa.house.gov/index.cfm?FuseAction=Contact.ContactForm | 2347 Rayburn House Office Building | |||||||
44449 | 44449 | Darrell Issa I000056 | rep | CA | 2009-01-06 | 2011-01-03 | Republican | 49 | http://www.house.gov/issa | ||||||||||||
44448 | 44448 | Darrell Issa I000056 | rep | CA | 2007-01-04 | 2009-01-03 | Republican | 49 | http://www.house.gov/issa | ||||||||||||
44447 | 44447 | Darrell Issa I000056 | rep | CA | 2005-01-04 | 2007-01-03 | Republican | 49 | http://www.house.gov/issa | ||||||||||||
44446 | 44446 | Darrell Issa I000056 | rep | CA | 2003-01-07 | 2005-01-03 | Republican | 49 | http://www.house.gov/issa | ||||||||||||
44445 | 44445 | Darrell Issa I000056 | rep | CA | 2001-01-03 | 2003-01-03 | Republican | 48 | |||||||||||||
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 | |||||||
44443 | 44443 | Cynthia Lummis L000571 | rep | WY | 2015-01-06 | 2017-01-03 | Republican | 0 | http://lummis.house.gov | 2433 Rayburn HOB; Washington DC 20515-5000 | 202-225-2311 | 202-225-3057 | http://lummis.house.gov/contact/ | 2433 Rayburn House Office Building | http://lummis.house.gov/news/rss.aspx | ||||||
44442 | 44442 | Cynthia Lummis L000571 | rep | WY | 2013-01-03 | 2015-01-03 | Republican | 0 | http://lummis.house.gov | 113 Cannon HOB; Washington DC 20515-5000 | 202-225-2311 | 202-225-3057 | http://lummis.house.gov/contact/ | 113 Cannon House Office Building | http://lummis.house.gov/news/rss.aspx | ||||||
44441 | 44441 | Cynthia Lummis L000571 | rep | WY | 2011-01-05 | 2013-01-03 | Republican | 0 | http://lummis.house.gov | 113 Cannon HOB; Washington DC 20515-5001 | 202-225-2311 | 202-225-3057 | https://forms.house.gov/lummis/contact-form.shtml | 113 Cannon House Office Building | |||||||
44440 | 44440 | Cynthia Lummis L000571 | rep | WY | 2009-01-06 | 2011-01-03 | Republican | 0 | http://lummis.house.gov | ||||||||||||
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 | ||||||
44438 | 44438 | Chris Jacobs J000020 | rep | NY | 2021-01-03 | 2023-01-03 | Republican | 27 | https://jacobs.house.gov | 214 Cannon House Office Building Washington DC 20515-3227 | 202-225-5265 | 214 Cannon House Office Building | |||||||||
44437 | 44437 | Chris Jacobs J000020 | rep | NY | 2020-07-21 | 2021-01-03 | Republican | 27 | 2243 Rayburn House Office Building Washington DC 20515-3227 | 202-225-5265 | 2243 Rayburn 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 | |||||||||
44435 | 44435 | Mike Garcia G000061 | rep | CA | 2020-05-19 | 2021-01-03 | Republican | 25 | 1130 Longworth House Office Building Washington DC 20515-0525 | 202-225-1956 | 1130 Longworth House Office Building | ||||||||||
44434 | 44434 | Thomas Tiffany T000165 | rep | WI | 2021-01-03 | 2023-01-03 | Republican | 7 | https://tiffany.house.gov | 1719 Longworth House Office Building Washington DC 20515-4907 | 202-225-3365 | 1719 Longworth House Office Building | |||||||||
44433 | 44433 | Thomas Tiffany T000165 | rep | WI | 2020-05-19 | 2021-01-03 | Republican | 7 | 1714 Longworth House Office Building Washington DC 20515-4907 | 202-225-3365 | 1714 Longworth House Office Building | ||||||||||
44432 | 44432 | Kweisi Mfume M000687 | rep | MD | 2021-01-03 | 2023-01-03 | Democrat | 7 | https://mfume.house.gov | 2263 Rayburn House Office Building Washington DC 20515-2007 | 202-225-4741 | 2263 Rayburn House Office Building | |||||||||
44431 | 44431 | Kweisi Mfume M000687 | rep | MD | 2020-05-05 | 2021-01-03 | Democrat | 7 | 2163 Rayburn House Office Building Washington DC 20515-2007 | 202-225-4741 | 2163 Rayburn House Office Building | ||||||||||
44430 | 44430 | Kweisi Mfume M000687 | rep | MD | 1995-01-04 | 1996-02-18 | Democrat | 7 | |||||||||||||
44429 | 44429 | Kweisi Mfume M000687 | rep | MD | 1993-01-05 | 1995-01-03 | Democrat | 7 | |||||||||||||
44428 | 44428 | Kweisi Mfume M000687 | rep | MD | 1991-01-03 | 1993-01-03 | Democrat | 7 | |||||||||||||
44427 | 44427 | Kweisi Mfume M000687 | rep | MD | 1989-01-03 | 1991-01-03 | Democrat | 7 | |||||||||||||
44426 | 44426 | Kweisi Mfume M000687 | rep | MD | 1987-01-06 | 1989-01-03 | Democrat | 7 | |||||||||||||
44425 | 44425 | Gregory Murphy M001210 | rep | NC | 2021-01-03 | 2023-01-03 | Republican | 3 | https://gregmurphy.house.gov | 313 Cannon House Office Building Washington DC 20515-3303 | 202-225-3415 | 313 Cannon House Office Building | |||||||||
44424 | 44424 | Gregory Murphy M001210 | rep | NC | 2019-09-17 | 2021-01-03 | Republican | 3 | https://gregmurphy.house.gov/ | 2333 Rayburn House Office Building Washington DC 20515-3303 | 202-225-3415 | https://gregmurphy.house.gov/contact/email | 2333 Rayburn 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 | |||||||||
44422 | 44422 | Dan Bishop B001311 | rep | NC | 2019-09-17 | 2021-01-03 | Republican | 9 | https://danbishop.house.gov/ | 132 Cannon House Office Building Washington DC 20515-3309 | 202-225-1976 | https://danbishop.house.gov/contact/email | 132 Cannon House Office Building | ||||||||
44421 | 44421 | Fred Keller K000395 | rep | PA | 2021-01-03 | 2023-01-03 | Republican | 12 | https://keller.house.gov | 1717 Longworth House Office Building Washington DC 20515-3812 | 202-225-3731 | 1717 Longworth House Office Building | |||||||||
44420 | 44420 | Fred Keller K000395 | rep | PA | 2019-06-03 | 2021-01-03 | Republican | 12 | https://keller.house.gov | 1717 Longworth House Office Building Washington DC 20515-3812 | 202-225-3731 | 1717 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 | |||||||||
44418 | 44418 | Jared Golden G000592 | rep | ME | 2019-01-03 | 2021-01-03 | Democrat | 2 | https://golden.house.gov | 1223 Longworth House Office Building Washington DC 20515-1902 | 202-225-6306 | 1223 Longworth House Office Building | |||||||||
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 | |||||||
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 | |||||||
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 | |||||||
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 | |||||||
44413 | 44413 | Carol Miller M001205 | rep | WV | 2021-01-03 | 2023-01-03 | Republican | 3 | https://miller.house.gov | 465 Cannon House Office Building Washington DC 20515-4803 | 202-225-3452 | 465 Cannon House Office Building | |||||||||
44412 | 44412 | Carol Miller M001205 | rep | WV | 2019-01-03 | 2021-01-03 | Republican | 3 | https://miller.house.gov | 1605 Longworth House Office Building Washington DC 20515-4803 | 202-225-3452 | 1605 Longworth House Office Building | |||||||||
44411 | 44411 | Bryan Steil S001213 | rep | WI | 2021-01-03 | 2023-01-03 | Republican | 1 | https://steil.house.gov | 1526 Longworth House Office Building Washington DC 20515-4901 | 202-225-3031 | 1526 Longworth House Office Building | |||||||||
44410 | 44410 | Bryan Steil S001213 | rep | WI | 2019-01-03 | 2021-01-03 | Republican | 1 | https://steil.house.gov | 1408 Longworth House Office Building Washington DC 20515-4901 | 202-225-3031 | 1408 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 | |||||||||
44408 | 44408 | Kim Schrier S001216 | rep | WA | 2019-01-03 | 2021-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 | |||||||||
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 | |||||||||
44406 | 44406 | Jennifer Wexton W000825 | rep | VA | 2019-01-03 | 2021-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 | |||||||||
44405 | 44405 | Abigail Spanberger S001209 | rep | VA | 2021-01-03 | 2023-01-03 | Democrat | 7 | https://spanberger.house.gov | 1431 Longworth House Office Building Washington DC 20515-4607 | 202-225-2815 | 1431 Longworth House Office Building | |||||||||
44404 | 44404 | Abigail Spanberger S001209 | rep | VA | 2019-01-03 | 2021-01-03 | Democrat | 7 | https://spanberger.house.gov | 1239 Longworth House Office Building Washington DC 20515-4607 | 202-225-2815 | 1239 Longworth House Office Building | |||||||||
44403 | 44403 | Ben Cline C001118 | rep | VA | 2021-01-03 | 2023-01-03 | Republican | 6 | https://cline.house.gov | 2443 Rayburn House Office Building Washington DC 20515-4606 | 202-225-5431 | 2443 Rayburn House Office Building | |||||||||
44402 | 44402 | Ben Cline C001118 | rep | VA | 2019-01-03 | 2021-01-03 | Republican | 6 | https://cline.house.gov | 1009 Longworth House Office Building Washington DC 20515-4606 | 202-225-5431 | 1009 Longworth House Office Building | |||||||||
44401 | 44401 | Elaine Luria L000591 | rep | VA | 2021-01-03 | 2023-01-03 | Democrat | 2 | https://luria.house.gov | 412 Cannon House Office Building Washington DC 20515-4602 | 202-225-4215 | 412 Cannon House Office Building | |||||||||
44400 | 44400 | Elaine Luria L000591 | rep | VA | 2019-01-03 | 2021-01-03 | Democrat | 2 | https://luria.house.gov | 534 Cannon House Office Building Washington DC 20515-4602 | 202-225-4215 | 534 Cannon House Office Building | |||||||||
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 | |||||||||
44398 | 44398 | Colin Allred A000376 | rep | TX | 2019-01-03 | 2021-01-03 | Democrat | 32 | https://allred.house.gov | 328 Cannon House Office Building Washington DC 20515-4332 | 202-225-2231 | 328 Cannon House Office Building | |||||||||
44397 | 44397 | Sylvia Garcia G000587 | rep | TX | 2021-01-03 | 2023-01-03 | Democrat | 29 | https://sylviagarcia.house.gov | 1620 Longworth House Office Building Washington DC 20515-4329 | 202-225-1688 | 1620 Longworth House Office Building | |||||||||
44396 | 44396 | Sylvia Garcia G000587 | rep | TX | 2019-01-03 | 2021-01-03 | Democrat | 29 | https://sylviagarcia.house.gov | 1620 Longworth House Office Building Washington DC 20515-4329 | 202-225-1688 | 1620 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 | |||||||||
44394 | 44394 | Chip Roy R000614 | rep | TX | 2019-01-03 | 2021-01-03 | Republican | 21 | https://roy.house.gov | 1319 Longworth House Office Building Washington DC 20515-4321 | 202-225-4236 | 1319 Longworth House Office Building | |||||||||
44393 | 44393 | Veronica Escobar E000299 | rep | TX | 2021-01-03 | 2023-01-03 | Democrat | 16 | https://escobar.house.gov | 1505 Longworth House Office Building Washington DC 20515-4316 | 202-225-4831 | 1505 Longworth House Office Building | |||||||||
44392 | 44392 | Veronica Escobar E000299 | rep | TX | 2019-01-03 | 2021-01-03 | Democrat | 16 | https://escobar.house.gov | 1505 Longworth House Office Building Washington DC 20515-4316 | 202-225-4831 | 1505 Longworth 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 | |||||||||
44390 | 44390 | Lizzie Fletcher F000468 | rep | TX | 2019-01-03 | 2021-01-03 | Democrat | 7 | https://fletcher.house.gov | 1429 Longworth House Office Building Washington DC 20515-4307 | 202-225-2571 | 1429 Longworth House Office Building | |||||||||
44389 | 44389 | Lance Gooden G000589 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 5 | https://gooden.house.gov | 1722 Longworth House Office Building Washington DC 20515-4305 | 202-225-3484 | 1722 Longworth House Office Building | |||||||||
44388 | 44388 | Lance Gooden G000589 | rep | TX | 2019-01-03 | 2021-01-03 | Republican | 5 | https://gooden.house.gov | 425 Cannon House Office Building Washington DC 20515-4305 | 202-225-3484 | 425 Cannon House Office Building | |||||||||
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 | |||||||||
44386 | 44386 | Van Taylor T000479 | rep | TX | 2019-01-03 | 2021-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 | |||||||||
44385 | 44385 | Dan Crenshaw C001120 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 2 | https://crenshaw.house.gov | 413 Cannon House Office Building Washington DC 20515-4302 | 202-225-6565 | 413 Cannon House Office Building | |||||||||
44384 | 44384 | Dan Crenshaw C001120 | rep | TX | 2019-01-03 | 2021-01-03 | Republican | 2 | https://crenshaw.house.gov | 413 Cannon House Office Building Washington DC 20515-4302 | 202-225-6565 | 413 Cannon House Office Building | |||||||||
44383 | 44383 | Mark Green G000590 | rep | TN | 2021-01-03 | 2023-01-03 | Republican | 7 | https://markgreen.house.gov | 2446 Rayburn House Office Building Washington DC 20515-4207 | 202-225-2811 | 2446 Rayburn House Office Building | |||||||||
44382 | 44382 | Mark Green G000590 | rep | TN | 2019-01-03 | 2021-01-03 | Republican | 7 | https://markgreen.house.gov | 533 Cannon House Office Building Washington DC 20515-4207 | 202-225-2811 | 533 Cannon 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 | |||||||||
44380 | 44380 | John Rose R000612 | rep | TN | 2019-01-03 | 2021-01-03 | Republican | 6 | https://johnrose.house.gov | 1232 Longworth House Office Building Washington DC 20515-4206 | 202-225-4231 | 1232 Longworth House Office Building | |||||||||
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 | |||||||||
44378 | 44378 | Tim Burchett B001309 | rep | TN | 2019-01-03 | 2021-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 | |||||||||
44377 | 44377 | Dusty Johnson J000301 | rep | SD | 2021-01-03 | 2023-01-03 | Republican | 0 | https://dustyjohnson.house.gov | 1714 Longworth House Office Building Washington DC 20515-4100 | 202-225-2801 | 1714 Longworth House Office Building | |||||||||
44376 | 44376 | Dusty Johnson J000301 | rep | SD | 2019-01-03 | 2021-01-03 | Republican | 0 | https://dustyjohnson.house.gov | 1508 Longworth House Office Building Washington DC 20515-4100 | 202-225-2801 | 1508 Longworth House Office Building | |||||||||
44375 | 44375 | William Timmons T000480 | rep | SC | 2021-01-03 | 2023-01-03 | Republican | 4 | https://timmons.house.gov | 267 Cannon House Office Building Washington DC 20515-4004 | 202-225-6030 | 267 Cannon House Office Building | |||||||||
44374 | 44374 | William Timmons T000480 | rep | SC | 2019-01-03 | 2021-01-03 | Republican | 4 | https://timmons.house.gov | 313 Cannon House Office Building Washington DC 20515-4004 | 202-225-6030 | 313 Cannon House Office Building | |||||||||
44373 | 44373 | Guy Reschenthaler R000610 | rep | PA | 2021-01-03 | 2023-01-03 | Republican | 14 | https://reschenthaler.house.gov | 409 Cannon House Office Building Washington DC 20515-3814 | 202-225-2065 | 409 Cannon House Office Building | |||||||||
44372 | 44372 | Guy Reschenthaler R000610 | rep | PA | 2019-01-03 | 2021-01-03 | Republican | 14 | https://reschenthaler.house.gov | 531 Cannon House Office Building Washington DC 20515-3814 | 202-225-2065 | 531 Cannon 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 | |||||||||
44370 | 44370 | John Joyce J000302 | rep | PA | 2019-01-03 | 2021-01-03 | Republican | 13 | https://johnjoyce.house.gov | 1337 Longworth House Office Building Washington DC 20515-3813 | 202-225-2431 | 1337 Longworth House Office Building | |||||||||
44369 | 44369 | Daniel Meuser M001204 | rep | PA | 2021-01-03 | 2023-01-03 | Republican | 9 | https://meuser.house.gov | 414 Cannon House Office Building Washington DC 20515-3809 | 202-225-6511 | 414 Cannon House Office Building | |||||||||
44368 | 44368 | Daniel Meuser M001204 | rep | PA | 2019-01-03 | 2021-01-03 | Republican | 9 | https://meuser.house.gov | 326 Cannon House Office Building Washington DC 20515-3809 | 202-225-6511 | 326 Cannon 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 | |||||||||
44366 | 44366 | Chrissy Houlahan H001085 | rep | PA | 2019-01-03 | 2021-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 | |||||||||
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 | |||||||||
44364 | 44364 | Madeleine Dean D000631 | rep | PA | 2019-01-03 | 2021-01-03 | Democrat | 4 | https://dean.house.gov | 129 Cannon House Office Building Washington DC 20515-3804 | 202-225-4731 | 129 Cannon House Office Building | |||||||||
44363 | 44363 | Anthony Gonzalez G000588 | rep | OH | 2021-01-03 | 2023-01-03 | Republican | 16 | https://anthonygonzalez.house.gov | 2458 Rayburn House Office Building Washington DC 20515-3516 | 202-225-3876 | 2458 Rayburn House Office Building | |||||||||
44362 | 44362 | Anthony Gonzalez G000588 | rep | OH | 2019-01-03 | 2021-01-03 | Republican | 16 | https://anthonygonzalez.house.gov | 1023 Longworth House Office Building Washington DC 20515-3516 | 202-225-3876 | 1023 Longworth House Office Building | |||||||||
44361 | 44361 | Alexandria Ocasio-Cortez O000172 | rep | NY | 2021-01-03 | 2023-01-03 | Democrat | 14 | https://ocasio-cortez.house.gov | 216 Cannon House Office Building Washington DC 20515-3214 | 202-225-3965 | 216 Cannon House Office Building | |||||||||
44360 | 44360 | Alexandria Ocasio-Cortez O000172 | rep | NY | 2019-01-03 | 2021-01-03 | Democrat | 14 | https://ocasio-cortez.house.gov | 229 Cannon House Office Building Washington DC 20515-3214 | 202-225-3965 | 229 Cannon House Office Building | |||||||||
44359 | 44359 | Susie Lee L000590 | rep | NV | 2021-01-03 | 2023-01-03 | Democrat | 3 | https://susielee.house.gov | 365 Cannon House Office Building Washington DC 20515-2803 | 202-225-3252 | 365 Cannon House Office Building | |||||||||
44358 | 44358 | Susie Lee L000590 | rep | NV | 2019-01-03 | 2021-01-03 | Democrat | 3 | https://susielee.house.gov | 522 Cannon House Office Building Washington DC 20515-2803 | 202-225-3252 | 522 Cannon House Office Building | |||||||||
44357 | 44357 | Mikie Sherrill S001207 | rep | NJ | 2021-01-03 | 2023-01-03 | Democrat | 11 | https://sherrill.house.gov | 1414 Longworth House Office Building Washington DC 20515-3011 | 202-225-5034 | 1414 Longworth House Office Building | |||||||||
44356 | 44356 | Mikie Sherrill S001207 | rep | NJ | 2019-01-03 | 2021-01-03 | Democrat | 11 | https://sherrill.house.gov | 1208 Longworth House Office Building Washington DC 20515-3011 | 202-225-5034 | 1208 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 | |||||||||
44354 | 44354 | Tom Malinowski M001203 | rep | NJ | 2019-01-03 | 2021-01-03 | Democrat | 7 | https://malinowski.house.gov | 426 Cannon House Office Building Washington DC 20515-3007 | 202-225-5361 | 426 Cannon House Office Building | |||||||||
44353 | 44353 | Andy Kim K000394 | rep | NJ | 2021-01-03 | 2023-01-03 | Democrat | 3 | https://kim.house.gov | 2444 Rayburn House Office Building Washington DC 20515-3003 | 202-225-4765 | 2444 Rayburn House Office Building | |||||||||
44352 | 44352 | Andy Kim K000394 | rep | NJ | 2019-01-03 | 2021-01-03 | Democrat | 3 | https://kim.house.gov | 1516 Longworth House Office Building Washington DC 20515-3003 | 202-225-4765 | 1516 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);