legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
406 rows where "start" is on date 1897-03-15 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: state, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
22275 | 22275 | James Lewis L000284 | rep | WA | 1897-03-15 | 1899-03-03 | Democrat | -1 | |||||||||||||
21840 | 21840 | William King K000216 | rep | UT | 1897-03-15 | 1899-03-03 | Democrat | 1 | |||||||||||||
20233 | 20233 | Henry Cooper C000752 | rep | WI | 1897-03-15 | 1899-03-03 | Republican | 1 | |||||||||||||
20009 | 20009 | Claude Swanson S001094 | rep | VA | 1897-03-15 | 1899-03-03 | Democrat | 5 | |||||||||||||
19557 | 19557 | Theodore Burton B001159 | rep | OH | 1897-03-15 | 1899-03-03 | Republican | 21 | |||||||||||||
19271 | 19271 | Charles Curtis C001008 | rep | KS | 1897-03-15 | 1899-03-03 | Republican | 4 | |||||||||||||
19240 | 19240 | Thomas Butler B001192 | rep | PA | 1897-03-15 | 1899-03-03 | Ind. Republican | 6 | |||||||||||||
18961 | 18961 | Frederick Gillett G000201 | rep | MA | 1897-03-15 | 1899-03-03 | Republican | 2 | |||||||||||||
18660 | 18660 | William Greene G000430 | rep | MA | 1897-03-15 | 1899-03-03 | Republican | 13 | |||||||||||||
18525 | 18525 | Oscar Underwood U000013 | rep | AL | 1897-03-15 | 1899-03-03 | Democrat | 9 | |||||||||||||
18402 | 18402 | Richard Parker P000070 | rep | NJ | 1897-03-15 | 1899-03-03 | Republican | 6 | |||||||||||||
18337 | 18337 | William Mason M000228 | sen | IL | 1897-03-15 | 1903-03-03 | 3 | Republican | |||||||||||||
18322 | 18322 | James Mann M000104 | rep | IL | 1897-03-15 | 1899-03-03 | Republican | 1 | |||||||||||||
18104 | 18104 | Joseph Cannon C000121 | rep | IL | 1897-03-15 | 1899-03-03 | Republican | 12 | |||||||||||||
17933 | 17933 | Thetus Sims S000441 | rep | TN | 1897-03-15 | 1899-03-03 | Democrat | 8 | |||||||||||||
17900 | 17900 | Edward Robbins R000298 | rep | PA | 1897-03-15 | 1899-03-03 | Republican | 21 | |||||||||||||
17834 | 17834 | John Moon M000884 | rep | TN | 1897-03-15 | 1899-03-03 | Democrat | 3 | |||||||||||||
17750 | 17750 | Edward Hamilton H000108 | rep | MI | 1897-03-15 | 1899-03-03 | Republican | 4 | |||||||||||||
17699 | 17699 | John Fitzgerald F000164 | rep | MA | 1897-03-15 | 1899-03-03 | Democrat | 9 | |||||||||||||
17612 | 17612 | James Clark C000437 | rep | MO | 1897-03-15 | 1899-03-03 | Democrat | 9 | |||||||||||||
17551 | 17551 | John Bankhead B000110 | rep | AL | 1897-03-15 | 1899-03-03 | Democrat | 6 | |||||||||||||
17506 | 17506 | John Williams W000521 | rep | MS | 1897-03-15 | 1899-03-03 | Democrat | 5 | |||||||||||||
17458 | 17458 | Cyrus Sulloway S001063 | rep | NH | 1897-03-15 | 1899-03-03 | Republican | 1 | |||||||||||||
17427 | 17427 | James Slayden S000482 | rep | TX | 1897-03-15 | 1899-03-03 | Democrat | 12 | |||||||||||||
17312 | 17312 | William Jones J000259 | rep | VA | 1897-03-15 | 1899-03-03 | Democrat | 1 | |||||||||||||
17274 | 17274 | Ebenezer Hill H000591 | rep | CT | 1897-03-15 | 1899-03-03 | Republican | 4 | |||||||||||||
17196 | 17196 | George Foss F000295 | rep | IL | 1897-03-15 | 1899-03-03 | Republican | 7 | |||||||||||||
17132 | 17132 | James Davidson D000084 | rep | WI | 1897-03-15 | 1899-03-03 | Republican | 6 | |||||||||||||
17044 | 17044 | William Adamson A000051 | rep | GA | 1897-03-15 | 1899-03-03 | Democrat | 4 | |||||||||||||
16999 | 16999 | John Stephens S000858 | rep | TX | 1897-03-15 | 1899-03-03 | Democrat | 13 | |||||||||||||
16988 | 16988 | Stephen Sparkman S000702 | rep | FL | 1897-03-15 | 1899-03-03 | Democrat | 1 | |||||||||||||
16974 | 16974 | Marcus Smith S000589 | rep | AZ | 1897-03-15 | 1899-03-03 | Democrat | 0 | |||||||||||||
16926 | 16926 | Boies Penrose P000217 | sen | PA | 1897-03-15 | 1903-03-03 | 3 | Republican | |||||||||||||
16906 | 16906 | Francis Newlands N000069 | rep | NV | 1897-03-15 | 1899-03-03 | Democrat | 0 | |||||||||||||
16855 | 16855 | James Lloyd L000380 | rep | MO | 1897-03-15 | 1899-03-03 | Democrat | 1 | |||||||||||||
16791 | 16791 | Robert Henry H000516 | rep | TX | 1897-03-15 | 1899-03-03 | Democrat | 7 | |||||||||||||
16781 | 16781 | James Hay H000382 | rep | VA | 1897-03-15 | 1899-03-03 | Democrat | 7 | |||||||||||||
16759 | 16759 | Jacob Gallinger G000023 | sen | NH | 1897-03-15 | 1903-03-03 | 3 | Republican | |||||||||||||
16696 | 16696 | Robert Broussard B000896 | rep | LA | 1897-03-15 | 1899-03-03 | Democrat | 3 | |||||||||||||
16603 | 16603 | George Taylor T000078 | rep | AL | 1897-03-15 | 1899-03-03 | Democrat | 1 | |||||||||||||
16586 | 16586 | Frederick Stevens S000878 | rep | MN | 1897-03-15 | 1899-03-03 | Republican | 4 | |||||||||||||
16579 | 16579 | William Smith S000629 | rep | MI | 1897-03-15 | 1899-03-03 | Republican | 5 | |||||||||||||
16569 | 16569 | Samuel Smith S000613 | rep | MI | 1897-03-15 | 1899-03-03 | Republican | 6 | |||||||||||||
16560 | 16560 | John Shafroth S000279 | rep | CO | 1897-03-15 | 1899-03-03 | Silver Republican | 1 | |||||||||||||
16515 | 16515 | Sereno Payne P000153 | rep | NY | 1897-03-15 | 1899-03-03 | Republican | 28 | |||||||||||||
16354 | 16354 | Harvey Fergusson F000083 | rep | NM | 1897-03-15 | 1899-03-03 | Democrat | -1 | |||||||||||||
16328 | 16328 | Henry Clayton C000495 | rep | AL | 1897-03-15 | 1899-03-03 | Democrat | 3 | |||||||||||||
16309 | 16309 | Edwin Burleigh B001105 | rep | ME | 1897-03-15 | 1899-03-03 | Republican | 3 | |||||||||||||
16274 | 16274 | Charles Bartlett B000199 | rep | GA | 1897-03-15 | 1899-03-03 | Democrat | 6 | |||||||||||||
16264 | 16264 | Richard Bartholdt B000196 | rep | MO | 1897-03-15 | 1899-03-03 | Republican | 10 | |||||||||||||
16196 | 16196 | William Sulzer S001065 | rep | NY | 1897-03-15 | 1899-03-03 | Democrat | 11 | |||||||||||||
16151 | 16151 | George Prince P000538 | rep | IL | 1897-03-15 | 1899-03-03 | Republican | 10 | |||||||||||||
16136 | 16136 | Marlin Olmsted O000079 | rep | PA | 1897-03-15 | 1899-03-03 | Republican | 14 | |||||||||||||
16083 | 16083 | Samuel McCall M000305 | rep | MA | 1897-03-15 | 1899-03-03 | Republican | 8 | |||||||||||||
16058 | 16058 | Henry Loudenslager L000450 | rep | NJ | 1897-03-15 | 1899-03-03 | Republican | 1 | |||||||||||||
16036 | 16036 | George Lawrence L000133 | rep | MA | 1897-03-15 | 1899-03-03 | Republican | 1 | |||||||||||||
16026 | 16026 | John Lamb L000033 | rep | VA | 1897-03-15 | 1899-03-03 | Democrat | 3 | |||||||||||||
15998 | 15998 | Edward Henry H000505 | rep | CT | 1897-03-15 | 1899-03-03 | Republican | 1 | |||||||||||||
15974 | 15974 | John Gardner G000057 | rep | NJ | 1897-03-15 | 1899-03-03 | Republican | 2 | |||||||||||||
15922 | 15922 | John Dalzell D000016 | rep | PA | 1897-03-15 | 1899-03-03 | Republican | 22 | |||||||||||||
15902 | 15902 | Edgar Crumpacker C000958 | rep | IN | 1897-03-15 | 1899-03-03 | Republican | 10 | |||||||||||||
15879 | 15879 | William Brantley B000770 | rep | GA | 1897-03-15 | 1899-03-03 | Democrat | 11 | |||||||||||||
15863 | 15863 | Henry Bingham B000469 | rep | PA | 1897-03-15 | 1899-03-03 | Republican | 1 | |||||||||||||
15804 | 15804 | Irving Wanger W000122 | rep | PA | 1897-03-15 | 1899-03-03 | Republican | 7 | |||||||||||||
15772 | 15772 | James Tawney T000060 | rep | MN | 1897-03-15 | 1899-03-03 | Republican | 1 | |||||||||||||
15754 | 15754 | Thomas Spight S000734 | rep | MS | 1897-03-15 | 1899-03-03 | Democrat | 2 | |||||||||||||
15747 | 15747 | Nehemiah Sperry S000733 | rep | CT | 1897-03-15 | 1899-03-03 | Republican | 2 | |||||||||||||
15740 | 15740 | George Southwick S000691 | rep | NY | 1897-03-15 | 1899-03-03 | Republican | 20 | |||||||||||||
15697 | 15697 | George Perkins P000232 | sen | CA | 1897-03-15 | 1903-03-03 | 3 | Republican | |||||||||||||
15662 | 15662 | Sydney Mudd M001059 | rep | MD | 1897-03-15 | 1899-03-03 | Republican | 5 | |||||||||||||
15635 | 15635 | Samuel McEnery M000429 | sen | LA | 1897-03-15 | 1903-03-03 | 3 | Democrat | |||||||||||||
15617 | 15617 | William Lovering L000465 | rep | MA | 1897-03-15 | 1899-03-03 | Republican | 12 | |||||||||||||
15611 | 15611 | William Lorimer L000444 | rep | IL | 1897-03-15 | 1899-03-03 | Republican | 2 | |||||||||||||
15603 | 15603 | Leonidas Livingston L000368 | rep | GA | 1897-03-15 | 1899-03-03 | Democrat | 5 | |||||||||||||
15561 | 15561 | Martin Johnson J000162 | rep | ND | 1897-03-15 | 1899-03-03 | Republican | 1 | |||||||||||||
15549 | 15549 | John Hull H000942 | rep | IA | 1897-03-15 | 1899-03-03 | Republican | 7 | |||||||||||||
15530 | 15530 | Benjamin Howell H000857 | rep | NJ | 1897-03-15 | 1899-03-03 | Republican | 3 | |||||||||||||
15522 | 15522 | William Howard H000848 | rep | GA | 1897-03-15 | 1899-03-03 | Democrat | 8 | |||||||||||||
15507 | 15507 | James Griggs G000473 | rep | GA | 1897-03-15 | 1899-03-03 | Democrat | 2 | |||||||||||||
15500 | 15500 | William Graham G000363 | rep | PA | 1897-03-15 | 1899-03-03 | Republican | 23 | |||||||||||||
15493 | 15493 | Joseph Graff G000351 | rep | IL | 1897-03-15 | 1899-03-03 | Republican | 14 | |||||||||||||
15460 | 15460 | Charles Fowler F000320 | rep | NJ | 1897-03-15 | 1899-03-03 | Republican | 8 | |||||||||||||
15443 | 15443 | William Ellis E000138 | rep | OR | 1897-03-15 | 1899-03-03 | Republican | 2 | |||||||||||||
15422 | 15422 | David De Armond D000167 | rep | MO | 1897-03-15 | 1899-03-03 | Democrat | 6 | |||||||||||||
15386 | 15386 | Alexander Clay C000478 | sen | GA | 1897-03-15 | 1903-03-03 | 3 | Democrat | |||||||||||||
15375 | 15375 | Adin Capron C000135 | rep | RI | 1897-03-15 | 1899-03-03 | Republican | 2 | |||||||||||||
15357 | 15357 | Walter Brownlow B000962 | rep | TN | 1897-03-15 | 1899-03-03 | Republican | 1 | |||||||||||||
15344 | 15344 | Henry Boutell B000672 | rep | IL | 1897-03-15 | 1899-03-03 | Republican | 6 | |||||||||||||
15323 | 15323 | De Alexander A000091 | rep | NY | 1897-03-15 | 1899-03-03 | Republican | 33 | |||||||||||||
15293 | 15293 | George Smith S000541 | rep | IL | 1897-03-15 | 1899-03-03 | Republican | 22 | |||||||||||||
15280 | 15280 | James Sherman S000345 | rep | NY | 1897-03-15 | 1899-03-03 | Republican | 25 | |||||||||||||
15265 | 15265 | John Rixey R000287 | rep | VA | 1897-03-15 | 1899-03-03 | Democrat | 8 | |||||||||||||
15238 | 15238 | Jesse Overstreet O000144 | rep | IN | 1897-03-15 | 1899-03-03 | Republican | 7 | |||||||||||||
15228 | 15228 | Adolph Meyer M000679 | rep | LA | 1897-03-15 | 1899-03-03 | Democrat | 1 | |||||||||||||
15215 | 15215 | Frank McLain M000533 | rep | MS | 1897-03-15 | 1899-03-03 | Democrat | 6 | |||||||||||||
15195 | 15195 | Elijah Lewis L000281 | rep | GA | 1897-03-15 | 1899-03-03 | Democrat | 3 | |||||||||||||
15186 | 15186 | Charles Landis L000050 | rep | IN | 1897-03-15 | 1899-03-03 | Republican | 9 | |||||||||||||
15172 | 15172 | William Kitchin K000252 | rep | NC | 1897-03-15 | 1899-03-03 | Democrat | 5 | |||||||||||||
15165 | 15165 | John Jenkins J000084 | rep | WI | 1897-03-15 | 1899-03-03 | Republican | 10 | |||||||||||||
15147 | 15147 | William Hepburn H000523 | rep | IA | 1897-03-15 | 1899-03-03 | Republican | 8 |
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);