NCAAFB

gistfile1.txt

delta
Florida Gators Football
Florida

delta
Tennessee Volunteers Football
Tennessee
Volunteers
TENN

delta
Georgia Bulldogs Football
Georgia

delta
Kentucky Wildcats Football
Kentucky
UK

delta
South Carolina Football
South Carolina
SCAR

delta
Vanderbilt Football
Commodores
VAN

delta
Arkansas Razorbacks Football
Arkansas
ARK

delta
Auburn Football
Auburn
AUB

delta
LSU Football

delta
Alabama Crimson Tide Football
ALA

delta
Ole Miss Football
Mississippi
Rebels
MISS

delta
Mississippi State Football
MSST

delta
Missouri Tigers Football
Missouri
MIZZ

delta
Texas A&M Football
TA&M

delta
Wake Forest Football
Wake Forest
Demon Deacons
WAKE

delta
Boston College Football
Boston College
BC

delta
Maryland Terrapins Football
Maryland
Terrapins
MD

delta
Clemson Football
CLEM

delta
Florida State Football

delta
NC State Football
North Carolina State
Wolfpack
NCST

delta
Georgia Tech Football
GT

delta
Virginia Tech Football
VT

delta
UVa Football
Virginia
UVA

delta
Miami Hurricanes Football
Miami
MIA

delta
UNC Football
North Carolina
Tar Heels
UNC

delta
Duke Football
Duke
Blue Devils
DUKE

delta
Pitt Football
Pittsburgh
PITT

delta
Syracuse Football
Syracuse
SYR

delta
Kansas State Football
KSU

delta
Kansas Jayhawks Football
Kansas
Jayhawks
KU

delta
Iowa State Football
Iowa State
Cyclones
ISU

delta
Oklahoma Sooners Football
Oklahoma
OKLA

delta
Texas Longhorns Football
Texas
TEX

delta
Texas Tech Football
TTU

delta
Oklahoma State Football
OKST

delta
Baylor Football
Baylor
BAY

delta
WVU Football

delta
TCU Football
Horned Frogs

delta
Nebraska Huskers Football
Nebraska
NEB

delta
Ohio State Football
OSU

delta
Wisconsin Badgers Football
WISC

delta
Michigan Wolverines Football
Michigan
MICH

delta
Penn State Football
PSU

delta
Purdue Football
Purdue
Boilermakers
PUR

delta
Minnesota Golden Gophers Football
Minnesota
Golden Gophers
MINN

delta
Indiana Hoosiers Football
Indiana
Hoosiers
IND

delta
Iowa Hawkeyes Football
Iowa
IOWA

delta
Northwestern Football
Northwestern
NU

delta
Michigan State Football
MSU

delta
Illinois Fighting Illini Football
Illinois
Fighting Illini
ILL

delta
Wyoming Cowboys Football
Wyoming
WYO

delta
New Mexico Lobos Football
New Mexico
Lobos
UNM

delta
Air Force Football
Air Force
AFA

delta
San Diego State Football
San Diego State
Aztecs
SDSU

delta
Colorado State Football
Colorado State
CSU

delta
UNLV Football
UNLV
Runnin' Rebels

delta
Boise State Football

delta
Hawaii Warriors Football
Hawaii
HAW

delta
San Jose State Football
San Jose State
SJSU

delta
Nevada Wolf Pack Football
Nevada
Wolf Pack
NEV

delta
Fresno State Football
Fresno State
FRES

delta
Utah State Football
Utah State
USU

delta
Colorado Buffaloes Football
Colorado
COL

delta
Utah Utes Football
Utah
Utes
UTAH

delta
USC Football

delta
Cal Bears Football
California
CAL

delta
Oregon State Football
ORST

delta
UCLA Football
Bruins

delta
Oregon Ducks Football
Oregon
Ducks
ORE

delta
Arizona State Football
ASU

delta
Arizona Wildcats Football
Arizona
ARIZ

delta
Washington State Football
Washington State

delta
Washington Huskies Football
Washington
WASH

