legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
476 rows where "start" is on date 1993-01-05
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
35753 | 35753 | Ronald Coleman C000621 | rep | TX | 1993-01-05 | 1995-01-03 | Democrat | 16 | |||||||||||||
35756 | 35756 | Barbara-Rose Collins C000633 | rep | MI | 1993-01-05 | 1995-01-03 | Democrat | 15 | |||||||||||||
35768 | 35768 | Cardiss Collins C000634 | rep | IL | 1993-01-05 | 1995-01-03 | Democrat | 7 | |||||||||||||
35779 | 35779 | Robert Dornan D000435 | rep | CA | 1993-01-05 | 1995-01-03 | Republican | 46 | |||||||||||||
35787 | 35787 | Norvell Emerson E000174 | rep | MO | 1993-01-05 | 1995-01-03 | Republican | 8 | |||||||||||||
35789 | 35789 | Cleo Fields F000110 | rep | LA | 1993-01-05 | 1995-01-03 | Democrat | 4 | |||||||||||||
35797 | 35797 | Jack Fields F000111 | rep | TX | 1993-01-05 | 1995-01-03 | Republican | 8 | |||||||||||||
35809 | 35809 | Harold Ford F000261 | rep | TN | 1993-01-05 | 1995-01-03 | Democrat | 9 | |||||||||||||
35812 | 35812 | Gary Franks F000348 | rep | CT | 1993-01-05 | 1995-01-03 | Republican | 5 | |||||||||||||
35819 | 35819 | Preston Geren G000134 | rep | TX | 1993-01-05 | 1995-01-03 | Democrat | 12 | |||||||||||||
35836 | 35836 | Sam Gibbons G000153 | rep | FL | 1993-01-05 | 1995-01-03 | Democrat | 11 | |||||||||||||
35841 | 35841 | Rod Grams G000367 | rep | MN | 1993-01-05 | 1995-01-03 | Republican | 6 | |||||||||||||
35849 | 35849 | Steven Gunderson G000524 | rep | WI | 1993-01-05 | 1995-01-03 | Republican | 3 | |||||||||||||
35853 | 35853 | Melton Hancock H000151 | rep | MO | 1993-01-05 | 1995-01-03 | Republican | 7 | |||||||||||||
35858 | 35858 | James Hayes H000390 | rep | LA | 1993-01-05 | 1995-01-03 | Democrat | 7 | |||||||||||||
35861 | 35861 | Martin Hoke H000707 | rep | OH | 1993-01-05 | 1995-01-03 | Republican | 10 | |||||||||||||
35876 | 35876 | Andrew Jacobs J000033 | rep | IN | 1993-01-05 | 1995-01-03 | Democrat | 10 | |||||||||||||
35880 | 35880 | Harry Johnston J000187 | rep | FL | 1993-01-05 | 1995-01-03 | Democrat | 19 | |||||||||||||
35886 | 35886 | Gregory Laughlin L000119 | rep | TX | 1993-01-05 | 1995-01-03 | Democrat | 14 | |||||||||||||
35892 | 35892 | James Lightfoot L000305 | rep | IA | 1993-01-05 | 1995-01-03 | Republican | 3 | |||||||||||||
35905 | 35905 | Jan Meyers M000684 | rep | KS | 1993-01-05 | 1995-01-03 | Republican | 3 | |||||||||||||
35916 | 35916 | Norman Mineta M000794 | rep | CA | 1993-01-05 | 1995-01-03 | Democrat | 15 | |||||||||||||
35931 | 35931 | Gillespie Montgomery M000865 | rep | MS | 1993-01-05 | 1995-01-03 | Democrat | 3 | |||||||||||||
35943 | 35943 | Carlos Moorhead M000926 | rep | CA | 1993-01-05 | 1995-01-03 | Republican | 27 | |||||||||||||
35962 | 35962 | John Myers M001130 | rep | IN | 1993-01-05 | 1995-01-03 | Republican | 7 | |||||||||||||
35965 | 35965 | William Orton O000108 | rep | UT | 1993-01-05 | 1995-01-03 | Democrat | 3 | |||||||||||||
35970 | 35970 | Lewis Payne P000152 | rep | VA | 1993-01-05 | 1995-01-03 | Democrat | 5 | |||||||||||||
35973 | 35973 | Douglas Peterson P000259 | rep | FL | 1993-01-05 | 1995-01-03 | Democrat | 2 | |||||||||||||
35990 | 35990 | James Quillen Q000013 | rep | TN | 1993-01-05 | 1995-01-03 | Republican | 1 | |||||||||||||
35992 | 35992 | Mel Reynolds R000178 | rep | IL | 1993-01-05 | 1995-01-03 | Democrat | 2 | |||||||||||||
36006 | 36006 | Charles Rose R000436 | rep | NC | 1993-01-05 | 1995-01-03 | Democrat | 7 | |||||||||||||
36015 | 36015 | Toby Roth R000459 | rep | WI | 1993-01-05 | 1995-01-03 | Republican | 8 | |||||||||||||
36034 | 36034 | Patricia Schroeder S000142 | rep | CO | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
36047 | 36047 | Gerry Studds S001040 | rep | MA | 1993-01-05 | 1995-01-03 | Democrat | 10 | |||||||||||||
36054 | 36054 | Raymond Thornton T000243 | rep | AR | 1993-01-05 | 1995-01-03 | Democrat | 2 | |||||||||||||
36056 | 36056 | Peter Torkildsen T000314 | rep | MA | 1993-01-05 | 1995-01-03 | Republican | 6 | |||||||||||||
36058 | 36058 | Walter Tucker T000405 | rep | CA | 1993-01-05 | 1995-01-03 | Democrat | 37 | |||||||||||||
36068 | 36068 | Harold Volkmer V000112 | rep | MO | 1993-01-05 | 1995-01-03 | Democrat | 9 | |||||||||||||
36075 | 36075 | Barbara Vucanovich V000124 | rep | NV | 1993-01-05 | 1995-01-03 | Republican | 2 | |||||||||||||
36086 | 36086 | Robert Walker W000068 | rep | PA | 1993-01-05 | 1995-01-03 | Republican | 16 | |||||||||||||
36096 | 36096 | John Williams W000520 | rep | MT | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
36108 | 36108 | Charles Wilson W000570 | rep | TX | 1993-01-05 | 1995-01-03 | Democrat | 2 | |||||||||||||
36111 | 36111 | William Zeliff Z000004 | rep | NH | 1993-01-05 | 1995-01-03 | Republican | 1 | |||||||||||||
36114 | 36114 | Richard Zimmer Z000008 | rep | NJ | 1993-01-05 | 1995-01-03 | Republican | 12 | |||||||||||||
36130 | 36130 | Eligio de la Garza D000203 | rep | TX | 1993-01-05 | 1995-01-03 | Democrat | 15 | |||||||||||||
36133 | 36133 | Henry Baesler B000028 | rep | KY | 1993-01-05 | 1995-01-03 | Democrat | 6 | |||||||||||||
36153 | 36153 | Ronald Dellums D000222 | rep | CA | 1993-01-05 | 1995-01-03 | Democrat | 9 | |||||||||||||
36160 | 36160 | Harris Fawell F000049 | rep | IL | 1993-01-05 | 1995-01-03 | Republican | 13 | |||||||||||||
36170 | 36170 | Victor Fazio F000053 | rep | CA | 1993-01-05 | 1995-01-03 | Democrat | 3 | |||||||||||||
36176 | 36176 | Floyd Flake F000184 | rep | NY | 1993-01-05 | 1995-01-03 | Democrat | 6 | |||||||||||||
36185 | 36185 | Thomas Foglietta F000235 | rep | PA | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
36190 | 36190 | Elizabeth Furse F000434 | rep | OR | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
36200 | 36200 | Newton Gingrich G000225 | rep | GA | 1993-01-05 | 1995-01-03 | Republican | 6 | |||||||||||||
36219 | 36219 | Henry González G000272 | rep | TX | 1993-01-05 | 1995-01-03 | Democrat | 20 | |||||||||||||
36242 | 36242 | Lee Hamilton H000114 | rep | IN | 1993-01-05 | 1995-01-03 | Democrat | 9 | |||||||||||||
36254 | 36254 | Willie Hefner H000448 | rep | NC | 1993-01-05 | 1995-01-03 | Democrat | 8 | |||||||||||||
36262 | 36262 | Tim Hutchinson H001015 | rep | AR | 1993-01-05 | 1995-01-03 | Republican | 3 | |||||||||||||
36269 | 36269 | Joseph Kennedy K000110 | rep | MA | 1993-01-05 | 1995-01-03 | Democrat | 8 | |||||||||||||
36278 | 36278 | Barbara Kennelly K000118 | rep | CT | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
36281 | 36281 | Jay Kim K000181 | rep | CA | 1993-01-05 | 1995-01-03 | Republican | 41 | |||||||||||||
36285 | 36285 | Scott Klug K000274 | rep | WI | 1993-01-05 | 1995-01-03 | Republican | 2 | |||||||||||||
36292 | 36292 | Thomas Manton M000117 | rep | NY | 1993-01-05 | 1995-01-03 | Democrat | 7 | |||||||||||||
36310 | 36310 | Joseph McDade M000399 | rep | PA | 1993-01-05 | 1995-01-03 | Republican | 10 | |||||||||||||
36313 | 36313 | Paul McHale M000466 | rep | PA | 1993-01-05 | 1995-01-03 | Democrat | 15 | |||||||||||||
36318 | 36318 | Susan Molinari M000843 | rep | NY | 1993-01-05 | 1995-01-03 | Republican | 13 | |||||||||||||
36326 | 36326 | Michael Parker P000066 | rep | MS | 1993-01-05 | 1995-01-03 | Democrat | 4 | |||||||||||||
36331 | 36331 | L. Paxon P000148 | rep | NY | 1993-01-05 | 1995-01-03 | Republican | 27 | |||||||||||||
36336 | 36336 | Glenn Poshard P000452 | rep | IL | 1993-01-05 | 1995-01-03 | Democrat | 19 | |||||||||||||
36345 | 36345 | William Richardson R000229 | rep | NM | 1993-01-05 | 1995-01-03 | Democrat | 3 | |||||||||||||
36351 | 36351 | Carlos Romero-Barceló R000417 | rep | PR | 1993-01-05 | 1997-01-03 | Democrat | 0 | |||||||||||||
36358 | 36358 | Daniel Schaefer S000109 | rep | CO | 1993-01-05 | 1995-01-03 | Republican | 6 | |||||||||||||
36363 | 36363 | Steven Schiff S000125 | rep | NM | 1993-01-05 | 1995-01-03 | Republican | 1 | |||||||||||||
36369 | 36369 | David Skaggs S000462 | rep | CO | 1993-01-05 | 1995-01-03 | Democrat | 2 | |||||||||||||
36385 | 36385 | Robert Smith S000607 | rep | OR | 1993-01-05 | 1995-01-03 | Republican | 2 | |||||||||||||
36395 | 36395 | Gerald Solomon S000675 | rep | NY | 1993-01-05 | 1995-01-03 | Republican | 22 | |||||||||||||
36410 | 36410 | Louis Stokes S000948 | rep | OH | 1993-01-05 | 1995-01-03 | Democrat | 11 | |||||||||||||
36413 | 36413 | Frank Tejeda T000113 | rep | TX | 1993-01-05 | 1995-01-03 | Democrat | 28 | |||||||||||||
36433 | 36433 | Esteban Torres T000316 | rep | CA | 1993-01-05 | 1995-01-03 | Democrat | 34 | |||||||||||||
36441 | 36441 | Robert Torricelli T000317 | rep | NJ | 1993-01-05 | 1995-01-03 | Democrat | 9 | |||||||||||||
36469 | 36469 | Sidney Yates Y000013 | rep | IL | 1993-01-05 | 1995-01-03 | Democrat | 9 | |||||||||||||
36483 | 36483 | Bill Archer A000215 | rep | TX | 1993-01-05 | 1995-01-03 | Republican | 7 | |||||||||||||
36488 | 36488 | Bill Barrett B000179 | rep | NE | 1993-01-05 | 1995-01-03 | Republican | 3 | |||||||||||||
36497 | 36497 | Herbert Bateman B000229 | rep | VA | 1993-01-05 | 1995-01-03 | Republican | 1 | |||||||||||||
36507 | 36507 | Tom Bliley B000556 | rep | VA | 1993-01-05 | 1995-01-03 | Republican | 7 | |||||||||||||
36520 | 36520 | John Breaux B000780 | sen | LA | 1993-01-05 | 1999-01-03 | 3 | Democrat | |||||||||||||
36536 | 36536 | George Brown B000918 | rep | CA | 1993-01-05 | 1995-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" } ] |
||||||||||||
36550 | 36550 | Charles Canady C000107 | rep | FL | 1993-01-05 | 1995-01-03 | Republican | 12 | |||||||||||||
36569 | 36569 | William Clay C000488 | rep | MO | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
36575 | 36575 | Paul Coverdell C000813 | sen | GA | 1993-01-05 | 1999-01-03 | 3 | Republican | |||||||||||||
36577 | 36577 | Pat Danner D000046 | rep | MO | 1993-01-05 | 1995-01-03 | Democrat | 6 | |||||||||||||
36586 | 36586 | Thomas Daschle D000064 | sen | SD | 1993-01-05 | 1999-01-03 | 3 | Democrat | |||||||||||||
36588 | 36588 | Jay Dickey D000312 | rep | AR | 1993-01-05 | 1995-01-03 | Republican | 4 | |||||||||||||
36599 | 36599 | Julian Dixon D000373 | rep | CA | 1993-01-05 | 1995-01-03 | Democrat | 32 | |||||||||||||
36605 | 36605 | Thomas Ewing E000282 | rep | IL | 1993-01-05 | 1995-01-03 | Republican | 15 | |||||||||||||
36613 | 36613 | Tillie Fowler F000328 | rep | FL | 1993-01-05 | 1995-01-03 | Republican | 4 | |||||||||||||
36617 | 36617 | Bob Franks F000349 | rep | NJ | 1993-01-05 | 1995-01-03 | Republican | 7 | |||||||||||||
36627 | 36627 | Sam Gejdenson G000120 | rep | CT | 1993-01-05 | 1995-01-03 | Democrat | 2 | |||||||||||||
36640 | 36640 | William Goodling G000291 | rep | PA | 1993-01-05 | 1995-01-03 | Republican | 19 | |||||||||||||
36645 | 36645 | Bob Graham G000352 | sen | FL | 1993-01-05 | 1999-01-03 | 3 | Democrat |
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);