{
    "product": "reference_territory_source_fact_table",
    "status": "builder_ready",
    "generated_at": "2026-07-06T19:07:48+00:00",
    "schema_count": 13,
    "input_count": 5,
    "output_count": 2,
    "builder": "scripts/build_reference_territory_source_facts.php",
    "input_template": "sources/reference-territory-source-facts-template.csv",
    "schema": [
        {
            "column": "territory_key",
            "description": "Cle territoire canonique, par exemple commune:33063 ou region:naq."
        },
        {
            "column": "territory_grain",
            "description": "Maille de la valeur : commune, dep, reg, country, etc."
        },
        {
            "column": "source_key",
            "description": "Source normalisee ou monitoring source."
        },
        {
            "column": "entity_key",
            "description": "Identifiant entite source ou agregat."
        },
        {
            "column": "kpi_family",
            "description": "Famille de KPI Winerix."
        },
        {
            "column": "kpi_key",
            "description": "KPI activable dans les scorecards."
        },
        {
            "column": "value",
            "description": "Valeur source ou agregat."
        },
        {
            "column": "unit",
            "description": "Unite : score_0_100, facility_count, presence."
        },
        {
            "column": "time_period",
            "description": "Annee, date ou periode source."
        },
        {
            "column": "confidence_hint",
            "description": "Indice de qualite ou statut issu de la source."
        },
        {
            "column": "source_url",
            "description": "URL source publique."
        },
        {
            "column": "caveat",
            "description": "Limite source a conserver dans la publication."
        },
        {
            "column": "normalized_at",
            "description": "Horodatage de construction de la table faits."
        }
    ],
    "inputs": [
        {
            "source_key": "datatourisme_fidelity_monitor",
            "input_file": "sources/datatourisme-fidelity-monitor.csv",
            "fact_strategy": "Freshness and regional coverage facts by country or region.",
            "scorecards": [
                "data_trust",
                "publication_readiness"
            ]
        },
        {
            "source_key": "openagenda_wine_events",
            "input_file": "sources/openagenda-wine-events-normalized.csv",
            "fact_strategy": "Wine event facts by commune when rows pass relevance threshold.",
            "scorecards": [
                "market_pull"
            ]
        },
        {
            "source_key": "bnlc_carpooling_areas",
            "input_file": "sources/bnlc-carpooling-areas-normalized.csv",
            "fact_strategy": "Carpool access facts by commune.",
            "scorecards": [
                "low_carbon_access"
            ]
        },
        {
            "source_key": "merimee_heritage_monuments",
            "input_file": "sources/merimee-monuments-normalized.csv",
            "fact_strategy": "Heritage signal facts by commune.",
            "scorecards": [
                "culture_story"
            ]
        },
        {
            "source_key": "insee_bpe_equipment",
            "input_file": "sources/insee-bpe-2024-equipment-normalized.csv",
            "fact_strategy": "Aggregated equipment facts by territory grain and KPI family.",
            "scorecards": [
                "experience_readiness",
                "culture_story",
                "low_carbon_access"
            ]
        }
    ],
    "outputs": [
        {
            "key": "fact_table",
            "path": "sources/reference-territory-source-facts.csv",
            "description": "Unified territory/source/KPI fact table."
        },
        {
            "key": "summary",
            "path": "sources/reference-territory-source-facts-summary.csv",
            "description": "Source-level status and fact counts."
        }
    ],
    "source_products": [
        "reference_activation_outputs_manifest",
        "reference_territory_data_spine",
        "reference_territory_kpi_scorecard_pack"
    ],
    "publication_caveat": "The fact table is a normalized source-to-KPI layer. It does not imply database import, endpoint validation or final public score certification."
}