legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
44,551 rows sorted by start descending
This data as json, copyable, CSV (advanced)
end (date) >30 ✖
- 1919-03-03 506
- 1931-03-03 502
- 1921-03-03 499
- 1933-03-03 499
- 1923-03-03 498
- 1941-01-03 498
- 1915-03-03 494
- 1925-03-03 493
- 1945-01-03 493
- 1939-01-03 492
- 1929-03-03 489
- 1963-01-03 489
- 1943-01-03 488
- 1947-01-03 488
- 1935-01-03 486
- 1949-01-03 486
- 1953-01-03 486
- 1917-03-03 485
- 1937-01-03 485
- 1955-01-03 485
- 1927-03-04 484
- 1961-01-03 483
- 1971-01-03 483
- 1951-01-03 482
- 1965-01-03 482
- 1983-01-03 481
- 1959-01-03 480
- 1977-01-03 480
- 1967-01-03 479
- 1975-01-03 479
- …
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
42479 | 42479 | Raúl Grijalva G000551 | rep | AZ | 2021-01-03 | 2023-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 | ||||||||
42486 | 42486 | Brett Guthrie G000558 | rep | KY | 2021-01-03 | 2023-01-03 | Republican | 2 | https://guthrie.house.gov | 2434 Rayburn House Office Building Washington DC 20515-1702 | 202-225-3501 | 2434 Rayburn House Office Building | http://guthrie.house.gov/common/rss/?rss=24 | ||||||||
42492 | 42492 | Andy Harris H001052 | rep | MD | 2021-01-03 | 2023-01-03 | Republican | 1 | https://harris.house.gov | 2334 Rayburn House Office Building Washington DC 20515-2001 | 202-225-5311 | 2334 Rayburn House Office Building | http://harris.house.gov/rss.xml | ||||||||
42498 | 42498 | Vicky Hartzler H001053 | rep | MO | 2021-01-03 | 2023-01-03 | Republican | 4 | https://hartzler.house.gov | 2235 Rayburn House Office Building Washington DC 20515-2504 | 202-225-2876 | 2235 Rayburn House Office Building | http://hartzler.house.gov/rss.xml | ||||||||
42508 | 42508 | Jaime Herrera Beutler H001056 | rep | WA | 2021-01-03 | 2023-01-03 | Republican | 3 | https://jhb.house.gov | 2352 Rayburn House Office Building Washington DC 20515-4703 | 202-225-3536 | 2352 Rayburn House Office Building | http://herrerabeutler.house.gov/news/rss.aspx | ||||||||
42517 | 42517 | Brian Higgins H001038 | rep | NY | 2021-01-03 | 2023-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 | ||||||||
42524 | 42524 | James Himes H001047 | rep | CT | 2021-01-03 | 2023-01-03 | Democrat | 4 | https://himes.house.gov | 2137 Rayburn House Office Building Washington DC 20515-0704 | 202-225-5541 | 2137 Rayburn House Office Building | http://himes.house.gov/rss.xml | ||||||||
42552 | 42552 | Steny Hoyer H000874 | rep | MD | 2021-01-03 | 2023-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 | ||||||||
42558 | 42558 | Bill Huizenga H001058 | rep | MI | 2021-01-03 | 2023-01-03 | Republican | 2 | https://huizenga.house.gov | 2232 Rayburn House Office Building Washington DC 20515-2202 | 202-225-4401 | 2232 Rayburn House Office Building | http://huizenga.house.gov/news/rss.aspx | ||||||||
42572 | 42572 | Sheila Jackson Lee J000032 | rep | TX | 2021-01-03 | 2023-01-03 | Democrat | 18 | https://jacksonlee.house.gov | 2426 Rayburn House Office Building Washington DC 20515-4318 | 202-225-3816 | 2426 Rayburn House Office Building | http://jacksonlee.house.gov/news/rss.aspx | ||||||||
42578 | 42578 | Bill Johnson J000292 | rep | OH | 2021-01-03 | 2023-01-03 | Republican | 6 | https://billjohnson.house.gov | 2336 Rayburn House Office Building Washington DC 20515-3506 | 202-225-5705 | 2336 Rayburn House Office Building | http://billjohnson.house.gov/constituentservices/opendoorsschedule.htm | ||||||||
42593 | 42593 | Eddie Johnson J000126 | rep | TX | 2021-01-03 | 2023-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 | ||||||||
42601 | 42601 | Henry Johnson J000288 | rep | GA | 2021-01-03 | 2023-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 | ||||||||
42611 | 42611 | Jim Jordan J000289 | rep | OH | 2021-01-03 | 2023-01-03 | Republican | 4 | https://jordan.house.gov | 2056 Rayburn House Office Building Washington DC 20515-3504 | 202-225-2676 | 2056 Rayburn House Office Building | http://jordan.house.gov/news/rss.aspx | ||||||||
42631 | 42631 | Marcy Kaptur K000009 | rep | OH | 2021-01-03 | 2023-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 | ||||||||
42637 | 42637 | William Keating K000375 | rep | MA | 2021-01-03 | 2023-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 | ||||||||
42643 | 42643 | Mike Kelly K000376 | rep | PA | 2021-01-03 | 2023-01-03 | Republican | 16 | https://kelly.house.gov | 1707 Longworth House Office Building Washington DC 20515-3816 | 202-225-5406 | 1707 Longworth House Office Building | http://kelly.house.gov/rss.xml | ||||||||
42656 | 42656 | Ron Kind K000188 | rep | WI | 2021-01-03 | 2023-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 | ||||||||
42662 | 42662 | Adam Kinzinger K000378 | rep | IL | 2021-01-03 | 2023-01-03 | Republican | 16 | https://kinzinger.house.gov | 2245 Rayburn House Office Building Washington DC 20515-1316 | 202-225-3635 | 2245 Rayburn House Office Building | http://kinzinger.house.gov/common/rss//index.cfm?rss=49 | ||||||||
42670 | 42670 | Doug Lamborn L000564 | rep | CO | 2021-01-03 | 2023-01-03 | Republican | 5 | https://lamborn.house.gov | 2371 Rayburn House Office Building Washington DC 20515-0605 | 202-225-4422 | 2371 Rayburn House Office Building | http://lamborn.house.gov/news-rss-graphic/news-rss-graphic/ | ||||||||
42681 | 42681 | James Langevin L000559 | rep | RI | 2021-01-03 | 2023-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 | ||||||||
42696 | 42696 | Rick Larsen L000560 | rep | WA | 2021-01-03 | 2023-01-03 | Democrat | 2 | https://larsen.house.gov | 2163 Rayburn House Office Building Washington DC 20515-4702 | 202-225-2605 | 2163 Rayburn House Office Building | http://larsen.house.gov/rss.xml | ||||||||
42708 | 42708 | John Larson L000557 | rep | CT | 2021-01-03 | 2023-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 | ||||||||
42716 | 42716 | Robert Latta L000566 | rep | OH | 2021-01-03 | 2023-01-03 | Republican | 5 | https://latta.house.gov | 2467 Rayburn House Office Building Washington DC 20515-3505 | 202-225-6405 | 2467 Rayburn House Office Building | http://latta.house.gov/news/rss.aspx | ||||||||
42737 | 42737 | Barbara Lee L000551 | rep | CA | 2021-01-03 | 2023-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 | ||||||||
42753 | 42753 | Zoe Lofgren L000397 | rep | CA | 2021-01-03 | 2023-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 | ||||||||
42759 | 42759 | Billy Long L000576 | rep | MO | 2021-01-03 | 2023-01-03 | Republican | 7 | https://long.house.gov | 2454 Rayburn House Office Building Washington DC 20515-2507 | 202-225-6536 | 2454 Rayburn House Office Building | http://long.house.gov/common/rss//index.cfm?rss=49 | ||||||||
42774 | 42774 | Frank Lucas L000491 | rep | OK | 2021-01-03 | 2023-01-03 | Republican | 3 | https://lucas.house.gov | 2405 Rayburn House Office Building Washington DC 20515-3603 | 202-225-5565 | 2405 Rayburn House Office Building | http://lucas.house.gov/rss.xml | ||||||||
42781 | 42781 | Blaine Luetkemeyer L000569 | rep | MO | 2021-01-03 | 2023-01-03 | Republican | 3 | https://luetkemeyer.house.gov | 2230 Rayburn House Office Building Washington DC 20515-2503 | 202-225-2956 | 2230 Rayburn House Office Building | http://luetkemeyer.house.gov/news/rss.aspx | ||||||||
42788 | 42788 | Ben Luján L000570 | sen | NM | 2021-01-03 | 2027-01-03 | 2 | Democrat | https://www.lujan.senate.gov | 498 Russell Senate Office Building Washington DC 20510 | 202-224-6621 | https://www.lujan.senate.gov/contact/ | 498 Russell Senate Office Building | junior | |||||||
42799 | 42799 | Stephen Lynch L000562 | rep | MA | 2021-01-03 | 2023-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 | ||||||||
42814 | 42814 | Carolyn Maloney M000087 | rep | NY | 2021-01-03 | 2023-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 | ||||||||
42837 | 42837 | Edward Markey M000133 | sen | MA | 2021-01-03 | 2027-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 | |||||||
42846 | 42846 | Doris Matsui M001163 | rep | CA | 2021-01-03 | 2023-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 | ||||||||
42854 | 42854 | Kevin McCarthy M001165 | rep | CA | 2021-01-03 | 2023-01-03 | Republican | 23 | https://kevinmccarthy.house.gov | 2468 Rayburn House Office Building Washington DC 20515-0523 | 202-225-2915 | 2468 Rayburn House Office Building | http://kevinmccarthy.house.gov/index.php?format=feed&type=rss | ||||||||
42863 | 42863 | Michael McCaul M001157 | rep | TX | 2021-01-03 | 2023-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 | |||||||||
42870 | 42870 | Tom McClintock M001177 | rep | CA | 2021-01-03 | 2023-01-03 | Republican | 4 | https://mcclintock.house.gov | 2312 Rayburn House Office Building Washington DC 20515-0504 | 202-225-2511 | 2312 Rayburn House Office Building | http://mcclintock.house.gov/atom.xml | ||||||||
42881 | 42881 | Betty McCollum M001143 | rep | MN | 2021-01-03 | 2023-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 | ||||||||
42894 | 42894 | James McGovern M000312 | rep | MA | 2021-01-03 | 2023-01-03 | Democrat | 2 | https://mcgovern.house.gov | 370 Cannon House Office Building Washington DC 20515-2102 | 202-225-6101 | 370 Cannon House Office Building | http://mcgovern.house.gov/common/rss/?rss=15 | ||||||||
42903 | 42903 | Patrick McHenry M001156 | rep | NC | 2021-01-03 | 2023-01-03 | Republican | 10 | https://mchenry.house.gov | 2004 Rayburn House Office Building Washington DC 20515-3310 | 202-225-2576 | 2004 Rayburn House Office Building | http://mchenry.house.gov/news/rss.aspx | ||||||||
42909 | 42909 | David McKinley M001180 | rep | WV | 2021-01-03 | 2023-01-03 | Republican | 1 | https://mckinley.house.gov | 2239 Rayburn House Office Building Washington DC 20515-4801 | 202-225-4172 | 2239 Rayburn House Office Building | http://mckinley.house.gov/common/rss//index.cfm?rss=49 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
43102 | 43102 | Gary Peters P000595 | sen | MI | 2021-01-03 | 2027-01-03 | 2 | Democrat | https://www.peters.senate.gov | 724 Hart Senate Office Building Washington DC 20510 | 202-224-6221 | https://www.peters.senate.gov/contact/email-gary | 724 Hart Senate Office Building | junior | |||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 |
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);