legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
480 rows where "end" is on date 1959-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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28778 | 28778 | Edward Bartlett B000201 | rep | AK | 1957-01-03 | 1959-01-03 | Democrat | 0 | |||||||||||||
27121 | 27121 | Frank Boykin B000725 | rep | AL | 1957-01-03 | 1959-01-03 | Democrat | 1 | |||||||||||||
27767 | 27767 | Carl Elliott E000120 | rep | AL | 1957-01-03 | 1959-01-03 | Democrat | 7 | |||||||||||||
27826 | 27826 | George Grant G000381 | rep | AL | 1957-01-03 | 1959-01-03 | Democrat | 2 | |||||||||||||
27911 | 27911 | George Huddleston H000904 | rep | AL | 1957-01-03 | 1959-01-03 | Democrat | 9 | |||||||||||||
28101 | 28101 | Albert Rains R000018 | rep | AL | 1957-01-03 | 1959-01-03 | Democrat | 5 | |||||||||||||
28118 | 28118 | Kenneth Roberts R000314 | rep | AL | 1957-01-03 | 1959-01-03 | Democrat | 4 | |||||||||||||
29033 | 29033 | Armistead Selden S000232 | rep | AL | 1957-01-03 | 1959-01-03 | Democrat | 6 | |||||||||||||
29551 | 29551 | George Andrews A000206 | rep | AL | 1957-01-03 | 1959-01-03 | Democrat | 3 | |||||||||||||
31086 | 31086 | Robert Jones J000248 | rep | AL | 1957-01-03 | 1959-01-03 | Democrat | 8 | |||||||||||||
26377 | 26377 | Lawrence Hays H000405 | rep | AR | 1957-01-03 | 1959-01-03 | Democrat | 5 | |||||||||||||
27407 | 27407 | William Norrell N000137 | rep | AR | 1957-01-03 | 1959-01-03 | Democrat | 6 | |||||||||||||
28455 | 28455 | Oren Harris H000249 | rep | AR | 1957-01-03 | 1959-01-03 | Democrat | 4 | |||||||||||||
28722 | 28722 | James Trimble T000373 | rep | AR | 1957-01-03 | 1959-01-03 | Democrat | 3 | |||||||||||||
28854 | 28854 | Ezekiel Gathings G000098 | rep | AR | 1957-01-03 | 1959-01-03 | Democrat | 1 | |||||||||||||
31190 | 31190 | Wilbur Mills M000778 | rep | AR | 1957-01-03 | 1959-01-03 | Democrat | 2 | |||||||||||||
27570 | 27570 | Stewart Udall U000002 | rep | AZ | 1957-01-03 | 1959-01-03 | Democrat | 2 | |||||||||||||
32678 | 32678 | Barry Goldwater G000267 | sen | AZ | 1953-01-03 | 1959-01-03 | 1 | Republican | |||||||||||||
32825 | 32825 | John Rhodes R000188 | rep | AZ | 1957-01-03 | 1959-01-03 | Republican | 1 | |||||||||||||
25742 | 25742 | William Knowland K000292 | sen | CA | 1953-01-03 | 1959-01-03 | 1 | Republican | |||||||||||||
26161 | 26161 | John Allen A000133 | rep | CA | 1957-01-03 | 1959-01-03 | Republican | 7 | |||||||||||||
26402 | 26402 | Patrick Hillings H000623 | rep | CA | 1957-01-03 | 1959-01-03 | Republican | 25 | |||||||||||||
26591 | 26591 | Hubert Scudder S000198 | rep | CA | 1957-01-03 | 1959-01-03 | Republican | 1 | |||||||||||||
26845 | 26845 | Clair Engle E000181 | rep | CA | 1957-01-03 | 1959-01-03 | Democrat | 2 | |||||||||||||
26884 | 26884 | Joseph Holt H000746 | rep | CA | 1957-01-03 | 1959-01-03 | Republican | 22 | |||||||||||||
26891 | 26891 | Donald Jackson J000008 | rep | CA | 1957-01-03 | 1959-01-03 | Republican | 16 | |||||||||||||
27228 | 27228 | Edgar Hiestand H000568 | rep | CA | 1957-01-03 | 1959-01-03 | Republican | 21 | |||||||||||||
27362 | 27362 | Gordon McDonough M000414 | rep | CA | 1957-01-03 | 1959-01-03 | Republican | 15 | |||||||||||||
27509 | 27509 | Dalip Saund S000075 | rep | CA | 1957-01-03 | 1959-01-03 | Democrat | 29 | |||||||||||||
27758 | 27758 | Clyde Doyle D000481 | rep | CA | 1957-01-03 | 1959-01-03 | Democrat | 23 | |||||||||||||
28135 | 28135 | John Shelley S000327 | rep | CA | 1957-01-03 | 1959-01-03 | Democrat | 5 | |||||||||||||
28149 | 28149 | Harry Sheppard S000335 | rep | CA | 1957-01-03 | 1959-01-03 | Democrat | 27 | |||||||||||||
28311 | 28311 | John Baldwin B000092 | rep | CA | 1957-01-03 | 1959-01-03 | Republican | 6 | |||||||||||||
28441 | 28441 | Harlan Hagen H000013 | rep | CA | 1957-01-03 | 1959-01-03 | Democrat | 14 | |||||||||||||
28630 | 28630 | James Roosevelt R000426 | rep | CA | 1957-01-03 | 1959-01-03 | Democrat | 26 | |||||||||||||
28950 | 28950 | Cecil King K000196 | rep | CA | 1957-01-03 | 1959-01-03 | Democrat | 17 | |||||||||||||
29090 | 29090 | Jesse Younger Y000060 | rep | CA | 1957-01-03 | 1959-01-03 | Republican | 9 | |||||||||||||
29338 | 29338 | Glenard Lipscomb L000344 | rep | CA | 1957-01-03 | 1959-01-03 | Republican | 24 | |||||||||||||
29492 | 29492 | James Utt U000034 | rep | CA | 1957-01-03 | 1959-01-03 | Republican | 28 | |||||||||||||
29954 | 29954 | George Miller M000727 | rep | CA | 1957-01-03 | 1959-01-03 | Democrat | 8 | |||||||||||||
30082 | 30082 | H. Smith S000545 | rep | CA | 1957-01-03 | 1959-01-03 | Republican | 20 | |||||||||||||
30435 | 30435 | Charles Gubser G000512 | rep | CA | 1957-01-03 | 1959-01-03 | Republican | 10 | |||||||||||||
30488 | 30488 | Chester Holifield H000713 | rep | CA | 1957-01-03 | 1959-01-03 | Democrat | 19 | |||||||||||||
30499 | 30499 | Craig Hosmer H000802 | rep | CA | 1957-01-03 | 1959-01-03 | Republican | 18 | |||||||||||||
30536 | 30536 | William Mailliard M000070 | rep | CA | 1957-01-03 | 1959-01-03 | Republican | 4 | |||||||||||||
30717 | 30717 | Charles Teague T000109 | rep | CA | 1957-01-03 | 1959-01-03 | Republican | 13 | |||||||||||||
31648 | 31648 | John McFall M000436 | rep | CA | 1957-01-03 | 1959-01-03 | Democrat | 11 | |||||||||||||
31677 | 31677 | John Moss M001035 | rep | CA | 1957-01-03 | 1959-01-03 | Democrat | 3 | |||||||||||||
31820 | 31820 | Bernice Sisk S000454 | rep | CA | 1957-01-03 | 1959-01-03 | Democrat | 12 | |||||||||||||
32400 | 32400 | Robert Wilson W000610 | rep | CA | 1957-01-03 | 1959-01-03 | Republican | 30 | |||||||||||||
26398 | 26398 | William Hill H000613 | rep | CO | 1957-01-03 | 1959-01-03 | Republican | 2 | |||||||||||||
27717 | 27717 | John Chenoweth C000346 | rep | CO | 1957-01-03 | 1959-01-03 | Republican | 3 | |||||||||||||
29461 | 29461 | Byron Rogers R000389 | rep | CO | 1957-01-03 | 1959-01-03 | Democrat | 1 | |||||||||||||
29563 | 29563 | Wayne Aspinall A000225 | rep | CO | 1957-01-03 | 1959-01-03 | Democrat | 4 | |||||||||||||
25784 | 25784 | William Purtell P000575 | sen | CT | 1953-01-03 | 1959-01-03 | 1 | Republican | |||||||||||||
26273 | 26273 | Albert Cretella C000905 | rep | CT | 1957-01-03 | 1959-01-03 | Republican | 3 | |||||||||||||
26495 | 26495 | Edwin May M000274 | rep | CT | 1957-01-03 | 1959-01-03 | Republican | 1 | |||||||||||||
26536 | 26536 | Albert Morano M000935 | rep | CT | 1957-01-03 | 1959-01-03 | Republican | 4 | |||||||||||||
26560 | 26560 | James Patterson P000119 | rep | CT | 1957-01-03 | 1959-01-03 | Republican | 5 | |||||||||||||
26578 | 26578 | Antoni Sadlak S000009 | rep | CT | 1957-01-03 | 1959-01-03 | Republican | 0 | |||||||||||||
27525 | 27525 | Horace Seely-Brown S000224 | rep | CT | 1957-01-03 | 1959-01-03 | Republican | 2 | |||||||||||||
26369 | 26369 | Harry Haskell H000318 | rep | DE | 1957-01-03 | 1959-01-03 | Republican | 0 | |||||||||||||
28740 | 28740 | John Williams W000518 | sen | DE | 1953-01-03 | 1959-01-03 | 1 | Republican | |||||||||||||
28471 | 28471 | Spessard Holland H000720 | sen | FL | 1953-01-03 | 1959-01-03 | 1 | Democrat | |||||||||||||
28552 | 28552 | Donald Matthews M000253 | rep | FL | 1957-01-03 | 1959-01-03 | Democrat | 8 | |||||||||||||
28899 | 28899 | Albert Herlong H000530 | rep | FL | 1957-01-03 | 1959-01-03 | Democrat | 5 | |||||||||||||
29184 | 29184 | William Cramer C000869 | rep | FL | 1957-01-03 | 1959-01-03 | Republican | 1 | |||||||||||||
30959 | 30959 | James Haley H000041 | rep | FL | 1957-01-03 | 1959-01-03 | Democrat | 7 | |||||||||||||
31753 | 31753 | Paul Rogers R000401 | rep | FL | 1957-01-03 | 1959-01-03 | Democrat | 6 | |||||||||||||
31808 | 31808 | Robert Sikes S000406 | rep | FL | 1957-01-03 | 1959-01-03 | Democrat | 3 | |||||||||||||
34237 | 34237 | Charles Bennett B000371 | rep | FL | 1957-01-03 | 1959-01-03 | Democrat | 2 | |||||||||||||
34443 | 34443 | Dante Fascell F000041 | rep | FL | 1957-01-03 | 1959-01-03 | Democrat | 4 | |||||||||||||
26474 | 26474 | Henderson Lanham L000077 | rep | GA | 1957-01-03 | 1959-01-03 | Democrat | 7 | |||||||||||||
26760 | 26760 | Paul Brown B000940 | rep | GA | 1957-01-03 | 1959-01-03 | Democrat | 10 | |||||||||||||
26916 | 26916 | Harlan Mitchell M000812 | rep | GA | 1957-01-03 | 1959-01-03 | Democrat | 7 | |||||||||||||
26945 | 26945 | Prince Preston P000516 | rep | GA | 1957-01-03 | 1959-01-03 | Democrat | 1 | |||||||||||||
27107 | 27107 | Iris Blitch B000561 | rep | GA | 1957-01-03 | 1959-01-03 | Democrat | 8 | |||||||||||||
27175 | 27175 | James Davis D000109 | rep | GA | 1957-01-03 | 1959-01-03 | Democrat | 5 | |||||||||||||
27786 | 27786 | Elijah Forrester F000283 | rep | GA | 1957-01-03 | 1959-01-03 | Democrat | 3 | |||||||||||||
28085 | 28085 | John Pilcher P000349 | rep | GA | 1957-01-03 | 1959-01-03 | Democrat | 2 | |||||||||||||
28225 | 28225 | Carl Vinson V000105 | rep | GA | 1957-01-03 | 1959-01-03 | Democrat | 6 | |||||||||||||
31120 | 31120 | Phillip Landrum L000054 | rep | GA | 1957-01-03 | 1959-01-03 | Democrat | 9 | |||||||||||||
31558 | 31558 | John Flynt F000229 | rep | GA | 1957-01-03 | 1959-01-03 | Democrat | 4 | |||||||||||||
26768 | 26768 | John Burns B001127 | rep | HI | 1957-01-03 | 1959-01-03 | Democrat | 0 | |||||||||||||
26282 | 26282 | Paul Cunningham C000993 | rep | IA | 1957-01-03 | 1959-01-03 | Republican | 5 | |||||||||||||
26491 | 26491 | Karl Le Compte L000157 | rep | IA | 1957-01-03 | 1959-01-03 | Republican | 4 | |||||||||||||
26631 | 26631 | Henry Talle T000028 | rep | IA | 1957-01-03 | 1959-01-03 | Republican | 2 | |||||||||||||
27160 | 27160 | Merwin Coad C000540 | rep | IA | 1957-01-03 | 1959-01-03 | Democrat | 6 | |||||||||||||
27892 | 27892 | Charles Hoeven H000678 | rep | IA | 1957-01-03 | 1959-01-03 | Republican | 8 | |||||||||||||
27924 | 27924 | Benton Jensen J000100 | rep | IA | 1957-01-03 | 1959-01-03 | Republican | 7 | |||||||||||||
30064 | 30064 | Frederick Schwengel S000161 | rep | IA | 1957-01-03 | 1959-01-03 | Republican | 1 | |||||||||||||
30418 | 30418 | Harold Gross G000495 | rep | IA | 1957-01-03 | 1959-01-03 | Republican | 3 | |||||||||||||
26766 | 26766 | Hamer Budge B001035 | rep | ID | 1957-01-03 | 1959-01-03 | Republican | 2 | |||||||||||||
27413 | 27413 | Gracie Pfost P000287 | rep | ID | 1957-01-03 | 1959-01-03 | Democrat | 1 | |||||||||||||
26184 | 26184 | James Bowler B000698 | rep | IL | 1957-01-03 | 1959-01-03 | Democrat | 7 | |||||||||||||
26203 | 26203 | Emmet Byrne B001211 | rep | IL | 1957-01-03 | 1959-01-03 | Republican | 3 | |||||||||||||
26333 | 26333 | Thomas Gordon G000316 | rep | IL | 1957-01-03 | 1959-01-03 | Democrat | 8 | |||||||||||||
26454 | 26454 | Russell Keeney K000042 | rep | IL | 1957-01-03 | 1959-01-03 | Republican | 14 | |||||||||||||
26518 | 26518 | William McVey M000609 | rep | IL | 1957-01-03 | 1959-01-03 | Republican | 4 | |||||||||||||
26595 | 26595 | Timothy Sheehan S000315 | rep | IL | 1957-01-03 | 1959-01-03 | Republican | 11 |
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);