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 1977-01-04 sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: end, party, end (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
32432 | 32432 | James Abdnor A000009 | rep | SD | 1977-01-04 | 1979-01-03 | Republican | 2 | |||||||||||||
33476 | 33476 | Brockman Adams A000031 | rep | WA | 1977-01-04 | 1979-01-03 | Democrat | 7 | |||||||||||||
33220 | 33220 | Joseph Addabbo A000052 | rep | NY | 1977-01-04 | 1979-01-03 | Democrat | 7 | |||||||||||||
39030 | 39030 | Daniel Akaka A000069 | rep | HI | 1977-01-04 | 1979-01-03 | Democrat | 2 | |||||||||||||
34166 | 34166 | William Alexander A000103 | rep | AR | 1977-01-04 | 1979-01-03 | Democrat | 1 | |||||||||||||
31413 | 31413 | Clifford Allen A000118 | rep | TN | 1977-01-04 | 1979-01-03 | Democrat | 5 | |||||||||||||
31918 | 31918 | Jerome Ambro A000170 | rep | NY | 1977-01-04 | 1979-01-03 | Democrat | 3 | |||||||||||||
31414 | 31414 | Joseph Ammerman A000177 | rep | PA | 1977-01-04 | 1979-01-03 | Democrat | 23 | |||||||||||||
34178 | 34178 | Glenn Anderson A000189 | rep | CA | 1977-01-04 | 1979-01-03 | Democrat | 32 | |||||||||||||
31928 | 31928 | John Anderson A000195 | rep | IL | 1977-01-04 | 1979-01-03 | Republican | 16 | |||||||||||||
32900 | 32900 | Ike Andrews A000207 | rep | NC | 1977-01-04 | 1979-01-03 | Democrat | 4 | |||||||||||||
32442 | 32442 | Mark Andrews A000208 | rep | ND | 1977-01-04 | 1979-01-03 | Republican | 0 | |||||||||||||
34192 | 34192 | Frank Annunzio A000212 | rep | IL | 1977-01-04 | 1979-01-03 | Democrat | 11 | |||||||||||||
35099 | 35099 | Douglas Applegate A000214 | rep | OH | 1977-01-04 | 1979-01-03 | Democrat | 18 | |||||||||||||
36475 | 36475 | Bill Archer A000215 | rep | TX | 1977-01-04 | 1979-01-03 | Republican | 7 | |||||||||||||
33227 | 33227 | William Armstrong A000219 | rep | CO | 1977-01-04 | 1979-01-03 | Republican | 5 | |||||||||||||
32454 | 32454 | John Ashbrook A000221 | rep | OH | 1977-01-04 | 1979-01-03 | Republican | 17 | |||||||||||||
31941 | 31941 | Thomas Ashley A000222 | rep | OH | 1977-01-04 | 1979-01-03 | Democrat | 9 | |||||||||||||
35111 | 35111 | Leslie Aspin A000224 | rep | WI | 1977-01-04 | 1979-01-03 | Democrat | 1 | |||||||||||||
34212 | 34212 | Les AuCoin A000337 | rep | OR | 1977-01-04 | 1979-01-03 | Democrat | 1 | |||||||||||||
33478 | 33478 | Robert Badham B000024 | rep | CA | 1977-01-04 | 1979-01-03 | Republican | 40 | |||||||||||||
31418 | 31418 | Herman Badillo B000025 | rep | NY | 1977-01-04 | 1979-01-03 | Democrat | 21 | |||||||||||||
32461 | 32461 | Louis Bafalis B000029 | rep | FL | 1977-01-04 | 1979-01-03 | Republican | 10 | |||||||||||||
31947 | 31947 | Alvin Baldus B000083 | rep | WI | 1977-01-04 | 1979-01-03 | Democrat | 3 | |||||||||||||
34220 | 34220 | Druie Barnard B000153 | rep | GA | 1977-01-04 | 1979-01-03 | Democrat | 10 | |||||||||||||
39658 | 39658 | Max Baucus B000243 | rep | MT | 1977-01-04 | 1978-12-14 | Democrat | 1 | |||||||||||||
31951 | 31951 | Robert Bauman B000244 | rep | MD | 1977-01-04 | 1979-01-03 | Republican | 1 | |||||||||||||
31954 | 31954 | Edward Beard B000279 | rep | RI | 1977-01-04 | 1979-01-03 | Democrat | 2 | |||||||||||||
32469 | 32469 | Robin Beard B000280 | rep | TN | 1977-01-04 | 1979-01-03 | Republican | 6 | |||||||||||||
33235 | 33235 | Berkley Bedell B000298 | rep | IA | 1977-01-04 | 1979-01-03 | Democrat | 6 | |||||||||||||
35683 | 35683 | Anthony Beilenson B000318 | rep | CA | 1977-01-04 | 1979-01-03 | Democrat | 23 | |||||||||||||
32473 | 32473 | Adam Benjamin B000363 | rep | IN | 1977-01-04 | 1979-01-03 | Democrat | 1 | |||||||||||||
34247 | 34247 | Charles Bennett B000371 | rep | FL | 1977-01-04 | 1979-01-03 | Democrat | 3 | |||||||||||||
33819 | 33819 | Lloyd Bentsen B000401 | sen | TX | 1977-01-04 | 1983-01-03 | 1 | Democrat | |||||||||||||
31422 | 31422 | Robert Bergland B000408 | rep | MN | 1977-01-04 | 1979-01-03 | Democrat | 7 | |||||||||||||
35698 | 35698 | Tom Bevill B000431 | rep | AL | 1977-01-04 | 1979-01-03 | Democrat | 4 | |||||||||||||
33488 | 33488 | Mario Biaggi B000432 | rep | NY | 1977-01-04 | 1979-01-03 | Democrat | 10 | |||||||||||||
32482 | 32482 | Jonathan Bingham B000472 | rep | NY | 1977-01-04 | 1979-01-03 | Democrat | 22 | |||||||||||||
32486 | 32486 | James Blanchard B000538 | rep | MI | 1977-01-04 | 1979-01-03 | Democrat | 18 | |||||||||||||
31424 | 31424 | Michael Blouin B000567 | rep | IA | 1977-01-04 | 1979-01-03 | Democrat | 2 | |||||||||||||
33824 | 33824 | Corinne Boggs B000592 | rep | LA | 1977-01-04 | 1979-01-03 | Democrat | 2 | |||||||||||||
33506 | 33506 | Edward Boland B000600 | rep | MA | 1977-01-04 | 1979-01-03 | Democrat | 2 | |||||||||||||
32503 | 32503 | Richard Bolling B000605 | rep | MO | 1977-01-04 | 1979-01-03 | Democrat | 5 | |||||||||||||
36815 | 36815 | David Bonior B000619 | rep | MI | 1977-01-04 | 1979-01-03 | Democrat | 12 | |||||||||||||
33518 | 33518 | Don Bonker B000620 | rep | WA | 1977-01-04 | 1979-01-03 | Democrat | 3 | |||||||||||||
32508 | 32508 | David Bowen B000682 | rep | MS | 1977-01-04 | 1979-01-03 | Democrat | 2 | |||||||||||||
31965 | 31965 | John Brademas B000736 | rep | IN | 1977-01-04 | 1979-01-03 | Democrat | 3 | |||||||||||||
36514 | 36514 | John Breaux B000780 | rep | LA | 1977-01-04 | 1979-01-03 | Democrat | 7 | |||||||||||||
31427 | 31427 | John Breckinridge B000788 | rep | KY | 1977-01-04 | 1979-01-03 | Democrat | 6 | |||||||||||||
32516 | 32516 | Jack Brinkley B000839 | rep | GA | 1977-01-04 | 1979-01-03 | Democrat | 3 | |||||||||||||
32520 | 32520 | William Brodhead B000862 | rep | MI | 1977-01-04 | 1979-01-03 | Democrat | 17 | |||||||||||||
35147 | 35147 | Jack Brooks B000880 | rep | TX | 1977-01-04 | 1979-01-03 | Democrat | 9 | |||||||||||||
34275 | 34275 | William Broomfield B000890 | rep | MI | 1977-01-04 | 1979-01-03 | Republican | 19 | |||||||||||||
32529 | 32529 | Clarence Brown B000910 | rep | OH | 1977-01-04 | 1979-01-03 | Republican | 7 | |||||||||||||
31433 | 31433 | Garry Brown B000917 | rep | MI | 1977-01-04 | 1979-01-03 | Republican | 3 | |||||||||||||
36528 | 36528 | George Brown B000918 | rep | CA | 1977-01-04 | 1979-01-03 | Democrat | 36 | |||||||||||||
33464 | 33464 | James Broyhill B000966 | rep | NC | 1977-01-04 | 1979-01-03 | Republican | 10 | |||||||||||||
31973 | 31973 | John Buchanan B001008 | rep | AL | 1977-01-04 | 1979-01-03 | Republican | 6 | |||||||||||||
33843 | 33843 | Quentin Burdick B001077 | sen | ND | 1977-01-04 | 1983-01-03 | 1 | Democrat | |||||||||||||
32534 | 32534 | Clair Burgener B001080 | rep | CA | 1977-01-04 | 1979-01-03 | Republican | 43 | |||||||||||||
31439 | 31439 | J. Burke B001091 | rep | FL | 1977-01-04 | 1979-01-03 | Republican | 12 | |||||||||||||
31449 | 31449 | James Burke B001092 | rep | MA | 1977-01-04 | 1979-01-03 | Democrat | 11 | |||||||||||||
31452 | 31452 | Yvonne Burke B001102 | rep | CA | 1977-01-04 | 1979-01-03 | Democrat | 28 | |||||||||||||
31468 | 31468 | Omar Burleson B001111 | rep | TX | 1977-01-04 | 1979-01-03 | Democrat | 17 | |||||||||||||
31979 | 31979 | William Burlison B001113 | rep | MO | 1977-01-04 | 1979-01-03 | Democrat | 10 | |||||||||||||
32539 | 32539 | John Burton B001153 | rep | CA | 1977-01-04 | 1979-01-03 | Democrat | 5 | |||||||||||||
32915 | 32915 | Phillip Burton B001156 | rep | CA | 1977-01-04 | 1979-01-03 | Democrat | 6 | |||||||||||||
32545 | 32545 | Manley Butler B001182 | rep | VA | 1977-01-04 | 1979-01-03 | Republican | 6 | |||||||||||||
31471 | 31471 | Harry Byrd B001209 | sen | VA | 1977-01-04 | 1983-01-03 | 1 | Independent | |||||||||||||
37957 | 37957 | Robert Byrd B001210 | sen | WV | 1977-01-04 | 1983-01-03 | 1 | Democrat | |||||||||||||
31475 | 31475 | Goodloe Byron B001221 | rep | MD | 1977-01-04 | 1979-01-03 | Democrat | 6 | |||||||||||||
31479 | 31479 | Howard Cannon C000120 | sen | NV | 1977-01-04 | 1983-01-03 | 1 | Democrat | |||||||||||||
31480 | 31480 | Bruce Caputo C000137 | rep | NY | 1977-01-04 | 1979-01-03 | Republican | 23 | |||||||||||||
31485 | 31485 | Charles Carney C000164 | rep | OH | 1977-01-04 | 1979-01-03 | Democrat | 19 | |||||||||||||
35162 | 35162 | Milton Carr C000178 | rep | MI | 1977-01-04 | 1979-01-03 | Democrat | 6 | |||||||||||||
31987 | 31987 | Tim Carter C000201 | rep | KY | 1977-01-04 | 1979-01-03 | Republican | 5 | |||||||||||||
31989 | 31989 | John Cavanaugh C000261 | rep | NE | 1977-01-04 | 1979-01-03 | Democrat | 2 | |||||||||||||
31498 | 31498 | Elford Cederberg C000263 | rep | MI | 1977-01-04 | 1979-01-03 | Republican | 10 | |||||||||||||
35728 | 35728 | John Chafee C000269 | sen | RI | 1977-01-04 | 1983-01-03 | 1 | Republican | |||||||||||||
33533 | 33533 | William Chappell C000321 | rep | FL | 1977-01-04 | 1979-01-03 | Democrat | 4 | |||||||||||||
32920 | 32920 | Lawton Chiles C000356 | sen | FL | 1977-01-04 | 1983-01-03 | 1 | Democrat | |||||||||||||
32553 | 32553 | Shirley Chisholm C000371 | rep | NY | 1977-01-04 | 1979-01-03 | Democrat | 12 | |||||||||||||
32563 | 32563 | Donald Clausen C000475 | rep | CA | 1977-01-04 | 1979-01-03 | Republican | 2 | |||||||||||||
31506 | 31506 | Delwin Clawson C000476 | rep | CA | 1977-01-04 | 1979-01-03 | Republican | 33 | |||||||||||||
36561 | 36561 | William Clay C000488 | rep | MO | 1977-01-04 | 1979-01-03 | Democrat | 1 | |||||||||||||
31998 | 31998 | James Cleveland C000512 | rep | NH | 1977-01-04 | 1979-01-03 | Republican | 2 | |||||||||||||
40620 | 40620 | Thad Cochran C000567 | rep | MS | 1977-01-04 | 1979-01-03 | Republican | 4 | |||||||||||||
34311 | 34311 | William Cohen C000598 | rep | ME | 1977-01-04 | 1979-01-03 | Republican | 2 | |||||||||||||
34316 | 34316 | Earl Coleman C000618 | rep | MO | 1977-01-04 | 1979-01-03 | Republican | 6 | |||||||||||||
35760 | 35760 | Cardiss Collins C000634 | rep | IL | 1977-01-04 | 1979-01-03 | Democrat | 7 | |||||||||||||
32571 | 32571 | James Collins C000638 | rep | TX | 1977-01-04 | 1979-01-03 | Republican | 3 | |||||||||||||
32928 | 32928 | Barber Conable C000666 | rep | NY | 1977-01-04 | 1979-01-03 | Republican | 35 | |||||||||||||
34334 | 34334 | Silvio Conte C000709 | rep | MA | 1977-01-04 | 1979-01-03 | Republican | 1 | |||||||||||||
40561 | 40561 | John Conyers C000714 | rep | MI | 1977-01-04 | 1979-01-03 | Democrat | 1 | |||||||||||||
32932 | 32932 | Thomas Corcoran C000773 | rep | IL | 1977-01-04 | 1979-01-03 | Republican | 15 | |||||||||||||
32008 | 32008 | James Corman C000780 | rep | CA | 1977-01-04 | 1979-01-03 | Democrat | 21 | |||||||||||||
31508 | 31508 | Robert Cornell C000782 | rep | WI | 1977-01-04 | 1979-01-03 | Democrat | 8 | |||||||||||||
31509 | 31509 | David Cornwell C000787 | rep | IN | 1977-01-04 | 1979-01-03 | Democrat | 8 | |||||||||||||
32936 | 32936 | Baltasar Corrada-del Río C000788 | rep | PR | 1977-01-04 | 1979-01-03 | New Progressive | 0 | |||||||||||||
32577 | 32577 | William Cotter C000799 | rep | CT | 1977-01-04 | 1979-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);