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 party
This data as json, copyable, CSV (advanced)
Suggested facets: start, district, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
41284 | 41284 | Tom Udall U000039 | sen | NM | 2015-01-06 | 2021-01-03 | 2 | Democrat | https://www.tomudall.senate.gov | 531 Hart Senate Office Building Washington DC 20510 | 202-224-6621 | 202-228-3261 | https://www.tomudall.senate.gov/?p=contact | 531 Hart Senate Office Building | senior | http://tomudall.senate.gov/rss/?p=blog | |||||
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 | |||||||||
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 | |||||||||
41381 | 41381 | Daniel Lipinski L000563 | rep | IL | 2019-01-03 | 2021-01-03 | Democrat | 3 | https://lipinski.house.gov | 2346 Rayburn House Office Building Washington DC 20515-1303 | 202-225-5701 | 2346 Rayburn House Office Building | http://www.lipinski.house.gov/common/rss//index.cfm?rss=25 | ||||||||
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 | ||||||||
41404 | 41404 | Nita Lowey L000480 | rep | NY | 2019-01-03 | 2021-01-03 | Democrat | 17 | https://lowey.house.gov | 2365 Rayburn House Office Building Washington DC 20515-3217 | 202-225-6506 | 2365 Rayburn House Office Building | http://www.house.gov/common/rss/?rss=18 | ||||||||
41433 | 41433 | Collin Peterson P000258 | rep | MN | 2019-01-03 | 2021-01-03 | Democrat | 7 | https://collinpeterson.house.gov | 2204 Rayburn House Office Building Washington DC 20515-2307 | 202-225-2165 | 2204 Rayburn House Office Building | http://collinpeterson.house.gov/rss.xml | ||||||||
41481 | 41481 | José Serrano S000248 | rep | NY | 2019-01-03 | 2021-01-03 | Democrat | 15 | https://serrano.house.gov | 2354 Rayburn House Office Building Washington DC 20515-3215 | 202-225-4361 | 2354 Rayburn House Office Building | http://serrano.house.gov/rss.xml | ||||||||
41529 | 41529 | Peter Visclosky V000108 | rep | IN | 2019-01-03 | 2021-01-03 | Democrat | 1 | https://visclosky.house.gov | 2328 Rayburn House Office Building Washington DC 20515-1401 | 202-225-2461 | 2328 Rayburn House Office Building | http://visclosky.house.gov/rss.xml | ||||||||
41557 | 41557 | Tulsi Gabbard G000571 | rep | HI | 2019-01-03 | 2021-01-03 | Democrat | 2 | https://gabbard.house.gov | 1433 Longworth House Office Building Washington DC 20515-1102 | 202-225-4906 | 1433 Longworth House Office Building | http://gabbard.house.gov/rss.xml | ||||||||
41565 | 41565 | Joseph Kennedy K000379 | rep | MA | 2019-01-03 | 2021-01-03 | Democrat | 4 | https://kennedy.house.gov | 304 Cannon House Office Building Washington DC 20515-2104 | 202-225-5931 | 304 Cannon House Office Building | http://kennedy.house.gov/rss.xml | ||||||||
41573 | 41573 | Denny Heck H001064 | rep | WA | 2019-01-03 | 2021-01-03 | Democrat | 10 | https://dennyheck.house.gov | 2452 Rayburn House Office Building Washington DC 20515-4710 | 202-225-9740 | 2452 Rayburn House Office Building | http://dennyheck.house.gov/rss.xml | ||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | ||||||||
41615 | 41615 | Cedric Richmond R000588 | rep | LA | 2019-01-03 | 2021-01-03 | Democrat | 2 | https://richmond.house.gov | 506 Cannon House Office Building Washington DC 20515-1802 | 202-225-6636 | 506 Cannon House Office Building | http://richmond.house.gov/rss.xml | ||||||||
41627 | 41627 | Marcia Fudge F000455 | rep | OH | 2019-01-03 | 2021-01-03 | Democrat | 11 | https://fudge.house.gov | 2344 Rayburn House Office Building Washington DC 20515-3511 | 202-225-7032 | 2344 Rayburn House Office Building | http://fudge.house.gov/common/rss//index.cfm?rss=25 | ||||||||
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 | |||||||||
41644 | 41644 | Alcee Hastings H000324 | rep | FL | 2019-01-03 | 2021-01-03 | Democrat | 20 | https://alceehastings.house.gov | 2353 Rayburn House Office Building Washington DC 20515-0920 | 202-225-1313 | 2353 Rayburn House Office Building | http://www.alceehastings.house.gov/news/rss.aspx | ||||||||
41701 | 41701 | Filemon Vela V000132 | rep | TX | 2019-01-03 | 2021-01-03 | Democrat | 34 | https://vela.house.gov | 307 Cannon House Office Building Washington DC 20515-4334 | 202-225-9901 | 307 Cannon House Office Building | http://vela.house.gov/rss.xml | ||||||||
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 | |||||||||
41725 | 41725 | Theodore Deutch D000610 | rep | FL | 2019-01-03 | 2021-01-03 | Democrat | 22 | https://teddeutch.house.gov | 2447 Rayburn House Office Building Washington DC 20515-0922 | 202-225-3001 | 2447 Rayburn House Office Building | http://teddeutch.house.gov/news/rss.aspx | ||||||||
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 | |||||||||
41846 | 41846 | Richard Durbin D000563 | sen | IL | 2015-01-06 | 2021-01-03 | 2 | Democrat | https://www.durbin.senate.gov | 711 Hart Senate Office Building Washington DC 20510 | 202-224-2152 | 202-228-0400 | https://www.durbin.senate.gov/contact/ | 711 Hart Senate Office Building | senior | http://durbin.senate.gov/public/index.cfm/rss/feed | |||||
41874 | 41874 | Jeff Merkley M001176 | sen | OR | 2015-01-06 | 2021-01-03 | 2 | Democrat | https://www.merkley.senate.gov | 313 Hart Senate Office Building Washington DC 20510 | 202-224-3753 | 202-228-3997 | http://www.merkley.senate.gov/contact/ | 313 Hart Senate Office Building | junior | http://www.merkley.senate.gov/rss/ | |||||
41882 | 41882 | John Reed R000122 | sen | RI | 2015-01-06 | 2021-01-03 | 2 | Democrat | https://www.reed.senate.gov | 728 Hart Senate Office Building Washington DC 20510 | 202-224-4642 | 202-224-4680 | https://www.reed.senate.gov/contact/ | 728 Hart Senate Office Building | senior | https://www.reed.senate.gov//rss/feeds/?type=all | |||||
41888 | 41888 | Jeanne Shaheen S001181 | sen | NH | 2015-01-06 | 2021-01-03 | 2 | Democrat | https://www.shaheen.senate.gov | 506 Hart Senate Office Building Washington DC 20510 | 202-224-2841 | 202-228-3194 | https://www.shaheen.senate.gov/contact/contact-jeanne | 506 Hart Senate Office Building | senior | http://www.shaheen.senate.gov/rss/ | |||||
41891 | 41891 | Mark Warner W000805 | sen | VA | 2015-01-06 | 2021-01-03 | 2 | Democrat | https://www.warner.senate.gov | 703 Hart Senate Office Building Washington DC 20510 | 202-224-2023 | 202-224-6295 | http://www.warner.senate.gov/public/index.cfm?p=Contact | 703 Hart Senate Office Building | senior | http://www.warner.senate.gov/public/?a=rss.feed | |||||
41899 | 41899 | Christopher Coons C001088 | sen | DE | 2015-01-06 | 2021-01-03 | 2 | Democrat | https://www.coons.senate.gov | 218 Russell Senate Office Building Washington DC 20510 | 202-224-5042 | 202-228-3075 | https://www.coons.senate.gov/contact | 218 Russell Senate Office Building | junior | http://www.coons.senate.gov/rss/feeds/?type=all | |||||
41930 | 41930 | Karen Bass B001270 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 37 | https://bass.house.gov | 2059 Rayburn House Office Building Washington DC 20515-0537 | 202-225-7084 | 2059 Rayburn House Office Building | http://bass.house.gov/rss.xml | ||||||||
41956 | 41956 | Sanford Bishop B000490 | rep | GA | 2019-01-03 | 2021-01-03 | Democrat | 2 | https://bishop.house.gov | 2407 Rayburn House Office Building Washington DC 20515-1002 | 202-225-3631 | 2407 Rayburn House Office Building | http://bishop.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 | ||||||||
42058 | 42058 | George Butterfield B001251 | rep | NC | 2019-01-03 | 2021-01-03 | Democrat | 1 | https://butterfield.house.gov | 2080 Rayburn House Office Building Washington DC 20515-3301 | 202-225-3101 | 2080 Rayburn House Office Building | http://butterfield.house.gov/rss/press-releases.xml/ | ||||||||
42090 | 42090 | André Carson C001072 | rep | IN | 2019-01-03 | 2021-01-03 | Democrat | 7 | https://carson.house.gov | 2135 Rayburn House Office Building Washington DC 20515-1407 | 202-225-4011 | 2135 Rayburn House Office Building | http://carson.house.gov/index.php?option=com_bca-rss-syndicator&feed_id=1 | ||||||||
42113 | 42113 | Kathy Castor C001066 | rep | FL | 2019-01-03 | 2021-01-03 | Democrat | 14 | https://castor.house.gov | 2052 Rayburn House Office Building Washington DC 20515-0914 | 202-225-3376 | 2052 Rayburn House Office Building | http://castor.house.gov/news/rss.aspx | ||||||||
42133 | 42133 | Judy Chu C001080 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 27 | https://chu.house.gov | 2423 Rayburn House Office Building Washington DC 20515-0527 | 202-225-5464 | 2423 Rayburn House Office Building | http://chu.house.gov/rss.xml | ||||||||
42139 | 42139 | David Cicilline C001084 | rep | RI | 2019-01-03 | 2021-01-03 | Democrat | 1 | https://cicilline.house.gov | 2233 Rayburn House Office Building Washington DC 20515-3901 | 202-225-4911 | 2233 Rayburn House Office Building | http://cicilline.house.gov/rss.xml | ||||||||
42147 | 42147 | Yvette Clarke C001067 | rep | NY | 2019-01-03 | 2021-01-03 | Democrat | 9 | https://clarke.house.gov | 2058 Rayburn House Office Building Washington DC 20515-3209 | 202-225-6231 | 2058 Rayburn House Office Building | http://clarke.house.gov/news/rss.aspx | ||||||||
42156 | 42156 | Emanuel Cleaver C001061 | rep | MO | 2019-01-03 | 2021-01-03 | Democrat | 5 | https://cleaver.house.gov | 2335 Rayburn House Office Building Washington DC 20515-2505 | 202-225-4535 | 2335 Rayburn House Office Building | http://cleaver.house.gov/rss.xml | ||||||||
42171 | 42171 | James Clyburn C000537 | rep | SC | 2019-01-03 | 2021-01-03 | Democrat | 6 | https://clyburn.house.gov | 200 Cannon House Office Building Washington DC 20515-4006 | 202-225-3315 | 200 Cannon House Office Building | http://clyburn.house.gov/rss.xml | ||||||||
42179 | 42179 | Steve Cohen C001068 | rep | TN | 2019-01-03 | 2021-01-03 | Democrat | 9 | https://cohen.house.gov | 2104 Rayburn House Office Building Washington DC 20515-4209 | 202-225-3265 | 2104 Rayburn House Office Building | http://cohen.house.gov/rss.xml | ||||||||
42196 | 42196 | Gerald Connolly C001078 | rep | VA | 2019-01-03 | 2021-01-03 | Democrat | 11 | https://connolly.house.gov | 2238 Rayburn House Office Building Washington DC 20515-4611 | 202-225-1492 | 2238 Rayburn House Office Building | http://connolly.house.gov/common/rss//index.cfm?rss=44 | ||||||||
42212 | 42212 | Jim Cooper C000754 | rep | TN | 2019-01-03 | 2021-01-03 | Democrat | 5 | https://cooper.house.gov | 1536 Longworth House Office Building Washington DC 20515-4205 | 202-225-4311 | 1536 Longworth House Office Building | http://cooper.house.gov/index.php?format=feed&type=rss | ||||||||
42221 | 42221 | Jim Costa C001059 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 16 | https://costa.house.gov | 2081 Rayburn House Office Building Washington DC 20515-0516 | 202-225-3341 | 2081 Rayburn House Office Building | http://costa.house.gov/index.php?format=feed&type=rss | ||||||||
42229 | 42229 | Joe Courtney C001069 | rep | CT | 2019-01-03 | 2021-01-03 | Democrat | 2 | https://courtney.house.gov | 2332 Rayburn House Office Building Washington DC 20515-0702 | 202-225-2076 | 2332 Rayburn House Office Building | http://courtney.house.gov/index.php?format=feed&type=rss | ||||||||
42251 | 42251 | Henry Cuellar C001063 | rep | TX | 2019-01-03 | 2021-01-03 | Democrat | 28 | https://cuellar.house.gov | 2372 Rayburn House Office Building Washington DC 20515-4328 | 202-225-1640 | 2372 Rayburn House Office Building | http://cuellar.house.gov/news/rss.aspx | ||||||||
42264 | 42264 | Danny Davis D000096 | rep | IL | 2019-01-03 | 2021-01-03 | Democrat | 7 | https://davis.house.gov | 2159 Rayburn House Office Building Washington DC 20515-1307 | 202-225-5006 | 2159 Rayburn House Office Building | http://davis.house.gov/index.php?format=feed&type=rss | ||||||||
42282 | 42282 | Peter DeFazio D000191 | rep | OR | 2019-01-03 | 2021-01-03 | Democrat | 4 | https://defazio.house.gov | 2134 Rayburn House Office Building Washington DC 20515-3704 | 202-225-6416 | 2134 Rayburn House Office Building | http://www.defazio.house.gov/index.php?format=feed&type=rss | ||||||||
42295 | 42295 | Diana DeGette D000197 | rep | CO | 2019-01-03 | 2021-01-03 | Democrat | 1 | https://degette.house.gov | 2111 Rayburn House Office Building Washington DC 20515-0601 | 202-225-4431 | 2111 Rayburn House Office Building | http://degette.house.gov/index.php?option=com_ninjarsssyndicator&feed_id=1&format=raw | ||||||||
42311 | 42311 | Rosa DeLauro D000216 | rep | CT | 2019-01-03 | 2021-01-03 | Democrat | 3 | https://delauro.house.gov | 2413 Rayburn House Office Building Washington DC 20515-0703 | 202-225-3661 | 2413 Rayburn House Office Building | http://delauro.house.gov/index.php?format=feed&type=rss | ||||||||
42341 | 42341 | Lloyd Doggett D000399 | rep | TX | 2019-01-03 | 2021-01-03 | Democrat | 35 | https://doggett.house.gov | 2307 Rayburn House Office Building Washington DC 20515-4335 | 202-225-4865 | 2307 Rayburn House Office Building | http://doggett.house.gov/index.php/component/ninjarsssyndicator/?feed_id=1&format=raw | ||||||||
42355 | 42355 | Michael Doyle D000482 | rep | PA | 2019-01-03 | 2021-01-03 | Democrat | 18 | https://doyle.house.gov | 306 Cannon House Office Building Washington DC 20515-3818 | 202-225-2135 | 306 Cannon House Office Building | http://doyle.house.gov/rss.xml | ||||||||
42376 | 42376 | Anna Eshoo E000215 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 18 | https://eshoo.house.gov | 202 Cannon House Office Building Washington DC 20515-0518 | 202-225-8104 | 202 Cannon House Office Building | http://eshoo.house.gov/index.php?format=feed&type=rss | ||||||||
42398 | 42398 | John Garamendi G000559 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 3 | https://garamendi.house.gov | 2368 Rayburn House Office Building Washington DC 20515-0503 | 202-225-1880 | 2368 Rayburn House Office Building | http://garamendi.house.gov/rss.xml | ||||||||
42462 | 42462 | Al Green G000553 | rep | TX | 2019-01-03 | 2021-01-03 | Democrat | 9 | https://algreen.house.gov | 2347 Rayburn House Office Building Washington DC 20515-4309 | 202-225-7508 | 2347 Rayburn House Office Building | http://algreen.house.gov/rss.xml | ||||||||
42478 | 42478 | Raúl Grijalva G000551 | rep | AZ | 2019-01-03 | 2021-01-03 | Democrat | 3 | https://grijalva.house.gov | 1511 Longworth House Office Building Washington DC 20515-0303 | 202-225-2435 | 1511 Longworth House Office Building | http://grijalva.house.gov/common/rss/?rss=13 | ||||||||
42516 | 42516 | Brian Higgins H001038 | rep | NY | 2019-01-03 | 2021-01-03 | Democrat | 26 | https://higgins.house.gov | 2459 Rayburn House Office Building Washington DC 20515-3226 | 202-225-3306 | 2459 Rayburn House Office Building | http://higgins.house.gov/rss.xml | ||||||||
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 | ||||||||
42551 | 42551 | Steny Hoyer H000874 | rep | MD | 2019-01-03 | 2021-01-03 | Democrat | 5 | https://hoyer.house.gov | 1705 Longworth House Office Building Washington DC 20515-2005 | 202-225-4131 | 1705 Longworth House Office Building | http://hoyer.house.gov/index.php?format=feed&type=rss | ||||||||
42571 | 42571 | Sheila Jackson Lee J000032 | rep | TX | 2019-01-03 | 2021-01-03 | Democrat | 18 | https://jacksonlee.house.gov | 2079 Rayburn House Office Building Washington DC 20515-4318 | 202-225-3816 | 2079 Rayburn House Office Building | http://jacksonlee.house.gov/news/rss.aspx | ||||||||
42592 | 42592 | Eddie Johnson J000126 | rep | TX | 2019-01-03 | 2021-01-03 | Democrat | 30 | https://ebjohnson.house.gov | 2306 Rayburn House Office Building Washington DC 20515-4330 | 202-225-8885 | 2306 Rayburn House Office Building | http://ebjohnson.house.gov/common/rss//index.cfm?rss=21 | ||||||||
42600 | 42600 | Henry Johnson J000288 | rep | GA | 2019-01-03 | 2021-01-03 | Democrat | 4 | https://hankjohnson.house.gov | 2240 Rayburn House Office Building Washington DC 20515-1004 | 202-225-1605 | 2240 Rayburn House Office Building | http://hankjohnson.house.gov/rss.xml | ||||||||
42630 | 42630 | Marcy Kaptur K000009 | rep | OH | 2019-01-03 | 2021-01-03 | Democrat | 9 | https://kaptur.house.gov | 2186 Rayburn House Office Building Washington DC 20515-3509 | 202-225-4146 | 2186 Rayburn House Office Building | http://kaptur.house.gov/index.php?format=feed&type=rss | ||||||||
42636 | 42636 | William Keating K000375 | rep | MA | 2019-01-03 | 2021-01-03 | Democrat | 9 | https://keating.house.gov | 2351 Rayburn House Office Building Washington DC 20515-2109 | 202-225-3111 | 2351 Rayburn House Office Building | http://keating.house.gov/index.php?format=feed&type=rss | ||||||||
42655 | 42655 | Ron Kind K000188 | rep | WI | 2019-01-03 | 2021-01-03 | Democrat | 3 | https://kind.house.gov | 1502 Longworth House Office Building Washington DC 20515-4903 | 202-225-5506 | 1502 Longworth House Office Building | http://kind.house.gov/common/rss/?rss=52 | ||||||||
42680 | 42680 | James Langevin L000559 | rep | RI | 2019-01-03 | 2021-01-03 | Democrat | 2 | https://langevin.house.gov | 2077 Rayburn House Office Building Washington DC 20515-3902 | 202-225-2735 | 2077 Rayburn House Office Building | http://langevin.house.gov/rss.xml | ||||||||
42695 | 42695 | Rick Larsen L000560 | rep | WA | 2019-01-03 | 2021-01-03 | Democrat | 2 | https://larsen.house.gov | 2113 Rayburn House Office Building Washington DC 20515-4702 | 202-225-2605 | 2113 Rayburn House Office Building | http://larsen.house.gov/rss.xml | ||||||||
42707 | 42707 | John Larson L000557 | rep | CT | 2019-01-03 | 2021-01-03 | Democrat | 1 | https://larson.house.gov | 1501 Longworth House Office Building Washington DC 20515-0701 | 202-225-2265 | 1501 Longworth House Office Building | http://www.larson.house.gov/index.php?format=feed&type=rss | ||||||||
42736 | 42736 | Barbara Lee L000551 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 13 | https://lee.house.gov | 2470 Rayburn House Office Building Washington DC 20515-0513 | 202-225-2661 | 2470 Rayburn House Office Building | http://lee.house.gov/rss.xml | ||||||||
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 | ||||||||
42787 | 42787 | Ben Luján L000570 | rep | NM | 2019-01-03 | 2021-01-03 | Democrat | 3 | https://lujan.house.gov | 2323 Rayburn House Office Building Washington DC 20515-3103 | 202-225-6190 | 2323 Rayburn House Office Building | http://lujan.house.gov/index.php?option=com_bca-rss-syndicator&feed_id=1 | ||||||||
42798 | 42798 | Stephen Lynch L000562 | rep | MA | 2019-01-03 | 2021-01-03 | Democrat | 8 | https://lynch.house.gov | 2109 Rayburn House Office Building Washington DC 20515-2108 | 202-225-8273 | 2109 Rayburn House Office Building | http://lynch.house.gov/rss.xml | ||||||||
42813 | 42813 | Carolyn Maloney M000087 | rep | NY | 2019-01-03 | 2021-01-03 | Democrat | 12 | https://maloney.house.gov | 2308 Rayburn House Office Building Washington DC 20515-3212 | 202-225-7944 | 2308 Rayburn House Office Building | http://maloney.house.gov/rss.xml | ||||||||
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 | |||||||
42845 | 42845 | Doris Matsui M001163 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 6 | https://matsui.house.gov | 2311 Rayburn House Office Building Washington DC 20515-0506 | 202-225-7163 | 2311 Rayburn House Office Building | http://matsui.house.gov/index.php?format=feed&type=rss | ||||||||
42880 | 42880 | Betty McCollum M001143 | rep | MN | 2019-01-03 | 2021-01-03 | Democrat | 4 | https://mccollum.house.gov | 2256 Rayburn House Office Building Washington DC 20515-2304 | 202-225-6631 | 2256 Rayburn House Office Building | http://mccollum.house.gov/rss.xml | ||||||||
42893 | 42893 | James McGovern M000312 | rep | MA | 2019-01-03 | 2021-01-03 | Democrat | 2 | https://mcgovern.house.gov | 408 Cannon House Office Building Washington DC 20515-2102 | 202-225-6101 | 408 Cannon House Office Building | http://mcgovern.house.gov/common/rss/?rss=15 | ||||||||
42925 | 42925 | Jerry McNerney M001166 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 9 | https://mcnerney.house.gov | 2265 Rayburn House Office Building Washington DC 20515-0509 | 202-225-1947 | 2265 Rayburn House Office Building | http://mcnerney.house.gov/rss.xml | ||||||||
42938 | 42938 | Gregory Meeks M001137 | rep | NY | 2019-01-03 | 2021-01-03 | Democrat | 5 | https://meeks.house.gov | 2310 Rayburn House Office Building Washington DC 20515-3205 | 202-225-3461 | 2310 Rayburn House Office Building | http://meeks.house.gov/rss.xml | ||||||||
42947 | 42947 | Gwen Moore M001160 | rep | WI | 2019-01-03 | 2021-01-03 | Democrat | 4 | https://gwenmoore.house.gov | 2252 Rayburn House Office Building Washington DC 20515-4904 | 202-225-4572 | 2252 Rayburn House Office Building | http://gwenmoore.house.gov/common/rss/index.cfm?rss=49 | ||||||||
42986 | 42986 | Jerrold Nadler N000002 | rep | NY | 2019-01-03 | 2021-01-03 | Democrat | 10 | https://nadler.house.gov | 2132 Rayburn House Office Building Washington DC 20515-3210 | 202-225-5635 | 2132 Rayburn House Office Building | http://nadler.house.gov/rss.xml | ||||||||
42998 | 42998 | Grace Napolitano N000179 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 32 | https://napolitano.house.gov | 1610 Longworth House Office Building Washington DC 20515-0532 | 202-225-5256 | 1610 Longworth House Office Building | http://napolitano.house.gov/rss.xml | ||||||||
43015 | 43015 | Richard Neal N000015 | rep | MA | 2019-01-03 | 2021-01-03 | Democrat | 1 | https://neal.house.gov | 2309 Rayburn House Office Building Washington DC 20515-2101 | 202-225-5601 | 2309 Rayburn House Office Building | http://neal.house.gov/index.php?format=feed&type=rss | ||||||||
43031 | 43031 | Eleanor Norton N000147 | rep | DC | 2019-01-03 | 2021-01-03 | Democrat | 0 | https://norton.house.gov | 2136 Rayburn House Office Building Washington DC 20515-5101 | 202-225-8050 | 2136 Rayburn House Office Building | http://norton.house.gov/index.php?format=feed&type=rss | ||||||||
43055 | 43055 | Frank Pallone P000034 | rep | NJ | 2019-01-03 | 2021-01-03 | Democrat | 6 | https://pallone.house.gov | 2107 Rayburn House Office Building Washington DC 20515-3006 | 202-225-4671 | 2107 Rayburn House Office Building | http://pallone.house.gov/rss.xml | ||||||||
43068 | 43068 | Bill Pascrell P000096 | rep | NJ | 2019-01-03 | 2021-01-03 | Democrat | 9 | https://pascrell.house.gov | 2409 Rayburn House Office Building Washington DC 20515-3009 | 202-225-5751 | 2409 Rayburn House Office Building | http://www.house.gov/apps/list/press/nj08_pascrell/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 |
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);