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 sorted by party descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25111 | 25111 | Fred Aandahl A000001 | rep | ND | 1951-01-03 | 1953-01-03 | Republican | 0 | |||||||||||||
25126 | 25126 | John Anderson A000196 | rep | CA | 1951-01-03 | 1953-01-03 | Republican | 8 | |||||||||||||
25127 | 25127 | Orland Armstrong A000218 | rep | MO | 1951-01-03 | 1953-01-03 | Republican | 6 | |||||||||||||
25129 | 25129 | Claude Bakewell B000080 | rep | MO | 1951-01-03 | 1953-01-03 | Republican | 11 | |||||||||||||
25145 | 25145 | William Blackney B000515 | rep | MI | 1951-01-03 | 1953-01-03 | Republican | 6 | |||||||||||||
25154 | 25154 | Walter Brehm B000794 | rep | OH | 1951-01-03 | 1953-01-03 | Republican | 11 | |||||||||||||
25162 | 25162 | Howard Buffett B001039 | rep | NE | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
25170 | 25170 | John Butler B001179 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 44 | |||||||||||||
25184 | 25184 | Albert Cole C000606 | rep | KS | 1951-01-03 | 1953-01-03 | Republican | 1 | |||||||||||||
25211 | 25211 | Fred Crawford C000889 | rep | MI | 1951-01-03 | 1953-01-03 | Republican | 8 | |||||||||||||
25212 | 25212 | Harmar Denny D000249 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 29 | |||||||||||||
25234 | 25234 | James Duff D000516 | sen | PA | 1951-01-03 | 1957-01-03 | 3 | Republican | |||||||||||||
25248 | 25248 | Charles Eaton E000023 | rep | NJ | 1951-01-03 | 1953-01-03 | Republican | 5 | |||||||||||||
25255 | 25255 | Charles Elston E000160 | rep | OH | 1951-01-03 | 1953-01-03 | Republican | 1 | |||||||||||||
25261 | 25261 | Frank Fellows F000066 | rep | ME | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
25277 | 25277 | Wilson Gillette G000206 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 14 | |||||||||||||
25298 | 25298 | Edwin Hall H000050 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 37 | |||||||||||||
25305 | 25305 | Leonard Hall H000060 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
25326 | 25326 | Christian Herter H000548 | rep | MA | 1951-01-03 | 1953-01-03 | Republican | 10 | |||||||||||||
25334 | 25334 | Edward Jenison J000080 | rep | IL | 1951-01-03 | 1953-01-03 | Republican | 23 | |||||||||||||
25389 | 25389 | Eugene Millikin M000771 | sen | CO | 1951-01-03 | 1957-01-03 | 3 | Republican | |||||||||||||
25410 | 25410 | Reid Murray M001112 | rep | WI | 1951-01-03 | 1953-01-03 | Republican | 7 | |||||||||||||
25453 | 25453 | Robert Ross R000453 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 5 | |||||||||||||
25486 | 25486 | George Schwabe S000155 | rep | OK | 1951-01-03 | 1953-01-03 | Republican | 1 | |||||||||||||
25489 | 25489 | Hardie Scott S000172 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
25491 | 25491 | Edward Sittler S000461 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 23 | |||||||||||||
25500 | 25500 | Karl Stefan S000845 | rep | NE | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
25510 | 25510 | Lowell Stockman S000936 | rep | OR | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
25519 | 25519 | Robert Taft T000009 | sen | OH | 1951-01-03 | 1953-12-31 | 3 | Republican | |||||||||||||
25525 | 25525 | Charles Tobey T000289 | sen | NH | 1951-01-03 | 1953-12-31 | 3 | Republican | |||||||||||||
25530 | 25530 | Harry Towe T000320 | rep | NJ | 1951-01-03 | 1953-01-03 | Republican | 9 | |||||||||||||
25535 | 25535 | Richard Vail V000003 | rep | IL | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
25536 | 25536 | Albert Vaughn V000077 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 8 | |||||||||||||
25539 | 25539 | Herman Welker W000269 | sen | ID | 1951-01-03 | 1957-01-03 | 3 | Republican | |||||||||||||
25541 | 25541 | Thomas Werdel W000298 | rep | CA | 1951-01-03 | 1953-01-03 | Republican | 10 | |||||||||||||
25551 | 25551 | John Wood W000700 | rep | ID | 1951-01-03 | 1953-01-03 | Republican | 1 | |||||||||||||
25568 | 25568 | Roy Woodruff W000718 | rep | MI | 1951-01-03 | 1953-01-03 | Republican | 10 | |||||||||||||
25574 | 25574 | Charles Potter P000460 | rep | MI | 1951-01-03 | 1952-11-04 | Republican | 11 | |||||||||||||
25583 | 25583 | Homer Angell A000257 | rep | OR | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
25599 | 25599 | Cecil Bishop B000486 | rep | IL | 1951-01-03 | 1953-01-03 | Republican | 26 | |||||||||||||
25604 | 25604 | Ernest Bramblett B000762 | rep | CA | 1951-01-03 | 1953-01-03 | Republican | 11 | |||||||||||||
25619 | 25619 | Fred Busbey B001161 | rep | IL | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
25661 | 25661 | Wesley D’Ewart D000281 | rep | MT | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
25668 | 25668 | Joseph Farrington F000034 | rep | HI | 1951-01-03 | 1953-01-03 | Republican | 0 | |||||||||||||
25674 | 25674 | James Golden G000258 | rep | KY | 1951-01-03 | 1953-01-03 | Republican | 9 | |||||||||||||
25680 | 25680 | Angier Goodwin G000297 | rep | MA | 1951-01-03 | 1953-01-03 | Republican | 8 | |||||||||||||
25688 | 25688 | Louis Graham G000360 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 25 | |||||||||||||
25694 | 25694 | Harold Hagen H000014 | rep | MN | 1951-01-03 | 1953-01-03 | Republican | 9 | |||||||||||||
25722 | 25722 | Merlin Hull H000943 | rep | WI | 1951-01-03 | 1953-01-03 | Republican | 9 | |||||||||||||
25724 | 25724 | Allan Hunter H000979 | rep | CA | 1951-01-03 | 1953-01-03 | Republican | 9 | |||||||||||||
25732 | 25732 | Edgar Jonas J000207 | rep | IL | 1951-01-03 | 1953-01-03 | Republican | 12 | |||||||||||||
25735 | 25735 | Charles Kersten K000150 | rep | WI | 1951-01-03 | 1953-01-03 | Republican | 5 | |||||||||||||
25781 | 25781 | C. Poulson P000475 | rep | CA | 1951-01-03 | 1953-01-03 | Republican | 13 | |||||||||||||
25806 | 25806 | Paul Shafer S000277 | rep | MI | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
25831 | 25831 | Alvin Weichel W000252 | rep | OH | 1951-01-03 | 1953-01-03 | Republican | 13 | |||||||||||||
25852 | 25852 | George Bender B000356 | rep | OH | 1951-01-03 | 1953-01-03 | Republican | 0 | |||||||||||||
25902 | 25902 | Shepard Crumpacker C000960 | rep | IN | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
25926 | 25926 | James Dolliver D000403 | rep | IA | 1951-01-03 | 1953-01-03 | Republican | 6 | |||||||||||||
25938 | 25938 | George Dondero D000411 | rep | MI | 1951-01-03 | 1953-01-03 | Republican | 17 | |||||||||||||
25948 | 25948 | Mathew Ellsworth E000146 | rep | OR | 1951-01-03 | 1953-01-03 | Republican | 4 | |||||||||||||
25973 | 25973 | Ralph Gamble G000031 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 28 | |||||||||||||
25990 | 25990 | Thomas Hand H000154 | rep | NJ | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
26000 | 26000 | John Hinshaw H000640 | rep | CA | 1951-01-03 | 1953-01-03 | Republican | 20 | |||||||||||||
26004 | 26004 | Richard Hoffman H000689 | rep | IL | 1951-01-03 | 1953-01-03 | Republican | 10 | |||||||||||||
26019 | 26019 | Clifford Hope H000768 | rep | KS | 1951-01-03 | 1953-01-03 | Republican | 5 | |||||||||||||
26026 | 26026 | Justin Johnson J000157 | rep | CA | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
26033 | 26033 | Karl King K000208 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 8 | |||||||||||||
26045 | 26045 | Harold Lovre L000468 | rep | SD | 1951-01-03 | 1953-01-03 | Republican | 1 | |||||||||||||
26054 | 26054 | Thomas Martin M000199 | rep | IA | 1951-01-03 | 1953-01-03 | Republican | 1 | |||||||||||||
26074 | 26074 | Charles Nelson N000031 | rep | ME | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
26082 | 26082 | John Phillips P000309 | rep | CA | 1951-01-03 | 1953-01-03 | Republican | 22 | |||||||||||||
26101 | 26101 | Chauncey Reed R000111 | rep | IL | 1951-01-03 | 1953-01-03 | Republican | 14 | |||||||||||||
26125 | 26125 | Dewey Short S000377 | rep | MO | 1951-01-03 | 1953-01-03 | Republican | 7 | |||||||||||||
26128 | 26128 | Ruth Thompson T000216 | rep | MI | 1951-01-03 | 1953-01-03 | Republican | 9 | |||||||||||||
26133 | 26133 | Harold Velde V000082 | rep | IL | 1951-01-03 | 1953-01-03 | Republican | 18 | |||||||||||||
26146 | 26146 | Jesse Wolcott W000668 | rep | MI | 1951-01-03 | 1953-01-03 | Republican | 7 | |||||||||||||
26158 | 26158 | John Allen A000133 | rep | CA | 1951-01-03 | 1953-01-03 | Republican | 7 | |||||||||||||
26174 | 26174 | August Andresen A000239 | rep | MN | 1951-01-03 | 1953-01-03 | Republican | 1 | |||||||||||||
26178 | 26178 | John Beamer B000276 | rep | IN | 1951-01-03 | 1953-01-03 | Republican | 5 | |||||||||||||
26185 | 26185 | Charles Brownson B000964 | rep | IN | 1951-01-03 | 1953-01-03 | Republican | 11 | |||||||||||||
26195 | 26195 | Usher Burdick B001079 | rep | ND | 1951-01-03 | 1953-01-03 | Republican | 0 | |||||||||||||
26201 | 26201 | John Butler B001180 | sen | MD | 1951-01-03 | 1957-01-03 | 3 | Republican | |||||||||||||
26205 | 26205 | Homer Capehart C000128 | sen | IN | 1951-01-03 | 1957-01-03 | 3 | Republican | |||||||||||||
26207 | 26207 | Joseph Carrigg C000182 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 14 | |||||||||||||
26221 | 26221 | Francis Case C000221 | sen | SD | 1951-01-03 | 1957-01-03 | 3 | Republican | |||||||||||||
26234 | 26234 | Cliff Clevenger C000515 | rep | OH | 1951-01-03 | 1953-01-03 | Republican | 5 | |||||||||||||
26246 | 26246 | William Cole C000617 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 39 | |||||||||||||
26267 | 26267 | Frederic Coudert C000804 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 17 | |||||||||||||
26279 | 26279 | Paul Cunningham C000993 | rep | IA | 1951-01-03 | 1953-01-03 | Republican | 5 | |||||||||||||
26296 | 26296 | James Devereux D000278 | rep | MD | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
26322 | 26322 | Myron George G000129 | rep | KS | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
26348 | 26348 | Ralph Gwinn G000541 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 27 | |||||||||||||
26356 | 26356 | Robert Hale H000036 | rep | ME | 1951-01-03 | 1953-01-03 | Republican | 1 | |||||||||||||
26361 | 26361 | Cecil Harden H000182 | rep | IN | 1951-01-03 | 1953-01-03 | Republican | 6 | |||||||||||||
26365 | 26365 | Robert Harrison H000275 | rep | NE | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
26386 | 26386 | John Heselton H000549 | rep | MA | 1951-01-03 | 1953-01-03 | Republican | 1 | |||||||||||||
26395 | 26395 | William Hill H000613 | rep | CO | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
26399 | 26399 | Patrick Hillings H000623 | rep | CA | 1951-01-03 | 1953-01-03 | Republican | 12 | |||||||||||||
26407 | 26407 | Otis Holmes H000740 | rep | WA | 1951-01-03 | 1953-01-03 | Republican | 4 | |||||||||||||
26415 | 26415 | Benjamin James J000045 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 7 |
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);