Andrew McGill

squared-maps. Automates making hipster square cartograph maps.

trump-twitter-classify. Uses a Naive Bayes classifier to detect whether Trump has authored a given @RealDonaldTrump tweet.

mirai-honeypot. A fake IoT toaster that mimics a login procedure on port 23 with the hopes of recording hacking attempts.

serendipity-bot. Asks Slack users what cool things they're up to so it can share them with the rest of the team.

bill-peduto-bot. A Twitter bot sharing Mayor Bill Peduto's schedule and Pittsburgh artifacts

she-not-he. Politely corrects Twitter users who refer to Caitlyn Jenner as a "he" instead of a "she."

pgh-crime-blotter. Scrapes and displays Pittsburgh Bureau of Police incident data

wheresbill. A scraper that helps track Pittsburgh mayor Bill Peduto's public schedule

pgh-ALPR-records. CSV of license plates scanned in August 2013 by the Pittsburgh Parking Authority.

presidential-nominees-scraper. Scrapes Congress.gov to pull vote data for confirmed presidential nominees from 1981 to present.

dmv. Scrapes the D.C. Department of Motor Vehicles' waiting room webcams to gather information on crowd patterns.

atlantic-tik-tok. An alternative way to read The Atlantic, modeled after TikTok.

omniture-slackbot. A bot for Slack that supplies traffic statistics from Omniture on demand.

mcu.ninja. Use Quicksort to definitively rank your favorite Marvel Cinematic Universe movies (and maybe other stuff?)

tween-titans. JavaScript

guess-graph. An interactive graph that challenges people to draw their best guess at a trend, and then shows them reality.

silverpop-node. Wrapper for the IBM Engage (Silverpop) XML API.

atlantic-timeline-share-cards. Bookmarklet proof-of-concept for programmatically generating share cards for The Atlantic's timeline project

atlantic-door-camera. Handles a Slack slash command and sends a picture via a Raspberry Pi.

atlantic-share-image-generator. Makes text-only cards for stories that don't have ready imagery.

slack-doorbell. Connects an Amazon Internet of Things button to a Slack channel to alert an office when one of their coworkers is locked out.

cherrypicker. Connects people to their closest Washington, D.C. cherry tree.

sweetgreen-button. An Amazon IoT button script for on-demand Sweetgreen ordering.

ads-game. Demonstrating how impossible it is to avoid campaign ads in battleground states

donor-compare. Calculates and displays the contributors shared between the U.S. presidential candidates of 2008, 2012 and 2016

jon-stewart-guests. Visualization showing the last 600-odd guests on The Daily Show, with options to filter.

2016-travel-tracker. An app monitoring where candidates for the 2016 presidential election have traveled.

omniture-loves-sheets. Module that takes a Google spreadsheet of story names, pulls Omniture stats and plops them back in the spreadsheet.

DHS-budget. A visualization comparing the relative size of the Department of Homeland Security appropriations bill to the amendments that are dooming it in the Senate.

washington-dc-income. Visualizes the relative wealth (and poverty) of Washington, D.C. by comparing it to the rest of the country.