legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
18 rows where district = "-1" and "end" is on date 1847-03-03
This data as json, copyable, CSV (advanced)
Suggested facets: state, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5405 | 5405 | John Dawson D000152 | rep | LA | 1845-12-01 | 1847-03-03 | Democrat | -1 | |||||||||||||
5415 | 5415 | Henry Ellett E000116 | rep | MS | 1845-12-01 | 1847-03-03 | Democrat | -1 | |||||||||||||
5436 | 5436 | Serranus Hastings H000330 | rep | IA | 1845-12-01 | 1847-03-03 | Democrat | -1 | |||||||||||||
5473 | 5473 | Morgan Martin M000196 | rep | WI | 1845-12-01 | 1847-03-03 | Democrat | -1 | |||||||||||||
5478 | 5478 | William McDaniel M000400 | rep | MO | 1845-12-01 | 1847-03-03 | Democrat | -1 | |||||||||||||
5487 | 5487 | Mace Moulton M001046 | rep | NH | 1845-12-01 | 1847-03-03 | Democrat | -1 | |||||||||||||
5503 | 5503 | Sterling Price P000531 | rep | MO | 1845-12-01 | 1847-03-03 | Democrat | -1 | |||||||||||||
5507 | 5507 | James Relfe R000160 | rep | MO | 1845-12-01 | 1847-03-03 | Democrat | -1 | |||||||||||||
5512 | 5512 | Robert Roberts R000315 | rep | MS | 1845-12-01 | 1847-03-03 | Democrat | -1 | |||||||||||||
5518 | 5518 | Leonard Sims S000440 | rep | MO | 1845-12-01 | 1847-03-03 | Democrat | -1 | |||||||||||||
5748 | 5748 | James Johnson J000146 | rep | NH | 1845-12-01 | 1847-03-03 | Democrat | -1 | |||||||||||||
5909 | 5909 | James Bowlin B000701 | rep | MO | 1845-12-01 | 1847-03-03 | Democrat | -1 | |||||||||||||
6040 | 6040 | Shepherd Leffler L000215 | rep | IA | 1845-12-01 | 1847-03-03 | Democrat | -1 | |||||||||||||
6083 | 6083 | Moses Norris N000140 | rep | NH | 1845-12-01 | 1847-03-03 | Democrat | -1 | |||||||||||||
6140 | 6140 | Jacob Thompson T000203 | rep | MS | 1845-12-01 | 1847-03-03 | Democrat | -1 | |||||||||||||
6466 | 6466 | Stephen Adams A000048 | rep | MS | 1845-12-01 | 1847-03-03 | Democrat | -1 | |||||||||||||
7020 | 7020 | Jefferson Davis D000113 | rep | MS | 1845-12-01 | 1847-03-03 | Democrat | -1 | |||||||||||||
7827 | 7827 | John Phelps P000296 | rep | MO | 1845-12-01 | 1847-03-03 | Democrat | -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);