NCAA BB

gistfile1.txt

delta
Florida Gators Basketball
Florida
UF

delta
Tennessee Volunteers Basketball
Tennessee
TENN

delta
Georgia Bulldogs Basketball
Georgia
UGA

delta
Kentucky Wildcats Basketball
Kentucky
UK

delta
South Carolina Basketball
South Carolina
SCAR

delta
Vanderbilt Basketball
Vanderbilt
Commodores
VAN

delta
Arkansas Razorbacks Basketball
Arkansas
ARK

delta
Auburn Basketball
Auburn
AUB

delta
LSU Basketball
LSU

delta
Alabama Crimson Tide Basketball
Alabama
Crimson Tide
ALA

delta
Ole Miss Basketball
Mississippi
Rebels
MISS

delta
Mississippi State Basketball
Mississippi State
MSST

delta
Missouri Tigers Basketball
Missouri
MIZZ

delta
Texas A&M Basketball
Texas A&M
TA&M

delta
Wake Forest Basketball
Wake Forest
Demon Deacons
WAKE

delta
Boston College Basketball
Boston College
BC

delta
Maryland Terrapins Basketball
MD

delta
Clemson Basketball
Clemson
CLEM

delta
Florida State Basketball
Florida State
Seminoles
FSU

delta
NC State Basketball
NC State
North Carolina State
Wolfpack
NCST

delta
Georgia Tech Basketball
Georgia Tech
Yellow Jackets
GT

delta
Virginia Tech Basketball
Virginia Tech
Hokies
VT

delta
UVA Basketball
Virginia
Cavaliers
UVA

delta
Miami Hurricanes Basketball
Miami
Hurricanes
MIA

delta
UNC Basketball
North Carolina
UNC

delta
Duke Basketball
DUKE

delta
Pitt Basketball
Pittsburgh
PITT

delta
Syracuse Basketball
Orange
SYR

delta
Notre Dame Basketball
ND

delta
Kansas State Basketball
Kansas State
KSU

delta
Kansas Jayhawks Basketball
Kansas
KU

delta
Iowa State Basketball
Iowa State
Cylcones
ISU

delta
Oklahoma Sooners Basketball
Oklahoma
Sooners
OKLA

delta
Texas Longhorns Basketball
Texas
TEX

delta
Texas Tech Basketball
Texas Tech
Red Raiders
TTU

delta
Oklahoma State Basketball
Oklahoma State
OKST

delta
Baylor Basketball
Baylor
BAY

delta
WVU Basketball
WVU

delta
TCU Basketball
TCU
Horned Frogs

delta
Georgetown Basketball
GTWN

delta
DePaul Basketball
DePaul
Blue Demons
DEP

delta
Seton Hall Basketball
Seton Hall
HALL

delta
Providence Friars Basketball
Providence
Friars
PROV

delta
Marquette Basketball
Marquette
MARQ

delta
Villanova Basketball
Villanova
VILL

delta
St John's Basketball
St John's
Red Storm
SJU

delta
Xavier Basketball
Xavier
Musketeers
XAV

delta
Butler Basketball
Butler
BUT

delta
Creighton Basketball
Creighton
Bluejays
CREI

delta
Nebraska Huskers Basketball
Nebraska
Huskers
NEB

delta
Ohio State Basketball
OSU

delta
Wisconsin Badgers Basketball
Wisconsin
WIS

delta
Michigan Wolverines Basketball
Michigan
MICH

delta
Penn State Basketball
Penn State
Nittany Lions
PSU

delta
Purdue Basketball
Purdue
Boilermakers
PUR

delta
Minnesota Golden Gophers Basketball
Minnesota
Golden Gophers
MINN

delta
Indiana Hoosiers Basketball
Indiana
Hoosiers
IND

delta
Iowa Hawkeyes Basketball
Iowa
Hawkeyes
IOWA

delta
Northwestern Basketball
Northwestern
NU

delta
Michigan State Basketball
MSU

delta
Illinois Fighting Illini Basketball
Illinois
Fighting Illini
ILL

