Government Tender Data for Transformers, Delivered as Rows

Four kinds of record answer a transformer tender question, and they sit at four different grains. Award ledgers record what was actually bought: GeM - India Government e-Marketplace holds individual contract orders with fifteen documented fields per order - contract number, date, buying mode, status, organization type, ministry, department, buyer name, plus line-item product, brand, model, HSN code, quantity and unit price. Opportunity streams record what is about to be bought: GeM's bid listings and the SAM.gov Entity Registration & Contract Awards record's presolicitation notices surface requirements while scope is still being shaped. Official statistics size the market both sides of a bid sit in: ONS PRODCOM across roughly 3,805 product codes in the UK, the Ministry of Heavy Industries' fiscal-year capital-goods tables in India. And policy records decide who may supply at all: India's Electrical Equipment Quality Control Orders, tracked through their November 2025 deferments.

The honest boundary: no single record covers every country's transformer tenders. India's is the deepest - a whole-of-government order book rather than a summary table. The American federal layer publishes award notices at comparable depth but scattered across agencies. The UK publishes demand-side statistics rather than an open contract ledger of the same grain. Datadory catalogs all of them under one roof as typed, joinable rows - thirty records for this industry alone, fourteen primary to heavy electrical equipment - so the comparison becomes a query instead of a research project.

GeM - India Government e-Marketplace is where Indian public demand clears. Government e-Marketplace is wholly government-owned under the Department of Commerce and live since 2016, and every central ministry, CPSU and state buys through it: 137,779 primary buyers and 214,559 secondary buyers operating across 10,649 product categories, placing 7.58 million orders worth Rs 5,027.78 billion in the last completed fiscal year, with 2.30 million more already logged in the year underway at the August 2026 research pass.

The useful unit for a seller is not the headline count but the row underneath it - one contract order with its line items, delivered exactly as captured:

# one row per contract order - observed shape, August 2026 verification pass
contract_no       : GEMC-511687701075757
order_status      : Fullfillment in Progress   # portal spelling, shipped verbatim
organization_type : Central Government
ministry          : Ministry of Agriculture and Farmers Welfare
buying_mode       : Direct
total_value_inr   : 10692.000
product           : <line-item text>          hsn_code        : <six-digit code>
ordered_quantity  : 1                          unit_price_inr  : 10692.000

That row shape repeats across everything the state buys, which is why the electrical slice - transformers, switchgear, circuit breakers, cables - isolates deterministically on product text and hsn_code rather than on keyword guesswork. History reaches back to February-March 2018, deep enough to profile buyers, incumbent suppliers and repeat ordering by ministry before a relevant bid even appears. A companion statistics layer rolls the same activity up per financial year, so any annual claim you make can be audited down to the individual contract numbers that produced it.

A watchlist is three cuts of data arriving on a schedule, not a day of scripting:

Steps 2 and 3 run on a standing feed; steps 1, 4, 5 and 6 are quarterly pulls. The only thing you maintain is the question.

Ministry of Heavy Industries (India) - Heavy Electrical Vertical is the policy layer, and it answers the question every bid team should settle first: can this equipment be sold into India at all? Its Electrical Equipment Quality Control Order repository runs from the 2020 core instrument through the Second Amendment of May 2024 to deferment and extension notifications issued as recently as November 2025. If a tender specifies equipment a competitor cannot certify against, that document trail is the moat.

Two records divide the American work cleanly. SAM.gov Entity Registration & Contract Awards is the demand ledger: the General Services Administration's authoritative registry of entity registrations, contract opportunities and award notices, where electrical purchases isolate along Product Service Code group 61 (Electric Wire, Power Distribution Equipment) and electrical NAICS codes such as 221121 and 335314. Award notices carry the obligated amount, award date, winning vendor's legal name and Unique Entity Identifier, set-aside designations and place of performance - frequently with a description paragraph naming the exact equipment; medium-voltage switchgear replacements appear at precisely that depth. It scores 8 out of 10 in Datadory's catalog rubric, and it reads two directions at once: forward as a pipeline of requirements still being shaped, backward as a ledger of who won what.

data.gov - US Federal Transformer Datasets is the regulatory map rather than the deal feed: a query-driven slice of the whole-of-government catalog reporting 552,271 records at the August 2026 pass, resolving transformer searches into EIA-860 generator and plant filings, FERC records, DOE distribution-transformer efficiency rulemaking material, power-administration asset inventories and state utility sets. Use it to understand the installed base and the efficiency perimeter every federal purchase must satisfy - then let SAM.gov tell you who actually bought.

The UK publishes the context around contracts more readily than a unified award ledger, and two records cover it from opposite ends. data.gov.uk - Electrical Equipment Datasets fronts the National Data Library: roughly 1,746 catalog records for the electrical-equipment query across 88 result pages, dominated by council WEEE collections and ICT inventories but carrying four veins that reward sector work - DESNZ historical electricity series, consumption figures at LSOA and MSOA level, NHS installed-base counts and EV charging locations. Each hit normalizes to one five-field row with its publisher attached.

To judge whether a UK contract will be fed domestically or by imports, pair it with UK ONS PRODCOM: annual manufacturers' sales across ~3,805 product codes back to 2008, published as accredited official statistics, with SIC division 27 isolating transformers, motors, generators and switchgear as separately coded products. Every row carries an explicit revision status - provisional, intermediate or final - so a market-sizing claim survives being re-checked. The diagnostic pattern: a falling domestic sales line against steady public-sector demand is what predicts imported supply winning UK tenders.

Because the hard part was never knowing these records exist - it is keeping them coherent. Three governments publish in three schemas, on three calendars, with three definitions of 'an award': GeM keys on GEMC contract numbers and ships status values including its own spelling of 'Fullfillment'; SAM.gov isolates electrical purchases only if someone maintains the PSC and NAICS code lists correctly; PRODCOM revises its estimates and expects you to notice. Stitched by hand, that is several ways for a quarterly total to quietly split.