Real Estate Construction Supply Risk Logs
This dataset provides detailed logs of supply chain risks affecting real estate construction projects, including information on delays, disruptions, impacted materials, suppliers, mitigation actions, and financial impacts. It enables project managers and operations teams to monitor vulnerabilities, analyze risk patterns, and improve project delivery timelines and resilience. The structured format supports proactive risk management and comprehensive reporting for large-scale construction operations.
Sample rows
preview · 8 of 62 rows · all 28 columns| risk_log_idstring | risk_severitystring | financial_impact_estimatefloat | location_citystring | project_idstring | project_namestring | location_statestring | location_countrystring | material_idstring | material_namestring | supplier_idstring | supplier_namestring | risk_typestring | risk_statusstring | date_identifieddate | expected_impact_start_datedate | expected_impact_end_datedate | actual_impact_daysinteger | mitigation_statusstring | mitigation_ownerstring | date_mitigateddate | created_bystring | created_atdatetime | updated_bystring | updated_atdatetime | risk_descriptionstring | mitigation_actionstring | residual_riskstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| RL-000001 | high | 3500 | San Diego | PJT-101 | Harbor Residences | CA | USA | MAT-001 | Reinforced Concrete | SUP-005 | WestBuild Materials | delay | identified | 2024-02-15 | 2024-02-18 | 2024-02-22 | 0 | completed | J. Martinez | 2024-02-20 | martinez_j | 2024-02-15T09:48:00 | martinez_j | 2024-02-20T16:03:00 | Scheduled concrete delivery missed due to supplier truck breakdown. | Arranged alternate delivery with backup supplier. | Minor scheduling adjustments required for next phase. |
| RL-000002 | critical | 6100.5 | Toronto | PJT-102 | Maple Grove Heights | ON | Canada | MAT-009 | Insulation Panels | SUP-007 | PolarTech | shortage | in_progress | 2024-01-19 | 2024-01-22 | 2024-02-10 | 8 | in_progress | A. Smith | blank | asmith | 2024-01-19T10:01:00 | asmith | 2024-02-11T15:32:00 | Supply shortage due to winter storm impacting distribution. | Expedited alternate orders and rescheduled insulation tasks. | May affect HVAC installation timeline. |
| RL-000003 | medium | 2600 | Miami | PJT-103 | Emerald Towers | FL | USA | MAT-003 | Glass Facade Panels | SUP-011 | ClearView Glass | quality_issue | mitigated | 2024-02-03 | 2024-02-05 | 2024-02-10 | 3 | completed | K. Lee | 2024-02-11 | klee | 2024-02-03T11:36:00 | klee | 2024-02-12T09:40:00 | Delivered facade panels failed quality inspection due to warping. | Panels returned and replacements prioritized. | Replacement may delay window installation by 2 days. |
| RL-000004 | critical | 9500 | Austin | PJT-104 | Sunset Gardens | TX | USA | MAT-005 | Steel Beams | SUP-003 | LoneStar Steelworks | disruption | identified | 2024-03-04 | 2024-03-06 | 2024-03-20 | 0 | not_started | blank | blank | project_ops | 2024-03-04T08:15:00 | blank | blank | Work stoppage at supplier facility due to labor strike. | Investigating alternative suppliers in neighboring states. | Potential cost increase if alternate supplier is engaged. |
| RL-000005 | medium | 1200.25 | San Diego | PJT-101 | Harbor Residences | CA | USA | MAT-008 | Copper Wiring | SUP-004 | Pacific Electric | delay | mitigated | 2024-01-25 | 2024-01-28 | 2024-02-02 | 2 | completed | T. Nguyen | 2024-02-03 | tnguyen | 2024-01-25T12:03:00 | tnguyen | 2024-02-04T09:15:00 | Late shipment of copper wiring due to customs clearance delay. | Worked with customs broker to expedite shipment. | Electrical rough-in may require re-sequencing. |
| RL-000006 | high | 4300 | Madison | PJT-105 | Lakeside Villas | WI | USA | MAT-007 | Roofing Membrane | SUP-014 | RoofSystems Inc. | quality_issue | in_progress | 2024-02-22 | 2024-02-24 | 2024-03-10 | 0 | in_progress | M. Benson | blank | mbenson | 2024-02-22T13:37:00 | mbenson | 2024-02-25T10:21:00 | Roofing membrane batch was found to have manufacturing defects. | Requested replacement batch and halted installation. | Installation delay may affect interior finishing. |
| RL-000007 | medium | 1900 | Denver | PJT-106 | Mountainview Estates | CO | USA | MAT-004 | Structural Lumber | SUP-009 | RockyTimber | shortage | identified | 2024-01-10 | 2024-01-13 | 2024-01-20 | 0 | not_started | blank | blank | project_ops | 2024-01-10T14:09:00 | blank | blank | Shortage due to supplier’s inventory mismanagement. | Supplier to expedite next shipment. | Risk of further delays if shipment is missed. |
| RL-000008 | high | 7200 | Miami | PJT-103 | Emerald Towers | FL | USA | MAT-010 | Elevator Systems | SUP-006 | LiftCorp | delay | in_progress | 2024-03-01 | 2024-03-05 | 2024-03-20 | 4 | in_progress | S. Patel | blank | spatel | 2024-03-01T10:27:00 | spatel | 2024-03-09T08:51:00 | Elevator system installation delayed by missing permits. | Permit office contacted and expedited. | Elevator commissioning may need rescheduling. |
| RL-000009 | critical | 8800 | Vancouver | PJT-107 | Cedar Court | BC | Canada | MAT-011 | Fire Suppression System | SUP-012 | SafeSpray Ltd. | quality_issue | in_progress | 2024-02-14 | 2024-02-16 | 2024-03-01 | 0 | in_progress | L. Chen | blank | lchen | 2024-02-14T15:21:00 | lchen | 2024-02-28T12:33:00 | Fire suppression system nozzles failed pressure tests. | Defective nozzles replaced, further testing scheduled. | Building occupancy delayed until retest passes. |
| RL-000010 | high | 2640 | Boston | PJT-108 | Seaside Lofts | MA | USA | MAT-002 | Ceramic Tiles | SUP-002 | TileWorld | disruption | identified | 2024-03-05 | 2024-03-06 | 2024-03-15 | 0 | in_progress | D. Rogers | blank | drogers | 2024-03-05T09:50:00 | drogers | 2024-03-10T11:05:00 | Port closure delayed import shipment of tiles. | Sourced interim tiles from local distributor. | Color mismatch possible for some units. |
| RL-000011 | medium | 1100 | Toronto | PJT-102 | Maple Grove Heights | ON | Canada | MAT-012 | HVAC Ductwork | SUP-010 | AirFlow Systems | delay | identified | 2024-02-09 | 2024-02-12 | 2024-02-18 | 0 | not_started | blank | blank | asmith | 2024-02-09T10:14:00 | blank | blank | HVAC ductwork delivery delayed due to production backlog. | Project team adjusted work schedule. | Risk of compounding delays on mechanical systems. |
| RL-000012 | high | 3050 | Chicago | PJT-109 | Prairie Fields | IL | USA | MAT-013 | Gypsum Board | SUP-008 | WallPro | shortage | in_progress | 2024-01-30 | 2024-02-01 | 2024-02-08 | 3 | completed | E. Thomas | 2024-02-09 | ethomas | 2024-01-30T13:55:00 | ethomas | 2024-02-09T17:19:00 | Unexpected demand spike caused gypsum board shortage. | Shifted deliveries from other projects. | Potential shortage if demand increases again. |
| RL-000013 | medium | 850 | Madison | PJT-105 | Lakeside Villas | WI | USA | MAT-014 | Paint | SUP-015 | ColorWorks | other | mitigated | 2024-02-18 | 2024-02-20 | 2024-02-25 | 1 | completed | C. Evans | 2024-02-26 | cevans | 2024-02-18T09:01:00 | cevans | 2024-02-26T10:48:00 | Paint delivery impacted by regulatory recall of batch. | Secured new compliant paint from alternate supplier. | Minor delays in final finishing. |
| RL-000014 | critical | 7800 | Portland | PJT-110 | Riverside Condos | OR | USA | MAT-015 | Aluminum Siding | SUP-013 | AluTech | disruption | identified | 2024-03-12 | 2024-03-15 | 2024-03-28 | 0 | not_started | blank | blank | project_ops | 2024-03-12T10:40:00 | blank | blank | Supplier experienced equipment failure, halting siding production. | On-site inventory checked for alternative options. | Large risk if production is not restored. |
| RL-000015 | high | 5400 | Denver | PJT-106 | Mountainview Estates | CO | USA | MAT-016 | HVAC Units | SUP-016 | ClimateControl | delay | in_progress | 2024-02-13 | 2024-02-15 | 2024-02-27 | 0 | in_progress | B. Wright | blank | bwright | 2024-02-13T08:59:00 | bwright | 2024-02-16T11:15:00 | Units delayed due to backlog in supplier’s inventory. | Supplier committed to partial shipment. | Partial installation may impact schedule. |
| RL-000016 | high | 3000 | Vancouver | PJT-107 | Cedar Court | BC | Canada | MAT-017 | Lighting Fixtures | blank | blank | shortage | in_progress | 2024-02-07 | 2024-02-09 | 2024-02-23 | 4 | completed | N. Singh | 2024-02-23 | nsingh | 2024-02-07T13:48:00 | nsingh | 2024-02-24T14:30:00 | Global chip shortage delayed production of smart lighting systems. | Secured partial shipment from alternate supplier. | Further delays possible for specialty fixtures. |
| RL-000017 | medium | 1200 | Madison | PJT-105 | Lakeside Villas | WI | USA | MAT-018 | Plumbing Fixtures | SUP-017 | FlowSmart | quality_issue | mitigated | 2024-02-05 | 2024-02-07 | 2024-02-10 | 1 | completed | R. Lawson | 2024-02-11 | rlawson | 2024-02-05T09:25:00 | rlawson | 2024-02-12T11:37:00 | Plumbing fixture finish was not compliant with project specification. | Supplier replaced fixtures with compliant batch. | No further issues expected. |
| RL-000018 | medium | 600 | Portland | PJT-110 | Riverside Condos | OR | USA | MAT-019 | Drywall | SUP-018 | SheetRockers | delay | identified | 2024-03-02 | 2024-03-04 | 2024-03-08 | 0 | not_started | blank | blank | project_ops | 2024-03-02T12:13:00 | blank | blank | Drywall shipment delayed due to truck breakdown. | Replacement truck dispatched. | Minimal, if replacement arrives on time. |
| RL-000019 | low | 0 | Boston | PJT-108 | Seaside Lofts | MA | USA | MAT-020 | Carpet | SUP-019 | FloorMasters | other | mitigated | 2024-02-16 | 2024-02-20 | 2024-02-23 | 0 | completed | A. Scott | 2024-02-24 | ascott | 2024-02-16T09:43:00 | ascott | 2024-02-25T13:02:00 | Carpet selected discontinued, requiring new approval. | Designer approved alternate selection. | No impact anticipated. |
| RL-000020 | medium | 1600 | Chicago | PJT-109 | Prairie Fields | IL | USA | MAT-021 | Windows | SUP-020 | ViewRight | delay | in_progress | 2024-02-11 | 2024-02-14 | 2024-02-21 | 0 | in_progress | G. Young | blank | gyoung | 2024-02-11T11:58:00 | gyoung | 2024-02-15T14:12:00 | Window delivery delayed due to supplier’s fleet maintenance. | Supplier expedited maintenance schedule. | May delay window installation. |
What the 62 rows show
from the 62-row sampleCritical (risk severity) stands out: mean financial_
- 4,100median financial_
impact_ estimate - 2location countries
- 3mitigation statuses
- 4risk statuses
- 5risk types
- 0median actual_
impact_ days
Median 4,100, from 0.0 to 42,001.
- string 20
- integer 1
- float 1
- date 4
- datetime 2
Columns
28 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 20 columns | |||
risk_log_id | string | Unique identifier for each supply risk log entryunique | RL-000001 |
project_id | string | Unique identifier for the real estate project | PJT-101 |
project_name | string | Name of the real estate project | Harbor Residences |
location_city | string | City where the project is located | San Diego |
location_state | string | State or province where the project is located | CA |
location_country | string | Country where the project is located2 countries | USA |
material_id | string | Unique identifier for the construction material | MAT-001 |
material_name | string | Name of the critical construction material | Reinforced Concrete |
supplier_id | string | Unique identifier for the supplieroptional | SUP-005 |
supplier_name | string | Name of the supplier providing the materialoptional | WestBuild Materials |
risk_type | string | Type of supply chain risk (e.g., delay, disruption, shortage, quality issue)delay · disruption · shortage · quality_issue · other | delay |
risk_description | string | Detailed description of the supply risk event | Scheduled concrete delive… |
risk_severity | string | Severity level of the risk (e.g., low, medium, high, critical)low · medium · high · critical | high |
risk_status | string | Current status of the risk (e.g., identified, in_progress, mitigated, closed)identified · in_progress · mitigated · closed | identified |
mitigation_action | string | Description of mitigation actions taken to address the riskoptional | Backup truck dispatched. |
mitigation_status | string | Status of mitigation actions (e.g., not_started, in_progress, completed, ineffective)not_started · in_progress · completed · ineffective · optional | completed |
mitigation_owner | string | Name or identifier of the person/team responsible for mitigationoptional | J. Martinez |
residual_risk | string | Description of any remaining risk after mitigationoptional | No impact anticipated. |
created_by | string | User or system that created the risk log entry | martinez_j |
updated_by | string | User or system that last updated the risk log entryoptional | martinez_j |
| Numbers 2 columns | |||
actual_impact_days | integer | Number of days the project was actually impacted due to this risk0 or more · optional | 0 |
financial_impact_estimate | float | Estimated financial impact of the risk (in project currency)0 or more · optional | 3500 |
| Dates and times 6 columns | |||
date_identified | date | Date when the risk was first identified | 2024-02-15 |
expected_impact_start_date | date | Date when the risk is expected to start impacting the projectoptional | 2024-02-18 |
expected_impact_end_date | date | Date when the risk is expected to stop impacting the projectoptional | 2024-02-22 |
date_mitigated | date | Date when the risk was mitigated or closedoptional | 2024-02-20 |
created_at | datetime | Timestamp when the risk log entry was created | 2024-02-15T09:48:00 |
updated_at | datetime | Timestamp when the risk log entry was last updatedoptional | 2024-02-20T16:03:00 |
Use it for
A real estate dashboard
Financial_
impact_ estimate by risk_ severity and a breakdown of location_ city. Excel, Power BI or Tableau. Why do the 14 critical rows have a mean financial_
impact_ estimate of 16,243? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Risk logs62RL-0000013500highRL-0000026100.5criticalRL-0000032600medium
A software demo
Believable risk logs with project_
id, project_ name and location_ city to fill a screen in front of a buyer.
This dataset62 rows28 columns
Yours1,000 rows28 columnslocation_city: UK only
blueprint · real-estate-construction-supply-risk-logs
Behind this dataset
Same schema. As many rows as you need.
These 62 rows came out of a blueprint — 28 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
- Every row represents a material supply event or risk occurrence for a specific project phase.
- Include supplier type, material category, risk type, event date, detected delay duration, and resolution status.
- Capture both realized incidents (e.g., shipment delays) and near-misses flagged by risk monitoring.
- Link each risk event to a quantified impact score (e.g., days delayed, cost overrun estimate).
- Log all mitigation actions (e.g., alternate sourcing) and their effectiveness.
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-risk-logs