legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
44,551 rows sorted by state
This data as json, copyable, CSV (advanced)
start (date) >30 ✖
- 1929-04-15 498
- 1913-04-07 496
- 1919-05-19 495
- 1917-04-02 494
- 1923-12-03 494
- 1931-12-07 494
- 1939-01-03 494
- 1921-04-11 491
- 1941-01-03 491
- 1943-01-06 486
- 1925-12-07 484
- 1927-12-05 484
- 1933-03-09 484
- 1947-01-03 484
- 1945-01-03 483
- 1951-01-03 483
- 1937-01-05 482
- 1961-01-03 482
- 1959-01-07 481
- 1915-12-06 480
- 1969-01-03 480
- 1981-01-05 480
- 1989-01-03 480
- 1935-01-03 479
- 1949-01-03 479
- 1957-01-03 479
- 1963-01-09 479
- 1975-01-14 478
- 1971-01-21 477
- 1977-01-04 477
- …
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7348 | 7348 | Williamson Cobb C000554 | rep | AL | 1849-12-03 | 1851-03-03 | Democrat | 6 | |||||||||||||
7349 | 7349 | Williamson Cobb C000554 | rep | AL | 1851-12-01 | 1853-03-03 | Democrat | 6 | |||||||||||||
7350 | 7350 | Williamson Cobb C000554 | rep | AL | 1853-12-05 | 1855-03-03 | Democrat | 6 | |||||||||||||
7351 | 7351 | Williamson Cobb C000554 | rep | AL | 1855-12-03 | 1857-03-03 | Democrat | 6 | |||||||||||||
7352 | 7352 | Williamson Cobb C000554 | rep | AL | 1857-12-07 | 1859-03-03 | Democrat | 6 | |||||||||||||
7353 | 7353 | Williamson Cobb C000554 | rep | AL | 1859-12-05 | 1861-03-03 | Democrat | 6 | |||||||||||||
7369 | 7369 | Jabez Curry C001003 | rep | AL | 1857-12-07 | 1859-03-03 | Democrat | 7 | |||||||||||||
7370 | 7370 | Jabez Curry C001003 | rep | AL | 1859-12-05 | 1861-03-03 | Democrat | 7 | |||||||||||||
7519 | 7519 | Sydenham Moore M000918 | rep | AL | 1857-12-07 | 1859-03-03 | Democrat | 4 | |||||||||||||
7520 | 7520 | Sydenham Moore M000918 | rep | AL | 1859-12-05 | 1861-03-03 | Democrat | 4 | |||||||||||||
7580 | 7580 | James Stallworth S000786 | rep | AL | 1857-12-07 | 1859-03-03 | Democrat | 1 | |||||||||||||
7581 | 7581 | James Stallworth S000786 | rep | AL | 1859-12-05 | 1861-03-03 | Democrat | 1 | |||||||||||||
8280 | 8280 | John Callis C000057 | rep | AL | 1867-03-04 | 1869-03-03 | Republican | 5 | |||||||||||||
8349 | 8349 | Thomas Haughey H000352 | rep | AL | 1867-03-04 | 1869-03-03 | Republican | 6 | |||||||||||||
8373 | 8373 | Francis Kellogg K000064 | rep | AL | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
8408 | 8408 | Benjamin Norris N000138 | rep | AL | 1867-03-04 | 1869-03-03 | Republican | 3 | |||||||||||||
8420 | 8420 | Charles Pierce P000332 | rep | AL | 1867-03-04 | 1869-03-03 | Republican | 4 | |||||||||||||
8501 | 8501 | Willard Warner W000159 | sen | AL | 1868-01-01 | 1871-03-03 | 2 | Republican | |||||||||||||
8535 | 8535 | Alfred Buck B001011 | rep | AL | 1869-03-04 | 1871-03-03 | Republican | 1 | |||||||||||||
8625 | 8625 | Robert Heflin H000447 | rep | AL | 1869-03-04 | 1871-03-03 | Republican | 3 | |||||||||||||
8719 | 8719 | William Sherrod S000352 | rep | AL | 1869-03-04 | 1871-03-03 | Democrat | 6 | |||||||||||||
8841 | 8841 | Charles Buckley B001025 | rep | AL | 1867-03-04 | 1869-03-03 | Republican | 2 | |||||||||||||
8842 | 8842 | Charles Buckley B001025 | rep | AL | 1869-03-04 | 1871-03-03 | Republican | 2 | |||||||||||||
8843 | 8843 | Charles Buckley B001025 | rep | AL | 1871-03-04 | 1873-03-03 | Republican | 2 | |||||||||||||
8880 | 8880 | Peter Dox D000478 | rep | AL | 1869-03-04 | 1871-03-03 | Democrat | 5 | |||||||||||||
8881 | 8881 | Peter Dox D000478 | rep | AL | 1871-03-04 | 1873-03-03 | Democrat | 5 | |||||||||||||
8911 | 8911 | George Goldthwaite G000266 | sen | AL | 1871-03-04 | 1877-03-03 | 2 | Democrat | |||||||||||||
8921 | 8921 | William Handley H000155 | rep | AL | 1871-03-04 | 1873-03-03 | Democrat | 3 | |||||||||||||
9040 | 9040 | Benjamin Turner T000414 | rep | AL | 1871-03-04 | 1873-03-03 | Republican | 1 | |||||||||||||
9099 | 9099 | Frederick Bromberg B000864 | rep | AL | 1873-12-01 | 1875-03-03 | Liberal Republican | 1 | |||||||||||||
9311 | 9311 | Charles Pelham P000192 | rep | AL | 1873-12-01 | 1875-03-03 | Republican | 3 | |||||||||||||
9320 | 9320 | James Rapier R000064 | rep | AL | 1873-12-01 | 1875-03-03 | Republican | 2 | |||||||||||||
9357 | 9357 | Charles Sheats S000314 | rep | AL | 1873-12-01 | 1875-03-03 | Republican | -1 | |||||||||||||
9365 | 9365 | Joseph Sloss S000498 | rep | AL | 1871-03-04 | 1873-03-03 | Democrat | 6 | |||||||||||||
9366 | 9366 | Joseph Sloss S000498 | rep | AL | 1873-12-01 | 1875-03-03 | Democrat | 6 | |||||||||||||
9379 | 9379 | George Spencer S000723 | sen | AL | 1868-01-01 | 1873-03-03 | 3 | Republican | |||||||||||||
9380 | 9380 | George Spencer S000723 | sen | AL | 1873-12-01 | 1879-03-03 | 3 | Republican | |||||||||||||
9406 | 9406 | Alexander White W000353 | rep | AL | 1851-12-01 | 1853-03-03 | Whig | 7 | |||||||||||||
9407 | 9407 | Alexander White W000353 | rep | AL | 1873-12-01 | 1875-03-03 | Republican | -1 | |||||||||||||
9453 | 9453 | Taul Bradford B000738 | rep | AL | 1875-12-06 | 1877-03-03 | Democrat | 3 | |||||||||||||
9475 | 9475 | John Caldwell C000035 | rep | AL | 1873-12-01 | 1875-03-03 | Democrat | 5 | |||||||||||||
9476 | 9476 | John Caldwell C000035 | rep | AL | 1875-12-06 | 1877-03-03 | Democrat | 5 | |||||||||||||
9521 | 9521 | Jeremiah Haralson H000179 | rep | AL | 1875-12-06 | 1877-03-03 | Republican | 1 | |||||||||||||
9525 | 9525 | Charles Hays H000402 | rep | AL | 1869-03-04 | 1871-03-03 | Republican | 4 | |||||||||||||
9526 | 9526 | Charles Hays H000402 | rep | AL | 1871-03-04 | 1873-03-03 | Republican | 4 | |||||||||||||
9527 | 9527 | Charles Hays H000402 | rep | AL | 1873-12-01 | 1875-03-03 | Republican | 4 | |||||||||||||
9528 | 9528 | Charles Hays H000402 | rep | AL | 1875-12-06 | 1877-03-03 | Republican | 4 | |||||||||||||
9819 | 9819 | William Garth G000086 | rep | AL | 1877-10-15 | 1879-03-03 | Democrat | 8 | |||||||||||||
9877 | 9877 | Robert Ligon L000306 | rep | AL | 1877-10-15 | 1879-03-03 | Democrat | 5 | |||||||||||||
9985 | 9985 | Jeremiah Williams W000512 | rep | AL | 1875-12-06 | 1877-03-03 | Democrat | 2 | |||||||||||||
9986 | 9986 | Jeremiah Williams W000512 | rep | AL | 1877-10-15 | 1879-03-03 | Democrat | 3 | |||||||||||||
10041 | 10041 | Newton Clements C000509 | rep | AL | 1879-03-18 | 1881-03-03 | Democrat | 6 | |||||||||||||
10107 | 10107 | George Houston H000822 | rep | AL | 1841-05-31 | 1843-03-03 | Democrat | 0 | |||||||||||||
10108 | 10108 | George Houston H000822 | rep | AL | 1843-12-04 | 1845-03-03 | Democrat | 5 | |||||||||||||
10109 | 10109 | George Houston H000822 | rep | AL | 1845-12-01 | 1847-03-03 | Democrat | 5 | |||||||||||||
10110 | 10110 | George Houston H000822 | rep | AL | 1847-12-06 | 1849-03-03 | Democrat | 5 | |||||||||||||
10111 | 10111 | George Houston H000822 | rep | AL | 1851-12-01 | 1853-03-03 | Democrat | 5 | |||||||||||||
10112 | 10112 | George Houston H000822 | rep | AL | 1853-12-05 | 1855-03-03 | Democrat | 5 | |||||||||||||
10113 | 10113 | George Houston H000822 | rep | AL | 1855-12-03 | 1857-03-03 | Democrat | 5 | |||||||||||||
10114 | 10114 | George Houston H000822 | rep | AL | 1857-12-07 | 1859-03-03 | Democrat | 5 | |||||||||||||
10115 | 10115 | George Houston H000822 | rep | AL | 1859-12-05 | 1861-03-03 | Democrat | 5 | |||||||||||||
10116 | 10116 | George Houston H000822 | sen | AL | 1879-03-18 | 1879-12-31 | 3 | Democrat | |||||||||||||
10132 | 10132 | Burwell Lewis L000272 | rep | AL | 1875-12-06 | 1877-03-03 | Democrat | -1 | |||||||||||||
10133 | 10133 | Burwell Lewis L000272 | rep | AL | 1879-03-18 | 1881-03-03 | Democrat | 6 | |||||||||||||
10181 | 10181 | William Samford S000022 | rep | AL | 1879-03-18 | 1881-03-03 | Democrat | 3 | |||||||||||||
10436 | 10436 | William Lowe L000474 | rep | AL | 1879-03-18 | 1881-03-03 | National Greenbacker | 8 | |||||||||||||
10437 | 10437 | William Lowe L000474 | rep | AL | 1881-12-05 | 1883-03-03 | National Greenbacker | 8 | |||||||||||||
10682 | 10682 | George Craig C000855 | rep | AL | 1883-12-03 | 1885-03-03 | Republican | 4 | |||||||||||||
10745 | 10745 | Thomas Herndon H000534 | rep | AL | 1879-03-18 | 1881-03-03 | Democrat | 1 | |||||||||||||
10746 | 10746 | Thomas Herndon H000534 | rep | AL | 1881-12-05 | 1883-03-03 | Democrat | 1 | |||||||||||||
10747 | 10747 | Thomas Herndon H000534 | rep | AL | 1883-12-03 | 1885-03-03 | Democrat | 1 | |||||||||||||
10748 | 10748 | Goldsmith Hewitt H000553 | rep | AL | 1875-12-06 | 1877-03-03 | Democrat | 6 | |||||||||||||
10749 | 10749 | Goldsmith Hewitt H000553 | rep | AL | 1877-10-15 | 1879-03-03 | Democrat | 6 | |||||||||||||
10750 | 10750 | Goldsmith Hewitt H000553 | rep | AL | 1881-12-05 | 1883-03-03 | Democrat | 6 | |||||||||||||
10751 | 10751 | Goldsmith Hewitt H000553 | rep | AL | 1883-12-03 | 1885-03-03 | Democrat | 6 | |||||||||||||
10850 | 10850 | Luke Pryor P000557 | sen | AL | 1880-01-01 | 1881-03-03 | 3 | Democrat | |||||||||||||
10851 | 10851 | Luke Pryor P000557 | rep | AL | 1883-12-03 | 1885-03-03 | Democrat | 8 | |||||||||||||
10885 | 10885 | Charles Shelley S000326 | rep | AL | 1877-10-15 | 1879-03-03 | Democrat | 4 | |||||||||||||
10886 | 10886 | Charles Shelley S000326 | rep | AL | 1879-03-18 | 1881-03-03 | Democrat | 4 | |||||||||||||
10887 | 10887 | Charles Shelley S000326 | rep | AL | 1881-12-05 | 1883-03-03 | Democrat | 4 | |||||||||||||
10888 | 10888 | Charles Shelley S000326 | rep | AL | 1883-12-03 | 1885-03-03 | Democrat | 4 | |||||||||||||
10933 | 10933 | Thomas Williams W000537 | rep | AL | 1879-03-18 | 1881-03-03 | Democrat | 5 | |||||||||||||
10934 | 10934 | Thomas Williams W000537 | rep | AL | 1881-12-05 | 1883-03-03 | Democrat | 5 | |||||||||||||
10935 | 10935 | Thomas Williams W000537 | rep | AL | 1883-12-03 | 1885-03-03 | Democrat | 5 | |||||||||||||
11125 | 11125 | John Martin M000188 | rep | AL | 1885-12-07 | 1887-03-03 | Democrat | 6 | |||||||||||||
11181 | 11181 | Thomas Sadler S000010 | rep | AL | 1885-12-07 | 1887-03-03 | Democrat | 5 | |||||||||||||
11331 | 11331 | Alexander Davidson D000082 | rep | AL | 1885-12-07 | 1887-03-03 | Democrat | 4 | |||||||||||||
11332 | 11332 | Alexander Davidson D000082 | rep | AL | 1887-12-05 | 1889-03-03 | Democrat | 4 | |||||||||||||
11421 | 11421 | James Jones J000233 | rep | AL | 1877-10-15 | 1879-03-03 | Democrat | 1 | |||||||||||||
11422 | 11422 | James Jones J000233 | rep | AL | 1883-12-03 | 1885-03-03 | Democrat | 1 | |||||||||||||
11423 | 11423 | James Jones J000233 | rep | AL | 1885-12-07 | 1887-03-03 | Democrat | 1 | |||||||||||||
11424 | 11424 | James Jones J000233 | rep | AL | 1887-12-05 | 1889-03-03 | Democrat | 1 | |||||||||||||
11849 | 11849 | John McDuffie M000428 | rep | AL | 1889-12-02 | 1891-03-03 | Republican | 4 | |||||||||||||
12164 | 12164 | William Forney F000280 | rep | AL | 1875-12-06 | 1877-03-03 | Democrat | -1 | |||||||||||||
12165 | 12165 | William Forney F000280 | rep | AL | 1877-10-15 | 1879-03-03 | Democrat | 7 | |||||||||||||
12166 | 12166 | William Forney F000280 | rep | AL | 1879-03-18 | 1881-03-03 | Democrat | 7 | |||||||||||||
12167 | 12167 | William Forney F000280 | rep | AL | 1881-12-05 | 1883-03-03 | Democrat | 7 | |||||||||||||
12168 | 12168 | William Forney F000280 | rep | AL | 1883-12-03 | 1885-03-03 | Democrat | 7 | |||||||||||||
12169 | 12169 | William Forney F000280 | rep | AL | 1885-12-07 | 1887-03-03 | Democrat | 7 | |||||||||||||
12170 | 12170 | William Forney F000280 | rep | AL | 1887-12-05 | 1889-03-03 | Democrat | 7 |
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);