legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
230 rows where "end" is on date 1823-03-03 sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2375 | 2375 | Joel Abbott A000003 | rep | GA | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
3287 | 3287 | Mark Alexander A000099 | rep | VA | 1821-12-03 | 1823-03-03 | Republican | 18 | |||||||||||||
2550 | 2550 | Robert Allen A000142 | rep | TN | 1821-12-03 | 1823-03-03 | Republican | 4 | |||||||||||||
2766 | 2766 | Samuel Allen A000146 | rep | MA | 1821-12-03 | 1823-03-03 | Federalist | 6 | |||||||||||||
4668 | 4668 | William Archer A000275 | rep | VA | 1821-12-03 | 1823-03-03 | Republican | 17 | |||||||||||||
2190 | 2190 | Henry Baldwin B000087 | rep | PA | 1821-12-03 | 1823-03-03 | Republican | 14 | |||||||||||||
2379 | 2379 | William Ball B000103 | rep | VA | 1821-12-03 | 1823-03-03 | Republican | 9 | |||||||||||||
2192 | 2192 | Levi Barber B000124 | rep | OH | 1821-12-03 | 1823-03-03 | Republican | 3 | |||||||||||||
3595 | 3595 | Noyes Barber B000125 | rep | CT | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
3043 | 3043 | Philip Barbour B000131 | rep | VA | 1821-12-03 | 1823-03-03 | Republican | 11 | |||||||||||||
2195 | 2195 | Gideon Barstow B000195 | rep | MA | 1821-12-03 | 1823-03-03 | Republican | 2 | |||||||||||||
2787 | 2787 | Burwell Bassett B000224 | rep | VA | 1821-12-03 | 1823-03-03 | Republican | 13 | |||||||||||||
2747 | 2747 | Ephraim Bateman B000228 | rep | NJ | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
2197 | 2197 | James Bates B000235 | rep | AR | 1821-12-03 | 1823-03-03 | -1 | ||||||||||||||
2559 | 2559 | Francis Baylies B000255 | rep | MA | 1821-12-03 | 1823-03-03 | Federalist | 10 | |||||||||||||
2200 | 2200 | Thomas Bayly B000258 | rep | MD | 1821-12-03 | 1823-03-03 | Federalist | 8 | |||||||||||||
2201 | 2201 | Lewis Bigelow B000455 | rep | MA | 1821-12-03 | 1823-03-03 | Federalist | 12 | |||||||||||||
2203 | 2203 | William Blackledge B000512 | rep | NC | 1821-12-03 | 1823-03-03 | Republican | 4 | |||||||||||||
3615 | 3615 | James Blair B000526 | rep | SC | 1821-12-03 | 1823-03-03 | Republican | 9 | |||||||||||||
2205 | 2205 | Charles Borland B000641 | rep | NY | 1821-12-03 | 1823-03-03 | Republican | 6 | |||||||||||||
2206 | 2206 | James Breckinridge B000786 | rep | KY | 1821-12-03 | 1823-03-03 | Republican | 8 | |||||||||||||
2382 | 2382 | John Brown B000926 | rep | PA | 1821-12-03 | 1823-03-03 | Republican | 9 | |||||||||||||
2208 | 2208 | Henry Bryan B000986 | rep | TN | 1821-12-03 | 1823-03-03 | Republican | 6 | |||||||||||||
6963 | 6963 | James Buchanan B001005 | rep | PA | 1821-12-03 | 1823-03-03 | Federalist | 3 | |||||||||||||
2209 | 2209 | Wingfield Bullock B001054 | rep | KY | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
2210 | 2210 | Daniel Burrows B001140 | rep | CT | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
2385 | 2385 | Hutchins Burton B001152 | rep | NC | 1821-12-03 | 1823-03-03 | Republican | 2 | |||||||||||||
2213 | 2213 | Josiah Butler B001181 | rep | NH | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
4152 | 4152 | Churchill Cambreleng C000061 | rep | NY | 1821-12-03 | 1823-03-03 | Republican | 2 | |||||||||||||
2567 | 2567 | John Campbell C000095 | rep | OH | 1821-12-03 | 1823-03-03 | Republican | 2 | |||||||||||||
2214 | 2214 | Samuel Campbell C000099 | rep | NY | 1821-12-03 | 1823-03-03 | Republican | 15 | |||||||||||||
2218 | 2218 | Newton Cannon C000123 | rep | TN | 1821-12-03 | 1823-03-03 | Republican | 5 | |||||||||||||
2815 | 2815 | John Carter C000197 | rep | SC | 1821-12-03 | 1823-03-03 | Republican | 9 | |||||||||||||
2572 | 2572 | George Cassedy C000234 | rep | NJ | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
2219 | 2219 | David Chambers C000281 | rep | OH | 1821-12-03 | 1823-03-03 | Republican | 4 | |||||||||||||
2392 | 2392 | John Chandler C000291 | sen | ME | 1820-01-01 | 1823-03-03 | 2 | Republican | |||||||||||||
2577 | 2577 | John Cocke C000571 | rep | TN | 1821-12-03 | 1823-03-03 | Republican | 2 | |||||||||||||
2220 | 2220 | Cadwallader Colden C000604 | rep | NY | 1821-12-03 | 1823-03-03 | Federalist | 1 | |||||||||||||
3341 | 3341 | Lewis Condict C000668 | rep | NJ | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
2221 | 2221 | Alfred Conkling C000679 | rep | NY | 1821-12-03 | 1823-03-03 | Republican | 14 | |||||||||||||
4425 | 4425 | Henry Connor C000700 | rep | NC | 1821-12-03 | 1823-03-03 | Republican | 11 | |||||||||||||
2580 | 2580 | Daniel Cook C000716 | rep | IL | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
2222 | 2222 | Jeremiah Cosden C000792 | rep | MD | 1821-12-03 | 1823-03-03 | Republican | 6 | |||||||||||||
5097 | 5097 | Samuel Crafts C000851 | rep | VT | 1821-12-03 | 1823-03-03 | Republican | 5 | |||||||||||||
2223 | 2223 | Josiah Crudup C000953 | rep | NC | 1821-12-03 | 1823-03-03 | Republican | 8 | |||||||||||||
2397 | 2397 | Joshua Cushman C001020 | rep | ME | 1821-12-03 | 1823-03-03 | Republican | 6 | |||||||||||||
4185 | 4185 | Alfred Cuthbert C001023 | rep | GA | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
2225 | 2225 | Joseph Dane D000026 | rep | ME | 1821-12-03 | 1823-03-03 | Federalist | 1 | |||||||||||||
2228 | 2228 | William Darlington D000059 | rep | PA | 1821-12-03 | 1823-03-03 | Republican | 2 | |||||||||||||
2231 | 2231 | George Denison D000238 | rep | PA | 1821-12-03 | 1823-03-03 | Republican | 10 | |||||||||||||
3079 | 3079 | Mahlon Dickerson D000308 | sen | NJ | 1817-12-01 | 1823-03-03 | 2 | Republican | |||||||||||||
3083 | 3083 | John Dickinson D000322 | rep | NY | 1821-12-03 | 1823-03-03 | Federalist | 10 | |||||||||||||
2232 | 2232 | James Duncan D000531 | rep | PA | 1821-12-03 | 1823-03-03 | -1 | ||||||||||||||
2399 | 2399 | Job Durfee D000568 | rep | RI | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
3091 | 3091 | Henry Dwight D000579 | rep | MA | 1821-12-03 | 1823-03-03 | Federalist | 7 | |||||||||||||
2404 | 2404 | Samuel Eddy E000040 | rep | RI | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
2407 | 2407 | Henry Edwards E000070 | rep | CT | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
2587 | 2587 | Samuel Edwards E000080 | rep | PA | 1821-12-03 | 1823-03-03 | Federalist | 1 | |||||||||||||
2593 | 2593 | Weldon Edwards E000083 | rep | NC | 1821-12-03 | 1823-03-03 | Republican | 6 | |||||||||||||
2409 | 2409 | William Ellis E000137 | rep | PA | 1821-12-03 | 1823-03-03 | -1 | ||||||||||||||
2236 | 2236 | William Eustis E000230 | rep | MA | 1821-12-03 | 1823-03-03 | Republican | 13 | |||||||||||||
2597 | 2597 | Patrick Farrelly F000032 | rep | PA | 1821-12-03 | 1823-03-03 | Republican | 15 | |||||||||||||
2600 | 2600 | John Findlay F000120 | rep | PA | 1821-12-03 | 1823-03-03 | Republican | 5 | |||||||||||||
2839 | 2839 | John Floyd F000221 | rep | VA | 1821-12-03 | 1823-03-03 | Republican | 5 | |||||||||||||
2239 | 2239 | Thomas Forrest F000281 | rep | PA | 1821-12-03 | 1823-03-03 | Federalist | 1 | |||||||||||||
2412 | 2412 | Walter Forward F000291 | rep | PA | 1821-12-03 | 1823-03-03 | Republican | 14 | |||||||||||||
2417 | 2417 | Timothy Fuller F000413 | rep | MA | 1821-12-03 | 1823-03-03 | Republican | 4 | |||||||||||||
2611 | 2611 | Robert Garnett G000077 | rep | VA | 1821-12-03 | 1823-03-03 | Republican | 12 | |||||||||||||
2240 | 2240 | John Gebhard G000114 | rep | NY | 1821-12-03 | 1823-03-03 | Federalist | 13 | |||||||||||||
3680 | 3680 | George Gilmer G000216 | rep | GA | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
2616 | 2616 | Joseph Gist G000227 | rep | SC | 1821-12-03 | 1823-03-03 | Republican | 8 | |||||||||||||
3687 | 3687 | Benjamin Gorham G000324 | rep | MA | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
2619 | 2619 | Andrew Govan G000346 | rep | SC | 1821-12-03 | 1823-03-03 | Republican | 4 | |||||||||||||
2242 | 2242 | Samuel Gross G000496 | rep | PA | 1821-12-03 | 1823-03-03 | Republican | 2 | |||||||||||||
3693 | 3693 | Thomas Hall H000072 | rep | NC | 1821-12-03 | 1823-03-03 | Republican | 3 | |||||||||||||
2852 | 2852 | James Hamilton H000110 | rep | SC | 1821-12-03 | 1823-03-03 | Republican | 2 | |||||||||||||
3921 | 3921 | Benjamin Hardin H000184 | rep | KY | 1821-12-03 | 1823-03-03 | Republican | 10 | |||||||||||||
2243 | 2243 | Mark Harris H000248 | rep | ME | 1821-12-03 | 1823-03-03 | Republican | 2 | |||||||||||||
2421 | 2421 | Matthew Harvey H000309 | rep | NH | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
2244 | 2244 | James Hawkes H000366 | rep | NY | 1821-12-03 | 1823-03-03 | Republican | 15 | |||||||||||||
3123 | 3123 | Joseph Hemphill H000470 | rep | PA | 1821-12-03 | 1823-03-03 | Federalist | 1 | |||||||||||||
3402 | 3402 | William Hendricks H000494 | rep | IN | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
2245 | 2245 | Joseph Hernández H000533 | rep | FL | 1821-12-03 | 1823-03-03 | -1 | ||||||||||||||
2630 | 2630 | Ebenezer Herrick H000538 | rep | ME | 1821-12-03 | 1823-03-03 | Republican | 5 | |||||||||||||
2247 | 2247 | Mark Hill H000602 | rep | ME | 1821-12-03 | 1823-03-03 | Republican | 3 | |||||||||||||
2635 | 2635 | Aaron Hobart H000659 | rep | MA | 1821-12-03 | 1823-03-03 | Republican | 8 | |||||||||||||
2859 | 2859 | George Holcombe H000711 | rep | NJ | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
2429 | 2429 | Charles Hooks H000761 | rep | NC | 1821-12-03 | 1823-03-03 | Republican | 5 | |||||||||||||
2249 | 2249 | Thomas Hubbard H000890 | rep | NY | 1821-12-03 | 1823-03-03 | Republican | 17 | |||||||||||||
3140 | 3140 | Samuel Ingham I000022 | rep | PA | 1821-12-03 | 1823-03-03 | Republican | 6 | |||||||||||||
2251 | 2251 | Edward Jackson J000010 | rep | VA | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
3150 | 3150 | Jonathan Jennings J000097 | rep | IN | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
2642 | 2642 | Francis Johnson J000129 | rep | KY | 1821-12-03 | 1823-03-03 | Republican | 6 | |||||||||||||
5342 | 5342 | Henry Johnson J000137 | sen | LA | 1818-01-01 | 1823-03-03 | 2 | Republican | |||||||||||||
2432 | 2432 | John Johnson J000154 | rep | KY | 1821-12-03 | 1823-03-03 | Republican | 3 | |||||||||||||
3961 | 3961 | Richard Johnson J000170 | sen | KY | 1819-12-06 | 1823-03-03 | 2 | Republican | |||||||||||||
3437 | 3437 | Josiah Johnston J000194 | rep | LA | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
2254 | 2254 | Francis Jones J000218 | rep | TN | 1821-12-03 | 1823-03-03 | Republican | 3 | |||||||||||||
2256 | 2256 | James Jones J000228 | rep | VA | 1821-12-03 | 1823-03-03 | Republican | 19 | |||||||||||||
3713 | 3713 | Joseph Kent K000125 | rep | MD | 1821-12-03 | 1823-03-03 | Republican | 2 |
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);