legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
1,157 rows where state = "MO"
This data as json, copyable, CSV (advanced)
party 9 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||
7963 | 7963 | William Hall H000079 | rep | MO | 1861-07-04 | 1863-03-03 | Democrat | 3 | |||||||||||||
7964 | 7964 | William Hall H000079 | rep | MO | 1863-12-07 | 1865-03-03 | Unionist | 8 | |||||||||||||
7977 | 7977 | Austin King K000194 | rep | MO | 1863-12-07 | 1865-03-03 | Unionist | 6 | |||||||||||||
7981 | 7981 | Samuel Knox K000297 | rep | MO | 1863-12-07 | 1865-03-03 | Unconditional Unionist | 1 | |||||||||||||
8009 | 8009 | John Noell N000122 | rep | MO | 1859-12-05 | 1861-03-03 | Democrat | 7 | |||||||||||||
8010 | 8010 | John Noell N000122 | rep | MO | 1861-07-04 | 1863-03-03 | Democrat | 7 | |||||||||||||
8011 | 8011 | John Noell N000122 | rep | MO | 1863-12-07 | 1865-03-03 | Unconditional Unionist | 3 | |||||||||||||
8029 | 8029 | James Rollins R000412 | rep | MO | 1861-07-04 | 1863-03-03 | Constitutional Unionist | 2 | |||||||||||||
8030 | 8030 | James Rollins R000412 | rep | MO | 1863-12-07 | 1865-03-03 | Unionist | 9 | |||||||||||||
8031 | 8031 | John Scott S000178 | rep | MO | 1863-12-07 | 1865-03-03 | Democrat | 3 | |||||||||||||
8087 | 8087 | Henry Blow B000572 | rep | MO | 1863-12-07 | 1865-03-03 | Unconditional Unionist | 2 | |||||||||||||
8088 | 8088 | Henry Blow B000572 | rep | MO | 1865-12-04 | 1867-03-03 | Republican | 2 | |||||||||||||
8140 | 8140 | John Hogan H000691 | rep | MO | 1865-12-04 | 1867-03-03 | Democrat | 1 | |||||||||||||
8160 | 8160 | John Kelso K000081 | rep | MO | 1865-12-04 | 1867-03-03 | Ind. Republican | 4 | |||||||||||||
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 | |||||||||||||
8378 | 8378 | Benjamin Loan L000384 | rep | MO | 1863-12-07 | 1865-03-03 | Unconditional Unionist | 7 | |||||||||||||
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 | |||||||||||||
8388 | 8388 | Joseph McClurg M000347 | rep | MO | 1863-12-07 | 1865-03-03 | Unconditional Unionist | 5 | |||||||||||||
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 | |||||||||||||
8407 | 8407 | Thomas Noell N000123 | rep | MO | 1867-03-04 | 1869-03-03 | Democrat | 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 | |||||||||||||
8530 | 8530 | Sempronius Boyd B000720 | rep | MO | 1863-12-07 | 1865-03-03 | Unconditional Unionist | 4 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
8828 | 8828 | Francis Blair B000523 | rep | MO | 1857-12-07 | 1859-03-03 | Ind. Democrat | 1 | |||||||||||||
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 | |||||||||||||
8831 | 8831 | Francis Blair B000523 | rep | MO | 1863-12-07 | 1865-03-03 | Unconditional Unionist | 1 | |||||||||||||
8832 | 8832 | Francis Blair B000523 | sen | MO | 1871-03-04 | 1873-03-03 | 3 | Democrat | |||||||||||||
8833 | 8833 | James Blair B000527 | rep | MO | 1871-03-04 | 1873-03-03 | Liberal Republican | 8 | |||||||||||||
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 | |||||||||||||
8895 | 8895 | Gustavus Finkelnburg F000129 | rep | MO | 1871-03-04 | 1873-03-03 | Liberal Republican | 2 | |||||||||||||
8941 | 8941 | Andrew King K000193 | rep | MO | 1871-03-04 | 1873-03-03 | Democrat | 9 | |||||||||||||
8953 | 8953 | James McCormick M000367 | rep | MO | 1867-03-04 | 1869-03-03 | Democrat | 3 | |||||||||||||
8954 | 8954 | James McCormick M000367 | rep | MO | 1869-03-04 | 1871-03-03 | Democrat | 3 | |||||||||||||
8955 | 8955 | James McCormick M000367 | rep | MO | 1871-03-04 | 1873-03-03 | Democrat | 3 | |||||||||||||
9092 | 9092 | Lewis Bogy B000595 | sen | MO | 1873-12-01 | 1877-12-31 | 3 | Democrat | |||||||||||||
9131 | 9131 | Abram Comingo C000658 | rep | MO | 1871-03-04 | 1873-03-03 | Democrat | 6 | |||||||||||||
9132 | 9132 | Abram Comingo C000658 | rep | MO | 1873-12-01 | 1875-03-03 | Democrat | 8 | |||||||||||||
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 | |||||||||||||
9492 | 9492 | Rezin De Bolt D000180 | rep | MO | 1875-12-06 | 1877-03-03 | Democrat | 10 | |||||||||||||
9550 | 9550 | Edward Kehr K000047 | rep | MO | 1875-12-06 | 1877-03-03 | Democrat | 1 | |||||||||||||
9644 | 9644 | William Stone S000967 | rep | MO | 1873-12-01 | 1875-03-03 | Democrat | 3 | |||||||||||||
9645 | 9645 | William Stone S000967 | rep | MO | 1875-12-06 | 1877-03-03 | Democrat | 3 | |||||||||||||
9729 | 9729 | David Armstrong A000279 | sen | MO | 1877-10-15 | 1879-03-03 | 3 | Democrat | |||||||||||||
9771 | 9771 | Nathan Cole C000610 | rep | MO | 1877-10-15 | 1879-03-03 | Republican | 2 | |||||||||||||
9776 | 9776 | Thomas Crittenden C000913 | rep | MO | 1873-12-01 | 1875-03-03 | Democrat | 7 | |||||||||||||
9777 | 9777 | Thomas Crittenden C000913 | rep | MO | 1877-10-15 | 1879-03-03 | Democrat | 7 | |||||||||||||
9812 | 9812 | Benjamin Franklin F000343 | rep | MO | 1875-12-06 | 1877-03-03 | Democrat | 8 | |||||||||||||
9813 | 9813 | Benjamin Franklin F000343 | rep | MO | 1877-10-15 | 1879-03-03 | Democrat | 8 | |||||||||||||
9825 | 9825 | John Glover G000245 | rep | MO | 1873-12-01 | 1875-03-03 | Democrat | 12 | |||||||||||||
9826 | 9826 | John Glover G000245 | rep | MO | 1875-12-06 | 1877-03-03 | Democrat | 12 | |||||||||||||
9827 | 9827 | John Glover G000245 | rep | MO | 1877-10-15 | 1879-03-03 | Democrat | 12 | |||||||||||||
9840 | 9840 | Robert Hatcher H000341 | rep | MO | 1873-12-01 | 1875-03-03 | Democrat | 4 | |||||||||||||
9841 | 9841 | Robert Hatcher H000341 | rep | MO | 1875-12-06 | 1877-03-03 | Democrat | 4 | |||||||||||||
9842 | 9842 | Robert Hatcher H000341 | rep | MO | 1877-10-15 | 1879-03-03 | Democrat | 4 | |||||||||||||
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 | |||||||||||||
9911 | 9911 | David Rea R000088 | rep | MO | 1875-12-06 | 1877-03-03 | Democrat | 9 | |||||||||||||
9912 | 9912 | David Rea R000088 | rep | MO | 1877-10-15 | 1879-03-03 | Democrat | 9 | |||||||||||||
10131 | 10131 | Alfred Lay L000149 | rep | MO | 1879-03-18 | 1881-03-03 | Democrat | 7 | |||||||||||||
10168 | 10168 | John Philips P000304 | rep | MO | 1875-12-06 | 1877-03-03 | Democrat | 7 | |||||||||||||
10169 | 10169 | John Philips P000304 | rep | MO | 1879-03-18 | 1881-03-03 | Democrat | 7 | |||||||||||||
10178 | 10178 | Gideon Rothwell R000463 | rep | MO | 1879-03-18 | 1881-03-03 | Democrat | 10 | |||||||||||||
10184 | 10184 | Samuel Sawyer S000092 | rep | MO | 1879-03-18 | 1881-03-03 | Ind. Democrat | 8 | |||||||||||||
10190 | 10190 | James Shields S000362 | sen | MO | 1879-01-27 | 1879-03-03 | 3 | Democrat | |||||||||||||
10211 | 10211 | James Waddill W000004 | rep | MO | 1879-03-18 | 1881-03-03 | Democrat | 6 | |||||||||||||
10213 | 10213 | Erastus Wells W000282 | rep | MO | 1869-03-04 | 1871-03-03 | Democrat | 1 | |||||||||||||
10214 | 10214 | Erastus Wells W000282 | rep | MO | 1871-03-04 | 1873-03-03 | Democrat | 1 | |||||||||||||
10215 | 10215 | Erastus Wells W000282 | rep | MO | 1873-12-01 | 1875-03-03 | Democrat | 2 | |||||||||||||
10216 | 10216 | Erastus Wells W000282 | rep | MO | 1875-12-06 | 1877-03-03 | Democrat | 2 | |||||||||||||
10217 | 10217 | Erastus Wells W000282 | rep | MO | 1879-03-18 | 1881-03-03 | Democrat | 2 | |||||||||||||
10253 | 10253 | Thomas Allen A000147 | rep | MO | 1881-12-05 | 1883-03-03 | Democrat | 2 | |||||||||||||
10275 | 10275 | Joseph Burrows B001141 | rep | MO | 1881-12-05 | 1883-03-03 | National Greenbacker | 10 | |||||||||||||
10292 | 10292 | John Clark C000442 | rep | MO | 1873-12-01 | 1875-03-03 | Democrat | 11 | |||||||||||||
10293 | 10293 | John Clark C000442 | rep | MO | 1875-12-06 | 1877-03-03 | Democrat | 11 |
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);