legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
472 rows where "end" is on date 1997-01-03 sorted by state
This data as json, copyable, CSV (advanced)
Suggested facets: state, party
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
37484 | 37484 | Ted Stevens S000888 | sen | AK | 1991-01-03 | 1997-01-03 | 2 | Republican | |||||||||||||
41675 | 41675 | Don Young Y000033 | rep | AK | 1995-01-04 | 1997-01-03 | Republican | 0 | |||||||||||||
34545 | 34545 | Howell Heflin H000445 | sen | AL | 1991-01-03 | 1997-01-03 | 2 | Democrat | |||||||||||||
35707 | 35707 | Tom Bevill B000431 | rep | AL | 1995-01-04 | 1997-01-03 | Democrat | 4 | |||||||||||||
35716 | 35716 | John Browder B000897 | rep | AL | 1995-01-04 | 1997-01-03 | Democrat | 3 | |||||||||||||
36850 | 36850 | H. Callahan C000052 | rep | AL | 1995-01-04 | 1997-01-03 | Republican | 1 | |||||||||||||
36964 | 36964 | Earl Hilliard H000621 | rep | AL | 1995-01-04 | 1997-01-03 | Democrat | 7 | |||||||||||||
37979 | 37979 | Robert Cramer C000868 | rep | AL | 1995-01-04 | 1997-01-03 | Democrat | 5 | |||||||||||||
38031 | 38031 | Terry Everett E000268 | rep | AL | 1995-01-04 | 1997-01-03 | Republican | 2 | |||||||||||||
39739 | 39739 | Spencer Bachus B000013 | rep | AL | 1995-01-04 | 1997-01-03 | Republican | 6 | |||||||||||||
34852 | 34852 | David Pryor P000556 | sen | AR | 1991-01-03 | 1997-01-03 | 2 | Democrat | |||||||||||||
36055 | 36055 | Raymond Thornton T000243 | rep | AR | 1995-01-04 | 1997-01-03 | Democrat | 2 | |||||||||||||
36263 | 36263 | Tim Hutchinson H001015 | rep | AR | 1995-01-04 | 1997-01-03 | Republican | 3 | |||||||||||||
36589 | 36589 | Jay Dickey D000312 | rep | AR | 1995-01-04 | 1997-01-03 | Republican | 4 | |||||||||||||
37773 | 37773 | Blanche Lincoln L000035 | rep | AR | 1995-01-04 | 1997-01-03 | Democrat | 1 | |||||||||||||
39832 | 39832 | Eni Faleomavaega F000010 | rep | AS | 1995-01-04 | 1997-01-03 | Democrat | 0 | |||||||||||||
37179 | 37179 | Robert Stump S001044 | rep | AZ | 1995-01-04 | 1997-01-03 | Republican | 3 | |||||||||||||
37675 | 37675 | John Hayworth H000413 | rep | AZ | 1995-01-04 | 1997-01-03 | Republican | 6 | |||||||||||||
37751 | 37751 | James Kolbe K000306 | rep | AZ | 1995-01-04 | 1997-01-03 | Republican | 5 | |||||||||||||
38800 | 38800 | John Shadegg S000275 | rep | AZ | 1995-01-04 | 1997-01-03 | Republican | 4 | |||||||||||||
39999 | 39999 | Ed Pastor P000099 | rep | AZ | 1995-01-04 | 1997-01-03 | Democrat | 2 | |||||||||||||
40487 | 40487 | Matt Salmon S000018 | rep | AZ | 1995-01-04 | 1997-01-03 | Republican | 1 | |||||||||||||
35682 | 35682 | William Baker B000078 | rep | CA | 1995-01-04 | 1997-01-03 | Republican | 10 | |||||||||||||
35692 | 35692 | Anthony Beilenson B000318 | rep | CA | 1995-01-04 | 1997-01-03 | Democrat | 24 | |||||||||||||
35780 | 35780 | Robert Dornan D000435 | rep | CA | 1995-01-04 | 1997-01-03 | Republican | 46 | |||||||||||||
35944 | 35944 | Carlos Moorhead M000926 | rep | CA | 1995-01-04 | 1997-01-03 | Republican | 27 | |||||||||||||
36036 | 36036 | Andrea Seastrand S000213 | rep | CA | 1995-01-04 | 1997-01-03 | Republican | 22 | |||||||||||||
36136 | 36136 | Sonny Bono B000622 | rep | CA | 1995-01-04 | 1997-01-03 | Republican | 44 | |||||||||||||
36154 | 36154 | Ronald Dellums D000222 | rep | CA | 1995-01-04 | 1997-01-03 | Democrat | 9 | |||||||||||||
36171 | 36171 | Victor Fazio F000053 | rep | CA | 1995-01-04 | 1997-01-03 | Democrat | 3 | |||||||||||||
36282 | 36282 | Jay Kim K000181 | rep | CA | 1995-01-04 | 1997-01-03 | Republican | 41 | |||||||||||||
36349 | 36349 | Frank Riggs R000252 | rep | CA | 1995-01-04 | 1997-01-03 | Republican | 1 | |||||||||||||
36434 | 36434 | Esteban Torres T000316 | rep | CA | 1995-01-04 | 1997-01-03 | Democrat | 34 | |||||||||||||
36537 | 36537 | George Brown B000918 | rep | CA | 1995-01-04 | 1997-01-03 | Democrat | 42 | |||||||||||||
36547 | 36547 | Tom Campbell C000100 | rep | CA | 1995-12-12 | 1997-01-03 | Republican | 15 | |||||||||||||
36600 | 36600 | Julian Dixon D000373 | rep | CA | 1995-01-04 | 1997-01-03 | Democrat | 32 | |||||||||||||
36693 | 36693 | Matthew Martínez M000206 | rep | CA | 1995-01-04 | 1997-01-03 | Democrat | 31 | |||||||||||||
36730 | 36730 | Ron Packard P000005 | rep | CA | 1995-01-04 | 1997-01-03 | Republican | 48 | |||||||||||||
36874 | 36874 | Gary Condit C000670 | rep | CA | 1995-01-04 | 1997-01-03 | Democrat | 18 | |||||||||||||
36969 | 36969 | Stephen Horn H000789 | rep | CA | 1995-01-04 | 1997-01-03 | Republican | 38 | |||||||||||||
37315 | 37315 | Calvin Dooley D000424 | rep | CA | 1995-01-04 | 1997-01-03 | Democrat | 20 | |||||||||||||
37423 | 37423 | Robert Matsui M000249 | rep | CA | 1995-01-04 | 1997-01-03 | Democrat | 5 | |||||||||||||
37574 | 37574 | C. Cox C000830 | rep | CA | 1995-01-04 | 1997-01-03 | Republican | 47 | |||||||||||||
37582 | 37582 | Randall Cunningham C000994 | rep | CA | 1995-01-04 | 1997-01-03 | Republican | 51 | |||||||||||||
37834 | 37834 | Richard Pombo P000419 | rep | CA | 1995-01-04 | 1997-01-03 | Republican | 11 | |||||||||||||
37914 | 37914 | William Thomas T000188 | rep | CA | 1995-01-04 | 1997-01-03 | Republican | 21 | |||||||||||||
38007 | 38007 | John Doolittle D000429 | rep | CA | 1995-01-04 | 1997-01-03 | Republican | 4 | |||||||||||||
38122 | 38122 | Duncan Hunter H000981 | rep | CA | 1995-01-04 | 1997-01-03 | Republican | 52 | |||||||||||||
38187 | 38187 | Tom Lantos L000090 | rep | CA | 1995-01-04 | 1997-01-03 | Democrat | 12 | |||||||||||||
38244 | 38244 | Juanita Millender-McDonald M000714 | rep | CA | 1996-03-26 | 1997-01-03 | Democrat | 37 | |||||||||||||
38780 | 38780 | George Radanovich R000004 | rep | CA | 1995-01-04 | 1997-01-03 | Republican | 19 | |||||||||||||
38950 | 38950 | Jane Harman H000213 | rep | CA | 1995-01-04 | 1997-01-03 | Democrat | 36 | |||||||||||||
39009 | 39009 | Bob Filner F000116 | rep | CA | 1995-01-04 | 1997-01-03 | Democrat | 50 | |||||||||||||
39149 | 39149 | Howard Berman B000410 | rep | CA | 1995-01-04 | 1997-01-03 | Democrat | 26 | |||||||||||||
39165 | 39165 | Brian Bilbray B000461 | rep | CA | 1995-01-04 | 1997-01-03 | Republican | 49 | |||||||||||||
39260 | 39260 | David Dreier D000492 | rep | CA | 1995-01-04 | 1997-01-03 | Republican | 28 | |||||||||||||
39289 | 39289 | Elton Gallegly G000021 | rep | CA | 1995-01-04 | 1997-01-03 | Republican | 23 | |||||||||||||
39310 | 39310 | Walter Herger H000528 | rep | CA | 1995-01-04 | 1997-01-03 | Republican | 2 | |||||||||||||
39391 | 39391 | Jerry Lewis L000274 | rep | CA | 1995-01-04 | 1997-01-03 | Republican | 40 | |||||||||||||
39524 | 39524 | Fortney Stark S000810 | rep | CA | 1995-01-04 | 1997-01-03 | Democrat | 13 | |||||||||||||
39572 | 39572 | Lynn Woolsey W000738 | rep | CA | 1995-01-04 | 1997-01-03 | Democrat | 6 | |||||||||||||
39938 | 39938 | Howard McKeon M000508 | rep | CA | 1995-01-04 | 1997-01-03 | Republican | 25 | |||||||||||||
39972 | 39972 | George Miller M000725 | rep | CA | 1995-01-04 | 1997-01-03 | Democrat | 7 | |||||||||||||
40089 | 40089 | Henry Waxman W000215 | rep | CA | 1995-01-04 | 1997-01-03 | Democrat | 29 | |||||||||||||
40297 | 40297 | Sam Farr F000030 | rep | CA | 1995-01-04 | 1997-01-03 | Democrat | 17 | |||||||||||||
40513 | 40513 | Xavier Becerra B000287 | rep | CA | 1995-01-04 | 1997-01-03 | Democrat | 30 | |||||||||||||
40977 | 40977 | Dana Rohrabacher R000409 | rep | CA | 1995-01-04 | 1997-01-03 | Republican | 45 | |||||||||||||
41024 | 41024 | Edward Royce R000487 | rep | CA | 1995-01-04 | 1997-01-03 | Republican | 39 | |||||||||||||
42061 | 42061 | Ken Calvert C000059 | rep | CA | 1995-01-04 | 1997-01-03 | Republican | 43 | |||||||||||||
42364 | 42364 | Anna Eshoo E000215 | rep | CA | 1995-01-04 | 1997-01-03 | Democrat | 14 | |||||||||||||
42740 | 42740 | Zoe Lofgren L000397 | rep | CA | 1995-01-04 | 1997-01-03 | Democrat | 16 | |||||||||||||
43076 | 43076 | Nancy Pelosi P000197 | rep | CA | 1995-01-04 | 1997-01-03 | Democrat | 8 | |||||||||||||
43182 | 43182 | Lucille Roybal-Allard R000486 | rep | CA | 1995-01-04 | 1997-01-03 | Democrat | 33 | |||||||||||||
43571 | 43571 | Maxine Waters W000187 | rep | CA | 1995-01-04 | 1997-01-03 | Democrat | 35 | |||||||||||||
34288 | 34288 | George Brown B000919 | sen | CO | 1991-01-03 | 1997-01-03 | 2 | Republican | |||||||||||||
36035 | 36035 | Patricia Schroeder S000142 | rep | CO | 1995-01-04 | 1997-01-03 | Democrat | 1 | |||||||||||||
36359 | 36359 | Daniel Schaefer S000109 | rep | CO | 1995-01-04 | 1997-01-03 | Republican | 6 | |||||||||||||
36370 | 36370 | David Skaggs S000462 | rep | CO | 1995-01-04 | 1997-01-03 | Democrat | 2 | |||||||||||||
37226 | 37226 | Wayne Allard A000109 | rep | CO | 1995-01-04 | 1997-01-03 | Republican | 4 | |||||||||||||
37434 | 37434 | Scott McInnis M000477 | rep | CO | 1995-01-04 | 1997-01-03 | Republican | 3 | |||||||||||||
37685 | 37685 | Joel Hefley H000444 | rep | CO | 1995-01-04 | 1997-01-03 | Republican | 5 | |||||||||||||
35813 | 35813 | Gary Franks F000348 | rep | CT | 1995-01-04 | 1997-01-03 | Republican | 5 | |||||||||||||
36279 | 36279 | Barbara Kennelly K000118 | rep | CT | 1995-01-04 | 1997-01-03 | Democrat | 1 | |||||||||||||
36628 | 36628 | Sam Gejdenson G000120 | rep | CT | 1995-01-04 | 1997-01-03 | Democrat | 2 | |||||||||||||
37731 | 37731 | Nancy Johnson J000163 | rep | CT | 1995-01-04 | 1997-01-03 | Republican | 6 | |||||||||||||
38337 | 38337 | Christopher Shays S001144 | rep | CT | 1995-01-04 | 1997-01-03 | Republican | 4 | |||||||||||||
42299 | 42299 | Rosa DeLauro D000216 | rep | CT | 1995-01-04 | 1997-01-03 | Democrat | 3 | |||||||||||||
43019 | 43019 | Eleanor Norton N000147 | rep | DC | 1995-01-04 | 1997-01-03 | Democrat | 0 | |||||||||||||
38431 | 38431 | Joseph Biden B000444 | sen | DE | 1991-01-03 | 1997-01-03 | 2 | Democrat | |||||||||||||
38480 | 38480 | Michael Castle C000243 | rep | DE | 1995-01-04 | 1997-01-03 | Republican | 0 | |||||||||||||
35837 | 35837 | Sam Gibbons G000153 | rep | FL | 1995-01-04 | 1997-01-03 | Democrat | 11 | |||||||||||||
35881 | 35881 | Harry Johnston J000187 | rep | FL | 1995-01-04 | 1997-01-03 | Democrat | 19 | |||||||||||||
35974 | 35974 | Douglas Peterson P000259 | rep | FL | 1995-01-04 | 1997-01-03 | Democrat | 2 | |||||||||||||
36551 | 36551 | Charles Canady C000107 | rep | FL | 1995-01-04 | 1997-01-03 | Republican | 12 | |||||||||||||
36614 | 36614 | Tillie Fowler F000328 | rep | FL | 1995-01-04 | 1997-01-03 | Republican | 4 | |||||||||||||
36703 | 36703 | Bill McCollum M000350 | rep | FL | 1995-01-04 | 1997-01-03 | Republican | 8 | |||||||||||||
37018 | 37018 | Carrie Meek M000628 | rep | FL | 1995-01-04 | 1997-01-03 | Democrat | 17 | |||||||||||||
37023 | 37023 | Dan Miller M000720 | rep | FL | 1995-01-04 | 1997-01-03 | Republican | 13 | |||||||||||||
37109 | 37109 | Joe Scarborough S000106 | rep | FL | 1995-01-04 | 1997-01-03 | Republican | 1 | |||||||||||||
37184 | 37184 | Karen Thurman T000253 | rep | FL | 1995-01-04 | 1997-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);