Window U-Factor & SHGC ratings database, delivered as rows

It reads like a lookup and resolves into a performance ledger - the certified numbers behind the energy label on virtually every window, door and skylight sold in North America.

Datadory delivers that ledger as the [NFRC Certified Fenestration Product Database]("/datasets/building-products/nfrc-certified-fenestration-product-database"), the certification program run by the National Fenestration Rating Council: 741 manufacturers across 14 product types - awning, casement, picture, sliding, single-hung, double-hung and specialty windows, garage doors, glazed wall systems, sidelites, transoms, skylights, sliding glass doors, swinging exterior doors and sloped glazing systems.

The unit of record surprises people. Not the model, not even the product line - one row per certified glazing variant. A single casement line can carry ten rated rows, one per glass package, which is why two quotes naming the same window can resolve to two different sets of certified physics. Multiply per-line variant counts across 741 manufacturers and the implied population runs to hundreds of thousands of individually rated rows: competitor catalogs document thousands of products, this documents every certified configuration with five comparable numbers apiece.

Within Datadory's catalog of 1,744 datasets across 159 viable industries the record scores 7/10 for quality, and it anchors the performance layer of the 24-record building-products slice. Catalogs say who sells a window, evaluation reports say whether code accepts it, this says precisely how the assembled unit performs.

A high-performance window routinely wears four or five marks at once, and each mark answers a different question. Treating them as interchangeable is how the wrong evidence lands in a specification. Seven cataloged records divide the work:

