Version history

{
  "query_kind": "sql",
  "query_body": "WITH latest_scores AS (\n  SELECT\n    s.*,\n    ROW_NUMBER() OVER (\n      PARTITION BY s.entity_type, s.entity_id\n      ORDER BY s.created_at DESC, s.id DESC\n    ) AS rn\n  FROM artifact_signals s\n  WHERE s.kind = 'falsification_score'\n    AND s.dimension = 'strength'\n)\nSELECT (a.artifact_type || ':' || a.id::text) AS ref, a.title\nFROM artifacts a\nJOIN latest_scores fs\n  ON fs.entity_type = a.artifact_type\n AND fs.entity_id = a.id::text\n AND fs.rn = 1\nWHERE a.epistemic_tier IN ('T3', 'T4', 'T5')\n  AND a.is_latest = 1\n  AND fs.value >= 0.7\n  AND fs.created_at < NOW() - INTERVAL '7 days'\n  AND NOT EXISTS (\n    SELECT 1\n    FROM artifact_signals rebuttal_target\n    WHERE rebuttal_target.entity_type = a.artifact_type\n      AND rebuttal_target.entity_id = a.id::text\n      AND rebuttal_target.kind = 'falsification_rebutted'\n  )\n  AND NOT EXISTS (\n    SELECT 1\n    FROM artifact_signals rebuttal_attempt\n    WHERE rebuttal_attempt.entity_type = 'falsification_attempt'\n      AND rebuttal_attempt.entity_id = fs.metadata->>'attempt_id'\n      AND rebuttal_attempt.kind = 'falsification_rebutted'\n  )\n",
  "query_params": {},
  "threshold": {
    "warning_at": 1,
    "critical_at": 1
  },
  "severity_default": "critical",
  "recommended_action_template": "{n} T3+ artifact(s) have carried falsification_score ≥0.7 for\nmore than 7 days without a validated rebuttal. Block promotion\nabove T3 and open/triage the SPEC-022 collider for: {refs[:5]}.\n",
  "state": "active",
  "proposer_id": "system-senate"
}