Property data fields for government housing analytics
Specific BrightCat fields and products relevant to this vertical. Every field listed below is queryable through Snowflake SQL, MCP natural language, or available in the weekly flat-file delivery.
| Signal | Product | Field / Logic | What it tells you |
|---|---|---|---|
| Inventory levels | Listings | COUNT by status, province, city | Active supply measurement by geography |
| Price velocity | Listings | pricechangeamt, pricechangepct week-over-week | Rate of price movement for affordability monitoring |
| Listing-to-sold conversion | Listings + Sold | Status transitions from NEW to SOLD | Market absorption rate by region |
| Rental supply | Rentals | Active rental counts, asking rents | Rental market supply and rate tracking |
| Commercial activity | Commercial | Sale + lease volume by property class | Economic activity proxy by municipality |
| Population movement | Listings | NEW listings = outbound movement signal | Household migration patterns by postal code |
Sample query
-- Government: weekly housing inventory dashboard
SELECT province, city,
COUNT(CASE WHEN listing_status = 'NEW' THEN 1 END) AS new_this_week,
COUNT(CASE WHEN listing_status IN ('NEW','PRICE CHANGED','EXTENDED') THEN 1 END) AS total_active,
ROUND(AVG(asking_price), 0) AS avg_asking,
ROUND(MEDIAN(days_on_market), 0) AS median_dom
FROM BRIGHTCAT_LISTINGS.PRODUCT.listings_weekly
WHERE file_date = (SELECT MAX(file_date)
FROM BRIGHTCAT_LISTINGS.PRODUCT.listings_weekly)
GROUP BY province, city
ORDER BY total_active DESC;Abstract example. Exact column names provided with access provisioning.