§ 04 · PUBLIC FINDINGS LEDGER

Every defect we know about, live.

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

Latest run
Sep 16, 2026, 6:00 AM UTC
RUN_ID c606c779…
Total findings
163
from 54 rules
Showing
166
All findings
Cadence
nightly
06:00 UTC · DuckDB+R2 engine
SeverityRulePillarFieldParcel / clusterWhereValue summaryDetected
MAJORR-CROSSTABLE-004P4 Cross-Source ReconciliationPARCEL_ENRICHED.—— (table-wide)54·042phantom_county_fips state=54 county=042 n=12377Sep 16, 2026, 7:56 AM UTC
MAJORR-CROSSTABLE-004P4 Cross-Source ReconciliationPARCEL_ENRICHED.—— (table-wide)54·022phantom_county_fips state=54 county=022 n=4122Sep 16, 2026, 7:56 AM UTC
MAJORR-CROSSTABLE-004P4 Cross-Source ReconciliationPARCEL_ENRICHED.—— (table-wide)54·020phantom_county_fips state=54 county=020 n=97781Sep 16, 2026, 7:56 AM UTC
MAJORR-CROSSTABLE-004P4 Cross-Source ReconciliationPARCEL_ENRICHED.—— (table-wide)09·015phantom_county_fips state=09 county=015 n=401390Sep 16, 2026, 7:56 AM UTC
MAJORR-CROSSTABLE-004P4 Cross-Source ReconciliationPARCEL_ENRICHED.—— (table-wide)09·009phantom_county_fips state=09 county=009 n=469172Sep 16, 2026, 7:56 AM UTC
MAJORR-CROSSTABLE-004P4 Cross-Source ReconciliationPARCEL_ENRICHED.—— (table-wide)09·001phantom_county_fips state=09 county=001 n=356972Sep 16, 2026, 7:56 AM UTC
MAJORR-CROSSTABLE-004P4 Cross-Source ReconciliationPARCEL_ENRICHED.—— (table-wide)54·038phantom_county_fips state=54 county=038 n=5330Sep 16, 2026, 7:56 AM UTC
MAJORR-CROSSTABLE-004P4 Cross-Source ReconciliationPARCEL_ENRICHED.—— (table-wide)54·032phantom_county_fips state=54 county=032 n=4057Sep 16, 2026, 7:56 AM UTC
MAJORR-CROSSTABLE-004P4 Cross-Source ReconciliationPARCEL_ENRICHED.—— (table-wide)54·016phantom_county_fips state=54 county=016 n=5327Sep 16, 2026, 7:56 AM UTC
MAJORR-CROSSTABLE-004P4 Cross-Source ReconciliationPARCEL_ENRICHED.—— (table-wide)54·014phantom_county_fips state=54 county=014 n=6622Sep 16, 2026, 7:56 AM UTC
MAJORR-CROSSTABLE-004P4 Cross-Source ReconciliationPARCEL_ENRICHED.—— (table-wide)54·010phantom_county_fips state=54 county=010 n=72248Sep 16, 2026, 7:56 AM UTC
MAJORR-CROSSTABLE-004P4 Cross-Source ReconciliationPARCEL_ENRICHED.—— (table-wide)54·026phantom_county_fips state=54 county=026 n=11232Sep 16, 2026, 7:56 AM UTC
MAJORR-CROSSTABLE-004P4 Cross-Source ReconciliationPARCEL_ENRICHED.—— (table-wide)54·046phantom_county_fips state=54 county=046 n=6548Sep 16, 2026, 7:56 AM UTC
MAJORR-CROSSTABLE-004P4 Cross-Source ReconciliationPARCEL_ENRICHED.—— (table-wide)54·036phantom_county_fips state=54 county=036 n=10784Sep 16, 2026, 7:56 AM UTC
MAJORR-CROSSTABLE-004P4 Cross-Source ReconciliationPARCEL_ENRICHED.—— (table-wide)54·040phantom_county_fips state=54 county=040 n=17062Sep 16, 2026, 7:56 AM UTC
MAJORR-CROSSTABLE-004P4 Cross-Source ReconciliationPARCEL_ENRICHED.—— (table-wide)54·054phantom_county_fips state=54 county=054 n=14650Sep 16, 2026, 7:56 AM UTC
MAJORR-CROSSTABLE-004P4 Cross-Source ReconciliationPARCEL_ENRICHED.—— (table-wide)09·013phantom_county_fips state=09 county=013 n=70883Sep 16, 2026, 7:56 AM UTC
MAJORR-CROSSTABLE-004P4 Cross-Source ReconciliationPARCEL_ENRICHED.—— (table-wide)54·012phantom_county_fips state=54 county=012 n=63291Sep 16, 2026, 7:56 AM UTC
MAJORR-CROSSTABLE-004P4 Cross-Source ReconciliationPARCEL_ENRICHED.—— (table-wide)54·034phantom_county_fips state=54 county=034 n=6670Sep 16, 2026, 7:56 AM UTC
MAJORR-CROSSTABLE-004P4 Cross-Source ReconciliationPARCEL_ENRICHED.—— (table-wide)09·011phantom_county_fips state=09 county=011 n=459352Sep 16, 2026, 7:56 AM UTC
MAJORR-CROSSTABLE-001P3 Cross-Field ConsistencyPARCEL_PERMITS.—— (table-wide)12juri=City of Asheville Permit Inspections permit_state=12 n_misrouted=209Sep 16, 2026, 7:44 AM UTC
MAJORR-CROSSTABLE-001P3 Cross-Field ConsistencyPARCEL_PERMITS.—— (table-wide)12Sep 16, 2026, 7:44 AM UTC
MAJORR-CROSSTABLE-001P3 Cross-Field ConsistencyPARCEL_PERMITS.—— (table-wide)12juri=arcgis_80 permit_state=12 n_misrouted=1913Sep 16, 2026, 7:44 AM UTC
MAJORR-CROSSTABLE-001P3 Cross-Field ConsistencyPARCEL_PERMITS.—— (table-wide)36juri=cityofnewyork.us permit_state=36 n_misrouted=380Sep 16, 2026, 7:44 AM UTC
MAJORR-CROSSTABLE-001P3 Cross-Field ConsistencyPARCEL_PERMITS.—— (table-wide)12juri=cityofgainesville permit_state=12 n_misrouted=461Sep 16, 2026, 7:44 AM UTC
MAJORR-CROSSTABLE-001P3 Cross-Field ConsistencyPARCEL_PERMITS.—— (table-wide)12juri=arcgis_2023 permit_state=12 n_misrouted=3073Sep 16, 2026, 7:44 AM UTC
MAJORR-CROSSTABLE-001P3 Cross-Field ConsistencyPARCEL_PERMITS.—— (table-wide)12juri=arcgis_28 permit_state=12 n_misrouted=38867Sep 16, 2026, 7:44 AM UTC
MAJORR-CROSSTABLE-001P3 Cross-Field ConsistencyPARCEL_PERMITS.—— (table-wide)26juri=Building Permits 2015-2019 permit_state=26 n_misrouted=356Sep 16, 2026, 7:44 AM UTC
MAJORR-CROSSTABLE-001P3 Cross-Field ConsistencyPARCEL_PERMITS.—— (table-wide)12juri=arcgis_29 permit_state=12 n_misrouted=77764Sep 16, 2026, 7:44 AM UTC
MAJORR-CROSSTABLE-001P3 Cross-Field ConsistencyPARCEL_PERMITS.—— (table-wide)12juri=arcgis_4902 permit_state=12 n_misrouted=1452Sep 16, 2026, 7:44 AM UTC
MAJORR-CROSSTABLE-001P3 Cross-Field ConsistencyPARCEL_PERMITS.—— (table-wide)12juri=Stormwater Operating Permits - City of Tallahassee permit_state=12 n_misrouted=117Sep 16, 2026, 7:44 AM UTC
MAJORR-CROSSTABLE-001P3 Cross-Field ConsistencyPARCEL_PERMITS.—— (table-wide)12juri=arcgis_1601 permit_state=12 n_misrouted=17410Sep 16, 2026, 7:44 AM UTC
MAJORR-CROSSTABLE-001P3 Cross-Field ConsistencyPARCEL_PERMITS.—— (table-wide)12juri=arcgis_201 permit_state=12 n_misrouted=1783Sep 16, 2026, 7:44 AM UTC
MAJORR-CROSSTABLE-001P3 Cross-Field ConsistencyPARCEL_PERMITS.—— (table-wide)16juri=Regional Building Permits permit_state=16 n_misrouted=375Sep 16, 2026, 7:44 AM UTC
MAJORR-CROSSTABLE-001P3 Cross-Field ConsistencyPARCEL_PERMITS.—— (table-wide)12juri=Miami, FL (City) permit_state=12 n_misrouted=133182Sep 16, 2026, 7:44 AM UTC
MAJORR-CROSSTABLE-001P3 Cross-Field ConsistencyPARCEL_PERMITS.—— (table-wide)12juri=Parcels with Pop-Up permit_state=12 n_misrouted=89486Sep 16, 2026, 7:44 AM UTC
MAJORR-CROSSTABLE-001P3 Cross-Field ConsistencyPARCEL_PERMITS.—— (table-wide)12juri=arcgis_2219 permit_state=12 n_misrouted=22820Sep 16, 2026, 7:44 AM UTC
MAJORR-CROSSTABLE-001P3 Cross-Field ConsistencyPARCEL_PERMITS.—— (table-wide)12juri=arcgis_2453 permit_state=12 n_misrouted=934Sep 16, 2026, 7:44 AM UTC
MAJORR-CROSSTABLE-001P3 Cross-Field ConsistencyPARCEL_PERMITS.—— (table-wide)12juri=arcgis_2329 permit_state=12 n_misrouted=391Sep 16, 2026, 7:44 AM UTC
MAJORR-CROSSTABLE-001P3 Cross-Field ConsistencyPARCEL_PERMITS.—— (table-wide)22Sep 16, 2026, 7:44 AM UTC
MAJORR-CROSSTABLE-001P3 Cross-Field ConsistencyPARCEL_PERMITS.—— (table-wide)23juri=New Dwellings - Census - Approved Building Permits permit_state=23 n_misrouted=784Sep 16, 2026, 7:44 AM UTC
MAJORR-CROSSTABLE-001P3 Cross-Field ConsistencyPARCEL_PERMITS.—— (table-wide)24juri=Permits Prior to 2022 permit_state=24 n_misrouted=598Sep 16, 2026, 7:44 AM UTC
MAJORR-CROSSTABLE-001P3 Cross-Field ConsistencyPARCEL_PERMITS.—— (table-wide)36juri=socrata_310 permit_state=36 n_misrouted=231Sep 16, 2026, 7:44 AM UTC
MAJORR-CROSSFIELD-001P3 Cross-Field ConsistencyPARCEL_ENRICHED.—— (table-wide)37state=37 both_present=3992330 yb_more_than_50y_after_sale=120135 rate=3.01%Sep 16, 2026, 7:17 AM UTC
MAJORR-CROSSFIELD-001P3 Cross-Field ConsistencyPARCEL_ENRICHED.—— (table-wide)11state=11 both_present=199124 yb_more_than_50y_after_sale=4105 rate=2.06%Sep 16, 2026, 7:17 AM UTC
MAJORR-CROSSFIELD-001P3 Cross-Field ConsistencyPARCEL_ENRICHED.—— (table-wide)04state=04 both_present=1976821 yb_more_than_50y_after_sale=613720 rate=31.05%Sep 16, 2026, 7:17 AM UTC
MAJORR-COVERAGE-013P7 Coverage & CompletenessPARCEL_ENRICHED.YEAR_BUILT— (table-wide)YEAR_BUILT populated 73.86% (expected >= 88%)Sep 16, 2026, 7:17 AM UTC
MAJORR-COVERAGE-008P7 Coverage & CompletenessPARCEL_ENRICHED.MARKET_VALUE— (table-wide)MARKET_VALUE populated 42.01% (expected >= 53%)Sep 16, 2026, 6:58 AM UTC
MAJORR-COVERAGE-007P7 Coverage & CompletenessPARCEL_ENRICHED.TOTAL_ASSESSED_VALUE— (table-wide)TOTAL_ASSESSED_VALUE populated 58.13% (expected >= 66%)Sep 16, 2026, 6:54 AM UTC
MAJORR-COVERAGE-006P7 Coverage & CompletenessPARCEL_ENRICHED.OWNER_MAILING_ADDRESS— (table-wide)OWNER_MAILING_ADDRESS populated 33.85% (expected >= 42%)Sep 16, 2026, 6:49 AM UTC
Page 2 of 4 · 166 findings

