GreenSpec — Green Building Product Directory data

It is the UK's editorially independent shortlist of genuinely greener building products, delivered as structured rows. GreenSpec has run since 2003, edited by practising architects and specifiers and independent of companies and trade bodies - which is why its endorsements carry weight with UK designers. Products enter the directory only after individual assessment, and each one lands inside a Uniclass-style tree of eight levels, L1 Ground treatment and retention through L8 Fixtures & fittings, spanning roughly 100 leaf categories: insulation by application, paints and varnishes, cement and concrete, bricks and blocks, windows and doors, membranes, rainwater harvesting, heat pumps.

The part worth automating is the per-product Environmental metrics block. Every product page states company credentials, material composition, life expectancy, EPD to ISO 14025 availability, recycled content, recyclability, third-party endorsement, environmental labelling and country of manufacture - plus a manufacturer contact block and a technical data-sheet link. Read off screens, those nine metrics die in browser tabs. Resolved into rows keyed by product and category path, they become a filterable corpus: which interior paints hold an EU Ecolabel, declare VOC-free formulations and ship from a named manufacturer is a query, not an afternoon.

Three records from the internal wall and ceiling paints category, flat exactly as they arrive in a delivery:

# Row 1 — a fully documented record: every environmental metric present
product_name          : earthBorn Claypaint
category_path         : L6 Construction fabric products / Paints and
                        varnishes / Internal wall and ceiling: paints
description           : Solvent-free wall and ceiling paint for internal use;
                        water-borne, VOC free, low odour, highly breathable
company_credentials   : European Union Ecolabel
materials             : Water, various clays, chalk, kaolin, vinegar ester,
                        methylcellulose, titanium dioxide, pigments
life_expectancy       : unknown
epd_to_iso_14025      : none
recycled_content      : 0
recycleable           : n/a
third_party_endorsement: none
environmental_labelling: none
country_of_manufacture : Germany
manufacturer          : earthBorn Paints
manufacturer_website  : www.earthbornpaints.co.uk/
manufacturer_address  : Brush Mate, Frodsham Business Centre, Bridge Lane,
                        Frodsham, Cheshire, WA6 7FZ

# Row 2 — a cross-listed product: name and hierarchy only
product_name          : Volvox Casein wall paint
category_path         : L6 Construction fabric products / Paints and
                        varnishes / Internal wall and ceiling: paints

# Row 3 — the endorsement badge, flagged per record
product_name          : Ty-Mawr Limewash
category_path         : L6 Construction fabric products / Paints and
                        varnishes / Internal wall and ceiling: paints
pass_endorsement_flag : true

Two things to read out of those rows. First, sparsity is preserved rather than papered over: where the editors record no life expectancy or no EPD, the row says unknown or none - honest nulls you can count, not blanks that quietly become zeros in someone's spreadsheet. Second, records differ in depth by design. A cross-listed product can appear as little more than name and hierarchy, while a flagship record like the claypaint above carries the full metrics block, materials declaration and postal address. Both shapes are data; treating them as one uniform table would be the actual error.

Eighteen documented fields per record, definitions verified during research, doing four jobs.

Identity and placement: product_name plus category_path, which locates every record inside the eight-level, ~100-leaf-category hierarchy - the column that turns directory browsing into a group-by.

Environmental metrics: the block that justifies the whole exercise - company_credentials, materials, life_expectancy, epd_to_iso_14025, recycled_content, recycleable, third_party_endorsement and environmental_labelling. Nine editor-maintained attributes per product, consistently labelled across the directory so a recycled-content comparison across paint, insulation and blockwork is a pivot rather than a re-reading exercise.

Manufacturer resolution: manufacturer, website, email and postal address - four columns that convert a catalogue entry into a contactable supplier list for sourcing, partnership mapping or supply-chain work.

Documentation signals: downloads (the technical data-sheet link) and the boolean pass_endorsement_flag marking products carrying the PASS badge. Where a record extends beyond these eighteen - longer editorial copy, extra listing detail - the extension is confirmed against live records when your sample is cut rather than promised blind.

Beyond the eighteen-column core, the surrounding GreenSpec estate extends the same product universe sideways; those extensions get mapped to your use case at sampling:

• Guidance-article text - the directory publishes substantial construction-guidance pieces alongside the product listings; their body text folds out as an additional field when your use case needs editorial context beside the specs.
• Category-tree reference - the full L1-L8 taxonomy with leaf-category membership counts, useful as a dimension table beside the product rows.
• Cross-listing resolution - products appearing under multiple leaf categories arrive deduplicated to one canonical record with a category-membership array, on request, instead of one row per listing.

