legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
473 rows where "start" is on date 1999-01-06 sorted by state
This data as json, copyable, CSV (advanced)
Suggested facets: state, end, party
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
36719 | 36719 | Frank Murkowski M001085 | sen | AK | 1999-01-06 | 2002-12-19 | 3 | Republican | |||||||||||||
41677 | 41677 | Don Young Y000033 | rep | AK | 1999-01-06 | 2001-01-03 | Republican | 0 | |||||||||||||
36852 | 36852 | H. Callahan C000052 | rep | AL | 1999-01-06 | 2001-01-03 | Republican | 1 | |||||||||||||
36966 | 36966 | Earl Hilliard H000621 | rep | AL | 1999-01-06 | 2001-01-03 | Democrat | 7 | |||||||||||||
37066 | 37066 | Bob Riley R000258 | rep | AL | 1999-01-06 | 2001-01-03 | Republican | 3 | |||||||||||||
37981 | 37981 | Robert Cramer C000868 | rep | AL | 1999-01-06 | 2001-01-03 | Democrat | 5 | |||||||||||||
38033 | 38033 | Terry Everett E000268 | rep | AL | 1999-01-06 | 2001-01-03 | Republican | 2 | |||||||||||||
39741 | 39741 | Spencer Bachus B000013 | rep | AL | 1999-01-06 | 2001-01-03 | Republican | 6 | |||||||||||||
41905 | 41905 | Robert Aderholt A000055 | rep | AL | 1999-01-06 | 2001-01-03 | Republican | 4 | |||||||||||||
43352 | 43352 | Richard Shelby S000320 | sen | AL | 1999-01-06 | 2005-01-03 | 3 | Republican | http://shelby.senate.gov/ | ||||||||||||
36591 | 36591 | Jay Dickey D000312 | rep | AR | 1999-01-06 | 2001-01-03 | Republican | 4 | |||||||||||||
36974 | 36974 | Asa Hutchinson H001014 | rep | AR | 1999-01-06 | 2001-01-03 | Republican | 3 | |||||||||||||
37774 | 37774 | Blanche Lincoln L000035 | sen | AR | 1999-01-06 | 2005-01-03 | 3 | Democrat | http://lincoln.senate.gov/ | ||||||||||||
38422 | 38422 | Robert Berry B000420 | rep | AR | 1999-01-06 | 2001-01-03 | Democrat | 1 | |||||||||||||
38826 | 38826 | Victor Snyder S000672 | rep | AR | 1999-01-06 | 2001-01-03 | Democrat | 2 | |||||||||||||
39834 | 39834 | Eni Faleomavaega F000010 | rep | AS | 1999-01-06 | 2001-01-03 | Democrat | 0 | |||||||||||||
37181 | 37181 | Robert Stump S001044 | rep | AZ | 1999-01-06 | 2001-01-03 | Republican | 3 | |||||||||||||
37677 | 37677 | John Hayworth H000413 | rep | AZ | 1999-01-06 | 2001-01-03 | Republican | 6 | |||||||||||||
37753 | 37753 | James Kolbe K000306 | rep | AZ | 1999-01-06 | 2001-01-03 | Republican | 5 | |||||||||||||
38802 | 38802 | John Shadegg S000275 | rep | AZ | 1999-01-06 | 2001-01-03 | Republican | 4 | |||||||||||||
40001 | 40001 | Ed Pastor P000099 | rep | AZ | 1999-01-06 | 2001-01-03 | Democrat | 2 | |||||||||||||
40489 | 40489 | Matt Salmon S000018 | rep | AZ | 1999-01-06 | 2001-01-03 | Republican | 1 | |||||||||||||
40650 | 40650 | John McCain M000303 | sen | AZ | 1999-01-06 | 2005-01-03 | 3 | Republican | http://mccain.senate.gov/ | ||||||||||||
36539 | 36539 | George Brown B000918 | rep | CA | 1999-01-06 | 1999-07-15 | Democrat | 42 | |||||||||||||
36549 | 36549 | Tom Campbell C000100 | rep | CA | 1999-01-06 | 2001-01-03 | Republican | 15 | |||||||||||||
36602 | 36602 | Julian Dixon D000373 | rep | CA | 1999-01-06 | 2001-01-03 | Democrat | 32 | |||||||||||||
36669 | 36669 | Steven Kuykendall K000357 | rep | CA | 1999-01-06 | 2001-01-03 | Republican | 36 | |||||||||||||
36695 | 36695 | Matthew Martínez M000206 | rep | CA | 1999-01-06 | 2001-01-03 | Republican | 31 | [ { "start": "1999-01-06", "end": "2000-07-27", "party": "Democrat" }, { "start": "2000-07-27", "end": "2001-01-03", "party": "Republican" } ] |
||||||||||||
36732 | 36732 | Ron Packard P000005 | rep | CA | 1999-01-06 | 2001-01-03 | Republican | 48 | |||||||||||||
36754 | 36754 | James Rogan R000386 | rep | CA | 1999-01-06 | 2001-01-03 | Republican | 27 | |||||||||||||
36876 | 36876 | Gary Condit C000670 | rep | CA | 1999-01-06 | 2001-01-03 | Democrat | 18 | |||||||||||||
36971 | 36971 | Stephen Horn H000789 | rep | CA | 1999-01-06 | 2001-01-03 | Republican | 38 | |||||||||||||
37317 | 37317 | Calvin Dooley D000424 | rep | CA | 1999-01-06 | 2001-01-03 | Democrat | 20 | |||||||||||||
37425 | 37425 | Robert Matsui M000249 | rep | CA | 1999-01-06 | 2001-01-03 | Democrat | 5 | |||||||||||||
37444 | 37444 | Doug Ose O000164 | rep | CA | 1999-01-06 | 2001-01-03 | Republican | 3 | |||||||||||||
37576 | 37576 | C. Cox C000830 | rep | CA | 1999-01-06 | 2001-01-03 | Republican | 47 | |||||||||||||
37584 | 37584 | Randall Cunningham C000994 | rep | CA | 1999-01-06 | 2001-01-03 | Republican | 51 | |||||||||||||
37836 | 37836 | Richard Pombo P000419 | rep | CA | 1999-01-06 | 2001-01-03 | Republican | 11 | |||||||||||||
37916 | 37916 | William Thomas T000188 | rep | CA | 1999-01-06 | 2001-01-03 | Republican | 21 | |||||||||||||
38009 | 38009 | John Doolittle D000429 | rep | CA | 1999-01-06 | 2001-01-03 | Republican | 4 | |||||||||||||
38124 | 38124 | Duncan Hunter H000981 | rep | CA | 1999-01-06 | 2001-01-03 | Republican | 52 | |||||||||||||
38189 | 38189 | Tom Lantos L000090 | rep | CA | 1999-01-06 | 2001-01-03 | Democrat | 12 | |||||||||||||
38246 | 38246 | Juanita Millender-McDonald M000714 | rep | CA | 1999-01-06 | 2001-01-03 | Democrat | 37 | |||||||||||||
38782 | 38782 | George Radanovich R000004 | rep | CA | 1999-01-06 | 2001-01-03 | Republican | 19 | |||||||||||||
38882 | 38882 | Ellen Tauscher T000057 | rep | CA | 1999-01-06 | 2001-01-03 | Democrat | 10 | |||||||||||||
39011 | 39011 | Bob Filner F000116 | rep | CA | 1999-01-06 | 2001-01-03 | Democrat | 50 | |||||||||||||
39151 | 39151 | Howard Berman B000410 | rep | CA | 1999-01-06 | 2001-01-03 | Democrat | 26 | |||||||||||||
39167 | 39167 | Brian Bilbray B000461 | rep | CA | 1999-01-06 | 2001-01-03 | Republican | 49 | |||||||||||||
39173 | 39173 | Mary Bono Mack B001228 | rep | CA | 1999-01-06 | 2001-01-03 | Republican | 44 | |||||||||||||
39262 | 39262 | David Dreier D000492 | rep | CA | 1999-01-06 | 2001-01-03 | Republican | 28 | |||||||||||||
39291 | 39291 | Elton Gallegly G000021 | rep | CA | 1999-01-06 | 2001-01-03 | Republican | 23 | |||||||||||||
39312 | 39312 | Walter Herger H000528 | rep | CA | 1999-01-06 | 2001-01-03 | Republican | 2 | |||||||||||||
39393 | 39393 | Jerry Lewis L000274 | rep | CA | 1999-01-06 | 2001-01-03 | Republican | 40 | |||||||||||||
39526 | 39526 | Fortney Stark S000810 | rep | CA | 1999-01-06 | 2001-01-03 | Democrat | 13 | |||||||||||||
39574 | 39574 | Lynn Woolsey W000738 | rep | CA | 1999-01-06 | 2001-01-03 | Democrat | 6 | |||||||||||||
39940 | 39940 | Howard McKeon M000508 | rep | CA | 1999-01-06 | 2001-01-03 | Republican | 25 | |||||||||||||
39954 | 39954 | Gary Miller M001139 | rep | CA | 1999-01-06 | 2001-01-03 | Republican | 41 | |||||||||||||
39974 | 39974 | George Miller M000725 | rep | CA | 1999-01-06 | 2001-01-03 | Democrat | 7 | |||||||||||||
40091 | 40091 | Henry Waxman W000215 | rep | CA | 1999-01-06 | 2001-01-03 | Democrat | 29 | |||||||||||||
40207 | 40207 | Barbara Boxer B000711 | sen | CA | 1999-01-06 | 2005-01-03 | 3 | Democrat | http://boxer.senate.gov/ | ||||||||||||
40268 | 40268 | Lois Capps C001036 | rep | CA | 1999-01-06 | 2001-01-03 | Democrat | 22 | |||||||||||||
40299 | 40299 | Sam Farr F000030 | rep | CA | 1999-01-06 | 2001-01-03 | Democrat | 17 | |||||||||||||
40468 | 40468 | Loretta Sanchez S000030 | rep | CA | 1999-01-06 | 2001-01-03 | Democrat | 46 | |||||||||||||
40515 | 40515 | Xavier Becerra B000287 | rep | CA | 1999-01-06 | 2001-01-03 | Democrat | 30 | |||||||||||||
40979 | 40979 | Dana Rohrabacher R000409 | rep | CA | 1999-01-06 | 2001-01-03 | Republican | 45 | |||||||||||||
41026 | 41026 | Edward Royce R000487 | rep | CA | 1999-01-06 | 2001-01-03 | Republican | 39 | |||||||||||||
42063 | 42063 | Ken Calvert C000059 | rep | CA | 1999-01-06 | 2001-01-03 | Republican | 43 | |||||||||||||
42366 | 42366 | Anna Eshoo E000215 | rep | CA | 1999-01-06 | 2001-01-03 | Democrat | 14 | |||||||||||||
42726 | 42726 | Barbara Lee L000551 | rep | CA | 1999-01-06 | 2001-01-03 | Democrat | 9 | |||||||||||||
42742 | 42742 | Zoe Lofgren L000397 | rep | CA | 1999-01-06 | 2001-01-03 | Democrat | 16 | |||||||||||||
42988 | 42988 | Grace Napolitano N000179 | rep | CA | 1999-01-06 | 2001-01-03 | Democrat | 34 | |||||||||||||
43078 | 43078 | Nancy Pelosi P000197 | rep | CA | 1999-01-06 | 2001-01-03 | Democrat | 8 | |||||||||||||
43184 | 43184 | Lucille Roybal-Allard R000486 | rep | CA | 1999-01-06 | 2001-01-03 | Democrat | 33 | |||||||||||||
43357 | 43357 | Brad Sherman S000344 | rep | CA | 1999-01-06 | 2001-01-03 | Democrat | 24 | |||||||||||||
43465 | 43465 | Mike Thompson T000460 | rep | CA | 1999-01-06 | 2001-01-03 | Democrat | 1 | |||||||||||||
43573 | 43573 | Maxine Waters W000187 | rep | CA | 1999-01-06 | 2001-01-03 | Democrat | 35 | |||||||||||||
36544 | 36544 | Ben Campbell C000077 | sen | CO | 1999-01-06 | 2005-01-03 | 3 | Republican | http://campbell.senate.gov/ | ||||||||||||
37114 | 37114 | Bob Schaffer S000112 | rep | CO | 1999-01-06 | 2001-01-03 | Republican | 4 | |||||||||||||
37436 | 37436 | Scott McInnis M000477 | rep | CO | 1999-01-06 | 2001-01-03 | Republican | 3 | |||||||||||||
37687 | 37687 | Joel Hefley H000444 | rep | CO | 1999-01-06 | 2001-01-03 | Republican | 5 | |||||||||||||
38344 | 38344 | Thomas Tancredo T000458 | rep | CO | 1999-01-06 | 2001-01-03 | Republican | 6 | |||||||||||||
39728 | 39728 | Mark Udall U000038 | rep | CO | 1999-01-06 | 2001-01-03 | Democrat | 2 | |||||||||||||
42285 | 42285 | Diana DeGette D000197 | rep | CO | 1999-01-06 | 2001-01-03 | Democrat | 1 | |||||||||||||
36630 | 36630 | Sam Gejdenson G000120 | rep | CT | 1999-01-06 | 2001-01-03 | Democrat | 2 | |||||||||||||
37011 | 37011 | James Maloney M000090 | rep | CT | 1999-01-06 | 2001-01-03 | Democrat | 5 | |||||||||||||
37610 | 37610 | Christopher Dodd D000388 | sen | CT | 1999-01-06 | 2005-01-03 | 3 | Democrat | http://dodd.senate.gov/ | ||||||||||||
37733 | 37733 | Nancy Johnson J000163 | rep | CT | 1999-01-06 | 2001-01-03 | Republican | 6 | |||||||||||||
38339 | 38339 | Christopher Shays S001144 | rep | CT | 1999-01-06 | 2001-01-03 | Republican | 4 | |||||||||||||
42301 | 42301 | Rosa DeLauro D000216 | rep | CT | 1999-01-06 | 2001-01-03 | Democrat | 3 | |||||||||||||
42697 | 42697 | John Larson L000557 | rep | CT | 1999-01-06 | 2001-01-03 | Democrat | 1 | |||||||||||||
43021 | 43021 | Eleanor Norton N000147 | rep | DC | 1999-01-06 | 2001-01-03 | Democrat | 0 | |||||||||||||
38482 | 38482 | Michael Castle C000243 | rep | DE | 1999-01-06 | 2001-01-03 | Republican | 0 | |||||||||||||
36553 | 36553 | Charles Canady C000107 | rep | FL | 1999-01-06 | 2001-01-03 | Republican | 12 | |||||||||||||
36616 | 36616 | Tillie Fowler F000328 | rep | FL | 1999-01-06 | 2001-01-03 | Republican | 4 | |||||||||||||
36646 | 36646 | Bob Graham G000352 | sen | FL | 1999-01-06 | 2005-01-03 | 3 | Democrat | http://graham.senate.gov/ | ||||||||||||
36705 | 36705 | Bill McCollum M000350 | rep | FL | 1999-01-06 | 2001-01-03 | Republican | 8 | |||||||||||||
37020 | 37020 | Carrie Meek M000628 | rep | FL | 1999-01-06 | 2001-01-03 | Democrat | 17 | |||||||||||||
37025 | 37025 | Dan Miller M000720 | rep | FL | 1999-01-06 | 2001-01-03 | Republican | 13 | |||||||||||||
37111 | 37111 | Joe Scarborough S000106 | rep | FL | 1999-01-06 | 2001-01-03 | Republican | 1 | |||||||||||||
37186 | 37186 | Karen Thurman T000253 | rep | FL | 1999-01-06 | 2001-01-03 | Democrat | 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);