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 party descending
This data as json, copyable, CSV (advanced)
Suggested facets: end, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
31433 | 31433 | Garry Brown B000917 | rep | MI | 1977-01-04 | 1979-01-03 | Republican | 3 | |||||||||||||
31439 | 31439 | J. Burke B001091 | rep | FL | 1977-01-04 | 1979-01-03 | Republican | 12 | |||||||||||||
31480 | 31480 | Bruce Caputo C000137 | rep | NY | 1977-01-04 | 1979-01-03 | Republican | 23 | |||||||||||||
31498 | 31498 | Elford Cederberg C000263 | rep | MI | 1977-01-04 | 1979-01-03 | Republican | 10 | |||||||||||||
31506 | 31506 | Delwin Clawson C000476 | rep | CA | 1977-01-04 | 1979-01-03 | Republican | 33 | |||||||||||||
31510 | 31510 | John Cunningham C000992 | rep | WA | 1977-01-04 | 1979-01-03 | Republican | 7 | |||||||||||||
31581 | 31581 | Louis Frey F000381 | rep | FL | 1977-01-04 | 1979-01-03 | Republican | 9 | |||||||||||||
31590 | 31590 | Samuel Hayakawa H000384 | sen | CA | 1977-01-04 | 1983-01-03 | 1 | Republican | |||||||||||||
31602 | 31602 | William Ketchum K000153 | rep | CA | 1977-01-04 | 1979-01-03 | Republican | 18 | |||||||||||||
31693 | 31693 | Gary Myers M001128 | rep | PA | 1977-01-04 | 1979-01-03 | Republican | 25 | |||||||||||||
31708 | 31708 | Shirley Pettis P000273 | rep | CA | 1977-01-04 | 1979-01-03 | Republican | 37 | |||||||||||||
31749 | 31749 | Albert Quie Q000010 | rep | MN | 1977-01-04 | 1979-01-03 | Republican | 1 | |||||||||||||
31782 | 31782 | Philip Ruppe R000512 | rep | MI | 1977-01-04 | 1979-01-03 | Republican | 11 | |||||||||||||
31788 | 31788 | Ronald Sarasin S000062 | rep | CT | 1977-01-04 | 1979-01-03 | Republican | 5 | |||||||||||||
31789 | 31789 | Harrison Schmitt S000132 | sen | NM | 1977-01-04 | 1983-01-03 | 1 | Republican | |||||||||||||
31838 | 31838 | Joe Skubitz S000472 | rep | KS | 1977-01-04 | 1979-01-03 | Republican | 5 | |||||||||||||
31839 | 31839 | Newton Steers S000844 | rep | MD | 1977-01-04 | 1979-01-03 | Republican | 8 | |||||||||||||
31845 | 31845 | William Steiger S000847 | rep | WI | 1977-01-04 | 1979-01-03 | Republican | 6 | |||||||||||||
31866 | 31866 | Charles Thone T000234 | rep | NE | 1977-01-04 | 1979-01-03 | Republican | 1 | |||||||||||||
31880 | 31880 | William Walsh W000107 | rep | NY | 1977-01-04 | 1979-01-03 | Republican | 33 | |||||||||||||
31886 | 31886 | Charles Whalen W000317 | rep | OH | 1977-01-04 | 1979-01-03 | Republican | 3 | |||||||||||||
31892 | 31892 | Charles Wiggins W000448 | rep | CA | 1977-01-04 | 1979-01-03 | Republican | 39 | |||||||||||||
31928 | 31928 | John Anderson A000195 | rep | IL | 1977-01-04 | 1979-01-03 | Republican | 16 | |||||||||||||
31951 | 31951 | Robert Bauman B000244 | rep | MD | 1977-01-04 | 1979-01-03 | Republican | 1 | |||||||||||||
31973 | 31973 | John Buchanan B001008 | rep | AL | 1977-01-04 | 1979-01-03 | Republican | 6 | |||||||||||||
31987 | 31987 | Tim Carter C000201 | rep | KY | 1977-01-04 | 1979-01-03 | Republican | 5 | |||||||||||||
31998 | 31998 | James Cleveland C000512 | rep | NH | 1977-01-04 | 1979-01-03 | Republican | 2 | |||||||||||||
32024 | 32024 | Samuel Devine D000279 | rep | OH | 1977-01-04 | 1979-01-03 | Republican | 12 | |||||||||||||
32108 | 32108 | William Harsha H000281 | rep | OH | 1977-01-04 | 1979-01-03 | Republican | 6 | |||||||||||||
32144 | 32144 | James Johnson J000148 | rep | CO | 1977-01-04 | 1979-01-03 | Republican | 4 | |||||||||||||
32147 | 32147 | Richard Kelly K000077 | rep | FL | 1977-01-04 | 1979-01-03 | Republican | 5 | |||||||||||||
32172 | 32172 | Robert McEwen M000433 | rep | NY | 1977-01-04 | 1979-01-03 | Republican | 30 | |||||||||||||
32281 | 32281 | Keith Sebelius S000217 | rep | KS | 1977-01-04 | 1979-01-03 | Republican | 1 | |||||||||||||
32350 | 32350 | David Treen T000362 | rep | LA | 1977-01-04 | 1979-01-03 | Republican | 3 | |||||||||||||
32410 | 32410 | Robert Wilson W000610 | rep | CA | 1977-01-04 | 1979-01-03 | Republican | 41 | |||||||||||||
32428 | 32428 | John Wydler W000780 | rep | NY | 1977-01-04 | 1979-01-03 | Republican | 5 | |||||||||||||
32432 | 32432 | James Abdnor A000009 | rep | SD | 1977-01-04 | 1979-01-03 | Republican | 2 | |||||||||||||
32442 | 32442 | Mark Andrews A000208 | rep | ND | 1977-01-04 | 1979-01-03 | Republican | 0 | |||||||||||||
32454 | 32454 | John Ashbrook A000221 | rep | OH | 1977-01-04 | 1979-01-03 | Republican | 17 | |||||||||||||
32461 | 32461 | Louis Bafalis B000029 | rep | FL | 1977-01-04 | 1979-01-03 | Republican | 10 | |||||||||||||
32469 | 32469 | Robin Beard B000280 | rep | TN | 1977-01-04 | 1979-01-03 | Republican | 6 | |||||||||||||
32529 | 32529 | Clarence Brown B000910 | rep | OH | 1977-01-04 | 1979-01-03 | Republican | 7 | |||||||||||||
32534 | 32534 | Clair Burgener B001080 | rep | CA | 1977-01-04 | 1979-01-03 | Republican | 43 | |||||||||||||
32545 | 32545 | Manley Butler B001182 | rep | VA | 1977-01-04 | 1979-01-03 | Republican | 6 | |||||||||||||
32563 | 32563 | Donald Clausen C000475 | rep | CA | 1977-01-04 | 1979-01-03 | Republican | 2 | |||||||||||||
32571 | 32571 | James Collins C000638 | rep | TX | 1977-01-04 | 1979-01-03 | Republican | 3 | |||||||||||||
32583 | 32583 | Robert Daniel D000037 | rep | VA | 1977-01-04 | 1979-01-03 | Republican | 4 | |||||||||||||
32605 | 32605 | Edward Derwinski D000269 | rep | IL | 1977-01-04 | 1979-01-03 | Republican | 4 | |||||||||||||
32617 | 32617 | David Emery E000175 | rep | ME | 1977-01-04 | 1979-01-03 | Republican | 1 | |||||||||||||
32632 | 32632 | Thomas Evans E000258 | rep | DE | 1977-01-04 | 1979-01-03 | Republican | 0 | |||||||||||||
32640 | 32640 | Millicent Fenwick F000078 | rep | NJ | 1977-01-04 | 1979-01-03 | Republican | 5 | |||||||||||||
32651 | 32651 | Paul Findley F000123 | rep | IL | 1977-01-04 | 1979-01-03 | Republican | 20 | |||||||||||||
32687 | 32687 | Barry Goldwater G000268 | rep | CA | 1977-01-04 | 1979-01-03 | Republican | 20 | |||||||||||||
32694 | 32694 | Tennyson Guyer G000537 | rep | OH | 1977-01-04 | 1979-01-03 | Republican | 4 | |||||||||||||
32698 | 32698 | Thomas Hagedorn H000012 | rep | MN | 1977-01-04 | 1979-01-03 | Republican | 2 | |||||||||||||
32709 | 32709 | Margaret Heckler H000440 | rep | MA | 1977-01-04 | 1979-01-03 | Republican | 10 | |||||||||||||
32718 | 32718 | Harold Hollenbeck H000722 | rep | NJ | 1977-01-04 | 1979-01-03 | Republican | 9 | |||||||||||||
32740 | 32740 | Marc Marks M000136 | rep | PA | 1977-01-04 | 1979-01-03 | Republican | 24 | |||||||||||||
32761 | 32761 | Robert McClory M000340 | rep | IL | 1977-01-04 | 1979-01-03 | Republican | 13 | |||||||||||||
32769 | 32769 | Paul McCloskey M000343 | rep | CA | 1977-01-04 | 1979-01-03 | Republican | 12 | |||||||||||||
32774 | 32774 | Donald Mitchell M000808 | rep | NY | 1977-01-04 | 1979-01-03 | Republican | 31 | |||||||||||||
32806 | 32806 | Thomas Railsback R000012 | rep | IL | 1977-01-04 | 1979-01-03 | Republican | 19 | |||||||||||||
32835 | 32835 | John Rhodes R000188 | rep | AZ | 1977-01-04 | 1979-01-03 | Republican | 1 | |||||||||||||
32848 | 32848 | John Rousselot R000469 | rep | CA | 1977-01-04 | 1979-01-03 | Republican | 26 | |||||||||||||
32864 | 32864 | John Stanton S000804 | rep | OH | 1977-01-04 | 1979-01-03 | Republican | 11 | |||||||||||||
32868 | 32868 | David Stockman S000935 | rep | MI | 1977-01-04 | 1979-01-03 | Republican | 4 | |||||||||||||
32877 | 32877 | William Wampler W000121 | rep | VA | 1977-01-04 | 1979-01-03 | Republican | 9 | |||||||||||||
32928 | 32928 | Barber Conable C000666 | rep | NY | 1977-01-04 | 1979-01-03 | Republican | 35 | |||||||||||||
32932 | 32932 | Thomas Corcoran C000773 | rep | IL | 1977-01-04 | 1979-01-03 | Republican | 15 | |||||||||||||
32954 | 32954 | William Edwards E000084 | rep | AL | 1977-01-04 | 1979-01-03 | Republican | 1 | |||||||||||||
32964 | 32964 | John Erlenborn E000204 | rep | IL | 1977-01-04 | 1979-01-03 | Republican | 14 | |||||||||||||
32976 | 32976 | Edwin Forsythe F000286 | rep | NJ | 1977-01-04 | 1979-01-03 | Republican | 6 | |||||||||||||
32988 | 32988 | George Hansen H000171 | rep | ID | 1977-01-04 | 1979-01-03 | Republican | 2 | |||||||||||||
33039 | 33039 | David Marriott M000143 | rep | UT | 1977-01-04 | 1979-01-03 | Republican | 2 | |||||||||||||
33045 | 33045 | James Martin M000183 | rep | NC | 1977-01-04 | 1979-01-03 | Republican | 9 | |||||||||||||
33107 | 33107 | Joel Pritchard P000546 | rep | WA | 1977-01-04 | 1979-01-03 | Republican | 1 | |||||||||||||
33123 | 33123 | James Robinson R000337 | rep | VA | 1977-01-04 | 1979-01-03 | Republican | 7 | |||||||||||||
33139 | 33139 | Harold Sawyer S000087 | rep | MI | 1977-01-04 | 1979-01-03 | Republican | 5 | |||||||||||||
33153 | 33153 | Robert Stafford S000776 | sen | VT | 1977-01-04 | 1983-01-03 | 1 | Republican | |||||||||||||
33162 | 33162 | Paul Trible T000367 | rep | VA | 1977-01-04 | 1979-01-03 | Republican | 1 | |||||||||||||
33171 | 33171 | Lowell Weicker W000253 | sen | CT | 1977-01-04 | 1983-01-03 | 1 | Republican | |||||||||||||
33181 | 33181 | Edward Winn W000636 | rep | KS | 1977-01-04 | 1979-01-03 | Republican | 3 | |||||||||||||
33227 | 33227 | William Armstrong A000219 | rep | CO | 1977-01-04 | 1979-01-03 | Republican | 5 | |||||||||||||
33302 | 33302 | Elwood Hillis H000624 | rep | IN | 1977-01-04 | 1979-01-03 | Republican | 5 | |||||||||||||
33309 | 33309 | Marjorie Holt H000747 | rep | MD | 1977-01-04 | 1979-01-03 | Republican | 4 | |||||||||||||
33324 | 33324 | Thomas Kindness K000190 | rep | OH | 1977-01-04 | 1979-01-03 | Republican | 8 | |||||||||||||
33370 | 33370 | William Moore M000923 | rep | LA | 1977-01-04 | 1979-01-03 | Republican | 6 | |||||||||||||
33377 | 33377 | George O’Brien O000010 | rep | IL | 1977-01-04 | 1979-01-03 | Republican | 17 | |||||||||||||
33399 | 33399 | Eldon Rudd R000495 | rep | AZ | 1977-01-04 | 1979-01-03 | Republican | 4 | |||||||||||||
33421 | 33421 | Marion Snyder S000669 | rep | KY | 1977-01-04 | 1979-01-03 | Republican | 4 | |||||||||||||
33438 | 33438 | George Whitehurst W000406 | rep | VA | 1977-01-04 | 1979-01-03 | Republican | 2 | |||||||||||||
33464 | 33464 | James Broyhill B000966 | rep | NC | 1977-01-04 | 1979-01-03 | Republican | 10 | |||||||||||||
33478 | 33478 | Robert Badham B000024 | rep | CA | 1977-01-04 | 1979-01-03 | Republican | 40 | |||||||||||||
33572 | 33572 | John Duncan D000534 | rep | TN | 1977-01-04 | 1979-01-03 | Republican | 2 | |||||||||||||
33624 | 33624 | Robert Kasten K000019 | rep | WI | 1977-01-04 | 1979-01-03 | Republican | 9 | |||||||||||||
33630 | 33630 | Jack Kemp K000086 | rep | NY | 1977-01-04 | 1979-01-03 | Republican | 38 | |||||||||||||
33646 | 33646 | Delbert Latta L000116 | rep | OH | 1977-01-04 | 1979-01-03 | Republican | 5 | |||||||||||||
33661 | 33661 | Manuel Luján L000506 | rep | NM | 1977-01-04 | 1979-01-03 | Republican | 1 | |||||||||||||
33673 | 33673 | Stewart McKinney M000527 | rep | CT | 1977-01-04 | 1979-01-03 | Republican | 4 | |||||||||||||
33717 | 33717 | James Quayle Q000007 | rep | IN | 1977-01-04 | 1979-01-03 | Republican | 4 |
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);