-
Notifications
You must be signed in to change notification settings - Fork 34
/
Copy pathsenate.sql
101 lines (101 loc) · 165 KB
/
senate.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
TRUNCATE TABLE `senate`;
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("AK", "S001198", "02290", "412665", "N00035774", null, "republican", "active", "false", "false", "false", "false", "II", "male", "white", "Dan Sullivan", "dan-sullivan", "1964-11-13", "2015-01-03", "2021-01-03", "38.892839", "-77.004356", "702 Hart Senate Office Building Washington DC 20510", "http://www.sullivan.senate.gov", "202-224-3004", "https://twitter.com/SenDanSullivan", "https://www.facebook.com/SenDanSullivan", "https://cdn.civil.services/senate/headshots/512x512/dan-sullivan.jpg", "Dan Sullivan is a Senator from Alaska; born in Fairview Park, Cuyahoga County, Ohio, November 13, 1964; graduated Culver Military Academy, Culver, Ind., 1983; B.A., Harvard University, 1987; M.F.S. and J.D., Georgetown University, 1993; United States Marine Corps 1993-1997; United States Marine Corps Reserves 1997-present, attaining the rank of lieutenant colonel; lawyer; White House aide and director on the National Security Council staff during the George W. Bush administration; assistant U.S. secretary of state for economic, energy and business affairs 2006-2009; attorney general of Alaska 2009-2010; Commissioner of Alaska Department of Natural Resources 2010-2013; elected as a Republican to the United States Senate in 2014 for the term ending January 3, 2021.");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("AK", "M001153", "01694", "300075", "N00026050", "15841", "republican", "active", "false", "false", "false", "false", "III", "female", "white", "Lisa Murkowski", "lisa-murkowski", "1957-05-22", "2002-12-20", "2023-01-03", "38.892839", "-77.004356", "709 Hart Senate Office Building Washington DC 20510", "http://www.murkowski.senate.gov", "202-224-6665", "https://twitter.com/LisaMurkowski", "https://www.facebook.com/SenLisaMurkowski", "https://cdn.civil.services/senate/headshots/512x512/lisa-murkowski.jpg", "Lisa Murkowski (daughter of Frank Hughes Murkowski), a Senator from Alaska; born in Ketchikan, Alaska, on May 22, 1957; attended public schools in Fairbanks, AK; attended Willamette University in Salem, Oregon, 1975-1977; B.A. in Economics, Georgetown University 1980; J.D., Willamette College of Law 1985; attorney; member, Alaska Bar Association; Anchorage District Court attorney 1987-1989; private practice 1989-1996; Mayor's Task Force on the Homeless 1990-1991; Anchorage Equal Rights Commission 1997-1998; Alaska State house of representatives 1999-2002; appointed to the U.S. Senate on December 20, 2002, to fill the vacancy caused by the resignation of her father, Frank H. Murkowski; elected to the U.S. Senate in 2004; unsuccessful candidate for renomination in 2010, but subsequently elected as a write-in candidate in the November 2, 2010, general election, for the term ending January 3, 2017; Republican Conference vice-chair (2009-2010); chair, Committee on Energy and Natural Resources (One Hundred Fourteenth Congress).");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("AL", "S001141", "01548", "300088", "N00003062", "443", "republican", "active", "false", "false", "false", "false", "II", "male", "white", "Jefferson Sessions", "jefferson-sessions", "1946-12-24", "1997-01-03", "2021-01-03", "38.892542", "-77.007415", "326 Russell Senate Office Building Washington DC 20510", "http://www.sessions.senate.gov", "202-224-4124", "https://twitter.com/SenatorSessions", "https://www.facebook.com/jeffsessions", "https://cdn.civil.services/senate/headshots/512x512/jefferson-sessions.jpg", "Jefferson Sessions, a Senator from Alabama; born in Hybart, Ala., December 24, 1946; attended the public schools; graduated from Huntingdon College, Montgomery 1969; graduated from University of Alabama School of Law, Tuscaloosa 1973; admitted to the Alabama bar in 1973, and engaged in the practice of law in Russellville 1973-1975; served in the U.S. Army Reserves, attaining the rank of captain 1973-1977; practiced law in Mobile 1977-1981; United States Attorney for the Southern District of Alabama 1981-1993; Alabama Attorney General 1994-1996; elected as a Republican to the United States Senate in 1996; reelected in 2002, 2008, and again in 2014 for the term ending January 3, 2021.");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("AL", "S000320", "01049", "300089", "N00009920", "53266", "republican", "active", "false", "false", "false", "false", "III", "male", "white", "Richard Shelby", "richard-shelby", "1934-05-06", "1987-01-03", "2023-01-03", "38.892542", "-77.007415", "304 Russell Senate Office Building Washington DC 20510", "http://www.shelby.senate.gov", "202-224-5744", "https://twitter.com/SenShelby", "https://www.facebook.com/RichardShelby", "https://cdn.civil.services/senate/headshots/512x512/richard-shelby.jpg", "Richard Shelby, a Senator and a Representative from Alabama; born in Birmingham, Ala., May 6, 1934; attended the public schools; graduated, University of Alabama 1957; graduated, University of Alabama School of Law 1963; admitted to the Alabama bar in 1961 and commenced practice in Tuscaloosa; city prosecutor, Tuscaloosa 1963-1971; United States Commissioner, Northern District of Alabama 1966-1970; Member, Alabama State Senate 1970-1978; elected as a Democrat to the Ninety-sixth Congress in 1978; reelected to the three succeeding Congresses and served from January 3, 1979, to January 3, 1987; was not a candidate for reelection to the House of Representatives in 1986, but was elected to the United States Senate; reelected in 1992, 1998, 2004, and again in 2010 for the term ending January 3, 2017; changed from the Democratic to the Republican Party in 1994; Chair, Select Committee on Intelligence (One Hundred Fifth and One Hundred Sixth Congresses, One Hundred Seventh Congress [January 20, 2001-June 6, 2001]), Committee on Banking, Housing and Urban Affairs (One Hundred Eighth and One Hundred Ninth Congresses, One Hundred Fourteenth Congress).");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("AR", "C001095", "02098", "412508", "N00033363", "135651", "republican", "active", "false", "false", "false", "false", "II", "male", "white", "Tom Cotton", "tom-cotton", "1977-05-13", "2015-01-03", "2021-01-03", "38.892542", "-77.007415", "124 Russell Senate Office Building Washington DC 20510", "http://www.cotton.senate.gov", "202-224-2353", "https://twitter.com/SenTomCotton", "https://www.facebook.com/SenatorTomCotton", "https://cdn.civil.services/senate/headshots/512x512/tom-cotton.jpg", "Tom Cotton, a Senator and a Representative from Arkansas; born in Dardanelle, Yell County, Ark., May 13, 1977; A.B., Harvard University, Cambridge, Mass., 1998; attended Claremont Graduate University, Claremont, Calif., 1998-1999; J.D., Harvard University, Cambridge, Mass., 2002; United States Army, 2004-2009; clerk, U.S. Court of Appeals, 2002-2003; lawyer, private practice; management consultant; farmer; elected as a Republican to the One Hundred Thirteenth Congress (January 3, 2013-January 3, 2015); was not a candidate for reelection to the House of Representatives but was elected as a Republican to the United States Senate in 2014 for the term ending January 3, 2021.");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("AR", "B001236", "01687", "400040", "N00013873", "27958", "republican", "active", "false", "false", "false", "false", "III", "male", "white", "John Boozman", "john-boozman", "1950-12-10", "2011-01-03", "2023-01-03", "38.892839", "-77.004356", "141 Hart Senate Office Building Washington DC 20510", "http://www.boozman.senate.gov", "202-224-4843", "https://twitter.com/JohnBoozman", "https://www.facebook.com/JohnBoozman", "https://cdn.civil.services/senate/headshots/512x512/john-boozman.jpg", "John Boozman, a Senator and a Representative from Arkansas; born in Shreveport, La., December 10, 1950; graduated from Northside High School, Fort Smith, Ark.; attended the University of Arkansas, Fayetteville, Ark., 1969-1972; graduated Southern College of Optometry, 1977; optometrist; business owner; rancher; member of the Rogers, Ark., school board; elected as a Republican to the One Hundred Seventh Congress by special election to fill the vacancy caused by the resignation of United States Representative Asa Hutchinson; reelected to the four succeeding Congresses (November 20, 2001-January 3, 2011); was not a candidate for reelection to the House of Representatives but was elected as a Republican to the United States Senate in 2010 for the term ending January 3, 2017.");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("AZ", "F000444", "01633", "400134", "N00009573", "28128", "republican", "active", "false", "false", "false", "false", "I", "male", "white", "Jeff Flake", "jeff-flake", "1962-12-31", "2013-01-03", "2019-01-03", "38.892542", "-77.007415", "413 Russell Senate Office Building Washington DC 20510", "http://www.flake.senate.gov", "202-224-4521", "https://twitter.com/JeffFlake", "https://www.facebook.com/senatorjeffflake", "https://cdn.civil.services/senate/headshots/512x512/jeff-flake.jpg", "Jeff Flake, a Senator and a Representative from Arizona; born in Snowflake, Navajo County, Ariz., December 31, 1962; graduated from Brigham Young University, Provo, Utah, 1986; M.A. Brigham Young University, Provo, Utah, 1987; elected as a Republican to the One Hundred Seventh and to the five succeeding Congresses (January 3, 2001-January 3, 2013); was not a candidate for reelection to the House of Representatives but was elected as a Republican to the United States Senate in 2012 for the term ending January 3, 2019.");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("AZ", "M000303", "00754", "300071", "N00006424", "53270", "republican", "active", "false", "false", "false", "false", "III", "male", "white", "John McCain", "john-mccain", "1936-08-29", "1987-01-03", "2023-01-03", "38.892542", "-77.007415", "218 Russell Senate Office Building Washington DC 20510", "http://www.mccain.senate.gov", "202-224-2235", "https://twitter.com/SenJohnMcCain", "https://www.facebook.com/johnmccain", "https://cdn.civil.services/senate/headshots/512x512/john-mccain.jpg", "John McCain, a Senator and a Representative from Arizona; born in Panama Canal Zone, August 29, 1936; attended schools in Alexandria, Va.; graduated United States Naval Academy, Annapolis, Md. 1958, and the National War College, Washington, D.C. 1973; pilot, United States Navy 1958-1981, prisoner of war in Vietnam 1967-1973; received numerous awards, including the Silver Star, Legion of Merit, Purple Heart, and Distinguished Flying Cross; elected as a Republican in 1982 to the Ninety-eighth Congress; reelected to the Ninety-ninth Congress in 1984 and served from January 3, 1983, to January 3, 1987; elected to the United States Senate in 1986; reelected in 1992, 1998, 2004, and again in 2010 for the term ending January 3, 2017; chair, Committee on Indian Affairs (One Hundred Fourth Congress; One Hundred Ninth Congress), Committee on Commerce, Science, and Transportation (One Hundred Fifth through One Hundred Sixth Congresses, One Hundred Seventh Congress [January 20, 2001-June 6, 2001], One Hundred Eighth Congress), Committee on Armed Services (One Hundred Fourteenth Congress); was an unsuccessful candidate for the Republican presidential nomination in 2000; was an unsuccessful Republican nominee for President of the United States in 2008.");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("CA", "F000062", "01332", "300043", "N00007364", "53273", "democrat", "active", "false", "false", "false", "false", "I", "female", "white", "Dianne Feinstein", "dianne-feinstein", "1933-06-22", "1992-11-10", "2019-01-03", "38.892839", "-77.004356", "331 Hart Senate Office Building Washington DC 20510", "http://www.feinstein.senate.gov", "202-224-3841", "https://twitter.com/SenFeinstein", "https://www.facebook.com/senatorfeinstein", "https://cdn.civil.services/senate/headshots/512x512/dianne-feinstein.jpg", "Dianne Feinstein, a Senator from California; born in San Francisco, Calif., June 22, 1933; attended the San Francisco public schools and graduated from the Convent of the Sacred Heart High School 1951; graduated, Stanford University 1955; Member, California Women's Board of Terms and Parole 1960-1966; Member, San Francisco Board of Supervisors 1970-1978, serving as president 1970-1971, 1974-1975, 1978; mayor of San Francisco 1978-1988; director, Bank of California 1988-1989; co-chair, San Francisco Education Fund's Permanent Fund 1988-1989; unsuccessful candidate for Governor of California 1990; elected in a special election on November 3, 1992, as a Democrat to the United States Senate to fill the term left vacant by the resignation of Pete Wilson; took office on November 4, 1992, and took the oath of office on November 10, 1992; reelected in 1994, 2000, 2006, and again in 2012 for the term ending January 3, 2019; chair, Committee on Rules and Administration (One Hundred Tenth Congress), Select Committee on Intelligence (One Hundred Eleventh to One Hundred Thirteenth Congresses).");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("CA", "H001075", null, "412678", null, "120012", "democrat", "active", "false", "false", "false", "false", "III", "female", "asian-american", "Kamala Harris", "kamala-harris", "1964-10-20", "2017-01-03", "2023-01-03", "38.892839", "-77.004356", "112 Hart Senate Office Building Washington DC 20510", "http://www.harris.senate.gov", "202-224-3553", "https://twitter.com/kamalaharris", "https://www.facebook.com/kamalaharris", "https://cdn.civil.services/senate/headshots/512x512/kamala-harris.jpg", "Kamala Harris, a Senator from California; born in Oakland, Calif., October 20, 1964; B.A., Howard University, 1986; J.D., University of California, Hastings College of the Law, 1989; admitted to the California bar in 1990; deputy district attorney, Alameda County, Calif., 1990-1998; managing attorney, San Francisco District Attorney’s Office; chief of the San Francisco City Attorney’s Division on Children and Families; district attorney of San Francisco 2004-2011; attorney general of California 2011-2016; elected as a Democrat to the United States Senate in 2016 for the term ending January 3, 2023.");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("CO", "G000562", "01998", "412406", "N00030780", "30004", "republican", "active", "false", "false", "false", "false", "II", "male", "white", "Cory Gardner", "cory-gardner", "1974-08-22", "2015-01-03", "2021-01-03", "38.892542", "-77.007415", "354 Russell Senate Office Building Washington DC 20510", "http://www.gardner.senate.gov", "202-224-5941", "https://twitter.com/SenCoryGardner", "https://www.facebook.com/SenCoryGardner", "https://cdn.civil.services/senate/headshots/512x512/cory-gardner.jpg", "Cory Gardner, a Senator and a Representative from Colorado; born in Yuma, Yuma County, Colo., on August 22, 1974; graduated from Yuma High School, Yuma, Colo., 1993; B.A., Colorado State University, Fort Collins, Colo., 1997; J.D., University of Colorado, Boulder, Colo., 2001; agricultural advocate; staff, United States Senator Wayne Allard of Colorado, 2002-2005; member of the Colorado state house of representatives, 2005-2010; elected as a Republican to the One Hundred Twelfth and to the succeeding Congress (January 3, 2011-January 3, 2015); was not a candidate for reelection to the House of Representatives but was elected as a Republican to the United States Senate in 2014 for the term ending January 3, 2021.");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("CO", "B001267", "01965", "412330", "N00030608", "110942", "democrat", "active", "false", "false", "false", "false", "III", "male", "white", "Michael Bennet", "michael-bennet", "1964-11-28", "2009-01-21", "2023-01-03", "38.892542", "-77.007415", "261 Russell Senate Office Building Washington DC 20510", "http://www.bennet.senate.gov", "202-224-5852", "https://twitter.com/SenBennetCo", "https://www.facebook.com/senatorbennet", "https://cdn.civil.services/senate/headshots/512x512/michael-bennet.jpg", "Michael Bennet, a Senator from Colorado; born in New Delhi, India, November 28, 1964; B.A., Wesleyan University, Middletown, Conn., 1987; J.D., Yale Law School, 1993, editor-in-chief of the Yale Law Journal; counsel to U.S. deputy attorney general 1995-1997; special assistant U.S. attorney, Conn., 1997; managing director, Anschutz Investment Co. 1997-2003; chief of staff to Mayor of Denver, Colo., 2003-2005; Superintendent, Denver Public Schools 2005-2009; appointed January 21, 2009, to the United States Senate for the term ending January 3, 2011, to fill the vacancy caused by the resignation of Kenneth L. Salazar; took the oath of office on January 22, 2009; elected to the U.S. Senate in 2010 for the term ending January 3, 2017; chair, Democratic Senatorial Campaign Committee (2013-2014).");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("CT", "M001169", "01837", "412194", "N00027566", "17189", "democrat", "active", "false", "false", "false", "false", "I", "male", "white", "Christopher Murphy", "christopher-murphy", "1973-08-03", "2013-01-03", "2019-01-03", "38.892839", "-77.004356", "136 Hart Senate Office Building Washington DC 20510", "http://www.murphy.senate.gov", "202-224-4041", "https://twitter.com/ChrisMurphyCT", "https://www.facebook.com/chrismurphyct", "https://cdn.civil.services/senate/headshots/512x512/christopher-murphy.jpg", "Christopher Murphy, a Senator and a Representative from Connecticut; born in White Plains, Westchester County, N.Y., August 3, 1973; B.A., Williams College, Williamstown, Mass., 1996; attended Exeter College, Oxford, England, 1994-1995; J.D., University of Connecticut, Hartford, Conn., 2002; lawyer, private practice; Southington, Conn., planning and zoning commission, 1997-1999; member of the Connecticut state house of representatives, 1999-2003; member of the Connecticut state senate, 2003-2006; elected as a Democrat to the One Hundred Tenth and to the two succeeding Congresses (January 3, 2007-January 3, 2013); was not a candidate for reelection to the House of Representatives but was elected as a Democrat to the United States Senate in 2012 for the term ending January 3, 2019.");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("CT", "B001277", "02076", "412490", "N00031685", "1568", "democrat", "active", "false", "false", "false", "false", "III", "male", "white", "Richard Blumenthal", "richard-blumenthal", "1946-02-13", "2011-01-05", "2023-01-03", "38.892839", "-77.004356", "706 Hart Senate Office Building Washington DC 20510", "http://www.blumenthal.senate.gov", "202-224-2823", "https://twitter.com/SenBlumenthal", "https://www.facebook.com/SenBlumenthal", "https://cdn.civil.services/senate/headshots/512x512/richard-blumenthal.jpg", "Richard Blumenthal, a Senator from Connecticut; born in Brooklyn, N.Y., February 13, 1946; graduated Harvard University, B.A., 1967; attended Cambridge University, 1967-1968; graduated Yale University, J.D., 1973; editor-in-chief of the Yale Law Journal; served in the United States Marine Corps Reserves 1970-1976; White House aide 1969-1970; law clerk to United States Supreme Court Justice Harry A. Blackmun 1974-1975; administrative assistant to Senator Abraham Ribicoff 1975-1976; United States Attorney for Connecticut 1977-1981; lawyer; member of the Connecticut state house of representatives 1984-1987; member of the Connecticut state senate 1987-1990; attorney general of Connecticut 1991-2010; elected as a Democrat to the United States Senate in 2010 for the term ending January 3, 2017.");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("DE", "C000174", "00179", "300019", "N00012508", "22421", "democrat", "active", "false", "false", "false", "false", "I", "male", "white", "Thomas Carper", "thomas-carper", "1947-01-23", "2001-01-03", "2019-01-03", "38.892839", "-77.004356", "513 Hart Senate Office Building Washington DC 20510", "http://www.carper.senate.gov", "202-224-2441", "https://twitter.com/SenatorCarper", "https://www.facebook.com/tomcarper", "https://cdn.civil.services/senate/headshots/512x512/thomas-carper.jpg", "Thomas Carper, a Senator and a Representative from Delaware; born in Beckley, Raleigh County, W.Va., January 23, 1947; attended public schools; graduated, Whetstone High School, Columbus, Ohio 1964; B.A., Ohio State University, Columbus 1968; University of Delaware, Newark, M.B.A. 1975; served in the United States Navy 1968-1973; Naval Reserve, commander, 1973-1991; Delaware State Treasurer 1976-1983; elected as a Democrat to the Ninety-eighth and to the four succeeding Congresses (January 3, 1983-January 3, 1993); Governor of Delaware 1993-2001; chairman of the National Governors Association 1998-1999; elected to the United States Senate in 2000 for term commencing January 3, 2001; reelected in 2006 and again in 2012 for the term ending January 3, 2019; chair, Committee on Homeland Security and Governmental Affairs (One Hundred Thirteenth Congress).");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("DE", "C001088", "01984", "412390", "N00031820", "122834", "democrat", "active", "false", "false", "false", "false", "II", "male", "white", "Chris Coons", "chris-coons", "1963-09-09", "2010-11-15", "2021-01-03", "38.892542", "-77.007415", "127A Russell Senate Office Building Washington DC 20510", "http://www.coons.senate.gov", "202-224-5042", "https://twitter.com/SenCoonsOffice", "https://www.facebook.com/senatorchriscoons", "https://cdn.civil.services/senate/headshots/512x512/chris-coons.jpg", "Chris Coons, a Senator from Delaware; born on September 9, 1963, in Greenwich, Conn.; B.A., Amherst College, 1985; J.D., Yale University Law School, 1992; M.A.R., Yale Divinity School, 1992; worked in the non-profit sector; attorney; served as president of the New Castle County Council 2001-2005; County Executive of New Castle County 2005-2010; elected as a Democrat to the United States Senate in the November 2, 2010, special election to the term ending January 3, 2015, a seat previously held by appointed Senator Edward E. Kaufman, and took the oath of office on November 15, 2010; reelected in 2014 for the term ending January 3, 2021.");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("FL", "N000032", "00859", "300078", "N00009926", "1606", "democrat", "active", "false", "false", "false", "false", "I", "male", "white", "Bill Nelson", "bill-nelson", "1942-09-29", "2001-01-03", "2019-01-03", "38.892839", "-77.004356", "716 Hart Senate Office Building Washington DC 20510", "http://www.billnelson.senate.gov", "202-224-5274", "https://twitter.com/SenBillNelson", "https://www.facebook.com/billnelson", "https://cdn.civil.services/senate/headshots/512x512/bill-nelson.jpg", "Bill Nelson, a Senator and a Representative from Florida; born in Miami, Dade County, Fla., September 29, 1942; attended the Brevard County public schools; graduated from Melbourne High School 1960; B.A., Yale University 1965; J.D., University of Virginia School of Law 1968; admitted to the Florida bar in 1968 and commenced practice in Melbourne in 1970; served in United States Army Reserve 1965-1971; United States Army, active duty, 1968-1970, achieving rank of captain; legislative assistant to Governor Reubin Askew 1971; elected to Florida State house of representatives in 1972 and reelected in 1974 and 1976; elected as a Democrat to the Ninety-sixth and to the five succeeding Congresses (January 3, 1979-January 3, 1991); was not a candidate for reelection in 1990 to the House of Representatives, but was a candidate for nomination for governor of Florida; crewmember on the twenty-fourth flight of the Space Shuttle Columbia, January 12-18, 1986; Florida treasurer and insurance commissioner 1995-2000; elected to the United States Senate in 2000 for the term commencing January 3, 2001; reelected in 2006 and again in 2012 for the term ending January 3, 2019; Chair, Special Committee on Aging (One Hundred Thirteenth Congress).");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("FL", "R000595", "02084", "412491", "N00030612", "1601", "republican", "active", "false", "false", "false", "false", "III", "male", "hispanic-american", "Marco Rubio", "marco-rubio", "1971-05-28", "2011-01-03", "2023-01-03", "38.892542", "-77.007415", "284 Russell Senate Office Building Washington DC 20510", "http://www.rubio.senate.gov", "202-224-3041", "https://twitter.com/SenRubioPress", "https://www.facebook.com/SenatorMarcoRubio", "https://cdn.civil.services/senate/headshots/512x512/marco-rubio.jpg", "Marco Rubio, a Senator from Florida; born in Miami, Fla., May 28, 1971; graduated University of Florida, B.S., 1993; graduated University of Miami, J.D., 1996; lawyer; West Miami City Commission 1998-2000; member of the Florida house of representatives 2000-2008; majority leader 2003-2006; speaker 2006-2008; elected as a Republican to the United States Senate for the term ending January 3, 2017.");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("GA", "P000612", "02286", "412666", "N00035516", null, "republican", "active", "false", "false", "false", "false", "II", "male", "white", "David Perdue", "david-perdue", "1949-12-10", "2015-01-03", "2021-01-03", "38.892542", "-77.007415", "383 Russell Senate Office Building Washington DC 20510", "http://www.perdue.senate.gov", "202-224-3521", "https://twitter.com/sendavidperdue", "https://www.facebook.com/SenatorDavidPerdue", "https://cdn.civil.services/senate/headshots/512x512/david-perdue.jpg", "David Perdue, a Senator from Georgia; born in Macon, Bibb County, Ga., December 10, 1949; B.S., Georgia Institute of Technology, 1972; M.S., Georgia Institute of Technology, 1976; management consultant; company executive; elected as a Republican to the United States Senate in 2014 for the term ending January 3, 2021.");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("GA", "I000055", "01608", "400194", "N00002593", "1721", "republican", "active", "false", "false", "false", "false", "III", "male", "white", "John Isakson", "john-isakson", "1944-12-28", "2005-01-03", "2023-01-03", "38.892542", "-77.007415", "131 Russell Senate Office Building Washington DC 20510", "http://www.isakson.senate.gov", "202-224-3643", "https://twitter.com/SenatorIsakson", "https://www.facebook.com/isakson", "https://cdn.civil.services/senate/headshots/512x512/john-isakson.jpg", "John Isakson, a Senator and a Representative from Georgia; born in Atlanta, Fulton County, Ga., December 28, 1944; graduated from the University of Georgia, Athens, Ga., 1966; served in the Georgia Air National Guard 1966-1972; member of the Georgia state general assembly, 1976-1990; unsuccessful candidate for election as Governor of Georgia 1990; member of the Georgia state senate 1993-1996; unsuccessful candidate for election to the United States Senate in 1996; chair of the Georgia board of education 1996; elected as a Republican to the One Hundred Sixth Congress by special election to fill the vacancy created when United States Representative Newt Gingrich did not take his seat in the One Hundred Sixth Congress; reelected to the two succeeding Congresses (February 23, 1999-January 3, 2005); was not a candidate for reelection to the House of Representatives, but was elected to the United States Senate in 2004; reelected in 2010 for the term ending January 3, 2017; chair, Committee on Veterans' Affairs (One Hundred Fourteenth Congress), Select Committee on Ethics (One Hundred Fourteenth Congress).");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("HI", "H001042", "01844", "412200", "N00028139", "1677", "democrat", "active", "false", "false", "false", "false", "I", "female", "asian-american", "Mazie Hirono", "mazie-hirono", "1947-11-03", "2013-01-03", "2019-01-03", "38.892839", "-77.004356", "330 Hart Senate Office Building Washington DC 20510", "http://www.hirono.senate.gov", "202-224-6361", "https://twitter.com/MazieHirono", "https://www.facebook.com/senatorhirono", "https://cdn.civil.services/senate/headshots/512x512/mazie-hirono.jpg", "Mazie Hirono, a Senator and a Representative from Hawaii; born in Fukushima, Japan, November 3, 1947; graduated from Kaimuki High School, Honolulu, Hawaii; B.A., University of Hawaii, Manoa, Hawaii, 1970; J.D., Georgetown University, Washington, D.C., 1978; lawyer, private practice; member of the Hawaii state house of representatives, 1981-1994; Hawaii lieutenant governor, 1994-2002; elected as a Democrat to the One Hundred Tenth and to the two succeeding Congresses (January 3, 2007-January 3, 2013); was not a candidate for reelection to the House of Representatives but was elected as a Democrat to the United States Senate in 2012 for the term ending January 3, 2019.");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("HI", "S001194", "02173", "412507", "N00028138", "17852", "democrat", "active", "false", "false", "false", "false", "III", "male", "white", "Brian Schatz", "brian-schatz", "1972-10-20", "2012-12-26", "2023-01-03", "38.892839", "-77.004356", "722 Hart Senate Office Building Washington DC 20510", "http://www.schatz.senate.gov", "202-224-3934", "https://twitter.com/SenBrianSchatz", "https://www.facebook.com/SenBrianSchatz", "https://cdn.civil.services/senate/headshots/512x512/brian-schatz.jpg", "Brian Schatz, a Senator from Hawaii; born in Ann Arbor, Washtenaw County, Mich., October 20, 1972; attended Punahou School in Honolulu, Hawaii; B.A. Pomona College 1994; teacher; member of the Hawaii state house of representatives, 1998-2006; CEO, Helping Hands Hawaii, 2002-2010; Chairman, Democratic Party of Hawaii, 2008-2011; Hawaii lieutenant governor, 2010-2012; appointed as a Democrat to the United States Senate on December 26, 2012, to fill the vacancy caused by the death of Daniel Inouye, and took the oath of office on December 27, 2012; elected in 2014 in a special election for the term ending January 3, 2017.");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("IA", "G000386", "00457", "300048", "N00001758", "53293", "republican", "active", "false", "false", "false", "false", "III", "male", "white", "Charles Grassley", "charles-grassley", "1933-09-17", "1981-01-03", "2023-01-03", "38.892839", "-77.004356", "135 Hart Senate Office Building Washington DC 20510", "http://www.grassley.senate.gov", "202-224-3744", "https://twitter.com/ChuckGrassley", "https://www.facebook.com/grassley", "https://cdn.civil.services/senate/headshots/512x512/charles-grassley.jpg", "Charles Grassley, a Senator and a Representative from Iowa; born in New Hartford, Butler County, Iowa, September 17, 1933; attended the public schools; graduated, University of Northern Iowa, Cedar Falls 1955; received a graduate degree from the same university in 1956; pursued graduate work, University of Iowa, Iowa City 1957-1958; engaged in agriculture; part-time university instructor; member, Iowa house of representatives 1959-1974; elected in 1974 as a Republican to the Ninety-fourth Congress; reelected to the Ninety-fifth and Ninety-sixth Congresses (January 3, 1975-January 3, 1981); was not a candidate in 1980 for reelection to the House of Representatives, but was elected to the Senate in 1980; reelected in 1986, 1992, 1998, 2004 and again in 2010 for the term ending January 3, 2017; Chair, Special Committee on Aging (One Hundred Fifth Congress), Committee on Finance (One Hundred Seventh Congress [January 20 to June 6, 2001], One Hundred Eighth and One Hundred Ninth Congresses), Committee on the Judiciary (One Hundred Fourteenth Congress).");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("IA", "E000295", "02283", "412667", "N00035483", null, "republican", "active", "false", "false", "false", "false", "II", "female", "white", "Joni Ernst", "joni-ernst", "1970-07-01", "2015-01-03", "2021-01-03", "38.892542", "-77.007415", "111 Russell Senate Office Building Washington DC 20510", "http://www.ernst.senate.gov", "202-224-3254", "https://twitter.com/SenJoniErnst", "https://www.facebook.com/senjoniernst", "https://cdn.civil.services/senate/headshots/512x512/joni-ernst.jpg", "Joni Ernst, a Senator from Iowa; born in Red Oak, Montgomery County, Iowa, July 1, 1970; B.A., Iowa State University, 1992; M.P.A., Columbus College (now Columbus State University), Columbus, Ga., 1995; United States Army Reserves, 1993-2001; Iowa Army National Guard, 2001-present, attaining the rank of lieutenant colonel; auditor of Montgomery County, Iowa, 2005-2011; member of the Iowa state Senate 2011-2014; elected as a Republican to the United States Senate in 2014 for the term ending January 3, 2021.");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("ID", "R000584", "01896", "412322", "N00029441", "2919", "republican", "active", "false", "false", "false", "false", "II", "male", "white", "James Risch", "james-risch", "1943-05-03", "2009-01-03", "2021-01-03", "38.892542", "-77.007415", "483 Russell Senate Office Building Washington DC 20510", "http://www.risch.senate.gov", "202-224-2752", "https://twitter.com/SenatorRisch", "https://www.facebook.com/SenatorRisch", "https://cdn.civil.services/senate/headshots/512x512/james-risch.jpg", "James Risch, a Senator from Idaho; born in Milwaukee, Wis., May 3, 1943; B.A., attended the University of Wisconsin, Milwaukee, 1961-1963; B.S. in Forestry, University of Idaho, 1965; J.D., University of Idaho College of Law, 1968; Ada County, Idaho, prosecuting attorney, 1970-1974; Idaho State Senator, 1974-1989 and 1995-2003, serving as majority leader (1976-1982), and as president pro tempore (1982-1989); lieutenant governor of Idaho, 2003-2006 and 2007-2009; governor of Idaho, 2006; elected as a Republican to the United States Senate in 2008; reelected in 2014 for the term ending January 3, 2021.");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("ID", "C000880", "00250", "300030", "N00006267", "26830", "republican", "active", "false", "false", "false", "false", "III", "male", "white", "Michael Crapo", "michael-crapo", "1951-05-20", "1999-01-03", "2023-01-03", "38.892947", "-77.075686", "239 Dirksen Senate Office Building Washington DC 20510", "http://www.crapo.senate.gov", "202-224-6142", "https://twitter.com/MikeCrapo", "https://www.facebook.com/mikecrapo", "https://cdn.civil.services/senate/headshots/512x512/michael-crapo.jpg", "Michael Crapo, a Senator and a Representative from Idaho; born in Idaho Falls, Bonneville County, Idaho, May 20, 1951; graduated Idaho Falls High School 1969; B.A., Brigham Young University 1973; J.D., Harvard University School of Law 1977; admitted to the bar in 1977; law clerk to Judge James M. Carter, United States Court of Appeals, Ninth Circuit 1977-1978; practiced law in San Diego 1978-1979, and in Idaho Falls 1979-1992; vice chair, Bonneville County Republican Committee 1979-1981; vice chair, Legislative District 29 Republican Committee 1982-1984; Idaho State Senator 1985-1992; elected as a Republican to the One Hundred Third and to the two succeeding Congresses (January 3, 1993-January 3, 1999); was not a candidate for reelection to the U.S. House of Representatives, but was elected to the United States Senate in 1998; reelected in 2004 and again in 2010 for the term ending January 3, 2017.");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("IL", "D000563", "00326", "300038", "N00004981", "26847", "democrat", "active", "false", "false", "false", "true", "II", "male", "white", "Richard Durbin", "richard-durbin", "1944-11-21", "1997-01-03", "2021-01-03", "38.892839", "-77.004356", "711 Hart Senate Office Building Washington DC 20510", "http://www.durbin.senate.gov", "202-224-2152", "https://twitter.com/SenatorDurbin", "https://www.facebook.com/SenatorDurbin", "https://cdn.civil.services/senate/headshots/512x512/richard-durbin.jpg", "Richard Durbin, a Senator and a Representative from Illinois; born in East St. Louis, St. Clair County, Ill., November 21, 1944; graduated from Assumption High School, East St. Louis 1962; B.S., Georgetown University School of Foreign Service, Washington, DC 1966; intern in the office of Illinois Senator Paul Douglas during his senior year in College; J.D., Georgetown University Law Center 1969; admitted to the Illinois bar 1969, and commenced practice in Springfield; legal counsel to Illinois Lieutenant Governor Paul Simon 1969-1972; legal counsel, Illinois State Senate Judiciary Committee 1972-1982; Democratic nominee for lieutenant governor of Illinois 1978; associate professor, Southern Illinois University School of Medicine, Springfield 1978-1983; delegate, Democratic National Conventions 1984, 1988, 1992 and 1996; chairman of Illinois state delegation in 1996; elected as a Democrat to the Ninety-eighth and to the six succeeding Congresses (January 3, 1983-January 2, 1997); elected as a Democrat to the United States Senate in 1996; reelected in 2002, 2008, and again in 2014 for the term ending January 3, 2021; Democratic party whip (2005-).");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("IL", "D000622", "02123", "412533", "N00027860", "57442", "democrat", "active", "false", "false", "false", "false", "III", "female", "asian-american", "Tammy Duckworth", "tammy-duckworth", "1968-03-12", "2017-01-03", "2023-01-03", "38.892839", "-77.004356", "524 Hart Senate Office Building Washington DC 20510", "http://www.duckworth.senate.gov", "202-224-2854", "https://twitter.com/tammyforil", "https://www.facebook.com/TammyforIllinois", "https://cdn.civil.services/senate/headshots/512x512/tammy-duckworth.jpg", "Tammy Duckworth, a Senator and a Representative from Illinois; born in Bangkok, Thailand, March 12, 1968; graduated from President William McKinley High School, Honolulu, Hawaii, 1985; B.A., University of Hawaii, Manoa, Hawaii, 1989; M.A., The George Washington University, Washington, D.C., 1992; attended Northern Illinois University, DeKalb, Ill.; Illinois Army National Guard, 1996-present; unsuccessful candidate for election to the United States House of Representatives in 2006; director, Ill. department of veterans' affairs, 2006-2009; assistant secretary, United States Department of Veterans' Affairs, 2009-2011; delegate to the Democratic National Convention, 2012; elected as a Democrat to the One Hundred Thirteenth Congress and to the succeeding Congress (January 3, 2013-January 3, 2017); was not a candidate for reelection to the House of Representatives but was elected as a Democrat to the United States Senate in 2016 for the term ending January 3, 2023.");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("IN", "D000607", "01850", "412205", "N00026586", "34212", "democrat", "active", "false", "false", "false", "false", "I", "male", "white", "Joe Donnelly", "joe-donnelly", "1955-09-29", "2013-01-03", "2019-01-03", "38.892839", "-77.004356", "720 Hart Senate Office Building Washington DC 20510", "http://www.donnelly.senate.gov", "202-224-4814", "https://twitter.com/SenDonnelly", "https://www.facebook.com/senatordonnelly", "https://cdn.civil.services/senate/headshots/512x512/joe-donnelly.jpg", "Joe Donnelly, a Senator and a Representative from Indiana; born in Queens, Queens County, N.Y., September 28, 1955; B.A., University of Notre Dame, Notre Dame, Ind., 1977; J.D., University of Notre Dame, Notre Dame, Ind., 1981; lawyer, private practice; business owner; unsuccessful candidate for the 108th Congress in 2004; elected as a Democrat to the One Hundred Tenth and to the two succeeding Congresses (January 3, 2007-January 3, 2013); was not a candidate for reelection to the House of Representatives but was elected as a Democrat to the United States Senate in 2012 for the term ending January 3, 2019.");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("IN", "Y000064", "02019", "412428", "N00030670", "120345", "republican", "active", "false", "false", "false", "false", "III", "male", "white", "Todd Young", "todd-young", "1972-08-24", "2017-01-03", "2023-01-03", "38.892542", "-77.007415", "493 Russell Senate Office Building Washington DC 20510", "http://www.young.senate.gov", "202-224-5623", "https://twitter.com/SenToddYoung", "https://www.facebook.com/toddyoungindiana", "https://cdn.civil.services/senate/headshots/512x512/todd-young.jpg", "Todd Young, a Senator and a Representative from Indiana; born in Lancaster, Lancaster County, Pa., August 24, 1972; graduated from Carmel High School, Carmel, Ind., 1990; B.S., United States Naval Academy, Annapolis, Md., 1995; M.B.A., University of Chicago, Chicago, Ill., 2000; M.A., University of London, London, England, 2001; J.D., Robert H. McKinney School of Law, Indiana University, Indianapolis, Ind., 2006; United States Navy, 1990-1991; United States Marine Corps, 1995-2000; staff, United States Senator Richard Lugar of Indiana, 2001-2003; Orange County, Ind., deputy prosecutor, 2007-2010; consultant; lawyer, private practice; elected as a Republican to the One Hundred Twelfth and to the two succeeding Congresses (January 3, 2011-January 3, 2017); was not a candidate for reelection to the House of Representatives but was elected as a Republican to the United States Senate in 2016 for the term ending January 3, 2023.");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("KS", "M000934", "01507", "400284", "N00005282", "542", "republican", "active", "false", "false", "false", "false", "III", "male", "white", "Jerry Moran", "jerry-moran", "1954-05-29", "2011-01-03", "2023-01-03", "38.892947", "-77.075686", "521 Dirksen Senate Office Building Washington DC 20510", "http://www.moran.senate.gov", "202-224-6521", "https://twitter.com/JerryMoran", "https://www.facebook.com/jerrymoran", "https://cdn.civil.services/senate/headshots/512x512/jerry-moran.jpg", "Jerry Moran, a Senator and a Representative from Kansas; born in Great Bend, Barton County, Kans., May 29, 1954; attended Plainville High School, Plainville, Kans.; graduated University of Kansas, Lawrence, Kans., B.S., 1976; graduated Kansas University School of Law, Lawrence, Kans., J.D., 1981; M.B.A. candidate, Fort Hays State University, Hays, Kans.; bank officer; instructor, Fort Hays State University, Hays, Kans.; member of the Kansas state senate 1989-1997, serving as vice president 1993-1995, majority leader 1995-1997; Kansas state special assistant attorney general 1982-1985; deputy attorney, Rooks County, Kans. 1987-1995; University of Kansas School of Law, Lawrence, Kans., board of governors, serving as vice president 1993-1994, and as President 1994-1995; board of directors, Kansas chamber of commerce and industry 1996-1997; elected as a Republican to the One Hundred Fifth Congress and to the six succeeding Congresses (January 3, 1997-January 3, 2011); was not a candidate for reelection to the House of Representatives but was elected as a Republican to the United States Senate in 2010 for the term ending January 3, 2017; chair, National Republican Senatorial Committee (2012-2014).");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("KS", "R000307", "00968", "300083", "N00005285", "26866", "republican", "active", "false", "false", "false", "false", "II", "male", "white", "Pat Roberts", "pat-roberts", "1936-04-20", "1997-01-03", "2021-01-03", "38.892839", "-77.004356", "109 Hart Senate Office Building Washington DC 20510", "http://www.roberts.senate.gov", "202-224-4774", "https://twitter.com/SenPatRoberts", "https://www.facebook.com/SenPatRoberts", "https://cdn.civil.services/senate/headshots/512x512/pat-roberts.jpg", "Pat Roberts, a Senator and a Representative from Kansas; born in Topeka, Kans., April 20, 1936; attended the public schools; graduated from Holton High School 1954; B.A., Kansas State University, Manhattan 1958; served in the U.S. Marine Corps as a captain 1958-1962; newspaper publisher, Litchfield Park, Ariz. 1962-1967; administrative assistant, United States Senator Frank Carlson 1967-1968; administrative assistant, United States Congressman Keith Sebelius 1968-1980; elected as a Republican to the Ninety-seventh and to the seven succeeding Congresses (January 3, 1981-January 2, 1997); chair, Committee on Agriculture (One Hundred Fourth Congress); not a candidate for reelection to the House of Representatives in 1996, but was elected as a Republican to the United States Senate in 1996; reelected in 2002, 2008, and again in 2014 for the term ending January 3, 2021; Chair, Select Committee on Ethics (One Hundred Sixth and One Hundred Seventh Congresses [November 9, 1999-January 3, 2001; January 20, 2001-June 6, 2001]), Select Committee on Intelligence (One Hundred Eighth and One Hundred Ninth Congresses), Committee on Agriculture, Nutrition, and Forestry (One Hundred Fourteenth Congress).");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("KY", "P000603", "02082", "412492", "N00030836", "117285", "republican", "active", "false", "false", "false", "false", "III", "male", "white", "Rand Paul", "rand-paul", "1963-01-07", "2011-01-03", "2023-01-03", "38.892542", "-77.007415", "167 Russell Senate Office Building Washington DC 20510", "http://www.paul.senate.gov", "202-224-4343", "https://twitter.com/RandPaul", "https://www.facebook.com/SenatorRandPaul", "https://cdn.civil.services/senate/headshots/512x512/rand-paul.jpg", "Rand Paul (son of Ronald Ernest Paul), a Senator from Kentucky; born in Pittsburgh, Pa., January 7, 1963; attended Baylor University, 1981-1984; graduated Duke University, M.D., 1988; ophthalmologist; elected as a Republican to the United States Senate for the term ending January 3, 2017.");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("KY", "M000355", "01395", "300072", "N00003389", "53298", "republican", "active", "true", "false", "false", "false", "II", "male", "white", "Mitch McConnell", "mitch-mcconnell", "1942-02-20", "1985-01-03", "2021-01-03", "38.892542", "-77.007415", "317 Russell Senate Office Building Washington DC 20510", "http://www.mcconnell.senate.gov", "202-224-2541", "https://twitter.com/McConnellPress", "https://www.facebook.com/mitchmcconnell", "https://cdn.civil.services/senate/headshots/512x512/mitch-mcconnell.jpg", "Mitch McConnell, a Senator from Kentucky; born in Tuscumbia, Colbert County, Ala., February 20, 1942; attended Louisville, Ky. public schools; graduated, University of Louisville 1964; graduated, University of Kentucky Law School, Lexington 1967; admitted to the Kentucky bar in 1967; legislative assistant to Senator Marlow Cook 1968-1970; Deputy Assistant United States Attorney for Legislative Affairs 1974-1975; Acting Assistant Attorney General 1975; elected judge-executive of Jefferson County, Ky., 1978-1985; elected as a Republican to the United States Senate in 1984; reelected in 1990, 1996, 2002, 2008, and again in 2014 for the term ending January 3, 2021; Republican party whip (2003-2007); minority leader (2007-2015); majority leader (2015-); chair, Select Committee on Ethics (One Hundred Fourth Congress), National Republican Senatorial Campaign Committee (One Hundred Fifth through One Hundred Sixth Congresses), Committee on Rules and Administration (One Hundred Sixth Congress, One Hundred Seventh Congress [January 20, 2001-June 6, 2001]).");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("LA", "C001075", "01925", "412269", "N00030245", "69494", "republican", "active", "false", "false", "false", "false", "II", "male", "white", "Bill Cassidy", "bill-cassidy", "1957-09-28", "2015-01-03", "2021-01-03", "38.892839", "-77.004356", "703 Hart Senate Office Building Washington DC 20510", "http://www.cassidy.senate.gov", "202-224-5824", "https://twitter.com/BillCassidy", "https://www.facebook.com/billcassidy", "https://cdn.civil.services/senate/headshots/512x512/bill-cassidy.jpg", "Bill Cassidy, a Senator and a Representative from Louisiana; born in Highland Park, Lake County, Ill., September 28, 1957; B.S., Louisiana State University, Baton Rouge, La., 1979; M.D., Louisiana State University Medical School, New Orleans, La., 1983; physician; member of the Louisiana state senate, 2006-2008; elected as a Republican to the One Hundred Eleventh and to the two succeeding Congresses (January 3, 2009-January 3, 2015); was not a candidate for reelection to the House of Representatives but was elected as a Republican to the United States Senate in 2014 for the term ending January 3, 2021.");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("LA", "K000393", null, "412679", null, "35496", "republican", "active", "false", "false", "false", "false", "III", "male", "white", "John Kennedy", "john-kennedy", "1951-11-21", "2017-01-03", "2023-01-03", "38.892839", "-77.004356", "703 Hart Senate Office Building Washington DC 20510", "http://www.kennedy.senate.gov", "202-224-4623", "https://twitter.com/johnkennedyla", "https://www.facebook.com/johnkennedylouisiana", "https://cdn.civil.services/senate/headshots/512x512/john-kennedy.jpg", "John Kennedy, a Senator from Louisiana; born in Centreville, Miss., November 21, 1951; B.A., Vanderbilt University, 1973; J.D., University of Virginia School of Law, 1977; B.C.L., Oxford University, Oxford, England, 1979; lawyer; special counsel to Louisiana Governor Buddy Roemer; secretary to Governor Roemer's Cabinet; Secretary of the state Department of Revenue in the Cabinet of Louisiana Governor Mike Foster 1996-1999; Louisiana state Treasurer 1999-2016; elected as a Republican to the United States Senate in 2016 for the term ending January 3, 2023.");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("MA", "W000817", "02182", "412542", "N00033492", "141272", "democrat", "active", "false", "false", "false", "false", "I", "female", "white", "Elizabeth Warren", "elizabeth-warren", "1949-06-22", "2013-01-03", "2019-01-03", "38.892839", "-77.004356", "317 Hart Senate Office Building Washington DC 20510", "http://www.warren.senate.gov", "202-224-4543", "https://twitter.com/SenWarren", "https://www.facebook.com/senatorelizabethwarren", "https://cdn.civil.services/senate/headshots/512x512/elizabeth-warren.jpg", "Elizabeth Warren, a Senator from Massachusetts; born in Oklahoma City, Okla., June 22, 1949; attended George Washington University, 1966-1968; graduated University of Houston, B.S., 1970; graduated Rutgers University, J.D., 1976; elementary school teacher; lawyer; law professor; bankruptcy analyst; Chair, Congressional Oversight Panel for the Troubled Asset Relief Program 2008-2010; special assistant to President Barack Obama for the Consumer Financial Protection Bureau 2010-2011; elected as a Democrat to the United States Senate in 2012 for the term ending January 3, 2019.");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("MA", "M000133", "00735", "400253", "N00000270", "26900", "democrat", "active", "false", "false", "false", "false", "II", "male", "white", "Edward Markey", "edward-markey", "1946-11-11", "2013-07-16", "2021-01-03", "38.892947", "-77.075686", "255 Dirksen Senate Office Building Washington DC 20510", "http://www.markey.senate.gov", "202-224-2742", "https://twitter.com/SenMarkey", "https://www.facebook.com/EdJMarkey", "https://cdn.civil.services/senate/headshots/512x512/edward-markey.jpg", "Edward Markey, a Senator and a Representative from Massachusetts; born in Malden, Middlesex County, Mass., July 11, 1946; attended Immaculate Conception Grammar School, Malden, Mass.; graduated from Malden Catholic High School, Malden, Mass., 1964; B.A., Boston College, Chestnut Hill, Mass., 1968; J.D., Boston College Law School, Chestnut Hill, Mass., 1972; lawyer, private practice; United States Army Reserve, 1968-1973; member of the Massachusetts state house of representatives, 1973-1976; elected as a Democrat to the Ninety-fourth Congress, by special election to fill the vacancy caused by the death of United States Representative Torbert H. Macdonald; reelected to the nineteen succeeding Congresses, and served from November 2, 1976, to July 15, 2013, when he resigned to become a U.S. Senator; elected as a Democrat to the U.S. Senate in a special election on June 25, 2013, to fill the vacancy caused by the resignation of John F. Kerry, a seat subsequently held by appointed Senator William Cowan, and took the oath of office on July 16, 2013; reelected in 2014 for the term ending January 3, 2021.");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("MD", "C000141", "00174", "400064", "N00001955", "26888", "democrat", "active", "false", "false", "false", "false", "I", "male", "white", "Benjamin Cardin", "benjamin-cardin", "1943-10-05", "2007-01-03", "2019-01-03", "38.892839", "-77.004356", "509 Hart Senate Office Building Washington DC 20510", "http://www.cardin.senate.gov", "202-224-4524", "https://twitter.com/SenatorCardin", "https://www.facebook.com/senatorbencardin", "https://cdn.civil.services/senate/headshots/512x512/benjamin-cardin.jpg", "Benjamin Cardin, a Senator and a Representative from Maryland; born in Baltimore, Md., October 5, 1943; attended public schools; graduated from Baltimore City College, Baltimore, Md., 1961; B.A., University of Pittsburgh, Pittsburgh, Pa., 1964; J.D., University of Maryland, Baltimore, Md., 1967; lawyer, private practice; member of the Maryland state house of delegates, 1966-1986, speaker, 1979-1986; elected as a Democrat to the One Hundredth and to the nine succeeding Congresses (January 3, 1987-January 3, 2007); one of the managers appointed by the House of Representatives in 1989 to conduct the impeachment proceedings against Walter L. Nixon, judge of the United States District Court for the District Court of Mississippi; not a candidate for reelection to the House of Representatives but was elected as a Democrat to the United States Senate in 2006 for the term commencing January 3, 2007; reelected in 2012 for the term ending January 3, 2019.");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("MD", "V000128", "01729", "400415", "N00013820", "6098", "democrat", "active", "false", "false", "false", "false", "III", "male", "white", "Chris Van Hollen", "chris-van-hollen", "1959-01-10", "2017-01-03", "2023-01-03", "38.892839", "-77.004356", "503 Hart Senate Office Building Washington DC 20510", "http://www.vanhollen.senate.gov", "202-224-4654", "https://twitter.com/chrisvanhollen", "https://www.facebook.com/vanhollenformd", "https://cdn.civil.services/senate/headshots/512x512/chris-van-hollen.jpg", "Christopher Van Hollen, a Senator and a Representative from Maryland; born in Karachi, Pakistan, January 10, 1959; B.A., Swarthmore College, Swarthmore, Pa., 1982; M.P.P., Harvard University, Cambridge, Mass., 1985; J.D., Georgetown University, Washington, D.C., 1990; lawyer, private practice; member of the Maryland state house of representatives, 1990-1994; member of the Maryland state senate, 1994-2002; elected as a Democrat to the One Hundred Eighth and to the six succeeding Congresses (January 3, 2003-January 3, 2017); was not a candidate for reelection to the House of Representatives but was elected as a Democrat to the United States Senate in 2016 for the term ending January 3, 2023.");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("ME", "K000383", "02185", "412545", "N00034580", "22381", "independent", "active", "false", "false", "false", "false", "I", "male", "white", "Angus King", "angus-king", "1944-03-31", "2013-01-03", "2019-01-03", "38.892839", "-77.004356", "133 Hart Senate Office Building Washington DC 20510", "http://www.king.senate.gov", "202-224-5344", "https://twitter.com/SenAngusKing", "https://www.facebook.com/SenatorAngusSKingJr", "https://cdn.civil.services/senate/headshots/512x512/angus-king.jpg", "Angus King, a Senator from Maine; born in Alexandria, Va., March 31, 1944; graduated Dartmouth College, B.A., 1966; graduated University of Virginia, J.D., 1969; lawyer; Counsel, U.S. Senate Subcommittee on Alcoholism and Narcotics; television program host and co-producer; company executive; energy conservation company owner; governor of Maine 1995-2003; elected as an Independent to the United States Senate in 2012 for the term ending January 3, 2019.");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("ME", "C001035", "01541", "300025", "N00000491", "379", "republican", "active", "false", "false", "false", "false", "II", "female", "white", "Susan Collins", "susan-collins", "1952-12-07", "1997-01-03", "2021-01-03", "38.892947", "-77.075686", "413 Dirksen Senate Office Building Washington DC 20510", "http://www.collins.senate.gov", "202-224-2523", "https://twitter.com/SenatorCollins", "https://www.facebook.com/susancollins", "https://cdn.civil.services/senate/headshots/512x512/susan-collins.jpg", "Susan Collins, a Senator from Maine; born in Caribou, Aroostook County, Maine, December 7, 1952; graduated from St. Lawrence University, Canton, NY 1975; worked for United States Senator William S. Cohen 1975-1987, serving as staff director of the Senate Governmental Affairs Subcommittee on the Oversight of Government Management 1981-1987; commissioner of the Maine Department of Professional and Financial Regulation 1987-1992; New England regional director, United States Small Business Administration 1992; served as deputy state treasurer of Massachusetts, 1993; won an eight-way Republican primary to become the first woman nominated for governor of Maine in 1994, but lost general election; elected as a Republican to the United States Senate in 1996; reelected in 2002, 2008, and again in 2014 for the term ending January 3, 2021; chair, Committee on Governmental Affairs (One Hundred Eighth Congress), Committee on Homeland Security and Governmental Affairs (One Hundred Ninth Congress); Special Committee on Aging (One Hundred Fourteenth Congress).");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("MI", "S000770", "01531", "300093", "N00004118", "515", "democrat", "active", "false", "false", "false", "false", "I", "female", "white", "Debbie Stabenow", "debbie-stabenow", "1950-04-29", "2001-01-03", "2019-01-03", "38.892839", "-77.004356", "731 Hart Senate Office Building Washington DC 20510", "http://www.stabenow.senate.gov", "202-224-4822", "https://twitter.com/SenStabenow", "https://www.facebook.com/stabenow", "https://cdn.civil.services/senate/headshots/512x512/debbie-stabenow.jpg", "Debbie Stabenow, a Senator and a Representative from Michigan; born in Gladwin, Mich., April 29, 1950; graduated, Clare High School; B.A., Michigan State University, East Lansing 1972; M.S.W. magna cum laude, Michigan State University, 1975; social worker; leadership training consultant; Ingham County commissioner 1975-1978; member, State house of representatives 1979-1990; member, State senate 1991-1994; elected as a Democrat to the One Hundred Fifth and One Hundred Sixth Congresses (January 3, 1997-January 3, 2001); was not a candidate for reelection to the House of Representatives in 2000, but was elected to the United States Senate for the term commencing January 3, 2001; reelected in 2006 and again in 2012 for the term ending January 3, 2019; Democratic Conference secretary (2005-2007); vice-chair, Democratic Policy and Communications Committee (2011-); chair, Committee on Agriculture, Nutrition, and Forestry (One Hundred Twelfth and One Hundred Thirteenth Congresses).");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("MI", "P000595", "01929", "412305", "N00029277", "8749", "democrat", "active", "false", "false", "false", "false", "II", "male", "white", "Gary Peters", "gary-peters", "1958-01-01", "2015-01-03", "2021-01-03", "38.892839", "-77.004356", "724 Hart Senate Office Building Washington DC 20510", "http://www.peters.senate.gov", "202-224-6221", "https://twitter.com/SenGaryPeters", "https://www.facebook.com/SenatorGaryPeters", "https://cdn.civil.services/senate/headshots/512x512/gary-peters.jpg", "Gary Peters, a Senator and a Representative from Michigan; born in Pontiac, Oakland County, Mich., December 1, 1958; B.A., Alma College, Alma, Mich., 1980; M.B.A., Finance, University of Detroit, Detroit, Mich., 1984; J.D., Wayne State University, Detroit, Mich., 1989; M.A., Philosophy, Michigan State University, East Lansing, Mich., 2007; United States Navy Reserve, 1993-2000, 2001-2005; assistant vice president, Merrill Lynch, 1980-1989; vice president, UBS/Paine Webber, 1989-2003; Arbitrator, Financial Industry Regulatory Authority; instructor, Oakland University, Rochester, Mich., and Wayne State University, Detroit, Mich.; Professor, Central Michigan University; member, Rochester Hills, Mich., city council, 1991-1993; member of the Michigan state senate, 1995-2002; unsuccessful candidate for Michigan state attorney general in 2002; chief administrative officer for the Bureau of investments, state of Michigan, 2003; lottery commissioner, state of Michigan, 2003-2007; elected as a Democrat to the One Hundred Eleventh and to the two succeeding Congresses (January 3, 2009-January 3, 2015); was not a candidate for reelection to the House of Representatives but was elected as a Democrat to the United States Senate in 2014 for the term ending January 3, 2021.");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("MN", "K000367", "01826", "412242", "N00027500", "65092", "democrat", "active", "false", "false", "false", "false", "I", "female", "white", "Amy Klobuchar", "amy-klobuchar", "1960-05-25", "2007-01-03", "2019-01-03", "38.892839", "-77.004356", "302 Hart Senate Office Building Washington DC 20510", "http://www.klobuchar.senate.gov", "202-224-3244", "https://twitter.com/amyklobuchar", "https://www.facebook.com/amyklobuchar", "https://cdn.civil.services/senate/headshots/512x512/amy-klobuchar.jpg", "Amy Klobuchar, a Senator from Minnesota; born in Plymouth, Minn., May 25, 1960; attended the public schools in Plymouth; graduated magna cum laude Yale University 1982; J.D., University of Chicago 1985; practiced law in Minnesota, becoming partner at the law firms of Dorsey & Whitney and Gray Plant Mooty; Hennepin County Attorney 1999-2006; elected as a Democrat to the United States Senate in 2006 for the term commencing January 3, 2007; reelected in 2012 for the term ending January 3, 2019.");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("MN", "F000457", "01969", "412378", "N00029016", "108924", "democrat", "active", "false", "false", "false", "false", "II", "male", "white", "Alan Franken", "alan-franken", "1951-05-21", "2009-07-07", "2021-01-03", "38.892839", "-77.004356", "309 Hart Senate Office Building Washington DC 20510", "http://www.franken.senate.gov", "202-224-5641", "https://twitter.com/SenFranken", "https://www.facebook.com/senatoralfranken", "https://cdn.civil.services/senate/headshots/512x512/alan-franken.jpg", "Alan Franken, a Senator from Minnesota; born in Manhattan, N.Y., May 21, 1951; A.B., Harvard University, Cambridge, Mass., 1973; screenwriter; comedian; author; radio talk show host; elected as a Democrat to the United States Senate in 2008 for the term beginning January 3, 2009, but the election was contested; following a June 30, 2009, decision in his favor by the Minnesota state supreme court, he took the oath of office and began service on July 7, 2009; reelected in 2014 for the term ending January 3, 2021.");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("MO", "B000575", "01464", "400034", "N00005195", "418", "republican", "active", "false", "false", "false", "false", "III", "male", "white", "Roy Blunt", "roy-blunt", "1950-01-10", "2011-01-03", "2023-01-03", "38.892542", "-77.007415", "260 Russell Senate Office Building Washington DC 20510", "http://www.blunt.senate.gov", "202-224-5721", "https://twitter.com/RoyBlunt", "https://www.facebook.com/SenatorBlunt", "https://cdn.civil.services/senate/headshots/512x512/roy-blunt.jpg", "Roy Blunt, a Senator and a Representative from Missouri; born in Niangua, Webster County, Mo., January 10, 1950; graduated Southwest Baptist University, Bolivar, Mo., B.A., 1970; graduated Missouri State University, Springfield, Mo., M.A., 1972; high school history teacher; clerk and chief election officer, Greene County, Mo. 1973-1984; Missouri state secretary of state 1984-1993; President, Southwest Baptist University, Bolivar, Mo. 1993-1996; elected as a Republican to the One Hundred Fifth and to the six succeeding Congresses (January 3, 1997-January 3, 2011); majority whip (One Hundred Eighth through One Hundred Ninth Congresses); acting majority leader (One Hundred Ninth Congress, September 28, 2005-February 2, 2006); minority whip (One Hundred Tenth Congress); was not a candidate for reelection to the House of Representatives but was elected as a Republican to the United States Senate in 2010 for the term ending January 3, 2017; vice-chair, Republican Conference (2012-); chair, Committee on Rules and Administration (One Hundred Fourteenth Congress).");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("MO", "M001170", "01820", "412243", "N00027694", "2109", "democrat", "active", "false", "false", "false", "false", "I", "female", "white", "Claire McCaskill", "claire-mccaskill", "1953-07-24", "2007-01-03", "2019-01-03", "38.892839", "-77.004356", "730 Hart Senate Office Building Washington DC 20510", "http://www.mccaskill.senate.gov", "202-224-6154", "https://twitter.com/McCaskillOffice", "https://www.facebook.com/senatormccaskill", "https://cdn.civil.services/senate/headshots/512x512/claire-mccaskill.jpg", "Claire McCaskill, a Senator from Missouri; born in Rolla, Mo., July 24, 1953; attended Hickman High School in Columbia, Mo.; graduated University of Missouri, Columbia 1975; J.D., University of Missouri, Columbia 1978; Missouri State house of representatives 1982-1988; Jackson County prosecutor 1992-1998; unsuccessful candidate for Governor 2004; Missouri State Auditor 1998-2006; elected as a Democrat to the United States Senate in 2006 for the term commencing January 3, 2007; reelected in 2012 for the term ending January 3, 2019.");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("MS", "W000437", "01226", "400432", "N00003280", "21926", "republican", "active", "false", "false", "false", "false", "I", "male", "white", "Roger Wicker", "roger-wicker", "1951-07-05", "2007-12-31", "2019-01-03", "38.892947", "-77.075686", "555 Dirksen Senate Office Building Washington DC 20510", "http://www.wicker.senate.gov", "202-224-6253", "https://twitter.com/SenatorWicker", "https://www.facebook.com/SenatorWicker", "https://cdn.civil.services/senate/headshots/512x512/roger-wicker.jpg", "Roger Wicker, a Senator and a Representative from Mississippi; born in Pontotoc, Pontotoc County, Miss., July 5, 1951; graduated Pontotoc High School, Pontotoc, Miss., 1969; B.A., University of Mississippi, University, Miss., 1973; J.D., University of Mississippi, University, Miss. 1975; Air Force Reserve Officer Training Corps; United States Air Force 1976-1980; United States Air Force Reserve 1980-2003; staff for United States Representative Trent Lott of Mississippi, House Committee on Rules 1980-1982; Tupelo, Miss., judge pro tem; Lee County, Miss., public defender 1984-1987; member of the Mississippi state Senate 1988-1994; elected as a Republican to the One Hundred Fourth and to the six succeeding Congresses (January 3, 1995-December 31, 2007); resigned on December 31, 2007, to accept appointment to the Senate; appointed to the U.S. Senate on December 31, 2007, to fill the seat left vacant by the resignation of Chester Trent Lott; took oath of office on December 31, 2007; elected in 2008 in a special election for the term ending January 3, 2013; reelected in 2012 for the term ending January 3, 2019; chair, National Republican Senatorial Committee (2015-).");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("MS", "C000567", "00213", "300023", "N00003328", "53312", "republican", "active", "false", "false", "false", "false", "II", "male", "white", "Thad Cochran", "thad-cochran", "1937-12-07", "1978-12-27", "2021-01-03", "38.892947", "-77.075686", "113 Dirksen Senate Office Building Washington DC 20510", "http://www.cochran.senate.gov", "202-224-5054", "https://twitter.com/SenThadCochran", "https://www.facebook.com/pages/US-Senator-Thad-Cochran-R-MS/384626981575895", "https://cdn.civil.services/senate/headshots/512x512/thad-cochran.jpg", "Thad Cochran, a Senator and a Representative from Mississippi; born in Pontotoc, Pontotoc County, Miss., December 7, 1937; educated in the public schools of Mississippi; graduated, University of Mississippi, Oxford 1959 and the University of Mississippi Law School 1965; studied international law and jurisprudence at Trinity College, University of Dublin, Ireland 1963-1964; served in the United States Navy 1959-1961; admitted to the Mississippi bar in 1965 and commenced practice in Jackson; elected as a Republican to the Ninety-third Congress in 1972; reelected to the Ninety-fourth and Ninety-fifth Congresses and served from January 3, 1973, until his resignation on December 26, 1978; was not a candidate for reelection to the House of Representatives, but was elected in 1978 to the United States Senate for the term commencing January 3, 1979; subsequently appointed by the Governor, December 27, 1978, to fill the vacancy caused by the resignation of James O. Eastland for the term ending January 3, 1979; reelected in 1984, 1990, 1996, 2002, 2008, and again in 2014 for the term ending January 3, 2021; Chair, Senate Republican Conference (1991-1997), Committee on Agriculture, Nutrition, and Forestry (One Hundred Eighth Congress); Committee on Appropriations (One Hundred Ninth and One Hundred Fourteenth Congresses).");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("MT", "T000464", "01829", "412244", "N00027605", "20928", "democrat", "active", "false", "false", "false", "false", "I", "male", "white", "Jon Tester", "jon-tester", "1956-08-21", "2007-01-03", "2019-01-03", "38.892839", "-77.004356", "311 Hart Senate Office Building Washington DC 20510", "http://www.tester.senate.gov", "202-224-2644", "https://twitter.com/SenatorTester", "https://www.facebook.com/senatortester", "https://cdn.civil.services/senate/headshots/512x512/jon-tester.jpg", "Jon Tester, a Senator from Montana; born in Havre, Mont., on August 21, 1956; graduated College of Great Falls 1978, farmer; teacher; member, Big Sandy school board 1983-1992 (chairman 1986-1991); Montana State Senate 1999-2006, serving as minority whip 2001-2003, minority leader 2003-2005, president 2005-2006; elected as a Democrat to the United States Senate in 2006 for the term commencing January 3, 2007; reelected in 2012 for the term ending January 3, 2019; chair, Committee on Indian Affairs (One Hundred Thirteenth Congress [February 12, 2014-January 3, 2015]); chair, Democratic Senatorial Campaign Committee (2015-).");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("MT", "D000618", "02138", "412549", "N00033054", "135720", "republican", "active", "false", "false", "false", "false", "II", "male", "white", "Steve Daines", "steve-daines", "1962-08-20", "2015-01-03", "2021-01-03", "38.892839", "-77.004356", "320 Hart Senate Office Building Washington DC 20510", "http://www.daines.senate.gov", "202-224-2651", "https://twitter.com/SteveDaines", "https://www.facebook.com/SteveDainesMT", "https://cdn.civil.services/senate/headshots/512x512/steve-daines.jpg", "Steve Daines, a Senator and a Representative from Montana; born in Van Nuys, Los Angeles County, Calif., August 20, 1962; graduated from Bozeman High School, Bozeman, Mont.; B.S., Montana State University, Bozeman, Mont., 1984; businessman; delegate, Republican National Convention, 1984; unsuccessful candidate for lieutenant governor of Montana in 2008; elected as a Republican to the One Hundred Thirteenth Congress (January 3, 2013-January 3, 2015); was not a candidate for reelection to the House of Representatives but was elected as a Republican to the United States Senate in 2014 for the term ending January 3, 2021.");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("NC", "B001135", "00153", "400054", "N00002221", "21787", "republican", "active", "false", "false", "false", "false", "III", "male", "white", "Richard Burr", "richard-burr", "1955-11-30", "2005-01-03", "2023-01-03", "38.892542", "-77.007415", "217 Russell Senate Office Building Washington DC 20510", "http://www.burr.senate.gov", "202-224-3154", "https://twitter.com/SenatorBurr", "https://www.facebook.com/SenatorRichardBurr", "https://cdn.civil.services/senate/headshots/512x512/richard-burr.jpg", "Richard Burr, a Senator and a Representative from North Carolina; born in Charlottesville, Albemarle County, Va., November 30, 1955; graduated from Reynolds High School, Winston-Salem, N.C., 1974; B.A., Wake Forest University, Winston-Salem, N.C., 1978; unsuccessful candidate for election to the One Hundred Third Congress in 1992; elected as a Republican to the One Hundred Fourth and to the four succeeding Congresses (January 3, 1995-January 3, 2005); was not a candidate for reelection to the House of Representatives, but was elected to the United States Senate in 2004; reelected in 2010 for the term ending January 3, 2017; Chair, Select Committee on Intelligence (One Hundred Fourteenth Congress).");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("NC", "T000476", "02291", "412668", "N00035492", null, "republican", "active", "false", "false", "false", "false", "II", "male", "white", "Thom Tillis", "thom-tillis", "1960-08-30", "2015-01-03", "2021-01-03", "38.892947", "-77.075686", "185 Dirksen Senate Office Building Washington DC 20510", "http://www.tillis.senate.gov", "202-224-6342", "https://twitter.com/senthomtillis", "https://www.facebook.com/SenatorThomTillis", "https://cdn.civil.services/senate/headshots/512x512/thom-tillis.jpg", "Thom Tillis, a Senator from North Carolina; born in Jacksonville, Duval County, Fla., August 30, 1960; B.A., University of Maryland University College, 1997; management consultant; member of the Cornelius (N.C.) board of commissioners 2003-2005; Member of the North Carolina house of representatives 2007-2014, serving as speaker of the House 2011-2014; elected as a Republican to the United States Senate in 2014 for the term ending January 3, 2021.");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("ND", "H001061", "02079", "412494", "N00031688", "41788", "republican", "active", "false", "false", "false", "false", "III", "male", "white", "John Hoeven", "john-hoeven", "1957-03-13", "2011-01-03", "2023-01-03", "38.892542", "-77.007415", "338 Russell Senate Office Building Washington DC 20510", "http://www.hoeven.senate.gov", "202-224-2551", "https://twitter.com/SenJohnHoeven", "https://www.facebook.com/SenatorJohnHoeven", "https://cdn.civil.services/senate/headshots/512x512/john-hoeven.jpg", "John Hoeven, a Senator from North Dakota; born in Bismarck, N.D., March 13, 1957; graduated Dartmouth College, B.A., 1979; graduated Northwestern University, M.B.A., 1981; bank president and CEO; governor of North Dakota 2000-2010; elected as a Republican to the United States Senate in 2010 for the term ending January 3, 2017.");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("ND", "H001069", "02174", "412554", "N00033782", "41716", "democrat", "active", "false", "false", "false", "false", "I", "female", "white", "Heidi Heitkamp", "heidi-heitkamp", "1955-10-30", "2013-01-03", "2019-01-03", "38.892839", "-77.004356", "110 Hart Senate Office Building Washington DC 20510", "http://www.heitkamp.senate.gov", "202-224-2043", "https://twitter.com/SenatorHeitkamp", "https://www.facebook.com/SenatorHeidiHeitkamp", "https://cdn.civil.services/senate/headshots/512x512/heidi-heitkamp.jpg", "Heidi Heitkamp, a Senator from North Dakota; born in Breckenridge, Minn., October 30, 1955; graduated University of North Dakota, B.A., 1977; graduated Lewis & Clark College, J.D., 1980; lawyer, Environmental Protection Agency 1980-1981; lawyer, Office of the North Dakota State Tax Commissioner 1981-1986; director, Dakota Gasification Company; tax commissioner of North Dakota 1986-1992; attorney general of North Dakota 1992-2000; unsuccessful Democratic candidate for governor of North Dakota in 2000; elected as a Democrat to the United States Senate in 2012 for the term ending January 3, 2019.");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("NE", "F000463", "02179", "412556", "N00033443", "41963", "republican", "active", "false", "false", "false", "false", "I", "female", "white", "Deb Fischer", "deb-fischer", "1951-03-01", "2013-01-03", "2019-01-03", "38.892542", "-77.007415", "454 Russell Senate Office Building Washington DC 20510", "http://www.fischer.senate.gov", "202-224-6551", "https://twitter.com/SenatorFischer", "https://www.facebook.com/senatordebfischer", "https://cdn.civil.services/senate/headshots/512x512/deb-fischer.jpg", "Deb Fischer, a Senator from Nebraska; born in Lincoln, Neb., March 1, 1951; graduated University of Nebraska, B.S., 1988; rancher; Valentine Rural High School Board of Education 1990-2004; Nebraska Coordinating Commission for Postsecondary Education 2000-2004; Nebraska Unicameral Legislature 2005-2012; elected as a Republican to the United States Senate in 2012 for the term ending January 3, 2019.");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("NE", "S001197", "02289", "412671", "N00035544", null, "republican", "active", "false", "false", "false", "false", "II", "male", "white", "Benjamin Sasse", "benjamin-sasse", "1972-02-22", "2015-01-03", "2021-01-03", "38.892542", "-77.007415", "386A Russell Senate Office Building Washington DC 20510", "http://www.sasse.senate.gov", "202-224-4224", "https://twitter.com/SenSasse", "https://www.facebook.com/SenatorSasse", "https://cdn.civil.services/senate/headshots/512x512/benjamin-sasse.jpg", "Benjamin Sasse, a Senator from Nebraska; born in Plainview, Pierce County, Nebr., February 22, 1972; B.A., Harvard University, 1994; M.A., St. John's College, Annapolis, Md., 1998; Ph.D., Yale University, 2004; management consultant; University professor; chief of staff to U.S. Representative Jeff Fortenberry; counselor to the secretary, U.S. Department of Health and Human Services; assistant secretary for planning and evaluation, U.S. Department of Health and Human Services; president of Midland University, Fremont, Nebr.; elected as a Republican to the United States Senate in 2014 for the term ending January 3, 2021.");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("NH", "S001181", "01901", "412323", "N00024790", "1663", "democrat", "active", "false", "false", "false", "false", "II", "female", "white", "Jeanne Shaheen", "jeanne-shaheen", "1947-01-28", "2009-01-03", "2021-01-13", "38.892839", "-77.004356", "506 Hart Senate Office Building Washington DC 20510", "http://www.shaheen.senate.gov", "202-224-2841", "https://twitter.com/SenatorShaheen", "https://www.facebook.com/SenatorShaheen", "https://cdn.civil.services/senate/headshots/512x512/jeanne-shaheen.jpg", "Jeanne Shaheen, a Senator from New Hampshire; born in St. Charles, Mo., January 28, 1947; B.A., Shippensburg State College, Shippensburg, Penn., 1969; M.S.S., University of Mississippi, 1973; New Hampshire State Senator, 1990-1996; governor of New Hampshire, 1997-2003; unsuccessful candidate for election to the United States Senate in 2002; elected as a Democrat to the United States Senate in 2008; reelected in 2014 for the term ending January 3, 2021.");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("NH", "H001076", null, "412680", null, "42552", "democrat", "active", "false", "false", "false", "false", "III", "female", "white", "Maggie Hassan", "maggie-hassan", "1958-02-27", "2017-01-03", "2023-01-03", "38.892542", "-77.007415", "144 Russell Senate Office Building Washington DC 20510", "http://www.hassan.senate.gov", "202-224-3324", "https://twitter.com/maggie_hassan", "https://www.facebook.com/maggiefornh", "https://cdn.civil.services/senate/headshots/512x512/maggie-hassan.jpg", "Maggie Hassan, a Senator from New Hampshire; born in Boston, Mass., February 27, 1958; B.A., Brown University, 1980; J.D., Northeastern University School of Law, 1985; lawyer; member of the New Hampshire Advisory Committee to the Adequacy in Education and Finance Commission; member of the New Hampshire state Senate 2005-2010, serving as majority leader 2008-2010; governor of New Hampshire 2013-2016; elected as a Democrat to the United States Senate in 2016 for the term ending January 3, 2023.");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("NJ", "M000639", "00791", "400272", "N00000699", "26961", "democrat", "active", "false", "false", "false", "false", "I", "male", "hispanic-american", "Robert Menendez", "robert-menendez", "1954-01-01", "2006-01-18", "2019-01-03", "38.892839", "-77.004356", "528 Hart Senate Office Building Washington DC 20510", "http://menendez.senate.gov", "202-224-4744", "https://twitter.com/SenatorMenendez", "https://www.facebook.com/senatormenendez", "https://cdn.civil.services/senate/headshots/512x512/robert-menendez.jpg", "Robert Menendez, a Senator and a Representative from New Jersey; born in New York, N.Y., on January 1, 1954; graduated from Union Hill High School, Union City, N.J., 1972; B.A., Saint Peter's College, Jersey City, N.J., 1976; J.D., Rutgers University School of Law, Newark, N.J., 1979; lawyer, private practice; member of the Union City, N.J., board of education 1974-1978, and chief financial officer 1978-1982; mayor of Union City, N.J., 1986-1992; member of the New Jersey state general assembly 1987-1991; Member of the New Jersey state Senate 1991-1993; elected as a Democrat to the One Hundred Third and to the six succeeding Congresses, and served from January 3, 1993, to January 16, 2006, when he resigned to become a U.S. senator; chair, House Democratic Caucus (One Hundred Eighth through One Hundred Ninth Congresses); appointed on January 17, 2006, to the United States Senate to fill vacancy caused by resignation of Jon S. Corzine; service began on January 17, 2006, and took the oath of office on January 18, 2006; elected to the U.S. Senate in 2006 for the term commencing January 3, 2007; reelected in 2012 for the term ending January 3, 2019; chair, Democratic Senatorial Campaign Committee (2008-2011), Committee on Foreign Relations (One Hundred Thirteenth Congress [February 1, 2013-January 3, 2015]).");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("NJ", "B001288", "02194", "412598", "N00035267", "76151", "democrat", "active", "false", "false", "false", "false", "II", "male", "african-american", "Cory Booker", "cory-booker", "1969-04-27", "2013-10-31", "2021-01-03", "38.892947", "-77.075686", "359 Dirksen Senate Office Building Washington DC 20510", "http://www.booker.senate.gov", "202-224-3224", "https://twitter.com/CoryBooker", "https://www.facebook.com/corybooker", "https://cdn.civil.services/senate/headshots/512x512/cory-booker.jpg", "Cory Booker, a Senator from New Jersey; born on April 27, 1969, in Washington, D.C.; graduated Northern Valley Regional High School, Old Tappan, N.J., 1987; B.A., Stanford University, 1991; M.A., Stanford University, 1992; attended The Queen's College, University of Oxford, Oxford, England, as a Rhodes Scholar and received a graduate degree in 1994; J.D., Yale Law School, 1997; worked as an attorney in the non-profit sector; Newark City Council 1998-2002; Mayor of Newark, N.J. 2006-2013; elected as a Democrat to the United States Senate in a special election on October 16, 2013, to fill the vacancy caused by the death of Frank Lautenberg, a seat subsequently held by appointed Senator Jeffrey Chiesa, and took the oath of office on October 31, 2013; reelected in 2014 for the term ending January 3, 2021.");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("NM", "H001046", "01937", "412281", "N00029835", "74517", "democrat", "active", "false", "false", "false", "false", "I", "male", "white", "Martin Heinrich", "martin-heinrich", "1971-10-17", "2013-01-03", "2019-01-03", "38.892839", "-77.004356", "303 Hart Senate Office Building Washington DC 20510", "http://www.heinrich.senate.gov", "202-224-5521", "https://twitter.com/MartinHeinrich", "https://www.facebook.com/MartinHeinrich", "https://cdn.civil.services/senate/headshots/512x512/martin-heinrich.jpg", "Martin Heinrich, a Senator and a Representative from New Mexico; born in Fallon, Churchill County, Nev.; October 17, 1971; B. S., University of Missouri, Columbia, Mo., 1995; attended University of New Mexico, Albuquerque, N. Mex., 2001-2002; engineer; business owner; member, Albuquerque, N. Mex., city council, 2003-2007; President, Albuquerque, N. Mex., city council, 2005-2006; trustee, New Mexico state natural resources, 2006; elected as a Democrat to the One Hundred Eleventh and to the succeeding Congress (January 3, 2009-January 3, 2013); was not a candidate for reelection to the House of Representatives but was elected as a Democrat to the United States Senate in 2012 for the term ending January 3, 2019.");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("NM", "U000039", "01567", "400413", "N00006561", "22658", "democrat", "active", "false", "false", "false", "false", "II", "male", "white", "Tom Udall", "tom-udall", "1948-05-18", "2009-01-03", "2021-01-03", "38.892839", "-77.004356", "531 Hart Senate Office Building Washington DC 20510", "http://www.tomudall.senate.gov", "202-224-6621", "https://twitter.com/SenatorTomUdall", "https://www.facebook.com/senatortomudall", "https://cdn.civil.services/senate/headshots/512x512/tom-udall.jpg", "Tom Udall (son of Stewart Lee Udall; nephew of Morris K. Udall; cousin of Mark Udall; cousin of Gordon H. Smith), a Senator and a Representative from New Mexico; born in Tucson, Pima County, Ariz., May 18, 1948; graduated from Prescott College, Prescott, Ariz., 1970; Bachelor of Law, Cambridge University, England, 1975; J.D., University of New Mexico School of Law, Albuquerque, N.M., 1977; appointed Assistant United States Attorney for the District of New Mexico, criminal division 1978-1981; served as Chief Counsel to the New Mexico Department of Health and Environment; Attorney General, State of New Mexico, 1990-1998; elected as a Democrat to the One Hundred Sixth and to the four succeeding Congresses (January 3, 1999-January 3, 2009); not a candidate for reelection to the House of Representatives but was elected as a Democrat to the United States Senate in 2008; reelected in 2014 for the term ending January 3, 2021.");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("NV", "H001041", "01863", "412218", "N00027522", "2291", "republican", "active", "false", "false", "false", "false", "I", "male", "white", "Dean Heller", "dean-heller", "1960-05-10", "2011-05-09", "2019-01-03", "38.892839", "-77.004356", "324 Hart Senate Office Building Washington DC 20510", "http://www.heller.senate.gov", "202-224-6244", "https://twitter.com/SenDeanHeller", "https://www.facebook.com/SenDeanHeller", "https://cdn.civil.services/senate/headshots/512x512/dean-heller.jpg", "Dean Heller, a Senator and a Representative from Nevada; born in Castro Valley, Alameda County, Calif., May 10, 1960; graduated from Carson High School, Carson City, Nev.; B.S., University of Southern California, Los Angeles, Calif., 1985; member of the Nevada state assembly 1990-1994; Nevada secretary of state 1995-2007; elected as a Republican to the One Hundred Tenth and to the two succeeding Congresses, and served from January 3, 2007, to May 9, 2011, when he resigned to become a U.S. Senator; appointed May 3, 2011, to the United States Senate for the term ending January 3, 2013, to fill the vacancy caused by the resignation of John E. Ensign; took the oath of office on May 9, 2011; subsequently elected in 2012 for the term ending January 3, 2019.");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("NV", "C001113", null, "412681", null, "69579", "democrat", "active", "false", "false", "false", "false", "III", "female", "hispanic-american", "Catherine Cortez Masto", "catherine-cortez-masto", "1964-03-29", "2017-01-03", "2023-01-03", "38.892839", "-77.004356", "522 Hart Senate Office Building Washington DC 20510", "http://www.masto.senate.gov", "202-224-3542", "https://twitter.com/catherinefornv", "https://www.facebook.com/catherinecortezmasto", "https://cdn.civil.services/senate/headshots/512x512/catherine-cortez-masto.jpg", "Catherine Cortez Masto, a Senator from Nevada; born in Las Vegas, Nev., March 29, 1964; B.A., University of Nevada, 1986; J.D., Gonzaga University School of Law, 1990; admitted to the Nevada bar in 1990; assistant county manager, Clark County, Nev.; chief of staff to Nevada Governor Bob Miller; federal prosecutor; attorney general of Nevada 2007-2015; executive vice chancellor for the Nevada System of Higher Education; elected as a Democrat to the United States Senate in 2016 for the term ending January 3, 2023.");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("NY", "S000148", "01036", "300087", "N00001093", "26976", "democrat", "active", "false", "false", "true", "false", "III", "male", "white", "Charles Schumer", "charles-schumer", "1950-11-23", "1999-01-03", "2023-01-03", "38.892839", "-77.004356", "322 Hart Senate Office Building Washington DC 20510", "http://www.schumer.senate.gov", "202-224-6542", "https://twitter.com/SenSchumer", "https://www.facebook.com/chuckschumer", "https://cdn.civil.services/senate/headshots/512x512/charles-schumer.jpg", "Charles Schumer, a Senator and a Representative from New York; born in Brooklyn, N.Y., November 23, 1950; attended the public schools; graduated from Madison High School, Brooklyn 1967; A.B., Harvard University 1971; J.D., Harvard Law School 1974; admitted to the New York bar in 1975; served in the New York State Assembly 1975-1980; elected as a Democrat to the Ninety-seventh and to the eight succeeding Congresses (January 3, 1981-January 3, 1999); was not a candidate in 1998 for reelection to the U.S. House of Representatives, but was elected as a Democrat to the United States Senate in 1998; reelected in 2004 and again in 2010 for the term ending January 3, 2017; chair, Democratic Senatorial Campaign Committee (2005-2008); chair, Democratic Policy and Communications Committee (2011-); chair, Joint Economic Committee (One Hundred Tenth and One Hundred Eleventh Congresses), Committee on Rules and Administration (One Hundred Eleventh to One Hundred Thirteenth Congresses).");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("NY", "G000555", "01866", "412223", "N00027658", "65147", "democrat", "active", "false", "false", "false", "false", "I", "female", "white", "Kirsten Gillibrand", "kirsten-gillibrand", "1966-12-09", "2009-01-26", "2019-01-03", "38.892542", "-77.007415", "478 Russell Senate Office Building Washington DC 20510", "http://www.gillibrand.senate.gov", "202-224-4451", "https://twitter.com/SenGillibrand", "https://www.facebook.com/KirstenGillibrand", "https://cdn.civil.services/senate/headshots/512x512/kirsten-gillibrand.jpg", "Kirsten Gillibrand, a Senator and a Representative from New York; born in Albany, Albany County, N.Y., December 9, 1966; A.B., Dartmouth College, Hanover, N.H., 1988; J.D., University of California Los Angeles, Los Angeles, Calif., 1991; lawyer, private practice; special counsel, United States Housing and Urban Development; elected as a Democrat to the One Hundred Tenth Congress and to the succeeding Congress, and served from January 3, 2007, to January 26, 2009, when she resigned to become a U.S. Senator; appointed January 23, 2009, to fill the vacancy caused by the resignation of Hillary Clinton; appointment took effect upon her resignation from the House of Representatives on January 26, 2009; took the oath of office on January 27, 2009; elected in 2010 in a special election for the term ending January 3, 2013; reelected in 2012 for the term ending January 3, 2019.");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("OH", "P000449", "00924", "400325", "N00003682", "27008", "republican", "active", "false", "false", "false", "false", "III", "male", "white", "Robert Portman", "robert-portman", "1955-12-19", "2011-01-03", "2023-01-03", "38.892542", "-77.007415", "448 Russell Senate Office Building Washington DC 20510", "http://www.portman.senate.gov", "202-224-3353", "https://twitter.com/SenRobPortman", "https://www.facebook.com/senrobportman", "https://cdn.civil.services/senate/headshots/512x512/robert-portman.jpg", "Robert Portman, a Senator and a Representative from Ohio; born in Cincinnati, Hamilton County, Ohio, December 19, 1955; graduated from the Cincinnati Country Day School, Cincinnati, Ohio; graduated Dartmouth College, Hanover, N.H., B.A., 1979; graduated University of Michigan School of Law, Ann Arbor, Mich., J.D., 1984; associate counsel to President George H. W. Bush 1989; deputy assistant and director, Office of Legislative Affairs, White House Office 1989-1991; elected as a Republican to the One Hundred Third Congress, by special election, to fill the vacancy caused by the resignation of United States Representative Willis D. Gradison, Jr.; reelected to the six succeeding Congresses until his resignation on April 29, 2005 (May 4, 1993-April 29, 2005); U.S. Trade Representative, in the cabinet of President of George W. Bush 2005-2006; Director, Office of Management and Budget, in the cabinet of President George W. Bush 2006-2007; elected as a Republican to the United States Senate in 2010 for the term ending January 3, 2017.");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("OH", "B000944", "00136", "400050", "N00003535", "27018", "democrat", "active", "false", "false", "false", "false", "I", "male", "white", "Sherrod Brown", "sherrod-brown", "1952-11-09", "2007-01-03", "2019-01-03", "38.892839", "-77.004356", "713 Hart Senate Office Building Washington DC 20510", "http://www.brown.senate.gov", "202-224-2315", "https://twitter.com/SenSherrodBrown", "https://www.facebook.com/sherrod", "https://cdn.civil.services/senate/headshots/512x512/sherrod-brown.jpg", "Sherrod Brown, a Senator and a Representative from Ohio; born in Mansfield, Richland County, Ohio, November 9, 1952; B.A., Yale University, New Haven, Conn., 1974; M.A., Ohio State University, Ohio, 1981; member of the faculty, Ohio State University, Mansfield, Ohio, 1979-1981; member of the Ohio State house of representatives, 1975-1982; Ohio secretary of state, 1983-1991; elected as a Democrat to the One Hundred Third and to the six succeeding Congresses (January 3, 1993-January 3, 2007); not a candidate for reelection to the House of Representatives but was elected as a Democrat to the United States Senate in 2006; reelected in 2012 for the term ending January 3, 2019.");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("OK", "L000575", "02050", "412464", "N00031129", "124938", "republican", "active", "false", "false", "false", "false", "III", "male", "white", "James Lankford", "james-lankford", "1968-03-04", "2015-01-03", "2023-01-03", "38.892839", "-77.004356", "316 Hart Senate Office Building Washington DC 20510", "http://www.lankford.senate.gov", "202-224-5754", "https://twitter.com/SenatorLankford", "https://www.facebook.com/SenatorLankford", "https://cdn.civil.services/senate/headshots/512x512/james-lankford.jpg", "James Lankford, a Senator and a Representative from Oklahoma; born in Dallas, Dallas County, Tex., March 4, 1968; B.S., University of Texas, Austin, Tex., 1990; M.Div., Southwestern Theological Baptist Seminary, Ft. Worth, Tex., 1994; youth camp director, 1996-2009; elected as a Republican to the One Hundred Twelfth and to the succeeding Congress (January 3, 2011-January 3, 2015); was not a candidate for reelection to the House of Representatives but was elected as a Republican to the U.S. Senate in the November 4, 2014, special election to the unexpired portion of the term ending January 3, 2017, left vacant by the resignation of Thomas Coburn; took the oath of office on January 3, 2015.");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("OK", "I000024", "00583", "300055", "N00005582", "27027", "republican", "active", "false", "false", "false", "false", "II", "male", "white", "James Inhofe", "james-inhofe", "1934-11-17", "1994-11-17", "2021-01-03", "38.892542", "-77.007415", "205 Russell Senate Office Building Washington DC 20510", "http://www.inhofe.senate.gov", "202-224-4721", "https://twitter.com/InhofePress", "https://www.facebook.com/jiminhofe", "https://cdn.civil.services/senate/headshots/512x512/james-inhofe.jpg", "James Inhofe, a Senator and a Representative from Oklahoma; born in Des Moines, Iowa, November 17, 1934; attended public schools in Tulsa, Okla.; B.A., University of Tulsa 1973; served in the U.S. Army 1957-1958; president, Quaker Life Insurance Company; member, Oklahoma State house of representatives 1967-1969; State Senate 1969-1977; unsuccessful candidate for Governor of Oklahoma 1974, and for the U. S. House of Representatives 1976; mayor of Tulsa 1978-1984; elected as a Republican to the One Hundredth and to the three succeeding Congresses and served from January 3, 1987, to November 15, 1994, when he resigned, having been elected to the United States Senate in the November 8, 1994, special election to the unexpired portion of the term ending January 3, 1997, left vacant by the resignation of David L. Boren; took the oath of office on November 17, 1994; elected to a full term in 1996; reelected in 2002, 2008, and again 2014 for the term ending January 3, 2021; chair, Committee on Environment and Public Works (One Hundred Eighth, One Hundred Ninth, and One Hundred Fourteenth Congresses).");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("OR", "W000779", "01247", "300100", "N00007724", "27036", "democrat", "active", "false", "false", "false", "false", "III", "male", "white", "Ron Wyden", "ron-wyden", "1949-05-03", "1996-02-06", "2023-01-03", "38.892947", "-77.075686", "221 Dirksen Senate Office Building Washington DC 20510", "http://www.wyden.senate.gov", "202-224-5244", "https://twitter.com/RonWyden", "https://www.facebook.com/wyden", "https://cdn.civil.services/senate/headshots/512x512/ron-wyden.jpg", "Ron Wyden, a Senator and a Representative from Oregon; born in Wichita, Sedgwick County, Kans., May 3, 1949; attended the public schools of Palo Alto, Calif.; A.B., Stanford University 1971; J.D., University of Oregon Law School in Eugene 1974; director, Oregon Legal Services for the Elderly 1977-1979; public member, Oregon State Board of Examiners of Nursing Home Administrators 1977-1979; elected as a Democrat to the Ninety-seventh and to the seven succeeding Congresses, and served from January 3, 1981, to February 5, 1996, when he resigned, having been elected to the Senate; elected to the Senate in a special election on January 30, 1996, to fill the unexpired portion of the term ending January 3, 1999, left vacant by the resignation of Robert W. Packwood, and began service on February 5, 1996; reelected in 1998, 2004 and again in 2010 for the term ending January 3, 2017; chair, Committee on Energy and Natural Resources (One Hundred Thirteenth Congress [January 3, 2013-February 12, 2014]), Committee on Finance (One Hundred Thirteenth Congress [February 12, 2014-January 3, 2015]).");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("OR", "M001176", "01900", "412325", "N00029303", "23644", "democrat", "active", "false", "false", "false", "false", "II", "male", "white", "Jeff Merkley", "jeff-merkley", "1956-10-24", "2009-01-03", "2021-01-03", "38.892839", "-77.004356", "313 Hart Senate Office Building Washington DC 20510", "http://www.merkley.senate.gov", "202-224-3753", "https://twitter.com/SenJeffMerkley", "https://www.facebook.com/jeffmerkley", "https://cdn.civil.services/senate/headshots/512x512/jeff-merkley.jpg", "Jeff Merkley, a Senator from Oregon; born in Myrtle Creek, Ore., October 24, 1956; B.A., Stanford University, 1979; M.P.A., Princeton University, 1982; government analyst; nonprofit executive; Oregon State Representative, 1999-2008; speaker of the Oregon State House of Representative, 2007-2008; elected as a Democrat to the United States Senate in 2008; reelected in 2014 for the term ending January 3, 2021.");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("PA", "T000461", "02085", "400408", "N00001489", "24096", "republican", "active", "false", "false", "false", "false", "III", "male", "white", "Patrick Toomey", "patrick-toomey", "1961-11-17", "2011-01-03", "2023-01-03", "38.892542", "-77.007415", "248 Russell Senate Office Building Washington DC 20510", "http://www.toomey.senate.gov", "202-224-4254", "https://twitter.com/SenToomey", "https://www.facebook.com/senatortoomey", "https://cdn.civil.services/senate/headshots/512x512/patrick-toomey.jpg", "Patrick Toomey, a Senator and a Representative from Pennsylvania; born in Providence, Providence County, R.I., November 17, 1961; graduated from LaSalle Academy, Providence, R.I.; graduated Harvard University, Cambridge, Mass., B.A., 1984; elected to Allentown, Pa., Government Study Commission 1994; elected as a Republican to the One Hundred Sixth and to the two succeeding Congresses (January 3, 1999-January 3, 2005); was not a candidate for reelection in 2004, but was an unsuccessful candidate for nomination to the United States Senate; elected as a Republican to the United States Senate in 2010 for the term ending January 3, 2017.");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("PA", "C001070", "01828", "412246", "N00027503", "2541", "democrat", "active", "false", "false", "false", "false", "I", "male", "white", "Robert Casey", "robert-casey", "1960-04-13", "2007-01-03", "2019-01-03", "38.892542", "-77.007415", "393 Russell Senate Office Building Washington DC 20510", "http://www.casey.senate.gov", "202-224-6324", "https://twitter.com/SenBobCasey", "https://www.facebook.com/SenatorBobCasey", "https://cdn.civil.services/senate/headshots/512x512/robert-casey.jpg", "Robert Casey, a Senator from Pennsylvania; born in Scranton, Penn., April 13, 1960; graduated College of the Holy Cross 1982; J.D., Catholic University of America 1988; practiced law in Scranton; Pennsylvania auditor general 1997-2005; unsuccessful candidate for Governor 2002; Pennsylvania State Treasurer 2005-2006; elected as a Democrat to the United States Senate in 2006 for the term commencing January 3, 2007; reelected in 2012 for the term ending January 3, 2019; chair, Joint Economic Committee (One Hundred Twelfth Congress); vice chair, Joint Economic Committee (One Hundred Thirteenth Congress).");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("RI", "W000802", "01823", "412247", "N00027533", "2572", "democrat", "active", "false", "false", "false", "false", "I", "male", "white", "Sheldon Whitehouse", "sheldon-whitehouse", "1955-10-20", "2007-01-03", "2019-01-03", "38.892839", "-77.004356", "530 Hart Senate Office Building Washington DC 20510", "http://www.whitehouse.senate.gov", "202-224-2921", "https://twitter.com/SenWhitehouse", "https://www.facebook.com/SenatorWhitehouse", "https://cdn.civil.services/senate/headshots/512x512/sheldon-whitehouse.jpg", "Sheldon Whitehouse, a Senator from Rhode Island; born in Manhattan, N.Y., October 20, 1955; graduated Yale University 1978; J.D., University of Virginia 1982; director, Rhode Island Department of Business Regulation 1992-1994; United States attorney 1994-1998; Rhode Island State attorney general 1999-2003; unsuccessful candidate for Governor 2002; elected as a Democrat to the United States Senate in 2006 for the term commencing January 3, 2007; reelected in 2012 for the term ending January 3, 2019.");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("RI", "R000122", "00949", "300081", "N00000362", "27060", "democrat", "active", "false", "false", "false", "false", "II", "male", "white", "Jack Reed", "jack-reed", "1949-11-12", "1997-01-03", "2021-01-03", "38.892839", "-77.004356", "728 Hart Senate Office Building Washington DC 20510", "http://www.reed.senate.gov", "202-224-4642", "https://twitter.com/SenJackReed", "https://www.facebook.com/SenJackReed", "https://cdn.civil.services/senate/headshots/512x512/jack-reed.jpg", "Jack Reed, a Senator and a Representative from Rhode Island; born in Providence, R.I., November 12, 1949; attended St. Matthew's Elementary School, Cranston, R.I.; graduated, LaSalle Academy, Providence, R.I., 1967; B.S., United States Military Academy, West Point 1971; M.P.P., Kennedy School of Government, Harvard University 1973; J.D., Harvard Law School 1982; served in the U.S. Army 1971-1979 and Army Reserve 1979-1991; associate professor, Department of Social Sciences, U.S. Military Academy 1977-1979; admitted to the Washington, D.C. bar 1983; lawyer; member, Rhode Island State Senate 1985-1990; elected as a Democrat to the One Hundred Second and to the two succeeding Congresses (January 3, 1991-January 2, 1997); was not a candidate for reelection to the House of Representatives in 1996, but was elected to the United States Senate in 1996; reelected in 2002, 2008, and again in 2014 for the term ending January 3, 2021.");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("SC", "S001184", "02056", "412471", "N00031782", "11940", "republican", "active", "false", "false", "false", "false", "III", "male", "african-american", "Tim Scott", "tim-scott", "1965-09-19", "2013-01-02", "2023-01-03", "38.892839", "-77.004356", "520 Hart Senate Office Building Washington DC 20510", "http://www.scott.senate.gov", "202-224-6121", "https://twitter.com/SenatorTimScott", "https://www.facebook.com/SenatorTimScott", "https://cdn.civil.services/senate/headshots/512x512/tim-scott.jpg", "Tim Scott, a Senator and a Representative from South Carolina; born in North Charleston, Charleston County, S.C., September 19, 1965; attended Presbyterian College, Clinton, S.C., 1983-1984; B.S., Charleston Southern University, Charleston, S.C., 1988; entrepreneur; Charleston County, S.C. council, 1995-2008; unsuccessful candidate for the South Carolina state senate in 1996; Member of the South Carolina house of representatives, 2009-2010; elected as a Republican to the One Hundred Twelfth Congress, and served from January 3, 2011, to January 2, 2013, when he resigned to become a U.S. Senator; appointed January 2, 2013, to fill the vacancy caused by the resignation of James DeMint; appointment took effect upon his resignation from the House of Representatives on January 2, 2013; took the oath of office on January 3, 2013; elected in 2014 in a special election for the term ending January 3, 2017.");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("SC", "G000359", "00452", "300047", "N00009975", "21992", "republican", "active", "false", "false", "false", "false", "II", "male", "white", "Lindsey Graham", "lindsey-graham", "1955-07-09", "2003-01-03", "2021-01-03", "38.892542", "-77.007415", "290 Russell Senate Office Building Washington DC 20510", "http://www.lgraham.senate.gov", "202-224-5972", "https://twitter.com/GrahamBlog", "https://www.facebook.com/USSenatorLindseyGraham", "https://cdn.civil.services/senate/headshots/512x512/lindsey-graham.jpg", "Lindsey Graham, a Senator and a Representative from South Carolina; born in Central, Pickens County, S.C., July 9, 1955; graduated from Daniel High School, Central, S.C. 1973; B.A., University of South Carolina, Columbia 1977; J.D., University of South Carolina School of Law 1981; United States Air Force 1982-1988; South Carolina Air National Guard 1989-1995; United States Air Force Reserves 1995-present; lawyer, private practice; assistant county attorney, Oconee County, S.C. 1988-1992; city attorney for Central, S.C. 1990-1994; Member of the South Carolina state house of representatives 1992-1994; elected as a Republican to the House of Representatives for the One Hundred Fourth and to the three succeeding Congresses (January 3, 1995-January 3, 2003); one of the managers appointed by the House of Representatives in 1998 to conduct the impeachment proceedings against President William Clinton; was not a candidate for reelection in 2002, but was elected as a Republican to the U.S. Senate in 2002; reelected in 2008, and again in 2014 for the term ending January 3, 2021.");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("SD", "T000250", "01534", "400546", "N00004572", "398", "republican", "active", "false", "false", "false", "false", "III", "male", "white", "John Thune", "john-thune", "1961-01-07", "2005-01-03", "2023-01-03", "38.892947", "-77.075686", "511 Dirksen Senate Office Building Washington DC 20510", "http://www.thune.senate.gov", "202-224-2321", "https://twitter.com/SenJohnThune", "https://www.facebook.com/johnthune", "https://cdn.civil.services/senate/headshots/512x512/john-thune.jpg", "John Thune, a Senator and a Representative from South Dakota; born in Pierre, Hughes County, S. Dak., January 7, 1961; graduated from Jones County High School, S. Dak., 1979; B.S., Biola University, La Mirada, Calif., 1983; M.B.A., University of South Dakota, Vermillion, S. Dak., 1984; executive director, South Dakota state municipal league; board of directors, National League of Cities; staff, United States Senator James Abdnor of South Dakota 1985-1986; South Dakota state Republican party executive director 1989-1991; director, South Dakota state railroad division 1991-1993; director, South Dakota state municipal league 1993-1996; elected as a Republican to the One Hundred Fifth and to the two succeeding Congresses (January 3, 1997-January 3, 2003); was not a candidate for reelection to the One Hundred Eighth Congress in 2002, but was an unsuccessful candidate for the United States Senate; elected as a Republican to the U.S. Senate in 2004; reelected in 2010 for the term ending January 3, 2017; vice-chair, Republican Conference (2009); chair, Republican Policy Committee (2009-2012); chair, Republican Conference (2012-); chair, Committee on Commerce, Science, and Transportation (One Hundred Fourteenth Congress).");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("SD", "R000605", "02288", "412669", "N00035187", null, "republican", "active", "false", "false", "false", "false", "II", "male", "white", "Mike Rounds", "mike-rounds", "1954-10-24", "2015-01-03", "2021-01-03", "38.892839", "-77.004356", "502 Hart Senate Office Building Washington DC 20510", "http://www.rounds.senate.gov", "202-224-5842", "https://twitter.com/SenatorRounds", "https://www.facebook.com/SenatorMikeRounds", "https://cdn.civil.services/senate/headshots/512x512/mike-rounds.jpg", "Mike Rounds, a Senator from South Dakota; born in Huron, Beadle County, S. Dak., October 24, 1954; B.S., South Dakota State University, 1977; insurance and real estate executive; member of the South Dakota state Senate 1991-2000, serving as majority leader 1995-2000; governor of South Dakota 2003-2011; elected as a Republican to the United States Senate in 2014 for the term ending January 3, 2021.");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("TN", "C001071", "01825", "412248", "N00027441", "65905", "republican", "active", "false", "false", "false", "false", "I", "male", "white", "Bob Corker", "bob-corker", "1952-08-24", "2007-01-03", "2019-01-03", "38.892947", "-77.075686", "425 Dirksen Senate Office Building Washington DC 20510", "http://www.corker.senate.gov", "202-224-3344", "https://twitter.com/SenBobCorker", "https://www.facebook.com/bobcorker", "https://cdn.civil.services/senate/headshots/512x512/bob-corker.jpg", "Bob Corker, a Senator from Tennessee; born in Orangeburg, S.C., August 24, 1952; attended the public schools in Chattanooga, Tenn.; graduated with a bachelor of science degree in industrial management, University of Tennessee 1974; commercial real estate developer; construction company owner; unsuccessful candidate for the United States Senate 1994; commissioner, Tennessee Finance and Administration Department 1995-1996; mayor of Chattanooga 2001-2005; elected as a Republican to the United States Senate in 2006 for the term commencing January 3, 2007; reelected in 2012 for the term ending January 3, 2019; Chair, Committee on Foreign Relations (One Hundred Fourteenth Congress).");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("TN", "A000360", "01695", "300002", "N00009888", "15691", "republican", "active", "false", "false", "false", "false", "II", "male", "white", "Lamar Alexander", "lamar-alexander", "1940-07-03", "2003-01-03", "2021-01-03", "38.892947", "-77.075686", "455 Dirksen Senate Office Building Washington DC 20510", "http://www.alexander.senate.gov", "202-224-4944", "https://twitter.com/SenAlexander", "https://www.facebook.com/senatorlamaralexander", "https://cdn.civil.services/senate/headshots/512x512/lamar-alexander.jpg", "Lamar Alexander, a Senator from Tennessee; born in Maryville, Tennessee, on July 3, 1940; B.A., Vanderbilt University 1962; J.D., New York University Law School 1965; governor of Tennessee 1979-1987; chairman of the National Governors Association 1985-1986; U.S. secretary of education 1991-1993; elected as a Republican to the U.S. Senate in 2002; reelected in 2008, and again in 2014 for the term ending January 3, 2021; chair, Republican Conference (2008-2012); chair, Committee on Health, Education, Labor, and Pensions (One Hundred Fourteenth Congress).");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("TX", "C001098", "02175", "412573", "N00033085", "135705", "republican", "active", "false", "false", "false", "false", "I", "male", "hispanic-american", "Ted Cruz", "ted-cruz", "1970-12-22", "2013-01-03", "2019-01-03", "38.892542", "-77.007415", "404 Russell Senate Office Building Washington DC 20510", "http://www.cruz.senate.gov", "202-224-5922", "https://twitter.com/SenTedCruz", "https://www.facebook.com/SenatorTedCruz", "https://cdn.civil.services/senate/headshots/512x512/ted-cruz.jpg", "Ted Cruz, a Senator from Texas; born in Calgary, Alberta, Canada, December 22, 1970; graduated Princeton University, B.A., 1992; graduated Harvard University, J.D., 1995; law clerk to Chief Justice of the United States William Rehnquist; associate deputy attorney general, U.S. Department of Justice; Director of the Office of Policy Planning, Federal Trade Commission; solicitor general of Texas 2003-2008; lawyer; elected as a Republican to the United States Senate in 2012 for the term ending January 3, 2019.");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("TX", "C001056", "01692", "300027", "N00024852", "15375", "republican", "active", "false", "true", "false", "false", "II", "male", "white", "John Cornyn", "john-cornyn", "1952-02-02", "2002-12-01", "2021-01-03", "38.892839", "-77.004356", "517 Hart Senate Office Building Washington DC 20510", "http://www.cornyn.senate.gov", "202-224-2934", "https://twitter.com/JohnCornyn", "https://www.facebook.com/sen.johncornyn", "https://cdn.civil.services/senate/headshots/512x512/john-cornyn.jpg", "John Cornyn, a Senator from Texas; born in Houston, Texas, on February 2, 1952; B.A., Trinity University 1973; J.D., St. Mary's School of Law 1977; LLM, University of Virginia 1995; attorney; Bexar County district court judge 1984-1990; Texas Supreme Court 1990-1997; Texas state attorney general 1999-2002; elected as a Republican to the U.S. Senate in 2002; subsequently appointed to the remainder of the term left vacant by the resignation of William Philip Gramm, and took the oath of office on December 2, 2002; reelected in 2008, and again in 2014 for the term ending January 3, 2021; Republican Conference vice-chair (2007-2009); chair, National Republican Senatorial Committee (2009-2012); Republican party whip (2013-).");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("UT", "L000577", "02080", "412495", "N00031696", "66395", "republican", "active", "false", "false", "false", "false", "III", "male", "white", "Mike Lee", "mike-lee", "1971-06-04", "2011-01-03", "2023-01-03", "38.892542", "-77.007415", "361A Russell Senate Office Building Washington DC 20510", "http://www.lee.senate.gov", "202-224-5444", "https://twitter.com/SenMikeLee", "https://www.facebook.com/senatormikelee", "https://cdn.civil.services/senate/headshots/512x512/mike-lee.jpg", "Mike Lee, a Senator from Utah; born in Mesa, Ariz., June 4, 1971; graduated Brigham Young University, B.A., 1994; graduated Brigham Young University, J.D., 1997; law clerk to 3rd Circuit Court of Appeals Justice Samuel Alito 1998; lawyer; assistant U.S. attorney 2002-2005; counsel to Utah Governor John Huntsman 2005-2006; law clerk to United States Supreme Court Justice Samuel Alito 2006-2007; lawyer; elected as a Republican to the United States Senate in 2010 for the term ending January 3, 2017.");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("UT", "H000338", "01351", "300052", "N00009869", "53352", "republican", "active", "false", "false", "false", "false", "I", "male", "white", "Orrin Hatch", "orrin-hatch", "1934-03-22", "1977-01-03", "2019-01-03", "38.892839", "-77.004356", "104 Hart Senate Office Building Washington DC 20510", "http://www.hatch.senate.gov", "202-224-5251", "https://twitter.com/SenOrrinHatch", "https://www.facebook.com/senatororrinhatch", "https://cdn.civil.services/senate/headshots/512x512/orrin-hatch.jpg", "Orrin Hatch, a Senator from Utah; born in Homestead Park, Allegheny County, Pa., March 22, 1934; received early education in the public schools of Pittsburgh, Pa.; graduated, Brigham Young University 1959; graduated, University of Pittsburgh Law School 1962; admitted to the Pennsylvania bar in 1963 and commenced practice in Pittsburgh; moved to Utah in 1969 and continued practicing law; elected as a Republican to the United States Senate in 1976; reelected in 1982, 1988, 1994, 2000, 2006, and again in 2012 for the term ending January 3, 2019; President pro tempore (2015-); chairman, Committee on Labor and Human Resources (Ninety-seventh to Ninety-ninth Congresses), Committee on the Judiciary (One Hundred Fourth to One Hundred Sixth Congresses; One Hundred Seventh Congress [January 20, 2001-June 6, 2001], One Hundred Eighth Congress), Committee on Finance (One Hundred Fourteenth Congress).");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("VA", "K000384", "02176", "412582", "N00033177", "50772", "democrat", "active", "false", "false", "false", "false", "I", "male", "white", "Timothy Kaine", "timothy-kaine", "1958-02-26", "2013-01-03", "2019-01-03", "38.892542", "-77.007415", "231 Russell Senate Office Building Washington DC 20510", "http://www.kaine.senate.gov", "202-224-4024", "https://twitter.com/SenKaineOffice", "https://www.facebook.com/SenatorKaine", "https://cdn.civil.services/senate/headshots/512x512/timothy-kaine.jpg", "Timothy Kaine, a Senator from Virginia; born in St. Paul, Minn., February 26, 1958; graduated University of Missouri, B.A., 1979; graduated Harvard University, J.D., 1983; lawyer; Richmond City Council 1994-1998; mayor of Richmond, Va., 1998-2001; lieutenant governor of Virginia 2002-2006; governor of Virginia 2006-2010; chairman of the Democratic National Committee 2009-2011; elected as a Democrat to the United States Senate in 2012 for the term ending January 3, 2019.");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("VA", "W000805", "01897", "412321", "N00002097", "535", "democrat", "active", "false", "false", "false", "false", "II", "male", "white", "Mark Warner", "mark-warner", "1954-12-15", "2009-01-03", "2021-01-03", "38.892542", "-77.007415", "475 Russell Senate Office Building Washington DC 20510", "http://www.warner.senate.gov", "202-224-2023", "https://twitter.com/MarkWarner", "https://www.facebook.com/MarkRWarner", "https://cdn.civil.services/senate/headshots/512x512/mark-warner.jpg", "Mark Warner, a Senator from Virginia; born in Indianapolis, Ind., December 15, 1954; B.A., George Washington University, 1977; J.D., Harvard Law School, 1980; worked on the staff of Senator Christopher Dodd; engaged in the high-technology business; co-founded the company that became Nextel; Virginia Democratic Party Chairman, 1993-1995; unsuccessful candidate for election to the United States Senate in 1996; Governor of Virginia, 2002-2006; chairman of the National Governors Association 2004-2005; elected as a Democrat to the United States Senate in 2008; reelected in 2014 for the term ending January 3, 2021.");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("VT", "L000174", "01383", "300065", "N00009918", "53353", "democrat", "active", "false", "false", "false", "false", "III", "male", "white", "Patrick Leahy", "patrick-leahy", "1940-03-31", "1975-01-03", "2023-01-03", "38.892542", "-77.007415", "437 Russell Senate Office Building Washington DC 20510", "http://www.leahy.senate.gov", "202-224-4242", "https://twitter.com/SenatorLeahy", "https://www.facebook.com/SenatorPatrickLeahy", "https://cdn.civil.services/senate/headshots/512x512/patrick-leahy.jpg", "Patrick Leahy, a Senator from Vermont; born in Montpelier, Washington County, Vt., March 31, 1940; graduated, St. Michael's College, Winooski, Vt., 1961; received J.D. degree from Georgetown University 1964; admitted to the Vermont bar in 1964 and commenced practice in Burlington; State's attorney, Chittenden County, Vt., 1966-1974; elected as a Democrat to the United States Senate in 1974; reelected in 1980, 1986, 1992,1998, 2004 and again in 2010 for the term ending January 3, 2017; President pro tempore (December 17, 2012-January 3, 2015); chair, Committee on Agriculture, Nutrition and Forestry (One Hundredth through One Hundred Third Congresses), Committee on the Judiciary (One Hundred Seventh Congress [January 3-20, 2001; June 6, 2001-January 3, 2003], One Hundred Tenth to One Hundred Thirteenth Congresses).");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("VT", "S000033", "01010", "400357", "N00000528", "27110", "independent", "active", "false", "false", "false", "false", "I", "male", "white", "Bernard Sanders", "bernard-sanders", "1941-09-08", "2007-01-03", "2019-01-03", "38.892542", "-77.007415", "332 Dirksen Senate Office Building Washington DC 20510", "http://www.sanders.senate.gov", "202-224-5141", "https://twitter.com/SenSanders", "https://www.facebook.com/senatorsanders", "https://cdn.civil.services/senate/headshots/512x512/bernard-sanders.jpg", "Bernard Sanders, a Senator and a Representative from Vermont; born in Brooklyn, Kings County, N.Y., September 8, 1941; graduated from Madison High School, Brooklyn, N.Y.; B.S., University of Chicago, Chicago, Ill., 1964; Faculty, Harvard University, Cambridge, Mass., 1989; faculty, Hamilton College, Clinton, N.Y., 1990; carpenter; journalist; unsuccessful independent candidate for election to the United States Senate in 1972 and 1974; unsuccessful independent candidate for election for governor of Vermont in 1972, 1976 and 1986; mayor of Burlington, Vt., 1981-1989; unsuccessful independent candidate to the One Hundred First Congress in 1988; elected as an Independent to the One Hundred Second and to the seven succeeding Congresses (January 3, 1991-January 3, 2007); was not a candidate for reelection to the House of Representatives but was elected as an Independent to the United States Senate in 2006 for the term commencing January 3, 2007; reelected in 2012 for the term ending January 3, 2019; chair, Committee on Veterans Affairs (One Hundred Thirteenth Congress).");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("WA", "M001111", "01409", "300076", "N00007876", "53358", "democrat", "active", "false", "false", "false", "false", "III", "female", "white", "Patty Murray", "patty-murray", "1950-10-11", "1993-01-03", "2023-01-03", "38.892542", "-77.007415", "154 Russell Senate Office Building Washington DC 20510", "http://www.murray.senate.gov", "202-224-2621", "https://twitter.com/PattyMurray", "https://www.facebook.com/pattymurray", "https://cdn.civil.services/senate/headshots/512x512/patty-murray.jpg", "Patty Murray, a Senator from Washington; born in Seattle, King County, Wash., October 11, 1950; graduated, Washington State University 1972; education volunteer 1977-1984; instructor, Shoreline Community College, Shoreline, Wash., 1984-1987; citizen lobbyist for environmental and educational issues 1983-1988; Member, board of directors, Shoreline School District 1985-1989, serving as president and legislative representative for two terms; member, Washington state Senate 1988-1992, Democratic whip 1990-1992; elected as a Democrat to the United States Senate in 1992; reelected in 1998, 2004 and again in 2010 for the term ending January 3, 2017; chairwoman, Democratic Senatorial Campaign Committee (2001-2003, 2011-2013), Committee on Veterans Affairs (One Hundred Twelfth Congress), Committee on the Budget (One Hundred Thirteenth Congress); Democratic Conference secretary (2007-).");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("WA", "C000127", "00172", "300018", "N00007836", "27122", "democrat", "active", "false", "false", "false", "false", "I", "female", "white", "Maria Cantwell", "maria-cantwell", "1958-10-13", "2001-01-03", "2019-01-03", "38.892839", "-77.004356", "511 Hart Senate Office Building Washington DC 20510", "http://www.cantwell.senate.gov", "202-224-3441", "https://twitter.com/SenatorCantwell", "https://www.facebook.com/senatorcantwell", "https://cdn.civil.services/senate/headshots/512x512/maria-cantwell.jpg", "Maria Cantwell, a Senator and a Representative from Washington; born in Indianapolis, Ind., October 13, 1958; attended public schools in Indianapolis; B.A., Miami University of Ohio 1980; pursued an academic course at the Miami University European Center, Luxembourg; public relations consultant; Washington State Representative 1987-1993; elected as a Democrat to the 103rd Congress (January 3, 1993-January 3, 1995); unsuccessful candidate for reelection to the 104th Congress; elected as a Democrat to the U.S. Senate on November 7, 2000, for the term commencing January 3, 2001; reelected in 2006 and again in 2012 for the term ending January 3, 2019; chair, Committee on Indian Affairs (One Hundred Thirteenth Congress [January 3, 2013-February 12, 2014]), Committee on Small Business and Entrepreneurship (One Hundred Thirteenth Congress [February 12, 2014-January 3, 2015]).");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("WI", "J000293", "02086", "412496", "N00032546", "126217", "republican", "active", "false", "false", "false", "false", "III", "male", "white", "Ron Johnson", "ron-johnson", "1955-04-08", "2011-01-03", "2023-01-03", "38.892839", "-77.004356", "328 Hart Senate Office Building Washington DC 20510", "http://www.ronjohnson.senate.gov", "202-224-5323", "https://twitter.com/SenRonJohnson", "https://www.facebook.com/senronjohnson", "https://cdn.civil.services/senate/headshots/512x512/ron-johnson.jpg", "Ron Johnson, a Senator from Wisconsin; born on April 8, 1955, in Mankato, Minn.; graduated University of Minnesota, B.S., 1977; studied business administration, University of Minnesota, 1977-1979; plastics manufacturer; accountant; elected as a Republican to the United States Senate in 2010 for the term ending January 3, 2017; chair, Committee on Homeland Security and Governmental Affairs (One Hundred Fourteenth Congress).");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("WI", "B001230", "01558", "400013", "N00004367", "3470", "democrat", "active", "false", "false", "false", "false", "I", "female", "white", "Tammy Baldwin", "tammy-baldwin", "1962-02-11", "2013-01-03", "2019-01-03", "38.892839", "-77.004356", "717 Hart Washington DC 20510", "http://www.baldwin.senate.gov", "202-224-5653", "https://twitter.com/SenatorBaldwin", "https://www.facebook.com/TammyBaldwin", "https://cdn.civil.services/senate/headshots/512x512/tammy-baldwin.jpg", "Tammy Baldwin, a Senator and a Representative from Wisconsin; born in Madison, Dane County, Wis., February 11, 1962; graduated from Madison West High School, Madison, Wis., 1980; A.B., Smith College, Northampton, Mass., 1984; J.D., University of Wisconsin Law School, Madison, Wis., 1989; lawyer, private practice; Dane County, Wis., board of supervisors, 1986-1994; member of the Wisconsin state assembly, 1993-1999; elected as a Democrat to the One Hundred Sixth and to the six succeeding Congresses (January 3, 1999-January 3, 2013); was not a candidate for reelection to the House of Representatives but was elected as a Democrat to the United States Senate in 2012 for the term ending January 3, 2019.");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("WV", "M001183", "01983", "412391", "N00032838", "7547", "democrat", "active", "false", "false", "false", "false", "I", "male", "white", "Joe Manchin", "joe-manchin", "1947-08-24", "2010-11-15", "2019-01-03", "38.892839", "-77.004356", "306 Hart Senate Office Building Washington DC 20510", "http://www.manchin.senate.gov", "202-224-3954", "https://twitter.com/Sen_JoeManchin", "https://www.facebook.com/JoeManchinIII", "https://cdn.civil.services/senate/headshots/512x512/joe-manchin.jpg", "Joe Manchin, a Senator from West Virginia; born August 24, 1947, in Farmington, Marion County, West Virginia; graduated Farmington High School, Farmington, WV, 1965; B.A., West Virginia University, 1970; businessman; member of the West Virginia house of delegates 1982-1986; member of the West Virginia state Senate 1986-1996; unsuccessful candidate for the Democratic gubernatorial nomination in 1996; Secretary of State, West Virginia 2000-2004; elected governor of West Virginia in 2004 and reelected in 2008; chairman of the National Governors Association 2010; elected as a Democrat to the U.S. Senate in a special election on November 2, 2010, to fill the vacancy caused by the death of Robert C. Byrd, a seat subsequently held by appointed Senator Carte Goodwin, and took the oath of office on November 15, 2010; reelected in 2012 for the term ending January 3, 2019.");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("WV", "C001047", "01676", "400061", "N00009771", "11701", "republican", "active", "false", "false", "false", "false", "II", "female", "white", "Shelley Capito", "shelley-capito", "1953-11-26", "2015-01-03", "2021-01-03", "38.892542", "-77.007415", "172 Russell Senate Office Building Washington DC 20510", "http://www.capito.senate.gov", "202-224-6472", "https://twitter.com/SenCapito", "https://www.facebook.com/senshelley", "https://cdn.civil.services/senate/headshots/512x512/shelley-capito.jpg", "Shelley Capito (daughter of Arch Alfred Moore, Jr.), a Senator and a Representative from West Virginia; born in Glendale, Marshall County, W.Va., November 26, 1953; B.S., Duke University, Durham, N.C., 1975; M.Ed., University of Virginia, Charlottesville, Va., 1976; college counselor; Member, West Virginia state house of representatives, 1997-2001; elected as a Republican to the One Hundred Seventh and to the six succeeding Congresses (January 3, 2001-January 3, 2015); was not a candidate for reelection to the House of Representatives but was elected as a Republican to the United States Senate in 2014 for the term ending January 3, 2021.");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("WY", "B001261", "01881", "412251", "N00006236", "52662", "republican", "active", "false", "false", "false", "false", "I", "male", "white", "John Barrasso", "john-barrasso", "1952-07-21", "2007-06-25", "2019-01-03", "38.892542", "-77.007415", "307 Dirksen Senate Office Building Washington DC 20510", "http://www.barrasso.senate.gov", "202-224-6441", "https://twitter.com/SenJohnBarrasso", "https://www.facebook.com/johnbarrasso", "https://cdn.civil.services/senate/headshots/512x512/john-barrasso.jpg", "John Barrasso, a Senator from Wyoming; born on July 21, 1952, in Reading, Penn.; graduated Georgetown University, Washington, D.C., B.S. 1974; graduated Georgetown University School of Medicine, M.D. 1978; residency at Yale Medical School, New Haven, Conn.; orthopedic surgeon, private practice; chief of staff of the Wyoming Medical Center, Casper, Wyo.; Wyoming State Senate 2002-2007; appointed to the United States Senate on June 22, 2007, to fill the vacancy caused by the death of Craig L. Thomas; took the oath of office on June 25, 2007; elected in 2008 in a special election for the term ending January 3, 2013; reelected in 2012 for the term ending January 3, 2019; vice-chair, Republican Conference (2010-2012); chair, Republican Policy Committee (2012-); chair, Committee on Indian Affairs (One Hundred Fourteenth Congress).");
INSERT INTO `senate` (`state`, `bioguide`, `thomas`, `govtrack`, `opensecrets`, `votesmart`, `party`, `status`, `majority_leader`, `majority_whip`, `minority_leader`, `minority_whip`, `class`, `gender`, `ethnicity`, `name`, `slug`, `date_of_birth`, `entered_office`, `term_end`, `latitude`, `longitude`, `address`, `website`, `phone`, `twitter_url`, `facebook_url`, `photo_url`, `biography`) VALUES ("WY", "E000285", "01542", "300041", "N00006249", "558", "republican", "active", "false", "false", "false", "false", "II", "male", "white", "Michael Enzi", "michael-enzi", "1944-02-01", "1997-01-03", "2021-01-03", "38.892542", "-77.007415", "379A Russell Senate Office Building Washington DC 20510", "http://www.enzi.senate.gov", "202-224-3424", "https://twitter.com/SenatorEnzi", "https://www.facebook.com/mikeenzi", "https://cdn.civil.services/senate/headshots/512x512/michael-enzi.jpg", "Michael Enzi, a Senator from Wyoming; born in Bremerton, Wash., February 1, 1944; attended public schools of Thermopolis and Sheridan, Wyo.; graduated, Sheridan High School 1962; received degree in accounting, George Washington University 1966; M.B.A. in retail marketing from Denver University 1968; served in Wyoming National Guard 1967-73; owned and operated family shoe stores in Gillette and Sheridan, Wyo., and Miles City, Mont.; Accountant; Certified Professional in Human Resources, 1993-present; Mayor of Gillette 1975-1982; Member, Wyoming house of representatives 1987-1991; Member, Wyoming state Senate 1991-1996; Commissioner, Western Interstate Commission for Higher Education 1995-1996; elected as a Republican to the United States Senate in 1996; reelected in 2002, 2008, and again in 2014 for the term ending January 3, 2021; Chair, Committee on Health, Education, Labor, and Pensions (One Hundred Ninth Congress), Committee on Budget (One Hundred Fourteenth Congress).");