legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
36 rows where "start" is on date 1993-01-05 and type = "sen"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
35159 | 35159 | Dale Bumpers B001057 | sen | AR | 1993-01-05 | 1999-01-03 | 3 | Democrat | |||||||||||||
35173 | 35173 | Alfonse D’Amato D000018 | sen | NY | 1993-01-05 | 1999-01-03 | 3 | Republican | |||||||||||||
35198 | 35198 | Robert Dole D000401 | sen | KS | 1993-01-05 | 1996-06-11 | 3 | Republican | |||||||||||||
35230 | 35230 | Duncan Faircloth F000437 | sen | NC | 1993-01-05 | 1999-01-03 | 3 | Republican | |||||||||||||
35264 | 35264 | Wendell Ford F000268 | sen | KY | 1993-01-05 | 1999-01-03 | 3 | Democrat | |||||||||||||
35289 | 35289 | John Glenn G000236 | sen | OH | 1993-01-05 | 1999-01-03 | 3 | Democrat | |||||||||||||
35346 | 35346 | Dirk Kempthorne K000088 | sen | ID | 1993-01-05 | 1999-01-03 | 3 | Republican | |||||||||||||
35391 | 35391 | Harlan Mathews M000236 | sen | TN | 1993-01-05 | 1995-01-03 | 2 | Democrat | appointment | ||||||||||||
35447 | 35447 | Carol Moseley Braun M001025 | sen | IL | 1993-01-05 | 1999-01-03 | 3 | Democrat | |||||||||||||
35492 | 35492 | Robert Packwood P000009 | sen | OR | 1993-01-05 | 1995-12-31 | 3 | Republican | |||||||||||||
36520 | 36520 | John Breaux B000780 | sen | LA | 1993-01-05 | 1999-01-03 | 3 | Democrat | |||||||||||||
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" } ] |
||||||||||||
36575 | 36575 | Paul Coverdell C000813 | sen | GA | 1993-01-05 | 1999-01-03 | 3 | Republican | |||||||||||||
36586 | 36586 | Thomas Daschle D000064 | sen | SD | 1993-01-05 | 1999-01-03 | 3 | Democrat | |||||||||||||
36645 | 36645 | Bob Graham G000352 | sen | FL | 1993-01-05 | 1999-01-03 | 3 | Democrat | |||||||||||||
36654 | 36654 | Ernest Hollings H000725 | sen | SC | 1993-01-05 | 1999-01-03 | 3 | Democrat | |||||||||||||
36718 | 36718 | Frank Murkowski M001085 | sen | AK | 1993-01-05 | 1999-01-03 | 3 | Republican | |||||||||||||
36722 | 36722 | Don Nickles N000102 | sen | OK | 1993-01-05 | 1999-01-03 | 3 | Republican | |||||||||||||
37517 | 37517 | Robert Bennett B000382 | sen | UT | 1993-01-05 | 1999-01-03 | 3 | Republican | |||||||||||||
37545 | 37545 | Christopher Bond B000611 | sen | MO | 1993-01-05 | 1999-01-03 | 3 | Republican | |||||||||||||
37609 | 37609 | Christopher Dodd D000388 | sen | CT | 1993-01-05 | 1999-01-03 | 3 | Democrat | |||||||||||||
37619 | 37619 | Byron Dorgan D000432 | sen | ND | 1993-01-05 | 1999-01-03 | 3 | Democrat | |||||||||||||
37634 | 37634 | Russell Feingold F000061 | sen | WI | 1993-01-05 | 1999-01-03 | 3 | Democrat | |||||||||||||
37661 | 37661 | Judd Gregg G000445 | sen | NH | 1993-01-05 | 1999-01-03 | 3 | Republican | |||||||||||||
37885 | 37885 | Arlen Specter S000709 | sen | PA | 1993-01-05 | 1999-01-03 | 3 | Republican | |||||||||||||
39026 | 39026 | Daniel Inouye I000025 | sen | HI | 1993-01-05 | 1999-01-03 | 3 | Democrat | |||||||||||||
39051 | 39051 | Kay Hutchison H001016 | sen | TX | 1993-01-05 | 1995-01-03 | 1 | Republican | |||||||||||||
40206 | 40206 | Barbara Boxer B000711 | sen | CA | 1993-01-05 | 1999-01-03 | 3 | Democrat | |||||||||||||
40215 | 40215 | Daniel Coats C000542 | sen | IN | 1993-01-05 | 1999-01-03 | 3 | Republican | |||||||||||||
40230 | 40230 | Barbara Mikulski M000702 | sen | MD | 1993-01-05 | 1999-01-03 | 3 | Democrat | |||||||||||||
40237 | 40237 | Harry Reid R000146 | sen | NV | 1993-01-05 | 1999-01-03 | 3 | Democrat | |||||||||||||
40649 | 40649 | John McCain M000303 | sen | AZ | 1993-01-05 | 1999-01-03 | 3 | Republican | |||||||||||||
42439 | 42439 | Charles Grassley G000386 | sen | IA | 1993-01-05 | 1999-01-03 | 3 | Republican | |||||||||||||
42720 | 42720 | Patrick Leahy L000174 | sen | VT | 1993-01-05 | 1999-01-03 | 3 | Democrat | |||||||||||||
42967 | 42967 | Patty Murray M001111 | sen | WA | 1993-01-05 | 1999-01-03 | 3 | Democrat | |||||||||||||
43351 | 43351 | Richard Shelby S000320 | sen | AL | 1993-01-05 | 1999-01-03 | 3 | Republican | [ { "start": "1993-01-05", "end": "1994-11-09", "party": "Democrat" }, { "start": "1994-11-09", "end": "2005-01-03", "party": "Republican" } ] |
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);