legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
471 rows where "start" is on date 2021-01-03 sorted by party
This data as json, copyable, CSV (advanced)
Suggested facets: state, end, party, rss_url, end (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
41616 | 41616 | Cedric Richmond R000588 | rep | LA | 2021-01-03 | 2021-01-15 | 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 | ||||||||
41628 | 41628 | Marcia Fudge F000455 | rep | OH | 2021-01-03 | 2021-03-10 | 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 | ||||||||
41630 | 41630 | Debra Haaland H001080 | rep | NM | 2021-01-03 | 2021-03-16 | Democrat | 1 | https://haaland.house.gov | 1421 Longworth House Office Building Washington DC 20515-3101 | 202-225-6316 | 1421 Longworth House Office Building | |||||||||
41645 | 41645 | Alcee Hastings H000324 | rep | FL | 2021-01-03 | 2021-04-06 | Democrat | 20 | https://alceehastings.house.gov | 2365 Rayburn House Office Building Washington DC 20515-0920 | 202-225-1313 | 2365 Rayburn House Office Building | http://www.alceehastings.house.gov/news/rss.aspx | ||||||||
41702 | 41702 | Filemon Vela V000132 | rep | TX | 2021-01-03 | 2022-03-31 | 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 | ||||||||
41711 | 41711 | Antonio Delgado D000630 | rep | NY | 2021-01-03 | 2022-05-25 | Democrat | 19 | https://delgado.house.gov | 1007 Longworth House Office Building Washington DC 20515-3219 | 202-225-5614 | 1007 Longworth House Office Building | |||||||||
41719 | 41719 | Charlie Crist C001111 | rep | FL | 2021-01-03 | 2022-08-31 | Democrat | 13 | https://crist.house.gov | 215 Cannon House Office Building Washington DC 20515-0913 | 202-225-5961 | 215 Cannon House Office Building | |||||||||
41726 | 41726 | Theodore Deutch D000610 | rep | FL | 2021-01-03 | 2022-09-30 | Democrat | 22 | https://teddeutch.house.gov | 2323 Rayburn House Office Building Washington DC 20515-0922 | 202-225-3001 | 2323 Rayburn House Office Building | http://teddeutch.house.gov/news/rss.aspx | ||||||||
41729 | 41729 | A. McEachin M001200 | rep | VA | 2021-01-03 | 2022-11-28 | Democrat | 4 | https://mceachin.house.gov | 314 Cannon House Office Building Washington DC 20515-4604 | 202-225-6365 | 314 Cannon House Office Building | |||||||||
41847 | 41847 | Richard Durbin D000563 | sen | IL | 2021-01-03 | 2027-01-03 | 2 | Democrat | https://www.durbin.senate.gov | 711 Hart Senate Office Building Washington DC 20510 | 202-224-2152 | https://www.durbin.senate.gov/contact/ | 711 Hart Senate Office Building | senior | http://durbin.senate.gov/public/index.cfm/rss/feed | ||||||
41875 | 41875 | Jeff Merkley M001176 | sen | OR | 2021-01-03 | 2027-01-03 | 2 | Democrat | https://www.merkley.senate.gov | 531 Hart Senate Office Building Washington DC 20510 | 202-224-3753 | https://www.merkley.senate.gov/contact/ | 531 Hart Senate Office Building | junior | http://www.merkley.senate.gov/rss/ | ||||||
41883 | 41883 | John Reed R000122 | sen | RI | 2021-01-03 | 2027-01-03 | 2 | Democrat | https://www.reed.senate.gov | 728 Hart Senate Office Building Washington DC 20510 | 202-224-4642 | https://www.reed.senate.gov/contact/ | 728 Hart Senate Office Building | senior | https://www.reed.senate.gov//rss/feeds/?type=all | ||||||
41889 | 41889 | Jeanne Shaheen S001181 | sen | NH | 2021-01-03 | 2027-01-03 | 2 | Democrat | https://www.shaheen.senate.gov | 506 Hart Senate Office Building Washington DC 20510 | 202-224-2841 | https://www.shaheen.senate.gov/contact/contact-jeanne | 506 Hart Senate Office Building | senior | http://www.shaheen.senate.gov/rss/ | ||||||
41892 | 41892 | Mark Warner W000805 | sen | VA | 2021-01-03 | 2027-01-03 | 2 | Democrat | https://www.warner.senate.gov | 703 Hart Senate Office Building Washington DC 20510 | 202-224-2023 | https://www.warner.senate.gov/public/index.cfm?p=Contact | 703 Hart Senate Office Building | senior | http://www.warner.senate.gov/public/?a=rss.feed | ||||||
41900 | 41900 | Christopher Coons C001088 | sen | DE | 2021-01-03 | 2027-01-03 | 2 | Democrat | https://www.coons.senate.gov | 218 Russell Senate Office Building Washington DC 20510 | 202-224-5042 | https://www.coons.senate.gov/contact | 218 Russell Senate Office Building | junior | http://www.coons.senate.gov/rss/feeds/?type=all | ||||||
41931 | 41931 | Karen Bass B001270 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 37 | https://bass.house.gov | 2021 Rayburn House Office Building Washington DC 20515-0537 | 202-225-7084 | 2021 Rayburn House Office Building | http://bass.house.gov/rss.xml | ||||||||
41957 | 41957 | Sanford Bishop B000490 | rep | GA | 2021-01-03 | 2023-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 | ||||||||
41980 | 41980 | Earl Blumenauer B000574 | rep | OR | 2021-01-03 | 2023-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 | ||||||||
42059 | 42059 | George Butterfield B001251 | rep | NC | 2021-01-03 | 2023-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/ | ||||||||
42091 | 42091 | André Carson C001072 | rep | IN | 2021-01-03 | 2023-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 | ||||||||
42114 | 42114 | Kathy Castor C001066 | rep | FL | 2021-01-03 | 2023-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 | ||||||||
42134 | 42134 | Judy Chu C001080 | rep | CA | 2021-01-03 | 2023-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 | ||||||||
42140 | 42140 | David Cicilline C001084 | rep | RI | 2021-01-03 | 2023-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 | ||||||||
42148 | 42148 | Yvette Clarke C001067 | rep | NY | 2021-01-03 | 2023-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 | ||||||||
42157 | 42157 | Emanuel Cleaver C001061 | rep | MO | 2021-01-03 | 2023-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 | ||||||||
42172 | 42172 | James Clyburn C000537 | rep | SC | 2021-01-03 | 2023-01-03 | Democrat | 6 | https://clyburn.house.gov | 274 Cannon House Office Building Washington DC 20515-4006 | 202-225-3315 | 274 Cannon House Office Building | http://clyburn.house.gov/rss.xml | ||||||||
42180 | 42180 | Steve Cohen C001068 | rep | TN | 2021-01-03 | 2023-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 | ||||||||
42197 | 42197 | Gerald Connolly C001078 | rep | VA | 2021-01-03 | 2023-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 | ||||||||
42213 | 42213 | Jim Cooper C000754 | rep | TN | 2021-01-03 | 2023-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 | ||||||||
42222 | 42222 | Jim Costa C001059 | rep | CA | 2021-01-03 | 2023-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 | ||||||||
42230 | 42230 | Joe Courtney C001069 | rep | CT | 2021-01-03 | 2023-01-03 | Democrat | 2 | https://courtney.house.gov | 2449 Rayburn House Office Building Washington DC 20515-0702 | 202-225-2076 | 2449 Rayburn House Office Building | http://courtney.house.gov/index.php?format=feed&type=rss | ||||||||
42252 | 42252 | Henry Cuellar C001063 | rep | TX | 2021-01-03 | 2023-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 | ||||||||
42265 | 42265 | Danny Davis D000096 | rep | IL | 2021-01-03 | 2023-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 | ||||||||
42283 | 42283 | Peter DeFazio D000191 | rep | OR | 2021-01-03 | 2023-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 | ||||||||
42296 | 42296 | Diana DeGette D000197 | rep | CO | 2021-01-03 | 2023-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 | ||||||||
42312 | 42312 | Rosa DeLauro D000216 | rep | CT | 2021-01-03 | 2023-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 | ||||||||
42342 | 42342 | Lloyd Doggett D000399 | rep | TX | 2021-01-03 | 2023-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 | ||||||||
42356 | 42356 | Michael Doyle D000482 | rep | PA | 2021-01-03 | 2023-01-03 | Democrat | 18 | https://doyle.house.gov | 270 Cannon House Office Building Washington DC 20515-3818 | 202-225-2135 | 270 Cannon House Office Building | http://doyle.house.gov/rss.xml | ||||||||
42377 | 42377 | Anna Eshoo E000215 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 18 | https://eshoo.house.gov | 272 Cannon House Office Building Washington DC 20515-0518 | 202-225-8104 | 272 Cannon House Office Building | http://eshoo.house.gov/index.php?format=feed&type=rss | ||||||||
42399 | 42399 | John Garamendi G000559 | rep | CA | 2021-01-03 | 2023-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 | ||||||||
42463 | 42463 | Al Green G000553 | rep | TX | 2021-01-03 | 2023-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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | |||||||||
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 |
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);