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 party
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, class, district, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2197 | 2197 | James Bates B000235 | rep | AR | 1821-12-03 | 1823-03-03 | -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 | ||||||||||||||
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 | ||||||||||||||
2409 | 2409 | William Ellis E000137 | rep | PA | 1821-12-03 | 1823-03-03 | -1 | ||||||||||||||
2484 | 2484 | Peter Sharpe S000297 | rep | NY | 1821-12-03 | 1823-03-03 | -1 | ||||||||||||||
3011 | 3011 | John Wright W000764 | rep | OH | 1821-12-03 | 1823-03-03 | -1 | ||||||||||||||
2363 | 2363 | James Lloyd L000378 | sen | MA | 1822-06-05 | 1823-03-03 | 2 | Adams | |||||||||||||
1890 | 1890 | Harrison Otis O000127 | sen | MA | 1817-12-01 | 1823-03-03 | 2 | Federalist | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
2240 | 2240 | John Gebhard G000114 | rep | NY | 1821-12-03 | 1823-03-03 | Federalist | 13 | |||||||||||||
2258 | 2258 | Joseph Kirkland K000235 | rep | NY | 1821-12-03 | 1823-03-03 | Federalist | 16 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
2324 | 2324 | Charles Ruggles R000501 | rep | NY | 1821-12-03 | 1823-03-03 | Federalist | 7 | |||||||||||||
2332 | 2332 | Micah Sterling S000871 | rep | NY | 1821-12-03 | 1823-03-03 | Federalist | 18 | |||||||||||||
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 | |||||||||||||
2349 | 2349 | Ezekiel Whitman W000421 | rep | ME | 1821-12-03 | 1823-03-03 | Federalist | 2 | |||||||||||||
2352 | 2352 | Ludwig Worman W000745 | rep | PA | 1821-12-03 | 1823-03-03 | Federalist | 7 | |||||||||||||
2452 | 2452 | Raphael Neale N000018 | rep | MD | 1821-12-03 | 1823-03-03 | Federalist | 1 | |||||||||||||
2493 | 2493 | James Stephenson S000864 | rep | VA | 1821-12-03 | 1823-03-03 | Federalist | 2 | |||||||||||||
2518 | 2518 | Nicholas Van Dyke V000037 | sen | DE | 1817-12-01 | 1823-03-03 | 2 | Federalist | |||||||||||||
2526 | 2526 | Henry Warfield W000150 | rep | MD | 1821-12-03 | 1823-03-03 | Federalist | 3 | |||||||||||||
2559 | 2559 | Francis Baylies B000255 | rep | MA | 1821-12-03 | 1823-03-03 | Federalist | 10 | |||||||||||||
2587 | 2587 | Samuel Edwards E000080 | rep | PA | 1821-12-03 | 1823-03-03 | Federalist | 1 | |||||||||||||
2652 | 2652 | Samuel Lathrop L000112 | rep | MA | 1821-12-03 | 1823-03-03 | Federalist | 5 | |||||||||||||
2685 | 2685 | Archibald McNeill M000586 | rep | NC | 1821-12-03 | 1823-03-03 | Federalist | 7 | |||||||||||||
2755 | 2755 | Daniel Rodney R000378 | rep | DE | 1821-12-03 | 1823-03-03 | Federalist | 0 | |||||||||||||
2766 | 2766 | Samuel Allen A000146 | rep | MA | 1821-12-03 | 1823-03-03 | Federalist | 6 | |||||||||||||
2896 | 2896 | Louis McLane M000535 | rep | DE | 1821-12-03 | 1823-03-03 | Federalist | 0 | |||||||||||||
2983 | 2983 | Stephen Van Rensselaer V000056 | rep | NY | 1821-12-03 | 1823-03-03 | Federalist | 9 | |||||||||||||
3083 | 3083 | John Dickinson D000322 | rep | NY | 1821-12-03 | 1823-03-03 | Federalist | 10 | |||||||||||||
3091 | 3091 | Henry Dwight D000579 | rep | MA | 1821-12-03 | 1823-03-03 | Federalist | 7 | |||||||||||||
3123 | 3123 | Joseph Hemphill H000470 | rep | PA | 1821-12-03 | 1823-03-03 | Federalist | 1 | |||||||||||||
3500 | 3500 | Jeremiah Nelson N000036 | rep | MA | 1821-12-03 | 1823-03-03 | Federalist | 3 | |||||||||||||
4548 | 4548 | Charles Mercer M000642 | rep | VA | 1821-12-03 | 1823-03-03 | Federalist | 8 | |||||||||||||
4586 | 4586 | John Reed R000121 | rep | MA | 1821-12-03 | 1823-03-03 | Federalist | 9 | |||||||||||||
4992 | 4992 | John Sergeant S000246 | rep | PA | 1821-12-03 | 1823-03-03 | Federalist | 1 | |||||||||||||
6963 | 6963 | James Buchanan B001005 | rep | PA | 1821-12-03 | 1823-03-03 | Federalist | 3 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
2236 | 2236 | William Eustis E000230 | rep | MA | 1821-12-03 | 1823-03-03 | Republican | 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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 |
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);