delta
Wyoming Cowboys Basketball
Wyoming
WYO

delta
New Mexico Lobos Basketball
New Mexico
Lobos
UNM

delta
Air Force Basketball
Air Force
AFA

delta
San Diego State Basketball
San Diego State
Aztecs
SDSU

delta
Colorado State Basketball
Colorado State
CSU

delta
UNLV Basketball
UNLV
Runnin' Rebels

delta
Boise State Basketball
Boise State
BSU

delta
San Jose State Basketball
San Jose State
SJSU

delta
Nevada Wolf Pack Basketball
Nevada
Wolf Pack
NEV

delta
Fresno State Basketball
Fresno State
FRES

delta
Utah State Basketball
Utah State
USU

delta
Colorado Buffaloes Basketball
Colorado
Buffaloes
COL

delta
Utah Utes Basketball
Utah
Utes
UTAH

delta
USC Basketball
USC

delta
Cal Bears Basketball
California
CAL

delta
Oregon State Basketball
ORST

delta
UCLA Basketball

delta
Oregon Ducks Basketball
Oregon
Ducks
ORE

delta
Arizona State Basketball
Arizona State
Sun Devils
ASU

delta
Arizona Wildcats Basketball
Arizona
ARIZ

delta
Washington State Basketball
Washington State
WSU

delta
Washington Huskies Basketball
Washington
WASH

delta
Stanford Basketball
Cardinal
STAN

delta
Idaho Vandals Basketball
Idaho
Vandals
IDHO

delta
New Mexico State Basketball
New Mexico State
NMSU

delta
UMKC Basketball
UMKC
Kangaroos

delta
Chicago State Basketball
Chicago State
CHI ST

delta
Cal State Bakersfield Basketball
CS Bakersfield
Cal State Bakersfield
CSB

delta
Seattle RedHawks Basketball
Seattle
SEA

delta
Texas-Pan American Basketball
Texas-Pan American
UTPA

delta
Utah Valley Basketball
Utah Valley
UVU

delta
Grand Canyon Antelopes
Antelopes
Grand Canyon

delta
Penn Basketball
Penn
Quakers
PENN

delta
Yale Basketball
Yale
YALE

delta
Cornell Basketball
Cornell
Big Red
COR

delta
Columbia Basketball
Columbia
CLMB

delta
Brown Bears Basketball
Brown
BRWN

delta
Harvard Basketball
Harvard
Crimson
HARV

delta
Dartmouth Basketball
Dartmouth
Big Green
DART

delta
Princeton Basketball
Princeton
PRIN

delta
UMass Basketball
Massachusetts
Minutemen
MASS

delta
GW Basketball
George Washington
GW

delta
Fordham Basketball
Fordham
FOR

delta
Rhode Island Rams Basketball
Rhode Island
URI

delta
St Joseph's Basketball
Saint Joseph's
JOES

delta
Dayton Basketball
Dayton
Flyers
DAY

delta
Saint Louis Billikens Basketball
Saint Louis
Billikens
SLU

delta
Duquesne Basketball
Duquesne
DUQ

delta
Richmond Spiders Basketball
Richmond
Spiders
RICH

delta
St. Bonaventure Basketball
St. Bonaventure
Bonnies
SBON

delta
La Salle Basketball
La Salle
Explorers
LAS

delta
Virginia Commonwealth Basketball
VCU
Virginia Commonwealth

delta
George Mason Basketball
George Mason
Patriots
GMU

delta
BYU Basketball
Brigham Young
BYU

delta
Gonzaga Basketball
Gonzaga
GONZ

delta
Santa Clara Basketball
Santa Clara
SCU

delta
Saint Mary's Basketball
Saint Mary's
SMC

delta
San Francisco Dons Basketball
San Francisco
Dons
SF

delta
San Diego Toreros Basketball
San Diego
Toreros
USD

delta
Loyola Marymount Basketball
Loyola Marymount
LMU

delta
Portland Pilots Basketball
Portland
Pilots
PORT

