legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
472 rows where "end" is on date 2023-01-03
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
42918 | 42918 | Cathy McMorris Rodgers M001159 | rep | WA | 2021-01-03 | 2023-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 | ||||||||
42926 | 42926 | Jerry McNerney M001166 | rep | CA | 2021-01-03 | 2023-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 | ||||||||
42939 | 42939 | Gregory Meeks M001137 | rep | NY | 2021-01-03 | 2023-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 | ||||||||
42948 | 42948 | Gwen Moore M001160 | rep | WI | 2021-01-03 | 2023-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 | ||||||||
42957 | 42957 | Jerry Moran M000934 | sen | KS | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.moran.senate.gov | 521 Dirksen Senate Office Building Washington DC 20510 | 202-224-6521 | 202-228-6966 | https://www.moran.senate.gov/public/index.cfm/e-mail-jerry | 521 Dirksen Senate Office Building | senior | http://www.moran.senate.gov/public/index.cfm/rss/feed/ | |||||
42961 | 42961 | Lisa Murkowski M001153 | sen | AK | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.murkowski.senate.gov | 522 Hart Senate Office Building Washington DC 20510 | 202-224-6665 | 202-224-5301 | https://www.murkowski.senate.gov/public/index.cfm/contact | 522 Hart Senate Office Building | senior | http://www.murkowski.senate.gov/public/?a=rss.feed | |||||
42971 | 42971 | Patty Murray M001111 | sen | WA | 2017-01-03 | 2023-01-03 | 3 | Democrat | https://www.murray.senate.gov | 154 Russell Senate Office Building Washington DC 20510 | 202-224-2621 | 202-224-0238 | https://www.murray.senate.gov/write-to-patty/ | 154 Russell Senate Office Building | senior | http://www.murray.senate.gov/public/?a=rss.feed | |||||
42987 | 42987 | Jerrold Nadler N000002 | rep | NY | 2021-01-03 | 2023-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 | ||||||||
42999 | 42999 | Grace Napolitano N000179 | rep | CA | 2021-01-03 | 2023-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 | ||||||||
43016 | 43016 | Richard Neal N000015 | rep | MA | 2021-01-03 | 2023-01-03 | Democrat | 1 | https://neal.house.gov | 372 Cannon House Office Building Washington DC 20515-2101 | 202-225-5601 | 372 Cannon House Office Building | http://neal.house.gov/index.php?format=feed&type=rss | ||||||||
43032 | 43032 | Eleanor Norton N000147 | rep | DC | 2021-01-03 | 2023-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 | ||||||||
43038 | 43038 | Steven Palazzo P000601 | rep | MS | 2021-01-03 | 2023-01-03 | Republican | 4 | https://palazzo.house.gov | 2349 Rayburn House Office Building Washington DC 20515-2404 | 202-225-5772 | 2349 Rayburn House Office Building | http://palazzo.house.gov/rss.xml | ||||||||
43056 | 43056 | Frank Pallone P000034 | rep | NJ | 2021-01-03 | 2023-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 | ||||||||
43069 | 43069 | Bill Pascrell P000096 | rep | NJ | 2021-01-03 | 2023-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 | ||||||||
43071 | 43071 | Rand Paul P000603 | sen | KY | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.paul.senate.gov | 167 Russell Senate Office Building Washington DC 20510 | 202-224-4343 | 202-228-1373 | https://www.paul.senate.gov/connect/email-rand | 167 Russell Senate Office Building | junior | http://paul.senate.gov/rss/?p=news | |||||
43089 | 43089 | Nancy Pelosi P000197 | rep | CA | 2021-01-03 | 2023-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 | ||||||||
43097 | 43097 | Ed Perlmutter P000593 | rep | CO | 2021-01-03 | 2023-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 | ||||||||
43109 | 43109 | Chellie Pingree P000597 | rep | ME | 2021-01-03 | 2023-01-03 | Democrat | 1 | https://pingree.house.gov | 2162 Rayburn House Office Building Washington DC 20515-1901 | 202-225-6116 | 2162 Rayburn House Office Building | http://pingree.house.gov/index.php?format=feed&type=rss | ||||||||
43118 | 43118 | Robert Portman P000449 | sen | OH | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.portman.senate.gov | 448 Russell Senate Office Building Washington DC 20510 | 202-224-3353 | https://www.portman.senate.gov/public/index.cfm/contact?p=contact-form | 448 Russell Senate Office Building | junior | http://www.portman.senate.gov/public/index.cfm/rss/feed | ||||||
43125 | 43125 | Bill Posey P000599 | rep | FL | 2021-01-03 | 2023-01-03 | Republican | 8 | https://posey.house.gov | 2150 Rayburn House Office Building Washington DC 20515-0908 | 202-225-3671 | 2150 Rayburn House Office Building | http://posey.house.gov/news/rss.aspx?documenttypeid=1487 | ||||||||
43142 | 43142 | David Price P000523 | rep | NC | 2021-01-03 | 2023-01-03 | Democrat | 4 | https://price.house.gov | 2108 Rayburn House Office Building Washington DC 20515-3304 | 202-225-1784 | 2108 Rayburn House Office Building | http://price.house.gov/index.php?format=feed&type=rss | ||||||||
43149 | 43149 | Mike Quigley Q000023 | rep | IL | 2021-01-03 | 2023-01-03 | Democrat | 5 | https://quigley.house.gov | 2078 Rayburn House Office Building Washington DC 20515-1305 | 202-225-4061 | 2078 Rayburn House Office Building | http://quigley.house.gov/index.php?format=feed&type=rss | ||||||||
43170 | 43170 | Harold Rogers R000395 | rep | KY | 2021-01-03 | 2023-01-03 | Republican | 5 | https://halrogers.house.gov | 2406 Rayburn House Office Building Washington DC 20515-1705 | 202-225-4601 | 2406 Rayburn House Office Building | http://halrogers.house.gov/news/rss.aspx | ||||||||
43180 | 43180 | Mike Rogers R000575 | rep | AL | 2021-01-03 | 2023-01-03 | Republican | 3 | https://mikerogers.house.gov | 2469 Rayburn House Office Building Washington DC 20515-0103 | 202-225-3261 | 2469 Rayburn House Office Building | http://mikerogers.house.gov/rss.xml | ||||||||
43195 | 43195 | Lucille Roybal-Allard R000486 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 40 | https://roybal-allard.house.gov | 2083 Rayburn House Office Building Washington DC 20515-0540 | 202-225-1766 | 2083 Rayburn House Office Building | http://roybal-allard.house.gov/news/rss.aspx | ||||||||
43197 | 43197 | Marco Rubio R000595 | sen | FL | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.rubio.senate.gov | 284 Russell Senate Office Building Washington DC 20510 | 202-224-3041 | 202-228-0285 | https://www.rubio.senate.gov/public/index.cfm/contact | 284 Russell Senate Office Building | senior | http://www.rubio.senate.gov/public/?a=rss.feed | |||||
43207 | 43207 | C. Ruppersberger R000576 | rep | MD | 2021-01-03 | 2023-01-03 | Democrat | 2 | https://ruppersberger.house.gov | 2206 Rayburn House Office Building Washington DC 20515-2002 | 202-225-3061 | 2206 Rayburn House Office Building | http://dutch.house.gov/atom.xml | ||||||||
43222 | 43222 | Bobby Rush R000515 | rep | IL | 2021-01-03 | 2023-01-03 | Democrat | 1 | https://rush.house.gov | 2188 Rayburn House Office Building Washington DC 20515-1301 | 202-225-4372 | 2188 Rayburn House Office Building | http://rush.house.gov/rss.xml | ||||||||
43232 | 43232 | Tim Ryan R000577 | rep | OH | 2021-01-03 | 2023-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 | ||||||||
43239 | 43239 | Gregorio Sablan S001177 | rep | MP | 2021-01-03 | 2023-01-03 | Democrat | 0 | https://sablan.house.gov | 2267 Rayburn House Office Building Washington DC 20515-5201 | 202-225-2646 | 2267 Rayburn House Office Building | http://sablan.house.gov/rss.xml | ||||||||
43247 | 43247 | John Sarbanes S001168 | rep | MD | 2021-01-03 | 2023-01-03 | Democrat | 3 | https://sarbanes.house.gov | 2370 Rayburn House Office Building Washington DC 20515-2003 | 202-225-4016 | 2370 Rayburn House Office Building | http://sarbanes.house.gov/rss_news.asp | ||||||||
43255 | 43255 | Steve Scalise S001176 | rep | LA | 2021-01-03 | 2023-01-03 | Republican | 1 | https://scalise.house.gov | 2049 Rayburn House Office Building Washington DC 20515-1801 | 202-225-3015 | 2049 Rayburn House Office Building | http://scalise.house.gov/rss.xml | ||||||||
43267 | 43267 | Janice Schakowsky S001145 | rep | IL | 2021-01-03 | 2023-01-03 | Democrat | 9 | https://schakowsky.house.gov | 2367 Rayburn House Office Building Washington DC 20515-1309 | 202-225-2111 | 2367 Rayburn House Office Building | http://schakowsky.house.gov/index.php?format=feed&type=rss | ||||||||
43278 | 43278 | Adam Schiff S001150 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 28 | https://schiff.house.gov | 2309 Rayburn House Office Building Washington DC 20515-0528 | 202-225-4176 | 2309 Rayburn House Office Building | http://schiff.house.gov/common/rss/?rss=49 | ||||||||
43285 | 43285 | Kurt Schrader S001180 | rep | OR | 2021-01-03 | 2023-01-03 | Democrat | 5 | https://schrader.house.gov | 2431 Rayburn House Office Building Washington DC 20515-3705 | 202-225-5711 | 2431 Rayburn House Office Building | http://schrader.house.gov/news/rss.aspx | ||||||||
43298 | 43298 | Charles Schumer S000148 | sen | NY | 2017-01-03 | 2023-01-03 | 3 | Democrat | https://www.schumer.senate.gov | 322 Hart Senate Office Building Washington DC 20510 | 202-224-6542 | 202-228-3027 | https://www.schumer.senate.gov/contact/email-chuck | 322 Hart Senate Office Building | senior | ||||||
43304 | 43304 | David Schweikert S001183 | rep | AZ | 2021-01-03 | 2023-01-03 | Republican | 6 | https://schweikert.house.gov | 304 Cannon House Office Building Washington DC 20515-0306 | 202-225-2190 | 304 Cannon House Office Building | http://schweikert.house.gov/rss/press-releases.xml | ||||||||
43310 | 43310 | Austin Scott S001189 | rep | GA | 2021-01-03 | 2023-01-03 | Republican | 8 | https://austinscott.house.gov | 2417 Rayburn House Office Building Washington DC 20515-1008 | 202-225-6531 | 2417 Rayburn House Office Building | http://austinscott.house.gov/index.php?format=feed&type=rss | ||||||||
43320 | 43320 | David Scott S001157 | rep | GA | 2021-01-03 | 2023-01-03 | Democrat | 13 | https://davidscott.house.gov | 468 Cannon House Office Building Washington DC 20515-1013 | 202-225-2939 | 468 Cannon House Office Building | http://davidscott.house.gov/news/rss.aspx | ||||||||
43335 | 43335 | Robert Scott S000185 | rep | VA | 2021-01-03 | 2023-01-03 | Democrat | 3 | https://bobbyscott.house.gov | 2328 Rayburn House Office Building Washington DC 20515-4603 | 202-225-8351 | 2328 Rayburn House Office Building | http://www.house.gov/index.php?format=feed&type=rss | ||||||||
43339 | 43339 | Tim Scott S001184 | sen | SC | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.scott.senate.gov | 104 Hart Senate Office Building Washington DC 20510 | 202-224-6121 | 202-225-3407 | https://www.scott.senate.gov/contact/email-me | 104 Hart Senate Office Building | junior | http://www.scott.senate.gov/rss.xml | |||||
43345 | 43345 | Terri Sewell S001185 | rep | AL | 2021-01-03 | 2023-01-03 | Democrat | 7 | https://sewell.house.gov | 2201 Rayburn House Office Building Washington DC 20515-0107 | 202-225-2665 | 2201 Rayburn House Office Building | http://sewell.house.gov/rss.xml | ||||||||
43355 | 43355 | Richard Shelby S000320 | sen | AL | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.shelby.senate.gov | 304 Russell Senate Office Building Washington DC 20510 | 202-224-5744 | 202-224-3416 | https://www.shelby.senate.gov/public/index.cfm/emailsenatorshelby | 304 Russell Senate Office Building | senior | http://www.shelby.senate.gov/public/index.cfm/rss/feed | |||||
43368 | 43368 | Brad Sherman S000344 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 30 | https://sherman.house.gov | 2181 Rayburn House Office Building Washington DC 20515-0530 | 202-225-5911 | 2181 Rayburn House Office Building | http://bradsherman.house.gov/press-releases-and-columns/rss.shtml | ||||||||
43380 | 43380 | Michael Simpson S001148 | rep | ID | 2021-01-03 | 2023-01-03 | Republican | 2 | https://simpson.house.gov | 2084 Rayburn House Office Building Washington DC 20515-1202 | 202-225-5531 | 2084 Rayburn House Office Building | http://simpson.house.gov/news/rss.aspx | ||||||||
43389 | 43389 | Albio Sires S001165 | rep | NJ | 2021-01-03 | 2023-01-03 | Democrat | 8 | https://sires.house.gov | 2268 Rayburn House Office Building Washington DC 20515-3008 | 202-225-7919 | 2268 Rayburn House Office Building | http://sires.house.gov/rss.xml | ||||||||
43402 | 43402 | Adam Smith S000510 | rep | WA | 2021-01-03 | 2023-01-03 | Democrat | 9 | https://adamsmith.house.gov | 2264 Rayburn House Office Building Washington DC 20515-4709 | 202-225-8901 | 2264 Rayburn House Office Building | http://www.house.gov/news/rss.aspx | ||||||||
43410 | 43410 | Adrian Smith S001172 | rep | NE | 2021-01-03 | 2023-01-03 | Republican | 3 | https://adriansmith.house.gov | 502 Cannon House Office Building Washington DC 20515-2703 | 202-225-6435 | 502 Cannon House Office Building | http://adriansmith.house.gov/rss.xml | ||||||||
43431 | 43431 | Christopher Smith S000522 | rep | NJ | 2021-01-03 | 2023-01-03 | Republican | 4 | https://chrissmith.house.gov | 2373 Rayburn House Office Building Washington DC 20515-3004 | 202-225-3765 | 2373 Rayburn House Office Building | http://chrissmith.house.gov/news/rss.aspx | ||||||||
43439 | 43439 | Jackie Speier S001175 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 14 | https://speier.house.gov | 2465 Rayburn House Office Building Washington DC 20515-0514 | 202-225-3531 | 2465 Rayburn House Office Building | http://speier.house.gov/index.php?format=feed&type=rss | ||||||||
43449 | 43449 | Linda Sánchez S001156 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 38 | https://lindasanchez.house.gov | 2329 Rayburn House Office Building Washington DC 20515-0538 | 202-225-6676 | 2329 Rayburn House Office Building | http://lindasanchez.house.gov/index.php?format=feed&type=rss | ||||||||
43464 | 43464 | Bennie Thompson T000193 | rep | MS | 2021-01-03 | 2023-01-03 | Democrat | 2 | https://benniethompson.house.gov | 2466 Rayburn House Office Building Washington DC 20515-2402 | 202-225-5876 | 2466 Rayburn House Office Building | http://benniethompson.house.gov/index.php?format=feed&type=rss | ||||||||
43476 | 43476 | Mike Thompson T000460 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 5 | https://mikethompson.house.gov | 268 Cannon House Office Building Washington DC 20515-0505 | 202-225-3311 | 268 Cannon House Office Building | http://mikethompson.house.gov/news/rss.aspx | ||||||||
43483 | 43483 | Glenn Thompson T000467 | rep | PA | 2021-01-03 | 2023-01-03 | Republican | 15 | https://thompson.house.gov | 400 Cannon House Office Building Washington DC 20515-3815 | 202-225-5121 | 400 Cannon House Office Building | http://thompson.house.gov/rss.xml | ||||||||
43489 | 43489 | John Thune T000250 | sen | SD | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.thune.senate.gov | 511 Dirksen Senate Office Building Washington DC 20510 | 202-224-2321 | 202-228-5429 | https://www.thune.senate.gov/public/index.cfm/contact | 511 Dirksen Senate Office Building | senior | http://www.thune.senate.gov/public/index.cfm/rss/feed | |||||
43496 | 43496 | Paul Tonko T000469 | rep | NY | 2021-01-03 | 2023-01-03 | Democrat | 20 | https://tonko.house.gov | 2369 Rayburn House Office Building Washington DC 20515-3220 | 202-225-5076 | 2369 Rayburn House Office Building | http://tonko.house.gov/rss/press-releases.xml | ||||||||
43501 | 43501 | Patrick Toomey T000461 | sen | PA | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.toomey.senate.gov | 455 Dirksen Senate Office Building Washington DC 20510 | 202-224-4254 | 202-228-0284 | https://www.toomey.senate.gov/?p=contact | 455 Dirksen Senate Office Building | junior | http://toomey.senate.gov/rss/?p=hot_topic | |||||
43511 | 43511 | Michael Turner T000463 | rep | OH | 2021-01-03 | 2023-01-03 | Republican | 10 | https://turner.house.gov | 2082 Rayburn House Office Building Washington DC 20515-3510 | 202-225-6465 | 2082 Rayburn House Office Building | http://turner.house.gov/news/rss.aspx | ||||||||
43529 | 43529 | Fred Upton U000031 | rep | MI | 2021-01-03 | 2023-01-03 | Republican | 6 | https://upton.house.gov | 2183 Rayburn House Office Building Washington DC 20515-2206 | 202-225-3761 | 2183 Rayburn House Office Building | http://www.house.gov/news/rss.aspx | ||||||||
43537 | 43537 | Chris Van Hollen V000128 | sen | MD | 2017-01-03 | 2023-01-03 | 3 | Democrat | https://www.vanhollen.senate.gov | 110 Hart Senate Office Building Washington DC 20510 | 202-224-4654 | 202-225-0375 | https://www.vanhollen.senate.gov/contact/email | 110 Hart Senate Office Building | junior | ||||||
43552 | 43552 | Nydia Velázquez V000081 | rep | NY | 2021-01-03 | 2023-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 | |||||||||
43559 | 43559 | Tim Walberg W000798 | rep | MI | 2021-01-03 | 2023-01-03 | Republican | 7 | https://walberg.house.gov | 2266 Rayburn House Office Building Washington DC 20515-2207 | 202-225-6276 | 2266 Rayburn House Office Building | http://walberg.house.gov/news/rss.aspx | ||||||||
43568 | 43568 | Debbie Wasserman Schultz W000797 | rep | FL | 2021-01-03 | 2023-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 | ||||||||
43584 | 43584 | Maxine Waters W000187 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 43 | https://waters.house.gov | 2221 Rayburn House Office Building Washington DC 20515-0543 | 202-225-2201 | 2221 Rayburn House Office Building | http://waters.house.gov/news/rss.aspx | ||||||||
43590 | 43590 | Daniel Webster W000806 | rep | FL | 2021-01-03 | 2023-01-03 | Republican | 11 | https://webster.house.gov | 2184 Rayburn House Office Building Washington DC 20515-0911 | 202-225-1002 | 2184 Rayburn House Office Building | http://webster.house.gov/news/rss.aspx | ||||||||
43598 | 43598 | Peter Welch W000800 | rep | VT | 2021-01-03 | 2023-01-03 | Democrat | 0 | https://welch.house.gov | 2187 Rayburn House Office Building Washington DC 20515-4500 | 202-225-4115 | 2187 Rayburn House Office Building | http://www.welch.house.gov/index.php?format=feed&type=rss | ||||||||
43609 | 43609 | Joe Wilson W000795 | rep | SC | 2021-01-03 | 2023-01-03 | Republican | 2 | https://joewilson.house.gov | 1436 Longworth House Office Building Washington DC 20515-4002 | 202-225-2452 | 1436 Longworth House Office Building | http://joewilson.house.gov/news/rss.aspx | ||||||||
43615 | 43615 | Frederica Wilson W000808 | rep | FL | 2021-01-03 | 2023-01-03 | Democrat | 24 | https://wilson.house.gov | 2445 Rayburn House Office Building Washington DC 20515-0924 | 202-225-4506 | 2445 Rayburn House Office Building | http://wilson.house.gov/common/rss//index.cfm?rss=49 | ||||||||
43623 | 43623 | Robert Wittman W000804 | rep | VA | 2021-01-03 | 2023-01-03 | Republican | 1 | https://wittman.house.gov | 2055 Rayburn House Office Building Washington DC 20515-4601 | 202-225-4261 | 2055 Rayburn House Office Building | http://www.wittman.house.gov/index.php?format=feed&type=rss | ||||||||
43629 | 43629 | Steve Womack W000809 | rep | AR | 2021-01-03 | 2023-01-03 | Republican | 3 | https://womack.house.gov | 2412 Rayburn House Office Building Washington DC 20515-0403 | 202-225-4301 | 2412 Rayburn House Office Building | http://womack.house.gov/news/rss.aspx | ||||||||
43642 | 43642 | Ron Wyden W000779 | sen | OR | 2017-01-03 | 2023-01-03 | 3 | Democrat | https://www.wyden.senate.gov | 221 Dirksen Senate Office Building Washington DC 20510 | 202-224-5244 | 202-228-2717 | https://www.wyden.senate.gov/contact/ | 221 Dirksen Senate Office Building | senior | http://www.wyden.senate.gov/rss/feeds/?type=all& | |||||
43650 | 43650 | John Yarmuth Y000062 | rep | KY | 2021-01-03 | 2023-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 | |||||||||
43654 | 43654 | Todd Young Y000064 | sen | IN | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.young.senate.gov | 185 Dirksen Senate Office Building Washington DC 20510 | 202-224-5623 | 202-226-6866 | https://www.young.senate.gov/contact | 185 Dirksen Senate Office Building | senior | ||||||
43660 | 43660 | Mark Amodei A000369 | rep | NV | 2021-01-03 | 2023-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 | ||||||||
43666 | 43666 | Suzanne Bonamici B001278 | rep | OR | 2021-01-03 | 2023-01-03 | Democrat | 1 | https://bonamici.house.gov | 2231 Rayburn House Office Building Washington DC 20515-3701 | 202-225-0855 | 2231 Rayburn House Office Building | http://bonamici.house.gov/rss.xml | ||||||||
43672 | 43672 | Suzan DelBene D000617 | rep | WA | 2021-01-03 | 2023-01-03 | Democrat | 1 | https://delbene.house.gov | 2330 Rayburn House Office Building Washington DC 20515-4701 | 202-225-6311 | 2330 Rayburn House Office Building | http://delbene.house.gov/rss.xml | ||||||||
43678 | 43678 | Thomas Massie M001184 | rep | KY | 2021-01-03 | 2023-01-03 | Republican | 4 | https://massie.house.gov | 2453 Rayburn House Office Building Washington DC 20515-1704 | 202-225-3465 | 2453 Rayburn House Office Building | http://massie.house.gov/rss.xml | ||||||||
43684 | 43684 | Donald Payne P000604 | rep | NJ | 2021-01-03 | 2023-01-03 | Democrat | 10 | https://payne.house.gov | 106 Cannon House Office Building Washington DC 20515-3010 | 202-225-3436 | 106 Cannon House Office Building | http://payne.house.gov/rss.xml | ||||||||
43687 | 43687 | Brian Schatz S001194 | sen | HI | 2017-01-03 | 2023-01-03 | 3 | Democrat | https://www.schatz.senate.gov | 722 Hart Senate Office Building Washington DC 20510 | 202-224-3934 | 202-228-1153 | https://www.schatz.senate.gov/contact | 722 Hart Senate Office Building | senior | ||||||
43694 | 43694 | Bill Foster F000454 | rep | IL | 2021-01-03 | 2023-01-03 | Democrat | 11 | https://foster.house.gov | 2366 Rayburn House Office Building Washington DC 20515-1311 | 202-225-3515 | 2366 Rayburn House Office Building | http://foster.house.gov/rss.xml | ||||||||
43700 | 43700 | Dina Titus T000468 | rep | NV | 2021-01-03 | 2023-01-03 | Democrat | 1 | https://titus.house.gov | 2464 Rayburn House Office Building Washington DC 20515-2801 | 202-225-5965 | 2464 Rayburn House Office Building | http://titus.house.gov/rss.xml | ||||||||
43712 | 43712 | Doug LaMalfa L000578 | rep | CA | 2021-01-03 | 2023-01-03 | Republican | 1 | https://lamalfa.house.gov | 408 Cannon House Office Building Washington DC 20515-0501 | 202-225-3076 | 408 Cannon House Office Building | http://lamalfa.house.gov/rss.xml | ||||||||
43717 | 43717 | Jared Huffman H001068 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 2 | https://huffman.house.gov | 1527 Longworth House Office Building Washington DC 20515-0502 | 202-225-5161 | 1527 Longworth House Office Building | http://huffman.house.gov/rss.xml | ||||||||
43722 | 43722 | Ami Bera B001287 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 7 | https://bera.house.gov | 172 Cannon House Office Building Washington DC 20515-0507 | 202-225-5716 | 172 Cannon House Office Building | http://bera.house.gov/rss.xml | ||||||||
43727 | 43727 | Eric Swalwell S001193 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 15 | https://swalwell.house.gov | 174 Cannon House Office Building Washington DC 20515-0515 | 202-225-5065 | 174 Cannon House Office Building | |||||||||
43732 | 43732 | Julia Brownley B001285 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 26 | https://juliabrownley.house.gov | 2262 Rayburn House Office Building Washington DC 20515-0526 | 202-225-5811 | 2262 Rayburn House Office Building | http://juliabrownley.house.gov/rss.xml | ||||||||
43737 | 43737 | Tony Cárdenas C001097 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 29 | https://cardenas.house.gov | 2438 Rayburn House Office Building Washington DC 20515-0529 | 202-225-6131 | 2438 Rayburn House Office Building | http://cardenas.house.gov/rss.xml | ||||||||
43742 | 43742 | Raul Ruiz R000599 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 36 | https://ruiz.house.gov | 2342 Rayburn House Office Building Washington DC 20515-0536 | 202-225-5330 | 2342 Rayburn House Office Building | http://ruiz.house.gov/rss.xml | ||||||||
43747 | 43747 | Mark Takano T000472 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 41 | https://takano.house.gov | 420 Cannon House Office Building Washington DC 20515-0541 | 202-225-2305 | 420 Cannon House Office Building | http://takano.house.gov/rss.xml | ||||||||
43752 | 43752 | Alan Lowenthal L000579 | rep | CA | 2021-01-03 | 2023-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 | ||||||||
43757 | 43757 | Juan Vargas V000130 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 51 | https://vargas.house.gov | 2244 Rayburn House Office Building Washington DC 20515-0551 | 202-225-8045 | 2244 Rayburn House Office Building | http://vargas.house.gov/rss.xml | ||||||||
43762 | 43762 | Scott Peters P000608 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 52 | https://scottpeters.house.gov | 1201 Longworth House Office Building Washington DC 20515-0552 | 202-225-0508 | 1201 Longworth House Office Building | http://scottpeters.house.gov/rss.xml | ||||||||
43767 | 43767 | Lois Frankel F000462 | rep | FL | 2021-01-03 | 2023-01-03 | Democrat | 21 | https://frankel.house.gov | 2305 Rayburn House Office Building Washington DC 20515-0921 | 202-225-9890 | 2305 Rayburn House Office Building | http://frankel.house.gov/rss.xml | ||||||||
43770 | 43770 | Tammy Duckworth D000622 | sen | IL | 2017-01-03 | 2023-01-03 | 3 | Democrat | https://www.duckworth.senate.gov | 524 Hart Senate Office Building Washington DC 20510 | 202-224-2854 | https://www.duckworth.senate.gov/content/contact-senator | 524 Hart Senate Office Building | junior | |||||||
43775 | 43775 | Rodney Davis D000619 | rep | IL | 2021-01-03 | 2023-01-03 | Republican | 13 | https://rodneydavis.house.gov | 2079 Rayburn House Office Building Washington DC 20515-1313 | 202-225-2371 | 2079 Rayburn House Office Building | http://rodneydavis.house.gov/rss.xml | ||||||||
43780 | 43780 | Cheri Bustos B001286 | rep | IL | 2021-01-03 | 2023-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 | ||||||||
43785 | 43785 | Garland Barr B001282 | rep | KY | 2021-01-03 | 2023-01-03 | Republican | 6 | https://barr.house.gov | 2430 Rayburn House Office Building Washington DC 20515-1706 | 202-225-4706 | 2430 Rayburn House Office Building | http://barr.house.gov/rss.xml | ||||||||
43794 | 43794 | Daniel Kildee K000380 | rep | MI | 2021-01-03 | 2023-01-03 | Democrat | 5 | https://dankildee.house.gov | 200 Cannon House Office Building Washington DC 20515-2205 | 202-225-3611 | 200 Cannon House Office Building | http://dankildee.house.gov/rss.xml | ||||||||
43799 | 43799 | Ann Wagner W000812 | rep | MO | 2021-01-03 | 2023-01-03 | Republican | 2 | https://wagner.house.gov | 2350 Rayburn House Office Building Washington DC 20515-2502 | 202-225-1621 | 2350 Rayburn House Office Building | http://wagner.house.gov/rss.xml | ||||||||
43807 | 43807 | Richard Hudson H001067 | rep | NC | 2021-01-03 | 2023-01-03 | Republican | 8 | https://hudson.house.gov | 2112 Rayburn House Office Building Washington DC 20515-3308 | 202-225-3715 | 2112 Rayburn House Office Building | http://hudson.house.gov/rss.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);