legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
241 rows where "start" is on date 1823-12-01
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2364 | 2364 | James Lloyd L000378 | sen | MA | 1823-12-01 | 1826-05-23 | 2 | Adams | |||||||||||||
2372 | 2372 | John Taylor T000086 | sen | VA | 1823-12-01 | 1824-08-21 | 2 | Republican | |||||||||||||
2376 | 2376 | Joel Abbott A000003 | rep | GA | 1823-12-01 | 1825-03-03 | Republican | -1 | |||||||||||||
2380 | 2380 | William Ball B000103 | rep | VA | 1823-12-01 | 1825-03-03 | Republican | 13 | |||||||||||||
2381 | 2381 | Samuel Breck B000783 | rep | PA | 1823-12-01 | 1825-03-03 | 1 | ||||||||||||||
2383 | 2383 | John Brown B000926 | rep | PA | 1823-12-01 | 1825-03-03 | 12 | ||||||||||||||
2386 | 2386 | Hutchins Burton B001152 | rep | NC | 1823-12-01 | 1825-03-03 | 2 | ||||||||||||||
2387 | 2387 | John Cady C000015 | rep | NY | 1823-12-01 | 1825-03-03 | 16 | ||||||||||||||
2388 | 2388 | Jacob Call C000049 | rep | IN | 1823-12-01 | 1825-03-03 | Jackson Republican | 1 | |||||||||||||
2389 | 2389 | Richard Call C000050 | rep | FL | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
2393 | 2393 | John Chandler C000291 | sen | ME | 1823-12-01 | 1829-03-03 | 2 | Jackson | |||||||||||||
2394 | 2394 | Lot Clark C000447 | rep | NY | 1823-12-01 | 1825-03-03 | 21 | ||||||||||||||
2395 | 2395 | Ela Collins C000635 | rep | NY | 1823-12-01 | 1825-03-03 | 20 | ||||||||||||||
2398 | 2398 | Joshua Cushman C001020 | rep | ME | 1823-12-01 | 1825-03-03 | 4 | ||||||||||||||
2400 | 2400 | Job Durfee D000568 | rep | RI | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
2401 | 2401 | Justin Dwinell D000584 | rep | NY | 1823-12-01 | 1825-03-03 | 22 | ||||||||||||||
2402 | 2402 | Lewis Eaton E000025 | rep | NY | 1823-12-01 | 1825-03-03 | Crawford Republican | 12 | |||||||||||||
2405 | 2405 | Samuel Eddy E000040 | rep | RI | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
2408 | 2408 | Henry Edwards E000070 | sen | CT | 1823-12-01 | 1827-03-03 | 1 | Jackson | |||||||||||||
2410 | 2410 | William Ellis E000137 | rep | PA | 1823-12-01 | 1825-03-03 | 9 | ||||||||||||||
2411 | 2411 | Charles Foote F000249 | rep | NY | 1823-12-01 | 1825-03-03 | 11 | ||||||||||||||
2413 | 2413 | Walter Forward F000291 | rep | PA | 1823-12-01 | 1825-03-03 | 16 | ||||||||||||||
2414 | 2414 | Joel Frost F000391 | rep | NY | 1823-12-01 | 1825-03-03 | Crawford Republican | 4 | |||||||||||||
2418 | 2418 | Timothy Fuller F000413 | rep | MA | 1823-12-01 | 1825-03-03 | Republican | 4 | |||||||||||||
2419 | 2419 | Alfred Gatlin G000099 | rep | NC | 1823-12-01 | 1825-03-03 | Crawford Republican | 1 | |||||||||||||
2420 | 2420 | James Gazlay G000109 | rep | OH | 1823-12-01 | 1825-03-03 | 1 | ||||||||||||||
2422 | 2422 | Matthew Harvey H000309 | rep | NH | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
2423 | 2423 | William Hayward H000410 | rep | MD | 1823-12-01 | 1825-03-03 | 7 | ||||||||||||||
2425 | 2425 | John Herkimer H000529 | rep | NY | 1823-12-01 | 1825-03-03 | Republican | 15 | |||||||||||||
2426 | 2426 | James Hogeboom H000700 | rep | NY | 1823-12-01 | 1825-03-03 | 9 | ||||||||||||||
2430 | 2430 | Charles Hooks H000761 | rep | NC | 1823-12-01 | 1825-03-03 | Republican | 5 | |||||||||||||
2431 | 2431 | Lemuel Jenkins J000085 | rep | NY | 1823-12-01 | 1825-03-03 | 7 | ||||||||||||||
2433 | 2433 | John Johnson J000154 | rep | KY | 1823-12-01 | 1825-03-03 | 5 | ||||||||||||||
2434 | 2434 | Samuel Lawrence L000138 | rep | NY | 1823-12-01 | 1825-03-03 | 25 | ||||||||||||||
2435 | 2435 | John Lee L000196 | rep | MD | 1823-12-01 | 1825-03-03 | 4 | ||||||||||||||
2437 | 2437 | Jabez Leftwich L000216 | rep | VA | 1823-12-01 | 1825-03-03 | 7 | ||||||||||||||
2439 | 2439 | Elisha Litchfield L000346 | rep | NY | 1823-12-01 | 1825-03-03 | 23 | ||||||||||||||
2442 | 2442 | Arthur Livermore L000362 | rep | NH | 1823-12-01 | 1825-03-03 | Republican | -1 | |||||||||||||
2443 | 2443 | Stephen Longfellow L000430 | rep | ME | 1823-12-01 | 1825-03-03 | 2 | ||||||||||||||
2445 | 2445 | James Matlack M000245 | rep | NJ | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
2447 | 2447 | Aaron Matson M000247 | rep | NH | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
2449 | 2449 | Duncan McArthur M000299 | rep | OH | 1823-12-01 | 1825-03-03 | 6 | ||||||||||||||
2453 | 2453 | Raphael Neale N000018 | rep | MD | 1823-12-01 | 1825-03-03 | 1 | ||||||||||||||
2454 | 2454 | Henry Olin O000068 | rep | VT | 1823-12-01 | 1825-03-03 | 3 | ||||||||||||||
2455 | 2455 | George Outlaw O000139 | rep | NC | 1823-12-01 | 1825-03-03 | 2 | ||||||||||||||
2456 | 2456 | John Patterson P000122 | rep | OH | 1823-12-01 | 1825-03-03 | 10 | ||||||||||||||
2460 | 2460 | Thomas Patterson P000128 | rep | PA | 1823-12-01 | 1825-03-03 | Republican | 15 | |||||||||||||
2463 | 2463 | William Plumer P000394 | rep | NH | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
2464 | 2464 | William Prince P000540 | rep | IN | 1823-12-01 | 1825-03-03 | Republican | 1 | |||||||||||||
2466 | 2466 | James Reynolds R000173 | rep | TN | 1823-12-01 | 1825-03-03 | Republican | 8 | |||||||||||||
2471 | 2471 | Charles Rich R000207 | rep | VT | 1823-12-01 | 1825-03-03 | Republican | 3 | |||||||||||||
2472 | 2472 | Gabriel Richard R000210 | rep | MI | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
2473 | 2473 | John Richards R000216 | rep | NY | 1823-12-01 | 1825-03-03 | 19 | ||||||||||||||
2475 | 2475 | William Rochester R000360 | rep | NY | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
2479 | 2479 | Thomas Rogers R000403 | rep | PA | 1823-12-01 | 1825-03-03 | Republican | 8 | |||||||||||||
2482 | 2482 | Thomas Ross R000456 | rep | OH | 1823-12-01 | 1825-03-03 | 2 | ||||||||||||||
2483 | 2483 | James Sandford S000040 | rep | TN | 1823-12-01 | 1825-03-03 | Jackson Republican | 6 | |||||||||||||
2485 | 2485 | Peter Sharpe S000297 | rep | NY | 1823-12-01 | 1825-03-03 | 3 | ||||||||||||||
2486 | 2486 | Jonas Sibley S000397 | rep | MA | 1823-12-01 | 1825-03-03 | 5 | ||||||||||||||
2489 | 2489 | Arthur Smith S000515 | rep | VA | 1823-12-01 | 1825-03-03 | 2 | ||||||||||||||
2490 | 2490 | Richard Spaight S000694 | rep | NC | 1823-12-01 | 1825-03-03 | 4 | ||||||||||||||
2494 | 2494 | James Stephenson S000864 | rep | VA | 1823-12-01 | 1825-03-03 | Federalist | 16 | |||||||||||||
2496 | 2496 | Ansel Sterling S000868 | rep | CT | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
2498 | 2498 | Ebenezer Stoddard S000943 | rep | CT | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
2501 | 2501 | Jesse Thomas T000171 | sen | IL | 1823-12-01 | 1829-03-03 | 2 | Adams | |||||||||||||
2502 | 2502 | Philip Thompson T000211 | rep | KY | 1823-12-01 | 1825-03-03 | 11 | ||||||||||||||
2504 | 2504 | John Tod T000290 | rep | PA | 1823-12-01 | 1825-03-03 | Republican | 13 | |||||||||||||
2507 | 2507 | Albert Tracy T000343 | rep | NY | 1823-12-01 | 1825-03-03 | Whig | 30 | |||||||||||||
2510 | 2510 | George Tucker T000397 | rep | VA | 1823-12-01 | 1825-03-03 | 6 | ||||||||||||||
2511 | 2511 | Jacob Tyson T000453 | rep | NY | 1823-12-01 | 1825-03-03 | 2 | ||||||||||||||
2515 | 2515 | Daniel Udree U000003 | rep | PA | 1823-12-01 | 1825-03-03 | Republican | 7 | |||||||||||||
2519 | 2519 | Nicholas Van Dyke V000037 | sen | DE | 1823-12-01 | 1827-03-03 | 2 | Adams | |||||||||||||
2521 | 2521 | William Van Wyck V000068 | rep | NY | 1823-12-01 | 1825-03-03 | 5 | ||||||||||||||
2522 | 2522 | Robert Vance V000018 | rep | NC | 1823-12-01 | 1825-03-03 | 12 | ||||||||||||||
2524 | 2524 | Nicholas Ware W000148 | sen | GA | 1823-12-01 | 1825-03-03 | 2 | ||||||||||||||
2527 | 2527 | Henry Warfield W000150 | rep | MD | 1823-12-01 | 1825-03-03 | 3 | ||||||||||||||
2528 | 2528 | Isaac Wayne W000217 | rep | PA | 1823-12-01 | 1825-03-03 | 4 | ||||||||||||||
2529 | 2529 | David White W000363 | rep | KY | 1823-12-01 | 1825-03-03 | 6 | ||||||||||||||
2530 | 2530 | Lemuel Whitman W000422 | rep | CT | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
2533 | 2533 | Isaac Williams W000505 | rep | NY | 1823-12-01 | 1825-03-03 | Republican | 13 | |||||||||||||
2536 | 2536 | Jared Williams W000510 | rep | VA | 1823-12-01 | 1825-03-03 | 17 | ||||||||||||||
2538 | 2538 | Thomas Williams W000540 | sen | MS | 1823-12-01 | 1829-03-03 | 2 | Jackson | |||||||||||||
2539 | 2539 | Isaac Wilson W000586 | rep | NY | 1823-12-01 | 1825-03-03 | Republican | 29 | |||||||||||||
2540 | 2540 | William Woods W000727 | rep | NY | 1823-12-01 | 1825-03-03 | 28 | ||||||||||||||
2545 | 2545 | Parmenio Adams A000042 | rep | NY | 1823-12-01 | 1825-03-03 | 29 | ||||||||||||||
2547 | 2547 | Adam Alexander A000089 | rep | TN | 1823-12-01 | 1825-03-03 | Jacksonian Republican | 9 | |||||||||||||
2551 | 2551 | Robert Allen A000142 | rep | TN | 1823-12-01 | 1825-03-03 | 5 | ||||||||||||||
2553 | 2553 | James Allison A000157 | rep | PA | 1823-12-01 | 1825-03-03 | 16 | ||||||||||||||
2560 | 2560 | Francis Baylies B000255 | rep | MA | 1823-12-01 | 1825-03-03 | 12 | ||||||||||||||
2563 | 2563 | William Bradley B000748 | rep | VT | 1823-12-01 | 1825-03-03 | Republican | 2 | |||||||||||||
2568 | 2568 | John Campbell C000095 | rep | OH | 1823-12-01 | 1825-03-03 | Republican | 5 | |||||||||||||
2570 | 2570 | George Cary C000212 | rep | GA | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
2573 | 2573 | George Cassedy C000234 | rep | NJ | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
2578 | 2578 | John Cocke C000571 | rep | TN | 1823-12-01 | 1825-03-03 | 2 | ||||||||||||||
2581 | 2581 | Daniel Cook C000716 | rep | IL | 1823-12-01 | 1825-03-03 | 1 | ||||||||||||||
2588 | 2588 | Samuel Edwards E000080 | rep | PA | 1823-12-01 | 1825-03-03 | 4 | ||||||||||||||
2594 | 2594 | Weldon Edwards E000083 | rep | NC | 1823-12-01 | 1825-03-03 | Republican | 6 | |||||||||||||
2598 | 2598 | Patrick Farrelly F000032 | rep | PA | 1823-12-01 | 1825-03-03 | 18 | ||||||||||||||
2601 | 2601 | John Findlay F000120 | rep | PA | 1823-12-01 | 1825-03-03 | 11 | ||||||||||||||
2612 | 2612 | Robert Garnett G000077 | rep | VA | 1823-12-01 | 1825-03-03 | Republican | 12 |
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);