legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
54 rows where "start" is on date 2017-01-03 and state = "CA"
This data as json, copyable, CSV (advanced)
Suggested facets: type
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
40524 | 40524 | Xavier Becerra B000287 | rep | CA | 2017-01-03 | 2017-01-24 | Democrat | 34 | https://becerra.house.gov | 1226 Longworth HOB; Washington DC 20515-0534 | 202-225-6235 | 1226 Longworth House Office Building | http://becerra.house.gov/index.php?format=feed&type=rss | ||||||||
40771 | 40771 | Jeff Denham D000612 | rep | CA | 2017-01-03 | 2019-01-03 | Republican | 10 | https://denham.house.gov | 1730 Longworth House Office Building; Washington DC 20515-0510 | 202-225-4540 | 202-225-3402 | 1730 Longworth House Office Building | http://denham.house.gov/rss.xml | |||||||
40988 | 40988 | Dana Rohrabacher R000409 | rep | CA | 2017-01-03 | 2019-01-03 | Republican | 48 | https://rohrabacher.house.gov | 2300 Rayburn House Office Building; Washington DC 20515-0548 | 202-225-2415 | 202-225-0145 | 2300 Rayburn House Office Building | http://rohrabacher.house.gov/rss.xml | |||||||
41035 | 41035 | Edward Royce R000487 | rep | CA | 2017-01-03 | 2019-01-03 | Republican | 39 | https://royce.house.gov | 2310 Rayburn House Office Building; Washington DC 20515-0539 | 202-225-4111 | 202-226-0335 | 2310 Rayburn House Office Building | http://royce.house.gov/news/rss.aspx | |||||||
41127 | 41127 | Steve Knight K000387 | rep | CA | 2017-01-03 | 2019-01-03 | Republican | 25 | https://knight.house.gov | 1023 Longworth House Office Building; Washington DC 20515-0525 | 202-225-1956 | 202-226-0683 | 1023 Longworth House Office Building | ||||||||
41129 | 41129 | Mimi Walters W000820 | rep | CA | 2017-01-03 | 2019-01-03 | Republican | 45 | https://walters.house.gov | 215 Cannon House Office Building; Washington DC 20515-0545 | 202-225-5611 | 202-225-9177 | 215 Cannon House Office Building | ||||||||
41220 | 41220 | Duncan Hunter H001048 | rep | CA | 2017-01-03 | 2019-01-03 | Republican | 50 | https://hunter.house.gov | 2429 Rayburn House Office Building; Washington DC 20515-0550 | 202-225-5672 | 202-225-0235 | 2429 Rayburn House Office Building | http://hunter.house.gov/rss.xml | |||||||
41257 | 41257 | Paul Cook C001094 | rep | CA | 2017-01-03 | 2019-01-03 | Republican | 8 | https://cook.house.gov | 1222 Longworth House Office Building; Washington DC 20515-0508 | 202-225-5861 | 202-225-6498 | 1222 Longworth House Office Building | http://cook.house.gov/rss.xml | |||||||
41325 | 41325 | Susan Davis D000598 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 53 | https://susandavis.house.gov | 1214 Longworth House Office Building; Washington DC 20515-0553 | 202-225-2040 | 202-225-2948 | 1214 Longworth House Office Building | ||||||||
41617 | 41617 | Kamala Harris H001075 | sen | CA | 2017-01-03 | 2021-01-18 | 3 | Democrat | https://www.harris.senate.gov | 112 Hart Senate Office Building Washington DC 20510 | 202-224-3553 | https://www.harris.senate.gov/contact | 112 Hart Senate Office Building | junior | |||||||
41659 | 41659 | Devin Nunes N000181 | rep | CA | 2017-01-03 | 2019-01-03 | Republican | 22 | https://nunes.house.gov | 1013 Longworth House Office Building; Washington DC 20515-0522 | 202-225-2523 | 202-225-3404 | 1013 Longworth House Office Building | http://nunes.house.gov/news/rss.aspx | |||||||
41929 | 41929 | Karen Bass B001270 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 37 | https://bass.house.gov | 2241 Rayburn House Office Building; Washington DC 20515-0537 | 202-225-7084 | 202-225-2422 | 2241 Rayburn House Office Building | http://bass.house.gov/rss.xml | |||||||
42072 | 42072 | Ken Calvert C000059 | rep | CA | 2017-01-03 | 2019-01-03 | Republican | 42 | https://calvert.house.gov | 2205 Rayburn House Office Building; Washington DC 20515-0542 | 202-225-1986 | 202-225-2004 | 2205 Rayburn House Office Building | http://calvert.house.gov/news/rss.aspx | |||||||
42132 | 42132 | Judy Chu C001080 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 27 | https://chu.house.gov | 2423 Rayburn House Office Building; Washington DC 20515-0527 | 202-225-5464 | 202-225-5467 | 2423 Rayburn House Office Building | http://chu.house.gov/rss.xml | |||||||
42220 | 42220 | Jim Costa C001059 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 16 | https://costa.house.gov | 2081 Rayburn House Office Building; Washington DC 20515-0516 | 202-225-3341 | 202-225-9308 | 2081 Rayburn House Office Building | http://costa.house.gov/index.php?format=feed&type=rss | |||||||
42375 | 42375 | Anna Eshoo E000215 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 18 | http://eshoo.house.gov | 241 Cannon House Office Building; Washington DC 20515-0518 | 202-225-8104 | 202-225-8890 | 241 Cannon House Office Building | http://eshoo.house.gov/index.php?format=feed&type=rss | |||||||
42397 | 42397 | John Garamendi G000559 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 3 | https://garamendi.house.gov | 2438 Rayburn House Office Building; Washington DC 20515-0503 | 202-225-1880 | 202-225-5914 | 2438 Rayburn House Office Building | http://garamendi.house.gov/rss.xml | |||||||
42735 | 42735 | Barbara Lee L000551 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 13 | https://lee.house.gov | 2267 Rayburn House Office Building; Washington DC 20515-0513 | 202-225-2661 | 202-225-9817 | 2267 Rayburn House Office Building | http://lee.house.gov/rss.xml | |||||||
42751 | 42751 | Zoe Lofgren L000397 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 19 | https://lofgren.house.gov | 1401 Longworth House Office Building; Washington DC 20515-0519 | 202-225-3072 | 202-225-3336 | 1401 Longworth House Office Building | http://lofgren.house.gov/index.php?format=feed&type=rss | |||||||
42844 | 42844 | Doris Matsui M001163 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 6 | http://matsui.house.gov | 2311 Rayburn House Office Building; Washington DC 20515-0506 | 202-225-7163 | 202-225-0566 | 2311 Rayburn House Office Building | http://matsui.house.gov/index.php?format=feed&type=rss | |||||||
42852 | 42852 | Kevin McCarthy M001165 | rep | CA | 2017-01-03 | 2019-01-03 | Republican | 23 | https://kevinmccarthy.house.gov | 2421 Rayburn House Office Building; Washington DC 20515-0523 | 202-225-2915 | 202-225-2908 | 2421 Rayburn House Office Building | http://kevinmccarthy.house.gov/index.php?format=feed&type=rss | |||||||
42868 | 42868 | Tom McClintock M001177 | rep | CA | 2017-01-03 | 2019-01-03 | Republican | 4 | https://mcclintock.house.gov | 2312 Rayburn House Office Building; Washington DC 20515-0504 | 202-225-2511 | 202-225-5444 | 2312 Rayburn House Office Building | http://mcclintock.house.gov/atom.xml | |||||||
42924 | 42924 | Jerry McNerney M001166 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 9 | https://mcnerney.house.gov | 2265 Rayburn House Office Building; Washington DC 20515-0509 | 202-225-1947 | 202-225-4060 | 2265 Rayburn House Office Building | http://mcnerney.house.gov/rss.xml | |||||||
42997 | 42997 | Grace Napolitano N000179 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 32 | https://napolitano.house.gov | 1610 Longworth House Office Building; Washington DC 20515-0532 | 202-225-5256 | 202-225-0027 | 1610 Longworth House Office Building | http://napolitano.house.gov/rss.xml | |||||||
43087 | 43087 | Nancy Pelosi P000197 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 12 | https://pelosi.house.gov | 233 Cannon House Office Building; Washington DC 20515-0512 | 202-225-4965 | 202-225-8259 | 233 Cannon House Office Building | http://pelosi.house.gov/atom.xml | |||||||
43193 | 43193 | Lucille Roybal-Allard R000486 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 40 | https://roybal-allard.house.gov | 2083 Rayburn House Office Building; Washington DC 20515-0540 | 202-225-1766 | 202-226-0350 | 2083 Rayburn House Office Building | http://roybal-allard.house.gov/news/rss.aspx | |||||||
43276 | 43276 | Adam Schiff S001150 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 28 | https://schiff.house.gov | 2372 Rayburn House Office Building; Washington DC 20515-0528 | 202-225-4176 | 202-225-5828 | 2372 Rayburn House Office Building | http://schiff.house.gov/common/rss/?rss=49 | |||||||
43366 | 43366 | Brad Sherman S000344 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 30 | https://sherman.house.gov | 2181 Rayburn House Office Building; Washington DC 20515-0530 | 202-225-5911 | 202-225-5879 | 2181 Rayburn House Office Building | http://bradsherman.house.gov/press-releases-and-columns/rss.shtml | |||||||
43437 | 43437 | Jackie Speier S001175 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 14 | https://speier.house.gov | 2465 Rayburn House Office Building; Washington DC 20515-0514 | 202-225-3531 | 202-347-0956 | 2465 Rayburn House Office Building | http://speier.house.gov/index.php?format=feed&type=rss | |||||||
43447 | 43447 | Linda Sánchez S001156 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 38 | https://lindasanchez.house.gov | 2329 Rayburn House Office Building; Washington DC 20515-0538 | 202-225-6676 | 202-226-1012 | 2329 Rayburn House Office Building | http://lindasanchez.house.gov/index.php?format=feed&type=rss | |||||||
43474 | 43474 | Mike Thompson T000460 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 5 | https://mikethompson.house.gov | 231 Cannon House Office Building; Washington DC 20515-0505 | 202-225-3311 | 202-225-4335 | 231 Cannon House Office Building | http://mikethompson.house.gov/news/rss.aspx | |||||||
43582 | 43582 | Maxine Waters W000187 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 43 | https://waters.house.gov | 2221 Rayburn House Office Building; Washington DC 20515-0543 | 202-225-2201 | 202-225-7854 | 2221 Rayburn House Office Building | http://waters.house.gov/news/rss.aspx | |||||||
43710 | 43710 | Doug LaMalfa L000578 | rep | CA | 2017-01-03 | 2019-01-03 | Republican | 1 | https://lamalfa.house.gov | 322 Cannon House Office Building; Washington DC 20515-0501 | 202-225-3076 | 530-534-7800 | 322 Cannon House Office Building | http://lamalfa.house.gov/rss.xml | |||||||
43715 | 43715 | Jared Huffman H001068 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 2 | https://huffman.house.gov | 1406 Longworth House Office Building; Washington DC 20515-0502 | 202-225-5161 | 202-225-5163 | 1406 Longworth House Office Building | http://huffman.house.gov/rss.xml | |||||||
43720 | 43720 | Ami Bera B001287 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 7 | https://bera.house.gov | 1431 Longworth House Office Building; Washington DC 20515-0507 | 202-225-5716 | 202-226-1298 | 1431 Longworth House Office Building | http://bera.house.gov/rss.xml | |||||||
43725 | 43725 | Eric Swalwell S001193 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 15 | https://swalwell.house.gov | 129 Cannon House Office Building; Washington DC 20515-0515 | 202-225-5065 | 129 Cannon House Office Building | |||||||||
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 | |||||||
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 | |||||||
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 | |||||||
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 | |||||||
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 | |||||||
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 | |||||||
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 | |||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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 | |||||||||
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/ | |||||||
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 |
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);