legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
35 rows where class = 3 and "end" is on date 1909-03-03
This data as json, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
14412 | 14412 | James McCreary M000382 | sen | KY | 1903-11-09 | 1909-03-03 | 3 | Democrat | |||||||||||||
14442 | 14442 | Thomas Platt P000383 | sen | NY | 1903-11-09 | 1909-03-03 | 3 | Republican | |||||||||||||
14497 | 14497 | Henry Teller T000116 | sen | CO | 1903-11-09 | 1909-03-03 | 3 | Democrat | |||||||||||||
14706 | 14706 | James Hemenway H000467 | sen | IN | 1905-12-04 | 1909-03-03 | 3 | Republican | |||||||||||||
14961 | 14961 | William Whyte W000435 | sen | MD | 1906-01-01 | 1909-03-03 | 3 | Democrat | |||||||||||||
15012 | 15012 | William Bryan B000994 | sen | FL | 1907-12-02 | 1909-03-03 | 3 | Democrat | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
15563 | 15563 | Joseph Johnston J000193 | sen | AL | 1907-12-02 | 1909-03-03 | 3 | Democrat | |||||||||||||
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 | |||||||||||||
15764 | 15764 | Isaac Stephenson S000863 | sen | WI | 1907-12-02 | 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 | |||||||||||||
16967 | 16967 | John Smith S000577 | sen | MD | 1908-03-25 | 1909-03-03 | 3 | Democrat | |||||||||||||
17018 | 17018 | William Stone S000968 | sen | MO | 1903-11-09 | 1909-03-03 | 3 | Democrat | |||||||||||||
18062 | 18062 | Frank Brandegee B000769 | sen | CT | 1905-05-10 | 1909-03-03 | 3 | Republican | |||||||||||||
18141 | 18141 | Albert Cummins C000988 | sen | IA | 1908-11-24 | 1909-03-03 | 3 | Republican | |||||||||||||
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 | |||||||||||||
20430 | 20430 | Thomas Gore G000323 | sen | OK | 1907-12-02 | 1909-03-03 | 3 | Democrat |
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);