Each subject area refreshes daily in Snowflake. Ad hoc requests for filings by case type, location, time frame, or other criteria that once required staff to pull together information manually can now be answered in minutes, even when a question depends on multiple types of court data.
Murder trials, for example, are among the court's most resource-intensive cases. Understanding how that workload is distributed requires knowing where pending murder trials are concentrated. That analysis requires both charge data to identify murder cases and hearing data to determine which have trials scheduled in the future. Before the warehouse, producing that analysis would have been extremely difficult, if not impossible. Now the analytics team can answer that kind of question quickly and give leadership a much clearer picture of the workload.
The warehouse has opened other kinds of analysis as well. When the court audits whether arraignments occur within statutory deadlines, the analytics team can now easily combine hearing information with arrest-date data that wasn’t readily accessible before the warehouse.
A change in state law created another recurring reporting need: a new type of court was created, and the analytics team needed to identify cases associated with specific charges to determine appropriate court staffing levels. The analytics team previously relied on a cumbersome process that involved converting and combining PDFs. With charge-level data available in Snowflake, the team can now identify those cases directly through a single query.
