Smart Grid Asset Health Log
This dataset provides granular, real-time health logs for IoT-enabled assets in smart energy grids, including operational status, sensor readings, maintenance history, and geospatial location. It empowers energy providers to optimize grid reliability, prioritize field interventions, and analyze asset health trends for predictive maintenance and sustainability. Designed for operational managers, data scientists, and maintenance teams seeking actionable insights into grid asset performance.
Sample rows
preview · 8 of 120 rows · all 22 columns| log_idstring | intervention_prioritystring | health_scorefloat | sensor_statusboolean | location_countrystring | asset_idstring | asset_typestring | location_latitudefloat | location_longitudefloat | location_street_addressstring | location_citystring | location_statestring | location_postal_codestring | timestampdatetime | operational_statusstring | temperaturefloat | voltagefloat | currentfloat | last_maintenance_datedate | next_maintenance_duedate | issue_descriptionstring | recommendationstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| TX-9GZB1K8 | low | 98.4 | true | USA | TR-1004 | transformer | 40.7128 | -74.006 | 350 Hudson St | New York | NY | 10014 | 2024-04-12T09:15:00Z | normal | 32.1 | 377.2 | 28.6 | 2024-03-10 | 2024-08-10 | blank | Continue regular monitoring and inspection. |
| SM-4HFD2LQ | urgent | 3.2 | false | Spain | SM-5510 | smart_meter | 40.4168 | -3.7038 | Calle de Atocha 42 | Madrid | Madrid | 28012 | 2024-05-08T18:33:20Z | critical | 45.9 | 0 | 0 | 2024-01-18 | 2024-05-18 | No data received from device, appears to be offline. | Immediate field technician dispatch required. |
| SG-8JPK6YT | medium | 69.4 | true | UK | SW-7892 | switchgear | 51.5074 | -0.1278 | 221B Baker St | London | London | NW16XE | 2024-06-03T10:51:44Z | maintenance | 78.3 | 239.8 | 15.6 | 2024-04-01 | 2024-08-01 | Scheduled maintenance ongoing on site. | Complete maintenance checklist and system test. |
| SN-3VPK1XZ | medium | 44.8 | true | Russia | SS-8552 | sensor | 55.7558 | 37.6173 | Lenina 10 | Moscow | Moscow | 101000 | 2024-04-22T04:25:00Z | warning | 125.5 | 8.3 | 0.09 | 2024-02-15 | 2024-06-15 | Abnormal temperature spikes detected. | Inspect sensor for overheating or failure. |
| RL-7BNQ2SF | medium | 50.7 | true | Japan | RY-3003 | relay | 35.6895 | 139.6917 | 2-11-1 Shibuya | Tokyo | Tokyo | 150-0002 | 2024-06-01T21:17:00Z | warning | 82.9 | 127.3 | 18.1 | 2024-03-28 | 2024-09-28 | Frequent switching detected, may cause wear. | Monitor relay cycles; plan preventive check. |
| OT-1FAPZL7 | urgent | 0 | false | Argentina | OT-1000 | other | -34.6037 | -58.3816 | Av. Corrientes 1500 | Buenos Aires | CABA | 1042 | 2024-03-19T14:43:54Z | offline | blank | blank | blank | 2023-10-10 | 2024-03-20 | Asset unreachable, no telemetry for 48 hours. | Immediate on-site inspection required. |
| TX-5VDQ8PW | low | 97.2 | true | France | TR-1007 | transformer | 48.8566 | 2.3522 | 10 Rue de Rivoli | Paris | IDF | 75004 | 2024-05-19T11:12:11Z | normal | 28.2 | 399.6 | 27.9 | 2024-04-10 | 2024-09-10 | blank | Maintain current inspection intervals. |
| SM-3GZT7LP | urgent | 1.5 | false | Norway | SM-5512 | smart_meter | 59.9139 | 10.7522 | Karl Johans gate 3 | Oslo | Oslo | 0154 | 2024-05-29T17:09:00Z | offline | blank | 0 | 0 | 2023-09-01 | 2024-05-30 | Device connection lost, no readings. | Reboot and perform diagnostic check. |
| SG-2YFV5MB | medium | 61.3 | true | India | SW-7893 | switchgear | 19.076 | 72.8777 | Bandra Kurla Complex | Mumbai | MH | 400051 | 2024-03-23T06:07:00Z | warning | 94.1 | 137.7 | 12.3 | 2024-02-10 | 2024-07-10 | Voltage fluctuation observed, possible overload. | Review load distribution and inspect panel. |
| SN-4KDX2FW | high | 9.7 | false | Brazil | SS-8553 | sensor | -23.5505 | -46.6333 | Av. Paulista 900 | Sao Paulo | SP | 01310-100 | 2024-02-18T09:42:00Z | critical | 147.2 | 5.7 | 0.06 | 2023-11-10 | 2024-02-20 | Sensor overheating, risk of failure. | Reduce load, schedule emergency replacement. |
| RL-2QHV7LK | urgent | 2.3 | false | Norway | RY-3005 | relay | 60.472 | 8.4689 | Torggata 12 | Bergen | Vestland | 5014 | 2024-05-17T22:03:00Z | critical | 138.9 | 230.1 | 17.8 | 2023-12-12 | 2024-05-18 | Relay burnout detected, immediate action required. | Replace relay and check associated circuits. |
| TX-2HBG8MD | low | 95.7 | true | USA | TR-1009 | transformer | 34.0522 | -118.2437 | 101 Main St | Los Angeles | CA | 90012 | 2024-02-22T15:48:00Z | normal | 22.4 | 355.8 | 24.6 | 2024-01-15 | 2024-06-15 | blank | Monitor routinely, no action required. |
| SM-7MJC1ZW | medium | 61.9 | false | Spain | SM-5522 | smart_meter | 41.3851 | 2.1734 | Carrer de Balmes 5 | Barcelona | CT | 08007 | 2024-03-10T11:35:10Z | warning | 48.7 | 230 | 13 | 2023-12-20 | 2024-06-20 | Intermittent connection, partial data loss. | Inspect wiring and reset meter. |
| SG-3BDS4VR | medium | 74.2 | true | Mexico | SW-7897 | switchgear | 19.4326 | -99.1332 | Av. Reforma 250 | Mexico City | CDMX | 06600 | 2024-03-29T02:06:22Z | maintenance | 80.6 | 213.5 | 19.7 | 2024-02-15 | 2024-07-15 | Routine scheduled system maintenance. | Complete system checks and clean contacts. |
| SN-9RTU2GK | low | 92.5 | true | Thailand | SS-8555 | sensor | 13.7563 | 100.5018 | Sukhumvit Rd 123 | Bangkok | Bangkok | 10110 | 2024-02-11T13:55:00Z | normal | 24.7 | 11.6 | 0.12 | 2024-01-01 | 2024-06-01 | blank | Continue monitoring, no issues detected. |
| RL-4MZF8LT | low | 89.3 | true | Philippines | RY-3007 | relay | 14.5995 | 120.9842 | Rizal Ave 789 | Manila | NCR | 1000 | 2024-04-15T01:19:00Z | normal | 29.1 | 230.8 | 17.3 | 2024-03-05 | 2024-08-05 | blank | Routine relay check during next scheduled visit. |
| OT-9BGW3XZ | low | 99.7 | true | Iceland | OT-1009 | other | 64.9631 | -19.0208 | Laugavegur 10 | Reykjavik | Capital | 101 | 2024-05-12T08:25:00Z | normal | 1.8 | 250 | 18.5 | 2023-12-10 | 2024-06-10 | blank | Routine asset check, no action required. |
| TX-7NQK3LF | low | 96.4 | true | Germany | TR-1004 | transformer | 52.52 | 13.405 | Alexanderplatz 2 | Berlin | BE | 10178 | 2024-01-18T08:30:00Z | normal | 35.9 | 398.5 | 26.7 | 2023-12-15 | 2024-06-15 | blank | Continue with standard inspection frequency. |
| SM-6FDX8TW | low | 93.6 | true | Kenya | SM-5515 | smart_meter | 1.2921 | 36.8219 | Moi Ave 45 | Nairobi | NA | 00100 | 2024-06-09T12:45:00Z | normal | 42.2 | 230 | 13 | 2024-04-10 | 2024-10-10 | blank | No action needed, continue monitoring. |
| SG-4ZMW9KV | high | 7.6 | false | Mexico | SW-7895 | switchgear | 23.6345 | -102.5528 | Calle 16 400 | Monterrey | NL | 64000 | 2024-02-10T17:12:00Z | critical | 119.7 | 170.6 | 10.1 | 2023-10-10 | 2024-02-15 | High temperature, protection trip activated. | Service switchgear immediately. |
What the 120 rows show
from the 120-row sampleUrgent (intervention priority) stands out: mean health_
- 68%sensor_
status = true - 61.8median health_
score - 5operational statuses
- 6asset types
- 47.2median temperature
- 219.1median voltage
Median 61.8, from 0.0 to 99.8.
- string 12
- float 6
- date 2
- datetime 1
- boolean 1
Columns
22 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 12 columns | |||
log_id | string | Unique identifier for each asset health log entryunique | TX-9GZB1K8 |
asset_id | string | Unique identifier for the IoT-enabled grid asset | TR-1004 |
asset_type | string | Type of grid asset (e.g., transformer, smart meter, switchgear)6 values | transformer |
location_street_address | string | Street address of the asset's physical locationoptional | 350 Hudson St |
location_city | string | City where the asset is locatedoptional | New York |
location_state | string | State or province where the asset is locatedoptional | NY |
location_postal_code | string | Postal code of the asset's locationoptional | 10014 |
location_country | string | Country where the asset is locatedoptional | USA |
operational_status | string | Current operational status of the assetnormal · warning · critical · offline · maintenance | normal |
intervention_priority | string | Priority level for field interventionlow · medium · high · urgent · optional | low |
issue_description | string | Description of any detected issue or anomalyoptional | No data received from dev… |
recommendation | string | Recommended action or intervention for the assetoptional | Maintain regular checks. |
| Numbers 6 columns | |||
location_latitude | float | Latitude coordinate of the asset's location-90 to 90 | 40.7128 |
location_longitude | float | Longitude coordinate of the asset's location-180 to 180 | -74.006 |
health_score | float | Numerical health score indicating asset condition (0-100)0 to 100 | 98.4 |
temperature | float | Current temperature reading from the asset (in Celsius)-50 to 150 · optional | 32.1 |
voltage | float | Current voltage reading from the asset (in Volts)0 or more · optional | 377.2 |
current | float | Current reading from the asset (in Amperes)0 or more · optional | 28.6 |
| Dates and times 3 columns | |||
timestamp | datetime | Date and time when the asset health log was recorded | 2024-04-12T09:15:00Z |
last_maintenance_date | date | Date when the asset was last maintainedoptional | 2024-03-10 |
next_maintenance_due | date | Scheduled date for next maintenanceoptional | 2024-08-10 |
| True or false 1 column | |||
sensor_status | boolean | Indicates if all asset sensors are reporting correctly (true/false)optional | true |
Use it for
An energy dashboard
The sensor_
status rate, health_ score by intervention_ priority and a breakdown of location_ country. Excel, Power BI or Tableau. Why do the 35 urgent rows have a mean health_
score of 3.4? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Logs120TX-9GZB1K898.4lowSM-4HFD2LQ3.2urgentSG-8JPK6YT69.4medium
A software demo
Believable logs with asset_
id, asset_ type and location_ latitude to fill a screen in front of a buyer.
This dataset120 rows22 columns
Yours1,000 rows22 columnslocation_latitude: UK only
blueprint · smart-grid-asset-health-log
Behind this dataset
Same schema. As many rows as you need.
These 120 rows came out of a blueprint — 22 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
- Each asset record must include a unique device ID
- Status updates are logged every 6 hours
- Health score is calculated from recent performance metrics
- Assets flagged 'Critical' trigger immediate review workflow
- Locations are mapped to grid sector zones
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
- smart-grid-asset-health-log