• [NFRC Certified Fenestration Product Database]("/datasets/building-products/nfrc-certified-fenestration-product-database") - how the assembled unit performs thermally and optically, as certified. One row per glazing variant across the 741-manufacturer roster.
• [Sweets Building Product Catalog and Specification Data]("/datasets/building-products/sweets-building-product-catalog-and-specification-data") - who makes it and how it is specified: tens of thousands of listings organized across all 35 CSI MasterFormat divisions, division 03 concrete alone exceeding 1,000 items, each carrying three-part specs, CAD details and BIM objects.
• [ICC-ES Evaluation Reports Directory]("/datasets/building-products/icc-es-evaluation-reports-directory-esrs-for-building-produc") - whether a building department accepts it: roughly 2,461 directory rows spanning Evaluation Service Reports, Listings, PMG plumbing/mechanical listings and Environmental Product Declarations, with legacy evaluations retained to 1990s-era reports such as BOCA-93-36.02.
• [Declare]("/datasets/building-products/declare-building-product-ingredient-disclosure-database") - what substances are in it: about 2,036 ingredient-disclosure labels with substance-level rows down to CAS number and weight range beneath each product.
• [GREENGUARD Certified Product Database]("/datasets/building-products/greenguard-certified-product-database") - what it emits indoors, screened against more than 15,000 VOCs inside UL SPOT's 180,000+ sustainable-product records.
• [Green Seal Certified Products Directory]("/datasets/building-products/green-seal-certified-products-directory") - whether it meets sustainability leadership standards such as GS-11, held by roughly 360 certified companies.
• [Lowe's Building Materials Product Catalog]("/datasets/building-products/lowe-s-building-materials-product-catalog") - whether it reaches a shelf, at what price and stock position: hundreds of thousands of SKUs with store-level price and inventory in 27 fields per row.

One distinction matters more than the rest: none of the neighboring registries publishes a U-factor or an SHGC value. A window can hold an ingredient label, an emissions certificate and a code evaluation report and still be unrated for energy performance. Only the certified ratings table settles that question - which is why energy-code conversations start here rather than in any of the others, and why the strongest workflows chain them: candidates in Sweets, code standing in ICC-ES, ranking on certified U-factor here, indoor-air screening last through Declare and GREENGUARD.

Three real variants from one casement line, captured during the August 2026 review - Acadia Windows and Doors' "700 Casement", CPD number AWD-M-21:

CPD #                 U-factor  SHGC   VT    CR   Glazing make-up
AWD-M-21-00081-00001  0.27      0.27   0.49  64   Vinyl/Vinyl, Fill 1: ARG(95/5), LowE, CL, No Grid
AWD-M-21-00082-00001  0.28      0.25   0.45  64   Vinyl/Vinyl, Fill 1: ARG(95/5), LowE, CL, Grid
AWD-M-21-00085-00001  0.28      0.27   0.49  62   (same line, thicker glass pack)

Every row also carries the manufacturer's own product code spelling the recipe out in order: 70/36 / arg / clr (DS/DS) 3/4" IG reads as glass thicknesses, argon fill, coating position and insulated-unit width. That code is the join key between a marketing SKU and certified physics, and it arrives intact on every delivered row.

Thirteen fields, verified against live rows during the August 2026 review and delivered with definitions and examples attached. An identity block names the configuration: the CPD number is anatomical - AWD-M-21-00081-00001 decomposes into maker, product type, line and variant - while series name locates the family and operator type separates fixed from operable sashes. Five measured fields carry the physics. Three descriptive fields explain it: frame type as a filterable enum, cavity gas fill, and a free-text glazing make-up encoding finish, coating placement, grids, dividers and spacers.

Two sparser fields - air leakage, capped at 0.3 in certification and thin on detail views, and the optional ventilation rating for standard screens - ship under additional-fields-on-request. Ask for them with your sample and they arrive joined rather than discovered missing mid-analysis.

Five workflows account for most of the demand, each mapped to named records rather than generic categories:

1. Verify submittals against the energy model. Architects and spec writers confirm a specified window's certified U-factor and SHGC meet project assumptions before submittal - matched at variant grain, using the same numbers the code official sees. The certified row outranks the brochure figure every time.
2. Benchmark a category end to end. Competitive-intel and product teams ask who else holds a 0.25-U casement and with what gas fill and frame economics, then track how certification breadth per manufacturer shifts as energy codes tighten across states and provinces.
3. Size addressable segments. Market researchers split the 741-manufacturer roster by frame material, gas fill and performance band to put numbers on categories inside windows, skylights and glazed wall systems.
4. Feed simulation with real envelopes. Data scientists and energy modelers build distribution curves over certified performance - how much U-factor separates builder-grade double-hungs from passive-house casements - and push realistic parameters into whole-building simulation.
5. Read certification volume as a demand signal. Investors tie per-manufacturer certification activity to code-tightening cycles, joining it to the housing and permits series described below.

Common thread: everyone needs the certified number itself, not a claim standing next to it.

Architects and spec writers arrive from the drawing set, checking candidate glass packages against an energy-model assumption before anything goes out for bid. Their screens live on the market researchers and spec workflow pages.

Competitive-intel and product teams arrive from the rival's cut sheet, rebuilding its certified performance ladder variant by variant; their scoring sits on the competitive intel product teams page.

Data scientists and energy modelers arrive from simulation, needing distributions rather than anecdotes; the fuller envelope-modeling workflow is scored on the data scientists page.

Investors and analysts arrive from the cycle, treating certification breadth per manufacturer as a leading read on code-driven replacement demand - see investors and quants use cases.

Different doors, same room: the certified variant row is the object everyone ends up holding.

Ratings say what can be specified; demand series say how many openings exist to specify into. Four companions cover the volume side, delivered through the same building-products manifest:

• [Census Economic Time Series Database]("/datasets/building-products/census-economic-time-series-database-mrts-m3-housing-constru") - new residential construction running from January 1959, building-materials-dealer retail from January 1992 and construction spending from 1993: 21 programs and six decades of American housing cycles in one spine.
• [Eurostat Dissemination API]("/datasets/building-products/eurostat-dissemination-api-construction-production-building-") - monthly construction production indices back to 1990 plus building permits by dwelling type across EU member states, EFTA and candidate countries. Permits lead installations.
• [Eurostat PRODCOM]("/datasets/building-products/eurostat-prodcom-production-statistics-for-building-product-") - annual sold production back to 1995 across roughly 4,000 eight-digit product headings per country-year, doors and windows explicitly among them, published for the prior reference year. Worth being precise about what it is not: PRODCOM counts windows manufactured and rates none of them.
• [NAHB Housing Economics reports]("/datasets/building-products/nahb-housing-economics-and-building-material-price-reports") - the monthly 0-to-100 builder sentiment index plus near-monthly reads on BLS producer prices for materials; July 2026 had residential materials excluding energy up 0.4 percent on the month and 5 percent year over year.

That last pairing exposes the market's one structural asymmetry: Europe offers production and permit volumes but no independently certified ratings counterpart in the slice, so mixed-market projects run asymmetrically - third-party certified ratings for North America, manufacturer declarations for Europe. And the sequencing holds everywhere: a window line launched into a falling permit series competes for fewer openings, however good its certified numbers look next to a rival's.

Because the ratings themselves are the easy part - everything around them is the work. Rating bounds differ by product category, so naive joins rank garage doors (0.00-2.00 U-factor) against casements (0.20-1.20); two of thirteen fields hide behind detail views; identifiers follow an anatomical scheme that has to survive the trip to your warehouse; and a certificate can lapse while the labeled unit is still glazed into a wall, quietly breaking any pipeline that assumes the live table is complete history.

Datadory handles all of that upstream of the rows. The variant grain survives delivery intact rather than collapsing to model level. Category bounds travel beside the values so cross-type rankings normalize themselves. Current-certification tables join to the historical label-certificate record set, so a five-year-old label still resolves to its original numbers, with commercial-project certificates tracked as their own record set for US and Canadian projects. Air leakage and ventilation ratings arrive pre-joined when asked for.

Files, feeds, or straight into your warehouse - daily, weekly, or hourly, your call. Name your product types, manufacturers and destination and the sample ships first, already cut to them; the production feed follows the same shape, so anything prototyped on the sample survives delivery unchanged. Request a sample scoped to your catalog.

This page covered the certified variant layer, the registries around it and the demand series that give the numbers a market to land in. Continue with:

1. NFRC Certified Fenestration Product Database - the dataset product page behind this article, with the full field dictionary, sample rows and coverage chips.
2. ICC-ES evaluation report lookup - the code-compliance step that pairs with certified ratings in nearly every submittal workflow.
3. Housing starts historical data in Excel - the demand spine the certification story rides on, reaching back to January 1959.
4. Building products data guide - the pillar mapping all 24 cataloged building-products records.

For the structured index, the building products data hub lists every record with field dictionary and coverage statement, and the best building products datasets ranking shows what to automate first. When brochure claims need to become certified rows, request a sample.