legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
53 rows where "end" is on date 2017-01-03 and state = "CA"
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
40209 | 40209 | Barbara Boxer B000711 | sen | CA | 2011-01-05 | 2017-01-03 | 3 | Democrat | https://www.boxer.senate.gov | 112 Hart Senate Office Building Washington DC 20510 | 202-224-3553 | 202-224-0454 | https://www.boxer.senate.gov/contact/shareyourviews.html | 112 Hart Senate Office Building | junior | ||||||
40276 | 40276 | Lois Capps C001036 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 24 | http://capps.house.gov | 2231 Rayburn HOB; Washington DC 20515-0524 | 202-225-3601 | 202-225-5632 | https://capps.house.gov/contact-me/email-me | 2231 Rayburn House Office Building | http://capps.house.gov/rss.xml | ||||||
40307 | 40307 | Sam Farr F000030 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 20 | http://farr.house.gov | 1126 Longworth HOB; Washington DC 20515-0520 | 202-225-2861 | 202-225-6791 | https://forms.house.gov/farr/webforms/issue_subscribe.html | 1126 Longworth House Office Building | http://www.farr.house.gov/index.php?format=feed&type=rss | ||||||
40360 | 40360 | Michael Honda H001034 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 17 | https://honda.house.gov | 1713 Longworth HOB; Washington DC 20515-0517 | 202-225-2631 | 202-225-2699 | http://honda.house.gov/contact | 1713 Longworth House Office Building | http://www.house.gov/index.php?format=feed&type=rss | ||||||
40476 | 40476 | Loretta Sanchez S000030 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 46 | http://lorettasanchez.house.gov | 1211 Longworth HOB; Washington DC 20515-0546 | 202-225-2965 | 202-225-5859 | https://lorettasanchez.house.gov/contact-me/email-me | 1211 Longworth House Office Building | http://lorettasanchez.house.gov/rss.xml | ||||||
40523 | 40523 | Xavier Becerra B000287 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 34 | http://becerra.house.gov | 1226 Longworth HOB; Washington DC 20515-0534 | 202-225-6235 | 202-225-2202 | http://becerraforms.house.gov/forms/writeyourrep/ | 1226 Longworth House Office Building | http://becerra.house.gov/index.php?format=feed&type=rss | ||||||
40770 | 40770 | Jeff Denham D000612 | rep | CA | 2015-01-06 | 2017-01-03 | Republican | 10 | http://denham.house.gov | 1730 Longworth HOB; Washington DC 20515-0510 | 202-225-4540 | 202-225-3402 | https://denham.house.gov/contact-me/email-me | 1730 Longworth House Office Building | http://denham.house.gov/rss.xml | ||||||
40987 | 40987 | Dana Rohrabacher R000409 | rep | CA | 2015-01-06 | 2017-01-03 | Republican | 48 | http://rohrabacher.house.gov | 2300 Rayburn HOB; Washington DC 20515-0548 | 202-225-2415 | 202-225-0145 | https://rohrabacher.house.gov/contact/email-me | 2300 Rayburn House Office Building | http://rohrabacher.house.gov/rss.xml | ||||||
41034 | 41034 | Edward Royce R000487 | rep | CA | 2015-01-06 | 2017-01-03 | Republican | 39 | http://royce.house.gov | 2310 Rayburn HOB; Washington DC 20515-0539 | 202-225-4111 | 202-226-0335 | https://royce.house.gov/contact/contactform.htm | 2310 Rayburn House Office Building | http://royce.house.gov/news/rss.aspx | ||||||
41126 | 41126 | Steve Knight K000387 | rep | CA | 2015-01-06 | 2017-01-03 | Republican | 25 | https://knight.house.gov | 1023 Longworth HOB; Washington DC 20515-0525 | 202-225-1956 | 202-226-0683 | 1023 Longworth House Office Building | ||||||||
41128 | 41128 | Mimi Walters W000820 | rep | CA | 2015-01-06 | 2017-01-03 | Republican | 45 | https://walters.house.gov | 236 Cannon HOB; Washington DC 20515-0545 | 202-225-5611 | 202-225-9177 | 236 Cannon House Office Building | ||||||||
41219 | 41219 | Duncan Hunter H001048 | rep | CA | 2015-01-06 | 2017-01-03 | Republican | 50 | http://hunter.house.gov | 2429 Rayburn HOB; Washington DC 20515-0550 | 202-225-5672 | 202-225-0235 | https://hunter.house.gov/contact-me/email-me | 2429 Rayburn House Office Building | http://hunter.house.gov/rss.xml | ||||||
41256 | 41256 | Paul Cook C001094 | rep | CA | 2015-01-06 | 2017-01-03 | Republican | 8 | http://cook.house.gov | 1222 Longworth HOB; Washington DC 20515-0508 | 202-225-5861 | https://cook.house.gov/contact/email-me | 1222 Longworth House Office Building | http://cook.house.gov/rss.xml | |||||||
41324 | 41324 | Susan Davis D000598 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 53 | http://susandavis.house.gov | 1214 Longworth HOB; Washington DC 20515-0553 | 202-225-2040 | 202-225-2948 | https://susandavisforms.house.gov/forms/writeyourrep/ | 1214 Longworth House Office Building | |||||||
41658 | 41658 | Devin Nunes N000181 | rep | CA | 2015-01-06 | 2017-01-03 | Republican | 22 | http://nunes.house.gov | 1013 Longworth HOB; Washington DC 20515-0522 | 202-225-2523 | 202-225-3404 | https://nunes.house.gov/contactform/default.aspx | 1013 Longworth House Office Building | http://nunes.house.gov/news/rss.aspx | ||||||
41928 | 41928 | Karen Bass B001270 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 37 | http://bass.house.gov | 408 Cannon HOB; Washington DC 20515-0537 | 202-225-7084 | 202-225-2422 | https://bass.house.gov/contact-me/email-me | 408 Cannon House Office Building | http://bass.house.gov/rss.xml | ||||||
42071 | 42071 | Ken Calvert C000059 | rep | CA | 2015-01-06 | 2017-01-03 | Republican | 42 | http://calvert.house.gov | 2205 Rayburn HOB; Washington DC 20515-0542 | 202-225-1986 | 202-225-2004 | https://calvert.house.gov/contactform/ | 2205 Rayburn House Office Building | http://calvert.house.gov/news/rss.aspx | ||||||
42131 | 42131 | Judy Chu C001080 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 27 | http://chu.house.gov | 2423 Rayburn HOB; Washington DC 20515-0527 | 202-225-5464 | 202-225-5467 | http://chu.house.gov/connect-with-me/email-judy | 2423 Rayburn House Office Building | http://chu.house.gov/rss.xml | ||||||
42219 | 42219 | Jim Costa C001059 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 16 | https://costa.house.gov | 1314 Longworth HOB; Washington DC 20515-0516 | 202-225-3341 | 202-225-9308 | http://www.house.gov/formcosta/issue.htm | 1314 Longworth House Office Building | http://costa.house.gov/index.php?format=feed&type=rss | ||||||
42374 | 42374 | Anna Eshoo E000215 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 18 | http://eshoo.house.gov | 241 Cannon HOB; Washington DC 20515-0518 | 202-225-8104 | 202-225-8890 | https://eshoo.house.gov/email-me/ | 241 Cannon House Office Building | http://eshoo.house.gov/index.php?format=feed&type=rss | ||||||
42396 | 42396 | John Garamendi G000559 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 3 | http://garamendi.house.gov | 2438 Rayburn HOB; Washington DC 20515-0503 | 202-225-1880 | 202-225-5914 | https://garamendi.house.gov/contact-me/email-me | 2438 Rayburn House Office Building | http://garamendi.house.gov/rss.xml | ||||||
42734 | 42734 | Barbara Lee L000551 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 13 | http://lee.house.gov | 2267 Rayburn HOB; Washington DC 20515-0513 | 202-225-2661 | 202-225-9817 | http://lee.house.gov/contact-the-office/email-me | 2267 Rayburn House Office Building | http://lee.house.gov/rss.xml | ||||||
42750 | 42750 | Zoe Lofgren L000397 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 19 | https://lofgren.house.gov | 1401 Longworth HOB; Washington DC 20515-0519 | 202-225-3072 | 202-225-3336 | http://lofgren.house.gov/contact/ | 1401 Longworth House Office Building | http://lofgren.house.gov/index.php?format=feed&type=rss | ||||||
42843 | 42843 | Doris Matsui M001163 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 6 | http://matsui.house.gov | 2311 Rayburn HOB; Washington DC 20515-0506 | 202-225-7163 | 202-225-0566 | https://matsui.house.gov/email-representative-matsui | 2311 Rayburn House Office Building | http://matsui.house.gov/index.php?format=feed&type=rss | ||||||
42851 | 42851 | Kevin McCarthy M001165 | rep | CA | 2015-01-06 | 2017-01-03 | Republican | 23 | http://kevinmccarthy.house.gov | 2421 Rayburn HOB; Washington DC 20515-0523 | 202-225-2915 | 202-225-2908 | https://kevinmccarthy.house.gov/contact/email-me | 2421 Rayburn House Office Building | http://kevinmccarthy.house.gov/index.php?format=feed&type=rss | ||||||
42867 | 42867 | Tom McClintock M001177 | rep | CA | 2015-01-06 | 2017-01-03 | Republican | 4 | http://mcclintock.house.gov | 2331 Rayburn HOB; Washington DC 20515-0504 | 202-225-2511 | 202-225-5444 | https://mcclintockforms.house.gov/forms/contact-form.shtml | 2331 Rayburn House Office Building | http://mcclintock.house.gov/atom.xml | ||||||
42923 | 42923 | Jerry McNerney M001166 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 9 | http://mcnerney.house.gov | 2265 Rayburn HOB; Washington DC 20515-0509 | 202-225-1947 | 202-225-4060 | https://mcnerney.house.gov/contact/email-me | 2265 Rayburn House Office Building | http://mcnerney.house.gov/rss.xml | ||||||
42996 | 42996 | Grace Napolitano N000179 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 32 | http://napolitano.house.gov | 1610 Longworth HOB; Washington DC 20515-0532 | 202-225-5256 | 202-225-0027 | https://napolitano.house.gov/contact-me/email-me | 1610 Longworth House Office Building | http://napolitano.house.gov/rss.xml | ||||||
43086 | 43086 | Nancy Pelosi P000197 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 12 | http://pelosi.house.gov | 233 Cannon HOB; Washington DC 20515-0512 | 202-225-4965 | 202-225-8259 | http://pelosi.house.gov/contact-me/email-me | 233 Cannon House Office Building | http://pelosi.house.gov/atom.xml | ||||||
43192 | 43192 | Lucille Roybal-Allard R000486 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 40 | http://roybal-allard.house.gov | 2330 Rayburn HOB; Washington DC 20515-0540 | 202-225-1766 | 202-226-0350 | http://roybal-allard.house.gov/contact/ | 2330 Rayburn House Office Building | http://roybal-allard.house.gov/news/rss.aspx | ||||||
43275 | 43275 | Adam Schiff S001150 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 28 | http://schiff.house.gov | 2411 Rayburn HOB; Washington DC 20515-0528 | 202-225-4176 | 202-225-5828 | https://schiff.house.gov/contact | 2411 Rayburn House Office Building | http://schiff.house.gov/common/rss/?rss=49 | ||||||
43365 | 43365 | Brad Sherman S000344 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 30 | http://sherman.house.gov | 2242 Rayburn HOB; Washington DC 20515-0530 | 202-225-5911 | 202-225-5879 | http://sherman.house.gov/contact/contact-congressman-sherman-form | 2242 Rayburn House Office Building | http://bradsherman.house.gov/press-releases-and-columns/rss.shtml | ||||||
43436 | 43436 | Jackie Speier S001175 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 14 | http://speier.house.gov | 2465 Rayburn HOB; Washington DC 20515-0514 | 202-225-3531 | 202-347-0956 | https://forms.house.gov/speier/webforms/email_jackie.shtml | 2465 Rayburn House Office Building | http://speier.house.gov/index.php?format=feed&type=rss | ||||||
43446 | 43446 | Linda Sánchez S001156 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 38 | https://lindasanchez.house.gov | 2329 Rayburn HOB; Washington DC 20515-0538 | 202-225-6676 | 202-226-1012 | https://forms.house.gov/lindasanchez/webforms/issue_subscribe.htm | 2329 Rayburn House Office Building | http://lindasanchez.house.gov/index.php?format=feed&type=rss | ||||||
43473 | 43473 | Mike Thompson T000460 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 5 | http://mikethompson.house.gov | 231 Cannon HOB; Washington DC 20515-0505 | 202-225-3311 | 202-225-4335 | https://mikethompson.house.gov/contact/email-me | 231 Cannon House Office Building | http://mikethompson.house.gov/news/rss.aspx | ||||||
43581 | 43581 | Maxine Waters W000187 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 43 | http://waters.house.gov | 2221 Rayburn HOB; Washington DC 20515-0543 | 202-225-2201 | 202-225-7854 | https://waters.house.gov/contact/contactform.htm | 2221 Rayburn House Office Building | http://waters.house.gov/news/rss.aspx | ||||||
43709 | 43709 | Doug LaMalfa L000578 | rep | CA | 2015-01-06 | 2017-01-03 | Republican | 1 | http://lamalfa.house.gov | 322 Cannon HOB; Washington DC 20515-0501 | 202-225-3076 | 530-534-7800 | https://lamalfa.house.gov/contact/email-me | 322 Cannon House Office Building | http://lamalfa.house.gov/rss.xml | ||||||
43714 | 43714 | Jared Huffman H001068 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 2 | http://huffman.house.gov | 1630 Longworth HOB; Washington DC 20515-0502 | 202-225-5161 | 202-225-5163 | https://huffman.house.gov/contact/email-me | 1630 Longworth House Office Building | http://huffman.house.gov/rss.xml | ||||||
43719 | 43719 | Ami Bera B001287 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 7 | http://bera.house.gov | 1535 Longworth HOB; Washington DC 20515-0507 | 202-225-5716 | 202-226-1298 | https://beraforms.house.gov/forms/writeyourrep/ | 1535 Longworth House Office Building | http://bera.house.gov/rss.xml | ||||||
43724 | 43724 | Eric Swalwell S001193 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 15 | http://swalwell.house.gov | 129 Cannon HOB; Washington DC 20515-0515 | 202-225-5065 | http://swalwell.house.gov/contact-me/email-eric/ | 129 Cannon House Office Building | ||||||||
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 | ||||||
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 | ||||||
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 | ||||||
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 | ||||||
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 | ||||||
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 | ||||||
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 | ||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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/ | ||||||
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 |
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);