legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
441 rows where "start" is on date 1909-03-15
This data as json, copyable, CSV (advanced)
Suggested facets: type, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||
15355 | 15355 | William Bradley B000749 | sen | KY | 1909-03-15 | 1915-03-03 | 3 | Republican | |||||||||||||
15356 | 15356 | Joseph Bristow B000844 | sen | KS | 1909-03-15 | 1915-03-03 | 3 | Republican | |||||||||||||
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 | |||||||||||||
15407 | 15407 | Coe Crawford C000888 | sen | SD | 1909-03-15 | 1915-03-03 | 3 | Republican | |||||||||||||
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 | |||||||||||||
15517 | 15517 | Weldon Heyburn H000554 | sen | ID | 1909-03-15 | 1913-03-03 | 3 | Republican | |||||||||||||
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 | |||||||||||||
15545 | 15545 | Charles Hughes H000919 | sen | CO | 1909-03-15 | 1911-12-31 | 3 | Democrat | |||||||||||||
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 | |||||||||||||
15562 | 15562 | Martin Johnson J000162 | sen | ND | 1909-03-15 | 1909-12-31 | 3 | Republican | |||||||||||||
15564 | 15564 | Joseph Johnston J000193 | sen | AL | 1909-03-15 | 1913-12-31 | 3 | Democrat | |||||||||||||
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 | |||||||||||||
15616 | 15616 | William Lorimer L000444 | sen | IL | 1909-03-15 | 1913-03-03 | 3 | Republican | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
15652 | 15652 | James Miller M000733 | rep | KS | 1909-03-15 | 1911-03-03 | Republican | 4 | |||||||||||||
15653 | 15653 | Charles Millington M000772 | rep | NY | 1909-03-15 | 1911-03-03 | Republican | 27 | |||||||||||||
15654 | 15654 | John Morehead M000940 | rep | NC | 1909-03-15 | 1911-03-03 | Republican | 5 | |||||||||||||
15659 | 15659 | Charles Morgan M000944 | rep | MO | 1909-03-15 | 1911-03-03 | Republican | 15 | |||||||||||||
15660 | 15660 | William Moxley M001053 | rep | IL | 1909-03-15 | 1911-03-03 | Republican | 6 | |||||||||||||
15668 | 15668 | Sydney Mudd M001059 | rep | MD | 1909-03-15 | 1911-03-03 | Republican | 5 | |||||||||||||
15670 | 15670 | Arthur Murphy M001087 | rep | MO | 1909-03-15 | 1911-03-03 | Republican | 16 | |||||||||||||
15672 | 15672 | Thomas Nicholls N000089 | rep | PA | 1909-03-15 | 1911-03-03 | Democrat | 10 |
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);