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 |
|---|---|---|---|---|---|---|---|
| MAJOR | R-SCHEMA-006 | P1 Schema & Structural | PARCEL_DEEDS.— | — (table-wide) | — | PARCEL_DEEDS distinct STATE_FIPS with >= 1000 rows = 28 (expected >= 30) | May 15, 2026, 11:11 PM UTC |
| MAJOR | R-FRESHNESS-001 | P5 Temporal & Freshness | PARCEL_ENRICHED.LAST_SALE_DATE | — (table-wide) | 10 | state=10 parcels=1224192 recent_sales_5y=4431 pct=0.36% | May 15, 2026, 11:08 PM UTC |
| MAJOR | R-FRESHNESS-001 | P5 Temporal & Freshness | PARCEL_ENRICHED.LAST_SALE_DATE | — (table-wide) | 15 | state=15 parcels=724997 recent_sales_5y=172 pct=0.02% | May 15, 2026, 11:08 PM UTC |
| MAJOR | R-FRESHNESS-001 | P5 Temporal & Freshness | PARCEL_ENRICHED.LAST_SALE_DATE | — (table-wide) | 49 | state=49 parcels=4738902 recent_sales_5y=42674 pct=0.90% | May 15, 2026, 11:08 PM UTC |
| MAJOR | R-FRESHNESS-001 | P5 Temporal & Freshness | PARCEL_ENRICHED.LAST_SALE_DATE | — (table-wide) | 16 | state=16 parcels=3563637 recent_sales_5y=17340 pct=0.49% | May 15, 2026, 11:08 PM UTC |
| MAJOR | R-FRESHNESS-001 | P5 Temporal & Freshness | PARCEL_ENRICHED.LAST_SALE_DATE | — (table-wide) | 44 | state=44 parcels=1775033 recent_sales_5y=8 pct=0.00% | May 15, 2026, 11:08 PM UTC |
| MAJOR | R-FRESHNESS-001 | P5 Temporal & Freshness | PARCEL_ENRICHED.LAST_SALE_DATE | — (table-wide) | 33 | state=33 parcels=1844949 recent_sales_5y=8568 pct=0.46% | May 15, 2026, 11:08 PM UTC |
| MAJOR | R-FRESHNESS-001 | P5 Temporal & Freshness | PARCEL_ENRICHED.LAST_SALE_DATE | — (table-wide) | 23 | state=23 parcels=2237584 recent_sales_5y=0 pct=0.00% | May 15, 2026, 11:08 PM UTC |
| MAJOR | R-FRESHNESS-001 | P5 Temporal & Freshness | PARCEL_ENRICHED.LAST_SALE_DATE | — (table-wide) | 38 | state=38 parcels=6510341 recent_sales_5y=6541 pct=0.10% | May 15, 2026, 11:08 PM UTC |
| MAJOR | R-FRESHNESS-001 | P5 Temporal & Freshness | PARCEL_ENRICHED.LAST_SALE_DATE | — (table-wide) | 34 | state=34 parcels=6533272 recent_sales_5y=5736 pct=0.09% | May 15, 2026, 11:08 PM UTC |
| MAJOR | R-FRESHNESS-001 | P5 Temporal & Freshness | PARCEL_ENRICHED.LAST_SALE_DATE | — (table-wide) | 56 | state=56 parcels=1320098 recent_sales_5y=8735 pct=0.66% | May 15, 2026, 11:08 PM 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% | May 15, 2026, 11:08 PM 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% | May 15, 2026, 11:08 PM 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% | May 15, 2026, 11:08 PM 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% | May 15, 2026, 11:08 PM 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.00% | May 15, 2026, 11:08 PM 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% | May 15, 2026, 11:08 PM UTC |
| MAJOR | R-DRIFT-004 | P6 Distributional & Drift | PARCEL_ENRICHED.— | — (table-wide) | 06 | state=06 p95_bldg_sqft=21384 | May 15, 2026, 11:07 PM UTC |
| MAJOR | R-DRIFT-004 | P6 Distributional & Drift | PARCEL_ENRICHED.— | — (table-wide) | 17 | state=17 p95_bldg_sqft=24137 | May 15, 2026, 11:07 PM UTC |
| MAJOR | R-DRIFT-004 | P6 Distributional & Drift | PARCEL_ENRICHED.— | — (table-wide) | 34 | state=34 p95_bldg_sqft=34856 | May 15, 2026, 11:07 PM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 54·022 | phantom_county_fips state=54 county=022 n=4122 | May 15, 2026, 11:07 PM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 09·015 | phantom_county_fips state=09 county=015 n=401382 | May 15, 2026, 11:07 PM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 54·044 | phantom_county_fips state=54 county=044 n=9628 | May 15, 2026, 11:07 PM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 54·048 | phantom_county_fips state=54 county=048 n=2025 | May 15, 2026, 11:07 PM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 54·006 | phantom_county_fips state=54 county=006 n=2756 | May 15, 2026, 11:07 PM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 54·034 | phantom_county_fips state=54 county=034 n=6670 | May 15, 2026, 11:07 PM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 09·011 | phantom_county_fips state=09 county=011 n=459313 | May 15, 2026, 11:07 PM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 54·054 | phantom_county_fips state=54 county=054 n=14650 | May 15, 2026, 11:07 PM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 54·036 | phantom_county_fips state=54 county=036 n=10784 | May 15, 2026, 11:07 PM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 54·046 | phantom_county_fips state=54 county=046 n=6548 | May 15, 2026, 11:07 PM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 09·007 | phantom_county_fips state=09 county=007 n=400463 | May 15, 2026, 11:07 PM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 54·028 | phantom_county_fips state=54 county=028 n=17676 | May 15, 2026, 11:07 PM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 54·042 | phantom_county_fips state=54 county=042 n=12377 | May 15, 2026, 11:07 PM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 09·003 | phantom_county_fips state=09 county=003 n=506883 | May 15, 2026, 11:07 PM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 54·040 | phantom_county_fips state=54 county=040 n=17062 | May 15, 2026, 11:07 PM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 54·050 | phantom_county_fips state=54 county=050 n=8849 | May 15, 2026, 11:07 PM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 09·013 | phantom_county_fips state=09 county=013 n=70668 | May 15, 2026, 11:07 PM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 09·009 | phantom_county_fips state=09 county=009 n=440905 | May 15, 2026, 11:07 PM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 54·038 | phantom_county_fips state=54 county=038 n=5330 | May 15, 2026, 11:07 PM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 09·005 | phantom_county_fips state=09 county=005 n=97337 | May 15, 2026, 11:07 PM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 54·052 | phantom_county_fips state=54 county=052 n=5901 | May 15, 2026, 11:07 PM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 54·026 | phantom_county_fips state=54 county=026 n=11232 | May 15, 2026, 11:07 PM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 54·032 | phantom_county_fips state=54 county=032 n=4057 | May 15, 2026, 11:07 PM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 09·001 | phantom_county_fips state=09 county=001 n=343280 | May 15, 2026, 11:07 PM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 54·024 | phantom_county_fips state=54 county=024 n=32004 | May 15, 2026, 11:07 PM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 54·030 | phantom_county_fips state=54 county=030 n=12289 | May 15, 2026, 11:07 PM UTC |
| MAJOR | R-COVERAGE-001 | P7 Coverage & Completeness | PARCEL_ENRICHED.OWNER_NAME | — (table-wide) | — | OWNER_NAME populated 78.86% on eligible parcels (excluded 18287677 legally-restricted parcels; expected >=80%) | May 15, 2026, 11:01 PM UTC |
| MINOR | R-DRIFT-006 | P6 Distributional & Drift | PARCEL_ENRICHED.— | — (table-wide) | 54·053 | state=54 county=053 max_tav=257055600.00 median_tav=1400 ratio=183611 | May 15, 2026, 11:08 PM UTC |
| MINOR | R-DRIFT-006 | P6 Distributional & Drift | PARCEL_ENRICHED.— | — (table-wide) | 36·103 | state=36 county=103 max_tav=25167533574.00 median_tav=157209 ratio=160090 | May 15, 2026, 11:08 PM UTC |
| MINOR | R-DRIFT-006 | P6 Distributional & Drift | PARCEL_ENRICHED.— | — (table-wide) | 36·081 | state=36 county=081 max_tav=3211276050.00 median_tav=21055 ratio=152516 | May 15, 2026, 11:08 PM UTC |
| Started | Status | Trigger | Rules | Findings | Duration | Run ID |
|---|---|---|---|---|---|---|
| May 15, 2026, 11:00 PM UTC | success | hetzner-systemd | 52 | 57 | 731s | 14756d09… |
| May 14, 2026, 11:00 PM UTC | success | hetzner-systemd | 52 | 57 | 751s | dd388feb… |
| May 13, 2026, 11:00 PM UTC | success | hetzner-systemd | 52 | 57 | 754s | 6cda6e05… |
| May 12, 2026, 11:00 PM UTC | success | hetzner-systemd | 52 | 71 | 744s | 27089fa8… |
| May 11, 2026, 11:00 PM UTC | success | hetzner-systemd | 52 | 71 | 768s | ad06e239… |
| May 10, 2026, 11:00 PM UTC | success | hetzner-systemd | 52 | 71 | 731s | 58773fe2… |
| May 9, 2026, 11:00 PM UTC | success | hetzner-systemd | 52 | 93 | 690s | 6740d719… |
| May 8, 2026, 11:00 PM UTC | success | hetzner-systemd | 52 | 93 | 714s | 1e613b7a… |
| May 8, 2026, 9:08 AM UTC | success | manual | 1 | 0 | 114s | aea9f702… |
| May 8, 2026, 9:06 AM UTC | success | manual | 1 | 0 | 163s | afde29b4… |
| May 8, 2026, 9:05 AM UTC | success | manual | 1 | 0 | 167s | c5948370… |
| May 8, 2026, 9:04 AM UTC | success | manual | 1 | 0 | 145s | 21e6cf2e… |
| May 8, 2026, 9:03 AM UTC | success | manual | 1 | 0 | 143s | aa48ff69… |
| May 8, 2026, 9:01 AM UTC | success | manual | 1 | 0 | 158s | f559f2f5… |
Schema · PROPZILLA.AUDIT.FINDINGS · clustered by (RUN_ID, RULE_ID) · append-only · PII redacted at write. Rules versioned in PROPZILLA.AUDIT.RULES.