This is the same firehose our engineering team sees. Append-only, paginated, no filtering tricks. If a defect is in the warehouse, it is in this list. ← back to audit overview
| Severity | Rule | Pillar | Field | Parcel / cluster | Where | Value summary | Detected |
|---|---|---|---|---|---|---|---|
| CRITICAL | SERVING-MAP-PROJECTION-MISSING | P0 Serving Invariants | — | — (table-wide) | — | partitioned parcels serving relation parcels_p has no complete ops.serving_snapshots version-map projection; run the rat | Sep 17, 2026, 7:24 AM UTC |
| CRITICAL | SERVING-ROWCOUNT-PARCELS-DELTA | P0 Serving Invariants | — | — (table-wide) | — | parcels_p count 289856342 changed 29.18% from previous 224373760; source=ops.serving_snapshots.row_count | Sep 17, 2026, 7:24 AM UTC |
| CRITICAL | R-SCHEMA-008 | P1 Schema & Structural | PARCEL_ENRICHED.ID | — (table-wide) | 01 | id_collision state=01 colliding_ids=37466 (same canonical uuid5 id on >1 distinct parcel; corrupts id-keyed lookup) | Sep 16, 2026, 9:23 AM UTC |
| CRITICAL | R-SCHEMA-001 | P1 Schema & Structural | PARCEL_ENRICHED.— | — (table-wide) | — | PE row count = 285714810 (expected 220M..280M) | Sep 16, 2026, 8:42 AM UTC |
| MAJOR | SERVING-ORPHANS-PARCEL-PERMITS-SAMPLE | P0 Serving Invariants | — | — (table-wide) | — | sampled 17609 matched permit rows; orphan_rows=3004 rate=17.06% sample=[{"state_fips": "12", "county_fips": "086", "matc | Sep 17, 2026, 7:24 AM UTC |
| MAJOR | R-RECONCILE-002 | P4 Cross-Source Reconciliation | PARCEL_PERMITS.— | — (table-wide) | 29 | state=29 permits_matched=943229 dangling=146218 dangling_rate=15.5% | Sep 16, 2026, 8:42 AM UTC |
| MAJOR | R-RECONCILE-002 | P4 Cross-Source Reconciliation | PARCEL_PERMITS.— | — (table-wide) | 22 | state=22 permits_matched=1221220 dangling=230834 dangling_rate=18.9% | Sep 16, 2026, 8:42 AM UTC |
| MAJOR | R-RECONCILE-002 | P4 Cross-Source Reconciliation | PARCEL_PERMITS.— | — (table-wide) | 26 | state=26 permits_matched=203134 dangling=18080 dangling_rate=8.9% | Sep 16, 2026, 8:42 AM UTC |
| MAJOR | R-RECONCILE-002 | P4 Cross-Source Reconciliation | PARCEL_PERMITS.— | — (table-wide) | 44 | state=44 permits_matched=11716 dangling=815 dangling_rate=6.96% | Sep 16, 2026, 8:42 AM UTC |
| MAJOR | R-RECONCILE-002 | P4 Cross-Source Reconciliation | PARCEL_PERMITS.— | — (table-wide) | 12 | state=12 permits_matched=2932023 dangling=921253 dangling_rate=31.42% | Sep 16, 2026, 8:42 AM UTC |
| MAJOR | R-RECONCILE-001 | P4 Cross-Source Reconciliation | PARCEL_PERMITS.— | — (table-wide) | 44 | state=44 permits_matched=11716 has_same_state=10893 resolve_rate=92.98% | Sep 16, 2026, 8:41 AM UTC |
| MAJOR | R-RECONCILE-001 | P4 Cross-Source Reconciliation | PARCEL_PERMITS.— | — (table-wide) | 26 | state=26 permits_matched=203134 has_same_state=184485 resolve_rate=90.82% | Sep 16, 2026, 8:41 AM UTC |
| MAJOR | R-RECONCILE-001 | P4 Cross-Source Reconciliation | PARCEL_PERMITS.— | — (table-wide) | 29 | state=29 permits_matched=943229 has_same_state=797011 resolve_rate=84.5% | Sep 16, 2026, 8:41 AM UTC |
| MAJOR | R-RECONCILE-001 | P4 Cross-Source Reconciliation | PARCEL_PERMITS.— | — (table-wide) | 22 | state=22 permits_matched=1221220 has_same_state=982768 resolve_rate=80.47% | Sep 16, 2026, 8:41 AM UTC |
| MAJOR | R-RECONCILE-001 | P4 Cross-Source Reconciliation | PARCEL_PERMITS.— | — (table-wide) | 12 | state=12 permits_matched=2932023 has_same_state=1618229 resolve_rate=55.19% | Sep 16, 2026, 8:41 AM UTC |
| MAJOR | R-FRESHNESS-001 | P5 Temporal & Freshness | PARCEL_ENRICHED.LAST_SALE_DATE | — (table-wide) | 38 | state=38 parcels=6530588 recent_sales_5y=6281 pct=0.1% | Sep 16, 2026, 8:34 AM UTC |
| MAJOR | R-FRESHNESS-001 | P5 Temporal & Freshness | PARCEL_ENRICHED.LAST_SALE_DATE | — (table-wide) | 16 | state=16 parcels=6946051 recent_sales_5y=15830 pct=0.23% | Sep 16, 2026, 8:34 AM UTC |
| MAJOR | R-FRESHNESS-001 | P5 Temporal & Freshness | PARCEL_ENRICHED.LAST_SALE_DATE | — (table-wide) | 44 | state=44 parcels=1775044 recent_sales_5y=6 pct=0.0% | Sep 16, 2026, 8:34 AM UTC |
| MAJOR | R-FRESHNESS-001 | P5 Temporal & Freshness | PARCEL_ENRICHED.LAST_SALE_DATE | — (table-wide) | 15 | state=15 parcels=724997 recent_sales_5y=155 pct=0.02% | Sep 16, 2026, 8:34 AM UTC |
| MAJOR | R-FRESHNESS-001 | P5 Temporal & Freshness | PARCEL_ENRICHED.LAST_SALE_DATE | — (table-wide) | 49 | state=49 parcels=4762373 recent_sales_5y=37472 pct=0.79% | Sep 16, 2026, 8:34 AM UTC |
| MAJOR | R-FRESHNESS-001 | P5 Temporal & Freshness | PARCEL_ENRICHED.LAST_SALE_DATE | — (table-wide) | 10 | state=10 parcels=1225182 recent_sales_5y=4128 pct=0.34% | Sep 16, 2026, 8:34 AM UTC |
| MAJOR | R-FRESHNESS-001 | P5 Temporal & Freshness | PARCEL_ENRICHED.LAST_SALE_DATE | — (table-wide) | 33 | state=33 parcels=1999451 recent_sales_5y=7954 pct=0.4% | Sep 16, 2026, 8:34 AM UTC |
| MAJOR | R-FRESHNESS-001 | P5 Temporal & Freshness | PARCEL_ENRICHED.LAST_SALE_DATE | — (table-wide) | 56 | state=56 parcels=1341260 recent_sales_5y=7922 pct=0.59% | Sep 16, 2026, 8:34 AM UTC |
| MAJOR | R-FRESHNESS-001 | P5 Temporal & Freshness | PARCEL_ENRICHED.LAST_SALE_DATE | — (table-wide) | 35 | state=35 parcels=2619359 recent_sales_5y=20811 pct=0.79% | Sep 16, 2026, 8:34 AM UTC |
| MAJOR | R-DRIFT-005 | P6 Distributional & Drift | PARCEL_ENRICHED.OWNER_NAME | — (table-wide) | 20 | state=20 parcels=2292425 null_owner=1689540 null_rate=73.7% | Sep 16, 2026, 8:17 AM UTC |
| MAJOR | R-DRIFT-005 | P6 Distributional & Drift | PARCEL_ENRICHED.OWNER_NAME | — (table-wide) | 46 | state=46 parcels=2774067 null_owner=2145561 null_rate=77.34% | Sep 16, 2026, 8:17 AM UTC |
| MAJOR | R-DRIFT-005 | P6 Distributional & Drift | PARCEL_ENRICHED.OWNER_NAME | — (table-wide) | 51 | state=51 parcels=9062182 null_owner=5668009 null_rate=62.55% | Sep 16, 2026, 8:17 AM UTC |
| MAJOR | R-DRIFT-005 | P6 Distributional & Drift | PARCEL_ENRICHED.OWNER_NAME | — (table-wide) | 23 | state=23 parcels=2266862 null_owner=2266840 null_rate=100.0% | Sep 16, 2026, 8:17 AM UTC |
| MAJOR | R-DRIFT-005 | P6 Distributional & Drift | PARCEL_ENRICHED.OWNER_NAME | — (table-wide) | 32 | state=32 parcels=4740710 null_owner=2851121 null_rate=60.14% | Sep 16, 2026, 8:17 AM UTC |
| MAJOR | R-DRIFT-005 | P6 Distributional & Drift | PARCEL_ENRICHED.OWNER_NAME | — (table-wide) | 53 | state=53 parcels=7556996 null_owner=5406627 null_rate=71.54% | Sep 16, 2026, 8:17 AM UTC |
| MAJOR | R-DRIFT-005 | P6 Distributional & Drift | PARCEL_ENRICHED.OWNER_NAME | — (table-wide) | 21 | state=21 parcels=1973569 null_owner=1295939 null_rate=65.66% | Sep 16, 2026, 8:17 AM UTC |
| MAJOR | R-DRIFT-005 | P6 Distributional & Drift | PARCEL_ENRICHED.OWNER_NAME | — (table-wide) | 33 | state=33 parcels=1999451 null_owner=1979534 null_rate=99.0% | Sep 16, 2026, 8:17 AM UTC |
| MAJOR | R-DRIFT-005 | P6 Distributional & Drift | PARCEL_ENRICHED.OWNER_NAME | — (table-wide) | 13 | state=13 parcels=7532901 null_owner=4550031 null_rate=60.4% | Sep 16, 2026, 8:17 AM UTC |
| MAJOR | R-DRIFT-005 | P6 Distributional & Drift | PARCEL_ENRICHED.OWNER_NAME | — (table-wide) | 44 | state=44 parcels=1775044 null_owner=1697263 null_rate=95.62% | Sep 16, 2026, 8:17 AM UTC |
| MAJOR | R-DRIFT-004 | P6 Distributional & Drift | PARCEL_ENRICHED.— | — (table-wide) | 17 | state=17 p95_bldg_sqft=24891 | Sep 16, 2026, 8:05 AM UTC |
| MAJOR | R-DRIFT-004 | P6 Distributional & Drift | PARCEL_ENRICHED.— | — (table-wide) | 34 | state=34 p95_bldg_sqft=36880 | Sep 16, 2026, 8:05 AM UTC |
| MAJOR | R-DRIFT-004 | P6 Distributional & Drift | PARCEL_ENRICHED.— | — (table-wide) | 06 | state=06 p95_bldg_sqft=22595 | Sep 16, 2026, 8:05 AM UTC |
| MAJOR | R-DRIFT-002 | P6 Distributional & Drift | PARCEL_ENRICHED.— | — (table-wide) | 35 | state=35 priced=35641 median_lsp=4500 | Sep 16, 2026, 8:00 AM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 09·015 | phantom_county_fips state=09 county=015 n=401390 | Sep 16, 2026, 7:56 AM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 09·009 | phantom_county_fips state=09 county=009 n=469172 | Sep 16, 2026, 7:56 AM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 54·052 | phantom_county_fips state=54 county=052 n=5901 | Sep 16, 2026, 7:56 AM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 54·020 | phantom_county_fips state=54 county=020 n=97781 | Sep 16, 2026, 7:56 AM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 09·001 | phantom_county_fips state=09 county=001 n=356972 | Sep 16, 2026, 7:56 AM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 54·042 | phantom_county_fips state=54 county=042 n=12377 | Sep 16, 2026, 7:56 AM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 54·026 | phantom_county_fips state=54 county=026 n=11232 | Sep 16, 2026, 7:56 AM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 54·010 | phantom_county_fips state=54 county=010 n=72248 | Sep 16, 2026, 7:56 AM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 54·014 | phantom_county_fips state=54 county=014 n=6622 | Sep 16, 2026, 7:56 AM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 54·046 | phantom_county_fips state=54 county=046 n=6548 | Sep 16, 2026, 7:56 AM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 54·038 | phantom_county_fips state=54 county=038 n=5330 | Sep 16, 2026, 7:56 AM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 09·003 | phantom_county_fips state=09 county=003 n=573083 | Sep 16, 2026, 7:56 AM UTC |
| Started | Status | Trigger | Rules | Findings | Duration | Run ID |
|---|---|---|---|---|---|---|
| Sep 17, 2026, 6:00 AM UTC | running | hetzner-systemd | 0 | 0 | — | c30df67a… |
| Sep 16, 2026, 6:00 AM UTC | success | hetzner-systemd | 54 | 163 | 13,708s | c606c779… |
| Sep 15, 2026, 6:00 AM UTC | success | hetzner-systemd | 54 | 163 | 12,962s | b9d2b7c3… |
| Sep 14, 2026, 6:00 AM UTC | success | hetzner-systemd | 54 | 163 | 13,042s | 21e224f8… |
| Sep 13, 2026, 6:00 AM UTC | success | hetzner-systemd | 54 | 163 | 13,228s | d918db84… |
| Sep 12, 2026, 6:00 AM UTC | success | hetzner-systemd | 54 | 163 | 14,581s | 349442a4… |
| Sep 11, 2026, 6:00 AM UTC | success | hetzner-systemd | 54 | 163 | 15,308s | 09654119… |
| Sep 10, 2026, 6:00 AM UTC | success | hetzner-systemd | 54 | 163 | 13,662s | 5eb160db… |
| Sep 9, 2026, 6:00 AM UTC | success | hetzner-systemd | 54 | 210 | 12,338s | 72a600d7… |
| Sep 8, 2026, 6:00 AM UTC | success | hetzner-systemd | 54 | 210 | 12,786s | e0b70699… |
| Sep 7, 2026, 6:00 AM UTC | partial | hetzner-systemd | 53 | 205 | 15,032s | aeefcbb6… |
| Sep 6, 2026, 6:00 AM UTC | success | hetzner-systemd | 54 | 206 | 15,141s | f2499392… |
| Sep 5, 2026, 6:00 AM UTC | success | hetzner-systemd | 54 | 206 | 14,994s | b8236cf3… |
| Sep 4, 2026, 6:00 AM UTC | success | hetzner-systemd | 54 | 206 | 15,217s | 58c2b75b… |
Schema · audit.findings · indexed by (run_id, rule_id) · append-only · PII redacted at write. Rules versioned in audit.rules.