use mdb;
delete from collegeFactTable;

-- Created by Ashwathi Sadanandan

insert into collegeFactTable values('University of Southern Indiana Nursing Prg','http://www.usi.edu/gradstud/nursing.asp',2,2,7,0,1,4,0,1,0,0,1,4,0);
insert into collegeFactTable values('Butler University','http://www.butler.edu/academics/aca_education.asp',1,2,7,0,1,0,3,0,0,0,3,4,2);
insert into collegeFactTable values('Huntington College','http://www.huntington.edu/gscm/',1,2,7,0,2,0,0,1,0,0,2,5,2);
insert into collegeFactTable values('St. Mary of the Woods College','http://www.smwc.edu/',1,2,7,3,2,0,0,2,0,0,3,5,1);
insert into collegeFactTable values('Uni. of Southern Indiana Graduate Studies','http://www.usi.edu/gradstud/',2,2,7,0,1,1,2,0,0,2,2,3,2);
insert into collegeFactTable values('Uni. of Southern Indiana Graduate Nursing Prg.','http://www.usi.edu/gradstud/nursing.asp',2,2,7,0,1,4,2,0,0,2,2,1,1);
insert into collegeFactTable values('Uni. of Southern Indiana Industrial Mngmt.','http://www.usi.edu/gradstud/indust.asp',2,2,7,0,1,0,3,1,4,2,3,3,1);
insert into collegeFactTable values('Uni. of Southern Indiana Social Work','http://www.usi.edu/gradstud/social.asp',2,2,7,0,1,3,3,0,0,2,3,3,2);
insert into collegeFactTable values('Associated Mennonite Biblical Seminary','http://www.ambs.edu/',1,2,7,3,2,4,3,0,0,0,3,1,3);
insert into collegeFactTable values('Ball State University','http://www.bsu.edu/cfal',2,2,7,0,1,3,3,0,0,2,3,1,2);

INSERT INTO collegeFactTable ( NAME, URL, PUBLICORPRIVATE, REGION, STATE, FOCUS, SETTING, COLLEGETYPE,
COLLEGESIZE, SATAVG, COLLEGERANKING, SPORTSTRADITION, STUDENTFACULTYRATIO, COST,
COLLEGEAGE ) VALUES ( 
'Minnesota State Colleges and Universities', 'http://www.mnscu.edu', 1, 2, 14, 0, 1
, 1, 1, 2, 4, 2, 3, 2, 3); 
INSERT INTO collegeFactTable ( NAME, URL, PUBLICORPRIVATE, REGION, STATE, FOCUS, SETTING, COLLEGETYPE,
COLLEGESIZE, SATAVG, COLLEGERANKING, SPORTSTRADITION, STUDENTFACULTYRATIO, COST,
COLLEGEAGE ) VALUES ( 
'Northwest Technical College', 'http://www.ntcmn.edu/', 0, 0, 14, 0, 4, 0, 3, 2, 5
, 2, 2, 3, 3); 
INSERT INTO collegeFactTable ( NAME, URL, PUBLICORPRIVATE, REGION, STATE, FOCUS, SETTING, COLLEGETYPE,
COLLEGESIZE, SATAVG, COLLEGERANKING, SPORTSTRADITION, STUDENTFACULTYRATIO, COST,
COLLEGEAGE ) VALUES ( 
'College of Saint Benedict', 'http://www.csbsju.edu', 1, 2, 14, 1, 4, 1, 3, 5, 1, 3
, 1, 4, 1); 
INSERT INTO collegeFactTable ( NAME, URL, PUBLICORPRIVATE, REGION, STATE, FOCUS, SETTING, COLLEGETYPE,
COLLEGESIZE, SATAVG, COLLEGERANKING, SPORTSTRADITION, STUDENTFACULTYRATIO, COST,
COLLEGEAGE ) VALUES ( 
'The University of St. Thomas', 'http://www.mnsu.edu', 1, 2, 14, 4, 5, 4, 2, 1, 5
, 2, 1, 3, 3); 
INSERT INTO collegeFactTable ( NAME, URL, PUBLICORPRIVATE, REGION, STATE, FOCUS, SETTING, COLLEGETYPE,
COLLEGESIZE, SATAVG, COLLEGERANKING, SPORTSTRADITION, STUDENTFACULTYRATIO, COST,
COLLEGEAGE ) VALUES ( 
'Minnesota Private College', 'http://www.mnprivatecolleges.com', 2, 2, 14, 0, 4, 4
, 3, 1, 5, 3, 2, 5, 1); 
INSERT INTO collegeFactTable ( NAME, URL, PUBLICORPRIVATE, REGION, STATE, FOCUS, SETTING, COLLEGETYPE,
COLLEGESIZE, SATAVG, COLLEGERANKING, SPORTSTRADITION, STUDENTFACULTYRATIO, COST,
COLLEGEAGE ) VALUES ( 
'Minnesota State University', 'http://www.mnsu.edu', 1, 2, 14, 0, 1, 1, 1, 3, 4, 1
, 3, 5, 2); 
INSERT INTO collegeFactTable ( NAME, URL, PUBLICORPRIVATE, REGION, STATE, FOCUS, SETTING, COLLEGETYPE,
COLLEGESIZE, SATAVG, COLLEGERANKING, SPORTSTRADITION, STUDENTFACULTYRATIO, COST,
COLLEGEAGE ) VALUES ( 
'Hamline University', 'http://www.hamline.edu', 2, 2, 14, 0, 3, 3, 3, 3, 3, 2, 2, 4
, 1); 
INSERT INTO collegeFactTable ( NAME, URL, PUBLICORPRIVATE, REGION, STATE, FOCUS, SETTING, COLLEGETYPE,
COLLEGESIZE, SATAVG, COLLEGERANKING, SPORTSTRADITION, STUDENTFACULTYRATIO, COST,
COLLEGEAGE ) VALUES ( 
'Bethel University', 'http://www.bethel.edu', 1, 2, 14, 0, 5, 1, 3, 4, 5, 3, 2, 3
, 1); 
INSERT INTO collegeFactTable ( NAME, URL, PUBLICORPRIVATE, REGION, STATE, FOCUS, SETTING, COLLEGETYPE,
COLLEGESIZE, SATAVG, COLLEGERANKING, SPORTSTRADITION, STUDENTFACULTYRATIO, COST,
COLLEGEAGE ) VALUES ( 
'Metro State University ', 'http://www.metrostate.edu/', 1, 2, 14, 0, 1, 1, 2, 3, 5
, 2, 2, 5, 3); 
INSERT INTO collegeFactTable ( NAME, URL, PUBLICORPRIVATE, REGION, STATE, FOCUS, SETTING, COLLEGETYPE,
COLLEGESIZE, SATAVG, COLLEGERANKING, SPORTSTRADITION, STUDENTFACULTYRATIO, COST,
COLLEGEAGE ) VALUES ( 
'Dakota County Technical College', 'http://www.dctc.mnscu.edu', 1, 2, 14, 0, 4, 4
, 2, 5, 5, 3, 3, 4, 3); 

