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 district
This data as json, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2194 | 2194 | James Barbour B000127 | sen | VA | 1821-12-03 | 1825-12-31 | 1 | Republican | |||||||||||||
2204 | 2204 | Elijah Boardman B000577 | sen | CT | 1821-12-03 | 1823-12-31 | 1 | Republican | |||||||||||||
2229 | 2229 | James De Wolf D000295 | sen | RI | 1821-12-03 | 1825-12-31 | 1 | Republican | |||||||||||||
2237 | 2237 | William Findlay F000122 | sen | PA | 1821-12-03 | 1827-03-03 | 1 | Jackson | |||||||||||||
2304 | 2304 | William Pinkney P000362 | sen | MD | 1821-12-03 | 1823-03-03 | 1 | Republican | |||||||||||||
2523 | 2523 | Nicholas Ware W000148 | sen | GA | 1821-12-03 | 1823-03-03 | 2 | Republican | |||||||||||||
2557 | 2557 | David Barton B000212 | sen | MO | 1821-12-03 | 1825-03-03 | 3 | Republican | |||||||||||||
2831 | 2831 | John Eaton E000024 | sen | TN | 1821-12-03 | 1825-03-03 | 1 | ||||||||||||||
2916 | 2916 | James Noble N000118 | sen | IN | 1821-12-03 | 1827-03-03 | 1 | Adams | |||||||||||||
2939 | 2939 | Benjamin Ruggles R000500 | sen | OH | 1821-12-03 | 1827-03-03 | 1 | Adams | |||||||||||||
2949 | 2949 | Horatio Seymour S000268 | sen | VT | 1821-12-03 | 1827-03-03 | 1 | Adams | |||||||||||||
3977 | 3977 | Nehemiah Knight K000287 | sen | RI | 1821-12-03 | 1823-03-03 | 2 | Republican | |||||||||||||
4123 | 4123 | Martin Van Buren V000009 | sen | NY | 1821-12-03 | 1827-03-03 | 1 | Jackson | |||||||||||||
6512 | 6512 | Thomas Benton B000398 | sen | MO | 1821-12-03 | 1827-03-03 | 1 | Jackson | |||||||||||||
2197 | 2197 | James Bates B000235 | rep | AR | 1821-12-03 | 1823-03-03 | -1 | ||||||||||||||
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 | |||||||||||||
2213 | 2213 | Josiah Butler B001181 | rep | NH | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
2232 | 2232 | James Duncan D000531 | rep | PA | 1821-12-03 | 1823-03-03 | -1 | ||||||||||||||
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 | |||||||||||||
2323 | 2323 | George Robertson R000322 | rep | KY | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
2326 | 2326 | John Russ R000519 | rep | CT | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
2329 | 2329 | Solomon Sibley S000400 | rep | MI | 1821-12-03 | 1823-03-03 | -1 | ||||||||||||||
2333 | 2333 | Selah Tuthill T000438 | rep | NY | 1821-12-03 | 1823-03-03 | -1 | ||||||||||||||
2336 | 2336 | Nathaniel Upham U000024 | rep | NH | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
2375 | 2375 | Joel Abbott A000003 | rep | GA | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
2399 | 2399 | Job Durfee D000568 | rep | RI | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
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 | |||||||||||||
2409 | 2409 | William Ellis E000137 | rep | PA | 1821-12-03 | 1823-03-03 | -1 | ||||||||||||||
2421 | 2421 | Matthew Harvey H000309 | 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 | |||||||||||||
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 | |||||||||||||
2484 | 2484 | Peter Sharpe S000297 | rep | NY | 1821-12-03 | 1823-03-03 | -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 | |||||||||||||
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 | |||||||||||||
2973 | 2973 | Edward Tattnall T000051 | rep | GA | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
2991 | 2991 | Thomas Whipple W000345 | rep | NH | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
3011 | 3011 | John Wright W000764 | rep | OH | 1821-12-03 | 1823-03-03 | -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 | |||||||||||||
3562 | 3562 | Wiley Thompson T000222 | rep | GA | 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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
2220 | 2220 | Cadwallader Colden C000604 | rep | NY | 1821-12-03 | 1823-03-03 | Federalist | 1 | |||||||||||||
2225 | 2225 | Joseph Dane D000026 | rep | ME | 1821-12-03 | 1823-03-03 | Federalist | 1 | |||||||||||||
2239 | 2239 | Thomas Forrest F000281 | rep | PA | 1821-12-03 | 1823-03-03 | Federalist | 1 | |||||||||||||
2251 | 2251 | Edward Jackson J000010 | rep | VA | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
2270 | 2270 | William Milnor M000786 | rep | PA | 1821-12-03 | 1823-03-03 | Federalist | 1 | |||||||||||||
2320 | 2320 | John Rhea R000181 | rep | TN | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
2452 | 2452 | Raphael Neale N000018 | rep | MD | 1821-12-03 | 1823-03-03 | Federalist | 1 | |||||||||||||
2481 | 2481 | Thomas Ross R000456 | rep | OH | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
2580 | 2580 | Daniel Cook C000716 | rep | IL | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
2587 | 2587 | Samuel Edwards E000080 | rep | PA | 1821-12-03 | 1823-03-03 | Federalist | 1 | |||||||||||||
2700 | 2700 | Joel Poinsett P000404 | rep | SC | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
2706 | 2706 | Christopher Rankin R000054 | rep | MS | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
2717 | 2717 | John Scott S000176 | rep | MO | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
2731 | 2731 | David Trimble T000372 | rep | KY | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
2946 | 2946 | Lemuel Sawyer S000089 | rep | NC | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
3003 | 3003 | Silas Wood W000703 | rep | NY | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
3123 | 3123 | Joseph Hemphill H000470 | rep | PA | 1821-12-03 | 1823-03-03 | Federalist | 1 | |||||||||||||
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 | |||||||||||||
3437 | 3437 | Josiah Johnston J000194 | rep | LA | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
3458 | 3458 | Rollin Mallary M000079 | rep | VT | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
3491 | 3491 | Gabriel Moore M000898 | rep | AL | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
3687 | 3687 | Benjamin Gorham G000324 | rep | MA | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
4992 | 4992 | John Sergeant S000246 | rep | PA | 1821-12-03 | 1823-03-03 | Federalist | 1 | |||||||||||||
2195 | 2195 | Gideon Barstow B000195 | rep | MA | 1821-12-03 | 1823-03-03 | Republican | 2 | |||||||||||||
2228 | 2228 | William Darlington D000059 | rep | PA | 1821-12-03 | 1823-03-03 | Republican | 2 | |||||||||||||
2242 | 2242 | Samuel Gross G000496 | rep | PA | 1821-12-03 | 1823-03-03 | Republican | 2 | |||||||||||||
2243 | 2243 | Mark Harris H000248 | rep | ME | 1821-12-03 | 1823-03-03 | Republican | 2 | |||||||||||||
2264 | 2264 | William Lowndes L000483 | rep | SC | 1821-12-03 | 1823-03-03 | Republican | 2 | |||||||||||||
2340 | 2340 | Thomas Van Swearingen V000059 | rep | VA | 1821-12-03 | 1823-03-03 | Federalist | 2 | |||||||||||||
2345 | 2345 | Phineas White W000389 | rep | VT | 1821-12-03 | 1823-03-03 | Republican | 2 | |||||||||||||
2349 | 2349 | Ezekiel Whitman W000421 | rep | ME | 1821-12-03 | 1823-03-03 | Federalist | 2 | |||||||||||||
2351 | 2351 | Samuel Woodson W000729 | rep | KY | 1821-12-03 | 1823-03-03 | Republican | 2 | |||||||||||||
2385 | 2385 | Hutchins Burton B001152 | rep | NC | 1821-12-03 | 1823-03-03 | Republican | 2 | |||||||||||||
2493 | 2493 | James Stephenson S000864 | rep | VA | 1821-12-03 | 1823-03-03 | Federalist | 2 | |||||||||||||
2567 | 2567 | John Campbell C000095 | rep | OH | 1821-12-03 | 1823-03-03 | Republican | 2 | |||||||||||||
2577 | 2577 | John Cocke C000571 | rep | TN | 1821-12-03 | 1823-03-03 | Republican | 2 | |||||||||||||
2852 | 2852 | James Hamilton H000110 | rep | SC | 1821-12-03 | 1823-03-03 | Republican | 2 | |||||||||||||
3713 | 3713 | Joseph Kent K000125 | rep | MD | 1821-12-03 | 1823-03-03 | Republican | 2 | |||||||||||||
3759 | 3759 | John Morgan M000953 | rep | NY | 1821-12-03 | 1823-03-03 | Republican | 2 | |||||||||||||
4152 | 4152 | Churchill Cambreleng C000061 | rep | NY | 1821-12-03 | 1823-03-03 | Republican | 2 | |||||||||||||
2192 | 2192 | Levi Barber B000124 | rep | OH | 1821-12-03 | 1823-03-03 | Republican | 3 | |||||||||||||
2247 | 2247 | Mark Hill H000602 | rep | ME | 1821-12-03 | 1823-03-03 | Republican | 3 | |||||||||||||
2254 | 2254 | Francis Jones J000218 | rep | TN | 1821-12-03 | 1823-03-03 | Republican | 3 | |||||||||||||
2299 | 2299 | John Phillips P000310 | rep | PA | 1821-12-03 | 1823-03-03 | Federalist | 3 | |||||||||||||
2300 | 2300 | Jeremiah Pierson P000342 | rep | NY | 1821-12-03 | 1823-03-03 | Republican | 3 |
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);