Automating the Auditing Process for the Travis County District Clerk's Office

I am working with the Travis County District Clerk's Office for my capstone project. They maintain the official records of all court proceedings heard in the District Courts. This includes civil, civil, and family relations cases. All these records are audited to check whether the information is in the correct order and that all the necessary forms are present in the system. I worked on automating the process of auditing the documents to reduce the manual intervention in the process. The tool is developed using Python and SQL is used to query the database to find the cases that have any anomalies and to find a solution that makes it easier for the clerks to identify such mistakes.