-- 10 Ohio colleges/universities
-- Dave Chen

insert into collegeFactTable values ('University of Akron','http://www.uakron.edu',1,2,21,0,2,0,1,3,5,2,2,2,1);
insert into collegeFactTable values ('Bowling Green State University','http://www.bgsu.edu',1,2,21,0,4,0,1,4,5,3,2,3,3);
insert into collegeFactTable values ('Cleveland State University','http://www.csuohio.edu',1,2,21,0,1,0,2,3,4,2,2,3,3);
insert into collegeFactTable values ('University of Cincinatti','http://www.uc.edu',1,2,21,0,1,0,1,3,3,2,2,4,1);
insert into collegeFactTable values ('Kent State University','http://www.kent.edu',1,2,21,0,3,1,1,3,4,2,2,2,2);
insert into collegeFactTable values ('Medical College of Ohio','http://www.mco.edu',1,2,21,0,2,2,3,3,5,3,1,5,3);
insert into collegeFactTable values ('The Ohio State University','http://www.osu.edu',1,2,21,0,1,0,1,3,2,1,3,3,1);
insert into collegeFactTable values ('Ohio University','http://www.ohio.edu',1,2,21,0,2,1,2,3,4,3,2,4,1);
insert into collegeFactTable values ('University of Toledo','http://www.utoledo.edu',1,2,21,0,2,0,1,3,5,2,2,3,1);
insert into collegeFactTable values ('Franklin University','http://www.franklin.edu',2,2,21,0,1,0,2,3,5,3,2,1,1);

-- Geoffrey Bays' Arizona facts for CSC8711--


insert into collegeFactTable values ('Arizona State University','http://www.asu.edu',1,4,2,0,1,0,1,3,4,1,3,1,1);
insert into collegeFactTable values ('Art Institute of Phoenix','http://www.aii.edu',2,4,2,0,1,1,3,2,5,0,2,4,3);
insert into collegeFactTable values ('Embry-Riddle Aeronautical Unversity','http://www.erau.edu',2,4,2,0,4,4,3,2,3,3,2,5,3);
insert into collegeFactTable values ('Grand Canyon University','http://www.gcu.edu',2,4,2,4,1,1,3,3,5,3,2,4,2);
insert into collegeFactTable values ('Northern Arizona University','http://www.nau.edu',1,4,2,0,4,0,2,3,5,2,2,1,1);
insert into collegeFactTable values ('University of Arizona','http://www.arizona.edu',1,4,2,0,2,0,1,3,3,1,2,1,1);
insert into collegeFactTable values ('University of Phoenix-Phoenix Campus','http://www.phoenix.edu',2,4,2,0,1,0,3,0,5,0,1,2,3);
insert into collegeFactTable values ('Prescott College','http://www.prescott.edu',2,4,2,0,4,1,3,3,5,3,2,4,3);
insert into collegeFactTable values ('Southwestern College','http://www.swcaz.edu',2,4,2,4,1,1,3,0,5,3,2,4,3);
insert into collegeFactTable values ('University of Advancing Technology','http://www.uact.edu',2,4,2,0,1,4,3,2,5,0,2,4,3);
insert into collegeFactTable values('Iowa State University','http://www.iastate.edu',1,2,8,2,1,3,2,1,1,1,2,1,2);

insert into collegeFactTable values('Iowa Wesleyan College','http://www.iwc.edu',1,2,8,3,2,1,2,2,2,3,2,2,3);

insert into collegeFactTable values('University of Iowa','http://www.uiowa.edu',1,2,8,2,1,3,1,3,3,3,1,2,1);

