legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
485 rows where "start" is on date 1947-01-03 sorted by district
This data as json, copyable, CSV (advanced)
Suggested facets: end, party, end (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24232 | 24232 | Raymond Baldwin B000095 | sen | CT | 1947-01-03 | 1949-12-16 | 1 | Republican | |||||||||||||
24243 | 24243 | Harry Cain C000021 | sen | WA | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
24285 | 24285 | Ralph Brewster B000816 | sen | ME | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
24322 | 24322 | Thomas Connally C000684 | sen | TX | 1947-01-03 | 1953-01-03 | 1 | Democrat | |||||||||||||
24369 | 24369 | Zales Ecton E000037 | sen | MT | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
24513 | 24513 | James Kem K000082 | sen | MO | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
24558 | 24558 | Henry Lodge L000394 | sen | MA | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
24601 | 24601 | Ernest McFarland M000438 | sen | AZ | 1947-01-03 | 1953-01-03 | 1 | Democrat | |||||||||||||
24603 | 24603 | James McGrath M000456 | sen | RI | 1947-01-03 | 1949-08-23 | 1 | Democrat | |||||||||||||
24612 | 24612 | Kenneth McKellar M000499 | sen | TN | 1947-01-03 | 1953-01-03 | 1 | Democrat | |||||||||||||
24624 | 24624 | Herbert O’Conor O000032 | sen | MD | 1947-01-03 | 1953-01-03 | 1 | Democrat | |||||||||||||
24711 | 24711 | Arthur Vandenberg V000025 | sen | MI | 1947-01-03 | 1951-04-18 | 1 | Republican | |||||||||||||
25606 | 25606 | John Bricker B000820 | sen | OH | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
25622 | 25622 | Hugh Butler B001177 | sen | NE | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
25671 | 25671 | Ralph Flanders F000190 | sen | VT | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
25726 | 25726 | Irving Ives I000050 | sen | NY | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
25729 | 25729 | William Jenner J000093 | sen | IN | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
25738 | 25738 | Harley Kilgore K000176 | sen | WV | 1947-01-03 | 1953-01-03 | 1 | Democrat | |||||||||||||
25741 | 25741 | William Knowland K000292 | sen | CA | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
25744 | 25744 | William Langer L000070 | sen | ND | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
25758 | 25758 | George Malone M000086 | sen | NV | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
25760 | 25760 | Edward Martin M000177 | sen | PA | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
25762 | 25762 | Joseph McCarthy M000315 | sen | WI | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
25810 | 25810 | Howard Smith S000553 | sen | NJ | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
25821 | 25821 | Edward Thye T000259 | sen | MN | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
25825 | 25825 | Arthur Watkins W000190 | sen | UT | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
25861 | 25861 | Joseph O’Mahoney O000088 | sen | WY | 1947-01-03 | 1953-01-03 | 1 | Democrat | |||||||||||||
26778 | 26778 | Harry Byrd B001208 | sen | VA | 1947-01-03 | 1953-01-03 | 1 | Democrat | |||||||||||||
26804 | 26804 | Dennis Chavez C000338 | sen | NM | 1947-01-03 | 1953-01-03 | 1 | Democrat | |||||||||||||
28470 | 28470 | Spessard Holland H000720 | sen | FL | 1947-01-03 | 1953-01-03 | 1 | Democrat | |||||||||||||
28739 | 28739 | John Williams W000518 | sen | DE | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
33155 | 33155 | John Stennis S000852 | sen | MS | 1947-01-03 | 1953-01-03 | 1 | Democrat | |||||||||||||
24454 | 24454 | Richard Harless H000212 | rep | AZ | 1947-01-03 | 1949-01-03 | Democrat | 0 | |||||||||||||
24570 | 24570 | Georgia Lusk L000519 | rep | NM | 1947-01-03 | 1949-01-03 | Democrat | 0 | |||||||||||||
24649 | 24649 | Charles Robertson R000319 | rep | ND | 1947-01-03 | 1949-01-03 | Republican | 0 | |||||||||||||
24670 | 24670 | Charles Russell R000522 | rep | NV | 1947-01-03 | 1949-01-03 | Republican | 0 | |||||||||||||
24688 | 24688 | William Stratton S000998 | rep | IL | 1947-01-03 | 1949-01-03 | Republican | 0 | |||||||||||||
24887 | 24887 | William Lemke L000238 | rep | ND | 1947-01-03 | 1949-01-03 | Republican | 0 | |||||||||||||
24999 | 24999 | Charles Plumley P000395 | rep | VT | 1947-01-03 | 1949-01-03 | Republican | 0 | |||||||||||||
25399 | 25399 | John Murdock M001081 | rep | AZ | 1947-01-03 | 1949-01-03 | Democrat | 0 | |||||||||||||
25587 | 25587 | Frank Barrett B000176 | rep | WY | 1947-01-03 | 1949-01-03 | Republican | 0 | |||||||||||||
25666 | 25666 | Joseph Farrington F000034 | rep | HI | 1947-01-03 | 1949-01-03 | Republican | 0 | |||||||||||||
25851 | 25851 | George Bender B000356 | rep | OH | 1947-01-03 | 1949-01-03 | Republican | 0 | |||||||||||||
25955 | 25955 | Antonio Fernández F000085 | rep | NM | 1947-01-03 | 1949-01-03 | Democrat | 0 | |||||||||||||
26573 | 26573 | Antoni Sadlak S000009 | rep | CT | 1947-01-03 | 1949-01-03 | Republican | 0 | |||||||||||||
27772 | 27772 | Antonio Fernós-Isern F000087 | rep | PR | 1947-01-03 | 1949-01-03 | Popular Democrat | 0 | |||||||||||||
28773 | 28773 | Edward Bartlett B000201 | rep | AK | 1947-01-03 | 1949-01-03 | Democrat | 0 | |||||||||||||
28782 | 28782 | James Boggs B000593 | rep | DE | 1947-01-03 | 1949-01-03 | Republican | 0 | |||||||||||||
24263 | 24263 | Samuel Arnold A000296 | rep | MO | 1947-01-03 | 1949-01-03 | Republican | 1 | |||||||||||||
24400 | 24400 | James Gallagher G000017 | rep | PA | 1947-01-03 | 1949-01-03 | Republican | 1 | |||||||||||||
24432 | 24432 | Abe Goff G000253 | rep | ID | 1947-01-03 | 1949-01-03 | Republican | 1 | |||||||||||||
24502 | 24502 | Homer Jones J000225 | rep | WA | 1947-01-03 | 1949-01-03 | Republican | 1 | |||||||||||||
24550 | 24550 | Clarence Lea L000163 | rep | CA | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
24559 | 24559 | Francis Love L000454 | rep | WV | 1947-01-03 | 1949-01-03 | Republican | 1 | |||||||||||||
24618 | 24618 | William Miller M000764 | rep | CT | 1947-01-03 | 1949-01-03 | Republican | 1 | |||||||||||||
24757 | 24757 | Schuyler Bland B000545 | rep | VA | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
24909 | 24909 | William Macy M000037 | rep | NY | 1947-01-03 | 1949-01-03 | Republican | 1 | |||||||||||||
24979 | 24979 | James Peterson P000261 | rep | FL | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
24990 | 24990 | Dayton Phillips P000306 | rep | TN | 1947-01-03 | 1949-01-03 | Republican | 1 | |||||||||||||
25016 | 25016 | George Sadowski S000011 | rep | MI | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
25182 | 25182 | Albert Cole C000606 | rep | KS | 1947-01-03 | 1949-01-03 | Republican | 1 | |||||||||||||
25253 | 25253 | Charles Elston E000160 | rep | OH | 1947-01-03 | 1949-01-03 | Republican | 1 | |||||||||||||
25288 | 25288 | Walter Granger G000379 | rep | UT | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
25446 | 25446 | John Rankin R000056 | rep | MS | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
25485 | 25485 | George Schwabe S000155 | rep | OK | 1947-01-03 | 1949-01-03 | Republican | 1 | |||||||||||||
26052 | 26052 | Thomas Martin M000199 | rep | IA | 1947-01-03 | 1949-01-03 | Republican | 1 | |||||||||||||
26172 | 26172 | August Andresen A000239 | rep | MN | 1947-01-03 | 1949-01-03 | Republican | 1 | |||||||||||||
26211 | 26211 | John Carroll C000189 | rep | CO | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
26339 | 26339 | Noble Gregory G000447 | rep | KY | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
26354 | 26354 | Robert Hale H000036 | rep | ME | 1947-01-03 | 1949-01-03 | Republican | 1 | |||||||||||||
26384 | 26384 | John Heselton H000549 | rep | MA | 1947-01-03 | 1949-01-03 | Republican | 1 | |||||||||||||
26527 | 26527 | Edward Miller M000724 | rep | MD | 1947-01-03 | 1949-01-03 | Republican | 1 | |||||||||||||
26614 | 26614 | Lawrence Smith S000585 | rep | WI | 1947-01-03 | 1949-01-03 | Republican | 1 | |||||||||||||
26685 | 26685 | Charles Wolverton W000683 | rep | NJ | 1947-01-03 | 1949-01-03 | Republican | 1 | |||||||||||||
26853 | 26853 | Aime Forand F000255 | rep | RI | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
26940 | 26940 | Prince Preston P000516 | rep | GA | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
27116 | 27116 | Frank Boykin B000725 | rep | AL | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
27372 | 27372 | Chester Merrow M000664 | rep | NH | 1947-01-03 | 1949-01-03 | Republican | 1 | |||||||||||||
28042 | 28042 | Albin Norblad N000133 | rep | OR | 1947-01-03 | 1949-01-03 | Republican | 1 | |||||||||||||
28333 | 28333 | Herbert Bonner B000621 | rep | NC | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
28849 | 28849 | Ezekiel Gathings G000098 | rep | AR | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
28992 | 28992 | Karl Mundt M001078 | rep | SD | 1947-01-03 | 1948-12-30 | Republican | 1 | |||||||||||||
29206 | 29206 | William Dawson D000158 | rep | IL | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
29446 | 29446 | Lucius Rivers R000280 | rep | SC | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
29904 | 29904 | Michael Mansfield M000113 | rep | MT | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
30268 | 30268 | Carl Curtis C001006 | rep | NE | 1947-01-03 | 1949-01-03 | Republican | 1 | |||||||||||||
31038 | 31038 | Felix Hébert H000437 | rep | LA | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
31145 | 31145 | Ray Madden M000039 | rep | IN | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
31261 | 31261 | John Patman P000103 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
24309 | 24309 | Charles Clason C000473 | rep | MA | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
24602 | 24602 | Robert McGarvey M000442 | rep | PA | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
24614 | 24614 | Hugh Meade M000617 | rep | MD | 1947-01-03 | 1949-01-03 | Democrat | 2 | |||||||||||||
24634 | 24634 | Emory Price P000524 | rep | FL | 1947-01-03 | 1949-01-03 | Democrat | 2 | |||||||||||||
24674 | 24674 | Max Schwabe S000156 | rep | MO | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
24677 | 24677 | Melvin Snyder S000670 | rep | WV | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
24863 | 24863 | John Jennings J000096 | rep | TN | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
24946 | 24946 | Earl Michener M000693 | rep | MI | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
25018 | 25018 | John Sanborn S000029 | rep | ID | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
25107 | 25107 | Earle Clements C000506 | rep | KY | 1947-01-03 | 1948-01-06 | Democrat | 2 | |||||||||||||
25161 | 25161 | Howard Buffett B001039 | rep | NE | 1947-01-03 | 1949-01-03 | Republican | 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);