legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
52 rows where "end" is on date 2013-01-03 and state = "CA"
This data as json, copyable, CSV (advanced)
Suggested facets: start, start (date), end (date)
Link | rowid ▼ | legislator_id | type | state | start | end | class | party | district | how | party_affiliations | url | caucus | address | phone | fax | contact_form | office | state_rank | rss_url | end-type |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
39117 | 39117 | Joe Baca B001234 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 43 | http://www.house.gov/baca | 2366 Rayburn HOB; Washington DC 20515-0543 | 202-225-6161 | 202-225-8671 | http://www.house.gov/baca/zipauth.shtml | 2366 Rayburn House Office Building | |||||||
39157 | 39157 | Howard Berman B000410 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 28 | http://www.house.gov/berman | 2221 Rayburn HOB; Washington DC 20515-0528 | 202-225-4695 | 202-225-3196 | http://www.house.gov/berman/contact/ | 2221 Rayburn House Office Building | |||||||
39171 | 39171 | Brian Bilbray B000461 | rep | CA | 2011-01-05 | 2013-01-03 | Republican | 50 | http://www.house.gov/bilbray | 2410 Rayburn HOB; Washington DC 20515-0550 | 202-225-0508 | 202-225-2558 | http://www.house.gov/bilbray/contact.shtml | 2410 Rayburn House Office Building | |||||||
39179 | 39179 | Mary Bono Mack B001228 | rep | CA | 2011-01-05 | 2013-01-03 | Republican | 45 | http://bono.house.gov | 104 Cannon HOB; Washington DC 20515-0545 | 202-225-5330 | 202-225-2961 | http://www.house.gov/formbono/issue.htm | 104 Cannon House Office Building | |||||||
39268 | 39268 | David Dreier D000492 | rep | CA | 2011-01-05 | 2013-01-03 | Republican | 26 | http://dreier.house.gov | 233 Cannon HOB; Washington DC 20515-0526 | 202-225-2305 | 202-225-7018 | http://doyle.house.gov/email_mike.shtml | 233 Cannon House Office Building | |||||||
39297 | 39297 | Elton Gallegly G000021 | rep | CA | 2011-01-05 | 2013-01-03 | Republican | 24 | http://www.house.gov/gallegly | 2309 Rayburn HOB; Washington DC 20515-0524 | 202-225-5811 | 202-225-1100 | http://www.house.gov/writerep | 2309 Rayburn House Office Building | |||||||
39318 | 39318 | Walter Herger H000528 | rep | CA | 2011-01-05 | 2013-01-03 | Republican | 2 | http://www.house.gov/herger | 242 Cannon HOB; Washington DC 20515-0502 | 202-225-3076 | 202-225-1740 | http://www.house.gov/herger/contact.shtml | 242 Cannon House Office Building | |||||||
39399 | 39399 | Jerry Lewis L000274 | rep | CA | 2011-01-05 | 2013-01-03 | Republican | 41 | http://www.house.gov/jerrylewis | 2112 Rayburn HOB; Washington DC 20515-0541 | 202-225-5861 | 202-225-6498 | http://www.house.gov/jerrylewis/IMA/WritetoRepresentativeLewis.htm | 2112 Rayburn House Office Building | |||||||
39408 | 39408 | Daniel Lungren L000517 | rep | CA | 2011-01-05 | 2013-01-03 | Republican | 3 | http://www.lungren.house.gov | 2313 Rayburn HOB; Washington DC 20515-0503 | 202-225-5716 | 202-226-1298 | https://forms.house.gov/lungren/forms/email.shtml | 2313 Rayburn House Office Building | |||||||
39489 | 39489 | Laura Richardson R000581 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 37 | http://richardson.house.gov/ | 1330 Longworth HOB; Washington DC 20515-0537 | 202-225-7924 | 202-225-7926 | http://richardson.house.gov/IMA/issue_subscribe.htm | 1330 Longworth House Office Building | |||||||
39532 | 39532 | Fortney Stark S000810 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 13 | http://www.house.gov/stark | 239 Cannon HOB; Washington DC 20515-0513 | 202-225-5065 | 202-226-3805 | http://www.house.gov/stark/contact/index.htm | 239 Cannon House Office Building | |||||||
39580 | 39580 | Lynn Woolsey W000738 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 6 | http://woolsey.house.gov | 2263 Rayburn HOB; Washington DC 20515-0506 | 202-225-5161 | 202-225-5163 | http://woolsey.house.gov/contactemailform.asp | 2263 Rayburn House Office Building | |||||||
39783 | 39783 | John Campbell C001064 | rep | CA | 2011-01-05 | 2013-01-03 | Republican | 48 | http://www.house.gov/campbell | 1507 Longworth HOB; Washington DC 20515-0548 | 202-225-5611 | 202-225-9177 | http://campbell.house.gov/Contact/ContactForm.htm | 1507 Longworth House Office Building | |||||||
39946 | 39946 | Howard McKeon M000508 | rep | CA | 2011-01-05 | 2013-01-03 | Republican | 25 | http://mckeon.house.gov | 2184 Rayburn HOB; Washington DC 20515-0525 | 202-225-1956 | 202-226-0683 | http://mckeon.house.gov/contact.shtml | 2184 Rayburn House Office Building | |||||||
39960 | 39960 | Gary Miller M001139 | rep | CA | 2011-01-05 | 2013-01-03 | Republican | 42 | http://www.house.gov/garymiller | 2349 Rayburn HOB; Washington DC 20515-0542 | 202-225-3201 | 202-226-6962 | http://garymiller.house.gov/Contact/ | 2349 Rayburn House Office Building | |||||||
39980 | 39980 | George Miller M000725 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 7 | http://www.house.gov/georgemiller | 2205 Rayburn HOB; Washington DC 20515-0507 | 202-225-2095 | 202-225-5609 | http://georgemiller.house.gov/contactus/2007/08/post_1.html | 2205 Rayburn House Office Building | |||||||
40097 | 40097 | Henry Waxman W000215 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 30 | http://www.henrywaxman.house.gov | 2204 Rayburn HOB; Washington DC 20515-0530 | 202-225-3976 | 202-225-4099 | http://waxman.house.gov/Contact/ | 2204 Rayburn House Office Building | |||||||
40190 | 40190 | Janice Hahn H001063 | rep | CA | 2011-07-19 | 2013-01-03 | Democrat | 36 | http://hahn.house.gov/ | 2400 Rayburn HOB; Washington DC 20515-0536 | 202-225-8220 | 202-226-7290 | https://hahn.house.gov/contact-me/email-me | 2400 Rayburn House Office Building | |||||||
40274 | 40274 | Lois Capps C001036 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 23 | http://www.house.gov/capps | 2231 Rayburn HOB; Washington DC 20515-0523 | 202-225-3601 | 202-225-5632 | http://www.house.gov/capps/contact/send_an_email.shtml | 2231 Rayburn House Office Building | |||||||
40305 | 40305 | Sam Farr F000030 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 17 | http://www.house.gov/farr | 1126 Longworth HOB; Washington DC 20515-0517 | 202-225-2861 | 202-225-6791 | http://www.farr.house.gov/index.php?option=com_content&task=view&id=202 | 1126 Longworth House Office Building | |||||||
40358 | 40358 | Michael Honda H001034 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 15 | http://www.house.gov/honda | 1713 Longworth HOB; Washington DC 20515-0515 | 202-225-2631 | 202-225-2699 | http://honda.house.gov/contactmike.shtml | 1713 Longworth House Office Building | |||||||
40474 | 40474 | Loretta Sanchez S000030 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 47 | http://www.lorettasanchez.house.gov | 1114 Longworth HOB; Washington DC 20515-0547 | 202-225-2965 | 202-225-5859 | http://www.lorettasanchez.house.gov/index.php?option=com_content&task=view&id=218&Itemid=17 | 1114 Longworth House Office Building | |||||||
40521 | 40521 | Xavier Becerra B000287 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 31 | http://becerra.house.gov | 1226 Longworth HOB; Washington DC 20515-0531 | 202-225-6235 | 202-225-2202 | http://becerra.house.gov/HoR/CA31/Hidden+Content/Email+Signup+Form.htm | 1226 Longworth House Office Building | |||||||
40768 | 40768 | Jeff Denham D000612 | rep | CA | 2011-01-05 | 2013-01-03 | Republican | 19 | http://denham.house.gov/ | 1605 Longworth HOB; Washington DC 20515-0519 | 202-225-4540 | 202-225-3402 | 1605 Longworth House Office Building | ||||||||
40985 | 40985 | Dana Rohrabacher R000409 | rep | CA | 2011-01-05 | 2013-01-03 | Republican | 46 | http://www.house.gov/rohrabacher | 2300 Rayburn HOB; Washington DC 20515-0546 | 202-225-2415 | 202-225-0145 | http://rohrabacher.house.gov/Contact/Zip.htm | 2300 Rayburn House Office Building | |||||||
41032 | 41032 | Edward Royce R000487 | rep | CA | 2011-01-05 | 2013-01-03 | Republican | 40 | http://www.royce.house.gov | 2185 Rayburn HOB; Washington DC 20515-0540 | 202-225-4111 | 202-226-0335 | http://www.house.gov/writerep | 2185 Rayburn House Office Building | |||||||
41217 | 41217 | Duncan Hunter H001048 | rep | CA | 2011-01-05 | 2013-01-03 | Republican | 52 | http://hunter.house.gov | 223 Cannon HOB; Washington DC 20515-0552 | 202-225-5672 | 202-225-0235 | https://forms.house.gov/hunter/zipauthen_contact.shtml | 223 Cannon House Office Building | |||||||
41322 | 41322 | Susan Davis D000598 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 53 | http://www.house.gov/susandavis | 1526 Longworth HOB; Washington DC 20515-0553 | 202-225-2040 | 202-225-2948 | http://www.house.gov/susandavis/contact.shtml | 1526 Longworth House Office Building | |||||||
41656 | 41656 | Devin Nunes N000181 | rep | CA | 2011-01-05 | 2013-01-03 | Republican | 21 | http://nunes.house.gov | 1013 Longworth HOB; Washington DC 20515-0521 | 202-225-2523 | 202-225-3404 | http://www.nunes.house.gov/index.cfm?FuseAction=ContactUs.ContactForm | 1013 Longworth House Office Building | |||||||
41773 | 41773 | Dianne Feinstein F000062 | sen | CA | 2007-01-04 | 2013-01-03 | 1 | Democrat | http://feinstein.senate.gov | 331 HART SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-3841 | 202-228-3954 | http://www.feinstein.senate.gov/public/index.cfm/e-mail-me | 331 Hart Senate Office Building | |||||||
41926 | 41926 | Karen Bass B001270 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 33 | http://karenbass.house.gov/ | 408 Cannon HOB; Washington DC 20515-0533 | 202-225-7084 | 202-225-2422 | 408 Cannon House Office Building | ||||||||
42069 | 42069 | Ken Calvert C000059 | rep | CA | 2011-01-05 | 2013-01-03 | Republican | 44 | http://calvert.house.gov | 2269 Rayburn HOB; Washington DC 20515-0544 | 202-225-1986 | 202-225-2004 | http://calvert.house.gov/awenhnjafe.asp | 2269 Rayburn House Office Building | |||||||
42129 | 42129 | Judy Chu C001080 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 32 | http://chu.house.gov/ | 1520 Longworth HOB; Washington DC 20515-0532 | 202-225-5464 | 202-225-5467 | https://forms.house.gov/chu/contact-form.shtml | 1520 Longworth House Office Building | |||||||
42217 | 42217 | Jim Costa C001059 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 20 | http://www.house.gov/costa | 1314 Longworth HOB; Washington DC 20515-0520 | 202-225-3341 | 202-225-9308 | http://www.house.gov/formcosta/issue.htm | 1314 Longworth House Office Building | |||||||
42372 | 42372 | Anna Eshoo E000215 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 14 | http://eshoo.house.gov | 205 Cannon HOB; Washington DC 20515-0514 | 202-225-8104 | 202-225-8890 | https://forms.house.gov/eshoo/webforms/issue_subscribe.htm | 205 Cannon House Office Building | |||||||
42394 | 42394 | John Garamendi G000559 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 10 | http://garamendi.house.gov/ | 228 Cannon HOB; Washington DC 20515-0510 | 202-225-1880 | 202-225-5914 | http://garamendi.house.gov/contact/email-me.shtml | 228 Cannon House Office Building | |||||||
42732 | 42732 | Barbara Lee L000551 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 9 | http://lee.house.gov | 2267 Rayburn HOB; Washington DC 20515-0509 | 202-225-2661 | 202-225-9817 | http://lee.house.gov/?sectionid=44&sectiontree=18,44 | 2267 Rayburn House Office Building | |||||||
42748 | 42748 | Zoe Lofgren L000397 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 16 | http://www.house.gov/lofgren | 1401 Longworth HOB; Washington DC 20515-0516 | 202-225-3072 | 202-225-3336 | http://lofgren.house.gov/emailform.shtml | 1401 Longworth House Office Building | |||||||
42841 | 42841 | Doris Matsui M001163 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 5 | http://www.house.gov/matsui | 222 Cannon HOB; Washington DC 20515-0505 | 202-225-7163 | 202-225-0566 | https://forms.house.gov/matsui/webforms/issue_subscribe.htm | 222 Cannon House Office Building | |||||||
42849 | 42849 | Kevin McCarthy M001165 | rep | CA | 2011-01-05 | 2013-01-03 | Republican | 22 | http://kevinmccarthy.house.gov | 326 Cannon HOB; Washington DC 20515-0522 | 202-225-2915 | 202-225-2908 | http://kevinmccarthy.house.gov/showpage.asp?ID=69 | 326 Cannon House Office Building | |||||||
42865 | 42865 | Tom McClintock M001177 | rep | CA | 2011-01-05 | 2013-01-03 | Republican | 4 | http://mcclintock.house.gov | 428 Cannon HOB; Washington DC 20515-0504 | 202-225-2511 | 202-225-5444 | https://forms.house.gov/mcclintock/contact-form.shtml | 428 Cannon House Office Building | |||||||
42921 | 42921 | Jerry McNerney M001166 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 11 | http://mcnerney.house.gov | 1210 Longworth HOB; Washington DC 20515-0511 | 202-225-1947 | 202-225-4060 | http://mcnerney.house.gov/contact.shtml | 1210 Longworth House Office Building | |||||||
42994 | 42994 | Grace Napolitano N000179 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 38 | http://napolitano.house.gov | 1610 Longworth HOB; Washington DC 20515-0538 | 202-225-5256 | 202-225-0027 | http://www.napolitano.house.gov/contact/feedback.htm | 1610 Longworth House Office Building | |||||||
43084 | 43084 | Nancy Pelosi P000197 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 8 | http://www.house.gov/pelosi | 235 Cannon HOB; Washington DC 20515-0508 | 202-225-4965 | 202-225-8259 | http://www.house.gov/pelosi/contact/contact.html | 235 Cannon House Office Building | |||||||
43190 | 43190 | Lucille Roybal-Allard R000486 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 34 | http://www.house.gov/roybal-allard | 2330 Rayburn HOB; Washington DC 20515-0534 | 202-225-1766 | 202-226-0350 | http://www.house.gov/writerep | 2330 Rayburn House Office Building | |||||||
43273 | 43273 | Adam Schiff S001150 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 29 | http://schiff.house.gov | 2411 Rayburn HOB; Washington DC 20515-0529 | 202-225-4176 | 202-225-5828 | http://schiff.house.gov/HoR/CA29/Contact+Information/Contact+Form.htm | 2411 Rayburn House Office Building | |||||||
43363 | 43363 | Brad Sherman S000344 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 27 | http://bradsherman.house.gov | 2242 Rayburn HOB; Washington DC 20515-0527 | 202-225-5911 | 202-225-5879 | http://www.house.gov/sherman/contact/ | 2242 Rayburn House Office Building | |||||||
43434 | 43434 | Jackie Speier S001175 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 12 | http://speier.house.gov/ | 211 Cannon HOB; Washington DC 20515-0512 | 202-225-3531 | 202-347-0956 | http://speier.house.gov/IMA/issue_subscribe.htm | 211 Cannon House Office Building | |||||||
43444 | 43444 | Linda Sánchez S001156 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 39 | http://www.house.gov/lindasanchez | 2423 Rayburn HOB; Washington DC 20515-0539 | 202-225-6676 | 202-226-1012 | http://www.house.gov/writerep | 2423 Rayburn House Office Building | |||||||
43471 | 43471 | Mike Thompson T000460 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 1 | http://mikethompson.house.gov | 231 Cannon HOB; Washington DC 20515-0501 | 202-225-3311 | 202-225-4335 | http://mikethompson.house.gov/contact/email.shtml | 231 Cannon House Office Building | |||||||
43579 | 43579 | Maxine Waters W000187 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 35 | http://www.house.gov/waters | 2344 Rayburn HOB; Washington DC 20515-0535 | 202-225-2201 | 202-225-7854 | http://www.house.gov/waters/IMA/issue.htm | 2344 Rayburn House Office Building | |||||||
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 |
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);