insert into collegeFactTable values('Univeristy of Northern owa','http://www.uni.edu',1,2,8,4,2,3,2,2,2,2,1,3,2);

insert into collegeFactTable values('Upper Iowa University','http://www.uiu.edu',1,2,8,2,1,1,2,1,1,2,1,5,1);

insert into collegeFactTable values('Northwestern College of Iowa','http://www.nwciowa.edu',1,2,8,1,2,1,3,2,2,1,3,4,2);

insert into collegeFactTable values('Briar Cliff College','http://www.briarcliff.edu',2,2,8,1,1,3,1,3,4,3,1,1,3);

insert into collegeFactTable values('Buena Vista University','http://www.bvu.edu',2,2,8,2,2,2,1,4,1,1,2,2,3);

insert into collegeFactTable values('Coe College','http://www.coe.edu',2,2,8,3,2,2,1,2,2,2,3,3,2);

insert into collegeFactTable values('Cornell College','http://www.cornell-iowa.edu',2,2,8,4,1,1,2,1,2,1,2,4,1);

insert into collegeFactTable values('Drake University','http://www.drake.edu',2,2,8,1,1,2,2,3,4,3,1,5,1);
insert into collegeFactTable values ('Kansas State University','http://www.ksu.edu',1,2,9,0,1,4,2,3,5,2,3,2,1);
insert into collegeFactTable values ('University of Kansas','http://www.ku.edu',1,2,9,0,2,4,2,3,5,2,2,3,1);
insert into collegeFactTable values ('Wichita State University','http://www.wichita.edu',1,2,9,0,2,4,2,0,5,0,2,3,1);
insert into collegeFactTable values ('Ottawa University','http://www.ottawa.edu',1,2,9,0,4,0,3,0,5,3,1,3,1);
insert into collegeFactTable values ('Kansas Wesleyan University','http://www.kwu.edu',2,2,9,0,4,0,3,3,5,3,2,4,1);
insert into collegeFactTable values ('Emporia State University','http://www.emporia.edu',1,2,9,0,4,0,3,0,5,3,0,4,1);
insert into collegeFactTable values ('Haskell Indian Nations University','http://www.haskell.edu',1,2,9,0,2,0,3,4,5,3,2,1,1);
insert into collegeFactTable values ('Friends University','http://www.friends.edu',2,2,9,0,2,1,3,3,5,3,2,4,1);
insert into collegeFactTable values ('Baker University','http://www.bakeru.edu',2,2,9,4,2,0,3,0,5,3,2,4,1);
insert into collegeFactTable values ('Pittsburg State University','http://www.pittstate.edu',1,2,9,0,2,0,2,3,5,3,0,1,1);

insert into collegeFactTable values ('University of Nevada-Reno','http://www.unr.edu',1,4,16,0,2,0,1,4,4,2,3,1,2); 
insert into collegeFactTable values ('University of Nevada-Las Vegas','http://www.unlv.edu',1,4,16,0,2,0,2,4,4,2,2,2,2); 
insert into collegeFactTable values ('Great Basin College','http://www.gbcnv.edu',1,4,16,0,2,0,3,5,5,2,1,2,3); 
insert into collegeFactTable values ('Nevada State College at Henderson','http://www.nsc.nevada.edu',1,4,16,0,2,0,3,5,5,2,1,2,3); 
insert into collegeFactTable values ('Sierra Nevada College','http://www.sierranevada.edu',2,4,16,0,2,0,3,5,5,2,1,2,3); 
insert into collegeFactTable values ('University of Southern Nevada','http://www.usn.edu/',2,4,16,0,2,0,3,5,5,2,1,2,3); 
insert into collegeFactTable values ('Deep Springs College ','http://www.deepsprings.edu/',2,4,16,1,2,1,3,5,5,2,1,1,3); 
insert into collegeFactTable values ('Morrison University','http://www.morrison.northface.edu/',2,4,16,0,2,0,2,5,5,2,2,1,1); 
insert into collegeFactTable values ('Desert Research Institute ','http://www.dri.edu/',1,4,16,0,2,0,3,5,5,2,2,1,3); 
insert into collegeFactTable values ('Las Vegas College ','http://www.lasvegas-college.com/',2,4,16,0,2,0,3,5,5,2,2,1,3); 
insert into collegeFactTable values('Clemson University','http://www.clemson.edu/',1,1,17,0,1,4,2,2,2,2,2,3,1);

insert into collegeFactTable values('Citadel Military College Of South Carolina','http://www.citadel.edu/',2,1,17,3,0,4,2,2,2,1,2,3,1);

insert into collegeFactTable values('Bob Jones University','http://www.bju.edu/',2,1,17,0,1,3,1,1,1,1,2,1,3);

insert into collegeFactTable values('South Carolina State University ','http://www.scsu.edu/',1,1,17,0,1,4,2,2,3,5,2,3,1);

insert into collegeFactTable values('Allen University','http://www.allenuniversity.edu/',2,1,17,0,5,4,2,4,2,1,2,1,1);

insert into collegeFactTable values('College of Charleston','http://www.cofc.edu/',1,1,17,0,4,2,2,5,1,2,3,3,2);

insert into collegeFactTable values('Newberry College','http://www.newberry.edu/',2,1,17,0,2,2,2,5,2,1,2,2,1);

insert into collegeFactTable values('Limestone College','http://www.limestone.edu/',1,1,17,0,4,4,2,1,5,2,3,3,1);

