Codebook
Codebook and data dictionary
Every field, its file, type, allowed values and the rule used to code it.
96 of 96 fields
| Field | Plain meaning | Allowed values | File | Known in |
|---|---|---|---|---|
| deal_id | Stable identifier: buyer-target-year | – | deals.json | 109 of 109 deals (100%) |
| announce_date | First public announcement (YYYY-MM-DD, or YYYY-MM where only month known) | – | deals.json | 109 of 109 deals (100%) |
| date_precision | day / month / year | – | deals.json | 109 of 109 deals (100%) |
| acquirer | Buying company | – | deals.json | 109 of 109 deals (100%) |
| acquirer_country | Buyer headquarters country | – | deals.json | 96 of 109 deals (88%) |
| target | Startup or lab | – | deals.json | 109 of 109 deals (100%) |
| target_country | Target operating country | – | deals.json | 98 of 109 deals (90%) |
| target_focus | What the target does, from sources | – | deals.json | 109 of 109 deals (100%) |
| deal_type | LICENCE_AND_HIRE, TEAM_ONLY_HIRE, MINORITY_STAKE_CONTROL, COMPUTE_FOR_EQUITY, OTHER_HYBRID | – | deals.json | 109 of 109 deals (100%) |
| licence_included | yes / no / not disclosed | – | deals.json | 25 of 109 deals (23%) |
| licence_exclusive | yes / no / not disclosed | yes / no / not disclosed | deals.json | 19 of 109 deals (17%) |
| equity_stake_pct | Buyer shareholding after the deal, percent | – | deals.json | 6 of 109 deals (6%) |
| disclosed_value_usd | Disclosed consideration in USD; never estimated | – | deals.json | 30 of 109 deals (28%) |
| value_note | Scope of the value: what it covers | – | deals.json | 36 of 109 deals (33%) |
| value_basis | filed / approximate / reported | – | deals.json | 45 of 109 deals (41%) |
| value_source_grade | Grade of the best source for the value | – | deals.json | 43 of 109 deals (39%) |
| founders_moved | Founders who joined the buyer | – | deals.json | 26 of 109 deals (24%) |
| founder_move_confirmed | See codebook | – | deals.json | 25 of 109 deals (23%) |
| staff_moved | Number or description of staff who moved | – | deals.json | 16 of 109 deals (15%) |
| target_staff_before | See codebook | – | deals.json | 0 of 109 deals (0%) |
| target_status_after | continued / pivoted / product discontinued / wound down / bankruptcy / sold | – | deals.json | 66 of 109 deals (61%) |
| status_date | Date of the status observation | – | deals.json | 57 of 109 deals (52%) |
| target_status_note | See codebook | – | deals.json | 3 of 109 deals (3%) |
| investor_outcome | See codebook | – | deals.json | 6 of 109 deals (6%) |
| employee_outcome | See codebook | – | deals.json | 2 of 109 deals (2%) |
| target_last_valuation_usd | See codebook | – | deals.json | 12 of 109 deals (11%) |
| valuation_date | See codebook | – | deals.json | 6 of 109 deals (6%) |
| regulatory_review | Highest level of regulator review known | none known / not disclosed / letters from US senators / inquiry opened / formal review / cleared | deals.json | 75 of 109 deals (69%) |
| regulatory_detail | Short neutral description | – | deals.json | 24 of 109 deals (22%) |
| regulatory_events | – | – | deals.json | 28 of 109 deals (26%) |
| conflict | See codebook | – | deals.json | 7 of 109 deals (6%) |
| date_basis | See codebook | – | deals.json | 76 of 109 deals (70%) |
| notes | See codebook | – | deals.json | 79 of 109 deals (72%) |
| completeness | See codebook | – | deals.json | 96 of 109 deals (88%) |
| sources | – | – | deals.json | 109 of 109 deals (100%) |
| buyer_tier | mega-cap over $100bn / other listed / AI lab | – | deals.json | 96 of 109 deals (88%) |
| remainder_after | Status of the remaining company | – | deals.json | 33 of 109 deals (30%) |
| remainder_date | See codebook | – | deals.json | 32 of 109 deals (29%) |
| remainder_valuation_after_usd | See codebook | – | deals.json | 21 of 109 deals (19%) |
| founder_retention | See codebook | – | deals.json | 8 of 109 deals (7%) |
| relationship_id | Links tranches of one relationship | – | deals.json | 75 of 109 deals (69%) |
| tranche_count | See codebook | – | deals.json | 62 of 109 deals (57%) |
| hsr_threshold_multiple | See codebook | – | deals.json | 20 of 109 deals (18%) |
| index_tier | core (strict control rule), extended (investment plus commercial tie-in, or AI infrastructure), hold (evidence below threshold) | – | deals.json | 109 of 109 deals (100%) |
| target_layer | Foundation models, applied AI and agents, infrastructure, etc. | – | deals.json | 63 of 109 deals (58%) |
| company_rationale | Reason given by the companies, quoted or closely paraphrased | – | deals.json | 37 of 109 deals (34%) |
| threshold_jurisdiction | Target operating-country proxy for merger thresholds (not a finding that a filing was required) | – | deals.json | 75 of 109 deals (69%) |
| threshold_year | See codebook | – | deals.json | 47 of 109 deals (43%) |
| deal_stage | See codebook | – | deals.json | 76 of 109 deals (70%) |
| staff_offers_reported | Employment offers reported (not completed hires) | – | deals.json | 2 of 109 deals (2%) |
| staff_hired_pct | See codebook | – | deals.json | 0 of 109 deals (0%) |
| structure_facts | See codebook | – | deals.json | 108 of 109 deals (99%) |
| voting_board_seat | Buyer holds a voting board seat (yes/no/not disclosed) | – | deals.json | 7 of 109 deals (6%) |
| board_observer_or_committee | Observer or advisory committee seat | – | deals.json | 4 of 109 deals (4%) |
| veto_or_reserved_matters | Buyer veto rights | – | deals.json | 3 of 109 deals (3%) |
| exclusivity | Commercial exclusivity linked to the deal | – | deals.json | 7 of 109 deals (6%) |
| right_of_first_refusal | ROFR held by buyer | – | deals.json | 4 of 109 deals (4%) |
| contractual_consultation_rights | Consultation rights | – | deals.json | 4 of 109 deals (4%) |
| licence_exclusive_confirmed | Exclusivity stated in an official source | – | deals.json | 16 of 109 deals (15%) |
| cloud_compute_spending_commitment | Target compute spend commitment tied to stake | – | deals.json | 8 of 109 deals (7%) |
| remainder_valuation_after_date | See codebook | – | deals.json | 20 of 109 deals (18%) |
| total_funding_raised_usd | See codebook | – | deals.json | 8 of 109 deals (7%) |
| lead_investors | See codebook | – | deals.json | 7 of 109 deals (6%) |
| payout_detail | See codebook | – | deals.json | 3 of 109 deals (3%) |
| remainder_6m | Remainder status about 6 months after announcement | – | deals.json | 30 of 109 deals (28%) |
| remainder_6m_observed_date | See codebook | – | deals.json | 16 of 109 deals (15%) |
| remainder_12m | About 12 months after | – | deals.json | 52 of 109 deals (48%) |
| remainder_12m_observed_date | See codebook | – | deals.json | 12 of 109 deals (11%) |
| remainder_24m | About 24 months after | – | deals.json | 76 of 109 deals (70%) |
| remainder_24m_observed_date | See codebook | – | deals.json | 6 of 109 deals (6%) |
| jurisdiction_basis | See codebook | – | deals.json | 47 of 109 deals (43%) |
| tier_reason | Why the record sits in its tier | – | deals.json | 96 of 109 deals (88%) |
| headline_check | – | – | deals.json | 109 of 109 deals (100%) |
| money_components | – | – | deals.json | 29 of 109 deals (27%) |
| tier_rule | – | – | deals.json | 96 of 109 deals (88%) |
| field_notes | – | – | deals.json | 104 of 109 deals (95%) |
| conflicts | – | – | deals.json | 13 of 109 deals (12%) |
| incorporation_jurisdiction | – | – | deals.json | 3 of 109 deals (3%) |
| observations | – | – | deals.json | 51 of 109 deals (47%) |
| deal_type_previous | – | – | deals.json | 37 of 109 deals (34%) |
| advisers | – | – | deals.json | 12 of 109 deals (11%) |
| evidence_status | See codebook | – | deals.json | 9 of 109 deals (8%) |
| value_scope | See codebook | – | deals.json | 20 of 109 deals (18%) |
| date_evidence_rule | – | – | deals.json | 16 of 109 deals (15%) |
| hsr_threshold_usd | See codebook | – | deals.json | 20 of 109 deals (18%) |
| funding_lead_for_review | See codebook | – | deals.json | 1 of 109 deals (1%) |
| dma_notification_date | Date of EU DMA Article 14 notification | – | deals.json | 15 of 109 deals (14%) |
| company_rationale_parts | – | – | deals.json | 12 of 109 deals (11%) |
| tier_previous | – | – | deals.json | 3 of 109 deals (3%) |
| research_lead | See codebook | – | deals.json | 2 of 109 deals (2%) |
| wind_down_notice | See codebook | – | deals.json | 1 of 109 deals (1%) |
| regulator_doc_url | See codebook | – | deals.json | 0 of 109 deals (0%) |
| source_round | See codebook | – | deals.json | 34 of 109 deals (31%) |
| money_type | – | – | deals.json | 13 of 109 deals (12%) |
| note | – | – | deals.json | 11 of 109 deals (10%) |
| added_in | – | – | deals.json | 13 of 109 deals (12%) |