legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
40 rows where district = 1 and "start" is on date 1901-12-02
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13897 | 13897 | Melville Bull B001048 | rep | RI | 1901-12-02 | 1903-03-03 | Republican | 1 | |||||||||||||
13908 | 13908 | Frank Coombs C000741 | rep | CA | 1901-12-02 | 1903-03-03 | Republican | 1 | |||||||||||||
13915 | 13915 | John Corliss C000779 | rep | MI | 1901-12-02 | 1903-03-03 | Republican | 1 | |||||||||||||
13944 | 13944 | Caldwell Edwards E000061 | rep | MT | 1901-12-02 | 1903-03-03 | Populist | 1 | |||||||||||||
13951 | 13951 | William Elliott E000129 | rep | SC | 1901-12-02 | 1903-03-03 | Democrat | 1 | |||||||||||||
13967 | 13967 | Thomas Glenn G000239 | rep | ID | 1901-12-02 | 1903-03-03 | Populist | 1 | |||||||||||||
14061 | 14061 | Philip McCulloch M000391 | rep | AR | 1901-12-02 | 1903-03-03 | Democrat | 1 | |||||||||||||
14159 | 14159 | William Shattuc S000300 | rep | OH | 1901-12-02 | 1903-03-03 | Republican | 1 | |||||||||||||
14195 | 14195 | Frederic Storm S000974 | rep | NY | 1901-12-02 | 1903-03-03 | Republican | 1 | |||||||||||||
14214 | 14214 | Charles Wheeler W000331 | rep | KY | 1901-12-02 | 1903-03-03 | Democrat | 1 | |||||||||||||
14242 | 14242 | Thomas Ball B000101 | rep | TX | 1901-12-02 | 1903-03-03 | Democrat | 1 | |||||||||||||
14508 | 14508 | Thomas Tongue T000309 | rep | OR | 1901-12-02 | 1903-03-03 | Republican | 1 | |||||||||||||
14600 | 14600 | Elmer Burkett B001103 | rep | NE | 1901-12-02 | 1903-03-03 | Republican | 1 | |||||||||||||
14647 | 14647 | Blackburn Dovener D000461 | rep | WV | 1901-12-02 | 1903-03-03 | Republican | 1 | |||||||||||||
14698 | 14698 | Thomas Hedge H000441 | rep | IA | 1901-12-02 | 1903-03-03 | Republican | 1 | |||||||||||||
14704 | 14704 | James Hemenway H000467 | rep | IN | 1901-12-02 | 1903-03-03 | Republican | 1 | |||||||||||||
14777 | 14777 | Rufus Lester L000255 | rep | GA | 1901-12-02 | 1903-03-03 | Democrat | 1 | |||||||||||||
15160 | 15160 | William Jackson J000029 | rep | MD | 1901-12-02 | 1903-03-03 | Republican | 1 | |||||||||||||
15209 | 15209 | Thomas Marshall M000163 | rep | ND | 1901-12-02 | 1903-03-03 | Republican | 1 | |||||||||||||
15230 | 15230 | Adolph Meyer M000679 | rep | LA | 1901-12-02 | 1903-03-03 | Democrat | 1 | |||||||||||||
15331 | 15331 | Amos Allen A000112 | rep | ME | 1901-12-02 | 1903-03-03 | Republican | 1 | |||||||||||||
15359 | 15359 | Walter Brownlow B000962 | rep | TN | 1901-12-02 | 1903-03-03 | Republican | 1 | |||||||||||||
15774 | 15774 | James Tawney T000060 | rep | MN | 1901-12-02 | 1903-03-03 | Republican | 1 | |||||||||||||
15865 | 15865 | Henry Bingham B000469 | rep | PA | 1901-12-02 | 1903-03-03 | Republican | 1 | |||||||||||||
15966 | 15966 | David Foster F000300 | rep | VT | 1901-12-02 | 1903-03-03 | Republican | 1 | |||||||||||||
16000 | 16000 | Edward Henry H000505 | rep | CT | 1901-12-02 | 1903-03-03 | Republican | 1 | |||||||||||||
16038 | 16038 | George Lawrence L000133 | rep | MA | 1901-12-02 | 1903-03-03 | Republican | 1 | |||||||||||||
16060 | 16060 | Henry Loudenslager L000450 | rep | NJ | 1901-12-02 | 1903-03-03 | Republican | 1 | |||||||||||||
16204 | 16204 | George Sutherland S001080 | rep | UT | 1901-12-02 | 1903-03-03 | Republican | 1 | |||||||||||||
16562 | 16562 | John Shafroth S000279 | rep | CO | 1901-12-02 | 1903-03-03 | Silver Republican | 1 | |||||||||||||
16605 | 16605 | George Taylor T000078 | rep | AL | 1901-12-02 | 1903-03-03 | Democrat | 1 | |||||||||||||
16857 | 16857 | James Lloyd L000380 | rep | MO | 1901-12-02 | 1903-03-03 | Democrat | 1 | |||||||||||||
16990 | 16990 | Stephen Sparkman S000702 | rep | FL | 1901-12-02 | 1903-03-03 | Democrat | 1 | |||||||||||||
17314 | 17314 | William Jones J000259 | rep | VA | 1901-12-02 | 1903-03-03 | Democrat | 1 | |||||||||||||
17460 | 17460 | Cyrus Sulloway S001063 | rep | NH | 1901-12-02 | 1903-03-03 | Republican | 1 | |||||||||||||
17594 | 17594 | Ezekiel Candler C000110 | rep | MS | 1901-12-02 | 1903-03-03 | Democrat | 1 | |||||||||||||
17946 | 17946 | John Small S000500 | rep | NC | 1901-12-02 | 1903-03-03 | Democrat | 1 | |||||||||||||
18324 | 18324 | James Mann M000104 | rep | IL | 1901-12-02 | 1903-03-03 | Republican | 1 | |||||||||||||
19273 | 19273 | Charles Curtis C001008 | rep | KS | 1901-12-02 | 1903-03-03 | Republican | 1 | |||||||||||||
20235 | 20235 | Henry Cooper C000752 | rep | WI | 1901-12-02 | 1903-03-03 | Republican | 1 |
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);