legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
15 rows where district = 8 and "start" is on date 1873-12-01
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9132 | 9132 | Abram Comingo C000658 | rep | MO | 1873-12-01 | 1875-03-03 | Democrat | 8 | |||||||||||||
9231 | 9231 | John Lawson L000144 | rep | NY | 1873-12-01 | 1875-03-03 | Republican | 8 | |||||||||||||
9262 | 9262 | Alexander McDill M000406 | rep | WI | 1873-12-01 | 1875-03-03 | Republican | 8 | |||||||||||||
9298 | 9298 | David Nunn N000170 | rep | TN | 1873-12-01 | 1875-03-03 | Republican | 8 | |||||||||||||
9402 | 9402 | James Tyner T000452 | rep | IN | 1873-12-01 | 1875-03-03 | Republican | 8 | |||||||||||||
9416 | 9416 | John Williams W000519 | rep | MA | 1873-12-01 | 1875-03-03 | Republican | 8 | |||||||||||||
9454 | 9454 | Nathan Bradley B000744 | rep | MI | 1873-12-01 | 1875-03-03 | Republican | 8 | |||||||||||||
9568 | 9568 | William Lawrence L000140 | rep | OH | 1873-12-01 | 1875-03-03 | Republican | 8 | |||||||||||||
9789 | 9789 | Milton Durham D000572 | rep | KY | 1873-12-01 | 1875-03-03 | Democrat | 8 | |||||||||||||
10042 | 10042 | Hiester Clymer C000539 | rep | PA | 1873-12-01 | 1875-03-03 | Democrat | 8 | |||||||||||||
10083 | 10083 | Greenbury Fort F000288 | rep | IL | 1873-12-01 | 1875-03-03 | Republican | 8 | |||||||||||||
10451 | 10451 | James McDill M000407 | rep | IA | 1873-12-01 | 1875-03-03 | Republican | 8 | |||||||||||||
10557 | 10557 | Alexander Stephens S000854 | rep | GA | 1873-12-01 | 1875-03-03 | Democrat | 8 | |||||||||||||
10919 | 10919 | Robert Vance V000019 | rep | NC | 1873-12-01 | 1875-03-03 | Democrat | 8 | |||||||||||||
12372 | 12372 | Eppa Hunton H000999 | rep | VA | 1873-12-01 | 1875-03-03 | Democrat | 8 |
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);