The Environmental Council of States is a national non-profit, non-partisan association of state environmental agency leaders. They needed a database portal for individuals in state agencies to better find projects that their colleagues in other states were doing. The inventory of projects included over 700 records.
I designed and built a dynamic table interface to allow anyone with web access to look up these records and filter by state, year, and category. All the information needed to be imported form a giant spreadsheet into a custom post type that allowed data to be easily edited in the backend.