{
  "generated_at": "2026-02-22T14:10:19+00:00",
  "db": "etl/data/staging/politicos-es.db",
  "doc_source_id": "parl_initiative_docs",
  "initiative_source_ids": [
    "congreso_iniciativas",
    "senado_iniciativas"
  ],
  "overall": {
    "initiatives_total": 4036,
    "initiatives_with_doc_links": 4006,
    "total_doc_links": 9085,
    "downloaded_doc_links": 8966,
    "missing_doc_links": 119,
    "doc_links_with_fetch_status": 9085,
    "doc_links_missing_fetch_status": 0,
    "downloaded_with_excerpt": 8966,
    "downloaded_missing_excerpt": 0,
    "linked_to_votes_total": 751,
    "linked_to_votes_with_downloaded_docs": 751,
    "missing_doc_links_likely_not_expected": 115,
    "missing_doc_links_actionable": 4,
    "initiatives_with_doc_links_pct": 99.26,
    "downloaded_doc_links_pct": 98.69,
    "fetch_status_coverage_pct": 100.0,
    "excerpt_coverage_pct": 100.0,
    "linked_to_votes_with_downloaded_docs_pct": 100.0,
    "effective_downloaded_doc_links_pct": 99.96
  },
  "by_source": {
    "congreso_iniciativas": {
      "initiatives_total": 429,
      "initiatives_with_doc_links": 399,
      "initiatives_with_doc_links_pct": 93.01,
      "total_doc_links": 812,
      "downloaded_doc_links": 812,
      "missing_doc_links": 0,
      "downloaded_doc_links_pct": 100.0,
      "doc_links_with_fetch_status": 812,
      "doc_links_missing_fetch_status": 0,
      "fetch_status_coverage_pct": 100.0,
      "downloaded_with_excerpt": 812,
      "downloaded_missing_excerpt": 0,
      "excerpt_coverage_pct": 100.0,
      "linked_to_votes_total": 104,
      "linked_to_votes_with_downloaded_docs": 104,
      "linked_to_votes_with_downloaded_docs_pct": 100.0,
      "missing_status_buckets": [],
      "missing_urls_sample": [],
      "doc_kind_breakdown": [
        {
          "doc_kind": "bocg",
          "total_links": 624,
          "downloaded_links": 624,
          "missing_links": 0,
          "downloaded_pct": 100.0
        },
        {
          "doc_kind": "ds",
          "total_links": 188,
          "downloaded_links": 188,
          "missing_links": 0,
          "downloaded_pct": 100.0
        }
      ],
      "missing_doc_links_likely_not_expected": 0,
      "missing_doc_links_actionable": 0,
      "effective_downloaded_doc_links_pct": 100.0
    },
    "senado_iniciativas": {
      "initiatives_total": 3607,
      "initiatives_with_doc_links": 3607,
      "initiatives_with_doc_links_pct": 100.0,
      "total_doc_links": 8273,
      "downloaded_doc_links": 8154,
      "missing_doc_links": 119,
      "downloaded_doc_links_pct": 98.56,
      "doc_links_with_fetch_status": 8273,
      "doc_links_missing_fetch_status": 0,
      "fetch_status_coverage_pct": 100.0,
      "downloaded_with_excerpt": 8154,
      "downloaded_missing_excerpt": 0,
      "excerpt_coverage_pct": 100.0,
      "linked_to_votes_total": 647,
      "linked_to_votes_with_downloaded_docs": 647,
      "linked_to_votes_with_downloaded_docs_pct": 100.0,
      "missing_status_buckets": [
        {
          "status": 404,
          "count": 119
        }
      ],
      "missing_urls_sample": [
        {
          "initiative_id": "senado:leg10:exp:610/000002",
          "doc_kind": "bocg",
          "doc_url": "http://www.senado.es/legis10/expedientes/610/enmiendas/global_enmiendas_vetos_10_610000002.xml",
          "last_http_status": 404,
          "attempts": 120,
          "last_attempt_at": "2026-02-22T13:50:06+00:00"
        },
        {
          "initiative_id": "senado:leg10:exp:610/000005",
          "doc_kind": "bocg",
          "doc_url": "http://www.senado.es/legis10/expedientes/610/enmiendas/global_enmiendas_vetos_10_610000005.xml",
          "last_http_status": 404,
          "attempts": 120,
          "last_attempt_at": "2026-02-22T13:50:06+00:00"
        },
        {
          "initiative_id": "senado:leg10:exp:610/000003",
          "doc_kind": "bocg",
          "doc_url": "http://www.senado.es/legis10/expedientes/610/enmiendas/global_enmiendas_vetos_10_610000003.xml",
          "last_http_status": 404,
          "attempts": 119,
          "last_attempt_at": "2026-02-22T13:50:06+00:00"
        },
        {
          "initiative_id": "senado:leg10:exp:610/000004",
          "doc_kind": "bocg",
          "doc_url": "http://www.senado.es/legis10/expedientes/610/enmiendas/global_enmiendas_vetos_10_610000004.xml",
          "last_http_status": 404,
          "attempts": 119,
          "last_attempt_at": "2026-02-22T13:50:06+00:00"
        },
        {
          "initiative_id": "senado:leg10:exp:610/000006",
          "doc_kind": "bocg",
          "doc_url": "http://www.senado.es/legis10/expedientes/610/enmiendas/global_enmiendas_vetos_10_610000006.xml",
          "last_http_status": 404,
          "attempts": 119,
          "last_attempt_at": "2026-02-22T13:50:06+00:00"
        },
        {
          "initiative_id": "senado:leg10:exp:610/000007",
          "doc_kind": "bocg",
          "doc_url": "http://www.senado.es/legis10/expedientes/610/enmiendas/global_enmiendas_vetos_10_610000007.xml",
          "last_http_status": 404,
          "attempts": 119,
          "last_attempt_at": "2026-02-22T13:50:06+00:00"
        },
        {
          "initiative_id": "senado:leg10:exp:610/000008",
          "doc_kind": "bocg",
          "doc_url": "http://www.senado.es/legis10/expedientes/610/enmiendas/global_enmiendas_vetos_10_610000008.xml",
          "last_http_status": 404,
          "attempts": 119,
          "last_attempt_at": "2026-02-22T13:50:06+00:00"
        },
        {
          "initiative_id": "senado:leg10:exp:610/000009",
          "doc_kind": "bocg",
          "doc_url": "http://www.senado.es/legis10/expedientes/610/enmiendas/global_enmiendas_vetos_10_610000009.xml",
          "last_http_status": 404,
          "attempts": 119,
          "last_attempt_at": "2026-02-22T13:50:06+00:00"
        },
        {
          "initiative_id": "senado:leg10:exp:610/000010",
          "doc_kind": "bocg",
          "doc_url": "http://www.senado.es/legis10/expedientes/610/enmiendas/global_enmiendas_vetos_10_610000010.xml",
          "last_http_status": 404,
          "attempts": 119,
          "last_attempt_at": "2026-02-22T13:50:06+00:00"
        },
        {
          "initiative_id": "senado:leg10:exp:610/000011",
          "doc_kind": "bocg",
          "doc_url": "http://www.senado.es/legis10/expedientes/610/enmiendas/global_enmiendas_vetos_10_610000011.xml",
          "last_http_status": 404,
          "attempts": 119,
          "last_attempt_at": "2026-02-22T13:50:06+00:00"
        }
      ],
      "doc_kind_breakdown": [
        {
          "doc_kind": "bocg",
          "total_links": 3969,
          "downloaded_links": 3850,
          "missing_links": 119,
          "downloaded_pct": 97.0
        },
        {
          "doc_kind": "ds",
          "total_links": 4304,
          "downloaded_links": 4304,
          "missing_links": 0,
          "downloaded_pct": 100.0
        }
      ],
      "global_enmiendas_vetos_analysis": {
        "total_global_enmiendas_missing": 119,
        "likely_not_expected_zero_enmiendas": 115,
        "actionable_missing_count": 4,
        "no_ini_downloaded": 0,
        "classification_counts": {
          "likely_not_expected_zero_enmiendas": 115,
          "has_enmiendas_or_unknown": 4
        },
        "actionable_missing_sample": [
          {
            "initiative_id": "senado:leg15:exp:600/000001",
            "doc_url": "https://www.senado.es/legis15/expedientes/600/enmiendas/global_enmiendas_vetos_15_600000001.xml",
            "last_http_status": 404,
            "attempts": 118,
            "last_attempt_at": "2026-02-22T13:50:06+00:00",
            "classification": "has_enmiendas_or_unknown",
            "ini_raw_path": "",
            "detail_raw_path": "etl/data/raw/text_documents/parl_initiative_docs/3536a3b070994ec3e1eb1a782590ecc30b04f149bf9643c713c58a40a8d6593e.bin",
            "enm_cantidad": "3",
            "enm_url": "/web/actividadparlamentaria/iniciativas/enmiendas/index.html?legis=15=600=000001"
          },
          {
            "initiative_id": "senado:leg12:exp:626/000002",
            "doc_url": "http://www.senado.es/legis12/expedientes/626/enmiendas/global_enmiendas_vetos_12_626000002.xml",
            "last_http_status": 404,
            "attempts": 117,
            "last_attempt_at": "2026-02-22T13:50:06+00:00",
            "classification": "has_enmiendas_or_unknown",
            "ini_raw_path": "",
            "detail_raw_path": "etl/data/raw/text_documents/parl_initiative_docs/0181a540f51b978580a7bbcecddc893c0928679177c6faeaa603e117e6bd64f6.bin",
            "enm_cantidad": "2",
            "enm_url": "/web/actividadparlamentaria/iniciativas/enmiendas/index.html?legis=12&id1=626&id2=000002"
          },
          {
            "initiative_id": "senado:leg15:exp:626/000009",
            "doc_url": "https://www.senado.es/legis15/expedientes/626/enmiendas/global_enmiendas_vetos_15_626000009.xml",
            "last_http_status": 404,
            "attempts": 115,
            "last_attempt_at": "2026-02-22T13:50:06+00:00",
            "classification": "has_enmiendas_or_unknown",
            "ini_raw_path": "",
            "detail_raw_path": "etl/data/raw/text_documents/parl_initiative_docs/48f73e2d113ff7737496a6dfb6276344ca228f63abef3ea1e38a5e5e1f06119e.bin",
            "enm_cantidad": "2",
            "enm_url": "/web/actividadparlamentaria/iniciativas/enmiendas/index.html?legis=15=626=000009"
          },
          {
            "initiative_id": "senado:leg14:exp:620/000001",
            "doc_url": "https://www.senado.es/legis14/expedientes/620/enmiendas/global_enmiendas_vetos_14_620000001.xml",
            "last_http_status": 404,
            "attempts": 114,
            "last_attempt_at": "2026-02-22T13:50:06+00:00",
            "classification": "has_enmiendas_or_unknown",
            "ini_raw_path": "",
            "detail_raw_path": "etl/data/raw/text_documents/parl_initiative_docs/7398f7bf97c972098911ff29b58d1720e9d11ad37b735b3d52e174245209021b.bin",
            "enm_cantidad": "1",
            "enm_url": "/web/actividadparlamentaria/iniciativas/enmiendas/index.html?legis=14=620=000001"
          }
        ]
      },
      "missing_doc_links_likely_not_expected": 115,
      "missing_doc_links_actionable": 4,
      "effective_downloaded_doc_links_pct": 99.95
    }
  }
}