legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
23 rows where district = 4 and "end" is on date 1849-03-03
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5632 | 5632 | Aylette Buckner B001032 | rep | KY | 1847-12-06 | 1849-03-03 | Whig | 4 | |||||||||||||
5642 | 5642 | Richard Canby C000108 | rep | OH | 1847-12-06 | 1849-03-03 | Whig | 4 | |||||||||||||
5648 | 5648 | Franklin Clark C000432 | rep | ME | 1847-12-06 | 1849-03-03 | Democrat | 4 | |||||||||||||
5719 | 5719 | Hugh Hill H000592 | rep | TN | 1847-12-06 | 1849-03-03 | Democrat | 4 | |||||||||||||
5737 | 5737 | Charles Ingersoll I000015 | rep | PA | 1847-12-06 | 1849-03-03 | Democrat | 4 | |||||||||||||
5749 | 5749 | James Johnson J000146 | rep | NH | 1847-12-06 | 1849-03-03 | Democrat | 4 | |||||||||||||
5799 | 5799 | John Palfrey P000033 | rep | MA | 1847-12-06 | 1849-03-03 | Whig | 4 | |||||||||||||
5820 | 5820 | Alexander Sims S000438 | rep | SC | 1847-12-06 | 1849-03-03 | Democrat | 4 | |||||||||||||
5824 | 5824 | Caleb Smith S000519 | rep | IN | 1847-12-06 | 1849-03-03 | Whig | 4 | |||||||||||||
5994 | 5994 | Hugh Haralson H000178 | rep | GA | 1847-12-06 | 1849-03-03 | Democrat | 4 | |||||||||||||
6018 | 6018 | Samuel Inge I000013 | rep | AL | 1847-12-06 | 1849-03-03 | Democrat | 4 | |||||||||||||
6072 | 6072 | Isaac Morse M001011 | rep | LA | 1847-12-06 | 1849-03-03 | Democrat | 4 | |||||||||||||
6089 | 6089 | Lucius Peck P000178 | rep | VT | 1847-12-06 | 1849-03-03 | Democrat | 4 | |||||||||||||
6121 | 6121 | Augustine Shepperd S000338 | rep | NC | 1847-12-06 | 1849-03-03 | Whig | 4 | |||||||||||||
6128 | 6128 | Truman Smith S000621 | rep | CT | 1847-12-06 | 1849-03-03 | Whig | 4 | |||||||||||||
6153 | 6153 | John Van Dyke V000035 | rep | NJ | 1847-12-06 | 1849-03-03 | Whig | 4 | |||||||||||||
6315 | 6315 | Willard Hall H000077 | rep | MO | 1847-12-06 | 1849-03-03 | Democrat | 4 | |||||||||||||
7295 | 7295 | Thomas Bocock B000582 | rep | VA | 1847-12-06 | 1849-03-03 | Democrat | 4 | |||||||||||||
7323 | 7323 | Albert Brown B000900 | rep | MS | 1847-12-06 | 1849-03-03 | Democrat | 4 | |||||||||||||
7490 | 7490 | William Maclay M000032 | rep | NY | 1847-12-06 | 1849-03-03 | Democrat | 4 | |||||||||||||
7496 | 7496 | John McQueen M000595 | rep | SC | 1847-12-06 | 1849-03-03 | Democrat | 4 | |||||||||||||
8226 | 8226 | John Wentworth W000295 | rep | IL | 1847-12-06 | 1849-03-03 | Democrat | 4 | |||||||||||||
10457 | 10457 | Robert McLane M000537 | rep | MD | 1847-12-06 | 1849-03-03 | Democrat | 4 |
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);