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 sorted by party
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
31332 | 31332 | James Stanton S000803 | rep | OH | 1971-01-21 | 1973-01-03 | Democrat | 20 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
31859 | 31859 | Olin Teague T000110 | rep | TX | 1971-01-21 | 1973-01-03 | Democrat | 6 | |||||||||||||
31874 | 31874 | Joseph Waggonner W000018 | rep | LA | 1971-01-21 | 1973-01-03 | Democrat | 4 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
31976 | 31976 | William Burlison B001113 | rep | MO | 1971-01-21 | 1973-01-03 | Democrat | 10 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
32122 | 32122 | Richard Ichord I000001 | rep | MO | 1971-01-21 | 1973-01-03 | Democrat | 8 | |||||||||||||
32137 | 32137 | Harold Johnson J000135 | rep | CA | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
32156 | 32156 | Marvin Mathis M000244 | rep | GA | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
32161 | 32161 | Mike McCormack M000365 | rep | WA | 1971-01-21 | 1973-01-03 | Democrat | 4 | |||||||||||||
32174 | 32174 | Koln McKay M000490 | rep | UT | 1971-01-21 | 1973-01-03 | Democrat | 1 | |||||||||||||
32180 | 32180 | Abner Mikva M000703 | rep | IL | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
32190 | 32190 | William Moorhead M000930 | rep | PA | 1971-01-21 | 1973-01-03 | Democrat | 14 | |||||||||||||
32199 | 32199 | John Murphy M001098 | rep | NY | 1971-01-21 | 1973-01-03 | Democrat | 16 | |||||||||||||
32204 | 32204 | Morgan Murphy M001101 | rep | IL | 1971-01-21 | 1973-01-03 | Democrat | 3 | |||||||||||||
32218 | 32218 | Lucien Nedzi N000019 | rep | MI | 1971-01-21 | 1973-01-03 | Democrat | 14 | |||||||||||||
32227 | 32227 | Edward Patten P000106 | rep | NJ | 1971-01-21 | 1973-01-03 | Democrat | 15 | |||||||||||||
32236 | 32236 | Lunsford Preyer P000520 | rep | NC | 1971-01-21 | 1973-01-03 | Democrat | 6 | |||||||||||||
32258 | 32258 | Herbert Roberts R000312 | rep | TX | 1971-01-21 | 1973-01-03 | Democrat | 4 | |||||||||||||
32264 | 32264 | Harold Runnels R000510 | rep | NM | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
32272 | 32272 | David Satterfield S000070 | rep | VA | 1971-01-21 | 1973-01-03 | Democrat | 3 | |||||||||||||
32289 | 32289 | John Slack S000473 | rep | WV | 1971-01-21 | 1973-01-03 | Democrat | 3 | |||||||||||||
32309 | 32309 | Harley Staggers S000778 | rep | WV | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
32325 | 32325 | Thomas Steed S000829 | rep | OK | 1971-01-21 | 1973-01-03 | Democrat | 4 | |||||||||||||
32339 | 32339 | Frank Thompson T000200 | rep | NJ | 1971-01-21 | 1973-01-03 | Democrat | 4 | |||||||||||||
32362 | 32362 | Albert Ullman U000004 | rep | OR | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
32371 | 32371 | Lionel Van Deerlin V000024 | rep | CA | 1971-01-21 | 1973-01-03 | Democrat | 37 | |||||||||||||
32384 | 32384 | Charles Vanik V000047 | rep | OH | 1971-01-21 | 1973-01-03 | Democrat | 22 | |||||||||||||
32393 | 32393 | Charles Wilson W000571 | rep | CA | 1971-01-21 | 1973-01-03 | Democrat | 31 | |||||||||||||
32415 | 32415 | Lester Wolff W000680 | rep | NY | 1971-01-21 | 1973-01-03 | Democrat | 3 | |||||||||||||
32479 | 32479 | Jonathan Bingham B000472 | rep | NY | 1971-01-21 | 1973-01-03 | Democrat | 23 | |||||||||||||
32500 | 32500 | Richard Bolling B000605 | rep | MO | 1971-01-21 | 1973-01-03 | Democrat | 5 | |||||||||||||
32513 | 32513 | Jack Brinkley B000839 | rep | GA | 1971-01-21 | 1973-01-03 | Democrat | 3 | |||||||||||||
32550 | 32550 | Shirley Chisholm C000371 | rep | NY | 1971-01-21 | 1973-01-03 | Democrat | 12 | |||||||||||||
32574 | 32574 | William Cotter C000799 | rep | CT | 1971-01-21 | 1973-01-03 | Democrat | 1 | |||||||||||||
32586 | 32586 | George Danielson D000043 | rep | CA | 1971-01-21 | 1973-01-03 | Democrat | 29 | |||||||||||||
32667 | 32667 | Lawrence Fountain F000319 | rep | NC | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
32784 | 32784 | Robert Mollohan M000845 | rep | WV | 1971-01-21 | 1973-01-03 | Democrat | 1 | |||||||||||||
32817 | 32817 | Henry Reuss R000165 | rep | WI | 1971-01-21 | 1973-01-03 | Democrat | 5 | |||||||||||||
32884 | 32884 | Richard White W000390 | rep | TX | 1971-01-21 | 1973-01-03 | Democrat | 16 |
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);