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
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14545 | 14545 | Charles Dick D000302 | sen | OH | 1905-03-05 | 1911-03-03 | 1 | Republican | |||||||||||||
14561 | 14561 | Nelson Aldrich A000083 | sen | RI | 1905-12-04 | 1911-03-03 | 1 | Republican | |||||||||||||
14574 | 14574 | Albert Beveridge B000429 | sen | IN | 1905-12-04 | 1911-03-03 | 1 | Republican | |||||||||||||
14598 | 14598 | Morgan Bulkeley B001044 | sen | CT | 1905-12-04 | 1911-03-03 | 1 | Republican | |||||||||||||
14602 | 14602 | Elmer Burkett B001103 | sen | NE | 1905-12-04 | 1911-03-03 | 1 | Republican | |||||||||||||
14613 | 14613 | Julius Burrows B001142 | sen | MI | 1905-12-04 | 1911-03-03 | 1 | Republican | |||||||||||||
14618 | 14618 | Thomas Carter C000200 | sen | MT | 1905-12-04 | 1911-03-03 | 1 | Republican | |||||||||||||
14630 | 14630 | John Daniel D000035 | sen | VA | 1905-12-04 | 1911-03-03 | 1 | Democrat | |||||||||||||
14642 | 14642 | Chauncey Depew D000264 | sen | NY | 1905-12-04 | 1911-03-03 | 1 | Republican | |||||||||||||
14662 | 14662 | Frank Flint F000207 | sen | CA | 1905-12-04 | 1911-03-03 | 1 | Republican | |||||||||||||
14663 | 14663 | James Frazier F000352 | sen | TN | 1905-12-04 | 1911-03-03 | 1 | Democrat | |||||||||||||
14694 | 14694 | Eugene Hale H000029 | sen | ME | 1905-12-04 | 1911-03-03 | 1 | Republican | |||||||||||||
14738 | 14738 | John Kean K000028 | sen | NJ | 1905-12-04 | 1911-03-03 | 1 | Republican | |||||||||||||
14840 | 14840 | Hernando Money M000854 | sen | MS | 1905-12-04 | 1911-03-03 | 1 | Democrat | |||||||||||||
14862 | 14862 | Samuel Piles P000351 | sen | WA | 1905-12-04 | 1911-03-03 | 1 | Republican | |||||||||||||
14888 | 14888 | Nathan Scott S000182 | sen | WV | 1905-12-04 | 1911-03-03 | 1 | Republican | |||||||||||||
14917 | 14917 | James Taliaferro T000026 | sen | FL | 1905-12-04 | 1911-03-03 | 1 | Democrat | |||||||||||||
14944 | 14944 | William Warner W000160 | sen | MO | 1905-12-04 | 1911-03-03 | 1 | Republican | |||||||||||||
15329 | 15329 | De Alexander A000091 | rep | NY | 1909-03-15 | 1911-03-03 | Republican | 36 | |||||||||||||
15335 | 15335 | Amos Allen A000112 | rep | ME | 1909-03-15 | 1911-03-03 | Republican | 1 | |||||||||||||
15337 | 15337 | Charles Barclay B000135 | rep | PA | 1909-03-15 | 1911-03-03 | Republican | 21 | |||||||||||||
15338 | 15338 | William Barnard B000155 | rep | IN | 1909-03-15 | 1911-03-03 | Republican | 6 | |||||||||||||
15340 | 15340 | George Bartlett B000203 | rep | NV | 1909-03-15 | 1911-03-03 | Democrat | 0 | |||||||||||||
15343 | 15343 | Joseph Bennett B000378 | rep | KY | 1909-03-15 | 1911-03-03 | Republican | 9 | |||||||||||||
15350 | 15350 | Henry Boutell B000672 | rep | IL | 1909-03-15 | 1911-03-03 | Republican | 9 | |||||||||||||
15354 | 15354 | Eaton Bowers B000689 | rep | MS | 1909-03-15 | 1911-03-03 | Democrat | 6 | |||||||||||||
15363 | 15363 | Walter Brownlow B000962 | rep | TN | 1909-03-15 | 1911-03-03 | Republican | 1 | |||||||||||||
15367 | 15367 | Adam Byrd B001207 | rep | MS | 1909-03-15 | 1911-03-03 | Democrat | 5 | |||||||||||||
15374 | 15374 | William Calderhead C000026 | rep | KS | 1909-03-15 | 1911-03-03 | Republican | 5 | |||||||||||||
15381 | 15381 | Adin Capron C000135 | rep | RI | 1909-03-15 | 1911-03-03 | Republican | 2 | |||||||||||||
15382 | 15382 | James Cassidy C000238 | rep | OH | 1909-03-15 | 1911-03-03 | Republican | 21 | |||||||||||||
15385 | 15385 | Pleasant Chapman C000315 | rep | IL | 1909-03-15 | 1911-03-03 | Republican | 24 | |||||||||||||
15388 | 15388 | Alexander Clay C000478 | sen | GA | 1909-03-15 | 1911-03-03 | 3 | Democrat | |||||||||||||
15391 | 15391 | William Cocks C000578 | rep | NY | 1909-03-15 | 1911-03-03 | Republican | 1 | |||||||||||||
15394 | 15394 | Ralph Cole C000612 | rep | OH | 1909-03-15 | 1911-03-03 | Republican | 8 | |||||||||||||
15396 | 15396 | Joel Cook C000718 | rep | PA | 1909-03-15 | 1911-03-03 | Republican | 2 | |||||||||||||
15400 | 15400 | Allen Cooper C000745 | rep | PA | 1909-03-15 | 1911-03-03 | Republican | 23 | |||||||||||||
15403 | 15403 | Harry Coudrey C000805 | rep | MO | 1909-03-15 | 1911-03-03 | Republican | 12 | |||||||||||||
15404 | 15404 | Charles Cowles C000826 | rep | NC | 1909-03-15 | 1911-03-03 | Republican | 8 | |||||||||||||
15406 | 15406 | William Craig C000861 | rep | AL | 1909-03-15 | 1911-03-03 | Democrat | 4 | |||||||||||||
15408 | 15408 | Charles Creager C000897 | rep | OK | 1909-03-15 | 1911-03-03 | Republican | 3 | |||||||||||||
15409 | 15409 | Charles Crow C000937 | rep | MO | 1909-03-15 | 1911-03-03 | Republican | 14 | |||||||||||||
15415 | 15415 | Francis Cushman C001018 | rep | WA | 1909-03-15 | 1911-03-03 | Republican | 2 | |||||||||||||
15418 | 15418 | Albert Dawson D000150 | rep | IA | 1909-03-15 | 1911-03-03 | Republican | 2 | |||||||||||||
15428 | 15428 | David De Armond D000167 | rep | MO | 1909-03-15 | 1911-03-03 | Democrat | 6 | |||||||||||||
15431 | 15431 | Edwin Denby D000232 | rep | MI | 1909-03-15 | 1911-03-03 | Republican | 1 | |||||||||||||
15433 | 15433 | Gerrit Diekema D000336 | rep | MI | 1909-03-15 | 1911-03-03 | Republican | 5 | |||||||||||||
15435 | 15435 | Albert Douglas D000449 | rep | OH | 1909-03-15 | 1911-03-03 | Republican | 11 | |||||||||||||
15437 | 15437 | Cyrus Durey D000567 | rep | NY | 1909-03-15 | 1911-03-03 | Republican | 25 | |||||||||||||
15440 | 15440 | Don Edwards E000065 | rep | KY | 1909-03-15 | 1911-03-03 | Republican | 11 | |||||||||||||
15445 | 15445 | William Ellis E000138 | rep | OR | 1909-03-15 | 1911-03-03 | Republican | 2 | |||||||||||||
15446 | 15446 | Politte Elvins E000163 | rep | MO | 1909-03-15 | 1911-03-03 | Republican | 13 | |||||||||||||
15449 | 15449 | William Englebright E000183 | rep | CA | 1909-03-15 | 1911-03-03 | Republican | 1 | |||||||||||||
15452 | 15452 | Jacob Fassett F000042 | rep | NY | 1909-03-15 | 1911-03-03 | Republican | 33 | |||||||||||||
15453 | 15453 | Hamilton Fish F000139 | rep | NY | 1909-03-15 | 1911-03-03 | Republican | 21 | |||||||||||||
15455 | 15455 | Otto Foelker F000231 | rep | NY | 1909-03-15 | 1911-03-03 | Republican | 3 | |||||||||||||
15456 | 15456 | Eugene Foss F000293 | rep | MA | 1909-03-15 | 1911-03-03 | Democrat | 14 | |||||||||||||
15458 | 15458 | William Foulkrod F000318 | rep | PA | 1909-03-15 | 1911-03-03 | Republican | 5 | |||||||||||||
15466 | 15466 | Charles Fowler F000320 | rep | NJ | 1909-03-15 | 1911-03-03 | Republican | 5 | |||||||||||||
15471 | 15471 | Joseph Gaines G000008 | rep | WV | 1909-03-15 | 1911-03-03 | Republican | 3 | |||||||||||||
15477 | 15477 | Washington Gardner G000062 | rep | MI | 1909-03-15 | 1911-03-03 | Republican | 3 | |||||||||||||
15478 | 15478 | Alfred Garner G000073 | rep | PA | 1909-03-15 | 1911-03-03 | Republican | 12 | |||||||||||||
15481 | 15481 | John Gill G000188 | rep | MD | 1909-03-15 | 1911-03-03 | Democrat | 4 | |||||||||||||
15485 | 15485 | Oscar Gillespie G000198 | rep | TX | 1909-03-15 | 1911-03-03 | Democrat | 12 | |||||||||||||
15486 | 15486 | Samuel Gilmore G000223 | rep | LA | 1909-03-15 | 1911-03-03 | Democrat | 2 | |||||||||||||
15490 | 15490 | Herman Goebel G000251 | rep | OH | 1909-03-15 | 1911-03-03 | Republican | 2 | |||||||||||||
15491 | 15491 | James Gordon G000312 | sen | MS | 1909-03-15 | 1911-03-03 | 2 | Democrat | |||||||||||||
15499 | 15499 | Joseph Graff G000351 | rep | IL | 1909-03-15 | 1911-03-03 | Republican | 16 | |||||||||||||
15505 | 15505 | William Graham G000363 | rep | PA | 1909-03-15 | 1911-03-03 | Republican | 29 | |||||||||||||
15506 | 15506 | John Grant G000383 | rep | NC | 1909-03-15 | 1911-03-03 | Republican | 10 | |||||||||||||
15513 | 15513 | James Griggs G000473 | rep | GA | 1909-03-15 | 1911-03-03 | Democrat | 2 | |||||||||||||
15514 | 15514 | Thomas Hamer H000098 | rep | ID | 1909-03-15 | 1911-03-03 | Republican | 1 | |||||||||||||
15515 | 15515 | James Havens H000358 | rep | NY | 1909-03-15 | 1911-03-03 | Democrat | 32 | |||||||||||||
15521 | 15521 | Edmund Hinshaw H000639 | rep | NE | 1909-03-15 | 1911-03-03 | Republican | 4 | |||||||||||||
15528 | 15528 | William Howard H000848 | rep | GA | 1909-03-15 | 1911-03-03 | Democrat | 8 | |||||||||||||
15536 | 15536 | Benjamin Howell H000857 | rep | NJ | 1909-03-15 | 1911-03-03 | Republican | 3 | |||||||||||||
15538 | 15538 | William Hubbard H000891 | rep | WV | 1909-03-15 | 1911-03-03 | Republican | 1 | |||||||||||||
15544 | 15544 | George Huff H000911 | rep | PA | 1909-03-15 | 1911-03-03 | Republican | 22 | |||||||||||||
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 | |||||||||||||
15557 | 15557 | Adna Johnson J000113 | rep | OH | 1909-03-15 | 1911-03-03 | Republican | 10 | |||||||||||||
15565 | 15565 | James Joyce J000276 | rep | OH | 1909-03-15 | 1911-03-03 | Republican | 15 | |||||||||||||
15572 | 15572 | Joseph Keifer K000048 | rep | OH | 1909-03-15 | 1911-03-03 | Republican | 7 | |||||||||||||
15576 | 15576 | John Keliher K000055 | rep | MA | 1909-03-15 | 1911-03-03 | Democrat | 9 | |||||||||||||
15580 | 15580 | James Kennedy K000106 | rep | OH | 1909-03-15 | 1911-03-03 | Republican | 18 | |||||||||||||
15585 | 15585 | Charles Knapp K000279 | rep | NY | 1909-03-15 | 1911-03-03 | Republican | 28 | |||||||||||||
15586 | 15586 | John Kronmiller K000331 | rep | MD | 1909-03-15 | 1911-03-03 | Republican | 3 | |||||||||||||
15588 | 15588 | Gustav Küstermann K000346 | rep | WI | 1909-03-15 | 1911-03-03 | Republican | 9 | |||||||||||||
15591 | 15591 | Tulio Larrinaga L000102 | rep | PR | 1909-03-15 | 1911-03-03 | Unionist | 0 | |||||||||||||
15595 | 15595 | Francis Lassiter L000106 | rep | VA | 1909-03-15 | 1911-03-03 | Democrat | 4 | |||||||||||||
15598 | 15598 | Charles Law L000124 | rep | NY | 1909-03-15 | 1911-03-03 | Republican | 4 | |||||||||||||
15599 | 15599 | Robert Lively L000361 | rep | TX | 1909-03-15 | 1911-03-03 | Democrat | 3 | |||||||||||||
15609 | 15609 | Leonidas Livingston L000368 | rep | GA | 1909-03-15 | 1911-03-03 | Democrat | 5 | |||||||||||||
15623 | 15623 | William Lovering L000465 | rep | MA | 1909-03-15 | 1911-03-03 | Republican | 14 | |||||||||||||
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 | |||||||||||||
15628 | 15628 | Zachary Massey M000230 | rep | TN | 1909-03-15 | 1911-03-03 | Republican | 1 | |||||||||||||
15633 | 15633 | Harry Maynard M000283 | rep | VA | 1909-03-15 | 1911-03-03 | Democrat | 2 | |||||||||||||
15634 | 15634 | William McCredie M000384 | rep | WA | 1909-03-15 | 1911-03-03 | Republican | 2 | |||||||||||||
15637 | 15637 | Samuel McEnery M000429 | sen | LA | 1909-03-15 | 1911-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);