Equipment Maintenance
This dataset provides comprehensive logs of equipment maintenance activities, detailing service dates, technician information, replaced parts, associated costs, and future service schedules. It enables organizations to track asset reliability, optimize maintenance cycles, and analyze operational expenses for improved decision-making.
Sample rows
preview · 8 of 200 rows · all 15 columns| maintenance_idinteger | service_typestring | downtime_minutesinteger | asset_namestring | asset_idstring | service_datedate | technician_idstring | technician_namestring | parts_replacedstring | cost_laborfloat | cost_partsfloat | total_costfloat | next_service_datedate | locationstring | technician_notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | preventive | 45 | HVAC System Main Hall | A1001 | 2022-03-15 | T101 | Maria Thompson | Filter-A1001 | 110 | 28.5 | 138.5 | 2022-09-15 | Plant 1 - Main Hall | Routine check, replaced air filter and cleaned intake. |
| 2 | corrective | 250 | Hydraulic Pump Unit 2 | A2034 | 2022-05-23 | T102 | James O'Connor | Valve-A2034 | 220 | 140 | 360 | 2022-09-23 | Plant 2 - Pump Area | Failure detected, replaced pressure valve, recalibrated system. |
| 3 | inspection | 10 | Cooling Tower Roof | A3109 | 2022-04-08 | T103 | Linda Chen | blank | 75 | 0 | 75 | 2023-04-08 | Plant 1 - Rooftop | Inspection completed, no issues found. |
| 4 | preventive | 38 | Compressor Room No. 5 | A5312 | 2022-07-19 | T104 | Victor Garcia | Filter-A5312 | 120 | 32 | 152 | 2023-01-19 | Plant 3 - Compressor Room | Routine preventive maintenance, replaced oil filter. |
| 5 | other | 1200 | Water Treatment Tank 4 | A8201 | 2022-08-03 | T105 | Olivia Patel | Panel-A8201,Sensor-A8201 | 410 | 980 | 1390 | 2022-10-03 | Plant 2 - Treatment Zone | Emergency event, replaced control panel and sensors. |
| 6 | preventive | 22 | Backup Generator East | A9620 | 2022-09-14 | T106 | Samuel Lee | Plug-A9620 | 95 | 18 | 113 | 2023-03-14 | Plant 4 - Generator Room | Routine maintenance, replaced spark plug. |
| 7 | corrective | 420 | Boiler System West Block | A4201 | 2022-11-02 | T107 | Emma Rossi | Burner-A4201 | 265 | 330 | 595 | 2023-03-02 | Plant 1 - Boiler Room | Failure detected, replaced burner assembly. |
| 8 | inspection | 7 | Hydraulic Pump Unit 2 | A2034 | 2023-01-17 | T102 | James O'Connor | blank | 100 | 0 | 100 | 2024-01-17 | Plant 2 - Pump Area | Inspection completed, no issues identified. |
| 9 | preventive | 30 | Cooling Tower Roof | A3109 | 2023-02-09 | T103 | Linda Chen | Mesh-A3109 | 112 | 25 | 137 | 2023-08-09 | Plant 1 - Rooftop | Routine check, replaced intake mesh. |
| 10 | corrective | 650 | Compressor Room No. 5 | A5312 | 2023-03-03 | T104 | Victor Garcia | Motor-A5312 | 320 | 595 | 915 | 2023-05-03 | Plant 3 - Compressor Room | Failure detected, replaced compressor motor. |
| 11 | inspection | 5 | Water Treatment Tank 4 | A8201 | 2023-04-14 | T105 | Olivia Patel | blank | 63 | 0 | 63 | 2024-04-14 | Plant 2 - Treatment Zone | Inspection completed, system in good condition. |
| 12 | corrective | 540 | Backup Generator East | A9620 | 2023-05-10 | T106 | Samuel Lee | Starter-A9620,Battery-A9620 | 275 | 210 | 485 | 2023-09-10 | Plant 4 - Generator Room | Corrective action, replaced starter and battery. |
| 13 | inspection | 0 | Boiler System West Block | A4201 | 2023-06-22 | T107 | Emma Rossi | blank | 80 | 0 | 80 | 2024-06-22 | Plant 1 - Boiler Room | Routine cleaning, no parts replaced. |
| 14 | corrective | 740 | Cooling Tower Roof | A3109 | 2023-07-17 | T103 | Linda Chen | Blades-A3109,Sensor-A3109 | 330 | 410 | 740 | 2023-10-17 | Plant 1 - Rooftop | Failure, replaced fan blades and sensor. |
| 15 | preventive | 52 | HVAC System Main Hall | A1001 | 2023-08-11 | T101 | Maria Thompson | Coil-A1001 | 138 | 44 | 182 | 2024-02-11 | Plant 1 - Main Hall | Preventive maintenance, replaced cooling coil. |
| 16 | other | 1500 | Hydraulic Pump Unit 2 | A2034 | 2023-09-07 | T102 | James O'Connor | Motor-A2034,Seal-A2034 | 410 | 690 | 1100 | 2023-11-07 | Plant 2 - Pump Area | Emergency, replaced motor and seal. |
| 17 | inspection | 3 | Compressor Room No. 5 | A5312 | 2023-10-22 | T104 | Victor Garcia | blank | 65 | 0 | 65 | 2024-10-22 | Plant 3 - Compressor Room | Inspection completed, no issues. |
| 18 | preventive | 36 | Water Treatment Tank 4 | A8201 | 2023-11-18 | T105 | Olivia Patel | Valve-A8201 | 105 | 33 | 138 | 2024-05-18 | Plant 2 - Treatment Zone | Preventive maintenance, replaced water inlet valve. |
| 19 | preventive | 27 | Backup Generator East | A9620 | 2024-01-09 | T106 | Samuel Lee | Filter-A9620 | 92 | 24 | 116 | 2024-07-09 | Plant 4 - Generator Room | Routine check, replaced fuel filter. |
| 20 | other | 1850 | Boiler System West Block | A4201 | 2024-02-13 | T107 | Emma Rossi | Module-A4201,Board-A4201 | 320 | 1275 | 1595 | 2024-04-13 | Plant 1 - Boiler Room | Emergency event, replaced ignition module and control board. |
What the 200 rows show
from the 200-row sampleOther (service type) stands out: mean downtime_
- 29median downtime_
minutes - 11assets
- 30locations
- 31technicians
- 31technician names
- 122.8median cost_
labor
Median 29, from 0 to 1,940.
- string 8
- integer 2
- float 3
- date 2
Columns
15 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 8 columns | |||
asset_id | string | Unique identifier for the equipment or asset being serviced11 assets | A1001 |
asset_name | string | Name or description of the equipment or asset | HVAC System Main Hall |
technician_id | string | Identifier for the technician who performed the service | T101 |
technician_name | string | Full name of the technician who performed the service | Maria Thompson |
technician_notes | string | Detailed notes or comments from the technician regarding the maintenanceoptional | Routine check, replaced a… |
parts_replaced | string | Comma-separated list of part names or codes replaced during serviceoptional | Filter-A1001 |
service_type | string | Type of maintenance service performed (e.g., preventive, corrective, inspection)preventive · corrective · inspection · other | preventive |
location | string | Physical location of the asset during maintenance (e.g., plant, building, room)optional | Plant 1 - Main Hall |
| Numbers 5 columns | |||
maintenance_id | integer | Unique identifier for each maintenance log entryunique · 1 or more | 1 |
cost_labor | float | Cost of labor for the maintenance service0 or more | 110 |
cost_parts | float | Cost of parts replaced during the maintenance service0 or more · optional | 28.5 |
total_cost | float | Total cost of the maintenance service (labor + parts)0 or more | 138.5 |
downtime_minutes | integer | Total downtime in minutes due to maintenance0 or more · optional | 45 |
| Dates and times 2 columns | |||
service_date | date | Date when the maintenance service was performed | 2022-03-15 |
next_service_date | date | Scheduled date for the next maintenance serviceoptional | 2022-09-15 |
Use it for
A manufacturing dashboard
Downtime_
minutes by service_ type and a breakdown of asset_ name. Excel, Power BI or Tableau. Why do the 21 other rows have a mean downtime_
minutes of 1,399? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Rows200145preventi…2250correcti…310inspecti…
A software demo
Believable rows with asset_
id, asset_ name and service_ date to fill a screen in front of a buyer.
blueprint · equipment-maintenance
Behind this dataset
Same schema. As many rows as you need.
These 200 rows came out of a blueprint — 15 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.
- Equipment ID references asset inventory
- Maintenance type: preventive, corrective, emergency
- Service date and next service date
- Parts cost and labor cost tracked
- Downtime hours impact operations
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
- equipment-maintenance