Visualizing a Year of @realDonaldTrump

By Matt Stiles | | Topics: Policy & Politics, Social Media

President Trump thumbed his way through another year in the White House on Twitter, compiling a good (great) collection of 2,930 touts, complaints, defenses and rants.

He left 2018 with this perplexing New Year’s Eve missive extolling the old-fashioned endurance of “Walls” and “Wheels” as one of his last.

As the message shows, the president’s twitter presence lately is crowded by an increasingly evergreen list of grievances (Democrats, Russia, fake news, etc). Still, plenty of his messages actually correspond quite neatly with news events.

Notice how the #maga hashtag, a political rallying cry, disappears after the midterm elections. He talks about The Wall and shutdowns in and around the shutdowns, of course. And he decries Special Counsel Robert Mueller most often around the times his former aides have appeared (and been convicted or pleaded guilty) in federal court.

These examples are obvious when plotted on a timeline with annotation:

Through it all, the president’s audience of followers grew steadily by 10 million users. He now has 56.7 million followers (me included). He’s No. 15 on that measure, according to friendorfollow.com, sandwiched between heavy hitters like @selenagomez and @britneyspears!

During 2018, @realDonaldTrump spread his tweets throughout the days of the week, with the president even finding time on the weekends to sound off:

This large collection of messages, scraped using twint, drew more than 300 million of engagements, with “likes” being most common by far. This one about North Korean leader Kim Jong Un a year ago received a whopping 475,000 likes, topping the list.

Here’s how those engagements split proportionally:

Speaking of retweets, there were 57 million in 2018. They came at the rate of 200,000 per day in some months. This popular “they-just-don’t-get-it” mashup of video clips, for example, received more than 110,000 retweets alone in July:

And, finally, as in years past, those messages were a mix of endorsements, promotions, defenses and complaints. Among the more popular keywords (sorry, no word clouds here):

You can download the data as a CSV here. Happy New Year!

Charting First-Round NFL Draft Picks

By Matt Stiles | | Topics: Sports

More than 1,600 players have been selected in the first round of the NFL draft since 1936, according to league statistics. These charts break down the choices made by NFL teams by school, position and position type.

First, by school:

And by position type:

And, finally, by position:

Data source: NFL.com | Scraping script

Thanks, Chris Amico, for scraping help.

UPDATE: Here’s a new chart with position types grouped: