legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
484 rows where "start" is on date 1951-01-03
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
26442 | 26442 | Robert Kean K000029 | rep | NJ | 1951-01-03 | 1953-01-03 | Republican | 12 | |||||||||||||
26450 | 26450 | Bernard Kearney K000030 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 31 | |||||||||||||
26460 | 26460 | Augustine Kelley K000058 | rep | PA | 1951-01-03 | 1953-01-03 | Democrat | 27 | |||||||||||||
26471 | 26471 | Henderson Lanham L000077 | rep | GA | 1951-01-03 | 1953-01-03 | Democrat | 7 | |||||||||||||
26478 | 26478 | Henry Latham L000108 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
26488 | 26488 | Karl Le Compte L000157 | rep | IA | 1951-01-03 | 1953-01-03 | Republican | 4 | |||||||||||||
26500 | 26500 | Samuel McConnell M000354 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 16 | |||||||||||||
26510 | 26510 | J. McGregor M000460 | rep | OH | 1951-01-03 | 1953-01-03 | Republican | 17 | |||||||||||||
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 | |||||||||||||
26529 | 26529 | Edward Miller M000724 | rep | MD | 1951-01-03 | 1953-01-03 | Republican | 1 | |||||||||||||
26533 | 26533 | Albert Morano M000935 | rep | CT | 1951-01-03 | 1953-01-03 | Republican | 4 | |||||||||||||
26541 | 26541 | Donald Nicholson N000097 | rep | MA | 1951-01-03 | 1953-01-03 | Republican | 9 | |||||||||||||
26551 | 26551 | Joseph O’Hara O000056 | rep | MN | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
26557 | 26557 | James Patterson P000119 | rep | CT | 1951-01-03 | 1953-01-03 | Republican | 5 | |||||||||||||
26561 | 26561 | Edmund Radwan R000008 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 43 | |||||||||||||
26566 | 26566 | Edward Robeson R000329 | rep | VA | 1951-01-03 | 1953-01-03 | Democrat | 1 | |||||||||||||
26575 | 26575 | Antoni Sadlak S000009 | rep | CT | 1951-01-03 | 1953-01-03 | Republican | 0 | |||||||||||||
26583 | 26583 | Errett Scrivner S000194 | rep | KS | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
26588 | 26588 | Hubert Scudder S000198 | rep | CA | 1951-01-03 | 1953-01-03 | Republican | 1 | |||||||||||||
26592 | 26592 | Timothy Sheehan S000315 | rep | IL | 1951-01-03 | 1953-01-03 | Republican | 11 | |||||||||||||
26599 | 26599 | Alfred Sieminski S000405 | rep | NJ | 1951-01-03 | 1953-01-03 | Democrat | 13 | |||||||||||||
26607 | 26607 | Sidney Simpson S000437 | rep | IL | 1951-01-03 | 1953-01-03 | Republican | 20 | |||||||||||||
26616 | 26616 | Lawrence Smith S000585 | rep | WI | 1951-01-03 | 1953-01-03 | Republican | 1 | |||||||||||||
26628 | 26628 | Henry Talle T000028 | rep | IA | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
26639 | 26639 | John Vorys V000119 | rep | OH | 1951-01-03 | 1953-01-03 | Republican | 12 | |||||||||||||
26647 | 26647 | Charles Vursell V000125 | rep | IL | 1951-01-03 | 1953-01-03 | Republican | 24 | |||||||||||||
26663 | 26663 | Richard Wigglesworth W000450 | rep | MA | 1951-01-03 | 1953-01-03 | Republican | 13 | |||||||||||||
26669 | 26669 | Alexander Wiley W000465 | sen | WI | 1951-01-03 | 1957-01-03 | 3 | Republican | |||||||||||||
26671 | 26671 | William Williams W000549 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 35 | |||||||||||||
26687 | 26687 | Charles Wolverton W000683 | rep | NJ | 1951-01-03 | 1953-01-03 | Republican | 1 | |||||||||||||
26701 | 26701 | Leo Allen A000138 | rep | IL | 1951-01-03 | 1953-01-03 | Republican | 16 | |||||||||||||
26716 | 26716 | Graham Barden B000139 | rep | NC | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
26730 | 26730 | James Beall B000271 | rep | MD | 1951-01-03 | 1953-01-03 | Republican | 6 | |||||||||||||
26757 | 26757 | Paul Brown B000940 | rep | GA | 1951-01-03 | 1953-01-03 | Democrat | 10 | |||||||||||||
26763 | 26763 | Hamer Budge B001035 | rep | ID | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
26770 | 26770 | Alvin Bush B001165 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 15 | |||||||||||||
26787 | 26787 | Gordon Canfield C000113 | rep | NJ | 1951-01-03 | 1953-01-03 | Republican | 8 | |||||||||||||
26794 | 26794 | Albert Carnahan C000162 | rep | MO | 1951-01-03 | 1953-01-03 | Democrat | 8 | |||||||||||||
26817 | 26817 | Isidore Dollinger D000402 | rep | NY | 1951-01-03 | 1953-01-03 | Democrat | 24 | |||||||||||||
26832 | 26832 | Carl Durham D000571 | rep | NC | 1951-01-03 | 1953-01-03 | Democrat | 6 | |||||||||||||
26842 | 26842 | Clair Engle E000181 | rep | CA | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
26855 | 26855 | Aime Forand F000255 | rep | RI | 1951-01-03 | 1953-01-03 | Democrat | 1 | |||||||||||||
26876 | 26876 | William Hess H000550 | rep | OH | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
26888 | 26888 | Donald Jackson J000008 | rep | CA | 1951-01-03 | 1953-01-03 | Republican | 16 | |||||||||||||
26897 | 26897 | Kenneth Keating K000036 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 40 | |||||||||||||
26908 | 26908 | Russell Mack M000021 | rep | WA | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
26920 | 26920 | Toby Morris M000991 | rep | OK | 1951-01-03 | 1953-01-03 | Democrat | 6 | |||||||||||||
26933 | 26933 | James Polk P000408 | rep | OH | 1951-01-03 | 1953-01-03 | Democrat | 6 | |||||||||||||
26942 | 26942 | Prince Preston P000516 | rep | GA | 1951-01-03 | 1953-01-03 | Democrat | 1 | |||||||||||||
26966 | 26966 | Daniel Reed R000113 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 45 | |||||||||||||
26978 | 26978 | Edward Rees R000132 | rep | KS | 1951-01-03 | 1953-01-03 | Republican | 4 | |||||||||||||
26996 | 26996 | Edith Rogers R000392 | rep | MA | 1951-01-03 | 1953-01-03 | Republican | 5 | |||||||||||||
27009 | 27009 | Richard Simpson S000436 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 17 | |||||||||||||
27016 | 27016 | Wint Smith S000640 | rep | KS | 1951-01-03 | 1953-01-03 | Republican | 6 | |||||||||||||
27025 | 27025 | Dean Taylor T000070 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 33 | |||||||||||||
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 | |||||||||||||
27062 | 27062 | Hugh Addonizio A000054 | rep | NJ | 1951-01-03 | 1953-01-03 | Democrat | 11 | |||||||||||||
27081 | 27081 | Herman Andersen A000179 | rep | MN | 1951-01-03 | 1953-01-03 | Republican | 7 | |||||||||||||
27087 | 27087 | Victor Anfuso A000255 | rep | NY | 1951-01-03 | 1953-01-03 | Democrat | 8 | |||||||||||||
27094 | 27094 | Cleveland Bailey B000035 | rep | WV | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
27118 | 27118 | Frank Boykin B000725 | rep | AL | 1951-01-03 | 1953-01-03 | Democrat | 1 | |||||||||||||
27134 | 27134 | Overton Brooks B000884 | rep | LA | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
27148 | 27148 | Robert Chiperfield C000365 | rep | IL | 1951-01-03 | 1953-01-03 | Republican | 19 | |||||||||||||
27154 | 27154 | Marguerite Church C000389 | rep | IL | 1951-01-03 | 1953-01-03 | Republican | 13 | |||||||||||||
27172 | 27172 | James Davis D000109 | rep | GA | 1951-01-03 | 1953-01-03 | Democrat | 5 | |||||||||||||
27198 | 27198 | Ivor Fenton F000075 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 12 | |||||||||||||
27205 | 27205 | James Frazier F000353 | rep | TN | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
27219 | 27219 | Burr Harrison H000264 | rep | VA | 1951-01-03 | 1953-01-03 | Democrat | 7 | |||||||||||||
27239 | 27239 | Clare Hoffman H000683 | rep | MI | 1951-01-03 | 1953-01-03 | Republican | 4 | |||||||||||||
27250 | 27250 | Frank Ikard I000007 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 13 | |||||||||||||
27262 | 27262 | Walter Judd J000278 | rep | MN | 1951-01-03 | 1953-01-03 | Republican | 5 | |||||||||||||
27270 | 27270 | Carroll Kearns K000032 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 28 | |||||||||||||
27293 | 27293 | Paul Kilday K000171 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 20 | |||||||||||||
27309 | 27309 | Thomas Lane L000065 | rep | MA | 1951-01-03 | 1953-01-03 | Democrat | 7 | |||||||||||||
27318 | 27318 | Thaddeus Machrowicz M000014 | rep | MI | 1951-01-03 | 1953-01-03 | Democrat | 1 | |||||||||||||
27325 | 27325 | Peter Mack M000020 | rep | IL | 1951-01-03 | 1953-01-03 | Democrat | 21 | |||||||||||||
27337 | 27337 | Fred Marshall M000152 | rep | MN | 1951-01-03 | 1953-01-03 | Democrat | 6 | |||||||||||||
27350 | 27350 | Noah Mason M000224 | rep | IL | 1951-01-03 | 1953-01-03 | Republican | 15 | |||||||||||||
27359 | 27359 | Gordon McDonough M000414 | rep | CA | 1951-01-03 | 1953-01-03 | Republican | 15 | |||||||||||||
27374 | 27374 | Chester Merrow M000664 | rep | NH | 1951-01-03 | 1953-01-03 | Republican | 1 | |||||||||||||
27384 | 27384 | Morgan Moulder M001045 | rep | MO | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
27390 | 27390 | Walter Mumma M001077 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 18 | |||||||||||||
27404 | 27404 | William Norrell N000137 | rep | AR | 1951-01-03 | 1953-01-03 | Democrat | 6 | |||||||||||||
27423 | 27423 | Louis Rabaut R000001 | rep | MI | 1951-01-03 | 1953-01-03 | Democrat | 14 | |||||||||||||
27453 | 27453 | Samuel Rayburn R000082 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
27471 | 27471 | Brazilla Reece R000108 | rep | TN | 1951-01-03 | 1953-01-03 | Republican | 1 | |||||||||||||
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 | |||||||||||||
27527 | 27527 | Frank Smith S000533 | rep | MS | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
27543 | 27543 | Brent Spence S000717 | rep | KY | 1951-01-03 | 1953-01-03 | Democrat | 5 | |||||||||||||
27563 | 27563 | John Taber T000001 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 38 | |||||||||||||
27578 | 27578 | James Van Zandt V000069 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 22 | |||||||||||||
27596 | 27596 | John Kennedy K000107 | rep | MA | 1951-01-03 | 1953-01-03 | Democrat | 11 | |||||||||||||
27612 | 27612 | James Auchincloss A000227 | rep | NJ | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
27624 | 27624 | Howard Baker B000062 | rep | TN | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
27646 | 27646 | John Bennett B000377 | rep | MI | 1951-01-03 | 1953-01-03 | Republican | 12 | |||||||||||||
27671 | 27671 | Charles Buckley B001024 | rep | NY | 1951-01-03 | 1953-01-03 | Democrat | 25 | |||||||||||||
27693 | 27693 | Clarence Cannon C000117 | rep | MO | 1951-01-03 | 1953-01-03 | Democrat | 9 |
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);