Skip to content
This repository has been archived by the owner. It is now read-only.
Go to file
Cannot retrieve contributors at this time
49 lines (38 sloc) 3.24 KB

Philadelphia Traffic Court Public Access File

This project is the result of a Pennsylvania Right-to-Know request filed with the Philadelphia Traffic Court. Data included shows every traffic violation in the city issued since 2006. This project is the primary publication of this data, although we encourage this data to be republished elsewhere. This project also endeavors to analyze the data and consider if there is any evidence of ticket-fixing, wrongdoing, or other injustice.


Philadelphia Traffic Court made national headlines throughout 2014 as its offices were raided by the FBI and 9 current and former judges face indictments[1] on 77 counts. The behavior at issue is ticket-fixing, where a favorable ruling is traded to judges for payment or other consideration. As a result, the Pennsylvania state legislature voted to dissolve[2] the court.

The Data

Over one million court cases are included in the data set.

Year Citations
2006 116,227
2007 106,834
2008 114,647
2009 98,057
2010 84,088
2011 108,098
2012 166,805
2013 155,208
2014 (incomplete) 74,333

The original file was provided to me by CD-ROM on December 18, 2014. It was a single Excel XLSX file172,875,037 bytes with SHA-256 hash 515ccf0aebe60a8319b0ef9c2392204a43da71aa5f14913eaf49051c98dc4c4e. Because this file is cumbersome (e.g. LibreOffice is unable to open it) I have sliced it into separate tab-separated-value files using IBM's SPSS software. No other modifications have been made. For consideration to people "cloning" this project, the original file is not included in this repository but is available by request.

Get Involved

First, please star this project to get updates. Then get active by using Wikis on the right to introduce yourself as a potential collaborator and Issues to recommend tasks and analysis we can complete.

Works Cited and Bibliography

You can’t perform that action at this time.