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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
44351 | 44351 | Jefferson Van Drew V000133 | rep | NJ | 2021-01-03 | 2023-01-03 | Republican | 2 | https://vandrew.house.gov | 2447 Rayburn House Office Building Washington DC 20515-3002 | 202-225-6572 | 2447 Rayburn House Office Building | |||||||||
44350 | 44350 | Jefferson Van Drew V000133 | rep | NJ | 2019-01-03 | 2021-01-03 | Republican | 2 | [ { "start": "2019-01-03", "end": "2019-12-18", "party": "Democrat" }, { "start": "2019-12-19", "end": "2021-01-03", "party": "Republican" } ] |
https://vandrew.house.gov | 331 Cannon House Office Building Washington DC 20515-3002 | 202-225-6572 | 331 Cannon House Office Building | ||||||||
44349 | 44349 | Chris Pappas P000614 | rep | NH | 2021-01-03 | 2023-01-03 | Democrat | 1 | https://pappas.house.gov | 319 Cannon House Office Building Washington DC 20515-2901 | 202-225-5456 | 319 Cannon House Office Building | |||||||||
44348 | 44348 | Chris Pappas P000614 | rep | NH | 2019-01-03 | 2021-01-03 | Democrat | 1 | https://pappas.house.gov | 323 Cannon House Office Building Washington DC 20515-2901 | 202-225-5456 | 323 Cannon House Office Building | |||||||||
44347 | 44347 | Kelly Armstrong A000377 | rep | ND | 2021-01-03 | 2023-01-03 | Republican | 0 | https://armstrong.house.gov | 1740 Longworth House Office Building Washington DC 20515-3400 | 202-225-2611 | 1740 Longworth House Office Building | |||||||||
44346 | 44346 | Kelly Armstrong A000377 | rep | ND | 2019-01-03 | 2021-01-03 | Republican | 0 | https://armstrong.house.gov | 1004 Longworth House Office Building Washington DC 20515-3400 | 202-225-2611 | 1004 Longworth House Office Building | |||||||||
44345 | 44345 | Michael Guest G000591 | rep | MS | 2021-01-03 | 2023-01-03 | Republican | 3 | https://guest.house.gov | 418 Cannon House Office Building Washington DC 20515-2403 | 202-225-5031 | 418 Cannon House Office Building | |||||||||
44344 | 44344 | Michael Guest G000591 | rep | MS | 2019-01-03 | 2021-01-03 | Republican | 3 | https://guest.house.gov | 230 Cannon House Office Building Washington DC 20515-2403 | 202-225-5031 | 230 Cannon House Office Building | |||||||||
44343 | 44343 | Pete Stauber S001212 | rep | MN | 2021-01-03 | 2023-01-03 | Republican | 8 | https://stauber.house.gov | 461 Cannon House Office Building Washington DC 20515-2308 | 202-225-6211 | 461 Cannon House Office Building | |||||||||
44342 | 44342 | Pete Stauber S001212 | rep | MN | 2019-01-03 | 2021-01-03 | Republican | 8 | https://stauber.house.gov | 126 Cannon House Office Building Washington DC 20515-2308 | 202-225-6211 | 126 Cannon House Office Building | |||||||||
44341 | 44341 | Ilhan Omar O000173 | rep | MN | 2021-01-03 | 2023-01-03 | Democrat | 5 | https://omar.house.gov | 1730 Longworth House Office Building Washington DC 20515-2305 | 202-225-4755 | 1730 Longworth House Office Building | |||||||||
44340 | 44340 | Ilhan Omar O000173 | rep | MN | 2019-01-03 | 2021-01-03 | Democrat | 5 | https://omar.house.gov | 1517 Longworth House Office Building Washington DC 20515-2305 | 202-225-4755 | 1517 Longworth House Office Building | |||||||||
44339 | 44339 | Dean Phillips P000616 | rep | MN | 2021-01-03 | 2023-01-03 | Democrat | 3 | https://phillips.house.gov | 2452 Rayburn House Office Building Washington DC 20515-2303 | 202-225-2871 | 2452 Rayburn House Office Building | |||||||||
44338 | 44338 | Dean Phillips P000616 | rep | MN | 2019-01-03 | 2021-01-03 | Democrat | 3 | https://phillips.house.gov | 1305 Longworth House Office Building Washington DC 20515-2303 | 202-225-2871 | 1305 Longworth House Office Building | |||||||||
44337 | 44337 | Angie Craig C001119 | rep | MN | 2021-01-03 | 2023-01-03 | Democrat | 2 | https://craig.house.gov | 2442 Rayburn House Office Building Washington DC 20515-2302 | 202-225-2271 | 2442 Rayburn House Office Building | |||||||||
44336 | 44336 | Angie Craig C001119 | rep | MN | 2019-01-03 | 2021-01-03 | Democrat | 2 | https://craig.house.gov | 1523 Longworth House Office Building Washington DC 20515-2302 | 202-225-2271 | 1523 Longworth House Office Building | |||||||||
44335 | 44335 | Rashida Tlaib T000481 | rep | MI | 2021-01-03 | 2023-01-03 | Democrat | 13 | https://tlaib.house.gov | 1628 Longworth House Office Building Washington DC 20515-2213 | 202-225-5126 | 1628 Longworth House Office Building | |||||||||
44334 | 44334 | Rashida Tlaib T000481 | rep | MI | 2019-01-03 | 2021-01-03 | Democrat | 13 | https://tlaib.house.gov | 1628 Longworth House Office Building Washington DC 20515-2213 | 202-225-5126 | 1628 Longworth House Office Building | |||||||||
44333 | 44333 | Haley Stevens S001215 | rep | MI | 2021-01-03 | 2023-01-03 | Democrat | 11 | https://stevens.house.gov | 1510 Longworth House Office Building Washington DC 20515-2211 | 202-225-8171 | 1510 Longworth House Office Building | |||||||||
44332 | 44332 | Haley Stevens S001215 | rep | MI | 2019-01-03 | 2021-01-03 | Democrat | 11 | https://stevens.house.gov | 227 Cannon House Office Building Washington DC 20515-2211 | 202-225-8171 | 227 Cannon House Office Building | |||||||||
44331 | 44331 | Andy Levin L000592 | rep | MI | 2021-01-03 | 2023-01-03 | Democrat | 9 | https://andylevin.house.gov | 312 Cannon House Office Building Washington DC 20515-2209 | 202-225-4961 | 312 Cannon House Office Building | |||||||||
44330 | 44330 | Andy Levin L000592 | rep | MI | 2019-01-03 | 2021-01-03 | Democrat | 9 | https://andylevin.house.gov | 228 Cannon House Office Building Washington DC 20515-2209 | 202-225-4961 | 228 Cannon 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 | |||||||||
44328 | 44328 | Elissa Slotkin S001208 | rep | MI | 2019-01-03 | 2021-01-03 | Democrat | 8 | https://slotkin.house.gov | 1531 Longworth House Office Building Washington DC 20515-2208 | 202-225-4872 | 1531 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 | |||||||||
44326 | 44326 | David Trone T000483 | rep | MD | 2019-01-03 | 2021-01-03 | Democrat | 6 | https://trone.house.gov | 1213 Longworth House Office Building Washington DC 20515-2006 | 202-225-2721 | 1213 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 | |||||||||
44324 | 44324 | Ayanna Pressley P000617 | rep | MA | 2019-01-03 | 2021-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 | |||||||||
44323 | 44323 | Lori Trahan T000482 | rep | MA | 2021-01-03 | 2023-01-03 | Democrat | 3 | https://trahan.house.gov | 2439 Rayburn House Office Building Washington DC 20515-2103 | 202-225-3411 | 2439 Rayburn House Office Building | |||||||||
44322 | 44322 | Lori Trahan T000482 | rep | MA | 2019-01-03 | 2021-01-03 | Democrat | 3 | https://trahan.house.gov | 1616 Longworth House Office Building Washington DC 20515-2103 | 202-225-3411 | 1616 Longworth House Office Building | |||||||||
44321 | 44321 | Sharice Davids D000629 | rep | KS | 2021-01-03 | 2023-01-03 | Democrat | 3 | https://davids.house.gov | 1541 Longworth House Office Building Washington DC 20515-1603 | 202-225-2865 | 1541 Longworth House Office Building | |||||||||
44320 | 44320 | Sharice Davids D000629 | rep | KS | 2019-01-03 | 2021-01-03 | Democrat | 3 | https://davids.house.gov | 1541 Longworth House Office Building Washington DC 20515-1603 | 202-225-2865 | 1541 Longworth House Office Building | |||||||||
44319 | 44319 | Greg Pence P000615 | rep | IN | 2021-01-03 | 2023-01-03 | Republican | 6 | https://pence.house.gov | 211 Cannon House Office Building Washington DC 20515-1406 | 202-225-3021 | 211 Cannon House Office Building | |||||||||
44318 | 44318 | Greg Pence P000615 | rep | IN | 2019-01-03 | 2021-01-03 | Republican | 6 | https://pence.house.gov | 222 Cannon House Office Building Washington DC 20515-1406 | 202-225-3021 | 222 Cannon 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 | |||||||||
44316 | 44316 | James Baird B001307 | rep | IN | 2019-01-03 | 2021-01-03 | Republican | 4 | https://baird.house.gov | 532 Cannon House Office Building Washington DC 20515-1404 | 202-225-5037 | 532 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 | |||||||||
44314 | 44314 | Lauren Underwood U000040 | rep | IL | 2019-01-03 | 2021-01-03 | Democrat | 14 | https://underwood.house.gov | 1118 Longworth House Office Building Washington DC 20515-1314 | 202-225-2976 | 1118 Longworth House Office Building | |||||||||
44313 | 44313 | Sean Casten C001117 | rep | IL | 2021-01-03 | 2023-01-03 | Democrat | 6 | https://casten.house.gov | 2440 Rayburn House Office Building Washington DC 20515-1306 | 202-225-4561 | 2440 Rayburn House Office Building | |||||||||
44312 | 44312 | Sean Casten C001117 | rep | IL | 2019-01-03 | 2021-01-03 | Democrat | 6 | https://casten.house.gov | 429 Cannon House Office Building Washington DC 20515-1306 | 202-225-4561 | 429 Cannon House Office Building | |||||||||
44311 | 44311 | Jesús García G000586 | rep | IL | 2021-01-03 | 2023-01-03 | Democrat | 4 | https://chuygarcia.house.gov | 1519 Longworth House Office Building Washington DC 20515-1304 | 202-225-8203 | 1519 Longworth House Office Building | |||||||||
44310 | 44310 | Jesús García G000586 | rep | IL | 2019-01-03 | 2021-01-03 | Democrat | 4 | https://chuygarcia.house.gov | 530 Cannon House Office Building Washington DC 20515-1304 | 202-225-8203 | 530 Cannon House Office Building | |||||||||
44309 | 44309 | Russ Fulcher F000469 | rep | ID | 2021-01-03 | 2023-01-03 | Republican | 1 | https://fulcher.house.gov | 1520 Longworth House Office Building Washington DC 20515-1201 | 202-225-6611 | 1520 Longworth House Office Building | |||||||||
44308 | 44308 | Russ Fulcher F000469 | rep | ID | 2019-01-03 | 2021-01-03 | Republican | 1 | https://fulcher.house.gov | 1520 Longworth House Office Building Washington DC 20515-1201 | 202-225-6611 | 1520 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 | |||||||||
44306 | 44306 | Cynthia Axne A000378 | rep | IA | 2019-01-03 | 2021-01-03 | Democrat | 3 | https://axne.house.gov | 330 Cannon House Office Building Washington DC 20515-1503 | 202-225-5476 | 330 Cannon House Office Building | |||||||||
44305 | 44305 | Michael San Nicolas S001204 | rep | GU | 2021-01-03 | 2023-01-03 | Democrat | 0 | https://sannicolas.house.gov | 1632 Longworth House Office Building Washington DC 20515-5301 | 202-225-1188 | 1632 Longworth House Office Building | |||||||||
44304 | 44304 | Michael San Nicolas S001204 | rep | GU | 2019-01-03 | 2021-01-03 | Democrat | 0 | https://sannicolas.house.gov | 1632 Longworth House Office Building Washington DC 20515-5301 | 202-225-1188 | 1632 Longworth House Office Building | |||||||||
44303 | 44303 | Lucy McBath M001208 | rep | GA | 2021-01-03 | 2023-01-03 | Democrat | 6 | https://mcbath.house.gov | 1513 Longworth House Office Building Washington DC 20515-1006 | 202-225-4501 | 1513 Longworth House Office Building | |||||||||
44302 | 44302 | Lucy McBath M001208 | rep | GA | 2019-01-03 | 2021-01-03 | Democrat | 6 | https://mcbath.house.gov | 1513 Longworth House Office Building Washington DC 20515-1006 | 202-225-4501 | 1513 Longworth House Office Building | |||||||||
44301 | 44301 | W. Steube S001214 | rep | FL | 2021-01-03 | 2023-01-03 | Republican | 17 | https://steube.house.gov | 2457 Rayburn House Office Building Washington DC 20515-0917 | 202-225-5792 | 2457 Rayburn House Office Building | |||||||||
44300 | 44300 | W. Steube S001214 | rep | FL | 2019-01-03 | 2021-01-03 | Republican | 17 | https://steube.house.gov | 521 Cannon House Office Building Washington DC 20515-0917 | 202-225-5792 | 521 Cannon House Office Building | |||||||||
44299 | 44299 | Michael Waltz W000823 | rep | FL | 2021-01-03 | 2023-01-03 | Republican | 6 | https://waltz.house.gov | 213 Cannon House Office Building Washington DC 20515-0906 | 202-225-2706 | 213 Cannon House Office Building | |||||||||
44298 | 44298 | Michael Waltz W000823 | rep | FL | 2019-01-03 | 2021-01-03 | Republican | 6 | https://waltz.house.gov | 216 Cannon House Office Building Washington DC 20515-0906 | 202-225-2706 | 216 Cannon House Office Building | |||||||||
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 | |||||||||
44296 | 44296 | Jahana Hayes H001081 | rep | CT | 2019-01-03 | 2021-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 | |||||||||
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 | |||||||||
44294 | 44294 | Jason Crow C001121 | rep | CO | 2019-01-03 | 2021-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 | |||||||||
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 | |||||||||
44292 | 44292 | Joe Neguse N000191 | rep | CO | 2019-01-03 | 2021-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 | |||||||||
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 | |||||||||
44290 | 44290 | Mike Levin L000593 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 49 | https://mikelevin.house.gov | 1626 Longworth House Office Building Washington DC 20515-0549 | 202-225-3906 | 1626 Longworth 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 | |||||||||
44288 | 44288 | Katie Porter P000618 | rep | CA | 2019-01-03 | 2021-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 | |||||||||
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 | |||||||||
44286 | 44286 | Josh Harder H001090 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 10 | https://harder.house.gov | 131 Cannon House Office Building Washington DC 20515-0510 | 202-225-4540 | 131 Cannon House Office Building | |||||||||
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 | |||||||||
44284 | 44284 | Greg Stanton S001211 | rep | AZ | 2019-01-03 | 2021-01-03 | Democrat | 9 | https://stanton.house.gov | 128 Cannon House Office Building Washington DC 20515-0309 | 202-225-9888 | 128 Cannon 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 | ||||||||
44282 | 44282 | Ann Kirkpatrick K000368 | rep | AZ | 2019-01-03 | 2021-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 | ||||||||
44281 | 44281 | Ann Kirkpatrick K000368 | rep | AZ | 2015-01-06 | 2017-01-03 | Democrat | 1 | http://kirkpatrick.house.gov | 201 Cannon HOB; Washington DC 20515-0301 | 202-225-3361 | 202-225-3462 | https://kirkpatrick.house.gov/contact/email-me | 201 Cannon House Office Building | http://kirkpatrick.house.gov/rss.xml | ||||||
44280 | 44280 | Ann Kirkpatrick K000368 | rep | AZ | 2013-01-03 | 2015-01-03 | Democrat | 1 | http://kirkpatrick.house.gov | 330 Cannon HOB; Washington DC 20515-0301 | 202-225-3361 | 202-225-3462 | https://kirkpatrick.house.gov/contact/email-me | 330 Cannon House Office Building | http://kirkpatrick.house.gov/rss.xml | ||||||
44279 | 44279 | Ann Kirkpatrick K000368 | rep | AZ | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://kirkpatrick.house.gov | ||||||||||||
44278 | 44278 | Steven Horsford H001066 | rep | NV | 2021-01-03 | 2023-01-03 | Democrat | 4 | https://horsford.house.gov | 562 Cannon House Office Building Washington DC 20515-2804 | 202-225-9894 | 562 Cannon House Office Building | http://horsford.house.gov/rss.xml | ||||||||
44277 | 44277 | Steven Horsford H001066 | rep | NV | 2019-01-03 | 2021-01-03 | Democrat | 4 | https://horsford.house.gov | 1330 Longworth House Office Building Washington DC 20515-2804 | 202-225-9894 | 1330 Longworth House Office Building | http://horsford.house.gov/rss.xml | ||||||||
44276 | 44276 | Steven Horsford H001066 | rep | NV | 2013-01-03 | 2015-01-03 | Democrat | 4 | http://horsford.house.gov | 1330 Longworth HOB; Washington DC 20515-2804 | 202-225-9894 | https://horsford.house.gov/contact/email-me | 1330 Longworth House Office Building | http://horsford.house.gov/rss.xml | |||||||
44275 | 44275 | Ed Case C001055 | rep | HI | 2021-01-03 | 2023-01-03 | Democrat | 1 | https://case.house.gov | 2210 Rayburn House Office Building Washington DC 20515-1101 | 202-225-2726 | 2210 Rayburn House Office Building | |||||||||
44274 | 44274 | Ed Case C001055 | rep | HI | 2019-01-03 | 2021-01-03 | Democrat | 1 | https://case.house.gov | 2443 Rayburn House Office Building Washington DC 20515-1101 | 202-225-2726 | 2443 Rayburn House Office Building | |||||||||
44273 | 44273 | Ed Case C001055 | rep | HI | 2005-01-04 | 2007-01-03 | Democrat | 2 | http://www.house.gov/case | ||||||||||||
44272 | 44272 | Ed Case C001055 | rep | HI | 2003-01-07 | 2005-01-03 | Democrat | 2 | http://www.house.gov/case | ||||||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 |
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);