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 legislator_id descending
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
18027 | 18027 | James Young Y000040 | rep | TX | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
16651 | 16651 | Horace Young Y000038 | rep | MI | 1913-04-07 | 1915-03-03 | Republican | 12 | |||||||||||||
18901 | 18901 | George Young Y000036 | rep | ND | 1913-04-07 | 1915-03-03 | Republican | 2 | |||||||||||||
17517 | 17517 | Frank Woods W000721 | rep | IA | 1913-04-07 | 1915-03-03 | Republican | 10 | |||||||||||||
25552 | 25552 | Roy Woodruff W000718 | rep | MI | 1913-04-07 | 1915-03-03 | Progressive | 10 | |||||||||||||
17040 | 17040 | Samuel Witherspoon W000662 | rep | MS | 1913-04-07 | 1915-03-03 | Democrat | 5 | |||||||||||||
18889 | 18889 | Samuel Winslow W000639 | rep | MA | 1913-04-07 | 1915-03-03 | Republican | 4 | |||||||||||||
20050 | 20050 | Otis Wingo W000635 | rep | AR | 1913-04-07 | 1915-03-03 | Democrat | 4 | |||||||||||||
16645 | 16645 | Frank Wilson W000580 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
17037 | 17037 | Emmett Wilson W000575 | rep | FL | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
19546 | 19546 | Frank Willis W000561 | rep | OH | 1913-04-07 | 1915-03-03 | Republican | 8 | |||||||||||||
17035 | 17035 | William Williams W000548 | rep | IL | 1913-04-07 | 1915-03-03 | Democrat | -1 | |||||||||||||
16640 | 16640 | William Wilder W000462 | rep | MA | 1913-04-07 | 1915-03-03 | Republican | 3 | |||||||||||||
21003 | 21003 | James Wickersham W000438 | rep | AK | 1913-04-07 | 1915-03-03 | Republican | 0 | |||||||||||||
17502 | 17502 | George White W000370 | rep | OH | 1913-04-07 | 1915-03-03 | Democrat | 15 | |||||||||||||
16661 | 16661 | Francis White W000368 | sen | AL | 1914-01-01 | 1915-03-03 | 3 | Democrat | |||||||||||||
16638 | 16638 | John Whitacre W000347 | rep | OH | 1913-04-07 | 1915-03-03 | Democrat | 18 | |||||||||||||
18009 | 18009 | Richard Whaley W000319 | rep | SC | 1913-04-07 | 1915-03-03 | Democrat | 1 | |||||||||||||
16660 | 16660 | William West W000305 | sen | GA | 1914-03-02 | 1915-03-03 | 2 | Democrat | appointment | ||||||||||||
18001 | 18001 | Edwin Webb W000231 | rep | NC | 1913-04-07 | 1915-03-03 | Democrat | 9 | |||||||||||||
16630 | 16630 | Claude Weaver W000224 | rep | OK | 1913-04-07 | 1915-03-03 | Democrat | -1 | |||||||||||||
17992 | 17992 | Walter Watson W000206 | rep | VA | 1913-04-07 | 1915-03-03 | Democrat | 4 | |||||||||||||
17988 | 17988 | John Watkins W000193 | rep | LA | 1913-04-07 | 1915-03-03 | Democrat | 4 | |||||||||||||
19146 | 19146 | Anderson Walters W000109 | rep | PA | 1913-04-07 | 1915-03-03 | Republican | -1 | |||||||||||||
16629 | 16629 | Allan Walsh W000095 | rep | NJ | 1913-04-07 | 1915-03-03 | Democrat | 4 | |||||||||||||
16628 | 16628 | Samuel Wallin W000090 | rep | NY | 1913-04-07 | 1915-03-03 | Republican | 30 | |||||||||||||
17497 | 17497 | John Walker W000060 | rep | GA | 1913-04-07 | 1915-03-03 | Democrat | 11 | |||||||||||||
18543 | 18543 | Andrew Volstead V000114 | rep | MN | 1913-04-07 | 1915-03-03 | Republican | 7 | |||||||||||||
16627 | 16627 | Henry Vollmer V000113 | rep | IA | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
28203 | 28203 | Carl Vinson V000105 | rep | GA | 1913-04-07 | 1915-03-03 | Democrat | 10 | |||||||||||||
16626 | 16626 | Horace Vaughan V000075 | rep | TX | 1913-04-07 | 1915-03-03 | Democrat | 1 | |||||||||||||
19519 | 19519 | William Vare V000071 | rep | PA | 1913-04-07 | 1915-03-03 | Republican | 1 | |||||||||||||
18533 | 18533 | Oscar Underwood U000013 | rep | AL | 1913-04-07 | 1915-03-03 | Democrat | 9 | |||||||||||||
16624 | 16624 | Edwin Underhill U000007 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 37 | |||||||||||||
16622 | 16622 | William Tuttle T000439 | rep | NJ | 1913-04-07 | 1915-03-03 | Democrat | 5 | |||||||||||||
17031 | 17031 | Samuel Tribble T000366 | rep | GA | 1913-04-07 | 1915-03-03 | Democrat | 8 | |||||||||||||
23711 | 23711 | Allen Treadway T000358 | rep | MA | 1913-04-07 | 1915-03-03 | Republican | 1 | |||||||||||||
16620 | 16620 | Edward Townsend T000332 | rep | NJ | 1913-04-07 | 1915-03-03 | Democrat | 10 | |||||||||||||
18868 | 18868 | Horace Towner T000325 | rep | IA | 1913-04-07 | 1915-03-03 | Republican | 8 | |||||||||||||
15829 | 15829 | John Thornton T000241 | sen | LA | 1910-01-01 | 1915-03-03 | 3 | Democrat | |||||||||||||
16614 | 16614 | Charles Thomson T000228 | rep | IL | 1913-04-07 | 1915-03-03 | Progressive | 10 | |||||||||||||
17974 | 17974 | Joseph Thompson T000210 | rep | OK | 1913-04-07 | 1915-03-03 | Democrat | -1 | |||||||||||||
19124 | 19124 | Robert Thomas T000185 | rep | KY | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
17028 | 17028 | Charles Thomas T000160 | sen | CO | 1913-04-07 | 1915-03-03 | 3 | Democrat | |||||||||||||
16612 | 16612 | Thomas Thacher T000140 | rep | MA | 1913-04-07 | 1915-03-03 | Democrat | 16 | |||||||||||||
18521 | 18521 | Peter Ten Eyck T000126 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 28 | |||||||||||||
20916 | 20916 | Henry Temple T000119 | rep | PA | 1913-04-07 | 1915-03-03 | Progressive | 24 | |||||||||||||
18516 | 18516 | Samuel Taylor T000100 | rep | AR | 1913-04-07 | 1915-03-03 | Democrat | 6 | |||||||||||||
16611 | 16611 | George Taylor T000078 | rep | AL | 1913-04-07 | 1915-03-03 | Democrat | 1 | |||||||||||||
23272 | 23272 | Edward Taylor T000072 | rep | CO | 1913-04-07 | 1915-03-03 | Democrat | -1 | |||||||||||||
16602 | 16602 | Benjamin Taylor T000066 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 25 | |||||||||||||
17026 | 17026 | Clyde Tavenner T000059 | rep | IL | 1913-04-07 | 1915-03-03 | Democrat | 14 | |||||||||||||
16601 | 16601 | Charles Talcott T000023 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 33 | |||||||||||||
17486 | 17486 | Joshua Talbott T000021 | rep | MD | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
17024 | 17024 | Joseph Taggart T000011 | rep | KS | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
17474 | 17474 | Robert Switzer S001124 | rep | OH | 1913-04-07 | 1915-03-03 | Republican | 10 | |||||||||||||
17468 | 17468 | Howard Sutherland S001081 | rep | WV | 1913-04-07 | 1915-03-03 | Republican | -1 | |||||||||||||
24113 | 24113 | Hatton Sumners S001072 | rep | TX | 1913-04-07 | 1915-03-03 | Democrat | -1 | |||||||||||||
16599 | 16599 | Timothy Sullivan S001061 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 13 | |||||||||||||
16596 | 16596 | Lawrence Stringer S001005 | rep | IL | 1913-04-07 | 1915-03-03 | Democrat | -1 | |||||||||||||
17021 | 17021 | Tom Stout S000982 | rep | MT | 1913-04-07 | 1915-03-03 | Democrat | -1 | |||||||||||||
17019 | 17019 | William Stone S000968 | sen | MO | 1909-03-15 | 1915-03-03 | 3 | Democrat | |||||||||||||
17013 | 17013 | Claudius Stone S000954 | rep | IL | 1913-04-07 | 1915-03-03 | Democrat | 16 | |||||||||||||
16595 | 16595 | Raymond Stevens S000885 | rep | NH | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
16594 | 16594 | Frederick Stevens S000878 | rep | MN | 1913-04-07 | 1915-03-03 | Republican | 4 | |||||||||||||
15765 | 15765 | Isaac Stephenson S000863 | sen | WI | 1909-03-15 | 1915-03-03 | 3 | Republican | |||||||||||||
17010 | 17010 | William Stephens S000861 | rep | CA | 1913-04-07 | 1915-03-03 | Republican | 10 | |||||||||||||
17007 | 17007 | John Stephens S000858 | rep | TX | 1913-04-07 | 1915-03-03 | Democrat | 13 | |||||||||||||
19991 | 19991 | Hubert Stephens S000857 | rep | MS | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
17446 | 17446 | Dan Stephens S000856 | rep | NE | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
18499 | 18499 | Halvor Steenerson S000842 | rep | MN | 1913-04-07 | 1915-03-03 | Republican | 9 | |||||||||||||
19979 | 19979 | Charles Stedman S000827 | rep | NC | 1913-04-07 | 1915-03-03 | Democrat | 5 | |||||||||||||
17963 | 17963 | Augustus Stanley S000796 | rep | KY | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
20876 | 20876 | William Stafford S000777 | rep | WI | 1913-04-07 | 1915-03-03 | Republican | 5 | |||||||||||||
16996 | 16996 | Stephen Sparkman S000702 | rep | FL | 1913-04-07 | 1915-03-03 | Democrat | 1 | |||||||||||||
19489 | 19489 | Reed Smoot S000644 | sen | UT | 1909-03-15 | 1915-03-03 | 3 | Republican | |||||||||||||
16985 | 16985 | William Smith S000636 | rep | TX | 1913-04-07 | 1915-03-03 | Democrat | 16 | |||||||||||||
16577 | 16577 | Samuel Smith S000613 | rep | MI | 1913-04-07 | 1915-03-03 | Republican | 6 | |||||||||||||
16978 | 16978 | Marcus Smith S000589 | sen | AZ | 1912-01-01 | 1915-03-03 | 3 | Democrat | |||||||||||||
16968 | 16968 | John Smith S000577 | sen | MD | 1909-03-04 | 1915-03-03 | 3 | Democrat | |||||||||||||
18850 | 18850 | John Smith S000573 | rep | MI | 1913-04-07 | 1915-03-03 | Republican | 3 | |||||||||||||
16964 | 16964 | Hoke Smith S000551 | sen | GA | 1911-04-04 | 1915-03-03 | 3 | Democrat | |||||||||||||
16962 | 16962 | George Smith S000540 | rep | MN | 1913-04-07 | 1915-03-03 | Republican | 5 | |||||||||||||
16568 | 16568 | Frank Smith S000535 | rep | MD | 1913-04-07 | 1915-03-03 | Democrat | 5 | |||||||||||||
22785 | 22785 | Ellison Smith S000530 | sen | SC | 1909-03-15 | 1915-03-03 | 3 | Democrat | |||||||||||||
17439 | 17439 | Charles Smith S000520 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 41 | |||||||||||||
20858 | 20858 | Addison Smith S000511 | rep | ID | 1913-04-07 | 1915-03-03 | Republican | -1 | |||||||||||||
17952 | 17952 | John Small S000500 | rep | NC | 1913-04-07 | 1915-03-03 | Democrat | 1 | |||||||||||||
19956 | 19956 | Charles Sloan S000491 | rep | NE | 1913-04-07 | 1915-03-03 | Republican | 4 | |||||||||||||
18486 | 18486 | Campbell Slemp S000486 | rep | VA | 1913-04-07 | 1915-03-03 | Republican | 9 | |||||||||||||
17435 | 17435 | James Slayden S000482 | rep | TX | 1913-04-07 | 1915-03-03 | Democrat | 14 | |||||||||||||
18478 | 18478 | Thomas Sisson S000456 | rep | MS | 1913-04-07 | 1915-03-03 | Democrat | 4 | |||||||||||||
19480 | 19480 | Nicholas Sinnott S000450 | rep | OR | 1913-04-07 | 1915-03-03 | Republican | 2 | |||||||||||||
17941 | 17941 | Thetus Sims S000441 | rep | TN | 1913-04-07 | 1915-03-03 | Democrat | 8 | |||||||||||||
20845 | 20845 | Milton Shreve S000387 | rep | PA | 1913-04-07 | 1915-03-03 | Republican | 25 | |||||||||||||
16960 | 16960 | Benjamin Shively S000371 | sen | IN | 1909-03-15 | 1915-03-03 | 3 | Democrat | |||||||||||||
18843 | 18843 | Isaac Sherwood S000355 | rep | OH | 1913-04-07 | 1915-03-03 | Democrat | 9 | |||||||||||||
16954 | 16954 | Lawrence Sherman S000348 | sen | IL | 1913-04-07 | 1915-03-03 | 3 | Republican | |||||||||||||
17422 | 17422 | Joseph Sherley S000343 | rep | KY | 1913-04-07 | 1915-03-03 | Democrat | 5 | |||||||||||||
16567 | 16567 | William Sharp S000296 | rep | OH | 1913-04-07 | 1915-03-03 | Democrat | 14 |
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);