What you’re seeing: one CityReportTotal “truth row” per city_key (current report card).
Traffic totals: all-time bytes/URLs from CityTrafficTotal (best-effort enrich).
Peers: top orgs / ASNs tag cloud from CityOrgTotal + CityAsnTotal (rollup).
Order: risk-first directory (risk_score desc), then freshness, then volume.
CityReportTotal contains rows for the latest publish.