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.
Sample rows
preview · 8 of 125 rows · all 25 columns| project_idstring | phase_namestring | quantity_deliveredfloat | phase_idstring | project_namestring | material_idstring | material_namestring | material_typestring | supplier_idstring | supplier_namestring | delivery_idstring | delivery_datedate | delivery_timestring | delivery_statusstring | unit_of_measurestring | expected_delivery_datedate | site_address_streetstring | site_address_citystring | site_address_statestring | site_address_postal_codestring | site_address_countrystring | received_bystring | traceability_referencestring | procurement_order_idstring | delivery_notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| P-001 | Foundation | 250.5 | PH-FA-01 | Liberty Tower Construction | M-1001 | Ready-Mix Concrete | structural | S-1001 | CementWorks USA | D-00001 | 2024-03-05 | 08:30 | on-time | cubic meters | 2024-03-05 | 101 Liberty Ave | Houston | TX | 77002 | USA | Jorge Ramirez | CONC-20240305-B01 | PO-USA-0001 | No issues noted on arrival. |
| P-002 | Framing | 120 | PH-FR-01 | Greenfield Mall Expansion | M-1002 | Steel Beams | structural | S-1002 | American Steel Group | D-00002 | 2024-04-15 | 11:00 | delayed | tons | 2024-04-13 | 200 Market St | Dallas | TX | 75201 | USA | Samantha Lee | STL-20240415-D05 | PO-USA-0002 | Delivery delayed due to supplier truck breakdown. |
| P-003 | Electrical | 75 | PH-EL-01 | Harbor Apartments | M-1003 | Copper Wire Spools | electrical | S-1003 | ElectraSource Ltd | D-00003 | 2024-05-02 | 09:15 | on-time | pieces | 2024-05-02 | 350 Ocean View Blvd | Miami | FL | 33132 | USA | Alison Trent | CUW-20240502-W14 | PO-USA-0003 | Copper wire spools checked and accepted. |
| P-004 | Interior | 350 | PH-IT-01 | Central Park Office Complex | M-1004 | Drywall Sheets | finishing | S-1004 | BuildFinish Inc | D-00004 | 2024-06-10 | 07:45 | on-time | pieces | 2024-06-10 | 1200 Central Park S | New York | NY | 10019 | USA | Marcus Allen | DRYW-20240610-B03 | PO-USA-0004 | All sheets received in good condition. |
| P-005 | Foundation | 65.5 | PH-FA-01 | Sunset Plaza Renovation | M-1005 | Reinforcing Steel Bars | structural | S-1002 | American Steel Group | D-00005 | 2024-07-01 | 13:20 | damaged | tons | 2024-06-30 | 15 Sunset Blvd | Los Angeles | CA | 90028 | USA | Gloria Chang | STBR-20240701-D02 | PO-USA-0005 | Some steel bars bent during transit. |
| P-006 | Plumbing | 180 | PH-PL-01 | Riverfront Towers | M-1006 | PVC Pipes | plumbing | S-1005 | FlowMaster Supply | D-00006 | 2024-09-18 | 10:10 | on-time | pieces | 2024-09-18 | 400 Riverfront Rd | Memphis | TN | 38103 | USA | Raymond Foster | PVC-20240918-P08 | PO-USA-0006 | Delivery completed as scheduled. |
| P-007 | Electrical | 48 | PH-EL-01 | Pacific Heights Residences | M-1007 | LED Lighting Fixtures | electrical | S-1006 | BrightLite Corp | D-00007 | 2024-11-22 | 16:05 | partial | pieces | 2024-11-21 | 55 Pacific Ave | San Francisco | CA | 94111 | USA | Natalie Wright | LED-20241122-F06 | PO-USA-0007 | Partial delivery, 12 fixtures backordered. |
| P-008 | Framing | 210 | PH-FR-01 | Broadway Arts Center | M-1008 | Lumber Boards | structural | S-1007 | TimberPro Distribution | D-00008 | 2024-08-27 | 07:05 | on-time | pieces | 2024-08-27 | 900 Broadway | Nashville | TN | 37203 | USA | Kevin Malone | LMB-20240827-B07 | PO-USA-0008 | Boards stacked and inspected. |
| P-009 | Plumbing | 130 | PH-PL-01 | Lakeview Hospital | M-1009 | Copper Plumbing Fittings | plumbing | S-1003 | ElectraSource Ltd | D-00009 | 2024-10-08 | 15:30 | delayed | pieces | 2024-10-06 | 700 Lakeview Dr | Chicago | IL | 60601 | USA | Erika Hansen | CPF-20241008-F04 | PO-USA-0009 | Supplier delayed due to inventory shortage. |
| P-010 | Interior | 500 | PH-IT-01 | Willow Grove Estates | M-1010 | Ceramic Tiles | finishing | S-1008 | TileArt GmbH | D-00010 | 2024-12-03 | 14:10 | on-time | pieces | 2024-12-03 | 320 Willow Rd | Philadelphia | PA | 19103 | USA | Hector Alvarez | CRT-20241203-T01 | PO-USA-0010 | All tiles received and verified. |
| P-011 | Foundation | 180 | PH-FA-02 | Résidence La Seine | M-1011 | Concrete Blocks | structural | S-2001 | Béton France SARL | D-00011 | 2024-03-20 | 08:50 | delayed | pieces | 2024-03-18 | 22 Quai de la Rapée | Paris | IDF | 75012 | France | Luc Moreau | CBK-20240320-B03 | PO-FR-0011 | Delivery delayed due to customs inspection. |
| P-012 | Electrical | 32 | PH-EL-02 | Glasgow Innovation Hub | M-1012 | Circuit Breakers | electrical | S-2002 | UK Power Supplies | D-00012 | 2024-07-17 | 12:30 | damaged | pieces | 2024-07-16 | 44 Queen Street | Glasgow | SCT | G1 3DX | UK | Martha Doyle | CBR-20240717-E02 | PO-UK-0012 | Four circuit breakers arrived with broken casings. |
| P-013 | Framing | 140 | PH-FR-02 | Toronto Skyline Residences | M-1013 | Engineered Wood Beams | structural | S-2003 | WoodWorks Canada | D-00013 | 2024-05-09 | 09:45 | on-time | pieces | 2024-05-09 | 100 Front St E | Toronto | ON | M5A 1E1 | Canada | Paul Richardson | EWB-20240509-W01 | PO-CA-0013 | Beams received and stored. |
| P-014 | Interior | 80 | PH-IT-02 | Sydney Harbour Offices | M-1014 | Paint Buckets | finishing | S-2004 | Aussie Decor | D-00014 | 2024-08-04 | 07:30 | on-time | pieces | 2024-08-04 | 8 Circular Quay W | Sydney | NSW | 2000 | Australia | Matthew Grant | PNT-20240804-B02 | PO-AU-0014 | Paint buckets delivered on time and stored. |
| P-015 | Plumbing | 110 | PH-PL-02 | Berlin Medical Center | M-1015 | PEX Tubing | plumbing | S-2005 | PlumbTech GmbH | D-00015 | 2024-10-14 | 13:10 | delayed | meters | 2024-10-12 | 50 Friedrichstrasse | Berlin | BE | 10117 | Germany | Klaus Werner | PEX-20241014-P03 | PO-DE-0015 | Delay due to customs clearance process. |
| P-016 | Framing | 400 | PH-FR-03 | Madrid Expo Center | M-1016 | Galvanized Nails | structural | S-2006 | NailTech España | D-00016 | 2024-06-28 | 06:00 | on-time | kilograms | 2024-06-28 | Calle Real 21 | Madrid | MD | 28013 | Spain | Ana Morales | NLS-20240628-G01 | PO-ES-0016 | Nails delivered and checked at site. |
| P-017 | Electrical | 18 | PH-EL-03 | Dublin Tech Park | M-1017 | Electrical Panels | electrical | S-2007 | Emerald Electric | D-00017 | 2024-09-15 | 17:45 | partial | pieces | 2024-09-14 | 29 Pearse St | Dublin | DN | D02 Y006 | Ireland | Sean Gallagher | ELP-20240915-E05 | PO-IE-0017 | Partial delivery, 4 panels missing from shipment. |
| P-018 | Interior | 100 | PH-IT-03 | Vancouver Trade Center | M-1018 | Acoustic Ceiling Tiles | finishing | S-2008 | Ceilings Plus Canada | D-00018 | 2024-11-01 | 08:15 | damaged | pieces | 2024-10-31 | 200 Granville St | Vancouver | BC | V6C 1S4 | Canada | Lydia Chen | ACT-20241101-T04 | PO-CA-0018 | 15 tiles arrived cracked. Damage documented. |
| P-019 | Foundation | 300 | PH-FA-03 | Melbourne City Hall | M-1019 | Aggregate Gravel | structural | S-2009 | Oz Materials Pty Ltd | D-00019 | 2024-12-13 | 05:55 | delayed | tons | 2024-12-10 | 80 Swanston St | Melbourne | VIC | 3000 | Australia | Timothy Lane | GRVL-20241213-G02 | PO-AU-0019 | Weather-related delays impacted delivery. |
| P-020 | Framing | 0 | PH-FR-04 | Barcelona Business Plaza | M-1020 | Steel Studs | structural | S-2010 | MetalForm Spain | D-00020 | 2024-07-20 | 14:30 | cancelled | pieces | 2024-07-19 | 10 Plaça de Catalunya | Barcelona | CT | 08002 | Spain | blank | blank | PO-ES-0020 | Order cancelled by project manager. |
What the 125 rows show
from the 125-row sampleFoundation (phase name) stands out: mean quantity_
- 130.0median quantity_
delivered - 4material types
- 5delivery statuses
- 8site address countries
- 13unit of measures
Median 130.0, from 0.0 to 540.8.
- string 22
- float 1
- date 2
Columns
25 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 22 columns | |||
project_id | string | Unique identifier for the construction project | P-001 |
project_name | string | Name of the construction project | Harbor Apartments |
phase_id | string | Unique identifier for the construction phase | PH-FA-01 |
phase_name | string | Name of the construction phase (e.g., foundation, framing, finishing)7 names | Foundation |
material_id | string | Unique identifier for the material | M-1001 |
material_name | string | Name or description of the material (e.g., concrete, steel beams) | Ready-Mix Concrete |
material_type | string | Type/category of the material (e.g., structural, finishing, electrical)4 types · optional | structural |
supplier_id | string | Unique identifier for the supplier | S-1001 |
supplier_name | string | Name of the supplier providing the material | CementWorks USA |
delivery_id | string | Unique identifier for the delivery eventunique | D-00001 |
delivery_time | string | Time of day when the material was delivered (HH:MM format)optional | 08:30 |
delivery_status | string | Status of the delivery (e.g., on-time, delayed, damaged)on-time · delayed · damaged · partial · cancelled | on-time |
unit_of_measure | string | Unit of measure for the delivered quantity (e.g., tons, cubic meters, pieces) | cubic meters |
site_address_street | string | Street address of the construction site | 101 Liberty Ave |
site_address_city | string | City of the construction site | Houston |
site_address_state | string | State or province of the construction site | TX |
site_address_postal_code | string | Postal code of the construction site | 77002 |
site_address_country | string | Country of the construction site8 countries | USA |
received_by | string | Name or identifier of the person who received the delivery at the siteoptional | Jorge Ramirez |
delivery_notes | string | Additional notes or comments about the delivery eventoptional | No issues with delivery. |
traceability_reference | string | Reference code or batch number for traceability of the materialoptional | CONC-20240305-B01 |
procurement_order_id | string | Identifier for the procurement order associated with the deliveryoptional | PO-USA-0001 |
| Numbers 1 column | |||
quantity_delivered | float | Quantity of material delivered (in specified units)0 or more | 250.5 |
| Dates and times 2 columns | |||
delivery_date | date | Date when the material was delivered | 2024-03-05 |
expected_delivery_date | date | Scheduled date for delivery according to procurement planoptional | 2024-03-05 |
Use it for
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.
- Projects125P-001250.5Foundati…P-002120FramingP-00375Electric…
A software demo
Believable projects with project_
name, phase_ id and phase_ name to fill a screen in front of a buyer.
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.
- 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.
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