legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
432 rows where "end" is on date 1997-01-03 and "start" is on date 1995-01-04
This data as json, copyable, CSV (advanced)
Suggested facets: start (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||
35707 | 35707 | Tom Bevill B000431 | rep | AL | 1995-01-04 | 1997-01-03 | Democrat | 4 | |||||||||||||
35709 | 35709 | Peter Blute B000576 | rep | MA | 1995-01-04 | 1997-01-03 | Republican | 3 | |||||||||||||
35712 | 35712 | William Brewster B000817 | rep | OK | 1995-01-04 | 1997-01-03 | Democrat | 3 | |||||||||||||
35716 | 35716 | John Browder B000897 | rep | AL | 1995-01-04 | 1997-01-03 | Democrat | 3 | |||||||||||||
35725 | 35725 | John Bryant B000997 | rep | TX | 1995-01-04 | 1997-01-03 | Democrat | 5 | |||||||||||||
35726 | 35726 | Jim Bunn B001063 | rep | OR | 1995-01-04 | 1997-01-03 | Republican | 5 | |||||||||||||
35737 | 35737 | Jim Chapman C000312 | rep | TX | 1995-01-04 | 1997-01-03 | Democrat | 1 | |||||||||||||
35738 | 35738 | Dick Chrysler C000385 | rep | MI | 1995-01-04 | 1997-01-03 | Republican | 8 | |||||||||||||
35747 | 35747 | William Clinger C000523 | rep | PA | 1995-01-04 | 1997-01-03 | Republican | 5 | |||||||||||||
35754 | 35754 | Ronald Coleman C000621 | rep | TX | 1995-01-04 | 1997-01-03 | Democrat | 16 | |||||||||||||
35757 | 35757 | Barbara-Rose Collins C000633 | rep | MI | 1995-01-04 | 1997-01-03 | Democrat | 15 | |||||||||||||
35769 | 35769 | Cardiss Collins C000634 | rep | IL | 1995-01-04 | 1997-01-03 | Democrat | 7 | |||||||||||||
35770 | 35770 | Wes Cooley C000737 | rep | OR | 1995-01-04 | 1997-01-03 | Republican | 2 | |||||||||||||
35771 | 35771 | Frank Cremeans C000903 | rep | OH | 1995-01-04 | 1997-01-03 | Republican | 6 | |||||||||||||
35780 | 35780 | Robert Dornan D000435 | rep | CA | 1995-01-04 | 1997-01-03 | Republican | 46 | |||||||||||||
35790 | 35790 | Cleo Fields F000110 | rep | LA | 1995-01-04 | 1997-01-03 | Democrat | 4 | |||||||||||||
35798 | 35798 | Jack Fields F000111 | rep | TX | 1995-01-04 | 1997-01-03 | Republican | 8 | |||||||||||||
35799 | 35799 | Michael Flanagan F000187 | rep | IL | 1995-01-04 | 1997-01-03 | Republican | 5 | |||||||||||||
35810 | 35810 | Harold Ford F000261 | rep | TN | 1995-01-04 | 1997-01-03 | Democrat | 9 | |||||||||||||
35813 | 35813 | Gary Franks F000348 | rep | CT | 1995-01-04 | 1997-01-03 | Republican | 5 | |||||||||||||
35814 | 35814 | Victor Frazer F000351 | rep | VI | 1995-01-04 | 1997-01-03 | Independent | 0 | |||||||||||||
35815 | 35815 | Dan Frisa F000387 | rep | NY | 1995-01-04 | 1997-01-03 | Republican | 4 | |||||||||||||
35816 | 35816 | David Funderburk F000426 | rep | NC | 1995-01-04 | 1997-01-03 | Republican | 2 | |||||||||||||
35820 | 35820 | Preston Geren G000134 | rep | TX | 1995-01-04 | 1997-01-03 | Democrat | 12 | |||||||||||||
35837 | 35837 | Sam Gibbons G000153 | rep | FL | 1995-01-04 | 1997-01-03 | Democrat | 11 | |||||||||||||
35850 | 35850 | Steven Gunderson G000524 | rep | WI | 1995-01-04 | 1997-01-03 | Republican | 3 | |||||||||||||
35854 | 35854 | Melton Hancock H000151 | rep | MO | 1995-01-04 | 1997-01-03 | Republican | 7 | |||||||||||||
35859 | 35859 | James Hayes H000390 | rep | LA | 1995-01-04 | 1997-01-03 | Republican | 7 | [ { "start": "1995-01-04", "end": "1995-12-01", "party": "Democrat" }, { "start": "1995-12-01", "end": "1997-01-03", "party": "Republican" } ] |
||||||||||||
35860 | 35860 | Fred Heineman H000452 | rep | NC | 1995-01-04 | 1997-01-03 | Republican | 4 | |||||||||||||
35862 | 35862 | Martin Hoke H000707 | rep | OH | 1995-01-04 | 1997-01-03 | Republican | 10 | |||||||||||||
35877 | 35877 | Andrew Jacobs J000033 | rep | IN | 1995-01-04 | 1997-01-03 | Democrat | 10 | |||||||||||||
35881 | 35881 | Harry Johnston J000187 | rep | FL | 1995-01-04 | 1997-01-03 | Democrat | 19 | |||||||||||||
35887 | 35887 | Gregory Laughlin L000119 | rep | TX | 1995-01-04 | 1997-01-03 | Republican | 14 | [ { "start": "1995-01-04", "end": "1995-06-26", "party": "Democrat" }, { "start": "1995-06-26", "end": "1997-01-03", "party": "Republican" } ] |
||||||||||||
35893 | 35893 | James Lightfoot L000305 | rep | IA | 1995-01-04 | 1997-01-03 | Republican | 3 | |||||||||||||
35894 | 35894 | James Longley L000431 | rep | ME | 1995-01-04 | 1997-01-03 | Republican | 1 | |||||||||||||
35900 | 35900 | William Martini M000207 | rep | NJ | 1995-01-04 | 1997-01-03 | Republican | 8 | |||||||||||||
35906 | 35906 | Jan Meyers M000684 | rep | KS | 1995-01-04 | 1997-01-03 | Republican | 3 | |||||||||||||
35932 | 35932 | Gillespie Montgomery M000865 | rep | MS | 1995-01-04 | 1997-01-03 | Democrat | 3 | |||||||||||||
35944 | 35944 | Carlos Moorhead M000926 | rep | CA | 1995-01-04 | 1997-01-03 | Republican | 27 | |||||||||||||
35963 | 35963 | John Myers M001130 | rep | IN | 1995-01-04 | 1997-01-03 | Republican | 7 | |||||||||||||
35966 | 35966 | William Orton O000108 | rep | UT | 1995-01-04 | 1997-01-03 | Democrat | 3 | |||||||||||||
35971 | 35971 | Lewis Payne P000152 | rep | VA | 1995-01-04 | 1997-01-03 | Democrat | 5 | |||||||||||||
35974 | 35974 | Douglas Peterson P000259 | rep | FL | 1995-01-04 | 1997-01-03 | Democrat | 2 | |||||||||||||
35991 | 35991 | James Quillen Q000013 | rep | TN | 1995-01-04 | 1997-01-03 | Republican | 1 | |||||||||||||
36007 | 36007 | Charles Rose R000436 | rep | NC | 1995-01-04 | 1997-01-03 | Democrat | 7 | |||||||||||||
36016 | 36016 | Toby Roth R000459 | rep | WI | 1995-01-04 | 1997-01-03 | Republican | 8 | |||||||||||||
36035 | 36035 | Patricia Schroeder S000142 | rep | CO | 1995-01-04 | 1997-01-03 | Democrat | 1 | |||||||||||||
36036 | 36036 | Andrea Seastrand S000213 | rep | CA | 1995-01-04 | 1997-01-03 | Republican | 22 | |||||||||||||
36048 | 36048 | Gerry Studds S001040 | rep | MA | 1995-01-04 | 1997-01-03 | Democrat | 10 | |||||||||||||
36049 | 36049 | Randy Tate T000048 | rep | WA | 1995-01-04 | 1997-01-03 | Republican | 9 | |||||||||||||
36055 | 36055 | Raymond Thornton T000243 | rep | AR | 1995-01-04 | 1997-01-03 | Democrat | 2 | |||||||||||||
36057 | 36057 | Peter Torkildsen T000314 | rep | MA | 1995-01-04 | 1997-01-03 | Republican | 6 | |||||||||||||
36069 | 36069 | Harold Volkmer V000112 | rep | MO | 1995-01-04 | 1997-01-03 | Democrat | 9 | |||||||||||||
36076 | 36076 | Barbara Vucanovich V000124 | rep | NV | 1995-01-04 | 1997-01-03 | Republican | 2 | |||||||||||||
36077 | 36077 | Enid Greene Waldholtz G000408 | rep | UT | 1995-01-04 | 1997-01-03 | Republican | 2 | |||||||||||||
36087 | 36087 | Robert Walker W000068 | rep | PA | 1995-01-04 | 1997-01-03 | Republican | 16 | |||||||||||||
36088 | 36088 | Michael Ward W000139 | rep | KY | 1995-01-04 | 1997-01-03 | Democrat | 3 | |||||||||||||
36097 | 36097 | John Williams W000520 | rep | MT | 1995-01-04 | 1997-01-03 | Democrat | 1 | |||||||||||||
36109 | 36109 | Charles Wilson W000570 | rep | TX | 1995-01-04 | 1997-01-03 | Democrat | 2 | |||||||||||||
36112 | 36112 | William Zeliff Z000004 | rep | NH | 1995-01-04 | 1997-01-03 | Republican | 1 | |||||||||||||
36115 | 36115 | Richard Zimmer Z000008 | rep | NJ | 1995-01-04 | 1997-01-03 | Republican | 12 | |||||||||||||
36131 | 36131 | Eligio de la Garza D000203 | rep | TX | 1995-01-04 | 1997-01-03 | Democrat | 15 | |||||||||||||
36134 | 36134 | Henry Baesler B000028 | rep | KY | 1995-01-04 | 1997-01-03 | Democrat | 6 | |||||||||||||
36136 | 36136 | Sonny Bono B000622 | rep | CA | 1995-01-04 | 1997-01-03 | Republican | 44 | |||||||||||||
36139 | 36139 | Jon Christensen C000377 | rep | NE | 1995-01-04 | 1997-01-03 | Republican | 2 | |||||||||||||
36154 | 36154 | Ronald Dellums D000222 | rep | CA | 1995-01-04 | 1997-01-03 | Democrat | 9 | |||||||||||||
36161 | 36161 | Harris Fawell F000049 | rep | IL | 1995-01-04 | 1997-01-03 | Republican | 13 | |||||||||||||
36171 | 36171 | Victor Fazio F000053 | rep | CA | 1995-01-04 | 1997-01-03 | Democrat | 3 | |||||||||||||
36177 | 36177 | Floyd Flake F000184 | rep | NY | 1995-01-04 | 1997-01-03 | Democrat | 6 | |||||||||||||
36186 | 36186 | Thomas Foglietta F000235 | rep | PA | 1995-01-04 | 1997-01-03 | Democrat | 1 | |||||||||||||
36188 | 36188 | Jon Fox F000332 | rep | PA | 1995-01-04 | 1997-01-03 | Republican | 13 | |||||||||||||
36191 | 36191 | Elizabeth Furse F000434 | rep | OR | 1995-01-04 | 1997-01-03 | Democrat | 1 | |||||||||||||
36201 | 36201 | Newton Gingrich G000225 | rep | GA | 1995-01-04 | 1997-01-03 | Republican | 6 | |||||||||||||
36220 | 36220 | Henry González G000272 | rep | TX | 1995-01-04 | 1997-01-03 | Democrat | 20 | |||||||||||||
36243 | 36243 | Lee Hamilton H000114 | rep | IN | 1995-01-04 | 1997-01-03 | Democrat | 9 | |||||||||||||
36255 | 36255 | Willie Hefner H000448 | rep | NC | 1995-01-04 | 1997-01-03 | Democrat | 8 | |||||||||||||
36263 | 36263 | Tim Hutchinson H001015 | rep | AR | 1995-01-04 | 1997-01-03 | Republican | 3 | |||||||||||||
36270 | 36270 | Joseph Kennedy K000110 | rep | MA | 1995-01-04 | 1997-01-03 | Democrat | 8 | |||||||||||||
36279 | 36279 | Barbara Kennelly K000118 | rep | CT | 1995-01-04 | 1997-01-03 | Democrat | 1 | |||||||||||||
36282 | 36282 | Jay Kim K000181 | rep | CA | 1995-01-04 | 1997-01-03 | Republican | 41 | |||||||||||||
36286 | 36286 | Scott Klug K000274 | rep | WI | 1995-01-04 | 1997-01-03 | Republican | 2 | |||||||||||||
36293 | 36293 | Thomas Manton M000117 | rep | NY | 1995-01-04 | 1997-01-03 | Democrat | 7 | |||||||||||||
36311 | 36311 | Joseph McDade M000399 | rep | PA | 1995-01-04 | 1997-01-03 | Republican | 10 | |||||||||||||
36314 | 36314 | Paul McHale M000466 | rep | PA | 1995-01-04 | 1997-01-03 | Democrat | 15 | |||||||||||||
36319 | 36319 | Susan Molinari M000843 | rep | NY | 1995-01-04 | 1997-01-03 | Republican | 13 | |||||||||||||
36321 | 36321 | Mark Neumann N000054 | rep | WI | 1995-01-04 | 1997-01-03 | Republican | 1 | |||||||||||||
36327 | 36327 | Michael Parker P000066 | rep | MS | 1995-01-04 | 1997-01-03 | Republican | 4 | [ { "start": "1995-01-04", "end": "1995-11-10", "party": "Democrat" }, { "start": "1995-11-10", "end": "1997-01-03", "party": "Republican" } ] |
||||||||||||
36332 | 36332 | L. Paxon P000148 | rep | NY | 1995-01-04 | 1997-01-03 | Republican | 27 | |||||||||||||
36337 | 36337 | Glenn Poshard P000452 | rep | IL | 1995-01-04 | 1997-01-03 | Democrat | 19 | |||||||||||||
36346 | 36346 | William Richardson R000229 | rep | NM | 1995-01-04 | 1997-01-03 | Democrat | 3 | |||||||||||||
36349 | 36349 | Frank Riggs R000252 | rep | CA | 1995-01-04 | 1997-01-03 | Republican | 1 | |||||||||||||
36359 | 36359 | Daniel Schaefer S000109 | rep | CO | 1995-01-04 | 1997-01-03 | Republican | 6 | |||||||||||||
36364 | 36364 | Steven Schiff S000125 | rep | NM | 1995-01-04 | 1997-01-03 | Republican | 1 | |||||||||||||
36370 | 36370 | David Skaggs S000462 | rep | CO | 1995-01-04 | 1997-01-03 | Democrat | 2 | |||||||||||||
36378 | 36378 | Linda Smith S000587 | rep | WA | 1995-01-04 | 1997-01-03 | Republican | 3 | |||||||||||||
36396 | 36396 | Gerald Solomon S000675 | rep | NY | 1995-01-04 | 1997-01-03 | Republican | 22 | |||||||||||||
36411 | 36411 | Louis Stokes S000948 | rep | OH | 1995-01-04 | 1997-01-03 | Democrat | 11 | |||||||||||||
36414 | 36414 | Frank Tejeda T000113 | rep | TX | 1995-01-04 | 1997-01-03 | Democrat | 28 |
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);