I created the website and database for The PUC Papers through nonprofit Consumer Watchdog and other organizations in April of 2016. Built on a Apache SOLR Lucerne backend with Open Search Server performing OCR and indexing over 150,000 files input into a MySQL database with a custom WordPress template was used as a search front end. Super fast, and even more secure. The PUC Papers scandal was covered in both state and national news with this website being a incredibly large source for information. For more information see The PUC Papers
The California Public Utilities Commission corruption scandal resulted in hundreds of thousands of PDF, excel and various other documents being put into the public domain through the Public Records Act. The website PUCPapers.org allows you to search through all these documents that expose new webs of corruption between state energy regulators and the energy industry they regulate.