legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
485 rows where "end" is on date 1955-01-03 sorted by state
This data as json, copyable, CSV (advanced)
Suggested facets: party, start (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28776 | 28776 | Edward Bartlett B000201 | rep | AK | 1953-01-03 | 1955-01-03 | Democrat | 0 | |||||||||||||
25593 | 25593 | Laurie Battle B000242 | rep | AL | 1953-01-03 | 1955-01-03 | Democrat | 9 | |||||||||||||
27119 | 27119 | Frank Boykin B000725 | rep | AL | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
27765 | 27765 | Carl Elliott E000120 | rep | AL | 1953-01-03 | 1955-01-03 | Democrat | 7 | |||||||||||||
27824 | 27824 | George Grant G000381 | rep | AL | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
28099 | 28099 | Albert Rains R000018 | rep | AL | 1953-01-03 | 1955-01-03 | Democrat | 5 | |||||||||||||
28116 | 28116 | Kenneth Roberts R000314 | rep | AL | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
29031 | 29031 | Armistead Selden S000232 | rep | AL | 1953-01-03 | 1955-01-03 | Democrat | 6 | |||||||||||||
29549 | 29549 | George Andrews A000206 | rep | AL | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
30700 | 30700 | John Sparkman S000701 | sen | AL | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
31084 | 31084 | Robert Jones J000248 | rep | AL | 1953-01-03 | 1955-01-03 | Democrat | 8 | |||||||||||||
26375 | 26375 | Lawrence Hays H000405 | rep | AR | 1953-01-03 | 1955-01-03 | Democrat | 5 | |||||||||||||
27405 | 27405 | William Norrell N000137 | rep | AR | 1953-01-03 | 1955-01-03 | Democrat | 6 | |||||||||||||
28453 | 28453 | Oren Harris H000249 | rep | AR | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
28720 | 28720 | James Trimble T000373 | rep | AR | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
28852 | 28852 | Ezekiel Gathings G000098 | rep | AR | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
30566 | 30566 | John McClellan M000332 | sen | AR | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
31188 | 31188 | Wilbur Mills M000778 | rep | AR | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
25776 | 25776 | Harold Patten P000107 | rep | AZ | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
32823 | 32823 | John Rhodes R000188 | rep | AZ | 1953-01-03 | 1955-01-03 | Republican | 1 | |||||||||||||
25605 | 25605 | Ernest Bramblett B000762 | rep | CA | 1953-01-03 | 1955-01-03 | Republican | 13 | |||||||||||||
25638 | 25638 | Robert Condon C000674 | rep | CA | 1953-01-03 | 1955-01-03 | Democrat | 6 | |||||||||||||
25725 | 25725 | Allan Hunter H000979 | rep | CA | 1953-01-03 | 1955-01-03 | Republican | 12 | |||||||||||||
25782 | 25782 | C. Poulson P000475 | rep | CA | 1953-01-03 | 1955-01-03 | Republican | 24 | |||||||||||||
25845 | 25845 | Samuel Yorty Y000024 | rep | CA | 1953-01-03 | 1955-01-03 | Democrat | 26 | |||||||||||||
26001 | 26001 | John Hinshaw H000640 | rep | CA | 1953-01-03 | 1955-01-03 | Republican | 20 | |||||||||||||
26027 | 26027 | Justin Johnson J000157 | rep | CA | 1953-01-03 | 1955-01-03 | Republican | 11 | |||||||||||||
26083 | 26083 | John Phillips P000309 | rep | CA | 1953-01-03 | 1955-01-03 | Republican | 29 | |||||||||||||
26159 | 26159 | John Allen A000133 | rep | CA | 1953-01-03 | 1955-01-03 | Republican | 7 | |||||||||||||
26400 | 26400 | Patrick Hillings H000623 | rep | CA | 1953-01-03 | 1955-01-03 | Republican | 25 | |||||||||||||
26589 | 26589 | Hubert Scudder S000198 | rep | CA | 1953-01-03 | 1955-01-03 | Republican | 1 | |||||||||||||
26843 | 26843 | Clair Engle E000181 | rep | CA | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
26882 | 26882 | Joseph Holt H000746 | rep | CA | 1953-01-03 | 1955-01-03 | Republican | 22 | |||||||||||||
26889 | 26889 | Donald Jackson J000008 | rep | CA | 1953-01-03 | 1955-01-03 | Republican | 16 | |||||||||||||
27226 | 27226 | Edgar Hiestand H000568 | rep | CA | 1953-01-03 | 1955-01-03 | Republican | 21 | |||||||||||||
27360 | 27360 | Gordon McDonough M000414 | rep | CA | 1953-01-03 | 1955-01-03 | Republican | 15 | |||||||||||||
27756 | 27756 | Clyde Doyle D000481 | rep | CA | 1953-01-03 | 1955-01-03 | Democrat | 23 | |||||||||||||
28133 | 28133 | John Shelley S000327 | rep | CA | 1953-01-03 | 1955-01-03 | Democrat | 5 | |||||||||||||
28147 | 28147 | Harry Sheppard S000335 | rep | CA | 1953-01-03 | 1955-01-03 | Democrat | 27 | |||||||||||||
28439 | 28439 | Harlan Hagen H000013 | rep | CA | 1953-01-03 | 1955-01-03 | Democrat | 14 | |||||||||||||
28948 | 28948 | Cecil King K000196 | rep | CA | 1953-01-03 | 1955-01-03 | Democrat | 17 | |||||||||||||
29088 | 29088 | Jesse Younger Y000060 | rep | CA | 1953-01-03 | 1955-01-03 | Republican | 9 | |||||||||||||
29336 | 29336 | Glenard Lipscomb L000344 | rep | CA | 1953-01-03 | 1955-01-03 | Republican | 24 | |||||||||||||
29490 | 29490 | James Utt U000034 | rep | CA | 1953-01-03 | 1955-01-03 | Republican | 28 | |||||||||||||
29952 | 29952 | George Miller M000727 | rep | CA | 1953-01-03 | 1955-01-03 | Democrat | 8 | |||||||||||||
30433 | 30433 | Charles Gubser G000512 | rep | CA | 1953-01-03 | 1955-01-03 | Republican | 10 | |||||||||||||
30486 | 30486 | Chester Holifield H000713 | rep | CA | 1953-01-03 | 1955-01-03 | Democrat | 19 | |||||||||||||
30497 | 30497 | Craig Hosmer H000802 | rep | CA | 1953-01-03 | 1955-01-03 | Republican | 18 | |||||||||||||
30534 | 30534 | William Mailliard M000070 | rep | CA | 1953-01-03 | 1955-01-03 | Republican | 4 | |||||||||||||
31675 | 31675 | John Moss M001035 | rep | CA | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
32398 | 32398 | Robert Wilson W000610 | rep | CA | 1953-01-03 | 1955-01-03 | Republican | 30 | |||||||||||||
24867 | 24867 | Edwin Johnson J000127 | sen | CO | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
26396 | 26396 | William Hill H000613 | rep | CO | 1953-01-03 | 1955-01-03 | Republican | 2 | |||||||||||||
27715 | 27715 | John Chenoweth C000346 | rep | CO | 1953-01-03 | 1955-01-03 | Republican | 3 | |||||||||||||
29459 | 29459 | Byron Rogers R000389 | rep | CO | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
29561 | 29561 | Wayne Aspinall A000225 | rep | CO | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
26271 | 26271 | Albert Cretella C000905 | rep | CT | 1953-01-03 | 1955-01-03 | Republican | 3 | |||||||||||||
26534 | 26534 | Albert Morano M000935 | rep | CT | 1953-01-03 | 1955-01-03 | Republican | 4 | |||||||||||||
26558 | 26558 | James Patterson P000119 | rep | CT | 1953-01-03 | 1955-01-03 | Republican | 5 | |||||||||||||
26576 | 26576 | Antoni Sadlak S000009 | rep | CT | 1953-01-03 | 1955-01-03 | Republican | 0 | |||||||||||||
27523 | 27523 | Horace Seely-Brown S000224 | rep | CT | 1953-01-03 | 1955-01-03 | Republican | 2 | |||||||||||||
28414 | 28414 | Thomas Dodd D000390 | rep | CT | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
25824 | 25824 | Herbert Warburton W000123 | rep | DE | 1953-01-03 | 1955-01-03 | Republican | 0 | |||||||||||||
25964 | 25964 | Joseph Frear F000356 | sen | DE | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
25632 | 25632 | Courtney Campbell C000080 | rep | FL | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
25748 | 25748 | William Lantaff L000089 | rep | FL | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
25795 | 25795 | Dwight Rogers R000391 | rep | FL | 1953-01-03 | 1955-01-03 | Democrat | 6 | |||||||||||||
28550 | 28550 | Donald Matthews M000253 | rep | FL | 1953-01-03 | 1955-01-03 | Democrat | 8 | |||||||||||||
28897 | 28897 | Albert Herlong H000530 | rep | FL | 1953-01-03 | 1955-01-03 | Democrat | 5 | |||||||||||||
30957 | 30957 | James Haley H000041 | rep | FL | 1953-01-03 | 1955-01-03 | Democrat | 7 | |||||||||||||
31806 | 31806 | Robert Sikes S000406 | rep | FL | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
34235 | 34235 | Charles Bennett B000371 | rep | FL | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
25631 | 25631 | Albert Camp C000070 | rep | GA | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
25836 | 25836 | William Wheeler W000342 | rep | GA | 1953-01-03 | 1955-01-03 | Democrat | 8 | |||||||||||||
26472 | 26472 | Henderson Lanham L000077 | rep | GA | 1953-01-03 | 1955-01-03 | Democrat | 7 | |||||||||||||
26758 | 26758 | Paul Brown B000940 | rep | GA | 1953-01-03 | 1955-01-03 | Democrat | 10 | |||||||||||||
26943 | 26943 | Prince Preston P000516 | rep | GA | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
27173 | 27173 | James Davis D000109 | rep | GA | 1953-01-03 | 1955-01-03 | Democrat | 5 | |||||||||||||
27784 | 27784 | Elijah Forrester F000283 | rep | GA | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
28083 | 28083 | John Pilcher P000349 | rep | GA | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
28223 | 28223 | Carl Vinson V000105 | rep | GA | 1953-01-03 | 1955-01-03 | Democrat | 6 | |||||||||||||
29027 | 29027 | Richard Russell R000536 | sen | GA | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
31118 | 31118 | Phillip Landrum L000054 | rep | GA | 1953-01-03 | 1955-01-03 | Democrat | 9 | |||||||||||||
31556 | 31556 | John Flynt F000229 | rep | GA | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
25669 | 25669 | Joseph Farrington F000034 | rep | HI | 1953-01-03 | 1955-01-03 | Republican | 0 | |||||||||||||
25951 | 25951 | Mary Farrington F000035 | rep | HI | 1953-01-03 | 1955-01-03 | Republican | 0 | |||||||||||||
24835 | 24835 | Guy Gillette G000205 | sen | IA | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
25927 | 25927 | James Dolliver D000403 | rep | IA | 1953-01-03 | 1955-01-03 | Republican | 6 | |||||||||||||
26055 | 26055 | Thomas Martin M000199 | rep | IA | 1953-01-03 | 1955-01-03 | Republican | 1 | |||||||||||||
26280 | 26280 | Paul Cunningham C000993 | rep | IA | 1953-01-03 | 1955-01-03 | Republican | 5 | |||||||||||||
26489 | 26489 | Karl Le Compte L000157 | rep | IA | 1953-01-03 | 1955-01-03 | Republican | 4 | |||||||||||||
26629 | 26629 | Henry Talle T000028 | rep | IA | 1953-01-03 | 1955-01-03 | Republican | 2 | |||||||||||||
27890 | 27890 | Charles Hoeven H000678 | rep | IA | 1953-01-03 | 1955-01-03 | Republican | 8 | |||||||||||||
27922 | 27922 | Benton Jensen J000100 | rep | IA | 1953-01-03 | 1955-01-03 | Republican | 7 | |||||||||||||
30416 | 30416 | Harold Gross G000495 | rep | IA | 1953-01-03 | 1955-01-03 | Republican | 3 | |||||||||||||
26764 | 26764 | Hamer Budge B001035 | rep | ID | 1953-01-03 | 1955-01-03 | Republican | 2 | |||||||||||||
27189 | 27189 | Henry Dworshak D000585 | sen | ID | 1949-10-14 | 1955-01-03 | 2 | Republican | appointment | ||||||||||||
27411 | 27411 | Gracie Pfost P000287 | rep | ID | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
25600 | 25600 | Cecil Bishop B000486 | rep | IL | 1953-01-03 | 1955-01-03 | Republican | 25 | |||||||||||||
25620 | 25620 | Fred Busbey B001161 | rep | IL | 1953-01-03 | 1955-01-03 | Republican | 3 |
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);