legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
2,177 rows where state = "CA" sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: how, state_rank, start (date), end (date)
party 7 ✖
- Democrat 1,210
- Republican 954
- Independent 3
- Populist 3
- Progressive 3
- Prohibitionist 3
- Democratic and Union Labor 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
44544 | 44544 | Connie Conway C001128 | rep | CA | 2022-06-07 | 2023-01-03 | Republican | 22 | 1013 Longworth House Office Building Washington DC 20515-0522 | 202-225-2523 | 1013 Longworth House Office Building | ||||||||||
44532 | 44532 | Alejandro Padilla P000145 | sen | CA | 2022-11-09 | 2023-01-03 | 3 | Democrat | special-election | https://www.padilla.senate.gov | 112 Hart Senate Office Building Washington DC 20510 | 202-224-3553 | https://www.padilla.senate.gov/contact/ | 112 Hart Senate Office Building | junior | ||||||
44531 | 44531 | Alejandro Padilla P000145 | sen | CA | 2021-01-20 | 2022-11-08 | 3 | Democrat | appointment | https://www.padilla.senate.gov | 112 Hart Senate Office Building Washington DC 20510 | 202-224-3553 | https://www.padilla.senate.gov/contact/ | 112 Hart Senate Office Building | junior | ||||||
44479 | 44479 | Sara Jacobs J000305 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 53 | https://sarajacobs.house.gov | 1232 Longworth House Office Building Washington DC 20515-0553 | 202-225-2040 | 1232 Longworth House Office Building | |||||||||
44478 | 44478 | Michelle Steel S001135 | rep | CA | 2021-01-03 | 2023-01-03 | Republican | 48 | https://steel.house.gov | 1113 Longworth House Office Building Washington DC 20515-0548 | 202-225-2415 | 1113 Longworth House Office Building | |||||||||
44477 | 44477 | Young Kim K000397 | rep | CA | 2021-01-03 | 2023-01-03 | Republican | 39 | https://youngkim.house.gov | 1306 Longworth House Office Building Washington DC 20515-0539 | 202-225-4111 | 1306 Longworth House Office Building | |||||||||
44476 | 44476 | Jay Obernolte O000019 | rep | CA | 2021-01-03 | 2023-01-03 | Republican | 8 | https://obernolte.house.gov | 1029 Longworth House Office Building Washington DC 20515-0508 | 202-225-5861 | 1029 Longworth House Office Building | |||||||||
44470 | 44470 | David Valadao V000129 | rep | CA | 2021-01-03 | 2023-01-03 | Republican | 21 | https://valadao.house.gov | 1728 Longworth House Office Building Washington DC 20515-0521 | 202-225-4695 | 1728 Longworth House Office Building | http://valadao.house.gov/rss.xml | ||||||||
44469 | 44469 | David Valadao V000129 | rep | CA | 2017-01-03 | 2019-01-03 | Republican | 21 | https://valadao.house.gov | 1728 Longworth House Office Building; Washington DC 20515-0521 | 202-225-4695 | 202-226-3196 | 1728 Longworth House Office Building | http://valadao.house.gov/rss.xml | |||||||
44468 | 44468 | David Valadao V000129 | rep | CA | 2015-01-06 | 2017-01-03 | Republican | 21 | http://valadao.house.gov | 1004 Longworth HOB; Washington DC 20515-0521 | 202-225-4695 | 202-226-3196 | http://valadao.house.gov/contact/ | 1004 Longworth House Office Building | http://valadao.house.gov/rss.xml | ||||||
44467 | 44467 | David Valadao V000129 | rep | CA | 2013-01-03 | 2015-01-03 | Republican | 21 | http://valadao.house.gov | 1004 Longworth HOB; Washington DC 20515-0521 | 202-225-4695 | 202-226-3196 | http://valadao.house.gov/contact/ | 1004 Longworth House Office Building | http://valadao.house.gov/rss.xml | ||||||
44454 | 44454 | Darrell Issa I000056 | rep | CA | 2021-01-03 | 2023-01-03 | Republican | 50 | https://issa.house.gov | 2300 Rayburn House Office Building Washington DC 20515-0550 | 202-225-5672 | 2300 Rayburn House Office Building | http://issa.house.gov/feed/ | ||||||||
44453 | 44453 | Darrell Issa I000056 | rep | CA | 2017-01-03 | 2019-01-03 | Republican | 49 | https://issa.house.gov | 2269 Rayburn House Office Building; Washington DC 20515-0549 | 202-225-3906 | 202-225-3303 | 2269 Rayburn House Office Building | http://issa.house.gov/feed/ | |||||||
44452 | 44452 | Darrell Issa I000056 | rep | CA | 2015-01-06 | 2017-01-03 | Republican | 49 | http://issa.house.gov | 2269 Rayburn HOB; Washington DC 20515-0549 | 202-225-3906 | 202-225-3303 | http://issa.house.gov/contact/contact-me | 2269 Rayburn House Office Building | http://issa.house.gov/feed/ | ||||||
44451 | 44451 | Darrell Issa I000056 | rep | CA | 2013-01-03 | 2015-01-03 | Republican | 49 | http://issa.house.gov | 2347 Rayburn HOB; Washington DC 20515-0549 | 202-225-3906 | 202-225-3303 | http://issa.house.gov/contact/contact-me | 2347 Rayburn House Office Building | http://issa.house.gov/feed/ | ||||||
44450 | 44450 | Darrell Issa I000056 | rep | CA | 2011-01-05 | 2013-01-03 | Republican | 49 | http://www.house.gov/issa | 2347 Rayburn HOB; Washington DC 20515-0549 | 202-225-3906 | 202-225-3303 | http://issa.house.gov/index.cfm?FuseAction=Contact.ContactForm | 2347 Rayburn House Office Building | |||||||
44449 | 44449 | Darrell Issa I000056 | rep | CA | 2009-01-06 | 2011-01-03 | Republican | 49 | http://www.house.gov/issa | ||||||||||||
44448 | 44448 | Darrell Issa I000056 | rep | CA | 2007-01-04 | 2009-01-03 | Republican | 49 | http://www.house.gov/issa | ||||||||||||
44447 | 44447 | Darrell Issa I000056 | rep | CA | 2005-01-04 | 2007-01-03 | Republican | 49 | http://www.house.gov/issa | ||||||||||||
44446 | 44446 | Darrell Issa I000056 | rep | CA | 2003-01-07 | 2005-01-03 | Republican | 49 | http://www.house.gov/issa | ||||||||||||
44445 | 44445 | Darrell Issa I000056 | rep | CA | 2001-01-03 | 2003-01-03 | Republican | 48 | |||||||||||||
44436 | 44436 | Mike Garcia G000061 | rep | CA | 2021-01-03 | 2023-01-03 | Republican | 25 | https://mikegarcia.house.gov | 1535 Longworth House Office Building Washington DC 20515-0525 | 202-225-1956 | 1535 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 | ||||||||||
44291 | 44291 | Mike Levin L000593 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 49 | https://mikelevin.house.gov | 1030 Longworth House Office Building Washington DC 20515-0549 | 202-225-3906 | 1030 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 | |||||||||
44289 | 44289 | Katie Porter P000618 | rep | CA | 2021-01-03 | 2023-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 | |||||||||
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 | |||||||||
44287 | 44287 | Josh Harder H001090 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 10 | https://harder.house.gov | 209 Cannon House Office Building Washington DC 20515-0510 | 202-225-4540 | 209 Cannon 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 | |||||||||
44238 | 44238 | Jimmy Gomez G000585 | rep | CA | 2021-01-03 | 2023-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 | |||||||||
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 | |||||||||
44236 | 44236 | Jimmy Gomez G000585 | rep | CA | 2017-07-11 | 2019-01-03 | Democrat | 34 | https://gomez.house.gov | 1226 Longworth House Office Building; Washington DC 20515-0534 | 202-225-6235 | 1226 Longworth House Office Building | |||||||||
44129 | 44129 | J. Correa C001110 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 46 | https://correa.house.gov | 2301 Rayburn House Office Building Washington DC 20515-0546 | 202-225-2965 | 2301 Rayburn 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 | |||||||||
44127 | 44127 | J. Correa C001110 | rep | CA | 2017-01-03 | 2019-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 | |||||||||
44126 | 44126 | Nanette Barragán B001300 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 44 | https://barragan.house.gov | 2246 Rayburn House Office Building Washington DC 20515-0544 | 202-225-8220 | 2246 Rayburn 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 | |||||||||
44124 | 44124 | Nanette Barragán B001300 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 44 | https://barragan.house.gov | 1320 Longworth House Office Building; Washington DC 20515-0544 | 202-225-8220 | 1320 Longworth House Office Building | |||||||||
44123 | 44123 | Salud Carbajal C001112 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 24 | https://carbajal.house.gov | 2331 Rayburn House Office Building Washington DC 20515-0524 | 202-225-3601 | 2331 Rayburn 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 | |||||||||
44121 | 44121 | Salud Carbajal C001112 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 24 | https://carbajal.house.gov | 212 Cannon House Office Building; Washington DC 20515-0524 | 202-225-3601 | 212 Cannon House Office Building | |||||||||
44120 | 44120 | Jimmy Panetta P000613 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 20 | https://panetta.house.gov | 406 Cannon House Office Building Washington DC 20515-0520 | 202-225-2861 | 406 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 | |||||||||
44118 | 44118 | Jimmy Panetta P000613 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 20 | https://panetta.house.gov | 228 Cannon House Office Building; Washington DC 20515-0520 | 202-225-2861 | 228 Cannon House Office Building | |||||||||
44117 | 44117 | Ro Khanna K000389 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 17 | https://khanna.house.gov | 306 Cannon House Office Building Washington DC 20515-0517 | 202-225-2631 | 306 Cannon 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 | |||||||||
44115 | 44115 | Ro Khanna K000389 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 17 | https://khanna.house.gov | 513 Cannon House Office Building; Washington DC 20515-0517 | 202-225-2631 | 513 Cannon House Office Building | |||||||||
43967 | 43967 | Norma Torres T000474 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 35 | https://torres.house.gov | 2227 Rayburn House Office Building Washington DC 20515-0535 | 202-225-6161 | 2227 Rayburn 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 | |||||||||
43965 | 43965 | Norma Torres T000474 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 35 | https://torres.house.gov | 1713 Longworth House Office Building; Washington DC 20515-0535 | 202-225-6161 | 202-225-8671 | 1713 Longworth House Office Building | ||||||||
43964 | 43964 | Norma Torres T000474 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 35 | https://torres.house.gov | 516 Cannon HOB; Washington DC 20515-0535 | 202-225-6161 | 202-225-8671 | 516 Cannon House Office Building | ||||||||
43963 | 43963 | Ted Lieu L000582 | rep | CA | 2021-01-03 | 2023-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 | |||||||||
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 | |||||||||
43961 | 43961 | Ted Lieu L000582 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 33 | https://lieu.house.gov | 236 Cannon House Office Building; Washington DC 20515-0533 | 202-225-3976 | 202-225-4099 | 236 Cannon House Office Building | ||||||||
43960 | 43960 | Ted Lieu L000582 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 33 | https://lieu.house.gov | 415 Cannon HOB; Washington DC 20515-0533 | 202-225-3976 | 202-225-4099 | 415 Cannon House Office Building | ||||||||
43959 | 43959 | Pete Aguilar A000371 | rep | CA | 2021-01-03 | 2023-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 | |||||||||
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 | |||||||||
43957 | 43957 | Pete Aguilar A000371 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 31 | https://aguilar.house.gov | 1223 Longworth House Office Building; Washington DC 20515-0531 | 202-225-3201 | 202-226-6962 | 1223 Longworth House Office Building | ||||||||
43956 | 43956 | Pete Aguilar A000371 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 31 | https://aguilar.house.gov | 1223 Longworth HOB; Washington DC 20515-0531 | 202-225-3201 | 202-226-6962 | 1223 Longworth House Office Building | ||||||||
43955 | 43955 | Mark DeSaulnier D000623 | rep | CA | 2021-01-03 | 2023-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 | |||||||||
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 | |||||||||
43953 | 43953 | Mark DeSaulnier D000623 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 11 | https://desaulnier.house.gov | 115 Cannon House Office Building; Washington DC 20515-0511 | 202-225-2095 | 202-225-5609 | 115 Cannon House Office Building | ||||||||
43952 | 43952 | Mark DeSaulnier D000623 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 11 | https://desaulnier.house.gov | 327 Cannon HOB; Washington DC 20515-0511 | 202-225-2095 | 202-225-5609 | 327 Cannon House Office Building | ||||||||
43762 | 43762 | Scott Peters P000608 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 52 | https://scottpeters.house.gov | 1201 Longworth House Office Building Washington DC 20515-0552 | 202-225-0508 | 1201 Longworth House Office Building | http://scottpeters.house.gov/rss.xml | ||||||||
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 | ||||||||
43760 | 43760 | Scott Peters P000608 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 52 | https://scottpeters.house.gov | 1122 Longworth House Office Building; Washington DC 20515-0552 | 202-225-0508 | 202-225-2558 | 1122 Longworth House Office Building | http://scottpeters.house.gov/rss.xml | |||||||
43759 | 43759 | Scott Peters P000608 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 52 | http://scottpeters.house.gov | 1122 Longworth HOB; Washington DC 20515-0552 | 202-225-0508 | 202-225-2558 | https://scottpeters.house.gov/contact/email-me | 1122 Longworth House Office Building | http://scottpeters.house.gov/rss.xml | ||||||
43758 | 43758 | Scott Peters P000608 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 52 | http://scottpeters.house.gov | 2410 Rayburn HOB; Washington DC 20515-0552 | 202-225-0508 | 202-225-2558 | https://scottpeters.house.gov/contact/email-me | 2410 Rayburn House Office Building | http://scottpeters.house.gov/rss.xml | ||||||
43757 | 43757 | Juan Vargas V000130 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 51 | https://vargas.house.gov | 2244 Rayburn House Office Building Washington DC 20515-0551 | 202-225-8045 | 2244 Rayburn House Office Building | http://vargas.house.gov/rss.xml | ||||||||
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 | ||||||||
43755 | 43755 | Juan Vargas V000130 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 51 | https://vargas.house.gov | 1605 Longworth House Office Building; Washington DC 20515-0551 | 202-225-8045 | 202-225-9073 | 1605 Longworth House Office Building | http://vargas.house.gov/rss.xml | |||||||
43754 | 43754 | Juan Vargas V000130 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 51 | http://vargas.house.gov | 1605 Longworth HOB; Washington DC 20515-0551 | 202-225-8045 | 202-225-9073 | https://vargas.house.gov/contact | 1605 Longworth House Office Building | http://vargas.house.gov/rss.xml | ||||||
43753 | 43753 | Juan Vargas V000130 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 51 | http://vargas.house.gov | 1605 Longworth HOB; Washington DC 20515-0551 | 202-225-8045 | 202-225-9073 | https://vargas.house.gov/contact | 1605 Longworth House Office Building | http://vargas.house.gov/rss.xml | ||||||
43752 | 43752 | Alan Lowenthal L000579 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 47 | https://lowenthal.house.gov | 108 Cannon House Office Building Washington DC 20515-0547 | 202-225-7924 | 108 Cannon House Office Building | http://lowenthal.house.gov/news/rss.aspx | ||||||||
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 | ||||||||
43750 | 43750 | Alan Lowenthal L000579 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 47 | https://lowenthal.house.gov | 125 Cannon House Office Building; Washington DC 20515-0547 | 202-225-7924 | 202-225-7926 | 125 Cannon House Office Building | http://lowenthal.house.gov/news/rss.aspx | |||||||
43749 | 43749 | Alan Lowenthal L000579 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 47 | http://lowenthal.house.gov | 108 Cannon HOB; Washington DC 20515-0547 | 202-225-7924 | 202-225-7926 | http://lowenthal.house.gov/contact/howtocontactme.htm | 108 Cannon House Office Building | http://lowenthal.house.gov/news/rss.aspx | ||||||
43748 | 43748 | Alan Lowenthal L000579 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 47 | http://lowenthal.house.gov | 515 Cannon HOB; Washington DC 20515-0547 | 202-225-7924 | 202-225-7926 | http://lowenthal.house.gov/contact/howtocontactme.htm | 515 Cannon House Office Building | http://lowenthal.house.gov/news/rss.aspx | ||||||
43747 | 43747 | Mark Takano T000472 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 41 | https://takano.house.gov | 420 Cannon House Office Building Washington DC 20515-0541 | 202-225-2305 | 420 Cannon House Office Building | http://takano.house.gov/rss.xml | ||||||||
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 | ||||||||
43745 | 43745 | Mark Takano T000472 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 41 | https://takano.house.gov | 1507 Longworth House Office Building; Washington DC 20515-0541 | 202-225-2305 | 202-225-7018 | 1507 Longworth House Office Building | http://takano.house.gov/rss.xml | |||||||
43744 | 43744 | Mark Takano T000472 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 41 | https://takano.house.gov | 1507 Longworth HOB; Washington DC 20515-0541 | 202-225-2305 | 202-225-7018 | https://takano.house.gov/contact/email-me | 1507 Longworth House Office Building | http://takano.house.gov/rss.xml | ||||||
43743 | 43743 | Mark Takano T000472 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 41 | http://takano.house.gov | 1507 Longworth HOB; Washington DC 20515-0541 | 202-225-2305 | https://takano.house.gov/contact/email-me | 1507 Longworth House Office Building | http://takano.house.gov/rss.xml | |||||||
43742 | 43742 | Raul Ruiz R000599 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 36 | https://ruiz.house.gov | 2342 Rayburn House Office Building Washington DC 20515-0536 | 202-225-5330 | 2342 Rayburn House Office Building | http://ruiz.house.gov/rss.xml | ||||||||
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 | ||||||||
43740 | 43740 | Raul Ruiz R000599 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 36 | https://ruiz.house.gov | 1319 Longworth House Office Building; Washington DC 20515-0536 | 202-225-5330 | 202-225-1238 | 1319 Longworth House Office Building | http://ruiz.house.gov/rss.xml | |||||||
43739 | 43739 | Raul Ruiz R000599 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 36 | https://ruiz.house.gov | 1319 Longworth HOB; Washington DC 20515-0536 | 202-225-5330 | 202-225-1238 | https://ruiz.house.gov/email-me | 1319 Longworth House Office Building | http://ruiz.house.gov/rss.xml | ||||||
43738 | 43738 | Raul Ruiz R000599 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 36 | http://ruiz.house.gov | 1319 Longworth HOB; Washington DC 20515-0536 | 202-225-5330 | https://ruiz.house.gov/email-me | 1319 Longworth House Office Building | http://ruiz.house.gov/rss.xml | |||||||
43737 | 43737 | Tony Cárdenas C001097 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 29 | https://cardenas.house.gov | 2438 Rayburn House Office Building Washington DC 20515-0529 | 202-225-6131 | 2438 Rayburn House Office Building | http://cardenas.house.gov/rss.xml | ||||||||
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 | ||||||||
43735 | 43735 | Tony Cárdenas C001097 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 29 | https://cardenas.house.gov | 1510 Longworth House Office Building; Washington DC 20515-0529 | 202-225-6131 | 202-225-0819 | 1510 Longworth House Office Building | http://cardenas.house.gov/rss.xml | |||||||
43734 | 43734 | Tony Cárdenas C001097 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 29 | http://cardenas.house.gov | 1510 Longworth HOB; Washington DC 20515-0529 | 202-225-6131 | 202-225-0819 | https://cardenas.house.gov/contact/email-me | 1510 Longworth House Office Building | http://cardenas.house.gov/rss.xml | ||||||
43733 | 43733 | Tony Cárdenas C001097 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 29 | http://cardenas.house.gov | 1508 Longworth HOB; Washington DC 20515-0529 | 202-225-6131 | 202-225-0819 | https://cardenas.house.gov/contact/email-me | 1508 Longworth House Office Building | http://cardenas.house.gov/rss.xml | ||||||
43732 | 43732 | Julia Brownley B001285 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 26 | https://juliabrownley.house.gov | 2262 Rayburn House Office Building Washington DC 20515-0526 | 202-225-5811 | 2262 Rayburn House Office Building | http://juliabrownley.house.gov/rss.xml | ||||||||
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 | ||||||||
43730 | 43730 | Julia Brownley B001285 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 26 | https://juliabrownley.house.gov | 1019 Longworth House Office Building; Washington DC 20515-0526 | 202-225-5811 | 202-225-1100 | 1019 Longworth House Office Building | http://juliabrownley.house.gov/rss.xml | |||||||
43729 | 43729 | Julia Brownley B001285 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 26 | http://juliabrownley.house.gov | 1019 Longworth HOB; Washington DC 20515-0526 | 202-225-5811 | 202-225-1100 | https://juliabrownley.house.gov/contact/email-me | 1019 Longworth House Office Building | http://juliabrownley.house.gov/rss.xml | ||||||
43728 | 43728 | Julia Brownley B001285 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 26 | http://juliabrownley.house.gov | 1019 Longworth HOB; Washington DC 20515-0526 | 202-225-5811 | 202-225-1100 | https://juliabrownley.house.gov/contact/email-me | 1019 Longworth House Office Building | http://juliabrownley.house.gov/rss.xml | ||||||
43727 | 43727 | Eric Swalwell S001193 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 15 | https://swalwell.house.gov | 174 Cannon House Office Building Washington DC 20515-0515 | 202-225-5065 | 174 Cannon House Office Building | |||||||||
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 |
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);