Geography: a United Kingdom market focus - these are materials specified on British sites, and the surrounding guidance reads UK regulation. Country of manufacture is recorded per product, so a German-made paint or a Welsh limewash stays identifiable; supply-chain questions survive the UK framing.

Temporal: a continuously maintained editorial directory running since 2003, with category and product pages marked monthly in the site's own change schedule. One structural honesty note: there is no archive of withdrawn products - when a product leaves the directory, its history leaves with it. Longitudinal product presence exists only where someone captured it repeatedly, which is the case for starting a cadence before the question arrives.

Granularity: one record per endorsed product, sitting in a two-level taxonomy of eight top-level categories and roughly 100 leaf categories holding a handful of products each. No rollups, no category averages - every downstream cut aggregates from the same atomic unit.

Set against Datadory's wider catalog - 1,744 datasets across 159 viable industries, average quality score 7.81 - this slice scores 7/10 with field definitions verified during research.

API, files, or your warehouse. Daily, weekly, or hourly.

Pick the channel your team already works in: REST endpoints for lookups against a category or product slice, flat files sized for overnight loads, or a direct pipe into Snowflake, BigQuery or Redshift. Cadence is yours to set - monthly matches the underlying editorial rhythm, weekly builds a withdrawal history the directory itself does not keep.

Every delivery ships with the full eighteen-field dictionary, sample rows for validation, and a schema that holds steady between refreshes. Name the categories - insulation, paints, windows, whatever the project needs - and the sample comes back shaped to them.

An endorsed-product corpus earns its keep in six jobs:

• Sustainable-specification screening - architects and specifiers shortlist by certification and label columns first, then read editorial copy only for survivors. Nine environmental metrics per product make the funnel mechanical.
• EPD coverage analysis - the epd_to_iso_14025 column measures how much of a product class carries ISO 14025 declarations, which is exactly the question embodied-carbon compliance teams ask before a project starts.
• Supplier discovery - manufacturer name, email, website and address turn category searches into contactable lists for procurement and partnership development.
• Materials composition research - the materials declarations join cleanly to ingredient- and substance-level datasets such as Declare, connecting what a product is made of to what each constituent does.
• Greenwash detection - where a product's marketing claims an ecolabel, the record shows whether the directory's editors credited it; the gap between the two is the story.
• Market mapping - counting endorsed products per leaf category quantifies where sustainable options are thick on the ground and where specification pressure has nothing to land on.

Market Researchers & Consultants get a defensible denominator for UK sustainable-construction sizing: how many endorsed products exist, in which categories, holding which certifications. Competitive Intelligence & Product Teams at manufacturers see the bar their own products must clear to earn endorsement - competitor credentials, labels and EPD status, row by row. Data Scientists & ML Engineers get typed columns with verified definitions and honest null markers, so ingestion is configuration rather than cleaning archaeology. Journalists, Academics & Students cite a source edited independently of trade bodies since 2003, which keeps a footnote standing under review.

How each persona wires the slice into daily work is expanded on the market researchers, competitive intel product teams and data scientists pages.

Inside this industry slice, three datasets answer three different questions about product sustainability. Declare goes deeper than the product row - roughly 2,036 label records with substance-level ingredients, CAS numbers, percentage ranges and Red List status - but covers only manufacturers who chose to disclose. Green Seal Certified Products Directory reads certification from the certifier's side, product by product, across a US-focused standards portfolio.

GreenSpec is the editorial-endorsement view: an independent UK verdict on each product, with a consistent nine-metric environmental block behind the verdict. The practical stack pairs all three - Declare for what is in the tin, Green Seal for what a US certifier approved, GreenSpec for what a UK specifier would actually shortlist.

Where this record sits in the vertical's ranking is on the best building products datasets page; the pooled industry view lives at the building products data hub.

Three things, stated up front.

First, this is a curated shortlist, not a trade counter. Roughly 238 products passed the editors' assessment; absence from the directory means 'not assessed or not endorsed', never 'unsustainable'. Treat it as a positive filter, and pair it with a broad catalog such as Sweets when you need the universe the filter selects from.

Second, withdrawn products leave no trace in the live directory. A single snapshot answers today's specification question; a cadence is what builds the longitudinal record the source itself does not publish.

Third, field definitions were established against live records during the August 2026 research pass; anything beyond the core eighteen is confirmed when we cut your sample, which is also where column naming locks down for your pipeline. Name the categories or certifications you care about and the sample comes back shaped to them.