legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
479 rows where "end" is on date 1975-01-03 sorted by legislator_id
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
32430 | 32430 | James Abdnor A000009 | rep | SD | 1973-01-03 | 1975-01-03 | Republican | 2 | |||||||||||||
30801 | 30801 | Bella Abzug A000018 | rep | NY | 1973-01-03 | 1975-01-03 | Democrat | 20 | |||||||||||||
33474 | 33474 | Brockman Adams A000031 | rep | WA | 1973-01-03 | 1975-01-03 | Democrat | 7 | |||||||||||||
33218 | 33218 | Joseph Addabbo A000052 | rep | NY | 1973-01-03 | 1975-01-03 | Democrat | 7 | |||||||||||||
29118 | 29118 | George Aiken A000062 | sen | VT | 1969-01-03 | 1975-01-03 | 3 | Republican | |||||||||||||
30816 | 30816 | Carl Albert A000073 | rep | OK | 1973-01-03 | 1975-01-03 | Democrat | 3 | |||||||||||||
34164 | 34164 | William Alexander A000103 | rep | AR | 1973-01-03 | 1975-01-03 | Democrat | 1 | |||||||||||||
30818 | 30818 | James Allen A000127 | sen | AL | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
34176 | 34176 | Glenn Anderson A000189 | rep | CA | 1973-01-03 | 1975-01-03 | Democrat | 35 | |||||||||||||
31926 | 31926 | John Anderson A000195 | rep | IL | 1973-01-03 | 1975-01-03 | Republican | 16 | |||||||||||||
32898 | 32898 | Ike Andrews A000207 | rep | NC | 1973-01-03 | 1975-01-03 | Democrat | 4 | |||||||||||||
32440 | 32440 | Mark Andrews A000208 | rep | ND | 1973-01-03 | 1975-01-03 | Republican | 0 | |||||||||||||
34190 | 34190 | Frank Annunzio A000212 | rep | IL | 1973-01-03 | 1975-01-03 | Democrat | 11 | |||||||||||||
36473 | 36473 | Bill Archer A000215 | rep | TX | 1973-01-03 | 1975-01-03 | Republican | 7 | |||||||||||||
30157 | 30157 | Leslie Arends A000216 | rep | IL | 1973-01-03 | 1975-01-03 | Republican | 15 | |||||||||||||
33225 | 33225 | William Armstrong A000219 | rep | CO | 1973-01-03 | 1975-01-03 | Republican | 5 | |||||||||||||
32452 | 32452 | John Ashbrook A000221 | rep | OH | 1973-01-03 | 1975-01-03 | Republican | 17 | |||||||||||||
31939 | 31939 | Thomas Ashley A000222 | rep | OH | 1973-01-03 | 1975-01-03 | Democrat | 9 | |||||||||||||
35109 | 35109 | Leslie Aspin A000224 | rep | WI | 1973-01-03 | 1975-01-03 | Democrat | 1 | |||||||||||||
31416 | 31416 | Herman Badillo B000025 | rep | NY | 1973-01-03 | 1975-01-03 | Democrat | 21 | |||||||||||||
32459 | 32459 | Louis Bafalis B000029 | rep | FL | 1973-01-03 | 1975-01-03 | Republican | 10 | |||||||||||||
30159 | 30159 | LaMar Baker B000069 | rep | TN | 1973-01-03 | 1975-01-03 | Republican | 3 | |||||||||||||
30833 | 30833 | William Barrett B000178 | rep | PA | 1973-01-03 | 1975-01-03 | Democrat | 1 | |||||||||||||
31949 | 31949 | Robert Bauman B000244 | rep | MD | 1973-01-03 | 1975-01-03 | Republican | 1 | |||||||||||||
30836 | 30836 | Birch Bayh B000254 | sen | IN | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
32467 | 32467 | Robin Beard B000280 | rep | TN | 1973-01-03 | 1975-01-03 | Republican | 6 | |||||||||||||
30844 | 30844 | Alphonzo Bell B000330 | rep | CA | 1973-01-03 | 1975-01-03 | Republican | 28 | |||||||||||||
30846 | 30846 | Henry Bellmon B000351 | sen | OK | 1969-01-03 | 1975-01-03 | 3 | Republican | |||||||||||||
30848 | 30848 | Jaime Benítez B000362 | rep | PR | 1973-01-03 | 1975-01-03 | Popular Democrat | 0 | |||||||||||||
34245 | 34245 | Charles Bennett B000371 | rep | FL | 1973-01-03 | 1975-01-03 | Democrat | 3 | |||||||||||||
31420 | 31420 | Robert Bergland B000408 | rep | MN | 1973-01-03 | 1975-01-03 | Democrat | 7 | |||||||||||||
35696 | 35696 | Tom Bevill B000431 | rep | AL | 1973-01-03 | 1975-01-03 | Democrat | 4 | |||||||||||||
33486 | 33486 | Mario Biaggi B000432 | rep | NY | 1973-01-03 | 1975-01-03 | Democrat | 10 | |||||||||||||
30853 | 30853 | Edward Biester B000451 | rep | PA | 1973-01-03 | 1975-01-03 | Republican | 8 | |||||||||||||
32480 | 32480 | Jonathan Bingham B000472 | rep | NY | 1973-01-03 | 1975-01-03 | Democrat | 22 | |||||||||||||
30164 | 30164 | Benjamin Blackburn B000506 | rep | GA | 1973-01-03 | 1975-01-03 | Republican | 4 | |||||||||||||
30178 | 30178 | John Blatnik B000550 | rep | MN | 1973-01-03 | 1975-01-03 | Democrat | 8 | |||||||||||||
33822 | 33822 | Corinne Boggs B000592 | rep | LA | 1973-01-03 | 1975-01-03 | Democrat | 2 | |||||||||||||
33504 | 33504 | Edward Boland B000600 | rep | MA | 1973-01-03 | 1975-01-03 | Democrat | 2 | |||||||||||||
32501 | 32501 | Richard Bolling B000605 | rep | MO | 1973-01-03 | 1975-01-03 | Democrat | 5 | |||||||||||||
32506 | 32506 | David Bowen B000682 | rep | MS | 1973-01-03 | 1975-01-03 | Democrat | 2 | |||||||||||||
31963 | 31963 | John Brademas B000736 | rep | IN | 1973-01-03 | 1975-01-03 | Democrat | 3 | |||||||||||||
30182 | 30182 | Frank Brasco B000771 | rep | NY | 1973-01-03 | 1975-01-03 | Democrat | 11 | |||||||||||||
30194 | 30194 | William Bray B000778 | rep | IN | 1973-01-03 | 1975-01-03 | Republican | 6 | |||||||||||||
36512 | 36512 | John Breaux B000780 | rep | LA | 1973-01-03 | 1975-01-03 | Democrat | 7 | |||||||||||||
31425 | 31425 | John Breckinridge B000788 | rep | KY | 1973-01-03 | 1975-01-03 | Democrat | 6 | |||||||||||||
32514 | 32514 | Jack Brinkley B000839 | rep | GA | 1973-01-03 | 1975-01-03 | Democrat | 3 | |||||||||||||
35145 | 35145 | Jack Brooks B000880 | rep | TX | 1973-01-03 | 1975-01-03 | Democrat | 9 | |||||||||||||
34273 | 34273 | William Broomfield B000890 | rep | MI | 1973-01-03 | 1975-01-03 | Republican | 19 | |||||||||||||
30201 | 30201 | Donald Brotzman B000893 | rep | CO | 1973-01-03 | 1975-01-03 | Republican | 2 | |||||||||||||
32527 | 32527 | Clarence Brown B000910 | rep | OH | 1973-01-03 | 1975-01-03 | Republican | 7 | |||||||||||||
31431 | 31431 | Garry Brown B000917 | rep | MI | 1973-01-03 | 1975-01-03 | Republican | 3 | |||||||||||||
36526 | 36526 | George Brown B000918 | rep | CA | 1973-01-03 | 1975-01-03 | Democrat | 38 | |||||||||||||
33462 | 33462 | James Broyhill B000966 | rep | NC | 1973-01-03 | 1975-01-03 | Republican | 10 | |||||||||||||
30212 | 30212 | Joel Broyhill B000967 | rep | VA | 1973-01-03 | 1975-01-03 | Republican | 10 | |||||||||||||
31971 | 31971 | John Buchanan B001008 | rep | AL | 1973-01-03 | 1975-01-03 | Republican | 6 | |||||||||||||
32532 | 32532 | Clair Burgener B001080 | rep | CA | 1973-01-03 | 1975-01-03 | Republican | 42 | |||||||||||||
31437 | 31437 | J. Burke B001091 | rep | FL | 1973-01-03 | 1975-01-03 | Republican | 12 | |||||||||||||
31447 | 31447 | James Burke B001092 | rep | MA | 1973-01-03 | 1975-01-03 | Democrat | 11 | |||||||||||||
31450 | 31450 | Yvonne Burke B001102 | rep | CA | 1973-01-03 | 1975-01-03 | Democrat | 37 | |||||||||||||
31466 | 31466 | Omar Burleson B001111 | rep | TX | 1973-01-03 | 1975-01-03 | Democrat | 17 | |||||||||||||
31977 | 31977 | William Burlison B001113 | rep | MO | 1973-01-03 | 1975-01-03 | Democrat | 10 | |||||||||||||
32537 | 32537 | John Burton B001153 | rep | CA | 1973-01-03 | 1975-01-03 | Democrat | 6 | |||||||||||||
32913 | 32913 | Phillip Burton B001156 | rep | CA | 1973-01-03 | 1975-01-03 | Democrat | 5 | |||||||||||||
32543 | 32543 | Manley Butler B001182 | rep | VA | 1973-01-03 | 1975-01-03 | Republican | 6 | |||||||||||||
31473 | 31473 | Goodloe Byron B001221 | rep | MD | 1973-01-03 | 1975-01-03 | Democrat | 6 | |||||||||||||
30215 | 30215 | John Camp C000073 | rep | OK | 1973-01-03 | 1975-01-03 | Republican | 6 | |||||||||||||
30222 | 30222 | Hugh Carey C000143 | rep | NY | 1973-01-03 | 1975-01-03 | Democrat | 15 | |||||||||||||
31483 | 31483 | Charles Carney C000164 | rep | OH | 1973-01-03 | 1975-01-03 | Democrat | 19 | |||||||||||||
31985 | 31985 | Tim Carter C000201 | rep | KY | 1973-01-03 | 1975-01-03 | Republican | 5 | |||||||||||||
30862 | 30862 | Robert Casey C000228 | rep | TX | 1973-01-03 | 1975-01-03 | Democrat | 22 | |||||||||||||
31496 | 31496 | Elford Cederberg C000263 | rep | MI | 1973-01-03 | 1975-01-03 | Republican | 10 | |||||||||||||
30240 | 30240 | Charles Chamberlain C000275 | rep | MI | 1973-01-03 | 1975-01-03 | Republican | 6 | |||||||||||||
33531 | 33531 | William Chappell C000321 | rep | FL | 1973-01-03 | 1975-01-03 | Democrat | 4 | |||||||||||||
32551 | 32551 | Shirley Chisholm C000371 | rep | NY | 1973-01-03 | 1975-01-03 | Democrat | 12 | |||||||||||||
30866 | 30866 | Frank Church C000388 | sen | ID | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
30874 | 30874 | Donald Clancy C000409 | rep | OH | 1973-01-03 | 1975-01-03 | Republican | 2 | |||||||||||||
30250 | 30250 | Frank Clark C000431 | rep | PA | 1973-01-03 | 1975-01-03 | Democrat | 25 | |||||||||||||
32561 | 32561 | Donald Clausen C000475 | rep | CA | 1973-01-03 | 1975-01-03 | Republican | 1 | |||||||||||||
31504 | 31504 | Delwin Clawson C000476 | rep | CA | 1973-01-03 | 1975-01-03 | Republican | 23 | |||||||||||||
36559 | 36559 | William Clay C000488 | rep | MO | 1973-01-03 | 1975-01-03 | Democrat | 1 | |||||||||||||
31996 | 31996 | James Cleveland C000512 | rep | NH | 1973-01-03 | 1975-01-03 | Republican | 2 | |||||||||||||
40618 | 40618 | Thad Cochran C000567 | rep | MS | 1973-01-03 | 1975-01-03 | Republican | 4 | |||||||||||||
34309 | 34309 | William Cohen C000598 | rep | ME | 1973-01-03 | 1975-01-03 | Republican | 2 | |||||||||||||
30260 | 30260 | Harold Collier C000629 | rep | IL | 1973-01-03 | 1975-01-03 | Republican | 6 | |||||||||||||
35758 | 35758 | Cardiss Collins C000634 | rep | IL | 1973-06-05 | 1975-01-03 | Democrat | 7 | |||||||||||||
32569 | 32569 | James Collins C000638 | rep | TX | 1973-01-03 | 1975-01-03 | Republican | 3 | |||||||||||||
32926 | 32926 | Barber Conable C000666 | rep | NY | 1973-01-03 | 1975-01-03 | Republican | 35 | |||||||||||||
30876 | 30876 | John Conlan C000682 | rep | AZ | 1973-01-03 | 1975-01-03 | Republican | 4 | |||||||||||||
34332 | 34332 | Silvio Conte C000709 | rep | MA | 1973-01-03 | 1975-01-03 | Republican | 1 | |||||||||||||
40559 | 40559 | John Conyers C000714 | rep | MI | 1973-01-03 | 1975-01-03 | Democrat | 1 | |||||||||||||
32006 | 32006 | James Corman C000780 | rep | CA | 1973-01-03 | 1975-01-03 | Democrat | 22 | |||||||||||||
32575 | 32575 | William Cotter C000799 | rep | CT | 1973-01-03 | 1975-01-03 | Democrat | 1 | |||||||||||||
34344 | 34344 | Robert Coughlin C000807 | rep | PA | 1973-01-03 | 1975-01-03 | Republican | 13 | |||||||||||||
37284 | 37284 | Philip Crane C000873 | rep | IL | 1973-01-03 | 1975-01-03 | Republican | 12 | |||||||||||||
33539 | 33539 | Alan Cranston C000877 | sen | CA | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
30263 | 30263 | Paul Cronin C000925 | rep | MA | 1973-01-03 | 1975-01-03 | Republican | 5 | |||||||||||||
30890 | 30890 | John Culver C000979 | rep | IA | 1973-01-03 | 1975-01-03 | Democrat | 2 | |||||||||||||
32581 | 32581 | Robert Daniel D000037 | rep | VA | 1973-01-03 | 1975-01-03 | Republican | 4 | |||||||||||||
33545 | 33545 | Wilbur Daniel D000038 | rep | VA | 1973-01-03 | 1975-01-03 | Democrat | 5 |
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);