legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
44,551 rows sorted by district descending
This data as json, copyable, CSV (advanced)
Suggested facets: class, how, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
41318 | 41318 | Susan Davis D000598 | rep | CA | 2003-01-07 | 2005-01-03 | Democrat | 53 | http://www.house.gov/susandavis | ||||||||||||
41319 | 41319 | Susan Davis D000598 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 53 | http://www.house.gov/susandavis | ||||||||||||
41320 | 41320 | Susan Davis D000598 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 53 | http://www.house.gov/susandavis | ||||||||||||
41321 | 41321 | Susan Davis D000598 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 53 | http://www.house.gov/susandavis | ||||||||||||
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 | |||||||
41323 | 41323 | Susan Davis D000598 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 53 | http://www.house.gov/susandavis | 1526 Longworth HOB; Washington DC 20515-0553 | 202-225-2040 | 202-225-2948 | https://susandavisforms.house.gov/forms/writeyourrep/ | 1526 Longworth House Office Building | |||||||
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 | |||||||
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 | ||||||||
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 | |||||||||
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 | |||||||||
38121 | 38121 | Duncan Hunter H000981 | rep | CA | 1993-01-05 | 1995-01-03 | Republican | 52 | |||||||||||||
38122 | 38122 | Duncan Hunter H000981 | rep | CA | 1995-01-04 | 1997-01-03 | Republican | 52 | |||||||||||||
38123 | 38123 | Duncan Hunter H000981 | rep | CA | 1997-01-07 | 1999-01-03 | Republican | 52 | |||||||||||||
38124 | 38124 | Duncan Hunter H000981 | rep | CA | 1999-01-06 | 2001-01-03 | Republican | 52 | |||||||||||||
38125 | 38125 | Duncan Hunter H000981 | rep | CA | 2001-01-03 | 2003-01-03 | Republican | 52 | |||||||||||||
38126 | 38126 | Duncan Hunter H000981 | rep | CA | 2003-01-07 | 2005-01-03 | Republican | 52 | http://www.house.gov/hunter | ||||||||||||
38127 | 38127 | Duncan Hunter H000981 | rep | CA | 2005-01-04 | 2007-01-03 | Republican | 52 | http://www.house.gov/hunter | ||||||||||||
38128 | 38128 | Duncan Hunter H000981 | rep | CA | 2007-01-04 | 2009-01-03 | Republican | 52 | http://www.house.gov/hunter | ||||||||||||
41216 | 41216 | Duncan Hunter H001048 | rep | CA | 2009-01-06 | 2011-01-03 | Republican | 52 | http://hunter.house.gov | ||||||||||||
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 | |||||||
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 | ||||||
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 | ||||||
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 | |||||||
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 | ||||||||
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 | ||||||||
37581 | 37581 | Randall Cunningham C000994 | rep | CA | 1993-01-05 | 1995-01-03 | Republican | 51 | |||||||||||||
37582 | 37582 | Randall Cunningham C000994 | rep | CA | 1995-01-04 | 1997-01-03 | Republican | 51 | |||||||||||||
37583 | 37583 | Randall Cunningham C000994 | rep | CA | 1997-01-07 | 1999-01-03 | Republican | 51 | |||||||||||||
37584 | 37584 | Randall Cunningham C000994 | rep | CA | 1999-01-06 | 2001-01-03 | Republican | 51 | |||||||||||||
37585 | 37585 | Randall Cunningham C000994 | rep | CA | 2001-01-03 | 2003-01-03 | Republican | 51 | |||||||||||||
39013 | 39013 | Bob Filner F000116 | rep | CA | 2003-01-07 | 2005-01-03 | Democrat | 51 | http://www.house.gov/filner | ||||||||||||
39014 | 39014 | Bob Filner F000116 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 51 | http://www.house.gov/filner | ||||||||||||
39015 | 39015 | Bob Filner F000116 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 51 | http://www.house.gov/filner | ||||||||||||
39016 | 39016 | Bob Filner F000116 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 51 | http://www.house.gov/filner | ||||||||||||
39017 | 39017 | Bob Filner F000116 | rep | CA | 2011-01-05 | 2012-12-03 | Democrat | 51 | http://www.house.gov/filner | 2428 Rayburn HOB; Washington DC 20515-0551 | 202-225-8045 | 202-225-9073 | http://www.house.gov/writerep | 2428 Rayburn House Office Building | |||||||
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 | ||||||
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 | ||||||
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 | |||||||
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 | ||||||||
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 | ||||||||
37586 | 37586 | Randall Cunningham C000994 | rep | CA | 2003-01-07 | 2005-01-03 | Republican | 50 | http://www.house.gov/cunningham | ||||||||||||
37587 | 37587 | Randall Cunningham C000994 | rep | CA | 2005-01-04 | 2005-12-01 | Republican | 50 | http://www.house.gov/cunningham | ||||||||||||
39008 | 39008 | Bob Filner F000116 | rep | CA | 1993-01-05 | 1995-01-03 | Democrat | 50 | |||||||||||||
39009 | 39009 | Bob Filner F000116 | rep | CA | 1995-01-04 | 1997-01-03 | Democrat | 50 | |||||||||||||
39010 | 39010 | Bob Filner F000116 | rep | CA | 1997-01-07 | 1999-01-03 | Democrat | 50 | |||||||||||||
39011 | 39011 | Bob Filner F000116 | rep | CA | 1999-01-06 | 2001-01-03 | Democrat | 50 | |||||||||||||
39012 | 39012 | Bob Filner F000116 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 50 | |||||||||||||
39168 | 39168 | Brian Bilbray B000461 | rep | CA | 2006-06-13 | 2007-01-03 | Republican | 50 | |||||||||||||
39169 | 39169 | Brian Bilbray B000461 | rep | CA | 2007-01-04 | 2009-01-03 | Republican | 50 | http://www.house.gov/bilbray | ||||||||||||
39170 | 39170 | Brian Bilbray B000461 | rep | CA | 2009-01-06 | 2011-01-03 | Republican | 50 | http://www.house.gov/bilbray | ||||||||||||
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 | |||||||
41218 | 41218 | Duncan Hunter H001048 | rep | CA | 2013-01-03 | 2015-01-03 | Republican | 50 | http://hunter.house.gov | 223 Cannon HOB; Washington DC 20515-0550 | 202-225-5672 | 202-225-0235 | https://hunter.house.gov/contact-me/email-me | 223 Cannon House Office Building | http://hunter.house.gov/rss.xml | ||||||
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 | ||||||
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 | |||||||
41221 | 41221 | Duncan Hunter H001048 | rep | CA | 2019-01-03 | 2020-01-13 | Republican | 50 | https://hunter.house.gov | 2429 Rayburn House Office Building; Washington DC 20515-0550 | 202-225-5672 | 2429 Rayburn House Office Building | http://hunter.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/ | ||||||||
35564 | 35564 | Lynn Schenk S000119 | rep | CA | 1993-01-05 | 1995-01-03 | Democrat | 49 | |||||||||||||
39165 | 39165 | Brian Bilbray B000461 | rep | CA | 1995-01-04 | 1997-01-03 | Republican | 49 | |||||||||||||
39166 | 39166 | Brian Bilbray B000461 | rep | CA | 1997-01-07 | 1999-01-03 | Republican | 49 | |||||||||||||
39167 | 39167 | Brian Bilbray B000461 | rep | CA | 1999-01-06 | 2001-01-03 | Republican | 49 | |||||||||||||
41317 | 41317 | Susan Davis D000598 | rep | CA | 2001-01-03 | 2003-01-03 | Democrat | 49 | |||||||||||||
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 | |||||||||
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 | |||||||||
44446 | 44446 | Darrell Issa I000056 | rep | CA | 2003-01-07 | 2005-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 | ||||||||||||
44448 | 44448 | Darrell Issa I000056 | rep | CA | 2007-01-04 | 2009-01-03 | Republican | 49 | http://www.house.gov/issa | ||||||||||||
44449 | 44449 | Darrell Issa I000056 | rep | CA | 2009-01-06 | 2011-01-03 | Republican | 49 | http://www.house.gov/issa | ||||||||||||
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 | |||||||
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/ | ||||||
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/ | ||||||
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/ | |||||||
36729 | 36729 | Ron Packard P000005 | rep | CA | 1993-01-05 | 1995-01-03 | Republican | 48 | |||||||||||||
36730 | 36730 | Ron Packard P000005 | rep | CA | 1995-01-04 | 1997-01-03 | Republican | 48 | |||||||||||||
36731 | 36731 | Ron Packard P000005 | rep | CA | 1997-01-07 | 1999-01-03 | Republican | 48 | |||||||||||||
36732 | 36732 | Ron Packard P000005 | rep | CA | 1999-01-06 | 2001-01-03 | Republican | 48 | |||||||||||||
37578 | 37578 | C. Cox C000830 | rep | CA | 2003-01-07 | 2005-01-03 | Republican | 48 | http://cox.house.gov | ||||||||||||
37579 | 37579 | C. Cox C000830 | rep | CA | 2005-01-04 | 2005-08-02 | Republican | 48 | http://cox.house.gov | ||||||||||||
39780 | 39780 | John Campbell C001064 | rep | CA | 2005-12-07 | 2007-01-03 | Republican | 48 | http://www.house.gov/campbell | ||||||||||||
39781 | 39781 | John Campbell C001064 | rep | CA | 2007-01-04 | 2009-01-03 | Republican | 48 | http://www.house.gov/campbell | ||||||||||||
39782 | 39782 | John Campbell C001064 | rep | CA | 2009-01-06 | 2011-01-03 | Republican | 48 | http://www.house.gov/campbell | ||||||||||||
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 | |||||||
40986 | 40986 | Dana Rohrabacher R000409 | rep | CA | 2013-01-03 | 2015-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 | ||||||
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 | ||||||
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 | |||||||
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 | |||||||||
44445 | 44445 | Darrell Issa I000056 | rep | CA | 2001-01-03 | 2003-01-03 | Republican | 48 | |||||||||||||
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 | |||||||||
37573 | 37573 | C. Cox C000830 | rep | CA | 1993-01-05 | 1995-01-03 | Republican | 47 | |||||||||||||
37574 | 37574 | C. Cox C000830 | rep | CA | 1995-01-04 | 1997-01-03 | Republican | 47 | |||||||||||||
37575 | 37575 | C. Cox C000830 | rep | CA | 1997-01-07 | 1999-01-03 | Republican | 47 | |||||||||||||
37576 | 37576 | C. Cox C000830 | rep | CA | 1999-01-06 | 2001-01-03 | Republican | 47 | |||||||||||||
37577 | 37577 | C. Cox C000830 | rep | CA | 2001-01-03 | 2003-01-03 | Republican | 47 | |||||||||||||
40470 | 40470 | Loretta Sanchez S000030 | rep | CA | 2003-01-07 | 2005-01-03 | Democrat | 47 | http://www.house.gov/sanchez | ||||||||||||
40471 | 40471 | Loretta Sanchez S000030 | rep | CA | 2005-01-04 | 2007-01-03 | Democrat | 47 | http://www.house.gov/sanchez | ||||||||||||
40472 | 40472 | Loretta Sanchez S000030 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 47 | http://www.lorettasanchez.house.gov | ||||||||||||
40473 | 40473 | Loretta Sanchez S000030 | rep | CA | 2009-01-06 | 2011-01-03 | Democrat | 47 | http://www.lorettasanchez.house.gov | ||||||||||||
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 | |||||||
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 | ||||||
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 | ||||||
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 |
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);