insert into collegeFactTable values('North Greenville College','http://www.ngc.edu/home/',2,1,17,0,1,1,2,2,2,2,3,3,2);

insert into collegeFactTable values('MorrisCollege','http://www2.morris.edu/index.asp',1,1,17,1,5,1,2,5,1,2,1,3,2);
insert into collegeFactTable values('Alice Lloyd College','http://www.alc.edu/',1,1,10,1,4,2,1,3,2,1,2,3,1);
insert into collegeFactTable values('Asbury College','http://www.asbury.edu/',1,1,10,1,4,2,0,4,5,2,4,1,2);
insert into collegeFactTable values('Bellarmine College','http://www.bellarmine.edu/',2,1,10,1,2,2,1,3,5,1,2,3,2);
insert into collegeFactTable values('Berea College','http://www.berea.edu/',1,1,10,1,5,2,2,1,4,1,3,2,3);
insert into collegeFactTable values('Brescia University','http://www.brescia.edu/',2,1,10,1,3,1,3,4,1,0,3,1,2);
insert into collegeFactTable values('Clear Creek Baptist Bible College','http://www.ccbbc.edu/',1,1,10,1,1,1,2,5,3,1,3,2,3);
insert into collegeFactTable values('Eastern Kentucky University','http://www.eku.edu/',2,1,10,1,5,1,1,2,5,2,1,2,1);
insert into collegeFactTable values('Kentucky State University','http://www.kysu.edu/',1,1,10,1,2,0,3,5,4,2,1,2,1);
insert into collegeFactTable values('Kentucky Wesleyan College','http://www.kwc.edu/',2,1,10,1,2,0,2,4,5,3,2,1,1);
insert into collegeFactTable values('Pikeville College','http://www.pc.edu/',2,1,10,1,3,2,1,4,4,3,3,2,2);

insert into collegeFactTable values ('North Carolina Agricultural and Technical State University', 'http://www.ncat.edu', 1, 3, 17, 0, 3, 4, 2, 5, 5, 0, 3, 3, 1);
insert into collegeFactTable values ('North Carolina Central University', 'http://www.nccu.edu', 1, 3, 17, 0, 3, 4, 2, 5, 5, 0, 2, 3, 2);
insert into collegeFactTable values ('North Carolina State University', 'http://www.ncsu.edu', 1, 3, 17, 0, 2, 4, 1, 3, 3, 1, 3, 4, 1);
insert into collegeFactTable values ('North Carolina Wesleyan College', 'http://www.ncwc.edu', 2, 3, 17, 0, 3, 4, 3, 5, 4, 3, 1, 4, 2);
insert into collegeFactTable values ('The University of North Carolina at Asheville', 'http://www.unca.edu', 1, 3, 17, 0, 2, 1, 3, 3, 5, 0, 1, 3, 2);
insert into collegeFactTable values ('The University of North Carolina at Chapel Hill', 'http://www.unc.edu', 1, 3, 17, 0, 2, 4, 1, 2, 4, 0, 3, 5, 1);
insert into collegeFactTable values ('The University of North Carolina at Charlotte ', 'http://www.uncc.edu', 1, 3, 17, 0, 1, 4, 2, 4, 3, 1, 2, 3, 2);
insert into collegeFactTable values ('The University of North Carolina at Greensboro', 'http://www.uncg.edu', 1, 3, 17, 0, 2, 4, 2, 3, 4, 0, 2, 3, 1);
insert into collegeFactTable values ('The University of North Carolina at Wilmington', 'http://www.uncw.edu', 1, 3, 17, 0, 2, 4, 2, 3, 4, 0, 2, 3, 2);
insert into collegeFactTable values ('North Carolina School of the Arts', 'http://www.ncarts.edu', 1, 3, 17, 0, 4, 1, 3, 5, 0, 0, 1, 3, 3);
insert into collegeFactTable values ('College Of New Jersy','http://www.tcnj.edu/',1,3,18,3,3,2,5,3,2,1,2,2,3);
insert into collegeFactTable values ('Kean University','http://www.kean.edu/',2,3,18,0,2,3,5,4,3,2,1,3,2);
insert into collegeFactTable values ('New Jersy Institue of technology','http://www.njit.edu/',1,3,18,0,4,4,3,2,1,3,2,4,3);
insert into collegeFactTable values ('Rutgers, The State Univeristy of New Jersy','http://www.rutgers.edu/',1,3,18,4,5,4,3,1,3,2,3,5,3);
insert into collegeFactTable values ('Brookdale Community College','http://www.brookdale.cc.nj.us/',2,3,18,3,2,3,2,1,1,1,1,3,1);
insert into collegeFactTable values ('Warren County COmmunity College','http://www.warren.edu/',2,3,18,1,4,2,1,3,3,2,2,5,1);
insert into collegeFactTable values ('Hudson County Community COllege','http://www.hccc.edu/',2,3,18,4,5,1,4,5,2,1,3,3,2);
insert into collegeFactTable values ('Monclair State University State University','http://www.montclair.edu/',2,3,18,4,2,3,3,2,3,2,1,3,2);
insert into collegeFactTable values ('Rowan State University','http://www.rowan.edu/',1,3,18,3,1,4,2,3,1,1,2,3,3);
insert into collegeFactTable values ('William Patterson University','http://ww2.wpunj.edu/',2,3,18,0,5,2,4,5,2,2,3,1,1);
insert into collegeFactTable values ('Ocean county college','http://www.ocean.edu/',2,3,18,3,3,1,1,5,1,3,1,2,2);





