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.