legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
411 rows where "start" is on date 1899-12-04 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: type, class, district, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21841 | 21841 | William King K000216 | rep | UT | 1899-12-04 | 1901-03-03 | Democrat | 1 | |||||||||||||
20480 | 20480 | Gilbert Haugen H000350 | rep | IA | 1899-12-04 | 1901-03-03 | Republican | 4 | |||||||||||||
20234 | 20234 | Henry Cooper C000752 | rep | WI | 1899-12-04 | 1901-03-03 | Republican | 1 | |||||||||||||
20010 | 20010 | Claude Swanson S001094 | rep | VA | 1899-12-04 | 1901-03-03 | Democrat | 5 | |||||||||||||
19558 | 19558 | Theodore Burton B001159 | rep | OH | 1899-12-04 | 1901-03-03 | Republican | 21 | |||||||||||||
19531 | 19531 | James Watson W000203 | rep | IN | 1899-12-04 | 1901-03-03 | Republican | 6 | |||||||||||||
19362 | 19362 | Wesley Jones J000257 | rep | WA | 1899-12-04 | 1901-03-03 | Republican | -1 | |||||||||||||
19272 | 19272 | Charles Curtis C001008 | rep | KS | 1899-12-04 | 1901-03-03 | Republican | 1 | |||||||||||||
19241 | 19241 | Thomas Butler B001192 | rep | PA | 1899-12-04 | 1901-03-03 | Republican | 6 | |||||||||||||
19071 | 19071 | Joseph Ransdell R000059 | rep | LA | 1899-12-04 | 1901-03-03 | Democrat | 5 | |||||||||||||
18962 | 18962 | Frederick Gillett G000201 | rep | MA | 1899-12-04 | 1901-03-03 | Republican | 2 | |||||||||||||
18818 | 18818 | Daniel Riordan R000264 | rep | NY | 1899-12-04 | 1901-03-03 | Democrat | 8 | |||||||||||||
18739 | 18739 | Henry Lodge L000393 | sen | MA | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
18696 | 18696 | Julius Kahn K000003 | rep | CA | 1899-12-04 | 1901-03-03 | Republican | 4 | |||||||||||||
18661 | 18661 | William Greene G000430 | rep | MA | 1899-12-04 | 1901-03-03 | Republican | 13 | |||||||||||||
18526 | 18526 | Oscar Underwood U000013 | rep | AL | 1899-12-04 | 1901-03-03 | Democrat | 9 | |||||||||||||
18456 | 18456 | William Rucker R000494 | rep | MO | 1899-12-04 | 1901-03-03 | Democrat | 2 | |||||||||||||
18442 | 18442 | William Rodenberg R000371 | rep | IL | 1899-12-04 | 1901-03-03 | Republican | 21 | |||||||||||||
18403 | 18403 | Richard Parker P000070 | rep | NJ | 1899-12-04 | 1901-03-03 | Republican | 6 | |||||||||||||
18360 | 18360 | Franklin Mondell M000852 | rep | WY | 1899-12-04 | 1901-03-03 | Republican | 0 | |||||||||||||
18323 | 18323 | James Mann M000104 | rep | IL | 1899-12-04 | 1901-03-03 | Republican | 1 | |||||||||||||
18178 | 18178 | Joseph Fordney F000271 | rep | MI | 1899-12-04 | 1901-03-03 | Republican | 8 | |||||||||||||
18105 | 18105 | Joseph Cannon C000121 | rep | IL | 1899-12-04 | 1901-03-03 | Republican | 12 | |||||||||||||
17945 | 17945 | John Small S000500 | rep | NC | 1899-12-04 | 1901-03-03 | Democrat | 1 | |||||||||||||
17934 | 17934 | Thetus Sims S000441 | rep | TN | 1899-12-04 | 1901-03-03 | Democrat | 8 | |||||||||||||
17835 | 17835 | John Moon M000884 | rep | TN | 1899-12-04 | 1901-03-03 | Democrat | 3 | |||||||||||||
17751 | 17751 | Edward Hamilton H000108 | rep | MI | 1899-12-04 | 1901-03-03 | Republican | 4 | |||||||||||||
17700 | 17700 | John Fitzgerald F000164 | rep | MA | 1899-12-04 | 1901-03-03 | Democrat | 9 | |||||||||||||
17664 | 17664 | John Esch E000212 | rep | WI | 1899-12-04 | 1901-03-03 | Republican | 7 | |||||||||||||
17613 | 17613 | James Clark C000437 | rep | MO | 1899-12-04 | 1901-03-03 | Democrat | 9 | |||||||||||||
17580 | 17580 | John Burnett B001121 | rep | AL | 1899-12-04 | 1901-03-03 | Democrat | 7 | |||||||||||||
17552 | 17552 | John Bankhead B000110 | rep | AL | 1899-12-04 | 1901-03-03 | Democrat | 6 | |||||||||||||
17507 | 17507 | John Williams W000521 | rep | MS | 1899-12-04 | 1901-03-03 | Democrat | 5 | |||||||||||||
17459 | 17459 | Cyrus Sulloway S001063 | rep | NH | 1899-12-04 | 1901-03-03 | Republican | 1 | |||||||||||||
17428 | 17428 | James Slayden S000482 | rep | TX | 1899-12-04 | 1901-03-03 | Democrat | 12 | |||||||||||||
17407 | 17407 | Dorsey Shackleford S000274 | rep | MO | 1899-12-04 | 1901-03-03 | Democrat | 8 | |||||||||||||
17347 | 17347 | Porter McCumber M000397 | sen | ND | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
17313 | 17313 | William Jones J000259 | rep | VA | 1899-12-04 | 1901-03-03 | Democrat | 1 | |||||||||||||
17275 | 17275 | Ebenezer Hill H000591 | rep | CT | 1899-12-04 | 1901-03-03 | Republican | 4 | |||||||||||||
17197 | 17197 | George Foss F000295 | rep | IL | 1899-12-04 | 1901-03-03 | Republican | 7 | |||||||||||||
17183 | 17183 | John Fitzgerald F000165 | rep | NY | 1899-12-04 | 1901-03-03 | Democrat | 2 | |||||||||||||
17173 | 17173 | David Finley F000131 | rep | SC | 1899-12-04 | 1901-03-03 | Democrat | 5 | |||||||||||||
17133 | 17133 | James Davidson D000084 | rep | WI | 1899-12-04 | 1901-03-03 | Republican | 6 | |||||||||||||
17125 | 17125 | Charles Culberson C000963 | sen | TX | 1899-12-04 | 1905-03-03 | 1 | Democrat | |||||||||||||
17045 | 17045 | William Adamson A000051 | rep | GA | 1899-12-04 | 1901-03-03 | Democrat | 4 | |||||||||||||
17034 | 17034 | William Williams W000548 | rep | IL | 1899-12-04 | 1901-03-03 | Democrat | 16 | |||||||||||||
17000 | 17000 | John Stephens S000858 | rep | TX | 1899-12-04 | 1901-03-03 | Democrat | 13 | |||||||||||||
16989 | 16989 | Stephen Sparkman S000702 | rep | FL | 1899-12-04 | 1901-03-03 | Democrat | 1 | |||||||||||||
16966 | 16966 | John Smith S000577 | rep | MD | 1899-12-04 | 1900-01-12 | Democrat | 1 | |||||||||||||
16943 | 16943 | Ernest Roberts R000311 | rep | MA | 1899-12-04 | 1901-03-03 | Republican | 7 | |||||||||||||
16907 | 16907 | Francis Newlands N000069 | rep | NV | 1899-12-04 | 1901-03-03 | Democrat | 0 | |||||||||||||
16856 | 16856 | James Lloyd L000380 | rep | MO | 1899-12-04 | 1901-03-03 | Democrat | 1 | |||||||||||||
16792 | 16792 | Robert Henry H000516 | rep | TX | 1899-12-04 | 1901-03-03 | Democrat | 7 | |||||||||||||
16782 | 16782 | James Hay H000382 | rep | VA | 1899-12-04 | 1901-03-03 | Democrat | 7 | |||||||||||||
16697 | 16697 | Robert Broussard B000896 | rep | LA | 1899-12-04 | 1901-03-03 | Democrat | 3 | |||||||||||||
16641 | 16641 | Frank Wilson W000580 | rep | NY | 1899-12-04 | 1901-03-03 | Democrat | 5 | |||||||||||||
16604 | 16604 | George Taylor T000078 | rep | AL | 1899-12-04 | 1901-03-03 | Democrat | 1 | |||||||||||||
16587 | 16587 | Frederick Stevens S000878 | rep | MN | 1899-12-04 | 1901-03-03 | Republican | 4 | |||||||||||||
16580 | 16580 | William Smith S000629 | rep | MI | 1899-12-04 | 1901-03-03 | Republican | 5 | |||||||||||||
16570 | 16570 | Samuel Smith S000613 | rep | MI | 1899-12-04 | 1901-03-03 | Republican | 6 | |||||||||||||
16561 | 16561 | John Shafroth S000279 | rep | CO | 1899-12-04 | 1901-03-03 | Silver Republican | 1 | |||||||||||||
16541 | 16541 | William Richardson R000227 | rep | AL | 1899-12-04 | 1901-03-03 | Democrat | 8 | |||||||||||||
16516 | 16516 | Sereno Payne P000153 | rep | NY | 1899-12-04 | 1901-03-03 | Republican | 28 | |||||||||||||
16451 | 16451 | Jefferson Levy L000268 | rep | NY | 1899-12-04 | 1901-03-03 | Democrat | 13 | |||||||||||||
16329 | 16329 | Henry Clayton C000495 | rep | AL | 1899-12-04 | 1901-03-03 | Democrat | 3 | |||||||||||||
16317 | 16317 | Albert Burleson B001110 | rep | TX | 1899-12-04 | 1901-03-03 | Democrat | 9 | |||||||||||||
16310 | 16310 | Edwin Burleigh B001105 | rep | ME | 1899-12-04 | 1901-03-03 | Republican | 3 | |||||||||||||
16297 | 16297 | Charles Burke B001087 | rep | SD | 1899-12-04 | 1901-03-03 | Republican | -1 | |||||||||||||
16275 | 16275 | Charles Bartlett B000199 | rep | GA | 1899-12-04 | 1901-03-03 | Democrat | 6 | |||||||||||||
16265 | 16265 | Richard Bartholdt B000196 | rep | MO | 1899-12-04 | 1901-03-03 | Republican | 10 | |||||||||||||
16219 | 16219 | Edward Vreeland V000122 | rep | NY | 1899-12-04 | 1901-03-03 | Republican | 34 | |||||||||||||
16197 | 16197 | William Sulzer S001065 | rep | NY | 1899-12-04 | 1901-03-03 | Democrat | 11 | |||||||||||||
16186 | 16186 | Walter Smith S000623 | rep | IA | 1899-12-04 | 1901-03-03 | Republican | 9 | |||||||||||||
16152 | 16152 | George Prince P000538 | rep | IL | 1899-12-04 | 1901-03-03 | Republican | 10 | |||||||||||||
16137 | 16137 | Marlin Olmsted O000079 | rep | PA | 1899-12-04 | 1901-03-03 | Republican | 14 | |||||||||||||
16121 | 16121 | James Needham N000021 | rep | CA | 1899-12-04 | 1901-03-03 | Republican | 7 | |||||||||||||
16084 | 16084 | Samuel McCall M000305 | rep | MA | 1899-12-04 | 1901-03-03 | Republican | 8 | |||||||||||||
16059 | 16059 | Henry Loudenslager L000450 | rep | NJ | 1899-12-04 | 1901-03-03 | Republican | 1 | |||||||||||||
16037 | 16037 | George Lawrence L000133 | rep | MA | 1899-12-04 | 1901-03-03 | Republican | 1 | |||||||||||||
16027 | 16027 | John Lamb L000033 | rep | VA | 1899-12-04 | 1901-03-03 | Democrat | 3 | |||||||||||||
15999 | 15999 | Edward Henry H000505 | rep | CT | 1899-12-04 | 1901-03-03 | Republican | 1 | |||||||||||||
15975 | 15975 | John Gardner G000057 | rep | NJ | 1899-12-04 | 1901-03-03 | Republican | 2 | |||||||||||||
15945 | 15945 | Michael Driscoll D000502 | rep | NY | 1899-12-04 | 1901-03-03 | Republican | 27 | |||||||||||||
15923 | 15923 | John Dalzell D000016 | rep | PA | 1899-12-04 | 1901-03-03 | Republican | 22 | |||||||||||||
15903 | 15903 | Edgar Crumpacker C000958 | rep | IN | 1899-12-04 | 1901-03-03 | Republican | 10 | |||||||||||||
15896 | 15896 | Clarence Clark C000425 | sen | WY | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
15880 | 15880 | William Brantley B000770 | rep | GA | 1899-12-04 | 1901-03-03 | Democrat | 11 | |||||||||||||
15864 | 15864 | Henry Bingham B000469 | rep | PA | 1899-12-04 | 1901-03-03 | Republican | 1 | |||||||||||||
15805 | 15805 | Irving Wanger W000122 | rep | PA | 1899-12-04 | 1901-03-03 | Republican | 7 | |||||||||||||
15780 | 15780 | Charles Thomas T000159 | rep | NC | 1899-12-04 | 1901-03-03 | Democrat | 3 | |||||||||||||
15773 | 15773 | James Tawney T000060 | rep | MN | 1899-12-04 | 1901-03-03 | Republican | 1 | |||||||||||||
15755 | 15755 | Thomas Spight S000734 | rep | MS | 1899-12-04 | 1901-03-03 | Democrat | 2 | |||||||||||||
15748 | 15748 | Nehemiah Sperry S000733 | rep | CT | 1899-12-04 | 1901-03-03 | Republican | 2 | |||||||||||||
15706 | 15706 | William Reeder R000131 | rep | KS | 1899-12-04 | 1901-03-03 | Republican | 6 | |||||||||||||
15690 | 15690 | George Pearre P000163 | rep | MD | 1899-12-04 | 1901-03-03 | Republican | 6 | |||||||||||||
15663 | 15663 | Sydney Mudd M001059 | rep | MD | 1899-12-04 | 1901-03-03 | Republican | 5 | |||||||||||||
15647 | 15647 | James Miller M000733 | rep | KS | 1899-12-04 | 1901-03-03 | Republican | 4 | |||||||||||||
15618 | 15618 | William Lovering L000465 | rep | MA | 1899-12-04 | 1901-03-03 | Republican | 12 | |||||||||||||
15612 | 15612 | William Lorimer L000444 | rep | IL | 1899-12-04 | 1901-03-03 | Republican | 2 | |||||||||||||
15604 | 15604 | Leonidas Livingston L000368 | rep | GA | 1899-12-04 | 1901-03-03 | Democrat | 5 |
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);