delta
Stanford Football
Cardinal
STAN

delta
BYU Football
Brigham Young
BYU

delta
Navy Football
Navy
Midshipmen
NAVY

delta
Army Football
Army
Black Knights
ARMY

delta
Idaho Vandals Football
Idaho
Vandals
IDAHO

delta
New Mexico State Football
New Mexico State
NMSU

delta
Notre Dame Football
ND

delta
Old Dominion Football
Old Dominion
Monarchs
ODU

delta
Penn Football
Penn
Quakers
PENN

delta
Yale Football
Yale
YALE

delta
Cornell Football
Cornell
Big Red
COR

delta
Columbia Football
Columbia
CLMB

delta
Brown Bears Football
Brown Bears
Brown
BRWN

delta
Harvard Football
Harvard
Crimson
HARV

delta
Dartmouth Football
Dartmouth
Big Green
DART

delta
Princeton Football
Princeton
PRIN

delta
Louisiana Tech Football
Louisiana Tech
LT

delta
Florida International Football
Florida International
Golden Panthers
FIU

delta
UAB Football
UAB

delta
Marshall Football
Marshall
Thundering Herd
MRSH

delta
Tulane Football
Tulane
Green Wave
TULN

delta
UTEP Miners Football
UTEP

delta
East Carolina Football
East Carolina
Pirates
ECU

delta
Florida Atlantic Football
Florida Atlantic
FAU

delta
North Texas Mean Green Football
North Texas
Mean Green
UNT

delta
Rice Football
Rice
RICE

delta
Southern Miss Football
Southern Miss
USM

delta
Middle Tennessee State Football
Blue Raiders

delta
Tulsa Football
Tulsa
Golden Hurricanes
TLSA

delta
UTSA Football
UTSA
Roadrunners

delta
Arkansas State Football
Arkansas State
Red Wolves
ARST

delta
Troy Trojans Football
Troy
TROY

delta
Louisiana-Monroe Football
Louisiana-Monroe
Warhawks
ULM

delta
Louisiana-Lafayette Football
Louisiana-Lafayette
Ragin' Cajuns
ULL

delta
Western Kentucky Football
Western Kentucky
WKU

delta
Texas State Football
Texas State
TXST

delta
South Alabama Football
South Alabama
Jaguars
USA

delta
Georgia State Football
Georgia State

delta
Buffalo Bulls Football
Buffalo
BUFF

delta
Miami Redhawks Football
Miami (OH)
Redhawks
M-OH

delta
Northern Illinois Football
Northern Illinois
NIU

delta
Western Michigan Football
Western Michigan
WMU

delta
Ball State Football
Ball State
BALL

delta
Akron Football
Akron
Zips
AKR

delta
Bowling Green State Football
Bowling Green
BGSU

delta
Kent State Football
Kent State
Golden Flashes
KENT

delta
Ohio Bobcats Football
Ohio
OHIO

delta
Central Michigan Football
Central Michigan
Chippewas
CMU

delta
Eastern Michigan Football
Eastern Michigan
EMU

delta
Toledo Football
Toledo
Rockets
TOL

delta
UMass Football
Massachusetts
Minutemen
MASS

delta
Bowie State Football
Bowie State

delta
Chowan Football
Chowan
CU

delta
Elizabeth City Football
Elizabeth City
ECSU

delta
Fayettville State Football
Fayettville State
FAY

delta
Johnson C Smith Football
Johnson C Smith
Golden Bulls
JCSU

delta
Livingstone College Football
Livingstone College
Blue Bears
LC

delta
Lincoln University (PA) Football
Lincoln University (PA)
LU

delta
St. Augustine's Football
St. Augustine's
Mighty Falcons
SA

delta
Shaw Football
Shaw
SHAW

delta
Virginia State Football
Virginia State
VSU

delta
Virginia Union Football
Virginia Union
VUU

delta
Winston-Salem State Football
Winston-Salem State
WSSU

delta
Alderson-Broaddus Football
Alderson-Broaddus
Battlers
ABC

