North American PPAs - Quarterly

WHAT THIS FILE IS

A register of the power purchase agreements announced for generating assets in the United States, Canada and Mexico since January 2024, as data you can filter, join and load into your own models. One row per agreement, each naming its buyer: the seller, where the asset is, the technology, capacity, tenor and structure where announced, and the sources.

Alongside the deals: every buyer and every seller with their deal counts, every company named with its type and home country, and a table of which company played which role in each deal.

Every value is as announced. A blank means the term was not announced, and nothing is estimated. Deal IDs are permanent and stay the same in every update.

WHAT YOU RECEIVE

An Excel workbook with a Read me sheet that explains every column, plus the same tables as CSV files that load without cleaning. Deal IDs are permanent and stay the same in every update.

• Sherpa Data … 2024-2026.xlsx
  • The workbook: Read me, Deals, Deal parties, Buyers, Sellers, Companies
• deals.csv / 269 rows
  • One row per PPA: buyer, seller, asset country, state or province, technology, capacity, tenor, structure, sources
• deal_parties.csv / 675 rows
  • Which company played which role in which deal
• buyers.csv / 156 rows
  • Every buyer, with type, home country, website and PPA count
• sellers.csv / 181 rows
  • Every developer, IPP or seller, with its PPA count
• companies.csv / 394 rows
  • Every company named, with type, home country and website
• README.txt
  • Selection rule, joins, counting rules and field coverage

PREVIEW

The first rows of each table, exactly as they appear in the file. The rest is in the download.

HOW COMPLETE EACH FIELD IS

Shown before you buy, so you know exactly what you are paying for. Nothing is estimated to fill a gap.

FIELD GUIDE

• Deal ID
  • Permanent record number (NA0001…). Unchanged in every update.
• Buyer(s) / Seller(s)
  • The buyer (offtaker) and the developer, IPP or seller, as named in the announcement.
• Asset country / State or province
  • Where the generating asset is. State or province as the announcement states it.
• Technology
  • Solar PV, onshore wind, nuclear, geothermal, hydro, storage, hybrid and so on.
• Capacity
  • As announced for the contract or project (MW, MWac, MWdc or GW). Never converted.
• Tenor / Structure
  • Contract length and structure (virtual, physical, sleeved) where announced.
• Disclosed value / Value (USD m)
  • The value as announced, and in US dollars millions where it was announced in dollars.
• Notes
  • Where a package and one of its contracts are both listed: do not add their capacities.
• Source / Second source
  • The announcement the record rests on, and an independent report of the same agreement where one exists.