legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
343 rows where "start" is on date 1873-12-01 sorted by state
This data as json, copyable, CSV (advanced)
Suggested facets: type, class, district, end (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9099 | 9099 | Frederick Bromberg B000864 | rep | AL | 1873-12-01 | 1875-03-03 | Liberal Republican | 1 | |||||||||||||
9311 | 9311 | Charles Pelham P000192 | rep | AL | 1873-12-01 | 1875-03-03 | Republican | 3 | |||||||||||||
9320 | 9320 | James Rapier R000064 | rep | AL | 1873-12-01 | 1875-03-03 | Republican | 2 | |||||||||||||
9357 | 9357 | Charles Sheats S000314 | rep | AL | 1873-12-01 | 1875-03-03 | Republican | -1 | |||||||||||||
9366 | 9366 | Joseph Sloss S000498 | rep | AL | 1873-12-01 | 1875-03-03 | Democrat | 6 | |||||||||||||
9380 | 9380 | George Spencer S000723 | sen | AL | 1873-12-01 | 1879-03-03 | 3 | Republican | |||||||||||||
9407 | 9407 | Alexander White W000353 | rep | AL | 1873-12-01 | 1875-03-03 | Republican | -1 | |||||||||||||
9475 | 9475 | John Caldwell C000035 | rep | AL | 1873-12-01 | 1875-03-03 | Democrat | 5 | |||||||||||||
9527 | 9527 | Charles Hays H000402 | rep | AL | 1873-12-01 | 1875-03-03 | Republican | 4 | |||||||||||||
9154 | 9154 | Stephen Dorsey D000441 | sen | AR | 1873-12-01 | 1879-03-03 | 3 | Republican | |||||||||||||
9201 | 9201 | Asa Hodges H000671 | rep | AR | 1873-12-01 | 1875-03-03 | Republican | 1 | |||||||||||||
9216 | 9216 | William Hynes H001027 | rep | AR | 1873-12-01 | 1875-03-03 | Liberal Republican | -1 | |||||||||||||
9376 | 9376 | Oliver Snyder S000671 | rep | AR | 1873-12-01 | 1875-03-03 | Republican | 2 | |||||||||||||
9703 | 9703 | William Wilshire W000567 | rep | AR | 1873-12-01 | 1875-03-03 | Republican | 3 | |||||||||||||
10357 | 10357 | Thomas Gunter G000527 | rep | AR | 1873-12-01 | 1875-03-03 | Democrat | 3 | |||||||||||||
13079 | 13079 | Richard McCormick M000371 | rep | AZ | 1873-12-01 | 1875-03-03 | Unionist | 0 | |||||||||||||
9121 | 9121 | Charles Clayton C000493 | rep | CA | 1873-12-01 | 1875-03-03 | Republican | 1 | |||||||||||||
9185 | 9185 | John Hager H000016 | sen | CA | 1873-12-01 | 1875-03-03 | 1 | Democrat | |||||||||||||
9210 | 9210 | Sherman Houghton H000815 | rep | CA | 1873-12-01 | 1875-03-03 | Republican | 4 | |||||||||||||
9340 | 9340 | Aaron Sargent S000065 | sen | CA | 1873-12-01 | 1879-03-03 | 3 | Republican | |||||||||||||
9878 | 9878 | John Luttrell L000522 | rep | CA | 1873-12-01 | 1875-03-03 | Democrat | 3 | |||||||||||||
10495 | 10495 | Horace Page P000017 | rep | CA | 1873-12-01 | 1875-03-03 | Republican | 2 | |||||||||||||
9724 | 9724 | Jerome Chaffee C000271 | rep | CO | 1873-12-01 | 1875-03-03 | Republican | -1 | |||||||||||||
9169 | 9169 | Orris Ferry F000094 | sen | CT | 1873-12-01 | 1875-12-31 | 3 | Republican | |||||||||||||
9220 | 9220 | Stephen Kellogg K000067 | rep | CT | 1873-12-01 | 1875-03-03 | Republican | 2 | |||||||||||||
9640 | 9640 | Henry Starkweather S000815 | rep | CT | 1873-12-01 | 1875-03-03 | Republican | 3 | |||||||||||||
9712 | 9712 | William Barnum B000166 | rep | CT | 1873-12-01 | 1875-03-03 | Democrat | 4 | |||||||||||||
13700 | 13700 | Joseph Hawley H000377 | rep | CT | 1873-12-01 | 1875-03-03 | Republican | 1 | |||||||||||||
9116 | 9116 | Norton Chipman C000370 | rep | DC | 1873-12-01 | 1875-03-03 | Republican | 0 | |||||||||||||
9236 | 9236 | James Lofland L000398 | rep | DE | 1873-12-01 | 1875-03-03 | Republican | 0 | |||||||||||||
9078 | 9078 | Moses Armstrong A000283 | rep | DK | 1873-12-01 | 1875-03-03 | Democrat | -1 | |||||||||||||
9133 | 9133 | Simon Conover C000701 | sen | FL | 1873-12-01 | 1879-03-03 | 3 | Republican | |||||||||||||
9615 | 9615 | William Purman P000572 | rep | FL | 1873-12-01 | 1875-03-03 | Republican | -1 | |||||||||||||
9681 | 9681 | Josiah Walls W000093 | rep | FL | 1873-12-01 | 1875-03-03 | Republican | -1 | |||||||||||||
9176 | 9176 | James Freeman F000362 | rep | GA | 1873-12-01 | 1875-03-03 | Republican | 5 | |||||||||||||
9321 | 9321 | Morgan Rawls R000074 | rep | GA | 1873-12-01 | 1875-03-03 | Democrat | 1 | |||||||||||||
9364 | 9364 | Andrew Sloan S000489 | rep | GA | 1873-12-01 | 1875-03-03 | Republican | 1 | |||||||||||||
9411 | 9411 | Richard Whiteley W000408 | rep | GA | 1873-12-01 | 1875-03-03 | Republican | 2 | |||||||||||||
9431 | 9431 | Pierce Young Y000048 | rep | GA | 1873-12-01 | 1875-03-03 | Democrat | 7 | |||||||||||||
9741 | 9741 | Hiram Bell B000336 | rep | GA | 1873-12-01 | 1875-03-03 | Democrat | 9 | |||||||||||||
10306 | 10306 | Philip Cook C000724 | rep | GA | 1873-12-01 | 1875-03-03 | Democrat | 3 | |||||||||||||
10557 | 10557 | Alexander Stephens S000854 | rep | GA | 1873-12-01 | 1875-03-03 | Democrat | 8 | |||||||||||||
11070 | 11070 | Henry Harris H000239 | rep | GA | 1873-12-01 | 1875-03-03 | Democrat | 4 | |||||||||||||
12087 | 12087 | James Blount B000568 | rep | GA | 1873-12-01 | 1875-03-03 | Democrat | 6 | |||||||||||||
12182 | 12182 | John Gordon G000313 | sen | GA | 1873-12-01 | 1879-03-03 | 3 | Democrat | |||||||||||||
9136 | 9136 | Aylett Cotton C000801 | rep | IA | 1873-12-01 | 1875-03-03 | Republican | 2 | |||||||||||||
9153 | 9153 | William Donnan D000413 | rep | IA | 1873-12-01 | 1875-03-03 | Republican | 3 | |||||||||||||
9239 | 9239 | William Loughridge L000451 | rep | IA | 1873-12-01 | 1875-03-03 | Republican | 6 | |||||||||||||
9301 | 9301 | Jackson Orr O000103 | rep | IA | 1873-12-01 | 1875-03-03 | Republican | 9 | |||||||||||||
9579 | 9579 | George McCrary M000379 | rep | IA | 1873-12-01 | 1875-03-03 | Republican | 1 | |||||||||||||
9613 | 9613 | Henry Pratt P000501 | rep | IA | 1873-12-01 | 1875-03-03 | Republican | 4 | |||||||||||||
10451 | 10451 | James McDill M000407 | rep | IA | 1873-12-01 | 1875-03-03 | Republican | 8 | |||||||||||||
10775 | 10775 | John Kasson K000018 | rep | IA | 1873-12-01 | 1875-03-03 | Republican | 7 | |||||||||||||
10936 | 10936 | James Wilson W000590 | rep | IA | 1873-12-01 | 1875-03-03 | Republican | 5 | |||||||||||||
14231 | 14231 | William Allison A000160 | sen | IA | 1873-12-01 | 1879-03-03 | 3 | Republican | |||||||||||||
11056 | 11056 | John Hailey H000023 | rep | ID | 1873-12-01 | 1875-03-03 | Democrat | -1 | |||||||||||||
9085 | 9085 | Granville Barrere B000173 | rep | IL | 1873-12-01 | 1875-03-03 | Republican | 9 | |||||||||||||
9122 | 9122 | Isaac Clements C000507 | rep | IL | 1873-12-01 | 1875-03-03 | Republican | 18 | |||||||||||||
9134 | 9134 | Franklin Corwin C000789 | rep | IL | 1873-12-01 | 1875-03-03 | Republican | 7 | |||||||||||||
9193 | 9193 | John Hawley H000376 | rep | IL | 1873-12-01 | 1875-03-03 | Republican | 6 | |||||||||||||
9250 | 9250 | Samuel Marshall M000160 | rep | IL | 1873-12-01 | 1875-03-03 | Democrat | 19 | |||||||||||||
9251 | 9251 | James Martin M000184 | rep | IL | 1873-12-01 | 1875-03-03 | Republican | 16 | |||||||||||||
9271 | 9271 | John McNulta M000587 | rep | IL | 1873-12-01 | 1875-03-03 | Republican | 13 | |||||||||||||
9299 | 9299 | Richard Oglesby O000048 | sen | IL | 1873-12-01 | 1879-03-03 | 3 | Republican | |||||||||||||
9322 | 9322 | William Ray R000081 | rep | IL | 1873-12-01 | 1875-03-03 | Republican | 10 | |||||||||||||
9325 | 9325 | John Rice R000200 | rep | IL | 1873-12-01 | 1875-03-03 | Republican | 1 | |||||||||||||
9335 | 9335 | James Robinson R000336 | rep | IL | 1873-12-01 | 1875-03-03 | Democrat | 12 | |||||||||||||
9404 | 9404 | Jasper Ward W000135 | rep | IL | 1873-12-01 | 1875-03-03 | Republican | 2 | |||||||||||||
9483 | 9483 | Bernard Caulfield C000255 | rep | IL | 1873-12-01 | 1875-03-03 | Democrat | 1 | |||||||||||||
9536 | 9536 | Stephen Hurlbut H001003 | rep | IL | 1873-12-01 | 1875-03-03 | Republican | 4 | |||||||||||||
9754 | 9754 | Horatio Burchard B001070 | rep | IL | 1873-12-01 | 1875-03-03 | Republican | 5 | |||||||||||||
9871 | 9871 | Robert Knapp K000281 | rep | IL | 1873-12-01 | 1875-03-03 | Democrat | 11 | |||||||||||||
10083 | 10083 | Greenbury Fort F000288 | rep | IL | 1873-12-01 | 1875-03-03 | Republican | 8 | |||||||||||||
11020 | 11020 | John Eden E000042 | rep | IL | 1873-12-01 | 1875-03-03 | Democrat | 15 | |||||||||||||
11135 | 11135 | William Morrison M001000 | rep | IL | 1873-12-01 | 1875-03-03 | Democrat | 17 | |||||||||||||
11364 | 11364 | Charles Farwell F000037 | rep | IL | 1873-12-01 | 1875-03-03 | Republican | 3 | |||||||||||||
18093 | 18093 | Joseph Cannon C000121 | rep | IL | 1873-12-01 | 1875-03-03 | Republican | 14 | |||||||||||||
9130 | 9130 | John Coburn C000558 | rep | IN | 1873-12-01 | 1875-03-03 | Republican | 5 | |||||||||||||
9280 | 9280 | Oliver Morton M001020 | sen | IN | 1873-12-01 | 1877-12-31 | 3 | Republican | |||||||||||||
9295 | 9295 | William Niblack N000083 | rep | IN | 1873-12-01 | 1875-03-03 | Democrat | 1 | |||||||||||||
9304 | 9304 | Jasper Packard P000004 | rep | IN | 1873-12-01 | 1875-03-03 | Republican | 11 | |||||||||||||
9341 | 9341 | Henry Sayler S000100 | rep | IN | 1873-12-01 | 1875-03-03 | Republican | 10 | |||||||||||||
9356 | 9356 | John Shanks S000284 | rep | IN | 1873-12-01 | 1875-03-03 | Republican | 9 | |||||||||||||
9402 | 9402 | James Tyner T000452 | rep | IN | 1873-12-01 | 1875-03-03 | Republican | 8 | |||||||||||||
9420 | 9420 | William Williams W000545 | rep | IN | 1873-12-01 | 1875-03-03 | Republican | -1 | |||||||||||||
9423 | 9423 | Jeremiah Wilson W000596 | rep | IN | 1873-12-01 | 1875-03-03 | Republican | 4 | |||||||||||||
9425 | 9425 | Simeon Wolfe W000677 | rep | IN | 1873-12-01 | 1875-03-03 | Democrat | 2 | |||||||||||||
9480 | 9480 | Thomas Cason C000232 | rep | IN | 1873-12-01 | 1875-03-03 | Republican | 7 | |||||||||||||
9854 | 9854 | Morton Hunter H000985 | rep | IN | 1873-12-01 | 1875-03-03 | Republican | 6 | |||||||||||||
10489 | 10489 | Godlove Orth O000106 | rep | IN | 1873-12-01 | 1875-03-03 | Republican | -1 | |||||||||||||
13340 | 13340 | William Holman H000732 | rep | IN | 1873-12-01 | 1875-03-03 | Democrat | 3 | |||||||||||||
9126 | 9126 | Stephen Cobb C000551 | rep | KS | 1873-12-01 | 1875-03-03 | Republican | -1 | |||||||||||||
9142 | 9142 | Robert Crozier C000952 | sen | KS | 1873-12-01 | 1875-03-03 | 2 | Republican | |||||||||||||
9241 | 9241 | David Lowe L000473 | rep | KS | 1873-12-01 | 1875-03-03 | Republican | -1 | |||||||||||||
9894 | 9894 | William Phillips P000315 | rep | KS | 1873-12-01 | 1875-03-03 | Republican | -1 | |||||||||||||
11086 | 11086 | John Ingalls I000012 | sen | KS | 1873-12-01 | 1879-03-03 | 3 | Republican | |||||||||||||
9070 | 9070 | George Adams A000035 | rep | KY | 1873-12-01 | 1875-03-03 | Democrat | 9 | |||||||||||||
9080 | 9080 | William Arthur A000304 | rep | KY | 1873-12-01 | 1875-03-03 | Democrat | 6 | |||||||||||||
9141 | 9141 | Edward Crossland C000933 | rep | KY | 1873-12-01 | 1875-03-03 | Democrat | 1 | |||||||||||||
9261 | 9261 | Thomas McCreery M000385 | sen | KY | 1873-12-01 | 1879-03-03 | 3 | Democrat |
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);