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 how
This data as json, copyable, CSV (advanced)
Suggested facets: state, party, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1790 | 1790 | Montfort Stokes S000949 | sen | NC | 1817-03-04 | 1823-03-03 | 2 | Republican | |||||||||||||
1880 | 1880 | David Morril M000966 | sen | NH | 1817-12-01 | 1823-03-03 | 2 | Republican | |||||||||||||
1890 | 1890 | Harrison Otis O000127 | sen | MA | 1817-12-01 | 1823-03-03 | 2 | Federalist | |||||||||||||
1949 | 1949 | John Williams W000516 | sen | TN | 1817-12-01 | 1823-03-03 | 2 | Republican | |||||||||||||
2109 | 2109 | James Pleasants P000386 | sen | VA | 1819-12-06 | 1823-03-03 | 2 | Republican | |||||||||||||
2167 | 2167 | John Walker W000061 | sen | AL | 1819-12-06 | 1823-03-03 | 3 | Republican | |||||||||||||
2190 | 2190 | Henry Baldwin B000087 | rep | PA | 1821-12-03 | 1823-03-03 | Republican | 14 | |||||||||||||
2192 | 2192 | Levi Barber B000124 | rep | OH | 1821-12-03 | 1823-03-03 | Republican | 3 | |||||||||||||
2195 | 2195 | Gideon Barstow B000195 | rep | MA | 1821-12-03 | 1823-03-03 | Republican | 2 | |||||||||||||
2197 | 2197 | James Bates B000235 | rep | AR | 1821-12-03 | 1823-03-03 | -1 | ||||||||||||||
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 | |||||||||||||
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 | |||||||||||||
2208 | 2208 | Henry Bryan B000986 | rep | TN | 1821-12-03 | 1823-03-03 | Republican | 6 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
2219 | 2219 | David Chambers C000281 | rep | OH | 1821-12-03 | 1823-03-03 | Republican | 4 | |||||||||||||
2220 | 2220 | Cadwallader Colden C000604 | rep | NY | 1821-12-03 | 1823-03-03 | Federalist | 1 | |||||||||||||
2221 | 2221 | Alfred Conkling C000679 | rep | NY | 1821-12-03 | 1823-03-03 | Republican | 14 | |||||||||||||
2222 | 2222 | Jeremiah Cosden C000792 | rep | MD | 1821-12-03 | 1823-03-03 | Republican | 6 | |||||||||||||
2223 | 2223 | Josiah Crudup C000953 | rep | NC | 1821-12-03 | 1823-03-03 | Republican | 8 | |||||||||||||
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 | |||||||||||||
2232 | 2232 | James Duncan D000531 | rep | PA | 1821-12-03 | 1823-03-03 | -1 | ||||||||||||||
2236 | 2236 | William Eustis E000230 | rep | MA | 1821-12-03 | 1823-03-03 | Republican | 13 | |||||||||||||
2239 | 2239 | Thomas Forrest F000281 | rep | PA | 1821-12-03 | 1823-03-03 | Federalist | 1 | |||||||||||||
2240 | 2240 | John Gebhard G000114 | rep | NY | 1821-12-03 | 1823-03-03 | Federalist | 13 | |||||||||||||
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 | |||||||||||||
2244 | 2244 | James Hawkes H000366 | rep | NY | 1821-12-03 | 1823-03-03 | Republican | 15 | |||||||||||||
2245 | 2245 | Joseph Hernández H000533 | rep | FL | 1821-12-03 | 1823-03-03 | -1 | ||||||||||||||
2247 | 2247 | Mark Hill H000602 | rep | ME | 1821-12-03 | 1823-03-03 | Republican | 3 | |||||||||||||
2249 | 2249 | Thomas Hubbard H000890 | rep | NY | 1821-12-03 | 1823-03-03 | Republican | 17 | |||||||||||||
2251 | 2251 | Edward Jackson J000010 | rep | VA | 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 | |||||||||||||
2257 | 2257 | Elias Keyes K000160 | rep | VT | 1821-12-03 | 1823-03-03 | Republican | 4 | |||||||||||||
2258 | 2258 | Joseph Kirkland K000235 | rep | NY | 1821-12-03 | 1823-03-03 | Federalist | 16 | |||||||||||||
2264 | 2264 | William Lowndes L000483 | rep | SC | 1821-12-03 | 1823-03-03 | Republican | 2 | |||||||||||||
2265 | 2265 | Richard McCarty M000321 | rep | NY | 1821-12-03 | 1823-03-03 | Republican | 8 | |||||||||||||
2266 | 2266 | James McSherry M000602 | rep | PA | 1821-12-03 | 1823-03-03 | Federalist | 5 | |||||||||||||
2270 | 2270 | William Milnor M000786 | rep | PA | 1821-12-03 | 1823-03-03 | Federalist | 1 | |||||||||||||
2273 | 2273 | Thomas Montgomery M000872 | rep | KY | 1821-12-03 | 1823-03-03 | Republican | 9 | |||||||||||||
2276 | 2276 | Samuel Moore M000916 | rep | PA | 1821-12-03 | 1823-03-03 | Republican | 6 | |||||||||||||
2278 | 2278 | Thomas Moore M000920 | rep | VA | 1821-12-03 | 1823-03-03 | Republican | 10 | |||||||||||||
2279 | 2279 | Thomas Murray M001115 | rep | PA | 1821-12-03 | 1823-03-03 | Republican | 10 | |||||||||||||
2285 | 2285 | Hugh Nelson N000035 | rep | VA | 1821-12-03 | 1823-03-03 | Republican | 22 | |||||||||||||
2286 | 2286 | John Nelson N000037 | rep | MD | 1821-12-03 | 1823-03-03 | Republican | 4 | |||||||||||||
2295 | 2295 | Anthony New N000058 | rep | KY | 1821-12-03 | 1823-03-03 | Republican | 5 | |||||||||||||
2297 | 2297 | James Overstreet O000142 | rep | SC | 1821-12-03 | 1823-03-03 | Republican | 4 | |||||||||||||
2298 | 2298 | Walter Patterson P000131 | rep | NY | 1821-12-03 | 1823-03-03 | Federalist | 5 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
2311 | 2311 | Robert Reid R000151 | rep | GA | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
2320 | 2320 | John Rhea R000181 | rep | TN | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
2323 | 2323 | George Robertson R000322 | rep | KY | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
2324 | 2324 | Charles Ruggles R000501 | rep | NY | 1821-12-03 | 1823-03-03 | Federalist | 7 | |||||||||||||
2326 | 2326 | John Russ R000519 | rep | CT | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
2327 | 2327 | Jonathan Russell R000531 | rep | MA | 1821-12-03 | 1823-03-03 | Republican | 11 | |||||||||||||
2329 | 2329 | Solomon Sibley S000400 | rep | MI | 1821-12-03 | 1823-03-03 | -1 | ||||||||||||||
2330 | 2330 | John Smith S000575 | rep | KY | 1821-12-03 | 1823-03-03 | Republican | 7 | |||||||||||||
2331 | 2331 | Elijah Spencer S000722 | rep | NY | 1821-12-03 | 1823-03-03 | Republican | 21 | |||||||||||||
2332 | 2332 | Micah Sterling S000871 | rep | NY | 1821-12-03 | 1823-03-03 | Federalist | 18 | |||||||||||||
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 | |||||||||||||
2338 | 2338 | Solomon Van Rensselaer V000055 | rep | NY | 1821-12-03 | 1823-03-03 | Federalist | 9 | |||||||||||||
2340 | 2340 | Thomas Van Swearingen V000059 | rep | VA | 1821-12-03 | 1823-03-03 | Federalist | 2 | |||||||||||||
2343 | 2343 | Felix Walker W000050 | rep | NC | 1821-12-03 | 1823-03-03 | Republican | 12 | |||||||||||||
2344 | 2344 | Reuben Walworth W000118 | rep | NY | 1821-12-03 | 1823-03-03 | Republican | 12 | |||||||||||||
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 | |||||||||||||
2350 | 2350 | William Williamson W000554 | rep | ME | 1821-12-03 | 1823-03-03 | Republican | 4 | |||||||||||||
2351 | 2351 | Samuel Woodson W000729 | rep | KY | 1821-12-03 | 1823-03-03 | Republican | 2 | |||||||||||||
2352 | 2352 | Ludwig Worman W000745 | rep | PA | 1821-12-03 | 1823-03-03 | Federalist | 7 | |||||||||||||
2358 | 2358 | Robert Wright W000768 | rep | MD | 1821-12-03 | 1823-03-03 | Republican | 7 | |||||||||||||
2363 | 2363 | James Lloyd L000378 | sen | MA | 1822-06-05 | 1823-03-03 | 2 | Adams | |||||||||||||
2371 | 2371 | John Taylor T000086 | sen | VA | 1822-12-18 | 1823-03-03 | 2 | Republican | |||||||||||||
2375 | 2375 | Joel Abbott A000003 | rep | GA | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
2379 | 2379 | William Ball B000103 | rep | VA | 1821-12-03 | 1823-03-03 | Republican | 9 | |||||||||||||
2382 | 2382 | John Brown B000926 | rep | PA | 1821-12-03 | 1823-03-03 | Republican | 9 | |||||||||||||
2385 | 2385 | Hutchins Burton B001152 | rep | NC | 1821-12-03 | 1823-03-03 | Republican | 2 | |||||||||||||
2392 | 2392 | John Chandler C000291 | sen | ME | 1820-01-01 | 1823-03-03 | 2 | Republican | |||||||||||||
2397 | 2397 | Joshua Cushman C001020 | rep | ME | 1821-12-03 | 1823-03-03 | Republican | 6 | |||||||||||||
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 | ||||||||||||||
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 | |||||||||||||
2421 | 2421 | Matthew Harvey H000309 | rep | NH | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
2429 | 2429 | Charles Hooks H000761 | rep | NC | 1821-12-03 | 1823-03-03 | Republican | 5 | |||||||||||||
2432 | 2432 | John Johnson J000154 | rep | KY | 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);