Alberta Legal Clinics — Summary Advice Evaluation
Alberta Law Foundation
Alberta’s legal clinics give clients summary advice: a short appointment that helps someone understand a legal problem and what to do next. The Alberta Law Foundation, which funds the clinics, wanted to know whether that advice worked. The answer was in client surveys taken at the appointment and again at follow-up.
The problem with the raw data
Each clinic’s surveys arrived as spreadsheets. Clinic and location names were spelled several ways, legal problems were described in free text, and a bad row could quietly disappear in a copy-and-paste. Comparing clinics, or linking an initial survey to its follow-up, meant cleaning everything by hand every time.
What the application did
Surveys were uploaded in numbered batches and parsed in the database. Every answer was validated by check constraints, and rows that failed were kept in an error log with their own review page rather than dropped. Clean-up functions standardised clinic and location values, and a scheduled job mapped legal problems onto a category list that administrators maintained, with a page listing anything still unmapped.
On top of the cleaned data sat 116 charts: who the clients were, what legal problems they brought, how long appointments took, whether clients followed the advice, and what they did next. Each user saw only the clinics they had been granted.
Status
The application was in use from 2021 to 2023 and has since been retired.