legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
486 rows where "end" is on date 1953-01-03 sorted by district
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25535 | 25535 | Richard Vail V000003 | rep | IL | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
25661 | 25661 | Wesley D’Ewart D000281 | rep | MT | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
25775 | 25775 | Harold Patten P000107 | rep | AZ | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
25842 | 25842 | Garrett Withers W000658 | rep | KY | 1952-08-02 | 1953-01-03 | Democrat | 2 | |||||||||||||
25980 | 25980 | William Granahan G000369 | rep | PA | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
25990 | 25990 | Thomas Hand H000154 | rep | NJ | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
26074 | 26074 | Charles Nelson N000031 | rep | ME | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
26296 | 26296 | James Devereux D000278 | rep | MD | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
26395 | 26395 | William Hill H000613 | rep | CO | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
26551 | 26551 | Joseph O’Hara O000056 | rep | MN | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
26583 | 26583 | Errett Scrivner S000194 | rep | KS | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
26628 | 26628 | Henry Talle T000028 | rep | IA | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
26763 | 26763 | Hamer Budge B001035 | rep | ID | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
26842 | 26842 | Clair Engle E000181 | rep | CA | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
26876 | 26876 | William Hess H000550 | rep | OH | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
27384 | 27384 | Morgan Moulder M001045 | rep | MO | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
27481 | 27481 | John Riley R000260 | rep | SC | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
27522 | 27522 | Horace Seely-Brown S000224 | rep | CT | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
27624 | 27624 | Howard Baker B000062 | rep | TN | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
27823 | 27823 | George Grant G000381 | rep | AL | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
28006 | 28006 | George Meader M000620 | rep | MI | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
28835 | 28835 | John Fogarty F000233 | rep | RI | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
28868 | 28868 | Charles Halleck H000081 | rep | IN | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
28879 | 28879 | Porter Hardy H000197 | rep | VA | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
29149 | 29149 | Ellis Berry B000416 | rep | SD | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
29612 | 29612 | Thomas Boggs B000594 | rep | LA | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
30278 | 30278 | Glenn Davis D000102 | rep | WI | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
30880 | 30880 | Norris Cotton C000802 | rep | NH | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
31187 | 31187 | Wilbur Mills M000778 | rep | AR | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
32299 | 32299 | Harley Staggers S000778 | rep | WV | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
33004 | 33004 | Henry Jackson J000013 | rep | WA | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
34234 | 34234 | Charles Bennett B000371 | rep | FL | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
35647 | 35647 | Jamie Whitten W000428 | rep | MS | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
25149 | 25149 | Edward Breen B000792 | rep | OH | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
25261 | 25261 | Frank Fellows F000066 | rep | ME | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
25381 | 25381 | John McGuire M000465 | rep | CT | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
25489 | 25489 | Hardie Scott S000172 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
25500 | 25500 | Karl Stefan S000845 | rep | NE | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
25538 | 25538 | Philip Welch W000264 | rep | MO | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
25583 | 25583 | Homer Angell A000257 | rep | OR | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
25619 | 25619 | Fred Busbey B001161 | rep | IL | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
25806 | 25806 | Paul Shafer S000277 | rep | MI | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
25902 | 25902 | Shepard Crumpacker C000960 | rep | IN | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
26026 | 26026 | Justin Johnson J000157 | rep | CA | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
26322 | 26322 | Myron George G000129 | rep | KS | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
26365 | 26365 | Robert Harrison H000275 | rep | NE | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
26478 | 26478 | Henry Latham L000108 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
26716 | 26716 | Graham Barden B000139 | rep | NC | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
26908 | 26908 | Russell Mack M000021 | rep | WA | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
27041 | 27041 | Roy Wier W000446 | rep | MN | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
27051 | 27051 | Gardner Withrow W000663 | rep | WI | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
27094 | 27094 | Cleveland Bailey B000035 | rep | WV | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
27205 | 27205 | James Frazier F000353 | rep | TN | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
27527 | 27527 | Frank Smith S000533 | rep | MS | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
27612 | 27612 | James Auchincloss A000227 | rep | NJ | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
27714 | 27714 | John Chenoweth C000346 | rep | CO | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
27783 | 27783 | Elijah Forrester F000283 | rep | GA | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
27793 | 27793 | Julian Gary G000091 | rep | VA | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
27998 | 27998 | Clifford McIntire M000478 | rep | ME | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
28038 | 28038 | Thruston Morton M001022 | rep | KY | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
28124 | 28124 | Paul Schenck S000117 | rep | OH | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
28323 | 28323 | Lindley Beckworth B000296 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
28719 | 28719 | James Trimble T000373 | rep | AR | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
29079 | 29079 | Edwin Willis W000559 | rep | LA | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
29410 | 29410 | Philip Philbin P000303 | rep | MA | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
29548 | 29548 | George Andrews A000206 | rep | AL | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
29803 | 29803 | Edward Garmatz G000071 | rep | MD | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
30317 | 30317 | William Dorn D000434 | rep | SC | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
30415 | 30415 | Harold Gross G000495 | rep | IA | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
30805 | 30805 | Carl Albert A000073 | rep | OK | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
31805 | 31805 | Robert Sikes S000406 | rep | FL | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
25180 | 25180 | Louis Clemente C000504 | rep | NY | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
25311 | 25311 | Franck Havenner H000356 | rep | CA | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
25331 | 25331 | Theodore Irving I000037 | rep | MO | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
25516 | 25516 | Boyd Tackett T000005 | rep | AR | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
25614 | 25614 | Joseph Bryson B000999 | rep | SC | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
25630 | 25630 | Albert Camp C000070 | rep | GA | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
25711 | 25711 | Charles Howell H000858 | rep | NJ | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
25747 | 25747 | William Lantaff L000089 | rep | FL | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
25889 | 25889 | Maurice Burnside B001131 | rep | WV | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
25948 | 25948 | Mathew Ellsworth E000146 | rep | OR | 1951-01-03 | 1953-01-03 | Republican | 4 | |||||||||||||
26224 | 26224 | Earl Chudoff C000386 | rep | PA | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
26407 | 26407 | Otis Holmes H000740 | rep | WA | 1951-01-03 | 1953-01-03 | Republican | 4 | |||||||||||||
26488 | 26488 | Karl Le Compte L000157 | rep | IA | 1951-01-03 | 1953-01-03 | Republican | 4 | |||||||||||||
26515 | 26515 | William McVey M000609 | rep | IL | 1951-01-03 | 1953-01-03 | Republican | 4 | |||||||||||||
26523 | 26523 | Arthur Miller M000715 | rep | NE | 1951-01-03 | 1953-01-03 | Republican | 4 | |||||||||||||
26533 | 26533 | Albert Morano M000935 | rep | CT | 1951-01-03 | 1953-01-03 | Republican | 4 | |||||||||||||
26978 | 26978 | Edward Rees R000132 | rep | KS | 1951-01-03 | 1953-01-03 | Republican | 4 | |||||||||||||
27134 | 27134 | Overton Brooks B000884 | rep | LA | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
27239 | 27239 | Clare Hoffman H000683 | rep | MI | 1951-01-03 | 1953-01-03 | Republican | 4 | |||||||||||||
27453 | 27453 | Samuel Rayburn R000082 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
28115 | 28115 | Kenneth Roberts R000314 | rep | AL | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
28364 | 28364 | Frank Chelf C000342 | rep | KY | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
28382 | 28382 | Harold Cooley C000736 | rep | NC | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
28431 | 28431 | Albert Gore G000320 | rep | TN | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
28558 | 28558 | Eugene McCarthy M000311 | rep | MN | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
29103 | 29103 | Edwin Adair A000024 | rep | IN | 1951-01-03 | 1953-01-03 | Republican | 4 | |||||||||||||
29238 | 29238 | George Fallon F000012 | rep | MD | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
29513 | 29513 | Watkins Abbitt A000002 | rep | VA | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
29528 | 29528 | Thomas Abernethy A000016 | rep | MS | 1951-01-03 | 1953-01-03 | Democrat | 4 |
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);