legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
444 rows where "end" is on date 1911-03-03 sorted by state
This data as json, copyable, CSV (advanced)
Suggested facets: state, start, class, district, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21001 | 21001 | James Wickersham W000438 | rep | AK | 1909-03-15 | 1911-03-03 | Republican | 0 | |||||||||||||
15406 | 15406 | William Craig C000861 | rep | AL | 1909-03-15 | 1911-03-03 | Democrat | 4 | |||||||||||||
16334 | 16334 | Henry Clayton C000495 | rep | AL | 1909-03-15 | 1911-03-03 | Democrat | 3 | |||||||||||||
16400 | 16400 | Richmond Hobson H000667 | rep | AL | 1909-03-15 | 1911-03-03 | Democrat | 6 | |||||||||||||
16546 | 16546 | William Richardson R000227 | rep | AL | 1909-03-15 | 1911-03-03 | Democrat | 8 | |||||||||||||
16609 | 16609 | George Taylor T000078 | rep | AL | 1909-03-15 | 1911-03-03 | Democrat | 1 | |||||||||||||
17585 | 17585 | John Burnett B001121 | rep | AL | 1909-03-15 | 1911-03-03 | Democrat | 7 | |||||||||||||
17635 | 17635 | Stanley Dent D000256 | rep | AL | 1909-03-15 | 1911-03-03 | Democrat | 2 | |||||||||||||
18531 | 18531 | Oscar Underwood U000013 | rep | AL | 1909-03-15 | 1911-03-03 | Democrat | 9 | |||||||||||||
18982 | 18982 | James Heflin H000446 | rep | AL | 1909-03-15 | 1911-03-03 | Democrat | 5 | |||||||||||||
15716 | 15716 | Charles Reid R000142 | rep | AR | 1909-03-15 | 1911-03-03 | Democrat | 5 | |||||||||||||
15801 | 15801 | Robert Wallace W000082 | rep | AR | 1909-03-15 | 1911-03-03 | Democrat | 7 | |||||||||||||
16069 | 16069 | Robert Macon M000035 | rep | AR | 1909-03-15 | 1911-03-03 | Democrat | 1 | |||||||||||||
16360 | 16360 | John Floyd F000222 | rep | AR | 1909-03-15 | 1911-03-03 | Democrat | 3 | |||||||||||||
19445 | 19445 | William Oldfield O000062 | rep | AR | 1909-03-15 | 1911-03-03 | Democrat | 2 | |||||||||||||
20810 | 20810 | Joseph Robinson R000347 | rep | AR | 1909-03-15 | 1911-03-03 | Democrat | 6 | |||||||||||||
22527 | 22527 | William Cravens C000886 | rep | AR | 1909-03-15 | 1911-03-03 | Democrat | 4 | |||||||||||||
18080 | 18080 | Ralph Cameron C000066 | rep | AZ | 1909-03-15 | 1911-03-03 | Republican | 0 | |||||||||||||
14662 | 14662 | Frank Flint F000207 | sen | CA | 1905-12-04 | 1911-03-03 | 1 | Republican | |||||||||||||
15449 | 15449 | William Englebright E000183 | rep | CA | 1909-03-15 | 1911-03-03 | Republican | 1 | |||||||||||||
15640 | 15640 | Duncan McKinlay M000518 | rep | CA | 1909-03-15 | 1911-03-03 | Republican | 2 | |||||||||||||
15646 | 15646 | James McLachlan M000532 | rep | CA | 1909-03-15 | 1911-03-03 | Republican | 7 | |||||||||||||
16126 | 16126 | James Needham N000021 | rep | CA | 1909-03-15 | 1911-03-03 | Republican | 6 | |||||||||||||
16184 | 16184 | Sylvester Smith S000614 | rep | CA | 1909-03-15 | 1911-03-03 | Republican | 8 | |||||||||||||
16428 | 16428 | Joseph Knowland K000291 | rep | CA | 1909-03-15 | 1911-03-03 | Republican | 3 | |||||||||||||
17254 | 17254 | Everis Hayes H000389 | rep | CA | 1909-03-15 | 1911-03-03 | Republican | 5 | |||||||||||||
18700 | 18700 | Julius Kahn K000003 | rep | CA | 1909-03-15 | 1911-03-03 | Republican | 4 | |||||||||||||
16178 | 16178 | Atterson Rucker R000492 | rep | CO | 1909-03-15 | 1911-03-03 | Democrat | 1 | |||||||||||||
22689 | 22689 | John Martin M000186 | rep | CO | 1909-03-15 | 1911-03-03 | Democrat | 2 | |||||||||||||
23270 | 23270 | Edward Taylor T000072 | rep | CO | 1909-03-15 | 1911-03-03 | Democrat | -1 | |||||||||||||
14598 | 14598 | Morgan Bulkeley B001044 | sen | CT | 1905-12-04 | 1911-03-03 | 1 | Republican | |||||||||||||
15753 | 15753 | Nehemiah Sperry S000733 | rep | CT | 1909-03-15 | 1911-03-03 | Republican | 2 | |||||||||||||
16004 | 16004 | Edward Henry H000505 | rep | CT | 1909-03-15 | 1911-03-03 | Republican | 1 | |||||||||||||
16008 | 16008 | Edwin Higgins H000578 | rep | CT | 1909-03-15 | 1911-03-03 | Republican | 3 | |||||||||||||
17280 | 17280 | Ebenezer Hill H000591 | rep | CT | 1909-03-15 | 1911-03-03 | Republican | 4 | |||||||||||||
20932 | 20932 | John Tilson T000279 | rep | CT | 1909-03-15 | 1911-03-03 | Republican | -1 | |||||||||||||
15995 | 15995 | William Heald H000422 | rep | DE | 1909-03-15 | 1911-03-03 | Republican | 0 | |||||||||||||
16241 | 16241 | Henry du Pont D000559 | sen | DE | 1906-01-01 | 1911-03-03 | 1 | Republican | |||||||||||||
14917 | 14917 | James Taliaferro T000026 | sen | FL | 1905-12-04 | 1911-03-03 | 1 | Democrat | |||||||||||||
16079 | 16079 | Dannite Mays M000289 | rep | FL | 1909-03-15 | 1911-03-03 | Democrat | 3 | |||||||||||||
16994 | 16994 | Stephen Sparkman S000702 | rep | FL | 1909-03-15 | 1911-03-03 | Democrat | 1 | |||||||||||||
18585 | 18585 | Frank Clark C000430 | rep | FL | 1909-03-15 | 1911-03-03 | Democrat | 2 | |||||||||||||
15388 | 15388 | Alexander Clay C000478 | sen | GA | 1909-03-15 | 1911-03-03 | 3 | Democrat | |||||||||||||
15513 | 15513 | James Griggs G000473 | rep | GA | 1909-03-15 | 1911-03-03 | Democrat | 2 | |||||||||||||
15528 | 15528 | William Howard H000848 | rep | GA | 1909-03-15 | 1911-03-03 | Democrat | 8 | |||||||||||||
15609 | 15609 | Leonidas Livingston L000368 | rep | GA | 1909-03-15 | 1911-03-03 | Democrat | 5 | |||||||||||||
15885 | 15885 | William Brantley B000770 | rep | GA | 1909-03-15 | 1911-03-03 | Democrat | 11 | |||||||||||||
16280 | 16280 | Charles Bartlett B000199 | rep | GA | 1909-03-15 | 1911-03-03 | Democrat | 6 | |||||||||||||
16549 | 16549 | Seaborn Roddenbery R000370 | rep | GA | 1909-03-15 | 1911-03-03 | Democrat | 2 | |||||||||||||
16656 | 16656 | Thomas Hardwick H000193 | rep | GA | 1909-03-15 | 1911-03-03 | Democrat | 10 | |||||||||||||
16812 | 16812 | Dudley Hughes H000920 | rep | GA | 1909-03-15 | 1911-03-03 | Democrat | 3 | |||||||||||||
17050 | 17050 | William Adamson A000051 | rep | GA | 1909-03-15 | 1911-03-03 | Democrat | 4 | |||||||||||||
19022 | 19022 | Gordon Lee L000194 | rep | GA | 1909-03-15 | 1911-03-03 | Democrat | 7 | |||||||||||||
19576 | 19576 | Thomas Bell B000348 | rep | GA | 1909-03-15 | 1911-03-03 | Democrat | 9 | |||||||||||||
20341 | 20341 | Charles Edwards E000062 | rep | GA | 1909-03-15 | 1911-03-03 | Democrat | 1 | |||||||||||||
18260 | 18260 | Jonah Kalanianaole K000004 | rep | HI | 1909-03-15 | 1911-03-03 | Republican | -1 | |||||||||||||
15418 | 15418 | Albert Dawson D000150 | rep | IA | 1909-03-15 | 1911-03-03 | Republican | 2 | |||||||||||||
15555 | 15555 | John Hull H000942 | rep | IA | 1909-03-15 | 1911-03-03 | Republican | 7 | |||||||||||||
15556 | 15556 | William Jamieson J000055 | rep | IA | 1909-03-15 | 1911-03-03 | Democrat | 8 | |||||||||||||
16015 | 16015 | Elbert Hubbard H000882 | rep | IA | 1909-03-15 | 1911-03-03 | Republican | 11 | |||||||||||||
16019 | 16019 | Nathan Kendall K000096 | rep | IA | 1909-03-15 | 1911-03-03 | Republican | 6 | |||||||||||||
16145 | 16145 | Charles Pickett P000325 | rep | IA | 1909-03-15 | 1911-03-03 | Republican | 3 | |||||||||||||
16191 | 16191 | Walter Smith S000623 | rep | IA | 1909-03-15 | 1911-03-03 | Republican | 9 | |||||||||||||
17515 | 17515 | Frank Woods W000721 | rep | IA | 1909-03-15 | 1911-03-03 | Republican | 10 | |||||||||||||
17791 | 17791 | Charles Kennedy K000104 | rep | IA | 1909-03-15 | 1911-03-03 | Republican | 1 | |||||||||||||
18194 | 18194 | James Good G000275 | rep | IA | 1909-03-15 | 1911-03-03 | Republican | 5 | |||||||||||||
20485 | 20485 | Gilbert Haugen H000350 | rep | IA | 1909-03-15 | 1911-03-03 | Republican | 4 | |||||||||||||
15514 | 15514 | Thomas Hamer H000098 | rep | ID | 1909-03-15 | 1911-03-03 | Republican | 1 | |||||||||||||
15350 | 15350 | Henry Boutell B000672 | rep | IL | 1909-03-15 | 1911-03-03 | Republican | 9 | |||||||||||||
15385 | 15385 | Pleasant Chapman C000315 | rep | IL | 1909-03-15 | 1911-03-03 | Republican | 24 | |||||||||||||
15499 | 15499 | Joseph Graff G000351 | rep | IL | 1909-03-15 | 1911-03-03 | Republican | 16 | |||||||||||||
15626 | 15626 | Frank Lowden L000472 | rep | IL | 1909-03-15 | 1911-03-03 | Republican | 13 | |||||||||||||
15627 | 15627 | Frederick Lundin L000515 | rep | IL | 1909-03-15 | 1911-03-03 | Republican | 7 | |||||||||||||
15660 | 15660 | William Moxley M001053 | rep | IL | 1909-03-15 | 1911-03-03 | Republican | 6 | |||||||||||||
15738 | 15738 | Howard Snapp S000650 | rep | IL | 1909-03-15 | 1911-03-03 | Republican | 11 | |||||||||||||
16101 | 16101 | James McKinney M000524 | rep | IL | 1909-03-15 | 1911-03-03 | Republican | 14 | |||||||||||||
16157 | 16157 | George Prince P000538 | rep | IL | 1909-03-15 | 1911-03-03 | Republican | 15 | |||||||||||||
16214 | 16214 | Napoleon Thistlewood T000154 | rep | IL | 1909-03-15 | 1911-03-03 | Republican | 25 | |||||||||||||
16380 | 16380 | James Graham G000357 | rep | IL | 1909-03-15 | 1911-03-03 | Democrat | 21 | |||||||||||||
16877 | 16877 | James McDermott M000405 | rep | IL | 1909-03-15 | 1911-03-03 | Democrat | 4 | |||||||||||||
17202 | 17202 | George Foss F000295 | rep | IL | 1909-03-15 | 1911-03-03 | Republican | 10 | |||||||||||||
17207 | 17207 | Martin Foster F000309 | rep | IL | 1909-03-15 | 1911-03-03 | Democrat | 23 | |||||||||||||
17453 | 17453 | John Sterling S000870 | rep | IL | 1909-03-15 | 1911-03-03 | Republican | 17 | |||||||||||||
17704 | 17704 | Thomas Gallagher G000018 | rep | IL | 1909-03-15 | 1911-03-03 | Democrat | 8 | |||||||||||||
18019 | 18019 | William Wilson W000624 | rep | IL | 1909-03-15 | 1911-03-03 | Republican | 3 | |||||||||||||
18110 | 18110 | Joseph Cannon C000121 | rep | IL | 1909-03-15 | 1911-03-03 | Republican | 18 | |||||||||||||
18328 | 18328 | James Mann M000104 | rep | IL | 1909-03-15 | 1911-03-03 | Republican | 2 | |||||||||||||
18348 | 18348 | William McKinley M000521 | rep | IL | 1909-03-15 | 1911-03-03 | Republican | 19 | |||||||||||||
18446 | 18446 | William Rodenberg R000371 | rep | IL | 1909-03-15 | 1911-03-03 | Republican | 22 | |||||||||||||
18948 | 18948 | Charles Fuller F000407 | rep | IL | 1909-03-15 | 1911-03-03 | Republican | 12 | |||||||||||||
19408 | 19408 | Martin Madden M000038 | rep | IL | 1909-03-15 | 1911-03-03 | Republican | 1 | |||||||||||||
21514 | 21514 | Henry Rainey R000014 | rep | IL | 1909-03-15 | 1911-03-03 | Democrat | 20 | |||||||||||||
25455 | 25455 | Adolph Sabath S000001 | rep | IL | 1909-03-15 | 1911-03-03 | Democrat | 5 | |||||||||||||
14574 | 14574 | Albert Beveridge B000429 | sen | IN | 1905-12-04 | 1911-03-03 | 1 | Republican | |||||||||||||
15338 | 15338 | William Barnard B000155 | rep | IN | 1909-03-15 | 1911-03-03 | Republican | 6 | |||||||||||||
15871 | 15871 | John Boehne B000587 | rep | IN | 1909-03-15 | 1911-03-03 | Democrat | 1 | |||||||||||||
15908 | 15908 | Edgar Crumpacker C000958 | rep | IN | 1909-03-15 | 1911-03-03 | Republican | 10 | |||||||||||||
16433 | 16433 | Charles Korbly K000316 | rep | IN | 1909-03-15 | 1911-03-03 | Democrat | 7 | |||||||||||||
16665 | 16665 | John Adair A000027 | rep | IN | 1909-03-15 | 1911-03-03 | Democrat | 8 | |||||||||||||
16732 | 16732 | Cyrus Cline C000521 | rep | IN | 1909-03-15 | 1911-03-03 | Democrat | 12 |
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);