legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
475 rows where "start" is on date 1997-01-07
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
36135 | 36135 | Henry Baesler B000028 | rep | KY | 1997-01-07 | 1999-01-03 | Democrat | 6 | |||||||||||||
36137 | 36137 | Sonny Bono B000622 | rep | CA | 1997-01-07 | 1998-01-05 | Republican | 44 | |||||||||||||
36138 | 36138 | Walter Capps C000134 | rep | CA | 1997-01-07 | 1997-10-28 | Democrat | 22 | |||||||||||||
36140 | 36140 | Jon Christensen C000377 | rep | NE | 1997-01-07 | 1999-01-03 | Republican | 2 | |||||||||||||
36141 | 36141 | J. Cleland C001034 | sen | GA | 1997-01-07 | 2003-01-03 | 2 | Democrat | |||||||||||||
36155 | 36155 | Ronald Dellums D000222 | rep | CA | 1997-01-07 | 1998-02-07 | Democrat | 9 | |||||||||||||
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 | |||||||||||||
36178 | 36178 | Floyd Flake F000184 | rep | NY | 1997-01-07 | 1997-11-17 | Democrat | 6 | |||||||||||||
36187 | 36187 | Thomas Foglietta F000235 | rep | PA | 1997-01-07 | 1997-11-11 | Democrat | 1 | |||||||||||||
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 | |||||||||||||
36227 | 36227 | Phil Gramm G000365 | sen | TX | 1997-01-07 | 2002-11-29 | 2 | Republican | |||||||||||||
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 | |||||||||||||
36261 | 36261 | Jesse Helms H000463 | sen | NC | 1997-01-07 | 2003-01-03 | 2 | Republican | |||||||||||||
36264 | 36264 | Tim Hutchinson H001015 | sen | AR | 1997-01-07 | 2003-01-03 | 2 | Republican | |||||||||||||
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 | |||||||||||||
36320 | 36320 | Susan Molinari M000843 | rep | NY | 1997-01-07 | 1997-08-02 | Republican | 13 | |||||||||||||
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 | |||||||||||||
36347 | 36347 | William Richardson R000229 | rep | NM | 1997-01-07 | 1997-02-13 | Democrat | 3 | |||||||||||||
36350 | 36350 | Frank Riggs R000252 | rep | CA | 1997-01-07 | 1999-01-03 | Republican | 1 | |||||||||||||
36352 | 36352 | Carlos Romero-Barceló R000417 | rep | PR | 1997-01-07 | 2001-01-03 | Democrat | 0 | |||||||||||||
36360 | 36360 | Daniel Schaefer S000109 | rep | CO | 1997-01-07 | 1999-01-03 | Republican | 6 | |||||||||||||
36365 | 36365 | Steven Schiff S000125 | rep | NM | 1997-01-07 | 1998-03-25 | Republican | 1 | |||||||||||||
36371 | 36371 | David Skaggs S000462 | rep | CO | 1997-01-07 | 1999-01-03 | Democrat | 2 | |||||||||||||
36377 | 36377 | Robert Smith S000606 | sen | NH | 1997-01-07 | 2003-01-03 | 2 | Republican | |||||||||||||
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 | |||||||||||||
36415 | 36415 | Frank Tejeda T000113 | rep | TX | 1997-01-07 | 1997-01-30 | Democrat | 28 | |||||||||||||
36417 | 36417 | Fred Thompson T000457 | sen | TN | 1997-01-07 | 2003-01-03 | 2 | Republican | |||||||||||||
36427 | 36427 | J. Thurmond T000254 | sen | SC | 1997-01-07 | 2003-01-03 | 2 | Republican | |||||||||||||
36435 | 36435 | Esteban Torres T000316 | rep | CA | 1997-01-07 | 1999-01-03 | Democrat | 34 | |||||||||||||
36443 | 36443 | Robert Torricelli T000317 | sen | NJ | 1997-01-07 | 2003-01-03 | 2 | Democrat | |||||||||||||
36445 | 36445 | Paul Wellstone W000288 | sen | MN | 1997-01-07 | 2002-10-25 | 2 | Democrat | |||||||||||||
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 | |||||||||||||
36538 | 36538 | George Brown B000918 | rep | CA | 1997-01-07 | 1999-01-03 | Democrat | 42 | |||||||||||||
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 | |||||||||||||
36579 | 36579 | Pat Danner D000046 | rep | MO | 1997-01-07 | 1999-01-03 | Democrat | 6 | |||||||||||||
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 | |||||||||||||
36647 | 36647 | Rick Hill H000605 | rep | MT | 1997-01-07 | 1999-01-03 | Republican | 0 | |||||||||||||
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 | |||||||||||||
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 |
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);