legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
224 rows where "start" is on date 1821-12-03 sorted by state
This data as json, copyable, CSV (advanced)
Suggested facets: type, state, end, party, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3491 | 3491 | Gabriel Moore M000898 | rep | AL | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
2197 | 2197 | James Bates B000235 | rep | AR | 1821-12-03 | 1823-03-03 | -1 | ||||||||||||||
2204 | 2204 | Elijah Boardman B000577 | sen | CT | 1821-12-03 | 1823-12-31 | 1 | Republican | |||||||||||||
2210 | 2210 | Daniel Burrows B001140 | rep | CT | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
2326 | 2326 | John Russ R000519 | rep | CT | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
2407 | 2407 | Henry Edwards E000070 | rep | CT | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
2495 | 2495 | Ansel Sterling S000868 | rep | CT | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
2497 | 2497 | Ebenezer Stoddard S000943 | rep | CT | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
3569 | 3569 | Gideon Tomlinson T000300 | rep | CT | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
3595 | 3595 | Noyes Barber B000125 | rep | CT | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
2366 | 2366 | Caesar Rodney R000377 | rep | DE | 1821-12-03 | 1822-01-24 | Republican | 0 | |||||||||||||
2755 | 2755 | Daniel Rodney R000378 | rep | DE | 1821-12-03 | 1823-03-03 | Federalist | 0 | |||||||||||||
2896 | 2896 | Louis McLane M000535 | rep | DE | 1821-12-03 | 1823-03-03 | Federalist | 0 | |||||||||||||
2245 | 2245 | Joseph Hernández H000533 | rep | FL | 1821-12-03 | 1823-03-03 | -1 | ||||||||||||||
2311 | 2311 | Robert Reid R000151 | rep | GA | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
2375 | 2375 | Joel Abbott A000003 | rep | GA | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
2523 | 2523 | Nicholas Ware W000148 | sen | GA | 1821-12-03 | 1823-03-03 | 2 | Republican | |||||||||||||
2973 | 2973 | Edward Tattnall T000051 | rep | GA | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
3562 | 3562 | Wiley Thompson T000222 | rep | GA | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
3680 | 3680 | George Gilmer G000216 | rep | GA | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
4185 | 4185 | Alfred Cuthbert C001023 | rep | GA | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
2580 | 2580 | Daniel Cook C000716 | rep | IL | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
2916 | 2916 | James Noble N000118 | sen | IN | 1821-12-03 | 1827-03-03 | 1 | Adams | |||||||||||||
3150 | 3150 | Jonathan Jennings J000097 | rep | IN | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
3402 | 3402 | William Hendricks H000494 | rep | IN | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
2206 | 2206 | James Breckinridge B000786 | rep | KY | 1821-12-03 | 1823-03-03 | Republican | 8 | |||||||||||||
2209 | 2209 | Wingfield Bullock B001054 | rep | KY | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
2273 | 2273 | Thomas Montgomery M000872 | rep | KY | 1821-12-03 | 1823-03-03 | Republican | 9 | |||||||||||||
2295 | 2295 | Anthony New N000058 | rep | KY | 1821-12-03 | 1823-03-03 | Republican | 5 | |||||||||||||
2323 | 2323 | George Robertson R000322 | rep | KY | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
2330 | 2330 | John Smith S000575 | rep | KY | 1821-12-03 | 1823-03-03 | Republican | 7 | |||||||||||||
2351 | 2351 | Samuel Woodson W000729 | rep | KY | 1821-12-03 | 1823-03-03 | Republican | 2 | |||||||||||||
2432 | 2432 | John Johnson J000154 | rep | KY | 1821-12-03 | 1823-03-03 | Republican | 3 | |||||||||||||
2642 | 2642 | Francis Johnson J000129 | rep | KY | 1821-12-03 | 1823-03-03 | Republican | 6 | |||||||||||||
2731 | 2731 | David Trimble T000372 | rep | KY | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
3921 | 3921 | Benjamin Hardin H000184 | rep | KY | 1821-12-03 | 1823-03-03 | Republican | 10 | |||||||||||||
5881 | 5881 | Thomas Metcalfe M000676 | rep | KY | 1821-12-03 | 1823-03-03 | Republican | 4 | |||||||||||||
3437 | 3437 | Josiah Johnston J000194 | rep | LA | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
2195 | 2195 | Gideon Barstow B000195 | rep | MA | 1821-12-03 | 1823-03-03 | Republican | 2 | |||||||||||||
2201 | 2201 | Lewis Bigelow B000455 | rep | MA | 1821-12-03 | 1823-03-03 | Federalist | 12 | |||||||||||||
2236 | 2236 | William Eustis E000230 | rep | MA | 1821-12-03 | 1823-03-03 | Republican | 13 | |||||||||||||
2327 | 2327 | Jonathan Russell R000531 | rep | MA | 1821-12-03 | 1823-03-03 | Republican | 11 | |||||||||||||
2417 | 2417 | Timothy Fuller F000413 | rep | MA | 1821-12-03 | 1823-03-03 | Republican | 4 | |||||||||||||
2559 | 2559 | Francis Baylies B000255 | rep | MA | 1821-12-03 | 1823-03-03 | Federalist | 10 | |||||||||||||
2635 | 2635 | Aaron Hobart H000659 | rep | MA | 1821-12-03 | 1823-03-03 | Republican | 8 | |||||||||||||
2652 | 2652 | Samuel Lathrop L000112 | rep | MA | 1821-12-03 | 1823-03-03 | Federalist | 5 | |||||||||||||
2766 | 2766 | Samuel Allen A000146 | rep | MA | 1821-12-03 | 1823-03-03 | Federalist | 6 | |||||||||||||
3091 | 3091 | Henry Dwight D000579 | rep | MA | 1821-12-03 | 1823-03-03 | Federalist | 7 | |||||||||||||
3500 | 3500 | Jeremiah Nelson N000036 | rep | MA | 1821-12-03 | 1823-03-03 | Federalist | 3 | |||||||||||||
3687 | 3687 | Benjamin Gorham G000324 | rep | MA | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
4586 | 4586 | John Reed R000121 | rep | MA | 1821-12-03 | 1823-03-03 | Federalist | 9 | |||||||||||||
2200 | 2200 | Thomas Bayly B000258 | rep | MD | 1821-12-03 | 1823-03-03 | Federalist | 8 | |||||||||||||
2222 | 2222 | Jeremiah Cosden C000792 | rep | MD | 1821-12-03 | 1823-03-03 | Republican | 6 | |||||||||||||
2286 | 2286 | John Nelson N000037 | rep | MD | 1821-12-03 | 1823-03-03 | Republican | 4 | |||||||||||||
2304 | 2304 | William Pinkney P000362 | sen | MD | 1821-12-03 | 1823-03-03 | 1 | Republican | |||||||||||||
2308 | 2308 | Philip Reed R000125 | rep | MD | 1821-12-03 | 1823-03-03 | Republican | 6 | |||||||||||||
2358 | 2358 | Robert Wright W000768 | rep | MD | 1821-12-03 | 1823-03-03 | Republican | 7 | |||||||||||||
2452 | 2452 | Raphael Neale N000018 | rep | MD | 1821-12-03 | 1823-03-03 | Federalist | 1 | |||||||||||||
2526 | 2526 | Henry Warfield W000150 | rep | MD | 1821-12-03 | 1823-03-03 | Federalist | 3 | |||||||||||||
2874 | 2874 | Peter Little L000354 | rep | MD | 1821-12-03 | 1823-03-03 | Republican | 5 | |||||||||||||
3713 | 3713 | Joseph Kent K000125 | rep | MD | 1821-12-03 | 1823-03-03 | Republican | 2 | |||||||||||||
4277 | 4277 | Isaac McKim M000516 | rep | MD | 1821-12-03 | 1823-03-03 | Republican | 5 | |||||||||||||
2225 | 2225 | Joseph Dane D000026 | rep | ME | 1821-12-03 | 1823-03-03 | Federalist | 1 | |||||||||||||
2243 | 2243 | Mark Harris H000248 | rep | ME | 1821-12-03 | 1823-03-03 | Republican | 2 | |||||||||||||
2247 | 2247 | Mark Hill H000602 | rep | ME | 1821-12-03 | 1823-03-03 | Republican | 3 | |||||||||||||
2349 | 2349 | Ezekiel Whitman W000421 | rep | ME | 1821-12-03 | 1823-03-03 | Federalist | 2 | |||||||||||||
2350 | 2350 | William Williamson W000554 | rep | ME | 1821-12-03 | 1823-03-03 | Republican | 4 | |||||||||||||
2397 | 2397 | Joshua Cushman C001020 | rep | ME | 1821-12-03 | 1823-03-03 | Republican | 6 | |||||||||||||
2630 | 2630 | Ebenezer Herrick H000538 | rep | ME | 1821-12-03 | 1823-03-03 | Republican | 5 | |||||||||||||
2657 | 2657 | Enoch Lincoln L000314 | rep | ME | 1821-12-03 | 1823-03-03 | Republican | 7 | |||||||||||||
2329 | 2329 | Solomon Sibley S000400 | rep | MI | 1821-12-03 | 1823-03-03 | -1 | ||||||||||||||
2557 | 2557 | David Barton B000212 | sen | MO | 1821-12-03 | 1825-03-03 | 3 | Republican | |||||||||||||
2717 | 2717 | John Scott S000176 | rep | MO | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
6512 | 6512 | Thomas Benton B000398 | sen | MO | 1821-12-03 | 1827-03-03 | 1 | Jackson | |||||||||||||
2706 | 2706 | Christopher Rankin R000054 | rep | MS | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
2203 | 2203 | William Blackledge B000512 | rep | NC | 1821-12-03 | 1823-03-03 | Republican | 4 | |||||||||||||
2223 | 2223 | Josiah Crudup C000953 | rep | NC | 1821-12-03 | 1823-03-03 | Republican | 8 | |||||||||||||
2343 | 2343 | Felix Walker W000050 | rep | NC | 1821-12-03 | 1823-03-03 | Republican | 12 | |||||||||||||
2385 | 2385 | Hutchins Burton B001152 | rep | NC | 1821-12-03 | 1823-03-03 | Republican | 2 | |||||||||||||
2429 | 2429 | Charles Hooks H000761 | rep | NC | 1821-12-03 | 1823-03-03 | Republican | 5 | |||||||||||||
2593 | 2593 | Weldon Edwards E000083 | rep | NC | 1821-12-03 | 1823-03-03 | Republican | 6 | |||||||||||||
2685 | 2685 | Archibald McNeill M000586 | rep | NC | 1821-12-03 | 1823-03-03 | Federalist | 7 | |||||||||||||
2881 | 2881 | John Long L000421 | rep | NC | 1821-12-03 | 1823-03-03 | Republican | 10 | |||||||||||||
2946 | 2946 | Lemuel Sawyer S000089 | rep | NC | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
3693 | 3693 | Thomas Hall H000072 | rep | NC | 1821-12-03 | 1823-03-03 | Republican | 3 | |||||||||||||
4425 | 4425 | Henry Connor C000700 | rep | NC | 1821-12-03 | 1823-03-03 | Republican | 11 | |||||||||||||
5073 | 5073 | Lewis Williams W000527 | rep | NC | 1821-12-03 | 1823-03-03 | Republican | 13 | |||||||||||||
5282 | 5282 | Romulus Saunders S000078 | rep | NC | 1821-12-03 | 1823-03-03 | Republican | 9 | |||||||||||||
2213 | 2213 | Josiah Butler B001181 | rep | NH | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
2336 | 2336 | Nathaniel Upham U000024 | rep | NH | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
2421 | 2421 | Matthew Harvey H000309 | rep | NH | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
2446 | 2446 | Aaron Matson M000247 | rep | NH | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
2462 | 2462 | William Plumer P000394 | rep | NH | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
2991 | 2991 | Thomas Whipple W000345 | rep | NH | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
2444 | 2444 | James Matlack M000245 | rep | NJ | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
2572 | 2572 | George Cassedy C000234 | rep | NJ | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
2747 | 2747 | Ephraim Bateman B000228 | rep | NJ | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
2859 | 2859 | George Holcombe H000711 | rep | NJ | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
3236 | 3236 | Samuel Swan S001088 | rep | NJ | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
3341 | 3341 | Lewis Condict C000668 | rep | NJ | 1821-12-03 | 1823-03-03 | Republican | -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);