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 rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: start
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
43571 | 43571 | Maxine Waters W000187 | rep | CA | 1995-01-04 | 1997-01-03 | Democrat | 35 | |||||||||||||
43539 | 43539 | Nydia Velázquez V000081 | rep | NY | 1995-01-04 | 1997-01-03 | Democrat | 12 | |||||||||||||
43516 | 43516 | Fred Upton U000031 | rep | MI | 1995-01-04 | 1997-01-03 | Republican | 6 | |||||||||||||
43451 | 43451 | Bennie Thompson T000193 | rep | MS | 1995-01-04 | 1997-01-03 | Democrat | 2 | |||||||||||||
43418 | 43418 | Christopher Smith S000522 | rep | NJ | 1995-01-04 | 1997-01-03 | Republican | 4 | |||||||||||||
43322 | 43322 | Robert Scott S000185 | rep | VA | 1995-01-04 | 1997-01-03 | Democrat | 3 | |||||||||||||
43293 | 43293 | Charles Schumer S000148 | rep | NY | 1995-01-04 | 1997-01-03 | Democrat | 9 | |||||||||||||
43209 | 43209 | Bobby Rush R000515 | rep | IL | 1995-01-04 | 1997-01-03 | Democrat | 1 | |||||||||||||
43182 | 43182 | Lucille Roybal-Allard R000486 | rep | CA | 1995-01-04 | 1997-01-03 | Democrat | 33 | |||||||||||||
43157 | 43157 | Harold Rogers R000395 | rep | KY | 1995-01-04 | 1997-01-03 | Republican | 5 | |||||||||||||
43111 | 43111 | Robert Portman P000449 | rep | OH | 1995-01-04 | 1997-01-03 | Republican | 2 | |||||||||||||
43076 | 43076 | Nancy Pelosi P000197 | rep | CA | 1995-01-04 | 1997-01-03 | Democrat | 8 | |||||||||||||
43043 | 43043 | Frank Pallone P000034 | rep | NJ | 1995-01-04 | 1997-01-03 | Democrat | 6 | |||||||||||||
43019 | 43019 | Eleanor Norton N000147 | rep | DC | 1995-01-04 | 1997-01-03 | Democrat | 0 | |||||||||||||
43003 | 43003 | Richard Neal N000015 | rep | MA | 1995-01-04 | 1997-01-03 | Democrat | 2 | |||||||||||||
42974 | 42974 | Jerrold Nadler N000002 | rep | NY | 1995-01-04 | 1997-01-03 | Democrat | 8 | |||||||||||||
42825 | 42825 | Edward Markey M000133 | rep | MA | 1995-01-04 | 1997-01-03 | Democrat | 7 | |||||||||||||
42801 | 42801 | Carolyn Maloney M000087 | rep | NY | 1995-01-04 | 1997-01-03 | Democrat | 14 | |||||||||||||
42761 | 42761 | Frank Lucas L000491 | rep | OK | 1995-01-04 | 1997-01-03 | Republican | 6 | |||||||||||||
42740 | 42740 | Zoe Lofgren L000397 | rep | CA | 1995-01-04 | 1997-01-03 | Democrat | 16 | |||||||||||||
42618 | 42618 | Marcy Kaptur K000009 | rep | OH | 1995-01-04 | 1997-01-03 | Democrat | 9 | |||||||||||||
42580 | 42580 | Eddie Johnson J000126 | rep | TX | 1995-01-04 | 1997-01-03 | Democrat | 30 | |||||||||||||
42559 | 42559 | Sheila Jackson Lee J000032 | rep | TX | 1995-01-04 | 1997-01-03 | Democrat | 18 | |||||||||||||
42539 | 42539 | Steny Hoyer H000874 | rep | MD | 1995-01-04 | 1997-01-03 | Democrat | 5 | |||||||||||||
42364 | 42364 | Anna Eshoo E000215 | rep | CA | 1995-01-04 | 1997-01-03 | Democrat | 14 | |||||||||||||
42343 | 42343 | Michael Doyle D000482 | rep | PA | 1995-01-04 | 1997-01-03 | Democrat | 18 | |||||||||||||
42329 | 42329 | Lloyd Doggett D000399 | rep | TX | 1995-01-04 | 1997-01-03 | Democrat | 10 | |||||||||||||
42299 | 42299 | Rosa DeLauro D000216 | rep | CT | 1995-01-04 | 1997-01-03 | Democrat | 3 | |||||||||||||
42270 | 42270 | Peter DeFazio D000191 | rep | OR | 1995-01-04 | 1997-01-03 | Democrat | 4 | |||||||||||||
42232 | 42232 | Michael Crapo C000880 | rep | ID | 1995-01-04 | 1997-01-03 | Republican | 2 | |||||||||||||
42159 | 42159 | James Clyburn C000537 | rep | SC | 1995-01-04 | 1997-01-03 | Democrat | 6 | |||||||||||||
42115 | 42115 | Steve Chabot C000266 | rep | OH | 1995-01-04 | 1997-01-03 | Republican | 1 | |||||||||||||
42061 | 42061 | Ken Calvert C000059 | rep | CA | 1995-01-04 | 1997-01-03 | Republican | 43 | |||||||||||||
42042 | 42042 | Richard Burr B001135 | rep | NC | 1995-01-04 | 1997-01-03 | Republican | 5 | |||||||||||||
41967 | 41967 | Earl Blumenauer B000574 | rep | OR | 1996-05-21 | 1997-01-03 | Democrat | 3 | |||||||||||||
41944 | 41944 | Sanford Bishop B000490 | rep | GA | 1995-01-04 | 1997-01-03 | Democrat | 2 | |||||||||||||
41878 | 41878 | John Reed R000122 | rep | RI | 1995-01-04 | 1997-01-03 | Democrat | 2 | |||||||||||||
41867 | 41867 | Mitch McConnell M000355 | sen | KY | 1991-01-03 | 1997-01-03 | 2 | Republican | |||||||||||||
41860 | 41860 | James Inhofe I000024 | sen | OK | 1994-11-17 | 1997-01-03 | 2 | Republican | |||||||||||||
41848 | 41848 | Lindsey Graham G000359 | rep | SC | 1995-01-04 | 1997-01-03 | Republican | 3 | |||||||||||||
41842 | 41842 | Richard Durbin D000563 | rep | IL | 1995-01-04 | 1997-01-03 | Democrat | 20 | |||||||||||||
41816 | 41816 | Roger Wicker W000437 | rep | MS | 1995-01-04 | 1997-01-03 | Republican | 1 | |||||||||||||
41792 | 41792 | Bernard Sanders S000033 | rep | VT | 1995-01-04 | 1997-01-03 | Independent | 0 | Democrat | ||||||||||||
41780 | 41780 | Robert Menendez M000639 | rep | NJ | 1995-01-04 | 1997-01-03 | Democrat | 13 | |||||||||||||
41749 | 41749 | Benjamin Cardin C000141 | rep | MD | 1995-01-04 | 1997-01-03 | Democrat | 3 | |||||||||||||
41731 | 41731 | Sherrod Brown B000944 | rep | OH | 1995-01-04 | 1997-01-03 | Democrat | 13 | |||||||||||||
41675 | 41675 | Don Young Y000033 | rep | AK | 1995-01-04 | 1997-01-03 | Republican | 0 | |||||||||||||
41632 | 41632 | Alcee Hastings H000324 | rep | FL | 1995-01-04 | 1997-01-03 | Democrat | 23 | |||||||||||||
41517 | 41517 | Peter Visclosky V000108 | rep | IN | 1995-01-04 | 1997-01-03 | Democrat | 1 | |||||||||||||
41494 | 41494 | Mac Thornberry T000238 | rep | TX | 1995-01-04 | 1997-01-03 | Republican | 13 | |||||||||||||
41469 | 41469 | José Serrano S000248 | rep | NY | 1995-01-04 | 1997-01-03 | Democrat | 16 | |||||||||||||
41453 | 41453 | F. Sensenbrenner S000244 | rep | WI | 1995-01-04 | 1997-01-03 | Republican | 9 | |||||||||||||
41421 | 41421 | Collin Peterson P000258 | rep | MN | 1995-01-04 | 1997-01-03 | Democrat | 7 | |||||||||||||
41392 | 41392 | Nita Lowey L000480 | rep | NY | 1995-01-04 | 1997-01-03 | Democrat | 18 | |||||||||||||
41352 | 41352 | Peter King K000210 | rep | NY | 1995-01-04 | 1997-01-03 | Republican | 3 | |||||||||||||
41330 | 41330 | Eliot Engel E000179 | rep | NY | 1995-01-04 | 1997-01-03 | Democrat | 17 | |||||||||||||
41273 | 41273 | Pat Roberts R000307 | rep | KS | 1995-01-04 | 1997-01-03 | Republican | 1 | |||||||||||||
41233 | 41233 | John Lewis L000287 | rep | GA | 1995-01-04 | 1997-01-03 | Democrat | 5 | |||||||||||||
41196 | 41196 | Elijah Cummings C000984 | rep | MD | 1996-04-16 | 1997-01-03 | Democrat | 7 | |||||||||||||
41174 | 41174 | Walter Jones J000255 | rep | NC | 1995-01-04 | 1997-01-03 | Republican | 3 | |||||||||||||
41117 | 41117 | Marshall Sanford S000051 | rep | SC | 1995-01-04 | 1997-01-03 | Republican | 1 | |||||||||||||
41059 | 41059 | Lamar Smith S000583 | rep | TX | 1995-01-04 | 1997-01-03 | Republican | 21 | |||||||||||||
41024 | 41024 | Edward Royce R000487 | rep | CA | 1995-01-04 | 1997-01-03 | Republican | 39 | |||||||||||||
41001 | 41001 | Ileana Ros-Lehtinen R000435 | rep | FL | 1995-01-04 | 1997-01-03 | Republican | 18 | |||||||||||||
40977 | 40977 | Dana Rohrabacher R000409 | rep | CA | 1995-01-04 | 1997-01-03 | Republican | 45 | |||||||||||||
40923 | 40923 | Frank LoBiondo L000554 | rep | NJ | 1995-01-04 | 1997-01-03 | Republican | 2 | |||||||||||||
40911 | 40911 | Sander Levin L000263 | rep | MI | 1995-01-04 | 1997-01-03 | Democrat | 12 | |||||||||||||
40884 | 40884 | Sam Johnson J000174 | rep | TX | 1995-01-04 | 1997-01-03 | Republican | 3 | |||||||||||||
40848 | 40848 | Luis Gutiérrez G000535 | rep | IL | 1995-01-04 | 1997-01-03 | Democrat | 4 | |||||||||||||
40835 | 40835 | Gene Green G000410 | rep | TX | 1995-01-04 | 1997-01-03 | Democrat | 29 | |||||||||||||
40818 | 40818 | Bob Goodlatte G000289 | rep | VA | 1995-01-04 | 1997-01-03 | Republican | 6 | |||||||||||||
40805 | 40805 | Rodney Frelinghuysen F000372 | rep | NJ | 1995-01-04 | 1997-01-03 | Republican | 11 | |||||||||||||
40780 | 40780 | John Duncan D000533 | rep | TN | 1995-01-04 | 1997-01-03 | Republican | 2 | |||||||||||||
40699 | 40699 | Joe Barton B000213 | rep | TX | 1995-01-04 | 1997-01-03 | Republican | 6 | |||||||||||||
40623 | 40623 | Thad Cochran C000567 | sen | MS | 1991-01-03 | 1997-01-03 | 2 | Republican | |||||||||||||
40606 | 40606 | Louise Slaughter S000480 | rep | NY | 1995-01-04 | 1997-01-03 | Democrat | 28 | |||||||||||||
40570 | 40570 | John Conyers C000714 | rep | MI | 1995-01-04 | 1997-01-03 | Democrat | 14 | |||||||||||||
40513 | 40513 | Xavier Becerra B000287 | rep | CA | 1995-01-04 | 1997-01-03 | Democrat | 30 | |||||||||||||
40487 | 40487 | Matt Salmon S000018 | rep | AZ | 1995-01-04 | 1997-01-03 | Republican | 1 | |||||||||||||
40450 | 40450 | Charles Rangel R000053 | rep | NY | 1995-01-04 | 1997-01-03 | Democrat | 15 | |||||||||||||
40397 | 40397 | John Mica M000689 | rep | FL | 1995-01-04 | 1997-01-03 | Republican | 7 | |||||||||||||
40385 | 40385 | Jim McDermott M000404 | rep | WA | 1995-01-04 | 1997-01-03 | Democrat | 7 | |||||||||||||
40297 | 40297 | Sam Farr F000030 | rep | CA | 1995-01-04 | 1997-01-03 | Democrat | 17 | |||||||||||||
40256 | 40256 | Corrine Brown B000911 | rep | FL | 1995-01-04 | 1997-01-03 | Democrat | 3 | |||||||||||||
40178 | 40178 | Ed Whitfield W000413 | rep | KY | 1995-01-04 | 1997-01-03 | Republican | 1 | |||||||||||||
40167 | 40167 | Chaka Fattah F000043 | rep | PA | 1995-01-04 | 1997-01-03 | Democrat | 2 | |||||||||||||
40156 | 40156 | John Boehner B000589 | rep | OH | 1995-01-04 | 1997-01-03 | Republican | 8 | |||||||||||||
40136 | 40136 | Howard Coble C000556 | rep | NC | 1995-01-04 | 1997-01-03 | Republican | 6 | |||||||||||||
40118 | 40118 | Steve Stockman S000937 | rep | TX | 1995-01-04 | 1997-01-03 | Republican | 9 | |||||||||||||
40106 | 40106 | Frank Wolf W000672 | rep | VA | 1995-01-04 | 1997-01-03 | Republican | 10 | |||||||||||||
40089 | 40089 | Henry Waxman W000215 | rep | CA | 1995-01-04 | 1997-01-03 | Democrat | 29 | |||||||||||||
40036 | 40036 | Nick Rahall R000011 | rep | WV | 1995-01-04 | 1997-01-03 | Democrat | 3 | |||||||||||||
40017 | 40017 | Thomas Petri P000265 | rep | WI | 1995-01-04 | 1997-01-03 | Republican | 6 | |||||||||||||
39999 | 39999 | Ed Pastor P000099 | rep | AZ | 1995-01-04 | 1997-01-03 | Democrat | 2 | |||||||||||||
39984 | 39984 | James Moran M000933 | rep | VA | 1995-01-04 | 1997-01-03 | Democrat | 8 | |||||||||||||
39972 | 39972 | George Miller M000725 | rep | CA | 1995-01-04 | 1997-01-03 | Democrat | 7 | |||||||||||||
39938 | 39938 | Howard McKeon M000508 | rep | CA | 1995-01-04 | 1997-01-03 | Republican | 25 | |||||||||||||
39902 | 39902 | Tom Latham L000111 | rep | IA | 1995-01-04 | 1997-01-03 | Republican | 5 | |||||||||||||
39892 | 39892 | Jack Kingston K000220 | rep | GA | 1995-01-04 | 1997-01-03 | Republican | 1 | |||||||||||||
39873 | 39873 | Doc Hastings H000329 | rep | WA | 1995-01-04 | 1997-01-03 | Republican | 4 |
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);