legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
494 rows where "end" is on date 1915-03-03 sorted by state
This data as json, copyable, CSV (advanced)
Suggested facets: party, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21003 | 21003 | James Wickersham W000438 | rep | AK | 1913-04-07 | 1915-03-03 | Republican | 0 | |||||||||||||
16336 | 16336 | Henry Clayton C000495 | rep | AL | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
16391 | 16391 | Christopher Harris H000235 | rep | AL | 1913-04-07 | 1915-03-03 | Democrat | 8 | |||||||||||||
16402 | 16402 | Richmond Hobson H000667 | rep | AL | 1913-04-07 | 1915-03-03 | Democrat | 6 | |||||||||||||
16490 | 16490 | William Mulkey M001070 | rep | AL | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
16548 | 16548 | William Richardson R000227 | rep | AL | 1913-04-07 | 1915-03-03 | Democrat | 8 | |||||||||||||
16611 | 16611 | George Taylor T000078 | rep | AL | 1913-04-07 | 1915-03-03 | Democrat | 1 | |||||||||||||
16661 | 16661 | Francis White W000368 | sen | AL | 1914-01-01 | 1915-03-03 | 3 | Democrat | |||||||||||||
16662 | 16662 | John Abercrombie A000013 | rep | AL | 1913-04-07 | 1915-03-03 | Democrat | -1 | |||||||||||||
17587 | 17587 | John Burnett B001121 | rep | AL | 1913-04-07 | 1915-03-03 | Democrat | 7 | |||||||||||||
17637 | 17637 | Stanley Dent D000256 | rep | AL | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
18044 | 18044 | Fred Blackmon B000514 | rep | AL | 1913-04-07 | 1915-03-03 | Democrat | 4 | |||||||||||||
18533 | 18533 | Oscar Underwood U000013 | rep | AL | 1913-04-07 | 1915-03-03 | Democrat | 9 | |||||||||||||
18984 | 18984 | James Heflin H000446 | rep | AL | 1913-04-07 | 1915-03-03 | Democrat | 5 | |||||||||||||
16362 | 16362 | John Floyd F000222 | rep | AR | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
16730 | 16730 | James Clarke C000463 | sen | AR | 1909-03-15 | 1915-03-03 | 3 | Democrat | |||||||||||||
17738 | 17738 | William Goodwin G000304 | rep | AR | 1913-04-07 | 1915-03-03 | Democrat | 7 | |||||||||||||
18244 | 18244 | Henderson Jacoway J000041 | rep | AR | 1913-04-07 | 1915-03-03 | Democrat | 5 | |||||||||||||
18516 | 18516 | Samuel Taylor T000100 | rep | AR | 1913-04-07 | 1915-03-03 | Democrat | 6 | |||||||||||||
19256 | 19256 | Thaddeus Caraway C000139 | rep | AR | 1913-04-07 | 1915-03-03 | Democrat | 1 | |||||||||||||
19447 | 19447 | William Oldfield O000062 | rep | AR | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
20050 | 20050 | Otis Wingo W000635 | rep | AR | 1913-04-07 | 1915-03-03 | Democrat | 4 | |||||||||||||
16978 | 16978 | Marcus Smith S000589 | sen | AZ | 1912-01-01 | 1915-03-03 | 3 | Democrat | |||||||||||||
27844 | 27844 | Carl Hayden H000385 | rep | AZ | 1913-04-07 | 1915-03-03 | Democrat | 0 | |||||||||||||
15699 | 15699 | George Perkins P000232 | sen | CA | 1909-03-15 | 1915-03-03 | 3 | Republican | |||||||||||||
16290 | 16290 | Charles Bell B000334 | rep | CA | 1913-04-07 | 1915-03-03 | Republican | 9 | |||||||||||||
16430 | 16430 | Joseph Knowland K000291 | rep | CA | 1913-04-07 | 1915-03-03 | Republican | 6 | |||||||||||||
16836 | 16836 | William Kent K000127 | rep | CA | 1913-04-07 | 1915-03-03 | Independent | 1 | |||||||||||||
17010 | 17010 | William Stephens S000861 | rep | CA | 1913-04-07 | 1915-03-03 | Republican | 10 | |||||||||||||
17256 | 17256 | Everis Hayes H000389 | rep | CA | 1913-04-07 | 1915-03-03 | Republican | 8 | |||||||||||||
17800 | 17800 | William Kettner K000155 | rep | CA | 1913-04-07 | 1915-03-03 | Democrat | 11 | |||||||||||||
18377 | 18377 | John Nolan N000124 | rep | CA | 1913-04-07 | 1915-03-03 | Republican | 5 | |||||||||||||
18702 | 18702 | Julius Kahn K000003 | rep | CA | 1913-04-07 | 1915-03-03 | Republican | 4 | |||||||||||||
19064 | 19064 | John Raker R000019 | rep | CA | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
19637 | 19637 | Charles Curry C001000 | rep | CA | 1913-04-07 | 1915-03-03 | Republican | 3 | |||||||||||||
21195 | 21195 | Denver Church C000387 | rep | CA | 1913-04-07 | 1915-03-03 | Democrat | 7 | |||||||||||||
16420 | 16420 | George Kindel K000189 | rep | CO | 1913-04-07 | 1915-03-03 | Democrat | 1 | |||||||||||||
16558 | 16558 | Harry Seldomridge S000234 | rep | CO | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
17028 | 17028 | Charles Thomas T000160 | sen | CO | 1913-04-07 | 1915-03-03 | 3 | Democrat | |||||||||||||
17323 | 17323 | Edward Keating K000035 | rep | CO | 1913-04-07 | 1915-03-03 | Democrat | -1 | |||||||||||||
23272 | 23272 | Edward Taylor T000072 | rep | CO | 1913-04-07 | 1915-03-03 | Democrat | -1 | |||||||||||||
16349 | 16349 | Jeremiah Donovan D000422 | rep | CT | 1913-04-07 | 1915-03-03 | Democrat | 4 | |||||||||||||
16419 | 16419 | William Kennedy K000117 | rep | CT | 1913-04-07 | 1915-03-03 | Democrat | 5 | |||||||||||||
16461 | 16461 | Bryan Mahan M000061 | rep | CT | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
16540 | 16540 | Thomas Reilly R000156 | rep | CT | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
18063 | 18063 | Frank Brandegee B000769 | sen | CT | 1909-03-15 | 1915-03-03 | 3 | Republican | |||||||||||||
21379 | 21379 | Augustine Lonergan L000409 | rep | CT | 1913-04-07 | 1915-03-03 | Democrat | 1 | |||||||||||||
16294 | 16294 | Franklin Brockson B000853 | rep | DE | 1913-04-07 | 1915-03-03 | Democrat | 0 | |||||||||||||
16436 | 16436 | Claude L’Engle L000548 | rep | FL | 1913-04-07 | 1915-03-03 | Democrat | -1 | |||||||||||||
16996 | 16996 | Stephen Sparkman S000702 | rep | FL | 1913-04-07 | 1915-03-03 | Democrat | 1 | |||||||||||||
17037 | 17037 | Emmett Wilson W000575 | rep | FL | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
18587 | 18587 | Frank Clark C000430 | rep | FL | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
21259 | 21259 | Duncan Fletcher F000200 | sen | FL | 1909-03-15 | 1915-03-03 | 3 | Democrat | |||||||||||||
16259 | 16259 | Augustus Bacon B000014 | sen | GA | 1913-04-07 | 1915-03-03 | 2 | Democrat | |||||||||||||
16282 | 16282 | Charles Bartlett B000199 | rep | GA | 1913-04-07 | 1915-03-03 | Democrat | 6 | |||||||||||||
16551 | 16551 | Seaborn Roddenbery R000370 | rep | GA | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
16660 | 16660 | William West W000305 | sen | GA | 1914-03-02 | 1915-03-03 | 2 | Democrat | appointment | ||||||||||||
16814 | 16814 | Dudley Hughes H000920 | rep | GA | 1913-04-07 | 1915-03-03 | Democrat | 12 | |||||||||||||
16964 | 16964 | Hoke Smith S000551 | sen | GA | 1911-04-04 | 1915-03-03 | 3 | Democrat | |||||||||||||
17031 | 17031 | Samuel Tribble T000366 | rep | GA | 1913-04-07 | 1915-03-03 | Democrat | 8 | |||||||||||||
17052 | 17052 | William Adamson A000051 | rep | GA | 1913-04-07 | 1915-03-03 | Democrat | 4 | |||||||||||||
17304 | 17304 | William Howard H000849 | rep | GA | 1913-04-07 | 1915-03-03 | Democrat | 5 | |||||||||||||
17497 | 17497 | John Walker W000060 | rep | GA | 1913-04-07 | 1915-03-03 | Democrat | 11 | |||||||||||||
18799 | 18799 | Frank Park P000051 | rep | GA | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
19024 | 19024 | Gordon Lee L000194 | rep | GA | 1913-04-07 | 1915-03-03 | Democrat | 7 | |||||||||||||
19578 | 19578 | Thomas Bell B000348 | rep | GA | 1913-04-07 | 1915-03-03 | Democrat | 9 | |||||||||||||
20261 | 20261 | Charles Crisp C000909 | rep | GA | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
20343 | 20343 | Charles Edwards E000062 | rep | GA | 1913-04-07 | 1915-03-03 | Democrat | 1 | |||||||||||||
28203 | 28203 | Carl Vinson V000105 | rep | GA | 1913-04-07 | 1915-03-03 | Democrat | 10 | |||||||||||||
18262 | 18262 | Jonah Kalanianaole K000004 | rep | HI | 1913-04-07 | 1915-03-03 | Republican | -1 | |||||||||||||
16337 | 16337 | Maurice Connolly C000699 | rep | IA | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
16424 | 16424 | Sanford Kirkpatrick K000237 | rep | IA | 1913-04-07 | 1915-03-03 | Democrat | 6 | |||||||||||||
16525 | 16525 | Irvin Pepper P000220 | rep | IA | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
16537 | 16537 | Solomon Prouty P000551 | rep | IA | 1913-04-07 | 1915-03-03 | Republican | 7 | |||||||||||||
16627 | 16627 | Henry Vollmer V000113 | rep | IA | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
17403 | 17403 | George Scott S000170 | rep | IA | 1913-04-07 | 1915-03-03 | Republican | 11 | |||||||||||||
17517 | 17517 | Frank Woods W000721 | rep | IA | 1913-04-07 | 1915-03-03 | Republican | 10 | |||||||||||||
17793 | 17793 | Charles Kennedy K000104 | rep | IA | 1913-04-07 | 1915-03-03 | Republican | 1 | |||||||||||||
18142 | 18142 | Albert Cummins C000988 | sen | IA | 1909-03-04 | 1915-03-03 | 3 | Republican | |||||||||||||
18196 | 18196 | James Good G000275 | rep | IA | 1913-04-07 | 1915-03-03 | Republican | 5 | |||||||||||||
18868 | 18868 | Horace Towner T000325 | rep | IA | 1913-04-07 | 1915-03-03 | Republican | 8 | |||||||||||||
19334 | 19334 | William Green G000422 | rep | IA | 1913-04-07 | 1915-03-03 | Republican | 9 | |||||||||||||
20487 | 20487 | Gilbert Haugen H000350 | rep | IA | 1913-04-07 | 1915-03-03 | Republican | 4 | |||||||||||||
16694 | 16694 | James Brady B000753 | sen | ID | 1913-04-07 | 1915-03-03 | 3 | Republican | |||||||||||||
20391 | 20391 | Burton French F000375 | rep | ID | 1913-04-07 | 1915-03-03 | Republican | -1 | |||||||||||||
20858 | 20858 | Addison Smith S000511 | rep | ID | 1913-04-07 | 1915-03-03 | Republican | -1 | |||||||||||||
16261 | 16261 | William Baltz B000107 | rep | IL | 1913-04-07 | 1915-03-03 | Democrat | 22 | |||||||||||||
16291 | 16291 | Charles Borchers B000635 | rep | IL | 1913-04-07 | 1915-03-03 | Democrat | 19 | |||||||||||||
16357 | 16357 | Louis Fitzhenry F000172 | rep | IL | 1913-04-07 | 1915-03-03 | Democrat | 17 | |||||||||||||
16364 | 16364 | Hiram Fowler F000321 | rep | IL | 1913-04-07 | 1915-03-03 | Democrat | 24 | |||||||||||||
16379 | 16379 | George Gorman G000327 | rep | IL | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
16382 | 16382 | James Graham G000357 | rep | IL | 1913-04-07 | 1915-03-03 | Democrat | 21 | |||||||||||||
16398 | 16398 | William Hinebaugh H000633 | rep | IL | 1913-04-07 | 1915-03-03 | Progressive | 12 | |||||||||||||
16404 | 16404 | Stephen Hoxworth H000873 | rep | IL | 1913-04-07 | 1915-03-03 | Democrat | 15 | |||||||||||||
16502 | 16502 | Frank O’Hair O000052 | rep | IL | 1913-04-07 | 1915-03-03 | Democrat | 18 | |||||||||||||
16596 | 16596 | Lawrence Stringer S001005 | rep | IL | 1913-04-07 | 1915-03-03 | Democrat | -1 | |||||||||||||
16614 | 16614 | Charles Thomson T000228 | rep | IL | 1913-04-07 | 1915-03-03 | Progressive | 10 | |||||||||||||
16710 | 16710 | Frank Buchanan B001001 | rep | IL | 1913-04-07 | 1915-03-03 | Democrat | 7 | |||||||||||||
16879 | 16879 | James McDermott M000405 | rep | IL | 1913-04-07 | 1915-03-03 | Democrat | 4 | |||||||||||||
16954 | 16954 | Lawrence Sherman S000348 | sen | IL | 1913-04-07 | 1915-03-03 | 3 | Republican |
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);