Real Estate Construction Supply Trace

This dataset provides comprehensive tracking of construction material deliveries, supplier performance, and traceability across project phases and sites. It enables supply chain analysts and operations managers to optimize procurement, identify bottlenecks, and improve efficiency in real estate construction projects. Key features include detailed delivery events, material traceability, and site-level address data for actionable insights.

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

Supply chain bottleneck identification and resolution

Sample rows

preview · 8 of 125 rows · all 25 columns
project_idstringphase_namestringquantity_deliveredfloatphase_idstringproject_namestringmaterial_idstringmaterial_namestringmaterial_typestringsupplier_idstringsupplier_namestringdelivery_idstringdelivery_datedatedelivery_timestringdelivery_statusstringunit_of_measurestringexpected_delivery_datedatesite_address_streetstringsite_address_citystringsite_address_statestringsite_address_postal_codestringsite_address_countrystringreceived_bystringtraceability_referencestringprocurement_order_idstringdelivery_notesstring
P-001Foundation250.5PH-FA-01Liberty Tower ConstructionM-1001Ready-Mix ConcretestructuralS-1001CementWorks USAD-000012024-03-0508:30on-timecubic meters2024-03-05101 Liberty AveHoustonTX77002USAJorge RamirezCONC-20240305-B01PO-USA-0001No issues noted on arrival.
P-002Framing120PH-FR-01Greenfield Mall ExpansionM-1002Steel BeamsstructuralS-1002American Steel GroupD-000022024-04-1511:00delayedtons2024-04-13200 Market StDallasTX75201USASamantha LeeSTL-20240415-D05PO-USA-0002Delivery delayed due to supplier truck breakdown.
P-003Electrical75PH-EL-01Harbor ApartmentsM-1003Copper Wire SpoolselectricalS-1003ElectraSource LtdD-000032024-05-0209:15on-timepieces2024-05-02350 Ocean View BlvdMiamiFL33132USAAlison TrentCUW-20240502-W14PO-USA-0003Copper wire spools checked and accepted.
P-004Interior350PH-IT-01Central Park Office ComplexM-1004Drywall SheetsfinishingS-1004BuildFinish IncD-000042024-06-1007:45on-timepieces2024-06-101200 Central Park SNew YorkNY10019USAMarcus AllenDRYW-20240610-B03PO-USA-0004All sheets received in good condition.
P-005Foundation65.5PH-FA-01Sunset Plaza RenovationM-1005Reinforcing Steel BarsstructuralS-1002American Steel GroupD-000052024-07-0113:20damagedtons2024-06-3015 Sunset BlvdLos AngelesCA90028USAGloria ChangSTBR-20240701-D02PO-USA-0005Some steel bars bent during transit.
P-006Plumbing180PH-PL-01Riverfront TowersM-1006PVC PipesplumbingS-1005FlowMaster SupplyD-000062024-09-1810:10on-timepieces2024-09-18400 Riverfront RdMemphisTN38103USARaymond FosterPVC-20240918-P08PO-USA-0006Delivery completed as scheduled.
P-007Electrical48PH-EL-01Pacific Heights ResidencesM-1007LED Lighting FixtureselectricalS-1006BrightLite CorpD-000072024-11-2216:05partialpieces2024-11-2155 Pacific AveSan FranciscoCA94111USANatalie WrightLED-20241122-F06PO-USA-0007Partial delivery, 12 fixtures backordered.
P-008Framing210PH-FR-01Broadway Arts CenterM-1008Lumber BoardsstructuralS-1007TimberPro DistributionD-000082024-08-2707:05on-timepieces2024-08-27900 BroadwayNashvilleTN37203USAKevin MaloneLMB-20240827-B07PO-USA-0008Boards stacked and inspected.

What the 125 rows show

from the 125-row sample

Foundation (phase name) stands out: mean quantity_delivered is 256.8, against 151.2 for the rest.

  • 130.0median quantity_delivered
  • 4material types
  • 5delivery statuses
  • 8site address countries
  • 13unit of measures
