legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
1,157 rows where state = "MO" sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: class, district, phone, contact_form, office, state_rank, rss_url, start (date), end (date)
party 15 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
44504 | 44504 | Cori Bush B001224 | rep | MO | 2021-01-03 | 2023-01-03 | Democrat | 1 | https://bush.house.gov | 563 Cannon House Office Building Washington DC 20515-2501 | 202-225-2406 | 563 Cannon House Office Building | |||||||||
44416 | 44416 | Joshua Hawley H001089 | sen | MO | 2019-01-03 | 2025-01-03 | 1 | Republican | https://www.hawley.senate.gov | 115 Russell Senate Office Building Washington DC 20510 | 202-224-6154 | https://www.hawley.senate.gov/contact-senator-hawley | 115 Russell Senate Office Building | junior | |||||||
43917 | 43917 | Jason Smith S001195 | rep | MO | 2021-01-03 | 2023-01-03 | Republican | 8 | https://jasonsmith.house.gov | 2418 Rayburn House Office Building Washington DC 20515-2508 | 202-225-4404 | 2418 Rayburn House Office Building | http://jasonsmith.house.gov/rss.xml | ||||||||
43916 | 43916 | Jason Smith S001195 | rep | MO | 2019-01-03 | 2021-01-03 | Republican | 8 | https://jasonsmith.house.gov | 2418 Rayburn House Office Building Washington DC 20515-2508 | 202-225-4404 | 2418 Rayburn House Office Building | http://jasonsmith.house.gov/rss.xml | ||||||||
43915 | 43915 | Jason Smith S001195 | rep | MO | 2017-01-03 | 2019-01-03 | Republican | 8 | https://jasonsmith.house.gov | 1118 Longworth House Office Building; Washington DC 20515-2508 | 202-225-4404 | 202-226-0326 | 1118 Longworth House Office Building | http://jasonsmith.house.gov/rss.xml | |||||||
43914 | 43914 | Jason Smith S001195 | rep | MO | 2015-01-06 | 2017-01-03 | Republican | 8 | http://jasonsmith.house.gov | 1118 Longworth HOB; Washington DC 20515-2508 | 202-225-4404 | 202-226-0326 | https://jasonsmith.house.gov/contact/email-me | 1118 Longworth House Office Building | http://jasonsmith.house.gov/rss.xml | ||||||
43913 | 43913 | Jason Smith S001195 | rep | MO | 2013-06-04 | 2015-01-03 | Republican | 8 | http://jasonsmith.house.gov | 2230 Rayburn HOB; Washington DC 20515-2508 | 202-225-4404 | 202-226-0326 | https://jasonsmith.house.gov/contact/email-me | 2230 Rayburn House Office Building | http://jasonsmith.house.gov/rss.xml | ||||||
43799 | 43799 | Ann Wagner W000812 | rep | MO | 2021-01-03 | 2023-01-03 | Republican | 2 | https://wagner.house.gov | 2350 Rayburn House Office Building Washington DC 20515-2502 | 202-225-1621 | 2350 Rayburn House Office Building | http://wagner.house.gov/rss.xml | ||||||||
43798 | 43798 | Ann Wagner W000812 | rep | MO | 2019-01-03 | 2021-01-03 | Republican | 2 | https://wagner.house.gov | 2350 Rayburn House Office Building Washington DC 20515-2502 | 202-225-1621 | 2350 Rayburn House Office Building | http://wagner.house.gov/rss.xml | ||||||||
43797 | 43797 | Ann Wagner W000812 | rep | MO | 2017-01-03 | 2019-01-03 | Republican | 2 | https://wagner.house.gov | 435 Cannon House Office Building; Washington DC 20515-2502 | 202-225-1621 | 202-225-2563 | 435 Cannon House Office Building | http://wagner.house.gov/rss.xml | |||||||
43796 | 43796 | Ann Wagner W000812 | rep | MO | 2015-01-06 | 2017-01-03 | Republican | 2 | http://wagner.house.gov | 435 Cannon HOB; Washington DC 20515-2502 | 202-225-1621 | https://wagner.house.gov/contact/email-me | 435 Cannon House Office Building | http://wagner.house.gov/rss.xml | |||||||
43795 | 43795 | Ann Wagner W000812 | rep | MO | 2013-01-03 | 2015-01-03 | Republican | 2 | http://wagner.house.gov | 435 Cannon HOB; Washington DC 20515-2502 | 202-225-1621 | https://wagner.house.gov/contact/email-me | 435 Cannon House Office Building | http://wagner.house.gov/rss.xml | |||||||
42781 | 42781 | Blaine Luetkemeyer L000569 | rep | MO | 2021-01-03 | 2023-01-03 | Republican | 3 | https://luetkemeyer.house.gov | 2230 Rayburn House Office Building Washington DC 20515-2503 | 202-225-2956 | 2230 Rayburn House Office Building | http://luetkemeyer.house.gov/news/rss.aspx | ||||||||
42780 | 42780 | Blaine Luetkemeyer L000569 | rep | MO | 2019-01-03 | 2021-01-03 | Republican | 3 | https://luetkemeyer.house.gov | 2230 Rayburn House Office Building Washington DC 20515-2503 | 202-225-2956 | 2230 Rayburn House Office Building | http://luetkemeyer.house.gov/news/rss.aspx | ||||||||
42779 | 42779 | Blaine Luetkemeyer L000569 | rep | MO | 2017-01-03 | 2019-01-03 | Republican | 3 | https://luetkemeyer.house.gov | 2230 Rayburn House Office Building; Washington DC 20515-2503 | 202-225-2956 | 202-225-5712 | 2230 Rayburn House Office Building | http://luetkemeyer.house.gov/news/rss.aspx | |||||||
42778 | 42778 | Blaine Luetkemeyer L000569 | rep | MO | 2015-01-06 | 2017-01-03 | Republican | 3 | http://luetkemeyer.house.gov | 2440 Rayburn HOB; Washington DC 20515-2503 | 202-225-2956 | 202-225-5712 | https://luetkemeyer.house.gov/forms/writeyourrep/ | 2440 Rayburn House Office Building | http://luetkemeyer.house.gov/news/rss.aspx | ||||||
42777 | 42777 | Blaine Luetkemeyer L000569 | rep | MO | 2013-01-03 | 2015-01-03 | Republican | 3 | http://luetkemeyer.house.gov | 2440 Rayburn HOB; Washington DC 20515-2503 | 202-225-2956 | 202-225-5712 | https://luetkemeyer.house.gov/forms/writeyourrep/ | 2440 Rayburn House Office Building | http://luetkemeyer.house.gov/news/rss.aspx | ||||||
42776 | 42776 | Blaine Luetkemeyer L000569 | rep | MO | 2011-01-05 | 2013-01-03 | Republican | 9 | http://luetkemeyer.house.gov | 1740 Longworth HOB; Washington DC 20515-2509 | 202-225-2956 | 202-225-5712 | https://forms.house.gov/luetkemeyer/contact-form.shtml | 1740 Longworth House Office Building | |||||||
42775 | 42775 | Blaine Luetkemeyer L000569 | rep | MO | 2009-01-06 | 2011-01-03 | Republican | 9 | http://luetkemeyer.house.gov | ||||||||||||
42759 | 42759 | Billy Long L000576 | rep | MO | 2021-01-03 | 2023-01-03 | Republican | 7 | https://long.house.gov | 2454 Rayburn House Office Building Washington DC 20515-2507 | 202-225-6536 | 2454 Rayburn House Office Building | http://long.house.gov/common/rss//index.cfm?rss=49 | ||||||||
42758 | 42758 | Billy Long L000576 | rep | MO | 2019-01-03 | 2021-01-03 | Republican | 7 | https://long.house.gov | 2454 Rayburn House Office Building Washington DC 20515-2507 | 202-225-6536 | 2454 Rayburn House Office Building | http://long.house.gov/common/rss//index.cfm?rss=49 | ||||||||
42757 | 42757 | Billy Long L000576 | rep | MO | 2017-01-03 | 2019-01-03 | Republican | 7 | https://long.house.gov | 2454 Rayburn House Office Building; Washington DC 20515-2507 | 202-225-6536 | 202-225-5604 | 2454 Rayburn House Office Building | http://long.house.gov/common/rss//index.cfm?rss=49 | |||||||
42756 | 42756 | Billy Long L000576 | rep | MO | 2015-01-06 | 2017-01-03 | Republican | 7 | http://long.house.gov | 1541 Longworth HOB; Washington DC 20515-2507 | 202-225-6536 | 202-225-5604 | https://longforms.house.gov/email-billy | 1541 Longworth House Office Building | http://long.house.gov/common/rss//index.cfm?rss=49 | ||||||
42755 | 42755 | Billy Long L000576 | rep | MO | 2013-01-03 | 2015-01-03 | Republican | 7 | http://long.house.gov | 1541 Longworth HOB; Washington DC 20515-2507 | 202-225-6536 | 202-225-5604 | https://longforms.house.gov/email-billy | 1541 Longworth House Office Building | http://long.house.gov/common/rss//index.cfm?rss=49 | ||||||
42754 | 42754 | Billy Long L000576 | rep | MO | 2011-01-05 | 2013-01-03 | Republican | 7 | http://long.house.gov/ | 1541 Longworth HOB; Washington DC 20515-2507 | 202-225-6536 | 202-225-5604 | 1541 Longworth House Office Building | ||||||||
42498 | 42498 | Vicky Hartzler H001053 | rep | MO | 2021-01-03 | 2023-01-03 | Republican | 4 | https://hartzler.house.gov | 2235 Rayburn House Office Building Washington DC 20515-2504 | 202-225-2876 | 2235 Rayburn House Office Building | http://hartzler.house.gov/rss.xml | ||||||||
42497 | 42497 | Vicky Hartzler H001053 | rep | MO | 2019-01-03 | 2021-01-03 | Republican | 4 | https://hartzler.house.gov | 2235 Rayburn House Office Building Washington DC 20515-2504 | 202-225-2876 | 2235 Rayburn House Office Building | http://hartzler.house.gov/rss.xml | ||||||||
42496 | 42496 | Vicky Hartzler H001053 | rep | MO | 2017-01-03 | 2019-01-03 | Republican | 4 | https://hartzler.house.gov | 2235 Rayburn House Office Building; Washington DC 20515-2504 | 202-225-2876 | 202-225-0148 | 2235 Rayburn House Office Building | http://hartzler.house.gov/rss.xml | |||||||
42495 | 42495 | Vicky Hartzler H001053 | rep | MO | 2015-01-06 | 2017-01-03 | Republican | 4 | http://hartzler.house.gov | 2235 Rayburn HOB; Washington DC 20515-2504 | 202-225-2876 | 202-225-0148 | https://hartzler.house.gov/contact-me/email-me | 2235 Rayburn House Office Building | http://hartzler.house.gov/rss.xml | ||||||
42494 | 42494 | Vicky Hartzler H001053 | rep | MO | 2013-01-03 | 2015-01-03 | Republican | 4 | http://hartzler.house.gov | 1023 Longworth HOB; Washington DC 20515-2504 | 202-225-2876 | 202-225-0148 | https://hartzler.house.gov/contact-me/email-me | 1023 Longworth House Office Building | http://hartzler.house.gov/rss.xml | ||||||
42493 | 42493 | Vicky Hartzler H001053 | rep | MO | 2011-01-05 | 2013-01-03 | Republican | 4 | http://hartzler.house.gov/ | 1023 Longworth HOB; Washington DC 20515-2504 | 202-225-2876 | 202-225-2695 | 1023 Longworth House Office Building | ||||||||
42454 | 42454 | Sam Graves G000546 | rep | MO | 2021-01-03 | 2023-01-03 | Republican | 6 | https://graves.house.gov | 1135 Longworth House Office Building Washington DC 20515-2506 | 202-225-7041 | 1135 Longworth House Office Building | http://graves.house.gov/common/rss/index.cfm?rss=25 | ||||||||
42453 | 42453 | Sam Graves G000546 | rep | MO | 2019-01-03 | 2021-01-03 | Republican | 6 | https://graves.house.gov | 1135 Longworth House Office Building Washington DC 20515-2506 | 202-225-7041 | 1135 Longworth House Office Building | http://graves.house.gov/common/rss/index.cfm?rss=25 | ||||||||
42452 | 42452 | Sam Graves G000546 | rep | MO | 2017-01-03 | 2019-01-03 | Republican | 6 | https://graves.house.gov | 1135 Longworth House Office Building; Washington DC 20515-2506 | 202-225-7041 | 202-225-8221 | 1135 Longworth House Office Building | http://graves.house.gov/common/rss/index.cfm?rss=25 | |||||||
42451 | 42451 | Sam Graves G000546 | rep | MO | 2015-01-06 | 2017-01-03 | Republican | 6 | https://graves.house.gov | 1415 Longworth HOB; Washington DC 20515-2506 | 202-225-7041 | 202-225-8221 | https://gravesforms.house.gov/email-sam | 1415 Longworth House Office Building | http://graves.house.gov/common/rss/index.cfm?rss=25 | ||||||
42450 | 42450 | Sam Graves G000546 | rep | MO | 2013-01-03 | 2015-01-03 | Republican | 6 | http://graves.house.gov | 1415 Longworth HOB; Washington DC 20515-2506 | 202-225-7041 | 202-225-8221 | https://gravesforms.house.gov/email-sam | 1415 Longworth House Office Building | http://graves.house.gov/common/rss/index.cfm?rss=25 | ||||||
42449 | 42449 | Sam Graves G000546 | rep | MO | 2011-01-05 | 2013-01-03 | Republican | 6 | http://www.house.gov/graves | 1415 Longworth HOB; Washington DC 20515-2506 | 202-225-7041 | 202-225-8221 | http://www.house.gov/graves/contact.shtml | 1415 Longworth House Office Building | |||||||
42448 | 42448 | Sam Graves G000546 | rep | MO | 2009-01-06 | 2011-01-03 | Republican | 6 | http://www.house.gov/graves | ||||||||||||
42447 | 42447 | Sam Graves G000546 | rep | MO | 2007-01-04 | 2009-01-03 | Republican | 6 | http://www.house.gov/graves | ||||||||||||
42446 | 42446 | Sam Graves G000546 | rep | MO | 2005-01-04 | 2007-01-03 | Republican | 6 | http://www.house.gov/graves | ||||||||||||
42445 | 42445 | Sam Graves G000546 | rep | MO | 2003-01-07 | 2005-01-03 | Republican | 6 | http://www.house.gov/graves | ||||||||||||
42444 | 42444 | Sam Graves G000546 | rep | MO | 2001-01-03 | 2003-01-03 | Republican | 6 | |||||||||||||
42157 | 42157 | Emanuel Cleaver C001061 | rep | MO | 2021-01-03 | 2023-01-03 | Democrat | 5 | https://cleaver.house.gov | 2335 Rayburn House Office Building Washington DC 20515-2505 | 202-225-4535 | 2335 Rayburn House Office Building | http://cleaver.house.gov/rss.xml | ||||||||
42156 | 42156 | Emanuel Cleaver C001061 | rep | MO | 2019-01-03 | 2021-01-03 | Democrat | 5 | https://cleaver.house.gov | 2335 Rayburn House Office Building Washington DC 20515-2505 | 202-225-4535 | 2335 Rayburn House Office Building | http://cleaver.house.gov/rss.xml | ||||||||
42155 | 42155 | Emanuel Cleaver C001061 | rep | MO | 2017-01-03 | 2019-01-03 | Democrat | 5 | https://cleaver.house.gov | 2335 Rayburn House Office Building; Washington DC 20515-2505 | 202-225-4535 | 202-225-4403 | 2335 Rayburn House Office Building | http://cleaver.house.gov/rss.xml | |||||||
42154 | 42154 | Emanuel Cleaver C001061 | rep | MO | 2015-01-06 | 2017-01-03 | Democrat | 5 | http://cleaver.house.gov | 2335 Rayburn HOB; Washington DC 20515-2505 | 202-225-4535 | 202-225-4403 | https://cleaver.house.gov/contact/email-me | 2335 Rayburn House Office Building | http://cleaver.house.gov/rss.xml | ||||||
42153 | 42153 | Emanuel Cleaver C001061 | rep | MO | 2013-01-03 | 2015-01-03 | Democrat | 5 | http://cleaver.house.gov | 2335 Rayburn HOB; Washington DC 20515-2505 | 202-225-4535 | 202-225-4403 | https://cleaver.house.gov/contact/email-me | 2335 Rayburn House Office Building | http://cleaver.house.gov/rss.xml | ||||||
42152 | 42152 | Emanuel Cleaver C001061 | rep | MO | 2011-01-05 | 2013-01-03 | Democrat | 5 | http://www.house.gov/cleaver | 1433 Longworth HOB; Washington DC 20515-2505 | 202-225-4535 | 202-225-4403 | http://www.house.gov/cleaver/IMA/issue.htm | 1433 Longworth House Office Building | |||||||
42151 | 42151 | Emanuel Cleaver C001061 | rep | MO | 2009-01-06 | 2011-01-03 | Democrat | 5 | http://www.house.gov/cleaver | ||||||||||||
42150 | 42150 | Emanuel Cleaver C001061 | rep | MO | 2007-01-04 | 2009-01-03 | Democrat | 5 | http://www.house.gov/cleaver | ||||||||||||
42149 | 42149 | Emanuel Cleaver C001061 | rep | MO | 2005-01-04 | 2007-01-03 | Democrat | 5 | |||||||||||||
41991 | 41991 | Roy Blunt B000575 | sen | MO | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.blunt.senate.gov | 260 Russell Senate Office Building Washington DC 20510 | 202-224-5721 | 202-224-8149 | https://www.blunt.senate.gov/public/index.cfm/contact-roy | 260 Russell Senate Office Building | senior | http://www.blunt.senate.gov/public/?a=rss.feed | |||||
41990 | 41990 | Roy Blunt B000575 | sen | MO | 2011-01-05 | 2017-01-03 | 3 | Republican | http://www.blunt.senate.gov | 260 Russell Senate Office Building Washington DC 20510 | 202-224-5721 | 202-224-8149 | http://www.blunt.senate.gov/public/index.cfm/contact-form?p=contact-roy | 260 Russell Senate Office Building | junior | http://www.blunt.senate.gov/public/?a=rss.feed | |||||
41989 | 41989 | Roy Blunt B000575 | rep | MO | 2009-01-06 | 2011-01-03 | Republican | 7 | http://blunt.house.gov/ | ||||||||||||
41988 | 41988 | Roy Blunt B000575 | rep | MO | 2007-01-04 | 2009-01-03 | Republican | 7 | http://www.house.gov/blunt | ||||||||||||
41987 | 41987 | Roy Blunt B000575 | rep | MO | 2005-01-04 | 2007-01-03 | Republican | 7 | http://www.house.gov/blunt | ||||||||||||
41986 | 41986 | Roy Blunt B000575 | rep | MO | 2003-01-07 | 2005-01-03 | Republican | 7 | http://www.house.gov/blunt | ||||||||||||
41985 | 41985 | Roy Blunt B000575 | rep | MO | 2001-01-03 | 2003-01-03 | Republican | 7 | |||||||||||||
41984 | 41984 | Roy Blunt B000575 | rep | MO | 1999-01-06 | 2001-01-03 | Republican | 7 | |||||||||||||
41983 | 41983 | Roy Blunt B000575 | rep | MO | 1997-01-07 | 1999-01-03 | Republican | 7 | |||||||||||||
41308 | 41308 | Wm. Clay C001049 | rep | MO | 2019-01-03 | 2021-01-03 | Democrat | 1 | https://lacyclay.house.gov | 2428 Rayburn House Office Building Washington DC 20515-2501 | 202-225-2406 | 2428 Rayburn House Office Building | |||||||||
41307 | 41307 | Wm. Clay C001049 | rep | MO | 2017-01-03 | 2019-01-03 | Democrat | 1 | https://lacyclay.house.gov | 2428 Rayburn House Office Building; Washington DC 20515-2501 | 202-225-2406 | 202-226-3717 | 2428 Rayburn House Office Building | ||||||||
41306 | 41306 | Wm. Clay C001049 | rep | MO | 2015-01-06 | 2017-01-03 | Democrat | 1 | http://lacyclay.house.gov | 2428 Rayburn HOB; Washington DC 20515-2501 | 202-225-2406 | 202-226-3717 | http://lacyclay.house.gov/contact-form/ | 2428 Rayburn House Office Building | |||||||
41305 | 41305 | Wm. Clay C001049 | rep | MO | 2013-01-03 | 2015-01-03 | Democrat | 1 | http://lacyclay.house.gov | 2418 Rayburn HOB; Washington DC 20515-2501 | 202-225-2406 | 202-226-3717 | http://lacyclay.house.gov/contact-form/ | 2418 Rayburn House Office Building | |||||||
41304 | 41304 | Wm. Clay C001049 | rep | MO | 2011-01-05 | 2013-01-03 | Democrat | 1 | http://www.house.gov/clay | 2418 Rayburn HOB; Washington DC 20515-2501 | 202-225-2406 | 202-226-3717 | http://lacyclay.house.gov/contact.htm | 2418 Rayburn House Office Building | |||||||
41303 | 41303 | Wm. Clay C001049 | rep | MO | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://www.house.gov/clay | ||||||||||||
41302 | 41302 | Wm. Clay C001049 | rep | MO | 2007-01-04 | 2009-01-03 | Democrat | 1 | http://www.house.gov/clay | ||||||||||||
41301 | 41301 | Wm. Clay C001049 | rep | MO | 2005-01-04 | 2007-01-03 | Democrat | 1 | http://www.house.gov/clay | ||||||||||||
41300 | 41300 | Wm. Clay C001049 | rep | MO | 2003-01-07 | 2005-01-03 | Democrat | 1 | http://www.house.gov/clay | ||||||||||||
41299 | 41299 | Wm. Clay C001049 | rep | MO | 2001-01-03 | 2003-01-03 | Democrat | 1 | |||||||||||||
40680 | 40680 | Claire McCaskill M001170 | sen | MO | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.mccaskill.senate.gov | 503 Hart Senate Office Building Washington DC 20510 | 202-224-6154 | 202-228-6326 | http://www.mccaskill.senate.gov/contact | 503 Hart Senate Office Building | senior | http://mccaskill.senate.gov/rss/?p=news | |||||
40679 | 40679 | Claire McCaskill M001170 | sen | MO | 2007-01-04 | 2013-01-03 | 1 | Democrat | http://mccaskill.senate.gov/ | 506 HART SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-6154 | 202-228-6326 | http://www.mccaskill.senate.gov/?p=contact | 506 Hart Senate Office Building | |||||||
39597 | 39597 | Jo Ann Emerson E000172 | rep | MO | 2013-01-03 | 2013-01-22 | Republican | 8 | http://emerson.house.gov | 2230 Rayburn HOB; Washington DC 20515-2508 | 202-225-4404 | 202-226-0326 | http://www.house.gov/emerson/contact/ | 2230 Rayburn House Office Building | |||||||
39596 | 39596 | Jo Ann Emerson E000172 | rep | MO | 2011-01-05 | 2013-01-03 | Republican | 8 | http://www.house.gov/emerson | 2230 Rayburn HOB; Washington DC 20515-2508 | 202-225-4404 | 202-226-0326 | http://www.house.gov/emerson/contact/ | 2230 Rayburn House Office Building | |||||||
39595 | 39595 | Jo Ann Emerson E000172 | rep | MO | 2009-01-06 | 2011-01-03 | Republican | 8 | http://www.house.gov/emerson | ||||||||||||
39594 | 39594 | Jo Ann Emerson E000172 | rep | MO | 2007-01-04 | 2009-01-03 | Republican | 8 | http://www.house.gov/emerson | ||||||||||||
39593 | 39593 | Jo Ann Emerson E000172 | rep | MO | 2005-01-04 | 2007-01-03 | Republican | 8 | http://www.house.gov/emerson | ||||||||||||
39592 | 39592 | Jo Ann Emerson E000172 | rep | MO | 2003-01-07 | 2005-01-03 | Republican | 8 | http://www.house.gov/emerson | ||||||||||||
39591 | 39591 | Jo Ann Emerson E000172 | rep | MO | 2001-01-03 | 2003-01-03 | Republican | 8 | |||||||||||||
39590 | 39590 | Jo Ann Emerson E000172 | rep | MO | 1999-01-06 | 2001-01-03 | Republican | 8 | |||||||||||||
39589 | 39589 | Jo Ann Emerson E000172 | rep | MO | 1997-01-07 | 1999-01-03 | Republican | 8 | [ { "start": "1997-01-07", "end": "1997-01-08", "party": "Independent" }, { "start": "1997-01-08", "end": "1999-01-03", "party": "Republican" } ] |
||||||||||||
39212 | 39212 | Russ Carnahan C001060 | rep | MO | 2011-01-05 | 2013-01-03 | Democrat | 3 | http://www.house.gov/carnahan | 1710 Longworth HOB; Washington DC 20515-2503 | 202-225-2671 | 202-225-7452 | http://carnahan.house.gov/contact.shtml | 1710 Longworth House Office Building | |||||||
39211 | 39211 | Russ Carnahan C001060 | rep | MO | 2009-01-06 | 2011-01-03 | Democrat | 3 | http://www.house.gov/carnahan | ||||||||||||
39210 | 39210 | Russ Carnahan C001060 | rep | MO | 2007-01-04 | 2009-01-03 | Democrat | 3 | http://www.house.gov/carnahan | ||||||||||||
39209 | 39209 | Russ Carnahan C001060 | rep | MO | 2005-01-04 | 2007-01-03 | Democrat | 3 | |||||||||||||
39105 | 39105 | W. Akin A000358 | rep | MO | 2011-01-05 | 2013-01-03 | Republican | 2 | http://akin.house.gov | 117 Cannon HOB; Washington DC 20515-2502 | 202-225-2561 | 202-225-2563 | http://akin.house.gov/email.shtml | 117 Cannon House Office Building | |||||||
39104 | 39104 | W. Akin A000358 | rep | MO | 2009-01-06 | 2011-01-03 | Republican | 2 | http://akin.house.gov | ||||||||||||
39103 | 39103 | W. Akin A000358 | rep | MO | 2007-01-04 | 2009-01-03 | Republican | 2 | http://akin.house.gov | ||||||||||||
39102 | 39102 | W. Akin A000358 | rep | MO | 2005-01-04 | 2007-01-03 | Republican | 2 | http://www.house.gov/akin | ||||||||||||
39101 | 39101 | W. Akin A000358 | rep | MO | 2003-01-07 | 2005-01-03 | Republican | 2 | http://www.house.gov/akin | ||||||||||||
39100 | 39100 | W. Akin A000358 | rep | MO | 2001-01-03 | 2003-01-03 | Republican | 2 | |||||||||||||
38824 | 38824 | Ike Skelton S000465 | rep | MO | 2009-01-06 | 2011-01-03 | Democrat | 4 | http://www.house.gov/skelton | ||||||||||||
38823 | 38823 | Ike Skelton S000465 | rep | MO | 2007-01-04 | 2009-01-03 | Democrat | 4 | http://www.house.gov/skelton | ||||||||||||
38822 | 38822 | Ike Skelton S000465 | rep | MO | 2005-01-04 | 2007-01-03 | Democrat | 4 | http://www.house.gov/skelton | ||||||||||||
38821 | 38821 | Ike Skelton S000465 | rep | MO | 2003-01-07 | 2005-01-03 | Democrat | 4 | http://www.house.gov/skelton | ||||||||||||
38820 | 38820 | Ike Skelton S000465 | rep | MO | 2001-01-03 | 2003-01-03 | Democrat | 4 | |||||||||||||
38819 | 38819 | Ike Skelton S000465 | rep | MO | 1999-01-06 | 2001-01-03 | Democrat | 4 | |||||||||||||
38818 | 38818 | Ike Skelton S000465 | rep | MO | 1997-01-07 | 1999-01-03 | Democrat | 4 | |||||||||||||
38817 | 38817 | Ike Skelton S000465 | rep | MO | 1995-01-04 | 1997-01-03 | Democrat | 4 | |||||||||||||
38816 | 38816 | Ike Skelton S000465 | rep | MO | 1993-01-05 | 1995-01-03 | Democrat | 4 |
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);