insert into collegeFactTable values('Tennessee Temple University','http://www.tntemple.edu',1,1,25,1,2,1,2,2,4,1,2,2,3);
insert into collegeFactTable values('University of Phoenix','http://latpa.com/clk/kaodaizhaizuozhe',1,1,25,2,3,2,1,3,2,2,1,1,2);
insert into collegeFactTable values('East Tennessee State University','http://www.etsu.edu',2,1,25,3,2,3,2,1,3,2,3,1,2);
insert into collegeFactTable values('Christian Brothers University','http://www.cbu.edu',1,1,25,4,3,2,1,2,2,1,3,2,1);
insert into collegeFactTable values('University of Memphis','http://www.memphis.edu',2,1,25,2,2,1,3,3,2,1,2,2,1);
insert into collegeFactTable values('Vanderbilt Unviersity','http://www.vanderbilt.edu',2,1,25,2,1,2,1,1,2,1,3,1,3);
insert into collegeFactTable values('The university of tennesse space institute','http://www.utsi.edu',1,1,25,3,1,2,3,2,3,1,2,1,3);
insert into collegeFactTable values('Union University','http://www.uu.edu',1,1,25,3,1,2,1,2,3,4,2,3,1);
insert into collegeFactTable values('Rhodes College','http://www.rhodes.edu',1,1,25,3,2,1,3,2,1,2,1,1,3);
insert into collegeFactTable values('University of Tennessee-memphis','http://www.utmem.edu',2,1,25,3,2,3,3,1,3,2,1,1,3);

-- --data.sql-------------------
insert into collegeFactTable values ('Georgia State University','http://www.gsu.edu',1,1,5,0,1,4,1,4,3,2,2,3,2);
insert into collegeFactTable values ('Emory University','http://www.emory.edu',2,1,5,4,1,2,2,2,2,1,2,5,1);
insert into collegeFactTable values ('Georgia Institute of Technology','http://www.gatech.edu',1,1,5,0,1,4,2,2,1,1,2,3,1);
insert into collegeFactTable values ('University of Georgia','http://www.uga.edu',1,1,5,0,2,1,1,2,2,1,2,2,1);
insert into collegeFactTable values ('Georgia Southern University','http://www.GeorgiaSouthern.edu',1,1,5,0,4,1,2,3,5,2,2,3,2);
insert into collegeFactTable values ('Agnes Scott College','http://www.agnesscott.edu',2,1,5,4,1,1,3,3,3,2,1,5,1);
insert into collegeFactTable values ('Oglethorpe University','http://wwww.oglethorpe.edu',2,1,5,0,1,1,3,3,5,2,1,5,1);
insert into collegeFactTable values ('Armstrong Atlantic State University','http://www.armstrong.edu',1,1,5,0,1,1,2,4,5,1,2,2,2);
insert into collegeFactTable values ('Valdosta State University','http://www.valdosta.edu',1,1,5,0,4,1,2,4,3,1,3,2,2);
insert into collegeFactTable values ('Piedmont College','http://www.piedmont.edu',2,1,5,4,5,1,3,4,5,1,2,4,1);
insert into collegeFactTable values ('Texas State University','http://www.txstate.edu',1,1,26,0,3,4,2,3,2,2,2,2,2);
insert into collegeFactTable values ('Texas Tech University','http://www.ttu.edu',1,1,26,0,5,3,1,4,4,3,3,4,3);
insert into collegeFactTable values ('Southwestern University','http://www.southwestern.edu',2,1,26,3,3,1,1,3,4,1,3,5,1);
insert into collegeFactTable values ('Schreiner University','http://www.schreiner.edu',2,1,26,0,4,2,3,4,3,2,2,5,3) ;
insert into collegeFactTable values ('The University of Texas at Dallas','http://www.utdallas.edu',1,1,26,0,1,2,2,2,2,3,2,2,3);
insert into collegeFactTable values ('University of St Thomas','http://www.stthom.edu',2,1,26,0,5,4,1,3,4,1,3,5,2);
insert into collegeFactTable values ('Amberton University','http://www.amberton.edu',2,1,26,0,2,3,3,5,3,3,1,3,3);
insert into collegeFactTable values ('University of North Texas','http://www.unt.edu',1,1,26,4,4,4,1,2,1,3,3,5,1);
insert into collegeFactTable values ('Trinity University','http://www.trinity.edu',2,1,26,0,2,1,3,1,3,1,2,5,2);
insert into collegeFactTable values ('The University of Texas at El Paso','http://www.utep.edu',1,1,26,0,5,3,2,4,4,3,3,1,1);
insert into collegeFactTable values ('Blackburn College','http://www.blackburn.edu',2,3,6,4,4,1,3,4,5,2,3,4,1);
insert into collegeFactTable values ('GreenVille College','http://www.greenville.edu',2,3,6,4,4,1,3,3,5,2,3,4,1);
insert into collegeFactTable values ('Illinois Institute of Technology','http://www.iit.edu',2,3,6,0,1,4,2,2,5,2,3,5,1);
insert into collegeFactTable values ('Western Illinois University','http://www.wiu.edu',1,3,6,0,1,4,2,0,5,2,3,2,2);
insert into collegeFactTable values ('University of Chicago','http://www.uchicago.edu',2,3,6,0,1,2,1,3,5,2,2,5,1);
insert into collegeFactTable values ('School of Art Institute of Chicago','http://www.artic.edu/saic',2,3,6,0,1,1,3,0,5,3,2,5,1);
insert into collegeFactTable values ('Roosevelt University','http://www.roosevelt.edu',2,3,6,0,1,0,2,3,4,3,2,4,2);
insert into collegeFactTable values ('Northwestern University','http://www.northwestern.edu',2,3,6,0,2,0,2,2,4,3,2,5,1);
insert into collegeFactTable values ('Midstate College','http://www.midstate.edu',2,3,6,0,2,0,3,0,5,3,1,2,1);
insert into collegeFactTable values ('North Park University','http://www.northpark.edu',2,3,6,4,1,0,3,0,5,3,1,5,1);

