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 1981-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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
33221 | 33221 | Joseph Addabbo A000052 | rep | NY | 1979-01-15 | 1981-01-03 | Democrat | 7 | |||||||||||||
39031 | 39031 | Daniel Akaka A000069 | rep | HI | 1979-01-15 | 1981-01-03 | Democrat | 2 | |||||||||||||
32895 | 32895 | Donald Albosta A000076 | rep | MI | 1979-01-15 | 1981-01-03 | Democrat | 10 | |||||||||||||
34167 | 34167 | William Alexander A000103 | rep | AR | 1979-01-15 | 1981-01-03 | Democrat | 1 | |||||||||||||
31919 | 31919 | Jerome Ambro A000170 | rep | NY | 1979-01-15 | 1981-01-03 | Democrat | 3 | |||||||||||||
34179 | 34179 | Glenn Anderson A000189 | rep | CA | 1979-01-15 | 1981-01-03 | Democrat | 32 | |||||||||||||
31929 | 31929 | John Anderson A000195 | rep | IL | 1979-01-15 | 1981-01-03 | Republican | 16 | |||||||||||||
32901 | 32901 | Ike Andrews A000207 | rep | NC | 1979-01-15 | 1981-01-03 | Democrat | 4 | |||||||||||||
32443 | 32443 | Mark Andrews A000208 | rep | ND | 1979-01-15 | 1981-01-03 | Republican | 0 | |||||||||||||
34193 | 34193 | Frank Annunzio A000212 | rep | IL | 1979-01-15 | 1981-01-03 | Democrat | 11 | |||||||||||||
34200 | 34200 | Beryl Anthony A000213 | rep | AR | 1979-01-15 | 1981-01-03 | Democrat | 4 | |||||||||||||
35100 | 35100 | Douglas Applegate A000214 | rep | OH | 1979-01-15 | 1981-01-03 | Democrat | 18 | |||||||||||||
36476 | 36476 | Bill Archer A000215 | rep | TX | 1979-01-15 | 1981-01-03 | Republican | 7 | |||||||||||||
32455 | 32455 | John Ashbrook A000221 | rep | OH | 1979-01-15 | 1981-01-03 | Republican | 17 | |||||||||||||
31942 | 31942 | Thomas Ashley A000222 | rep | OH | 1979-01-15 | 1981-01-03 | Democrat | 9 | |||||||||||||
35112 | 35112 | Leslie Aspin A000224 | rep | WI | 1979-01-15 | 1981-01-03 | Democrat | 1 | |||||||||||||
32457 | 32457 | Eugene Atkinson A000329 | rep | PA | 1979-01-15 | 1981-01-03 | Democrat | 25 | |||||||||||||
34213 | 34213 | Les AuCoin A000337 | rep | OR | 1979-01-15 | 1981-01-03 | Democrat | 1 | |||||||||||||
33479 | 33479 | Robert Badham B000024 | rep | CA | 1979-01-15 | 1981-01-03 | Republican | 40 | |||||||||||||
32462 | 32462 | Louis Bafalis B000029 | rep | FL | 1979-01-15 | 1981-01-03 | Republican | 10 | |||||||||||||
32464 | 32464 | Donald Bailey B000037 | rep | PA | 1979-01-15 | 1981-01-03 | Democrat | 21 | |||||||||||||
31948 | 31948 | Alvin Baldus B000083 | rep | WI | 1979-01-15 | 1981-01-03 | Democrat | 3 | |||||||||||||
34221 | 34221 | Druie Barnard B000153 | rep | GA | 1979-01-15 | 1981-01-03 | Democrat | 10 | |||||||||||||
33230 | 33230 | Michael Barnes B000160 | rep | MD | 1979-01-15 | 1981-01-03 | Democrat | 8 | |||||||||||||
31952 | 31952 | Robert Bauman B000244 | rep | MD | 1979-01-15 | 1981-01-03 | Republican | 1 | |||||||||||||
30837 | 30837 | Birch Bayh B000254 | sen | IN | 1975-01-14 | 1981-01-03 | 3 | Democrat | |||||||||||||
31955 | 31955 | Edward Beard B000279 | rep | RI | 1979-01-15 | 1981-01-03 | Democrat | 2 | |||||||||||||
32470 | 32470 | Robin Beard B000280 | rep | TN | 1979-01-15 | 1981-01-03 | Republican | 6 | |||||||||||||
33236 | 33236 | Berkley Bedell B000298 | rep | IA | 1979-01-15 | 1981-01-03 | Democrat | 6 | |||||||||||||
35684 | 35684 | Anthony Beilenson B000318 | rep | CA | 1979-01-15 | 1981-01-03 | Democrat | 23 | |||||||||||||
30847 | 30847 | Henry Bellmon B000351 | sen | OK | 1975-01-14 | 1981-01-03 | 3 | Republican | |||||||||||||
32474 | 32474 | Adam Benjamin B000363 | rep | IN | 1979-01-15 | 1981-01-03 | Democrat | 1 | |||||||||||||
34248 | 34248 | Charles Bennett B000371 | rep | FL | 1979-01-15 | 1981-01-03 | Democrat | 3 | |||||||||||||
37241 | 37241 | Douglas Bereuter B000403 | rep | NE | 1979-01-15 | 1981-01-03 | Republican | 1 | |||||||||||||
32904 | 32904 | Edwin Bethune B000422 | rep | AR | 1979-01-15 | 1981-01-03 | Republican | 2 | |||||||||||||
35699 | 35699 | Tom Bevill B000431 | rep | AL | 1979-01-15 | 1981-01-03 | Democrat | 4 | |||||||||||||
33489 | 33489 | Mario Biaggi B000432 | rep | NY | 1979-01-15 | 1981-01-03 | Democrat | 10 | |||||||||||||
32483 | 32483 | Jonathan Bingham B000472 | rep | NY | 1979-01-15 | 1981-01-03 | Democrat | 22 | |||||||||||||
32487 | 32487 | James Blanchard B000538 | rep | MI | 1979-01-15 | 1981-01-03 | Democrat | 18 | |||||||||||||
33825 | 33825 | Corinne Boggs B000592 | rep | LA | 1979-01-15 | 1981-01-03 | Democrat | 2 | |||||||||||||
33507 | 33507 | Edward Boland B000600 | rep | MA | 1979-01-15 | 1981-01-03 | Democrat | 2 | |||||||||||||
32504 | 32504 | Richard Bolling B000605 | rep | MO | 1979-01-15 | 1981-01-03 | Democrat | 5 | |||||||||||||
33512 | 33512 | William Boner B000615 | rep | TN | 1979-01-15 | 1981-01-03 | Democrat | 5 | |||||||||||||
36816 | 36816 | David Bonior B000619 | rep | MI | 1979-01-15 | 1981-01-03 | Democrat | 12 | |||||||||||||
33519 | 33519 | Don Bonker B000620 | rep | WA | 1979-01-15 | 1981-01-03 | Democrat | 3 | |||||||||||||
32509 | 32509 | David Bowen B000682 | rep | MS | 1979-01-15 | 1981-01-03 | Democrat | 2 | |||||||||||||
31966 | 31966 | John Brademas B000736 | rep | IN | 1979-01-15 | 1981-01-03 | Democrat | 3 | |||||||||||||
36515 | 36515 | John Breaux B000780 | rep | LA | 1979-01-15 | 1981-01-03 | Democrat | 7 | |||||||||||||
32517 | 32517 | Jack Brinkley B000839 | rep | GA | 1979-01-15 | 1981-01-03 | Democrat | 3 | |||||||||||||
32521 | 32521 | William Brodhead B000862 | rep | MI | 1979-01-15 | 1981-01-03 | Democrat | 17 | |||||||||||||
35148 | 35148 | Jack Brooks B000880 | rep | TX | 1979-01-15 | 1981-01-03 | Democrat | 9 | |||||||||||||
34276 | 34276 | William Broomfield B000890 | rep | MI | 1979-01-15 | 1981-01-03 | Republican | 19 | |||||||||||||
32530 | 32530 | Clarence Brown B000910 | rep | OH | 1979-01-15 | 1981-01-03 | Republican | 7 | |||||||||||||
36529 | 36529 | George Brown B000918 | rep | CA | 1979-01-15 | 1981-01-03 | Democrat | 36 | |||||||||||||
33465 | 33465 | James Broyhill B000966 | rep | NC | 1979-01-15 | 1981-01-03 | Republican | 10 | |||||||||||||
31974 | 31974 | John Buchanan B001008 | rep | AL | 1979-01-15 | 1981-01-03 | Republican | 6 | |||||||||||||
35156 | 35156 | Dale Bumpers B001057 | sen | AR | 1975-01-14 | 1981-01-03 | 3 | Democrat | |||||||||||||
32535 | 32535 | Clair Burgener B001080 | rep | CA | 1979-01-15 | 1981-01-03 | Republican | 43 | |||||||||||||
31980 | 31980 | William Burlison B001113 | rep | MO | 1979-01-15 | 1981-01-03 | Democrat | 10 | |||||||||||||
32540 | 32540 | John Burton B001153 | rep | CA | 1979-01-15 | 1981-01-03 | Democrat | 5 | |||||||||||||
32916 | 32916 | Phillip Burton B001156 | rep | CA | 1979-01-15 | 1981-01-03 | Democrat | 6 | |||||||||||||
32546 | 32546 | Manley Butler B001182 | rep | VA | 1979-01-15 | 1981-01-03 | Republican | 6 | |||||||||||||
34297 | 34297 | Beverly Byron B001220 | rep | MD | 1979-01-15 | 1981-01-03 | Democrat | 6 | |||||||||||||
33243 | 33243 | Carroll Campbell C000079 | rep | SC | 1979-01-15 | 1981-01-03 | Republican | 4 | |||||||||||||
33247 | 33247 | William Carney C000165 | rep | NY | 1979-01-15 | 1981-01-03 | Republican | 1 | |||||||||||||
35163 | 35163 | Milton Carr C000178 | rep | MI | 1979-01-15 | 1981-01-03 | Democrat | 6 | |||||||||||||
31988 | 31988 | Tim Carter C000201 | rep | KY | 1979-01-15 | 1981-01-03 | Republican | 5 | |||||||||||||
31990 | 31990 | John Cavanaugh C000261 | rep | NE | 1979-01-15 | 1981-01-03 | Democrat | 2 | |||||||||||||
33534 | 33534 | William Chappell C000321 | rep | FL | 1979-01-15 | 1981-01-03 | Democrat | 4 | |||||||||||||
33846 | 33846 | Richard Cheney C000344 | rep | WY | 1979-01-15 | 1981-01-03 | Republican | 0 | |||||||||||||
32554 | 32554 | Shirley Chisholm C000371 | rep | NY | 1979-01-15 | 1981-01-03 | Democrat | 12 | |||||||||||||
30867 | 30867 | Frank Church C000388 | sen | ID | 1975-01-14 | 1981-01-03 | 3 | Democrat | |||||||||||||
32564 | 32564 | Donald Clausen C000475 | rep | CA | 1979-01-15 | 1981-01-03 | Republican | 2 | |||||||||||||
36562 | 36562 | William Clay C000488 | rep | MO | 1979-01-15 | 1981-01-03 | Democrat | 1 | |||||||||||||
31999 | 31999 | James Cleveland C000512 | rep | NH | 1979-01-15 | 1981-01-03 | Republican | 2 | |||||||||||||
35739 | 35739 | William Clinger C000523 | rep | PA | 1979-01-15 | 1981-01-03 | Republican | 23 | |||||||||||||
33855 | 33855 | Anthony Coelho C000581 | rep | CA | 1979-01-15 | 1981-01-03 | Democrat | 15 | |||||||||||||
34317 | 34317 | Earl Coleman C000618 | rep | MO | 1979-01-15 | 1981-01-03 | Republican | 6 | |||||||||||||
35761 | 35761 | Cardiss Collins C000634 | rep | IL | 1979-01-15 | 1981-01-03 | Democrat | 7 | |||||||||||||
32572 | 32572 | James Collins C000638 | rep | TX | 1979-01-15 | 1981-01-03 | Republican | 3 | |||||||||||||
32929 | 32929 | Barber Conable C000666 | rep | NY | 1979-01-15 | 1981-01-03 | Republican | 35 | |||||||||||||
34335 | 34335 | Silvio Conte C000709 | rep | MA | 1979-01-15 | 1981-01-03 | Republican | 1 | |||||||||||||
40562 | 40562 | John Conyers C000714 | rep | MI | 1979-01-15 | 1981-01-03 | Democrat | 1 | |||||||||||||
32933 | 32933 | Thomas Corcoran C000773 | rep | IL | 1979-01-15 | 1981-01-03 | Republican | 15 | |||||||||||||
32009 | 32009 | James Corman C000780 | rep | CA | 1979-01-15 | 1981-01-03 | Democrat | 21 | |||||||||||||
32937 | 32937 | Baltasar Corrada-del Río C000788 | rep | PR | 1979-01-15 | 1981-01-03 | New Progressive | 0 | |||||||||||||
32578 | 32578 | William Cotter C000799 | rep | CT | 1979-01-15 | 1981-01-03 | Democrat | 1 | |||||||||||||
34347 | 34347 | Robert Coughlin C000807 | rep | PA | 1979-01-15 | 1981-01-03 | Republican | 13 | |||||||||||||
33861 | 33861 | James Courter C000809 | rep | NJ | 1979-01-15 | 1981-01-03 | Republican | 13 | |||||||||||||
32940 | 32940 | Daniel Crane C000871 | rep | IL | 1979-01-15 | 1981-01-03 | Republican | 22 | |||||||||||||
37287 | 37287 | Philip Crane C000873 | rep | IL | 1979-01-15 | 1981-01-03 | Republican | 12 | |||||||||||||
33540 | 33540 | Alan Cranston C000877 | sen | CA | 1975-01-14 | 1981-01-03 | 3 | Democrat | |||||||||||||
33867 | 33867 | George Crockett C000919 | rep | MI | 1979-01-15 | 1981-01-03 | Democrat | 13 | |||||||||||||
30891 | 30891 | John Culver C000979 | sen | IA | 1975-01-14 | 1981-01-03 | 3 | Democrat | |||||||||||||
32945 | 32945 | Norman D’Amours D000017 | rep | NH | 1979-01-15 | 1981-01-03 | Democrat | 1 | |||||||||||||
32584 | 32584 | Robert Daniel D000037 | rep | VA | 1979-01-15 | 1981-01-03 | Republican | 4 | |||||||||||||
33548 | 33548 | Wilbur Daniel D000038 | rep | VA | 1979-01-15 | 1981-01-03 | Democrat | 5 | |||||||||||||
32590 | 32590 | George Danielson D000043 | rep | CA | 1979-01-15 | 1981-01-03 | Democrat | 30 | |||||||||||||
34355 | 34355 | William Dannemeyer D000044 | rep | CA | 1979-01-15 | 1981-01-03 | Republican | 39 | |||||||||||||
36581 | 36581 | Thomas Daschle D000064 | rep | SD | 1979-01-15 | 1981-01-03 | Democrat | 1 |
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);