legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
30 rows where class = 3 and "start" is on date 1903-11-09
This data as json, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||
14307 | 14307 | Charles Fairbanks F000003 | sen | IN | 1903-11-09 | 1905-12-31 | 3 | Republican | |||||||||||||
14312 | 14312 | Joseph Foraker F000253 | sen | OH | 1903-11-09 | 1909-03-03 | 3 | Republican | |||||||||||||
14316 | 14316 | Charles Fulton F000420 | sen | OR | 1903-11-09 | 1909-03-03 | 3 | Republican | |||||||||||||
14336 | 14336 | Arthur Gorman G000326 | sen | MD | 1903-11-09 | 1907-03-03 | 3 | Democrat | |||||||||||||
14344 | 14344 | Henry Hansbrough H000169 | sen | ND | 1903-11-09 | 1909-03-03 | 3 | Republican | |||||||||||||
14356 | 14356 | Albert Hopkins H000770 | sen | IL | 1903-11-09 | 1909-03-03 | 3 | Republican | |||||||||||||
14366 | 14366 | Alfred Kittredge K000255 | sen | SD | 1903-11-09 | 1909-03-03 | 3 | Republican | |||||||||||||
14378 | 14378 | Asbury Latimer L000114 | sen | SC | 1903-11-09 | 1909-03-03 | 3 | Democrat | |||||||||||||
14387 | 14387 | Chester Long L000412 | sen | KS | 1903-11-09 | 1909-03-03 | 3 | Republican | |||||||||||||
14400 | 14400 | Stephen Mallory M000085 | sen | FL | 1903-11-09 | 1907-12-23 | 3 | Democrat | |||||||||||||
14412 | 14412 | James McCreary M000382 | sen | KY | 1903-11-09 | 1909-03-03 | 3 | Democrat | |||||||||||||
14425 | 14425 | Edmund Pettus P000279 | sen | AL | 1903-11-09 | 1907-12-31 | 3 | Democrat | |||||||||||||
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 | |||||||||||||
14485 | 14485 | John Spooner S000741 | sen | WI | 1903-11-09 | 1907-12-31 | 3 | Republican | |||||||||||||
14497 | 14497 | Henry Teller T000116 | sen | CO | 1903-11-09 | 1909-03-03 | 3 | Democrat | |||||||||||||
15387 | 15387 | Alexander Clay C000478 | sen | GA | 1903-11-09 | 1909-03-03 | 3 | Democrat | |||||||||||||
15516 | 15516 | Weldon Heyburn H000554 | sen | ID | 1903-11-09 | 1909-03-03 | 3 | Republican | |||||||||||||
15636 | 15636 | Samuel McEnery M000429 | sen | LA | 1903-11-09 | 1909-03-03 | 3 | Democrat | |||||||||||||
15698 | 15698 | George Perkins P000232 | sen | CA | 1903-11-09 | 1909-03-03 | 3 | Republican | |||||||||||||
16729 | 16729 | James Clarke C000463 | sen | AR | 1903-11-09 | 1909-03-03 | 3 | Democrat | |||||||||||||
16760 | 16760 | Jacob Gallinger G000023 | sen | NH | 1903-11-09 | 1909-03-03 | 3 | Republican | |||||||||||||
16909 | 16909 | Francis Newlands N000069 | sen | NV | 1903-11-09 | 1909-03-03 | 3 | Democrat | |||||||||||||
16927 | 16927 | Boies Penrose P000217 | sen | PA | 1903-11-09 | 1909-03-03 | 3 | Republican | |||||||||||||
17018 | 17018 | William Stone S000968 | sen | MO | 1903-11-09 | 1909-03-03 | 3 | Democrat | |||||||||||||
18149 | 18149 | William Dillingham D000347 | sen | VT | 1903-11-09 | 1909-03-03 | 3 | Republican | |||||||||||||
19455 | 19455 | Lee Overman O000140 | sen | NC | 1903-11-09 | 1909-03-03 | 3 | Democrat | |||||||||||||
19488 | 19488 | Reed Smoot S000644 | sen | UT | 1903-11-09 | 1909-03-03 | 3 | Republican |
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);