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 sorted by end-type
This data as json, copyable, CSV (advanced)
Suggested facets: state, party, rss_url, start (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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
41916 | 41916 | Robert Aderholt A000055 | rep | AL | 2021-01-03 | 2023-01-03 | Republican | 4 | https://aderholt.house.gov | 266 Cannon House Office Building Washington DC 20515-0104 | 202-225-4876 | 266 Cannon House Office Building | http://aderholt.house.gov/common/rss//index.cfm?rss=20 | ||||||||
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 | ||||||||
41934 | 41934 | Michael Bennet B001267 | sen | CO | 2017-01-03 | 2023-01-03 | 3 | Democrat | https://www.bennet.senate.gov/public | 261 Russell Senate Office Building Washington DC 20510 | 202-224-5852 | 202-228-5097 | https://www.bennet.senate.gov/public/index.cfm/contact | 261 Russell Senate Office Building | senior | http://www.bennet.senate.gov/rss/feeds/?type=news | |||||
41942 | 41942 | Gus Bilirakis B001257 | rep | FL | 2021-01-03 | 2023-01-03 | Republican | 12 | https://bilirakis.house.gov | 2354 Rayburn House Office Building Washington DC 20515-0912 | 202-225-5755 | 2354 Rayburn House Office Building | http://bilirakis.house.gov/index.php?format=feed&type=rss | ||||||||
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 | ||||||||
41982 | 41982 | Richard Blumenthal B001277 | sen | CT | 2017-01-03 | 2023-01-03 | 3 | Democrat | https://www.blumenthal.senate.gov | 706 Hart Senate Office Building Washington DC 20510 | 202-224-2823 | 202-224-9673 | https://www.blumenthal.senate.gov/contact/ | 706 Hart Senate Office Building | senior | http://www.blumenthal.senate.gov/rss/feeds/?type=all | |||||
41991 | 41991 | Roy Blunt B000575 | sen | MO | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.blunt.senate.gov | 260 Russell Senate Office Building Washington DC 20510 | 202-224-5721 | 202-224-8149 | https://www.blunt.senate.gov/public/index.cfm/contact-roy | 260 Russell Senate Office Building | senior | http://www.blunt.senate.gov/public/?a=rss.feed | |||||
41998 | 41998 | John Boozman B001236 | sen | AR | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.boozman.senate.gov/public | 141 Hart Senate Office Building Washington DC 20510 | 202-224-4843 | 202-228-1371 | https://www.boozman.senate.gov/public/index.cfm/contact | 141 Hart Senate Office Building | senior | http://www.boozman.senate.gov/public/index.cfm/rss/feed | |||||
42011 | 42011 | Kevin Brady B000755 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 8 | https://kevinbrady.house.gov | 1011 Longworth House Office Building Washington DC 20515-4308 | 202-225-4901 | 1011 Longworth House Office Building | http://kevinbrady.house.gov/common/rss/index.cfm?rss=49 | ||||||||
42017 | 42017 | Mo Brooks B001274 | rep | AL | 2021-01-03 | 2023-01-03 | Republican | 5 | https://brooks.house.gov | 2185 Rayburn House Office Building Washington DC 20515-0105 | 202-225-4801 | 2185 Rayburn House Office Building | http://brooks.house.gov/rss/press-releases.xml | ||||||||
42025 | 42025 | Vern Buchanan B001260 | rep | FL | 2021-01-03 | 2023-01-03 | Republican | 16 | https://buchanan.house.gov | 2110 Rayburn House Office Building Washington DC 20515-0916 | 202-225-5015 | 2110 Rayburn House Office Building | http://buchanan.house.gov/index.php?option=com_bca-rss-syndicator&feed_id=2 | ||||||||
42031 | 42031 | Larry Bucshon B001275 | rep | IN | 2021-01-03 | 2023-01-03 | Republican | 8 | https://bucshon.house.gov | 2313 Rayburn House Office Building Washington DC 20515-1408 | 202-225-4636 | 2313 Rayburn House Office Building | http://bucshon.house.gov/rss.xml | ||||||||
42041 | 42041 | Michael Burgess B001248 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 26 | https://burgess.house.gov | 2161 Rayburn House Office Building Washington DC 20515-4326 | 202-225-7772 | 2161 Rayburn House Office Building | http://burgess.house.gov/news/rss.aspx | ||||||||
42049 | 42049 | Richard Burr B001135 | sen | NC | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.burr.senate.gov | 217 Russell Senate Office Building Washington DC 20510 | 202-224-3154 | 202-228-2981 | https://www.burr.senate.gov/contact | 217 Russell Senate Office Building | senior | http://www.burr.senate.gov/public/index.cfm?fuseaction=rss.feed | |||||
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/ | ||||||||
42074 | 42074 | Ken Calvert C000059 | rep | CA | 2021-01-03 | 2023-01-03 | Republican | 42 | https://calvert.house.gov | 2205 Rayburn House Office Building Washington DC 20515-0542 | 202-225-1986 | 2205 Rayburn House Office Building | http://calvert.house.gov/news/rss.aspx | ||||||||
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 | ||||||||
42101 | 42101 | John Carter C001051 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 31 | https://carter.house.gov | 2208 Rayburn House Office Building Washington DC 20515-4331 | 202-225-3864 | 2208 Rayburn House Office Building | http://carter.house.gov/common/rss/?rss=40 | ||||||||
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 | ||||||||
42127 | 42127 | Steve Chabot C000266 | rep | OH | 2021-01-03 | 2023-01-03 | Republican | 1 | https://chabot.house.gov | 2408 Rayburn House Office Building Washington DC 20515-3501 | 202-225-2216 | 2408 Rayburn House Office Building | http://chabot.house.gov/common/rss/index.cfm?rss=49 | ||||||||
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 | ||||||||
42190 | 42190 | Tom Cole C001053 | rep | OK | 2021-01-03 | 2023-01-03 | Republican | 4 | https://cole.house.gov | 2207 Rayburn House Office Building Washington DC 20515-3604 | 202-225-6165 | 2207 Rayburn House Office Building | http://cole.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 | ||||||||
42237 | 42237 | Michael Crapo C000880 | sen | ID | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.crapo.senate.gov | 239 Dirksen Senate Office Building Washington DC 20510 | 202-224-6142 | 202-228-1375 | https://www.crapo.senate.gov/contact | 239 Dirksen Senate Office Building | senior | ||||||
42243 | 42243 | Eric Crawford C001087 | rep | AR | 2021-01-03 | 2023-01-03 | Republican | 1 | https://crawford.house.gov | 2422 Rayburn House Office Building Washington DC 20515-0401 | 202-225-4076 | 2422 Rayburn House Office Building | http://crawford.house.gov/news/rss.aspx | ||||||||
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 | ||||||||
42318 | 42318 | Scott DesJarlais D000616 | rep | TN | 2021-01-03 | 2023-01-03 | Republican | 4 | https://desjarlais.house.gov | 2304 Rayburn House Office Building Washington DC 20515-4204 | 202-225-6831 | 2304 Rayburn House Office Building | http://desjarlais.house.gov/news/rss.aspx | ||||||||
42328 | 42328 | Mario Diaz-Balart D000600 | rep | FL | 2021-01-03 | 2023-01-03 | Republican | 25 | https://mariodiazbalart.house.gov | 374 Cannon House Office Building Washington DC 20515-0925 | 202-225-4211 | 374 Cannon House Office Building | http://mariodiazbalart.house.gov/rss.xml | ||||||||
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 | ||||||||
42362 | 42362 | Jeff Duncan D000615 | rep | SC | 2021-01-03 | 2023-01-03 | Republican | 3 | https://jeffduncan.house.gov | 2229 Rayburn House Office Building Washington DC 20515-4003 | 202-225-5301 | 2229 Rayburn House Office Building | http://jeffduncan.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 | ||||||||
42383 | 42383 | Charles Fleischmann F000459 | rep | TN | 2021-01-03 | 2023-01-03 | Republican | 3 | https://fleischmann.house.gov | 462 Cannon House Office Building Washington DC 20515-4203 | 202-225-3271 | 462 Cannon House Office Building | http://fleischmann.house.gov/rss.xml | ||||||||
42392 | 42392 | Virginia Foxx F000450 | rep | NC | 2021-01-03 | 2023-01-03 | Republican | 5 | https://foxx.house.gov | 2462 Rayburn House Office Building Washington DC 20515-3305 | 202-225-2071 | 2462 Rayburn House Office Building | http://foxx.house.gov/common/rss/?rss=55 | ||||||||
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 | ||||||||
42405 | 42405 | Bob Gibbs G000563 | rep | OH | 2021-01-03 | 2023-01-03 | Republican | 7 | https://gibbs.house.gov | 2217 Rayburn House Office Building Washington DC 20515-3507 | 202-225-6265 | 2217 Rayburn House Office Building | http://gibbs.house.gov/rss.xml | ||||||||
42414 | 42414 | Louie Gohmert G000552 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 1 | https://gohmert.house.gov | 2269 Rayburn House Office Building Washington DC 20515-4301 | 202-225-3035 | 2269 Rayburn House Office Building | http://gohmert.house.gov/news/rss.aspx | ||||||||
42420 | 42420 | Paul Gosar G000565 | rep | AZ | 2021-01-03 | 2023-01-03 | Republican | 4 | https://gosar.house.gov | 2057 Rayburn House Office Building Washington DC 20515-0304 | 202-225-2315 | 2057 Rayburn House Office Building | http://gosar.house.gov/rss.xml | ||||||||
42433 | 42433 | Kay Granger G000377 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 12 | https://kaygranger.house.gov | 1026 Longworth House Office Building Washington DC 20515-4312 | 202-225-5071 | 1026 Longworth House Office Building | http://kaygranger.house.gov/rss.xml | ||||||||
42443 | 42443 | Charles Grassley G000386 | sen | IA | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.grassley.senate.gov | 135 Hart Senate Office Building Washington DC 20510 | 202-224-3744 | 202-224-6020 | https://www.grassley.senate.gov/contact | 135 Hart Senate Office Building | senior | http://grassley.senate.gov/customcf/rss_feed.cfm | |||||
42454 | 42454 | Sam Graves G000546 | rep | MO | 2021-01-03 | 2023-01-03 | Republican | 6 | https://graves.house.gov | 1135 Longworth House Office Building Washington DC 20515-2506 | 202-225-7041 | 1135 Longworth House Office Building | http://graves.house.gov/common/rss/index.cfm?rss=25 | ||||||||
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 | ||||||||
42469 | 42469 | H. Griffith G000568 | rep | VA | 2021-01-03 | 2023-01-03 | Republican | 9 | https://morgangriffith.house.gov | 2202 Rayburn House Office Building Washington DC 20515-4609 | 202-225-3861 | 2202 Rayburn House Office Building | http://morgangriffith.house.gov/news/rss.aspx | ||||||||
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 | ||||||||
42531 | 42531 | John Hoeven H001061 | sen | ND | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.hoeven.senate.gov | 338 Russell Senate Office Building Washington DC 20510 | 202-224-2551 | 202-224-7999 | https://www.hoeven.senate.gov/contact/email-the-senator/form | 338 Russell Senate Office Building | senior | http://www.hoeven.senate.gov/public/index.cfm/rss/feed | |||||
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 | ||||||||
42603 | 42603 | Ron Johnson J000293 | sen | WI | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.ronjohnson.senate.gov | 328 Hart Senate Office Building Washington DC 20510 | 202-224-5323 | 920-230-7262 | https://www.ronjohnson.senate.gov/public/index.cfm/email-the-senator | 328 Hart Senate Office Building | senior | http://www.ronjohnson.senate.gov/public/index.cfm/rss/feed | |||||
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 | ||||||||
42685 | 42685 | James Lankford L000575 | sen | OK | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.lankford.senate.gov | 316 Hart Senate Office Building Washington DC 20510 | 202-224-5754 | https://www.lankford.senate.gov/contact/email | 316 Hart Senate Office Building | junior | |||||||
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 | ||||||||
42724 | 42724 | Patrick Leahy L000174 | sen | VT | 2017-01-03 | 2023-01-03 | 3 | Democrat | https://www.leahy.senate.gov | 437 Russell Senate Office Building Washington DC 20510 | 202-224-4242 | 202-224-3479 | https://www.leahy.senate.gov/contact/ | 437 Russell Senate Office Building | senior | http://www.leahy.senate.gov/rss/feeds/press/ | |||||
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 | ||||||||
42739 | 42739 | Mike Lee L000577 | sen | UT | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.lee.senate.gov | 363 Russell Senate Office Building Washington DC 20510 | 202-224-5444 | https://www.lee.senate.gov/public/index.cfm/contact | 363 Russell Senate Office Building | senior | http://www.lee.senate.gov/public/index.cfm/rss/feed | ||||||
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 | ||||||||
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 | ||||||||
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 |
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);