legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
44,551 rows
This data as json, copyable, CSV (advanced)
end (date) >30 ✖
- 1931-03-03 502
- 1933-03-03 499
- 1941-01-03 498
- 1945-01-03 493
- 1939-01-03 492
- 1929-03-03 489
- 1963-01-03 489
- 1943-01-03 488
- 1947-01-03 488
- 1935-01-03 486
- 1949-01-03 486
- 1953-01-03 486
- 1937-01-03 485
- 1955-01-03 485
- 1925-03-03 484
- 1961-01-03 483
- 1971-01-03 483
- 1951-01-03 482
- 1965-01-03 482
- 1983-01-03 481
- 1927-03-04 480
- 1959-01-03 480
- 1977-01-03 480
- 1967-01-03 479
- 1975-01-03 479
- 1981-01-03 479
- 1987-01-03 478
- 1957-01-03 477
- 1973-01-03 477
- 1979-01-03 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
18335 | 18335 | William Mason M000228 | rep | IL | 1887-12-05 | 1889-03-03 | Republican | 3 | |||||||||||||
18336 | 18336 | William Mason M000228 | rep | IL | 1889-12-02 | 1891-03-03 | Republican | 3 | |||||||||||||
18337 | 18337 | William Mason M000228 | sen | IL | 1897-03-15 | 1903-03-03 | 3 | Republican | |||||||||||||
18338 | 18338 | William Mason M000228 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | -1 | |||||||||||||
18339 | 18339 | William Mason M000228 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | -1 | |||||||||||||
18340 | 18340 | William Mason M000228 | rep | IL | 1921-04-11 | 1923-03-03 | Republican | -1 | |||||||||||||
18341 | 18341 | Clifton McArthur M000298 | rep | OR | 1915-12-06 | 1917-03-03 | Republican | 3 | |||||||||||||
18342 | 18342 | Clifton McArthur M000298 | rep | OR | 1917-04-02 | 1919-03-03 | Republican | 3 | |||||||||||||
18343 | 18343 | Clifton McArthur M000298 | rep | OR | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
18344 | 18344 | Clifton McArthur M000298 | rep | OR | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
18345 | 18345 | Washington McCormick M000373 | rep | MT | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
18346 | 18346 | William McKinley M000521 | rep | IL | 1905-12-04 | 1907-03-03 | Republican | 19 | |||||||||||||
18347 | 18347 | William McKinley M000521 | rep | IL | 1907-12-02 | 1909-03-03 | Republican | 19 | |||||||||||||
18348 | 18348 | William McKinley M000521 | rep | IL | 1909-03-15 | 1911-03-03 | Republican | 19 | |||||||||||||
18349 | 18349 | William McKinley M000521 | rep | IL | 1911-04-04 | 1913-03-03 | Republican | 19 | |||||||||||||
18350 | 18350 | William McKinley M000521 | rep | IL | 1915-12-06 | 1917-03-03 | Republican | 19 | |||||||||||||
18351 | 18351 | William McKinley M000521 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | 19 | |||||||||||||
18352 | 18352 | William McKinley M000521 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 19 | |||||||||||||
18353 | 18353 | William McKinley M000521 | sen | IL | 1921-04-11 | 1927-03-04 | 3 | Republican | |||||||||||||
18354 | 18354 | Joseph McLaughlin M000540 | rep | PA | 1917-04-02 | 1919-03-03 | Republican | -1 | |||||||||||||
18355 | 18355 | Joseph McLaughlin M000540 | rep | PA | 1921-04-11 | 1923-03-03 | Republican | -1 | |||||||||||||
18356 | 18356 | Isaac McPherson M000592 | rep | MO | 1919-05-19 | 1921-03-03 | Republican | 15 | |||||||||||||
18357 | 18357 | Isaac McPherson M000592 | rep | MO | 1921-04-11 | 1923-03-03 | Republican | 15 | |||||||||||||
18358 | 18358 | Frank Millspaugh M000781 | rep | MO | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
18359 | 18359 | Franklin Mondell M000852 | rep | WY | 1895-12-02 | 1897-03-03 | Republican | 0 | |||||||||||||
18360 | 18360 | Franklin Mondell M000852 | rep | WY | 1899-12-04 | 1901-03-03 | Republican | 0 | |||||||||||||
18361 | 18361 | Franklin Mondell M000852 | rep | WY | 1901-12-02 | 1903-03-03 | Republican | 0 | |||||||||||||
18362 | 18362 | Franklin Mondell M000852 | rep | WY | 1903-11-09 | 1905-03-03 | Republican | 0 | |||||||||||||
18363 | 18363 | Franklin Mondell M000852 | rep | WY | 1905-12-04 | 1907-03-03 | Republican | 0 | |||||||||||||
18364 | 18364 | Franklin Mondell M000852 | rep | WY | 1907-12-02 | 1909-03-03 | Republican | 0 | |||||||||||||
18365 | 18365 | Franklin Mondell M000852 | rep | WY | 1909-03-15 | 1911-03-03 | Republican | 0 | |||||||||||||
18366 | 18366 | Franklin Mondell M000852 | rep | WY | 1911-04-04 | 1913-03-03 | Republican | 0 | |||||||||||||
18367 | 18367 | Franklin Mondell M000852 | rep | WY | 1913-04-07 | 1915-03-03 | Republican | 0 | |||||||||||||
18368 | 18368 | Franklin Mondell M000852 | rep | WY | 1915-12-06 | 1917-03-03 | Republican | 0 | |||||||||||||
18369 | 18369 | Franklin Mondell M000852 | rep | WY | 1917-04-02 | 1919-03-03 | Republican | 0 | |||||||||||||
18370 | 18370 | Franklin Mondell M000852 | rep | WY | 1919-05-19 | 1921-03-03 | Republican | 0 | |||||||||||||
18371 | 18371 | Franklin Mondell M000852 | rep | WY | 1921-04-11 | 1923-03-03 | Republican | 0 | |||||||||||||
18372 | 18372 | Néstor Montoya M000877 | rep | NM | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
18373 | 18373 | Adolphus Nelson N000029 | rep | WI | 1917-04-02 | 1919-03-03 | Republican | 11 | |||||||||||||
18374 | 18374 | Adolphus Nelson N000029 | rep | WI | 1919-05-19 | 1921-03-03 | Republican | 11 | |||||||||||||
18375 | 18375 | Adolphus Nelson N000029 | rep | WI | 1921-04-11 | 1923-03-03 | Republican | 11 | |||||||||||||
18376 | 18376 | Samuel Nicholson N000101 | sen | CO | 1921-04-11 | 1923-12-31 | 3 | Republican | |||||||||||||
18377 | 18377 | John Nolan N000124 | rep | CA | 1913-04-07 | 1915-03-03 | Republican | 5 | |||||||||||||
18378 | 18378 | John Nolan N000124 | rep | CA | 1915-12-06 | 1917-03-03 | Republican | 5 | |||||||||||||
18379 | 18379 | John Nolan N000124 | rep | CA | 1917-04-02 | 1919-03-03 | Republican | 5 | |||||||||||||
18380 | 18380 | John Nolan N000124 | rep | CA | 1919-05-19 | 1921-03-03 | Republican | 5 | |||||||||||||
18381 | 18381 | John Nolan N000124 | rep | CA | 1921-04-11 | 1923-03-03 | Republican | 5 | |||||||||||||
18382 | 18382 | Miner Norton N000154 | rep | OH | 1921-04-11 | 1923-03-03 | Republican | 20 | |||||||||||||
18383 | 18383 | Charles Ogden O000042 | rep | KY | 1919-05-19 | 1921-03-03 | Republican | 5 | |||||||||||||
18384 | 18384 | Charles Ogden O000042 | rep | KY | 1921-04-11 | 1923-03-03 | Republican | 5 | |||||||||||||
18385 | 18385 | Archibald Olpp O000082 | rep | NJ | 1921-04-11 | 1923-03-03 | Republican | 11 | |||||||||||||
18386 | 18386 | James Overstreet O000143 | rep | GA | 1905-12-04 | 1907-03-03 | Democrat | 1 | |||||||||||||
18387 | 18387 | James Overstreet O000143 | rep | GA | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
18388 | 18388 | James Overstreet O000143 | rep | GA | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
18389 | 18389 | James Overstreet O000143 | rep | GA | 1921-04-11 | 1923-03-03 | Democrat | 1 | |||||||||||||
18390 | 18390 | Lemuel Padgett P000012 | rep | TN | 1901-12-02 | 1903-03-03 | Democrat | 7 | |||||||||||||
18391 | 18391 | Lemuel Padgett P000012 | rep | TN | 1903-11-09 | 1905-03-03 | Democrat | 7 | |||||||||||||
18392 | 18392 | Lemuel Padgett P000012 | rep | TN | 1905-12-04 | 1907-03-03 | Democrat | 7 | |||||||||||||
18393 | 18393 | Lemuel Padgett P000012 | rep | TN | 1907-12-02 | 1909-03-03 | Democrat | 7 | |||||||||||||
18394 | 18394 | Lemuel Padgett P000012 | rep | TN | 1909-03-15 | 1911-03-03 | Democrat | 7 | |||||||||||||
18395 | 18395 | Lemuel Padgett P000012 | rep | TN | 1911-04-04 | 1913-03-03 | Democrat | 7 | |||||||||||||
18396 | 18396 | Lemuel Padgett P000012 | rep | TN | 1913-04-07 | 1915-03-03 | Democrat | 7 | |||||||||||||
18397 | 18397 | Lemuel Padgett P000012 | rep | TN | 1915-12-06 | 1917-03-03 | Democrat | 7 | |||||||||||||
18398 | 18398 | Lemuel Padgett P000012 | rep | TN | 1917-04-02 | 1919-03-03 | Democrat | 7 | |||||||||||||
18399 | 18399 | Lemuel Padgett P000012 | rep | TN | 1919-05-19 | 1921-03-03 | Democrat | 7 | |||||||||||||
18400 | 18400 | Lemuel Padgett P000012 | rep | TN | 1921-04-11 | 1923-03-03 | Democrat | 7 | |||||||||||||
18401 | 18401 | Richard Parker P000070 | rep | NJ | 1895-12-02 | 1897-03-03 | Republican | 6 | |||||||||||||
18402 | 18402 | Richard Parker P000070 | rep | NJ | 1897-03-15 | 1899-03-03 | Republican | 6 | |||||||||||||
18403 | 18403 | Richard Parker P000070 | rep | NJ | 1899-12-04 | 1901-03-03 | Republican | 6 | |||||||||||||
18404 | 18404 | Richard Parker P000070 | rep | NJ | 1901-12-02 | 1903-03-03 | Republican | 6 | |||||||||||||
18405 | 18405 | Richard Parker P000070 | rep | NJ | 1903-11-09 | 1905-03-03 | Republican | 7 | |||||||||||||
18406 | 18406 | Richard Parker P000070 | rep | NJ | 1905-12-04 | 1907-03-03 | Republican | 7 | |||||||||||||
18407 | 18407 | Richard Parker P000070 | rep | NJ | 1907-12-02 | 1909-03-03 | Republican | 7 | |||||||||||||
18408 | 18408 | Richard Parker P000070 | rep | NJ | 1909-03-15 | 1911-03-03 | Republican | 7 | |||||||||||||
18409 | 18409 | Richard Parker P000070 | rep | NJ | 1913-04-07 | 1915-03-03 | Republican | 9 | |||||||||||||
18410 | 18410 | Richard Parker P000070 | rep | NJ | 1915-12-06 | 1917-03-03 | Republican | 9 | |||||||||||||
18411 | 18411 | Richard Parker P000070 | rep | NJ | 1917-04-02 | 1919-03-03 | Republican | 9 | |||||||||||||
18412 | 18412 | Richard Parker P000070 | rep | NJ | 1921-04-11 | 1923-03-03 | Republican | 9 | |||||||||||||
18413 | 18413 | Lucian Parrish P000083 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 13 | |||||||||||||
18414 | 18414 | Lucian Parrish P000083 | rep | TX | 1921-04-11 | 1923-03-03 | Democrat | 13 | |||||||||||||
18415 | 18415 | John Paul P000143 | rep | VA | 1921-04-11 | 1923-03-03 | Republican | 7 | |||||||||||||
18416 | 18416 | John Peters P000253 | rep | ME | 1913-04-07 | 1915-03-03 | Republican | 3 | |||||||||||||
18417 | 18417 | John Peters P000253 | rep | ME | 1915-12-06 | 1917-03-03 | Republican | 3 | |||||||||||||
18418 | 18418 | John Peters P000253 | rep | ME | 1917-04-02 | 1919-03-03 | Republican | 3 | |||||||||||||
18419 | 18419 | John Peters P000253 | rep | ME | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
18420 | 18420 | John Peters P000253 | rep | ME | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
18421 | 18421 | Andrew Petersen P000257 | rep | NY | 1921-04-11 | 1923-03-03 | Republican | 9 | |||||||||||||
18422 | 18422 | Joseph Pringey P000542 | rep | OK | 1921-04-11 | 1923-03-03 | Republican | 4 | |||||||||||||
18423 | 18423 | Amos Radcliffe R000005 | rep | NJ | 1919-05-19 | 1921-03-03 | Republican | 7 | |||||||||||||
18424 | 18424 | Amos Radcliffe R000005 | rep | NJ | 1921-04-11 | 1923-03-03 | Republican | 7 | |||||||||||||
18425 | 18425 | Lilius Rainey R000017 | rep | AL | 1919-05-19 | 1921-03-03 | Democrat | 7 | |||||||||||||
18426 | 18426 | Lilius Rainey R000017 | rep | AL | 1921-04-11 | 1923-03-03 | Democrat | 7 | |||||||||||||
18427 | 18427 | Charles Reavis R000101 | rep | NE | 1915-12-06 | 1917-03-03 | Republican | 1 | |||||||||||||
18428 | 18428 | Charles Reavis R000101 | rep | NE | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
18429 | 18429 | Charles Reavis R000101 | rep | NE | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
18430 | 18430 | Charles Reavis R000101 | rep | NE | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
18431 | 18431 | John Reber R000102 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 12 | |||||||||||||
18432 | 18432 | John Reber R000102 | rep | PA | 1921-04-11 | 1923-03-03 | Republican | 12 | |||||||||||||
18433 | 18433 | Marion Rhodes R000190 | rep | MO | 1905-12-04 | 1907-03-03 | Republican | 13 | |||||||||||||
18434 | 18434 | Marion Rhodes R000190 | rep | MO | 1919-05-19 | 1921-03-03 | Republican | 13 |
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);