legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
30 rows where class = 3 and "end" is on date 1897-03-03
This data as json, copyable, CSV (advanced)
Suggested facets: start, party, start (date), 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12099 | 12099 | Calvin Brice B000818 | sen | OH | 1891-12-07 | 1897-03-03 | 3 | Democrat | |||||||||||||
12125 | 12125 | Wilkinson Call C000051 | sen | FL | 1891-12-07 | 1897-03-03 | 3 | Democrat | |||||||||||||
12129 | 12129 | James Cameron C000065 | sen | PA | 1891-12-07 | 1897-03-03 | 3 | Republican | |||||||||||||
12180 | 12180 | Charles Gibson G000157 | sen | MD | 1891-12-07 | 1897-03-03 | 3 | Democrat | |||||||||||||
12184 | 12184 | John Gordon G000313 | sen | GA | 1891-12-07 | 1897-03-03 | 3 | Democrat | |||||||||||||
12216 | 12216 | John Irby I000027 | sen | SC | 1891-12-07 | 1897-03-03 | 3 | Democrat | |||||||||||||
12260 | 12260 | John Palmer P000042 | sen | IL | 1891-12-07 | 1897-03-03 | 3 | Democrat | |||||||||||||
12270 | 12270 | William Peffer P000188 | sen | KS | 1891-12-07 | 1897-03-03 | 3 | Populist | |||||||||||||
12274 | 12274 | James Pugh P000561 | sen | AL | 1891-12-07 | 1897-03-03 | 3 | Democrat | |||||||||||||
12296 | 12296 | Watson Squire S000761 | sen | WA | 1891-12-07 | 1897-03-03 | 3 | Republican | |||||||||||||
12344 | 12344 | William Vilas V000099 | sen | WI | 1891-12-07 | 1897-03-03 | 3 | Democrat | |||||||||||||
12353 | 12353 | Daniel Voorhees V000116 | sen | IN | 1891-12-07 | 1897-03-03 | 3 | Democrat | |||||||||||||
12371 | 12371 | David Hill H000590 | sen | NY | 1892-01-01 | 1897-03-03 | 3 | Democrat | |||||||||||||
12882 | 12882 | Newton Blanchard B000541 | sen | LA | 1894-01-01 | 1897-03-03 | 3 | Democrat | |||||||||||||
13226 | 13226 | Arthur Brown B000902 | sen | UT | 1896-01-01 | 1897-03-03 | 3 | Republican | |||||||||||||
13365 | 13365 | James Jones J000231 | sen | AR | 1891-12-07 | 1897-03-03 | 3 | Democrat | |||||||||||||
13370 | 13370 | John Jones J000237 | sen | NV | 1891-12-07 | 1897-03-03 | 3 | Republican | |||||||||||||
13379 | 13379 | James Kyle K000353 | sen | SD | 1891-12-07 | 1897-03-03 | 3 | Populist | |||||||||||||
13435 | 13435 | Justin Morrill M000969 | sen | VT | 1891-12-07 | 1897-03-03 | 3 | Republican | |||||||||||||
13454 | 13454 | Jeter Pritchard P000545 | sen | NC | 1895-12-02 | 1897-03-03 | 3 | Republican | |||||||||||||
13517 | 13517 | George Vest V000091 | sen | MO | 1891-12-07 | 1897-03-03 | 3 | Democrat | |||||||||||||
13869 | 13869 | Joseph Blackburn B000508 | sen | KY | 1891-12-07 | 1897-03-03 | 3 | Democrat | |||||||||||||
13938 | 13938 | Fred Dubois D000509 | sen | ID | 1891-12-07 | 1897-03-03 | 3 | Republican | |||||||||||||
14083 | 14083 | John Mitchell M000818 | sen | OR | 1891-12-07 | 1897-03-03 | 3 | Republican | |||||||||||||
14234 | 14234 | William Allison A000160 | sen | IA | 1891-12-07 | 1897-03-03 | 3 | Republican | |||||||||||||
14342 | 14342 | Henry Hansbrough H000169 | sen | ND | 1891-12-07 | 1897-03-03 | 3 | Republican | |||||||||||||
14435 | 14435 | Orville Platt P000382 | sen | CT | 1891-12-07 | 1897-03-03 | 3 | Republican | |||||||||||||
14495 | 14495 | Henry Teller T000116 | sen | CO | 1891-12-07 | 1897-03-03 | 3 | Republican | |||||||||||||
15696 | 15696 | George Perkins P000232 | sen | CA | 1893-08-07 | 1897-03-03 | 3 | Republican | |||||||||||||
16758 | 16758 | Jacob Gallinger G000023 | sen | NH | 1891-12-07 | 1897-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);