delta
Pepperdine Basketball
Pepperdine
Waves
PEPP

delta
Pacific Tigers basketball
Pacific
PAC

delta
Louisiana Tech Basketball
Louisiana Tech
LT

delta
Charlotte 49ers Basketball
Charlotte
CHAR

delta
Southern Miss Golden Basketball
Southern Miss
USM

delta
Tulsa Golden Hurricanes Basketball
Tulsa
Golden Hurricane
TLSA

delta
Tulane Basketball
Tulane
Green Wave
TULN

delta
Rice Owls Basketball
Rice
RICE

delta
UAB Basketball
UAB
Blazers

delta
Marshall Basketball
Marshall
Thundering Herd
MRSH

delta
UTEP Basketball
UTEP
Miners

delta
East Carolina Basketball
East Carolina
ECU

delta
Old Dominion Basketball
Old Dominion
Monarchs
ODU

delta
Middle Tennessee State Basketball
Middle Tenn State
Middle Tennessee State
Blue Raiders
MTU

delta
Florida Atlantic Basketball
Florida Atlantic
FAU

delta
Florida International Basketball
FL Internationial
Florida International
Golden Panthers
FIU

delta
North Texas Basketball
North Texas
Mean Green
UNT

delta
Texas at San Antonio
UTSA

delta
Oral Roberts Basketball
Oral Roberts
ORU

delta
New Orleans Privateers Basketball
New Orleans
Privateers
UNO

delta
Houston Baptist Basketball
Houston Baptist
HBU

delta
Central Arkansas Basketball
Central Arkansas
CARK

delta
Lamar Basketball
Lamar
LAM

delta
McNeese State Basketball
McNeese State
MCNS

delta
Nicholls State Basketball
Nicholls State
NICH

delta
Northwestern State Basketball
Northwestern State
Demons
NWST

delta
Sam Houston State Basketball
Sam Houston State
Bearkats
SHSU

delta
Southeastern Louisiana Basketball
SE Louisiana
Southeastern Louisiana
SELA

delta
Stephen F. Austin Basketball
Stephen F. Austin
SFA

delta
Texas A&M-CC Basketball
Texas A&M-CC
Islanders
AMCC

delta
Abilene Christian Wildcats Basketball
Abilene Christian

delta
Incarnate Word Cardinals
Incarnate World

delta
Kent State Basketball
Kent State
Golden Flashes
KENT

delta
Ohio Bobcats Basketball
Ohio
OHIO

delta
Miami Redhawks Basketball
Miami (OH)
M-OH

delta
Akron Zips Basketball
Akron
Zips
AKR

delta
Bowling Green Basketball
Bowling Green
BGSU

delta
Ball State Basketball
Ball State
BALL

delta
Buffalo Bulls Basketball
Buffalo
BUFF

delta
Central Michigan Basketball
Central Michigan
Chippewas
CMU

delta
Eastern Michigan Basketball
Eastern Michigan
EMU

delta
Northern Illinois Basketball
Northern Illinois
NIU

delta
Toledo Basketball
Toledo
Rockets
TOL

delta
Western Michigan Basketball
Western Michigan
WMU

delta
North Carolina-Wilmington Basketball
UNC Wilmington
North Carolina-Wilmington
UNCW

delta
William & Mary Basketball
William & Mary
Tribe
W&M

delta
Delaware Basketball
Delaware
Fightin' Blue Hens
DEL

delta
Northeastern Basketball
Northeastern
NE

delta
Hofstra Basketball
Hofstra
Pride
HOF

delta
Towson Basketball
Towson
TOWS

delta
James Madison Basketball
James Madison
JMU

delta
Drexel Basketball
Drexel
Dragons
DREX

delta
Charleston Basketball
Charleston
COFC

delta
UMBC Basketball
UMBC
Retrievers

delta
Albany Basketball
Albany
Great Danes
ALBY

delta
Hartford Basketball
Hartford
HART

delta
Vermont Basketball
Vermont
UVM

delta
Binghamton Basketball
Binghamton
BING

delta
New Hampshire Basketball
New Hampshire
UNH

