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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
35096 | 35096 | Michael Andrews A000209 | rep | TX | 1993-01-05 | 1995-01-03 | Democrat | 25 | |||||||||||||
35098 | 35098 | Thomas Andrews A000211 | rep | ME | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
35107 | 35107 | Douglas Applegate A000214 | rep | OH | 1993-01-05 | 1995-01-03 | Democrat | 18 | |||||||||||||
35119 | 35119 | Leslie Aspin A000224 | rep | WI | 1993-01-05 | 1993-01-20 | Democrat | 1 | |||||||||||||
35121 | 35121 | James Bacchus B000008 | rep | FL | 1993-01-05 | 1995-01-03 | Democrat | 15 | |||||||||||||
35123 | 35123 | Thomas Barlow B000151 | rep | KY | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
35128 | 35128 | Helen Bentley B000392 | rep | MD | 1993-01-05 | 1995-01-03 | Republican | 2 | |||||||||||||
35132 | 35132 | James Bilbray B000462 | rep | NV | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
35134 | 35134 | Lucien Blackwell B000517 | rep | PA | 1993-01-05 | 1995-01-03 | Democrat | 2 | |||||||||||||
35155 | 35155 | Jack Brooks B000880 | rep | TX | 1993-01-05 | 1995-01-03 | Democrat | 9 | |||||||||||||
35159 | 35159 | Dale Bumpers B001057 | sen | AR | 1993-01-05 | 1999-01-03 | 3 | Democrat | |||||||||||||
35160 | 35160 | Leslie Byrne B001213 | rep | VA | 1993-01-05 | 1995-01-03 | Democrat | 11 | |||||||||||||
35169 | 35169 | Milton Carr C000178 | rep | MI | 1993-01-05 | 1995-01-03 | Democrat | 8 | |||||||||||||
35170 | 35170 | Samuel Coppersmith C000767 | rep | AZ | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
35173 | 35173 | Alfonse D’Amato D000018 | sen | NY | 1993-01-05 | 1999-01-03 | 3 | Republican | |||||||||||||
35179 | 35179 | George Darden D000051 | rep | GA | 1993-01-05 | 1995-01-03 | Democrat | 7 | |||||||||||||
35189 | 35189 | Butler Derrick D000267 | rep | SC | 1993-01-05 | 1995-01-03 | Democrat | 3 | |||||||||||||
35198 | 35198 | Robert Dole D000401 | sen | KS | 1993-01-05 | 1996-06-11 | 3 | Republican | |||||||||||||
35214 | 35214 | William Edwards E000064 | rep | CA | 1993-01-05 | 1995-01-03 | Democrat | 16 | |||||||||||||
35224 | 35224 | Glenn English E000184 | rep | OK | 1993-01-05 | 1994-01-07 | Democrat | 6 | |||||||||||||
35225 | 35225 | Karan English E000186 | rep | AZ | 1993-01-05 | 1995-01-03 | Democrat | 6 | |||||||||||||
35229 | 35229 | Albert Espy E000218 | rep | MS | 1993-01-05 | 1993-01-22 | Democrat | 2 | |||||||||||||
35230 | 35230 | Duncan Faircloth F000437 | sen | NC | 1993-01-05 | 1999-01-03 | 3 | Republican | |||||||||||||
35231 | 35231 | Eric Fingerhut F000128 | rep | OH | 1993-01-05 | 1995-01-03 | Democrat | 19 | |||||||||||||
35244 | 35244 | Hamilton Fish F000141 | rep | NY | 1993-01-05 | 1995-01-03 | Republican | 19 | |||||||||||||
35259 | 35259 | Thomas Foley F000239 | rep | WA | 1993-01-05 | 1995-01-03 | Democrat | 5 | |||||||||||||
35264 | 35264 | Wendell Ford F000268 | sen | KY | 1993-01-05 | 1999-01-03 | 3 | Democrat | |||||||||||||
35279 | 35279 | William Ford F000270 | rep | MI | 1993-01-05 | 1995-01-03 | Democrat | 13 | |||||||||||||
35284 | 35284 | Dean Gallo G000025 | rep | NJ | 1993-01-05 | 1995-01-03 | Republican | 11 | |||||||||||||
35289 | 35289 | John Glenn G000236 | sen | OH | 1993-01-05 | 1999-01-03 | 3 | Democrat | |||||||||||||
35298 | 35298 | Daniel Glickman G000240 | rep | KS | 1993-01-05 | 1995-01-03 | Democrat | 4 | |||||||||||||
35308 | 35308 | Willis Gradison G000349 | rep | OH | 1993-01-05 | 1993-01-31 | Republican | 2 | |||||||||||||
35312 | 35312 | Frederick Grandy G000371 | rep | IA | 1993-01-05 | 1995-01-03 | Republican | 5 | |||||||||||||
35313 | 35313 | Daniel Hamburg H000096 | rep | CA | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
35318 | 35318 | Paul Henry H000514 | rep | MI | 1993-01-05 | 1993-07-31 | Republican | 3 | |||||||||||||
35321 | 35321 | Peter Hoagland H000652 | rep | NE | 1993-01-05 | 1995-01-03 | Democrat | 2 | |||||||||||||
35325 | 35325 | George Hochbrueckner H000670 | rep | NY | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
35326 | 35326 | Michael Huffington H000912 | rep | CA | 1993-01-05 | 1995-01-03 | Republican | 22 | |||||||||||||
35336 | 35336 | William Hughes H000930 | rep | NJ | 1993-01-05 | 1995-01-03 | Democrat | 2 | |||||||||||||
35344 | 35344 | Earl Hutto H001018 | rep | FL | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
35345 | 35345 | Clete Johnson J000120 | rep | GA | 1993-01-05 | 1995-01-03 | Democrat | 10 | |||||||||||||
35346 | 35346 | Dirk Kempthorne K000088 | sen | ID | 1993-01-05 | 1999-01-03 | 3 | Republican | |||||||||||||
35347 | 35347 | Herbert Klein K000262 | rep | NJ | 1993-01-05 | 1995-01-03 | Democrat | 8 | |||||||||||||
35349 | 35349 | Michael Kopetski K000312 | rep | OR | 1993-01-05 | 1995-01-03 | Democrat | 5 | |||||||||||||
35350 | 35350 | Myron Kreidler K000328 | rep | WA | 1993-01-05 | 1995-01-03 | Democrat | 9 | |||||||||||||
35355 | 35355 | Larry LaRocco L000098 | rep | ID | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
35359 | 35359 | H. Lancaster L000045 | rep | NC | 1993-01-05 | 1995-01-03 | Democrat | 3 | |||||||||||||
35365 | 35365 | Richard Lehman L000225 | rep | CA | 1993-01-05 | 1995-01-03 | Democrat | 19 | |||||||||||||
35366 | 35366 | David Levy L000267 | rep | NY | 1993-01-05 | 1995-01-03 | Republican | 4 | |||||||||||||
35372 | 35372 | Thomas Lewis L000295 | rep | FL | 1993-01-05 | 1995-01-03 | Republican | 16 | |||||||||||||
35382 | 35382 | Marilyn Lloyd L000381 | rep | TN | 1993-01-05 | 1995-01-03 | Democrat | 3 | |||||||||||||
35385 | 35385 | Jill Long Thompson L000420 | rep | IN | 1993-01-05 | 1995-01-03 | Democrat | 4 | |||||||||||||
35388 | 35388 | Ronald Machtley M000015 | rep | RI | 1993-01-05 | 1995-01-03 | Republican | 1 | |||||||||||||
35389 | 35389 | David Mann M000100 | rep | OH | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
35390 | 35390 | Marjorie Margolies-Mezvinsky M000129 | rep | PA | 1993-01-05 | 1995-01-03 | Democrat | 13 | |||||||||||||
35391 | 35391 | Harlan Mathews M000236 | sen | TN | 1993-01-05 | 1995-01-03 | 2 | Democrat | appointment | ||||||||||||
35403 | 35403 | Romano Mazzoli M000291 | rep | KY | 1993-01-05 | 1995-01-03 | Democrat | 3 | |||||||||||||
35409 | 35409 | Alfred McCandless M000306 | rep | CA | 1993-01-05 | 1995-01-03 | Republican | 44 | |||||||||||||
35415 | 35415 | Francis McCloskey M000342 | rep | IN | 1993-01-05 | 1995-01-03 | Democrat | 8 | |||||||||||||
35422 | 35422 | David McCurdy M000398 | rep | OK | 1993-01-05 | 1995-01-03 | Democrat | 4 | |||||||||||||
35427 | 35427 | John McMillan M000566 | rep | NC | 1993-01-05 | 1995-01-03 | Republican | 9 | |||||||||||||
35446 | 35446 | Robert Michel M000692 | rep | IL | 1993-01-05 | 1995-01-03 | Republican | 18 | |||||||||||||
35447 | 35447 | Carol Moseley Braun M001025 | sen | IL | 1993-01-05 | 1999-01-03 | 3 | Democrat | |||||||||||||
35456 | 35456 | Austin Murphy M001088 | rep | PA | 1993-01-05 | 1995-01-03 | Democrat | 20 | |||||||||||||
35477 | 35477 | William Natcher N000009 | rep | KY | 1993-01-05 | 1994-03-29 | Democrat | 2 | |||||||||||||
35487 | 35487 | Stephen Neal N000016 | rep | NC | 1993-01-05 | 1995-01-03 | Democrat | 5 | |||||||||||||
35492 | 35492 | Robert Packwood P000009 | sen | OR | 1993-01-05 | 1995-12-31 | 3 | Republican | |||||||||||||
35501 | 35501 | Leon Panetta P000047 | rep | CA | 1993-01-05 | 1993-01-21 | Democrat | 17 | |||||||||||||
35507 | 35507 | Timothy Penny P000215 | rep | MN | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
35523 | 35523 | James Pickle P000328 | rep | TX | 1993-01-05 | 1995-01-03 | Democrat | 10 | |||||||||||||
35527 | 35527 | Arthur Ravenel R000072 | rep | SC | 1993-01-05 | 1995-01-03 | Republican | 1 | |||||||||||||
35533 | 35533 | Thomas Ridge R000243 | rep | PA | 1993-01-05 | 1995-01-03 | Republican | 21 | |||||||||||||
35551 | 35551 | Daniel Rostenkowski R000458 | rep | IL | 1993-01-05 | 1995-01-03 | Democrat | 5 | |||||||||||||
35557 | 35557 | James Rowland R000481 | rep | GA | 1993-01-05 | 1995-01-03 | Democrat | 8 | |||||||||||||
35560 | 35560 | George Sangmeister S000056 | rep | IL | 1993-01-05 | 1995-01-03 | Democrat | 11 | |||||||||||||
35563 | 35563 | William Sarpalius S000066 | rep | TX | 1993-01-05 | 1995-01-03 | Democrat | 13 | |||||||||||||
35564 | 35564 | Lynn Schenk S000119 | rep | CA | 1993-01-05 | 1995-01-03 | Democrat | 49 | |||||||||||||
35574 | 35574 | Philip Sharp S000294 | rep | IN | 1993-01-05 | 1995-01-03 | Democrat | 2 | |||||||||||||
35575 | 35575 | Karen Shepherd S000332 | rep | UT | 1993-01-05 | 1995-01-03 | Democrat | 2 | |||||||||||||
35581 | 35581 | James Slattery S000477 | rep | KS | 1993-01-05 | 1995-01-03 | Democrat | 2 | |||||||||||||
35599 | 35599 | Neal Smith S000596 | rep | IA | 1993-01-05 | 1995-01-03 | Democrat | 4 | |||||||||||||
35605 | 35605 | Donald Sundquist S001075 | rep | TN | 1993-01-05 | 1995-01-03 | Republican | 7 | |||||||||||||
35607 | 35607 | Richard Swett S001113 | rep | NH | 1993-01-05 | 1995-01-03 | Democrat | 2 | |||||||||||||
35615 | 35615 | Allan Swift S001115 | rep | WA | 1993-01-05 | 1995-01-03 | Democrat | 2 | |||||||||||||
35623 | 35623 | Michael Synar S001139 | rep | OK | 1993-01-05 | 1995-01-03 | Democrat | 2 | |||||||||||||
35626 | 35626 | Jolene Unsoeld U000017 | rep | WA | 1993-01-05 | 1995-01-03 | Democrat | 3 | |||||||||||||
35632 | 35632 | Itimous Valentine V000006 | rep | NC | 1993-01-05 | 1995-01-03 | Democrat | 2 | |||||||||||||
35635 | 35635 | Craig Washington W000177 | rep | TX | 1993-01-05 | 1995-01-03 | Democrat | 18 | |||||||||||||
35641 | 35641 | Alan Wheat W000326 | rep | MO | 1993-01-05 | 1995-01-03 | Democrat | 5 | |||||||||||||
35668 | 35668 | Jamie Whitten W000428 | rep | MS | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
35678 | 35678 | Ron de Lugo D000209 | rep | VI | 1993-01-05 | 1995-01-03 | Democrat | 0 | |||||||||||||
35681 | 35681 | William Baker B000078 | rep | CA | 1993-01-05 | 1995-01-03 | Republican | 10 | |||||||||||||
35691 | 35691 | Anthony Beilenson B000318 | rep | CA | 1993-01-05 | 1995-01-03 | Democrat | 24 | |||||||||||||
35706 | 35706 | Tom Bevill B000431 | rep | AL | 1993-01-05 | 1995-01-03 | Democrat | 4 | |||||||||||||
35708 | 35708 | Peter Blute B000576 | rep | MA | 1993-01-05 | 1995-01-03 | Republican | 3 | |||||||||||||
35711 | 35711 | William Brewster B000817 | rep | OK | 1993-01-05 | 1995-01-03 | Democrat | 3 | |||||||||||||
35715 | 35715 | John Browder B000897 | rep | AL | 1993-01-05 | 1995-01-03 | Democrat | 3 | |||||||||||||
35724 | 35724 | John Bryant B000997 | rep | TX | 1993-01-05 | 1995-01-03 | Democrat | 5 | |||||||||||||
35736 | 35736 | Jim Chapman C000312 | rep | TX | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
35746 | 35746 | William Clinger C000523 | rep | PA | 1993-01-05 | 1995-01-03 | Republican | 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);