legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
469 rows where "end" is on date 2021-01-03 sorted by state
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, district, rss_url
Link | rowid | legislator_id | type | state ▼ | start | end | class | party | district | how | party_affiliations | url | caucus | address | phone | fax | contact_form | office | state_rank | rss_url | end-type |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
41687 | 41687 | Don Young Y000033 | rep | AK | 2019-01-03 | 2021-01-03 | Republican | 0 | https://donyoung.house.gov | 2314 Rayburn House Office Building Washington DC 20515-0200 | 202-225-5765 | 2314 Rayburn House Office Building | http://donyoung.house.gov/news/rss.aspx | ||||||||
44072 | 44072 | Dan Sullivan S001198 | sen | AK | 2015-01-06 | 2021-01-03 | 2 | Republican | https://www.sullivan.senate.gov | 302 Hart Senate Office Building Washington DC 20510 | 202-224-3004 | https://www.sullivan.senate.gov/contact/email | 302 Hart Senate Office Building | junior | |||||||
41438 | 41438 | Martha Roby R000591 | rep | AL | 2019-01-03 | 2021-01-03 | Republican | 2 | https://roby.house.gov | 504 Cannon House Office Building Washington DC 20515-0102 | 202-225-2901 | 504 Cannon House Office Building | http://roby.house.gov/rss.xml | ||||||||
41577 | 41577 | Bradley Byrne B001289 | rep | AL | 2019-01-03 | 2021-01-03 | Republican | 1 | https://byrne.house.gov | 119 Cannon House Office Building Washington DC 20515-0101 | 202-225-4931 | 119 Cannon House Office Building | |||||||||
41594 | 41594 | Doug Jones J000300 | sen | AL | 2018-01-03 | 2021-01-03 | 2 | Democrat | https://www.jones.senate.gov | 330 Hart Senate Office Building Washington DC 20510 | 202-224-4124 | https://www.jones.senate.gov/content/contact-senator | 330 Hart Senate Office Building | junior | |||||||
41915 | 41915 | Robert Aderholt A000055 | rep | AL | 2019-01-03 | 2021-01-03 | Republican | 4 | https://aderholt.house.gov | 1203 Longworth House Office Building Washington DC 20515-0104 | 202-225-4876 | 1203 Longworth House Office Building | http://aderholt.house.gov/common/rss//index.cfm?rss=20 | ||||||||
42016 | 42016 | Mo Brooks B001274 | rep | AL | 2019-01-03 | 2021-01-03 | Republican | 5 | https://brooks.house.gov | 2246 Rayburn House Office Building Washington DC 20515-0105 | 202-225-4801 | 2246 Rayburn House Office Building | http://brooks.house.gov/rss/press-releases.xml | ||||||||
43179 | 43179 | Mike Rogers R000575 | rep | AL | 2019-01-03 | 2021-01-03 | Republican | 3 | https://mikerogers.house.gov | 2184 Rayburn House Office Building Washington DC 20515-0103 | 202-225-3261 | 2184 Rayburn House Office Building | http://mikerogers.house.gov/rss.xml | ||||||||
43344 | 43344 | Terri Sewell S001185 | rep | AL | 2019-01-03 | 2021-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 | ||||||||
43938 | 43938 | Gary Palmer P000609 | rep | AL | 2019-01-03 | 2021-01-03 | Republican | 6 | https://palmer.house.gov | 207 Cannon House Office Building Washington DC 20515-0106 | 202-225-4921 | 207 Cannon House Office Building | |||||||||
42242 | 42242 | Eric Crawford C001087 | rep | AR | 2019-01-03 | 2021-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 | ||||||||
43628 | 43628 | Steve Womack W000809 | rep | AR | 2019-01-03 | 2021-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 | ||||||||
43702 | 43702 | Tom Cotton C001095 | sen | AR | 2015-01-06 | 2021-01-03 | 2 | Republican | https://www.cotton.senate.gov | 326 Russell Senate Office Building Washington DC 20510 | 202-224-2353 | https://www.cotton.senate.gov/contact/contact-tom | 326 Russell Senate Office Building | junior | |||||||
43942 | 43942 | J. Hill H001072 | rep | AR | 2019-01-03 | 2021-01-03 | Republican | 2 | https://hill.house.gov | 1533 Longworth House Office Building Washington DC 20515-0402 | 202-225-2506 | 1533 Longworth House Office Building | |||||||||
43946 | 43946 | Bruce Westerman W000821 | rep | AR | 2019-01-03 | 2021-01-03 | Republican | 4 | https://westerman.house.gov | 209 Cannon House Office Building Washington DC 20515-0404 | 202-225-3772 | 209 Cannon House Office Building | |||||||||
44070 | 44070 | Aumua Amata Radewagen R000600 | rep | AS | 2019-01-03 | 2021-01-03 | Republican | 0 | https://radewagen.house.gov | 1339 Longworth House Office Building Washington DC 20515-5200 | 202-225-8577 | 1339 Longworth House Office Building | |||||||||
42419 | 42419 | Paul Gosar G000565 | rep | AZ | 2019-01-03 | 2021-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 | ||||||||
42478 | 42478 | Raúl Grijalva G000551 | rep | AZ | 2019-01-03 | 2021-01-03 | Democrat | 3 | https://grijalva.house.gov | 1511 Longworth House Office Building Washington DC 20515-0303 | 202-225-2435 | 1511 Longworth House Office Building | http://grijalva.house.gov/common/rss/?rss=13 | ||||||||
43303 | 43303 | David Schweikert S001183 | rep | AZ | 2019-01-03 | 2021-01-03 | Republican | 6 | https://schweikert.house.gov | 1526 Longworth House Office Building Washington DC 20515-0306 | 202-225-2190 | 1526 Longworth House Office Building | http://schweikert.house.gov/rss/press-releases.xml | ||||||||
43950 | 43950 | Ruben Gallego G000574 | rep | AZ | 2019-01-03 | 2021-01-03 | Democrat | 7 | https://rubengallego.house.gov | 1131 Longworth House Office Building Washington DC 20515-0307 | 202-225-4065 | 1131 Longworth House Office Building | |||||||||
44110 | 44110 | Tom O’Halleran O000171 | rep | AZ | 2019-01-03 | 2021-01-03 | Democrat | 1 | https://ohalleran.house.gov | 324 Cannon House Office Building Washington DC 20515-0301 | 202-225-3361 | 324 Cannon House Office Building | |||||||||
44113 | 44113 | Andy Biggs B001302 | rep | AZ | 2019-01-03 | 2021-01-03 | Republican | 5 | https://biggs.house.gov | 1318 Longworth House Office Building Washington DC 20515-0305 | 202-225-2635 | 1318 Longworth House Office Building | |||||||||
44252 | 44252 | Debbie Lesko L000589 | rep | AZ | 2019-01-03 | 2021-01-03 | Republican | 8 | https://lesko.house.gov | 1113 Longworth House Office Building Washington DC 20515-0308 | 202-225-4576 | 1113 Longworth House Office Building | |||||||||
44282 | 44282 | Ann Kirkpatrick K000368 | rep | AZ | 2019-01-03 | 2021-01-03 | Democrat | 2 | https://kirkpatrick.house.gov | 309 Cannon House Office Building Washington DC 20515-0302 | 202-225-2542 | 309 Cannon House Office Building | http://kirkpatrick.house.gov/rss.xml | ||||||||
44284 | 44284 | Greg Stanton S001211 | rep | AZ | 2019-01-03 | 2021-01-03 | Democrat | 9 | https://stanton.house.gov | 128 Cannon House Office Building Washington DC 20515-0309 | 202-225-9888 | 128 Cannon House Office Building | |||||||||
41326 | 41326 | Susan Davis D000598 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 53 | https://susandavis.house.gov | 1214 Longworth House Office Building Washington DC 20515-0553 | 202-225-2040 | 1214 Longworth House Office Building | |||||||||
41595 | 41595 | TJ Cox C001124 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 21 | https://cox.house.gov | 1728 Longworth House Office Building Washington DC 20515-0521 | 202-225-4695 | 1728 Longworth House Office Building | |||||||||
41596 | 41596 | Gilbert Cisneros C001123 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 39 | https://cisneros.house.gov | 431 Cannon House Office Building Washington DC 20515-0539 | 202-225-4111 | 431 Cannon House Office Building | |||||||||
41597 | 41597 | Harley Rouda R000616 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 48 | https://rouda.house.gov | 2300 Rayburn House Office Building Washington DC 20515-0548 | 202-225-2415 | 2300 Rayburn House Office Building | |||||||||
41660 | 41660 | Devin Nunes N000181 | rep | CA | 2019-01-03 | 2021-01-03 | Republican | 22 | https://nunes.house.gov | 1013 Longworth House Office Building Washington DC 20515-0522 | 202-225-2523 | 1013 Longworth House Office Building | http://nunes.house.gov/news/rss.aspx | ||||||||
41930 | 41930 | Karen Bass B001270 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 37 | https://bass.house.gov | 2059 Rayburn House Office Building Washington DC 20515-0537 | 202-225-7084 | 2059 Rayburn House Office Building | http://bass.house.gov/rss.xml | ||||||||
42073 | 42073 | Ken Calvert C000059 | rep | CA | 2019-01-03 | 2021-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 | ||||||||
42133 | 42133 | Judy Chu C001080 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 27 | https://chu.house.gov | 2423 Rayburn House Office Building Washington DC 20515-0527 | 202-225-5464 | 2423 Rayburn House Office Building | http://chu.house.gov/rss.xml | ||||||||
42221 | 42221 | Jim Costa C001059 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 16 | https://costa.house.gov | 2081 Rayburn House Office Building Washington DC 20515-0516 | 202-225-3341 | 2081 Rayburn House Office Building | http://costa.house.gov/index.php?format=feed&type=rss | ||||||||
42376 | 42376 | Anna Eshoo E000215 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 18 | https://eshoo.house.gov | 202 Cannon House Office Building Washington DC 20515-0518 | 202-225-8104 | 202 Cannon House Office Building | http://eshoo.house.gov/index.php?format=feed&type=rss | ||||||||
42398 | 42398 | John Garamendi G000559 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 3 | https://garamendi.house.gov | 2368 Rayburn House Office Building Washington DC 20515-0503 | 202-225-1880 | 2368 Rayburn House Office Building | http://garamendi.house.gov/rss.xml | ||||||||
42736 | 42736 | Barbara Lee L000551 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 13 | https://lee.house.gov | 2470 Rayburn House Office Building Washington DC 20515-0513 | 202-225-2661 | 2470 Rayburn House Office Building | http://lee.house.gov/rss.xml | ||||||||
42752 | 42752 | Zoe Lofgren L000397 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 19 | https://lofgren.house.gov | 1401 Longworth House Office Building Washington DC 20515-0519 | 202-225-3072 | 1401 Longworth House Office Building | http://lofgren.house.gov/index.php?format=feed&type=rss | ||||||||
42845 | 42845 | Doris Matsui M001163 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 6 | https://matsui.house.gov | 2311 Rayburn House Office Building Washington DC 20515-0506 | 202-225-7163 | 2311 Rayburn House Office Building | http://matsui.house.gov/index.php?format=feed&type=rss | ||||||||
42853 | 42853 | Kevin McCarthy M001165 | rep | CA | 2019-01-03 | 2021-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 | ||||||||
42869 | 42869 | Tom McClintock M001177 | rep | CA | 2019-01-03 | 2021-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 | ||||||||
42925 | 42925 | Jerry McNerney M001166 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 9 | https://mcnerney.house.gov | 2265 Rayburn House Office Building Washington DC 20515-0509 | 202-225-1947 | 2265 Rayburn House Office Building | http://mcnerney.house.gov/rss.xml | ||||||||
42998 | 42998 | Grace Napolitano N000179 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 32 | https://napolitano.house.gov | 1610 Longworth House Office Building Washington DC 20515-0532 | 202-225-5256 | 1610 Longworth House Office Building | http://napolitano.house.gov/rss.xml | ||||||||
43088 | 43088 | Nancy Pelosi P000197 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 12 | https://pelosi.house.gov | 1236 Longworth House Office Building Washington DC 20515-0512 | 202-225-4965 | 1236 Longworth House Office Building | http://pelosi.house.gov/atom.xml | ||||||||
43194 | 43194 | Lucille Roybal-Allard R000486 | rep | CA | 2019-01-03 | 2021-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 | ||||||||
43277 | 43277 | Adam Schiff S001150 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 28 | https://schiff.house.gov | 2269 Rayburn House Office Building Washington DC 20515-0528 | 202-225-4176 | 2269 Rayburn House Office Building | http://schiff.house.gov/common/rss/?rss=49 | ||||||||
43367 | 43367 | Brad Sherman S000344 | rep | CA | 2019-01-03 | 2021-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 | ||||||||
43438 | 43438 | Jackie Speier S001175 | rep | CA | 2019-01-03 | 2021-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 | ||||||||
43448 | 43448 | Linda Sánchez S001156 | rep | CA | 2019-01-03 | 2021-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 | ||||||||
43475 | 43475 | Mike Thompson T000460 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 5 | https://mikethompson.house.gov | 406 Cannon House Office Building Washington DC 20515-0505 | 202-225-3311 | 406 Cannon House Office Building | http://mikethompson.house.gov/news/rss.aspx | ||||||||
43583 | 43583 | Maxine Waters W000187 | rep | CA | 2019-01-03 | 2021-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 | ||||||||
43711 | 43711 | Doug LaMalfa L000578 | rep | CA | 2019-01-03 | 2021-01-03 | Republican | 1 | https://lamalfa.house.gov | 322 Cannon House Office Building Washington DC 20515-0501 | 202-225-3076 | 322 Cannon House Office Building | http://lamalfa.house.gov/rss.xml | ||||||||
43716 | 43716 | Jared Huffman H001068 | rep | CA | 2019-01-03 | 2021-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 | ||||||||
43721 | 43721 | Ami Bera B001287 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 7 | https://bera.house.gov | 1727 Longworth House Office Building Washington DC 20515-0507 | 202-225-5716 | 1727 Longworth House Office Building | http://bera.house.gov/rss.xml | ||||||||
43726 | 43726 | Eric Swalwell S001193 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 15 | https://swalwell.house.gov | 407 Cannon House Office Building Washington DC 20515-0515 | 202-225-5065 | 407 Cannon House Office Building | |||||||||
43731 | 43731 | Julia Brownley B001285 | rep | CA | 2019-01-03 | 2021-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 | ||||||||
43736 | 43736 | Tony Cárdenas C001097 | rep | CA | 2019-01-03 | 2021-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 | ||||||||
43741 | 43741 | Raul Ruiz R000599 | rep | CA | 2019-01-03 | 2021-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 | ||||||||
43746 | 43746 | Mark Takano T000472 | rep | CA | 2019-01-03 | 2021-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 | ||||||||
43751 | 43751 | Alan Lowenthal L000579 | rep | CA | 2019-01-03 | 2021-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 | ||||||||
43756 | 43756 | Juan Vargas V000130 | rep | CA | 2019-01-03 | 2021-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 | ||||||||
43761 | 43761 | Scott Peters P000608 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 52 | https://scottpeters.house.gov | 2338 Rayburn House Office Building Washington DC 20515-0552 | 202-225-0508 | 2338 Rayburn House Office Building | http://scottpeters.house.gov/rss.xml | ||||||||
43954 | 43954 | Mark DeSaulnier D000623 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 11 | https://desaulnier.house.gov | 503 Cannon House Office Building Washington DC 20515-0511 | 202-225-2095 | 503 Cannon House Office Building | |||||||||
43958 | 43958 | Pete Aguilar A000371 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 31 | https://aguilar.house.gov | 109 Cannon House Office Building Washington DC 20515-0531 | 202-225-3201 | 109 Cannon House Office Building | |||||||||
43962 | 43962 | Ted Lieu L000582 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 33 | https://lieu.house.gov | 403 Cannon House Office Building Washington DC 20515-0533 | 202-225-3976 | 403 Cannon House Office Building | |||||||||
43966 | 43966 | Norma Torres T000474 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 35 | https://torres.house.gov | 2444 Rayburn House Office Building Washington DC 20515-0535 | 202-225-6161 | 2444 Rayburn House Office Building | |||||||||
44116 | 44116 | Ro Khanna K000389 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 17 | https://khanna.house.gov | 221 Cannon House Office Building Washington DC 20515-0517 | 202-225-2631 | 221 Cannon House Office Building | |||||||||
44119 | 44119 | Jimmy Panetta P000613 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 20 | https://panetta.house.gov | 212 Cannon House Office Building Washington DC 20515-0520 | 202-225-2861 | 212 Cannon House Office Building | |||||||||
44122 | 44122 | Salud Carbajal C001112 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 24 | https://carbajal.house.gov | 1431 Longworth House Office Building Washington DC 20515-0524 | 202-225-3601 | 1431 Longworth House Office Building | |||||||||
44125 | 44125 | Nanette Barragán B001300 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 44 | https://barragan.house.gov | 1030 Longworth House Office Building Washington DC 20515-0544 | 202-225-8220 | 1030 Longworth House Office Building | |||||||||
44128 | 44128 | J. Correa C001110 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 46 | https://correa.house.gov | 1039 Longworth House Office Building Washington DC 20515-0546 | 202-225-2965 | 1039 Longworth House Office Building | |||||||||
44237 | 44237 | Jimmy Gomez G000585 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 34 | https://gomez.house.gov | 1530 Longworth House Office Building Washington DC 20515-0534 | 202-225-6235 | 1530 Longworth House Office Building | |||||||||
44286 | 44286 | Josh Harder H001090 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 10 | https://harder.house.gov | 131 Cannon House Office Building Washington DC 20515-0510 | 202-225-4540 | 131 Cannon House Office Building | |||||||||
44288 | 44288 | Katie Porter P000618 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 45 | https://porter.house.gov | 1117 Longworth House Office Building Washington DC 20515-0545 | 202-225-5611 | 1117 Longworth House Office Building | |||||||||
44290 | 44290 | Mike Levin L000593 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 49 | https://mikelevin.house.gov | 1626 Longworth House Office Building Washington DC 20515-0549 | 202-225-3906 | 1626 Longworth House Office Building | |||||||||
44435 | 44435 | Mike Garcia G000061 | rep | CA | 2020-05-19 | 2021-01-03 | Republican | 25 | 1130 Longworth House Office Building Washington DC 20515-0525 | 202-225-1956 | 1130 Longworth House Office Building | ||||||||||
41350 | 41350 | Cory Gardner G000562 | sen | CO | 2015-01-06 | 2021-01-03 | 2 | Republican | https://www.gardner.senate.gov | 354 Russell Senate Office Building Washington DC 20510 | 202-224-5941 | 202-225-5870 | https://www.gardner.senate.gov/contact-cory/email-cory | 354 Russell Senate Office Building | junior | ||||||
41511 | 41511 | Scott Tipton T000470 | rep | CO | 2019-01-03 | 2021-01-03 | Republican | 3 | https://tipton.house.gov | 218 Cannon House Office Building Washington DC 20515-0603 | 202-225-4761 | 218 Cannon House Office Building | http://tipton.house.gov/rss.xml | ||||||||
42295 | 42295 | Diana DeGette D000197 | rep | CO | 2019-01-03 | 2021-01-03 | Democrat | 1 | https://degette.house.gov | 2111 Rayburn House Office Building Washington DC 20515-0601 | 202-225-4431 | 2111 Rayburn House Office Building | http://degette.house.gov/index.php?option=com_ninjarsssyndicator&feed_id=1&format=raw | ||||||||
42669 | 42669 | Doug Lamborn L000564 | rep | CO | 2019-01-03 | 2021-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/ | ||||||||
43096 | 43096 | Ed Perlmutter P000593 | rep | CO | 2019-01-03 | 2021-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 | ||||||||
43970 | 43970 | Ken Buck B001297 | rep | CO | 2019-01-03 | 2021-01-03 | Republican | 4 | https://buck.house.gov | 2455 Rayburn House Office Building Washington DC 20515-0604 | 202-225-4676 | 2455 Rayburn House Office Building | |||||||||
44292 | 44292 | Joe Neguse N000191 | rep | CO | 2019-01-03 | 2021-01-03 | Democrat | 2 | https://neguse.house.gov | 1419 Longworth House Office Building Washington DC 20515-0602 | 202-225-2161 | 1419 Longworth House Office Building | |||||||||
44294 | 44294 | Jason Crow C001121 | rep | CO | 2019-01-03 | 2021-01-03 | Democrat | 6 | https://crow.house.gov | 1229 Longworth House Office Building Washington DC 20515-0606 | 202-225-7882 | 1229 Longworth House Office Building | |||||||||
42229 | 42229 | Joe Courtney C001069 | rep | CT | 2019-01-03 | 2021-01-03 | Democrat | 2 | https://courtney.house.gov | 2332 Rayburn House Office Building Washington DC 20515-0702 | 202-225-2076 | 2332 Rayburn House Office Building | http://courtney.house.gov/index.php?format=feed&type=rss | ||||||||
42311 | 42311 | Rosa DeLauro D000216 | rep | CT | 2019-01-03 | 2021-01-03 | Democrat | 3 | https://delauro.house.gov | 2413 Rayburn House Office Building Washington DC 20515-0703 | 202-225-3661 | 2413 Rayburn House Office Building | http://delauro.house.gov/index.php?format=feed&type=rss | ||||||||
42523 | 42523 | James Himes H001047 | rep | CT | 2019-01-03 | 2021-01-03 | Democrat | 4 | https://himes.house.gov | 1227 Longworth House Office Building Washington DC 20515-0704 | 202-225-5541 | 1227 Longworth House Office Building | http://himes.house.gov/rss.xml | ||||||||
42707 | 42707 | John Larson L000557 | rep | CT | 2019-01-03 | 2021-01-03 | Democrat | 1 | https://larson.house.gov | 1501 Longworth House Office Building Washington DC 20515-0701 | 202-225-2265 | 1501 Longworth House Office Building | http://www.larson.house.gov/index.php?format=feed&type=rss | ||||||||
44296 | 44296 | Jahana Hayes H001081 | rep | CT | 2019-01-03 | 2021-01-03 | Democrat | 5 | https://hayes.house.gov | 1415 Longworth House Office Building Washington DC 20515-0705 | 202-225-4476 | 1415 Longworth House Office Building | |||||||||
43031 | 43031 | Eleanor Norton N000147 | rep | DC | 2019-01-03 | 2021-01-03 | Democrat | 0 | https://norton.house.gov | 2136 Rayburn House Office Building Washington DC 20515-5101 | 202-225-8050 | 2136 Rayburn House Office Building | http://norton.house.gov/index.php?format=feed&type=rss | ||||||||
41899 | 41899 | Christopher Coons C001088 | sen | DE | 2015-01-06 | 2021-01-03 | 2 | Democrat | https://www.coons.senate.gov | 218 Russell Senate Office Building Washington DC 20510 | 202-224-5042 | 202-228-3075 | https://www.coons.senate.gov/contact | 218 Russell Senate Office Building | junior | http://www.coons.senate.gov/rss/feeds/?type=all | |||||
44131 | 44131 | Lisa Blunt Rochester B001303 | rep | DE | 2019-01-03 | 2021-01-03 | Democrat | 0 | https://bluntrochester.house.gov | 1519 Longworth House Office Building Washington DC 20515-0800 | 202-225-4165 | 1519 Longworth House Office Building | |||||||||
41549 | 41549 | Ted Yoho Y000065 | rep | FL | 2019-01-03 | 2021-01-03 | Republican | 3 | https://yoho.house.gov | 1730 Longworth House Office Building Washington DC 20515-0903 | 202-225-5744 | 1730 Longworth House Office Building | http://yoho.house.gov/rss.xml | ||||||||
41589 | 41589 | Francis Rooney R000607 | rep | FL | 2019-01-03 | 2021-01-03 | Republican | 19 | https://francisrooney.house.gov | 120 Cannon House Office Building Washington DC 20515-0919 | 202-225-2536 | 120 Cannon House Office Building | |||||||||
41598 | 41598 | Ross Spano S001210 | rep | FL | 2019-01-03 | 2021-01-03 | Republican | 15 | https://spano.house.gov | 224 Cannon House Office Building Washington DC 20515-0915 | 202-225-1252 | 224 Cannon House Office Building | |||||||||
41599 | 41599 | Debbie Mucarsel-Powell M001207 | rep | FL | 2019-01-03 | 2021-01-03 | Democrat | 26 | https://mucarsel-powell.house.gov | 114 Cannon House Office Building Washington DC 20515-0926 | 202-225-2778 | 114 Cannon House Office Building | |||||||||
41600 | 41600 | Donna Shalala S001206 | rep | FL | 2019-01-03 | 2021-01-03 | Democrat | 27 | https://shalala.house.gov | 1320 Longworth House Office Building Washington DC 20515-0927 | 202-225-3931 | 1320 Longworth House Office Building | |||||||||
41644 | 41644 | Alcee Hastings H000324 | rep | FL | 2019-01-03 | 2021-01-03 | Democrat | 20 | https://alceehastings.house.gov | 2353 Rayburn House Office Building Washington DC 20515-0920 | 202-225-1313 | 2353 Rayburn House Office Building | http://www.alceehastings.house.gov/news/rss.aspx | ||||||||
41718 | 41718 | Charlie Crist C001111 | rep | FL | 2019-01-03 | 2021-01-03 | Democrat | 13 | https://crist.house.gov | 215 Cannon House Office Building Washington DC 20515-0913 | 202-225-5961 | 215 Cannon House Office Building | |||||||||
41725 | 41725 | Theodore Deutch D000610 | rep | FL | 2019-01-03 | 2021-01-03 | Democrat | 22 | https://teddeutch.house.gov | 2447 Rayburn House Office Building Washington DC 20515-0922 | 202-225-3001 | 2447 Rayburn House Office Building | http://teddeutch.house.gov/news/rss.aspx |
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);