legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
44,551 rows
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
42238 | 42238 | Eric Crawford C001087 | rep | AR | 2011-01-05 | 2013-01-03 | Republican | 1 | http://crawford.house.gov/ | 1408 Longworth HOB; Washington DC 20515-0401 | 202-225-4076 | 202-225-5602 | 1408 Longworth House Office Building | ||||||||
42239 | 42239 | Eric Crawford C001087 | rep | AR | 2013-01-03 | 2015-01-03 | Republican | 1 | http://crawford.house.gov | 1711 Longworth HOB; Washington DC 20515-0401 | 202-225-4076 | 202-225-5602 | http://crawford.house.gov/contact/ | 1711 Longworth House Office Building | http://crawford.house.gov/news/rss.aspx | ||||||
42240 | 42240 | Eric Crawford C001087 | rep | AR | 2015-01-06 | 2017-01-03 | Republican | 1 | http://crawford.house.gov | 1711 Longworth HOB; Washington DC 20515-0401 | 202-225-4076 | 202-225-5602 | http://crawford.house.gov/contact/ | 1711 Longworth House Office Building | http://crawford.house.gov/news/rss.aspx | ||||||
42241 | 42241 | Eric Crawford C001087 | rep | AR | 2017-01-03 | 2019-01-03 | Republican | 1 | https://crawford.house.gov | 2422 Rayburn House Office Building; Washington DC 20515-0401 | 202-225-4076 | 202-225-5602 | 2422 Rayburn House Office Building | http://crawford.house.gov/news/rss.aspx | |||||||
42242 | 42242 | Eric Crawford C001087 | rep | AR | 2019-01-03 | 2021-01-03 | Republican | 1 | https://crawford.house.gov | 2422 Rayburn House Office Building Washington DC 20515-0401 | 202-225-4076 | 2422 Rayburn House Office Building | http://crawford.house.gov/news/rss.aspx | ||||||||
42243 | 42243 | Eric Crawford C001087 | rep | AR | 2021-01-03 | 2023-01-03 | Republican | 1 | https://crawford.house.gov | 2422 Rayburn House Office Building Washington DC 20515-0401 | 202-225-4076 | 2422 Rayburn House Office Building | http://crawford.house.gov/news/rss.aspx | ||||||||
42244 | 42244 | Henry Cuellar C001063 | rep | TX | 2005-01-04 | 2007-01-03 | Democrat | 28 | |||||||||||||
42245 | 42245 | Henry Cuellar C001063 | rep | TX | 2007-01-04 | 2009-01-03 | Democrat | 28 | http://www.house.gov/cuellar | ||||||||||||
42246 | 42246 | Henry Cuellar C001063 | rep | TX | 2009-01-06 | 2011-01-03 | Democrat | 28 | http://www.house.gov/cuellar | ||||||||||||
42247 | 42247 | Henry Cuellar C001063 | rep | TX | 2011-01-05 | 2013-01-03 | Democrat | 28 | http://www.house.gov/cuellar | 2463 Rayburn HOB; Washington DC 20515-4328 | 202-225-1640 | 202-225-1641 | http://cuellar.house.gov/Contact/SendMeAnEmail.htm | 2463 Rayburn House Office Building | |||||||
42248 | 42248 | Henry Cuellar C001063 | rep | TX | 2013-01-03 | 2015-01-03 | Democrat | 28 | http://cuellar.house.gov | 2431 Rayburn HOB; Washington DC 20515-4328 | 202-225-1640 | 202-225-1641 | https://cuellar.house.gov/forms/writeyourrep/default.aspx | 2431 Rayburn House Office Building | http://cuellar.house.gov/news/rss.aspx | ||||||
42249 | 42249 | Henry Cuellar C001063 | rep | TX | 2015-01-06 | 2017-01-03 | Democrat | 28 | http://cuellar.house.gov | 2209 Rayburn HOB; Washington DC 20515-4328 | 202-225-1640 | 202-225-1641 | https://cuellar.house.gov/forms/writeyourrep/default.aspx | 2209 Rayburn House Office Building | http://cuellar.house.gov/news/rss.aspx | ||||||
42250 | 42250 | Henry Cuellar C001063 | rep | TX | 2017-01-03 | 2019-01-03 | Democrat | 28 | https://cuellar.house.gov | 2209 Rayburn House Office Building; Washington DC 20515-4328 | 202-225-1640 | 202-225-1641 | 2209 Rayburn House Office Building | http://cuellar.house.gov/news/rss.aspx | |||||||
42251 | 42251 | Henry Cuellar C001063 | rep | TX | 2019-01-03 | 2021-01-03 | Democrat | 28 | https://cuellar.house.gov | 2372 Rayburn House Office Building Washington DC 20515-4328 | 202-225-1640 | 2372 Rayburn House Office Building | http://cuellar.house.gov/news/rss.aspx | ||||||||
42252 | 42252 | Henry Cuellar C001063 | rep | TX | 2021-01-03 | 2023-01-03 | Democrat | 28 | https://cuellar.house.gov | 2372 Rayburn House Office Building Washington DC 20515-4328 | 202-225-1640 | 2372 Rayburn House Office Building | http://cuellar.house.gov/news/rss.aspx | ||||||||
42253 | 42253 | Danny Davis D000096 | rep | IL | 1997-01-07 | 1999-01-03 | Democrat | 7 | |||||||||||||
42254 | 42254 | Danny Davis D000096 | rep | IL | 1999-01-06 | 2001-01-03 | Democrat | 7 | |||||||||||||
42255 | 42255 | Danny Davis D000096 | rep | IL | 2001-01-03 | 2003-01-03 | Democrat | 7 | |||||||||||||
42256 | 42256 | Danny Davis D000096 | rep | IL | 2003-01-07 | 2005-01-03 | Democrat | 7 | http://www.house.gov/davis | ||||||||||||
42257 | 42257 | Danny Davis D000096 | rep | IL | 2005-01-04 | 2007-01-03 | Democrat | 7 | http://www.house.gov/davis | ||||||||||||
42258 | 42258 | Danny Davis D000096 | rep | IL | 2007-01-04 | 2009-01-03 | Democrat | 7 | http://www.house.gov/davis | ||||||||||||
42259 | 42259 | Danny Davis D000096 | rep | IL | 2009-01-06 | 2011-01-03 | Democrat | 7 | http://www.house.gov/davis | ||||||||||||
42260 | 42260 | Danny Davis D000096 | rep | IL | 2011-01-05 | 2013-01-03 | Democrat | 7 | http://www.house.gov/davis | 2159 Rayburn HOB; Washington DC 20515-1307 | 202-225-5006 | 202-225-5641 | https://forms.house.gov/davis/webforms/issue_subscribe.htm | 2159 Rayburn House Office Building | |||||||
42261 | 42261 | Danny Davis D000096 | rep | IL | 2013-01-03 | 2015-01-03 | Democrat | 7 | http://www.davis.house.gov | 2159 Rayburn HOB; Washington DC 20515-1307 | 202-225-5006 | 202-225-5641 | https://davis.house.gov/email-me | 2159 Rayburn House Office Building | http://davis.house.gov/index.php?format=feed&type=rss | ||||||
42262 | 42262 | Danny Davis D000096 | rep | IL | 2015-01-06 | 2017-01-03 | Democrat | 7 | http://davis.house.gov | 2159 Rayburn HOB; Washington DC 20515-1307 | 202-225-5006 | 202-225-5641 | https://davis.house.gov/email-me | 2159 Rayburn House Office Building | http://davis.house.gov/index.php?format=feed&type=rss | ||||||
42263 | 42263 | Danny Davis D000096 | rep | IL | 2017-01-03 | 2019-01-03 | Democrat | 7 | https://davis.house.gov | 2159 Rayburn House Office Building; Washington DC 20515-1307 | 202-225-5006 | 202-225-5641 | 2159 Rayburn House Office Building | http://davis.house.gov/index.php?format=feed&type=rss | |||||||
42264 | 42264 | Danny Davis D000096 | rep | IL | 2019-01-03 | 2021-01-03 | Democrat | 7 | https://davis.house.gov | 2159 Rayburn House Office Building Washington DC 20515-1307 | 202-225-5006 | 2159 Rayburn House Office Building | http://davis.house.gov/index.php?format=feed&type=rss | ||||||||
42265 | 42265 | Danny Davis D000096 | rep | IL | 2021-01-03 | 2023-01-03 | Democrat | 7 | https://davis.house.gov | 2159 Rayburn House Office Building Washington DC 20515-1307 | 202-225-5006 | 2159 Rayburn House Office Building | http://davis.house.gov/index.php?format=feed&type=rss | ||||||||
42266 | 42266 | Peter DeFazio D000191 | rep | OR | 1987-01-06 | 1989-01-03 | Democrat | 4 | |||||||||||||
42267 | 42267 | Peter DeFazio D000191 | rep | OR | 1989-01-03 | 1991-01-03 | Democrat | 4 | |||||||||||||
42268 | 42268 | Peter DeFazio D000191 | rep | OR | 1991-01-03 | 1993-01-03 | Democrat | 4 | |||||||||||||
42269 | 42269 | Peter DeFazio D000191 | rep | OR | 1993-01-05 | 1995-01-03 | Democrat | 4 | |||||||||||||
42270 | 42270 | Peter DeFazio D000191 | rep | OR | 1995-01-04 | 1997-01-03 | Democrat | 4 | |||||||||||||
42271 | 42271 | Peter DeFazio D000191 | rep | OR | 1997-01-07 | 1999-01-03 | Democrat | 4 | |||||||||||||
42272 | 42272 | Peter DeFazio D000191 | rep | OR | 1999-01-06 | 2001-01-03 | Democrat | 4 | |||||||||||||
42273 | 42273 | Peter DeFazio D000191 | rep | OR | 2001-01-03 | 2003-01-03 | Democrat | 4 | |||||||||||||
42274 | 42274 | Peter DeFazio D000191 | rep | OR | 2003-01-07 | 2005-01-03 | Democrat | 4 | http://www.house.gov/defazio/ | ||||||||||||
42275 | 42275 | Peter DeFazio D000191 | rep | OR | 2005-01-04 | 2007-01-03 | Democrat | 4 | http://www.house.gov/defazio/ | ||||||||||||
42276 | 42276 | Peter DeFazio D000191 | rep | OR | 2007-01-04 | 2009-01-03 | Democrat | 4 | http://defazio.house.gov | ||||||||||||
42277 | 42277 | Peter DeFazio D000191 | rep | OR | 2009-01-06 | 2011-01-03 | Democrat | 4 | http://defazio.house.gov | ||||||||||||
42278 | 42278 | Peter DeFazio D000191 | rep | OR | 2011-01-05 | 2013-01-03 | Democrat | 4 | http://defazio.house.gov | 2134 Rayburn HOB; Washington DC 20515-3704 | 202-225-6416 | 202-225-0032 | http://www.house.gov/formdefazio/contact.html | 2134 Rayburn House Office Building | |||||||
42279 | 42279 | Peter DeFazio D000191 | rep | OR | 2013-01-03 | 2015-01-03 | Democrat | 4 | http://defazio.house.gov | 2134 Rayburn HOB; Washington DC 20515-3704 | 202-225-6416 | https://defazio.house.gov/contact/email-me | 2134 Rayburn House Office Building | http://www.defazio.house.gov/index.php?format=feed&type=rss | |||||||
42280 | 42280 | Peter DeFazio D000191 | rep | OR | 2015-01-06 | 2017-01-03 | Democrat | 4 | http://defazio.house.gov | 2134 Rayburn HOB; Washington DC 20515-3704 | 202-225-6416 | https://defazio.house.gov/contact/email-me | 2134 Rayburn House Office Building | http://www.defazio.house.gov/index.php?format=feed&type=rss | |||||||
42281 | 42281 | Peter DeFazio D000191 | rep | OR | 2017-01-03 | 2019-01-03 | Democrat | 4 | https://defazio.house.gov | 2134 Rayburn House Office Building; Washington DC 20515-3704 | 202-225-6416 | 2134 Rayburn House Office Building | http://www.defazio.house.gov/index.php?format=feed&type=rss | ||||||||
42282 | 42282 | Peter DeFazio D000191 | rep | OR | 2019-01-03 | 2021-01-03 | Democrat | 4 | https://defazio.house.gov | 2134 Rayburn House Office Building Washington DC 20515-3704 | 202-225-6416 | 2134 Rayburn House Office Building | http://www.defazio.house.gov/index.php?format=feed&type=rss | ||||||||
42283 | 42283 | Peter DeFazio D000191 | rep | OR | 2021-01-03 | 2023-01-03 | Democrat | 4 | https://defazio.house.gov | 2134 Rayburn House Office Building Washington DC 20515-3704 | 202-225-6416 | 2134 Rayburn House Office Building | http://www.defazio.house.gov/index.php?format=feed&type=rss | ||||||||
42284 | 42284 | Diana DeGette D000197 | rep | CO | 1997-01-07 | 1999-01-03 | Democrat | 1 | |||||||||||||
42285 | 42285 | Diana DeGette D000197 | rep | CO | 1999-01-06 | 2001-01-03 | Democrat | 1 | |||||||||||||
42286 | 42286 | Diana DeGette D000197 | rep | CO | 2001-01-03 | 2003-01-03 | Democrat | 1 | |||||||||||||
42287 | 42287 | Diana DeGette D000197 | rep | CO | 2003-01-07 | 2005-01-03 | Democrat | 1 | http://www.house.gov/degette | ||||||||||||
42288 | 42288 | Diana DeGette D000197 | rep | CO | 2005-01-04 | 2007-01-03 | Democrat | 1 | http://www.house.gov/degette | ||||||||||||
42289 | 42289 | Diana DeGette D000197 | rep | CO | 2007-01-04 | 2009-01-03 | Democrat | 1 | http://www.house.gov/degette | ||||||||||||
42290 | 42290 | Diana DeGette D000197 | rep | CO | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://www.house.gov/degette | ||||||||||||
42291 | 42291 | Diana DeGette D000197 | rep | CO | 2011-01-05 | 2013-01-03 | Democrat | 1 | http://www.house.gov/degette | 2335 Rayburn HOB; Washington DC 20515-0601 | 202-225-4431 | 202-225-5657 | http://www.house.gov/formdegette/zip_auth.htm | 2335 Rayburn House Office Building | |||||||
42292 | 42292 | Diana DeGette D000197 | rep | CO | 2013-01-03 | 2015-01-03 | Democrat | 1 | http://degette.house.gov | 2368 Rayburn HOB; Washington DC 20515-0601 | 202-225-4431 | 202-225-5657 | https://degette.house.gov/contact/send-me-an-email/email-me | 2368 Rayburn House Office Building | http://degette.house.gov/index.php?option=com_ninjarsssyndicator&feed_id=1&format=raw | ||||||
42293 | 42293 | Diana DeGette D000197 | rep | CO | 2015-01-06 | 2017-01-03 | Democrat | 1 | http://degette.house.gov | 2368 Rayburn HOB; Washington DC 20515-0601 | 202-225-4431 | 202-225-5657 | https://degette.house.gov/contact/send-me-an-email/email-me | 2368 Rayburn House Office Building | http://degette.house.gov/index.php?option=com_ninjarsssyndicator&feed_id=1&format=raw | ||||||
42294 | 42294 | Diana DeGette D000197 | rep | CO | 2017-01-03 | 2019-01-03 | Democrat | 1 | https://degette.house.gov | 2111 Rayburn House Office Building; Washington DC 20515-0601 | 202-225-4431 | 202-225-5657 | 2111 Rayburn House Office Building | http://degette.house.gov/index.php?option=com_ninjarsssyndicator&feed_id=1&format=raw | |||||||
42295 | 42295 | Diana DeGette D000197 | rep | CO | 2019-01-03 | 2021-01-03 | Democrat | 1 | https://degette.house.gov | 2111 Rayburn House Office Building Washington DC 20515-0601 | 202-225-4431 | 2111 Rayburn House Office Building | http://degette.house.gov/index.php?option=com_ninjarsssyndicator&feed_id=1&format=raw | ||||||||
42296 | 42296 | Diana DeGette D000197 | rep | CO | 2021-01-03 | 2023-01-03 | Democrat | 1 | https://degette.house.gov | 2111 Rayburn House Office Building Washington DC 20515-0601 | 202-225-4431 | 2111 Rayburn House Office Building | http://degette.house.gov/index.php?option=com_ninjarsssyndicator&feed_id=1&format=raw | ||||||||
42297 | 42297 | Rosa DeLauro D000216 | rep | CT | 1991-01-03 | 1993-01-03 | Democrat | 3 | |||||||||||||
42298 | 42298 | Rosa DeLauro D000216 | rep | CT | 1993-01-05 | 1995-01-03 | Democrat | 3 | |||||||||||||
42299 | 42299 | Rosa DeLauro D000216 | rep | CT | 1995-01-04 | 1997-01-03 | Democrat | 3 | |||||||||||||
42300 | 42300 | Rosa DeLauro D000216 | rep | CT | 1997-01-07 | 1999-01-03 | Democrat | 3 | |||||||||||||
42301 | 42301 | Rosa DeLauro D000216 | rep | CT | 1999-01-06 | 2001-01-03 | Democrat | 3 | |||||||||||||
42302 | 42302 | Rosa DeLauro D000216 | rep | CT | 2001-01-03 | 2003-01-03 | Democrat | 3 | |||||||||||||
42303 | 42303 | Rosa DeLauro D000216 | rep | CT | 2003-01-07 | 2005-01-03 | Democrat | 3 | http://www.house.gov/delauro | ||||||||||||
42304 | 42304 | Rosa DeLauro D000216 | rep | CT | 2005-01-04 | 2007-01-03 | Democrat | 3 | http://www.house.gov/delauro | ||||||||||||
42305 | 42305 | Rosa DeLauro D000216 | rep | CT | 2007-01-04 | 2009-01-03 | Democrat | 3 | http://www.house.gov/delauro | ||||||||||||
42306 | 42306 | Rosa DeLauro D000216 | rep | CT | 2009-01-06 | 2011-01-03 | Democrat | 3 | http://www.house.gov/delauro | ||||||||||||
42307 | 42307 | Rosa DeLauro D000216 | rep | CT | 2011-01-05 | 2013-01-03 | Democrat | 3 | http://www.house.gov/delauro | 2413 Rayburn HOB; Washington DC 20515-0703 | 202-225-3661 | 202-225-4890 | http://delauro.house.gov/contact_form_email.cfm | 2413 Rayburn House Office Building | |||||||
42308 | 42308 | Rosa DeLauro D000216 | rep | CT | 2013-01-03 | 2015-01-03 | Democrat | 3 | http://delauro.house.gov | 2413 Rayburn HOB; Washington DC 20515-0703 | 202-225-3661 | 202-225-4890 | https://forms.house.gov/delauro/webforms/contact_form_email.shtml | 2413 Rayburn House Office Building | http://delauro.house.gov/index.php?format=feed&type=rss | ||||||
42309 | 42309 | Rosa DeLauro D000216 | rep | CT | 2015-01-06 | 2017-01-03 | Democrat | 3 | http://delauro.house.gov | 2413 Rayburn HOB; Washington DC 20515-0703 | 202-225-3661 | 202-225-4890 | https://forms.house.gov/delauro/webforms/contact_form_email.shtml | 2413 Rayburn House Office Building | http://delauro.house.gov/index.php?format=feed&type=rss | ||||||
42310 | 42310 | Rosa DeLauro D000216 | rep | CT | 2017-01-03 | 2019-01-03 | Democrat | 3 | https://delauro.house.gov | 2413 Rayburn House Office Building; Washington DC 20515-0703 | 202-225-3661 | 202-225-4890 | 2413 Rayburn House Office Building | http://delauro.house.gov/index.php?format=feed&type=rss | |||||||
42311 | 42311 | Rosa DeLauro D000216 | rep | CT | 2019-01-03 | 2021-01-03 | Democrat | 3 | https://delauro.house.gov | 2413 Rayburn House Office Building Washington DC 20515-0703 | 202-225-3661 | 2413 Rayburn House Office Building | http://delauro.house.gov/index.php?format=feed&type=rss | ||||||||
42312 | 42312 | Rosa DeLauro D000216 | rep | CT | 2021-01-03 | 2023-01-03 | Democrat | 3 | https://delauro.house.gov | 2413 Rayburn House Office Building Washington DC 20515-0703 | 202-225-3661 | 2413 Rayburn House Office Building | http://delauro.house.gov/index.php?format=feed&type=rss | ||||||||
42313 | 42313 | Scott DesJarlais D000616 | rep | TN | 2011-01-05 | 2013-01-03 | Republican | 4 | http://desjarlais.house.gov/ | 413 Cannon HOB; Washington DC 20515-4204 | 202-225-6831 | 202-226-5172 | 413 Cannon House Office Building | ||||||||
42314 | 42314 | Scott DesJarlais D000616 | rep | TN | 2013-01-03 | 2015-01-03 | Republican | 4 | http://desjarlais.house.gov | 413 Cannon HOB; Washington DC 20515-4204 | 202-225-6831 | 202-226-5172 | http://desjarlais.house.gov/contact/email-me | 413 Cannon House Office Building | http://desjarlais.house.gov/news/rss.aspx | ||||||
42315 | 42315 | Scott DesJarlais D000616 | rep | TN | 2015-01-06 | 2017-01-03 | Republican | 4 | https://desjarlais.house.gov | 413 Cannon HOB; Washington DC 20515-4204 | 202-225-6831 | 202-226-5172 | http://desjarlais.house.gov/contact/email-me | 413 Cannon House Office Building | http://desjarlais.house.gov/news/rss.aspx | ||||||
42316 | 42316 | Scott DesJarlais D000616 | rep | TN | 2017-01-03 | 2019-01-03 | Republican | 4 | https://desjarlais.house.gov | 2301 Rayburn House Office Building; Washington DC 20515-4204 | 202-225-6831 | 202-226-5172 | 2301 Rayburn House Office Building | http://desjarlais.house.gov/news/rss.aspx | |||||||
42317 | 42317 | Scott DesJarlais D000616 | rep | TN | 2019-01-03 | 2021-01-03 | Republican | 4 | https://desjarlais.house.gov | 2301 Rayburn House Office Building Washington DC 20515-4204 | 202-225-6831 | 2301 Rayburn House Office Building | http://desjarlais.house.gov/news/rss.aspx | ||||||||
42318 | 42318 | Scott DesJarlais D000616 | rep | TN | 2021-01-03 | 2023-01-03 | Republican | 4 | https://desjarlais.house.gov | 2304 Rayburn House Office Building Washington DC 20515-4204 | 202-225-6831 | 2304 Rayburn House Office Building | http://desjarlais.house.gov/news/rss.aspx | ||||||||
42319 | 42319 | Mario Diaz-Balart D000600 | rep | FL | 2003-01-07 | 2005-01-03 | Republican | 25 | http://www.house.gov/mariodiaz-balart | ||||||||||||
42320 | 42320 | Mario Diaz-Balart D000600 | rep | FL | 2005-01-04 | 2007-01-03 | Republican | 25 | http://www.house.gov/mariodiaz-balart | ||||||||||||
42321 | 42321 | Mario Diaz-Balart D000600 | rep | FL | 2007-01-04 | 2009-01-03 | Republican | 25 | http://www.house.gov/mariodiaz-balart | ||||||||||||
42322 | 42322 | Mario Diaz-Balart D000600 | rep | FL | 2009-01-06 | 2011-01-03 | Republican | 25 | http://www.house.gov/mariodiaz-balart | ||||||||||||
42323 | 42323 | Mario Diaz-Balart D000600 | rep | FL | 2011-01-05 | 2013-01-03 | Republican | 21 | http://www.house.gov/mariodiaz-balart | 436 Cannon HOB; Washington DC 20515-0921 | 202-225-4211 | 202-225-8576 | Http://mariodiaz-balart.house.gov//index.cfm?sectionid=11 | 436 Cannon House Office Building | |||||||
42324 | 42324 | Mario Diaz-Balart D000600 | rep | FL | 2013-01-03 | 2015-01-03 | Republican | 25 | http://mariodiazbalart.house.gov | 436 Cannon HOB; Washington DC 20515-0925 | 202-225-4211 | 202-225-8576 | http://mariodiazbalart.house.gov/contact-mario/write-rep-diaz-balart | 436 Cannon House Office Building | http://mariodiazbalart.house.gov/rss.xml | ||||||
42325 | 42325 | Mario Diaz-Balart D000600 | rep | FL | 2015-01-06 | 2017-01-03 | Republican | 25 | http://mariodiazbalart.house.gov | 440 Cannon HOB; Washington DC 20515-0925 | 202-225-4211 | 202-225-8576 | http://mariodiazbalart.house.gov/contact-mario/write-rep-diaz-balart | 440 Cannon House Office Building | http://mariodiazbalart.house.gov/rss.xml | ||||||
42326 | 42326 | Mario Diaz-Balart D000600 | rep | FL | 2017-01-03 | 2019-01-03 | Republican | 25 | https://mariodiazbalart.house.gov | 440 Cannon House Office Building; Washington DC 20515-0925 | 202-225-4211 | 202-225-8576 | 440 Cannon House Office Building | http://mariodiazbalart.house.gov/rss.xml | |||||||
42327 | 42327 | Mario Diaz-Balart D000600 | rep | FL | 2019-01-03 | 2021-01-03 | Republican | 25 | https://mariodiazbalart.house.gov | 404 Cannon House Office Building Washington DC 20515-0925 | 202-225-4211 | 404 Cannon House Office Building | http://mariodiazbalart.house.gov/rss.xml | ||||||||
42328 | 42328 | Mario Diaz-Balart D000600 | rep | FL | 2021-01-03 | 2023-01-03 | Republican | 25 | https://mariodiazbalart.house.gov | 374 Cannon House Office Building Washington DC 20515-0925 | 202-225-4211 | 374 Cannon House Office Building | http://mariodiazbalart.house.gov/rss.xml | ||||||||
42329 | 42329 | Lloyd Doggett D000399 | rep | TX | 1995-01-04 | 1997-01-03 | Democrat | 10 | |||||||||||||
42330 | 42330 | Lloyd Doggett D000399 | rep | TX | 1997-01-07 | 1999-01-03 | Democrat | 10 | |||||||||||||
42331 | 42331 | Lloyd Doggett D000399 | rep | TX | 1999-01-06 | 2001-01-03 | Democrat | 10 | |||||||||||||
42332 | 42332 | Lloyd Doggett D000399 | rep | TX | 2001-01-03 | 2003-01-03 | Democrat | 10 | |||||||||||||
42333 | 42333 | Lloyd Doggett D000399 | rep | TX | 2003-01-07 | 2005-01-03 | Democrat | 10 | http://www.house.gov/doggett | ||||||||||||
42334 | 42334 | Lloyd Doggett D000399 | rep | TX | 2005-01-04 | 2007-01-03 | Democrat | 25 | http://www.house.gov/doggett | ||||||||||||
42335 | 42335 | Lloyd Doggett D000399 | rep | TX | 2007-01-04 | 2009-01-03 | Democrat | 25 | http://www.house.gov/doggett | ||||||||||||
42336 | 42336 | Lloyd Doggett D000399 | rep | TX | 2009-01-06 | 2011-01-03 | Democrat | 25 | http://www.house.gov/doggett | ||||||||||||
42337 | 42337 | Lloyd Doggett D000399 | rep | TX | 2011-01-05 | 2013-01-03 | Democrat | 25 | http://www.house.gov/doggett | 201 Cannon HOB; Washington DC 20515-4325 | 202-225-4865 | 202-225-3073 | http://www.house.gov/doggett/doggett_ima/doggett_get_address.shtml | 201 Cannon 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);