legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
473 rows where "end" is on date 2001-01-03 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, class, district, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
44456 | 44456 | Pete Sessions S000250 | rep | TX | 1999-01-06 | 2001-01-03 | Republican | 5 | |||||||||||||
43573 | 43573 | Maxine Waters W000187 | rep | CA | 1999-01-06 | 2001-01-03 | Democrat | 35 | |||||||||||||
43541 | 43541 | Nydia Velázquez V000081 | rep | NY | 1999-01-06 | 2001-01-03 | Democrat | 12 | |||||||||||||
43518 | 43518 | Fred Upton U000031 | rep | MI | 1999-01-06 | 2001-01-03 | Republican | 6 | |||||||||||||
43497 | 43497 | Patrick Toomey T000461 | rep | PA | 1999-01-06 | 2001-01-03 | Republican | 15 | |||||||||||||
43485 | 43485 | John Thune T000250 | rep | SD | 1999-01-06 | 2001-01-03 | Republican | 0 | |||||||||||||
43465 | 43465 | Mike Thompson T000460 | rep | CA | 1999-01-06 | 2001-01-03 | Democrat | 1 | |||||||||||||
43453 | 43453 | Bennie Thompson T000193 | rep | MS | 1999-01-06 | 2001-01-03 | Democrat | 2 | |||||||||||||
43420 | 43420 | Christopher Smith S000522 | rep | NJ | 1999-01-06 | 2001-01-03 | Republican | 4 | |||||||||||||
43391 | 43391 | Adam Smith S000510 | rep | WA | 1999-01-06 | 2001-01-03 | Democrat | 9 | |||||||||||||
43369 | 43369 | Michael Simpson S001148 | rep | ID | 1999-01-06 | 2001-01-03 | Republican | 2 | |||||||||||||
43357 | 43357 | Brad Sherman S000344 | rep | CA | 1999-01-06 | 2001-01-03 | Democrat | 24 | |||||||||||||
43324 | 43324 | Robert Scott S000185 | rep | VA | 1999-01-06 | 2001-01-03 | Democrat | 3 | |||||||||||||
43256 | 43256 | Janice Schakowsky S001145 | rep | IL | 1999-01-06 | 2001-01-03 | Democrat | 9 | |||||||||||||
43211 | 43211 | Bobby Rush R000515 | rep | IL | 1999-01-06 | 2001-01-03 | Democrat | 1 | |||||||||||||
43184 | 43184 | Lucille Roybal-Allard R000486 | rep | CA | 1999-01-06 | 2001-01-03 | Democrat | 33 | |||||||||||||
43159 | 43159 | Harold Rogers R000395 | rep | KY | 1999-01-06 | 2001-01-03 | Republican | 5 | |||||||||||||
43131 | 43131 | David Price P000523 | rep | NC | 1999-01-06 | 2001-01-03 | Democrat | 4 | |||||||||||||
43113 | 43113 | Robert Portman P000449 | rep | OH | 1999-01-06 | 2001-01-03 | Republican | 2 | |||||||||||||
43078 | 43078 | Nancy Pelosi P000197 | rep | CA | 1999-01-06 | 2001-01-03 | Democrat | 8 | |||||||||||||
43058 | 43058 | Bill Pascrell P000096 | rep | NJ | 1999-01-06 | 2001-01-03 | Democrat | 8 | |||||||||||||
43045 | 43045 | Frank Pallone P000034 | rep | NJ | 1999-01-06 | 2001-01-03 | Democrat | 6 | |||||||||||||
43021 | 43021 | Eleanor Norton N000147 | rep | DC | 1999-01-06 | 2001-01-03 | Democrat | 0 | |||||||||||||
43005 | 43005 | Richard Neal N000015 | rep | MA | 1999-01-06 | 2001-01-03 | Democrat | 2 | |||||||||||||
42988 | 42988 | Grace Napolitano N000179 | rep | CA | 1999-01-06 | 2001-01-03 | Democrat | 34 | |||||||||||||
42976 | 42976 | Jerrold Nadler N000002 | rep | NY | 1999-01-06 | 2001-01-03 | Democrat | 8 | |||||||||||||
42950 | 42950 | Jerry Moran M000934 | rep | KS | 1999-01-06 | 2001-01-03 | Republican | 1 | |||||||||||||
42928 | 42928 | Gregory Meeks M001137 | rep | NY | 1999-01-06 | 2001-01-03 | Democrat | 6 | |||||||||||||
42883 | 42883 | James McGovern M000312 | rep | MA | 1999-01-06 | 2001-01-03 | Democrat | 3 | |||||||||||||
42827 | 42827 | Edward Markey M000133 | rep | MA | 1999-01-06 | 2001-01-03 | Democrat | 7 | |||||||||||||
42803 | 42803 | Carolyn Maloney M000087 | rep | NY | 1999-01-06 | 2001-01-03 | Democrat | 14 | |||||||||||||
42763 | 42763 | Frank Lucas L000491 | rep | OK | 1999-01-06 | 2001-01-03 | Republican | 6 | |||||||||||||
42742 | 42742 | Zoe Lofgren L000397 | rep | CA | 1999-01-06 | 2001-01-03 | Democrat | 16 | |||||||||||||
42726 | 42726 | Barbara Lee L000551 | rep | CA | 1999-01-06 | 2001-01-03 | Democrat | 9 | |||||||||||||
42697 | 42697 | John Larson L000557 | rep | CT | 1999-01-06 | 2001-01-03 | Democrat | 1 | |||||||||||||
42645 | 42645 | Ron Kind K000188 | rep | WI | 1999-01-06 | 2001-01-03 | Democrat | 3 | |||||||||||||
42620 | 42620 | Marcy Kaptur K000009 | rep | OH | 1999-01-06 | 2001-01-03 | Democrat | 9 | |||||||||||||
42582 | 42582 | Eddie Johnson J000126 | rep | TX | 1999-01-06 | 2001-01-03 | Democrat | 30 | |||||||||||||
42561 | 42561 | Sheila Jackson Lee J000032 | rep | TX | 1999-01-06 | 2001-01-03 | Democrat | 18 | |||||||||||||
42541 | 42541 | Steny Hoyer H000874 | rep | MD | 1999-01-06 | 2001-01-03 | Democrat | 5 | |||||||||||||
42422 | 42422 | Kay Granger G000377 | rep | TX | 1999-01-06 | 2001-01-03 | Republican | 12 | |||||||||||||
42366 | 42366 | Anna Eshoo E000215 | rep | CA | 1999-01-06 | 2001-01-03 | Democrat | 14 | |||||||||||||
42345 | 42345 | Michael Doyle D000482 | rep | PA | 1999-01-06 | 2001-01-03 | Democrat | 18 | |||||||||||||
42331 | 42331 | Lloyd Doggett D000399 | rep | TX | 1999-01-06 | 2001-01-03 | Democrat | 10 | |||||||||||||
42301 | 42301 | Rosa DeLauro D000216 | rep | CT | 1999-01-06 | 2001-01-03 | Democrat | 3 | |||||||||||||
42285 | 42285 | Diana DeGette D000197 | rep | CO | 1999-01-06 | 2001-01-03 | Democrat | 1 | |||||||||||||
42272 | 42272 | Peter DeFazio D000191 | rep | OR | 1999-01-06 | 2001-01-03 | Democrat | 4 | |||||||||||||
42254 | 42254 | Danny Davis D000096 | rep | IL | 1999-01-06 | 2001-01-03 | Democrat | 7 | |||||||||||||
42161 | 42161 | James Clyburn C000537 | rep | SC | 1999-01-06 | 2001-01-03 | Democrat | 6 | |||||||||||||
42117 | 42117 | Steve Chabot C000266 | rep | OH | 1999-01-06 | 2001-01-03 | Republican | 1 | |||||||||||||
42063 | 42063 | Ken Calvert C000059 | rep | CA | 1999-01-06 | 2001-01-03 | Republican | 43 | |||||||||||||
42044 | 42044 | Richard Burr B001135 | rep | NC | 1999-01-06 | 2001-01-03 | Republican | 5 | |||||||||||||
42000 | 42000 | Kevin Brady B000755 | rep | TX | 1999-01-06 | 2001-01-03 | Republican | 8 | |||||||||||||
41984 | 41984 | Roy Blunt B000575 | rep | MO | 1999-01-06 | 2001-01-03 | Republican | 7 | |||||||||||||
41969 | 41969 | Earl Blumenauer B000574 | rep | OR | 1999-01-06 | 2001-01-03 | Democrat | 3 | |||||||||||||
41946 | 41946 | Sanford Bishop B000490 | rep | GA | 1999-01-06 | 2001-01-03 | Democrat | 2 | |||||||||||||
41917 | 41917 | Tammy Baldwin B001230 | rep | WI | 1999-01-06 | 2001-01-03 | Democrat | 2 | |||||||||||||
41905 | 41905 | Robert Aderholt A000055 | rep | AL | 1999-01-06 | 2001-01-03 | Republican | 4 | |||||||||||||
41850 | 41850 | Lindsey Graham G000359 | rep | SC | 1999-01-06 | 2001-01-03 | Republican | 3 | |||||||||||||
41818 | 41818 | Roger Wicker W000437 | rep | MS | 1999-01-06 | 2001-01-03 | Republican | 1 | |||||||||||||
41802 | 41802 | Debbie Stabenow S000770 | rep | MI | 1999-01-06 | 2001-01-03 | Democrat | 8 | |||||||||||||
41794 | 41794 | Bernard Sanders S000033 | rep | VT | 1999-01-06 | 2001-01-03 | Independent | 0 | Democrat | ||||||||||||
41782 | 41782 | Robert Menendez M000639 | rep | NJ | 1999-01-06 | 2001-01-03 | Democrat | 13 | |||||||||||||
41771 | 41771 | Dianne Feinstein F000062 | sen | CA | 1995-01-04 | 2001-01-03 | 1 | Democrat | |||||||||||||
41751 | 41751 | Benjamin Cardin C000141 | rep | MD | 1999-01-06 | 2001-01-03 | Democrat | 3 | |||||||||||||
41733 | 41733 | Sherrod Brown B000944 | rep | OH | 1999-01-06 | 2001-01-03 | Democrat | 13 | |||||||||||||
41677 | 41677 | Don Young Y000033 | rep | AK | 1999-01-06 | 2001-01-03 | Republican | 0 | |||||||||||||
41634 | 41634 | Alcee Hastings H000324 | rep | FL | 1999-01-06 | 2001-01-03 | Democrat | 23 | |||||||||||||
41530 | 41530 | Greg Walden W000791 | rep | OR | 1999-01-06 | 2001-01-03 | Republican | 2 | |||||||||||||
41519 | 41519 | Peter Visclosky V000108 | rep | IN | 1999-01-06 | 2001-01-03 | Democrat | 1 | |||||||||||||
41496 | 41496 | Mac Thornberry T000238 | rep | TX | 1999-01-06 | 2001-01-03 | Republican | 13 | |||||||||||||
41483 | 41483 | John Shimkus S000364 | rep | IL | 1999-01-06 | 2001-01-03 | Republican | 20 | |||||||||||||
41471 | 41471 | José Serrano S000248 | rep | NY | 1999-01-06 | 2001-01-03 | Democrat | 16 | |||||||||||||
41455 | 41455 | F. Sensenbrenner S000244 | rep | WI | 1999-01-06 | 2001-01-03 | Republican | 9 | |||||||||||||
41423 | 41423 | Collin Peterson P000258 | rep | MN | 1999-01-06 | 2001-01-03 | Democrat | 7 | |||||||||||||
41394 | 41394 | Nita Lowey L000480 | rep | NY | 1999-01-06 | 2001-01-03 | Democrat | 18 | |||||||||||||
41354 | 41354 | Peter King K000210 | rep | NY | 1999-01-06 | 2001-01-03 | Republican | 3 | |||||||||||||
41332 | 41332 | Eliot Engel E000179 | rep | NY | 1999-01-06 | 2001-01-03 | Democrat | 17 | |||||||||||||
41278 | 41278 | Tom Udall U000039 | rep | NM | 1999-01-06 | 2001-01-03 | Democrat | 3 | |||||||||||||
41235 | 41235 | John Lewis L000287 | rep | GA | 1999-01-06 | 2001-01-03 | Democrat | 5 | |||||||||||||
41210 | 41210 | John Isakson I000055 | rep | GA | 1999-01-06 | 2001-01-03 | Republican | 6 | |||||||||||||
41198 | 41198 | Elijah Cummings C000984 | rep | MD | 1999-01-06 | 2001-01-03 | Democrat | 7 | |||||||||||||
41176 | 41176 | Walter Jones J000255 | rep | NC | 1999-01-06 | 2001-01-03 | Republican | 3 | |||||||||||||
41119 | 41119 | Marshall Sanford S000051 | rep | SC | 1999-01-06 | 2001-01-03 | Republican | 1 | |||||||||||||
41061 | 41061 | Lamar Smith S000583 | rep | TX | 1999-01-06 | 2001-01-03 | Republican | 21 | |||||||||||||
41036 | 41036 | Paul Ryan R000570 | rep | WI | 1999-01-06 | 2001-01-03 | Republican | 1 | |||||||||||||
41026 | 41026 | Edward Royce R000487 | rep | CA | 1999-01-06 | 2001-01-03 | Republican | 39 | |||||||||||||
41003 | 41003 | Ileana Ros-Lehtinen R000435 | rep | FL | 1999-01-06 | 2001-01-03 | Republican | 18 | |||||||||||||
40979 | 40979 | Dana Rohrabacher R000409 | rep | CA | 1999-01-06 | 2001-01-03 | Republican | 45 | |||||||||||||
40925 | 40925 | Frank LoBiondo L000554 | rep | NJ | 1999-01-06 | 2001-01-03 | Republican | 2 | |||||||||||||
40913 | 40913 | Sander Levin L000263 | rep | MI | 1999-01-06 | 2001-01-03 | Democrat | 12 | |||||||||||||
40886 | 40886 | Sam Johnson J000174 | rep | TX | 1999-01-06 | 2001-01-03 | Republican | 3 | |||||||||||||
40850 | 40850 | Luis Gutiérrez G000535 | rep | IL | 1999-01-06 | 2001-01-03 | Democrat | 4 | |||||||||||||
40837 | 40837 | Gene Green G000410 | rep | TX | 1999-01-06 | 2001-01-03 | Democrat | 29 | |||||||||||||
40820 | 40820 | Bob Goodlatte G000289 | rep | VA | 1999-01-06 | 2001-01-03 | Republican | 6 | |||||||||||||
40807 | 40807 | Rodney Frelinghuysen F000372 | rep | NJ | 1999-01-06 | 2001-01-03 | Republican | 11 | |||||||||||||
40782 | 40782 | John Duncan D000533 | rep | TN | 1999-01-06 | 2001-01-03 | Republican | 2 | |||||||||||||
40749 | 40749 | Joseph Crowley C001038 | rep | NY | 1999-01-06 | 2001-01-03 | Democrat | 7 | |||||||||||||
40734 | 40734 | Michael Capuano C001037 | rep | MA | 1999-01-06 | 2001-01-03 | Democrat | 8 | |||||||||||||
40724 | 40724 | Robert Brady B001227 | rep | PA | 1999-01-06 | 2001-01-03 | Democrat | 1 |
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);