legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
469 rows where "end" is on date 2021-01-03 sorted by rss_url
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
41308 | 41308 | Wm. Clay C001049 | rep | MO | 2019-01-03 | 2021-01-03 | Democrat | 1 | https://lacyclay.house.gov | 2428 Rayburn House Office Building Washington DC 20515-2501 | 202-225-2406 | 2428 Rayburn House Office Building | |||||||||
41316 | 41316 | K. Conaway C001062 | rep | TX | 2019-01-03 | 2021-01-03 | Republican | 11 | https://conaway.house.gov | 2469 Rayburn House Office Building Washington DC 20515-4311 | 202-225-3605 | 2469 Rayburn House Office Building | |||||||||
41326 | 41326 | Susan Davis D000598 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 53 | https://susandavis.house.gov | 1214 Longworth House Office Building Washington DC 20515-0553 | 202-225-2040 | 1214 Longworth House Office Building | |||||||||
41342 | 41342 | Eliot Engel E000179 | rep | NY | 2019-01-03 | 2021-01-03 | Democrat | 16 | https://engel.house.gov | 2426 Rayburn House Office Building Washington DC 20515-3216 | 202-225-2464 | 2426 Rayburn House Office Building | |||||||||
41350 | 41350 | Cory Gardner G000562 | sen | CO | 2015-01-06 | 2021-01-03 | 2 | Republican | https://www.gardner.senate.gov | 354 Russell Senate Office Building Washington DC 20510 | 202-224-5941 | 202-225-5870 | https://www.gardner.senate.gov/contact-cory/email-cory | 354 Russell Senate Office Building | junior | ||||||
41444 | 41444 | David Roe R000582 | rep | TN | 2019-01-03 | 2021-01-03 | Republican | 1 | https://roe.house.gov | 102 Cannon House Office Building Washington DC 20515-4201 | 202-225-6356 | 102 Cannon House Office Building | |||||||||
41506 | 41506 | Mac Thornberry T000238 | rep | TX | 2019-01-03 | 2021-01-03 | Republican | 13 | https://thornberry.house.gov | 2208 Rayburn House Office Building Washington DC 20515-4313 | 202-225-3706 | 2208 Rayburn House Office Building | |||||||||
41577 | 41577 | Bradley Byrne B001289 | rep | AL | 2019-01-03 | 2021-01-03 | Republican | 1 | https://byrne.house.gov | 119 Cannon House Office Building Washington DC 20515-0101 | 202-225-4931 | 119 Cannon House Office Building | |||||||||
41580 | 41580 | Ralph Abraham A000374 | rep | LA | 2019-01-03 | 2021-01-03 | Republican | 5 | https://abraham.house.gov | 417 Cannon House Office Building Washington DC 20515-1805 | 202-225-8490 | 417 Cannon House Office Building | |||||||||
41583 | 41583 | Will Hurd H001073 | rep | TX | 2019-01-03 | 2021-01-03 | Republican | 23 | https://hurd.house.gov | 317 Cannon House Office Building Washington DC 20515-4323 | 202-225-4511 | 317 Cannon House Office Building | |||||||||
41584 | 41584 | David Perdue P000612 | sen | GA | 2015-01-06 | 2021-01-03 | 2 | Republican | https://www.perdue.senate.gov | 455 Russell Senate Office Building Washington DC 20510 | 202-224-3521 | https://www.perdue.senate.gov/connect/email | 455 Russell Senate Office Building | senior | |||||||
41587 | 41587 | Mark Walker W000819 | rep | NC | 2019-01-03 | 2021-01-03 | Republican | 6 | https://walker.house.gov | 1725 Longworth House Office Building Washington DC 20515-3306 | 202-225-3065 | 1725 Longworth House Office Building | |||||||||
41589 | 41589 | Francis Rooney R000607 | rep | FL | 2019-01-03 | 2021-01-03 | Republican | 19 | https://francisrooney.house.gov | 120 Cannon House Office Building Washington DC 20515-0919 | 202-225-2536 | 120 Cannon House Office Building | |||||||||
41591 | 41591 | Paul Mitchell M001201 | rep | MI | 2019-01-03 | 2021-01-03 | Independent | 10 | [ { "start": "2019-01-03", "end": "2020-12-13", "party": "Republican" }, { "start": "2020-12-14", "end": "2021-01-03", "party": "Independent" } ] |
https://mitchell.house.gov | 211 Cannon House Office Building Washington DC 20515-2210 | 202-225-2106 | 211 Cannon House Office Building | ||||||||
41593 | 41593 | Greg Gianforte G000584 | rep | MT | 2019-01-03 | 2021-01-03 | Republican | 0 | https://gianforte.house.gov | 1222 Longworth House Office Building Washington DC 20515-2600 | 202-225-3211 | 1222 Longworth House Office Building | |||||||||
41594 | 41594 | Doug Jones J000300 | sen | AL | 2018-01-03 | 2021-01-03 | 2 | Democrat | https://www.jones.senate.gov | 330 Hart Senate Office Building Washington DC 20510 | 202-224-4124 | https://www.jones.senate.gov/content/contact-senator | 330 Hart Senate Office Building | junior | |||||||
41595 | 41595 | TJ Cox C001124 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 21 | https://cox.house.gov | 1728 Longworth House Office Building Washington DC 20515-0521 | 202-225-4695 | 1728 Longworth House Office Building | |||||||||
41596 | 41596 | Gilbert Cisneros C001123 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 39 | https://cisneros.house.gov | 431 Cannon House Office Building Washington DC 20515-0539 | 202-225-4111 | 431 Cannon House Office Building | |||||||||
41597 | 41597 | Harley Rouda R000616 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 48 | https://rouda.house.gov | 2300 Rayburn House Office Building Washington DC 20515-0548 | 202-225-2415 | 2300 Rayburn House Office Building | |||||||||
41598 | 41598 | Ross Spano S001210 | rep | FL | 2019-01-03 | 2021-01-03 | Republican | 15 | https://spano.house.gov | 224 Cannon House Office Building Washington DC 20515-0915 | 202-225-1252 | 224 Cannon House Office Building | |||||||||
41599 | 41599 | Debbie Mucarsel-Powell M001207 | rep | FL | 2019-01-03 | 2021-01-03 | Democrat | 26 | https://mucarsel-powell.house.gov | 114 Cannon House Office Building Washington DC 20515-0926 | 202-225-2778 | 114 Cannon House Office Building | |||||||||
41600 | 41600 | Donna Shalala S001206 | rep | FL | 2019-01-03 | 2021-01-03 | Democrat | 27 | https://shalala.house.gov | 1320 Longworth House Office Building Washington DC 20515-0927 | 202-225-3931 | 1320 Longworth House Office Building | |||||||||
41601 | 41601 | Abby Finkenauer F000467 | rep | IA | 2019-01-03 | 2021-01-03 | Democrat | 1 | https://finkenauer.house.gov | 124 Cannon House Office Building Washington DC 20515-1501 | 202-225-2911 | 124 Cannon House Office Building | |||||||||
41602 | 41602 | Steven Watkins W000824 | rep | KS | 2019-01-03 | 2021-01-03 | Republican | 2 | https://watkins.house.gov | 1205 Longworth House Office Building Washington DC 20515-1602 | 202-225-6601 | 1205 Longworth House Office Building | |||||||||
41603 | 41603 | Xochitl Torres Small T000484 | rep | NM | 2019-01-03 | 2021-01-03 | Democrat | 2 | https://torressmall.house.gov | 430 Cannon House Office Building Washington DC 20515-3102 | 202-225-2365 | 430 Cannon House Office Building | |||||||||
41604 | 41604 | Max Rose R000613 | rep | NY | 2019-01-03 | 2021-01-03 | Democrat | 11 | https://maxrose.house.gov | 1529 Longworth House Office Building Washington DC 20515-3211 | 202-225-3371 | 1529 Longworth House Office Building | |||||||||
41605 | 41605 | Anthony Brindisi B001308 | rep | NY | 2019-01-03 | 2021-01-03 | Democrat | 22 | https://brindisi.house.gov | 329 Cannon House Office Building Washington DC 20515-3222 | 202-225-3665 | 329 Cannon House Office Building | |||||||||
41606 | 41606 | Kendra Horn H001083 | rep | OK | 2019-01-03 | 2021-01-03 | Democrat | 5 | https://horn.house.gov | 415 Cannon House Office Building Washington DC 20515-3605 | 202-225-2132 | 415 Cannon House Office Building | |||||||||
41607 | 41607 | Joe Cunningham C001122 | rep | SC | 2019-01-03 | 2021-01-03 | Democrat | 1 | https://cunningham.house.gov | 423 Cannon House Office Building Washington DC 20515-4001 | 202-225-3176 | 423 Cannon House Office Building | |||||||||
41608 | 41608 | Ben McAdams M001209 | rep | UT | 2019-01-03 | 2021-01-03 | Democrat | 4 | https://mcadams.house.gov | 130 Cannon House Office Building Washington DC 20515-4404 | 202-225-3011 | 130 Cannon House Office Building | |||||||||
41609 | 41609 | Denver Riggleman R000611 | rep | VA | 2019-01-03 | 2021-01-03 | Republican | 5 | https://riggleman.house.gov | 1022 Longworth House Office Building Washington DC 20515-4605 | 202-225-4711 | 1022 Longworth House Office Building | |||||||||
41610 | 41610 | Kwanza Hall H001092 | rep | GA | 2020-12-03 | 2021-01-03 | Democrat | 5 | https://hall.house.gov/ | 300 Cannon House Office Building Washington DC 20515-1005 | 202-225-3801 | https://hall.house.gov/contact | 300 Cannon House Office Building | ||||||||
41619 | 41619 | Ron Wright W000827 | rep | TX | 2019-01-03 | 2021-01-03 | Republican | 6 | https://wright.house.gov | 428 Cannon House Office Building Washington DC 20515-4306 | 202-225-2002 | 428 Cannon House Office Building | |||||||||
41629 | 41629 | Debra Haaland H001080 | rep | NM | 2019-01-03 | 2021-01-03 | Democrat | 1 | https://haaland.house.gov | 1237 Longworth House Office Building Washington DC 20515-3101 | 202-225-6316 | 1237 Longworth House Office Building | |||||||||
41662 | 41662 | Jim Hagedorn H001088 | rep | MN | 2019-01-03 | 2021-01-03 | Republican | 1 | https://hagedorn.house.gov | 325 Cannon House Office Building Washington DC 20515-2301 | 202-225-2472 | 325 Cannon House Office Building | |||||||||
41710 | 41710 | Antonio Delgado D000630 | rep | NY | 2019-01-03 | 2021-01-03 | Democrat | 19 | https://delgado.house.gov | 1007 Longworth House Office Building Washington DC 20515-3219 | 202-225-5614 | 1007 Longworth House Office Building | |||||||||
41718 | 41718 | Charlie Crist C001111 | rep | FL | 2019-01-03 | 2021-01-03 | Democrat | 13 | https://crist.house.gov | 215 Cannon House Office Building Washington DC 20515-0913 | 202-225-5961 | 215 Cannon House Office Building | |||||||||
41728 | 41728 | A. McEachin M001200 | rep | VA | 2019-01-03 | 2021-01-03 | Democrat | 4 | https://mceachin.house.gov | 314 Cannon House Office Building Washington DC 20515-4604 | 202-225-6365 | 314 Cannon House Office Building | |||||||||
41885 | 41885 | James Risch R000584 | sen | ID | 2015-01-06 | 2021-01-03 | 2 | Republican | https://www.risch.senate.gov | 483 Russell Senate Office Building Washington DC 20510 | 202-224-2752 | 202-224-2573 | http://www.risch.senate.gov/public/index.cfm?p=Email | 483 Russell Senate Office Building | junior | ||||||
42082 | 42082 | Shelley Capito C001047 | sen | WV | 2015-01-06 | 2021-01-03 | 2 | Republican | https://www.capito.senate.gov | 172 Russell Senate Office Building Washington DC 20510 | 202-224-6472 | 202-225-7856 | https://www.capito.senate.gov/contact/contact-shelley | 172 Russell Senate Office Building | junior | ||||||
42105 | 42105 | Bill Cassidy C001075 | sen | LA | 2015-01-06 | 2021-01-03 | 2 | Republican | https://www.cassidy.senate.gov | 520 Hart Senate Office Building Washington DC 20510 | 202-224-5824 | 202-225-7313 | https://www.cassidy.senate.gov/contact | 520 Hart Senate Office Building | senior | ||||||
42836 | 42836 | Edward Markey M000133 | sen | MA | 2015-01-06 | 2021-01-03 | 2 | Democrat | https://www.markey.senate.gov | 255 Dirksen Senate Office Building Washington DC 20510 | 202-224-2742 | https://www.markey.senate.gov/contact | 255 Dirksen Senate Office Building | junior | |||||||
42862 | 42862 | Michael McCaul M001157 | rep | TX | 2019-01-03 | 2021-01-03 | Republican | 10 | https://mccaul.house.gov | 2001 Rayburn House Office Building Washington DC 20515-4310 | 202-225-2401 | 2001 Rayburn House Office Building | |||||||||
43101 | 43101 | Gary Peters P000595 | sen | MI | 2015-01-06 | 2021-01-03 | 2 | Democrat | https://www.peters.senate.gov | 724 Hart Senate Office Building Washington DC 20510 | 202-224-6221 | 202-226-2356 | https://www.peters.senate.gov/contact/email-gary | 724 Hart Senate Office Building | junior | ||||||
43551 | 43551 | Nydia Velázquez V000081 | rep | NY | 2019-01-03 | 2021-01-03 | Democrat | 7 | https://velazquez.house.gov | 2302 Rayburn House Office Building Washington DC 20515-3207 | 202-225-2361 | 2302 Rayburn House Office Building | |||||||||
43649 | 43649 | John Yarmuth Y000062 | rep | KY | 2019-01-03 | 2021-01-03 | Democrat | 3 | https://yarmuth.house.gov | 402 Cannon House Office Building Washington DC 20515-1703 | 202-225-5401 | 402 Cannon House Office Building | |||||||||
43702 | 43702 | Tom Cotton C001095 | sen | AR | 2015-01-06 | 2021-01-03 | 2 | Republican | https://www.cotton.senate.gov | 326 Russell Senate Office Building Washington DC 20510 | 202-224-2353 | https://www.cotton.senate.gov/contact/contact-tom | 326 Russell Senate Office Building | junior | |||||||
43726 | 43726 | Eric Swalwell S001193 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 15 | https://swalwell.house.gov | 407 Cannon House Office Building Washington DC 20515-0515 | 202-225-5065 | 407 Cannon House Office Building | |||||||||
43801 | 43801 | Steve Daines D000618 | sen | MT | 2015-01-06 | 2021-01-03 | 2 | Republican | https://www.daines.senate.gov | 320 Hart Senate Office Building Washington DC 20510 | 202-224-2651 | 202-228-1236 | https://www.daines.senate.gov/connect/email-steve | 320 Hart Senate Office Building | junior | ||||||
43837 | 43837 | Brad Wenstrup W000815 | rep | OH | 2019-01-03 | 2021-01-03 | Republican | 2 | https://wenstrup.house.gov | 2419 Rayburn House Office Building Washington DC 20515-3502 | 202-225-3164 | 2419 Rayburn House Office Building | |||||||||
43919 | 43919 | Cory Booker B001288 | sen | NJ | 2015-01-06 | 2021-01-03 | 2 | Democrat | https://www.booker.senate.gov | 717 Hart Senate Office Building Washington DC 20510 | 202-224-3224 | 202-224-8378 | https://www.booker.senate.gov/?p=contact | 717 Hart Senate Office Building | junior | ||||||
43924 | 43924 | Katherine Clark C001101 | rep | MA | 2019-01-03 | 2021-01-03 | Democrat | 5 | https://katherineclark.house.gov | 2448 Rayburn House Office Building Washington DC 20515-2105 | 202-225-2836 | 2448 Rayburn House Office Building | |||||||||
43929 | 43929 | Donald Norcross N000188 | rep | NJ | 2019-01-03 | 2021-01-03 | Democrat | 1 | https://norcross.house.gov | 2437 Rayburn House Office Building Washington DC 20515-3001 | 202-225-6501 | 2437 Rayburn House Office Building | |||||||||
43934 | 43934 | Alma Adams A000370 | rep | NC | 2019-01-03 | 2021-01-03 | Democrat | 12 | https://adams.house.gov | 2436 Rayburn House Office Building Washington DC 20515-3312 | 202-225-1510 | 2436 Rayburn House Office Building | |||||||||
43938 | 43938 | Gary Palmer P000609 | rep | AL | 2019-01-03 | 2021-01-03 | Republican | 6 | https://palmer.house.gov | 207 Cannon House Office Building Washington DC 20515-0106 | 202-225-4921 | 207 Cannon House Office Building | |||||||||
43942 | 43942 | J. Hill H001072 | rep | AR | 2019-01-03 | 2021-01-03 | Republican | 2 | https://hill.house.gov | 1533 Longworth House Office Building Washington DC 20515-0402 | 202-225-2506 | 1533 Longworth House Office Building | |||||||||
43946 | 43946 | Bruce Westerman W000821 | rep | AR | 2019-01-03 | 2021-01-03 | Republican | 4 | https://westerman.house.gov | 209 Cannon House Office Building Washington DC 20515-0404 | 202-225-3772 | 209 Cannon House Office Building | |||||||||
43950 | 43950 | Ruben Gallego G000574 | rep | AZ | 2019-01-03 | 2021-01-03 | Democrat | 7 | https://rubengallego.house.gov | 1131 Longworth House Office Building Washington DC 20515-0307 | 202-225-4065 | 1131 Longworth House Office Building | |||||||||
43954 | 43954 | Mark DeSaulnier D000623 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 11 | https://desaulnier.house.gov | 503 Cannon House Office Building Washington DC 20515-0511 | 202-225-2095 | 503 Cannon House Office Building | |||||||||
43958 | 43958 | Pete Aguilar A000371 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 31 | https://aguilar.house.gov | 109 Cannon House Office Building Washington DC 20515-0531 | 202-225-3201 | 109 Cannon House Office Building | |||||||||
43962 | 43962 | Ted Lieu L000582 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 33 | https://lieu.house.gov | 403 Cannon House Office Building Washington DC 20515-0533 | 202-225-3976 | 403 Cannon House Office Building | |||||||||
43966 | 43966 | Norma Torres T000474 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 35 | https://torres.house.gov | 2444 Rayburn House Office Building Washington DC 20515-0535 | 202-225-6161 | 2444 Rayburn House Office Building | |||||||||
43970 | 43970 | Ken Buck B001297 | rep | CO | 2019-01-03 | 2021-01-03 | Republican | 4 | https://buck.house.gov | 2455 Rayburn House Office Building Washington DC 20515-0604 | 202-225-4676 | 2455 Rayburn House Office Building | |||||||||
43974 | 43974 | Earl Carter C001103 | rep | GA | 2019-01-03 | 2021-01-03 | Republican | 1 | https://buddycarter.house.gov | 2432 Rayburn House Office Building Washington DC 20515-1001 | 202-225-5831 | 2432 Rayburn House Office Building | |||||||||
43978 | 43978 | Jody Hice H001071 | rep | GA | 2019-01-03 | 2021-01-03 | Republican | 10 | https://hice.house.gov | 409 Cannon House Office Building Washington DC 20515-1010 | 202-225-4101 | 409 Cannon House Office Building | |||||||||
43982 | 43982 | Barry Loudermilk L000583 | rep | GA | 2019-01-03 | 2021-01-03 | Republican | 11 | https://loudermilk.house.gov | 422 Cannon House Office Building Washington DC 20515-1011 | 202-225-2931 | 422 Cannon House Office Building | |||||||||
43986 | 43986 | Rick Allen A000372 | rep | GA | 2019-01-03 | 2021-01-03 | Republican | 12 | https://allen.house.gov | 2400 Rayburn House Office Building Washington DC 20515-1012 | 202-225-2823 | 2400 Rayburn House Office Building | |||||||||
43990 | 43990 | Mike Bost B001295 | rep | IL | 2019-01-03 | 2021-01-03 | Republican | 12 | https://bost.house.gov | 1440 Longworth House Office Building Washington DC 20515-1312 | 202-225-5661 | 1440 Longworth House Office Building | |||||||||
43994 | 43994 | Garret Graves G000577 | rep | LA | 2019-01-03 | 2021-01-03 | Republican | 6 | https://garretgraves.house.gov | 2402 Rayburn House Office Building Washington DC 20515-1806 | 202-225-3901 | 2402 Rayburn House Office Building | |||||||||
43998 | 43998 | Seth Moulton M001196 | rep | MA | 2019-01-03 | 2021-01-03 | Democrat | 6 | https://moulton.house.gov | 1127 Longworth House Office Building Washington DC 20515-2106 | 202-225-8020 | 1127 Longworth House Office Building | |||||||||
44002 | 44002 | John Moolenaar M001194 | rep | MI | 2019-01-03 | 2021-01-03 | Republican | 4 | https://moolenaar.house.gov | 117 Cannon House Office Building Washington DC 20515-2204 | 202-225-3561 | 117 Cannon House Office Building | |||||||||
44006 | 44006 | Debbie Dingell D000624 | rep | MI | 2019-01-03 | 2021-01-03 | Democrat | 12 | https://debbiedingell.house.gov | 116 Cannon House Office Building Washington DC 20515-2212 | 202-225-4071 | 116 Cannon House Office Building | |||||||||
44010 | 44010 | Brenda Lawrence L000581 | rep | MI | 2019-01-03 | 2021-01-03 | Democrat | 14 | https://lawrence.house.gov | 2463 Rayburn House Office Building Washington DC 20515-2214 | 202-225-5802 | 2463 Rayburn House Office Building | |||||||||
44014 | 44014 | Tom Emmer E000294 | rep | MN | 2019-01-03 | 2021-01-03 | Republican | 6 | https://emmer.house.gov | 315 Cannon House Office Building Washington DC 20515-2306 | 202-225-2331 | 315 Cannon House Office Building | |||||||||
44018 | 44018 | David Rouzer R000603 | rep | NC | 2019-01-03 | 2021-01-03 | Republican | 7 | https://rouzer.house.gov | 2439 Rayburn House Office Building Washington DC 20515-3307 | 202-225-2731 | 2439 Rayburn House Office Building | |||||||||
44022 | 44022 | Bonnie Watson Coleman W000822 | rep | NJ | 2019-01-03 | 2021-01-03 | Democrat | 12 | https://watsoncoleman.house.gov | 2442 Rayburn House Office Building Washington DC 20515-3012 | 202-225-5801 | 2442 Rayburn House Office Building | |||||||||
44026 | 44026 | Lee Zeldin Z000017 | rep | NY | 2019-01-03 | 2021-01-03 | Republican | 1 | https://zeldin.house.gov | 2441 Rayburn House Office Building Washington DC 20515-3201 | 202-225-3826 | 2441 Rayburn House Office Building | |||||||||
44030 | 44030 | Kathleen Rice R000602 | rep | NY | 2019-01-03 | 2021-01-03 | Democrat | 4 | https://kathleenrice.house.gov | 2435 Rayburn House Office Building Washington DC 20515-3204 | 202-225-5516 | 2435 Rayburn House Office Building | |||||||||
44034 | 44034 | Elise Stefanik S001196 | rep | NY | 2019-01-03 | 2021-01-03 | Republican | 21 | https://stefanik.house.gov | 318 Cannon House Office Building Washington DC 20515-3221 | 202-225-4611 | 318 Cannon House Office Building | |||||||||
44038 | 44038 | John Katko K000386 | rep | NY | 2019-01-03 | 2021-01-03 | Republican | 24 | https://katko.house.gov | 2457 Rayburn House Office Building Washington DC 20515-3224 | 202-225-3701 | 2457 Rayburn House Office Building | |||||||||
44042 | 44042 | Brendan Boyle B001296 | rep | PA | 2019-01-03 | 2021-01-03 | Democrat | 2 | https://boyle.house.gov | 1133 Longworth House Office Building Washington DC 20515-3802 | 202-225-6111 | 1133 Longworth House Office Building | |||||||||
44046 | 44046 | Brian Babin B001291 | rep | TX | 2019-01-03 | 2021-01-03 | Republican | 36 | https://babin.house.gov | 2236 Rayburn House Office Building Washington DC 20515-4336 | 202-225-1555 | 2236 Rayburn House Office Building | |||||||||
44050 | 44050 | Donald Beyer B001292 | rep | VA | 2019-01-03 | 2021-01-03 | Democrat | 8 | https://beyer.house.gov | 1119 Longworth House Office Building Washington DC 20515-4608 | 202-225-4376 | 1119 Longworth House Office Building | |||||||||
44054 | 44054 | Stacey Plaskett P000610 | rep | VI | 2019-01-03 | 2021-01-03 | Democrat | 0 | https://plaskett.house.gov | 2404 Rayburn House Office Building Washington DC 20515-5500 | 202-225-1790 | 2404 Rayburn House Office Building | |||||||||
44058 | 44058 | Dan Newhouse N000189 | rep | WA | 2019-01-03 | 2021-01-03 | Republican | 4 | https://newhouse.house.gov | 1414 Longworth House Office Building Washington DC 20515-4704 | 202-225-5816 | 1414 Longworth House Office Building | |||||||||
44062 | 44062 | Glenn Grothman G000576 | rep | WI | 2019-01-03 | 2021-01-03 | Republican | 6 | https://grothman.house.gov | 1427 Longworth House Office Building Washington DC 20515-4906 | 202-225-2476 | 1427 Longworth House Office Building | |||||||||
44066 | 44066 | Alexander Mooney M001195 | rep | WV | 2019-01-03 | 2021-01-03 | Republican | 2 | https://mooney.house.gov | 2440 Rayburn House Office Building Washington DC 20515-4802 | 202-225-2711 | 2440 Rayburn House Office Building | |||||||||
44070 | 44070 | Aumua Amata Radewagen R000600 | rep | AS | 2019-01-03 | 2021-01-03 | Republican | 0 | https://radewagen.house.gov | 1339 Longworth House Office Building Washington DC 20515-5200 | 202-225-8577 | 1339 Longworth House Office Building | |||||||||
44072 | 44072 | Dan Sullivan S001198 | sen | AK | 2015-01-06 | 2021-01-03 | 2 | Republican | https://www.sullivan.senate.gov | 302 Hart Senate Office Building Washington DC 20510 | 202-224-3004 | https://www.sullivan.senate.gov/contact/email | 302 Hart Senate Office Building | junior | |||||||
44074 | 44074 | Joni Ernst E000295 | sen | IA | 2015-01-06 | 2021-01-03 | 2 | Republican | https://www.ernst.senate.gov/public | 730 Hart Senate Office Building Washington DC 20510 | 202-224-3254 | https://www.ernst.senate.gov/public/index.cfm/contact | 730 Hart Senate Office Building | junior | |||||||
44076 | 44076 | Thom Tillis T000476 | sen | NC | 2015-01-06 | 2021-01-03 | 2 | Republican | https://www.tillis.senate.gov | 113 Dirksen Senate Office Building Washington DC 20510 | 202-224-6342 | https://www.tillis.senate.gov/public/index.cfm/email-me | 113 Dirksen Senate Office Building | junior | |||||||
44078 | 44078 | Mike Rounds R000605 | sen | SD | 2015-01-06 | 2021-01-03 | 2 | Republican | https://www.rounds.senate.gov | 502 Hart Senate Office Building Washington DC 20510 | 202-224-5842 | https://www.rounds.senate.gov/contact/email-mike | 502 Hart Senate Office Building | junior | |||||||
44080 | 44080 | Benjamin Sasse S001197 | sen | NE | 2015-01-06 | 2021-01-03 | 2 | Republican | https://www.sasse.senate.gov/public | 107 Russell Senate Office Building Washington DC 20510 | 202-224-4224 | http://www.sasse.senate.gov/public/index.cfm/email-ben | 107 Russell Senate Office Building | junior | |||||||
44084 | 44084 | Trent Kelly K000388 | rep | MS | 2019-01-03 | 2021-01-03 | Republican | 1 | https://trentkelly.house.gov | 1005 Longworth House Office Building Washington DC 20515-2401 | 202-225-4306 | 1005 Longworth House Office Building | |||||||||
44088 | 44088 | Darin LaHood L000585 | rep | IL | 2019-01-03 | 2021-01-03 | Republican | 18 | https://lahood.house.gov | 1424 Longworth House Office Building Washington DC 20515-1318 | 202-225-6201 | 1424 Longworth House Office Building | |||||||||
44092 | 44092 | Warren Davidson D000626 | rep | OH | 2019-01-03 | 2021-01-03 | Republican | 8 | https://davidson.house.gov | 1107 Longworth House Office Building Washington DC 20515-3508 | 202-225-6205 | 1107 Longworth House Office Building | |||||||||
44110 | 44110 | Tom O’Halleran O000171 | rep | AZ | 2019-01-03 | 2021-01-03 | Democrat | 1 | https://ohalleran.house.gov | 324 Cannon House Office Building Washington DC 20515-0301 | 202-225-3361 | 324 Cannon House Office Building | |||||||||
44113 | 44113 | Andy Biggs B001302 | rep | AZ | 2019-01-03 | 2021-01-03 | Republican | 5 | https://biggs.house.gov | 1318 Longworth House Office Building Washington DC 20515-0305 | 202-225-2635 | 1318 Longworth House Office Building | |||||||||
44116 | 44116 | Ro Khanna K000389 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 17 | https://khanna.house.gov | 221 Cannon House Office Building Washington DC 20515-0517 | 202-225-2631 | 221 Cannon House Office Building | |||||||||
44119 | 44119 | Jimmy Panetta P000613 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 20 | https://panetta.house.gov | 212 Cannon House Office Building Washington DC 20515-0520 | 202-225-2861 | 212 Cannon 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);