legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
477 rows where "end" is on date 1985-01-03
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
33581 | 33581 | Wyche Fowler F000329 | rep | GA | 1983-01-03 | 1985-01-03 | Democrat | 5 | |||||||||||||
33609 | 33609 | James Howard H000840 | rep | NJ | 1983-01-03 | 1985-01-03 | Democrat | 3 | |||||||||||||
33619 | 33619 | Ed Jones J000216 | rep | TN | 1983-01-03 | 1985-01-03 | Democrat | 8 | |||||||||||||
33633 | 33633 | Jack Kemp K000086 | rep | NY | 1983-01-03 | 1985-01-03 | Republican | 31 | |||||||||||||
33649 | 33649 | Delbert Latta L000116 | rep | OH | 1983-01-03 | 1985-01-03 | Republican | 5 | |||||||||||||
33654 | 33654 | Michael Lowry L000486 | rep | WA | 1983-01-03 | 1985-01-03 | Democrat | 7 | |||||||||||||
33664 | 33664 | Manuel Luján L000506 | rep | NM | 1983-01-03 | 1985-01-03 | Republican | 1 | |||||||||||||
33667 | 33667 | Kenneth MacKay M000023 | rep | FL | 1983-01-03 | 1985-01-03 | Democrat | 6 | |||||||||||||
33676 | 33676 | Stewart McKinney M000527 | rep | CT | 1983-01-03 | 1985-01-03 | Republican | 4 | |||||||||||||
33681 | 33681 | Daniel Mica M000688 | rep | FL | 1983-01-03 | 1985-01-03 | Democrat | 14 | |||||||||||||
33692 | 33692 | William Nichols N000095 | rep | AL | 1983-01-03 | 1985-01-03 | Democrat | 3 | |||||||||||||
33714 | 33714 | Charles Price P000522 | rep | IL | 1983-01-03 | 1985-01-03 | Democrat | 21 | |||||||||||||
33738 | 33738 | Peter Rodino R000374 | rep | NJ | 1983-01-03 | 1985-01-03 | Democrat | 10 | |||||||||||||
33742 | 33742 | Charles Roemer R000384 | rep | LA | 1983-01-03 | 1985-01-03 | Democrat | 4 | |||||||||||||
33759 | 33759 | Fernand St. Germain S000762 | rep | RI | 1983-01-03 | 1985-01-03 | Democrat | 1 | |||||||||||||
33774 | 33774 | Samuel Stratton S000997 | rep | NY | 1983-01-03 | 1985-01-03 | Democrat | 23 | |||||||||||||
33778 | 33778 | Fofó Sunia S001077 | rep | AS | 1983-01-03 | 1985-01-03 | Democrat | 0 | |||||||||||||
33796 | 33796 | Gene Taylor T000075 | rep | MO | 1983-01-03 | 1985-01-03 | Republican | 7 | |||||||||||||
33803 | 33803 | Timothy Wirth W000647 | rep | CO | 1983-01-03 | 1985-01-03 | Democrat | 2 | |||||||||||||
33807 | 33807 | George Wortley W000752 | rep | NY | 1983-01-03 | 1985-01-03 | Republican | 27 | |||||||||||||
33810 | 33810 | Jim Bates B000236 | rep | CA | 1983-01-03 | 1985-01-03 | Democrat | 44 | |||||||||||||
33827 | 33827 | Corinne Boggs B000592 | rep | LA | 1983-01-03 | 1985-01-03 | Democrat | 2 | |||||||||||||
33831 | 33831 | Douglas Bosco B000648 | rep | CA | 1983-01-03 | 1985-01-03 | Democrat | 1 | |||||||||||||
33848 | 33848 | Richard Cheney C000344 | rep | WY | 1983-01-03 | 1985-01-03 | Republican | 0 | |||||||||||||
33852 | 33852 | James Clarke C000462 | rep | NC | 1983-01-03 | 1985-01-03 | Democrat | 11 | |||||||||||||
33857 | 33857 | Anthony Coelho C000581 | rep | CA | 1983-01-03 | 1985-01-03 | Democrat | 15 | |||||||||||||
33863 | 33863 | James Courter C000809 | rep | NJ | 1983-01-03 | 1985-01-03 | Republican | 12 | |||||||||||||
33869 | 33869 | George Crockett C000919 | rep | MI | 1983-01-03 | 1985-01-03 | Democrat | 13 | |||||||||||||
33885 | 33885 | Royden Dyson D000593 | rep | MD | 1983-01-03 | 1985-01-03 | Democrat | 1 | |||||||||||||
33895 | 33895 | Walter Fauntroy F000046 | rep | DC | 1983-01-03 | 1985-01-03 | Democrat | 0 | |||||||||||||
33902 | 33902 | Ronnie Flippo F000208 | rep | AL | 1983-01-03 | 1985-01-03 | Democrat | 5 | |||||||||||||
33910 | 33910 | James Florio F000215 | rep | NJ | 1983-01-03 | 1985-01-03 | Democrat | 1 | |||||||||||||
33920 | 33920 | William Frenzel F000380 | rep | MN | 1983-01-03 | 1985-01-03 | Republican | 3 | |||||||||||||
33927 | 33927 | Robert Garcia G000047 | rep | NY | 1983-01-03 | 1985-01-03 | Democrat | 18 | |||||||||||||
33943 | 33943 | Augustus Hawkins H000367 | rep | CA | 1983-01-03 | 1985-01-03 | Democrat | 29 | |||||||||||||
33954 | 33954 | John Hiler H000586 | rep | IN | 1983-01-03 | 1985-01-03 | Republican | 3 | |||||||||||||
33970 | 33970 | Robert Kastenmeier K000020 | rep | WI | 1983-01-03 | 1985-01-03 | Democrat | 2 | |||||||||||||
33976 | 33976 | James Leath L000180 | rep | TX | 1983-01-03 | 1985-01-03 | Democrat | 11 | |||||||||||||
33982 | 33982 | George Leland L000237 | rep | TX | 1983-01-03 | 1985-01-03 | Democrat | 18 | |||||||||||||
33990 | 33990 | Thomas Luken L000508 | rep | OH | 1983-01-03 | 1985-01-03 | Democrat | 1 | |||||||||||||
33999 | 33999 | Lynn Martin M000195 | rep | IL | 1983-01-03 | 1985-01-03 | Republican | 16 | |||||||||||||
34022 | 34022 | Guy Molinari M000842 | rep | NY | 1983-01-03 | 1985-01-03 | Republican | 14 | |||||||||||||
34026 | 34026 | Bruce Morrison M000992 | rep | CT | 1983-01-03 | 1985-01-03 | Democrat | 3 | |||||||||||||
34030 | 34030 | Howard Nielson N000106 | rep | UT | 1983-01-03 | 1985-01-03 | Republican | 3 | |||||||||||||
34036 | 34036 | Stanford Parris P000080 | rep | VA | 1983-01-03 | 1985-01-03 | Republican | 8 | |||||||||||||
34042 | 34042 | Charles Pashayan P000097 | rep | CA | 1983-01-03 | 1985-01-03 | Republican | 17 | |||||||||||||
34059 | 34059 | Claude Pepper P000218 | rep | FL | 1983-01-03 | 1985-01-03 | Democrat | 18 | |||||||||||||
34083 | 34083 | Claudine Schneider S000136 | rep | RI | 1983-01-03 | 1985-01-03 | Republican | 2 | |||||||||||||
34092 | 34092 | Norman Shumway S000393 | rep | CA | 1983-01-03 | 1985-01-03 | Republican | 14 | |||||||||||||
34097 | 34097 | Dennis Smith S000527 | rep | OR | 1983-01-03 | 1985-01-03 | Republican | 5 | |||||||||||||
34107 | 34107 | Virginia Smith S000622 | rep | NE | 1983-01-03 | 1985-01-03 | Republican | 3 | |||||||||||||
34114 | 34114 | Arlan Stangeland S000795 | rep | MN | 1983-01-03 | 1985-01-03 | Republican | 7 | |||||||||||||
34120 | 34120 | Thomas Tauke T000053 | rep | IA | 1983-01-03 | 1985-01-03 | Republican | 2 | |||||||||||||
34127 | 34127 | Douglas Walgren W000044 | rep | PA | 1983-01-03 | 1985-01-03 | Democrat | 18 | |||||||||||||
34136 | 34136 | Robert Whittaker W000426 | rep | KS | 1983-01-03 | 1985-01-03 | Republican | 5 | |||||||||||||
34156 | 34156 | James Wright W000763 | rep | TX | 1983-01-03 | 1985-01-03 | Democrat | 12 | |||||||||||||
34169 | 34169 | William Alexander A000103 | rep | AR | 1983-01-03 | 1985-01-03 | Democrat | 1 | |||||||||||||
34181 | 34181 | Glenn Anderson A000189 | rep | CA | 1983-01-03 | 1985-01-03 | Democrat | 32 | |||||||||||||
34195 | 34195 | Frank Annunzio A000212 | rep | IL | 1983-01-03 | 1985-01-03 | Democrat | 11 | |||||||||||||
34202 | 34202 | Beryl Anthony A000213 | rep | AR | 1983-01-03 | 1985-01-03 | Democrat | 4 | |||||||||||||
34215 | 34215 | Les AuCoin A000337 | rep | OR | 1983-01-03 | 1985-01-03 | Democrat | 1 | |||||||||||||
34223 | 34223 | Druie Barnard B000153 | rep | GA | 1983-01-03 | 1985-01-03 | Democrat | 10 | |||||||||||||
34228 | 34228 | Harry Bartlett B000204 | rep | TX | 1983-01-03 | 1985-01-03 | Republican | 3 | |||||||||||||
34250 | 34250 | Charles Bennett B000371 | rep | FL | 1983-01-03 | 1985-01-03 | Democrat | 3 | |||||||||||||
34259 | 34259 | David Boren B000639 | sen | OK | 1979-01-15 | 1985-01-03 | 2 | Democrat | |||||||||||||
34262 | 34262 | William Bradley B001225 | sen | NJ | 1979-01-15 | 1985-01-03 | 2 | Democrat | |||||||||||||
34278 | 34278 | William Broomfield B000890 | rep | MI | 1983-01-03 | 1985-01-03 | Republican | 18 | |||||||||||||
34284 | 34284 | George Brown B000919 | rep | CO | 1983-01-03 | 1985-01-03 | Republican | 4 | |||||||||||||
34299 | 34299 | Beverly Byron B001220 | rep | MD | 1983-01-03 | 1985-01-03 | Democrat | 6 | |||||||||||||
34304 | 34304 | Rodney Chandler C000293 | rep | WA | 1983-01-03 | 1985-01-03 | Republican | 8 | |||||||||||||
34312 | 34312 | William Cohen C000598 | sen | ME | 1979-01-15 | 1985-01-03 | 2 | Republican | |||||||||||||
34319 | 34319 | Earl Coleman C000618 | rep | MO | 1983-01-03 | 1985-01-03 | Republican | 6 | |||||||||||||
34337 | 34337 | Silvio Conte C000709 | rep | MA | 1983-01-03 | 1985-01-03 | Republican | 1 | |||||||||||||
34349 | 34349 | Robert Coughlin C000807 | rep | PA | 1983-01-03 | 1985-01-03 | Republican | 13 | |||||||||||||
34357 | 34357 | William Dannemeyer D000044 | rep | CA | 1983-01-03 | 1985-01-03 | Republican | 39 | |||||||||||||
34364 | 34364 | Robert Davis D000131 | rep | MI | 1983-01-03 | 1985-01-03 | Republican | 11 | |||||||||||||
34378 | 34378 | William Dickinson D000326 | rep | AL | 1983-01-03 | 1985-01-03 | Republican | 2 | |||||||||||||
34385 | 34385 | Brian Donnelly D000416 | rep | MA | 1983-01-03 | 1985-01-03 | Democrat | 11 | |||||||||||||
34394 | 34394 | Thomas Downey D000471 | rep | NY | 1983-01-03 | 1985-01-03 | Democrat | 2 | |||||||||||||
34400 | 34400 | Bernard Dwyer D000586 | rep | NJ | 1983-01-03 | 1985-01-03 | Democrat | 6 | |||||||||||||
34406 | 34406 | Mervyn Dymally D000592 | rep | CA | 1983-01-03 | 1985-01-03 | Democrat | 31 | |||||||||||||
34415 | 34415 | Joseph Early E000013 | rep | MA | 1983-01-03 | 1985-01-03 | Democrat | 3 | |||||||||||||
34421 | 34421 | Dennis Eckart E000031 | rep | OH | 1983-01-03 | 1985-01-03 | Democrat | 11 | |||||||||||||
34429 | 34429 | Marvin Edwards E000077 | rep | OK | 1983-01-03 | 1985-01-03 | Republican | 5 | |||||||||||||
34434 | 34434 | Ben Erdreich E000201 | rep | AL | 1983-01-03 | 1985-01-03 | Democrat | 6 | |||||||||||||
34439 | 34439 | J. Exon E000284 | sen | NE | 1979-01-15 | 1985-01-03 | 2 | Democrat | |||||||||||||
34456 | 34456 | Dante Fascell F000041 | rep | FL | 1983-01-03 | 1985-01-03 | Democrat | 19 | |||||||||||||
34461 | 34461 | Edward Feighan F000059 | rep | OH | 1983-01-03 | 1985-01-03 | Democrat | 19 | |||||||||||||
34478 | 34478 | Joseph Gaydos G000105 | rep | PA | 1983-01-03 | 1985-01-03 | Democrat | 20 | |||||||||||||
34486 | 34486 | Albert Gore G000321 | rep | TN | 1983-01-03 | 1985-01-03 | Democrat | 6 | |||||||||||||
34491 | 34491 | William Gray G000402 | rep | PA | 1983-01-03 | 1985-01-03 | Democrat | 2 | |||||||||||||
34499 | 34499 | Sedgwick Green G000417 | rep | NY | 1983-01-03 | 1985-01-03 | Republican | 15 | |||||||||||||
34506 | 34506 | Frank Guarini G000511 | rep | NJ | 1983-01-03 | 1985-01-03 | Democrat | 14 | |||||||||||||
34519 | 34519 | John Hammerschmidt H000124 | rep | AR | 1983-01-03 | 1985-01-03 | Republican | 3 | |||||||||||||
34528 | 34528 | Charles Hatcher H000340 | rep | GA | 1983-01-03 | 1985-01-03 | Democrat | 2 | |||||||||||||
34535 | 34535 | Mark Hatfield H000343 | sen | OR | 1979-01-15 | 1985-01-03 | 2 | Republican | |||||||||||||
34538 | 34538 | Charles Hayes H000388 | rep | IL | 1983-01-03 | 1985-01-03 | Democrat | 1 | |||||||||||||
34543 | 34543 | Howell Heflin H000445 | sen | AL | 1979-01-15 | 1985-01-03 | 2 | Democrat | |||||||||||||
34547 | 34547 | Dennis Hertel H000547 | rep | MI | 1983-01-03 | 1985-01-03 | Democrat | 14 | |||||||||||||
34557 | 34557 | Larry Hopkins H000776 | rep | KY | 1983-01-03 | 1985-01-03 | Republican | 6 |
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);