delta
McMurry Football
McMurry
War Hawks
MCU

delta
North Greenville Football
North Greenville
Crusaders
NGU

delta
Oklahoma Panhandle State Football
Oklahoma Panhandle State
OPSU

delta
South Dakota School of Mines Football
South Dakota School of Mines
Hardrockers
SDSM

delta
North Carolina-Pembroke Football
North Carolina-Pembroke
Braves
UNCP

delta
Arkansas Tech Football
Arkansas Tech
Wonder Boys
ATU

delta
East Central Oklahoma Football
East Central Oklahoma
ECOK

delta
Henderson State Football
Henderson State
Reddies
HSU

delta
Harding Football
Harding
Bisons
HU

delta
Northwestern Oklahoma State Football
Northwestern Oklahoma State
Rangers
NWOKST

delta
Ouachita Baptist Football
Ouachita Baptist
OBU

delta
Southern Arkansas Football
Southern Arkansas
Muleriders
SARU

delta
Southeastern Oklahoma State Football
Southeastern Oklahoma State
Savage Storm
SEOK

delta
Southern Nazarene Football
Southern Nazarene
Crimson Storm
SNU

delta
Southwestern Oklahoma State Football
Southwestern Oklahoma State
SWOK

delta
Arkansas-Monticello Football
Arkansas-Monticello
Boll Weevils
UARM

delta
Ashland Football
Ashland
ASHU

delta
Ferris State Football
Ferris State
FERST

delta
Grand Valley State Football
Grand Valley State
GVSU

delta
Hillsdale Football
Hillsdale
HILC

delta
Lake Erie Football
Lake Erie
Storm
LEC

delta
Michigan Tech Football
Michigan Tech

delta
Malone Football
Malone
MU

delta
Northern Michigan Football
Northern Michigan
NMIU

delta
Northwood Football
Northwood
Timberwolves
NOWOU

delta
Ohio Dominican Football
Ohio Dominican
OHDU

delta
Saginaw Valley State Football
Saginaw Valley State
SVSU

delta
Tiffin Football
Tiffin
TU

delta
Findlay Football
Findlay
Oilers
UFIN

delta
Walsh Football
Walsh
WALU

delta
Wayne State (MI) Football
Wayne State (MI)
WSUMI

delta
Kentucky Wesleyan Football
Kentucky Wesleyan
KWC

delta
McKendree Football
McKendree
MCKU

delta
Missouri-Science & Tech Football
Missouri-Science & Tech
MUST

delta
Quincy Football
Quincy
QU

delta
St. Joseph's College Football
St. Joseph's College
Pumas
SJCI

delta
Truman State Football
Truman State
TRUST

delta
Indianapolis Football
Indianapolis
UINDY

delta
William Jewell Football
William Jewell
WJC

delta
Delta State Football
Delta State
Statesmen
DELST

delta
Florida Tech Football
Florida Tech
FT

delta
Shorter Football
Shorter
SHORU

delta
North Alabama Football
North Alabama
UNA

delta
West Alabama Football
West Alabama
UWA

delta
West Georgia
UWGA

delta
Valdosta State Football
Valdosta State
VALST

delta
Angelo State Football
Angelo State
ASTU

delta
Eastern New Mexico Football
Eastern New Mexico
ENMU

delta
Midwestern State Football
Midwestern State
MWSU

delta
Texas A&M-Commerce Football
Texas A&M-Commerce
TAMC

delta
Texas A&M-Kingsville Football
Texas A&M-Kingsville
Javelinas
TAMUK

delta
Tarleton State Football
Tarleton State
Texans
TSU

delta
West Texas A&M Football
West Texas A&M
WTAMU

delta
Emporia State Football
Emporia State
Hornets
ESU

delta
Fort Hays State Football
Fort Hays State
FHS

delta
Lindenwood Football
Lindenwood
LINU

delta
Lincoln University (MO) Football
Lincoln University (MO)
Blue Tigers
LUMO

