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 office
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, district, state_rank, rss_url
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
42010 | 42010 | Kevin Brady B000755 | rep | TX | 2019-01-03 | 2021-01-03 | Republican | 8 | https://kevinbrady.house.gov | 1011 Longworth House Office Building Washington DC 20515-4308 | 202-225-4901 | 1011 Longworth House Office Building | http://kevinbrady.house.gov/common/rss/index.cfm?rss=49 | ||||||||
41660 | 41660 | Devin Nunes N000181 | rep | CA | 2019-01-03 | 2021-01-03 | Republican | 22 | https://nunes.house.gov | 1013 Longworth House Office Building Washington DC 20515-0522 | 202-225-2523 | 1013 Longworth House Office Building | http://nunes.house.gov/news/rss.aspx | ||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
44191 | 44191 | Don Bacon B001298 | rep | NE | 2019-01-03 | 2021-01-03 | Republican | 2 | https://bacon.house.gov | 1024 Longworth House Office Building Washington DC 20515-2702 | 202-225-4155 | 1024 Longworth House Office Building | |||||||||
42432 | 42432 | Kay Granger G000377 | rep | TX | 2019-01-03 | 2021-01-03 | Republican | 12 | https://kaygranger.house.gov | 1026 Longworth House Office Building Washington DC 20515-4312 | 202-225-5071 | 1026 Longworth House Office Building | http://kaygranger.house.gov/rss.xml | ||||||||
44219 | 44219 | Jodey Arrington A000375 | rep | TX | 2019-01-03 | 2021-01-03 | Republican | 19 | https://arrington.house.gov | 1029 Longworth House Office Building Washington DC 20515-4319 | 202-225-4005 | 1029 Longworth House Office Building | |||||||||
43683 | 43683 | Donald Payne P000604 | rep | NJ | 2019-01-03 | 2021-01-03 | Democrat | 10 | https://payne.house.gov | 103 Cannon House Office Building Washington DC 20515-3010 | 202-225-3436 | 103 Cannon House Office Building | http://payne.house.gov/rss.xml | ||||||||
44125 | 44125 | Nanette Barragán B001300 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 44 | https://barragan.house.gov | 1030 Longworth House Office Building Washington DC 20515-0544 | 202-225-8220 | 1030 Longworth House Office Building | |||||||||
44158 | 44158 | A. Ferguson F000465 | rep | GA | 2019-01-03 | 2021-01-03 | Republican | 3 | https://ferguson.house.gov | 1032 Longworth House Office Building Washington DC 20515-1003 | 202-225-5901 | 1032 Longworth House Office Building | |||||||||
43862 | 43862 | Matthew Cartwright C001090 | rep | PA | 2019-01-03 | 2021-01-03 | Democrat | 8 | https://cartwright.house.gov | 1034 Longworth House Office Building Washington DC 20515-3808 | 202-225-5546 | 1034 Longworth House Office Building | http://cartwright.house.gov/rss.xml | ||||||||
42917 | 42917 | Cathy McMorris Rodgers M001159 | rep | WA | 2019-01-03 | 2021-01-03 | Republican | 5 | https://mcmorris.house.gov | 1035 Longworth House Office Building Washington DC 20515-4705 | 202-225-2006 | 1035 Longworth House Office Building | http://mcmorris.house.gov/common/rss/?rss=96 | ||||||||
44096 | 44096 | James Comer C001108 | rep | KY | 2019-01-03 | 2021-01-03 | Republican | 1 | https://comer.house.gov | 1037 Longworth House Office Building Washington DC 20515-1701 | 202-225-3115 | 1037 Longworth House Office Building | https://comer.house.gov/rss.xml | ||||||||
44128 | 44128 | J. Correa C001110 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 46 | https://correa.house.gov | 1039 Longworth House Office Building Washington DC 20515-0546 | 202-225-2965 | 1039 Longworth House Office Building | |||||||||
43659 | 43659 | Mark Amodei A000369 | rep | NV | 2019-01-03 | 2021-01-03 | Republican | 2 | https://amodei.house.gov | 104 Cannon House Office Building Washington DC 20515-2802 | 202-225-6155 | 104 Cannon House Office Building | http://amodei.house.gov/common/rss//?rss=49 | ||||||||
41289 | 41289 | Justin Amash A000367 | rep | MI | 2019-01-03 | 2021-01-03 | Libertarian | 3 | [ { "start": "2019-01-03", "end": "2019-07-03", "party": "Republican" }, { "start": "2019-07-04", "end": "2020-04-30", "party": "Independent" }, { "start": "2020-05-01", "end": "2021-01-03", "party": "Libertarian" } ] |
https://amash.house.gov | 106 Cannon House Office Building Washington DC 20515-2203 | 202-225-3831 | 106 Cannon House Office Building | http://amash.house.gov/rss.xml | |||||||
43874 | 43874 | Randy Weber W000814 | rep | TX | 2019-01-03 | 2021-01-03 | Republican | 14 | https://weber.house.gov | 107 Cannon House Office Building Washington DC 20515-4314 | 202-225-2831 | 107 Cannon House Office Building | http://weber.house.gov/rss.xml | ||||||||
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 | |||||||
43751 | 43751 | Alan Lowenthal L000579 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 47 | https://lowenthal.house.gov | 108 Cannon House Office Building Washington DC 20515-0547 | 202-225-7924 | 108 Cannon House Office Building | http://lowenthal.house.gov/news/rss.aspx | ||||||||
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 | |||||||||
41277 | 41277 | Pat Roberts R000307 | sen | KS | 2015-01-06 | 2021-01-03 | 2 | Republican | https://www.roberts.senate.gov | 109 Hart Senate Office Building Washington DC 20510 | 202-224-4774 | 202-224-3514 | https://www.roberts.senate.gov/public/?p=EmailPat | 109 Hart Senate Office Building | senior | http://www.roberts.senate.gov/public/?a=rss.feed | |||||
44100 | 44100 | Dwight Evans E000296 | rep | PA | 2019-01-03 | 2021-01-03 | Democrat | 3 | https://evans.house.gov | 1105 Longworth House Office Building Washington DC 20515-3803 | 202-225-4001 | 1105 Longworth House Office Building | https://evans.house.gov/rss.xml | ||||||||
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 | |||||||||
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 | |||||||||
41569 | 41569 | George Holding H001065 | rep | NC | 2019-01-03 | 2021-01-03 | Republican | 2 | https://holding.house.gov | 1110 Longworth House Office Building Washington DC 20515-3302 | 202-225-3032 | 1110 Longworth House Office Building | http://holding.house.gov/rss.xml | ||||||||
41979 | 41979 | Earl Blumenauer B000574 | rep | OR | 2019-01-03 | 2021-01-03 | Democrat | 3 | https://blumenauer.house.gov | 1111 Longworth House Office Building Washington DC 20515-3703 | 202-225-4811 | 1111 Longworth House Office Building | http://blumenauer.house.gov/index.php?format=feed&type=rss | ||||||||
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 | |||||||||
43567 | 43567 | Debbie Wasserman Schultz W000797 | rep | FL | 2019-01-03 | 2021-01-03 | Democrat | 23 | https://wassermanschultz.house.gov | 1114 Longworth House Office Building Washington DC 20515-0923 | 202-225-7931 | 1114 Longworth House Office Building | http://wassermanschultz.house.gov/atom.xml | ||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
43847 | 43847 | David Joyce J000295 | rep | OH | 2019-01-03 | 2021-01-03 | Republican | 14 | https://joyce.house.gov | 1124 Longworth House Office Building Washington DC 20515-3514 | 202-225-5731 | 1124 Longworth House Office Building | http://joyce.house.gov/rss/press-releases.xml | ||||||||
43231 | 43231 | Tim Ryan R000577 | rep | OH | 2019-01-03 | 2021-01-03 | Democrat | 13 | https://timryan.house.gov | 1126 Longworth House Office Building Washington DC 20515-3513 | 202-225-5261 | 1126 Longworth House Office Building | http://timryan.house.gov/rss.xml | ||||||||
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 | |||||||||
44216 | 44216 | Vicente Gonzalez G000581 | rep | TX | 2019-01-03 | 2021-01-03 | Democrat | 15 | https://gonzalez.house.gov | 113 Cannon House Office Building Washington DC 20515-4315 | 202-225-2531 | 113 Cannon House Office Building | |||||||||
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 | |||||||
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 | ||||||||||
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 | |||||||||
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 | |||||||||
42453 | 42453 | Sam Graves G000546 | rep | MO | 2019-01-03 | 2021-01-03 | Republican | 6 | https://graves.house.gov | 1135 Longworth House Office Building Washington DC 20515-2506 | 202-225-7041 | 1135 Longworth House Office Building | http://graves.house.gov/common/rss/index.cfm?rss=25 | ||||||||
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 | |||||||||
44161 | 44161 | Raja Krishnamoorthi K000391 | rep | IL | 2019-01-03 | 2021-01-03 | Democrat | 8 | https://krishnamoorthi.house.gov | 115 Cannon House Office Building Washington DC 20515-1308 | 202-225-3711 | 115 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 | |||||||||
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 | |||||||||
44188 | 44188 | Ted Budd B001305 | rep | NC | 2019-01-03 | 2021-01-03 | Republican | 13 | https://budd.house.gov | 118 Cannon House Office Building Washington DC 20515-3313 | 202-225-4531 | 118 Cannon House Office Building | |||||||||
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 | |||||||||
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 | |||||||||
43334 | 43334 | Robert Scott S000185 | rep | VA | 2019-01-03 | 2021-01-03 | Democrat | 3 | https://bobbyscott.house.gov | 1201 Longworth House Office Building Washington DC 20515-4603 | 202-225-8351 | 1201 Longworth House Office Building | http://www.house.gov/index.php?format=feed&type=rss | ||||||||
41915 | 41915 | Robert Aderholt A000055 | rep | AL | 2019-01-03 | 2021-01-03 | Republican | 4 | https://aderholt.house.gov | 1203 Longworth House Office Building Washington DC 20515-0104 | 202-225-4876 | 1203 Longworth House Office Building | http://aderholt.house.gov/common/rss//index.cfm?rss=20 | ||||||||
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 | |||||||||
43857 | 43857 | Scott Perry P000605 | rep | PA | 2019-01-03 | 2021-01-03 | Republican | 10 | https://perry.house.gov | 1207 Longworth House Office Building Washington DC 20515-3810 | 202-225-5836 | 1207 Longworth House Office Building | http://perry.house.gov/rss.xml | ||||||||
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 | |||||||||
43589 | 43589 | Daniel Webster W000806 | rep | FL | 2019-01-03 | 2021-01-03 | Republican | 11 | https://webster.house.gov | 1210 Longworth House Office Building Washington DC 20515-0911 | 202-225-1002 | 1210 Longworth House Office Building | http://webster.house.gov/news/rss.aspx | ||||||||
41388 | 41388 | David Loebsack L000565 | rep | IA | 2019-01-03 | 2021-01-03 | Democrat | 2 | https://loebsack.house.gov | 1211 Longworth House Office Building Washington DC 20515-1502 | 202-225-6576 | 1211 Longworth House Office Building | http://loebsack.house.gov/news/rss.aspx | ||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
44249 | 44249 | Conor Lamb L000588 | rep | PA | 2019-01-03 | 2021-01-03 | Democrat | 17 | https://lamb.house.gov | 1224 Longworth House Office Building Washington DC 20515-3817 | 202-225-2301 | 1224 Longworth House Office Building | |||||||||
43096 | 43096 | Ed Perlmutter P000593 | rep | CO | 2019-01-03 | 2021-01-03 | Democrat | 7 | https://perlmutter.house.gov | 1226 Longworth House Office Building Washington DC 20515-0607 | 202-225-2645 | 1226 Longworth House Office Building | http://perlmutter.house.gov/index.php?format=feed&type=rss | ||||||||
42523 | 42523 | James Himes H001047 | rep | CT | 2019-01-03 | 2021-01-03 | Democrat | 4 | https://himes.house.gov | 1227 Longworth House Office Building Washington DC 20515-0704 | 202-225-5541 | 1227 Longworth House Office Building | http://himes.house.gov/rss.xml | ||||||||
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 | |||||||||
41298 | 41298 | Rob Bishop B001250 | rep | UT | 2019-01-03 | 2021-01-03 | Republican | 1 | https://robbishop.house.gov | 123 Cannon House Office Building Washington DC 20515-4401 | 202-225-0453 | 123 Cannon House Office Building | http://robbishop.house.gov/news/rss.aspx | ||||||||
44225 | 44225 | Mike Gallagher G000579 | rep | WI | 2019-01-03 | 2021-01-03 | Republican | 8 | https://gallagher.house.gov | 1230 Longworth House Office Building Washington DC 20515-4908 | 202-225-5665 | 1230 Longworth House Office Building | |||||||||
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 | |||||||||
43779 | 43779 | Cheri Bustos B001286 | rep | IL | 2019-01-03 | 2021-01-03 | Democrat | 17 | https://bustos.house.gov | 1233 Longworth House Office Building Washington DC 20515-1317 | 202-225-5905 | 1233 Longworth House Office Building | http://bustos.house.gov/rss.xml | ||||||||
43088 | 43088 | Nancy Pelosi P000197 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 12 | https://pelosi.house.gov | 1236 Longworth House Office Building Washington DC 20515-0512 | 202-225-4965 | 1236 Longworth House Office Building | http://pelosi.house.gov/atom.xml | ||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
44240 | 44240 | John Curtis C001114 | rep | UT | 2019-01-03 | 2021-01-03 | Republican | 3 | https://curtis.house.gov | 125 Cannon House Office Building Washington DC 20515-4403 | 202-225-7751 | 125 Cannon House Office Building | |||||||||
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 | |||||||||
44208 | 44208 | Lloyd Smucker S001199 | rep | PA | 2019-01-03 | 2021-01-03 | Republican | 11 | https://smucker.house.gov | 127 Cannon House Office Building Washington DC 20515-3811 | 202-225-2411 | 127 Cannon House Office Building | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | ||||||||
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 | |||||||||
44179 | 44179 | Anthony Brown B001304 | rep | MD | 2019-01-03 | 2021-01-03 | Democrat | 4 | https://anthonybrown.house.gov | 1323 Longworth House Office Building Washington DC 20515-2004 | 202-225-8699 | 1323 Longworth House Office Building | |||||||||
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 | ||||||||
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 | |||||||||
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 | |||||||||
42752 | 42752 | Zoe Lofgren L000397 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 19 | https://lofgren.house.gov | 1401 Longworth House Office Building Washington DC 20515-0519 | 202-225-3072 | 1401 Longworth House Office Building | http://lofgren.house.gov/index.php?format=feed&type=rss |
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);