legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
481 rows where "start" is on date 1989-01-03 sorted by state
This data as json, copyable, CSV (advanced)
Suggested facets: type, party, end (date)
end 17 ✖
- 1991-01-03 437
- 1995-01-03 28
- 1991-12-31 2
- 1989-05-30 1
- 1989-06-15 1
- 1989-06-30 1
- 1989-08-07 1
- 1989-08-13 1
- 1989-12-31 1
- 1990-01-07 1
- 1990-01-16 1
- 1990-03-17 1
- 1990-05-15 1
- 1990-12-07 1
- 1992-09-08 1
- 1993-01-03 1
- 1993-12-31 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
41672 | 41672 | Don Young Y000033 | rep | AK | 1989-01-03 | 1991-01-03 | Republican | 0 | |||||||||||||
33905 | 33905 | Ronnie Flippo F000208 | rep | AL | 1989-01-03 | 1991-01-03 | Democrat | 5 | |||||||||||||
34381 | 34381 | William Dickinson D000326 | rep | AL | 1989-01-03 | 1991-01-03 | Republican | 2 | |||||||||||||
34437 | 34437 | Ben Erdreich E000201 | rep | AL | 1989-01-03 | 1991-01-03 | Democrat | 6 | |||||||||||||
34525 | 34525 | Claude Harris H000236 | rep | AL | 1989-01-03 | 1991-01-03 | Democrat | 7 | |||||||||||||
35704 | 35704 | Tom Bevill B000431 | rep | AL | 1989-01-03 | 1991-01-03 | Democrat | 4 | |||||||||||||
35713 | 35713 | John Browder B000897 | rep | AL | 1989-01-03 | 1991-01-03 | Democrat | 3 | |||||||||||||
36847 | 36847 | H. Callahan C000052 | rep | AL | 1989-01-03 | 1991-01-03 | Republican | 1 | |||||||||||||
34073 | 34073 | Tommy Robinson R000354 | rep | AR | 1989-01-03 | 1991-01-03 | Republican | 2 | [ { "start": "1989-01-03", "end": "1989-07-28", "party": "Democrat" }, { "start": "1989-07-28", "end": "1991-01-03", "party": "Republican" } ] |
||||||||||||
34172 | 34172 | William Alexander A000103 | rep | AR | 1989-01-03 | 1991-01-03 | Democrat | 1 | |||||||||||||
34205 | 34205 | Beryl Anthony A000213 | rep | AR | 1989-01-03 | 1991-01-03 | Democrat | 4 | |||||||||||||
34522 | 34522 | John Hammerschmidt H000124 | rep | AR | 1989-01-03 | 1991-01-03 | Republican | 3 | |||||||||||||
39829 | 39829 | Eni Faleomavaega F000010 | rep | AS | 1989-01-03 | 1991-01-03 | Democrat | 0 | |||||||||||||
33879 | 33879 | Dennis DeConcini D000185 | sen | AZ | 1989-01-03 | 1995-01-03 | 1 | Democrat | |||||||||||||
34867 | 34867 | John Rhodes R000189 | rep | AZ | 1989-01-03 | 1991-01-03 | Republican | 1 | |||||||||||||
35027 | 35027 | Morris Udall U000001 | rep | AZ | 1989-01-03 | 1991-01-03 | Democrat | 2 | |||||||||||||
37176 | 37176 | Robert Stump S001044 | rep | AZ | 1989-01-03 | 1991-01-03 | Republican | 3 | |||||||||||||
37748 | 37748 | James Kolbe K000306 | rep | AZ | 1989-01-03 | 1991-01-03 | Republican | 5 | |||||||||||||
40660 | 40660 | Jon Kyl K000352 | rep | AZ | 1989-01-03 | 1991-01-03 | Republican | 4 | |||||||||||||
33813 | 33813 | Jim Bates B000236 | rep | CA | 1989-01-03 | 1991-01-03 | Democrat | 44 | |||||||||||||
33834 | 33834 | Douglas Bosco B000648 | rep | CA | 1989-01-03 | 1991-01-03 | Democrat | 1 | |||||||||||||
33860 | 33860 | Anthony Coelho C000581 | rep | CA | 1989-01-03 | 1989-06-15 | Democrat | 15 | |||||||||||||
33946 | 33946 | Augustus Hawkins H000367 | rep | CA | 1989-01-03 | 1991-01-03 | Democrat | 29 | |||||||||||||
34045 | 34045 | Charles Pashayan P000097 | rep | CA | 1989-01-03 | 1991-01-03 | Republican | 17 | |||||||||||||
34095 | 34095 | Norman Shumway S000393 | rep | CA | 1989-01-03 | 1991-01-03 | Republican | 14 | |||||||||||||
34141 | 34141 | Pete Wilson W000607 | sen | CA | 1989-01-03 | 1991-12-31 | 1 | Republican | |||||||||||||
34184 | 34184 | Glenn Anderson A000189 | rep | CA | 1989-01-03 | 1991-01-03 | Democrat | 32 | |||||||||||||
34360 | 34360 | William Dannemeyer D000044 | rep | CA | 1989-01-03 | 1991-01-03 | Republican | 39 | |||||||||||||
34409 | 34409 | Mervyn Dymally D000592 | rep | CA | 1989-01-03 | 1991-01-03 | Democrat | 31 | |||||||||||||
34661 | 34661 | Robert Lagomarsino L000020 | rep | CA | 1989-01-03 | 1991-01-03 | Republican | 19 | |||||||||||||
34687 | 34687 | Meldon Levine L000264 | rep | CA | 1989-01-03 | 1991-01-03 | Democrat | 27 | |||||||||||||
34693 | 34693 | William Lowery L000479 | rep | CA | 1989-01-03 | 1991-01-03 | Republican | 41 | |||||||||||||
34911 | 34911 | Edward Roybal R000485 | rep | CA | 1989-01-03 | 1991-01-03 | Democrat | 25 | |||||||||||||
35212 | 35212 | William Edwards E000064 | rep | CA | 1989-01-03 | 1991-01-03 | Democrat | 10 | |||||||||||||
35363 | 35363 | Richard Lehman L000225 | rep | CA | 1989-01-03 | 1991-01-03 | Democrat | 18 | |||||||||||||
35407 | 35407 | Alfred McCandless M000306 | rep | CA | 1989-01-03 | 1991-01-03 | Republican | 37 | |||||||||||||
35499 | 35499 | Leon Panetta P000047 | rep | CA | 1989-01-03 | 1991-01-03 | Democrat | 16 | |||||||||||||
35689 | 35689 | Anthony Beilenson B000318 | rep | CA | 1989-01-03 | 1991-01-03 | Democrat | 23 | |||||||||||||
35777 | 35777 | Robert Dornan D000435 | rep | CA | 1989-01-03 | 1991-01-03 | Republican | 38 | |||||||||||||
35914 | 35914 | Norman Mineta M000794 | rep | CA | 1989-01-03 | 1991-01-03 | Democrat | 13 | |||||||||||||
35941 | 35941 | Carlos Moorhead M000926 | rep | CA | 1989-01-03 | 1991-01-03 | Republican | 22 | |||||||||||||
36151 | 36151 | Ronald Dellums D000222 | rep | CA | 1989-01-03 | 1991-01-03 | Democrat | 8 | |||||||||||||
36168 | 36168 | Victor Fazio F000053 | rep | CA | 1989-01-03 | 1991-01-03 | Democrat | 4 | |||||||||||||
36431 | 36431 | Esteban Torres T000316 | rep | CA | 1989-01-03 | 1991-01-03 | Democrat | 34 | |||||||||||||
36534 | 36534 | George Brown B000918 | rep | CA | 1989-01-03 | 1991-01-03 | Democrat | 36 | |||||||||||||
36545 | 36545 | Tom Campbell C000100 | rep | CA | 1989-01-03 | 1991-01-03 | Republican | 12 | |||||||||||||
36597 | 36597 | Julian Dixon D000373 | rep | CA | 1989-01-03 | 1991-01-03 | Democrat | 28 | |||||||||||||
36690 | 36690 | Matthew Martínez M000206 | rep | CA | 1989-01-03 | 1991-01-03 | Democrat | 30 | |||||||||||||
36727 | 36727 | Ron Packard P000005 | rep | CA | 1989-01-03 | 1991-01-03 | Republican | 43 | |||||||||||||
36871 | 36871 | Gary Condit C000670 | rep | CA | 1989-01-03 | 1991-01-03 | Democrat | 15 | |||||||||||||
37420 | 37420 | Robert Matsui M000249 | rep | CA | 1989-01-03 | 1991-01-03 | Democrat | 3 | |||||||||||||
37571 | 37571 | C. Cox C000830 | rep | CA | 1989-01-03 | 1991-01-03 | Republican | 40 | |||||||||||||
37911 | 37911 | William Thomas T000188 | rep | CA | 1989-01-03 | 1991-01-03 | Republican | 20 | |||||||||||||
38119 | 38119 | Duncan Hunter H000981 | rep | CA | 1989-01-03 | 1991-01-03 | Republican | 45 | |||||||||||||
38184 | 38184 | Tom Lantos L000090 | rep | CA | 1989-01-03 | 1991-01-03 | Democrat | 11 | |||||||||||||
39146 | 39146 | Howard Berman B000410 | rep | CA | 1989-01-03 | 1991-01-03 | Democrat | 26 | |||||||||||||
39257 | 39257 | David Dreier D000492 | rep | CA | 1989-01-03 | 1991-01-03 | Republican | 33 | |||||||||||||
39286 | 39286 | Elton Gallegly G000021 | rep | CA | 1989-01-03 | 1991-01-03 | Republican | 21 | |||||||||||||
39307 | 39307 | Walter Herger H000528 | rep | CA | 1989-01-03 | 1991-01-03 | Republican | 2 | |||||||||||||
39388 | 39388 | Jerry Lewis L000274 | rep | CA | 1989-01-03 | 1991-01-03 | Republican | 35 | |||||||||||||
39521 | 39521 | Fortney Stark S000810 | rep | CA | 1989-01-03 | 1991-01-03 | Democrat | 9 | |||||||||||||
39969 | 39969 | George Miller M000725 | rep | CA | 1989-01-03 | 1991-01-03 | Democrat | 7 | |||||||||||||
40086 | 40086 | Henry Waxman W000215 | rep | CA | 1989-01-03 | 1991-01-03 | Democrat | 24 | |||||||||||||
40204 | 40204 | Barbara Boxer B000711 | rep | CA | 1989-01-03 | 1991-01-03 | Democrat | 6 | |||||||||||||
40974 | 40974 | Dana Rohrabacher R000409 | rep | CA | 1989-01-03 | 1991-01-03 | Republican | 42 | |||||||||||||
43073 | 43073 | Nancy Pelosi P000197 | rep | CA | 1989-01-03 | 1991-01-03 | Democrat | 5 | |||||||||||||
34287 | 34287 | George Brown B000919 | rep | CO | 1989-01-03 | 1991-01-03 | Republican | 4 | |||||||||||||
36032 | 36032 | Patricia Schroeder S000142 | rep | CO | 1989-01-03 | 1991-01-03 | Democrat | 1 | |||||||||||||
36356 | 36356 | Daniel Schaefer S000109 | rep | CO | 1989-01-03 | 1991-01-03 | Republican | 6 | |||||||||||||
36367 | 36367 | David Skaggs S000462 | rep | CO | 1989-01-03 | 1991-01-03 | Democrat | 2 | |||||||||||||
36541 | 36541 | Ben Campbell C000077 | rep | CO | 1989-01-03 | 1991-01-03 | Democrat | 3 | |||||||||||||
37682 | 37682 | Joel Hefley H000444 | rep | CO | 1989-01-03 | 1991-01-03 | Republican | 5 | |||||||||||||
34029 | 34029 | Bruce Morrison M000992 | rep | CT | 1989-01-03 | 1991-01-03 | Democrat | 3 | |||||||||||||
34076 | 34076 | John Rowland R000482 | rep | CT | 1989-01-03 | 1991-01-03 | Republican | 5 | |||||||||||||
36276 | 36276 | Barbara Kennelly K000118 | rep | CT | 1989-01-03 | 1991-01-03 | Democrat | 1 | |||||||||||||
36625 | 36625 | Sam Gejdenson G000120 | rep | CT | 1989-01-03 | 1991-01-03 | Democrat | 2 | |||||||||||||
37728 | 37728 | Nancy Johnson J000163 | rep | CT | 1989-01-03 | 1991-01-03 | Republican | 6 | |||||||||||||
38334 | 38334 | Christopher Shays S001144 | rep | CT | 1989-01-03 | 1991-01-03 | Republican | 4 | |||||||||||||
39059 | 39059 | Joseph Lieberman L000304 | sen | CT | 1989-01-03 | 1995-01-03 | 1 | Democrat | |||||||||||||
33898 | 33898 | Walter Fauntroy F000046 | rep | DC | 1989-01-03 | 1991-01-03 | Democrat | 0 | |||||||||||||
36022 | 36022 | William Roth R000460 | sen | DE | 1989-01-03 | 1995-01-03 | 1 | Republican | |||||||||||||
41761 | 41761 | Thomas Carper C000174 | rep | DE | 1989-01-03 | 1991-01-03 | Democrat | 0 | |||||||||||||
33932 | 33932 | James Grant G000382 | rep | FL | 1989-01-03 | 1991-01-03 | Republican | 2 | [ { "start": "1989-01-03", "end": "1989-02-21", "party": "Democrat" }, { "start": "1989-02-21", "end": "1991-01-03", "party": "Republican" } ] |
||||||||||||
34062 | 34062 | Claude Pepper P000218 | rep | FL | 1989-01-03 | 1989-05-30 | Democrat | 18 | |||||||||||||
34253 | 34253 | Charles Bennett B000371 | rep | FL | 1989-01-03 | 1991-01-03 | Democrat | 3 | |||||||||||||
34459 | 34459 | Dante Fascell F000041 | rep | FL | 1989-01-03 | 1991-01-03 | Democrat | 19 | |||||||||||||
34601 | 34601 | Andrew Ireland I000029 | rep | FL | 1989-01-03 | 1991-01-03 | Republican | 10 | |||||||||||||
34603 | 34603 | Craig James J000047 | rep | FL | 1989-01-03 | 1991-01-03 | Republican | 4 | |||||||||||||
34671 | 34671 | William Lehman L000226 | rep | FL | 1989-01-03 | 1991-01-03 | Democrat | 17 | |||||||||||||
34973 | 34973 | Lawrence Smith S000586 | rep | FL | 1989-01-03 | 1991-01-03 | Democrat | 16 | |||||||||||||
35342 | 35342 | Earl Hutto H001018 | rep | FL | 1989-01-03 | 1991-01-03 | Democrat | 1 | |||||||||||||
35370 | 35370 | Thomas Lewis L000295 | rep | FL | 1989-01-03 | 1991-01-03 | Republican | 12 | |||||||||||||
35834 | 35834 | Sam Gibbons G000153 | rep | FL | 1989-01-03 | 1991-01-03 | Democrat | 7 | |||||||||||||
35878 | 35878 | Harry Johnston J000187 | rep | FL | 1989-01-03 | 1991-01-03 | Democrat | 14 | |||||||||||||
35898 | 35898 | Connie Mack M000019 | sen | FL | 1989-01-03 | 1995-01-03 | 1 | Republican | |||||||||||||
36700 | 36700 | Bill McCollum M000350 | rep | FL | 1989-01-03 | 1991-01-03 | Republican | 5 | |||||||||||||
37356 | 37356 | Porter Goss G000336 | rep | FL | 1989-01-03 | 1991-01-03 | Republican | 13 | |||||||||||||
37523 | 37523 | Michael Bilirakis B000463 | rep | FL | 1989-01-03 | 1991-01-03 | Republican | 9 | |||||||||||||
37866 | 37866 | E. Shaw S000303 | rep | FL | 1989-01-03 | 1991-01-03 | Republican | 15 | |||||||||||||
39533 | 39533 | Clifford Stearns S000822 | rep | FL | 1989-01-03 | 1991-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);