WardSafetySnapshot

App: housing

Quarterly crime/safety snapshot for a ward. One snapshot per ward per period (idempotent upsert).

Fields

Field	Type	Description
ward	ForeignKey(Ward)	The ward this snapshot covers
period_label	CharField	Period identifier (e.g. ‘2025-Q4’)
period_start	DateField	Start date of the reporting period
period_end	DateField	End date of the reporting period
source_version	CharField	Data source identifier
overall_score	DecimalField	Composite safety score (0-10)
violent_crime_score	DecimalField	Violent crime sub-score (0-10)
property_crime_score	DecimalField	Property crime sub-score (0-10)
gang_safety_score	DecimalField	Gang safety sub-score (0-10)
burglary_score	DecimalField	Burglary sub-score (0-10)
vehicle_crime_score	DecimalField	Vehicle crime sub-score (0-10)
gang_presence	TextField	Gang presence description
reasoning	TextField	Safety assessment reasoning
tourist_relevance	CharField	Tourist relevance level
news_sentiment	CharField	News sentiment indicator
trend_direction	CharField	Crime trend direction
yoy_change_pct	DecimalField	Year-over-year change (%)
computed_at	DateTimeField	When this snapshot was computed (auto)
is_latest	BooleanField	True for the most recent snapshot per ward

Relationships

• Ward