legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
32 rows where district = 3 and "start" is on date 1879-03-18
This data as json, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9993 | 9993 | Joseph Acklen A000023 | rep | LA | 1879-03-18 | 1881-03-03 | Democrat | 3 | |||||||||||||
10004 | 10004 | Hiram Barber B000120 | rep | IL | 1879-03-18 | 1881-03-03 | Republican | 3 | |||||||||||||
10005 | 10005 | Bradley Barlow B000148 | rep | VT | 1879-03-18 | 1881-03-03 | National Greenbacker | 3 | |||||||||||||
10012 | 10012 | George Bicknell B000438 | rep | IN | 1879-03-18 | 1881-03-03 | Democrat | 3 | |||||||||||||
10034 | 10034 | Simeon Chittenden C000373 | rep | NY | 1879-03-18 | 1881-03-03 | Republican | 3 | |||||||||||||
10073 | 10073 | Evarts Farr F000028 | rep | NH | 1879-03-18 | 1881-03-03 | Republican | 3 | |||||||||||||
10079 | 10079 | Walbridge Field F000108 | rep | MA | 1879-03-18 | 1881-03-03 | Republican | 3 | |||||||||||||
10120 | 10120 | Joseph Johnston J000192 | rep | VA | 1879-03-18 | 1881-03-03 | Democrat | 3 | |||||||||||||
10129 | 10129 | William Kimmel K000185 | rep | MD | 1879-03-18 | 1881-03-03 | Democrat | 3 | |||||||||||||
10143 | 10143 | Jonas McGowan M000453 | rep | MI | 1879-03-18 | 1881-03-03 | Republican | 3 | |||||||||||||
10146 | 10146 | John McMahon M000561 | rep | OH | 1879-03-18 | 1881-03-03 | Democrat | 3 | |||||||||||||
10179 | 10179 | Daniel Russell R000523 | rep | NC | 1879-03-18 | 1881-03-03 | National Greenbacker | 3 | |||||||||||||
10181 | 10181 | William Samford S000022 | rep | AL | 1879-03-18 | 1881-03-03 | Democrat | 3 | |||||||||||||
10267 | 10267 | Campbell Berry B000415 | rep | CA | 1879-03-18 | 1881-03-03 | Democrat | 3 | |||||||||||||
10277 | 10277 | John Caldwell C000036 | rep | KY | 1879-03-18 | 1881-03-03 | Democrat | 3 | |||||||||||||
10309 | 10309 | Philip Cook C000724 | rep | GA | 1879-03-18 | 1881-03-03 | Democrat | 3 | |||||||||||||
10318 | 10318 | Jordan Cravens C000885 | rep | AR | 1879-03-18 | 1881-03-03 | Democrat | 3 | |||||||||||||
10352 | 10352 | Richard Frost F000393 | rep | MO | 1879-03-18 | 1881-03-03 | Democrat | 3 | |||||||||||||
10379 | 10379 | George Hazelton H000418 | rep | WI | 1879-03-18 | 1881-03-03 | Republican | 3 | |||||||||||||
10433 | 10433 | Stephen Lindsey L000328 | rep | ME | 1879-03-18 | 1881-03-03 | Republican | 3 | |||||||||||||
10524 | 10524 | Miles Ross R000452 | rep | NJ | 1879-03-18 | 1881-03-03 | Democrat | 3 | |||||||||||||
10699 | 10699 | George Dibrell D000301 | rep | TN | 1879-03-18 | 1881-03-03 | Democrat | 3 | |||||||||||||
10853 | 10853 | Ossian Ray R000079 | rep | NH | 1879-03-18 | 1881-03-03 | Republican | 3 | |||||||||||||
10954 | 10954 | David Aiken A000061 | rep | SC | 1879-03-18 | 1881-03-03 | Democrat | 3 | |||||||||||||
11246 | 11246 | John Wait W000025 | rep | CT | 1879-03-18 | 1881-03-03 | Republican | 3 | |||||||||||||
11261 | 11261 | Olin Wellborn W000272 | rep | TX | 1879-03-18 | 1881-03-03 | Democrat | 3 | |||||||||||||
11800 | 11800 | John Kenna K000099 | rep | WV | 1879-03-18 | 1881-03-03 | Democrat | 3 | |||||||||||||
11920 | 11920 | Samuel Randall R000039 | rep | PA | 1879-03-18 | 1881-03-03 | Democrat | 3 | |||||||||||||
11947 | 11947 | Thomas Ryan R000559 | rep | KS | 1879-03-18 | 1881-03-03 | Republican | 3 | |||||||||||||
12013 | 12013 | William Washburn W000175 | rep | MN | 1879-03-18 | 1881-03-03 | Republican | 3 | |||||||||||||
13509 | 13509 | Thomas Updegraff U000019 | rep | IA | 1879-03-18 | 1881-03-03 | Republican | 3 | |||||||||||||
14833 | 14833 | Hernando Money M000854 | rep | MS | 1879-03-18 | 1881-03-03 | Democrat | 3 |
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);