Skip to content

Deal data

This processed-data family assembles current SEC XBRL acquisition disclosures and builds reviewable links from the reported deal parties to Revelio firms. The clean deal panel is the basis for the Table 9 data pipeline; the mapping tables retain candidate and audit information rather than silently forcing uncertain names to a match.

flowchart LR
    facts[(Reprocessed 10-K / 10-Q XBRL facts)]
    legacy[(Legacy goodwill CSV)]
    ref[(Revelio company reference)]
    deals[(Clean XBRL deal panel)]
    target_mapping[(Target–Revelio candidates)]
    acquirer_mapping[(Acquirer–Revelio candidates)]

    facts --> deals
    facts --> target_mapping
    facts --> acquirer_mapping
    legacy --> target_mapping
    legacy --> acquirer_mapping
    ref --> target_mapping
    ref --> acquirer_mapping

    classDef input fill:#e8eef7,stroke:#52739e,stroke-width:2px
    classDef process fill:#fff0d8,stroke:#b7791f,stroke-width:2px
    classDef reusable fill:#e2f2e7,stroke:#3b7a4b,stroke-width:2px
    class facts,legacy,ref input
    class deals,target_mapping,acquirer_mapping reusable

Products

Dataset Role Grain Current location
Clean XBRL deal panel Current processed deal facts Issuer CIK × reported target label /data/full/processed/raw/xbrl_deals.parquet
XBRL target–Revelio candidates Reviewable target-name mapping Reported target label × Revelio candidate /data/full/processed/mapping_xbrl_targets_revelio.parquet
XBRL acquirer–Revelio candidates Reviewable issuer mapping Reported CIK/name identity × Revelio parent candidate /data/full/processed/mapping_xbrl_acquirers_revelio.parquet

The mapping builders combine goodwill-bearing labels from the current deal panel with the legacy CSV at /data/xbrl_goodwill/goodwill_xbrl_20102022.csv. That legacy extract can contribute matching labels, but it is not the source for the current deal panel or Table 9 regression rows. The available year range in the current panel is set by the staged XBRL Parquets; the builder does not impose a fixed end year.

The later analysis workflow builds a deal-level regression panel, scores target workers against the acquirer, and estimates the goodwill regressions.