• Energy
  • 25 columns
  • 802 rows
  • 8 formats

Cable Diagnostic Testing - Partial Discharge and Tan Delta

This dataset provides detailed records of offline and online diagnostic tests performed on medium-voltage cables, including partial discharge, tan delta, VLF withstand, and TDR measurements. Each entry captures test results, cable specifications, location, and technician information, enabling comprehensive asset health analysis and predictive maintenance planning for electrical infrastructure.

  • last updated 1 Nov 2025
  • by GoMask
The brief that made it

Asset health monitoring and predictive maintenance for electrical utilities

Sample rows

preview · 8 of 802 rows · all 25 columns
test_idstringtest_resultstringtan_delta_valuefloattdr_reflection_typestringcable_idstringtest_datedatetimetest_typestringtest_modestringoperator_namestringlocation_namestringlocation_street_addressstringlocation_citystringlocation_statestringlocation_postal_codestringlocation_countrystringcable_typestringcable_length_mfloatcable_voltage_rating_kvfloatpd_magnitude_pcfloatpd_location_mfloattan_delta_voltage_kvfloatvlf_test_voltage_kvfloatvlf_test_duration_minfloattdr_reflection_location_mfloatcommentsstring
PD-001-A1WarningblankblankCAB-51362024-02-29T10:28:00ZPartial DischargeOnlineThomas MüllerMunich City SubstationBayerstrasse 88MunichBavaria80335GermanyXLPE350.5101400102.3blankblankblankblankPD detected at 102m, magnitude above recommended threshold. Increased monitoring suggested.
TD-002-B2Fail0.64blankCAB-18722021-07-22T15:45:00ZTan DeltaOfflineSarah O'ConnellLiverpool Utility VaultMersey Rd 24LiverpoolMerseysideL3 5QAUKPILC150033blankblank35blankblankblankHigh Tan Delta value observed. Cable replacement recommended due to insulation aging.
VLF-003-C3PassblankblankCAB-51362023-11-10T09:15:00ZVLF WithstandOfflineJessica SmithHouston Industrial ParkOak Street 220HoustonTX77002USAXLPE250015blankblankblank16.545blankVLF withstand test passed. Cable insulation health within expected parameters.
TDR-004-D4WarningblankImpedance ChangeCAB-90272022-03-28T13:32:00ZTDROnlineBoris IvanovMoscow Metro TunnelLenin Ave 12MoscowMoscow101000RussiaPILC9006.6blankblankblankblankblank287TDR indicates impedance change at 287m. Further investigation recommended.
TD-005-E5Pass0.08blankCAB-12752023-06-15T16:48:00ZTan DeltaOnlineLei ZhangBeijing Power NodeDongcheng St 8BeijingBeijing100007ChinaXLPE80011blankblank11.6blankblankblankTan Delta value well within safe limits. No action required.
PD-006-F6FailblankblankCAB-68212024-01-18T12:20:00ZPartial DischargeOfflineMohammed IbrahimDetroit Service CenterWoodward Ave 335DetroitMI48226USAXLPE1200333500780blankblankblankblankCritical PD detected near 780 meters. Cable requires urgent remediation.
TDR-007-G7FailblankShortCAB-51142023-05-09T11:40:00ZTDROfflineMartin FischerBerlin Power GridAlexanderplatz 5BerlinBerlin10178GermanyXLPE175015blankblankblankblankblank1010Short circuit detected by TDR. Cable section requires immediate replacement.
VLF-008-H8PassblankblankCAB-34202022-04-01T23:59:59ZVLF WithstandOnlineDavid WilsonSydney Commercial HubGeorge St 14SydneyNSW2000AustraliaEPR1001blankblankblank1.230blankVLF test for EPR cable successful. No insulation degradation detected.

What the 802 rows show

from the 802-row sample

Pass (test result) stands out: mean tan_delta_value is 0.07, against 0.71 for the rest.

  • 0.09median tan_delta_value
  • 2test modes
  • 4test types
  • 4cable types
  • 54location countries
  • 161location cities
Mean tan_delta_value by test_result203 rows
00.40.80.07Pass130 rows0.78Fail37 rows0.64Warning36 rows
tan_delta_value203 rows, in bands of 0.1
0551101041384611191317800.51tan_delta_value →

Median 0.09, from 0.01 to 0.99.