delta
Maine Basketball
Maine
Black Bears
ME

delta
Stony Brook Basketball
Stony Brook
Seawolves
STON

delta
UMass Lowell River Hawks
River Hawks
UMass Lowell

delta
Austin Peay Basketball
Austin Peay
Governors
PEAY

delta
Murray State Basketball
Murray State
Racers
MURR

delta
Morehead State Basketball
Morehead State
MORE

delta
Tennessee-Martin Basketball
Tennessee-Martin
Skyhawks
TENM

delta
Tennessee State Basketball
Tennessee State
TNST

delta
Eastern Kentucky Basketball
Eastern Kentucky
EKY

delta
Tennessee Tech Basketball
Tennessee Tech
TNTC

delta
Southeast Missouri State Basketball
Southeast MO State
Southeast Missouri State
SEMO

delta
Eastern Illinois Basketball
Eastern Illinois
EIU

delta
Jacksonville State Basketball
Jacksonville State
JVST

delta
Belmont Basketball
Belmont
BEL

delta
SIU Edwardsville Basketball
SIU Edwardsville
SIUE

delta
IUPUI Basketball
IUPUI

delta
North Dakota State Basketball
North Dakota State
NDSU

delta
IPFW Basketball
IPFW
Mastodons

delta
Western Illinois Basketball
Western Illinois
Leathernecks
WIU

delta
South Dakota State Basketball
South Dakota State
Jackrabbits
SDST

delta
Denver Pioneers Basketball
Denver
DEN

delta
South Dakota Basketball
South Dakota
Coyotes
SDAK

delta
Nebraska-Omaha Basketball
Nebraska-Omaha
NEOM

delta
Wright State Basketball
Wright State
WRST

delta
Cleveland State Basketball
Cleveland State
CLEV

delta
Oakland Basketball
Oakland
Golden Grizzlies
OAK

delta
Valparaiso Basketball
Valparaiso
VALP

delta
Illinois-Chicago Basketball
Illinois-Chicago
UIC

delta
Wisconsin-Green Bay Basketball
Green Bay
GB

delta
UWM Basketball
Milwaukee
MILW

delta
Youngstown State Basketball
Youngstown State
Penguins
YSU

delta
Detroit Mercy Basketball
Detroit
DET

delta
Arkansas State Basketball
Arkansas State
Red Wolves
ARST

delta
Georgia State Basketball
Georgia State
GAST

delta
South Alabama Basketball
South Alabama
USA

delta
Western Kentucky Basketball
Western Kentucky
Hilltoppers
WKU

delta
Troy Basketball
Troy
TROY

delta
Arkansas-Little Rock Basketball
Ark-Little Rock
Arkansas-Little Rock
UALR

delta
Louisiana-Lafayette Basketball
LA Lafayette
Louisiana-Lafayette
Ragin' Cajuns
ULL

delta
Louisiana-Monroe Basketball
Louisiana-Monroe
Warhawks
ULM

delta
Texas State Basketball
Texas State
TXST

delta
Texas-Arlington Basketball
Texas-Arlington
UTA

delta
Central Connecticut State Basketball
Central Conn.
Central Connecticut State
CCSU

delta
Robert Morris Basketball
Robert Morris
RMU

delta
Wagner Basketball
Wagner
WAG

delta
Sacred Heart Basketball
Sacred Heart
SHU

delta
Mount St. Mary's Basketball
Mount St. Mary's
MSM

delta
Long Island Basketball
Long Island
Blackbirds
LIU

delta
Fairleigh Dickinson Basketball
Fairleigh Dickinson
FDU

delta
St. Francis (NY) Basketball
St. Francis (NY)
SFNY

delta
St. Francis (PA) Basketball
St. Francis (PA)
Red Flash
SFPA

delta
Bryant University Basketball
Bryant University
BRY

delta
Coastal Carolina Basketball
Coastal Carolina
Chanticleers
CCAR

delta
Charleston Southern Basketball
Charleston Southern
CHSO

