legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
484 rows where "start" is on date 1961-01-03 sorted by end descending
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
27059 | 27059 | Maurine Neuberger N000052 | sen | OR | 1961-01-03 | 1967-01-03 | 2 | Democrat | |||||||||||||
27183 | 27183 | Paul Douglas D000456 | sen | IL | 1961-01-03 | 1967-01-03 | 2 | Democrat | |||||||||||||
27497 | 27497 | Absalom Robertson R000317 | sen | VA | 1961-01-03 | 1967-01-03 | 2 | Democrat | |||||||||||||
27505 | 27505 | Leverett Saltonstall S000021 | sen | MA | 1961-01-03 | 1967-01-03 | 2 | Republican | |||||||||||||
28755 | 28755 | Gordon Allott A000161 | sen | CO | 1961-01-03 | 1967-01-03 | 2 | Republican | |||||||||||||
28762 | 28762 | Clinton Anderson A000186 | sen | NM | 1961-01-03 | 1967-01-03 | 2 | Democrat | |||||||||||||
28780 | 28780 | Edward Bartlett B000201 | sen | AK | 1961-01-03 | 1967-01-03 | 2 | Democrat | |||||||||||||
28785 | 28785 | James Boggs B000593 | sen | DE | 1961-01-03 | 1967-01-03 | 2 | Republican | |||||||||||||
28805 | 28805 | John Cooper C000758 | sen | KY | 1961-01-03 | 1967-01-03 | 2 | Republican | |||||||||||||
28820 | 28820 | Allen Ellender E000112 | sen | LA | 1961-01-03 | 1967-01-03 | 2 | Democrat | |||||||||||||
28917 | 28917 | Benjamin Jordan J000267 | sen | NC | 1961-01-03 | 1967-01-03 | 2 | Democrat | |||||||||||||
28964 | 28964 | Jack Miller M000730 | sen | IA | 1961-01-03 | 1967-01-03 | 2 | Republican | |||||||||||||
28996 | 28996 | Karl Mundt M001078 | sen | SD | 1961-01-03 | 1967-01-03 | 2 | Republican | |||||||||||||
29029 | 29029 | Richard Russell R000536 | sen | GA | 1961-01-03 | 1967-01-03 | 2 | Democrat | |||||||||||||
29047 | 29047 | Margaret Smith S000590 | sen | ME | 1961-01-03 | 1967-01-03 | 2 | Republican | |||||||||||||
30229 | 30229 | Clifford Case C000220 | sen | NJ | 1961-01-03 | 1967-01-03 | 2 | Republican | |||||||||||||
30273 | 30273 | Carl Curtis C001006 | sen | NE | 1961-01-03 | 1967-01-03 | 2 | Republican | |||||||||||||
30341 | 30341 | James Eastland E000018 | sen | MS | 1961-01-03 | 1967-01-03 | 2 | Democrat | |||||||||||||
30568 | 30568 | John McClellan M000332 | sen | AR | 1961-01-03 | 1967-01-03 | 2 | Democrat | |||||||||||||
30579 | 30579 | Lee Metcalf M000671 | sen | MT | 1961-01-03 | 1967-01-03 | 2 | Democrat | |||||||||||||
30702 | 30702 | John Sparkman S000701 | sen | AL | 1961-01-03 | 1967-01-03 | 2 | Democrat | |||||||||||||
32249 | 32249 | Jennings Randolph R000046 | sen | WV | 1961-01-03 | 1967-01-03 | 2 | Democrat | |||||||||||||
32344 | 32344 | John Tower T000322 | sen | TX | 1961-01-03 | 1967-01-03 | 2 | Republican | |||||||||||||
34830 | 34830 | Claiborne Pell P000193 | sen | RI | 1961-01-03 | 1967-01-03 | 2 | Democrat | |||||||||||||
36421 | 36421 | J. Thurmond T000254 | sen | SC | 1961-01-03 | 1967-01-03 | 2 | Republican | [ { "start": "1961-01-03", "end": "1964-09-16", "party": "Democrat" }, { "start": "1964-09-16", "end": "1967-01-03", "party": "Republican" } ] |
||||||||||||
27366 | 27366 | Patrick McNamara M000582 | sen | MI | 1961-01-03 | 1966-04-30 | 2 | Democrat | |||||||||||||
31594 | 31594 | Hubert Humphrey H000953 | sen | MN | 1961-01-03 | 1964-12-29 | 2 | Democrat | |||||||||||||
27283 | 27283 | Carey Kefauver K000044 | sen | TN | 1961-01-03 | 1963-12-31 | 2 | Democrat | |||||||||||||
27286 | 27286 | Robert Kerr K000144 | sen | OK | 1961-01-03 | 1963-12-31 | 2 | Democrat | |||||||||||||
27067 | 27067 | Hugh Addonizio A000054 | rep | NJ | 1961-01-03 | 1963-01-03 | Democrat | 11 | |||||||||||||
27072 | 27072 | Hugh Alexander A000094 | rep | NC | 1961-01-03 | 1963-01-03 | Democrat | 9 | |||||||||||||
27074 | 27074 | Thomas Alford A000105 | rep | AR | 1961-01-03 | 1963-01-03 | Democrat | 5 | |||||||||||||
27086 | 27086 | Herman Andersen A000179 | rep | MN | 1961-01-03 | 1963-01-03 | Republican | 7 | |||||||||||||
27091 | 27091 | Victor Anfuso A000255 | rep | NY | 1961-01-03 | 1963-01-03 | Democrat | 8 | |||||||||||||
27099 | 27099 | Cleveland Bailey B000035 | rep | WV | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
27103 | 27103 | Perkins Bass B000222 | rep | NH | 1961-01-03 | 1963-01-03 | Republican | 2 | |||||||||||||
27109 | 27109 | Iris Blitch B000561 | rep | GA | 1961-01-03 | 1963-01-03 | Democrat | 8 | |||||||||||||
27123 | 27123 | Frank Boykin B000725 | rep | AL | 1961-01-03 | 1963-01-03 | Democrat | 1 | |||||||||||||
27126 | 27126 | James Breeding B000791 | rep | KS | 1961-01-03 | 1963-01-03 | Democrat | 5 | |||||||||||||
27139 | 27139 | Overton Brooks B000884 | rep | LA | 1961-01-03 | 1963-01-03 | Democrat | 4 | |||||||||||||
27141 | 27141 | Frank Burke B001090 | rep | KY | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
27153 | 27153 | Robert Chiperfield C000365 | rep | IL | 1961-01-03 | 1963-01-03 | Republican | 19 | |||||||||||||
27159 | 27159 | Marguerite Church C000389 | rep | IL | 1961-01-03 | 1963-01-03 | Republican | 13 | |||||||||||||
27162 | 27162 | Merwin Coad C000540 | rep | IA | 1961-01-03 | 1963-01-03 | Democrat | 6 | |||||||||||||
27164 | 27164 | Robert Cook C000725 | rep | OH | 1961-01-03 | 1963-01-03 | Democrat | 11 | |||||||||||||
27169 | 27169 | Laurence Curtis C001011 | rep | MA | 1961-01-03 | 1963-01-03 | Republican | 10 | |||||||||||||
27177 | 27177 | James Davis D000109 | rep | GA | 1961-01-03 | 1963-01-03 | Democrat | 5 | |||||||||||||
27180 | 27180 | Edwin Dooley D000425 | rep | NY | 1961-01-03 | 1963-01-03 | Republican | 26 | |||||||||||||
27184 | 27184 | Edwin Durno D000575 | rep | OR | 1961-01-03 | 1963-01-03 | Republican | 4 | |||||||||||||
27191 | 27191 | Henry Dworshak D000585 | sen | ID | 1961-01-03 | 1963-01-03 | 2 | Republican | |||||||||||||
27203 | 27203 | Ivor Fenton F000075 | rep | PA | 1961-01-03 | 1963-01-03 | Republican | 12 | |||||||||||||
27210 | 27210 | James Frazier F000353 | rep | TN | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
27211 | 27211 | Peter Garland G000069 | rep | ME | 1961-01-03 | 1963-01-03 | Republican | 1 | |||||||||||||
27215 | 27215 | Kathryn Granahan G000368 | rep | PA | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
27224 | 27224 | Burr Harrison H000264 | rep | VA | 1961-01-03 | 1963-01-03 | Democrat | 7 | |||||||||||||
27225 | 27225 | John Hickey H000561 | sen | WY | 1961-01-03 | 1963-01-03 | 2 | Democrat | appointment | ||||||||||||
27230 | 27230 | Edgar Hiestand H000568 | rep | CA | 1961-01-03 | 1963-01-03 | Republican | 21 | |||||||||||||
27244 | 27244 | Clare Hoffman H000683 | rep | MI | 1961-01-03 | 1963-01-03 | Republican | 4 | |||||||||||||
27249 | 27249 | Lester Holtzman H000753 | rep | NY | 1961-01-03 | 1963-01-03 | Democrat | 6 | |||||||||||||
27255 | 27255 | Frank Ikard I000007 | rep | TX | 1961-01-03 | 1963-01-03 | Democrat | 13 | |||||||||||||
27257 | 27257 | Thomas Johnson J000176 | rep | MD | 1961-01-03 | 1963-01-03 | Democrat | 1 | |||||||||||||
27267 | 27267 | Walter Judd J000278 | rep | MN | 1961-01-03 | 1963-01-03 | Republican | 5 | |||||||||||||
27275 | 27275 | Carroll Kearns K000032 | rep | PA | 1961-01-03 | 1963-01-03 | Republican | 24 | |||||||||||||
27298 | 27298 | Paul Kilday K000171 | rep | TX | 1961-01-03 | 1963-01-03 | Democrat | 20 | |||||||||||||
27301 | 27301 | Alvin Kitchin K000249 | rep | NC | 1961-01-03 | 1963-01-03 | Democrat | 8 | |||||||||||||
27303 | 27303 | Frank Kowalski K000320 | rep | CT | 1961-01-03 | 1963-01-03 | Democrat | 0 | |||||||||||||
27314 | 27314 | Thomas Lane L000065 | rep | MA | 1961-01-03 | 1963-01-03 | Democrat | 7 | |||||||||||||
27317 | 27317 | Joseph Loser L000446 | rep | TN | 1961-01-03 | 1963-01-03 | Democrat | 5 | |||||||||||||
27323 | 27323 | Thaddeus Machrowicz M000014 | rep | MI | 1961-01-03 | 1963-01-03 | Democrat | 1 | |||||||||||||
27330 | 27330 | Peter Mack M000020 | rep | IL | 1961-01-03 | 1963-01-03 | Democrat | 21 | |||||||||||||
27335 | 27335 | Donald Magnuson M000052 | rep | WA | 1961-01-03 | 1963-01-03 | Democrat | 7 | |||||||||||||
27342 | 27342 | Fred Marshall M000152 | rep | MN | 1961-01-03 | 1963-01-03 | Democrat | 6 | |||||||||||||
27355 | 27355 | Noah Mason M000224 | rep | IL | 1961-01-03 | 1963-01-03 | Republican | 15 | |||||||||||||
27364 | 27364 | Gordon McDonough M000414 | rep | CA | 1961-01-03 | 1963-01-03 | Republican | 15 | |||||||||||||
27368 | 27368 | Harold McSween M000605 | rep | LA | 1961-01-03 | 1963-01-03 | Democrat | 8 | |||||||||||||
27369 | 27369 | Walter McVey M000608 | rep | KS | 1961-01-03 | 1963-01-03 | Republican | 3 | |||||||||||||
27379 | 27379 | Chester Merrow M000664 | rep | NH | 1961-01-03 | 1963-01-03 | Republican | 1 | |||||||||||||
27381 | 27381 | Clement Miller M000719 | rep | CA | 1961-01-03 | 1963-01-03 | Democrat | 1 | |||||||||||||
27382 | 27382 | Tom Moorehead M000927 | rep | OH | 1961-01-03 | 1963-01-03 | Republican | 15 | |||||||||||||
27389 | 27389 | Morgan Moulder M001045 | rep | MO | 1961-01-03 | 1963-01-03 | Democrat | 11 | |||||||||||||
27395 | 27395 | Walter Mumma M001077 | rep | PA | 1961-01-03 | 1963-01-03 | Republican | 16 | |||||||||||||
27397 | 27397 | Catherine Norrell N000136 | rep | AR | 1961-01-03 | 1963-01-03 | Democrat | 6 | |||||||||||||
27409 | 27409 | William Norrell N000137 | rep | AR | 1961-01-03 | 1963-01-03 | Democrat | 6 | |||||||||||||
27410 | 27410 | Morris Peterson P000264 | rep | UT | 1961-01-03 | 1963-01-03 | Democrat | 1 | |||||||||||||
27415 | 27415 | Gracie Pfost P000287 | rep | ID | 1961-01-03 | 1963-01-03 | Democrat | 1 | |||||||||||||
27428 | 27428 | Louis Rabaut R000001 | rep | MI | 1961-01-03 | 1963-01-03 | Democrat | 14 | |||||||||||||
27433 | 27433 | John Ray R000077 | rep | NY | 1961-01-03 | 1963-01-03 | Republican | 15 | |||||||||||||
27458 | 27458 | Samuel Rayburn R000082 | rep | TX | 1961-01-03 | 1963-01-03 | Democrat | 4 | |||||||||||||
27476 | 27476 | Brazilla Reece R000108 | rep | TN | 1961-01-03 | 1963-01-03 | Republican | 1 | |||||||||||||
27477 | 27477 | Louise Reece R000109 | rep | TN | 1961-01-03 | 1963-01-03 | Republican | 1 | |||||||||||||
27478 | 27478 | Corinne Riley R000259 | rep | SC | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
27486 | 27486 | John Riley R000260 | rep | SC | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
27501 | 27501 | J. Rutherford R000547 | rep | TX | 1961-01-03 | 1963-01-03 | Democrat | 16 | |||||||||||||
27508 | 27508 | Alfred Santangelo S000057 | rep | NY | 1961-01-03 | 1963-01-03 | Democrat | 18 | |||||||||||||
27511 | 27511 | Dalip Saund S000075 | rep | CA | 1961-01-03 | 1963-01-03 | Democrat | 29 | |||||||||||||
27516 | 27516 | Gordon Scherer S000120 | rep | OH | 1961-01-03 | 1963-01-03 | Republican | 1 | |||||||||||||
27520 | 27520 | William Scranton S000193 | rep | PA | 1961-01-03 | 1963-01-03 | Republican | 10 | |||||||||||||
27526 | 27526 | Horace Seely-Brown S000224 | rep | CT | 1961-01-03 | 1963-01-03 | Republican | 2 | |||||||||||||
27532 | 27532 | Frank Smith S000533 | rep | MS | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
27548 | 27548 | Brent Spence S000717 | rep | KY | 1961-01-03 | 1963-01-03 | Democrat | 5 |
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);