OR Union Contracts

Company: Freedom Foundation
Year Built: 2020
Planet Kodiak tasks: Application Architecture, Database Design, WordPress Plugin Development, Security
Technologies Used: WordPress, PHP, PDF Library, JavaScript, Database Indexing

Freedom Foundation wanted to create an index of every contract between government employers and labor unions representing public employees in Oregon State.

With this site, I extended an existing WordPress plugin I had created for them that allows Freedom Foundation to upload PDFs of every contract, and make every word indexable and searchable. This robust search engine includes nearly 2,000 contracts—plus 3,000 contracts for Washington State—and allows users to filter contracts based on keywords, combinations of keywords, effective dates, employer types, employer names, locations, and unions. I also built is a powerful relevance algorithm used to ensure highest quality results appear first.