Green Building Material Supply Tracker

This dataset provides detailed tracking of sustainable building material shipments across construction projects, including supplier, material, ESG certification, logistics, and carbon emissions data. It enables real estate and procurement managers to monitor supply chain efficiency, benchmark ESG compliance, and identify bottlenecks in green material sourcing for improved sustainability reporting and operational optimization.

  • last updated 17 Dec 2025
  • by GoMask
The brief that made it

Benchmarking supply chain efficiency and identifying bottlenecks in green material sourcing

Sample rows

preview · 8 of 150 rows · all 34 columns
shipment_idstringtransport_modestringdistance_kmfloatis_sustainablebooleanproject_address_citystringproject_idstringproject_namestringproject_managerstringproject_address_streetstringproject_address_statestringproject_address_postal_codestringproject_address_countrystringmaterial_idstringmaterial_namestringmaterial_categorystringesg_certificationstringsupplier_idstringsupplier_namestringsupplier_address_streetstringsupplier_address_citystringsupplier_address_statestringsupplier_address_postal_codestringsupplier_address_countrystringshipment_datedateexpected_delivery_datedateactual_delivery_datedateshipment_statusstringquantityfloatunit_of_measurestringestimated_co2e_kgfloatesg_compliance_flagbooleanbottleneck_flagbooleanbottleneck_reasonstringnotesstring
SHIP-00001truck33.5falseDenverPRJ-1001Sunset LoftsJessica Morales1421 Oak LaneCO80203USAMAT-0011Reinforced ConcreteconcreteblankSUP-102Rocky Mountain Supply Co.3015 Quarry BlvdAuroraCO80014USA2024-03-042024-03-082024-03-08delivered35.2tons207.9falsefalseblankDelivered as scheduled, no issues reported.
SHIP-00002truck72.4falseSan JosePRJ-1002Green Valley Tech HubSamuel Chen1842 Innovation DrCA95125USAMAT-0023Recycled Steel BeamssteelblankSUP-104Pacific Steel LLC4398 Foundry WayFremontCA94538USA2024-03-082024-03-122024-03-12delivered20.5tons449.68falsefalseblankSteel shipment received in good condition.
SHIP-00003rail326.9trueSeattlePRJ-1003Cascade Heights CondosLinda Foster5907 Summit AveWA98105USAMAT-0034Timber Panels FSCtimberFSCSUP-106Evergreen Lumber1220 Pine StTacomaWA98402USA2024-03-102024-03-152024-03-17delayed700pieces367.76truetrueRail strike caused two-day delay.Delayed due to labor action; notified project team.
SHIP-00004ship3120.5trueSan FranciscoPRJ-1004Bayview Business CenterMichael Kim437 Bay StCA94107USAMAT-0042Facade Glass PanelsfacadeLEEDSUP-108Crystal Facades Inc.892 Market AveOaklandCA94607USA2024-03-122024-03-252024-03-28delayed170pieces1248.2truetrueShipping container backlog at port.Delay at Oakland port; expedited unloading requested.
SHIP-00005truck354.7trueDallasPRJ-1005Metro ApartmentsDavid Patel9814 6th StTX75204USAMAT-0053Insulation Foam BoardsinsulationLEEDSUP-110Sunrise Building Materials4021 Commerce RdHoustonTX77002USA2024-03-142024-03-172024-03-17delivered600pieces638.46truefalseblankDelivered as planned; sustainability documentation verified.
SHIP-00006rail1985.2trueSeattlePRJ-1006Rainier PlazaOlivia Thompson415 47th Ave EWA98116USAMAT-0064Electrical Wiring SetselectricalCradle to CradleSUP-112Northwest Electric7011 Wire StRedmondWA98052USA2024-03-182024-03-232024-03-24delayed110meters413.53truetrueCustoms inspection at border.Delay due to customs check; project notified.
SHIP-00007truck83.6falseAustinPRJ-1007TechLink OfficesAva Lee9230 Northgate BlvdTX78758USAMAT-0071Galvanized Steel RodssteelblankSUP-113Lone Star Metals222 Foundry DrEl PasoTX79901USA2024-03-202024-03-252024-03-25delivered42.8tons502.67falsefalseblankSteel rods delivered on time.
SHIP-00008rail485.4truePortlandPRJ-1008Cedar Ridge TownhomesEthan Walker771 Cedar Crest DrOR97201USAMAT-0085Sustainable Timber BoardstimberFSCSUP-115Pine Valley Lumber Co.3578 Timber AveEugeneOR97401USA2024-03-212024-03-262024-03-26delivered870pieces545.17truefalseblankHigh-volume timber shipment; FSC certificate on file.

What the 150 rows show

from the 150-row sample

Ship (transport mode) stands out: mean distance_km is 2,628, against 248.9 for the rest.

  • 55%is_sustainable = true
  • 103.2median distance_km
  • 3esg certifications
  • 4unit of measures
  • 5shipment statuses
  • 6material categories
