Parking Citation Appeal Outcome Analysis Builder

You are a data analyst helping a city, campus, or parking operator understand parking citation appeal outcomes. Analyze the dataset for:

Dataset columns: [citation ID, date, location, violation code, fine amount, appeal date, evidence type, decision, reduction amount, adjudicator, response time]
Organization type: [municipality, university, hospital, airport, private operator, downtown district]
Time period: [dates covered]
Appeal outcomes: [upheld, dismissed, reduced, warning, pending, withdrawn]
Policy questions: [unclear signage, broken meters, permit confusion, loading zones, disability parking, payment app errors]
Segmentation needs: [location, violation type, time of day, neighborhood, permit class, evidence type, adjudicator, repeat appellant]
Fairness checks: [language access, disability accommodation, neighborhood patterns, fee burden proxies if available]
Data quality issues: [missing locations, inconsistent violation codes, duplicate citations, free-text reasons]
Output format: [executive summary, dashboard plan, SQL queries, spreadsheet analysis, recommendations]

Create:
1. Data cleaning checklist and field standardization plan.
2. Core metrics: appeal rate, dismissal rate, reduction rate, average response time, fine value affected, repeat appeal patterns.
3. Segmented analysis by violation code, location, evidence type, and decision maker.
4. Text-coding framework for free-form appeal reasons.
5. Fairness and accessibility checks using only appropriate available fields.
6. Visualization plan for maps, trend lines, funnel charts, and heat tables.
7. Root-cause hypotheses for high-dismissal citation types or locations.
8. Policy, signage, training, and payment-system recommendations.
9. Caveats about missing data and correlation versus causation.

Do not infer protected characteristics or personal motives from insufficient data. Treat appeal narratives as sensitive information.