legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
473 rows where "end" is on date 1999-01-03 sorted by office
This data as json, copyable, CSV (advanced)
Suggested facets: start, district
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
35159 | 35159 | Dale Bumpers B001057 | sen | AR | 1993-01-05 | 1999-01-03 | 3 | Democrat | |||||||||||||
35173 | 35173 | Alfonse D’Amato D000018 | sen | NY | 1993-01-05 | 1999-01-03 | 3 | Republican | |||||||||||||
35230 | 35230 | Duncan Faircloth F000437 | sen | NC | 1993-01-05 | 1999-01-03 | 3 | Republican | |||||||||||||
35264 | 35264 | Wendell Ford F000268 | sen | KY | 1993-01-05 | 1999-01-03 | 3 | Democrat | |||||||||||||
35289 | 35289 | John Glenn G000236 | sen | OH | 1993-01-05 | 1999-01-03 | 3 | Democrat | |||||||||||||
35346 | 35346 | Dirk Kempthorne K000088 | sen | ID | 1993-01-05 | 1999-01-03 | 3 | Republican | |||||||||||||
35447 | 35447 | Carol Moseley Braun M001025 | sen | IL | 1993-01-05 | 1999-01-03 | 3 | Democrat | |||||||||||||
36135 | 36135 | Henry Baesler B000028 | rep | KY | 1997-01-07 | 1999-01-03 | Democrat | 6 | |||||||||||||
36140 | 36140 | Jon Christensen C000377 | rep | NE | 1997-01-07 | 1999-01-03 | Republican | 2 | |||||||||||||
36162 | 36162 | Harris Fawell F000049 | rep | IL | 1997-01-07 | 1999-01-03 | Republican | 13 | |||||||||||||
36172 | 36172 | Victor Fazio F000053 | rep | CA | 1997-01-07 | 1999-01-03 | Democrat | 3 | |||||||||||||
36189 | 36189 | Jon Fox F000332 | rep | PA | 1997-01-07 | 1999-01-03 | Republican | 13 | |||||||||||||
36192 | 36192 | Elizabeth Furse F000434 | rep | OR | 1997-01-07 | 1999-01-03 | Democrat | 1 | |||||||||||||
36202 | 36202 | Newton Gingrich G000225 | rep | GA | 1997-01-07 | 1999-01-03 | Republican | 6 | |||||||||||||
36221 | 36221 | Henry González G000272 | rep | TX | 1997-01-07 | 1999-01-03 | Democrat | 20 | |||||||||||||
36244 | 36244 | Lee Hamilton H000114 | rep | IN | 1997-01-07 | 1999-01-03 | Democrat | 9 | |||||||||||||
36256 | 36256 | Willie Hefner H000448 | rep | NC | 1997-01-07 | 1999-01-03 | Democrat | 8 | |||||||||||||
36265 | 36265 | Jay Johnson J000149 | rep | WI | 1997-01-07 | 1999-01-03 | Democrat | 8 | |||||||||||||
36271 | 36271 | Joseph Kennedy K000110 | rep | MA | 1997-01-07 | 1999-01-03 | Democrat | 8 | |||||||||||||
36280 | 36280 | Barbara Kennelly K000118 | rep | CT | 1997-01-07 | 1999-01-03 | Democrat | 1 | |||||||||||||
36283 | 36283 | Jay Kim K000181 | rep | CA | 1997-01-07 | 1999-01-03 | Republican | 41 | |||||||||||||
36287 | 36287 | Scott Klug K000274 | rep | WI | 1997-01-07 | 1999-01-03 | Republican | 2 | |||||||||||||
36294 | 36294 | Thomas Manton M000117 | rep | NY | 1997-01-07 | 1999-01-03 | Democrat | 7 | |||||||||||||
36312 | 36312 | Joseph McDade M000399 | rep | PA | 1997-01-07 | 1999-01-03 | Republican | 10 | |||||||||||||
36315 | 36315 | Paul McHale M000466 | rep | PA | 1997-01-07 | 1999-01-03 | Democrat | 15 | |||||||||||||
36322 | 36322 | Mark Neumann N000054 | rep | WI | 1997-01-07 | 1999-01-03 | Republican | 1 | |||||||||||||
36323 | 36323 | Michael Pappas P000049 | rep | NJ | 1997-01-07 | 1999-01-03 | Republican | 12 | |||||||||||||
36328 | 36328 | Michael Parker P000066 | rep | MS | 1997-01-07 | 1999-01-03 | Republican | 4 | |||||||||||||
36333 | 36333 | L. Paxon P000148 | rep | NY | 1997-01-07 | 1999-01-03 | Republican | 27 | |||||||||||||
36338 | 36338 | Glenn Poshard P000452 | rep | IL | 1997-01-07 | 1999-01-03 | Democrat | 19 | |||||||||||||
36339 | 36339 | William Redmond R000567 | rep | NM | 1997-05-13 | 1999-01-03 | Republican | 3 | |||||||||||||
36350 | 36350 | Frank Riggs R000252 | rep | CA | 1997-01-07 | 1999-01-03 | Republican | 1 | |||||||||||||
36360 | 36360 | Daniel Schaefer S000109 | rep | CO | 1997-01-07 | 1999-01-03 | Republican | 6 | |||||||||||||
36371 | 36371 | David Skaggs S000462 | rep | CO | 1997-01-07 | 1999-01-03 | Democrat | 2 | |||||||||||||
36379 | 36379 | Linda Smith S000587 | rep | WA | 1997-01-07 | 1999-01-03 | Republican | 3 | |||||||||||||
36386 | 36386 | Robert Smith S000607 | rep | OR | 1997-01-07 | 1999-01-03 | Republican | 2 | |||||||||||||
36387 | 36387 | Vincent Snowbarger S000662 | rep | KS | 1997-01-07 | 1999-01-03 | Republican | 3 | |||||||||||||
36397 | 36397 | Gerald Solomon S000675 | rep | NY | 1997-01-07 | 1999-01-03 | Republican | 22 | |||||||||||||
36412 | 36412 | Louis Stokes S000948 | rep | OH | 1997-01-07 | 1999-01-03 | Democrat | 11 | |||||||||||||
36435 | 36435 | Esteban Torres T000316 | rep | CA | 1997-01-07 | 1999-01-03 | Democrat | 34 | |||||||||||||
36447 | 36447 | Richard White W000391 | rep | WA | 1997-01-07 | 1999-01-03 | Republican | 1 | |||||||||||||
36471 | 36471 | Sidney Yates Y000013 | rep | IL | 1997-01-07 | 1999-01-03 | Democrat | 9 | |||||||||||||
36485 | 36485 | Bill Archer A000215 | rep | TX | 1997-01-07 | 1999-01-03 | Republican | 7 | |||||||||||||
36490 | 36490 | Bill Barrett B000179 | rep | NE | 1997-01-07 | 1999-01-03 | Republican | 3 | |||||||||||||
36499 | 36499 | Herbert Bateman B000229 | rep | VA | 1997-01-07 | 1999-01-03 | Republican | 1 | |||||||||||||
36509 | 36509 | Tom Bliley B000556 | rep | VA | 1997-01-07 | 1999-01-03 | Republican | 7 | |||||||||||||
36520 | 36520 | John Breaux B000780 | sen | LA | 1993-01-05 | 1999-01-03 | 3 | Democrat | |||||||||||||
36538 | 36538 | George Brown B000918 | rep | CA | 1997-01-07 | 1999-01-03 | Democrat | 42 | |||||||||||||
36543 | 36543 | Ben Campbell C000077 | sen | CO | 1993-01-05 | 1999-01-03 | 3 | Republican | [ { "start": "1993-01-05", "end": "1995-03-03", "party": "Democrat" }, { "start": "1995-03-03", "end": "1999-01-03", "party": "Republican" } ] |
||||||||||||
36548 | 36548 | Tom Campbell C000100 | rep | CA | 1997-01-07 | 1999-01-03 | Republican | 15 | |||||||||||||
36552 | 36552 | Charles Canady C000107 | rep | FL | 1997-01-07 | 1999-01-03 | Republican | 12 | |||||||||||||
36555 | 36555 | Helen Chenoweth-Hage C000345 | rep | ID | 1997-01-07 | 1999-01-03 | Republican | 1 | |||||||||||||
36571 | 36571 | William Clay C000488 | rep | MO | 1997-01-07 | 1999-01-03 | Democrat | 1 | |||||||||||||
36573 | 36573 | Merrill Cook C000722 | rep | UT | 1997-01-07 | 1999-01-03 | Republican | 2 | |||||||||||||
36575 | 36575 | Paul Coverdell C000813 | sen | GA | 1993-01-05 | 1999-01-03 | 3 | Republican | |||||||||||||
36579 | 36579 | Pat Danner D000046 | rep | MO | 1997-01-07 | 1999-01-03 | Democrat | 6 | |||||||||||||
36586 | 36586 | Thomas Daschle D000064 | sen | SD | 1993-01-05 | 1999-01-03 | 3 | Democrat | |||||||||||||
36590 | 36590 | Jay Dickey D000312 | rep | AR | 1997-01-07 | 1999-01-03 | Republican | 4 | |||||||||||||
36601 | 36601 | Julian Dixon D000373 | rep | CA | 1997-01-07 | 1999-01-03 | Democrat | 32 | |||||||||||||
36607 | 36607 | Thomas Ewing E000282 | rep | IL | 1997-01-07 | 1999-01-03 | Republican | 15 | |||||||||||||
36611 | 36611 | Michael Forbes F000257 | rep | NY | 1997-01-07 | 1999-01-03 | Republican | 1 | |||||||||||||
36615 | 36615 | Tillie Fowler F000328 | rep | FL | 1997-01-07 | 1999-01-03 | Republican | 4 | |||||||||||||
36619 | 36619 | Bob Franks F000349 | rep | NJ | 1997-01-07 | 1999-01-03 | Republican | 7 | |||||||||||||
36629 | 36629 | Sam Gejdenson G000120 | rep | CT | 1997-01-07 | 1999-01-03 | Democrat | 2 | |||||||||||||
36642 | 36642 | William Goodling G000291 | rep | PA | 1997-01-07 | 1999-01-03 | Republican | 19 | |||||||||||||
36645 | 36645 | Bob Graham G000352 | sen | FL | 1993-01-05 | 1999-01-03 | 3 | Democrat | |||||||||||||
36647 | 36647 | Rick Hill H000605 | rep | MT | 1997-01-07 | 1999-01-03 | Republican | 0 | |||||||||||||
36654 | 36654 | Ernest Hollings H000725 | sen | SC | 1993-01-05 | 1999-01-03 | 3 | Democrat | |||||||||||||
36663 | 36663 | John Kasich K000016 | rep | OH | 1997-01-07 | 1999-01-03 | Republican | 12 | |||||||||||||
36667 | 36667 | Ron Klink K000270 | rep | PA | 1997-01-07 | 1999-01-03 | Democrat | 4 | |||||||||||||
36672 | 36672 | Rick Lazio L000155 | rep | NY | 1997-01-07 | 1999-01-03 | Republican | 2 | |||||||||||||
36684 | 36684 | Robert Livingston L000371 | rep | LA | 1997-01-07 | 1999-01-03 | Republican | 1 | |||||||||||||
36694 | 36694 | Matthew Martínez M000206 | rep | CA | 1997-01-07 | 1999-01-03 | Democrat | 31 | |||||||||||||
36704 | 36704 | Bill McCollum M000350 | rep | FL | 1997-01-07 | 1999-01-03 | Republican | 8 | |||||||||||||
36707 | 36707 | David McIntosh M000481 | rep | IN | 1997-01-07 | 1999-01-03 | Republican | 2 | |||||||||||||
36710 | 36710 | Jack Metcalf M000669 | rep | WA | 1997-01-07 | 1999-01-03 | Republican | 2 | |||||||||||||
36714 | 36714 | David Minge M000795 | rep | MN | 1997-01-07 | 1999-01-03 | Democrat | 2 | |||||||||||||
36718 | 36718 | Frank Murkowski M001085 | sen | AK | 1993-01-05 | 1999-01-03 | 3 | Republican | |||||||||||||
36722 | 36722 | Don Nickles N000102 | sen | OK | 1993-01-05 | 1999-01-03 | 3 | Republican | |||||||||||||
36731 | 36731 | Ron Packard P000005 | rep | CA | 1997-01-07 | 1999-01-03 | Republican | 48 | |||||||||||||
36733 | 36733 | Edward Pease P000171 | rep | IN | 1997-01-07 | 1999-01-03 | Republican | 7 | |||||||||||||
36740 | 36740 | Owen Pickett P000326 | rep | VA | 1997-01-07 | 1999-01-03 | Democrat | 2 | |||||||||||||
36751 | 36751 | John Porter P000444 | rep | IL | 1997-01-07 | 1999-01-03 | Republican | 10 | |||||||||||||
36753 | 36753 | James Rogan R000386 | rep | CA | 1997-01-07 | 1999-01-03 | Republican | 27 | |||||||||||||
36765 | 36765 | Bruce Vento V000087 | rep | MN | 1997-01-07 | 1999-01-03 | Democrat | 4 | |||||||||||||
36767 | 36767 | Robert Weygand W000315 | rep | RI | 1997-01-07 | 1999-01-03 | Democrat | 2 | |||||||||||||
36776 | 36776 | Robert Wise W000654 | rep | WV | 1997-01-07 | 1999-01-03 | Democrat | 2 | |||||||||||||
36787 | 36787 | Richard Armey A000217 | rep | TX | 1997-01-07 | 1999-01-03 | Republican | 26 | |||||||||||||
36791 | 36791 | John Baldacci B000081 | rep | ME | 1997-01-07 | 1999-01-03 | Democrat | 2 | |||||||||||||
36796 | 36796 | James Barcia B000134 | rep | MI | 1997-01-07 | 1999-01-03 | Democrat | 5 | |||||||||||||
36800 | 36800 | Bob Barr B000169 | rep | GA | 1997-01-07 | 1999-01-03 | Republican | 7 | |||||||||||||
36805 | 36805 | Thomas Barrett B000177 | rep | WI | 1997-01-07 | 1999-01-03 | Democrat | 5 | |||||||||||||
36809 | 36809 | Ken Bentsen B000400 | rep | TX | 1997-01-07 | 1999-01-03 | Democrat | 25 | |||||||||||||
36812 | 36812 | Rod Blagojevich B000518 | rep | IL | 1997-01-07 | 1999-01-03 | Democrat | 5 | |||||||||||||
36825 | 36825 | David Bonior B000619 | rep | MI | 1997-01-07 | 1999-01-03 | Democrat | 10 | |||||||||||||
36835 | 36835 | Robert Borski B000644 | rep | PA | 1997-01-07 | 1999-01-03 | Democrat | 3 | |||||||||||||
36839 | 36839 | Ed Bryant B000996 | rep | TN | 1997-01-07 | 1999-01-03 | Republican | 7 | |||||||||||||
36851 | 36851 | H. Callahan C000052 | rep | AL | 1997-01-07 | 1999-01-03 | Republican | 1 | |||||||||||||
36860 | 36860 | Eva Clayton C000494 | rep | NC | 1997-01-07 | 1999-01-03 | Democrat | 1 | |||||||||||||
36868 | 36868 | Robert Clement C000503 | rep | TN | 1997-01-07 | 1999-01-03 | Democrat | 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);