legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
438 rows where "end" is on date 1905-03-03 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, party, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23513 | 23513 | Carter Glass G000232 | rep | VA | 1903-11-09 | 1905-03-03 | Democrat | 6 | |||||||||||||
22697 | 22697 | James McAndrews M000296 | rep | IL | 1903-11-09 | 1905-03-03 | Democrat | 5 | |||||||||||||
22404 | 22404 | Morris Sheppard S000337 | rep | TX | 1903-11-09 | 1905-03-03 | Democrat | 1 | |||||||||||||
22330 | 22330 | George Norris N000139 | rep | NE | 1903-11-09 | 1905-03-03 | Republican | 5 | |||||||||||||
21511 | 21511 | Henry Rainey R000014 | rep | IL | 1903-11-09 | 1905-03-03 | Democrat | 20 | |||||||||||||
21483 | 21483 | Edward Pou P000474 | rep | NC | 1903-11-09 | 1905-03-03 | Democrat | 4 | |||||||||||||
21281 | 21281 | John Garner G000074 | rep | TX | 1903-11-09 | 1905-03-03 | Democrat | 15 | |||||||||||||
20872 | 20872 | William Stafford S000777 | rep | WI | 1903-11-09 | 1905-03-03 | Republican | 5 | |||||||||||||
20807 | 20807 | Joseph Robinson R000347 | rep | AR | 1903-11-09 | 1905-03-03 | Democrat | 6 | |||||||||||||
20664 | 20664 | Nicholas Longworth L000433 | rep | OH | 1903-11-09 | 1905-03-03 | Republican | 1 | |||||||||||||
20482 | 20482 | Gilbert Haugen H000350 | rep | IA | 1903-11-09 | 1905-03-03 | Republican | 4 | |||||||||||||
20387 | 20387 | Burton French F000375 | rep | ID | 1903-11-09 | 1905-03-03 | Republican | 1 | |||||||||||||
20236 | 20236 | Henry Cooper C000752 | rep | WI | 1903-11-09 | 1905-03-03 | Republican | 1 | |||||||||||||
20012 | 20012 | Claude Swanson S001094 | rep | VA | 1903-11-09 | 1905-03-03 | Democrat | 5 | |||||||||||||
19785 | 19785 | James Hughes H000924 | rep | WV | 1903-11-09 | 1905-03-03 | Republican | 5 | |||||||||||||
19560 | 19560 | Theodore Burton B001159 | rep | OH | 1903-11-09 | 1905-03-03 | Republican | 21 | |||||||||||||
19533 | 19533 | James Watson W000203 | rep | IN | 1903-11-09 | 1905-03-03 | Republican | 6 | |||||||||||||
19364 | 19364 | Wesley Jones J000257 | rep | WA | 1903-11-09 | 1905-03-03 | Republican | -1 | |||||||||||||
19274 | 19274 | Charles Curtis C001008 | rep | KS | 1903-11-09 | 1905-03-03 | Republican | 1 | |||||||||||||
19243 | 19243 | Thomas Butler B001192 | rep | PA | 1903-11-09 | 1905-03-03 | Republican | 7 | |||||||||||||
19167 | 19167 | Harry Woodyard W000737 | rep | WV | 1903-11-09 | 1905-03-03 | Republican | 4 | |||||||||||||
19073 | 19073 | Joseph Ransdell R000059 | rep | LA | 1903-11-09 | 1905-03-03 | Democrat | 5 | |||||||||||||
18979 | 18979 | James Heflin H000446 | rep | AL | 1904-05-19 | 1905-03-03 | Democrat | 5 | |||||||||||||
18964 | 18964 | Frederick Gillett G000201 | rep | MA | 1903-11-09 | 1905-03-03 | Republican | 2 | |||||||||||||
18945 | 18945 | Charles Fuller F000407 | rep | IL | 1903-11-09 | 1905-03-03 | Republican | 12 | |||||||||||||
18739 | 18739 | Henry Lodge L000393 | sen | MA | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
18709 | 18709 | Claude Kitchin K000250 | rep | NC | 1903-11-09 | 1905-03-03 | Democrat | 2 | |||||||||||||
18681 | 18681 | Benjamin Humphreys H000960 | rep | MS | 1903-11-09 | 1905-03-03 | Democrat | 3 | |||||||||||||
18663 | 18663 | William Greene G000430 | rep | MA | 1903-11-09 | 1905-03-03 | Republican | 14 | |||||||||||||
18607 | 18607 | Charles Davis D000093 | rep | MN | 1903-11-09 | 1905-03-03 | Republican | 3 | |||||||||||||
18596 | 18596 | William Cockran C000575 | rep | NY | 1903-11-09 | 1905-03-03 | Democrat | 12 | |||||||||||||
18538 | 18538 | Andrew Volstead V000114 | rep | MN | 1903-11-09 | 1905-03-03 | Republican | 7 | |||||||||||||
18528 | 18528 | Oscar Underwood U000013 | rep | AL | 1903-11-09 | 1905-03-03 | Democrat | 9 | |||||||||||||
18494 | 18494 | Halvor Steenerson S000842 | rep | MN | 1903-11-09 | 1905-03-03 | Republican | 9 | |||||||||||||
18458 | 18458 | William Rucker R000494 | rep | MO | 1903-11-09 | 1905-03-03 | Democrat | 2 | |||||||||||||
18443 | 18443 | William Rodenberg R000371 | rep | IL | 1903-11-09 | 1905-03-03 | Republican | 22 | |||||||||||||
18405 | 18405 | Richard Parker P000070 | rep | NJ | 1903-11-09 | 1905-03-03 | Republican | 7 | |||||||||||||
18391 | 18391 | Lemuel Padgett P000012 | rep | TN | 1903-11-09 | 1905-03-03 | Democrat | 7 | |||||||||||||
18362 | 18362 | Franklin Mondell M000852 | rep | WY | 1903-11-09 | 1905-03-03 | Republican | 0 | |||||||||||||
18325 | 18325 | James Mann M000104 | rep | IL | 1903-11-09 | 1905-03-03 | Republican | 2 | |||||||||||||
18277 | 18277 | Moses Kinkaid K000221 | rep | NE | 1903-11-09 | 1905-03-03 | Republican | 6 | |||||||||||||
18257 | 18257 | Jonah Kalanianaole K000004 | rep | HI | 1903-11-09 | 1905-03-03 | Republican | -1 | |||||||||||||
18180 | 18180 | Joseph Fordney F000271 | rep | MI | 1903-11-09 | 1905-03-03 | Republican | 8 | |||||||||||||
18168 | 18168 | Henry Flood F000210 | rep | VA | 1903-11-09 | 1905-03-03 | Democrat | 10 | |||||||||||||
18107 | 18107 | Joseph Cannon C000121 | rep | IL | 1903-11-09 | 1905-03-03 | Republican | 18 | |||||||||||||
18083 | 18083 | Philip Campbell C000097 | rep | KS | 1903-11-09 | 1905-03-03 | Republican | 3 | |||||||||||||
18060 | 18060 | Frank Brandegee B000769 | rep | CT | 1903-11-09 | 1905-03-03 | Republican | 3 | |||||||||||||
18016 | 18016 | William Wilson W000624 | rep | IL | 1903-11-09 | 1905-03-03 | Republican | 3 | |||||||||||||
17996 | 17996 | Edwin Webb W000231 | rep | NC | 1903-11-09 | 1905-03-03 | Democrat | 9 | |||||||||||||
17958 | 17958 | Augustus Stanley S000796 | rep | KY | 1903-11-09 | 1905-03-03 | Democrat | 2 | |||||||||||||
17947 | 17947 | John Small S000500 | rep | NC | 1903-11-09 | 1905-03-03 | Democrat | 1 | |||||||||||||
17936 | 17936 | Thetus Sims S000441 | rep | TN | 1903-11-09 | 1905-03-03 | Democrat | 8 | |||||||||||||
17837 | 17837 | John Moon M000884 | rep | TN | 1903-11-09 | 1905-03-03 | Democrat | 3 | |||||||||||||
17809 | 17809 | Asbury Lever L000259 | rep | SC | 1903-11-09 | 1905-03-03 | Democrat | 7 | |||||||||||||
17753 | 17753 | Edward Hamilton H000108 | rep | MI | 1903-11-09 | 1905-03-03 | Republican | 4 | |||||||||||||
17728 | 17728 | Henry Goldfogle G000260 | rep | NY | 1903-11-09 | 1905-03-03 | Democrat | 9 | |||||||||||||
17666 | 17666 | John Esch E000212 | rep | WI | 1903-11-09 | 1905-03-03 | Republican | 7 | |||||||||||||
17615 | 17615 | James Clark C000437 | rep | MO | 1903-11-09 | 1905-03-03 | Democrat | 9 | |||||||||||||
17595 | 17595 | Ezekiel Candler C000110 | rep | MS | 1903-11-09 | 1905-03-03 | Democrat | 1 | |||||||||||||
17582 | 17582 | John Burnett B001121 | rep | AL | 1903-11-09 | 1905-03-03 | Democrat | 7 | |||||||||||||
17554 | 17554 | John Bankhead B000110 | rep | AL | 1903-11-09 | 1905-03-03 | Democrat | 6 | |||||||||||||
17544 | 17544 | Lewis Ball B000100 | sen | DE | 1903-11-09 | 1905-03-03 | 1 | Republican | |||||||||||||
17509 | 17509 | John Williams W000521 | rep | MS | 1903-11-09 | 1905-03-03 | Democrat | 8 | |||||||||||||
17490 | 17490 | Charles Townsend T000330 | rep | MI | 1903-11-09 | 1905-03-03 | Republican | 2 | |||||||||||||
17481 | 17481 | Joshua Talbott T000021 | rep | MD | 1903-11-09 | 1905-03-03 | Democrat | 2 | |||||||||||||
17461 | 17461 | Cyrus Sulloway S001063 | rep | NH | 1903-11-09 | 1905-03-03 | Republican | 1 | |||||||||||||
17450 | 17450 | John Sterling S000870 | rep | IL | 1903-11-09 | 1905-03-03 | Republican | 17 | |||||||||||||
17443 | 17443 | John Snook S000657 | rep | OH | 1903-11-09 | 1905-03-03 | Democrat | 5 | |||||||||||||
17430 | 17430 | James Slayden S000482 | rep | TX | 1903-11-09 | 1905-03-03 | Democrat | 14 | |||||||||||||
17417 | 17417 | Joseph Sherley S000343 | rep | KY | 1903-11-09 | 1905-03-03 | Democrat | 5 | |||||||||||||
17409 | 17409 | Dorsey Shackleford S000274 | rep | MO | 1903-11-09 | 1905-03-03 | Democrat | 8 | |||||||||||||
17347 | 17347 | Porter McCumber M000397 | sen | ND | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
17331 | 17331 | Philander Knox K000296 | sen | PA | 1904-06-10 | 1905-03-03 | 1 | Republican | |||||||||||||
17315 | 17315 | William Jones J000259 | rep | VA | 1903-11-09 | 1905-03-03 | Democrat | 1 | |||||||||||||
17286 | 17286 | Gilbert Hitchcock H000645 | rep | NE | 1903-11-09 | 1905-03-03 | Democrat | 2 | |||||||||||||
17277 | 17277 | Ebenezer Hill H000591 | rep | CT | 1903-11-09 | 1905-03-03 | Republican | 4 | |||||||||||||
17245 | 17245 | Courtney Hamlin H000119 | rep | MO | 1903-11-09 | 1905-03-03 | Democrat | 7 | |||||||||||||
17231 | 17231 | Alexander Gregg G000441 | rep | TX | 1903-11-09 | 1905-03-03 | Democrat | 7 | |||||||||||||
17216 | 17216 | Augustus Gardner G000050 | rep | MA | 1903-11-09 | 1905-03-03 | Republican | 6 | |||||||||||||
17199 | 17199 | George Foss F000295 | rep | IL | 1903-11-09 | 1905-03-03 | Republican | 10 | |||||||||||||
17185 | 17185 | John Fitzgerald F000165 | rep | NY | 1903-11-09 | 1905-03-03 | Democrat | 7 | |||||||||||||
17175 | 17175 | David Finley F000131 | rep | SC | 1903-11-09 | 1905-03-03 | Democrat | 5 | |||||||||||||
17135 | 17135 | James Davidson D000084 | rep | WI | 1903-11-09 | 1905-03-03 | Republican | 8 | |||||||||||||
17125 | 17125 | Charles Culberson C000963 | sen | TX | 1899-12-04 | 1905-03-03 | 1 | Democrat | |||||||||||||
17047 | 17047 | William Adamson A000051 | rep | GA | 1903-11-09 | 1905-03-03 | Democrat | 4 | |||||||||||||
17002 | 17002 | John Stephens S000858 | rep | TX | 1903-11-09 | 1905-03-03 | Democrat | 13 | |||||||||||||
16991 | 16991 | Stephen Sparkman S000702 | rep | FL | 1903-11-09 | 1905-03-03 | Democrat | 1 | |||||||||||||
16980 | 16980 | William Smith S000636 | rep | TX | 1903-11-09 | 1905-03-03 | Democrat | 16 | |||||||||||||
16945 | 16945 | Ernest Roberts R000311 | rep | MA | 1903-11-09 | 1905-03-03 | Republican | 7 | |||||||||||||
16916 | 16916 | Robert Page P000022 | rep | NC | 1903-11-09 | 1905-03-03 | Democrat | 7 | |||||||||||||
16867 | 16867 | George Loud L000449 | rep | MI | 1903-11-09 | 1905-03-03 | Republican | 10 | |||||||||||||
16858 | 16858 | James Lloyd L000380 | rep | MO | 1903-11-09 | 1905-03-03 | Democrat | 1 | |||||||||||||
16841 | 16841 | Daniel Lafean L000014 | rep | PA | 1903-11-09 | 1905-03-03 | Republican | 20 | |||||||||||||
16826 | 16826 | Joseph Johnson J000156 | rep | SC | 1903-11-09 | 1905-03-03 | Democrat | 4 | |||||||||||||
16816 | 16816 | William Humphrey H000958 | rep | WA | 1903-11-09 | 1905-03-03 | Republican | -1 | |||||||||||||
16805 | 16805 | Joseph Howell H000866 | rep | UT | 1903-11-09 | 1905-03-03 | Republican | 1 | |||||||||||||
16794 | 16794 | Robert Henry H000516 | rep | TX | 1903-11-09 | 1905-03-03 | Democrat | 11 | |||||||||||||
16784 | 16784 | James Hay H000382 | rep | VA | 1903-11-09 | 1905-03-03 | Democrat | 7 | |||||||||||||
16763 | 16763 | Joseph Goulden G000344 | rep | NY | 1903-11-09 | 1905-03-03 | Democrat | 18 | |||||||||||||
16713 | 16713 | George Burgess B001083 | rep | TX | 1903-11-09 | 1905-03-03 | Democrat | 9 |
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);