legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
333 rows where party = "Republican" and state = "MO"
This data as json, copyable, CSV (advanced)
Suggested facets: type, class, district, phone, fax, contact_form, office, state_rank, rss_url, start (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2557 | 2557 | David Barton B000212 | sen | MO | 1821-12-03 | 1825-03-03 | 3 | Republican | |||||||||||||
2717 | 2717 | John Scott S000176 | rep | MO | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
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 | |||||||||||||
7921 | 7921 | Benjamin Brown B000905 | sen | MO | 1863-12-07 | 1867-03-03 | 3 | Republican | |||||||||||||
8088 | 8088 | Henry Blow B000572 | rep | MO | 1865-12-04 | 1867-03-03 | Republican | 2 | |||||||||||||
8248 | 8248 | George Anderson A000188 | rep | MO | 1865-12-04 | 1867-03-03 | Republican | 9 | |||||||||||||
8249 | 8249 | George Anderson A000188 | rep | MO | 1867-03-04 | 1869-03-03 | Republican | 9 | |||||||||||||
8315 | 8315 | Charles Drake D000484 | sen | MO | 1867-03-04 | 1871-03-03 | 3 | Republican | |||||||||||||
8338 | 8338 | Joseph Gravely G000389 | rep | MO | 1867-03-04 | 1869-03-03 | Republican | 4 | |||||||||||||
8379 | 8379 | Benjamin Loan L000384 | rep | MO | 1865-12-04 | 1867-03-03 | Republican | 7 | |||||||||||||
8380 | 8380 | Benjamin Loan L000384 | rep | MO | 1867-03-04 | 1869-03-03 | Republican | 7 | |||||||||||||
8389 | 8389 | Joseph McClurg M000347 | rep | MO | 1865-12-04 | 1867-03-03 | Republican | 5 | |||||||||||||
8390 | 8390 | Joseph McClurg M000347 | rep | MO | 1867-03-04 | 1869-03-03 | Republican | 5 | |||||||||||||
8403 | 8403 | Carman Newcomb N000065 | rep | MO | 1867-03-04 | 1869-03-03 | Republican | 2 | |||||||||||||
8406 | 8406 | Thomas Noell N000123 | rep | MO | 1865-12-04 | 1867-03-03 | Republican | 3 | |||||||||||||
8425 | 8425 | William Pile P000350 | rep | MO | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
8456 | 8456 | John Stover S000983 | rep | MO | 1867-03-04 | 1869-03-03 | Republican | 5 | |||||||||||||
8507 | 8507 | Joel Asper A000320 | rep | MO | 1869-03-04 | 1871-03-03 | Republican | 7 | |||||||||||||
8519 | 8519 | John Benjamin B000364 | rep | MO | 1865-12-04 | 1867-03-03 | Republican | 8 | |||||||||||||
8520 | 8520 | John Benjamin B000364 | rep | MO | 1867-03-04 | 1869-03-03 | Republican | 8 | |||||||||||||
8521 | 8521 | John Benjamin B000364 | rep | MO | 1869-03-04 | 1871-03-03 | Republican | 8 | |||||||||||||
8531 | 8531 | Sempronius Boyd B000720 | rep | MO | 1869-03-04 | 1871-03-03 | Republican | 4 | |||||||||||||
8584 | 8584 | David Dyer D000589 | rep | MO | 1869-03-04 | 1871-03-03 | Republican | 9 | |||||||||||||
8795 | 8795 | Daniel Jewett J000103 | sen | MO | 1870-01-01 | 1871-12-31 | 3 | Republican | |||||||||||||
8829 | 8829 | Francis Blair B000523 | rep | MO | 1859-12-05 | 1861-03-03 | Republican | 1 | |||||||||||||
8830 | 8830 | Francis Blair B000523 | rep | MO | 1861-07-04 | 1863-03-03 | Republican | 1 | |||||||||||||
8844 | 8844 | Samuel Burdett B001074 | rep | MO | 1869-03-04 | 1871-03-03 | Republican | 5 | |||||||||||||
8845 | 8845 | Samuel Burdett B001074 | rep | MO | 1871-03-04 | 1873-03-03 | Republican | 5 | |||||||||||||
8894 | 8894 | Gustavus Finkelnburg F000129 | rep | MO | 1869-03-04 | 1871-03-03 | Republican | 2 | |||||||||||||
9189 | 9189 | Harrison Havens H000357 | rep | MO | 1871-03-04 | 1873-03-03 | Republican | 4 | |||||||||||||
9190 | 9190 | Harrison Havens H000357 | rep | MO | 1873-12-01 | 1875-03-03 | Republican | 6 | |||||||||||||
9215 | 9215 | Ira Hyde H001023 | rep | MO | 1873-12-01 | 1875-03-03 | Republican | 10 | |||||||||||||
9307 | 9307 | Isaac Parker P000059 | rep | MO | 1871-03-04 | 1873-03-03 | Republican | 7 | |||||||||||||
9308 | 9308 | Isaac Parker P000059 | rep | MO | 1873-12-01 | 1875-03-03 | Republican | 9 | |||||||||||||
9385 | 9385 | Edwin Stanard S000787 | rep | MO | 1873-12-01 | 1875-03-03 | Republican | 1 | |||||||||||||
9771 | 9771 | Nathan Cole C000610 | rep | MO | 1877-10-15 | 1879-03-03 | Republican | 2 | |||||||||||||
9857 | 9857 | Anthony Ittner I000048 | rep | MO | 1877-10-15 | 1879-03-03 | Republican | 1 | |||||||||||||
9889 | 9889 | Lyne Metcalfe M000674 | rep | MO | 1877-10-15 | 1879-03-03 | Republican | 3 | |||||||||||||
9897 | 9897 | Henry Pollard P000414 | rep | MO | 1877-10-15 | 1879-03-03 | Republican | 10 | |||||||||||||
10461 | 10461 | James McLean M000548 | rep | MO | 1881-12-05 | 1883-03-03 | Republican | 2 | |||||||||||||
10528 | 10528 | Gustavus Sessinghaus S000249 | rep | MO | 1881-12-05 | 1883-03-03 | Republican | 3 | |||||||||||||
11758 | 11758 | Nathan Frank F000340 | rep | MO | 1889-12-02 | 1891-03-03 | Republican | 9 | |||||||||||||
11809 | 11809 | William Kinsey K000229 | rep | MO | 1889-12-02 | 1891-03-03 | Republican | 10 | |||||||||||||
11874 | 11874 | Frederick Niedringhaus N000104 | rep | MO | 1889-12-02 | 1891-03-03 | Republican | 8 | |||||||||||||
12006 | 12006 | William Wade W000008 | rep | MO | 1885-12-07 | 1887-03-03 | Republican | 13 | |||||||||||||
12007 | 12007 | William Wade W000008 | rep | MO | 1887-12-05 | 1889-03-03 | Republican | 13 | |||||||||||||
12008 | 12008 | William Wade W000008 | rep | MO | 1889-12-02 | 1891-03-03 | Republican | 13 | |||||||||||||
12930 | 12930 | Charles Burton B001147 | rep | MO | 1895-12-02 | 1897-03-03 | Republican | 15 | |||||||||||||
12939 | 12939 | Charles Clark C000423 | rep | MO | 1895-12-02 | 1897-03-03 | Republican | 1 | |||||||||||||
12979 | 12979 | George Crowther C000949 | rep | MO | 1895-12-02 | 1897-03-03 | Republican | 4 | |||||||||||||
13036 | 13036 | Joel Hubbard H000884 | rep | MO | 1895-12-02 | 1897-03-03 | Republican | 8 | |||||||||||||
13103 | 13103 | Norman Mozley M001056 | rep | MO | 1895-12-02 | 1897-03-03 | Republican | 14 | |||||||||||||
13136 | 13136 | John Raney R000052 | rep | MO | 1895-12-02 | 1897-03-03 | Republican | 13 | |||||||||||||
13181 | 13181 | John Tracey T000342 | rep | MO | 1895-12-02 | 1897-03-03 | Republican | 7 | |||||||||||||
13182 | 13182 | William Treloar T000363 | rep | MO | 1895-12-02 | 1897-03-03 | Republican | 9 | |||||||||||||
13195 | 13195 | Robert Van Horn V000042 | rep | MO | 1865-12-04 | 1867-03-03 | Republican | 6 | |||||||||||||
13196 | 13196 | Robert Van Horn V000042 | rep | MO | 1867-03-04 | 1869-03-03 | Republican | 6 | |||||||||||||
13197 | 13197 | Robert Van Horn V000042 | rep | MO | 1869-03-04 | 1871-03-03 | Republican | 6 | |||||||||||||
13198 | 13198 | Robert Van Horn V000042 | rep | MO | 1881-12-05 | 1883-03-03 | Republican | 8 | |||||||||||||
13199 | 13199 | Robert Van Horn V000042 | rep | MO | 1895-12-02 | 1897-03-03 | Republican | 5 | |||||||||||||
13754 | 13754 | Charles Pearce P000582 | rep | MO | 1897-03-15 | 1899-03-03 | Republican | 12 | |||||||||||||
13755 | 13755 | Charles Pearce P000582 | rep | MO | 1899-12-04 | 1901-03-03 | Republican | 12 | |||||||||||||
14026 | 14026 | Charles Joy J000274 | rep | MO | 1893-08-07 | 1895-03-03 | Republican | 11 | |||||||||||||
14027 | 14027 | Charles Joy J000274 | rep | MO | 1895-12-02 | 1897-03-03 | Republican | 11 | |||||||||||||
14028 | 14028 | Charles Joy J000274 | rep | MO | 1897-03-15 | 1899-03-03 | Republican | 11 | |||||||||||||
14029 | 14029 | Charles Joy J000274 | rep | MO | 1899-12-04 | 1901-03-03 | Republican | 11 | |||||||||||||
14030 | 14030 | Charles Joy J000274 | rep | MO | 1901-12-02 | 1903-03-03 | Republican | 11 | |||||||||||||
14209 | 14209 | George Wagoner W000022 | rep | MO | 1901-12-02 | 1903-03-03 | Republican | 12 | |||||||||||||
14664 | 14664 | Frank Fulkerson F000403 | rep | MO | 1905-12-04 | 1907-03-03 | Republican | 4 | |||||||||||||
14757 | 14757 | Frank Klepper K000265 | rep | MO | 1905-12-04 | 1907-03-03 | Republican | 3 | |||||||||||||
14890 | 14890 | Cassius Shartel S000299 | rep | MO | 1905-12-04 | 1907-03-03 | Republican | 15 | |||||||||||||
14924 | 14924 | William Tyndall T000451 | rep | MO | 1905-12-04 | 1907-03-03 | Republican | 14 | |||||||||||||
14942 | 14942 | William Warner W000160 | rep | MO | 1885-12-07 | 1887-03-03 | Republican | 5 | |||||||||||||
14943 | 14943 | William Warner W000160 | rep | MO | 1887-12-05 | 1889-03-03 | Republican | 5 | |||||||||||||
14944 | 14944 | William Warner W000160 | sen | MO | 1905-12-04 | 1911-03-03 | 1 | Republican | |||||||||||||
14948 | 14948 | John Welborn W000260 | rep | MO | 1905-12-04 | 1907-03-03 | Republican | 7 | |||||||||||||
15026 | 15026 | Henry Caulfield C000256 | rep | MO | 1907-12-02 | 1909-03-03 | Republican | 11 | |||||||||||||
15401 | 15401 | Harry Coudrey C000805 | rep | MO | 1905-12-04 | 1907-03-03 | Republican | 12 | |||||||||||||
15402 | 15402 | Harry Coudrey C000805 | rep | MO | 1907-12-02 | 1909-03-03 | Republican | 12 | |||||||||||||
15403 | 15403 | Harry Coudrey C000805 | rep | MO | 1909-03-15 | 1911-03-03 | Republican | 12 | |||||||||||||
15409 | 15409 | Charles Crow C000937 | rep | MO | 1909-03-15 | 1911-03-03 | Republican | 14 | |||||||||||||
15446 | 15446 | Politte Elvins E000163 | rep | MO | 1909-03-15 | 1911-03-03 | Republican | 13 | |||||||||||||
15659 | 15659 | Charles Morgan M000944 | rep | MO | 1909-03-15 | 1911-03-03 | Republican | 15 | |||||||||||||
15669 | 15669 | Arthur Murphy M001087 | rep | MO | 1905-12-04 | 1907-03-03 | Republican | 16 | |||||||||||||
15670 | 15670 | Arthur Murphy M001087 | rep | MO | 1909-03-15 | 1911-03-03 | Republican | 16 | |||||||||||||
15888 | 15888 | Theron Catlin C000252 | rep | MO | 1911-04-04 | 1913-03-03 | Republican | 11 | |||||||||||||
16262 | 16262 | Richard Bartholdt B000196 | rep | MO | 1893-08-07 | 1895-03-03 | Republican | 10 | |||||||||||||
16263 | 16263 | Richard Bartholdt B000196 | rep | MO | 1895-12-02 | 1897-03-03 | Republican | 10 | |||||||||||||
16264 | 16264 | Richard Bartholdt B000196 | rep | MO | 1897-03-15 | 1899-03-03 | Republican | 10 | |||||||||||||
16265 | 16265 | Richard Bartholdt B000196 | rep | MO | 1899-12-04 | 1901-03-03 | Republican | 10 | |||||||||||||
16266 | 16266 | Richard Bartholdt B000196 | rep | MO | 1901-12-02 | 1903-03-03 | Republican | 10 | |||||||||||||
16267 | 16267 | Richard Bartholdt B000196 | rep | MO | 1903-11-09 | 1905-03-03 | Republican | 10 | |||||||||||||
16268 | 16268 | Richard Bartholdt B000196 | rep | MO | 1905-12-04 | 1907-03-03 | Republican | 10 | |||||||||||||
16269 | 16269 | Richard Bartholdt B000196 | rep | MO | 1907-12-02 | 1909-03-03 | Republican | 10 | |||||||||||||
16270 | 16270 | Richard Bartholdt B000196 | rep | MO | 1909-03-15 | 1911-03-03 | Republican | 10 | |||||||||||||
16271 | 16271 | Richard Bartholdt B000196 | rep | MO | 1911-04-04 | 1913-03-03 | Republican | 10 | |||||||||||||
16272 | 16272 | Richard Bartholdt B000196 | rep | MO | 1913-04-07 | 1915-03-03 | Republican | 10 | |||||||||||||
17166 | 17166 | Frederick Essen E000219 | rep | MO | 1917-04-02 | 1919-03-03 | Republican | 10 | |||||||||||||
17353 | 17353 | Jacob Meeker M000629 | rep | MO | 1915-12-06 | 1917-03-03 | Republican | 10 |
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);