legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
451 rows where "start" is on date 1911-04-04 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: state, end, party, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
27843 | 27843 | Carl Hayden H000385 | rep | AZ | 1911-04-04 | 1913-03-03 | Democrat | 0 | |||||||||||||
25456 | 25456 | Adolph Sabath S000001 | rep | IL | 1911-04-04 | 1913-03-03 | Democrat | 5 | |||||||||||||
25213 | 25213 | Robert Doughton D000448 | rep | NC | 1911-04-04 | 1913-03-03 | Democrat | 8 | |||||||||||||
24604 | 24604 | Kenneth McKellar M000499 | rep | TN | 1911-04-04 | 1913-03-03 | Democrat | 10 | |||||||||||||
23819 | 23819 | James Curley C000996 | rep | MA | 1911-04-04 | 1913-03-03 | Democrat | 10 | |||||||||||||
23517 | 23517 | Carter Glass G000232 | rep | VA | 1911-04-04 | 1913-03-03 | Democrat | 6 | |||||||||||||
23271 | 23271 | Edward Taylor T000072 | rep | CO | 1911-04-04 | 1913-03-03 | Democrat | -1 | |||||||||||||
22690 | 22690 | John Martin M000186 | rep | CO | 1911-04-04 | 1913-03-03 | Democrat | 2 | |||||||||||||
22528 | 22528 | William Cravens C000886 | rep | AR | 1911-04-04 | 1913-03-03 | Democrat | 4 | |||||||||||||
22478 | 22478 | William Ashbrook A000306 | rep | OH | 1911-04-04 | 1913-03-03 | Democrat | 17 | |||||||||||||
22408 | 22408 | Morris Sheppard S000337 | rep | TX | 1911-04-04 | 1913-03-03 | Democrat | 1 | |||||||||||||
22334 | 22334 | George Norris N000139 | rep | NE | 1911-04-04 | 1913-03-03 | Republican | 5 | |||||||||||||
22268 | 22268 | David Lewis L000277 | rep | MD | 1911-04-04 | 1913-03-03 | Democrat | 6 | |||||||||||||
22218 | 22218 | Byron Harrison H000265 | rep | MS | 1911-04-04 | 1913-03-03 | Democrat | 6 | |||||||||||||
22186 | 22186 | Finly Gray G000395 | rep | IN | 1911-04-04 | 1913-03-03 | Democrat | 6 | |||||||||||||
22145 | 22145 | Benjamin Focht F000230 | rep | PA | 1911-04-04 | 1913-03-03 | Republican | 17 | |||||||||||||
22077 | 22077 | James Byrnes B001215 | rep | SC | 1911-04-04 | 1913-03-03 | Democrat | 2 | |||||||||||||
21671 | 21671 | Joseph Byrns B001217 | rep | TN | 1911-04-04 | 1913-03-03 | Democrat | 6 | |||||||||||||
21515 | 21515 | Henry Rainey R000014 | rep | IL | 1911-04-04 | 1913-03-03 | Democrat | 20 | |||||||||||||
21487 | 21487 | Edward Pou P000474 | rep | NC | 1911-04-04 | 1913-03-03 | Democrat | 4 | |||||||||||||
21285 | 21285 | John Garner G000074 | rep | TX | 1911-04-04 | 1913-03-03 | Democrat | 15 | |||||||||||||
21224 | 21224 | Clement Dickinson D000316 | rep | MO | 1911-04-04 | 1913-03-03 | Democrat | 6 | |||||||||||||
21174 | 21174 | Robert Bulkley B001045 | rep | OH | 1911-04-04 | 1913-03-03 | Democrat | 21 | |||||||||||||
21002 | 21002 | James Wickersham W000438 | rep | AK | 1911-04-04 | 1913-03-03 | Republican | 0 | |||||||||||||
20933 | 20933 | John Tilson T000279 | rep | CT | 1911-04-04 | 1913-03-03 | Republican | -1 | |||||||||||||
20811 | 20811 | Joseph Robinson R000347 | rep | AR | 1911-04-04 | 1913-03-03 | Democrat | 6 | |||||||||||||
20749 | 20749 | John Nelson N000039 | rep | WI | 1911-04-04 | 1913-03-03 | Republican | 2 | |||||||||||||
20699 | 20699 | James McLaughlin M000539 | rep | MI | 1911-04-04 | 1913-03-03 | Republican | 9 | |||||||||||||
20668 | 20668 | Nicholas Longworth L000433 | rep | OH | 1911-04-04 | 1913-03-03 | Republican | 1 | |||||||||||||
20653 | 20653 | John Linthicum L000340 | rep | MD | 1911-04-04 | 1913-03-03 | Democrat | 4 | |||||||||||||
20541 | 20541 | Cordell Hull H000940 | rep | TN | 1911-04-04 | 1913-03-03 | Democrat | 4 | |||||||||||||
20499 | 20499 | Willis Hawley H000379 | rep | OR | 1911-04-04 | 1913-03-03 | Republican | 1 | |||||||||||||
20486 | 20486 | Gilbert Haugen H000350 | rep | IA | 1911-04-04 | 1913-03-03 | Republican | 4 | |||||||||||||
20390 | 20390 | Burton French F000375 | rep | ID | 1911-04-04 | 1913-03-03 | Republican | 1 | |||||||||||||
20342 | 20342 | Charles Edwards E000062 | rep | GA | 1911-04-04 | 1913-03-03 | Democrat | 1 | |||||||||||||
20319 | 20319 | Leonidas Dyer D000591 | rep | MO | 1911-04-04 | 1913-03-03 | Republican | 12 | |||||||||||||
20240 | 20240 | Henry Cooper C000752 | rep | WI | 1911-04-04 | 1913-03-03 | Republican | 1 | |||||||||||||
20211 | 20211 | James Collier C000630 | rep | MS | 1911-04-04 | 1913-03-03 | Democrat | 8 | |||||||||||||
20015 | 20015 | Claude Swanson S001094 | sen | VA | 1911-04-04 | 1917-03-03 | 1 | Democrat | |||||||||||||
19990 | 19990 | Hubert Stephens S000857 | rep | MS | 1911-04-04 | 1913-03-03 | Democrat | 2 | |||||||||||||
19978 | 19978 | Charles Stedman S000827 | rep | NC | 1911-04-04 | 1913-03-03 | Democrat | 5 | |||||||||||||
19955 | 19955 | Charles Sloan S000491 | rep | NE | 1911-04-04 | 1913-03-03 | Republican | 4 | |||||||||||||
19924 | 19924 | Stephen Porter P000447 | rep | PA | 1911-04-04 | 1913-03-03 | Republican | 29 | |||||||||||||
19789 | 19789 | James Hughes H000924 | rep | WV | 1911-04-04 | 1913-03-03 | Republican | 5 | |||||||||||||
19742 | 19742 | William Griest G000456 | rep | PA | 1911-04-04 | 1913-03-03 | Republican | 9 | |||||||||||||
19577 | 19577 | Thomas Bell B000348 | rep | GA | 1911-04-04 | 1913-03-03 | Democrat | 9 | |||||||||||||
19545 | 19545 | Frank Willis W000561 | rep | OH | 1911-04-04 | 1913-03-03 | Republican | 8 | |||||||||||||
19518 | 19518 | William Vare V000071 | rep | PA | 1911-04-04 | 1913-03-03 | Republican | 1 | |||||||||||||
19470 | 19470 | Thomas Rubey R000491 | rep | MO | 1911-04-04 | 1913-03-03 | Democrat | 16 | |||||||||||||
19446 | 19446 | William Oldfield O000062 | rep | AR | 1911-04-04 | 1913-03-03 | Democrat | 2 | |||||||||||||
19409 | 19409 | Martin Madden M000038 | rep | IL | 1911-04-04 | 1913-03-03 | Republican | 1 | |||||||||||||
19373 | 19373 | John Kindred K000191 | rep | NY | 1911-04-04 | 1913-03-03 | Democrat | 14 | |||||||||||||
19333 | 19333 | William Green G000422 | rep | IA | 1911-04-04 | 1913-03-03 | Republican | 9 | |||||||||||||
19322 | 19322 | Finis Garrett G000082 | rep | TN | 1911-04-04 | 1913-03-03 | Democrat | 9 | |||||||||||||
19247 | 19247 | Thomas Butler B001192 | rep | PA | 1911-04-04 | 1913-03-03 | Republican | 7 | |||||||||||||
19207 | 19207 | Victor Berger B000407 | rep | WI | 1911-04-04 | 1913-03-03 | Socialist | 5 | |||||||||||||
19189 | 19189 | Daniel Anthony A000261 | rep | KS | 1911-04-04 | 1913-03-03 | Republican | 1 | |||||||||||||
19123 | 19123 | Robert Thomas T000185 | rep | KY | 1911-04-04 | 1913-03-03 | Democrat | 3 | |||||||||||||
19088 | 19088 | Arthur Rouse R000466 | rep | KY | 1911-04-04 | 1913-03-03 | Democrat | 6 | |||||||||||||
19077 | 19077 | Joseph Ransdell R000059 | rep | LA | 1911-04-04 | 1913-03-03 | Democrat | 5 | |||||||||||||
19063 | 19063 | John Raker R000019 | rep | CA | 1911-04-04 | 1913-03-03 | Democrat | 1 | |||||||||||||
19023 | 19023 | Gordon Lee L000194 | rep | GA | 1911-04-04 | 1913-03-03 | Democrat | 7 | |||||||||||||
19012 | 19012 | John Langley L000072 | rep | KY | 1911-04-04 | 1913-03-03 | Republican | 10 | |||||||||||||
18997 | 18997 | Ben Johnson J000118 | rep | KY | 1911-04-04 | 1913-03-03 | Democrat | 4 | |||||||||||||
18983 | 18983 | James Heflin H000446 | rep | AL | 1911-04-04 | 1913-03-03 | Democrat | 5 | |||||||||||||
18968 | 18968 | Frederick Gillett G000201 | rep | MA | 1911-04-04 | 1913-03-03 | Republican | 2 | |||||||||||||
18949 | 18949 | Charles Fuller F000407 | rep | IL | 1911-04-04 | 1913-03-03 | Republican | 12 | |||||||||||||
18918 | 18918 | Charles Carter C000196 | rep | OK | 1911-04-04 | 1913-03-03 | Democrat | 4 | |||||||||||||
18867 | 18867 | Horace Towner T000325 | rep | IA | 1911-04-04 | 1913-03-03 | Republican | 8 | |||||||||||||
18849 | 18849 | John Smith S000573 | rep | MI | 1911-04-04 | 1913-03-03 | Republican | 3 | |||||||||||||
18842 | 18842 | Isaac Sherwood S000355 | rep | OH | 1911-04-04 | 1913-03-03 | Democrat | 9 | |||||||||||||
18822 | 18822 | Daniel Riordan R000264 | rep | NY | 1911-04-04 | 1913-03-03 | Democrat | 8 | |||||||||||||
18810 | 18810 | James Reed R000118 | sen | MO | 1911-04-04 | 1917-03-03 | 1 | Democrat | |||||||||||||
18772 | 18772 | Luther Mott M001041 | rep | NY | 1911-04-04 | 1913-03-03 | Republican | 28 | |||||||||||||
18756 | 18756 | George McLean M000547 | sen | CT | 1911-04-04 | 1917-03-03 | 1 | Republican | |||||||||||||
18749 | 18749 | John McKenzie M000506 | rep | IL | 1911-04-04 | 1913-03-03 | Republican | 13 | |||||||||||||
18741 | 18741 | Henry Lodge L000393 | sen | MA | 1911-04-04 | 1917-03-03 | 1 | Republican | |||||||||||||
18724 | 18724 | Robert La Follette L000004 | sen | WI | 1911-04-04 | 1917-03-03 | 1 | Republican | |||||||||||||
18713 | 18713 | Claude Kitchin K000250 | rep | NC | 1911-04-04 | 1913-03-03 | Democrat | 2 | |||||||||||||
18701 | 18701 | Julius Kahn K000003 | rep | CA | 1911-04-04 | 1913-03-03 | Republican | 4 | |||||||||||||
18685 | 18685 | Benjamin Humphreys H000960 | rep | MS | 1911-04-04 | 1913-03-03 | Democrat | 3 | |||||||||||||
18667 | 18667 | William Greene G000430 | rep | MA | 1911-04-04 | 1913-03-03 | Republican | 13 | |||||||||||||
18641 | 18641 | William Fields F000113 | rep | KY | 1911-04-04 | 1913-03-03 | Democrat | 9 | |||||||||||||
18619 | 18619 | Henry Dupré D000561 | rep | LA | 1911-04-04 | 1913-03-03 | Democrat | 2 | |||||||||||||
18611 | 18611 | Charles Davis D000093 | rep | MN | 1911-04-04 | 1913-03-03 | Republican | 3 | |||||||||||||
18586 | 18586 | Frank Clark C000430 | rep | FL | 1911-04-04 | 1913-03-03 | Democrat | 2 | |||||||||||||
18576 | 18576 | James Cantrill C000126 | rep | KY | 1911-04-04 | 1913-03-03 | Democrat | 7 | |||||||||||||
18564 | 18564 | Sydney Anderson A000233 | rep | MN | 1911-04-04 | 1913-03-03 | Republican | 1 | |||||||||||||
18542 | 18542 | Andrew Volstead V000114 | rep | MN | 1911-04-04 | 1913-03-03 | Republican | 7 | |||||||||||||
18532 | 18532 | Oscar Underwood U000013 | rep | AL | 1911-04-04 | 1913-03-03 | Democrat | 9 | |||||||||||||
18515 | 18515 | Samuel Taylor T000100 | rep | AR | 1911-04-04 | 1913-03-03 | Democrat | 6 | |||||||||||||
18498 | 18498 | Halvor Steenerson S000842 | rep | MN | 1911-04-04 | 1913-03-03 | Republican | 9 | |||||||||||||
18485 | 18485 | Campbell Slemp S000486 | rep | VA | 1911-04-04 | 1913-03-03 | Republican | 9 | |||||||||||||
18477 | 18477 | Thomas Sisson S000456 | rep | MS | 1911-04-04 | 1913-03-03 | Democrat | 4 | |||||||||||||
18462 | 18462 | William Rucker R000494 | rep | MO | 1911-04-04 | 1913-03-03 | Democrat | 2 | |||||||||||||
18447 | 18447 | William Rodenberg R000371 | rep | IL | 1911-04-04 | 1913-03-03 | Republican | 22 | |||||||||||||
18395 | 18395 | Lemuel Padgett P000012 | rep | TN | 1911-04-04 | 1913-03-03 | Democrat | 7 | |||||||||||||
18366 | 18366 | Franklin Mondell M000852 | rep | WY | 1911-04-04 | 1913-03-03 | Republican | 0 | |||||||||||||
18349 | 18349 | William McKinley M000521 | rep | IL | 1911-04-04 | 1913-03-03 | Republican | 19 | |||||||||||||
18329 | 18329 | James Mann M000104 | rep | IL | 1911-04-04 | 1913-03-03 | Republican | 2 |
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);