legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
212 rows where "start" is on date 1817-12-01 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: type, state, end, party, district, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7722 | 7722 | John Crittenden C000912 | sen | KY | 1817-12-01 | 1819-03-03 | 2 | Republican | |||||||||||||
5933 | 5933 | Henry Clay C000482 | rep | KY | 1817-12-01 | 1819-03-03 | Republican | 2 | |||||||||||||
5636 | 5636 | John Calhoun C000044 | rep | SC | 1817-12-01 | 1819-03-03 | Democratic Republican | -1 | |||||||||||||
5095 | 5095 | Samuel Crafts C000851 | rep | VT | 1817-12-01 | 1819-03-03 | Republican | 0 | |||||||||||||
5071 | 5071 | Lewis Williams W000527 | rep | NC | 1817-12-01 | 1819-03-03 | Republican | 13 | |||||||||||||
4990 | 4990 | John Sergeant S000246 | rep | PA | 1817-12-01 | 1819-03-03 | Federalist | 1 | |||||||||||||
4654 | 4654 | John Tyler T000450 | rep | VA | 1817-12-01 | 1819-03-03 | Republican | 23 | |||||||||||||
4651 | 4651 | William Harrison H000279 | rep | OH | 1817-12-01 | 1819-03-03 | Republican | 1 | |||||||||||||
4546 | 4546 | Charles Mercer M000642 | rep | VA | 1817-12-01 | 1819-03-03 | Federalist | 8 | |||||||||||||
4468 | 4468 | Charles Fisher F000144 | rep | NC | 1817-12-01 | 1819-03-03 | Republican | 10 | |||||||||||||
4308 | 4308 | John Palmer P000041 | rep | NY | 1817-12-01 | 1819-03-03 | Republican | 12 | |||||||||||||
3960 | 3960 | Richard Johnson J000170 | rep | KY | 1817-12-01 | 1819-03-03 | Republican | 3 | |||||||||||||
3691 | 3691 | Thomas Hall H000072 | rep | NC | 1817-12-01 | 1819-03-03 | Republican | 3 | |||||||||||||
3554 | 3554 | John Taylor T000091 | rep | NY | 1817-12-01 | 1819-03-03 | Republican | 11 | |||||||||||||
3512 | 3512 | Thomas Newton N000078 | rep | VA | 1817-12-01 | 1819-03-03 | Republican | 21 | |||||||||||||
3498 | 3498 | Jeremiah Nelson N000036 | rep | MA | 1817-12-01 | 1819-03-03 | Federalist | 3 | |||||||||||||
3481 | 3481 | Stephen Miller M000755 | rep | SC | 1817-12-01 | 1819-03-03 | Republican | 9 | |||||||||||||
3472 | 3472 | William McCoy M000377 | rep | VA | 1817-12-01 | 1819-03-03 | Republican | 4 | |||||||||||||
3400 | 3400 | William Hendricks H000494 | rep | IN | 1817-12-01 | 1819-03-03 | Republican | 1 | |||||||||||||
3385 | 3385 | John Forsyth F000284 | rep | GA | 1817-12-01 | 1818-11-23 | Republican | -1 | |||||||||||||
3282 | 3282 | George Poindexter P000402 | rep | MS | 1817-12-01 | 1819-03-03 | Republican | 1 | |||||||||||||
3257 | 3257 | Starling Tucker T000402 | rep | SC | 1817-12-01 | 1819-03-03 | Republican | 5 | |||||||||||||
3225 | 3225 | Henry Storrs S000976 | rep | NY | 1817-12-01 | 1819-03-03 | Federalist | 16 | |||||||||||||
3210 | 3210 | Alexander Smyth S000646 | rep | VA | 1817-12-01 | 1819-03-03 | Republican | 6 | |||||||||||||
3206 | 3206 | Nathaniel Silsbee S000411 | rep | MA | 1817-12-01 | 1819-03-03 | Republican | 2 | |||||||||||||
3176 | 3176 | John McLean M000550 | rep | IL | 1817-12-01 | 1819-03-03 | Republican | 1 | |||||||||||||
3139 | 3139 | Samuel Ingham I000022 | rep | PA | 1817-12-01 | 1819-03-03 | Republican | 6 | |||||||||||||
3132 | 3132 | John Holmes H000739 | rep | MA | 1817-12-01 | 1819-03-03 | Democratic Republican | 14 | |||||||||||||
3079 | 3079 | Mahlon Dickerson D000308 | sen | NJ | 1817-12-01 | 1823-03-03 | 2 | Republican | |||||||||||||
3041 | 3041 | Philip Barbour B000131 | rep | VA | 1817-12-01 | 1819-03-03 | Republican | 11 | |||||||||||||
2965 | 2965 | Samuel Smith S000609 | rep | MD | 1817-12-01 | 1819-03-03 | Republican | 5 | |||||||||||||
2944 | 2944 | Lemuel Sawyer S000089 | rep | NC | 1817-12-01 | 1819-03-03 | Republican | 1 | |||||||||||||
2929 | 2929 | Albion Parris P000079 | rep | MA | 1817-12-01 | 1819-03-03 | Republican | 20 | |||||||||||||
2894 | 2894 | Louis McLane M000535 | rep | DE | 1817-12-01 | 1819-03-03 | Federalist | 0 | |||||||||||||
2872 | 2872 | Peter Little L000354 | rep | MD | 1817-12-01 | 1819-03-03 | Republican | 5 | |||||||||||||
2837 | 2837 | John Floyd F000221 | rep | VA | 1817-12-01 | 1819-03-03 | Republican | 5 | |||||||||||||
2792 | 2792 | Philemon Beecher B000306 | rep | OH | 1817-12-01 | 1819-03-03 | Republican | 5 | |||||||||||||
2786 | 2786 | Burwell Bassett B000224 | rep | VA | 1817-12-01 | 1819-03-03 | Republican | 13 | |||||||||||||
2764 | 2764 | Samuel Allen A000146 | rep | MA | 1817-12-01 | 1819-03-03 | Federalist | 6 | |||||||||||||
2745 | 2745 | Ephraim Bateman B000228 | rep | NJ | 1817-12-01 | 1819-03-03 | Republican | -1 | |||||||||||||
2729 | 2729 | David Trimble T000372 | rep | KY | 1817-12-01 | 1819-03-03 | Republican | 1 | |||||||||||||
2715 | 2715 | John Scott S000176 | rep | MO | 1817-12-01 | 1819-03-03 | -1 | ||||||||||||||
2695 | 2695 | George Peter P000250 | rep | MD | 1817-12-01 | 1819-03-03 | Federalist | 3 | |||||||||||||
2655 | 2655 | Enoch Lincoln L000314 | rep | MA | 1817-12-01 | 1819-03-03 | Republican | 20 | |||||||||||||
2609 | 2609 | Robert Garnett G000077 | rep | VA | 1817-12-01 | 1819-03-03 | Republican | 12 | |||||||||||||
2591 | 2591 | Weldon Edwards E000083 | rep | NC | 1817-12-01 | 1819-03-03 | Republican | 6 | |||||||||||||
2565 | 2565 | John Campbell C000095 | rep | OH | 1817-12-01 | 1819-03-03 | Republican | 2 | |||||||||||||
2542 | 2542 | Thomas Cobb C000553 | rep | GA | 1817-12-01 | 1819-03-03 | Republican | -1 | |||||||||||||
2537 | 2537 | Thomas Williams W000540 | sen | MS | 1817-12-01 | 1823-03-03 | 2 | Republican | |||||||||||||
2532 | 2532 | Isaac Williams W000505 | rep | NY | 1817-12-01 | 1819-03-03 | Republican | 15 | |||||||||||||
2518 | 2518 | Nicholas Van Dyke V000037 | sen | DE | 1817-12-01 | 1823-03-03 | 2 | Federalist | |||||||||||||
2476 | 2476 | Thomas Rogers R000403 | rep | PA | 1817-12-01 | 1819-03-03 | Republican | 6 | |||||||||||||
2468 | 2468 | Charles Rich R000207 | rep | VT | 1817-12-01 | 1819-03-03 | Republican | 0 | |||||||||||||
2457 | 2457 | Thomas Patterson P000128 | rep | PA | 1817-12-01 | 1819-03-03 | Republican | 12 | |||||||||||||
2440 | 2440 | Arthur Livermore L000362 | rep | NH | 1817-12-01 | 1819-03-03 | Republican | -1 | |||||||||||||
2424 | 2424 | John Herkimer H000529 | rep | NY | 1817-12-01 | 1819-03-03 | Republican | 14 | |||||||||||||
2415 | 2415 | Timothy Fuller F000413 | rep | MA | 1817-12-01 | 1819-03-03 | Republican | 4 | |||||||||||||
2377 | 2377 | William Ball B000103 | rep | VA | 1817-12-01 | 1819-03-03 | Republican | 9 | |||||||||||||
2373 | 2373 | Joel Abbott A000003 | rep | GA | 1817-12-01 | 1819-03-03 | Republican | -1 | |||||||||||||
2347 | 2347 | Ezekiel Whitman W000421 | rep | MA | 1817-12-01 | 1819-03-03 | Federalist | 15 | |||||||||||||
2341 | 2341 | Felix Walker W000050 | rep | NC | 1817-12-01 | 1819-03-03 | Republican | 12 | |||||||||||||
2334 | 2334 | Nathaniel Upham U000024 | rep | NH | 1817-12-01 | 1819-03-03 | Republican | -1 | |||||||||||||
2321 | 2321 | George Robertson R000322 | rep | KY | 1817-12-01 | 1819-03-03 | Republican | 7 | |||||||||||||
2318 | 2318 | John Rhea R000181 | rep | TN | 1817-12-01 | 1819-03-03 | Republican | 1 | |||||||||||||
2309 | 2309 | Robert Reid R000151 | rep | GA | 1817-12-01 | 1819-03-03 | Republican | -1 | |||||||||||||
2307 | 2307 | Philip Reed R000125 | rep | MD | 1817-12-01 | 1819-03-03 | Republican | 6 | |||||||||||||
2294 | 2294 | Anthony New N000058 | rep | KY | 1817-12-01 | 1819-03-03 | Republican | 5 | |||||||||||||
2283 | 2283 | Hugh Nelson N000035 | rep | VA | 1817-12-01 | 1819-03-03 | Republican | 22 | |||||||||||||
2274 | 2274 | Samuel Moore M000916 | rep | PA | 1817-12-01 | 1819-03-03 | Republican | 6 | |||||||||||||
2262 | 2262 | William Lowndes L000483 | rep | SC | 1817-12-01 | 1819-03-03 | Republican | 2 | |||||||||||||
2252 | 2252 | Francis Jones J000218 | rep | TN | 1817-12-01 | 1819-03-03 | Republican | 3 | |||||||||||||
2248 | 2248 | Thomas Hubbard H000890 | rep | NY | 1817-12-01 | 1819-03-03 | Republican | 17 | |||||||||||||
2211 | 2211 | Josiah Butler B001181 | rep | NH | 1817-12-01 | 1819-03-03 | Republican | -1 | |||||||||||||
2198 | 2198 | Thomas Bayly B000258 | rep | MD | 1817-12-01 | 1819-03-03 | Federalist | 8 | |||||||||||||
2191 | 2191 | Levi Barber B000124 | rep | OH | 1817-12-01 | 1819-03-03 | Republican | 3 | |||||||||||||
2188 | 2188 | Henry Baldwin B000087 | rep | PA | 1817-12-01 | 1819-03-03 | Republican | 14 | |||||||||||||
2183 | 2183 | Elijah Mills M000774 | rep | MA | 1817-12-01 | 1819-03-03 | Federalist | 5 | |||||||||||||
2172 | 2172 | Peter Wendover W000293 | rep | NY | 1817-12-01 | 1819-03-03 | Republican | 2 | |||||||||||||
2169 | 2169 | James Wallace W000078 | rep | PA | 1817-12-01 | 1819-03-03 | Republican | 3 | |||||||||||||
2164 | 2164 | David Walker W000048 | rep | KY | 1817-12-01 | 1819-03-03 | Republican | 6 | |||||||||||||
2161 | 2161 | Caleb Tompkins T000303 | rep | NY | 1817-12-01 | 1819-03-03 | Republican | 3 | |||||||||||||
2159 | 2159 | William Terrell T000132 | rep | GA | 1817-12-01 | 1819-03-03 | Republican | -1 | |||||||||||||
2155 | 2155 | Christian Tarr T000042 | rep | PA | 1817-12-01 | 1819-03-03 | Republican | 13 | |||||||||||||
2153 | 2153 | George Strother S001023 | rep | VA | 1817-12-01 | 1819-03-03 | Republican | 10 | |||||||||||||
2146 | 2146 | Henry Southard S000685 | rep | NJ | 1817-12-01 | 1819-03-03 | Republican | -1 | |||||||||||||
2138 | 2138 | James Smith S000559 | rep | NC | 1817-12-01 | 1819-03-03 | Republican | 8 | |||||||||||||
2135 | 2135 | Ballard Smith S000516 | rep | VA | 1817-12-01 | 1819-03-03 | Republican | 7 | |||||||||||||
2132 | 2132 | Jesse Slocumb S000497 | rep | NC | 1817-12-01 | 1819-03-03 | Federalist | 4 | |||||||||||||
2130 | 2130 | Eldred Simkins S000414 | rep | SC | 1817-12-01 | 1819-03-03 | Republican | 6 | |||||||||||||
2128 | 2128 | Henry Shaw S000307 | rep | MA | 1817-12-01 | 1819-03-03 | Republican | 7 | |||||||||||||
2126 | 2126 | Thomas Settle S000254 | rep | NC | 1817-12-01 | 1819-03-03 | Republican | 9 | |||||||||||||
2124 | 2124 | Zabdiel Sampson S000026 | rep | MA | 1817-12-01 | 1819-03-03 | Republican | 8 | |||||||||||||
2118 | 2118 | Samuel Ringgold R000263 | rep | MD | 1817-12-01 | 1819-03-03 | Republican | 4 | |||||||||||||
2112 | 2112 | Mark Richards R000217 | rep | VT | 1817-12-01 | 1819-03-03 | Republican | 0 | |||||||||||||
2110 | 2110 | Tunstall Quarles Q000005 | rep | KY | 1817-12-01 | 1819-03-03 | Republican | 9 | |||||||||||||
2108 | 2108 | James Pleasants P000386 | rep | VA | 1817-12-01 | 1819-03-03 | Republican | 17 | |||||||||||||
2103 | 2103 | James Pindall P000358 | rep | VA | 1817-12-01 | 1819-03-03 | Federalist | 1 | |||||||||||||
2096 | 2096 | John Parrott P000084 | rep | NH | 1817-12-01 | 1819-03-03 | Republican | -1 | |||||||||||||
2091 | 2091 | John Murray M001109 | rep | PA | 1817-12-01 | 1819-03-03 | Republican | 10 | |||||||||||||
2089 | 2089 | Jonathan Moseley M001023 | rep | CT | 1817-12-01 | 1819-03-03 | Federalist | -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);