delta
North Carolina-Asheville Basketball
UNC Asheville
North Carolina-Asheville
UNCA

delta
Winthrop Basketball
Winthrop
WIN

delta
High Point Basketball
High Point
HP

delta
Liberty Basketball
Liberty
LIB

delta
Virginia Military Basketball
Virginia Military
Keydets
VMI

delta
Radford Basketball
Radford
RAD

delta
Campbell Basketball
Campbell
Fighting Camels
CAMP

delta
Gardner-Webb Basketball
Gardner-Webb
Runnin' Bulldogs
WEBB

delta
Presbyterian Basketball
Presbyterian
Blue Hose
PRE

delta
Longwood Basketball
Longwood
Lancers
LONG

delta
Army Basketball
Army
Black Knights
ARMY

delta
Boston University Basketball
Boston University
BU

delta
American University Basketball
American University
AMER

delta
Navy Basketball
Navy
Midhsipmen
NAVY

delta
Colgate Basketball
Colgate
COLG

delta
Lehigh Basketball
Lehigh
Mountain Hawks
LEH

delta
Lafayette Basketball
Lafayette
Leopars
LAF

delta
Bucknell Basketball
Bucknell
BUCK

delta
Holy Cross Basketball
Holy Cross
HC

delta
Loyola (MD) Basketball
Loyola (MD)
Greyhounds
L-MD

delta
Davidson Basketball
Davidson
DAV

delta
Appalachian State Basketball
Appalachian State
APP

delta
Samford Basketball
Samford
SAM

delta
Chattanooga Basketball
Chattanooga
Mocs
CHAT

delta
UNC-Greensboro Basketball
UNC Greensboro
UNC-Greensboro
UNCG

delta
Elon Basketball
Elon
ELON

delta
Western Carolina Basketball
Western Carolina
WCU

delta
Georgia Southern Basketball
Georgia Southern
GASO

delta
Wofford Basketball
Wofford
WOF

delta
Furman Basketball
Furman
Paladins
FUR

delta
Citadel Basketball
Citadel
CIT

delta
Quinnipiac Basketball
Quinnipiac
QUIN

delta
Monmouth Basketball
Monmouth
MONM

delta
Rider Basketball
Rider
RID

delta
Siena Basketball
Siena
Saints
SIE

delta
Niagara Basketball
Niagara
Purple Eagles
NIAG

delta
Marist Basketball
Marist
Red Foxes
MRST

delta
Fairfield Basketball
Fairfield
Stags
FAIR

delta
Iona Basketball
Iona
IONA

delta
Manhattan Basketball
Manhattan
Jaspers
MAN

delta
St. Peter's Basketball
St. Peter's
Peacocks
SPC

delta
Canisius Basketball
Canisius
Golden Griffins
CAN

delta
Illinois State Basketball
Illinois State
Redbirds
ILST

delta
Loyola (IL) Basketball
Loyola (IL)
Ramblers
L-IL

delta
Drake Basketball
Drake
DRKE

delta
Southern Illinois Basketball
Southern Illinois
Salukis
SIU

delta
Northern Iowa Basketball
Northern Iowa
UNI

delta
Bradley Basketball
Bradley
BRAD

delta
Missouri State Basketball
Missouri State
MOSU

delta
Indiana State Basketball
Indiana State
Sycamores
INST

delta
Wichita State Basketball
Wichita State
Shockers
WICH

delta
Evansville Basketball
Evansville
Purple Aces
EVAN

delta
East Tennessee State Basketball
East Tenn State
East Tennessee State
ETENN

delta
Florida Gulf Coast Basketball
Florida Gulf Coast
FGCU

delta
Jacksonville Basketball
Jacksonville
Dolphins
JAC

delta
Kennesaw State Basketball
Kennesaw State
KENN

delta
Lipscomb Basketball
Lipscomb
Bisons
LIP

delta
Mercer Basketball
Mercer
MER

delta
North Florida Basketball
North Florida
Ospreys
UNF

delta
Stetson Basketball
Stetson
Hatters
STET

