Property Maintenance Supply Chain Log
This dataset provides a comprehensive log of property maintenance supply chain activities, including sourcing, shipment, and fulfillment details for each order. It enables real estate managers to monitor supply cycles, identify delays, evaluate vendor performance, and optimize building operations. The structured format supports analytics for downtime reduction and vendor benchmarking.
Sample rows
preview · 8 of 65 rows · all 27 columns| log_idinteger | shipment_statusstring | vendor_ratingfloat | property_statestring | property_idinteger | property_namestring | property_street_addressstring | property_citystring | property_postal_codestring | property_countrystring | supply_idinteger | supply_namestring | supply_categorystring | quantity_orderedinteger | unit_pricefloat | total_order_valuefloat | vendor_idinteger | vendor_namestring | vendor_contact_namestring | vendor_contact_emailstring | order_datedate | expected_delivery_datedate | actual_delivery_datedate | delay_reasonstring | fulfillment_statusstring | received_bystring | notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | delivered | 4.9 | CO | 101 | Pinecrest Apartments | 1542 Pine St. | Denver | 80220 | USA | 2001 | LED Light Bulb | electrical | 50 | 2.75 | 137.5 | 301 | Bright Supplies LLC | Sandra Lee | s.lee@ | 2024-05-02 | 2024-05-06 | 2024-05-06 | blank | complete | Eric Davis | All items received in good condition. |
| 2 | delayed | 4 | IL | 102 | Lakeside Villas | 890 Lakeview Dr. | Chicago | 60657 | USA | 2002 | Plunger | plumbing | 15 | 6.5 | 97.5 | 302 | PlumbPro Inc. | George Fisher | gfisher@ | 2024-04-28 | 2024-05-03 | 2024-05-04 | Supplier inventory issue | complete | Maria Gomez | One day delay, otherwise fine. |
| 3 | delivered | 4.7 | OH | 103 | Maple Grove Offices | 421 Maple Ave. | Columbus | 43215 | USA | 2003 | Air Filter | HVAC | 30 | 8.25 | 247.5 | 303 | CleanAir Distributors | Lisa Tran | lisa.tran@ | 2024-05-07 | 2024-05-12 | 2024-05-12 | blank | complete | John McNeil | Filters match specifications. |
| 4 | delivered | 4.8 | AZ | 104 | Sunrise Commercial Center | 77 Sunrise Blvd. | Phoenix | 85016 | USA | 2004 | Glass Cleaner | cleaning | 20 | 4.25 | 85 | 304 | Sparkle Cleaning Co. | Neil Patterson | neilp@ | 2024-04-29 | 2024-05-02 | 2024-05-02 | blank | complete | Patricia Lee | blank |
| 5 | in-transit | blank | CO | 101 | Pinecrest Apartments | 1542 Pine St. | Denver | 80220 | USA | 2005 | Pipe Wrench | plumbing | 10 | 12 | 120 | 302 | PlumbPro Inc. | George Fisher | gfisher@ | 2024-05-10 | 2024-05-13 | blank | blank | pending | blank | blank |
| 6 | delivered | 5 | TX | 105 | Willow Park Residence | 332 Willow St. | Austin | 78705 | USA | 2006 | Mop Bucket | cleaning | 8 | 18.5 | 148 | 304 | Sparkle Cleaning Co. | Neil Patterson | neilp@ | 2024-05-01 | 2024-05-04 | 2024-05-03 | blank | complete | Ryan Chu | Fast delivery, excellent service. |
| 7 | shipped | blank | WA | 106 | Broadway Lofts | 1012 Broadway Ave. | Seattle | 98122 | USA | 2007 | Extension Cord | electrical | 25 | 9 | 225 | 301 | Bright Supplies LLC | Sandra Lee | s.lee@ | 2024-05-03 | 2024-05-10 | blank | blank | pending | blank | blank |
| 8 | ordered | blank | CA | 107 | Sierra Ridge Homes | 55 Sierra Ridge Rd. | Sacramento | 95814 | USA | 2008 | Toilet Flapper | plumbing | 40 | 3.75 | 150 | 302 | PlumbPro Inc. | George Fisher | gfisher@ | 2024-05-12 | 2024-05-15 | blank | blank | pending | blank | blank |
| 9 | delayed | 3.8 | FL | 108 | Garden View Plaza | 888 Garden View Ln. | Miami | 33130 | USA | 2009 | Disinfectant Spray | cleaning | 65 | 5.99 | 389.35 | 305 | CleanSource Market | Derek Wallace | derek.wallace@ | 2024-05-05 | 2024-05-08 | 2024-05-09 | Shipping partner delay | complete | Alicia Bond | Delivery was late by one day. |
| 10 | delivered | 4.5 | TX | 109 | Oak Hill Towers | 203 Oak Hill Dr. | Dallas | 75201 | USA | 2010 | HVAC Thermostat | HVAC | 12 | 37.5 | 450 | 303 | CleanAir Distributors | Lisa Tran | lisa.tran@ | 2024-05-04 | 2024-05-10 | 2024-05-10 | blank | complete | Kevin Young | Installed successfully. |
| 11 | in-transit | blank | MA | 110 | Union Square Residences | 181 Union Square | Boston | 02114 | USA | 2011 | Circuit Breaker | electrical | 6 | 24 | 144 | 301 | Bright Supplies LLC | Sandra Lee | s.lee@ | 2024-05-06 | 2024-05-13 | blank | blank | pending | blank | blank |
| 12 | delivered | 4.6 | MN | 111 | Riverfront Offices | 500 Riverfront Blvd. | Minneapolis | 55401 | USA | 2012 | Vacuum Cleaner | cleaning | 3 | 135 | 405 | 304 | Sparkle Cleaning Co. | Neil Patterson | neilp@ | 2024-05-08 | 2024-05-12 | 2024-05-12 | blank | complete | Rachel Kim | blank |
| 13 | delayed | 4.2 | CA | 112 | Harbor Point Condos | 77 Harbor Point | San Diego | 92101 | USA | 2013 | Drain Cleaner | plumbing | 25 | 7.8 | 195 | 302 | PlumbPro Inc. | George Fisher | gfisher@ | 2024-05-05 | 2024-05-09 | 2024-05-10 | Weather-related shipping delay | complete | Laura Smith | Delivered a day late due to heavy rain. |
| 14 | shipped | blank | OR | 113 | Cedar Heights | 120 Cedar Heights Rd. | Portland | 97209 | USA | 2014 | Ceiling Fan | electrical | 4 | 55 | 220 | 301 | Bright Supplies LLC | Sandra Lee | s.lee@ | 2024-05-02 | 2024-05-09 | blank | blank | pending | blank | blank |
| 15 | delivered | 4.4 | MO | 114 | Meadowfield Estates | 410 Meadowfield Ln. | Kansas City | 64112 | USA | 2015 | Air Conditioner Filter | HVAC | 18 | 10.5 | 189 | 303 | CleanAir Distributors | Lisa Tran | lisa.tran@ | 2024-04-30 | 2024-05-03 | 2024-05-03 | blank | complete | Sean Parker | blank |
| 16 | ordered | blank | NC | 115 | Parkside Business Center | 201 Parkside Ave. | Raleigh | 27601 | USA | 2016 | Floor Scrubber | cleaning | 2 | 249.99 | 499.98 | 305 | CleanSource Market | Derek Wallace | derek.wallace@ | 2024-05-09 | 2024-05-13 | blank | blank | pending | blank | blank |
| 17 | ordered | blank | CO | 101 | Pinecrest Apartments | 1542 Pine St. | Denver | 80220 | USA | 2017 | Outlet Covers | electrical | 60 | 1.25 | 75 | 301 | Bright Supplies LLC | Sandra Lee | s.lee@ | 2024-05-11 | 2024-05-17 | blank | blank | pending | blank | For routine electrical maintenance. |
| 18 | shipped | blank | GA | 116 | Stonegate Offices | 663 Stonegate Pkwy. | Atlanta | 30303 | USA | 2018 | Hand Soap Refill | cleaning | 45 | 3.95 | 177.75 | 305 | CleanSource Market | Derek Wallace | derek.wallace@ | 2024-05-10 | 2024-05-14 | blank | blank | pending | blank | blank |
| 19 | delayed | 3.9 | CA | 117 | Westfield Gardens | 315 Westfield Dr. | San Francisco | 94109 | USA | 2019 | Faucet Cartridge | plumbing | 22 | 11.75 | 258.5 | 302 | PlumbPro Inc. | George Fisher | gfisher@ | 2024-05-03 | 2024-05-08 | 2024-05-09 | Backorder from manufacturer | complete | Shawn Patel | Vendor communicated delay promptly. |
| 20 | ordered | blank | OH | 118 | Elmwood Plaza | 212 Elmwood Ave. | Cleveland | 44115 | USA | 2020 | HVAC Fan Belt | HVAC | 14 | 17 | 238 | 303 | CleanAir Distributors | Lisa Tran | lisa.tran@ | 2024-05-13 | 2024-05-18 | blank | blank | pending | blank | blank |
What the 65 rows show
from the 65-row sampleDelayed (shipment status) stands out: mean vendor_
- 4.4median vendor_
rating - 2fulfillment statuses
- 4supply categories
- 11vendor names
- 11vendor contact names
- 11vendor contact emails
Median 4.4, from 3.5 to 5.0.
- string 16
- integer 5
- float 3
- date 3
Columns
27 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 16 columns | |||
property_name | string | Name of the propertyup to 255 | Pinecrest Apartments |
property_street_address | string | Street address of the propertyup to 255 | 1542 Pine St. |
property_city | string | City where the property is locatedup to 100 | Denver |
property_state | string | State or region of the propertyup to 100 | CO |
property_postal_code | string | Postal code of the propertyup to 20 | 80220 |
property_country | string | Country of the propertyup to 100 | USA |
supply_name | string | Name of the maintenance supply itemup to 255 | LED Light Bulb |
supply_category | string | Category of the maintenance supply (e.g., plumbing, electrical, cleaning)up to 100 · 4 categories | electrical |
vendor_name | string | Name of the vendorup to 255 · 11 names | Bright Supplies LLC |
vendor_contact_name | string | Primary contact person at the vendorup to 100 · 11 names · optional | Sandra Lee |
vendor_contact_email | string | Email address of the vendor contactup to 100 · 11 emails · optional | s.lee@ |
shipment_status | string | Current status of the shipment (e.g., ordered, shipped, in-transit, delivered, delayed, cancelled)6 values | delivered |
delay_reason | string | Reason for any shipment delay, if applicableup to 255 · optional | Supplier inventory issue |
fulfillment_status | string | Status of order fulfillment (e.g., pending, complete, partial, cancelled)pending · complete · partial · cancelled | complete |
received_by | string | Name of the person who received the supplies at the propertyup to 100 · optional | Eric Davis |
notes | string | Additional notes or comments about the order or deliveryoptional | Installed successfully. |
| Numbers 8 columns | |||
log_id | integer | Unique identifier for each supply chain log entryunique · 1 or more | 1 |
property_id | integer | Unique identifier for the property where supplies are delivered1 or more | 101 |
supply_id | integer | Unique identifier for the maintenance supply item1 or more | 2001 |
quantity_ordered | integer | Number of supply items ordered1 or more | 50 |
unit_price | float | Price per unit of the supply item0 or more | 2.75 |
total_order_value | float | Total value of the order (quantity_ordered * unit_price)0 or more | 137.5 |
vendor_id | integer | Unique identifier for the vendor supplying the item1 or more | 301 |
vendor_rating | float | Performance rating for the vendor (0-5 scale)0 to 5 · optional | 4.9 |
| Dates and times 3 columns | |||
order_date | date | Date when the supply order was placed | 2024-05-02 |
expected_delivery_date | date | Date when the supplies are expected to be delivered | 2024-05-06 |
actual_delivery_date | date | Date when the supplies were actually deliveredoptional | 2024-05-06 |
Use it for
A real estate dashboard
Vendor_
rating by shipment_ status and a breakdown of property_ state. Excel, Power BI or Tableau. Why do the 15 delayed rows have a mean vendor_
rating of 3.9? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Rows6514.9delivered24delayed34.7delivered
A software demo
Believable rows with property_
id, property_ name and property_ street_ address to fill a screen in front of a buyer.
blueprint · property-maintenance-supply-chain-log
Behind this dataset
Same schema. As many rows as you need.
These 65 rows came out of a blueprint — 27 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.
- Log each supply order from request to delivery.
- Capture vendor approval and performance ratings.
- Flag orders exceeding standard lead times.
- Record supply shortages and substitution actions.
- Include cost and sustainability attributes for each order.
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
- property-maintenance-supply-chain-log