Mean quantity_delivered by phase_name125 rows
0200400180.6Fram…27 ro…87.9Elec…25 ro…256.8Foun…20 ro…181.8Fini…20 ro…113.3Plum…17 ro…210.0Inte…13 ro…171.8Exca…3 rows
quantity_delivered125 rows, in bands of 100
0255041412115520300600quantity_delivered →

Median 130.0, from 0.0 to 540.8.

phase_id125 rows · top 10 of 38 values
  1. PH-EL-0311
  2. PH-FA-0110
  3. PH-FR-018
  4. PH-PL-018
  5. PH-EL-017
  6. PH-FA-027
  7. PH-FI-047
  8. PH-FR-076
  9. PH-EL-025
  10. PH-FR-025
25 columns by typefrom the column list below
  • string 22
  • float 1
  • date 2

Columns

25 columns in three groups
blueprint · 25 columns
columntypedescriptionexample
Text 22 columns
project_idstringUnique identifier for the construction projectP-001
project_namestringName of the construction projectHarbor Apartments
phase_idstringUnique identifier for the construction phasePH-FA-01
phase_namestringName of the construction phase (e.g., foundation, framing, finishing)7 namesFoundation
material_idstringUnique identifier for the materialM-1001
material_namestringName or description of the material (e.g., concrete, steel beams)Ready-Mix Concrete
material_typestringType/category of the material (e.g., structural, finishing, electrical)4 types · optionalstructural
supplier_idstringUnique identifier for the supplierS-1001
supplier_namestringName of the supplier providing the materialCementWorks USA
delivery_idstringUnique identifier for the delivery eventuniqueD-00001
delivery_timestringTime of day when the material was delivered (HH:MM format)optional08:30
delivery_statusstringStatus of the delivery (e.g., on-time, delayed, damaged)on-time · delayed · damaged · partial · cancelledon-time
unit_of_measurestringUnit of measure for the delivered quantity (e.g., tons, cubic meters, pieces)cubic meters
site_address_streetstringStreet address of the construction site101 Liberty Ave
site_address_citystringCity of the construction siteHouston
site_address_statestringState or province of the construction siteTX
site_address_postal_codestringPostal code of the construction site77002
site_address_countrystringCountry of the construction site8 countriesUSA
received_bystringName or identifier of the person who received the delivery at the siteoptionalJorge Ramirez
delivery_notesstringAdditional notes or comments about the delivery eventoptionalNo issues with delivery.
traceability_referencestringReference code or batch number for traceability of the materialoptionalCONC-20240305-B01
procurement_order_idstringIdentifier for the procurement order associated with the deliveryoptionalPO-USA-0001
Numbers 1 column
quantity_deliveredfloatQuantity of material delivered (in specified units)0 or more250.5
Dates and times 2 columns
delivery_datedateDate when the material was delivered2024-03-05
expected_delivery_datedateScheduled date for delivery according to procurement planoptional2024-03-05

Use it for

  • median quantit…130.0125 rowsmean quantity deliver…180.6Fram…87.9Elec…256.8Foun…181.8Fini…

    A real estate dashboard

    Quantity_delivered by phase_name and a breakdown of phase_id. Excel, Power BI or Tableau.

  • Why do the 20 Foundation rows have a mean quantity_delivered of 256.8?

    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 projects with project_name, phase_id and phase_name to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 25 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 dataset125 rows25 columns
Yours1,000 rows25 columnssite_address_street: UK only

blueprint · real-estate-construction-supply-trace

Behind this dataset

Same schema. As many rows as you need.

These 125 rows came out of a blueprint — 25 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.
  • Include supplier, origin, material type, and quantity.
  • Log date/time of delivery and receiving site.
  • Include traceability code and quality status for each material.
  • Flag shipments delayed over 24 hours for review.
Rows
Open the blueprint in Data Factory

1 credit per row. Preview 20 rows free. Buy rows for the full run.

Exports
CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence
yours to use, including commercially
API slug
real-estate-construction-supply-trace

What should your data show?

Preview 20 rows free
No signup. No card.