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 rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: type
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
44427 | 44427 | Kweisi Mfume M000687 | rep | MD | 1989-01-03 | 1991-01-03 | Democrat | 7 | |||||||||||||
43634 | 43634 | Ron Wyden W000779 | rep | OR | 1989-01-03 | 1991-01-03 | Democrat | 3 | |||||||||||||
43513 | 43513 | Fred Upton U000031 | rep | MI | 1989-01-03 | 1991-01-03 | Republican | 4 | |||||||||||||
43415 | 43415 | Christopher Smith S000522 | rep | NJ | 1989-01-03 | 1991-01-03 | Republican | 4 | |||||||||||||
43290 | 43290 | Charles Schumer S000148 | rep | NY | 1989-01-03 | 1991-01-03 | Democrat | 10 | |||||||||||||
43154 | 43154 | Harold Rogers R000395 | rep | KY | 1989-01-03 | 1991-01-03 | Republican | 5 | |||||||||||||
43127 | 43127 | David Price P000523 | rep | NC | 1989-01-03 | 1991-01-03 | Democrat | 4 | |||||||||||||
43073 | 43073 | Nancy Pelosi P000197 | rep | CA | 1989-01-03 | 1991-01-03 | Democrat | 5 | |||||||||||||
43040 | 43040 | Frank Pallone P000034 | rep | NJ | 1989-01-03 | 1991-01-03 | Democrat | 3 | |||||||||||||
43000 | 43000 | Richard Neal N000015 | rep | MA | 1989-01-03 | 1991-01-03 | Democrat | 2 | |||||||||||||
42822 | 42822 | Edward Markey M000133 | rep | MA | 1989-01-03 | 1991-01-03 | Democrat | 7 | |||||||||||||
42615 | 42615 | Marcy Kaptur K000009 | rep | OH | 1989-01-03 | 1991-01-03 | Democrat | 9 | |||||||||||||
42536 | 42536 | Steny Hoyer H000874 | rep | MD | 1989-01-03 | 1991-01-03 | Democrat | 5 | |||||||||||||
42267 | 42267 | Peter DeFazio D000191 | rep | OR | 1989-01-03 | 1991-01-03 | Democrat | 4 | |||||||||||||
42201 | 42201 | Jim Cooper C000754 | rep | TN | 1989-01-03 | 1991-01-03 | Democrat | 4 | |||||||||||||
41857 | 41857 | James Inhofe I000024 | rep | OK | 1989-01-03 | 1991-01-03 | Republican | 1 | |||||||||||||
41839 | 41839 | Richard Durbin D000563 | rep | IL | 1989-01-03 | 1991-01-03 | Democrat | 20 | |||||||||||||
41761 | 41761 | Thomas Carper C000174 | rep | DE | 1989-01-03 | 1991-01-03 | Democrat | 0 | |||||||||||||
41746 | 41746 | Benjamin Cardin C000141 | rep | MD | 1989-01-03 | 1991-01-03 | Democrat | 3 | |||||||||||||
41672 | 41672 | Don Young Y000033 | rep | AK | 1989-01-03 | 1991-01-03 | Republican | 0 | |||||||||||||
41514 | 41514 | Peter Visclosky V000108 | rep | IN | 1989-01-03 | 1991-01-03 | Democrat | 1 | |||||||||||||
41466 | 41466 | José Serrano S000248 | rep | NY | 1989-01-03 | 1991-01-03 | Democrat | 18 | |||||||||||||
41450 | 41450 | F. Sensenbrenner S000244 | rep | WI | 1989-01-03 | 1991-01-03 | Republican | 9 | |||||||||||||
41389 | 41389 | Nita Lowey L000480 | rep | NY | 1989-01-03 | 1991-01-03 | Democrat | 20 | |||||||||||||
41327 | 41327 | Eliot Engel E000179 | rep | NY | 1989-01-03 | 1991-01-03 | Democrat | 19 | |||||||||||||
41270 | 41270 | Pat Roberts R000307 | rep | KS | 1989-01-03 | 1991-01-03 | Republican | 1 | |||||||||||||
41230 | 41230 | John Lewis L000287 | rep | GA | 1989-01-03 | 1991-01-03 | Democrat | 5 | |||||||||||||
41056 | 41056 | Lamar Smith S000583 | rep | TX | 1989-01-03 | 1991-01-03 | Republican | 21 | |||||||||||||
40998 | 40998 | Ileana Ros-Lehtinen R000435 | rep | FL | 1989-01-03 | 1991-01-03 | Republican | 18 | |||||||||||||
40974 | 40974 | Dana Rohrabacher R000409 | rep | CA | 1989-01-03 | 1991-01-03 | Republican | 42 | |||||||||||||
40908 | 40908 | Sander Levin L000263 | rep | MI | 1989-01-03 | 1991-01-03 | Democrat | 17 | |||||||||||||
40777 | 40777 | John Duncan D000533 | rep | TN | 1989-01-03 | 1991-01-03 | Republican | 2 | |||||||||||||
40696 | 40696 | Joe Barton B000213 | rep | TX | 1989-01-03 | 1991-01-03 | Republican | 6 | |||||||||||||
40686 | 40686 | Bill Nelson N000032 | rep | FL | 1989-01-03 | 1991-01-03 | Democrat | 11 | |||||||||||||
40674 | 40674 | Orrin Hatch H000338 | sen | UT | 1989-01-03 | 1995-01-03 | 1 | Republican | |||||||||||||
40660 | 40660 | Jon Kyl K000352 | rep | AZ | 1989-01-03 | 1991-01-03 | Republican | 4 | |||||||||||||
40603 | 40603 | Louise Slaughter S000480 | rep | NY | 1989-01-03 | 1991-01-03 | Democrat | 30 | |||||||||||||
40567 | 40567 | John Conyers C000714 | rep | MI | 1989-01-03 | 1991-01-03 | Democrat | 1 | |||||||||||||
40447 | 40447 | Charles Rangel R000053 | rep | NY | 1989-01-03 | 1991-01-03 | Democrat | 16 | |||||||||||||
40382 | 40382 | Jim McDermott M000404 | rep | WA | 1989-01-03 | 1991-01-03 | Democrat | 7 | |||||||||||||
40214 | 40214 | Daniel Coats C000542 | sen | IN | 1989-01-03 | 1993-01-03 | 3 | Republican | appointment | ||||||||||||
40204 | 40204 | Barbara Boxer B000711 | rep | CA | 1989-01-03 | 1991-01-03 | Democrat | 6 | |||||||||||||
40133 | 40133 | Howard Coble C000556 | rep | NC | 1989-01-03 | 1991-01-03 | Republican | 6 | |||||||||||||
40103 | 40103 | Frank Wolf W000672 | rep | VA | 1989-01-03 | 1991-01-03 | Republican | 10 | |||||||||||||
40086 | 40086 | Henry Waxman W000215 | rep | CA | 1989-01-03 | 1991-01-03 | Democrat | 24 | |||||||||||||
40033 | 40033 | Nick Rahall R000011 | rep | WV | 1989-01-03 | 1991-01-03 | Democrat | 4 | |||||||||||||
40014 | 40014 | Thomas Petri P000265 | rep | WI | 1989-01-03 | 1991-01-03 | Republican | 6 | |||||||||||||
39969 | 39969 | George Miller M000725 | rep | CA | 1989-01-03 | 1991-01-03 | Democrat | 7 | |||||||||||||
39860 | 39860 | Ralph Hall H000067 | rep | TX | 1989-01-03 | 1991-01-03 | Democrat | 4 | |||||||||||||
39829 | 39829 | Eni Faleomavaega F000010 | rep | AS | 1989-01-03 | 1991-01-03 | Democrat | 0 | |||||||||||||
39816 | 39816 | John Dingell D000355 | rep | MI | 1989-01-03 | 1991-01-03 | Democrat | 16 | |||||||||||||
39705 | 39705 | Tim Johnson J000177 | rep | SD | 1989-01-03 | 1991-01-03 | Democrat | 1 | |||||||||||||
39631 | 39631 | C. Young Y000031 | rep | FL | 1989-01-03 | 1991-01-03 | Republican | 8 | |||||||||||||
39605 | 39605 | Frank Lautenberg L000123 | sen | NJ | 1989-01-03 | 1995-01-03 | 1 | Democrat | |||||||||||||
39557 | 39557 | Edolphus Towns T000326 | rep | NY | 1989-01-03 | 1991-01-03 | Democrat | 11 | |||||||||||||
39533 | 39533 | Clifford Stearns S000822 | rep | FL | 1989-01-03 | 1991-01-03 | Republican | 6 | |||||||||||||
39521 | 39521 | Fortney Stark S000810 | rep | CA | 1989-01-03 | 1991-01-03 | Democrat | 9 | |||||||||||||
39388 | 39388 | Jerry Lewis L000274 | rep | CA | 1989-01-03 | 1991-01-03 | Republican | 35 | |||||||||||||
39351 | 39351 | Dale Kildee K000172 | rep | MI | 1989-01-03 | 1991-01-03 | Democrat | 7 | |||||||||||||
39307 | 39307 | Walter Herger H000528 | rep | CA | 1989-01-03 | 1991-01-03 | Republican | 2 | |||||||||||||
39286 | 39286 | Elton Gallegly G000021 | rep | CA | 1989-01-03 | 1991-01-03 | Republican | 21 | |||||||||||||
39273 | 39273 | Barney Frank F000339 | rep | MA | 1989-01-03 | 1991-01-03 | Democrat | 4 | |||||||||||||
39257 | 39257 | David Dreier D000492 | rep | CA | 1989-01-03 | 1991-01-03 | Republican | 33 | |||||||||||||
39241 | 39241 | Norman Dicks D000327 | rep | WA | 1989-01-03 | 1991-01-03 | Democrat | 6 | |||||||||||||
39220 | 39220 | Jerry Costello C000794 | rep | IL | 1989-01-03 | 1991-01-03 | Democrat | 21 | |||||||||||||
39196 | 39196 | Dan Burton B001149 | rep | IN | 1989-01-03 | 1991-01-03 | Republican | 6 | |||||||||||||
39146 | 39146 | Howard Berman B000410 | rep | CA | 1989-01-03 | 1991-01-03 | Democrat | 26 | |||||||||||||
39087 | 39087 | Gary Ackerman A000022 | rep | NY | 1989-01-03 | 1991-01-03 | Democrat | 7 | |||||||||||||
39076 | 39076 | Olympia Snowe S000663 | rep | ME | 1989-01-03 | 1991-01-03 | Republican | 2 | |||||||||||||
39065 | 39065 | Richard Lugar L000504 | sen | IN | 1989-01-03 | 1995-01-03 | 1 | Republican | |||||||||||||
39059 | 39059 | Joseph Lieberman L000304 | sen | CT | 1989-01-03 | 1995-01-03 | 1 | Democrat | |||||||||||||
39055 | 39055 | Herbert Kohl K000305 | sen | WI | 1989-01-03 | 1995-01-03 | 1 | Democrat | |||||||||||||
39042 | 39042 | Jeff Bingaman B000468 | sen | NM | 1989-01-03 | 1995-01-03 | 1 | Democrat | |||||||||||||
39036 | 39036 | Daniel Akaka A000069 | rep | HI | 1989-01-03 | 1990-05-15 | Democrat | 2 | |||||||||||||
38973 | 38973 | Donald Payne P000149 | rep | NJ | 1989-01-03 | 1991-01-03 | Democrat | 10 | |||||||||||||
38888 | 38888 | Gene Taylor T000074 | rep | MS | 1989-01-03 | 1991-01-03 | Democrat | 5 | |||||||||||||
38870 | 38870 | John Tanner T000038 | rep | TN | 1989-01-03 | 1991-01-03 | Democrat | 8 | |||||||||||||
38850 | 38850 | John Spratt S000749 | rep | SC | 1989-01-03 | 1991-01-03 | Democrat | 5 | |||||||||||||
38814 | 38814 | Ike Skelton S000465 | rep | MO | 1989-01-03 | 1991-01-03 | Democrat | 4 | |||||||||||||
38754 | 38754 | Solomon Ortiz O000107 | rep | TX | 1989-01-03 | 1991-01-03 | Democrat | 27 | |||||||||||||
38740 | 38740 | David Obey O000007 | rep | WI | 1989-01-03 | 1991-01-03 | Democrat | 7 | |||||||||||||
38719 | 38719 | James Oberstar O000006 | rep | MN | 1989-01-03 | 1991-01-03 | Democrat | 8 | |||||||||||||
38700 | 38700 | John Murtha M001120 | rep | PA | 1989-01-03 | 1991-01-03 | Democrat | 12 | |||||||||||||
38673 | 38673 | Alan Mollohan M000844 | rep | WV | 1989-01-03 | 1991-01-03 | Democrat | 1 | |||||||||||||
38604 | 38604 | Paul Kanjorski K000008 | rep | PA | 1989-01-03 | 1991-01-03 | Democrat | 11 | |||||||||||||
38557 | 38557 | Barton Gordon G000309 | rep | TN | 1989-01-03 | 1991-01-03 | Democrat | 6 | |||||||||||||
38439 | 38439 | Frederick Boucher B000657 | rep | VA | 1989-01-03 | 1991-01-03 | Democrat | 9 | |||||||||||||
38355 | 38355 | James Walsh W000099 | rep | NY | 1989-01-03 | 1991-01-03 | Republican | 27 | |||||||||||||
38349 | 38349 | Craig Thomas T000162 | rep | WY | 1989-01-03 | 1991-01-03 | Republican | 0 | |||||||||||||
38334 | 38334 | Christopher Shays S001144 | rep | CT | 1989-01-03 | 1991-01-03 | Republican | 4 | |||||||||||||
38323 | 38323 | H. Saxton S000097 | rep | NJ | 1989-01-03 | 1991-01-03 | Republican | 13 | |||||||||||||
38301 | 38301 | Ralph Regula R000141 | rep | OH | 1989-01-03 | 1991-01-03 | Republican | 16 | |||||||||||||
38226 | 38226 | Michael McNulty M000590 | rep | NY | 1989-01-03 | 1991-01-03 | Democrat | 23 | |||||||||||||
38216 | 38216 | James McCrery M000388 | rep | LA | 1989-01-03 | 1991-01-03 | Republican | 4 | |||||||||||||
38210 | 38210 | Trent Lott L000447 | sen | MS | 1989-01-03 | 1995-01-03 | 1 | Republican | |||||||||||||
38184 | 38184 | Tom Lantos L000090 | rep | CA | 1989-01-03 | 1991-01-03 | Democrat | 11 | |||||||||||||
38154 | 38154 | Edward Kennedy K000105 | sen | MA | 1989-01-03 | 1995-01-03 | 1 | Democrat | |||||||||||||
38119 | 38119 | Duncan Hunter H000981 | rep | CA | 1989-01-03 | 1991-01-03 | Republican | 45 | |||||||||||||
38079 | 38079 | J. Hastert H000323 | rep | IL | 1989-01-03 | 1991-01-03 | Republican | 14 | |||||||||||||
38062 | 38062 | Paul Gillmor G000210 | rep | OH | 1989-01-03 | 1991-01-03 | Republican | 5 |
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);