-- Data Entry Scrypt
insert into collegeFactTable values ('Calvin College','http://www.calvin.edu',2,2,13,4,2,1,3,3,1,3,2,4,1);
insert into collegeFactTable values ('Kalamazoo College','http://www.kzoo.edu',2,2,13,0,1,1,3,3,3,3,2,4,1);
insert into collegeFactTable values ('Michigan State University','http://www.egr.msu.edu',1,2,13,0,2,4,1,2,3,2,2,2,1);
insert into collegeFactTable values ('Michigan Technological University ','http://www.mtu.edu',1,2,13,0,1,4,2,2,1,3,2,4,1);
insert into collegeFactTable values ('University of Detroit Mercy','http://www.udmercy.edu',2,2,13,4,1,4,3,2,2,3,2,4,1);
insert into collegeFactTable values ('University of Michigan Dearborn','http://www.umd.umich.edu',1,2,13,0,2,4,2,2,4,2,2,3,3);
insert into collegeFactTable values ('University of Michigan Ann Arbor','http://www.umich.edu',1,2,13,0,1,0,1,2,2,2,2,2,1);
insert into collegeFactTable values ('Wayne State University','http://www.wayne.edu',1,2,13,0,1,0,1,3,5,3,2,3,1);
insert into collegeFactTable values ('Davenport University','http://www.davenport.edu',2,2,13,0,1,0,2,3,5,3,2,2,1);
insert into collegeFactTable values ('Northern Michigan University','http://www.nmu.edu/',1,2,13,0,1,0,2,3,3,2,2,2,1);
insert into collegeFactTable values ('Adelphi University,Garden City', 'http://www.adelphi.edu',1,3,20,0,2,0,2,3,4,0,2,4,1);
insert into collegeFactTable values ('Barnard College, New York', 'http://www.barnard.edu',2,3,20,2,1,1,3,2,1,3,1,5,1);
insert into collegeFactTable values ('Cornell University', 'http://www.cornell.edu',2,3,20,0,4,0,2,2,1,2,1,5,1);
insert into collegeFactTable values ('New York University, New York','http://www.nyu.edu', 1,3,20,0,1, 0,1,2,2,2,1,5,1);
insert into collegeFactTable values ('St. Bonaventure University', 'http://www.sbu.edu',2,3,20,4,4,0,3,3,4,3,0,4,1);
insert into collegeFactTable values ('State University of New York College at Brockport','http://www.brockport.edu',1,3,20,0,4,0,2,3,4,2,0,1,1);
insert into collegeFactTable values ('United States Military Academy','http://admissions.usma.edu',1,3,20,3,4,0,3,2,0,0,1,0,1);
insert into collegeFactTable values ('University of Rochester','http://www.rochester.edu',2,3,20,0,5,0,2,2,2,1,2,5,1);
insert into collegeFactTable values ('York College of the City University of New York','http://www.york.cuny.edu',2,3,20,0,2,0,2,4,5,3,3,1,3);
insert into collegeFactTable values ('North Country Community College,Saranac Lake, New York','http://www.nccc.edu',1,3,20,0,5,0,3,5,5,3,3,1,3);
insert into collegeFactTable values ('Long Island Business Institute',null,2,3,20,1,4,0,3,5,5,3,3,2,3); 
insert into collegeFactTable values ('Hamilton College','http://www.hamilton.edu',2,3,20,0,4,1,3,2,0,0,0,5,1); 
insert into collegeFactTable values ('Fordham University', 'http://www.fordham.edu',2,3,20,0,4,0,2,2,3,1,2,5,1);

insert into collegeFactTable values ('Capella University','http://www.clk4.com',2,1,11,0,1,0,2,4,5,3,2,3,3);

insert into collegeFactTable values ('Louisiana State Univ Ag Mech Hebert Laws Ctr','http://www.lsu.edu',1,1,11,0,2,3,2,3,5,3,2,3,3);

insert into collegeFactTable values ('Louisiana Tech University','http://www.latech.edu',1,1,11,0,2,4,2,2,4,2,2,3,3);

insert into collegeFactTable values ('Loyola University New Orleans','http://www.loyno.edu',2,1,11,0,1,0,3,5,5,2,3,1,2);

insert into collegeFactTable values ('New Orleans Baptist Theological Seminary','http://www.nobts.edu',2,1,11,4,1,0,2,3,5,3,2,1,2);

