Per-column QA battery on the silver Real-Estate-Master (REM) snapshot the features read as-of T0.
| # | ID | Audit | Counties failing |
|---|
Colour: green clean (0) · yellow ≤ 1,000 records · red > 1,000 records (drag the Yellow ≤ slider to move the line). A check PASSES only when it hits the expected value exactly (0, or ratio 1.00); yellow flags a real-but-small miss worth a glance, red a material gap. Many fails are known source realities (coverage gaps, sentinels) rather than ETL corruption — the immutable-field defects (G1 YearBuilt) are the ones to chase first. Open the Audits tab for plain-words + the exact query per check.
Colour: green 0 · yellow ≤ 1,000 records · red > 1,000 records. Click any row to read it in plain words + copy the Athena/Trino query (it carries the active property-type filter). Numbers are pinned to the snapshot for the selected property type.
| Column | Type | Meaning |
|---|
Full FA field definitions: resources › FA › Assessor.
Read-only audit. Chip numbers computed locally (DuckDB over the committed silver_rem snapshot, no AWS) per property-type bucket; the copy-paste queries are the Athena/Trino equivalents against "8020rei-silver-data-lake"."real_estate_master_v1" (partitions fips + period, verified live) and carry the active lower(usetype) filter. The live lake re-commits, so Athena counts may differ slightly. Reproduce locally: uv run python scripts/roofing/silver_qa/qa_silver_assessor.py then build_silver_qa_dashboard.py.