legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
478 rows where "start" is on date 1971-01-21
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
31063 | 31063 | John Jarman J000057 | rep | OK | 1971-01-21 | 1973-01-03 | Democrat | 5 | |||||||||||||
31078 | 31078 | Albert Johnson J000115 | rep | PA | 1971-01-21 | 1973-01-03 | Republican | 23 | |||||||||||||
31093 | 31093 | Robert Jones J000248 | rep | AL | 1971-01-21 | 1973-01-03 | Democrat | 8 | |||||||||||||
31102 | 31102 | Joseph Karth K000014 | rep | MN | 1971-01-21 | 1973-01-03 | Democrat | 4 | |||||||||||||
31115 | 31115 | John Kluczynski K000273 | rep | IL | 1971-01-21 | 1973-01-03 | Democrat | 5 | |||||||||||||
31127 | 31127 | Phillip Landrum L000054 | rep | GA | 1971-01-21 | 1973-01-03 | Democrat | 9 | |||||||||||||
31140 | 31140 | Torbert Macdonald M000005 | rep | MA | 1971-01-21 | 1973-01-03 | Democrat | 7 | |||||||||||||
31157 | 31157 | Ray Madden M000039 | rep | IN | 1971-01-21 | 1973-01-03 | Democrat | 1 | |||||||||||||
31171 | 31171 | John McCollister M000349 | rep | NE | 1971-01-21 | 1973-01-03 | Republican | 2 | |||||||||||||
31197 | 31197 | Wilbur Mills M000778 | rep | AR | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
31214 | 31214 | Thomas Morgan M000958 | rep | PA | 1971-01-21 | 1973-01-03 | Democrat | 26 | |||||||||||||
31222 | 31222 | Charles Mosher M001031 | rep | OH | 1971-01-21 | 1973-01-03 | Republican | 13 | |||||||||||||
31234 | 31234 | James O’Hara O000055 | rep | MI | 1971-01-21 | 1973-01-03 | Democrat | 12 | |||||||||||||
31249 | 31249 | Otto Passman P000098 | rep | LA | 1971-01-21 | 1973-01-03 | Democrat | 5 | |||||||||||||
31273 | 31273 | John Patman P000103 | rep | TX | 1971-01-21 | 1973-01-03 | Democrat | 1 | |||||||||||||
31278 | 31278 | Jerry Pettis P000272 | rep | CA | 1971-01-21 | 1973-01-03 | Republican | 33 | |||||||||||||
31287 | 31287 | William Randall R000041 | rep | MO | 1971-01-21 | 1973-01-03 | Democrat | 4 | |||||||||||||
31293 | 31293 | Thomas Rees R000134 | rep | CA | 1971-01-21 | 1973-01-03 | Democrat | 26 | |||||||||||||
31306 | 31306 | John Roush R000467 | rep | IN | 1971-01-21 | 1973-01-03 | Democrat | 4 | |||||||||||||
31315 | 31315 | Herman Schneebeli S000135 | rep | PA | 1971-01-21 | 1973-01-03 | Republican | 17 | |||||||||||||
31329 | 31329 | Garner Shriver S000388 | rep | KS | 1971-01-21 | 1973-01-03 | Republican | 4 | |||||||||||||
31332 | 31332 | James Stanton S000803 | rep | OH | 1971-01-21 | 1973-01-03 | Democrat | 20 | |||||||||||||
31339 | 31339 | Sam Steiger S000846 | rep | AZ | 1971-01-21 | 1973-01-03 | Republican | 3 | |||||||||||||
31347 | 31347 | Robert Stephens S000860 | rep | GA | 1971-01-21 | 1973-01-03 | Democrat | 10 | |||||||||||||
31355 | 31355 | Williamson Stuckey S001039 | rep | GA | 1971-01-21 | 1973-01-03 | Democrat | 8 | |||||||||||||
31367 | 31367 | Leonor Sullivan S001057 | rep | MO | 1971-01-21 | 1973-01-03 | Democrat | 3 | |||||||||||||
31371 | 31371 | James Symington S001134 | rep | MO | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
31378 | 31378 | Burt Talcott T000022 | rep | CA | 1971-01-21 | 1973-01-03 | Republican | 12 | |||||||||||||
31391 | 31391 | Roy Taylor T000099 | rep | NC | 1971-01-21 | 1973-01-03 | Democrat | 11 | |||||||||||||
31399 | 31399 | Joseph Vigorito V000098 | rep | PA | 1971-01-21 | 1973-01-03 | Democrat | 24 | |||||||||||||
31408 | 31408 | Pierre du Pont D000558 | rep | DE | 1971-01-21 | 1973-01-03 | Republican | 0 | |||||||||||||
31415 | 31415 | Herman Badillo B000025 | rep | NY | 1971-01-21 | 1973-01-03 | Democrat | 21 | |||||||||||||
31419 | 31419 | Robert Bergland B000408 | rep | MN | 1971-01-21 | 1973-01-03 | Democrat | 7 | |||||||||||||
31430 | 31430 | Garry Brown B000917 | rep | MI | 1971-01-21 | 1973-01-03 | Republican | 3 | |||||||||||||
31436 | 31436 | J. Burke B001091 | rep | FL | 1971-01-21 | 1973-01-03 | Republican | 10 | |||||||||||||
31446 | 31446 | James Burke B001092 | rep | MA | 1971-01-21 | 1973-01-03 | Democrat | 11 | |||||||||||||
31465 | 31465 | Omar Burleson B001111 | rep | TX | 1971-01-21 | 1973-01-03 | Democrat | 17 | |||||||||||||
31470 | 31470 | Harry Byrd B001209 | sen | VA | 1971-01-21 | 1977-01-03 | 1 | Independent | |||||||||||||
31472 | 31472 | Goodloe Byron B001221 | rep | MD | 1971-01-21 | 1973-01-03 | Democrat | 6 | |||||||||||||
31478 | 31478 | Howard Cannon C000120 | sen | NV | 1971-01-21 | 1977-01-03 | 1 | Democrat | |||||||||||||
31482 | 31482 | Charles Carney C000164 | rep | OH | 1971-01-21 | 1973-01-03 | Democrat | 19 | |||||||||||||
31495 | 31495 | Elford Cederberg C000263 | rep | MI | 1971-01-21 | 1973-01-03 | Republican | 10 | |||||||||||||
31503 | 31503 | Delwin Clawson C000476 | rep | CA | 1971-01-21 | 1973-01-03 | Republican | 23 | |||||||||||||
31523 | 31523 | James Delaney D000211 | rep | NY | 1971-01-21 | 1973-01-03 | Democrat | 9 | |||||||||||||
31534 | 31534 | John Dent D000255 | rep | PA | 1971-01-21 | 1973-01-03 | Democrat | 21 | |||||||||||||
31540 | 31540 | Joshua Eilberg E000096 | rep | PA | 1971-01-21 | 1973-01-03 | Democrat | 4 | |||||||||||||
31547 | 31547 | Frank Evans E000240 | rep | CO | 1971-01-21 | 1973-01-03 | Democrat | 3 | |||||||||||||
31552 | 31552 | Walter Flowers F000218 | rep | AL | 1971-01-21 | 1973-01-03 | Democrat | 5 | |||||||||||||
31565 | 31565 | John Flynt F000229 | rep | GA | 1971-01-21 | 1973-01-03 | Democrat | 6 | |||||||||||||
31573 | 31573 | Donald Fraser F000350 | rep | MN | 1971-01-21 | 1973-01-03 | Democrat | 5 | |||||||||||||
31578 | 31578 | Louis Frey F000381 | rep | FL | 1971-01-21 | 1973-01-03 | Republican | 5 | |||||||||||||
31586 | 31586 | Michael Harrington H000230 | rep | MA | 1971-01-21 | 1973-01-03 | Democrat | 6 | |||||||||||||
31595 | 31595 | Hubert Humphrey H000953 | sen | MN | 1971-01-21 | 1977-01-03 | 1 | Democrat | |||||||||||||
31606 | 31606 | Edward Koch K000302 | rep | NY | 1971-01-21 | 1973-01-03 | Democrat | 17 | |||||||||||||
31617 | 31617 | Robert Leggett L000221 | rep | CA | 1971-01-21 | 1973-01-03 | Democrat | 4 | |||||||||||||
31639 | 31639 | George Mahon M000065 | rep | TX | 1971-01-21 | 1973-01-03 | Democrat | 19 | |||||||||||||
31644 | 31644 | James Mann M000105 | rep | SC | 1971-01-21 | 1973-01-03 | Democrat | 4 | |||||||||||||
31655 | 31655 | John McFall M000436 | rep | CA | 1971-01-21 | 1973-01-03 | Democrat | 15 | |||||||||||||
31662 | 31662 | Lloyd Meeds M000626 | rep | WA | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
31666 | 31666 | Ralph Metcalfe M000675 | rep | IL | 1971-01-21 | 1973-01-03 | Democrat | 1 | |||||||||||||
31684 | 31684 | John Moss M001035 | rep | CA | 1971-01-21 | 1973-01-03 | Democrat | 3 | |||||||||||||
31690 | 31690 | Edmund Muskie M001121 | sen | ME | 1971-01-21 | 1977-01-03 | 1 | Democrat | |||||||||||||
31701 | 31701 | Robert Nix N000113 | rep | PA | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
31714 | 31714 | Otis Pike P000348 | rep | NY | 1971-01-21 | 1973-01-03 | Democrat | 1 | |||||||||||||
31735 | 31735 | William Poage P000398 | rep | TX | 1971-01-21 | 1973-01-03 | Democrat | 11 | |||||||||||||
31746 | 31746 | Albert Quie Q000010 | rep | MN | 1971-01-21 | 1973-01-03 | Republican | 1 | |||||||||||||
31760 | 31760 | Paul Rogers R000401 | rep | FL | 1971-01-21 | 1973-01-03 | Democrat | 9 | |||||||||||||
31765 | 31765 | Teno Roncalio R000421 | rep | WY | 1971-01-21 | 1973-01-03 | Democrat | 0 | |||||||||||||
31773 | 31773 | Frederick Rooney R000423 | rep | PA | 1971-01-21 | 1973-01-03 | Democrat | 15 | |||||||||||||
31779 | 31779 | Philip Ruppe R000512 | rep | MI | 1971-01-21 | 1973-01-03 | Republican | 11 | |||||||||||||
31796 | 31796 | George Shipley S000367 | rep | IL | 1971-01-21 | 1973-01-03 | Democrat | 23 | |||||||||||||
31815 | 31815 | Robert Sikes S000406 | rep | FL | 1971-01-21 | 1973-01-03 | Democrat | 1 | |||||||||||||
31827 | 31827 | Bernice Sisk S000454 | rep | CA | 1971-01-21 | 1973-01-03 | Democrat | 16 | |||||||||||||
31835 | 31835 | Joe Skubitz S000472 | rep | KS | 1971-01-21 | 1973-01-03 | Republican | 5 | |||||||||||||
31842 | 31842 | William Steiger S000847 | rep | WI | 1971-01-21 | 1973-01-03 | Republican | 6 | |||||||||||||
31859 | 31859 | Olin Teague T000110 | rep | TX | 1971-01-21 | 1973-01-03 | Democrat | 6 | |||||||||||||
31863 | 31863 | Charles Thone T000234 | rep | NE | 1971-01-21 | 1973-01-03 | Republican | 1 | |||||||||||||
31874 | 31874 | Joseph Waggonner W000018 | rep | LA | 1971-01-21 | 1973-01-03 | Democrat | 4 | |||||||||||||
31883 | 31883 | Charles Whalen W000317 | rep | OH | 1971-01-21 | 1973-01-03 | Republican | 3 | |||||||||||||
31889 | 31889 | Charles Wiggins W000448 | rep | CA | 1971-01-21 | 1973-01-03 | Republican | 25 | |||||||||||||
31897 | 31897 | Harrison Williams W000502 | sen | NJ | 1971-01-21 | 1977-01-03 | 1 | Democrat | |||||||||||||
31909 | 31909 | John Young Y000043 | rep | TX | 1971-01-21 | 1973-01-03 | Democrat | 14 | |||||||||||||
31925 | 31925 | John Anderson A000195 | rep | IL | 1971-01-21 | 1973-01-03 | Republican | 16 | |||||||||||||
31938 | 31938 | Thomas Ashley A000222 | rep | OH | 1971-01-21 | 1973-01-03 | Democrat | 9 | |||||||||||||
31962 | 31962 | John Brademas B000736 | rep | IN | 1971-01-21 | 1973-01-03 | Democrat | 3 | |||||||||||||
31970 | 31970 | John Buchanan B001008 | rep | AL | 1971-01-21 | 1973-01-03 | Republican | 6 | |||||||||||||
31976 | 31976 | William Burlison B001113 | rep | MO | 1971-01-21 | 1973-01-03 | Democrat | 10 | |||||||||||||
31984 | 31984 | Tim Carter C000201 | rep | KY | 1971-01-21 | 1973-01-03 | Republican | 5 | |||||||||||||
31995 | 31995 | James Cleveland C000512 | rep | NH | 1971-01-21 | 1973-01-03 | Republican | 2 | |||||||||||||
32005 | 32005 | James Corman C000780 | rep | CA | 1971-01-21 | 1973-01-03 | Democrat | 22 | |||||||||||||
32010 | 32010 | Mendel Davis D000125 | rep | SC | 1971-01-21 | 1973-01-03 | Democrat | 1 | |||||||||||||
32021 | 32021 | Samuel Devine D000279 | rep | OH | 1971-01-21 | 1973-01-03 | Republican | 12 | |||||||||||||
32034 | 32034 | Charles Diggs D000344 | rep | MI | 1971-01-21 | 1973-01-03 | Democrat | 13 | |||||||||||||
32039 | 32039 | Robert Drinan D000499 | rep | MA | 1971-01-21 | 1973-01-03 | Democrat | 3 | |||||||||||||
32051 | 32051 | Robert Eckhardt E000035 | rep | TX | 1971-01-21 | 1973-01-03 | Democrat | 8 | |||||||||||||
32071 | 32071 | Daniel Flood F000209 | rep | PA | 1971-01-21 | 1973-01-03 | Democrat | 11 | |||||||||||||
32082 | 32082 | Robert Giaimo G000151 | rep | CT | 1971-01-21 | 1973-01-03 | Democrat | 3 | |||||||||||||
32092 | 32092 | James Hanley H000158 | rep | NY | 1971-01-21 | 1973-01-03 | Democrat | 35 | |||||||||||||
32105 | 32105 | William Harsha H000281 | rep | OH | 1971-01-21 | 1973-01-03 | Republican | 6 | |||||||||||||
32122 | 32122 | Richard Ichord I000001 | rep | MO | 1971-01-21 | 1973-01-03 | Democrat | 8 |
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);