deal schema documentation | mike bommarito

overview

this document provides comprehensive documentation for the data center deal and transaction json schema used throughout the database. deals represent major transactions including acquisitions, joint ventures, power purchase agreements, and strategic partnerships that shape the data center landscape.

schema versions

current version: 1.0 (october 2025)
file locations: embedded within project and entity records
deal types: m&a, joint ventures, ppas, strategic partnerships, sale-leasebacks

deal object schema

core identification fields

Field	Type	Required	Description
dealId	string	yes	unique identifier for the deal
dealType	enum	yes	acquisition \| joint_venture \| ppa \| partnership \| sale_leaseback \| development
dealName	string	yes	human-readable deal name or description
announcementDate	date	yes	date deal was publicly announced (YYYY-MM-DD)
closingDate	date	no	date deal closed or expected to close
status	enum	yes	announced \| pending \| closed \| terminated

financial terms

Field	Type	Required	Description
dealValue	object	no	total transaction value
dealValue.amount	number	no	deal value in USD
dealValue.currency	string	no	currency code (default: USD)
dealValue.type	enum	no	enterprise_value \| equity_value \| asset_value
investmentCommitment	number	no	committed investment amount in USD
financingStructure	string	no	description of financing (debt, equity, hybrid)

participants

Field	Type	Required	Description
participants	array	yes	array of deal participants
participant.entity	string	yes	entity name
participant.entityId	string	no	reference to entity schema id
participant.role	enum	yes	buyer \| seller \| jv_partner \| investor \| lender \| advisor
participant.ownership	number	no	ownership percentage (0-100)

assets and scope

Field	Type	Required	Description
assets	object	no	assets involved in deal
assets.facilities	array	no	data center facilities included
assets.landAcres	number	no	total land in acres
assets.powerCapacityMW	number	no	total power capacity in megawatts
assets.squareFeet	number	no	total facility square footage
projectIds	array	no	references to related project ids

power and infrastructure

Field	Type	Required	Description
powerAgreement	object	no	power purchase agreement details
powerAgreement.type	enum	no	ppa \| nuclear \| renewable \| grid
powerAgreement.capacityMW	number	no	contracted power capacity
powerAgreement.duration	number	no	agreement duration in years
powerAgreement.technology	string	no	solar \| wind \| nuclear_smr \| natural_gas

deal type definitions

acquisition deals

standard m&a transactions where one entity purchases another:

{
  "dealType": "acquisition",
  "participants": [
    {
      "entity": "Blackstone",
      "role": "buyer",
      "ownership": 100
    },
    {
      "entity": "QTS Realty Trust",
      "role": "seller"
    }
  ],
  "dealValue": {
    "amount": 10000000000,
    "type": "enterprise_value"
  }
}

joint ventures

strategic partnerships with shared ownership:

{
  "dealType": "joint_venture",
  "dealName": "Prince William Digital Gateway",
  "participants": [
    {
      "entity": "QTS",
      "role": "jv_partner",
      "ownership": 50
    },
    {
      "entity": "Compass Datacenters",
      "role": "jv_partner",
      "ownership": 50
    }
  ],
  "investmentCommitment": 24700000000
}

power purchase agreements

long-term power contracts, especially for renewable or nuclear:

{
  "dealType": "ppa",
  "dealName": "Microsoft Three Mile Island Restart",
  "participants": [
    {
      "entity": "Microsoft",
      "role": "buyer"
    },
    {
      "entity": "Constellation Energy",
      "role": "seller"
    }
  ],
  "powerAgreement": {
    "type": "nuclear",
    "capacityMW": 837,
    "duration": 20,
    "technology": "nuclear_smr"
  }
}

sale-leaseback transactions

entity sells facility but leases it back:

{
  "dealType": "sale_leaseback",
  "participants": [
    {
      "entity": "Meta",
      "role": "seller"
    },
    {
      "entity": "Digital Realty",
      "role": "buyer"
    }
  ],
  "dealValue": {
    "amount": 500000000,
    "type": "asset_value"
  },
  "assets": {
    "facilities": ["Meta Huntsville DC"],
    "powerCapacityMW": 100
  }
}

validation rules

required field combinations

if dealType is “acquisition”, must have dealValue
if dealType is “ppa”, must have powerAgreement
if dealType is “joint_venture”, must have multiple participants with role: "jv_partner"

date validations

announcementDate cannot be in the future
closingDate must be after or equal to announcementDate
if status is “closed”, closingDate is required

financial validations

dealValue.amount must be positive
participant.ownership must be between 0 and 100
sum of ownership for all jv_partner roles should equal 100

example complete deal record

{
  "dealId": "deal-2024-aws-edgecore-louisacounty",
  "dealType": "development",
  "dealName": "AWS EdgeCore Louisa County Development",
  "announcementDate": "2024-07-15",
  "closingDate": "2024-08-01",
  "status": "closed",
  "dealValue": {
    "amount": 17000000000,
    "currency": "USD",
    "type": "asset_value"
  },
  "investmentCommitment": 17000000000,
  "participants": [
    {
      "entity": "Amazon Web Services",
      "entityId": "entity-aws",
      "role": "buyer",
      "ownership": 100
    },
    {
      "entity": "EdgeCore Digital Infrastructure",
      "entityId": "entity-edgecore",
      "role": "seller"
    }
  ],
  "assets": {
    "facilities": ["EdgeCore Louisa County Campus"],
    "landAcres": 2200,
    "powerCapacityMW": 1100,
    "squareFeet": 3900000
  },
  "projectIds": ["va-louisa-edgecore-campus"],
  "sources": [
    {
      "name": "Reuters",
      "url": "https://www.reuters.com/business/aws-edgecore-louisa-county/",
      "date": "2024-07-15"
    }
  ]
}

integration with project schema

deals are referenced within project records:

{
  "projectId": "va-ashburn-quantum-loophole",
  "relatedDeals": [
    {
      "dealId": "deal-2024-quantum-tpg",
      "dealType": "investment",
      "role": "target"
    }
  ]
}

integration with entity schema

entities track their deal history:

{
  "entityId": "entity-qts",
  "dealHistory": [
    {
      "dealId": "deal-2021-blackstone-qts",
      "dealType": "acquisition",
      "role": "seller",
      "date": "2021-06-07",
      "value": 10000000000
    }
  ]
}

common queries

find all nuclear power deals

filter for dealType: "ppa" and powerAgreement.technology: "nuclear_smr"

track m&a consolidation

filter for dealType: "acquisition" and aggregate by buyer entity

identify joint venture partners

filter for dealType: "joint_venture" and extract participant pairs

project schema - core project data structure
entity schema - entity profiles and relationships
data sources - methodology and source documentation
economics & deals - analysis of major transactions

data quality notes

deal values often undisclosed or reported as ranges
closing dates may be projected and subject to change
ownership percentages in joint ventures sometimes confidential
power agreement terms frequently under nda
multiple sources required for validation

schema version 1.0 - last updated: october 17, 2025