legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
437 rows where "start" is on date 1903-11-09
This data as json, copyable, CSV (advanced)
Suggested facets: type, party, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14226 | 14226 | James Allee A000110 | sen | DE | 1903-11-09 | 1907-03-03 | 2 | Republican | |||||||||||||
14236 | 14236 | William Allison A000160 | sen | IA | 1903-11-09 | 1909-03-03 | 3 | Republican | |||||||||||||
14237 | 14237 | Levi Ankeny A000258 | sen | WA | 1903-11-09 | 1909-03-03 | 3 | Republican | |||||||||||||
14238 | 14238 | De Badger B000021 | rep | OH | 1903-11-09 | 1905-03-03 | Democrat | 12 | |||||||||||||
14239 | 14239 | Robert Baker B000073 | rep | NY | 1903-11-09 | 1905-03-03 | Democrat | 6 | |||||||||||||
14243 | 14243 | Thomas Ball B000101 | rep | TX | 1903-11-09 | 1905-03-03 | Democrat | 8 | |||||||||||||
14244 | 14244 | Edward Bassett B000225 | rep | NY | 1903-11-09 | 1905-03-03 | Democrat | 5 | |||||||||||||
14245 | 14245 | Theodore Bell B000347 | rep | CA | 1903-11-09 | 1905-03-03 | Democrat | 2 | |||||||||||||
14246 | 14246 | Allan Benny B000385 | rep | NJ | 1903-11-09 | 1905-03-03 | Democrat | 9 | |||||||||||||
14250 | 14250 | Maecenas Benton B000397 | rep | MO | 1903-11-09 | 1905-03-03 | Democrat | 15 | |||||||||||||
14253 | 14253 | Vincent Boreing B000637 | rep | KY | 1903-11-09 | 1905-03-03 | Republican | 11 | |||||||||||||
14256 | 14256 | Phanor Breazeale B000781 | rep | LA | 1903-11-09 | 1905-03-03 | Democrat | 4 | |||||||||||||
14257 | 14257 | James Brown B000923 | rep | PA | 1903-11-09 | 1905-03-03 | Ind. Republican | 32 | |||||||||||||
14259 | 14259 | Henry Burk B001085 | rep | PA | 1903-11-09 | 1905-03-03 | Republican | 3 | |||||||||||||
14261 | 14261 | James Butler B001178 | rep | MO | 1903-11-09 | 1905-03-03 | Democrat | 12 | |||||||||||||
14263 | 14263 | John Cassingham C000239 | rep | OH | 1903-11-09 | 1905-03-03 | Democrat | 17 | |||||||||||||
14267 | 14267 | Charles Cochran C000562 | rep | MO | 1903-11-09 | 1905-03-03 | Democrat | 4 | |||||||||||||
14271 | 14271 | William Connell C000687 | rep | PA | 1903-11-09 | 1905-03-03 | Republican | 10 | |||||||||||||
14275 | 14275 | William Cowherd C000825 | rep | MO | 1903-11-09 | 1905-03-03 | Democrat | 5 | |||||||||||||
14276 | 14276 | George Croft C000921 | rep | SC | 1903-11-09 | 1905-03-03 | Democrat | 2 | |||||||||||||
14277 | 14277 | Theodore Croft C000922 | rep | SC | 1903-11-09 | 1905-03-03 | Democrat | 2 | |||||||||||||
14280 | 14280 | Joseph Crowley C000943 | rep | IL | 1903-11-09 | 1905-03-03 | Democrat | 23 | |||||||||||||
14281 | 14281 | Milton Daniels D000042 | rep | CA | 1903-11-09 | 1905-03-03 | Republican | 8 | |||||||||||||
14285 | 14285 | Robert Davis D000132 | rep | FL | 1903-11-09 | 1905-03-03 | Democrat | 2 | |||||||||||||
14286 | 14286 | Edward De Nivernais D000230 | rep | CA | 1903-11-09 | 1905-03-03 | Democratic and Union Labor | -1 | |||||||||||||
14288 | 14288 | Federico Degetau D000196 | rep | PR | 1903-11-09 | 1905-03-03 | Republican | 0 | |||||||||||||
14290 | 14290 | James Denny D000250 | rep | MD | 1903-11-09 | 1905-03-03 | Democrat | 4 | |||||||||||||
14291 | 14291 | Charles Dickerman D000307 | rep | PA | 1903-11-09 | 1905-03-03 | Democrat | 16 | |||||||||||||
14297 | 14297 | Hugh Dinsmore D000358 | rep | AR | 1903-11-09 | 1905-03-03 | Democrat | 3 | |||||||||||||
14300 | 14300 | John Dougherty D000447 | rep | MO | 1903-11-09 | 1905-03-03 | Democrat | 3 | |||||||||||||
14302 | 14302 | William Douglas D000458 | rep | NY | 1903-11-09 | 1905-03-03 | Republican | 15 | |||||||||||||
14303 | 14303 | Martin Emerich E000170 | rep | IL | 1903-11-09 | 1905-03-03 | Democrat | 1 | |||||||||||||
14305 | 14305 | Alvin Evans E000232 | rep | PA | 1903-11-09 | 1905-03-03 | Republican | 19 | |||||||||||||
14307 | 14307 | Charles Fairbanks F000003 | sen | IN | 1903-11-09 | 1905-12-31 | 3 | Republican | |||||||||||||
14308 | 14308 | Morgan Fitzpatrick F000176 | rep | TN | 1903-11-09 | 1905-03-03 | Democrat | 4 | |||||||||||||
14310 | 14310 | Robert Foerderer F000232 | rep | PA | 1903-11-09 | 1905-03-03 | Republican | 4 | |||||||||||||
14312 | 14312 | Joseph Foraker F000253 | sen | OH | 1903-11-09 | 1909-03-03 | 3 | Republican | |||||||||||||
14315 | 14315 | George Foster F000303 | rep | IL | 1903-11-09 | 1905-03-03 | Democrat | 4 | |||||||||||||
14316 | 14316 | Charles Fulton F000420 | sen | OR | 1903-11-09 | 1909-03-03 | 3 | Republican | |||||||||||||
14321 | 14321 | Henry Gibson G000161 | rep | TN | 1903-11-09 | 1905-03-03 | Republican | 2 | |||||||||||||
14324 | 14324 | Joseph Gill G000189 | rep | OH | 1903-11-09 | 1905-03-03 | Republican | 16 | |||||||||||||
14330 | 14330 | Charles Gillet G000199 | rep | NY | 1903-11-09 | 1905-03-03 | Republican | 33 | |||||||||||||
14332 | 14332 | Daniel Gooch G000273 | rep | KY | 1903-11-09 | 1905-03-03 | Democrat | 6 | |||||||||||||
14336 | 14336 | Arthur Gorman G000326 | sen | MD | 1903-11-09 | 1907-03-03 | 3 | Democrat | |||||||||||||
14340 | 14340 | Francis Griffith G000468 | rep | IN | 1903-11-09 | 1905-03-03 | Democrat | 4 | |||||||||||||
14344 | 14344 | Henry Hansbrough H000169 | sen | ND | 1903-11-09 | 1909-03-03 | 3 | Republican | |||||||||||||
14346 | 14346 | Charles Hildebrant H000585 | rep | OH | 1903-11-09 | 1905-03-03 | Republican | 6 | |||||||||||||
14356 | 14356 | Albert Hopkins H000770 | sen | IL | 1903-11-09 | 1909-03-03 | 3 | Republican | |||||||||||||
14357 | 14357 | Henry Houston H000823 | rep | DE | 1903-11-09 | 1905-03-03 | Democrat | 0 | |||||||||||||
14358 | 14358 | George Howell H000862 | rep | PA | 1903-11-09 | 1905-03-03 | Democrat | 10 | |||||||||||||
14361 | 14361 | Whiteside Hunter H000989 | rep | KY | 1903-11-09 | 1905-03-03 | Republican | 11 | |||||||||||||
14362 | 14362 | Amos Jackson J000004 | rep | OH | 1903-11-09 | 1905-03-03 | Republican | 13 | |||||||||||||
14364 | 14364 | James Kehoe K000045 | rep | KY | 1903-11-09 | 1905-03-03 | Democrat | 9 | |||||||||||||
14366 | 14366 | Alfred Kittredge K000255 | sen | SD | 1903-11-09 | 1909-03-03 | 3 | Republican | |||||||||||||
14369 | 14369 | Theodore Kluttz K000275 | rep | NC | 1903-11-09 | 1905-03-03 | Democrat | 8 | |||||||||||||
14371 | 14371 | Thomas Kyle K000355 | rep | OH | 1903-11-09 | 1905-03-03 | Republican | 7 | |||||||||||||
14372 | 14372 | William Lanning L000084 | rep | NJ | 1903-11-09 | 1905-03-03 | Republican | 4 | |||||||||||||
14378 | 14378 | Asbury Latimer L000114 | sen | SC | 1903-11-09 | 1909-03-03 | 3 | Democrat | |||||||||||||
14382 | 14382 | John Lind L000319 | rep | MN | 1903-11-09 | 1905-03-03 | Democrat | 5 | |||||||||||||
14383 | 14383 | Edward Livernash L000365 | rep | CA | 1903-11-09 | 1905-03-03 | Democrat | 4 | |||||||||||||
14387 | 14387 | Chester Long L000412 | sen | KS | 1903-11-09 | 1909-03-03 | 3 | Republican | |||||||||||||
14388 | 14388 | Alfred Lucking L000500 | rep | MI | 1903-11-09 | 1905-03-03 | Democrat | 1 | |||||||||||||
14394 | 14394 | John Maddox M000040 | rep | GA | 1903-11-09 | 1905-03-03 | Democrat | 7 | |||||||||||||
14396 | 14396 | William Mahoney M000069 | rep | IL | 1903-11-09 | 1905-03-03 | Democrat | 8 | |||||||||||||
14400 | 14400 | Stephen Mallory M000085 | sen | FL | 1903-11-09 | 1907-12-23 | 3 | Democrat | |||||||||||||
14405 | 14405 | George McClellan M000331 | rep | NY | 1903-11-09 | 1905-03-03 | Democrat | 12 | |||||||||||||
14412 | 14412 | James McCreary M000382 | sen | KY | 1903-11-09 | 1909-03-03 | 3 | Democrat | |||||||||||||
14415 | 14415 | Victor Metcalf M000672 | rep | CA | 1903-11-09 | 1905-03-03 | Republican | 3 | |||||||||||||
14419 | 14419 | Robert Miers M000700 | rep | IN | 1903-11-09 | 1905-03-03 | Democrat | 2 | |||||||||||||
14422 | 14422 | Stephen Morgan M000957 | rep | OH | 1903-11-09 | 1905-03-03 | Republican | 10 | |||||||||||||
14423 | 14423 | Norton Otis O000130 | rep | NY | 1903-11-09 | 1905-03-03 | Republican | 19 | |||||||||||||
14425 | 14425 | Edmund Pettus P000279 | sen | AL | 1903-11-09 | 1907-12-31 | 3 | Democrat | |||||||||||||
14432 | 14432 | Rice Pierce P000337 | rep | TN | 1903-11-09 | 1905-03-03 | Democrat | 9 | |||||||||||||
14437 | 14437 | Orville Platt P000382 | sen | CT | 1903-11-09 | 1905-12-31 | 3 | Republican | |||||||||||||
14442 | 14442 | Thomas Platt P000383 | sen | NY | 1903-11-09 | 1909-03-03 | 3 | Republican | |||||||||||||
14443 | 14443 | Henry Porter P000441 | rep | PA | 1903-11-09 | 1905-03-03 | Ind. Republican | 31 | |||||||||||||
14445 | 14445 | Samuel Powers P000492 | rep | MA | 1903-11-09 | 1905-03-03 | Republican | 12 | |||||||||||||
14449 | 14449 | John Rhea R000182 | rep | KY | 1903-11-09 | 1905-03-03 | Democrat | 3 | |||||||||||||
14459 | 14459 | James Richardson R000222 | rep | TN | 1903-11-09 | 1905-03-03 | Democrat | 5 | |||||||||||||
14460 | 14460 | Ira Rider R000242 | rep | NY | 1903-11-09 | 1905-03-03 | Democrat | 14 | |||||||||||||
14464 | 14464 | Edward Robb R000296 | rep | MO | 1903-11-09 | 1905-03-03 | Democrat | 13 | |||||||||||||
14468 | 14468 | James Robinson R000338 | rep | IN | 1903-11-09 | 1905-03-03 | Democrat | 12 | |||||||||||||
14470 | 14470 | Bernard Rodey R000372 | rep | NM | 1903-11-09 | 1905-03-03 | Republican | -1 | |||||||||||||
14472 | 14472 | Robert Scarborough S000107 | rep | SC | 1903-11-09 | 1905-03-03 | Democrat | 6 | |||||||||||||
14474 | 14474 | Townsend Scudder S000202 | rep | NY | 1903-11-09 | 1905-03-03 | Democrat | 1 | |||||||||||||
14475 | 14475 | George Shiras S000370 | rep | PA | 1903-11-09 | 1905-03-03 | Ind. Republican | 29 | |||||||||||||
14476 | 14476 | Francis Shober S000373 | rep | NY | 1903-11-09 | 1905-03-03 | Democrat | 17 | |||||||||||||
14477 | 14477 | Joseph Shull S000391 | rep | PA | 1903-11-09 | 1905-03-03 | Democrat | 26 | |||||||||||||
14479 | 14479 | William Skiles S000466 | rep | OH | 1903-11-09 | 1905-03-03 | Republican | 14 | |||||||||||||
14480 | 14480 | George Smith S000538 | rep | NY | 1903-11-09 | 1905-03-03 | Republican | 24 | |||||||||||||
14482 | 14482 | Burleigh Spalding S000695 | rep | ND | 1903-11-09 | 1905-03-03 | Republican | -1 | |||||||||||||
14485 | 14485 | John Spooner S000741 | sen | WI | 1903-11-09 | 1907-12-31 | 3 | Republican | |||||||||||||
14491 | 14491 | Farish Tate T000046 | rep | GA | 1903-11-09 | 1905-03-03 | Democrat | 9 | |||||||||||||
14497 | 14497 | Henry Teller T000116 | sen | CO | 1903-11-09 | 1909-03-03 | 3 | Democrat | |||||||||||||
14500 | 14500 | John Thayer T000149 | rep | MA | 1903-11-09 | 1905-03-03 | Democrat | 3 | |||||||||||||
14503 | 14503 | Lot Thomas T000179 | rep | IA | 1903-11-09 | 1905-03-03 | Republican | 11 | |||||||||||||
14505 | 14505 | Charles Thompson T000196 | rep | AL | 1903-11-09 | 1905-03-03 | Democrat | 5 | |||||||||||||
14509 | 14509 | Thomas Tongue T000309 | rep | OR | 1903-11-09 | 1905-03-03 | Republican | -1 | |||||||||||||
14515 | 14515 | Henry Van Voorhis V000062 | rep | OH | 1903-11-09 | 1905-03-03 | Republican | 15 | |||||||||||||
14519 | 14519 | Willard Vandiver V000032 | rep | MO | 1903-11-09 | 1905-03-03 | Democrat | 14 |
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);