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 | R-SCHEMA-003 | P1 Schema & Structural | PARCEL_PERMITS.— | — (table-wide) | — | PARCEL_PERMITS row count = 1417360 (expected >= 50M) | Jun 28, 2026, 6:33 AM UTC |
| MAJOR | R-SCHEMA-006 | P1 Schema & Structural | PARCEL_DEEDS.— | — (table-wide) | — | PARCEL_DEEDS distinct STATE_FIPS with >= 1000 rows = 1 (expected >= 30) | Jun 28, 2026, 6:37 AM UTC |
| MAJOR | R-FRESHNESS-001 | P5 Temporal & Freshness | PARCEL_ENRICHED.LAST_SALE_DATE | — (table-wide) | 10 | state=10 parcels=1224192 recent_sales_5y=4338 pct=0.35% | Jun 28, 2026, 6:31 AM UTC |
| MAJOR | R-FRESHNESS-001 | P5 Temporal & Freshness | PARCEL_ENRICHED.LAST_SALE_DATE | — (table-wide) | 33 | state=33 parcels=1844949 recent_sales_5y=8357 pct=0.45% | Jun 28, 2026, 6:31 AM UTC |
| MAJOR | R-FRESHNESS-001 | P5 Temporal & Freshness | PARCEL_ENRICHED.LAST_SALE_DATE | — (table-wide) | 16 | state=16 parcels=3563637 recent_sales_5y=16862 pct=0.47% | Jun 28, 2026, 6:31 AM UTC |
| MAJOR | R-FRESHNESS-001 | P5 Temporal & Freshness | PARCEL_ENRICHED.LAST_SALE_DATE | — (table-wide) | 49 | state=49 parcels=4738902 recent_sales_5y=40826 pct=0.86% | Jun 28, 2026, 6:31 AM UTC |
| MAJOR | R-FRESHNESS-001 | P5 Temporal & Freshness | PARCEL_ENRICHED.LAST_SALE_DATE | — (table-wide) | 15 | state=15 parcels=724997 recent_sales_5y=169 pct=0.02% | Jun 28, 2026, 6:31 AM UTC |
| MAJOR | R-FRESHNESS-001 | P5 Temporal & Freshness | PARCEL_ENRICHED.LAST_SALE_DATE | — (table-wide) | 56 | state=56 parcels=1320098 recent_sales_5y=8445 pct=0.64% | Jun 28, 2026, 6:31 AM UTC |
| MAJOR | R-FRESHNESS-001 | P5 Temporal & Freshness | PARCEL_ENRICHED.LAST_SALE_DATE | — (table-wide) | 44 | state=44 parcels=1775033 recent_sales_5y=7 pct=0.0% | Jun 28, 2026, 6:31 AM UTC |
| MAJOR | R-FRESHNESS-001 | P5 Temporal & Freshness | PARCEL_ENRICHED.LAST_SALE_DATE | — (table-wide) | 38 | state=38 parcels=6510341 recent_sales_5y=6457 pct=0.1% | Jun 28, 2026, 6:31 AM UTC |
| MAJOR | R-FRESHNESS-001 | P5 Temporal & Freshness | PARCEL_ENRICHED.LAST_SALE_DATE | — (table-wide) | 34 | state=34 parcels=6533272 recent_sales_5y=5528 pct=0.08% | Jun 28, 2026, 6:31 AM UTC |
| MAJOR | R-DRIFT-005 | P6 Distributional & Drift | PARCEL_ENRICHED.OWNER_NAME | — (table-wide) | 33 | state=33 parcels=1844949 null_owner=1825032 null_rate=98.92% | Jun 28, 2026, 6:26 AM UTC |
| MAJOR | R-DRIFT-005 | P6 Distributional & Drift | PARCEL_ENRICHED.OWNER_NAME | — (table-wide) | 49 | state=49 parcels=4738902 null_owner=4052746 null_rate=85.52% | Jun 28, 2026, 6:26 AM UTC |
| MAJOR | R-DRIFT-005 | P6 Distributional & Drift | PARCEL_ENRICHED.OWNER_NAME | — (table-wide) | 31 | state=31 parcels=2457966 null_owner=1969686 null_rate=80.13% | Jun 28, 2026, 6:26 AM UTC |
| MAJOR | R-DRIFT-005 | P6 Distributional & Drift | PARCEL_ENRICHED.OWNER_NAME | — (table-wide) | 23 | state=23 parcels=2237584 null_owner=2237562 null_rate=100.0% | Jun 28, 2026, 6:26 AM UTC |
| MAJOR | R-DRIFT-005 | P6 Distributional & Drift | PARCEL_ENRICHED.OWNER_NAME | — (table-wide) | 34 | state=34 parcels=6533272 null_owner=6049375 null_rate=92.59% | Jun 28, 2026, 6:26 AM UTC |
| MAJOR | R-DRIFT-005 | P6 Distributional & Drift | PARCEL_ENRICHED.OWNER_NAME | — (table-wide) | 44 | state=44 parcels=1775033 null_owner=1697252 null_rate=95.62% | Jun 28, 2026, 6:26 AM UTC |
| MAJOR | R-DRIFT-004 | P6 Distributional & Drift | PARCEL_ENRICHED.— | — (table-wide) | 06 | state=06 p95_bldg_sqft=22990 | Jun 28, 2026, 6:23 AM UTC |
| MAJOR | R-DRIFT-004 | P6 Distributional & Drift | PARCEL_ENRICHED.— | — (table-wide) | 17 | state=17 p95_bldg_sqft=25049 | Jun 28, 2026, 6:23 AM UTC |
| MAJOR | R-DRIFT-004 | P6 Distributional & Drift | PARCEL_ENRICHED.— | — (table-wide) | 34 | state=34 p95_bldg_sqft=36560 | Jun 28, 2026, 6:23 AM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 54·040 | phantom_county_fips state=54 county=040 n=17062 | Jun 28, 2026, 6:23 AM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 54·054 | phantom_county_fips state=54 county=054 n=14650 | Jun 28, 2026, 6:23 AM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 54·012 | phantom_county_fips state=54 county=012 n=63291 | Jun 28, 2026, 6:23 AM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 55·000 | phantom_county_fips state=55 county=000 n=10170 | Jun 28, 2026, 6:23 AM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 09·003 | phantom_county_fips state=09 county=003 n=506883 | Jun 28, 2026, 6:23 AM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 09·005 | phantom_county_fips state=09 county=005 n=97337 | Jun 28, 2026, 6:23 AM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 09·007 | phantom_county_fips state=09 county=007 n=400463 | Jun 28, 2026, 6:23 AM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 18·000 | phantom_county_fips state=18 county=000 n=39519 | Jun 28, 2026, 6:23 AM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 32·000 | phantom_county_fips state=32 county=000 n=1328920 | Jun 28, 2026, 6:23 AM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 46·000 | phantom_county_fips state=46 county=000 n=4086 | Jun 28, 2026, 6:23 AM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 54·000 | phantom_county_fips state=54 county=000 n=564914 | Jun 28, 2026, 6:23 AM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 54·006 | phantom_county_fips state=54 county=006 n=2756 | Jun 28, 2026, 6:23 AM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 54·044 | phantom_county_fips state=54 county=044 n=9628 | Jun 28, 2026, 6:23 AM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 54·048 | phantom_county_fips state=54 county=048 n=2025 | Jun 28, 2026, 6:23 AM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 54·050 | phantom_county_fips state=54 county=050 n=8849 | Jun 28, 2026, 6:23 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 | Jun 28, 2026, 6:23 AM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 54·018 | phantom_county_fips state=54 county=018 n=3935 | Jun 28, 2026, 6:23 AM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 54·028 | phantom_county_fips state=54 county=028 n=17676 | Jun 28, 2026, 6:23 AM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 36·000 | phantom_county_fips state=36 county=000 n=67279 | Jun 28, 2026, 6:23 AM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 08·000 | phantom_county_fips state=08 county=000 n=9509 | Jun 28, 2026, 6:23 AM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 09·015 | phantom_county_fips state=09 county=015 n=401382 | Jun 28, 2026, 6:23 AM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 09·001 | phantom_county_fips state=09 county=001 n=343280 | Jun 28, 2026, 6:23 AM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 09·009 | phantom_county_fips state=09 county=009 n=440905 | Jun 28, 2026, 6:23 AM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 13·000 | phantom_county_fips state=13 county=000 n=120813 | Jun 28, 2026, 6:23 AM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 15·000 | phantom_county_fips state=15 county=000 n=25632 | Jun 28, 2026, 6:23 AM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 20·000 | phantom_county_fips state=20 county=000 n=2599 | Jun 28, 2026, 6:23 AM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 29·000 | phantom_county_fips state=29 county=000 n=5031 | Jun 28, 2026, 6:23 AM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 41·000 | phantom_county_fips state=41 county=000 n=281766 | Jun 28, 2026, 6:23 AM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 45·000 | phantom_county_fips state=45 county=000 n=20922 | Jun 28, 2026, 6:23 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 | Jun 28, 2026, 6:23 AM UTC |
| Started | Status | Trigger | Rules | Findings | Duration | Run ID |
|---|---|---|---|---|---|---|
| Jun 28, 2026, 6:00 AM UTC | success | hetzner-systemd | 52 | 85 | 2617s | 7722c6c5… |
| Jun 27, 2026, 6:00 AM UTC | success | hetzner-systemd | 52 | 86 | 2471s | e91a9055… |
| Jun 26, 2026, 6:00 AM UTC | success | hetzner-systemd | 52 | 86 | 3197s | 1b4a6960… |
| Jun 25, 2026, 6:00 AM UTC | success | hetzner-systemd | 52 | 85 | 3923s | 1028d3f1… |
| Jun 24, 2026, 6:00 AM UTC | success | hetzner-systemd | 52 | 85 | 3820s | 6ce3f790… |
| Jun 23, 2026, 6:00 AM UTC | success | hetzner-systemd | 52 | 85 | 3893s | e730436e… |
| Jun 22, 2026, 6:00 AM UTC | success | hetzner-systemd | 52 | 85 | 3762s | fac56c30… |
| Jun 21, 2026, 6:00 AM UTC | success | hetzner-systemd | 52 | 85 | 3902s | b4576c1a… |
| Jun 20, 2026, 6:00 AM UTC | success | hetzner-systemd | 52 | 85 | 3895s | 4e308b54… |
| Jun 19, 2026, 6:00 AM UTC | success | hetzner-systemd | 52 | 85 | 3819s | 41c5a10d… |
| Jun 18, 2026, 6:00 AM UTC | success | hetzner-systemd | 52 | 85 | 3887s | faec571a… |
| Jun 17, 2026, 6:00 AM UTC | success | hetzner-systemd | 52 | 85 | 3819s | 428bc6b2… |
| Jun 16, 2026, 6:00 AM UTC | success | hetzner-systemd | 52 | 85 | 3996s | 14a6d509… |
| Jun 15, 2026, 6:00 AM UTC | success | hetzner-systemd | 52 | 85 | 3836s | 1c3251ff… |
Schema · audit.findings · indexed by (run_id, rule_id) · append-only · PII redacted at write. Rules versioned in audit.rules.