Random Mass Perspectives
Mass public shootings (MPS) are not random, despite appearances. Though the Gun Facts Project has uncovered some amazing insights about these events, some induced downtime gave us leisure to explore niches in the MPS data… and we uncovered some new perspectives. The Big Database Bust At Gun Facts, we have an internal project to warehouse crime data and other data for rapid recall and creative exploration. During the conceptualization phase, the project was jokingly named “Data Whore.” Unfortunately, the name stuck. We had loaded the old FBI Uniform Crime Reports going back to the 1980s with county-level demographic and population numbers, had built a few handy data views (SQL views for our fellow geeks), and more. Then the database crashed, got massively corrupted, and led to a week-long recovery and migration to a new database technology that isn’t as prone to failure under massive operations (we were deleting 22M rows … Continue reading →