delta
USC Upstate Basketball
USC Upstate
SCUS

delta
Northern Kentucky Basketball
Northern Kentucky
Norse
NKU

delta
Southern Utah Basketball
Southern Utah
Thunderbirds
SUU

delta
Portland State Basketball
Portland State
PRST

delta
Eastern Washington Basketball
Eastern Washington
EWU

delta
Idaho State Basketball
Idaho State
Bengals
IDST

delta
Montana Basketball
Montana
Grizzlies
MONT

delta
Montana State Basketball
Montana State
MTST

delta
Northern Arizona Basketball
Northern Arizona
NAU

delta
Northern Colorado Basketball
Northern Colorado
UNCO

delta
Sacramento State Basketball
Sacramento State
SAC

delta
Weber State Basketball
Weber State
WEB

delta
North Dakota Basketball
North Dakota
Fighting Sioux
UND

delta
Hawaii Warriors Basketball
Hawaii
Warriors
HAW

delta
Cal State Fullerton Basketball
CS Fullerton
Cal State Fullerton
CSF

delta
Cal Poly Basketball
Cal Poly
CP

delta
Cal State Northridge Basketball
CS Northridge
Cal State Northridge
Matadors
CSN

delta
Long Beach State Basketball
Long Beach State
LBSU

delta
UC Davis Basketball
UC Davis
UCD

delta
UC Irvine Basketball
UC Irvine
Anteaters
UCI

delta
UC Riverside Basketball
UC Riverside
UCRV

delta
UC Santa Barbara Basketball
UC Santa Barbara
Gauchos
UCSB

delta
N.J.I.T. Basketball
NJIT
N.J.I.T.

delta
Coppin State Basketball
Coppin State
COPP

delta
North Carolina Central Basketball
NC Central
North Carolina Central
NCCU

delta
Savannah State Basketball
Savannah State
SAV

delta
Bethune-Cookman Basketball
Bethune-Cookman
COOK

delta
Delaware State Basketball
Delaware State
DSU

delta
Florida A&M Basketball
Florida A&M
FAMU

delta
Hampton Basketball
Hampton
HAMP

delta
Howard Basketball
Howard
HOW

delta
Maryland-Eastern Shore Basketball
UMD Eastern Shore
Maryland-Eastern Shore
UMES

delta
Morgan State Basketball
Morgan State
MORG

delta
Norfolk State Basketball
Norfolk State
NORF

delta
North Carolina A&T Basketball
NC A&T
North Carolina A&T
NCAT

delta
South Carolina State Basketball
SC State
South Carolina State
SCST

delta
Mississippi Valley State Basketball
Mississippi Valley State
MVSU

delta
Alabama A&M Basketball
Alabama A&M
AAMU

delta
Alabama State Basketball
Alabama State
ALST

delta
Alcorn State Basketball
Alcorn State
ALCN

delta
Arkansas-Pine Bluff Basketball
UAPB
Arkansas-Pine Bluff
Golden Lions
ARPB

delta
Grambling State Basketball
Grambling State
GRAM

delta
Jackson State Basketball
Jackson State
JKST

delta
Prairie View A&M Basketball
Prairie View A&M
Delta Devils
PV

delta
Southern University Basketball
Southern University
SOU

delta
Texas Southern Basketball
Texas Southern
TXSO

delta
Louisville Cardinals Basketball
Louisville
LOU

delta
Rutgers Basketball
Rutgers
Scarlet Knights
RUTG

delta
South Florida Bulls Basketball
South Florida
USF

delta
Cincinnati Bearcats Basketball
Cincinnati
CIN

delta
UConn Basketball
Connecticut
CONN

delta
Temple Basketball
Temple
TEM

delta
Memphis Tigers Basketball
Memphis
MEM

delta
UCF Basketball
UCF

delta
Houston Cougars Basketball
Houston
HOU

delta
SMU Basketball
Southern Methodist
SMU

new = Tag.find_by_permalink("college-basketball").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-basketball").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-basketball").teams.map{|a| a.twitter_keywords}.flatten.count
1246