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 district
This data as json, copyable, CSV (advanced)
Suggested facets: class, district, phone, fax, contact_form, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2557 | 2557 | David Barton B000212 | sen | MO | 1821-12-03 | 1825-03-03 | 3 | Republican | |||||||||||||
2558 | 2558 | David Barton B000212 | sen | MO | 1825-12-05 | 1831-03-03 | 3 | Adams | |||||||||||||
3324 | 3324 | Alexander Buckner B001030 | sen | MO | 1831-12-05 | 1833-12-31 | 3 | Jackson | |||||||||||||
4257 | 4257 | Lewis Linn L000338 | sen | MO | 1833-12-02 | 1837-03-03 | 3 | Jackson | |||||||||||||
4258 | 4258 | Lewis Linn L000338 | sen | MO | 1837-09-04 | 1843-03-03 | 3 | Democrat | |||||||||||||
5897 | 5897 | David Atchison A000322 | sen | MO | 1843-12-04 | 1849-03-03 | 3 | Democrat | |||||||||||||
5898 | 5898 | David Atchison A000322 | sen | MO | 1849-12-03 | 1855-03-03 | 3 | Democrat | |||||||||||||
6309 | 6309 | Henry Geyer G000146 | sen | MO | 1851-12-01 | 1857-03-03 | 1 | Ind. Republican-Democrat | |||||||||||||
6512 | 6512 | Thomas Benton B000398 | sen | MO | 1821-12-03 | 1827-03-03 | 1 | Jackson | |||||||||||||
6513 | 6513 | Thomas Benton B000398 | sen | MO | 1827-12-03 | 1833-03-03 | 1 | Jackson | |||||||||||||
6514 | 6514 | Thomas Benton B000398 | sen | MO | 1833-12-02 | 1839-03-03 | 1 | Democrat | |||||||||||||
6515 | 6515 | Thomas Benton B000398 | sen | MO | 1839-12-02 | 1845-03-03 | 1 | Democrat | |||||||||||||
6516 | 6516 | Thomas Benton B000398 | sen | MO | 1845-12-01 | 1851-03-03 | 1 | Democrat | |||||||||||||
7067 | 7067 | James Green G000414 | sen | MO | 1857-12-07 | 1861-03-03 | 3 | Democrat | |||||||||||||
7184 | 7184 | Trusten Polk P000411 | sen | MO | 1857-12-07 | 1863-03-03 | 1 | Democrat | |||||||||||||
7774 | 7774 | Waldo Johnson J000179 | sen | MO | 1861-07-04 | 1863-03-03 | 3 | Democrat | |||||||||||||
7897 | 7897 | John Henderson H000483 | sen | MO | 1862-01-17 | 1863-03-03 | 1 | Republican | |||||||||||||
7898 | 7898 | John Henderson H000483 | sen | MO | 1863-03-04 | 1869-03-03 | 1 | Republican | |||||||||||||
7900 | 7900 | Robert Wilson W000609 | sen | MO | 1862-01-01 | 1863-12-31 | 3 | Unionist | |||||||||||||
7921 | 7921 | Benjamin Brown B000905 | sen | MO | 1863-12-07 | 1867-03-03 | 3 | Republican | |||||||||||||
8315 | 8315 | Charles Drake D000484 | sen | MO | 1867-03-04 | 1871-03-03 | 3 | Republican | |||||||||||||
8715 | 8715 | Carl Schurz S000151 | sen | MO | 1869-03-04 | 1875-03-03 | 1 | Liberal Republican | |||||||||||||
8795 | 8795 | Daniel Jewett J000103 | sen | MO | 1870-01-01 | 1871-12-31 | 3 | Republican | |||||||||||||
8832 | 8832 | Francis Blair B000523 | sen | MO | 1871-03-04 | 1873-03-03 | 3 | Democrat | |||||||||||||
9092 | 9092 | Lewis Bogy B000595 | sen | MO | 1873-12-01 | 1877-12-31 | 3 | Democrat | |||||||||||||
9729 | 9729 | David Armstrong A000279 | sen | MO | 1877-10-15 | 1879-03-03 | 3 | Democrat | |||||||||||||
10190 | 10190 | James Shields S000362 | sen | MO | 1879-01-27 | 1879-03-03 | 3 | Democrat | |||||||||||||
13515 | 13515 | George Vest V000091 | sen | MO | 1879-03-18 | 1885-03-03 | 3 | Democrat | |||||||||||||
13516 | 13516 | George Vest V000091 | sen | MO | 1885-12-07 | 1891-03-03 | 3 | Democrat | |||||||||||||
13517 | 13517 | George Vest V000091 | sen | MO | 1891-12-07 | 1897-03-03 | 3 | Democrat | |||||||||||||
13518 | 13518 | George Vest V000091 | sen | MO | 1897-03-15 | 1903-03-03 | 3 | Democrat | |||||||||||||
13616 | 13616 | Francis Cockrell C000576 | sen | MO | 1875-12-06 | 1881-03-03 | 1 | Democrat | |||||||||||||
13617 | 13617 | Francis Cockrell C000576 | sen | MO | 1881-12-05 | 1887-03-03 | 1 | Democrat | |||||||||||||
13618 | 13618 | Francis Cockrell C000576 | sen | MO | 1887-12-05 | 1893-03-03 | 1 | Democrat | |||||||||||||
13619 | 13619 | Francis Cockrell C000576 | sen | MO | 1893-08-07 | 1899-03-03 | 1 | Democrat | |||||||||||||
13620 | 13620 | Francis Cockrell C000576 | sen | MO | 1899-12-04 | 1905-03-03 | 1 | Democrat | |||||||||||||
14944 | 14944 | William Warner W000160 | sen | MO | 1905-12-04 | 1911-03-03 | 1 | Republican | |||||||||||||
17018 | 17018 | William Stone S000968 | sen | MO | 1903-11-09 | 1909-03-03 | 3 | Democrat | |||||||||||||
17019 | 17019 | William Stone S000968 | sen | MO | 1909-03-15 | 1915-03-03 | 3 | Democrat | |||||||||||||
17020 | 17020 | William Stone S000968 | sen | MO | 1915-12-06 | 1919-03-03 | 3 | Democrat | |||||||||||||
17531 | 17531 | Xenophon Wilfley W000471 | sen | MO | 1918-04-30 | 1919-03-03 | 3 | Democrat | appointment | ||||||||||||
18491 | 18491 | Selden Spencer S000730 | sen | MO | 1918-01-01 | 1921-03-03 | 3 | Republican | |||||||||||||
18492 | 18492 | Selden Spencer S000730 | sen | MO | 1921-04-11 | 1925-12-31 | 3 | Republican | |||||||||||||
18810 | 18810 | James Reed R000118 | sen | MO | 1911-04-04 | 1917-03-03 | 1 | Democrat | |||||||||||||
18811 | 18811 | James Reed R000118 | sen | MO | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
18812 | 18812 | James Reed R000118 | sen | MO | 1923-12-03 | 1929-03-03 | 1 | Democrat | |||||||||||||
19166 | 19166 | George Williams W000499 | sen | MO | 1925-12-07 | 1927-03-04 | 3 | Republican | appointment | ||||||||||||
19182 | 19182 | Harry Hawes H000362 | sen | MO | 1926-12-06 | 1927-03-04 | 3 | Democrat | |||||||||||||
19183 | 19183 | Harry Hawes H000362 | sen | MO | 1927-12-05 | 1933-02-03 | 3 | Democrat | |||||||||||||
19923 | 19923 | Roscoe Patterson P000127 | sen | MO | 1929-04-15 | 1935-01-03 | 1 | Republican | |||||||||||||
22524 | 22524 | Joel Clark C000440 | sen | MO | 1933-03-09 | 1939-01-03 | 3 | Democrat | |||||||||||||
22525 | 22525 | Joel Clark C000440 | sen | MO | 1939-01-03 | 1945-01-03 | 3 | Democrat | |||||||||||||
23787 | 23787 | Frank Briggs B000828 | sen | MO | 1945-01-18 | 1947-01-03 | 1 | Democrat | appointment | ||||||||||||
23838 | 23838 | Forrest Donnell D000414 | sen | MO | 1945-01-03 | 1951-01-03 | 3 | Republican | |||||||||||||
24229 | 24229 | Harry Truman T000387 | sen | MO | 1935-01-03 | 1941-01-03 | 1 | Democrat | |||||||||||||
24230 | 24230 | Harry Truman T000387 | sen | MO | 1941-01-03 | 1945-12-31 | 1 | Democrat | |||||||||||||
24513 | 24513 | James Kem K000082 | sen | MO | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
26381 | 26381 | Thomas Hennings H000502 | sen | MO | 1951-01-03 | 1957-01-03 | 3 | Democrat | |||||||||||||
26382 | 26382 | Thomas Hennings H000502 | sen | MO | 1957-01-03 | 1960-09-13 | 3 | Democrat | |||||||||||||
27995 | 27995 | Edward Long L000415 | sen | MO | 1960-09-23 | 1963-01-03 | 3 | Democrat | appointment | ||||||||||||
27996 | 27996 | Edward Long L000415 | sen | MO | 1963-01-09 | 1968-12-27 | 3 | Democrat | |||||||||||||
30101 | 30101 | William Symington S001136 | sen | MO | 1953-01-03 | 1959-01-03 | 1 | Democrat | |||||||||||||
30102 | 30102 | William Symington S001136 | sen | MO | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
30103 | 30103 | William Symington S001136 | sen | MO | 1965-01-04 | 1971-01-03 | 1 | Democrat | |||||||||||||
30104 | 30104 | William Symington S001136 | sen | MO | 1971-01-21 | 1976-12-27 | 1 | Democrat | |||||||||||||
32611 | 32611 | Thomas Eagleton E000004 | sen | MO | 1968-12-28 | 1969-01-03 | 3 | Democrat | |||||||||||||
32612 | 32612 | Thomas Eagleton E000004 | sen | MO | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
32613 | 32613 | Thomas Eagleton E000004 | sen | MO | 1975-01-14 | 1981-01-03 | 3 | Democrat | |||||||||||||
32614 | 32614 | Thomas Eagleton E000004 | sen | MO | 1981-01-05 | 1987-01-03 | 3 | Democrat | |||||||||||||
33873 | 33873 | John Danforth D000030 | sen | MO | 1976-12-27 | 1977-01-03 | 1 | Republican | |||||||||||||
33874 | 33874 | John Danforth D000030 | sen | MO | 1977-01-04 | 1983-01-03 | 1 | Republican | |||||||||||||
33875 | 33875 | John Danforth D000030 | sen | MO | 1983-01-03 | 1989-01-03 | 1 | Republican | |||||||||||||
33876 | 33876 | John Danforth D000030 | sen | MO | 1989-01-03 | 1995-01-03 | 1 | Republican | |||||||||||||
35680 | 35680 | John Ashcroft A000356 | sen | MO | 1995-01-04 | 2001-01-03 | 1 | Republican | |||||||||||||
36854 | 36854 | Jean Carnahan C001043 | sen | MO | 2001-01-03 | 2003-01-03 | 1 | Democrat | appointment | ||||||||||||
37221 | 37221 | James Talent T000024 | sen | MO | 2002-11-25 | 2007-01-03 | 1 | Republican | http://talent.senate.gov/ | ||||||||||||
37544 | 37544 | Christopher Bond B000611 | sen | MO | 1987-01-06 | 1993-01-03 | 3 | Republican | |||||||||||||
37545 | 37545 | Christopher Bond B000611 | sen | MO | 1993-01-05 | 1999-01-03 | 3 | Republican | |||||||||||||
37546 | 37546 | Christopher Bond B000611 | sen | MO | 1999-01-06 | 2005-01-03 | 3 | Republican | http://bond.senate.gov/ | ||||||||||||
37547 | 37547 | Christopher Bond B000611 | sen | MO | 2005-01-04 | 2011-01-03 | 3 | Republican | http://bond.senate.gov | ||||||||||||
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 | |||||||
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 | |||||
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 | |||||
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 | |||||
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 | |||||||
1349 | 1349 | Edward Hempstead H000472 | rep | MO | 1811-11-04 | 1813-03-03 | -1 | ||||||||||||||
1350 | 1350 | Edward Hempstead H000472 | rep | MO | 1813-05-24 | 1815-03-03 | -1 | ||||||||||||||
1551 | 1551 | Rufus Easton E000022 | rep | MO | 1813-05-24 | 1815-03-03 | -1 | ||||||||||||||
1552 | 1552 | Rufus Easton E000022 | rep | MO | 1815-12-04 | 1817-03-03 | -1 | ||||||||||||||
2714 | 2714 | John Scott S000176 | rep | MO | 1815-12-04 | 1817-03-03 | -1 | ||||||||||||||
2715 | 2715 | John Scott S000176 | rep | MO | 1817-12-01 | 1819-03-03 | -1 | ||||||||||||||
2716 | 2716 | John Scott S000176 | rep | MO | 1819-12-06 | 1821-03-03 | -1 | ||||||||||||||
3629 | 3629 | John Bull B001046 | rep | MO | 1833-12-02 | 1835-03-03 | -1 | ||||||||||||||
3838 | 3838 | William Ashley A000315 | rep | MO | 1833-12-02 | 1835-03-03 | Jacksonian | -1 | |||||||||||||
3839 | 3839 | William Ashley A000315 | rep | MO | 1835-12-07 | 1837-03-03 | Jacksonian | -1 | |||||||||||||
4500 | 4500 | Albert Harrison H000261 | rep | MO | 1835-12-07 | 1837-03-03 | Jackson | -1 | |||||||||||||
4501 | 4501 | Albert Harrison H000261 | rep | MO | 1837-09-04 | 1839-03-03 | Democrat | -1 | |||||||||||||
4502 | 4502 | Albert Harrison H000261 | rep | MO | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
4771 | 4771 | John Edwards E000076 | rep | MO | 1841-05-31 | 1843-03-03 | Democrat | -1 | |||||||||||||
4902 | 4902 | John Miller M000735 | rep | MO | 1837-09-04 | 1839-03-03 | Democrat | -1 |
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);