delta
Missouri Southern State Football
Missouri Southern State
MSSU

delta
Missouri Western Football
Missouri Western
Griffons
MWSTU

delta
Northeastern State Football
Northeastern State
RiverHawks
NSU

delta
Northwest Missouri State Football
Northwest Missouri State
NWMSU

delta
Pittsburg State Football
Pittsburg State
Gorillas
PITTST

delta
Southwest Baptist Football
Southwest Baptist
SBU

delta
Central Missouri Football
Central Missouri
Mules
UCMO

delta
Central Oklahoma Football
Central Oklahoma
Bronchos
UCO

delta
Nebraska-Kearney Football
Nebraska-Kearney
Lopers
UNK

delta
Washburn Football
Washburn
Ichabods
WU

delta
Assumption Football
Assumption
AC

delta
American International Football
American International
AIC

delta
Bentley Football
Bentley
BU

delta
Long Island University C.W. Football
Long Island University C.W.
LIUCWP

delta
Merrimack Football
Merrimack
MC

delta
Pace Football
Pace
Setters
PU

delta
Saint Anselm Football
Saint Anselm
Anselm Hawks
SAC

delta
Southern Connecticut State Football
Southern Connecticut State
SCSU

delta
Stonehill Football
Stonehill
STHL

delta
New Haven Football
New Haven
UNH

delta
Augustana Football
Augustana
AUG

delta
Bemidji State Football
Bemidji State
BSTU

delta
Concordia Football
Concordia
CONU

delta
Minnesota State Football
Minnesota State
MNST

delta
Minot State Football
Minot State
MSTU

delta
Minnesota State Moorhead Football
Minnesota State Moorhead
MSUM

delta
Northern State Football
Northern State
NSTU

delta
St. Cloud State Football
St. Cloud State
SCSTU

delta
Sioux Falls Football
Sioux Falls
SF

delta
Southwest Minnesota State Football
Southwest Minnesota State
SWMSU

delta
Upper Iowa Football
Upper Iowa
Peacocks
UIU

delta
University of Mary (ND) Football
University of Mary (ND)
UMARY

delta
Minnesota-Crookston Football
Minnesota-Crookston
UMC

delta
Minnesota-Duluth Football
Minnesota-Duluth
UMD

delta
Wayne State (NE) Football
Wayne State (NE)
WSTU

delta
Winona State Football
Winona State

delta
Azusa Pacific Football
Azusa Pacific
APU

delta
Central Washington Football
Central Washington
CWU

delta
Dixie State Football
Dixie State
Red Storm
DSU

delta
Humboldt State Football
Humboldt State
Lumberjacks
HUMST

delta
Simon Fraser Football
Simon Fraser
Clan
SFU

delta
Western Oregon Football
Western Oregon
WOU

delta
Bloomsburg Football
Bloomsburg
BLOOM

delta
Clarion Football
Clarion
CLARU

delta
California University of PA Football
California University of PA
Vulcans
CUP

delta
Cheyney Football
Cheyney
CUPA

delta
East Stroudsburg Football
East Stroudsburg
ESUPA

delta
Edinboro Football
Edinboro
Fighting Scots
EU

delta
Gannon Football
Gannon
Golden Knights
GU

delta
Indiana University of PA Football
Indiana University of PA
Norm
IUPA

delta
Kutztown Football
Kutztown
KUTZU

delta
Lock Haven Football
Lock Haven
Bald Eagles
LHU

delta
Mercyhurst Football
Mercyhurst
MHU

delta
Millersville (PA) Football
Millersville (PA)
MUPA

delta
Shippensburg Football
Shippensburg
Raiders
SHIPU

delta
Seton Hill Football
Seton Hill
Griffins
SHU

delta
Slippery Rock Football
Slippery Rock
The Rock
SRU

delta
West Chester Football
West Chester
WCUPA

delta
Adams State Football
Adams State
Grizzlies
ADAMS

delta
Black Hills Football
Black Hills
BHSU

delta
Colorado Mesa Football
Colorado Mesa
COMU

