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-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 54·020 | phantom_county_fips state=54 county=020 n=97781 | Jul 22, 2026, 6:26 AM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 54·022 | phantom_county_fips state=54 county=022 n=4122 | Jul 22, 2026, 6:26 AM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 54·024 | phantom_county_fips state=54 county=024 n=32004 | Jul 22, 2026, 6:26 AM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 54·030 | phantom_county_fips state=54 county=030 n=12289 | Jul 22, 2026, 6:26 AM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 42·000 | phantom_county_fips state=42 county=000 n=1774 | Jul 22, 2026, 6:26 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 | Jul 22, 2026, 6:26 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 | Jul 22, 2026, 6:26 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 | Jul 22, 2026, 6:26 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 | Jul 22, 2026, 6:26 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 | Jul 22, 2026, 6:26 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 | Jul 22, 2026, 6:26 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 | Jul 22, 2026, 6:26 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 | Jul 22, 2026, 6:26 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 | Jul 22, 2026, 6:26 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 | Jul 22, 2026, 6:26 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 | Jul 22, 2026, 6:26 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 | Jul 22, 2026, 6:26 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 | Jul 22, 2026, 6:26 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 | Jul 22, 2026, 6:26 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 | Jul 22, 2026, 6:26 AM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 09·011 | phantom_county_fips state=09 county=011 n=459313 | Jul 22, 2026, 6:26 AM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 09·013 | phantom_county_fips state=09 county=013 n=70668 | Jul 22, 2026, 6:26 AM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 12·000 | phantom_county_fips state=12 county=000 n=30865 | Jul 22, 2026, 6:26 AM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 27·000 | phantom_county_fips state=27 county=000 n=1073879 | Jul 22, 2026, 6:26 AM UTC |
| MAJOR | R-CROSSTABLE-004 | P4 Cross-Source Reconciliation | PARCEL_ENRICHED.— | — (table-wide) | 31·000 | phantom_county_fips state=31 county=000 n=298007 | Jul 22, 2026, 6:26 AM 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%) | Jul 22, 2026, 6:00 AM UTC |
| MINOR | R-DRIFT-006 | P6 Distributional & Drift | PARCEL_ENRICHED.— | — (table-wide) | 36·081 | state=36 county=081 max_tav=3211276050.00 median_tav=21106 ratio=152150.0 | Jul 22, 2026, 6:34 AM UTC |
| MINOR | R-DRIFT-006 | P6 Distributional & Drift | PARCEL_ENRICHED.— | — (table-wide) | 54·053 | state=54 county=053 max_tav=257055600.00 median_tav=1436 ratio=179008.0 | Jul 22, 2026, 6:34 AM UTC |
| MINOR | R-DRIFT-006 | P6 Distributional & Drift | PARCEL_ENRICHED.— | — (table-wide) | 36·085 | state=36 county=085 max_tav=1587991105.00 median_tav=14805 ratio=107260.0 | Jul 22, 2026, 6:34 AM UTC |
| MINOR | R-DRIFT-006 | P6 Distributional & Drift | PARCEL_ENRICHED.— | — (table-wide) | 36·047 | state=36 county=047 max_tav=2653733250.00 median_tav=21270 ratio=124764.0 | Jul 22, 2026, 6:34 AM UTC |
| MINOR | R-DRIFT-006 | P6 Distributional & Drift | PARCEL_ENRICHED.— | — (table-wide) | 36·055 | state=36 county=055 max_tav=1587991105.00 median_tav=1134 ratio=1400345.0 | Jul 22, 2026, 6:34 AM UTC |
| MINOR | R-DRIFT-006 | P6 Distributional & Drift | PARCEL_ENRICHED.— | — (table-wide) | 36·103 | state=36 county=103 max_tav=25167533574.00 median_tav=156212 ratio=161111.0 | Jul 22, 2026, 6:34 AM UTC |
| MINOR | R-COVERAGE-011 | P7 Coverage & Completeness | PARCEL_ENRICHED.LAST_SALE_PRICE | — (table-wide) | — | LAST_SALE_PRICE populated 20.38% (expected >= 31%) | Jul 22, 2026, 6:19 AM UTC |
| MINOR | R-COVERAGE-009 | P7 Coverage & Completeness | PARCEL_ENRICHED.LOT_SIZE_SQFT | — (table-wide) | — | LOT_SIZE_SQFT populated 58.03% (expected >= 60%) | Jul 22, 2026, 6:17 AM UTC |
| INFO | R-CROSSFIELD-005 | P3 Cross-Field Consistency | PARCEL_ENRICHED.— | — (table-wide) | 39 | state=39 bedroom_parcels=605037 missing_sqft=93136 rate=15.39% | Jul 22, 2026, 6:22 AM UTC |
| INFO | R-CROSSFIELD-005 | P3 Cross-Field Consistency | PARCEL_ENRICHED.— | — (table-wide) | 46 | state=46 bedroom_parcels=145799 missing_sqft=39146 rate=26.85% | Jul 22, 2026, 6:22 AM UTC |
| Started | Status | Trigger | Rules | Findings | Duration | Run ID |
|---|---|---|---|---|---|---|
| Jul 22, 2026, 6:00 AM UTC | success | hetzner-systemd | 52 | 86 | 2798s | f8ddc793… |
| Jul 21, 2026, 6:00 AM UTC | success | hetzner-systemd | 52 | 86 | 2664s | 8667bace… |
| Jul 20, 2026, 6:00 AM UTC | success | hetzner-systemd | 52 | 86 | 2652s | 9ec3c215… |
| Jul 19, 2026, 6:00 AM UTC | success | hetzner-systemd | 52 | 86 | 2717s | eff3d07a… |
| Jul 18, 2026, 6:00 AM UTC | success | hetzner-systemd | 52 | 86 | 2703s | 72f14a2a… |
| Jul 18, 2026, 2:58 AM UTC | success | hetzner-systemd | 52 | 86 | 3072s | b2fbe859… |
| Jul 14, 2026, 6:00 AM UTC | success | hetzner-systemd | 52 | 86 | 2526s | f9bf5f30… |
| Jul 13, 2026, 6:00 AM UTC | success | hetzner-systemd | 52 | 85 | 2728s | 5dac376d… |
| Jul 12, 2026, 6:00 AM UTC | success | hetzner-systemd | 52 | 85 | 2877s | e75b8acb… |
| Jul 11, 2026, 6:00 AM UTC | success | hetzner-systemd | 52 | 85 | 2571s | bf832423… |
| Jul 10, 2026, 6:00 AM UTC | success | hetzner-systemd | 52 | 85 | 2538s | c9569a61… |
| Jul 9, 2026, 6:00 AM UTC | success | hetzner-systemd | 52 | 85 | 2671s | 8921d549… |
Schema · audit.findings · indexed by (run_id, rule_id) · append-only · PII redacted at write. Rules versioned in audit.rules.