Tag Archives: social media analysis

WATCH Blue Get the Last Word: The 2015 NCAA Men’s Basketball Championship

Following up on the successful post visualizing  live Tweets pertaining to the Final Four matchup between undefeated Kentucky and Wisconsin, this writer decided to take it one step further and to portray the Twitter fandom of Duke Nation and Badger Nation during last night’s National Championship game. If you succumbed to your early bedtime, the blue that fills the interactive map at the end of the animation should amply suggest who the victor was!

Each of the 54,625 randomly mined Tweets had to contain at least one of the following inherently pro-Duke or pro-Wisconsin keyword: “GoWisconsin,” “GoWisconsinBadgers,” “GoBadgers,” “BadgerNation,” “BadgersBelieve,” “FrankTheTank,” “DukeNation,” “OkaforWins,” “GoDuke,” “GoDukeBlueDevils,” “GoBlueDevils,” and “BlueDevilNation.” Those Tweets, which had been collected using the filterStream function of the R statistical computing language, were then filtered down to 2,409 randomly geocoded Tweets (Tweets whose locations could be derived). Finally, each Tweet was categorized as being pro-Duke or pro-Wisconsin before being inputted into a web mapping platform called CartoDb. In the end, Duke Nation can lay claims to being more excited on Twitter during last night’s game, broadcasting 1,724 messages versus Badger Nation’s 685 in this random sample of geocoded Tweets – another reason for the Blue Devil haters out there to hate! The final data set can be accessed here: DukeWisLVantData.

The following excerpts from the Guardian’s minute-by-minute commentary of the match can be a helpful guide to the map. Pause the video at the indicated times to see how the match’s real-time twists and turns had an impact on real-world social media behavior:

 9:21 PM ET – Kaminsky hits a long three and then takes a charge. HEY! Stop stealing Duke’s game, thief!

9:43 PM ET – Duke has its biggest lead of the game, 21-16, with a little over 8 minutes left in the half.

9:51 PM ET – Wisconsin 24, Duke 23 / 4:47 left in the half

The Badgers are on a run – 7 unanswered – capped by Kaminsky making and and-1. When Kaminsky finished his play, CBS showed a bar in Madison with tons of people drinking.

10:25 PM ET – The second half is underway. Wisconsin starts with the ball and … takes a 34-31 lead on a corner three by Koenig.

10:28 PM ET – Wisconsin 38, Duke 33 / 18:32 left

Coach K calls a timeout after Dekker scores off a Duke turnover. The Blue Devils look sloppy coming out of the half. How is that possible? They just were coached up by the great Mike Krzyzewski for 15 minutes.

10:40 PM ET – Wisconsin 46, Duke 39 / 13:55 left

Koenig hits another three to give Wisconsin its biggest lead.

And Dekker still hasn’t hit a three in the game. Very bad for Duke. (Good for America?)

10:46 PM ET – Wisconsin 51, Duke 45 / 11:43 left

Grayson Allen is keeping Duke in the game. If he doesn’t go pro, he will enjoy a long college career of being despised by adults all across the country.

10:50 PM ET – Grayson Allen has scored the last 8 points for Duke. Grayson Allen sounds like the name of trust fund son of an attorney. It’s a very Duke name.

11:04 PM ET – We’re tied at 56 with less than 5 minutes left. Yes, this will do nicely. Thank you, sports.

11:13 PM ET – Duke 63, Wisconsin 58 / 2 minutes left

Back-to-back buckets for Okafor after sitting out for six minutes. He was out for so long, he apparently forgot he was having a bad game.

11:22 PM ET – Duke 68, Wisconsin 63 / 14.9 left

After Tyus Jones hit two free throws, Wisconsin had an awful offensive possession, ran down a ton of clock and then threw up an airball from the top of the key. Prepare for another Duke title.