delta
Chadron Football
Chadron
CSC

delta
Colorado School of Mines Football
Colorado School of Mines
Orediggers
CSM

delta
Colorado State Pueblo Football
Colorado State Pueblo
ThunderWolves
CSUP

delta
Fort Lewis Football
Fort Lewis
FLC

delta
New Mexico Highlands Football
New Mexico Highlands
NMHU

delta
Western New Mexico Football
Western New Mexico
WNMU

delta
Western State College Colorado Football
Western State College Colorado
WSCU

delta
Brevard Football
Brevard
Tornados
BVDC

delta
Catawba Football
Catawba
Indians
CATC

delta
Carson-Newman Football
Carson-Newman
CNU

delta
Lenoir-Rhyne Football
Lenoir-Rhyne
LRU

delta
Mars Will Football
Mars Will
MHC

delta
Newberry Football
Newberry
NEWC

delta
Tusculum Football
Tusculum
TC

delta
Wingate Football
Wingate
WGU

delta
Albany State (GA) Football
Albany State (GA)
ASUG

delta
Benedict Football
Benedict
BENC

delta
Clark Atlanta Football
Clark Atlanta
CAU

delta
Central State (OH) Football
Central State (OH)
CSO

delta
Fort Valley State Football
Fort Valley State
FVSU

delta
Kentucky State Football
Kentucky State
Thorobreds
KYSU

delta
Lane Football
Lane
LANE

delta
Miles Football
Miles
MILES

delta
Morehouse Football
Morehouse
Maroon Tigers
MRHC

delta
Stillman Football
Stillman
STMC

delta
Tuskegee Football
Tuskegee
Golden Tigers
TUSKU

delta
Concord Football
Concord
Mountain Lions
CNCD

delta
Fairmont Football
Fairmont
Fighting Falcons
FSTU

delta
Glenville Football
Glenville
GSC

delta
Notre Dame College Football
Notre Dame College

delta
Sheperd Football
Sheperd
SHEP

delta
Charleston (WV) Football
Charleston (WV)
UC

delta
Urbana Football
Urbana
Blue Knights
URB

delta
Virginia-Wise Football
Virginia-Wise
Highland Cavaliers
UVW

delta
West Liberty State Football
West Liberty State
WLU

delta
West Virginia State Football
West Virginia State
WVS

delta
West Virginia Wesleyan Football
West Virginia Wesleyan
WVWC

delta
Louisville Cardinals Football
Louisville
LVILLE

delta
Rutgers Football
Rutgers
Scarlet Knights
RUTG

delta
South Florida Bulls Football
South Florida
USF

delta
Cincinnati Bearcats Football
Cincinnati
CIN

delta
UConn Football
Connecticut
CONN

delta
Memphis Tigers Football
Memphis
MEM

delta
UCF Knights Football
UCF
Knights

delta
Houston Cougars Football
Houston
HOU

delta
SMU Mustangs Football
Southern Methodist
SMU

delta
Temple Football
Temple
TEM

new = Tag.find_by_permalink("college-football").teams.map do |t|
[t.name, t.short_name, t.nav_name, t.city_name, t.mascot_name, t.abbreviation].uniq.compact.map do |a|
if a.match(/ /)
[a, a.split(' ')]
else
a
end
end
end.flatten

aa = Hash[new.map{|a| [a, new.count(a)]}]

dups = Hash[aa.select {|a| a[1] >1 }].keys

Tag.find_by_permalink("college-football").teams.each do |t|

new = [t.name, t.short_name, t.nav_name, t.city_name, t.mascot_name, t.abbreviation].uniq.compact

puts "delta"

new.each do |n|
puts n unless (t.positive_keywords.map{|a| a.keyword} + dups).include?(n)
t.twitter_keywords.create(:keyword => n, :positive => true) unless (t.positive_keywords.map{|a| a.keyword} + dups).include?(n)
end

puts
end

Tag.find_by_permalink("college-football").teams.map{|a| a.twitter_keywords}.flatten.count
648