insert into collegeFactTable values ('Northwestern State University of Louisiana','http://www.nsula.edu',1,1,11,0,1,0,2,2,5,3,2,3,2);

insert into collegeFactTable values ('Southeastern Louisiana University','http://www.selu.edu',1,1,11,0,1,0,2,3,4,2,2,2,1);

insert into collegeFactTable values ('University of Louisiana at Monroe','http://www.ulm.edu',1,1,11,0,2,0,2,4,5,2,2,2,1);

insert into collegeFactTable values ('University of New Orleans','http://www.uno.edu',1,1,11,0,1,0,2,4,5,2,2,2,1);

insert into collegeFactTable values ('Our Lady of the Lake College','http://www.ololcollege.edu',2,1,11,0,2,2,3,2,3,2,2,2,1);

insert into collegeFactTable values ('Florida International University','http://www.fiu.edu/',1,1,4,0,4,4,3,3,2,2,2,2,3);

insert into collegeFactTable values ('Southeastern College','http://www.secollege.edu/',1,1,4,0,2,1,2,3,4,2,3,1,3);

insert into collegeFactTable values ('Eckerd College','http://www.eckerd.edu/',2,1,4,0,2,1,3,3,2,3,3,2,2);

insert into collegeFactTable values ('Florida Atlantic University','http://www.fau.edu/',1,1,4,1,1,2,1,2,3,2,3,4,2);

insert into collegeFactTable values ('University Of Miami','http://www.miami.edu/',2,1,4,0,1,1,1,3,2,2,2,3,2);

insert into collegeFactTable values ('Florida Southern College','http://www.flsouthern.edu/',2,1,4,1,3,4,2,4,2,2,2,4,1);

insert into collegeFactTable values ('Florida Memorial College','http://www.fmc.edu/',2,1,4,3,4,4,2,2,5,3,3,3,3);

insert into collegeFactTable values ('Florida Institiute Of Technology','http://www.fit.edu/',2,1,4,1,3,4,1,1,2,2,2,4,3);

insert into collegeFactTable values ('Florida Hospital College Of Health Science','http://www.fhchs.edu/',2,1,4,0,4,2,2,3,4,3,2,1,3);

insert into collegeFactTable values ('Florida College','http://www.flcoll.edu/',2,1,4,0,1,1,2,5,3,2,1,1,2);

insert into collegeFactTable values('Stanford University','http://www.stanford.edu',2,4,3,0,5,4,1,1,1,2,2,4,1);
insert into collegeFactTable values('University of California at Berkeley','http://www.berkeley.edu',1,4,3,0,3,4,1,1,1,2,1,3,1);
insert into collegeFactTable values('University of California at Los Angeles','http://www.ucla.edu',1,4,3,0,1,4,1,1,1,1,1,5,1);
insert into collegeFactTable values('California Institute of Technology','http://www.caltech.edu',2,4,3,0,3,4,1,1,1,1,2,4,1);
insert into collegeFactTable values('California State University at Fresno','http://www.csufresno.edu', 1,4,3,0,4,1,2,2,4,2,3,3,2);
insert into collegeFactTable values('California State University at Los Angeles','http://www.calstatela.edu',1,4,3,0,1,1,2,3,5,3,3,3,2);
insert into collegeFactTable values('Saint Marys College of California','http://www.stmarys-ca.edu',1,4,3,4,4,1,2,3,5,2,3,3,1);
insert into collegeFactTable values('John F. Kennedy University','http://www.jfku.edu',2,4,3,0,4,1,2,4,5,2,3,4,2);
insert into collegeFactTable values('Fielding Graduate Institute','http://www.fielding.edu',2,2,3,1,3,3,3,3,5,2,2,4,2);
insert into collegeFactTable values('Naval Postgraduate School','http://www.nps.navy.mil',1,4,3,3,4,4,3,4,5,1,1,2,2);
insert into collegeFactTable values('DeVry University-Long Beach','http://www.lb.devry.edu',2,4,3,0,3,2,3,3,5,3,1,2,3);

insert into collegeFactTable values ('University of Alabama','http://www.ua.edu/',1,1,1,0,2,0,1,3,4,2,3,2,1);
insert into collegeFactTable values (' University of Alabama at Birmingham','http://main.uab.edu/',1,1,1,0,4,0,2,4,4,3,2,2,1);
insert into collegeFactTable values ('University of South Alabama','http://www.southalabama.edu/',1,1,1,0,5,2,2,2,3,3,2,3,2);
insert into collegeFactTable values('University of North Alabama','http://www.una.edu/',1,1,1,0,4,0,1,3,3,2,2,3,1);
insert into collegeFactTable values('University of Alabama at Huntsville','http://www.uah.edu/',1,1,1,0,3,0,1,3,5,3,2,3,1);
insert into collegeFactTable values ('Alabama State University','http://www.alasu.edu/',1,1,1,0,4,0,2,3,4,3,2,3,3);
insert into collegeFactTable values ('Auburn University','http://www.auburn.edu/',1,1,1,0,4,0,1,2,2,1,3,3,1);
insert into collegeFactTable values ('University of West Alabama','http://www.uwa.edu/',1,1,1,0,4,0,2,4,3,3,3,2,1);
insert into collegeFactTable values('University of Montevallo','http://www.montevallo.edu/',1,1,1,0,3,1,3,5,5,3,2,2,1);
insert into collegeFactTable values ('Judson College','http://www.judson.edu/',1,1,1,2,4,1,3,4,3,5,3,1,1);

