legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
446 rows where "end" is on date 1909-03-03 sorted by party
This data as json, copyable, CSV (advanced)
Suggested facets: type, state, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15675 | 15675 | Pablo Ocampo O000020 | rep | PI | 1907-12-02 | 1909-03-03 | 0 | ||||||||||||||
16045 | 16045 | Benito Legarda Y Tuason L000218 | rep | PI | 1907-12-02 | 1909-03-03 | 0 | ||||||||||||||
14378 | 14378 | Asbury Latimer L000114 | sen | SC | 1903-11-09 | 1909-03-03 | 3 | Democrat | |||||||||||||
14412 | 14412 | James McCreary M000382 | sen | KY | 1903-11-09 | 1909-03-03 | 3 | Democrat | |||||||||||||
14497 | 14497 | Henry Teller T000116 | sen | CO | 1903-11-09 | 1909-03-03 | 3 | Democrat | |||||||||||||
14961 | 14961 | William Whyte W000435 | sen | MD | 1906-01-01 | 1909-03-03 | 3 | Democrat | |||||||||||||
14996 | 14996 | Joseph Brodhead B000860 | rep | PA | 1907-12-02 | 1909-03-03 | Democrat | 26 | |||||||||||||
15011 | 15011 | Stephen Brundidge B000979 | rep | AR | 1907-12-02 | 1909-03-03 | Democrat | 2 | |||||||||||||
15012 | 15012 | William Bryan B000994 | sen | FL | 1907-12-02 | 1909-03-03 | 3 | Democrat | |||||||||||||
15020 | 15020 | Ben Caldwell C000029 | rep | IL | 1907-12-02 | 1909-03-03 | Democrat | 21 | |||||||||||||
15041 | 15041 | Samuel Cooper C000761 | rep | TX | 1907-12-02 | 1909-03-03 | Democrat | 2 | |||||||||||||
15055 | 15055 | William Crawford C000896 | rep | NC | 1907-12-02 | 1909-03-03 | Democrat | 10 | |||||||||||||
15074 | 15074 | Robert Davey D000081 | rep | LA | 1907-12-02 | 1909-03-03 | Democrat | 2 | |||||||||||||
15113 | 15113 | Elmer Fulton F000421 | rep | OK | 1907-12-02 | 1909-03-03 | Democrat | 2 | |||||||||||||
15119 | 15119 | John Gaines G000007 | rep | TN | 1907-12-02 | 1909-03-03 | Democrat | 6 | |||||||||||||
15128 | 15128 | Daniel Granger G000375 | rep | RI | 1907-12-02 | 1909-03-03 | Democrat | 1 | |||||||||||||
15130 | 15130 | Richard Hackett H000004 | rep | NC | 1907-12-02 | 1909-03-03 | Democrat | 8 | |||||||||||||
15131 | 15131 | Thomas Hackney H000007 | rep | MO | 1907-12-02 | 1909-03-03 | Democrat | 15 | |||||||||||||
15136 | 15136 | Daniel Hamilton H000107 | rep | IA | 1907-12-02 | 1909-03-03 | Democrat | 6 | |||||||||||||
15155 | 15155 | Wilson Hill H000614 | rep | MS | 1907-12-02 | 1909-03-03 | Democrat | 4 | |||||||||||||
15171 | 15171 | William Kimball K000184 | rep | KY | 1907-12-02 | 1909-03-03 | Democrat | 7 | |||||||||||||
15177 | 15177 | William Kitchin K000252 | rep | NC | 1907-12-02 | 1909-03-03 | Democrat | 5 | |||||||||||||
15182 | 15182 | James Lamar L000028 | rep | MO | 1907-12-02 | 1909-03-03 | Democrat | 16 | |||||||||||||
15185 | 15185 | William Lamar L000031 | rep | FL | 1907-12-02 | 1909-03-03 | Democrat | 3 | |||||||||||||
15193 | 15193 | Eugene Leake L000175 | rep | NJ | 1907-12-02 | 1909-03-03 | Democrat | 9 | |||||||||||||
15194 | 15194 | John Lenahan L000239 | rep | PA | 1907-12-02 | 1909-03-03 | Democrat | 11 | |||||||||||||
15200 | 15200 | Elijah Lewis L000281 | rep | GA | 1907-12-02 | 1909-03-03 | Democrat | 3 | |||||||||||||
15220 | 15220 | Frank McLain M000533 | rep | MS | 1907-12-02 | 1909-03-03 | Democrat | 7 | |||||||||||||
15233 | 15233 | Adolph Meyer M000679 | rep | LA | 1907-12-02 | 1909-03-03 | Democrat | 1 | |||||||||||||
15236 | 15236 | James Murphy M001095 | rep | WI | 1907-12-02 | 1909-03-03 | Democrat | 3 | |||||||||||||
15257 | 15257 | Le Pratt P000504 | rep | NJ | 1907-12-02 | 1909-03-03 | Democrat | 8 | |||||||||||||
15270 | 15270 | John Rixey R000287 | rep | VA | 1907-12-02 | 1909-03-03 | Democrat | -1 | |||||||||||||
15275 | 15275 | William Ryan R000563 | rep | NY | 1907-12-02 | 1909-03-03 | Democrat | 35 | |||||||||||||
15299 | 15299 | Madison Smith S000588 | rep | MO | 1907-12-02 | 1909-03-03 | Democrat | 13 | |||||||||||||
15310 | 15310 | Ariosto Wiley W000466 | rep | AL | 1907-12-02 | 1909-03-03 | Democrat | 2 | |||||||||||||
15311 | 15311 | Oliver Wiley W000469 | rep | AL | 1907-12-02 | 1909-03-03 | Democrat | 2 | |||||||||||||
15312 | 15312 | Harry Wolf W000674 | rep | MD | 1907-12-02 | 1909-03-03 | Democrat | 3 | |||||||||||||
15313 | 15313 | Frank Gary G000090 | sen | SC | 1908-01-01 | 1909-03-03 | 3 | Democrat | |||||||||||||
15314 | 15314 | William Milton M000788 | sen | FL | 1908-01-01 | 1909-03-03 | 3 | Democrat | |||||||||||||
15339 | 15339 | George Bartlett B000203 | rep | NV | 1907-12-02 | 1909-03-03 | Democrat | 0 | |||||||||||||
15353 | 15353 | Eaton Bowers B000689 | rep | MS | 1907-12-02 | 1909-03-03 | Democrat | 6 | |||||||||||||
15366 | 15366 | Adam Byrd B001207 | rep | MS | 1907-12-02 | 1909-03-03 | Democrat | 5 | |||||||||||||
15387 | 15387 | Alexander Clay C000478 | sen | GA | 1903-11-09 | 1909-03-03 | 3 | Democrat | |||||||||||||
15405 | 15405 | William Craig C000861 | rep | AL | 1907-12-02 | 1909-03-03 | Democrat | 4 | |||||||||||||
15427 | 15427 | David De Armond D000167 | rep | MO | 1907-12-02 | 1909-03-03 | Democrat | 6 | |||||||||||||
15480 | 15480 | John Gill G000188 | rep | MD | 1907-12-02 | 1909-03-03 | Democrat | 4 | |||||||||||||
15484 | 15484 | Oscar Gillespie G000198 | rep | TX | 1907-12-02 | 1909-03-03 | Democrat | 12 | |||||||||||||
15512 | 15512 | James Griggs G000473 | rep | GA | 1907-12-02 | 1909-03-03 | Democrat | 2 | |||||||||||||
15527 | 15527 | William Howard H000848 | rep | GA | 1907-12-02 | 1909-03-03 | Democrat | 8 | |||||||||||||
15563 | 15563 | Joseph Johnston J000193 | sen | AL | 1907-12-02 | 1909-03-03 | 3 | Democrat | |||||||||||||
15575 | 15575 | John Keliher K000055 | rep | MA | 1907-12-02 | 1909-03-03 | Democrat | 9 | |||||||||||||
15594 | 15594 | Francis Lassiter L000106 | rep | VA | 1907-12-02 | 1909-03-03 | Democrat | 4 | |||||||||||||
15608 | 15608 | Leonidas Livingston L000368 | rep | GA | 1907-12-02 | 1909-03-03 | Democrat | 5 | |||||||||||||
15632 | 15632 | Harry Maynard M000283 | rep | VA | 1907-12-02 | 1909-03-03 | Democrat | 2 | |||||||||||||
15636 | 15636 | Samuel McEnery M000429 | sen | LA | 1903-11-09 | 1909-03-03 | 3 | Democrat | |||||||||||||
15671 | 15671 | Thomas Nicholls N000089 | rep | PA | 1907-12-02 | 1909-03-03 | Democrat | 10 | |||||||||||||
15673 | 15673 | Joseph O’Connell O000026 | rep | MA | 1907-12-02 | 1909-03-03 | Democrat | 10 | |||||||||||||
15688 | 15688 | James Patterson P000118 | rep | SC | 1907-12-02 | 1909-03-03 | Democrat | 2 | |||||||||||||
15715 | 15715 | Charles Reid R000142 | rep | AR | 1907-12-02 | 1909-03-03 | Democrat | 5 | |||||||||||||
15721 | 15721 | Joseph Rhinock R000185 | rep | KY | 1907-12-02 | 1909-03-03 | Democrat | 6 | |||||||||||||
15727 | 15727 | Gordon Russell R000526 | rep | TX | 1907-12-02 | 1909-03-03 | Democrat | 3 | |||||||||||||
15759 | 15759 | Thomas Spight S000734 | rep | MS | 1907-12-02 | 1909-03-03 | Democrat | 2 | |||||||||||||
15784 | 15784 | Charles Thomas T000159 | rep | NC | 1907-12-02 | 1909-03-03 | Democrat | 3 | |||||||||||||
15796 | 15796 | William Tou Velle T000318 | rep | OH | 1907-12-02 | 1909-03-03 | Democrat | 4 | |||||||||||||
15800 | 15800 | Robert Wallace W000082 | rep | AR | 1907-12-02 | 1909-03-03 | Democrat | 7 | |||||||||||||
15816 | 15816 | Charles Weisse W000259 | rep | WI | 1907-12-02 | 1909-03-03 | Democrat | 6 | |||||||||||||
15823 | 15823 | William Willett W000481 | rep | NY | 1907-12-02 | 1909-03-03 | Democrat | 14 | |||||||||||||
15884 | 15884 | William Brantley B000770 | rep | GA | 1907-12-02 | 1909-03-03 | Democrat | 11 | |||||||||||||
15932 | 15932 | Matthew Denver D000262 | rep | OH | 1907-12-02 | 1909-03-03 | Democrat | 6 | |||||||||||||
15959 | 15959 | James Ellerbe E000113 | rep | SC | 1907-12-02 | 1909-03-03 | Democrat | 6 | |||||||||||||
15963 | 15963 | Charles Fornes F000277 | rep | NY | 1907-12-02 | 1909-03-03 | Democrat | 11 | |||||||||||||
15985 | 15985 | George Gordon G000310 | rep | TN | 1907-12-02 | 1909-03-03 | Democrat | 10 | |||||||||||||
16022 | 16022 | George Kipp K000232 | rep | PA | 1907-12-02 | 1909-03-03 | Democrat | 14 | |||||||||||||
16031 | 16031 | John Lamb L000033 | rep | VA | 1907-12-02 | 1909-03-03 | Democrat | 3 | |||||||||||||
16051 | 16051 | George Lindsay L000324 | rep | NY | 1907-12-02 | 1909-03-03 | Democrat | 2 | |||||||||||||
16068 | 16068 | Robert Macon M000035 | rep | AR | 1907-12-02 | 1909-03-03 | Democrat | 1 | |||||||||||||
16096 | 16096 | John McHenry M000470 | rep | PA | 1907-12-02 | 1909-03-03 | Democrat | 16 | |||||||||||||
16115 | 16115 | John Moore M000904 | rep | TX | 1907-12-02 | 1909-03-03 | Democrat | 8 | |||||||||||||
16161 | 16161 | Arsène Pujo P000567 | rep | LA | 1907-12-02 | 1909-03-03 | Democrat | 7 | |||||||||||||
16167 | 16167 | Choice Randell R000042 | rep | TX | 1907-12-02 | 1909-03-03 | Democrat | 4 | |||||||||||||
16201 | 16201 | William Sulzer S001065 | rep | NY | 1907-12-02 | 1909-03-03 | Democrat | 10 | |||||||||||||
16231 | 16231 | William Wilson W000620 | rep | PA | 1907-12-02 | 1909-03-03 | Democrat | 15 | |||||||||||||
16251 | 16251 | Timothy Ansberry A000259 | rep | OH | 1907-12-02 | 1909-03-03 | Democrat | 5 | |||||||||||||
16279 | 16279 | Charles Bartlett B000199 | rep | GA | 1907-12-02 | 1909-03-03 | Democrat | 6 | |||||||||||||
16286 | 16286 | James Beall B000270 | rep | TX | 1907-12-02 | 1909-03-03 | Democrat | 5 | |||||||||||||
16321 | 16321 | Albert Burleson B001110 | rep | TX | 1907-12-02 | 1909-03-03 | Democrat | 10 | |||||||||||||
16333 | 16333 | Henry Clayton C000495 | rep | AL | 1907-12-02 | 1909-03-03 | Democrat | 3 | |||||||||||||
16359 | 16359 | John Floyd F000222 | rep | AR | 1907-12-02 | 1909-03-03 | Democrat | 3 | |||||||||||||
16387 | 16387 | Winfield Hammond H000135 | rep | MN | 1907-12-02 | 1909-03-03 | Democrat | 2 | |||||||||||||
16393 | 16393 | Francis Harrison H000268 | rep | NY | 1907-12-02 | 1909-03-03 | Democrat | 16 | |||||||||||||
16399 | 16399 | Richmond Hobson H000667 | rep | AL | 1907-12-02 | 1909-03-03 | Democrat | 6 | |||||||||||||
16406 | 16406 | William Hughes H000929 | rep | NJ | 1907-12-02 | 1909-03-03 | Democrat | 6 | |||||||||||||
16412 | 16412 | Ollie James J000051 | rep | KY | 1907-12-02 | 1909-03-03 | Democrat | 1 | |||||||||||||
16447 | 16447 | George Legaré L000219 | rep | SC | 1907-12-02 | 1909-03-03 | Democrat | 1 | |||||||||||||
16526 | 16526 | Andrew Peters P000251 | rep | MA | 1907-12-02 | 1909-03-03 | Democrat | 11 | |||||||||||||
16545 | 16545 | William Richardson R000227 | rep | AL | 1907-12-02 | 1909-03-03 | Democrat | 8 | |||||||||||||
16552 | 16552 | John Rothermel R000461 | rep | PA | 1907-12-02 | 1909-03-03 | Democrat | 13 | |||||||||||||
16608 | 16608 | George Taylor T000078 | rep | AL | 1907-12-02 | 1909-03-03 | Democrat | 1 | |||||||||||||
16655 | 16655 | Thomas Hardwick H000193 | rep | GA | 1907-12-02 | 1909-03-03 | Democrat | 10 | |||||||||||||
16664 | 16664 | John Adair A000027 | rep | IN | 1907-12-02 | 1909-03-03 | Democrat | 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);