legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
489 rows where "end" is on date 1963-01-03 sorted by state
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
27123 | 27123 | Frank Boykin B000725 | rep | AL | 1961-01-03 | 1963-01-03 | Democrat | 1 | |||||||||||||
27769 | 27769 | Carl Elliott E000120 | rep | AL | 1961-01-03 | 1963-01-03 | Democrat | 7 | |||||||||||||
27828 | 27828 | George Grant G000381 | rep | AL | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
27883 | 27883 | Joseph Hill H000598 | sen | AL | 1957-01-03 | 1963-01-03 | 3 | Democrat | |||||||||||||
27913 | 27913 | George Huddleston H000904 | rep | AL | 1961-01-03 | 1963-01-03 | Democrat | 9 | |||||||||||||
28103 | 28103 | Albert Rains R000018 | rep | AL | 1961-01-03 | 1963-01-03 | Democrat | 5 | |||||||||||||
28120 | 28120 | Kenneth Roberts R000314 | rep | AL | 1961-01-03 | 1963-01-03 | Democrat | 4 | |||||||||||||
29035 | 29035 | Armistead Selden S000232 | rep | AL | 1961-01-03 | 1963-01-03 | Democrat | 6 | |||||||||||||
29553 | 29553 | George Andrews A000206 | rep | AL | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
31088 | 31088 | Robert Jones J000248 | rep | AL | 1961-01-03 | 1963-01-03 | Democrat | 8 | |||||||||||||
27074 | 27074 | Thomas Alford A000105 | rep | AR | 1961-01-03 | 1963-01-03 | Democrat | 5 | |||||||||||||
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 | |||||||||||||
28457 | 28457 | Oren Harris H000249 | rep | AR | 1961-01-03 | 1963-01-03 | Democrat | 4 | |||||||||||||
28724 | 28724 | James Trimble T000373 | rep | AR | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
28856 | 28856 | Ezekiel Gathings G000098 | rep | AR | 1961-01-03 | 1963-01-03 | Democrat | 1 | |||||||||||||
29283 | 29283 | James Fulbright F000401 | sen | AR | 1957-01-03 | 1963-01-03 | 3 | Democrat | |||||||||||||
31192 | 31192 | Wilbur Mills M000778 | rep | AR | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
27572 | 27572 | Stewart Udall U000002 | rep | AZ | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
27856 | 27856 | Carl Hayden H000385 | sen | AZ | 1957-01-03 | 1963-01-03 | 3 | Democrat | |||||||||||||
32827 | 32827 | John Rhodes R000188 | rep | AZ | 1961-01-03 | 1963-01-03 | Republican | 1 | |||||||||||||
35013 | 35013 | Morris Udall U000001 | rep | AZ | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
27230 | 27230 | Edgar Hiestand H000568 | rep | CA | 1961-01-03 | 1963-01-03 | Republican | 21 | |||||||||||||
27364 | 27364 | Gordon McDonough M000414 | rep | CA | 1961-01-03 | 1963-01-03 | Republican | 15 | |||||||||||||
27381 | 27381 | Clement Miller M000719 | rep | CA | 1961-01-03 | 1963-01-03 | Democrat | 1 | |||||||||||||
27511 | 27511 | Dalip Saund S000075 | rep | CA | 1961-01-03 | 1963-01-03 | Democrat | 29 | |||||||||||||
27760 | 27760 | Clyde Doyle D000481 | rep | CA | 1961-01-03 | 1963-01-03 | Democrat | 23 | |||||||||||||
27975 | 27975 | Thomas Kuchel K000335 | sen | CA | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
28137 | 28137 | John Shelley S000327 | rep | CA | 1961-01-03 | 1963-01-03 | Democrat | 5 | |||||||||||||
28151 | 28151 | Harry Sheppard S000335 | rep | CA | 1961-01-03 | 1963-01-03 | Democrat | 27 | |||||||||||||
28313 | 28313 | John Baldwin B000092 | rep | CA | 1961-01-03 | 1963-01-03 | Republican | 6 | |||||||||||||
28443 | 28443 | Harlan Hagen H000013 | rep | CA | 1961-01-03 | 1963-01-03 | Democrat | 14 | |||||||||||||
28632 | 28632 | James Roosevelt R000426 | rep | CA | 1961-01-03 | 1963-01-03 | Democrat | 26 | |||||||||||||
28952 | 28952 | Cecil King K000196 | rep | CA | 1961-01-03 | 1963-01-03 | Democrat | 17 | |||||||||||||
29092 | 29092 | Jesse Younger Y000060 | rep | CA | 1961-01-03 | 1963-01-03 | Republican | 9 | |||||||||||||
29176 | 29176 | Jeffery Cohelan C000596 | rep | CA | 1961-01-03 | 1963-01-03 | Democrat | 7 | |||||||||||||
29340 | 29340 | Glenard Lipscomb L000344 | rep | CA | 1961-01-03 | 1963-01-03 | Republican | 24 | |||||||||||||
29494 | 29494 | James Utt U000034 | rep | CA | 1961-01-03 | 1963-01-03 | Republican | 28 | |||||||||||||
29956 | 29956 | George Miller M000727 | rep | CA | 1961-01-03 | 1963-01-03 | Democrat | 8 | |||||||||||||
30084 | 30084 | H. Smith S000545 | rep | CA | 1961-01-03 | 1963-01-03 | Republican | 20 | |||||||||||||
30437 | 30437 | Charles Gubser G000512 | rep | CA | 1961-01-03 | 1963-01-03 | Republican | 10 | |||||||||||||
30490 | 30490 | Chester Holifield H000713 | rep | CA | 1961-01-03 | 1963-01-03 | Democrat | 19 | |||||||||||||
30501 | 30501 | Craig Hosmer H000802 | rep | CA | 1961-01-03 | 1963-01-03 | Republican | 18 | |||||||||||||
30538 | 30538 | William Mailliard M000070 | rep | CA | 1961-01-03 | 1963-01-03 | Republican | 4 | |||||||||||||
30719 | 30719 | Charles Teague T000109 | rep | CA | 1961-01-03 | 1963-01-03 | Republican | 13 | |||||||||||||
30838 | 30838 | Alphonzo Bell B000330 | rep | CA | 1961-01-03 | 1963-01-03 | Republican | 16 | |||||||||||||
31650 | 31650 | John McFall M000436 | rep | CA | 1961-01-03 | 1963-01-03 | Democrat | 11 | |||||||||||||
31679 | 31679 | John Moss M001035 | rep | CA | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
31822 | 31822 | Bernice Sisk S000454 | rep | CA | 1961-01-03 | 1963-01-03 | Democrat | 12 | |||||||||||||
32000 | 32000 | James Corman C000780 | rep | CA | 1961-01-03 | 1963-01-03 | Democrat | 22 | |||||||||||||
32132 | 32132 | Harold Johnson J000135 | rep | CA | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
32402 | 32402 | Robert Wilson W000610 | rep | CA | 1961-01-03 | 1963-01-03 | Republican | 30 | |||||||||||||
32843 | 32843 | John Rousselot R000469 | rep | CA | 1961-01-03 | 1963-01-03 | Republican | 25 | |||||||||||||
26213 | 26213 | John Carroll C000189 | sen | CO | 1957-01-03 | 1963-01-03 | 3 | Democrat | |||||||||||||
27719 | 27719 | John Chenoweth C000346 | rep | CO | 1961-01-03 | 1963-01-03 | Republican | 3 | |||||||||||||
29220 | 29220 | Peter Dominick D000409 | rep | CO | 1961-01-03 | 1963-01-03 | Republican | 2 | |||||||||||||
29463 | 29463 | Byron Rogers R000389 | rep | CO | 1961-01-03 | 1963-01-03 | Democrat | 1 | |||||||||||||
29565 | 29565 | Wayne Aspinall A000225 | rep | CO | 1961-01-03 | 1963-01-03 | Democrat | 4 | |||||||||||||
26200 | 26200 | Prescott Bush B001167 | sen | CT | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
27303 | 27303 | Frank Kowalski K000320 | rep | CT | 1961-01-03 | 1963-01-03 | Democrat | 0 | |||||||||||||
27526 | 27526 | Horace Seely-Brown S000224 | rep | CT | 1961-01-03 | 1963-01-03 | Republican | 2 | |||||||||||||
28156 | 28156 | Abner Sibal S000395 | rep | CT | 1961-01-03 | 1963-01-03 | Republican | 4 | |||||||||||||
29199 | 29199 | Emilio Daddario D000001 | rep | CT | 1961-01-03 | 1963-01-03 | Democrat | 1 | |||||||||||||
29963 | 29963 | John Monagan M000847 | rep | CT | 1961-01-03 | 1963-01-03 | Democrat | 5 | |||||||||||||
32077 | 32077 | Robert Giaimo G000151 | rep | CT | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
28566 | 28566 | Harris McDowell M000418 | rep | DE | 1961-01-03 | 1963-01-03 | Democrat | 0 | |||||||||||||
28166 | 28166 | George Smathers S000505 | sen | FL | 1957-01-03 | 1963-01-03 | 3 | Democrat | |||||||||||||
28554 | 28554 | Donald Matthews M000253 | rep | FL | 1961-01-03 | 1963-01-03 | Democrat | 8 | |||||||||||||
28901 | 28901 | Albert Herlong H000530 | rep | FL | 1961-01-03 | 1963-01-03 | Democrat | 5 | |||||||||||||
29186 | 29186 | William Cramer C000869 | rep | FL | 1961-01-03 | 1963-01-03 | Republican | 1 | |||||||||||||
30961 | 30961 | James Haley H000041 | rep | FL | 1961-01-03 | 1963-01-03 | Democrat | 7 | |||||||||||||
31755 | 31755 | Paul Rogers R000401 | rep | FL | 1961-01-03 | 1963-01-03 | Democrat | 6 | |||||||||||||
31810 | 31810 | Robert Sikes S000406 | rep | FL | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
34239 | 34239 | Charles Bennett B000371 | rep | FL | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
34445 | 34445 | Dante Fascell F000041 | rep | FL | 1961-01-03 | 1963-01-03 | Democrat | 4 | |||||||||||||
27109 | 27109 | Iris Blitch B000561 | rep | GA | 1961-01-03 | 1963-01-03 | Democrat | 8 | |||||||||||||
27177 | 27177 | James Davis D000109 | rep | GA | 1961-01-03 | 1963-01-03 | Democrat | 5 | |||||||||||||
27788 | 27788 | Elijah Forrester F000283 | rep | GA | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
28087 | 28087 | John Pilcher P000349 | rep | GA | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
28227 | 28227 | Carl Vinson V000105 | rep | GA | 1961-01-03 | 1963-01-03 | Democrat | 6 | |||||||||||||
29817 | 29817 | George Hagan H000010 | rep | GA | 1961-01-03 | 1963-01-03 | Democrat | 1 | |||||||||||||
30286 | 30286 | John Davis D000122 | rep | GA | 1961-01-03 | 1963-01-03 | Democrat | 7 | |||||||||||||
31122 | 31122 | Phillip Landrum L000054 | rep | GA | 1961-01-03 | 1963-01-03 | Democrat | 9 | |||||||||||||
31342 | 31342 | Robert Stephens S000860 | rep | GA | 1961-01-03 | 1963-01-03 | Democrat | 10 | |||||||||||||
31381 | 31381 | Herman Talmadge T000035 | sen | GA | 1957-01-03 | 1963-01-03 | 3 | Democrat | |||||||||||||
31560 | 31560 | John Flynt F000229 | rep | GA | 1961-01-03 | 1963-01-03 | Democrat | 4 | |||||||||||||
26905 | 26905 | Oren Long L000425 | sen | HI | 1959-01-07 | 1963-01-03 | 3 | Democrat | |||||||||||||
39020 | 39020 | Daniel Inouye I000025 | rep | HI | 1961-01-03 | 1963-01-03 | Democrat | 0 | |||||||||||||
27162 | 27162 | Merwin Coad C000540 | rep | IA | 1961-01-03 | 1963-01-03 | Democrat | 6 | |||||||||||||
27659 | 27659 | James Bromwell B000867 | rep | IA | 1961-01-03 | 1963-01-03 | Republican | 2 | |||||||||||||
27869 | 27869 | Bourke Hickenlooper H000559 | sen | IA | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
27894 | 27894 | Charles Hoeven H000678 | rep | IA | 1961-01-03 | 1963-01-03 | Republican | 8 | |||||||||||||
27926 | 27926 | Benton Jensen J000100 | rep | IA | 1961-01-03 | 1963-01-03 | Republican | 7 | |||||||||||||
29879 | 29879 | John Kyl K000351 | rep | IA | 1961-01-03 | 1963-01-03 | Republican | 4 | |||||||||||||
30066 | 30066 | Frederick Schwengel S000161 | rep | IA | 1961-01-03 | 1963-01-03 | Republican | 1 | |||||||||||||
30420 | 30420 | Harold Gross G000495 | rep | IA | 1961-01-03 | 1963-01-03 | Republican | 3 | |||||||||||||
35583 | 35583 | Neal Smith S000596 | rep | IA | 1961-01-03 | 1963-01-03 | Democrat | 5 | |||||||||||||
27191 | 27191 | Henry Dworshak D000585 | sen | ID | 1961-01-03 | 1963-01-03 | 2 | Republican | |||||||||||||
27415 | 27415 | Gracie Pfost P000287 | rep | ID | 1961-01-03 | 1963-01-03 | Democrat | 1 | |||||||||||||
27841 | 27841 | Ralph Harding H000191 | rep | ID | 1961-01-03 | 1963-01-03 | Democrat | 2 |
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);