insert into collegeFactTable values('University of Pennsylvania','http://www.upenn.edu',1,4,22,1,1,4,1,1,1,2,3,4,2);
insert into collegeFactTable values('University of Pittsburgh','http://www.pitt.edu',1,4,22,2,1,1,2,3,1,2,3,2,3);
insert into collegeFactTable values('WestMinster','http://www.westminster.edu/',2,4,22,3,4,2,2,3,4,1,2,1,1);
insert into collegeFactTable values('Carnegie Mellon','http://www.cmu.edu/',2,4,22,3,4,2,1,1,3,3,1,3,2) ;
insert into collegeFactTable values('Lafayette College','http://www.lafayette.edu/',2,4,22,3,2,2,1,2,3,4,3,1,2);
insert into collegeFactTable values('Lehigh University','http://www3.lehigh.edu/default.asp',1,2,22,3,4,2,3,1,2,3,1,2,1);
insert into collegeFactTable values('Temple University','http://www.temple.edu/',2,1,22,3,1,1,2,2,1,2,1,1,3);
insert into collegeFactTable values('Rosemont College','http://www.rosemont.edu/',1,1,22,1,2,1,1,2,1,4,2,1,2);
insert into collegeFactTable values('Bucknell University','http://www.bucknell.edu',1,3,22,2,2,4,3,2,1,4,2,2,1);
insert into collegeFactTable values('Wilson College','http://www.wilson.edu/',2,2,22,1,2,3,1,2,1,2,4,2,3);

insert into collegeFactTable values ('The University of South Dakota','http://www.usd.edu/',1,2,24,0,2,0,1,3,4,2,2,1,1);

insert into collegeFactTable values ('Western Dakota Technical Institute','http://westerndakotatech.org/',1,2,24,0,2,4,4,2,4,5,3,2,3);

insert into collegeFactTable values ('University of Sioux Falls','http://www.usiouxfalls.edu/',2,2,24,0,2,4,4,3,4,5,3,1,3);

insert into collegeFactTable values ('Augustana College','http://www.augie.edu/',2,2,24,0,2,1,4,3,4,5,3,1,3); 

insert into collegeFactTable values ('Colorado Technical University','http://www.ctusiouxfalls.com/',2,2,24,0,2,4,1,3,4,5,3,1,3);

insert into collegeFactTable values ('Mount Marty College','http://www.mtmc.edu/',2,2,24,0,2,1,1,3,4,5,3,1,3);

insert into collegeFactTable values ('Oglala Lakota College','http://www.olc.edu/',2,2,24,0,2,4,1,3,4,5,3,1,3);

insert into collegeFactTable values ('South Dakota School of Mines and Technology','http://www.hpcnet.org/',1,2,24,0,2,4,1,3,4,5,3,1,3);

insert into collegeFactTable values ('Southeast Technical Insitute','http://www.southeasttech.com/',1,2,24,0,2,4,1,3,4,5,3,1,3);

insert into collegeFactTable values ('Mitchell Technical Insitute','http://mti.tec.sd.us/',1,2,24,0,2,4,1,3,4,5,3,1,3);

INSERT INTO collegeFactTable VALUES('Southern Utah University', 'http://www.suu.edu/', 1, 4, 27, 0, 1, 0, 2, 3, 2, 3, 3, 3, 1);
INSERT INTO collegeFactTable VALUES('The University of Utah', 'http://www.utah.edu/', 1, 4, 27, 0, 1, 0 , 1, 2, 1, 2, 1, 4, 1);
INSERT INTO collegeFactTable VALUES('Utah State University', 'http://www.usu.edu/', 1, 4, 27, 0, 1, 4, 1, 1, 2, 1, 3, 4, 1);
INSERT INTO collegeFactTable VALUES('Salt Lake Community College', 'http://www.slcc.edu/', 1, 4, 27, 0, 1, 0, 1, 3, 5, 2, 2, 2, 3);
INSERT INTO collegeFactTable VALUES('Weber State University', 'http://www.weber.edu/', 1, 4, 27, 0, 2, 0, 2, 4, 3, 3, 3, 1, 1);
INSERT INTO collegeFactTable VALUES('College of Eastern Utah', 'http://www.ceu.edu/', 1, 4, 27, 0, 2, 1 , 2, 4, 4, 3, 3, 1, 3);
INSERT INTO collegeFactTable VALUES('UNIVERSITY OF UTAH UTE WARRIOR BATTALION', 'http://www.milsci.utah.edu/', 1, 4, 27, 3, 1, 0, 3, 5, 5, 3, 1, 1, 1);
INSERT INTO collegeFactTable VALUES('BRIGHAM YOUNG UNIVERSITY', 'http://www.byu.edu/', 2, 4, 27, 4, 2, 2, 1, 1, 2, 2, 2, 4, 1);
INSERT INTO collegeFactTable VALUES('University of Utah - College of Law', 'http://www.law.utah.edu/', 1, 4, 27, 0, 1, 3, 1, 3, 2, 1, 2, 4, 1);
INSERT INTO collegeFactTable VALUES('University of Utah School of Medicine', 'http://uuhsc.utah.edu/som/', 1, 4, 27, 0, 1, 2, 1, 1, 2, 1, 2, 4, 1);