legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
32 rows where district = "-1" and "end" is on date 1819-03-03
This data as json, copyable, CSV (advanced)
Suggested facets: state, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1801 | 1801 | Benjamin Bennet B000368 | rep | NJ | 1817-12-01 | 1819-03-03 | Republican | -1 | |||||||||||||
1805 | 1805 | John Boss B000650 | rep | RI | 1817-12-01 | 1819-03-03 | Federalist | -1 | |||||||||||||
1818 | 1818 | Zadock Cook C000728 | rep | GA | 1817-12-01 | 1819-03-03 | Republican | -1 | |||||||||||||
1844 | 1844 | Sylvester Gilbert G000178 | rep | CT | 1817-12-01 | 1819-03-03 | Republican | -1 | |||||||||||||
1853 | 1853 | Salma Hale H000038 | rep | NH | 1817-12-01 | 1819-03-03 | Republican | -1 | |||||||||||||
1860 | 1860 | Uriel Holmes H000743 | rep | CT | 1817-12-01 | 1819-03-03 | Federalist | -1 | |||||||||||||
1865 | 1865 | Ebenezer Huntington H000996 | rep | CT | 1817-12-01 | 1819-03-03 | Federalist | -1 | |||||||||||||
1877 | 1877 | James Mason M000215 | rep | RI | 1817-12-01 | 1819-03-03 | Federalist | -1 | |||||||||||||
1900 | 1900 | Timothy Pitkin P000368 | rep | CT | 1817-12-01 | 1819-03-03 | Federalist | -1 | |||||||||||||
1902 | 1902 | Nathaniel Pope P000432 | rep | IL | 1817-12-01 | 1819-03-03 | -1 | ||||||||||||||
1924 | 1924 | Samuel Sherwood S000357 | rep | CT | 1817-12-01 | 1819-03-03 | Federalist | -1 | |||||||||||||
1938 | 1938 | Nathaniel Terry T000135 | rep | CT | 1817-12-01 | 1819-03-03 | Federalist | -1 | |||||||||||||
1950 | 1950 | Thomas Williams W000541 | rep | CT | 1817-12-01 | 1819-03-03 | Federalist | -1 | |||||||||||||
1971 | 1971 | Joseph Bloomfield B000566 | rep | NJ | 1817-12-01 | 1819-03-03 | Republican | -1 | |||||||||||||
1993 | 1993 | Clifton Clagett C000399 | rep | NH | 1817-12-01 | 1819-03-03 | Republican | -1 | |||||||||||||
2002 | 2002 | Joel Crawford C000891 | rep | GA | 1817-12-01 | 1819-03-03 | Republican | -1 | |||||||||||||
2004 | 2004 | John Crowell C000942 | rep | AL | 1817-12-01 | 1819-03-03 | -1 | ||||||||||||||
2055 | 2055 | Charles Kinsey K000227 | rep | NJ | 1817-12-01 | 1819-03-03 | Republican | -1 | |||||||||||||
2059 | 2059 | John Linn L000337 | rep | NJ | 1817-12-01 | 1819-03-03 | Republican | -1 | |||||||||||||
2089 | 2089 | Jonathan Moseley M001023 | rep | CT | 1817-12-01 | 1819-03-03 | Federalist | -1 | |||||||||||||
2096 | 2096 | John Parrott P000084 | rep | NH | 1817-12-01 | 1819-03-03 | Republican | -1 | |||||||||||||
2146 | 2146 | Henry Southard S000685 | rep | NJ | 1817-12-01 | 1819-03-03 | Republican | -1 | |||||||||||||
2159 | 2159 | William Terrell T000132 | rep | GA | 1817-12-01 | 1819-03-03 | Republican | -1 | |||||||||||||
2211 | 2211 | Josiah Butler B001181 | rep | NH | 1817-12-01 | 1819-03-03 | Republican | -1 | |||||||||||||
2309 | 2309 | Robert Reid R000151 | rep | GA | 1817-12-01 | 1819-03-03 | Republican | -1 | |||||||||||||
2334 | 2334 | Nathaniel Upham U000024 | rep | NH | 1817-12-01 | 1819-03-03 | Republican | -1 | |||||||||||||
2373 | 2373 | Joel Abbott A000003 | rep | GA | 1817-12-01 | 1819-03-03 | Republican | -1 | |||||||||||||
2440 | 2440 | Arthur Livermore L000362 | rep | NH | 1817-12-01 | 1819-03-03 | Republican | -1 | |||||||||||||
2542 | 2542 | Thomas Cobb C000553 | rep | GA | 1817-12-01 | 1819-03-03 | Republican | -1 | |||||||||||||
2715 | 2715 | John Scott S000176 | rep | MO | 1817-12-01 | 1819-03-03 | -1 | ||||||||||||||
2745 | 2745 | Ephraim Bateman B000228 | rep | NJ | 1817-12-01 | 1819-03-03 | Republican | -1 | |||||||||||||
5636 | 5636 | John Calhoun C000044 | rep | SC | 1817-12-01 | 1819-03-03 | Democratic 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);