SAIDI/SAIFI/CAIDI Reliability Metrics Calculation
This dataset provides comprehensive reliability metrics for electric power systems, including both system-wide and feeder-level indices such as SAIDI, SAIFI, CAIDI, and MAIFI. It enables utilities, regulators, and analysts to track outage frequency and duration, benchmark performance, and identify areas for reliability improvement. The data is structured for easy comparison and trend analysis across different systems and time periods.
Sample rows
preview · 8 of 500 rows · all 14 columns| record_idstring | saidifloat | is_system_wideboolean | report_datedate | system_idstring | feeder_idstring | feeder_namestring | saififloat | caidifloat | maififloat | customer_countinteger | total_interruptionsinteger | total_momentary_interruptionsinteger | notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| R001 | 78.2 | true | 2023-03-15 | SYS-MIDLAND-01 | blank | blank | 1.25 | 62.6 | 1.1 | 32850 | 132 | 19 | Annual reliability report; Midland utility serving urban and suburban loads, typical performance year. |
| R002 | 45.7 | false | 2024-01-29 | SYS-CENTRAL-02 | CENTRAL-023 | Central Park West | 1.86 | 24.6 | 8.2 | 2210 | 34 | 47 | Frequent momentary interruptions due to windstorms in early 2024; urban feeder serving mixed residential. |
| R003 | 64.1 | true | 2022-05-17 | SYS-HARBOR-03 | blank | blank | 1.09 | 58.7 | 0.6 | 48150 | 97 | 28 | System-wide report for Harbor region; infrastructure upgrades completed, reliability improved. |
| R004 | 0 | true | 2020-09-13 | SYS-NORTH-04 | blank | blank | 0 | 0 | 0 | 0 | 0 | 0 | Boundary test case: zero customers, zero interruptions, system was offline for maintenance period. |
| R005 | 68.9 | false | 2023-07-05 | SYS-EAST-05 | EAST-101 | Eastside Commercial | 2.1 | 32.8 | 0.9 | 3100 | 44 | 8 | Feeder-level report; construction activity led to increased interruptions, mostly commercial customers. |
| R006 | 94.2 | false | 2022-12-09 | SYS-GLEN-06 | GLEN-007 | Glenwood Estates | 1.74 | 54.1 | 2.3 | 1675 | 29 | 10 | Aging infrastructure in Glenwood Estates, moderate number of sustained and momentary interruptions. |
| R007 | 22.9 | false | 2024-02-16 | SYS-VALLEY-07 | VALLEY-056 | Valley View | 0.93 | 24.6 | 8.4 | 3650 | 13 | 41 | High momentary interruption rate due to ice storms; Valley View feeder serving dense residential area. |
| R008 | 25.3 | true | 2021-08-22 | SYS-LAKE-08 | blank | blank | 0.74 | 34.2 | 1.2 | 17440 | 25 | 6 | Lake region annual reliability report; performance stable, minor interruptions due to line faults. |
| R009 | 133.8 | false | 2023-10-01 | SYS-RIVER-09 | RIVER-022 | River Bend Rural | 1.25 | 107 | 2.9 | 950 | 21 | 5 | Rural feeder with elevated CAIDI; multiple outages from summer storms, long restoration times. |
| R010 | 76.5 | false | 2020-11-17 | SYS-PINE-10 | PINE-390 | Pine Grove | 1.32 | 57.9 | blank | 1350 | 17 | 7 | Pine Grove feeder, momentary interruptions data incomplete, mostly residential and small commercial. |
| R011 | 11250.4 | true | 2023-06-11 | SYS-COAST-11 | blank | blank | 791.6 | 9999 | 10.5 | 91700 | 900 | 75 | Extreme weather event hit entire Coast system; record outage duration and frequency in June 2023. |
| R012 | 302.8 | false | 2022-04-27 | SYS-HILL-12 | HILL-078 | Hilltop Rural | 1.56 | 125.9 | blank | 1550 | 39 | 9 | Rural feeder with long restoration times; vegetation and terrain challenges increased CAIDI. |
| R013 | 18.7 | true | 2021-02-13 | SYS-METRO-13 | blank | blank | 0.62 | 30.1 | 0.3 | 20400 | 18 | 2 | Metro system annual summary; lowest interruption rates among all regional systems. |
| R014 | 41.2 | true | 2023-09-19 | SYS-FOREST-14 | blank | blank | 1.11 | 37.2 | 0.8 | 42150 | 82 | 12 | System-wide report for Forest region; moderate interruptions, no major events reported. |
| R015 | 101.6 | false | 2022-07-23 | SYS-ROCK-15 | ROCK-045 | Rockville Main | 2.62 | 38.8 | 0.7 | 4200 | 43 | 6 | Rockville feeder affected by construction, elevated interruption frequency during summer 2022. |
| R016 | 95.4 | true | 2023-05-22 | SYS-SOUTH-16 | blank | blank | 1.76 | 54.2 | 0.9 | 36400 | 158 | 35 | South system annual metrics; higher interruptions due to spring thunderstorms. |
| R017 | 0 | false | 2021-12-25 | SYS-PARK-17 | PARK-137 | Parkside North | 0 | 0 | blank | 0 | 0 | 0 | Boundary case: new feeder, no customers, no events as of end of 2021. |
| R018 | 87.3 | true | 2023-11-04 | SYS-BRIDGE-18 | blank | blank | 1.31 | 66.7 | 1.3 | 50900 | 120 | 23 | Bridge region system-wide metrics; improved reliability after substation upgrades. |
| R019 | 289.5 | false | 2022-03-08 | SYS-PLAIN-19 | PLAIN-091 | Plains Rural South | 1.02 | 110.1 | 3.1 | 700 | 36 | 7 | Rural feeder report; severe winter affected restoration times, high CAIDI. |
| R020 | 12500 | true | 2020-12-30 | SYS-URBAN-20 | blank | blank | 900 | 9999 | 10 | 94000 | 900 | 75 | Major urban blackout during winter storm; extreme metrics for testing system response. |
What the 500 rows show
from the 500-row sample- 49%is_
system_ wide = true - 61.3median saidi
- 1.2median saifi
- 49.8median caidi
- 1.2median maifi
- 3,826median customer_
count
Median 61.3, from 0.0 to 12,500.
- string 5
- integer 3
- float 4
- date 1
- boolean 1
Columns
14 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 5 columns | |||
record_id | string | Unique identifier for each reliability metrics recordunique | R001 |
system_id | string | Identifier for the electric system or utility | SYS-MIDLAND-01 |
feeder_id | string | Identifier for the feeder within the system (blank if system-wide)optional | CENTRAL-023 |
feeder_name | string | Name or description of the feeder (blank if system-wide)optional | Central Park West |
notes | string | Additional notes or comments regarding the metrics or data collectionoptional | Annual reliability report… |
| Numbers 7 columns | |||
saidi | float | System Average Interruption Duration Index (minutes per customer per year)0 or more | 78.2 |
saifi | float | System Average Interruption Frequency Index (interruptions per customer per year)0 or more | 1.25 |
caidi | float | Customer Average Interruption Duration Index (average minutes per interruption)0 or more · optional | 62.6 |
maifi | float | Momentary Average Interruption Frequency Index (momentary interruptions per customer per year)0 or more · optional | 1.1 |
customer_count | integer | Number of customers served by the system or feeder0 or more | 32850 |
total_interruptions | integer | Total number of sustained interruptions recorded for the period0 or more · optional | 132 |
total_momentary_interruptions | integer | Total number of momentary interruptions recorded for the period0 or more · optional | 19 |
| Dates and times 1 column | |||
report_date | date | Date when the reliability metrics were calculated or reported | 2023-03-15 |
| True or false 1 column | |||
is_system_wide | boolean | Indicates if the metrics are system-wide (true) or feeder-level (false) | true |
Use it for
An energy dashboard
The is_
system_ wide rate and saidi. Excel, Power BI or Tableau. Why do 247 of 500 rows have is_
system_ wide = true? A class exercise
Hand out the rows and one question. Everyone works from the same 500 rows.
- Records500R00178.2trueR00245.7falseR00364.1true
A software demo
Believable records with report_
date, system_ id and feeder_ id to fill a screen in front of a buyer.
This dataset500 rows14 columns
Yours1,000 rows14 columns
blueprint · saidisaificaidi-reliability-metrics-calculation
Behind this dataset
Same schema. As many rows as you need.
These 500 rows came out of a blueprint — 14 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
- Reporting period: monthly, quarterly, annual
- SAIDI = total customer-minutes of interruption / total customers served
- SAIFI = total customer interruptions / total customers served
- CAIDI = SAIDI / SAIFI (average outage duration per customer affected)
- MAIFI = total customer momentary interruptions / total customers served
- Exclude major event days (MEDs) per IEEE 1366
- Include planned vs. unplanned outages separately
- Feeder-level and system-level aggregation
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
- saidisaificaidi-reliability-metrics-calculation