In [1]:
xs = [10,20,30,40,50]
In [2]:
for x in xs:
    print(x)

10
20
30
40
50
In [3]:
for i,x in enumerate(xs):
    print(i,x)

0 10
1 20
2 30
3 40
4 50
In [6]:
import csv

def read_senators(fname):
    with open(fname) as f:
        data = csv.reader(f,delimiter=',')
        include_columns = [0,1,6,7,9,12,13,18,19,20]
        for row in data:
            s = "INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ("       
            for i,value in enumerate(row):
                if i in include_columns:
                    s = s + "'" + value + "',"                  
            s = s[:-1] + ");"
            print(s)

def main():
    read_senators("senators.csv")

main()

INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Brown','Sherrod','1952-11-09','M','OH','Democrat','https://www.brown.senate.gov','SenSherrodBrown','SenatorSherrodBrown','SherrodBrownOhio');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Cantwell','Maria','1958-10-13','F','WA','Democrat','https://www.cantwell.senate.gov','SenatorCantwell','senatorcantwell','SenatorCantwell');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Cardin','Benjamin','1943-10-05','M','MD','Democrat','https://www.cardin.senate.gov','SenatorCardin','senatorbencardin','senatorcardin');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Carper','Thomas','1947-01-23','M','DE','Democrat','https://www.carper.senate.gov/public','SenatorCarper','tomcarper','senatorcarper');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Casey','Robert','1960-04-13','M','PA','Democrat','https://www.casey.senate.gov','SenBobCasey','SenatorBobCasey','SenatorBobCasey');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Feinstein','Dianne','1933-06-22','F','CA','Democrat','https://www.feinstein.senate.gov','SenFeinstein','senatorfeinstein','SenatorFeinstein');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Klobuchar','Amy','1960-05-25','F','MN','Democrat','https://www.klobuchar.senate.gov','SenAmyKlobuchar','','senatorklobuchar');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Menendez','Robert','1954-01-01','M','NJ','Democrat','https://www.menendez.senate.gov','SenatorMenendez','senatormenendez','SenatorMenendezNJ');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Sanders','Bernard','1941-09-08','M','VT','Independent','https://www.sanders.senate.gov','SenSanders','senatorsanders','senatorsanders');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Stabenow','Debbie','1950-04-29','F','MI','Democrat','https://www.stabenow.senate.gov','SenStabenow','SenatorStabenow','senatorstabenow');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Tester','Jon','1956-08-21','M','MT','Democrat','https://www.tester.senate.gov','SenatorTester','senatortester','senatorjontester');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Whitehouse','Sheldon','1955-10-20','M','RI','Democrat','https://www.whitehouse.senate.gov','SenWhitehouse','SenatorWhitehouse','SenatorWhitehouse');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Barrasso','John','1952-07-21','M','WY','Republican','https://www.barrasso.senate.gov','SenJohnBarrasso','johnbarrasso','barrassowyo');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Wicker','Roger','1951-07-05','M','MS','Republican','https://www.wicker.senate.gov','SenatorWicker','SenatorWicker','SenatorWicker');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Collins','Susan','1952-12-07','F','ME','Republican','https://www.collins.senate.gov','SenatorCollins','susancollins','SenatorSusanCollins');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Cornyn','John','1952-02-02','M','TX','Republican','https://www.cornyn.senate.gov','JohnCornyn','sen.johncornyn','senjohncornyn');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Durbin','Richard','1944-11-21','M','IL','Democrat','https://www.durbin.senate.gov','SenatorDurbin','SenatorDurbin','SenatorDurbin');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Graham','Lindsey','1955-07-09','M','SC','Republican','https://www.lgraham.senate.gov/public','GrahamBlog','USSenatorLindseyGraham','USSenLindseyGraham');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Inhofe','James','1934-11-17','M','OK','Republican','https://www.inhofe.senate.gov','JimInhofe','jiminhofe','jiminhofepressoffice');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('McConnell','Mitch','1942-02-20','M','KY','Republican','https://www.mcconnell.senate.gov','McConnellPress','mitchmcconnell','');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Merkley','Jeff','1956-10-24','M','OR','Democrat','https://www.merkley.senate.gov','SenJeffMerkley','jeffmerkley','SenatorJeffMerkley');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Reed','John','1949-11-12','M','RI','Democrat','https://www.reed.senate.gov','SenJackReed','SenJackReed','SenatorReed');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Risch','James','1943-05-03','M','ID','Republican','https://www.risch.senate.gov','SenatorRisch','senatorjimrisch','SenatorJamesRisch');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Shaheen','Jeanne','1947-01-28','F','NH','Democrat','https://www.shaheen.senate.gov','SenatorShaheen','SenatorShaheen','senatorshaheen');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Warner','Mark','1954-12-15','M','VA','Democrat','https://www.warner.senate.gov','MarkWarner','MarkRWarner','SenatorMarkWarner');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Gillibrand','Kirsten','1966-12-09','F','NY','Democrat','https://www.gillibrand.senate.gov','GillibrandNY','SenKirstenGillibrand','KirstenEGillibrand');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Coons','Christopher','1963-09-09','M','DE','Democrat','https://www.coons.senate.gov','ChrisCoons','senatorchriscoons','senatorchriscoons');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Manchin','Joe','1947-08-24','M','WV','Democrat','https://www.manchin.senate.gov','Sen_JoeManchin','JoeManchinIII','SenatorJoeManchin');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Baldwin','Tammy','1962-02-11','F','WI','Democrat','https://www.baldwin.senate.gov','SenatorBaldwin','senatortammybaldwin','witammybaldwin');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Bennet','Michael','1964-11-28','M','CO','Democrat','https://www.bennet.senate.gov/public','SenatorBennet','senbennetco','SenatorBennet');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Blackburn','Marsha','1952-06-06','F','TN','Republican','https://www.blackburn.senate.gov','MarshaBlackburn','marshablackburn','RepMarshaBlackburn');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Blumenthal','Richard','1946-02-13','M','CT','Democrat','https://www.blumenthal.senate.gov','SenBlumenthal','SenBlumenthal','SenatorBlumenthal');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Blunt','Roy','1950-01-10','M','MO','Republican','https://www.blunt.senate.gov','RoyBlunt','SenatorBlunt','SenatorBlunt');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Boozman','John','1950-12-10','M','AR','Republican','https://www.boozman.senate.gov/public','JohnBoozman','JohnBoozman','BoozmanPressOffice');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Burr','Richard','1955-11-30','M','NC','Republican','https://www.burr.senate.gov','SenatorBurr','SenatorRichardBurr','SenatorRichardBurr');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Capito','Shelley','1953-11-26','F','WV','Republican','https://www.capito.senate.gov','SenCapito','senshelley','');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Cassidy','Bill','1957-09-28','M','LA','Republican','https://www.cassidy.senate.gov','SenBillCassidy','','SenatorBillCassidy');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Crapo','Michael','1951-05-20','M','ID','Republican','https://www.crapo.senate.gov','MikeCrapo','mikecrapo','senatorcrapo');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Grassley','Charles','1933-09-17','M','IA','Republican','https://www.grassley.senate.gov','ChuckGrassley','grassley','senchuckgrassley');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Heinrich','Martin','1971-10-17','M','NM','Democrat','https://www.heinrich.senate.gov','MartinHeinrich','MartinHeinrich','SenMartinHeinrich');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Hirono','Mazie','1947-11-03','F','HI','Democrat','https://www.hirono.senate.gov','MazieHirono','senatorhirono','CongresswomanHirono');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Hoeven','John','1957-03-13','M','ND','Republican','https://www.hoeven.senate.gov','SenJohnHoeven','SenatorJohnHoeven','senatorjohnhoevennd');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Johnson','Ron','1955-04-08','M','WI','Republican','https://www.ronjohnson.senate.gov','SenRonJohnson','senronjohnson','SenatorRonJohnson');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Lankford','James','1968-03-04','M','OK','Republican','https://www.lankford.senate.gov','SenatorLankford','SenatorLankford','SenatorLankford');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Leahy','Patrick','1940-03-31','M','VT','Democrat','https://www.leahy.senate.gov','SenatorLeahy','SenatorPatrickLeahy','SenatorPatrickLeahy');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Lee','Mike','1971-06-04','M','UT','Republican','https://www.lee.senate.gov','SenMikeLee','senatormikelee','senatormikelee');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Luján','Ben','1972-06-07','M','NM','Democrat','https://www.lujan.senate.gov','SenatorLujan','','');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Markey','Edward','1946-07-11','M','MA','Democrat','https://www.markey.senate.gov','SenMarkey','EdJMarkey','RepMarkey');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Moran','Jerry','1954-05-29','M','KS','Republican','https://www.moran.senate.gov','JerryMoran','jerrymoran','senatorjerrymoran');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Murkowski','Lisa','1957-05-22','F','AK','Republican','https://www.murkowski.senate.gov','LisaMurkowski','SenLisaMurkowski','senatormurkowski');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Murphy','Christopher','1973-08-03','M','CT','Democrat','https://www.murphy.senate.gov','SenMurphyOffice','chrismurphyct','senchrismurphy');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Murray','Patty','1950-10-11','F','WA','Democrat','https://www.murray.senate.gov','PattyMurray','','SenatorPattyMurray');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Paul','Rand','1963-01-07','M','KY','Republican','https://www.paul.senate.gov','SenRandPaul','SenatorRandPaul','SenatorRandPaul');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Peters','Gary','1958-12-01','M','MI','Democrat','https://www.peters.senate.gov','SenGaryPeters','SenGaryPeters','RepGaryPeters');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Portman','Robert','1955-12-19','M','OH','Republican','https://www.portman.senate.gov','SenRobPortman','senrobportman','SenRobPortman');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Rubio','Marco','1971-05-28','M','FL','Republican','https://www.rubio.senate.gov','SenRubioPress','SenatorMarcoRubio','SenatorMarcoRubio');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Schumer','Charles','1950-11-23','M','NY','Democrat','https://www.schumer.senate.gov','SenSchumer','senschumer','SenatorSchumer');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Scott','Tim','1965-09-19','M','SC','Republican','https://www.scott.senate.gov','SenatorTimScott','SenatorTimScott','SenatorTimScott');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Shelby','Richard','1934-05-06','M','AL','Republican','https://www.shelby.senate.gov','SenShelby','RichardShelby','SenatorRichardShelby');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Thune','John','1961-01-07','M','SD','Republican','https://www.thune.senate.gov','SenJohnThune','','johnthune');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Toomey','Patrick','1961-11-17','M','PA','Republican','https://www.toomey.senate.gov','SenToomey','senatortoomey','sentoomey');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Van Hollen','Chris','1959-01-10','M','MD','Democrat','https://www.vanhollen.senate.gov','ChrisVanHollen','chrisvanhollen','RepChrisVanHollen');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Wyden','Ron','1949-05-03','M','OR','Democrat','https://www.wyden.senate.gov','RonWyden','','senronwyden');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Young','Todd','1972-08-24','M','IN','Republican','https://www.young.senate.gov','SenToddYoung','SenatorToddYoung','RepToddYoung');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Schatz','Brian','1972-10-20','M','HI','Democrat','https://www.schatz.senate.gov','SenBrianSchatz','SenBrianSchatz','senbrianschatz');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Cotton','Tom','1977-05-13','M','AR','Republican','https://www.cotton.senate.gov','SenTomCotton','SenatorTomCotton','RepTomCotton');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Sinema','Kyrsten','1976-07-12','F','AZ','Democrat','https://www.sinema.senate.gov','SenatorSinema','CongresswomanSinema','repsinema');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Duckworth','Tammy','1968-03-12','F','IL','Democrat','https://www.duckworth.senate.gov','SenDuckworth','SenDuckworth','repduckworth');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Warren','Elizabeth','1949-06-22','F','MA','Democrat','https://www.warren.senate.gov','SenWarren','senatorelizabethwarren','senelizabethwarren');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('King','Angus','1944-03-31','M','ME','Independent','https://www.king.senate.gov','SenAngusKing','SenatorAngusSKingJr','SenatorAngusKing');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Daines','Steve','1962-08-20','M','MT','Republican','https://www.daines.senate.gov','SteveDaines','SteveDainesMT','SteveDainesMT');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Cramer','Kevin','1961-01-21','M','ND','Republican','https://www.cramer.senate.gov','SenKevinCramer','CongressmanKevinCramer','kevincramer');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Fischer','Deb','1951-03-01','F','NE','Republican','https://www.fischer.senate.gov','SenatorFischer','senatordebfischer','senatordebfischer');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Cruz','Ted','1970-12-22','M','TX','Republican','https://www.cruz.senate.gov','SenTedCruz','SenatorTedCruz','sentedcruz');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Kaine','Timothy','1958-02-26','M','VA','Democrat','https://www.kaine.senate.gov','','SenatorKaine','SenatorTimKaine');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Booker','Cory','1969-04-27','M','NJ','Democrat','https://www.booker.senate.gov','SenBooker','','SenCoryBooker');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Sullivan','Dan','1964-11-13','M','AK','Republican','https://www.sullivan.senate.gov','SenDanSullivan','SenDanSullivan','');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Ernst','Joni','1970-07-01','F','IA','Republican','https://www.ernst.senate.gov','SenJoniErnst','senjoniernst','');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Tillis','Thom','1960-08-30','M','NC','Republican','https://www.tillis.senate.gov','SenThomTillis','SenatorThomTillis','');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Rounds','Mike','1954-10-24','M','SD','Republican','https://www.rounds.senate.gov','SenatorRounds','SenatorMikeRounds','');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Sasse','Benjamin','1972-02-22','M','NE','Republican','https://www.sasse.senate.gov/public','SenSasse','SenatorSasse','');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Kennedy','John','1951-11-21','M','LA','Republican','https://www.kennedy.senate.gov/public','SenJohnKennedy','JohnKennedyLouisiana','');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Hassan','Margaret','1958-02-27','F','NH','Democrat','https://www.hassan.senate.gov','SenatorHassan','SenatorHassan','');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Cortez Masto','Catherine','1964-03-29','F','NV','Democrat','https://www.cortezmasto.senate.gov','SenCortezMasto','SenatorCortezMasto','');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Marshall','Roger','1960-08-09','M','KS','Republican','https://www.marshall.senate.gov','SenatorMarshall','','');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Rosen','Jacky','1957-08-02','F','NV','Democrat','https://www.rosen.senate.gov','SenJackyRosen','RepJackyRosen','');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Smith','Tina','1958-03-04','F','MN','Democrat','https://www.smith.senate.gov','SenTinaSmith','USSenTinaSmith','');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Hyde-Smith','Cindy','1959-05-10','F','MS','Republican','https://www.hydesmith.senate.gov','SenHydeSmith','','');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Scott','Rick','1952-12-01','M','FL','Republican','https://www.rickscott.senate.gov','SenRickScott','RickScottSenOffice','');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Braun','Mike','1954-03-24','M','IN','Republican','https://www.braun.senate.gov','SenatorBraun','','');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Hawley','Joshua','1979-12-31','M','MO','Republican','https://www.hawley.senate.gov','SenHawleyPress','','');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Romney','Mitt','1947-03-12','M','UT','Republican','https://www.romney.senate.gov','SenatorRomney','','');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Kelly','Mark','1964-02-21','M','AZ','Democrat','https://www.kelly.senate.gov','SenMarkKelly','SenMarkKelly','');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Lummis','Cynthia','1954-09-10','F','WY','Republican','https://www.lummis.senate.gov','SenLummis','','');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Tuberville','Tommy','1954-09-18','M','AL','Republican','https://www.tuberville.senate.gov','SenTuberville','','');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Hickenlooper','John','1952-02-07','M','CO','Democrat','https://www.hickenlooper.senate.gov','SenatorHick','','');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Hagerty','Bill','1959-08-14','M','TN','Republican','https://www.hagerty.senate.gov','SenatorHagerty','','');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Padilla','Alejandro','1973-03-22','M','CA','Democrat','https://www.padilla.senate.gov','SenAlexPadilla','','');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Ossoff','Jon','1987-02-16','M','GA','Democrat','https://www.ossoff.senate.gov','SenOssoff','','');
INSERT INTO SENATOR (lname,fname,birthday,gender,state,party,url,twitter,facebook,youtube) VALUES ('Warnock','Raphael','1969-07-23','M','GA','Democrat','https://www.warnock.senate.gov','SenatorWarnock','','');
In [ ]: