Data
Data traceability
Every metric on Hereabouts is traced from its original source through the full medallion pipeline: bronze, silver, gold, and served. Select a data source below to see the complete path.
Property Price Register
Property Services Regulatory Authority (PSRA)
Weekly ZIP download ppr_sales.py
Pipeline Flow
Bronze
ppr_transactions
Raw ingested data
Silver
silver_ppr_clean
Cleaned & transformed
Gold
Tables produced
silver_ppr_by_countysilver_ppr_by_leasilver_ppr_by_townsilver_ppr_monthly_by_countysilver_ppr_monthly_by_leasilver_ppr_monthly_by_townsilver_ppr_rolling_by_countysilver_ppr_rolling_by_leasilver_ppr_rolling_by_towngold_national_summarygold_recent_activity
Served
API endpoints
/national/summary/area/{level}/{slug}/summary/area/{level}/{slug}/sales/area/{level}/{slug}/yield/rankings/discover
7 Metrics derived from this source
Median Sale Price
National ReportCounty ReportCounty StatLEA StatTown Stat
silver_ppr_clean silver_ppr_rolling_by_{county|lea|town} median_price_12m
Bronze Raw CSV from PPR — price as text with € and comma separators
Silver Price stripped of € and , and cast to NUMERIC. Address geocoded via gold.geography_registry substring match. VAT-exclusive flag preserved.
Gold PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY price_eur) FILTER (WHERE date_of_sale >= CURRENT_DATE - INTERVAL '12 months'), grouped by area. True trailing-12-month window, not a calendar-year bucket -- see silver_ppr_rolling_by_county.sql. The older silver_ppr_by_{county|lea|town} tables (calendar sale_year) still back the 5-year trend chart only.
Sales Volume (12-month rolling)
National ReportCounty StatLEA StatTown Stat
silver_ppr_clean silver_ppr_rolling_by_{county|lea|town} total_sales_12m
Silver COUNT(*) of valid sales records mapped to area
Gold COUNT(*) FILTER (WHERE date_of_sale >= CURRENT_DATE - INTERVAL '12 months'), grouped by area. True rolling 12-month count.
YoY Price Change
County StatLEA StatTown Stat
silver_ppr_clean silver_ppr_rolling_by_{county|lea|town} yoy_change_pct
Gold silver_ppr_rolling_by_{county|lea|town} carries both median_price_12m (trailing 12 months) and median_price_prev_12m (the 12 months before that). yoy_change_pct = ((median_price_12m - median_price_prev_12m) / median_price_prev_12m) × 100, computed in serving API.
Average Sale Price
County StatLEA StatTown Stat
silver_ppr_clean silver_ppr_rolling_by_{county|lea|town} avg_price_12m
Gold AVG(price_eur) FILTER (WHERE date_of_sale >= CURRENT_DATE - INTERVAL '12 months'), grouped by area.
New Build Premium
County Stat
silver_ppr_clean gold_cso_rppi_by_county new_build_premium_pct
Bronze PPR raw data — VAT exclusive flag marks new builds
Silver Sales split by vat_exclusive flag. 13.5% VAT added to new build prices.
Gold (VAT-adjusted new build median - existing median) / existing median × 100.
Recent Sales Activity
County StatLEA Stat
silver_ppr_clean gold_recent_activity price, address, event_date
Bronze Latest PPR ZIP extract
Silver Parsed and geocoded records, filtered to most recent entries
Gold Most recent entries with address, price, LEA name.
Price-to-Income Ratio
County Stat
silver_ppr_clean + silver_cso_disposable_income_by_county serving API computed computed
Gold median_price_12m / median_household_income. Computed in serving API from silver_ppr_rolling_by_county and silver_cso_disposable_income_by_county.