Mean distance_km by transport_mode143 rows
02,0004,00090.6truck75 rows665.5rail32 rows2,628ship28 rows66.2air8 rows
distance_km150 rows, in bands of 500
06012011323107671102,5004,500distance_km →

Median 103.2, from 0.0 to 4,212.

project_address_city142 rows with a value · 8 left blank
  1. Seattle17
  2. San Francisco16
  3. Portland15
  4. Denver13
  5. San Jose11
  6. Austin10
  7. San Diego9
  8. Dallas7
  9. Sacramento7
  10. New York6
34 columns by typefrom the column list below
  • string 25
  • float 3
  • date 3
  • boolean 3

Columns

34 columns in four groups
blueprint · 34 columns
columntypedescriptionexample
Text 25 columns
shipment_idstringUnique identifier for each material shipmentuniqueSHIP-00001
project_idstringUnique identifier for the construction project receiving the shipmentPRJ-1001
project_namestringName of the construction projectSunset Lofts
project_managerstringName of the project manager overseeing the construction projectoptionalJessica Morales
project_address_streetstringStreet address of the construction project site1421 Oak Lane
project_address_citystringCity of the construction project siteDenver
project_address_statestringState or province of the construction project site9 statesCO
project_address_postal_codestringPostal or ZIP code of the construction project site80203
project_address_countrystringCountry of the construction project siteUSA
material_idstringUnique identifier for the building materialMAT-0011
material_namestringName or description of the building materialReinforced Concrete
material_categorystringCategory of the building material (e.g., insulation, concrete, timber, steel)6 categoriesconcrete
esg_certificationstringName of the ESG or green certification (e.g., LEED, FSC, Cradle to Cradle)3 certifications · optionalFSC
supplier_idstringUnique identifier for the material supplierSUP-102
supplier_namestringName of the supplier providing the materialPacific Steel LLC
supplier_address_streetstringStreet address of the supplieroptional3015 Quarry Blvd
supplier_address_citystringCity of the supplieroptionalAurora
supplier_address_statestringState or province of the supplier8 states · optionalCO
supplier_address_postal_codestringPostal or ZIP code of the supplieroptional80014
supplier_address_countrystringCountry of the supplieroptionalUSA
shipment_statusstringCurrent status of the shipmentpending · in_transit · delivered · delayed · cancelleddelivered
unit_of_measurestringUnit of measure for the material quantity (e.g., tons, cubic meters, pieces)4 measurestons
transport_modestringMode of transport used for the shipment (e.g., truck, rail, ship, air)4 modestruck
bottleneck_reasonstringDescription of the reason for the bottleneck, if anyoptionalRail strike caused two-da…
notesstringAdditional notes or comments about the shipmentoptionalDelivered as scheduled, n…
Numbers 3 columns
quantityfloatQuantity of material shipped (in specified units)0 or more35.2
distance_kmfloatDistance covered by the shipment in kilometers0 or more33.5
estimated_co2e_kgfloatEstimated CO2 equivalent emissions (in kilograms) for the shipment0 or more207.9
Dates and times 3 columns
shipment_datedateDate when the shipment was dispatched2024-03-04
expected_delivery_datedateExpected date of delivery to the project site2024-03-08
actual_delivery_datedateActual date when the shipment was deliveredoptional2024-03-08
True or false 3 columns
is_sustainablebooleanIndicates if the material is certified as sustainablefalse
esg_compliance_flagbooleanIndicates if the shipment meets ESG compliance requirementsfalse
bottleneck_flagbooleanIndicates if this shipment experienced a supply chain bottleneckfalse

Use it for

  • is sustainable55%83 of 150 rowsmean distance km by t…90.6truck665.5rail2.6kship66.2air

    A logistics dashboard

    The is_sustainable rate, distance_km by transport_mode and a breakdown of project_address_city. Excel, Power BI or Tableau.

  • Why do the 28 ship rows have a mean distance_km of 2,628?

    A root-cause class exercise

    Hand out the rows and one question. The answer is in the data, not in the brief.

  • A software demo

    Believable shipments with project_id, project_name and project_manager to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 34 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset150 rows34 columns
Yours1,000 rows34 columnsproject_address_street: UK only

blueprint · green-building-material-supply-tracker

Behind this dataset

Same schema. As many rows as you need.

These 150 rows came out of a blueprint — 34 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.

Rules it was built with
  • Each row represents a unique material shipment event.
  • Include supplier, material type, certification status, estimated carbon footprint.
  • Shipments flagged if delivery exceeds project deadlines.
  • Materials lacking recognized green certification must be highlighted.
  • Record source location and distance-to-site for footprint calculation.
  • Shipments with high carbon impact are automatically prioritized for review.
Rows
Open the blueprint in Data Factory

1 credit per row. New accounts start with 25 free credits.

Exports
CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence
yours to use, including commercially
API slug
green-building-material-supply-tracker

More in Logistics

Browse all
Also in LogisticsNonprofit Supply Chain Carbon TrackerSupply Chain Disruption EventsCold Chain Logistics Temperature LogsAll 1,954 datasets

What should your data show?

Preview 20 rows free
No signup. No card.