legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
20,712 rows where party = "Democrat" sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: how, state_rank, start (date)
state >30 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||||||
44548 | 44548 | Mary Peltola P000619 | rep | AK | 2022-09-13 | 2023-01-03 | Democrat | 0 | https://peltola.house.gov | 2314 Rayburn House Office Building Washington DC 20515-0200 | 202-225-5765 | 2314 Rayburn House Office Building | |||||||||
44543 | 44543 | Sheila Cherfilus-McCormick C001127 | rep | FL | 2022-01-18 | 2023-01-03 | Democrat | 20 | https://cherfilus-mccormick.house.gov | 2365 Rayburn House Office Building Washington DC 20515-0920 | 202-225-1313 | 2365 Rayburn House Office Building | |||||||||
44541 | 44541 | Shontel Brown B001313 | rep | OH | 2021-11-04 | 2023-01-03 | Democrat | 11 | https://shontelbrown.house.gov | 2344 Rayburn House Office Building Washington DC 20515-3511 | 202-225-7032 | 2344 Rayburn House Office Building | |||||||||
44539 | 44539 | Melanie Stansbury S001218 | rep | NM | 2021-06-14 | 2023-01-03 | Democrat | 1 | https://stansbury.house.gov | 1421 Longworth House Office Building Washington DC 20515-3101 | 202-225-6316 | 1421 Longworth House Office Building | |||||||||
44538 | 44538 | Troy Carter C001125 | rep | LA | 2021-05-11 | 2023-01-03 | Democrat | 2 | https://troycarter.house.gov | 506 Cannon House Office Building Washington DC 20515-1802 | 202-225-6636 | 506 Cannon House Office Building | |||||||||
44534 | 44534 | Raphael Warnock W000790 | sen | GA | 2021-01-20 | 2023-01-03 | 3 | Democrat | special-election | https://www.warnock.senate.gov | 388 Russell Senate Office Building Washington DC 20510 | 202-224-3643 | https://www.warnock.senate.gov/contact/ | 388 Russell Senate Office Building | junior | ||||||
44533 | 44533 | Jon Ossoff O000174 | sen | GA | 2021-01-20 | 2027-01-03 | 2 | Democrat | https://www.ossoff.senate.gov | 455 Russell Senate Office Building Washington DC 20510 | 202-224-3521 | https://www.ossoff.senate.gov/contact-us/ | 455 Russell Senate Office Building | senior | |||||||
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 | ||||||
44531 | 44531 | Alejandro Padilla P000145 | sen | CA | 2021-01-20 | 2022-11-08 | 3 | Democrat | appointment | 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 | ||||||
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 | |||||||||
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 | |||||||||
44514 | 44514 | Jamaal Bowman B001223 | rep | NY | 2021-01-03 | 2023-01-03 | Democrat | 16 | https://bowman.house.gov | 1605 Longworth House Office Building Washington DC 20515-3216 | 202-225-2464 | 1605 Longworth House Office Building | |||||||||
44513 | 44513 | Ritchie Torres T000486 | rep | NY | 2021-01-03 | 2023-01-03 | Democrat | 15 | https://ritchietorres.house.gov | 317 Cannon House Office Building Washington DC 20515-3215 | 202-225-4361 | 317 Cannon House Office Building | |||||||||
44510 | 44510 | Teresa Leger Fernandez L000273 | rep | NM | 2021-01-03 | 2023-01-03 | Democrat | 3 | https://fernandez.house.gov | 1432 Longworth House Office Building Washington DC 20515-3103 | 202-225-6190 | 1432 Longworth House Office Building | |||||||||
44507 | 44507 | Kathy Manning M001135 | rep | NC | 2021-01-03 | 2023-01-03 | Democrat | 6 | https://manning.house.gov | 415 Cannon House Office Building Washington DC 20515-3306 | 202-225-3065 | 415 Cannon 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 | |||||||||
44504 | 44504 | Cori Bush B001224 | rep | MO | 2021-01-03 | 2023-01-03 | Democrat | 1 | https://bush.house.gov | 563 Cannon House Office Building Washington DC 20515-2501 | 202-225-2406 | 563 Cannon House Office Building | |||||||||
44500 | 44500 | Jake Auchincloss A000148 | rep | MA | 2021-01-03 | 2023-01-03 | Democrat | 4 | https://auchincloss.house.gov | 1524 Longworth House Office Building Washington DC 20515-2104 | 202-225-5931 | 1524 Longworth House Office Building | |||||||||
44496 | 44496 | Frank Mrvan M001214 | rep | IN | 2021-01-03 | 2023-01-03 | Democrat | 1 | https://mrvan.house.gov | 1607 Longworth House Office Building Washington DC 20515-1401 | 202-225-2461 | 1607 Longworth 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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
44472 | 44472 | John Hickenlooper H000273 | sen | CO | 2021-01-03 | 2027-01-03 | 2 | Democrat | https://www.hickenlooper.senate.gov | 374 Russell Senate Office Building Washington DC 20510 | 202-224-5941 | https://www.hickenlooper.senate.gov/contact/ | 374 Russell Senate Office Building | junior | |||||||
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 | ||||||
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 | |||||||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 |
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);