legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
444 rows where "end" is on date 1911-03-03 sorted by party
This data as json, copyable, CSV (advanced)
Suggested facets: state, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15676 | 15676 | Pablo Ocampo O000020 | rep | PI | 1909-03-15 | 1911-03-03 | 0 | ||||||||||||||
16046 | 16046 | Benito Legarda Y Tuason L000218 | rep | PI | 1909-03-15 | 1911-03-03 | 0 | ||||||||||||||
16931 | 16931 | Manuel Quezon Q000009 | rep | PI | 1909-03-15 | 1911-03-03 | 0 | ||||||||||||||
14630 | 14630 | John Daniel D000035 | sen | VA | 1905-12-04 | 1911-03-03 | 1 | Democrat | |||||||||||||
14663 | 14663 | James Frazier F000352 | sen | TN | 1905-12-04 | 1911-03-03 | 1 | Democrat | |||||||||||||
14840 | 14840 | Hernando Money M000854 | sen | MS | 1905-12-04 | 1911-03-03 | 1 | Democrat | |||||||||||||
14917 | 14917 | James Taliaferro T000026 | sen | FL | 1905-12-04 | 1911-03-03 | 1 | Democrat | |||||||||||||
15340 | 15340 | George Bartlett B000203 | rep | NV | 1909-03-15 | 1911-03-03 | Democrat | 0 | |||||||||||||
15354 | 15354 | Eaton Bowers B000689 | rep | MS | 1909-03-15 | 1911-03-03 | Democrat | 6 | |||||||||||||
15367 | 15367 | Adam Byrd B001207 | rep | MS | 1909-03-15 | 1911-03-03 | Democrat | 5 | |||||||||||||
15388 | 15388 | Alexander Clay C000478 | sen | GA | 1909-03-15 | 1911-03-03 | 3 | Democrat | |||||||||||||
15406 | 15406 | William Craig C000861 | rep | AL | 1909-03-15 | 1911-03-03 | Democrat | 4 | |||||||||||||
15428 | 15428 | David De Armond D000167 | rep | MO | 1909-03-15 | 1911-03-03 | Democrat | 6 | |||||||||||||
15456 | 15456 | Eugene Foss F000293 | rep | MA | 1909-03-15 | 1911-03-03 | Democrat | 14 | |||||||||||||
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 | |||||||||||||
15491 | 15491 | James Gordon G000312 | sen | MS | 1909-03-15 | 1911-03-03 | 2 | Democrat | |||||||||||||
15513 | 15513 | James Griggs G000473 | rep | GA | 1909-03-15 | 1911-03-03 | Democrat | 2 | |||||||||||||
15515 | 15515 | James Havens H000358 | rep | NY | 1909-03-15 | 1911-03-03 | Democrat | 32 | |||||||||||||
15528 | 15528 | William Howard H000848 | rep | GA | 1909-03-15 | 1911-03-03 | Democrat | 8 | |||||||||||||
15556 | 15556 | William Jamieson J000055 | rep | IA | 1909-03-15 | 1911-03-03 | Democrat | 8 | |||||||||||||
15576 | 15576 | John Keliher K000055 | rep | MA | 1909-03-15 | 1911-03-03 | Democrat | 9 | |||||||||||||
15595 | 15595 | Francis Lassiter L000106 | rep | VA | 1909-03-15 | 1911-03-03 | Democrat | 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 | |||||||||||||
15633 | 15633 | Harry Maynard M000283 | rep | VA | 1909-03-15 | 1911-03-03 | Democrat | 2 | |||||||||||||
15637 | 15637 | Samuel McEnery M000429 | sen | LA | 1909-03-15 | 1911-03-03 | 3 | Democrat | |||||||||||||
15672 | 15672 | Thomas Nicholls N000089 | rep | PA | 1909-03-15 | 1911-03-03 | Democrat | 10 | |||||||||||||
15674 | 15674 | Joseph O’Connell O000026 | rep | MA | 1909-03-15 | 1911-03-03 | Democrat | 10 | |||||||||||||
15689 | 15689 | James Patterson P000118 | rep | SC | 1909-03-15 | 1911-03-03 | Democrat | 2 | |||||||||||||
15716 | 15716 | Charles Reid R000142 | rep | AR | 1909-03-15 | 1911-03-03 | Democrat | 5 | |||||||||||||
15722 | 15722 | Joseph Rhinock R000185 | rep | KY | 1909-03-15 | 1911-03-03 | Democrat | 6 | |||||||||||||
15728 | 15728 | Gordon Russell R000526 | rep | TX | 1909-03-15 | 1911-03-03 | Democrat | 3 | |||||||||||||
15760 | 15760 | Thomas Spight S000734 | rep | MS | 1909-03-15 | 1911-03-03 | Democrat | 2 | |||||||||||||
15785 | 15785 | Charles Thomas T000159 | rep | NC | 1909-03-15 | 1911-03-03 | Democrat | 3 | |||||||||||||
15790 | 15790 | Fountain Thompson T000199 | sen | ND | 1909-03-15 | 1911-03-03 | 3 | Democrat | |||||||||||||
15797 | 15797 | William Tou Velle T000318 | rep | OH | 1909-03-15 | 1911-03-03 | Democrat | 4 | |||||||||||||
15801 | 15801 | Robert Wallace W000082 | rep | AR | 1909-03-15 | 1911-03-03 | Democrat | 7 | |||||||||||||
15817 | 15817 | Charles Weisse W000259 | rep | WI | 1909-03-15 | 1911-03-03 | Democrat | 6 | |||||||||||||
15824 | 15824 | William Willett W000481 | rep | NY | 1909-03-15 | 1911-03-03 | Democrat | 14 | |||||||||||||
15837 | 15837 | Carl Anderson A000182 | rep | OH | 1909-03-15 | 1911-03-03 | Democrat | 13 | |||||||||||||
15871 | 15871 | John Boehne B000587 | rep | IN | 1909-03-15 | 1911-03-03 | Democrat | 1 | |||||||||||||
15885 | 15885 | William Brantley B000770 | rep | GA | 1909-03-15 | 1911-03-03 | Democrat | 11 | |||||||||||||
15900 | 15900 | James Cox C000835 | rep | OH | 1909-03-15 | 1911-03-03 | Democrat | 3 | |||||||||||||
15933 | 15933 | Matthew Denver D000262 | rep | OH | 1909-03-15 | 1911-03-03 | Democrat | 6 | |||||||||||||
15935 | 15935 | William Dickson D000334 | rep | MS | 1909-03-15 | 1911-03-03 | Democrat | 7 | |||||||||||||
15960 | 15960 | James Ellerbe E000113 | rep | SC | 1909-03-15 | 1911-03-03 | Democrat | 6 | |||||||||||||
15964 | 15964 | Charles Fornes F000277 | rep | NY | 1909-03-15 | 1911-03-03 | Democrat | 11 | |||||||||||||
15983 | 15983 | Patrick Gill G000191 | rep | MO | 1909-03-15 | 1911-03-03 | Democrat | 11 | |||||||||||||
15986 | 15986 | George Gordon G000310 | rep | TN | 1909-03-15 | 1911-03-03 | Democrat | 10 | |||||||||||||
16032 | 16032 | John Lamb L000033 | rep | VA | 1909-03-15 | 1911-03-03 | Democrat | 3 | |||||||||||||
16034 | 16034 | James Latta L000117 | rep | NE | 1909-03-15 | 1911-03-03 | Democrat | 3 | |||||||||||||
16052 | 16052 | George Lindsay L000324 | rep | NY | 1909-03-15 | 1911-03-03 | Democrat | 2 | |||||||||||||
16069 | 16069 | Robert Macon M000035 | rep | AR | 1909-03-15 | 1911-03-03 | Democrat | 1 | |||||||||||||
16079 | 16079 | Dannite Mays M000289 | rep | FL | 1909-03-15 | 1911-03-03 | Democrat | 3 | |||||||||||||
16097 | 16097 | John McHenry M000470 | rep | PA | 1909-03-15 | 1911-03-03 | Democrat | 16 | |||||||||||||
16116 | 16116 | John Moore M000904 | rep | TX | 1909-03-15 | 1911-03-03 | Democrat | 8 | |||||||||||||
16162 | 16162 | Arsène Pujo P000567 | rep | LA | 1909-03-15 | 1911-03-03 | Democrat | 7 | |||||||||||||
16168 | 16168 | Choice Randell R000042 | rep | TX | 1909-03-15 | 1911-03-03 | Democrat | 4 | |||||||||||||
16173 | 16173 | Isidor Rayner R000086 | sen | MD | 1905-12-04 | 1911-03-03 | 1 | Democrat | |||||||||||||
16178 | 16178 | Atterson Rucker R000492 | rep | CO | 1909-03-15 | 1911-03-03 | Democrat | 1 | |||||||||||||
16202 | 16202 | William Sulzer S001065 | rep | NY | 1909-03-15 | 1911-03-03 | Democrat | 10 | |||||||||||||
16216 | 16216 | Robert Turnbull T000413 | rep | VA | 1909-03-15 | 1911-03-03 | Democrat | 4 | |||||||||||||
16229 | 16229 | Robert Wickliffe W000443 | rep | LA | 1909-03-15 | 1911-03-03 | Democrat | 6 | |||||||||||||
16232 | 16232 | William Wilson W000620 | rep | PA | 1909-03-15 | 1911-03-03 | Democrat | 15 | |||||||||||||
16252 | 16252 | Timothy Ansberry A000259 | rep | OH | 1909-03-15 | 1911-03-03 | Democrat | 5 | |||||||||||||
16280 | 16280 | Charles Bartlett B000199 | rep | GA | 1909-03-15 | 1911-03-03 | Democrat | 6 | |||||||||||||
16287 | 16287 | James Beall B000270 | rep | TX | 1909-03-15 | 1911-03-03 | Democrat | 5 | |||||||||||||
16322 | 16322 | Albert Burleson B001110 | rep | TX | 1909-03-15 | 1911-03-03 | Democrat | 10 | |||||||||||||
16334 | 16334 | Henry Clayton C000495 | rep | AL | 1909-03-15 | 1911-03-03 | Democrat | 3 | |||||||||||||
16338 | 16338 | James Covington C000816 | rep | MD | 1909-03-15 | 1911-03-03 | Democrat | 1 | |||||||||||||
16360 | 16360 | John Floyd F000222 | rep | AR | 1909-03-15 | 1911-03-03 | Democrat | 3 | |||||||||||||
16380 | 16380 | James Graham G000357 | rep | IL | 1909-03-15 | 1911-03-03 | Democrat | 21 | |||||||||||||
16388 | 16388 | Winfield Hammond H000135 | rep | MN | 1909-03-15 | 1911-03-03 | Democrat | 2 | |||||||||||||
16394 | 16394 | Francis Harrison H000268 | rep | NY | 1909-03-15 | 1911-03-03 | Democrat | 16 | |||||||||||||
16400 | 16400 | Richmond Hobson H000667 | rep | AL | 1909-03-15 | 1911-03-03 | Democrat | 6 | |||||||||||||
16407 | 16407 | William Hughes H000929 | rep | NJ | 1909-03-15 | 1911-03-03 | Democrat | 6 | |||||||||||||
16413 | 16413 | Ollie James J000051 | rep | KY | 1909-03-15 | 1911-03-03 | Democrat | 1 | |||||||||||||
16421 | 16421 | Eugene Kinkead K000222 | rep | NJ | 1909-03-15 | 1911-03-03 | Democrat | 9 | |||||||||||||
16433 | 16433 | Charles Korbly K000316 | rep | IN | 1909-03-15 | 1911-03-03 | Democrat | 7 | |||||||||||||
16448 | 16448 | George Legaré L000219 | rep | SC | 1909-03-15 | 1911-03-03 | Democrat | 1 | |||||||||||||
16458 | 16458 | John Maguire M000060 | rep | NE | 1909-03-15 | 1911-03-03 | Democrat | 1 | |||||||||||||
16488 | 16488 | John Mitchell M000820 | rep | MA | 1909-03-15 | 1911-03-03 | Democrat | 4 | |||||||||||||
16504 | 16504 | Alexander Palmer P000035 | rep | PA | 1909-03-15 | 1911-03-03 | Democrat | 26 | |||||||||||||
16527 | 16527 | Andrew Peters P000251 | rep | MA | 1909-03-15 | 1911-03-03 | Democrat | 11 | |||||||||||||
16546 | 16546 | William Richardson R000227 | rep | AL | 1909-03-15 | 1911-03-03 | Democrat | 8 | |||||||||||||
16549 | 16549 | Seaborn Roddenbery R000370 | rep | GA | 1909-03-15 | 1911-03-03 | Democrat | 2 | |||||||||||||
16553 | 16553 | John Rothermel R000461 | rep | PA | 1909-03-15 | 1911-03-03 | Democrat | 13 | |||||||||||||
16565 | 16565 | William Sharp S000296 | rep | OH | 1909-03-15 | 1911-03-03 | Democrat | 14 | |||||||||||||
16609 | 16609 | George Taylor T000078 | rep | AL | 1909-03-15 | 1911-03-03 | Democrat | 1 | |||||||||||||
16656 | 16656 | Thomas Hardwick H000193 | rep | GA | 1909-03-15 | 1911-03-03 | Democrat | 10 | |||||||||||||
16665 | 16665 | John Adair A000027 | rep | IN | 1909-03-15 | 1911-03-03 | Democrat | 8 | |||||||||||||
16672 | 16672 | Wyatt Aiken A000064 | rep | SC | 1909-03-15 | 1911-03-03 | Democrat | 3 | |||||||||||||
16702 | 16702 | Robert Broussard B000896 | rep | LA | 1909-03-15 | 1911-03-03 | Democrat | 3 | |||||||||||||
16716 | 16716 | George Burgess B001083 | rep | TX | 1909-03-15 | 1911-03-03 | Democrat | 9 | |||||||||||||
16732 | 16732 | Cyrus Cline C000521 | rep | IN | 1909-03-15 | 1911-03-03 | Democrat | 12 | |||||||||||||
16737 | 16737 | William Cullop C000975 | rep | IN | 1909-03-15 | 1911-03-03 | Democrat | 2 | |||||||||||||
16749 | 16749 | Daniel Driscoll D000500 | rep | NY | 1909-03-15 | 1911-03-03 | Democrat | 35 | |||||||||||||
16766 | 16766 | Joseph Goulden G000344 | rep | NY | 1909-03-15 | 1911-03-03 | Democrat | 18 |
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);