-- team data
INSERT INTO `scoreboard`.`team_data`
(division, conference, fullname, filename, abbreviated, cfbd_div, cfbd_conf, cfbd_team, cfbd_nicknames, massey_div, massey_conf, massey_name, massey_team, massey_nicknames)
VALUES ('FBS','ACC','Boston College Eagles','bostoncollege','Boston College','fbs','ACC','Boston College','BC','P4','ACC','Boston College','Boston_College',NULL),
('FBS','ACC','California Golden Bears','california','California','fbs','ACC','California','CAL','P4','ACC','California','California',NULL),
('FBS','ACC','Clemson Tigers','clemson','Clemson','fbs','ACC','Clemson','CLEM','P4','ACC','Clemson','Clemson',NULL),
('FBS','ACC','Duke Blue Devils','duke','Duke','fbs','ACC','Duke','DUKE','P4','ACC','Duke','Duke',NULL),
('FBS','ACC','Florida State Seminoles','floridastate','Florida State','fbs','ACC','Florida State','FSU,Florida St','P4','ACC','Florida State','Florida_St',NULL),
('FBS','ACC','Georgia Tech Yellow Jackets','georgiatech','Georgia Tech','fbs','ACC','Georgia Tech','GT','P4','ACC','Georgia Tech','Georgia_Tech',NULL),
('FBS','ACC','Louisville Cardinals','louisville','Louisville','fbs','ACC','Louisville','LOU','P4','ACC','Louisville','Louisville',NULL),
('FBS','ACC','Miami Hurricanes','miami','Miami','fbs','ACC','Miami','Miami (FL),MIA','P4','ACC','Miami','Miami_FL',NULL),
('FBS','ACC','NC State Wolfpack','ncstate','NC State','fbs','ACC','NC State','NCSU,North Carolina St.','P4','ACC','NC State','NC_State',NULL),
('FBS','ACC','North Carolina Tar Heels','northcarolina','North Carolina','fbs','ACC','North Carolina','UNC','P4','ACC','North Carolina','North_Carolina',NULL),
('FBS','ACC','Pittsburgh Panthers','pittsburgh','Pittsburgh','fbs','ACC','Pittsburgh','Pitt,PITT','P4','ACC','Pittsburgh','Pittsburgh',NULL),
('FBS','ACC','SMU Mustangs','smu','SMU','fbs','ACC','SMU','Southern Methodist','P4','ACC','SMU','SMU',NULL),
('FBS','ACC','Stanford Cardinal','stanford','Stanford','fbs','ACC','Stanford','STAN','P4','ACC','Stanford','Stanford',NULL),
('FBS','ACC','Syracuse Orange','syracuse','Syracuse','fbs','ACC','Syracuse','SYR','P4','ACC','Syracuse','Syracuse',NULL),
('FBS','ACC','Virginia Cavaliers','virginia','Virginia','fbs','ACC','Virginia','UVA','P4','ACC','Virginia','Virginia',NULL),
('FBS','ACC','Virginia Tech Hokies','virginiatech','Virginia Tech','fbs','ACC','Virginia Tech','VT','P4','ACC','Virginia Tech','Virginia_Tech',NULL),
('FBS','ACC','Wake Forest Demon Deacons','wakeforest','Wake Forest','fbs','ACC','Wake Forest','WAKE','P4','ACC','Wake Forest','Wake_Forest',NULL),
('FBS','American','Army West Point Black Knights','army','Army','fbs','American Athletic','Army','ARMY','FBS','American','Army','Army',NULL),
('FBS','American','Charlotte 49ers','charlotte','Charlotte','fbs','American Athletic','Charlotte','CLT','FBS','American','Charlotte','Charlotte',NULL),
('FBS','American','ECU Pirates','ecu','ECU','fbs','American Athletic','East Carolina','ECU','FBS','American','ECU','East_Carolina',NULL),
('FBS','American','FAU Owls','fau','FAU','fbs','American Athletic','Florida Atlantic','FAU','FBS','American','FAU','FL_Atlantic',NULL),
('FBS','American','Memphis Tigers','memphis','Memphis','fbs','American Athletic','Memphis','MEM','FBS','American','Memphis','Memphis',NULL),
('FBS','American','Navy Midshipmen','navy','Navy','fbs','American Athletic','Navy','NAVY','FBS','American','Navy','Navy',NULL),
('FBS','American','North Texas Mean Green','northtexas','North Texas','fbs','American Athletic','North Texas','UNT','FBS','American','North Texas','North_Texas',NULL),
('FBS','American','Rice Owls','rice','Rice','fbs','American Athletic','Rice','RICE','FBS','American','Rice','Rice',NULL),
('FBS','American','Temple Owls','temple','Temple','fbs','American Athletic','Temple','TEM','FBS','American','Temple','Temple',NULL),
('FBS','American','Tulane Green Wave','tulane','Tulane','fbs','American Athletic','Tulane','TULN','FBS','American','Tulane','Tulane',NULL),
('FBS','American','Tulsa Golden Hurricane','tulsa','Tulsa','fbs','American Athletic','Tulsa','TLSA','FBS','American','Tulsa','Tulsa',NULL),
('FBS','American','UAB Blazers','uab','UAB','fbs','American Athletic','UAB','Alabama-Birmingham','FBS','American','UAB','UAB',NULL),
('FBS','American','USF Bulls','usf','USF','fbs','American Athletic','South Florida','USF','FBS','American','USF','South_Florida',NULL),
('FBS','American','UTSA Roadrunners','utsa','UTSA','fbs','American Athletic','UTSA','UT San Antonio,Texas-San Antonio','FBS','American','UTSA','UT_San_Antonio',NULL),
('FBS','Big 12','Arizona Wildcats','arizona','Arizona','fbs','Big 12','Arizona','ARIZ','P4','Big 12','Arizona','Arizona',NULL),
('FBS','Big 12','Arizona State Sun Devils','arizonastate','Arizona State','fbs','Big 12','Arizona State','ASU,Arizona St','P4','Big 12','Arizona State','Arizona_St',NULL),
('FBS','Big 12','Baylor Bears','baylor','Baylor','fbs','Big 12','Baylor','BAY','P4','Big 12','Baylor','Baylor',NULL),
('FBS','Big 12','BYU Cougars','byu','BYU','fbs','Big 12','BYU','Brigham Young','P4','Big 12','BYU','BYU',NULL),
('FBS','Big 12','Cincinnati Bearcats','cincinnati','Cincinnati','fbs','Big 12','Cincinnati','CIN','P4','Big 12','Cincinnati','Cincinnati',NULL),
('FBS','Big 12','Colorado Buffaloes','colorado','Colorado','fbs','Big 12','Colorado','COLO','P4','Big 12','Colorado','Colorado',NULL),
('FBS','Big 12','Houston Cougars','houston','Houston','fbs','Big 12','Houston','HOU','P4','Big 12','Houston','Houston',NULL),
('FBS','Big 12','Iowa State Cyclones','iowastate','Iowa State','fbs','Big 12','Iowa State','ISU','P4','Big 12','Iowa State','Iowa_St',NULL),
('FBS','Big 12','Kansas Jayhawks','kansas','Kansas','fbs','Big 12','Kansas','KU','P4','Big 12','Kansas','Kansas',NULL),
('FBS','Big 12','Kansas State Wildcats','kansasstate','Kansas State','fbs','Big 12','Kansas State','Kansas St,KSU','P4','Big 12','Kansas State','Kansas_St',NULL),
('FBS','Big 12','Oklahoma State Cowboys','oklahomastate','Oklahoma State','fbs','Big 12','Oklahoma State','OKST,Oklahoma St','P4','Big 12','Oklahoma State','Oklahoma_St',NULL),
('FBS','Big 12','TCU Horned Frogs','tcu','TCU','fbs','Big 12','TCU','Texas Christian','P4','Big 12','TCU','TCU',NULL),
('FBS','Big 12','Texas Tech Red Raiders','texastech','Texas Tech','fbs','Big 12','Texas Tech','TTU','P4','Big 12','Texas Tech','Texas_Tech',NULL),
('FBS','Big 12','UCF Knights','ucf','UCF','fbs','Big 12','UCF','Central Florida','P4','Big 12','UCF','UCF',NULL),
('FBS','Big 12','Utah Utes','utah','Utah','fbs','Big 12','Utah','UTAH','P4','Big 12','Utah','Utah',NULL),
('FBS','Big 12','West Virginia Mountaineers','westvirginia','West Virginia','fbs','Big 12','West Virginia','WVU','P4','Big 12','West Virginia','West_Virginia',NULL),
('FBS','Big Ten','Illinois Fighting Illini','illinois','Illinois','fbs','Big Ten','Illinois','ILL','P4','Big Ten','Illinois','Illinois',NULL),
('FBS','Big Ten','Indiana Hoosiers','indiana','Indiana','fbs','Big Ten','Indiana','IU','P4','Big Ten','Indiana','Indiana',NULL),
('FBS','Big Ten','Iowa Hawkeyes','iowa','Iowa','fbs','Big Ten','Iowa','IOWA','P4','Big Ten','Iowa','Iowa',NULL),
('FBS','Big Ten','Maryland Terrapins','maryland','Maryland','fbs','Big Ten','Maryland','MD','P4','Big Ten','Maryland','Maryland',NULL),
('FBS','Big Ten','Michigan Wolverines','michigan','Michigan','fbs','Big Ten','Michigan','MICH','P4','Big Ten','Michigan','Michigan',NULL),
('FBS','Big Ten','Michigan State Spartans','michiganstate','Michigan State','fbs','Big Ten','Michigan State','Michigan St,MSU','P4','Big Ten','Michigan State','Michigan_St',NULL),
('FBS','Big Ten','Minnesota Golden Gophers','minnesota','Minnesota','fbs','Big Ten','Minnesota','MINN','P4','Big Ten','Minnesota','Minnesota',NULL),
('FBS','Big Ten','Nebraska Cornhuskers','nebraska','Nebraska','fbs','Big Ten','Nebraska','NEB','P4','Big Ten','Nebraska','Nebraska',NULL),
('FBS','Big Ten','Northwestern Wildcats','northwestern','Northwestern','fbs','Big Ten','Northwestern','NU','P4','Big Ten','Northwestern','Northwestern',NULL),
('FBS','Big Ten','Ohio State Buckeyes','ohiostate','Ohio State','fbs','Big Ten','Ohio State','OSU','P4','Big Ten','Ohio State','Ohio_St',NULL),
('FBS','Big Ten','Oregon Ducks','oregon','Oregon','fbs','Big Ten','Oregon','ORE','P4','Big Ten','Oregon','Oregon',NULL),
('FBS','Big Ten','Penn State Nittany Lions','pennstate','Penn State','fbs','Big Ten','Penn State','PSU','P4','Big Ten','Penn State','Penn_St',NULL),
('FBS','Big Ten','Purdue Boilermakers','purdue','Purdue','fbs','Big Ten','Purdue','PUR','P4','Big Ten','Purdue','Purdue',NULL),
('FBS','Big Ten','Rutgers Scarlet Knights','rutgers','Rutgers','fbs','Big Ten','Rutgers','RUTG','P4','Big Ten','Rutgers','Rutgers',NULL),
('FBS','Big Ten','UCLA Bruins','ucla','UCLA','fbs','Big Ten','UCLA',NULL,'P4','Big Ten','UCLA','UCLA',NULL),
('FBS','Big Ten','USC Trojans','usc','USC','fbs','Big Ten','USC',NULL,'P4','Big Ten','USC','USC',NULL),
('FBS','Big Ten','Washington Huskies','washington','Washington','fbs','Big Ten','Washington','WASH','P4','Big Ten','Washington','Washington',NULL),
('FBS','Big Ten','Wisconsin Badgers','wisconsin','Wisconsin','fbs','Big Ten','Wisconsin','WIS','P4','Big Ten','Wisconsin','Wisconsin',NULL),
('FBS','Conference USA','FIU Panthers','fiu','FIU','fbs','Conference USA','Florida International','Florida Intl,FIU','FBS','Conference USA','FIU','Florida_Intl',NULL),
('FBS','Conference USA','Jacksonville State Gamecocks','jacksonvillestate','Jacksonville State','fbs','Conference USA','Jacksonville State','JVST,Jax State','FBS','Conference USA','Jacksonville State','Jacksonville_St',NULL),
('FBS','Conference USA','Kennesaw State Owls','kennesawstate','Kennesaw State','fbs','Conference USA','Kennesaw State','Kennesaw,Kennesaw St,KENN','FBS','Conference USA','Kennesaw State','Kennesaw',NULL),
('FBS','Conference USA','Liberty Flames','liberty','Liberty','fbs','Conference USA','Liberty','LIB','FBS','Conference USA','Liberty','Liberty',NULL),
('FBS','Conference USA','Louisiana Tech Bulldogs','louisianatech','Louisiana Tech','fbs','Conference USA','Louisiana Tech','LT','FBS','Conference USA','Louisiana Tech','Louisiana_Tech',NULL),
('FBS','Conference USA','Middle Tennessee Blue Raiders','middletennessee','Middle Tennessee','fbs','Conference USA','Middle Tennessee','MTSU,Middle Tennessee State','FBS','Conference USA','Middle Tennessee','MTSU',NULL),
('FBS','Conference USA','New Mexico State Aggies','newmexicostate','New Mexico State','fbs','Conference USA','New Mexico State','New Mexico St,NMSU','FBS','Conference USA','New Mexico State','New_Mexico_St',NULL),
('FBS','Conference USA','Sam Houston Bearkats','samhoustonstate','Sam Houston','fbs','Conference USA','Sam Houston','Sam Houston State,SHSU','FBS','Conference USA','Sam Houston','Sam_Houston_St',NULL),
('FBS','Conference USA','UTEP Miners','utep','UTEP','fbs','Conference USA','UTEP','Texas-El Paso','FBS','Conference USA','UTEP','UTEP',NULL),
('FBS','Conference USA','WKU Hilltoppers','wku','WKU','fbs','Conference USA','Western Kentucky','Western KY,WKU','FBS','Conference USA','WKU','WKU',NULL),
('FBS','FBS Independents','Notre Dame Fighting Irish','notredame','Notre Dame','fbs','FBS Independents','Notre Dame','ND','P4','FBS Independents 1','Notre Dame','Notre_Dame',NULL),
('FBS','FBS Independents','UConn Huskies','connecticut','UConn','fbs','FBS Independents','UConn','Connecticut,CONN','FBS','FBS Independents 2','UConn','Connecticut',NULL),
('FBS','FBS Independents','UMass Minutemen','umass','UMass','fbs','FBS Independents','Massachusetts','UMass,MASS','FBS','FBS Independents 2','UMass','Massachusetts',NULL),
('FBS','MAC','Akron Zips','akron','Akron','fbs','Mid-American','Akron','AKR','FBS','MAC','Akron','Akron',NULL),
('FBS','MAC','Ball State Cardinals','ballstate','Ball State','fbs','Mid-American','Ball State','BALL','FBS','MAC','Ball State','Ball_St',NULL),
('FBS','MAC','Bowling Green Falcons','bowlinggreen','Bowling Green','fbs','Mid-American','Bowling Green','Bowling Green State,BGSU','FBS','MAC','Bowling Green','Bowling_Green',NULL),
('FBS','MAC','Buffalo Bulls','buffalo','Buffalo','fbs','Mid-American','Buffalo','BUF','FBS','MAC','Buffalo','Buffalo',NULL),
('FBS','MAC','Central Michigan Chippewas','centralmichigan','Central Michigan','fbs','Mid-American','Central Michigan','CMU,C Michigan','FBS','MAC','Central Michigan','C_Michigan',NULL),
('FBS','MAC','Eastern Michigan Eagles','easternmichigan','Eastern Michigan','fbs','Mid-American','Eastern Michigan','EMU,E Michigan','FBS','MAC','Eastern Michigan','E_Michigan',NULL),
('FBS','MAC','Kent State Golden Flashes','kentstate','Kent State','fbs','Mid-American','Kent State','KENT','FBS','MAC','Kent State','Kent',NULL),
('FBS','MAC','Miami (OH) RedHawks','miamioh','Miami (OH)','fbs','Mid-American','Miami (OH)','M-OH,Miami OH','FBS','MAC','Miami (OH)','Miami_OH',NULL),
('FBS','MAC','Northern Illinois Huskies','northernillinois','Northern Illinois','fbs','Mid-American','Northern Illinois','N Illinois,NIU','FBS','MAC','Northern Illinois','N_Illinois',NULL),
('FBS','MAC','Ohio Bobcats','ohio','Ohio','fbs','Mid-American','Ohio','OHIO','FBS','MAC','Ohio','Ohio',NULL),
('FBS','MAC','Toledo Rockets','toledo','Toledo','fbs','Mid-American','Toledo','TOL','FBS','MAC','Toledo','Toledo',NULL),
('FBS','MAC','Western Michigan Broncos','westernmichigan','Western Michigan','fbs','Mid-American','Western Michigan','WMU,W Michigan','FBS','MAC','Western Michigan','W_Michigan',NULL),
('FBS','Mountain West','Air Force Falcons','airforce','Air Force','fbs','Mountain West','Air Force','AFA','FBS','Mountain West','Air Force','Air_Force',NULL),
('FBS','Mountain West','Boise State Broncos','boisestate','Boise State','fbs','Mountain West','Boise State','Boise St,BOIS','FBS','Mountain West','Boise State','Boise_St',NULL),
('FBS','Mountain West','Colorado State Rams','coloradostate','Colorado State','fbs','Mountain West','Colorado State','CSU,Colorado St','FBS','Mountain West','Colorado State','Colorado_St',NULL),
('FBS','Mountain West','Fresno State Bulldogs','fresnostate','Fresno State','fbs','Mountain West','Fresno State','Fresno St,FRES','FBS','Mountain West','Fresno State','Fresno_St',NULL),
('FBS','Mountain West','Hawai''i Rainbow Warriors','hawaii','Hawai''i','fbs','Mountain West','Hawai''i','HAW','FBS','Mountain West','Hawai''i','Hawaii',NULL),
('FBS','Mountain West','Nevada Wolf Pack','nevada','Nevada','fbs','Mountain West','Nevada','NEV','FBS','Mountain West','Nevada','Nevada',NULL),
('FBS','Mountain West','New Mexico Lobos','newmexico','New Mexico','fbs','Mountain West','New Mexico','UNM','FBS','Mountain West','New Mexico','New_Mexico',NULL),
('FBS','Mountain West','San Diego State Aztecs','sandiegostate','San Diego State','fbs','Mountain West','San Diego State','San Diego St,SDSU','FBS','Mountain West','San Diego State','San_Diego_St',NULL),
('FBS','Mountain West','San José State Spartans','sanjosestate','San José State','fbs','Mountain West','San José State','San Jose St.,San José St,SJSU','FBS','Mountain West','San José State','San_Jose_St',NULL),
('FBS','Mountain West','UNLV Rebels','unlv','UNLV','fbs','Mountain West','UNLV','Nevada-Las Vegas','FBS','Mountain West','UNLV','UNLV',NULL),
('FBS','Mountain West','Utah State Aggies','utahstate','Utah State','fbs','Mountain West','Utah State','USU','FBS','Mountain West','Utah State','Utah_St',NULL),
('FBS','Mountain West','Wyoming Cowboys','wyoming','Wyoming','fbs','Mountain West','Wyoming','WYO','FBS','Mountain West','Wyoming','Wyoming',NULL),
('FBS','Pac-12','Oregon State Beavers','oregonstate','Oregon State','fbs','Pac-12','Oregon State','ORST,Oregon St','P4','Pac-12','Oregon State','Oregon_St',NULL),
('FBS','Pac-12','Washington State Cougars','washingtonstate','Washington State','fbs','Pac-12','Washington State','Washington St,WSU','P4','Pac-12','Washington State','Washington_St',NULL),
('FBS','SEC','Alabama Crimson Tide','alabama','Alabama','fbs','SEC','Alabama','ALA','P4','SEC','Alabama','Alabama',NULL),
('FBS','SEC','Arkansas Razorbacks','arkansas','Arkansas','fbs','SEC','Arkansas','ARK','P4','SEC','Arkansas','Arkansas',NULL),
('FBS','SEC','Auburn Tigers','auburn','Auburn','fbs','SEC','Auburn','AUB','P4','SEC','Auburn','Auburn',NULL),
('FBS','SEC','Florida Gators','florida','Florida','fbs','SEC','Florida','FLA','P4','SEC','Florida','Florida',NULL),
('FBS','SEC','Georgia Bulldogs','georgia','Georgia','fbs','SEC','Georgia','UGA','P4','SEC','Georgia','Georgia',NULL),
('FBS','SEC','Kentucky Wildcats','kentucky','Kentucky','fbs','SEC','Kentucky','UK','P4','SEC','Kentucky','Kentucky',NULL),
('FBS','SEC','LSU Tigers','lsu','LSU','fbs','SEC','LSU','Louisiana State','P4','SEC','LSU','LSU',NULL),
('FBS','SEC','Mississippi State Bulldogs','mississippistate','Mississippi State','fbs','SEC','Mississippi State','MSST,Mississippi St','P4','SEC','Mississippi State','Mississippi_St',NULL),
('FBS','SEC','Missouri Tigers','missouri','Missouri','fbs','SEC','Missouri','MIZ','P4','SEC','Missouri','Missouri',NULL),
('FBS','SEC','Oklahoma Sooners','oklahoma','Oklahoma','fbs','SEC','Oklahoma','OU','P4','SEC','Oklahoma','Oklahoma',NULL),
('FBS','SEC','Ole Miss Rebels','olemiss','Ole Miss','fbs','SEC','Ole Miss','MISS','P4','SEC','Ole Miss','Mississippi',NULL),
('FBS','SEC','South Carolina Gamecocks','southcarolina','South Carolina','fbs','SEC','South Carolina','SC','P4','SEC','South Carolina','South_Carolina',NULL),
('FBS','SEC','Tennessee Volunteers','tennessee','Tennessee','fbs','SEC','Tennessee','TENN','P4','SEC','Tennessee','Tennessee',NULL),
('FBS','SEC','Texas Longhorns','texas','Texas','fbs','SEC','Texas','TEX','P4','SEC','Texas','Texas',NULL),
('FBS','SEC','Texas A&M Aggies','texasam','Texas A&M','fbs','SEC','Texas A&M','TA&M','P4','SEC','Texas A&M','Texas_A&M',NULL),
('FBS','SEC','Vanderbilt Commodores','vanderbilt','Vanderbilt','fbs','SEC','Vanderbilt','VAN','P4','SEC','Vanderbilt','Vanderbilt',NULL),
('FBS','Sun Belt','Appalachian State Mountaineers','appalachianstate','Appalachian State','fbs','Sun Belt','App State','Appalachian State,APP','FBS','Sun Belt','Appalachian State','Appalachian_St',NULL),
('FBS','Sun Belt','Arkansas State Red Wolves','arkansasstate','Arkansas State','fbs','Sun Belt','Arkansas State','ARST,Arkansas St','FBS','Sun Belt','Arkansas State','Arkansas_St',NULL),
('FBS','Sun Belt','Coastal Carolina Chanticleers','coastalcarolina','Coastal Carolina','fbs','Sun Belt','Coastal Carolina','Coastal Car,CCU','FBS','Sun Belt','Coastal Carolina','Coastal_Car',NULL),
('FBS','Sun Belt','Georgia Southern Eagles','georgiasouthern','Georgia Southern','fbs','Sun Belt','Georgia Southern','GASO,GA Southern','FBS','Sun Belt','Georgia Southern','Ga_Southern',NULL),
('FBS','Sun Belt','Georgia State Panthers','georgiastate','Georgia State','fbs','Sun Belt','Georgia State','GAST,Georgia St','FBS','Sun Belt','Georgia State','Georgia_St',NULL),
('FBS','Sun Belt','James Madison Dukes','jamesmadison','James Madison','fbs','Sun Belt','James Madison','JMU','FBS','Sun Belt','James Madison','James_Madison',NULL),
('FBS','Sun Belt','Louisiana Ragin'' Cajuns','louisiana','Louisiana','fbs','Sun Belt','Louisiana','UL,UL Lafayette','FBS','Sun Belt','Louisiana','Louisiana',NULL),
('FBS','Sun Belt','Marshall Thundering Herd','marshall','Marshall','fbs','Sun Belt','Marshall','MRSH','FBS','Sun Belt','Marshall','Marshall',NULL),
('FBS','Sun Belt','Old Dominion Monarchs','olddominion','Old Dominion','fbs','Sun Belt','Old Dominion','ODU','FBS','Sun Belt','Old Dominion','Old_Dominion',NULL),
('FBS','Sun Belt','South Alabama Jaguars','southalabama','South Alabama','fbs','Sun Belt','South Alabama','USA','FBS','Sun Belt','South Alabama','South_Alabama',NULL),
('FBS','Sun Belt','Southern Miss Golden Eagles','southernmiss','Southern Miss','fbs','Sun Belt','Southern Miss','Southern Mississippi,USM','FBS','Sun Belt','Southern Miss','Southern_Miss',NULL),
('FBS','Sun Belt','Texas State Bobcats','texasstate','Texas State','fbs','Sun Belt','Texas State','Texas St,TXST','FBS','Sun Belt','Texas State','Texas_St',NULL),
('FBS','Sun Belt','Troy Trojans','troy','Troy','fbs','Sun Belt','Troy','TROY','FBS','Sun Belt','Troy','Troy',NULL),
('FBS','Sun Belt','ULM Warhawks','ulm','ULM','fbs','Sun Belt','UL Monroe','Louisiana Monroe,ULM,La.-Monroe','FBS','Sun Belt','ULM','ULM',NULL),
('FCS','Big Sky','Cal Poly Mustangs','calpoly','Cal Poly','fcs','Big Sky','Cal Poly','CP','FCS','Big Sky','Cal Poly','Cal_Poly',NULL),
('FCS','Big Sky','Eastern Washington Eagles','easternwashington','Eastern Washington','fcs','Big Sky','Eastern Washington','E Washington,EWU','FCS','Big Sky','Eastern Washington','E_Washington',NULL),
('FCS','Big Sky','Idaho Vandals','idaho','Idaho','fcs','Big Sky','Idaho','IDHO','FCS','Big Sky','Idaho','Idaho',NULL),
('FCS','Big Sky','Idaho State Bengals','idahostate','Idaho State','fcs','Big Sky','Idaho State','IDST,Idaho St','FCS','Big Sky','Idaho State','Idaho_St',NULL),
('FCS','Big Sky','Montana Grizzlies','montana','Montana','fcs','Big Sky','Montana','MONT','FCS','Big Sky','Montana','Montana',NULL),
('FCS','Big Sky','Montana State Bobcats','montanastate','Montana State','fcs','Big Sky','Montana State','MTST,Montana St','FCS','Big Sky','Montana State','Montana_St',NULL),
('FCS','Big Sky','Northern Arizona Lumberjacks','northernarizona','Northern Arizona','fcs','Big Sky','Northern Arizona','NAU,N Arizona','FCS','Big Sky','Northern Arizona','Northern_Arizona',NULL),
('FCS','Big Sky','Northern Colorado Bears','northerncolorado','Northern Colorado','fcs','Big Sky','Northern Colorado','N Colorado,UNCO','FCS','Big Sky','Northern Colorado','N_Colorado',NULL),
('FCS','Big Sky','Portland State Vikings','portlandstate','Portland State','fcs','Big Sky','Portland State','PRST,Portland St','FCS','Big Sky','Portland State','Portland_St',NULL),
('FCS','Big Sky','Sacramento State Hornets','sacramentostate','Sacramento State','fcs','Big Sky','Sacramento State','Cal State Sacramento,Sacramento St,SAC','FCS','Big Sky','Sacramento State','CS_Sacramento',NULL),
('FCS','Big Sky','UC Davis Aggies','ucdavis','UC Davis','fcs','Big Sky','UC Davis','California-Davis,UCD','FCS','Big Sky','UC Davis','UC_Davis',NULL),
('FCS','Big Sky','Weber State Wildcats','weberstate','Weber State','fcs','Big Sky','Weber State','WEB,Weber St','FCS','Big Sky','Weber State','Weber_St',NULL),
('FCS','Big South-OVC','Charleston Southern Buccaneers','charlestonsouthern','Charleston Southern','fcs','Big South-OVC','Charleston Southern','CHSO,Charleston So','FCS','Big South-OVC','Charleston Southern','Charleston_So',NULL),
('FCS','Big South-OVC','Eastern Illinois Panthers','easternillinois','Eastern Illinois','fcs','Big South-OVC','Eastern Illinois','EIU,E Illinois','FCS','Big South-OVC','Eastern Illinois','E_Illinois',NULL),
('FCS','Big South-OVC','Gardner-Webb Runnin'' Bulldogs','gardnerwebb','Gardner-Webb','fcs','Big South-OVC','Gardner-Webb','Gardner Webb,GWEB','FCS','Big South-OVC','Gardner-Webb','Gardner_Webb',NULL),
('FCS','Big South-OVC','Lindenwood Lions','lindenwood','Lindenwood','fcs','Big South-OVC','Lindenwood','LIN','FCS','Big South-OVC','Lindenwood','Lindenwood',NULL),
('FCS','Big South-OVC','Southeast Missouri Redhawks','southeastmissouri','Southeast Missouri','fcs','Big South-OVC','Southeast Missouri State','Southeast Missouri,SEMO,SE Missouri','FCS','Big South-OVC','Southeast Missouri','SE_Missouri_St',NULL),
('FCS','Big South-OVC','Tennessee State Tigers','tennesseestate','Tennessee State','fcs','Big South-OVC','Tennessee State','Tennessee St,TNST','FCS','Big South-OVC','Tennessee State','Tennessee_St',NULL),
('FCS','Big South-OVC','Tennessee Tech Golden Eagles','tennesseetech','Tennessee Tech','fcs','Big South-OVC','Tennessee Tech','TNTC','FCS','Big South-OVC','Tennessee Tech','Tennessee_Tech',NULL),
('FCS','Big South-OVC','UT Martin Skyhawks','utmartin','UT Martin','fcs','Big South-OVC','UT Martin','UTM,Tennessee Martin','FCS','Big South-OVC','UT Martin','TN_Martin',NULL),
('FCS','Big South-OVC','Western Illinois Leathernecks','westernillinois','Western Illinois','fcs','Big South-OVC','Western Illinois','W Illinois,WIU','FCS','Big South-OVC','Western Illinois','W_Illinois',NULL),
('FCS','CAA','Bryant Bulldogs','bryant','Bryant','fcs','CAA','Bryant','BRY','FCS','CAA','Bryant','Bryant',NULL),
('FCS','CAA','Campbell Fighting Camels','campbell','Campbell','fcs','CAA','Campbell','CAM','FCS','CAA','Campbell','Campbell',NULL),
('FCS','CAA','Delaware Fightin'' Blue Hens','delaware','Delaware','fcs','CAA','Delaware','DEL','FCS','CAA','Delaware','Delaware',NULL),
('FCS','CAA','Elon Phoenix','elon','Elon','fcs','CAA','Elon','ELON','FCS','CAA','Elon','Elon',NULL),
('FCS','CAA','Hampton Pirates','hampton','Hampton','fcs','CAA','Hampton','HAMP','FCS','CAA','Hampton','Hampton',NULL),
('FCS','CAA','Maine Black Bears','maine','Maine','fcs','CAA','Maine','ME','FCS','CAA','Maine','Maine',NULL),
('FCS','CAA','Monmouth Hawks','monmouth','Monmouth','fcs','CAA','Monmouth','MONM,Monmouth NJ','FCS','CAA','Monmouth','Monmouth_NJ',NULL),
('FCS','CAA','New Hampshire Wildcats','newhampshire','New Hampshire','fcs','CAA','New Hampshire','UNH','FCS','CAA','New Hampshire','New_Hampshire',NULL),
('FCS','CAA','North Carolina A&T Aggies','northcarolinaat','North Carolina A&T','fcs','CAA','North Carolina A&T','NCAT,NC A&T','FCS','CAA','North Carolina A&T','NC_A&T',NULL),
('FCS','CAA','Rhode Island Rams','rhodeisland','Rhode Island','fcs','CAA','Rhode Island','URI','FCS','CAA','Rhode Island','Rhode_Island',NULL),
('FCS','CAA','Richmond Spiders','richmond','Richmond','fcs','CAA','Richmond','RICH','FCS','CAA','Richmond','Richmond',NULL),
('FCS','CAA','Stony Brook Seawolves','stonybrook','Stony Brook','fcs','CAA','Stony Brook','STBK','FCS','CAA','Stony Brook','Stony_Brook',NULL),
('FCS','CAA','Towson Tigers','towson','Towson','fcs','CAA','Towson','TOW','FCS','CAA','Towson','Towson',NULL),
('FCS','CAA','UAlbany Great Danes','albany','UAlbany','fcs','CAA','UAlbany','Albany,SUNY Albany,ALB','FCS','CAA','UAlbany','SUNY_Albany',NULL),
('FCS','CAA','Villanova Wildcats','villanova','Villanova','fcs','CAA','Villanova','VILL','FCS','CAA','Villanova','Villanova',NULL),
('FCS','CAA','William & Mary Tribe','williammary','William & Mary','fcs','CAA','William & Mary','W&M','FCS','CAA','William & Mary','William_&_Mary',NULL),
('FCS','Ivy League','Brown Bears','brown','Brown','fcs','Ivy','Brown','BRWN','FCS','Ivy','Brown','Brown',NULL),
('FCS','Ivy League','Columbia Lions','columbia','Columbia','fcs','Ivy','Columbia','COLU','FCS','Ivy','Columbia','Columbia',NULL),
('FCS','Ivy League','Cornell Big Red','cornell','Cornell','fcs','Ivy','Cornell','COR','FCS','Ivy','Cornell','Cornell',NULL),
('FCS','Ivy League','Dartmouth Big Green','dartmouth','Dartmouth','fcs','Ivy','Dartmouth','DART','FCS','Ivy','Dartmouth','Dartmouth',NULL),
('FCS','Ivy League','Harvard Crimson','harvard','Harvard','fcs','Ivy','Harvard','HARV','FCS','Ivy','Harvard','Harvard',NULL),
('FCS','Ivy League','Penn Quakers','pennsylvania','Penn','fcs','Ivy','Pennsylvania','PENN,Penn','FCS','Ivy','Penn','Penn',NULL),
('FCS','Ivy League','Princeton Tigers','princeton','Princeton','fcs','Ivy','Princeton','PRIN','FCS','Ivy','Princeton','Princeton',NULL),
('FCS','Ivy League','Yale Bulldogs','yale','Yale','fcs','Ivy','Yale','YALE','FCS','Ivy','Yale','Yale',NULL),
('FCS','MEAC','Delaware State Hornets','delawarestate','Delaware State','fcs','MEAC','Delaware State','DSU,Delaware St','FCS','MEAC','Delaware State','Delaware_St',NULL),
('FCS','MEAC','Howard Bison','howard','Howard','fcs','MEAC','Howard','HOW','FCS','MEAC','Howard','Howard',NULL),
('FCS','MEAC','Morgan State Bears','morganstate','Morgan State','fcs','MEAC','Morgan State','MORG,Morgan St','FCS','MEAC','Morgan State','Morgan_St',NULL),
('FCS','MEAC','NCCU Eagles','nccu','NCCU','fcs','MEAC','North Carolina Central','NC Central,NCCU','FCS','MEAC','NCCU','NC_Central',NULL),
('FCS','MEAC','Norfolk State Spartans','norfolkstate','Norfolk State','fcs','MEAC','Norfolk State','NORF,Norfolk St','FCS','MEAC','Norfolk State','Norfolk_St',NULL),
('FCS','MEAC','South Carolina State Bulldogs','southcarolinastate','South Carolina State','fcs','MEAC','South Carolina State','SCST,SC State','FCS','MEAC','South Carolina State','S_Carolina_St',NULL),
('FCS','MVFC','Illinois State Redbirds','illinoisstate','Illinois State','fcs','MVFC','Illinois State','Illinois St,ILST','FCS','MVFC','Illinois State','Illinois_St',NULL),
('FCS','MVFC','Indiana State Sycamores','indianastate','Indiana State','fcs','MVFC','Indiana State','INST,Indiana St','FCS','MVFC','Indiana State','Indiana_St',NULL),
('FCS','MVFC','Missouri State Bears','missouristate','Missouri State','fcs','MVFC','Missouri State','Missouri St,MOST','FCS','MVFC','Missouri State','Missouri_St',NULL),
('FCS','MVFC','Murray State Racers','murraystate','Murray State','fcs','MVFC','Murray State','MUR,Murray St','FCS','MVFC','Murray State','Murray_St',NULL),
('FCS','MVFC','North Dakota Fighting Hawks','northdakota','North Dakota','fcs','MVFC','North Dakota','UND','FCS','MVFC','North Dakota','North_Dakota',NULL),
('FCS','MVFC','North Dakota State Bison','northdakotastate','North Dakota State','fcs','MVFC','North Dakota State','N Dakota St,NDSU','FCS','MVFC','North Dakota State','N_Dakota_St',NULL),
('FCS','MVFC','Northern Iowa Panthers','northerniowa','Northern Iowa','fcs','MVFC','Northern Iowa','UNI','FCS','MVFC','Northern Iowa','Northern_Iowa',NULL),
('FCS','MVFC','South Dakota Coyotes','southdakota','South Dakota','fcs','MVFC','South Dakota','SDAK','FCS','MVFC','South Dakota','South_Dakota',NULL),
('FCS','MVFC','South Dakota State Jackrabbits','southdakotastate','South Dakota State','fcs','MVFC','South Dakota State','SDST,S Dakota St','FCS','MVFC','South Dakota State','S_Dakota_St',NULL),
('FCS','MVFC','Southern Illinois Salukis','southernillinois','Southern Illinois','fcs','MVFC','Southern Illinois','S Illinois,SIU','FCS','MVFC','Southern Illinois','S_Illinois',NULL),
('FCS','MVFC','Youngstown State Penguins','youngstownstate','Youngstown State','fcs','MVFC','Youngstown State','Youngstown St,YSU','FCS','MVFC','Youngstown State','Youngstown_St',NULL),
('FCS','Northeast','CCSU Blue Devils','ccsu','CCSU','fcs','NEC','Central Connecticut','CCSU,C Connecticut,Central Connecticut State','FCS','Northeast','CCSU','Central_Conn',NULL),
('FCS','Northeast','Duquesne Dukes','duquesne','Duquesne','fcs','NEC','Duquesne','DUQ','FCS','Northeast','Duquesne','Duquesne',NULL),
('FCS','Northeast','LIU Sharks','liu','LIU','fcs','NEC','Long Island University','LIU,Long Island','FCS','Northeast','LIU','LIU_Post',NULL),
('FCS','Northeast','Mercyhurst Lakers','mercyhurst','Mercyhurst','fcs','NEC','Mercyhurst','MERC','FCS','Northeast','Mercyhurst','Mercyhurst',NULL),
('FCS','Northeast','Robert Morris Colonials','robertmorris','Robert Morris','fcs','NEC','Robert Morris','RMU','FCS','Northeast','Robert Morris','Robert_Morris',NULL),
('FCS','Northeast','St. Francis Red Flash','stfrancis','St. Francis','fcs','NEC','St. Francis (PA)','St Francis (PA),SFPA,St Francis PA,St. Francis PA','FCS','Northeast','St. Francis','St_Francis_PA',NULL),
('FCS','Northeast','Stonehill Skyhawks','stonehill','Stonehill','fcs','NEC','Stonehill','STO','FCS','Northeast','Stonehill','Stonehill',NULL),
('FCS','Northeast','Wagner Seahawks','wagner','Wagner','fcs','NEC','Wagner','WAG','FCS','Northeast','Wagner','Wagner',NULL),
('FCS','Patriot','Bucknell Bison','bucknell','Bucknell','fcs','Patriot','Bucknell','BUCK','FCS','Patriot','Bucknell','Bucknell',NULL),
('FCS','Patriot','Colgate Raiders','colgate','Colgate','fcs','Patriot','Colgate','COLG','FCS','Patriot','Colgate','Colgate',NULL),
('FCS','Patriot','Fordham Rams','fordham','Fordham','fcs','Patriot','Fordham','FOR','FCS','Patriot','Fordham','Fordham',NULL),
('FCS','Patriot','Georgetown Hoyas','georgetown','Georgetown','fcs','Patriot','Georgetown','GTWN','FCS','Patriot','Georgetown','Georgetown',NULL),
('FCS','Patriot','Holy Cross Crusaders','holycross','Holy Cross','fcs','Patriot','Holy Cross','HC','FCS','Patriot','Holy Cross','Holy_Cross',NULL),
('FCS','Patriot','Lafayette Leopards','lafayette','Lafayette','fcs','Patriot','Lafayette','LAF','FCS','Patriot','Lafayette','Lafayette',NULL),
('FCS','Patriot','Lehigh Mountain Hawks','lehigh','Lehigh','fcs','Patriot','Lehigh','LEH','FCS','Patriot','Lehigh','Lehigh',NULL),
('FCS','Pioneer','Butler Bulldogs','butler','Butler','fcs','Pioneer','Butler','BUT','FCS','Pioneer','Butler','Butler',NULL),
('FCS','Pioneer','Davidson Wildcats','davidson','Davidson','fcs','Pioneer','Davidson','DAV','FCS','Pioneer','Davidson','Davidson',NULL),
('FCS','Pioneer','Dayton Flyers','dayton','Dayton','fcs','Pioneer','Dayton','DAY','FCS','Pioneer','Dayton','Dayton',NULL),
('FCS','Pioneer','Drake Bulldogs','drake','Drake','fcs','Pioneer','Drake','DRKE','FCS','Pioneer','Drake','Drake',NULL),
('FCS','Pioneer','Marist Red Foxes','marist','Marist','fcs','Pioneer','Marist','MRST','FCS','Pioneer','Marist','Marist',NULL),
('FCS','Pioneer','Morehead State Eagles','moreheadstate','Morehead State','fcs','Pioneer','Morehead State','MORE,Morehead St','FCS','Pioneer','Morehead State','Morehead_St',NULL),
('FCS','Pioneer','Presbyterian Blue Hose','presbyterian','Presbyterian','fcs','Pioneer','Presbyterian','Presbyterian College,PRES','FCS','Pioneer','Presbyterian','Presbyterian',NULL),
('FCS','Pioneer','San Diego Toreros','sandiego','San Diego','fcs','Pioneer','San Diego','USD','FCS','Pioneer','San Diego','San_Diego',NULL),
('FCS','Pioneer','St. Thomas Tommies','stthomasmn','St. Thomas','fcs','Pioneer','St. Thomas (MN)','STMN,St Thomas MN,St Thomas (MN)','FCS','Pioneer','St. Thomas','St_Thomas_MN',NULL),
('FCS','Pioneer','Stetson Hatters','stetson','Stetson','fcs','Pioneer','Stetson','STET','FCS','Pioneer','Stetson','Stetson',NULL),
('FCS','Pioneer','Valparaiso Beacons','valparaiso','Valparaiso','fcs','Pioneer','Valparaiso','VAL','FCS','Pioneer','Valparaiso','Valparaiso',NULL),
('FCS','SoCon','Chattanooga Mocs','chattanooga','Chattanooga','fcs','Southern','Chattanooga','UTC','FCS','Southern','Chattanooga','Chattanooga',NULL),
('FCS','SoCon','ETSU Buccaneers','easttennesseestate','ETSU','fcs','Southern','East Tennessee State','ETSU','FCS','Southern','ETSU','ETSU',NULL),
('FCS','SoCon','Furman Paladins','furman','Furman','fcs','Southern','Furman','FUR','FCS','Southern','Furman','Furman',NULL),
('FCS','SoCon','Mercer Bears','mercer','Mercer','fcs','Southern','Mercer','MER','FCS','Southern','Mercer','Mercer',NULL),
('FCS','SoCon','Samford Bulldogs','samford','Samford','fcs','Southern','Samford','SAM','FCS','Southern','Samford','Samford',NULL),
('FCS','SoCon','The Citadel Bulldogs','citadel','The Citadel','fcs','Southern','The Citadel','CIT','FCS','Southern','The Citadel','Citadel',NULL),
('FCS','SoCon','VMI Keydets','vmi','VMI','fcs','Southern','VMI','Virginia Military Institute','FCS','Southern','VMI','VMI',NULL),
('FCS','SoCon','Western Carolina Catamounts','westerncarolina','Western Carolina','fcs','Southern','Western Carolina','WCU,W Carolina','FCS','Southern','Western Carolina','W_Carolina',NULL),
('FCS','SoCon','Wofford Terriers','wofford','Wofford','fcs','Southern','Wofford','WOF','FCS','Southern','Wofford','Wofford',NULL),
('FCS','Southland','HCU Huskies','houstonbaptist','HCU','fcs','Southland','Houston Christian','Houston Baptist,HCU,Hou Christian','FCS','Southland','HCU','Houston_Chr',NULL),
('FCS','Southland','Lamar Cardinals','lamar','Lamar','fcs','Southland','Lamar','LAM','FCS','Southland','Lamar','Lamar',NULL),
('FCS','Southland','McNeese Cowboys','mcneese','McNeese','fcs','Southland','McNeese','MCN','FCS','Southland','McNeese','McNeese_St',NULL),
('FCS','Southland','Nicholls Colonels','nicholls','Nicholls','fcs','Southland','Nicholls','NICH','FCS','Southland','Nicholls','Nicholls_St',NULL),
('FCS','Southland','Northwestern State Demons','northwesternstate','Northwestern State','fcs','Southland','Northwestern State','NWST,N''Western St','FCS','Southland','Northwestern State','Northwestern_LA',NULL),
('FCS','Southland','Southeastern Lions','southeasternlouisiana','Southeastern','fcs','Southland','SE Louisiana','Southeastern Louisiana,Southeast Louisiana,SELA','FCS','Southland','Southeastern','SE_Louisiana',NULL),
('FCS','Southland','Stephen F. Austin Lumberjacks','stephenfaustin','Stephen F. Austin','fcs','Southland','Stephen F. Austin','SFA,SF Austin,Stephen F Austin','FCS','Southland','Stephen F. Austin','SF_Austin',NULL),
('FCS','Southland','Texas A&M-Commerce Lions','texasamcommerce','Texas A&M-Commerce','fcs','Southland','Texas A&M-Commerce','Texas A&M-Comm,TAMC','FCS','Southland','Texas A&M-Commerce','TX_A&M_Commerce',NULL),
('FCS','Southland','UIW Cardinals','incarnateword','UIW','fcs','Southland','Incarnate Word','UIW','FCS','Southland','UIW','Incarnate_Word',NULL),
('FCS','Southland','UTRGV Vaqueros','utrgv','UTRGV',NULL,NULL,NULL,NULL,'FCS','UAC','UTRGV','UTRGV',NULL),
('FCS','SWAC','Alabama A&M Bulldogs','alabamaam','Alabama A&M','fcs','SWAC','Alabama A&M','AAMU','FCS','SWAC','Alabama A&M','Alabama_A&M',NULL),
('FCS','SWAC','Alabama State Hornets','alabamastate','Alabama State','fcs','SWAC','Alabama State','ALST,Alabama St','FCS','SWAC','Alabama State','Alabama_St',NULL),
('FCS','SWAC','Alcorn State Braves','alcornstate','Alcorn State','fcs','SWAC','Alcorn State','Alcorn St,ALCN,Alcorn','FCS','SWAC','Alcorn State','Alcorn_St',NULL),
('FCS','SWAC','Bethune-Cookman Wildcats','bethunecookman','Bethune-Cookman','fcs','SWAC','Bethune-Cookman','BCU,Bethune','FCS','SWAC','Bethune-Cookman','Bethune-Cookman',NULL),
('FCS','SWAC','Florida A&M Rattlers','floridaam','Florida A&M','fcs','SWAC','Florida A&M','FAMU','FCS','SWAC','Florida A&M','Florida_A&M',NULL),
('FCS','SWAC','Grambling Tigers','grambling','Grambling','fcs','SWAC','Grambling','GRAM,Grambling State','FCS','SWAC','Grambling','Grambling',NULL),
('FCS','SWAC','Jackson State Tigers','jacksonstate','Jackson State','fcs','SWAC','Jackson State','Jackson St,JKST','FCS','SWAC','Jackson State','Jackson_St',NULL),
('FCS','SWAC','MVSU Delta Devils','mvsu','MVSU','fcs','SWAC','Mississippi Valley State','Miss Valley St,MVSU','FCS','SWAC','MVSU','MS_Valley_St',NULL),
('FCS','SWAC','Prairie View A&M Panthers','prairieviewam','Prairie View A&M','fcs','SWAC','Prairie View A&M','Prairie View,PV','FCS','SWAC','Prairie View A&M','Prairie_View',NULL),
('FCS','SWAC','Southern Jaguars','southern','Southern','fcs','SWAC','Southern','SOU','FCS','SWAC','Southern','Southern_Univ',NULL),
('FCS','SWAC','Texas Southern Tigers','texassouthern','Texas Southern','fcs','SWAC','Texas Southern','TXSO','FCS','SWAC','Texas Southern','TX_Southern',NULL),
('FCS','SWAC','UAPB Golden Lions','uapb','UAPB','fcs','SWAC','Arkansas-Pine Bluff','Arkansas Pine Bluff,UAPB,AR-Pine Bluff','FCS','SWAC','UAPB','Ark_Pine_Bluff',NULL),
('FCS','UAC','Abilene Christian Wildcats','abilenechristian','Abilene Christian','fcs','UAC','Abilene Christian','Abilene Chrstn,ACU','FCS','UAC','Abilene Christian','Abilene_Chr',NULL),
('FCS','UAC','Austin Peay Governors','austinpeay','Austin Peay','fcs','UAC','Austin Peay','APSU','FCS','UAC','Austin Peay','Austin_Peay',NULL),
('FCS','UAC','Central Arkansas Bears','centralarkansas','Central Arkansas','fcs','UAC','Central Arkansas','CARK,C Arkansas','FCS','UAC','Central Arkansas','Cent_Arkansas',NULL),
('FCS','UAC','EKU Colonels','easternkentucky','EKU','fcs','UAC','Eastern Kentucky','E Kentucky,EKU','FCS','UAC','EKU','E_Kentucky',NULL),
('FCS','UAC','North Alabama Lions','northalabama','North Alabama','fcs','UAC','North Alabama','UNA','FCS','UAC','North Alabama','North_Alabama',NULL),
('FCS','UAC','Southern Utah Thunderbirds','southernutah','Southern Utah','fcs','UAC','Southern Utah','SUU','FCS','UAC','Southern Utah','Southern_Utah',NULL),
('FCS','UAC','Tarleton Texans','tarletonstate','Tarleton','fcs','UAC','Tarleton State','Tarleton St,TAR','FCS','UAC','Tarleton','Tarleton_St',NULL),
('FCS','UAC','Utah Tech Trailblazers','utahtech','Utah Tech','fcs','UAC','Utah Tech','UTU,Dixie State','FCS','UAC','Utah Tech','Utah_Tech',NULL),
('FCS','UAC','West Georgia Wolves','westgeorgia','West Georgia','fcs','UAC','West Georgia','WGA','FCS','UAC','West Georgia','West_Georgia',NULL),
('FCS','Yankee','Merrimack Warriors','merrimack','Merrimack','fcs','FCS Independents','Merrimack','MRMK','FCS','FCS Independent','Merrimack','Merrimack',NULL),
('FCS','Yankee','Sacred Heart Pioneers','sacredheart','Sacred Heart','fcs','FCS Independents','Sacred Heart','SHU','FCS','FCS Independent','Sacred Heart','Sacred_Heart',NULL),
('D2','CIAA','Bluefield State Big Blue','bluefieldstate','Bluefield State','ii','CIAA','Bluefield State','Bluefield,BLU,Bluefield St','D2','CIAA','Bluefield State','Bluefield_St',NULL),
('D2','CIAA','Bowie State Bulldogs','bowiestate','Bowie State','ii','CIAA','Bowie State','BSU,Bowie St','D2','CIAA','Bowie State','Bowie_St',NULL),
('D2','CIAA','Elizabeth City State Vikings','elizabethcitystate','Elizabeth City State','ii','CIAA','Elizabeth City State','ELI,Eliz City','D2','CIAA','Elizabeth City State','Eliz._City_St',NULL),
('D2','CIAA','Fayetteville State Broncos','fayettevillestate','Fayetteville State','ii','CIAA','Fayetteville State','FAY,Fayetvl St','D2','CIAA','Fayetteville State','Fayetteville_St',NULL),
('D2','CIAA','Johnson C. Smith Golden Bulls','johnsoncsmith','Johnson C. Smith','ii','CIAA','Johnson C Smith','Jsn C Smth,Johnson Smith,JOH','D2','CIAA','Johnson C. Smith','JC_Smith',NULL),
('D2','CIAA','Lincoln (PA) Lions','lincolnpa','Lincoln (PA)','ii','CIAA','Lincoln (PA)','LINP','D2','CIAA','Lincoln (PA)','Lincoln_PA',NULL),
('D2','CIAA','Livingstone Blue Bears','livingstone','Livingstone','ii','CIAA','Livingstone','LIV,Lvingstone','D2','CIAA','Livingstone','Livingstone',NULL),
('D2','CIAA','Shaw Bears','shawuniversity','Shaw','ii','CIAA','Shaw','SHAW','D2','CIAA','Shaw','Shaw_NC',NULL),
('D2','CIAA','Virginia State Trojans','virginiastate','Virginia State','ii','CIAA','Virginia St','Virginia State,VIR,VA State','D2','CIAA','Virginia State','Virginia_St',NULL),
('D2','CIAA','Virginia Union Panthers','virginiaunion','Virginia Union','ii','CIAA','Virginia Union','VU,VA Union','D2','CIAA','Virginia Union','Virginia_Union',NULL),
('D2','CIAA','Winston-Salem State Rams','winstonsalemstate','Winston-Salem State','ii','CIAA','Winston-Salem','WNSL','D2','CIAA','Winston-Salem State','W_Salem_St',NULL),
('D2','GLIAC','Davenport Panthers','davenport','Davenport','ii','GLIAC','Davenport','DU','D2','GLIAC','Davenport','Davenport',NULL),
('D2','GLIAC','Ferris State Bulldogs','ferrisstate','Ferris State','ii','GLIAC','Ferris State','FRST,Ferris St','D2','GLIAC','Ferris State','Ferris_St',NULL),
('D2','GLIAC','Grand Valley State Lakers','grandvalleystate','Grand Valley State','ii','GLIAC','Grand Valley State University','Grand Valley State,GVSU,Grand Vall','D2','GLIAC','Grand Valley State','Grand_Valley_St',NULL),
('D2','GLIAC','Michigan Tech Huskies','michigantech','Michigan Tech','ii','GLIAC','Michigan Tech','MTU','D2','GLIAC','Michigan Tech','Michigan_Tech',NULL),
('D2','GLIAC','Northern Michigan Wildcats','northernmichigan','Northern Michigan','ii','GLIAC','Northern Michigan','NMI,N Michigan','D2','GLIAC','Northern Michigan','N_Michigan',NULL),
('D2','GLIAC','Roosevelt Lakers','roosevelt','Roosevelt','ii','GLIAC','Roosevelt','ROO','D2','GLIAC','Roosevelt','Roosevelt',NULL),
('D2','GLIAC','Saginaw Valley State Cardinals','saginawvalleystate','Saginaw Valley State','ii','GLIAC','Saginaw Valley State','Saginaw Valley,SAGI,Saginawval','D2','GLIAC','Saginaw Valley State','Saginaw_Val',NULL),
('D2','GLIAC','Wayne State (MI) Warriors','waynestatemi','Wayne State (MI)','ii','GLIAC','Wayne State (MI)','Wayne State MI,WAY','D2','GLIAC','Wayne State (MI)','Wayne_St_MI',NULL),
('D2','GLVC','Lincoln (MO) Blue Tigers','lincolnmo','Lincoln (MO)','ii','Great Lakes','Lincoln (MO)','LIN','D2','GLVC','Lincoln (MO)','Lincoln_MO',NULL),
('D2','GLVC','McKendree Bearcats','mckendree','McKendree','ii','Great Lakes','McKendree','MAN','D2','GLVC','McKendree','McKendree',NULL),
('D2','GLVC','Missouri S&T Miners','missourisnt','Missouri S&T','ii','Great Lakes','Missouri S&T','MISSO,MO S&T','D2','GLVC','Missouri S&T','Missouri_S&T',NULL),
('D2','GLVC','Quincy Hawks','quincy','Quincy','ii','Great Lakes','Quincy','QUI','D2','GLVC','Quincy','Quincy',NULL),
('D2','GLVC','Southwest Baptist Bearcats','southwestbaptist','Southwest Baptist','ii','Great Lakes','Southwest Baptist','SW Baptist,SWB','D2','GLVC','Southwest Baptist','SW_Baptist',NULL),
('D2','GLVC','Truman Bulldogs','trumanstate','Truman','ii','Great Lakes','Truman State','TRU,Truman St','D2','GLVC','Truman','Truman_St',NULL),
('D2','GLVC','UIndy Greyhounds','indianapolis','UIndy','ii','Great Lakes','Indianapolis','INDY,Indy','D2','GLVC','Indianapolis','Indianapolis',NULL),
('D2','GLVC','Upper Iowa Peacocks','upperiowa','Upper Iowa','ii','Great Lakes','Upper Iowa University','Upper Iowa,UPPERIOWA','D2','GLVC','Upper Iowa','Upper_Iowa',NULL),
('D2','GLVC','William Jewell Cardinals','williamjewell','William Jewell','ii','Great Lakes','William Jewell','William Jewell College,WILLI','D2','GLVC','William Jewell','Wm_Jewell',NULL),
('D2','Great American','Arkansas Tech Wonder Boys','arkansastech','Arkansas Tech','ii','Great American','Arkansas Tech','ARKTECH','D2','Great American','Arkansas Tech','Arkansas_Tech',NULL),
('D2','Great American','Arkansas-Monticello Boll Weevils','arkansasmonticello','Arkansas-Monticello','ii','Great American','Arkansas-Monticello','ARKMONT,Ark-Monticello','D2','Great American','Arkansas-Monticello','Ark_Monticello',NULL),
('D2','Great American','East Central Tigers','eastcentral','East Central','ii','Great American','East Central (OK)','East Central,East Central University,EAS,E Cen OK','D2','Great American','East Central','East_Central_OK',NULL),
('D2','Great American','Harding Bisons','harding','Harding','ii','Great American','Harding University','Harding,HARDING','D2','Great American','Harding','Harding',NULL),
('D2','Great American','Henderson State Reddies','hendersonstate','Henderson State','ii','Great American','Henderson State','Henderson,HENDERSON','D2','Great American','Henderson State','Henderson_St',NULL),
('D2','Great American','NW Oklahoma State Rangers','northwestoklahomastate','NW Oklahoma State','ii','Great American','Northwestern Oklahoma State','NW OK ST,NWO','D2','Great American','NW Oklahoma State','NW_Oklahoma_St',NULL),
('D2','Great American','Oklahoma Baptist Bison','oklahomabaptist','Oklahoma Baptist','ii','Great American','Oklahoma Baptist','OB,Okbaptu','D2','Great American','Oklahoma Baptist','OK_Baptist',NULL),
('D2','Great American','Ouachita Baptist Tigers','ouachitabaptist','Ouachita Baptist','ii','Great American','Ouachita Baptist','Ouachita,OUA','D2','Great American','Ouachita Baptist','Ouachita',NULL),
('D2','Great American','SE Oklahoma State Savage Storm','seoklahomastate','SE Oklahoma State','ii','Great American','Southeastern Oklahoma State','Southeastern Oklahoma,SEOS,SE OK ST','D2','Great American','SE Oklahoma State','SE_Oklahoma',NULL),
('D2','Great American','Southern Arkansas Muleriders','southernarkansas','Southern Arkansas','ii','Great American','Southern Arkansas','S Ark,SOU','D2','Great American','Southern Arkansas','S_Arkansas',NULL),
('D2','Great American','Southern Nazarene Crimson Storm','southernnazarene','Southern Nazarene','ii','Great American','Southern Nazarene','STN,S Nazarene','D2','Great American','Southern Nazarene','Southern_Nazarene',NULL),
('D2','Great American','SW Oklahoma State Bulldogs','swoklahomastate','SW Oklahoma State','ii','Great American','Southwestern Oklahoma State','Southwestern Oklahoma,SW Okla St,SWO','D2','Great American','SW Oklahoma State','SW_Oklahoma',NULL),
('D2','Great Midwest','Ashland Eagles','ashland','Ashland','ii','Great Midwest Athletic','Ashland','ASH','D2','Great Midwest','Ashland','Ashland',NULL),
('D2','Great Midwest','Findlay Oilers','findlay','Findlay','ii','Great Midwest Athletic','Findlay','FINDLAY','D2','Great Midwest','Findlay','Findlay',NULL),
('D2','Great Midwest','Hillsdale Chargers','hillsdale','Hillsdale','ii','Great Midwest Athletic','Hillsdale','HILLSDALE','D2','Great Midwest','Hillsdale','Hillsdale',NULL),
('D2','Great Midwest','Kentucky Wesleyan Panthers','kentuckywesleyan','Kentucky Wesleyan','ii','Great Midwest Athletic','Kentucky Wesleyan','KY Wesleyn,KYWESL','D2','Great Midwest','Kentucky Wesleyan','KY_Wesleyan',NULL),
('D2','Great Midwest','Lake Erie Storm','lakeerie','Lake Erie','ii','Great Midwest Athletic','Lake Erie','Lake Erie College,LAKEERIE','D2','Great Midwest','Lake Erie','Lake_Erie',NULL),
('D2','Great Midwest','Northwood Timberwolves','northwood','Northwood','ii','Great Midwest Athletic','Northwood (MI)','NAR,Northwood,Northwood University','D2','Great Midwest','Northwood','Northwood_MI',NULL),
('D2','Great Midwest','Ohio Dominican Panthers','ohiodominican','Ohio Dominican','ii','Great Midwest Athletic','Ohio Dominican','Panthers','D2','Great Midwest','Ohio Dominican','OH_Dominican',NULL),
('D2','Great Midwest','Thomas More Saints','thomasmore','Thomas More','ii','Great Midwest Athletic','Thomas More College','Thomas More,THMORE,Thmas More','D2','Great Midwest','Thomas More','Thomas_More',NULL),
('D2','Great Midwest','Tiffin Dragons','tiffin','Tiffin','ii','Great Midwest Athletic','Tiffin','TIF,Tiffin University','D2','Great Midwest','Tiffin','Tiffin',NULL),
('D2','Great Midwest','Walsh Cavaliers','walsh','Walsh','ii','Great Midwest Athletic','Walsh','WAL','D2','Great Midwest','Walsh','Walsh',NULL),
('D2','Gulf South','Chowan Hawks','chowan','Chowan','ii','Gulf South','Chowan','CHOWA','D2','Gulf South','Chowan','Chowan',NULL),
('D2','Gulf South','Delta State Statesmen','deltastate','Delta State','ii','Gulf South','Delta State','DELTAST,Del State','D2','Gulf South','Delta State','Delta_St',NULL),
('D2','Gulf South','Erskine Flying Fleet','erskine','Erskine','ii','Gulf South','ERSKINE','Erskine','D2','Gulf South','Erskine','Erskine',NULL),
('D2','Gulf South','Mississippi College Choctaws','mississippicollege','Mississippi College','ii','Gulf South','Mississippi College','Miss Coll,MIS','D2','Gulf South','Mississippi College','Mississippi_Col',NULL),
('D2','Gulf South','North Greenville Trailblazers','northgreenville','North Greenville','ii','Gulf South','North Greenville','N Greenvll,NG','D2','Gulf South','North Greenville','North_Greenville',NULL),
('D2','Gulf South','Valdosta State Blazers','valdostastate','Valdosta State','ii','Gulf South','Valdosta State','VAL,Valdosta','D2','Gulf South','Valdosta State','Valdosta_St',NULL),
('D2','Gulf South','West Alabama Tigers','westalabama','West Alabama','ii','Gulf South','West Alabama','WES,W Alabama','D2','Gulf South','West Alabama','West_Alabama',NULL),
('D2','Gulf South','West Florida Argonauts','uwf','West Florida','ii','Gulf South','West Florida','WES,W Florida','D2','Gulf South','West Florida','West_Florida',NULL),
('D2','Lone Star','Angelo State Rams','angelostate','Angelo State','ii','Lone Star','Angelo State','ANG','D2','Lone Star','Angelo State','Angelo_St',NULL),
('D2','Lone Star','Central Washington Wildcats','centralwashington','Central Washington','ii','Lone Star','Central Washington','CENTWASH,C Wash','D2','Lone Star','Central Washington','C_Washington',NULL),
('D2','Lone Star','Eastern New Mexico Greyhounds','easternnewmexico','Eastern New Mexico','ii','Lone Star','Eastern New Mexico','EASTERNNM,Eastern NM','D2','Lone Star','Eastern New Mexico','E_New_Mexico',NULL),
('D2','Lone Star','Midwestern State Mustangs','midwesternstate','Midwestern State','ii','Lone Star','Midwestern State','MID,Midwest St','D2','Lone Star','Midwestern State','Midwest_TX_St',NULL),
('D2','Lone Star','Sul Ross State Lobos','sulrossstate','Sul Ross State','ii','Lone Star','Sul Ross State','SROS','D2','Lone Star','Sul Ross State','Sul_Ross',NULL),
('D2','Lone Star','Texas A&M-Kingsville Javelinas','texasamkingsville','Texas A&M-Kingsville','ii','Lone Star','Texas A&M-Kingsville','TX A&M Kng,TXA','D2','Lone Star','Texas A&M-Kingsville','TX_A&M_K''ville',NULL),
('D2','Lone Star','UTPB Falcons','utpb','UTPB','ii','Lone Star','UT Permian Basin','University of Texas of the Permian Basin,TXPBAS,UTPermianBasin','D2','Lone Star','UTPB','Permian_Basin',NULL),
('D2','Lone Star','West Texas A&M Buffs','westtexasam','West Texas A&M','ii','Lone Star','West Texas A&M','WES','D2','Lone Star','West Texas A&M','W_Texas_A&M',NULL),
('D2','Lone Star','Western New Mexico Mustangs','westernnewmexico','Western New Mexico','ii','Lone Star','Western New Mexico','W New Mex,WNMEX','D2','Lone Star','Western New Mexico','W_New_Mexico',NULL),
('D2','Lone Star','Western Oregon Wolves','westernoregon','Western Oregon','ii','Lone Star','Western Oregon','WORE','D2','Lone Star','Western Oregon','W_Oregon',NULL),
('D2','Mid-America IAA','Central Missouri Mules','centralmissouri','Central Missouri','ii','Mid America','Central Missouri','Central Missouri State,CENM,C Missouri','D2','Mid-America IAA','Central Missouri','C_Missouri',NULL),
('D2','Mid-America IAA','Central Oklahoma Bronchos','centraloklahoma','Central Oklahoma','ii','Mid America','Central Oklahoma','CENO,C Okla','D2','Mid-America IAA','Central Oklahoma','C_Oklahoma',NULL),
('D2','Mid-America IAA','Emporia State Hornets','emporiastate','Emporia State','ii','Mid America','Emporia State University','Emporia State,Emporia St,EMP','D2','Mid-America IAA','Emporia State','Emporia_St',NULL),
('D2','Mid-America IAA','Fort Hays State Tigers','forthaysstate','Fort Hays State','ii','Mid America','Fort Hays State','Ft Hays St,FTHAYST','D2','Mid-America IAA','Fort Hays State','Fort_Hays_St',NULL),
('D2','Mid-America IAA','Missouri Southern Lions','missourisouthern','Missouri Southern','ii','Mid America','Missouri Southern State','MO Southrn,MOSSTC','D2','Mid-America IAA','Missouri Southern','MO_Southern',NULL),
('D2','Mid-America IAA','Missouri Western Griffons','missouriwestern','Missouri Western','ii','Mid America','Missouri Western','MO Westrn,MOW','D2','Mid-America IAA','Missouri Western','MO_Western',NULL),
('D2','Mid-America IAA','Nebraska-Kearney Lopers','nebraskakearney','Nebraska-Kearney','ii','Mid America','Nebraska-Kearney','NEKR,Neb Kearney','D2','Mid-America IAA','Nebraska-Kearney','NE_Kearney',NULL),
('D2','Mid-America IAA','Northwest Missouri State Bearcats','northwestmissouristate','Northwest Missouri State','ii','Mid America','Northwest Missouri St','Northwest Missouri State,NW MO ST,NWMS','D2','Mid-America IAA','Northwest Missouri State','NW_Missouri',NULL),
('D2','Mid-America IAA','Pittsburg State Gorillas','pittsburgstate','Pittsburg State','ii','Mid America','Pittsburg St','Pittsburg State,Pitt St,PIT','D2','Mid-America IAA','Pittsburg State','Pittsburg_St',NULL),
('D2','Mid-America IAA','Washburn Ichabods','washburn','Washburn','ii','Mid America','Washburn','WAS','D2','Mid-America IAA','Washburn','Washburn',NULL),
('D2','Mountain East','Charleston (WV) Golden Eagles','charleston','Charleston (WV)','ii','Mountain East','University Of Charleston (WV)','Charleston (WV),CHWV,Charl WV','D2','Mountain East','Charleston (WV)','Charleston_WV',NULL),
('D2','Mountain East','Concord Mountain Lions','concord','Concord','ii','Mountain East','Concord University','Concord,CON','D2','Mountain East','Concord','Concord',NULL),
('D2','Mountain East','Fairmont State Falcons','fairmontstate','Fairmont State','ii','Mountain East','Fairmont State','FAIRST,Fairmnt St','D2','Mountain East','Fairmont State','Fairmont_St',NULL),
('D2','Mountain East','Frostburg State Bobcats','frostburgstate','Frostburg State','ii','Mountain East','Frostburg State','Frostburg,FRO','D2','Mountain East','Frostburg State','Frostburg_St',NULL),
('D2','Mountain East','Glenville State Pioneers','glenvillestate','Glenville State','ii','Mountain East','Glenville State','Glenville,GLENVILLE','D2','Mountain East','Glenville State','Glenville_St',NULL),
('D2','Mountain East','UNC Pembroke Braves','uncpembroke','UNC Pembroke','ii','Mountain East','UNC Pembroke','NC Pembrke,NCPEMB','D2','Mountain East','UNC Pembroke','NC_Pembroke',NULL),
('D2','Mountain East','West Liberty Hilltoppers','westliberty','West Liberty','ii','Mountain East','West Liberty','WLIBST','D2','Mountain East','West Liberty','West_Liberty',NULL),
('D2','Mountain East','West Virginia State Yellow Jackets','westvirginiastate','West Virginia State','ii','Mountain East','West Virginia State','W Virginia St,WEST ','D2','Mountain East','West Virginia State','WV_State',NULL),
('D2','Mountain East','West Virginia Wesleyan Bobcats','westvirginiawesleyan','West Virginia Wesleyan','ii','Mountain East','West Virginia Wesleyan','WV Wesleyan,WEST,WV Weslyan','D2','Mountain East','West Virginia Wesleyan','WV_Wesleyan',NULL),
('D2','Mountain East','Wheeling Cardinals','wheelingjesuit','Wheeling','ii','Mountain East','Wheeling','Wheeling Jesuit,WHEEL','D2','Mountain East','Wheeling','Wheeling',NULL),
('D2','Northeast-10','American International Yellow Jackets','americaninternational','American International','ii','Northeast 10','American International','AIC,American Int''l','D2','Northeast-10','American International','American_Intl',NULL),
('D2','Northeast-10','Assumption Greyhounds','assumption','Assumption','ii','Northeast 10','Assumption','ASP,Assumption College','D2','Northeast-10','Assumption','Assumption',NULL),
('D2','Northeast-10','Bentley Falcons','bentley','Bentley','ii','Northeast 10','Bentley','BENT','D2','Northeast-10','Bentley','Bentley',NULL),
('D2','Northeast-10','Franklin Pierce Ravens','franklinpierce','Franklin Pierce','ii','Northeast 10','Franklin Pierce','FRANK,FRNKLNPRCE','D2','Northeast-10','Franklin Pierce','Franklin_Pierce',NULL),
('D2','Northeast-10','New Haven Chargers','newhaven','New Haven','ii','Northeast 10','New Haven','NH','D2','Northeast-10','New Haven','New_Haven',NULL),
('D2','Northeast-10','Pace Setters','pace','Pace','ii','Northeast 10','Pace','PAC','D2','Northeast-10','Pace','Pace',NULL),
('D2','Northeast-10','Post Eagles','post','Post','ii','Northeast 10','Post University','POS,Post Universit','D2','Northeast-10','Post','Post',NULL),
('D2','Northeast-10','Southern Connecticut Owls','southernconnecticutstate','Southern Connecticut','ii','Northeast 10','Southern Connecticut State','SOU,S Conn St','D2','Northeast-10','Southern Connecticut','S_Connecticut',NULL),
('D2','Northeast-10','St. Anselm Hawks','stanselm','St. Anselm','ii','Northeast 10','St. Anselm','St Anselm,STA','D2','Northeast-10','St. Anselm','St_Anselm',NULL),
('D2','Northern Sun','Augustana (SD) Vikings','augustanasd','Augustana (SD)','ii','Northern Sun','Augustana University (SD)','Augustana (SD),AUSD','D2','Northern Sun','Augustana (SD)','Augustana_SD',NULL),
('D2','Northern Sun','Bemidji State Beavers','bemidjistate','Bemidji State','ii','Northern Sun','Bemidji State','BST,Bemidji St','D2','Northern Sun','Bemidji State','Bemidji_St',NULL),
('D2','Northern Sun','Concordia (MN-St. Paul) Golden Bears','concordiastpaul','Concordia (MN-St. Paul)','ii','Northern Sun','Concordia University St Paul','Concordia-St. Paul,CON,Cncrdia SP','D2','Northern Sun','Concordia (MN-St.Paul)','Concordia_SP',NULL),
('D2','Northern Sun','Mary Marauders','mary','Mary','ii','Northern Sun','University of Mary','Univ of Mary,MARY','D2','Northern Sun','Mary','Mary_ND',NULL),
('D2','Northern Sun','Minnesota State Mavericks','mankatostate','Minnesota State','ii','Northern Sun','Minnesota State Mankato','Minnesota State,Minnesota St,MNST','D2','Northern Sun','Minnesota State','MN_Mankato',NULL),
('D2','Northern Sun','Minnesota-Duluth Bulldogs','minnesotaduluth','Minnesota-Duluth','ii','Northern Sun','Minnesota Duluth','Minnesota-Duluth,Minn Duluth,UMD','D2','Northern Sun','Minnesota-Duluth','MN_Duluth',NULL),
('D2','Northern Sun','Minot State Beavers','minotstate','Minot State','ii','Northern Sun','Minot State','MIN,Minot St','D2','Northern Sun','Minot State','Minot_St',NULL),
('D2','Northern Sun','MSU-Moorhead Dragons','minnesotastatemoorhead','MSU-Moorhead','ii','Northern Sun','Minnesota State Moorhead','Minnesota St-Moorhead,MIN,Moorhead','D2','Northern Sun','MSU-Moorhead','Moorhead_St',NULL),
('D2','Northern Sun','Northern State Wolves','northernstate','Northern State','ii','Northern Sun','Northern State','Northrn St,NOR','D2','Northern Sun','Northern State','Northern_St_SD',NULL),
('D2','Northern Sun','Sioux Falls Cougars','siouxfalls','Sioux Falls','ii','Northern Sun','Sioux Falls','SIO,Siouxfalls','D2','Northern Sun','Sioux Falls','Sioux_Falls',NULL),
('D2','Northern Sun','Southwest Minnesota State Mustangs','southwestminnesotastate','Southwest Minnesota','ii','Northern Sun','Southwest Minnesota State','SW Minn State,SWMN','D2','Northern Sun','Southwest Minnesota','SW_Minnesota',NULL),
('D2','Northern Sun','Wayne State (NE) Wildcats','waynestate','Wayne State (NE)','ii','Northern Sun','Wayne State (NE)','Wayne State NE,WNST','D2','Northern Sun','Wayne State (NE)','Wayne_St_NE',NULL),
('D2','Northern Sun','Winona State Warriors','winonastate','Winona State','ii','Northern Sun','Winona State','WIN','D2','Northern Sun','Winona State','Winona_St',NULL),
('D2','PSAC','Bloomsburg Huskies','bloomsburg','Bloomsburg','ii','Pennsylvania State Athletic','Bloomsburg','BLMSB','D2','PSAC','Bloomsburg','Bloomsburg',NULL),
('D2','PSAC','California (PA) Vulcans','californiapa','California (PA)','ii','Pennsylvania State Athletic','PennWest California','California (PA),PennWest Cal,PWC,California (Pennsylvania)','D2','PSAC','California (PA)','California_PA',NULL),
('D2','PSAC','Clarion Golden Eagles','clarion','Clarion','ii','Pennsylvania State Athletic','Clarion','CLARION','D2','PSAC','Clarion','Clarion',NULL),
('D2','PSAC','East Stroudsburg Warriors','eaststroudsburg','East Stroudsburg','ii','Pennsylvania State Athletic','East Stroudsburg University','East Stroudsburg,E Strouds,ESTROUD','D2','PSAC','East Stroudsburg','E_Stroudsburg',NULL),
('D2','PSAC','Edinboro Fighting Scots','edinboro','Edinboro','ii','Pennsylvania State Athletic','Edinboro University','Edinboro,EDI','D2','PSAC','Edinboro','Edinboro',NULL),
('D2','PSAC','Gannon Golden Knights','gannon','Gannon','ii','Pennsylvania State Athletic','Gannon','GAN','D2','PSAC','Gannon','Gannon',NULL),
('D2','PSAC','Indiana (PA) Crimson Hawks','indianapa','Indiana (PA)','ii','Pennsylvania State Athletic','Indiana-Pennsylvania','Indiana (PA),IUP,Indiana PA,INDIANAPA','D2','PSAC','Indiana (PA)','Indiana_PA',NULL),
('D2','PSAC','Kutztown Golden Bears','kutztown','Kutztown','ii','Pennsylvania State Athletic','Kutztown University','Kutztown,KUTZTOWN','D2','PSAC','Kutztown','Kutztown',NULL),
('D2','PSAC','Lock Haven Bald Eagles','lockhaven','Lock Haven','ii','Pennsylvania State Athletic','Lock Haven University','Lock Haven,LHU','D2','PSAC','Lock Haven','Lock_Haven',NULL),
('D2','PSAC','Millersville Marauders','millersville','Millersville','ii','Pennsylvania State Athletic','Millersville','Millersvll,MIL','D2','PSAC','Millersville','Millersville',NULL),
('D2','PSAC','Seton Hill Griffins','setonhill','Seton Hill','ii','Pennsylvania State Athletic','Seton Hill','Seton Hill College,SETONHILL','D2','PSAC','Seton Hill','Seton_Hill',NULL),
('D2','PSAC','Shepherd Rams','shepherd','Shepherd','ii','Pennsylvania State Athletic','Shepherd','SHE','D2','PSAC','Shepherd','Shepherd',NULL),
('D2','PSAC','Shippensburg Red Raiders','shippensburg','Shippensburg','ii','Pennsylvania State Athletic','Shippensburg','SHPSBRG,Shipnsburg','D2','PSAC','Shippensburg','Shippensburg',NULL),
('D2','PSAC','Slippery Rock The Rock','slipperyrock','Slippery Rock','ii','Pennsylvania State Athletic','Slippery Rock','Sliprock,SRU','D2','PSAC','Slippery Rock','Slippery_Rock',NULL),
('D2','PSAC','West Chester Golden Rams','westchester','West Chester','ii','Pennsylvania State Athletic','West Chester','WES,W Chester','D2','PSAC','West Chester','West_Chester',NULL),
('D2','RMAC','Adams State Grizzlies','adamsstate','Adams State','ii','Rocky Mountain','Adams State','ADST,Adams St','D2','Rocky Mountain','Adams State','Adams_St',NULL),
('D2','RMAC','Black Hills State Yellow Jackets','blackhillsstate','Black Hills State','ii','Rocky Mountain','Black Hills State','BHST,Black Hills St','D2','Rocky Mountain','Black Hills State','Black_Hills_St',NULL),
('D2','RMAC','Chadron State Eagles','chadronstate','Chadron State','ii','Rocky Mountain','Chadron St','Chadron State,CHADRONST','D2','Rocky Mountain','Chadron State','Chadron_St',NULL),
('D2','RMAC','Colorado Mesa Mavericks','coloradomesa','Colorado Mesa','ii','Rocky Mountain','Colorado Mesa','Colo Mesa,MESA','D2','Rocky Mountain','Colorado Mesa','CO_Mesa',NULL),
('D2','RMAC','Colorado Mines Orediggers','coloradomines','Colorado Mines','ii','Rocky Mountain','Colorado School Of Mines','Colorado Mines,COLOMINES,Colo Mines,Colorado School of Mines','D2','Rocky Mountain','Colorado Mines','Colorado_Mines',NULL),
('D2','RMAC','CSU Pueblo ThunderWolves','csupueblo','CSU Pueblo','ii','Rocky Mountain','CSU Pueblo','Colorado State-Pueblo,CSTP,CO St Pueb','D2','Rocky Mountain','CSU-Pueblo','CSU-Pueblo',NULL),
('D2','RMAC','Fort Lewis Skyhawks','fortlewis','Fort Lewis','ii','Rocky Mountain','Fort Lewis','Ft Lewis,FORTLEW','D2','Rocky Mountain','Fort Lewis','Ft_Lewis',NULL),
('D2','RMAC','New Mexico Highlands Cowboys','newmexicohighlands','New Mexico Highlands','ii','Rocky Mountain','New Mexico Highlands','NM Highlnd,NMH','D2','Rocky Mountain','New Mexico Highlands','NM_Highlands',NULL),
('D2','RMAC','South Dakota Mines Hardrockers','southdakotamines','South Dakota Mines','ii','Rocky Mountain','South Dakota Mines','SD Mines,SDMT','D2','Rocky Mountain','South Dakota Mines','S_Dakota_Tech',NULL),
('D2','RMAC','Western Colorado Mountaineers','westernstate','Western Colorado','ii','Rocky Mountain','Western Colorado','Western State,Western St,WESTSTCOL','D2','Rocky Mountain','Western Colorado','Western_St_CO',NULL),
('D2','SIAC','Albany State Golden Rams','albanystate','Albany State','ii','SIAC','Albany State GA','Albany State (GA),ALBS,Albany St','D2','SIAC','Albany State','Albany_GA',NULL),
('D2','SIAC','Allen Yellow Jackets','allen','Allen','ii','SIAC','Allen','ALL','D2','SIAC','Allen','Allen',NULL),
('D2','SIAC','Benedict Tigers','benedict','Benedict','ii','SIAC','Benedict College','Benedict,BEN','D2','SIAC','Benedict','Benedict',NULL),
('D2','SIAC','Central State Marauders','centralstate','Central State','ii','SIAC','Central State (OH)','Central State,CEN,Central St','D2','SIAC','Central State','Central_St_OH',NULL),
('D2','SIAC','Clark Atlanta Panthers','clarkatlanta','Clark Atlanta','ii','SIAC','Clark Atlanta','CLA,Clark Atl','D2','SIAC','Clark Atlanta','Clark_Atlanta',NULL),
('D2','SIAC','Edward Waters Tigers','edwardwaters','Edward Waters','ii','SIAC','Edward Waters','EDW,Ed Waters','D2','SIAC','Edward Waters','Edward_Waters',NULL),
('D2','SIAC','Fort Valley State Wildcats','fortvalleystate','Fort Valley State','ii','SIAC','Fort Valley State','Ft Valley,FOR','D2','SIAC','Fort Valley State','Fort_Valley_St',NULL),
('D2','SIAC','Kentucky State Thorobreds','kentuckystate','Kentucky State','ii','SIAC','Kentucky State','Kentucky St,KYST','D2','SIAC','Kentucky State','Kentucky_St',NULL),
('D2','SIAC','Lane Dragons','lane','Lane','ii','SIAC','Lane College','Lane,LAC','D2','SIAC','Lane','Lane',NULL),
('D2','SIAC','Miles Golden Bears','milescollege','Miles','ii','SIAC','Miles College','Miles,MIL','D2','SIAC','Miles','Miles',NULL),
('D2','SIAC','Morehouse Maroon Tigers','morehouse','Morehouse','ii','SIAC','Morehouse College','Morehouse,MOR','D2','SIAC','Morehouse','Morehouse',NULL),
('D2','SIAC','Savannah State Tigers','savannahstate','Savannah State','ii','SIAC','Savannah St','Savannah State,SAV','D2','SIAC','Savannah State','Savannah_St',NULL),
('D2','SIAC','Tuskegee Golden Tigers','tuskegee','Tuskegee','ii','SIAC','Tuskegee','TUS','D2','SIAC','Tuskegee','Tuskegee',NULL),
('D2','South Atlantic','Anderson (SC) Trojans','andersonsc','Anderson (SC)','ii','South Atlantic','Anderson (Sc)','Anderson (SC),AND','D2','South Atlantic','Anderson (SC)','Anderson_SC',NULL),
('D2','South Atlantic','Barton Bulldogs','barton','Barton','ii','South Atlantic','Wilson','Barton College,BARTON','D2','South Atlantic','Barton','Barton',NULL),
('D2','South Atlantic','Carson-Newman Eagles','carsonnewman','Carson-Newman','ii','South Atlantic','Carson-Newman College','Carson-Newman,CAR,Carson Newman College','D2','South Atlantic','Carson-Newman','Carson-Newman',NULL),
('D2','South Atlantic','Catawba Indians','catawba','Catawba','ii','South Atlantic','Catawba','Catawba College,CAT','D2','South Atlantic','Catawba','Catawba',NULL),
('D2','South Atlantic','Emory & Henry Wasps','emoryhenry','Emory & Henry','ii','South Atlantic','Emory & Henry College','Emory & Henry,EMHEN','D2','South Atlantic','Emory & Henry','Emory_&_Henry',NULL),
('D2','South Atlantic','Lenoir-Rhyne Bears','lenoirrhyne','Lenoir-Rhyne','ii','South Atlantic','Lenoir-Rhyne','LENRHYNE,Len-Rhyne','D2','South Atlantic','Lenoir-Rhyne','Lenoir-Rhyne',NULL),
('D2','South Atlantic','Limestone Saints','limestone','Limestone','ii','South Atlantic','Limestone','LIMESTONE','D2','South Atlantic','Limestone','Limestone',NULL),
('D2','South Atlantic','Mars Hill Lions','marshill','Mars Hill','ii','South Atlantic','Mars Hill','MARSHILL','D2','South Atlantic','Mars Hill','Mars_Hill',NULL),
('D2','South Atlantic','Newberry Wolves','newberry','Newberry','ii','South Atlantic','Newberry','NBY','D2','South Atlantic','Newberry','Newberry',NULL),
('D2','South Atlantic','Tusculum Pioneers','tusculum','Tusculum','ii','South Atlantic','Greeneville','Tusculum,TUS','D2','South Atlantic','Tusculum','Tusculum',NULL),
('D2','South Atlantic','Virginia-Wise Cavaliers','virginiawise','Virginia-Wise','ii','South Atlantic','UVA Wise','UVA-Wise,VA Wise,VIRWISE','D2','South Atlantic','Virginia-Wise','UVA-Wise',NULL),
('D2','South Atlantic','Wingate Bulldogs','wingate','Wingate','ii','South Atlantic','Wingate','WIN','D2','South Atlantic','Wingate','Wingate',NULL),
('D2','D2 Independents','Northeastern State RiverHawks','northeasternstate','Northeastern State','ii','Independent DII','Northeastern State','NOR,NE ST','D2','D2 Independents','Northeastern State','NE_Oklahoma',NULL),
('D2','D2 Independents','Shorter Hawks','shorter','Shorter','ii','Gulf South','Shorter','SHOR','D2','D2 Independents','Shorter','Shorter',NULL),
('D3','American Rivers','Buena Vista Beavers','buenavista','Buena Vista','iii','American Rivers','Buena Vista','BUENA','D3','American Rivers','Buena Vista','Buena_Vista',NULL),
('D3','American Rivers','Central Dutch','central','Central','iii','American Rivers','Central College','Central,CNTCIA','D3','American Rivers','Central','Central_IA',NULL),
('D3','American Rivers','Coe Kohawks','coe','Coe','iii','American Rivers','Coe College','Coe,COE','D3','American Rivers','Coe','Coe',NULL),
('D3','American Rivers','Dubuque Spartans','dubuque','Dubuque','iii','American Rivers','Dubuque','DUB','D3','American Rivers','Dubuque','Dubuque',NULL),
('D3','American Rivers','Loras Duhawks','loras','Loras','iii','American Rivers','Loras College','LOR,Loras','D3','American Rivers','Loras','Loras',NULL),
('D3','American Rivers','Luther Norse','luther','Luther','iii','American Rivers','Luther','LUT','D3','American Rivers','Luther','Luther_IA',NULL),
('D3','American Rivers','Nebraska Wesleyan Prairie Wolves','nebraskawesleyan','Nebraska Wesleyan','iii','American Rivers','Nebraska Wesleyan','Nebraska Wesleyan University,NEBWS,Neb Wesleyan','D3','American Rivers','Nebraska Wesleyan','NE_Wesleyan',NULL),
('D3','American Rivers','Simpson (IA) Storm','simpson','Simpson (IA)','iii','American Rivers','Simpson College (IA)','Simpson College,Simpson,SIMPS','D3','American Rivers','Simpson','Simpson_IA',NULL),
('D3','American Rivers','Wartburg Knights','wartburg','Wartburg','iii','American Rivers','Wartburg','WAR','D3','American Rivers','Wartburg','Wartburg',NULL),
('D3','American Southwest','ETBU Tigers','easttexasbaptist','ETBU','iii','American Southwest','East Texas Baptist University','East Texas Baptist,EAS,E TX Bapt','D3','American Southwest','East Texas Baptist','E_Texas_Bap',NULL),
('D3','American Southwest','Hardin-Simmons Cowboys','hardinsimmons','Hardin-Simmons','iii','American Southwest','Hardin-Simmons','HARDSIM,Hardn-Simm','D3','American Southwest','Hardin-Simmons','Hardin-Simmons',NULL),
('D3','American Southwest','Howard Payne Yellow Jackets','howardpayne','Howard Payne','iii','American Southwest','Howard Payne','HOWPAY,Hwrd Payne','D3','American Southwest','Howard Payne','Howard_Payne',NULL),
('D3','American Southwest','Mary Hardin-Baylor Crusaders','umhb','Mary Hardin-Baylor','iii','American Southwest','Mary Hardin-Baylor','MRYHRBAY,Mry Hr-Bay','D3','American Southwest','Mary Hardin-Baylor','M_Hardin-Baylor',NULL),
('D3','CCIW','Augustana (IL) Vikings','augustana','Augustana (IL)','iii','CCIW','Augustana (IL)','Augustana IL,AUGIL','D3','CCIW','Augustana (IL)','Augustana_IL',NULL),
('D3','CCIW','Carroll (WI) Pioneers','carrollwi','Carroll (WI)','iii','CCIW','Carroll University (WI)','Carroll (WI),CAR,Carroll WI,Carroll (Wisconsin)','D3','CCIW','Carroll (WI)','Carroll_WI',NULL),
('D3','CCIW','Carthage Firebirds','carthage','Carthage','iii','CCIW','Carthage','CARCWI','D3','CCIW','Carthage','Carthage',NULL),
('D3','CCIW','Elmhurst Bluejays','elmhurst','Elmhurst','iii','CCIW','Elmhurst','ELM','D3','CCIW','Elmhurst','Elmhurst',NULL),
('D3','CCIW','Illinois Wesleyan Titans','illinoiswesleyan','Illinois Wesleyan','iii','CCIW','Illinois Wesleyan','IL Weslyan,ILLWES','D3','CCIW','Illinois Wesleyan','IL_Wesleyan',NULL),
('D3','CCIW','Millikin Big Blue','millikin','Millikin','iii','CCIW','Millikin','MIL','D3','CCIW','Millikin','Millikin',NULL),
('D3','CCIW','North Central (IL) Cardinals','northcentral','North Central (IL)','iii','CCIW','North Central College','North Central,NOR,N Central','D3','CCIW','North Central','N_Central_IL',NULL),
('D3','CCIW','North Park Vikings','northpark','North Park','iii','CCIW','North Park','NOR','D3','CCIW','North Park','North_Park',NULL),
('D3','CCIW','WashU Bears','washu','WashU','iii','CCIW','Washington University (St. Louis)','Washington (MO),Wash St Louis,WSTL','D3','CCIW','WashU','Washington_StL',NULL),
('D3','CCIW','Wheaton (IL) Thunder','wheaton','Wheaton (IL)','iii','CCIW','Wheaton','Wheaton College (Ill),WHEATON','D3','CCIW','Wheaton (IL)','Wheaton_IL',NULL),
('D3','Centennial','Dickinson Red Devils','dickinson','Dickinson','iii','Centennial','Dickinson (PA)','Dickinson,DIC,Dicknsn PA','D3','Centennial','Dickinson','Dickinson',NULL),
('D3','Centennial','Franklin & Marshall Diplomats','franklinmarshall','Franklin & Marshall','iii','Centennial','Franklin & Marshall','FRKLNMAR,Frkln Mrsh','D3','Centennial','Franklin & Marshall','Frank_&_Marsh',NULL),
('D3','Centennial','Gettysburg Bullets','gettysburg','Gettysburg','iii','Centennial','Gettysburg','GETTY','D3','Centennial','Gettysburg','Gettysburg',NULL),
('D3','Centennial','Johns Hopkins Blue Jays','johnshopkins','Johns Hopkins','iii','Centennial','Johns Hopkins University','Johns Hopkins,JHU','D3','Centennial','Johns Hopkins','Johns_Hopkins',NULL),
('D3','Centennial','McDaniel Green Terror','mcdaniel','McDaniel','iii','Centennial','McDaniel College','McDaniel,MCD','D3','Centennial','McDaniel','McDaniel',NULL),
('D3','Centennial','Muhlenberg Mules','muhlenberg','Muhlenberg','iii','Centennial','Muhlenberg','MHLBRG','D3','Centennial','Muhlenberg','Muhlenberg',NULL),
('D3','Centennial','Ursinus Bears','ursinus','Ursinus','iii','Centennial','Ursinus','URS','D3','Centennial','Ursinus','Ursinus',NULL),
('D3','Conference of New England','Curry Colonels','curry','Curry','iii','Commonwealth Coast','Curry College','Curry,CUR','D3','Commonwealth Coast','Curry','Curry',NULL),
('D3','Conference of New England','Endicott Gulls','endicott','Endicott','iii','Commonwealth Coast','Endicott College','Endicott,END','D3','Commonwealth Coast','Endicott','Endicott',NULL),
('D3','Conference of New England','Husson Eagles','husson','Husson','iii','Commonwealth Coast','Husson','HUSSON','D3','Commonwealth Coast','Husson','Husson',NULL),
('D3','Conference of New England','Nichols Bison','nichols','Nichols','iii','Commonwealth Coast','Nichols College','Nichols,NICHOLS,Nichls Col','D3','Commonwealth Coast','Nichols','Nichols',NULL),
('D3','Conference of New England','UNE Nor''easters','une','UNE','iii','Commonwealth Coast','Biddeford','University of New England,NWENG,NEWENGLAND','D3','Commonwealth Coast','New England (ME)','U_New_England',NULL),
('D3','Conference of New England','Western New England Golden Bears','westernnewengland','Western New England','iii','Commonwealth Coast','Western New England','WNWENG,Western NE','D3','Commonwealth Coast','Western New England','W_New_England',NULL),
('D3','Conference of New England','Maine Maritime Mariners','mainemaritime','Maine Maritime','iii','Independent DIII','Maine Maritime','ME Mrtme,MAI','D3','Conference of New England','Maine Maritime','ME_Maritime',NULL),
('D3','Conference of New England','New England College Pilgrims','newengland','New England College',NULL,NULL,NULL,NULL,'D3','Conference of New England','New England College','New_England_College',NULL),
('D3','ECFC','Alfred State Pioneers','alfredstate','Alfred State','iii','ECFC','Alfred State','Alfred State College,Alfred St,ASC','D3','ECFC','Alfred State','Alfred_St',NULL),
('D3','ECFC','Anna Maria AMCATS','annamaria','Anna Maria','iii','ECFC','Anna Maria College','Anna Maria,ANN','D3','ECFC','Anna Maria','Anna_Maria',NULL),
('D3','ECFC','Dean Bulldogs','dean','Dean','iii','ECFC','Dean College','DEA','D3','ECFC','Dean','Dean',NULL),
('D3','ECFC','Gallaudet Bison','gallaudet','Gallaudet','iii','ECFC','Gallaudet','GALLAUDET','D3','ECFC','Gallaudet','Gallaudet',NULL),
('D3','Empire 8','Alfred Saxons','alfred','Alfred','iii','Empire 8','Alfred University','Alfred,ALF','D3','Empire 8','Alfred','Alfred',NULL),
('D3','Empire 8','Brockport Golden Eagles','brockport','Brockport','iii','Empire 8','Brockport','Brockport State (NY),BRO','D3','Empire 8','Brockport','Brockport_St',NULL),
('D3','Empire 8','Cortland Red Dragons','sunycortland','Cortland','iii','Empire 8','Cortland','SUNY Cortland,CORTLAND','D3','Empire 8','Cortland','Cortland_St',NULL),
('D3','Empire 8','Hartwick Hawks','hartwick','Hartwick','iii','Empire 8','Hartwick','HAR','D3','Empire 8','Hartwick','Hartwick',NULL),
('D3','Empire 8','Hilbert Hawks','hilbert','Hilbert','iii','Empire 8','Hilbert College','HIL','D3','Empire 8','Hilbert','Hilbert',NULL),
('D3','Empire 8','Morrisville State Mustangs','morrisvillestate','Morrisville State','iii','Empire 8','SUNY Morrisville','Morrisville State,MOR,Morrisvlle','D3','Empire 8','Morrisville State','Morrisville_St',NULL),
('D3','Empire 8','St. John Fisher Cardinals','stjohnfisher','St. John Fisher','iii','Empire 8','St John Fisher University','St. John Fisher,SJFISH,St John Fisher','D3','Empire 8','St. John Fisher','St_John_Fisher',NULL),
('D3','Empire 8','Utica Pioneers','utica','Utica','iii','Empire 8','Utica','UTICA','D3','Empire 8','Utica','Utica',NULL),
('D3','Heartland','Anderson (IN) Ravens','anderson','Anderson (IN)','iii','Heartland','Anderson (IN)','Anderson IN,AND','D3','Heartland','Anderson (IN)','Anderson_IN',NULL),
('D3','Heartland','Bluffton Beavers','bluffton','Bluffton','iii','Heartland','Bluffton','BLUFFTON','D3','Heartland','Bluffton','Bluffton',NULL),
('D3','Heartland','Franklin Grizzlies','franklin','Franklin','iii','Heartland','Franklin','FRANKLIN','D3','Heartland','Franklin','Franklin',NULL),
('D3','Heartland','Hanover Panthers','hanover','Hanover','iii','Heartland','Hanover College','Hanover,HAN','D3','Heartland','Hanover','Hanover',NULL),
('D3','Heartland','Manchester Spartans','manchester','Manchester','iii','Heartland','Manchester','MNCHSTR','D3','Heartland','Manchester (IN)','Manchester',NULL),
('D3','Heartland','Mount St. Joseph Lions','mountstjoseph','Mount St. Joseph','iii','Heartland','Mount St. Joseph','MTS,Mt St Joe','D3','Heartland','Mount St. Joseph','Mt_St_Joseph',NULL),
('D3','Heartland','Rose-Hulman Engineers','rosehulman','Rose-Hulman','iii','Heartland','Rose-Hulman','Rosehulman,ROSEHUL','D3','Heartland','Rose-Hulman','Rose-Hulman',NULL),
('D3','Landmark','Catholic Cardinals','catholic','Catholic','iii','Landmark Conference','Catholic','Catholic University,CATH','D3','Landmark','Catholic','Catholic',NULL),
('D3','Landmark','Juniata Eagles','juniata','Juniata','iii','Landmark Conference','Juniata College','Juniata,JUN','D3','Landmark','Juniata','Juniata',NULL),
('D3','Landmark','Keystone Giants','keystone','Keystone','iii','Landmark Conference','Keystone','KYSTN,KEYST','D3','Landmark','Keystone','Keystone',NULL),
('D3','Landmark','Lycoming Warriors','lycoming','Lycoming','iii','Landmark Conference','Lycoming','LYCOMING','D3','Landmark','Lycoming','Lycoming',NULL),
('D3','Landmark','Moravian Greyhounds','moravian','Moravian','iii','Landmark Conference','Moravian','MOR','D3','Landmark','Moravian','Moravian',NULL),
('D3','Landmark','Susquehanna River Hawks','susquehanna','Susquehanna','iii','Landmark Conference','Susquehanna','Susquehnna,SUS','D3','Landmark','Susquehanna','Susquehanna',NULL),
('D3','Landmark','Wilkes Colonels','wilkes','Wilkes','iii','Landmark Conference','Wilkes','WILKES','D3','Landmark','Wilkes','Wilkes',NULL),
('D3','Liberty League','Buffalo State Bengals','buffalostate','Buffalo State','iii','Liberty League','Buffalo State','BUF,BUFFALOST','D3','Liberty League','Buffalo State','Buffalo_St',NULL),
('D3','Liberty League','Hobart Statesmen','hobart','Hobart','iii','Liberty League','Hobart College','Hobart,HBRT','D3','Liberty League','Hobart','Hobart_&_Smith',NULL),
('D3','Liberty League','Ithaca Bombers','ithaca','Ithaca','iii','Liberty League','Ithaca College','Ithaca,ITH','D3','Liberty League','Ithaca','Ithaca',NULL),
('D3','Liberty League','Rochester Yellowjackets','rochester','Rochester','iii','Liberty League','University of Rochester (NY)','Rochester,ROC','D3','Liberty League','Rochester','Rochester_NY',NULL),
('D3','Liberty League','RPI Engineers','rpi','RPI','iii','Liberty League','Rensselaer','RPI','D3','Liberty League','RPI','Rensselaer',NULL),
('D3','Liberty League','St. Lawrence Saints','stlawrence','St. Lawrence','iii','Liberty League','St. Lawrence','St Lawrence,USL','D3','Liberty League','St. Lawrence','St_Lawrence',NULL),
('D3','Liberty League','Union (NY) Garnet Chargers','union','Union (NY)','iii','Liberty League','Union (NY)','Union,UNNY,Union College','D3','Liberty League','Union (NY)','Union_NY',NULL),
('D3','MASCAC','Bridgewater State Bears','bridgewaterstate','Bridgewater State','iii','MSCAC','Bridgewater State','Bridgewater St,BRST','D3','MASCAC','Bridgewater State','Bridgewater_MA',NULL),
('D3','MASCAC','Castleton Spartans','castleton','Castleton','iii','MSCAC','Castleton','Castleton State College,CAS','D3','MASCAC','Castleton','Castleton',NULL),
('D3','MASCAC','Fitchburg State Falcons','fitchburgstate','Fitchburg State','iii','MSCAC','Fitchburg State','Fitchburg,FITCH','D3','MASCAC','Fitchburg State','Fitchburg_St',NULL),
('D3','MASCAC','Framingham State Rams','framinghamstate','Framingham State','iii','MSCAC','Framingham State','Framingham,FRA','D3','MASCAC','Framingham State','Framingham_St',NULL),
('D3','MASCAC','Massachusetts Maritime Buccaneers','massachusettsmaritime','Massachusetts Maritime','iii','MSCAC','Mass Maritime','MAMARI,MA Maritme','D3','MASCAC','Massachusetts Maritime','MA_Maritime',NULL),
('D3','MASCAC','Plymouth State Panthers','plymouthstate','Plymouth State','iii','MSCAC','Plymouth State','PLYST,Plymouthst','D3','MASCAC','Plymouth State','Plymouth_St',NULL),
('D3','MASCAC','UMass Dartmouth Corsairs','umassdartmouth','UMass Dartmouth','iii','MSCAC','UMass Dartmouth','UMass Dart,MASSA','D3','MASCAC','UMass Dartmouth','MA_Dartmouth',NULL),
('D3','MASCAC','WestConn Wolves','westernconnecticutstate','WestConn','iii','MSCAC','Western Connecticut St','Western Connecticut State,WES,W Conn St','D3','MASCAC','Western Connecticut','W_Connecticut',NULL),
('D3','MASCAC','Westfield State Owls','westfieldstate','Westfield State','iii','MSCAC','Westfield State','WES,Westfield St','D3','MASCAC','Westfield State','Westfield_St',NULL),
('D3','MASCAC','Worcester State Lancers','worcesterstate','Worcester State','iii','MSCAC','Worcester St','Worcester State College,Wor State,WORST','D3','MASCAC','Worcester State','Worcester_St',NULL),
('D3','MIAC','Augsburg Auggies','augsburg','Augsburg','iii','Minnesota','Augsburg','AUG','D3','MIAC','Augsburg','Augsburg',NULL),
('D3','MIAC','Bethel (MN) Royals','bethel','Bethel (MN)','iii','Minnesota','Bethel (MN)','BET','D3','MIAC','Bethel (MN)','Bethel_MN',NULL),
('D3','MIAC','Carleton Knights','carletonmn','Carleton','iii','Minnesota','Carleton','CARLETON','D3','MIAC','Carleton (MN)','Carleton_MN',NULL),
('D3','MIAC','Concordia (MN-Moorhead) Cobbers','concordiamoorhead','Concordia (MN-Moorhead)','iii','Minnesota','Concordia Moorhead','Concordia (MN),CONCOMN,Cncrdia MH','D3','MIAC','Concordia (MN-Moorhead)','Concordia_Mhd',NULL),
('D3','MIAC','Gustavus Adolphus Golden Gusties','gustavusadolphus','Gustavus Adolphus','iii','Minnesota','Gustavus Adolphus','GUSADOL,Gustvs Adl','D3','MIAC','Gustavus Adolphus','Gust_Adolphus',NULL),
('D3','MIAC','Hamline Pipers','hamline','Hamline','iii','Minnesota','Hamline University','Hamline,HAM','D3','MIAC','Hamline','Hamline',NULL),
('D3','MIAC','Macalester Scots','macalester','Macalester','iii','Minnesota','Macalester','MACALES','D3','MIAC','Macalester','Macalester',NULL),
('D3','MIAC','St. John''s (MN) Johnnies','stjohnsmn','St. John''s (MN)','iii','Minnesota','Saint John''s (MN)','St. Johns (MN),ST. J,St. John''s,St John''s (MN)','D3','MIAC','St. John''s (MN)','St_John''s_MN',NULL),
('D3','MIAC','St. Olaf Oles','stolaf','St. Olaf','iii','Minnesota','St. Olaf','St. Olaf College,STO','D3','MIAC','St. Olaf','St_Olaf',NULL),
('D3','MIAC','St. Scholastica Saints','stscholastica','St. Scholastica','iii','Minnesota','St. Scholastica','Scholastic,SCHOLA','D3','MIAC','St. Scholastica','St_Scholastica',NULL),
('D3','Michigan IAA','Adrian Bulldogs','adrian','Adrian','iii','Michigan','Adrian','ADR','D3','Michigan IAA','Adrian','Adrian',NULL),
('D3','Michigan IAA','Albion Britons','albion','Albion','iii','Michigan','Albion','ALBI','D3','Michigan IAA','Albion','Albion',NULL),
('D3','Michigan IAA','Alma Scots','alma','Alma','iii','Michigan','Alma','Alma College,ALM','D3','Michigan IAA','Alma','Alma',NULL),
('D3','Michigan IAA','Calvin Knights','calvin','Calvin','iii','Michigan','Calvin University','Calvin Univers,CAL','D3','Michigan IAA','Calvin','Calvin',NULL),
('D3','Michigan IAA','Hope Flying Dutchmen','hope','Hope','iii','Michigan','Hope College','Hope,HOP','D3','Michigan IAA','Hope','Hope',NULL),
('D3','Michigan IAA','Kalamazoo Hornets','kalamazoo','Kalamazoo','iii','Michigan','Kalamazoo','KAL','D3','Michigan IAA','Kalamazoo','Kalamazoo',NULL),
('D3','Michigan IAA','Olivet Comets','olivet','Olivet','iii','Michigan','Olivet College','OLI,Olivetcoll','D3','Michigan IAA','Olivet','Olivet_MI',NULL),
('D3','Michigan IAA','Trine Thunder','trine','Trine','iii','Michigan','Trine University','Trine,TRI','D3','Michigan IAA','Trine','Trine',NULL),
('D3','Middle Atlantic','Albright Lions','albright','Albright','iii','Mid Atlantic','Albright','ALB','D3','Middle Atlantic','Albright','Albright',NULL),
('D3','Middle Atlantic','Alvernia Golden Wolves','alvernia','Alvernia','iii','Mid Atlantic','Reading','Alvernia University,ALVERNIA','D3','Middle Atlantic','Alvernia','Alvernia',NULL),
('D3','Middle Atlantic','Delaware Valley Aggies','delawarevalley','Delaware Valley','iii','Mid Atlantic','Delaware Valley','Del Valley,DV','D3','Middle Atlantic','Delaware Valley','Delaware_Val',NULL),
('D3','Middle Atlantic','Eastern Eagles','eastern','Eastern','iii','Mid Atlantic','Eastern University','EAS,Eastern,Eastern_Univ','D3','Middle Atlantic','Eastern','Eastern','Eastern_Univ'),
('D3','Middle Atlantic','FDU Florham Devils','fduflorham','FDU Florham','iii','Mid Atlantic','FDU-Florham','FDUFLOR,FDU Florhm','D3','Middle Atlantic','FDU Florham','FDU_Madison',NULL),
('D3','Middle Atlantic','King''s Monarchs','kings','King''s','iii','Mid Atlantic','Kings College (PA)','King''s College (PA),KIN,Kings PA','D3','Middle Atlantic','King''s (PA)','King''s_PA',NULL),
('D3','Middle Atlantic','Lebanon Valley Flying Dutchmen','lebanonvalley','Lebanon Valley','iii','Mid Atlantic','Lebanon Valley','Lebanon,LEB','D3','Middle Atlantic','Lebanon Valley','Lebanon_Val',NULL),
('D3','Middle Atlantic','Misericordia Cougars','misericordia','Misericordia','iii','Mid Atlantic','Misericordia','Misercord,MISC','D3','Middle Atlantic','Misericordia','Misericordia',NULL),
('D3','Middle Atlantic','Stevenson Mustangs','stevenson','Stevenson','iii','Mid Atlantic','Stevenson','STU','D3','Middle Atlantic','Stevenson','Stevenson',NULL),
('D3','Middle Atlantic','Widener Pride','widener','Widener','iii','Mid Atlantic','Widener','WID','D3','Middle Atlantic','Widener','Widener',NULL),
('D3','Midwest','Beloit Buccaneers','beloit','Beloit','iii','Midwest','Beloit','Beloit College,BEL','D3','Midwest','Beloit','Beloit',NULL),
('D3','Midwest','Chicago Maroons','chicago','Chicago','iii','Midwest','Chicago','CHI','D3','Midwest','Chicago','Chicago',NULL),
('D3','Midwest','Cornell (IA) Rams','cornellia','Cornell (IA)','iii','Midwest','Cornell College (IA)','Cornellia,CORNELLIA,Cornell College','D3','Midwest','Cornell (IA)','Cornell_IA',NULL),
('D3','Midwest','Grinnell Pioneers','grinnell','Grinnell','iii','Midwest','Grinnell','GRI','D3','Midwest','Grinnell','Grinnell',NULL),
('D3','Midwest','Illinois College Blueboys','illinoiscollege','Illinois College','iii','Midwest','Illinois College','Ill Col,ILLCOLL','D3','Midwest','Illinois College','Illinois_Col',NULL),
('D3','Midwest','Knox Prairie Fire','knox','Knox','iii','Midwest','Knox College','KNO,Knox','D3','Midwest','Knox','Knox',NULL),
('D3','Midwest','Lake Forest Foresters','lakeforest','Lake Forest','iii','Midwest','Lake Forest College','Lake Forest,LAK,Lake Forst','D3','Midwest','Lake Forest','Lake_Forest',NULL),
('D3','Midwest','Lawrence Vikings','lawrence','Lawrence','iii','Midwest','Lawrence University','Lawrence,LAW','D3','Midwest','Lawrence','Lawrence',NULL),
('D3','Midwest','Monmouth (IL) Fighting Scots','monmouthil','Monmouth (IL)','iii','Midwest','Monmouth (IL)','MONMIL,Monmth IL','D3','Midwest','Monmouth (IL)','Monmouth_IL',NULL),
('D3','Midwest','Ripon Red Hawks','ripon','Ripon','iii','Midwest','Ripon','RIP','D3','Midwest','Ripon','Ripon',NULL),
('D3','NACC','Aurora Spartans','aurora','Aurora','iii','NACC','Aurora','AUR','D3','NACC','Aurora','Aurora',NULL),
('D3','NACC','Benedictine (IL) Eagles','benedictine','Benedictine (IL)','iii','NACC','Benedictine University','Benedictine (IL),Benedictine,BENILL','D3','NACC','Benedictine (IL)','Benedictine_IL',NULL),
('D3','NACC','Concordia (IL) Cougars','concordiachicago','Concordia (IL)','iii','NACC','Concordia University Chicago','Concordia (IL),Cncrdia IL,CONCOIL','D3','NACC','Concordia (IL)','Concordia_IL',NULL),
('D3','NACC','Concordia (WI) Falcons','concordiawi','Concordia (WI)','iii','NACC','Concordia-Wisconsin','Concordia (WI),Cncrdia WI,CONW','D3','NACC','Concordia (WI)','Concordia_WI',NULL),
('D3','NACC','Eureka Red Devils','eureka','Eureka','iii','NACC','Eureka College','Eureka,EUR','D3','NACC','Eureka','Eureka',NULL),
('D3','NACC','Lakeland Muskies','lakeland','Lakeland','iii','NACC','Lakeland','Lakeland University,LAKEL','D3','NACC','Lakeland','Lakeland',NULL),
('D3','NACC','Rockford Regents','rockford','Rockford','iii','NACC','Rockford','ROCKF','D3','NACC','Rockford','Rockford',NULL),
('D3','NACC','St. Norbert Green Knights','stnorbert','St. Norbert','iii','NACC','St. Norbert','St Norbert,STN','D3','NACC','St. Norbert','St_Norbert',NULL),
('D3','NACC','Wisconsin Lutheran Warriors','wisconsinlutheran','Wisconsin Lutheran','iii','NACC','Wisconsin-Lutheran','Wisconsin Lutheran,Wis Luthrn,WILU','D3','NACC','Wisconsin Lutheran','WI_Lutheran',NULL),
('D3','NESCAC','Amherst Mammoths','amherst','Amherst','iii','NESCAC','Amherst','Amherst College,AMH','D3','NESCAC','Amherst','Amherst',NULL),
('D3','NESCAC','Bates Bobcats','bates','Bates','iii','NESCAC','Bates','Bates College,BAT','D3','NESCAC','Bates','Bates',NULL),
('D3','NESCAC','Bowdoin Polar Bears','bowdoin','Bowdoin','iii','NESCAC','Bowdoin','BOW','D3','NESCAC','Bowdoin','Bowdoin',NULL),
('D3','NESCAC','Colby White Mules','colby','Colby','iii','NESCAC','Colby College','Colby,COLBY','D3','NESCAC','Colby','Colby',NULL),
('D3','NESCAC','Hamilton Continentals','hamilton','Hamilton','iii','NESCAC','Hamilton','HAM','D3','NESCAC','Hamilton','Hamilton',NULL),
('D3','NESCAC','Middlebury Panthers','middlebury','Middlebury','iii','NESCAC','Middlebury','MIDLBRY','D3','NESCAC','Middlebury','Middlebury',NULL),
('D3','NESCAC','Trinity (CT) Bantams','trinityct','Trinity (CT)','iii','NESCAC','Trinity (CT)','TRI,Trinity CT','D3','NESCAC','Trinity (CT)','Trinity_CT',NULL),
('D3','NESCAC','Tufts Jumbos','tufts','Tufts','iii','NESCAC','Tufts','TUF','D3','NESCAC','Tufts','Tufts',NULL),
('D3','NESCAC','Wesleyan (CT) Cardinals','wesleyan','Wesleyan (CT)','iii','NESCAC','Wesleyan University (CT)','Wesleyan,WES','D3','NESCAC','Wesleyan','Wesleyan_CT',NULL),
('D3','NESCAC','Williams Ephs','williams','Williams','iii','NESCAC','Williams','WIL','D3','NESCAC','Williams','Williams',NULL),
('D3','NEWMAC','Coast Guard Bears','coastguard','Coast Guard','iii','NEWMAC','Coast Guard','USCGA','D3','NEWMAC','Coast Guard','Coast_Guard',NULL),
('D3','NEWMAC','Merchant Marine Mariners','merchantmarine','Merchant Marine','iii','NEWMAC','Merchant Marine Academy','Merchant Marine,MER,Mrchnt Mar','D3','NEWMAC','Merchant Marine','Merchant_Marine',NULL),
('D3','NEWMAC','MIT Engineers','mit','MIT','iii','NEWMAC','MIT',NULL,'D3','NEWMAC','MIT','MIT',NULL),
('D3','NEWMAC','Norwich Cadets','norwich','Norwich','iii','NEWMAC','Norwich','NOR','D3','NEWMAC','Norwich','Norwich',NULL),
('D3','NEWMAC','Salve Regina Seahawks','salveregina','Salve Regina','iii','NEWMAC','Salve Regina','Salvregina,SALVE','D3','NEWMAC','Salve Regina','Salve_Regina',NULL),
('D3','NEWMAC','Springfield Pride','springfield','Springfield','iii','NEWMAC','Springfield','Springfld,SPR','D3','NEWMAC','Springfield','Springfield',NULL),
('D3','NEWMAC','SUNY Maritime Privateers','sunymaritime','SUNY Maritime','iii','NEWMAC','SUNY Maritime','Maritme NY,SUNYMAR','D3','NEWMAC','SUNY Maritime','SUNY_Maritime',NULL),
('D3','NEWMAC','WPI Engineers','wpi','WPI','iii','NEWMAC','Worcester Polytechnic Institute','Worcester Polytechnic,Wor Tech,WORCE','D3','NEWMAC','WPI','Worcester_Tech',NULL),
('D3','NJAC','Christopher Newport Captains','christophernewport','Christopher Newport','iii','New Jersey','Christopher Newport','Chris Nwpt,CHR','D3','NJAC','Christopher Newport','Chris_Newport',NULL),
('D3','NJAC','Kean Cougars','kean','Kean','iii','New Jersey','Kean','KEAN','D3','NJAC','Kean','Kean',NULL),
('D3','NJAC','Montclair State Red Hawks','montclairstate','Montclair State','iii','New Jersey','Montclair State','Montclr St,MON','D3','NJAC','Montclair State','Montclair_St',NULL),
('D3','NJAC','Rowan Professors','rowan','Rowan','iii','New Jersey','Rowan','ROW','D3','NJAC','Rowan','Rowan',NULL),
('D3','NJAC','Salisbury Seagulls','salisbury','Salisbury','iii','New Jersey','Salisbury','SALIS','D3','NJAC','Salisbury','Salisbury',NULL),
('D3','NJAC','TCNJ Lions','tcnj','TCNJ','iii','New Jersey','College Of New Jersey','College of New Jersey,COL,C of NJ','D3','NJAC','TCNJ','College_of_NJ',NULL),
('D3','NJAC','William Paterson Pioneers','williampaterson','William Paterson','iii','New Jersey','William Paterson','WILLPAT,Will Paterson','D3','NJAC','William Paterson','Wm_Paterson',NULL),
('D3','North Coast','Denison Big Red','denison','Denison','iii','North Coast','Denison University','Denison,DEN','D3','North Coast','Denison','Denison',NULL),
('D3','North Coast','DePauw Tigers','depauw','DePauw','iii','North Coast','Depauw','DePauw,DEP','D3','North Coast','DePauw','DePauw',NULL),
('D3','North Coast','Hiram Terriers','hiram','Hiram','iii','North Coast','Hiram College','Hiram,HIRAM','D3','North Coast','Hiram','Hiram',NULL),
('D3','North Coast','Kenyon Owls','kenyon','Kenyon','iii','North Coast','Kenyon','KEN','D3','North Coast','Kenyon','Kenyon',NULL),
('D3','North Coast','Oberlin Yeomen','oberlin','Oberlin','iii','North Coast','Oberlin','OBERLIN','D3','North Coast','Oberlin','Oberlin',NULL),
('D3','North Coast','Ohio Wesleyan Battling Bishops','ohiowesleyan','Ohio Wesleyan','iii','North Coast','Ohio Wesleyan','Ohioweslyn,OHWESL','D3','North Coast','Ohio Wesleyan','Ohio_Wesleyan',NULL),
('D3','North Coast','Wabash Little Giants','wabash','Wabash','iii','North Coast','Wabash College','Wabash,WAB','D3','North Coast','Wabash','Wabash',NULL),
('D3','North Coast','Wittenberg Tigers','wittenberg','Wittenberg','iii','North Coast','Wittenberg','WITTEN','D3','North Coast','Wittenberg','Wittenberg',NULL),
('D3','North Coast','Wooster Fighting Scots','wooster','Wooster','iii','North Coast','Wooster','WOO','D3','North Coast','Wooster','Wooster',NULL),
('D3','Northwest','George Fox Bruins','georgefox','George Fox','iii','Northwest','NEWBERG','George Fox University,GFU,George Fox','D3','Northwest','George Fox','George_Fox',NULL),
('D3','Northwest','Lewis & Clark Pioneers','lewisclark','Lewis & Clark','iii','Northwest','Lewis & Clark College','Lewis & Clark,LEW,Lws & Clrk','D3','Northwest','Lewis & Clark','Lewis_&_Clark',NULL),
('D3','Northwest','Linfield Wildcats','linfield','Linfield','iii','Northwest','Linfield College','Linfield,LIN','D3','Northwest','Linfield','Linfield',NULL),
('D3','Northwest','Pacific (OR) Boxers','pacificor','Pacific (OR)','iii','Northwest','Pacific (OR)','Pacificor,PAC','D3','Northwest','Pacific (OR)','Pacific_OR',NULL),
('D3','Northwest','Pacific Lutheran Lutes','pacificlutheran','Pacific Lutheran','iii','Northwest','Pacific Lutheran','Pacluthern,PACLTH','D3','Northwest','Pacific Lutheran','Pac_Lutheran',NULL),
('D3','Northwest','Puget Sound Loggers','pugetsound','Puget Sound','iii','Northwest','Puget Sound','PUGET,Pugetsound','D3','Northwest','Puget Sound','Puget_Sound',NULL),
('D3','Northwest','Whitworth Pirates','whitworth','Whitworth','iii','Northwest','Whitworth','WHI','D3','Northwest','Whitworth','Whitworth',NULL),
('D3','Northwest','Willamette Bearcats','willamette','Willamette','iii','Northwest','Willamette','WLLMTT','D3','Northwest','Willamette','Willamette',NULL),
('D3','OAC','Baldwin Wallace Yellow Jackets','baldwinwallace','Baldwin Wallace','iii','Ohio','Baldwin Wallace','Baldwin-Wallace,Bald Wallace,BAL','D3','OAC','Baldwin Wallace','Baldwin-Wallace',NULL),
('D3','OAC','Capital Comets','capital','Capital','iii','Ohio','Capital','CAPITAL','D3','OAC','Capital','Capital',NULL),
('D3','OAC','Heidelberg Fighting Student Princes','heidelberg','Heidelberg','iii','Ohio','Heidelberg','HEI','D3','OAC','Heidelberg','Heidelberg',NULL),
('D3','OAC','John Carroll Blue Streaks','johncarroll','John Carroll','iii','Ohio','John Carroll University','John Carroll,John Carrl,JOH','D3','OAC','John Carroll','John_Carroll',NULL),
('D3','OAC','Marietta Pioneers','marietta','Marietta','iii','Ohio','Marietta','MAR','D3','OAC','Marietta','Marietta',NULL),
('D3','OAC','Mount Union Purple Raiders','mountunion','Mount Union','iii','Ohio','University of Mount Union','Mount Union,Mt Union,MTU','D3','OAC','Mount Union','Mt_Union',NULL),
('D3','OAC','Muskingum Fighting Muskies','muskingum','Muskingum','iii','Ohio','Muskingum University','Muskingum,MUS','D3','OAC','Muskingum','Muskingum',NULL),
('D3','OAC','Ohio Northern Polar Bears','ohionorthern','Ohio Northern','iii','Ohio','Ohio Northern','OHNRTH,Ohio Nor','D3','OAC','Ohio Northern','Ohio_Northern',NULL),
('D3','OAC','Otterbein Cardinals','otterbein','Otterbein','iii','Ohio','Otterbein','OTT','D3','OAC','Otterbein','Otterbein',NULL),
('D3','OAC','Wilmington (OH) Quakers','wilmington','Wilmington (OH)','iii','Ohio','Wilmington (OH)','WILMOH,Wilmington OH','D3','OAC','Wilmington','Wilmington_OH',NULL),
('D3','ODAC','Averett Cougars','averett','Averett','iii','Old Dominion','Averett','AVE','D3','ODAC','Averett','Averett',NULL),
('D3','ODAC','Bridgewater Eagles','bridgewater','Bridgewater','iii','Old Dominion','Bridgewater (VA)','Bridgewater VA,BRVA','D3','ODAC','Bridgewater','Bridgewater_VA',NULL),
('D3','ODAC','Ferrum Panthers','ferrum','Ferrum','iii','Old Dominion','Ferrum','FER','D3','ODAC','Ferrum','Ferrum',NULL),
('D3','ODAC','Guilford Quakers','guilford','Guilford','iii','Old Dominion','Guilford College','Guilford,GUI','D3','ODAC','Guilford','Guilford',NULL),
('D3','ODAC','Hampden-Sydney Tigers','hampdensydney','Hampden-Sydney','iii','Old Dominion','Hampden-Sydney','Hamp Sdney,HAM','D3','ODAC','Hampden-Sydney','Hampden-Sydney',NULL),
('D3','ODAC','Randolph-Macon Yellow Jackets','randolphmacon','Randolph-Macon','iii','Old Dominion','Randolph-Macon','Randmacon,RAN','D3','ODAC','Randolph-Macon','Randolph-Macon',NULL),
('D3','ODAC','Shenandoah Hornets','shenandoah','Shenandoah','iii','Old Dominion','Shenandoah','SHENAN','D3','ODAC','Shenandoah','Shenandoah',NULL),
('D3','ODAC','Washington & Lee Generals','washingtonlee','Washington & Lee','iii','Old Dominion','Washington and Lee','Washington & Lee,Wash and Lee,UWL','D3','ODAC','Washington & Lee','Washington_&_Lee',NULL),
('D3','Presidents'' AC','Allegheny Gators','allegheny','Allegheny','iii','Presidents''','Allegheny','ALL','D3','Presidents'' AC','Allegheny','Allegheny',NULL),
('D3','Presidents'' AC','Bethany (WV) Bison','bethanywv','Bethany (WV)','iii','Presidents''','Bethany (WV)','BETHWV,Bethany (West Virginia)','D3','Presidents'' AC','Bethany (WV)','Bethany_WV',NULL),
('D3','Presidents'' AC','Carnegie Mellon Tartans','carnegiemellon','Carnegie Mellon','iii','Presidents''','Carnegie Mellon','Carng Mell,CARNGMELL','D3','Presidents'' AC','Carnegie Mellon','Carnegie_Mellon',NULL),
('D3','Presidents'' AC','Case Western Reserve Spartans','casewestern','Case Western Reserve','iii','Presidents''','Case Western Reserve','CSR,Case Wstrn','D3','Presidents'' AC','Case Western Reserve','Case_Western',NULL),
('D3','Presidents'' AC','Geneva Golden Tornadoes','geneva','Geneva','iii','Presidents''','Geneva','Geneva College,GENEVA','D3','Presidents'' AC','Geneva','Geneva',NULL),
('D3','Presidents'' AC','Grove City Wolverines','grovecity','Grove City','iii','Presidents''','Grove City College','GRO,Grove City','D3','Presidents'' AC','Grove City','Grove_City',NULL),
('D3','Presidents'' AC','St. Vincent Bearcats','saintvincent','St. Vincent','iii','Presidents''','Saint Vincent','St. Vincent,STV','D3','Presidents'' AC','St. Vincent','St_Vincent',NULL),
('D3','Presidents'' AC','Thiel Tomcats','thiel','Thiel','iii','Presidents''','Thiel','Thiel College,THIEL','D3','Presidents'' AC','Thiel','Thiel',NULL),
('D3','Presidents'' AC','Washington & Jefferson Presidents','washingtonjefferson','Washington & Jefferson','iii','Presidents''','Washington & Jefferson','WAS,Wash & Jeff','D3','Presidents'' AC','Washington & Jefferson','Wash_&_Jeff',NULL),
('D3','Presidents'' AC','Waynesburg Yellow Jackets','waynesburg','Waynesburg','iii','Presidents''','Waynesburg','WAYNEB','D3','Presidents'' AC','Waynesburg','Waynesburg',NULL),
('D3','Presidents'' AC','Westminster (PA) Titans','westministerpa','Westminster (PA)','iii','Presidents''','Westminster (PA)','Westminster PA,WMNPA,Wmnsterpa','D3','Presidents'' AC','Westminster (PA)','Westminster_PA',NULL),
('D3','SAA','Berry Vikings','berry','Berry','iii','Southern Athletic','Berry College','BER,Berry','D3','SAA','Berry','Berry',NULL),
('D3','SAA','Centre Colonels','centre','Centre','iii','Southern Athletic','Centre College Kentucky','Centre,CENTRE','D3','SAA','Centre','Centre',NULL),
('D3','SAA','Hendrix Warriors','hendrix','Hendrix','iii','Southern Athletic','Hendrix College','Hendrix,HENDRIX','D3','SAA','Hendrix','Hendrix',NULL),
('D3','SAA','Millsaps Majors','millsaps','Millsaps','iii','Southern Athletic','Millsaps','MIL','D3','SAA','Millsaps','Millsaps',NULL),
('D3','SAA','Rhodes Lynx','rhodes','Rhodes','iii','Southern Athletic','Rhodes College','Rhodes,RHO','D3','SAA','Rhodes','Rhodes',NULL),
('D3','SAA','Sewanee Tigers','sewanee','Sewanee','iii','Southern Athletic','Sewanee','Sewanee Univ. of the South,SEWAN','D3','SAA','Sewanee','Sewanee',NULL),
('D3','SAA','Southwestern (TX) Pirates','southwesterntx','Southwestern (TX)','iii','Southern Athletic','Southwestern University','SW,Southwestern (TX),SW Univ','D3','SAA','Southwestern (TX)','SW_Univ_TX',NULL),
('D3','SAA','Trinity (TX) Tigers','trinitytx','Trinity (TX)','iii','Southern Athletic','Trinity University TX','Trinity (TX),TRTX,Trinity TX','D3','SAA','Trinity (TX)','Trinity_TX',NULL),
('D3','SCAC','Austin Kangaroos','austin','Austin','iii','Southern Collegiate Athletic','Austin','Austin College,AUS','D3','SCAC','Austin','Austin_Col',NULL),
('D3','SCAC','Centenary (LA) Gents','centenary','Centenary (LA)','iii','Southern Collegiate Athletic','CENTENARY','Centenary,CEN','D3','SCAC','Centenary (LA)','Centenary_LA',NULL),
('D3','SCAC','Lyon Scots','lyon','Lyon','iii','Southern Collegiate Athletic','LYONCOLL','Lyon College,LYON','D3','SCAC','Lyon','Lyon',NULL),
('D3','SCAC','McMurry War Hawks','mcmurry','McMurry','iii','Southern Collegiate Athletic','McMurry','MCM','D3','SCAC','McMurry','McMurry',NULL),
('D3','SCAC','Texas Lutheran Bulldogs','texaslutheran','Texas Lutheran','iii','Southern Collegiate Athletic','Texas Lutheran','TL','D3','SCAC','Texas Lutheran','TX_Lutheran',NULL),
('D3','SCAC','Schreiner Mountaineers','schreiner','Schreiner',NULL,NULL,NULL,NULL,'D3','SCAC','Schreiner','Schreiner',NULL),
('D3','SCIAC','Cal Lutheran Kingsmen','callutheran','Cal Lutheran','iii','So. Cal.','California Lutheran University','Cal Lutheran,California Lutheran,Cal Luthrn,CALLUTH','D3','SCIAC','Cal Lutheran','Cal_Lutheran',NULL),
('D3','SCIAC','Chapman Panthers','chapman','Chapman','iii','So. Cal.','Chapman','CHA','D3','SCIAC','Chapman','Chapman',NULL),
('D3','SCIAC','Claremont-Mudd-Scripps Stags','claremontmuddscripps','Claremont-Mudd-Scripps','iii','So. Cal.','Claremont-Mudd-Scripps College','Claremont,Clare Mudd,CLA','D3','SCIAC','Claremont-Mudd-Scripps','Claremont_M.S.',NULL),
('D3','SCIAC','La Verne Leopards','laverne','La Verne','iii','So. Cal.','La Verne','Laverne,LAVERNE','D3','SCIAC','La Verne','La_Verne',NULL),
('D3','SCIAC','Pomona-Pitzer Sagehens','pomonapitzer','Pomona-Pitzer','iii','So. Cal.','Pomona Pitzer','Pomona-Pitzer,POM,Pomonapit','D3','SCIAC','Pomona-Pitzer','Pomona_Pitzer',NULL),
('D3','SCIAC','Redlands Bulldogs','redlands','Redlands','iii','So. Cal.','Redlands','RED','D3','SCIAC','Redlands','Redlands',NULL),
('D3','Upper Midwest','Crown Polars','crown','Crown','iii','Upper Midwest','Crown College','CROWN,Crown','D3','Upper Midwest','Crown','Crown_MN',NULL),
('D3','Upper Midwest','Greenville Panthers','greenville','Greenville','iii','Upper Midwest','Greenville','GRNVIL','D3','Upper Midwest','Greenville','Greenville',NULL),
('D3','Upper Midwest','Martin Luther Knights','martinluther','Martin Luther','iii','Upper Midwest','Martin Luther','Martin Luther College,MAR,Mart Lther','D3','Upper Midwest','Martin Luther','Martin_Luther',NULL),
('D3','Upper Midwest','Minnesota-Morris Cougars','minnesotamorris','Minnesota-Morris','iii','Upper Midwest','Minnesota Morris','Minnesota-Morris,MN Morris,MNMOR','D3','Upper Midwest','Minnesota-Morris','MN_Morris',NULL),
('D3','Upper Midwest','Northwestern (MN) Eagles','northwesternstpaul','Northwestern (MN)','iii','Upper Midwest','Northwestern (MN)','NWMN,NW Coll MN','D3','Upper Midwest','Northwestern (MN)','Northwestern_MN',NULL),
('D3','Upper Midwest','Westminster (MO) Blue Jays','westministermo','Westminster (MO)','iii','Upper Midwest','Westminster College (MO)','Westminster,Wmnstermo,WMN','D3','Upper Midwest','Westminster (MO)','Westminster_MO',NULL),
('D3','USA South','Belhaven Blazers','belhaven','Belhaven','iii','USA South','Belhaven','Belhaven College,BELHA','D3','USA South','Belhaven','Belhaven_MS',NULL),
('D3','USA South','Brevard Tornados','brevard','Brevard','iii','USA South','Brevard College','BRE,Brevard','D3','USA South','Brevard','Brevard',NULL),
('D3','USA South','Greensboro Pride','greensboro','Greensboro','iii','USA South','Greensboro College','Greensboro,GRNSBORO','D3','USA South','Greensboro','Greensboro',NULL),
('D3','USA South','Huntingdon Hawks','huntingdon','Huntingdon','iii','USA South','Huntingdon College (AL)','Huntingdon,HNTNGDN','D3','USA South','Huntingdon','Huntingdon',NULL),
('D3','USA South','LaGrange Panthers','lagrange','LaGrange','iii','USA South','Lagrange College','LaGrange College,LAG,LaGrange','D3','USA South','LaGrange','LaGrange',NULL),
('D3','USA South','Maryville (TN) Scots','maryville','Maryville (TN)','iii','USA South','Maryville College (TN)','Maryville TN,Maryville,MRYVILTN,Maryville (TN)','D3','USA South','Maryville','Maryville_TN',NULL),
('D3','USA South','Methodist Monarchs','methodist','Methodist','iii','USA South','Methodist','MTH','D3','USA South','Methodist','Methodist',NULL),
('D3','USA South','NC Wesleyan Battling Bishops','ncwesleyan','NC Wesleyan','iii','USA South','North Carolina Wesleyan','NC Wesleyan,NORTH,NC Wesleyn','D3','USA South','NC Wesleyan','NC_Wesleyan',NULL),
('D3','USA South','Southern Virginia Knights','southernvirginia','Southern Virginia','iii','USA South','Southern Virginia','S Virginia,SVA','D3','USA South','Southern Virginia','S_Virginia',NULL),
('D3','WIAC','Wisconsin-Eau Claire Blugolds','wisconsineauclaire','Wisconsin-Eau Claire','iii','Wisconsin','Wisconsin-Eau Claire','Wis EC,WISE','D3','WIAC','Wisconsin-Eau Claire','WI_Eau_Claire',NULL),
('D3','WIAC','Wisconsin-La Crosse Eagles','wisconsinlacrosse','Wisconsin-La Crosse','iii','Wisconsin','Wisconsin-Lacrosse','Wisconsin-La Crosse,Wis LC,WISL','D3','WIAC','Wisconsin-La Crosse','WI_LaCrosse',NULL),
('D3','WIAC','Wisconsin-Oshkosh Titans','wisconsinoshkosh','Wisconsin-Oshkosh','iii','Wisconsin','Wisconsin-Oshkosh','UW-Oshkosh,WISO,Wis Osh','D3','WIAC','Wisconsin-Oshkosh','WI_Oshkosh',NULL),
('D3','WIAC','Wisconsin-Platteville Pioneers','wisconsinplatteville','Wisconsin-Platteville','iii','Wisconsin','Wisconsin-Platteville','WIPL,Wis Platte','D3','WIAC','Wisconsin-Platteville','WI_Platteville',NULL),
('D3','WIAC','Wisconsin-River Falls Falcons','wisconsinriverfalls','Wisconsin-River Falls','iii','Wisconsin','Wisconsin-River Falls','UW-River Falls,Wis RF,WIRF','D3','WIAC','Wisconsin-River Falls','WI_River_Falls',NULL),
('D3','WIAC','Wisconsin-Stevens Point Pointers','wisconsinstevenspoint','Wisconsin-Stevens Point','iii','Wisconsin','Wisconsin-Stevens Pt','Wisconsin-Stevens Point,WISP,Wis Stevns','D3','WIAC','Wisconsin-Stevens Point','WI_Stevens_Pt',NULL),
('D3','WIAC','Wisconsin-Stout Blue Devils','wisconsinstout','Wisconsin-Stout','iii','Wisconsin','Wisconsin-Stout','UW-Stout,WISS,Wis Stout','D3','WIAC','Wisconsin-Stout','WI_Stout',NULL),
('D3','WIAC','Wisconsin-Whitewater Warhawks','wisconsinwhitewater','Wisconsin-Whitewater','iii','Wisconsin','Wisconsin-Whitewater','UW-Whitewater,WISW,Wis Whtwtr','D3','WIAC','Wisconsin-Whitewater','WI_Whitewater',NULL),
('NAIA','Appalachian AC','Bluefield Rams','bluefield','Bluefield',NULL,NULL,NULL,NULL,'NAIA','Appalachian AC','Bluefield','Bluefield_Univ',NULL),
('NAIA','Appalachian AC','Kentucky Christian Knights','kentuckychristian','Kentucky Christian','Unknown','Unknown','Kentucky Christian',NULL,'NAIA','Appalachian AC','Kentucky Christian','Kentucky_Chr',NULL),
('NAIA','Appalachian AC','Pikeville Bears','pikeville','Pikeville','Unknown','Unknown','Pikeville',NULL,'NAIA','Appalachian AC','Pikeville','Pikeville',NULL),
('NAIA','Appalachian AC','Point Skyhawks','point','Point','Unknown','Unknown','Point University',NULL,'NAIA','Appalachian AC','Point','Point',NULL),
('NAIA','Appalachian AC','Reinhardt Eagles','reinhardt','Reinhardt','Unknown','Unknown','Reinhardt','Reinhardt University','NAIA','Appalachian AC','Reinhardt','Reinhardt',NULL),
('NAIA','Appalachian AC','St. Andrews Knights','standrewsnc','St. Andrews','Unknown','Unknown','St. Andrews','Laurinburg','NAIA','Appalachian AC','St. Andrews (NC)','St_Andrew''s',NULL),
('NAIA','Appalachian AC','Union Commonwealth Bulldogs','unionky','Union Commonwealth',NULL,NULL,NULL,NULL,'NAIA','Appalachian AC','Union Commonwealth','Union_KY',NULL),
('NAIA','Frontier','Arizona Christian Firestorm','azchristian','Arizona Christian','Unknown','Unknown','Arizona Christian','Phoenix','NAIA','Frontier','Arizona Christian','Arizona_Chr',NULL),
('NAIA','Frontier','Carroll (MT) Fighting Saints','carrollmt','Carroll (MT)',NULL,NULL,NULL,NULL,'NAIA','Frontier','Carroll (MT)','Carroll_MT',NULL),
('NAIA','Frontier','College of Idaho Coyotes','collegeidaho','College of Idaho','Unknown','Unknown','College of Idaho',NULL,'NAIA','Frontier','College of Idaho','Col_of_Idaho',NULL),
('NAIA','Frontier','Eastern Oregon Mountaineers','easternoregon','Eastern Oregon','Unknown','Unknown','Eastern Oregon',NULL,'NAIA','Frontier','Eastern Oregon','Eastern_Oregon',NULL),
('NAIA','Frontier','Montana Tech Orediggers','montanatech','Montana Tech','Unknown','Unknown','Montana Tech',NULL,'NAIA','Frontier','Montana Tech','MT_Tech',NULL),
('NAIA','Frontier','Montana Western Bulldogs','montanawestern','Montana Western','Unknown','Unknown','Montana-Western',NULL,'NAIA','Frontier','Montana Western','MT_Western',NULL),
('NAIA','Frontier','MSU Northern Lights','montanastatenorthern','MSU Northern','Unknown','Unknown','MONTANASTN',NULL,'NAIA','Frontier','Montana State-Northern','MT_St_Northern',NULL),
('NAIA','Frontier','Rocky Mountain Battlin'' Bears','rockymountain','Rocky Mountain',NULL,NULL,NULL,NULL,'NAIA','Frontier','Rocky Mountain','Rocky_Mtn',NULL),
('NAIA','Frontier','Southern Oregon Raiders','southernoregon','Southern Oregon','Unknown','Unknown','Southern Oregon',NULL,'NAIA','Frontier','Southern Oregon','Southern_Oregon',NULL),
('NAIA','Great Plains','Briar Cliff Chargers','briarcliff','Briar Cliff',NULL,NULL,NULL,NULL,'NAIA','Great Plains','Briar Cliff','Briar_Cliff',NULL),
('NAIA','Great Plains','Concordia (NE) Bulldogs','concordiane','Concordia (NE)',NULL,NULL,NULL,NULL,'NAIA','Great Plains','Concordia (NE)','Concordia_NE',NULL),
('NAIA','Great Plains','Dakota Wesleyan Tigers','dakotawesleyan','Dakota Wesleyan','Unknown','Unknown','Dakota Wesleyan',NULL,'NAIA','Great Plains','Dakota Wesleyan','Dakota_Wesleyan',NULL),
('NAIA','Great Plains','Doane Tigers','doane','Doane','Unknown','Unknown','Doane',NULL,'NAIA','Great Plains','Doane','Doane',NULL),
('NAIA','Great Plains','Dordt Defenders','dordt','Dordt',NULL,NULL,NULL,NULL,'NAIA','Great Plains','Dordt','Dordt',NULL),
('NAIA','Great Plains','Hastings Broncos','hastings','Hastings','Unknown','Unknown','Hastings',NULL,'NAIA','Great Plains','Hastings','Hastings',NULL),
('NAIA','Great Plains','Midland Warriors','midland','Midland',NULL,NULL,NULL,NULL,'NAIA','Great Plains','Midland','Midland_NE',NULL),
('NAIA','Great Plains','Morningside Mustangs','morningside','Morningside','Unknown','Unknown','Morningside',NULL,'NAIA','Great Plains','Morningside','Morningside',NULL),
('NAIA','Great Plains','Mount Marty Lancers','mountmarty','Mount Marty',NULL,NULL,NULL,NULL,'NAIA','Great Plains','Mount Marty','Mt_Marty',NULL),
('NAIA','Great Plains','Northwestern (IA) Red Raiders','northwesternia','Northwestern (IA)','Unknown','Unknown','Northwestern (IA)',NULL,'NAIA','Great Plains','Northwestern (IA)','Northwestern_IA',NULL),
('NAIA','Great Plains','Waldorf Warriors','waldorf','Waldorf','Unknown','Unknown','Waldorf','Waldorf College','NAIA','Great Plains','Waldorf','Waldorf',NULL),
('NAIA','Heart of America','Baker Wildcats','baker','Baker','Unknown','Unknown','Baker',NULL,'NAIA','Heart of America','Baker','Baker_KS',NULL),
('NAIA','Heart of America','Benedictine (KS) Ravens','benedictineks','Benedictine (KS)',NULL,NULL,NULL,NULL,'NAIA','Heart of America','Benedictine (KS)','Benedictine_KS',NULL),
('NAIA','Heart of America','Central Methodist Eagles','centralmethodist','Central Methodist','Unknown','Unknown','Central Methodist',NULL,'NAIA','Heart of America','Central Methodist','Cent_Methodist',NULL),
('NAIA','Heart of America','Clarke Pride','clarke','Clarke',NULL,NULL,NULL,NULL,'NAIA','Heart of America','Clarke','Clarke',NULL),
('NAIA','Heart of America','Culver-Stockton Wildcats','culverstockton','Culver-Stockton','Unknown','Unknown','Culver-Stockton',NULL,'NAIA','Heart of America','Culver-Stockton','Culver-Stockton',NULL),
('NAIA','Heart of America','Graceland Yellowjackets','graceland','Graceland',NULL,NULL,NULL,NULL,'NAIA','Heart of America','Graceland','Graceland',NULL),
('NAIA','Heart of America','Grand View Vikings','grandview','Grand View','Unknown','Unknown','Grand View',NULL,'NAIA','Heart of America','Grand View','Grand_View',NULL),
('NAIA','Heart of America','MidAmerica Nazarene Pioneers','midamericanazarene','MidAmerica Nazarene',NULL,NULL,NULL,NULL,'NAIA','Heart of America','MidAmerica Nazarene','Mid_Am_Nazarene',NULL),
('NAIA','Heart of America','Missouri Baptist Spartans','missouribaptist','Missouri Baptist','Unknown','Unknown','Missouri Baptist',NULL,'NAIA','Heart of America','Missouri Baptist','MO_Baptist',NULL),
('NAIA','Heart of America','Missouri Valley Vikings','missourivalley','Missouri Valley','Unknown','Unknown','Missouri Valley',NULL,'NAIA','Heart of America','Missouri Valley','Missouri_Val',NULL),
('NAIA','Heart of America','Peru State Bobcats','perustate','Peru State','Unknown','Unknown','Peru State',NULL,'NAIA','Heart of America','Peru State','Peru_St',NULL),
('NAIA','Heart of America','St. Ambrose Fighting Bees','stambrose','St. Ambrose','Unknown','Unknown','St. Ambrose','St Ambrose University  Iowa','NAIA','Heart of America','St. Ambrose','St_Ambrose',NULL),
('NAIA','Heart of America','William Penn Statesmen','williampenn','William Penn','Unknown','Unknown','William Penn',NULL,'NAIA','Heart of America','William Penn','William_Penn',NULL),
('NAIA','Heart of America','William Woods Owls','williamwoods','William Woods','Unknown','Unknown','William Woods',NULL,'NAIA','Heart of America','William Woods','W_Woods',NULL),
('NAIA','KCAC','Avila Eagles','avila','Avila',NULL,NULL,NULL,NULL,'NAIA','KCAC','Avila','Avila',NULL),
('NAIA','KCAC','Bethany (KS) Swedes','bethanyks','Bethany (KS)','Unknown','Unknown','Bethany (KS)',NULL,'NAIA','KCAC','Bethany (KS)','Bethany_KS',NULL),
('NAIA','KCAC','Bethel (KS) Threshers','bethelks','Bethel (KS)','Unknown','Unknown','Bethel Col',NULL,'NAIA','KCAC','Bethel (KS)','Bethel_KS',NULL),
('NAIA','KCAC','Evangel Valor','evangel','Evangel','Unknown','Unknown','Evangel',NULL,'NAIA','KCAC','Evangel','Evangel',NULL),
('NAIA','KCAC','Friends Falcons','friends','Friends','Unknown','Unknown','Friends',NULL,'NAIA','KCAC','Friends','Friends',NULL),
('NAIA','KCAC','Kansas Wesleyan Coyotes','kansaswesleyan','Kansas Wesleyan','Unknown','Unknown','Kansas Wesleyan',NULL,'NAIA','KCAC','Kansas Wesleyan','KS_Wesleyan',NULL),
('NAIA','KCAC','McPherson Bulldogs','mcpherson','McPherson',NULL,NULL,NULL,NULL,'NAIA','KCAC','McPherson','McPherson',NULL),
('NAIA','KCAC','Ottawa (KS) Braves','ottawaks','Ottawa (KS)',NULL,NULL,NULL,NULL,'NAIA','KCAC','Ottawa (KS)','Ottawa_KS',NULL),
('NAIA','KCAC','Southwestern (KS) Moundbuilders','southwesternks','Southwestern (KS)',NULL,NULL,NULL,NULL,'NAIA','KCAC','Southwestern (KS)','Southwestern_KS',NULL),
('NAIA','KCAC','St. Mary (KS) Spires','saintmary','St. Mary (KS)',NULL,NULL,NULL,NULL,'NAIA','KCAC','St. Mary (KS)','St_Mary_KS',NULL),
('NAIA','KCAC','Sterling Warriors','sterling','Sterling',NULL,NULL,NULL,NULL,'NAIA','KCAC','Sterling','Sterling',NULL),
('NAIA','KCAC','Tabor Bluejays','tabor','Tabor',NULL,NULL,NULL,NULL,'NAIA','KCAC','Tabor','Tabor',NULL),
('NAIA','Mid-South','Bethel (TN) Wildcats','betheltn','Bethel (TN)','Unknown','Unknown','Bethel (TN)','Bethel University Tennessee','NAIA','Mid-South','Bethel (TN)','Bethel_TN',NULL),
('NAIA','Mid-South','Campbellsville Tigers','campbellsville','Campbellsville','Unknown','Unknown','Campbellsville University',NULL,'NAIA','Mid-South','Campbellsville','Campbellsville',NULL),
('NAIA','Mid-South','Cumberland Phoenix','cumberland','Cumberland','Unknown','Unknown','Cumberland',NULL,'NAIA','Mid-South','Cumberland','Cumberland_TN',NULL),
('NAIA','Mid-South','Cumberlands Patriots','cumberlands','Cumberlands',NULL,NULL,NULL,NULL,'NAIA','Mid-South','Cumberlands','Cumberlands_KY',NULL),
('NAIA','Mid-South','Faulkner Eagles','faulkner','Faulkner','Unknown','Unknown','Faulkner','Faulkner University','NAIA','Mid-South','Faulkner','Faulkner',NULL),
('NAIA','Mid-South','Georgetown (KY) Tigers','georgetownky','Georgetown (KY)','Unknown','Unknown','Georgetown (KY)','Georgetown College Kentucky,Georgetown (Kentucky)','NAIA','Mid-South','Georgetown (KY)','Georgetown_KY',NULL),
('NAIA','Mid-South','Lindsey Wilson Blue Raiders','lindseywilson','Lindsey Wilson','Unknown','Unknown','Lindsey Wilson',NULL,'NAIA','Mid-South','Lindsey Wilson','Lindsey_Wilson',NULL),
('NAIA','Mid-States','Concordia (MI) Cardinals','concordiami','Concordia (MI)','Unknown','Unknown','Concordia College (MI)','Concordia-Michigan','NAIA','MSFA','Concordia (MI)','Concordia_MI',NULL),
('NAIA','Mid-States','Defiance Yellow Jackets','defiance','Defiance','iii','Heartland','Defiance','Defiance College','NAIA','MSFA','Defiance','Defiance',NULL),
('NAIA','Mid-States','Indiana Wesleyan Wildcats','indianawesleyan','Indiana Wesleyan','Unknown','Unknown','Indiana Wesleyan',NULL,'NAIA','MSFA','Indiana Wesleyan','IN_Wesleyan',NULL),
('NAIA','Mid-States','Judson Eagles','judson','Judson','Unknown','Unknown','Judson University','Elgin','NAIA','MSFA','Judson','Judson_IL',NULL),
('NAIA','Mid-States','Lawrence Tech Blue Devils','lawrencetech','Lawrence Tech','Unknown','Unknown','Lawrence Tech',NULL,'NAIA','MSFA','Lawrence Tech','Lawrence_Tech',NULL),
('NAIA','Mid-States','Madonna Crusaders','madonna','Madonna','Unknown','Unknown','Madonna University','Madonna University (Mich.)','NAIA','MSFA','Madonna','Madonna',NULL),
('NAIA','Mid-States','Marian (IN) Knights','marian','Marian (IN)','Unknown','Unknown','MARIAN (IN',NULL,'NAIA','MSFA','Marian','Marian_IN',NULL),
('NAIA','Mid-States','Olivet Nazarene Tigers','olivetnazarene','Olivet Nazarene',NULL,NULL,NULL,NULL,'NAIA','MSFA','Olivet Nazarene','Olivet_Naz',NULL),
('NAIA','Mid-States','Siena Heights Saints','sienaheights','Siena Heights','Unknown','Unknown','Siena Heights',NULL,'NAIA','MSFA','Siena Heights','Siena_Hts',NULL),
('NAIA','Mid-States','St. Francis (IL) Fighting Saints','stfrancisil','St. Francis (IL)','Unknown','Unknown','St. Francis (IL)',NULL,'NAIA','MSFA','St. Francis (IL)','St_Francis_IL',NULL),
('NAIA','Mid-States','St. Francis (IN) Cougars','saintfrancisin','St. Francis (IN)','Unknown','Unknown','St. Francis (IN)','University Of St Francis IN','NAIA','MSFA','St. Francis (IN)','St_Francis_IN',NULL),
('NAIA','Mid-States','St. Xavier Cougars','saintxavier','St. Xavier','Unknown','Unknown','St. Xavier (IL)','St. Xavier IL','NAIA','MSFA','St. Xavier','St_Xavier_IL',NULL),
('NAIA','Mid-States','Taylor Trojans','taylor','Taylor','Unknown','Unknown','Taylor',NULL,'NAIA','MSFA','Taylor','Taylor_IN',NULL),
('NAIA','North Star','Dakota State Trojans','dakotastate','Dakota State','Unknown','Unknown','Dakota State','Dakota State University','NAIA','NSAA','Dakota State','Dakota_St',NULL),
('NAIA','North Star','Dickinson State Blue Hawks','dickinsonstate','Dickinson State','Unknown','Unknown','Dickinson State','Dickinson State University','NAIA','NSAA','Dickinson State','Dickinson_St_ND',NULL),
('NAIA','North Star','Jamestown Jimmies','jamestown','Jamestown','Unknown','Unknown','Jamestown','Jamestown College','NAIA','NSAA','Jamestown','Jamestown',NULL),
('NAIA','North Star','Mayville State Comets','mayvillestate','Mayville State','Unknown','Unknown','Mayville State',NULL,'NAIA','NSAA','Mayville State','Mayville_St',NULL),
('NAIA','North Star','Valley City State Vikings','valleycitystate','Valley City State','Unknown','Unknown','Valley City State',NULL,'NAIA','NSAA','Valley City State','Valley_City_St',NULL),
('NAIA','Sooner AC','Arkansas Baptist Buffaloes','arkansasbaptist','Arkansas Baptist','Unknown','Unknown','Arkansas Baptist','Little Rock','NAIA','Sooner AC','Arkansas Baptist','Ark_Baptist',NULL),
('NAIA','Sooner AC','Langston Lions','langston','Langston','Unknown','Unknown','Langston','Langston University','NAIA','Sooner AC','Langston','Langston',NULL),
('NAIA','Sooner AC','Louisiana Christian Wildcats','louisianacollege','Louisiana Christian','Unknown','Unknown','Louisiana Christian','LA College,LACOLLEGE,Louisiana_College,Louisiana College,Louisiana_Col,Louisiana_Chr','NAIA','Sooner AC','Louisiana Christian','Louisiana_College,Louisiana College,Louisiana_Col,Louisiana_Chr',NULL),
('NAIA','Sooner AC','Nelson Lions','swag','Nelson','Unknown','Unknown','Southwestern Assemblies of God',NULL,'NAIA','Sooner AC','Nelson','SW_Assemb_God',NULL),
('NAIA','Sooner AC','North American Stallions','northamerican','North American','Unknown','Unknown','North American University',NULL,'NAIA','Sooner AC','North American','North_American',NULL),
('NAIA','Sooner AC','Ottawa (AZ) Spirit','ouaz','Ottawa (AZ)',NULL,NULL,NULL,NULL,'NAIA','Sooner AC','Ottawa (AZ)','Ottawa_AZ',NULL),
('NAIA','Sooner AC','Panhandle State Aggies','oklahomapanhandle','Panhandle State','ii','Independent DII','OK Panhandle St','Oklahoma Panhandle St','D3','D3 Independents','Oklahoma Panhandle','Panhandle_St',NULL),
('NAIA','Sooner AC','Texas College Steers','texascollege','Texas College','Unknown','Unknown','Texas College',NULL,'NAIA','Sooner AC','Texas College','Texas_Col',NULL),
('NAIA','Sooner AC','Texas Wesleyan Rams','texaswesleyan','Texas Wesleyan','Unknown','Unknown','Texas Wesleyan',NULL,'NAIA','Sooner AC','Texas Wesleyan','TX_Wesleyan',NULL),
('NAIA','Sooner AC','Wayland Baptist Pioneers','waylandbaptist','Wayland Baptist','Unknown','Unknown','Wayland Baptist',NULL,'NAIA','Sooner AC','Wayland Baptist','Wayland',NULL),
('NAIA','The Sun','Ave Maria Gyrenes','avemaria','Ave Maria','Unknown','Unknown','Ave Maria','Ave Maria University','NAIA','The Sun','Ave Maria','Ave_Maria',NULL),
('NAIA','The Sun','Florida Memorial Lions','floridamemorial','Florida Memorial','Unknown','Unknown','Florida Memorial University',NULL,'NAIA','The Sun','Florida Memorial','FL_Memorial',NULL),
('NAIA','The Sun','Keiser Seahawks','keiser','Keiser','Unknown','Unknown','Keiser University','Keiser (Fl)','NAIA','The Sun','Keiser','Keiser',NULL),
('NAIA','The Sun','Southeastern Fire','southeastern','Southeastern',NULL,NULL,NULL,NULL,'NAIA','The Sun','Southeastern (FL)','Southeastern_FL',NULL),
('NAIA','The Sun','St. Thomas (FL) Bobcats','stthomasfl','St. Thomas (FL)','Unknown','Unknown','St. Thomas University (Fl)',NULL,'NAIA','The Sun','St. Thomas (FL)','St_Thomas_FL',NULL),
('NAIA','The Sun','Thomas (GA) Night Hawks','thomasga','Thomas (GA)',NULL,NULL,NULL,NULL,'NAIA','The Sun','Thomas (GA)','Thomas_GA',NULL),
('NAIA','The Sun','Warner Royals','warner','Warner','Unknown','Unknown','Warner','Warner University','NAIA','The Sun','Warner','Warner',NULL),
('NAIA','The Sun','Webber International Warriors','webberinternational','Webber International','Unknown','Unknown','Webber International',NULL,'NAIA','The Sun','Webber International','Webber',NULL),
('NAIA','NAIA Independent','Simpson (CA) Red Hawks','simpsonca','Simpson (CA)','Unknown','Unknown','Simpson University (Ca)',NULL,'NAIA','NAIA Independent','Simpson (CA)','Simpson_CA',NULL),
('CCCAA','North American','Cabrillo Seahawks','cabrillo','Cabrillo',NULL,NULL,NULL,NULL,'CCCAA','North American','Cabrillo','Cabrillo',NULL),
('CCCAA','North American','College of the Redwoods Corsairs','collegeredwoods','College of the Redwoods',NULL,NULL,NULL,NULL,'CCCAA','North American','College of the Redwoods','Col_of_the_Redwoods',NULL),
('CCCAA','North American','Foothill Owls','foothill','Foothill',NULL,NULL,NULL,NULL,'CCCAA','North American','Foothill','Foothill_Col',NULL),
('CCCAA','North American','Gavilan Rams','gavilan','Gavilan',NULL,NULL,NULL,NULL,'CCCAA','North American','Gavilan','Gavilan',NULL),
('CCCAA','North American','Hartnell Panthers','hartnell','Hartnell',NULL,NULL,NULL,NULL,'CCCAA','North American','Hartnell','Hartnell',NULL),
('CCCAA','North American','Los Medanos Mustangs','losmedanos','Los Medanos',NULL,NULL,NULL,NULL,'CCCAA','North American','Los Medanos','Los_Medanos',NULL),
('CCCAA','North American','Merced Blue Devils','merced','Merced',NULL,NULL,NULL,NULL,'CCCAA','North American','Merced','Merced_Col',NULL),
('CCCAA','North American','Monterey Peninsula Lobos','montereypeninsula','Monterey Peninsula',NULL,NULL,NULL,NULL,'CCCAA','North American','Monterey Peninsula','Monterey_Peninsula',NULL),
('CCCAA','North American','Reedley Tigers','reedley','Reedley',NULL,NULL,NULL,NULL,'CCCAA','North American','Reedley','Reedley',NULL),
('CCCAA','North American','San Jose City Jaguars','sanjosecity','San Jose City',NULL,NULL,NULL,NULL,'CCCAA','North American','San Jose City','San_Jose_City_Col',NULL),
('CCCAA','North American','Shasta Knights','shasta','Shasta',NULL,NULL,NULL,NULL,'CCCAA','North American','Shasta','Shasta_Col',NULL),
('CCCAA','North American','West Hills Falcons','westhills','West Hills',NULL,NULL,NULL,NULL,'CCCAA','North American','West Hills','West_Hills',NULL),
('CCCAA','North American','Yuba 49ers','yuba','Yuba',NULL,NULL,NULL,NULL,'CCCAA','North American','Yuba','Yuba',NULL),
('CCCAA','North National','American River Beavers','americanriver','American River',NULL,NULL,NULL,NULL,'CCCAA','North National','American River','American_River',NULL),
('CCCAA','North National','Butte Roadrunners','butte','Butte',NULL,NULL,NULL,NULL,'CCCAA','North National','Butte','Butte_Col',NULL),
('CCCAA','North National','CC San Francisco Rams','ccsanfrancisco','CC San Francisco',NULL,NULL,NULL,NULL,'CCCAA','North National','CC San Francisco','City_Col_San_Fran',NULL),
('CCCAA','North National','Chabot Gladiators','chabot','Chabot',NULL,NULL,NULL,NULL,'CCCAA','North National','Chabot','Chabot',NULL),
('CCCAA','North National','College of the Sequoias Giants','collegesequoias','College of the Sequoias',NULL,NULL,NULL,NULL,'CCCAA','North National','College of the Sequoias','Col_of_the_Sequoias',NULL),
('CCCAA','North National','College of the Siskiyous Eagles','collegesiskiyous','College of the Siskiyous',NULL,NULL,NULL,NULL,'CCCAA','North National','College of the Siskiyous','Siskiyous',NULL),
('CCCAA','North National','Contra Costa Comets','contracosta','Contra Costa',NULL,NULL,NULL,NULL,'CCCAA','North National','Contra Costa','Contra_Costa',NULL),
('CCCAA','North National','De Anza Dons','deanza','De Anza',NULL,NULL,NULL,NULL,'CCCAA','North National','De Anza','De_Anza_Col',NULL),
('CCCAA','North National','Diablo Valley Vikings','diablovalley','Diablo Valley',NULL,NULL,NULL,NULL,'CCCAA','North National','Diablo Valley','Diablo_Val',NULL),
('CCCAA','North National','Feather River Golden Eagles','featherriver','Feather River',NULL,NULL,NULL,NULL,'CCCAA','North National','Feather River','Feather_River',NULL),
('CCCAA','North National','Fresno City Rams','fresnocity','Fresno City',NULL,NULL,NULL,NULL,'CCCAA','North National','Fresno City','Fresno_City_Col',NULL),
('CCCAA','North National','Laney Eagles','laney','Laney',NULL,NULL,NULL,NULL,'CCCAA','North National','Laney','Laney',NULL),
('CCCAA','North National','Modesto Junior Pirates','modestojunior','Modesto Junior',NULL,NULL,NULL,NULL,'CCCAA','North National','Modesto Junior','Modesto_JC',NULL),
('CCCAA','North National','Sacramento City Panthers','sacramentocity','Sacramento City',NULL,NULL,NULL,NULL,'CCCAA','North National','Sacramento City','Sacramento_City',NULL),
('CCCAA','North National','San Joaquin Delta Mustangs','sanjoaquindelta','San Joaquin Delta',NULL,NULL,NULL,NULL,'CCCAA','North National','San Joaquin Delta','San_Joaquin_Delta',NULL),
('CCCAA','North National','San Mateo Bulldogs','sanmateo','San Mateo',NULL,NULL,NULL,NULL,'CCCAA','North National','San Mateo','Col_San_Mateo',NULL),
('CCCAA','North National','Santa Rosa Junior Bear Cubs','santarosajunior','Santa Rosa Junior',NULL,NULL,NULL,NULL,'CCCAA','North National','Santa Rosa Junior','Santa_Rosa_JC',NULL),
('CCCAA','North National','Sierra Wolverines','sierra','Sierra',NULL,NULL,NULL,NULL,'CCCAA','North National','Sierra','Sierra_Col',NULL),
('CCCAA','South American','Allan Hancock Bulldogs','allanhancock','Allan Hancock',NULL,NULL,NULL,NULL,'CCCAA','South American','Allan Hancock','Allan_Hancock',NULL),
('CCCAA','South American','Antelope Valley Marauders','antelopevalley','Antelope Valley',NULL,NULL,NULL,NULL,'CCCAA','South American','Antelope Valley','Antelope_Val_CC',NULL),
('CCCAA','South American','Citrus Fighting Owls','citrus','Citrus',NULL,NULL,NULL,NULL,'CCCAA','South American','Citrus','Citrus_Col',NULL),
('CCCAA','South American','College of the Desert Roadrunners','collegedesert','College of the Desert',NULL,NULL,NULL,NULL,'CCCAA','South American','College of the Desert','Col_of_the_Desert',NULL),
('CCCAA','South American','Compton CC Tartars','comptoncc','Compton CC',NULL,NULL,NULL,NULL,'CCCAA','South American','Compton CC','Compton_CC',NULL),
('CCCAA','South American','East Los Angeles Huskies','eastlosangeles','East Los Angeles',NULL,NULL,NULL,NULL,'CCCAA','South American','East Los Angeles','East_LA_Col',NULL),
('CCCAA','South American','Glendale CC (CA) Vaqueros','glendaleccca','Glendale CC (CA)',NULL,NULL,NULL,NULL,'CCCAA','South American','Glendale CC (CA)','Glendale_CA',NULL),
('CCCAA','South American','Los Angeles Pierce Brahma Bulls','losangelespierce','Los Angeles Pierce',NULL,NULL,NULL,NULL,'CCCAA','South American','Los Angeles Pierce','LA_Pierce',NULL),
('CCCAA','South American','Los Angeles Southwest Cougars','losangelessouthwest','Los Angeles Southwest',NULL,NULL,NULL,NULL,'CCCAA','South American','Los Angeles Southwest','LA_Southwest',NULL),
('CCCAA','South American','Los Angeles Valley Monarchs','losangelesvalley','Los Angeles Valley',NULL,NULL,NULL,NULL,'CCCAA','South American','Los Angeles Valley','LA_Valley_Col',NULL),
('CCCAA','South American','Mt. San Jacinto Eagles','mtsanjacinto','Mt. San Jacinto',NULL,NULL,NULL,NULL,'CCCAA','South American','Mt. San Jacinto','Mt_San_Jacinto',NULL),
('CCCAA','South American','Pasadena City Lancers','pasadenacity','Pasadena City',NULL,NULL,NULL,NULL,'CCCAA','South American','Pasadena City','Pasadena_City_Col',NULL),
('CCCAA','South American','San Bernardino Valley Wolverines','sanbernardinovalley','San Bernardino Valley',NULL,NULL,NULL,NULL,'CCCAA','South American','San Bernardino Valley','San_Bernardino_Val',NULL),
('CCCAA','South American','San Diego Mesa Olympians','sandiegomesa','San Diego Mesa',NULL,NULL,NULL,NULL,'CCCAA','South American','San Diego Mesa','San_Diego_Mesa',NULL),
('CCCAA','South American','Santa Ana Dons','santaana','Santa Ana',NULL,NULL,NULL,NULL,'CCCAA','South American','Santa Ana','Santa_Ana_Col',NULL),
('CCCAA','South American','Santa Barbara City Vaqueros','santabarbaracity','Santa Barbara City',NULL,NULL,NULL,NULL,'CCCAA','South American','Santa Barbara City','Santa_Barbara_City',NULL),
('CCCAA','South American','Southwestern CC (CA) Jaguars','southwestern','Southwestern CC (CA)',NULL,NULL,NULL,NULL,'CCCAA','South American','Southwestern CC (CA)','Southwestern_CA',NULL),
('CCCAA','South American','Victor Valley Rams','victorvalley','Victor Valley',NULL,NULL,NULL,NULL,'CCCAA','South American','Victor Valley','Victor_Valley',NULL),
('CCCAA','South American','West Los Angeles Wildcats','westlosangeles','West Los Angeles',NULL,NULL,NULL,NULL,'CCCAA','South American','West Los Angeles','West_LA_Col',NULL),
('CCCAA','South National','Bakersfield Renegades','bakersfield','Bakersfield',NULL,NULL,NULL,NULL,'CCCAA','South National','Bakersfield','Bakersfield_Col',NULL),
('CCCAA','South National','Cerritos Falcons','cerritos','Cerritos',NULL,NULL,NULL,NULL,'CCCAA','South National','Cerritos','Cerritos_Col',NULL),
('CCCAA','South National','Chaffey Panthers','chaffey','Chaffey',NULL,NULL,NULL,NULL,'CCCAA','South National','Chaffey','Chaffey',NULL),
('CCCAA','South National','College of the Canyons Cougars','collegecanyons','College of the Canyons','Unknown','Unknown','College of the Canyons',NULL,'CCCAA','South National','College of the Canyons','Col_of_the_Canyons',NULL),
('CCCAA','South National','El Camino Warriors','elcamino','El Camino',NULL,NULL,NULL,NULL,'CCCAA','South National','El Camino','El_Camino_Col',NULL),
('CCCAA','South National','Fullerton Hornets','fullerton','Fullerton',NULL,NULL,NULL,NULL,'CCCAA','South National','Fullerton','Fullerton_Col',NULL),
('CCCAA','South National','Golden West Rustlers','goldenwest','Golden West',NULL,NULL,NULL,NULL,'CCCAA','South National','Golden West','Golden_West',NULL),
('CCCAA','South National','Grossmont Griffins','grossmont','Grossmont',NULL,NULL,NULL,NULL,'CCCAA','South National','Grossmont','Grossmont',NULL),
('CCCAA','South National','Long Beach City Vikings','longbeachcity','Long Beach City',NULL,NULL,NULL,NULL,'CCCAA','South National','Long Beach City','Long_Beach_City_Col',NULL),
('CCCAA','South National','Los Angeles Harbor Seahawks','losangelesharbor','Los Angeles Harbor',NULL,NULL,NULL,NULL,'CCCAA','South National','Los Angeles Harbor','LA_Harbor',NULL),
('CCCAA','South National','Moorpark Raiders','moorpark','Moorpark',NULL,NULL,NULL,NULL,'CCCAA','South National','Moorpark','Moorpark',NULL),
('CCCAA','South National','Mt. SAC Mounties','mountsanantonio','Mt. SAC',NULL,NULL,NULL,NULL,'CCCAA','South National','Mt. SAC','Mt_San_Antonio',NULL),
('CCCAA','South National','Orange Coast Pirates','orangecoast','Orange Coast',NULL,NULL,NULL,NULL,'CCCAA','South National','Orange Coast','Orange_Coast',NULL),
('CCCAA','South National','Palomar Comets','palomar','Palomar',NULL,NULL,NULL,NULL,'CCCAA','South National','Palomar','Palomar_Col',NULL),
('CCCAA','South National','Riverside CC Tigers','riversidecc','Riverside CC',NULL,NULL,NULL,NULL,'CCCAA','South National','Riverside CC','Riverside_CC',NULL),
('CCCAA','South National','Saddleback Bobcats','saddleback','Saddleback',NULL,NULL,NULL,NULL,'CCCAA','South National','Saddleback','Saddleback',NULL),
('CCCAA','South National','Santa Monica Corsairs','santamonica','Santa Monica',NULL,NULL,NULL,NULL,'CCCAA','South National','Santa Monica','Santa_Monica_Col',NULL),
('CCCAA','South National','Ventura Pirates','ventura','Ventura',NULL,NULL,NULL,NULL,'CCCAA','South National','Ventura','Ventura_Col',NULL),
('NJCAA','Iowa Community College Athletic Conference','Ellsworth CC Panthers','ellsworthcc','Ellsworth CC',NULL,NULL,NULL,NULL,'NJCAA','Iowa Community College Athletic Conference','Ellsworth CC','Ellsworth_CC',NULL),
('NJCAA','Iowa Community College Athletic Conference','Iowa Central CC Tritons','iowacentralcc','Iowa Central CC',NULL,NULL,NULL,NULL,'NJCAA','Iowa Community College Athletic Conference','Iowa Central CC','Iowa_Cent',NULL),
('NJCAA','Iowa Community College Athletic Conference','Iowa Western CC Reivers','iowawesterncc','Iowa Western CC',NULL,NULL,NULL,NULL,'NJCAA','Iowa Community College Athletic Conference','Iowa Western CC','Iowa_Western_CC',NULL),
('NJCAA','Kansas Jayhawk Community College Conference','Butler CC Grizzlies','butlercc','Butler CC',NULL,NULL,NULL,NULL,'NJCAA','Kansas Jayhawk Community College Conference','Butler CC','Butler_Co-KS',NULL),
('NJCAA','Kansas Jayhawk Community College Conference','Coffeyville CC Red Ravens','coffeyvillecc','Coffeyville CC',NULL,NULL,NULL,NULL,'NJCAA','Kansas Jayhawk Community College Conference','Coffeyville CC','Coffeyville_CC',NULL),
('NJCAA','Kansas Jayhawk Community College Conference','Dodge City CC Conquistadors','dodgecitycc','Dodge City CC',NULL,NULL,NULL,NULL,'NJCAA','Kansas Jayhawk Community College Conference','Dodge City CC','Dodge_City_CC',NULL),
('NJCAA','Kansas Jayhawk Community College Conference','Fort Scott CC Greyhounds','fortscottcc','Fort Scott CC',NULL,NULL,NULL,NULL,'NJCAA','Kansas Jayhawk Community College Conference','Fort Scott CC','Fort_Scott_CC',NULL),
('NJCAA','Kansas Jayhawk Community College Conference','Garden City CC Broncbusters','gardencitycc','Garden City CC',NULL,NULL,NULL,NULL,'NJCAA','Kansas Jayhawk Community College Conference','Garden City CC','Garden_City_CC',NULL),
('NJCAA','Kansas Jayhawk Community College Conference','Highland CC Scotties','highlandcc','Highland CC',NULL,NULL,NULL,NULL,'NJCAA','Kansas Jayhawk Community College Conference','Highland CC','Highland_CC_KS',NULL),
('NJCAA','Kansas Jayhawk Community College Conference','Hutchinson CC Blue Dragons','hutchinsoncc','Hutchinson CC',NULL,NULL,NULL,NULL,'NJCAA','Kansas Jayhawk Community College Conference','Hutchinson CC','Hutchinson_CC',NULL),
('NJCAA','Kansas Jayhawk Community College Conference','Independence CC Pirates','independencecc','Independence CC',NULL,NULL,NULL,NULL,'NJCAA','Kansas Jayhawk Community College Conference','Independence CC','Independence_CC',NULL),
('NJCAA','MACJC','Coahoma CC Tigers','coahomacc','Coahoma CC',NULL,NULL,NULL,NULL,'NJCAA','MACJC','Coahoma CC','Coahoma_CC',NULL),
('NJCAA','MACJC','Copiah-Lincoln CC Wolfpack','copiahlincolncc','Copiah-Lincoln CC',NULL,NULL,NULL,NULL,'NJCAA','MACJC','Copiah-Lincoln CC','Copiah-Lincoln',NULL),
('NJCAA','MACJC','East Central CC Warriors','eastcentralcc','East Central CC',NULL,NULL,NULL,NULL,'NJCAA','MACJC','East Central CC','East_Central_CC',NULL),
('NJCAA','MACJC','East Mississippi CC Lions','eastmississippicc','East Mississippi CC',NULL,NULL,NULL,NULL,'NJCAA','MACJC','East Mississippi CC','E_Mississippi_CC',NULL),
('NJCAA','MACJC','Hinds CC Eagles','hinds','Hinds CC',NULL,NULL,NULL,NULL,'NJCAA','MACJC','Hinds CC','Hinds_CC',NULL),
('NJCAA','MACJC','Holmes CC Bulldogs','holmes','Holmes CC',NULL,NULL,NULL,NULL,'NJCAA','MACJC','Holmes CC','Holmes_CC',NULL),
('NJCAA','MACJC','Itawamba CC Indians','itawambacc','Itawamba CC',NULL,NULL,NULL,NULL,'NJCAA','MACJC','Itawamba CC','Itawamba_CC',NULL),
('NJCAA','MACJC','Jones County JC Bobcats','jonescountyjc','Jones County JC',NULL,NULL,NULL,NULL,'NJCAA','MACJC','Jones County JC','Jones_Col',NULL),
('NJCAA','MACJC','Mississippi Delta CC Trojans','mississippideltacc','Mississippi Delta CC',NULL,NULL,NULL,NULL,'NJCAA','MACJC','Mississippi Delta CC','MS_Delta',NULL),
('NJCAA','MACJC','Mississippi Gulf Coast CC Bulldogs','mississippigulfcoastcc','Mississippi Gulf Coast CC',NULL,NULL,NULL,NULL,'NJCAA','MACJC','Mississippi Gulf Coast CC','MS_Gulf_Coast',NULL),
('NJCAA','MACJC','Northeast Mississippi CC Tigers','northeastmississippicc','Northeast Mississippi CC',NULL,NULL,NULL,NULL,'NJCAA','MACJC','Northeast Mississippi CC','NE_MS_CC',NULL),
('NJCAA','MACJC','Northwest Mississippi CC Rangers','northwestmississippicc','Northwest Mississippi CC',NULL,NULL,NULL,NULL,'NJCAA','MACJC','Northwest Mississippi CC','NW_Mississippi',NULL),
('NJCAA','MACJC','Pearl River CC Wildcats','pearlrivercc','Pearl River CC',NULL,NULL,NULL,NULL,'NJCAA','MACJC','Pearl River CC','Pearl_River_CC',NULL),
('NJCAA','MACJC','Southwest Mississippi CC Bears','southwestmississippicc','Southwest Mississippi CC',NULL,NULL,NULL,NULL,'NJCAA','MACJC','Southwest Mississippi CC','SW_Mississippi',NULL),
('NJCAA','Minnesota College Athletic Conference','Central Lakes Raiders','centrallakes','Central Lakes',NULL,NULL,NULL,NULL,'NJCAA','Minnesota College Athletic Conference','Central Lakes','Central_Lakes',NULL),
('NJCAA','Minnesota College Athletic Conference','Dakota College Lumberjacks','dakotacollege','Dakota College',NULL,NULL,NULL,NULL,'NJCAA','Minnesota College Athletic Conference','Dakota College','Dakota-Bottineau',NULL),
('NJCAA','Minnesota College Athletic Conference','Fond du Lac Thunder','fonddulac','Fond du Lac',NULL,NULL,NULL,NULL,'NJCAA','Minnesota College Athletic Conference','Fond du Lac','Fond_du_Lac_T&CC',NULL),
('NJCAA','Minnesota College Athletic Conference','Itasca CC Vikings','itascacc','Itasca CC',NULL,NULL,NULL,NULL,'NJCAA','Minnesota College Athletic Conference','Itasca CC','Itasca_CC',NULL),
('NJCAA','Minnesota College Athletic Conference','Mesabi Range CTC Norse','mesabirangectc','Mesabi Range CTC',NULL,NULL,NULL,NULL,'NJCAA','Minnesota College Athletic Conference','Mesabi Range CTC','Mesabi_Range',NULL),
('NJCAA','Minnesota College Athletic Conference','Minnesota State CTC Spartans','minnesotastatectc','Minnesota State CTC',NULL,NULL,NULL,NULL,'NJCAA','Minnesota College Athletic Conference','Minnesota State CTC','MN_St_CTC',NULL),
('NJCAA','Minnesota College Athletic Conference','Minnesota West CTC Bluejays','minnesotawestctc','Minnesota West CTC',NULL,NULL,NULL,NULL,'NJCAA','Minnesota College Athletic Conference','Minnesota West CTC','MN_West_C&T',NULL),
('NJCAA','Minnesota College Athletic Conference','North Dakota Science Wildcats','northdakotascience','North Dakota Science',NULL,NULL,NULL,NULL,'NJCAA','Minnesota College Athletic Conference','North Dakota Science','ND_St_Science',NULL),
('NJCAA','Minnesota College Athletic Conference','Northland CTC Pioneers','northlandctc','Northland CTC',NULL,NULL,NULL,NULL,'NJCAA','Minnesota College Athletic Conference','Northland CTC','Northland_CTC',NULL),
('NJCAA','Minnesota College Athletic Conference','Ridgewater Warriors','ridgewater','Ridgewater',NULL,NULL,NULL,NULL,'NJCAA','Minnesota College Athletic Conference','Ridgewater','Ridgewater',NULL),
('NJCAA','Minnesota College Athletic Conference','Rochester CTC Yellowjackets','rochesterctc','Rochester CTC',NULL,NULL,NULL,NULL,'NJCAA','Minnesota College Athletic Conference','Rochester CTC','Rochester_C&T',NULL),
('NJCAA','Minnesota College Athletic Conference','Vermilion CC Ironmen','vermillion','Vermilion CC',NULL,NULL,NULL,NULL,'NJCAA','Minnesota College Athletic Conference','Vermilion CC','Vermilion_CC',NULL),
('NJCAA','NJCAA Independents','ASA Miami Silver Storm','asamiami','ASA Miami',NULL,NULL,NULL,NULL,'NJCAA','NJCAA Independents','ASA Miami','ASA_Miami',NULL),
('NJCAA','NJCAA Independents','Community Christian Lions','communitychristian','Community Christian',NULL,NULL,NULL,NULL,'NJCAA','NJCAA Independents','Community Christian','Community_Chr_MI',NULL),
('NJCAA','NJCAA Independents','DuPage Chaparrals','dupage','DuPage',NULL,NULL,NULL,NULL,'NJCAA','NJCAA Independents','DuPage','Col_of_Dupage',NULL),
('NJCAA','NJCAA Independents','Erie CC Kats','eriecc','Erie CC',NULL,NULL,NULL,NULL,'NJCAA','NJCAA Independents','Erie CC','Erie_CC',NULL),
('NJCAA','NJCAA Independents','Georgia Military Bulldogs','georgiamilitary','Georgia Military',NULL,NULL,NULL,NULL,'NJCAA','NJCAA Independents','Georgia Military','Georgia_Mil',NULL),
('NJCAA','NJCAA Independents','Hocking Hawks','hocking','Hocking',NULL,NULL,NULL,NULL,'NJCAA','NJCAA Independents','Hocking','Hocking',NULL),
('NJCAA','NJCAA Independents','Hudson Valley CC Vikings','hudsonvalleycc','Hudson Valley CC',NULL,NULL,NULL,NULL,'NJCAA','NJCAA Independents','Hudson Valley CC','Hudson_Val',NULL),
('NJCAA','NJCAA Independents','Louisburg Hurricanes','louisburg','Louisburg','Unknown','Unknown','Louisburg',NULL,'NJCAA','NJCAA Independents','Louisburg','Louisburg',NULL),
('NJCAA','NJCAA Independents','Nassau CC Lions','nassaucc','Nassau CC',NULL,NULL,NULL,NULL,'NJCAA','NJCAA Independents','Nassau CC','Nassau_CC',NULL),
('NJCAA','NJCAA Independents','Snow Badgers','snow','Snow',NULL,NULL,NULL,NULL,'NJCAA','NJCAA Independents','Snow','Snow_Col',NULL),
('NJCAA','NJCAA Independents','Sussex County CC Skylanders','sussexcountycc','Sussex County CC',NULL,NULL,NULL,NULL,'NJCAA','NJCAA Independents','Sussex County CC','Sussex_Co_CC',NULL),
('NJCAA','Northeast JC Football Conference','ASA Avengers','asa','ASA',NULL,NULL,NULL,NULL,'NJCAA','Northeast JC Football Conference','ASA','ASA',NULL),
('NJCAA','Northeast JC Football Conference','Lackawanna Falcons','lackawanna','Lackawanna',NULL,NULL,NULL,NULL,'NJCAA','Northeast JC Football Conference','Lackawanna','Lackawanna',NULL),
('NJCAA','Northeast JC Football Conference','Monroe Mustangs','monroe','Monroe',NULL,NULL,NULL,NULL,'NJCAA','Northeast JC Football Conference','Monroe','Monroe-NR',NULL),
('NJCAA','Southwest Junior College Football Conference','Blinn Buccaneers','blinn','Blinn',NULL,NULL,NULL,NULL,'NJCAA','Southwest Junior College Football Conference','Blinn','Blinn',NULL),
('NJCAA','Southwest Junior College Football Conference','Cisco Wranglers','cisco','Cisco',NULL,NULL,NULL,NULL,'NJCAA','Southwest Junior College Football Conference','Cisco','Cisco_JC',NULL),
('NJCAA','Southwest Junior College Football Conference','Kilgore Rangers','kilgore','Kilgore',NULL,NULL,NULL,NULL,'NJCAA','Southwest Junior College Football Conference','Kilgore','Kilgore',NULL),
('NJCAA','Southwest Junior College Football Conference','Navarro Bulldogs','navarro','Navarro',NULL,NULL,NULL,NULL,'NJCAA','Southwest Junior College Football Conference','Navarro','Navarro',NULL),
('NJCAA','Southwest Junior College Football Conference','New Mexico Military Broncos','newmexicomilitary','New Mexico Military','Unknown','Unknown','New Mexico Military',NULL,'NJCAA','Southwest Junior College Football Conference','New Mexico Military','NM_Military',NULL),
('NJCAA','Southwest Junior College Football Conference','Northeastern Oklahoma A&M Golden Norsemen','northeasternoklahomaam','Northeastern Oklahoma A&M',NULL,NULL,NULL,NULL,'NJCAA','Southwest Junior College Football Conference','Northeastern Oklahoma A&M','NE_OK_A&M',NULL),
('NJCAA','Southwest Junior College Football Conference','Trinity Valley CC Cardinals','trinityvalleycc','Trinity Valley CC',NULL,NULL,NULL,NULL,'NJCAA','Southwest Junior College Football Conference','Trinity Valley CC','Trinity_Valley_CC',NULL),
('NJCAA','Southwest Junior College Football Conference','Tyler JC Apaches','tylerjc','Tyler JC',NULL,NULL,NULL,NULL,'NJCAA','Southwest Junior College Football Conference','Tyler JC','Tyler_JC',NULL),
('Club','CSFL','Mansfield Mountaineers','mansfield','Mansfield','Unknown','Unknown','Mansfield',NULL,'Other','CSFL','Mansfield','Mansfield',NULL),
('Club','NCFA','Central Georgia Tech Titans','centralgeorgiatech','Central Georgia Tech',NULL,NULL,NULL,NULL,NULL,'Unknown','Unknown','Central Georgia Tech','Cent_Georgia_Tech'),
('Club','NCFA','George Mason Patriots','georgemason','George Mason','Unknown','Unknown','George Mason',NULL,'Other','NCFA','George Mason','George_Mason',NULL),
('Club','NCFA','Middle Georgia State Knights','middlegeorgiastate','Middle Georgia State',NULL,NULL,NULL,NULL,'Other','NCFA','Middle Georgia State','Mid_Georgia',NULL),
('Other','AIFC','APA Panthers','apa','APA',NULL,NULL,NULL,NULL,'Other','AIFC','APA',NULL,NULL),
('Other','AIFC','Atlanta Sports Academy Spartans','atlantasportsacademy','Atlanta Sports Academy',NULL,NULL,NULL,NULL,'Other','AIFC','Atlanta Sports Academy',NULL,NULL),
('Other','AIFC','Elite One Academy Lions','eliteoneacademy','Elite One Academy',NULL,NULL,NULL,NULL,'Other','AIFC','Elite One Academy',NULL,NULL),
('Other','AIFC','Littlejohn Sports Academy Ravens','littlejohnsportsacademy','Littlejohn Sports Academy',NULL,NULL,NULL,NULL,'Other','AIFC','Littlejohn Sports Academy',NULL,NULL),
('Other','AIFC','Port City Ocean Crusaders','portcity','Port City',NULL,NULL,NULL,NULL,'Other','AIFC','Port City',NULL,NULL),
('Other','AIFC','University of God''s Chosen Disciples','universitygodschosen','University of God''s Chosen','Unknown','Unknown','University of God''s Chosen',NULL,'Other','AIFC','University of God''s Chosen',NULL,NULL),
('Other','EAC','Alabama Prep-Birmingham Cardinals','alabamaprep','Alabama-Prep Birmingham',NULL,NULL,NULL,NULL,'Other','EAC','Alabama-Prep Birmingham',NULL,NULL),
('Other','EAC','APSA Bearcats','apsa','APSA',NULL,NULL,NULL,NULL,'Other','EAC','APSA',NULL,NULL),
('Other','EAC','Gattaca Florida Hurricanes','gattacaflorida','Gattaca Florida',NULL,NULL,NULL,NULL,'Other','EAC','Gattaca Florida',NULL,NULL),
('Other','EAC','GCPSA Sharks','gcpsa','GCSPA',NULL,NULL,NULL,NULL,'Other','EAC','GCSPA',NULL,NULL),
('Other','EAC','Georgia Prep SA Lions','georgiaprepsa','Georgia Prep SA',NULL,NULL,NULL,NULL,'Other','EAC','Georgia Prep SA',NULL,NULL),
('Other','EAC','North Georgia SA Mountaineers','northgeorgiasa','North Georgia SA',NULL,NULL,NULL,NULL,'Other','EAC','North Georgia SA',NULL,NULL),
('Other','EAC','OC Tech Gladiators','octech','OC Tech',NULL,NULL,NULL,NULL,'Other','EAC','OC Tech',NULL,NULL),
('Other','EAC','Palmetto Prep Minutemen','palmettoprep','Palmetto Prep',NULL,NULL,NULL,NULL,'Other','EAC','Palmetto Prep',NULL,NULL),
('Other','HJCAC','Gila River Hawks','gilariver','Gila River',NULL,NULL,NULL,NULL,'Other','HJCAC','Gila River','Gila_River',NULL),
('Other','HJCAC','Maricopa Mustangs','maricopa','Maricopa',NULL,NULL,NULL,NULL,'Other','HJCAC','Maricopa','Maricopa',NULL),
('Other','HJCAC','Papago Pumas','papago','Papago',NULL,NULL,NULL,NULL,'Other','HJCAC','Papago','Papago',NULL),
('Other','HJCAC','Salt River Scorpions','saltriver','Salt River',NULL,NULL,NULL,NULL,'Other','HJCAC','Salt River','Salt_River',NULL),
('Other','HJCAC','Sonoran Sidewinders','sonoran','Sonoran',NULL,NULL,NULL,NULL,'Other','HJCAC','Sonoran','Sonoran',NULL),
('Other','NCAU','Blue Lights Triumphant Thoroughbreds','bluelights','Blue Lights',NULL,NULL,NULL,NULL,'Other','NCAU','Blue Lights',NULL,NULL),
('Other','NCAU','College of Faith (AR) Warriors','collegeoffaithar','College of Faith (AR)',NULL,NULL,NULL,NULL,'Other','NCAU','College of Faith (AR)','Col_of_Faith_AR',NULL),
('Other','NCAU','College of Faith (NC) Saints','collegeoffaith','College of Faith (NC)',NULL,NULL,NULL,NULL,'Other','NCAU','College of Faith (NC)','Col_of_Faith_NC',NULL),
('Other','NCAU','Haywood Crusaders','haywood','Haywood',NULL,NULL,NULL,NULL,'Other','NCAU','Haywood',NULL,NULL),
('Other','NCAU','Ramah Rams','ramah','Ramah',NULL,NULL,NULL,NULL,'Other','NCAU','Ramah',NULL,NULL),
('Other','NCAU','Southern Sports Academy Panthers','southernsportsacademy','Southern Sports Academy',NULL,NULL,NULL,NULL,'Other','NCAU','Southern Sports Academy',NULL,NULL),
('Other','NCAU','University of Faith (FL) Glory Eagles','universityoffaith','University of Faith (FL)',NULL,NULL,NULL,NULL,'Other','NCAU','University of Faith (FL)','Faith_FL',NULL),
('Other','NCAU','University of Faith (OK) Kings','universityfaithok','University of Faith (OK)',NULL,NULL,NULL,NULL,'Other','NCAU','University of Faith (OK)',NULL,NULL),
('Other','NCAU','Virginia A&M Gators','hamptonroads','Virginia A&M Gators',NULL,NULL,NULL,NULL,'Other','NCAU','Virginia A&M Gators',NULL,NULL),
('Other','NWJCFL','Central Sound Warhawks','centralsoundjc','Central Sound',NULL,NULL,NULL,NULL,'Other','NWJCFL','Central Sound',NULL,NULL),
('Other','NWJCFL','Eastside JC Bulldogs','eastsidejc','Eastside JC',NULL,NULL,NULL,NULL,'Other','NWJCFL','Eastside JC',NULL,NULL),
('Other','NWJCFL','Everett Red Raiders','everett','Everett',NULL,NULL,NULL,NULL,'Other','NWJCFL','Everett',NULL,NULL),
('Other','NWJCFL','Lewis and Clark Valley Loggers','lewisclarkvalley','Lewis and Clark Valley',NULL,NULL,NULL,NULL,'Other','NWJCFL','Lewis and Clark Valley','Lewis-Clark_ID',NULL),
('Other','UTFL','Salt Lake CC Bruins','slcc','Salt Lake CC',NULL,NULL,NULL,NULL,'Other','UTFL','Salt Lake CC',NULL,NULL),
('Other','ICAA','Atlantis Atlanteans','atlantis','Atlantis',NULL,NULL,NULL,NULL,'Other','Independent','Atlantis','Atlantis',NULL),
('Other','ICAA','Fort Lauderdale Eagles','fortlauderdale','Fort Lauderdale','Unknown','Unknown','UFTL',NULL,'Other','Independent','Fort Lauderdale','Ft_Lauderdale',NULL),
('Other','ICAA','McDougle Tech Bison','mcdougletech','McDougle Tech',NULL,NULL,NULL,NULL,'Other','Independent','McDougle Tech','McDougle_Tech',NULL),
('Other','Independent','Apprentice Ship Builders','apprentice','Apprentice','iii','Independent DIII','Apprentice School',NULL,'Other','Independent','Apprentice','Apprentice',NULL),
('Other','Independent','Central International Cardinals','centralinternational','Central International',NULL,NULL,NULL,NULL,'Other','Independent','Central International',NULL,NULL),
('Other','Independent','Clinton Golden Bears','clinton','Clinton',NULL,NULL,NULL,NULL,'Other','Independent','Clinton',NULL,NULL),
('Other','Independent','DC Metro Wolves','dcmetro','DC Metro',NULL,NULL,NULL,NULL,'Other','Independent','DC Metro',NULL,NULL),
('Other','Independent','Delaware Tech CC Gamecocks','delawaretechcc','Delaware Tech CC',NULL,NULL,NULL,NULL,'Other','Independent','Delaware Tech CC',NULL,NULL),
('Other','Independent','Fork Union Military Academy','forkunion','Fork Union','Unknown','Unknown','Fork Union',NULL,'Other','Independent','Fork Union',NULL,NULL),
('Other','Independent','Glove Prep Vikings','gloveprep','Glove Prep',NULL,NULL,NULL,NULL,'Other','Independent','Glove Prep',NULL,NULL),
('Other','Independent','Gordon’s Fine Arts & Sports Panthers','gordonfinearts','Gordon’s Fine Arts & Sports',NULL,NULL,NULL,NULL,'Other','Independent','Gordon’s Fine Arts & Sports',NULL,NULL),
('Other','Independent','Jersey Coast Academy Jaguars','jerseycoast','Jersey Coast Academy',NULL,NULL,NULL,NULL,'Other','Independent','Jersey Coast Academy',NULL,NULL),
('Other','Independent','Lincoln (CA) Oaklanders','lincolnca','Lincoln (CA)','ii','Independent DII','Lincoln (CA)','Lincoln University (CA)','Other','Independent','Lincoln (CA)','Lincoln_CA',NULL),
('Other','Independent','Redemption Dragon Slayers','redemption','Redemption',NULL,NULL,NULL,NULL,'Other','Independent','Redemption',NULL,NULL),
('Other','Independent','Redemption Academy Dragons','redemptionacademy','Redemption Academy',NULL,NULL,NULL,NULL,'Other','Independent','Redemption Academy',NULL,NULL),
('Other','Independent','Texas A&T Drillers','texasat','Texas A&T',NULL,NULL,NULL,NULL,'Other','Independent','Texas A&T','Texas_A&T',NULL),
('Other','Independent','Thaddeus Stevens Bulldogs','thaddeusstevens','Thaddeus Stevens','Unknown','Unknown','Thaddeus Stevens',NULL,'Other','Independent','Thaddeus Stevens','Stevens',NULL),
('Other','Independent','Valley Forge MA&C Trojans','valleyforgemac','Valley Forge MA&C',NULL,NULL,NULL,NULL,'Other','Independent','Valley Forge MA&C','Val_Forge_Mil',NULL),
('Other','Independent','Virginia-Lynchburg Dragons','virginialynchburg','Virginia-Lynchburg','Unknown','Unknown','Virginia Lynchburg','Virginia University Of Lynchburg','Other','Independent','Virginia-Lynchburg','VA-Lynchburg',NULL),
('Other','Independent','Williamson Mechanics','williamson','Williamson',NULL,NULL,NULL,NULL,'Other','Independent','Williamson','Williamson_Tr',NULL),
('Other','Independent','Zoubida Cole Jaguars','zoubidacole','Zoubida Cole',NULL,NULL,NULL,NULL,'Other','Independent','Zoubida Cole',NULL,NULL),
('Canada','Atlantic University Football Conference','Acadia Axemen','acadia','Acadia',NULL,NULL,NULL,NULL,'Canada','Atlantic University Football Conference','Acadia','Acadia',NULL),
('Canada','Atlantic University Football Conference','Bishop''s University Gaiters','bishops','Bishop''s University',NULL,NULL,NULL,NULL,'Canada','Atlantic University Football Conference','Bishop''s University','Bishop''s',NULL),
('Canada','Atlantic University Football Conference','Mount Allison Mounties','mountallison','Mount Allison',NULL,NULL,NULL,NULL,'Canada','Atlantic University Football Conference','Mount Allison','Mt_Allison',NULL),
('Canada','Atlantic University Football Conference','St. Francis Xavier X-Men','stfrancisxavier','St. Francis Xavier',NULL,NULL,NULL,NULL,'Canada','Atlantic University Football Conference','St. Francis Xavier','St_Fran_Xavier',NULL),
('Canada','Atlantic University Football Conference','St. Mary''s (NS) Huskies','saintmarys','St. Mary''s (NS)',NULL,NULL,NULL,NULL,'Canada','Atlantic University Football Conference','St. Mary''s (NS)','St_Mary''s_NS',NULL),
('Canada','Canada West Football Conference','Alberta Golden Bears','alberta','Alberta',NULL,NULL,NULL,NULL,'Canada','Canada West Football Conference','Alberta','Alberta',NULL),
('Canada','Canada West Football Conference','Calgary Dinos','calgary','Calgary',NULL,NULL,NULL,NULL,'Canada','Canada West Football Conference','Calgary','Calgary',NULL),
('Canada','Canada West Football Conference','Manitoba Bisons','manitoba','Manitoba','Unknown','Unknown','Manitoba',NULL,'Canada','Canada West Football Conference','Manitoba','Manitoba',NULL),
('Canada','Canada West Football Conference','Regina Rams','regina','Regina',NULL,NULL,NULL,NULL,'Canada','Canada West Football Conference','Regina','Regina',NULL),
('Canada','Canada West Football Conference','Saskatchewan Huskies','saskatchewan','Saskatchewan',NULL,NULL,NULL,NULL,'Canada','Canada West Football Conference','Saskatchewan','Saskatchewan',NULL),
('Canada','Canada West Football Conference','UBC Thunderbirds','ubc','UBC',NULL,NULL,NULL,NULL,'Canada','Canada West Football Conference','UBC','Brit_Columbia',NULL),
('Canada','Ontario University Athletics','Carleton (ON) Ravens','carletonca','Carleton (ON)',NULL,NULL,NULL,NULL,'Canada','Ontario University Athletics','Carleton (ON)','Carleton_ON',NULL),
('Canada','Ontario University Athletics','Guelph Gryphons','guelph','Guelph',NULL,NULL,NULL,NULL,'Canada','Ontario University Athletics','Guelph','Guelph',NULL),
('Canada','Ontario University Athletics','McMaster Marauders','mcmaster','McMaster',NULL,NULL,NULL,NULL,'Canada','Ontario University Athletics','McMaster','McMaster',NULL),
('Canada','Ontario University Athletics','Ottawa (ON) Gee-Gees','uottawa','Ottawa (ON)',NULL,NULL,NULL,NULL,'Canada','Ontario University Athletics','Ottawa (ON)','Ottawa_ON',NULL),
('Canada','Ontario University Athletics','Queen''s University Gaels','queens','Queen''s University',NULL,NULL,NULL,NULL,'Canada','Ontario University Athletics','Queen''s University','Queen''s_ON',NULL),
('Canada','Ontario University Athletics','Toronto Varsity Blues','toronto','Toronto',NULL,NULL,NULL,NULL,'Canada','Ontario University Athletics','Toronto','Toronto',NULL),
('Canada','Ontario University Athletics','Waterloo Warriors','waterloo','Waterloo',NULL,NULL,NULL,NULL,'Canada','Ontario University Athletics','Waterloo','Waterloo',NULL),
('Canada','Ontario University Athletics','Western Ontario Mustangs','westernontario','Western Ontario','Unknown','Unknown','Western Ontario',NULL,'Canada','Ontario University Athletics','Western Ontario','Western_ON',NULL),
('Canada','Ontario University Athletics','Wilfrid Laurier Golden Hawks','wilfridlaurier','Wilfrid Laurier',NULL,NULL,NULL,NULL,'Canada','Ontario University Athletics','Wilfrid Laurier','Laurier',NULL),
('Canada','Ontario University Athletics','Windsor Lancers','windsor','Windsor',NULL,NULL,NULL,NULL,'Canada','Ontario University Athletics','Windsor','Windsor',NULL),
('Canada','Ontario University Athletics','York (ON) Lions','york','York (ON)',NULL,NULL,NULL,NULL,'Canada','Ontario University Athletics','York (ON)','York_ON',NULL),
('Canada','RSEQ','Concordia (QC) Stingers','concordiaca','Concordia (QC)',NULL,NULL,NULL,NULL,'Canada','RSEQ','Concordia (QC)','Concordia_QC',NULL),
('Canada','RSEQ','Laval Rouge et Or','laval','Laval',NULL,NULL,NULL,NULL,'Canada','RSEQ','Laval','Laval',NULL),
('Canada','RSEQ','McGill Redbirds','mcgill','McGill','Unknown','Unknown','McGill',NULL,'Canada','RSEQ','McGill','McGill',NULL),
('Canada','RSEQ','Montréal Carabins','montreal','Montréal',NULL,NULL,NULL,NULL,'Canada','RSEQ','Montréal','Montreal',NULL),
('Canada','RSEQ','Sherbrooke Vert et Or','sherbrooke','Sherbrooke',NULL,NULL,NULL,NULL,'Canada','RSEQ','Sherbrooke','Col_Sherbrooke',NULL),
('Mexico','CONADEIP','Zorros CETYS Mexicali','cetysmexicali','CETYS Mexicali',NULL,NULL,NULL,NULL,'Mexico','CONADEIP','CETYS Mexicali','CETYS_Mexicali',NULL),
('Mexico','CONADEIP','Zorros CETYS Tijuana','cetystijuana','CETYS Tijuana',NULL,NULL,NULL,NULL,'Mexico','CONADEIP','CETYS Tijuana','CETYS_Tijuana',NULL),
('Mexico','CONADEIP','Borregos Guadalajara','guadalajara','Guadalajara',NULL,NULL,NULL,NULL,'Mexico','CONADEIP','Guadalajara','Guadalajara',NULL),
('Mexico','CONADEIP','Potros ITSON Obregón','itson','ITSON Obregón',NULL,NULL,NULL,NULL,'Mexico','CONADEIP','ITSON Obregón','Obregon',NULL),
('Mexico','CONADEIP','Borregos México','cem','México',NULL,NULL,NULL,NULL,'Mexico','CONADEIP','México','ITESM_Mexico',NULL),
('Mexico','CONADEIP','Borregos Monterrey','monterrey','Monterrey',NULL,NULL,NULL,NULL,'Mexico','CONADEIP','Monterrey','Monterrey',NULL),
('Mexico','CONADEIP','Borregos Puebla','puebla','Puebla',NULL,NULL,NULL,NULL,'Mexico','CONADEIP','Puebla','ITESM_Puebla',NULL),
('Mexico','CONADEIP','Borregos Querétaro','queretaro','Querétaro',NULL,NULL,NULL,NULL,'Mexico','CONADEIP','Querétaro','Queretaro',NULL),
('Mexico','CONADEIP','Borregos Toluca','toluca','Toluca',NULL,NULL,NULL,NULL,'Mexico','CONADEIP','Toluca','Toluca',NULL),
('Mexico','CONADEIP','Cimarrones UABC Tijuana','tijuana','UABC Tijuana',NULL,NULL,NULL,NULL,'Mexico','CONADEIP','UABC Tijuana','Tijuana',NULL),
('Mexico','CONADEIP','Aztecas UDLAP','udlap','UDLAP',NULL,NULL,NULL,NULL,'Mexico','CONADEIP','UDLAP','UDLA_Puebla',NULL),
('Mexico','CONADEIP','Coyotes UT Hermosillo','uthermosillo','UT Hermosillo',NULL,NULL,NULL,NULL,'Mexico','CONADEIP','UT Hermosillo','Coyotes_UTH',NULL),
('Mexico','ONEFA','Lobos BUAP','buap','BUAP',NULL,NULL,NULL,NULL,'Mexico','ONEFA','BUAP','Lobos_BUAP',NULL),
('Mexico','ONEFA','Centinelas CGP','cgpresidenciales','CGP',NULL,NULL,NULL,NULL,'Mexico','ONEFA','CGP','Centinelas_CGP',NULL),
('Mexico','ONEFA','Pumas CU UNAM','unam','CU UNAM',NULL,NULL,NULL,NULL,'Mexico','ONEFA','CU UNAM','Pumas_CU_UNAM',NULL),
('Mexico','ONEFA','Águilas Blancas IPN','ipnsantotomas','IPN',NULL,NULL,NULL,NULL,'Mexico','ONEFA','IPN','Aguilas_Blancas_IPN',NULL),
('Mexico','ONEFA','Burros Blancos IPN','ipnzacatenco','IPN',NULL,NULL,NULL,NULL,'Mexico','ONEFA','IPN','Burros_Blancos_IPN',NULL),
('Mexico','ONEFA','Tlahuicas Morelos','morelos','Morelos',NULL,NULL,NULL,NULL,'Mexico','ONEFA','Morelos','Tlahuicas',NULL),
('Mexico','ONEFA','Frailes Tepeyac','tepeyac','Tepeyac',NULL,NULL,NULL,NULL,'Mexico','ONEFA','Tepeyac','Frailes_UT',NULL),
('Mexico','ONEFA','Leones UACan','anahuaccancun','UACan',NULL,NULL,NULL,NULL,'Mexico','ONEFA','UACan','Leones_UA-Cancun',NULL),
('Mexico','ONEFA','Lobos UAdeC','uadec','UAdeC',NULL,NULL,NULL,NULL,'Mexico','ONEFA','UAdeC','Lobos_UAC',NULL),
('Mexico','ONEFA','Potros Salvajes UAEM','uaem','UAEM',NULL,NULL,NULL,NULL,'Mexico','ONEFA','UAEM','Potros_Salvajes',NULL),
('Mexico','ONEFA','Tecos UAG','uag','UAG',NULL,NULL,NULL,NULL,'Mexico','ONEFA','UAG','Tecos_UAG',NULL),
('Mexico','ONEFA','Leones UAMN','uamn','UAMN',NULL,NULL,NULL,NULL,'Mexico','ONEFA','UAMN',NULL,NULL),
('Mexico','ONEFA','Auténticos Tigres UANL','uanl','UANL',NULL,NULL,NULL,NULL,'Mexico','ONEFA','UANL','Autenticos_Tigres',NULL),
('Mexico','ONEFA','Leones UAQro','uaqro','UAQro',NULL,NULL,NULL,NULL,'Mexico','ONEFA','UAQro','Leones_UA-Queretaro',NULL),
('Mexico','ONEFA','Correcaminos UAT Reynosa','uatreynosa','UAT Reynosa',NULL,NULL,NULL,NULL,'Mexico','ONEFA','UAT Reynosa','UAT_Reynosa',NULL),
('Mexico','ONEFA','Correcaminos UAT Victoria','uatvictoria','UAT Victoria',NULL,NULL,NULL,NULL,'Mexico','ONEFA','UAT Victoria','UAT_Victoria',NULL),
('Mexico','ONEFA','Leones Negros UDG','udg','UDG',NULL,NULL,NULL,NULL,'Mexico','ONEFA','UDG','Leones_Negros_UdeG',NULL),
('Mexico','ONEFA','Pumas Acatlán UNAM','unamacatlan','UNAM',NULL,NULL,NULL,NULL,'Mexico','ONEFA','UNAM','Pumas_Acatlan',NULL),
('Mexico','ONEFA','Halcones UV','veracruzana','UV',NULL,NULL,NULL,NULL,'Mexico','ONEFA','UV','Halcones_UV',NULL),
('Mexico','ONEFA','Linces UVM Lomas Verdes','lomasverdes','UVM Lomas Verdes',NULL,NULL,NULL,NULL,'Mexico','ONEFA','UVM Lomas Verdes','Linces_UVM',NULL),
('Discontinued USA','Discontinued D1','Boston University Terriers','bostonuniversity','Boston University','Unknown','Unknown','Boston University',NULL,'Discontinued Teams','D1 Discontinued','Boston University','Boston_Univ',NULL),
('Discontinued USA','Discontinued D1','Canisius Golden Griffins','canisius','Canisius','Unknown','Unknown','Canisius',NULL,'Discontinued Teams','D1 Discontinued','Canisius','Canisius',NULL),
('Discontinued USA','Discontinued D1','Evansville Purple Aces','evansville','Evansville','Unknown','Unknown','Evansville',NULL,'Discontinued Teams','D1 Discontinued','Evansville','Evansville',NULL),
('Discontinued USA','Discontinued D1','Fairfield Stags','fairfield','Fairfield','Unknown','Unknown','Fairfield',NULL,'Discontinued Teams','D1 Discontinued','Fairfield','Fairfield',NULL),
('Discontinued USA','Discontinued D1','Hofstra Pride','hofstra','Hofstra','Unknown','Unknown','Hofstra',NULL,'Discontinued Teams','D1 Discontinued','Hofstra','Hofstra',NULL),
('Discontinued USA','Discontinued D1','Iona Gaels','iona','Iona','Unknown','Unknown','Iona',NULL,'Discontinued Teams','D1 Discontinued','Iona','Iona',NULL),
('Discontinued USA','Discontinued D1','Jacksonville Dolphins','jacksonville','Jacksonville','Unknown','Unknown','Jacksonville',NULL,'Discontinued Teams','D1 Discontinued','Jacksonville','Jacksonville',NULL),
('Discontinued USA','Discontinued D1','La Salle Explorers','lasalle','La Salle','Unknown','Unknown','La Salle',NULL,'Discontinued Teams','D1 Discontinued','La Salle','La_Salle',NULL),
('Discontinued USA','Discontinued D1','Marquette Golden Eagles','marquette','Marquette','Unknown','Unknown','Marquette',NULL,'Discontinued Teams','D1 Discontinued','Marquette','Marquette',NULL),
('Discontinued USA','Discontinued D1','Northeastern Huskies','northeastern','Northeastern','Unknown','Unknown','Northeastern',NULL,'Discontinued Teams','D1 Discontinued','Northeastern','Northeastern',NULL),
('Discontinued USA','Discontinued D1','Pacific Tigers','pacific','Pacific','Unknown','Unknown','Pacific',NULL,'Discontinued Teams','D1 Discontinued','Pacific','Pacific',NULL),
('Discontinued USA','Discontinued D1','Siena Saints','siena','Siena','Unknown','Unknown','Siena',NULL,'Discontinued Teams','D1 Discontinued','Siena','Siena',NULL),
('Discontinued USA','Discontinued D1','St. John''s (NY) Red Storm','stjohnsny','St. John''s (NY)',NULL,NULL,NULL,NULL,'Discontinued Teams','D1 Discontinued','St. John''s (NY)','St_John''s',NULL),
('Discontinued USA','Discontinued D1','St. Mary''s (CA) Gaels','stmarys','St. Mary''s (CA)','Unknown','Unknown','St. Mary''s (CA)',NULL,'Discontinued Teams','D1 Discontinued','St. Mary''s (CA)','St_Mary''s_CA',NULL),
('Discontinued USA','Discontinued D1','St. Peter''s Peacocks','stpeters','St. Peter''s','Unknown','Unknown','St. Peter''s',NULL,'Discontinued Teams','D1 Discontinued','St. Peter''s','St_Peter''s',NULL),
('Discontinued USA','Discontinued NCAA','Alderson Broaddus Battlers','aldersonbroaddus','Alderson Broaddus','ii','Mountain East','Alderson-Broaddus',NULL,'D2','Mountain East','Alderson Broaddus','Ald-Broaddus',NULL),
('Discontinued USA','Discontinued NCAA','Azusa Pacific Cougars','azusapacific','Azusa Pacific','ii','Great Northwest','Azusa Pacific',NULL,'Discontinued Teams','NCAA Discontinued','Azusa Pacific','Azusa_Pacific',NULL),
('Discontinued USA','Discontinued NCAA','Bacone Warriors','bacone','Bacone',NULL,NULL,NULL,NULL,'Discontinued Teams','NCAA Discontinued','Bacone','Bacone',NULL),
('Discontinued USA','Discontinued NCAA','Barber-Scotia Sabers','barberscotia','Barber-Scotia',NULL,NULL,NULL,NULL,'Discontinued Teams','NCAA Discontinued','Barber-Scotia',NULL,NULL),
('Discontinued USA','Discontinued NCAA','Becker Hawks','becker','Becker',NULL,NULL,NULL,NULL,'Discontinued Teams','NCAA Discontinued','Becker','Becker',NULL),
('Discontinued USA','Discontinued NCAA','Birmingham-Southern Panthers','birminghamsouthern','Birmingham-Southern','iii','Southern Athletic','Birmingham-Southern',NULL,'Discontinued Teams','NCAA Discontinued','Birmingham-Southern','Birmingham_So',NULL),
('Discontinued USA','Discontinued NCAA','Blackburn Beavers','blackburn','Blackburn','Unknown','Unknown','Blackburn',NULL,'Discontinued Teams','NCAA Discontinued','Blackburn','Blackburn',NULL),
('Discontinued USA','Discontinued NCAA','Cheyney Wolves','cheyney','Cheyney','ii','Pennsylvania State Athletic','Cheyney',NULL,'Discontinued Teams','NCAA Discontinued','Cheyney','Cheyney_St',NULL),
('Discontinued USA','Discontinued NCAA','Chico State Wildcats','chicostate','Chico State',NULL,NULL,NULL,NULL,'Discontinued Teams','NCAA Discontinued','Chico State','CS_Chico',NULL),
('Discontinued USA','Discontinued NCAA','Cincinnati Christian Eagles','cincinnatichristian','Cincinnati Christian','Unknown','Unknown','Cincinnati Christian',NULL,'Discontinued Teams','NCAA Discontinued','Cincinnati Christian','Cincinnati_Chr',NULL),
('Discontinued USA','Discontinued NCAA','Colorado College Tigers','coloradocollege','Colorado College','Unknown','Unknown','Colorado College',NULL,'Discontinued Teams','NCAA Discontinued','Colorado College','Colorado_Col',NULL),
('Discontinued USA','Discontinued NCAA','Dana Vikings','dana','Dana',NULL,NULL,NULL,NULL,'Discontinued Teams','Non-NCAA Discontinued','Dana','Dana',NULL),
('Discontinued USA','Discontinued NCAA','Earlham Quakers','earlham','Earlham','Unknown','Unknown','Earlham',NULL,'Discontinued Teams','NCAA Discontinued','Earlham','Earlham',NULL),
('Discontinued USA','Discontinued NCAA','Finlandia Lions','finlandia','Finlandia','iii','Upper Midwest','Finlandia University',NULL,'Discontinued Teams','NCAA Discontinued','Finlandia','Finlandia',NULL),
('Discontinued USA','Discontinued NCAA','Florida Tech Panthers','floridatech','Florida Tech','Unknown','Unknown','Florida Tech',NULL,'Discontinued Teams','NCAA Discontinued','Florida Tech','Florida_Tech',NULL),
('Discontinued USA','Discontinued NCAA','Haskell Indians','haskell','Haskell','Unknown','Unknown','Haskell',NULL,'Discontinued Teams','NCAA Discontinued','Haskell','Haskell',NULL),
('Discontinued USA','Discontinued NCAA','Knoxville Bulldogs','knoxville','Knoxville','Unknown','Unknown','Knoxville',NULL,'Discontinued Teams','NCAA Discontinued','Knoxville','Knoxville_Col',NULL),
('Discontinued USA','Discontinued NCAA','Lambuth Eagles','lambuth','Lambuth','Unknown','Unknown','Lambuth',NULL,'Discontinued Teams','NCAA Discontinued','Lambuth','Lambuth',NULL),
('Discontinued USA','Discontinued NCAA','Lindenwood-Belleville Lynx','lindenwoodbelleville','Lindenwood-Belleville',NULL,NULL,NULL,NULL,'Discontinued Teams','NCAA Discontinued','Lindenwood-Belleville','Lindenwood-Belle',NULL),
('Discontinued USA','Discontinued NCAA','MacMurray Highlanders','macmurray','MacMurray',NULL,NULL,NULL,NULL,'Discontinued Teams','NCAA Discontinued','MacMurray','MacMurray',NULL),
('Discontinued USA','Discontinued NCAA','Malone Pioneers','malone','Malone','Unknown','Unknown','Malone',NULL,'Discontinued Teams','NCAA Discontinued','Malone','Malone',NULL),
('Discontinued USA','Discontinued NCAA','Maranatha Baptist Sabercats','maranathabaptist','Maranatha Baptist',NULL,NULL,NULL,NULL,'Discontinued Teams','NCAA Discontinued','Maranatha Baptist','Maranatha_Bap',NULL),
('Discontinued USA','Discontinued NCAA','Menlo Oaks','menlo','Menlo','Unknown','Unknown','Menlo',NULL,'Discontinued Teams','NCAA Discontinued','Menlo','Menlo',NULL),
('Discontinued USA','Discontinued NCAA','Minnesota-Crookston Golden Eagles','minnesotacrookston','Minnesota-Crookston','Unknown','Unknown','Minnesota-Crookston',NULL,'Discontinued Teams','NCAA Discontinued','Minnesota-Crookston','MN_Crookston',NULL),
('Discontinued USA','Discontinued NCAA','Morris Brown Wolverines','morrisbrown','Morris Brown','Unknown','Unknown','Morris Brown',NULL,'Discontinued Teams','NCAA Discontinued','Morris Brown','Morris_Brown',NULL),
('Discontinued USA','Discontinued NCAA','Mount Ida Mustangs','mountida','Mount Ida','iii','ECFC','Mount Ida College',NULL,'Discontinued Teams','NCAA Discontinued','Mount Ida','Mt_Ida',NULL),
('Discontinued USA','Discontinued NCAA','Mount Scenario Fighting Saints','mountscenario','Mount Scenario',NULL,NULL,NULL,NULL,'Discontinued Teams','NCAA Discontinued','Mount Scenario','Mt_Senario',NULL),
('Discontinued USA','Discontinued NCAA','New Jersey City Gothic Knights','newjerseycity','New Jersey City',NULL,NULL,NULL,NULL,'Discontinued Teams','NCAA Discontinued','New Jersey City','NJ_City',NULL),
('Discontinued USA','Discontinued NCAA','Notre Dame (OH) Falcons','notredameoh','Notre Dame (OH)','ii','Mountain East','Notre Dame College',NULL,'Discontinued Teams','NCAA Discontinued','Notre Dame (OH)','Notre_Dame_OH',NULL),
('Discontinued USA','Discontinued NCAA','Occidental Tigers','occidental','Occidental','iii','So. Cal.','Occidental',NULL,'Discontinued Teams','NCAA Discontinued','Occidental','Occidental',NULL),
('Discontinued USA','Discontinued NCAA','Omaha Mavericks','nebraskaomaha','Omaha',NULL,NULL,NULL,NULL,'Discontinued Teams','NCAA Discontinued','Omaha','NE_Omaha',NULL),
('Discontinued USA','Discontinued NCAA','Paine Lions','paine','Paine','Unknown','Unknown','Paine',NULL,'Discontinued Teams','NCAA Discontinued','Paine','Paine',NULL),
('Discontinued USA','Discontinued NCAA','Paul Quinn Tigers','paulquinn','Paul Quinn',NULL,NULL,NULL,NULL,'Discontinued Teams','NCAA Discontinued','Paul Quinn','Paul_Quinn',NULL),
('Discontinued USA','Discontinued NCAA','Principia Panthers','principia','Principia',NULL,NULL,NULL,NULL,'Discontinued Teams','NCAA Discontinued','Principia','Principia',NULL),
('Discontinued USA','Discontinued NCAA','Si Tanka Eagles','sitanka','Si Tanka',NULL,NULL,NULL,NULL,'Discontinued Teams','NCAA Discontinued','Si Tanka','Huron',NULL),
('Discontinued USA','Discontinued NCAA','Simon Fraser Red Leafs','simonfraser','Simon Fraser','ii','Lone Star','Simon Fraser',NULL,'Discontinued Teams','NCAA Discontinued','Simon Fraser','Simon_Fraser',NULL),
('Discontinued USA','Discontinued NCAA','Sonoma State Seawolves','sonomastate','Sonoma State','Unknown','Unknown','Sonoma State',NULL,'Discontinued Teams','NCAA Discontinued','Sonoma State','Sonoma_St',NULL),
('Discontinued USA','Discontinued NCAA','St. Augustine''s Falcons','staugustines','St. Augustine''s','ii','CIAA','St. Augustine''s',NULL,'Discontinued Teams','NCAA Discontinued','St. Augustine''s','St_Augustine''s',NULL),
('Discontinued USA','Discontinued NCAA','St. Cloud State Huskies','stcloudstate','St. Cloud State','Unknown','Unknown','St. Cloud State',NULL,'Discontinued Teams','NCAA Discontinued','St. Cloud State','St_Cloud',NULL),
('Discontinued USA','Discontinued NCAA','St. Joseph''s (IN) Pumas','stjosephs','St. Joseph''s (IN)','ii','Great Lakes','St. Joseph''s (IN)',NULL,'Discontinued Teams','NCAA Discontinued','St. Joseph''s (IN)','St_Joseph''s_IN',NULL),
('Discontinued USA','Discontinued NCAA','St. Paul''s (VA) Tigers','stpaulsva','St. Paul''s (VA)',NULL,NULL,NULL,NULL,'Discontinued Teams','NCAA Discontinued','St. Paul''s (VA)','St_Paul''s',NULL),
('Discontinued USA','Discontinued NCAA','Stillman Tigers','stillman','Stillman','Unknown','Unknown','Stillman',NULL,'Discontinued Teams','NCAA Discontinued','Stillman','Stillman',NULL),
('Discontinued USA','Discontinued NCAA','Sue Bennett Dragons','suebennett','Sue Bennett',NULL,NULL,NULL,NULL,'Discontinued Teams','NCAA Discontinued','Sue Bennett','Sue_Bennett',NULL),
('Discontinued USA','Discontinued NCAA','Swarthmore Garnet','swarthmore','Swarthmore','Unknown','Unknown','Swarthmore',NULL,'Discontinued Teams','NCAA Discontinued','Swarthmore','Swarthmore',NULL),
('Discontinued USA','Discontinued NCAA','UMass Boston Beacons','massachusettsboston','UMass Boston',NULL,NULL,NULL,NULL,'Discontinued Teams','NCAA Discontinued','UMass Boston','MA_Boston',NULL),
('Discontinued USA','Discontinued NCAA','UMass Lowell River Hawks','massachusettslowell','UMass Lowell','Unknown','Unknown','UMass Lowell',NULL,'Discontinued Teams','NCAA Discontinued','UMass Lowell','MA_Lowell',NULL),
('Discontinued USA','Discontinued NCAA','Urbana Blue Knights','urbana','Urbana','Unknown','Unknown','Urbana',NULL,'Discontinued Teams','NCAA Discontinued','Urbana','Urbana',NULL),
('Discontinued USA','Discontinued NCAA','Wesley Wolverines','wesley','Wesley','Unknown','Unknown','Wesley','Wesley College','Discontinued Teams','NCAA Discontinued','Wesley','Wesley_DE',NULL),
('Discontinued USA','Discontinued NCAA','Western Washington Vikings','westernwashington','Western Washington','Unknown','Unknown','Western Washington',NULL,'Discontinued Teams','NCAA Discontinued','Western Washington','W_Washington',NULL),
('Discontinued USA','Discontinued NCAA','Westmar Eagles','westmar','Westmar',NULL,NULL,NULL,NULL,'Discontinued Teams','Non-NCAA Discontinued','Westmar','Westmar',NULL),
('Discontinued USA','Discontinued NCAA','Whittier Poets','whittier','Whittier',NULL,NULL,NULL,NULL,'Discontinued Teams','NCAA Discontinued','Whittier','Whittier',NULL),
('Discontinued USA','Discontinued NCAA','WVU Tech Golden Bears','westvirginiatech','WVU Tech',NULL,NULL,NULL,NULL,'Discontinued Teams','NCAA Discontinued','WVU Tech','WV_Tech',NULL),
('Discontinued USA','Discontinued Non-NCAA','Arizona Western Matadors','arizonawestern','Arizona Western',NULL,NULL,NULL,NULL,'Discontinued Teams','Non-NCAA Discontinued','Arizona Western','AZ_Western',NULL),
('Discontinued USA','Discontinued Non-NCAA','BYU-Idaho Vikings','byuidaho','BYU-Idaho',NULL,NULL,NULL,NULL,'Discontinued Teams','Non-NCAA Discontinued','BYU-Idaho',NULL,NULL),
('Discontinued USA','Discontinued Non-NCAA','Concordia (AL) Hornets','concordiaal','Concordia (AL)','Unknown','Unknown','Concordia (AL)',NULL,'Discontinued Teams','Non-NCAA Discontinued','Concordia (AL)','Concordia_AL',NULL),
('Discontinued USA','Discontinued Non-NCAA','Eastern Arizona Gila Monsters','easternarizona','Eastern Arizona',NULL,NULL,NULL,NULL,'Discontinued Teams','Non-NCAA Discontinued','Eastern Arizona','Eastern_Arizona',NULL),
('Discontinued USA','Discontinued Non-NCAA','Glendale CC (AZ) Gauchos','glendaleccaz','Glendale CC (AZ)',NULL,NULL,NULL,NULL,'Discontinued Teams','Non-NCAA Discontinued','Glendale CC (AZ)','Glendale_AZ',NULL),
('Discontinued USA','Discontinued Non-NCAA','Globe Institute of Technology Knights','globetech','Globe Institute of Technology',NULL,NULL,NULL,NULL,'Discontinued Teams','Non-NCAA Discontinued','Globe Institute of Technology','Globe_Tech',NULL),
('Discontinued USA','Discontinued Non-NCAA','Grand Rapids CC Raiders','gccr','Grand Rapids CC',NULL,NULL,NULL,NULL,'Discontinued Teams','Non-NCAA Discontinued','Grand Rapids CC','Grand_Rapids_CC',NULL),
('Discontinued USA','Discontinued Non-NCAA','Harper Hawks','harper','Harper',NULL,NULL,NULL,NULL,'Discontinued Teams','Non-NCAA Discontinued','Harper','Harper',NULL),
('Discontinued USA','Discontinued Non-NCAA','Hibbing CC Cardinals','hibbingcc','Hibbing CC',NULL,NULL,NULL,NULL,'Discontinued Teams','Non-NCAA Discontinued','Hibbing CC','Hibbing_CC',NULL),
('Discontinued USA','Discontinued Non-NCAA','Iowa Wesleyan Tigers','iowawesleyan','Iowa Wesleyan','Unknown','Unknown','Iowa Wesleyan',NULL,'Discontinued Teams','Non-NCAA Discontinued','Iowa Wesleyan','Iowa_Wesleyan',NULL),
('Discontinued USA','Discontinued Non-NCAA','Joliet JC Wolves','jolietjc','Joliet JC',NULL,NULL,NULL,NULL,'Discontinued Teams','Non-NCAA Discontinued','Joliet JC','Joliet_JC',NULL),
('Discontinued USA','Discontinued Non-NCAA','Lon Morris Bearcats','lonmorris','Lon Morris',NULL,NULL,NULL,NULL,'Discontinued Teams','Non-NCAA Discontinued','Lon Morris','Lon_Morris',NULL),
('Discontinued USA','Discontinued Non-NCAA','Marin Mariners','collegemarin','Marin',NULL,NULL,NULL,NULL,'Discontinued Teams','Non-NCAA Discontinued','Marin','Col_of_Marin',NULL),
('Discontinued USA','Discontinued Non-NCAA','Mendocino Eagles','mendocino','Mendocino',NULL,NULL,NULL,NULL,'Discontinued Teams','Non-NCAA Discontinued','Mendocino','Mendocino',NULL),
('Discontinued USA','Discontinued Non-NCAA','Mesa CC Thunderbirds','mesacc','Mesa CC',NULL,NULL,NULL,NULL,'Discontinued Teams','Non-NCAA Discontinued','Mesa CC','Mesa_CC',NULL),
('Discontinued USA','Discontinued Non-NCAA','Montgomery Raptors','montgomery','Montgomery',NULL,NULL,NULL,NULL,'Discontinued Teams','Non-NCAA Discontinued','Montgomery',NULL,NULL),
('Discontinued USA','Discontinued Non-NCAA','Morthland Patriots','morthland','Morthland','Unknown','Unknown','Morthland',NULL,'Discontinued Teams','Non-NCAA Discontinued','Morthland','Morthland',NULL),
('Discontinued USA','Discontinued Non-NCAA','New Mexico Tech Miners','newmexicotech','New Mexico Tech','Unknown','Unknown','New Mexico Tech',NULL,'Discontinued Teams','Non-NCAA Discontinued','New Mexico Tech',NULL,NULL),
('Discontinued USA','Discontinued Non-NCAA','North Iowa Area CC Trojans','northiowaareacc','North Iowa Area CC',NULL,NULL,NULL,NULL,'Discontinued Teams','Non-NCAA Discontinued','North Iowa Area CC','N_Iowa_CC',NULL),
('Discontinued USA','Discontinued Non-NCAA','Ohio Mid-Western Rams','ohiomw','Ohio Mid-Western',NULL,NULL,NULL,NULL,'Discontinued Teams','Non-NCAA Discontinued','Ohio Mid-Western',NULL,NULL),
('Discontinued USA','Discontinued Non-NCAA','Phoenix Bears','phoenix','Phoenix',NULL,NULL,NULL,NULL,'Discontinued Teams','Non-NCAA Discontinued','Phoenix','Phoenix_Col',NULL),
('Discontinued USA','Discontinued Non-NCAA','Pima CC Aztecs','pimacc','Pima CC',NULL,NULL,NULL,NULL,'Discontinued Teams','Non-NCAA Discontinued','Pima CC','Pima_CC',NULL),
('Discontinued USA','Discontinued Non-NCAA','Potomac State Catamounts','potomacstate','Potomac State',NULL,NULL,NULL,NULL,'Discontinued Teams','Non-NCAA Discontinued','Potomac State',NULL,NULL),
('Discontinued USA','Discontinued Non-NCAA','Presentation Saints','presentation','Presentation','Unknown','Unknown','Presentation','Presentation College','Discontinued Teams','Non-NCAA Discontinued','Presentation','Presentation',NULL),
('Discontinued USA','Discontinued Non-NCAA','Rainy River CC Voyageurs','rainyrivercc','Rainy River CC',NULL,NULL,NULL,NULL,'Discontinued Teams','Non-NCAA Discontinued','Rainy River CC','Rainy_River_CC',NULL),
('Discontinued USA','Discontinued Non-NCAA','Ranger JC Rangers','rangerjc','Ranger JC',NULL,NULL,NULL,NULL,'Discontinued Teams','Non-NCAA Discontinued','Ranger JC','Ranger',NULL),
('Discontinued USA','Discontinued Non-NCAA','Rock Velley Golden Eagles','rockvalley','Rock Velley',NULL,NULL,NULL,NULL,'Discontinued Teams','Non-NCAA Discontinued','Rock Velley','Rock_Valley',NULL),
('Discontinued USA','Discontinued Non-NCAA','Scottsdale CC Fighting Artichokes','scottsdalecc','Scottsdale CC',NULL,NULL,NULL,NULL,'Discontinued Teams','Non-NCAA Discontinued','Scottsdale CC','Scottsdale_CC',NULL),
('Discontinued USA','Discontinued Non-NCAA','Solano CC Falcons','solanocc','Solano CC',NULL,NULL,NULL,NULL,'Discontinued Teams','Non-NCAA Discontinued','Solano CC','Solano_CC',NULL),
('Discontinued USA','Discontinued Non-NCAA','Trinity Bible College Lions','trinitybible','Trinity Bible College',NULL,NULL,NULL,NULL,'Discontinued Teams','Non-NCAA Discontinued','Trinity Bible College','Trinity_Bib',NULL),
('Discontinued USA','Discontinued Non-NCAA','Trinity International Trojans','trinityinternational','Trinity International','Unknown','Unknown','Trinity International (IL)',NULL,'Discontinued Teams','Non-NCAA Discontinued','Trinity International','Trinity_Intl',NULL),
('Discontinued USA','Discontinued Non-NCAA','West Valley Vikings','westvalley','West Valley',NULL,NULL,NULL,NULL,'Discontinued Teams','Non-NCAA Discontinued','West Valley','West_Valley_Col',NULL),
('Discontinued International','Mexico','Zorros ITQ','itq','ITQ',NULL,NULL,NULL,NULL,'Discontinued Teams','Mexico','ITQ','Zorros_ITQ',NULL),
(NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CCCAA','South American','Compton CC','El_Camino-Compton',NULL),
(NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'D2','D2 Independents','Bluefield State','Bluefield_WV',NULL),
(NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'D2','D2 Independents','Bluefield State','Bluefield_State',NULL),
(NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'D2','GLIAC','Roosevelt','R_Morris_Chi',NULL),
(NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'D3','Centennial','McDaniel','McDaniel_Col',NULL),
(NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'D3','SCIAC','Pomona-Pitzer','Pomona-Pitzer',NULL),
(NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'D3','Upper Midwest','Martin Luther','Luther_MN',NULL),
(NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Discontinued Teams','D1 Discontinued','CSU Northridge','CS_Northridge',NULL),
(NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Discontinued Teams','Mexico','Anahuac','Anahuac',NULL),
(NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Discontinued Teams','Mexico','Hermosillo','Hermosillo',NULL),
(NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Discontinued Teams','Mexico','Madero Puebla','Madero_Puebla',NULL),
(NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Discontinued Teams','Mexico','UTZMG','UTZMG',NULL),
(NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Discontinued Teams','NCAA Discontinued','Georgia Southwestern State',NULL,NULL),
(NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Discontinued Teams','NCAA Discontinued','Humboldt State','Humboldt_St',NULL),
(NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Discontinued Teams','NCAA Discontinued','King (TN)',NULL,NULL),
(NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Discontinued Teams','Non-NCAA Discontinued','Air Force Prep','Air_Force_Prep',NULL),
(NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Discontinued Teams','Non-NCAA Discontinued','Berean Institute','Berean_Institute',NULL),
(NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Discontinued Teams','Non-NCAA Discontinued','Lon Morris','Southeast_Prep',NULL),
(NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Discontinued Teams','Non-NCAA Discontinued','Madison College','Madison_Col',NULL),
(NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Discontinued Teams','Non-NCAA Discontinued','Walter Reed','Walter_Reed',NULL),
(NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FCS','Southland','Texas A&M-Commerce','East_Texas_St',NULL),
(NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FCS','UAC','Utah Tech','Dixie_St',NULL),
(NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Mexico','ONEFA','UA Chapingo','Toros_Salvajes',NULL),
(NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Mexico','ONEFA','UA Chihuahua','Aguilas_UACH',NULL),
(NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'NAIA','Appalachian AC','Bluefield','Bluefield_VA',NULL),
(NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'NAIA','Heart of America','William Woods','William_Woods',NULL),
(NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'NJCAA','MACJC','Jones County JC','Jones_Co_CC',NULL),
(NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FCS','Southland','HCU','Houston_Bap',NULL)
;


-- conference data
INSERT INTO `scoreboard`.`conference_data`
(division, fullname, filename, abbreviated)
VALUES ('FBS', 'ACC', 'acc', 'ACC'),
('FBS', 'American', 'aac', 'American'),
('FBS', 'Big 12', 'big12', 'Big 12'),
('FBS', 'Big Ten', 'bigten', 'Big Ten'),
('FBS', 'Conference USA', 'cusa', 'Conference USA'),
('FBS', 'FBS Independents', 'indep', 'FBS Independents'),
('FBS', 'MAC', 'mac', 'MAC'),
('FBS', 'Mountain West', 'mwc', 'Mountain West'),
('FBS', 'NCAA', 'ncaa', 'NCAA'),
('FBS', 'Pac-12', 'pac12', 'Pac-12'),
('FBS', 'SEC', 'sec', 'SEC'),
('FBS', 'Sun Belt', 'sunbelt', 'Sun Belt'),
('FCS', 'ASUN', 'asun', 'ASUN'),
('FCS', 'Big Sky', 'bigsky', 'Big Sky'),
('FCS', 'Big South', 'bigsouth', 'Big South'),
('FCS', 'Big South-OVC', 'bigsouthovc', 'Big South-OVC'),
('FCS', 'CAA', 'caa', 'CAA'),
('FCS', 'FCS', 'fcs', 'FCS'),
('FCS', 'Ivy League', 'ivy', 'Ivy League'),
('FCS', 'MEAC', 'meac', 'MEAC'),
('FCS', 'MVFC', 'mvfc', 'MVFC'),
('FCS', 'Northeast', 'nec', 'Northeast'),
('FCS', 'Ohio Valley', 'ovc', 'Ohio Valley'),
('FCS', 'Patriot', 'patriot', 'Patriot'),
('FCS', 'Pioneer', 'pioneer', 'Pioneer'),
('FCS', 'SoCon', 'socon', 'SoCon'),
('FCS', 'Southland', 'southland', 'Southland'),
('FCS', 'SWAC', 'swac', 'SWAC'),
('FCS', 'UAC', 'uac', 'UAC'),
('FCS', 'WAC', 'wac', 'WAC'),
('FCS', 'Yankee', 'yankee', 'Yankee'),
('D2', 'CIAA', 'ciaa', 'CIAA'),
('D2', 'GLIAC', 'gliac', 'GLIAC'),
('D2', 'GLVC', 'glvc', 'GLVC'),
('D2', 'Great American', 'gac', 'Great American'),
('D2', 'Great Midwest', 'gmac', 'Great Midwest'),
('D2', 'Gulf South', 'gsc', 'Gulf South'),
('D2', 'Lone Star', 'lsc', 'Lone Star'),
('D2', 'Mid-America IAA', 'midamericaiaa', 'Mid-America IAA'),
('D2', 'Mountain East', 'mec', 'Mountain East'),
('D2', 'Northeast-10', 'ne10', 'Northeast-10'),
('D2', 'Northern Sun', 'nsic', 'Northern Sun'),
('D2', 'PSAC', 'psac', 'PSAC'),
('D2', 'RMAC', 'rmac', 'RMAC'),
('D2', 'SIAC', 'siac', 'SIAC'),
('D2', 'South Atlantic', 'southatlantic', 'South Atlantic'),
('D3', 'American Rivers', 'arc', 'American Rivers'),
('D3', 'American Southwest', 'asc', 'American Southwest'),
('D3', 'CCIW', 'cciw', 'CCIW'),
('D3', 'Centennial', 'centennialconference', 'Centennial'),
('D3', 'Conference of New England', 'ccc', 'Conference of New England'),
('D3', 'ECFC', 'easterncfc', 'ECFC'),
('D3', 'Empire 8', 'empire8', 'Empire 8'),
('D3', 'Heartland', 'hcac', 'Heartland'), -- Discontinued. According to wiki it was D2 anyway
('D3', 'Landmark', 'landmark', 'Landmark'),
('D3', 'Liberty League', 'libertyleague', 'Liberty League'),
('D3', 'MASCAC', 'mascac', 'MASCAC'),
('D3', 'MIAC', 'miac', 'MIAC'),
('D3', 'Michigan IAA', 'michiganiaa', 'Michigan IAA'),
('D3', 'Middle Atlantic', 'middleatlantic', 'Middle Atlantic'),
('D3', 'Midwest', 'midwest', 'Midwest'),
('D3', 'NACC', 'nacc', 'NACC'),
('D3', 'NESCAC', 'nescac', 'NESCAC'),
('D3', 'NEWMAC', 'newmac', 'NEWMAC'),
('D3', 'NJAC', 'njac', 'NJAC'),
('D3', 'North Coast', 'northcoast', 'North Coast'),
('D3', 'Northwest', 'nwc', 'Northwest'),
('D3', 'OAC', 'oac', 'OAC'),
('D3', 'ODAC', 'odac', 'ODAC'),
('D3', "Presidents' AC", 'pac', "Presidents' AC"),
('D3', 'SAA', 'saa', 'SAA'),
('D3', 'SCAC', 'scac', 'SCAC'),
('D3', 'SCIAC', 'sciac', 'SCIAC'),
('D3', 'Upper Midwest', 'umac', 'Upper Midwest'),
('D3', 'USA South', 'usasouth', 'USA South'),
('D3', 'WIAC', 'wiac', 'WIAC'),
('NAIA', 'Appalachian AC', 'appalachianac', 'Appalachian AC'),
('NAIA', 'Frontier', 'frontier', 'Frontier'),
('NAIA', 'Great Plains', 'gpac', 'Great Plains'),
('NAIA', 'Heart of America', 'haac', 'Heart of America'),
('NAIA', 'KCAC', 'kcac', 'KCAC'),
('NAIA', 'Mid-South', 'midsouth', 'Mid-South'),
('NAIA', 'Mid-States', 'msfa', 'Mid-States'),
('NAIA', 'North Star', 'nsaa', 'North Star'),
('NAIA', 'Sooner AC', 'soonerac', 'Sooner AC'),
('NAIA', 'The Sun', 'thesun', 'The Sun'),
('Other', 'BUCS', 'bucs', 'BUCS'),
('Other', 'CCCAA', 'cccaa', 'CCCAA'),
('Other', 'College Football Finland', 'uifl', 'College Football Finland'),
('Other', 'CONADEIP', 'conadeip', 'CONADEIP'),
('Other', 'CSFL', 'csfl', 'CSFL'),
('Other', 'ICFF', 'icff', 'ICFF'),
('Other', 'JAFA', 'jafa', 'JAFA'),
('Other', 'MSFL', 'msfl', 'MSFL'),
('Other', 'NAIA', 'naia', 'NAIA'),
('Other', 'NCAA D2', 'ncaad2', 'NCAA D2'),
('Other', 'NCAA D3', 'ncaad3', 'NCAA D3'),
('Other', 'NCCAA', 'nccaa', 'NCCAA'),
('Other', 'NCFA', 'ncfa', 'NCFA'),
('Other', 'NJCAA', 'njcaa', 'NJCAA'),
('Other', 'ONEFA', 'onefa', 'ONEFA'),
('Other', 'U Sports', 'cis', 'U Sports'),
('Other', 'USCAA', 'uscaa', 'USCAA'),
('Discontinued', 'ACFC', 'acfc', 'ACFC'),
('Discontinued', 'AMCU', 'amcu', 'AMCU'),
('Discontinued', 'American West', 'americanwest', 'American West'),
('Discontinued', 'AQ7', 'aq7', 'AQ7'),
('Discontinued', 'Arkansas Intercollegiate', 'arkansasintercollegiate', 'Arkansas Intercollegiate'),
('Discontinued', 'Atlantic 10', 'atlantic10', 'Atlantic 10'),
('Discontinued', 'Big 8', 'big8', 'Big 8'),
('Discontinued', 'Big East', 'bigeast', 'Big East'),
('Discontinued', 'Big West', 'bigwest', 'Big West'),
('Discontinued', 'Border Conference', 'border', 'Border Conference'),
('Discontinued', 'CCAA', 'ccaa', 'CCAA'),
('Discontinued', 'Conference Carolinas', 'conferencecarolinas', 'Conference Carolinas'),
('Discontinued', 'Dakota Athletic', 'dakotaathletic', 'Dakota Athletic'),
-- ('Discontinued', 'ECFC', 'easterncfc', 'ECFC'), -- not discontinued just yet!
('Discontinued', 'EPC', 'epc', 'EPC'),
('Discontinued', 'GCAC', 'gcac', 'GCAC'),
('Discontinued', 'Great Lakes', 'greatlakes', 'Great Lakes'),
('Discontinued', 'Great Northwest', 'gnac', 'Great Northwest'),
('Discontinued', 'Great West', 'greatwest', 'Great West'),
('Discontinued', 'Gulf Star', 'gulfstar', 'Gulf Star'),
-- ('Discontinued', 'Heartland', 'hcac', 'Heartland'),
('Discontinued', 'IBFC', 'ibfc', 'IBFC'),
('Discontinued', 'MAAC', 'maac', 'MAAC'),
('Discontinued', 'Metro', 'metro', 'Metro'),
('Discontinued', 'Mid-Continent', 'midcontinent', 'Mid-Continent'),
('Discontinued', 'Missouri Valley', 'mvc', 'Missouri Valley'),
('Discontinued', 'MSC', 'msc', 'MSC'),
('Discontinued', 'NCAC', 'ncac', 'NCAC'),
('Discontinued', 'North Atlantic', 'northatlantic', 'North Atlantic'),
('Discontinued', 'North Central', 'ncc', 'North Central'),
('Discontinued', 'Pacific Northwest', 'pacificnorthwest', 'Pacific Northwest'),
('Discontinued', 'SAIAA', 'saiaa', 'SAIAA'),
('Discontinued', 'SIAA', 'siaa', 'SIAA'),
('Discontinued', 'SLIAC', 'sliac', 'SLIAC'),
('Discontinued', 'Southwest', 'southwest', 'Southwest'),
('Discontinued', 'TIAA', 'tiaa', 'TIAA'),
('Discontinued', 'UAA', 'uaa', 'UAA'),
('Discontinued', 'WIUFA', 'wiufa', 'WIUFA'),
('Discontinued', 'WVIAC', 'wviac', 'WVIAC')
;


-- bowl data
INSERT INTO `scoreboard`.`bowl_data`
(level, fullname, filename, abbreviated)
VALUES ('Championships', 'BCS Championship', 'bcs', 'BCS Championship'),
('Championships', 'College Football Playoff', 'cfp', 'College Football Playoff'),
('Championships', 'Cotton Bowl', 'cotton', 'Cotton Bowl'),
('Championships', 'D2 National Championship', 'd2championship', 'D2 National Championship'),
('Championships', 'FCS Championship', 'fcsc', 'FCS Championship'),
('Championships', 'Fiesta Bowl', 'fiesta', 'Fiesta Bowl'),
('Championships', 'NAIA National Championship', 'naiachampionship', 'NAIA National Championship'),
('Championships', 'Orange Bowl', 'orange', 'Orange Bowl'),
('Championships', 'Peach Bowl', 'peach', 'Peach Bowl'),
('Championships', 'Rose Bowl', 'rose', 'Rose Bowl'),
('Championships', 'Stagg Bowl', 'stagg', 'Stagg Bowl'),
('Championships', 'Sugar Bowl', 'sugar', 'Sugar Bowl'),
('Championships', 'Vanier Cup', 'vanier', 'Vanier Cup'),
('Major', 'Alamo Bowl', 'alamo', 'Alamo Bowl'),
('Major', 'Cheez-It Bowl', 'cheezit', 'Cheez-It Bowl'),
('Major', 'Citrus Bowl', 'citrusbowl', 'Citrus Bowl'),
('Major', "Duke's Mayo Bowl", 'dukesmayo', "Duke's Mayo Bowl"),
('Major', 'Fenway Bowl', 'fenway', 'Fenway Bowl'),
('Major', 'First Responder Bowl', 'dallas', 'First Responder Bowl'),
('Major', 'Gator Bowl', 'gator', 'Gator Bowl'),
('Major', 'Guaranteed Rate Cactus Bowl', 'cactus', 'Guaranteed Rate Cactus Bowl'),
('Major', 'Holiday Bowl', 'holiday', 'Holiday Bowl'),
('Major', 'Independence Bowl', 'independence', 'Independence Bowl'),
('Major', 'LA Bowl', 'labowl', 'LA Bowl'),
('Major', 'Las Vegas Bowl', 'lasvegas', 'Las Vegas Bowl'),
('Major', 'Liberty Bowl', 'libertybowl', 'Liberty Bowl'),
('Major', 'Military Bowl', 'military', 'Military Bowl'),
('Major', 'Music City Bowl', 'musiccity', 'Music City Bowl'),
('Major', 'Pinstripe Bowl', 'pinstripe', 'Pinstripe Bowl'),
('Major', 'Redbox Bowl', 'sfbowl', 'Redbox Bowl'),
('Major', 'Sun Bowl', 'sun', 'Sun Bowl'),
('Major', 'Tampa Bay Bowl', 'tampabay', 'Tampa Bay Bowl'),
('Major', 'Texas Bowl', 'texasbowl', 'Texas Bowl'),
('Other', 'Arizona Bowl', 'arizonabowl', 'Arizona Bowl'),
('Other', 'Armed Forces Bowl', 'armedforces', 'Armed Forces Bowl'),
('Other', 'Bahamas Bowl', 'bahamas', 'Bahamas Bowl'),
('Other', 'Birmingham Bowl', 'birminghambowl', 'Birmingham Bowl'),
('Other', 'Boca Raton Bowl', 'bocaraton', 'Boca Raton Bowl'),
('Other', 'Camellia Bowl', 'camellia', 'Camellia Bowl'),
('Other', 'Celebration Bowl', 'celebration', 'Celebration Bowl'),
('Other', 'Cure Bowl', 'cure', 'Cure Bowl'),
('Other', 'Famous Idaho Potato Bowl', 'potato', 'Famous Idaho Potato Bowl'),
('Other', 'Frisco Bowl', 'friscobowl', 'Frisco Bowl'),
('Other', 'Frisco Football Classic', 'friscoclassic', 'Frisco Football Classic'),
('Other', 'Gasparilla Bowl', 'stpetersburg', 'Gasparilla Bowl'),
('Other', "Hawai'i Bowl", 'hawaiibowl', "Hawai'i Bowl"),
('Other', 'Heritage Bowl (D2)', 'heritaged2', 'Heritage Bowl (D2)'),
('Other', 'Lending Tree Mobile Bowl', 'mobile', 'Lending Tree Mobile Bowl'),
('Other', 'Mineral Water Bowl', 'mineralwater', 'Mineral Water Bowl'),
('Other', 'Myrtle Beach Bowl', 'myrtlebeach', 'Myrtle Beach Bowl'),
('Other', 'New Mexico Bowl', 'newmexicobowl', 'New Mexico Bowl'),
('Other', 'New Orleans Bowl', 'neworleansbowl', 'New Orleans Bowl'),
('Other', 'Oyster Bowl', 'oyster', 'Oyster Bowl'),
('Other', 'Pioneer Bowl', 'pioneerbowl', 'Pioneer Bowl'),
('Other', 'Pop-Tarts Bowl', 'poptarts', 'Pop-Tarts Bowl'),
('Other', 'Quick Lane Bowl', 'lions', 'Quick Lane Bowl'),
('Other', 'Texarkana Bowl', 'texarkana', 'Texarkana Bowl'),
('Discontinued', 'All-American Bowl', 'allamerican', 'All-American Bowl'),
('Discontinued', 'Aloha Bowl', 'aloha', 'Aloha Bowl'),
('Discontinued', 'Aviation Bowl', 'aviation', 'Aviation Bowl'),
('Discontinued', 'Aztec Bowl', 'aztec', 'Aztec Bowl'),
('Discontinued', 'Bacardi Bowl', 'bacardi', 'Bacardi Bowl'),
('Discontinued', 'Belk Bowl', 'belk', 'Belk Bowl'),
('Discontinued', 'Bluebonnet Bowl', 'bluebonnet', 'Bluebonnet Bowl'),
('Discontinued', 'Bluegrass Bowl', 'bluegrass', 'Bluegrass Bowl'),
('Discontinued', 'California Raisin Bowl', 'californiaraisin', 'California Raisin Bowl'),
('Discontinued', 'Charity Bowl', 'charitybowl', 'Charity Bowl'),
('Discontinued', 'Cherry Bowl', 'cherrybowl', 'Cherry Bowl'),
('Discontinued', 'Chicago College All-Star Game', 'chicagoallstar', 'Chicago College All-Star Game'),
('Discontinued', 'Cigar Bowl', 'cigar', 'Cigar Bowl'),
('Discontinued', 'Delta Bowl', 'delta', 'Delta Bowl'),
('Discontinued', 'Dixie Bowl', 'dixiebowl', 'Dixie Bowl'),
('Discontinued', 'Dixie Classic', 'dixieclassic', 'Dixie Classic'),
('Discontinued', 'Dixie Rotary Bowl', 'dixierotary', 'Dixie Rotary Bowl'),
('Discontinued', 'Fort Worth Bowl', 'fortworthbowl', 'Fort Worth Bowl'),
('Discontinued', 'Freedom Bowl', 'freedom', 'Freedom Bowl'),
('Discontinued', 'Garden State Bowl', 'gardenstate', 'Garden State Bowl'),
('Discontinued', 'Glass Bowl', 'glass', 'Glass Bowl'),
('Discontinued', 'Gotham Bowl', 'gotham', 'Gotham Bowl'),
('Discontinued', 'Gridiron Classic', 'gridiron', 'Gridiron Classic'),
('Discontinued', 'Harbor Bowl', 'harbor', 'Harbor Bowl'),
('Discontinued', 'Heritage Bowl', 'heritage', 'Heritage Bowl'),
('Discontinued', 'Houston Bowl', 'houstonbowl', 'Houston Bowl'),
('Discontinued', 'International Bowl', 'internationalbowl', 'International Bowl'),
('Discontinued', 'Ivy Bowl', 'ivybowl', 'Ivy Bowl'),
('Discontinued', 'Kanza Bowl', 'kanza', 'Kanza Bowl'),
('Discontinued', 'Los Angeles Christmas Festival', 'losangeleschristmas', 'Los Angeles Christmas Festival'),
('Discontinued', 'Mirage Bowl', 'mirage', 'Mirage Bowl'),
('Discontinued', 'Montgomery Bowl', 'montgomerybowl', 'Montgomery Bowl'),
('Discontinued', 'Oil Bowl', 'oilbowl', 'Oil Bowl'),
('Discontinued', 'Pineapple Bowl', 'pineapple', 'Pineapple Bowl'),
('Discontinued', 'Poinsettia Bowl', 'poinsettia', 'Poinsettia Bowl'),
('Discontinued', 'Presidential Cup', 'presidentialcup', 'Presidential Cup'),
('Discontinued', 'Refrigerator Bowl', 'refrigerator', 'Refrigerator Bowl'),
('Discontinued', 'Salad Bowl', 'salad', 'Salad Bowl'),
('Discontinued', 'San Diego East-West Christmas Classic', 'sandiegochristmas', 'San Diego East-West Christmas Classic'),
('Discontinued', 'Seattle Bowl', 'seattlebowl', 'Seattle Bowl'),
('Discontinued', 'Shrine Bowl', 'shrine', 'Shrine Bowl'),
('Discontinued', 'Silicon Valley Football Classic', 'siliconvalley', 'Silicon Valley Football Classic'),
('Discontinued', 'Vulcan Bowl', 'vulcan', 'Vulcan Bowl')
;

