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.

  • opened 7 times
  • last updated 29 Oct 2025
  • by GoMask
The brief that made it

Asset reliability and lifecycle analysis

Sample rows

preview · 8 of 200 rows · all 15 columns
maintenance_idintegerservice_typestringdowntime_minutesintegerasset_namestringasset_idstringservice_datedatetechnician_idstringtechnician_namestringparts_replacedstringcost_laborfloatcost_partsfloattotal_costfloatnext_service_datedatelocationstringtechnician_notesstring
1preventive45HVAC System Main HallA10012022-03-15T101Maria ThompsonFilter-A100111028.5138.52022-09-15Plant 1 - Main HallRoutine check, replaced air filter and cleaned intake.
2corrective250Hydraulic Pump Unit 2A20342022-05-23T102James O'ConnorValve-A20342201403602022-09-23Plant 2 - Pump AreaFailure detected, replaced pressure valve, recalibrated system.
3inspection10Cooling Tower RoofA31092022-04-08T103Linda Chenblank750752023-04-08Plant 1 - RooftopInspection completed, no issues found.
4preventive38Compressor Room No. 5A53122022-07-19T104Victor GarciaFilter-A5312120321522023-01-19Plant 3 - Compressor RoomRoutine preventive maintenance, replaced oil filter.
5other1200Water Treatment Tank 4A82012022-08-03T105Olivia PatelPanel-A8201,Sensor-A820141098013902022-10-03Plant 2 - Treatment ZoneEmergency event, replaced control panel and sensors.
6preventive22Backup Generator EastA96202022-09-14T106Samuel LeePlug-A962095181132023-03-14Plant 4 - Generator RoomRoutine maintenance, replaced spark plug.
7corrective420Boiler System West BlockA42012022-11-02T107Emma RossiBurner-A42012653305952023-03-02Plant 1 - Boiler RoomFailure detected, replaced burner assembly.
8inspection7Hydraulic Pump Unit 2A20342023-01-17T102James O'Connorblank10001002024-01-17Plant 2 - Pump AreaInspection completed, no issues identified.

What the 200 rows show

from the 200-row sample

Other (service type) stands out: mean downtime_minutes is 1,399, against 96.4 for the rest.

  • 29median downtime_minutes
  • 11assets
  • 30locations
  • 31technicians
  • 31technician names
  • 122.8median cost_labor
Mean downtime_minutes by service_type200 rows
01,0002,00024.1preventi…59 rows245.3correcti…64 rows2.4inspecti…56 rows1,399other21 rows
downtime_minutes200 rows, in bands of 200
075150146246403752301,0002,000downtime_minutes →

Median 29, from 0 to 1,940.

asset_name200 rows · top 10 of 32 values
  1. Thermal Transfer Heat Exchanger9
  2. Conveyor System South8
  3. Air Compressor Station 78
  4. Central Hydraulic Compressor Unit8
  5. Cooling Water Recirculation Pump8
  6. Rotary Air Handler Main8
  7. Water Chiller Assembly 20348
  8. HVAC Controller 53128
  9. Packaging Line Belt B7
  10. Mixing Tank Upper Block7
15 columns by typefrom the column list below
  • string 8
  • integer 2
  • float 3
  • date 2

Columns

15 columns in three groups
blueprint · 15 columns
columntypedescriptionexample
Text 8 columns
asset_idstringUnique identifier for the equipment or asset being serviced11 assetsA1001
asset_namestringName or description of the equipment or assetHVAC System Main Hall
technician_idstringIdentifier for the technician who performed the serviceT101
technician_namestringFull name of the technician who performed the serviceMaria Thompson
technician_notesstringDetailed notes or comments from the technician regarding the maintenanceoptionalRoutine check, replaced a…
parts_replacedstringComma-separated list of part names or codes replaced during serviceoptionalFilter-A1001
service_typestringType of maintenance service performed (e.g., preventive, corrective, inspection)preventive · corrective · inspection · otherpreventive
locationstringPhysical location of the asset during maintenance (e.g., plant, building, room)optionalPlant 1 - Main Hall
Numbers 5 columns
maintenance_idintegerUnique identifier for each maintenance log entryunique · 1 or more1
cost_laborfloatCost of labor for the maintenance service0 or more110
cost_partsfloatCost of parts replaced during the maintenance service0 or more · optional28.5
total_costfloatTotal cost of the maintenance service (labor + parts)0 or more138.5
downtime_minutesintegerTotal downtime in minutes due to maintenance0 or more · optional45
Dates and times 2 columns
service_datedateDate when the maintenance service was performed2022-03-15
next_service_datedateScheduled date for the next maintenance serviceoptional2022-09-15

Use it for

  • median downtim…29200 rowsmean downtime minutes…24.1prev…245.3corr…2.4insp…1.4kother

    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.

  • A software demo

    Believable rows with asset_id, asset_name and service_date to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 15 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 dataset200 rows15 columns
Yours1,000 rows15 columnslocation: UK only

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.

Rules it was built with
  • 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
Rows
Open the blueprint in Data Factory

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

What should your data show?

Preview 20 rows free
No signup. No card.