legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
29 rows where party = "Adams" and state = "OH"
This data as json, copyable, CSV (advanced)
Suggested facets: start, end, class, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2569 | 2569 | John Campbell C000095 | rep | OH | 1825-12-05 | 1827-03-03 | Adams | 5 | |||||||||||||
2640 | 2640 | David Jennings J000095 | rep | OH | 1825-12-05 | 1827-03-03 | Adams | 10 | |||||||||||||
2720 | 2720 | Thomas Shannon S000289 | rep | OH | 1825-12-05 | 1827-03-03 | Adams | 10 | |||||||||||||
2795 | 2795 | Philemon Beecher B000306 | rep | OH | 1825-12-05 | 1827-03-03 | Adams | 9 | |||||||||||||
2796 | 2796 | Philemon Beecher B000306 | rep | OH | 1827-12-03 | 1829-03-03 | Adams | 9 | |||||||||||||
2829 | 2829 | John Davenport D000076 | rep | OH | 1827-12-03 | 1829-03-03 | Adams | 10 | |||||||||||||
2901 | 2901 | William McLean M000552 | rep | OH | 1825-12-05 | 1827-03-03 | Adams | 3 | |||||||||||||
2902 | 2902 | William McLean M000552 | rep | OH | 1827-12-03 | 1829-03-03 | Adams | 3 | |||||||||||||
2914 | 2914 | Francis Muhlenberg M001061 | rep | OH | 1827-12-03 | 1829-03-03 | Adams | 6 | |||||||||||||
2939 | 2939 | Benjamin Ruggles R000500 | sen | OH | 1821-12-03 | 1827-03-03 | 1 | Adams | |||||||||||||
2940 | 2940 | Benjamin Ruggles R000500 | sen | OH | 1827-12-03 | 1833-03-03 | 1 | Adams | |||||||||||||
2955 | 2955 | John Sloane S000494 | rep | OH | 1825-12-05 | 1827-03-03 | Adams | 12 | |||||||||||||
2956 | 2956 | John Sloane S000494 | rep | OH | 1827-12-03 | 1829-03-03 | Adams | 12 | |||||||||||||
2999 | 2999 | William Wilson W000619 | rep | OH | 1825-12-05 | 1827-03-03 | Adams | 8 | |||||||||||||
3009 | 3009 | John Woods W000724 | rep | OH | 1825-12-05 | 1827-03-03 | Adams | 2 | |||||||||||||
3010 | 3010 | John Woods W000724 | rep | OH | 1827-12-03 | 1829-03-03 | Adams | 2 | |||||||||||||
3013 | 3013 | John Wright W000764 | rep | OH | 1825-12-05 | 1827-03-03 | Adams | 11 | |||||||||||||
3014 | 3014 | John Wright W000764 | rep | OH | 1827-12-03 | 1829-03-03 | Adams | 11 | |||||||||||||
3017 | 3017 | Jacob Burnet B001117 | sen | OH | 1828-01-01 | 1831-03-03 | 3 | Adams | |||||||||||||
3048 | 3048 | Mordecai Bartley B000210 | rep | OH | 1825-12-05 | 1827-03-03 | Adams | 14 | |||||||||||||
3049 | 3049 | Mordecai Bartley B000210 | rep | OH | 1827-12-03 | 1829-03-03 | Adams | 14 | |||||||||||||
3356 | 3356 | William Creighton C000902 | rep | OH | 1827-12-03 | 1829-03-03 | Adams | 6 | |||||||||||||
4376 | 4376 | Elisha Whittlesey W000431 | rep | OH | 1825-12-05 | 1827-03-03 | Adams | 13 | |||||||||||||
4377 | 4377 | Elisha Whittlesey W000431 | rep | OH | 1827-12-03 | 1829-03-03 | Adams | 13 | |||||||||||||
4652 | 4652 | William Harrison H000279 | sen | OH | 1825-12-05 | 1829-03-03 | 3 | Adams | |||||||||||||
5557 | 5557 | Joseph Vance V000017 | rep | OH | 1825-12-05 | 1827-03-03 | Adams | 4 | |||||||||||||
5558 | 5558 | Joseph Vance V000017 | rep | OH | 1827-12-03 | 1829-03-03 | Adams | 4 | |||||||||||||
6156 | 6156 | Samuel Vinton V000107 | rep | OH | 1825-12-05 | 1827-03-03 | Adams | 7 | |||||||||||||
6157 | 6157 | Samuel Vinton V000107 | rep | OH | 1827-12-03 | 1829-03-03 | Adams | 7 |
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);