tdr_reflection_type190 rows with a value · 612 left blank
  1. Impedance Change59
  2. Other52
  3. Open40
  4. Short39
25 columns by typefrom the column list below
  • string 15
  • float 9
  • datetime 1

Columns

25 columns in three groups
blueprint · 25 columns
columntypedescriptionexample
Text 15 columns
test_idstringUnique identifier for each diagnostic test eventuniquePD-001-A1
cable_idstringUnique identifier for the cable being testedCAB-5136
test_typestringType of diagnostic test performed (PD, Tan Delta, VLF, TDR)Partial Discharge · Tan Delta · VLF Withstand · TDRPartial Discharge
test_modestringIndicates whether the test was performed offline or onlineOffline · OnlineOnline
operator_namestringName of the technician or engineer who performed the testoptionalThomas Müller
location_namestringName or description of the cable installation locationoptionalMunich City Substation
location_street_addressstringStreet address of the cable installation siteoptionalBayerstrasse 88
location_citystringCity of the cable installation siteoptionalMunich
location_statestringState or province of the cable installation siteoptionalBavaria
location_postal_codestringPostal code of the cable installation siteoptional80335
location_countrystringCountry of the cable installation siteoptionalGermany
cable_typestringType or model of the cable tested (e.g., XLPE, PILC)4 types · optionalXLPE
tdr_reflection_typestringType of reflection detected (e.g., open, short, impedance change)Open · Short · Impedance Change · Other · optionalImpedance Change
test_resultstringOverall result of the test (Pass, Fail, Warning)Pass · Fail · WarningWarning
commentsstringAdditional notes or observations from the testoptionalPD detected at 102m, magn…
Numbers 9 columns
cable_length_mfloatLength of the cable tested, in meters0 or more · optional350.5
cable_voltage_rating_kvfloatVoltage rating of the cable, in kilovolts0 or more · optional10
pd_magnitude_pcfloatPartial discharge magnitude measured in picoCoulombs (pC)0 or more · optional1400
pd_location_mfloatLocation of partial discharge along the cable, in meters from test point0 or more · optional102.3
tan_delta_valuefloatMeasured dissipation factor (tan delta) value0 to 1 · optional0.64
tan_delta_voltage_kvfloatVoltage at which tan delta was measured, in kilovolts0 or more · optional35
vlf_test_voltage_kvfloatVery low frequency test voltage applied, in kilovolts0 or more · optional16.5
vlf_test_duration_minfloatDuration of VLF withstand test, in minutes0 or more · optional45
tdr_reflection_location_mfloatLocation of reflection detected by TDR, in meters from test point0 or more · optional287
Dates and times 1 column
test_datedatetimeDate and time when the diagnostic test was performed2024-02-29T10:28:00Z

Use it for

  • median tan del…0.09203 rowsmean tan delta value …0.07Pass0.78Fail0.64Warning

    An energy dashboard

    Tan_delta_value by test_result and a breakdown of tdr_reflection_type. Excel, Power BI or Tableau.

  • Why do the 130 Pass rows have a mean tan_delta_value of 0.07?

    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 tests with cable_id, test_date and test_type to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 25 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 dataset802 rows25 columns
Yours1,000 rows25 columnslocation_name: UK only

blueprint · cable-diagnostic-testing-partial-discharge-and-tan-delta

Behind this dataset

Same schema. As many rows as you need.

These 802 rows came out of a blueprint — 25 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
  • Cable circuit ID, installation date, and insulation type (XLPE, EPR, PILC)
  • Test method: offline (VLF, tan delta), online (PD monitoring)
  • Partial discharge level in picocoulombs (pC), <5pC acceptable
  • Dissipation factor (tan delta) and trending over time
  • VLF test voltage (0.1Hz, typically 2-3x rated voltage)
  • Insulation resistance (megohms) and polarization index
  • Time-domain reflectometry for fault pre-location
  • Condition assessment: good, monitor, plan replacement, critical
Rows
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
cable-diagnostic-testing-partial-discharge-and-tan-delta

More in Energy

Browse all
Also in EnergyGas Insulated Switchgear (GIS) Inspection and SF6 Leak DetectionElectricity Demand Forecasting DatasetSCADA Alarm and Event ManagementAll 1,966 datasets

What should your data show?

Preview 20 rows free
No signup. No card.