legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
51 rows where "end" is on date 2021-01-03 and state = "CA"
This data as json, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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);