Run history · last 14 days

StartedStatusTriggerRulesFindingsDurationRun ID
Sep 17, 2026, 6:00 AM UTCrunninghetzner-systemd00c30df67a…
Sep 16, 2026, 6:00 AM UTCsuccesshetzner-systemd5416313,708sc606c779…
Sep 15, 2026, 6:00 AM UTCsuccesshetzner-systemd5416312,962sb9d2b7c3…
Sep 14, 2026, 6:00 AM UTCsuccesshetzner-systemd5416313,042s21e224f8…
Sep 13, 2026, 6:00 AM UTCsuccesshetzner-systemd5416313,228sd918db84…
Sep 12, 2026, 6:00 AM UTCsuccesshetzner-systemd5416314,581s349442a4…
Sep 11, 2026, 6:00 AM UTCsuccesshetzner-systemd5416315,308s09654119…
Sep 10, 2026, 6:00 AM UTCsuccesshetzner-systemd5416313,662s5eb160db…
Sep 9, 2026, 6:00 AM UTCsuccesshetzner-systemd5421012,338s72a600d7…
Sep 8, 2026, 6:00 AM UTCsuccesshetzner-systemd5421012,786se0b70699…
Sep 7, 2026, 6:00 AM UTCpartialhetzner-systemd5320515,032saeefcbb6…
Sep 6, 2026, 6:00 AM UTCsuccesshetzner-systemd5420615,141sf2499392…
Sep 5, 2026, 6:00 AM UTCsuccesshetzner-systemd5420614,994sb8236cf3…
Sep 4, 2026, 6:00 AM UTCsuccesshetzner-systemd5420615,217s58c2b75b…

Schema · audit.findings · indexed by (run_id, rule_id) · append-only · PII redacted at write. Rules versioned in audit.rules.