us-governors.sql

INSERT INTO `us-governors` (`state_name`, `state_name_slug`, `state_code`, `state_code_slug`, `votesmart`, `title`, `party`, `name`, `name_slug`, `first_name`, `middle_name`, `last_name`, `name_suffix`, `goes_by`, `pronunciation`, `gender`, `ethnicity`, `religion`, `openly_lgbtq`, `date_of_birth`, `entered_office`, `term_end`, `biography`, `phone`, `fax`, `latitude`, `longitude`, `address_complete`, `address_number`, `address_prefix`, `address_street`, `address_sec_unit_type`, `address_sec_unit_num`, `address_city`, `address_state`, `address_zipcode`, `address_type`, `website`, `contact_page`, `facebook_url`, `twitter_handle`, `twitter_url`, `photo_url`) VALUES ("Alabama", "alabama", "AL", "al", "27642", "governor", "republican", "Kay Ivey", "kay-ivey", "Kay", null, "Ivey", null, null, "KAY EYE-vee", "female", "white-american", "baptist", null, "1944-10-15", "2017-04-10", "2019-01-01", "Kay Ellen Ivey (born October 15, 1944) is an American politician and educator who is the 54th and current Governor of Alabama since April 2017. Ivey, a member of the Republican Party, served as the 38th Alabama State Treasurer from 2003 to 2011, and later became the 30th Lieutenant Governor of Alabama; she was the first Republican woman elected in this state, serving from January 2011 until April 2017.", "334-242-7900", "334-242-4661", "32.3773052", "-86.3010403", "600 Dexter Avenue, Montgomery, AL 36130", "600", null, "Dexter", null, null, "Montgomery", "AL", "36130", "Avenue", "http://governor.alabama.gov", "http://governor.alabama.gov/contact", "https://www.facebook.com/KayIveyAL", "LtGovIvey", "https://twitter.com/LtGovIvey", "https://cdn.civil.services/us-governors/headshots/512x512/kay-ivey.jpg");
INSERT INTO `us-governors` (`state_name`, `state_name_slug`, `state_code`, `state_code_slug`, `votesmart`, `title`, `party`, `name`, `name_slug`, `first_name`, `middle_name`, `last_name`, `name_suffix`, `goes_by`, `pronunciation`, `gender`, `ethnicity`, `religion`, `openly_lgbtq`, `date_of_birth`, `entered_office`, `term_end`, `biography`, `phone`, `fax`, `latitude`, `longitude`, `address_complete`, `address_number`, `address_prefix`, `address_street`, `address_sec_unit_type`, `address_sec_unit_num`, `address_city`, `address_state`, `address_zipcode`, `address_type`, `website`, `contact_page`, `facebook_url`, `twitter_handle`, `twitter_url`, `photo_url`) VALUES ("Alaska", "alaska", "AK", "ak", "123219", "governor", "independent", "William Walker", "william-walker", "William", null, "Walker", null, "Bill", "BIL WAH-ker", "male", "white-american", "christian", null, "1951-04-16", "2014-12-01", "2019-01-01", "William Martin "Bill" Walker (born April 16, 1951) is an American attorney and politician who is the 13th and current Governor of Alaska. He is the second native-born governor of Alaska after William A. Egan (1959–1966 and 1970–1974).", "907-465-3500", "407-465-3532", "27.7812652", "-82.6321373", "Office of Governor Bill Walker, 3rd Floor, State Capitol, P.O Box 110001, Juneau, AK 99811", null, null, "of", "Office", null, null, null, null, null, "https://gov.alaska.gov", "https://gov.alaska.gov/contact/email-the-governor/", "https://www.facebook.com/Governor.BillWalker", "AkGovBillWalker", "https://twitter.com/AkGovBillWalker", "https://cdn.civil.services/us-governors/headshots/512x512/william-walker.jpg");
INSERT INTO `us-governors` (`state_name`, `state_name_slug`, `state_code`, `state_code_slug`, `votesmart`, `title`, `party`, `name`, `name_slug`, `first_name`, `middle_name`, `last_name`, `name_suffix`, `goes_by`, `pronunciation`, `gender`, `ethnicity`, `religion`, `openly_lgbtq`, `date_of_birth`, `entered_office`, `term_end`, `biography`, `phone`, `fax`, `latitude`, `longitude`, `address_complete`, `address_number`, `address_prefix`, `address_street`, `address_sec_unit_type`, `address_sec_unit_num`, `address_city`, `address_state`, `address_zipcode`, `address_type`, `website`, `contact_page`, `facebook_url`, `twitter_handle`, `twitter_url`, `photo_url`) VALUES ("Arizona", "arizona", "AZ", "az", "123548", "governor", "republican", "Douglas Ducey", "douglas-ducey", "Douglas", "Anthony", "Ducey", null, "Doug", "DOAG DOO-see", "male", "white-american", "roman-catholic", null, "1964-04-09", "2015-01-05", "2019-01-01", "Douglas Anthony "Doug" Ducey (born April 9, 1964) is an American businessman who is the 23rd and current governor of the U.S. State of Arizona. He is a member of the Republican Party, and was sworn in as governor on January 5, 2015. Prior to his governorship, he served as the state's 42nd treasurer. He is also the first man to serve as Arizona Governor in over 17 years.", "520-628-6580", null, "33.4481208", "-112.0992236", "1700 West Washington Street, Phoenix, AZ 85007", "1700", "West", "Washington", null, null, "Phoenix", "AZ", "85007", "Street", "http://azgovernor.gov", "http://azgovernor.gov/engage/form/contact-governor-ducey", "https://www.facebook.com/dougducey", "dougducey", "https://twitter.com/dougducey", "https://cdn.civil.services/us-governors/headshots/512x512/douglas-ducey.jpg");
INSERT INTO `us-governors` (`state_name`, `state_name_slug`, `state_code`, `state_code_slug`, `votesmart`, `title`, `party`, `name`, `name_slug`, `first_name`, `middle_name`, `last_name`, `name_suffix`, `goes_by`, `pronunciation`, `gender`, `ethnicity`, `religion`, `openly_lgbtq`, `date_of_birth`, `entered_office`, `term_end`, `biography`, `phone`, `fax`, `latitude`, `longitude`, `address_complete`, `address_number`, `address_prefix`, `address_street`, `address_sec_unit_type`, `address_sec_unit_num`, `address_city`, `address_state`, `address_zipcode`, `address_type`, `website`, `contact_page`, `facebook_url`, `twitter_handle`, `twitter_url`, `photo_url`) VALUES ("Arkansas", "arkansas", "AR", "ar", "732", "governor", "republican", "Asa Hutchinson", "asa-hutchinson", "Asa", null, "Hutchinson", null, null, "AY-suh HU-chin-sun", "male", "white-american", "baptist", null, "1950-12-03", "2015-01-13", "2019-01-01", "William Asa Hutchinson II (born December 3, 1950) is an American businessman, attorney, politician who has been the 46th Governor of Arkansas since 2015. Previously he was U.S. Attorney for the Fort Smith-based Western District of Arkansas, U.S. Congressman from the Third District of Arkansas, Administrator of the U.S. Drug Enforcement Administration (DEA) and the first Undersecretary for Border & Transportation Security at the U.S. Department of Homeland Security.", "501-682-2345", "34.746779", "34.746779", "-92.2912417", "State Capitol Room 250, 500 Woodlane Street, Little Rock, AR 72201", null, null, "State", null, null, null, null, null, null, "http://governor.arkansas.gov", "http://governor.arkansas.gov/contact-info", "https://www.facebook.com/asaforarkansas", "AsaHutchinson", "https://twitter.com/AsaHutchinson", "https://cdn.civil.services/us-governors/headshots/512x512/asa-hutchinson.jpg");
INSERT INTO `us-governors` (`state_name`, `state_name_slug`, `state_code`, `state_code_slug`, `votesmart`, `title`, `party`, `name`, `name_slug`, `first_name`, `middle_name`, `last_name`, `name_suffix`, `goes_by`, `pronunciation`, `gender`, `ethnicity`, `religion`, `openly_lgbtq`, `date_of_birth`, `entered_office`, `term_end`, `biography`, `phone`, `fax`, `latitude`, `longitude`, `address_complete`, `address_number`, `address_prefix`, `address_street`, `address_sec_unit_type`, `address_sec_unit_num`, `address_city`, `address_state`, `address_zipcode`, `address_type`, `website`, `contact_page`, `facebook_url`, `twitter_handle`, `twitter_url`, `photo_url`) VALUES ("California", "california", "CA", "ca", "69557", "governor", "democrat", "Edmund Brown", "edmund-brown", "Edmund", "G.", "Brown", "Jr.", "Jerry", "JE-ree BROWN", "male", "white-american", "unspecified", null, "1938-04-07", "2011-01-03", "2019-01-01", "Edmund Gerald "Jerry" Brown Jr. (born April 7, 1938) is an American politician and lawyer who has served as the 39th Governor of California since 2011. A member of the Democratic Party, Brown previously served as the 34th governor from 1975 to 1983, and is the longest-serving governor in California history. Prior to and following his first governorship, Brown served in numerous state, local and party positions, including three times a candidate for the Democratic nomination for President of the United States.", "916-445-2841", "916-558-3160", "38.5789026", "-121.4965295", "State Capitol, Suite 1173, Sacramento, CA 95814", null, null, "State", null, null, null, null, null, null, "http://gov.ca.gov", "https://govnews.gov.ca.gov/gov39mail/mail.php", "https://www.facebook.com/jerrybrown", "JerryBrownGov", "https://twitter.com/JerryBrownGov", "https://cdn.civil.services/us-governors/headshots/512x512/edmund-brown.jpg");
INSERT INTO `us-governors` (`state_name`, `state_name_slug`, `state_code`, `state_code_slug`, `votesmart`, `title`, `party`, `name`, `name_slug`, `first_name`, `middle_name`, `last_name`, `name_suffix`, `goes_by`, `pronunciation`, `gender`, `ethnicity`, `religion`, `openly_lgbtq`, `date_of_birth`, `entered_office`, `term_end`, `biography`, `phone`, `fax`, `latitude`, `longitude`, `address_complete`, `address_number`, `address_prefix`, `address_street`, `address_sec_unit_type`, `address_sec_unit_num`, `address_city`, `address_state`, `address_zipcode`, `address_type`, `website`, `contact_page`, `facebook_url`, `twitter_handle`, `twitter_url`, `photo_url`) VALUES ("Colorado", "colorado", "CO", "co", "71547", "governor", "democrat", "John Hickenlooper", "john-hickenlooper", "John", null, "Hickenlooper", null, null, "JOAN HIK-en-LOO-per", "male", "white-american", "unspecified", null, "1952-02-07", "2011-01-11", "2019-01-01", "John Wright Hickenlooper, Jr. (born February 7, 1952), is an American politician, and the 42nd and current Governor of Colorado, in office since 2011. He is a member of the Democratic Party. Born in Narberth, Pennsylvania, Hickenlooper is a graduate of Wesleyan University. After his career as a geologist, Hickenlooper entered a career in business and cofounded the Wynkoop Brewing Company in Denver. Hickenlooper was elected the 43rd mayor of Denver in 2003, serving two terms, until 2011.", "303-866-2471", "303-866-2003", "39.7393292", "-104.9870009", "200 East Colfax Avenue, 136 State Capitol Building, Denver, CO 80203", "200", "East", "Colfax", null, null, null, null, null, "Avenue", "http://www.colorado.gov/governor/", "https://www.colorado.gov/governor/contact", "https://www.facebook.com/JohnHickenlooper", "hickforco", "https://twitter.com/hickforco", "https://cdn.civil.services/us-governors/headshots/512x512/john-hickenlooper.jpg");
INSERT INTO `us-governors` (`state_name`, `state_name_slug`, `state_code`, `state_code_slug`, `votesmart`, `title`, `party`, `name`, `name_slug`, `first_name`, `middle_name`, `last_name`, `name_suffix`, `goes_by`, `pronunciation`, `gender`, `ethnicity`, `religion`, `openly_lgbtq`, `date_of_birth`, `entered_office`, `term_end`, `biography`, `phone`, `fax`, `latitude`, `longitude`, `address_complete`, `address_number`, `address_prefix`, `address_street`, `address_sec_unit_type`, `address_sec_unit_num`, `address_city`, `address_state`, `address_zipcode`, `address_type`, `website`, `contact_page`, `facebook_url`, `twitter_handle`, `twitter_url`, `photo_url`) VALUES ("Connecticut", "connecticut", "CT", "ct", "66223", "governor", "democrat", "Dannel Malloy", "dannel-malloy", "Dannel", null, "Malloy", null, null, "DA-nel MA-loy", "male", "white-american", "unspecified", null, "1955-07-21", "2011-01-05", "2019-01-01", "Dannel Patrick "Dan" Malloy (born July 21, 1955) is an American politician who is the 88th and current Governor of Connecticut. A member of the Democratic Party, Malloy has served as governor since 2011. He is currently the chair of the Democratic Governors Association.", "860-566-4840", "860-524-7395", "41.7638385", "-72.6863461", "State Capitol, 210 Capitol Ave, Hartford, CT 06106", null, null, "State", null, null, null, null, null, null, "http://portal.ct.gov/governor", "http://portal.ct.gov/en/Contact-and-Help/Ask-a-Question", "https://www.facebook.com/GovMalloyOffice", "GovMalloyOffice", "https://twitter.com/GovMalloyOffice", "https://cdn.civil.services/us-governors/headshots/512x512/dannel-malloy.jpg");
INSERT INTO `us-governors` (`state_name`, `state_name_slug`, `state_code`, `state_code_slug`, `votesmart`, `title`, `party`, `name`, `name_slug`, `first_name`, `middle_name`, `last_name`, `name_suffix`, `goes_by`, `pronunciation`, `gender`, `ethnicity`, `religion`, `openly_lgbtq`, `date_of_birth`, `entered_office`, `term_end`, `biography`, `phone`, `fax`, `latitude`, `longitude`, `address_complete`, `address_number`, `address_prefix`, `address_street`, `address_sec_unit_type`, `address_sec_unit_num`, `address_city`, `address_state`, `address_zipcode`, `address_type`, `website`, `contact_page`, `facebook_url`, `twitter_handle`, `twitter_url`, `photo_url`) VALUES ("Delaware", "delaware", "DE", "de", "53658", "governor", "democrat", "John Carney", "john-carney", "John", null, "Carney", null, null, "JOAN KARR-nee", "male", "white-american", "roman-catholic", null, "1956-05-20", "2017-01-17", "2019-01-01", "John Charles Carney Jr. (born May 20, 1956) is an American politician who is the 74th and current Governor of Delaware since January 2017. A member of the Democratic Party, he served as the U.S. Representative for Delaware's at-large congressional district from 2011 to 2017 prior to his governorship. Carney was also the 24th Lieutenant Governor of Delaware from 2001 to 2009 and served as Delaware's Secretary of Finance.", "302-577-4101", null, "39.743532", "-75.5484957", "Carvel State Office Building, 820 North French Street, 12th Floor, Wilmington, DE 19801", null, null, "Carvel", null, null, null, null, null, null, "http://governor.delaware.gov", "http://delaware.gov/help/degov-contact.shtml", "https://www.facebook.com/JohnCarneyDE", "johncarneyde", "https://twitter.com/johncarneyde", "https://cdn.civil.services/us-governors/headshots/512x512/john-carney.jpg");
INSERT INTO `us-governors` (`state_name`, `state_name_slug`, `state_code`, `state_code_slug`, `votesmart`, `title`, `party`, `name`, `name_slug`, `first_name`, `middle_name`, `last_name`, `name_suffix`, `goes_by`, `pronunciation`, `gender`, `ethnicity`, `religion`, `openly_lgbtq`, `date_of_birth`, `entered_office`, `term_end`, `biography`, `phone`, `fax`, `latitude`, `longitude`, `address_complete`, `address_number`, `address_prefix`, `address_street`, `address_sec_unit_type`, `address_sec_unit_num`, `address_city`, `address_state`, `address_zipcode`, `address_type`, `website`, `contact_page`, `facebook_url`, `twitter_handle`, `twitter_url`, `photo_url`) VALUES ("Florida", "florida", "FL", "fl", "124204", "governor", "republican", "Rick Scott", "rick-scott", "Rick", null, "Scott", null, null, "RIK SKAHT", "male", "white-american", "christian", null, "1952-12-01", "2011-01-04", "2019-01-01", "Richard Lynn "Rick" Scott (born December 1, 1952) is an American businessman and politician who has been the 45th Governor of Florida, since 2011. He is a member of the Republican Party of Florida.", "850-488-7146", null, "30.437722", "-84.2836701", "State of Florida, The Capitol, 400 South Monroe Street, Tallahassee, FL 32399", null, null, "State", null, null, "of", "Florida", null, null, "http://www.flgov.com", "http://www.flgov.com/contact-governor/", "https://www.facebook.com/governorrickscott", "FLGovScott", "https://twitter.com/FLGovScott", "https://cdn.civil.services/us-governors/headshots/512x512/rick-scott.jpg");
INSERT INTO `us-governors` (`state_name`, `state_name_slug`, `state_code`, `state_code_slug`, `votesmart`, `title`, `party`, `name`, `name_slug`, `first_name`, `middle_name`, `last_name`, `name_suffix`, `goes_by`, `pronunciation`, `gender`, `ethnicity`, `religion`, `openly_lgbtq`, `date_of_birth`, `entered_office`, `term_end`, `biography`, `phone`, `fax`, `latitude`, `longitude`, `address_complete`, `address_number`, `address_prefix`, `address_street`, `address_sec_unit_type`, `address_sec_unit_num`, `address_city`, `address_state`, `address_zipcode`, `address_type`, `website`, `contact_page`, `facebook_url`, `twitter_handle`, `twitter_url`, `photo_url`) VALUES ("Georgia", "georgia", "GA", "ga", "26824", "governor", "republican", "Nathan Deal", "nathan-deal", "Nathan", null, "Deal", null, null, "NAY-then DE-al", "male", "white-american", "christian", null, "1942-08-25", "2011-01-10", "2019-01-01", "John Nathan Deal (born August 25, 1942) is an American politician who is the 82nd and current Governor of the U.S. state of Georgia since January 2011. He was elected to the U.S. House of Representatives as a Democrat in 1992, but switched to the Republican Party in 1995. On March 1, 2010, Deal announced his resignation from Congress to run for governor of Georgia.", "404-656-1776", "404-657-7332", "33.7489981", "-84.3903046", "206 Washington Street, 111 State Capitol, Atlanta, GA 30334", "206", null, "Washington", null, null, null, null, null, "Street", "http://gov.georgia.gov", "https://gov.georgia.gov/webform/contact-governor-domestic-form", "https://www.facebook.com/GovernorDeal", "GovernorDeal", "https://twitter.com/GovernorDeal", "https://cdn.civil.services/us-governors/headshots/512x512/nathan-deal.jpg");
INSERT INTO `us-governors` (`state_name`, `state_name_slug`, `state_code`, `state_code_slug`, `votesmart`, `title`, `party`, `name`, `name_slug`, `first_name`, `middle_name`, `last_name`, `name_suffix`, `goes_by`, `pronunciation`, `gender`, `ethnicity`, `religion`, `openly_lgbtq`, `date_of_birth`, `entered_office`, `term_end`, `biography`, `phone`, `fax`, `latitude`, `longitude`, `address_complete`, `address_number`, `address_prefix`, `address_street`, `address_sec_unit_type`, `address_sec_unit_num`, `address_city`, `address_state`, `address_zipcode`, `address_type`, `website`, `contact_page`, `facebook_url`, `twitter_handle`, `twitter_url`, `photo_url`) VALUES ("Hawaii", "hawaii", "HI", "hi", "3406", "governor", "democrat", "David Ige", "david-ige", "David", null, "Ige", null, null, "DAY-vid EE-gay", "male", "pacific-islander", "unspecified", null, "1957-01-15", "2014-12-01", "2019-01-01", "David Yutaka Ige (born January 15, 1957) is an American politician who serves as the eighth and current Governor of Hawaii, in office since 2014. A Democrat, he previously served in the Hawaii State Senate, representing the 16th district, from 1995 to 2014. In the 2014 Hawaii gubernatorial election, he won the Democratic primary by defeating incumbent Governor Neil Abercrombie with 66% of the vote.", "808-586-0034", "808-586-0006", "21.307764", "-157.8594961", "415 South Beretania Street, Honolulu, HI 96813", "415", "South", "Beretania", null, null, "Honolulu", "HI", "96813", "Street", "http://governor.hawaii.gov", "https://governor.hawaii.gov/contact-us/contact-the-governor/", "https://www.facebook.com/GovernorDavidIge", "GovHawaii", "https://twitter.com/GovHawaii", "https://cdn.civil.services/us-governors/headshots/512x512/david-ige.jpg");
INSERT INTO `us-governors` (`state_name`, `state_name_slug`, `state_code`, `state_code_slug`, `votesmart`, `title`, `party`, `name`, `name_slug`, `first_name`, `middle_name`, `last_name`, `name_suffix`, `goes_by`, `pronunciation`, `gender`, `ethnicity`, `religion`, `openly_lgbtq`, `date_of_birth`, `entered_office`, `term_end`, `biography`, `phone`, `fax`, `latitude`, `longitude`, `address_complete`, `address_number`, `address_prefix`, `address_street`, `address_sec_unit_type`, `address_sec_unit_num`, `address_city`, `address_state`, `address_zipcode`, `address_type`, `website`, `contact_page`, `facebook_url`, `twitter_handle`, `twitter_url`, `photo_url`) VALUES ("Idaho", "idaho", "ID", "id", "1679", "governor", "republican", "Clement Otter", "clement-otter", "Clement", "Leroy", "Otter", null, "Butch", "BUUCH AH-ter", "male", "white-american", "roman-catholic", null, "1942-05-03", "2007-01-01", "2019-01-01", "Clement Leroy "Butch" Otter (born May 3, 1942) is an American businessman and politician who has served as the 32nd Governor of Idaho since January 2007. He is a member of the Republican Party. Having served for 10 years, 116 days, Otter is currently the longest-serving incumbent Governor in the United States whose time in office has run consecutively.", "208-334-2100", "208-334-3454", "43.6174911", "-116.2025323", "P.O. Box 83720, Boise, ID 83720", null, null, "Boise", "PO. Box", "83720", null, null, null, null, "http://gov.idaho.gov/", "https://gov.idaho.gov/ourgov/contact.html", "https://www.facebook.com/Governor-C-L-Butch-Otter-292986829831/", "butchotter", "https://twitter.com/butchotter", "https://cdn.civil.services/us-governors/headshots/512x512/clement-otter.jpg");
INSERT INTO `us-governors` (`state_name`, `state_name_slug`, `state_code`, `state_code_slug`, `votesmart`, `title`, `party`, `name`, `name_slug`, `first_name`, `middle_name`, `last_name`, `name_suffix`, `goes_by`, `pronunciation`, `gender`, `ethnicity`, `religion`, `openly_lgbtq`, `date_of_birth`, `entered_office`, `term_end`, `biography`, `phone`, `fax`, `latitude`, `longitude`, `address_complete`, `address_number`, `address_prefix`, `address_street`, `address_sec_unit_type`, `address_sec_unit_num`, `address_city`, `address_state`, `address_zipcode`, `address_type`, `website`, `contact_page`, `facebook_url`, `twitter_handle`, `twitter_url`, `photo_url`) VALUES ("Illinois", "illinois", "IL", "il", "147492", "governor", "republican", "Bruce Rauner", "bruce-rauner", "Bruce", null, "Rauner", null, null, "BROOS ROW-ner", "male", "white-american", "unspecified", null, "1957-01-12", "2015-01-12", "2019-01-01", "Bruce Vincent Rauner (born February 18, 1957) is an American businessman, philanthropist, and politician. He is the 42nd and current Governor of Illinois, serving since January 12, 2015. Prior to his election, he was the Chairman of R8 Capital Partners and Chairman of the private equity firm GTCR, based in Chicago.", "312-814-2121", null, "39.7984385", "-89.6573079", "207 State House, Springfield, IL 62706", "207", null, "State House", null, null, "Springfield", "IL", "62706", null, "https://www.illinois.gov/gov/pages/default.aspx", "https://www.illinois.gov/gov/contactus/Pages/default.aspx", "https://www.facebook.com/GovRauner", "GovRauner", "https://twitter.com/GovRauner", "https://cdn.civil.services/us-governors/headshots/512x512/bruce-rauner.jpg");
INSERT INTO `us-governors` (`state_name`, `state_name_slug`, `state_code`, `state_code_slug`, `votesmart`, `title`, `party`, `name`, `name_slug`, `first_name`, `middle_name`, `last_name`, `name_suffix`, `goes_by`, `pronunciation`, `gender`, `ethnicity`, `religion`, `openly_lgbtq`, `date_of_birth`, `entered_office`, `term_end`, `biography`, `phone`, `fax`, `latitude`, `longitude`, `address_complete`, `address_number`, `address_prefix`, `address_street`, `address_sec_unit_type`, `address_sec_unit_num`, `address_city`, `address_state`, `address_zipcode`, `address_type`, `website`, `contact_page`, `facebook_url`, `twitter_handle`, `twitter_url`, `photo_url`) VALUES ("Indiana", "indiana", "IN", "in", "34349", "governor", "republican", "Eric Holcomb", "eric-holcomb", "Eric", "Joseph", "Holcomb", null, null, "E-rik HAWL-koam", "male", "white-american", "church-of-god", null, "1968-05-02", "2017-01-09", "2019-01-01", "Eric Joseph Holcomb (born May 2, 1968) is an American politician who serves as the 51st and current Governor of Indiana since January 2017. Prior to his election to the governorship, he was also the 51st Lieutenant Governor of Indiana under Governor Mike Pence, now the 48th and current Vice President of the United States.", "317-232-4567", "317-232-3443", "39.7984385", "-89.6573079", "State House, Room 206 Indianapolis, IN 46204", null, null, "State", null, null, null, null, null, null, "http://www.in.gov/gov/", "http://www.in.gov/core/help.html", "https://www.facebook.com/GovHolcomb", "GovHolcomb", "https://twitter.com/GovHolcomb", "https://cdn.civil.services/us-governors/headshots/512x512/eric-holcomb.jpg");
INSERT INTO `us-governors` (`state_name`, `state_name_slug`, `state_code`, `state_code_slug`, `votesmart`, `title`, `party`, `name`, `name_slug`, `first_name`, `middle_name`, `last_name`, `name_suffix`, `goes_by`, `pronunciation`, `gender`, `ethnicity`, `religion`, `openly_lgbtq`, `date_of_birth`, `entered_office`, `term_end`, `biography`, `phone`, `fax`, `latitude`, `longitude`, `address_complete`, `address_number`, `address_prefix`, `address_street`, `address_sec_unit_type`, `address_sec_unit_num`, `address_city`, `address_state`, `address_zipcode`, `address_type`, `website`, `contact_page`, `facebook_url`, `twitter_handle`, `twitter_url`, `photo_url`) VALUES ("Iowa", "iowa", "IA", "ia", "103324", "governor", "republican", "Kimberly Reynolds", "kimberly-reynolds", "Kimberly", "Kay", "Reynolds", null, "Kim", "KIM RE-neldz", "female", "white-american", "unspecified", null, "1959-08-04", "2017-05-24", "2019-01-01", "Kimberly Kay Reynold is an American politician serving as the 43rd and current Governor of Iowa since 2017. A Republican, she previously served as the Lieutenant Governor of Iowa from 2011 to 2017 and assumed the governorship when incumbent Governor Terry Branstad became the United States Ambassador to China. Reynolds is the first female Governor of Iowa.", "515-281-5211", null, "41.5912077", "-93.6059486", "1007 East Grand Ave., Des Moines, IA 50319", "1007", "East", "Grand", null, null, "Des Moines", "IA", "50319", "Ave", "https://governor.iowa.gov", "https://governor.iowa.gov/contact", "https://www.facebook.com/IAGovernor", "kimreynoldsia", "https://twitter.com/kimreynoldsia", "https://cdn.civil.services/us-governors/headshots/512x512/kimberly-reynolds.jpg");
INSERT INTO `us-governors` (`state_name`, `state_name_slug`, `state_code`, `state_code_slug`, `votesmart`, `title`, `party`, `name`, `name_slug`, `first_name`, `middle_name`, `last_name`, `name_suffix`, `goes_by`, `pronunciation`, `gender`, `ethnicity`, `religion`, `openly_lgbtq`, `date_of_birth`, `entered_office`, `term_end`, `biography`, `phone`, `fax`, `latitude`, `longitude`, `address_complete`, `address_number`, `address_prefix`, `address_street`, `address_sec_unit_type`, `address_sec_unit_num`, `address_city`, `address_state`, `address_zipcode`, `address_type`, `website`, `contact_page`, `facebook_url`, `twitter_handle`, `twitter_url`, `photo_url`) VALUES ("Kansas", "kansas", "KS", "ks", "34449", "governor", "republican", "Jeffrey Colyer", "jeffrey-colyer", "Jeffrey", "William", "Colyer", null, "Jeff", "JEF KAWL-ee-er", "male", "white-american", "unspecified", null, "1960-06-03", "2018-01-31", "2019-01-01", "Jeffrey William Colyer (born June 3, 1960) is an American surgeon and politician who has served as the 47th Governor of Kansas since 2018. A member of the Republican Party, he previously served as the 49th Lieutenant Governor of Kansas from 2011 until 2018, as a member of the Kansas Senate from 2009 to 2011, and in the Kansas House of Representatives from 2007 to 2009.", "785-296-3232", null, "39.0481528", "-95.6803429", "300 Southwest, 10th Avenue, Suite 241S, Topeka, KS 66612", "300", "Southwest", "10th", "Suite", "241S", "Topeka", "KS", "66612", "Avenue", "https://governor.kansas.gov/", "https://governor.kansas.gov/contact/contact-the-governor/", "https://www.facebook.com/DrJeffColyer/", "drjeffcolyer", "https://twitter.com/drjeffcolyer", "https://cdn.civil.services/us-governors/headshots/512x512/jeffrey-colyer.jpg");
INSERT INTO `us-governors` (`state_name`, `state_name_slug`, `state_code`, `state_code_slug`, `votesmart`, `title`, `party`, `name`, `name_slug`, `first_name`, `middle_name`, `last_name`, `name_suffix`, `goes_by`, `pronunciation`, `gender`, `ethnicity`, `religion`, `openly_lgbtq`, `date_of_birth`, `entered_office`, `term_end`, `biography`, `phone`, `fax`, `latitude`, `longitude`, `address_complete`, `address_number`, `address_prefix`, `address_street`, `address_sec_unit_type`, `address_sec_unit_num`, `address_city`, `address_state`, `address_zipcode`, `address_type`, `website`, `contact_page`, `facebook_url`, `twitter_handle`, `twitter_url`, `photo_url`) VALUES ("Kentucky", "kentucky", "KY", "ky", "146094", "governor", "republican", "Matthew Bevin", "matthew-bevin", "Matthew", "Griswold", "Bevin", null, "Matt", "MAT BE-vin", "male", "white-american", "christian", null, "1967-01-09", "2015-12-08", "2019-01-01", "Matthew Griswold "Matt" Bevin (born January 9, 1967) is an American businessman and politician who currently serves as the 62nd Governor of Kentucky. He is the third Republican elected Governor of Kentucky since World War II, after Ernie Fletcher (2003–2007) and Louie B. Nunn (1967–1971).", "502-564-2611", "502-564-2517", "38.1867792", "-84.877415", "700 Capitol Avenue, Suite 100, Frankfort, KY 40601", "700", null, "Capitol", "Suite", "100", "Frankfort", "KY", "40601", "Avenue", "http://governor.ky.gov", "http://governor.ky.gov/pages/contact.aspx", "https://www.facebook.com/GovMattBevin", "GovMattBevin", "https://twitter.com/GovMattBevin", "https://cdn.civil.services/us-governors/headshots/512x512/matthew-bevin.jpg");
INSERT INTO `us-governors` (`state_name`, `state_name_slug`, `state_code`, `state_code_slug`, `votesmart`, `title`, `party`, `name`, `name_slug`, `first_name`, `middle_name`, `last_name`, `name_suffix`, `goes_by`, `pronunciation`, `gender`, `ethnicity`, `religion`, `openly_lgbtq`, `date_of_birth`, `entered_office`, `term_end`, `biography`, `phone`, `fax`, `latitude`, `longitude`, `address_complete`, `address_number`, `address_prefix`, `address_street`, `address_sec_unit_type`, `address_sec_unit_num`, `address_city`, `address_state`, `address_zipcode`, `address_type`, `website`, `contact_page`, `facebook_url`, `twitter_handle`, `twitter_url`, `photo_url`) VALUES ("Louisiana", "louisiana", "LA", "la", "72012", "governor", "democrat", "John Edwards", "john-edwards", "John", "Bel", "Edwards", null, null, "JOAN ED-werdz", "male", "white-american", "unspecified", null, "1966-09-16", "2016-01-11", "2019-01-01", "John Bel Edwards (born September 16, 1966) is an American politician and lawyer who is the 56th and current Governor of Louisiana, in office since January 11, 2016. He was previously the Minority Leader of the Louisiana House of Representatives and represented the 72nd District for two terms. He left the state legislature to run for governor in 2015.", "623-773-7328", null, "33.5766177", "-112.242531", "8401 West Monroe Street, Peoria, AZ 85345", "8401", "West", "Monroe", null, null, "Peoria", "AZ", "85345", "Street", "http://gov.louisiana.gov/", "http://gov.louisiana.gov/page/contact", "https://www.facebook.com/LouisianaGov", "louisianagov", "https://twitter.com/louisianagov", "https://cdn.civil.services/us-governors/headshots/512x512/john-edwards.jpg");
INSERT INTO `us-governors` (`state_name`, `state_name_slug`, `state_code`, `state_code_slug`, `votesmart`, `title`, `party`, `name`, `name_slug`, `first_name`, `middle_name`, `last_name`, `name_suffix`, `goes_by`, `pronunciation`, `gender`, `ethnicity`, `religion`, `openly_lgbtq`, `date_of_birth`, `entered_office`, `term_end`, `biography`, `phone`, `fax`, `latitude`, `longitude`, `address_complete`, `address_number`, `address_prefix`, `address_street`, `address_sec_unit_type`, `address_sec_unit_num`, `address_city`, `address_state`, `address_zipcode`, `address_type`, `website`, `contact_page`, `facebook_url`, `twitter_handle`, `twitter_url`, `photo_url`) VALUES ("Maine", "maine", "ME", "me", "120907", "governor", "republican", "Paul LePage", "paul-lepage", "Paul", "Richard", "LePage", null, null, "PA-ul LEE-payj", "male", "white-american", "unspecified", null, "1948-10-09", "2011-01-05", "2019-01-01", "Paul Richard LePage (born October 9, 1948) is an American businessman and Republican Party politician who is currently the 74th Governor of Maine. Born in Lewiston, LePage grew up with seventeen siblings. After some initial difficulty entering college due to speaking French as his first language, he succeeded in obtaining a Bachelor of Science in business administration in finance and accounting from Husson College, later earning a Master of Business Administration from the University of Maine.", "207-287-3531", "207-287-1034", "44.3044824", "-69.7835823", "Office of the Governor, Number 1, State House Station, Augusta, ME 04333", null, null, "of", "Office", null, null, null, null, null, "http://www.maine.gov/governor/lepage/", "http://www.maine.gov/governor/lepage/citizen_services/ideas-suggestions.shtml", "https://www.facebook.com/mainesgov", "Governor_LePage", "https://twitter.com/Governor_LePage", "https://cdn.civil.services/us-governors/headshots/512x512/paul-lepage.jpg");
INSERT INTO `us-governors` (`state_name`, `state_name_slug`, `state_code`, `state_code_slug`, `votesmart`, `title`, `party`, `name`, `name_slug`, `first_name`, `middle_name`, `last_name`, `name_suffix`, `goes_by`, `pronunciation`, `gender`, `ethnicity`, `religion`, `openly_lgbtq`, `date_of_birth`, `entered_office`, `term_end`, `biography`, `phone`, `fax`, `latitude`, `longitude`, `address_complete`, `address_number`, `address_prefix`, `address_street`, `address_sec_unit_type`, `address_sec_unit_num`, `address_city`, `address_state`, `address_zipcode`, `address_type`, `website`, `contact_page`, `facebook_url`, `twitter_handle`, `twitter_url`, `photo_url`) VALUES ("Maryland", "maryland", "MD", "md", "147764", "governor", "republican", "Lawrence Hogan", "lawrence-hogan", "Lawrence", "Joseph", "Hogan", "Jr.", "Larry", "LA-ree HOH-gen", "male", "white-american", "unspecified", null, "1956-05-25", "2015-01-21", "2019-01-01", "Lawrence Joseph "Larry" Hogan Jr. (born May 25, 1956) is an American politician who currently serves as the 62nd Governor of Maryland, in office since January 2015. He is only the second Republican governor in Maryland in nearly 50 years, and the first Maryland governor from Anne Arundel County to be elected in over 100 years.", "410-974-3901", null, "38.9788597", "-76.4932177", "100 State Circle, Annapolis, MD 21401", "100", null, "State", null, null, "Annapolis", "MD", "21401", "Circle", "http://governor.maryland.gov/", "http://governor.maryland.gov/mail/default.asp", "https://www.facebook.com/larryhoganmd", "LarryHogan", "https://twitter.com/LarryHogan", "https://cdn.civil.services/us-governors/headshots/512x512/lawrence-hogan.jpg");
INSERT INTO `us-governors` (`state_name`, `state_name_slug`, `state_code`, `state_code_slug`, `votesmart`, `title`, `party`, `name`, `name_slug`, `first_name`, `middle_name`, `last_name`, `name_suffix`, `goes_by`, `pronunciation`, `gender`, `ethnicity`, `religion`, `openly_lgbtq`, `date_of_birth`, `entered_office`, `term_end`, `biography`, `phone`, `fax`, `latitude`, `longitude`, `address_complete`, `address_number`, `address_prefix`, `address_street`, `address_sec_unit_type`, `address_sec_unit_num`, `address_city`, `address_state`, `address_zipcode`, `address_type`, `website`, `contact_page`, `facebook_url`, `twitter_handle`, `twitter_url`, `photo_url`) VALUES ("Massachusetts", "massachusetts", "MA", "ma", "124824", "governor", "republican", "Charles Baker", "charles-baker", "Charles", "Duane", "Baker", "Jr.", "Charlie", "CHARR-lee BAY-ker", "male", "white-american", "protestant", null, "1956-11-13", "2015-01-08", "2019-01-01", "Charles Duane "Charlie" Baker Jr. (born November 13, 1956), is an American businessman and the 72nd and current Governor of Massachusetts, having been sworn into office on January 8, 2015. He was a cabinet official under two Massachusetts governors, spent ten years as CEO of Harvard Pilgrim Health Care and was also the Republican nominee for governor of Massachusetts in an unsuccessful 2010 bid.", "617-725-4005", "617-727-9725", "42.3587723", "-71.0660006", "Massachusetts State House, Office of the Governor, Room 280 Boston, MA 02133", null, null, "Massachusetts", null, null, null, null, null, null, "http://www.mass.gov/governor/", "http://www.mass.gov/governor/constituent-services/contact-governor-office/", "https://www.facebook.com/CharlieBakerMA", "massgovernor", "https://twitter.com/massgovernor", "https://cdn.civil.services/us-governors/headshots/512x512/charles-baker.jpg");
INSERT INTO `us-governors` (`state_name`, `state_name_slug`, `state_code`, `state_code_slug`, `votesmart`, `title`, `party`, `name`, `name_slug`, `first_name`, `middle_name`, `last_name`, `name_suffix`, `goes_by`, `pronunciation`, `gender`, `ethnicity`, `religion`, `openly_lgbtq`, `date_of_birth`, `entered_office`, `term_end`, `biography`, `phone`, `fax`, `latitude`, `longitude`, `address_complete`, `address_number`, `address_prefix`, `address_street`, `address_sec_unit_type`, `address_sec_unit_num`, `address_city`, `address_state`, `address_zipcode`, `address_type`, `website`, `contact_page`, `facebook_url`, `twitter_handle`, `twitter_url`, `photo_url`) VALUES ("Michigan", "michigan", "MI", "mi", "124011", "governor", "republican", "Richard Snyder", "richard-snyder", "Richard", "Dale", "Snyder", null, "Rick", "RIK SNY-der", "male", "white-american", "unspecified", null, "1958-08-19", "2011-01-01", "2019-01-01", "Richard Dale "Rick" Snyder (born August 19, 1958) is an American politician, business executive, venture capitalist, and accountant. He is the 48th and current Governor of Michigan. A member of the Republican Party, he assumed office as governor on January 1, 2011. From 2005 to 2007, Snyder served as the chairman of the board of Gateway, Inc., based in Irvine, California.", "517-373-3400", "517-335-6863", "42.6800039", "-84.502194", "Post Office Box 30013, Lansing, MI 48909", null, null, "Post", "Office", null, null, null, null, null, "http://www.michigan.gov/snyder", "https://somgovweb.state.mi.us/GovRelations/ShareOpinion.aspx", "https://www.facebook.com/GovernorRickSnyder", "onetoughnerd", "https://twitter.com/onetoughnerd", "https://cdn.civil.services/us-governors/headshots/512x512/richard-snyder.jpg");
INSERT INTO `us-governors` (`state_name`, `state_name_slug`, `state_code`, `state_code_slug`, `votesmart`, `title`, `party`, `name`, `name_slug`, `first_name`, `middle_name`, `last_name`, `name_suffix`, `goes_by`, `pronunciation`, `gender`, `ethnicity`, `religion`, `openly_lgbtq`, `date_of_birth`, `entered_office`, `term_end`, `biography`, `phone`, `fax`, `latitude`, `longitude`, `address_complete`, `address_number`, `address_prefix`, `address_street`, `address_sec_unit_type`, `address_sec_unit_num`, `address_city`, `address_state`, `address_zipcode`, `address_type`, `website`, `contact_page`, `facebook_url`, `twitter_handle`, `twitter_url`, `photo_url`) VALUES ("Minnesota", "minnesota", "MN", "mn", "20301", "governor", "democrat", "Mark Dayton", "mark-dayton", "Mark", "Brandt", "Dayton", null, null, "MARK DAY-ten", "male", "white-american", "presbyterian", null, "1947-01-26", "2011-01-03", "2019-01-01", "Mark Brandt Dayton (born January 26, 1947) is an American politician who is the 40th and current Governor of Minnesota, serving since 2011. He was previously a United States Senator for Minnesota from 2001 to 2007, and the Minnesota State Auditor from 1991 to 1995. He is a member of the Minnesota Democratic–Farmer–Labor Party (DFL), which affiliates with the national Democratic Party.", "651-201-3400", "651-797-1850", "44.9551538", "-93.104427", "130 State Capitol, 75 Reverend Dr. Martin Luther King Jr. Boulevard, Saint Paul, MN 55155", "130", null, "State", null, null, null, null, null, null, "https://mn.gov/governor/", "https://mn.gov/governor/contact-us/form/", "https://www.facebook.com/GovMarkDayton", "GovMarkDayton", "https://twitter.com/GovMarkDayton", "https://cdn.civil.services/us-governors/headshots/512x512/mark-dayton.jpg");
INSERT INTO `us-governors` (`state_name`, `state_name_slug`, `state_code`, `state_code_slug`, `votesmart`, `title`, `party`, `name`, `name_slug`, `first_name`, `middle_name`, `last_name`, `name_suffix`, `goes_by`, `pronunciation`, `gender`, `ethnicity`, `religion`, `openly_lgbtq`, `date_of_birth`, `entered_office`, `term_end`, `biography`, `phone`, `fax`, `latitude`, `longitude`, `address_complete`, `address_number`, `address_prefix`, `address_street`, `address_sec_unit_type`, `address_sec_unit_num`, `address_city`, `address_state`, `address_zipcode`, `address_type`, `website`, `contact_page`, `facebook_url`, `twitter_handle`, `twitter_url`, `photo_url`) VALUES ("Mississippi", "mississippi", "MS", "ms", "2126", "governor", "republican", "Dewey Bryant", "dewey-bryant", "Dewey", "Phillip", "Bryant", null, "Phil", "FIL BRY-ant", "male", "white-american", "united-methodist", null, "1954-12-09", "2012-01-10", "2019-01-01", "Dewey Phillip "Phil" Bryant (born December 9, 1954) is an American politician from the state of Mississippi who has served as the 64th Governor of Mississippi since 2012. He previously served as the 31st Lieutenant Governor of Mississippi from 2008 to 2012 and as the 40th State Auditor of Mississippi from 1996 to 2008.", "601-359-3150", "601-359-3741", "32.3504041", "-90.1551408", "P.O. Box 139, Jackson, MS 39205", null, null, "Jackson", "PO. Box", "139", null, null, null, null, "http://www.governorbryant.ms.gov/", "http://www.governorbryant.ms.gov/Pages/Contact.aspx", "https://www.facebook.com/im4phil", "PhilBryantMS", "https://twitter.com/PhilBryantMS", "https://cdn.civil.services/us-governors/headshots/512x512/dewey-bryant.jpg");
INSERT INTO `us-governors` (`state_name`, `state_name_slug`, `state_code`, `state_code_slug`, `votesmart`, `title`, `party`, `name`, `name_slug`, `first_name`, `middle_name`, `last_name`, `name_suffix`, `goes_by`, `pronunciation`, `gender`, `ethnicity`, `religion`, `openly_lgbtq`, `date_of_birth`, `entered_office`, `term_end`, `biography`, `phone`, `fax`, `latitude`, `longitude`, `address_complete`, `address_number`, `address_prefix`, `address_street`, `address_sec_unit_type`, `address_sec_unit_num`, `address_city`, `address_state`, `address_zipcode`, `address_type`, `website`, `contact_page`, `facebook_url`, `twitter_handle`, `twitter_url`, `photo_url`) VALUES ("Missouri", "missouri", "MO", "mo", "169028", "governor", "republican", "Eric Greitens", "eric-greitens", "Eric", "Robert", "Greitens", null, null, "E-rik GRY-tenz", "male", "white-american", "unspecified", null, "1974-04-10", "2017-01-09", "2019-01-01", "Eric Robert Greitens (born April 10, 1974) is an American politician, author, and former Navy SEAL currently serving as the 56th Governor of Missouri, since January 2017. He is currently the second youngest Governor in the United States, after New Hampshire's Chris Sununu, also born in 1974.", "573-751-3222", null, "38.5774764", "-92.1758644", "201 West Capitol Avenue, Room 216, Post Office Box 720, Jefferson City, MO 65101", "201", "West", "Capitol", "Room", "216", null, null, null, "Avenue", "https://governor.mo.gov/", "https://governor.mo.gov/get-involved/contact-the-governors-office", "https://www.facebook.com/EricGreitens", "EricGreitens", "https://twitter.com/EricGreitens", "https://cdn.civil.services/us-governors/headshots/512x512/eric-greitens.jpg");
INSERT INTO `us-governors` (`state_name`, `state_name_slug`, `state_code`, `state_code_slug`, `votesmart`, `title`, `party`, `name`, `name_slug`, `first_name`, `middle_name`, `last_name`, `name_suffix`, `goes_by`, `pronunciation`, `gender`, `ethnicity`, `religion`, `openly_lgbtq`, `date_of_birth`, `entered_office`, `term_end`, `biography`, `phone`, `fax`, `latitude`, `longitude`, `address_complete`, `address_number`, `address_prefix`, `address_street`, `address_sec_unit_type`, `address_sec_unit_num`, `address_city`, `address_state`, `address_zipcode`, `address_type`, `website`, `contact_page`, `facebook_url`, `twitter_handle`, `twitter_url`, `photo_url`) VALUES ("Montana", "montana", "MT", "mt", "110899", "governor", "democrat", "Stephen Bullock", "stephen-bullock", "Stephen", "Clark", "Bullock", null, null, "STEE-ven BUU-luhk", "male", "white-american", "unspecified", null, "1966-04-11", "2013-01-07", "2019-01-01", "Stephen Clark Bullock (born April 11, 1966) is an American politician and lawyer who is the 24th and current Governor of Montana, serving since 2013. He is a member of the Democratic Party.", "406-444-3111", "406-444-5529", "46.5300037", "-112.162194", "Office of the Governor, Post Office Box 200801, Helena, MT 59620", null, null, "of", "Office", null, null, null, null, null, "http://governor.mt.gov/", "http://governor.mt.gov/Home/Contact/shareopinion", "https://www.facebook.com/GovernorBullock", "GovernorBullock", "https://twitter.com/GovernorBullock", "https://cdn.civil.services/us-governors/headshots/512x512/stephen-bullock.jpg");
INSERT INTO `us-governors` (`state_name`, `state_name_slug`, `state_code`, `state_code_slug`, `votesmart`, `title`, `party`, `name`, `name_slug`, `first_name`, `middle_name`, `last_name`, `name_suffix`, `goes_by`, `pronunciation`, `gender`, `ethnicity`, `religion`, `openly_lgbtq`, `date_of_birth`, `entered_office`, `term_end`, `biography`, `phone`, `fax`, `latitude`, `longitude`, `address_complete`, `address_number`, `address_prefix`, `address_street`, `address_sec_unit_type`, `address_sec_unit_num`, `address_city`, `address_state`, `address_zipcode`, `address_type`, `website`, `contact_page`, `facebook_url`, `twitter_handle`, `twitter_url`, `photo_url`) VALUES ("Nebraska", "nebraska", "NE", "ne", "57777", "governor", "republican", "John Ricketts", "john-ricketts", "John", "Peter", "Ricketts", null, "Pete", "PEET RI-kits", "male", "white-american", "roman-catholic", null, "1964-08-19", "2015-01-08", "2019-01-01", "Ricketts was born in Nebraska City, Nebraska, and now lives in Omaha. He attended the University of Chicago for both his bachelor and graduate studies, and received an MBA in marketing and finance from the university's Graduate School of Business.", "402-471-2244", "402-471-6031", "40.800004", "-96.672194", "Office of the Governor, Post Office Box 94848, Lincoln, NE 68509-4848", null, null, "of", "Office", null, null, null, null, null, "https://governor.nebraska.gov/", "https://governor.nebraska.gov/contact-form", "https://www.facebook.com/GovernorPeteRicketts", "GovRicketts", "https://twitter.com/GovRicketts", "https://cdn.civil.services/us-governors/headshots/512x512/john-ricketts.jpg");
INSERT INTO `us-governors` (`state_name`, `state_name_slug`, `state_code`, `state_code_slug`, `votesmart`, `title`, `party`, `name`, `name_slug`, `first_name`, `middle_name`, `last_name`, `name_suffix`, `goes_by`, `pronunciation`, `gender`, `ethnicity`, `religion`, `openly_lgbtq`, `date_of_birth`, `entered_office`, `term_end`, `biography`, `phone`, `fax`, `latitude`, `longitude`, `address_complete`, `address_number`, `address_prefix`, `address_street`, `address_sec_unit_type`, `address_sec_unit_num`, `address_city`, `address_state`, `address_zipcode`, `address_type`, `website`, `contact_page`, `facebook_url`, `twitter_handle`, `twitter_url`, `photo_url`) VALUES ("Nevada", "nevada", "NV", "nv", "9067", "governor", "republican", "Brian Sandoval", "brian-sandoval", "Brian", "Edward", "Sandoval", null, null, "BRI-an SAND-OH-val", "male", "white-american", "unspecified", null, "1963-08-05", "2011-01-03", "2019-01-01", "Brian Edward Sandoval (born August 5, 1963) is an American politician and attorney who is the 29th and current Governor of Nevada. A member of the Republican Party, Sandoval is a former United States District Judge of the United States District Court for the District of Nevada. On June 9, 2010, Sandoval defeated his GOP challengers (including the then-incumbent governor Jim Gibbons) to win the Republican nomination for the 2010 gubernatorial election.", "775-684-5670", "775-684-5683", "39.1641639", "-119.7683391", "State Capitol, 101 North Carson Street, Carson City, NV 89701", null, null, "State", null, null, null, null, null, null, "http://gov.nv.gov/", "http://gov.nv.gov/Contact/Email-the-Governor/", "https://www.facebook.com/BrianSandoval", "GovSandoval", "https://twitter.com/GovSandoval", "https://cdn.civil.services/us-governors/headshots/512x512/brian-sandoval.jpg");
INSERT INTO `us-governors` (`state_name`, `state_name_slug`, `state_code`, `state_code_slug`, `votesmart`, `title`, `party`, `name`, `name_slug`, `first_name`, `middle_name`, `last_name`, `name_suffix`, `goes_by`, `pronunciation`, `gender`, `ethnicity`, `religion`, `openly_lgbtq`, `date_of_birth`, `entered_office`, `term_end`, `biography`, `phone`, `fax`, `latitude`, `longitude`, `address_complete`, `address_number`, `address_prefix`, `address_street`, `address_sec_unit_type`, `address_sec_unit_num`, `address_city`, `address_state`, `address_zipcode`, `address_type`, `website`, `contact_page`, `facebook_url`, `twitter_handle`, `twitter_url`, `photo_url`) VALUES ("New Hampshire", "new-hampshire", "NH", "nh", "125989", "governor", "republican", "Christopher Sununu", "christopher-sununu", "Christopher", "T.", "Sununu", null, "Chris", "KRIS SUU-NOO-noo", "male", "white-american", "roman-catholic", null, "1974-11-05", "2017-01-05", "2019-01-01", "Christopher T. "Chris" Sununu (born November 5, 1974) is an American politician and businessman who serves as the 82nd and current Governor of New Hampshire, since January 2017. Sununu was previously a member of the New Hampshire Executive Council, an office he held from (2011-2017). At age 42, Sununu is currently the youngest state Governor in the United States.", "603-271-2121", "603-271-7680", "43.2069998", "-71.5403939", "107 North Main Street, Concord, NH 03301", "107", "North", "Main", null, null, "Concord", "NH", "03301", "Street", "http://www.governor.nh.gov/", "https://business.nh.gov/nhgovernor/comments.asp", "https://www.facebook.com/GovernorChrisSununu", "GovChrisSununu", "https://twitter.com/GovChrisSununu", "https://cdn.civil.services/us-governors/headshots/512x512/christopher-sununu.jpg");
INSERT INTO `us-governors` (`state_name`, `state_name_slug`, `state_code`, `state_code_slug`, `votesmart`, `title`, `party`, `name`, `name_slug`, `first_name`, `middle_name`, `last_name`, `name_suffix`, `goes_by`, `pronunciation`, `gender`, `ethnicity`, `religion`, `openly_lgbtq`, `date_of_birth`, `entered_office`, `term_end`, `biography`, `phone`, `fax`, `latitude`, `longitude`, `address_complete`, `address_number`, `address_prefix`, `address_street`, `address_sec_unit_type`, `address_sec_unit_num`, `address_city`, `address_state`, `address_zipcode`, `address_type`, `website`, `contact_page`, `facebook_url`, `twitter_handle`, `twitter_url`, `photo_url`) VALUES ("New Jersey", "new-jersey", "NJ", "nj", "176221", "governor", "democrat", "Philip Murphy", "philip-murphy", "Philip", "Dunton", "Murphy", null, "Phil", "FIL MUR-fee", "male", "white-american", "unspecified", null, "1957-08-16", "2018-01-16", "2022-01-01", "Philip Dunton Murphy (born August 16, 1957) is an American financier, diplomat, and politician currently serving as the 56th Governor of New Jersey. Murphy, a Democrat, defeated then Lieutenant Governor Kim Guadagno in the 2017 gubernatorial election.", "609-292-6000", null, "40.220707", "-74.763027", "Office of the Governor, Post Office Box 001, Trenton, NJ 08625", null, null, "of", "Office", null, null, null, null, null, "http://www.nj.gov/governor/", "http://www.nj.gov/governor/contact/", "https://www.facebook.com/PhilMurphyNJ", "philmurphynj", "https://twitter.com/philmurphynj", "https://cdn.civil.services/us-governors/headshots/512x512/philip-murphy.jpg");
INSERT INTO `us-governors` (`state_name`, `state_name_slug`, `state_code`, `state_code_slug`, `votesmart`, `title`, `party`, `name`, `name_slug`, `first_name`, `middle_name`, `last_name`, `name_suffix`, `goes_by`, `pronunciation`, `gender`, `ethnicity`, `religion`, `openly_lgbtq`, `date_of_birth`, `entered_office`, `term_end`, `biography`, `phone`, `fax`, `latitude`, `longitude`, `address_complete`, `address_number`, `address_prefix`, `address_street`, `address_sec_unit_type`, `address_sec_unit_num`, `address_city`, `address_state`, `address_zipcode`, `address_type`, `website`, `contact_page`, `facebook_url`, `twitter_handle`, `twitter_url`, `photo_url`) VALUES ("New Mexico", "new-mexico", "NM", "nm", "121633", "governor", "republican", "Susana Martinez", "susana-martinez", "Susana", null, "Martinez", null, null, "SOO-ZA-nuh MARR-TEE-nez", "female", "hispanic-american", "unspecified", null, "1959-07-14", "2011-01-01", "2019-01-01", "Susana Martinez (born July 14, 1959) is an American politician and attorney who is the 31st Governor of New Mexico and chairwoman of the Republican Governors Association. A Republican, Martinez was elected governor on November 2, 2010 and sworn into office on January 1, 2011. She is the first woman to be elected governor of New Mexico and the first Hispanic woman governor in the United States.", "505-476-2200", "505-476-2226", "35.6819673", "-105.941017", "Office of the Governor, 490 Old Santa Fe Trail, Room 400, Santa Fe, NM 87501", null, null, "of", "Office", null, null, null, null, null, "http://www.governor.state.nm.us/", "http://www.governor.state.nm.us/Contact_the_Governor.aspx", "https://www.facebook.com/SusanaMartinezFan", "Gov_Martinez", "https://twitter.com/Gov_Martinez", "https://cdn.civil.services/us-governors/headshots/512x512/susana-martinez.jpg");
INSERT INTO `us-governors` (`state_name`, `state_name_slug`, `state_code`, `state_code_slug`, `votesmart`, `title`, `party`, `name`, `name_slug`, `first_name`, `middle_name`, `last_name`, `name_suffix`, `goes_by`, `pronunciation`, `gender`, `ethnicity`, `religion`, `openly_lgbtq`, `date_of_birth`, `entered_office`, `term_end`, `biography`, `phone`, `fax`, `latitude`, `longitude`, `address_complete`, `address_number`, `address_prefix`, `address_street`, `address_sec_unit_type`, `address_sec_unit_num`, `address_city`, `address_state`, `address_zipcode`, `address_type`, `website`, `contact_page`, `facebook_url`, `twitter_handle`, `twitter_url`, `photo_url`) VALUES ("New York", "new-york", "NY", "ny", "45083", "governor", "democrat", "Andrew Cuomo", "andrew-cuomo", "Andrew", "Mark", "Cuomo", null, null, "AN-droo KWOH-moh", "male", "white-american", "roman-catholic", null, "1957-12-06", "2011-01-01", "2019-01-01", "Andrew Mark Cuomo (born December 6, 1957) is an American politician and attorney who has been the 56th Governor of New York since January 1, 2011. A member of the Democratic Party, he was elected in 2010, holding the same position his father, Mario Cuomo, held for three terms from 1983 to 1995.", "518-474-8390", null, "42.6497791", "-73.7618584", "Governor of New York State, NYS State Capitol Building, Albany, NY 12224", null, null, "Governor", null, null, "of", "New York", null, null, "http://www.governor.ny.gov/", "http://www.governor.ny.gov/contact-iframe", "https://www.facebook.com/GovernorAndrewCuomo", "nygovcuomo", "https://twitter.com/nygovcuomo", "https://cdn.civil.services/us-governors/headshots/512x512/andrew-cuomo.jpg");
INSERT INTO `us-governors` (`state_name`, `state_name_slug`, `state_code`, `state_code_slug`, `votesmart`, `title`, `party`, `name`, `name_slug`, `first_name`, `middle_name`, `last_name`, `name_suffix`, `goes_by`, `pronunciation`, `gender`, `ethnicity`, `religion`, `openly_lgbtq`, `date_of_birth`, `entered_office`, `term_end`, `biography`, `phone`, `fax`, `latitude`, `longitude`, `address_complete`, `address_number`, `address_prefix`, `address_street`, `address_sec_unit_type`, `address_sec_unit_num`, `address_city`, `address_state`, `address_zipcode`, `address_type`, `website`, `contact_page`, `facebook_url`, `twitter_handle`, `twitter_url`, `photo_url`) VALUES ("North Carolina", "north-carolina", "NC", "nc", "5900", "governor", "democrat", "Roy Cooper", "roy-cooper", "Roy", "Asberry", "Cooper", "III", null, "ROY KOO-per", "male", "white-american", "presbyterian", null, "1957-06-13", "2017-01-01", "2019-01-01", "Roy Asberry Cooper III (born June 13, 1957) is an American politician and attorney who is the 75th and current Governor of North Carolina, since January 2017. Prior to his governorship, Cooper had served as the Attorney General of North Carolina from 2001 to 2017 and was previously a member of the North Carolina State Senate.", "919-814-2000", null, "35.8093599", "-78.7094088", "20301 Mail Service Center, Raleigh, NC 27699", "20301", null, "Mail Service", null, null, "Raleigh", "NC", "27699", "Center", "https://governor.nc.gov/", "https://governor.nc.gov/contact-governor-cooper", "https://www.facebook.com/NCgovernor", "NC_Governor", "https://twitter.com/NC_Governor", "https://cdn.civil.services/us-governors/headshots/512x512/roy-cooper.jpg");
INSERT INTO `us-governors` (`state_name`, `state_name_slug`, `state_code`, `state_code_slug`, `votesmart`, `title`, `party`, `name`, `name_slug`, `first_name`, `middle_name`, `last_name`, `name_suffix`, `goes_by`, `pronunciation`, `gender`, `ethnicity`, `religion`, `openly_lgbtq`, `date_of_birth`, `entered_office`, `term_end`, `biography`, `phone`, `fax`, `latitude`, `longitude`, `address_complete`, `address_number`, `address_prefix`, `address_street`, `address_sec_unit_type`, `address_sec_unit_num`, `address_city`, `address_state`, `address_zipcode`, `address_type`, `website`, `contact_page`, `facebook_url`, `twitter_handle`, `twitter_url`, `photo_url`) VALUES ("North Dakota", "north-dakota", "ND", "nd", "170745", "governor", "republican", "Douglas Burgum", "douglas-burgum", "Douglas", "J.", "Burgum", null, "Doug", "DOAG BUR-gum", "male", "white-american", "unspecified", null, "1956-08-01", "2016-12-15", "2019-01-01", "Douglas J. Burgum (born August 1, 1956) is an American entrepreneur, philanthropist and politician serving as the 33rd and current Governor of North Dakota since December 15, 2016. He is a member of the Republican Party.", "701-328-2200", "701-328-2205", "46.8207013", "-100.7849455", "600 East Boulevard, Avenue Bismarck, ND 58505", "600", null, "East", null, null, "Avenue Bismarck", "ND", "58505", "Boulevard", "https://www.governor.nd.gov/", "https://www.governor.nd.gov/contact-us", "https://www.facebook.com/GovernorDougBurgum", "DougBurgum", "https://twitter.com/DougBurgum", "https://cdn.civil.services/us-governors/headshots/512x512/douglas-burgum.jpg");
INSERT INTO `us-governors` (`state_name`, `state_name_slug`, `state_code`, `state_code_slug`, `votesmart`, `title`, `party`, `name`, `name_slug`, `first_name`, `middle_name`, `last_name`, `name_suffix`, `goes_by`, `pronunciation`, `gender`, `ethnicity`, `religion`, `openly_lgbtq`, `date_of_birth`, `entered_office`, `term_end`, `biography`, `phone`, `fax`, `latitude`, `longitude`, `address_complete`, `address_number`, `address_prefix`, `address_street`, `address_sec_unit_type`, `address_sec_unit_num`, `address_city`, `address_state`, `address_zipcode`, `address_type`, `website`, `contact_page`, `facebook_url`, `twitter_handle`, `twitter_url`, `photo_url`) VALUES ("Ohio", "ohio", "OH", "oh", "27017", "governor", "republican", "John Kasich", "john-kasich", "John", "Richard", "Kasich", null, null, "JOAN KA-sich", "male", "white-american", "christian", null, "1952-05-13", "2011-01-10", "2019-01-01", "John Richard Kasich (born May 13, 1952) is an American politician and former television host. He is the 69th and current Governor of Ohio. First elected in 2010 and re-elected in 2014, Kasich is a member of the Republican Party.[2] His second term is set to end on January 14, 2019, due to term limits.", "614-466-3555", null, "39.9604503", "-83.0033678", "Riffe Center, 30th Floor, 77 South High Street, Columbus, OH 43215", null, null, "Riffe", null, null, null, null, null, "Center", "http://governor.ohio.gov/", "http://governor.ohio.gov/Contact/ContacttheGovernor.aspx", "https://www.facebook.com/JohnKasich", "OHPressSec", "https://twitter.com/OHPressSec", "https://cdn.civil.services/us-governors/headshots/512x512/john-kasich.jpg");
INSERT INTO `us-governors` (`state_name`, `state_name_slug`, `state_code`, `state_code_slug`, `votesmart`, `title`, `party`, `name`, `name_slug`, `first_name`, `middle_name`, `last_name`, `name_suffix`, `goes_by`, `pronunciation`, `gender`, `ethnicity`, `religion`, `openly_lgbtq`, `date_of_birth`, `entered_office`, `term_end`, `biography`, `phone`, `fax`, `latitude`, `longitude`, `address_complete`, `address_number`, `address_prefix`, `address_street`, `address_sec_unit_type`, `address_sec_unit_num`, `address_city`, `address_state`, `address_zipcode`, `address_type`, `website`, `contact_page`, `facebook_url`, `twitter_handle`, `twitter_url`, `photo_url`) VALUES ("Oklahoma", "oklahoma", "OK", "ok", "1699", "governor", "republican", "Mary Fallin", "mary-fallin", "Mary", null, "Fallin", null, null, "ME-ree FAW-lin", "female", "white-american", "christian", null, "1954-12-09", "2011-01-10", "2019-01-01", "Mary Fallin (born December 9, 1954) is an American politician who is the 27th and current Governor of Oklahoma. A member of the Republican Party, Fallin was elected governor in 2010 and re-elected in 2014.", "405-521-2342", "405-521-3353", "35.4921098", "-97.5055107", "Oklahoma State Capitol, 2300 North Lincoln Boulevard, Room 212, Oklahoma City, OK 73105", null, null, "Oklahoma", null, null, null, null, null, null, "https://www.ok.gov/governor/", "https://www.ok.gov/triton/modules/formbuilder/form.php?form_id=0d5f27f90f279a5b64535ec11836feaa07db37cbb20807e960b2c0aa58b9f358", "https://www.facebook.com/GovernorMaryFallin", "GovMaryFallin", "https://twitter.com/GovMaryFallin", "https://cdn.civil.services/us-governors/headshots/512x512/mary-fallin.jpg");
INSERT INTO `us-governors` (`state_name`, `state_name_slug`, `state_code`, `state_code_slug`, `votesmart`, `title`, `party`, `name`, `name_slug`, `first_name`, `middle_name`, `last_name`, `name_suffix`, `goes_by`, `pronunciation`, `gender`, `ethnicity`, `religion`, `openly_lgbtq`, `date_of_birth`, `entered_office`, `term_end`, `biography`, `phone`, `fax`, `latitude`, `longitude`, `address_complete`, `address_number`, `address_prefix`, `address_street`, `address_sec_unit_type`, `address_sec_unit_num`, `address_city`, `address_state`, `address_zipcode`, `address_type`, `website`, `contact_page`, `facebook_url`, `twitter_handle`, `twitter_url`, `photo_url`) VALUES ("Oregon", "oregon", "OR", "or", "2990", "governor", "democrat", "Katherine Brown", "katherine-brown", "Katherine", null, "Brown", null, "Kate", "KAYT BROWN", "female", "white-american", "unspecified", null, "1960-06-21", "2015-02-18", "2019-01-01", "Katherine "Kate" Brown (born June 21, 1960) is an American politician who is the 38th and current Governor of Oregon. Brown, a Democrat and an attorney, previously served as Oregon Secretary of State and as majority leader of the Oregon State Senate, where she represented portions of Milwaukie and of Northeast and Southeast Portland.", "503-378-4582", null, "44.9382486", "-123.032757", "160 State Capitol, 900 Court Street, Salem, OR 97301-4047", "160", null, "State", null, null, null, null, null, null, "http://www.oregon.gov/gov/pages/index.aspx", "http://www.oregon.gov/gov/Pages/share-your-opinion.aspx", "https://www.facebook.com/oregongovernor", "OregonGovBrown", "https://twitter.com/OregonGovBrown", "https://cdn.civil.services/us-governors/headshots/512x512/katherine-brown.jpg");
INSERT INTO `us-governors` (`state_name`, `state_name_slug`, `state_code`, `state_code_slug`, `votesmart`, `title`, `party`, `name`, `name_slug`, `first_name`, `middle_name`, `last_name`, `name_suffix`, `goes_by`, `pronunciation`, `gender`, `ethnicity`, `religion`, `openly_lgbtq`, `date_of_birth`, `entered_office`, `term_end`, `biography`, `phone`, `fax`, `latitude`, `longitude`, `address_complete`, `address_number`, `address_prefix`, `address_street`, `address_sec_unit_type`, `address_sec_unit_num`, `address_city`, `address_state`, `address_zipcode`, `address_type`, `website`, `contact_page`, `facebook_url`, `twitter_handle`, `twitter_url`, `photo_url`) VALUES ("Pennsylvania", "pennsylvania", "PA", "pa", "77203", "governor", "democrat", "Thomas Wolf", "thomas-wolf", "Thomas", "Westerman", "Wolf", null, "Tom", "TAWM WAWLF", "male", "white-american", "unspecified", null, "1948-11-17", "2015-01-20", "2019-01-01", "Thomas Westerman "Tom" Wolf (born November 17, 1948) is an American businessman and politician who is the 47th and current Governor of Pennsylvania, since taking office on January 20, 2015. A Democrat, he defeated Republican incumbent Tom Corbett in the 2014 gubernatorial election. Previously, Wolf served as the Secretary of the Pennsylvania Department of Revenue from April 2007 until November 2008 and as an executive in his family-owned business.", "717-787-2500", "717-772-8284", "40.2645516", "-76.8860975", "508 Main Capitol Building, Harrisburg, PA 17120", "508", null, "Main Capitol", "Building", "Harrisbur", "g", "PA", "17120", null, "https://www.governor.pa.gov/", "https://www.governor.pa.gov/contact/", "https://www.facebook.com/governorwolf", "governortomwolf", "https://twitter.com/governortomwolf", "https://cdn.civil.services/us-governors/headshots/512x512/thomas-wolf.jpg");
INSERT INTO `us-governors` (`state_name`, `state_name_slug`, `state_code`, `state_code_slug`, `votesmart`, `title`, `party`, `name`, `name_slug`, `first_name`, `middle_name`, `last_name`, `name_suffix`, `goes_by`, `pronunciation`, `gender`, `ethnicity`, `religion`, `openly_lgbtq`, `date_of_birth`, `entered_office`, `term_end`, `biography`, `phone`, `fax`, `latitude`, `longitude`, `address_complete`, `address_number`, `address_prefix`, `address_street`, `address_sec_unit_type`, `address_sec_unit_num`, `address_city`, `address_state`, `address_zipcode`, `address_type`, `website`, `contact_page`, `facebook_url`, `twitter_handle`, `twitter_url`, `photo_url`) VALUES ("Rhode Island", "rhode-island", "RI", "ri", "128028", "governor", "democrat", "Gina Raimondo", "gina-raimondo", "Gina", "Marie", "Raimondo", null, null, "JEE-nuh RAY-mahn-doh", "female", "white-american", "unspecified", null, "1971-05-17", "2015-01-06", "2019-01-01", "Gina Marie Raimondo (born May 17, 1971) is an American politician, businesswoman, venture capitalist, and the 75th and current Governor of the State of Rhode Island. Raimondo, a member of the Democratic Party, is the first woman to serve as Governor of Rhode Island. Prior to her election as governor, she served as the General Treasurer for the State of Rhode Island and was the second Rhode Island woman to serve as Treasurer.", "401-222-2080", "401-222-8096", "41.8310614", "-71.4171496", "82 Smith Street, Providence, RI 02903", "82", null, "Smith", null, null, "Providence", "RI", "02903", "Street", "http://www.gov.ri.gov/", "http://www.gov.ri.gov/contact/", "https://www.facebook.com/GinaMRaimondo", "ginaraimondo", "https://twitter.com/ginaraimondo", "https://cdn.civil.services/us-governors/headshots/512x512/gina-raimondo.jpg");
INSERT INTO `us-governors` (`state_name`, `state_name_slug`, `state_code`, `state_code_slug`, `votesmart`, `title`, `party`, `name`, `name_slug`, `first_name`, `middle_name`, `last_name`, `name_suffix`, `goes_by`, `pronunciation`, `gender`, `ethnicity`, `religion`, `openly_lgbtq`, `date_of_birth`, `entered_office`, `term_end`, `biography`, `phone`, `fax`, `latitude`, `longitude`, `address_complete`, `address_number`, `address_prefix`, `address_street`, `address_sec_unit_type`, `address_sec_unit_num`, `address_city`, `address_state`, `address_zipcode`, `address_type`, `website`, `contact_page`, `facebook_url`, `twitter_handle`, `twitter_url`, `photo_url`) VALUES ("South Carolina", "south-carolina", "SC", "sc", "48189", "governor", "republican", "Henry McMaster", "henry-mcmaster", "Henry", "Dargan", "McMaster", null, null, "HEN-ree MUHK-MAS-ter", "male", "white-american", "presbyterian", null, "1947-05-27", "2017-01-24", "2019-01-01", "Henry Dargan McMaster (born May 27, 1947) is an American politician and attorney who is the 117th and current Governor of South Carolina. He assumed office on January 24, 2017. He previously served as the 91st Lieutenant Governor of South Carolina from 2015 to 2017, as well as Attorney General of South Carolina from 2003 to 2011.", "803-734-2100", "803-734-5167", "34.0004102", "-81.0350236", "The Honorable Henry McMaster, Office of the Governor, 1100 Gervais Street, Columbia, SC 29201", null, null, "The", null, null, null, null, null, null, "http://governor.sc.gov/Pages/default.aspx", "http://governor.sc.gov/Contact/Pages/default.aspx", "https://www.facebook.com/HenryMcMaster", "SCGOVOFFICE", "https://twitter.com/SCGOVOFFICE", "https://cdn.civil.services/us-governors/headshots/512x512/henry-mcmaster.jpg");
INSERT INTO `us-governors` (`state_name`, `state_name_slug`, `state_code`, `state_code_slug`, `votesmart`, `title`, `party`, `name`, `name_slug`, `first_name`, `middle_name`, `last_name`, `name_suffix`, `goes_by`, `pronunciation`, `gender`, `ethnicity`, `religion`, `openly_lgbtq`, `date_of_birth`, `entered_office`, `term_end`, `biography`, `phone`, `fax`, `latitude`, `longitude`, `address_complete`, `address_number`, `address_prefix`, `address_street`, `address_sec_unit_type`, `address_sec_unit_num`, `address_city`, `address_state`, `address_zipcode`, `address_type`, `website`, `contact_page`, `facebook_url`, `twitter_handle`, `twitter_url`, `photo_url`) VALUES ("South Dakota", "south-dakota", "SD", "sd", "11218", "governor", "republican", "Dennis Daugaard", "dennis-daugaard", "Dennis", "Martin", "Daugaard", null, null, "DE-nis DAH-gard", "male", "white-american", "lutheran", null, "1953-06-11", "2011-01-08", "2019-01-01", "Dennis Martin Daugaard (born June 11, 1953) is an American attorney and politician who has been the 32nd Governor of South Dakota since January 2011. He is the first governor of South Dakota or any state in the United States to be the child of deaf parents.", "607-773-3212", null, "44.367069", "-100.3484242", "Office of the Governor, 500 East Capitol Avenue, Pierre, SD 57501", null, null, "of", "Office", null, null, null, null, null, "http://sd.gov/governor/", "http://sd.gov/governor/contact/contact.aspx", null, "SDGovDaugaard", "https://twitter.com/SDGovDaugaard", "https://cdn.civil.services/us-governors/headshots/512x512/dennis-daugaard.jpg");
INSERT INTO `us-governors` (`state_name`, `state_name_slug`, `state_code`, `state_code_slug`, `votesmart`, `title`, `party`, `name`, `name_slug`, `first_name`, `middle_name`, `last_name`, `name_suffix`, `goes_by`, `pronunciation`, `gender`, `ethnicity`, `religion`, `openly_lgbtq`, `date_of_birth`, `entered_office`, `term_end`, `biography`, `phone`, `fax`, `latitude`, `longitude`, `address_complete`, `address_number`, `address_prefix`, `address_street`, `address_sec_unit_type`, `address_sec_unit_num`, `address_city`, `address_state`, `address_zipcode`, `address_type`, `website`, `contact_page`, `facebook_url`, `twitter_handle`, `twitter_url`, `photo_url`) VALUES ("Tennessee", "tennessee", "TN", "tn", "78497", "governor", "republican", "William Haslam", "william-haslam", "William", "Edward", "Haslam", null, "Bill", "BIL HAZ-lahm", "male", "white-american", "presbyterian", null, "1958-08-23", "2011-01-15", "2019-01-01", "William Edward "Bill" Haslam (born August 23, 1958) is an American politician and businessman who is the 49th and current Governor of Tennessee. A member of the Republican Party, Haslam was elected Governor in 2010 and was sworn in on January 15, 2011.", "615-741-2001", null, "36.1658533", "-86.7864881", "1st Floor, State Capitol, 600 Charlotte Avenur, Nashville, TN 37243", "1", null, "st", "Floor", "State", null, null, null, null, "http://www.tn.gov/governor", "http://www.tn.gov/governor/topic/contact", "https://www.facebook.com/TeamHaslam", "billhaslam", "https://twitter.com/billhaslam", "https://cdn.civil.services/us-governors/headshots/512x512/william-haslam.jpg");
INSERT INTO `us-governors` (`state_name`, `state_name_slug`, `state_code`, `state_code_slug`, `votesmart`, `title`, `party`, `name`, `name_slug`, `first_name`, `middle_name`, `last_name`, `name_suffix`, `goes_by`, `pronunciation`, `gender`, `ethnicity`, `religion`, `openly_lgbtq`, `date_of_birth`, `entered_office`, `term_end`, `biography`, `phone`, `fax`, `latitude`, `longitude`, `address_complete`, `address_number`, `address_prefix`, `address_street`, `address_sec_unit_type`, `address_sec_unit_num`, `address_city`, `address_state`, `address_zipcode`, `address_type`, `website`, `contact_page`, `facebook_url`, `twitter_handle`, `twitter_url`, `photo_url`) VALUES ("Texas", "texas", "TX", "tx", "50168", "governor", "republican", "Gregory Abbott", "gregory-abbott", "Gregory", "Wayne", "Abbott", null, "Greg", "GREG A-buht", "male", "white-american", "roman-catholic", null, "1957-11-13", "2015-01-20", "2019-01-01", "Gregory Wayne "Greg" Abbott (born November 13, 1957) is an American lawyer and politician who currently serves as the 48th Governor of Texas since January 2015. During the Governorship of his predecessor, Rick Perry, Abbott was the 50th Attorney General of Texas and is a Republican.", "512-463-2000", null, "30.2727169", "-97.7410268", "Office of the Governor, Post Office Box 12428, Austin, TX 78711-2428", null, null, "of", "Office", null, null, null, null, null, "http://gov.texas.gov/", "https://gov.texas.gov/contact/", "https://www.facebook.com/TexasGovernor", "TexGov", "https://twitter.com/TexGov", "https://cdn.civil.services/us-governors/headshots/512x512/gregory-abbott.jpg");
INSERT INTO `us-governors` (`state_name`, `state_name_slug`, `state_code`, `state_code_slug`, `votesmart`, `title`, `party`, `name`, `name_slug`, `first_name`, `middle_name`, `last_name`, `name_suffix`, `goes_by`, `pronunciation`, `gender`, `ethnicity`, `religion`, `openly_lgbtq`, `date_of_birth`, `entered_office`, `term_end`, `biography`, `phone`, `fax`, `latitude`, `longitude`, `address_complete`, `address_number`, `address_prefix`, `address_street`, `address_sec_unit_type`, `address_sec_unit_num`, `address_city`, `address_state`, `address_zipcode`, `address_type`, `website`, `contact_page`, `facebook_url`, `twitter_handle`, `twitter_url`, `photo_url`) VALUES ("Utah", "utah", "UT", "ut", "50344", "governor", "republican", "Gary Herbert", "gary-herbert", "Gary", "Richard", "Herbert", null, null, "GE-ree HUR-bert", "male", "white-american", "christian", null, "1947-05-07", "2009-08-11", "2019-01-01", "Gary Richard Herbert (born May 7, 1947) is an American politician who is the 17th and current Governor of Utah. A member of the Republican Party, Herbert has served as Governor since August 2009. From July 2015 to July 2016, Herbert served as chair of the National Governors Association.", "801-538-1000", "801-538-1528", "40.7443666", "-111.9725741", "Utah State Capitol, 350 North State Street, Suite 200, Post Office Box 142220, Salt Lake City, UT 84114", null, null, "Utah", null, null, null, null, null, null, "https://www.utah.gov/governor/", "https://gocentral.utah.gov/Request/Contact?response=true", "https://www.facebook.com/GovGaryHerbert", "governorherbert", "https://twitter.com/governorherbert", "https://cdn.civil.services/us-governors/headshots/512x512/gary-herbert.jpg");
INSERT INTO `us-governors` (`state_name`, `state_name_slug`, `state_code`, `state_code_slug`, `votesmart`, `title`, `party`, `name`, `name_slug`, `first_name`, `middle_name`, `last_name`, `name_suffix`, `goes_by`, `pronunciation`, `gender`, `ethnicity`, `religion`, `openly_lgbtq`, `date_of_birth`, `entered_office`, `term_end`, `biography`, `phone`, `fax`, `latitude`, `longitude`, `address_complete`, `address_number`, `address_prefix`, `address_street`, `address_sec_unit_type`, `address_sec_unit_num`, `address_city`, `address_state`, `address_zipcode`, `address_type`, `website`, `contact_page`, `facebook_url`, `twitter_handle`, `twitter_url`, `photo_url`) VALUES ("Vermont", "vermont", "VT", "vt", "55934", "governor", "republican", "Philip Scott", "philip-scott", "Philip", null, "Scott", null, "Phil", "FIL SKAHT", "male", "white-american", "unspecified", null, "1958-08-04", "2017-01-05", "2019-01-01", "Philip "Phil" Scott (born August 4, 1958) is an American politician and businessman serving as the 82nd and current Governor of the state of Vermont, since January 2017. A Republican, he won the 2016 general election with over 52% of the vote. He was previously the 80th Lieutenant Governor of Vermont, an office he held from 2011 to 2017.", "802-828-3333", "802-828-3339", "44.2612298", "-72.5817197", "109 State Street, Pavilion Montpelier, VT 05609", "109", null, "State", null, null, "Pavilion Montpelier", "VT", "05609", "Street", "http://governor.vermont.gov/", "http://governor.vermont.gov/contact-us/message", "https://www.facebook.com/GovPhilScott", "GovPhilScott", "https://twitter.com/GovPhilScott", "https://cdn.civil.services/us-governors/headshots/512x512/philip-scott.jpg");
INSERT INTO `us-governors` (`state_name`, `state_name_slug`, `state_code`, `state_code_slug`, `votesmart`, `title`, `party`, `name`, `name_slug`, `first_name`, `middle_name`, `last_name`, `name_suffix`, `goes_by`, `pronunciation`, `gender`, `ethnicity`, `religion`, `openly_lgbtq`, `date_of_birth`, `entered_office`, `term_end`, `biography`, `phone`, `fax`, `latitude`, `longitude`, `address_complete`, `address_number`, `address_prefix`, `address_street`, `address_sec_unit_type`, `address_sec_unit_num`, `address_city`, `address_state`, `address_zipcode`, `address_type`, `website`, `contact_page`, `facebook_url`, `twitter_handle`, `twitter_url`, `photo_url`) VALUES ("Virginia", "virginia", "VA", "va", null, "governor", "democrat", "Ralph Northam", "ralph-northam", "Ralph", "Shearer", "Northam", null, null, "RALF NORTH-am", "male", "white-american", "unspecified", null, "1959-09-13", "2018-01-13", "2022-01-01", "Ralph Shearer Northam (born September 13, 1959) is an American physician, veteran and politician serving as the 73rd Governor of Virginia since January 13, 2018. He served as the 40th Lieutenant Governor of Virginia from 2014 to 2018 prior to winning the governorship against Republican nominee Ed Gillespie in 2017.", "804-786-2211", null, "37.6284448", "-77.5469394", "Post Office Box 1475, Richmond, VA 23218", null, null, "Post", "Office", null, null, null, null, null, "https://governor.virginia.gov/", "https://governor.virginia.gov/constituent-services/communicating-with-the-governors-office/", "https://www.facebook.com/ralph.northam", "ralphnortham", "https://twitter.com/ralphnortham", "https://cdn.civil.services/us-governors/headshots/512x512/ralph-northam.jpg");
INSERT INTO `us-governors` (`state_name`, `state_name_slug`, `state_code`, `state_code_slug`, `votesmart`, `title`, `party`, `name`, `name_slug`, `first_name`, `middle_name`, `last_name`, `name_suffix`, `goes_by`, `pronunciation`, `gender`, `ethnicity`, `religion`, `openly_lgbtq`, `date_of_birth`, `entered_office`, `term_end`, `biography`, `phone`, `fax`, `latitude`, `longitude`, `address_complete`, `address_number`, `address_prefix`, `address_street`, `address_sec_unit_type`, `address_sec_unit_num`, `address_city`, `address_state`, `address_zipcode`, `address_type`, `website`, `contact_page`, `facebook_url`, `twitter_handle`, `twitter_url`, `photo_url`) VALUES ("Washington", "washington", "WA", "wa", "27125", "governor", "democrat", "Jay Inslee", "jay-inslee", "Jay", "Robert", "Inslee", null, null, "JAY INZ-lee", "male", "white-american", "protestant", null, "1951-02-09", "2013-01-16", "2019-01-01", "Jay Robert Inslee (born February 9, 1951) is an American politician, attorney and member of the Democratic Party who has served as the 23rd Governor of Washington since January 2013.", "360-902-4111", "360-753-4110", "47.0400036", "-122.892194", "Office of the Governor, Post Office Box 40002, Olympia, WA 98504-0002", null, null, "of", "Office", null, null, null, null, null, "http://www.governor.wa.gov/", "http://www.governor.wa.gov/contact/contact/send-gov-inslee-e-message", "https://www.facebook.com/WaStateGov", "jayinslee", "https://twitter.com/jayinslee", "https://cdn.civil.services/us-governors/headshots/512x512/jay-inslee.jpg");
INSERT INTO `us-governors` (`state_name`, `state_name_slug`, `state_code`, `state_code_slug`, `votesmart`, `title`, `party`, `name`, `name_slug`, `first_name`, `middle_name`, `last_name`, `name_suffix`, `goes_by`, `pronunciation`, `gender`, `ethnicity`, `religion`, `openly_lgbtq`, `date_of_birth`, `entered_office`, `term_end`, `biography`, `phone`, `fax`, `latitude`, `longitude`, `address_complete`, `address_number`, `address_prefix`, `address_street`, `address_sec_unit_type`, `address_sec_unit_num`, `address_city`, `address_state`, `address_zipcode`, `address_type`, `website`, `contact_page`, `facebook_url`, `twitter_handle`, `twitter_url`, `photo_url`) VALUES ("West Virginia", "west-virginia", "WV", "wv", "166287", "governor", "democrat", "James Justice", "james-justice", "James", "Conley", "Justice", "Jr.", "Jim", "JIM JUS-tis", "male", "white-american", "unspecified", null, "1951-04-27", "2017-01-16", "2019-01-01", "James Conley "Jim" Justice Jr. (born April 27, 1951) is an American coal mining and agriculture businessman and politician who is the 36th and current Governor of West Virginia since January 2017. Owner of over 50 companies, including The Greenbrier, a luxury resort, Justice is one of the few billionaires from the state of West Virginia. A Democrat, Justice ran for Governor in the 2016 general election as the Democratic nominee, defeating the Republican nominee, Bill Cole.", "304-558-2000", null, "38.3372072", "-81.6145768", "State Capitol, 1900 Kanawha Blvd. E, Charleston, WV 25305", null, null, "State", null, null, null, null, null, null, "http://www.governor.wv.gov/Pages/default.aspx", "http://www.governor.wv.gov/Pages/SubmitaCommenttotheGovernor.aspx", "https://www.facebook.com/WVGovernor", "WVGovernor", "https://twitter.com/WVGovernor", "https://cdn.civil.services/us-governors/headshots/512x512/james-justice.jpg");
INSERT INTO `us-governors` (`state_name`, `state_name_slug`, `state_code`, `state_code_slug`, `votesmart`, `title`, `party`, `name`, `name_slug`, `first_name`, `middle_name`, `last_name`, `name_suffix`, `goes_by`, `pronunciation`, `gender`, `ethnicity`, `religion`, `openly_lgbtq`, `date_of_birth`, `entered_office`, `term_end`, `biography`, `phone`, `fax`, `latitude`, `longitude`, `address_complete`, `address_number`, `address_prefix`, `address_street`, `address_sec_unit_type`, `address_sec_unit_num`, `address_city`, `address_state`, `address_zipcode`, `address_type`, `website`, `contact_page`, `facebook_url`, `twitter_handle`, `twitter_url`, `photo_url`) VALUES ("Wisconsin", "wisconsin", "WI", "wi", "3552", "governor", "republican", "Scott Walker", "scott-walker", "Scott", "Kevin", "Walker", null, null, "SKAHT WAH-ker", "male", "white-american", "unspecified", null, "1967-06-30", "2011-01-03", "2019-01-01", "Scott Kevin Walker (born November 2, 1967) is an American politician who is the 45th and current Governor of Wisconsin. First elected governor in the 2010 Wisconsin general election, he won a 2012 recall election and was reelected governor in the 2014 Wisconsin gubernatorial election. He also served in the Wisconsin State Assembly and as the Milwaukee County Executive.", "608-266-1212", null, "43.086661", "-89.3857785", "Office of Governor Scott Walker, 115 East Capitol, Madison, WI 53702", null, null, "of", "Office", null, null, null, null, null, "https://walker.wi.gov/", "https://walker.wi.gov/contact-us", "https://www.facebook.com/governorscottwalker", "govwalker", "https://twitter.com/govwalker", "https://cdn.civil.services/us-governors/headshots/512x512/scott-walker.jpg");
INSERT INTO `us-governors` (`state_name`, `state_name_slug`, `state_code`, `state_code_slug`, `votesmart`, `title`, `party`, `name`, `name_slug`, `first_name`, `middle_name`, `last_name`, `name_suffix`, `goes_by`, `pronunciation`, `gender`, `ethnicity`, `religion`, `openly_lgbtq`, `date_of_birth`, `entered_office`, `term_end`, `biography`, `phone`, `fax`, `latitude`, `longitude`, `address_complete`, `address_number`, `address_prefix`, `address_street`, `address_sec_unit_type`, `address_sec_unit_num`, `address_city`, `address_state`, `address_zipcode`, `address_type`, `website`, `contact_page`, `facebook_url`, `twitter_handle`, `twitter_url`, `photo_url`) VALUES ("Wyoming", "wyoming", "WY", "wy", "127254", "governor", "republican", "Matthew Mead", "matthew-mead", "Matthew", "Hansen", "Mead", null, "Matt", "MAT ME-ad", "male", "white-american", "episcopalian", null, "1962-03-11", "2011-01-03", "2019-01-01", "Matthew Hansen "Matt" Mead (born March 11, 1962) is an American lawyer and politician who has served as the 32nd Governor of Wyoming since 2011. A Republican, he is a maternal grandson of Governor and U.S. Senator Clifford Hansen.", "307-777-7434", "307-632-3909", "41.1398184", "-104.8221281", "State Capitol, 200 West 24th Street, Cheyenne, WY 82002-0010", null, null, "State", null, null, null, null, null, null, "http://governor.wyo.gov/", "https://sites.google.com/a/wyo.gov/governor/contact-us", "https://www.facebook.com/governormattmead", "GovMattMead", "https://twitter.com/GovMattMead", "https://cdn.civil.services/us-governors/headshots/512x512/matthew-mead.jpg");